Technical Tidbits From Spatial Analysis & Data Science

Menu

Skip to content
  • Home
  • Intro R workshop
  • Spatial R workshop
  • Machine Learning R workshop
  • Home
  • Data Solutions
  • Training
  • Research
  • About Us
  • Tech Blog
  • Contact us

Month: June 2014

First taste of routing in PostGIS using pgRouting

Posted on June 18, 2014 by zev@zevross.com · 3 Comments

We have moved many of our geographic analyses to QGIS from ESRI’s ArcGIS but we have yet to find an adequate replacement for ESRI’s Network Analyst extension. Network Analyst, itself, can be clunky and tricky to use (not to mention expensive!), but it has enabled us to compute network buffers and minimum network distance fairly […]

Continue reading →

Use PostgreSQL’s ‘custom format’ to efficiently backup and restore tables

Posted on June 11, 2014 by zev@zevross.com · 5 Comments

PostgreSQL allows you to easily dump tables for backup purposes into plain text files using code such as: pg_dump mytable > mytable_backup.sql But this process is not very flexible and can create very large output files. As an alternative, PostgreSQL has a nice little feature that allows users to export to what is called a […]

Continue reading →

No ESRI, no problem. Manipulate shapefiles with the Python library gdal

Posted on June 9, 2014 by zev@zevross.com · 3 Comments

Although we still use ESRI products such as ArcGIS for geographic analysis, more and more we find ourselves turning to open source software like PostGIS and QGIS. In many cases, though, even PostGIS and QGIS are more software than necessary for a given task and we prefer to skip the ‘middleman’ in favor of the […]

Continue reading →

We can help!

We specialize in data analytics, interactive maps, data visualization and Shiny applications.

Learn more about us

Search blog posts

Subscribe to new posts by email

Follow us on twitter

Follow @zevross
My Tweets

Categories

  • D3
  • Data Visualization
  • Database
  • GDAL
  • ggplot2
  • GIS/Maps
  • Graphic Design
  • JavaScript
  • LeafletJS
  • Markdown
  • PostGIS
  • PostgreSQL
  • Python
  • R
  • Regular Expressions
  • Shiny
  • Spatial
  • Uncategorized
  • Web Development
  • Web Mapping

Recent Comments

  • hollie@zevross.com on Tips and tricks for working with images and figures in R Markdown documents
  • Will D on Tips and tricks for working with images and figures in R Markdown documents
  • Dima on Convert Procreate illustrations into web-friendly svgs for interaction and animation
  • zev@zevross.com on Creating beautiful demographic maps in R with the tidycensus and tmap packages
  • Alex on Creating beautiful demographic maps in R with the tidycensus and tmap packages
© 2019 Technical Tidbits From Spatial Analysis & Data Science
Powered by WordPress & Themegraphy
ZevRoss Spatial
Analysis
209 N. Aurora St, 2nd Floor
Ithaca, NY 14850
607-277-0004

info@zevross.com