top of page
Search
![](https://static.wixstatic.com/media/539afc_36bd0a6afc454a90b7fd721b865db711~mv2.jpeg/v1/fill/w_250,h_250,fp_0.50_0.50,q_30,blur_30,enc_auto/539afc_36bd0a6afc454a90b7fd721b865db711~mv2.webp)
![Easy bivariate map with Postgres](https://static.wixstatic.com/media/539afc_36bd0a6afc454a90b7fd721b865db711~mv2.jpeg/v1/fill/w_454,h_341,fp_0.50_0.50,q_90,enc_auto/539afc_36bd0a6afc454a90b7fd721b865db711~mv2.webp)
artlembo
Mar 14, 20193 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...
234 views1 comment
![](https://static.wixstatic.com/media/539afc_c699635ab3604dda8f3f68f73ad6ba81~mv2.jpg/v1/fill/w_250,h_250,fp_0.50_0.50,q_30,blur_30,enc_auto/539afc_c699635ab3604dda8f3f68f73ad6ba81~mv2.webp)
![Engaging students with multiuser editing, and FOSS4g](https://static.wixstatic.com/media/539afc_c699635ab3604dda8f3f68f73ad6ba81~mv2.jpg/v1/fill/w_454,h_341,fp_0.50_0.50,q_90,enc_auto/539afc_c699635ab3604dda8f3f68f73ad6ba81~mv2.webp)
artlembo
Feb 21, 20192 min read
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...
24 views0 comments
![](https://static.wixstatic.com/media/539afc_022af9ea556f4198b6f57b4a92d69047~mv2.jpg/v1/fill/w_250,h_250,fp_0.50_0.50,q_30,blur_30,enc_auto/539afc_022af9ea556f4198b6f57b4a92d69047~mv2.webp)
![Big Data Results](https://static.wixstatic.com/media/539afc_022af9ea556f4198b6f57b4a92d69047~mv2.jpg/v1/fill/w_454,h_341,fp_0.50_0.50,q_90,enc_auto/539afc_022af9ea556f4198b6f57b4a92d69047~mv2.webp)
artlembo
Oct 16, 20185 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...
150 views0 comments
artlembo
Jul 7, 20182 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...
595 views0 comments
![](https://static.wixstatic.com/media/54ece48fa04e492fa46bd79980105f0d.jpg/v1/fill/w_250,h_250,fp_0.50_0.50,q_30,blur_30,enc_auto/54ece48fa04e492fa46bd79980105f0d.webp)
![Multi-Ring (non-overlapping) Buffers with PostGIS](https://static.wixstatic.com/media/54ece48fa04e492fa46bd79980105f0d.jpg/v1/fill/w_454,h_341,fp_0.50_0.50,q_90,enc_auto/54ece48fa04e492fa46bd79980105f0d.webp)
artlembo
Jun 22, 20181 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...
278 views0 comments
![Undergraduate Geospatial Python Projects](https://static.wixstatic.com/media/539afc_d91b4b4011a34b4dab2233cc3ec9cebe~mv2.png/v1/fill/w_240,h_200,fp_0.50_0.50,q_95,enc_auto/539afc_d91b4b4011a34b4dab2233cc3ec9cebe~mv2.webp)
artlembo
Dec 17, 20164 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...
290 views0 comments
![](https://static.wixstatic.com/media/539afc_d5cf76c74d75422eaddbf06f594722ee~mv2.jpg/v1/fill/w_250,h_250,fp_0.50_0.50,q_30,blur_30,enc_auto/539afc_d5cf76c74d75422eaddbf06f594722ee~mv2.webp)
![Advanced Editing Capabilities with PostGIS](https://static.wixstatic.com/media/539afc_d5cf76c74d75422eaddbf06f594722ee~mv2.jpg/v1/fill/w_367,h_275,fp_0.50_0.50,q_90,enc_auto/539afc_d5cf76c74d75422eaddbf06f594722ee~mv2.webp)
artlembo
May 26, 20162 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...
25 views0 comments
artlembo
May 18, 20163 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...
4 views0 comments
![](https://static.wixstatic.com/media/539afc_66e8cdefbe2543d39abbec5631ae9137~mv2.jpg/v1/fill/w_250,h_250,fp_0.50_0.50,q_30,blur_30,enc_auto/539afc_66e8cdefbe2543d39abbec5631ae9137~mv2.webp)
![k-Nearest Neighbor with PostGRES](https://static.wixstatic.com/media/539afc_66e8cdefbe2543d39abbec5631ae9137~mv2.jpg/v1/fill/w_454,h_268,fp_0.50_0.50,q_90,enc_auto/539afc_66e8cdefbe2543d39abbec5631ae9137~mv2.webp)
artlembo
Apr 26, 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...
223 views0 comments
![](https://static.wixstatic.com/media/539afc_56f2b3162c674ff2af60ad5790dccc6e~mv2.jpg/v1/fill/w_232,h_232,fp_0.50_0.50,lg_1,q_30,blur_30,enc_auto/539afc_56f2b3162c674ff2af60ad5790dccc6e~mv2.webp)
![Trade Area Analysis in Postgres / PostGIS](https://static.wixstatic.com/media/539afc_56f2b3162c674ff2af60ad5790dccc6e~mv2.jpg/v1/fill/w_454,h_166,fp_0.50_0.50,q_90,enc_auto/539afc_56f2b3162c674ff2af60ad5790dccc6e~mv2.webp)
artlembo
Apr 20, 20164 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...
25 views0 comments
artlembo
Apr 19, 20162 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...
21 views0 comments
![](https://static.wixstatic.com/media/539afc_4bfbf0235126437bab6c287011b2882f~mv2.jpg/v1/fill/w_250,h_250,fp_0.50_0.50,q_30,blur_30,enc_auto/539afc_4bfbf0235126437bab6c287011b2882f~mv2.webp)
![When More is Less…. lessons from processing large data files](https://static.wixstatic.com/media/539afc_4bfbf0235126437bab6c287011b2882f~mv2.jpg/v1/fill/w_454,h_341,fp_0.50_0.50,q_90,enc_auto/539afc_4bfbf0235126437bab6c287011b2882f~mv2.webp)
artlembo
Jul 7, 20152 min read
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...
85 views0 comments
![](https://www.createspace.com/Img/T556/T63/T36/BookCoverImage.jpg?random=0.9433617102181375)
![New Books – How do I do that in PostGIS, How do I do that in Manifold SQL](https://www.createspace.com/Img/T556/T63/T36/BookCoverImage.jpg?random=0.9433617102181375)
artlembo
Jun 26, 20151 min read
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...
44 views0 comments
![](https://static.wixstatic.com/media/539afc_11ec3700c8b74e9cbd6092c255e65207~mv2.jpg/v1/fill/w_250,h_250,fp_0.50_0.50,q_30,blur_30,enc_auto/539afc_11ec3700c8b74e9cbd6092c255e65207~mv2.webp)
![A Poor Man’s Parallel Processor for GIS](https://static.wixstatic.com/media/539afc_11ec3700c8b74e9cbd6092c255e65207~mv2.jpg/v1/fill/w_454,h_341,fp_0.50_0.50,q_90,enc_auto/539afc_11ec3700c8b74e9cbd6092c255e65207~mv2.webp)
artlembo
Apr 20, 20154 min read
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....
24 views0 comments
bottom of page