Home
last modified time | relevance | path

Searched refs:the_geog (Results 1 – 25 of 101) sorted by relevance

12345

/dports/databases/postgis30/postgis-3.0.4/regress/core/
H A Dregress_brin_index_geography.sql31 CREATE INDEX brin_geog on test using brin (the_geog) WITH (pages_per_range = 10);
38 …select num,ST_astext(the_geog) from test where the_geog && ST_GeographyFromText('SRID=4326;POLYGON…
41 SELECT COUNT(num) FROM test WHERE the_geog IS NULL;
48 …select num,ST_astext(the_geog) from test where the_geog && ST_GeographyFromText('SRID=4326;POLYGON…
51 SELECT COUNT(num) FROM test WHERE the_geog IS NULL;
53 …(*) FROM test where ST_Covers(ST_GeogFromText('POLYGON((0 0, 45 0, 45 45, 0 45, 0 0))'), the_geog);
54 SELECT '#4608-2', count(*) FROM test where ST_CoveredBy(the_geog, ST_GeogFromText('POLYGON((0 0, 45…
H A Dtickets.sql167 SELECT '#262', ST_AsText(pt.the_geog) As wkt_pt, ST_Covers(poly.the_geog, pt.the_geog) As geog,
169 ST_Transform(CAST(poly.the_geog As geometry),32611),
170 ST_Transform(CAST(pt.the_geog As geometry),32611)) As utm,
172 CAST(poly.the_geog As geometry),
173 CAST(pt.the_geog As geometry)
184 As pt(the_geog);
256 CREATE TABLE utm_dots ( the_geog geography, utm_srid integer); field
259 SELECT ST_AsText(the_geog) as the_pt,
261 ST_Area(ST_Buffer(the_geog,10)) As the_area,
264 WHERE ST_Area(ST_Buffer(the_geog,10)) NOT between 307 and 315
[all …]
H A Dregress_lots_of_geographies.sql7 INSERT INTO test (num, the_geog)
/dports/databases/postgis32/postgis-3.2.0/regress/core/
H A Dregress_brin_index_geography.sql31 CREATE INDEX brin_geog on test using brin (the_geog) WITH (pages_per_range = 10);
38 …select num,ST_astext(the_geog) from test where the_geog && ST_GeographyFromText('SRID=4326;POLYGON…
41 SELECT COUNT(num) FROM test WHERE the_geog IS NULL;
48 …select num,ST_astext(the_geog) from test where the_geog && ST_GeographyFromText('SRID=4326;POLYGON…
51 SELECT COUNT(num) FROM test WHERE the_geog IS NULL;
53 …(*) FROM test where ST_Covers(ST_GeogFromText('POLYGON((0 0, 45 0, 45 45, 0 45, 0 0))'), the_geog);
54 SELECT '#4608-2', count(*) FROM test where ST_CoveredBy(the_geog, ST_GeogFromText('POLYGON((0 0, 45…
H A Dtickets.sql159 SELECT '#262', ST_AsText(pt.the_geog) As wkt_pt, ST_Covers(poly.the_geog, pt.the_geog) As geog,
161 ST_Transform(CAST(poly.the_geog As geometry),32611),
162 ST_Transform(CAST(pt.the_geog As geometry),32611)) As utm,
164 CAST(poly.the_geog As geometry),
165 CAST(pt.the_geog As geometry)
176 As pt(the_geog);
248 CREATE TABLE utm_dots ( the_geog geography, utm_srid integer); field
251 SELECT ST_AsText(the_geog) as the_pt,
253 ST_Area(ST_Buffer(the_geog,10)) As the_area,
256 WHERE ST_Area(ST_Buffer(the_geog,10)) NOT between 307 and 315
[all …]
H A Dregress_lots_of_geographies.sql7 INSERT INTO test (num, the_geog)
/dports/databases/postgis31/postgis-3.1.4/regress/core/
H A Dregress_brin_index_geography.sql31 CREATE INDEX brin_geog on test using brin (the_geog) WITH (pages_per_range = 10);
38 …select num,ST_astext(the_geog) from test where the_geog && ST_GeographyFromText('SRID=4326;POLYGON…
41 SELECT COUNT(num) FROM test WHERE the_geog IS NULL;
48 …select num,ST_astext(the_geog) from test where the_geog && ST_GeographyFromText('SRID=4326;POLYGON…
51 SELECT COUNT(num) FROM test WHERE the_geog IS NULL;
53 …(*) FROM test where ST_Covers(ST_GeogFromText('POLYGON((0 0, 45 0, 45 45, 0 45, 0 0))'), the_geog);
54 SELECT '#4608-2', count(*) FROM test where ST_CoveredBy(the_geog, ST_GeogFromText('POLYGON((0 0, 45…
H A Dtickets.sql167 SELECT '#262', ST_AsText(pt.the_geog) As wkt_pt, ST_Covers(poly.the_geog, pt.the_geog) As geog,
169 ST_Transform(CAST(poly.the_geog As geometry),32611),
170 ST_Transform(CAST(pt.the_geog As geometry),32611)) As utm,
172 CAST(poly.the_geog As geometry),
173 CAST(pt.the_geog As geometry)
184 As pt(the_geog);
256 CREATE TABLE utm_dots ( the_geog geography, utm_srid integer); field
259 SELECT ST_AsText(the_geog) as the_pt,
261 ST_Area(ST_Buffer(the_geog,10)) As the_area,
264 WHERE ST_Area(ST_Buffer(the_geog,10)) NOT between 307 and 315
[all …]
H A Dregress_lots_of_geographies.sql7 INSERT INTO test (num, the_geog)
/dports/databases/postgis25/postgis-2.5.5/regress/
H A Dregress_brin_index_geography.sql31 CREATE INDEX brin_geog on test using brin (the_geog) WITH (pages_per_range = 10);
38 …select num,ST_astext(the_geog) from test where the_geog && ST_GeographyFromText('SRID=4326;POLYGON…
41 SELECT COUNT(num) FROM test WHERE the_geog IS NULL;
48 …select num,ST_astext(the_geog) from test where the_geog && ST_GeographyFromText('SRID=4326;POLYGON…
51 SELECT COUNT(num) FROM test WHERE the_geog IS NULL;
H A Dtickets.sql176 SELECT '#262', ST_AsText(pt.the_geog) As wkt_pt, ST_Covers(poly.the_geog, pt.the_geog) As geog,
178 ST_Transform(CAST(poly.the_geog As geometry),32611),
179 ST_Transform(CAST(pt.the_geog As geometry),32611)) As utm,
181 CAST(poly.the_geog As geometry),
182 CAST(pt.the_geog As geometry)
193 As pt(the_geog);
265 CREATE TABLE utm_dots ( the_geog geography, utm_srid integer); field
268 SELECT ST_AsText(the_geog) as the_pt,
270 ST_Area(ST_Buffer(the_geog,10)) As the_area,
273 WHERE ST_Area(ST_Buffer(the_geog,10)) NOT between 307 and 315
[all …]
H A Dregress_lots_of_geographies.sql7 INSERT INTO test (num, the_geog)
/dports/databases/postgis25/postgis-2.5.5/regress/sfcgal/
H A Dtickets.sql178 SELECT '#262', ST_AsText(pt.the_geog) As wkt_pt, ST_Covers(poly.the_geog, pt.the_geog) As geog,
180 ST_Transform(CAST(poly.the_geog As geometry),32611),
181 ST_Transform(CAST(pt.the_geog As geometry),32611)) As utm,
183 CAST(poly.the_geog As geometry),
184 CAST(pt.the_geog As geometry)
195 As pt(the_geog);
267 CREATE TABLE utm_dots ( the_geog geography, utm_srid integer); field
270 SELECT ST_AsText(the_geog) as the_pt,
272 ST_Area(ST_Buffer(the_geog,10)) As the_area,
275 WHERE ST_Area(ST_Buffer(the_geog,10)) NOT between 307 and 315
[all …]
/dports/databases/postgis31/postgis-3.1.4/doc/po/ko_KR/
H A Dreference_measure.xml.po282 " ST_Area(the_geog) sqm\n"
2040 "SELECT ST_Length(the_geog) As length_spheroid, ST_Length(the_geog,false) As "
2044 "As the_geog)\n"
2052 "SELECT ST_Length(the_geog) As length_spheroid, ST_Length(the_geog,false) As "
2056 "As the_geog)\n"
4109 #~ "ST_Area(the_geog,false)/POWER(0.3048,2) As sqft_sphere, ST_Area(the_geog) "
4120 #~ " ) As foo(the_geog);\n"
4126 #~ " SELECT ST_Area(the_geog)/POWER(0.3048,2) As sqft, ST_Area(the_geog) As "
4131 #~ "ST_Area(the_geog,false)/POWER(0.3048,2) As sqft_sphere, ST_Area(the_geog) "
4142 #~ " ) As foo(the_geog);\n"
[all …]
/dports/databases/postgis30/postgis-3.0.4/doc/po/ko_KR/
H A Dreference_measure.xml.po282 " ST_Area(the_geog) sqm\n"
2040 "SELECT ST_Length(the_geog) As length_spheroid, ST_Length(the_geog,false) As "
2044 "As the_geog)\n"
2052 "SELECT ST_Length(the_geog) As length_spheroid, ST_Length(the_geog,false) As "
2056 "As the_geog)\n"
4070 #~ "ST_Area(the_geog,false)/POWER(0.3048,2) As sqft_sphere, ST_Area(the_geog) "
4081 #~ " ) As foo(the_geog);\n"
4087 #~ " SELECT ST_Area(the_geog)/POWER(0.3048,2) As sqft, ST_Area(the_geog) As "
4092 #~ "ST_Area(the_geog,false)/POWER(0.3048,2) As sqft_sphere, ST_Area(the_geog) "
4103 #~ " ) As foo(the_geog);\n"
[all …]
/dports/databases/postgis32/postgis-3.2.0/doc/po/ko_KR/
H A Dreference_measure.xml.po282 " ST_Area(the_geog) sqm\n"
2079 "SELECT ST_Length(the_geog) As length_spheroid, ST_Length(the_geog,false) As "
2083 "As the_geog)\n"
2091 "SELECT ST_Length(the_geog) As length_spheroid, ST_Length(the_geog,false) As "
2095 "As the_geog)\n"
4190 #~ "ST_Area(the_geog,false)/POWER(0.3048,2) As sqft_sphere, ST_Area(the_geog) "
4201 #~ " ) As foo(the_geog);\n"
4207 #~ " SELECT ST_Area(the_geog)/POWER(0.3048,2) As sqft, ST_Area(the_geog) As "
4212 #~ "ST_Area(the_geog,false)/POWER(0.3048,2) As sqft_sphere, ST_Area(the_geog) "
4223 #~ " ) As foo(the_geog);\n"
[all …]
/dports/graphics/py-gdal/gdal-3.3.3/doc/source/drivers/vector/
H A Dpgdump.rst65 *the_geog* for GEOM_TYPE=geography.
/dports/graphics/p5-Geo-GDAL/gdal-3.3.3/doc/source/drivers/vector/
H A Dpgdump.rst65 *the_geog* for GEOM_TYPE=geography.
/dports/graphics/gdal/gdal-3.3.3/doc/source/drivers/vector/
H A Dpgdump.rst65 *the_geog* for GEOM_TYPE=geography.
/dports/databases/postgis31/postgis-3.1.4/doc/po/ja/
H A Dreference_measure.xml.po281 " ST_Area(the_geog) sqm\n"
2120 "SELECT ST_Length(the_geog) As length_spheroid, ST_Length(the_geog,false) As "
2124 "As the_geog)\n"
2132 "SELECT ST_Length(the_geog) As length_spheroid, ST_Length(the_geog,false) As "
2136 "As the_geog)\n"
4186 #~ "ST_Area(the_geog,false)/POWER(0.3048,2) As sqft_sphere, ST_Area(the_geog) "
4197 #~ " ) As foo(the_geog);\n"
4203 #~ " SELECT ST_Area(the_geog)/POWER(0.3048,2) As sqft, ST_Area(the_geog) As "
4208 #~ "ST_Area(the_geog,false)/POWER(0.3048,2) As sqft_sphere, ST_Area(the_geog) "
4219 #~ " ) As foo(the_geog);\n"
[all …]
/dports/databases/postgis30/postgis-3.0.4/doc/po/ja/
H A Dreference_measure.xml.po281 " ST_Area(the_geog) sqm\n"
2120 "SELECT ST_Length(the_geog) As length_spheroid, ST_Length(the_geog,false) As "
2124 "As the_geog)\n"
2132 "SELECT ST_Length(the_geog) As length_spheroid, ST_Length(the_geog,false) As "
2136 "As the_geog)\n"
4142 #~ "ST_Area(the_geog,false)/POWER(0.3048,2) As sqft_sphere, ST_Area(the_geog) "
4153 #~ " ) As foo(the_geog);\n"
4159 #~ " SELECT ST_Area(the_geog)/POWER(0.3048,2) As sqft, ST_Area(the_geog) As "
4164 #~ "ST_Area(the_geog,false)/POWER(0.3048,2) As sqft_sphere, ST_Area(the_geog) "
4175 #~ " ) As foo(the_geog);\n"
[all …]
/dports/databases/postgis32/postgis-3.2.0/doc/po/ja/
H A Dreference_measure.xml.po281 " ST_Area(the_geog) sqm\n"
2137 "SELECT ST_Length(the_geog) As length_spheroid, ST_Length(the_geog,false) As "
2141 "As the_geog)\n"
2149 "SELECT ST_Length(the_geog) As length_spheroid, ST_Length(the_geog,false) As "
2153 "As the_geog)\n"
4309 #~ "ST_Area(the_geog,false)/POWER(0.3048,2) As sqft_sphere, ST_Area(the_geog) "
4320 #~ " ) As foo(the_geog);\n"
4326 #~ " SELECT ST_Area(the_geog)/POWER(0.3048,2) As sqft, ST_Area(the_geog) As "
4331 #~ "ST_Area(the_geog,false)/POWER(0.3048,2) As sqft_sphere, ST_Area(the_geog) "
4342 #~ " ) As foo(the_geog);\n"
[all …]
/dports/databases/postgis25/postgis-2.5.5/doc/po/ko_KR/
H A Dreference_measure.xml.po1401 "SELECT ST_Area(the_geog)/POWER(0.3048,2) As sqft_spheroid, ST_Area(the_geog,"
1402 "false)/POWER(0.3048,2) As sqft_sphere, ST_Area(the_geog) As sqm_spheroid\n"
1412 " ) As foo(the_geog);\n"
1418 " SELECT ST_Area(the_geog)/POWER(0.3048,2) As sqft, ST_Area(the_geog) As "
1422 "SELECT ST_Area(the_geog)/POWER(0.3048,2) As sqft_spheroid, ST_Area(the_geog,"
1433 " ) As foo(the_geog);\n"
1439 " SELECT ST_Area(the_geog)/POWER(0.3048,2) As sqft, ST_Area(the_geog) As "
5765 "SELECT ST_Length(the_geog) As length_spheroid, ST_Length(the_geog,false) As "
5769 "As the_geog)\n"
5776 "SELECT ST_Length(the_geog) As length_spheroid, ST_Length(the_geog,false) As "
[all …]
/dports/databases/postgis25/postgis-2.5.5/doc/po/ja/
H A Dreference_measure.xml.po1403 "SELECT ST_Area(the_geog)/POWER(0.3048,2) As sqft_spheroid, ST_Area(the_geog,"
1404 "false)/POWER(0.3048,2) As sqft_sphere, ST_Area(the_geog) As sqm_spheroid\n"
1414 " ) As foo(the_geog);\n"
1420 " SELECT ST_Area(the_geog)/POWER(0.3048,2) As sqft, ST_Area(the_geog) As "
1424 "SELECT ST_Area(the_geog)/POWER(0.3048,2) As sqft_spheroid, ST_Area(the_geog,"
1435 " ) As foo(the_geog);\n"
1441 " SELECT ST_Area(the_geog)/POWER(0.3048,2) As sqft, ST_Area(the_geog) As "
5972 "SELECT ST_Length(the_geog) As length_spheroid, ST_Length(the_geog,false) As "
5976 "As the_geog)\n"
5983 "SELECT ST_Length(the_geog) As length_spheroid, ST_Length(the_geog,false) As "
[all …]
/dports/databases/postgis25/postgis-2.5.5/doc/po/de/
H A Dreference_measure.xml.po997 "SELECT ST_Area(the_geog)/POWER(0.3048,2) As sqft_spheroid, ST_Area(the_geog,false)/POWER(0.3048,2…
1006 " ) As foo(the_geog);\n"
1012 " SELECT ST_Area(the_geog)/POWER(0.3048,2) As sqft, ST_Area(the_geog) As sqm\n"
1014 …the_geog)/POWER(0.3048,2) As sqft_spheroid, ST_Area(the_geog,false)/POWER(0.3048,2) As sqft_spher…
4143 "SELECT ST_Length(the_geog) As length_spheroid, ST_Length(the_geog,false) As length_sphere\n"
4145 "'SRID=4326;LINESTRING(-72.1260 42.45, -72.1240 42.45666, -72.123 42.1546)') As the_geog)\n"

12345