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
225 views
0 comments
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
605 views
0 comments


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
282 views
0 comments


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
73 views
0 comments


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
17 views
0 comments


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
24 views
0 comments
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
6 views
0 comments


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
5 views
0 comments

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
294 views
0 comments


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
235 views
0 comments


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
36 views
0 comments


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
25 views
0 comments


New Books – How do I do that in PostGIS, How do I do that in Manifold SQL
I have two new books out – How do I do that in PostGIS, and How do I do that in Manifold SQL. From the back cover of How do I do that in...
artlembo
Jun 26, 20151 min read
46 views
0 comments


Spatial is Not Special – Quadrat Analysis
In our book we illustrated the use of quadrat analysis for determining whether points were random, clustered, or distributed. Figure...
artlembo
Jun 8, 20142 min read
35 views
0 comments


Spatial is Not Special – Nearest Neighbor Index
It is nice to get back to the book, and start talking about Statistical Problem Solving in Geography again. Today we are going to look...
artlembo
May 30, 20142 min read
26 views
0 comments


ARC/INFO Functions in SQL – Line Density
Dale posted a request to see Line Density recreated in SQL. Please take a look at the ESRI help topic for line density. I will warn you,...
artlembo
May 28, 20142 min read
6 views
0 comments
ARC/INFO Functions – Symmetrical Difference
I was recently asked by danb to illustrate the ARC/INFO function symmetrical difference. We basically want to find those areas in layer A...
artlembo
May 26, 20141 min read
15 views
0 comments
ARC/INFO Functions – UNION
We are going to conclude our overlay posts with the ARC/INFO UNION command. This should be a lot easier than it actually is. I think...
artlembo
May 23, 20142 min read
12 views
0 comments


ARC/INFO Functions in SQL – IDENTITY
The ARC/INFO IDENTITY operation seen here is sometimes confusing because it takes ALL of the Input feature, and the part of the IDENTITY...
artlembo
May 20, 20142 min read
16 views
0 comments


Spatial is Not Special – Spatial Interaction completion
We’ve spent some time looking at how to create spatial interaction models using PIVOT tables and spatial constructs in SQL. The one last...
artlembo
May 14, 20141 min read
1 view
0 comments
bottom of page