{ "tables": [ { "isCoGoEnabled": false, "isDataBranchVersioned": false, "supportedContingentValuesFormats": "JSON, PBF", "supportsApplyEditsWithGlobalIds": true, "maxRecordCount": 2000, "infoInEstimates": [ "extent", "count" ], "type": "Table", "syncEnabled": true, "supportsAttachmentsByUploadId": true, "relationships": [ { "keyField": "facilityid", "role": "esriRelRoleDestination", "composite": false, "name": "swDrainPipe", "relatedTableId": 3, "id": 3, "cardinality": "esriRelCardinalityOneToMany" }, { "keyField": "facilityid", "role": "esriRelRoleDestination", "composite": false, "name": "swVirtualReach", "relatedTableId": 6, "id": 4, "cardinality": "esriRelCardinalityOneToMany" } ], "supportsAttachmentsResizing": true, "cimVersion": "2.6.0", "isDataArchived": false, "id": 8, "supportsStatistics": true, "supportedExportFormats": "sqlite,filegdb,shapefile,csv,geojson", "standardMaxRecordCount": 16000, "isDataVersioned": false, "templates": [ { "name": "swConveyanceCondition", "description": "", "drawingTool": "esriFeatureEditToolNone", "prototype": { "attributes": { "maintcomments": null, "manyid": null, "date_of_assessment": null, "cond_struct_rating": null, "facilityid": null, "cond_maint_rating": null, "cond_access_rating": null, "structcomments": null, "accesscomments": null } } } ], "supportsAdvancedQueries": true, "currentVersion": 11.2, "advancedEditingCapabilities": { "supportsAsyncApplyEdits": true, "supportsApplyEditsbyUploadID": true, "supportsReturnEditResults": true, "supportedSqlFormatsInCalculate": [ "standard" ], "supportedApplyEditsUploadIDFormats": "JSON" }, "objectIdField": "objectid", "supportsQuantizationEditMode": true, "hasContingentValuesDefinition": true, "name": "swConveyanceCondition", "displayField": "facilityid", "supportsCalculate": true, "fields": [ { "nullable": false, "defaultValue": null, "editable": false, "length": 4, "type": "esriFieldTypeOID", "modelName": "System-maintained ObjectID", "domain": null, "name": "objectid", "alias": "OBJECTID" }, { "modelName": "FACILITYID", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "facilityid", "length": 25, "alias": "Facility ID", "type": "esriFieldTypeString" }, { "modelName": "MANYID", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "manyid", "alias": "Many ID", "type": "esriFieldTypeInteger" }, { "modelName": "DATE_OF_ASSESSMENT", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "precision": 1, "name": "date_of_assessment", "length": 29, "alias": "Date Of Assessment", "type": "esriFieldTypeDate" }, { "modelName": "COND_ACCESS_RATING", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "cond_access_rating", "length": 30, "alias": "Accessibility Rating", "type": "esriFieldTypeString" }, { "modelName": "ACCESSCOMMENTS", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "accesscomments", "length": 254, "alias": "Accessibility Comments", "type": "esriFieldTypeString" }, { "modelName": "COND_STRUCT_RATING", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "cond_struct_rating", "length": 30, "alias": "Structural Rating", "type": "esriFieldTypeString" }, { "modelName": "STRUCTCOMMENTS", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "structcomments", "length": 254, "alias": "Structural Condition Comments", "type": "esriFieldTypeString" }, { "modelName": "COND_MAINT_RATING", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "cond_maint_rating", "length": 30, "alias": "Maintenance Rating", "type": "esriFieldTypeString" }, { "modelName": "MAINTCOMMENTS", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "maintcomments", "length": 254, "alias": "Maintenance Condition Comments", "type": "esriFieldTypeString" }, { "modelName": "creationdate", "nullable": true, "editable": false, "defaultValue": null, "domain": null, "precision": 1, "name": "creationdate", "length": 29, "alias": "CreationDate", "type": "esriFieldTypeDate" }, { "modelName": "creator", "nullable": true, "editable": false, "defaultValue": null, "domain": null, "name": "creator", "length": 255, "alias": "Creator", "type": "esriFieldTypeString" }, { "modelName": "editdate", "nullable": true, "editable": false, "defaultValue": null, "domain": null, "precision": 1, "name": "editdate", "length": 29, "alias": "EditDate", "type": "esriFieldTypeDate" }, { "modelName": "editor", "nullable": true, "editable": false, "defaultValue": null, "domain": null, "name": "editor", "length": 255, "alias": "Editor", "type": "esriFieldTypeString" }, { "nullable": false, "editable": false, "defaultValue": null, "domain": null, "name": "globalid", "length": 38, "alias": "globalid", "type": "esriFieldTypeGlobalID" } ], "maxRecordCountFactor": 1, "dateFieldsTimeReference": { "respectsDaylightSaving": false, "timeZone": "UTC" }, "supportsFieldDescriptionProperty": true, "allowGeometryUpdates": true, "useStandardizedQueries": true, "globalIdField": "globalid", "description": "", "syncCanReturnChanges": true, "supportsAsyncDelete": true, "supportedSpatialRelationships": [ "esriSpatialRelIntersects", "esriSpatialRelContains", "esriSpatialRelCrosses", "esriSpatialRelEnvelopeIntersects", "esriSpatialRelOverlaps", "esriSpatialRelTouches", "esriSpatialRelWithin" ], "supportsRollbackOnFailureParameter": true, "isDataReplicaTracked": false, "supportsTruncate": true, "indexes": [ { "name": "g14069facilityid", "isUnique": false, "description": "", "fields": "facilityid", "isAscending": true }, { "name": "r4637_sde_rowid_uk", "isUnique": true, "description": "", "fields": "objectid", "isAscending": true }, { "name": "uuid_4637", "isUnique": true, "description": "", "fields": "globalid", "isAscending": true } ], "editFieldsInfo": { "editDateField": "editdate", "editorField": "editor", "creationDateField": "creationdate", "creatorField": "creator" }, "htmlPopupType": "esriServerHTMLPopupTypeNone", "hasAttachments": false, "advancedQueryCapabilities": { "supportsSqlExpression": true, "supportsQueryWithResultType": true, "supportsQueryRelatedPagination": true, "supportsQueryWithCacheHint": false, "supportsQueryWithDatumTransformation": true, "supportsQueryNumericBins": false, "supportsCurrentUserQueries": true, "supportsQueryAttachmentsWithReturnUrl": true, "supportsQueryDateBins": false, "supportsQueryWithLodSR": false, "supportsPaginationOnAggregatedQueries": true, "supportsMaxRecordCountFactor": true, "supportsPagination": true, "supportsStatistics": true, "supportsOrderBy": true, "supportsLod": false, "supportsAdvancedQueryRelated": true, "supportsQueryAttachments": true, "supportsQueryAttachmentsCountOnly": true, "supportsReturningQueryExtent": true, "supportsOrderByOnlyOnLayerFields": false, "supportsOutFieldSqlExpression": true, "supportsTopFeaturesQuery": true, "supportsDistinct": true, "supportsQueryAnalytic": true, "supportsPercentileStatistics": true, "supportsHavingClause": true }, "supportsValidateSQL": true, "enableZDefaults": true, "serviceItemId": "c8ab64fd58ae41f79bb4b326233d89e9", "allowUpdateWithoutMValues": true, "supportsCoordinatesQuantization": true, "types": [], "capabilities": "Query,Sync", "supportsAppend": true, "supportsExceedsLimitStatistics": true, "advancedQueryAnalyticCapabilities": { "supportsAsync": true, "supportsLinearRegression": true, "supportsPercentileAnalytic": false }, "hasMetadata": true, "supportedAppendFormats": "shapefile,geojson,csv,featureCollection,excel,jsonl", "tileMaxRecordCount": 4000, "typeIdField": "", "supportsASyncCalculate": true, "supportedQueryFormats": "JSON, geoJSON, PBF", "sqlParserVersion": "PG_11.2.0", "copyrightText": "", "zDefault": 0, "supportsLayerOverrides": true }, { "isCoGoEnabled": false, "isDataBranchVersioned": false, "supportedContingentValuesFormats": "JSON, PBF", "supportsApplyEditsWithGlobalIds": true, "maxRecordCount": 2000, "infoInEstimates": [ "extent", "count" ], "type": "Table", "syncEnabled": true, "supportsAttachmentsByUploadId": true, "relationships": [ { "keyField": "facilityid", "role": "esriRelRoleDestination", "composite": false, "name": "swDischargePoint", "relatedTableId": 0, "id": 0, "cardinality": "esriRelCardinalityOneToMany" }, { "keyField": "facilityid", "role": "esriRelRoleDestination", "composite": false, "name": "swInlet", "relatedTableId": 1, "id": 1, "cardinality": "esriRelCardinalityOneToMany" }, { "keyField": "facilityid", "role": "esriRelRoleDestination", "composite": false, "name": "swNetworkStructure", "relatedTableId": 2, "id": 2, "cardinality": "esriRelCardinalityOneToMany" } ], "supportsAttachmentsResizing": true, "cimVersion": "2.6.0", "isDataArchived": false, "id": 9, "supportsStatistics": true, "supportedExportFormats": "sqlite,filegdb,shapefile,csv,geojson", "standardMaxRecordCount": 16000, "isDataVersioned": false, "templates": [ { "name": "swNodesCondition", "description": "", "drawingTool": "esriFeatureEditToolNone", "prototype": { "attributes": { "maintcomments": null, "manyid": null, "date_of_assessment": null, "cond_struct_rating": null, "facilityid": null, "cond_maint_rating": null, "cond_access_rating": null, "structcomments": null, "accesscomments": null } } } ], "supportsAdvancedQueries": true, "currentVersion": 11.2, "advancedEditingCapabilities": { "supportsAsyncApplyEdits": true, "supportsApplyEditsbyUploadID": true, "supportsReturnEditResults": true, "supportedSqlFormatsInCalculate": [ "standard" ], "supportedApplyEditsUploadIDFormats": "JSON" }, "objectIdField": "objectid", "supportsQuantizationEditMode": true, "hasContingentValuesDefinition": true, "name": "swNodesCondition", "displayField": "facilityid", "supportsCalculate": true, "fields": [ { "nullable": false, "defaultValue": null, "editable": false, "length": 4, "type": "esriFieldTypeOID", "modelName": "System-maintained ObjectID", "domain": null, "name": "objectid", "alias": "OBJECTID" }, { "modelName": "FACILITYID", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "facilityid", "length": 25, "alias": "Facility ID", "type": "esriFieldTypeString" }, { "modelName": "MANYID", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "manyid", "alias": "Many ID", "type": "esriFieldTypeInteger" }, { "modelName": "DATE_OF_ASSESSMENT", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "precision": 1, "name": "date_of_assessment", "length": 29, "alias": "Date Of Assessment", "type": "esriFieldTypeDate" }, { "modelName": "COND_ACCESS_RATING", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "cond_access_rating", "length": 30, "alias": "Accessibility Rating", "type": "esriFieldTypeString" }, { "modelName": "ACCESSCOMMENTS", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "accesscomments", "length": 254, "alias": "Accessibility Comments", "type": "esriFieldTypeString" }, { "modelName": "COND_STRUCT_RATING", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "cond_struct_rating", "length": 30, "alias": "Structural Rating", "type": "esriFieldTypeString" }, { "modelName": "STRUCTCOMMENTS", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "structcomments", "length": 254, "alias": "Structural Condition Comments", "type": "esriFieldTypeString" }, { "modelName": "COND_MAINT_RATING", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "cond_maint_rating", "length": 30, "alias": "Maintenance Rating", "type": "esriFieldTypeString" }, { "modelName": "MAINTCOMMENTS", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "maintcomments", "length": 254, "alias": "Maintenance Condition Comments", "type": "esriFieldTypeString" }, { "modelName": "creationdate", "nullable": true, "editable": false, "defaultValue": null, "domain": null, "precision": 1, "name": "creationdate", "length": 29, "alias": "CreationDate", "type": "esriFieldTypeDate" }, { "modelName": "creator", "nullable": true, "editable": false, "defaultValue": null, "domain": null, "name": "creator", "length": 255, "alias": "Creator", "type": "esriFieldTypeString" }, { "modelName": "editdate", "nullable": true, "editable": false, "defaultValue": null, "domain": null, "precision": 1, "name": "editdate", "length": 29, "alias": "EditDate", "type": "esriFieldTypeDate" }, { "modelName": "editor", "nullable": true, "editable": false, "defaultValue": null, "domain": null, "name": "editor", "length": 255, "alias": "Editor", "type": "esriFieldTypeString" }, { "nullable": false, "editable": false, "defaultValue": null, "domain": null, "name": "globalid", "length": 38, "alias": "globalid", "type": "esriFieldTypeGlobalID" } ], "maxRecordCountFactor": 1, "dateFieldsTimeReference": { "respectsDaylightSaving": false, "timeZone": "UTC" }, "supportsFieldDescriptionProperty": true, "allowGeometryUpdates": true, "useStandardizedQueries": true, "globalIdField": "globalid", "description": "", "syncCanReturnChanges": true, "supportsAsyncDelete": true, "supportedSpatialRelationships": [ "esriSpatialRelIntersects", "esriSpatialRelContains", "esriSpatialRelCrosses", "esriSpatialRelEnvelopeIntersects", "esriSpatialRelOverlaps", "esriSpatialRelTouches", "esriSpatialRelWithin" ], "supportsRollbackOnFailureParameter": true, "isDataReplicaTracked": false, "supportsTruncate": true, "indexes": [ { "name": "g14070facilityid", "isUnique": false, "description": "", "fields": "facilityid", "isAscending": true }, { "name": "r4638_sde_rowid_uk", "isUnique": true, "description": "", "fields": "objectid", "isAscending": true }, { "name": "uuid_4638", "isUnique": true, "description": "", "fields": "globalid", "isAscending": true } ], "editFieldsInfo": { "editDateField": "editdate", "editorField": "editor", "creationDateField": "creationdate", "creatorField": "creator" }, "htmlPopupType": "esriServerHTMLPopupTypeNone", "hasAttachments": false, "advancedQueryCapabilities": { "supportsSqlExpression": true, "supportsQueryWithResultType": true, "supportsQueryRelatedPagination": true, "supportsQueryWithCacheHint": false, "supportsQueryWithDatumTransformation": true, "supportsQueryNumericBins": false, "supportsCurrentUserQueries": true, "supportsQueryAttachmentsWithReturnUrl": true, "supportsQueryDateBins": false, "supportsQueryWithLodSR": false, "supportsPaginationOnAggregatedQueries": true, "supportsMaxRecordCountFactor": true, "supportsPagination": true, "supportsStatistics": true, "supportsOrderBy": true, "supportsLod": false, "supportsAdvancedQueryRelated": true, "supportsQueryAttachments": true, "supportsQueryAttachmentsCountOnly": true, "supportsReturningQueryExtent": true, "supportsOrderByOnlyOnLayerFields": false, "supportsOutFieldSqlExpression": true, "supportsTopFeaturesQuery": true, "supportsDistinct": true, "supportsQueryAnalytic": true, "supportsPercentileStatistics": true, "supportsHavingClause": true }, "supportsValidateSQL": true, "enableZDefaults": true, "serviceItemId": "c8ab64fd58ae41f79bb4b326233d89e9", "allowUpdateWithoutMValues": true, "supportsCoordinatesQuantization": true, "types": [], "capabilities": "Query,Sync", "supportsAppend": true, "supportsExceedsLimitStatistics": true, "advancedQueryAnalyticCapabilities": { "supportsAsync": true, "supportsLinearRegression": true, "supportsPercentileAnalytic": false }, "hasMetadata": true, "supportedAppendFormats": "shapefile,geojson,csv,featureCollection,excel,jsonl", "tileMaxRecordCount": 4000, "typeIdField": "", "supportsASyncCalculate": true, "supportedQueryFormats": "JSON, geoJSON, PBF", "sqlParserVersion": "PG_11.2.0", "copyrightText": "", "zDefault": 0, "supportsLayerOverrides": true } ], "layers": [ { "isCoGoEnabled": false, "extent": { "ymin": 4021541.288020894, "xmin": -9025804.18737912, "ymax": 4043683.492828667, "xmax": -8998967.262188971, "spatialReference": { "falseM": -100000, "xyTolerance": 0.001, "mUnits": 10000, "zUnits": 10000, "latestWkid": 3857, "zTolerance": 0.001, "wkid": 102100, "xyUnits": 1.4892314192838538E8, "mTolerance": 0.001, "falseX": -20037700, "falseY": -30241100, "falseZ": -100000 } }, "isDataBranchVersioned": false, "supportedContingentValuesFormats": "JSON, PBF", "supportsApplyEditsWithGlobalIds": true, "maxRecordCount": 2000, "infoInEstimates": [ "extent", "count" ], "type": "Feature Layer", "onlyAllowTrueCurveUpdatesByTrueCurveClients": true, "syncEnabled": true, "supportsAttachmentsByUploadId": true, "relationships": [ { "keyField": "facilityid", "role": "esriRelRoleOrigin", "composite": false, "name": "swNodesCondition", "relatedTableId": 9, "id": 0, "cardinality": "esriRelCardinalityOneToMany" } ], "supportsAttachmentsResizing": true, "cimVersion": "2.6.0", "isDataArchived": false, "id": 0, "supportsStatistics": true, "supportedExportFormats": "sqlite,filegdb,shapefile,csv,geojson", "standardMaxRecordCount": 16000, "isDataVersioned": false, "templates": [ { "name": "swDischargePoint", "description": "", "drawingTool": "esriFeatureEditToolPoint", "prototype": { "symbol": null, "_constructed": true, "attributes": { "maintainedby": 1, "watershed": null, "openbottomwidth": null, "facilityid": null, "facilityidindex": null, "installdate": null, "majoroutfall": null, "outfall": null, "avgdisch": null, "closedshape": null, "invertdepth": null, "northing": null, "enabled": 1, "lifecyclestatus": "Active", "dischid": null, "closedheight": null, "opendepth": null, "openclosed": null, "closeddischnum": null, "reasonforstub": null, "gpsdate": null, "ownedby": 1, "elevation": null, "closedwidth": null, "submerged": null, "comments": null, "easting": null, "permitid": null, "closeddiameter": null, "stubpt": null, "ancillaryrole": null, "centerelev": null, "dischstructtype": null, "activeflag": null, "invertelev": null, "submergedtype": null, "subwatershed": null, "estavgaccurracy": null, "material": null, "opentopwidth": null, "datasource": null, "gpswho": null, "permit": null, "peakdisch": null, "legacyid": null, "location": null, "instream": null } } } ], "hasGeometryProperties": true, "supportsAdvancedQueries": true, "parentLayer": null, "currentVersion": 11.2, "canScaleSymbols": false, "hasZ": false, "advancedEditingCapabilities": { "supportsAsyncApplyEdits": true, "supportsApplyEditsbyUploadID": true, "supportsReturnEditResults": true, "supportedSqlFormatsInCalculate": [ "standard" ], "supportedApplyEditsUploadIDFormats": "JSON" }, "objectIdField": "objectid", "supportsQuantizationEditMode": true, "hasContingentValuesDefinition": true, "name": "swDischargePoint", "allowTrueCurvesUpdates": false, "displayField": "facilityid", "supportsCalculate": true, "fields": [ { "nullable": false, "defaultValue": null, "editable": false, "length": 4, "type": "esriFieldTypeOID", "modelName": "System-maintained ObjectID", "domain": null, "name": "objectid", "alias": "OBJECTID" }, { "modelName": "FACILITYID", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "facilityid", "length": 25, "alias": "Facility ID", "type": "esriFieldTypeString" }, { "modelName": "FACILITYIDINDEX", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "facilityidindex", "alias": "Facility ID Index", "type": "esriFieldTypeInteger" }, { "modelName": "LEGACYID", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "legacyid", "length": 25, "alias": "Legacy ID", "type": "esriFieldTypeString" }, { "modelName": "INSTALLDATE", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "precision": 1, "name": "installdate", "length": 29, "alias": "Install Date", "type": "esriFieldTypeDate" }, { "modelName": "DISCHID", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "dischid", "length": 20, "alias": "Discharge Identifier", "type": "esriFieldTypeString" }, { "modelName": "DISCHSTRUCTTYPE", "nullable": true, "editable": true, "defaultValue": null, "domain": { "splitPolicy": "esriSPTDefaultValue", "name": "swDischargePointType_10", "description": "List of infrastructure Discharge Point Types", "type": "codedValue", "codedValues": [ { "code": "Rip Rap", "name": "Rip Rap" }, { "code": "Curb Cut", "name": "Curb Cut" }, { "code": "Spillway", "name": "Spillway" }, { "code": "Wingwall", "name": "Wingwall" }, { "code": "Flared End", "name": "Flared End" }, { "code": "Open Drainage", "name": "Open Drainage" }, { "code": "Pipe Inlet / Outlet", "name": "Pipe Inlet / Outlet" }, { "code": "Mitered", "name": "Mitered" }, { "code": "Headwall / Endwall", "name": "Headwall / Endwall" }, { "code": "Other", "name": "Other" }, { "code": "Unknown", "name": "Unknown" } ], "mergePolicy": "esriMPTDefaultValue" }, "name": "dischstructtype", "length": 50, "alias": "Discharge Structure Type", "type": "esriFieldTypeString" }, { "modelName": "MAJOROUTFALL", "nullable": true, "editable": true, "defaultValue": null, "domain": { "splitPolicy": "esriSPTDefaultValue", "name": "YesNo_22", "description": "A yes/no indicator", "type": "codedValue", "codedValues": [ { "code": "Y", "name": "Yes" }, { "code": "N", "name": "No" } ], "mergePolicy": "esriMPTDefaultValue" }, "name": "majoroutfall", "length": 5, "alias": "Major Outfall", "type": "esriFieldTypeString" }, { "modelName": "OUTFALL", "nullable": true, "editable": true, "defaultValue": null, "domain": { "splitPolicy": "esriSPTDefaultValue", "name": "YesNo_22", "description": "A yes/no indicator", "type": "codedValue", "codedValues": [ { "code": "Y", "name": "Yes" }, { "code": "N", "name": "No" } ], "mergePolicy": "esriMPTDefaultValue" }, "name": "outfall", "length": 50, "alias": "Outfall", "type": "esriFieldTypeString" }, { "modelName": "WATERSHED", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "watershed", "length": 50, "alias": "Watershed", "type": "esriFieldTypeString" }, { "modelName": "SUBWATERSHED", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "subwatershed", "length": 50, "alias": "Subwatershed", "type": "esriFieldTypeString" }, { "modelName": "PERMIT", "nullable": true, "editable": true, "defaultValue": null, "domain": { "splitPolicy": "esriSPTDefaultValue", "name": "YesNo_22", "description": "A yes/no indicator", "type": "codedValue", "codedValues": [ { "code": "Y", "name": "Yes" }, { "code": "N", "name": "No" } ], "mergePolicy": "esriMPTDefaultValue" }, "name": "permit", "length": 5, "alias": "Permitted MS4 Outfall", "type": "esriFieldTypeString" }, { "modelName": "PERMITID", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "permitid", "length": 100, "alias": "Permit Identifier", "type": "esriFieldTypeString" }, { "modelName": "OPENCLOSED", "nullable": true, "editable": true, "defaultValue": null, "domain": { "splitPolicy": "esriSPTDefaultValue", "name": "swOpenClosed", "description": "Either open or closed pipe", "type": "codedValue", "codedValues": [ { "code": "OD", "name": "Open Drainage" }, { "code": "CP", "name": "Closed Pipe" } ], "mergePolicy": "esriMPTDefaultValue" }, "name": "openclosed", "length": 20, "alias": "Open or Closed", "type": "esriFieldTypeString" }, { "modelName": "MATERIAL", "nullable": true, "editable": true, "defaultValue": null, "domain": { "splitPolicy": "esriSPTDefaultValue", "name": "swPipeMaterial", "description": "The list of pipe materials types based on the NASSCO standards", "type": "codedValue", "codedValues": [ { "code": "ABS", "name": "ABS Plastic" }, { "code": "AC", "name": "Asbestos Cement" }, { "code": "ASP", "name": "Asphalt" }, { "code": "BR", "name": "Brick" }, { "code": "BMP", "name": "Brick Masonry" }, { "code": "CAS", "name": "Cast Iron" }, { "code": "CT", "name": "Clay Tile" }, { "code": "CDB", "name": "Cinderblock" }, { "code": "CP", "name": "Concrete (Non-Reinforced)" }, { "code": "CSB", "name": "Concrete Segments (Bolted)" }, { "code": "CSU", "name": "Concrete Segments (Unbolted)" }, { "code": "CNB", "name": "Concrete & Brick" }, { "code": "CMP", "name": "Corrugated Metal" }, { "code": "COP", "name": "Copper" }, { "code": "CIPP", "name": "Cured In Place" }, { "code": "DIP", "name": "Ductile Iron" }, { "code": "FRP", "name": "Fiberglass Reinforced" }, { "code": "EARGEO", "name": "Earth & Geotextile" }, { "code": "EAR", "name": "Earthen" }, { "code": "GEO", "name": "Geotextile" }, { "code": "GP", "name": "Galvanized Pipe" }, { "code": "GRC", "name": "Glass Reinforced Cement" }, { "code": "HDPE", "name": "High Density Polyethylene" }, { "code": "OB", "name": "Pitch Fiber (Orangeburg)" }, { "code": "PSC", "name": "Plastic/Steel Composite" }, { "code": "PE", "name": "Polyethylene" }, { "code": "PP", "name": "Polypropylene" }, { "code": "PVC", "name": "Polyvinyl Chloride" }, { "code": "PCCP", "name": "Pre-Stressed Concrete Cylinder" }, { "code": "RCP", "name": "Reinforced Concrete" }, { "code": "RPM", "name": "Reinforced Plastic (Truss)" }, { "code": "RIP", "name": "Rip Rap" }, { "code": "SB", "name": "Segmented Block" }, { "code": "SP", "name": "Steel" }, { "code": "TTE", "name": "Transite" }, { "code": "VCP", "name": "Vitrified Clay" }, { "code": "WD", "name": "Wood" }, { "code": "OTH", "name": "Other" }, { "code": "UNK", "name": "Unknown" } ], "mergePolicy": "esriMPTDefaultValue" }, "name": "material", "length": 50, "alias": "Discharge Material", "type": "esriFieldTypeString" }, { "modelName": "CLOSEDDISCHNUM", "nullable": true, "editable": true, "defaultValue": null, "domain": { "splitPolicy": "esriSPTDefaultValue", "name": "swDischNumber_10", "description": "A number of shapes at a given closed pipe outfall.", "type": "codedValue", "codedValues": [ { "code": "D", "name": "Double" }, { "code": "Other", "name": "Other" }, { "code": "S", "name": "Single" }, { "code": "T", "name": "Triple" } ], "mergePolicy": "esriMPTDefaultValue" }, "name": "closeddischnum", "length": 5, "alias": "Closed Discharge Number", "type": "esriFieldTypeString" }, { "modelName": "CLOSEDSHAPE", "nullable": true, "editable": true, "defaultValue": null, "domain": { "splitPolicy": "esriSPTDefaultValue", "name": "swPipeShape_10", "description": "NASSCO pipe shapes", "type": "codedValue", "codedValues": [ { "code": "A", "name": "Arched" }, { "code": "B", "name": "Barrel" }, { "code": "C", "name": "Circular" }, { "code": "E", "name": "Egg-shaped" }, { "code": "H", "name": "Horseshoe" }, { "code": "O", "name": "Oval" }, { "code": "Other", "name": "Other" }, { "code": "R", "name": "Rectangular" }, { "code": "S", "name": "Square" }, { "code": "T", "name": "Trapezoidal" }, { "code": "TRI", "name": "Triangular/V-Shape" }, { "code": "U", "name": "U-shaped with Flat Top" }, { "code": "Unknown", "name": "Unknown" } ], "mergePolicy": "esriMPTDefaultValue" }, "name": "closedshape", "length": 100, "alias": "Closed Shape", "type": "esriFieldTypeString" }, { "modelName": "CLOSEDDIAMETER", "nullable": true, "editable": true, "defaultValue": null, "domain": { "splitPolicy": "esriSPTDuplicate", "name": "swPipeDiameter", "description": "A list of pipe diameters", "type": "codedValue", "codedValues": [ { "code": 6, "name": "6\"" }, { "code": 8, "name": "8\"" }, { "code": 10, "name": "10\"" }, { "code": 12, "name": "12\"" }, { "code": 15, "name": "15\"" }, { "code": 18, "name": "18\"" }, { "code": 21, "name": "21\"" }, { "code": 24, "name": "24\"" }, { "code": 30, "name": "30\"" }, { "code": 36, "name": "36\"" }, { "code": 42, "name": "42\"" }, { "code": 48, "name": "48\"" }, { "code": 54, "name": "54\"" }, { "code": 60, "name": "60\"" }, { "code": 66, "name": "66\"" }, { "code": 72, "name": "72\"" }, { "code": 78, "name": "78\"" }, { "code": 84, "name": "84\"" }, { "code": 90, "name": "90\"" }, { "code": 96, "name": "96\"" }, { "code": 102, "name": "102\"" }, { "code": 110, "name": "110\"" }, { "code": 114, "name": "114\"" }, { "code": 120, "name": "120\"" }, { "code": 126, "name": "126\"" }, { "code": 132, "name": "132\"" }, { "code": 138, "name": "138\"" }, { "code": 144, "name": "144\"" }, { "code": -1, "name": "Other" }, { "code": 0, "name": "Unknown" }, { "code": -3, "name": "N/A" } ], "mergePolicy": "esriMPTDefaultValue" }, "name": "closeddiameter", "alias": "Closed Diameter", "type": "esriFieldTypeDouble" }, { "modelName": "CLOSEDHEIGHT", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "closedheight", "alias": "Closed Height", "type": "esriFieldTypeDouble" }, { "modelName": "CLOSEDWIDTH", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "closedwidth", "alias": "Closed Width", "type": "esriFieldTypeDouble" }, { "modelName": "OPENDEPTH", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "opendepth", "alias": "Open Depth", "type": "esriFieldTypeDouble" }, { "modelName": "OPENTOPWIDTH", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "opentopwidth", "alias": "Open Top Width", "type": "esriFieldTypeDouble" }, { "modelName": "OPENBOTTOMWIDTH", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "openbottomwidth", "alias": "Open Bottom Width", "type": "esriFieldTypeDouble" }, { "modelName": "INVERTDEPTH", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "invertdepth", "alias": "Invert Depth", "type": "esriFieldTypeDouble" }, { "modelName": "SUBMERGED", "nullable": true, "editable": true, "defaultValue": null, "domain": { "splitPolicy": "esriSPTDefaultValue", "name": "swSubmerged", "description": "Sanitary and stormwater pipe shapes", "type": "codedValue", "codedValues": [ { "code": "Fully", "name": "Fully" }, { "code": "Partly", "name": "Partly" }, { "code": "N", "name": "No" } ], "mergePolicy": "esriMPTDefaultValue" }, "name": "submerged", "length": 8, "alias": "Submerged", "type": "esriFieldTypeString" }, { "modelName": "SUBMERGEDTYPE", "nullable": true, "editable": true, "defaultValue": null, "domain": { "splitPolicy": "esriSPTDefaultValue", "name": "swSubmergedTypes_3", "description": "A list of submerged depth types.", "type": "codedValue", "codedValues": [ { "code": "NO", "name": "No" }, { "code": "PART", "name": "Partially" }, { "code": "FULL", "name": "Fully" } ], "mergePolicy": "esriMPTDefaultValue" }, "name": "submergedtype", "length": 50, "alias": "Submerged Type", "type": "esriFieldTypeString" }, { "modelName": "INSTREAM", "nullable": true, "editable": true, "defaultValue": null, "domain": { "splitPolicy": "esriSPTDefaultValue", "name": "YesNo_22", "description": "A yes/no indicator", "type": "codedValue", "codedValues": [ { "code": "Y", "name": "Yes" }, { "code": "N", "name": "No" } ], "mergePolicy": "esriMPTDefaultValue" }, "name": "instream", "length": 5, "alias": "In Stream", "type": "esriFieldTypeString" }, { "modelName": "AVGDISCH", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "avgdisch", "length": 10, "alias": "Average Discharge", "type": "esriFieldTypeString" }, { "modelName": "PEAKDISCH", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "peakdisch", "length": 10, "alias": "Peak Discharge", "type": "esriFieldTypeString" }, { "modelName": "LIFECYCLESTATUS", "nullable": true, "editable": true, "defaultValue": "Active", "domain": { "splitPolicy": "esriSPTDefaultValue", "name": "swLifeCycleStatus", "description": "Life cycle status of the asset", "type": "codedValue", "codedValues": [ { "code": "Active", "name": "Active" }, { "code": "Inactive", "name": "Inactive" }, { "code": "Proposed", "name": "Proposed" }, { "code": "Abandoned", "name": "Abandoned" }, { "code": "Removed", "name": "Removed" }, { "code": "Deleted/DNE", "name": "Deleted/DNE" } ], "mergePolicy": "esriMPTDefaultValue" }, "name": "lifecyclestatus", "length": 25, "alias": "Life Cycle Status", "type": "esriFieldTypeString" }, { "modelName": "ACTIVEFLAG", "nullable": true, "editable": true, "defaultValue": null, "domain": { "splitPolicy": "esriSPTDuplicate", "name": "BooleanDomain_6", "description": "A 0/1 boolean domain", "type": "codedValue", "codedValues": [ { "code": 0, "name": "False" }, { "code": 1, "name": "True" } ], "mergePolicy": "esriMPTDefaultValue" }, "name": "activeflag", "alias": "Active Flag", "type": "esriFieldTypeSmallInteger" }, { "modelName": "OWNEDBY", "nullable": true, "editable": true, "defaultValue": 1, "domain": { "splitPolicy": "esriSPTDefaultValue", "name": "swAssetOwner", "description": "The owner of the asset", "type": "codedValue", "codedValues": [ { "code": 1, "name": "City of Columbia" }, { "code": 2, "name": "SCDOT" }, { "code": 3, "name": "Richland County" }, { "code": 4, "name": "Lexington County" }, { "code": 5, "name": "USC" }, { "code": 6, "name": "Federal" }, { "code": 0, "name": "Joint Ownership" }, { "code": -1, "name": "Private" }, { "code": -2, "name": "Unknown" } ], "mergePolicy": "esriMPTDefaultValue" }, "name": "ownedby", "alias": "Owned By", "type": "esriFieldTypeSmallInteger" }, { "modelName": "MAINTAINEDBY", "nullable": true, "editable": true, "defaultValue": 1, "domain": { "splitPolicy": "esriSPTDefaultValue", "name": "swAssetManager", "description": "The manager of the asset", "type": "codedValue", "codedValues": [ { "code": 1, "name": "City of Columbia" }, { "code": 2, "name": "SCDOT" }, { "code": 3, "name": "Richland County" }, { "code": 4, "name": "Lexington County" }, { "code": 5, "name": "USC" }, { "code": 6, "name": "Federal" }, { "code": 0, "name": "Joint Ownership" }, { "code": -1, "name": "Private" }, { "code": -2, "name": "Unknown" } ], "mergePolicy": "esriMPTDefaultValue" }, "name": "maintainedby", "alias": "Maintained By", "type": "esriFieldTypeSmallInteger" }, { "modelName": "LOCATION", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "location", "length": 250, "alias": "Location Description", "type": "esriFieldTypeString" }, { "modelName": "COMMENTS", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "comments", "length": 250, "alias": "Comments", "type": "esriFieldTypeString" }, { "modelName": "STUBPT", "nullable": true, "editable": true, "defaultValue": null, "domain": { "splitPolicy": "esriSPTDefaultValue", "name": "swStubPt", "description": "Is the feature a Stub Point", "type": "codedValue", "codedValues": [ { "code": "Stub Point", "name": "Stub Point" }, { "code": "N/A", "name": "N/A" } ], "mergePolicy": "esriMPTDefaultValue" }, "name": "stubpt", "length": 30, "alias": "Stub Point", "type": "esriFieldTypeString" }, { "modelName": "REASONFORSTUB", "nullable": true, "editable": true, "defaultValue": null, "domain": { "splitPolicy": "esriSPTDefaultValue", "name": "swReasonForStub_12", "description": "Why the feature is tagged as a Stub Point", "type": "codedValue", "codedValues": [ { "code": "Edge of Basin", "name": "Edge of Basin" }, { "code": "Edge of Project Area", "name": "Edge of Project Area" }, { "code": "Inaccessible", "name": "Inaccessible" }, { "code": "Not Found", "name": "Not Found" }, { "code": "Private or Commercial", "name": "Private or Commercial" }, { "code": "Paved Over", "name": "Paved Over" }, { "code": "Abandoned", "name": "Abandoned" }, { "code": "Other", "name": "Other" } ], "mergePolicy": "esriMPTDefaultValue" }, "name": "reasonforstub", "length": 255, "alias": "Reason For Stub Point", "type": "esriFieldTypeString" }, { "modelName": "DATASOURCE", "nullable": true, "editable": true, "defaultValue": null, "domain": { "splitPolicy": "esriSPTDefaultValue", "name": "swDataSource", "description": "Source of the data", "type": "codedValue", "codedValues": [ { "code": "ASB", "name": "Asbuilt/Record Drawing" }, { "code": "DES", "name": "Design Drawing" }, { "code": "IMG", "name": "Imagery" }, { "code": "MAPGPS", "name": "Mapping Grade GPS" }, { "code": "SURVGPS", "name": "Survey Grade GPS" }, { "code": "FLD", "name": "Field Survey" }, { "code": "SC", "name": "Service Card" }, { "code": "TC", "name": "Tap Card" }, { "code": "PLAT", "name": "Plat" }, { "code": "DEED", "name": "Deed" }, { "code": "AUTO", "name": "Auto Generated" }, { "code": "OTH", "name": "Other" }, { "code": "UNK", "name": "Unknown" } ], "mergePolicy": "esriMPTDefaultValue" }, "name": "datasource", "length": 30, "alias": "Data Source", "type": "esriFieldTypeString" }, { "modelName": "LASTEDITOR", "nullable": true, "editable": false, "defaultValue": null, "domain": null, "name": "lasteditor", "length": 50, "alias": "Last Editor", "type": "esriFieldTypeString" }, { "modelName": "LASTUPDATE", "nullable": true, "editable": false, "defaultValue": null, "domain": null, "precision": 1, "name": "lastupdate", "length": 29, "alias": "Last Update Date", "type": "esriFieldTypeDate" }, { "modelName": "CREATOR", "nullable": true, "editable": false, "defaultValue": null, "domain": null, "name": "creator", "length": 50, "alias": "Creator", "type": "esriFieldTypeString" }, { "modelName": "CREATIONDATE", "nullable": true, "editable": false, "defaultValue": null, "domain": null, "precision": 1, "name": "creationdate", "length": 29, "alias": "Creation Date", "type": "esriFieldTypeDate" }, { "modelName": "GPSWHO", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "gpswho", "length": 50, "alias": "GPS Who", "type": "esriFieldTypeString" }, { "modelName": "GPSDATE", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "precision": 1, "name": "gpsdate", "length": 29, "alias": "GPS Date", "type": "esriFieldTypeDate" }, { "modelName": "NORTHING", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "northing", "alias": "Northing", "type": "esriFieldTypeDouble" }, { "modelName": "EASTING", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "easting", "alias": "Easting", "type": "esriFieldTypeDouble" }, { "modelName": "ELEVATION", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "elevation", "alias": "Surveyed Elevation", "type": "esriFieldTypeDouble" }, { "modelName": "INVERTELEV", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "invertelev", "alias": "Invert Elevation", "type": "esriFieldTypeDouble" }, { "modelName": "ESTAVGACCURRACY", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "estavgaccurracy", "alias": "Estimated Average Accurracy", "type": "esriFieldTypeDouble" }, { "modelName": "ENABLED", "nullable": true, "editable": true, "defaultValue": 1, "domain": { "splitPolicy": "esriSPTDefaultValue", "name": "EnabledDomain_9", "description": "Geometric Network Enabled domain", "type": "codedValue", "codedValues": [ { "code": 0, "name": "False" }, { "code": 1, "name": "True" } ], "mergePolicy": "esriMPTDefaultValue" }, "name": "enabled", "alias": "Enabled", "type": "esriFieldTypeSmallInteger" }, { "modelName": "ANCILLARYROLE", "nullable": true, "editable": true, "defaultValue": null, "domain": { "splitPolicy": "esriSPTDefaultValue", "name": "AncillaryRoleDomain_1", "description": "", "type": "codedValue", "codedValues": [ { "code": "None", "name": "None" }, { "code": "Source", "name": "Source" }, { "code": "Sink", "name": "Sink" } ], "mergePolicy": "esriMPTDefaultValue" }, "name": "ancillaryrole", "length": 10, "alias": "ANCILLARYROLE", "type": "esriFieldTypeString" }, { "modelName": "CENTERELEV", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "centerelev", "alias": "Stucture Center Elevation", "type": "esriFieldTypeDouble" }, { "nullable": false, "editable": false, "defaultValue": null, "domain": null, "name": "globalid", "length": 38, "alias": "globalid", "type": "esriFieldTypeGlobalID" } ], "maxRecordCountFactor": 1, "dateFieldsTimeReference": { "respectsDaylightSaving": false, "timeZone": "UTC" }, "supportsFieldDescriptionProperty": true, "hasM": false, "allowGeometryUpdates": true, "useStandardizedQueries": true, "globalIdField": "globalid", "description": "", "syncCanReturnChanges": true, "supportsAsyncDelete": true, "supportedSpatialRelationships": [ "esriSpatialRelIntersects", "esriSpatialRelContains", "esriSpatialRelCrosses", "esriSpatialRelEnvelopeIntersects", "esriSpatialRelOverlaps", "esriSpatialRelTouches", "esriSpatialRelWithin" ], "supportsRollbackOnFailureParameter": true, "isDataReplicaTracked": false, "standardMaxRecordCountNoGeometry": 16000, "supportsTruncate": true, "indexes": [ { "name": "g14078facilityid", "isUnique": false, "description": "", "fields": "facilityid", "isAscending": true }, { "name": "i14078facilityid", "isUnique": false, "description": "", "fields": "facilityidindex", "isAscending": true }, { "name": "i14078legacyid", "isUnique": false, "description": "", "fields": "legacyid", "isAscending": true }, { "name": "r4645_sde_rowid_uk", "isUnique": true, "description": "", "fields": "objectid", "isAscending": true }, { "name": "a3853_ix1", "isUnique": true, "description": "", "fields": "shape", "isAscending": true }, { "name": "uuid_4645", "isUnique": true, "description": "", "fields": "globalid", "isAscending": true } ], "editFieldsInfo": { "editDateField": "lastupdate", "editorField": "lasteditor", "creationDateField": "creationdate", "creatorField": "creator" }, "htmlPopupType": "esriServerHTMLPopupTypeAsHTMLText", "minScale": 9028, "hasAttachments": false, "advancedQueryCapabilities": { "supportsSqlExpression": true, "supportsQueryWithResultType": true, "supportsQueryRelatedPagination": true, "supportsQueryWithCacheHint": false, "supportsQueryWithDatumTransformation": true, "supportsQueryNumericBins": false, "supportsCurrentUserQueries": true, "supportsQueryAttachmentsWithReturnUrl": true, "supportsQueryDateBins": false, "supportsQueryWithLodSR": true, "supportsPaginationOnAggregatedQueries": true, "supportsPagination": true, "supportsMaxRecordCountFactor": true, "supportsStatistics": true, "supportsOrderBy": true, "supportsQueryWithDistance": true, "supportsLod": true, "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": "c8ab64fd58ae41f79bb4b326233d89e9", "allowUpdateWithoutMValues": true, "supportsCoordinatesQuantization": true, "types": [], "capabilities": "Query,Sync", "maxScale": 0, "supportsAppend": true, "supportsExceedsLimitStatistics": true, "defaultVisibility": true, "advancedQueryAnalyticCapabilities": { "supportsAsync": true, "supportsLinearRegression": true, "supportsPercentileAnalytic": false }, "hasMetadata": true, "supportedAppendFormats": "shapefile,geojson,csv,featureCollection,excel,jsonl", "tileMaxRecordCount": 4000, "typeIdField": "", "supportsASyncCalculate": true, "supportedQueryFormats": "JSON, geoJSON, PBF", "sqlParserVersion": "PG_11.2.0", "drawingInfo": { "renderer": { "symbol": { "outline": { "color": [ 112, 112, 112, 255 ], "width": 0.75, "style": "esriSLSSolid", "type": "esriSLS" }, "color": [ 190, 232, 255, 255 ], "size": 4, "yoffset": 0, "xoffset": 0, "angle": 0, "style": "esriSMSCircle", "type": "esriSMS" }, "type": "simple" }, "transparency": 0 }, "copyrightText": "", "zDefault": 0, "geometryType": "esriGeometryPoint", "supportsLayerOverrides": true }, { "isCoGoEnabled": false, "extent": { "ymin": 4020327.2048199847, "xmin": -9035951.716426088, "ymax": 4046380.239949189, "xmax": -8996291.6504232, "spatialReference": { "falseM": -100000, "xyTolerance": 0.001, "mUnits": 10000, "zUnits": 10000, "latestWkid": 3857, "zTolerance": 0.001, "wkid": 102100, "xyUnits": 1.4892314192838538E8, "mTolerance": 0.001, "falseX": -20037700, "falseY": -30241100, "falseZ": -100000 } }, "isDataBranchVersioned": false, "supportedContingentValuesFormats": "JSON, PBF", "supportsApplyEditsWithGlobalIds": true, "maxRecordCount": 2000, "infoInEstimates": [ "extent", "count" ], "type": "Feature Layer", "onlyAllowTrueCurveUpdatesByTrueCurveClients": true, "syncEnabled": true, "supportsAttachmentsByUploadId": true, "relationships": [ { "keyField": "facilityid", "role": "esriRelRoleOrigin", "composite": false, "name": "swNodesCondition", "relatedTableId": 9, "id": 1, "cardinality": "esriRelCardinalityOneToMany" } ], "supportsAttachmentsResizing": true, "cimVersion": "2.6.0", "isDataArchived": false, "id": 1, "supportsStatistics": true, "supportedExportFormats": "sqlite,filegdb,shapefile,csv,geojson", "standardMaxRecordCount": 16000, "isDataVersioned": false, "templates": [ { "name": "swInlet", "description": "", "drawingTool": "esriFeatureEditToolPoint", "prototype": { "symbol": null, "_constructed": true, "attributes": { "maintainedby": 1, "facilityid": null, "facilityidindex": null, "installdate": null, "outfall": null, "invertdepth": null, "northing": null, "enabled": 1, "lifecyclestatus": "Active", "throatoffset": null, "reasonforstub": null, "gpsdate": null, "ownedby": 1, "elevation": null, "accesstype": null, "comments": null, "easting": null, "stubpt": null, "centerelev": null, "ancillaryrole": null, "additionalpipe": null, "activeflag": null, "subwatershed": null, "structuredepth": null, "inlettype": null, "datasource": null, "gpswho": null, "legacyid": null, "location": null } } } ], "hasGeometryProperties": true, "supportsAdvancedQueries": true, "parentLayer": null, "currentVersion": 11.2, "canScaleSymbols": false, "hasZ": false, "advancedEditingCapabilities": { "supportsAsyncApplyEdits": true, "supportsApplyEditsbyUploadID": true, "supportsReturnEditResults": true, "supportedSqlFormatsInCalculate": [ "standard" ], "supportedApplyEditsUploadIDFormats": "JSON" }, "objectIdField": "objectid", "supportsQuantizationEditMode": true, "hasContingentValuesDefinition": true, "name": "swInlet", "allowTrueCurvesUpdates": false, "displayField": "facilityid", "supportsCalculate": true, "fields": [ { "nullable": false, "defaultValue": null, "editable": false, "length": 4, "type": "esriFieldTypeOID", "modelName": "System-maintained ObjectID", "domain": null, "name": "objectid", "alias": "OBJECTID" }, { "modelName": "FACILITYID", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "facilityid", "length": 25, "alias": "Facility ID", "type": "esriFieldTypeString" }, { "modelName": "FACILITYIDINDEX", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "facilityidindex", "alias": "Facility ID Index", "type": "esriFieldTypeInteger" }, { "modelName": "LEGACYID", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "legacyid", "length": 25, "alias": "Legacy ID", "type": "esriFieldTypeString" }, { "modelName": "INSTALLDATE", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "precision": 1, "name": "installdate", "length": 29, "alias": "Install Date", "type": "esriFieldTypeDate" }, { "modelName": "INLETTYPE", "nullable": true, "editable": true, "defaultValue": null, "domain": { "splitPolicy": "esriSPTDefaultValue", "name": "swInletTypes_10", "description": "List of inlet types", "type": "codedValue", "codedValues": [ { "code": "Grate Inlet", "name": "Grate Inlet" }, { "code": "Combination Inlet", "name": "Combination Inlet" }, { "code": "Curb Inlet", "name": "Curb Inlet" }, { "code": "Yard Inlet", "name": "Yard Inlet" }, { "code": "Other", "name": "Other" }, { "code": "Unknown", "name": "Unknown" } ], "mergePolicy": "esriMPTDefaultValue" }, "name": "inlettype", "length": 50, "alias": "Inlet Type", "type": "esriFieldTypeString" }, { "modelName": "ACCESSTYPE", "nullable": true, "editable": true, "defaultValue": null, "domain": { "splitPolicy": "esriSPTDefaultValue", "name": "swAccessType_10", "description": "List of infrastructure access types", "type": "codedValue", "codedValues": [ { "code": "Grate", "name": "Grate" }, { "code": "Manhole", "name": "Manhole" }, { "code": "No Access", "name": "No Access" }, { "code": "Other", "name": "Other" }, { "code": "Unknown", "name": "Unknown" } ], "mergePolicy": "esriMPTDefaultValue" }, "name": "accesstype", "length": 20, "alias": "Access Type", "type": "esriFieldTypeString" }, { "modelName": "STRUCTUREDEPTH", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "structuredepth", "alias": "Structure Center Depth", "type": "esriFieldTypeDouble" }, { "modelName": "SUBWATERSHED", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "subwatershed", "length": 50, "alias": "Subwatershed", "type": "esriFieldTypeString" }, { "modelName": "THROATOFFSET", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "throatoffset", "alias": "Throat Offset", "type": "esriFieldTypeDouble" }, { "modelName": "INVERTDEPTH", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "invertdepth", "alias": "Invert Depth", "type": "esriFieldTypeDouble" }, { "modelName": "STUBPT", "nullable": true, "editable": true, "defaultValue": null, "domain": { "splitPolicy": "esriSPTDefaultValue", "name": "swStubPt", "description": "Is the feature a Stub Point", "type": "codedValue", "codedValues": [ { "code": "Stub Point", "name": "Stub Point" }, { "code": "N/A", "name": "N/A" } ], "mergePolicy": "esriMPTDefaultValue" }, "name": "stubpt", "length": 30, "alias": "Stub Point", "type": "esriFieldTypeString" }, { "modelName": "REASONFORSTUB", "nullable": true, "editable": true, "defaultValue": null, "domain": { "splitPolicy": "esriSPTDefaultValue", "name": "swReasonForStub_12", "description": "Why the feature is tagged as a Stub Point", "type": "codedValue", "codedValues": [ { "code": "Edge of Basin", "name": "Edge of Basin" }, { "code": "Edge of Project Area", "name": "Edge of Project Area" }, { "code": "Inaccessible", "name": "Inaccessible" }, { "code": "Not Found", "name": "Not Found" }, { "code": "Private or Commercial", "name": "Private or Commercial" }, { "code": "Paved Over", "name": "Paved Over" }, { "code": "Abandoned", "name": "Abandoned" }, { "code": "Other", "name": "Other" } ], "mergePolicy": "esriMPTDefaultValue" }, "name": "reasonforstub", "length": 255, "alias": "Reason For Stub Point", "type": "esriFieldTypeString" }, { "modelName": "OUTFALL", "nullable": true, "editable": true, "defaultValue": null, "domain": { "splitPolicy": "esriSPTDefaultValue", "name": "YesNo_22", "description": "A yes/no indicator", "type": "codedValue", "codedValues": [ { "code": "Y", "name": "Yes" }, { "code": "N", "name": "No" } ], "mergePolicy": "esriMPTDefaultValue" }, "name": "outfall", "length": 50, "alias": "Outfall", "type": "esriFieldTypeString" }, { "modelName": "LIFECYCLESTATUS", "nullable": true, "editable": true, "defaultValue": "Active", "domain": { "splitPolicy": "esriSPTDefaultValue", "name": "swLifeCycleStatus", "description": "Life cycle status of the asset", "type": "codedValue", "codedValues": [ { "code": "Active", "name": "Active" }, { "code": "Inactive", "name": "Inactive" }, { "code": "Proposed", "name": "Proposed" }, { "code": "Abandoned", "name": "Abandoned" }, { "code": "Removed", "name": "Removed" }, { "code": "Deleted/DNE", "name": "Deleted/DNE" } ], "mergePolicy": "esriMPTDefaultValue" }, "name": "lifecyclestatus", "length": 25, "alias": "Life Cycle Status", "type": "esriFieldTypeString" }, { "modelName": "ACTIVEFLAG", "nullable": true, "editable": true, "defaultValue": null, "domain": { "splitPolicy": "esriSPTDuplicate", "name": "BooleanDomain_6", "description": "A 0/1 boolean domain", "type": "codedValue", "codedValues": [ { "code": 0, "name": "False" }, { "code": 1, "name": "True" } ], "mergePolicy": "esriMPTDefaultValue" }, "name": "activeflag", "alias": "Active Flag", "type": "esriFieldTypeSmallInteger" }, { "modelName": "OWNEDBY", "nullable": true, "editable": true, "defaultValue": 1, "domain": { "splitPolicy": "esriSPTDefaultValue", "name": "swAssetOwner", "description": "The owner of the asset", "type": "codedValue", "codedValues": [ { "code": 1, "name": "City of Columbia" }, { "code": 2, "name": "SCDOT" }, { "code": 3, "name": "Richland County" }, { "code": 4, "name": "Lexington County" }, { "code": 5, "name": "USC" }, { "code": 6, "name": "Federal" }, { "code": 0, "name": "Joint Ownership" }, { "code": -1, "name": "Private" }, { "code": -2, "name": "Unknown" } ], "mergePolicy": "esriMPTDefaultValue" }, "name": "ownedby", "alias": "Owned By", "type": "esriFieldTypeSmallInteger" }, { "modelName": "MAINTAINEDBY", "nullable": true, "editable": true, "defaultValue": 1, "domain": { "splitPolicy": "esriSPTDefaultValue", "name": "swAssetManager", "description": "The manager of the asset", "type": "codedValue", "codedValues": [ { "code": 1, "name": "City of Columbia" }, { "code": 2, "name": "SCDOT" }, { "code": 3, "name": "Richland County" }, { "code": 4, "name": "Lexington County" }, { "code": 5, "name": "USC" }, { "code": 6, "name": "Federal" }, { "code": 0, "name": "Joint Ownership" }, { "code": -1, "name": "Private" }, { "code": -2, "name": "Unknown" } ], "mergePolicy": "esriMPTDefaultValue" }, "name": "maintainedby", "alias": "Maintained By", "type": "esriFieldTypeSmallInteger" }, { "modelName": "LOCATION", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "location", "length": 250, "alias": "Location Description", "type": "esriFieldTypeString" }, { "modelName": "COMMENTS", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "comments", "length": 250, "alias": "Comments", "type": "esriFieldTypeString" }, { "modelName": "DATASOURCE", "nullable": true, "editable": true, "defaultValue": null, "domain": { "splitPolicy": "esriSPTDefaultValue", "name": "swDataSource", "description": "Source of the data", "type": "codedValue", "codedValues": [ { "code": "ASB", "name": "Asbuilt/Record Drawing" }, { "code": "DES", "name": "Design Drawing" }, { "code": "IMG", "name": "Imagery" }, { "code": "MAPGPS", "name": "Mapping Grade GPS" }, { "code": "SURVGPS", "name": "Survey Grade GPS" }, { "code": "FLD", "name": "Field Survey" }, { "code": "SC", "name": "Service Card" }, { "code": "TC", "name": "Tap Card" }, { "code": "PLAT", "name": "Plat" }, { "code": "DEED", "name": "Deed" }, { "code": "AUTO", "name": "Auto Generated" }, { "code": "OTH", "name": "Other" }, { "code": "UNK", "name": "Unknown" } ], "mergePolicy": "esriMPTDefaultValue" }, "name": "datasource", "length": 25, "alias": "Data Source", "type": "esriFieldTypeString" }, { "modelName": "LASTEDITOR", "nullable": true, "editable": false, "defaultValue": null, "domain": null, "name": "lasteditor", "length": 50, "alias": "Last Editor", "type": "esriFieldTypeString" }, { "modelName": "LASTUPDATE", "nullable": true, "editable": false, "defaultValue": null, "domain": null, "precision": 1, "name": "lastupdate", "length": 29, "alias": "Last Update Date", "type": "esriFieldTypeDate" }, { "modelName": "CREATOR", "nullable": true, "editable": false, "defaultValue": null, "domain": null, "name": "creator", "length": 50, "alias": "Creator", "type": "esriFieldTypeString" }, { "modelName": "CREATIONDATE", "nullable": true, "editable": false, "defaultValue": null, "domain": null, "precision": 1, "name": "creationdate", "length": 29, "alias": "Creation Date", "type": "esriFieldTypeDate" }, { "modelName": "GPSWHO", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "gpswho", "length": 50, "alias": "GPS Who", "type": "esriFieldTypeString" }, { "modelName": "GPSDATE", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "precision": 1, "name": "gpsdate", "length": 29, "alias": "GPS Date", "type": "esriFieldTypeDate" }, { "modelName": "NORTHING", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "northing", "alias": "Northing", "type": "esriFieldTypeDouble" }, { "modelName": "EASTING", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "easting", "alias": "Easting", "type": "esriFieldTypeDouble" }, { "modelName": "ELEVATION", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "elevation", "alias": "Surveyed Elevation", "type": "esriFieldTypeDouble" }, { "modelName": "ENABLED", "nullable": true, "editable": true, "defaultValue": 1, "domain": { "splitPolicy": "esriSPTDefaultValue", "name": "EnabledDomain_9", "description": "Geometric Network Enabled domain", "type": "codedValue", "codedValues": [ { "code": 0, "name": "False" }, { "code": 1, "name": "True" } ], "mergePolicy": "esriMPTDefaultValue" }, "name": "enabled", "alias": "Enabled", "type": "esriFieldTypeSmallInteger" }, { "modelName": "ANCILLARYROLE", "nullable": true, "editable": true, "defaultValue": null, "domain": { "splitPolicy": "esriSPTDefaultValue", "name": "AncillaryRoleDomain_1", "description": "", "type": "codedValue", "codedValues": [ { "code": "None", "name": "None" }, { "code": "Source", "name": "Source" }, { "code": "Sink", "name": "Sink" } ], "mergePolicy": "esriMPTDefaultValue" }, "name": "ancillaryrole", "length": 10, "alias": "Ancillary Role", "type": "esriFieldTypeString" }, { "modelName": "ADDITIONALPIPE", "nullable": true, "editable": true, "defaultValue": null, "domain": { "splitPolicy": "esriSPTDefaultValue", "name": "YesNo_22", "description": "A yes/no indicator", "type": "codedValue", "codedValues": [ { "code": "Y", "name": "Yes" }, { "code": "N", "name": "No" } ], "mergePolicy": "esriMPTDefaultValue" }, "name": "additionalpipe", "length": 50, "alias": "Additional Pipes Present", "type": "esriFieldTypeString" }, { "modelName": "CENTERELEV", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "centerelev", "alias": "Structure Center Elevation", "type": "esriFieldTypeDouble" }, { "nullable": false, "editable": false, "defaultValue": null, "domain": null, "name": "globalid", "length": 38, "alias": "globalid", "type": "esriFieldTypeGlobalID" } ], "maxRecordCountFactor": 1, "dateFieldsTimeReference": { "respectsDaylightSaving": false, "timeZone": "UTC" }, "supportsFieldDescriptionProperty": true, "hasM": false, "allowGeometryUpdates": true, "useStandardizedQueries": true, "globalIdField": "globalid", "description": "", "syncCanReturnChanges": true, "supportsAsyncDelete": true, "supportedSpatialRelationships": [ "esriSpatialRelIntersects", "esriSpatialRelContains", "esriSpatialRelCrosses", "esriSpatialRelEnvelopeIntersects", "esriSpatialRelOverlaps", "esriSpatialRelTouches", "esriSpatialRelWithin" ], "supportsRollbackOnFailureParameter": true, "isDataReplicaTracked": false, "standardMaxRecordCountNoGeometry": 16000, "supportsTruncate": true, "indexes": [ { "name": "g14073facilityid", "isUnique": false, "description": "", "fields": "facilityid", "isAscending": true }, { "name": "r4640_sde_rowid_uk", "isUnique": true, "description": "", "fields": "objectid", "isAscending": true }, { "name": "a3848_ix1", "isUnique": true, "description": "", "fields": "shape", "isAscending": true }, { "name": "uuid_4640", "isUnique": true, "description": "", "fields": "globalid", "isAscending": true } ], "editFieldsInfo": { "editDateField": "lastupdate", "editorField": "lasteditor", "creationDateField": "creationdate", "creatorField": "creator" }, "htmlPopupType": "esriServerHTMLPopupTypeAsHTMLText", "minScale": 9028, "hasAttachments": false, "advancedQueryCapabilities": { "supportsSqlExpression": true, "supportsQueryWithResultType": true, "supportsQueryRelatedPagination": true, "supportsQueryWithCacheHint": false, "supportsQueryWithDatumTransformation": true, "supportsQueryNumericBins": false, "supportsCurrentUserQueries": true, "supportsQueryAttachmentsWithReturnUrl": true, "supportsQueryDateBins": false, "supportsQueryWithLodSR": true, "supportsPaginationOnAggregatedQueries": true, "supportsPagination": true, "supportsMaxRecordCountFactor": true, "supportsStatistics": true, "supportsOrderBy": true, "supportsQueryWithDistance": true, "supportsLod": true, "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": "c8ab64fd58ae41f79bb4b326233d89e9", "allowUpdateWithoutMValues": true, "supportsCoordinatesQuantization": true, "types": [], "capabilities": "Query,Sync", "maxScale": 0, "supportsAppend": true, "supportsExceedsLimitStatistics": true, "defaultVisibility": true, "advancedQueryAnalyticCapabilities": { "supportsAsync": true, "supportsLinearRegression": true, "supportsPercentileAnalytic": false }, "hasMetadata": true, "supportedAppendFormats": "shapefile,geojson,csv,featureCollection,excel,jsonl", "tileMaxRecordCount": 4000, "typeIdField": "", "supportsASyncCalculate": true, "supportedQueryFormats": "JSON, geoJSON, PBF", "sqlParserVersion": "PG_11.2.0", "drawingInfo": { "renderer": { "symbol": { "outline": { "color": [ 0, 0, 0, 255 ], "width": 0.75, "style": "esriSLSSolid", "type": "esriSLS" }, "color": [ 211, 255, 190, 255 ], "size": 4, "yoffset": 0, "xoffset": 0, "angle": 0, "style": "esriSMSCircle", "type": "esriSMS" }, "type": "simple" }, "transparency": 0 }, "copyrightText": "", "zDefault": 0, "geometryType": "esriGeometryPoint", "supportsLayerOverrides": true }, { "isCoGoEnabled": false, "extent": { "ymin": 4020858.222175725, "xmin": -9035966.01476665, "ymax": 4046472.29294423, "xmax": -8996415.011216803, "spatialReference": { "falseM": -100000, "xyTolerance": 0.001, "mUnits": 10000, "zUnits": 10000, "latestWkid": 3857, "zTolerance": 0.001, "wkid": 102100, "xyUnits": 1.4892314192838538E8, "mTolerance": 0.001, "falseX": -20037700, "falseY": -30241100, "falseZ": -100000 } }, "isDataBranchVersioned": false, "supportedContingentValuesFormats": "JSON, PBF", "supportsApplyEditsWithGlobalIds": true, "maxRecordCount": 2000, "infoInEstimates": [ "extent", "count" ], "type": "Feature Layer", "onlyAllowTrueCurveUpdatesByTrueCurveClients": true, "syncEnabled": true, "supportsAttachmentsByUploadId": true, "relationships": [ { "keyField": "facilityid", "role": "esriRelRoleOrigin", "composite": false, "name": "swNodesCondition", "relatedTableId": 9, "id": 2, "cardinality": "esriRelCardinalityOneToMany" } ], "supportsAttachmentsResizing": true, "cimVersion": "2.6.0", "isDataArchived": false, "id": 2, "supportsStatistics": true, "supportedExportFormats": "sqlite,filegdb,shapefile,csv,geojson", "standardMaxRecordCount": 16000, "isDataVersioned": false, "templates": [ { "name": "swNetworkStructure", "description": "", "drawingTool": "esriFeatureEditToolPoint", "prototype": { "symbol": null, "_constructed": true, "attributes": { "maintainedby": 1, "facilityid": null, "facilityidindex": null, "installdate": null, "outfall": null, "invertdepth": null, "northing": null, "enabled": 1, "lifecyclestatus": "Active", "reasonforstub": null, "gpsdate": null, "ownedby": 1, "elevation": null, "accesstype": null, "comments": null, "easting": null, "structuretype": null, "stubpt": null, "centerelev": null, "ancillaryrole": null, "additionalpipe": null, "structurematerial": null, "activeflag": null, "subwatershed": null, "structuredepth": null, "datasource": null, "flowpresent": null, "gpswho": null, "legacyid": null, "location": null } } } ], "hasGeometryProperties": true, "supportsAdvancedQueries": true, "parentLayer": null, "currentVersion": 11.2, "canScaleSymbols": false, "hasZ": false, "advancedEditingCapabilities": { "supportsAsyncApplyEdits": true, "supportsApplyEditsbyUploadID": true, "supportsReturnEditResults": true, "supportedSqlFormatsInCalculate": [ "standard" ], "supportedApplyEditsUploadIDFormats": "JSON" }, "objectIdField": "objectid", "supportsQuantizationEditMode": true, "hasContingentValuesDefinition": true, "name": "swNetworkStructure", "allowTrueCurvesUpdates": false, "displayField": "facilityid", "supportsCalculate": true, "fields": [ { "nullable": false, "defaultValue": null, "editable": false, "length": 4, "type": "esriFieldTypeOID", "modelName": "System-maintained ObjectID", "domain": null, "name": "objectid", "alias": "OBJECTID" }, { "modelName": "FACILITYID", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "facilityid", "length": 25, "alias": "Facility ID", "type": "esriFieldTypeString" }, { "modelName": "FACILITYIDINDEX", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "facilityidindex", "alias": "Facility ID Index", "type": "esriFieldTypeInteger" }, { "modelName": "LEGACYID", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "legacyid", "length": 25, "alias": "Legacy ID", "type": "esriFieldTypeString" }, { "modelName": "INSTALLDATE", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "precision": 1, "name": "installdate", "length": 29, "alias": "Install Date", "type": "esriFieldTypeDate" }, { "modelName": "STRUCTURETYPE", "nullable": true, "editable": true, "defaultValue": null, "domain": { "splitPolicy": "esriSPTDefaultValue", "name": "swNetworkStructureType_11", "description": "Stormwater network structure types", "type": "codedValue", "codedValues": [ { "code": "Blind Junction", "name": "Blind Junction" }, { "code": "Diversion Box", "name": "Diversion Box" }, { "code": "Junction Box", "name": "Junction Box" }, { "code": "Roof Drain", "name": "Roof Drain" }, { "code": "Cylindrical Manhole", "name": "Cylindrical Manhole" }, { "code": "Outlet Structure/Riser", "name": "Outlet Structure/Riser" }, { "code": "Virtual Junction", "name": "Virtual Junction" }, { "code": "Weir Structure", "name": "Weir Structure" }, { "code": "Other", "name": "Other" }, { "code": "Unknown", "name": "Unknown" } ], "mergePolicy": "esriMPTDefaultValue" }, "name": "structuretype", "length": 30, "alias": "Structure Type", "type": "esriFieldTypeString" }, { "modelName": "STRUCTUREMATERIAL", "nullable": true, "editable": true, "defaultValue": null, "domain": { "splitPolicy": "esriSPTDefaultValue", "name": "swConstType_12", "description": "Inlet constructioin type", "type": "codedValue", "codedValues": [ { "code": "Pre-Cast Concrete", "name": "Pre-Cast Concrete" }, { "code": "Brick", "name": "Brick" }, { "code": "Masonry", "name": "Masonry" }, { "code": "Hand-Poured Concrete", "name": "Hand-Poured Concrete" }, { "code": "Concrete & Brick", "name": "Concrete & Brick" }, { "code": "Other", "name": "Other" }, { "code": "Unknown", "name": "Unknown" } ], "mergePolicy": "esriMPTDefaultValue" }, "name": "structurematerial", "length": 20, "alias": "Structure Material", "type": "esriFieldTypeString" }, { "modelName": "STRUCTUREDEPTH", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "structuredepth", "alias": "Structure Center Depth", "type": "esriFieldTypeDouble" }, { "modelName": "ACCESSTYPE", "nullable": true, "editable": true, "defaultValue": null, "domain": { "splitPolicy": "esriSPTDefaultValue", "name": "swAccessType_10", "description": "List of infrastructure access types", "type": "codedValue", "codedValues": [ { "code": "Grate", "name": "Grate" }, { "code": "Manhole", "name": "Manhole" }, { "code": "No Access", "name": "No Access" }, { "code": "Other", "name": "Other" }, { "code": "Unknown", "name": "Unknown" } ], "mergePolicy": "esriMPTDefaultValue" }, "name": "accesstype", "length": 20, "alias": "Access Type", "type": "esriFieldTypeString" }, { "modelName": "SUBWATERSHED", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "subwatershed", "length": 50, "alias": "Subwatershed", "type": "esriFieldTypeString" }, { "modelName": "INVERTDEPTH", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "invertdepth", "alias": "Invert Depth", "type": "esriFieldTypeDouble" }, { "modelName": "STUBPT", "nullable": true, "editable": true, "defaultValue": null, "domain": { "splitPolicy": "esriSPTDefaultValue", "name": "swStubPt", "description": "Is the feature a Stub Point", "type": "codedValue", "codedValues": [ { "code": "Stub Point", "name": "Stub Point" }, { "code": "N/A", "name": "N/A" } ], "mergePolicy": "esriMPTDefaultValue" }, "name": "stubpt", "length": 30, "alias": "Stub Point", "type": "esriFieldTypeString" }, { "modelName": "REASONFORSTUB", "nullable": true, "editable": true, "defaultValue": null, "domain": { "splitPolicy": "esriSPTDefaultValue", "name": "swReasonForStub_12", "description": "Why the feature is tagged as a Stub Point", "type": "codedValue", "codedValues": [ { "code": "Edge of Basin", "name": "Edge of Basin" }, { "code": "Edge of Project Area", "name": "Edge of Project Area" }, { "code": "Inaccessible", "name": "Inaccessible" }, { "code": "Not Found", "name": "Not Found" }, { "code": "Private or Commercial", "name": "Private or Commercial" }, { "code": "Paved Over", "name": "Paved Over" }, { "code": "Abandoned", "name": "Abandoned" }, { "code": "Other", "name": "Other" } ], "mergePolicy": "esriMPTDefaultValue" }, "name": "reasonforstub", "length": 255, "alias": "Reason For Stub Point", "type": "esriFieldTypeString" }, { "modelName": "FLOWPRESENT", "nullable": true, "editable": true, "defaultValue": null, "domain": { "splitPolicy": "esriSPTDefaultValue", "name": "swFlowDescription_1", "description": "A list of different flow descriptions.", "type": "codedValue", "codedValues": [ { "code": "D", "name": "Dry Flow Present" }, { "code": "N", "name": "No Dry Weather Flow" }, { "code": "P", "name": "Perennial Waterbody" } ], "mergePolicy": "esriMPTDefaultValue" }, "name": "flowpresent", "length": 50, "alias": "Flow Present", "type": "esriFieldTypeString" }, { "modelName": "OUTFALL", "nullable": true, "editable": true, "defaultValue": null, "domain": { "splitPolicy": "esriSPTDefaultValue", "name": "YesNo_22", "description": "A yes/no indicator", "type": "codedValue", "codedValues": [ { "code": "Y", "name": "Yes" }, { "code": "N", "name": "No" } ], "mergePolicy": "esriMPTDefaultValue" }, "name": "outfall", "length": 50, "alias": "Outfall", "type": "esriFieldTypeString" }, { "modelName": "LIFECYCLESTATUS", "nullable": true, "editable": true, "defaultValue": "Active", "domain": { "splitPolicy": "esriSPTDefaultValue", "name": "swLifeCycleStatus", "description": "Life cycle status of the asset", "type": "codedValue", "codedValues": [ { "code": "Active", "name": "Active" }, { "code": "Inactive", "name": "Inactive" }, { "code": "Proposed", "name": "Proposed" }, { "code": "Abandoned", "name": "Abandoned" }, { "code": "Removed", "name": "Removed" }, { "code": "Deleted/DNE", "name": "Deleted/DNE" } ], "mergePolicy": "esriMPTDefaultValue" }, "name": "lifecyclestatus", "length": 25, "alias": "Life Cycle Status", "type": "esriFieldTypeString" }, { "modelName": "ACTIVEFLAG", "nullable": true, "editable": true, "defaultValue": null, "domain": { "splitPolicy": "esriSPTDuplicate", "name": "BooleanDomain_6", "description": "A 0/1 boolean domain", "type": "codedValue", "codedValues": [ { "code": 0, "name": "False" }, { "code": 1, "name": "True" } ], "mergePolicy": "esriMPTDefaultValue" }, "name": "activeflag", "alias": "Active Flag", "type": "esriFieldTypeSmallInteger" }, { "modelName": "OWNEDBY", "nullable": true, "editable": true, "defaultValue": 1, "domain": { "splitPolicy": "esriSPTDefaultValue", "name": "swAssetOwner", "description": "The owner of the asset", "type": "codedValue", "codedValues": [ { "code": 1, "name": "City of Columbia" }, { "code": 2, "name": "SCDOT" }, { "code": 3, "name": "Richland County" }, { "code": 4, "name": "Lexington County" }, { "code": 5, "name": "USC" }, { "code": 6, "name": "Federal" }, { "code": 0, "name": "Joint Ownership" }, { "code": -1, "name": "Private" }, { "code": -2, "name": "Unknown" } ], "mergePolicy": "esriMPTDefaultValue" }, "name": "ownedby", "alias": "Owned By", "type": "esriFieldTypeSmallInteger" }, { "modelName": "MAINTAINEDBY", "nullable": true, "editable": true, "defaultValue": 1, "domain": { "splitPolicy": "esriSPTDefaultValue", "name": "swAssetManager", "description": "The manager of the asset", "type": "codedValue", "codedValues": [ { "code": 1, "name": "City of Columbia" }, { "code": 2, "name": "SCDOT" }, { "code": 3, "name": "Richland County" }, { "code": 4, "name": "Lexington County" }, { "code": 5, "name": "USC" }, { "code": 6, "name": "Federal" }, { "code": 0, "name": "Joint Ownership" }, { "code": -1, "name": "Private" }, { "code": -2, "name": "Unknown" } ], "mergePolicy": "esriMPTDefaultValue" }, "name": "maintainedby", "alias": "Maintained By", "type": "esriFieldTypeSmallInteger" }, { "modelName": "LOCATION", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "location", "length": 250, "alias": "Location Description", "type": "esriFieldTypeString" }, { "modelName": "COMMENTS", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "comments", "length": 250, "alias": "Comments", "type": "esriFieldTypeString" }, { "modelName": "DATASOURCE", "nullable": true, "editable": true, "defaultValue": null, "domain": { "splitPolicy": "esriSPTDefaultValue", "name": "swDataSource", "description": "Source of the data", "type": "codedValue", "codedValues": [ { "code": "ASB", "name": "Asbuilt/Record Drawing" }, { "code": "DES", "name": "Design Drawing" }, { "code": "IMG", "name": "Imagery" }, { "code": "MAPGPS", "name": "Mapping Grade GPS" }, { "code": "SURVGPS", "name": "Survey Grade GPS" }, { "code": "FLD", "name": "Field Survey" }, { "code": "SC", "name": "Service Card" }, { "code": "TC", "name": "Tap Card" }, { "code": "PLAT", "name": "Plat" }, { "code": "DEED", "name": "Deed" }, { "code": "AUTO", "name": "Auto Generated" }, { "code": "OTH", "name": "Other" }, { "code": "UNK", "name": "Unknown" } ], "mergePolicy": "esriMPTDefaultValue" }, "name": "datasource", "length": 25, "alias": "Data Source", "type": "esriFieldTypeString" }, { "modelName": "LASTEDITOR", "nullable": true, "editable": false, "defaultValue": null, "domain": null, "name": "lasteditor", "length": 50, "alias": "Last Editor", "type": "esriFieldTypeString" }, { "modelName": "LASTUPDATE", "nullable": true, "editable": false, "defaultValue": null, "domain": null, "precision": 1, "name": "lastupdate", "length": 29, "alias": "Last Update Date", "type": "esriFieldTypeDate" }, { "modelName": "CREATOR", "nullable": true, "editable": false, "defaultValue": null, "domain": null, "name": "creator", "length": 50, "alias": "Creator", "type": "esriFieldTypeString" }, { "modelName": "CREATIONDATE", "nullable": true, "editable": false, "defaultValue": null, "domain": null, "precision": 1, "name": "creationdate", "length": 29, "alias": "Creation Date", "type": "esriFieldTypeDate" }, { "modelName": "GPSWHO", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "gpswho", "length": 50, "alias": "GPS Who", "type": "esriFieldTypeString" }, { "modelName": "GPSDATE", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "precision": 1, "name": "gpsdate", "length": 29, "alias": "GPS Date", "type": "esriFieldTypeDate" }, { "modelName": "NORTHING", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "northing", "alias": "Northing", "type": "esriFieldTypeDouble" }, { "modelName": "EASTING", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "easting", "alias": "Easting", "type": "esriFieldTypeDouble" }, { "modelName": "ELEVATION", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "elevation", "alias": "Surveyed Elevation", "type": "esriFieldTypeDouble" }, { "modelName": "ENABLED", "nullable": true, "editable": true, "defaultValue": 1, "domain": { "splitPolicy": "esriSPTDefaultValue", "name": "EnabledDomain_9", "description": "Geometric Network Enabled domain", "type": "codedValue", "codedValues": [ { "code": 0, "name": "False" }, { "code": 1, "name": "True" } ], "mergePolicy": "esriMPTDefaultValue" }, "name": "enabled", "alias": "Enabled", "type": "esriFieldTypeSmallInteger" }, { "modelName": "ANCILLARYROLE", "nullable": true, "editable": true, "defaultValue": null, "domain": { "splitPolicy": "esriSPTDefaultValue", "name": "AncillaryRoleDomain_1", "description": "", "type": "codedValue", "codedValues": [ { "code": "None", "name": "None" }, { "code": "Source", "name": "Source" }, { "code": "Sink", "name": "Sink" } ], "mergePolicy": "esriMPTDefaultValue" }, "name": "ancillaryrole", "length": 10, "alias": "Ancillary Role", "type": "esriFieldTypeString" }, { "modelName": "ADDITIONALPIPE", "nullable": true, "editable": true, "defaultValue": null, "domain": { "splitPolicy": "esriSPTDefaultValue", "name": "YesNo_22", "description": "A yes/no indicator", "type": "codedValue", "codedValues": [ { "code": "Y", "name": "Yes" }, { "code": "N", "name": "No" } ], "mergePolicy": "esriMPTDefaultValue" }, "name": "additionalpipe", "length": 50, "alias": "Additional Pipes Present", "type": "esriFieldTypeString" }, { "modelName": "CENTERELEV", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "centerelev", "alias": "Structure Center Elevation", "type": "esriFieldTypeDouble" }, { "nullable": false, "editable": false, "defaultValue": null, "domain": null, "name": "globalid", "length": 38, "alias": "globalid", "type": "esriFieldTypeGlobalID" } ], "maxRecordCountFactor": 1, "dateFieldsTimeReference": { "respectsDaylightSaving": false, "timeZone": "UTC" }, "supportsFieldDescriptionProperty": true, "hasM": false, "allowGeometryUpdates": true, "useStandardizedQueries": true, "globalIdField": "globalid", "description": "", "syncCanReturnChanges": true, "supportsAsyncDelete": true, "supportedSpatialRelationships": [ "esriSpatialRelIntersects", "esriSpatialRelContains", "esriSpatialRelCrosses", "esriSpatialRelEnvelopeIntersects", "esriSpatialRelOverlaps", "esriSpatialRelTouches", "esriSpatialRelWithin" ], "supportsRollbackOnFailureParameter": true, "isDataReplicaTracked": false, "standardMaxRecordCountNoGeometry": 16000, "supportsTruncate": true, "indexes": [ { "name": "g14077facilityid", "isUnique": false, "description": "", "fields": "facilityid", "isAscending": true }, { "name": "r4644_sde_rowid_uk", "isUnique": true, "description": "", "fields": "objectid", "isAscending": true }, { "name": "a3852_ix1", "isUnique": true, "description": "", "fields": "shape", "isAscending": true }, { "name": "uuid_4644", "isUnique": true, "description": "", "fields": "globalid", "isAscending": true } ], "editFieldsInfo": { "editDateField": "lastupdate", "editorField": "lasteditor", "creationDateField": "creationdate", "creatorField": "creator" }, "htmlPopupType": "esriServerHTMLPopupTypeAsHTMLText", "minScale": 9028, "hasAttachments": false, "advancedQueryCapabilities": { "supportsSqlExpression": true, "supportsQueryWithResultType": true, "supportsQueryRelatedPagination": true, "supportsQueryWithCacheHint": false, "supportsQueryWithDatumTransformation": true, "supportsQueryNumericBins": false, "supportsCurrentUserQueries": true, "supportsQueryAttachmentsWithReturnUrl": true, "supportsQueryDateBins": false, "supportsQueryWithLodSR": true, "supportsPaginationOnAggregatedQueries": true, "supportsPagination": true, "supportsMaxRecordCountFactor": true, "supportsStatistics": true, "supportsOrderBy": true, "supportsQueryWithDistance": true, "supportsLod": true, "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": "c8ab64fd58ae41f79bb4b326233d89e9", "allowUpdateWithoutMValues": true, "supportsCoordinatesQuantization": true, "types": [], "capabilities": "Query,Sync", "maxScale": 0, "supportsAppend": true, "supportsExceedsLimitStatistics": true, "defaultVisibility": true, "advancedQueryAnalyticCapabilities": { "supportsAsync": true, "supportsLinearRegression": true, "supportsPercentileAnalytic": false }, "hasMetadata": true, "supportedAppendFormats": "shapefile,geojson,csv,featureCollection,excel,jsonl", "tileMaxRecordCount": 4000, "typeIdField": "", "supportsASyncCalculate": true, "supportedQueryFormats": "JSON, geoJSON, PBF", "sqlParserVersion": "PG_11.2.0", "drawingInfo": { "renderer": { "symbol": { "outline": { "color": [ 0, 0, 0, 255 ], "width": 0.75, "style": "esriSLSSolid", "type": "esriSLS" }, "color": [ 173, 173, 173, 255 ], "size": 4, "yoffset": 0, "xoffset": 0, "angle": 0, "style": "esriSMSCircle", "type": "esriSMS" }, "type": "simple" }, "transparency": 0 }, "copyrightText": "", "zDefault": 0, "geometryType": "esriGeometryPoint", "supportsLayerOverrides": true }, { "isCoGoEnabled": false, "extent": { "ymin": 4020327.2048199847, "xmin": -9035966.01476665, "ymax": 4056729.03051091, "xmax": -8996280.711903412, "spatialReference": { "falseM": -100000, "xyTolerance": 0.001, "mUnits": 10000, "zUnits": 10000, "latestWkid": 3857, "zTolerance": 0.001, "wkid": 102100, "xyUnits": 1.4892314192838538E8, "mTolerance": 0.001, "falseX": -20037700, "falseY": -30241100, "falseZ": -100000 } }, "isDataBranchVersioned": false, "supportedContingentValuesFormats": "JSON, PBF", "supportsApplyEditsWithGlobalIds": true, "maxRecordCount": 2000, "infoInEstimates": [ "extent", "count" ], "type": "Feature Layer", "onlyAllowTrueCurveUpdatesByTrueCurveClients": true, "syncEnabled": true, "supportsAttachmentsByUploadId": true, "relationships": [ { "keyField": "facilityid", "role": "esriRelRoleOrigin", "composite": false, "name": "swConveyanceCondition", "relatedTableId": 8, "id": 3, "cardinality": "esriRelCardinalityOneToMany" } ], "supportsAttachmentsResizing": true, "cimVersion": "2.6.0", "isDataArchived": false, "id": 3, "supportsStatistics": true, "supportedExportFormats": "sqlite,filegdb,shapefile,csv,geojson", "standardMaxRecordCount": 2000, "isDataVersioned": false, "templates": [ { "name": "swDrainPipe", "description": "", "drawingTool": "esriFeatureEditToolLine", "prototype": { "symbol": null, "_constructed": true, "attributes": { "maintainedby": -2, "facilityid": null, "installdate": null, "dsnodeid": null, "enabled": 1, "lifecyclestatus": "Active", "dnnorthing": null, "upinvelev": null, "diameter": null, "mainshape": null, "closeddischnum": null, "facilityindex": null, "usinvertdepth": null, "dneasting": null, "dsinvertdepth": null, "gpsdate": null, "draintype": null, "ownedby": -2, "height": null, "comments": null, "upnorthing": null, "slope": null, "usnodeid": null, "downelev": null, "activeflag": null, "integrationstatus": null, "subwatershed": null, "dninvelev": null, "upelev": null, "material": null, "datasource": null, "flowpresent": null, "gpswho": null, "width": null, "legacyid": null, "location": null, "upeasting": null } } } ], "hasGeometryProperties": true, "supportsAdvancedQueries": true, "parentLayer": null, "currentVersion": 11.2, "canScaleSymbols": false, "hasZ": false, "advancedEditingCapabilities": { "supportsAsyncApplyEdits": true, "supportsApplyEditsbyUploadID": true, "supportsReturnEditResults": true, "supportedSqlFormatsInCalculate": [ "standard" ], "supportedApplyEditsUploadIDFormats": "JSON" }, "objectIdField": "objectid", "supportsQuantizationEditMode": true, "hasContingentValuesDefinition": true, "name": "swDrainPipe", "allowTrueCurvesUpdates": false, "displayField": "facilityid", "supportsCalculate": true, "fields": [ { "nullable": false, "defaultValue": null, "editable": false, "length": 4, "type": "esriFieldTypeOID", "modelName": "System-maintained ObjectID", "domain": null, "name": "objectid", "alias": "OBJECTID" }, { "modelName": "FACILITYID", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "facilityid", "length": 25, "alias": "Facility ID", "type": "esriFieldTypeString" }, { "modelName": "FACILITYINDEX", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "facilityindex", "alias": "Facility ID Index", "type": "esriFieldTypeInteger" }, { "modelName": "USNODEID", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "usnodeid", "length": 50, "alias": "From Node", "type": "esriFieldTypeString" }, { "modelName": "DSNODEID", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "dsnodeid", "length": 50, "alias": "To Node", "type": "esriFieldTypeString" }, { "modelName": "LEGACYID", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "legacyid", "length": 25, "alias": "Legacy ID", "type": "esriFieldTypeString" }, { "modelName": "DRAINTYPE", "nullable": true, "editable": true, "defaultValue": null, "domain": { "splitPolicy": "esriSPTDefaultValue", "name": "swDrainType", "description": "Type of drain pipe", "type": "codedValue", "codedValues": [ { "code": "Pipe", "name": "Pipe" }, { "code": "Culvert", "name": "Culvert" }, { "code": "Other", "name": "Other" }, { "code": "Unknown", "name": "Unknown" } ], "mergePolicy": "esriMPTDefaultValue" }, "name": "draintype", "length": 50, "alias": "DrainType", "type": "esriFieldTypeString" }, { "modelName": "INSTALLDATE", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "precision": 1, "name": "installdate", "length": 29, "alias": "Install Date", "type": "esriFieldTypeDate" }, { "modelName": "MATERIAL", "nullable": true, "editable": true, "defaultValue": null, "domain": { "splitPolicy": "esriSPTDefaultValue", "name": "swPipeMaterial", "description": "The list of pipe materials types based on the NASSCO standards", "type": "codedValue", "codedValues": [ { "code": "ABS", "name": "ABS Plastic" }, { "code": "AC", "name": "Asbestos Cement" }, { "code": "ASP", "name": "Asphalt" }, { "code": "BR", "name": "Brick" }, { "code": "BMP", "name": "Brick Masonry" }, { "code": "CAS", "name": "Cast Iron" }, { "code": "CT", "name": "Clay Tile" }, { "code": "CDB", "name": "Cinderblock" }, { "code": "CP", "name": "Concrete (Non-Reinforced)" }, { "code": "CSB", "name": "Concrete Segments (Bolted)" }, { "code": "CSU", "name": "Concrete Segments (Unbolted)" }, { "code": "CNB", "name": "Concrete & Brick" }, { "code": "CMP", "name": "Corrugated Metal" }, { "code": "COP", "name": "Copper" }, { "code": "CIPP", "name": "Cured In Place" }, { "code": "DIP", "name": "Ductile Iron" }, { "code": "FRP", "name": "Fiberglass Reinforced" }, { "code": "EARGEO", "name": "Earth & Geotextile" }, { "code": "EAR", "name": "Earthen" }, { "code": "GEO", "name": "Geotextile" }, { "code": "GP", "name": "Galvanized Pipe" }, { "code": "GRC", "name": "Glass Reinforced Cement" }, { "code": "HDPE", "name": "High Density Polyethylene" }, { "code": "OB", "name": "Pitch Fiber (Orangeburg)" }, { "code": "PSC", "name": "Plastic/Steel Composite" }, { "code": "PE", "name": "Polyethylene" }, { "code": "PP", "name": "Polypropylene" }, { "code": "PVC", "name": "Polyvinyl Chloride" }, { "code": "PCCP", "name": "Pre-Stressed Concrete Cylinder" }, { "code": "RCP", "name": "Reinforced Concrete" }, { "code": "RPM", "name": "Reinforced Plastic (Truss)" }, { "code": "RIP", "name": "Rip Rap" }, { "code": "SB", "name": "Segmented Block" }, { "code": "SP", "name": "Steel" }, { "code": "TTE", "name": "Transite" }, { "code": "VCP", "name": "Vitrified Clay" }, { "code": "WD", "name": "Wood" }, { "code": "OTH", "name": "Other" }, { "code": "UNK", "name": "Unknown" } ], "mergePolicy": "esriMPTDefaultValue" }, "name": "material", "length": 50, "alias": "Material", "type": "esriFieldTypeString" }, { "modelName": "DIAMETER", "nullable": true, "editable": true, "defaultValue": null, "domain": { "splitPolicy": "esriSPTDuplicate", "name": "swPipeDiameter", "description": "A list of pipe diameters", "type": "codedValue", "codedValues": [ { "code": 6, "name": "6\"" }, { "code": 8, "name": "8\"" }, { "code": 10, "name": "10\"" }, { "code": 12, "name": "12\"" }, { "code": 15, "name": "15\"" }, { "code": 18, "name": "18\"" }, { "code": 21, "name": "21\"" }, { "code": 24, "name": "24\"" }, { "code": 30, "name": "30\"" }, { "code": 36, "name": "36\"" }, { "code": 42, "name": "42\"" }, { "code": 48, "name": "48\"" }, { "code": 54, "name": "54\"" }, { "code": 60, "name": "60\"" }, { "code": 66, "name": "66\"" }, { "code": 72, "name": "72\"" }, { "code": 78, "name": "78\"" }, { "code": 84, "name": "84\"" }, { "code": 90, "name": "90\"" }, { "code": 96, "name": "96\"" }, { "code": 102, "name": "102\"" }, { "code": 110, "name": "110\"" }, { "code": 114, "name": "114\"" }, { "code": 120, "name": "120\"" }, { "code": 126, "name": "126\"" }, { "code": 132, "name": "132\"" }, { "code": 138, "name": "138\"" }, { "code": 144, "name": "144\"" }, { "code": -1, "name": "Other" }, { "code": 0, "name": "Unknown" }, { "code": -3, "name": "N/A" } ], "mergePolicy": "esriMPTDefaultValue" }, "name": "diameter", "alias": "Diameter", "type": "esriFieldTypeDouble" }, { "modelName": "HEIGHT", "nullable": true, "editable": true, "defaultValue": null, "domain": { "splitPolicy": "esriSPTDuplicate", "name": "swPipeDiameter", "description": "A list of pipe diameters", "type": "codedValue", "codedValues": [ { "code": 6, "name": "6\"" }, { "code": 8, "name": "8\"" }, { "code": 10, "name": "10\"" }, { "code": 12, "name": "12\"" }, { "code": 15, "name": "15\"" }, { "code": 18, "name": "18\"" }, { "code": 21, "name": "21\"" }, { "code": 24, "name": "24\"" }, { "code": 30, "name": "30\"" }, { "code": 36, "name": "36\"" }, { "code": 42, "name": "42\"" }, { "code": 48, "name": "48\"" }, { "code": 54, "name": "54\"" }, { "code": 60, "name": "60\"" }, { "code": 66, "name": "66\"" }, { "code": 72, "name": "72\"" }, { "code": 78, "name": "78\"" }, { "code": 84, "name": "84\"" }, { "code": 90, "name": "90\"" }, { "code": 96, "name": "96\"" }, { "code": 102, "name": "102\"" }, { "code": 110, "name": "110\"" }, { "code": 114, "name": "114\"" }, { "code": 120, "name": "120\"" }, { "code": 126, "name": "126\"" }, { "code": 132, "name": "132\"" }, { "code": 138, "name": "138\"" }, { "code": 144, "name": "144\"" }, { "code": -1, "name": "Other" }, { "code": 0, "name": "Unknown" }, { "code": -3, "name": "N/A" } ], "mergePolicy": "esriMPTDefaultValue" }, "name": "height", "alias": "Height", "type": "esriFieldTypeDouble" }, { "modelName": "WIDTH", "nullable": true, "editable": true, "defaultValue": null, "domain": { "splitPolicy": "esriSPTDuplicate", "name": "swPipeDiameter", "description": "A list of pipe diameters", "type": "codedValue", "codedValues": [ { "code": 6, "name": "6\"" }, { "code": 8, "name": "8\"" }, { "code": 10, "name": "10\"" }, { "code": 12, "name": "12\"" }, { "code": 15, "name": "15\"" }, { "code": 18, "name": "18\"" }, { "code": 21, "name": "21\"" }, { "code": 24, "name": "24\"" }, { "code": 30, "name": "30\"" }, { "code": 36, "name": "36\"" }, { "code": 42, "name": "42\"" }, { "code": 48, "name": "48\"" }, { "code": 54, "name": "54\"" }, { "code": 60, "name": "60\"" }, { "code": 66, "name": "66\"" }, { "code": 72, "name": "72\"" }, { "code": 78, "name": "78\"" }, { "code": 84, "name": "84\"" }, { "code": 90, "name": "90\"" }, { "code": 96, "name": "96\"" }, { "code": 102, "name": "102\"" }, { "code": 110, "name": "110\"" }, { "code": 114, "name": "114\"" }, { "code": 120, "name": "120\"" }, { "code": 126, "name": "126\"" }, { "code": 132, "name": "132\"" }, { "code": 138, "name": "138\"" }, { "code": 144, "name": "144\"" }, { "code": -1, "name": "Other" }, { "code": 0, "name": "Unknown" }, { "code": -3, "name": "N/A" } ], "mergePolicy": "esriMPTDefaultValue" }, "name": "width", "alias": "Width", "type": "esriFieldTypeDouble" }, { "modelName": "MAINSHAPE", "nullable": true, "editable": true, "defaultValue": null, "domain": { "splitPolicy": "esriSPTDefaultValue", "name": "swPipeShape_10", "description": "NASSCO pipe shapes", "type": "codedValue", "codedValues": [ { "code": "A", "name": "Arched" }, { "code": "B", "name": "Barrel" }, { "code": "C", "name": "Circular" }, { "code": "E", "name": "Egg-shaped" }, { "code": "H", "name": "Horseshoe" }, { "code": "O", "name": "Oval" }, { "code": "Other", "name": "Other" }, { "code": "R", "name": "Rectangular" }, { "code": "S", "name": "Square" }, { "code": "T", "name": "Trapezoidal" }, { "code": "TRI", "name": "Triangular/V-Shape" }, { "code": "U", "name": "U-shaped with Flat Top" }, { "code": "Unknown", "name": "Unknown" } ], "mergePolicy": "esriMPTDefaultValue" }, "name": "mainshape", "length": 25, "alias": "Main Shape", "type": "esriFieldTypeString" }, { "modelName": "USINVERTDEPTH", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "usinvertdepth", "alias": "US Invert Depth", "type": "esriFieldTypeDouble" }, { "modelName": "DSINVERTDEPTH", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "dsinvertdepth", "alias": "DS Invert Depth", "type": "esriFieldTypeDouble" }, { "modelName": "SLOPE", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "slope", "alias": "Slope", "type": "esriFieldTypeDouble" }, { "modelName": "FLOWPRESENT", "nullable": true, "editable": true, "defaultValue": null, "domain": { "splitPolicy": "esriSPTDefaultValue", "name": "YesNo_22", "description": "A yes/no indicator", "type": "codedValue", "codedValues": [ { "code": "Y", "name": "Yes" }, { "code": "N", "name": "No" } ], "mergePolicy": "esriMPTDefaultValue" }, "name": "flowpresent", "length": 50, "alias": "Flow Present", "type": "esriFieldTypeString" }, { "modelName": "SUBWATERSHED", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "subwatershed", "length": 50, "alias": "Subwatershed", "type": "esriFieldTypeString" }, { "modelName": "LIFECYCLESTATUS", "nullable": true, "editable": true, "defaultValue": "Active", "domain": { "splitPolicy": "esriSPTDefaultValue", "name": "swLifeCycleStatus", "description": "Life cycle status of the asset", "type": "codedValue", "codedValues": [ { "code": "Active", "name": "Active" }, { "code": "Inactive", "name": "Inactive" }, { "code": "Proposed", "name": "Proposed" }, { "code": "Abandoned", "name": "Abandoned" }, { "code": "Removed", "name": "Removed" }, { "code": "Deleted/DNE", "name": "Deleted/DNE" } ], "mergePolicy": "esriMPTDefaultValue" }, "name": "lifecyclestatus", "length": 25, "alias": "Life Cycle Status", "type": "esriFieldTypeString" }, { "modelName": "ACTIVEFLAG", "nullable": true, "editable": true, "defaultValue": null, "domain": { "splitPolicy": "esriSPTDuplicate", "name": "BooleanDomain_6", "description": "A 0/1 boolean domain", "type": "codedValue", "codedValues": [ { "code": 0, "name": "False" }, { "code": 1, "name": "True" } ], "mergePolicy": "esriMPTDefaultValue" }, "name": "activeflag", "alias": "Active Flag", "type": "esriFieldTypeSmallInteger" }, { "modelName": "OWNEDBY", "nullable": true, "editable": true, "defaultValue": -2, "domain": { "splitPolicy": "esriSPTDefaultValue", "name": "swAssetOwner", "description": "The owner of the asset", "type": "codedValue", "codedValues": [ { "code": 1, "name": "City of Columbia" }, { "code": 2, "name": "SCDOT" }, { "code": 3, "name": "Richland County" }, { "code": 4, "name": "Lexington County" }, { "code": 5, "name": "USC" }, { "code": 6, "name": "Federal" }, { "code": 0, "name": "Joint Ownership" }, { "code": -1, "name": "Private" }, { "code": -2, "name": "Unknown" } ], "mergePolicy": "esriMPTDefaultValue" }, "name": "ownedby", "alias": "Owned By", "type": "esriFieldTypeSmallInteger" }, { "modelName": "MAINTAINEDBY", "nullable": true, "editable": true, "defaultValue": -2, "domain": { "splitPolicy": "esriSPTDefaultValue", "name": "swAssetManager", "description": "The manager of the asset", "type": "codedValue", "codedValues": [ { "code": 1, "name": "City of Columbia" }, { "code": 2, "name": "SCDOT" }, { "code": 3, "name": "Richland County" }, { "code": 4, "name": "Lexington County" }, { "code": 5, "name": "USC" }, { "code": 6, "name": "Federal" }, { "code": 0, "name": "Joint Ownership" }, { "code": -1, "name": "Private" }, { "code": -2, "name": "Unknown" } ], "mergePolicy": "esriMPTDefaultValue" }, "name": "maintainedby", "alias": "Maintained By", "type": "esriFieldTypeSmallInteger" }, { "modelName": "LOCATION", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "location", "length": 250, "alias": "Location Description", "type": "esriFieldTypeString" }, { "modelName": "COMMENTS", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "comments", "length": 250, "alias": "Comments", "type": "esriFieldTypeString" }, { "modelName": "DATASOURCE", "nullable": true, "editable": true, "defaultValue": null, "domain": { "splitPolicy": "esriSPTDefaultValue", "name": "swDataSource", "description": "Source of the data", "type": "codedValue", "codedValues": [ { "code": "ASB", "name": "Asbuilt/Record Drawing" }, { "code": "DES", "name": "Design Drawing" }, { "code": "IMG", "name": "Imagery" }, { "code": "MAPGPS", "name": "Mapping Grade GPS" }, { "code": "SURVGPS", "name": "Survey Grade GPS" }, { "code": "FLD", "name": "Field Survey" }, { "code": "SC", "name": "Service Card" }, { "code": "TC", "name": "Tap Card" }, { "code": "PLAT", "name": "Plat" }, { "code": "DEED", "name": "Deed" }, { "code": "AUTO", "name": "Auto Generated" }, { "code": "OTH", "name": "Other" }, { "code": "UNK", "name": "Unknown" } ], "mergePolicy": "esriMPTDefaultValue" }, "name": "datasource", "length": 25, "alias": "Data Source", "type": "esriFieldTypeString" }, { "modelName": "LASTEDITOR", "nullable": true, "editable": false, "defaultValue": null, "domain": null, "name": "lasteditor", "length": 50, "alias": "Last Editor", "type": "esriFieldTypeString" }, { "modelName": "LASTUPDATE", "nullable": true, "editable": false, "defaultValue": null, "domain": null, "precision": 1, "name": "lastupdate", "length": 29, "alias": "Last Update Date", "type": "esriFieldTypeDate" }, { "modelName": "CREATOR", "nullable": true, "editable": false, "defaultValue": null, "domain": null, "name": "creator", "length": 50, "alias": "Creator", "type": "esriFieldTypeString" }, { "modelName": "CREATIONDATE", "nullable": true, "editable": false, "defaultValue": null, "domain": null, "precision": 1, "name": "creationdate", "length": 29, "alias": "Creation Date", "type": "esriFieldTypeDate" }, { "modelName": "GPSWHO", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "gpswho", "length": 50, "alias": "GPS Who", "type": "esriFieldTypeString" }, { "modelName": "GPSDATE", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "precision": 1, "name": "gpsdate", "length": 29, "alias": "GPS Date", "type": "esriFieldTypeDate" }, { "modelName": "UPNORTHING", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "upnorthing", "alias": "Upstream Northing", "type": "esriFieldTypeDouble" }, { "modelName": "UPEASTING", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "upeasting", "alias": "Upstream Easting", "type": "esriFieldTypeDouble" }, { "modelName": "DNNORTHING", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "dnnorthing", "alias": "Downstream Northing", "type": "esriFieldTypeDouble" }, { "modelName": "DNEASTING", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "dneasting", "alias": "Downstream Easting", "type": "esriFieldTypeDouble" }, { "modelName": "UPELEV", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "upelev", "alias": "Upstream Surveyed Elevation", "type": "esriFieldTypeDouble" }, { "modelName": "DOWNELEV", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "downelev", "alias": "Downstream Surveyed Elevation", "type": "esriFieldTypeDouble" }, { "modelName": "UPINVELEV", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "upinvelev", "alias": "Upstream Pipe Invert Elevation", "type": "esriFieldTypeDouble" }, { "modelName": "DNINVELEV", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "dninvelev", "alias": "Downstream Pipe Invert Elevation", "type": "esriFieldTypeDouble" }, { "modelName": "ENABLED", "nullable": true, "editable": true, "defaultValue": 1, "domain": { "splitPolicy": "esriSPTDefaultValue", "name": "EnabledDomain_9", "description": "Geometric Network Enabled domain", "type": "codedValue", "codedValues": [ { "code": 0, "name": "False" }, { "code": 1, "name": "True" } ], "mergePolicy": "esriMPTDefaultValue" }, "name": "enabled", "alias": "Enabled", "type": "esriFieldTypeSmallInteger" }, { "modelName": "CLOSEDDISCHNUM", "nullable": true, "editable": true, "defaultValue": null, "domain": { "splitPolicy": "esriSPTDefaultValue", "name": "swDischNumber_10", "description": "A number of shapes at a given closed pipe outfall.", "type": "codedValue", "codedValues": [ { "code": "D", "name": "Double" }, { "code": "Other", "name": "Other" }, { "code": "S", "name": "Single" }, { "code": "T", "name": "Triple" } ], "mergePolicy": "esriMPTDefaultValue" }, "name": "closeddischnum", "length": 5, "alias": "Closed Discharge Number", "type": "esriFieldTypeString" }, { "modelName": "INTEGRATIONSTATUS", "nullable": true, "editable": true, "defaultValue": null, "domain": { "splitPolicy": "esriSPTDefaultValue", "name": "YesNo_22", "description": "A yes/no indicator", "type": "codedValue", "codedValues": [ { "code": "Y", "name": "Yes" }, { "code": "N", "name": "No" } ], "mergePolicy": "esriMPTDefaultValue" }, "name": "integrationstatus", "length": 255, "alias": "Integration Status", "type": "esriFieldTypeString" }, { "virtual": true, "nullable": true, "editable": false, "defaultValue": null, "domain": null, "name": "SHAPE__Length", "alias": "SHAPE__Length", "type": "esriFieldTypeDouble" }, { "nullable": false, "editable": false, "defaultValue": null, "domain": null, "name": "globalid", "length": 38, "alias": "globalid", "type": "esriFieldTypeGlobalID" } ], "maxRecordCountFactor": 1, "dateFieldsTimeReference": { "respectsDaylightSaving": false, "timeZone": "UTC" }, "supportsFieldDescriptionProperty": true, "hasM": false, "allowGeometryUpdates": true, "useStandardizedQueries": true, "globalIdField": "globalid", "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": "g14074facilityid", "isUnique": false, "description": "", "fields": "facilityid", "isAscending": true }, { "name": "i14074facilityin", "isUnique": false, "description": "", "fields": "facilityindex", "isAscending": true }, { "name": "r4641_sde_rowid_uk", "isUnique": true, "description": "", "fields": "objectid", "isAscending": true }, { "name": "a3849_ix1", "isUnique": true, "description": "", "fields": "shape", "isAscending": true }, { "name": "uuid_4641", "isUnique": true, "description": "", "fields": "globalid", "isAscending": true } ], "editFieldsInfo": { "editDateField": "lastupdate", "editorField": "lasteditor", "creationDateField": "creationdate", "creatorField": "creator" }, "htmlPopupType": "esriServerHTMLPopupTypeAsHTMLText", "minScale": 9028, "hasAttachments": false, "advancedQueryCapabilities": { "supportsSqlExpression": true, "supportsQueryWithResultType": true, "supportsQueryRelatedPagination": true, "supportsQueryWithCacheHint": false, "supportsQueryWithDatumTransformation": true, "supportsQueryNumericBins": false, "supportsCurrentUserQueries": true, "supportsQueryAttachmentsWithReturnUrl": true, "supportsQueryDateBins": false, "supportsQueryWithLodSR": true, "supportsPaginationOnAggregatedQueries": true, "supportsPagination": true, "supportsMaxRecordCountFactor": true, "supportsStatistics": true, "supportsOrderBy": true, "supportsReturningGeometryProperties": true, "supportsQueryWithDistance": true, "supportsLod": true, "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": "c8ab64fd58ae41f79bb4b326233d89e9", "allowUpdateWithoutMValues": true, "supportsCoordinatesQuantization": true, "types": [], "capabilities": "Query,Sync", "maxScale": 0, "supportsAppend": true, "supportsExceedsLimitStatistics": true, "defaultVisibility": true, "advancedQueryAnalyticCapabilities": { "supportsAsync": true, "supportsLinearRegression": true, "supportsPercentileAnalytic": false }, "hasMetadata": true, "supportedAppendFormats": "shapefile,geojson,csv,featureCollection,excel,jsonl", "tileMaxRecordCount": 2000, "typeIdField": "", "supportsASyncCalculate": true, "supportedQueryFormats": "JSON, geoJSON, PBF", "sqlParserVersion": "PG_11.2.0", "drawingInfo": { "renderer": { "symbol": { "color": [ 0, 121, 173, 255 ], "width": 0.75, "style": "esriSLSSolid", "type": "esriSLS" }, "type": "simple" }, "transparency": 0 }, "copyrightText": "", "zDefault": 0, "geometryType": "esriGeometryPolyline", "supportsLayerOverrides": true }, { "isCoGoEnabled": false, "extent": { "ymin": 4023155.8435531408, "xmin": -9025950.684691025, "ymax": 4037609.558748156, "xmax": -9009994.87452723, "spatialReference": { "falseM": -100000, "xyTolerance": 0.001, "mUnits": 10000, "zUnits": 10000, "latestWkid": 3857, "zTolerance": 0.001, "wkid": 102100, "xyUnits": 1.4892314192838538E8, "mTolerance": 0.001, "falseX": -20037700, "falseY": -30241100, "falseZ": -100000 } }, "isDataBranchVersioned": false, "supportedContingentValuesFormats": "JSON, PBF", "supportsApplyEditsWithGlobalIds": true, "maxRecordCount": 2000, "infoInEstimates": [ "extent", "count" ], "type": "Feature Layer", "onlyAllowTrueCurveUpdatesByTrueCurveClients": true, "syncEnabled": true, "supportsAttachmentsByUploadId": true, "relationships": [], "supportsAttachmentsResizing": true, "cimVersion": "2.6.0", "isDataArchived": false, "id": 4, "supportsStatistics": true, "supportedExportFormats": "sqlite,filegdb,shapefile,csv,geojson", "standardMaxRecordCount": 2000, "isDataVersioned": false, "templates": [ { "name": "swNaturalWaterbody", "description": "", "drawingTool": "esriFeatureEditToolPolygon", "prototype": { "symbol": null, "_constructed": true, "attributes": { "maintainedby": 1, "facilityid": null, "facilityidindex": null, "installdate": null, "comments": null, "waterbodytype": null, "waterbodywidth": null, "enabled": 1, "activeflag": null, "lifecyclestatus": "Active", "waterbodydepth": null, "subwatershed": null, "datasource": null, "gpswho": null, "legacyid": null, "location": null, "gpsdate": null, "ownedby": 1, "pondid": null } } } ], "hasGeometryProperties": true, "supportsAdvancedQueries": true, "parentLayer": null, "currentVersion": 11.2, "canScaleSymbols": false, "hasZ": false, "advancedEditingCapabilities": { "supportsAsyncApplyEdits": true, "supportsApplyEditsbyUploadID": true, "supportsReturnEditResults": true, "supportedSqlFormatsInCalculate": [ "standard" ], "supportedApplyEditsUploadIDFormats": "JSON" }, "objectIdField": "objectid", "supportsQuantizationEditMode": true, "hasContingentValuesDefinition": true, "name": "swNaturalWaterbody", "allowTrueCurvesUpdates": false, "displayField": "facilityid", "supportsCalculate": true, "fields": [ { "nullable": false, "defaultValue": null, "editable": false, "length": 4, "type": "esriFieldTypeOID", "modelName": "System-maintained ObjectID", "domain": null, "name": "objectid", "alias": "OBJECTID" }, { "modelName": "FACILITYID", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "facilityid", "length": 25, "alias": "Facility ID", "type": "esriFieldTypeString" }, { "modelName": "FACILITYIDINDEX", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "facilityidindex", "alias": "Facility ID Index", "type": "esriFieldTypeInteger" }, { "modelName": "LEGACYID", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "legacyid", "length": 25, "alias": "Legacy ID", "type": "esriFieldTypeString" }, { "modelName": "INSTALLDATE", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "precision": 1, "name": "installdate", "length": 29, "alias": "Install Date", "type": "esriFieldTypeDate" }, { "modelName": "WATERBODYTYPE", "nullable": true, "editable": true, "defaultValue": null, "domain": { "splitPolicy": "esriSPTDefaultValue", "name": "swWaterBodyType", "description": "List of waterbody types", "type": "codedValue", "codedValues": [ { "code": "Shallow Marsh", "name": "Shallow Marsh" }, { "code": "Pond", "name": "Pond" }, { "code": "Wetland", "name": "Wetland" }, { "code": "OTH", "name": "Other" }, { "code": "-2", "name": "Unknown" } ], "mergePolicy": "esriMPTDefaultValue" }, "name": "waterbodytype", "length": 50, "alias": "Waterbody Type", "type": "esriFieldTypeString" }, { "modelName": "PONDID", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "pondid", "length": 30, "alias": "Pond ID", "type": "esriFieldTypeString" }, { "modelName": "WATERBODYDEPTH", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "waterbodydepth", "alias": "Depth", "type": "esriFieldTypeDouble" }, { "modelName": "WATERBODYWIDTH", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "waterbodywidth", "alias": "Width", "type": "esriFieldTypeDouble" }, { "modelName": "SUBWATERSHED", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "subwatershed", "length": 50, "alias": "Subwatershed", "type": "esriFieldTypeString" }, { "modelName": "LIFECYCLESTATUS", "nullable": true, "editable": true, "defaultValue": "Active", "domain": { "splitPolicy": "esriSPTDefaultValue", "name": "swLifeCycleStatus", "description": "Life cycle status of the asset", "type": "codedValue", "codedValues": [ { "code": "Active", "name": "Active" }, { "code": "Inactive", "name": "Inactive" }, { "code": "Proposed", "name": "Proposed" }, { "code": "Abandoned", "name": "Abandoned" }, { "code": "Removed", "name": "Removed" }, { "code": "Deleted/DNE", "name": "Deleted/DNE" } ], "mergePolicy": "esriMPTDefaultValue" }, "name": "lifecyclestatus", "length": 25, "alias": "Life Cycle Status", "type": "esriFieldTypeString" }, { "modelName": "ACTIVEFLAG", "nullable": true, "editable": true, "defaultValue": null, "domain": { "splitPolicy": "esriSPTDuplicate", "name": "BooleanDomain_6", "description": "A 0/1 boolean domain", "type": "codedValue", "codedValues": [ { "code": 0, "name": "False" }, { "code": 1, "name": "True" } ], "mergePolicy": "esriMPTDefaultValue" }, "name": "activeflag", "alias": "Active Flag", "type": "esriFieldTypeSmallInteger" }, { "modelName": "OWNEDBY", "nullable": true, "editable": true, "defaultValue": 1, "domain": { "splitPolicy": "esriSPTDefaultValue", "name": "swAssetOwner", "description": "The owner of the asset", "type": "codedValue", "codedValues": [ { "code": 1, "name": "City of Columbia" }, { "code": 2, "name": "SCDOT" }, { "code": 3, "name": "Richland County" }, { "code": 4, "name": "Lexington County" }, { "code": 5, "name": "USC" }, { "code": 6, "name": "Federal" }, { "code": 0, "name": "Joint Ownership" }, { "code": -1, "name": "Private" }, { "code": -2, "name": "Unknown" } ], "mergePolicy": "esriMPTDefaultValue" }, "name": "ownedby", "alias": "Owned By", "type": "esriFieldTypeSmallInteger" }, { "modelName": "MAINTAINEDBY", "nullable": true, "editable": true, "defaultValue": 1, "domain": { "splitPolicy": "esriSPTDefaultValue", "name": "swAssetManager", "description": "The manager of the asset", "type": "codedValue", "codedValues": [ { "code": 1, "name": "City of Columbia" }, { "code": 2, "name": "SCDOT" }, { "code": 3, "name": "Richland County" }, { "code": 4, "name": "Lexington County" }, { "code": 5, "name": "USC" }, { "code": 6, "name": "Federal" }, { "code": 0, "name": "Joint Ownership" }, { "code": -1, "name": "Private" }, { "code": -2, "name": "Unknown" } ], "mergePolicy": "esriMPTDefaultValue" }, "name": "maintainedby", "alias": "Maintained By", "type": "esriFieldTypeSmallInteger" }, { "modelName": "LOCATION", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "location", "length": 250, "alias": "Location Description", "type": "esriFieldTypeString" }, { "modelName": "COMMENTS", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "comments", "length": 250, "alias": "Comments", "type": "esriFieldTypeString" }, { "modelName": "DATASOURCE", "nullable": true, "editable": true, "defaultValue": null, "domain": { "splitPolicy": "esriSPTDefaultValue", "name": "swDataSource", "description": "Source of the data", "type": "codedValue", "codedValues": [ { "code": "ASB", "name": "Asbuilt/Record Drawing" }, { "code": "DES", "name": "Design Drawing" }, { "code": "IMG", "name": "Imagery" }, { "code": "MAPGPS", "name": "Mapping Grade GPS" }, { "code": "SURVGPS", "name": "Survey Grade GPS" }, { "code": "FLD", "name": "Field Survey" }, { "code": "SC", "name": "Service Card" }, { "code": "TC", "name": "Tap Card" }, { "code": "PLAT", "name": "Plat" }, { "code": "DEED", "name": "Deed" }, { "code": "AUTO", "name": "Auto Generated" }, { "code": "OTH", "name": "Other" }, { "code": "UNK", "name": "Unknown" } ], "mergePolicy": "esriMPTDefaultValue" }, "name": "datasource", "length": 25, "alias": "Data Source", "type": "esriFieldTypeString" }, { "modelName": "LASTEDITOR", "nullable": true, "editable": false, "defaultValue": null, "domain": null, "name": "lasteditor", "length": 50, "alias": "Last Editor", "type": "esriFieldTypeString" }, { "modelName": "LASTUPDATE", "nullable": true, "editable": false, "defaultValue": null, "domain": null, "precision": 1, "name": "lastupdate", "length": 29, "alias": "Last Update Date", "type": "esriFieldTypeDate" }, { "modelName": "CREATOR", "nullable": true, "editable": false, "defaultValue": null, "domain": null, "name": "creator", "length": 50, "alias": "Creator", "type": "esriFieldTypeString" }, { "modelName": "CREATIONDATE", "nullable": true, "editable": false, "defaultValue": null, "domain": null, "precision": 1, "name": "creationdate", "length": 29, "alias": "Creation Date", "type": "esriFieldTypeDate" }, { "modelName": "GPSWHO", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "gpswho", "length": 50, "alias": "GPS Who", "type": "esriFieldTypeString" }, { "modelName": "GPSDATE", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "precision": 1, "name": "gpsdate", "length": 29, "alias": "GPS Date", "type": "esriFieldTypeDate" }, { "modelName": "ENABLED", "nullable": true, "editable": true, "defaultValue": 1, "domain": { "splitPolicy": "esriSPTDefaultValue", "name": "EnabledDomain_9", "description": "Geometric Network Enabled domain", "type": "codedValue", "codedValues": [ { "code": 0, "name": "False" }, { "code": 1, "name": "True" } ], "mergePolicy": "esriMPTDefaultValue" }, "name": "enabled", "alias": "Enabled", "type": "esriFieldTypeSmallInteger" }, { "virtual": true, "nullable": true, "editable": false, "defaultValue": null, "domain": null, "name": "SHAPE__Length", "alias": "SHAPE__Length", "type": "esriFieldTypeDouble" }, { "virtual": true, "nullable": true, "editable": false, "defaultValue": null, "domain": null, "name": "SHAPE__Area", "alias": "SHAPE__Area", "type": "esriFieldTypeDouble" }, { "nullable": false, "editable": false, "defaultValue": null, "domain": null, "name": "globalid", "length": 38, "alias": "globalid", "type": "esriFieldTypeGlobalID" } ], "maxRecordCountFactor": 1, "dateFieldsTimeReference": { "respectsDaylightSaving": false, "timeZone": "UTC" }, "supportsFieldDescriptionProperty": true, "hasM": false, "allowGeometryUpdates": true, "useStandardizedQueries": true, "globalIdField": "globalid", "description": "", "syncCanReturnChanges": true, "supportsAsyncDelete": true, "supportedSpatialRelationships": [ "esriSpatialRelIntersects", "esriSpatialRelContains", "esriSpatialRelCrosses", "esriSpatialRelEnvelopeIntersects", "esriSpatialRelOverlaps", "esriSpatialRelTouches", "esriSpatialRelWithin" ], "geometryProperties": { "shapeAreaFieldName": "SHAPE__Area", "shapeLengthFieldName": "SHAPE__Length", "units": "esriMeters" }, "supportsRollbackOnFailureParameter": true, "isDataReplicaTracked": false, "standardMaxRecordCountNoGeometry": 16000, "supportsTruncate": true, "indexes": [ { "name": "r4639_sde_rowid_uk", "isUnique": true, "description": "", "fields": "objectid", "isAscending": true }, { "name": "a3847_ix1", "isUnique": true, "description": "", "fields": "shape", "isAscending": true }, { "name": "uuid_4639", "isUnique": true, "description": "", "fields": "globalid", "isAscending": true } ], "editFieldsInfo": { "editDateField": "lastupdate", "editorField": "lasteditor", "creationDateField": "creationdate", "creatorField": "creator" }, "htmlPopupType": "esriServerHTMLPopupTypeAsHTMLText", "minScale": 9028, "hasAttachments": false, "advancedQueryCapabilities": { "supportsSqlExpression": true, "supportsQueryWithResultType": true, "supportsQueryRelatedPagination": true, "supportsQueryWithCacheHint": false, "supportsQueryWithDatumTransformation": true, "supportsQueryNumericBins": false, "supportsCurrentUserQueries": true, "supportsQueryAttachmentsWithReturnUrl": true, "supportsQueryDateBins": false, "supportsQueryWithLodSR": true, "supportsPaginationOnAggregatedQueries": true, "supportsPagination": true, "supportsMaxRecordCountFactor": true, "supportsStatistics": true, "supportsOrderBy": true, "supportsReturningGeometryProperties": true, "supportsQueryWithDistance": true, "supportsLod": true, "supportsCountDistinct": true, "supportsAdvancedQueryRelated": true, "supportsQueryAttachments": true, "supportsReturningQueryExtent": true, "supportsQueryAttachmentsCountOnly": true, "supportsOrderByOnlyOnLayerFields": false, "supportsOutFieldSqlExpression": true, "supportsTopFeaturesQuery": true, "supportsReturningGeometryEnvelope": false, "supportsDistinct": true, "supportsReturningGeometryCentroid": true, "supportsQueryAnalytic": true, "supportsPercentileStatistics": true, "supportsHavingClause": true }, "supportsValidateSQL": true, "enableZDefaults": true, "serviceItemId": "c8ab64fd58ae41f79bb4b326233d89e9", "allowUpdateWithoutMValues": true, "supportsCoordinatesQuantization": true, "types": [], "capabilities": "Query,Sync", "maxScale": 0, "supportsAppend": true, "supportsExceedsLimitStatistics": true, "defaultVisibility": true, "advancedQueryAnalyticCapabilities": { "supportsAsync": true, "supportsLinearRegression": true, "supportsPercentileAnalytic": false }, "hasMetadata": true, "supportedAppendFormats": "shapefile,geojson,csv,featureCollection,excel,jsonl", "tileMaxRecordCount": 2000, "typeIdField": "", "supportsASyncCalculate": true, "supportedQueryFormats": "JSON, geoJSON, PBF", "sqlParserVersion": "PG_11.2.0", "drawingInfo": { "renderer": { "symbol": { "outline": { "color": [ 110, 110, 110, 255 ], "width": 0.4, "style": "esriSLSSolid", "type": "esriSLS" }, "color": [ 194, 194, 194, 255 ], "style": "esriSFSSolid", "type": "esriSFS" }, "type": "simple" }, "transparency": 0 }, "copyrightText": "", "zDefault": 0, "geometryType": "esriGeometryPolygon", "supportsLayerOverrides": true }, { "isCoGoEnabled": false, "extent": { "ymin": 3994189.115583658, "xmin": -9035962.984206295, "ymax": 4057154.4841822386, "xmax": -8974480.480140982, "spatialReference": { "falseM": -100000, "xyTolerance": 0.001, "mUnits": 10000, "zUnits": 10000, "latestWkid": 3857, "zTolerance": 0.001, "wkid": 102100, "xyUnits": 1.4892314192838538E8, "mTolerance": 0.001, "falseX": -20037700, "falseY": -30241100, "falseZ": -100000 } }, "isDataBranchVersioned": false, "supportedContingentValuesFormats": "JSON, PBF", "supportsApplyEditsWithGlobalIds": true, "maxRecordCount": 2000, "infoInEstimates": [ "extent", "count" ], "type": "Feature Layer", "onlyAllowTrueCurveUpdatesByTrueCurveClients": true, "syncEnabled": true, "supportsAttachmentsByUploadId": true, "relationships": [], "supportsAttachmentsResizing": true, "cimVersion": "2.6.0", "isDataArchived": false, "id": 5, "supportsStatistics": true, "supportedExportFormats": "sqlite,filegdb,shapefile,csv,geojson", "standardMaxRecordCount": 2000, "isDataVersioned": false, "templates": [ { "name": "swOpenDrain", "description": "", "drawingTool": "esriFeatureEditToolLine", "prototype": { "symbol": null, "_constructed": true, "attributes": { "maintainedby": 1, "facilityid": null, "facilityidindex": null, "installdate": null, "enabled": 1, "dsnodeid": null, "lifecyclestatus": "Active", "dnnorthing": null, "dneasting": null, "bankheight": null, "gpsdate": null, "ownedby": 1, "comments": null, "rightmaterial": null, "opendraintype": null, "topwidth": null, "upnorthing": null, "leftmaterial": null, "downelev": null, "usnodeid": null, "activeflag": null, "subwatershed": null, "upelev": null, "datasource": null, "bottommaterial": null, "flowpresent": null, "gpswho": null, "legacyid": null, "bottomwidth": null, "location": null, "upeasting": null } } } ], "hasGeometryProperties": true, "supportsAdvancedQueries": true, "parentLayer": null, "currentVersion": 11.2, "canScaleSymbols": false, "hasZ": false, "advancedEditingCapabilities": { "supportsAsyncApplyEdits": true, "supportsApplyEditsbyUploadID": true, "supportsReturnEditResults": true, "supportedSqlFormatsInCalculate": [ "standard" ], "supportedApplyEditsUploadIDFormats": "JSON" }, "objectIdField": "objectid", "supportsQuantizationEditMode": true, "hasContingentValuesDefinition": true, "name": "swOpenDrain", "allowTrueCurvesUpdates": false, "displayField": "facilityid", "supportsCalculate": true, "fields": [ { "nullable": false, "defaultValue": null, "editable": false, "length": 4, "type": "esriFieldTypeOID", "modelName": "System-maintained ObjectID", "domain": null, "name": "objectid", "alias": "OBJECTID" }, { "modelName": "FACILITYID", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "facilityid", "length": 25, "alias": "Facility ID", "type": "esriFieldTypeString" }, { "modelName": "FACILITYIDINDEX", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "facilityidindex", "alias": "Facility ID Index", "type": "esriFieldTypeInteger" }, { "modelName": "USNODEID", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "usnodeid", "length": 50, "alias": "From Node", "type": "esriFieldTypeString" }, { "modelName": "DSNODEID", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "dsnodeid", "length": 50, "alias": "To Node", "type": "esriFieldTypeString" }, { "modelName": "LEGACYID", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "legacyid", "length": 25, "alias": "Legacy ID", "type": "esriFieldTypeString" }, { "modelName": "INSTALLDATE", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "precision": 1, "name": "installdate", "length": 29, "alias": "Install Date", "type": "esriFieldTypeDate" }, { "modelName": "OPENDRAINTYPE", "nullable": true, "editable": true, "defaultValue": null, "domain": { "splitPolicy": "esriSPTDefaultValue", "name": "swOpenDrainType_10", "description": "Type of open drain", "type": "codedValue", "codedValues": [ { "code": "Ditch", "name": "Ditch" }, { "code": "Swale", "name": "Swale" }, { "code": "Stream", "name": "Stream" }, { "code": "Waterbody", "name": "Waterbody" }, { "code": "Other", "name": "Other" }, { "code": "Unknown", "name": "Unknown" } ], "mergePolicy": "esriMPTDefaultValue" }, "name": "opendraintype", "length": 20, "alias": "Open Drain Type", "type": "esriFieldTypeString" }, { "modelName": "LEFTMATERIAL", "nullable": true, "editable": true, "defaultValue": null, "domain": { "splitPolicy": "esriSPTDefaultValue", "name": "swOpenDrainMaterial_10", "description": "List of materials for open drain", "type": "codedValue", "codedValues": [ { "code": "Asph", "name": "Asphalt" }, { "code": "BR", "name": "Brick" }, { "code": "Concrete (Non-Reinforced)", "name": "Concrete (Non-Reinforced)" }, { "code": "Concrete (Reinforced)", "name": "Concrete (Reinforced)" }, { "code": "EARGEO", "name": "Earth & Geotextile" }, { "code": "GEO", "name": "Geotextile" }, { "code": "SB", "name": "Segmented Block" }, { "code": "BMP", "name": "Brick Masonry" }, { "code": "Native Rock", "name": "Native Rock" }, { "code": "Bed Rock", "name": "Bed Rock" }, { "code": "Rip Rap", "name": "Rip Rap" }, { "code": "Stone Masonry", "name": "Stone Masonry" }, { "code": "Vegetation/Earthen", "name": "Vegetation/Earthen" }, { "code": "Other", "name": "Other" }, { "code": "Unknown", "name": "Unknown" } ], "mergePolicy": "esriMPTDefaultValue" }, "name": "leftmaterial", "length": 50, "alias": "Left Material", "type": "esriFieldTypeString" }, { "modelName": "RIGHTMATERIAL", "nullable": true, "editable": true, "defaultValue": null, "domain": { "splitPolicy": "esriSPTDefaultValue", "name": "swOpenDrainMaterial_10", "description": "List of materials for open drain", "type": "codedValue", "codedValues": [ { "code": "Asph", "name": "Asphalt" }, { "code": "BR", "name": "Brick" }, { "code": "Concrete (Non-Reinforced)", "name": "Concrete (Non-Reinforced)" }, { "code": "Concrete (Reinforced)", "name": "Concrete (Reinforced)" }, { "code": "EARGEO", "name": "Earth & Geotextile" }, { "code": "GEO", "name": "Geotextile" }, { "code": "SB", "name": "Segmented Block" }, { "code": "BMP", "name": "Brick Masonry" }, { "code": "Native Rock", "name": "Native Rock" }, { "code": "Bed Rock", "name": "Bed Rock" }, { "code": "Rip Rap", "name": "Rip Rap" }, { "code": "Stone Masonry", "name": "Stone Masonry" }, { "code": "Vegetation/Earthen", "name": "Vegetation/Earthen" }, { "code": "Other", "name": "Other" }, { "code": "Unknown", "name": "Unknown" } ], "mergePolicy": "esriMPTDefaultValue" }, "name": "rightmaterial", "length": 50, "alias": "Right Material", "type": "esriFieldTypeString" }, { "modelName": "BOTTOMMATERIAL", "nullable": true, "editable": true, "defaultValue": null, "domain": { "splitPolicy": "esriSPTDefaultValue", "name": "swOpenDrainMaterial_10", "description": "List of materials for open drain", "type": "codedValue", "codedValues": [ { "code": "Asph", "name": "Asphalt" }, { "code": "BR", "name": "Brick" }, { "code": "Concrete (Non-Reinforced)", "name": "Concrete (Non-Reinforced)" }, { "code": "Concrete (Reinforced)", "name": "Concrete (Reinforced)" }, { "code": "EARGEO", "name": "Earth & Geotextile" }, { "code": "GEO", "name": "Geotextile" }, { "code": "SB", "name": "Segmented Block" }, { "code": "BMP", "name": "Brick Masonry" }, { "code": "Native Rock", "name": "Native Rock" }, { "code": "Bed Rock", "name": "Bed Rock" }, { "code": "Rip Rap", "name": "Rip Rap" }, { "code": "Stone Masonry", "name": "Stone Masonry" }, { "code": "Vegetation/Earthen", "name": "Vegetation/Earthen" }, { "code": "Other", "name": "Other" }, { "code": "Unknown", "name": "Unknown" } ], "mergePolicy": "esriMPTDefaultValue" }, "name": "bottommaterial", "length": 50, "alias": "Bottom Material", "type": "esriFieldTypeString" }, { "modelName": "TOPWIDTH", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "topwidth", "alias": "Top Width", "type": "esriFieldTypeDouble" }, { "modelName": "BOTTOMWIDTH", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "bottomwidth", "alias": "Bottom Width", "type": "esriFieldTypeDouble" }, { "modelName": "BANKHEIGHT", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "bankheight", "alias": "Bank Height", "type": "esriFieldTypeDouble" }, { "modelName": "FLOWPRESENT", "nullable": true, "editable": true, "defaultValue": null, "domain": { "splitPolicy": "esriSPTDefaultValue", "name": "YesNo_22", "description": "A yes/no indicator", "type": "codedValue", "codedValues": [ { "code": "Y", "name": "Yes" }, { "code": "N", "name": "No" } ], "mergePolicy": "esriMPTDefaultValue" }, "name": "flowpresent", "length": 50, "alias": "Flow Present", "type": "esriFieldTypeString" }, { "modelName": "SUBWATERSHED", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "subwatershed", "length": 50, "alias": "Subwatershed", "type": "esriFieldTypeString" }, { "modelName": "LIFECYCLESTATUS", "nullable": true, "editable": true, "defaultValue": "Active", "domain": { "splitPolicy": "esriSPTDefaultValue", "name": "swLifeCycleStatus", "description": "Life cycle status of the asset", "type": "codedValue", "codedValues": [ { "code": "Active", "name": "Active" }, { "code": "Inactive", "name": "Inactive" }, { "code": "Proposed", "name": "Proposed" }, { "code": "Abandoned", "name": "Abandoned" }, { "code": "Removed", "name": "Removed" }, { "code": "Deleted/DNE", "name": "Deleted/DNE" } ], "mergePolicy": "esriMPTDefaultValue" }, "name": "lifecyclestatus", "length": 25, "alias": "Life Cycle Status", "type": "esriFieldTypeString" }, { "modelName": "ACTIVEFLAG", "nullable": true, "editable": true, "defaultValue": null, "domain": { "splitPolicy": "esriSPTDuplicate", "name": "BooleanDomain_6", "description": "A 0/1 boolean domain", "type": "codedValue", "codedValues": [ { "code": 0, "name": "False" }, { "code": 1, "name": "True" } ], "mergePolicy": "esriMPTDefaultValue" }, "name": "activeflag", "alias": "Active Flag", "type": "esriFieldTypeSmallInteger" }, { "modelName": "OWNEDBY", "nullable": true, "editable": true, "defaultValue": 1, "domain": { "splitPolicy": "esriSPTDefaultValue", "name": "swAssetOwner", "description": "The owner of the asset", "type": "codedValue", "codedValues": [ { "code": 1, "name": "City of Columbia" }, { "code": 2, "name": "SCDOT" }, { "code": 3, "name": "Richland County" }, { "code": 4, "name": "Lexington County" }, { "code": 5, "name": "USC" }, { "code": 6, "name": "Federal" }, { "code": 0, "name": "Joint Ownership" }, { "code": -1, "name": "Private" }, { "code": -2, "name": "Unknown" } ], "mergePolicy": "esriMPTDefaultValue" }, "name": "ownedby", "alias": "Owned By", "type": "esriFieldTypeSmallInteger" }, { "modelName": "MAINTAINEDBY", "nullable": true, "editable": true, "defaultValue": 1, "domain": { "splitPolicy": "esriSPTDefaultValue", "name": "swAssetManager", "description": "The manager of the asset", "type": "codedValue", "codedValues": [ { "code": 1, "name": "City of Columbia" }, { "code": 2, "name": "SCDOT" }, { "code": 3, "name": "Richland County" }, { "code": 4, "name": "Lexington County" }, { "code": 5, "name": "USC" }, { "code": 6, "name": "Federal" }, { "code": 0, "name": "Joint Ownership" }, { "code": -1, "name": "Private" }, { "code": -2, "name": "Unknown" } ], "mergePolicy": "esriMPTDefaultValue" }, "name": "maintainedby", "alias": "Maintained By", "type": "esriFieldTypeSmallInteger" }, { "modelName": "LOCATION", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "location", "length": 250, "alias": "Location Description", "type": "esriFieldTypeString" }, { "modelName": "COMMENTS", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "comments", "length": 250, "alias": "Comments", "type": "esriFieldTypeString" }, { "modelName": "DATASOURCE", "nullable": true, "editable": true, "defaultValue": null, "domain": { "splitPolicy": "esriSPTDefaultValue", "name": "swDataSource", "description": "Source of the data", "type": "codedValue", "codedValues": [ { "code": "ASB", "name": "Asbuilt/Record Drawing" }, { "code": "DES", "name": "Design Drawing" }, { "code": "IMG", "name": "Imagery" }, { "code": "MAPGPS", "name": "Mapping Grade GPS" }, { "code": "SURVGPS", "name": "Survey Grade GPS" }, { "code": "FLD", "name": "Field Survey" }, { "code": "SC", "name": "Service Card" }, { "code": "TC", "name": "Tap Card" }, { "code": "PLAT", "name": "Plat" }, { "code": "DEED", "name": "Deed" }, { "code": "AUTO", "name": "Auto Generated" }, { "code": "OTH", "name": "Other" }, { "code": "UNK", "name": "Unknown" } ], "mergePolicy": "esriMPTDefaultValue" }, "name": "datasource", "length": 25, "alias": "Data Source", "type": "esriFieldTypeString" }, { "modelName": "LASTEDITOR", "nullable": true, "editable": false, "defaultValue": null, "domain": null, "name": "lasteditor", "length": 50, "alias": "Last Editor", "type": "esriFieldTypeString" }, { "modelName": "LASTUPDATE", "nullable": true, "editable": false, "defaultValue": null, "domain": null, "precision": 1, "name": "lastupdate", "length": 29, "alias": "Last Update Date", "type": "esriFieldTypeDate" }, { "modelName": "CREATOR", "nullable": true, "editable": false, "defaultValue": null, "domain": null, "name": "creator", "length": 50, "alias": "Creator", "type": "esriFieldTypeString" }, { "modelName": "CREATIONDATE", "nullable": true, "editable": false, "defaultValue": null, "domain": null, "precision": 1, "name": "creationdate", "length": 29, "alias": "Creation Date", "type": "esriFieldTypeDate" }, { "modelName": "GPSWHO", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "gpswho", "length": 50, "alias": "GPS Who", "type": "esriFieldTypeString" }, { "modelName": "GPSDATE", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "precision": 1, "name": "gpsdate", "length": 29, "alias": "GPS Date", "type": "esriFieldTypeDate" }, { "modelName": "UPNORTHING", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "upnorthing", "alias": "Upstream Northing", "type": "esriFieldTypeDouble" }, { "modelName": "UPEASTING", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "upeasting", "alias": "Upstream Easting", "type": "esriFieldTypeDouble" }, { "modelName": "DNNORTHING", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "dnnorthing", "alias": "Downstream Northing", "type": "esriFieldTypeDouble" }, { "modelName": "DNEASTING", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "dneasting", "alias": "Downsteam Easting", "type": "esriFieldTypeDouble" }, { "modelName": "UPELEV", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "upelev", "alias": "Upstream Surveyed Elevation", "type": "esriFieldTypeDouble" }, { "modelName": "DOWNELEV", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "downelev", "alias": "Downstream Surveyed Elevation", "type": "esriFieldTypeDouble" }, { "modelName": "ENABLED", "nullable": true, "editable": true, "defaultValue": 1, "domain": { "splitPolicy": "esriSPTDefaultValue", "name": "EnabledDomain_9", "description": "Geometric Network Enabled domain", "type": "codedValue", "codedValues": [ { "code": 0, "name": "False" }, { "code": 1, "name": "True" } ], "mergePolicy": "esriMPTDefaultValue" }, "name": "enabled", "alias": "Enabled", "type": "esriFieldTypeSmallInteger" }, { "virtual": true, "nullable": true, "editable": false, "defaultValue": null, "domain": null, "name": "SHAPE__Length", "alias": "SHAPE__Length", "type": "esriFieldTypeDouble" }, { "nullable": false, "editable": false, "defaultValue": null, "domain": null, "name": "globalid", "length": 38, "alias": "globalid", "type": "esriFieldTypeGlobalID" } ], "maxRecordCountFactor": 1, "dateFieldsTimeReference": { "respectsDaylightSaving": false, "timeZone": "UTC" }, "supportsFieldDescriptionProperty": true, "hasM": false, "allowGeometryUpdates": true, "useStandardizedQueries": true, "globalIdField": "globalid", "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": "g14079facilityid", "isUnique": false, "description": "", "fields": "facilityid", "isAscending": true }, { "name": "i14079facilityid", "isUnique": false, "description": "", "fields": "facilityidindex", "isAscending": true }, { "name": "r4646_sde_rowid_uk", "isUnique": true, "description": "", "fields": "objectid", "isAscending": true }, { "name": "a3854_ix1", "isUnique": true, "description": "", "fields": "shape", "isAscending": true }, { "name": "uuid_4646", "isUnique": true, "description": "", "fields": "globalid", "isAscending": true } ], "editFieldsInfo": { "editDateField": "lastupdate", "editorField": "lasteditor", "creationDateField": "creationdate", "creatorField": "creator" }, "htmlPopupType": "esriServerHTMLPopupTypeAsHTMLText", "minScale": 9028, "hasAttachments": false, "advancedQueryCapabilities": { "supportsSqlExpression": true, "supportsQueryWithResultType": true, "supportsQueryRelatedPagination": true, "supportsQueryWithCacheHint": false, "supportsQueryWithDatumTransformation": true, "supportsQueryNumericBins": false, "supportsCurrentUserQueries": true, "supportsQueryAttachmentsWithReturnUrl": true, "supportsQueryDateBins": false, "supportsQueryWithLodSR": true, "supportsPaginationOnAggregatedQueries": true, "supportsPagination": true, "supportsMaxRecordCountFactor": true, "supportsStatistics": true, "supportsOrderBy": true, "supportsReturningGeometryProperties": true, "supportsQueryWithDistance": true, "supportsLod": true, "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": "c8ab64fd58ae41f79bb4b326233d89e9", "allowUpdateWithoutMValues": true, "supportsCoordinatesQuantization": true, "types": [], "capabilities": "Query,Sync", "maxScale": 0, "supportsAppend": true, "supportsExceedsLimitStatistics": true, "defaultVisibility": true, "advancedQueryAnalyticCapabilities": { "supportsAsync": true, "supportsLinearRegression": true, "supportsPercentileAnalytic": false }, "hasMetadata": true, "supportedAppendFormats": "shapefile,geojson,csv,featureCollection,excel,jsonl", "tileMaxRecordCount": 2000, "typeIdField": "", "supportsASyncCalculate": true, "supportedQueryFormats": "JSON, geoJSON, PBF", "sqlParserVersion": "PG_11.2.0", "drawingInfo": { "renderer": { "symbol": { "color": [ 163, 255, 115, 255 ], "width": 0.75, "style": "esriSLSSolid", "type": "esriSLS" }, "type": "simple" }, "transparency": 0 }, "copyrightText": "", "zDefault": 0, "geometryType": "esriGeometryPolyline", "supportsLayerOverrides": true }, { "isCoGoEnabled": false, "extent": { "ymin": 4022512.0537420437, "xmin": -9023583.33621001, "ymax": 4037812.8266121447, "xmax": -9008972.861598285, "spatialReference": { "falseM": -100000, "xyTolerance": 0.001, "mUnits": 10000, "zUnits": 10000, "latestWkid": 3857, "zTolerance": 0.001, "wkid": 102100, "xyUnits": 1.4892314192838538E8, "mTolerance": 0.001, "falseX": -20037700, "falseY": -30241100, "falseZ": -100000 } }, "isDataBranchVersioned": false, "supportedContingentValuesFormats": "JSON, PBF", "supportsApplyEditsWithGlobalIds": true, "maxRecordCount": 2000, "infoInEstimates": [ "extent", "count" ], "type": "Feature Layer", "onlyAllowTrueCurveUpdatesByTrueCurveClients": true, "syncEnabled": true, "supportsAttachmentsByUploadId": true, "relationships": [ { "keyField": "facilityid", "role": "esriRelRoleOrigin", "composite": false, "name": "swConveyanceCondition", "relatedTableId": 8, "id": 4, "cardinality": "esriRelCardinalityOneToMany" } ], "supportsAttachmentsResizing": true, "cimVersion": "2.6.0", "isDataArchived": false, "id": 6, "supportsStatistics": true, "supportedExportFormats": "sqlite,filegdb,shapefile,csv,geojson", "standardMaxRecordCount": 2000, "isDataVersioned": false, "templates": [ { "name": "swVirtualReach", "description": "", "drawingTool": "esriFeatureEditToolLine", "prototype": { "symbol": null, "_constructed": true, "attributes": { "dnelev": null, "facilityid": null, "facilityidindex": null, "comments": null, "upnorthing": null, "usnodeid": null, "enabled": 1, "dsnodeid": null, "invdate": null, "dnnorthing": null, "subwatershed": null, "upelev": null, "datasource": null, "bmpid": null, "legacyid": null, "dneasting": null, "upeasting": null, "easement": null } } } ], "hasGeometryProperties": true, "supportsAdvancedQueries": true, "parentLayer": null, "currentVersion": 11.2, "canScaleSymbols": false, "hasZ": false, "advancedEditingCapabilities": { "supportsAsyncApplyEdits": true, "supportsApplyEditsbyUploadID": true, "supportsReturnEditResults": true, "supportedSqlFormatsInCalculate": [ "standard" ], "supportedApplyEditsUploadIDFormats": "JSON" }, "objectIdField": "objectid", "supportsQuantizationEditMode": true, "hasContingentValuesDefinition": true, "name": "swVirtualReach", "allowTrueCurvesUpdates": false, "displayField": "facilityid", "supportsCalculate": true, "fields": [ { "nullable": false, "defaultValue": null, "editable": false, "length": 4, "type": "esriFieldTypeOID", "modelName": "System-maintained ObjectID", "domain": null, "name": "objectid", "alias": "OBJECTID" }, { "modelName": "FACILITYID", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "facilityid", "length": 25, "alias": "Facility ID", "type": "esriFieldTypeString" }, { "modelName": "FACILITYIDINDEX", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "facilityidindex", "alias": "Facility ID Index", "type": "esriFieldTypeInteger" }, { "modelName": "USNODEID", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "usnodeid", "length": 50, "alias": "From Node", "type": "esriFieldTypeString" }, { "modelName": "DSNODEID", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "dsnodeid", "length": 50, "alias": "To Node", "type": "esriFieldTypeString" }, { "modelName": "LEGACYID", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "legacyid", "length": 25, "alias": "LegacyID", "type": "esriFieldTypeString" }, { "modelName": "INVDATE", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "precision": 1, "name": "invdate", "length": 29, "alias": "Inventory Date", "type": "esriFieldTypeDate" }, { "modelName": "EASEMENT", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "easement", "length": 50, "alias": "Easement", "type": "esriFieldTypeString" }, { "modelName": "COMMENTS", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "comments", "length": 250, "alias": "Comments", "type": "esriFieldTypeString" }, { "modelName": "DATASOURCE", "nullable": true, "editable": true, "defaultValue": null, "domain": { "splitPolicy": "esriSPTDefaultValue", "name": "swDataSource", "description": "Source of the data", "type": "codedValue", "codedValues": [ { "code": "ASB", "name": "Asbuilt/Record Drawing" }, { "code": "DES", "name": "Design Drawing" }, { "code": "IMG", "name": "Imagery" }, { "code": "MAPGPS", "name": "Mapping Grade GPS" }, { "code": "SURVGPS", "name": "Survey Grade GPS" }, { "code": "FLD", "name": "Field Survey" }, { "code": "SC", "name": "Service Card" }, { "code": "TC", "name": "Tap Card" }, { "code": "PLAT", "name": "Plat" }, { "code": "DEED", "name": "Deed" }, { "code": "AUTO", "name": "Auto Generated" }, { "code": "OTH", "name": "Other" }, { "code": "UNK", "name": "Unknown" } ], "mergePolicy": "esriMPTDefaultValue" }, "name": "datasource", "length": 25, "alias": "Data Source", "type": "esriFieldTypeString" }, { "modelName": "BMPID", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "bmpid", "length": 25, "alias": "BMP ID", "type": "esriFieldTypeString" }, { "modelName": "SUBWATERSHED", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "subwatershed", "length": 50, "alias": "Subwatershed", "type": "esriFieldTypeString" }, { "modelName": "UPNORTHING", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "upnorthing", "alias": "Upstream Northing", "type": "esriFieldTypeDouble" }, { "modelName": "UPEASTING", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "upeasting", "alias": "Upstream Easting", "type": "esriFieldTypeDouble" }, { "modelName": "DNNORTHING", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "dnnorthing", "alias": "Downstream Northing", "type": "esriFieldTypeDouble" }, { "modelName": "DNEASTING", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "dneasting", "alias": "Downstream Easting", "type": "esriFieldTypeDouble" }, { "modelName": "UPELEV", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "upelev", "alias": "Upstream Surveyed Elevation", "type": "esriFieldTypeDouble" }, { "modelName": "DNELEV", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "dnelev", "alias": "Downstream Surveyed Elevation", "type": "esriFieldTypeDouble" }, { "modelName": "ENABLED", "nullable": true, "editable": true, "defaultValue": 1, "domain": { "splitPolicy": "esriSPTDefaultValue", "name": "EnabledDomain_9", "description": "Geometric Network Enabled domain", "type": "codedValue", "codedValues": [ { "code": 0, "name": "False" }, { "code": 1, "name": "True" } ], "mergePolicy": "esriMPTDefaultValue" }, "name": "enabled", "alias": "Enabled", "type": "esriFieldTypeSmallInteger" }, { "modelName": "creationdate", "nullable": true, "editable": false, "defaultValue": null, "domain": null, "precision": 1, "name": "creationdate", "length": 29, "alias": "CreationDate", "type": "esriFieldTypeDate" }, { "modelName": "creator", "nullable": true, "editable": false, "defaultValue": null, "domain": null, "name": "creator", "length": 255, "alias": "Creator", "type": "esriFieldTypeString" }, { "modelName": "editdate", "nullable": true, "editable": false, "defaultValue": null, "domain": null, "precision": 1, "name": "editdate", "length": 29, "alias": "EditDate", "type": "esriFieldTypeDate" }, { "modelName": "editor", "nullable": true, "editable": false, "defaultValue": null, "domain": null, "name": "editor", "length": 255, "alias": "Editor", "type": "esriFieldTypeString" }, { "virtual": true, "nullable": true, "editable": false, "defaultValue": null, "domain": null, "name": "SHAPE__Length", "alias": "SHAPE__Length", "type": "esriFieldTypeDouble" }, { "nullable": false, "editable": false, "defaultValue": null, "domain": null, "name": "globalid", "length": 38, "alias": "globalid", "type": "esriFieldTypeGlobalID" } ], "maxRecordCountFactor": 1, "dateFieldsTimeReference": { "respectsDaylightSaving": false, "timeZone": "UTC" }, "supportsFieldDescriptionProperty": true, "hasM": false, "allowGeometryUpdates": true, "useStandardizedQueries": true, "globalIdField": "globalid", "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": "r4642_sde_rowid_uk", "isUnique": true, "description": "", "fields": "objectid", "isAscending": true }, { "name": "a3850_ix1", "isUnique": true, "description": "", "fields": "shape", "isAscending": true }, { "name": "uuid_4642", "isUnique": true, "description": "", "fields": "globalid", "isAscending": true } ], "editFieldsInfo": { "editDateField": "editdate", "editorField": "editor", "creationDateField": "creationdate", "creatorField": "creator" }, "htmlPopupType": "esriServerHTMLPopupTypeAsHTMLText", "minScale": 9028, "hasAttachments": false, "advancedQueryCapabilities": { "supportsSqlExpression": true, "supportsQueryWithResultType": true, "supportsQueryRelatedPagination": true, "supportsQueryWithCacheHint": false, "supportsQueryWithDatumTransformation": true, "supportsQueryNumericBins": false, "supportsCurrentUserQueries": true, "supportsQueryAttachmentsWithReturnUrl": true, "supportsQueryDateBins": false, "supportsQueryWithLodSR": true, "supportsPaginationOnAggregatedQueries": true, "supportsPagination": true, "supportsMaxRecordCountFactor": true, "supportsStatistics": true, "supportsOrderBy": true, "supportsReturningGeometryProperties": true, "supportsQueryWithDistance": true, "supportsLod": true, "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": "c8ab64fd58ae41f79bb4b326233d89e9", "allowUpdateWithoutMValues": true, "supportsCoordinatesQuantization": true, "types": [], "capabilities": "Query,Sync", "maxScale": 0, "supportsAppend": true, "supportsExceedsLimitStatistics": true, "defaultVisibility": true, "advancedQueryAnalyticCapabilities": { "supportsAsync": true, "supportsLinearRegression": true, "supportsPercentileAnalytic": false }, "hasMetadata": true, "supportedAppendFormats": "shapefile,geojson,csv,featureCollection,excel,jsonl", "tileMaxRecordCount": 2000, "typeIdField": "", "supportsASyncCalculate": true, "supportedQueryFormats": "JSON, geoJSON, PBF", "sqlParserVersion": "PG_11.2.0", "drawingInfo": { "renderer": { "symbol": { "color": [ 255, 235, 175, 255 ], "width": 0.75, "style": "esriSLSDashDot", "type": "esriSLS" }, "type": "simple" }, "transparency": 0 }, "copyrightText": "", "zDefault": 0, "geometryType": "esriGeometryPolyline", "supportsLayerOverrides": true }, { "isCoGoEnabled": false, "extent": { "ymin": 4020830.4698557258, "xmin": -9035071.409400601, "ymax": 4045621.7809907496, "xmax": -8997716.026541643, "spatialReference": { "falseM": -100000, "xyTolerance": 0.001, "mUnits": 10000, "zUnits": 10000, "latestWkid": 3857, "zTolerance": 0.001, "wkid": 102100, "xyUnits": 1.4892314192838538E8, "mTolerance": 0.001, "falseX": -20037700, "falseY": -30241100, "falseZ": -100000 } }, "isDataBranchVersioned": false, "supportedContingentValuesFormats": "JSON, PBF", "supportsApplyEditsWithGlobalIds": true, "maxRecordCount": 2000, "infoInEstimates": [ "extent", "count" ], "type": "Feature Layer", "onlyAllowTrueCurveUpdatesByTrueCurveClients": true, "syncEnabled": true, "supportsAttachmentsByUploadId": true, "relationships": [], "supportsAttachmentsResizing": true, "cimVersion": "2.6.0", "isDataArchived": false, "id": 7, "supportsStatistics": true, "supportedExportFormats": "sqlite,filegdb,shapefile,csv,geojson", "standardMaxRecordCount": 2000, "isDataVersioned": false, "templates": [ { "name": "swPermBMP", "description": "", "drawingTool": "esriFeatureEditToolPolygon", "prototype": { "symbol": null, "_constructed": true, "attributes": { "maintainedby": 1, "facilityid": null, "facilityidindex": null, "installdate": null, "comments": null, "permitid": null, "waterbodytype": null, "enabled": 1, "activeflag": null, "lifecyclestatus": "Active", "subwatershed": null, "datasource": null, "gpswho": null, "permit": null, "legacyid": null, "location": null, "gpsdate": null, "bmptype": null, "ownedby": 1, "pondid": null } } } ], "hasGeometryProperties": true, "supportsAdvancedQueries": true, "parentLayer": null, "currentVersion": 11.2, "canScaleSymbols": false, "hasZ": false, "advancedEditingCapabilities": { "supportsAsyncApplyEdits": true, "supportsApplyEditsbyUploadID": true, "supportsReturnEditResults": true, "supportedSqlFormatsInCalculate": [ "standard" ], "supportedApplyEditsUploadIDFormats": "JSON" }, "objectIdField": "objectid", "supportsQuantizationEditMode": true, "hasContingentValuesDefinition": true, "name": "swPermBMP", "allowTrueCurvesUpdates": false, "displayField": "facilityid", "supportsCalculate": true, "fields": [ { "nullable": false, "defaultValue": null, "editable": false, "length": 4, "type": "esriFieldTypeOID", "modelName": "System-maintained ObjectID", "domain": null, "name": "objectid", "alias": "OBJECTID" }, { "modelName": "FACILITYID", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "facilityid", "length": 25, "alias": "Facility ID", "type": "esriFieldTypeString" }, { "modelName": "FACILITYIDINDEX", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "facilityidindex", "alias": "Facility ID Index", "type": "esriFieldTypeInteger" }, { "modelName": "LEGACYID", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "legacyid", "length": 25, "alias": "Legacy ID", "type": "esriFieldTypeString" }, { "modelName": "INSTALLDATE", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "precision": 1, "name": "installdate", "length": 29, "alias": "Install Date", "type": "esriFieldTypeDate" }, { "modelName": "BMPTYPE", "nullable": true, "editable": true, "defaultValue": null, "domain": { "splitPolicy": "esriSPTDefaultValue", "name": "swBMPType", "description": "A list of BMP structures", "type": "codedValue", "codedValues": [ { "code": "Detention/Dry Pond", "name": "Detention/Dry Pond" }, { "code": "Retention/Wet Pond", "name": "Retention/Wet Pond" }, { "code": "Bioretention", "name": "Bioretention" }, { "code": "Underground Detention", "name": "Underground Detention" }, { "code": "Infiltration Trench/Basin", "name": "Infiltration Trench/Basin" }, { "code": "Pervious Pavement", "name": "Pervious Pavement" }, { "code": "Green Roof", "name": "Green Roof" }, { "code": "Water Quality Unit", "name": "Water Quality Unit" }, { "code": "Engineered Wetland", "name": "Engineered Wetland" }, { "code": "OTH", "name": "Other" }, { "code": "-2", "name": "Unknown" } ], "mergePolicy": "esriMPTDefaultValue" }, "name": "bmptype", "length": 50, "alias": "BMP Type", "type": "esriFieldTypeString" }, { "modelName": "PERMIT", "nullable": true, "editable": true, "defaultValue": null, "domain": { "splitPolicy": "esriSPTDefaultValue", "name": "YesNo_22", "description": "A yes/no indicator", "type": "codedValue", "codedValues": [ { "code": "Y", "name": "Yes" }, { "code": "N", "name": "No" } ], "mergePolicy": "esriMPTDefaultValue" }, "name": "permit", "length": 30, "alias": "Permitted MS4 BMP", "type": "esriFieldTypeString" }, { "modelName": "PERMITID", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "permitid", "length": 20, "alias": "Permit Identifier", "type": "esriFieldTypeString" }, { "modelName": "PONDID", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "pondid", "length": 30, "alias": "Pond ID", "type": "esriFieldTypeString" }, { "modelName": "WATERBODYTYPE", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "waterbodytype", "length": 25, "alias": "Water Body Type", "type": "esriFieldTypeString" }, { "modelName": "SUBWATERSHED", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "subwatershed", "length": 50, "alias": "Subwatershed", "type": "esriFieldTypeString" }, { "modelName": "LIFECYCLESTATUS", "nullable": true, "editable": true, "defaultValue": "Active", "domain": { "splitPolicy": "esriSPTDefaultValue", "name": "swLifeCycleStatus", "description": "Life cycle status of the asset", "type": "codedValue", "codedValues": [ { "code": "Active", "name": "Active" }, { "code": "Inactive", "name": "Inactive" }, { "code": "Proposed", "name": "Proposed" }, { "code": "Abandoned", "name": "Abandoned" }, { "code": "Removed", "name": "Removed" }, { "code": "Deleted/DNE", "name": "Deleted/DNE" } ], "mergePolicy": "esriMPTDefaultValue" }, "name": "lifecyclestatus", "length": 25, "alias": "Life Cycle Status", "type": "esriFieldTypeString" }, { "modelName": "ACTIVEFLAG", "nullable": true, "editable": true, "defaultValue": null, "domain": { "splitPolicy": "esriSPTDuplicate", "name": "BooleanDomain_6", "description": "A 0/1 boolean domain", "type": "codedValue", "codedValues": [ { "code": 0, "name": "False" }, { "code": 1, "name": "True" } ], "mergePolicy": "esriMPTDefaultValue" }, "name": "activeflag", "alias": "Active Flag", "type": "esriFieldTypeSmallInteger" }, { "modelName": "OWNEDBY", "nullable": true, "editable": true, "defaultValue": 1, "domain": { "splitPolicy": "esriSPTDefaultValue", "name": "swAssetOwner", "description": "The owner of the asset", "type": "codedValue", "codedValues": [ { "code": 1, "name": "City of Columbia" }, { "code": 2, "name": "SCDOT" }, { "code": 3, "name": "Richland County" }, { "code": 4, "name": "Lexington County" }, { "code": 5, "name": "USC" }, { "code": 6, "name": "Federal" }, { "code": 0, "name": "Joint Ownership" }, { "code": -1, "name": "Private" }, { "code": -2, "name": "Unknown" } ], "mergePolicy": "esriMPTDefaultValue" }, "name": "ownedby", "alias": "Owned By", "type": "esriFieldTypeSmallInteger" }, { "modelName": "MAINTAINEDBY", "nullable": true, "editable": true, "defaultValue": 1, "domain": { "splitPolicy": "esriSPTDefaultValue", "name": "swAssetManager", "description": "The manager of the asset", "type": "codedValue", "codedValues": [ { "code": 1, "name": "City of Columbia" }, { "code": 2, "name": "SCDOT" }, { "code": 3, "name": "Richland County" }, { "code": 4, "name": "Lexington County" }, { "code": 5, "name": "USC" }, { "code": 6, "name": "Federal" }, { "code": 0, "name": "Joint Ownership" }, { "code": -1, "name": "Private" }, { "code": -2, "name": "Unknown" } ], "mergePolicy": "esriMPTDefaultValue" }, "name": "maintainedby", "alias": "Maintained By", "type": "esriFieldTypeSmallInteger" }, { "modelName": "LOCATION", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "location", "length": 250, "alias": "Location Description", "type": "esriFieldTypeString" }, { "modelName": "COMMENTS", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "comments", "length": 250, "alias": "Comments", "type": "esriFieldTypeString" }, { "modelName": "DATASOURCE", "nullable": true, "editable": true, "defaultValue": null, "domain": { "splitPolicy": "esriSPTDefaultValue", "name": "swDataSource", "description": "Source of the data", "type": "codedValue", "codedValues": [ { "code": "ASB", "name": "Asbuilt/Record Drawing" }, { "code": "DES", "name": "Design Drawing" }, { "code": "IMG", "name": "Imagery" }, { "code": "MAPGPS", "name": "Mapping Grade GPS" }, { "code": "SURVGPS", "name": "Survey Grade GPS" }, { "code": "FLD", "name": "Field Survey" }, { "code": "SC", "name": "Service Card" }, { "code": "TC", "name": "Tap Card" }, { "code": "PLAT", "name": "Plat" }, { "code": "DEED", "name": "Deed" }, { "code": "AUTO", "name": "Auto Generated" }, { "code": "OTH", "name": "Other" }, { "code": "UNK", "name": "Unknown" } ], "mergePolicy": "esriMPTDefaultValue" }, "name": "datasource", "length": 25, "alias": "Data Source", "type": "esriFieldTypeString" }, { "modelName": "LASTEDITOR", "nullable": true, "editable": false, "defaultValue": null, "domain": null, "name": "lasteditor", "length": 50, "alias": "Last Editor", "type": "esriFieldTypeString" }, { "modelName": "LASTUPDATE", "nullable": true, "editable": false, "defaultValue": null, "domain": null, "precision": 1, "name": "lastupdate", "length": 29, "alias": "Last Update Date", "type": "esriFieldTypeDate" }, { "modelName": "CREATOR", "nullable": true, "editable": false, "defaultValue": null, "domain": null, "name": "creator", "length": 50, "alias": "Creator", "type": "esriFieldTypeString" }, { "modelName": "CREATIONDATE", "nullable": true, "editable": false, "defaultValue": null, "domain": null, "precision": 1, "name": "creationdate", "length": 29, "alias": "Creation Date", "type": "esriFieldTypeDate" }, { "modelName": "GPSWHO", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "gpswho", "length": 50, "alias": "GPS Who", "type": "esriFieldTypeString" }, { "modelName": "GPSDATE", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "precision": 1, "name": "gpsdate", "length": 29, "alias": "GPS Date", "type": "esriFieldTypeDate" }, { "modelName": "ENABLED", "nullable": true, "editable": true, "defaultValue": 1, "domain": { "splitPolicy": "esriSPTDefaultValue", "name": "EnabledDomain_9", "description": "Geometric Network Enabled domain", "type": "codedValue", "codedValues": [ { "code": 0, "name": "False" }, { "code": 1, "name": "True" } ], "mergePolicy": "esriMPTDefaultValue" }, "name": "enabled", "alias": "Enabled", "type": "esriFieldTypeSmallInteger" }, { "virtual": true, "nullable": true, "editable": false, "defaultValue": null, "domain": null, "name": "SHAPE__Length", "alias": "SHAPE__Length", "type": "esriFieldTypeDouble" }, { "virtual": true, "nullable": true, "editable": false, "defaultValue": null, "domain": null, "name": "SHAPE__Area", "alias": "SHAPE__Area", "type": "esriFieldTypeDouble" }, { "nullable": false, "editable": false, "defaultValue": null, "domain": null, "name": "globalid", "length": 38, "alias": "globalid", "type": "esriFieldTypeGlobalID" } ], "maxRecordCountFactor": 1, "dateFieldsTimeReference": { "respectsDaylightSaving": false, "timeZone": "UTC" }, "supportsFieldDescriptionProperty": true, "hasM": false, "allowGeometryUpdates": true, "useStandardizedQueries": true, "globalIdField": "globalid", "description": "", "syncCanReturnChanges": true, "supportsAsyncDelete": true, "supportedSpatialRelationships": [ "esriSpatialRelIntersects", "esriSpatialRelContains", "esriSpatialRelCrosses", "esriSpatialRelEnvelopeIntersects", "esriSpatialRelOverlaps", "esriSpatialRelTouches", "esriSpatialRelWithin" ], "geometryProperties": { "shapeAreaFieldName": "SHAPE__Area", "shapeLengthFieldName": "SHAPE__Length", "units": "esriMeters" }, "supportsRollbackOnFailureParameter": true, "isDataReplicaTracked": false, "standardMaxRecordCountNoGeometry": 16000, "supportsTruncate": true, "indexes": [ { "name": "r4643_sde_rowid_uk", "isUnique": true, "description": "", "fields": "objectid", "isAscending": true }, { "name": "a3851_ix1", "isUnique": true, "description": "", "fields": "shape", "isAscending": true }, { "name": "uuid_4643", "isUnique": true, "description": "", "fields": "globalid", "isAscending": true } ], "editFieldsInfo": { "editDateField": "lastupdate", "editorField": "lasteditor", "creationDateField": "creationdate", "creatorField": "creator" }, "htmlPopupType": "esriServerHTMLPopupTypeAsHTMLText", "minScale": 9028, "hasAttachments": false, "advancedQueryCapabilities": { "supportsSqlExpression": true, "supportsQueryWithResultType": true, "supportsQueryRelatedPagination": true, "supportsQueryWithCacheHint": false, "supportsQueryWithDatumTransformation": true, "supportsQueryNumericBins": false, "supportsCurrentUserQueries": true, "supportsQueryAttachmentsWithReturnUrl": true, "supportsQueryDateBins": false, "supportsQueryWithLodSR": true, "supportsPaginationOnAggregatedQueries": true, "supportsPagination": true, "supportsMaxRecordCountFactor": true, "supportsStatistics": true, "supportsOrderBy": true, "supportsReturningGeometryProperties": true, "supportsQueryWithDistance": true, "supportsLod": true, "supportsCountDistinct": true, "supportsAdvancedQueryRelated": true, "supportsQueryAttachments": true, "supportsReturningQueryExtent": true, "supportsQueryAttachmentsCountOnly": true, "supportsOrderByOnlyOnLayerFields": false, "supportsOutFieldSqlExpression": true, "supportsTopFeaturesQuery": true, "supportsReturningGeometryEnvelope": false, "supportsDistinct": true, "supportsReturningGeometryCentroid": true, "supportsQueryAnalytic": true, "supportsPercentileStatistics": true, "supportsHavingClause": true }, "supportsValidateSQL": true, "enableZDefaults": true, "serviceItemId": "c8ab64fd58ae41f79bb4b326233d89e9", "allowUpdateWithoutMValues": true, "supportsCoordinatesQuantization": true, "types": [], "capabilities": "Query,Sync", "maxScale": 0, "supportsAppend": true, "supportsExceedsLimitStatistics": true, "defaultVisibility": true, "advancedQueryAnalyticCapabilities": { "supportsAsync": true, "supportsLinearRegression": true, "supportsPercentileAnalytic": false }, "hasMetadata": true, "supportedAppendFormats": "shapefile,geojson,csv,featureCollection,excel,jsonl", "tileMaxRecordCount": 2000, "typeIdField": "", "supportsASyncCalculate": true, "supportedQueryFormats": "JSON, geoJSON, PBF", "sqlParserVersion": "PG_11.2.0", "drawingInfo": { "renderer": { "symbol": { "outline": { "color": [ 255, 255, 255, 255 ], "width": 0.4, "style": "esriSLSSolid", "type": "esriSLS" }, "color": [ 133, 133, 133, 255 ], "style": "esriSFSSolid", "type": "esriSFS" }, "type": "simple" }, "transparency": 25 }, "copyrightText": "", "zDefault": 0, "geometryType": "esriGeometryPolygon", "supportsLayerOverrides": true } ] }