PostGIS Snippets - Versionsgeschichte

Stefan: /* Geometry Constructors */

2016-12-06T00:18:41Z

Geometry Constructors

← Nächstältere Version		Version vom 6. Dezember 2016, 00:18 Uhr
Zeile 13:		Zeile 13:
	/4 / SELECT ST_AsEWKT('SRID=4326;POINT(-71.06 42.28)'::geometry) -- ok, but prefer 1/ST_GeomFromText		/4 / SELECT ST_AsEWKT('SRID=4326;POINT(-71.06 42.28)'::geometry) -- ok, but prefer 1/ST_GeomFromText
	/5 / SELECT ST_AsEWKT(ST_SetSRID('POINT(-71.06 42.28)'::geometry, 4326)) -- ok, but prefer 1/ST_GeomFromText		/5 / SELECT ST_AsEWKT(ST_SetSRID('POINT(-71.06 42.28)'::geometry, 4326)) -- ok, but prefer 1/ST_GeomFromText
	/6 / SELECT ST_AsEWKT(ST_MakePoint(-71.06, 42.28, 4326)) -- ok for 'symbolic' form. But why no EWKT returning?		/6 / SELECT ST_AsEWKT(ST_MakePoint(-71.06, 42.28, 4326)) -- ok for 'symbolic' form. But why no EWKT returning? ST_Point is OGC alias for ST_MakePoint.

	Geography:		Geography:

Stefan: /* Geometry Constructors */

2016-01-22T12:45:59Z

Geometry Constructors

← Nächstältere Version		Version vom 22. Januar 2016, 12:45 Uhr
Zeile 7:		Zeile 7:
	Geometry constructors for geometry and geography types: Howto construct and print e.g. a coordinate in EPSG:4326 and in lon/lat format in either textual or 'symbolic' form?		Geometry constructors for geometry and geography types: Howto construct and print e.g. a coordinate in EPSG:4326 and in lon/lat format in either textual or 'symbolic' form?

	~~Works...~~		Geometry:
	/1 / '''SELECT ST_AsEWKT(ST_GeomFromText('POINT(-71.06 42.28)', 4326)) -- ok, preferred if text input'''		/1 / '''SELECT ST_AsEWKT(ST_GeomFromText('POINT(-71.06 42.28)', 4326)) -- ok, preferred if text input'''
	/2 / '''SELECT ST_AsEWKT(ST_GeomFromText('SRID=4326;POINT(-71.06 42.28)')) -- ok (if srid 'inline')'''		/2 / '''SELECT ST_AsEWKT(ST_GeomFromText('SRID=4326;POINT(-71.06 42.28)')) -- ok (if srid 'inline')'''
Zeile 15:		Zeile 15:
	/6 / SELECT ST_AsEWKT(ST_MakePoint(-71.06, 42.28, 4326)) -- ok for 'symbolic' form. But why no EWKT returning?		/6 / SELECT ST_AsEWKT(ST_MakePoint(-71.06, 42.28, 4326)) -- ok for 'symbolic' form. But why no EWKT returning?

	~~...does not work with geography~~:		Geography:
	/1 / SELECT ST_AsEWKT(ST_GeogFromText('POINT(-71.06 42.28)', 4326)) -- ERROR: unknown ST_GeogFromText()		/1 / SELECT ST_AsEWKT(ST_GeogFromText('POINT(-71.06 42.28)', 4326)) -- ERROR: unknown ST_GeogFromText()
	/2a/ SELECT ST_AsEWKT(ST_GeogFromText('SRID=4326;POINT(-71.06 42.28)')) -- ERROR: no ST_AsEWKT.		/2a/ SELECT ST_AsEWKT(ST_GeogFromText('SRID=4326;POINT(-71.06 42.28)')) -- ERROR: no ST_AsEWKT.

Stefan: /* Point Constructors */

2016-01-22T12:45:24Z

Point Constructors

← Nächstältere Version		Version vom 22. Januar 2016, 12:45 Uhr
Zeile 3:		Zeile 3:
	* [[PostGIS]]		* [[PostGIS]]

	== ~~Point~~ Constructors ==		== Geometry Constructors ==

	~~Point~~ constructors for geometry and geography types: Howto construct and print a coordinate in EPSG:4326 and in lon/lat format in either textual or 'symbolic' form?		Geometry constructors for geometry and geography types: Howto construct and print e.g. a coordinate in EPSG:4326 and in lon/lat format in either textual or 'symbolic' form?

	Works...		Works...

Stefan: /* Point Constructors */

2016-01-22T12:44:27Z

Point Constructors

← Nächstältere Version		Version vom 22. Januar 2016, 12:44 Uhr
Zeile 8:		Zeile 8:

	Works...		Works...
	/1 / SELECT ST_AsEWKT(ST_GeomFromText('POINT(-71.06 42.28)', 4326)) -- ok, preferred if text input		/1 / '''SELECT ST_AsEWKT(ST_GeomFromText('POINT(-71.06 42.28)', 4326)) -- ok, preferred if text input'''
	/2 / SELECT ST_AsEWKT(ST_GeomFromText('SRID=4326;POINT(-71.06 42.28)')) -- ok (if srid 'inline')		/2 / '''SELECT ST_AsEWKT(ST_GeomFromText('SRID=4326;POINT(-71.06 42.28)')) -- ok (if srid 'inline')'''
	/3 / SELECT ST_AsEWKT(ST_GeomFromEWKT('SRID=4326;POINT(-71.06 42.28)')) -- ok, but why then ST_GeomFromText?		/3 / SELECT ST_AsEWKT(ST_GeomFromEWKT('SRID=4326;POINT(-71.06 42.28)')) -- ok, but why then ST_GeomFromText?
	/4 / SELECT ST_AsEWKT('SRID=4326;POINT(-71.06 42.28)'::geometry) -- ok, but prefer 1/ST_GeomFromText		/4 / SELECT ST_AsEWKT('SRID=4326;POINT(-71.06 42.28)'::geometry) -- ok, but prefer 1/ST_GeomFromText
Zeile 20:		Zeile 20:
	/2b/ '''SELECT ST_AsText(ST_GeogFromText('SRID=4326;POINT(-71.06 42.28)')) -- ok (if srid 'inline'); (there's no AsEWKT)'''		/2b/ '''SELECT ST_AsText(ST_GeogFromText('SRID=4326;POINT(-71.06 42.28)')) -- ok (if srid 'inline'); (there's no AsEWKT)'''
	/3 / SELECT ST_AsText(ST_GeogFromEWKT('SRID=4326;POINT(-71.06 42.28)')) -- ERROR: no ST_GeogFromEWKT.		/3 / SELECT ST_AsText(ST_GeogFromEWKT('SRID=4326;POINT(-71.06 42.28)')) -- ERROR: no ST_GeogFromEWKT.
	/4 / SELECT ST_AsText('SRID=4326;POINT(-71.06 42.28)'::geography) -- ok (no AsEWKT)~~, but prefer 1/ST_GeomFromText~~		/4 / '''SELECT ST_AsText('SRID=4326;POINT(-71.06 42.28)'::geography) -- ok (no AsEWKT)'''
	/5 / SELECT ST_AsText(ST_SetSRID('POINT(-71.06 42.28)'::geography, 4326)) -- ERROR: ok SetSRID w. geography unnecessary		/5 / SELECT ST_AsText(ST_SetSRID('POINT(-71.06 42.28)'::geography, 4326)) -- ERROR: ok SetSRID w. geography unnecessary
	/6 / Equivalent to ST_MakePoint for geography types missing: => ST_MakePointG?		/6 / Equivalent to ST_MakePoint for geography types missing: => ST_MakePointG?

Stefan: /* Point Constructors */

2016-01-22T12:43:00Z

Point Constructors

← Nächstältere Version		Version vom 22. Januar 2016, 12:43 Uhr
Zeile 15:		Zeile 15:
	/6 / SELECT ST_AsEWKT(ST_MakePoint(-71.06, 42.28, 4326)) -- ok for 'symbolic' form. But why no EWKT returning?		/6 / SELECT ST_AsEWKT(ST_MakePoint(-71.06, 42.28, 4326)) -- ok for 'symbolic' form. But why no EWKT returning?

	...does not work:		...does not work with geography:
	/1 / SELECT ST_AsEWKT(ST_GeogFromText('POINT(-71.06 42.28)', 4326)) -- ERROR: unknown ST_GeogFromText()~~: why?~~		/1 / SELECT ST_AsEWKT(ST_GeogFromText('POINT(-71.06 42.28)', 4326)) -- ERROR: unknown ST_GeogFromText()
	/2a/ SELECT ST_AsEWKT(ST_GeogFromText('SRID=4326;POINT(-71.06 42.28)')) -- ERROR: no ST_AsEWKT~~: why not?~~		/2a/ SELECT ST_AsEWKT(ST_GeogFromText('SRID=4326;POINT(-71.06 42.28)')) -- ERROR: no ST_AsEWKT.
	/2b/ SELECT ST_AsText(ST_GeogFromText('SRID=4326;POINT(-71.06 42.28)')) -- ok (if srid 'inline'); no AsEWKT		/2b/ '''SELECT ST_AsText(ST_GeogFromText('SRID=4326;POINT(-71.06 42.28)')) -- ok (if srid 'inline'); (there's no AsEWKT)'''
	/3 / SELECT ST_AsText(ST_GeogFromEWKT('SRID=4326;POINT(-71.06 42.28)')) -- ERROR: no ST_GeogFromEWKT~~: why?~~		/3 / SELECT ST_AsText(ST_GeogFromEWKT('SRID=4326;POINT(-71.06 42.28)')) -- ERROR: no ST_GeogFromEWKT.
	/4 / SELECT ST_AsText('SRID=4326;POINT(-71.06 42.28)'::geography) -- ok (no AsEWKT), but prefer 1/ST_GeomFromText		/4 / SELECT ST_AsText('SRID=4326;POINT(-71.06 42.28)'::geography) -- ok (no AsEWKT), but prefer 1/ST_GeomFromText
	/5 / SELECT ST_AsText(ST_SetSRID('POINT(-71.06 42.28)'::geography, 4326)) -- ERROR: ok SetSRID w. geography unnecessary		/5 / SELECT ST_AsText(ST_SetSRID('POINT(-71.06 42.28)'::geography, 4326)) -- ERROR: ok SetSRID w. geography unnecessary
Zeile 27:		Zeile 27:
	* Create ST_AsEWKT for geography and harmonize ST_AsText (depreciate with EWKT).		* Create ST_AsEWKT for geography and harmonize ST_AsText (depreciate with EWKT).
	* Create ST_GeogFromEWKT for geography and harmonize ST_GeogFromText (depreciate with EWKT).		* Create ST_GeogFromEWKT for geography and harmonize ST_GeogFromText (depreciate with EWKT).


	== Bounding Box (bbox, box, mbr, ...) Constructors ==		== Bounding Box (bbox, box, mbr, ...) Constructors ==

Stefan am 16. Februar 2011 um 13:36 Uhr

2011-02-16T13:36:59Z

@@ Zeile 27: / Zeile 27: @@
 * Create ST_AsEWKT for geography and harmonize ST_AsText (depreciate with EWKT).
 * Create ST_GeogFromEWKT for geography and harmonize ST_GeogFromText (depreciate with EWKT).
 == hstore ==
@@ Zeile 62: / Zeile 77: @@
      SELECT lower(tags->'cuisine') AS cuisine FROM planet_osm_polygon WHERE tags ? 'cuisine'
    ) AS t GROUP BY cuisine ORDER BY c DESC;

Stefan am 16. Februar 2011 um 13:36 Uhr

2011-02-16T13:36:31Z

@@ Zeile 15: / Zeile 15: @@
    /*6 */ SELECT ST_AsEWKT(ST_MakePoint(-71.06, 42.28, 4326)) -- ok for 'symbolic' form. But why no EWKT returning?
-Does not work...!
+...does not work:
    /*1 */ SELECT ST_AsEWKT(ST_GeogFromText('POINT(-71.06 42.28)', 4326)) -- ERROR: unknown ST_GeogFromText(): why?
    /*2a*/ SELECT ST_AsEWKT(ST_GeogFromText('SRID=4326;POINT(-71.06 42.28)')) -- ERROR: no ST_AsEWKT: why not?
@@ Zeile 62: / Zeile 62: @@
      SELECT lower(tags->'cuisine') AS cuisine FROM planet_osm_polygon WHERE tags ? 'cuisine'
    ) AS t GROUP BY cuisine ORDER BY c DESC;

Stefan: /* hstore */

2011-02-16T13:24:37Z

hstore

← Nächstältere Version		Version vom 16. Februar 2011, 13:24 Uhr
Zeile 34:		Zeile 34:
	=== Index ===		=== Index ===

			Create index for a field of type hstore:
	DROP INDEX planet_osm_point_tags;		DROP INDEX planet_osm_point_tags;
	CREATE INDEX planet_osm_point_tags		CREATE INDEX planet_osm_point_tags
Zeile 39:		Zeile 40:
	USING gin (tags)		USING gin (tags)

			Create a index with expression:
	DROP INDEX planet_osm_point_tags2;		DROP INDEX planet_osm_point_tags2;
	CREATE INDEX planet_osm_point_tags2		CREATE INDEX planet_osm_point_tags2
Zeile 54:		Zeile 56:
	"italian";197		"italian";197
	"pizza";123		"pizza";123
	~~"burger";112~~


	SELECT count(*) AS c, cuisine FROM (		SELECT count(*) AS c, cuisine FROM (
	SELECT lower(tags->'cuisine') AS cuisine FROM planet_osm_point WHERE tags ? 'cuisine'		SELECT lower(tags->'cuisine') AS cuisine FROM planet_osm_point WHERE tags ? 'cuisine'

Stefan: /* hstore */

2011-02-16T13:19:55Z

hstore

← Nächstältere Version		Version vom 16. Februar 2011, 13:19 Uhr
Zeile 30:		Zeile 30:
	== hstore ==		== hstore ==

	Key-Value data type.		Key-Value data type of PostgreSQL.

	=== Index ===		=== Index ===

Stefan: /* Point Constructors */

2011-02-16T13:19:24Z

Point Constructors

← Nächstältere Version		Version vom 16. Februar 2011, 13:19 Uhr
Zeile 5:		Zeile 5:
	== Point Constructors ==		== Point Constructors ==

	Point ~~Constructors~~ for geometry and geography types: Howto construct and print a coordinate in EPSG:4326 and in lon/lat format in either textual or 'symbolic' form?		Point constructors for geometry and geography types: Howto construct and print a coordinate in EPSG:4326 and in lon/lat format in either textual or 'symbolic' form?

	* /1 / SELECT ST_AsEWKT(ST_GeomFromText('POINT(-71.06 42.28)', 4326)) -- ok, preferred if text input		Works...
	* /2 / SELECT ST_AsEWKT(ST_GeomFromText('SRID=4326;POINT(-71.06 42.28)')) -- ok (if srid 'inline')		/1 / SELECT ST_AsEWKT(ST_GeomFromText('POINT(-71.06 42.28)', 4326)) -- ok, preferred if text input
	* /3 / SELECT ST_AsEWKT(ST_GeomFromEWKT('SRID=4326;POINT(-71.06 42.28)')) -- ok, but why then ST_GeomFromText?		/2 / SELECT ST_AsEWKT(ST_GeomFromText('SRID=4326;POINT(-71.06 42.28)')) -- ok (if srid 'inline')
	* /4 / SELECT ST_AsEWKT('SRID=4326;POINT(-71.06 42.28)'::geometry) -- ok, but prefer 1/ST_GeomFromText		/3 / SELECT ST_AsEWKT(ST_GeomFromEWKT('SRID=4326;POINT(-71.06 42.28)')) -- ok, but why then ST_GeomFromText?
	* /5 / SELECT ST_AsEWKT(ST_SetSRID('POINT(-71.06 42.28)'::geometry, 4326)) -- ok, but prefer 1/ST_GeomFromText		/4 / SELECT ST_AsEWKT('SRID=4326;POINT(-71.06 42.28)'::geometry) -- ok, but prefer 1/ST_GeomFromText
	* /6 / SELECT ST_AsEWKT(ST_MakePoint(-71.06, 42.28, 4326)) -- ok for 'symbolic' form. But why no EWKT returning?		/5 / SELECT ST_AsEWKT(ST_SetSRID('POINT(-71.06 42.28)'::geometry, 4326)) -- ok, but prefer 1/ST_GeomFromText
			/6 / SELECT ST_AsEWKT(ST_MakePoint(-71.06, 42.28, 4326)) -- ok for 'symbolic' form. But why no EWKT returning?

	* /1 / SELECT ST_AsEWKT(ST_GeogFromText('POINT(-71.06 42.28)', 4326)) -- ERROR: unknown ST_GeogFromText(): why?		Does not work...!
	* /2a/ SELECT ST_AsEWKT(ST_GeogFromText('SRID=4326;POINT(-71.06 42.28)')) -- ERROR: no ST_AsEWKT: why not?		/1 / SELECT ST_AsEWKT(ST_GeogFromText('POINT(-71.06 42.28)', 4326)) -- ERROR: unknown ST_GeogFromText(): why?
	* /2b/ SELECT ST_AsText(ST_GeogFromText('SRID=4326;POINT(-71.06 42.28)')) -- ok (if srid 'inline'); no AsEWKT		/2a/ SELECT ST_AsEWKT(ST_GeogFromText('SRID=4326;POINT(-71.06 42.28)')) -- ERROR: no ST_AsEWKT: why not?
	* /3 / SELECT ST_AsText(ST_GeogFromEWKT('SRID=4326;POINT(-71.06 42.28)')) -- ERROR: no ST_GeogFromEWKT: why?		/2b/ SELECT ST_AsText(ST_GeogFromText('SRID=4326;POINT(-71.06 42.28)')) -- ok (if srid 'inline'); no AsEWKT
	* /4 / SELECT ST_AsText('SRID=4326;POINT(-71.06 42.28)'::geography) -- ok (no AsEWKT), but prefer 1/ST_GeomFromText		/3 / SELECT ST_AsText(ST_GeogFromEWKT('SRID=4326;POINT(-71.06 42.28)')) -- ERROR: no ST_GeogFromEWKT: why?
	* /5 / SELECT ST_AsText(ST_SetSRID('POINT(-71.06 42.28)'::geography, 4326)) -- ERROR: ok SetSRID w. geography unnecessary		/4 / SELECT ST_AsText('SRID=4326;POINT(-71.06 42.28)'::geography) -- ok (no AsEWKT), but prefer 1/ST_GeomFromText
	* /6 / Equivalent to ST_MakePoint for geography types missing: => ST_MakePointG?		/5 / SELECT ST_AsText(ST_SetSRID('POINT(-71.06 42.28)'::geography, 4326)) -- ERROR: ok SetSRID w. geography unnecessary
			/6 / Equivalent to ST_MakePoint for geography types missing: => ST_MakePointG?

	Wishlist for future(!) PostGIS developments:		Wishlist for future(!) PostGIS developments:

← Nächstältere Version		Version vom 22. Januar 2016, 12:44 Uhr
Zeile 8:		Zeile 8:

	Works...		Works...
	/1 / SELECT ST_AsEWKT(ST_GeomFromText('POINT(-71.06 42.28)', 4326)) -- ok, preferred if text input		/1 / '''SELECT ST_AsEWKT(ST_GeomFromText('POINT(-71.06 42.28)', 4326)) -- ok, preferred if text input'''
	/2 / SELECT ST_AsEWKT(ST_GeomFromText('SRID=4326;POINT(-71.06 42.28)')) -- ok (if srid 'inline')		/2 / '''SELECT ST_AsEWKT(ST_GeomFromText('SRID=4326;POINT(-71.06 42.28)')) -- ok (if srid 'inline')'''
	/3 / SELECT ST_AsEWKT(ST_GeomFromEWKT('SRID=4326;POINT(-71.06 42.28)')) -- ok, but why then ST_GeomFromText?		/3 / SELECT ST_AsEWKT(ST_GeomFromEWKT('SRID=4326;POINT(-71.06 42.28)')) -- ok, but why then ST_GeomFromText?
	/4 / SELECT ST_AsEWKT('SRID=4326;POINT(-71.06 42.28)'::geometry) -- ok, but prefer 1/ST_GeomFromText		/4 / SELECT ST_AsEWKT('SRID=4326;POINT(-71.06 42.28)'::geometry) -- ok, but prefer 1/ST_GeomFromText
Zeile 20:		Zeile 20:
	/2b/ '''SELECT ST_AsText(ST_GeogFromText('SRID=4326;POINT(-71.06 42.28)')) -- ok (if srid 'inline'); (there's no AsEWKT)'''		/2b/ '''SELECT ST_AsText(ST_GeogFromText('SRID=4326;POINT(-71.06 42.28)')) -- ok (if srid 'inline'); (there's no AsEWKT)'''
	/3 / SELECT ST_AsText(ST_GeogFromEWKT('SRID=4326;POINT(-71.06 42.28)')) -- ERROR: no ST_GeogFromEWKT.		/3 / SELECT ST_AsText(ST_GeogFromEWKT('SRID=4326;POINT(-71.06 42.28)')) -- ERROR: no ST_GeogFromEWKT.
	/4 / SELECT ST_AsText('SRID=4326;POINT(-71.06 42.28)'::geography) -- ok (no AsEWKT)~~, but prefer 1/ST_GeomFromText~~		/4 / '''SELECT ST_AsText('SRID=4326;POINT(-71.06 42.28)'::geography) -- ok (no AsEWKT)'''
	/5 / SELECT ST_AsText(ST_SetSRID('POINT(-71.06 42.28)'::geography, 4326)) -- ERROR: ok SetSRID w. geography unnecessary		/5 / SELECT ST_AsText(ST_SetSRID('POINT(-71.06 42.28)'::geography, 4326)) -- ERROR: ok SetSRID w. geography unnecessary
	/6 / Equivalent to ST_MakePoint for geography types missing: => ST_MakePointG?		/6 / Equivalent to ST_MakePoint for geography types missing: => ST_MakePointG?

← Nächstältere Version		Version vom 16. Februar 2011, 13:19 Uhr
Zeile 5:		Zeile 5:
	== Point Constructors ==		== Point Constructors ==

	Point ~~Constructors~~ for geometry and geography types: Howto construct and print a coordinate in EPSG:4326 and in lon/lat format in either textual or 'symbolic' form?		Point constructors for geometry and geography types: Howto construct and print a coordinate in EPSG:4326 and in lon/lat format in either textual or 'symbolic' form?

	* /1 / SELECT ST_AsEWKT(ST_GeomFromText('POINT(-71.06 42.28)', 4326)) -- ok, preferred if text input		Works...
	* /2 / SELECT ST_AsEWKT(ST_GeomFromText('SRID=4326;POINT(-71.06 42.28)')) -- ok (if srid 'inline')		/1 / SELECT ST_AsEWKT(ST_GeomFromText('POINT(-71.06 42.28)', 4326)) -- ok, preferred if text input
	* /3 / SELECT ST_AsEWKT(ST_GeomFromEWKT('SRID=4326;POINT(-71.06 42.28)')) -- ok, but why then ST_GeomFromText?		/2 / SELECT ST_AsEWKT(ST_GeomFromText('SRID=4326;POINT(-71.06 42.28)')) -- ok (if srid 'inline')
	* /4 / SELECT ST_AsEWKT('SRID=4326;POINT(-71.06 42.28)'::geometry) -- ok, but prefer 1/ST_GeomFromText		/3 / SELECT ST_AsEWKT(ST_GeomFromEWKT('SRID=4326;POINT(-71.06 42.28)')) -- ok, but why then ST_GeomFromText?
	* /5 / SELECT ST_AsEWKT(ST_SetSRID('POINT(-71.06 42.28)'::geometry, 4326)) -- ok, but prefer 1/ST_GeomFromText		/4 / SELECT ST_AsEWKT('SRID=4326;POINT(-71.06 42.28)'::geometry) -- ok, but prefer 1/ST_GeomFromText
	* /6 / SELECT ST_AsEWKT(ST_MakePoint(-71.06, 42.28, 4326)) -- ok for 'symbolic' form. But why no EWKT returning?		/5 / SELECT ST_AsEWKT(ST_SetSRID('POINT(-71.06 42.28)'::geometry, 4326)) -- ok, but prefer 1/ST_GeomFromText
			/6 / SELECT ST_AsEWKT(ST_MakePoint(-71.06, 42.28, 4326)) -- ok for 'symbolic' form. But why no EWKT returning?

	* /1 / SELECT ST_AsEWKT(ST_GeogFromText('POINT(-71.06 42.28)', 4326)) -- ERROR: unknown ST_GeogFromText(): why?		Does not work...!
	* /2a/ SELECT ST_AsEWKT(ST_GeogFromText('SRID=4326;POINT(-71.06 42.28)')) -- ERROR: no ST_AsEWKT: why not?		/1 / SELECT ST_AsEWKT(ST_GeogFromText('POINT(-71.06 42.28)', 4326)) -- ERROR: unknown ST_GeogFromText(): why?
	* /2b/ SELECT ST_AsText(ST_GeogFromText('SRID=4326;POINT(-71.06 42.28)')) -- ok (if srid 'inline'); no AsEWKT		/2a/ SELECT ST_AsEWKT(ST_GeogFromText('SRID=4326;POINT(-71.06 42.28)')) -- ERROR: no ST_AsEWKT: why not?
	* /3 / SELECT ST_AsText(ST_GeogFromEWKT('SRID=4326;POINT(-71.06 42.28)')) -- ERROR: no ST_GeogFromEWKT: why?		/2b/ SELECT ST_AsText(ST_GeogFromText('SRID=4326;POINT(-71.06 42.28)')) -- ok (if srid 'inline'); no AsEWKT
	* /4 / SELECT ST_AsText('SRID=4326;POINT(-71.06 42.28)'::geography) -- ok (no AsEWKT), but prefer 1/ST_GeomFromText		/3 / SELECT ST_AsText(ST_GeogFromEWKT('SRID=4326;POINT(-71.06 42.28)')) -- ERROR: no ST_GeogFromEWKT: why?
	* /5 / SELECT ST_AsText(ST_SetSRID('POINT(-71.06 42.28)'::geography, 4326)) -- ERROR: ok SetSRID w. geography unnecessary		/4 / SELECT ST_AsText('SRID=4326;POINT(-71.06 42.28)'::geography) -- ok (no AsEWKT), but prefer 1/ST_GeomFromText
	* /6 / Equivalent to ST_MakePoint for geography types missing: => ST_MakePointG?		/5 / SELECT ST_AsText(ST_SetSRID('POINT(-71.06 42.28)'::geography, 4326)) -- ERROR: ok SetSRID w. geography unnecessary
			/6 / Equivalent to ST_MakePoint for geography types missing: => ST_MakePointG?

	Wishlist for future(!) PostGIS developments:		Wishlist for future(!) PostGIS developments: