top of page
Search


Building a geodatabase tutorial - ArcGIS Pro
If you're like me, you've enjoyed using the ESRI Tutorial Building a Geodatabase. It's a great tutorial that steps students through some...
artlembo
Mar 11, 20201 min read
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 Maps with QGIS, SQL, and the DB Manager
Previously, I blogged about creating bivariate maps with Postgres, and Arcpy. Pretty cool stuff, check it out! But, to be honest even...
artlembo
Sep 17, 20191 min read
SQL or Models in QGIS – you decide
In my previous post, I showed how to create a model in QGIS – I think that was pretty cool! But, as I say over and over, SQL is even...
artlembo
Sep 13, 20191 min read


Models in QGIS
Did you know that QGIS can design graphical models, similar to the way Model Builder in ArcGIS works? The following video is taken from...
artlembo
Aug 20, 20191 min read


Big Data Geo-Analytics with Postgres workshop Evaluation
Technical and Detailed. Great teacher explanation. Really good! Practical advice, in-depth enough to really learn something useful (most...
artlembo
Aug 12, 20192 min read


Bivariate Choropleth Maps with Arcpy
In my previous post, I showed how to prepare the data for a bivariate choropleth map using PostGIS and QGIS. I also indicated that there...
artlembo
Mar 15, 20192 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


Ready for a new career?
I just got off the phone with a very large developer. I want to call him a GIS developer, but really that’s not was he does. Rather, he...
artlembo
Mar 7, 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...
artlembo
Feb 21, 20192 min read
PostGIS Multiprocessing Code-Review
As promised, let’s walk through the code I wrote to create the multiprocessing of my Postgres/PostGIS task. You may recall that I said...
artlembo
Dec 11, 20183 min read


PostGIS and Multiprocessing
NYC taxi cab pickup locations for October, 2012 OK, let’s cut to the chase: I used Python’s parallel processing capabilities with...
artlembo
Dec 10, 20185 min read


Denver workshops – a mixture of sadness and joy.
two successful Keeping Up with GIS Technology workshops out in Denver. This was a week mixed with sadness and joy: sadness in that my...
artlembo
Oct 28, 20184 min read


Follow up to my big data test – improving PostGIS performance
Just a quick follow-up to my big data test. If you remember, I was able to determine the number of taxi pickups and the sum of the fares...
artlembo
Oct 17, 20182 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


Maryland GIS Conference: Workshop Results
We had a very successful workshop on GIS at the Maryland Geospatial Conference – well, actually two workshops. I was asked to teach a...
artlembo
Aug 19, 20182 min read


Is a Geography Degree worth it?
Recently, we were asked by our new University President, Chuck Wight, how our students are doing in obtaining their first job. You have...
artlembo
Aug 10, 20183 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 Manifold 9
In my last post, I showed you how to create multi-ring, non-overlapping buffers with spatial SQL in PostGIS. In this post, I want to do...
artlembo
Jun 26, 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...
artlembo
Jun 22, 20181 min read
bottom of page