Add to Watchlist

CartoDB, and maps out of the Schemaverse

2 views

Citation of segment
Embed Code
Purchasing a DVD Cite video

Formal Metadata

Title CartoDB, and maps out of the Schemaverse
Title of Series PGCon 2013
Number of Parts 25
Author PGCon - PostgreSQL Conference for Users and Developers
Contributors Heroku (Sponsor)
License 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.
DOI 10.5446/19043
Publisher PGCon - PostgreSQL Conference for Users and Developers, Andrea Ross
Release Date 2013
Language English
Production Place Ottawa, Canada

Content Metadata

Subject Area Computer Science
Abstract Lightning talk from PGCon 2013.
Series
Annotations
Transcript
Loading...
but that's not the case so that the stock was to pose to be about getting 2 the tends to about party
companies in open source software is geospatial data is in the problem that you do not out of prosperous 12 basically puts equal and that's out of bad at all the last 2 hours I decided to take the torque and I was considered how
to make in that very quickly using sequel and CSS but
I so the only at a glance this universe presentation I think would be collected to make money out of the universe so that we can be doing and 1st we have this is very very
the fact in the last 2 2 hours very so the 1st steps was meters exported all the planet data and we exported all the data of the ship flight recorder and so just to get a bit of an idea and those who don't know what the numerous so this is just a bunch of ships currently flying around and the coordinates threat and that's going well that's not really loading anyway so not missing much they don't work that well although I will be done by many ways so luckily we have
this year and would get x 40 readers exported
CSB and that level of origin so moving along
I I swear that data looks
great OK so but hopefully the lack
of a lot of things so this is really what we wanted to do is to see if we could visualize that they got so what is loaded basically all
parts the so the way we did that is by and this is in the you can just drag and drop the file
that we created before you can also connect it bad and then there is this 1 right to this 1 so those are the planets and discomfort
entropic and I would just break new table on this continuity account and basically you have the latitude and longitude unions in the sequel but basically there's position for every planet we transform it into a fake geographic locations and we're going to do a map of the so because the the of the much more
to 0 yeah it's funny so they so that they based their you can just
click on the map view and it would be very nice map here that well what we wanted to see if it was not the plan as we wanted to see actually there's a this it's moving and what we did this is we loaded into this all the table is flight recorder and we have 1 record per it's the bird location so ships are moving so we have these these said Colin called talked with basically is like the time so what we have is 1 full day of data of 6 moving trying to tackle the plan and what we did this was this and put it on 2
and 1 of the colleges libraries and there's a lot to this animation so what you see here is that 1 day and is 1 of things moving at the everyday debate every spots so you see now it's going and that's basically forming players but along with this later with the compared to the to the other models have already but this analysis starting that they they see that they establish the different parts of the map of how the fact expanding they have the free ones are very clear they have a very clear strategy just trying to spend as fast as they can when all the you can see and the policy here we can see so you can see others have like this once these guys here like trying to move as fast as he can from 1 place to another so yeah and this is this is how it looks like there's that come with so the map of the so this is parity map
what went on in the in the where they all came from as far as everyone coming from different areas 1 person in the middle and then you get right down to the bottom right with the equivalent this 1 again and so you
and know and the meaning of expanded where they are now and the that they point right so this is a very quick demo that with this weapon and of the number needed on the last 2 hours but if you're interested in learning how to map out of data at the parties agreed to doing that and we we can visualize really large amounts of data and in you know the most over time but also like you just need to make a new there's static is studied and you can also make that basically is based on PostgreSQL and posterior so there's anybody interesting on talking about how to how posteriors worsens while we were working a lot on so we're interested always you know in the kind geographical mapping and and your but you might want to build the correct
Metropolitan area network
Computer animation
Personal digital assistant
Personal area network
Grand Unified Theory
Gamma function
Uniform space
Router (computing)
Metropolitan area network
Computer animation
Open source
Software
Sequel
Commodore VIC-20
Torque
Graphical user interface
Gamma function
Metre
Metropolitan area network
Electronic data interchange
Computer animation
Presentation of a group
Commodore VIC-20
Computer file
Universe (mathematics)
Bit
Grand Unified Theory
Gamma function
Hand fan
Metropolitan area network
Duality (mathematics)
Computer animation
Sine
Energy level
Gamma function
Metropolitan area network
Computer animation
Graph (mathematics)
Computer file
Storage area network
Metropolitan area network
Email
Electronic data interchange
Computer animation
Computer file
Graphical user interface
Gamma function
Mereology
Metropolitan area network
Electronic data interchange
Computer animation
Mapping
Sequel
Commodore VIC-20
Division (mathematics)
Graphical user interface
Right angle
Analytic continuation
Position operator
Table (information)
Plane (geometry)
Metropolitan area network
Uniform resource locator
Computer animation
Mapping
View (database)
Multiplication sign
Java applet
Planning
Graphical user interface
Gamma function
Table (information)
Area
Metropolitan area network
Electronic data interchange
Mapping
Parity (mathematics)
Scientific modelling
Mathematical analysis
1 (number)
Mereology
Equivalence relation
Computer animation
Strategy game
Graphical user interface
Right angle
Gamma function
Library (computing)
Metropolitan area network
Arithmetic mean
Electronic data interchange
Computer animation
Mapping
Multiplication sign
Graphical user interface
Gamma function
Posterior probability
Number
Loading...
Feedback

Timings

  473 ms - page object

Version

AV-Portal 3.8.0 (dec2fe8b0ce2e718d55d6f23ab68f0b2424a1f3f)