{ "layers": [ { "currentVersion": 10.61, "id": 0, "name": "PARCELS", "type": "Feature Layer", "description": "Polygon feature class graphically representing taxable parcels of land within Riverside County. This layer is replicated from Assessor's CountyGIS geodatabase.Field information:APN - Assessor's Parcel NumberFLAG - A special designation for the parcel (condos, mobile homes, etc). Update daily, Monday through Friday.", "geometryType": "esriGeometryPolygon", "sourceSpatialReference": { "wkid": 102646, "latestWkid": 2230 }, "copyrightText": "Riverside County Assessor / RCIT", "parentLayer": null, "subLayers": [], "minScale": 50000, "maxScale": 0, "drawingInfo": { "renderer": { "type": "simple", "symbol": { "type": "esriSFS", "style": "esriSFSSolid", "color": [ 0, 0, 0, 0 ], "outline": { "type": "esriSLS", "style": "esriSLSSolid", "color": [ 104, 104, 104, 255 ], "width": 0.7 } }, "label": "", "description": "" }, "transparency": 0, "labelingInfo": null }, "defaultVisibility": true, "extent": { "xmin": 6128715.251304686, "ymin": 2098700.951531768, "xmax": 7111604.311113194, "ymax": 2341310.131010607, "spatialReference": { "wkid": 102646, "latestWkid": 2230 } }, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeAsHTMLText", "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": 9, "domain": null }, { "name": "FLAG", "type": "esriFieldTypeString", "alias": "FLAG", "length": 2, "domain": null }, { "name": "SHAPE", "type": "esriFieldTypeGeometry", "alias": "SHAPE", "domain": null }, { "name": "SHAPE.STArea()", "type": "esriFieldTypeDouble", "alias": "SHAPE.STArea()", "domain": null }, { "name": "SHAPE.STLength()", "type": "esriFieldTypeDouble", "alias": "SHAPE.STLength()", "domain": null } ], "geometryField": { "name": "SHAPE", "type": "esriFieldTypeGeometry", "alias": "SHAPE" }, "indexes": [ { "name": "R163_pk", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "I173APN", "fields": "APN", "isAscending": true, "isUnique": false, "description": "" }, { "name": "S144_idx", "fields": "SHAPE", "isAscending": true, "isUnique": true, "description": "" } ], "subtypes": [], "relationships": [ { "id": 0, "name": "GDB_PUB.RIVCO.ASSESSOR_GENERAL", "relatedTableId": 1, "role": "esriRelRoleOrigin", "keyField": "APN", "cardinality": "esriRelCardinalityOneToMany", "composite": false }, { "id": 1, "name": "GDB_PUB.RIVCO.ASSESSOR_PROPERTY_CHAR", "relatedTableId": 2, "role": "esriRelRoleOrigin", "keyField": "APN", "cardinality": "esriRelCardinalityOneToMany", "composite": false }, { "id": 2, "name": "GDB_PUB.RIVCO.ASSESSOR_RECORDED_BOOK", "relatedTableId": 3, "role": "esriRelRoleOrigin", "keyField": "APN", "cardinality": "esriRelCardinalityOneToMany", "composite": false }, { "id": 3, "name": "GDB_PUB.RIVCO.ASSESSOR_TAXYEAR", "relatedTableId": 4, "role": "esriRelRoleOrigin", "keyField": "APN", "cardinality": "esriRelCardinalityOneToMany", "composite": false }, { "id": 4, "name": "GDB_PUB.RIVCO.ASSESSOR_SALES_DATA", "relatedTableId": 5, "role": "esriRelRoleOrigin", "keyField": "APN", "cardinality": "esriRelCardinalityOneToMany", "composite": false }, { "id": 5, "name": "GDB_PUB.RIVCO.CREST_GENERAL", "relatedTableId": 6, "role": "esriRelRoleOrigin", "keyField": "APN", "cardinality": "esriRelCardinalityOneToMany", "composite": false }, { "id": 6, "name": "GDB_PUB.RIVCO.CREST_PROPERTY_CHAR", "relatedTableId": 7, "role": "esriRelRoleOrigin", "keyField": "APN", "cardinality": "esriRelCardinalityOneToMany", "composite": false }, { "id": 7, "name": "GDB_PUB.RIVCO.CREST_RECORDED_BOOK", "relatedTableId": 8, "role": "esriRelRoleOrigin", "keyField": "APN", "cardinality": "esriRelCardinalityOneToMany", "composite": false }, { "id": 8, "name": "GDB_PUB.RIVCO.CREST_TAXYEAR", "relatedTableId": 9, "role": "esriRelRoleOrigin", "keyField": "APN", "cardinality": "esriRelCardinalityOneToMany", "composite": false }, { "id": 9, "name": "GDB_PUB.RIVCO.CREST_ASSESSEE", "relatedTableId": 10, "role": "esriRelRoleOrigin", "keyField": "APN", "cardinality": "esriRelCardinalityOneToMany", "composite": false } ], "canModifyLayer": false, "canScaleSymbols": false, "hasLabels": false, "capabilities": "Map,Query,Data", "maxRecordCount": 1000, "supportsStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON, AMF, geoJSON", "isDataVersioned": false, "ownershipBasedAccessControlForFeatures": {"allowOthersToQuery": true}, "useStandardizedQueries": true, "advancedQueryCapabilities": { "useStandardizedQueries": true, "supportsStatistics": true, "supportsHavingClause": true, "supportsCountDistinct": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsPagination": true, "supportsTrueCurve": true, "supportsReturningQueryExtent": true, "supportsQueryWithDistance": true, "supportsSqlExpression": true }, "supportsDatumTransformation": true, "supportsCoordinatesQuantization": true } ], "tables": [ { "currentVersion": 10.61, "id": 1, "name": "ASSESSOR_GENERAL", "type": "Table", "description": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "MAIL_TO_NAME", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "ASMT", "type": "esriFieldTypeString", "alias": "ASMT", "length": 9, "domain": null }, { "name": "CHKDIGIT", "type": "esriFieldTypeString", "alias": "CHKDIGIT", "length": 1, "domain": null }, { "name": "CLUSTER_NUMBER", "type": "esriFieldTypeInteger", "alias": "CLUSTER_NUMBER", "domain": null }, { "name": "APN", "type": "esriFieldTypeString", "alias": "APN", "length": 9, "domain": null }, { "name": "VCC1_CD", "type": "esriFieldTypeString", "alias": "VCC1_CD", "length": 1, "domain": null }, { "name": "APPR1_ID", "type": "esriFieldTypeInteger", "alias": "APPR1_ID", "domain": null }, { "name": "DOLA1_DATE", "type": "esriFieldTypeString", "alias": "DOLA1_DATE", "length": 10, "domain": null }, { "name": "VCC2_CD", "type": "esriFieldTypeString", "alias": "VCC2_CD", "length": 1, "domain": null }, { "name": "APPR2_ID", "type": "esriFieldTypeInteger", "alias": "APPR2_ID", "domain": null }, { "name": "DOLA2_DATE", "type": "esriFieldTypeString", "alias": "DOLA2_DATE", "length": 10, "domain": null }, { "name": "VCC3_CD", "type": "esriFieldTypeString", "alias": "VCC3_CD", "length": 1, "domain": null }, { "name": "APPR3_ID", "type": "esriFieldTypeInteger", "alias": "APPR3_ID", "domain": null }, { "name": "DOLA3_DATE", "type": "esriFieldTypeString", "alias": "DOLA3_DATE", "length": 10, "domain": null }, { "name": "VCC4_CD", "type": "esriFieldTypeString", "alias": "VCC4_CD", "length": 1, "domain": null }, { "name": "APPR4_ID", "type": "esriFieldTypeInteger", "alias": "APPR4_ID", "domain": null }, { "name": "DOLA4_DATE", "type": "esriFieldTypeString", "alias": "DOLA4_DATE", "length": 10, "domain": null }, { "name": "BASE_YEAR", "type": "esriFieldTypeInteger", "alias": "BASE_YEAR", "domain": null }, { "name": "BASE_YR_MFLAG", "type": "esriFieldTypeString", "alias": "BASE_YR_MFLAG", "length": 1, "domain": null }, { "name": "REAL_USE_PID", "type": "esriFieldTypeString", "alias": "REAL_USE_PID", "length": 2, "domain": null }, { "name": "PC_FLAG", "type": "esriFieldTypeString", "alias": "PC_FLAG", "length": 1, "domain": null }, { "name": "ASSESMNT_DESC", "type": "esriFieldTypeString", "alias": "ASSESMNT_DESC", "length": 50, "domain": null }, { "name": "MAIL_TO_NAME", "type": "esriFieldTypeString", "alias": "MAIL_TO_NAME", "length": 43, "domain": null }, { "name": "MAIL_TO_STREET", "type": "esriFieldTypeString", "alias": "MAIL_TO_STREET", "length": 37, "domain": null }, { "name": "MAIL_TO_CITY", "type": "esriFieldTypeString", "alias": "MAIL_TO_CITY", "length": 31, "domain": null }, { "name": "MAIL_TO_ZIP", "type": "esriFieldTypeInteger", "alias": "MAIL_TO_ZIP", "domain": null }, { "name": "SITUS_STREET", "type": "esriFieldTypeString", "alias": "SITUS_STREET", "length": 18, "domain": null }, { "name": "SITUS_SUFFIX", "type": "esriFieldTypeString", "alias": "SITUS_SUFFIX", "length": 3, "domain": null }, { "name": "SITUS_DIR", "type": "esriFieldTypeString", "alias": "SITUS_DIR", "length": 1, "domain": null }, { "name": "SITUS_HOUSE_NO", "type": "esriFieldTypeInteger", "alias": "SITUS_HOUSE_NO", "domain": null }, { "name": "SITUS_HOUSE_SUF", "type": "esriFieldTypeInteger", "alias": "SITUS_HOUSE_SUF", "domain": null }, { "name": "SITUS_UNIT", "type": "esriFieldTypeString", "alias": "SITUS_UNIT", "length": 4, "domain": null }, { "name": "SITUS_CITY", "type": "esriFieldTypeString", "alias": "SITUS_CITY", "length": 26, "domain": null }, { "name": "SITUS_ZIP", "type": "esriFieldTypeInteger", "alias": "SITUS_ZIP", "domain": null }, { "name": "PRIMARY_CODE", "type": "esriFieldTypeString", "alias": "PRIMARY_CODE", "length": 1, "domain": null }, { "name": "SECONDARY_CODE", "type": "esriFieldTypeInteger", "alias": "SECONDARY_CODE", "domain": null }, { "name": "NUM_OF_UNITS", "type": "esriFieldTypeInteger", "alias": "NUM_OF_UNITS", "domain": null }, { "name": "MULTIPLE_CODE", "type": "esriFieldTypeString", "alias": "MULTIPLE_CODE", "length": 1, "domain": null }, { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null } ], "indexes": [ { "name": "R33_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "I38SITUS_ZIP", "fields": "SITUS_ZIP", "isAscending": true, "isUnique": false, "description": "" }, { "name": "I38ASMT", "fields": "ASMT", "isAscending": true, "isUnique": false, "description": "" }, { "name": "I38APN", "fields": "APN", "isAscending": true, "isUnique": false, "description": "" }, { "name": "I38SITUS_CITY", "fields": "SITUS_CITY", "isAscending": true, "isUnique": false, "description": "" }, { "name": "I38MAIL_TO_ZIP", "fields": "MAIL_TO_ZIP", "isAscending": true, "isUnique": false, "description": "" }, { "name": "I38MAIL_TO_CITY", "fields": "MAIL_TO_CITY", "isAscending": true, "isUnique": false, "description": "" }, { "name": "I38MAIL_TO_STREE", "fields": "MAIL_TO_STREET", "isAscending": true, "isUnique": false, "description": "" }, { "name": "I38SITUS_HOUSE_N", "fields": "SITUS_HOUSE_NO", "isAscending": true, "isUnique": false, "description": "" }, { "name": "I38MAIL_TO_NAME", "fields": "MAIL_TO_NAME", "isAscending": true, "isUnique": false, "description": "" }, { "name": "I38SITUS_SUFFIX", "fields": "SITUS_SUFFIX", "isAscending": true, "isUnique": false, "description": "" }, { "name": "I38SITUS_STREET", "fields": "SITUS_STREET", "isAscending": true, "isUnique": false, "description": "" }, { "name": "I38SECONDARY_COD", "fields": "SECONDARY_CODE", "isAscending": true, "isUnique": false, "description": "" }, { "name": "I38PRIMARY_CODE", "fields": "PRIMARY_CODE", "isAscending": true, "isUnique": false, "description": "" } ], "subtypes": [], "relationships": [ { "id": 0, "name": "GDB_PUB.RIVCO.PARCELS", "relatedTableId": 0, "role": "esriRelRoleDestination", "keyField": "ASMT", "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 } }, { "currentVersion": 10.61, "id": 2, "name": "ASSESSOR_PROPERTY_CHAR", "type": "Table", "description": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "ASMT", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "ASMT", "type": "esriFieldTypeString", "alias": "ASMT", "length": 9, "domain": null }, { "name": "SHEET_NBR", "type": "esriFieldTypeInteger", "alias": "SHEET_NBR", "domain": null }, { "name": "STREET_SURFACED", "type": "esriFieldTypeString", "alias": "STREET_SURFACED", "length": 1, "domain": null }, { "name": "YEAR_EST_IND", "type": "esriFieldTypeString", "alias": "YEAR_EST_IND", "length": 1, "domain": null }, { "name": "YEAR_CONSTRUCTED", "type": "esriFieldTypeString", "alias": "YEAR_CONSTRUCTED", "length": 4, "domain": null }, { "name": "NBR_STORIES", "type": "esriFieldTypeString", "alias": "NBR_STORIES", "length": 1, "domain": null }, { "name": "ROOF_TYPE", "type": "esriFieldTypeString", "alias": "ROOF_TYPE", "length": 1, "domain": null }, { "name": "GARAGE1_TYPE", "type": "esriFieldTypeString", "alias": "GARAGE1_TYPE", "length": 1, "domain": null }, { "name": "GARAGE1_AREA", "type": "esriFieldTypeInteger", "alias": "GARAGE1_AREA", "domain": null }, { "name": "CARPORT1_AREA", "type": "esriFieldTypeInteger", "alias": "CARPORT1_AREA", "domain": null }, { "name": "GARAGE2_TYPE", "type": "esriFieldTypeString", "alias": "GARAGE2_TYPE", "length": 1, "domain": null }, { "name": "GARAGE2_AREA", "type": "esriFieldTypeInteger", "alias": "GARAGE2_AREA", "domain": null }, { "name": "CARPORT2_AREA", "type": "esriFieldTypeInteger", "alias": "CARPORT2_AREA", "domain": null }, { "name": "FIREPLACE_FLAG", "type": "esriFieldTypeString", "alias": "FIREPLACE_FLAG", "length": 1, "domain": null }, { "name": "FIREPLACE_VALUE", "type": "esriFieldTypeInteger", "alias": "FIREPLACE_VALUE", "domain": null }, { "name": "BATHS", "type": "esriFieldTypeSingle", "alias": "BATHS", "domain": null }, { "name": "CENTRAL_HEAT", "type": "esriFieldTypeString", "alias": "CENTRAL_HEAT", "length": 1, "domain": null }, { "name": "CENTRAL_COOL", "type": "esriFieldTypeString", "alias": "CENTRAL_COOL", "length": 1, "domain": null }, { "name": "DESIGN_TYPE", "type": "esriFieldTypeSingle", "alias": "DESIGN_TYPE", "domain": null }, { "name": "CONST_TYPE", "type": "esriFieldTypeString", "alias": "CONST_TYPE", "length": 1, "domain": null }, { "name": "STR_QUAL_CD", "type": "esriFieldTypeSingle", "alias": "STR_QUAL_CD", "domain": null }, { "name": "STR_SHAPE_CD", "type": "esriFieldTypeString", "alias": "STR_SHAPE_CD", "length": 1, "domain": null }, { "name": "AREA_1", "type": "esriFieldTypeInteger", "alias": "AREA_1", "domain": null }, { "name": "TOTAL_AREA", "type": "esriFieldTypeInteger", "alias": "TOTAL_AREA", "domain": null }, { "name": "CARPET_GARAGE", "type": "esriFieldTypeString", "alias": "CARPET_GARAGE", "length": 1, "domain": null }, { "name": "POOL", "type": "esriFieldTypeString", "alias": "POOL", "length": 1, "domain": null }, { "name": "BEDROOMS", "type": "esriFieldTypeInteger", "alias": "BEDROOMS", "domain": null }, { "name": "MISC_STR_RCLD", "type": "esriFieldTypeInteger", "alias": "MISC_STR_RCLD", "domain": null }, { "name": "TOT_RCLD", "type": "esriFieldTypeInteger", "alias": "TOT_RCLD", "domain": null }, { "name": "WTR_FAIR", "type": "esriFieldTypeString", "alias": "WTR_FAIR", "length": 1, "domain": null } ], "indexes": [ { "name": "R36_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "I41ASMT", "fields": "ASMT", "isAscending": true, "isUnique": false, "description": "" } ], "subtypes": [], "relationships": [ { "id": 1, "name": "GDB_PUB.RIVCO.PARCELS", "relatedTableId": 0, "role": "esriRelRoleDestination", "keyField": "ASMT", "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 } }, { "currentVersion": 10.61, "id": 3, "name": "ASSESSOR_RECORDED_BOOK", "type": "Table", "description": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "SUBDIV_NAME", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "ASMT", "type": "esriFieldTypeString", "alias": "ASMT", "length": 9, "domain": null }, { "name": "TRACT_NUMBER", "type": "esriFieldTypeInteger", "alias": "TRACT_NUMBER", "domain": null }, { "name": "ACRE", "type": "esriFieldTypeSingle", "alias": "ACRE", "domain": null }, { "name": "RECORDERS_TYPE", "type": "esriFieldTypeString", "alias": "RECORDERS_TYPE", "length": 2, "domain": null }, { "name": "BOOK", "type": "esriFieldTypeInteger", "alias": "BOOK", "domain": null }, { "name": "PAGE", "type": "esriFieldTypeInteger", "alias": "PAGE", "domain": null }, { "name": "COUNTY_CODE", "type": "esriFieldTypeString", "alias": "COUNTY_CODE", "length": 2, "domain": null }, { "name": "LOT_TYPE", "type": "esriFieldTypeString", "alias": "LOT_TYPE", "length": 1, "domain": null }, { "name": "LOT", "type": "esriFieldTypeString", "alias": "LOT", "length": 4, "domain": null }, { "name": "BLOCK_NUMBER", "type": "esriFieldTypeString", "alias": "BLOCK_NUMBER", "length": 3, "domain": null }, { "name": "PORTIONAL_FLAG", "type": "esriFieldTypeString", "alias": "PORTIONAL_FLAG", "length": 1, "domain": null }, { "name": "SUBDIV_NAME", "type": "esriFieldTypeString", "alias": "SUBDIV_NAME", "length": 48, "domain": null }, { "name": "POR_SEC_LAND_1", "type": "esriFieldTypeString", "alias": "POR_SEC_LAND_1", "length": 2, "domain": null }, { "name": "SECTION_NUMBER_1", "type": "esriFieldTypeInteger", "alias": "SECTION_NUMBER_1", "domain": null }, { "name": "TOWNSHIP_1", "type": "esriFieldTypeInteger", "alias": "TOWNSHIP_1", "domain": null }, { "name": "RANGE_1", "type": "esriFieldTypeInteger", "alias": "RANGE_1", "domain": null }, { "name": "RANGE_DIR_1", "type": "esriFieldTypeString", "alias": "RANGE_DIR_1", "length": 1, "domain": null }, { "name": "POR_SEC_LAND_2", "type": "esriFieldTypeString", "alias": "POR_SEC_LAND_2", "length": 2, "domain": null }, { "name": "SECTION_NUMBER_2", "type": "esriFieldTypeInteger", "alias": "SECTION_NUMBER_2", "domain": null }, { "name": "TOWNSHIP_2", "type": "esriFieldTypeInteger", "alias": "TOWNSHIP_2", "domain": null }, { "name": "RANGE_2", "type": "esriFieldTypeInteger", "alias": "RANGE_2", "domain": null }, { "name": "RANGE_DIR_2", "type": "esriFieldTypeString", "alias": "RANGE_DIR_2", "length": 1, "domain": null }, { "name": "CAME_FROM", "type": "esriFieldTypeString", "alias": "CAME_FROM", "length": 9, "domain": null }, { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null } ], "indexes": [ { "name": "R37_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "I42ACRE", "fields": "ACRE", "isAscending": true, "isUnique": false, "description": "" }, { "name": "I42ASMT", "fields": "ASMT", "isAscending": true, "isUnique": false, "description": "" }, { "name": "I42BLOCK_NUMBER", "fields": "BLOCK_NUMBER", "isAscending": true, "isUnique": false, "description": "" }, { "name": "I42BOOK", "fields": "BOOK", "isAscending": true, "isUnique": false, "description": "" }, { "name": "I42LOT", "fields": "LOT", "isAscending": true, "isUnique": false, "description": "" }, { "name": "I42PAGE", "fields": "PAGE", "isAscending": true, "isUnique": false, "description": "" }, { "name": "I42RECORDERS_TYP", "fields": "RECORDERS_TYPE", "isAscending": true, "isUnique": false, "description": "" }, { "name": "I42SUBDIV_NAME", "fields": "SUBDIV_NAME", "isAscending": true, "isUnique": false, "description": "" }, { "name": "I42TRACT_NUMBER", "fields": "TRACT_NUMBER", "isAscending": true, "isUnique": false, "description": "" } ], "subtypes": [], "relationships": [ { "id": 2, "name": "GDB_PUB.RIVCO.PARCELS", "relatedTableId": 0, "role": "esriRelRoleDestination", "keyField": "ASMT", "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 } }, { "currentVersion": 10.61, "id": 4, "name": "ASSESSOR_TAXYEAR", "type": "Table", "description": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "ASMT", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "ASMT", "type": "esriFieldTypeString", "alias": "ASMT", "length": 9, "domain": null }, { "name": "TAXYEAR", "type": "esriFieldTypeInteger", "alias": "TAXYEAR", "domain": null }, { "name": "TAXABILITY_CD", "type": "esriFieldTypeInteger", "alias": "TAXABILITY_CD", "domain": null }, { "name": "PRIMARY_TRA", "type": "esriFieldTypeString", "alias": "PRIMARY_TRA", "length": 3, "domain": null }, { "name": "TRA", "type": "esriFieldTypeString", "alias": "TRA", "length": 6, "domain": null }, { "name": "LAND", "type": "esriFieldTypeInteger", "alias": "LAND", "domain": null }, { "name": "STRUCTURE", "type": "esriFieldTypeInteger", "alias": "STRUCTURE", "domain": null }, { "name": "TRADE_FIXTURE", "type": "esriFieldTypeInteger", "alias": "TRADE_FIXTURE", "domain": null }, { "name": "TREE_VINE", "type": "esriFieldTypeInteger", "alias": "TREE_VINE", "domain": null }, { "name": "CITRUS_PEST", "type": "esriFieldTypeInteger", "alias": "CITRUS_PEST", "domain": null }, { "name": "BUS_PERS_PROP", "type": "esriFieldTypeInteger", "alias": "BUS_PERS_PROP", "domain": null }, { "name": "BOAT", "type": "esriFieldTypeInteger", "alias": "BOAT", "domain": null }, { "name": "AIRCRAFT", "type": "esriFieldTypeInteger", "alias": "AIRCRAFT", "domain": null }, { "name": "PENALTY10", "type": "esriFieldTypeInteger", "alias": "PENALTY10", "domain": null }, { "name": "PENALTY25", "type": "esriFieldTypeInteger", "alias": "PENALTY25", "domain": null }, { "name": "HOMEOWNERS_EXMPT", "type": "esriFieldTypeInteger", "alias": "HOMEOWNERS_EXMPT", "domain": null }, { "name": "VETERAN", "type": "esriFieldTypeInteger", "alias": "VETERAN", "domain": null }, { "name": "DISABLE_VET", "type": "esriFieldTypeInteger", "alias": "DISABLE_VET", "domain": null }, { "name": "CHURCH", "type": "esriFieldTypeInteger", "alias": "CHURCH", "domain": null }, { "name": "RELIGIOUS", "type": "esriFieldTypeInteger", "alias": "RELIGIOUS", "domain": null }, { "name": "CEMETERY", "type": "esriFieldTypeInteger", "alias": "CEMETERY", "domain": null }, { "name": "SCHOOL", "type": "esriFieldTypeInteger", "alias": "SCHOOL", "domain": null }, { "name": "LIBRARY", "type": "esriFieldTypeInteger", "alias": "LIBRARY", "domain": null }, { "name": "MUSEUM", "type": "esriFieldTypeInteger", "alias": "MUSEUM", "domain": null }, { "name": "COLLAGE", "type": "esriFieldTypeInteger", "alias": "COLLAGE", "domain": null }, { "name": "HOSPITAL", "type": "esriFieldTypeInteger", "alias": "HOSPITAL", "domain": null }, { "name": "PRIVATE_SCHOOL", "type": "esriFieldTypeInteger", "alias": "PRIVATE_SCHOOL", "domain": null }, { "name": "CHARITY", "type": "esriFieldTypeInteger", "alias": "CHARITY", "domain": null }, { "name": "OTHER", "type": "esriFieldTypeInteger", "alias": "OTHER", "domain": null }, { "name": "EXEMPT_TYPE1", "type": "esriFieldTypeInteger", "alias": "EXEMPT_TYPE1", "domain": null }, { "name": "EXEMPT_AMOUNT1", "type": "esriFieldTypeInteger", "alias": "EXEMPT_AMOUNT1", "domain": null }, { "name": "EXEMPT_TYPE2", "type": "esriFieldTypeInteger", "alias": "EXEMPT_TYPE2", "domain": null }, { "name": "EXEMPT_AMOUNT2", "type": "esriFieldTypeInteger", "alias": "EXEMPT_AMOUNT2", "domain": null }, { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null } ], "indexes": [ { "name": "R40_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "I45ASMT", "fields": "ASMT", "isAscending": true, "isUnique": false, "description": "" }, { "name": "I45BUS_PERS_PROP", "fields": "BUS_PERS_PROP", "isAscending": true, "isUnique": false, "description": "" }, { "name": "I45STRUCTURE", "fields": "STRUCTURE", "isAscending": true, "isUnique": false, "description": "" }, { "name": "I45TRADE_FIXTURE", "fields": "TRADE_FIXTURE", "isAscending": true, "isUnique": false, "description": "" }, { "name": "I45TREE_VINE", "fields": "TREE_VINE", "isAscending": true, "isUnique": false, "description": "" }, { "name": "I45TAXABILITY_CD", "fields": "TAXABILITY_CD", "isAscending": true, "isUnique": false, "description": "" }, { "name": "I45TAXYEAR", "fields": "TAXYEAR", "isAscending": true, "isUnique": false, "description": "" } ], "subtypes": [], "relationships": [ { "id": 3, "name": "GDB_PUB.RIVCO.PARCELS", "relatedTableId": 0, "role": "esriRelRoleDestination", "keyField": "ASMT", "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 } }, { "currentVersion": 10.61, "id": 5, "name": "ASSESSOR_SALES_DATA", "type": "Table", "description": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "ASMT", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "ASMT", "type": "esriFieldTypeString", "alias": "ASMT", "length": 9, "domain": null }, { "name": "CNT", "type": "esriFieldTypeInteger", "alias": "CNT", "domain": null }, { "name": "CONV_DATE", "type": "esriFieldTypeDate", "alias": "CONV_DATE", "length": 8, "domain": null }, { "name": "CONV_TYPE_CD", "type": "esriFieldTypeInteger", "alias": "CONV_TYPE_CD", "domain": null }, { "name": "CONV_SEQ", "type": "esriFieldTypeInteger", "alias": "CONV_SEQ", "domain": null }, { "name": "DEDPROC_DATE", "type": "esriFieldTypeString", "alias": "DEDPROC_DATE", "length": 10, "domain": null }, { "name": "CONV_COMPL_DATE", "type": "esriFieldTypeString", "alias": "CONV_COMPL_DATE", "length": 10, "domain": null }, { "name": "CONV_POST_DATE", "type": "esriFieldTypeString", "alias": "CONV_POST_DATE", "length": 10, "domain": null }, { "name": "TRANS_TYPE", "type": "esriFieldTypeString", "alias": "TRANS_TYPE", "length": 3, "domain": null }, { "name": "CONV_MULT", "type": "esriFieldTypeString", "alias": "CONV_MULT", "length": 1, "domain": null }, { "name": "FULL_VAL", "type": "esriFieldTypeString", "alias": "FULL_VAL", "length": 1, "domain": null }, { "name": "IND_SELL_PRICE", "type": "esriFieldTypeInteger", "alias": "IND_SELL_PRICE", "domain": null }, { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null } ], "indexes": [ { "name": "R38_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "I43ASMT", "fields": "ASMT", "isAscending": true, "isUnique": false, "description": "" }, { "name": "I43FULL_VAL", "fields": "FULL_VAL", "isAscending": true, "isUnique": false, "description": "" }, { "name": "I43IND_SELL_PRIC", "fields": "IND_SELL_PRICE", "isAscending": true, "isUnique": false, "description": "" }, { "name": "I43TRANS_TYPE", "fields": "TRANS_TYPE", "isAscending": true, "isUnique": false, "description": "" } ], "subtypes": [], "relationships": [ { "id": 4, "name": "GDB_PUB.RIVCO.PARCELS", "relatedTableId": 0, "role": "esriRelRoleDestination", "keyField": "ASMT", "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 }, "dateFieldsTimeReference": null }, { "currentVersion": 10.61, "id": 6, "name": "GDB_PUB.RIVCO.CREST_GENERAL", "type": "Table", "description": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "STREET_NAME", "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": "GEO_CD", "type": "esriFieldTypeString", "alias": "GEO_CD", "length": 32, "domain": null }, { "name": "CLASS_CODE", "type": "esriFieldTypeString", "alias": "CLASS_CODE", "length": 64, "domain": null }, { "name": "STREET_NAME", "type": "esriFieldTypeString", "alias": "STREET_NAME", "length": 64, "domain": null }, { "name": "STREET_TYPE", "type": "esriFieldTypeString", "alias": "STREET_TYPE", "length": 8, "domain": null }, { "name": "STREET_PREDIRECTIONAL", "type": "esriFieldTypeString", "alias": "STREET_PREDIRECTIONAL", "length": 2, "domain": null }, { "name": "STREET_NUMBER", "type": "esriFieldTypeInteger", "alias": "STREET_NUMBER", "domain": null }, { "name": "STREET_NUMBER_SFX", "type": "esriFieldTypeString", "alias": "STREET_NUMBER_SFX", "length": 16, "domain": null }, { "name": "UNIT_NUMBER", "type": "esriFieldTypeString", "alias": "UNIT_NUMBER", "length": 8, "domain": null }, { "name": "CITY", "type": "esriFieldTypeString", "alias": "CITY", "length": 32, "domain": null }, { "name": "POSTAL_CD", "type": "esriFieldTypeString", "alias": "POSTAL_CD", "length": 16, "domain": null }, { "name": "PRIME_BASE_YEAR", "type": "esriFieldTypeInteger", "alias": "PRIME_BASE_YEAR", "domain": null }, { "name": "MULTIPLE", "type": "esriFieldTypeString", "alias": "MULTIPLE", "length": 64, "domain": null }, { "name": "BUSINESS_USE_CODE", "type": "esriFieldTypeString", "alias": "BUSINESS_USE_CODE", "length": 64, "domain": null } ], "indexes": [ { "name": "R350_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "I796POSTAL_CD", "fields": "POSTAL_CD", "isAscending": true, "isUnique": false, "description": "" }, { "name": "I796CITY", "fields": "CITY", "isAscending": true, "isUnique": false, "description": "" }, { "name": "I796STREET_NAME", "fields": "STREET_NAME", "isAscending": true, "isUnique": false, "description": "" }, { "name": "I796PIN", "fields": "PIN", "isAscending": true, "isUnique": false, "description": "" } ], "subtypes": [], "relationships": [ { "id": 5, "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 } }, { "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 } }, { "currentVersion": 10.61, "id": 8, "name": "GDB_PUB.RIVCO.CREST_RECORDED_BOOK", "type": "Table", "description": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "SUBDIVISION_NAME", "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": "ACREAGE", "type": "esriFieldTypeDouble", "alias": "ACREAGE", "domain": null }, { "name": "RECORDER_MAP_TYPE", "type": "esriFieldTypeString", "alias": "RECORDER_MAP_TYPE", "length": 16, "domain": null }, { "name": "BOOK", "type": "esriFieldTypeString", "alias": "BOOK", "length": 4, "domain": null }, { "name": "PAGE", "type": "esriFieldTypeString", "alias": "PAGE", "length": 4, "domain": null }, { "name": "MAP_BOOK_PAGE", "type": "esriFieldTypeString", "alias": "MAP_BOOK_PAGE", "length": 16, "domain": null }, { "name": "COUNTY_CODE", "type": "esriFieldTypeString", "alias": "COUNTY_CODE", "length": 2, "domain": null }, { "name": "LOT_TYPE", "type": "esriFieldTypeString", "alias": "LOT_TYPE", "length": 16, "domain": null }, { "name": "LOT", "type": "esriFieldTypeString", "alias": "LOT", "length": 64, "domain": null }, { "name": "BLOCK", "type": "esriFieldTypeString", "alias": "BLOCK", "length": 64, "domain": null }, { "name": "PORTIONAL", "type": "esriFieldTypeString", "alias": "PORTIONAL", "length": 64, "domain": null }, { "name": "SUBDIVISION_NAME", "type": "esriFieldTypeString", "alias": "SUBDIVISION_NAME", "length": 64, "domain": null }, { "name": "PORTION_DIRECTION1", "type": "esriFieldTypeString", "alias": "PORTION_DIRECTION1", "length": 8, "domain": null }, { "name": "SECTION_NUMBER1", "type": "esriFieldTypeString", "alias": "SECTION_NUMBER1", "length": 16, "domain": null }, { "name": "TOWNSHIP1", "type": "esriFieldTypeString", "alias": "TOWNSHIP1", "length": 4, "domain": null }, { "name": "RANGE1", "type": "esriFieldTypeString", "alias": "RANGE1", "length": 4, "domain": null }, { "name": "RANGE_DIRECTION1", "type": "esriFieldTypeString", "alias": "RANGE_DIRECTION1", "length": 4, "domain": null }, { "name": "PORTION_DIRECTION2", "type": "esriFieldTypeString", "alias": "PORTION_DIRECTION2", "length": 4, "domain": null }, { "name": "SECTION_NUMBER2", "type": "esriFieldTypeString", "alias": "SECTION_NUMBER2", "length": 16, "domain": null }, { "name": "TOWNSHIP2", "type": "esriFieldTypeString", "alias": "TOWNSHIP2", "length": 4, "domain": null }, { "name": "RANGE2", "type": "esriFieldTypeString", "alias": "RANGE2", "length": 4, "domain": null }, { "name": "RANGE_DIRECTION2", "type": "esriFieldTypeString", "alias": "RANGE_DIRECTION2", "length": 4, "domain": null }, { "name": "CAME_FROM", "type": "esriFieldTypeString", "alias": "CAME_FROM", "length": 2000, "domain": null } ], "indexes": [ { "name": "R353_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "I799SUBDIVISION_", "fields": "SUBDIVISION_NAME", "isAscending": true, "isUnique": false, "description": "" }, { "name": "I799MAP_BOOK_PAG", "fields": "MAP_BOOK_PAGE", "isAscending": true, "isUnique": false, "description": "" }, { "name": "I799PAGE", "fields": "PAGE", "isAscending": true, "isUnique": false, "description": "" }, { "name": "I799BOOK", "fields": "BOOK", "isAscending": true, "isUnique": false, "description": "" }, { "name": "I799PIN", "fields": "PIN", "isAscending": true, "isUnique": false, "description": "" } ], "subtypes": [], "relationships": [ { "id": 7, "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 } }, { "currentVersion": 10.61, "id": 9, "name": "GDB_PUB.RIVCO.CREST_TAXYEAR", "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": "TAX_YEAR", "type": "esriFieldTypeSmallInteger", "alias": "TAX_YEAR", "domain": null }, { "name": "IS_TAXABLE", "type": "esriFieldTypeSmallInteger", "alias": "IS_TAXABLE", "domain": null }, { "name": "PRIMARY_TAG", "type": "esriFieldTypeString", "alias": "PRIMARY_TAG", "length": 3, "domain": null }, { "name": "SECONDARY_TAG", "type": "esriFieldTypeString", "alias": "SECONDARY_TAG", "length": 3, "domain": null }, { "name": "LAND", "type": "esriFieldTypeDouble", "alias": "LAND", "domain": null }, { "name": "STRUCTURES", "type": "esriFieldTypeDouble", "alias": "STRUCTURES", "domain": null }, { "name": "LIVING_IMPROVEMENTS", "type": "esriFieldTypeDouble", "alias": "LIVING_IMPROVEMENTS", "domain": null }, { "name": "TRADE_FIXTURES", "type": "esriFieldTypeDouble", "alias": "TRADE_FIXTURES", "domain": null }, { "name": "PERSONAL_PROPERTY", "type": "esriFieldTypeDouble", "alias": "PERSONAL_PROPERTY", "domain": null }, { "name": "LATE_FILING_10_PENALTY", "type": "esriFieldTypeDouble", "alias": "LATE_FILING_10_PENALTY", "domain": null }, { "name": "LATE_FILING_15_PENALTY", "type": "esriFieldTypeDouble", "alias": "LATE_FILING_15_PENALTY", "domain": null }, { "name": "HOMEOWNERS_EXMPT", "type": "esriFieldTypeDouble", "alias": "HOMEOWNERS_EXMPT", "domain": null }, { "name": "VETERANS_EXMPT", "type": "esriFieldTypeDouble", "alias": "VETERANS_EXMPT", "domain": null }, { "name": "CHURCH_EXMPT", "type": "esriFieldTypeDouble", "alias": "CHURCH_EXMPT", "domain": null }, { "name": "RELIGIOUS_EXMPT", "type": "esriFieldTypeDouble", "alias": "RELIGIOUS_EXMPT", "domain": null }, { "name": "PUBLIC_SCHOOL_EXMPT", "type": "esriFieldTypeDouble", "alias": "PUBLIC_SCHOOL_EXMPT", "domain": null }, { "name": "PUBLIC_LIBRARY_EXMPT", "type": "esriFieldTypeDouble", "alias": "PUBLIC_LIBRARY_EXMPT", "domain": null }, { "name": "PUBLIC_MUSEUM_EXMPT", "type": "esriFieldTypeDouble", "alias": "PUBLIC_MUSEUM_EXMPT", "domain": null }, { "name": "COLLEGE_EXMPT", "type": "esriFieldTypeDouble", "alias": "COLLEGE_EXMPT", "domain": null }, { "name": "HOSPITAL_EXMPT", "type": "esriFieldTypeDouble", "alias": "HOSPITAL_EXMPT", "domain": null }, { "name": "PRIVATE_SCHOOL_EXMPT", "type": "esriFieldTypeDouble", "alias": "PRIVATE_SCHOOL_EXMPT", "domain": null }, { "name": "CHARITY_RELIGIOUS_EXMPT", "type": "esriFieldTypeDouble", "alias": "CHARITY_RELIGIOUS_EXMPT", "domain": null }, { "name": "OTHER_EXMPT", "type": "esriFieldTypeDouble", "alias": "OTHER_EXMPT", "domain": null } ], "indexes": [ { "name": "R359_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "I805PIN", "fields": "PIN", "isAscending": true, "isUnique": false, "description": "" } ], "subtypes": [], "relationships": [ { "id": 8, "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 } }, { "currentVersion": 10.61, "id": 10, "name": "GDB_PUB.RIVCO.CREST_ASSESSEE", "type": "Table", "description": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "LAST_NAME", "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": "TAX_YEAR", "type": "esriFieldTypeSmallInteger", "alias": "TAX_YEAR", "domain": null }, { "name": "MAIL_STREET", "type": "esriFieldTypeString", "alias": "MAIL_STREET", "length": 64, "domain": null }, { "name": "MAIL_CITY", "type": "esriFieldTypeString", "alias": "MAIL_CITY", "length": 32, "domain": null }, { "name": "MAIL_STATE", "type": "esriFieldTypeString", "alias": "MAIL_STATE", "length": 16, "domain": null }, { "name": "MAIL_POSTAL_CD", "type": "esriFieldTypeString", "alias": "MAIL_POSTAL_CD", "length": 16, "domain": null } ], "indexes": [ { "name": "R351_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "I797MAIL_POSTAL_", "fields": "MAIL_POSTAL_CD", "isAscending": true, "isUnique": false, "description": "" }, { "name": "I797MAIL_CITY", "fields": "MAIL_CITY", "isAscending": true, "isUnique": false, "description": "" }, { "name": "I797MAIL_STREET", "fields": "MAIL_STREET", "isAscending": true, "isUnique": false, "description": "" }, { "name": "I797PIN", "fields": "PIN", "isAscending": true, "isUnique": false, "description": "" } ], "subtypes": [], "relationships": [ { "id": 9, "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 } } ] }