About
Dr. James E. Marca earned his PhD in transportation engineering from the University of California, Irvine in 2002. He started working with PostgreSQL and PostGIS at that time to stash and process GPS data collected from in-vehicle data collection units streaming data over CDPD wireless modems. He continues to use PostgreSQL as a data store for research projects and websites, and has connected to PostgreSQL from Perl, Java, JavaScript, Python, Elixir, and R. Some of that code is available on github (https://github.com/jmarca)
James E. Marca has presented the following presentations
Using PostgreSQL and Friends for a Street Sweeping Solver Project
at
Postgres Webinar Series
presented by James E. Marca
video
In responding to an RFP to optimize and improve street sweeping routes for a small city in California, we developed a solver based on Google's Operations Research Tools. While the guts of the solver uses OR-Tools, virtually everything else about the project is made possible by PostgreSQL, PostGIS, and pgRouting.
In this presentation, I talk about the various ways PostgreSQL and friends made ...
more Wed 21 2020 Case Study
Using PostgreSQL, PostGIS, and pgRouting for street sweeping
at
Postgres Conference 2020
Load, clean, store, and animate OpenStreetMap data for a street sweeping route-optimizer project
presented by James E. Marca
In responding to an RFP to optimize and improve street sweeping routes for a small city in California, we developed a solver based on Google's Operations Research Tools. While the guts of the solver uses OR-Tools, virtually everything else about the project is made possible by PostgreSQL, PostGIS, and pgRouting.
In this presentation, I talk about the various ways PostgreSQL and friends ...
more Case Studies
That SQL looks pretty complicated. Where are the tests?
at
PGConf US 2016 [PgConf.US]
presented by James E. Marca
My standard development technique with PostgreSQL is to hack away in Emacs, try things out on live data, and eventually build up working queries and functions. This "test as you go" approach works well for small projects, but for really hard problems the result is usually hundreds of lines of SQL that looks a lot like an object lesson in unmaintainable code. Old hackers can learn new tricks, an...
more Development