[postgis-tickets] [SCM] PostGIS branch master updated. 3.4.0rc1-640-ga396271bb
git at osgeo.org
git at osgeo.org
Thu Sep 28 03:05:57 PDT 2023
This is an automated email from the git hooks/post-receive script. It was
generated because a ref change was pushed to the repository containing
the project "PostGIS".
The branch, master has been updated
via a396271bb6034b6b865504e4c0945d2cc1e8dc8b (commit)
from 70f676483cd672704359ec8c276612c56c91b882 (commit)
Those revisions listed above that are new to this repository have
not appeared on any other notification email; so we list those
revisions in full, below.
- Log -----------------------------------------------------------------
commit a396271bb6034b6b865504e4c0945d2cc1e8dc8b
Author: Chris Mayo <aklhfex at gmail.com>
Date: Wed Sep 27 19:39:52 2023 +0100
Fix stray "[" at the start of some manual code snippets
diff --git a/doc/administration.xml b/doc/administration.xml
index 6dcfc2dab..bd99d0dee 100644
--- a/doc/administration.xml
+++ b/doc/administration.xml
@@ -392,7 +392,7 @@ ALTER EXTENSION postgis_topology UPDATE TO "&last_release_version;next";</progra
entry from spatial_ref_sys and re-construct the check(s) with:
</para>
- <programlisting><![CDATA[[
+ <programlisting><![CDATA[
ALTER TABLE spatial_ref_sys ADD CONSTRAINT spatial_ref_sys_srid_check check (srid > 0 AND srid < 999000 );
]]></programlisting>
diff --git a/doc/extras_historytable.xml b/doc/extras_historytable.xml
index 79c03fb96..89214ff4b 100644
--- a/doc/extras_historytable.xml
+++ b/doc/extras_historytable.xml
@@ -36,7 +36,7 @@
<programlisting>SELECT * FROM roads_history WHERE roads_pk = 111;</programlisting>
<para>Or, to retrieve a view of the roads table at any point in the past:</para>
-<programlisting><![CDATA[[
+<programlisting><![CDATA[
SELECT * FROM roads_history
WHERE date_added < 'January 1, 2001' AND
( date_deleted >= 'January 1, 2001' OR date_deleted IS NULL );
diff --git a/doc/extras_tigergeocoder.xml b/doc/extras_tigergeocoder.xml
index 9dbc2b1f5..fd3bb02f6 100644
--- a/doc/extras_tigergeocoder.xml
+++ b/doc/extras_tigergeocoder.xml
@@ -1273,7 +1273,7 @@ result
</programlisting>
<para>For this one we reuse our geocoded example from <xref linkend="Geocode"/> and we only want the primary address and at most 2 cross streets.</para>
-<programlisting><![CDATA[[
+<programlisting><![CDATA[
SELECT actual_addr, lon, lat, pprint_addy((rg).addy[1]) As int_addr1,
(rg).street[1] As cross1, (rg).street[2] As cross2
FROM (SELECT address As actual_addr, lon, lat,
diff --git a/doc/performance_tips.xml b/doc/performance_tips.xml
index 44bae8033..9d991f600 100644
--- a/doc/performance_tips.xml
+++ b/doc/performance_tips.xml
@@ -66,7 +66,7 @@ UPDATE mytable SET bbox = ST_Envelope(ST_Force2D(geom));</programlisting>
<para>Now change your query to use the && operator against bbox
instead of geom_column, like:</para>
- <programlisting><![CDATA[[
+ <programlisting><![CDATA[
SELECT geom_column
FROM mytable
WHERE bbox && ST_SetSRID('BOX3D(0 0,1 1)'::box3d,4326);
diff --git a/doc/reference_accessor.xml b/doc/reference_accessor.xml
index c9515bdf6..bd92d89ea 100644
--- a/doc/reference_accessor.xml
+++ b/doc/reference_accessor.xml
@@ -1244,7 +1244,7 @@ LINESTRING(0 0 1,1 1 1,1 2 1,1 1 1,0 0 1)
<refsection>
<title>Standard Examples</title>
- <programlisting><![CDATA[[
+ <programlisting><![CDATA[
--Extracting a subset of points from a 3d multipoint
SELECT n, ST_AsEWKT(ST_GeometryN(geom, n)) As geomewkt
FROM (
diff --git a/doc/reference_bbox.xml b/doc/reference_bbox.xml
index 25810a93b..9c282d58c 100644
--- a/doc/reference_bbox.xml
+++ b/doc/reference_bbox.xml
@@ -509,7 +509,7 @@ FROM (SELECT ST_Translate(ST_Force_3DZ(ST_LineToCurve(ST_Buffer(ST_Point(x,y),1)
<refsection>
<title>Examples</title>
- <programlisting><![CDATA[[
+ <programlisting><![CDATA[
--Return all features that fall reside or partly reside in a US national atlas coordinate bounding box
--It is assumed here that the geometries are stored with SRID = 2163 (US National atlas equal area)
diff --git a/doc/reference_cluster.xml b/doc/reference_cluster.xml
index a23b3498e..0432df691 100644
--- a/doc/reference_cluster.xml
+++ b/doc/reference_cluster.xml
@@ -92,7 +92,7 @@
<caption><para>Clusters within 50 meters with at least 2 items per cluster. Singletons have NULL for cid</para></caption>
</mediaobject>
</informalfigure>
- <programlisting><![CDATA[[
+ <programlisting><![CDATA[
SELECT name, ST_ClusterDBSCAN(geom, eps := 50, minpoints := 2) over () AS cid
FROM boston_polys
WHERE name > '' AND building > ''
@@ -103,7 +103,7 @@ WHERE name > '' AND building > ''
]]></programlisting>
</para></entry>
- <entry><para><screen><![CDATA[[
+ <entry><para><screen><![CDATA[
name | bucket
-------------------------------------+--------
Manulife Tower | 0
diff --git a/doc/reference_lrs.xml b/doc/reference_lrs.xml
index bbe6f94b1..ac33725c5 100644
--- a/doc/reference_lrs.xml
+++ b/doc/reference_lrs.xml
@@ -432,7 +432,7 @@ A query to cut a LineString into sections of length 100 or shorter.
It uses <varname>generate_series()</varname> with a CROSS JOIN LATERAL
to produce the equivalent of a FOR loop.
</para>
-<programlisting><![CDATA[[
+<programlisting><![CDATA[
WITH data(id, geom) AS (VALUES
( 'A', 'LINESTRING( 0 0, 200 0)'::geometry ),
diff --git a/doc/reference_measure.xml b/doc/reference_measure.xml
index 60344c59f..3f3c81d9d 100644
--- a/doc/reference_measure.xml
+++ b/doc/reference_measure.xml
@@ -1180,7 +1180,7 @@ ST_3DLength
longitude/latitude and a length is desired without reprojection.
The spheroid is specified by a text value as follows:</para>
- <literallayout><![CDATA[[
+ <literallayout><![CDATA[
SPHEROID[<NAME>,<SEMI-MAJOR AXIS>,<INVERSE FLATTENING>]
]]> </literallayout>
<para>For example:</para>
diff --git a/doc/reference_operator.xml b/doc/reference_operator.xml
index 5b764c079..4bb012abd 100644
--- a/doc/reference_operator.xml
+++ b/doc/reference_operator.xml
@@ -67,7 +67,7 @@
<refsection>
<title>Examples</title>
- <programlisting><![CDATA[[
+ <programlisting><![CDATA[
SELECT tbl1.column1, tbl2.column1, tbl1.column2 && tbl2.column2 AS overlaps
FROM ( VALUES
(1, 'LINESTRING(0 0, 3 3)'::geometry),
@@ -143,7 +143,7 @@ FROM ( VALUES
<refsection>
<title>Examples</title>
- <programlisting><![CDATA[[
+ <programlisting><![CDATA[
SELECT ST_Point(1,1) && ST_MakeBox2D(ST_Point(0,0), ST_Point(2,2)) AS overlaps;
overlaps
@@ -211,7 +211,7 @@ SELECT ST_Point(1,1) && ST_MakeBox2D(ST_Point(0,0), ST_Point(2,2)) AS overlaps;
<refsection>
<title>Examples</title>
- <programlisting><![CDATA[[
+ <programlisting><![CDATA[
SELECT ST_MakeBox2D(ST_Point(0,0), ST_Point(2,2)) && ST_Point(1,1) AS overlaps;
overlaps
@@ -279,7 +279,7 @@ SELECT ST_MakeBox2D(ST_Point(0,0), ST_Point(2,2)) && ST_Point(1,1) AS overlaps;
<refsection>
<title>Examples</title>
- <programlisting><![CDATA[[
+ <programlisting><![CDATA[
SELECT ST_MakeBox2D(ST_Point(0,0), ST_Point(2,2)) && ST_MakeBox2D(ST_Point(1,1), ST_Point(3,3)) AS overlaps;
overlaps
@@ -349,7 +349,7 @@ SELECT ST_MakeBox2D(ST_Point(0,0), ST_Point(2,2)) && ST_MakeBox2D(ST_Point(1,1),
<refsection>
<title>Examples: 3D LineStrings</title>
- <programlisting><![CDATA[[
+ <programlisting><![CDATA[
SELECT tbl1.column1, tbl2.column1, tbl1.column2 &&& tbl2.column2 AS overlaps_3d,
tbl1.column2 && tbl2.column2 AS overlaps_2d
FROM ( VALUES
@@ -369,7 +369,7 @@ FROM ( VALUES
<refsection>
<title>Examples: 3M LineStrings</title>
- <programlisting><![CDATA[[
+ <programlisting><![CDATA[
SELECT tbl1.column1, tbl2.column1, tbl1.column2 &&& tbl2.column2 AS overlaps_3zm,
tbl1.column2 && tbl2.column2 AS overlaps_2d
FROM ( VALUES
@@ -439,7 +439,7 @@ FROM ( VALUES
<refsection>
<title>Examples</title>
- <programlisting><![CDATA[[
+ <programlisting><![CDATA[
SELECT ST_MakePoint(1,1,1) &&& ST_3DMakeBox(ST_MakePoint(0,0,0), ST_MakePoint(2,2,2)) AS overlaps;
overlaps
@@ -503,7 +503,7 @@ SELECT ST_MakePoint(1,1,1) &&& ST_3DMakeBox(ST_MakePoint(0,0,0), ST_MakePoint(2,
<refsection>
<title>Examples</title>
- <programlisting><![CDATA[[
+ <programlisting><![CDATA[
SELECT ST_3DMakeBox(ST_MakePoint(0,0,0), ST_MakePoint(2,2,2)) &&& ST_MakePoint(1,1,1) AS overlaps;
overlaps
@@ -567,7 +567,7 @@ SELECT ST_3DMakeBox(ST_MakePoint(0,0,0), ST_MakePoint(2,2,2)) &&& ST_MakePoint(1
<refsection>
<title>Examples</title>
- <programlisting><![CDATA[[
+ <programlisting><![CDATA[
SELECT ST_3DMakeBox(ST_MakePoint(0,0,0), ST_MakePoint(2,2,2)) &&& ST_3DMakeBox(ST_MakePoint(1,1,1), ST_MakePoint(3,3,3)) AS overlaps;
overlaps
@@ -630,7 +630,7 @@ SELECT ST_3DMakeBox(ST_MakePoint(0,0,0), ST_MakePoint(2,2,2)) &&& ST_3DMakeBox(S
<refsection>
<title>Examples</title>
- <programlisting><![CDATA[[
+ <programlisting><![CDATA[
SELECT tbl1.column1, tbl2.column1, tbl1.column2 &< tbl2.column2 AS overleft
FROM
( VALUES
@@ -707,7 +707,7 @@ FROM
<refsection>
<title>Examples</title>
- <programlisting><![CDATA[[
+ <programlisting><![CDATA[
SELECT tbl1.column1, tbl2.column1, tbl1.column2 &<| tbl2.column2 AS overbelow
FROM
( VALUES
@@ -781,7 +781,7 @@ FROM
<refsection>
<title>Examples</title>
- <programlisting><![CDATA[[
+ <programlisting><![CDATA[
SELECT tbl1.column1, tbl2.column1, tbl1.column2 &> tbl2.column2 AS overright
FROM
( VALUES
@@ -854,7 +854,7 @@ FROM
<refsection>
<title>Examples</title>
- <programlisting><![CDATA[[
+ <programlisting><![CDATA[
SELECT tbl1.column1, tbl2.column1, tbl1.column2 << tbl2.column2 AS left
FROM
( VALUES
@@ -923,7 +923,7 @@ FROM
<refsection>
<title>Examples</title>
- <programlisting><![CDATA[[
+ <programlisting><![CDATA[
SELECT tbl1.column1, tbl2.column1, tbl1.column2 <<| tbl2.column2 AS below
FROM
( VALUES
@@ -1027,7 +1027,7 @@ FROM
<refsection>
<title>Examples</title>
- <programlisting><![CDATA[[
+ <programlisting><![CDATA[
SELECT 'LINESTRING(0 0, 0 1, 1 0)'::geometry = 'LINESTRING(1 1, 0 0)'::geometry;
?column?
----------
@@ -1117,7 +1117,7 @@ f
<refsection>
<title>Examples</title>
- <programlisting><![CDATA[[
+ <programlisting><![CDATA[
SELECT tbl1.column1, tbl2.column1, tbl1.column2 >> tbl2.column2 AS right
FROM
( VALUES
@@ -1188,7 +1188,7 @@ FROM
<refsection>
<title>Examples</title>
- <programlisting><![CDATA[[
+ <programlisting><![CDATA[
SELECT tbl1.column1, tbl2.column1, tbl1.column2 @ tbl2.column2 AS contained
FROM
( VALUES
@@ -1456,7 +1456,7 @@ FROM
<refsection>
<title>Examples</title>
- <programlisting><![CDATA[[
+ <programlisting><![CDATA[
SELECT tbl1.column1, tbl2.column1, tbl1.column2 |&> tbl2.column2 AS overabove
FROM
( VALUES
@@ -1985,7 +1985,7 @@ ORDER BY d limit 10;
<para>
Then the KNN raw answer:
</para>
-<programlisting><![CDATA[[
+<programlisting><![CDATA[
SELECT st_distance(geom, 'SRID=3005;POINT(1011102 450541)'::geometry) as d,edabbr, vaabbr
FROM va2005
ORDER BY geom <-> 'SRID=3005;POINT(1011102 450541)'::geometry limit 10;
@@ -2012,7 +2012,7 @@ If you run "EXPLAIN ANALYZE" on the two queries you would see a performance impr
<para>
For users running with PostgreSQL < 9.5, use a hybrid query to find the true nearest neighbors. First a CTE query using the index-assisted KNN, then an exact query to get correct ordering:
</para>
-<programlisting><![CDATA[[
+<programlisting><![CDATA[
WITH index_query AS (
SELECT ST_Distance(geom, 'SRID=3005;POINT(1011102 450541)'::geometry) as d,edabbr, vaabbr
FROM va2005
@@ -2169,7 +2169,7 @@ Returns the 2D distance between A and B bounding boxes.
<refsection>
<title>Examples</title>
-<programlisting><![CDATA[[
+<programlisting><![CDATA[
SELECT *
FROM (
SELECT b.tlid, b.mtfcc,
diff --git a/doc/reference_output.xml b/doc/reference_output.xml
index dd1cacae9..fa8e28b94 100644
--- a/doc/reference_output.xml
+++ b/doc/reference_output.xml
@@ -494,7 +494,7 @@ F000000000000000000000000000000000000000000000000');
<para>javascript will look something like this where $ variable you replace with query result</para>
- <programlisting><![CDATA[[
+ <programlisting><![CDATA[
<script type="text/javascript" src="http://maps.googleapis.com/maps/api/js?libraries=geometry"></script>
<script type="text/javascript">
flightPath = new google.maps.Polyline({
@@ -889,7 +889,7 @@ SELECT ST_AsGML(ST_GeomFromText('POLYGON((0 0,0 1,1 1,1 0,0 0))',4326));
</refsection>
<refsection>
<title>Examples: Version 3</title>
- <programlisting><![CDATA[[
+ <programlisting><![CDATA[
-- Flip coordinates and output extended EPSG (16 | 1)--
SELECT ST_AsGML(3, ST_GeomFromText('POINT(5.234234233242 6.34534534534)',4326), 5, 17);
st_asgml
@@ -897,7 +897,7 @@ SELECT ST_AsGML(3, ST_GeomFromText('POINT(5.234234233242 6.34534534534)',4326),
<gml:Point srsName="urn:ogc:def:crs:EPSG::4326"><gml:pos>6.34535 5.23423</gml:pos></gml:Point>
]]></programlisting>
- <programlisting><![CDATA[[
+ <programlisting><![CDATA[
-- Output the envelope (32) --
SELECT ST_AsGML(3, ST_GeomFromText('LINESTRING(1 2, 3 4, 10 20)',4326), 5, 32);
st_asgml
@@ -909,7 +909,7 @@ SELECT ST_AsGML(3, ST_GeomFromText('LINESTRING(1 2, 3 4, 10 20)',4326), 5, 32);
]]></programlisting>
- <programlisting><![CDATA[[
+ <programlisting><![CDATA[
-- Output the envelope (32) , reverse (lat lon instead of lon lat) (16), long srs (1)= 32 | 16 | 1 = 49 --
SELECT ST_AsGML(3, ST_GeomFromText('LINESTRING(1 2, 3 4, 10 20)',4326), 5, 49);
st_asgml
@@ -921,7 +921,7 @@ SELECT ST_AsGML(3, ST_GeomFromText('LINESTRING(1 2, 3 4, 10 20)',4326), 5, 49);
]]></programlisting>
- <programlisting><![CDATA[[
+ <programlisting><![CDATA[
-- Polyhedral Example --
SELECT ST_AsGML(3, ST_GeomFromEWKT('POLYHEDRALSURFACE( ((0 0 0, 0 0 1, 0 1 1, 0 1 0, 0 0 0)),
((0 0 0, 0 1 0, 1 1 0, 1 0 0, 0 0 0)), ((0 0 0, 1 0 0, 1 0 1, 0 0 1, 0 0 0)),
@@ -1052,7 +1052,7 @@ SELECT ST_AsGML(3, ST_GeomFromEWKT('POLYHEDRALSURFACE( ((0 0 0, 0 0 1, 0 1 1, 0
<refsection>
<title>Examples</title>
- <programlisting><![CDATA[[
+ <programlisting><![CDATA[
SELECT ST_AsKML(ST_GeomFromText('POLYGON((0 0,0 1,1 1,1 0,0 0))',4326));
st_askml
@@ -1238,7 +1238,7 @@ SELECT (ST_AsLatLonText('POINT (-302.2342342 -792.32498)'));
<title>Examples</title>
<para>Converting a <varname>POINT</varname> to MARC21/XML formated as hdddmmss (default)</para>
- <programlisting><![CDATA[[
+ <programlisting><![CDATA[
SELECT ST_AsMARC21('SRID=4326;POINT(-4.504289 54.253312)'::geometry);
@@ -1260,7 +1260,7 @@ SELECT (ST_AsLatLonText('POINT (-302.2342342 -792.32498)'));
]]></programlisting>
<para>Converting a <varname>POLYGON</varname> to MARC21/XML formated in decimal degrees</para>
- <programlisting><![CDATA[[
+ <programlisting><![CDATA[
SELECT ST_AsMARC21('SRID=4326;POLYGON((-4.5792388916015625 54.18172660239091,-4.56756591796875 54.196993557130355,-4.546623229980469 54.18313300502024,-4.5792388916015625 54.18172660239091))'::geometry,'hddd.dddd');
@@ -1280,7 +1280,7 @@ SELECT (ST_AsLatLonText('POINT (-302.2342342 -792.32498)'));
]]></programlisting>
<para>Converting a <varname>GEOMETRYCOLLECTION</varname> to MARC21/XML formated in decimal minutes. The geometries order in the MARC21/XML output correspond to their order in the collection.</para>
- <programlisting><![CDATA[[
+ <programlisting><![CDATA[
SELECT ST_AsMARC21('SRID=4326;GEOMETRYCOLLECTION(POLYGON((13.1 52.65,13.516666666666667 52.65,13.516666666666667 52.38333333333333,13.1 52.38333333333333,13.1 52.65)),POINT(-4.5 54.25))'::geometry,'hdddmm.mmmm');
@@ -1486,7 +1486,7 @@ SELECT ST_AsMVTGeom(
<refsection>
<title>Examples</title>
- <programlisting><![CDATA[[
+ <programlisting><![CDATA[
WITH mvtgeom AS
(
SELECT ST_AsMVTGeom(geom, ST_TileEnvelope(12, 513, 412), extent => 4096, buffer => 64) AS geom, name, description
@@ -1770,7 +1770,7 @@ SELECT ST_AsTWKB(array_agg(geom), array_agg(gid)) FROM mytable;
<refsection>
<title>Example: Create a fully functional X3D document - This will generate a cube that is viewable in FreeWrl and other X3D viewers.</title>
- <programlisting><![CDATA[[
+ <programlisting><![CDATA[
SELECT '<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE X3D PUBLIC "ISO//Web3D//DTD X3D 3.0//EN" "http://www.web3d.org/specifications/x3d-3.0.dtd">
<X3D>
@@ -1816,7 +1816,7 @@ SELECT '<?xml version="1.0" encoding="UTF-8"?>
<link xlink:href="http://postgis.net/docs/support/viewers/x3d_viewer.htm">x3d scene viewer</link>
and click Show
</para>
- <programlisting><![CDATA[[
+ <programlisting><![CDATA[
SELECT string_agg('<Shape>' || ST_AsX3D(ST_Extrude(geom, 0,0, i*0.5)) ||
'<Appearance>
<Material diffuseColor="' || (0.01*i)::text || ' 0.8 0.2" specularColor="' || (0.05*i)::text || ' 0 0.5"/>
@@ -1835,7 +1835,7 @@ FROM ST_Subdivide(ST_Letters('PostGIS'),20) WITH ORDINALITY AS f(geom,i);
</refsection>
<refsection>
<title>Example: An Octagon elevated 3 Units and decimal precision of 6</title>
- <programlisting><![CDATA[[
+ <programlisting><![CDATA[
SELECT ST_AsX3D(
ST_Translate(
ST_Force_3d(
@@ -1852,7 +1852,7 @@ x3dfrag
</refsection>
<refsection>
<title>Example: TIN</title>
- <programlisting><![CDATA[[
+ <programlisting><![CDATA[
SELECT ST_AsX3D(ST_GeomFromEWKT('TIN (((
0 0 0,
0 0 1,
@@ -1873,7 +1873,7 @@ SELECT ST_AsX3D(ST_GeomFromEWKT('TIN (((
</refsection>
<refsection>
<title>Example: Closed multilinestring (the boundary of a polygon with holes)</title>
- <programlisting><![CDATA[[
+ <programlisting><![CDATA[
SELECT ST_AsX3D(
ST_GeomFromEWKT('MULTILINESTRING((20 0 10,16 -12 10,0 -16 10,-12 -12 10,-20 0 10,-12 16 10,0 24 10,16 16 10,20 0 10),
(12 0 10,8 8 10,0 12 10,-8 8 10,-8 0 10,-8 -4 10,0 -8 10,8 -4 10,12 0 10))')
diff --git a/doc/reference_overlay.xml b/doc/reference_overlay.xml
index fe16e09e6..4d0a2bde0 100644
--- a/doc/reference_overlay.xml
+++ b/doc/reference_overlay.xml
@@ -721,7 +721,7 @@ LINESTRING(44.7994523421035 82.5156766227011,85 85)
and new records for each subdivided result geometry are inserted.
</para>
-<programlisting><![CDATA[[
+<programlisting><![CDATA[
WITH complex_areas_to_subdivide AS (
DELETE from polygons_table
diff --git a/doc/reference_raster.xml b/doc/reference_raster.xml
index 1f2a12d57..2788617e0 100644
--- a/doc/reference_raster.xml
+++ b/doc/reference_raster.xml
@@ -249,7 +249,7 @@ VALUES (1,
<varlistentry>
<term><varname>reclassexpr text</varname></term>
<listitem><para>range expression consisting of comma delimited range:map_range mappings. : to define mapping that defines how to map old band values to new band values. ( means >, ) means less than, ] < or equal, [ means > or equal</para>
- <para><programlisting><![CDATA[[
+ <para><programlisting><![CDATA[
1. [a-b] = a <= x <= b
2. (a-b] = a < x <= b
@@ -1214,7 +1214,7 @@ WHERE short_name = 'JPEG') As g;
(9 rows)
</programlisting>
-<programlisting><![CDATA[[
+<programlisting><![CDATA[
-- raw xml output for creator options for GeoTiff --
SELECT create_options
@@ -4932,7 +4932,7 @@ WHERE rid=2;
2 | 253 | 78 | 70
</programlisting>
- <programlisting><![CDATA[[
+ <programlisting><![CDATA[
--- Get all values in bands 1,2,3 of each pixel --
SELECT x, y, ST_Value(rast, 1, x, y) As b1val,
@@ -4955,7 +4955,7 @@ WHERE rid = 2 AND x <= ST_Width(rast) AND y <= ST_Height(rast);
]]></programlisting>
- <programlisting><![CDATA[[
+ <programlisting><![CDATA[
--- Get all values in bands 1,2,3 of each pixel same as above but returning the upper left point point of each pixel --
SELECT ST_AsText(ST_SetSRID(
@@ -4976,7 +4976,7 @@ WHERE rid = 2 AND x <= ST_Width(rast) AND y <= ST_Height(rast);
:
]]></programlisting>
- <programlisting><![CDATA[[
+ <programlisting><![CDATA[
--- Get a polygon formed by union of all pixels
that fall in a particular value range and intersect particular polygon --
@@ -5013,7 +5013,7 @@ WHERE
]]></programlisting>
- <programlisting><![CDATA[[
+ <programlisting><![CDATA[
--- Checking all the pixels of a large raster tile can take a long time.
--- You can dramatically improve speed at some lose of precision by orders of magnitude
@@ -5583,7 +5583,7 @@ FROM ST_SetValues(
<refsection>
<title>Examples</title>
- <programlisting><![CDATA[[
+ <programlisting><![CDATA[
-- Geometry example
SELECT (foo.geomval).val, ST_AsText(ST_Union((foo.geomval).geom))
@@ -5719,7 +5719,7 @@ GROUP BY (foo.geomval).val;
<refsection>
<title>Examples: Variant 1</title>
- <programlisting><![CDATA[[
+ <programlisting><![CDATA[
/*
The ST_SetValues() does the following...
@@ -5764,7 +5764,7 @@ ORDER BY 1, 2;
]]></programlisting>
- <programlisting><![CDATA[[
+ <programlisting><![CDATA[
/*
The ST_SetValues() does the following...
@@ -8328,7 +8328,7 @@ FROM (SELECT rid, band, ST_SummaryStats(rast, band) As stats
<title>Example: Summarize pixels that intersect buildings of interest</title>
<para>This example took 574ms on PostGIS windows 64-bit with all of Boston Buildings
and aerial Tiles (tiles each 150x150 pixels ~ 134,000 tiles), ~102,000 building records</para>
- <programlisting><![CDATA[[
+ <programlisting><![CDATA[
WITH
-- our features of interest
feat AS (SELECT gid As building_id, geom_26986 As geom FROM buildings AS b
@@ -9005,7 +9005,7 @@ SELECT ST_AsHexWKB(rast) As rastbin FROM dummy_rast WHERE rid=1;
<refsection>
<title>JPEG Output Example, multiple tiles as single raster</title>
- <programlisting><![CDATA[[
+ <programlisting><![CDATA[
SELECT ST_AsGDALRaster(ST_Union(rast), 'JPEG', ARRAY['QUALITY=50']) As rastjpg
FROM dummy_rast
WHERE rast && ST_MakeEnvelope(10, 10, 11, 11);
@@ -9019,7 +9019,7 @@ WHERE rast && ST_MakeEnvelope(10, 10, 11, 11);
We'lll repeat the prior example but also exporting. Note for this you'll need to have super user access to db since it uses server side lo functions.
It will also export to path on server network. If you need export locally,
use the psql equivalent lo_ functions which export to the local file system instead of the server file system.</para>
- <programlisting><![CDATA[[
+ <programlisting><![CDATA[
DROP TABLE IF EXISTS tmp_out ;
CREATE TABLE tmp_out AS
@@ -11723,7 +11723,7 @@ WHERE rid = 2;
</programlisting>
<para>Create a new 1 band raster of pixel-type 2BUI from our original that is reclassified and set the nodata value to a passed parameter to the user function (0).</para>
- <programlisting><![CDATA[[
+ <programlisting><![CDATA[
ALTER TABLE dummy_rast ADD COLUMN map_rast2 raster;
CREATE FUNCTION classify_fct(pixel float, pos integer[], variadic args text[])
RETURNS float
@@ -11918,7 +11918,7 @@ Note that the argument contains the name of the function, the types of the funct
<refsection>
<title>Example: Overlaying rasters on a canvas as separate bands</title>
- <programlisting><![CDATA[[
+ <programlisting><![CDATA[
-- define our user defined function --
CREATE OR REPLACE FUNCTION raster_mapalgebra_union(
@@ -14307,7 +14307,7 @@ MULTIPOLYGON(((3427928 5793243.85,3427928 5793243.8,3427928 5793243.75,3427927.8
<refsection>
<title>Examples</title>
- <programlisting><![CDATA[[
+ <programlisting><![CDATA[
SELECT A.rid As a_rid, B.rid As b_rid, A.rast &< B.rast As overleft
FROM dummy_rast AS A CROSS JOIN dummy_rast AS B;
@@ -14368,7 +14368,7 @@ a_rid | b_rid | overleft
<refsection>
<title>Examples</title>
- <programlisting><![CDATA[[
+ <programlisting><![CDATA[
SELECT A.rid As a_rid, B.rid As b_rid, A.rast &> B.rast As overright
FROM dummy_rast AS A CROSS JOIN dummy_rast AS B;
diff --git a/doc/reference_relationship.xml b/doc/reference_relationship.xml
index 1bb96922a..049af9fd7 100644
--- a/doc/reference_relationship.xml
+++ b/doc/reference_relationship.xml
@@ -1166,7 +1166,7 @@ FROM (SELECT
<para><emphasis role="bold">Example:</emphasis>
Finds all streets that cross
</para>
-<programlisting><![CDATA[[
+<programlisting><![CDATA[
SELECT s1.gid, s2.gid, ST_LineCrossingDirection(s1.geom, s2.geom)
FROM streets s1 CROSS JOIN streets s2
diff --git a/doc/reference_validation.xml b/doc/reference_validation.xml
index 3e79066ab..ed94bb362 100644
--- a/doc/reference_validation.xml
+++ b/doc/reference_validation.xml
@@ -152,7 +152,7 @@ The optional <varname>flags</varname> parameter is a bitfield. It can have the f
<refsection>
<title>Examples</title>
- <programlisting><![CDATA[[
+ <programlisting><![CDATA[
--First 3 Rejects from a successful quintuplet experiment
SELECT gid, reason(ST_IsValidDetail(geom)), ST_AsText(location(ST_IsValidDetail(geom))) as location
@@ -249,7 +249,7 @@ validity_info
--------------------------
Self-intersection[150 150]
</programlisting>
- <programlisting><![CDATA[[
+ <programlisting><![CDATA[
--First 3 Rejects from a successful quintuplet experiment
SELECT gid, ST_IsValidReason(geom) as validity_info
diff --git a/doc/using_postgis_dataman.xml b/doc/using_postgis_dataman.xml
index 148ef7a49..0c5c742d0 100644
--- a/doc/using_postgis_dataman.xml
+++ b/doc/using_postgis_dataman.xml
@@ -2125,7 +2125,7 @@ AVERYLONGCOLUMNNAME DBFFIELD2</programlisting>
this:
</para>
- <programlisting><![CDATA[[
+ <programlisting><![CDATA[
# shp2pgsql -c -D -s 4269 -i -I shaperoads.shp myschema.roadstable > roads.sql
# psql -d roadsdb -f roads.sql
]]></programlisting>
@@ -2224,7 +2224,7 @@ WHERE ST_Intersects(roads_geom, 'SRID=312;POLYGON((...))');</programlisting>
comparison.</para>
<para>Using a "BOX3D" object for the frame, such a query looks like this:</para>
- <programlisting><![CDATA[[
+ <programlisting><![CDATA[
SELECT ST_AsText(roads_geom) AS geom
FROM roads
WHERE
@@ -2243,11 +2243,11 @@ WHERE
to the database and converts a table (possibly defined by a query) into
a shape file. The basic syntax is:</para>
- <programlisting><![CDATA[[
+ <programlisting><![CDATA[
pgsql2shp [<options>] <database> [<schema>.]<table>
]]></programlisting>
- <programlisting><![CDATA[[
+ <programlisting><![CDATA[
pgsql2shp [<options>] <database> <query>
]]></programlisting>
diff --git a/doc/using_postgis_query.xml b/doc/using_postgis_query.xml
index 3abbeb421..5812c7c06 100644
--- a/doc/using_postgis_query.xml
+++ b/doc/using_postgis_query.xml
@@ -426,7 +426,7 @@ WHERE a.id != b.id
specifying a line partly inside and partly outside a polygon is
'<emphasis role="bold">102101FF2</emphasis>':</para>
- <programlisting><![CDATA[[
+ <programlisting><![CDATA[
-- Find wharves partly on a lake's shoreline
SELECT a.lake_id, b.wharf_id
FROM lakes a, wharfs b
@@ -480,7 +480,7 @@ WHERE a.geom && b.geom
operation. For example, the following query would be quite slow on a
large table:</para>
- <programlisting><![CDATA[[
+ <programlisting><![CDATA[
SELECT geom
FROM geom_table
WHERE ST_Distance( geom, 'SRID=312;POINT(100000 200000)' ) < 100
@@ -715,7 +715,7 @@ kilometers
</question>
<answer>
- <programlisting><![CDATA[[
+ <programlisting><![CDATA[
SELECT gid, name, ST_Area(geom) AS area
FROM bc_municipality
WHERE ST_NRings(geom) > 1
diff --git a/doc/using_raster_dataman.xml b/doc/using_raster_dataman.xml
index 866f090f6..e225e0020 100644
--- a/doc/using_raster_dataman.xml
+++ b/doc/using_raster_dataman.xml
@@ -21,7 +21,7 @@
<para>An example session using the loader to create an input file and uploading it chunked in 100x100 tiles might look like this:</para>
- <programlisting><![CDATA[[
+ <programlisting><![CDATA[
# -s use srid 4326
# -I create spatial index
# -C use standard raster constraints
@@ -571,7 +571,7 @@ AWS_SECRET_ACCESS_KEY=xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx';</programlisting
a particular wgs 84 bounding box and then unions with <xref linkend="RT_ST_Union"/> the intersecting tiles together returning all bands, transforms to user specified projection using <xref linkend="RT_ST_Transform"/>,
and then outputs the results as a png using <xref linkend="RT_ST_AsPNG"/>.</para>
<para>You would call the below using <programlisting>http://mywebserver/test_raster.php?srid=2249</programlisting> to get the raster image in Massachusetts state plane feet.</para>
- <programlisting><![CDATA[[
+ <programlisting><![CDATA[
<?php
/** contents of test_raster.php **/
@@ -610,14 +610,14 @@ echo pg_unescape_bytea($row[0]);
and then outputs the results as a png using <xref linkend="RT_ST_AsPNG"/>.</para>
<para>This is same example as <xref linkend="RT_PHP_Output"/> except implemented in C#.</para>
<para>You would call the below using <programlisting>http://mywebserver/TestRaster.ashx?srid=2249</programlisting> to get the raster image in Massachusetts state plane feet.</para>
- <programlisting><![CDATA[[
+ <programlisting><![CDATA[
-- web.config connection string section --
<connectionStrings>
<add name="DSN"
connectionString="server=localhost;database=mydb;Port=5432;User Id=myuser;password=mypwd"/>
</connectionStrings>
]]></programlisting>
- <programlisting><![CDATA[[
+ <programlisting><![CDATA[
// Code for TestRaster.ashx
<%@ WebHandler Language="C#" Class="TestRaster" %>
using System;
-----------------------------------------------------------------------
Summary of changes:
doc/administration.xml | 2 +-
doc/extras_historytable.xml | 2 +-
doc/extras_tigergeocoder.xml | 2 +-
doc/performance_tips.xml | 2 +-
doc/reference_accessor.xml | 2 +-
doc/reference_bbox.xml | 2 +-
doc/reference_cluster.xml | 4 ++--
doc/reference_lrs.xml | 2 +-
doc/reference_measure.xml | 2 +-
doc/reference_operator.xml | 42 +++++++++++++++++++++---------------------
doc/reference_output.xml | 30 +++++++++++++++---------------
doc/reference_overlay.xml | 2 +-
doc/reference_raster.xml | 32 ++++++++++++++++----------------
doc/reference_relationship.xml | 2 +-
doc/reference_validation.xml | 4 ++--
doc/using_postgis_dataman.xml | 8 ++++----
doc/using_postgis_query.xml | 6 +++---
doc/using_raster_dataman.xml | 8 ++++----
18 files changed, 77 insertions(+), 77 deletions(-)
hooks/post-receive
--
PostGIS
More information about the postgis-tickets
mailing list