[postgis-users] shp2pgsql (php)

[Paul Scott]

Robert,

Thanks for the input, I have worked out a very similar function to do
that as well, but also using the regular pg php functions. I also
thought that it may be a bit of an ugly hack, but now I feel better
seeing that someone else has done it the same way ;>

I will let you know when I release the class in its final form, bearing
in mind that this is a hobby for me, and it may take some time!

--Paul

On Wed, 2004-12-29 at 20:22, Robert W. Burgholzer wrote:
> Paul,
> 
> Don't know if this is helpful or just an ugly hack, but I happened to write 
> a coordinate extractor this morning. The "projectid" field in my queries is 
> used because my db has several projects stored in the same db, so eliminate 
> it if yours doesn't need this. The "quickview" function is included, and as 
> you can see is just a simple wrapper for setextent, and is implemented as a 
> method on the object "amap".  The object "amap" is a custom object that I 
> have written, carved out of the old gMap suite routines, and some home-made 
> additions. The "listobject", "listobject->performquery()" and 
> "listobject->getRecordValue" are proprietary functions that I use to make 
> my applications somewhat db independent, and are not included in the 
> interest of brevity:
> 
> 
> # quickview function, sets the extent of a map,
>     function quickView($lox,$loy,$hix,$hiy) {
>        $this->map->setextent($lox,$loy,$hix,$hiy);
>     }
> 
> # get the extent, and set your map to that extent
> $listobject->querystring = "select extent(the_geom) as thisext from 
> watersheds_dd where projectid = $projectid";
> 
> $listobject->performQuery();
> $extext = $listobject->getRecordValue(1,'thisext');
> #print("Extent: $extext <br>");
> list($open, $tail) = explode("(", $extext);
> list($coordpair, $close) = split(")", $tail);
> list($locoords, $hicoords) = split(",", $coordpair);
> list($lox, $loy, $loz) = split(" ", $locoords);
> list($hix, $hiy, $hiz) = split(" ", $hicoords);
> 
> #print("$open, $tail, $coordpair, $close, $locoords, $hicoords, $lox, $loy, 
> $loz, $hix, $hiy, $hiz<br>");
> 
> 
> if (!isset($HTTP_POST_VARS['extent']) ) {
>     $amap->quickView($lox,$loy,$hix,$hiy);
> }
> 
> At 10:27 AM 12/29/2004 +0200, you wrote:
> >This is what I have so far, I am busy writing a function now that gets
> >the extents from postGIS and writes them to a mapfile (not Included)
> >
> >//function to insert shapefiles (ESRI) into PostGIS DB
> >function create_sql($filename,$dbname)
> >{
> >         //create the tablename from the filename (replace the .shp with shp)
> >         $tablename1 = str_replace('.','',$filename);
> >         //Remove last three chars from table name ('shp' is discarded)
> >         $tablename = substr($tablename1,0,-3);
> >         //Give the log file a name by tacking .log onto the table name
> >         $logfile = $tablename.".log";
> >         //execute the shell script that does all the real work (thanks
> >refractions.net)
> >         $ret = shell_exec("/usr/local/pgsql/bin/shp2pgsql $filename
> >$tablename|/usr/local/pgsql/bin/psql -d $dbname 2>&1");
> >         //echo $ret; //debug only (displays the results)
> >         //open a file handle for binary safe write - this creates a
> >logfile...Use it or leave it, just an extra
> >         $handle = fopen($logfile,'w');
> >         //Write the log data to a file
> >         fwrite($handle, $ret);
> >         //close the file handle
> >         fclose($handle);
> >}
> >
> >//loop through all the shapefiles and perform the function on them
> >foreach (glob("*.shp") as $filename)
> >{
> >   //display the file size and name that we are currently working on
> >   //echo "$filename size " . filesize($filename) . "<br><br>\n";
> >   //do the sql-ize and insert the data, also write a log
> >   create_sql($filename,$dbname);
> >}//end foreach
> >
> >On Wed, 2004-12-29 at 10:20, "Guillaume SUEUR (Géosignal)" wrote:
> > > I think I can be interested in that. If I can help !
> > >
> > > regards
> > >
> > > Guillaume
> > >
> > > Paul Scott wrote:
> > > > ***********************
> > > > Votre mail a étét scanné par InterScan VirusWall.
> > > > ***********-***********
> > > >
> > > >
> > > > Hope you all had a good holiday!
> > > >
> > > > I have written a shapefile dumper function in PHP using shp2pgsql that
> > > > basically goes through a directory of files and inserts them all into a
> > > > postgis db, and then writes a log file for each shapefile (for error
> > > > checking).
> > > >
> > > >
> > > > I am planning on making a PHP class to handle a bunch of functions for
> > > > creating db's, populating them and doing some other basic stuff, which I
> > > > will release on the phpclasses.org site. I would also like to include
> > > > some functions to create a UMN Mapserver .map file to use the data
> > > > automagically for "regular" users that don't need to know the
> > > > intricacies of postgis, mapserver and php to set up a quick app. i.e.
> > > > The users will be able to fill out a webform, upload their data in shp
> > > > format and in a few minutes have a ready to go mapserver app.
> > > >
> > > > If anyone is interested in the code that I have written so far, or would
> > > > like to help out on this project, please contact me.
> > > >
> > > >
> > > > --Paul
> > > > --
> > > >
> > > > Linux User #348957
> > > >
> > > > _______________________________________________
> > > > postgis-users mailing list
> > > > postgis-users at postgis.refractions.net
> > > > http://postgis.refractions.net/mailman/listinfo/postgis-users
> > > >
> > > >
> > > >
> > > >
> >--
> >Linux User #348957
> >
> >_______________________________________________
> >postgis-users mailing list
> >postgis-users at postgis.refractions.net
> >http://postgis.refractions.net/mailman/listinfo/postgis-users
> 
> Robert Burgholzer
> Environmental Engineer
> MapTech Inc.
> phone: 804-869-3066
> http://www.maptech-inc.com/
> 
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users
> 
-- 
Linux User #348957