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

[Jim Burnett]

What is interesting is that I can rename the file to xls, and open them in
excell. They ( recordsets ) don't have a record number/key either. I cant
import that excell file into access unless I save as another excel file
using the actuall excel format. The dbf files wont import as dbase files
into access or excell. I dont really care about access or excell, i just
want to be able to search on the data as is in the dbf file.

What format does ESRI use when producing the SHP files?

-Jim
http://www.phpgis.org/



----- Original Message -----
From: "Jon Shorie" <jshorie at medinaco.org>
To: <mapserver-users at lists.gis.umn.edu>
Sent: Wednesday, March 26, 2003 9:30 AM
Subject: Re: [Mapserver-users] Re: Query data PHP/Mapscript


> It is possible that what you are dealing with are actually .db files from
a
> boorland product such as delphi or paradox.  They are very similar to .dbf
> files except that they do not have a record number as the first field in
> them.  This breaks the .dbf standard (and probably the ms excel and ms
> access) .dbf filters, but I do not think that it would be a problem for
> mapserver (perhaps someone else can shed some light on this).  If the .db
> files are renamed .dbf then it may be possible to still make use of them.
A
> good way to check is to see if (after renaming to .db) the file can be
opened
> in quattro pro, paradox, or delphi.
>
> On Wednesday 26 March 2003 08: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/mapserver-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
>
>
> _______________________________________________
> Mapserver-users mailing list
> Mapserver-users at lists.gis.umn.edu
> http://lists.gis.umn.edu/mailman/listinfo/mapserver-users