[postgis-users] FOSS4G Architectures/options for Distributed DBs
Tim Bowden
tim.bowden at westnet.com.au
Wed Apr 16 17:38:18 PDT 2008
On Wed, 2008-04-16 at 12:38 +0200, Willy-Bas Loos wrote:
> 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.
There is an ESRI solution that will do the job. The problem with such a
solution is the cost. Given the network bandwidth/latency/connectivity
issues Shaun has mentioned means having remote sites do editing of data
located on a central site is a recipe for disaster imho.
If the data is being generated at the remote sites, and used at the
remote sites, I believe your best bet is to have a data repository at
the remote site to enable local editing. The data is then replicated to
central where most of the activity would presumably be reporting type
functions. As such, delayed (or asynchronous) updates is manageable so
long as you know when you last replicated.
If such requirements can be answered without significant dev costs, I'd
love to know how.
Regards,
Tim Bowden
>
> 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
>
>
> _______________________________________________
> 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