altitudelatitude longitudepostgispostgresql
I'm trying to take advantage of the many functions available in Postgis for dealing with latitude and longitude coordinate systems.
However, I would like to add some altitude information to my database and I can't find the proper answer for which datatype should be used for properly holding Latitude, Longitude and Altitude in Postgis?
I have found that Geometry type is capable of X, Y and Z, but the Geography type only holds Latitude and Longitude.
Is there and differences between both?
Check out pgsphere, it's specifically designed for handling astronomical data.
Are you using the correct spatial reference ID? The vs14_housing data you referenced is 102685.
If you use your query using the UTM(26913), no results.
But if you change it to 102685, it works. Unless you projected your vs14_housing data (which you failed to mention in the question).
with cte as
(
select 1 as id, ST_Transform(ST_SetSRID(ST_MakePoint(-76.6129, 39.3106), 4326), 102685) point_location
,st_astext(ST_Transform(ST_SetSRID(ST_MakePoint(-76.6129, 39.3106), 4326), 102685)) wkt
)
SELECT a.id, b.csa2010
FROM public."vs14_housing" b, cte a
WHERE
ST_Intersects(a.point_location, b.geom)
or
ST_Contains(a.point_location, b.geom)
or
ST_Within(a.point_location, b.geom)
Best Answer
I don't see why geography can't hold Z. Did you try it?
As per the docs:
CREATE TABLE testgeog(gid serial PRIMARY KEY, the_geog geography(POINTZ,4326) );