I made a few updates to a number of pages on the site. The GIS Blogs page is now called Geo Blogs and I added a few more blogs to the list. Also, I made sure the mash-ups available on the map mash-up page all work. I try to keep up with the mash-up examples, but sometimes data sources change and I need to update the code.
Why is it that the only time I have to blog is on Sunday mornings? Here are a few quick geo-items that tickled my fancy from the previous week.
Check out the article, The New Cartographers: OpenStreetMap’s World Takeover, from Carl Franzen at Talking Points Memo. The first two parts of this story have been tweeted a lot this last week and I can see why. The article provides a fairly good overview of OSM, including some background on the project, the nuances of licensing OSM data, and adoption in the tech industry. Part three of the article comes out on Sunday. Makes me feel good about calling 2012 the year of OSM.
The guys at Google’s NC data center, which just got the indoors street view treatment, definitely Rickrolled streetview (Check out the image on the screens, also, why didn’t they blur out Rick Astley’s face too?).
Brian Flood has been doing a lot of great things for the online mapping and spatial data communities for a while now. This video and post on the MapBox blog is the latest example. Using Arc2Earth Sync to integrate with MapBox and ArcGIS appears smooth and simple. Awesome. There is a lot of great work happening in “spatial” and it’s only going to make what we do as geo-professionals better.
Speaking of MapBox, when does Esri try to scoop them up (if they haven’t already), like they just did with GeoLoqi?
Avid Geo Boston had their October meet-up this past week. The video is here. Since I am a horrible member and missed the meet-up for the third straight month I cannot comment on the talks, but I’m sure everyone had a good time.
I use Weather Underground for the my weather needs, especially the handy-dandy web-mapping application for “Is it going to rain on my run?” weather report. Just recently, I was checking the radar before heading out and noticed what appeared to be a technical malfunction, or the opening scenes to an epic movie.
What is happening? Were there massive, freak storms happening throughout the eastern US? No.
What you are probably seeing are radar blobs/radar blooms. It took a couple minutes of Googling, but here is a 2007 article from AccuWeather.com explaining what you see on the map. Apparently I observed a phenomena actually known as Ground Clutter. I’m neither a radar or weather expert so I won’t comment on what is technically happening but it’s still pretty neat to see on a map.
ArcGIS 10.1 has been out for a few months now and I am curious as to what the GIS public thinks of the newest release. I haven’t upgraded any of my Esri products to the newest release yet, and probably won’t for a while, but I want to gauge the public’s reaction to the most recent “dot” release.
If you have any other thoughts or comments on ArcGIS for Desktop (ArcMap), ArcGIS Online, Esri Maps for Excel, or anything else spatial leave a message!
I’ll post the results in a couple weeks.
Here is the awesome, non-scientific, one question survey. Take it!
Like all of you, I run into the famous (infamous?) Esri error report, more often than I like. Ever wonder what happens when you actually report the error (which I do when I have the patience)? Check this out this blog post from Esri’s Resource Center. One item that I took away from the article is that I need to add more information to my error report than just my frustrated babbling, as Esri’s error reporting algorithms evaluate the available information before it is passed on to the engineers.
If you are a heavy Esri user and run into the error report often you should take the five minutes to read the post.
Avid Geo will be holding it’s monthly meeting for August this coming Thursday at Dogpatch Labs in Cambridge. Unfortunately I can’t make this month’s meeting but it looks to another good one. David Zwarg, from Azavea will be talking about PostGIS raster formats and supporting GDAL drivers. I’ve seen David speak a couple times now and its always about some pretty interesting stuff. So, if you are into PostGIS, GDAL, and like “talking shop” with some people in the know then head over to Cambridge this Thursday!
After a geo-action packed week at the 2012 Esri UC here my top 10 observations that I had written down in my notebook:
The spatial stats sessions were great, but for many of the sessions you needed an understanding of basic prob and stats. Even with a basic understanding of stats all of the OLS, GWR, R Squared, and dependent variable talk may have been a little confusing for the beginner (which is totally understandable). However, if you were a stats nut, then these sessions were right on the money.
I always like meeting up with my old UConn grad school classmates and I was able to do that a lot at this year’s UC. It is great to talk with them about what they are doing now and where they want to go. At some point we should organize a party…
I focused on spatial analysis sessions this year’s UC and all the raster analysis sessions I attended were great, and I am looking forward to a number of upgrades in 10.1. I like presentations that progress from a question to a solution and the raster analysis presentations I saw definitely did this.
You can’t beat the weather in San Diego.
Seeing the improvements to the arcpy cursors in 10.1 made me happy. Huge improvement in performance, so much so I’ll start using them! Now I have to wait for SP1 when 64bit geoprocessing FINALLY becomes available before I actually upgrade.
It seemed to me that the only vendors on the floor of the exhibition hall were those promoting/selling the cloud or mobile products. There were a few data vendors out there, but I think they were all pushing cloud services and mobile products as well.
I always like the graphics on the giant screen during the Esri UC plenary. It must be someone’s full time job to create those “slides”. I wish my powerpoint slides looked that good.
The “Evening in Balboa Park” was a lot of fun, especially if you got there early and got to the sushi lines quickly. However, if you did have to wait in line for sushi at the Casa De Balboa the unique musician rocking out on the electric cello provided some quality entertainment! Also, Metalachi rocked the house.
My eight year old stopwatch died in San Diego. This probably explains my horrible, down right embarrassing time in Esri 5k. It’s obviously all my watch’s fault.
Roger Tomlinson and Jack Dangermond during the SAG ceremony. I bet Roger was thinking about the ways he was going to zing Jack during his speech!
Bonus Thoughts – you don’t have to use your ArcGIS Online credits to read these…
One of the biggest criticism of ArcGIS 10, and rightfully so, was in regards to the quality of the software. If Jack, or any other members of Esri, had talked about efforts to improve the quality of Esri products during the morning plenary I believe you would have seen the hall erupt in applause, because frankly, that’s all we really care about. Reliable, quality software.
During the plenary Esri announced full 64 bit desktop in a service pack sometime in 2013. Finally…
I know GIS is firmly entrenched in the military and security sectors, but some of the demos I saw regarding drone data collection and creating spatial data from drone cameras was a little too “Big Brother” for my liking.
I wish the Padres were in town during the week of the conference.
Esri Maps for Microsoft Office could be a big hit, but it requires an AGO account and doesn’t come cheap. I can see this as pretty powerful tool for organizations, but managing all those accounts, especially if you can’t tie them into your organization’s account system, might make it a little cumbersome to manage. I need to learn more about EMMO.
Overall, I thought it was a good conference. I did a lot of networking and learned a lot. Like any conference, it is about what you make it. I had a specific agenda that I stuck to and it turned out pretty good.
Were you there? What did you think of the conference? Would you recommend it to your cowokers or others in the geo-professions? Leave a comment!
I had a question the other day about how to incorporate a where statement into a spatial join (STIntersects). Unfortunately, the examples I had previously posted didn’t cover that topic. Well, here is an example of querying two tables, using the geometry data type in each, along with a where statement, to find all results that meet the defined spatial conditions:
select PP.*, SP.*
from Populated_Places PP
inner join States_Provinces SP with(Index(geom_sidx))
on PP.geom.STIntersects(SP.geom) = 1
where SP.NAME_0 = 'United States of America'
and SP.NAME_1 = 'Massachusetts'
Let’s breakdown this query:
The query starts by calling all the columns from two different tables, a table with point data called Populated_Places, and a table containing polygon data called State_Provinces.
The query then performs an inner join between the two tables, In the inner join I specifically call the spatial index from the States_Provinces table. I call this index because I want to use it, and because query optimizer may skip it, as it does with many spatial indexes.
In the ON statement I set up the STIntersects statement between the point table and the polygon table, only returning the records that intersect. This is done by setting the Boolean requirement at the end of the STIntersects statement to 1. I also make sure to set the correct column in each table that contains the spatial datatype, which in this case is called geom for both tables.
Now, here comes the where statement,which is about as vanilla as vanilla can be. In the where statement I simply limit the polygons that are eligible for the query based on some defined values.
This type of query will also work with line or polygon features, as demonstrated in the following picture. In this example I query all the roads that intersect a polygon defined in the where statement. You will notice that I have the spatial results tab open to display the intersecting line features.
This is a pretty simple example, but if you have never worked in this medium it can be a little confusing at first. Have any more spatial sql questions? Let me know. I need to keep sharp.