'[postgis-users] Proposal for a new function ST_GeogFromLatLon'

[prev in list] [next in list] [prev in thread] [next in thread] 

List:       postgis-users
Subject:    [postgis-users] Proposal for a new function ST_GeogFromLatLon
From:       Javier de la Torre <jatorre () vizzuality ! com>
Date:       2012-05-31 20:59:41
Message-ID: D989F725-9010-40F8-A489-AD5276D53CB5 () vizzuality ! com
[Download RAW message or body]

[Attachment #2 (multipart/alternative)]

Hi all,

We are having lot of new web developers coming to use PostGIS and thats =
great! One of the first barries I know some people have is how =
complicate is to create a point on PostGIS. Basically you need to know:

1) In PostGIS first comes Longitude, then Latitude
2) You have to specify an srid, which most people havent heard of

So what I would consider a trivial query looks like this:

SELECT * FROM mytable WHERE the_geom && =
ST_SetSRID(ST_MakePoint(-123.0,34),4326)

I propose to have a wrapper function called ST_GeogFromLatLon or =
something similar so that we can do:

SELECT * FROM mytable WHERE the_geom && ST_GeogFromLatLon(34,-123.0)

The ST_GeogFromLatLon will imply 4326 SRID. And the return could be =
geography, as it cast well to geometry, so it will work in most cases.

I know is not such a big difference, but I think it will help a lot new =
people and will also make our queries look much better in some =
scenarios. In my experiences when teaching postgis this is kind of =
annoying having to go through it.

Does this break the entire GIS world? :D
Just kidding.

Javier de la Torre
@jatorre

Vizzuality
148 Lafayette St. PH, New York, 10013,USA
+1 347 320 7715
www.vizzuality.com

[Attachment #5 (unknown)]

<html><head></head><body style="word-wrap: break-word; -webkit-nbsp-mode: space; \
-webkit-line-break: after-white-space; ">Hi all,<br><br>We are having lot of new web \
developers coming to use PostGIS and thats great! One of the first barries I know \
some people have is how complicate is to create a point on PostGIS. Basically you \
need to know:<br><br>1) In PostGIS first comes Longitude, then Latitude<br>2) You \
have to specify an srid, which most people havent heard of<br><br>So what I would \
consider a trivial query looks like this:<br><br>SELECT * FROM mytable WHERE the_geom \
&amp;&amp; ST_SetSRID(ST_MakePoint(-123.0,34),4326)<br><br>I propose to have a \
wrapper function called ST_GeogFromLatLon or something similar so that we can \
do:<br><br>SELECT * FROM mytable WHERE the_geom &amp;&amp; \
ST_GeogFromLatLon(34,-123.0)<br><br>The ST_GeogFromLatLon will imply 4326 SRID. And \
the return could be geography, as it cast well to geometry, so it will work in most \
cases.<br><br>I know is not such a big difference, but I think it will help a lot new \
people and will also make our queries look much better in some scenarios. In my \
experiences when teaching postgis this is kind of annoying having to go through \
it.<br><br>Does this break the entire GIS world? :D<br>Just kidding.<br><br><div> \
<span class="Apple-style-span" style="border-collapse: separate; color: rgb(0, 0, 0); \
font-family: Helvetica; font-style: normal; font-variant: normal; font-weight: \
normal; letter-spacing: normal; line-height: normal; orphans: 2; text-align: \
-webkit-auto; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; \
word-spacing: 0px; -webkit-border-horizontal-spacing: 0px; \
-webkit-border-vertical-spacing: 0px; -webkit-text-decorations-in-effect: none; \
-webkit-text-size-adjust: auto; -webkit-text-stroke-width: 0px; font-size: medium; \
"><span class="Apple-style-span" style="border-collapse: separate; color: rgb(0, 0, \
0); font-family: Helvetica; font-style: normal; font-variant: normal; font-weight: \
normal; letter-spacing: normal; line-height: normal; orphans: 2; text-align: \
-webkit-auto; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; \
word-spacing: 0px; -webkit-border-horizontal-spacing: 0px; \
-webkit-border-vertical-spacing: 0px; -webkit-text-decorations-in-effect: none; \
-webkit-text-size-adjust: auto; -webkit-text-stroke-width: 0px; font-size: medium; \
"><div style="word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: \
after-white-space; "><span class="Apple-style-span" style="border-collapse: separate; \
color: rgb(0, 0, 0); font-family: Helvetica; font-style: normal; font-variant: \
normal; font-weight: normal; letter-spacing: normal; line-height: normal; orphans: 2; \
text-align: -webkit-auto; text-indent: 0px; text-transform: none; white-space: \
normal; widows: 2; word-spacing: 0px; -webkit-border-horizontal-spacing: 0px; \
-webkit-border-vertical-spacing: 0px; -webkit-text-decorations-in-effect: none; \
-webkit-text-size-adjust: auto; -webkit-text-stroke-width: 0px; font-size: medium; \
"><div style="word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: \
after-white-space; "><span class="Apple-style-span" style="border-collapse: separate; \
color: rgb(0, 0, 0); font-family: Helvetica; font-style: normal; font-variant: \
normal; font-weight: normal; letter-spacing: normal; line-height: normal; orphans: 2; \
text-align: -webkit-auto; text-indent: 0px; text-transform: none; white-space: \
normal; widows: 2; word-spacing: 0px; -webkit-border-horizontal-spacing: 0px; \
-webkit-border-vertical-spacing: 0px; -webkit-text-decorations-in-effect: none; \
-webkit-text-size-adjust: auto; -webkit-text-stroke-width: 0px; font-size: medium; \
"><div style="word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: \
after-white-space; "><span class="Apple-style-span" style="border-collapse: separate; \
font-family: Helvetica; font-style: normal; font-variant: normal; font-weight: \
normal; letter-spacing: normal; line-height: normal; orphans: 2; text-align: \
-webkit-auto; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; \
word-spacing: 0px; -webkit-border-horizontal-spacing: 0px; \
-webkit-border-vertical-spacing: 0px; -webkit-text-decorations-in-effect: none; \
-webkit-text-size-adjust: auto; -webkit-text-stroke-width: 0px; font-size: medium; \
"><div style="word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: \
after-white-space; "><span class="Apple-style-span" style="border-collapse: separate; \
font-variant: normal; letter-spacing: normal; line-height: normal; orphans: 2; \
text-align: -webkit-auto; text-indent: 0px; text-transform: none; white-space: \
normal; widows: 2; word-spacing: 0px; -webkit-border-horizontal-spacing: 0px; \
-webkit-border-vertical-spacing: 0px; -webkit-text-decorations-in-effect: none; \
-webkit-text-size-adjust: auto; -webkit-text-stroke-width: 0px; "><div \
style="word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: \
after-white-space; "><div><div><div><span class="Apple-style-span" \
style="border-collapse: separate; font-variant: normal; letter-spacing: normal; \
line-height: normal; orphans: 2; text-align: -webkit-auto; text-indent: 0px; \
text-transform: none; white-space: normal; widows: 2; word-spacing: 0px; \
-webkit-border-horizontal-spacing: 0px; -webkit-border-vertical-spacing: 0px; \
-webkit-text-decorations-in-effect: none; -webkit-text-size-adjust: auto; \
-webkit-text-stroke-width: 0px; "><div style="color: rgb(0, 0, 0); font-family: \
Helvetica; font-size: medium; font-weight: normal; font-style: normal; "><div \
style="color: rgb(0, 0, 0); "><div style="word-wrap: break-word; -webkit-nbsp-mode: \
space; -webkit-line-break: after-white-space; "><span class="Apple-style-span" \
style="border-collapse: separate; font-family: Helvetica; font-style: normal; \
font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: \
normal; orphans: 2; text-align: -webkit-auto; text-indent: 0px; text-transform: none; \
white-space: normal; widows: 2; word-spacing: 0px; -webkit-border-horizontal-spacing: \
0px; -webkit-border-vertical-spacing: 0px; -webkit-text-decorations-in-effect: none; \
-webkit-text-size-adjust: auto; -webkit-text-stroke-width: 0px; font-size: medium; \
"><div style="word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: \
after-white-space; "><div><div><div><span class="Apple-style-span" \
style="border-collapse: separate; font-family: Helvetica; font-style: normal; \
font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: \
normal; orphans: 2; text-align: -webkit-auto; text-indent: 0px; text-transform: none; \
white-space: normal; widows: 2; word-spacing: 0px; -webkit-border-horizontal-spacing: \
0px; -webkit-border-vertical-spacing: 0px; -webkit-text-decorations-in-effect: none; \
-webkit-text-size-adjust: auto; -webkit-text-stroke-width: 0px; font-size: medium; \
"><div style="color: rgb(0, 0, 0); "><div style="color: rgb(0, 0, 0); "><div \
style="word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: \
after-white-space; "><span class="Apple-style-span" style="border-collapse: separate; \
color: rgb(0, 0, 0); font-family: Helvetica; font-style: normal; font-variant: \
normal; font-weight: normal; letter-spacing: normal; line-height: normal; orphans: 2; \
text-align: -webkit-auto; text-indent: 0px; text-transform: none; white-space: \
normal; widows: 2; word-spacing: 0px; -webkit-border-horizontal-spacing: 0px; \
-webkit-border-vertical-spacing: 0px; -webkit-text-decorations-in-effect: none; \
-webkit-text-size-adjust: auto; -webkit-text-stroke-width: 0px; font-size: medium; \
"><div style="word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: \
after-white-space; "><span class="Apple-style-span" style="border-collapse: separate; \
font-family: Helvetica; font-style: normal; font-variant: normal; font-weight: \
normal; letter-spacing: normal; line-height: normal; orphans: 2; text-align: \
-webkit-auto; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; \
word-spacing: 0px; -webkit-border-horizontal-spacing: 0px; \
-webkit-border-vertical-spacing: 0px; -webkit-text-decorations-in-effect: none; \
-webkit-text-size-adjust: auto; -webkit-text-stroke-width: 0px; font-size: medium; \
"><div style="word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: \
after-white-space; "><div><div><div><span class="Apple-style-span" \
style="border-collapse: separate; font-family: Helvetica; font-style: normal; \
font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: \
normal; orphans: 2; text-align: -webkit-auto; text-indent: 0px; text-transform: none; \
white-space: normal; widows: 2; word-spacing: 0px; -webkit-border-horizontal-spacing: \
0px; -webkit-border-vertical-spacing: 0px; -webkit-text-decorations-in-effect: none; \
-webkit-text-size-adjust: auto; -webkit-text-stroke-width: 0px; font-size: medium; \
"><div style="color: rgb(0, 0, 0); "><div style="color: rgb(0, 0, 0); ">Javier de la \
Torre</div><div style="font-size: 11px; "><a href="http://twitter.com/jatorre/"><font \
class="Apple-style-span" color="#000000">@jatorre</font></a></div><div style="color: \
rgb(0, 0, 0); "><br></div><div style="color: rgb(0, 0, 0); \
"><b>Vizzuality</b></div><div style="color: rgb(0, 0, 0); font-size: 10px; ">148 \
Lafayette St. PH, New York, \
10013,USA</div></div></span></div></div></div></div></span></div></span><span \
class="Apple-style-span" style="font-size: 10px; ">+1 347 320 7715</span></div><div \
style="word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: \
after-white-space; "><span class="Apple-style-span" style="font-size: 10px; "><font \
class="Apple-style-span" color="#000000"><a \
href="http://www.vizzuality.com/">www.vizzuality.com</a></font></span></div></div></di \
v></span></div></div></div></div></span></div></div></div></span></div></div></div></div></span></div></span></div></span></div></span></div></span></span>
 </div>
<br></body></html>

_______________________________________________
postgis-users mailing list
postgis-users@postgis.refractions.net
http://postgis.refractions.net/mailman/listinfo/postgis-users

[prev in list] [next in list] [prev in thread] [next in thread] 