{ "currentVersion": 11.5, "cimVersion": "3.5.0", "id": 34, "name": "Improvements", "type": "Table", "description": "", "copyrightText": "", "editFieldsInfo": null, "ownershipBasedAccessControlForFeatures": null, "syncCanReturnChanges": false, "relationships": [], "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, "supportsQueryWithDistance": true, "supportsReturningQueryExtent": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsAdvancedQueryRelated": true, "supportsQueryRelatedPagination": true, "supportsCurrentUserQueries": true, "supportsFullTextSearch": true, "fullTextSearchCapabilities": { "supportsSearchOperator": true, "supportsOperator": false, "supportsSqlExpressionInFullText": true }, "fullTextSearchableFields": [], "supportsQueryWithResultType": true, "supportsReturningGeometryCentroid": false, "supportsReturningGeometryEnvelope": false, "supportsSqlExpression": true, "supportsLod": false, "supportsQueryWithLodSR": false, "supportsQueryAnalytic": true, "supportsQueryWithCacheHint": false }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": true, "supportsPercentileAnalytic": true }, "advancedEditingCapabilities": { "supportedSqlFormatsInCalculate": [ "standard" ], "supportsAsyncApplyEdits": true, "supportsApplyEditsbyUploadID": true, "supportedApplyEditsUploadIDFormats": "JSON,PBF" }, "hasMetadata": true, "hasAttachments": false, "supportsApplyEditsWithGlobalIds": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "objectIdField": "OBJECTID", "globalIdField": "", "displayField": "PID", "typeIdField": "", "subtypeField": "", "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null, "editable": false, "nullable": false, "defaultValue": null, "modelName": "OBJECTID" }, { "name": "PID", "type": "esriFieldTypeString", "alias": "PID", "domain": null, "editable": true, "nullable": true, "length": 15, "defaultValue": null, "modelName": "PID" }, { "name": "AccountNumber", "type": "esriFieldTypeString", "alias": "AccountNumber", "domain": null, "editable": true, "nullable": true, "length": 10, "defaultValue": null, "modelName": "AccountNumber" }, { "name": "GPIN", "type": "esriFieldTypeString", "alias": "GPIN", "domain": null, "editable": true, "nullable": false, "length": 20, "defaultValue": null, "modelName": "GPIN" }, { "name": "PARCELID", "type": "esriFieldTypeString", "alias": "PARCELID", "domain": null, "editable": true, "nullable": true, "length": 15, "defaultValue": null, "modelName": "PARCELID" }, { "name": "BID", "type": "esriFieldTypeString", "alias": "BID", "domain": null, "editable": true, "nullable": true, "length": 10, "defaultValue": null, "modelName": "BID" }, { "name": "BUILDINGNUMBER", "type": "esriFieldTypeString", "alias": "BUILDINGNUMBER", "domain": null, "editable": true, "nullable": true, "length": 15, "defaultValue": null, "modelName": "BUILDINGNUMBER" }, { "name": "STORIES", "type": "esriFieldTypeString", "alias": "STORIES", "domain": null, "editable": true, "nullable": true, "length": 15, "defaultValue": null, "modelName": "STORIES" }, { "name": "EXTERIORWALL1", "type": "esriFieldTypeString", "alias": "EXTERIORWALL1", "domain": null, "editable": true, "nullable": true, "length": 100, "defaultValue": null, "modelName": "EXTERIORWALL1" }, { "name": "EXTERIORWALL2", "type": "esriFieldTypeString", "alias": "EXTERIORWALL2", "domain": null, "editable": true, "nullable": true, "length": 100, "defaultValue": null, "modelName": "EXTERIORWALL2" }, { "name": "FOUNDATION", "type": "esriFieldTypeString", "alias": "FOUNDATION", "domain": null, "editable": true, "nullable": true, "length": 100, "defaultValue": null, "modelName": "FOUNDATION" }, { "name": "ROOFCOVER", "type": "esriFieldTypeString", "alias": "ROOFCOVER", "domain": null, "editable": true, "nullable": true, "length": 100, "defaultValue": null, "modelName": "ROOFCOVER" }, { "name": "ROOFTYPE", "type": "esriFieldTypeString", "alias": "ROOFTYPE", "domain": null, "editable": true, "nullable": true, "length": 100, "defaultValue": null, "modelName": "ROOFTYPE" }, { "name": "HEATTYPE", "type": "esriFieldTypeString", "alias": "HEATTYPE", "domain": null, "editable": true, "nullable": true, "length": 100, "defaultValue": null, "modelName": "HEATTYPE" }, { "name": "CENTRALAIR", "type": "esriFieldTypeString", "alias": "CENTRALAIR", "domain": null, "editable": true, "nullable": true, "length": 100, "defaultValue": null, "modelName": "CENTRALAIR" }, { "name": "HEATTYPE2", "type": "esriFieldTypeString", "alias": "HEATTYPE2", "domain": null, "editable": true, "nullable": true, "length": 100, "defaultValue": null, "modelName": "HEATTYPE2" }, { "name": "CENTRALAIR2", "type": "esriFieldTypeString", "alias": "CENTRALAIR2", "domain": null, "editable": true, "nullable": true, "length": 100, "defaultValue": null, "modelName": "CENTRALAIR2" }, { "name": "HEATTYPE3", "type": "esriFieldTypeString", "alias": "HEATTYPE3", "domain": null, "editable": true, "nullable": true, "length": 100, "defaultValue": null, "modelName": "HEATTYPE3" }, { "name": "CENTRALAIR3", "type": "esriFieldTypeString", "alias": "CENTRALAIR3", "domain": null, "editable": true, "nullable": true, "length": 100, "defaultValue": null, "modelName": "CENTRALAIR3" }, { "name": "TOTALROOMS", "type": "esriFieldTypeString", "alias": "TOTALROOMS", "domain": null, "editable": true, "nullable": true, "length": 100, "defaultValue": null, "modelName": "TOTALROOMS" }, { "name": "NUMBERBEDROOMS", "type": "esriFieldTypeString", "alias": "NUMBERBEDROOMS", "domain": null, "editable": true, "nullable": true, "length": 100, "defaultValue": null, "modelName": "NUMBERBEDROOMS" }, { "name": "FULLBATHS", "type": "esriFieldTypeString", "alias": "FULLBATHS", "domain": null, "editable": true, "nullable": true, "length": 100, "defaultValue": null, "modelName": "FULLBATHS" }, { "name": "HALFBATHS", "type": "esriFieldTypeString", "alias": "HALFBATHS", "domain": null, "editable": true, "nullable": true, "length": 100, "defaultValue": null, "modelName": "HALFBATHS" }, { "name": "SINKS", "type": "esriFieldTypeString", "alias": "SINKS", "domain": null, "editable": true, "nullable": true, "length": 100, "defaultValue": null, "modelName": "SINKS" }, { "name": "SHOWERSTALLS", "type": "esriFieldTypeString", "alias": "SHOWERSTALLS", "domain": null, "editable": true, "nullable": true, "length": 100, "defaultValue": null, "modelName": "SHOWERSTALLS" }, { "name": "FIREPLACES", "type": "esriFieldTypeString", "alias": "FIREPLACES", "domain": null, "editable": true, "nullable": true, "length": 100, "defaultValue": null, "modelName": "FIREPLACES" }, { "name": "DORMERS", "type": "esriFieldTypeString", "alias": "DORMERS", "domain": null, "editable": true, "nullable": true, "length": 100, "defaultValue": null, "modelName": "DORMERS" }, { "name": "ATTICFLOOR", "type": "esriFieldTypeString", "alias": "ATTICFLOOR", "domain": null, "editable": true, "nullable": true, "length": 100, "defaultValue": null, "modelName": "ATTICFLOOR" }, { "name": "ATTICSTAIRS", "type": "esriFieldTypeString", "alias": "ATTICSTAIRS", "domain": null, "editable": true, "nullable": true, "length": 100, "defaultValue": null, "modelName": "ATTICSTAIRS" }, { "name": "LIVINGAREA", "type": "esriFieldTypeString", "alias": "LIVINGAREA", "domain": null, "editable": true, "nullable": true, "length": 100, "defaultValue": null, "modelName": "LIVINGAREA" }, { "name": "YEARBUILT", "type": "esriFieldTypeString", "alias": "YEARBUILT", "domain": null, "editable": true, "nullable": true, "length": 100, "defaultValue": null, "modelName": "YEARBUILT" }, { "name": "REMODELCODE", "type": "esriFieldTypeString", "alias": "REMODELCODE", "domain": null, "editable": true, "nullable": true, "length": 100, "defaultValue": null, "modelName": "REMODELCODE" }, { "name": "YEARREMODELED", "type": "esriFieldTypeString", "alias": "YEARREMODELED", "domain": null, "editable": true, "nullable": true, "length": 100, "defaultValue": null, "modelName": "YEARREMODELED" }, { "name": "COMMRSTYLE", "type": "esriFieldTypeString", "alias": "COMMRSTYLE", "domain": null, "editable": true, "nullable": true, "length": 10, "defaultValue": null, "modelName": "COMMRSTYLE" }, { "name": "COMMRSTORIES", "type": "esriFieldTypeString", "alias": "COMMRSTORIES", "domain": null, "editable": true, "nullable": true, "length": 10, "defaultValue": null, "modelName": "COMMRSTORIES" }, { "name": "TOTALAREA", "type": "esriFieldTypeString", "alias": "TOTALAREA", "domain": null, "editable": true, "nullable": true, "length": 10, "defaultValue": null, "modelName": "TOTALAREA" }, { "name": "OCCUPANCY1", "type": "esriFieldTypeString", "alias": "OCCUPANCY1", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "OCCUPANCY1" }, { "name": "OCCUPANCY2", "type": "esriFieldTypeString", "alias": "OCCUPANCY2", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "OCCUPANCY2" }, { "name": "OCCUPANCY3", "type": "esriFieldTypeString", "alias": "OCCUPANCY3", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "OCCUPANCY3" }, { "name": "FRONTWALL1", "type": "esriFieldTypeString", "alias": "FRONTWALL1", "domain": null, "editable": true, "nullable": true, "length": 100, "defaultValue": null, "modelName": "FRONTWALL1" }, { "name": "FRONTWALL2", "type": "esriFieldTypeString", "alias": "FRONTWALL2", "domain": null, "editable": true, "nullable": true, "length": 100, "defaultValue": null, "modelName": "FRONTWALL2" }, { "name": "HVAC1", "type": "esriFieldTypeString", "alias": "HVAC1", "domain": null, "editable": true, "nullable": true, "length": 100, "defaultValue": null, "modelName": "HVAC1" }, { "name": "HVAC2", "type": "esriFieldTypeString", "alias": "HVAC2", "domain": null, "editable": true, "nullable": true, "length": 100, "defaultValue": null, "modelName": "HVAC2" }, { "name": "HVAC3", "type": "esriFieldTypeString", "alias": "HVAC3", "domain": null, "editable": true, "nullable": true, "length": 100, "defaultValue": null, "modelName": "HVAC3" }, { "name": "ELEVATORS", "type": "esriFieldTypeString", "alias": "ELEVATORS", "domain": null, "editable": true, "nullable": true, "length": 100, "defaultValue": null, "modelName": "ELEVATORS" }, { "name": "NUMELEVATORS", "type": "esriFieldTypeString", "alias": "NUMELEVATORS", "domain": null, "editable": true, "nullable": true, "length": 100, "defaultValue": null, "modelName": "NUMELEVATORS" }, { "name": "SPRINKLERS", "type": "esriFieldTypeString", "alias": "SPRINKLERS", "domain": null, "editable": true, "nullable": true, "length": 100, "defaultValue": null, "modelName": "SPRINKLERS" }, { "name": "BasementGarageDoors", "type": "esriFieldTypeString", "alias": "BasementGarageDoors", "domain": null, "editable": true, "nullable": true, "length": 40, "defaultValue": null, "modelName": "BasementGarageDoors" }, { "name": "BasementGarage", "type": "esriFieldTypeString", "alias": "BasementGarage", "domain": null, "editable": true, "nullable": true, "length": 40, "defaultValue": null, "modelName": "BasementGarage" }, { "name": "FinishedBasementPercent", "type": "esriFieldTypeInteger", "alias": "FinishedBasementPercent", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "FinishedBasementPercent" }, { "name": "FoundationConstruction", "type": "esriFieldTypeString", "alias": "FoundationConstruction", "domain": null, "editable": true, "nullable": true, "length": 40, "defaultValue": null, "modelName": "FoundationConstruction" }, { "name": "BuildingClass", "type": "esriFieldTypeString", "alias": "BuildingClass", "domain": null, "editable": true, "nullable": true, "length": 40, "defaultValue": null, "modelName": "BuildingClass" }, { "name": "RESYEARBUILT", "type": "esriFieldTypeString", "alias": "RESYEARBUILT", "domain": null, "editable": true, "nullable": true, "length": 100, "defaultValue": null, "modelName": "RESYEARBUILT" }, { "name": "RESIDENTIALSTYLE", "type": "esriFieldTypeString", "alias": "RESIDENTIALSTYLE", "domain": null, "editable": true, "nullable": true, "length": 100, "defaultValue": null, "modelName": "RESIDENTIALSTYLE" }, { "name": "INTERIORWALL1", "type": "esriFieldTypeString", "alias": "INTERIORWALL1", "domain": null, "editable": true, "nullable": true, "length": 100, "defaultValue": null, "modelName": "INTERIORWALL1" }, { "name": "INTERIORFLOORCOVERING", "type": "esriFieldTypeString", "alias": "INTERIORFLOORCOVERING", "domain": null, "editable": true, "nullable": true, "length": 100, "defaultValue": null, "modelName": "INTERIORFLOORCOVERING" }, { "name": "FIREPLACETYPE", "type": "esriFieldTypeString", "alias": "FIREPLACETYPE", "domain": null, "editable": true, "nullable": true, "length": 100, "defaultValue": null, "modelName": "FIREPLACETYPE" }, { "name": "COMYEARBUILT", "type": "esriFieldTypeString", "alias": "COMYEARBUILT", "domain": null, "editable": true, "nullable": true, "length": 100, "defaultValue": null, "modelName": "COMYEARBUILT" } ], "indexes": [ { "name": "R65_SDE_ROWID_UK", "isAscending": true, "isUnique": true, "description": "", "fields": "OBJECTID" } ], "datesInUnknownTimezone": false, "dateFieldsTimeReference": { "timeZone": "UTC", "timeZoneIANA": "Etc/UTC", "respectsDaylightSaving": false }, "preferredTimeReference": null, "types": [], "templates": [ { "name": "Improvements", "description": "", "prototype": { "attributes": { "FIREPLACETYPE": null, "PID": null, "AccountNumber": null, "GPIN": " ", "PARCELID": null, "BID": null, "BUILDINGNUMBER": null, "STORIES": null, "EXTERIORWALL1": null, "EXTERIORWALL2": null, "FOUNDATION": null, "ROOFCOVER": null, "ROOFTYPE": null, "HEATTYPE": null, "CENTRALAIR": null, "HEATTYPE2": null, "CENTRALAIR2": null, "HEATTYPE3": null, "CENTRALAIR3": null, "TOTALROOMS": null, "NUMBERBEDROOMS": null, "FULLBATHS": null, "HALFBATHS": null, "SINKS": null, "SHOWERSTALLS": null, "FIREPLACES": null, "DORMERS": null, "ATTICFLOOR": null, "ATTICSTAIRS": null, "LIVINGAREA": null, "YEARBUILT": null, "REMODELCODE": null, "YEARREMODELED": null, "COMMRSTYLE": null, "COMMRSTORIES": null, "TOTALAREA": null, "OCCUPANCY1": null, "OCCUPANCY2": null, "OCCUPANCY3": null, "FRONTWALL1": null, "FRONTWALL2": null, "HVAC1": null, "HVAC2": null, "HVAC3": null, "ELEVATORS": null, "NUMELEVATORS": null, "SPRINKLERS": null, "BasementGarageDoors": null, "BasementGarage": null, "FinishedBasementPercent": null, "FoundationConstruction": null, "BuildingClass": null, "RESYEARBUILT": null, "RESIDENTIALSTYLE": null, "INTERIORWALL1": null, "INTERIORFLOORCOVERING": null, "COMYEARBUILT": null } }, "drawingTool": "esriFeatureEditToolNone" } ], "maxRecordCount": 2000, "supportedQueryFormats": "JSON, geoJSON, PBF", "supportedExportFormats": "sqlite,filegdb,shapefile,csv,geojson", "capabilities": "Query", "useStandardizedQueries": true, "bigIntegerRestrictedTo53Bits": true, "supportsAppend": true, "supportedAppendFormats": "FILEGDB,PBF", "standardMaxRecordCount": 32000, "tileMaxRecordCount": 2000, "maxRecordCountFactor": 1 }