{ "isCoGoEnabled": false, "isDataBranchVersioned": false, "supportsApplyEditsWithGlobalIds": false, "maxRecordCount": 2000, "infoInEstimates": [ "extent", "count" ], "type": "Table", "supportsAttachmentsByUploadId": true, "editingInfo": {"lastEditDate": 1641290458978}, "relationships": [ { "keyField": "propertyid", "role": "esriRelRoleDestination", "composite": false, "name": "Property", "relatedTableId": 0, "id": 0, "cardinality": "esriRelCardinalityOneToMany" } ], "supportsAttachmentsResizing": true, "cimVersion": "2.6.0", "isDataArchived": false, "id": 2, "supportsStatistics": true, "supportedExportFormats": "sqlite,filegdb,shapefile,csv,geojson", "standardMaxRecordCount": 16000, "isDataVersioned": false, "templates": [ { "name": "UnitMix", "description": "", "drawingTool": "esriFeatureEditToolNone", "prototype": { "attributes": { "p_parkingspacesperunit": null, "p_numberofstories": null, "p_zipcode": null, "p_buildingstatus": null, "latitude": null, "p_buildingname": null, "p_countyname": null, "p_yearbuilt": null, "maxmonthlyrent": null, "p_city": null, "minunitsizesqft": null, "p_lastsaledate": null, "maxunitsizesqft": null, "updatedate": -2209161600000, "numbaths": null, "p_buildingratingdesc": null, "p_weightedavgrentpersf": null, "numbeds": 0, "p_avgmonthlyrent": null, "longitude": null, "p_totalunits": null, "p_landareaac": null, "p_yearrenovated": null, "lv_extractdate": null, "p_trueowner": null, "p_amenities": null, "p_lastsaleprice": null, "p_buildingclass": null, "p_avgunitsize": null, "minmonthlyrent": null, "p_submarketname": null, "p_recordedowner": null, "avgunitsizesqft": null, "avgmonthlyrent": null, "numunits": null, "propertyid": 0 } } } ], "supportsAdvancedQueries": true, "currentVersion": 11.4, "advancedEditingCapabilities": { "supportsAsyncApplyEdits": true, "supportsApplyEditsbyUploadID": true, "supportsReturnEditResults": true, "supportedSqlFormatsInCalculate": [ "standard" ], "supportedApplyEditsUploadIDFormats": "JSON,PBF" }, "objectIdField": "objectid", "supportsQuantizationEditMode": true, "name": "UnitMix", "displayField": "p_buildingname", "supportsCalculate": true, "fields": [ { "modelName": "propertyid", "nullable": false, "editable": true, "defaultValue": null, "domain": null, "name": "propertyid", "alias": "PropertyID", "type": "esriFieldTypeInteger" }, { "modelName": "p_trueowner", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "p_trueowner", "length": 2147483647, "alias": "P_TrueOwner", "type": "esriFieldTypeString" }, { "modelName": "p_recordedowner", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "p_recordedowner", "length": 2147483647, "alias": "P_RecordedOwner", "type": "esriFieldTypeString" }, { "modelName": "p_buildingname", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "p_buildingname", "length": 150, "alias": "P_BuildingName", "type": "esriFieldTypeString" }, { "modelName": "p_buildingstatus", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "p_buildingstatus", "length": 20, "alias": "P_BuildingStatus", "type": "esriFieldTypeString" }, { "modelName": "p_buildingclass", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "p_buildingclass", "length": 1, "alias": "P_BuildingClass", "type": "esriFieldTypeString" }, { "modelName": "p_buildingratingdesc", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "p_buildingratingdesc", "length": 30, "alias": "P_BuildingRatingDesc", "type": "esriFieldTypeString" }, { "modelName": "p_landareaac", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "p_landareaac", "alias": "P_LandAreaAC", "type": "esriFieldTypeDouble" }, { "modelName": "p_totalunits", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "p_totalunits", "alias": "P_TotalUnits", "type": "esriFieldTypeInteger" }, { "modelName": "p_avgunitsize", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "p_avgunitsize", "alias": "P_AvgUnitSize", "type": "esriFieldTypeInteger" }, { "modelName": "p_parkingspacesperunit", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "p_parkingspacesperunit", "alias": "P_ParkingSpacesPerUnit", "type": "esriFieldTypeInteger" }, { "modelName": "p_yearbuilt", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "p_yearbuilt", "alias": "P_YearBuilt", "type": "esriFieldTypeInteger" }, { "modelName": "p_yearrenovated", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "p_yearrenovated", "alias": "P_YearRenovated", "type": "esriFieldTypeInteger" }, { "modelName": "p_numberofstories", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "p_numberofstories", "alias": "P_NumberOfStories", "type": "esriFieldTypeInteger" }, { "modelName": "p_amenities", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "p_amenities", "length": 500, "alias": "P_Amenities", "type": "esriFieldTypeString" }, { "modelName": "p_avgmonthlyrent", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "p_avgmonthlyrent", "alias": "P_AvgMonthlyRent", "type": "esriFieldTypeDouble" }, { "modelName": "p_weightedavgrentpersf", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "p_weightedavgrentpersf", "alias": "P_WeightedAvgRentPerSF", "type": "esriFieldTypeDouble" }, { "modelName": "p_submarketname", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "p_submarketname", "length": 40, "alias": "P_SubmarketName", "type": "esriFieldTypeString" }, { "modelName": "p_zipcode", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "p_zipcode", "length": 9, "alias": "P_ZipCode", "type": "esriFieldTypeString" }, { "modelName": "p_city", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "p_city", "length": 30, "alias": "P_City", "type": "esriFieldTypeString" }, { "modelName": "p_countyname", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "p_countyname", "length": 25, "alias": "P_CountyName", "type": "esriFieldTypeString" }, { "modelName": "p_lastsaledate", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "precision": 1, "name": "p_lastsaledate", "length": 29, "alias": "P_LastSaleDate", "type": "esriFieldTypeDate" }, { "modelName": "p_lastsaleprice", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "p_lastsaleprice", "alias": "P_LastSalePrice", "type": "esriFieldTypeDouble" }, { "modelName": "numbeds", "nullable": false, "editable": true, "defaultValue": null, "domain": null, "name": "numbeds", "alias": "NumBeds", "type": "esriFieldTypeInteger" }, { "modelName": "numbaths", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "numbaths", "alias": "NumBaths", "type": "esriFieldTypeDouble" }, { "modelName": "numunits", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "numunits", "alias": "NumUnits", "type": "esriFieldTypeInteger" }, { "modelName": "minunitsizesqft", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "minunitsizesqft", "alias": "MinUnitSizeSqFt", "type": "esriFieldTypeInteger" }, { "modelName": "maxunitsizesqft", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "maxunitsizesqft", "alias": "MaxUnitSizeSqFt", "type": "esriFieldTypeInteger" }, { "modelName": "avgunitsizesqft", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "avgunitsizesqft", "alias": "AvgUnitSizeSqFt", "type": "esriFieldTypeInteger" }, { "modelName": "minmonthlyrent", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "minmonthlyrent", "alias": "MinMonthlyRent", "type": "esriFieldTypeInteger" }, { "modelName": "maxmonthlyrent", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "maxmonthlyrent", "alias": "MaxMonthlyRent", "type": "esriFieldTypeInteger" }, { "modelName": "avgmonthlyrent", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "avgmonthlyrent", "alias": "AvgMonthlyRent", "type": "esriFieldTypeInteger" }, { "modelName": "updatedate", "nullable": false, "editable": true, "defaultValue": null, "domain": null, "precision": 1, "name": "updatedate", "length": 29, "alias": "UpdateDate", "type": "esriFieldTypeDate" }, { "modelName": "latitude", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "latitude", "alias": "Latitude", "type": "esriFieldTypeDouble" }, { "modelName": "longitude", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "longitude", "alias": "Longitude", "type": "esriFieldTypeDouble" }, { "modelName": "lv_extractdate", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "lv_extractdate", "length": 10, "alias": "LV_ExtractDate", "type": "esriFieldTypeString" }, { "modelName": "objectid", "nullable": false, "defaultValue": null, "editable": false, "domain": null, "name": "objectid", "alias": "OBJECTID", "type": "esriFieldTypeOID" } ], "maxRecordCountFactor": 1, "dateFieldsTimeReference": { "timeZoneIANA": "Etc/UTC", "respectsDaylightSaving": false, "timeZone": "UTC" }, "supportsFieldDescriptionProperty": true, "allowGeometryUpdates": true, "useStandardizedQueries": true, "globalIdField": null, "description": "", "syncCanReturnChanges": true, "supportsAsyncDelete": true, "supportedSpatialRelationships": [ "esriSpatialRelIntersects", "esriSpatialRelContains", "esriSpatialRelCrosses", "esriSpatialRelEnvelopeIntersects", "esriSpatialRelOverlaps", "esriSpatialRelTouches", "esriSpatialRelWithin" ], "supportsRollbackOnFailureParameter": true, "isDataReplicaTracked": false, "supportsTruncate": true, "indexes": [ { "name": "g1081propertyid", "isUnique": false, "description": "", "fields": "propertyid", "isAscending": true }, { "name": "i1081numbeds1", "isUnique": false, "description": "", "fields": "numbeds,numbaths,maxunitsizesqft", "isAscending": true }, { "name": "r829_sde_rowid_uk", "isUnique": true, "description": "", "fields": "objectid", "isAscending": true } ], "supportedAppendSourceFilterFormats": "featureService", "editFieldsInfo": null, "htmlPopupType": "esriServerHTMLPopupTypeNone", "GUIDFormat": "O", "hasAttachments": false, "queryBinsCapabilities": { "supportedStatisticTypes": [ "count", "sum", "min", "max", "avg", "stddev", "var", "percentile_cont", "percentile_disc" ], "supportsFixedIntervalBin": true, "supportsAutoIntervalBin": true, "supportsFixedBoundariesBin": true, "supportsDateBin": true }, "advancedQueryCapabilities": { "supportsSqlExpression": true, "supportsQueryWithResultType": true, "supportsQueryRelatedPagination": true, "supportsQueryWithCacheHint": false, "supportsQueryWithDatumTransformation": true, "supportsCurrentUserQueries": true, "supportsQueryAttachmentsWithReturnUrl": true, "supportsDefaultSR": true, "supportsQueryDateBins": false, "supportsQueryWithLodSR": false, "supportsPaginationOnAggregatedQueries": true, "supportsMaxRecordCountFactor": true, "supportsPagination": true, "supportsStatistics": true, "supportsOrderBy": true, "supportsFullTextSearch": true, "supportsLod": false, "supportsSpatialAggregationStatistics": false, "supportsAdvancedQueryRelated": true, "supportsQueryAttachments": true, "supportsQueryAttachmentsCountOnly": true, "supportsReturningQueryExtent": true, "supportsOrderByOnlyOnLayerFields": false, "supportsOutFieldSqlExpression": true, "supportsTopFeaturesQuery": true, "supportsDistinct": true, "supportsQueryAnalytic": true, "supportsPercentileStatistics": true, "supportsHavingClause": true }, "supportsValidateSQL": true, "enableZDefaults": true, "serviceItemId": "801d5c5b7f384f08b70f40e347fde08e", "allowUpdateWithoutMValues": true, "supportsCoordinatesQuantization": true, "types": [], "capabilities": "Query,Extract", "supportsAppend": true, "supportsExceedsLimitStatistics": true, "advancedQueryAnalyticCapabilities": { "supportsAsync": true, "supportsLinearRegression": true, "supportsPercentileAnalytic": false }, "hasMetadata": true, "supportedAppendFormats": "csv,excel,featureCollection,featureService,geojson,jsonl,pbf,shapefile", "tileMaxRecordCount": 4000, "typeIdField": "", "supportsASyncCalculate": true, "supportedQueryFormats": "JSON, geoJSON, PBF", "sqlParserVersion": "PG_11.4.0", "copyrightText": "", "zDefault": 0, "supportsLayerOverrides": true }