{ "layers": [ { "currentVersion": 10.91, "cimVersion": "2.9.0", "id": 0, "name": "Parcels", "type": "Feature Layer", "description": "

The City of Escondido's parcel layer is derived from the San Diego County asessor's parcels but also includes Proposed parcels (parcels that have been subdivided and plotted by COE planning and building departments but not yet recorded by the county asessor's office) and Retired parcels (Parcels which have been subdivided or otherwise replaced with new parcels, but which we wish to keep a historical record of). These are indicated in the ASSETSATUS field, and the definitions of each category can be found below in the \"fields\" section.Parcels are keyed to the Assessor Parcel Number (APN), except in the case of proposed parcels, which have a temporary \"placeholder\" APN, generally the building plan lot number with a prefix to indicate which development it belongs to. These proposed parcels are replaced once the asessor's office releases APN numbers for the development with the new \"official\" parcels containing and APN number.This layer also contains attributes to indicate the current zoning and general plan land use designation of each parcel.<\/SPAN><\/SPAN><\/P>

This layer contains \u201cstacked\u201d parcels. That means that for any piece of ground there may be multiple parcels. For example, a condominium building may have 20 individual condos. Each condo is a separate taxable parcel. All 20 parcels will be associated with the same physical lot on the ground. When the parcel layer is created each individual condo has a polygon representing the physical location of the parent parcel. In this example there will be 20 polygons all stacked on top of each other that represent the taxable parcels and each polygon will have the same physical characteristics (shape, size, area, location) \u2013 they are, essentially, copies of each other. However, other associated information (owner, document numbers, etc) will be different for each. In this case, each condo unit will have its own parcel number and there will be no single parcel representing the lot on the ground. <\/SPAN><\/SPAN><\/P>

Besides condominiums there are two other cases where you will see stacked parcels \u2013 possessory interest and mobile homes. Possessory interests have Assessor Parcel Numbers (APNs) that start with 76x. A possessory interest (or PI) parcel represents a taxable interest in the underlying, or parent, parcel but not necessarily ownership. For instance, a private company may have an arrangement with a University to operate a business on campus \u2013 a coffee shop or gift shop for example. The private business is taxable and is assinged a 76x APN and that APN is associated with the parent parcel which is owned by the University. Possessory intestests do not represent ownership on the parcel, only a taxable interest in the underlying parent parcel.<\/SPAN><\/SPAN><\/P>

Mobile home parcel APNs start with 77x. In a manner similar to the possessory interests, mobile home owners own their home (coach) but not the underlying property on which the house sits. The actual mobile home is a separate taxable parcel associated with the mobile home park parent parcel. These taxable parcels all have the same polygon as the underlying parent parcel and will show as stacked parcels as well.<\/SPAN><\/SPAN><\/P><\/DIV>", "geometryType": "esriGeometryPolygon", "sourceSpatialReference": { "wkid": 102646, "latestWkid": 2230, "xyTolerance": 0.003280833333333333, "zTolerance": 0.001, "mTolerance": 0.001, "falseX": -118608900, "falseY": -91259500, "xyUnits": 3048.0060960121928, "falseZ": 0, "zUnits": 1, "falseM": 0, "mUnits": 1 }, "copyrightText": "City of Escondido", "parentLayer": null, "subLayers": [], "minScale": 10000, "maxScale": 0, "referenceScale": 0.0, "drawingInfo": { "renderer": { "type": "simple", "symbol": { "type": "esriSFS", "style": "esriSFSSolid", "color": [ 0, 0, 0, 0 ], "outline": { "type": "esriSLS", "style": "esriSLSSolid", "color": [ 255, 255, 115, 255 ], "width": 0.4 } } }, "scaleSymbols": true, "transparency": 0, "labelingInfo": null }, "defaultVisibility": true, "extent": { "xmin": 6273734.583968803, "ymin": 1952272.999965638, "xmax": 6351390.490008384, "ymax": 2028648.0010867268, "spatialReference": { "wkid": 102646, "latestWkid": 2230, "xyTolerance": 0.003280833333333333, "zTolerance": 0.001, "mTolerance": 0.001, "falseX": -118608900, "falseY": -91259500, "xyUnits": 3.597970630767777E7, "falseZ": -100000, "zUnits": 10000, "falseM": -100000, "mUnits": 10000 } }, "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": 10, "domain": null }, { "name": "ESC_FULLADDR", "type": "esriFieldTypeString", "alias": "Address", "length": 100, "domain": null }, { "name": "ESC_OWNNAME", "type": "esriFieldTypeString", "alias": "Owner Name", "length": 255, "domain": null }, { "name": "ESC_OWNADDR", "type": "esriFieldTypeString", "alias": "Owner Address", "length": 255, "domain": null }, { "name": "ACREAGE", "type": "esriFieldTypeDouble", "alias": "Acreage", "domain": null }, { "name": "ZONING", "type": "esriFieldTypeString", "alias": "Zoning", "length": 25, "domain": null }, { "name": "GENPLAN", "type": "esriFieldTypeString", "alias": "General Plan", "length": 10, "domain": null }, { "name": "shape", "type": "esriFieldTypeGeometry", "alias": "SHAPE", "domain": null }, { "name": "LEGLDESC", "type": "esriFieldTypeString", "alias": "Legal Description", "length": 65, "domain": null }, { "name": "SUBMAP", "type": "esriFieldTypeString", "alias": "Subdivision Map", "length": 11, "domain": null }, { "name": "SUBNAME", "type": "esriFieldTypeString", "alias": "Subdivision Name", "length": 64, "domain": null }, { "name": "YEAR_EFFEC", "type": "esriFieldTypeString", "alias": "Year Built", "length": 2, "domain": null }, { "name": "FRACTINT", "type": "esriFieldTypeDouble", "alias": "FRACTINT", "domain": null }, { "name": "SITUS_JURI", "type": "esriFieldTypeString", "alias": "Jurisdiction", "length": 2, "domain": null }, { "name": "ASR_LAND", "type": "esriFieldTypeInteger", "alias": "Assesed Land Value", "domain": null }, { "name": "ASR_IMPR", "type": "esriFieldTypeInteger", "alias": "Assesed Improvement Value", "domain": null }, { "name": "ASR_TOTAL", "type": "esriFieldTypeInteger", "alias": "Assesed Total Value", "domain": null }, { "name": "DOCTYPE", "type": "esriFieldTypeString", "alias": "Assesor Document Type", "length": 1, "domain": null }, { "name": "DOCNMBR", "type": "esriFieldTypeString", "alias": "Assesor Document Number", "length": 6, "domain": null }, { "name": "DOCDATE", "type": "esriFieldTypeString", "alias": "Assesor Document Date", "length": 8, "domain": null }, { "name": "TAXSTAT", "type": "esriFieldTypeString", "alias": "Taxable", "length": 1, "domain": null }, { "name": "OWNEROCC", "type": "esriFieldTypeString", "alias": "Owner Occupied", "length": 1, "domain": null }, { "name": "TRANUM", "type": "esriFieldTypeString", "alias": "Tax Rate Area Number", "length": 5, "domain": null }, { "name": "UNITQTY", "type": "esriFieldTypeInteger", "alias": "Number of Dwelling Units", "domain": null }, { "name": "NUCLEUS_ZO", "type": "esriFieldTypeString", "alias": "Generalized Land Use Zones", "length": 2, "domain": null }, { "name": "NUCLEUS_US", "type": "esriFieldTypeString", "alias": "Sprcific Land Use Codes", "length": 3, "domain": null }, { "name": "TOTAL_LVG_", "type": "esriFieldTypeInteger", "alias": "Total Living Area (SF)", "domain": null }, { "name": "BEDROOMS", "type": "esriFieldTypeString", "alias": "# of Bedrooms", "length": 3, "domain": null }, { "name": "BATHS", "type": "esriFieldTypeString", "alias": "# Of Bathrooms", "length": 3, "domain": null }, { "name": "ADDITION_A", "type": "esriFieldTypeInteger", "alias": "Building Addition Area", "domain": null }, { "name": "GARAGE_CON", "type": "esriFieldTypeString", "alias": "Garage Conversion", "length": 1, "domain": null }, { "name": "GARAGE_STA", "type": "esriFieldTypeString", "alias": "GARAGE_STA", "length": 3, "domain": null }, { "name": "CARPORT_ST", "type": "esriFieldTypeString", "alias": "CARPORT_ST", "length": 3, "domain": null }, { "name": "POOL", "type": "esriFieldTypeString", "alias": "Pool", "length": 1, "domain": null }, { "name": "USABLE_SQ_", "type": "esriFieldTypeString", "alias": "Pad Area (SF)", "length": 5, "domain": null }, { "name": "shape.STArea()", "type": "esriFieldTypeDouble", "alias": "SHAPE.STArea()", "domain": null }, { "name": "HISTORIC", "type": "esriFieldTypeString", "alias": "Historic Designation", "length": 255, "domain": null }, { "name": "ASSETSTATUS", "type": "esriFieldTypeString", "alias": "ASSETSTATUS", "length": 1, "domain": { "type": "codedValue", "name": "AssetStatus", "description": "Current, Retired or Abandoned - Instead of deleting assets they are retired (replaced wholly or partly by new features) or abandoned (blocked and left in ground).", "codedValues": [ { "name": "Current", "code": "C" }, { "name": "Retired", "code": "R" }, { "name": "Abandoned", "code": "A" }, { "name": "Geometric Network Only", "code": "G" }, { "name": "Proposed", "code": "P" }, { "name": "Needs Review", "code": "N" }, { "name": "to Delete", "code": "D" }, { "name": "Transposed", "code": "T" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "PARENT_APN", "type": "esriFieldTypeString", "alias": "Parent APN", "length": 10, "domain": null } ], "geometryField": { "name": "shape", "type": "esriFieldTypeGeometry", "alias": "SHAPE" }, "indexes": [ { "name": "R452_pk", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "I1589APN", "fields": "APN", "isAscending": true, "isUnique": false, "description": "" }, { "name": "I1589ESC_FULLADD", "fields": "ESC_FULLADDR", "isAscending": true, "isUnique": false, "description": "" }, { "name": "I1589ESC_OWNNAME", "fields": "ESC_OWNNAME", "isAscending": true, "isUnique": false, "description": "" }, { "name": "S244_idx", "fields": "shape", "isAscending": true, "isUnique": true, "description": "" } ], "subtypes": [], "relationships": [ { "id": 0, "name": "GISBack.GIS.GB_BldgPerm", "relatedTableId": 2, "role": "esriRelRoleOrigin", "keyField": "APN", "cardinality": "esriRelCardinalityOneToMany", "composite": false }, { "id": 1, "name": "GISBack.GIS.GB_BusLic", "relatedTableId": 3, "role": "esriRelRoleOrigin", "keyField": "APN", "cardinality": "esriRelCardinalityOneToMany", "composite": false }, { "id": 2, "name": "GISBack.GIS.GB_Cases", "relatedTableId": 4, "role": "esriRelRoleOrigin", "keyField": "APN", "cardinality": "esriRelCardinalityOneToMany", "composite": false }, { "id": 3, "name": "GISBack.GIS.GB_SpecDist", "relatedTableId": 11, "role": "esriRelRoleOrigin", "keyField": "APN", "cardinality": "esriRelCardinalityOneToMany", "composite": false } ], "canModifyLayer": true, "canScaleSymbols": false, "hasLabels": false, "capabilities": "Map,Query,Data", "maxRecordCount": 2000, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON, geoJSON, PBF", "isDataVersioned": false, "ownershipBasedAccessControlForFeatures": {"allowOthersToQuery": true}, "useStandardizedQueries": true, "supportedSpatialRelationships": [ "esriSpatialRelIntersects", "esriSpatialRelContains", "esriSpatialRelCrosses", "esriSpatialRelEnvelopeIntersects", "esriSpatialRelIndexIntersects", "esriSpatialRelOverlaps", "esriSpatialRelTouches", "esriSpatialRelWithin", "esriSpatialRelRelation" ], "advancedQueryCapabilities": { "useStandardizedQueries": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsPagination": true, "supportsLod": false, "supportsQueryWithLodSR": false, "supportsTrueCurve": true, "supportsQueryWithDatumTransformation": true, "supportsReturningQueryExtent": true, "supportsQueryWithDistance": true, "supportsSqlExpression": true, "supportsTimeRelation": true, "supportsSqlFormat": false, "supportsQueryAnalytic": true }, "supportsDatumTransformation": true, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": false, "supportsPercentileAnalytic": true }, "dateFieldsTimeReference": null, "preferredTimeReference": null, "datesInUnknownTimezone": false, "hasGeometryProperties": true, "geometryProperties": { "shapeAreaFieldName": "shape.STArea()", "shapeLengthFieldName": "shape.STLength()", "units": "esriFeet" }, "hasMetadata": true, "isDataArchived": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "supportsCoordinatesQuantization": true, "supportsDynamicLegends": true, "serviceItemId": "a8cc72ec4de641479df8fa29a97f94cd" } ], "tables": [ { "currentVersion": 10.91, "cimVersion": "2.9.0", "id": 1, "name": "GB_Address", "type": "Table", "description": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "ADDR", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "APN", "type": "esriFieldTypeDouble", "alias": "APN", "domain": null }, { "name": "ADDR", "type": "esriFieldTypeString", "alias": "ADDR", "length": 255, "domain": null }, { "name": "UNITNUM", "type": "esriFieldTypeString", "alias": "UNITNUM", "length": 255, "domain": null }, { "name": "GLOBALID", "type": "esriFieldTypeGlobalID", "alias": "GLOBALID", "length": 38, "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 }, { "name": "APNTXT", "type": "esriFieldTypeString", "alias": "APNTXT", "length": 10, "domain": null }, { "name": "ASSETSTATUS", "type": "esriFieldTypeString", "alias": "ASSETSTATUS", "length": 1, "domain": { "type": "codedValue", "name": "AssetStatus", "description": "Current, Retired or Abandoned - Instead of deleting assets they are retired (replaced wholly or partly by new features) or abandoned (blocked and left in ground).", "codedValues": [ { "name": "Current", "code": "C" }, { "name": "Retired", "code": "R" }, { "name": "Abandoned", "code": "A" }, { "name": "Geometric Network Only", "code": "G" }, { "name": "Proposed", "code": "P" }, { "name": "Needs Review", "code": "N" }, { "name": "to Delete", "code": "D" }, { "name": "Transposed", "code": "T" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } } ], "indexes": [ { "name": "R486_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "UUID_486", "fields": "GLOBALID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "G1700APN", "fields": "APN", "isAscending": true, "isUnique": false, "description": "" }, { "name": "G1700APNTXT", "fields": "APNTXT", "isAscending": true, "isUnique": false, "description": "" } ], "subtypes": [], "relationships": [], "capabilities": "Map,Query,Data", "maxRecordCount": 2000, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON, PBF", "isDataVersioned": false, "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, "supportsSqlFormat": false, "supportsQueryAnalytic": true }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": false, "supportsPercentileAnalytic": true }, "dateFieldsTimeReference": null, "preferredTimeReference": null, "datesInUnknownTimezone": false, "hasMetadata": true, "isDataArchived": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "serviceItemId": "a8cc72ec4de641479df8fa29a97f94cd" }, { "currentVersion": 10.91, "cimVersion": "2.9.0", "id": 2, "name": "GB_BldgPerm", "type": "Table", "description": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "BLDG_PERMIT", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "APN", "type": "esriFieldTypeDouble", "alias": "APN", "domain": null }, { "name": "BLDG_PERMIT", "type": "esriFieldTypeString", "alias": "BLDG_PERMIT", "length": 40, "domain": null }, { "name": "GLOBALID", "type": "esriFieldTypeGlobalID", "alias": "GLOBALID", "length": 38, "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 }, { "name": "APNTXT", "type": "esriFieldTypeString", "alias": "APNTXT", "length": 10, "domain": null }, { "name": "DUPS", "type": "esriFieldTypeSmallInteger", "alias": "DUPS", "domain": null }, { "name": "DUPS_5", "type": "esriFieldTypeSmallInteger", "alias": "DUPS_5", "domain": null }, { "name": "ASSETSTATUS", "type": "esriFieldTypeString", "alias": "ASSETSTATUS", "length": 1, "domain": { "type": "codedValue", "name": "AssetStatus", "description": "Current, Retired or Abandoned - Instead of deleting assets they are retired (replaced wholly or partly by new features) or abandoned (blocked and left in ground).", "codedValues": [ { "name": "Current", "code": "C" }, { "name": "Retired", "code": "R" }, { "name": "Abandoned", "code": "A" }, { "name": "Geometric Network Only", "code": "G" }, { "name": "Proposed", "code": "P" }, { "name": "Needs Review", "code": "N" }, { "name": "to Delete", "code": "D" }, { "name": "Transposed", "code": "T" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } } ], "indexes": [ { "name": "R487_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "UUID_487", "fields": "GLOBALID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "G1701APN", "fields": "APN", "isAscending": true, "isUnique": false, "description": "" }, { "name": "G1701APNTXT", "fields": "APNTXT", "isAscending": true, "isUnique": false, "description": "" } ], "subtypes": [], "relationships": [ { "id": 0, "name": "GISBack.GIS.Parcels_GB", "relatedTableId": 0, "role": "esriRelRoleDestination", "keyField": "APNTXT", "cardinality": "esriRelCardinalityOneToMany", "composite": false } ], "capabilities": "Map,Query,Data", "maxRecordCount": 2000, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON, PBF", "isDataVersioned": false, "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, "supportsSqlFormat": false, "supportsQueryAnalytic": true }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": false, "supportsPercentileAnalytic": true }, "dateFieldsTimeReference": null, "preferredTimeReference": null, "datesInUnknownTimezone": false, "hasMetadata": true, "isDataArchived": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "serviceItemId": "a8cc72ec4de641479df8fa29a97f94cd" }, { "currentVersion": 10.91, "cimVersion": "2.9.0", "id": 3, "name": "GB_BusLic", "type": "Table", "description": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "BUSLIC", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "APN", "type": "esriFieldTypeDouble", "alias": "APN", "domain": null }, { "name": "BUSLIC", "type": "esriFieldTypeString", "alias": "BUSLIC", "length": 40, "domain": null }, { "name": "GLOBALID", "type": "esriFieldTypeGlobalID", "alias": "GLOBALID", "length": 38, "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 }, { "name": "APNTXT", "type": "esriFieldTypeString", "alias": "APNTXT", "length": 10, "domain": null }, { "name": "ASSETSTATUS", "type": "esriFieldTypeString", "alias": "ASSETSTATUS", "length": 1, "domain": { "type": "codedValue", "name": "AssetStatus", "description": "Current, Retired or Abandoned - Instead of deleting assets they are retired (replaced wholly or partly by new features) or abandoned (blocked and left in ground).", "codedValues": [ { "name": "Current", "code": "C" }, { "name": "Retired", "code": "R" }, { "name": "Abandoned", "code": "A" }, { "name": "Geometric Network Only", "code": "G" }, { "name": "Proposed", "code": "P" }, { "name": "Needs Review", "code": "N" }, { "name": "to Delete", "code": "D" }, { "name": "Transposed", "code": "T" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } } ], "indexes": [ { "name": "R488_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "UUID_488", "fields": "GLOBALID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "G1702APN", "fields": "APN", "isAscending": true, "isUnique": false, "description": "" }, { "name": "G1702APNTXT", "fields": "APNTXT", "isAscending": true, "isUnique": false, "description": "" } ], "subtypes": [], "relationships": [ { "id": 1, "name": "GISBack.GIS.Parcels_GB", "relatedTableId": 0, "role": "esriRelRoleDestination", "keyField": "APNTXT", "cardinality": "esriRelCardinalityOneToMany", "composite": false } ], "capabilities": "Map,Query,Data", "maxRecordCount": 2000, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON, PBF", "isDataVersioned": false, "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, "supportsSqlFormat": false, "supportsQueryAnalytic": true }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": false, "supportsPercentileAnalytic": true }, "dateFieldsTimeReference": null, "preferredTimeReference": null, "datesInUnknownTimezone": false, "hasMetadata": true, "isDataArchived": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "serviceItemId": "a8cc72ec4de641479df8fa29a97f94cd" }, { "currentVersion": 10.91, "cimVersion": "2.9.0", "id": 4, "name": "GB_Cases", "type": "Table", "description": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "CASEID", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "APN", "type": "esriFieldTypeDouble", "alias": "APN", "domain": null }, { "name": "CASEID", "type": "esriFieldTypeString", "alias": "CASEID", "length": 255, "domain": null }, { "name": "GLOBALID", "type": "esriFieldTypeGlobalID", "alias": "GLOBALID", "length": 38, "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 }, { "name": "APNTXT", "type": "esriFieldTypeString", "alias": "APNTXT", "length": 10, "domain": null }, { "name": "CORRECTION", "type": "esriFieldTypeString", "alias": "CORRECTION", "length": 1, "domain": null }, { "name": "ASSETSTATUS", "type": "esriFieldTypeString", "alias": "ASSETSTATUS", "length": 1, "domain": { "type": "codedValue", "name": "AssetStatus", "description": "Current, Retired or Abandoned - Instead of deleting assets they are retired (replaced wholly or partly by new features) or abandoned (blocked and left in ground).", "codedValues": [ { "name": "Current", "code": "C" }, { "name": "Retired", "code": "R" }, { "name": "Abandoned", "code": "A" }, { "name": "Geometric Network Only", "code": "G" }, { "name": "Proposed", "code": "P" }, { "name": "Needs Review", "code": "N" }, { "name": "to Delete", "code": "D" }, { "name": "Transposed", "code": "T" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } } ], "indexes": [ { "name": "R489_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "UUID_489", "fields": "GLOBALID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "G1703APN", "fields": "APN", "isAscending": true, "isUnique": false, "description": "" }, { "name": "G1703APNTXT", "fields": "APNTXT", "isAscending": true, "isUnique": false, "description": "" } ], "subtypes": [], "relationships": [ { "id": 2, "name": "GISBack.GIS.Parcels_GB", "relatedTableId": 0, "role": "esriRelRoleDestination", "keyField": "APNTXT", "cardinality": "esriRelCardinalityOneToMany", "composite": false } ], "capabilities": "Map,Query,Data", "maxRecordCount": 2000, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON, PBF", "isDataVersioned": false, "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, "supportsSqlFormat": false, "supportsQueryAnalytic": true }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": false, "supportsPercentileAnalytic": true }, "dateFieldsTimeReference": null, "preferredTimeReference": null, "datesInUnknownTimezone": false, "hasMetadata": true, "isDataArchived": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "serviceItemId": "a8cc72ec4de641479df8fa29a97f94cd" }, { "currentVersion": 10.91, "cimVersion": "2.9.0", "id": 5, "name": "GB_Historic", "type": "Table", "description": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "HISTORIC", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "APN", "type": "esriFieldTypeDouble", "alias": "APN", "domain": null }, { "name": "HISTORIC", "type": "esriFieldTypeString", "alias": "HISTORIC", "length": 255, "domain": null }, { "name": "GLOBALID", "type": "esriFieldTypeGlobalID", "alias": "GLOBALID", "length": 38, "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 }, { "name": "APNTXT", "type": "esriFieldTypeString", "alias": "APNTXT", "length": 10, "domain": null }, { "name": "NOTES", "type": "esriFieldTypeString", "alias": "NOTES", "length": 255, "domain": null }, { "name": "ASSETSTATUS", "type": "esriFieldTypeString", "alias": "ASSETSTATUS", "length": 1, "domain": { "type": "codedValue", "name": "AssetStatus", "description": "Current, Retired or Abandoned - Instead of deleting assets they are retired (replaced wholly or partly by new features) or abandoned (blocked and left in ground).", "codedValues": [ { "name": "Current", "code": "C" }, { "name": "Retired", "code": "R" }, { "name": "Abandoned", "code": "A" }, { "name": "Geometric Network Only", "code": "G" }, { "name": "Proposed", "code": "P" }, { "name": "Needs Review", "code": "N" }, { "name": "to Delete", "code": "D" }, { "name": "Transposed", "code": "T" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } } ], "indexes": [ { "name": "R490_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "UUID_490", "fields": "GLOBALID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "G1704APN", "fields": "APN", "isAscending": true, "isUnique": false, "description": "" }, { "name": "G1704APNTXT", "fields": "APNTXT", "isAscending": true, "isUnique": false, "description": "" } ], "subtypes": [], "relationships": [], "capabilities": "Map,Query,Data", "maxRecordCount": 2000, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON, PBF", "isDataVersioned": false, "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, "supportsSqlFormat": false, "supportsQueryAnalytic": true }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": false, "supportsPercentileAnalytic": true }, "dateFieldsTimeReference": null, "preferredTimeReference": null, "datesInUnknownTimezone": false, "hasMetadata": true, "isDataArchived": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "serviceItemId": "a8cc72ec4de641479df8fa29a97f94cd" }, { "currentVersion": 10.91, "cimVersion": "2.9.0", "id": 6, "name": "GB_LandUse", "type": "Table", "description": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "LANDUSE", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "APN", "type": "esriFieldTypeDouble", "alias": "APN", "domain": null }, { "name": "LANDUSE", "type": "esriFieldTypeString", "alias": "LANDUSE", "length": 255, "domain": null }, { "name": "GLOBALID", "type": "esriFieldTypeGlobalID", "alias": "GLOBALID", "length": 38, "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 }, { "name": "APNTXT", "type": "esriFieldTypeString", "alias": "APNTXT", "length": 10, "domain": null }, { "name": "ASSETSTATUS", "type": "esriFieldTypeString", "alias": "ASSETSTATUS", "length": 1, "domain": { "type": "codedValue", "name": "AssetStatus", "description": "Current, Retired or Abandoned - Instead of deleting assets they are retired (replaced wholly or partly by new features) or abandoned (blocked and left in ground).", "codedValues": [ { "name": "Current", "code": "C" }, { "name": "Retired", "code": "R" }, { "name": "Abandoned", "code": "A" }, { "name": "Geometric Network Only", "code": "G" }, { "name": "Proposed", "code": "P" }, { "name": "Needs Review", "code": "N" }, { "name": "to Delete", "code": "D" }, { "name": "Transposed", "code": "T" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } } ], "indexes": [ { "name": "R491_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "UUID_491", "fields": "GLOBALID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "G1705APN", "fields": "APN", "isAscending": true, "isUnique": false, "description": "" }, { "name": "G1705APNTXT", "fields": "APNTXT", "isAscending": true, "isUnique": false, "description": "" } ], "subtypes": [], "relationships": [], "capabilities": "Map,Query,Data", "maxRecordCount": 2000, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON, PBF", "isDataVersioned": false, "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, "supportsSqlFormat": false, "supportsQueryAnalytic": true }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": false, "supportsPercentileAnalytic": true }, "dateFieldsTimeReference": null, "preferredTimeReference": null, "datesInUnknownTimezone": false, "hasMetadata": true, "isDataArchived": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "serviceItemId": "a8cc72ec4de641479df8fa29a97f94cd" }, { "currentVersion": 10.91, "cimVersion": "2.9.0", "id": 7, "name": "GB_Location", "type": "Table", "description": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "LOC_ID", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "APN", "type": "esriFieldTypeDouble", "alias": "APN", "domain": null }, { "name": "LOC_ID", "type": "esriFieldTypeString", "alias": "LOC_ID", "length": 255, "domain": null }, { "name": "GLOBALID", "type": "esriFieldTypeGlobalID", "alias": "GLOBALID", "length": 38, "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 }, { "name": "APNTXT", "type": "esriFieldTypeString", "alias": "APNTXT", "length": 10, "domain": null }, { "name": "ASSETSTATUS", "type": "esriFieldTypeString", "alias": "ASSETSTATUS", "length": 1, "domain": { "type": "codedValue", "name": "AssetStatus", "description": "Current, Retired or Abandoned - Instead of deleting assets they are retired (replaced wholly or partly by new features) or abandoned (blocked and left in ground).", "codedValues": [ { "name": "Current", "code": "C" }, { "name": "Retired", "code": "R" }, { "name": "Abandoned", "code": "A" }, { "name": "Geometric Network Only", "code": "G" }, { "name": "Proposed", "code": "P" }, { "name": "Needs Review", "code": "N" }, { "name": "to Delete", "code": "D" }, { "name": "Transposed", "code": "T" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } } ], "indexes": [ { "name": "R492_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "UUID_492", "fields": "GLOBALID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "G1706APN", "fields": "APN", "isAscending": true, "isUnique": false, "description": "" }, { "name": "G1706APNTXT", "fields": "APNTXT", "isAscending": true, "isUnique": false, "description": "" } ], "subtypes": [], "relationships": [], "capabilities": "Map,Query,Data", "maxRecordCount": 2000, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON, PBF", "isDataVersioned": false, "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, "supportsSqlFormat": false, "supportsQueryAnalytic": true }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": false, "supportsPercentileAnalytic": true }, "dateFieldsTimeReference": null, "preferredTimeReference": null, "datesInUnknownTimezone": false, "hasMetadata": true, "isDataArchived": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "serviceItemId": "a8cc72ec4de641479df8fa29a97f94cd" }, { "currentVersion": 10.91, "cimVersion": "2.9.0", "id": 8, "name": "GB_Notes", "type": "Table", "description": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "NOTE", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "APN", "type": "esriFieldTypeDouble", "alias": "APN", "domain": null }, { "name": "NOTE", "type": "esriFieldTypeString", "alias": "NOTE", "length": 255, "domain": null }, { "name": "GLOBALID", "type": "esriFieldTypeGlobalID", "alias": "GLOBALID", "length": 38, "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 }, { "name": "APNTXT", "type": "esriFieldTypeString", "alias": "APNTXT", "length": 10, "domain": null }, { "name": "ASSETSTATUS", "type": "esriFieldTypeString", "alias": "ASSETSTATUS", "length": 1, "domain": { "type": "codedValue", "name": "AssetStatus", "description": "Current, Retired or Abandoned - Instead of deleting assets they are retired (replaced wholly or partly by new features) or abandoned (blocked and left in ground).", "codedValues": [ { "name": "Current", "code": "C" }, { "name": "Retired", "code": "R" }, { "name": "Abandoned", "code": "A" }, { "name": "Geometric Network Only", "code": "G" }, { "name": "Proposed", "code": "P" }, { "name": "Needs Review", "code": "N" }, { "name": "to Delete", "code": "D" }, { "name": "Transposed", "code": "T" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } } ], "indexes": [ { "name": "R493_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "UUID_493", "fields": "GLOBALID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "G1707APN", "fields": "APN", "isAscending": true, "isUnique": false, "description": "" }, { "name": "G1707APNTXT", "fields": "APNTXT", "isAscending": true, "isUnique": false, "description": "" } ], "subtypes": [], "relationships": [], "capabilities": "Map,Query,Data", "maxRecordCount": 2000, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON, PBF", "isDataVersioned": false, "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, "supportsSqlFormat": false, "supportsQueryAnalytic": true }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": false, "supportsPercentileAnalytic": true }, "dateFieldsTimeReference": null, "preferredTimeReference": null, "datesInUnknownTimezone": false, "hasMetadata": true, "isDataArchived": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "serviceItemId": "a8cc72ec4de641479df8fa29a97f94cd" }, { "currentVersion": 10.91, "cimVersion": "2.9.0", "id": 9, "name": "GB_RepayDetails", "type": "Table", "description": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "DEVELOP_NAME", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "FOLDERNUM", "type": "esriFieldTypeInteger", "alias": "FOLDERNUM", "domain": null }, { "name": "RESONUM", "type": "esriFieldTypeString", "alias": "RESONUM", "length": 255, "domain": null }, { "name": "RESO_DT", "type": "esriFieldTypeString", "alias": "RESO_DT", "length": 255, "domain": null }, { "name": "EXPIRE_DT", "type": "esriFieldTypeString", "alias": "EXPIRE_DT", "length": 255, "domain": null }, { "name": "DEVELOP_NAME", "type": "esriFieldTypeString", "alias": "DEVELOP_NAME", "length": 255, "domain": null }, { "name": "DESCR", "type": "esriFieldTypeString", "alias": "DESCR", "length": 255, "domain": null }, { "name": "PAY_TO", "type": "esriFieldTypeString", "alias": "PAY_TO", "length": 255, "domain": null }, { "name": "LOTS", "type": "esriFieldTypeString", "alias": "LOTS", "length": 255, "domain": null }, { "name": "BLOCKS", "type": "esriFieldTypeString", "alias": "BLOCKS", "length": 255, "domain": null }, { "name": "TYPE1", "type": "esriFieldTypeString", "alias": "TYPE1", "length": 255, "domain": null }, { "name": "TYPE2", "type": "esriFieldTypeString", "alias": "TYPE2", "length": 255, "domain": null }, { "name": "TYPE3", "type": "esriFieldTypeString", "alias": "TYPE3", "length": 255, "domain": null }, { "name": "NOTES", "type": "esriFieldTypeString", "alias": "NOTES", "length": 255, "domain": null }, { "name": "GLOBALID", "type": "esriFieldTypeGlobalID", "alias": "GLOBALID", "length": 38, "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 }, { "name": "ASSETSTATUS", "type": "esriFieldTypeString", "alias": "ASSETSTATUS", "length": 1, "domain": null } ], "indexes": [ { "name": "R496_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "UUID_496", "fields": "GLOBALID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "G1710FOLDERNUM", "fields": "FOLDERNUM", "isAscending": true, "isUnique": false, "description": "" } ], "subtypes": [], "relationships": [], "capabilities": "Map,Query,Data", "maxRecordCount": 2000, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON, PBF", "isDataVersioned": false, "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, "supportsSqlFormat": false, "supportsQueryAnalytic": true }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": false, "supportsPercentileAnalytic": true }, "dateFieldsTimeReference": null, "preferredTimeReference": null, "datesInUnknownTimezone": false, "hasMetadata": true, "isDataArchived": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "serviceItemId": "a8cc72ec4de641479df8fa29a97f94cd" }, { "currentVersion": 10.91, "cimVersion": "2.9.0", "id": 10, "name": "GB_Repayments", "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": 10, "domain": null }, { "name": "LINENUM", "type": "esriFieldTypeInteger", "alias": "LINENUM", "domain": null }, { "name": "FOLDERNUM", "type": "esriFieldTypeInteger", "alias": "FOLDERNUM", "domain": null }, { "name": "REPAY_TYPE", "type": "esriFieldTypeString", "alias": "REPAY_TYPE", "length": 4, "domain": null }, { "name": "CHARGE", "type": "esriFieldTypeDouble", "alias": "CHARGE", "domain": null }, { "name": "REPAY_DT", "type": "esriFieldTypeDate", "alias": "REPAY_DT", "length": 8, "domain": null }, { "name": "RECEIPT", "type": "esriFieldTypeString", "alias": "RECEIPT", "length": 10, "domain": null }, { "name": "FLAG", "type": "esriFieldTypeString", "alias": "FLAG", "length": 1, "domain": null }, { "name": "TEST", "type": "esriFieldTypeSmallInteger", "alias": "TEST", "domain": null }, { "name": "GlobalID", "type": "esriFieldTypeGlobalID", "alias": "GlobalID", "length": 38, "domain": null } ], "indexes": [ { "name": "R495_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "UUID_495", "fields": "GlobalID", "isAscending": true, "isUnique": false, "description": "" } ], "subtypes": [], "relationships": [], "capabilities": "Map,Query,Data", "maxRecordCount": 2000, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON, PBF", "isDataVersioned": false, "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, "supportsSqlFormat": false, "supportsQueryAnalytic": true }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": false, "supportsPercentileAnalytic": true }, "dateFieldsTimeReference": null, "preferredTimeReference": null, "datesInUnknownTimezone": false, "hasMetadata": true, "isDataArchived": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "serviceItemId": "a8cc72ec4de641479df8fa29a97f94cd" }, { "currentVersion": 10.91, "cimVersion": "2.9.0", "id": 11, "name": "GB_SpecDist", "type": "Table", "description": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "SD_DESC", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "APN", "type": "esriFieldTypeDouble", "alias": "APN", "domain": null }, { "name": "SD_DESC", "type": "esriFieldTypeString", "alias": "SD_DESC", "length": 255, "domain": null }, { "name": "APNTXT", "type": "esriFieldTypeString", "alias": "APNTXT", "length": 10, "domain": null }, { "name": "ASSETSTATUS", "type": "esriFieldTypeString", "alias": "ASSETSTATUS", "length": 1, "domain": { "type": "codedValue", "name": "AssetStatus", "description": "Current, Retired or Abandoned - Instead of deleting assets they are retired (replaced wholly or partly by new features) or abandoned (blocked and left in ground).", "codedValues": [ { "name": "Current", "code": "C" }, { "name": "Retired", "code": "R" }, { "name": "Abandoned", "code": "A" }, { "name": "Geometric Network Only", "code": "G" }, { "name": "Proposed", "code": "P" }, { "name": "Needs Review", "code": "N" }, { "name": "to Delete", "code": "D" }, { "name": "Transposed", "code": "T" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } } ], "indexes": [ { "name": "R494_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "G1708APN", "fields": "APN", "isAscending": true, "isUnique": false, "description": "" }, { "name": "G1708APNTXT", "fields": "APNTXT", "isAscending": true, "isUnique": false, "description": "" } ], "subtypes": [], "relationships": [ { "id": 3, "name": "GISBack.GIS.Parcels_GB", "relatedTableId": 0, "role": "esriRelRoleDestination", "keyField": "APNTXT", "cardinality": "esriRelCardinalityOneToMany", "composite": false } ], "capabilities": "Map,Query,Data", "maxRecordCount": 2000, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON, PBF", "isDataVersioned": false, "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, "supportsSqlFormat": false, "supportsQueryAnalytic": true }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": false, "supportsPercentileAnalytic": true }, "dateFieldsTimeReference": null, "preferredTimeReference": null, "datesInUnknownTimezone": false, "hasMetadata": true, "isDataArchived": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "serviceItemId": "a8cc72ec4de641479df8fa29a97f94cd" } ] }