Skip to content

Instantly share code, notes, and snippets.

@antoniolocandro

antoniolocandro/test_area

Last active December 30, 2015 09:09
Show Gist options
  • Save antoniolocandro/7807424 to your computer and use it in GitHub Desktop.
Save antoniolocandro/7807424 to your computer and use it in GitHub Desktop.
Download ZIP
Compare ESRI WGS84 degree area calculation with POSTGIS
Raw
test_area
-- Test to compare the area calculation in degrees when data is stores as WGS84 in ESRI vrs POSTGIS
select shape_area as ESRI_area, ST_Area (geom) as POSTGIS_area, (shape_area-(ST_Area (geom)))*100 as Percentage_Difference from fir_area_20131205
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment