[postgis-users] FOSS4G Architectures/options for Distributed DBs

Brent Wood pcreso at pcreso.com
Wed Apr 16 11:42:09 PDT 2008


Hi Tim,

Just one point, you suggest Mapguide as part of the solution, I'm not sure if
you mean Mapguide OpenSource (as a FOSS package) or Mapguide Enterprise/Studio
(commercial packages sold by Autodesk IIRC).

Given the FOSS based discussion, I'm assuming the OS version, but figured this
is worth clarifying.


Cheers,

  Brent Wood 


--- 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
> 




More information about the postgis-users mailing list