Name: LCRMetersEngineer_Projects_Test

Display Field: Join_Count

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description:

Copyright Text:

Min. Scale: 0

Max. Scale: 0

Default Visibility: true

Max Record Count: 2000

Supported query Formats: JSON, geoJSON, PBF

Use Standardized Queries: True

Extent:

XMin: -10714626.0320502
YMin: 5029433.06024547
XMax: -10672532.0856829
YMax: 5068750.34641612
Spatial Reference: PROJCS["WGS_1984_Web_Mercator_Auxiliary_Sphere",GEOGCS["GCS_WGS_1984",DATUM["D_WGS_1984",SPHEROID["WGS_1984",6378137.0,298.257223563]],PRIMEM["Greenwich",0.0],UNIT["Degree",0.0174532925199433]],PROJECTION["Mercator_Auxiliary_Sphere"],PARAMETER["False_Easting",0.0],PARAMETER["False_Northing",0.0],PARAMETER["Central_Meridian",0.0],PARAMETER["Standard_Parallel_1",0.0],PARAMETER["Auxiliary_Sphere_Type",0.0],UNIT["Meter",1.0]],VERTCS["NAVD_1988",VDATUM["North_American_Vertical_Datum_1988"],PARAMETER["Vertical_Shift",0.0],PARAMETER["Direction",1.0],UNIT["Foot_US",0.3048006096012192]]

Drawing Info:

{"renderer":{"type":"uniqueValue","field1":"Material_Category","defaultSymbol":{"type":"esriSMS","style":"esriSMSCircle","color":[130,130,130,255],"size":9,"angle":0,"xoffset":0,"yoffset":0,"outline":{"color":[0,0,0,255],"width":0.7}},"defaultLabel":"","uniqueValueGroups":[{"heading":"Category","classes":[{"label":"Galvanized Requiring Replacement","description":"Galvanized Requiring Replacement","symbol":{"type":"esriSMS","style":"esriSMSCircle","color":[204,204,204,255],"size":9,"angle":0,"xoffset":0,"yoffset":0,"outline":{"color":[0,0,0,255],"width":0.3}},"values":[["Galvanized Requiring Replacement"]]},{"label":"Lead","description":"Lead","symbol":{"type":"esriSMS","style":"esriSMSCircle","color":[0,0,0,255],"size":9,"angle":0,"xoffset":0,"yoffset":0,"outline":{"color":[255,255,255,255],"width":0.1}},"values":[["Lead"]]},{"label":"Lead Status Unknown","description":"Lead Status Unknown","symbol":{"type":"esriSMS","style":"esriSMSCircle","color":[168,168,0,255],"size":9,"angle":0,"xoffset":0,"yoffset":0,"outline":{"color":[0,0,0,255],"width":0.3}},"values":[["Lead Status Unknown"]]}]}],"uniqueValueInfos":[{"symbol":{"type":"esriSMS","style":"esriSMSCircle","color":[204,204,204,255],"size":9,"angle":0,"xoffset":0,"yoffset":0,"outline":{"color":[0,0,0,255],"width":0.3}},"value":"Galvanized Requiring Replacement","label":"Galvanized Requiring Replacement"},{"symbol":{"type":"esriSMS","style":"esriSMSCircle","color":[0,0,0,255],"size":9,"angle":0,"xoffset":0,"yoffset":0,"outline":{"color":[255,255,255,255],"width":0.1}},"value":"Lead","label":"Lead"},{"symbol":{"type":"esriSMS","style":"esriSMSCircle","color":[168,168,0,255],"size":9,"angle":0,"xoffset":0,"yoffset":0,"outline":{"color":[0,0,0,255],"width":0.3}},"value":"Lead Status Unknown","label":"Lead Status Unknown"}],"fieldDelimiter":",","authoringInfo":{"colorRamp":{"type":"multipart","colorRamps":[{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[237,207,252,255],"toColor":[237,207,252,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[182,252,182,255],"toColor":[182,252,182,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[252,221,182,255],"toColor":[252,221,182,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[192,249,252,255],"toColor":[192,249,252,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[252,182,190,255],"toColor":[252,182,190,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[241,252,179,255],"toColor":[241,252,179,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[202,252,218,255],"toColor":[202,252,218,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[207,224,252,255],"toColor":[207,224,252,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[182,195,252,255],"toColor":[182,195,252,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[252,182,250,255],"toColor":[252,182,250,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[252,215,215,255],"toColor":[252,215,215,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[247,252,215,255],"toColor":[247,252,215,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[252,202,227,255],"toColor":[252,202,227,255]}]}}},"scaleSymbols":true,"transparency":0,"labelingInfo":null}

HasZ: true

HasM: true

Has Attachments: false

Has Geometry Properties: false

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Object ID Field: OBJECTID

Unique ID Field:

Name : OBJECTID

IsSystemMaintained : True

Global ID Field: GlobalID

Type ID Field: Material_Category

Fields:

• OBJECTID (type: esriFieldTypeOID, alias: OBJECTID, SQL Type: sqlTypeOther, length: 0, nullable: false, editable: false)
• Join_Count (type: esriFieldTypeInteger, alias: Join_Count, SQL Type: sqlTypeOther, nullable: true, editable: true)
• TARGET_FID (type: esriFieldTypeInteger, alias: TARGET_FID, SQL Type: sqlTypeOther, nullable: true, editable: true)
• ASSETGROUP (type: esriFieldTypeInteger, alias: Asset group, SQL Type: sqlTypeOther, nullable: true, editable: true)
• ASSETTYPE (type: esriFieldTypeSmallInteger, alias: Asset type, SQL Type: sqlTypeOther, nullable: true, editable: true)
• LASTUPDATE (type: esriFieldTypeDate, alias: Last update, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• UPDATEDBY (type: esriFieldTypeString, alias: Updated by, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• ASSETID (type: esriFieldTypeString, alias: Asset ID, SQL Type: sqlTypeOther, length: 64, nullable: true, editable: true)
• SYMBOLROTATION (type: esriFieldTypeSmallInteger, alias: Symbol Rotation, SQL Type: sqlTypeOther, nullable: true, editable: true)
• SAPCONNECTIONOBJECT (type: esriFieldTypeInteger, alias: Connection Object, SQL Type: sqlTypeOther, nullable: true, editable: true)
• SAPPREMISE (type: esriFieldTypeInteger, alias: Premise, SQL Type: sqlTypeOther, nullable: true, editable: true)
• SAPDEVICELOCATION (type: esriFieldTypeInteger, alias: Device Location, SQL Type: sqlTypeOther, nullable: true, editable: true)
• GUID (type: esriFieldTypeGUID, alias: GUID, SQL Type: sqlTypeOther, length: 38, nullable: true, editable: true)
• ADDRESS (type: esriFieldTypeString, alias: Address, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• LCR1 (type: esriFieldTypeSmallInteger, alias: LCR Material 1 mtr to sb, SQL Type: sqlTypeOther, nullable: true, editable: true)
• LCR2 (type: esriFieldTypeSmallInteger, alias: LCR Material 2 sb to tap, SQL Type: sqlTypeOther, nullable: true, editable: true)
• LCR1_LCR2_Concatenate (type: esriFieldTypeString, alias: Concatenate Material, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Material_Category (type: esriFieldTypeString, alias: Category, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• ADDRESS_1 (type: esriFieldTypeString, alias: Full Address, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• POINT_X (type: esriFieldTypeDouble, alias: POINT_X, SQL Type: sqlTypeOther, nullable: true, editable: true)
• POINT_Y (type: esriFieldTypeDouble, alias: POINT_Y, SQL Type: sqlTypeOther, nullable: true, editable: true)
• POINT_Z (type: esriFieldTypeDouble, alias: POINT_Z, SQL Type: sqlTypeOther, nullable: true, editable: true)
• POINT_M (type: esriFieldTypeDouble, alias: POINT_M, SQL Type: sqlTypeOther, nullable: true, editable: true)
• DATECREATED (type: esriFieldTypeDate, alias: Date Created, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• CREATIONUSER (type: esriFieldTypeString, alias: Creation User, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
• DATEMODIFIED (type: esriFieldTypeDate, alias: Date Modified, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• MODIFICATIONUSER (type: esriFieldTypeString, alias: Modification User, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
• PROJECTTYPE (type: esriFieldTypeString, alias: Project Type, SQL Type: sqlTypeOther, length: 30, nullable: true, editable: true)
• PROJECTNUMBER (type: esriFieldTypeString, alias: Project Number, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true)
• PROJECTYEAR (type: esriFieldTypeString, alias: Project Year, SQL Type: sqlTypeOther, length: 4, nullable: true, editable: true)
• CONTACT (type: esriFieldTypeString, alias: Contact, SQL Type: sqlTypeOther, length: 30, nullable: true, editable: true)
• GMAINABANFT (type: esriFieldTypeDouble, alias: Gas Main Abandonment (FT), SQL Type: sqlTypeOther, nullable: true, editable: true)
• WMAINABANFT (type: esriFieldTypeDouble, alias: Water Main Abandonment (FT), SQL Type: sqlTypeOther, nullable: true, editable: true)
• GSVREPNUM (type: esriFieldTypeInteger, alias: Number of Gas Service Replacements, SQL Type: sqlTypeOther, nullable: true, editable: true)
• WSVREPNUM (type: esriFieldTypeInteger, alias: Number of Water , SQL Type: sqlTypeOther, nullable: true, editable: true)
• COMMENTS (type: esriFieldTypeString, alias: Comments, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• LIFECYCLESTATUS (type: esriFieldTypeString, alias: Lifecycle Status, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• DESCRIPTION (type: esriFieldTypeString, alias: Project Description, SQL Type: sqlTypeOther, length: 265, nullable: true, editable: true)
• DESIGNSTART (type: esriFieldTypeDate, alias: Design Start Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• CONSTRUCTIONSTART (type: esriFieldTypeDate, alias: Construction Start Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• PHONE (type: esriFieldTypeString, alias: Phone, SQL Type: sqlTypeOther, length: 15, nullable: true, editable: true)
• EMAIL (type: esriFieldTypeString, alias: Email, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
• ENDDATE (type: esriFieldTypeDate, alias: Project End Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• GlobalID (type: esriFieldTypeGlobalID, alias: GlobalID, SQL Type: sqlTypeOther, length: 38, nullable: false, editable: false)

Types:

ID: Galvanized Requiring Replacement
Name: Galvanized Requiring Replacement
Domains:

Templates:

Name: Galvanized Requiring Replacement
Description:
Drawing Tool: esriFeatureEditToolPoint
Prototype:

Attributes:

• ASSETGROUP: 0
• ASSETTYPE: 0
• Material_Category: Galvanized Requiring Replacement

---

ID: Lead
Name: Lead
Domains:

Templates:

Name: Lead
Description:
Drawing Tool: esriFeatureEditToolPoint
Prototype:

Attributes:

• ASSETGROUP: 0
• ASSETTYPE: 0
• Material_Category: Lead

---

ID: Lead Status Unknown
Name: Lead Status Unknown
Domains:

Templates:

Name: Lead Status Unknown
Description:
Drawing Tool: esriFeatureEditToolPoint
Prototype:

Attributes:

• ASSETGROUP: 0
• ASSETTYPE: 0
• Material_Category: Lead Status Unknown

---

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 5/20/2024 4:21:21 PM

Schema Last Edit Date: 5/20/2024 4:21:21 PM

Data Last Edit Date: 4/16/2024 3:36:27 PM

Supported Operations:   Query   Query Pivot   Query Top Features   Query Analytic   Query Bins   Generate Renderer   Validate SQL   Get Estimates   ConvertFormat