{ "currentVersion": 11.4, "cimVersion": "3.4.0", "id": 5, "name": "SingleFamily_PC851SF", "type": "Table", "description": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "APN", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "APN", "type": "esriFieldTypeString", "alias": "APN", "length": 50, "domain": null }, { "name": "BUILDING_NUM", "type": "esriFieldTypeInteger", "alias": "BUILDING_NUM", "domain": null }, { "name": "PROPERTY_TYPE", "type": "esriFieldTypeInteger", "alias": "PROPERTY_TYPE", "domain": null }, { "name": "USE_CODE", "type": "esriFieldTypeInteger", "alias": "USE_CODE", "domain": null }, { "name": "ZONING_CODE", "type": "esriFieldTypeString", "alias": "ZONING_CODE", "length": 255, "domain": null }, { "name": "SPECIAL_PROP_FLG", "type": "esriFieldTypeString", "alias": "SPECIAL_PROP-FLG", "length": 255, "domain": null }, { "name": "DATE_UPDATED", "type": "esriFieldTypeInteger", "alias": "DATE_UPDATED", "domain": null }, { "name": "LAND_ACRES", "type": "esriFieldTypeDouble", "alias": "LAND_ACRES", "domain": null }, { "name": "USABLE_SQ_FEET", "type": "esriFieldTypeInteger", "alias": "USABLE_SQ_FEET", "domain": null }, { "name": "YEAR_BUILT", "type": "esriFieldTypeString", "alias": "YEAR_BUILT", "length": 255, "domain": null }, { "name": "EFFECTIVE_YEAR", "type": "esriFieldTypeString", "alias": "EFFECTIVE_YEAR", "length": 255, "domain": null }, { "name": "TOTAL_ROOMS", "type": "esriFieldTypeString", "alias": "TOTAL_ROOMS", "length": 255, "domain": null }, { "name": "BATH_ROOMS", "type": "esriFieldTypeString", "alias": "BATH_ROOMS", "length": 255, "domain": null }, { "name": "DINING_ROOM", "type": "esriFieldTypeInteger", "alias": "DINING_ROOM", "domain": null }, { "name": "FAMILY_ROOM", "type": "esriFieldTypeInteger", "alias": "FAMILY_ROOM", "domain": null }, { "name": "BEDROOM", "type": "esriFieldTypeInteger", "alias": "BEDROOM", "domain": null }, { "name": "UTILITY_ROOM", "type": "esriFieldTypeInteger", "alias": "UTILITY_ROOM", "domain": null }, { "name": "QUALITY_CLASS", "type": "esriFieldTypeString", "alias": "QUALITY_CLASS", "length": 255, "domain": null }, { "name": "MODEL_NUM", "type": "esriFieldTypeString", "alias": "MODEL_NUM", "length": 255, "domain": null }, { "name": "HEAT_AIR_COND", "type": "esriFieldTypeString", "alias": "HEAT_AIR_COND", "length": 255, "domain": null }, { "name": "GARAGE_PORT", "type": "esriFieldTypeString", "alias": "GARAGE_PORT", "length": 255, "domain": null }, { "name": "PORCH_FLAG", "type": "esriFieldTypeString", "alias": "PORCH_FLAG", "length": 255, "domain": null }, { "name": "PATIO_CODE", "type": "esriFieldTypeString", "alias": "PATIO-CODE", "length": 255, "domain": null }, { "name": "MISC_COSTS", "type": "esriFieldTypeString", "alias": "MISC_COSTS", "length": 255, "domain": null }, { "name": "POOL_SAP_CODE", "type": "esriFieldTypeString", "alias": "POOL_SAP_CODE", "length": 255, "domain": null }, { "name": "HILLSIDE_FLAG", "type": "esriFieldTypeString", "alias": "HILLSIDE_FLAG", "length": 255, "domain": null }, { "name": "TENNIS_FLAG", "type": "esriFieldTypeString", "alias": "TENNIS_FLAG", "length": 255, "domain": null }, { "name": "GARAGE_CONV_FLAG", "type": "esriFieldTypeString", "alias": "GARAGE_CONV_FLAG", "length": 255, "domain": null }, { "name": "EXTRA_KITCHEN", "type": "esriFieldTypeString", "alias": "EXTRA_KITCHEN", "length": 255, "domain": null }, { "name": "EXTRA_PLUMB", "type": "esriFieldTypeString", "alias": "EXTRA_PLUMB", "length": 255, "domain": null }, { "name": "CONDITION_CODE", "type": "esriFieldTypeString", "alias": "CONDITION_CODE", "length": 255, "domain": null }, { "name": "SCREEN_ROOM_FLAG", "type": "esriFieldTypeString", "alias": "SCREEN_ROOM_FLAG", "length": 255, "domain": null }, { "name": "TOTAL_AREA", "type": "esriFieldTypeString", "alias": "TOTAL_AREA", "length": 255, "domain": null }, { "name": "FIRST_FLOOR_AREA", "type": "esriFieldTypeString", "alias": "FIRST_FLOOR_AREA", "length": 255, "domain": null }, { "name": "SECOND_FLR_AREA", "type": "esriFieldTypeString", "alias": "SECOND_FLR_AREA", "length": 255, "domain": null }, { "name": "THIRD_FLOOR_AREA", "type": "esriFieldTypeString", "alias": "THIRD_FLOOR_AREA", "length": 255, "domain": null }, { "name": "BASEMENT_AREA", "type": "esriFieldTypeString", "alias": "BASEMENT_AREA", "length": 255, "domain": null }, { "name": "BASEMENT_FACTOR", "type": "esriFieldTypeString", "alias": "BASEMENT_FACTOR", "length": 255, "domain": null }, { "name": "GARAGE_AREA", "type": "esriFieldTypeString", "alias": "GARAGE_AREA", "length": 255, "domain": null }, { "name": "GARAGE_FACTOR", "type": "esriFieldTypeString", "alias": "GARAGE-FACTOR", "length": 255, "domain": null }, { "name": "ADDITION_AREA", "type": "esriFieldTypeString", "alias": "ADDITION_AREA", "length": 255, "domain": null }, { "name": "ADDITION_FACTOR", "type": "esriFieldTypeString", "alias": "ADDITION_FACTOR", "length": 255, "domain": null }, { "name": "REMARKS", "type": "esriFieldTypeString", "alias": "REMARKS", "length": 255, "domain": null }, { "name": "created_user", "type": "esriFieldTypeString", "alias": "created_user", "length": 255, "domain": null }, { "name": "created_date", "type": "esriFieldTypeDate", "alias": "created_date", "length": 8, "domain": null }, { "name": "last_edited_user", "type": "esriFieldTypeString", "alias": "last_edited_user", "length": 255, "domain": null }, { "name": "last_edited_date", "type": "esriFieldTypeDate", "alias": "last_edited_date", "length": 8, "domain": null } ], "indexes": [ { "name": "R57_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "G467APN", "fields": "APN", "isAscending": true, "isUnique": false, "description": "" } ], "subtypes": [], "relationships": [], "capabilities": "Map,Query,Data", "maxRecordCount": 1000, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON, PBF", "isDataVersioned": true, "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, "supportsAdvancedQueryRelated": true, "supportsQueryRelatedPagination": 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 } }