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

Wed Mar 26 07:27:21 PST 2003

I've got 15 diferent "parcel" shape files from 15 diferent countys here in
Virginia. None of these dbf files will open import into dbase, access or
excell. The php dbase functions do not work, and the perl module xbase
doesnt work either.

Could it be that the people producing these arent producing an index field
with them? I dont see any key of anykind when I look at the data in
ArcExplorer.

I will try xbase again to double check everything, its been a while sense I
tried it.

-Jim

----- Original Message -----
From: "Puneet Kishor" <pkishor at geoanalytics.com>
To: "'Jim Burnett'" <r000t at adelphia.net>; <woodbri at swoodbridge.com>;
<mapserver-users at lists.gis.umn.edu>
Sent: Wednesday, March 26, 2003 9:35 AM
Subject: RE: [Mapserver-users] Re: Query data PHP/Mapscript

> 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
> > > >
> > >
> > >
> >