Personal geodatabase layer not working.

[Paul Moen]

I created a personal geodatabase with only 3 records in each feature class.
One has 3 counties as polygons.  The other is a point layer with only three
points. Maybe I messed up when I created the geodatabase.


On 11/29/06 10:12 AM, "William Kyngesburye" <woklist at kyngchaos.com> wrote:

> On Nov 29, 2006, at 9:34 AM, Paul Moen wrote:
> 
>> I have a dsn named 'thecounty' set up to access a Personal
>> Geodatabase.
>> When I use the following command,
>> ogrinfo Pgeo:thecounty votes
>> 
>> I get the following output,
>> 
>> INFO: Open of `PGeo:thecounty'
>>       using driver `PGeo' successful.
>> 
> ...
> 
>> I get no errors, but nothing is displayed on my map.  The
>> projection of my
>> map is the same as the Projection in the personal geodatabase.
>> 
>> Anyone have any ideas?
>> 
> Still having problems with this?
> 
> One question - when you installed that Actual Access driver, are you
> just using the trial?  That only returns the first 3 records in any
> MDB, and those 3 might not be on your map region.
I am using the trial.  I was hoping to make sure it works before spending
the money.

> 
> try this:
> 
> ogrinfo -al Pgeo:thecounty votes
Gives this output.


Layer name: Votes
Geometry: Unknown (any)
Feature Count: 3
Extent: (2785689.942372, 524554.643027) - (2857978.115425, 559998.112040)
Layer SRS WKT:
PROJCS["NAD_1983_StatePlane_North_Dakota_South_FIPS_3302_Feet",
    GEOGCS["GCS_North_American_1983",
        DATUM["North_American_Datum_1983",
            SPHEROID["GRS_1980",6378137.0,298.257222101]],
        PRIMEM["Greenwich",0.0],
        UNIT["Degree",0.0174532925199433]],
    PROJECTION["Lambert_Conformal_Conic_2SP"],
    PARAMETER["False_Easting",1968500.0],
    PARAMETER["False_Northing",0.0],
    PARAMETER["Central_Meridian",-100.5],
    PARAMETER["Standard_Parallel_1",46.18333333333333],
    PARAMETER["Standard_Parallel_2",47.48333333333333],
    PARAMETER["Latitude_Of_Origin",45.66666666666666],
    UNIT["Foot_US",0.3048006096012192]]
OBJECTID: Integer (11.0)
ADDRESS: String (255.0)
PRECINCT: String (255.0)
PARCEL: String (255.0)
CITYNAME: String (255.0)
POLL_LOCAT: String (255.0)
OGRFeature(Votes):1
  OBJECTID (Integer) = 1
  ADDRESS (String) = N/A
  PRECINCT (String) = 09-20-02 & 09-20-03 & 09-20-04
  PARCEL (String) = 26000001343010
  CITYNAME (String) = ARTHUR
  POLL_LOCAT (String) = Northern Cass School District

OGRFeature(Votes):2
  OBJECTID (Integer) = 2
  ADDRESS (String) = 550 MAIN ST
  PRECINCT (String) = 09-22-02
  PARCEL (String) = 08010011629000
  CITYNAME (String) = ARTHUR
  POLL_LOCAT (String) = Arthur Community Hall

OGRFeature(Votes):3
  OBJECTID (Integer) = 3
  ADDRESS (String) = 17150 25TH ST SE
  PRECINCT (String) = 09-22-06
  PARCEL (String) = 09020011904000
  CITYNAME (String) = ARGUSVILLE
  POLL_LOCAT (String) = Argusville Fire Hall

> 
> That should list the attributes and coordinates data for those first
> three features. Or the whole file if you bought the driver.
> 
> -----
> William Kyngesburye <kyngchaos at kyngchaos.com>
> http://www.kyngchaos.com/
> 
> "History is an illusion caused by the passage of time, and time is an
> illusion caused by the passage of history."
> 
> - Hitchhiker's Guide to the Galaxy
> 
> 

Paul T. Moen
pmoen at nd.gov
701-328-2434
701-328-3696 (fax)
ND State Water Commission