{ "currentVersion": 11.1, "cimVersion": "3.1.0", "id": 2, "name": "Assessor Building Information", "type": "Table", "description": "", "copyrightText": "", "editFieldsInfo": null, "ownershipBasedAccessControlForFeatures": null, "syncCanReturnChanges": false, "relationships": [ { "id": 1, "name": "SDELOADER.CityBase_AssessorData", "relatedTableId": 1, "cardinality": "esriRelCardinalityOneToMany", "role": "esriRelRoleDestination", "keyField": "PropertyId", "composite": false, "catalogID": "{4324B29E-3DD5-4238-8B0C-972234F087FE}" }, { "id": 2, "name": "SDELOADER.CityBase_AssessorData", "relatedTableId": 1, "cardinality": "esriRelCardinalityOneToMany", "role": "esriRelRoleDestination", "keyField": "PropertyId", "composite": false, "catalogID": "{C774B22E-82A5-4398-B3CF-91468DE34088}" } ], "isDataVersioned": false, "isDataArchived": false, "infoInEstimates": [ "count" ], "isDataBranchVersioned": false, "isDataReplicaTracked": false, "isCoGoEnabled": false, "supportsRollbackOnFailureParameter": true, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportsValidateSQL": true, "supportsCoordinatesQuantization": false, "supportsCalculate": true, "supportsASyncCalculate": true, "advancedQueryCapabilities": { "supportsPagination": true, "supportsTrueCurve": true, "supportsQueryWithDistance": true, "supportsReturningQueryExtent": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsQueryWithResultType": true, "supportsReturningGeometryCentroid": false, "supportsSqlExpression": true, "supportsLod": false, "supportsQueryWithLodSR": false, "supportsQueryAnalytic": true }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": false, "supportsPercentileAnalytic": true }, "advancedEditingCapabilities": { "supportedSqlFormatsInCalculate": [ "standard" ], "supportsAsyncApplyEdits": true, "supportsApplyEditsbyUploadID": true, "supportedApplyEditsUploadIDFormats": "JSON" }, "hasMetadata": true, "hasAttachments": false, "supportsApplyEditsWithGlobalIds": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "objectIdField": "OBJECTID", "globalIdField": "", "displayField": "ZoningCode", "typeIdField": "", "subtypeField": "", "fields": [ { "name": "PropertyId", "type": "esriFieldTypeInteger", "alias": "PropertyId", "domain": null, "editable": true, "nullable": false, "defaultValue": null, "modelName": "PropertyId" }, { "name": "BuildingId", "type": "esriFieldTypeInteger", "alias": "BuildingId", "domain": null, "editable": true, "nullable": false, "defaultValue": null, "modelName": "BuildingId" }, { "name": "BuildingSequence", "type": "esriFieldTypeInteger", "alias": "BuildingSequence", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "BuildingSequence" }, { "name": "ZoningCode", "type": "esriFieldTypeString", "alias": "ZoningCode", "domain": null, "editable": true, "nullable": true, "length": 20, "defaultValue": null, "modelName": "ZoningCode" }, { "name": "ZoningDistrict", "type": "esriFieldTypeString", "alias": "ZoningDistrict", "domain": null, "editable": true, "nullable": true, "length": 200, "defaultValue": null, "modelName": "ZoningDistrict" }, { "name": "LotSize", "type": "esriFieldTypeDouble", "alias": "LotSize", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "LotSize" }, { "name": "LotUnits", "type": "esriFieldTypeString", "alias": "LotUnits", "domain": null, "editable": true, "nullable": true, "length": 200, "defaultValue": null, "modelName": "LotUnits" }, { "name": "YearBuilt", "type": "esriFieldTypeInteger", "alias": "YearBuilt", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "YearBuilt" }, { "name": "FullBaths", "type": "esriFieldTypeInteger", "alias": "FullBaths", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "FullBaths" }, { "name": "HalfBaths", "type": "esriFieldTypeInteger", "alias": "HalfBaths", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "HalfBaths" }, { "name": "TotalRooms", "type": "esriFieldTypeString", "alias": "TotalRooms", "domain": null, "editable": true, "nullable": true, "length": 40, "defaultValue": null, "modelName": "TotalRooms" }, { "name": "Bedrooms", "type": "esriFieldTypeString", "alias": "Bedrooms", "domain": null, "editable": true, "nullable": true, "length": 40, "defaultValue": null, "modelName": "Bedrooms" }, { "name": "HeatType", "type": "esriFieldTypeString", "alias": "HeatType", "domain": null, "editable": true, "nullable": true, "length": 200, "defaultValue": null, "modelName": "HeatType" }, { "name": "HeatFuel", "type": "esriFieldTypeString", "alias": "HeatFuel", "domain": null, "editable": true, "nullable": true, "length": 200, "defaultValue": null, "modelName": "HeatFuel" }, { "name": "CommercialUnits", "type": "esriFieldTypeString", "alias": "CommercialUnits", "domain": null, "editable": true, "nullable": true, "length": 40, "defaultValue": null, "modelName": "CommercialUnits" }, { "name": "ResidentialUnits", "type": "esriFieldTypeString", "alias": "ResidentialUnits", "domain": null, "editable": true, "nullable": true, "length": 40, "defaultValue": null, "modelName": "ResidentialUnits" }, { "name": "BuildingType", "type": "esriFieldTypeString", "alias": "BuildingType", "domain": null, "editable": true, "nullable": true, "length": 200, "defaultValue": null, "modelName": "BuildingType" }, { "name": "Quality", "type": "esriFieldTypeString", "alias": "Quality", "domain": null, "editable": true, "nullable": true, "length": 200, "defaultValue": null, "modelName": "Quality" }, { "name": "DepreciationPct", "type": "esriFieldTypeDouble", "alias": "DepreciationPct", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "DepreciationPct" }, { "name": "PhysicalCondition", "type": "esriFieldTypeString", "alias": "PhysicalCondition", "domain": null, "editable": true, "nullable": true, "length": 200, "defaultValue": null, "modelName": "PhysicalCondition" }, { "name": "FoundationType", "type": "esriFieldTypeString", "alias": "FoundationType", "domain": null, "editable": true, "nullable": true, "length": 200, "defaultValue": null, "modelName": "FoundationType" }, { "name": "StoryHeight", "type": "esriFieldTypeString", "alias": "StoryHeight", "domain": null, "editable": true, "nullable": true, "length": 40, "defaultValue": null, "modelName": "StoryHeight" }, { "name": "CreatedDate", "type": "esriFieldTypeDate", "alias": "CreatedDate", "domain": null, "editable": true, "nullable": false, "length": 8, "defaultValue": null, "modelName": "CreatedDate" }, { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null, "editable": false, "nullable": false, "defaultValue": null, "modelName": "OBJECTID" } ], "indexes": [ { "name": "R3107_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "GDB_45513_Proper", "fields": "PropertyId", "isAscending": true, "isUnique": false, "description": "" }, { "name": "GDB_45513_Buildi", "fields": "BuildingId", "isAscending": true, "isUnique": false, "description": "" } ], "datesInUnknownTimezone": false, "dateFieldsTimeReference": { "timeZone": "Eastern Standard Time", "respectsDaylightSaving": false }, "preferredTimeReference": null, "types": [], "templates": [ { "name": "Assessor Building Information", "description": "", "prototype": { "attributes": { "CreatedDate": -2209161600000, "PropertyId": 0, "BuildingId": 0, "BuildingSequence": null, "ZoningCode": null, "ZoningDistrict": null, "LotSize": null, "LotUnits": null, "YearBuilt": null, "FullBaths": null, "HalfBaths": null, "TotalRooms": null, "Bedrooms": null, "HeatType": null, "HeatFuel": null, "CommercialUnits": null, "ResidentialUnits": null, "BuildingType": null, "Quality": null, "DepreciationPct": null, "PhysicalCondition": null, "FoundationType": null, "StoryHeight": null } }, "drawingTool": "esriFeatureEditToolNone" } ], "maxRecordCount": 8800, "supportedQueryFormats": "JSON, geoJSON, PBF", "supportedExportFormats": "sqlite,filegdb,shapefile,csv,geojson", "capabilities": "Query,Extract", "useStandardizedQueries": true, "standardMaxRecordCount": 32000, "tileMaxRecordCount": 8800, "maxRecordCountFactor": 1, "serviceItemId": "8f26c016d0ba4fb6af7688668a4b6e81" }