Layer: IVS_Near200Steelhead (ID:0)

View In: Map Viewer

Name: IVS_Near200Steelhead

Display Field: SciName

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description:

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":"SciName","uniqueValueInfos":[{"symbol":{"type":"esriPMS","url":"eac6e34155927a308663924a996ca1e6","imageData":"iVBORw0KGgoAAAANSUhEUgAAAAsAAAAUCAYAAABbLMdoAAAACXBIWXMAAA7EAAAOxAGVKw4bAAABBUlEQVQokc2Rv07CUBSHv4tdqi7t0hQ3Vw0LG+/gSsQH6EsoFbUvYR8AjCs8A9tdKqNl4k/u0i4tl0FbBwMxhAhs/LaTfCf5zu8YHBADIODttaScf0NY4cT1acqtcED3pta49haZRuf6UWeaQPXmIPpQDAQVt6Cstml1jNVWrXGFeWauRjdRqZeoxAOYjGcEcVeu4T8gALZjYTsWADpfMo0nGByQY4N1rpnGM3S+5OKyuj5uK/wZjYmGo1CA/BiOPMux6rZjk6iEVKXyCyE3NIrBPXd9IETBs3qvA/jcyp3Om28/tur2gguM2SLTnJ6bu2GfpnyJek8C4T781va/RptWZx+NH5zLYM73ydNcAAAAAElFTkSuQmCC","contentType":"image/png","width":8,"height":15,"angle":0,"xoffset":2.64,"yoffset":6},"value":"Egeria densa","label":"Egeria densa"},{"symbol":{"type":"esriPMS","url":"a4b0b6dc845c57a52dc27bba6877e880","imageData":"iVBORw0KGgoAAAANSUhEUgAAAAsAAAAUCAYAAABbLMdoAAAACXBIWXMAAA7EAAAOxAGVKw4bAAAA+0lEQVQokc2SrY7CQBSFv4ExyGFV+wA14FA8xNqGYnB9jWUfY3GYlmDpO1SNqxqBIkVNK6eqXbEL2Z+GgOO4m3w3OfecK3lAEmC346PrOAOb4RAvDNG9cJLwOp2uYucsztk35yxpas5CcGhbssEAr+vwo4i1vGxNJitGo5fL6NW1iavKxABlmZMkub7CP0AAlApQKgCgaSynU47kAT0b7JylLHOaxuL78+txvfDxmFEU2w2gi2IbKxXMxuOAqjLUtdFCoH/ZaFuy5ZIDsAHDfm9mAIvFV6M3Pf+t/dmiuwuWktI5+++ReuEwRKdp9i4E3ndst21EEet7bHwCFFxe0bjfqsMAAAAASUVORK5CYII=","contentType":"image/png","width":8,"height":15,"angle":0,"xoffset":2.64,"yoffset":6},"value":"Iris pseudacorus","label":"Iris pseudacorus"},{"symbol":{"type":"esriPMS","url":"8f001d16429dbaff88ee8a249bbeccf9","imageData":"iVBORw0KGgoAAAANSUhEUgAAAAsAAAAUCAYAAABbLMdoAAAACXBIWXMAAA7EAAAOxAGVKw4bAAABC0lEQVQokc2RvU7CYBSGn2I1aTUxdWna0VU3Nu7BlYgX0NGUKxCvwKabvQAwrnANbF0Ia5lMmy8xoKY/hE+pA4GoIQgb73aS5yTPOa/KDlEB3CceKUk+IagcYPl1wrVws82VdVlzZkWKLLI7WaS4HZGg0FXm9KhglSW216ClLrfsixqH2vFytPKJcPKxcADe4hHNdhSu4B8gALphohsmAHKa8fESobJD9g2WRcZ7HCGnGaf2+eq4tfDraEA87AcKhMmw72iGWdXPTPKxoJiIUCqEvzSUOb2HG7pAAILbZ1EF8K8XjW50/lv7vr1uK/hLJZ4VKUfayf+wXyd0O4N7FCxv8bbNGl6D1jYa32PGYCaJrlcIAAAAAElFTkSuQmCC","contentType":"image/png","width":8,"height":15,"angle":0,"xoffset":2.64,"yoffset":6},"value":"Phalaris arundinacea","label":"Phalaris arundinacea"},{"symbol":{"type":"esriPMS","url":"7bc0a131943b9d435a15109d211630ca","imageData":"iVBORw0KGgoAAAANSUhEUgAAAAsAAAAUCAYAAABbLMdoAAAACXBIWXMAAA7EAAAOxAGVKw4bAAAA8UlEQVQokc2SvW0CQRCFvzOXOCA4Z3MFkNgZBUADTpFxAdeGcRm+AsAihQKugSUi2oDI2skgmJOWCJwA8s8JQcbLRvpGevPepFyhFOATPvagQNkCGYBrhMfw/NTvF9GMaPYWzZioagKzHczvQPaQD2GUHrceez3u2+3jKBvVYh1CARC8Z+y9O8E/QAAyETIRALZ1zZf3pFyhW4OjGcF7tnVN3umcjmuEV4sFy6oqAbesqiIT6T7kOesQ2Ki6BNwvGzuYv8IMKFFlqtoFeDk0etbz39pvLbqL4BRCNPv3SI3wANzEufcE5BDbeRtDGF1i4xvavFjrwkqRzwAAAABJRU5ErkJggg==","contentType":"image/png","width":8,"height":15,"angle":0,"xoffset":2.64,"yoffset":6},"value":"Reynoutria japonica","label":"Reynoutria japonica"}],"fieldDelimiter":",","authoringInfo":{"colorRamp":{"type":"multipart","colorRamps":[{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[210,252,210,255],"toColor":[210,252,210,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[252,182,252,255],"toColor":[252,182,252,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[179,218,252,255],"toColor":[179,218,252,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[252,191,182,255],"toColor":[252,191,182,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[252,237,210,255],"toColor":[252,237,210,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[252,215,247,255],"toColor":[252,215,247,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[191,182,252,255],"toColor":[191,182,252,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[192,252,250,255],"toColor":[192,252,250,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[250,252,179,255],"toColor":[250,252,179,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[252,179,224,255],"toColor":[252,179,224,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[207,207,252,255],"toColor":[207,207,252,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[209,252,182,255],"toColor":[209,252,182,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[252,252,204,255],"toColor":[252,252,204,255]}]}}},"scaleSymbols":true,"transparency":0,"labelingInfo":null}
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:

Type ID Field: SciName

Fields:

OBJECTID_1 (type: esriFieldTypeOID, alias: OBJECTID_1, SQL Type: sqlTypeOther, length: 0, nullable: false, editable: false)
objectid (type: esriFieldTypeInteger, alias: objectid, SQL Type: sqlTypeOther, nullable: true, editable: true)
reporter (type: esriFieldTypeString, alias: reporter, SQL Type: sqlTypeOther, length: 452, nullable: true, editable: true)
RecOwner (type: esriFieldTypeString, alias: RecOwner, SQL Type: sqlTypeOther, length: 75, nullable: true, editable: true)
SciName (type: esriFieldTypeString, alias: SciName, SQL Type: sqlTypeOther, length: 302, nullable: true, editable: true)
ComName (type: esriFieldTypeString, alias: ComName, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
Nativity (type: esriFieldTypeString, alias: Nativity, SQL Type: sqlTypeOther, length: 21, nullable: true, editable: true)
OccStatus (type: esriFieldTypeString, alias: OccStatus, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true)
Status (type: esriFieldTypeString, alias: Status, SQL Type: sqlTypeOther, length: 30, nullable: true, editable: true)
ObsDate (type: esriFieldTypeString, alias: ObsDate, SQL Type: sqlTypeOther, length: 30, nullable: true, editable: true)
DateEnt (type: esriFieldTypeString, alias: DateEnt, SQL Type: sqlTypeOther, length: 30, nullable: true, editable: true)
DateUp (type: esriFieldTypeString, alias: DateUp, SQL Type: sqlTypeOther, length: 30, nullable: true, editable: true)
Location (type: esriFieldTypeString, alias: Location, SQL Type: sqlTypeOther, length: 206, nullable: true, editable: true)
Latitude (type: esriFieldTypeString, alias: Latitude, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true)
Longitude (type: esriFieldTypeString, alias: Longitude, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true)
Datum (type: esriFieldTypeString, alias: Datum, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true)
Method (type: esriFieldTypeString, alias: Method, SQL Type: sqlTypeOther, length: 2147483647, nullable: true, editable: true)
CoordAcc (type: esriFieldTypeInteger, alias: CoordAcc, SQL Type: sqlTypeOther, nullable: true, editable: true)
DataType (type: esriFieldTypeString, alias: DataType, SQL Type: sqlTypeOther, length: 30, nullable: true, editable: true)
Centroid (type: esriFieldTypeString, alias: Centroid, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
Abundance (type: esriFieldTypeString, alias: Abundance, SQL Type: sqlTypeOther, length: 101, nullable: true, editable: true)
InfestAcre (type: esriFieldTypeDouble, alias: InfestAcre, SQL Type: sqlTypeOther, nullable: true, editable: true)
GrossAcre (type: esriFieldTypeDouble, alias: GrossAcre, SQL Type: sqlTypeOther, nullable: true, editable: true)
Percentcov (type: esriFieldTypeString, alias: Percentcov, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
Density (type: esriFieldTypeString, alias: Density, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
Quantity (type: esriFieldTypeInteger, alias: Quantity, SQL Type: sqlTypeOther, nullable: true, editable: true)
QuantityU (type: esriFieldTypeString, alias: QuantityU, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
APPXQuant (type: esriFieldTypeString, alias: APPXQuant, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
NumCollect (type: esriFieldTypeString, alias: NumCollect, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
Smallest (type: esriFieldTypeString, alias: Smallest, SQL Type: sqlTypeOther, length: 81, nullable: true, editable: true)
Largest (type: esriFieldTypeString, alias: Largest, SQL Type: sqlTypeOther, length: 81, nullable: true, editable: true)
Incidence (type: esriFieldTypeString, alias: Incidence, SQL Type: sqlTypeOther, length: 81, nullable: true, editable: true)
Severity (type: esriFieldTypeString, alias: Severity, SQL Type: sqlTypeOther, length: 81, nullable: true, editable: true)
Host (type: esriFieldTypeString, alias: Host, SQL Type: sqlTypeOther, length: 302, nullable: true, editable: true)
Host_Name (type: esriFieldTypeString, alias: Host_Name, SQL Type: sqlTypeOther, length: 500, nullable: true, editable: true)
HostPheno (type: esriFieldTypeString, alias: HostPheno, SQL Type: sqlTypeOther, length: 75, nullable: true, editable: true)
HostDamage (type: esriFieldTypeString, alias: HostDamage, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
ManageStat (type: esriFieldTypeString, alias: ManageStat, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
PopStat (type: esriFieldTypeString, alias: PopStat, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
Habitat (type: esriFieldTypeString, alias: Habitat, SQL Type: sqlTypeOther, length: 70, nullable: true, editable: true)
LocalOwner (type: esriFieldTypeString, alias: LocalOwner, SQL Type: sqlTypeOther, length: 200, nullable: true, editable: true)
Site (type: esriFieldTypeString, alias: Site, SQL Type: sqlTypeOther, length: 356, nullable: true, editable: true)
RecBasis (type: esriFieldTypeString, alias: RecBasis, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
Museum (type: esriFieldTypeString, alias: Museum, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
MuseumRec (type: esriFieldTypeString, alias: MuseumRec, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
Voucher (type: esriFieldTypeString, alias: Voucher, SQL Type: sqlTypeOther, length: 1, nullable: true, editable: true)
ObsIDer (type: esriFieldTypeString, alias: ObsIDer, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
CollectTme (type: esriFieldTypeInteger, alias: CollectTme, SQL Type: sqlTypeOther, nullable: true, editable: true)
UUID (type: esriFieldTypeString, alias: UUID, SQL Type: sqlTypeOther, length: 36, nullable: true, editable: true)
OrgSrcID (type: esriFieldTypeString, alias: OrgSrcID, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
OrigName (type: esriFieldTypeString, alias: OrigName, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
RecSrcTyp (type: esriFieldTypeString, alias: RecSrcTyp, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
Surveyor (type: esriFieldTypeString, alias: Surveyor, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
DateAcc (type: esriFieldTypeInteger, alias: DateAcc, SQL Type: sqlTypeOther, nullable: true, editable: true)
VisitType (type: esriFieldTypeString, alias: VisitType, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
DataMthd (type: esriFieldTypeString, alias: DataMthd, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
TrapType (type: esriFieldTypeString, alias: TrapType, SQL Type: sqlTypeOther, length: 150, nullable: true, editable: true)
NumTraps (type: esriFieldTypeString, alias: NumTraps, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
TargetName (type: esriFieldTypeString, alias: TargetName, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
TargetCnt (type: esriFieldTypeDouble, alias: TargetCnt, SQL Type: sqlTypeOther, nullable: true, editable: true)
TargetRnge (type: esriFieldTypeString, alias: TargetRnge, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
Phenology (type: esriFieldTypeString, alias: Phenology, SQL Type: sqlTypeOther, length: 150, nullable: true, editable: true)
LifeStatus (type: esriFieldTypeString, alias: LifeStatus, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
Sex (type: esriFieldTypeString, alias: Sex, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
PID (type: esriFieldTypeString, alias: PID, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
WaterName (type: esriFieldTypeString, alias: WaterName, SQL Type: sqlTypeOther, length: 300, nullable: true, editable: true)
WaterType (type: esriFieldTypeString, alias: WaterType, SQL Type: sqlTypeOther, length: 2147483647, nullable: true, editable: true)
Substrate (type: esriFieldTypeString, alias: Substrate, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
TreatArea (type: esriFieldTypeDouble, alias: TreatArea, SQL Type: sqlTypeOther, nullable: true, editable: true)
PlantTreat (type: esriFieldTypeInteger, alias: PlantTreat, SQL Type: sqlTypeOther, nullable: true, editable: true)
TreatComm (type: esriFieldTypeString, alias: TreatComm, SQL Type: sqlTypeOther, length: 2147483647, nullable: true, editable: true)
Reference (type: esriFieldTypeString, alias: Reference, SQL Type: sqlTypeOther, length: 2147483647, nullable: true, editable: true)
Locality (type: esriFieldTypeString, alias: Locality, SQL Type: sqlTypeOther, length: 2147483647, nullable: true, editable: true)
Comments (type: esriFieldTypeString, alias: Comments, SQL Type: sqlTypeOther, length: 2147483647, nullable: true, editable: true)
ReviewDate (type: esriFieldTypeString, alias: ReviewDate, SQL Type: sqlTypeOther, length: 30, nullable: true, editable: true)
Reviewer (type: esriFieldTypeString, alias: Reviewer, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
VerifyMthd (type: esriFieldTypeString, alias: VerifyMthd, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
Verified (type: esriFieldTypeString, alias: Verified, SQL Type: sqlTypeOther, length: 12, nullable: true, editable: true)
IDCred (type: esriFieldTypeString, alias: IDCred, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
ReviewComm (type: esriFieldTypeString, alias: ReviewComm, SQL Type: sqlTypeOther, length: 2147483647, nullable: true, editable: true)
NEAR_FID_All100 (type: esriFieldTypeInteger, alias: NEAR_FID, SQL Type: sqlTypeOther, nullable: true, editable: true)
NEAR_DIST_All100 (type: esriFieldTypeDouble, alias: NEAR_DIST, SQL Type: sqlTypeOther, nullable: true, editable: true)
NEAR_FC_All100 (type: esriFieldTypeString, alias: NEAR_FC, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
NEAR_FID_All500 (type: esriFieldTypeInteger, alias: NEAR_FID_All500, SQL Type: sqlTypeOther, nullable: true, editable: true)
NEAR_DIST_All500 (type: esriFieldTypeDouble, alias: NEAR_DIST_All500, SQL Type: sqlTypeOther, nullable: true, editable: true)
NEAR_FC_All500 (type: esriFieldTypeString, alias: NEAR_FC_All500, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
NEAR_FID_All50 (type: esriFieldTypeInteger, alias: NEAR_FID_All50, SQL Type: sqlTypeOther, nullable: true, editable: true)
NEAR_DIST_All50 (type: esriFieldTypeDouble, alias: NEAR_DIST_All50, SQL Type: sqlTypeOther, nullable: true, editable: true)
NEAR_FC_All50 (type: esriFieldTypeString, alias: NEAR_FC_All50, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
NEAR_ANGLE (type: esriFieldTypeDouble, alias: NEAR_ANGLE, SQL Type: sqlTypeOther, nullable: true, editable: true)
NEAR_FID_All500A (type: esriFieldTypeInteger, alias: NEAR_FID_All500A, SQL Type: sqlTypeOther, nullable: true, editable: true)
NEAR_DIST_All500A (type: esriFieldTypeDouble, alias: NEAR_DIST_All500A, SQL Type: sqlTypeOther, nullable: true, editable: true)
NEAR_FC_All500A (type: esriFieldTypeString, alias: NEAR_FC_All500A, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
NEAR_FID_200 (type: esriFieldTypeInteger, alias: NEAR_FID_200, SQL Type: sqlTypeOther, nullable: true, editable: true)
NEAR_DIST_200 (type: esriFieldTypeDouble, alias: NEAR_DIST_200, SQL Type: sqlTypeOther, nullable: true, editable: true)
NEAR_FC_200 (type: esriFieldTypeString, alias: NEAR_FC_200, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
NEAR_FID_200Chum (type: esriFieldTypeInteger, alias: NEAR_FID_200Chum, SQL Type: sqlTypeOther, nullable: true, editable: true)
NEAR_DIST_200Chum (type: esriFieldTypeDouble, alias: NEAR_DIST_200Chum, SQL Type: sqlTypeOther, nullable: true, editable: true)
NEAR_FID_200Chnk (type: esriFieldTypeInteger, alias: NEAR_FID_200Chnk, SQL Type: sqlTypeOther, nullable: true, editable: true)
NEAR_DIST_200Chnk (type: esriFieldTypeDouble, alias: NEAR_DIST_200Chnk, SQL Type: sqlTypeOther, nullable: true, editable: true)
NEAR_FID_200Chm (type: esriFieldTypeInteger, alias: NEAR_FID_200Chm, SQL Type: sqlTypeOther, nullable: true, editable: true)
NEAR_DIST_200Chm (type: esriFieldTypeDouble, alias: NEAR_DIST_200Chm, SQL Type: sqlTypeOther, nullable: true, editable: true)
NEAR_FID_200Ch (type: esriFieldTypeInteger, alias: NEAR_FID_200Ch, SQL Type: sqlTypeOther, nullable: true, editable: true)
NEAR_DIST_200Ch (type: esriFieldTypeDouble, alias: NEAR_DIST_200Ch, SQL Type: sqlTypeOther, nullable: true, editable: true)
NEAR_FID_200Pnk (type: esriFieldTypeInteger, alias: NEAR_FID_200Pnk, SQL Type: sqlTypeOther, nullable: true, editable: true)
NEAR_DIST_200Pnk (type: esriFieldTypeDouble, alias: NEAR_DIST_200Pnk, SQL Type: sqlTypeOther, nullable: true, editable: true)
NEAR_FID_200Scky (type: esriFieldTypeInteger, alias: NEAR_FID_200Scky, SQL Type: sqlTypeOther, nullable: true, editable: true)
NEAR_DIST_200Scky (type: esriFieldTypeDouble, alias: NEAR_DIST_200Scky, SQL Type: sqlTypeOther, nullable: true, editable: true)
NEAR_FID_200Stlhd (type: esriFieldTypeInteger, alias: NEAR_FID_200Stlhd, SQL Type: sqlTypeOther, nullable: true, editable: true)
NEAR_DIST_200Stlhd (type: esriFieldTypeDouble, alias: NEAR_DIST_200Stlhd, SQL Type: sqlTypeOther, nullable: true, editable: true)

Types:

SciName: Egeria densa

SciName: Iris pseudacorus

SciName: Phalaris arundinacea

SciName: Reynoutria japonica

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 3/31/2021 10:32:55 PM

Schema Last Edit Date: 3/31/2021 10:32:55 PM

Data Last Edit Date: 3/31/2021 10:32:55 PM

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