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

Tim Bowden tim.bowden at westnet.com.au
Wed Apr 16 17:42:24 PDT 2008


On Wed, 2008-04-16 at 11:42 -0700, Brent Wood wrote:
> 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.
> 

By default I'm assuming MapGuideOS, though I guess that's a call for the
client to make.  It also depends on being able to put a "business
solution" support contract in place that covers MapGuideOS.  I don't see
that as a significant obstacle.

Regards,
Tim Bowden
> 
> 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
> > 
> 
> _______________________________________________
> 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