[postgis-users] FOSS4G Architectures/options for Distributed DBs
Willy-Bas Loos
willybas at gmail.com
Wed Apr 16 03:38:28 PDT 2008
I think ESRI offers products (ArcSDE if I'm not mistaken) that offer
disconnected editting, and integration with Oracle (and ArcPad of course).
You could run PostGIS on the remote sites, allthough then you'd need 600 SDE
enterprise editions :(. I don't know if the disconnected editting feature is
in any of the cheaper versions and what the diffence is in costs.
If you're going to demand Oracle and ArcPad, combined with disconnected
editting, it sounds to me that ArcSDE would be a logical choice. Then again
600 SDE licences are probably pretty expensive.
Maybe this could be part of your client-side solution:
http://www.conterra.de/en/products/sdi/wfseditor/index.shtm
It offers disconnected editting in ArcMap on an SDE server on basis of
WFS-T.
hope that helps.
WBL
On Wed, Apr 16, 2008 at 12:09 PM, Tim Bowden <tim.bowden at westnet.com.au>
wrote:
> On Wed, 2008-04-16 at 11:30 +0200, Willy-Bas Loos wrote:
> > Hi Shaun,
> >
> > I think i saw a colleage of yours at the FOSS4G2007, Tim Bowden.
> > http://www.foss4g2007.org/presentations/view.php?abstract_id=261
> > (i'm missing the presentation file at the website, maybe put it up
> > there?)
> > Back then it sounded like you had things solved. What's the factor
> > that has been added to the problem?
> > The client interface?
>
> Firstly, you're assuming my presentation was for Shaun's project (though
> yes, I have done work for him in the past). That's not something I've
> said at any point. With that out of the way...
>
> >From my pov, there is a solution (small scale trialed but not yet prod
> tested!) to the distributed data part. It would seem Shaun's /current/
> requirements involve a little more integration into the existing
> enterprise GIS system (SDE), along with integrating a proprietary field
> solution. As far as I see it, those requirements aren't show stoppers
> by any means. From the requirements given, I can't see any solution
> that doesn't involve reasonable dev costs.
>
> FWIW, I believe a distributed postgis db (between site and central),
> using Mapguide as an interface at each site office is the most cost
> effective way of getting an "enterprise" type solution (with all the
> business baggage that entails). If anyone has any alternate suggestions
> that don't involve significant dev costs, I'd also love to hear them.
> Personally, I believe any solution in such a distributed environment is
> going to cost enough dollars to make it a budget item in its own right.
> There's a lot of dev, testing and tweaking to get everything going
> smoothly with the constraints you've got there Shaun. Unfortunately
> that means dollars.
>
> HTH,
> Tim Bowden
>
> >
> > Cheers,
> >
> > WBL
> >
> >
> > On Mon, Apr 14, 2008 at 11:37 PM, Shaun Kolomeitz
> > <Shaun.Kolomeitz at epa.qld.gov.au> wrote:
> > This is not strictly a PostGIS issue, but PostGIS could be one
> > part of
> > the solution (I think) ?
> >
> > I'm curious as to what the broader community thinks would be a
> > workable
> > solution for our spatial business problem from a FOSS4G
> > perspective.
> >
> > We have a broad area network of around 600 clients spread
> > across an area
> > of 1500 x 1900 km in the State of Queensland, Australia.
> > Primarily our
> > clients are Rangers and Resource Managers, managing their
> > "patch of
> > dirt" (Flora, Fauna, Fire, Pests, Assets, Visitor, Camping,
> > Heritage,
> > etc).
> > 150 or so are currently located on remote Satellite
> > connections (with
> > latency issues) reducing to 50 by the end of the year. The
> > rest are
> > split between NextG, ADSL and WAN type connections. Satellite
> > connections in particular may not be available in bad weather
> > conditions.
> >
> > In the past we've had ArcView 3.x as a custom client app
> > running locally
> > and now we're looking to the future.
> > The system is used in the office as a planning tool for field
> > activities
> > (such as a new fence, fire break, pest treatment) before
> > heading out
> > into the paddock.
> > Users collect (capture) a variety of information while in the
> > field
> > relating to the above activities mentioned (Fire, Pests,
> > Assets etc) and
> > send zipped shapefiles via email through our network of
> > contacts twice a
> > year to head office. At the moment only Fire and Pest info is
> > sent,
> > although we'd like users around the state to be more
> > collaborative (from
> > a data sense).
> >
> > The only real givens are that we'll have a corporate GIS
> > repository
> > storing all corporate data in an Oracle SDE db in head office,
> > and that
> > the users will be taking data with them into the field (no
> > connection to
> > ANY network).
> > I'm pretty sure we'll be using ArcPad as our field-based app
> > (on
> > handhelds and tablets/laptops).
> >
> > Our main business problems are -
> > 1) Providing a simple to use system which acts as a "portal"
> > to a range
> > of spatial and non-spatial data and systems relevant to the
> > users patch
> > 2) Simplifying (or automating) the update of data to/from the
> > park base
> > to the head office
> > 3) Managing data as it is "checked-out" for field use and then
> > "checked-in" after it comes back, while not providing too much
> > of an
> > overhead for the users
> > 4) Providing a basic GIS ability (similar to ArcView 3.x)
> > 5) Providing a means of integrating information in other
> > datasets (fire,
> > pests) and across other dbs (WildLife db) or applications
> > (Assets, etc)
> > 6) Providing multi-user access to individual datasets
> > 7) Providing redlining, markup and a collaboration type
> > ability
> > 8) Providing a standard look-and-feel to any client
> >
> > I'm happy to discuss further if need be.
> > As always any assistance would be greatly appreciated.
> > We are trying to work on a response to our executive within 13
> > days.
> >
> > Kind regards,
> > Shaun Kolomeitz,
> > Senior Technical Officer
> > Business and Asset Services
> > Queensland Parks and Wildlife Division
> > Environmental Protection Agency
> >
> +----------------------------------------------------------------+
> > Think B4U Print
> > 1 ream of paper = 6% of a tree and 5.4kg CO2 in the atmosphere
> > 3 sheets of A4 paper = 1 litre of water
> >
> +----------------------------------------------------------------+
> > _________________________
> > Disclaimer
> >
> > WARNING: This e-mail (including any attachments) has
> > originated from a Queensland Government department and may
> > contain information that is confidential, private, or covered
> > by legal professional privilege, and may be protected by
> > copyright.
> >
> > You may use this e-mail only if you are the person(s) it was
> > intended to be sent to and if you use it in an authorised
> > way. No one is allowed to use, review, alter, transmit,
> > disclose, distribute, print or copy this e-mail without
> > appropriate authority. If you have received this e-mail in
> > error, please inform the sender immediately by phone or e-mail
> > and delete this e-mail, including any copies, from your
> > computer system network and destroy any hardcopies.
> >
> > Unless otherwise stated, this e-mail represents the views of
> > the sender and not the views of the Environmental Protection
> > Agency.
> >
> > Although this e-mail has been checked for the presence of
> > computer viruses, the Environmental Protection Agency provides
> > no warranty that all viruses have been detected and cleaned.
> > Any use of this e-mail could harm your computer system. It is
> > your responsibility to ensure that this e-mail does not
> > contain and is not affected by computer viruses, defects or
> > interference by third parties or replication problems
> > (including incompatibility with your computer system).
> >
> > E-mails sent to and from the Environmental Protection Agency
> > will be electronically stored, managed and may be audited, in
> > accordance with the law and Queensland Government Information
> > Standards (IS31, IS38, IS40, IS41 and IS42) to the extent they
> > are consistent with the law.
> > ___________________________
> >
> > !DEPTSTAMP1!
> > _______________________________________________
> > 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
>
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20080416/0e2a6908/attachment.html>
More information about the postgis-users
mailing list