[postgis-tickets] r15119 - doc corrections from ruvyn for PostGIS 2.2.3
Regina Obe
lr at pcorp.us
Sun Sep 18 21:55:14 PDT 2016
Author: robe
Date: 2016-09-18 21:55:14 -0700 (Sun, 18 Sep 2016)
New Revision: 15119
Modified:
branches/2.2/NEWS
branches/2.2/doc/faq_raster.xml
branches/2.2/doc/reference_constructor.xml
branches/2.2/doc/reference_raster.xml
Log:
doc corrections from ruvyn for PostGIS 2.2.3
closes #3581
closes #3580
closes #3586
closes #3575
Modified: branches/2.2/NEWS
===================================================================
--- branches/2.2/NEWS 2016-09-19 04:54:41 UTC (rev 15118)
+++ branches/2.2/NEWS 2016-09-19 04:55:14 UTC (rev 15119)
@@ -28,6 +28,7 @@
(Christian Quest / Dan Baston)
- #3501 use ST_Union instead of ST_Collect to compute
raster max extent constraint
+ - Numerous documentation corrections from ruvyn
PostGIS 2.2.2
Modified: branches/2.2/doc/faq_raster.xml
===================================================================
--- branches/2.2/doc/faq_raster.xml 2016-09-19 04:54:41 UTC (rev 15118)
+++ branches/2.2/doc/faq_raster.xml 2016-09-19 04:55:14 UTC (rev 15119)
@@ -264,7 +264,7 @@
</question>
<answer>
- <para>The function is not unique error happens if one of your arguments is a textual representation of a geometry instead of a geometry. In these cases, PostgreSQL marks the textual representation as an unknown type, which means it can fall into the st_intersects(raster, geometry) or st_intersects(raster,raster) thus resulting in a non-unique case since both functions can in theory support your request. To prevent this, you need to cast the geometry to a geometry.</para>
+ <para>The function is not unique error happens if one of your arguments is a textual representation of a geometry instead of a geometry. In these cases, PostgreSQL marks the textual representation as an unknown type, which means it can fall into the st_intersects(raster, geometry) or st_intersects(raster,raster) thus resulting in a non-unique case since both functions can in theory support your request. To prevent this, you need to cast the textual representation of the geometry to a geometry.</para>
<para>For example if your code looks like this:</para>
<programlisting>SELECT rast
FROM my_raster
Modified: branches/2.2/doc/reference_constructor.xml
===================================================================
--- branches/2.2/doc/reference_constructor.xml 2016-09-19 04:54:41 UTC (rev 15118)
+++ branches/2.2/doc/reference_constructor.xml 2016-09-19 04:55:14 UTC (rev 15119)
@@ -425,7 +425,7 @@
\\312Q\\300\\366{b\\235*!E@\\225|\\354.P\\312Q
\\300p\\231\\323e1!E@');</programlisting>
- <note><para>In PostgreSQL 9.1+ - standard_conforming_strings is set to on by default, where as in past versions it was set to on. You can change defaults as needed
+ <note><para>In PostgreSQL 9.1+ - standard_conforming_strings is set to on by default, where as in past versions it was set to off. You can change defaults as needed
for a single query or at the database or server level. Below is how you would do it with standard_conforming_strings = on. In this case we escape the ' with standard ansi ',
but slashes are not escaped</para></note>
<programlisting>
Modified: branches/2.2/doc/reference_raster.xml
===================================================================
--- branches/2.2/doc/reference_raster.xml 2016-09-19 04:54:41 UTC (rev 15118)
+++ branches/2.2/doc/reference_raster.xml 2016-09-19 04:55:14 UTC (rev 15119)
@@ -6423,12 +6423,17 @@
<title>Examples</title>
<para>A simple example reskewing a raster from a skew of 0.0 to a skew of 0.0015.</para>
- <programlisting>-- the original raster pixel size
-SELECT ST_Rotation(ST_AddBand(ST_MakeEmptyRaster(100, 100, 0, 0, 0.001, -0.001, 0, 0, 4269), '8BUI'::text, 1, 0))
+ <programlisting>-- the original raster non-rotated
+SELECT ST_Rotation(ST_AddBand(ST_MakeEmptyRaster(100, 100, 0, 0, 0.001, -0.001, 0, 0, 4269), '8BUI'::text, 1, 0));
+
+-- result
+0
--- the rescaled raster raster pixel size
-SELECT ST_Rotation(ST_Reskew(ST_AddBand(ST_MakeEmptyRaster(100, 100, 0, 0, 0.001, -0.001, 0, 0, 4269), '8BUI'::text, 1, 0), 0.0015))
- </programlisting>
+-- the reskewed raster raster rotation
+SELECT ST_Rotation(ST_Reskew(ST_AddBand(ST_MakeEmptyRaster(100, 100, 0, 0, 0.001, -0.001, 0, 0, 4269), '8BUI'::text, 1, 0), 0.0015));
+
+-- result
+-0.982793723247329</programlisting>
</refsection>
@@ -6506,12 +6511,16 @@
<title>Examples</title>
<para>A simple example snapping a raster to a slightly different grid.</para>
- <programlisting>-- the original raster pixel size
-SELECT ST_UpperLeftX(ST_AddBand(ST_MakeEmptyRaster(10, 10, 0, 0, 0.001, -0.001, 0, 0, 4269), '8BUI'::text, 1, 0))
+ <programlisting>-- the original raster upper left X
+SELECT ST_UpperLeftX(ST_AddBand(ST_MakeEmptyRaster(10, 10, 0, 0, 0.001, -0.001, 0, 0, 4269), '8BUI'::text, 1, 0));
+-- result
+0
--- the rescaled raster raster pixel size
-SELECT ST_UpperLeftX(ST_SnapToGrid(ST_AddBand(ST_MakeEmptyRaster(10, 10, 0, 0, 0.001, -0.001, 0, 0, 4269), '8BUI'::text, 1, 0), 0.0002, 0.0002))
- </programlisting>
+-- the upper left of raster after snapping
+SELECT ST_UpperLeftX(ST_SnapToGrid(ST_AddBand(ST_MakeEmptyRaster(10, 10, 0, 0, 0.001, -0.001, 0, 0, 4269), '8BUI'::text, 1, 0), 0.0002, 0.0002));
+
+--result
+-0.0008</programlisting>
</refsection>
More information about the postgis-tickets
mailing list