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

Wed, 26 Mar 2003 10:27:21 -0500

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@geoanalytics.com>
To: "'Jim Burnett'" <r000t@adelphia.net>; <woodbri@swoodbridge.com>;
<mapserver-users@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@adelphia.net]
> > Sent: Wednesday, March 26, 2003 8:05 AM
> > To: woodbri@swoodbridge.com; Puneet Kishor;
> > mapserver-users@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@swoodbridge.com>
> > To: "Puneet Kishor" <pkishor@geoanalytics.com>;
> > <mapserver-users@lists.gis.umn.edu>; "Jim Burnett"
> > <r000t@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@geoanalytics.com>
> > > > To: "'Jim Burnett'" <r000t@adelphia.net>;
> > > > <mapserver-users@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@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@geoanalytics.com>
> > > > > > To: <mapserver-users@lists.gis.umn.edu>
> > > > > > Sent: Tuesday, March 25, 2003 4:37 PM
> > > > > > Subject: [Mapserver-users] Re: Query data PHP/Mapscript
> > > > > >
> > > > > >
> > > > > > > --- In mapserver-users@yahoogroups.com, "Jim Burnett"
> > > > > > <r000t@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@g...>
> > > > > > > > To: <mapserver-users@l...>
> > > > > > > > Sent: Tuesday, March 25, 2003 3:57 PM
> > > > > > > > Subject: [Mapserver-users] Re: Query data PHP/Mapscript
> > > > > > > >
> > > > > > > >
> > > > > > > > > --- In mapserver-users@yahoogroups.com, "Jim Burnett"
> > > > > > <r000t@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@l...
> > > > > > > > >
> > http://lists.gis.umn.edu/mailman/listinfo/m> apserver-users
> > > > > > > >
> > > > > > > > _______________________________________________
> > > > > > > > Mapserver-users mailing list
> > > > > > > > Mapserver-users@l...
> > > > > > > > http://lists.gis.umn.edu/mailman/listinfo/mapserver-users
> > > > > > >
> > > > > > > _______________________________________________
> > > > > > > Mapserver-users mailing list
> > > > > > > Mapserver-users@lists.gis.umn.edu
> > > > > > > http://lists.gis.umn.edu/mailman/listinfo/mapserver-users
> > > > > >
> > > > > _______________________________________________
> > > > > Mapserver-users mailing list
> > > > > Mapserver-users@lists.gis.umn.edu
> > > > > http://lists.gis.umn.edu/mailman/listinfo/mapserver-users
> > > > >
> > > >
> > > > _______________________________________________
> > > > Mapserver-users mailing list
> > > > Mapserver-users@lists.gis.umn.edu
> > > > http://lists.gis.umn.edu/mailman/listinfo/mapserver-users
> > > >
> > >
> > >
> >

_______________________________________________
Mapserver-users mailing list
Mapserver-users@lists.gis.umn.edu
http://lists.gis.umn.edu/mailman/listinfo/mapserver-users