[postgis-users] [Fwd: postgis-users Digest, Vol 79, Issue 29]
Vernon
vwu at vicina.info
Sat May 30 15:13:21 PDT 2009
Hi Milo,
Thanks very much for your information.
I never received your email for some reason, but learn your reply from the
digest.
I don't quite understand what you mean by data. Our current application
has the location, that is street address, information. I know I first need
something to convert a street address into latitude and Longitude. I guess
that is what you say to get a function from openstreetmap. It is great
that the openstreetmap has a globe coverage. Our application current uses
the Google map. We are out of luck for any street address in Asia. I
haven't found out how to use the openstreetmap though.
regards,
Vernon
---------------------------- Original Message ----------------------------
Subject: postgis-users Digest, Vol 79, Issue 29
From: postgis-users-request at postgis.refractions.net
Date: Sat, May 30, 2009 12:00 pm
To: postgis-users at postgis.refractions.net
--------------------------------------------------------------------------
Send postgis-users mailing list submissions to
postgis-users at postgis.refractions.net
To subscribe or unsubscribe via the World Wide Web, visit
http://postgis.refractions.net/mailman/listinfo/postgis-users
or, via email, send a message with subject or body 'help' to
postgis-users-request at postgis.refractions.net
You can reach the person managing the list at
postgis-users-owner at postgis.refractions.net
When replying, please edit your Subject line so it is more specific than
"Re: Contents of postgis-users digest..."
Today's Topics:
1. upgrade a database from postgis 1.3 -> 1.4 (Dylan Beaudette) 2. Is
PostGIS for me? (Vernon)
3. Re: Is PostGIS for me? (Milo van der Linden)
4. Re: ESRI GDB format into PostGIS (Bruce Foster)
----------------------------------------------------------------------
Message: 1
Date: Fri, 29 May 2009 12:12:51 -0700
From: Dylan Beaudette <debeaudette at ucdavis.edu>
Subject: [postgis-users] upgrade a database from postgis 1.3 -> 1.4 To:
PostGIS Users Discussion <postgis-users at postgis.refractions.net>
Message-ID: <200905291212.51707.dylan.beaudette at gmail.com>
Content-Type: text/plain; charset="us-ascii"
Hi,
After working through the issues related to upgrading a postgis-enabled DB
up through 1.3.3, I am now stuck as to how I should upgrade to 1.4. All
of the functions are replaced when I run postgis.sql, however, none of
the AGGREGATES are updated. Is there a clean way to do this? Or will I
need to manually remove all of the AGGREGATES, and then re-run
postgis.sql?
Thanks!
Dylan
--
Dylan Beaudette
Soil Resource Laboratory
http://casoilresource.lawr.ucdavis.edu/
University of California at Davis
530.754.7341
------------------------------
Message: 2
Date: Fri, 29 May 2009 14:30:22 -0700 (PDT)
From: "Vernon" <vwu at vicina.info>
Subject: [postgis-users] Is PostGIS for me?
To: postgis-users at postgis.refractions.net
Message-ID: <60330.174.6.129.141.1243632622.squirrel at www.vicina.info>
Content-Type: text/plain;charset=iso-8859-1
After having been used PostgreSQL for some years, I just learn the PostGID
lately. Currently, I need to solve a street address and distance problem
which is to find out the distance between to given street address (or well
know location as such the city hall in a city) or to find out whether a
street address is inside of a given distance from another street address.
I am wondering whether PostGIS can help me to solve the problem or not. I
understand I first need to convert a street address into a pair of
latitude and Longitude.
------------------------------
Message: 3
Date: Fri, 29 May 2009 23:55:17 +0200
From: Milo van der Linden <mlinden at zeelandnet.nl>
Subject: Re: [postgis-users] Is PostGIS for me?
To: PostGIS Users Discussion <postgis-users at postgis.refractions.net>
Message-ID: <4A2059C5.9010604 at zeelandnet.nl>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
If you want to do distances like that, without any data it's of no use.
You might consider looking at openstreetmap's functions to import data
into postgis, this will at least give you some point information
depending on how well your area of interest is mapped.
But in general, the answer is YES WE CAN. postgis is excelent at
calculating distances (as the crow flies) between points.
Vernon wrote:
> After having been used PostgreSQL for some years, I just learn the
PostGID lately. Currently, I need to solve a street address and distance
problem which is to find out the distance between to given street
address (or well know location as such the city hall in a city) or to
find out whether a street address is inside of a given distance from
another street address. I am wondering whether PostGIS can help me to
solve the problem or not. I understand I first need to convert a street
address into a pair of latitude and Longitude.
>
>
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users
>
>
------------------------------
Message: 4
Date: Sat, 30 May 2009 09:46:46 +0700
From: Bruce Foster <gis.foster at gmail.com>
Subject: Re: [postgis-users] ESRI GDB format into PostGIS
To: PostGIS Users Discussion <postgis-users at postgis.refractions.net>
Message-ID:
<c97454c50905291946m76c5e023n74842b3fabcc5dec at mail.gmail.com>
Content-Type: text/plain; charset=ISO-8859-1
HI
this could help;
ESRI Geodatabases
This topic continues the general introduction to geospatial data
storage covered by the Data Storage Strategies and the Spatial DBMS
topics. This topic should be read together with those two topics,
which introduce terminology and concepts used in this topic as well. This
topic breaks out information specific to ESRI use of databases for new
types of ESRI geospatial storage for the convenience of ESRI users.
ESRI, a legacy GIS vendor, has introduced a variety of products that can
work with geometry and attribute data stored in DBMS servers.
These are not spatial DBMS servers as such are generally understood, but
rather are software products and middleware software that manage data
stored in real DBMS servers using either blob or geometry types if the
DBMS is a spatial DBMS. It is a classic case of a GIS vendor providing
their own spatial capabilities for a DBMS by using their own non-native
geometry types together with supporting capabilities
supplied by the GIS vendor.
Manifold can also work with non-native data stored in databases using ESRI
conventions. In such cases Manifold will work with ESRI's
geometry types and supporting metadata tables using ESRI conventions for
compatibility with ESRI products.
Nomenclature
Many users are baffled by ESRI nomenclature when it comes to parsing the
bewildering variety of marketing phrases ESRI has used to describe ESRI
"geodatabase" formats. If you feel baffled, you are not alone. In a
nutshell, ESRI at one point introduced the idea of storing geometry in
DBMS using a format that more or less boiled down to storing
shapefiles within blobs. This was done in a complex way using
middleware called ArcSDE that worked with serious databases like
Oracle, and it was also done in a somewhat simplified way in Personal
Geodatabase products that used Access .MDB files and were later
apparently updated to work with MSDE (a free version of Microsoft SQL
Server) or with SQL Server Express. In recent years, the ArcSDE
product name seems to have been dropped by ESRI: more recent versions of
this technology have been packaged as part of the ArcGIS product family
and have been referred to as geodatabases.
All such storage methods are technically similar and are generally
referred to as SDE geodatabase formats or as Personal geodatabase
formats when in the somewhat simplified form that uses Access .MDB for
file-based storage. Since all such formats are similar or derived from
ArcSDE, they are referred to by Manifold documentation as ESRI SDE or as
ESRI Geodatabase or as Personal Geodatabase data sources, the
various terms being used interchangeably, regardless of which file format
or DBMS system is used to store the data.
The terms are used interchangeably because some ESRI users come from a
long ArcSDE tradition and don't realize that "geodatabase" is the new term
for the same old thing, while some newer ESRI users might not realize that
their "geodatabase" is really SDE technology with a new name. Because of
the confusion caused by ESRI names for their SDE and their Personal
technology being so similar, Manifold documentation will often refer to
SDE and Personal geodatabases to underline that a particular capability is
available whether one is working with either SDE geodatabases or the
somewhat simpler Personal geodatabases.
Manifold can also connect to ESRI SDE and Personal geodatabase data
sources for full read / write / edit capability. The only limitation is
that unlike all other work with all other spatial DBMS, Manifold will not
create new SDE or new Personal geodatabases, nor will
Manifold add new drawings to an existing geodatabase. If we already have
drawings in an SDE or Personal geodatabase, Manifold will happily import
or link to those drawings. We can edit those drawings, adding new objects
and deleting or editing old objects and in general perform whatever
operation we like. For example, we could link to an existing drawing in a
geodatabase and then copy and paste objects from some other drawing into
that drawing. However, we cannot create new
drawings or new geodatabases.
ESRI ArcSDE / ArcGIS / Personal Geodatabases
ESRI's ArcSDE product stores drawing geometry and other GIS data
within ordinary, non-spatial DBMS servers. ESRI products refer to such
data as geodatabases or SDE data sources (see notes on nomenclature
above).
Technically, one can organize an SDE data source on almost any
database. However, since this can not be done in a database-neutral
fashion and since setting up an SDE data source involves creating
database-specific objects, SDE data sources are only organized on
big-name databases explicitly supported by ESRI, such as IBM DB2, IBM
Informix, Microsoft SQL Server 2000 or 2005 and Oracle. SDE data
sources using Access .mdb appear to have been replaced with SQL Server
Express 2005. Personal geodatabases seem to be found almost
exclusively within .mdb files.
Manifold knows to look for SDE or Personal geodatabase data if we use
Database Console to connect to a database. Manifold usage of SDE or
Personal geodatabase data sources uses Database Console as the primary
interface and includes:
· Connecting to an SDE data source.
· Listing the drawings in an SDE data source in Database Console. ·
Importing drawings.
· Linking drawings in read-write mode.
When importing or linking drawings from SDE or Personal geodatabase data
sources Manifold will fetch the coordinate systems (projections) in use
from ESRI metadata. Importing or linking a drawing assigns it the
coordinate system stored on the data source.
Manifold will convert ESRI style objects within the SDE database into
Manifold equivalents. For example, reading data from an SDE
geodatabase reads parametric curves, flattening them into lines with
straight line segments. As of the current writing Manifold does not accept
"multipoint" values, although this capability is expected to be added in
future editions.
Although Manifold can connect to an existing SDE database, read
(import) drawings, write drawings, link drawings and edit drawings,
Manifold will not export new drawings to an SDE database nor will
Manifold create a new SDE database.
http://www.manifold.net/doc/manifold.htm
Bruce
On Fri, May 29, 2009 at 6:38 AM, Simon Greener
<simon at spatialdbadvisor.com> wrote:
> Frank and Piotr,
>
> Yes, Manifold has reverse-engineered Personal and Enterprise
GeoDatabases. DOn't know how well.
>
> Type "GeoDatabase" into Search in the Manifold Help.
>
> But, the way it is done is that one uses Tools>Database Console tto go
to the database (eg Access .mdb) file that holds the geodata. When
Manifold opens it it will recognise the ESRI crap and allow you to
import/link to it.
>
> regards
> Simon
>> Frank Warmerdam wrote:
>>>
>>> Are you suggesting that Manifold GIS has reverse engineered the file
geodatabase format? Can you provide any pointers supporting that? If
those guys can reverse engineer it, then so could we given enough
desire.
>> I'm using Manifold on daily basis. Not to import ESRI files.
>> Just looked through all possible imports and couldn't find ESRI GDB file
>
>
>
> --
> SpatialDB Advice and Design, Solutions Architecture and Programming,
Oracle Database 10g Administrator Certified Associate; Oracle Database
10g SQL Certified Professional Oracle Spatial, SQL Server, PostGIS,
MySQL, ArcSDE, Manifold GIS, FME, Radius Topology and Studio Specialist.
39 Cliff View Drive, Allens Rivulet, 7150, Tasmania, Australia.
> Website: www.spatialdbadvisor.com
> Email: simon at spatialdbadvisor.com
> Voice: +61 362 396397
> Mobile: +61 418 396391
> Skype: sggreener
> Longitude: 147.20515 (147° 12' 18" E)
> Latitude: -43.01530 (43° 00' 55" S)
> NAC:W80CK 7SWP3
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users
>
------------------------------
_______________________________________________
postgis-users mailing list
postgis-users at postgis.refractions.net
http://postgis.refractions.net/mailman/listinfo/postgis-users
End of postgis-users Digest, Vol 79, Issue 29
*********************************************
--------------------------------
Spam/Virus scanning by CanIt Pro
For more information see
http://www.kgbinternet.com/SpamFilter.htm
To control your spam filter, log in at
http://filter.kgbinternet.com
--
www.vicina.info - your local community information service
News portal - quick, easy browses more than 4,000 news entries from all
major news agencies around the world.
Community news - share your story with others in your community.
Service directory - find or review local places to eat, shop, relax, and
play.
Classified ad - post and browse free classified ads in your neighbourhood.
More information about the postgis-users
mailing list