171 reputation
6
bio website mattmakesmaps.com
location Seattle, WA
age 28
visits member for 3 years, 10 months
seen Oct 2 at 22:50

i ♥ maps & bikes

Find me on twitter at @mattmakesmaps


Aug
20
comment How can I insert a bounding box or polygon in a PostGIS geometry field?
The output is as follows: geometry --------------------------------------------------------------------------------‌​----------------------------------------------- POLYGON Z ((42.79231 -76.116679 0,42.79231 -76.116081 0,42.794448 -76.116081 0,42.794448 -76.116679 0,42.79231 -76.116679 0)) (1 row)
Aug
20
comment How can I insert a bounding box or polygon in a PostGIS geometry field?
Based on your above example, the following SQL Statement outputs a Polygon Z geometry: SELECT ST_AsText(ST_Force_3D(ST_SetSRID(ST_Envelope(ST_Makeline(ST_MakePoint(42.794448, -76.116081, 415),ST_MakePoint(42.79231, -76.116679, 415))),4326))) AS geometry
Aug
20
comment How can I insert a bounding box or polygon in a PostGIS geometry field?
Is the column you're trying to load these data into a 3d column? If so you can use the ST_Force_3D function, as seen in this previous question
Aug
20
answered How can I insert a bounding box or polygon in a PostGIS geometry field?
Feb
9
awarded  Informed
Feb
6
answered How to import shp2pgsql on mac?
Feb
2
answered Problem installing PostGIS on Ubuntu Server 13.10
Nov
27
answered postGIS union multiple tables, big dataset, faster approach?
Sep
23
answered Given a BBOX and Zoom Range, Return All TMS Addresses
Sep
11
awarded  Tumbleweed
Sep
4
asked Given a BBOX and Zoom Range, Return All TMS Addresses
Aug
30
awarded  Supporter
Aug
28
answered Why WMS Image Repeat leaflet?
Feb
4
comment Advice on benchmarking my Tile Server (Apache2+mod_wsgi)
Thanks for the comprehensive set of links. This definitely gives me a starting point.
Feb
4
awarded  Student
Feb
4
answered Any low-cost Virtual Private Servers able to run GeoServer?
Feb
4
awarded  Autobiographer
Feb
4
asked Advice on benchmarking my Tile Server (Apache2+mod_wsgi)
Feb
4
answered How do I serve data in a sqlite database on a shared web host, like GoDaddy, onto a GIS web map?
Feb
3
awarded  Teacher