Name: City-owned waterline
Display Field: MATERIAL
Type: Feature Layer
Geometry Type: esriGeometryPolyline
Is View: true
Is Updatable View: true
Source Schema Changes Allowed: true
Sources
Description:
Copyright Text:
Min. Scale: 0
Max. Scale: 0
Default Visibility: true
Max Record Count: 1000
Supported query Formats: JSON, geoJSON, PBF
Use Standardized Queries: True
Extent:
XMin: 2189494.55535367
YMin: 368475.877334565
XMax: 2264487.39257242
YMax: 465655.982842728
Spatial Reference: 102724 (2267)
Drawing Info:
{"renderer":{"type":"uniqueValue","field1":"DIAMETER","field2":null,"field3":null,"defaultSymbol":null,"defaultLabel":null,"uniqueValueInfos":[{"symbol":{"type":"esriSLS","style":"esriSLSSolid","color":[0,112,255,255],"width":0.5},"value":"1.5","label":"<=10\"","description":""},{"symbol":{"type":"esriSLS","style":"esriSLSSolid","color":[0,112,255,255],"width":0.5},"value":"1.25","label":"<=10\"","description":""},{"symbol":{"type":"esriSLS","style":"esriSLSSolid","color":[0,112,255,255],"width":0.5},"value":"1","label":"<=10\"","description":""},{"symbol":{"type":"esriSLS","style":"esriSLSSolid","color":[0,112,255,255],"width":0.5},"value":"10","label":"<=10\"","description":""},{"symbol":{"type":"esriSLS","style":"esriSLSSolid","color":[0,112,255,255],"width":0.5},"value":"2.5","label":"<=10\"","description":""},{"symbol":{"type":"esriSLS","style":"esriSLSSolid","color":[0,112,255,255],"width":0.5},"value":"2","label":"<=10\"","description":""},{"symbol":{"type":"esriSLS","style":"esriSLSSolid","color":[0,112,255,255],"width":0.5},"value":"3","label":"<=10\"","description":""},{"symbol":{"type":"esriSLS","style":"esriSLSSolid","color":[0,112,255,255],"width":0.5},"value":"0.75","label":"<=10\"","description":""},{"symbol":{"type":"esriSLS","style":"esriSLSSolid","color":[0,112,255,255],"width":0.5},"value":"4.5","label":"<=10\"","description":""},{"symbol":{"type":"esriSLS","style":"esriSLSSolid","color":[0,112,255,255],"width":0.5},"value":"4","label":"<=10\"","description":""},{"symbol":{"type":"esriSLS","style":"esriSLSSolid","color":[0,112,255,255],"width":0.5},"value":"5","label":"<=10\"","description":""},{"symbol":{"type":"esriSLS","style":"esriSLSSolid","color":[0,112,255,255],"width":0.5},"value":"6","label":"<=10\"","description":""},{"symbol":{"type":"esriSLS","style":"esriSLSSolid","color":[0,112,255,255],"width":0.5},"value":"7","label":"<=10\"","description":""},{"symbol":{"type":"esriSLS","style":"esriSLSSolid","color":[0,112,255,255],"width":0.5},"value":"8","label":"<=10\"","description":""},{"symbol":{"type":"esriSLS","style":"esriSLSSolid","color":[0,112,255,255],"width":0.5},"value":"-1","label":"<=10\"","description":""},{"symbol":{"type":"esriSLS","style":"esriSLSSolid","color":[0,112,255,255],"width":0.5},"value":"0","label":"<=10\"","description":""},{"symbol":{"type":"esriSLS","style":"esriSLSSolid","color":[0,112,255,255],"width":1.5},"value":"12","label":"12\" - 20\"","description":""},{"symbol":{"type":"esriSLS","style":"esriSLSSolid","color":[0,112,255,255],"width":1.5},"value":"14","label":"12\" - 20\"","description":""},{"symbol":{"type":"esriSLS","style":"esriSLSSolid","color":[0,112,255,255],"width":1.5},"value":"15","label":"12\" - 20\"","description":""},{"symbol":{"type":"esriSLS","style":"esriSLSSolid","color":[0,112,255,255],"width":1.5},"value":"16","label":"12\" - 20\"","description":""},{"symbol":{"type":"esriSLS","style":"esriSLSSolid","color":[0,112,255,255],"width":1.5},"value":"18","label":"12\" - 20\"","description":""},{"symbol":{"type":"esriSLS","style":"esriSLSSolid","color":[0,112,255,255],"width":1.5},"value":"20","label":"12\" - 20\"","description":""},{"symbol":{"type":"esriSLS","style":"esriSLSSolid","color":[0,92,230,255],"width":2.2},"value":"24","label":"24\"+","description":""},{"symbol":{"type":"esriSLS","style":"esriSLSSolid","color":[0,92,230,255],"width":2.2},"value":"30","label":"24\"+","description":""},{"symbol":{"type":"esriSLS","style":"esriSLSSolid","color":[0,92,230,255],"width":2.2},"value":"36","label":"24\"+","description":""},{"symbol":{"type":"esriSLS","style":"esriSLSSolid","color":[0,92,230,255],"width":2.2},"value":"40","label":"24\"+","description":""},{"symbol":{"type":"esriSLS","style":"esriSLSSolid","color":[0,92,230,255],"width":2.2},"value":"42","label":"24\"+","description":""},{"symbol":{"type":"esriSLS","style":"esriSLSSolid","color":[0,92,230,255],"width":2.2},"value":"48","label":"24\"+","description":""},{"symbol":{"type":"esriSLS","style":"esriSLSSolid","color":[0,92,230,255],"width":2.2},"value":"54","label":"24\"+","description":""},{"symbol":{"type":"esriSLS","style":"esriSLSSolid","color":[0,92,230,255],"width":2.2},"value":"60","label":"24\"+","description":""},{"symbol":{"type":"esriSLS","style":"esriSLSSolid","color":[0,92,230,255],"width":2.2},"value":"66","label":"24\"+","description":""},{"symbol":{"type":"esriSLS","style":"esriSLSSolid","color":[0,92,230,255],"width":2.2},"value":"72","label":"24\"+","description":""},{"symbol":{"type":"esriSLS","style":"esriSLSSolid","color":[0,92,230,255],"width":2.2},"value":"75","label":"24\"+","description":""}],"fieldDelimiter":","},"transparency":0,"labelingInfo":null}
HasZ: false
HasM: true
Has Attachments: false
Has Geometry Properties: true
HTML Popup Type: esriServerHTMLPopupTypeNone
Object ID Field: OBJECTID
Unique ID Field:
IsSystemMaintained : True
Global ID Field:
Type ID Field: DIAMETER
Fields:
- OBJECTID (type: esriFieldTypeOID, alias: OBJECTID, SQL Type: sqlTypeOther, length: 0, nullable: false, editable: false)
- FACILITYID (type: esriFieldTypeString, alias: UID, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
- INSTALLDATE (type: esriFieldTypeDate, alias: A_INSTALL_DATE, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
- MATERIAL (type: esriFieldTypeString, alias: X_MATERIAL, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true, Coded Values: [ACP: ACP], [CIP: CIP], [CONCRETE: CONCRETE], ... 11 more ...)
- DIAMETER (type: esriFieldTypeDouble, alias: X_NOM_DIA, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0.75: 3/4"], [1: 1"], [1.25: 1 1/4"], ... 30 more ...)
- WATERTYPE (type: esriFieldTypeString, alias: Water_Type, SQL Type: sqlTypeOther, length: 30, nullable: true, editable: true, Coded Values: [Potable: Potable Water], [Raw: Raw Water], [Reclaimed: Reclaimed Water], ... 3 more ...)
- X_FUNCTION (type: esriFieldTypeString, alias: X_FUNCTION, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [LOCAL: LOCAL], [PRIMARY_FEED: PRIMARY_FEED], [UNKNOWN: UNKNOWN])
- TRANSMISSION (type: esriFieldTypeString, alias: TRANSMISSION, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true, Coded Values: [YES: YES], [NO: NO], [UNKNOWN: UNKNOWN])
- Shape__Length (type: esriFieldTypeDouble, alias: Shape__Length, SQL Type: sqlTypeDouble, nullable: true, editable: false)
Types:
ID: 1.5
Name: 1.5
Domains:
- Field Name: MATERIAL
Inherited
- Field Name: DIAMETER
Inherited
- Field Name: WATERTYPE
Inherited
- Field Name: TRANSMISSION
Inherited
Templates:
Name: <=10"
Description:
Drawing Tool: esriFeatureEditToolLine
Prototype:
Attributes:
- INSTALLDATE: -2177452800000
- MATERIAL: PVC
- DIAMETER: 1.5
- WATERTYPE: Potable
ID: 1.25
Name: 1.25
Domains:
- Field Name: MATERIAL
Inherited
- Field Name: DIAMETER
Inherited
- Field Name: WATERTYPE
Inherited
- Field Name: TRANSMISSION
Inherited
Templates:
Name: <=10"
Description:
Drawing Tool: esriFeatureEditToolLine
Prototype:
Attributes:
- INSTALLDATE: -2177452800000
- MATERIAL: PVC
- DIAMETER: 1.25
- WATERTYPE: Potable
ID: 1
Name: 1
Domains:
- Field Name: MATERIAL
Inherited
- Field Name: DIAMETER
Inherited
- Field Name: WATERTYPE
Inherited
- Field Name: TRANSMISSION
Inherited
Templates:
Name: <=10"
Description:
Drawing Tool: esriFeatureEditToolLine
Prototype:
Attributes:
- INSTALLDATE: -2177452800000
- MATERIAL: PVC
- DIAMETER: 1
- WATERTYPE: Potable
ID: 10
Name: 10
Domains:
- Field Name: MATERIAL
Inherited
- Field Name: DIAMETER
Inherited
- Field Name: WATERTYPE
Inherited
- Field Name: TRANSMISSION
Inherited
Templates:
Name: <=10"
Description:
Drawing Tool: esriFeatureEditToolLine
Prototype:
Attributes:
- INSTALLDATE: -2177452800000
- MATERIAL: PVC
- DIAMETER: 10
- WATERTYPE: Potable
ID: 2.5
Name: 2.5
Domains:
- Field Name: MATERIAL
Inherited
- Field Name: DIAMETER
Inherited
- Field Name: WATERTYPE
Inherited
- Field Name: TRANSMISSION
Inherited
Templates:
Name: <=10"
Description:
Drawing Tool: esriFeatureEditToolLine
Prototype:
Attributes:
- INSTALLDATE: -2177452800000
- MATERIAL: PVC
- DIAMETER: 2.5
- WATERTYPE: Potable
ID: 2
Name: 2
Domains:
- Field Name: MATERIAL
Inherited
- Field Name: DIAMETER
Inherited
- Field Name: WATERTYPE
Inherited
- Field Name: TRANSMISSION
Inherited
Templates:
Name: <=10"
Description:
Drawing Tool: esriFeatureEditToolLine
Prototype:
Attributes:
- INSTALLDATE: -2177452800000
- MATERIAL: PVC
- DIAMETER: 2
- WATERTYPE: Potable
ID: 3
Name: 3
Domains:
- Field Name: MATERIAL
Inherited
- Field Name: DIAMETER
Inherited
- Field Name: WATERTYPE
Inherited
- Field Name: TRANSMISSION
Inherited
Templates:
Name: <=10"
Description:
Drawing Tool: esriFeatureEditToolLine
Prototype:
Attributes:
- INSTALLDATE: -2177452800000
- MATERIAL: PVC
- DIAMETER: 3
- WATERTYPE: Potable
ID: 0.75
Name: 0.75
Domains:
- Field Name: MATERIAL
Inherited
- Field Name: DIAMETER
Inherited
- Field Name: WATERTYPE
Inherited
- Field Name: TRANSMISSION
Inherited
Templates:
Name: <=10"
Description:
Drawing Tool: esriFeatureEditToolLine
Prototype:
Attributes:
- INSTALLDATE: -2177452800000
- MATERIAL: PVC
- DIAMETER: 0.75
- WATERTYPE: Potable
ID: 4.5
Name: 4.5
Domains:
- Field Name: MATERIAL
Inherited
- Field Name: DIAMETER
Inherited
- Field Name: WATERTYPE
Inherited
- Field Name: TRANSMISSION
Inherited
Templates:
Name: <=10"
Description:
Drawing Tool: esriFeatureEditToolLine
Prototype:
Attributes:
- INSTALLDATE: -2177452800000
- MATERIAL: PVC
- DIAMETER: 4.5
- WATERTYPE: Potable
ID: 4
Name: 4
Domains:
- Field Name: MATERIAL
Inherited
- Field Name: DIAMETER
Inherited
- Field Name: WATERTYPE
Inherited
- Field Name: TRANSMISSION
Inherited
Templates:
Name: <=10"
Description:
Drawing Tool: esriFeatureEditToolLine
Prototype:
Attributes:
- INSTALLDATE: -2177452800000
- MATERIAL: PVC
- DIAMETER: 4
- WATERTYPE: Potable
ID: 5
Name: 5
Domains:
- Field Name: MATERIAL
Inherited
- Field Name: DIAMETER
Inherited
- Field Name: WATERTYPE
Inherited
- Field Name: TRANSMISSION
Inherited
Templates:
Name: <=10"
Description:
Drawing Tool: esriFeatureEditToolLine
Prototype:
Attributes:
- INSTALLDATE: -2177452800000
- MATERIAL: PVC
- DIAMETER: 5
- WATERTYPE: Potable
ID: 6
Name: 6
Domains:
- Field Name: MATERIAL
Inherited
- Field Name: DIAMETER
Inherited
- Field Name: WATERTYPE
Inherited
- Field Name: TRANSMISSION
Inherited
Templates:
Name: <=10"
Description:
Drawing Tool: esriFeatureEditToolLine
Prototype:
Attributes:
- INSTALLDATE: -2177452800000
- MATERIAL: PVC
- DIAMETER: 6
- WATERTYPE: Potable
ID: 7
Name: 7
Domains:
- Field Name: MATERIAL
Inherited
- Field Name: DIAMETER
Inherited
- Field Name: WATERTYPE
Inherited
- Field Name: TRANSMISSION
Inherited
Templates:
Name: <=10"
Description:
Drawing Tool: esriFeatureEditToolLine
Prototype:
Attributes:
- INSTALLDATE: -2177452800000
- MATERIAL: PVC
- DIAMETER: 7
- WATERTYPE: Potable
ID: 8
Name: 8
Domains:
- Field Name: MATERIAL
Inherited
- Field Name: DIAMETER
Inherited
- Field Name: WATERTYPE
Inherited
- Field Name: TRANSMISSION
Inherited
Templates:
Name: <=10"
Description:
Drawing Tool: esriFeatureEditToolLine
Prototype:
Attributes:
- INSTALLDATE: -2177452800000
- MATERIAL: PVC
- DIAMETER: 8
- WATERTYPE: Potable
ID: -1
Name: -1
Domains:
- Field Name: MATERIAL
Inherited
- Field Name: DIAMETER
Inherited
- Field Name: WATERTYPE
Inherited
- Field Name: TRANSMISSION
Inherited
Templates:
Name: <=10"
Description:
Drawing Tool: esriFeatureEditToolLine
Prototype:
Attributes:
- INSTALLDATE: -2177452800000
- MATERIAL: PVC
- DIAMETER: -1
- WATERTYPE: Potable
ID: 0
Name: 0
Domains:
- Field Name: MATERIAL
Inherited
- Field Name: DIAMETER
Inherited
- Field Name: WATERTYPE
Inherited
- Field Name: TRANSMISSION
Inherited
Templates:
Name: waterline
Description:
Drawing Tool: esriFeatureEditToolLine
Prototype:
Attributes:
- INSTALLDATE: -2177452800000
- MATERIAL: PVC
- DIAMETER: 0
- WATERTYPE: Potable
Name: <=10"
Description:
Drawing Tool: esriFeatureEditToolLine
Prototype:
Attributes:
- INSTALLDATE: -2177452800000
- MATERIAL: PVC
- DIAMETER: 0
- WATERTYPE: Potable
ID: 12
Name: 12
Domains:
- Field Name: MATERIAL
Inherited
- Field Name: DIAMETER
Inherited
- Field Name: WATERTYPE
Inherited
- Field Name: TRANSMISSION
Inherited
Templates:
Name: 12" - 20"
Description:
Drawing Tool: esriFeatureEditToolLine
Prototype:
Attributes:
- INSTALLDATE: -2177452800000
- MATERIAL: PVC
- DIAMETER: 12
- WATERTYPE: Potable
ID: 14
Name: 14
Domains:
- Field Name: MATERIAL
Inherited
- Field Name: DIAMETER
Inherited
- Field Name: WATERTYPE
Inherited
- Field Name: TRANSMISSION
Inherited
Templates:
Name: 12" - 20"
Description:
Drawing Tool: esriFeatureEditToolLine
Prototype:
Attributes:
- INSTALLDATE: -2177452800000
- MATERIAL: PVC
- DIAMETER: 14
- WATERTYPE: Potable
ID: 15
Name: 15
Domains:
- Field Name: MATERIAL
Inherited
- Field Name: DIAMETER
Inherited
- Field Name: WATERTYPE
Inherited
- Field Name: TRANSMISSION
Inherited
Templates:
Name: 12" - 20"
Description:
Drawing Tool: esriFeatureEditToolLine
Prototype:
Attributes:
- INSTALLDATE: -2177452800000
- MATERIAL: PVC
- DIAMETER: 15
- WATERTYPE: Potable
ID: 16
Name: 16
Domains:
- Field Name: MATERIAL
Inherited
- Field Name: DIAMETER
Inherited
- Field Name: WATERTYPE
Inherited
- Field Name: TRANSMISSION
Inherited
Templates:
Name: 12" - 20"
Description:
Drawing Tool: esriFeatureEditToolLine
Prototype:
Attributes:
- INSTALLDATE: -2177452800000
- MATERIAL: PVC
- DIAMETER: 16
- WATERTYPE: Potable
ID: 18
Name: 18
Domains:
- Field Name: MATERIAL
Inherited
- Field Name: DIAMETER
Inherited
- Field Name: WATERTYPE
Inherited
- Field Name: TRANSMISSION
Inherited
Templates:
Name: 12" - 20"
Description:
Drawing Tool: esriFeatureEditToolLine
Prototype:
Attributes:
- INSTALLDATE: -2177452800000
- MATERIAL: PVC
- DIAMETER: 18
- WATERTYPE: Potable
ID: 20
Name: 20
Domains:
- Field Name: MATERIAL
Inherited
- Field Name: DIAMETER
Inherited
- Field Name: WATERTYPE
Inherited
- Field Name: TRANSMISSION
Inherited
Templates:
Name: 12" - 20"
Description:
Drawing Tool: esriFeatureEditToolLine
Prototype:
Attributes:
- INSTALLDATE: -2177452800000
- MATERIAL: PVC
- DIAMETER: 20
- WATERTYPE: Potable
ID: 24
Name: 24
Domains:
- Field Name: MATERIAL
Inherited
- Field Name: DIAMETER
Inherited
- Field Name: WATERTYPE
Inherited
- Field Name: TRANSMISSION
Inherited
Templates:
Name: 24"+
Description:
Drawing Tool: esriFeatureEditToolLine
Prototype:
Attributes:
- INSTALLDATE: -2177452800000
- MATERIAL: PVC
- DIAMETER: 24
- WATERTYPE: Potable
ID: 30
Name: 30
Domains:
- Field Name: MATERIAL
Inherited
- Field Name: DIAMETER
Inherited
- Field Name: WATERTYPE
Inherited
- Field Name: TRANSMISSION
Inherited
Templates:
Name: 24"+
Description:
Drawing Tool: esriFeatureEditToolLine
Prototype:
Attributes:
- INSTALLDATE: -2177452800000
- MATERIAL: PVC
- DIAMETER: 30
- WATERTYPE: Potable
ID: 36
Name: 36
Domains:
- Field Name: MATERIAL
Inherited
- Field Name: DIAMETER
Inherited
- Field Name: WATERTYPE
Inherited
- Field Name: TRANSMISSION
Inherited
Templates:
Name: 24"+
Description:
Drawing Tool: esriFeatureEditToolLine
Prototype:
Attributes:
- INSTALLDATE: -2177452800000
- MATERIAL: PVC
- DIAMETER: 36
- WATERTYPE: Potable
ID: 40
Name: 40
Domains:
- Field Name: MATERIAL
Inherited
- Field Name: DIAMETER
Inherited
- Field Name: WATERTYPE
Inherited
- Field Name: TRANSMISSION
Inherited
Templates:
Name: 24"+
Description:
Drawing Tool: esriFeatureEditToolLine
Prototype:
Attributes:
- INSTALLDATE: -2177452800000
- MATERIAL: PVC
- DIAMETER: 40
- WATERTYPE: Potable
ID: 42
Name: 42
Domains:
- Field Name: MATERIAL
Inherited
- Field Name: DIAMETER
Inherited
- Field Name: WATERTYPE
Inherited
- Field Name: TRANSMISSION
Inherited
Templates:
Name: 24"+
Description:
Drawing Tool: esriFeatureEditToolLine
Prototype:
Attributes:
- INSTALLDATE: -2177452800000
- MATERIAL: PVC
- DIAMETER: 42
- WATERTYPE: Potable
ID: 48
Name: 48
Domains:
- Field Name: MATERIAL
Inherited
- Field Name: DIAMETER
Inherited
- Field Name: WATERTYPE
Inherited
- Field Name: TRANSMISSION
Inherited
Templates:
Name: 24"+
Description:
Drawing Tool: esriFeatureEditToolLine
Prototype:
Attributes:
- INSTALLDATE: -2177452800000
- MATERIAL: PVC
- DIAMETER: 48
- WATERTYPE: Potable
ID: 54
Name: 54
Domains:
- Field Name: MATERIAL
Inherited
- Field Name: DIAMETER
Inherited
- Field Name: WATERTYPE
Inherited
- Field Name: TRANSMISSION
Inherited
Templates:
Name: 24"+
Description:
Drawing Tool: esriFeatureEditToolLine
Prototype:
Attributes:
- INSTALLDATE: -2177452800000
- MATERIAL: PVC
- DIAMETER: 54
- WATERTYPE: Potable
ID: 60
Name: 60
Domains:
- Field Name: MATERIAL
Inherited
- Field Name: DIAMETER
Inherited
- Field Name: WATERTYPE
Inherited
- Field Name: TRANSMISSION
Inherited
Templates:
Name: 24"+
Description:
Drawing Tool: esriFeatureEditToolLine
Prototype:
Attributes:
- INSTALLDATE: -2177452800000
- MATERIAL: PVC
- DIAMETER: 60
- WATERTYPE: Potable
ID: 66
Name: 66
Domains:
- Field Name: MATERIAL
Inherited
- Field Name: DIAMETER
Inherited
- Field Name: WATERTYPE
Inherited
- Field Name: TRANSMISSION
Inherited
Templates:
Name: 24"+
Description:
Drawing Tool: esriFeatureEditToolLine
Prototype:
Attributes:
- INSTALLDATE: -2177452800000
- MATERIAL: PVC
- DIAMETER: 66
- WATERTYPE: Potable
ID: 72
Name: 72
Domains:
- Field Name: MATERIAL
Inherited
- Field Name: DIAMETER
Inherited
- Field Name: WATERTYPE
Inherited
- Field Name: TRANSMISSION
Inherited
Templates:
Name: 24"+
Description:
Drawing Tool: esriFeatureEditToolLine
Prototype:
Attributes:
- INSTALLDATE: -2177452800000
- MATERIAL: PVC
- DIAMETER: 72
- WATERTYPE: Potable
ID: 75
Name: 75
Domains:
- Field Name: MATERIAL
Inherited
- Field Name: DIAMETER
Inherited
- Field Name: WATERTYPE
Inherited
- Field Name: TRANSMISSION
Inherited
Templates:
Name: 24"+
Description:
Drawing Tool: esriFeatureEditToolLine
Prototype:
Attributes:
- INSTALLDATE: -2177452800000
- MATERIAL: PVC
- DIAMETER: 75
- WATERTYPE: Potable
Is Data Versioned: false
Has Contingent Values: false
Supports Rollback On Failure Parameter: true
Last Edit Date: 8/12/2026 2:53:27 PM
Schema Last Edit Date: 8/12/2026 2:53:27 PM
Data Last Edit Date: 8/12/2026 2:53:27 PM
Supported Operations:
Query
Query Pivot
Query Top Features
Query Analytic
Query Bins
Generate Renderer
Validate SQL
Get Estimates
ConvertFormat