{ "layers": [ { "currentVersion": 11.5, "cimVersion": "3.5.0", "id": 4, "name": "Sanitary Permit", "type": "Feature Layer", "description": "", "geometryType": "esriGeometryPoint", "sourceSpatialReference": { "wkid": 102754, "latestWkid": 2289, "xyTolerance": 0.001, "zTolerance": 0.001, "mTolerance": 0.001, "falseX": -1.1812129999998207E8, "falseY": -9.741829999994947E7, "xyUnits": 3048.0060960121914, "falseZ": 0, "zUnits": 1, "falseM": 0, "mUnits": 1 }, "spatialReference": { "wkid": 102754, "latestWkid": 2289, "xyTolerance": 0.003280833333333333, "zTolerance": 0.001, "mTolerance": 0.001, "falseX": -118121300, "falseY": -97418300, "xyUnits": 3048.0060960121928, "falseZ": -100000, "zUnits": 10000, "falseM": -100000, "mUnits": 10000 }, "copyrightText": "", "parentLayer": null, "subLayers": [], "minScale": 0, "maxScale": 0, "referenceScale": 0.0, "drawingInfo": { "renderer": { "type": "simple", "symbol": { "type": "esriPMS", "url": "9ee9d4b88b206a4a9e6f4653fe801188", "imageData": "iVBORw0KGgoAAAANSUhEUgAAABAAAAAQCAYAAAAf8/9hAAAACXBIWXMAAA7EAAAOxAGVKw4bAAAAS0lEQVQ4jWNhoBCwQOkGBgYGYxL1ngXpY4FyjP//Z/DBpoqRkTgXkA1YyNc6agAMsDBQCFhGDWCAhcFZNTWSQ+MZciA23L5NXnACAN2qCPWV/mWgAAAAAElFTkSuQmCC", "contentType": "image/png", "width": 12, "height": 12, "angle": 0, "xoffset": 0, "yoffset": 0 } }, "scaleSymbols": true, "transparency": 0, "labelingInfo": null }, "defaultVisibility": true, "extent": { "xmin": 2232423.595238954, "ymin": 309617.1212532222, "xmax": 2359500.9444302022, "ymax": 439318.0114572197, "spatialReference": { "wkid": 102754, "latestWkid": 2289, "xyTolerance": 0.003280833333333333, "zTolerance": 0.001, "mTolerance": 0.001, "falseX": -118121300, "falseY": -97418300, "xyUnits": 3048.0060960121928, "falseZ": -100000, "zUnits": 10000, "falseM": -100000, "mUnits": 10000 } }, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeAsHTMLText", "displayField": "vector.SDE.SANPERMIT.PERMIT_NUMBER", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "vector.SDE.Zoning_Parcel_Points.OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "vector.SDE.Zoning_Parcel_Points.PIN", "type": "esriFieldTypeString", "alias": "PIN", "length": 17, "domain": null }, { "name": "vector.SDE.SANPERMIT.PERMIT_NUMBER", "type": "esriFieldTypeString", "alias": "Permit Number", "length": 15, "domain": null }, { "name": "vector.SDE.Zoning_Parcel_Points.Zone2012", "type": "esriFieldTypeString", "alias": "Zone2012", "length": 5, "domain": null }, { "name": "vector.SDE.Zoning_Parcel_Points.ORIG_FID", "type": "esriFieldTypeInteger", "alias": "ORIG_FID", "domain": null }, { "name": "vector.SDE.Zoning_Parcel_Points.Shape", "type": "esriFieldTypeGeometry", "alias": "SHAPE", "domain": null }, { "name": "vector.SDE.Zoning_Parcel_Points.GlobalID", "type": "esriFieldTypeGlobalID", "alias": "GlobalID", "length": 38, "domain": null }, { "name": "vector.SDE.SANPERMIT.OBJECTID", "type": "esriFieldTypeInteger", "alias": "OBJECTID", "domain": null }, { "name": "vector.SDE.SANPERMIT.PERMIT_SUFFIX", "type": "esriFieldTypeString", "alias": "Permit Suffix", "length": 10, "domain": null }, { "name": "vector.SDE.SANPERMIT.PERMIT_YEAR", "type": "esriFieldTypeString", "alias": "Permit Year", "length": 4, "domain": null }, { "name": "vector.SDE.SANPERMIT.STATE_PLAN_ID", "type": "esriFieldTypeString", "alias": "State Plan ID", "length": 20, "domain": null }, { "name": "vector.SDE.SANPERMIT.APPLICANT_FULLNAME", "type": "esriFieldTypeString", "alias": "Applicant Name", "length": 32, "domain": null }, { "name": "vector.SDE.SANPERMIT.FIRENO_ADDRESS", "type": "esriFieldTypeString", "alias": "Site Address", "length": 40, "domain": null }, { "name": "vector.SDE.SANPERMIT.PLB68_NUMBER", "type": "esriFieldTypeString", "alias": "Plumber Number", "length": 15, "domain": null }, { "name": "vector.SDE.SANPERMIT.PLUMBER_NAME", "type": "esriFieldTypeString", "alias": "Plumber Name", "length": 40, "domain": null }, { "name": "vector.SDE.SANPERMIT.ISSUE_DATE", "type": "esriFieldTypeDate", "alias": "Issue Date", "length": 8, "domain": null }, { "name": "vector.SDE.SANPERMIT.DENIAL_DATE", "type": "esriFieldTypeDate", "alias": "Denial Date", "length": 8, "domain": null }, { "name": "vector.SDE.SANPERMIT.INSTALL_DATE", "type": "esriFieldTypeDate", "alias": "Install Date", "length": 8, "domain": null }, { "name": "vector.SDE.SANPERMIT.DATE_RECEIVED", "type": "esriFieldTypeDate", "alias": "Date Received", "length": 8, "domain": null }, { "name": "vector.SDE.SANPERMIT.MULTIPLE_SYSTEMS", "type": "esriFieldTypeString", "alias": "Multiple Systems", "length": 1, "domain": null }, { "name": "vector.SDE.SANPERMIT.POWTS_TYPE", "type": "esriFieldTypeString", "alias": "POWTS Types", "length": 32, "domain": null }, { "name": "vector.SDE.SANPERMIT.PERMIT_TYPE", "type": "esriFieldTypeString", "alias": "Permit Type", "length": 32, "domain": null }, { "name": "vector.SDE.SANPERMIT.BUILDING_TYPE", "type": "esriFieldTypeString", "alias": "Building Type", "length": 32, "domain": null }, { "name": "vector.SDE.SANPERMIT.USE_DESC", "type": "esriFieldTypeString", "alias": "Use Description", "length": 60, "domain": null }, { "name": "vector.SDE.SANPERMIT.PERMIT_DESC", "type": "esriFieldTypeString", "alias": "Permit Description", "length": 60, "domain": null }, { "name": "vector.SDE.SANPERMIT.POWTS_DESC", "type": "esriFieldTypeString", "alias": "POWTS Description", "length": 60, "domain": null }, { "name": "vector.SDE.SANPERMIT.PLUMBER_MPRS", "type": "esriFieldTypeString", "alias": "Plumber MPRS", "length": 20, "domain": null }, { "name": "vector.SDE.SANPERMIT.TANK_FLOW", "type": "esriFieldTypeString", "alias": "Tank Flow", "length": 10, "domain": null }, { "name": "vector.SDE.SANPERMIT.TANK_RATE", "type": "esriFieldTypeString", "alias": "Tank Rate", "length": 10, "domain": null }, { "name": "vector.SDE.SANPERMIT.TANK_AREA_RQ", "type": "esriFieldTypeString", "alias": "Tank Area Required", "length": 10, "domain": null }, { "name": "vector.SDE.SANPERMIT.TANK_AREA_PR", "type": "esriFieldTypeString", "alias": "Tank Area Preposed", "length": 10, "domain": null }, { "name": "vector.SDE.SANPERMIT.TANK_ELEVATION", "type": "esriFieldTypeString", "alias": "System Elevation", "length": 10, "domain": null }, { "name": "vector.SDE.SANPERMIT.TANK_INSTALL_DATE", "type": "esriFieldTypeDate", "alias": "Tank Install Date", "length": 8, "domain": null }, { "name": "vector.SDE.SANPERMIT.DRAINFD_INST_DATE", "type": "esriFieldTypeDate", "alias": "DrainFD Install Date", "length": 8, "domain": null }, { "name": "vector.SDE.SANPERMIT.NUMBER_OF_BEDROOMS", "type": "esriFieldTypeString", "alias": "# of Bedrooms", "length": 2, "domain": null }, { "name": "vector.SDE.SANPERMIT.IS_REVISED", "type": "esriFieldTypeString", "alias": "Revised?", "length": 1, "domain": null }, { "name": "vector.SDE.SANPERMIT.REVISION_DATE", "type": "esriFieldTypeDate", "alias": "Revision Date", "length": 8, "domain": null }, { "name": "vector.SDE.SANPERMIT.REVISION_REASON", "type": "esriFieldTypeString", "alias": "Revision Reason", "length": 60, "domain": null }, { "name": "vector.SDE.SANPERMIT.EXTENDED", "type": "esriFieldTypeString", "alias": "Extended", "length": 1, "domain": null }, { "name": "vector.SDE.SANPERMIT.PLUMBER_TRANSFER", "type": "esriFieldTypeString", "alias": "Plumber Transfer", "length": 1, "domain": null }, { "name": "vector.SDE.SANPERMIT.OWNER_TRANSFER", "type": "esriFieldTypeString", "alias": "Owner Transfer", "length": 1, "domain": null }, { "name": "vector.SDE.SANPERMIT.ACTIVE", "type": "esriFieldTypeString", "alias": "Active", "length": 1, "domain": null }, { "name": "vector.SDE.SANPERMIT.CHANGE_DATE", "type": "esriFieldTypeDate", "alias": "Updated Date", "length": 8, "domain": null }, { "name": "vector.SDE.SANPERMIT.CHANGE_OPID", "type": "esriFieldTypeString", "alias": "Updated By", "length": 15, "domain": null }, { "name": "vector.SDE.SANPERMIT.RESTRICTED", "type": "esriFieldTypeString", "alias": "Restricted", "length": 1, "domain": null }, { "name": "vector.SDE.SANPERMIT.APPROVED_BY", "type": "esriFieldTypeString", "alias": "Approved By", "length": 255, "domain": null }, { "name": "vector.SDE.SANPERMIT.PIN", "type": "esriFieldTypeString", "alias": "Parcel Number", "length": 20, "domain": null }, { "name": "vector.SDE.SANPERMIT.CST_BM_ELEV", "type": "esriFieldTypeString", "alias": "Soil Test BM Elevation", "length": 15, "domain": null }, { "name": "vector.SDE.SANPERMIT.INSP_BM_ELEV", "type": "esriFieldTypeString", "alias": "Inspection BM Elevations", "length": 15, "domain": null }, { "name": "vector.SDE.SANPERMIT.BM_DESCRIPTION", "type": "esriFieldTypeString", "alias": "BM Description", "length": 200, "domain": null }, { "name": "vector.SDE.SANPERMIT.SIPHON_PUMP_MANUFACTURER", "type": "esriFieldTypeString", "alias": "Pump Manufacturer", "length": 30, "domain": null }, { "name": "vector.SDE.SANPERMIT.SIPHON_PUMP_MODEL", "type": "esriFieldTypeString", "alias": "Pump Model", "length": 30, "domain": null }, { "name": "vector.SDE.SANPERMIT.SIPHON_FILTER_MANUFACTURER", "type": "esriFieldTypeString", "alias": "Filter Manufacturer", "length": 30, "domain": null }, { "name": "vector.SDE.SANPERMIT.SIPHON_FILTER_MODEL", "type": "esriFieldTypeString", "alias": "Filter Model", "length": 30, "domain": null }, { "name": "vector.SDE.SANPERMIT.SIPHON_DEMAND_GPM", "type": "esriFieldTypeString", "alias": "Demand GPM", "length": 15, "domain": null }, { "name": "vector.SDE.SANPERMIT.SIPHON_LIFT", "type": "esriFieldTypeString", "alias": "TDH Lift", "length": 15, "domain": null }, { "name": "vector.SDE.SANPERMIT.SIPHON_FRICTION_LOSS", "type": "esriFieldTypeString", "alias": "TDH Firction Loss", "length": 15, "domain": null }, { "name": "vector.SDE.SANPERMIT.SIPHON_HEAD", "type": "esriFieldTypeString", "alias": "TDH Head", "length": 15, "domain": null }, { "name": "vector.SDE.SANPERMIT.SIPHON_LENGTH", "type": "esriFieldTypeString", "alias": "Forceman Length", "length": 255, "domain": null }, { "name": "vector.SDE.SANPERMIT.SIPHON_DIA", "type": "esriFieldTypeString", "alias": "Forcemain Diameter", "length": 15, "domain": null }, { "name": "vector.SDE.SANPERMIT.DISPERSAL_WIDTH", "type": "esriFieldTypeString", "alias": "Dimensions Width", "length": 255, "domain": null }, { "name": "vector.SDE.SANPERMIT.DISPERSAL_LENGTH", "type": "esriFieldTypeString", "alias": "Dimensions Length", "length": 255, "domain": null }, { "name": "vector.SDE.SANPERMIT.DISPERSAL_NUM_CELLS", "type": "esriFieldTypeString", "alias": "Dimensions # of Cells", "length": 255, "domain": null }, { "name": "vector.SDE.SANPERMIT.DISPERSAL_CELL_TYPE", "type": "esriFieldTypeString", "alias": "Type of Cell", "length": 30, "domain": null }, { "name": "vector.SDE.SANPERMIT.DISPERSAL_MANUFACTURER", "type": "esriFieldTypeString", "alias": "Cell Manufacturer", "length": 30, "domain": null }, { "name": "vector.SDE.SANPERMIT.DISPERSAL_MODEL", "type": "esriFieldTypeString", "alias": "Cell Model", "length": 30, "domain": null }, { "name": "vector.SDE.SANPERMIT.PRETREAT_MANUFACTURER", "type": "esriFieldTypeString", "alias": "Pretreatment Manufacturer", "length": 30, "domain": null }, { "name": "vector.SDE.SANPERMIT.PRETREAT_MODEL", "type": "esriFieldTypeString", "alias": "Pretreatment Model", "length": 30, "domain": null }, { "name": "vector.SDE.SANPERMIT.DIST_MAN_LENGTH", "type": "esriFieldTypeString", "alias": "Header/Manifold Length", "length": 15, "domain": null }, { "name": "vector.SDE.SANPERMIT.DIST_MAN_DIA", "type": "esriFieldTypeString", "alias": "Header/Manifold Diameter", "length": 15, "domain": null }, { "name": "vector.SDE.SANPERMIT.DIST_PIPE_LENGTH", "type": "esriFieldTypeString", "alias": "Distribution Pipe Length", "length": 15, "domain": null }, { "name": "vector.SDE.SANPERMIT.DIST_PIPE_DIA", "type": "esriFieldTypeString", "alias": "Distribution Pipe Diameter", "length": 15, "domain": null }, { "name": "vector.SDE.SANPERMIT.DIST_PIPE_SPAC", "type": "esriFieldTypeString", "alias": "Distribution Pipe Spac", "length": 15, "domain": null }, { "name": "vector.SDE.SANPERMIT.DIST_XHOLE_SIZE", "type": "esriFieldTypeString", "alias": "X Hole Size", "length": 15, "domain": null }, { "name": "vector.SDE.SANPERMIT.DIST_XHOLE_SPACING", "type": "esriFieldTypeString", "alias": "X Hole Spacing", "length": 15, "domain": null }, { "name": "vector.SDE.SANPERMIT.DIST_OBSERV_PIPE", "type": "esriFieldTypeString", "alias": "Observation Pipes", "length": 1, "domain": null }, { "name": "vector.SDE.SANPERMIT.SOIL_DEPTH_CENTER", "type": "esriFieldTypeString", "alias": "Depth Over Cell Center", "length": 15, "domain": null }, { "name": "vector.SDE.SANPERMIT.SOIL_DEPTH_EDGES", "type": "esriFieldTypeString", "alias": "Depth Over Cell Edges", "length": 15, "domain": null }, { "name": "vector.SDE.SANPERMIT.SOIL_DEPTH_TOPSOIL", "type": "esriFieldTypeString", "alias": "Depth to Topsoil", "length": 15, "domain": null }, { "name": "vector.SDE.SANPERMIT.SOIL_SEEDED", "type": "esriFieldTypeString", "alias": "Seeded/Sodded", "length": 1, "domain": null }, { "name": "vector.SDE.SANPERMIT.SOIL_MULCHED", "type": "esriFieldTypeString", "alias": "Mulched", "length": 1, "domain": null }, { "name": "vector.SDE.SANPERMIT.DOC_DATE", "type": "esriFieldTypeDate", "alias": "Document Date", "length": 8, "domain": null }, { "name": "vector.SDE.SANPERMIT.REV_REQ", "type": "esriFieldTypeSmallInteger", "alias": "vector.SDE.SANPERMIT.REV_REQ", "domain": null } ], "geometryField": { "name": "vector.SDE.Zoning_Parcel_Points.Shape", "type": "esriFieldTypeGeometry", "alias": "SHAPE" }, "indexes": [ { "name": "R1273_pk", "fields": "vector.SDE.Zoning_Parcel_Points.OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "UUID_1273", "fields": "vector.SDE.Zoning_Parcel_Points.GlobalID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "UUID_OID_1273", "fields": "vector.SDE.Zoning_Parcel_Points.GlobalID,vector.SDE.Zoning_Parcel_Points.OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "GDB_42973_PIN", "fields": "vector.SDE.Zoning_Parcel_Points.PIN", "isAscending": true, "isUnique": false, "description": "" }, { "name": "S1024_idx", "fields": "vector.SDE.Zoning_Parcel_Points.Shape", "isAscending": true, "isUnique": true, "description": "" }, { "name": "R1263_SDE_ROWID_UK", "fields": "vector.SDE.SANPERMIT.OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "GDB_42159_PERMIT_NUMBER", "fields": "vector.SDE.SANPERMIT.PERMIT_NUMBER", "isAscending": true, "isUnique": false, "description": "" } ], "subtypes": [], "relationships": [ { "id": 0, "name": "vector.SDE.SANINSPECTION", "relatedTableId": 2, "role": "esriRelRoleOrigin", "keyField": "PIN", "cardinality": "esriRelCardinalityOneToMany", "composite": false, "catalogID": "{3C6AC585-1B50-4A90-9A3D-9B11D77445B6}" }, { "id": 1, "name": "vector.SDE.SANTANKS", "relatedTableId": 1, "role": "esriRelRoleOrigin", "keyField": "PIN", "cardinality": "esriRelCardinalityOneToMany", "composite": false, "catalogID": "{0CF26949-766E-42B7-8F78-61E220150136}" } ], "canModifyLayer": true, "canScaleSymbols": false, "hasLabels": false, "capabilities": "Map,Query,Data", "maxRecordCount": 2000, "maxSelectionCount": 2000, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON, geoJSON, PBF", "isDataVersioned": true, "ownershipBasedAccessControlForFeatures": {"allowOthersToQuery": true}, "useStandardizedQueries": true, "supportedSpatialRelationships": [ "esriSpatialRelIntersects", "esriSpatialRelContains", "esriSpatialRelCrosses", "esriSpatialRelEnvelopeIntersects", "esriSpatialRelIndexIntersects", "esriSpatialRelOverlaps", "esriSpatialRelTouches", "esriSpatialRelWithin", "esriSpatialRelRelation" ], "advancedQueryCapabilities": { "useStandardizedQueries": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsAdvancedQueryRelated": true, "supportsQueryRelatedPagination": true, "supportsPagination": true, "supportsLod": false, "supportsQueryWithLodSR": false, "supportsTrueCurve": true, "supportsQueryWithDatumTransformation": true, "supportsReturningQueryExtent": true, "supportsQueryWithDistance": true, "supportsSqlExpression": true, "supportsTimeRelation": true, "supportsSqlFormat": false, "supportsQueryAnalytic": true, "supportsCurrentUserQueries": true }, "supportsDatumTransformation": true, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": false, "supportsPercentileAnalytic": true }, "dateFieldsTimeReference": null, "preferredTimeReference": null, "datesInUnknownTimezone": false, "hasMetadata": true, "isDataArchived": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "supportsCoordinatesQuantization": true, "supportsDynamicLegends": true, "serviceItemId": "21a368db418c40cd9cdec82d3c0c6b38" } ], "tables": [ { "currentVersion": 11.5, "cimVersion": "3.5.0", "id": 1, "name": "Sanitary Tanks", "type": "Table", "description": null, "copyrightText": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayFieldExpressionInfo": { "expression": "var tt = $feature.TANK_TYPE\n\nif (tt == 'S'){\n return 'Septic'\n} \nif (tt == 'DC'){\n return 'Dosing Chamber'\n}\nif (tt == 'HT'){\n return 'Holding Tanks'\n}\nelse {\n null\n}", "title": "Custom" }, "displayField": "PERMIT_NUMBER", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "PERMIT_NUMBER", "type": "esriFieldTypeString", "alias": "Permit Number", "length": 20, "domain": null }, { "name": "PIN", "type": "esriFieldTypeString", "alias": "PIN", "length": 20, "domain": null }, { "name": "REVISION_NUMBER", "type": "esriFieldTypeString", "alias": "Revision Number", "length": 15, "domain": null }, { "name": "TANK_TYPE", "type": "esriFieldTypeString", "alias": "Tank Type", "length": 20, "domain": null }, { "name": "SEQ", "type": "esriFieldTypeString", "alias": "Sequence", "length": 1, "domain": null }, { "name": "NUM_UNITS", "type": "esriFieldTypeString", "alias": "Number of Units", "length": 1, "domain": null }, { "name": "GALLONS_NEW", "type": "esriFieldTypeString", "alias": "Gallons New", "length": 10, "domain": null }, { "name": "GALLONS_EX", "type": "esriFieldTypeString", "alias": "Gallons Exisiting", "length": 10, "domain": null }, { "name": "MANUFACTURER", "type": "esriFieldTypeString", "alias": "Manufacturer", "length": 20, "domain": null }, { "name": "PC", "type": "esriFieldTypeString", "alias": "Prefab Concrete", "length": 1, "domain": null }, { "name": "SC", "type": "esriFieldTypeString", "alias": "Site Constructed", "length": 1, "domain": null }, { "name": "ST", "type": "esriFieldTypeString", "alias": "Steel", "length": 1, "domain": null }, { "name": "FG", "type": "esriFieldTypeString", "alias": "Fiber Glass", "length": 1, "domain": null }, { "name": "PL", "type": "esriFieldTypeString", "alias": "Plastic", "length": 1, "domain": null }, { "name": "GlobalID", "type": "esriFieldTypeGlobalID", "alias": "GlobalID", "length": 38, "domain": null } ], "indexes": [ { "name": "R1269_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "GDB_42963_PERMIT_NUMBER", "fields": "PERMIT_NUMBER", "isAscending": true, "isUnique": false, "description": "" }, { "name": "UUID_1269", "fields": "GlobalID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "UUID_OID_1269", "fields": "GlobalID,OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "GDB_42963_PIN", "fields": "PIN", "isAscending": true, "isUnique": false, "description": "" } ], "subtypes": [], "relationships": [ { "id": 1, "name": "vector.SDE.Zoning_Parcel_Points", "relatedTableId": 4, "role": "esriRelRoleDestination", "keyField": "PIN", "cardinality": "esriRelCardinalityOneToMany", "composite": false, "catalogID": "{0CF26949-766E-42B7-8F78-61E220150136}" } ], "capabilities": "Map,Query,Data", "maxRecordCount": 2000, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON, PBF", "isDataVersioned": true, "useStandardizedQueries": true, "advancedQueryCapabilities": { "useStandardizedQueries": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsPagination": true, "supportsTrueCurve": false, "supportsReturningQueryExtent": true, "supportsQueryWithDistance": true, "supportsSqlExpression": true, "supportsTimeRelation": true, "supportsAdvancedQueryRelated": true, "supportsQueryRelatedPagination": true, "supportsSqlFormat": false, "supportsQueryAnalytic": true, "supportsCurrentUserQueries": true }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": false, "supportsPercentileAnalytic": true }, "dateFieldsTimeReference": null, "preferredTimeReference": null, "datesInUnknownTimezone": false, "hasMetadata": true, "isDataArchived": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "serviceItemId": "21a368db418c40cd9cdec82d3c0c6b38" }, { "currentVersion": 11.5, "cimVersion": "3.5.0", "id": 2, "name": "Sanitary Inspection", "type": "Table", "description": null, "copyrightText": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "Date", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "Inspector", "type": "esriFieldTypeString", "alias": "Inspector", "length": 40, "domain": { "type": "codedValue", "name": "POWTS Inspector", "description": "POWTS inspectors", "codedValues": [ { "name": "Sarah Elsner", "code": "SE" }, { "name": "Caleb Dammen", "code": "CD" }, { "name": "Haley Nielsen", "code": "HN" }, { "name": "Matt Zangl", "code": "MZ" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "Date", "type": "esriFieldTypeDate", "alias": "Date", "length": 8, "domain": null }, { "name": "PIN", "type": "esriFieldTypeString", "alias": "PIN", "length": 20, "domain": null }, { "name": "Permit_Number", "type": "esriFieldTypeString", "alias": "Permit Number", "length": 15, "domain": null }, { "name": "CST_BM_Elevation", "type": "esriFieldTypeDouble", "alias": "Soil Test BM Elevation", "domain": null }, { "name": "INSP_BM_Elevation", "type": "esriFieldTypeDouble", "alias": "Inspection BM Elevation", "domain": null }, { "name": "BM_Desc", "type": "esriFieldTypeString", "alias": "Benchmark Description", "length": 255, "domain": null }, { "name": "Benchmark_BS", "type": "esriFieldTypeDouble", "alias": "Benchmark backsight", "domain": null }, { "name": "Benchmark_HI", "type": "esriFieldTypeDouble", "alias": "Benchmark Height of Insturment", "domain": null }, { "name": "Benchmark_FS", "type": "esriFieldTypeDouble", "alias": "Benchmark foresight", "domain": null }, { "name": "TurningPoint", "type": "esriFieldTypeString", "alias": "TurningPoint", "length": 5, "domain": { "type": "codedValue", "name": "Y/N", "description": "Yes/No and N/A Domain", "codedValues": [ { "name": "Yes", "code": "Y" }, { "name": "No", "code": "N" }, { "name": "N/A", "code": "N/A" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "PRETANK_PROPLINE", "type": "esriFieldTypeString", "alias": "Text setback to property line", "length": 10, "domain": { "type": "codedValue", "name": "POWTS Setback Pretext", "description": "", "codedValues": [ { "name": "NA", "code": "NA" }, { "name": "NI", "code": "NI" }, { "name": "+", "code": "+" }, { "name": "Actual Distance", "code": "DIST" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "TANK_PROPLINE", "type": "esriFieldTypeSingle", "alias": "Tank setback to property line", "domain": null }, { "name": "PRETANK_WELL", "type": "esriFieldTypeString", "alias": "Text tank setback to well", "length": 10, "domain": { "type": "codedValue", "name": "POWTS Setback Pretext", "description": "", "codedValues": [ { "name": "NA", "code": "NA" }, { "name": "NI", "code": "NI" }, { "name": "+", "code": "+" }, { "name": "Actual Distance", "code": "DIST" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "TANK_WELL", "type": "esriFieldTypeSingle", "alias": "Tank setback to well", "domain": null }, { "name": "PRETANK_BUILDING", "type": "esriFieldTypeString", "alias": "Text tank setback to building", "length": 10, "domain": { "type": "codedValue", "name": "POWTS Setback Pretext", "description": "", "codedValues": [ { "name": "NA", "code": "NA" }, { "name": "NI", "code": "NI" }, { "name": "+", "code": "+" }, { "name": "Actual Distance", "code": "DIST" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "TANK_BUILDING", "type": "esriFieldTypeSingle", "alias": "Tank setback to building", "domain": null }, { "name": "PRETANK_AIRINTAKE", "type": "esriFieldTypeString", "alias": "Text tank setback to air intake", "length": 10, "domain": { "type": "codedValue", "name": "POWTS Setback Pretext", "description": "", "codedValues": [ { "name": "NA", "code": "NA" }, { "name": "NI", "code": "NI" }, { "name": "+", "code": "+" }, { "name": "Actual Distance", "code": "DIST" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "TANK_AIRINTAKE", "type": "esriFieldTypeSingle", "alias": "Tank setback to air intake", "domain": null }, { "name": "SIPHON_PUMP_MANUFACTURER", "type": "esriFieldTypeString", "alias": "Pump Manufacturer", "length": 255, "domain": null }, { "name": "SIPHON_PUMP_MODEL", "type": "esriFieldTypeString", "alias": "Pump Model", "length": 255, "domain": null }, { "name": "SIPHON_FILTER_MANUFACTURER", "type": "esriFieldTypeString", "alias": "Filter Manufacturer", "length": 255, "domain": null }, { "name": "SIPHON_FILTER_MODEL", "type": "esriFieldTypeString", "alias": "Filter Model", "length": 255, "domain": null }, { "name": "SIPHON_DEMAND_GPM", "type": "esriFieldTypeSingle", "alias": "Demain GPM", "domain": null }, { "name": "SIPHON_LIFT", "type": "esriFieldTypeSingle", "alias": "TDH Lift", "domain": null }, { "name": "SIPHON_FRICTION_LOSS", "type": "esriFieldTypeSingle", "alias": "TDH Frction Loss", "domain": null }, { "name": "SIPHON_HEAD", "type": "esriFieldTypeSingle", "alias": "TDH Head", "domain": null }, { "name": "SIPHON_LENGTH", "type": "esriFieldTypeSingle", "alias": "Forcemain Length", "domain": null }, { "name": "SIPHON_DIA", "type": "esriFieldTypeSingle", "alias": "Forcemain Diameter", "domain": null }, { "name": "PRESIPHON_DISTTOWELL", "type": "esriFieldTypeString", "alias": "Text forcemain distance to well", "length": 255, "domain": { "type": "codedValue", "name": "POWTS Setback Pretext", "description": "", "codedValues": [ { "name": "NA", "code": "NA" }, { "name": "NI", "code": "NI" }, { "name": "+", "code": "+" }, { "name": "Actual Distance", "code": "DIST" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "SIPHON_DISTTOWELL", "type": "esriFieldTypeSingle", "alias": "Forceman Distance to well", "domain": null }, { "name": "DISPERSAL_WIDTH", "type": "esriFieldTypeSingle", "alias": "Dimensions Width", "domain": null }, { "name": "DISPERSAL_LENGTH", "type": "esriFieldTypeSingle", "alias": "Dimensions Length", "domain": null }, { "name": "DISPERSAL_NUM_CELLS", "type": "esriFieldTypeSmallInteger", "alias": "# of Cells", "domain": null }, { "name": "PREDISPERSAL_PROPLINE", "type": "esriFieldTypeString", "alias": "Text cell setback from property line", "length": 255, "domain": { "type": "codedValue", "name": "POWTS Setback Pretext", "description": "", "codedValues": [ { "name": "NA", "code": "NA" }, { "name": "NI", "code": "NI" }, { "name": "+", "code": "+" }, { "name": "Actual Distance", "code": "DIST" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "DISPERSAL_PROPLINE", "type": "esriFieldTypeSingle", "alias": "Cell setback from property line", "domain": null }, { "name": "PREDISPERSAL_BUILDING", "type": "esriFieldTypeString", "alias": "Text cell setback from building", "length": 255, "domain": { "type": "codedValue", "name": "POWTS Setback Pretext", "description": "", "codedValues": [ { "name": "NA", "code": "NA" }, { "name": "NI", "code": "NI" }, { "name": "+", "code": "+" }, { "name": "Actual Distance", "code": "DIST" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "DISPERSAL_BUILDING", "type": "esriFieldTypeSingle", "alias": "Cell setback from building", "domain": null }, { "name": "PREDISPERSAL_WELL", "type": "esriFieldTypeString", "alias": "Text cell setback from well", "length": 255, "domain": { "type": "codedValue", "name": "POWTS Setback Pretext", "description": "", "codedValues": [ { "name": "NA", "code": "NA" }, { "name": "NI", "code": "NI" }, { "name": "+", "code": "+" }, { "name": "Actual Distance", "code": "DIST" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "DISPERSAL_WELL", "type": "esriFieldTypeSingle", "alias": "Cell setback from well", "domain": null }, { "name": "PREDISPERSAL_OHWM", "type": "esriFieldTypeString", "alias": "Text cell setback from OHWM", "length": 255, "domain": { "type": "codedValue", "name": "POWTS Setback Pretext", "description": "", "codedValues": [ { "name": "NA", "code": "NA" }, { "name": "NI", "code": "NI" }, { "name": "+", "code": "+" }, { "name": "Actual Distance", "code": "DIST" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "DISPERSAL_OHWM", "type": "esriFieldTypeSingle", "alias": "Cell setback from OHWM", "domain": null }, { "name": "DISPERSAL_CELL_TYPE", "type": "esriFieldTypeString", "alias": "Type of Cell", "length": 255, "domain": null }, { "name": "DISPERSAL_MANUFACTURER", "type": "esriFieldTypeString", "alias": "Cell Manufacturer", "length": 255, "domain": null }, { "name": "DISPERSAL_MODEL", "type": "esriFieldTypeString", "alias": "Cell Model", "length": 255, "domain": null }, { "name": "PRETREAT_MANUFACTURER", "type": "esriFieldTypeString", "alias": "Pretreatment Manufacturer", "length": 255, "domain": null }, { "name": "PRETREAT_MODEL", "type": "esriFieldTypeString", "alias": "Pretreatment Model", "length": 255, "domain": null }, { "name": "Comment", "type": "esriFieldTypeString", "alias": "Comment", "length": 1000, "domain": null }, { "name": "GlobalID", "type": "esriFieldTypeGlobalID", "alias": "GlobalID", "length": 38, "domain": null }, { "name": "TurningPoint_BS2", "type": "esriFieldTypeDouble", "alias": "Turning point backsight 2", "domain": null }, { "name": "TurningPoint_HI2", "type": "esriFieldTypeDouble", "alias": "Turning point HI 2", "domain": null }, { "name": "TurningPoint_FS2", "type": "esriFieldTypeDouble", "alias": "Turning point foresight 2", "domain": null }, { "name": "SIPHON_TOTAL", "type": "esriFieldTypeSingle", "alias": "SIPHON_TOTAL", "domain": null }, { "name": "TurningPoint_BS3", "type": "esriFieldTypeDouble", "alias": "Turning point backsight 3", "domain": null }, { "name": "TurningPoint_HI3", "type": "esriFieldTypeDouble", "alias": "Turning point HI3", "domain": null }, { "name": "TurningPoint_FS3", "type": "esriFieldTypeDouble", "alias": "Turning point foresight 3", "domain": null } ], "indexes": [ { "name": "R1280_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "G43382Permit_Number", "fields": "Permit_Number", "isAscending": true, "isUnique": false, "description": "" }, { "name": "UUID_1280", "fields": "GlobalID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "GDB_43382_PIN", "fields": "PIN", "isAscending": true, "isUnique": false, "description": "" } ], "subtypes": [], "relationships": [ { "id": 2, "name": "vector.SDE.ElevationData", "relatedTableId": 3, "role": "esriRelRoleOrigin", "keyField": "GlobalID", "cardinality": "esriRelCardinalityOneToMany", "composite": false, "catalogID": "{49A3BCF8-5600-46F9-B0A0-85C2779D5B7A}" }, { "id": 0, "name": "vector.SDE.Zoning_Parcel_Points", "relatedTableId": 4, "role": "esriRelRoleDestination", "keyField": "PIN", "cardinality": "esriRelCardinalityOneToMany", "composite": false, "catalogID": "{3C6AC585-1B50-4A90-9A3D-9B11D77445B6}" } ], "capabilities": "Map,Query,Data", "maxRecordCount": 2000, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON, PBF", "isDataVersioned": false, "useStandardizedQueries": true, "advancedQueryCapabilities": { "useStandardizedQueries": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsPagination": true, "supportsTrueCurve": false, "supportsReturningQueryExtent": true, "supportsQueryWithDistance": true, "supportsSqlExpression": true, "supportsTimeRelation": true, "supportsAdvancedQueryRelated": true, "supportsQueryRelatedPagination": true, "supportsSqlFormat": false, "supportsQueryAnalytic": true, "supportsCurrentUserQueries": true }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": false, "supportsPercentileAnalytic": true }, "dateFieldsTimeReference": null, "preferredTimeReference": null, "datesInUnknownTimezone": false, "hasMetadata": true, "isDataArchived": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "serviceItemId": "21a368db418c40cd9cdec82d3c0c6b38" }, { "currentVersion": 11.5, "cimVersion": "3.5.0", "id": 3, "name": "Sanitary Elevation Points", "type": "Table", "description": null, "copyrightText": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "InfastructureType", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "Permit_Number1", "type": "esriFieldTypeString", "alias": "Permit_Number", "length": 255, "domain": null }, { "name": "InfastructureType", "type": "esriFieldTypeString", "alias": "InfastructureType", "length": 255, "domain": { "type": "codedValue", "name": "SanInfastructure", "description": "Sanitary infastructure types for POWTS inspection", "codedValues": [ { "name": "Building Sewer", "code": "BS" }, { "name": "Tank Inlet", "code": "TI" }, { "name": "Tank Outlet", "code": "TO" }, { "name": "Dose Tank Inlet", "code": "DTI" }, { "name": "Dose Tank Bottom", "code": "DTB" }, { "name": "Inst. Contour", "code": "IC" }, { "name": "Header/Manifold", "code": "HM" }, { "name": "Distribution Pipe", "code": "DP" }, { "name": "Infiltrative Surface", "code": "IS" }, { "name": "Final Grade", "code": "FG" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "FS", "type": "esriFieldTypeString", "alias": "Foresight", "length": 255, "domain": null }, { "name": "Elevation", "type": "esriFieldTypeSmallInteger", "alias": "ElevationHI", "domain": null }, { "name": "ELEV_CALC", "type": "esriFieldTypeDouble", "alias": "Infastructure Elevation ", "domain": null }, { "name": "Comments", "type": "esriFieldTypeString", "alias": "Comments/Desc.", "length": 1000, "domain": null }, { "name": "GlobalID", "type": "esriFieldTypeGlobalID", "alias": "GlobalID", "length": 38, "domain": null }, { "name": "InspectionID", "type": "esriFieldTypeGUID", "alias": "InspectionID", "length": 38, "domain": null } ], "indexes": [ { "name": "R1281_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "G43383Permit_Number", "fields": "Permit_Number1", "isAscending": true, "isUnique": false, "description": "" }, { "name": "UUID_1281", "fields": "GlobalID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "GDB_43383_InspectionID", "fields": "InspectionID", "isAscending": true, "isUnique": false, "description": "" } ], "subtypes": [], "relationships": [ { "id": 2, "name": "vector.SDE.SANINSPECTION", "relatedTableId": 2, "role": "esriRelRoleDestination", "keyField": "InspectionID", "cardinality": "esriRelCardinalityOneToMany", "composite": false, "catalogID": "{49A3BCF8-5600-46F9-B0A0-85C2779D5B7A}" } ], "capabilities": "Map,Query,Data", "maxRecordCount": 2000, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON, PBF", "isDataVersioned": false, "useStandardizedQueries": true, "advancedQueryCapabilities": { "useStandardizedQueries": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsPagination": true, "supportsTrueCurve": false, "supportsReturningQueryExtent": true, "supportsQueryWithDistance": true, "supportsSqlExpression": true, "supportsTimeRelation": true, "supportsAdvancedQueryRelated": true, "supportsQueryRelatedPagination": true, "supportsSqlFormat": false, "supportsQueryAnalytic": true, "supportsCurrentUserQueries": true }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": false, "supportsPercentileAnalytic": true }, "dateFieldsTimeReference": null, "preferredTimeReference": null, "datesInUnknownTimezone": false, "hasMetadata": true, "isDataArchived": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "serviceItemId": "21a368db418c40cd9cdec82d3c0c6b38" } ] }