Bborie Park [Fri, 10 Jun 2011 15:19:03 +0000 (15:19 +0000)]
Rewrote ST_BandMetaData to use a C function instead of sequential calls for the metadata of a raster's band in plpgsql. Also added regression tests for ST_MetaData and ST_BandMetaData due to C functions.
Bborie Park [Thu, 9 Jun 2011 18:55:35 +0000 (18:55 +0000)]
Replaced the parameter "srs" in ST_AsGDALRaster with "srid" so as to match that of ST_Transform and other functions that deals with spatial reference systems. In doing so, this eliminates the user function ST_srtext and just has a hidden _ST_srtext function for use by the underlying C functions. Another nice benefit is that I was able to reduce the number of user-facing functions.
Bborie Park [Wed, 8 Jun 2011 21:10:11 +0000 (21:10 +0000)]
Rewrote how the standard/sample deviation is computed in ST_SummaryStats for coverage tables. It now extends the existing use of a single-pass standard deviation calculation to be able to do the calculation for a coverage table.
Bborie Park [Wed, 8 Jun 2011 00:00:51 +0000 (00:00 +0000)]
fixed ST_SummaryStats for coverage tables where the sum of all tiles was not being computed.
Associated ticket #1005
Also added shortcuts to ST_Count for when parameter "exclude_nodata_value" is FALSE, just compute the count based upon the raster's dimensions. Performance difference between the normal route and the shortcut is negligible for small rasters but noticable when run on large rasters and coverage tables
Bborie Park [Tue, 7 Jun 2011 22:59:23 +0000 (22:59 +0000)]
Added support for coverage tables to ST_Histogram. This entailed adding the ability to explicitly specify the min and max values in the underlying C function rt_band_get_histogram. The min and max parameters should ONLY be used by the established coverage table handling ST_Histogram functions as the returned percent element of the histogram type is changed from returning the percentage to returning the sum of counts for that histogram.
Bborie Park [Tue, 7 Jun 2011 18:21:34 +0000 (18:21 +0000)]
Add ST_Transform function that achieves the primary purpose of reprojecting a raster to a new projection system. This makes use of the GDAL Warp API function GDALAutoCreateWarpedVRT(). In the future, the underlying C function is expected to be refactored to support skewing and pixel scaling at the same time the raster is reprojected.
Really minor changes to rt_pg/rt_pg.c adding initilization values to variables for eliminating compile warnings in Windows (thanks Pierre).
Fixed variable "status" in rt_raster_from_gdal_dataset() of rt_core/rt_api.c
Bborie Park [Sun, 5 Jun 2011 20:52:48 +0000 (20:52 +0000)]
- added additional function parameters "bandNums" and "count" to rt_raster_to_gdal_mem so that the GDAL dataset created only contains those bands specified
- any calls to rt_raster_to_gdal_mem function was refactored for the new function parameters
- refactored rt_raster_dump_as_wktpolygons to make use of rt_raster_to_gdal_mem so as to reduce duplicate code and improve cleanliness
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.
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.
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.
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
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
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.
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)
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
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
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]
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.
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.
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.
projects / postgis / log