{"action":"created","issue":{"url":"https://api.github.com/repos/IDgis/geo-publisher/issues/145","repository_url":"https://api.github.com/repos/IDgis/geo-publisher","labels_url":"https://api.github.com/repos/IDgis/geo-publisher/issues/145/labels{/name}","comments_url":"https://api.github.com/repos/IDgis/geo-publisher/issues/145/comments","events_url":"https://api.github.com/repos/IDgis/geo-publisher/issues/145/events","html_url":"https://github.com/IDgis/geo-publisher/issues/145","id":45118057,"number":145,"title":"Vraag: URL in metadata naar overzichtsplaatje","user":{"login":"ekuyer","id":4831557,"avatar_url":"https://avatars.githubusercontent.com/u/4831557?v=3","gravatar_id":"","url":"https://api.github.com/users/ekuyer","html_url":"https://github.com/ekuyer","followers_url":"https://api.github.com/users/ekuyer/followers","following_url":"https://api.github.com/users/ekuyer/following{/other_user}","gists_url":"https://api.github.com/users/ekuyer/gists{/gist_id}","starred_url":"https://api.github.com/users/ekuyer/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/ekuyer/subscriptions","organizations_url":"https://api.github.com/users/ekuyer/orgs","repos_url":"https://api.github.com/users/ekuyer/repos","events_url":"https://api.github.com/users/ekuyer/events{/privacy}","received_events_url":"https://api.github.com/users/ekuyer/received_events","type":"User","site_admin":false},"labels":[{"url":"https://api.github.com/repos/IDgis/geo-publisher/labels/enhancement","name":"enhancement","color":"84b6eb"}],"state":"open","locked":false,"assignee":null,"milestone":{"url":"https://api.github.com/repos/IDgis/geo-publisher/milestones/7","html_url":"https://github.com/IDgis/geo-publisher/milestones/6b.%20Prio%202%20na%20productiegang","labels_url":"https://api.github.com/repos/IDgis/geo-publisher/milestones/7/labels","id":990883,"number":7,"title":"6b. Prio 2 na productiegang","description":"","creator":{"login":"erikorbons","id":7956525,"avatar_url":"https://avatars.githubusercontent.com/u/7956525?v=3","gravatar_id":"","url":"https://api.github.com/users/erikorbons","html_url":"https://github.com/erikorbons","followers_url":"https://api.github.com/users/erikorbons/followers","following_url":"https://api.github.com/users/erikorbons/following{/other_user}","gists_url":"https://api.github.com/users/erikorbons/gists{/gist_id}","starred_url":"https://api.github.com/users/erikorbons/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/erikorbons/subscriptions","organizations_url":"https://api.github.com/users/erikorbons/orgs","repos_url":"https://api.github.com/users/erikorbons/repos","events_url":"https://api.github.com/users/erikorbons/events{/privacy}","received_events_url":"https://api.github.com/users/erikorbons/received_events","type":"User","site_admin":false},"open_issues":15,"closed_issues":13,"state":"open","created_at":"2015-02-23T08:43:37Z","updated_at":"2016-01-22T12:35:55Z","due_on":null,"closed_at":null},"comments":3,"created_at":"2014-10-07T15:02:52Z","updated_at":"2016-02-15T09:08:43Z","closed_at":null,"body":"Dit plaatje wordt in de aanbieding van IDGIS door de pub omg gegenereerd. Dit willen we niet altijd geautomatiseerd laten doen op basis van extents. (bijvoorbeeld: De BAG op schaal Nederland laat geen goede preview zien). Soms geven we zelf een plaatje mee."},"comment":{"url":"https://api.github.com/repos/IDgis/geo-publisher/issues/comments/184123394","html_url":"https://github.com/IDgis/geo-publisher/issues/145#issuecomment-184123394","issue_url":"https://api.github.com/repos/IDgis/geo-publisher/issues/145","id":184123394,"user":{"login":"copierrj","id":2194475,"avatar_url":"https://avatars.githubusercontent.com/u/2194475?v=3","gravatar_id":"","url":"https://api.github.com/users/copierrj","html_url":"https://github.com/copierrj","followers_url":"https://api.github.com/users/copierrj/followers","following_url":"https://api.github.com/users/copierrj/following{/other_user}","gists_url":"https://api.github.com/users/copierrj/gists{/gist_id}","starred_url":"https://api.github.com/users/copierrj/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/copierrj/subscriptions","organizations_url":"https://api.github.com/users/copierrj/orgs","repos_url":"https://api.github.com/users/copierrj/repos","events_url":"https://api.github.com/users/copierrj/events{/privacy}","received_events_url":"https://api.github.com/users/copierrj/received_events","type":"User","site_admin":false},"created_at":"2016-02-15T09:08:43Z","updated_at":"2016-02-15T09:08:43Z","body":"Opzoeken van metadata documenten zonder plaatje:\r\n\r\n```sql\r\nwith graphic_overviews as (\r\nselect \r\n\tidentification, \r\n\tmetadata_file_identification, \r\n\tmetadata_identification, \r\n\txpath(\r\n\t\t'/gmd:MD_Metadata/gmd:identificationInfo/gmd:MD_DataIdentification/' || \r\n\t\t'gmd:graphicOverview/gmd:MD_BrowseGraphic/gmd:fileName/gco:CharacterString/text()',\r\n\t\txmlparse(document document), \r\n\t\tarray[\r\n\t\t\tarray['gmd', 'http://www.isotc211.org/2005/gmd'], \r\n\t\t\tarray['gco', 'http://www.isotc211.org/2005/gco']])::text[] graphic_overviews\r\nfrom publisher.source_dataset_metadata sdm\r\njoin publisher.dataset d on d.source_dataset_id = sdm.source_dataset_id)\r\nselect identification, metadata_file_identification, metadata_identification \r\nfrom graphic_overviews go\r\nwhere array_length(go.graphic_overviews, 1) = 0;\r\n```"}}