{ "layers": [ { "currentVersion": 10.91, "id": 0, "name": "TaxParcel", "type": "Feature Layer", "description": "", "geometryType": "esriGeometryPolygon", "sourceSpatialReference": { "wkid": 102100, "latestWkid": 3857 }, "copyrightText": "", "parentLayer": null, "subLayers": [], "minScale": 0, "maxScale": 0, "drawingInfo": { "renderer": { "type": "simple", "symbol": { "type": "esriSFS", "style": "esriSFSSolid", "color": [ 201, 242, 208, 255 ], "outline": { "type": "esriSLS", "style": "esriSLSSolid", "color": [ 110, 110, 110, 255 ], "width": 0.4 } }, "label": "", "description": "" }, "transparency": 0, "labelingInfo": null }, "defaultVisibility": true, "extent": { "xmin": -8649692.2877, "ymin": 5327719.125200003, "xmax": -8630879.7854, "ymax": 5352795.287199996, "spatialReference": { "wkid": 102100, "latestWkid": 3857 } }, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeAsHTMLText", "displayField": "STREET_NAME", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "PARCELID", "type": "esriFieldTypeString", "alias": "SBL", "length": 30, "domain": null }, { "name": "PRINTKEY", "type": "esriFieldTypeString", "alias": "PRINTKEY", "length": 25, "domain": null }, { "name": "STREET_NUM", "type": "esriFieldTypeString", "alias": "Street Number", "length": 20, "domain": null }, { "name": "STREET_NAME", "type": "esriFieldTypeString", "alias": "Street Name", "length": 25, "domain": null }, { "name": "SITEADDRESS", "type": "esriFieldTypeString", "alias": "NAME", "length": 80, "domain": null }, { "name": "CITY", "type": "esriFieldTypeString", "alias": "City", "length": 10, "domain": null }, { "name": "ZIP5", "type": "esriFieldTypeString", "alias": "Zip Code", "length": 5, "domain": null }, { "name": "CLASSCD", "type": "esriFieldTypeString", "alias": "Property Class Code", "length": 10, "domain": null }, { "name": "CLASSDSCRP", "type": "esriFieldTypeString", "alias": "Property Class", "length": 100, "domain": null }, { "name": "PROPERTYTYPE", "type": "esriFieldTypeString", "alias": "Property Type", "length": 100, "domain": null }, { "name": "OWNERNME1", "type": "esriFieldTypeString", "alias": "First Owner Name", "length": 120, "domain": null }, { "name": "PSTLADDRESS", "type": "esriFieldTypeString", "alias": "Postal Address", "length": 50, "domain": null }, { "name": "PSTLCITY", "type": "esriFieldTypeString", "alias": "Postal City", "length": 25, "domain": null }, { "name": "LOT_FRONTAGE", "type": "esriFieldTypeDouble", "alias": "Lot Frontage", "domain": null }, { "name": "LOT_DEPTH", "type": "esriFieldTypeDouble", "alias": "Lot Depth", "domain": null }, { "name": "STATEDAREA", "type": "esriFieldTypeString", "alias": "Stated Area", "length": 50, "domain": null }, { "name": "CURRENT_LAND_VALUE", "type": "esriFieldTypeInteger", "alias": "Current Land Value", "domain": null }, { "name": "CURRENT_TOTAL_VALUE", "type": "esriFieldTypeInteger", "alias": "Current Total Assessed Value", "domain": null }, { "name": "CURRENT_TAXABLE_VALUE", "type": "esriFieldTypeInteger", "alias": "Current Taxable Value", "domain": null }, { "name": "TENTATIVE_LAND_VALUE", "type": "esriFieldTypeInteger", "alias": "Tentative Land Value", "domain": null }, { "name": "TENTATIVE_TOTAL_VALUE", "type": "esriFieldTypeInteger", "alias": "Tentative Total Assessed Value", "domain": null }, { "name": "TENTATIVE_TAXABLE_VALUE", "type": "esriFieldTypeInteger", "alias": "Tentative Taxable Value", "domain": null }, { "name": "SALE_DATE", "type": "esriFieldTypeString", "alias": "Sale Date", "length": 50, "domain": null }, { "name": "SALE_PRICE", "type": "esriFieldTypeInteger", "alias": "Sale Price", "domain": null }, { "name": "BOOK", "type": "esriFieldTypeString", "alias": "Book", "length": 10, "domain": null }, { "name": "PAGE", "type": "esriFieldTypeString", "alias": "Page", "length": 10, "domain": null }, { "name": "DEED_TYPE", "type": "esriFieldTypeString", "alias": "Deed Type", "length": 10, "domain": null }, { "name": "VALID", "type": "esriFieldTypeString", "alias": "Valid", "length": 5, "domain": { "type": "codedValue", "name": "YesNo", "description": "A yes/no indicator", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "RESCOM", "type": "esriFieldTypeString", "alias": "RESCOM", "length": 10, "domain": null }, { "name": "SHAPEACRES", "type": "esriFieldTypeDouble", "alias": "SHAPEACRES", "domain": null }, { "name": "BISZONING", "type": "esriFieldTypeString", "alias": "BISZONING", "length": 20, "domain": null }, { "name": "OWNERSHIPCODE", "type": "esriFieldTypeString", "alias": "OWNERSHIPCODE", "length": 5, "domain": null }, { "name": "NORESUNITS", "type": "esriFieldTypeInteger", "alias": "Number of Residential Units", "domain": null }, { "name": "LOW_STREET_NUM", "type": "esriFieldTypeString", "alias": "LOW_STREET_NUM", "length": 10, "domain": null }, { "name": "HIGH_STREET_NUM", "type": "esriFieldTypeString", "alias": "HIGH_STREET_NUM", "length": 10, "domain": null }, { "name": "GISEXTDATE", "type": "esriFieldTypeDate", "alias": "GISEXTDATE", "length": 8, "domain": null }, { "name": "SHAPE", "type": "esriFieldTypeGeometry", "alias": "SHAPE", "domain": null }, { "name": "LOW_STREET_SORT", "type": "esriFieldTypeDouble", "alias": "LOW_STREET_SORT", "domain": null }, { "name": "MultiSale", "type": "esriFieldTypeString", "alias": "MultiSale", "length": 10, "domain": null }, { "name": "PARCEL_SOURCE", "type": "esriFieldTypeString", "alias": "PARCEL_SOURCE", "length": 50, "domain": null }, { "name": "SHAPE.STArea()", "type": "esriFieldTypeDouble", "alias": "SHAPE.STArea()", "domain": null }, { "name": "SHAPE.STLength()", "type": "esriFieldTypeDouble", "alias": "SHAPE.STLength()", "domain": null } ], "geometryField": { "name": "SHAPE", "type": "esriFieldTypeGeometry", "alias": "SHAPE" }, "indexes": [ { "name": "R111_pk", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "G544PARCELID", "fields": "PARCELID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "S42_idx", "fields": "SHAPE", "isAscending": true, "isUnique": true, "description": "" } ], "subtypes": [], "relationships": [ { "id": 0, "name": "Commercial Accessory", "relatedTableId": 4, "role": "esriRelRoleOrigin", "keyField": "PARCELID", "cardinality": "esriRelCardinalityOneToMany", "composite": false }, { "id": 1, "name": "Parcel Images", "relatedTableId": 10, "role": "esriRelRoleOrigin", "keyField": "PARCELID", "cardinality": "esriRelCardinalityOneToMany", "composite": false }, { "id": 2, "name": "Residential Accessory", "relatedTableId": 1, "role": "esriRelRoleOrigin", "keyField": "PARCELID", "cardinality": "esriRelCardinalityOneToMany", "composite": false }, { "id": 3, "name": "Residential Structure", "relatedTableId": 2, "role": "esriRelRoleOrigin", "keyField": "PARCELID", "cardinality": "esriRelCardinalityOneToMany", "composite": false }, { "id": 4, "name": "Special Districts", "relatedTableId": 7, "role": "esriRelRoleOrigin", "keyField": "PARCELID", "cardinality": "esriRelCardinalityOneToMany", "composite": false }, { "id": 5, "name": "Tax Exemptions", "relatedTableId": 8, "role": "esriRelRoleOrigin", "keyField": "PARCELID", "cardinality": "esriRelCardinalityOneToMany", "composite": false }, { "id": 6, "name": "Overlay Districts", "relatedTableId": 14, "role": "esriRelRoleOrigin", "keyField": "PARCELID", "cardinality": "esriRelCardinalityOneToMany", "composite": false }, { "id": 7, "name": "Preservation Districts", "relatedTableId": 15, "role": "esriRelRoleOrigin", "keyField": "PARCELID", "cardinality": "esriRelCardinalityOneToMany", "composite": false }, { "id": 8, "name": "Zoning Districts", "relatedTableId": 16, "role": "esriRelRoleOrigin", "keyField": "PARCELID", "cardinality": "esriRelCardinalityOneToMany", "composite": false }, { "id": 9, "name": "Land Lord Registry", "relatedTableId": 19, "role": "esriRelRoleOrigin", "keyField": "PARCELID", "cardinality": "esriRelCardinalityOneToMany", "composite": false }, { "id": 10, "name": "CommercialStructure_RPS", "relatedTableId": 3, "role": "esriRelRoleOrigin", "keyField": "PARCELID", "cardinality": "esriRelCardinalityOneToMany", "composite": false }, { "id": 11, "name": "CommercialUse_RPS", "relatedTableId": 5, "role": "esriRelRoleOrigin", "keyField": "PARCELID", "cardinality": "esriRelCardinalityOneToMany", "composite": false }, { "id": 12, "name": "ParcelWaterBill", "relatedTableId": 6, "role": "esriRelRoleOrigin", "keyField": "PARCELID", "cardinality": "esriRelCardinalityOneToMany", "composite": false }, { "id": 13, "name": "ParcelTaxBill", "relatedTableId": 9, "role": "esriRelRoleOrigin", "keyField": "PARCELID", "cardinality": "esriRelCardinalityOneToMany", "composite": false } ], "canModifyLayer": true, "canScaleSymbols": false, "hasLabels": false, "capabilities": "Map,Query,Data", "maxRecordCount": 100000, "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, "hasGeometryProperties": true, "geometryProperties": { "shapeAreaFieldName": "SHAPE.STArea()", "shapeLengthFieldName": "SHAPE.STLength()", "units": "esriMeters" }, "dateFieldsTimeReference": null, "supportsCoordinatesQuantization": true } ], "tables": [ { "currentVersion": 10.91, "id": 1, "name": "AppTaxParcelViewer.DBO.ResidentialAccessory", "type": "Table", "description": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "SBL", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "SBL", "type": "esriFieldTypeString", "alias": "SBL", "length": 26, "domain": null }, { "name": "STRUCTURE_CODE", "type": "esriFieldTypeString", "alias": "Accessory", "length": 50, "domain": null }, { "name": "DIMENSION1", "type": "esriFieldTypeString", "alias": "Dimension 1", "length": 10, "domain": null }, { "name": "DIMENSION2", "type": "esriFieldTypeString", "alias": "Dimension 2", "length": 10, "domain": null }, { "name": "YEAR_BUILT", "type": "esriFieldTypeString", "alias": "Year Built", "length": 255, "domain": null }, { "name": "NO_OF_IDENTICAL", "type": "esriFieldTypeString", "alias": "Number of Identical", "length": 50, "domain": null } ], "indexes": [ { "name": "R101_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "G533SBL", "fields": "SBL", "isAscending": true, "isUnique": false, "description": "" } ], "subtypes": [], "relationships": [ { "id": 2, "name": "Tax Parcel", "relatedTableId": 0, "role": "esriRelRoleDestination", "keyField": "SBL", "cardinality": "esriRelCardinalityOneToMany", "composite": false } ], "capabilities": "Map,Query,Data", "maxRecordCount": 100000, "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.91, "id": 2, "name": "AppTaxParcelViewer.DBO.ResidentialStructure", "type": "Table", "description": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "SBL", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "SBL", "type": "esriFieldTypeString", "alias": "SBL", "length": 26, "domain": null }, { "name": "GRADE", "type": "esriFieldTypeString", "alias": "Overall Construction Quality", "length": 15, "domain": null }, { "name": "OVER_COND", "type": "esriFieldTypeString", "alias": "Overall Condition", "length": 15, "domain": null }, { "name": "BASEMENT", "type": "esriFieldTypeString", "alias": "Basement", "length": 15, "domain": null }, { "name": "BLDGSTYLE", "type": "esriFieldTypeString", "alias": "Building Style", "length": 15, "domain": null }, { "name": "EXT_WALL", "type": "esriFieldTypeString", "alias": "Exterior Wall Material", "length": 15, "domain": null }, { "name": "HEAT_TYPE", "type": "esriFieldTypeString", "alias": "Heat Type", "length": 15, "domain": null }, { "name": "AIR_COND", "type": "esriFieldTypeString", "alias": "Central Air Conditioning", "length": 3, "domain": null }, { "name": "FUEL_TYPE", "type": "esriFieldTypeString", "alias": "Fuel Type", "length": 20, "domain": null }, { "name": "BASEMENT_TYPE", "type": "esriFieldTypeString", "alias": "Basement Type", "length": 50, "domain": null }, { "name": "BASEMENT_GARAGE", "type": "esriFieldTypeString", "alias": "Basement Garage", "length": 50, "domain": null }, { "name": "YR_BUILT", "type": "esriFieldTypeString", "alias": "Year Built", "length": 50, "domain": null }, { "name": "STORIES", "type": "esriFieldTypeString", "alias": "Stories", "length": 50, "domain": null }, { "name": "FIREPLACES", "type": "esriFieldTypeString", "alias": "Fireplaces", "length": 50, "domain": null }, { "name": "BEDS", "type": "esriFieldTypeString", "alias": "Beds", "length": 50, "domain": null }, { "name": "KITCHENS", "type": "esriFieldTypeString", "alias": "Kitchens", "length": 50, "domain": null }, { "name": "BATHS", "type": "esriFieldTypeString", "alias": "Baths", "length": 50, "domain": null }, { "name": "HALFBATH", "type": "esriFieldTypeString", "alias": "Half Baths", "length": 50, "domain": null }, { "name": "FINISHED_BASEMENT_AREA", "type": "esriFieldTypeString", "alias": "Finished Basement Area", "length": 50, "domain": null }, { "name": "FIRST_FLOOR_AREA", "type": "esriFieldTypeString", "alias": "First Floor Area", "length": 50, "domain": null }, { "name": "SECOND_FLOOR_AREA", "type": "esriFieldTypeString", "alias": "Second Floor Area", "length": 50, "domain": null }, { "name": "ADDITIONAL_FLOOR_AREA", "type": "esriFieldTypeString", "alias": "Additional Floor Area", "length": 50, "domain": null }, { "name": "HALF_STORY", "type": "esriFieldTypeString", "alias": "Half Story", "length": 50, "domain": null }, { "name": "THREE_QUARTER_STORY", "type": "esriFieldTypeString", "alias": "Three Quarter Story", "length": 50, "domain": null }, { "name": "FINISHED_REC_ROOM", "type": "esriFieldTypeString", "alias": "Finished Rec Room", "length": 50, "domain": null }, { "name": "FINISHED_ATTIC", "type": "esriFieldTypeString", "alias": "Finished Attic", "length": 50, "domain": null }, { "name": "FINISHED_OVER_GARAGE", "type": "esriFieldTypeString", "alias": "Finished Over Garage", "length": 50, "domain": null }, { "name": "GARAGE_CAPACITY", "type": "esriFieldTypeString", "alias": "GARAGE_CAPACITY", "length": 50, "domain": null }, { "name": "RESFLRAREA", "type": "esriFieldTypeString", "alias": "Total Sq Ft Living Area", "length": 50, "domain": null } ], "indexes": [ { "name": "R102_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "G534SBL", "fields": "SBL", "isAscending": true, "isUnique": false, "description": "" } ], "subtypes": [], "relationships": [ { "id": 3, "name": "Tax Parcel", "relatedTableId": 0, "role": "esriRelRoleDestination", "keyField": "SBL", "cardinality": "esriRelCardinalityOneToMany", "composite": false } ], "capabilities": "Map,Query,Data", "maxRecordCount": 100000, "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.91, "id": 3, "name": "AppTaxParcelViewer.DBO.CommercialStructure_RPS", "type": "Table", "description": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "SBL", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "SBL", "type": "esriFieldTypeString", "alias": "SBL", "length": 30, "domain": null }, { "name": "YR_BUILT", "type": "esriFieldTypeString", "alias": "YR_BUILT", "length": 10, "domain": null }, { "name": "GRADE", "type": "esriFieldTypeString", "alias": "GRADE", "length": 20, "domain": null }, { "name": "OVER_COND", "type": "esriFieldTypeString", "alias": "OVER_COND", "length": 20, "domain": null }, { "name": "STORIES", "type": "esriFieldTypeString", "alias": "STORIES", "length": 20, "domain": null }, { "name": "IDENTICAL", "type": "esriFieldTypeString", "alias": "IDENTICAL", "length": 20, "domain": null }, { "name": "BUILDING_TYPE", "type": "esriFieldTypeString", "alias": "BUILDING_TYPE", "length": 100, "domain": null }, { "name": "GROSS_SQ_FT", "type": "esriFieldTypeString", "alias": "GROSS_SQ_FT", "length": 50, "domain": null } ], "indexes": [ { "name": "R122_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "GDB_574_SBL", "fields": "SBL", "isAscending": true, "isUnique": false, "description": "" } ], "subtypes": [], "relationships": [ { "id": 10, "name": "TaxParcel", "relatedTableId": 0, "role": "esriRelRoleDestination", "keyField": "SBL", "cardinality": "esriRelCardinalityOneToMany", "composite": false } ], "capabilities": "Map,Query,Data", "maxRecordCount": 100000, "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.91, "id": 4, "name": "AppTaxParcelViewer.DBO.CommercialAccessory", "type": "Table", "description": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "SBL", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "SBL", "type": "esriFieldTypeString", "alias": "SBL", "length": 26, "domain": null }, { "name": "STRUCTURE_CODE", "type": "esriFieldTypeString", "alias": "Structure Type", "length": 50, "domain": null }, { "name": "DIMENSION1", "type": "esriFieldTypeString", "alias": "Dimension 1", "length": 50, "domain": null }, { "name": "DIMENSION2", "type": "esriFieldTypeString", "alias": "Dimension 2", "length": 50, "domain": null }, { "name": "YEAR_BUILT", "type": "esriFieldTypeString", "alias": "Year Built", "length": 50, "domain": null }, { "name": "NO_OF_IDENTICAL", "type": "esriFieldTypeString", "alias": "Number of Identical Structures", "length": 50, "domain": null } ], "indexes": [ { "name": "R92_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "G524SBL", "fields": "SBL", "isAscending": true, "isUnique": false, "description": "" } ], "subtypes": [], "relationships": [ { "id": 0, "name": "Tax Parcel", "relatedTableId": 0, "role": "esriRelRoleDestination", "keyField": "SBL", "cardinality": "esriRelCardinalityOneToMany", "composite": false } ], "capabilities": "Map,Query,Data", "maxRecordCount": 100000, "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.91, "id": 5, "name": "AppTaxParcelViewer.DBO.CommercialUse_RPS", "type": "Table", "description": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "SBL20", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "SBL20", "type": "esriFieldTypeString", "alias": "SBL20", "length": 30, "domain": null }, { "name": "USEDASCDEDESCR", "type": "esriFieldTypeString", "alias": "USEDASCDEDESCR", "length": 50, "domain": null }, { "name": "RENTABLESQFT", "type": "esriFieldTypeString", "alias": "RENTABLESQFT", "length": 50, "domain": null }, { "name": "NBR1BEDROOMAPTS", "type": "esriFieldTypeString", "alias": "NBR1BEDROOMAPTS", "length": 20, "domain": null }, { "name": "NBR2BEDROOMAPTS", "type": "esriFieldTypeString", "alias": "NBR2BEDROOMAPTS", "length": 20, "domain": null }, { "name": "NBR3BEDROOMAPTS", "type": "esriFieldTypeString", "alias": "NBR3BEDROOMAPTS", "length": 20, "domain": null } ], "indexes": [ { "name": "R123_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "GDB_575_SBL20", "fields": "SBL20", "isAscending": true, "isUnique": false, "description": "" } ], "subtypes": [], "relationships": [ { "id": 11, "name": "TaxParcel", "relatedTableId": 0, "role": "esriRelRoleDestination", "keyField": "SBL20", "cardinality": "esriRelCardinalityOneToMany", "composite": false } ], "capabilities": "Map,Query,Data", "maxRecordCount": 100000, "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.91, "id": 6, "name": "AppTaxParcelViewer.DBO.ParcelWaterBill", "type": "Table", "description": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "AccountOwnerName", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "SBL20", "type": "esriFieldTypeString", "alias": "SBL20", "length": 30, "domain": null }, { "name": "SBL10", "type": "esriFieldTypeString", "alias": "SBL10", "length": 20, "domain": null }, { "name": "WSEID", "type": "esriFieldTypeString", "alias": "WSEID", "length": 20, "domain": null }, { "name": "DVLVSRV_ID", "type": "esriFieldTypeString", "alias": "DVLVSRV_ID", "length": 20, "domain": null }, { "name": "AccountOwnerName", "type": "esriFieldTypeString", "alias": "AccountOwnerName", "length": 60, "domain": null }, { "name": "LastBill", "type": "esriFieldTypeString", "alias": "LastBill", "length": 20, "domain": null }, { "name": "DueDate", "type": "esriFieldTypeString", "alias": "DueDate", "length": 20, "domain": null }, { "name": "Adjustments", "type": "esriFieldTypeString", "alias": "Adjustments", "length": 20, "domain": null }, { "name": "Penalties", "type": "esriFieldTypeString", "alias": "Penalties", "length": 20, "domain": null }, { "name": "Balance", "type": "esriFieldTypeString", "alias": "Balance", "length": 20, "domain": null }, { "name": "LastPayment", "type": "esriFieldTypeString", "alias": "LastPayment", "length": 20, "domain": null }, { "name": "LastPayDate", "type": "esriFieldTypeString", "alias": "LastPayDate", "length": 20, "domain": null }, { "name": "OutsideConnection", "type": "esriFieldTypeString", "alias": "OutsideConnection", "length": 30, "domain": null }, { "name": "InsideConnection", "type": "esriFieldTypeString", "alias": "InsideConnection", "length": 30, "domain": null } ], "indexes": [ { "name": "R113_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "GDB_565_SBL20", "fields": "SBL20", "isAscending": true, "isUnique": false, "description": "" } ], "subtypes": [], "relationships": [ { "id": 12, "name": "TaxParcel", "relatedTableId": 0, "role": "esriRelRoleDestination", "keyField": "SBL20", "cardinality": "esriRelCardinalityOneToMany", "composite": false } ], "capabilities": "Map,Query,Data", "maxRecordCount": 100000, "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.91, "id": 7, "name": "AppTaxParcelViewer.DBO.SpecialDistricts", "type": "Table", "description": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "SBL20", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "SBL20", "type": "esriFieldTypeString", "alias": "SBL20", "length": 50, "domain": null }, { "name": "TotalSpecialDistricts", "type": "esriFieldTypeSmallInteger", "alias": "TotalSpecialDistricts", "domain": null }, { "name": "SpecialDistrictCode", "type": "esriFieldTypeString", "alias": "SpecialDistrictCode", "length": 50, "domain": null }, { "name": "SpecialDistrictDesc", "type": "esriFieldTypeString", "alias": "SpecialDistrictDesc", "length": 50, "domain": null }, { "name": "Units", "type": "esriFieldTypeSmallInteger", "alias": "Units", "domain": null } ], "indexes": [ { "name": "R103_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "G535SBL20", "fields": "SBL20", "isAscending": true, "isUnique": false, "description": "" } ], "subtypes": [], "relationships": [ { "id": 4, "name": "Tax Parcel", "relatedTableId": 0, "role": "esriRelRoleDestination", "keyField": "SBL20", "cardinality": "esriRelCardinalityOneToMany", "composite": false } ], "capabilities": "Map,Query,Data", "maxRecordCount": 100000, "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.91, "id": 8, "name": "AppTaxParcelViewer.DBO.TaxExemptions", "type": "Table", "description": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "ExemptionName", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "SBL20", "type": "esriFieldTypeString", "alias": "SBL20", "length": 50, "domain": null }, { "name": "TotalExemptions", "type": "esriFieldTypeString", "alias": "TOTALEXEMPTIONS", "length": 50, "domain": null }, { "name": "ExemptionCode", "type": "esriFieldTypeString", "alias": "ExemptionsCode", "length": 50, "domain": null }, { "name": "ExemptionName", "type": "esriFieldTypeString", "alias": "ExemptionName", "length": 50, "domain": null }, { "name": "ExemptionAmount", "type": "esriFieldTypeString", "alias": "ExemptionAmount", "length": 50, "domain": null }, { "name": "ExemptionPercent", "type": "esriFieldTypeString", "alias": "ExemptionPercent", "length": 50, "domain": null }, { "name": "InitialYear", "type": "esriFieldTypeString", "alias": "InitialYear", "length": 50, "domain": null }, { "name": "TermYear", "type": "esriFieldTypeString", "alias": "TermYear", "length": 50, "domain": null } ], "indexes": [ { "name": "R104_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "G536SBL20", "fields": "SBL20", "isAscending": true, "isUnique": false, "description": "" } ], "subtypes": [], "relationships": [ { "id": 5, "name": "Tax Parcel", "relatedTableId": 0, "role": "esriRelRoleDestination", "keyField": "SBL20", "cardinality": "esriRelCardinalityOneToMany", "composite": false } ], "capabilities": "Map,Query,Data", "maxRecordCount": 100000, "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.91, "id": 9, "name": "AppTaxParcelViewer.DBO.ParcelTaxBill", "type": "Table", "description": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "PayDate01", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "CurrentTax", "type": "esriFieldTypeDouble", "alias": "CurrentTax", "domain": null }, { "name": "Payment01", "type": "esriFieldTypeDouble", "alias": "Payment01", "domain": null }, { "name": "Payment02", "type": "esriFieldTypeDouble", "alias": "Payment02", "domain": null }, { "name": "Payment03", "type": "esriFieldTypeDouble", "alias": "Payment03", "domain": null }, { "name": "Payment04", "type": "esriFieldTypeDouble", "alias": "Payment04", "domain": null }, { "name": "AmountPaid01", "type": "esriFieldTypeDouble", "alias": "AmountPaid01", "domain": null }, { "name": "AmountPaid02", "type": "esriFieldTypeDouble", "alias": "AmountPaid02", "domain": null }, { "name": "AmountPaid03", "type": "esriFieldTypeDouble", "alias": "AmountPaid03", "domain": null }, { "name": "AmountPaid04", "type": "esriFieldTypeDouble", "alias": "AmountPaid04", "domain": null }, { "name": "PayDate01", "type": "esriFieldTypeString", "alias": "PayDate01", "length": 50, "domain": null }, { "name": "PayDate02", "type": "esriFieldTypeString", "alias": "PayDate02", "length": 50, "domain": null }, { "name": "PayDate03", "type": "esriFieldTypeString", "alias": "PayDate03", "length": 50, "domain": null }, { "name": "PayDate04", "type": "esriFieldTypeString", "alias": "PayDate04", "length": 50, "domain": null }, { "name": "InterestDue", "type": "esriFieldTypeDouble", "alias": "InterestDue", "domain": null }, { "name": "TrueTax", "type": "esriFieldTypeDouble", "alias": "TrueTax", "domain": null }, { "name": "TotalPaid", "type": "esriFieldTypeDouble", "alias": "TotalPaid", "domain": null }, { "name": "PrincipalDue", "type": "esriFieldTypeDouble", "alias": "PrincipalDue", "domain": null }, { "name": "SBL20", "type": "esriFieldTypeString", "alias": "SBL20", "length": 50, "domain": null }, { "name": "TotalDue", "type": "esriFieldTypeDouble", "alias": "TotalDue", "domain": null }, { "name": "TotalInterestPaid", "type": "esriFieldTypeDouble", "alias": "TotalInterestPaid", "domain": null }, { "name": "YR_2015", "type": "esriFieldTypeString", "alias": "YR_2015", "length": 20, "domain": null }, { "name": "YR_2016", "type": "esriFieldTypeString", "alias": "YR_2016", "length": 20, "domain": null }, { "name": "YR_2017", "type": "esriFieldTypeString", "alias": "YR_2017", "length": 20, "domain": null }, { "name": "YR_2018", "type": "esriFieldTypeString", "alias": "YR_2018", "length": 20, "domain": null }, { "name": "YR_2019", "type": "esriFieldTypeString", "alias": "YR_2019", "length": 20, "domain": null }, { "name": "YR_2020", "type": "esriFieldTypeString", "alias": "YR_2020", "length": 20, "domain": null }, { "name": "YR_2021", "type": "esriFieldTypeString", "alias": "YR_2021", "length": 20, "domain": null }, { "name": "YR_2022", "type": "esriFieldTypeString", "alias": "YR_2022", "length": 20, "domain": null }, { "name": "YR_2023", "type": "esriFieldTypeString", "alias": "YR_2023", "length": 20, "domain": null }, { "name": "YR_2024", "type": "esriFieldTypeString", "alias": "YR_2024", "length": 20, "domain": null }, { "name": "YR_2025", "type": "esriFieldTypeString", "alias": "YR_2025", "length": 20, "domain": null }, { "name": "YR_2026", "type": "esriFieldTypeString", "alias": "YR_2026", "length": 20, "domain": null }, { "name": "YR_2027", "type": "esriFieldTypeString", "alias": "YR_2027", "length": 20, "domain": null }, { "name": "YR_2028", "type": "esriFieldTypeString", "alias": "YR_2028", "length": 20, "domain": null }, { "name": "YR_2029", "type": "esriFieldTypeString", "alias": "YR_2029", "length": 20, "domain": null }, { "name": "YR_2030", "type": "esriFieldTypeString", "alias": "YR_2030", "length": 20, "domain": null }, { "name": "YR_2031", "type": "esriFieldTypeString", "alias": "YR_2031", "length": 20, "domain": null }, { "name": "YR_2032", "type": "esriFieldTypeString", "alias": "YR_2032", "length": 20, "domain": null } ], "indexes": [ { "name": "R141_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "GDB_891_SBL20", "fields": "SBL20", "isAscending": true, "isUnique": false, "description": "" } ], "subtypes": [], "relationships": [ { "id": 13, "name": "TaxParcel", "relatedTableId": 0, "role": "esriRelRoleDestination", "keyField": "SBL20", "cardinality": "esriRelCardinalityOneToMany", "composite": false } ], "capabilities": "Map,Query,Data", "maxRecordCount": 100000, "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.91, "id": 10, "name": "AppTaxParcelViewer.DBO.ParcelImages", "type": "Table", "description": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "SBL", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "SBL", "type": "esriFieldTypeString", "alias": "SBL", "length": 22, "domain": null }, { "name": "ImagePath", "type": "esriFieldTypeString", "alias": "ImagePath", "length": 4000, "domain": null }, { "name": "DATE", "type": "esriFieldTypeDate", "alias": "DATE", "length": 8, "domain": null }, { "name": "Comment", "type": "esriFieldTypeString", "alias": "Comment", "length": 255, "domain": null }, { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null } ], "indexes": null, "subtypes": [], "relationships": [ { "id": 1, "name": "Tax Parcel", "relatedTableId": 0, "role": "esriRelRoleDestination", "keyField": "SBL", "cardinality": "esriRelCardinalityOneToMany", "composite": false } ], "capabilities": "Map,Query,Data", "maxRecordCount": 100000, "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.91, "id": 11, "name": "AppTaxParcelViewer.DBO.CodeEnforcement", "type": "Table", "description": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "NAME", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "ADDRESS", "type": "esriFieldTypeString", "alias": "Address", "length": 30, "domain": null }, { "name": "SBL", "type": "esriFieldTypeString", "alias": "SBL", "length": 20, "domain": null }, { "name": "USE_CODE", "type": "esriFieldTypeString", "alias": "Use Code", "length": 3, "domain": null }, { "name": "OWNER", "type": "esriFieldTypeString", "alias": "Owner", "length": 30, "domain": null }, { "name": "OPEN_CASE", "type": "esriFieldTypeString", "alias": "Open Case", "length": 3, "domain": null }, { "name": "OPEN_CASES", "type": "esriFieldTypeSmallInteger", "alias": "Open Cases", "domain": null }, { "name": "CASE_TYPE", "type": "esriFieldTypeString", "alias": "Case Type", "length": 4, "domain": null }, { "name": "CASE_SOURCE", "type": "esriFieldTypeString", "alias": "Case Source", "length": 2, "domain": null }, { "name": "VACANT", "type": "esriFieldTypeString", "alias": "Vacant", "length": 10, "domain": null }, { "name": "OUTSTANDING_VIOLATIONS", "type": "esriFieldTypeSmallInteger", "alias": "Outstanding Violations", "domain": null }, { "name": "CODE_ENFORCEMENT", "type": "esriFieldTypeString", "alias": "Code Enforcement", "length": 3, "domain": null }, { "name": "TOTAL_TICKETS", "type": "esriFieldTypeSmallInteger", "alias": "Total Tickets", "domain": null }, { "name": "PENDING_FINES", "type": "esriFieldTypeString", "alias": "Pending Fines", "length": 3, "domain": null }, { "name": "FINE_BALANCE", "type": "esriFieldTypeSmallInteger", "alias": "Fine Balance", "domain": null }, { "name": "TAX_FORECLOSURE", "type": "esriFieldTypeString", "alias": "Tax Foreclosure", "length": 3, "domain": null }, { "name": "INSPECTOR_ID", "type": "esriFieldTypeString", "alias": "Inpsector ID", "length": 10, "domain": null }, { "name": "CASE_NUMBER", "type": "esriFieldTypeString", "alias": "Case Number", "length": 20, "domain": null }, { "name": "DEMO_CASE", "type": "esriFieldTypeString", "alias": "Demo Case", "length": 3, "domain": null }, { "name": "PERMIT_CASE", "type": "esriFieldTypeString", "alias": "PERMIT_CASE", "length": 3, "domain": null }, { "name": "CASE_OPEN_DATE", "type": "esriFieldTypeString", "alias": "Case Open Date", "length": 30, "domain": null }, { "name": "LAST_TICKET_DATE", "type": "esriFieldTypeString", "alias": "Last Ticket Date", "length": 30, "domain": null }, { "name": "VACANT_DATE", "type": "esriFieldTypeString", "alias": "Vacant Date", "length": 30, "domain": null }, { "name": "RUNDATE", "type": "esriFieldTypeString", "alias": "RUNDATE", "length": 10, "domain": null }, { "name": "RUNTIME", "type": "esriFieldTypeString", "alias": "RUNTIME", "length": 10, "domain": null }, { "name": "INSPECTORAREA", "type": "esriFieldTypeString", "alias": "Inpsector Area", "length": 5, "domain": null }, { "name": "NAME", "type": "esriFieldTypeString", "alias": "Inspector", "length": 50, "domain": null }, { "name": "PHONE", "type": "esriFieldTypeString", "alias": "Phone Number", "length": 15, "domain": null }, { "name": "EMAIL", "type": "esriFieldTypeString", "alias": "Email", "length": 50, "domain": null }, { "name": "NSC", "type": "esriFieldTypeString", "alias": "NSC", "length": 10, "domain": null }, { "name": "OFFICEADDR", "type": "esriFieldTypeString", "alias": "Office Address", "length": 100, "domain": null }, { "name": "CONTSITUA", "type": "esriFieldTypeString", "alias": "CONTSITUA", "length": 50, "domain": null }, { "name": "NEWCOMPL", "type": "esriFieldTypeString", "alias": "NEWCOMPL", "length": 20, "domain": null } ], "indexes": [ { "name": "R91_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "G523SBL", "fields": "SBL", "isAscending": true, "isUnique": false, "description": "" } ], "subtypes": [], "relationships": [], "capabilities": "Map,Query,Data", "maxRecordCount": 100000, "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.91, "id": 12, "name": "AppTaxParcelViewer.DBO.Lead_LeadSafe", "type": "Table", "description": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "HSE_NUM", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "HSE_NUM", "type": "esriFieldTypeString", "alias": "House Number", "length": 10, "domain": null }, { "name": "ST_DIR", "type": "esriFieldTypeString", "alias": "Pre Direction", "length": 1, "domain": null }, { "name": "STREET", "type": "esriFieldTypeString", "alias": "Street Name", "length": 30, "domain": null }, { "name": "ST_TYPE", "type": "esriFieldTypeString", "alias": "Street Type", "length": 8, "domain": null }, { "name": "UNIT", "type": "esriFieldTypeString", "alias": "Unit", "length": 10, "domain": null }, { "name": "CLEARED", "type": "esriFieldTypeString", "alias": "Cleared", "length": 8, "domain": null }, { "name": "ExtrDate", "type": "esriFieldTypeString", "alias": "Extract Date", "length": 6, "domain": null }, { "name": "ExtrTime", "type": "esriFieldTypeString", "alias": "Extract Time", "length": 5, "domain": null }, { "name": "BISSBL", "type": "esriFieldTypeString", "alias": "BISSBL", "length": 20, "domain": null } ], "indexes": [ { "name": "R95_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "G527BISSBL", "fields": "BISSBL", "isAscending": true, "isUnique": false, "description": "" } ], "subtypes": [], "relationships": [], "capabilities": "Map,Query,Data", "maxRecordCount": 100000, "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.91, "id": 13, "name": "AppTaxParcelViewer.DBO.v_rentals_GIS", "type": "Table", "description": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "StreetName", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "BISSBL", "type": "esriFieldTypeString", "alias": "BISSBL", "length": 20, "domain": null }, { "name": "street", "type": "esriFieldTypeString", "alias": "street", "length": 22, "domain": null }, { "name": "Class", "type": "esriFieldTypeInteger", "alias": "Class", "domain": null }, { "name": "HouseNum", "type": "esriFieldTypeString", "alias": "HouseNum", "length": 6, "domain": null }, { "name": "Direction", "type": "esriFieldTypeString", "alias": "Direction", "length": 1, "domain": null }, { "name": "StreetName", "type": "esriFieldTypeString", "alias": "StreetName", "length": 15, "domain": null }, { "name": "StreetType", "type": "esriFieldTypeString", "alias": "StreetType", "length": 4, "domain": null }, { "name": "EffectiveDate_GIS", "type": "esriFieldTypeString", "alias": "EffectiveDate_GIS", "length": 10, "domain": null }, { "name": "ExpDate_GIS", "type": "esriFieldTypeString", "alias": "ExpDate_GIS", "length": 10, "domain": null }, { "name": "UD_DESC", "type": "esriFieldTypeString", "alias": "UD_DESC", "length": 50, "domain": null } ], "indexes": [ { "name": "R108_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "G540BISSBL", "fields": "BISSBL", "isAscending": true, "isUnique": false, "description": "" } ], "subtypes": [], "relationships": [], "capabilities": "Map,Query,Data", "maxRecordCount": 100000, "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.91, "id": 14, "name": "AppTaxParcelViewer.DBO.TaxParcelOverlayDistricts", "type": "Table", "description": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "PARCELID", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "PARCELID", "type": "esriFieldTypeString", "alias": "PARCELID", "length": 30, "domain": null }, { "name": "PRINTKEY", "type": "esriFieldTypeString", "alias": "PRINTKEY", "length": 30, "domain": null }, { "name": "SITEADDRESS", "type": "esriFieldTypeString", "alias": "SITEADDRESS", "length": 50, "domain": null }, { "name": "DESCRIPTION", "type": "esriFieldTypeString", "alias": "DESCRIPTION", "length": 254, "domain": null }, { "name": "BLURB1", "type": "esriFieldTypeString", "alias": "BLURB1", "length": 254, "domain": null }, { "name": "LINKTEXT1", "type": "esriFieldTypeString", "alias": "LINKTEXT1", "length": 254, "domain": null }, { "name": "HREF1", "type": "esriFieldTypeString", "alias": "HREF1", "length": 254, "domain": null }, { "name": "BLURB2", "type": "esriFieldTypeString", "alias": "BLURB2", "length": 254, "domain": null }, { "name": "LINKTEXT2", "type": "esriFieldTypeString", "alias": "LINKTEXT2", "length": 254, "domain": null }, { "name": "HREF2", "type": "esriFieldTypeString", "alias": "HREF2", "length": 254, "domain": null } ], "indexes": [ { "name": "R105_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "G537PARCELID", "fields": "PARCELID", "isAscending": true, "isUnique": false, "description": "" } ], "subtypes": [], "relationships": [ { "id": 6, "name": "Tax Parcel", "relatedTableId": 0, "role": "esriRelRoleDestination", "keyField": "PARCELID", "cardinality": "esriRelCardinalityOneToMany", "composite": false } ], "capabilities": "Map,Query,Data", "maxRecordCount": 100000, "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.91, "id": 15, "name": "AppTaxParcelViewer.DBO.TaxParcelPreservationDistricts", "type": "Table", "description": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "PARCELID", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "PARCELID", "type": "esriFieldTypeString", "alias": "PARCELID", "length": 30, "domain": null }, { "name": "PRINTKEY", "type": "esriFieldTypeString", "alias": "PRINTKEY", "length": 30, "domain": null }, { "name": "SITEADDRESS", "type": "esriFieldTypeString", "alias": "SITEADDRESS", "length": 50, "domain": null }, { "name": "DESCRIPTION", "type": "esriFieldTypeString", "alias": "DESCRIPTION", "length": 254, "domain": null }, { "name": "BLURB1", "type": "esriFieldTypeString", "alias": "BLURB1", "length": 254, "domain": null }, { "name": "LINKTEXT1", "type": "esriFieldTypeString", "alias": "LINKTEXT1", "length": 254, "domain": null }, { "name": "HREF1", "type": "esriFieldTypeString", "alias": "HREF1", "length": 254, "domain": null }, { "name": "BLURB2", "type": "esriFieldTypeString", "alias": "BLURB2", "length": 254, "domain": null }, { "name": "LINKTEXT2", "type": "esriFieldTypeString", "alias": "LINKTEXT2", "length": 254, "domain": null }, { "name": "HREF2", "type": "esriFieldTypeString", "alias": "HREF2", "length": 254, "domain": null } ], "indexes": [ { "name": "R106_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "G538PARCELID", "fields": "PARCELID", "isAscending": true, "isUnique": false, "description": "" } ], "subtypes": [], "relationships": [ { "id": 7, "name": "Tax Parcel", "relatedTableId": 0, "role": "esriRelRoleDestination", "keyField": "PARCELID", "cardinality": "esriRelCardinalityOneToMany", "composite": false } ], "capabilities": "Map,Query,Data", "maxRecordCount": 100000, "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.91, "id": 16, "name": "AppTaxParcelViewer.DBO.TaxParcelZoningDistricts", "type": "Table", "description": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "PARCELID", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "PARCELID", "type": "esriFieldTypeString", "alias": "PARCELID", "length": 30, "domain": null }, { "name": "PRINTKEY", "type": "esriFieldTypeString", "alias": "PRINTKEY", "length": 30, "domain": null }, { "name": "SITEADDRESS", "type": "esriFieldTypeString", "alias": "SITEADDRESS", "length": 50, "domain": null }, { "name": "DESCRIPTION", "type": "esriFieldTypeString", "alias": "DESCRIPTION", "length": 254, "domain": null }, { "name": "BLURB1", "type": "esriFieldTypeString", "alias": "BLURB1", "length": 254, "domain": null }, { "name": "LINKTEXT1", "type": "esriFieldTypeString", "alias": "LINKTEXT1", "length": 254, "domain": null }, { "name": "HREF1", "type": "esriFieldTypeString", "alias": "HREF1", "length": 254, "domain": null }, { "name": "BLURB2", "type": "esriFieldTypeString", "alias": "BLURB2", "length": 254, "domain": null }, { "name": "LINKTEXT2", "type": "esriFieldTypeString", "alias": "LINKTEXT2", "length": 254, "domain": null }, { "name": "HREF2", "type": "esriFieldTypeString", "alias": "HREF2", "length": 254, "domain": null } ], "indexes": [ { "name": "R107_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "G539PARCELID", "fields": "PARCELID", "isAscending": true, "isUnique": false, "description": "" } ], "subtypes": [], "relationships": [ { "id": 8, "name": "Tax Parcel", "relatedTableId": 0, "role": "esriRelRoleDestination", "keyField": "PARCELID", "cardinality": "esriRelCardinalityOneToMany", "composite": false } ], "capabilities": "Map,Query,Data", "maxRecordCount": 100000, "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.91, "id": 17, "name": "AppTaxParcelViewer.DBO.NuisancePoints", "type": "Table", "description": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "SBL20", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "SBL20", "type": "esriFieldTypeString", "alias": "SBL20", "length": 20, "domain": null }, { "name": "CASENUM", "type": "esriFieldTypeString", "alias": "CASENUM", "length": 6, "domain": null }, { "name": "ADDRESS", "type": "esriFieldTypeString", "alias": "ADDRESS", "length": 30, "domain": null }, { "name": "VIOCODE", "type": "esriFieldTypeString", "alias": "VIOCODE", "length": 7, "domain": null }, { "name": "VIODESC", "type": "esriFieldTypeString", "alias": "VIODESC", "length": 25, "domain": null }, { "name": "VIOPOINTS", "type": "esriFieldTypeSmallInteger", "alias": "VIOPOINTS", "domain": null }, { "name": "PTDATE", "type": "esriFieldTypeString", "alias": "PTDATE", "length": 20, "domain": null }, { "name": "EXTDATE", "type": "esriFieldTypeString", "alias": "EXTDATE", "length": 6, "domain": null }, { "name": "EXTTIME", "type": "esriFieldTypeString", "alias": "EXTTIME", "length": 5, "domain": null }, { "name": "TOTALPOINTS", "type": "esriFieldTypeString", "alias": "Total Points", "length": 10, "domain": null }, { "name": "SIXMONTHPOINTS", "type": "esriFieldTypeString", "alias": "Six Month Points", "length": 10, "domain": null }, { "name": "TWELVEMONTHPOINTS", "type": "esriFieldTypeString", "alias": "Twelve Month Points", "length": 10, "domain": null } ], "indexes": [ { "name": "R97_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "G529SBL20", "fields": "SBL20", "isAscending": true, "isUnique": false, "description": "" } ], "subtypes": [], "relationships": [], "capabilities": "Map,Query,Data", "maxRecordCount": 100000, "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.91, "id": 18, "name": "AppTaxParcelViewer.DBO.NuisanceEvents", "type": "Table", "description": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "SBL20", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "SBL20", "type": "esriFieldTypeString", "alias": "SBL20", "length": 20, "domain": null }, { "name": "CASENUM", "type": "esriFieldTypeString", "alias": "Case Number", "length": 6, "domain": null }, { "name": "ADDRESS", "type": "esriFieldTypeString", "alias": "Address", "length": 30, "domain": null }, { "name": "EVENTCODE", "type": "esriFieldTypeString", "alias": "Enforcement Action Code", "length": 3, "domain": null }, { "name": "EVENTDESC", "type": "esriFieldTypeString", "alias": "Enforcement Action Description", "length": 50, "domain": null }, { "name": "EVENTDATE", "type": "esriFieldTypeString", "alias": "Enforcement Action Date", "length": 20, "domain": null }, { "name": "EXTDATE", "type": "esriFieldTypeString", "alias": "Extract Date", "length": 6, "domain": null }, { "name": "EXTTIME", "type": "esriFieldTypeString", "alias": "Extract Time", "length": 5, "domain": null } ], "indexes": [ { "name": "R96_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "G528SBL20", "fields": "SBL20", "isAscending": true, "isUnique": false, "description": "" } ], "subtypes": [], "relationships": [], "capabilities": "Map,Query,Data", "maxRecordCount": 100000, "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.91, "id": 19, "name": "AppTaxParcelViewer.DBO.LandLordRegistry", "type": "Table", "description": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "CONTACTNAME", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "SBL", "type": "esriFieldTypeString", "alias": "SBL", "length": 255, "domain": null }, { "name": "CONTACTNAME", "type": "esriFieldTypeString", "alias": "CONTACTNAME", "length": 50, "domain": null }, { "name": "CONTACTADDRESS", "type": "esriFieldTypeString", "alias": "CONTACTADDRESS", "length": 90, "domain": null }, { "name": "CONTACTCITYSTATE", "type": "esriFieldTypeString", "alias": "CONTACTCITYSTATE", "length": 30, "domain": null }, { "name": "CONTACTZIP", "type": "esriFieldTypeString", "alias": "CONTACTZIP", "length": 10, "domain": null }, { "name": "CONTACTPHONE", "type": "esriFieldTypeString", "alias": "CONTACTPHONE", "length": 20, "domain": null }, { "name": "CONTACTEFFDATE", "type": "esriFieldTypeString", "alias": "CONTACTEFFDATE", "length": 20, "domain": null }, { "name": "EXTDATE", "type": "esriFieldTypeString", "alias": "EXTDATE", "length": 50, "domain": null }, { "name": "EXTTIME", "type": "esriFieldTypeString", "alias": "EXTTIME", "length": 50, "domain": null } ], "indexes": [ { "name": "R112_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "GDB_563_SBL", "fields": "SBL", "isAscending": true, "isUnique": false, "description": "" } ], "subtypes": [], "relationships": [ { "id": 9, "name": "Tax Parcel", "relatedTableId": 0, "role": "esriRelRoleDestination", "keyField": "SBL", "cardinality": "esriRelCardinalityOneToMany", "composite": false } ], "capabilities": "Map,Query,Data", "maxRecordCount": 100000, "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.91, "id": 20, "name": "AppTaxParcelViewer.DBO.MunisCharges", "type": "Table", "description": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "cust_name", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "bill_line", "type": "esriFieldTypeSmallInteger", "alias": "bill_line", "domain": null }, { "name": "FY", "type": "esriFieldTypeSmallInteger", "alias": "FY", "domain": null }, { "name": "ar_code", "type": "esriFieldTypeString", "alias": "ar_code", "length": 5, "domain": null }, { "name": "ar_code_text", "type": "esriFieldTypeString", "alias": "ar_code_text", "length": 40, "domain": null }, { "name": "chrg_cde", "type": "esriFieldTypeString", "alias": "chrg_cde", "length": 6, "domain": null }, { "name": "chrg_code_text", "type": "esriFieldTypeString", "alias": "chrg_code_text", "length": 40, "domain": null }, { "name": "invoice", "type": "esriFieldTypeInteger", "alias": "invoice", "domain": null }, { "name": "customer", "type": "esriFieldTypeInteger", "alias": "customer", "domain": null }, { "name": "cust_name", "type": "esriFieldTypeString", "alias": "cust_name", "length": 40, "domain": null }, { "name": "cust_addr", "type": "esriFieldTypeString", "alias": "cust_addr", "length": 40, "domain": null }, { "name": "cust_city", "type": "esriFieldTypeString", "alias": "cust_city", "length": 20, "domain": null }, { "name": "cust_state", "type": "esriFieldTypeString", "alias": "cust_state", "length": 2, "domain": null }, { "name": "cust_zip", "type": "esriFieldTypeString", "alias": "cust_zip", "length": 10, "domain": null }, { "name": "invoice_date", "type": "esriFieldTypeString", "alias": "invoice_date", "length": 30, "domain": null }, { "name": "due_date", "type": "esriFieldTypeString", "alias": "due_date", "length": 30, "domain": null }, { "name": "orig_amt", "type": "esriFieldTypeDouble", "alias": "orig_amt", "domain": null }, { "name": "adj_amt", "type": "esriFieldTypeDouble", "alias": "adj_amt", "domain": null }, { "name": "paid_amt", "type": "esriFieldTypeDouble", "alias": "paid_amt", "domain": null }, { "name": "unpaid_bal", "type": "esriFieldTypeDouble", "alias": "unpaid_bal", "domain": null }, { "name": "bill_parcel", "type": "esriFieldTypeString", "alias": "bill_parcel", "length": 20, "domain": null }, { "name": "RUN_DATE", "type": "esriFieldTypeDate", "alias": "RUN_DATE", "length": 8, "domain": null } ], "indexes": [ { "name": "R119_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" } ], "subtypes": [], "relationships": [], "capabilities": "Map,Query,Data", "maxRecordCount": 100000, "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.91, "id": 21, "name": "AppTaxParcelViewer.DBO.Lead_CofOIssd", "type": "Table", "description": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "BISSBL", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "LicenseNumber", "type": "esriFieldTypeString", "alias": "LicenseNumber", "length": 20, "domain": null }, { "name": "HSE_NUM", "type": "esriFieldTypeString", "alias": "HSE_NUM", "length": 20, "domain": null }, { "name": "ST_DIR", "type": "esriFieldTypeString", "alias": "ST_DIR", "length": 10, "domain": null }, { "name": "STREET", "type": "esriFieldTypeString", "alias": "STREET", "length": 40, "domain": null }, { "name": "ST_TYPE", "type": "esriFieldTypeString", "alias": "ST_TYPE", "length": 20, "domain": null }, { "name": "City", "type": "esriFieldTypeString", "alias": "City", "length": 20, "domain": null }, { "name": "Zip", "type": "esriFieldTypeString", "alias": "Zip", "length": 20, "domain": null }, { "name": "ParcelID", "type": "esriFieldTypeString", "alias": "ParcelID", "length": 24, "domain": null }, { "name": "BISSBL", "type": "esriFieldTypeString", "alias": "BISSBL", "length": 24, "domain": null }, { "name": "ISSUED", "type": "esriFieldTypeString", "alias": "ISSUED", "length": 20, "domain": null }, { "name": "EFFECTIVE", "type": "esriFieldTypeString", "alias": "EFFECTIVE", "length": 20, "domain": null }, { "name": "EXPIRE", "type": "esriFieldTypeString", "alias": "EXPIRE", "length": 20, "domain": null }, { "name": "Milestone", "type": "esriFieldTypeString", "alias": "Milestone", "length": 40, "domain": null }, { "name": "Status", "type": "esriFieldTypeString", "alias": "Status", "length": 20, "domain": null }, { "name": "OWNERNME1", "type": "esriFieldTypeString", "alias": "OWNERNME1", "length": 100, "domain": null }, { "name": "CLASSCD", "type": "esriFieldTypeString", "alias": "CLASSCD", "length": 10, "domain": null }, { "name": "CLASSDSCRP", "type": "esriFieldTypeString", "alias": "CLASSDSCRP", "length": 40, "domain": null }, { "name": "RESUNITS", "type": "esriFieldTypeInteger", "alias": "RESUNITS", "domain": null }, { "name": "ExtrDate", "type": "esriFieldTypeString", "alias": "ExtrDate", "length": 10, "domain": null }, { "name": "ExtrTime", "type": "esriFieldTypeString", "alias": "ExtrTime", "length": 10, "domain": null } ], "indexes": [ { "name": "R162_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" } ], "subtypes": [], "relationships": [], "capabilities": "Map,Query,Data", "maxRecordCount": 100000, "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 } ] }