Name: Storage Tanks
Display Field: name
Type: Feature Layer
Geometry Type: esriGeometryPoint
Description:
Copyright Text:
Min. Scale: 2311163
Max. Scale: 0
Default Visibility: true
Max Record Count: 2000
Supported query Formats: JSON, geoJSON, PBF
Use Standardized Queries: True
Extent:
XMin: 2905019.9005787
YMin: 9934319.5691931
XMax: 3391760.33893972
YMax: 10421060.0075541
Spatial Reference: 102739 (2277)
Drawing Info:
{"renderer":{"type":"uniqueValue","field1":"ASSETTYPE","uniqueValueInfos":[{"symbol":{"type":"esriPMS","url":"a6960fd67f887a82f6e24ec28554d08f","imageData":"iVBORw0KGgoAAAANSUhEUgAAABAAAAASCAYAAABSO15qAAAACXBIWXMAAA7EAAAOxAGVKw4bAAABV0lEQVQ4jc2TsW7CMBCGPwsWzOqpQ1jDimfmrEF+B/oYlMeAdwigMmXObFayEqSyeI1H3IVEbUnVoi79F0unu8/+z3d9/qj+10CaprrX6+kQgg4hPAEIId6Ay/V63e92O9sJMMbMgflgMNBKKaSUDIfDNvF0OuGcWxhjLLDMsmzfAowx8xDCSmtNHMdIKe+eOplMACjLUhdF8WqMec6ybN0HCCGskiQhiqIfPTcX5Hm+AtatBefcrwAA3vv7Hlhrqeua8XiMUqqz0DnH8XikLMt7QJIkWGvZbrdIKWka2RQ2ZxzHTKdTiqL4DFBKMZvN8N7jnMN7j/eeuq4ZjUatPaVUt4VGUspf96IT8Kj+EeCROaiqCuDyEbDM83yhtW5Htkvee6qqar5w3QI2m82LMcYeDoeFtVZHUfTdMiGEsEKIz8sEcAvs0zTV5/P58XVudEuwX+Pf6R3jOq5EzRDKRgAAAABJRU5ErkJggg==","contentType":"image/png","width":12,"height":13,"angle":0,"xoffset":0,"yoffset":0},"value":"564","label":"Ground Storage Tank"},{"symbol":{"type":"esriPMS","url":"57c6afa4703d20373e89f3c3603d727e","imageData":"iVBORw0KGgoAAAANSUhEUgAAABAAAAAjCAYAAACdHYpiAAAACXBIWXMAAA7EAAAOxAGVKw4bAAABxUlEQVRIie2VMY+bQBSEZ5Ebb03jK6CFeq+lpsEIzG/w5Wec8zfsmtaLuDTU1FtDjaW7wrh9DRKkMSgYkvhySufpHtr3aWZA7AJf1OK/AXzffwIATdNWSZKouwBRFL20bbtmjAkAq/75ZrMBgI+u61TXdbtfgQsACIJAMMZ2y+XSMwwDtm0DAHRdBwAQEeq6XhGRl+e5F0WRaprGT9P0fQEAjLGdaZqe4zjgnE9scs5hGAYAwLIsSCnF5XJJATz3AM+27dnlOQkhkGWZGHWglIKu63+F1HWNoiiGeVRiHMewLAumaYJzPoJVVYXz+YyyLIduRgDXdUFEUEpBKYW6rmd7CMMQACClnDrQdR2u6w4zEQ3LtzEmDohocvB3fVzBHwOg67ofeZ57rut+psS3ASClXIdh+BbHsWcYBkzTHBVFRCAiFEXR298fj8dvowhSynUQBKKqqnVVVa+3Ua62923b7iefcq8kSVQQBNA07XW73Y6sHw4H3C5PAP+iB+ABeAA+Aeh/bXcBkiRRURSpLMuE4zgAgLIswRhTc3fkrIOmafzT6ZTGcSwAgDGmAHy/O0Kapu8Anvsb+jrfF2EG9Ed9+S38BGhg0XkVIO5HAAAAAElFTkSuQmCC","contentType":"image/png","width":12,"height":26,"angle":0,"xoffset":0,"yoffset":0},"value":"563","label":"Elevated Storage Tank"},{"symbol":{"type":"esriPMS","url":"d9e49f70e43c701c1c4f644abd8c22c1","imageData":"iVBORw0KGgoAAAANSUhEUgAAAA8AAAAgCAYAAADNLCKpAAAACXBIWXMAAA7EAAAOxAGVKw4bAAABaElEQVQ4je2VPXLCMBCFnxgoUO3GFNCKFtP6BuAxcAdyjIRjwCk0UEFLrdp2iQrSbGu7wSgNEiEJkBkoeZ129tu/0ezW8YDqT4ejKGo1Go0AAKqq2gOAlFJdheM4Dmq12pAxNmg2mwHn3DkREcbj8SeA1eFwmC2Xy72DJ5PJ0BgzF0L43W4Xnuf9qoaI/CRJpmmaTuM47ksplc38HgSB3+v1rvbneR7CMESn08Fms5kD6NcBwBjTuj2aiwqcv+tZKYU8z3GtbK01drsdtNbO5uDRaAQiwna7BRGBcw47NPtut9sIwxDr9foSBgAhBIQQKIoCRAQALoCtxtp/wVY2yz09/4e94Bf8gh+FGWN7rbX/1/r5KSICY+y8equqelNKrfI8v7V6kSQJsixTAGYOllKqKIr6WZYN0jT94Jz7wHkFFUWBsiyVMUYdj8eFvR6u59MVWABY2HNTluX/zs13nQLt7/X/0LS/AKZ1qFvSGUBhAAAAAElFTkSuQmCC","contentType":"image/png","width":11,"height":24,"angle":0,"xoffset":0,"yoffset":0},"value":"562","label":"Standpipe"}],"fieldDelimiter":",","visualVariables":[{"type":"sizeInfo","valueExpressionTitle":"Custom","valueExpression":"$view.scale","stops":[{"size":30.295794674403236,"value":4513.988705},{"size":24.23663573952259,"value":36111.909643},{"size":12.118317869761295,"value":288895.277144},{"size":6.0591589348806476,"value":2311162.217155}],"axis":"height","valueUnit":""}]},"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:
IsSystemMaintained : True
Global ID Field: GLOBALID
Type ID Field: ASSETTYPE
Fields:
- OBJECTID (type: esriFieldTypeOID, alias: OBJECTID, SQL Type: sqlTypeOther, length: 0, nullable: false, editable: false)
- ASSETGROUP (type: esriFieldTypeInteger, alias: Asset group, SQL Type: sqlTypeOther, nullable: false, editable: true)
- ASSETTYPE (type: esriFieldTypeSmallInteger, alias: Asset type, SQL Type: sqlTypeOther, nullable: false, editable: true)
- ASSOCIATIONSTATUS (type: esriFieldTypeSmallInteger, alias: Association status, SQL Type: sqlTypeOther, nullable: false, editable: false, Coded Values: [0: None], [1: Container], [2: Structure], ... 33 more ...)
- ISSUBNETWORKCONTROLLER (type: esriFieldTypeSmallInteger, alias: Is subnetwork controller, SQL Type: sqlTypeOther, nullable: false, editable: false, Coded Values: [0: False], [1: True])
- ISCONNECTED (type: esriFieldTypeSmallInteger, alias: Is connected, SQL Type: sqlTypeOther, nullable: false, editable: false, Coded Values: [0: False], [1: True], [2: Unknown])
- SUBNETWORKCONTROLLERNAME (type: esriFieldTypeString, alias: Subnetwork controller name, SQL Type: sqlTypeOther, length: 2000, nullable: false, editable: false)
- TIERNAME (type: esriFieldTypeInteger, alias: Tier name, SQL Type: sqlTypeOther, nullable: false, editable: false, Coded Values: [0: Unknown], [1: Water Cathodic Protection], [2: Water System], ... 3 more ...)
- TIERRANK (type: esriFieldTypeInteger, alias: Tier rank, SQL Type: sqlTypeOther, nullable: false, editable: false)
- TERMINALCONFIGURATION (type: esriFieldTypeString, alias: Terminal path, SQL Type: sqlTypeOther, length: 128, nullable: false, editable: true)
- GLOBALID (type: esriFieldTypeGlobalID, alias: Global ID, SQL Type: sqlTypeOther, length: 38, nullable: false, editable: false)
- cpsubnetworkname (type: esriFieldTypeString, alias: CP Subnetwork Name, SQL Type: sqlTypeOther, length: 2000, nullable: false, editable: false)
- SUPPORTEDSUBNETWORKNAME (type: esriFieldTypeString, alias: Supported subnetwork name, SQL Type: sqlTypeOther, length: 2000, nullable: false, editable: false)
- SUPPORTINGSUBNETWORKNAME (type: esriFieldTypeString, alias: Supporting subnetwork name, SQL Type: sqlTypeOther, length: 2000, nullable: false, editable: false)
- SystemSubnetworkName (type: esriFieldTypeString, alias: System Subnetwork Name, SQL Type: sqlTypeOther, length: 2000, nullable: false, editable: false)
- PressureSubnetworkName (type: esriFieldTypeString, alias: Pressure Subnetwork Name, SQL Type: sqlTypeOther, length: 2000, nullable: false, editable: false)
- IsolationSubnetworkName (type: esriFieldTypeString, alias: Isolation Subnetwork Name, SQL Type: sqlTypeOther, length: 2000, nullable: false, editable: false)
- DMASubnetworkName (type: esriFieldTypeString, alias: DMA Subnetwork Name, SQL Type: sqlTypeOther, length: 2000, nullable: false, editable: false)
- diameter (type: esriFieldTypeDouble, alias: diameter: Diameter, Diameter 1, Height, Inlet Diameter, Pipe Diameter, Weight, SQL Type: sqlTypeOther, nullable: true, editable: true)
- secondarydiameter (type: esriFieldTypeDouble, alias: secondarydiameter: Diameter 2, Nozzle Diameter, Outlet Diameter, Width, SQL Type: sqlTypeOther, nullable: true, editable: true)
- pressure (type: esriFieldTypeDouble, alias: pressure: Amperage, Pressure, Rated Pressure, Volume, SQL Type: sqlTypeOther, nullable: true, editable: true)
- designtype (type: esriFieldTypeSmallInteger, alias: designtype: Anode Count, Design Type, Manufacturer, Pump Type, Test Wire Count, Valve Type, Wire Count, SQL Type: sqlTypeOther, nullable: true, editable: true)
- normalstatus (type: esriFieldTypeSmallInteger, alias: Normal Status, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: Closed], [1: Open], [3: Partial])
- presentstatus (type: esriFieldTypeSmallInteger, alias: Present Status, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: Closed], [1: Open], [3: Partial])
- additionaldetails (type: esriFieldTypeSmallInteger, alias: additionaldetails: Clockwise to Close, Cooling Method, Critical, Material, SQL Type: sqlTypeOther, nullable: true, editable: true)
- designinfo (type: esriFieldTypeDouble, alias: designinfo: Anode Depth, Rated Flow, Turns to Close, Voltage, SQL Type: sqlTypeOther, nullable: true, editable: true)
- operable (type: esriFieldTypeSmallInteger, alias: Operable, SQL Type: sqlTypeOther, nullable: false, editable: true, Coded Values: [0: False], [1: True])
- name (type: esriFieldTypeString, alias: Name, SQL Type: sqlTypeOther, length: 64, nullable: true, editable: true)
- installdate (type: esriFieldTypeDate, alias: Install Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
- UID (type: esriFieldTypeString, alias: Unique ID, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
- accountid (type: esriFieldTypeString, alias: Account ID, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
- ownedby (type: esriFieldTypeString, alias: Owned By, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true, Coded Values: [CITY OF ROUND ROCK: City of Round Rock], [PRIVATE: Private], [MUD: MUD], ... 2 more ...)
- maintby (type: esriFieldTypeString, alias: Maintained By, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true, Coded Values: [CITY OF ROUND ROCK: City of Round Rock], [PRIVATE: Private], [MUD: MUD], ... 2 more ...)
- additionaldevice (type: esriFieldTypeSmallInteger, alias: additionaldevice: Additional Device, Has Bypass, Internal Meter, Metered, SQL Type: sqlTypeOther, nullable: true, editable: true)
- notes (type: esriFieldTypeString, alias: Notes, SQL Type: sqlTypeOther, length: 2000, nullable: true, editable: true)
- symbolrotation (type: esriFieldTypeSmallInteger, alias: Symbol Rotation, SQL Type: sqlTypeOther, nullable: true, editable: true, Range: [0 - 359])
- lastmaint (type: esriFieldTypeDate, alias: Last Maintenance, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
- lifecyclestatus (type: esriFieldTypeSmallInteger, alias: Lifecycle Status, SQL Type: sqlTypeOther, nullable: false, editable: true, Coded Values: [0: Unknown], [1: Proposed], [2: Approved], ... 14 more ...)
- bondedinsulated (type: esriFieldTypeSmallInteger, alias: Bonded/Insulated, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [1: Bonded], [2: Insulated])
- cptraceability (type: esriFieldTypeSmallInteger, alias: Cathodic Protection Traceability, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: Unknown], [1: Yes], [2: No])
- inservicedate (type: esriFieldTypeDate, alias: In-Service Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
- retireddate (type: esriFieldTypeDate, alias: Retired Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
- spatialsource (type: esriFieldTypeString, alias: Spatial Source, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true, Coded Values: [AS_BUILT: Asbuilt], [CAD: CAD], [EXISTING_DATA: Existing Data], ... 4 more ...)
- spatialconfidence (type: esriFieldTypeSmallInteger, alias: Spatial Confidence, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: Unknown], [1: High], [2: Medium], ... 1 more ...)
- cpoverride (type: esriFieldTypeSmallInteger, alias: Cathodic Protection Override, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [1: Traceable], [2: Not Traceable])
- manufacturer (type: esriFieldTypeString, alias: Manufacturer, SQL Type: sqlTypeOther, length: 25, nullable: true, editable: true, Coded Values: [AMERICAN DARLING: American Darling], [AVK: Avk], [CLOW: Clow], ... 7 more ...)
- operator (type: esriFieldTypeSmallInteger, alias: Postindicator Valve, SQL Type: sqlTypeOther, nullable: true, editable: true)
- survey_date (type: esriFieldTypeDate, alias: Survey Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
- survey_crew (type: esriFieldTypeString, alias: Survey Crew, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true, Coded Values: [BAKER-AICKLEN: BAKER-AICKLEN], [CITY UTILITY DEPT: CITY UTILITY DEPT], [OTHER: OTHER])
- survey_class (type: esriFieldTypeString, alias: Survey Class, SQL Type: sqlTypeOther, length: 15, nullable: true, editable: true, Coded Values: [RTK/GPS: RTK/GPS], [DGPS: DGPS], [CONVENTIONAL: CONVENTIONAL], ... 6 more ...)
- gps_z (type: esriFieldTypeDouble, alias: GPS_Z, SQL Type: sqlTypeOther, nullable: true, editable: true)
- field_id (type: esriFieldTypeString, alias: Field ID, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
- address (type: esriFieldTypeString, alias: Address, SQL Type: sqlTypeOther, length: 130, nullable: true, editable: true)
- location (type: esriFieldTypeString, alias: Location, SQL Type: sqlTypeOther, length: 250, nullable: true, editable: true)
- model (type: esriFieldTypeString, alias: Model, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true, Coded Values: [129: 129], [929: 929], [27-30: 27-30], ... 14 more ...)
- yr_mfg (type: esriFieldTypeInteger, alias: Year Manufactured, SQL Type: sqlTypeOther, nullable: true, editable: true)
- fh_valve (type: esriFieldTypeString, alias: Has Valve?, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true, Coded Values: [YES: Yes], [NO: No], [UNKNOWN: Unknown])
- potable (type: esriFieldTypeString, alias: Potable?, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true, Coded Values: [YES: Yes], [NO: No], [UNKNOWN: Unknown])
- hyd_size (type: esriFieldTypeDouble, alias: Size, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: Unknown], [5: 5"], [5.25: 5 1/4"], ... 1 more ...)
- tag_id (type: esriFieldTypeInteger, alias: TAG ID, SQL Type: sqlTypeOther, nullable: true, editable: true)
- dead_end_flush (type: esriFieldTypeString, alias: Dead End Flush?, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true, Coded Values: [YES: Yes], [NO: No], [UNKNOWN: Unknown])
- capacity (type: esriFieldTypeString, alias: Capacity (MG), SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
- elevation (type: esriFieldTypeSmallInteger, alias: Elevation, SQL Type: sqlTypeOther, nullable: true, editable: true)
- created_date (type: esriFieldTypeDate, alias: Creation date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: false)
- created_user (type: esriFieldTypeString, alias: Creator, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: false)
- last_edited_date (type: esriFieldTypeDate, alias: Last update, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: false)
- last_edited_user (type: esriFieldTypeString, alias: Updated by, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: false)
- eid (type: esriFieldTypeString, alias: EID, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
- meter_number (type: esriFieldTypeString, alias: Meter Number, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
- CorrectionDate (type: esriFieldTypeDate, alias: Correction Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
- meter_size (type: esriFieldTypeDouble, alias: Meter Size, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: Unknown], [0.75: 3/4"], [1: 1"], ... 21 more ...)
Types:
ID: 564
Name: Ground Storage Tank
Domains:
- Field Name: ASSOCIATIONSTATUS
Inherited
- Field Name: ISSUBNETWORKCONTROLLER
Inherited
- Field Name: ISCONNECTED
Inherited
- Field Name: TIERNAME
Inherited
- Field Name: normalstatus
Inherited
- Field Name: presentstatus
Inherited
- Field Name: operable
Inherited
- Field Name: ownedby
Inherited
- Field Name: maintby
Inherited
- Field Name: symbolrotation
Inherited
- Field Name: lifecyclestatus
Inherited
- Field Name: bondedinsulated
Inherited
- Field Name: cptraceability
Inherited
- Field Name: spatialsource
Inherited
- Field Name: spatialconfidence
Inherited
- Field Name: cpoverride
Inherited
- Field Name: manufacturer
Inherited
- Field Name: survey_crew
Inherited
- Field Name: survey_class
Inherited
- Field Name: model
Inherited
- Field Name: fh_valve
Inherited
- Field Name: potable
Inherited
- Field Name: hyd_size
Inherited
- Field Name: dead_end_flush
Inherited
- Field Name: meter_size
Inherited
Templates:
Name: 564
Description:
Drawing Tool: esriFeatureEditToolPoint
Prototype:
Attributes:
- ASSETGROUP: 0
- ASSETTYPE: 564
- TERMINALCONFIGURATION: Default
- dead_end_flush: NO
- operable: 1
- ownedby: CITY OF ROUND ROCK
- maintby: CITY OF ROUND ROCK
- lifecyclestatus: 0
- cptraceability: 0
ID: 563
Name: Elevated Storage Tank
Domains:
- Field Name: ASSOCIATIONSTATUS
Inherited
- Field Name: ISSUBNETWORKCONTROLLER
Inherited
- Field Name: ISCONNECTED
Inherited
- Field Name: TIERNAME
Inherited
- Field Name: normalstatus
Inherited
- Field Name: presentstatus
Inherited
- Field Name: operable
Inherited
- Field Name: ownedby
Inherited
- Field Name: maintby
Inherited
- Field Name: symbolrotation
Inherited
- Field Name: lifecyclestatus
Inherited
- Field Name: bondedinsulated
Inherited
- Field Name: cptraceability
Inherited
- Field Name: spatialsource
Inherited
- Field Name: spatialconfidence
Inherited
- Field Name: cpoverride
Inherited
- Field Name: manufacturer
Inherited
- Field Name: survey_crew
Inherited
- Field Name: survey_class
Inherited
- Field Name: model
Inherited
- Field Name: fh_valve
Inherited
- Field Name: potable
Inherited
- Field Name: hyd_size
Inherited
- Field Name: dead_end_flush
Inherited
- Field Name: meter_size
Inherited
Templates:
Name: 563
Description:
Drawing Tool: esriFeatureEditToolPoint
Prototype:
Attributes:
- ASSETGROUP: 0
- ASSETTYPE: 563
- TERMINALCONFIGURATION: Default
- dead_end_flush: NO
- operable: 1
- ownedby: CITY OF ROUND ROCK
- maintby: CITY OF ROUND ROCK
- lifecyclestatus: 0
- cptraceability: 0
ID: 562
Name: Standpipe
Domains:
- Field Name: ASSOCIATIONSTATUS
Inherited
- Field Name: ISSUBNETWORKCONTROLLER
Inherited
- Field Name: ISCONNECTED
Inherited
- Field Name: TIERNAME
Inherited
- Field Name: normalstatus
Inherited
- Field Name: presentstatus
Inherited
- Field Name: operable
Inherited
- Field Name: ownedby
Inherited
- Field Name: maintby
Inherited
- Field Name: symbolrotation
Inherited
- Field Name: lifecyclestatus
Inherited
- Field Name: bondedinsulated
Inherited
- Field Name: cptraceability
Inherited
- Field Name: spatialsource
Inherited
- Field Name: spatialconfidence
Inherited
- Field Name: cpoverride
Inherited
- Field Name: manufacturer
Inherited
- Field Name: survey_crew
Inherited
- Field Name: survey_class
Inherited
- Field Name: model
Inherited
- Field Name: fh_valve
Inherited
- Field Name: potable
Inherited
- Field Name: hyd_size
Inherited
- Field Name: dead_end_flush
Inherited
- Field Name: meter_size
Inherited
Templates:
Name: 562
Description:
Drawing Tool: esriFeatureEditToolPoint
Prototype:
Attributes:
- ASSETGROUP: 0
- ASSETTYPE: 562
- TERMINALCONFIGURATION: Default
- dead_end_flush: NO
- operable: 1
- ownedby: CITY OF ROUND ROCK
- maintby: CITY OF ROUND ROCK
- lifecyclestatus: 0
- cptraceability: 0
Is Data Versioned: false
Has Contingent Values: false
Supports Rollback On Failure Parameter: true
Last Edit Date: 4/21/2026 6:15:08 PM
Schema Last Edit Date: 4/21/2026 6:15:08 PM
Data Last Edit Date: 9/2/2025 1:20:26 PM
Supported Operations:
Query
Query Pivot
Query Top Features
Query Analytic
Query Bins
Generate Renderer
Validate SQL
Get Estimates
ConvertFormat