150 likes | 286 Views
E N D
This document has been produced with the financial assistance of the Estonia – Latvia – Russia Cross Border Cooperation Programme within European Neighbourhood and Partnership Instrument 2007 – 2013. The contents of this document are the sole responsibility of Tartu City Government and can under no circumstances be regarded as reflecting the position of the Programme, Programme participating countries, alongside with the European Union Software specifics and future possibilities, cooperation with Estonian University of Life Sciences within GreenMan Project Rauno Külavee Tartu City Government Project coordinator
TableofContents • Briefoverviewof RED program • Everydayusageoftheprogram / implementationpossibilities • Issuesregarding RED program • Futuresolutions
RED overview Purposeofdesign: • Toensurecross-usageofspatialdatainsidecitygovernmentintranet • To grant accesstodatafromeverydepartment • Toensureexchangeofdatabetweendepartments
RED overview • Spatialdatastoredinspecialapplicationshadtobetransferredto RED withcertaininterval (usuallyeverynight) viaexport-importmodules
RED overview • Datacanbeinserteddirectlyto RED database • Withregardsto a moresimpledatamodel, thiswasthepreferred variant. • Userinterfaceoftheprogramiswrittenspecificallyfor Tartu City Government, orderedby a localsoftwarecompany. • City Governmentgaveinstructionsbeforehand
RED overview • Presently 2nd versionoftheprograminuse (2002) • Uses ODBC link viaOracledatabase • Number ofsimultaneoususersunlimited • Programis a bitold-fashionedalready. Weplantochangeitorrenewit, whichwouldenableimplementationpossibilitiesof present dayGIS-solutions.
Everydayusage • Possibletolog on indifferentrole • Spectatoror • Dataentryclerk • Possibilitytoviewdatainsertedbydifferentdepartments Publicparks & citycleaningservice: • Basic plans/maps10+ • Oftenusedmaps: • 1) 1:5000 • 2) 1:2000 • 3) 1:500 • 4) Ortomap2012 mai / 2003 versioon (demo Tähtvere park)
MapusedbyPublicparks & citycleaningservice • (EKRAAN- view, demo) • ca 30 classesofobjects (inclmaintenanceclasses) • Objectclassesaddedbyadministrator • Objectscanbeinsertedbydepartmentworkersbythemselves • Bordersofplotsofland (lots) alsovisible
Mostoftenusedfunctions • Objectinsertion/adding • 2nd classarea Marja 26B • Insertionofbench, playground, trashcan • Object number 12.1 2) Objectdataviewing 3) Objectdatachanging
Sagedamini kasutatavad funktsioonid 4) Specificationofmaintenanceareas 5) Inspectionoflandplotborders(changingdonebydifferentdepartment) 6) Checkingofintendedpurpose 7) Viewingownershipdataoflandplots (linnakrunt) 8) Nõlvaku street, Uus class & III klass (borderschanged)
Benefits • Insertedobjectsviewableby all RED users (differentdepartments) • Systemhasbecomeverycomfortableovertheyears • Possibletoaddadditionalobjectclassesifneeded • Facilitatespreparationofprocurements
Issues • Problemwithdatastoredindifferentdatabasesusagein RED environment (nationaldatabases) • Checking, ifdata import includesdata loss, thedataisnotaccepted and isofferedviaothermeans • Someimportantdataofferedvia WMS servicebut RED unabletousethatservice.
Issues • Uncomfortablezoomingcapability • Intranetsystemonly • Made forusageby Tartu (and Tartu City Gvtisnottheownerofthelicence)
Issues • No directmeanstopublishcurrentlyavailabledataontothecityweb-basedmap. Would need extrawork. • RED cannotofferorusethe WMS. (webmapservice). Dataexchangeoverthe net possibleonlyviaspecialprograms
Futuresolutions • Cooperationwith EULS withinGreenManproject, tofindthesolutionthat suits all partner cities – eithersoftwareorapplication • Oneversion on thePostGISplatformalreadyexists. FurtherdevelopmentofGeoArchiveapplication • Alsooneversiontodevelop/implementnewapplications • Our aim ispublishingofgeo-data on thecitywebmapviafastmeans.