Mark Leslie [Thu, 2 Aug 2007 19:58:46 +0000 (19:58 +0000)]
Added PreparedGeometry and caching support to the intersects function in the jts connector. Created wrapper functions for the PreparedGeometry functionality.
Mark Cave-Ayland [Thu, 12 Jul 2007 20:33:23 +0000 (20:33 +0000)]
Add missing methods to the PROJ.4 cache memory context to prevent a backend crash caused by a NULL pointer dereference when PostgreSQL is trying to clean up memory contexts. Per report from Tom Lane.
Stephen Frost [Mon, 9 Jul 2007 02:20:00 +0000 (02:20 +0000)]
- Added print-print function for norm_addy type (norm_addy -> varchar)
- Restructured geocode(), accept address in parsed norm_addy form
as well as unparsed varchar form. Return norm_addy type instead of
varchar (use pprint_addy() if you want a varchar result instead)
Stephen Frost [Sun, 8 Jul 2007 21:56:47 +0000 (21:56 +0000)]
- City names are 90 characters (this matters more than you might
think because it affects the types returned from the various
calls and if they don't match subsequent geocode() queries in
the same session may complain about the planned record type not
matching across calls)
Stephen Frost [Tue, 3 Jul 2007 21:32:50 +0000 (21:32 +0000)]
Add in initial import scripts for importing the TIGER/Line
data into a PostGIS system. Could probably be improved to
accept more arguments/etc and require less direct script
modification to make it work. Also, not sure the polygons
are done perfectly yet. :/
Stephen Frost [Tue, 3 Jul 2007 21:30:34 +0000 (21:30 +0000)]
Add in broken out/updated normalize/geocode functions
- create_geocode.sql:
Main creation script for pulling in all the other
.sql files to create all the functions and whatnot
- normalize/
Normalization routines, includes mapping 'North' -> 'N',
'Virginia' -> 'VA', etc, etc.
- geocode/
Actual geocoding routines to find the point geometry of the
address. Includes interpolation across the linestring found
for the location (perhaps not the best), and fallbacks to
zip-code and city, state matches using the associated lookup
tables for those. Also currently returns a set rather than
a cursor, that's up for some debate but the cursor makes it
difficult to do things like fallback, imv. Especially since
references to it from another pl/pgsql function require it to
be a specific record type across multiple calls. That's
currently a problem. :/
Stephen Frost [Tue, 3 Jul 2007 21:19:54 +0000 (21:19 +0000)]
tables/- New scripts for roads_local/tiger_geocode_roads, clean up lookup_tables
- roads_local.sql:
Script to create the road_local table from the completechain
table which is created by ogr2ogr. Mainly handles type
conversions. Also creates the tlid, cfcc, and geometry
indexes.
- tiger_geocode_roads.sql:
Script to create the tiger_geocode_roads table which breaks
down the roads_local to just the street name, etc, much
smaller than roads_local but has the pointers to get back
to the full roads_local for address number matching, etc.
Also creates the appropriate indexes using soundex().
- lookup_tables.sql:
- Add 'drop if exists' to make script easily re-runnable
- Add primary keys, good thing to have, and creates indexes
- Add st_code (TIGER/Line state code) to state_lookup
- Remove dup in street_type_lookup
- Add in building of:
place_lookup
county_lookup
countysub_lookup
zip_lookup_all
zip_lookup
Mark Leslie [Thu, 28 Jun 2007 22:46:08 +0000 (22:46 +0000)]
Added ST_Covers and ST_CoveredBy functions, as discussed at http://lin-ear-th-inking.blogspot.com. Added regression tests and documention for the new functions.
Mark Leslie [Thu, 28 Jun 2007 20:21:32 +0000 (20:21 +0000)]
Added a 1D rtree for polygon segment indexing, and tied the index into the point in polygon short-circuit of the contains, within, intersects and disjoint methods. Added an index cache to the comparitor methods to save index build times.
Applied Michael Fuhr's patch to use explicit text casts where required. Required for PostgreSQL 8.3 where many of the implicit casts to text have been removed.
Mark Leslie [Mon, 4 Jun 2007 23:06:28 +0000 (23:06 +0000)]
Added versions of functions with standard ST (Spatial Type) prefixes to any functions that were lacking them. Updated the regression tests to include the new functions.
Reduce 'LWGEOM_gist_joinsel called with arguments that are not column references' warning to DEBUG1; it's not really a problem, and in cases where people a lot of these types of queries, the logs get flooded with these NOTICEs. Per email from Flavio Perri.
Fixed bug #145 - RemovePoint Failure in the bugtracker. It was an off-by-one error in ptarray.c which caused the penultimate point to not be copied to the new geometry.
Fix broken docbook stylesheet search. AC_ARG_WITH only calls its contents when a --with-* option is specified, so the search would never be invoked in its current position. Moved the search into the second macro argument, so it is now invoked if no --with-xsl argument is specified, which I believe was the intended behaviour.
Mark Cave-Ayland [Thu, 31 May 2007 13:18:04 +0000 (13:18 +0000)]
Add support for the upcoming release of PostgreSQL 8.3. From PostgreSQL 8.3, the internal structure of varlena datatypes has changed and so any references to the size of the varlena and its address must use the VARSIZE and SET_VARSIZE macros. Includes a #define in pgsql_compat.h so that SET_VARSIZE still works with the older PostgreSQL versions. Passes all regression tests under PostgreSQL 8.2 and PostgreSQL 8.3. Thanks to David Techer and Michael Fuhr for additional testing.
Mark Leslie [Mon, 28 May 2007 15:34:04 +0000 (15:34 +0000)]
Added curve handling to getType, numGeometries, geometryN, dimension, exteriorRing, numInteriorRings, interiorRingN, closed (lwgeom_ogc.c) lwgeom_clone (lwgeom.c) and area. Added function ST_CurveToLine and ST_LineToCurve. Added regression tests for sql-mm geometries and related functions.
Mark Cave-Ayland [Mon, 14 May 2007 17:51:32 +0000 (17:51 +0000)]
Remove GEOS C++ API support from PostGIS HEAD; it's been broken since 1.2.0 and so we require a minimum of GEOS 2.2.0 to compile and run PostGIS. Includes alterations to autoconf to display an error message during configure if the GEOS version is incorrect. Passes all regression tests with GEOS 2.2.3 and GEOS 3.0.0rc4 using GEOS CAPI.
Mark Cave-Ayland [Fri, 26 Jan 2007 15:11:30 +0000 (15:11 +0000)]
Refine previous patch to use a different delimiter than : (!) for sed. This simplifies the Makefile and protects all the $*dir arguments from escaping issues under Win32.
projects / postgis / log