Name: Great Depression ICPSR by County (1940)
Display Field: name
Type: Feature Layer
Geometry Type: esriGeometryPolygon
Description: GreatDepression_ICPSR_1940byCounty
Copyright Text:
Min. Scale: 0
Max. Scale: 0
Default Visibility: false
Max Record Count: 2000
Supported query Formats: JSON, geoJSON, PBF
Use Standardized Queries: True
Extent:
XMin: -13888508.3672
YMin: 2817030.7362
XMax: -7452821.0283
YMax: 6340333.7854
Spatial Reference: 102100 (3857)
Drawing Info:
{"renderer":{"type":"simple","symbol":{"type":"esriSFS","style":"esriSFSSolid","color":[76,129,205,191],"outline":{"type":"esriSLS","style":"esriSLSSolid","color":[0,0,0,255],"width":0.75}}},"scaleSymbols":true,"transparency":0,"labelingInfo":null}
HasZ: false
HasM: false
Has Attachments: false
Has Geometry Properties: true
HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText
Object ID Field: OBJECTID_12
Unique ID Field:
IsSystemMaintained : True
Global ID Field:
Type ID Field:
Fields:
- OBJECTID_12 (type: esriFieldTypeOID, alias: FID, SQL Type: sqlTypeOther, length: 0, nullable: false, editable: false)
- OBJECTID (type: esriFieldTypeInteger, alias: OBJECTID, SQL Type: sqlTypeOther, nullable: true, editable: true)
- DECADE (type: esriFieldTypeString, alias: DECADE, SQL Type: sqlTypeOther, length: 4, nullable: true, editable: true)
- NHGISNAM (type: esriFieldTypeString, alias: NHGISNAM, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
- NHGISST (type: esriFieldTypeString, alias: NHGISST, SQL Type: sqlTypeOther, length: 3, nullable: true, editable: true)
- NHGISCTY (type: esriFieldTypeString, alias: NHGISCTY, SQL Type: sqlTypeOther, length: 4, nullable: true, editable: true)
- ICPSRST (type: esriFieldTypeString, alias: ICPSRST, SQL Type: sqlTypeOther, length: 3, nullable: true, editable: true)
- ICPSRCTY (type: esriFieldTypeString, alias: ICPSRCTY, SQL Type: sqlTypeOther, length: 4, nullable: true, editable: true)
- ICPSRNAM (type: esriFieldTypeString, alias: ICPSRNAM, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
- STATENAM (type: esriFieldTypeString, alias: STATENAM, SQL Type: sqlTypeOther, length: 25, nullable: true, editable: true)
- ICPSRSTI (type: esriFieldTypeDouble, alias: ICPSRSTI, SQL Type: sqlTypeOther, nullable: true, editable: true)
- ICPSRCTYI (type: esriFieldTypeDouble, alias: ICPSRCTYI, SQL Type: sqlTypeOther, nullable: true, editable: true)
- ICPSRFIP (type: esriFieldTypeDouble, alias: ICPSRFIP, SQL Type: sqlTypeOther, nullable: true, editable: true)
- STATE (type: esriFieldTypeString, alias: STATE, SQL Type: sqlTypeOther, length: 3, nullable: true, editable: true)
- COUNTY (type: esriFieldTypeString, alias: COUNTY, SQL Type: sqlTypeOther, length: 4, nullable: true, editable: true)
- PID (type: esriFieldTypeDouble, alias: PID, SQL Type: sqlTypeOther, nullable: true, editable: true)
- X_CENTROID (type: esriFieldTypeDouble, alias: X_CENTROID, SQL Type: sqlTypeOther, nullable: true, editable: true)
- Y_CENTROID (type: esriFieldTypeDouble, alias: Y_CENTROID, SQL Type: sqlTypeOther, nullable: true, editable: true)
- GISJOIN (type: esriFieldTypeString, alias: GISJOIN, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
- GISJOIN2 (type: esriFieldTypeString, alias: GISJOIN2, SQL Type: sqlTypeOther, length: 7, nullable: true, editable: true)
- Shape_Leng (type: esriFieldTypeDouble, alias: Shape_Leng, SQL Type: sqlTypeOther, nullable: true, editable: true)
- JoinID (type: esriFieldTypeString, alias: JoinID, SQL Type: sqlTypeOther, length: 254, nullable: true, editable: true)
- OBJECTID_1 (type: esriFieldTypeInteger, alias: OBJECTID_1, SQL Type: sqlTypeOther, nullable: true, editable: true)
- state_1 (type: esriFieldTypeDouble, alias: state_1, SQL Type: sqlTypeOther, nullable: true, editable: true)
- county_1 (type: esriFieldTypeDouble, alias: county_1, SQL Type: sqlTypeOther, nullable: true, editable: true)
- fips (type: esriFieldTypeDouble, alias: fips, SQL Type: sqlTypeOther, nullable: true, editable: true)
- name (type: esriFieldTypeString, alias: name, SQL Type: sqlTypeOther, length: 254, nullable: true, editable: true)
- totpop (type: esriFieldTypeDouble, alias: totpop, SQL Type: sqlTypeOther, nullable: true, editable: true)
- urb940 (type: esriFieldTypeDouble, alias: urb940, SQL Type: sqlTypeOther, nullable: true, editable: true)
- mtot (type: esriFieldTypeDouble, alias: mtot, SQL Type: sqlTypeOther, nullable: true, editable: true)
- ftot (type: esriFieldTypeDouble, alias: ftot, SQL Type: sqlTypeOther, nullable: true, editable: true)
- fbmtot (type: esriFieldTypeDouble, alias: fbmtot, SQL Type: sqlTypeOther, nullable: true, editable: true)
- fbftot (type: esriFieldTypeDouble, alias: fbftot, SQL Type: sqlTypeOther, nullable: true, editable: true)
- nwtot (type: esriFieldTypeDouble, alias: nwtot, SQL Type: sqlTypeOther, nullable: true, editable: true)
- fbwtot (type: esriFieldTypeDouble, alias: fbwtot, SQL Type: sqlTypeOther, nullable: true, editable: true)
- negtot (type: esriFieldTypeDouble, alias: negtot, SQL Type: sqlTypeOther, nullable: true, editable: true)
- m21 (type: esriFieldTypeDouble, alias: m21, SQL Type: sqlTypeOther, nullable: true, editable: true)
- f21 (type: esriFieldTypeDouble, alias: f21, SQL Type: sqlTypeOther, nullable: true, editable: true)
- t713tot (type: esriFieldTypeDouble, alias: t713tot, SQL Type: sqlTypeOther, nullable: true, editable: true)
- tsch713 (type: esriFieldTypeDouble, alias: tsch713, SQL Type: sqlTypeOther, nullable: true, editable: true)
- t1415tot (type: esriFieldTypeDouble, alias: t1415tot, SQL Type: sqlTypeOther, nullable: true, editable: true)
- tsch1415 (type: esriFieldTypeDouble, alias: tsch1415, SQL Type: sqlTypeOther, nullable: true, editable: true)
- t1617tot (type: esriFieldTypeDouble, alias: t1617tot, SQL Type: sqlTypeOther, nullable: true, editable: true)
- tsch1617 (type: esriFieldTypeDouble, alias: tsch1617, SQL Type: sqlTypeOther, nullable: true, editable: true)
- t1820tot (type: esriFieldTypeDouble, alias: t1820tot, SQL Type: sqlTypeOther, nullable: true, editable: true)
- tsch1820 (type: esriFieldTypeDouble, alias: tsch1820, SQL Type: sqlTypeOther, nullable: true, editable: true)
- urbfarm (type: esriFieldTypeDouble, alias: urbfarm, SQL Type: sqlTypeOther, nullable: true, editable: true)
- rurfarm (type: esriFieldTypeDouble, alias: rurfarm, SQL Type: sqlTypeOther, nullable: true, editable: true)
- mfgestab (type: esriFieldTypeDouble, alias: mfgestab, SQL Type: sqlTypeOther, nullable: true, editable: true)
- mfgavear (type: esriFieldTypeDouble, alias: mfgavear, SQL Type: sqlTypeOther, nullable: true, editable: true)
- mfgwages (type: esriFieldTypeDouble, alias: mfgwages, SQL Type: sqlTypeOther, nullable: true, editable: true)
- mfgout (type: esriFieldTypeDouble, alias: mfgout, SQL Type: sqlTypeOther, nullable: true, editable: true)
- totposswk (type: esriFieldTypeDouble, alias: totposswk, SQL Type: sqlTypeOther, nullable: true, editable: true)
- pctunemp (type: esriFieldTypeDouble, alias: pctunemp, SQL Type: sqlTypeOther, nullable: true, editable: true)
- gainwork (type: esriFieldTypeDouble, alias: gainwork, SQL Type: sqlTypeOther, nullable: true, editable: true)
- m14lf (type: esriFieldTypeDouble, alias: m14lf, SQL Type: sqlTypeOther, nullable: true, editable: true)
- f14lf (type: esriFieldTypeDouble, alias: f14lf, SQL Type: sqlTypeOther, nullable: true, editable: true)
- totemerg (type: esriFieldTypeDouble, alias: totemerg, SQL Type: sqlTypeOther, nullable: true, editable: true)
- m14emerg (type: esriFieldTypeDouble, alias: m14emerg, SQL Type: sqlTypeOther, nullable: true, editable: true)
- f14emerg (type: esriFieldTypeDouble, alias: f14emerg, SQL Type: sqlTypeOther, nullable: true, editable: true)
- totseek (type: esriFieldTypeDouble, alias: totseek, SQL Type: sqlTypeOther, nullable: true, editable: true)
- m14seek (type: esriFieldTypeDouble, alias: m14seek, SQL Type: sqlTypeOther, nullable: true, editable: true)
- f14seek (type: esriFieldTypeDouble, alias: f14seek, SQL Type: sqlTypeOther, nullable: true, editable: true)
- mprof (type: esriFieldTypeDouble, alias: mprof, SQL Type: sqlTypeOther, nullable: true, editable: true)
- fprof (type: esriFieldTypeDouble, alias: fprof, SQL Type: sqlTypeOther, nullable: true, editable: true)
- msprof (type: esriFieldTypeDouble, alias: msprof, SQL Type: sqlTypeOther, nullable: true, editable: true)
- fsprof (type: esriFieldTypeDouble, alias: fsprof, SQL Type: sqlTypeOther, nullable: true, editable: true)
- mfarm (type: esriFieldTypeDouble, alias: mfarm, SQL Type: sqlTypeOther, nullable: true, editable: true)
- ffarm (type: esriFieldTypeDouble, alias: ffarm, SQL Type: sqlTypeOther, nullable: true, editable: true)
- mmanag (type: esriFieldTypeDouble, alias: mmanag, SQL Type: sqlTypeOther, nullable: true, editable: true)
- fmanag (type: esriFieldTypeDouble, alias: fmanag, SQL Type: sqlTypeOther, nullable: true, editable: true)
- mclerk (type: esriFieldTypeDouble, alias: mclerk, SQL Type: sqlTypeOther, nullable: true, editable: true)
- fclerk (type: esriFieldTypeDouble, alias: fclerk, SQL Type: sqlTypeOther, nullable: true, editable: true)
- mcraft (type: esriFieldTypeDouble, alias: mcraft, SQL Type: sqlTypeOther, nullable: true, editable: true)
- fcraft (type: esriFieldTypeDouble, alias: fcraft, SQL Type: sqlTypeOther, nullable: true, editable: true)
- moperat (type: esriFieldTypeDouble, alias: moperat, SQL Type: sqlTypeOther, nullable: true, editable: true)
- foperat (type: esriFieldTypeDouble, alias: foperat, SQL Type: sqlTypeOther, nullable: true, editable: true)
- mdomest (type: esriFieldTypeDouble, alias: mdomest, SQL Type: sqlTypeOther, nullable: true, editable: true)
- fdomest (type: esriFieldTypeDouble, alias: fdomest, SQL Type: sqlTypeOther, nullable: true, editable: true)
- mservoth (type: esriFieldTypeDouble, alias: mservoth, SQL Type: sqlTypeOther, nullable: true, editable: true)
- fservoth (type: esriFieldTypeDouble, alias: fservoth, SQL Type: sqlTypeOther, nullable: true, editable: true)
- mflabwag (type: esriFieldTypeDouble, alias: mflabwag, SQL Type: sqlTypeOther, nullable: true, editable: true)
- fflabwag (type: esriFieldTypeDouble, alias: fflabwag, SQL Type: sqlTypeOther, nullable: true, editable: true)
- mflabufw (type: esriFieldTypeDouble, alias: mflabufw, SQL Type: sqlTypeOther, nullable: true, editable: true)
- fflabufw (type: esriFieldTypeDouble, alias: fflabufw, SQL Type: sqlTypeOther, nullable: true, editable: true)
- mlabor (type: esriFieldTypeDouble, alias: mlabor, SQL Type: sqlTypeOther, nullable: true, editable: true)
- flabor (type: esriFieldTypeDouble, alias: flabor, SQL Type: sqlTypeOther, nullable: true, editable: true)
- moccunk (type: esriFieldTypeDouble, alias: moccunk, SQL Type: sqlTypeOther, nullable: true, editable: true)
- foccunk (type: esriFieldTypeDouble, alias: foccunk, SQL Type: sqlTypeOther, nullable: true, editable: true)
- retail (type: esriFieldTypeDouble, alias: retail, SQL Type: sqlTypeOther, nullable: true, editable: true)
- retsales (type: esriFieldTypeDouble, alias: retsales, SQL Type: sqlTypeOther, nullable: true, editable: true)
- rettemp (type: esriFieldTypeDouble, alias: rettemp, SQL Type: sqlTypeOther, nullable: true, editable: true)
- retwages (type: esriFieldTypeDouble, alias: retwages, SQL Type: sqlTypeOther, nullable: true, editable: true)
- wholest (type: esriFieldTypeDouble, alias: wholest, SQL Type: sqlTypeOther, nullable: true, editable: true)
- wholnsal (type: esriFieldTypeDouble, alias: wholnsal, SQL Type: sqlTypeOther, nullable: true, editable: true)
- wholtemp (type: esriFieldTypeDouble, alias: wholtemp, SQL Type: sqlTypeOther, nullable: true, editable: true)
- wholwage (type: esriFieldTypeDouble, alias: wholwage, SQL Type: sqlTypeOther, nullable: true, editable: true)
- servest (type: esriFieldTypeDouble, alias: servest, SQL Type: sqlTypeOther, nullable: true, editable: true)
- servnsal (type: esriFieldTypeDouble, alias: servnsal, SQL Type: sqlTypeOther, nullable: true, editable: true)
- servtemp (type: esriFieldTypeDouble, alias: servtemp, SQL Type: sqlTypeOther, nullable: true, editable: true)
- servwage (type: esriFieldTypeDouble, alias: servwage, SQL Type: sqlTypeOther, nullable: true, editable: true)
- pctown (type: esriFieldTypeDouble, alias: pctown, SQL Type: sqlTypeOther, nullable: true, editable: true)
- pctownn (type: esriFieldTypeDouble, alias: pctownn, SQL Type: sqlTypeOther, nullable: true, editable: true)
- pctownw (type: esriFieldTypeDouble, alias: pctownw, SQL Type: sqlTypeOther, nullable: true, editable: true)
- dwell (type: esriFieldTypeDouble, alias: dwell, SQL Type: sqlTypeOther, nullable: true, editable: true)
- dwellocc (type: esriFieldTypeDouble, alias: dwellocc, SQL Type: sqlTypeOther, nullable: true, editable: true)
- dwellown (type: esriFieldTypeDouble, alias: dwellown, SQL Type: sqlTypeOther, nullable: true, editable: true)
- dwownwh (type: esriFieldTypeDouble, alias: dwownwh, SQL Type: sqlTypeOther, nullable: true, editable: true)
- dwownneg (type: esriFieldTypeDouble, alias: dwownneg, SQL Type: sqlTypeOther, nullable: true, editable: true)
- dwellren (type: esriFieldTypeDouble, alias: dwellren, SQL Type: sqlTypeOther, nullable: true, editable: true)
- dwrenwh (type: esriFieldTypeDouble, alias: dwrenwh, SQL Type: sqlTypeOther, nullable: true, editable: true)
- dwrenneg (type: esriFieldTypeDouble, alias: dwrenneg, SQL Type: sqlTypeOther, nullable: true, editable: true)
- totpop30 (type: esriFieldTypeDouble, alias: totpop30, SQL Type: sqlTypeOther, nullable: true, editable: true)
- dwelectr (type: esriFieldTypeDouble, alias: dwelectr, SQL Type: sqlTypeOther, nullable: true, editable: true)
- pctelec (type: esriFieldTypeDouble, alias: pctelec, SQL Type: sqlTypeOther, nullable: true, editable: true)
- dwradio (type: esriFieldTypeDouble, alias: dwradio, SQL Type: sqlTypeOther, nullable: true, editable: true)
- pctradio (type: esriFieldTypeDouble, alias: pctradio, SQL Type: sqlTypeOther, nullable: true, editable: true)
- dwrefrig (type: esriFieldTypeDouble, alias: dwrefrig, SQL Type: sqlTypeOther, nullable: true, editable: true)
- pctrefri (type: esriFieldTypeDouble, alias: pctrefri, SQL Type: sqlTypeOther, nullable: true, editable: true)
- negm21 (type: esriFieldTypeDouble, alias: negm21, SQL Type: sqlTypeOther, nullable: true, editable: true)
- negf21 (type: esriFieldTypeDouble, alias: negf21, SQL Type: sqlTypeOther, nullable: true, editable: true)
- cropval (type: esriFieldTypeDouble, alias: cropval, SQL Type: sqlTypeOther, nullable: true, editable: true)
- croval29 (type: esriFieldTypeDouble, alias: croval29, SQL Type: sqlTypeOther, nullable: true, editable: true)
- forest (type: esriFieldTypeDouble, alias: forest, SQL Type: sqlTypeOther, nullable: true, editable: true)
- farms (type: esriFieldTypeDouble, alias: farms, SQL Type: sqlTypeOther, nullable: true, editable: true)
- farmwh (type: esriFieldTypeDouble, alias: farmwh, SQL Type: sqlTypeOther, nullable: true, editable: true)
- farmnonw (type: esriFieldTypeDouble, alias: farmnonw, SQL Type: sqlTypeOther, nullable: true, editable: true)
- acfarms (type: esriFieldTypeDouble, alias: acfarms, SQL Type: sqlTypeOther, nullable: true, editable: true)
- fartentot (type: esriFieldTypeDouble, alias: fartentot, SQL Type: sqlTypeOther, nullable: true, editable: true)
- pctfarown1 (type: esriFieldTypeDouble, alias: pctfarown1, SQL Type: sqlTypeOther, nullable: true, editable: true)
- pctfarown2 (type: esriFieldTypeDouble, alias: pctfarown2, SQL Type: sqlTypeOther, nullable: true, editable: true)
- pctfarman (type: esriFieldTypeDouble, alias: pctfarman, SQL Type: sqlTypeOther, nullable: true, editable: true)
- pctfarten (type: esriFieldTypeDouble, alias: pctfarten, SQL Type: sqlTypeOther, nullable: true, editable: true)
- farmfown (type: esriFieldTypeDouble, alias: farmfown, SQL Type: sqlTypeOther, nullable: true, editable: true)
- farmpown (type: esriFieldTypeDouble, alias: farmpown, SQL Type: sqlTypeOther, nullable: true, editable: true)
- farmman (type: esriFieldTypeDouble, alias: farmman, SQL Type: sqlTypeOther, nullable: true, editable: true)
- farmten (type: esriFieldTypeDouble, alias: farmten, SQL Type: sqlTypeOther, nullable: true, editable: true)
- farm02 (type: esriFieldTypeDouble, alias: farm02, SQL Type: sqlTypeOther, nullable: true, editable: true)
- farm39 (type: esriFieldTypeDouble, alias: farm39, SQL Type: sqlTypeOther, nullable: true, editable: true)
- farm1029 (type: esriFieldTypeDouble, alias: farm1029, SQL Type: sqlTypeOther, nullable: true, editable: true)
- farm3049 (type: esriFieldTypeDouble, alias: farm3049, SQL Type: sqlTypeOther, nullable: true, editable: true)
- farm5069 (type: esriFieldTypeDouble, alias: farm5069, SQL Type: sqlTypeOther, nullable: true, editable: true)
- farm7099 (type: esriFieldTypeDouble, alias: farm7099, SQL Type: sqlTypeOther, nullable: true, editable: true)
- farm100 (type: esriFieldTypeDouble, alias: farm100, SQL Type: sqlTypeOther, nullable: true, editable: true)
- farm140 (type: esriFieldTypeDouble, alias: farm140, SQL Type: sqlTypeOther, nullable: true, editable: true)
- farm180 (type: esriFieldTypeDouble, alias: farm180, SQL Type: sqlTypeOther, nullable: true, editable: true)
- farm220 (type: esriFieldTypeDouble, alias: farm220, SQL Type: sqlTypeOther, nullable: true, editable: true)
- farm260 (type: esriFieldTypeDouble, alias: farm260, SQL Type: sqlTypeOther, nullable: true, editable: true)
- farm380 (type: esriFieldTypeDouble, alias: farm380, SQL Type: sqlTypeOther, nullable: true, editable: true)
- farm500 (type: esriFieldTypeDouble, alias: farm500, SQL Type: sqlTypeOther, nullable: true, editable: true)
- farm700 (type: esriFieldTypeDouble, alias: farm700, SQL Type: sqlTypeOther, nullable: true, editable: true)
- farm1000 (type: esriFieldTypeDouble, alias: farm1000, SQL Type: sqlTypeOther, nullable: true, editable: true)
- wmtot (type: esriFieldTypeDouble, alias: wmtot, SQL Type: sqlTypeOther, nullable: true, editable: true)
- wftot (type: esriFieldTypeDouble, alias: wftot, SQL Type: sqlTypeOther, nullable: true, editable: true)
- blmtot (type: esriFieldTypeDouble, alias: blmtot, SQL Type: sqlTypeOther, nullable: true, editable: true)
- blftot (type: esriFieldTypeDouble, alias: blftot, SQL Type: sqlTypeOther, nullable: true, editable: true)
- pctschool (type: esriFieldTypeDouble, alias: pctschool, SQL Type: sqlTypeOther, nullable: true, editable: true)
- tschage (type: esriFieldTypeDouble, alias: tschage, SQL Type: sqlTypeOther, nullable: true, editable: true)
- tschool (type: esriFieldTypeDouble, alias: tschool, SQL Type: sqlTypeOther, nullable: true, editable: true)
- farm1_49 (type: esriFieldTypeDouble, alias: farm1_49, SQL Type: sqlTypeOther, nullable: true, editable: true)
- farm50_99 (type: esriFieldTypeDouble, alias: farm50_99, SQL Type: sqlTypeOther, nullable: true, editable: true)
- far100_499 (type: esriFieldTypeDouble, alias: far100_499, SQL Type: sqlTypeOther, nullable: true, editable: true)
- far500_999 (type: esriFieldTypeDouble, alias: far500_999, SQL Type: sqlTypeOther, nullable: true, editable: true)
- farm1000_ (type: esriFieldTypeDouble, alias: farm1000_, SQL Type: sqlTypeOther, nullable: true, editable: true)
- avgfarmac (type: esriFieldTypeDouble, alias: avgfarmac, SQL Type: sqlTypeOther, nullable: true, editable: true)
- region1 (type: esriFieldTypeDouble, alias: region1, SQL Type: sqlTypeOther, nullable: true, editable: true)
- region2 (type: esriFieldTypeDouble, alias: region2, SQL Type: sqlTypeOther, nullable: true, editable: true)
- JoinID_1 (type: esriFieldTypeString, alias: JoinID_1, SQL Type: sqlTypeOther, length: 254, nullable: true, editable: true)
- Shape__Area (type: esriFieldTypeDouble, alias: Shape__Area, SQL Type: sqlTypeDouble, nullable: true, editable: false)
- Shape__Length (type: esriFieldTypeDouble, alias: Shape__Length, SQL Type: sqlTypeDouble, nullable: true, editable: false)
Templates:
Name: Great Depression ICPSR by County (1940)
Description:
Drawing Tool: esriFeatureEditToolPolygon
Prototype:
Is Data Versioned: false
Has Contingent Values: false
Supports Rollback On Failure Parameter: true
Last Edit Date: 8/10/2020 3:53:50 PM
Schema Last Edit Date: 8/10/2020 3:53:50 PM
Data Last Edit Date: 8/10/2020 3:53:50 PM
Supported Operations:
Query
Query Pivot
Query Top Features
Query Analytic
Query Bins
Generate Renderer
Validate SQL
Get Estimates
ConvertFormat