The Manager's Guide to PostGIS - Paul Ramsey at FOOSS4G 2014 PDX

Interesting talk by Paul Ramsey about the decision process to adopt PostGIS vs other spatial databases at FOOSS4G 2014 Portland, OR. Ramsey, "what do managers need to know before they can get comfortable with the idea of making the move."

Comments

Post a Comment

Popular posts from this blog

Update WPF Interaction Triggers in from .Net Framework 4.8 to .Net 5

  When migrating the Visual Studio projects from .Net Framework 4.8 to .Net 5, you may encounter   in the following error regarding Interaction.Triggers .   Error      XDG0008             The name "Interaction" does not exist in the namespace "http://schemas.microsoft.com/xaml/behaviors".   The one solution to fix it is to install “ Microsoft.Xaml.Behaviors.Wpf ” from Nuget And update the namespace ( if needed) xmlns : i ="http://schemas.microsoft.com/expression/2010/interactivity" to              xmlns:i ="http://schemas.microsoft.com/xaml/behaviors"
Read more

Extract Raster Values from Points

The R blog article encourages me to write this solution to extract Raster values from points in R. In geospatial analysis, extracting the raster value of a point is a common task. If you have few raster files or few points; you can extract the raster value by overlaying a point on the top of the raster using ArcGIS. What will you do, if you have hundreds of raster files and thousands of points? The easy solution is use loop in Python and ArcGIS. Is loop efficient to use? No. Can loop be avoided? Yes. Then how?  Follow the steps: Step 1: Create a Raster stack or Raster brick of your raster files using “raster” package in R . For example: rasStack = stack(raster1, raster2,raster3 …rasterN) Step 2:   Read point data, and convert them into spatial points data frame. Sample: pointfile.csv Point_ID LONGITUDE LATITUDE 1 48.765863             -...
Read more

Choropleth mapping techniques for Web2.0

Image
For my recent project, I have to display county wise time series data of disease pattern in web map for the conterminous United States for 20 years. In addition, I have to use Google maps as base layer and should overlay images on the top of it.  The concept sounds easy, and it was also similar with choropleth or thematic mapping . However, it should be in the Web 2.0. I tried to figure out what are the possible ways to achieve this, I tried and few of them. Here I am going to share the pros and cons of these methods in a real quick and dirty style. Choropleth with GFT 1) Google Fusion Tables Pros: Easy, No understanding of computer programming needed. Upload small or large data sets from spreadsheets or CSV files. Visualize your data on maps, timelines and charts. Pick who can access your data; hide parts of your data if needed. Merge data from multiple tables. Cons: Not much flexible and you can’t tweaks easily according to your needs.  Choropleth with Car...
Read more