{ "currentVersion": 10.61, "id": 7, "name": "GDB_PUB.RIVCO.CREST_PROPERTY_CHAR", "type": "Table", "description": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "PIN", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "PIN", "type": "esriFieldTypeString", "alias": "PIN", "length": 32, "domain": null }, { "name": "BUILDING_ID", "type": "esriFieldTypeInteger", "alias": "BUILDING_ID", "domain": null }, { "name": "STREET_SURFACED", "type": "esriFieldTypeString", "alias": "STREET_SURFACED", "length": 32, "domain": null }, { "name": "YEAR_BUILT", "type": "esriFieldTypeInteger", "alias": "YEAR_BUILT", "domain": null }, { "name": "NUMBER_OF_STORIES", "type": "esriFieldTypeInteger", "alias": "NUMBER_OF_STORIES", "domain": null }, { "name": "ROOF_TYPE", "type": "esriFieldTypeString", "alias": "ROOF_TYPE", "length": 64, "domain": null }, { "name": "GARAGE_TYPE", "type": "esriFieldTypeString", "alias": "GARAGE_TYPE", "length": 64, "domain": null }, { "name": "GARAGE_SIZE", "type": "esriFieldTypeDouble", "alias": "GARAGE_SIZE", "domain": null }, { "name": "CARPORT_SIZE", "type": "esriFieldTypeDouble", "alias": "CARPORT_SIZE", "domain": null }, { "name": "HAS_FIREPLACE", "type": "esriFieldTypeString", "alias": "HAS_FIREPLACE", "length": 64, "domain": null }, { "name": "BATH_COUNT", "type": "esriFieldTypeInteger", "alias": "BATH_COUNT", "domain": null }, { "name": "CENTRAL_HEATING", "type": "esriFieldTypeString", "alias": "CENTRAL_HEATING", "length": 64, "domain": null }, { "name": "CENTRAL_COOLING", "type": "esriFieldTypeString", "alias": "CENTRAL_COOLING", "length": 64, "domain": null }, { "name": "DESIGN_TYPE", "type": "esriFieldTypeString", "alias": "DESIGN_TYPE", "length": 64, "domain": null }, { "name": "CONSTRUCTION_TYPE", "type": "esriFieldTypeString", "alias": "CONSTRUCTION_TYPE", "length": 64, "domain": null }, { "name": "QUALITY_CODE", "type": "esriFieldTypeString", "alias": "QUALITY_CODE", "length": 64, "domain": null }, { "name": "SHAPE_CODE", "type": "esriFieldTypeString", "alias": "SHAPE_CODE", "length": 64, "domain": null }, { "name": "LIVING_AREA", "type": "esriFieldTypeDouble", "alias": "LIVING_AREA", "domain": null }, { "name": "ACTUAL_AREA", "type": "esriFieldTypeDouble", "alias": "ACTUAL_AREA", "domain": null }, { "name": "HAS_POOL", "type": "esriFieldTypeString", "alias": "HAS_POOL", "length": 8, "domain": null }, { "name": "BEDROOM_COUNT", "type": "esriFieldTypeInteger", "alias": "BEDROOM_COUNT", "domain": null }, { "name": "FAIRWAY", "type": "esriFieldTypeString", "alias": "FAIRWAY", "length": 64, "domain": null }, { "name": "WATERFRONT", "type": "esriFieldTypeString", "alias": "WATERFRONT", "length": 64, "domain": null } ], "indexes": [ { "name": "R352_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "I798PIN", "fields": "PIN", "isAscending": true, "isUnique": false, "description": "" } ], "subtypes": [], "relationships": [ { "id": 6, "name": "GDB_PUB.RIVCO.PARCELS", "relatedTableId": 0, "role": "esriRelRoleDestination", "keyField": "PIN", "cardinality": "esriRelCardinalityOneToMany", "composite": false } ], "capabilities": "Map,Query,Data", "maxRecordCount": 1000, "supportsStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON, AMF", "isDataVersioned": false, "useStandardizedQueries": true, "advancedQueryCapabilities": { "useStandardizedQueries": true, "supportsStatistics": true, "supportsHavingClause": true, "supportsCountDistinct": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsPagination": true, "supportsTrueCurve": false, "supportsReturningQueryExtent": true, "supportsQueryWithDistance": true, "supportsSqlExpression": true } }