{ "currentVersion": 11.2, "cimVersion": "3.2.0", "id": 84, "name": "PermitInspectionsSummary210", "type": "Table", "description": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "StName", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "ParcelNo", "type": "esriFieldTypeString", "alias": "ParcelNo", "length": 255, "domain": null }, { "name": "Map", "type": "esriFieldTypeString", "alias": "Map", "length": 255, "domain": null }, { "name": "Block", "type": "esriFieldTypeString", "alias": "Block", "length": 255, "domain": null }, { "name": "Lot", "type": "esriFieldTypeString", "alias": "Lot", "length": 255, "domain": null }, { "name": "WorkArea", "type": "esriFieldTypeString", "alias": "WorkArea", "length": 255, "domain": null }, { "name": "JobSiteStatus", "type": "esriFieldTypeString", "alias": "JobSiteStatus", "length": 255, "domain": null }, { "name": "PermitType", "type": "esriFieldTypeString", "alias": "PermitType", "length": 255, "domain": null }, { "name": "PermitStatus", "type": "esriFieldTypeString", "alias": "PermitStatus", "length": 255, "domain": null }, { "name": "Permit_Number", "type": "esriFieldTypeString", "alias": "Permit_Number", "length": 255, "domain": null }, { "name": "TrackingNo", "type": "esriFieldTypeString", "alias": "TrackingNo", "length": 255, "domain": null }, { "name": "PermitNo", "type": "esriFieldTypeString", "alias": "PermitNo", "length": 255, "domain": null }, { "name": "InspType", "type": "esriFieldTypeString", "alias": "InspType", "length": 255, "domain": null }, { "name": "InspStatus", "type": "esriFieldTypeString", "alias": "InspStatus", "length": 255, "domain": null }, { "name": "DateInspected", "type": "esriFieldTypeString", "alias": "DateInspected", "length": 255, "domain": null }, { "name": "Comment", "type": "esriFieldTypeString", "alias": "Comment", "length": 255, "domain": null }, { "name": "ApplicantId", "type": "esriFieldTypeString", "alias": "ApplicantId", "length": 255, "domain": null }, { "name": "JobSiteNo", "type": "esriFieldTypeString", "alias": "JobSiteNo", "length": 255, "domain": null }, { "name": "StNo", "type": "esriFieldTypeString", "alias": "StNo", "length": 255, "domain": null }, { "name": "StName", "type": "esriFieldTypeString", "alias": "StName", "length": 255, "domain": null }, { "name": "SubDivName", "type": "esriFieldTypeString", "alias": "SubDivName", "length": 255, "domain": null }, { "name": "Address", "type": "esriFieldTypeString", "alias": "Address", "length": 255, "domain": null }, { "name": "StateCode", "type": "esriFieldTypeString", "alias": "StateCode", "length": 255, "domain": null }, { "name": "District", "type": "esriFieldTypeString", "alias": "District", "length": 255, "domain": null }, { "name": "Zoning", "type": "esriFieldTypeString", "alias": "Zoning", "length": 255, "domain": null }, { "name": "BuilderLot", "type": "esriFieldTypeString", "alias": "BuilderLot", "length": 255, "domain": null }, { "name": "InspectorID", "type": "esriFieldTypeString", "alias": "InspectorID", "length": 255, "domain": null }, { "name": "InspName", "type": "esriFieldTypeString", "alias": "InspName", "length": 255, "domain": null }, { "name": "WorkCategory", "type": "esriFieldTypeString", "alias": "WorkCategory", "length": 255, "domain": null }, { "name": "WorkDesc", "type": "esriFieldTypeString", "alias": "WorkDesc", "length": 255, "domain": null }, { "name": "Owner", "type": "esriFieldTypeString", "alias": "Owner", "length": 255, "domain": null }, { "name": "OwnAddr", "type": "esriFieldTypeString", "alias": "OwnAddr", "length": 255, "domain": null }, { "name": "OwnCity", "type": "esriFieldTypeString", "alias": "OwnCity", "length": 255, "domain": null }, { "name": "OwnState", "type": "esriFieldTypeString", "alias": "OwnState", "length": 255, "domain": null }, { "name": "OwnZip", "type": "esriFieldTypeString", "alias": "OwnZip", "length": 255, "domain": null }, { "name": "Contractor", "type": "esriFieldTypeString", "alias": "Contractor", "length": 255, "domain": null }, { "name": "ContAddr", "type": "esriFieldTypeString", "alias": "ContAddr", "length": 255, "domain": null }, { "name": "ContCity", "type": "esriFieldTypeString", "alias": "ContCity", "length": 255, "domain": null }, { "name": "ContState", "type": "esriFieldTypeString", "alias": "ContState", "length": 255, "domain": null }, { "name": "ContZip", "type": "esriFieldTypeString", "alias": "ContZip", "length": 255, "domain": null }, { "name": "ContPhone", "type": "esriFieldTypeString", "alias": "ContPhone", "length": 255, "domain": null }, { "name": "InspectionId", "type": "esriFieldTypeString", "alias": "InspectionId", "length": 255, "domain": null }, { "name": "ApplicationID", "type": "esriFieldTypeString", "alias": "ApplicationID", "length": 255, "domain": null }, { "name": "YR", "type": "esriFieldTypeString", "alias": "YR", "length": 255, "domain": null }, { "name": "JSYr", "type": "esriFieldTypeString", "alias": "JSYr", "length": 255, "domain": null }, { "name": "PermitNum", "type": "esriFieldTypeString", "alias": "PermitNum", "length": 255, "domain": null }, { "name": "JSNum", "type": "esriFieldTypeString", "alias": "JSNum", "length": 255, "domain": null }, { "name": "Issued", "type": "esriFieldTypeString", "alias": "Issued", "length": 255, "domain": null }, { "name": "PID", "type": "esriFieldTypeString", "alias": "PID", "length": 50, "domain": null }, { "name": "MAP_PAR_ID", "type": "esriFieldTypeString", "alias": "MAP_PAR_ID", "length": 50, "domain": null } ], "indexes": [ { "name": "R438_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "G908PID", "fields": "PID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "G908MAP_PAR_ID", "fields": "MAP_PAR_ID", "isAscending": true, "isUnique": false, "description": "" } ], "subtypes": [], "relationships": [ { "id": 0, "name": "M210TaxPar", "relatedTableId": 90, "role": "esriRelRoleDestination", "keyField": "PID", "cardinality": "esriRelCardinalityOneToMany", "composite": false, "catalogID": "{4F8E9BAB-8BFF-4990-994B-6663F4F1BCFC}" }, { "id": 6, "name": "M210TaxPar", "relatedTableId": 79, "role": "esriRelRoleDestination", "keyField": "PID", "cardinality": "esriRelCardinalityOneToMany", "composite": false, "catalogID": "{4F8E9BAB-8BFF-4990-994B-6663F4F1BCFC}" }, { "id": 12, "name": "M210TaxPar", "relatedTableId": 39, "role": "esriRelRoleDestination", "keyField": "PID", "cardinality": "esriRelCardinalityOneToMany", "composite": false, "catalogID": "{4F8E9BAB-8BFF-4990-994B-6663F4F1BCFC}" }, { "id": 18, "name": "M210TaxPar", "relatedTableId": 87, "role": "esriRelRoleDestination", "keyField": "PID", "cardinality": "esriRelCardinalityOneToMany", "composite": false, "catalogID": "{4F8E9BAB-8BFF-4990-994B-6663F4F1BCFC}" }, { "id": 24, "name": "M210TaxPar", "relatedTableId": 86, "role": "esriRelRoleDestination", "keyField": "PID", "cardinality": "esriRelCardinalityOneToMany", "composite": false, "catalogID": "{4F8E9BAB-8BFF-4990-994B-6663F4F1BCFC}" } ], "capabilities": "Map,Query,Data", "maxRecordCount": 12000, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON, PBF", "isDataVersioned": false, "useStandardizedQueries": true, "advancedQueryCapabilities": { "useStandardizedQueries": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsPagination": true, "supportsTrueCurve": false, "supportsReturningQueryExtent": true, "supportsQueryWithDistance": true, "supportsSqlExpression": true, "supportsTimeRelation": true, "supportsSqlFormat": false, "supportsQueryAnalytic": true, "supportsCurrentUserQueries": true }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": false, "supportsPercentileAnalytic": true }, "dateFieldsTimeReference": null, "preferredTimeReference": null, "datesInUnknownTimezone": false, "hasMetadata": true, "isDataArchived": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 } }