{ "tables": [], "layers": [ { "isCoGoEnabled": false, "extent": { "ymin": 4946366.016599998, "xmin": -8409971.0539, "ymax": 4958691.269500002, "xmax": -8395755.9515, "spatialReference": { "falseM": -100000, "xyTolerance": 0.001, "mUnits": 10000, "zUnits": 10000, "latestWkid": 3857, "zTolerance": 0.001, "wkid": 102100, "xyUnits": 10000, "mTolerance": 0.001, "falseX": -20037700, "falseY": -30241100, "falseZ": -100000 } }, "isDataBranchVersioned": false, "supportsApplyEditsWithGlobalIds": true, "maxRecordCount": 2000, "infoInEstimates": [ "extent", "count" ], "type": "Feature Layer", "onlyAllowTrueCurveUpdatesByTrueCurveClients": true, "supportsAttachmentsByUploadId": true, "editingInfo": {}, "relationships": [], "supportsAttachmentsResizing": true, "cimVersion": "2.6.0", "isDataArchived": false, "id": 1, "spatialReference": { "falseM": -100000, "xyTolerance": 0.001, "mUnits": 10000, "zUnits": 10000, "latestWkid": 3857, "zTolerance": 0.001, "wkid": 102100, "xyUnits": 10000, "mTolerance": 0.001, "falseX": -20037700, "falseY": -30241100, "falseZ": -100000 }, "supportsStatistics": true, "supportedExportFormats": "sqlite,filegdb,shapefile,csv,geojson", "standardMaxRecordCount": 16000, "isDataVersioned": false, "templates": [ { "name": "Sanitary Manhole", "description": "", "drawingTool": "esriFeatureEditToolPoint", "prototype": { "attributes": { "top_elevation": null, "chamber_description": null, "notes": null, "chamber_width": null, "manhole_type": 1, "infrastructure_type": null, "infrastructure_class": "1", "me_id": null, "enabled": 1, "chamber_height": null, "diameter": null, "createdby": null, "street": null, "lifecycle_status": null, "install_date": null, "connections": null, "lucity_id": null, "cityworks_id": null, "manhole_insertdate": null, "address": null, "construction_asbuilt": null, "concatenated_id": null, "infrastructure_id": null, "outflow_elevation": null, "manhole_inserttype": null, "createdon": null, "lid_type": null, "modifiedon": null, "depth": null, "ownership": null, "material": null, "chamber_length": null, "location": null, "lateral_asbuilt": null, "modifiedby": null } } } ], "hasGeometryProperties": true, "supportsAdvancedQueries": true, "parentLayer": { "name": "LCA Sanitary", "id": 0 }, "currentVersion": 11.5, "canScaleSymbols": false, "hasZ": false, "advancedEditingCapabilities": { "supportsAsyncApplyEdits": true, "supportsApplyEditsbyUploadID": true, "supportsReturnEditResults": true, "supportedSqlFormatsInCalculate": [ "standard" ], "supportedApplyEditsUploadIDFormats": "JSON,PBF" }, "objectIdField": "objectid", "supportsQuantizationEditMode": true, "hasContingentValuesDefinition": false, "name": "Sanitary Manhole", "allowTrueCurvesUpdates": false, "displayField": "me_id", "supportsCalculate": true, "fields": [ { "nullable": false, "defaultValue": null, "editable": false, "length": 4, "type": "esriFieldTypeOID", "modelName": "OBJECTID", "domain": null, "name": "objectid", "alias": "OBJECTID" }, { "modelName": "ME_ID", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "me_id", "length": 12, "alias": "Metcaff Eddy ID", "type": "esriFieldTypeString" }, { "modelName": "LIFECYCLE_STATUS", "nullable": true, "editable": true, "defaultValue": null, "domain": { "splitPolicy": "esriSPTDefaultValue", "name": "SAN_Status", "description": "Sanitary Lifecycle Status", "type": "codedValue", "codedValues": [ { "code": 1, "name": "Active" }, { "code": 2, "name": "Proposed" }, { "code": 3, "name": "Abandoned" } ], "mergePolicy": "esriMPTDefaultValue" }, "name": "lifecycle_status", "alias": "Lifecycle Status", "type": "esriFieldTypeInteger" }, { "modelName": "MANHOLE_TYPE", "nullable": true, "editable": true, "defaultValue": 1, "domain": null, "name": "manhole_type", "alias": "Manhole Type", "type": "esriFieldTypeSmallInteger" }, { "modelName": "OWNERSHIP", "nullable": true, "editable": true, "defaultValue": null, "domain": { "splitPolicy": "esriSPTDefaultValue", "name": "SAN_Ownership", "description": "Sanitary Ownership", "type": "codedValue", "codedValues": [ { "code": 1, "name": "City of Allentown" }, { "code": 2, "name": "City of Bethlehem" }, { "code": 3, "name": "Coplay-Whitehall" }, { "code": 4, "name": "Emmaus" }, { "code": 5, "name": "Hanover Twp" }, { "code": 6, "name": "L.C.A." }, { "code": 7, "name": "Private" }, { "code": 8, "name": "Salisbury Twp" }, { "code": 9, "name": "South Whitehall Twp" }, { "code": 10, "name": "Upper Macungie" }, { "code": 11, "name": "Whitehall Twp" } ], "mergePolicy": "esriMPTDefaultValue" }, "name": "ownership", "alias": "Ownership", "type": "esriFieldTypeInteger" }, { "modelName": "INSTALL_DATE", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "precision": 1, "name": "install_date", "length": 29, "alias": "Install Date", "type": "esriFieldTypeDate" }, { "modelName": "TOP_ELEVATION", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "top_elevation", "alias": "Top Rim Elevation", "type": "esriFieldTypeDouble" }, { "modelName": "OUTFLOW_ELEVATION", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "outflow_elevation", "alias": "Outflow Elevation", "type": "esriFieldTypeDouble" }, { "modelName": "LID_TYPE", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "lid_type", "length": 16, "alias": "Lid Type", "type": "esriFieldTypeString" }, { "modelName": "MANHOLE_INSERTTYPE", "nullable": true, "editable": true, "defaultValue": null, "domain": { "splitPolicy": "esriSPTDefaultValue", "name": "SAN_InsertType", "description": "Sanitary Insert Type", "type": "codedValue", "codedValues": [ { "code": 1, "name": "Existing Insert" }, { "code": 2, "name": "Plastic Insert" }, { "code": 3, "name": "Unknown" }, { "code": 4, "name": "Solid" }, { "code": 5, "name": "Repaired & Sealed" }, { "code": 6, "name": "Bolted Solid" }, { "code": 7, "name": "plugged" }, { "code": 8, "name": "need insert" } ], "mergePolicy": "esriMPTDefaultValue" }, "name": "manhole_inserttype", "alias": "Manhole Insert Type", "type": "esriFieldTypeInteger" }, { "modelName": "INSTALL_DATE", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "precision": 1, "name": "manhole_insertdate", "length": 29, "alias": "Manhole Insert Date", "type": "esriFieldTypeDate" }, { "modelName": "ADDRESS", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "address", "length": 50, "alias": "Address", "type": "esriFieldTypeString" }, { "modelName": "STREET", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "street", "length": 100, "alias": "Street", "type": "esriFieldTypeString" }, { "modelName": "Location", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "location", "length": 100, "alias": "Location", "type": "esriFieldTypeString" }, { "modelName": "ENABLED", "nullable": true, "editable": true, "defaultValue": 1, "domain": { "splitPolicy": "esriSPTDefaultValue", "name": "EnabledDomain", "description": "", "type": "codedValue", "codedValues": [ { "code": 0, "name": "False" }, { "code": 1, "name": "True" } ], "mergePolicy": "esriMPTDefaultValue" }, "name": "enabled", "alias": "Enabled", "type": "esriFieldTypeSmallInteger" }, { "modelName": "LATERAL_ASBUILT", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "lateral_asbuilt", "length": 12, "alias": "Lateral Asbuilt", "type": "esriFieldTypeString" }, { "modelName": "CONSTRUCTION_ASBUILT", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "construction_asbuilt", "length": 12, "alias": "Construction Asbuilt", "type": "esriFieldTypeString" }, { "modelName": "DEPTH", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "depth", "alias": "Depth", "type": "esriFieldTypeDouble" }, { "modelName": "DIAMETER", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "diameter", "alias": "Diameter", "type": "esriFieldTypeSmallInteger" }, { "modelName": "MATERIAL", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "material", "length": 8, "alias": "Material", "type": "esriFieldTypeString" }, { "modelName": "CONNECTIONS", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "connections", "alias": "Connections", "type": "esriFieldTypeSmallInteger" }, { "modelName": "CHAMBER_LENGTH", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "chamber_length", "alias": "Chamber Length", "type": "esriFieldTypeDouble" }, { "modelName": "CHAMBER_WIDTH", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "chamber_width", "alias": "Chamber Width", "type": "esriFieldTypeDouble" }, { "modelName": "CHAMBER_HEIGHT", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "chamber_height", "alias": "Chamber Height", "type": "esriFieldTypeDouble" }, { "modelName": "CHAMBER_DESCRIPTION", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "chamber_description", "length": 80, "alias": "Chamber Description", "type": "esriFieldTypeString" }, { "modelName": "NOTES", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "notes", "length": 255, "alias": "Notes", "type": "esriFieldTypeString" }, { "modelName": "INFRASTRUCTURE_ID", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "infrastructure_id", "length": 5, "alias": "Infrastructure ID", "type": "esriFieldTypeString" }, { "modelName": "INFRASTRUCTURE_TYPE", "nullable": true, "editable": true, "defaultValue": null, "domain": { "splitPolicy": "esriSPTDefaultValue", "name": "SAN_InfrastructureType_1", "description": "Sanitary Infrastructure Types", "type": "codedValue", "codedValues": [ { "code": "40", "name": "San Main Segment" }, { "code": "41", "name": "San Manhole" }, { "code": "42", "name": "San Fitting" }, { "code": "43", "name": "San Lateral" }, { "code": "44", "name": "San Wye" }, { "code": "45", "name": "San Stub" }, { "code": "46", "name": "San Junction Box" }, { "code": "47", "name": "San Clean Out" }, { "code": "48", "name": "San Meter" } ], "mergePolicy": "esriMPTDefaultValue" }, "name": "infrastructure_type", "length": 2, "alias": "Infrastructure Type", "type": "esriFieldTypeString" }, { "modelName": "INFRASTRUCTURE_CLASS", "nullable": true, "editable": true, "defaultValue": "1", "domain": null, "name": "infrastructure_class", "length": 1, "alias": "Infrastructure Class", "type": "esriFieldTypeString" }, { "modelName": "CONCATENATED_ID", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "concatenated_id", "length": 8, "alias": "Concatenated ID", "type": "esriFieldTypeString" }, { "modelName": "CREATEDBY", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "createdby", "length": 30, "alias": "Created By", "type": "esriFieldTypeString" }, { "modelName": "CREATEDON", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "precision": 1, "name": "createdon", "length": 29, "alias": "Created On", "type": "esriFieldTypeDate" }, { "modelName": "MODIFIEDBY", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "modifiedby", "length": 30, "alias": "Modified By", "type": "esriFieldTypeString" }, { "modelName": "MODIFIEDON", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "precision": 1, "name": "modifiedon", "length": 29, "alias": "Modified On", "type": "esriFieldTypeDate" }, { "modelName": "LucityLinkID", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "lucity_id", "alias": "Lucity Link ID", "type": "esriFieldTypeInteger" }, { "modelName": "CITYWORKS_ID", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "cityworks_id", "length": 15, "alias": "CITYWORKS_ID", "type": "esriFieldTypeString" }, { "nullable": false, "editable": false, "defaultValue": null, "length": 38, "type": "esriFieldTypeGlobalID", "modelName": "GlobalID", "domain": null, "name": "globalid", "alias": "GlobalID" } ], "maxRecordCountFactor": 1, "dateFieldsTimeReference": { "timeZoneIANA": "Etc/UTC", "respectsDaylightSaving": false, "timeZone": "UTC" }, "supportsFieldDescriptionProperty": true, "hasM": false, "allowGeometryUpdates": true, "useStandardizedQueries": true, "globalIdField": "globalid", "sourceSpatialReference": { "wkt": "PROJCS[\"WGS_1984_Web_Mercator_Auxiliary_Sphere\",GEOGCS[\"GCS_WGS_1984\",DATUM[\"D_WGS_1984\",SPHEROID[\"WGS_1984\",6378137.0,298.257223563]],PRIMEM[\"Greenwich\",0.0],UNIT[\"Degree\",0.0174532925199433]],PROJECTION[\"Mercator_Auxiliary_Sphere\"],PARAMETER[\"False_Easting\",0.0],PARAMETER[\"False_Northing\",0.0],PARAMETER[\"Central_Meridian\",0.0],PARAMETER[\"Standard_Parallel_1\",0.0],PARAMETER[\"Auxiliary_Sphere_Type\",0.0],UNIT[\"Meter\",1.0]]", "falseM": -100000, "mUnits": 10000, "zUnits": 10000, "zTolerance": 0.001, "wkid": 3857, "xyUnits": 10000, "mTolerance": 0.001, "falseX": -20037700, "falseY": -30241100, "falseZ": -100000 }, "description": "", "syncCanReturnChanges": true, "supportsAsyncDelete": true, "supportedSpatialRelationships": [ "esriSpatialRelIntersects", "esriSpatialRelContains", "esriSpatialRelCrosses", "esriSpatialRelEnvelopeIntersects", "esriSpatialRelOverlaps", "esriSpatialRelTouches", "esriSpatialRelWithin" ], "supportsRollbackOnFailureParameter": true, "isDataReplicaTracked": false, "standardMaxRecordCountNoGeometry": 16000, "supportsTruncate": true, "indexes": [ { "name": "r1392_sde_rowid_uk", "isUnique": true, "description": "", "fields": "objectid", "isAscending": true }, { "name": "uuid_1392", "isUnique": true, "description": "", "fields": "globalid", "isAscending": true }, { "name": "a1134_ix1", "isUnique": true, "description": "", "fields": "shape", "isAscending": true } ], "supportedAppendSourceFilterFormats": "featureService", "editFieldsInfo": null, "htmlPopupType": "esriServerHTMLPopupTypeAsHTMLText", "GUIDFormat": "O", "minScale": 0, "hasAttachments": false, "queryBinsCapabilities": { "supportsFirstDayOfWeek": false, "supportedNormalizationTypes": [ "boxCox", "field", "inverse", "log", "naturalLog", "percentOfTotal", "squareRoot" ], "supportedStatisticTypes": [ "count", "sum", "min", "max", "avg", "stddev", "var", "percentile_cont", "percentile_disc" ], "supportsNormalization": true, "supportsSnapToData": true, "supportsFixedIntervalBin": true, "supportsStackBy": true, "supportsAutoIntervalBin": true, "supportsFixedBoundariesBin": true, "supportsDateBin": true, "supportsSplitBy": true, "supportsReturnFullIntervalBin": true }, "advancedQueryCapabilities": { "supportsSqlExpression": true, "supportsQueryWithResultType": true, "supportsQueryRelatedPagination": true, "supportsQueryWithCacheHint": false, "supportsQueryWithDatumTransformation": true, "supportsCurrentUserQueries": true, "supportsQueryAttachmentsWithReturnUrl": true, "fullTextSearchCapabilities": { "supportsOperator": true, "supportsSearchOperator": true }, "supportsDefaultSR": true, "supportsQueryDateBins": false, "supportsQueryWithLodSR": true, "supportsPaginationOnAggregatedQueries": true, "supportsPagination": true, "supportsMaxRecordCountFactor": true, "fullTextSearchableFields": [], "supportsStatistics": true, "supportsOrderBy": true, "supportsFullTextSearch": true, "supportsQueryWithDistance": true, "supportsLod": true, "supportsSpatialAggregationStatistics": false, "supportsCountDistinct": true, "supportsAdvancedQueryRelated": true, "supportsQueryAttachments": true, "supportsReturningQueryExtent": true, "supportsQueryAttachmentsCountOnly": true, "supportsOrderByOnlyOnLayerFields": false, "supportsOutFieldSqlExpression": true, "supportsTopFeaturesQuery": true, "supportsReturningGeometryEnvelope": false, "supportsDistinct": true, "supportsReturningGeometryCentroid": false, "supportsQueryAnalytic": true, "supportsPercentileStatistics": true, "supportsHavingClause": true }, "supportsValidateSQL": true, "enableZDefaults": true, "serviceItemId": "73c9094000594fa6a7dc6bbb7054bd8f", "allowUpdateWithoutMValues": true, "supportsCoordinatesQuantization": true, "types": [], "capabilities": "Query", "maxScale": 0, "supportsAppend": true, "supportsExceedsLimitStatistics": true, "defaultVisibility": true, "advancedQueryAnalyticCapabilities": { "supportsAsync": true, "supportsLinearRegression": true, "supportsPercentileAnalytic": false }, "hasMetadata": true, "supportedAppendFormats": "csv,excel,featureCollection,featureService,geojson,imageCollection,jsonl,pbf,shapefile", "tileMaxRecordCount": 4000, "typeIdField": "", "supportsASyncCalculate": true, "supportedQueryFormats": "JSON, geoJSON, PBF", "sqlParserVersion": "PG_11.4.0", "drawingInfo": { "renderer": { "symbol": { "outline": { "color": [ 255, 255, 255, 255 ], "width": 0.75 }, "color": [ 56, 168, 0, 255 ], "size": 6, "yoffset": 0, "xoffset": 0, "angle": 0, "style": "esriSMSCircle", "type": "esriSMS" }, "type": "simple" }, "scaleSymbols": true, "transparency": 0, "labelingInfo": null }, "geometryField": { "sqlType": "sqlTypeDistinct", "nullable": true, "editable": true, "name": "shape", "typeName": "st_point", "length": 2147483647, "type": "esriFieldTypeGeometry" }, "copyrightText": "", "zDefault": 0, "geometryType": "esriGeometryPoint", "supportsLayerOverrides": true }, { "isCoGoEnabled": false, "extent": { "ymin": 4946534.369800001, "xmin": -8409971.0539, "ymax": 4958691.269500002, "xmax": -8395755.9515, "spatialReference": { "falseM": -100000, "xyTolerance": 0.001, "mUnits": 10000, "zUnits": 10000, "latestWkid": 3857, "zTolerance": 0.001, "wkid": 102100, "xyUnits": 10000, "mTolerance": 0.001, "falseX": -20037700, "falseY": -30241100, "falseZ": -100000 } }, "isDataBranchVersioned": false, "supportsApplyEditsWithGlobalIds": true, "maxRecordCount": 2000, "infoInEstimates": [ "extent", "count" ], "type": "Feature Layer", "onlyAllowTrueCurveUpdatesByTrueCurveClients": true, "supportsAttachmentsByUploadId": true, "editingInfo": {}, "relationships": [], "supportsAttachmentsResizing": true, "cimVersion": "2.6.0", "isDataArchived": false, "id": 2, "spatialReference": { "falseM": -100000, "xyTolerance": 0.001, "mUnits": 10000, "zUnits": 10000, "latestWkid": 3857, "zTolerance": 0.001, "wkid": 102100, "xyUnits": 10000, "mTolerance": 0.001, "falseX": -20037700, "falseY": -30241100, "falseZ": -100000 }, "supportsStatistics": true, "supportedExportFormats": "sqlite,filegdb,shapefile,csv,geojson", "standardMaxRecordCount": 2000, "isDataVersioned": false, "templates": [], "hasGeometryProperties": true, "supportsAdvancedQueries": true, "parentLayer": { "name": "LCA Sanitary", "id": 0 }, "currentVersion": 11.5, "canScaleSymbols": false, "hasZ": false, "advancedEditingCapabilities": { "supportsAsyncApplyEdits": true, "supportsApplyEditsbyUploadID": true, "supportsReturnEditResults": true, "supportedSqlFormatsInCalculate": [ "standard" ], "supportedApplyEditsUploadIDFormats": "JSON,PBF" }, "objectIdField": "objectid", "supportsQuantizationEditMode": true, "hasContingentValuesDefinition": false, "name": "Sanitary Main", "allowTrueCurvesUpdates": false, "displayField": "enabled", "supportsCalculate": true, "fields": [ { "nullable": false, "defaultValue": null, "editable": false, "length": 4, "type": "esriFieldTypeOID", "modelName": "OBJECTID", "domain": null, "name": "objectid", "alias": "Object ID" }, { "modelName": "ENABLED", "nullable": true, "editable": true, "defaultValue": 1, "domain": { "splitPolicy": "esriSPTDefaultValue", "name": "EnabledDomain", "description": "", "type": "codedValue", "codedValues": [ { "code": 0, "name": "False" }, { "code": 1, "name": "True" } ], "mergePolicy": "esriMPTDefaultValue" }, "name": "enabled", "alias": "Enabled", "type": "esriFieldTypeSmallInteger" }, { "modelName": "LifecycleStatus", "nullable": true, "editable": true, "defaultValue": null, "domain": { "splitPolicy": "esriSPTDefaultValue", "name": "SAN_Status", "description": "Sanitary Lifecycle Status", "type": "codedValue", "codedValues": [ { "code": 1, "name": "Active" }, { "code": 2, "name": "Proposed" }, { "code": 3, "name": "Abandoned" } ], "mergePolicy": "esriMPTDefaultValue" }, "name": "lifecycle_status", "alias": "Lifecycle Status", "type": "esriFieldTypeInteger" }, { "modelName": "INSTALL_DATE", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "precision": 1, "name": "install_date", "length": 29, "alias": "Install Date", "type": "esriFieldTypeDate" }, { "modelName": "MAIN_TYPE", "nullable": true, "editable": true, "defaultValue": 1, "domain": { "splitPolicy": "esriSPTDuplicate", "name": "SAN_MainType_1", "description": "", "type": "codedValue", "codedValues": [ { "code": 1, "name": "Collector" }, { "code": 2, "name": "Interceptor" } ], "mergePolicy": "esriMPTDefaultValue" }, "name": "main_type", "alias": "Main Type", "type": "esriFieldTypeSmallInteger" }, { "modelName": "MAIN_SIZE", "nullable": true, "editable": true, "defaultValue": null, "domain": { "splitPolicy": "esriSPTDefaultValue", "name": "SAN_MainSize_1", "description": "", "type": "codedValue", "codedValues": [ { "code": 4, "name": "4\"" }, { "code": 6, "name": "6\"" }, { "code": 8, "name": "8\"" }, { "code": 10, "name": "10\"" }, { "code": 12, "name": "12\"" }, { "code": 15, "name": "15\"" }, { "code": 16, "name": "16\"" }, { "code": 18, "name": "18\"" }, { "code": 20, "name": "20\"" }, { "code": 21, "name": "21\"" }, { "code": 24, "name": "24\"" }, { "code": 27, "name": "27\"" }, { "code": 30, "name": "30\"" }, { "code": 33, "name": "33\"" }, { "code": 36, "name": "36\"" }, { "code": 39, "name": "39\"" }, { "code": 42, "name": "42\"" }, { "code": 48, "name": "48\"" }, { "code": 54, "name": "54\"" }, { "code": 60, "name": "60\"" }, { "code": 14, "name": "14\"" } ], "mergePolicy": "esriMPTDefaultValue" }, "name": "main_size", "alias": "Main Size", "type": "esriFieldTypeSmallInteger" }, { "modelName": "MainMaterial2", "nullable": true, "editable": true, "defaultValue": null, "domain": { "splitPolicy": "esriSPTDefaultValue", "name": "SAN_MainMaterial", "description": "Sanitary Main Material", "type": "codedValue", "codedValues": [ { "code": 0, "name": "N/A" }, { "code": 1, "name": "Cast Iron Pipe" }, { "code": 2, "name": "Ductile Iron Pipe" }, { "code": 3, "name": "Polyvinyl Chloride (Schedule 40)" }, { "code": 4, "name": "Polyvinyl Chloride (SDR 26)" }, { "code": 5, "name": "Polyvinyl Chloride (SDR 35)" }, { "code": 6, "name": "Reinforced Concrete Pipe" }, { "code": 7, "name": "Reinfored Poured in Place with Tile Floor" }, { "code": 8, "name": "Steel Encasement" }, { "code": 9, "name": "Terra Cotta" }, { "code": 10, "name": "Vitrified Clay Pipe" } ], "mergePolicy": "esriMPTDefaultValue" }, "name": "main_material", "alias": "Main Material", "type": "esriFieldTypeInteger" }, { "modelName": "OWNERSHIP", "nullable": true, "editable": true, "defaultValue": null, "domain": { "splitPolicy": "esriSPTDefaultValue", "name": "SAN_Ownership", "description": "Sanitary Ownership", "type": "codedValue", "codedValues": [ { "code": 1, "name": "City of Allentown" }, { "code": 2, "name": "City of Bethlehem" }, { "code": 3, "name": "Coplay-Whitehall" }, { "code": 4, "name": "Emmaus" }, { "code": 5, "name": "Hanover Twp" }, { "code": 6, "name": "L.C.A." }, { "code": 7, "name": "Private" }, { "code": 8, "name": "Salisbury Twp" }, { "code": 9, "name": "South Whitehall Twp" }, { "code": 10, "name": "Upper Macungie" }, { "code": 11, "name": "Whitehall Twp" } ], "mergePolicy": "esriMPTDefaultValue" }, "name": "ownership", "alias": "Ownership", "type": "esriFieldTypeInteger" }, { "modelName": "UPSTREAM_MH", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "upstream_mh", "length": 12, "alias": "Upstream Manhole", "type": "esriFieldTypeString" }, { "modelName": "DOWNSTREAM_MH", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "downstream_mh", "length": 12, "alias": "Downstream Manhole", "type": "esriFieldTypeString" }, { "modelName": "UPSTREAM_INVERT", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "upstream_invert", "alias": "Upstream Invert", "type": "esriFieldTypeDouble" }, { "modelName": "DOWNSTREAM_INVERT", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "downstream_invert", "alias": "Downstream Invert", "type": "esriFieldTypeDouble" }, { "modelName": "SLOPE", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "slope", "alias": "Slope", "type": "esriFieldTypeDouble" }, { "modelName": "TRUNK_SECTION", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "trunk_section", "length": 6, "alias": "Trunk Section", "type": "esriFieldTypeString" }, { "modelName": "LATERAL_ASBUILT", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "lateral_asbuilt", "length": 12, "alias": "Lateral Asbuilt", "type": "esriFieldTypeString" }, { "modelName": "CONSTRUCTION_ASBUILT", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "construction_asbuilt", "length": 12, "alias": "Construction Asbuilt", "type": "esriFieldTypeString" }, { "modelName": "DIGITAL_IMAGE", "nullable": true, "editable": true, "defaultValue": "\"\\\\Water1\\Software\\Digital_Images\\San_const\\\"", "domain": null, "name": "digital_image", "length": 100, "alias": "Digital Image", "type": "esriFieldTypeString" }, { "modelName": "IN_CASING", "nullable": true, "editable": true, "defaultValue": null, "domain": { "splitPolicy": "esriSPTDefaultValue", "name": "G_YesNoIndicator", "description": "", "type": "codedValue", "codedValues": [ { "code": 1, "name": "Yes" }, { "code": 0, "name": "No" } ], "mergePolicy": "esriMPTDefaultValue" }, "name": "in_casing", "alias": "In Casing", "type": "esriFieldTypeSmallInteger" }, { "modelName": "EXTERIOR_COATED", "nullable": true, "editable": true, "defaultValue": null, "domain": { "splitPolicy": "esriSPTDefaultValue", "name": "G_YesNoIndicator", "description": "", "type": "codedValue", "codedValues": [ { "code": 1, "name": "Yes" }, { "code": 0, "name": "No" } ], "mergePolicy": "esriMPTDefaultValue" }, "name": "exterior_coated", "alias": "Exterior Coated", "type": "esriFieldTypeSmallInteger" }, { "modelName": "LINING_TYPE", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "lining_type", "length": 80, "alias": "Lining Type", "type": "esriFieldTypeString" }, { "modelName": "PIPEID", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "pipeid", "alias": "Pipe ID", "type": "esriFieldTypeInteger" }, { "modelName": "LucityLinkID", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "lucity_id", "alias": "Lucity Link ID", "type": "esriFieldTypeInteger" }, { "modelName": "DIGITAL_VIDEO", "nullable": true, "editable": true, "defaultValue": "\"\\\\WATER4\\E-BUSINESS\\PipeTech\\Videos", "domain": null, "name": "digital_video", "length": 100, "alias": "Digital Video", "type": "esriFieldTypeString" }, { "modelName": "NOTES", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "notes", "length": 255, "alias": "Notes", "type": "esriFieldTypeString" }, { "modelName": "CREATEDBY", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "createdby", "length": 30, "alias": "Created by", "type": "esriFieldTypeString" }, { "modelName": "CREATEDON", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "precision": 1, "name": "createdon", "length": 29, "alias": "Created On", "type": "esriFieldTypeDate" }, { "modelName": "MODIFIEDBY", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "modifiedby", "length": 50, "alias": "Modified By", "type": "esriFieldTypeString" }, { "modelName": "MODIFIEDON", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "precision": 1, "name": "modifiedon", "length": 29, "alias": "Modified On", "type": "esriFieldTypeDate" }, { "modelName": "INFRASTRUCTURE_ID", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "infrastructure_id", "length": 5, "alias": "Infrastructure ID", "type": "esriFieldTypeString" }, { "modelName": "INFRASTRUCTURE_TYPE", "nullable": true, "editable": true, "defaultValue": null, "domain": { "splitPolicy": "esriSPTDefaultValue", "name": "SAN_InfrastructureType_1", "description": "Sanitary Infrastructure Types", "type": "codedValue", "codedValues": [ { "code": "40", "name": "San Main Segment" }, { "code": "41", "name": "San Manhole" }, { "code": "42", "name": "San Fitting" }, { "code": "43", "name": "San Lateral" }, { "code": "44", "name": "San Wye" }, { "code": "45", "name": "San Stub" }, { "code": "46", "name": "San Junction Box" }, { "code": "47", "name": "San Clean Out" }, { "code": "48", "name": "San Meter" } ], "mergePolicy": "esriMPTDefaultValue" }, "name": "infrastructure_type", "length": 2, "alias": "Infrastructure Type", "type": "esriFieldTypeString" }, { "modelName": "INFRASTRUCTURE_CLASS", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "infrastructure_class", "length": 1, "alias": "Infrastructure Class", "type": "esriFieldTypeString" }, { "modelName": "CONCATENATED_ID", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "concatenated_id", "length": 8, "alias": "Concatenated ID", "type": "esriFieldTypeString" }, { "modelName": "Lucity_Length", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "lucity_length", "alias": "Lucity_Length", "type": "esriFieldTypeDouble" }, { "modelName": "i", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "i", "alias": "i", "type": "esriFieldTypeSmallInteger" }, { "modelName": "CITYWORKS_ID", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "cityworks_id", "length": 15, "alias": "CITYWORKS_ID", "type": "esriFieldTypeString" }, { "modelName": "District", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "district", "length": 65, "alias": "District", "type": "esriFieldTypeString" }, { "nullable": false, "editable": false, "defaultValue": null, "length": 38, "type": "esriFieldTypeGlobalID", "modelName": "GlobalID", "domain": null, "name": "globalid", "alias": "GlobalID" }, { "virtual": true, "nullable": true, "editable": false, "defaultValue": null, "domain": null, "name": "SHAPE__Length", "alias": "SHAPE__Length", "type": "esriFieldTypeDouble" } ], "maxRecordCountFactor": 1, "dateFieldsTimeReference": { "timeZoneIANA": "Etc/UTC", "respectsDaylightSaving": false, "timeZone": "UTC" }, "supportsFieldDescriptionProperty": true, "hasM": false, "allowGeometryUpdates": true, "useStandardizedQueries": true, "globalIdField": "globalid", "sourceSpatialReference": { "wkt": "PROJCS[\"WGS_1984_Web_Mercator_Auxiliary_Sphere\",GEOGCS[\"GCS_WGS_1984\",DATUM[\"D_WGS_1984\",SPHEROID[\"WGS_1984\",6378137.0,298.257223563]],PRIMEM[\"Greenwich\",0.0],UNIT[\"Degree\",0.0174532925199433]],PROJECTION[\"Mercator_Auxiliary_Sphere\"],PARAMETER[\"False_Easting\",0.0],PARAMETER[\"False_Northing\",0.0],PARAMETER[\"Central_Meridian\",0.0],PARAMETER[\"Standard_Parallel_1\",0.0],PARAMETER[\"Auxiliary_Sphere_Type\",0.0],UNIT[\"Meter\",1.0]]", "falseM": -100000, "mUnits": 10000, "zUnits": 10000, "zTolerance": 0.001, "wkid": 3857, "xyUnits": 10000, "mTolerance": 0.001, "falseX": -20037700, "falseY": -30241100, "falseZ": -100000 }, "description": "", "syncCanReturnChanges": true, "supportsAsyncDelete": true, "supportedSpatialRelationships": [ "esriSpatialRelIntersects", "esriSpatialRelContains", "esriSpatialRelCrosses", "esriSpatialRelEnvelopeIntersects", "esriSpatialRelOverlaps", "esriSpatialRelTouches", "esriSpatialRelWithin" ], "geometryProperties": { "shapeLengthFieldName": "SHAPE__Length", "units": "esriMeters" }, "supportsRollbackOnFailureParameter": true, "isDataReplicaTracked": false, "standardMaxRecordCountNoGeometry": 16000, "supportsTruncate": true, "indexes": [ { "name": "r1391_sde_rowid_uk", "isUnique": true, "description": "", "fields": "objectid", "isAscending": true }, { "name": "uuid_1391", "isUnique": true, "description": "", "fields": "globalid", "isAscending": true }, { "name": "a1133_ix1", "isUnique": true, "description": "", "fields": "shape", "isAscending": true } ], "supportedAppendSourceFilterFormats": "featureService", "editFieldsInfo": null, "htmlPopupType": "esriServerHTMLPopupTypeAsHTMLText", "GUIDFormat": "O", "minScale": 0, "hasAttachments": false, "queryBinsCapabilities": { "supportsFirstDayOfWeek": false, "supportedNormalizationTypes": [ "boxCox", "field", "inverse", "log", "naturalLog", "percentOfTotal", "squareRoot" ], "supportedStatisticTypes": [ "count", "sum", "min", "max", "avg", "stddev", "var", "percentile_cont", "percentile_disc" ], "supportsNormalization": true, "supportsSnapToData": true, "supportsFixedIntervalBin": true, "supportsStackBy": true, "supportsAutoIntervalBin": true, "supportsFixedBoundariesBin": true, "supportsDateBin": true, "supportsSplitBy": true, "supportsReturnFullIntervalBin": true }, "advancedQueryCapabilities": { "supportsSqlExpression": true, "supportsQueryWithResultType": true, "supportsQueryRelatedPagination": true, "supportsQueryWithCacheHint": false, "supportsQueryWithDatumTransformation": true, "supportsCurrentUserQueries": true, "supportsQueryAttachmentsWithReturnUrl": true, "fullTextSearchCapabilities": { "supportsOperator": true, "supportsSearchOperator": true }, "supportsDefaultSR": true, "supportsQueryDateBins": false, "supportsQueryWithLodSR": true, "supportsPaginationOnAggregatedQueries": true, "supportsPagination": true, "supportsMaxRecordCountFactor": true, "fullTextSearchableFields": [], "supportsStatistics": true, "supportsOrderBy": true, "supportsReturningGeometryProperties": true, "supportsFullTextSearch": true, "supportsQueryWithDistance": true, "supportsLod": true, "supportsSpatialAggregationStatistics": false, "supportsCountDistinct": true, "supportsAdvancedQueryRelated": true, "supportsQueryAttachments": true, "supportsReturningQueryExtent": true, "supportsQueryAttachmentsCountOnly": true, "supportsOrderByOnlyOnLayerFields": false, "supportsOutFieldSqlExpression": true, "supportsTopFeaturesQuery": true, "supportsReturningGeometryEnvelope": true, "supportsDistinct": true, "supportsReturningGeometryCentroid": false, "supportsQueryAnalytic": true, "supportsPercentileStatistics": true, "supportsHavingClause": true }, "supportsValidateSQL": true, "enableZDefaults": true, "serviceItemId": "73c9094000594fa6a7dc6bbb7054bd8f", "allowUpdateWithoutMValues": true, "supportsCoordinatesQuantization": true, "types": [ { "templates": [ { "name": "Collector", "description": "", "drawingTool": "esriFeatureEditToolLine", "prototype": { "attributes": { "main_material": null, "notes": null, "main_type": 1, "infrastructure_type": null, "infrastructure_class": null, "enabled": 1, "main_size": 8, "digital_image": "\"\\\\Water1\\Software\\Digital_Images\\San_const\\\"", "exterior_coated": 1, "downstream_invert": null, "pipeid": null, "createdby": null, "upstream_invert": null, "lifecycle_status": null, "downstream_mh": null, "install_date": null, "lucity_id": null, "cityworks_id": null, "digital_video": "\"\\\\WATER4\\E-BUSINESS\\PipeTech\\Videos", "construction_asbuilt": null, "lucity_length": null, "upstream_mh": null, "i": null, "concatenated_id": null, "infrastructure_id": null, "slope": null, "createdon": null, "trunk_section": null, "modifiedon": null, "ownership": null, "district": null, "lining_type": null, "in_casing": 1, "lateral_asbuilt": null, "modifiedby": null } } } ], "name": "Collector", "domains": { "main_material": {"type": "inherited"}, "exterior_coated": {"type": "inherited"}, "ownership": {"type": "inherited"}, "in_casing": {"type": "inherited"}, "lifecycle_status": {"type": "inherited"}, "infrastructure_type": {"type": "inherited"}, "enabled": {"type": "inherited"}, "main_size": {"type": "inherited"} }, "id": 1 }, { "templates": [ { "name": "Interceptor", "description": "", "drawingTool": "esriFeatureEditToolLine", "prototype": { "attributes": { "main_material": null, "notes": null, "main_type": 2, "infrastructure_type": null, "infrastructure_class": null, "enabled": 1, "main_size": 8, "digital_image": "\"\\\\Water1\\Software\\Digital_Images\\San_const\\\"", "exterior_coated": 1, "downstream_invert": null, "pipeid": null, "createdby": null, "upstream_invert": null, "lifecycle_status": null, "downstream_mh": null, "install_date": null, "lucity_id": null, "cityworks_id": null, "digital_video": "\"\\\\WATER4\\E-BUSINESS\\PipeTech\\Videos", "construction_asbuilt": null, "lucity_length": null, "upstream_mh": null, "i": null, "concatenated_id": null, "infrastructure_id": null, "slope": null, "createdon": null, "trunk_section": null, "modifiedon": null, "ownership": null, "district": null, "lining_type": null, "in_casing": 1, "lateral_asbuilt": null, "modifiedby": null } } } ], "name": "Interceptor", "domains": { "main_material": {"type": "inherited"}, "exterior_coated": {"type": "inherited"}, "ownership": {"type": "inherited"}, "in_casing": {"type": "inherited"}, "lifecycle_status": {"type": "inherited"}, "infrastructure_type": {"type": "inherited"}, "enabled": {"type": "inherited"}, "main_size": {"type": "inherited"} }, "id": 2 } ], "capabilities": "Query", "maxScale": 0, "supportsAppend": true, "supportsExceedsLimitStatistics": true, "defaultVisibility": true, "advancedQueryAnalyticCapabilities": { "supportsAsync": true, "supportsLinearRegression": true, "supportsPercentileAnalytic": false }, "hasMetadata": true, "supportedAppendFormats": "csv,excel,featureCollection,featureService,geojson,imageCollection,jsonl,pbf,shapefile", "tileMaxRecordCount": 2000, "typeIdField": "main_type", "supportsASyncCalculate": true, "supportedQueryFormats": "JSON, geoJSON, PBF", "sqlParserVersion": "PG_11.4.0", "drawingInfo": { "renderer": { "field1": "main_type", "authoringInfo": { "colorRamp": { "colorRamps": [ { "toColor": [ 244, 184, 252, 255 ], "fromColor": [ 244, 184, 252, 255 ], "type": "algorithmic", "algorithm": "esriCIELabAlgorithm" }, { "toColor": [ 182, 252, 185, 255 ], "fromColor": [ 182, 252, 185, 255 ], "type": "algorithmic", "algorithm": "esriCIELabAlgorithm" }, { "toColor": [ 252, 217, 202, 255 ], "fromColor": [ 252, 217, 202, 255 ], "type": "algorithmic", "algorithm": "esriCIELabAlgorithm" }, { "toColor": [ 184, 223, 252, 255 ], "fromColor": [ 184, 223, 252, 255 ], "type": "algorithmic", "algorithm": "esriCIELabAlgorithm" }, { "toColor": [ 250, 252, 179, 255 ], "fromColor": [ 250, 252, 179, 255 ], "type": "algorithmic", "algorithm": "esriCIELabAlgorithm" }, { "toColor": [ 189, 252, 241, 255 ], "fromColor": [ 189, 252, 241, 255 ], "type": "algorithmic", "algorithm": "esriCIELabAlgorithm" }, { "toColor": [ 182, 185, 252, 255 ], "fromColor": [ 182, 185, 252, 255 ], "type": "algorithmic", "algorithm": "esriCIELabAlgorithm" }, { "toColor": [ 252, 179, 207, 255 ], "fromColor": [ 252, 179, 207, 255 ], "type": "algorithmic", "algorithm": "esriCIELabAlgorithm" }, { "toColor": [ 231, 210, 252, 255 ], "fromColor": [ 231, 210, 252, 255 ], "type": "algorithmic", "algorithm": "esriCIELabAlgorithm" }, { "toColor": [ 218, 252, 212, 255 ], "fromColor": [ 218, 252, 212, 255 ], "type": "algorithmic", "algorithm": "esriCIELabAlgorithm" }, { "toColor": [ 252, 246, 210, 255 ], "fromColor": [ 252, 246, 210, 255 ], "type": "algorithmic", "algorithm": "esriCIELabAlgorithm" }, { "toColor": [ 252, 197, 201, 255 ], "fromColor": [ 252, 197, 201, 255 ], "type": "algorithmic", "algorithm": "esriCIELabAlgorithm" }, { "toColor": [ 252, 207, 234, 255 ], "fromColor": [ 252, 207, 234, 255 ], "type": "algorithmic", "algorithm": "esriCIELabAlgorithm" } ], "type": "multipart" } }, "uniqueValueInfos": [ { "symbol": { "color": [ 56, 168, 0, 255 ], "width": 1, "style": "esriSLSSolid", "type": "esriSLS" }, "label": "Collector", "value": "1" }, { "symbol": { "color": [ 38, 115, 0, 255 ], "width": 2, "style": "esriSLSSolid", "type": "esriSLS" }, "label": "Interceptor", "value": "2" } ], "type": "uniqueValue", "fieldDelimiter": "," }, "scaleSymbols": true, "transparency": 0, "labelingInfo": null }, "geometryField": { "sqlType": "sqlTypeOther", "nullable": true, "editable": true, "name": "shape", "typeName": "st_geometry", "length": 2147483647, "type": "esriFieldTypeGeometry" }, "copyrightText": "", "zDefault": 0, "geometryType": "esriGeometryPolyline", "supportsLayerOverrides": true }, { "isCoGoEnabled": false, "extent": { "ymin": 4946704.063600004, "xmin": -8409844.2053, "ymax": 4958703.044399999, "xmax": -8395813.0661, "spatialReference": { "falseM": -100000, "xyTolerance": 0.001, "mUnits": 10000, "zUnits": 10000, "latestWkid": 3857, "zTolerance": 0.001, "wkid": 102100, "xyUnits": 10000, "mTolerance": 0.001, "falseX": -20037700, "falseY": -30241100, "falseZ": -100000 } }, "isDataBranchVersioned": false, "supportsApplyEditsWithGlobalIds": true, "maxRecordCount": 2000, "infoInEstimates": [ "extent", "count" ], "type": "Feature Layer", "onlyAllowTrueCurveUpdatesByTrueCurveClients": true, "supportsAttachmentsByUploadId": true, "editingInfo": {}, "relationships": [], "supportsAttachmentsResizing": true, "cimVersion": "2.6.0", "isDataArchived": false, "id": 3, "spatialReference": { "falseM": -100000, "xyTolerance": 0.001, "mUnits": 10000, "zUnits": 10000, "latestWkid": 3857, "zTolerance": 0.001, "wkid": 102100, "xyUnits": 10000, "mTolerance": 0.001, "falseX": -20037700, "falseY": -30241100, "falseZ": -100000 }, "supportsStatistics": true, "supportedExportFormats": "sqlite,filegdb,shapefile,csv,geojson", "standardMaxRecordCount": 2000, "isDataVersioned": false, "templates": [ { "name": "Sanintary Lateral", "description": "", "drawingTool": "esriFeatureEditToolLine", "prototype": { "attributes": { "notes": null, "cad_map_number": null, "elevtopcurb": null, "infrastructure_type": null, "infrastructure_class": "1", "lateral_installer_name": null, "enabled": 1, "manufacturer": null, "createdby": null, "lateral_size": null, "lifecycle_status": null, "model": null, "inst_date": null, "lateral_type": null, "int_loc_id": null, "lateral_length": null, "cityworks_id": null, "lateral_connection_type": null, "lateral_slope": null, "lateral_roughness_coefficient": null, "concatenated_id": null, "infrastructure_id": null, "location_description": null, "as_built_number": null, "createdon": null, "modifiedon": null, "ownership": null, "ward_number": null, "elevtoppipe": null, "modifiedby": null, "wardacctno": null } } } ], "hasGeometryProperties": true, "supportsAdvancedQueries": true, "parentLayer": { "name": "LCA Sanitary", "id": 0 }, "currentVersion": 11.5, "canScaleSymbols": false, "hasZ": false, "advancedEditingCapabilities": { "supportsAsyncApplyEdits": true, "supportsApplyEditsbyUploadID": true, "supportsReturnEditResults": true, "supportedSqlFormatsInCalculate": [ "standard" ], "supportedApplyEditsUploadIDFormats": "JSON,PBF" }, "objectIdField": "objectid", "supportsQuantizationEditMode": true, "hasContingentValuesDefinition": false, "name": "Sanintary Lateral", "allowTrueCurvesUpdates": false, "displayField": "lateral_installer_name", "supportsCalculate": true, "fields": [ { "nullable": false, "defaultValue": null, "editable": false, "length": 4, "type": "esriFieldTypeOID", "modelName": "OBJECTID", "domain": null, "name": "objectid", "alias": "Object ID" }, { "modelName": "ENABLED", "nullable": true, "editable": true, "defaultValue": 1, "domain": { "splitPolicy": "esriSPTDefaultValue", "name": "EnabledDomain", "description": "", "type": "codedValue", "codedValues": [ { "code": 0, "name": "False" }, { "code": 1, "name": "True" } ], "mergePolicy": "esriMPTDefaultValue" }, "name": "enabled", "alias": "Enabled", "type": "esriFieldTypeSmallInteger" }, { "modelName": "LIFECYCLE_STATUS", "nullable": true, "editable": true, "defaultValue": null, "domain": { "splitPolicy": "esriSPTDefaultValue", "name": "SAN_Status", "description": "Sanitary Lifecycle Status", "type": "codedValue", "codedValues": [ { "code": 1, "name": "Active" }, { "code": 2, "name": "Proposed" }, { "code": 3, "name": "Abandoned" } ], "mergePolicy": "esriMPTDefaultValue" }, "name": "lifecycle_status", "alias": "Lifecycle Status", "type": "esriFieldTypeInteger" }, { "modelName": "AS_BUILT_NUMBER", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "as_built_number", "length": 50, "alias": "Asbuilt Number", "type": "esriFieldTypeString" }, { "modelName": "INST_DATE", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "precision": 1, "name": "inst_date", "length": 29, "alias": "Install Date", "type": "esriFieldTypeDate" }, { "modelName": "MANUFACTURER", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "manufacturer", "length": 30, "alias": "Manufacturer", "type": "esriFieldTypeString" }, { "modelName": "OWNERSHIP", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "ownership", "length": 255, "alias": "Ownership", "type": "esriFieldTypeString" }, { "modelName": "NOTES", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "notes", "length": 255, "alias": "Notes", "type": "esriFieldTypeString" }, { "modelName": "LOCATION_DESCRIPTION", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "location_description", "length": 50, "alias": "Location Description", "type": "esriFieldTypeString" }, { "modelName": "WARD_NUMBER", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "ward_number", "alias": "Ward Number", "type": "esriFieldTypeDouble" }, { "modelName": "CAD_MAP_NUMBER", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "cad_map_number", "length": 4, "alias": "Cad Map Number", "type": "esriFieldTypeString" }, { "modelName": "WARDACCTNO", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "wardacctno", "length": 9, "alias": "Ward Account Number", "type": "esriFieldTypeString" }, { "modelName": "INFRASTRUCTURE_ID", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "infrastructure_id", "length": 5, "alias": "Infrastructure ID", "type": "esriFieldTypeString" }, { "modelName": "INFRASTRUCTURE_TYPE", "nullable": true, "editable": true, "defaultValue": null, "domain": { "splitPolicy": "esriSPTDefaultValue", "name": "SAN_InfrastructureType_1", "description": "Sanitary Infrastructure Types", "type": "codedValue", "codedValues": [ { "code": "40", "name": "San Main Segment" }, { "code": "41", "name": "San Manhole" }, { "code": "42", "name": "San Fitting" }, { "code": "43", "name": "San Lateral" }, { "code": "44", "name": "San Wye" }, { "code": "45", "name": "San Stub" }, { "code": "46", "name": "San Junction Box" }, { "code": "47", "name": "San Clean Out" }, { "code": "48", "name": "San Meter" } ], "mergePolicy": "esriMPTDefaultValue" }, "name": "infrastructure_type", "length": 2, "alias": "Infrastructure Type", "type": "esriFieldTypeString" }, { "modelName": "INFRASTRUCTURE_CLASS", "nullable": true, "editable": true, "defaultValue": "1", "domain": null, "name": "infrastructure_class", "length": 1, "alias": "Infrastructure Class", "type": "esriFieldTypeString" }, { "modelName": "CONCATENATED_ID", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "concatenated_id", "length": 8, "alias": "Concatenated ID", "type": "esriFieldTypeString" }, { "modelName": "MODEL", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "model", "length": 30, "alias": "Model", "type": "esriFieldTypeString" }, { "modelName": "INT_LOC_ID", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "int_loc_id", "alias": "Int Loc ID", "type": "esriFieldTypeDouble" }, { "modelName": "LATERAL_CONNECTION_TYPE", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "lateral_connection_type", "length": 255, "alias": "Lateral Connection Type", "type": "esriFieldTypeString" }, { "modelName": "LATERAL_TYPE", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "lateral_type", "length": 255, "alias": "Lateral Type", "type": "esriFieldTypeString" }, { "modelName": "LATERAL_INSTALLER_NAME", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "lateral_installer_name", "length": 255, "alias": "Lateral Installer Name", "type": "esriFieldTypeString" }, { "modelName": "LATERAL_LENGTH", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "lateral_length", "alias": "Lateral Length", "type": "esriFieldTypeDouble" }, { "modelName": "LATERAL_ROUGHNESS_COEFFICIENT", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "lateral_roughness_coefficient", "alias": "Lateral Roughness Coefficient", "type": "esriFieldTypeDouble" }, { "modelName": "LATERAL_SLOPE", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "lateral_slope", "alias": "Lateral Slope", "type": "esriFieldTypeDouble" }, { "modelName": "LATERAL_SIZE", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "lateral_size", "alias": "Lateral Size", "type": "esriFieldTypeDouble" }, { "modelName": "ELEVTOPCURB", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "elevtopcurb", "alias": "Curb Elevation", "type": "esriFieldTypeDouble" }, { "modelName": "ELEVTOPPIPE", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "elevtoppipe", "alias": "Pipe Elevation", "type": "esriFieldTypeDouble" }, { "modelName": "CREATEDBY", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "createdby", "length": 30, "alias": "Created By", "type": "esriFieldTypeString" }, { "modelName": "CREATEDON", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "precision": 1, "name": "createdon", "length": 29, "alias": "Created On", "type": "esriFieldTypeDate" }, { "modelName": "MODIFIEDBY", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "modifiedby", "length": 30, "alias": "Modified By", "type": "esriFieldTypeString" }, { "modelName": "MODIFIEDON", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "precision": 1, "name": "modifiedon", "length": 29, "alias": "Modified On", "type": "esriFieldTypeDate" }, { "modelName": "CITYWORKS_ID", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "cityworks_id", "length": 15, "alias": "CITYWORKS_ID", "type": "esriFieldTypeString" }, { "nullable": false, "editable": false, "defaultValue": null, "length": 38, "type": "esriFieldTypeGlobalID", "modelName": "GlobalID", "domain": null, "name": "globalid", "alias": "GlobalID" }, { "virtual": true, "nullable": true, "editable": false, "defaultValue": null, "domain": null, "name": "SHAPE__Length", "alias": "SHAPE__Length", "type": "esriFieldTypeDouble" } ], "maxRecordCountFactor": 1, "dateFieldsTimeReference": { "timeZoneIANA": "Etc/UTC", "respectsDaylightSaving": false, "timeZone": "UTC" }, "supportsFieldDescriptionProperty": true, "hasM": false, "allowGeometryUpdates": true, "useStandardizedQueries": true, "globalIdField": "globalid", "sourceSpatialReference": { "wkt": "PROJCS[\"WGS_1984_Web_Mercator_Auxiliary_Sphere\",GEOGCS[\"GCS_WGS_1984\",DATUM[\"D_WGS_1984\",SPHEROID[\"WGS_1984\",6378137.0,298.257223563]],PRIMEM[\"Greenwich\",0.0],UNIT[\"Degree\",0.0174532925199433]],PROJECTION[\"Mercator_Auxiliary_Sphere\"],PARAMETER[\"False_Easting\",0.0],PARAMETER[\"False_Northing\",0.0],PARAMETER[\"Central_Meridian\",0.0],PARAMETER[\"Standard_Parallel_1\",0.0],PARAMETER[\"Auxiliary_Sphere_Type\",0.0],UNIT[\"Meter\",1.0]]", "falseM": -100000, "mUnits": 10000, "zUnits": 10000, "zTolerance": 0.001, "wkid": 3857, "xyUnits": 10000, "mTolerance": 0.001, "falseX": -20037700, "falseY": -30241100, "falseZ": -100000 }, "description": "", "syncCanReturnChanges": true, "supportsAsyncDelete": true, "supportedSpatialRelationships": [ "esriSpatialRelIntersects", "esriSpatialRelContains", "esriSpatialRelCrosses", "esriSpatialRelEnvelopeIntersects", "esriSpatialRelOverlaps", "esriSpatialRelTouches", "esriSpatialRelWithin" ], "geometryProperties": { "shapeLengthFieldName": "SHAPE__Length", "units": "esriMeters" }, "supportsRollbackOnFailureParameter": true, "isDataReplicaTracked": false, "standardMaxRecordCountNoGeometry": 16000, "supportsTruncate": true, "indexes": [ { "name": "r1393_sde_rowid_uk", "isUnique": true, "description": "", "fields": "objectid", "isAscending": true }, { "name": "uuid_1393", "isUnique": true, "description": "", "fields": "globalid", "isAscending": true }, { "name": "a1135_ix1", "isUnique": true, "description": "", "fields": "shape", "isAscending": true } ], "supportedAppendSourceFilterFormats": "featureService", "editFieldsInfo": null, "htmlPopupType": "esriServerHTMLPopupTypeAsHTMLText", "GUIDFormat": "O", "minScale": 0, "hasAttachments": false, "queryBinsCapabilities": { "supportsFirstDayOfWeek": false, "supportedNormalizationTypes": [ "boxCox", "field", "inverse", "log", "naturalLog", "percentOfTotal", "squareRoot" ], "supportedStatisticTypes": [ "count", "sum", "min", "max", "avg", "stddev", "var", "percentile_cont", "percentile_disc" ], "supportsNormalization": true, "supportsSnapToData": true, "supportsFixedIntervalBin": true, "supportsStackBy": true, "supportsAutoIntervalBin": true, "supportsFixedBoundariesBin": true, "supportsDateBin": true, "supportsSplitBy": true, "supportsReturnFullIntervalBin": true }, "advancedQueryCapabilities": { "supportsSqlExpression": true, "supportsQueryWithResultType": true, "supportsQueryRelatedPagination": true, "supportsQueryWithCacheHint": false, "supportsQueryWithDatumTransformation": true, "supportsCurrentUserQueries": true, "supportsQueryAttachmentsWithReturnUrl": true, "fullTextSearchCapabilities": { "supportsOperator": true, "supportsSearchOperator": true }, "supportsDefaultSR": true, "supportsQueryDateBins": false, "supportsQueryWithLodSR": true, "supportsPaginationOnAggregatedQueries": true, "supportsPagination": true, "supportsMaxRecordCountFactor": true, "fullTextSearchableFields": [], "supportsStatistics": true, "supportsOrderBy": true, "supportsReturningGeometryProperties": true, "supportsFullTextSearch": true, "supportsQueryWithDistance": true, "supportsLod": true, "supportsSpatialAggregationStatistics": false, "supportsCountDistinct": true, "supportsAdvancedQueryRelated": true, "supportsQueryAttachments": true, "supportsReturningQueryExtent": true, "supportsQueryAttachmentsCountOnly": true, "supportsOrderByOnlyOnLayerFields": false, "supportsOutFieldSqlExpression": true, "supportsTopFeaturesQuery": true, "supportsReturningGeometryEnvelope": true, "supportsDistinct": true, "supportsReturningGeometryCentroid": false, "supportsQueryAnalytic": true, "supportsPercentileStatistics": true, "supportsHavingClause": true }, "supportsValidateSQL": true, "enableZDefaults": true, "serviceItemId": "73c9094000594fa6a7dc6bbb7054bd8f", "allowUpdateWithoutMValues": true, "supportsCoordinatesQuantization": true, "types": [], "capabilities": "Query", "maxScale": 0, "supportsAppend": true, "supportsExceedsLimitStatistics": true, "defaultVisibility": true, "advancedQueryAnalyticCapabilities": { "supportsAsync": true, "supportsLinearRegression": true, "supportsPercentileAnalytic": false }, "hasMetadata": true, "supportedAppendFormats": "csv,excel,featureCollection,featureService,geojson,imageCollection,jsonl,pbf,shapefile", "tileMaxRecordCount": 2000, "typeIdField": "", "supportsASyncCalculate": true, "supportedQueryFormats": "JSON, geoJSON, PBF", "sqlParserVersion": "PG_11.4.0", "drawingInfo": { "renderer": { "symbol": { "color": [ 76, 230, 0, 255 ], "width": 1, "style": "esriSLSSolid", "type": "esriSLS" }, "type": "simple" }, "scaleSymbols": true, "transparency": 0, "labelingInfo": null }, "geometryField": { "sqlType": "sqlTypeOther", "nullable": true, "editable": true, "name": "shape", "typeName": "st_geometry", "length": 2147483647, "type": "esriFieldTypeGeometry" }, "copyrightText": "", "zDefault": 0, "geometryType": "esriGeometryPolyline", "supportsLayerOverrides": true } ] }