Layer: Laadpalen (ID:0)

View In: Map Viewer

Name: Laadpalen

Display Field: type_laadp

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description: Laadpalen_20200907

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:

Drawing Info:

{"renderer":{"type":"uniqueValue","field1":"Status_laadpaal","uniqueValueInfos":[{"value":"Bestaande laadpaal","symbol":{"angle":0,"xoffset":0,"yoffset":0,"type":"esriPMS","url":"9817b36e-8abf-40fa-9861-1cb1b6923b66","imageData":"iVBORw0KGgoAAAANSUhEUgAAAEAAAABACAYAAACqaXHeAAAAGXRFWHRTb2Z0d2FyZQBBZG9iZSBJbWFnZVJlYWR5ccllPAAAAyJpVFh0WE1MOmNvbS5hZG9iZS54bXAAAAAAADw/eHBhY2tldCBiZWdpbj0i77u/IiBpZD0iVzVNME1wQ2VoaUh6cmVTek5UY3prYzlkIj8+IDx4OnhtcG1ldGEgeG1sbnM6eD0iYWRvYmU6bnM6bWV0YS8iIHg6eG1wdGs9IkFkb2JlIFhNUCBDb3JlIDUuMC1jMDYwIDYxLjEzNDc3NywgMjAxMC8wMi8xMi0xNzozMjowMCAgICAgICAgIj4gPHJkZjpSREYgeG1sbnM6cmRmPSJodHRwOi8vd3d3LnczLm9yZy8xOTk5LzAyLzIyLXJkZi1zeW50YXgtbnMjIj4gPHJkZjpEZXNjcmlwdGlvbiByZGY6YWJvdXQ9IiIgeG1sbnM6eG1wPSJodHRwOi8vbnMuYWRvYmUuY29tL3hhcC8xLjAvIiB4bWxuczp4bXBNTT0iaHR0cDovL25zLmFkb2JlLmNvbS94YXAvMS4wL21tLyIgeG1sbnM6c3RSZWY9Imh0dHA6Ly9ucy5hZG9iZS5jb20veGFwLzEuMC9zVHlwZS9SZXNvdXJjZVJlZiMiIHhtcDpDcmVhdG9yVG9vbD0iQWRvYmUgUGhvdG9zaG9wIENTNSBNYWNpbnRvc2giIHhtcE1NOkluc3RhbmNlSUQ9InhtcC5paWQ6MEI0ODdCMkVEMjcwMTFFMEFFOTVFRTBGMDE2NDc1MDUiIHhtcE1NOkRvY3VtZW50SUQ9InhtcC5kaWQ6MEI0ODdCMkZEMjcwMTFFMEFFOTVFRTBGMDE2NDc1MDUiPiA8eG1wTU06RGVyaXZlZEZyb20gc3RSZWY6aW5zdGFuY2VJRD0ieG1wLmlpZDowQjQ4N0IyQ0QyNzAxMUUwQUU5NUVFMEYwMTY0NzUwNSIgc3RSZWY6ZG9jdW1lbnRJRD0ieG1wLmRpZDowQjQ4N0IyREQyNzAxMUUwQUU5NUVFMEYwMTY0NzUwNSIvPiA8L3JkZjpEZXNjcmlwdGlvbj4gPC9yZGY6UkRGPiA8L3g6eG1wbWV0YT4gPD94cGFja2V0IGVuZD0iciI/PkS8gO0AAALLSURBVHja7JtNb9swDIZlt0Ox9JYeetph6KGn/P//ZGBdu6EtbMf2+KZkRqiym262pdgUwCqxnUh8SOqLadZ1nVtzyd3KiwEwAAbAABgAA2AADIABMAAGwAAYgDWWy//5cJZlySn02fMN84CRvicj8u2cHSfvu6aqYUHbHUscAPiz2+1cnucHQXjoEBHXlLpt23fXca1pGrff711d1wepquogZVke70Oo3JCUJK8kFUkdE0AuSogigBBS1gehn4FAeQEQUh7P4z6VbyS/SR5IfilPiALgQlsRlhelteJafOXxWqyvAfjKozCAe5KCm6jZC/ZRAaCT2vW1wqJkHwARfAcUFwB4L5+VgnvsASg/SR6lD1HHAI7NoOW1lUPhIMpDOfEAgeJPbWoMgOt/JfkifUgGgCilldDXfABiaa14SHkVAhuSK1Y+jw1AW+bYcV1rVw4B0M/49/vaSWkdoC0TVEgGMR9CaCrUA+hZAdCWA4wQhNAU6E+hp3pakgC0pWXRIteG1gF6vXBKO0kC0HEuisMTfMX92B6K9zE2PLOHgIAIuXyf+0+545sNgD8O9Fk+BGERAIasOhQCizkR8uf9IS+Y89AjyhgQ2gCN1fGkAeiZ4DNz+yIA6Cnvo+XsokNgCqufxUJoSqufjQfMUcZsJ0/RKnO2NRoA2QobgLUCGHOPfpZL4Tk9YMyc5OWYblkUxfFEF7U+EOk7DD11syTZJsk8pQag2263d1R/J9lxfUtyPZETPJO8uLfUGJIEkhuMB4A7gjzdE8kPvr6ZCMALt/HEbdaxATRsDeTqJF2FpMXVRABKVr7gNkvuQ1QAsMQDv0e6SjI2UxTxNkmOvsYGgBis2Oro3KP7m7GZZDXM7ej0eJvCGNBwZ5CozNw/pqtObK9z738gERVAxx2Zb0EQexpcwj9c2e8EDYABMAAGwAAYAANgANZa/ggwAIc7yL2dnKfvAAAAAElFTkSuQmCC","contentType":"image/png","width":15,"height":15},"label":"Bestaande laadpaal"},{"value":"Laadpaal in ontwikkeling","symbol":{"angle":0,"xoffset":0,"yoffset":0,"type":"esriPMS","url":"e7e15542-d211-4584-bd83-e27aa70202f3","imageData":"iVBORw0KGgoAAAANSUhEUgAAAEAAAABACAYAAACqaXHeAAAAGXRFWHRTb2Z0d2FyZQBBZG9iZSBJbWFnZVJlYWR5ccllPAAAAyJpVFh0WE1MOmNvbS5hZG9iZS54bXAAAAAAADw/eHBhY2tldCBiZWdpbj0i77u/IiBpZD0iVzVNME1wQ2VoaUh6cmVTek5UY3prYzlkIj8+IDx4OnhtcG1ldGEgeG1sbnM6eD0iYWRvYmU6bnM6bWV0YS8iIHg6eG1wdGs9IkFkb2JlIFhNUCBDb3JlIDUuMC1jMDYwIDYxLjEzNDc3NywgMjAxMC8wMi8xMi0xNzozMjowMCAgICAgICAgIj4gPHJkZjpSREYgeG1sbnM6cmRmPSJodHRwOi8vd3d3LnczLm9yZy8xOTk5LzAyLzIyLXJkZi1zeW50YXgtbnMjIj4gPHJkZjpEZXNjcmlwdGlvbiByZGY6YWJvdXQ9IiIgeG1sbnM6eG1wPSJodHRwOi8vbnMuYWRvYmUuY29tL3hhcC8xLjAvIiB4bWxuczp4bXBNTT0iaHR0cDovL25zLmFkb2JlLmNvbS94YXAvMS4wL21tLyIgeG1sbnM6c3RSZWY9Imh0dHA6Ly9ucy5hZG9iZS5jb20veGFwLzEuMC9zVHlwZS9SZXNvdXJjZVJlZiMiIHhtcDpDcmVhdG9yVG9vbD0iQWRvYmUgUGhvdG9zaG9wIENTNSBNYWNpbnRvc2giIHhtcE1NOkluc3RhbmNlSUQ9InhtcC5paWQ6MkY1QkQxNEVEMjgwMTFFMEFFOTVFRTBGMDE2NDc1MDUiIHhtcE1NOkRvY3VtZW50SUQ9InhtcC5kaWQ6MkY1QkQxNEZEMjgwMTFFMEFFOTVFRTBGMDE2NDc1MDUiPiA8eG1wTU06RGVyaXZlZEZyb20gc3RSZWY6aW5zdGFuY2VJRD0ieG1wLmlpZDoyRjVCRDE0Q0QyODAxMUUwQUU5NUVFMEYwMTY0NzUwNSIgc3RSZWY6ZG9jdW1lbnRJRD0ieG1wLmRpZDoyRjVCRDE0REQyODAxMUUwQUU5NUVFMEYwMTY0NzUwNSIvPiA8L3JkZjpEZXNjcmlwdGlvbj4gPC9yZGY6UkRGPiA8L3g6eG1wbWV0YT4gPD94cGFja2V0IGVuZD0iciI/PmLCBcwAAAOiSURBVHja7JvPUtswEMZlA2UKN3roodNDp4ee+lg99rX6cMyUQjv8CbJ2u+vs2ivFTpyQYDGRZhYZx479/fRpLUtQIaI75lK7Iy8FQAFQABQABUABUAAUAAVAAVAAFAAFwDGW05ecXFVVdoK2nd8oDtjT91REHl7zxsl9l1QFCb42SswDoP356xN56kSMVXe7xZxSw3AN9Dk2FM8UjyRrsTxF5UEvF3+253ygoIMcHezoJOfnBFD3YobyghELCQg1TiueNOATfeRHxfN20zR8xmeKfxQ3FH/N0bMAOOnEgLZ2iAEgxHV7mB4j6kBaHZIIMQwB8I3iWr7AiwuamQGwfckMVW1aF0So+hd6OF3rm16CifABAN57dQCXPxS33T3MmgMYgBVkBXM9lqYwiTWtzxFC0BzA1n9PcTbS914bwJMRBXHLuiRP4wiEIfubuum7wAXFuYiv5wYgXR1Wkz6OCMcJDkjEe2793gFZjQM2ixpywbr+bwOXLR/eDAB8IYAERoAeQIO5A9gEYUy8M+JNy6MI5+FDFwBv1AE4MQeYCEZ4ECD7XNDdL4Ap4rcE0G1G2zkD2NQ13MQngoqW0AHm8nfMvAu4NX1+UxI0+8G2vkSur8PrW3tKF1jjgJWvz9oBu+aA5HyUzI8urt2bAQAj2xPER9kfTPZXGNkCgBEIMOF9wJzXJAMfxHgckLcDYKTe0AU00+ugJ8jYH2XbOiLfgVDYDEGFaiOi2e4GPNryIryDkn0OgDXDWWth12d5Zwc52veN4CgPdC+dGTqAW6VK3uJQX17A9t9VB0TdwAx7rXDA+FrZAeBJirN04sK8yDTSBQBXxVsHoOuFrz7+eDo8ZwBm4qIFEOK+rOIxsX/3ALHPfYxHgdBPPecJoH1Hp7t8DkvxHqQlTSLTPr6SA4ackHSVFlK148znaznA26wNySyOsTRi8hQ0boBk3+AE5B7XJPeaBG9/XC9BeN/W7AoNztwcfJxa2FrZ7huyeF3XrXCuT+s6OwB4dXX1leovFN+l/khxeaAX7HuKB7dcGvPJWHMeAHIjvE53R/Fb9l8cCMCDXONOrunnBhCkNXitTpereNHi/EAAFiL+Wq65cPFa3CwAuCVu5HdertIVm0MUdZsujj7uCqB6yTPVZONaxL4T4XbF5hAFBEK6PA7b6tl3DghyM/y4rtyOy1VbzDykfyAxmwOyKdvqqco/TR15KQAKgAKgACgACoACoAA42vJfgAEAYxifbVSwuOoAAAAASUVORK5CYII=","contentType":"image/png","width":15,"height":15},"label":"Laadpaal in ontwikkeling"},{"value":"Mogelijke laadpaal","symbol":{"angle":0,"xoffset":0,"yoffset":0,"type":"esriPMS","url":"dd31208e-7d37-4201-becb-995761651f0c","imageData":"iVBORw0KGgoAAAANSUhEUgAAAEAAAABACAYAAACqaXHeAAAAGXRFWHRTb2Z0d2FyZQBBZG9iZSBJbWFnZVJlYWR5ccllPAAAAyJpVFh0WE1MOmNvbS5hZG9iZS54bXAAAAAAADw/eHBhY2tldCBiZWdpbj0i77u/IiBpZD0iVzVNME1wQ2VoaUh6cmVTek5UY3prYzlkIj8+IDx4OnhtcG1ldGEgeG1sbnM6eD0iYWRvYmU6bnM6bWV0YS8iIHg6eG1wdGs9IkFkb2JlIFhNUCBDb3JlIDUuMC1jMDYwIDYxLjEzNDc3NywgMjAxMC8wMi8xMi0xNzozMjowMCAgICAgICAgIj4gPHJkZjpSREYgeG1sbnM6cmRmPSJodHRwOi8vd3d3LnczLm9yZy8xOTk5LzAyLzIyLXJkZi1zeW50YXgtbnMjIj4gPHJkZjpEZXNjcmlwdGlvbiByZGY6YWJvdXQ9IiIgeG1sbnM6eG1wPSJodHRwOi8vbnMuYWRvYmUuY29tL3hhcC8xLjAvIiB4bWxuczp4bXBNTT0iaHR0cDovL25zLmFkb2JlLmNvbS94YXAvMS4wL21tLyIgeG1sbnM6c3RSZWY9Imh0dHA6Ly9ucy5hZG9iZS5jb20veGFwLzEuMC9zVHlwZS9SZXNvdXJjZVJlZiMiIHhtcDpDcmVhdG9yVG9vbD0iQWRvYmUgUGhvdG9zaG9wIENTNSBNYWNpbnRvc2giIHhtcE1NOkluc3RhbmNlSUQ9InhtcC5paWQ6MTI0NTQwRTVEMjlBMTFFMEFFOTVFRTBGMDE2NDc1MDUiIHhtcE1NOkRvY3VtZW50SUQ9InhtcC5kaWQ6MTI0NTQwRTZEMjlBMTFFMEFFOTVFRTBGMDE2NDc1MDUiPiA8eG1wTU06RGVyaXZlZEZyb20gc3RSZWY6aW5zdGFuY2VJRD0ieG1wLmlpZDoxMjQ1NDBFM0QyOUExMUUwQUU5NUVFMEYwMTY0NzUwNSIgc3RSZWY6ZG9jdW1lbnRJRD0ieG1wLmRpZDoxMjQ1NDBFNEQyOUExMUUwQUU5NUVFMEYwMTY0NzUwNSIvPiA8L3JkZjpEZXNjcmlwdGlvbj4gPC9yZGY6UkRGPiA8L3g6eG1wbWV0YT4gPD94cGFja2V0IGVuZD0iciI/Pq0+xwoAAAPASURBVHja7JrNbtswDMclt1ux9rT2sNMOww7FDnv/p9kLFFi3bliL1DY50SZtSpbdD9ixgFIFYydOk/x/pChKskdE95abNwAGwAAYAANgAAyAATAABsAAGAADYAAMwMv+2fviBL1UjwFYCQB9Dhw1dL2/CIeWjb4be/0v03O61u+hh98/vENmUoW/+OOb7hEcJB5IXdgr6Y7YXwd+H7Jdfes+4yrYIdhDsMdgNUPYBUClBRGEXujjRKxfDF8FYUY8BH83TQfzc7C/wW6D/VGRsAuAk0WvuqmXXc5dOIKYE9+OAK6D3fB/1ky72RcAuqmLcSEuMfMUR9ESCXRKwtsgrw1U6rqWCKD2i3pf6oRdcgC6hV6Y8zq6SRcB1QXkSKJJfMMR0NJDnwMo9D8Ee+eWe9dxAMx5F2fE6ibCvcuLrxsRP3SB82BnLL7aG8CTokUwqOsags8kwVR8w12AI2CVdrqJfpyGNc6MApgbBpOwB2DvgyTCQgEsCZ8VnBkBQISCCvtWv1YqgEyoe5z3dG4E6MTDKF7Oqc6E4TqUCeBZ4nGGgYhTEFCdg7q+5gx29Qh4jvhcrkBVAoMqfqJ6YDhfD0C1zRz7GXVAKh5Hj+vn6HLnhQKAJzL8ovgFKFE0rNxO3TEa5rM9qqgYIoCjIH1PDAbLToLpzE4/jzyeVH25xBflBHjdosfRIyCq6FRxA0lS0++VazT0RRBAZ//CR4E044t4GccHL7t8VEgEpIUPYFwHlB0BOC1qIg/CtG/rJNfCWAl2EFCBgMILIZcKYQFS0eUyus4HwJEyVIE4jYKic4AWrkvZtJrLJkY1D2gViKEq1PmixAggr+h+S1NXPYtDyFR4LjMUqrmAFq41FxkBtEgRr9qMiUy6QScGMuKTik+E62FRCq2qZABNqxYu2hGG9GXATB0AcY2UJkpQi6TdarMvFADN0Ulst3ojkaDzgQyFLh8B0XCoRasu4t1rF76OFQFNLLhtxmSoQzodBsHFy+ESGdrPehduzS25VZPgx+ubDgQtW3c5oYuK3ihzk9H7JIR1KOvXciFeVVUnnI5kpQHAy8vLr+H4Jdh3Pn4KdrHR9OpfsHvXb43Vblx92w8A/xDap7sL9pNfP98IwD1/xx1/Z703gJa9QXt1sl1FmxZnGwE4sPgb/s4D/4ZdAZAnbvk5bVfJjs0WTaJNNkcfXgtgrfsDKhb7noXrHZstGjCEdHscdrtBgo0En7D59UftuGZyK9wgYbfI2F1iBsAAGAADYAAMgAEwAAbgbbb/AgwAHt9AXMrKIaIAAAAASUVORK5CYII=","contentType":"image/png","width":15,"height":15},"label":"Mogelijke laadpaal"}]},"labelingInfo":[{"labelExpression":null,"labelExpressionInfo":{"expression":"$feature[\"laadpaal_i\"]","value":"{laadpaal_i}"},"fieldInfos":[{"fieldName":"laadpaal_i","format":{"places":0,"digitSeparator":false}}],"useCodedValues":true,"maxScale":0,"minScale":25137,"where":null,"labelPlacement":"esriServerPointLabelPlacementAboveRight","symbol":{"color":[51,51,51,255],"type":"esriTS","backgroundColor":null,"borderLineColor":null,"haloSize":0,"haloColor":null,"horizontalAlignment":"center","rightToLeft":false,"angle":0,"xoffset":0,"yoffset":0,"text":"","rotated":false,"kerning":true,"font":{"size":9,"style":"normal","decoration":"none","weight":"bold","family":"Arial"}}}],"transparency":0}
HasZ: false

HasM: false

Has Attachments: false

Has Geometry Properties: false

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Object ID Field: OBJECTID_1

Unique ID Field:

Global ID Field: GlobalID

Type ID Field:

Fields:

OBJECTID_1 (type: esriFieldTypeOID, alias: OBJECTID_1, SQL Type: sqlTypeOther, length: 0, nullable: false, editable: false)
type_laadp (type: esriFieldTypeString, alias: type_laadp, SQL Type: sqlTypeOther, length: 254, nullable: true, editable: true, Coded Values: [Mogelijke laadpaal: Mogelijke laadpaal], [Laadplein < 4 plekken: Laadplein < 4 plekken], [Laadplein < 6 plekken: Laadplein < 6 plekken], ... 2 more ...)
laadpaal_i (type: esriFieldTypeInteger, alias: laadpaal_i, SQL Type: sqlTypeOther, nullable: true, editable: true)
geom (type: esriFieldTypeString, alias: geom, SQL Type: sqlTypeOther, length: 254, nullable: true, editable: true)
locatie_code (type: esriFieldTypeDouble, alias: locatie_code, SQL Type: sqlTypeOther, nullable: true, editable: true)
naam (type: esriFieldTypeString, alias: naam, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
laadpaal_nummer (type: esriFieldTypeString, alias: laadpaal nummer, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
type (type: esriFieldTypeDouble, alias: type, SQL Type: sqlTypeOther, nullable: true, editable: true)
straat (type: esriFieldTypeString, alias: straat, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
huisnummer (type: esriFieldTypeString, alias: huisnummer, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
postcode (type: esriFieldTypeString, alias: postcode, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
plaats (type: esriFieldTypeString, alias: plaats, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
lat (type: esriFieldTypeDouble, alias: lat, SQL Type: sqlTypeOther, nullable: true, editable: true)
lon (type: esriFieldTypeDouble, alias: lon, SQL Type: sqlTypeOther, nullable: true, editable: true)
laadpaal_num (type: esriFieldTypeString, alias: laadpaal_num, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
Kolom1 (type: esriFieldTypeString, alias: Kolom1, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
ObjectID (type: esriFieldTypeInteger, alias: ObjectID, SQL Type: sqlTypeOther, nullable: true, editable: true)
Operationeel_sinds (type: esriFieldTypeDate, alias: Operationeel sinds, SQL Type: sqlTypeOther, length: 0, nullable: true, editable: true)
Aanbieder (type: esriFieldTypeString, alias: Aanbieder, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true)
Bomenwacht (type: esriFieldTypeString, alias: Bomenwacht, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true, Coded Values: [Ja: Ja], [Nee: Nee])
Soort_laadpaal (type: esriFieldTypeString, alias: Soort laadpaal, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true, Coded Values: [Standaard: Standaard])
Status_laadpaal (type: esriFieldTypeString, alias: Status laadpaal, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true, Coded Values: [Mogelijke laadpaal: Mogelijke laadpaal], [Laadpaal in ontwikkeling: Laadpaal in ontwikkeling], [Bestaande laadpaal: Bestaande laadpaal], ... 1 more ...)
Laadpaal_toevoeging (type: esriFieldTypeString, alias: Laadpaal toevoeging, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true)
GlobalID (type: esriFieldTypeGlobalID, alias: GlobalID, SQL Type: sqlTypeOther, length: 38, nullable: false, editable: false)
Mogelijke_laadpaal (type: esriFieldTypeInteger, alias: Mogelijke_laadpaal, SQL Type: sqlTypeOther, nullable: true, editable: true)
Laadpaal_ontwikkeling (type: esriFieldTypeInteger, alias: Laadpaal_ontwikkeling, SQL Type: sqlTypeOther, nullable: true, editable: true)
Bestaande_laadpaal (type: esriFieldTypeInteger, alias: Bestaande_laadpaal, SQL Type: sqlTypeOther, nullable: true, editable: true)
CreationDate (type: esriFieldTypeDate, alias: CreationDate, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: false)
Creator (type: esriFieldTypeString, alias: Creator, SQL Type: sqlTypeOther, length: 128, 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: 128, nullable: true, editable: false)
Opmerking (type: esriFieldTypeString, alias: Opmerking, SQL Type: sqlTypeOther, length: 500, nullable: true, editable: true)
Relatics (type: esriFieldTypeString, alias: Relatics, SQL Type: sqlTypeOther, length: 500, nullable: true, editable: true)

Templates:

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 9/3/2024 12:48:24 PM

Schema Last Edit Date: 9/3/2024 12:48:24 PM

Data Last Edit Date: 9/3/2024 12:48:24 PM

Supported Operations: Query Query Pivot Query Top Features Query Analytic Query Bins Add Features Update Features Delete Features Apply Edits Calculate Generate Renderer Validate SQL Get Estimates ConvertFormat