{ "currentVersion": 11.3, "cimVersion": "3.3.0", "id": 1, "name": "Preliminary Water Mains", "type": "Feature Layer", "parentLayer": null, "defaultVisibility": true, "minScale": 250000, "maxScale": 0, "canScaleSymbols": false, "geometryType": "esriGeometryPolyline", "description": "", "copyrightText": "", "editFieldsInfo": { "creationDateField": "created_date", "creatorField": "created_user", "editDateField": "last_edited_date", "editorField": "last_edited_user" }, "ownershipBasedAccessControlForFeatures": null, "syncCanReturnChanges": true, "relationships": [ { "id": 1, "name": "wmHistory", "relatedTableId": 3, "cardinality": "esriRelCardinalityOneToMany", "role": "esriRelRoleOrigin", "keyField": "Asset_ID", "composite": false, "catalogID": "{F0CA019B-183E-4FAC-A614-ACEF16361AD9}" } ], "isDataVersioned": true, "isDataArchived": false, "infoInEstimates": [ "extent" ], "isDataBranchVersioned": false, "isDataReplicaTracked": false, "isCoGoEnabled": false, "modelName": "GP_153355777", "supportsRollbackOnFailureParameter": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportsValidateSQL": true, "supportsCoordinatesQuantization": true, "supportsQuantizationEditMode": true, "supportsCalculate": true, "supportsASyncCalculate": true, "supportsDatumTransformation": true, "advancedQueryCapabilities": { "supportsPagination": true, "supportsTrueCurve": true, "supportsQueryWithDistance": true, "supportsReturningQueryExtent": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsAdvancedQueryRelated": true, "supportsQueryRelatedPagination": true, "supportsCurrentUserQueries": true, "supportsQueryWithResultType": true, "supportsReturningGeometryCentroid": false, "supportsSqlExpression": true, "supportsQueryWithDatumTransformation": true, "supportsLod": false, "supportsQueryWithLodSR": false, "supportsQueryAnalytic": true }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": true, "supportsPercentileAnalytic": true }, "advancedEditingCapabilities": { "supportedSqlFormatsInCalculate": [ "standard" ], "supportsAsyncApplyEdits": true, "supportsApplyEditsbyUploadID": true, "supportedApplyEditsUploadIDFormats": "JSON" }, "hasGeometryProperties": true, "geometryProperties": { "shapeLengthFieldName": "Shape__Length", "units": "esriMeters" }, "hasMetadata": true, "extent": { "xmin": -1.0787692797904227E7, "ymin": 5900279.914362575, "xmax": -1.0771296881681874E7, "ymax": 5938861.470819249, "spatialReference": { "wkid": 102100, "latestWkid": 3857, "xyTolerance": 0.001, "zTolerance": 0.001, "mTolerance": 0.001, "falseX": -20037700, "falseY": -30241100, "xyUnits": 10000, "falseZ": -100000, "zUnits": 10000, "falseM": -100000, "mUnits": 10000 } }, "sourceSpatialReference": { "wkt2": "COMPOUNDCRS[\"\",PROJCRS[\"Fargo_Ground_Coordinate_System\",BASEGEOGCRS[\"GCS_North_American_1983\",DATUM[\"D_North_American_1983\",ELLIPSOID[\"GRS_1980\",6378137.0,298.257222101,LENGTHUNIT[\"Meter\",1.0]]],PRIMEM[\"Greenwich\",0.0,ANGLEUNIT[\"Degree\",0.0174532925199433]],CS[ellipsoidal,2],ANGLEUNIT[\"Degree\",0.0174532925199433]],CONVERSION[\"Rectified_Skew_Orthomorphic_Natural_Origin\",METHOD[\"Rectified_Skew_Orthomorphic_Natural_Origin\"],PARAMETER[\"False_Easting\",2869344.93,LENGTHUNIT[\"Foot_US\",0.3048006096012192]],PARAMETER[\"False_Northing\",-16657672.6488,LENGTHUNIT[\"Foot_US\",0.3048006096012192]],PARAMETER[\"Scale_Factor\",1.000038773618,SCALEUNIT[\"Unity\",1.0]],PARAMETER[\"Azimuth\",2.63389226,ANGLEUNIT[\"Degree\",0.0174532925199433]],PARAMETER[\"Longitude_Of_Center\",-96.88886388888889,ANGLEUNIT[\"Degree\",0.0174532925199433]],PARAMETER[\"Latitude_Of_Center\",46.99163611111111,ANGLEUNIT[\"Degree\",0.0174532925199433]],PARAMETER[\"XY_Plane_Rotation\",0.0,ANGLEUNIT[\"Degree\",0.0174532925199433]]],CS[Cartesian,2],AXIS[\"Easting (X)\",east,ORDER[1]],AXIS[\"Northing (Y)\",north,ORDER[2]],LENGTHUNIT[\"Foot_US\",0.3048006096012192]],VERTCRS[\"NAVD_1988\",VDATUM[\"North_American_Vertical_Datum_1988\"],CS[vertical,1],AXIS[\"Gravity-related height (H)\",up,LENGTHUNIT[\"Foot_US\",0.3048006096012192]]]]", "wkt": "PROJCS[\"Fargo_Ground_Coordinate_System\",GEOGCS[\"GCS_North_American_1983\",DATUM[\"D_North_American_1983\",SPHEROID[\"GRS_1980\",6378137.0,298.257222101]],PRIMEM[\"Greenwich\",0.0],UNIT[\"Degree\",0.0174532925199433]],PROJECTION[\"Rectified_Skew_Orthomorphic_Natural_Origin\"],PARAMETER[\"False_Easting\",2869344.93],PARAMETER[\"False_Northing\",-16657672.6488],PARAMETER[\"Scale_Factor\",1.000038773618],PARAMETER[\"Azimuth\",2.63389226],PARAMETER[\"Longitude_Of_Center\",-96.88886388888889],PARAMETER[\"Latitude_Of_Center\",46.99163611111111],PARAMETER[\"XY_Plane_Rotation\",0.0],UNIT[\"Foot_US\",0.3048006096012192]],VERTCS[\"NAVD_1988\",VDATUM[\"North_American_Vertical_Datum_1988\"],PARAMETER[\"Vertical_Shift\",0.0],PARAMETER[\"Direction\",1.0],UNIT[\"Foot_US\",0.3048006096012192]]", "xyTolerance": 0.0032808333333333335, "zTolerance": 0.001, "mTolerance": 0.001, "falseX": -100234300, "falseY": -82178900, "xyUnits": 3048.0060960121914, "falseZ": 0, "zUnits": 1, "falseM": 0, "mUnits": 1 }, "sourceHeightModelInfo": { "heightModel": "gravity_related_height", "vertCRS": "NAVD_1988", "heightUnit": "us-foot" }, "drawingInfo": { "renderer": { "type": "simple", "symbol": { "type": "esriSLS", "style": "esriSLSSolid", "color": [ 0, 197, 255, 255 ], "width": 1.5 } }, "scaleSymbols": true, "transparency": 0, "labelingInfo": null }, "hasM": false, "hasZ": false, "allowGeometryUpdates": true, "allowTrueCurvesUpdates": false, "onlyAllowTrueCurveUpdatesByTrueCurveClients": true, "hasAttachments": false, "supportsApplyEditsWithGlobalIds": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "objectIdField": "OBJECTID", "globalIdField": "GlobalID", "displayField": "ProjectNumber", "typeIdField": "", "subtypeField": "", "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null, "editable": false, "nullable": false, "defaultValue": null, "modelName": "OBJECTID" }, { "name": "ProjectNumber", "type": "esriFieldTypeString", "alias": "ProjectNumber", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "ProjectNumber" }, { "name": "YearInstalled", "type": "esriFieldTypeString", "alias": "YearInstalled", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "YearInstalled" }, { "name": "ProjectRetired", "type": "esriFieldTypeString", "alias": "ProjectRetired", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "ProjectRetired" }, { "name": "YearRetired", "type": "esriFieldTypeString", "alias": "YearRetired", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "YearRetired" }, { "name": "Material", "type": "esriFieldTypeString", "alias": "Material", "domain": null, "editable": true, "nullable": true, "length": 254, "defaultValue": "PVC", "modelName": "MATERIAL" }, { "name": "Diameter", "type": "esriFieldTypeString", "alias": "Diameter", "domain": null, "editable": true, "nullable": true, "length": 16, "defaultValue": null, "modelName": "Diameter" }, { "name": "UpstreamInvert", "type": "esriFieldTypeString", "alias": "UpstreamInvert", "domain": null, "editable": true, "nullable": true, "length": 16, "defaultValue": null, "modelName": "UpstreamInvert" }, { "name": "DownstreamInvert", "type": "esriFieldTypeString", "alias": "DownstreamInvert", "domain": null, "editable": true, "nullable": true, "length": 16, "defaultValue": null, "modelName": "DownstreamInvert" }, { "name": "Condition", "type": "esriFieldTypeString", "alias": "Condition", "domain": null, "editable": true, "nullable": true, "length": 25, "defaultValue": null, "modelName": "Condition" }, { "name": "FlowMeasurement", "type": "esriFieldTypeString", "alias": "FlowMeasurement", "domain": null, "editable": true, "nullable": true, "length": 25, "defaultValue": null, "modelName": "FlowMeasurement" }, { "name": "Pressure", "type": "esriFieldTypeString", "alias": "Pressure", "domain": null, "editable": true, "nullable": true, "length": 25, "defaultValue": null, "modelName": "Pressure" }, { "name": "Comments", "type": "esriFieldTypeString", "alias": "Comments", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "COMMENTS" }, { "name": "Datum", "type": "esriFieldTypeString", "alias": "Datum", "domain": { "type": "codedValue", "name": "Datum", "description": "Datum", "codedValues": [ { "name": "U.S.G.S. Vertical Datum of 1988", "code": "1988" }, { "name": "City of Fargo Datum", "code": "Fargo" }, { "name": "U.S.G.S. Vertical Datum of 1927", "code": "1927" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 50, "defaultValue": "1988", "modelName": "Datum" }, { "name": "Status", "type": "esriFieldTypeString", "alias": "Status", "domain": { "type": "codedValue", "name": "Status", "description": "Status", "codedValues": [ { "name": "Planned", "code": "Planned" }, { "name": "Active", "code": "Active" }, { "name": "Abandoned", "code": "Abandoned" }, { "name": "Removed", "code": "Removed" }, { "name": "Killed", "code": "Killed" }, { "name": "Construction", "code": "Construction" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" }, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "Status" }, { "name": "Manufacturer", "type": "esriFieldTypeString", "alias": "Manufacturer", "domain": null, "editable": true, "nullable": true, "length": 25, "defaultValue": null, "modelName": "Manufacturer" }, { "name": "HydrantLead", "type": "esriFieldTypeSmallInteger", "alias": "HydrantLead", "domain": { "type": "codedValue", "name": "YesNo", "description": "Populates Yes and No Values", "codedValues": [ { "name": "Yes", "code": 1 }, { "name": "No", "code": 0 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "defaultValue": 0, "modelName": "HydrantLead" }, { "name": "Liner", "type": "esriFieldTypeSmallInteger", "alias": "Liner", "domain": { "type": "codedValue", "name": "YesNo", "description": "Populates Yes and No Values", "codedValues": [ { "name": "Yes", "code": 1 }, { "name": "No", "code": 0 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "defaultValue": 0, "modelName": "Liner" }, { "name": "LinerProjectNumber", "type": "esriFieldTypeString", "alias": "LinerProjectNumber", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "LinerProjectNumber" }, { "name": "LinerYearInstalled", "type": "esriFieldTypeString", "alias": "LinerYearInstalled", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "LinerYearInstalled" }, { "name": "LinerMaterial", "type": "esriFieldTypeString", "alias": "LinerMaterial", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "LinerMaterial" }, { "name": "TraceWire", "type": "esriFieldTypeSmallInteger", "alias": "TraceWire", "domain": { "type": "codedValue", "name": "YesNo", "description": "Populates Yes and No Values", "codedValues": [ { "name": "Yes", "code": 1 }, { "name": "No", "code": 0 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "defaultValue": null, "modelName": "TraceWire" }, { "name": "WaterJurisdiction", "type": "esriFieldTypeString", "alias": "WaterJurisdiction", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "WaterJurisdiction" }, { "name": "ConsequenceOfFailure", "type": "esriFieldTypeDouble", "alias": "ConsequenceOfFailure", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "ConsequenceOfFailure" }, { "name": "ProbabilityOfFailure", "type": "esriFieldTypeDouble", "alias": "ProbabilityOfFailure", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "ProbabilityOfFailure" }, { "name": "Mitigation", "type": "esriFieldTypeDouble", "alias": "Mitigation", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "Mitigation" }, { "name": "Risk", "type": "esriFieldTypeDouble", "alias": "Risk", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "Risk" }, { "name": "EstimatedLife", "type": "esriFieldTypeSmallInteger", "alias": "EstimatedLife", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "EstimatedLife" }, { "name": "InstallationDate", "type": "esriFieldTypeDate", "alias": "InstallationDate", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "InstallationDate" }, { "name": "ReplacementCost", "type": "esriFieldTypeDouble", "alias": "ReplacementCost", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "ReplacementCost" }, { "name": "CostingDate", "type": "esriFieldTypeDate", "alias": "CostingDate", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "CostingDate" }, { "name": "Asset_ID", "type": "esriFieldTypeString", "alias": "Asset_ID", "domain": null, "editable": true, "nullable": true, "length": 20, "defaultValue": null, "modelName": "Asset_ID" }, { "name": "LINEID", "type": "esriFieldTypeInteger", "alias": "LINEID", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "LINEID" }, { "name": "ModelingDescription", "type": "esriFieldTypeString", "alias": "ModelingDescription", "domain": null, "editable": true, "nullable": true, "length": 60, "defaultValue": null, "modelName": "ModelingDescription" }, { "name": "ModelingArea", "type": "esriFieldTypeString", "alias": "ModelingArea", "domain": null, "editable": true, "nullable": true, "length": 32, "defaultValue": null, "modelName": "ModelingArea" }, { "name": "ModelingRoughness", "type": "esriFieldTypeDouble", "alias": "ModelingRoughness", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "ModelingRoughness" }, { "name": "LAYER", "type": "esriFieldTypeString", "alias": "LAYER", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": "X_WM_cntr", "modelName": "LAYER" }, { "name": "COLOR", "type": "esriFieldTypeInteger", "alias": "COLOR", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "COLOR" }, { "name": "LINETYPE", "type": "esriFieldTypeString", "alias": "LINETYPE", "domain": null, "editable": true, "nullable": true, "length": 16, "defaultValue": null, "modelName": "Linetype" }, { "name": "created_user", "type": "esriFieldTypeString", "alias": "created_user", "domain": null, "editable": false, "nullable": true, "length": 255, "defaultValue": null, "modelName": "created_user" }, { "name": "created_date", "type": "esriFieldTypeDate", "alias": "created_date", "domain": null, "editable": false, "nullable": true, "length": 8, "defaultValue": null, "modelName": "created_date" }, { "name": "last_edited_user", "type": "esriFieldTypeString", "alias": "last_edited_user", "domain": null, "editable": false, "nullable": true, "length": 255, "defaultValue": null, "modelName": "last_edited_user" }, { "name": "last_edited_date", "type": "esriFieldTypeDate", "alias": "last_edited_date", "domain": null, "editable": false, "nullable": true, "length": 8, "defaultValue": null, "modelName": "last_edited_date" }, { "name": "Shape__Length", "type": "esriFieldTypeDouble", "alias": "Shape.STLength()", "domain": null, "editable": false, "nullable": true, "defaultValue": null, "modelName": "Shape.STLength()", "required": true }, { "name": "Private", "type": "esriFieldTypeSmallInteger", "alias": "Private", "domain": { "type": "codedValue", "name": "YesNo", "description": "Populates Yes and No Values", "codedValues": [ { "name": "Yes", "code": 1 }, { "name": "No", "code": 0 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "defaultValue": 0, "modelName": "Private" }, { "name": "GlobalID", "type": "esriFieldTypeGlobalID", "alias": "GlobalID", "domain": null, "editable": false, "nullable": false, "length": 38, "defaultValue": null, "modelName": "GlobalID" }, { "name": "TransmissionLines", "type": "esriFieldTypeString", "alias": "TransmissionLines", "domain": { "type": "codedValue", "name": "Yes or No", "description": "Yes or No", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 50, "defaultValue": "No", "modelName": "TransmissionLines" }, { "name": "UseType", "type": "esriFieldTypeString", "alias": "UseType", "domain": { "type": "codedValue", "name": "WaterUseType", "description": "The type of water use", "codedValues": [ { "name": "Domestic", "code": "Domestic" }, { "name": "Fire Protection", "code": "Fire Protection" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "UseType" }, { "name": "EmergencyMain", "type": "esriFieldTypeSmallInteger", "alias": "EmergencyMain", "domain": { "type": "codedValue", "name": "YesNo", "description": "Populates Yes and No Values", "codedValues": [ { "name": "Yes", "code": 1 }, { "name": "No", "code": 0 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "defaultValue": 0, "modelName": "EmergencyMain" } ], "geometryField": { "name": "Shape", "type": "esriFieldTypeGeometry", "alias": "Shape", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "Shape" }, "indexes": [ { "name": "R224_pk", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "UUID_224", "fields": "GlobalID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "G338Asset_ID", "fields": "Asset_ID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "UUID_OID_224", "fields": "GlobalID,OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "insights_4D35EE0B", "fields": "Status", "isAscending": true, "isUnique": false, "description": "" }, { "name": "insights_8A91D5C1", "fields": "Diameter", "isAscending": true, "isUnique": false, "description": "" }, { "name": "insights_63EF74F8", "fields": "YearInstalled", "isAscending": true, "isUnique": false, "description": "" }, { "name": "S128_idx", "fields": "Shape", "isAscending": true, "isUnique": true, "description": "" } ], "datesInUnknownTimezone": false, "dateFieldsTimeReference": { "timeZone": "UTC", "respectsDaylightSaving": false }, "preferredTimeReference": null, "types": [], "templates": [ { "name": "Preliminary Water Lines", "description": "", "prototype": { "attributes": { "ModelingRoughness": null, "UseType": null, "ProjectNumber": null, "YearInstalled": null, "ProjectRetired": null, "YearRetired": null, "Material": "PVC", "Diameter": null, "UpstreamInvert": null, "DownstreamInvert": null, "Condition": null, "FlowMeasurement": null, "Pressure": null, "Comments": null, "Datum": "1988", "Status": null, "Manufacturer": null, "HydrantLead": 0, "Liner": 0, "LinerProjectNumber": null, "LinerYearInstalled": null, "LinerMaterial": null, "TraceWire": null, "WaterJurisdiction": null, "ConsequenceOfFailure": null, "ProbabilityOfFailure": null, "Mitigation": null, "Risk": null, "EstimatedLife": null, "InstallationDate": null, "ReplacementCost": null, "CostingDate": null, "Asset_ID": null, "LINEID": null, "ModelingDescription": null, "ModelingArea": null, "LAYER": "X_WM_cntr", "COLOR": null, "LINETYPE": null, "EmergencyMain": 0, "Private": 0, "TransmissionLines": "No" } }, "drawingTool": "esriFeatureEditToolLine" } ], "maxRecordCount": 1000, "supportedQueryFormats": "JSON, geoJSON, PBF", "supportedExportFormats": "sqlite,filegdb,shapefile,csv,geojson", "capabilities": "Query,Create,Update,Delete,Uploads,Editing", "useStandardizedQueries": true, "bigIntegerRestrictedTo53Bits": true, "supportedSpatialRelationships": [ "esriSpatialRelIntersects", "esriSpatialRelContains", "esriSpatialRelCrosses", "esriSpatialRelEnvelopeIntersects", "esriSpatialRelIndexIntersects", "esriSpatialRelOverlaps", "esriSpatialRelTouches", "esriSpatialRelWithin", "esriSpatialRelRelation" ], "standardMaxRecordCount": 8000, "tileMaxRecordCount": 4000, "standardMaxRecordCountNoGeometry": 32000, "maxRecordCountFactor": 1 }