If you are like me, you love writing spatial SQL. But what can you do if you have a geodatabase, some shapefiles, or any other data...

A friend recently asked me about the cool looking bivariate maps produced with ArcOnline, lamenting that the capability seemed lacking...

I wanted to revisit the taxi data example that I previously blogged about.  I had a 6GB file of 16 million taxi pickup locations and 260...

Do you have a set of lines that you need to determine if there are any “dangle” nodes?  A dangle is a line segment that overhangs another...

I was interested in creating mult-ring buffers but with a twist: I didn’t want the buffers to overlap one another.  In other words, if I...

Sure you can solve it with a few for loops,  inserting the results into a new table, but that really is a hassle.  Also, I have to do it...

Continuing my series on big data geoanalytics, I wanted to show how to bring in large data sets so that we can start working with them....

In my last video, I gave a short of mile-high view of how SQL can be used for big data geoanalytics.  I want to dive a little deeper, and...

I’m getting ready to create a course in big data analytics with GIS.  I have lots of ideas as to what to do, but one thing I know is that...

The TuGIS training workshop on March 20, 2017 is completed – you can see the workshop evaluations below: The workshop evaluations are in...

previous video, I showed how Radian studio can read data directly from PostgreSQL, SQLite, and also easily exchange data between them.  ...

#TUgis2017) is on March 20/21, 2017.  I first attended TUgis in 1990, and it is always a great conference.  It is not too large, so it is...

GIS Programming students presented their programming projects to ESRI. First, I cannot say enough to thank ESRI for taking time out of...

CLICK TO VIEW Jeff Scarmazzi presenting on h0w to create editing rules and triggers using Postgres and PostGIS Today I want to introduce...

UMD provided me with enrollment numbers, and we are getting a pretty full class.  However, a few people on the “outside” have asked for a...

Well, even though you didn’t ask for it, I decided to create a k-nearest neighbor analysis in PostGRES/PostGIS.  This has lots of...

I wanted to give you another look at some features that Radian Studio will offer. I’ve shown how we can use SQL to replicate the ARC/INFO...

How I used SQL to generate an accumulated sum of spatial data My friend Tomas does work with business analytics, and wanted to find a way...

A friend recently asked me to help him generate polyline shapefiles with Z and M values that he could deliver to a customer.  The problem...

As most of you know, I am a big fan of spatial SQL.  It is my go-to tool whenever working with GIS.  But, I have seen too many people...