Layer: PA Damage Assessment 2016 (ID:1)

View In: Map Viewer

Name: PA Damage Assessment 2016

Display Field: Contact_Owner_Name

Type: Feature Layer

Geometry Type: esriGeometryPoint

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:

Drawing Info:

{"renderer":{"type":"uniqueValue","field1":"PA_Damage_Category","field2":null,"field3":null,"fieldDelimiter":", ","defaultSymbol":null,"defaultLabel":null,"uniqueValueInfos":[{"symbol":{"type":"esriPMS","url":"c57072d34f0ca9d0b3cbbc28ac493020","imageData":"iVBORw0KGgoAAAANSUhEUgAAAB4AAAAUCAYAAACaq43EAAAAAXNSR0IB2cksfwAAAAlwSFlzAAAOxAAADsQBlSsOGwAAAsVJREFUSInF1l9o1lUcx/HX/v6mBZu/pFyWelEuJZKK0dCLSHiIsmUFk2AGSYS7CAtSugjKYiRD6CY2chRUi0UYjMXMQFCQBINumlJBEBsDR7UOzNrcWWvr4nkGc3t+z54o6AOHw+H34fv+cs73+zun2v+k6nKNQ7T8QXtIkp2TMd4yzdpr1CTM1TOZJslIA+fqY+zOMfGvwGeonaD7Em3fUL8L98UoxRpUYQ6/0/BLjJt/5MEBXu9ibGuavvlkCO//Y/BAmh4aCqHrIeqOoCHDl+AGbMA9eIqKUTZ9FsJ7xzi6g9yj/FAWuI9Pvw2h7TUq0qzMMlSBLTiM77ith+Ghxsb2x8bHT5YEf8K7E+x7NSOrK64/wBQbC8Dl2o43qDk6Pt5/ip/3cL4o+BQ7z/H8WxlQuIB92I0pfI138EKG/yYcobqXQawrCh5Jku4DMVbWZARZqs+xFh/h2cK4McO7CZtpGEzTg3tDOLEC/H2M2w6WAYVx1OInHCokUUq7cGFqaj9Wgv+itqpM8J2FuQknUbmKfx2muHlxfR14lvkFqooVynL9Kt/LZ+XbaFR+S7N0Ne+fLAreypUxbi8VYFFr5Pu3sbAeWQV8Ges5XRS8LU07+0M48Yri7bFULxbmATyNHSW8kzjPTGuMx4qCHw+htydJOr6I8d49GUGa5VtqUS/Jn3eS4Z/FcRZ2p+nLuRBmioKhOcYHvkqSS/0xNrVheWttKYxyFNDFwv1J8vYTIfQs/bYSzJ9ivOtj+g7T/hwVd1u9apfqmnzRfUnMpWnH3hA+WO7JvCT288xpjl9Mkt7eGJtzVG7HrfJFtVQL+A1j8n+yYWZbGHyYA60hTBWLX/JafIRhMbacYf3VJOk4S+tojE0z1FVTPU3VNPN1zG1gciOXG9O0744QPswxXyp2WQ+BHBNi7ETnquYQyglZ/gvkv9bfeA7UM4xoU4EAAAAASUVORK5CYII=","contentType":"image/png","width":22,"height":15,"angle":0,"xoffset":0,"yoffset":0},"value":"Individual Business Total Loss","label":"Individual Business Total Loss","description":""},{"symbol":{"type":"esriPMS","url":"710e66eaa06ae47d74d79d88f03ea592","imageData":"iVBORw0KGgoAAAANSUhEUgAAAB4AAAAUCAYAAACaq43EAAAAAXNSR0IB2cksfwAAAAlwSFlzAAAOxAAADsQBlSsOGwAAA15JREFUSInFln9IlHccx1+ej/f4c+qjtbTSAu2mLWOFJBWNpFs0c1bMEGzDiJFQ2KJuKcFWQzrlwIhxklKtZbiNYuKwtS24wLIWtD9SaYVseAlKdj3zytP7Xnruj4fo8h7PGwW94eHLh+fN+/U83+f7eb5fiTckKVxjRzUFo6OUq+PyardHvD0miB33ESVLTCTG41bi5P6kGK4mxgq72YrrlcBXqjC6JrH3PKD0dh+Ja3JgRZZASYAYI0QaYGISnnpJGh4RmX1DvN92m6/qyxhYkq58vbVBPf2/wW1fKFUdPWr9+qVEW7ZBUqy+T5YgToZ5iZCXCdsKiHA+IuPiDfWUtYwjyxdj/tDKvbDALXv48c7faumXpUQocaHmJFgRwKI5cLAE7g6woPE3ujssaeWbbUMXQoK/38tJ1yjbD38MkiE4eHAEXCMvKEoCzFc04HTlLoSjZUQd+WGo9dJ+HhYdp1MXfMnC6qu9fHbsU30oQNdd2H4CCk3g8cItJ3xTAXs36ftT4sGyBan5d9qBZF1wv0u279wgDFEzQAP182GIleGcAyqaoGI9xEfrezNSITOVpPZqZXdJndoUBP5rUOTs/mB2KMDQv2CMgn+GoWqj9hChtCYXuu57dgDB4Ek/xsgw3hYge582mhS4UAMGvY8coOQE8AjmPq9fAvue4Z+CyFkyAHh0SutlRw/kWcBp16Z0Jj3xQIyEWxe8JJ3BARcLQwU8V4xR6980Rav7h0ODex9A6ltc1gXnZCi1rdfUpkNb9dsjUPvOaGPbTShbBcsXz+x1j0PnPbzF64RVF/xRndrcuEuu/OVP8V7RSv2Q/GzoOvqi/rwIstO1P5iefJNga2OqMEc5YK5RvbpggPy5YtX1QbmntVOYStfC9NZaNEe7wpE6CvU/MbUyS27Y0qA2Bt4LBlt5BuKd83toOXiW8l2FRLybOfuqDdS4T1t0v95BmPOUyhKbena6Z8ZNYoedTy5XY/ujT25udoh88zIMuQsgPQXijC97p4DHT2HABbfuQ7cTX4GJ9o1L2VlsUz16+SG3xU11dIMouFJD6hOvXOnopdj5UJi8E0RLII35iRwT+KMNTMxLxj0/md60FKUl61v1O7MDf6jssA4C2sYuaoHa2d1qOJHhn0Bet/4D7E8TMrt/ezoAAAAASUVORK5CYII=","contentType":"image/png","width":22,"height":15,"angle":0,"xoffset":0,"yoffset":0},"value":"Individual Business Major","label":"Individual Business Major Damage","description":""},{"symbol":{"type":"esriPMS","url":"a110189b36ebcfe22798906e22671ce7","imageData":"iVBORw0KGgoAAAANSUhEUgAAAB4AAAAUCAYAAACaq43EAAAAAXNSR0IB2cksfwAAAAlwSFlzAAAOxAAADsQBlSsOGwAAA0dJREFUSInFllFIVFkYx3/jjF7HghlvsuvkrvpQmhJJhST5EAmXKJusQAk0SGLRh7BglR6C1hZJBqGXcKhhF3YzJhaDwRgzEBQkoaCXVCoIYoYBZWs6MNaM3llzejgIs3ocZ9mF/cPhcLh/vt/hnO+737HxP8mWrTEYpO7zZ1qF0A7HYua3iQQFS0vkahorDgcxXddCTieTDoc5aBhE/xV4fJy8aJTB2VmaX7zAUV8PBw6Y6DrY7WC1wsoKfPqE8/17s+ztW44EAvzk8RCpqNB/PnNG/PqPwYGA3hUMCs/Ro+T39IDTqfZpGmzbBsXFsG8fnD2LJRym9OFD8Ut/P701NRgnTvAmK/DQEH+8fCmar1/HouuZzmSjLBYoL4fubnj1iu+8XmaCQVfryZMLwxnBDx5wJxql5do1sCm2NT8P0bQb1HUoKZHA9aquhhs3yO3tXfCPjvJnYyNTSvDoKIcnJ/nh5k01FGB6GlpaoKEB4nF4/hxu34ZLl9T+HTugpwebz8cIUKgEh0LaYHu7mZObqw6SrkePoKAA7t2DCxfk2L5d7S0thbIynCMjekdTk7i7Afz6tVnV0bE1FGBhAfLy4N076OqSm8ik+nqYno63ARvBX76QZ7VmB969W86VlTA8DDk5mf2FhRCP883a+m/gZJLVVAqrKlHW68MHWcsTE7KMwmF5pJtpcRHsdmJKcEUF85EI32cKsCa7XdavyyXXoVBm8NwcFBUxpgRXVel9fr+4e/WqujzSdfmynAMBOHcOamo298ZiMDXFsttt9ivBp04Jn9erdT5+bO5vbFQHqa2VJbWmK1fkfWua2p9MwsAAqYYG/UfDEMtKsAxsHnr6VJv1+83K5mZYX1rl5XJkIyHA4yF18KB26/Rp4U3/pgDzF5h77t9nqLub1osXsezdu3XWpmtpSSbdkyeYhqF3NjWJ39Z7Nm0SbW2cHxtj4NkzzefzmbWGQU51NezcKZMqXakUfPwIkYj8k83MkKyrY+TYMdrdbhFXxc/YFo8fZwbMuvFxihYXtc6JCdzhsFm5vEy+zYYtkcCaSLCan89KcTGxkhLmXC59aNcu8bthsJopdlYPAdnYzT6gb2u3yCZk9i+Q/1pfAXgBFZGmIsvtAAAAAElFTkSuQmCC","contentType":"image/png","width":22,"height":15,"angle":0,"xoffset":0,"yoffset":0},"value":"Individual Business Minor","label":"Individual Business Minor Loss","description":""},{"symbol":{"type":"esriPMS","url":"ed918c998df1b03f027b1387bfcffe7d","imageData":"iVBORw0KGgoAAAANSUhEUgAAAB4AAAAeCAYAAAA7MK6iAAAAAXNSR0IB2cksfwAAAAlwSFlzAAAOxAAADsQBlSsOGwAAAchJREFUSInt1rFrFEEUx/FPzOkSrNwikjQiWohoIdfZWamQay3VKhBSCGolysXGQrRSAqbwf5CToPgXWBykEEmj5aVbbFcPY7F7Mnfn3V7OCWfhD4bZmX0z35l9M29fzYxU+5fADaxiJRKjnSTJ2zzPN0aCkyTZqOd58wUu4FgEapf6bp7XH7DW4hI6g+DlPM+bLxVvY6mm2MRTFlu8UnzRPvAKnB9esaxi8iM4joUxNmeLqh4uqKcGHB0Y8A0nK8A93cctxQ4HVYKW/gT+az0ryztcrbA9lOt0DV9xOib4Oe6Uz/v4jj28xpPAbhvrMcHzZQknOIOHJWyn7G/FBo/SAq4E4Pf4qTjxhwreV/i1p1OYG2MfDbyDN0H7ZmzwZ3wI2l18QXPArlExz4HBW2UZp0eCEBULXKXHuGf0oZoafAPXB/rmkOKcIiaP8+3U4Mu4fdBBMcCx9B88E3AHfiAJOuexFrQXpwTlo8Bpmm5lWbb6Sf/lP4HNKWGhdouqPQTOsqyNvXWWNnHRcBo0jbol9G7R/B30+nycpmnjY5a16kFuFFF90bYPXO56WZHQV8X5SdUp3dgOO0ed6kn+BRMry4YT5Jldp18IYV/TIYPOVwAAAABJRU5ErkJggg==","contentType":"image/png","width":22,"height":22,"angle":0,"xoffset":0,"yoffset":0},"value":"Public Business Total Loss","label":"Public Business Total Loss","description":""},{"symbol":{"type":"esriPMS","url":"ca6dbc334f766c6a1b0db5dee9863b07","imageData":"iVBORw0KGgoAAAANSUhEUgAAAB4AAAAeCAYAAAA7MK6iAAAAAXNSR0IB2cksfwAAAAlwSFlzAAAOxAAADsQBlSsOGwAAAiJJREFUSInt1j9oE1EAx/FvLn/OUkG8ITUVWv8hIhVaDhFcxIJooAeK0EWoDlJSOgjWpVJJXRREp0rRDN3EWU6qUnAXPThEpYsVpSbb06XD6ZE4XNpLct61SV6Jgz94w3v37n3e/XmPl6BDSfxLsAGMAyOSDEtV1eeO48yGwqqqzup7nPxcDgb6IRVvX3XL6Murjn7zCROmzRBQbIR7HcfJP8zB0IH2wfUkFBjog3tjpE2bx3hvtA4eATjaF5gxYi16cAXo3gFdyfA+hzIA6BsTqrlmACQbvvrPNei5Gg2v50YWLg97T9iYhAJA5m9w27n/wisvp+HsYHTfbVlO5+7CyhzsT0uEH1yCa9WFVgF+uVD6AQtLcMf0+y1aMJmVCMcVr2wMkIKDPTAzCovvwC557eZbyXBYulJwetCHX32EcgWU2DbDFWCl5Nf7NYiFoFJh+ws8s/362CmIcJuHP32Hpfd+3S3D5xLkn9b3M45Hj9M0XHjtlajcugD6Jtuu9HV8+yJMnQ//qVqGR09AtmFXiimg7YQje709eROzNfjkYbgy3OxdEmBZ+Q93BC4C/HZBrWmNKzBxxq+nd7UGOW4IrGlaQQgx/uFb/eLf3Q3zWzyBRGV5FQArAAshLKA0+YjMfA6O7YOkEri/6bhlD72+AEAhAANomma8+SpMfdo/G0lMIRSuPnUv3oHekAQWq5/Rqm0M+6vrZtduhBCBto4tpz8u9oo5ZNV6zwAAAABJRU5ErkJggg==","contentType":"image/png","width":22,"height":22,"angle":0,"xoffset":0,"yoffset":0},"value":"Public Business Major","label":"Public Business Major Damage","description":""},{"symbol":{"type":"esriPMS","url":"98d04bb7ec69a041389e4c1609cc1837","imageData":"iVBORw0KGgoAAAANSUhEUgAAAB4AAAAeCAYAAAA7MK6iAAAAAXNSR0IB2cksfwAAAAlwSFlzAAAOxAAADsQBlSsOGwAAAgpJREFUSIntlrFKK0EUhr+Y1SVYuUVEGxEtRLQI29lZqeC2lmolhBSCWokSbSxEKyVwU/gOspeg+AQWgRQiabRMusF2dDEWY7JZ4+69bkZi4Q8DO2fPzDczZ85wDHok4yeBHWADWNbEKJum+VdKeRAKNk3zwLZl/uwMZmZgYKB7qudhV6vS3t0l67pkgNpH8KiUMn9+DplM98CmDENt4viYtOvyB3WiAfAywPR0x4oRInryvj4YHIRUKtxnchIAu7Wgtn8OQH9/cMDTEwwPR4Ob2tmBtTW1w48yFGnkM3DXOjlR7eoKFhaifb8lnRYX4fERxsc1gk9PYXNTfTca8PwM9TpcXMDRke9XKkEupxGcTKrWmsCAiQnY21OwSkXZXVczOEypFMzP++Dra3h9VTf+W8GNhoprU2NjkEiE+2sDVypween3V1c1g+/v4ebG73sePDxAPh/0c5zoeb4MLhZVi9L+Pth2tI/2PD48hO3t8EsVG7yyAktLQVsiAZYFU1PqTY6KbWzw3Bysr391lAawLv2CewKuAby8gGn6xmQSslm/n07HA0kZArYsqyiE2Li7Cyb/0BAUCvFg7apWASh3gIUQZaCeyzFSKMDsbGcZFEeep6BbWwC03rxAjC3Lcm5vhWvbfm2kUcVQ8PuuR1EF/T+e+f9W7T2M5XZj2K0OrK5biU/q456l0xsnH40YgZexrwAAAABJRU5ErkJggg==","contentType":"image/png","width":22,"height":22,"angle":0,"xoffset":0,"yoffset":0},"value":"Public Business Minor","label":"Public Business Minor Damage","description":""}]},"transparency":0,"labelingInfo":null}
HasZ: false

HasM: false

Has Attachments: true

Has Geometry Properties: false

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Object ID Field: OBJECTID

Unique ID Field:

Global ID Field: GlobalID

Type ID Field: PA_Damage_Category

Fields:

OBJECTID (type: esriFieldTypeOID, alias: OBJECTID, SQL Type: sqlTypeOther, length: 0, nullable: false, editable: false)
Access (type: esriFieldTypeString, alias: Access, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])
Assistance_Type (type: esriFieldTypeString, alias: Assistance Type, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [IA: IA], [PA: PA])
Contact_Owner_Name (type: esriFieldTypeString, alias: Contact Owner Name, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
Business_Address_Number (type: esriFieldTypeString, alias: Business Address Number, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
Street_Road_Name (type: esriFieldTypeString, alias: Street/Road Name, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
City_Town_Name (type: esriFieldTypeString, alias: City/Town Name, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
Phone (type: esriFieldTypeString, alias: Phone, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
Non_Profit_or_Profit (type: esriFieldTypeString, alias: Non-Profit or Profit, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [Non-Profit Business: Non-Profit Business], [Profit Business: Profit Business], [Non-Profit Agriculture: Non-Profit Agriculture], ... 1 more ...)
PA_Damage_Category (type: esriFieldTypeString, alias: PA Damage, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [Public Business Minor: Public Business Minor Damage], [Public Business Major: Public Business Major Damage], [Public Business Total Loss: Public Business Total Loss], ... 3 more ...)
Dollar_Estimate (type: esriFieldTypeString, alias: Damage Dollar Estimate, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
Insurance (type: esriFieldTypeString, alias: Insurance, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No], [Unknown: Unknown], ... 1 more ...)
Percent_of_Damage_Insured (type: esriFieldTypeString, alias: Percent of Damage Insured, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
Flood_Zone (type: esriFieldTypeString, alias: Flood Zone, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No], [Unknown: Unknown])
Flood_Damage_Depth_Ft (type: esriFieldTypeString, alias: Flood Damage Depth in Feet, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [None: None], [0: 0], [1: 1], ... 24 more ...)
Flood_Damage_Depth_Inches (type: esriFieldTypeString, alias: Flood Damage Depth in Inches, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [none: none], [0: 0], [1: 1], ... 10 more ...)
Number_Employees_Unemployed (type: esriFieldTypeString, alias: Number of Employees Unemployed, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
Length_of_Unemployment (type: esriFieldTypeString, alias: Length of Unemployment, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
PA_Damage_Estimate_Buildings (type: esriFieldTypeString, alias: Damage Estimate of Buildings, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
PA_Damage_Estimate_Planted_Crop (type: esriFieldTypeString, alias: Damage Estimate of Planted Crops, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
PA_Damage_Estimate_Equipment (type: esriFieldTypeString, alias: Damage Estimate of Equipment, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
PA_Damage_Estimate_Livestock_Po (type: esriFieldTypeString, alias: Damage Estimate of Livestock and Poultry, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
Date (type: esriFieldTypeDate, alias: Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
Comments_Details (type: esriFieldTypeString, alias: Comments/Details, SQL Type: sqlTypeOther, length: 300, nullable: true, editable: true)
GlobalID (type: esriFieldTypeGlobalID, alias: GlobalID, SQL Type: sqlTypeOther, length: 38, nullable: false, editable: false)
CreationDate (type: esriFieldTypeDate, alias: CreationDate, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: false)
Creator (type: esriFieldTypeString, alias: Creator, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: false)
EditDate (type: esriFieldTypeDate, alias: EditDate, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: false)
Editor (type: esriFieldTypeString, alias: Editor, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: false)

Types:

Field Name: Access
Inherited
Field Name: Assistance_Type
Inherited
Field Name: Non_Profit_or_Profit
Inherited
Field Name: PA_Damage_Category
Inherited
Field Name: Insurance
Inherited
Field Name: Flood_Zone
Inherited
Field Name: Flood_Damage_Depth_Ft
Inherited
Field Name: Flood_Damage_Depth_Inches
Inherited

PA_Damage_Category: Public Business Minor

Field Name: Access
Inherited
Field Name: Assistance_Type
Inherited
Field Name: Non_Profit_or_Profit
Inherited
Field Name: PA_Damage_Category
Inherited
Field Name: Insurance
Inherited
Field Name: Flood_Zone
Inherited
Field Name: Flood_Damage_Depth_Ft
Inherited
Field Name: Flood_Damage_Depth_Inches
Inherited

PA_Damage_Category: Individual Business Major

Field Name: Access
Inherited
Field Name: Assistance_Type
Inherited
Field Name: Non_Profit_or_Profit
Inherited
Field Name: PA_Damage_Category
Inherited
Field Name: Insurance
Inherited
Field Name: Flood_Zone
Inherited
Field Name: Flood_Damage_Depth_Ft
Inherited
Field Name: Flood_Damage_Depth_Inches
Inherited

PA_Damage_Category: Public Business Total Loss

Field Name: Access
Inherited
Field Name: Assistance_Type
Inherited
Field Name: Non_Profit_or_Profit
Inherited
Field Name: PA_Damage_Category
Inherited
Field Name: Insurance
Inherited
Field Name: Flood_Zone
Inherited
Field Name: Flood_Damage_Depth_Ft
Inherited
Field Name: Flood_Damage_Depth_Inches
Inherited

PA_Damage_Category: Individual Business Total Loss

Field Name: Access
Inherited
Field Name: Assistance_Type
Inherited
Field Name: Non_Profit_or_Profit
Inherited
Field Name: PA_Damage_Category
Inherited
Field Name: Insurance
Inherited
Field Name: Flood_Zone
Inherited
Field Name: Flood_Damage_Depth_Ft
Inherited
Field Name: Flood_Damage_Depth_Inches
Inherited

PA_Damage_Category: Public Business Major

Field Name: Access
Inherited
Field Name: Assistance_Type
Inherited
Field Name: Non_Profit_or_Profit
Inherited
Field Name: PA_Damage_Category
Inherited
Field Name: Insurance
Inherited
Field Name: Flood_Zone
Inherited
Field Name: Flood_Damage_Depth_Ft
Inherited
Field Name: Flood_Damage_Depth_Inches
Inherited

PA_Damage_Category: Individual Business Minor

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 12/28/2018 7:00:49 PM

Schema Last Edit Date: 12/28/2018 7:00:49 PM

Data Last Edit Date: 12/28/2018 7:00:49 PM

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