Working With Spatial Databases With GeoAlchemy

Video in TIB AV-Portal: Working With Spatial Databases With GeoAlchemy

Formal Metadata

Working With Spatial Databases With GeoAlchemy
Title of Series
CC Attribution - NonCommercial - ShareAlike 3.0 Unported:
You are free to use, adapt and copy, distribute and transmit the work or content in adapted or unchanged form for any legal and non-commercial purpose as long as the work is attributed to the author in the manner specified by the author or licensor and the work or content is shared also in adapted form only under the conditions of this license.
Release Date
Production Place

Content Metadata

Subject Area
GeoAlchemy helps you use spatial databases from Python. GeoAlchemy provides extensions to SQLAlchemy, the Python SQL toolkit and ORM. GeoAlchemy builds on SQLAlchemy's extreme flexibility, and can be used for different types of applications, from simple scripts to complex web applications. In this talk we will present GeoAlchemy and SQLAlchemy. We will describe when and how SQLAlchemy and GeoAlchemy can be useful. We will demonstrate the power and flexibility of the tools. We will also present the new version of GeoAlchemy, namely GeoAlchemy 2. GeoAlchemy 2 enables leveraging PostGIS' new features. For example, GeoAlchemy 2 supports PostGIS's new raster type. Finally, we will demonstrate how GeoAlchemy integrates with other well-known Python tools, such as Shapely.
Area Installation art Slide rule Programming language Group action Sequel Multiplication sign Video game Quicksort Figurate number Library (computing)
Web 2.0 Scripting language Sequel Projective plane Video game Video game Software framework Cartesian coordinate system Geometry Spacetime World Wide Web Consortium
Arithmetic mean Sequel Internetworking Decision theory Software framework Database Software framework Database Escape character Figurate number Abstraction
Dependent and independent variables Theory of relativity Process (computing) Decision theory Software developer Query language Prisoner's dilemma Software developer Decision theory Range (statistics) Relational database Form (programming)
Scripting language Email Regulärer Ausdruck <Textverarbeitung> Link (knot theory) Key (cryptography) Relational database Core dump Coma Berenices Cartesian coordinate system System call Causality Query language Object (grammar) Order (biology) Object-relational mapping Moving average Energy level Right angle Object (grammar) Endliche Modelltheorie Table (information) Physical system Library (computing) Address space
Digital filter Buffer solution Software framework
Greatest element Multiplication sign Area Web 2.0 Bit rate Semiconductor memory Buffer solution Zustandsgröße Predictability Area Covering space Scripting language Sequel Repetition Point (geometry) Bit Pi Raster graphics Moving average Whiteboard Geometry Arc (geometry) Point (geometry) Functional (mathematics) Line (geometry) Disintegration Electronic program guide Field (computer science) Product (business) Revision control Causality Term (mathematics) Representation (politics) Software testing Summierbarkeit Condition number Projective plane Physical law Core dump Client (computing) Cartesian coordinate system System call Uniform boundedness principle Personal digital assistant Function (mathematics) Network topology Revision control Object-relational mapping Video game
but they did feel very well thanks for of attending the stops at some of that there is and their competition this morning with the but it is thought commemorating the figures from the Bank of majority in the midst of so many misery and steam still said and so today going to talk about the Jewish Jimmy library which is by far the and you can find my slide on 9 at this year or the industry and time the so what is it you have me so that the definition and celebrity for using sequels spatial that from by so that they could they would 2 so far so we have posted persisting with said the main open sold a showed that it is that there is the 1 we all love a year used by many people in the area of the many featured those manufacturers and a day that my and we by and by the end is is nice Programming Language that people use because it's become a very popular 1 which and especially in the G ideas that killed a we of many libraries and many great stuff where implemented in the UK for example I the shipping chip worry which is the written and the real life from the likes of retirees and we have many more Brooksy and which was so is the greatest of where the that we and you can find and there is also an official by firm the regulatory where you can find packages and everything is in the sort of the storey which makes it very convenient to download and instal by thousands of ppp so we are great great whose with 5 and 6 and now we need good way to could libraries to be able to use but it is from by and that's exactly tourism why we are developing a Jewish to to use spatial that uses and name but this from the combined group but there is another big
projects and very well known projects and that does that the idea this is a general and dango as G would general inside the geological brings the geospatial stuffed into general the we and 1 that we can wonder why and in general there is on orange and the Far and works for which he was generally works for she over geometry so
yes it's great Django is great for that it's not it's not everything in the stock but there is something else the generally is a Web the where framework and we want to be able to use sequel space showed that everything from by but outside Fault also for on with applications for example you may need to write the script for data and that it is all for the visit found this is just script you don't want food with applications and download is really away framework for the you don't want to instal Django and you during the just to write a dead end and in his script for example and also found that out of a very interesting way framework of their life when
they were as anyone heard about last multiple and tourist while the people of yes that's that through the also very great great friends with lots of beaches and the of but those are more on the way there might micro from with that not all of them are micro but more on on the side compared to the general and in the figure of the Lebanese the don't at the opinions on the estuary sequel to keep the you use with a framework for the day and stick to that competitive general which comes with which its own far and self and people who use and tyranny both and last day closer used as a means to of escape Kimi is a general purpose as you have to keep by don't make such as the Union during the duet these days on the general struggles to and there are good reasons to love to the said this would keep it said it found that the use of self where very very very flexible much more flexible than any other foreign by an orange jangle saying some way to prevent a debt sequel came out to its so that decision is that that is to give of and and
way to talk about it says other thing because it's very Bolton to know of the of the of the groundwork it's very different from from other to put it so as opposed to most of the foreign that we find out on the internet this 1 is not about Abstracting the database at because Abstracting is fighting and it is true that she needed someone to hide and that that and its from from you it's more about what the nation which
means that you as a developer instruct as a knee to the ground where you need it so it's your and and their relations no 4 of the data is completely prisoner so as to
provide a range of February to express decisions made by their which means fixture responsibility to build the queries but to know about the relation Falmouth show they are accessory you will you would need to do job of England query theatre it on your own As 2nd does he viewed the tools to to be able to to do that in a in so
that's that was the best of the of the minority and now along in the UK if they turn out of the library and the very there is to see there is the cause and the Tories denotive players and it's a essentially an extra expression systems so you can be the the key right eschewal in but with a very nice construct and on top of that there is no objective relation of by foreign which most people know what it is and this 1 is the of this film on the cause of that you can use 1 on the order of each you build a very high level Applications like away the where the application you would probably use the but if you just want to write a script for the and that it is all for manipulating the coping data from 1 table to another things like that you can use the call and the 1st by using the called you can get a bit of profound to some people start with the Orange and when they need to be when the 2 of the very far from queries then this which to the call the amount of home Serbia is an
example of an extra me where you are so this 1 uses the your because we can see that this is that this is the 1st of these is grid based on on objects that object model so this is where I would join so so we conceded the is explicit here so it's a joy between user and accurate and this is that it too is a very nice way to write in and out of her I would like that so that your knees
of your Hume's actually very thin very thin layer of both the me as a genius is very very flexible it's a framework on to which you can you can held so that the reason Jewish and he is just a book early amid all this it as the same because the team I don't know so there is and
that you can equerry example so it's verisimilitude sold at previous life agree with the theatre and in size the field so we can see some of these as the about her as the area to the stories of these grid and late who was a Rolls of area and that the rate of 33 because of so to reduce the risk meet in the pub or the excited it but book and also you have to meet integrate well with over by an area of for example Shipley and the ship the idle Makino shifting its so it's about and rapper of Geos Geos geometry naira and geoengineering poses to shape and from state functions to be be able could to 1 of Hewitt me geometry is to shift the German trees and the German geometry is that you are so in this example a used the same inquiry has as reducing and then a can use it to save function cover again they which is a teacher and later by the Germans and a and some of this geometry to a ship via geometry to accept the Germans and then my Daniels everything that that should be suitable for example here this example Eiffel the representative for of sunshine palms on these geometry and then can get the w Katie representations of these the so this is this is very very simple and very very far just a quick status are on the project of we really is version to 6 months ago that this is the condition of his early is a completely new audiences of which benefits from the latest Adams's of the as a new project we which makes it even think it's a very thin layer even in the face of earth of the has been has been improved and now which works with both the cause and the bottom of the inning and it was not the case before it would only work with the law and so which means that no Jewish and he is a very good candidate for writing scripts and that many of the dead and predictions scripts for for budget and we know simple but just to to eye which was actually a reason for for these new version of the show or even of the of the of the human and ways for all of the time that it was just also the which means geometry during the and even for the rest new time we the rest of the board was worth as some of its recent and those who would like to emphasise that the project is treated him and and this is where we are 100 per cent coverage by like tests and we of food documentation with tutorials to once oils once total over the call and another 1 for the Arc and the food but the Irish of but at every stage and fine of the condition that the stock now
in terms of exposure of the the project the memory is used in the production of both the FA of the show and the 2nd version of its use by the from 18 December project that we do at Kempton most of all projects are very thin on the Irish and there is also the skyline project that you can find on the Web this is the application is that the kitchen is a bit on the side of versions of during the and it's written by its the books about it is the the end of the year is a German guide and is being very helpful working on the on Jewish need to save 1 of the main point of contact details of the further cities
thank you very much for pension and there are many questions that need to be of so


  321 ms - page object


AV-Portal 3.20.2 (36f6df173ce4850b467c9cb7af359cf1cdaed247)