{ "preferredTimeReference": { "timeZoneIANA": "America/Chicago", "respectsDaylightSaving": true, "timeZone": "Central Standard Time" }, "useStandardizedQueries": true, "maxRecordCount": 2000, "description": null, "datesInUnknownTimezone": false, "type": "Table", "subtypes": [], "relationships": [{ "keyField": "sPermitNum", "role": "esriRelRoleDestination", "catalogID": "{62BDD418-AD63-46B0-B185-5F8EAE8761A6}", "composite": false, "name": "EnergovHistoricalPermits", "relatedTableId": 2, "id": 4, "cardinality": "esriRelCardinalityOneToMany" }], "indexes": [ { "name": "R1915_SDE_ROWID_UK", "isUnique": true, "description": "", "fields": "OBJECTID", "isAscending": true }, { "name": "GDB_34334_sPermi", "isUnique": false, "description": "", "fields": "sPermitNum", "isAscending": true } ], "htmlPopupType": "esriServerHTMLPopupTypeNone", "cimVersion": "3.6.0", "isDataArchived": true, "id": 4, "archivingInfo": { "startArchivingMoment": 1737976787000, "supportsQueryWithHistoricMoment": true }, "hasAttachments": false, "advancedQueryCapabilities": { "supportsStatistics": true, "supportsSqlExpression": true, "supportsTrueCurve": false, "supportsOrderBy": true, "supportsQueryRelatedPagination": true, "supportsSqlFormat": false, "useStandardizedQueries": true, "supportsQueryWithDistance": true, "supportsCountDistinct": true, "supportsCurrentUserQueries": true, "supportsAdvancedQueryRelated": true, "supportsReturningQueryExtent": true, "supportsPagination": true, "supportsDistinct": true, "supportsTimeRelation": true, "supportsQueryAnalytic": true, "supportsPercentileStatistics": true, "supportsHavingClause": true }, "subtypeField": null, "subtypeFieldName": null, "supportsStatistics": true, "capabilities": "Map,Query,Data", "supportsExceedsLimitStatistics": true, "isDataVersioned": true, "supportsAdvancedQueries": true, "advancedQueryAnalyticCapabilities": { "supportsAsync": false, "supportsLinearRegression": true, "supportsPercentileAnalytic": true }, "hasMetadata": true, "currentVersion": 12, "typeIdField": null, "defaultSubtypeCode": null, "supportedQueryFormats": "JSON, PBF", "name": "EnergovHistoricalContractors", "displayField": "CompanyNam", "copyrightText": null, "fields": [ { "nullable": false, "domain": null, "name": "OBJECTID", "alias": "OBJECTID", "type": "esriFieldTypeOID" }, { "nullable": true, "domain": null, "name": "CompanyNam", "length": 100, "alias": "CompanyNam", "type": "esriFieldTypeString" }, { "nullable": true, "domain": null, "name": "sPhone", "length": 50, "alias": "sPhone", "type": "esriFieldTypeString" }, { "nullable": true, "domain": null, "name": "sContracto", "length": 50, "alias": "sContracto", "type": "esriFieldTypeString" }, { "nullable": true, "domain": null, "name": "sOtherPhon", "length": 50, "alias": "sOtherPhon", "type": "esriFieldTypeString" }, { "nullable": true, "domain": null, "name": "sLName", "length": 100, "alias": "sLName", "type": "esriFieldTypeString" }, { "nullable": true, "domain": null, "name": "sFName", "length": 100, "alias": "sFName", "type": "esriFieldTypeString" }, { "nullable": true, "domain": null, "name": "sComments", "length": 254, "alias": "sComments", "type": "esriFieldTypeString" }, { "nullable": true, "domain": null, "name": "sEmail", "length": 254, "alias": "sEmail", "type": "esriFieldTypeString" }, { "nullable": true, "domain": null, "name": "sFax", "length": 50, "alias": "sFax", "type": "esriFieldTypeString" }, { "nullable": true, "domain": null, "name": "sName", "length": 50, "alias": "sName", "type": "esriFieldTypeString" }, { "nullable": true, "domain": null, "name": "sDescripti", "length": 254, "alias": "sDescripti", "type": "esriFieldTypeString" }, { "nullable": true, "domain": null, "name": "sLicenseNu", "length": 50, "alias": "sLicenseNu", "type": "esriFieldTypeString" }, { "nullable": true, "domain": null, "name": "dtExpDate", "length": 8, "alias": "dtExpDate", "type": "esriFieldTypeDate" }, { "nullable": true, "domain": null, "name": "sComments_", "length": 254, "alias": "sComments_", "type": "esriFieldTypeString" }, { "nullable": true, "domain": null, "name": "sName_1", "length": 50, "alias": "sName_1", "type": "esriFieldTypeString" }, { "nullable": true, "domain": null, "name": "AppDate", "length": 8, "alias": "AppDate", "type": "esriFieldTypeDate" }, { "nullable": true, "domain": null, "name": "ExpDate", "length": 8, "alias": "ExpDate", "type": "esriFieldTypeDate" }, { "nullable": true, "domain": null, "name": "sPermitNum", "length": 50, "alias": "sPermitNum", "type": "esriFieldTypeString" }, { "nullable": true, "domain": null, "name": "dtIssued", "length": 8, "alias": "dtIssued", "type": "esriFieldTypeDate" }, { "nullable": true, "domain": null, "name": "sValue", "length": 50, "alias": "sValue", "type": "esriFieldTypeString" }, { "nullable": true, "domain": null, "name": "sSqFeet", "length": 50, "alias": "sSqFeet", "type": "esriFieldTypeString" }, { "nullable": true, "domain": null, "name": "sComments1", "length": 254, "alias": "sComments1", "type": "esriFieldTypeString" }, { "nullable": true, "domain": null, "name": "sCONumber", "length": 50, "alias": "sCONumber", "type": "esriFieldTypeString" }, { "nullable": true, "domain": null, "name": "dtCOIssued", "length": 8, "alias": "dtCOIssued", "type": "esriFieldTypeDate" }, { "nullable": true, "domain": null, "name": "dtFinaled", "length": 8, "alias": "dtFinaled", "type": "esriFieldTypeDate" }, { "nullable": true, "domain": null, "name": "dtLastInsp", "length": 8, "alias": "dtLastInsp", "type": "esriFieldTypeDate" } ], "dateFieldsTimeReference": { "timeZoneIANA": "America/Chicago", "respectsDaylightSaving": true, "timeZone": "Central Standard Time" } }