How do you manage your spatial data? Just looking to see what kind of consensus there is out there – please pass this along
I want to continue adding more nuances to my previous geocoding post here. In this post, I wanted to show you how I am using Radian to call SQL Server to perform data selection, A Radian function to modify the data coming back from SQL Server, Google’s geocoding API to get X,Y coordinates from an address string, and then another Radian function to convert the geocoded coordinates into a geometry object.
if you want to learn more about writing SQL queries in SQL Server, Radian, or Postgres, check out the training classes at www.gisadvisor.com.
Recently my students and I wrote a paper on geocoding with different Python tools here. While that was really fun, it does take a bit of work to write the code. As you know, I’m partial to doing anything I can with SQL. My attempts to build geocoding into PostgreSQL has not been very successful, although my friends who use Linux versions have had better success.
So, I was really happy to see that Radian built in many geocoding servers into their product, and the functionality is accessible via SQL. The following video shows how to use the Google geocoder through Radian, and I’ve added a little wrinkle: some of the locations are straight addresses, while others are intersections. Using a very simple CASE statement, the addresses geocode effortlessly. Check it out, and let me know what you think.
if you are interested in learning how to use Radian Studio, check out http://www.gisadvisor.com where I have 9 different training courses in geospatial technology.
I was just recently sent a review of my book An Introduction to Statistical Problem Solving in Geography. If you are thinking about a good introductory text on quantitative geography, this review will give you a good idea of what the book is about.
Also, for a limited time, you can get my online version of the course for $30 here. That’s 12 hours of lectures, explanations, and hands-on demonstrations – these are similar to the lectures I give in my University course (although somewhat abbreviated). So, if you want apply quantitative geographic theory in your GIS work, this is a great way to learn.
Someone just retweeted my presentation from Scotland last Fall. I spoke on creating a QGIS plug-in for parallel processing and terrain analysis. I had a fantastic time at @GISUK. Here is a link to the talk.
Today I want to introduce you to another one of my students, Meghan Murphy. Meghan is an outstanding student, and one of the top undergraduates I have ever worked with (I know, I say that a lot, but they just keep getting better and better). Even as a Sophomore, Meghan was always helping other students out, even the Seniors – students would seem to wait for Meghan to organize everyone together to study for upcoming exams.
She also has an innate ability to work with GIS, and pick up new things: one day she has never programmed in Python, and the next day, she has a couple of hundred line Python script created and running in ArcGIS! So, I was so happy when Meghan said she wanted to take a special course in Open Source GIS that I was offering this semester. We covered QGIS, Postgres/PostGIS, GDAL, and Geoserver. For her final project, Meghan decided she wanted to compare the cartography capabilities of ArcGIS and QGIS, and make a video about it (maybe she was inspired by my videos, or maybe she just figured after watching Lembo’s videos, how could I do worse!).
Whatever her reason, like everything else she does, this turned out great, especially since she had never done a live tutorial like this. So, I encourage you to watch the side-by-side comparisons for creating a basic cartographic product in both ArcGIS and QGIS. It’s about 40 minutes long, but worth every minute: I found that I learned some things I hadn’t known regarding some cartographic tools. And, on that note, I’ll have more videos from my undergraduates shortly (some built web maps, others built an enterprise GIS with Postgres.
If you want to learn more about open source GIS, Python programming, Spatial SQL, or Spatial Statistics, check out my online courses at www.gisadvisor.com.
The Web GIS Duel: Final Thoughts
This is a continuation of Mark Balwanz’s blog posts on his creation of web mapping sites using both ESRI and Geoserver. Today he will talk about his experience creating the site using open source technology.
Over the first three parts of this blog series (here, here, and here), I have laid out my project plan, walked you through my ESRI implementation, and my Open Source implementation. During this fourth and final blog I plan on sharing with you my overall thoughts on both implementations in regards to what I liked and disliked. As I mentioned in Part 1 of this series, everything I share here is just my opinion and is based on this one project. I also want to point out that most of my previous experience, both academic and professional, is based in ESRI and is probably shaping some of my opinions.
As someone who has spent most of his GIS life working with ESRI, I have to admit it was a little uncomfortable to move into the Open Source world. However, being uncomfortable was a good thing as it pushed me to learn a lot of new technologies. I think Open Source can be a great way for organizations to start using GIS as there is a lot less upfront cost and with a little research you can find the Open Source project that best fits your need.
I hope you have enjoyed this blog series and have maybe learned something that you can use. Please feel free to leave comments if you have any questions and thanks for reading!
The TuGIS training workshop on March 20, 2017 is completed – you can see the workshop evaluations below:
The workshop evaluations are in
(if you want to cut to the chase, the workshop results are here).
I had a great time teaching our two workshops at the TuGIS conference. In the morning, my students and I presented Spatial SQL: A Language for Geographers, and in the afternoon we taught Python for Geospatial.
We knew expectations would be high: both courses sold-out in 2 days, and we even expanded the class size to 38 people for each workshop!! I knew that teaching 38 people would be a challenge, but it would also be a great lesson to see if we could corral so many cats into a single, technical workshop. The workshop evaluations would be crucial to determine if we met our objectives.
The workshop evaluations were overwhelmingly positive. For example:
- over 90% said they enjoyed the workshop.
- over 83% said it was much better than other GIS training they have been to.
- on a scale of 1-10, 95% of the attendees rated the course a 7 or above.
- 93% said they learned something new in the workshop.
- 89% said the workshops would help them in their careers.
- 91% said they would apply these skills to their job.
I decided to throw one curve-ball on the evaluation sheet and asked:
This was a half-day workshop. Most one-day GIS training classes cost around $600/day. If we developed other in-depth full-day workshops on topics like this for under $250, how likely would you be to participate in it?
it turned out that 89% of the respondents rated a 7 or higher, indicating that almost 90% of the people valued the training enough to pay $250 for a full day course (opposed to $600 for most GIS courses). This means it is possible to offer really good, low cost training to GIS professionals. Keep an eye out on this, as I am very likely to take these training classes on the road.
The comments the participants provided were great – it confirmed our belief that this was an excellent training course, and that the course needed to be expanded to 8 hours, rather than 4 hours – most everyone felt like their was simply too much information to absorb.
If you would like to see the results of the workshop evaluation, click the link below:
Finally, if you can’t make it to a live workshop, all of my video training courses are $30 or less, when you visit www.gisadvisor.com. These courses can’t get into the level of depth that a live course gives, but you’ll see that after thousands of students taking the courses, close to 90% of them give the course 4 starts out of 5!
I just got the new build of Radian Studio, and now that it can directly read geodatabases, you can link directly to the geodatabase from inside of Radian and perform Radian spatial queries on it. In this video, I’m linking directly to an ESRI geodatabase, creating a small map display of the data, performing a spatial clip of two vector layers, and returning the results. In my previous video, I showed how Radian studio can read data directly from PostgreSQL, SQLite, and also easily exchange data between them. This is just another example of how Radian can manage disparate GIS databases.
l hope you like the video, if so, consider learning more about Radian Studio in my online course here.
As many of you know, Manifold Software, Ltd. has just announced the release of Radian Studio. To help people learn Radian, gisadvisor.com, LLC. has just released the video training course Radian Studio.
The more I’m using Radian Studio, the better I like it. Have a look at the short video below to get a quick look at what Radian Studio can do, and decide if it is something you want to try out.
The course is over four hours of video instruction, which as you know from other gisadvisor.com videos, is probably close to a one or two day training program. I wanted to get this training out quickly, so there will be more added to it as the days go on, and as Manifold Software, Ltd. adds more functionality.
As part of the introductory offer, the entire course is available for $30 if you purchase it using the coupon code here – that is an incredible deal to learn such a sophisticated piece of software. And as always, any of the courses you sign up for are available forever, and you can view the courses on your desktop, tablet, and any smart device.
This is one of the best ways to learn the basics of Radian Studio, and it’s at a price that is very affordable to anyone. Don’t forget, if you use Radian Studio, the Manifold forum is a great place to learn from others.