]> granicus.if.org Git - postgis/log
postgis
14 years agomore speed optimizations
Regina Obe [Sun, 5 Jun 2011 07:35:14 +0000 (07:35 +0000)]
more speed optimizations

git-svn-id: http://svn.osgeo.org/postgis/trunk@7323 b70326c6-7e19-0410-871a-916f4a2858ee

14 years agorevise function s so lookup zip utilizes constraint exclusion
Regina Obe [Sun, 5 Jun 2011 07:07:40 +0000 (07:07 +0000)]
revise function s so lookup zip utilizes constraint exclusion

git-svn-id: http://svn.osgeo.org/postgis/trunk@7322 b70326c6-7e19-0410-871a-916f4a2858ee

14 years ago#1004: census has finally released zcta5 for 2010. Get rid of zcta500 table. replac...
Regina Obe [Sun, 5 Jun 2011 06:13:09 +0000 (06:13 +0000)]
#1004: census has finally released zcta5 for 2010.  Get rid of zcta500 table.  replace with a more generic named zcta5.  Revise loader state script to load in zcta510 data and revise functions to use new zcta5 table.

git-svn-id: http://svn.osgeo.org/postgis/trunk@7321 b70326c6-7e19-0410-871a-916f4a2858ee

14 years agoFix more erroneous statements about ST_Reclass
Regina Obe [Sat, 4 Jun 2011 02:11:03 +0000 (02:11 +0000)]
Fix more erroneous statements about ST_Reclass

git-svn-id: http://svn.osgeo.org/postgis/trunk@7320 b70326c6-7e19-0410-871a-916f4a2858ee

14 years agoget rid of TODO note on ST_REclass exmaple -- I already did it.
Regina Obe [Sat, 4 Jun 2011 00:59:34 +0000 (00:59 +0000)]
get rid of TODO note on ST_REclass exmaple -- I already did it.

git-svn-id: http://svn.osgeo.org/postgis/trunk@7319 b70326c6-7e19-0410-871a-916f4a2858ee

14 years agohuh more mistakes in ST_Reclass
Regina Obe [Sat, 4 Jun 2011 00:58:41 +0000 (00:58 +0000)]
huh more mistakes in ST_Reclass

git-svn-id: http://svn.osgeo.org/postgis/trunk@7318 b70326c6-7e19-0410-871a-916f4a2858ee

14 years agoAdded rt_raster_from_gdal_dataset function to rt_core/rt_api.c. This function provid...
Bborie Park [Fri, 3 Jun 2011 17:02:57 +0000 (17:02 +0000)]
Added rt_raster_from_gdal_dataset function to rt_core/rt_api.c.  This function provides the functionality needed to convert a GDAL dataset into a PostGIS Raster object.

git-svn-id: http://svn.osgeo.org/postgis/trunk@7317 b70326c6-7e19-0410-871a-916f4a2858ee

14 years agoCheck for new GDALFPolygonize function. If it isn't present, the old GDALPolygonize...
Jorge Arévalo [Fri, 3 Jun 2011 15:19:40 +0000 (15:19 +0000)]
Check for new GDALFPolygonize function. If it isn't present, the old GDALPolygonize is called. Related ticket #650.

git-svn-id: http://svn.osgeo.org/postgis/trunk@7316 b70326c6-7e19-0410-871a-916f4a2858ee

14 years agoadd missing ST_ValueCount protos, get rid of ' around , causing comment installation...
Regina Obe [Fri, 3 Jun 2011 06:00:38 +0000 (06:00 +0000)]
add missing ST_ValueCount protos, get rid of ' around , causing comment installation to fail.

git-svn-id: http://svn.osgeo.org/postgis/trunk@7315 b70326c6-7e19-0410-871a-916f4a2858ee

14 years agofix wording of reclassarg and summarystats
Regina Obe [Thu, 2 Jun 2011 22:51:27 +0000 (22:51 +0000)]
fix wording of reclassarg and summarystats

git-svn-id: http://svn.osgeo.org/postgis/trunk@7314 b70326c6-7e19-0410-871a-916f4a2858ee

14 years agoFix typo
Regina Obe [Thu, 2 Jun 2011 22:25:19 +0000 (22:25 +0000)]
Fix typo

git-svn-id: http://svn.osgeo.org/postgis/trunk@7313 b70326c6-7e19-0410-871a-916f4a2858ee

14 years agodocument ST_Band
Regina Obe [Thu, 2 Jun 2011 21:54:57 +0000 (21:54 +0000)]
document ST_Band

git-svn-id: http://svn.osgeo.org/postgis/trunk@7312 b70326c6-7e19-0410-871a-916f4a2858ee

14 years agoget rid of extra paragraph marks
Regina Obe [Thu, 2 Jun 2011 21:27:02 +0000 (21:27 +0000)]
get rid of extra paragraph marks

git-svn-id: http://svn.osgeo.org/postgis/trunk@7311 b70326c6-7e19-0410-871a-916f4a2858ee

14 years agoexample how to use variadic version of ST_Reclass raster function, finish off reclass...
Regina Obe [Thu, 2 Jun 2011 21:13:47 +0000 (21:13 +0000)]
example how to use variadic version of ST_Reclass raster function, finish off reclassarg type description, add summarystats type

git-svn-id: http://svn.osgeo.org/postgis/trunk@7310 b70326c6-7e19-0410-871a-916f4a2858ee

14 years agoClarify GDAL version requirements for Mapserver to load PostGIS raster
Regina Obe [Thu, 2 Jun 2011 05:05:59 +0000 (05:05 +0000)]
Clarify GDAL version requirements for Mapserver to load PostGIS raster

git-svn-id: http://svn.osgeo.org/postgis/trunk@7309 b70326c6-7e19-0410-871a-916f4a2858ee

14 years agoFixed ticket #650. You need to update your GDAL copy to a release up to 22476 to...
Jorge Arévalo [Wed, 1 Jun 2011 23:50:14 +0000 (23:50 +0000)]
Fixed ticket #650. You need to update your GDAL copy to a release up to 22476 to make it work.

git-svn-id: http://svn.osgeo.org/postgis/trunk@7308 b70326c6-7e19-0410-871a-916f4a2858ee

14 years agoThe box2d of an empty geometry is NULL, not a point. Closes ticket #938 and regress...
Sandro Santilli [Wed, 1 Jun 2011 12:31:58 +0000 (12:31 +0000)]
The box2d of an empty geometry is NULL, not a point. Closes ticket #938 and regress-tests it.

git-svn-id: http://svn.osgeo.org/postgis/trunk@7307 b70326c6-7e19-0410-871a-916f4a2858ee

14 years agoput a space after parameter name to try to prevent getting shoved in with type in...
Regina Obe [Wed, 1 Jun 2011 11:55:50 +0000 (11:55 +0000)]
put a space after parameter name to try to prevent getting shoved in with type in reclassarg type def

git-svn-id: http://svn.osgeo.org/postgis/trunk@7306 b70326c6-7e19-0410-871a-916f4a2858ee

14 years agost_recalss -- hmm screwed up on example. Had overlapping ranges before.
Regina Obe [Wed, 1 Jun 2011 08:22:30 +0000 (08:22 +0000)]
st_recalss -- hmm screwed up on example.  Had overlapping ranges before.

git-svn-id: http://svn.osgeo.org/postgis/trunk@7305 b70326c6-7e19-0410-871a-916f4a2858ee

14 years agomove raster types to raster section (there are way too many now to try to lump into...
Regina Obe [Wed, 1 Jun 2011 08:17:27 +0000 (08:17 +0000)]
move raster types to raster section (there are way too many now to try to lump into reference_type and do case statements to exclude from postgis_comments).  Revise raster_comments to look for types in reference_raster.  Add docu for ST_Reclass and reclassarg type.  Need at least one more example to show how to use recalssargs.

git-svn-id: http://svn.osgeo.org/postgis/trunk@7304 b70326c6-7e19-0410-871a-916f4a2858ee

14 years agoadditional code refactoring in rt_raster_from_band
Bborie Park [Tue, 31 May 2011 22:54:18 +0000 (22:54 +0000)]
additional code refactoring in rt_raster_from_band

git-svn-id: http://svn.osgeo.org/postgis/trunk@7303 b70326c6-7e19-0410-871a-916f4a2858ee

14 years agocode refactored and added copying of raster attributes to new raster in rt_raster_fro...
Bborie Park [Tue, 31 May 2011 22:47:33 +0000 (22:47 +0000)]
code refactored and added copying of raster attributes to new raster in rt_raster_from_band

git-svn-id: http://svn.osgeo.org/postgis/trunk@7302 b70326c6-7e19-0410-871a-916f4a2858ee

14 years ago#960 get rid of obsolete ST_AsPNG protos to make consistent with implementation
Regina Obe [Tue, 31 May 2011 01:50:18 +0000 (01:50 +0000)]
#960 get rid of obsolete ST_AsPNG protos to make consistent with implementation

git-svn-id: http://svn.osgeo.org/postgis/trunk@7301 b70326c6-7e19-0410-871a-916f4a2858ee

14 years ago#960 get rid of ST_AsGDALRaster proto and update remaining to be consistent with...
Regina Obe [Tue, 31 May 2011 01:39:18 +0000 (01:39 +0000)]
#960 get rid of ST_AsGDALRaster proto and update remaining to be consistent with new default args.

git-svn-id: http://svn.osgeo.org/postgis/trunk@7300 b70326c6-7e19-0410-871a-916f4a2858ee

14 years ago#961- reduce number of functions - Get rid of st_area(geography) and change st_area...
Regina Obe [Tue, 31 May 2011 01:29:19 +0000 (01:29 +0000)]
#961- reduce number of functions -  Get rid of st_area(geography) and change st_area(geography, use_spheroid = true) and also have named argument names so callable by named args

git-svn-id: http://svn.osgeo.org/postgis/trunk@7299 b70326c6-7e19-0410-871a-916f4a2858ee

14 years agodocument missing proto for createtopology
Regina Obe [Tue, 31 May 2011 01:09:04 +0000 (01:09 +0000)]
document missing proto for createtopology

git-svn-id: http://svn.osgeo.org/postgis/trunk@7298 b70326c6-7e19-0410-871a-916f4a2858ee

14 years agoDocument ST_SummaryStats raster function
Regina Obe [Tue, 31 May 2011 00:54:01 +0000 (00:54 +0000)]
Document ST_SummaryStats raster function

git-svn-id: http://svn.osgeo.org/postgis/trunk@7297 b70326c6-7e19-0410-871a-916f4a2858ee

14 years agoAdded default values for function parameters of ST_AsTIFF, ST_AsJPEG and ST_AsPNG.
Bborie Park [Mon, 30 May 2011 20:18:23 +0000 (20:18 +0000)]
Added default values for function parameters of ST_AsTIFF, ST_AsJPEG and ST_AsPNG.

Associated ticket is #960

git-svn-id: http://svn.osgeo.org/postgis/trunk@7296 b70326c6-7e19-0410-871a-916f4a2858ee

14 years agoAdded default parameter for ST_AsGDALRaster
Bborie Park [Mon, 30 May 2011 15:48:37 +0000 (15:48 +0000)]
Added default parameter for ST_AsGDALRaster

Associated ticket is #960

git-svn-id: http://svn.osgeo.org/postgis/trunk@7295 b70326c6-7e19-0410-871a-916f4a2858ee

14 years agorenamed all instances of "hasnodata" function argument to "exclude_nodata_value"...
Bborie Park [Mon, 30 May 2011 14:53:11 +0000 (14:53 +0000)]
renamed all instances of "hasnodata" function argument to "exclude_nodata_value" in SQL functions (and underlying code where appropriate) ST_SummaryStats, ST_Count, ST_Sum, ST_Mean, ST_StdDev, ST_MinMax, ST_Quantile, ST_Histogram, ST_ValueCount and ST_ValuePercent

git-svn-id: http://svn.osgeo.org/postgis/trunk@7294 b70326c6-7e19-0410-871a-916f4a2858ee

14 years agoget rid of bash line -- seems unnecessary and breaks if multiple states. Forgot...
Regina Obe [Mon, 30 May 2011 09:45:36 +0000 (09:45 +0000)]
get rid of bash line -- seems unnecessary and breaks if multiple states.  Forgot cd which was making secondary states fail loading.

git-svn-id: http://svn.osgeo.org/postgis/trunk@7293 b70326c6-7e19-0410-871a-916f4a2858ee

14 years agogit-svn-id: http://svn.osgeo.org/postgis/trunk@7292 b70326c6-7e19-0410-871a-916f4a2858ee
Regina Obe [Mon, 30 May 2011 08:28:13 +0000 (08:28 +0000)]
git-svn-id: http://svn.osgeo.org/postgis/trunk@7292 b70326c6-7e19-0410-871a-916f4a2858ee

14 years agomore corrections and one more example for ST_ValueCount
Regina Obe [Mon, 30 May 2011 08:27:29 +0000 (08:27 +0000)]
more corrections and one more example for ST_ValueCount

git-svn-id: http://svn.osgeo.org/postgis/trunk@7291 b70326c6-7e19-0410-871a-916f4a2858ee

14 years agofix errors in notes
Regina Obe [Mon, 30 May 2011 07:39:39 +0000 (07:39 +0000)]
fix errors in notes

git-svn-id: http://svn.osgeo.org/postgis/trunk@7290 b70326c6-7e19-0410-871a-916f4a2858ee

14 years agofill in more missing protos for st_valuecount -- still more to go
Regina Obe [Mon, 30 May 2011 03:57:42 +0000 (03:57 +0000)]
fill in more missing protos for st_valuecount -- still more to go

git-svn-id: http://svn.osgeo.org/postgis/trunk@7289 b70326c6-7e19-0410-871a-916f4a2858ee

14 years agoput in missing protos for st_quantile. Revise comment generator scripts to properly...
Regina Obe [Mon, 30 May 2011 03:43:09 +0000 (03:43 +0000)]
put in missing protos for st_quantile.  Revise comment generator scripts to properly handle OUT parameters

git-svn-id: http://svn.osgeo.org/postgis/trunk@7288 b70326c6-7e19-0410-871a-916f4a2858ee

14 years agodocument ST_quantile -- still missing some protos (also get rid of obsolete warnings)
Regina Obe [Mon, 30 May 2011 02:52:07 +0000 (02:52 +0000)]
document ST_quantile -- still missing some protos (also get rid of obsolete warnings)

git-svn-id: http://svn.osgeo.org/postgis/trunk@7287 b70326c6-7e19-0410-871a-916f4a2858ee

14 years agoreference to st_valuecount in st_dumpaspixels
Regina Obe [Mon, 30 May 2011 01:56:17 +0000 (01:56 +0000)]
reference to st_valuecount in st_dumpaspixels

git-svn-id: http://svn.osgeo.org/postgis/trunk@7286 b70326c6-7e19-0410-871a-916f4a2858ee

14 years agoMove Bborie's new cool stat functions into their own section. Add documentation...
Regina Obe [Mon, 30 May 2011 01:51:37 +0000 (01:51 +0000)]
Move Bborie's new cool stat functions into their own section.  Add documentation for st_valuecount -- more coming for other raster functions.  macro replace hasnodata with exclude_nodata_value which hopefully will be clearer to everyone.  The raster codebase needs to be changed to agree with new names (mostly for those utilizing named arguments in PostgreSQL 9.0+).  In enhnced section --put a note that hasnodata was renamed to exclude_nodata_value.

git-svn-id: http://svn.osgeo.org/postgis/trunk@7285 b70326c6-7e19-0410-871a-916f4a2858ee

14 years agoadd remarked out line to set search path -- suggested by Brian Hamlin. Also some...
Regina Obe [Mon, 30 May 2011 00:30:58 +0000 (00:30 +0000)]
add remarked out line to set search path -- suggested by Brian Hamlin.  Also some other minor changes

git-svn-id: http://svn.osgeo.org/postgis/trunk@7284 b70326c6-7e19-0410-871a-916f4a2858ee

14 years agoGet rid of deprecated call to centroid
Regina Obe [Sat, 28 May 2011 23:32:41 +0000 (23:32 +0000)]
Get rid of deprecated call to centroid

git-svn-id: http://svn.osgeo.org/postgis/trunk@7283 b70326c6-7e19-0410-871a-916f4a2858ee

14 years agofix for #996 also had to revise least and greatest helper functions to deal with...
Regina Obe [Sat, 28 May 2011 15:07:19 +0000 (15:07 +0000)]
fix for #996 also had to revise least and greatest helper functions to deal with to and froms that can't be converted to integers. Also added missing indexes to base tables (helps the planner with inherited tables though it never really uses those indexes)

git-svn-id: http://svn.osgeo.org/postgis/trunk@7282 b70326c6-7e19-0410-871a-916f4a2858ee

14 years agofill in some missing licensing headers and svn tags
Regina Obe [Sat, 28 May 2011 13:29:50 +0000 (13:29 +0000)]
fill in some missing licensing headers and svn tags

git-svn-id: http://svn.osgeo.org/postgis/trunk@7281 b70326c6-7e19-0410-871a-916f4a2858ee

14 years agoIt's "spatialreference.org", not "spatialreferencing.org" (srid=900913)
Sandro Santilli [Sat, 28 May 2011 11:46:13 +0000 (11:46 +0000)]
It's "spatialreference.org", not "spatialreferencing.org" (srid=900913)

git-svn-id: http://svn.osgeo.org/postgis/trunk@7280 b70326c6-7e19-0410-871a-916f4a2858ee

14 years agorevise readme wording so those unix users who aren't on linux won't be quite as offended
Regina Obe [Sat, 28 May 2011 11:24:34 +0000 (11:24 +0000)]
revise readme wording so those unix users who aren't on linux won't be quite as offended

git-svn-id: http://svn.osgeo.org/postgis/trunk@7279 b70326c6-7e19-0410-871a-916f4a2858ee

14 years agofix for #995 handling lower level fips. Also many fixes for #908 sh tiger loader...
Regina Obe [Sat, 28 May 2011 11:18:24 +0000 (11:18 +0000)]
fix for #995 handling lower level fips.  Also many fixes for #908 sh tiger loader profile.  Testing now and will close out if confirmed its fixed.  Also put in a note in the .sh and .bat that for PostgreSQL 9.1+ have to install fuzzystrmatch with the CREATE EXTENSION syntax

git-svn-id: http://svn.osgeo.org/postgis/trunk@7278 b70326c6-7e19-0410-871a-916f4a2858ee

14 years ago- remove OUT parameters on those functions that only return a single value.
Bborie Park [Fri, 27 May 2011 23:35:07 +0000 (23:35 +0000)]
- remove OUT parameters on those functions that only return a single value.
- updated regression tests that made use of those functions returning single values with OUT parameters

git-svn-id: http://svn.osgeo.org/postgis/trunk@7277 b70326c6-7e19-0410-871a-916f4a2858ee

14 years agoAdded default values for function arguments of ST_Reclass
Bborie Park [Fri, 27 May 2011 14:42:23 +0000 (14:42 +0000)]
Added default values for function arguments of ST_Reclass

git-svn-id: http://svn.osgeo.org/postgis/trunk@7276 b70326c6-7e19-0410-871a-916f4a2858ee

14 years agoST_AddEdgeModFace is complete...
Sandro Santilli [Fri, 27 May 2011 14:01:24 +0000 (14:01 +0000)]
ST_AddEdgeModFace is complete...

git-svn-id: http://svn.osgeo.org/postgis/trunk@7275 b70326c6-7e19-0410-871a-916f4a2858ee

14 years agoDocument ST_AddEdgeModFace, tweak documentation of ST_AddEdgeNewFaces [RT-SIGTA]
Sandro Santilli [Fri, 27 May 2011 14:01:19 +0000 (14:01 +0000)]
Document ST_AddEdgeModFace, tweak documentation of ST_AddEdgeNewFaces [RT-SIGTA]

git-svn-id: http://svn.osgeo.org/postgis/trunk@7274 b70326c6-7e19-0410-871a-916f4a2858ee

14 years agoImplement topology.ST_AddEdgeModFace. Includes regress test. [RT-SIGTA]
Sandro Santilli [Fri, 27 May 2011 14:01:14 +0000 (14:01 +0000)]
Implement topology.ST_AddEdgeModFace. Includes regress test. [RT-SIGTA]

git-svn-id: http://svn.osgeo.org/postgis/trunk@7273 b70326c6-7e19-0410-871a-916f4a2858ee

14 years agofix indentation
Regina Obe [Fri, 27 May 2011 12:15:39 +0000 (12:15 +0000)]
fix indentation

git-svn-id: http://svn.osgeo.org/postgis/trunk@7272 b70326c6-7e19-0410-871a-916f4a2858ee

14 years agoSimplify face registration by the end of ST_AddEdgeNewFaces [RT-SIGTA]
Sandro Santilli [Fri, 27 May 2011 10:18:38 +0000 (10:18 +0000)]
Simplify face registration by the end of ST_AddEdgeNewFaces [RT-SIGTA]

git-svn-id: http://svn.osgeo.org/postgis/trunk@7271 b70326c6-7e19-0410-871a-916f4a2858ee

14 years agoST_AddEdgeNewFaces: another test splitting a face with holes on both sides [RT-SIGTA].
Sandro Santilli [Fri, 27 May 2011 09:51:18 +0000 (09:51 +0000)]
ST_AddEdgeNewFaces: another test splitting a face with holes on both sides [RT-SIGTA].

git-svn-id: http://svn.osgeo.org/postgis/trunk@7270 b70326c6-7e19-0410-871a-916f4a2858ee

14 years agotopology.ST_AddEdgeNewFaces: do not needlessly replace face of holes found in a face...
Sandro Santilli [Fri, 27 May 2011 09:34:18 +0000 (09:34 +0000)]
topology.ST_AddEdgeNewFaces: do not needlessly replace face of holes found in a face splitted by the newly added edge. Regress test it. [RT-SIGTA].

git-svn-id: http://svn.osgeo.org/postgis/trunk@7269 b70326c6-7e19-0410-871a-916f4a2858ee

14 years agoAdd an optional force_new parameter to topology.ST_AddFace to force creation of a...
Sandro Santilli [Fri, 27 May 2011 08:34:23 +0000 (08:34 +0000)]
Add an optional force_new parameter to topology.ST_AddFace to force creation of a new face when one already exists. Regress test and document. [RT-SIGTA]

git-svn-id: http://svn.osgeo.org/postgis/trunk@7268 b70326c6-7e19-0410-871a-916f4a2858ee

14 years agofix cpp extra token warning
Sandro Santilli [Fri, 27 May 2011 08:34:13 +0000 (08:34 +0000)]
fix cpp extra token warning

git-svn-id: http://svn.osgeo.org/postgis/trunk@7267 b70326c6-7e19-0410-871a-916f4a2858ee

14 years agochange ST_ConcaveHull to use default parameters
Regina Obe [Fri, 27 May 2011 07:13:42 +0000 (07:13 +0000)]
change ST_ConcaveHull to use default parameters

git-svn-id: http://svn.osgeo.org/postgis/trunk@7266 b70326c6-7e19-0410-871a-916f4a2858ee

14 years agopreliminary documentation for ST_Count
Regina Obe [Fri, 27 May 2011 06:46:05 +0000 (06:46 +0000)]
preliminary documentation for ST_Count

git-svn-id: http://svn.osgeo.org/postgis/trunk@7265 b70326c6-7e19-0410-871a-916f4a2858ee

14 years ago- Added default values for function parameters of ST_ValueCount and ST_ValuePercent...
Bborie Park [Fri, 27 May 2011 00:02:59 +0000 (00:02 +0000)]
- Added default values for function parameters of ST_ValueCount and ST_ValuePercent.  Removed duplicative functions of the same.
- Tweaked the regression tests for ST_ValueCount and ST_ValuePercent as one question for each function type was too ambiguous.

git-svn-id: http://svn.osgeo.org/postgis/trunk@7264 b70326c6-7e19-0410-871a-916f4a2858ee

14 years agoAdded default parameter values for ST_Quantile functions
Bborie Park [Thu, 26 May 2011 23:32:20 +0000 (23:32 +0000)]
Added default parameter values for ST_Quantile functions

git-svn-id: http://svn.osgeo.org/postgis/trunk@7263 b70326c6-7e19-0410-871a-916f4a2858ee

14 years agoAdded default values for function parameters of ST_Histogram and removed duplicative...
Bborie Park [Thu, 26 May 2011 23:11:09 +0000 (23:11 +0000)]
Added default values for function parameters of ST_Histogram and removed duplicative functions.

git-svn-id: http://svn.osgeo.org/postgis/trunk@7262 b70326c6-7e19-0410-871a-916f4a2858ee

14 years agoForgot to delete the commented out functions of ST_SummaryStats and dependants from...
Bborie Park [Thu, 26 May 2011 22:50:54 +0000 (22:50 +0000)]
Forgot to delete the commented out functions of ST_SummaryStats and dependants from r7260

git-svn-id: http://svn.osgeo.org/postgis/trunk@7261 b70326c6-7e19-0410-871a-916f4a2858ee

14 years agoAdded default values for function parameters of ST_SummaryStats, ST_Count, ST_Sum...
Bborie Park [Thu, 26 May 2011 22:40:05 +0000 (22:40 +0000)]
Added default values for function parameters of ST_SummaryStats, ST_Count, ST_Sum, ST_Mean, ST_StdDev and ST_MinMax.

git-svn-id: http://svn.osgeo.org/postgis/trunk@7260 b70326c6-7e19-0410-871a-916f4a2858ee

14 years agoAdded default parameter for ST_Band and reduced function count by 1.
Bborie Park [Thu, 26 May 2011 21:35:33 +0000 (21:35 +0000)]
Added default parameter for ST_Band and reduced function count by 1.

Added additional regression tests for ST_Band.

git-svn-id: http://svn.osgeo.org/postgis/trunk@7259 b70326c6-7e19-0410-871a-916f4a2858ee

14 years agoChanged to STABLE from IMMUTABLE for all functions that operate on a coverage using...
Bborie Park [Thu, 26 May 2011 21:23:52 +0000 (21:23 +0000)]
Changed to STABLE from IMMUTABLE for all functions that operate on a coverage using the function parameters "rastertable" and "rastercolumn"

git-svn-id: http://svn.osgeo.org/postgis/trunk@7258 b70326c6-7e19-0410-871a-916f4a2858ee

14 years agochanged name "proportion" to "percent" for ST_Histogram to stay consistent with ST_Va...
Bborie Park [Thu, 26 May 2011 20:09:50 +0000 (20:09 +0000)]
changed name "proportion" to "percent" for ST_Histogram to stay consistent with ST_ValuePercent

git-svn-id: http://svn.osgeo.org/postgis/trunk@7257 b70326c6-7e19-0410-871a-916f4a2858ee

14 years agoAddition of ST_ValuePercent, sibling of ST_ValueCount. This function provides the...
Bborie Park [Thu, 26 May 2011 20:04:12 +0000 (20:04 +0000)]
Addition of ST_ValuePercent, sibling of ST_ValueCount.  This function provides the ability to determine the percentage of a raster's band that is of a user-specified value.

Assocated ticket is #990

Also specified STRICT for functions with "searchvalue" (the singular) argument.

git-svn-id: http://svn.osgeo.org/postgis/trunk@7256 b70326c6-7e19-0410-871a-916f4a2858ee

14 years agoChanged the datatype for "count" from integer to bigint. This should allow the ...
Bborie Park [Thu, 26 May 2011 15:43:26 +0000 (15:43 +0000)]
Changed the datatype for "count" from integer to bigint.  This should allow the "count" return value to handle large numbers coming from the various coverage functions.

git-svn-id: http://svn.osgeo.org/postgis/trunk@7255 b70326c6-7e19-0410-871a-916f4a2858ee

14 years ago#949 Add all E and F deprecated functions to uninstall_legacy.sql.in.c and minor...
Regina Obe [Thu, 26 May 2011 14:01:17 +0000 (14:01 +0000)]
#949 Add all E and F deprecated functions to uninstall_legacy.sql.in.c and minor sorting and casing cleanup.

git-svn-id: http://svn.osgeo.org/postgis/trunk@7254 b70326c6-7e19-0410-871a-916f4a2858ee

14 years agoError handling refinements in topology.ST_AddEdgeNewFaces (#988)
Sandro Santilli [Thu, 26 May 2011 07:26:56 +0000 (07:26 +0000)]
Error handling refinements in topology.ST_AddEdgeNewFaces (#988)

Check for given edge having two distinct vertices before getting a new
edge id from sequence, and before testing it for crossing nodes (or it'd
give a confusing error message). Refine error message about no-segment
edges to not talk about nodes. [RT-SIGTA]

git-svn-id: http://svn.osgeo.org/postgis/trunk@7253 b70326c6-7e19-0410-871a-916f4a2858ee

14 years agoAdds ST_ValueCount to count the number of times a user-provided value or all values...
Bborie Park [Thu, 26 May 2011 04:23:54 +0000 (04:23 +0000)]
Adds ST_ValueCount to count the number of times a user-provided value or all values occurs in a raster's band.

Associated ticket is #953

git-svn-id: http://svn.osgeo.org/postgis/trunk@7252 b70326c6-7e19-0410-871a-916f4a2858ee

14 years agogit-svn-id: http://svn.osgeo.org/postgis/trunk@7251 b70326c6-7e19-0410-871a-916f4a2858ee
Regina Obe [Wed, 25 May 2011 23:38:13 +0000 (23:38 +0000)]
git-svn-id: http://svn.osgeo.org/postgis/trunk@7251 b70326c6-7e19-0410-871a-916f4a2858ee

14 years agoput header on table
Regina Obe [Wed, 25 May 2011 23:37:08 +0000 (23:37 +0000)]
put header on table

git-svn-id: http://svn.osgeo.org/postgis/trunk@7250 b70326c6-7e19-0410-871a-916f4a2858ee

14 years agotry group
Regina Obe [Wed, 25 May 2011 21:09:00 +0000 (21:09 +0000)]
try group

git-svn-id: http://svn.osgeo.org/postgis/trunk@7249 b70326c6-7e19-0410-871a-916f4a2858ee

14 years ago#661 Type info of geography columns incomplete - pg_dump output wrong
Paul Ramsey [Wed, 25 May 2011 18:42:16 +0000 (18:42 +0000)]
#661 Type info of geography columns incomplete - pg_dump output wrong

git-svn-id: http://svn.osgeo.org/postgis/trunk@7248 b70326c6-7e19-0410-871a-916f4a2858ee

14 years agoAdd ST_Count and ST_Sum functions that are fronts for the count and sum values of...
Bborie Park [Wed, 25 May 2011 18:28:14 +0000 (18:28 +0000)]
Add ST_Count and ST_Sum functions that are fronts for the count and sum values of ST_SummaryStats

Associated tickets are #985 (ST_Count) and #986 (ST_Sum)

git-svn-id: http://svn.osgeo.org/postgis/trunk@7246 b70326c6-7e19-0410-871a-916f4a2858ee

14 years agogit-svn-id: http://svn.osgeo.org/postgis/trunk@7245 b70326c6-7e19-0410-871a-916f4a2858ee
Regina Obe [Wed, 25 May 2011 13:13:26 +0000 (13:13 +0000)]
git-svn-id: http://svn.osgeo.org/postgis/trunk@7245 b70326c6-7e19-0410-871a-916f4a2858ee

14 years agogit-svn-id: http://svn.osgeo.org/postgis/trunk@7244 b70326c6-7e19-0410-871a-916f4a2858ee
Regina Obe [Wed, 25 May 2011 12:49:22 +0000 (12:49 +0000)]
git-svn-id: http://svn.osgeo.org/postgis/trunk@7244 b70326c6-7e19-0410-871a-916f4a2858ee

14 years agogit-svn-id: http://svn.osgeo.org/postgis/trunk@7243 b70326c6-7e19-0410-871a-916f4a2858ee
Regina Obe [Wed, 25 May 2011 12:48:46 +0000 (12:48 +0000)]
git-svn-id: http://svn.osgeo.org/postgis/trunk@7243 b70326c6-7e19-0410-871a-916f4a2858ee

14 years agogit-svn-id: http://svn.osgeo.org/postgis/trunk@7242 b70326c6-7e19-0410-871a-916f4a2858ee
Regina Obe [Wed, 25 May 2011 12:35:02 +0000 (12:35 +0000)]
git-svn-id: http://svn.osgeo.org/postgis/trunk@7242 b70326c6-7e19-0410-871a-916f4a2858ee

14 years agorevert
Regina Obe [Wed, 25 May 2011 12:29:01 +0000 (12:29 +0000)]
revert

git-svn-id: http://svn.osgeo.org/postgis/trunk@7241 b70326c6-7e19-0410-871a-916f4a2858ee

14 years agodefine style for methodsynopsis
Regina Obe [Wed, 25 May 2011 12:13:55 +0000 (12:13 +0000)]
define style for methodsynopsis

git-svn-id: http://svn.osgeo.org/postgis/trunk@7240 b70326c6-7e19-0410-871a-916f4a2858ee

14 years agomissed a spot
Regina Obe [Tue, 24 May 2011 18:53:01 +0000 (18:53 +0000)]
missed a spot

git-svn-id: http://svn.osgeo.org/postgis/trunk@7239 b70326c6-7e19-0410-871a-916f4a2858ee

14 years agoexperiment with methodsynopsis evidentally seems to support default parameters and...
Regina Obe [Tue, 24 May 2011 18:50:35 +0000 (18:50 +0000)]
experiment with methodsynopsis evidentally seems to support default parameters and conditional args, we need to move from funcsynopsis (designed for C) to methodsynopsis.  This is what PHP uses -- https://doc.php.net/php/dochowto/chapter-skeletons.php

git-svn-id: http://svn.osgeo.org/postgis/trunk@7238 b70326c6-7e19-0410-871a-916f4a2858ee

14 years agoStop using astext legacy function in raster tests -- make check finally succeeds...
Sandro Santilli [Tue, 24 May 2011 15:21:46 +0000 (15:21 +0000)]
Stop using astext legacy function in raster tests -- make check finally succeeds with both raster and topology enabled

git-svn-id: http://svn.osgeo.org/postgis/trunk@7237 b70326c6-7e19-0410-871a-916f4a2858ee

14 years agoAllow dumping universal face edges with ST_GetFaceEdges. Do it in the correct order...
Sandro Santilli [Tue, 24 May 2011 14:47:00 +0000 (14:47 +0000)]
Allow dumping universal face edges with ST_GetFaceEdges. Do it in the correct order. Fixes bug #984. [RT-SIGTA]

git-svn-id: http://svn.osgeo.org/postgis/trunk@7236 b70326c6-7e19-0410-871a-916f4a2858ee

14 years ago- Added test testgdalraster.in which properly tests the output of ST_AsGDALRaster...
Bborie Park [Tue, 24 May 2011 14:27:08 +0000 (14:27 +0000)]
- Added test testgdalraster.in which properly tests the output of ST_AsGDALRaster.  This test makes use of rtgdalraster.py found in raster/scripts/python, which itself requires psycopg2.
- Refactored rt_asgdalraster.sql, rt_astiff.sql, rt_asjpeg.sql and rt_aspng.sql to no longer attempt to validate the output of the respective functions with an MD5 checksum but rather be a test of the functions' behaviors.

git-svn-id: http://svn.osgeo.org/postgis/trunk@7235 b70326c6-7e19-0410-871a-916f4a2858ee

14 years agoST_GetFaceGeometry: throw SQL/MM exception when asked for the Universal Face geometry...
Sandro Santilli [Tue, 24 May 2011 13:49:18 +0000 (13:49 +0000)]
ST_GetFaceGeometry: throw SQL/MM exception when asked for the Universal Face geometry. Fixes bug #973 [RT-SIGTA]

git-svn-id: http://svn.osgeo.org/postgis/trunk@7234 b70326c6-7e19-0410-871a-916f4a2858ee

14 years agotopology.ValidateTopology: do not construct the geometry of universal face, it's...
Sandro Santilli [Tue, 24 May 2011 13:47:55 +0000 (13:47 +0000)]
topology.ValidateTopology: do not construct the geometry of universal face, it's not used anyway. Closes bug #977. [RT-SIGTA]

git-svn-id: http://svn.osgeo.org/postgis/trunk@7233 b70326c6-7e19-0410-871a-916f4a2858ee

14 years agoST_AddEdgeNewFaces: don't get fooled by empty segments when computing azimuts [RT...
Sandro Santilli [Tue, 24 May 2011 13:15:01 +0000 (13:15 +0000)]
ST_AddEdgeNewFaces: don't get fooled by empty segments when computing azimuts [RT-SIGTA]

git-svn-id: http://svn.osgeo.org/postgis/trunk@7232 b70326c6-7e19-0410-871a-916f4a2858ee

14 years agoFix a bogus test for ST_AddEdgeNewFaces (was missing to check informations about...
Sandro Santilli [Tue, 24 May 2011 12:14:14 +0000 (12:14 +0000)]
Fix a bogus test for ST_AddEdgeNewFaces (was missing to check informations about the newly added edge) -- [RT-SIGTA]

git-svn-id: http://svn.osgeo.org/postgis/trunk@7231 b70326c6-7e19-0410-871a-916f4a2858ee

14 years agoAdd another (successful) test for ST_AddEdgeNewFaces when creating a new face in...
Sandro Santilli [Tue, 24 May 2011 10:45:40 +0000 (10:45 +0000)]
Add another (successful) test for ST_AddEdgeNewFaces when creating a new face in the universal face by closing a ring around an existing non-isolated edge [RT-SIGTA].

git-svn-id: http://svn.osgeo.org/postgis/trunk@7230 b70326c6-7e19-0410-871a-916f4a2858ee

14 years agoAdd TODO item and SQL/MM compatibility note in ST_ChangeEdgeGeom
Sandro Santilli [Tue, 24 May 2011 09:22:12 +0000 (09:22 +0000)]
Add TODO item and SQL/MM compatibility note in ST_ChangeEdgeGeom

git-svn-id: http://svn.osgeo.org/postgis/trunk@7229 b70326c6-7e19-0410-871a-916f4a2858ee

14 years agoTest ST_ChangeEdgeGeom with edge crossing
Sandro Santilli [Tue, 24 May 2011 09:13:39 +0000 (09:13 +0000)]
Test ST_ChangeEdgeGeom with edge crossing

git-svn-id: http://svn.osgeo.org/postgis/trunk@7228 b70326c6-7e19-0410-871a-916f4a2858ee

14 years agoST_ChangeEdgeGeom: check existence of given edge, reduce scans used to check start...
Sandro Santilli [Tue, 24 May 2011 08:45:55 +0000 (08:45 +0000)]
ST_ChangeEdgeGeom: check existence of given edge, reduce scans used to check start/end point and simplify the code, regress test the fix. Fixes bug #979.

git-svn-id: http://svn.osgeo.org/postgis/trunk@7227 b70326c6-7e19-0410-871a-916f4a2858ee

14 years agoNo functional change: tabs to 2 spaces.
Sandro Santilli [Tue, 24 May 2011 08:22:54 +0000 (08:22 +0000)]
No functional change: tabs to 2 spaces.

git-svn-id: http://svn.osgeo.org/postgis/trunk@7226 b70326c6-7e19-0410-871a-916f4a2858ee

14 years agoMove tests for ST_ChangeEdgeGeom into a dedicated file. Prepared for ticket #979...
Sandro Santilli [Tue, 24 May 2011 08:13:46 +0000 (08:13 +0000)]
Move tests for ST_ChangeEdgeGeom into a dedicated file. Prepared for ticket #979. [RT-SIGTA].

git-svn-id: http://svn.osgeo.org/postgis/trunk@7225 b70326c6-7e19-0410-871a-916f4a2858ee

14 years agoTest ST_GetFaceGeometry behavior when given face_id 0 (Universal Face). See ticket...
Sandro Santilli [Tue, 24 May 2011 07:54:45 +0000 (07:54 +0000)]
Test ST_GetFaceGeometry behavior when given face_id 0 (Universal Face). See ticket #973.

git-svn-id: http://svn.osgeo.org/postgis/trunk@7224 b70326c6-7e19-0410-871a-916f4a2858ee

14 years agoST_AddIsoEdge: tell that a node is isolated by only looking at containing_face rather...
Sandro Santilli [Tue, 24 May 2011 07:04:43 +0000 (07:04 +0000)]
ST_AddIsoEdge: tell that a node is isolated by only looking at containing_face rather than recomputing it. Closes ticket #978. [RT-SIGTA]

git-svn-id: http://svn.osgeo.org/postgis/trunk@7223 b70326c6-7e19-0410-871a-916f4a2858ee