{"id":970,"date":"2012-11-16T14:32:55","date_gmt":"2012-11-16T22:32:55","guid":{"rendered":"http:\/\/blog.light42.com\/wordpress\/?p=970"},"modified":"2012-12-07T09:55:55","modified_gmt":"2012-12-07T17:55:55","slug":"postgis-2-0-intro-presentation","status":"publish","type":"post","link":"http:\/\/blog.light42.com\/wordpress\/?p=970","title":{"rendered":"PostGIS 2.0 Intro Presentation"},"content":{"rendered":"<p><img decoding=\"async\" src=\"http:\/\/blog.light42.com\/wordpress\/wp-content\/uploads\/2012\/11\/University_of_California_Seal.svg_.png\" alt=\"UC\" align=\"right\" height=\"108px\" width=\"108px\"\/><\/p>\n<p>at <a href=\"http:\/\/www.cs.berkeley.edu\/\" title=\"Soda Hall EECS\" target=\"_blank\">UC Berkeley Soda Hall<\/a>, for the <a href=\"http:\/\/www.meetup.com\/postgresql-1\/\" title=\"SFPUG\" target=\"_blank\">San Francisco PostgreSQL Users Group<\/a><\/p>\n<p>and again at the <a href=\"http:\/\/www.cnr.berkeley.edu\/site\/index.php\" title=\"CNR\" target=\"_blank\">College of Natural Resources<\/a> for GIS Day 2012<\/p>\n<h4>\n<a href=\"http:\/\/blog.light42.com\/wordpress\/wp-content\/uploads\/2012\/11\/pg_20_sfpugM.pdf\" title=\"main slides\" target=\"_blank\">main slides<\/a> and <a href=\"http:\/\/blog.light42.com\/wordpress\/wp-content\/uploads\/2012\/11\/postgis_raster.pdf\" title=\"pg raster slides by dustymugs\" target=\"_blank\">dustymugs&#8217; raster slides<\/a><\/h4>\n<p><em>errata:<\/em><br \/>\n* The <a href=\"http:\/\/postgis.org\/documentation\/manual-svn\/ST_MakeValid.html\" title=\"ST_MakeValid()\" target=\"_blank\">ST_MakeValid(geom)<\/a> example could have been expanded to include <a href=\"http:\/\/postgis.org\/documentation\/manual-svn\/ST_IsValidDetail.html\" title=\"ST_IsValidDetail()\" target=\"_blank\">ST_IsValidDetail()<\/a><\/p>\n<p>* It is arguably wrong to say that Lat\/Lng (<a href=\"http:\/\/spatialreference.org\/ref\/epsg\/4326\/\" title=\"srs\" target=\"_blank\">EPSG:4326<\/a>) data is one of the projections.  I meant to present that there are spatial reference systems and you use one per table, so calling Lat\/Lng one of them made one less turn in the directions for use. But so it goes.<\/p>\n<h4><a href=\"http:\/\/blog.light42.com\/wordpress\/wp-content\/uploads\/2012\/12\/pg_20_agu_06dec.pdf\" title=\"slides\" target=\"_blank\">SF GeoMeetup \/ AGU 2012 slides<\/a><\/h4>\n","protected":false},"excerpt":{"rendered":"<p>at UC Berkeley Soda Hall, for the San Francisco PostgreSQL Users Group and again at the College of Natural Resources for GIS Day 2012 main slides and dustymugs&#8217; raster slides errata: * The ST_MakeValid(geom) example could have been expanded to include ST_IsValidDetail() * It is arguably wrong to say that Lat\/Lng (EPSG:4326) data is one [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[5,6],"tags":[],"_links":{"self":[{"href":"http:\/\/blog.light42.com\/wordpress\/index.php?rest_route=\/wp\/v2\/posts\/970"}],"collection":[{"href":"http:\/\/blog.light42.com\/wordpress\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/blog.light42.com\/wordpress\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/blog.light42.com\/wordpress\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/blog.light42.com\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=970"}],"version-history":[{"count":27,"href":"http:\/\/blog.light42.com\/wordpress\/index.php?rest_route=\/wp\/v2\/posts\/970\/revisions"}],"predecessor-version":[{"id":1346,"href":"http:\/\/blog.light42.com\/wordpress\/index.php?rest_route=\/wp\/v2\/posts\/970\/revisions\/1346"}],"wp:attachment":[{"href":"http:\/\/blog.light42.com\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=970"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/blog.light42.com\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=970"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/blog.light42.com\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=970"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}