{ "currentVersion": 11.2, "cimVersion": "3.2.0", "id": 82, "name": "BuildingPermitData210", "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": "StNo", "type": "esriFieldTypeString", "alias": "StNo", "length": 255, "domain": null }, { "name": "StName", "type": "esriFieldTypeString", "alias": "StName", "length": 255, "domain": null }, { "name": "Address", "type": "esriFieldTypeString", "alias": "Address", "length": 255, "domain": null }, { "name": "SubDivName", "type": "esriFieldTypeString", "alias": "SubDivName", "length": 255, "domain": null }, { "name": "BuilderLot", "type": "esriFieldTypeString", "alias": "BuilderLot", "length": 255, "domain": null }, { "name": "Zoning", "type": "esriFieldTypeString", "alias": "Zoning", "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": "Sewer", "type": "esriFieldTypeString", "alias": "Sewer", "length": 255, "domain": null }, { "name": "Water", "type": "esriFieldTypeString", "alias": "Water", "length": 255, "domain": null }, { "name": "LotArea", "type": "esriFieldTypeString", "alias": "LotArea", "length": 255, "domain": null }, { "name": "PermitType", "type": "esriFieldTypeString", "alias": "PermitType", "length": 255, "domain": null }, { "name": "Status", "type": "esriFieldTypeString", "alias": "Status", "length": 255, "domain": null }, { "name": "PermitNo", "type": "esriFieldTypeString", "alias": "PermitNo", "length": 255, "domain": null }, { "name": "TrackingNo", "type": "esriFieldTypeString", "alias": "TrackingNo", "length": 255, "domain": null }, { "name": "SubDate", "type": "esriFieldTypeDate", "alias": "SubDate", "length": 8, "domain": null }, { "name": "ApprovDate", "type": "esriFieldTypeDate", "alias": "ApprovDate", "length": 8, "domain": null }, { "name": "IssueDate", "type": "esriFieldTypeDate", "alias": "IssueDate", "length": 8, "domain": null }, { "name": "ExpiresOn", "type": "esriFieldTypeDate", "alias": "ExpiresOn", "length": 8, "domain": null }, { "name": "WorkCateg", "type": "esriFieldTypeString", "alias": "WorkCateg", "length": 255, "domain": null }, { "name": "WorkDesc", "type": "esriFieldTypeString", "alias": "WorkDesc", "length": 255, "domain": null }, { "name": "UseGroup", "type": "esriFieldTypeString", "alias": "UseGroup", "length": 255, "domain": null }, { "name": "ConstClass", "type": "esriFieldTypeString", "alias": "ConstClass", "length": 255, "domain": null }, { "name": "Comment", "type": "esriFieldTypeString", "alias": "Comment", "length": 255, "domain": null }, { "name": "CostEst", "type": "esriFieldTypeString", "alias": "CostEst", "length": 255, "domain": null }, { "name": "TotFees", "type": "esriFieldTypeString", "alias": "TotFees", "length": 255, "domain": null }, { "name": "RecptNo", "type": "esriFieldTypeString", "alias": "RecptNo", "length": 255, "domain": null }, { "name": "AssignTo", "type": "esriFieldTypeString", "alias": "AssignTo", "length": 255, "domain": null }, { "name": "FileNo", "type": "esriFieldTypeString", "alias": "FileNo", "length": 255, "domain": null }, { "name": "JobSiteNo", "type": "esriFieldTypeString", "alias": "JobSiteNo", "length": 255, "domain": null }, { "name": "WorkArea", "type": "esriFieldTypeString", "alias": "WorkArea", "length": 255, "domain": null }, { "name": "ProposedUse", "type": "esriFieldTypeString", "alias": "ProposedUse", "length": 255, "domain": null }, { "name": "PropUDet", "type": "esriFieldTypeString", "alias": "PropUDet", "length": 255, "domain": null }, { "name": "UnitsGain", "type": "esriFieldTypeString", "alias": "UnitsGain", "length": 255, "domain": null }, { "name": "UnitsLost", "type": "esriFieldTypeString", "alias": "UnitsLost", "length": 255, "domain": null }, { "name": "Contractor", "type": "esriFieldTypeString", "alias": "Contractor", "length": 255, "domain": null }, { "name": "ContAdd", "type": "esriFieldTypeString", "alias": "ContAdd", "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": "LicType", "type": "esriFieldTypeString", "alias": "LicType", "length": 255, "domain": null }, { "name": "LicNo", "type": "esriFieldTypeString", "alias": "LicNo", "length": 255, "domain": null }, { "name": "InsType", "type": "esriFieldTypeString", "alias": "InsType", "length": 255, "domain": null }, { "name": "InsNumber", "type": "esriFieldTypeString", "alias": "InsNumber", "length": 255, "domain": null }, { "name": "Owner", "type": "esriFieldTypeString", "alias": "Owner", "length": 255, "domain": null }, { "name": "OwnerAdd", "type": "esriFieldTypeString", "alias": "OwnerAdd", "length": 255, "domain": null }, { "name": "OwnerCity", "type": "esriFieldTypeString", "alias": "OwnerCity", "length": 255, "domain": null }, { "name": "OwnerState", "type": "esriFieldTypeString", "alias": "OwnerState", "length": 255, "domain": null }, { "name": "OwnerZip", "type": "esriFieldTypeString", "alias": "OwnerZip", "length": 255, "domain": null }, { "name": "OwnerPhone", "type": "esriFieldTypeString", "alias": "OwnerPhone", "length": 255, "domain": null }, { "name": "Applicant", "type": "esriFieldTypeString", "alias": "Applicant", "length": 255, "domain": null }, { "name": "AppAdd", "type": "esriFieldTypeString", "alias": "AppAdd", "length": 255, "domain": null }, { "name": "AppCity", "type": "esriFieldTypeString", "alias": "AppCity", "length": 255, "domain": null }, { "name": "AppState", "type": "esriFieldTypeString", "alias": "AppState", "length": 255, "domain": null }, { "name": "AppZip", "type": "esriFieldTypeString", "alias": "AppZip", "length": 255, "domain": null }, { "name": "AppPhone", "type": "esriFieldTypeString", "alias": "AppPhone", "length": 255, "domain": null }, { "name": "AppFAX", "type": "esriFieldTypeString", "alias": "AppFAX", "length": 255, "domain": null }, { "name": "ContId", "type": "esriFieldTypeString", "alias": "ContId", "length": 255, "domain": null }, { "name": "ApplId", "type": "esriFieldTypeString", "alias": "ApplId", "length": 255, "domain": null }, { "name": "OwnerId", "type": "esriFieldTypeString", "alias": "OwnerId", "length": 255, "domain": null }, { "name": "InspId", "type": "esriFieldTypeString", "alias": "InspId", "length": 255, "domain": null }, { "name": "CheckNo", "type": "esriFieldTypeString", "alias": "CheckNo", "length": 255, "domain": null }, { "name": "JSYr", "type": "esriFieldTypeString", "alias": "JSYr", "length": 255, "domain": null }, { "name": "JSNum", "type": "esriFieldTypeString", "alias": "JSNum", "length": 255, "domain": null }, { "name": "DatePaid", "type": "esriFieldTypeString", "alias": "DatePaid", "length": 255, "domain": null }, { "name": "YR", "type": "esriFieldTypeString", "alias": "YR", "length": 255, "domain": null }, { "name": "PermitNum", "type": "esriFieldTypeString", "alias": "PermitNum", "length": 255, "domain": null }, { "name": "WorkCategory", "type": "esriFieldTypeString", "alias": "WorkCategory", "length": 255, "domain": null }, { "name": "InspCode", "type": "esriFieldTypeString", "alias": "InspCode", "length": 255, "domain": null }, { "name": "PoleNo", "type": "esriFieldTypeString", "alias": "PoleNo", "length": 255, "domain": null }, { "name": "Service", "type": "esriFieldTypeString", "alias": "Service", "length": 255, "domain": null }, { "name": "Amps", "type": "esriFieldTypeString", "alias": "Amps", "length": 255, "domain": null }, { "name": "Volts", "type": "esriFieldTypeString", "alias": "Volts", "length": 255, "domain": null }, { "name": "NoMeters", "type": "esriFieldTypeString", "alias": "NoMeters", "length": 255, "domain": null }, { "name": "SRENo", "type": "esriFieldTypeString", "alias": "SRENo", "length": 255, "domain": null }, { "name": "LCBY", "type": "esriFieldTypeString", "alias": "LCBY", "length": 255, "domain": null }, { "name": "Fixture_Count", "type": "esriFieldTypeString", "alias": "Fixture_Count", "length": 255, "domain": null }, { "name": "TaxID", "type": "esriFieldTypeString", "alias": "TaxID", "length": 255, "domain": null }, { "name": "Taxes", "type": "esriFieldTypeString", "alias": "Taxes", "length": 255, "domain": null }, { "name": "Fees", "type": "esriFieldTypeString", "alias": "Fees", "length": 255, "domain": null }, { "name": "RedFlag", "type": "esriFieldTypeString", "alias": "RedFlag", "length": 255, "domain": null }, { "name": "YellowFlag", "type": "esriFieldTypeString", "alias": "YellowFlag", "length": 255, "domain": null }, { "name": "Paid", "type": "esriFieldTypeString", "alias": "Paid", "length": 255, "domain": null }, { "name": "InvAmt", "type": "esriFieldTypeString", "alias": "InvAmt", "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 }, { "name": "IssueDate_Format", "type": "esriFieldTypeString", "alias": "IssueDate_Format", "length": 255, "domain": null } ], "indexes": [ { "name": "R426_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "G896PID", "fields": "PID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "G896MAP_PAR_ID", "fields": "MAP_PAR_ID", "isAscending": true, "isUnique": false, "description": "" } ], "subtypes": [], "relationships": [ { "id": 2, "name": "M210TaxPar", "relatedTableId": 90, "role": "esriRelRoleDestination", "keyField": "PID", "cardinality": "esriRelCardinalityOneToMany", "composite": false, "catalogID": "{5DC4E75A-6B9B-4E50-BE5E-D1ED657C8D28}" }, { "id": 8, "name": "M210TaxPar", "relatedTableId": 79, "role": "esriRelRoleDestination", "keyField": "PID", "cardinality": "esriRelCardinalityOneToMany", "composite": false, "catalogID": "{5DC4E75A-6B9B-4E50-BE5E-D1ED657C8D28}" }, { "id": 14, "name": "M210TaxPar", "relatedTableId": 39, "role": "esriRelRoleDestination", "keyField": "PID", "cardinality": "esriRelCardinalityOneToMany", "composite": false, "catalogID": "{5DC4E75A-6B9B-4E50-BE5E-D1ED657C8D28}" }, { "id": 20, "name": "M210TaxPar", "relatedTableId": 87, "role": "esriRelRoleDestination", "keyField": "PID", "cardinality": "esriRelCardinalityOneToMany", "composite": false, "catalogID": "{5DC4E75A-6B9B-4E50-BE5E-D1ED657C8D28}" }, { "id": 26, "name": "M210TaxPar", "relatedTableId": 86, "role": "esriRelRoleDestination", "keyField": "PID", "cardinality": "esriRelCardinalityOneToMany", "composite": false, "catalogID": "{5DC4E75A-6B9B-4E50-BE5E-D1ED657C8D28}" }, { "id": 30, "name": "Parcels_M210.DBO.M210Assess", "relatedTableId": 76, "role": "esriRelRoleDestination", "keyField": "MAP_PAR_ID", "cardinality": "esriRelCardinalityOneToMany", "composite": false, "catalogID": "{3CC6C4FB-6545-4272-8905-3C91B4FE210E}" } ], "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 } }