Uniform Internal Data

GIS USER GROUP
1

Hi all

Does anybody using Earthlight have a robust way to extract daily, internal data such as planning polygons from Uniform (IDOX). We had to move from our previous script a few years back to a python script which was okay for a while but is currently pulling through all the textual data, but not all the spatial data - there is missing geometry. We are checking the script and the Uniform table names to check if anything has changed.

Any scripts that append tables as well would be greatly appreciated.

Kind regards
Scott

2

Hi Scott

We extract data from Uniform and import this into Earthlight.

The flow is as follows:-

  • The python scripts run to generate the shape files.

  • The “DataPump_Uniform_data_import.bat” then runs to launch Datapump and
    runs the “Uniform_Imports.script” to handle the import. It then takes the data from the created shapefiles and imports them into tables in Earthlight, this is handled by the source files to define the fields to pull.

Ive not included the SDE or ODC files as these contain our connection string info. Each time it runs all the data in the earthlight table is removed and then re-imported.

This forum does not allow me to upload zipfiles, so if you can provide me with your email address, I can then forward on our scripts in a zipfile.

Thanks

Steven

3

Hi Steven

Thank you for your help with this. My email is scott.hales@fdean.gov.uk

Kind regards
Scott