top of page
Search
Virtual layers with QGIS – wait a second, this is starting to look like Manifold…
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...
artlembo
Sep 18, 20191 min read


Easy bivariate map with Postgres
A friend recently asked me about the cool looking bivariate maps produced with ArcOnline, lamenting that the capability seemed lacking...
artlembo
Mar 14, 20193 min read


Big Data Results
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...
artlembo
Oct 16, 20185 min read
Finding “Dangles” with PostGIS
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...
artlembo
Jul 7, 20182 min read


Multi-Ring (non-overlapping) Buffers with PostGIS
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...
artlembo
Jun 22, 20181 min read


GIS Analysis of Overlapping Layers
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...
artlembo
Jun 19, 20181 min read


Big Data GeoAnalytics – adding data
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....
artlembo
Nov 30, 20171 min read


Big Data GeoAnalytics – Turning Points to Lines
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...
artlembo
Nov 21, 20171 min read


Big data geo-analytics with SQL
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...
artlembo
Nov 20, 20171 min read
Maryland State GIS Conference (TuGIS)
The TuGIS training workshop on March 20, 2017 is completed – you can see the workshop evaluations below: The workshop evaluations are in...
artlembo
Mar 26, 20172 min read


Radian can read ESRI geodatabases
previous video, I showed how Radian studio can read data directly from PostgreSQL, SQLite, and also easily exchange data between them. ...
artlembo
Mar 1, 20171 min read


Workshops at the Maryland Geospatial Conference
#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...
artlembo
Jan 27, 20172 min read


Undergraduate Geospatial Python Projects
GIS Programming students presented their programming projects to ESRI. First, I cannot say enough to thank ESRI for taking time out of...
artlembo
Dec 17, 20164 min read


Advanced Editing Capabilities with PostGIS
CLICK TO VIEW Jeff Scarmazzi presenting on h0w to create editing rules and triggers using Postgres and PostGIS Today I want to introduce...
artlembo
May 26, 20162 min read
Open Source GIS Course at UMD – the Syllabus
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...
artlembo
May 18, 20163 min read


k-Nearest Neighbor with PostGRES
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...
artlembo
Apr 26, 20163 min read


k-nearest neighbor with SQL in Radian Studio
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...
artlembo
Apr 26, 20162 min read


Trade Area Analysis in Postgres / PostGIS
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...
artlembo
Apr 20, 20164 min read
SQL and ogr to create 4D lines
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...
artlembo
Apr 19, 20162 min read


Doing a GROUP BY in ArcGIS
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...
artlembo
Jul 13, 20151 min read
bottom of page