{ "layers": [ { "currentVersion": 10.71, "id": 0, "name": "Report", "type": "Feature Layer", "description": "", "geometryType": "esriGeometryPolygon", "sourceSpatialReference": { "wkid": 102645, "latestWkid": 2229 }, "copyrightText": "", "parentLayer": null, "subLayers": [], "minScale": 0, "maxScale": 0, "drawingInfo": { "renderer": { "type": "simple", "symbol": { "type": "esriSFS", "style": "esriSFSSolid", "color": [ 0, 0, 0, 0 ], "outline": { "type": "esriSLS", "style": "esriSLSSolid", "color": [ 230, 0, 0, 255 ], "width": 1 } }, "label": "", "description": "" }, "transparency": 0, "labelingInfo": null }, "defaultVisibility": true, "extent": { "xmin": 6621534.0832543075, "ymin": 1775558.0000138134, "xmax": 7730249.500005379, "ymax": 2488963.7500367314, "spatialReference": { "wkid": 102645, "latestWkid": 2229 } }, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeAsHTMLText", "displayField": "Parcel", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "Parcel", "type": "esriFieldTypeString", "alias": "Parcel", "length": 13, "domain": null }, { "name": "ParcelStatusDesc", "type": "esriFieldTypeString", "alias": "Parcel Status", "length": 104, "domain": null }, { "name": "ParcelTypeDesc", "type": "esriFieldTypeString", "alias": "Parcel Type", "length": 104, "domain": null }, { "name": "PropertyID", "type": "esriFieldTypeString", "alias": "Property ID", "length": 15, "domain": null }, { "name": "BilledOwner", "type": "esriFieldTypeString", "alias": "Owner 1", "length": 60, "domain": null }, { "name": "JointOwner", "type": "esriFieldTypeString", "alias": "Joint Owner", "length": 60, "domain": null }, { "name": "SitusAddressln1", "type": "esriFieldTypeString", "alias": "Property Address Line 1", "length": 49, "domain": null }, { "name": "SitusAddressln2", "type": "esriFieldTypeString", "alias": "Property Address Line 2", "length": 70, "domain": null }, { "name": "MailingAddressln1", "type": "esriFieldTypeString", "alias": "Mailing Address Line 1", "length": 44, "domain": null }, { "name": "MailingAddressln2", "type": "esriFieldTypeString", "alias": "Mailing Address Line 2", "length": 44, "domain": null }, { "name": "TaxStatusDesc", "type": "esriFieldTypeString", "alias": "Tax Status", "length": 104, "domain": null }, { "name": "UseCodeDesc", "type": "esriFieldTypeString", "alias": "Use Code", "length": 10, "domain": null }, { "name": "LandAccessDesc", "type": "esriFieldTypeString", "alias": "Land Access", "length": 100, "domain": null }, { "name": "SizeRAngeDesc", "type": "esriFieldTypeString", "alias": "Size", "length": 105, "domain": null }, { "name": "LandTypeDesc", "type": "esriFieldTypeString", "alias": "Land Type", "length": 105, "domain": null }, { "name": "DistrictDesc", "type": "esriFieldTypeString", "alias": "District", "length": 14, "domain": null }, { "name": "RespGroupDesc", "type": "esriFieldTypeString", "alias": "Resp Group", "length": 104, "domain": null }, { "name": "RespUnitDesc", "type": "esriFieldTypeString", "alias": "RespnUnit", "length": 106, "domain": null }, { "name": "EffectiveDate", "type": "esriFieldTypeDate", "alias": "Effective Date", "length": 8, "domain": null }, { "name": "Shape", "type": "esriFieldTypeGeometry", "alias": "Shape", "domain": null }, { "name": "AssessormapCode", "type": "esriFieldTypeString", "alias": "AssessormapCode", "length": 13, "domain": null }, { "name": "AttachedParcel", "type": "esriFieldTypeString", "alias": "AttachedParcel", "length": 9, "domain": null }, { "name": "SitusAddress_Search", "type": "esriFieldTypeString", "alias": "SitusAddress_Search", "length": 255, "domain": null }, { "name": "SitusStreetNumber", "type": "esriFieldTypeString", "alias": "SitusStreetNumber", "length": 7, "domain": null }, { "name": "SitusStreetName", "type": "esriFieldTypeString", "alias": "SitusStreetName", "length": 20, "domain": null }, { "name": "SitusZipCode", "type": "esriFieldTypeString", "alias": "SitusZipCode", "length": 5, "domain": null }, { "name": "SitusCommunity", "type": "esriFieldTypeString", "alias": "SitusCommunity", "length": 20, "domain": null }, { "name": "SitusState", "type": "esriFieldTypeString", "alias": "SitusState", "length": 2, "domain": null }, { "name": "Page", "type": "esriFieldTypeString", "alias": "Page", "length": 3, "domain": null }, { "name": "BilledOwner2", "type": "esriFieldTypeString", "alias": "Owner 2", "length": 60, "domain": null } ], "geometryField": { "name": "Shape", "type": "esriFieldTypeGeometry", "alias": "Shape" }, "indexes": [ { "name": "R58_pk", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "S23_idx", "fields": "Shape", "isAscending": true, "isUnique": true, "description": "" } ], "subtypes": [], "relationships": [ { "id": 0, "name": "SBC_PUB.DBO.PAT_CurrentOwners", "relatedTableId": 1, "role": "esriRelRoleOrigin", "keyField": "Parcel", "cardinality": "esriRelCardinalityOneToMany", "composite": false }, { "id": 1, "name": "SBC_PUB.DBO.PAT_LegalTract", "relatedTableId": 2, "role": "esriRelRoleOrigin", "keyField": "Parcel", "cardinality": "esriRelCardinalityOneToMany", "composite": false }, { "id": 2, "name": "SBC_PUB.DBO.PAT_LegalReasonFChange", "relatedTableId": 3, "role": "esriRelRoleOrigin", "keyField": "Parcel", "cardinality": "esriRelCardinalityOneToMany", "composite": false }, { "id": 3, "name": "SBC_PUB.DBO.PAT_HoxRecords", "relatedTableId": 4, "role": "esriRelRoleOrigin", "keyField": "Parcel", "cardinality": "esriRelCardinalityOneToMany", "composite": false }, { "id": 4, "name": "SBC_PUB.DBO.PAT_RollValHistory", "relatedTableId": 5, "role": "esriRelRoleOrigin", "keyField": "Parcel", "cardinality": "esriRelCardinalityOneToMany", "composite": false }, { "id": 5, "name": "SBC_PUB.DBO.PAT_ParcelHistory", "relatedTableId": 6, "role": "esriRelRoleOrigin", "keyField": "Parcel", "cardinality": "esriRelCardinalityOneToMany", "composite": false }, { "id": 6, "name": "SBC_PUB.DBO.PAT_OwnerHistory", "relatedTableId": 7, "role": "esriRelRoleOrigin", "keyField": "Parcel", "cardinality": "esriRelCardinalityOneToMany", "composite": false }, { "id": 7, "name": "SBC_PUB.DBO.PAT_CharacteristicsLand", "relatedTableId": 9, "role": "esriRelRoleOrigin", "keyField": "Parcel", "cardinality": "esriRelCardinalityOneToMany", "composite": false }, { "id": 8, "name": "SBC_PUB.DBO.PAT_CharacteristicsSFR", "relatedTableId": 10, "role": "esriRelRoleOrigin", "keyField": "Parcel", "cardinality": "esriRelCardinalityOneToMany", "composite": false }, { "id": 9, "name": "SBC_PUB.DBO.PAT_CharacteristicsOther", "relatedTableId": 11, "role": "esriRelRoleOrigin", "keyField": "Parcel", "cardinality": "esriRelCardinalityOneToMany", "composite": false }, { "id": 10, "name": "SBC_PUB.dbo.PAT_SupplementsNew_INTERNAL", "relatedTableId": 12, "role": "esriRelRoleOrigin", "keyField": "Parcel", "cardinality": "esriRelCardinalityOneToMany", "composite": false }, { "id": 11, "name": "SBC_PUB.dbo.PAT_Taxable_Values_INTERNAL", "relatedTableId": 13, "role": "esriRelRoleOrigin", "keyField": "Parcel", "cardinality": "esriRelCardinalityOneToMany", "composite": false }, { "id": 12, "name": "SBC_PUB.dbo.PAT_Processed_Corr", "relatedTableId": 14, "role": "esriRelRoleOrigin", "keyField": "Parcel", "cardinality": "esriRelCardinalityOneToMany", "composite": false }, { "id": 13, "name": "SBC_PUB.dbo.PAT_NOPICS_INTERNAL", "relatedTableId": 15, "role": "esriRelRoleOrigin", "keyField": "Parcel", "cardinality": "esriRelCardinalityOneToMany", "composite": false }, { "id": 14, "name": "SBC_PUB.dbo.PAT_MailingAddr_INTERNAL", "relatedTableId": 16, "role": "esriRelRoleOrigin", "keyField": "Parcel", "cardinality": "esriRelCardinalityOneToMany", "composite": false }, { "id": 15, "name": "SBC_PUB.dbo.PAT_Notes_INTERNAL", "relatedTableId": 17, "role": "esriRelRoleOrigin", "keyField": "Parcel", "cardinality": "esriRelCardinalityOneToMany", "composite": false }, { "id": 16, "name": "SBC_PUB.DBO.PAT_SupplementHistory", "relatedTableId": 8, "role": "esriRelRoleOrigin", "keyField": "Parcel", "cardinality": "esriRelCardinalityOneToMany", "composite": false }, { "id": 17, "name": "SBC_PUB.dbo.PAT_Pending_Corrections_INTERNAL", "relatedTableId": 18, "role": "esriRelRoleOrigin", "keyField": "Parcel", "cardinality": "esriRelCardinalityOneToMany", "composite": false }, { "id": 18, "name": "SBC_PUB.dbo.PAT_LegalParcel", "relatedTableId": 19, "role": "esriRelRoleOrigin", "keyField": "Parcel", "cardinality": "esriRelCardinalityOneToMany", "composite": false } ], "canModifyLayer": true, "canScaleSymbols": false, "hasLabels": false, "capabilities": "Map,Query,Data", "maxRecordCount": 1000, "supportsStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON, 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, "dateFieldsTimeReference": null, "supportsCoordinatesQuantization": true } ], "tables": [ { "currentVersion": 10.71, "id": 1, "name": "Current Owners", "type": "Table", "description": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "Parcel", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "Parcel", "type": "esriFieldTypeString", "alias": "Parcel", "length": 13, "domain": null }, { "name": "Name", "type": "esriFieldTypeString", "alias": "Name", "length": 73, "domain": null }, { "name": "RI", "type": "esriFieldTypeString", "alias": "R/I", "length": 105, "domain": null }, { "name": "PrcInt", "type": "esriFieldTypeDouble", "alias": "%Int", "domain": null }, { "name": "Type_", "type": "esriFieldTypeString", "alias": "Type", "length": 104, "domain": null }, { "name": "OWNR_ACQUISITION", "type": "esriFieldTypeString", "alias": "Acquisition Date", "length": 10, "domain": null }, { "name": "OWNR_DOCUMENT", "type": "esriFieldTypeString", "alias": "Document Date", "length": 10, "domain": null }, { "name": "OWNR_THRU", "type": "esriFieldTypeString", "alias": "Inactive Date", "length": 10, "domain": null }, { "name": "DocumentNumbers", "type": "esriFieldTypeString", "alias": "Document Nbrs", "length": 4000, "domain": null } ], "indexes": [ { "name": "R34_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "ix_Parcel", "fields": "Parcel", "isAscending": true, "isUnique": false, "description": "" } ], "subtypes": [], "relationships": [ { "id": 0, "name": "SBC_PUB.DBO.PAT_PropertyInfo_INTERNAL", "relatedTableId": 0, "role": "esriRelRoleDestination", "keyField": "Parcel", "cardinality": "esriRelCardinalityOneToMany", "composite": false } ], "capabilities": "Map,Query,Data", "maxRecordCount": 1000, "supportsStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON", "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.71, "id": 2, "name": "Legal Tract Map", "type": "Table", "description": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "Parcel", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "Parcel", "type": "esriFieldTypeString", "alias": "Legal Parcel", "length": 13, "domain": null }, { "name": "Tract", "type": "esriFieldTypeString", "alias": "Legal Tract", "length": 10, "domain": null }, { "name": "Lot", "type": "esriFieldTypeString", "alias": "Legal Lot", "length": 5, "domain": null }, { "name": "Block", "type": "esriFieldTypeString", "alias": "Legal Block", "length": 3, "domain": null }, { "name": "ParcelMap", "type": "esriFieldTypeString", "alias": "Legal Map #", "length": 10, "domain": null }, { "name": "ParcelNbr", "type": "esriFieldTypeString", "alias": "Legal Parcel #", "length": 5, "domain": null }, { "name": "Unit", "type": "esriFieldTypeString", "alias": "Unit", "length": 5, "domain": null }, { "name": "Book", "type": "esriFieldTypeString", "alias": "Legal Book", "length": 3, "domain": null }, { "name": "Page", "type": "esriFieldTypeString", "alias": "Page", "length": 3, "domain": null }, { "name": "LegalDescription", "type": "esriFieldTypeString", "alias": "Legal Description", "length": 1073741822, "domain": null } ], "indexes": [ { "name": "R28_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "ix_Parcel", "fields": "Parcel", "isAscending": true, "isUnique": false, "description": "" } ], "subtypes": [], "relationships": [ { "id": 1, "name": "SBC_PUB.DBO.PAT_PropertyInfo_INTERNAL", "relatedTableId": 0, "role": "esriRelRoleDestination", "keyField": "Parcel", "cardinality": "esriRelCardinalityOneToMany", "composite": false } ], "capabilities": "Map,Query,Data", "maxRecordCount": 1000, "supportsStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON", "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.71, "id": 3, "name": "Legal Reason for Change", "type": "Table", "description": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "Parcel", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "Parcel", "type": "esriFieldTypeString", "alias": "Parcel", "length": 13, "domain": null }, { "name": "LegalRsnforChangeDesc", "type": "esriFieldTypeString", "alias": "Legal Reason For Change", "length": 106, "domain": null }, { "name": "DocumentNumber", "type": "esriFieldTypeString", "alias": "Document Number", "length": 13, "domain": null }, { "name": "RecordedDate", "type": "esriFieldTypeDate", "alias": "Recorded Date", "length": 8, "domain": null } ], "indexes": [ { "name": "R27_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "ix_Parcel", "fields": "Parcel", "isAscending": true, "isUnique": false, "description": "" } ], "subtypes": [], "relationships": [ { "id": 2, "name": "SBC_PUB.DBO.PAT_PropertyInfo_INTERNAL", "relatedTableId": 0, "role": "esriRelRoleDestination", "keyField": "Parcel", "cardinality": "esriRelCardinalityOneToMany", "composite": false } ], "capabilities": "Map,Query,Data", "maxRecordCount": 1000, "supportsStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON", "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.71, "id": 4, "name": "Hox Records", "type": "Table", "description": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "Parcel", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "Parcel", "type": "esriFieldTypeString", "alias": "Parcel", "length": 13, "domain": null }, { "name": "StatusDesc", "type": "esriFieldTypeString", "alias": "Status", "length": 105, "domain": null }, { "name": "EffectiveDate", "type": "esriFieldTypeString", "alias": "EffectivenDate", "length": 10, "domain": null }, { "name": "ThroughDate", "type": "esriFieldTypeString", "alias": "Through Date", "length": 10, "domain": null }, { "name": "ReturnedDate", "type": "esriFieldTypeString", "alias": "Returned Date", "length": 10, "domain": null }, { "name": "AcquiredDate", "type": "esriFieldTypeString", "alias": "Acquired Date", "length": 10, "domain": null }, { "name": "OccupiedDate", "type": "esriFieldTypeString", "alias": "Occupied Date", "length": 10, "domain": null }, { "name": "Dwellings", "type": "esriFieldTypeSmallInteger", "alias": "Dwellings", "domain": null } ], "indexes": [ { "name": "R25_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "ix_Parcel", "fields": "Parcel", "isAscending": true, "isUnique": false, "description": "" } ], "subtypes": [], "relationships": [ { "id": 3, "name": "SBC_PUB.DBO.PAT_PropertyInfo_INTERNAL", "relatedTableId": 0, "role": "esriRelRoleDestination", "keyField": "Parcel", "cardinality": "esriRelCardinalityOneToMany", "composite": false } ], "capabilities": "Map,Query,Data", "maxRecordCount": 1000, "supportsStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON", "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.71, "id": 5, "name": "Roll Values History", "type": "Table", "description": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "Parcel", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "Parcel", "type": "esriFieldTypeString", "alias": "Parcel", "length": 13, "domain": null }, { "name": "RollYear", "type": "esriFieldTypeString", "alias": "Roll Year", "length": 4, "domain": null }, { "name": "TRA", "type": "esriFieldTypeInteger", "alias": "TRA", "domain": null }, { "name": "Supplement", "type": "esriFieldTypeString", "alias": "Supplement", "length": 3, "domain": null }, { "name": "CorrectedDate", "type": "esriFieldTypeDate", "alias": "Corrected Date", "length": 8, "domain": null }, { "name": "CorrectedCode", "type": "esriFieldTypeString", "alias": "Corrected Code", "length": 4, "domain": null }, { "name": "billedname", "type": "esriFieldTypeString", "alias": "Billed Owner", "length": 72, "domain": null }, { "name": "jointowner", "type": "esriFieldTypeString", "alias": "Joint Owner", "length": 72, "domain": null }, { "name": "LandValue", "type": "esriFieldTypeDouble", "alias": "Land Value", "domain": null }, { "name": "ImprovementValue", "type": "esriFieldTypeDouble", "alias": "Improvement Value", "domain": null }, { "name": "ImprovementPenalty", "type": "esriFieldTypeDouble", "alias": "Improvement Penalty", "domain": null }, { "name": "PersonalPropertyValue", "type": "esriFieldTypeDouble", "alias": "Pers Prop Value", "domain": null }, { "name": "PersonalPropertyPenalty", "type": "esriFieldTypeDouble", "alias": "Pers Prop Penalty", "domain": null }, { "name": "TotalPenalties", "type": "esriFieldTypeDouble", "alias": "Total Penalties", "domain": null }, { "name": "TotalValue", "type": "esriFieldTypeDouble", "alias": "Total Value", "domain": null }, { "name": "HOXExemption", "type": "esriFieldTypeDouble", "alias": "HOX Exemption", "domain": null }, { "name": "SpecialExemptions", "type": "esriFieldTypeDouble", "alias": "Special Exemptions", "domain": null }, { "name": "NetValue", "type": "esriFieldTypeDouble", "alias": "Net Value", "domain": null }, { "name": "OriginalParcel", "type": "esriFieldTypeString", "alias": "Original Parcel", "length": 13, "domain": null } ], "indexes": [ { "name": "R26_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "ix_Parcel", "fields": "Parcel", "isAscending": true, "isUnique": false, "description": "" }, { "name": "ix_test", "fields": "Parcel,RollYear", "isAscending": true, "isUnique": false, "description": "" } ], "subtypes": [], "relationships": [ { "id": 4, "name": "SBC_PUB.DBO.PAT_PropertyInfo_INTERNAL", "relatedTableId": 0, "role": "esriRelRoleDestination", "keyField": "Parcel", "cardinality": "esriRelCardinalityOneToMany", "composite": false } ], "capabilities": "Map,Query,Data", "maxRecordCount": 1000, "supportsStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON", "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.71, "id": 6, "name": "Parcel History", "type": "Table", "description": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "Parcel", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "Parcel", "type": "esriFieldTypeString", "alias": "Parcel", "length": 13, "domain": null }, { "name": "EventDate", "type": "esriFieldTypeDate", "alias": "Event Date", "length": 8, "domain": null }, { "name": "EventGroupTypeDesc", "type": "esriFieldTypeString", "alias": "Event Group/Type", "length": 100, "domain": null }, { "name": "MultiParcelIND", "type": "esriFieldTypeString", "alias": "Multi Parcel", "length": 3, "domain": null }, { "name": "MultiParcel", "type": "esriFieldTypeString", "alias": "Multi Parcel List", "length": 21, "domain": null } ], "indexes": [ { "name": "R43_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "ix_ParcelNumber", "fields": "Parcel", "isAscending": true, "isUnique": false, "description": "" } ], "subtypes": [], "relationships": [ { "id": 5, "name": "SBC_PUB.DBO.PAT_PropertyInfo_INTERNAL", "relatedTableId": 0, "role": "esriRelRoleDestination", "keyField": "Parcel", "cardinality": "esriRelCardinalityOneToMany", "composite": false } ], "capabilities": "Map,Query,Data", "maxRecordCount": 1000, "supportsStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON", "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.71, "id": 7, "name": "Owner History", "type": "Table", "description": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "Parcel", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "Parcel", "type": "esriFieldTypeString", "alias": "Parcel", "length": 13, "domain": null }, { "name": "Name", "type": "esriFieldTypeString", "alias": "Name", "length": 73, "domain": null }, { "name": "RIDesc", "type": "esriFieldTypeString", "alias": "R/I", "length": 105, "domain": null }, { "name": "Int_", "type": "esriFieldTypeDouble", "alias": "% Int", "domain": null }, { "name": "TypeDesc", "type": "esriFieldTypeString", "alias": "Type", "length": 104, "domain": null }, { "name": "OWNR_OWNR_SEQ", "type": "esriFieldTypeSmallInteger", "alias": "OWNR_OWNR_SEQ", "domain": null }, { "name": "AcquisitionDate", "type": "esriFieldTypeString", "alias": "Acquisition Date", "length": 10, "domain": null }, { "name": "DocumentDate", "type": "esriFieldTypeString", "alias": "Document Date", "length": 10, "domain": null }, { "name": "OrigInactiveDate", "type": "esriFieldTypeString", "alias": "OrigInactive Date", "length": 10, "domain": null }, { "name": "DocumentNumber", "type": "esriFieldTypeString", "alias": "Document Number", "length": 4000, "domain": null }, { "name": "ExclType", "type": "esriFieldTypeString", "alias": "ExclType", "length": 3, "domain": null }, { "name": "ExclStatus", "type": "esriFieldTypeString", "alias": "ExclStatus", "length": 1, "domain": null } ], "indexes": [ { "name": "R37_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "ix_Parcel", "fields": "Parcel", "isAscending": true, "isUnique": false, "description": "" }, { "name": "ix_parce_seq", "fields": "Parcel,OWNR_OWNR_SEQ", "isAscending": true, "isUnique": false, "description": "" } ], "subtypes": [], "relationships": [ { "id": 6, "name": "SBC_PUB.DBO.PAT_PropertyInfo_INTERNAL", "relatedTableId": 0, "role": "esriRelRoleDestination", "keyField": "Parcel", "cardinality": "esriRelCardinalityOneToMany", "composite": false } ], "capabilities": "Map,Query,Data", "maxRecordCount": 1000, "supportsStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON", "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.71, "id": 8, "name": "Supplement History", "type": "Table", "description": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "Parcel", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "Parcel", "type": "esriFieldTypeString", "alias": "Parcel", "length": 13, "domain": null }, { "name": "SuplementDate", "type": "esriFieldTypeString", "alias": "Suplement Date", "length": 10, "domain": null }, { "name": "RollTypeDesc", "type": "esriFieldTypeString", "alias": "Roll Type", "length": 106, "domain": null }, { "name": "SuplementTypeDesc", "type": "esriFieldTypeString", "alias": "Suplement Type", "length": 106, "domain": null }, { "name": "RevisedIND", "type": "esriFieldTypeString", "alias": "Revised IND", "length": 1, "domain": null }, { "name": "CorrectedDate", "type": "esriFieldTypeString", "alias": "Corrected Date", "length": 10, "domain": null }, { "name": "CorrectionCode", "type": "esriFieldTypeString", "alias": "Correction Code", "length": 4, "domain": null }, { "name": "SupplementYear", "type": "esriFieldTypeString", "alias": "Supplement Year", "length": 4, "domain": null }, { "name": "LegalStatus", "type": "esriFieldTypeString", "alias": "Legal Status", "length": 9, "domain": null }, { "name": "TRA", "type": "esriFieldTypeInteger", "alias": "TRA", "domain": null }, { "name": "BilliedOwner", "type": "esriFieldTypeString", "alias": "Billied Owner", "length": 72, "domain": null }, { "name": "JointOwner", "type": "esriFieldTypeString", "alias": "Joint Owner", "length": 72, "domain": null }, { "name": "NewLand", "type": "esriFieldTypeDouble", "alias": "New Land", "domain": null }, { "name": "NEwImprovement", "type": "esriFieldTypeDouble", "alias": "New Improvement", "domain": null }, { "name": "OldLand", "type": "esriFieldTypeDouble", "alias": "Old Land", "domain": null }, { "name": "OldImprovement", "type": "esriFieldTypeDouble", "alias": "Old Improvement", "domain": null }, { "name": "NewHox", "type": "esriFieldTypeDouble", "alias": "New Hox", "domain": null }, { "name": "OldHox", "type": "esriFieldTypeDouble", "alias": "Old Hox", "domain": null }, { "name": "SuppHox", "type": "esriFieldTypeDouble", "alias": "Supp Hox", "domain": null }, { "name": "SpecialExemptions", "type": "esriFieldTypeDouble", "alias": "Special Exemptions", "domain": null }, { "name": "ImproPenalty", "type": "esriFieldTypeDouble", "alias": "Improvements Penalty", "domain": null }, { "name": "PriorSupps", "type": "esriFieldTypeDouble", "alias": "Prior Supps", "domain": null }, { "name": "ConstinProgress", "type": "esriFieldTypeDouble", "alias": "Construction In Progress", "domain": null }, { "name": "PSUP_NET_VALUE", "type": "esriFieldTypeDouble", "alias": "Net Value", "domain": null }, { "name": "MonthsProrated", "type": "esriFieldTypeSmallInteger", "alias": "Months Prorated", "domain": null }, { "name": "NopicDate", "type": "esriFieldTypeString", "alias": "NOPIC Date", "length": 10, "domain": null }, { "name": "ExtractDate", "type": "esriFieldTypeString", "alias": "Extract Date", "length": 10, "domain": null }, { "name": "CorrStatus", "type": "esriFieldTypeString", "alias": "Corr Status", "length": 3, "domain": null }, { "name": "OriginalParcel", "type": "esriFieldTypeString", "alias": "Original Parcel", "length": 13, "domain": null }, { "name": "SpclExmTyp1", "type": "esriFieldTypeString", "alias": "Special Exemption Type 1", "length": 2, "domain": null }, { "name": "SpclExm1", "type": "esriFieldTypeDouble", "alias": "Special Exemption 1", "domain": null }, { "name": "SpclExmTyp2", "type": "esriFieldTypeString", "alias": "Special Exemption Type 2", "length": 2, "domain": null }, { "name": "SpclExm2", "type": "esriFieldTypeString", "alias": "Special Exemption 2", "length": 2, "domain": null }, { "name": "SupplementSortKey", "type": "esriFieldTypeDate", "alias": "Supplement Sort Key", "length": 8, "domain": null } ], "indexes": [ { "name": "R24_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "ix_Parcel", "fields": "Parcel", "isAscending": true, "isUnique": false, "description": "" } ], "subtypes": [], "relationships": [ { "id": 16, "name": "SBC_PUB.DBO.PAT_PropertyInfo_INTERNAL", "relatedTableId": 0, "role": "esriRelRoleDestination", "keyField": "Parcel", "cardinality": "esriRelCardinalityOneToMany", "composite": false } ], "capabilities": "Map,Query,Data", "maxRecordCount": 1000, "supportsStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON", "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.71, "id": 9, "name": "Land Characteristics", "type": "Table", "description": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "Parcel", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "Parcel", "type": "esriFieldTypeString", "alias": "Parcel", "length": 13, "domain": null }, { "name": "EffectiveDateFrom", "type": "esriFieldTypeString", "alias": "Effective Date From", "length": 10, "domain": null }, { "name": "EffectiveDateto", "type": "esriFieldTypeString", "alias": "Effective Date to", "length": 10, "domain": null }, { "name": "Zoning", "type": "esriFieldTypeString", "alias": "Zoning", "length": 8, "domain": null }, { "name": "LotWidth", "type": "esriFieldTypeDouble", "alias": "Lot Width", "domain": null }, { "name": "LotDepth", "type": "esriFieldTypeDouble", "alias": "Lot Depth", "domain": null }, { "name": "Footage", "type": "esriFieldTypeInteger", "alias": "Footage", "domain": null }, { "name": "GrossAcre", "type": "esriFieldTypeDouble", "alias": "Gross Acre", "domain": null }, { "name": "NetAcre", "type": "esriFieldTypeDouble", "alias": "Net Acre", "domain": null }, { "name": "AccessDesc", "type": "esriFieldTypeString", "alias": "Access", "length": 144, "domain": null }, { "name": "SlopeDirectionDesc", "type": "esriFieldTypeString", "alias": "Slope Dir", "length": 104, "domain": null }, { "name": "SlopeDegreeDesc", "type": "esriFieldTypeString", "alias": "Slope Degree", "length": 144, "domain": null }, { "name": "ViewQualityDesc", "type": "esriFieldTypeString", "alias": "View Quality", "length": 144, "domain": null }, { "name": "ViewTypeDesc", "type": "esriFieldTypeString", "alias": "View Type", "length": 104, "domain": null }, { "name": "SewerDesc", "type": "esriFieldTypeString", "alias": "Sewer", "length": 104, "domain": null }, { "name": "WaterDesc", "type": "esriFieldTypeString", "alias": "Water", "length": 104, "domain": null }, { "name": "ElectricityDesc", "type": "esriFieldTypeString", "alias": "Elec.", "length": 104, "domain": null }, { "name": "GasDesc", "type": "esriFieldTypeString", "alias": "Gas", "length": 104, "domain": null }, { "name": "OffsiteDesc", "type": "esriFieldTypeString", "alias": "Offsite", "length": 104, "domain": null }, { "name": "EncroachmentDesc", "type": "esriFieldTypeString", "alias": "Enc/Eas", "length": 104, "domain": null }, { "name": "Nuisance1Desc", "type": "esriFieldTypeString", "alias": "Nuisance1", "length": 144, "domain": null }, { "name": "Nuisance2Desc", "type": "esriFieldTypeString", "alias": "Nuisance2", "length": 144, "domain": null }, { "name": "SpecialInfluence1Desc", "type": "esriFieldTypeString", "alias": "Spc Infl1", "length": 144, "domain": null }, { "name": "SpecialInfluence2Desc", "type": "esriFieldTypeString", "alias": "Spc Infl2", "length": 144, "domain": null }, { "name": "DockRightsDesc", "type": "esriFieldTypeString", "alias": "Dock Rts", "length": 104, "domain": null }, { "name": "LeaseExp", "type": "esriFieldTypeDate", "alias": "Lease Exp", "length": 8, "domain": null } ], "indexes": [ { "name": "R20_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "ix_Parcel", "fields": "Parcel", "isAscending": true, "isUnique": false, "description": "" } ], "subtypes": [], "relationships": [ { "id": 7, "name": "SBC_PUB.DBO.PAT_PropertyInfo_INTERNAL", "relatedTableId": 0, "role": "esriRelRoleDestination", "keyField": "Parcel", "cardinality": "esriRelCardinalityOneToMany", "composite": false } ], "capabilities": "Map,Query,Data", "maxRecordCount": 1000, "supportsStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON", "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.71, "id": 10, "name": "SFR Characteristics", "type": "Table", "description": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "Parcel", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "Parcel", "type": "esriFieldTypeString", "alias": "Parcel", "length": 13, "domain": null }, { "name": "EffectiveDateFrom", "type": "esriFieldTypeString", "alias": "Effective Date From", "length": 10, "domain": null }, { "name": "EffectiveDateto", "type": "esriFieldTypeString", "alias": "Effective Date to", "length": 10, "domain": null }, { "name": "Sqnce", "type": "esriFieldTypeSmallInteger", "alias": "Sequence", "domain": null }, { "name": "ConstType", "type": "esriFieldTypeString", "alias": "Const Type", "length": 1, "domain": null }, { "name": "QualityDesc", "type": "esriFieldTypeString", "alias": "Quality", "length": 146, "domain": null }, { "name": "Shape", "type": "esriFieldTypeString", "alias": "Shape", "length": 1, "domain": null }, { "name": "OtherSFAddressln1", "type": "esriFieldTypeString", "alias": "SFR Addressln1", "length": 41, "domain": null }, { "name": "OtherSFAddressln2", "type": "esriFieldTypeString", "alias": "SFR Addressln2", "length": 27, "domain": null }, { "name": "CostTableDesc", "type": "esriFieldTypeString", "alias": "Cost Table", "length": 105, "domain": null }, { "name": "MHMakeDesc", "type": "esriFieldTypeString", "alias": "MH Make", "length": 106, "domain": null }, { "name": "Size_", "type": "esriFieldTypeInteger", "alias": "Size", "domain": null }, { "name": "ConstYear", "type": "esriFieldTypeString", "alias": "Const Year", "length": 4, "domain": null }, { "name": "EffYear", "type": "esriFieldTypeSmallInteger", "alias": "Eff Year", "domain": null }, { "name": "NumberofBath", "type": "esriFieldTypeString", "alias": "Nbr Bath", "length": 50, "domain": null }, { "name": "NumberofBed", "type": "esriFieldTypeSmallInteger", "alias": "Nbr Bdrm", "domain": null }, { "name": "FamilyDen", "type": "esriFieldTypeSmallInteger", "alias": "Family Den", "domain": null }, { "name": "TotalRooms", "type": "esriFieldTypeSmallInteger", "alias": "Total Rooms", "domain": null }, { "name": "RoofTypeDesc", "type": "esriFieldTypeString", "alias": "Roof Type", "length": 104, "domain": null }, { "name": "LandscapeDesc", "type": "esriFieldTypeString", "alias": "Landscape Quality", "length": 144, "domain": null }, { "name": "FobsoDesc", "type": "esriFieldTypeString", "alias": "Func Obs", "length": 104, "domain": null }, { "name": "TMSSeasonDesc", "type": "esriFieldTypeString", "alias": "TMS Season", "length": 105, "domain": null }, { "name": "CostMod", "type": "esriFieldTypeSmallInteger", "alias": "Cost Mod", "domain": null }, { "name": "FunctionalObsoPct", "type": "esriFieldTypeSmallInteger", "alias": "Fun Obs pct", "domain": null }, { "name": "EcoObsoPct", "type": "esriFieldTypeSmallInteger", "alias": "Eco Obso Pct", "domain": null }, { "name": "DefrMaintenance", "type": "esriFieldTypeInteger", "alias": "Defr Maint", "domain": null }, { "name": "Floor1Size", "type": "esriFieldTypeInteger", "alias": "Floor1 Size", "domain": null }, { "name": "Floor2Size", "type": "esriFieldTypeInteger", "alias": "Floor2 Size", "domain": null }, { "name": "Floor2Factor", "type": "esriFieldTypeSmallInteger", "alias": "Floor2 Factor", "domain": null }, { "name": "Floor3Size", "type": "esriFieldTypeInteger", "alias": "Floor3 Size", "domain": null }, { "name": "Floor3Factor", "type": "esriFieldTypeSmallInteger", "alias": "Floor3 Factor", "domain": null }, { "name": "Bas1Size", "type": "esriFieldTypeInteger", "alias": "Bas1 Size", "domain": null }, { "name": "Bas1Factor", "type": "esriFieldTypeSmallInteger", "alias": "Bas1 Factor", "domain": null }, { "name": "Bas2Size", "type": "esriFieldTypeInteger", "alias": "Bas2 Size", "domain": null }, { "name": "Bas2Factor", "type": "esriFieldTypeSmallInteger", "alias": "Bas2 Factor", "domain": null }, { "name": "Add1Size", "type": "esriFieldTypeInteger", "alias": "Add1 Size", "domain": null }, { "name": "Add1Factor", "type": "esriFieldTypeSmallInteger", "alias": "Add1 Factor", "domain": null }, { "name": "Add2Size", "type": "esriFieldTypeInteger", "alias": "Add2 Size", "domain": null }, { "name": "Add2Factor", "type": "esriFieldTypeSmallInteger", "alias": "Add2 Factor", "domain": null }, { "name": "Add3Size", "type": "esriFieldTypeInteger", "alias": "Add3 Size", "domain": null }, { "name": "Add3Factor", "type": "esriFieldTypeSmallInteger", "alias": "Add3 Factor", "domain": null }, { "name": "Pch1Size", "type": "esriFieldTypeInteger", "alias": "Pch1 Size", "domain": null }, { "name": "Pch1Factor", "type": "esriFieldTypeSmallInteger", "alias": "Pch1 Factor", "domain": null }, { "name": "Pch2Size", "type": "esriFieldTypeInteger", "alias": "Pch2 Size", "domain": null }, { "name": "Pch2Factor", "type": "esriFieldTypeSmallInteger", "alias": "Pch2 Factor", "domain": null }, { "name": "Pch3Size", "type": "esriFieldTypeInteger", "alias": "Pch3 Size", "domain": null }, { "name": "Pch3Factor", "type": "esriFieldTypeSmallInteger", "alias": "Pch3 Factor", "domain": null }, { "name": "DeckSQF", "type": "esriFieldTypeInteger", "alias": "Deck SQF", "domain": null }, { "name": "DeckFactor", "type": "esriFieldTypeSmallInteger", "alias": "Deck Factor", "domain": null }, { "name": "DeckStall", "type": "esriFieldTypeSmallInteger", "alias": "Deck Stall", "domain": null }, { "name": "PortSQF", "type": "esriFieldTypeInteger", "alias": "Port SQF", "domain": null }, { "name": "PortFactor", "type": "esriFieldTypeSmallInteger", "alias": "Port Factor", "domain": null }, { "name": "PortStall", "type": "esriFieldTypeSmallInteger", "alias": "Port Stall", "domain": null }, { "name": "GarageSQF", "type": "esriFieldTypeInteger", "alias": "Garage SQF", "domain": null }, { "name": "GarageClassDesc", "type": "esriFieldTypeString", "alias": "Garage Class", "length": 106, "domain": null }, { "name": "GarageStall", "type": "esriFieldTypeSmallInteger", "alias": "Garage Stall", "domain": null }, { "name": "ACRcn", "type": "esriFieldTypeInteger", "alias": "AC Rcn", "domain": null }, { "name": "HeatDesc", "type": "esriFieldTypeString", "alias": "Heat", "length": 104, "domain": null }, { "name": "CoolDesc", "type": "esriFieldTypeString", "alias": "Cool", "length": 104, "domain": null }, { "name": "FireplaceRcn", "type": "esriFieldTypeInteger", "alias": "Fireplace Rcn", "domain": null }, { "name": "NoofFireplaces", "type": "esriFieldTypeSmallInteger", "alias": "Nbr Fireplaces", "domain": null }, { "name": "YardImpRcn", "type": "esriFieldTypeInteger", "alias": "Yard Imp Rcn", "domain": null }, { "name": "MiscRcn", "type": "esriFieldTypeInteger", "alias": "Misc. Rcn", "domain": null }, { "name": "PoolRcn", "type": "esriFieldTypeInteger", "alias": "Pool Rcn", "domain": null }, { "name": "PoolTypeDesc", "type": "esriFieldTypeString", "alias": "Pool Type", "length": 144, "domain": null }, { "name": "SpecialImpRcn", "type": "esriFieldTypeInteger", "alias": "spc Imp Rcn", "domain": null }, { "name": "SpecialImp1Desc", "type": "esriFieldTypeString", "alias": "Spc Imp1", "length": 105, "domain": null }, { "name": "SpecialImp2Desc", "type": "esriFieldTypeString", "alias": "Spc Imp2", "length": 105, "domain": null }, { "name": "SpecialImp3Desc", "type": "esriFieldTypeString", "alias": "Spc Imp3", "length": 105, "domain": null }, { "name": "MHSlidingDesc", "type": "esriFieldTypeString", "alias": "MH Sliding", "length": 104, "domain": null }, { "name": "MHFndLf", "type": "esriFieldTypeSmallInteger", "alias": "MH Fnd Lf", "domain": null }, { "name": "MHFndTypeDesc", "type": "esriFieldTypeString", "alias": "MH Fnd Typ", "length": 104, "domain": null }, { "name": "MHSkirtLf", "type": "esriFieldTypeSmallInteger", "alias": "MH Skirt Lf", "domain": null }, { "name": "MHSkirtTypeDesc", "type": "esriFieldTypeString", "alias": "MH Skrt Typ", "length": 104, "domain": null } ], "indexes": [ { "name": "R22_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "ix_Parcel", "fields": "Parcel", "isAscending": true, "isUnique": false, "description": "" } ], "subtypes": [], "relationships": [ { "id": 8, "name": "SBC_PUB.DBO.PAT_PropertyInfo_INTERNAL", "relatedTableId": 0, "role": "esriRelRoleDestination", "keyField": "Parcel", "cardinality": "esriRelCardinalityOneToMany", "composite": false } ], "capabilities": "Map,Query,Data", "maxRecordCount": 1000, "supportsStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON", "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.71, "id": 11, "name": "Other Characteristics", "type": "Table", "description": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "Parcel", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "Parcel", "type": "esriFieldTypeString", "alias": "Parcel", "length": 50, "domain": null }, { "name": "EffectiveDateFrom", "type": "esriFieldTypeString", "alias": "Effective Date From", "length": 10, "domain": null }, { "name": "EffectiveDateto", "type": "esriFieldTypeString", "alias": "Effective Date to", "length": 10, "domain": null }, { "name": "Sqnce", "type": "esriFieldTypeSmallInteger", "alias": "Sequence", "domain": null }, { "name": "OtherLocation", "type": "esriFieldTypeString", "alias": "Location", "length": 50, "domain": null }, { "name": "OtherSOAddressln1", "type": "esriFieldTypeString", "alias": "Addressln1", "length": 49, "domain": null }, { "name": "OtherSOAddressln2", "type": "esriFieldTypeString", "alias": "Addressln2", "length": 29, "domain": null }, { "name": "OtherUseDesc", "type": "esriFieldTypeString", "alias": "Use", "length": 153, "domain": null }, { "name": "StrucQuality", "type": "esriFieldTypeString", "alias": "Struc Quality", "length": 50, "domain": null }, { "name": "StrucType", "type": "esriFieldTypeString", "alias": "Struc Type", "length": 50, "domain": null }, { "name": "GroLease", "type": "esriFieldTypeInteger", "alias": "Gro Lease", "domain": null }, { "name": "NetLease", "type": "esriFieldTypeInteger", "alias": "Net Lease", "domain": null }, { "name": "ConstYear", "type": "esriFieldTypeString", "alias": "Const. Year", "length": 50, "domain": null }, { "name": "EffYear", "type": "esriFieldTypeSmallInteger", "alias": "Eff Year", "domain": null }, { "name": "NbrUnits", "type": "esriFieldTypeSmallInteger", "alias": "Nbr Units", "domain": null }, { "name": "AdjSFUnits", "type": "esriFieldTypeInteger", "alias": "Adj. SF Units", "domain": null }, { "name": "NBRStories", "type": "esriFieldTypeSmallInteger", "alias": "# Stories", "domain": null }, { "name": "StoryHeight", "type": "esriFieldTypeSmallInteger", "alias": "Story Height", "domain": null }, { "name": "Elevator", "type": "esriFieldTypeSmallInteger", "alias": "Elevator", "domain": null }, { "name": "LandScapeDesc", "type": "esriFieldTypeString", "alias": "Land Scape", "length": 153, "domain": null }, { "name": "FuncObsoDesc", "type": "esriFieldTypeString", "alias": "Func. Obs", "length": 153, "domain": null }, { "name": "AdjLBRate", "type": "esriFieldTypeSingle", "alias": "Adj LB Rate", "domain": null }, { "name": "LeaseExp", "type": "esriFieldTypeDate", "alias": "Lease Exp", "length": 8, "domain": null }, { "name": "Apt1Units", "type": "esriFieldTypeSmallInteger", "alias": "Apt 1 Units", "domain": null }, { "name": "Apt1Bdrm", "type": "esriFieldTypeSmallInteger", "alias": "Apt 1 Bdrm", "domain": null }, { "name": "Apt1Bath", "type": "esriFieldTypeSingle", "alias": "Apt 1 Bath", "domain": null }, { "name": "Apt2Units", "type": "esriFieldTypeSmallInteger", "alias": "Apt 2 Units", "domain": null }, { "name": "Apt2Bdrm", "type": "esriFieldTypeSmallInteger", "alias": "Apt 2 Bdrm", "domain": null }, { "name": "Apt2Bath", "type": "esriFieldTypeSingle", "alias": "Apt 2 Bath", "domain": null }, { "name": "Apt3Units", "type": "esriFieldTypeSmallInteger", "alias": "Apt 3 Units", "domain": null }, { "name": "Apt3Bdrm", "type": "esriFieldTypeSmallInteger", "alias": "Apt 3 Bdrm", "domain": null }, { "name": "Apt3Bath", "type": "esriFieldTypeSingle", "alias": "Apt 3 Bath", "domain": null }, { "name": "Apt4Units", "type": "esriFieldTypeSmallInteger", "alias": "Apt 4 Units", "domain": null }, { "name": "Apt4Bdrm", "type": "esriFieldTypeSmallInteger", "alias": "Apt 4 Bdrm", "domain": null }, { "name": "Apt4Bath", "type": "esriFieldTypeSingle", "alias": "Apt 4 Bath", "domain": null }, { "name": "Apt5Units", "type": "esriFieldTypeSmallInteger", "alias": "Apt 5 Units", "domain": null }, { "name": "Apt5Bdrm", "type": "esriFieldTypeSmallInteger", "alias": "Apt 5 Bdrm", "domain": null }, { "name": "Apt5Bath", "type": "esriFieldTypeSingle", "alias": "Apt 5 Bath", "domain": null }, { "name": "Garage", "type": "esriFieldTypeSmallInteger", "alias": "Garage", "domain": null }, { "name": "CarPort", "type": "esriFieldTypeSmallInteger", "alias": "Car Port", "domain": null }, { "name": "OpenSpaces", "type": "esriFieldTypeSmallInteger", "alias": "Open Spaces", "domain": null }, { "name": "RVSpaces", "type": "esriFieldTypeSmallInteger", "alias": "RV Spaces", "domain": null }, { "name": "LaundryDesc", "type": "esriFieldTypeString", "alias": "Laundry", "length": 153, "domain": null }, { "name": "RecBldgDesc", "type": "esriFieldTypeString", "alias": "Rec Bldg", "length": 153, "domain": null }, { "name": "AptPoolDesc", "type": "esriFieldTypeString", "alias": "Apt Pool", "length": 153, "domain": null }, { "name": "AptSpaDesc", "type": "esriFieldTypeString", "alias": "Apt Spa", "length": 153, "domain": null }, { "name": "TennisDesc", "type": "esriFieldTypeString", "alias": "Tennis", "length": 153, "domain": null }, { "name": "SecurityGateDesc", "type": "esriFieldTypeString", "alias": "Security Gate", "length": 153, "domain": null }, { "name": "OfficePercent", "type": "esriFieldTypeSmallInteger", "alias": "Office Percent", "domain": null }, { "name": "MezzSQF", "type": "esriFieldTypeInteger", "alias": "Mezz SQF", "domain": null }, { "name": "RestaurantDesc", "type": "esriFieldTypeString", "alias": "Restaurant", "length": 153, "domain": null }, { "name": "HotelPoolDesc", "type": "esriFieldTypeString", "alias": "Hotel Pool", "length": 153, "domain": null }, { "name": "HotelSpaDesc", "type": "esriFieldTypeString", "alias": "Hotel Spa", "length": 153, "domain": null }, { "name": "ConfRoomDesc", "type": "esriFieldTypeString", "alias": "Conf. Room", "length": 153, "domain": null } ], "indexes": [ { "name": "R31_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "ix_Parcel", "fields": "Parcel", "isAscending": true, "isUnique": false, "description": "" } ], "subtypes": [], "relationships": [ { "id": 9, "name": "SBC_PUB.DBO.PAT_PropertyInfo_INTERNAL", "relatedTableId": 0, "role": "esriRelRoleDestination", "keyField": "Parcel", "cardinality": "esriRelCardinalityOneToMany", "composite": false } ], "capabilities": "Map,Query,Data", "maxRecordCount": 1000, "supportsStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON", "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.71, "id": 12, "name": "Supplemental Roll Values New", "type": "Table", "description": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "NSUP_PARCEL_NBR", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "NSUP_PARCEL_NBR", "type": "esriFieldTypeString", "alias": "Parcel Number", "length": 13, "domain": null }, { "name": "NSUP_SUPPLEMENT", "type": "esriFieldTypeDate", "alias": "Supplement", "length": 8, "domain": null }, { "name": "RollType", "type": "esriFieldTypeString", "alias": "Roll Type", "length": 3, "domain": null }, { "name": "RollTypeDesc", "type": "esriFieldTypeString", "alias": "Roll Type", "length": 255, "domain": null }, { "name": "SuppYear", "type": "esriFieldTypeString", "alias": "Supplement Year", "length": 4, "domain": null }, { "name": "SuppType", "type": "esriFieldTypeString", "alias": "Supplement Type", "length": 3, "domain": null }, { "name": "SuppTypeDesc", "type": "esriFieldTypeString", "alias": "Supplement Type", "length": 255, "domain": null }, { "name": "NSUP_BIL_OWN_SEQ", "type": "esriFieldTypeSmallInteger", "alias": "Billed Owner Sequence", "domain": null }, { "name": "NSUP_JNT_OWN_SEQ", "type": "esriFieldTypeSmallInteger", "alias": "Joint Owner Sequence", "domain": null }, { "name": "NSUP_NEW_VAL_SEQ", "type": "esriFieldTypeSmallInteger", "alias": "New Value Sequence", "domain": null }, { "name": "NSUP_OLD_VAL_SEQ", "type": "esriFieldTypeSmallInteger", "alias": "Old Value Sequence", "domain": null }, { "name": "NSUP_LAND_VALUE", "type": "esriFieldTypeDouble", "alias": "Land Value", "domain": null }, { "name": "NewImprovement", "type": "esriFieldTypeDouble", "alias": "New Improvement", "domain": null }, { "name": "OldLand", "type": "esriFieldTypeDouble", "alias": "Old Land", "domain": null }, { "name": "OldImprovement", "type": "esriFieldTypeDouble", "alias": "Old Improvement", "domain": null }, { "name": "NewHOX", "type": "esriFieldTypeDouble", "alias": "New HOX", "domain": null }, { "name": "OldHOX", "type": "esriFieldTypeDouble", "alias": "Old HOX", "domain": null }, { "name": "SuppHOX", "type": "esriFieldTypeDouble", "alias": "Supp HOX", "domain": null }, { "name": "SpclExmAmt1", "type": "esriFieldTypeDouble", "alias": "Special Exemption Amount 1", "domain": null }, { "name": "SpclExmType1", "type": "esriFieldTypeString", "alias": "Special Exemption Type 1", "length": 2, "domain": null }, { "name": "Exem1TypeDesc", "type": "esriFieldTypeString", "alias": "Exemption 1 Description", "length": 255, "domain": null }, { "name": "SpclExmAmt2", "type": "esriFieldTypeDouble", "alias": "Special Exemption Amount 2", "domain": null }, { "name": "SpclExmType2", "type": "esriFieldTypeString", "alias": "Special Exemption Type 2", "length": 2, "domain": null }, { "name": "Exem2TypeDesc", "type": "esriFieldTypeString", "alias": "Exemption 2 Description", "length": 255, "domain": null }, { "name": "PriorSupps", "type": "esriFieldTypeDouble", "alias": "Prior Supplements", "domain": null }, { "name": "NetValue", "type": "esriFieldTypeDouble", "alias": "Net Value", "domain": null }, { "name": "NetChange", "type": "esriFieldTypeDouble", "alias": "Net Change", "domain": null }, { "name": "NSUP_LAST_CHANGE", "type": "esriFieldTypeDate", "alias": "Last Change Date", "length": 8, "domain": null }, { "name": "NSUP_BUILT", "type": "esriFieldTypeDate", "alias": "Built", "length": 8, "domain": null }, { "name": "NOPICDate", "type": "esriFieldTypeDate", "alias": "NOPIC Date", "length": 8, "domain": null }, { "name": "NSUP_NOPIC_SEQ", "type": "esriFieldTypeSmallInteger", "alias": "NOPIC Sequence", "domain": null }, { "name": "ConstructionInProgress", "type": "esriFieldTypeDouble", "alias": "Construction In Progress", "domain": null }, { "name": "BilledOwner", "type": "esriFieldTypeString", "alias": "Billed Owner", "length": 255, "domain": null }, { "name": "SuppValue", "type": "esriFieldTypeDouble", "alias": "Supp Value", "domain": null }, { "name": "JointOwner", "type": "esriFieldTypeString", "alias": "Joint Owner", "length": 255, "domain": null } ], "indexes": null, "subtypes": [], "relationships": [ { "id": 10, "name": "SBC_PUB.DBO.PAT_PropertyInfo_INTERNAL", "relatedTableId": 0, "role": "esriRelRoleDestination", "keyField": "NSUP_PARCEL_NBR", "cardinality": "esriRelCardinalityOneToMany", "composite": false } ], "capabilities": "Map,Query,Data", "maxRecordCount": 1000, "supportsStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON", "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.71, "id": 13, "name": "Taxable Values", "type": "Table", "description": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "VALU_PARCEL_NBR", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "VALU_PARCEL_NBR", "type": "esriFieldTypeString", "alias": "VALU_PARCEL_NBR", "length": 13, "domain": null }, { "name": "VALU_CHG_SEQ", "type": "esriFieldTypeSmallInteger", "alias": "VALU_CHG_SEQ", "domain": null }, { "name": "RevInd", "type": "esriFieldTypeString", "alias": "Rev Ind", "length": 1, "domain": null }, { "name": "EventDate", "type": "esriFieldTypeDate", "alias": "Event Date", "length": 8, "domain": null }, { "name": "VALU_EVENT_KEY", "type": "esriFieldTypeDate", "alias": "VALU_EVENT_KEY", "length": 8, "domain": null }, { "name": "EventDesc", "type": "esriFieldTypeString", "alias": "Event Description", "length": 255, "domain": null }, { "name": "ChgType", "type": "esriFieldTypeString", "alias": "Change Type", "length": 2, "domain": null }, { "name": "ChgDesc", "type": "esriFieldTypeString", "alias": "Change Description", "length": 255, "domain": null }, { "name": "Land", "type": "esriFieldTypeDouble", "alias": "Land", "domain": null }, { "name": "Impr", "type": "esriFieldTypeDouble", "alias": "Improvement", "domain": null }, { "name": "PersProp", "type": "esriFieldTypeDouble", "alias": "Pers Prop", "domain": null }, { "name": "Total", "type": "esriFieldTypeDouble", "alias": "Total", "domain": null }, { "name": "VALU_SUPP_IND", "type": "esriFieldTypeString", "alias": "VALU_SUPP_IND", "length": 1, "domain": null }, { "name": "Appr", "type": "esriFieldTypeString", "alias": "Appr", "length": 3, "domain": null }, { "name": "PostDate", "type": "esriFieldTypeDate", "alias": "Post Date", "length": 8, "domain": null }, { "name": "UserID", "type": "esriFieldTypeString", "alias": "User ID", "length": 8, "domain": null } ], "indexes": null, "subtypes": [], "relationships": [ { "id": 11, "name": "SBC_PUB.DBO.PAT_PropertyInfo_INTERNAL", "relatedTableId": 0, "role": "esriRelRoleDestination", "keyField": "VALU_PARCEL_NBR", "cardinality": "esriRelCardinalityOneToMany", "composite": false } ], "capabilities": "Map,Query,Data", "maxRecordCount": 1000, "supportsStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON", "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.71, "id": 14, "name": "Processed Corrections", "type": "Table", "description": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "CORT_PARCEL_NBR", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "CORT_PARCEL_NBR", "type": "esriFieldTypeString", "alias": "CORT_PARCEL_NBR", "length": 13, "domain": null }, { "name": "Seq", "type": "esriFieldTypeInteger", "alias": "Seq", "domain": null }, { "name": "RollDate", "type": "esriFieldTypeDate", "alias": "Roll Date", "length": 8, "domain": null }, { "name": "RollType", "type": "esriFieldTypeString", "alias": "Roll Type", "length": 3, "domain": null }, { "name": "CORT_REV_IND", "type": "esriFieldTypeString", "alias": "CORT_REV_IND", "length": 1, "domain": null }, { "name": "CORT_OLD_ROL_SEQ", "type": "esriFieldTypeSmallInteger", "alias": "CORT_OLD_ROL_SEQ", "domain": null }, { "name": "CORT_NEW_ROL_SEQ", "type": "esriFieldTypeSmallInteger", "alias": "CORT_NEW_ROL_SEQ", "domain": null }, { "name": "CORT_INITIATION", "type": "esriFieldTypeDate", "alias": "Initiation", "length": 8, "domain": null }, { "name": "Initated", "type": "esriFieldTypeString", "alias": "Initated", "length": 14, "domain": null }, { "name": "InitatedDesc", "type": "esriFieldTypeString", "alias": "Initiated", "length": 255, "domain": null }, { "name": "Status", "type": "esriFieldTypeString", "alias": "Status", "length": 3, "domain": null }, { "name": "StatusDesc", "type": "esriFieldTypeString", "alias": "Status", "length": 255, "domain": null }, { "name": "DiscReason", "type": "esriFieldTypeString", "alias": "Disc Reason", "length": 3, "domain": null }, { "name": "Code", "type": "esriFieldTypeString", "alias": "Code", "length": 15, "domain": null }, { "name": "CodeDesc", "type": "esriFieldTypeString", "alias": "Code", "length": 255, "domain": null }, { "name": "CORT_NA_IND", "type": "esriFieldTypeString", "alias": "CORT_NA_IND", "length": 1, "domain": null }, { "name": "CORT_CORR_NBR", "type": "esriFieldTypeInteger", "alias": "CORT_CORR_NBR", "domain": null }, { "name": "Completed", "type": "esriFieldTypeDate", "alias": "Completed", "length": 8, "domain": null }, { "name": "CORT_DAMAGE_REG", "type": "esriFieldTypeSmallInteger", "alias": "CORT_DAMAGE_REG", "domain": null }, { "name": "CORT_DAMAGE_RED", "type": "esriFieldTypeSmallInteger", "alias": "CORT_DAMAGE_RED", "domain": null }, { "name": "CORT_INT_BAS_AMT", "type": "esriFieldTypeDouble", "alias": "CORT_INT_BAS_AMT", "domain": null }, { "name": "CORT_INTEREST", "type": "esriFieldTypeDate", "alias": "Interest", "length": 8, "domain": null }, { "name": "CORT_TXPR_LETTER", "type": "esriFieldTypeDate", "alias": "CORT_TXPR_LETTER", "length": 8, "domain": null }, { "name": "NoLag", "type": "esriFieldTypeString", "alias": "No Lag", "length": 1, "domain": null }, { "name": "Released", "type": "esriFieldTypeDate", "alias": "Released", "length": 8, "domain": null }, { "name": "CORT_POST_KEY", "type": "esriFieldTypeDate", "alias": "CORT_POST_KEY", "length": 8, "domain": null }, { "name": "CORT_POST_USERID", "type": "esriFieldTypeString", "alias": "CORT_POST_USERID", "length": 8, "domain": null } ], "indexes": null, "subtypes": [], "relationships": [ { "id": 12, "name": "SBC_PUB.DBO.PAT_PropertyInfo_INTERNAL", "relatedTableId": 0, "role": "esriRelRoleDestination", "keyField": "CORT_PARCEL_NBR", "cardinality": "esriRelCardinalityOneToMany", "composite": false } ], "capabilities": "Map,Query,Data", "maxRecordCount": 1000, "supportsStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON", "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.71, "id": 15, "name": "NOPICs", "type": "Table", "description": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "NOPI_PARCEL_NBR", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "NOPI_PARCEL_NBR", "type": "esriFieldTypeString", "alias": "NOPI_PARCEL_NBR", "length": 13, "domain": null }, { "name": "MailDate", "type": "esriFieldTypeDate", "alias": "MailDate", "length": 8, "domain": null }, { "name": "EventDate", "type": "esriFieldTypeDate", "alias": "EventDate", "length": 8, "domain": null }, { "name": "NOPI_CNTL_NO", "type": "esriFieldTypeInteger", "alias": "NOPI_CNTL_NO", "domain": null }, { "name": "NOPI_NOPIC_TYPE", "type": "esriFieldTypeString", "alias": "NOPI_NOPIC_TYPE", "length": 8, "domain": null }, { "name": "TypeDesc", "type": "esriFieldTypeString", "alias": "TypeDesc", "length": 255, "domain": null }, { "name": "NOPI_GUID", "type": "esriFieldTypeString", "alias": "NOPI_GUID", "length": 50, "domain": null }, { "name": "NOPI_PROCESSED", "type": "esriFieldTypeDate", "alias": "NOPI_PROCESSED", "length": 8, "domain": null }, { "name": "NOPI_POST_KEY", "type": "esriFieldTypeDate", "alias": "NOPI_POST_KEY", "length": 8, "domain": null }, { "name": "NOPI_POST_USERID", "type": "esriFieldTypeString", "alias": "NOPI_POST_USERID", "length": 8, "domain": null }, { "name": "NOPI_DATA", "type": "esriFieldTypeString", "alias": "NOPI_DATA", "length": 800, "domain": null } ], "indexes": null, "subtypes": [], "relationships": [ { "id": 13, "name": "SBC_PUB.DBO.PAT_PropertyInfo_INTERNAL", "relatedTableId": 0, "role": "esriRelRoleDestination", "keyField": "NOPI_PARCEL_NBR", "cardinality": "esriRelCardinalityOneToMany", "composite": false } ], "capabilities": "Map,Query,Data", "maxRecordCount": 1000, "supportsStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON", "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.71, "id": 16, "name": "Mailing Address History", "type": "Table", "description": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "Parcel", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "Parcel", "type": "esriFieldTypeString", "alias": "Parcel", "length": 13, "domain": null }, { "name": "BilledOwner", "type": "esriFieldTypeString", "alias": "Billed Owner", "length": 255, "domain": null }, { "name": "EffectiveDate", "type": "esriFieldTypeDate", "alias": "Effective Date", "length": 8, "domain": null }, { "name": "AddrLn1", "type": "esriFieldTypeString", "alias": "Address Line 1", "length": 255, "domain": null }, { "name": "AddrLn2", "type": "esriFieldTypeString", "alias": "Address Line 2", "length": 255, "domain": null }, { "name": "OwnerInactiveDate", "type": "esriFieldTypeDate", "alias": "Owner Inactive Date", "length": 8, "domain": null } ], "indexes": null, "subtypes": [], "relationships": [ { "id": 14, "name": "SBC_PUB.DBO.PAT_PropertyInfo_INTERNAL", "relatedTableId": 0, "role": "esriRelRoleDestination", "keyField": "Parcel", "cardinality": "esriRelCardinalityOneToMany", "composite": false } ], "capabilities": "Map,Query,Data", "maxRecordCount": 1000, "supportsStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON", "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.71, "id": 17, "name": "Notes", "type": "Table", "description": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "Parcel", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "Parcel", "type": "esriFieldTypeString", "alias": "Parcel", "length": 13, "domain": null }, { "name": "NoteDate", "type": "esriFieldTypeString", "alias": "Note Date", "length": 10, "domain": null }, { "name": "InitFromSubsys", "type": "esriFieldTypeString", "alias": "Init From Subsys", "length": 106, "domain": null }, { "name": "NoteData", "type": "esriFieldTypeString", "alias": "Note Data", "length": 4000, "domain": null } ], "indexes": null, "subtypes": [], "relationships": [ { "id": 15, "name": "SBC_PUB.DBO.PAT_PropertyInfo_INTERNAL", "relatedTableId": 0, "role": "esriRelRoleDestination", "keyField": "Parcel", "cardinality": "esriRelCardinalityOneToMany", "composite": false } ], "capabilities": "Map,Query,Data", "maxRecordCount": 1000, "supportsStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON", "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.71, "id": 18, "name": "Pending Corrections", "type": "Table", "description": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "CORD_PARCEL_NBR", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "CORD_PARCEL_NBR", "type": "esriFieldTypeString", "alias": "CORD_PARCEL_NBR", "length": 13, "domain": null }, { "name": "EventDate", "type": "esriFieldTypeDate", "alias": "Event Date", "length": 8, "domain": null }, { "name": "Priority", "type": "esriFieldTypeString", "alias": "Priority", "length": 255, "domain": null }, { "name": "Initiated", "type": "esriFieldTypeDate", "alias": "Initiated", "length": 8, "domain": null }, { "name": "INIT_FROM_SUBSYS", "type": "esriFieldTypeString", "alias": "Init From Subsys", "length": 255, "domain": null }, { "name": "Released", "type": "esriFieldTypeDate", "alias": "Released", "length": 8, "domain": null }, { "name": "InterestDate", "type": "esriFieldTypeDate", "alias": "Interest Date", "length": 8, "domain": null }, { "name": "RollDate", "type": "esriFieldTypeDate", "alias": "Roll Date", "length": 8, "domain": null }, { "name": "Type", "type": "esriFieldTypeString", "alias": "Type", "length": 255, "domain": null }, { "name": "InterestInd", "type": "esriFieldTypeString", "alias": "Interest Ind", "length": 255, "domain": null }, { "name": "SRC1", "type": "esriFieldTypeString", "alias": "SRC1", "length": 255, "domain": null }, { "name": "Reas1", "type": "esriFieldTypeString", "alias": "Reason1", "length": 255, "domain": null }, { "name": "SRC2", "type": "esriFieldTypeString", "alias": "SRC2", "length": 255, "domain": null }, { "name": "Reas2", "type": "esriFieldTypeString", "alias": "Reason2", "length": 255, "domain": null }, { "name": "SRC3", "type": "esriFieldTypeString", "alias": "SRC3", "length": 255, "domain": null }, { "name": "Reas3", "type": "esriFieldTypeString", "alias": "Reason3", "length": 255, "domain": null }, { "name": "User1", "type": "esriFieldTypeString", "alias": "User1", "length": 255, "domain": null }, { "name": "User2", "type": "esriFieldTypeString", "alias": "User2", "length": 255, "domain": null }, { "name": "User3", "type": "esriFieldTypeString", "alias": "User3", "length": 255, "domain": null } ], "indexes": null, "subtypes": [], "relationships": [ { "id": 17, "name": "SBC_PUB.DBO.PAT_PropertyInfo_INTERNAL", "relatedTableId": 0, "role": "esriRelRoleDestination", "keyField": "CORD_PARCEL_NBR", "cardinality": "esriRelCardinalityOneToMany", "composite": false } ], "capabilities": "Map,Query,Data", "maxRecordCount": 1000, "supportsStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON", "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.71, "id": 19, "name": "Legal Parcel Map", "type": "Table", "description": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "Parcel", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "Parcel", "type": "esriFieldTypeString", "alias": "Legal Parcel", "length": 13, "domain": null }, { "name": "Tract", "type": "esriFieldTypeString", "alias": "Legal Tract", "length": 10, "domain": null }, { "name": "Lot", "type": "esriFieldTypeString", "alias": "Legal Lot", "length": 5, "domain": null }, { "name": "Block", "type": "esriFieldTypeString", "alias": "Legal Block", "length": 3, "domain": null }, { "name": "ParcelMap", "type": "esriFieldTypeString", "alias": "Legal Map #", "length": 10, "domain": null }, { "name": "ParcelNbr", "type": "esriFieldTypeString", "alias": "Legal Parcel #", "length": 5, "domain": null }, { "name": "Unit", "type": "esriFieldTypeString", "alias": "Unit", "length": 5, "domain": null }, { "name": "Book", "type": "esriFieldTypeString", "alias": "Legal Book", "length": 3, "domain": null }, { "name": "Page", "type": "esriFieldTypeString", "alias": "Page", "length": 3, "domain": null }, { "name": "LegalDescription", "type": "esriFieldTypeString", "alias": "Legal Description", "length": 1073741822, "domain": null }, { "name": "Latitude", "type": "esriFieldTypeString", "alias": "Latitude", "length": 20, "domain": null }, { "name": "Longitude", "type": "esriFieldTypeString", "alias": "Longitude", "length": 20, "domain": null } ], "indexes": null, "subtypes": [], "relationships": [ { "id": 18, "name": "SBC_PUB.DBO.PAT_PropertyInfo_INTERNAL", "relatedTableId": 0, "role": "esriRelRoleDestination", "keyField": "Parcel", "cardinality": "esriRelCardinalityOneToMany", "composite": false } ], "capabilities": "Map,Query,Data", "maxRecordCount": 1000, "supportsStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON", "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 } } ] }