[Manifold-l] HELP ON PLAN OF ATTACK

[Simon Greener (SpatialDB Advisor)]

Richard,

It would help if we could get some idea of the data items on each of
the spatial data objects.

So, for example, where is the lid and invert level data stored?

To get invert levels at the end of each pipe I would have thought
spatial SQL statements might be the best and first initial attack
on bringing the data together into the cohesive form they want.
Also, SQL is easier to write, share (on this formum), and correct.
Only resort to scripting and manual work when all SQL avenues have
been exhausted.

regards
S
On Tue, 11 Jul 2006 09:57:16 +0100, Richard Sands  
<richard.sands at bigpond.com> wrote:

> I have to present a survey I undertook of sewer/ stormwater lines to a
> client in GIS format.
> I have ASCII files of all the points (NEZ,Codes), AutoCAD drawings of all
> points, lines and symbols (manholes/ gully pits etc).
> I am not sure the best approach to utilise my data.  They want manholes
> (point data) to contain elevations of the lid and inverts, pipes  
> (linework)
> to have inverts at both ends and grade as well as upstream/ downstream
> manhole numbers.
> I'm not asking for a blow by blow, but just a few pointers as to how to
> automate some of the processes - I expect scripts would work - but my
> knowledge of such is those you take to the chemist to supposedly help you
> get better.  That said I'm willing to learn.
> This is an interesting challenge and has highlighted the inadequacies of
> survey software (mine anyway) and the gulf between such and GIS.
> As a side note I am putting all my survey data into Manifold now and
> building up a rather extensive data base - one thing GIS does a lot  
> better
> than survey software - its very good.
> regards  Richard
>
> Richard Sands
>  Registered Surveyor
> 2175 Sheffield Road
> SHEFFIELD 7306
> Tasmania
> richard.sands at bigpond.com
>
> _______________________________________________
> Manifold-l mailing list
> Manifold-l at lists.directionsmag.com
> http://www.directionsmag.com/mailman/listinfo/manifold-l



-- 
--------------------------------------------------
Simon Greener
SpatialDB Advice, Solutions Architect,
Oracle Spatial, MYSQL, PostGIS and Manifold enthusiast
Allens Rivulet, Tasmania, Australia.
Voice: +61 3 62396397
Longitude: 147.2048
Latitude: -43.0141