{ "currentVersion": 11.2, "cimVersion": "3.2.0", "id": 83, "name": "ZBASummary210", "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": "JobSiteNo", "type": "esriFieldTypeString", "alias": "JobSiteNo", "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": "ParcelNo", "type": "esriFieldTypeDouble", "alias": "ParcelNo", "domain": null }, { "name": "BuilderLot", "type": "esriFieldTypeString", "alias": "BuilderLot", "length": 255, "domain": null }, { "name": "SubDivName", "type": "esriFieldTypeString", "alias": "SubDivName", "length": 255, "domain": null }, { "name": "StateCode", "type": "esriFieldTypeString", "alias": "StateCode", "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": "esriFieldTypeDouble", "alias": "LotArea", "domain": null }, { "name": "PatsStNo", "type": "esriFieldTypeDouble", "alias": "PatsStNo", "domain": null }, { "name": "FILENO", "type": "esriFieldTypeString", "alias": "FILENO", "length": 255, "domain": null }, { "name": "PlanningStatus", "type": "esriFieldTypeString", "alias": "PlanningStatus", "length": 255, "domain": null }, { "name": "AppType", "type": "esriFieldTypeString", "alias": "AppType", "length": 255, "domain": null }, { "name": "DecisionDate", "type": "esriFieldTypeDate", "alias": "DecisionDate", "length": 8, "domain": null }, { "name": "DateSubmitted", "type": "esriFieldTypeDate", "alias": "DateSubmitted", "length": 8, "domain": null }, { "name": "AcceptedDate", "type": "esriFieldTypeString", "alias": "AcceptedDate", "length": 255, "domain": null }, { "name": "RepresentativeName", "type": "esriFieldTypeString", "alias": "RepresentativeName", "length": 255, "domain": null }, { "name": "ReferenceNo", "type": "esriFieldTypeString", "alias": "ReferenceNo", "length": 255, "domain": null }, { "name": "TrackingNo", "type": "esriFieldTypeString", "alias": "TrackingNo", "length": 255, "domain": null }, { "name": "HearingDeadline", "type": "esriFieldTypeString", "alias": "HearingDeadline", "length": 255, "domain": null }, { "name": "zbastatus", "type": "esriFieldTypeString", "alias": "zbastatus", "length": 255, "domain": null }, { "name": "ExpiresOn", "type": "esriFieldTypeString", "alias": "ExpiresOn", "length": 255, "domain": null }, { "name": "AccDate", "type": "esriFieldTypeString", "alias": "AccDate", "length": 255, "domain": null }, { "name": "SubDate", "type": "esriFieldTypeDate", "alias": "SubDate", "length": 8, "domain": null }, { "name": "Expr1029", "type": "esriFieldTypeString", "alias": "Expr1029", "length": 255, "domain": null }, { "name": "OwnerName", "type": "esriFieldTypeString", "alias": "OwnerName", "length": 255, "domain": null }, { "name": "Actions", "type": "esriFieldTypeString", "alias": "Actions", "length": 255, "domain": null }, { "name": "SurveyorName", "type": "esriFieldTypeString", "alias": "SurveyorName", "length": 255, "domain": null }, { "name": "DecDate", "type": "esriFieldTypeString", "alias": "DecDate", "length": 255, "domain": null }, { "name": "TotFees", "type": "esriFieldTypeDouble", "alias": "TotFees", "domain": null }, { "name": "FilingDeadline", "type": "esriFieldTypeString", "alias": "FilingDeadline", "length": 255, "domain": null }, { "name": "NoticeSentBy", "type": "esriFieldTypeString", "alias": "NoticeSentBy", "length": 255, "domain": null }, { "name": "FirstAdvertising", "type": "esriFieldTypeString", "alias": "FirstAdvertising", "length": 255, "domain": null }, { "name": "SecondAdvertising", "type": "esriFieldTypeString", "alias": "SecondAdvertising", "length": 255, "domain": null }, { "name": "MemberPackage", "type": "esriFieldTypeString", "alias": "MemberPackage", "length": 255, "domain": null }, { "name": "HearingCont", "type": "esriFieldTypeString", "alias": "HearingCont", "length": 255, "domain": null }, { "name": "HearingClose", "type": "esriFieldTypeString", "alias": "HearingClose", "length": 255, "domain": null }, { "name": "VotingDate", "type": "esriFieldTypeString", "alias": "VotingDate", "length": 255, "domain": null }, { "name": "VotingDeadline", "type": "esriFieldTypeString", "alias": "VotingDeadline", "length": 255, "domain": null }, { "name": "DecisionDraftBy", "type": "esriFieldTypeString", "alias": "DecisionDraftBy", "length": 255, "domain": null }, { "name": "FinalSigningBy", "type": "esriFieldTypeString", "alias": "FinalSigningBy", "length": 255, "domain": null }, { "name": "DecisionDeadline", "type": "esriFieldTypeString", "alias": "DecisionDeadline", "length": 255, "domain": null }, { "name": "Appeal", "type": "esriFieldTypeString", "alias": "Appeal", "length": 255, "domain": null }, { "name": "AppealDeadline", "type": "esriFieldTypeString", "alias": "AppealDeadline", "length": 255, "domain": null }, { "name": "Zoning", "type": "esriFieldTypeString", "alias": "Zoning", "length": 255, "domain": null }, { "name": "District", "type": "esriFieldTypeString", "alias": "District", "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": "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": "Surveyor", "type": "esriFieldTypeString", "alias": "Surveyor", "length": 255, "domain": null }, { "name": "SurveyAdd", "type": "esriFieldTypeString", "alias": "SurveyAdd", "length": 255, "domain": null }, { "name": "SurveyCity", "type": "esriFieldTypeString", "alias": "SurveyCity", "length": 255, "domain": null }, { "name": "SurveyState", "type": "esriFieldTypeString", "alias": "SurveyState", "length": 255, "domain": null }, { "name": "SurveyZip", "type": "esriFieldTypeString", "alias": "SurveyZip", "length": 255, "domain": null }, { "name": "AttName", "type": "esriFieldTypeString", "alias": "AttName", "length": 255, "domain": null }, { "name": "AttAdd", "type": "esriFieldTypeString", "alias": "AttAdd", "length": 255, "domain": null }, { "name": "AttCity", "type": "esriFieldTypeString", "alias": "AttCity", "length": 255, "domain": null }, { "name": "AttState", "type": "esriFieldTypeString", "alias": "AttState", "length": 255, "domain": null }, { "name": "AttZip", "type": "esriFieldTypeString", "alias": "AttZip", "length": 255, "domain": null }, { "name": "EngName", "type": "esriFieldTypeString", "alias": "EngName", "length": 255, "domain": null }, { "name": "EngAdd", "type": "esriFieldTypeString", "alias": "EngAdd", "length": 255, "domain": null }, { "name": "EngCity", "type": "esriFieldTypeString", "alias": "EngCity", "length": 255, "domain": null }, { "name": "EngState", "type": "esriFieldTypeString", "alias": "EngState", "length": 255, "domain": null }, { "name": "EngZip", "type": "esriFieldTypeString", "alias": "EngZip", "length": 255, "domain": null }, { "name": "ArcName", "type": "esriFieldTypeString", "alias": "ArcName", "length": 255, "domain": null }, { "name": "ArcAdd", "type": "esriFieldTypeString", "alias": "ArcAdd", "length": 255, "domain": null }, { "name": "ArcCity", "type": "esriFieldTypeString", "alias": "ArcCity", "length": 255, "domain": null }, { "name": "ArcState", "type": "esriFieldTypeString", "alias": "ArcState", "length": 255, "domain": null }, { "name": "ArcZip", "type": "esriFieldTypeString", "alias": "ArcZip", "length": 255, "domain": null }, { "name": "Scity", "type": "esriFieldTypeString", "alias": "Scity", "length": 255, "domain": null }, { "name": "Scsz", "type": "esriFieldTypeString", "alias": "Scsz", "length": 255, "domain": null }, { "name": "Acity", "type": "esriFieldTypeString", "alias": "Acity", "length": 255, "domain": null }, { "name": "Acsz", "type": "esriFieldTypeString", "alias": "Acsz", "length": 255, "domain": null }, { "name": "Ocity", "type": "esriFieldTypeString", "alias": "Ocity", "length": 255, "domain": null }, { "name": "Ocsz", "type": "esriFieldTypeString", "alias": "Ocsz", "length": 255, "domain": null }, { "name": "Attcsz", "type": "esriFieldTypeString", "alias": "Attcsz", "length": 255, "domain": null }, { "name": "Arccsz", "type": "esriFieldTypeString", "alias": "Arccsz", "length": 255, "domain": null }, { "name": "Engcsz", "type": "esriFieldTypeString", "alias": "Engcsz", "length": 255, "domain": null }, { "name": "JobSiteYear", "type": "esriFieldTypeString", "alias": "JobSiteYear", "length": 255, "domain": null }, { "name": "ReferenceNoYear", "type": "esriFieldTypeString", "alias": "ReferenceNoYear", "length": 255, "domain": null }, { "name": "FileNoYear", "type": "esriFieldTypeString", "alias": "FileNoYear", "length": 255, "domain": null }, { "name": "JobSiteNum", "type": "esriFieldTypeString", "alias": "JobSiteNum", "length": 255, "domain": null }, { "name": "ReferenceNum", "type": "esriFieldTypeString", "alias": "ReferenceNum", "length": 255, "domain": null }, { "name": "FileNum", "type": "esriFieldTypeString", "alias": "FileNum", "length": 255, "domain": null }, { "name": "FirstOfComments", "type": "esriFieldTypeString", "alias": "FirstOfComments", "length": 255, "domain": null }, { "name": "FirstOfPlanningComment", "type": "esriFieldTypeString", "alias": "FirstOfPlanningComment", "length": 255, "domain": null }, { "name": "PlanningType", "type": "esriFieldTypeString", "alias": "PlanningType", "length": 255, "domain": null }, { "name": "HearingDate", "type": "esriFieldTypeString", "alias": "HearingDate", "length": 255, "domain": null }, { "name": "DEPNo", "type": "esriFieldTypeString", "alias": "DEPNo", "length": 255, "domain": null }, { "name": "AssignedTo", "type": "esriFieldTypeString", "alias": "AssignedTo", "length": 255, "domain": null }, { "name": "AssignedToName", "type": "esriFieldTypeString", "alias": "AssignedToName", "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": "R439_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "G909PID", "fields": "PID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "G909MAP_PAR_ID", "fields": "MAP_PAR_ID", "isAscending": true, "isUnique": false, "description": "" } ], "subtypes": [], "relationships": [ { "id": 3, "name": "M210TaxPar", "relatedTableId": 90, "role": "esriRelRoleDestination", "keyField": "PID", "cardinality": "esriRelCardinalityOneToMany", "composite": false, "catalogID": "{1A965968-A837-4B5A-A774-DBE8AF3BB978}" }, { "id": 9, "name": "M210TaxPar", "relatedTableId": 79, "role": "esriRelRoleDestination", "keyField": "PID", "cardinality": "esriRelCardinalityOneToMany", "composite": false, "catalogID": "{1A965968-A837-4B5A-A774-DBE8AF3BB978}" }, { "id": 15, "name": "M210TaxPar", "relatedTableId": 39, "role": "esriRelRoleDestination", "keyField": "PID", "cardinality": "esriRelCardinalityOneToMany", "composite": false, "catalogID": "{1A965968-A837-4B5A-A774-DBE8AF3BB978}" }, { "id": 21, "name": "M210TaxPar", "relatedTableId": 87, "role": "esriRelRoleDestination", "keyField": "PID", "cardinality": "esriRelCardinalityOneToMany", "composite": false, "catalogID": "{1A965968-A837-4B5A-A774-DBE8AF3BB978}" }, { "id": 27, "name": "M210TaxPar", "relatedTableId": 86, "role": "esriRelRoleDestination", "keyField": "PID", "cardinality": "esriRelCardinalityOneToMany", "composite": false, "catalogID": "{1A965968-A837-4B5A-A774-DBE8AF3BB978}" }, { "id": 31, "name": "Parcels_M210.DBO.M210Assess", "relatedTableId": 76, "role": "esriRelRoleDestination", "keyField": "MAP_PAR_ID", "cardinality": "esriRelCardinalityOneToMany", "composite": false, "catalogID": "{81EA7925-E5FF-4BD0-8710-F0562B671291}" } ], "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 } }