[Mapserver-users] Re: Query data PHP/Mapscript

[Puneet Kishor]

Jim,


> -----Original Message-----
> From: Jim Burnett [mailto:r000t at adelphia.net] 
> Sent: Wednesday, March 26, 2003 8:05 AM
> To: woodbri at swoodbridge.com; Puneet Kishor; 
> mapserver-users at lists.gis.umn.edu
> Subject: Re: [Mapserver-users] Re: Query data PHP/Mapscript
> 
> 
> As my last message says, the file is NOT dbase, it is foxpro. 
> Or whatever
> esri uses. These modules will not read the dbf files. I am 
> talking about the
> dbf files that are produced with the shp files.

If you are talking about the dbf files that are produces with shapefiles,
those are indeed standard dbf files. If you are unable to open them then
there is something wrong with those specific files. The fact that you are
able to query them via mapserver proves once again that they are basic dbf
files.

I routinely query dbf files associated with shapefiles via perl's xbase
module, and also via php. No problem at all.

Dunno what to suggest... you said that Excel and Access also failed. I can
only think they are corrupted in someway.

If you have access to Arcview, you could read them in, and save them out
again as a copy... maybe that would fix them.




> 
> -Jim
> ----- Original Message -----
> From: <woodbri at swoodbridge.com>
> To: "Puneet Kishor" <pkishor at geoanalytics.com>;
> <mapserver-users at lists.gis.umn.edu>; "Jim Burnett" 
> <r000t at adelphia.net>
> Sent: Wednesday, March 26, 2003 8:52 AM
> Subject: Re: [Mapserver-users] Re: Query data PHP/Mapscript
> 
> 
> > In PHP look at the dbase module and in Perl look at the 
> xbase module.
> > Both of these will allow you to open and read dbf files.
> >
> > -Steve W.
> >
> > On 26 Mar 2003 at 8:36, Jim Burnett wrote:
> >
> > > I am pretty sure the are NOT dbase files, however 
> mapserver reads them
> > > just fine when querying the map. What I want to do is query these
> > > files without displaying a map, but show the results of 
> thedata found.
> > > Currently I put the data in mysql, but I want to make my 
> application
> > > 100% mapserver driven. Then I just search on the mysql 
> database  using
> > > sql. So thats what I want to do with mapserver.
> > >
> > > -Jim
> > >
> > > ----- Original Message -----
> > > From: "Puneet Kishor" <pkishor at geoanalytics.com>
> > > To: "'Jim Burnett'" <r000t at adelphia.net>;
> > > <mapserver-users at lists.gis.umn.edu>
> > > Sent: Tuesday, March 25, 2003 5:08 PM
> > > Subject: RE: [Mapserver-users] Re: Query data PHP/Mapscript
> > >
> > >
> > > > please reply to the email list... others may have 
> better ideas than
> > > > me.
> > > >
> > > >
> > > > > -----Original Message-----
> > > > > From: Jim Burnett [mailto:r000t at adelphia.net]
> > > > > Sent: Tuesday, March 25, 2003 3:58 PM
> > > > > To: pkishor_98
> > > > > Subject: Re: [Mapserver-users] Re: Query data PHP/Mapscript
> > > > >
> > > > >
> > > > > I was hoping to not have to use odbc. Is there anyway 
> to access
> > > > > the information via mapserver? I could do a query, 
> show the query
> > > > > on the map and in templates.
> > > >
> > > > when you say "I could do a query" do you mean that you 
> are able to
> > > > do so,
> > > or
> > > > you would like to do so?
> > > >
> > > > I am not sure of the capabilities of the dbase methods that have
> > > > been recently built in mapserver, but my sense is that they also
> > > > access only
> > > dbf
> > > > files that are actually dbase compatible. The problem 
> is, dbf files
> > > created
> > > > by foxpro are not really true dbf files... they just 
> happen to have
> > > > the
> > > .dbf
> > > > extension. If that is what you have, odbc may be the 
> only way out,
> > > > unless you can find a foxpro driver for php (I seriously doubt
> > > > that).
> > > >
> > > > So, first determine what exactly these dbf files are. 
> Then use the
> > > > appropriate way to access them.
> > > >
> > > > Hope this helps.
> > > >
> > > > Puneet.
> > > >
> > > >
> > > >
> > > >
> > > > >
> > > > > ----- Original Message -----
> > > > > From: "pkishor_98" <pkishor at geoanalytics.com>
> > > > > To: <mapserver-users at lists.gis.umn.edu>
> > > > > Sent: Tuesday, March 25, 2003 4:37 PM
> > > > > Subject: [Mapserver-users] Re: Query data PHP/Mapscript
> > > > >
> > > > >
> > > > > > --- In mapserver-users at yahoogroups.com, "Jim Burnett"
> > > > > <r000t at a...> wrote:
> > > > > > > Yeah I looked in the dbase methods but they dont work
> > > > > > > with any of the dbf
> > > > > > > files I have. Actually Excel and Access can even read
> > > > > > > them.  Any clues?
> > > > > >
> > > > > > I am assuming you meant to write "Actually Excel and Access
> > > > > > _can't_ even read..."
> > > > > >
> > > > > >
> > > > > > Since neither Excel nor Access can read these dbf 
> files, they
> > > > > > are probably not dbf files created by dbase, or 
> compatible with
> > > > > the dbase
> > > > > > format. In all likelihood, these are foxpro files. In which
> > > > > case, your
> > > > > > best bet would be to use the foxpro odbc driver, and access
> > > > > the files
> > > > > > as odbc datasources.
> > > > > >
> > > > > >
> > > > > >
> > > > > >
> > > > > >
> > > > > > >
> > > > > > >
> > > > > > > ----- Original Message -----
> > > > > > > From: "pkishor_98" <pkishor at g...>
> > > > > > > To: <mapserver-users at l...>
> > > > > > > Sent: Tuesday, March 25, 2003 3:57 PM
> > > > > > > Subject: [Mapserver-users] Re: Query data PHP/Mapscript
> > > > > > >
> > > > > > >
> > > > > > > > --- In mapserver-users at yahoogroups.com, "Jim Burnett"
> > > > > <r000t at a...>
> > > > > > wrote:
> > > > > > > > > Hey all, looks like spring is here at last!
> > > > > > > > >
> > > > > > > > > Anywho, I want to search a dbf file for some data (
> > > > > not map ). For
> > > > > > > > example I have a parcel layer that I want to search on.
> > > > > I want to get
> > > > > > > > all the "smiths" or whatever I want to search on. Can
> > > > > this be done?
> > > > > > > >
> > > > > > > >
> > > > > > > > sure... check out the dbase methods in php. make sure
> > > > > php is compiled
> > > > > > > > with dbase.
> > > > > > > >
> > > > > > > > since dbf is a crummy format, you will have to loop
> > > > > through each row,
> > > > > > > > and within each row, loop through each field, unless
> > > > > you know which
> > > > > > > > field you are searching for, until you find what you
> > > > > are looking for.
> > > > > > > >
> > > > > > > > _______________________________________________
> > > > > > > > Mapserver-users mailing list
> > > > > > > > Mapserver-users at l...
> > > > > > > > 
> http://lists.gis.umn.edu/mailman/listinfo/m> apserver-users
> > > > > > >
> > > > > > > _______________________________________________
> > > > > > > Mapserver-users mailing list
> > > > > > > Mapserver-users at l...
> > > > > > > http://lists.gis.umn.edu/mailman/listinfo/mapserver-users
> > > > > >
> > > > > > _______________________________________________
> > > > > > Mapserver-users mailing list
> > > > > > Mapserver-users at lists.gis.umn.edu
> > > > > > http://lists.gis.umn.edu/mailman/listinfo/mapserver-users
> > > > >
> > > > _______________________________________________
> > > > Mapserver-users mailing list
> > > > Mapserver-users at lists.gis.umn.edu
> > > > http://lists.gis.umn.edu/mailman/listinfo/mapserver-users
> > > >
> > >
> > > _______________________________________________
> > > Mapserver-users mailing list
> > > Mapserver-users at lists.gis.umn.edu
> > > http://lists.gis.umn.edu/mailman/listinfo/mapserver-users
> > >
> >
> >
>