Name: ROAD SEGMENTS
Display Field: STR_NAME
Type: Feature Layer
Geometry Type: esriGeometryPolyline
Description: This data represents a culmination of data from various sources originating with Jerry Forman with (formerally with Custer County Road Department) and with help form KLJ Engineering. This data is continually bein updated from sources such as Century Lin, Custer County, Miles City and Garfeld County sources. Updates to this data will be an ongoing process and will never be officially completed. It is possible that errors may exist within this data and Custer County 911 welcomes any suggestions of possible errors for review and correction. The data originated as GPS centerline road data created by the Montana Dept. of Transportation. Any additional roads added to the network such as towns and missing Streets and Avenues were heads up digitized using the most current version of 1 meter NAIP imagery.
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: -107.953926655
YMin: 45.748816639
XMax: -104.732665883558
YMax: 47.809801722
Spatial Reference: 4269 (4269)
Drawing Info:
{"renderer":{"type":"uniqueValue","field1":"St_PreTyp","field2":null,"field3":null,"defaultSymbol":{"type":"esriSLS","style":"esriSLSSolid","color":[0,0,0,255],"width":1},"defaultLabel":"ROAD","uniqueValueInfos":[{"symbol":{"type":"esriSLS","style":"esriSLSSolid","color":[250,52,17,255],"width":3.4},"value":"HIGHWAY","label":"HIGHWAY","description":""},{"symbol":{"type":"esriSLS","style":"esriSLSSolid","color":[250,52,17,255],"width":3.4},"value":"OLD HIGHWAY","label":"HIGHWAY","description":""},{"symbol":{"type":"esriSLS","style":"esriSLSSolid","color":[0,0,0,255],"width":3.4},"value":"INTERSTATE","label":"INTERSTATE","description":""},{"symbol":{"type":"esriSLS","style":"esriSLSSolid","color":[0,0,0,255],"width":1},"value":"ROAD","label":"ROAD","description":""},{"symbol":{"type":"esriSLS","style":"esriSLSSolid","color":[0,0,0,255],"width":3.4},"value":"UNITED STATES HIGHWAY","label":"UNITED STATES HIGHWAY","description":""}],"fieldDelimiter":","},"transparency":0,"labelingInfo":[{"labelPlacement":"esriServerLinePlacementAboveAlong","where":"\"St_PreTyp\" IN ('HIGHWAY' , 'OLD HIGHWAY' )","labelExpression":"[STR_NAME]","useCodedValues":true,"symbol":{"type":"esriTS","color":[0,0,0,255],"backgroundColor":null,"borderLineColor":null,"borderLineSize":null,"verticalAlignment":"baseline","horizontalAlignment":"left","rightToLeft":false,"angle":0,"xoffset":0,"yoffset":0,"kerning":true,"haloColor":null,"haloSize":null,"font":{"family":"Arial","size":8,"style":"normal","weight":"bold","decoration":"none"}},"minScale":500000,"maxScale":0},{"labelPlacement":"esriServerLinePlacementAboveAlong","where":"(\"St_PreTyp\" = 'INTERSTATE' )","labelExpression":"[STR_NAME]","useCodedValues":true,"symbol":{"type":"esriTS","color":[255,255,255,255],"backgroundColor":null,"borderLineColor":null,"borderLineSize":null,"verticalAlignment":"baseline","horizontalAlignment":"left","rightToLeft":false,"angle":0,"xoffset":0,"yoffset":0,"kerning":true,"haloColor":null,"haloSize":null,"font":{"family":"Arial","size":7,"style":"normal","weight":"bold","decoration":"none"}},"minScale":500000,"maxScale":0},{"labelPlacement":"esriServerLinePlacementAboveAlong","where":"(\"St_PreTyp\" = 'ROAD' )","labelExpression":"[Fullname]","useCodedValues":true,"symbol":{"type":"esriTS","color":[0,0,0,255],"backgroundColor":null,"borderLineColor":null,"borderLineSize":null,"verticalAlignment":"baseline","horizontalAlignment":"left","rightToLeft":false,"angle":0,"xoffset":0,"yoffset":0,"kerning":true,"haloColor":[255,255,255,255],"haloSize":1,"font":{"family":"Arial","size":8,"style":"normal","weight":"bold","decoration":"none"}},"minScale":200000,"maxScale":0},{"labelPlacement":"esriServerLinePlacementAboveAlong","where":"(\"St_PreTyp\" = 'UNITED STATES HIGHWAY' )","labelExpression":"[STR_NAME]","useCodedValues":true,"symbol":{"type":"esriTS","color":[0,0,0,255],"backgroundColor":null,"borderLineColor":null,"borderLineSize":null,"verticalAlignment":"baseline","horizontalAlignment":"left","rightToLeft":false,"angle":0,"xoffset":0,"yoffset":0,"kerning":true,"haloColor":null,"haloSize":null,"font":{"family":"Arial","size":8,"style":"normal","weight":"bold","decoration":"none"}},"minScale":500000,"maxScale":0},{"labelPlacement":"esriServerLinePlacementAboveAlong","where":"NOT ((\"St_PreTyp\" = 'HIGHWAY' ) OR (\"St_PreTyp\" = 'OLD HIGHWAY' ) OR (\"St_PreTyp\" = 'INTERSTATE' ) OR (\"St_PreTyp\" = 'ROAD' ) OR (\"St_PreTyp\" = 'UNITED STATES HIGHWAY' ))","labelExpression":"[Fullname]","useCodedValues":true,"symbol":{"type":"esriTS","color":[0,0,0,255],"backgroundColor":null,"borderLineColor":null,"borderLineSize":null,"verticalAlignment":"baseline","horizontalAlignment":"left","rightToLeft":false,"angle":0,"xoffset":0,"yoffset":0,"kerning":true,"haloColor":[255,255,255,253],"haloSize":1,"font":{"family":"Arial","size":8,"style":"normal","weight":"bold","decoration":"none"}},"minScale":200000,"maxScale":0}]}
HasZ: false
HasM: false
Has Attachments: false
Has Geometry Properties: true
HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText
Object ID Field: OBJECTID
Unique ID Field:
IsSystemMaintained : True
Global ID Field: GlobalID
Type ID Field: St_PreTyp
Fields:
- OBJECTID (type: esriFieldTypeOID, alias: OBJECTID, SQL Type: sqlTypeOther, length: 0, nullable: false, editable: false)
- LENGTH (type: esriFieldTypeDouble, alias: LENGTH, SQL Type: sqlTypeOther, nullable: true, editable: true)
- LFROM (type: esriFieldTypeDouble, alias: LFROM, SQL Type: sqlTypeOther, nullable: true, editable: true)
- LTO (type: esriFieldTypeDouble, alias: LTO, SQL Type: sqlTypeOther, nullable: true, editable: true)
- RFROM (type: esriFieldTypeDouble, alias: RFROM, SQL Type: sqlTypeOther, nullable: true, editable: true)
- RTO (type: esriFieldTypeDouble, alias: RTO, SQL Type: sqlTypeOther, nullable: true, editable: true)
- PRE_DIR (type: esriFieldTypeString, alias: PRE_DIR, SQL Type: sqlTypeOther, length: 15, nullable: true, editable: true, Coded Values: [N: N], [S: S], [E: E], ... 5 more ...)
- PRE_TYPE (type: esriFieldTypeString, alias: PRE_TYPE, SQL Type: sqlTypeOther, length: 15, nullable: true, editable: true)
- SUF_DIR (type: esriFieldTypeString, alias: SUF_DIR, SQL Type: sqlTypeOther, length: 15, nullable: true, editable: true)
- ESNL (type: esriFieldTypeString, alias: ESNL, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true)
- ESNR (type: esriFieldTypeString, alias: ESNR, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true)
- STATUS (type: esriFieldTypeString, alias: STATUS, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true)
- MINUTES (type: esriFieldTypeDouble, alias: MINUTES, SQL Type: sqlTypeOther, nullable: true, editable: true)
- MILES (type: esriFieldTypeDouble, alias: MILES, SQL Type: sqlTypeOther, nullable: true, editable: true)
- STR_NAME (type: esriFieldTypeString, alias: STR_NAME, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
- Fullname (type: esriFieldTypeString, alias: Fullname, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
- Community (type: esriFieldTypeString, alias: Community, SQL Type: sqlTypeOther, length: 30, nullable: true, editable: true)
- State (type: esriFieldTypeString, alias: State, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true, Coded Values: [ND: ND], [MT: MT], [WY: WY], ... 2 more ...)
- Str_type (type: esriFieldTypeString, alias: Str_type, SQL Type: sqlTypeOther, length: 15, nullable: true, editable: true, Coded Values: [AVE: AVE], [BLVD: BLVD], [CIR: CIR], ... 71 more ...)
- COUNTY (type: esriFieldTypeString, alias: COUNTY, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
- LENGTHFT (type: esriFieldTypeDouble, alias: LENGTHFT, SQL Type: sqlTypeOther, nullable: true, editable: true)
- RD_CLASS (type: esriFieldTypeSmallInteger, alias: RD_CLASS, SQL Type: sqlTypeOther, nullable: true, editable: true)
- RATE (type: esriFieldTypeSmallInteger, alias: RATE, SQL Type: sqlTypeOther, nullable: true, editable: true)
- LABEL (type: esriFieldTypeString, alias: LABEL, SQL Type: sqlTypeOther, length: 75, nullable: true, editable: true)
- PRINCIPAL (type: esriFieldTypeSmallInteger, alias: PRINCIPAL, SQL Type: sqlTypeOther, nullable: true, editable: true)
- AdNumPre_L (type: esriFieldTypeString, alias: AdNumPre_L, SQL Type: sqlTypeOther, length: 15, nullable: true, editable: true)
- AdNumPre_R (type: esriFieldTypeString, alias: AdNumPre_R, SQL Type: sqlTypeOther, length: 15, nullable: true, editable: true)
- FromAddr_L (type: esriFieldTypeInteger, alias: FromAddr_L, SQL Type: sqlTypeOther, nullable: true, editable: true)
- ToAddr_L (type: esriFieldTypeInteger, alias: ToAddr_L, SQL Type: sqlTypeOther, nullable: true, editable: true)
- FromAddr_R (type: esriFieldTypeInteger, alias: FromAddr_R, SQL Type: sqlTypeOther, nullable: true, editable: true)
- ToAddr_R (type: esriFieldTypeInteger, alias: ToAddr_R, SQL Type: sqlTypeOther, nullable: true, editable: true)
- Parity_L (type: esriFieldTypeString, alias: Parity_L, SQL Type: sqlTypeOther, length: 1, nullable: true, editable: true, Coded Values: [E: E], [O: O], [Z: Z], ... 1 more ...)
- Parity_R (type: esriFieldTypeString, alias: Parity_R, SQL Type: sqlTypeOther, length: 1, nullable: true, editable: true, Coded Values: [E: E], [O: O], [Z: Z], ... 1 more ...)
- St_PreMod (type: esriFieldTypeString, alias: St_PreMod, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
- St_PreDir (type: esriFieldTypeString, alias: St_PreDir, SQL Type: sqlTypeOther, length: 9, nullable: true, editable: true, Coded Values: [NORTH: NORTH], [SOUTH: SOUTH], [EAST: EAST], ... 5 more ...)
- St_PreTyp (type: esriFieldTypeString, alias: St_PreTyp, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [HIGHWAY: HIGHWAY], [INTERSTATE: INTERSTATE], [OLD HIGHWAY: OLD HIGHWAY], ... 2 more ...)
- St_PreSep (type: esriFieldTypeString, alias: St_PreSep, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true, Coded Values: [OF THE: OF THE], [AT: AT], [DE LAS: DE LAS], ... 6 more ...)
- St_Name (type: esriFieldTypeString, alias: St_Name, SQL Type: sqlTypeOther, length: 60, nullable: true, editable: true)
- St_PosTyp (type: esriFieldTypeString, alias: St_PosTyp, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [AVENUE: AVENUE], [STREET: STREET], [ROAD: ROAD], ... 10 more ...)
- St_PosDir (type: esriFieldTypeString, alias: St_PosDir, SQL Type: sqlTypeOther, length: 9, nullable: true, editable: true, Coded Values: [NORTH: NORTH], [SOUTH: SOUTH], [EAST: EAST], ... 5 more ...)
- St_PosMod (type: esriFieldTypeString, alias: St_PosMod, SQL Type: sqlTypeOther, length: 25, nullable: true, editable: true)
- Country_L (type: esriFieldTypeString, alias: Country_L, SQL Type: sqlTypeOther, length: 2, nullable: true, editable: true)
- Country_R (type: esriFieldTypeString, alias: Country_R, SQL Type: sqlTypeOther, length: 2, nullable: true, editable: true)
- State_L (type: esriFieldTypeString, alias: State_L, SQL Type: sqlTypeOther, length: 2, nullable: true, editable: true, Coded Values: [ND: ND], [MT: MT], [WY: WY], ... 2 more ...)
- State_R (type: esriFieldTypeString, alias: State_R, SQL Type: sqlTypeOther, length: 2, nullable: true, editable: true, Coded Values: [ND: ND], [MT: MT], [WY: WY], ... 2 more ...)
- County_L (type: esriFieldTypeString, alias: County_L, SQL Type: sqlTypeOther, length: 40, nullable: true, editable: true, Coded Values: [CUSTER: CUSTER], [GARFIELD: GARFIELD], [ROSEBUD: ROSEBUD], ... 8 more ...)
- County_R (type: esriFieldTypeString, alias: County_R, SQL Type: sqlTypeOther, length: 40, nullable: true, editable: true, Coded Values: [CUSTER: CUSTER], [GARFIELD: GARFIELD], [ROSEBUD: ROSEBUD], ... 8 more ...)
- AddCode_L (type: esriFieldTypeString, alias: AddCode_L, SQL Type: sqlTypeOther, length: 6, nullable: true, editable: true)
- AddCode_R (type: esriFieldTypeString, alias: AddCode_R, SQL Type: sqlTypeOther, length: 6, nullable: true, editable: true)
- IncMuni_L (type: esriFieldTypeString, alias: IncMuni_L, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
- IncMuni_R (type: esriFieldTypeString, alias: IncMuni_R, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
- UnincCom_L (type: esriFieldTypeString, alias: UnincCom_L, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
- UnincCom_R (type: esriFieldTypeString, alias: UnincCom_R, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
- NbrhdCom_L (type: esriFieldTypeString, alias: NbrhdCom_L, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
- NbrhdCom_R (type: esriFieldTypeString, alias: NbrhdCom_R, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
- PostCode_L (type: esriFieldTypeString, alias: PostCode_L, SQL Type: sqlTypeOther, length: 7, nullable: true, editable: true, Coded Values: [59301: 59301], [59058: 59058], [59077: 59077], ... 10 more ...)
- PostCode_R (type: esriFieldTypeString, alias: PostCode_R, SQL Type: sqlTypeOther, length: 7, nullable: true, editable: true, Coded Values: [59301: 59301], [59058: 59058], [59077: 59077], ... 10 more ...)
- PostComm_L (type: esriFieldTypeString, alias: PostComm_L, SQL Type: sqlTypeOther, length: 40, nullable: true, editable: true, Coded Values: [JORDAN: JORDAN], [ANGELA: ANGELA], [COHAGEN: COHAGEN], ... 9 more ...)
- PostComm_R (type: esriFieldTypeString, alias: PostComm_R, SQL Type: sqlTypeOther, length: 40, nullable: true, editable: true, Coded Values: [JORDAN: JORDAN], [ANGELA: ANGELA], [COHAGEN: COHAGEN], ... 9 more ...)
- SpeedLimit (type: esriFieldTypeSmallInteger, alias: SpeedLimit, SQL Type: sqlTypeOther, nullable: true, editable: true)
- OneWay (type: esriFieldTypeString, alias: OneWay, SQL Type: sqlTypeOther, length: 2, nullable: true, editable: true, Coded Values: [B: B], [FT: FT], [TF: TF])
- Valid_L (type: esriFieldTypeString, alias: Valid_L, SQL Type: sqlTypeOther, length: 1, nullable: true, editable: true, Coded Values: [Y: Y], [N: N])
- Valid_R (type: esriFieldTypeString, alias: Valid_R, SQL Type: sqlTypeOther, length: 1, nullable: true, editable: true, Coded Values: [Y: Y], [N: N])
- RoadClass (type: esriFieldTypeString, alias: RoadClass, SQL Type: sqlTypeOther, length: 15, nullable: true, editable: true, Coded Values: [PRIMARY: PRIMARY], [SECONDARY: SECONDARY], [LOCAL: LOCAL], ... 11 more ...)
- Shape__Length (type: esriFieldTypeDouble, alias: Shape__Length, SQL Type: sqlTypeDouble, nullable: true, editable: false)
- GlobalID (type: esriFieldTypeGlobalID, alias: GlobalID, SQL Type: sqlTypeOther, length: 38, nullable: false, editable: false)
Types:
ID: HIGHWAY
Name: HIGHWAY
Domains:
- Field Name: PRE_DIR
Inherited
- Field Name: State
Inherited
- Field Name: Str_type
Inherited
- Field Name: Parity_L
Inherited
- Field Name: Parity_R
Inherited
- Field Name: St_PreDir
Inherited
- Field Name: St_PreTyp
Inherited
- Field Name: St_PreSep
Inherited
- Field Name: St_PosTyp
Inherited
- Field Name: St_PosDir
Inherited
- Field Name: State_L
Inherited
- Field Name: State_R
Inherited
- Field Name: County_L
Inherited
- Field Name: County_R
Inherited
- Field Name: PostCode_L
Inherited
- Field Name: PostCode_R
Inherited
- Field Name: PostComm_L
Inherited
- Field Name: PostComm_R
Inherited
- Field Name: OneWay
Inherited
- Field Name: Valid_L
Inherited
- Field Name: Valid_R
Inherited
- Field Name: RoadClass
Inherited
Templates:
Name: HIGHWAY
Description:
Drawing Tool: esriFeatureEditToolLine
Prototype:
Attributes:
- Country_L: US
- Country_R: US
- State_L: MT
- St_PreTyp: HIGHWAY
- State_R: MT
ID: OLD HIGHWAY
Name: OLD HIGHWAY
Domains:
- Field Name: PRE_DIR
Inherited
- Field Name: State
Inherited
- Field Name: Str_type
Inherited
- Field Name: Parity_L
Inherited
- Field Name: Parity_R
Inherited
- Field Name: St_PreDir
Inherited
- Field Name: St_PreTyp
Inherited
- Field Name: St_PreSep
Inherited
- Field Name: St_PosTyp
Inherited
- Field Name: St_PosDir
Inherited
- Field Name: State_L
Inherited
- Field Name: State_R
Inherited
- Field Name: County_L
Inherited
- Field Name: County_R
Inherited
- Field Name: PostCode_L
Inherited
- Field Name: PostCode_R
Inherited
- Field Name: PostComm_L
Inherited
- Field Name: PostComm_R
Inherited
- Field Name: OneWay
Inherited
- Field Name: Valid_L
Inherited
- Field Name: Valid_R
Inherited
- Field Name: RoadClass
Inherited
Templates:
Name: HIGHWAY
Description:
Drawing Tool: esriFeatureEditToolLine
Prototype:
Attributes:
- Country_L: US
- Country_R: US
- State_L: MT
- St_PreTyp: OLD HIGHWAY
- State_R: MT
ID: INTERSTATE
Name: INTERSTATE
Domains:
- Field Name: PRE_DIR
Inherited
- Field Name: State
Inherited
- Field Name: Str_type
Inherited
- Field Name: Parity_L
Inherited
- Field Name: Parity_R
Inherited
- Field Name: St_PreDir
Inherited
- Field Name: St_PreTyp
Inherited
- Field Name: St_PreSep
Inherited
- Field Name: St_PosTyp
Inherited
- Field Name: St_PosDir
Inherited
- Field Name: State_L
Inherited
- Field Name: State_R
Inherited
- Field Name: County_L
Inherited
- Field Name: County_R
Inherited
- Field Name: PostCode_L
Inherited
- Field Name: PostCode_R
Inherited
- Field Name: PostComm_L
Inherited
- Field Name: PostComm_R
Inherited
- Field Name: OneWay
Inherited
- Field Name: Valid_L
Inherited
- Field Name: Valid_R
Inherited
- Field Name: RoadClass
Inherited
Templates:
Name: INTERSTATE
Description:
Drawing Tool: esriFeatureEditToolLine
Prototype:
Attributes:
- Country_L: US
- Country_R: US
- State_L: MT
- St_PreTyp: INTERSTATE
- State_R: MT
ID: ROAD
Name: ROAD
Domains:
- Field Name: PRE_DIR
Inherited
- Field Name: State
Inherited
- Field Name: Str_type
Inherited
- Field Name: Parity_L
Inherited
- Field Name: Parity_R
Inherited
- Field Name: St_PreDir
Inherited
- Field Name: St_PreTyp
Inherited
- Field Name: St_PreSep
Inherited
- Field Name: St_PosTyp
Inherited
- Field Name: St_PosDir
Inherited
- Field Name: State_L
Inherited
- Field Name: State_R
Inherited
- Field Name: County_L
Inherited
- Field Name: County_R
Inherited
- Field Name: PostCode_L
Inherited
- Field Name: PostCode_R
Inherited
- Field Name: PostComm_L
Inherited
- Field Name: PostComm_R
Inherited
- Field Name: OneWay
Inherited
- Field Name: Valid_L
Inherited
- Field Name: Valid_R
Inherited
- Field Name: RoadClass
Inherited
Templates:
Name: ROAD
Description:
Drawing Tool: esriFeatureEditToolLine
Prototype:
Attributes:
- Country_L: US
- Country_R: US
- State_L: MT
- St_PreTyp: ROAD
- State_R: MT
ID: UNITED STATES HIGHWAY
Name: UNITED STATES HIGHWAY
Domains:
- Field Name: PRE_DIR
Inherited
- Field Name: State
Inherited
- Field Name: Str_type
Inherited
- Field Name: Parity_L
Inherited
- Field Name: Parity_R
Inherited
- Field Name: St_PreDir
Inherited
- Field Name: St_PreTyp
Inherited
- Field Name: St_PreSep
Inherited
- Field Name: St_PosTyp
Inherited
- Field Name: St_PosDir
Inherited
- Field Name: State_L
Inherited
- Field Name: State_R
Inherited
- Field Name: County_L
Inherited
- Field Name: County_R
Inherited
- Field Name: PostCode_L
Inherited
- Field Name: PostCode_R
Inherited
- Field Name: PostComm_L
Inherited
- Field Name: PostComm_R
Inherited
- Field Name: OneWay
Inherited
- Field Name: Valid_L
Inherited
- Field Name: Valid_R
Inherited
- Field Name: RoadClass
Inherited
Templates:
Name: UNITED STATES HIGHWAY
Description:
Drawing Tool: esriFeatureEditToolLine
Prototype:
Attributes:
- Country_L: US
- Country_R: US
- State_L: MT
- St_PreTyp: UNITED STATES HIGHWAY
- State_R: MT
Is Data Versioned: false
Has Contingent Values: false
Supports Rollback On Failure Parameter: true
Last Edit Date: 11/26/2024 7:09:49 PM
Schema Last Edit Date: 11/26/2024 7:09:49 PM
Data Last Edit Date: 11/26/2024 7:09:49 PM
Supported Operations:
Query
Query Pivot
Query Top Features
Query Analytic
Query Bins
Generate Renderer
Validate SQL
Get Estimates
ConvertFormat