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...
top of page
Search
artlembo
- Feb 21, 2019
- 2 min
Engaging students with multiuser editing, and FOSS4g
A friend is doing some research on estrogen and estrodial in water samples in Delaware. We have about 50 sub-watersheds that show the...
16 views0 comments
artlembo
- Oct 16, 2018
- 5 min
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...
132 views0 comments
artlembo
- Jul 7, 2018
- 2 min
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...
377 views0 comments
artlembo
- Jun 22, 2018
- 1 min
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...
211 views0 comments
artlembo
- Dec 17, 2016
- 4 min
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...
139 views0 comments
artlembo
- May 26, 2016
- 2 min
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...
18 views0 comments
artlembo
- May 18, 2016
- 3 min
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...
4 views0 comments
artlembo
- Apr 26, 2016
- 3 min
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...
172 views0 comments
artlembo
- Apr 20, 2016
- 4 min
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...
15 views0 comments
artlembo
- Apr 19, 2016
- 2 min
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...
10 views0 comments
artlembo
- Jul 7, 2015
- 2 min
When More is Less…. lessons from processing large data files
My good friend Stuart Hamilton gave me a fun conundrum to try out. He has a file of province boundaries (400 areas) and lidar derived...
62 views0 comments
artlembo
- Jun 26, 2015
- 1 min
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...
34 views0 comments
artlembo
- Apr 20, 2015
- 4 min
A Poor Man’s Parallel Processor for GIS
In addition to SQL, I also am interested in processing large volumes of spatial data. One of the newest rages in “big data” is Hadoop....
22 views0 comments
bottom of page