Name: Fire Hydrant
Display Field: assetid
Type: Feature Layer
Geometry Type: esriGeometryPoint
Is View: true
Is Updatable View: true
Source Schema Changes Allowed: true
Sources
Description:
Copyright Text:
Min. Scale: 123674
Max. Scale: 0
Default Visibility: true
Max Record Count: 2000
Supported query Formats: JSON, geoJSON, PBF
Use Standardized Queries: True
Extent:
XMin: -11155337.777234
YMin: 3475813.13458373
XMax: -8088002.76653994
YMax: 5091763.73153527
Spatial Reference: 102100 (3857)
Drawing Info:
{"renderer":{"type":"uniqueValue","field1":"assettype","defaultSymbol":{"type":"esriSMS","style":"esriSMSCircle","color":[255,255,255,255],"size":12.75,"angle":0,"xoffset":0,"yoffset":0,"outline":{"color":[0,0,0,255],"width":0.5}},"defaultLabel":"Other","uniqueValueGroups":[{"heading":"","classes":[{"label":"Unknown","description":"Unknown","symbol":{"type":"esriPMS","url":"3c146855f4e145d89fc30bb0658992f7","imageData":"iVBORw0KGgoAAAANSUhEUgAAABsAAAAbCAYAAACN1PRVAAAACXBIWXMAAA7EAAAOxAGVKw4bAAAED0lEQVRIic2Wz0tcVxTHP0+dXGM7c+Oo1zY6Dx4zsyh1bCKmm44uJouICIGk0H8ghMCsuuteSxexBAqBLFyVrgL5URDTLHQRcBOFQOaBi9EMDBlLx3HMU6M+ZLxdzMzTcWZIS6T0rB733Xs+99z7PefcNv5Da/v/wbp0H20E0VzkiKA3rtkHchyyxrZR/DhYj45gEOaIIKUG/w3OAxHOEUHpIiVsNo3cv4f16FE0fWhgAosRhrAYQnABQScA22TYIMMDHpECDEbp0Tk2jBf/HFYFxejkDjcJk2g4L4BFAIu7JFhjgSQzaPpQ+hp54/mHYVXQBBbfcpPPGAK4QYGEs4rf3cV/sMOh7OZNe5AndPNS9EKYBA+xmGSaFNClr7BpLDWH9eiIF1EF9AV73Gadr90884vznFSBlJKfBgZYF0W+J0Ih4LOYYorrJDGIENA1wqmFGYTRwJ1j0D1W6eYQhGBgYADbtr3poVAIKSWSPf7gNWMMUhC+Tu5ziyQz+BgFntbDunQfRwSZwKre0W3WyyDAtm2y2WzN3mzbxnVdotEoAL+xwhiD5SOdYJ5ZMgR0sBrdMaytIu+R4zsawakBKaVwXRfHcVBKoZTCtm2EEJimid/d5YYo8JhuiGExSwYfYeAUTHMRAKsMG3ffsri8SCgU8kDDw8Pk83lviVLK24yUkuXlZcbjHTwW3XCZq8ACrcdF4BhWrQyCCwD+gx3WHQfHKUfnui7ZbBbTNL0l6XTagy8uLgIQ/CsD5qVyWpz0SyPpVxLW7+7WDDuO491N1aSUpNPpOhfNrGkF2cBX57iRSSm96AF22v3lD5ctoFo/T8E0+xicZ5sMAax1+TlCCKLRqCd3pRTpdNoDK6XIZrMIIYjFYqRSKTKicmpbZABobQSDHBBhowx7Qjf34nGEELiuSzqd9u6lCsxms+TzeUzTRClFPB7nR8qi4T3vACjRIKkPWeMcER7wiLskXopeVtw/uUSJaDSKEKImoR3HQVQSvSqaVwctzMn+8oRnzHt+62DbRhGli6SANRYIk/hBfMnv7pKXR1JKLzoA0zQ90Aod/NpeOcI1FpglQwvF5uWqhI3BKElmeIhVCPisMQaZcV4Rlh11yqvmX6Y9yC8Hn/Ba9pbbTpIZz98Jq4VtGjl6dA5NH5NMM8XUjvi08zsxwrj7lvHoV3wT3QOggI837UF+RjIn+kFQBk0yDYBm9XQjrZf+hvECpa+RAq6T5D63CJOYE/1lp82s2s8ADHIUattLYxhA3nhOl76CQYQkM0wwTwyLy1z1KoPLFltkeM87nlWKbjWiBqDmMIBNY4mAXsPHKLNkKs4Wms5v4SPeIEBFSU8J6CA+wrQS9GqdZp9W9ilRPJvXVS30g87OBnZG9jeb9ZwD8bQiVwAAAABJRU5ErkJggg==","contentType":"image/png","width":20,"height":20,"angle":0,"xoffset":0,"yoffset":0},"values":[["0"]]},{"label":"Fire Hydrant","description":"Fire Hydrant","symbol":{"type":"esriPMS","url":"0350469f1796cb3dddde668c6271f715","imageData":"iVBORw0KGgoAAAANSUhEUgAAABsAAAAbCAYAAACN1PRVAAAACXBIWXMAAA7EAAAOxAGVKw4bAAAEMklEQVRIic2WUUhbVxjHf1dN0w5Na9RgbmBwl6jzwbU1dntJ3RYf2nWphbUvLRT6ULQs7EXYy15M0bc6BmOFNvNpMGHFMjGZtg9xrN2e6l2FFIqrISDNjdWqNaRoED17uMlNryZ0ozJ2nu4957v/H993/uc7t4r/cFT9/2B1wkUVdgQy29iNecE6kGKTBBlp5c1gDcKDhJtt7GyVWJc4AHjYhweHWGGLRyxLqX8PaxCdCFwIIIDCcdpRaMfKIazUApAhyRJJbnCbOCDRSYNIsSTd++ewAqiNWq5wFjf+knE2FGwoXMNPgimCDCNw4RAnWJTuvh5WAAVQOMdZGmkHkCdG8MbGURMP8W5uo1oqoNWL83wf6nsd4MbPLRQGGCIO1IljLEsPysMahMfIKA+Sk7No336Jdj/CuO8S3sOfGeHRxTl6P/8YlBb4JgL1ToVBBjlDEAkPNmEyjhkm4UYAV/IZPVZxhnrQEn8CEJ6f4WbbSSM88mwObSMLj1U4KSP/mkGrqanlOpcJMoyFTmBsN6xOuNjGTgClsEfyD1+j5kE9bx8xgQDjPTw/o09c7ICxWb2kAWJESWIT9kJ2RVhV3t7H9T3yxsZJ34+YQOraAvL+apzWasLzM6RzWTPwuYY8MYJ26gK0oRAliQU3sAMmkAFQdBg/hxnvOEd0cY7+Jh/q2gLd06N4DzaayggQatbXQ80+In9MET51AY7SBUxRWWwCRVihM1g5BJB++gTv4TZDXN5fTcDhKZYsDwk4PDit1Uz7LukZTo/qizYUky6lrJ8/sIGKt0zTTms16VzWNKeuLdDf5NsVV26U7SCqpWKXcKmRzmXNgHp9N8ixChT65w6YYB2JA2RIYkNRZRfq2gJXn/xumCDybM7YHwBtI4u6toDTWk1v/I5uItml662SBKCyFAxSgIclHSaf76O77zTaRhanVQcW9qW/yUc6p4MCDg+98TuGgZxXf9TVXvICgC1KHOpNEuzDww1ucw2/9v5HnP7gU7TffjJMEWr2GSVzWvUj0D09arjSeeRD1K5uXW+SmKG7C5aRVnCIFeJAginc+NXQ98if/IK2kSU8P4O6tmBkB3q7KoBo9SJ/MYRK/vsoSSpYKd+utniERCdBhrmFotlqFHlSQ77Ygfb0L0LNReelc1m8Bxv1o9HqhZ4QkZZ39WsnyLCh98oww5alFA0ihcDFAEMMMqjV1NQyNos3Nk54YoTe2Hd6Ketl0u+04PzqZrF0GZIMMASAYG7nRbrb+kvSPRziBHHgDEGucxk3frWr2xDVXgk3ngv3GYBEiufm66U0DGBRukudOIaEhyDDBIjRhsJRuozOkGOVVZK85AWT+aZbyKgEqDwMYFl6gE0ksNBJlGRebKpsfAVv8A8C5J00hk3YseCmErvR6wTrVLLOFit783dlhr5WbG9gezT+Bj8btV2PiD2CAAAAAElFTkSuQmCC","contentType":"image/png","width":20,"height":20,"angle":0,"xoffset":0,"yoffset":0},"values":[["321"]]}]}],"uniqueValueInfos":[{"symbol":{"type":"esriPMS","url":"3c146855f4e145d89fc30bb0658992f7","imageData":"iVBORw0KGgoAAAANSUhEUgAAABsAAAAbCAYAAACN1PRVAAAACXBIWXMAAA7EAAAOxAGVKw4bAAAED0lEQVRIic2Wz0tcVxTHP0+dXGM7c+Oo1zY6Dx4zsyh1bCKmm44uJouICIGk0H8ghMCsuuteSxexBAqBLFyVrgL5URDTLHQRcBOFQOaBi9EMDBlLx3HMU6M+ZLxdzMzTcWZIS6T0rB733Xs+99z7PefcNv5Da/v/wbp0H20E0VzkiKA3rtkHchyyxrZR/DhYj45gEOaIIKUG/w3OAxHOEUHpIiVsNo3cv4f16FE0fWhgAosRhrAYQnABQScA22TYIMMDHpECDEbp0Tk2jBf/HFYFxejkDjcJk2g4L4BFAIu7JFhjgSQzaPpQ+hp54/mHYVXQBBbfcpPPGAK4QYGEs4rf3cV/sMOh7OZNe5AndPNS9EKYBA+xmGSaFNClr7BpLDWH9eiIF1EF9AV73Gadr90884vznFSBlJKfBgZYF0W+J0Ih4LOYYorrJDGIENA1wqmFGYTRwJ1j0D1W6eYQhGBgYADbtr3poVAIKSWSPf7gNWMMUhC+Tu5ziyQz+BgFntbDunQfRwSZwKre0W3WyyDAtm2y2WzN3mzbxnVdotEoAL+xwhiD5SOdYJ5ZMgR0sBrdMaytIu+R4zsawakBKaVwXRfHcVBKoZTCtm2EEJimid/d5YYo8JhuiGExSwYfYeAUTHMRAKsMG3ffsri8SCgU8kDDw8Pk83lviVLK24yUkuXlZcbjHTwW3XCZq8ACrcdF4BhWrQyCCwD+gx3WHQfHKUfnui7ZbBbTNL0l6XTagy8uLgIQ/CsD5qVyWpz0SyPpVxLW7+7WDDuO491N1aSUpNPpOhfNrGkF2cBX57iRSSm96AF22v3lD5ctoFo/T8E0+xicZ5sMAax1+TlCCKLRqCd3pRTpdNoDK6XIZrMIIYjFYqRSKTKicmpbZABobQSDHBBhowx7Qjf34nGEELiuSzqd9u6lCsxms+TzeUzTRClFPB7nR8qi4T3vACjRIKkPWeMcER7wiLskXopeVtw/uUSJaDSKEKImoR3HQVQSvSqaVwctzMn+8oRnzHt+62DbRhGli6SANRYIk/hBfMnv7pKXR1JKLzoA0zQ90Aod/NpeOcI1FpglQwvF5uWqhI3BKElmeIhVCPisMQaZcV4Rlh11yqvmX6Y9yC8Hn/Ba9pbbTpIZz98Jq4VtGjl6dA5NH5NMM8XUjvi08zsxwrj7lvHoV3wT3QOggI837UF+RjIn+kFQBk0yDYBm9XQjrZf+hvECpa+RAq6T5D63CJOYE/1lp82s2s8ADHIUattLYxhA3nhOl76CQYQkM0wwTwyLy1z1KoPLFltkeM87nlWKbjWiBqDmMIBNY4mAXsPHKLNkKs4Wms5v4SPeIEBFSU8J6CA+wrQS9GqdZp9W9ilRPJvXVS30g87OBnZG9jeb9ZwD8bQiVwAAAABJRU5ErkJggg==","contentType":"image/png","width":20,"height":20,"angle":0,"xoffset":0,"yoffset":0},"value":"0","label":"Unknown"},{"symbol":{"type":"esriPMS","url":"0350469f1796cb3dddde668c6271f715","imageData":"iVBORw0KGgoAAAANSUhEUgAAABsAAAAbCAYAAACN1PRVAAAACXBIWXMAAA7EAAAOxAGVKw4bAAAEMklEQVRIic2WUUhbVxjHf1dN0w5Na9RgbmBwl6jzwbU1dntJ3RYf2nWphbUvLRT6ULQs7EXYy15M0bc6BmOFNvNpMGHFMjGZtg9xrN2e6l2FFIqrISDNjdWqNaRoED17uMlNryZ0ozJ2nu4957v/H993/uc7t4r/cFT9/2B1wkUVdgQy29iNecE6kGKTBBlp5c1gDcKDhJtt7GyVWJc4AHjYhweHWGGLRyxLqX8PaxCdCFwIIIDCcdpRaMfKIazUApAhyRJJbnCbOCDRSYNIsSTd++ewAqiNWq5wFjf+knE2FGwoXMNPgimCDCNw4RAnWJTuvh5WAAVQOMdZGmkHkCdG8MbGURMP8W5uo1oqoNWL83wf6nsd4MbPLRQGGCIO1IljLEsPysMahMfIKA+Sk7No336Jdj/CuO8S3sOfGeHRxTl6P/8YlBb4JgL1ToVBBjlDEAkPNmEyjhkm4UYAV/IZPVZxhnrQEn8CEJ6f4WbbSSM88mwObSMLj1U4KSP/mkGrqanlOpcJMoyFTmBsN6xOuNjGTgClsEfyD1+j5kE9bx8xgQDjPTw/o09c7ICxWb2kAWJESWIT9kJ2RVhV3t7H9T3yxsZJ34+YQOraAvL+apzWasLzM6RzWTPwuYY8MYJ26gK0oRAliQU3sAMmkAFQdBg/hxnvOEd0cY7+Jh/q2gLd06N4DzaayggQatbXQ80+In9MET51AY7SBUxRWWwCRVihM1g5BJB++gTv4TZDXN5fTcDhKZYsDwk4PDit1Uz7LukZTo/qizYUky6lrJ8/sIGKt0zTTms16VzWNKeuLdDf5NsVV26U7SCqpWKXcKmRzmXNgHp9N8ixChT65w6YYB2JA2RIYkNRZRfq2gJXn/xumCDybM7YHwBtI4u6toDTWk1v/I5uItml662SBKCyFAxSgIclHSaf76O77zTaRhanVQcW9qW/yUc6p4MCDg+98TuGgZxXf9TVXvICgC1KHOpNEuzDww1ucw2/9v5HnP7gU7TffjJMEWr2GSVzWvUj0D09arjSeeRD1K5uXW+SmKG7C5aRVnCIFeJAginc+NXQ98if/IK2kSU8P4O6tmBkB3q7KoBo9SJ/MYRK/vsoSSpYKd+utniERCdBhrmFotlqFHlSQ77Ygfb0L0LNReelc1m8Bxv1o9HqhZ4QkZZ39WsnyLCh98oww5alFA0ihcDFAEMMMqjV1NQyNos3Nk54YoTe2Hd6Ketl0u+04PzqZrF0GZIMMASAYG7nRbrb+kvSPRziBHHgDEGucxk3frWr2xDVXgk3ngv3GYBEiufm66U0DGBRukudOIaEhyDDBIjRhsJRuozOkGOVVZK85AWT+aZbyKgEqDwMYFl6gE0ksNBJlGRebKpsfAVv8A8C5J00hk3YseCmErvR6wTrVLLOFit783dlhr5WbG9gezT+Bj8btV2PiD2CAAAAAElFTkSuQmCC","contentType":"image/png","width":20,"height":20,"angle":0,"xoffset":0,"yoffset":0},"value":"321","label":"Fire Hydrant"}],"fieldDelimiter":",","authoringInfo":{"colorRamp":{"type":"multipart","colorRamps":[{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[245,252,210,255],"toColor":[245,252,210,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[209,184,252,255],"toColor":[209,184,252,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[252,184,189,255],"toColor":[252,184,189,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[187,233,252,255],"toColor":[187,233,252,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[187,252,189,255],"toColor":[187,252,189,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[252,202,238,255],"toColor":[252,202,238,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[179,252,235,255],"toColor":[179,252,235,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[252,226,215,255],"toColor":[252,226,215,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[197,208,252,255],"toColor":[197,208,252,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[252,223,182,255],"toColor":[252,223,182,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[249,182,252,255],"toColor":[249,182,252,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[252,210,217,255],"toColor":[252,210,217,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[252,246,179,255],"toColor":[252,246,179,255]}]}},"visualVariables":[{"type":"rotationInfo","valueExpressionTitle":"Custom","valueExpression":"$feature.symbolrotation","rotationType":"arithmetic"}]},"scaleSymbols":true,"transparency":0,"labelingInfo":null}
HasZ: true
HasM: true
Has Attachments: true
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)
- assettype (type: esriFieldTypeSmallInteger, alias: Asset Type, SQL Type: sqlTypeOther, nullable: false, editable: true, Coded Values: [0: Unknown], [321: Fire Hydrant])
- assetid (type: esriFieldTypeString, alias: Asset ID, SQL Type: sqlTypeOther, length: 64, nullable: true, editable: true)
- diameter (type: esriFieldTypeDouble, alias: Service Diameter, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: Unknown], [4: 4"], [4.5: 4 1/2"], ... 6 more ...)
- secondarydiameter (type: esriFieldTypeDouble, alias: Nozzle Diameter, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: Unknown], [2.5: 2 1/2"], [4.5: 4 1/2"], ... 4 more ...)
- manufacturer (type: esriFieldTypeSmallInteger, alias: Manufacturer, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: Unknown], [60: American Darling], [61: Clow Corporation], ... 13 more ...)
- model (type: esriFieldTypeInteger, alias: Model, SQL Type: sqlTypeOther, nullable: true, editable: true)
- installdate (type: esriFieldTypeDate, alias: Install Date, 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], ... 7 more ...)
- notes (type: esriFieldTypeString, alias: Notes, SQL Type: sqlTypeOther, length: 2000, nullable: true, editable: true)
- ownedby (type: esriFieldTypeSmallInteger, alias: Owned By, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [1: Our Agency], [2: Private], [100: Other])
- symbolrotation (type: esriFieldTypeSmallInteger, alias: Symbol Rotation, SQL Type: sqlTypeOther, nullable: true, editable: true, Range: [0 - 359])
- globalid (type: esriFieldTypeGlobalID, alias: Global ID, SQL Type: sqlTypeOther, length: 38, nullable: false, editable: false)
- location (type: esriFieldTypeString, alias: Location, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true)
- valvelocation (type: esriFieldTypeString, alias: Valve Location, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true)
- valvetype (type: esriFieldTypeString, alias: Valve Type, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true)
- mainsize (type: esriFieldTypeString, alias: Main Size, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true)
- testdate (type: esriFieldTypeDate, alias: Test Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
- staticpsi (type: esriFieldTypeDouble, alias: Static PSI, SQL Type: sqlTypeOther, nullable: true, editable: true)
- flowpsi (type: esriFieldTypeDouble, alias: Flow PSI, SQL Type: sqlTypeOther, nullable: true, editable: true)
- flowgpm (type: esriFieldTypeDouble, alias: Flow GPM, SQL Type: sqlTypeOther, nullable: true, editable: true)
- bonnetcolor (type: esriFieldTypeString, alias: Bonnet Color, SQL Type: sqlTypeOther, length: 64, nullable: true, editable: true, Coded Values: [Blue: Blue], [Green: Green], [Orange: Orange], ... 3 more ...)
Types:
ID: 0
Name: Unknown
Domains:
- Field Name: assettype
Inherited
- Field Name: diameter
Inherited
- Field Name: secondarydiameter
Inherited
- Field Name: manufacturer
Inherited
- Field Name: lifecyclestatus
Inherited
- Field Name: ownedby
Inherited
- Field Name: maintby
Inherited
- Field Name: spatialsource
Inherited
- Field Name: spatialconfidence
Inherited
- Field Name: symbolrotation
Inherited
- Field Name: ESRIGNSS_POSITIONSOURCETYPE
Inherited
- Field Name: ESRIGNSS_FIXTYPE
Inherited
- Field Name: ESRIGNSS_STATIONID
Inherited
- Field Name: ESRIGNSS_NUMSATS
Inherited
- Field Name: assignmenttype
Inherited
- Field Name: adoptionstatus
Inherited
- Field Name: publicview
Inherited
Templates:
Name: Unknown
Description:
Drawing Tool: esriFeatureEditToolPoint
Prototype:
Attributes:
- lifecyclestatus: 8
- ownedby: 1
- maintby: 1
ID: 321
Name: Fire Hydrant
Domains:
- Field Name: assettype
Inherited
- Field Name: diameter
Inherited
- Field Name: secondarydiameter
Inherited
- Field Name: manufacturer
Inherited
- Field Name: lifecyclestatus
Inherited
- Field Name: ownedby
Inherited
- Field Name: maintby
Inherited
- Field Name: spatialsource
Inherited
- Field Name: spatialconfidence
Inherited
- Field Name: symbolrotation
Inherited
- Field Name: ESRIGNSS_POSITIONSOURCETYPE
Inherited
- Field Name: ESRIGNSS_FIXTYPE
Inherited
- Field Name: ESRIGNSS_STATIONID
Inherited
- Field Name: ESRIGNSS_NUMSATS
Inherited
- Field Name: assignmenttype
Inherited
- Field Name: adoptionstatus
Inherited
- Field Name: publicview
Inherited
Templates:
Name: Fire Hydrant
Description:
Drawing Tool: esriFeatureEditToolPoint
Prototype:
Attributes:
- lifecyclestatus: 8
- ownedby: 1
- maintby: 1
Is Data Versioned: false
Has Contingent Values: false
Supports Rollback On Failure Parameter: true
Last Edit Date: 9/25/2026 8:01:57 AM
Schema Last Edit Date: 9/23/2026 1:57:43 AM
Data Last Edit Date: 9/25/2026 8:01:57 AM
Supported Operations:
Query
Query Pivot
Query Top Features
Query Analytic
Query Bins
Query Attachments
Generate Renderer
Validate SQL
Get Estimates
ConvertFormat