{"id":3063,"date":"2017-02-23T11:37:58","date_gmt":"2017-02-23T19:37:58","guid":{"rendered":"http:\/\/blog.light42.com\/wordpress\/?p=3063"},"modified":"2017-02-25T07:41:38","modified_gmt":"2017-02-25T15:41:38","slug":"naip-ca-2016-processing","status":"publish","type":"post","link":"http:\/\/blog.light42.com\/wordpress\/?p=3063","title":{"rendered":"NAIP CA 2016 Processing"},"content":{"rendered":"<p>Running 11,000 DOQQs through a processing pipeline &#8211; so far, so good !<br \/>\n&nbsp;<\/p>\n<p><a href=\"http:\/\/blog.light42.com\/wordpress\/wp-content\/uploads\/2017\/02\/NAIP_CA_2016_progress_23Feb17.png\"><img loading=\"lazy\" decoding=\"async\" src=\"http:\/\/blog.light42.com\/wordpress\/wp-content\/uploads\/2017\/02\/NAIP_CA_2016_progress_23Feb17-300x269.png\" alt=\"\" width=\"300\" height=\"269\" class=\"alignnone size-medium wp-image-3064\" srcset=\"http:\/\/blog.light42.com\/wordpress\/wp-content\/uploads\/2017\/02\/NAIP_CA_2016_progress_23Feb17-300x269.png 300w, http:\/\/blog.light42.com\/wordpress\/wp-content\/uploads\/2017\/02\/NAIP_CA_2016_progress_23Feb17-768x689.png 768w, http:\/\/blog.light42.com\/wordpress\/wp-content\/uploads\/2017\/02\/NAIP_CA_2016_progress_23Feb17.png 1012w\" sizes=\"(max-width: 300px) 100vw, 300px\" \/><\/a><\/p>\n<p>&nbsp;<\/p>\n<p>&nbsp;<br \/>\n<em>Details at 0.6 meters per pixel:<\/em><br \/>\n<a href=\"http:\/\/blog.light42.com\/wordpress\/wp-content\/uploads\/2017\/02\/NAIP_CA_2016_yuba0.png\"><img loading=\"lazy\" decoding=\"async\" src=\"http:\/\/blog.light42.com\/wordpress\/wp-content\/uploads\/2017\/02\/NAIP_CA_2016_yuba0-300x244.png\" alt=\"\" width=\"300\" height=\"244\" class=\"alignleft size-medium wp-image-3066\" srcset=\"http:\/\/blog.light42.com\/wordpress\/wp-content\/uploads\/2017\/02\/NAIP_CA_2016_yuba0-300x244.png 300w, http:\/\/blog.light42.com\/wordpress\/wp-content\/uploads\/2017\/02\/NAIP_CA_2016_yuba0-768x625.png 768w, http:\/\/blog.light42.com\/wordpress\/wp-content\/uploads\/2017\/02\/NAIP_CA_2016_yuba0-1024x833.png 1024w, http:\/\/blog.light42.com\/wordpress\/wp-content\/uploads\/2017\/02\/NAIP_CA_2016_yuba0.png 1107w\" sizes=\"(max-width: 300px) 100vw, 300px\" \/><\/a>&nbsp;<a href=\"http:\/\/blog.light42.com\/wordpress\/wp-content\/uploads\/2017\/02\/NAIP_CA_2016_yuba1_IR.png\"><img loading=\"lazy\" decoding=\"async\" src=\"http:\/\/blog.light42.com\/wordpress\/wp-content\/uploads\/2017\/02\/NAIP_CA_2016_yuba1_IR-300x272.png\" alt=\"\" width=\"300\" height=\"272\" class=\"alignnone size-medium wp-image-3068\" srcset=\"http:\/\/blog.light42.com\/wordpress\/wp-content\/uploads\/2017\/02\/NAIP_CA_2016_yuba1_IR-300x272.png 300w, http:\/\/blog.light42.com\/wordpress\/wp-content\/uploads\/2017\/02\/NAIP_CA_2016_yuba1_IR-768x696.png 768w, http:\/\/blog.light42.com\/wordpress\/wp-content\/uploads\/2017\/02\/NAIP_CA_2016_yuba1_IR.png 964w\" sizes=\"(max-width: 300px) 100vw, 300px\" \/><\/a><br \/>\n&nbsp;<\/p>\n<p><strong>Prioritize LA, for Today<\/strong><\/p>\n<pre>\r\nauth_buildings=# \r\n  update doqq_processing as a \r\n    set priority=6 from tl_2016_us_county b, naip_3_16_1_1_ca c \r\n      where \r\n        b.statefp='06' and b.countyfp='037' and \r\n        st_intersects(b.geom, c.geom) and a.doqqid=c.gid;\r\n<\/pre>\n<p><a href=\"http:\/\/blog.light42.com\/wordpress\/wp-content\/uploads\/2017\/02\/ca-2016-naip-left-todo.jpg\"><img loading=\"lazy\" decoding=\"async\" src=\"http:\/\/blog.light42.com\/wordpress\/wp-content\/uploads\/2017\/02\/ca-2016-naip-left-todo-300x187.jpg\" alt=\"\" width=\"300\" height=\"187\" class=\"alignnone size-medium wp-image-3075\" srcset=\"http:\/\/blog.light42.com\/wordpress\/wp-content\/uploads\/2017\/02\/ca-2016-naip-left-todo-300x187.jpg 300w, http:\/\/blog.light42.com\/wordpress\/wp-content\/uploads\/2017\/02\/ca-2016-naip-left-todo-768x479.jpg 768w, http:\/\/blog.light42.com\/wordpress\/wp-content\/uploads\/2017\/02\/ca-2016-naip-left-todo.jpg 832w\" sizes=\"(max-width: 300px) 100vw, 300px\" \/><\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Running 11,000 DOQQs through a processing pipeline &#8211; so far, so good ! &nbsp; &nbsp; &nbsp; Details at 0.6 meters per pixel: &nbsp; &nbsp; Prioritize LA, for Today auth_buildings=# update doqq_processing as a set priority=6 from tl_2016_us_county b, naip_3_16_1_1_ca c where b.statefp=&#8217;06&#8217; and b.countyfp=&#8217;037&#8242; and st_intersects(b.geom, c.geom) and a.doqqid=c.gid;<\/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\/3063"}],"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=3063"}],"version-history":[{"count":9,"href":"http:\/\/blog.light42.com\/wordpress\/index.php?rest_route=\/wp\/v2\/posts\/3063\/revisions"}],"predecessor-version":[{"id":3080,"href":"http:\/\/blog.light42.com\/wordpress\/index.php?rest_route=\/wp\/v2\/posts\/3063\/revisions\/3080"}],"wp:attachment":[{"href":"http:\/\/blog.light42.com\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=3063"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/blog.light42.com\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=3063"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/blog.light42.com\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=3063"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}