<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 TRANSITIONAL//EN">
<HTML>
<HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; CHARSET=UTF-8">
<META NAME="GENERATOR" CONTENT="GtkHTML/3.8.0">
</HEAD>
<BODY>
Hello Chris,<BR>
<BR>
I have already done what you're attempting, minus driving instructions as it wasn't a requirement, but I do have that separatele using Google Maps - <A HREF="http://www.spatialguru.net/router/">http://www.spatialguru.net/router/</A>. My solution uses the 2005fe TIGER/line files, the Perl geocoder from geocoder.us, PL/PERL, and custom PL/PGSQL functions. The flow is like this:<BR>
<BR>
1) PL/PERL function invokes geocoder with address<BR>
2) Geocoder returns EWKT<BR>
3) EWKT converted to Geometry via GeomFromEWKT<BR>
4) Geometry buffered by XXX miles<BR>
5) Spatial search for all results Intersects this ROI<BR>
<BR>
You can check it out at <A HREF="http://www.demographicsguru.com">http://www.demographicsguru.com</A>. Just click on the "By Radius" button to do you search. You must enter an address to get a direct result; otherwise the following rules apply:<BR>
<BR>
1) if zip code entered, return buffered zip centroid<BR>
2) if city and state entered, search for zip code(s) in city/state and returned buffered zip centroid<BR>
<BR>
When you get a result, click the "View Map" button to see an image of the buffered area, generated using PHP MapScript.<BR>
<BR>
If this is what you're looking for email me and I can explain it further. If you already have PostGIS and MapServer (or code for another mapping solution, i.e. Google, Yahoo, MSN) set up you could literally have this up and running in about half an hour or less.<BR>
<BR>
Regards,<BR>
<BR>
Mark Thomas<BR>
<BR>
On Mon, 2006-07-03 at 12:00 -0700, postgis-users-request@postgis.refractions.net wrote:
<BLOCKQUOTE TYPE=CITE>
<PRE>
<FONT COLOR="#000000">Send postgis-users mailing list submissions to</FONT>
<FONT COLOR="#000000"> <A HREF="mailto:postgis-users@postgis.refractions.net">postgis-users@postgis.refractions.net</A></FONT>
<FONT COLOR="#000000">To subscribe or unsubscribe via the World Wide Web, visit</FONT>
<FONT COLOR="#000000"> <A HREF="http://postgis.refractions.net/mailman/listinfo/postgis-users">http://postgis.refractions.net/mailman/listinfo/postgis-users</A></FONT>
<FONT COLOR="#000000">or, via email, send a message with subject or body 'help' to</FONT>
<FONT COLOR="#000000"> <A HREF="mailto:postgis-users-request@postgis.refractions.net">postgis-users-request@postgis.refractions.net</A></FONT>
<FONT COLOR="#000000">You can reach the person managing the list at</FONT>
<FONT COLOR="#000000"> <A HREF="mailto:postgis-users-owner@postgis.refractions.net">postgis-users-owner@postgis.refractions.net</A></FONT>
<FONT COLOR="#000000">When replying, please edit your Subject line so it is more specific</FONT>
<FONT COLOR="#000000">than "Re: Contents of postgis-users digest..."</FONT>
<FONT COLOR="#000000">Today's Topics:</FONT>
<FONT COLOR="#000000"> 1. 1.1.3 compilation problem (Stefano B.)</FONT>
<FONT COLOR="#000000"> 2. AW: [postgis-users] Linear Referencing: Create Measure</FONT>
<FONT COLOR="#000000"> (D?ster Horst)</FONT>
<FONT COLOR="#000000"> 3. RE: 1.1.3 compilation problem (Mark Cave-Ayland)</FONT>
<FONT COLOR="#000000"> 4. Raster images (Warren Noll)</FONT>
<FONT COLOR="#000000"> 5. Re: Raster images (Stephen Woodbridge)</FONT>
<FONT COLOR="#000000"> 6. bring PostGIS into the raster world (Warren Noll)</FONT>
<FONT COLOR="#000000">----------------------------------------------------------------------</FONT>
<FONT COLOR="#000000">Message: 1</FONT>
<FONT COLOR="#000000">Date: Mon, 3 Jul 2006 09:09:29 +0200</FONT>
<FONT COLOR="#000000">From: "Stefano B." <<A HREF="mailto:stefano.bonnin@comai.to">stefano.bonnin@comai.to</A>></FONT>
<FONT COLOR="#000000">Subject: [postgis-users] 1.1.3 compilation problem</FONT>
<FONT COLOR="#000000">To: "PostGIS Users Discussion" <<A HREF="mailto:postgis-users@postgis.refractions.net">postgis-users@postgis.refractions.net</A>></FONT>
<FONT COLOR="#000000">Message-ID: <095b01c69e6f$a0a56470$0501a8c0@comai04></FONT>
<FONT COLOR="#000000">Content-Type: text/plain; charset="iso-8859-1"</FONT>
<FONT COLOR="#000000">Hi, when I compile postgis 1.1.3 on my freebsd 5.3 os I get the following:</FONT>
<FONT COLOR="#000000">checking for gcc... gcc</FONT>
<FONT COLOR="#000000">checking for C compiler default output file name... a.out</FONT>
<FONT COLOR="#000000">checking whether the C compiler works... yes</FONT>
<FONT COLOR="#000000">checking whether we are cross compiling... no</FONT>
<FONT COLOR="#000000">checking for suffix of executables...</FONT>
<FONT COLOR="#000000">checking for suffix of object files... o</FONT>
<FONT COLOR="#000000">checking whether we are using the GNU C compiler... yes</FONT>
<FONT COLOR="#000000">checking whether gcc accepts -g... yes</FONT>
<FONT COLOR="#000000">checking for gcc option to accept ANSI C... none needed</FONT>
<FONT COLOR="#000000">checking for g++... g++</FONT>
<FONT COLOR="#000000">checking whether we are using the GNU C++ compiler... yes</FONT>
<FONT COLOR="#000000">checking whether g++ accepts -g... yes</FONT>
<FONT COLOR="#000000">checking whether ln -s works... yes</FONT>
<FONT COLOR="#000000">checking for iconv_open in -liconv... no</FONT>
<FONT COLOR="#000000">checking for libiconv_open in -liconv... no</FONT>
<FONT COLOR="#000000">checking for iconv_open in -lc... no</FONT>
<FONT COLOR="#000000">checking how to run the C preprocessor... gcc -E</FONT>
<FONT COLOR="#000000">checking for egrep... grep -E</FONT>
<FONT COLOR="#000000">checking for ANSI C header files... yes</FONT>
<FONT COLOR="#000000">checking for sys/types.h... yes</FONT>
<FONT COLOR="#000000">checking for sys/stat.h... yes</FONT>
<FONT COLOR="#000000">checking for stdlib.h... yes</FONT>
<FONT COLOR="#000000">checking for string.h... yes</FONT>
<FONT COLOR="#000000">checking for memory.h... yes</FONT>
<FONT COLOR="#000000">checking for strings.h... yes</FONT>
<FONT COLOR="#000000">checking for inttypes.h... yes</FONT>
<FONT COLOR="#000000">checking for stdint.h... yes</FONT>
<FONT COLOR="#000000">checking for unistd.h... yes</FONT>
<FONT COLOR="#000000">checking iconv.h usability... no</FONT>
<FONT COLOR="#000000">checking iconv.h presence... no</FONT>
<FONT COLOR="#000000">checking for iconv.h... no</FONT>
<FONT COLOR="#000000">checking build system type... i386-unknown-freebsd5.3</FONT>
<FONT COLOR="#000000">checking host system type... i386-unknown-freebsd5.3</FONT>
<FONT COLOR="#000000">checking for geos-config... /usr/local/bin/geos-config</FONT>
<FONT COLOR="#000000">checking for proj... /usr/local/bin/proj</FONT>
<FONT COLOR="#000000">checking for flex... /usr/bin/flex</FONT>
<FONT COLOR="#000000">checking for dllwrap... no</FONT>
<FONT COLOR="#000000">checking for dlltool... no</FONT>
<FONT COLOR="#000000">checking for bison... bison -y</FONT>
<FONT COLOR="#000000">checking for perl... /usr/bin/perl</FONT>
<FONT COLOR="#000000">checking for xsltproc... no</FONT>
<FONT COLOR="#000000">checking for pdfxmltex... no</FONT>
<FONT COLOR="#000000">checking for db2pdf... no</FONT>
<FONT COLOR="#000000">checking for jw... no</FONT>
<FONT COLOR="#000000">checking which template to use... freebsd</FONT>
<FONT COLOR="#000000">configure: creating ./config.status</FONT>
<FONT COLOR="#000000">config.status: creating Makefile.config</FONT>
<FONT COLOR="#000000">config.status: creating config.h</FONT>
<FONT COLOR="#000000">config.status: config.h is unchanged</FONT>
<FONT COLOR="#000000"> SUMMARY</FONT>
<FONT COLOR="#000000"> -------------------------------------------------------</FONT>
<FONT COLOR="#000000"> HOST_OS: freebsd5.3</FONT>
<FONT COLOR="#000000"> PGSQL: /usr/local/pgsql8.1/bin/pg_config</FONT>
<FONT COLOR="#000000"> GEOS: /usr/local/bin/geos-config (with C-API)</FONT>
<FONT COLOR="#000000"> (ldflags: -L/usr/local/lib)</FONT>
<FONT COLOR="#000000"> PROJ: prefix=/usr/local libdir=/usr/local/lib</FONT>
<FONT COLOR="#000000"> ICONV: 0</FONT>
<FONT COLOR="#000000"> PORTNAME: freebsd</FONT>
<FONT COLOR="#000000"> PREFIX: /usr/local/pgsql8.1</FONT>
<FONT COLOR="#000000"> EPREFIX: ${prefix}</FONT>
<FONT COLOR="#000000"> DOC: /usr/local/pgsql8.1/doc/contrib</FONT>
<FONT COLOR="#000000"> DATA: /usr/local/pgsql8.1/share/contrib</FONT>
<FONT COLOR="#000000"> MAN: /usr/local/pgsql8.1/man</FONT>
<FONT COLOR="#000000"> BIN: /usr/local/pgsql8.1/bin</FONT>
<FONT COLOR="#000000"> EXT: /usr/local/pgsql8.1/lib (\$$libdir)</FONT>
<FONT COLOR="#000000"> -------------------------------------------------------</FONT>
<FONT COLOR="#000000">gmake -C lwgeom</FONT>
<FONT COLOR="#000000">gmake[1]: Entering directory `/usr/src/smit/postgis-1.1.3/lwgeom'</FONT>
<FONT COLOR="#000000">bison -y -vd -p lwg_parse_yy wktparse.y</FONT>
<FONT COLOR="#000000">wktparse.y:40.14: parse error, unexpected ":", expecting ";" or "|"</FONT>
<FONT COLOR="#000000">wktparse.y:58.20-32: $3 of `geometry' has no declared type</FONT>
<FONT COLOR="#000000">wktparse.y:61.6-19: $1 of `geometry' has no declared type</FONT>
<FONT COLOR="#000000">wktparse.y:145.17: parse error, unexpected ":", expecting ";" or "|"</FONT>
<FONT COLOR="#000000">wktparse.y:232.14-31: $1 of `geom_multilinestring' has no declared type</FONT>
<FONT COLOR="#000000">wktparse.y:232.14-34: $2 of `geom_multilinestring' has no declared type</FONT>
<FONT COLOR="#000000">wktparse.y:235.20-37: $1 of `geom_multilinestring' has no declared type</FONT>
<FONT COLOR="#000000">wktparse.y:235.20-40: $2 of `geom_multilinestring' has no declared type</FONT>
<FONT COLOR="#000000">wktparse.y:235.20-43: $3 of `geom_multilinestring' has no declared type</FONT>
<FONT COLOR="#000000">wktparse.y:238.26-43: $1 of `geom_multilinestring' has no declared type</FONT>
<FONT COLOR="#000000">wktparse.y:238.26-46: $2 of `geom_multilinestring' has no declared type</FONT>
<FONT COLOR="#000000">wktparse.y:238.26-49: $3 of `geom_multilinestring' has no declared type</FONT>
<FONT COLOR="#000000">wktparse.y:238.26-52: $4 of `geom_multilinestring' has no declared type</FONT>
<FONT COLOR="#000000">gmake[1]: *** [wktparse.tab.c] Error 1</FONT>
<FONT COLOR="#000000">gmake[1]: Leaving directory `/usr/src/smit/postgis-1.1.3/lwgeom'</FONT>
<FONT COLOR="#000000">gmake: *** [liblwgeom] Error 2</FONT>
<FONT COLOR="#000000">gmake -C lwgeom</FONT>
<FONT COLOR="#000000">gmake[1]: Entering directory `/usr/src/smit/postgis-1.1.3/lwgeom'</FONT>
<FONT COLOR="#000000">bison -y -vd -p lwg_parse_yy wktparse.y</FONT>
<FONT COLOR="#000000">wktparse.y:40.14: parse error, unexpected ":", expecting ";" or "|"</FONT>
<FONT COLOR="#000000">wktparse.y:58.20-32: $3 of `geometry' has no declared type</FONT>
<FONT COLOR="#000000">wktparse.y:61.6-19: $1 of `geometry' has no declared type</FONT>
<FONT COLOR="#000000">wktparse.y:145.17: parse error, unexpected ":", expecting ";" or "|"</FONT>
<FONT COLOR="#000000">wktparse.y:232.14-31: $1 of `geom_multilinestring' has no declared type</FONT>
<FONT COLOR="#000000">wktparse.y:232.14-34: $2 of `geom_multilinestring' has no declared type</FONT>
<FONT COLOR="#000000">wktparse.y:235.20-37: $1 of `geom_multilinestring' has no declared type</FONT>
<FONT COLOR="#000000">wktparse.y:235.20-40: $2 of `geom_multilinestring' has no declared type</FONT>
<FONT COLOR="#000000">wktparse.y:235.20-43: $3 of `geom_multilinestring' has no declared type</FONT>
<FONT COLOR="#000000">wktparse.y:238.26-43: $1 of `geom_multilinestring' has no declared type</FONT>
<FONT COLOR="#000000">wktparse.y:238.26-46: $2 of `geom_multilinestring' has no declared type</FONT>
<FONT COLOR="#000000">wktparse.y:238.26-49: $3 of `geom_multilinestring' has no declared type</FONT>
<FONT COLOR="#000000">wktparse.y:238.26-52: $4 of `geom_multilinestring' has no declared type</FONT>
<FONT COLOR="#000000">gmake[1]: *** [wktparse.tab.c] Error 1</FONT>
<FONT COLOR="#000000">gmake[1]: Leaving directory `/usr/src/smit/postgis-1.1.3/lwgeom'</FONT>
<FONT COLOR="#000000">gmake: *** [liblwgeom] Error 2</FONT>
<FONT COLOR="#000000">I have compiled with:</FONT>
<FONT COLOR="#000000">./configure --with-pgsql=/usr/local/pgsql8.1/bin/pg_config --with-geos --with-proj</FONT>
<FONT COLOR="#000000">gmake</FONT>
<FONT COLOR="#000000">thanks in advance</FONT>
<FONT COLOR="#000000">Stefano</FONT>
<FONT COLOR="#000000">-------------- next part --------------</FONT>
<FONT COLOR="#000000">An HTML attachment was scrubbed...</FONT>
<FONT COLOR="#000000">URL: <A HREF="http://lists.refractions.net/pipermail/postgis-users/attachments/20060703/5fb0a4d1/attachment-0001.html">http://lists.refractions.net/pipermail/postgis-users/attachments/20060703/5fb0a4d1/attachment-0001.html</A></FONT>
<FONT COLOR="#000000">------------------------------</FONT>
<FONT COLOR="#000000">Message: 2</FONT>
<FONT COLOR="#000000">Date: Mon, 3 Jul 2006 10:24:52 +0100 </FONT>
<FONT COLOR="#000000">From: D?ster Horst <<A HREF="mailto:Horst.Duester@bd.so.ch">Horst.Duester@bd.so.ch</A>></FONT>
<FONT COLOR="#000000">Subject: AW: [postgis-users] Linear Referencing: Create Measure</FONT>
<FONT COLOR="#000000">To: 'PostGIS Users Discussion' <<A HREF="mailto:postgis-users@postgis.refractions.net">postgis-users@postgis.refractions.net</A>></FONT>
<FONT COLOR="#000000">Message-ID:</FONT>
<FONT COLOR="#000000"> <<A HREF="mailto:5B025B1F39D6D4119F5700508BEEEC6603DE417B@srsofaioi4546.ktso.ch">5B025B1F39D6D4119F5700508BEEEC6603DE417B@srsofaioi4546.ktso.ch</A>></FONT>
<FONT COLOR="#000000">Content-Type: text/plain; charset="iso-8859-1"</FONT>
<FONT COLOR="#000000">Hallo strk</FONT>
<FONT COLOR="#000000">Thak you very much for your response. The required function should measure</FONT>
<FONT COLOR="#000000">lines or multilines. For instance I need to measure a river network. The</FONT>
<FONT COLOR="#000000">measures of the rivers are implicit predefined during the creation process</FONT>
<FONT COLOR="#000000">of the river networkdata and don't represent the real world in all cases.</FONT>
<FONT COLOR="#000000">The predefinition bases on the two attributes "from" and "to" measure. The</FONT>
<FONT COLOR="#000000">"from" value represents the lowest measure value and the "to" value highest</FONT>
<FONT COLOR="#000000">measure value of any linestring in case of our rivernetwork. The units of</FONT>
<FONT COLOR="#000000">our predefined measures is km and the datatype is float8. </FONT>
<FONT COLOR="#000000">The work to do is to interpolate the measure of every vertex point of any</FONT>
<FONT COLOR="#000000">linestring/multilinestring with respect to "from" and "to". With this</FONT>
<FONT COLOR="#000000">approach it is also possible to create measures in percent of linelength.</FONT>
<FONT COLOR="#000000">You have to set from=0 and to=100.</FONT>
<FONT COLOR="#000000">A second case could be to calculate the measures based on the length of the</FONT>
<FONT COLOR="#000000">relevant linestring from zero to length. Therefore you don't need to</FONT>
<FONT COLOR="#000000">predefine from and to.</FONT>
<FONT COLOR="#000000">In both cases you have to differ between linestrings and multilinestrings.</FONT>
<FONT COLOR="#000000">In case of continuous linestrings you can interpolate over the whole line.</FONT>
<FONT COLOR="#000000">In case of multilinestrings you have to consider possible gaps in the</FONT>
<FONT COLOR="#000000">multilinestring. I'll attach the code of a former version of Christoph</FONT>
<FONT COLOR="#000000">Spoerri's lrs_create_measure. Unfortunately the lrs_create_measures</FONT>
<FONT COLOR="#000000">functions don't work correct yet. </FONT>
<FONT COLOR="#000000">I think the function call could be:</FONT>
<FONT COLOR="#000000">line_create_measure(geometry,[float8],[float8])</FONT>
<FONT COLOR="#000000">line_create_measure(wkb_geometry,from,to) or</FONT>
<FONT COLOR="#000000">line_create_measure(wkb_geometry,0,1) would solve the first case</FONT>
<FONT COLOR="#000000">line_create_measure(wkb_geometry) would solve the second case.</FONT>
<FONT COLOR="#000000">I hope this will be a base for a further discussion.</FONT>
<FONT COLOR="#000000">With best regards</FONT>
<FONT COLOR="#000000">Dr. Horst Dster </FONT>
<FONT COLOR="#000000">GIS-Koordinator, Stv. Amtschef</FONT>
<FONT COLOR="#000000">Kanton Solothurn</FONT>
<FONT COLOR="#000000">Amt fr Geoinformation</FONT>
<FONT COLOR="#000000">Abteilung SO!GIS Koordination</FONT>
<FONT COLOR="#000000">Rtistrasse 4</FONT>
<FONT COLOR="#000000">CH-4501 Solothurn </FONT>
<FONT COLOR="#000000">Tel.: ++41 (0)32 627 25 32 </FONT>
<FONT COLOR="#000000">Fax: ++41 (0)32 627 22 14</FONT>
<FONT COLOR="#000000"><A HREF="mailto:horst.duester@bd.so.ch">horst.duester@bd.so.ch</A> </FONT>
<FONT COLOR="#000000"><A HREF="http://www.sogis.so.ch">www.sogis.so.ch</A></FONT>
<FONT COLOR="#000000">> -----Ursprngliche Nachricht-----</FONT>
<FONT COLOR="#000000">> Von: <A HREF="mailto:strk@refractions.net">strk@refractions.net</A> [mailto:<A HREF="mailto:strk@refractions.net">strk@refractions.net</A>]</FONT>
<FONT COLOR="#000000">> Gesendet am: Donnerstag, 29. Juni 2006 23:57</FONT>
<FONT COLOR="#000000">> An: <A HREF="mailto:'postgis-users@postgis.refractions.net">'postgis-users@postgis.refractions.net</A>'</FONT>
<FONT COLOR="#000000">> Betreff: Re: [postgis-users] Linear Referencing: Create Measure</FONT>
<FONT COLOR="#000000">> </FONT>
<FONT COLOR="#000000">> Maybe we can add such a function, but semantics must be exactly</FONT>
<FONT COLOR="#000000">> defined. How are 'from' and 'to' defined ? How are they applied</FONT>
<FONT COLOR="#000000">> to different types of geometries ?</FONT>
<FONT COLOR="#000000">> </FONT>
<FONT COLOR="#000000">> --strk;</FONT>
<FONT COLOR="#000000">> </FONT>
<FONT COLOR="#000000">> On Thu, Jun 29, 2006 at 11:43:44AM +0100, Dster Horst wrote:</FONT>
<FONT COLOR="#000000">> > I'm faced with the problem to create MGeometries for using </FONT>
<FONT COLOR="#000000">> with the "Linear</FONT>
<FONT COLOR="#000000">> > Referencing" functions of PostGIS. I like to create the </FONT>
<FONT COLOR="#000000">> measures defined by</FONT>
<FONT COLOR="#000000">> > two table attributes meas_from and meas_to. In further </FONT>
<FONT COLOR="#000000">> versions of Christoph</FONT>
<FONT COLOR="#000000">> > Spoerri's LRS functions there exists a function</FONT>
<FONT COLOR="#000000">> > lrs_create_measure(geometry,from,to). As the result the </FONT>
<FONT COLOR="#000000">> M-Values were</FONT>
<FONT COLOR="#000000">> > interpolated based on a start and a stop value of each line. The new</FONT>
<FONT COLOR="#000000">> > functions don't offer such a functionality. I would be </FONT>
<FONT COLOR="#000000">> greatful for any hint</FONT>
<FONT COLOR="#000000">> > how to create measures along a line referenced by a from </FONT>
<FONT COLOR="#000000">> and a to value of</FONT>
<FONT COLOR="#000000">> > this line.</FONT>
<FONT COLOR="#000000">> _______________________________________________</FONT>
<FONT COLOR="#000000">> postgis-users mailing list</FONT>
<FONT COLOR="#000000">> <A HREF="mailto:postgis-users@postgis.refractions.net">postgis-users@postgis.refractions.net</A></FONT>
<FONT COLOR="#000000">> <A HREF="http://postgis.refractions.net/mailman/listinfo/postgis-users">http://postgis.refractions.net/mailman/listinfo/postgis-users</A></FONT>
<FONT COLOR="#000000">> </FONT>
<FONT COLOR="#000000">-------------- next part --------------</FONT>
<FONT COLOR="#000000">A non-text attachment was scrubbed...</FONT>
<FONT COLOR="#000000">Name: lwgeom_functions_lrs.c</FONT>
<FONT COLOR="#000000">Type: application/octet-stream</FONT>
<FONT COLOR="#000000">Size: 45935 bytes</FONT>
<FONT COLOR="#000000">Desc: not available</FONT>
<FONT COLOR="#000000">Url : <A HREF="http://lists.refractions.net/pipermail/postgis-users/attachments/20060703/fb4580f2/lwgeom_functions_lrs.obj">http://lists.refractions.net/pipermail/postgis-users/attachments/20060703/fb4580f2/lwgeom_functions_lrs.obj</A></FONT>
<FONT COLOR="#000000">------------------------------</FONT>
<FONT COLOR="#000000">Message: 3</FONT>
<FONT COLOR="#000000">Date: Mon, 3 Jul 2006 11:47:37 +0100</FONT>
<FONT COLOR="#000000">From: "Mark Cave-Ayland" <<A HREF="mailto:m.cave-ayland@webbased.co.uk">m.cave-ayland@webbased.co.uk</A>></FONT>
<FONT COLOR="#000000">Subject: RE: [postgis-users] 1.1.3 compilation problem</FONT>
<FONT COLOR="#000000">To: "'PostGIS Users Discussion'"</FONT>
<FONT COLOR="#000000"> <<A HREF="mailto:postgis-users@postgis.refractions.net">postgis-users@postgis.refractions.net</A>></FONT>
<FONT COLOR="#000000">Message-ID: <<A HREF="mailto:200607031047.k63AlgQ05980@webbased16.localdomain">200607031047.k63AlgQ05980@webbased16.localdomain</A>></FONT>
<FONT COLOR="#000000">Content-Type: text/plain; charset="iso-8859-1"</FONT>
<FONT COLOR="#000000">> From: <A HREF="mailto:postgis-users-bounces@postgis.refractions.net">postgis-users-bounces@postgis.refractions.net</A> [mailto:postgis-users-</FONT>
<FONT COLOR="#000000"><A HREF="mailto:bounces@postgis.refractions.net">bounces@postgis.refractions.net</A>] On Behalf Of Stefano B.</FONT>
<FONT COLOR="#000000">> Sent: 03 July 2006 08:09</FONT>
<FONT COLOR="#000000">> To: PostGIS Users Discussion</FONT>
<FONT COLOR="#000000">> Subject: [postgis-users] 1.1.3 compilation problem</FONT>
<FONT COLOR="#000000">></FONT>
<FONT COLOR="#000000">> Hi, when I compile postgis 1.1.3 on my freebsd 5.3 os I get the following:</FONT>
<FONT COLOR="#000000">(cut)</FONT>
<FONT COLOR="#000000">> gmake -C lwgeom</FONT>
<FONT COLOR="#000000">> gmake[1]: Entering directory `/usr/src/smit/postgis-1.1.3/lwgeom'</FONT>
<FONT COLOR="#000000">> bison -y -vd -p lwg_parse_yy wktparse.y</FONT>
<FONT COLOR="#000000">> wktparse.y:40.14: parse error, unexpected ":", expecting ";" or "|"</FONT>
<FONT COLOR="#000000">> wktparse.y:58.20-32: $3 of `geometry' has no declared type</FONT>
<FONT COLOR="#000000">> wktparse.y:61.6-19: $1 of `geometry' has no declared type</FONT>
<FONT COLOR="#000000">> wktparse.y:145.17: parse error, unexpected ":", expecting ";" or "|"</FONT>
<FONT COLOR="#000000">> wktparse.y:232.14-31: $1 of `geom_multilinestring' has no declared type</FONT>
<FONT COLOR="#000000">> wktparse.y:232.14-34: $2 of `geom_multilinestring' has no declared type</FONT>
<FONT COLOR="#000000">> wktparse.y:235.20-37: $1 of `geom_multilinestring' has no declared type</FONT>
<FONT COLOR="#000000">> wktparse.y:235.20-40: $2 of `geom_multilinestring' has no declared type</FONT>
<FONT COLOR="#000000">> wktparse.y:235.20-43: $3 of `geom_multilinestring' has no declared type</FONT>
<FONT COLOR="#000000">> wktparse.y:238.26-43: $1 of `geom_multilinestring' has no declared type</FONT>
<FONT COLOR="#000000">> wktparse.y:238.26-46: $2 of `geom_multilinestring' has no declared type</FONT>
<FONT COLOR="#000000">> wktparse.y:238.26-49: $3 of `geom_multilinestring' has no declared type</FONT>
<FONT COLOR="#000000">> wktparse.y:238.26-52: $4 of `geom_multilinestring' has no declared type</FONT>
<FONT COLOR="#000000">> gmake[1]: *** [wktparse.tab.c] Error 1</FONT>
<FONT COLOR="#000000">> gmake[1]: Leaving directory `/usr/src/smit/postgis-1.1.3/lwgeom'</FONT>
<FONT COLOR="#000000">> gmake: *** [liblwgeom] Error 2</FONT>
<FONT COLOR="#000000">> gmake -C lwgeom</FONT>
<FONT COLOR="#000000">> gmake[1]: Entering directory `/usr/src/smit/postgis-1.1.3/lwgeom'</FONT>
<FONT COLOR="#000000">> bison -y -vd -p lwg_parse_yy wktparse.y</FONT>
<FONT COLOR="#000000">> wktparse.y:40.14: parse error, unexpected ":", expecting ";" or "|"</FONT>
<FONT COLOR="#000000">> wktparse.y:58.20-32: $3 of `geometry' has no declared type</FONT>
<FONT COLOR="#000000">> wktparse.y:61.6-19: $1 of `geometry' has no declared type</FONT>
<FONT COLOR="#000000">> wktparse.y:145.17: parse error, unexpected ":", expecting ";" or "|"</FONT>
<FONT COLOR="#000000">> wktparse.y:232.14-31: $1 of `geom_multilinestring' has no declared type</FONT>
<FONT COLOR="#000000">> wktparse.y:232.14-34: $2 of `geom_multilinestring' has no declared type</FONT>
<FONT COLOR="#000000">> wktparse.y:235.20-37: $1 of `geom_multilinestring' has no declared type</FONT>
<FONT COLOR="#000000">> wktparse.y:235.20-40: $2 of `geom_multilinestring' has no declared type</FONT>
<FONT COLOR="#000000">> wktparse.y:235.20-43: $3 of `geom_multilinestring' has no declared type</FONT>
<FONT COLOR="#000000">> wktparse.y:238.26-43: $1 of `geom_multilinestring' has no declared type</FONT>
<FONT COLOR="#000000">> wktparse.y:238.26-46: $2 of `geom_multilinestring' has no declared type</FONT>
<FONT COLOR="#000000">> wktparse.y:238.26-49: $3 of `geom_multilinestring' has no declared type</FONT>
<FONT COLOR="#000000">> wktparse.y:238.26-52: $4 of `geom_multilinestring' has no declared type</FONT>
<FONT COLOR="#000000">> gmake[1]: *** [wktparse.tab.c] Error 1</FONT>
<FONT COLOR="#000000">> gmake[1]: Leaving directory `/usr/src/smit/postgis-1.1.3/lwgeom'</FONT>
<FONT COLOR="#000000">> gmake: *** [liblwgeom] Error 2</FONT>
<FONT COLOR="#000000">Hi Stefano,</FONT>
<FONT COLOR="#000000">If you haven't altered any of the bison grammar files, then it could be that</FONT>
<FONT COLOR="#000000">you're using a broken version of Bison - I know the PostgreSQL team often</FONT>
<FONT COLOR="#000000">experience problems with Bison versions > 1.875, which is the version I'm</FONT>
<FONT COLOR="#000000">using here without any issues.</FONT>
<FONT COLOR="#000000">What is more interesting is that even though we include</FONT>
<FONT COLOR="#000000">lex.yy.c/wktparse.tab.c in the release tarballs, under Win32 it seems to</FONT>
<FONT COLOR="#000000">want to always rebuild these files from the .yy source files if flex/bison</FONT>
<FONT COLOR="#000000">are found during the configure phase, instead of noticing that the supplied</FONT>
<FONT COLOR="#000000">files haven't been changed and using them as they are. Does anyone else see</FONT>
<FONT COLOR="#000000">this behaviour?</FONT>
<FONT COLOR="#000000">Kind regards,</FONT>
<FONT COLOR="#000000">Mark.</FONT>
<FONT COLOR="#000000">------------------------</FONT>
<FONT COLOR="#000000">WebBased Ltd</FONT>
<FONT COLOR="#000000">17 Research Way</FONT>
<FONT COLOR="#000000">Plymouth</FONT>
<FONT COLOR="#000000">PL6 8BT</FONT>
<FONT COLOR="#000000">T: +44 (0)1752 797131</FONT>
<FONT COLOR="#000000">F: +44 (0)1752 791023</FONT>
<FONT COLOR="#000000"><A HREF="http://www.webbased.co.uk">http://www.webbased.co.uk</A> </FONT>
<FONT COLOR="#000000"><A HREF="http://www.infomapper.com">http://www.infomapper.com</A></FONT>
<FONT COLOR="#000000"><A HREF="http://www.swtc.co.uk">http://www.swtc.co.uk</A> </FONT>
<FONT COLOR="#000000">This email and any attachments are confidential to the intended recipient</FONT>
<FONT COLOR="#000000">and may also be privileged. If you are not the intended recipient please</FONT>
<FONT COLOR="#000000">delete it from your system and notify the sender. You should not copy it or</FONT>
<FONT COLOR="#000000">use it for any purpose nor disclose or distribute its contents to any other</FONT>
<FONT COLOR="#000000">person.</FONT>
<FONT COLOR="#000000">------------------------------</FONT>
<FONT COLOR="#000000">Message: 4</FONT>
<FONT COLOR="#000000">Date: Mon, 3 Jul 2006 09:23:45 -0500</FONT>
<FONT COLOR="#000000">From: "Warren Noll" <<A HREF="mailto:warren.noll@21csi.com">warren.noll@21csi.com</A>></FONT>
<FONT COLOR="#000000">Subject: [postgis-users] Raster images</FONT>
<FONT COLOR="#000000">To: <<A HREF="mailto:postgis-users@postgis.refractions.net">postgis-users@postgis.refractions.net</A>></FONT>
<FONT COLOR="#000000">Message-ID: <004701c69eac$4b652080$9000a8c0@21CSILaptop23></FONT>
<FONT COLOR="#000000">Content-Type: text/plain; charset="us-ascii"</FONT>
<FONT COLOR="#000000">Skipped content of type multipart/alternative-------------- next part --------------</FONT>
<FONT COLOR="#000000">A non-text attachment was scrubbed...</FONT>
<FONT COLOR="#000000">Name: not available</FONT>
<FONT COLOR="#000000">Type: image/jpeg</FONT>
<FONT COLOR="#000000">Size: 5934 bytes</FONT>
<FONT COLOR="#000000">Desc: not available</FONT>
<FONT COLOR="#000000">Url : <A HREF="http://lists.refractions.net/pipermail/postgis-users/attachments/20060703/44631fcc/attachment-0001.jpe">http://lists.refractions.net/pipermail/postgis-users/attachments/20060703/44631fcc/attachment-0001.jpe</A></FONT>
<FONT COLOR="#000000">------------------------------</FONT>
<FONT COLOR="#000000">Message: 5</FONT>
<FONT COLOR="#000000">Date: Mon, 03 Jul 2006 11:09:43 -0400</FONT>
<FONT COLOR="#000000">From: Stephen Woodbridge <<A HREF="mailto:woodbri@swoodbridge.com">woodbri@swoodbridge.com</A>></FONT>
<FONT COLOR="#000000">Subject: Re: [postgis-users] Raster images</FONT>
<FONT COLOR="#000000">To: <A HREF="mailto:Warren.Noll@21csi.com">Warren.Noll@21csi.com</A>, PostGIS Users Discussion</FONT>
<FONT COLOR="#000000"> <<A HREF="mailto:postgis-users@postgis.refractions.net">postgis-users@postgis.refractions.net</A>></FONT>
<FONT COLOR="#000000">Message-ID: <<A HREF="mailto:44A93337.9060600@swoodbridge.com">44A93337.9060600@swoodbridge.com</A>></FONT>
<FONT COLOR="#000000">Content-Type: text/plain; charset=windows-1252; format=flowed</FONT>
<FONT COLOR="#000000">Hi Warren,</FONT>
<FONT COLOR="#000000">There has been a lot of discussion about rasters on the list and the </FONT>
<FONT COLOR="#000000">dev-list so you might want to read some of that. But I will summarize in </FONT>
<FONT COLOR="#000000">really short form and leave it to others that chime in if I have it </FONT>
<FONT COLOR="#000000">wrong ot there are other options.</FONT>
<FONT COLOR="#000000">Today, I think your best bet it to keep the raster data as files but to </FONT>
<FONT COLOR="#000000">use postgres/postgis to the manage you raster colection. So you might </FONT>
<FONT COLOR="#000000">include metadata, transform info, size, path to the file on disk, you </FONT>
<FONT COLOR="#000000">might also want to create polygon or bbox representations of each raster </FONT>
<FONT COLOR="#000000">file so you can use spatial search against these and other data you have </FONT>
<FONT COLOR="#000000">in postgis.</FONT>
<FONT COLOR="#000000">If you are working with mapserver, I would read the mapserver archive </FONT>
<FONT COLOR="#000000">for posts by Ed McNierney on rasters. He runs Topozone.com and they have </FONT>
<FONT COLOR="#000000">nearly a million rasters online that require ablut 20TB of disk space.</FONT>
<FONT COLOR="#000000">Hope that helps,</FONT>
<FONT COLOR="#000000"> -Steve W</FONT>
<FONT COLOR="#000000">Warren Noll wrote:</FONT>
<FONT COLOR="#000000">> Im new to PostGIS. We are using it to access our GIS data, but dont </FONT>
<FONT COLOR="#000000">> know for sure the best way to handle raster images. Any suggestions?</FONT>
<FONT COLOR="#000000">> </FONT>
<FONT COLOR="#000000">> </FONT>
<FONT COLOR="#000000">> </FONT>
<FONT COLOR="#000000">> Warren Noll</FONT>
<FONT COLOR="#000000">> </FONT>
<FONT COLOR="#000000">> **/21st Century Systems, Inc./**</FONT>
<FONT COLOR="#000000">> </FONT>
<FONT COLOR="#000000">> //199 East 4th Street////, Suite B//</FONT>
<FONT COLOR="#000000">> </FONT>
<FONT COLOR="#000000">> //University of Missouri Technology Park, Building 2081//</FONT>
<FONT COLOR="#000000">> </FONT>
<FONT COLOR="#000000">> //Fort//// Leonard Wood, MO 65473//</FONT>
<FONT COLOR="#000000">> </FONT>
<FONT COLOR="#000000">> //573-329-8526 ext. 2165//</FONT>
<FONT COLOR="#000000">> </FONT>
<FONT COLOR="#000000">> //573-329-8509 (Fax)//</FONT>
<FONT COLOR="#000000">> </FONT>
<FONT COLOR="#000000">> <A HREF="mailto:WARREN.NOLL@21CSI.COM">WARREN.NOLL@21CSI.COM</A> <mailto:<A HREF="mailto:WARREN.NOLL@21CSI.COM">WARREN.NOLL@21CSI.COM</A>> <A HREF="http://WWW.21CSI.COM">WWW.21CSI.COM</A> </FONT>
<FONT COLOR="#000000">> <<A HREF="http://www.21CSI.COM">http://www.21CSI.COM</A>></FONT>
<FONT COLOR="#000000">> </FONT>
<FONT COLOR="#000000">> </FONT>
<FONT COLOR="#000000">> </FONT>
<FONT COLOR="#000000">> </FONT>
<FONT COLOR="#000000">> </FONT>
<FONT COLOR="#000000">> </FONT>
<FONT COLOR="#000000">> </FONT>
<FONT COLOR="#000000">> ********************************************************************</FONT>
<FONT COLOR="#000000">> </FONT>
<FONT COLOR="#000000">> This electronic mail transmission contains confidential</FONT>
<FONT COLOR="#000000">> </FONT>
<FONT COLOR="#000000">> information intended only for the person(s) named.</FONT>
<FONT COLOR="#000000">> </FONT>
<FONT COLOR="#000000">> Any use, distribution, copying or disclosure by another</FONT>
<FONT COLOR="#000000">> </FONT>
<FONT COLOR="#000000">> person is strictly prohibited.</FONT>
<FONT COLOR="#000000">> </FONT>
<FONT COLOR="#000000">> ********************************************************************</FONT>
<FONT COLOR="#000000">> </FONT>
<FONT COLOR="#000000">> </FONT>
<FONT COLOR="#000000">> </FONT>
<FONT COLOR="#000000">> </FONT>
<FONT COLOR="#000000">> </FONT>
<FONT COLOR="#000000">> </FONT>
<FONT COLOR="#000000">> </FONT>
<FONT COLOR="#000000">> </FONT>
<FONT COLOR="#000000">> ------------------------------------------------------------------------</FONT>
<FONT COLOR="#000000">> </FONT>
<FONT COLOR="#000000">> _______________________________________________</FONT>
<FONT COLOR="#000000">> postgis-users mailing list</FONT>
<FONT COLOR="#000000">> <A HREF="mailto:postgis-users@postgis.refractions.net">postgis-users@postgis.refractions.net</A></FONT>
<FONT COLOR="#000000">> <A HREF="http://postgis.refractions.net/mailman/listinfo/postgis-users">http://postgis.refractions.net/mailman/listinfo/postgis-users</A></FONT>
<FONT COLOR="#000000">------------------------------</FONT>
<FONT COLOR="#000000">Message: 6</FONT>
<FONT COLOR="#000000">Date: Mon, 3 Jul 2006 10:11:50 -0500</FONT>
<FONT COLOR="#000000">From: "Warren Noll" <<A HREF="mailto:warren.noll@21csi.com">warren.noll@21csi.com</A>></FONT>
<FONT COLOR="#000000">Subject: [postgis-users] bring PostGIS into the raster world</FONT>
<FONT COLOR="#000000">To: <<A HREF="mailto:postgis-users@postgis.refractions.net">postgis-users@postgis.refractions.net</A>></FONT>
<FONT COLOR="#000000">Message-ID: <004d01c69eb3$031e9bb0$9000a8c0@21CSILaptop23></FONT>
<FONT COLOR="#000000">Content-Type: text/plain; charset="us-ascii"</FONT>
<FONT COLOR="#000000">Skipped content of type multipart/alternative-------------- next part --------------</FONT>
<FONT COLOR="#000000">A non-text attachment was scrubbed...</FONT>
<FONT COLOR="#000000">Name: not available</FONT>
<FONT COLOR="#000000">Type: image/jpeg</FONT>
<FONT COLOR="#000000">Size: 5934 bytes</FONT>
<FONT COLOR="#000000">Desc: not available</FONT>
<FONT COLOR="#000000">Url : <A HREF="http://lists.refractions.net/pipermail/postgis-users/attachments/20060703/94f23fc3/attachment-0001.jpe">http://lists.refractions.net/pipermail/postgis-users/attachments/20060703/94f23fc3/attachment-0001.jpe</A></FONT>
<FONT COLOR="#000000">------------------------------</FONT>
<FONT COLOR="#000000">_______________________________________________</FONT>
<FONT COLOR="#000000">postgis-users mailing list</FONT>
<FONT COLOR="#000000"><A HREF="mailto:postgis-users@postgis.refractions.net">postgis-users@postgis.refractions.net</A></FONT>
<FONT COLOR="#000000"><A HREF="http://postgis.refractions.net/mailman/listinfo/postgis-users">http://postgis.refractions.net/mailman/listinfo/postgis-users</A></FONT>
<FONT COLOR="#000000">End of postgis-users Digest, Vol 45, Issue 3</FONT>
<FONT COLOR="#000000">********************************************</FONT>
</PRE>
</BLOCKQUOTE>
<TABLE CELLSPACING="0" CELLPADDING="0" WIDTH="100%">
<TR>
<TD>
Mark Thomas<BR>
Senior Software Engineer<BR>
Awarix Corporation<BR>
mthomas@awarix.com<BR>
http://www.awarix.com<BR>
<BR>
<I>"Commit to the Lord whatever you do, </I><BR>
<I> and your plans will succeed." - Proverbs 16:3</I><BR>
<BR>
<BR>
</TD>
</TR>
</TABLE>
</BODY>
</HTML>