Skills Demonstrated
- Webprogramming
- Spatial databases
- SQL
- Python
- SVG
SVG Webmap using the Oracle Database
I was tasked with extracting spatial and non-spatial data from an Oracle database in order to display it on the web using CGI protocol. The map data is retrieved by a python script which accesses the Oracle database and queries it with SQL queries. The python script displays the data on a web server (the webmap is created on-the-fly).
A SVG map of archaeological finds and the fields where they were discovered was created. The webmap is interactive (hovering, clicking and display/hide layers) which is programmed in JavaScript.I wrote the main code in Python and used the cx_Oracle module in order to connect to the database. The SQL queries embedded in the Python script were in charge of retrieving the data.
Once the data was stored in a variable, I implemented different loops in order to display certain information and to draw . I used HTML and CSS for the overall design and styling of the page.
« Back