{ "currentVersion": 11.3, "cimVersion": "3.3.0", "id": 31, "name": "Pipes", "type": "Feature Layer", "parentLayer": null, "defaultVisibility": true, "minScale": 0, "maxScale": 0, "canScaleSymbols": false, "geometryType": "esriGeometryPolyline", "description": "", "copyrightText": "", "editFieldsInfo": null, "ownershipBasedAccessControlForFeatures": null, "syncCanReturnChanges": true, "relationships": [], "isDataVersioned": true, "isDataArchived": false, "infoInEstimates": [ "extent" ], "isDataBranchVersioned": false, "isDataReplicaTracked": false, "isCoGoEnabled": false, "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": "esriFeet" }, "hasMetadata": true, "extent": { "xmin": 1784254.1817285556, "ymin": 572077.1840372361, "xmax": 1848478.683239827, "ymax": 625108.246129865, "spatialReference": { "wkid": 103152, "latestWkid": 6576, "xyTolerance": 0.001, "zTolerance": 0.001, "mTolerance": 0.001, "falseX": -4.5035996273705E11, "falseY": -4.5035996273705E11, "xyUnits": 2644.992507866249, "falseZ": -100000, "zUnits": 9999.998889777098, "falseM": -100000, "mUnits": 10000 } }, "sourceSpatialReference": { "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 }, "drawingInfo": { "renderer": { "type": "simple", "symbol": { "type": "esriSLS", "style": "esriSLSSolid", "color": [ 230, 230, 0, 255 ], "width": 2 } }, "scaleSymbols": true, "transparency": 0, "labelingInfo": null }, "hasM": true, "hasZ": true, "enableZDefaults": false, "supportsVCSProjection": true, "allowUpdateWithoutMValues": false, "allowGeometryUpdates": true, "allowTrueCurvesUpdates": true, "onlyAllowTrueCurveUpdatesByTrueCurveClients": true, "hasAttachments": false, "supportsApplyEditsWithGlobalIds": false, "htmlPopupType": "esriServerHTMLPopupTypeAsHTMLText", "objectIdField": "OBJECTID", "globalIdField": "GlobalID", "displayField": "Enabled", "typeIdField": "", "subtypeField": "Material", "defaultSubtypeCode": 3, "fields": [ { "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": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null, "editable": false, "nullable": false, "defaultValue": null, "modelName": "System-maintained ObjectID" }, { "name": "Enabled", "type": "esriFieldTypeSmallInteger", "alias": "Enabled", "domain": { "type": "codedValue", "name": "EnabledDomain", "description": "", "codedValues": [ { "name": "False", "code": 0 }, { "name": "True", "code": 1 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "defaultValue": 1, "modelName": "Enabled" }, { "name": "CREATIONUSER", "type": "esriFieldTypeString", "alias": "Creation User", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "CREATIONUSER" }, { "name": "DATECREATED", "type": "esriFieldTypeDate", "alias": "Date Created", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "DATECREATED" }, { "name": "DATEMODIFIED", "type": "esriFieldTypeDate", "alias": "Date Modified", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "DATEMODIFIED" }, { "name": "LASTUSER", "type": "esriFieldTypeString", "alias": "Last User", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "LASTUSER" }, { "name": "LEGACYID", "type": "esriFieldTypeString", "alias": "Legacy ID", "domain": null, "editable": true, "nullable": true, "length": 38, "defaultValue": null, "modelName": "LEGACYID" }, { "name": "INSTALLATIONDATE", "type": "esriFieldTypeDate", "alias": "InstallationDate", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "INSTALLATIONDATE" }, { "name": "STATUS", "type": "esriFieldTypeString", "alias": "Status", "domain": { "type": "codedValue", "name": "Pipe Facility Status", "description": "Lifecycle state of a gas facility asset.", "codedValues": [ { "name": "Proposed", "code": "Proposed" }, { "name": "Proposed Retired", "code": "Proposed Retired" }, { "name": "Active", "code": "Active" }, { "name": "Inactive", "code": "Inactive" }, { "name": "Retired", "code": "Retired" }, { "name": "Removed", "code": "Removed" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" }, "editable": true, "nullable": true, "length": 20, "defaultValue": "Active", "modelName": "STATUS" }, { "name": "NOMINALDIAMETER", "type": "esriFieldTypeDouble", "alias": "Nominal Diameter", "domain": { "type": "codedValue", "name": "Gas Pipe Diameter Bare Steel", "description": "List of valid nominal diameters for Bare Steel pipe", "codedValues": [ { "name": "1/4\"", "code": 0.25 }, { "name": "3/8\"", "code": 0.38 }, { "name": "1/2\"", "code": 0.5 }, { "name": "3/4\"", "code": 0.75 }, { "name": "1\"", "code": 1 }, { "name": "1 1/4\"", "code": 1.25 }, { "name": "1 1/2\"", "code": 1.5 }, { "name": "2\"", "code": 2 }, { "name": "2 1/2\"", "code": 2.5 }, { "name": "3\"", "code": 3 }, { "name": "3 1/2\"", "code": 3.5 }, { "name": "4\"", "code": 4 }, { "name": "6\"", "code": 6 }, { "name": "8\"", "code": 8 }, { "name": "10\"", "code": 10 }, { "name": "12\"", "code": 12 }, { "name": "14\"", "code": 14 }, { "name": "16\"", "code": 16 }, { "name": "18\"", "code": 18 }, { "name": "20\"", "code": 20 }, { "name": "22\"", "code": 22 }, { "name": "24\"", "code": 24 }, { "name": "26\"", "code": 26 }, { "name": "28\"", "code": 28 }, { "name": "30\"", "code": 30 }, { "name": "32\"", "code": 32 }, { "name": "34\"", "code": 34 }, { "name": "36\"", "code": 36 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" }, "editable": true, "nullable": true, "defaultValue": null, "modelName": "NOMINALDIAMETER" }, { "name": "OUTSIDEDIAMETER", "type": "esriFieldTypeDouble", "alias": "Outside Diameter", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "OUTSIDEDIAMETER" }, { "name": "DIAMETERUNITS", "type": "esriFieldTypeString", "alias": "Nominal Diameter Units", "domain": { "type": "codedValue", "name": "Gas Pipe Diameter Units", "description": "List of units of measure for gas pipe diameters", "codedValues": [ { "name": "inch", "code": "inch" }, { "name": "millimeter", "code": "mm" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" }, "editable": true, "nullable": true, "length": 20, "defaultValue": "inch", "modelName": "DIAMETERUNITS" }, { "name": "OPERATINGPRESSURE", "type": "esriFieldTypeDouble", "alias": "Operating Pressure", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "OPERATINGPRESSURE" }, { "name": "COATINGTYPE", "type": "esriFieldTypeString", "alias": "Coating Type", "domain": { "type": "codedValue", "name": "Coating Type", "description": "List of valid options for the type of coating applied to a pipe", "codedValues": [ { "name": "3M Tape", "code": "3M Tape" }, { "name": "Bare", "code": "Bare" }, { "name": "Blue Guard", "code": "Blue Guard" }, { "name": "Coal Tar", "code": "Coal Tar" }, { "name": "Coal Tar Enamel", "code": "Coal Tar Enamel" }, { "name": "Cold Tape", "code": "Cold Tape" }, { "name": "Concrete", "code": "Concrete" }, { "name": "Does Not Apply", "code": "Does Not Apply" }, { "name": "Epoxy", "code": "Epoxy" }, { "name": "Flex Clad", "code": "Flex Clad" }, { "name": "Galvanized", "code": "Galvanized" }, { "name": "Hot Tape", "code": "Hot Tape" }, { "name": "Hysol", "code": "Hysol" }, { "name": "Mill Wrap", "code": "Mill Wrap" }, { "name": "Neoprene", "code": "Neoprene" }, { "name": "Paint", "code": "Paint" }, { "name": "Primer", "code": "Primer" }, { "name": "Rock Jacket", "code": "Rock Jacket" }, { "name": "Scotch Wrap", "code": "Scotch Wrap" }, { "name": "Tar", "code": "Tar" }, { "name": "Tape", "code": "Tape" }, { "name": "Wax", "code": "Wax" }, { "name": "Wrap", "code": "Wrap" }, { "name": "Other", "code": "Other" }, { "name": "Asbestos Felt", "code": "Asbestos Felt" }, { "name": "Asphalt", "code": "Asphalt" }, { "name": "Enamel", "code": "Enamel" }, { "name": "Extruded Asphalt", "code": "Extruded Asphalt" }, { "name": "Felt Wrap", "code": "Felt Wrap" }, { "name": "Flakeline", "code": "Flakeline" }, { "name": "Fusion Bonded Epoxy", "code": "Fusion Bonded Epoxy" }, { "name": "Glass Filled Polyester", "code": "Glass Filled Polyester" }, { "name": "Grease", "code": "Grease" }, { "name": "Paper", "code": "Paper" }, { "name": "Plastic", "code": "Plastic" }, { "name": "Yellow Jacket", "code": "Yellow Jacket" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" }, "editable": true, "nullable": true, "length": 30, "defaultValue": null, "modelName": "COATINGTYPE" }, { "name": "MEASUREDLENGTH", "type": "esriFieldTypeDouble", "alias": "Measured Length", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "MEASUREDLENGTH" }, { "name": "LENGTHSOURCE", "type": "esriFieldTypeString", "alias": "Length Source", "domain": { "type": "codedValue", "name": "Length Source", "description": "The method used determine the measurement", "codedValues": [ { "name": "Field Measurement", "code": "Field Measurement" }, { "name": "Mapping System", "code": "Mapping System" }, { "name": "User-Derived", "code": "User-Derived" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" }, "editable": true, "nullable": true, "length": 25, "defaultValue": "Field Measurement", "modelName": "LENGTHSOURCE" }, { "name": "ACTUALINTERNALDIAMETER", "type": "esriFieldTypeDouble", "alias": "Actual Internal Diameter", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "ACTUALINTERNALDIAMETER" }, { "name": "WALLTHICKNESS", "type": "esriFieldTypeDouble", "alias": "Wall Thickness", "domain": { "type": "codedValue", "name": "PipeWallThickness", "description": "List of values of the wall thickness of a gas pipe", "codedValues": [ { "name": "0", "code": 0 }, { "name": "0.125", "code": 0.125 }, { "name": "0.2", "code": 0.2 }, { "name": "0.3", "code": 0.3 }, { "name": "0.4", "code": 0.4 }, { "name": "0.5", "code": 0.5 }, { "name": "0.6", "code": 0.6 }, { "name": "0.7", "code": 0.7 }, { "name": "0.75", "code": 0.75 }, { "name": "0.8", "code": 0.8 }, { "name": "0.9", "code": 0.9 }, { "name": "1.0", "code": 1 }, { "name": "1.1", "code": 1.1 }, { "name": "1.2", "code": 1.2 }, { "name": "1.25", "code": 1.25 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" }, "editable": true, "nullable": true, "defaultValue": null, "modelName": "WALLTHICKNESS" }, { "name": "ASSETUNITCODE", "type": "esriFieldTypeString", "alias": "Asset Unit Code", "domain": null, "editable": true, "nullable": true, "length": 20, "defaultValue": null, "modelName": "ASSETUNITCODE" }, { "name": "OWNER", "type": "esriFieldTypeString", "alias": "Owner", "domain": { "type": "codedValue", "name": "CityCode", "description": "Where gas asset is located", "codedValues": [ { "name": "Smyrna", "code": "Smyrna" }, { "name": "LaVergne", "code": "LaVergne" }, { "name": "Nolensville", "code": "Nolensville" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 20, "defaultValue": "Smyrna", "modelName": "OWNER" }, { "name": "INSERVICEDATE", "type": "esriFieldTypeDate", "alias": "In Service Date", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "INSERVICEDATE" }, { "name": "DATE_RETIRED", "type": "esriFieldTypeDate", "alias": "Date Retired", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "DATE_RETIRED" }, { "name": "INSTALLATIONMETHOD", "type": "esriFieldTypeString", "alias": "Installation Method", "domain": { "type": "codedValue", "name": "Pipe Install Method", "description": "Installation methods for installing gas pipe", "codedValues": [ { "name": "Trench", "code": "Trench" }, { "name": "Joint Trench", "code": "Joint Trench" }, { "name": "Insertion", "code": "Insertion" }, { "name": "Direct Bore", "code": "Direct Bore" }, { "name": "Split and Pull", "code": "Split and Pull" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" }, "editable": true, "nullable": true, "length": 20, "defaultValue": "Direct Bore", "modelName": "INSTALLATIONMETHOD" }, { "name": "WARNINGTAPE", "type": "esriFieldTypeString", "alias": "Warning Tape", "domain": { "type": "codedValue", "name": "Yes No Indicator", "description": "Boolean list with single letter representation of yes and no", "codedValues": [ { "name": "No", "code": "N" }, { "name": "Yes", "code": "Y" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" }, "editable": true, "nullable": true, "length": 5, "defaultValue": null, "modelName": "WARNINGTAPE" }, { "name": "TRACERWIRE", "type": "esriFieldTypeString", "alias": "Tracer Wire", "domain": { "type": "codedValue", "name": "Yes No Indicator", "description": "Boolean list with single letter representation of yes and no", "codedValues": [ { "name": "No", "code": "N" }, { "name": "Yes", "code": "Y" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" }, "editable": true, "nullable": true, "length": 5, "defaultValue": null, "modelName": "TRACERWIRE" }, { "name": "WORKORDERID", "type": "esriFieldTypeString", "alias": "Work Order ID", "domain": null, "editable": true, "nullable": true, "length": 20, "defaultValue": null, "modelName": "WORKORDERID" }, { "name": "PROJECTNUMBER", "type": "esriFieldTypeString", "alias": "Project Number", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "PROJECTNUMBER" }, { "name": "PIPETESTDATE", "type": "esriFieldTypeDate", "alias": "Pipe Test Date", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "PIPETESTDATE" }, { "name": "PIPETESTDURATION", "type": "esriFieldTypeString", "alias": "Pipe Test Duration", "domain": null, "editable": true, "nullable": true, "length": 20, "defaultValue": null, "modelName": "PIPETESTDURATION" }, { "name": "PIPETESTPRESSURE", "type": "esriFieldTypeDouble", "alias": "Pipe Test Pressure", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "PIPETESTPRESSURE" }, { "name": "PIPETESTTYPE", "type": "esriFieldTypeString", "alias": "Pipe Test Type", "domain": { "type": "codedValue", "name": "PipeTestType", "description": "List of substances used to test the containment capabilities of the gas system", "codedValues": [ { "name": "Air", "code": "Air" }, { "name": "Gas", "code": "Gas" }, { "name": "Water", "code": "Water" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" }, "editable": true, "nullable": true, "length": 10, "defaultValue": null, "modelName": "PIPETESTTYPE" }, { "name": "ELECTRICSURVEYINDICATOR", "type": "esriFieldTypeString", "alias": "Electric Survey Indicator", "domain": { "type": "codedValue", "name": "Yes No Indicator", "description": "Boolean list with single letter representation of yes and no", "codedValues": [ { "name": "No", "code": "N" }, { "name": "Yes", "code": "Y" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" }, "editable": true, "nullable": true, "length": 5, "defaultValue": null, "modelName": "ELECTRICSURVEYINDICATOR" }, { "name": "DESIGNPRESSUREENTERED", "type": "esriFieldTypeDouble", "alias": "Design Pressure - Entered", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "DESIGNPRESSUREENTERED" }, { "name": "DESIGNPRESSURESTANDARD", "type": "esriFieldTypeDouble", "alias": "Design Pressure - Standard", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "DESIGNPRESSURESTANDARD" }, { "name": "DESIGNPRESSUREUNITOFMEASURE", "type": "esriFieldTypeString", "alias": "Design Pressure - Unit of Measure", "domain": null, "editable": true, "nullable": true, "length": 20, "defaultValue": null, "modelName": "DESIGNPRESSUREUNITOFMEASURE" }, { "name": "DESIGNCLASS", "type": "esriFieldTypeInteger", "alias": "Design Class", "domain": { "type": "codedValue", "name": "DOTClassType", "description": "List of valid DOT pipeline classifications", "codedValues": [ { "name": "Class 1", "code": 1 }, { "name": "Class 2", "code": 2 }, { "name": "Class 3", "code": 3 }, { "name": "Class 4", "code": 4 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" }, "editable": true, "nullable": true, "defaultValue": null, "modelName": "DESIGNCLASS" }, { "name": "DESIGNFACTOR", "type": "esriFieldTypeDouble", "alias": "Design Factor", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "DESIGNFACTOR" }, { "name": "Material", "type": "esriFieldTypeInteger", "alias": "Material", "domain": null, "editable": true, "nullable": true, "defaultValue": 3, "modelName": "Material" }, { "name": "SYSTEMTYPE", "type": "esriFieldTypeString", "alias": "Pipe System Type", "domain": { "type": "codedValue", "name": "Pipe System Type", "description": "List of valid system types in the pipe system", "codedValues": [ { "name": "Distribution", "code": "Distribution" }, { "name": "Transmission", "code": "Transmission" }, { "name": "Gathering", "code": "Gathering" }, { "name": "OffShore Transmission", "code": "OffShoreTransmission" }, { "name": "OffShore Gathering", "code": "OffShoreGathering" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 20, "defaultValue": "Distribution", "modelName": "SYSTEMTYPE" }, { "name": "CRITICALINDICATOR", "type": "esriFieldTypeString", "alias": "Critical Indicator", "domain": { "type": "codedValue", "name": "Yes No Indicator", "description": "Boolean list with single letter representation of yes and no", "codedValues": [ { "name": "No", "code": "N" }, { "name": "Yes", "code": "Y" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" }, "editable": true, "nullable": true, "length": 5, "defaultValue": null, "modelName": "CRITICALINDICATOR" }, { "name": "PIGGABLE", "type": "esriFieldTypeString", "alias": "Piggable", "domain": { "type": "codedValue", "name": "Yes No Indicator", "description": "Boolean list with single letter representation of yes and no", "codedValues": [ { "name": "No", "code": "N" }, { "name": "Yes", "code": "Y" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" }, "editable": true, "nullable": true, "length": 2, "defaultValue": "N", "modelName": "PIGGABLE" }, { "name": "BARCODE", "type": "esriFieldTypeString", "alias": "Barcode", "domain": null, "editable": true, "nullable": true, "length": 16, "defaultValue": null, "modelName": "BARCODE" }, { "name": "MANUFACTURER", "type": "esriFieldTypeString", "alias": "Manufacturer", "domain": { "type": "codedValue", "name": "Gas Pipe Manufacturer", "description": "List of valid manufacturers of pipe", "codedValues": [ { "name": "Thrall Distribution", "code": "Thrall Distribution" }, { "name": "UPONOR", "code": "UPONOR" }, { "name": "Other", "code": "Other" }, { "name": "Unknown", "code": "Unknown" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" }, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "MANUFACTURER" }, { "name": "MANUFACTURELOTNO", "type": "esriFieldTypeString", "alias": "Manufacture Lot No", "domain": null, "editable": true, "nullable": true, "length": 5, "defaultValue": null, "modelName": "MANUFACTURELOTNO" }, { "name": "MANUFACTUREDATE", "type": "esriFieldTypeDate", "alias": "Manufacture Date", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "MANUFACTUREDATE" }, { "name": "PIPESPECIFICATION", "type": "esriFieldTypeString", "alias": "Pipe Specification", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "PIPESPECIFICATION" }, { "name": "CPSYSTEM_GlobalID", "type": "esriFieldTypeGUID", "alias": "CPSystem_GlobalID", "domain": null, "editable": true, "nullable": true, "length": 38, "defaultValue": null, "modelName": "CPSYSTEM_GlobalID" }, { "name": "MAOPDESIGN", "type": "esriFieldTypeDouble", "alias": "MAOP Design", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "MAOPDESIGN" }, { "name": "MAOPTEST", "type": "esriFieldTypeDouble", "alias": "MAOP Test", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "MAOPTEST" }, { "name": "MAOPRECORD", "type": "esriFieldTypeDouble", "alias": "MAOP Record", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "MAOPRECORD" }, { "name": "MAOPUNITOFMEASURE", "type": "esriFieldTypeString", "alias": "MAOP Unit of Measure", "domain": null, "editable": true, "nullable": true, "length": 20, "defaultValue": null, "modelName": "MAOPUNITOFMEASURE" }, { "name": "PRESSURESYSTEM_GlobalID", "type": "esriFieldTypeGUID", "alias": "PressureSystem_GlobalID", "domain": null, "editable": true, "nullable": true, "length": 38, "defaultValue": null, "modelName": "PRESSURESYSTEM_GlobalID" }, { "name": "EMERISOSYS_GlobalID", "type": "esriFieldTypeGUID", "alias": "EmerIsoSys_GlobalID", "domain": null, "editable": true, "nullable": true, "length": 38, "defaultValue": null, "modelName": "EMERISOSYS_GlobalID" }, { "name": "PINCHABLE", "type": "esriFieldTypeString", "alias": "PINCHABLE", "domain": { "type": "codedValue", "name": "Yes No Indicator", "description": "Boolean list with single letter representation of yes and no", "codedValues": [ { "name": "No", "code": "N" }, { "name": "Yes", "code": "Y" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" }, "editable": true, "nullable": true, "length": 2, "defaultValue": "N", "modelName": "PINCHABLE" }, { "name": "PIPEGRADE", "type": "esriFieldTypeString", "alias": "PIPEGRADE", "domain": null, "editable": true, "nullable": true, "length": 20, "defaultValue": null, "modelName": "PIPEGRADE" }, { "name": "GIRTHWELDTYPE", "type": "esriFieldTypeString", "alias": "Girth Weld Type", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "GIRTHWELDTYPE" }, { "name": "LONGITUDINALSEAMORIENTATION", "type": "esriFieldTypeString", "alias": "Longitudinal Seam Orientation", "domain": null, "editable": true, "nullable": true, "length": 20, "defaultValue": null, "modelName": "LONGITUDINALSEAMORIENTATION" }, { "name": "GASTRACEWEIGHT", "type": "esriFieldTypeInteger", "alias": "GASTRACEWEIGHT", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "GASTRACEWEIGHT" }, { "name": "SMYS", "type": "esriFieldTypeDouble", "alias": "SMYS", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "SMYS" }, { "name": "PERCENTSMYS", "type": "esriFieldTypeDouble", "alias": "Percent SMYS", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "PERCENTSMYS" }, { "name": "PipeInfo", "type": "esriFieldTypeString", "alias": "PipeInfo", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "PipeInfo" }, { "name": "AssetLocation", "type": "esriFieldTypeString", "alias": "AssetLocation", "domain": { "type": "codedValue", "name": "AssetLocation", "description": "Where asset is located", "codedValues": [ { "name": "Smyrna", "code": "Smyrna" }, { "name": "LaVergne", "code": "LaVergne" }, { "name": "Nolensville", "code": "Nolensville" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "AssetLocation" }, { "name": "HowCollected", "type": "esriFieldTypeString", "alias": "HowCollected", "domain": { "type": "codedValue", "name": "HowCollected", "description": "How the asset was added to GIS system", "codedValues": [ { "name": "Geocoded", "code": "Geocoded" }, { "name": "GPS", "code": "GPS" }, { "name": "Site Visit", "code": "Site Visit" }, { "name": "Placed on Map", "code": "Placed on Map" }, { "name": "Other", "code": "Other" }, { "name": "As Built Drawing", "code": "As Built Drawing" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "HowCollected" }, { "name": "HorizontalAccuracy", "type": "esriFieldTypeDouble", "alias": "HorizontalAccuracy", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "HorizontalAccuracy" }, { "name": "CrewMember", "type": "esriFieldTypeString", "alias": "CrewMember", "domain": { "type": "codedValue", "name": "CrewMember", "description": "Name of crew performing work", "codedValues": [ { "name": "Chas Keel", "code": "Chas Keel" }, { "name": "Derek Francis", "code": "Derek Francis" }, { "name": "DJ Carter", "code": "DJ Carter" }, { "name": "Dustin West", "code": "Dustin West" }, { "name": "Fred Koch", "code": "Fred Koch" }, { "name": "Jackie Reed", "code": "Jackie Reed" }, { "name": "Joel Womble", "code": "Joel Womble" }, { "name": "Johnnie Moore", "code": "Johnnie Moore" }, { "name": "Josh McCormick", "code": "Josh McCormick" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "CrewMember" }, { "name": "GlobalID", "type": "esriFieldTypeGlobalID", "alias": "GlobalID", "domain": null, "editable": false, "nullable": false, "length": 38, "defaultValue": null, "modelName": "GlobalID" }, { "name": "Shape__Length", "type": "esriFieldTypeDouble", "alias": "SHAPE.STLength()", "domain": null, "editable": false, "nullable": true, "defaultValue": null, "modelName": "SHAPE.STLength()", "required": true } ], "geometryField": { "name": "SHAPE", "type": "esriFieldTypeGeometry", "alias": "SHAPE", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "System-maintained Geometry for a feature" }, "indexes": [ { "name": "R46_pk", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "UUID_46", "fields": "GlobalID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "UUID_OID_46", "fields": "GlobalID,OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "S35_idx", "fields": "SHAPE", "isAscending": true, "isUnique": true, "description": "" } ], "datesInUnknownTimezone": false, "dateFieldsTimeReference": { "timeZone": "UTC", "respectsDaylightSaving": false }, "preferredTimeReference": null, "types": [], "templates": [ { "name": "Pipes", "description": "", "prototype": { "attributes": { "DESIGNFACTOR": null, "CrewMember": null, "HorizontalAccuracy": null, "HowCollected": null, "AssetLocation": null, "PipeInfo": null, "Enabled": 1, "CREATIONUSER": null, "DATECREATED": null, "DATEMODIFIED": null, "LASTUSER": null, "LEGACYID": null, "INSTALLATIONDATE": null, "STATUS": "Active", "NOMINALDIAMETER": 4, "OUTSIDEDIAMETER": null, "DIAMETERUNITS": "inch", "OPERATINGPRESSURE": null, "COATINGTYPE": null, "MEASUREDLENGTH": null, "LENGTHSOURCE": "Field Measurement", "ACTUALINTERNALDIAMETER": null, "WALLTHICKNESS": null, "ASSETUNITCODE": null, "OWNER": "Smyrna", "INSERVICEDATE": null, "DATE_RETIRED": null, "INSTALLATIONMETHOD": "Trench", "WARNINGTAPE": null, "TRACERWIRE": null, "WORKORDERID": null, "PROJECTNUMBER": null, "PIPETESTDATE": null, "PIPETESTDURATION": null, "PIPETESTPRESSURE": null, "PIPETESTTYPE": null, "ELECTRICSURVEYINDICATOR": null, "DESIGNPRESSUREENTERED": null, "DESIGNPRESSURESTANDARD": null, "DESIGNPRESSUREUNITOFMEASURE": null, "DESIGNCLASS": null, "Material": 3, "SYSTEMTYPE": "Distribution", "CRITICALINDICATOR": null, "PIGGABLE": "N", "BARCODE": null, "MANUFACTURER": null, "MANUFACTURELOTNO": null, "MANUFACTUREDATE": null, "PIPESPECIFICATION": null, "CPSYSTEM_GlobalID": null, "MAOPDESIGN": null, "MAOPTEST": null, "MAOPRECORD": null, "MAOPUNITOFMEASURE": null, "PRESSURESYSTEM_GlobalID": null, "EMERISOSYS_GlobalID": null, "PINCHABLE": "N", "PIPEGRADE": null, "GIRTHWELDTYPE": null, "LONGITUDINALSEAMORIENTATION": null, "GASTRACEWEIGHT": null, "SMYS": null, "PERCENTSMYS": null } }, "drawingTool": "esriFeatureEditToolLine" } ], "subtypes": [ { "code": 3, "name": "Coated Steel", "defaultValues": { "Enabled": 1, "CREATIONUSER": null, "DATECREATED": null, "DATEMODIFIED": null, "LASTUSER": null, "LEGACYID": null, "INSTALLATIONDATE": null, "STATUS": "Active", "NOMINALDIAMETER": 4, "OUTSIDEDIAMETER": null, "DIAMETERUNITS": "inch", "OPERATINGPRESSURE": null, "COATINGTYPE": null, "MEASUREDLENGTH": null, "LENGTHSOURCE": "Field Measurement", "ACTUALINTERNALDIAMETER": null, "WALLTHICKNESS": null, "ASSETUNITCODE": null, "OWNER": "Smyrna", "INSERVICEDATE": null, "DATE_RETIRED": null, "INSTALLATIONMETHOD": "Trench", "WARNINGTAPE": null, "TRACERWIRE": null, "WORKORDERID": null, "PROJECTNUMBER": null, "PIPETESTDATE": null, "PIPETESTDURATION": null, "PIPETESTPRESSURE": null, "PIPETESTTYPE": null, "ELECTRICSURVEYINDICATOR": null, "DESIGNPRESSUREENTERED": null, "DESIGNPRESSURESTANDARD": null, "DESIGNPRESSUREUNITOFMEASURE": null, "DESIGNCLASS": null, "DESIGNFACTOR": null, "Material": 3, "SYSTEMTYPE": "Distribution", "CRITICALINDICATOR": null, "PIGGABLE": "N", "BARCODE": null, "MANUFACTURER": null, "MANUFACTURELOTNO": null, "MANUFACTUREDATE": null, "PIPESPECIFICATION": null, "CPSYSTEM_GlobalID": null, "MAOPDESIGN": null, "MAOPTEST": null, "MAOPRECORD": null, "MAOPUNITOFMEASURE": null, "PRESSURESYSTEM_GlobalID": null, "EMERISOSYS_GlobalID": null, "PINCHABLE": "N", "PIPEGRADE": null, "GIRTHWELDTYPE": null, "LONGITUDINALSEAMORIENTATION": null, "GASTRACEWEIGHT": null, "SMYS": null, "PERCENTSMYS": null, "PipeInfo": null, "AssetLocation": null, "HowCollected": null, "HorizontalAccuracy": null, "CrewMember": null, "GlobalID": null, "created_user": null, "created_date": null, "last_edited_user": null, "last_edited_date": null, "SHAPE.STLength()": null }, "domains": { "Enabled": {"type": "inherited"}, "STATUS": {"type": "inherited"}, "NOMINALDIAMETER": {"type": "inherited"}, "DIAMETERUNITS": {"type": "inherited"}, "COATINGTYPE": {"type": "inherited"}, "LENGTHSOURCE": {"type": "inherited"}, "WALLTHICKNESS": {"type": "inherited"}, "OWNER": {"type": "inherited"}, "INSTALLATIONMETHOD": {"type": "inherited"}, "WARNINGTAPE": {"type": "inherited"}, "TRACERWIRE": {"type": "inherited"}, "PIPETESTTYPE": {"type": "inherited"}, "ELECTRICSURVEYINDICATOR": {"type": "inherited"}, "DESIGNCLASS": {"type": "inherited"}, "SYSTEMTYPE": {"type": "inherited"}, "CRITICALINDICATOR": {"type": "inherited"}, "PIGGABLE": {"type": "inherited"}, "MANUFACTURER": {"type": "inherited"}, "PINCHABLE": {"type": "inherited"}, "AssetLocation": {"type": "inherited"}, "HowCollected": {"type": "inherited"}, "CrewMember": {"type": "inherited"} } }, { "code": 5, "name": "Plastic PE", "defaultValues": { "Enabled": 1, "CREATIONUSER": null, "DATECREATED": null, "DATEMODIFIED": null, "LASTUSER": null, "LEGACYID": null, "INSTALLATIONDATE": null, "STATUS": "Active", "NOMINALDIAMETER": 2, "OUTSIDEDIAMETER": null, "DIAMETERUNITS": "inch", "OPERATINGPRESSURE": null, "COATINGTYPE": null, "MEASUREDLENGTH": null, "LENGTHSOURCE": "Field Measurement", "ACTUALINTERNALDIAMETER": null, "WALLTHICKNESS": null, "ASSETUNITCODE": null, "OWNER": "Smyrna", "INSERVICEDATE": null, "DATE_RETIRED": null, "INSTALLATIONMETHOD": "Direct Bore", "WARNINGTAPE": null, "TRACERWIRE": null, "WORKORDERID": null, "PROJECTNUMBER": null, "PIPETESTDATE": null, "PIPETESTDURATION": null, "PIPETESTPRESSURE": null, "PIPETESTTYPE": null, "ELECTRICSURVEYINDICATOR": null, "DESIGNPRESSUREENTERED": null, "DESIGNPRESSURESTANDARD": null, "DESIGNPRESSUREUNITOFMEASURE": null, "DESIGNCLASS": null, "DESIGNFACTOR": null, "Material": 5, "SYSTEMTYPE": "Distribution", "CRITICALINDICATOR": null, "PIGGABLE": "N", "BARCODE": null, "MANUFACTURER": null, "MANUFACTURELOTNO": null, "MANUFACTUREDATE": null, "PIPESPECIFICATION": null, "CPSYSTEM_GlobalID": null, "MAOPDESIGN": null, "MAOPTEST": null, "MAOPRECORD": null, "MAOPUNITOFMEASURE": null, "PRESSURESYSTEM_GlobalID": null, "EMERISOSYS_GlobalID": null, "PINCHABLE": "N", "PIPEGRADE": null, "GIRTHWELDTYPE": null, "LONGITUDINALSEAMORIENTATION": null, "GASTRACEWEIGHT": null, "SMYS": null, "PERCENTSMYS": null, "PipeInfo": null, "AssetLocation": null, "HowCollected": null, "HorizontalAccuracy": null, "CrewMember": null, "GlobalID": null, "created_user": null, "created_date": null, "last_edited_user": null, "last_edited_date": null, "SHAPE.STLength()": null }, "domains": { "Enabled": {"type": "inherited"}, "STATUS": {"type": "inherited"}, "NOMINALDIAMETER": {"type": "inherited"}, "DIAMETERUNITS": {"type": "inherited"}, "COATINGTYPE": {"type": "inherited"}, "LENGTHSOURCE": {"type": "inherited"}, "WALLTHICKNESS": {"type": "inherited"}, "OWNER": {"type": "inherited"}, "INSTALLATIONMETHOD": {"type": "inherited"}, "WARNINGTAPE": {"type": "inherited"}, "TRACERWIRE": {"type": "inherited"}, "PIPETESTTYPE": {"type": "inherited"}, "ELECTRICSURVEYINDICATOR": {"type": "inherited"}, "DESIGNCLASS": {"type": "inherited"}, "SYSTEMTYPE": {"type": "inherited"}, "CRITICALINDICATOR": {"type": "inherited"}, "PIGGABLE": {"type": "inherited"}, "MANUFACTURER": {"type": "inherited"}, "PINCHABLE": {"type": "inherited"}, "AssetLocation": {"type": "inherited"}, "HowCollected": {"type": "inherited"}, "CrewMember": {"type": "inherited"} } } ], "maxRecordCount": 2000, "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, "serviceItemId": "446eed2244384d878aba8823e548f49f" }