{"id":1313,"date":"2018-01-09T09:30:23","date_gmt":"2018-01-09T08:30:23","guid":{"rendered":"https:\/\/vgrutv.wordpress.com\/?p=1313"},"modified":"2018-01-18T15:49:40","modified_gmt":"2018-01-18T14:49:40","slug":"spatial-sql-2","status":"publish","type":"post","link":"https:\/\/vgrblogg.se\/utveckling\/2018\/01\/09\/spatial-sql-2\/","title":{"rendered":"Spatial SQL #2"},"content":{"rendered":"

\"SQL_befolkning\"<\/p>\n

Spatial SQL<\/em><\/p>\n

\u201dLite mindre prosa, lite fler till\u00e4mpningar\u201d skrev jag nyligen<\/a>. H\u00e4r kommer d\u00e4rf\u00f6r inl\u00e4gg #2 om vad jag l\u00e4r mig inom spatial SQL. #1 hittar du h\u00e4r<\/a>. Precis som f\u00f6rra g\u00e5ngen \u00e4r det en sammanst\u00e4llning av exempel som jag anv\u00e4nder mig av och inte ett helt\u00e4ckande utbildningsmaterial. Kanske \u00e4r det fler som har nytta av denna sammanst\u00e4llning.\u00a0I dagsl\u00e4get \u00e4r fokus p\u00e5 vektordata och enklare statistik, s\u00e5 antalet till\u00e4mpningar inom ex. raster och punktmoln h\u00f6gst begr\u00e4nsat.<\/p>\n

Lista egenskaper f\u00f6r alla tabeller i schemat<\/strong>\r\nSELECT *\r\nFROM information_schema.columns\r\nWHERE table_schema = 'public'\r\nORDER BY table_name;<\/pre>\n
Lista egenskaper f\u00f6r alla geometrikolumner<\/strong>\r\nSELECT * FROM public.geometry_columns\r\nWHERE f_table_schema = 'public'\r\nORDER BY f_table_name;<\/pre>\n
Lista alla adressplatser p\u00e5 en gata<\/strong>\r\nSELECT adromrade, adrplats, xkoord, ykoord FROM adresser_90a\r\nWHERE adromrade = 'Broplatsen'\r\nAND postort = 'M\u00f6lndal'\r\nORDER BY adrplats;<\/pre>\n
Skapa convex hull f\u00f6r en kommun<\/strong>\r\nSELECT kommunnamn, ST_ConvexHull(geom)\r\nFROM kommunytor_vg\r\nWHERE id = 1;<\/pre>\n
Skapa extent f\u00f6r kommuner<\/strong>\r\nSELECT id, kommunnamn, ST_Extent(geom) As extent\r\nFROM kommunytor_vg\r\nGROUP BY kommunnamn, id;<\/pre>\n
Ber\u00e4kna antalet noder f\u00f6r varje polygon<\/strong>\r\nSELECT kommunnamn, ST_NPoints(geom) As punkter\r\nFROM kommunytor_vg\r\nORDER BY punkter DESC;<\/pre>\n
Transformera till WGS 84<\/strong>\r\nSELECT id, namn, ST_Transform(geom,4326) As geom\r\nFROM vardcentraler_vg;<\/pre>\n
L\u00e4s ut objekt som GeoJSON i WGS 84<\/strong>\r\nSELECT id, namn, ST_asGeoJSON(ST_Transform(geom,4326)) As geom\r\nFROM vardcentraler_vg;<\/pre>\n
Hitta korta linjer<\/strong>\r\nSELECT id, linje, beskrivning, ST_Length(geom) As length FROM kollektivtrafik_linjeriktningar\r\nWHERE ST_Length(geom) < 500;<\/pre>\n
Ber\u00e4kna avst\u00e5nd mellan tv\u00e5 objekt i samma tabell<\/strong>\r\nSELECT ST_Distance(a.geom, b.geom)\r\nFROM sjukhus a, sjukhus b\r\nWHERE a.namn='Alings\u00e5s lasarett' AND b.namn='Kung\u00e4lvs sjukhus';<\/pre>\n
Ber\u00e4kna avst\u00e5nd mellan ett objekt och samtliga poster i en annan tabell<\/strong>\r\nSELECT s.namn As Sjukhus, v.namn As v\u00e5rdcentral, Round(ST_Distance(s.geom, v.geom)) As avst\u00e5nd\r\nFROM\r\n (SELECT namn, geom FROM public.sjukhus WHERE namn = 'Brink\u00e5sen') As s\r\n CROSS JOIN\r\n (SELECT namn, geom FROM public.vardcentraler_vg) As v\r\nORDER BY avst\u00e5nd;<\/pre>\n
Summera befolkningsm\u00e4ngd inom 1 km respektive sjukhus<\/strong>\r\nSELECT sj.namn, sum(b.totbef)\r\nFROM\r\n befolkning_250x250m As b INNER JOIN sjukhus As sj ON ST_DWithin(b.geom,sj.geom,1000)\r\nGROUP BY sj.namn\r\nORDER BY sj.namn;<\/pre>\n
Ber\u00e4kna kollektivtrafikn\u00e4tets l\u00e4ngd p\u00e5 Tj\u00f6rn<\/strong>\r\nSELECT sum(ST_Length(kollektivtrafik_linjeriktningar.geom))\r\n FROM kollektivtrafik_linjeriktningar, kommunytor_vg\r\n WHERE ST_Intersects(kollektivtrafik_linjeriktningar.geom,kommunytor_vg.geom) AND kommunytor_vg.kommunnamn = 'Tj\u00f6rn';<\/pre>\n
Ber\u00e4kna befolkningsm\u00e4ngd i alla kommuner<\/strong>\r\nSELECT kommunnamn, sum(totbef)\r\nFROM public.befolkning_250x250m, kommunytor_vg\r\nWHERE ST_Intersects(befolkning_250x250m.geom,kommunytor_vg.geom)\r\nGROUP BY kommunnamn\r\nORDER BY kommunnamn;<\/pre>\n
Ber\u00e4kna avst\u00e5nd mellan tv\u00e5 kommuner<\/strong>\r\nSELECT a.kommunnamn As komm_a, b.kommunnamn As komm_b, ST_Distance(a.geom, b.geom) As dist_m\r\nFROM kommunytor_vg As a CROSS JOIN kommunytor_vg As b\r\nWHERE a.kommunnamn = 'Tj\u00f6rn' and b.kommunnamn = 'Alings\u00e5s';<\/pre>\n
Hitta punkter inom 500 m fr\u00e5n kollektivtrafikens linjen\u00e4t<\/strong>\r\nSELECT s.id, s.snamn\r\nFROM\r\n skolenheter As s INNER JOIN kollektivtrafik_linjeriktningar As kl ON ST_DWithin(s.geom,kl.geom,500)\r\nGROUP BY s.id\r\nORDER BY s.snamn;<\/pre>\n
Hitta 5 n\u00e4rmaste punkter<\/strong>\r\nSELECT k.id, k.kommunnamn, ST_Distance(k.geom, s.geom) As avstand, k.geom\r\nFROM kommunytor_vg As k INNER JOIN sjukhus As s ON ST_DWithin(s.geom, k.geom, 50000)\r\nWHERE s.id = 19\r\nORDER BY avstand\r\nLIMIT 5;\r\n\r\nAlternativt\r\n\r\nSELECT id, snamn, geom\r\nFROM skolenheter\r\nORDER BY ST_SetSRID(ST_Point(322176, 6400599), 3006) <-> geom LIMIT 5;<\/pre>\n
D\u00e4r tar det stopp f\u00f6r denna g\u00e5ng. Fler exempel l\u00e4r f\u00f6lja.<\/p>\n","protected":false},"excerpt":{"rendered":"
Spatial SQL \u201dLite mindre prosa, lite fler till\u00e4mpningar\u201d skrev jag nyligen. H\u00e4r kommer d\u00e4rf\u00f6r inl\u00e4gg #2 om vad jag l\u00e4r mig inom spatial SQL. #1 hittar du h\u00e4r. Precis som f\u00f6rra g\u00e5ngen \u00e4r det en sammanst\u00e4llning av exempel som jag anv\u00e4nder mig av och inte ett helt\u00e4ckande utbildningsmaterial. Kanske \u00e4r det fler som har nytta … <\/p>\n
Forts\u00e4tt l\u00e4sa \u201dSpatial SQL #2\u201d<\/span><\/a><\/p>\n","protected":false},"author":4,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[4],"tags":[606,615],"class_list":["post-1313","post","type-post","status-publish","format-standard","hentry","category-geo-perspektiv","tag-statistik","tag-structured-query-language-sql"],"yoast_head":"\nSpatial SQL #2 — Utveckling i VGR<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/vgrblogg.se\/utveckling\/2018\/01\/09\/spatial-sql-2\/\" \/>\n<meta property=\"og:locale\" content=\"sv_SE\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Spatial SQL #2 — Utveckling i VGR\" \/>\n<meta property=\"og:description\" content=\"Spatial SQL \u201dLite mindre prosa, lite fler till\u00e4mpningar\u201d skrev jag nyligen. H\u00e4r kommer d\u00e4rf\u00f6r inl\u00e4gg #2 om vad jag l\u00e4r mig inom spatial SQL. #1 hittar du h\u00e4r. Precis som f\u00f6rra g\u00e5ngen \u00e4r det en sammanst\u00e4llning av exempel som jag anv\u00e4nder mig av och inte ett helt\u00e4ckande utbildningsmaterial. Kanske \u00e4r det fler som har nytta … Forts\u00e4tt l\u00e4sa \u201dSpatial SQL #2\u201d\" \/>\n<meta property=\"og:url\" content=\"https:\/\/vgrblogg.se\/utveckling\/2018\/01\/09\/spatial-sql-2\/\" \/>\n<meta property=\"og:site_name\" content=\"Utveckling i VGR\" \/>\n<meta property=\"article:published_time\" content=\"2018-01-09T08:30:23+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2018-01-18T14:49:40+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/vgrblogg.se\/utveckling\/wp-content\/uploads\/sites\/3\/2018\/01\/sql_befolkning.jpg\" \/>\n<meta name=\"author\" content=\"Magnus Nilsson\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Skriven av\" \/>\n\t<meta name=\"twitter:data1\" content=\"Magnus Nilsson\" \/>\n\t<meta name=\"twitter:label2\" content=\"Ber\u00e4knad l\u00e4stid\" \/>\n\t<meta name=\"twitter:data2\" content=\"3 minuter\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/vgrblogg.se\/utveckling\/2018\/01\/09\/spatial-sql-2\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/vgrblogg.se\/utveckling\/2018\/01\/09\/spatial-sql-2\/\"},\"author\":{\"name\":\"Magnus Nilsson\",\"@id\":\"https:\/\/vgrblogg.se\/utveckling\/#\/schema\/person\/5a867bf0a80df151ec2e483ec15ff3c9\"},\"headline\":\"Spatial SQL #2\",\"datePublished\":\"2018-01-09T08:30:23+00:00\",\"dateModified\":\"2018-01-18T14:49:40+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/vgrblogg.se\/utveckling\/2018\/01\/09\/spatial-sql-2\/\"},\"wordCount\":110,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/vgrblogg.se\/utveckling\/#organization\"},\"image\":{\"@id\":\"https:\/\/vgrblogg.se\/utveckling\/2018\/01\/09\/spatial-sql-2\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/vgrblogg.se\/utveckling\/wp-content\/uploads\/sites\/3\/2018\/01\/sql_befolkning.jpg\",\"keywords\":[\"Statistik\",\"Structured Query Language (SQL)\"],\"articleSection\":[\"Geo-perspektiv\"],\"inLanguage\":\"sv-SE\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/vgrblogg.se\/utveckling\/2018\/01\/09\/spatial-sql-2\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/vgrblogg.se\/utveckling\/2018\/01\/09\/spatial-sql-2\/\",\"url\":\"https:\/\/vgrblogg.se\/utveckling\/2018\/01\/09\/spatial-sql-2\/\",\"name\":\"Spatial SQL #2 — Utveckling i VGR\",\"isPartOf\":{\"@id\":\"https:\/\/vgrblogg.se\/utveckling\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/vgrblogg.se\/utveckling\/2018\/01\/09\/spatial-sql-2\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/vgrblogg.se\/utveckling\/2018\/01\/09\/spatial-sql-2\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/vgrblogg.se\/utveckling\/wp-content\/uploads\/sites\/3\/2018\/01\/sql_befolkning.jpg\",\"datePublished\":\"2018-01-09T08:30:23+00:00\",\"dateModified\":\"2018-01-18T14:49:40+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/vgrblogg.se\/utveckling\/2018\/01\/09\/spatial-sql-2\/#breadcrumb\"},\"inLanguage\":\"sv-SE\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/vgrblogg.se\/utveckling\/2018\/01\/09\/spatial-sql-2\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"sv-SE\",\"@id\":\"https:\/\/vgrblogg.se\/utveckling\/2018\/01\/09\/spatial-sql-2\/#primaryimage\",\"url\":\"https:\/\/vgrblogg.se\/utveckling\/wp-content\/uploads\/sites\/3\/2018\/01\/sql_befolkning.jpg\",\"contentUrl\":\"https:\/\/vgrblogg.se\/utveckling\/wp-content\/uploads\/sites\/3\/2018\/01\/sql_befolkning.jpg\",\"width\":613,\"height\":441},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/vgrblogg.se\/utveckling\/2018\/01\/09\/spatial-sql-2\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Hem\",\"item\":\"https:\/\/vgrblogg.se\/utveckling\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Spatial SQL #2\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/vgrblogg.se\/utveckling\/#website\",\"url\":\"https:\/\/vgrblogg.se\/utveckling\/\",\"name\":\"Utveckling i VGR\",\"description\":\"Inblick i utvecklingsarbetet inom VGR\",\"publisher\":{\"@id\":\"https:\/\/vgrblogg.se\/utveckling\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/vgrblogg.se\/utveckling\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"sv-SE\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/vgrblogg.se\/utveckling\/#organization\",\"name\":\"Utveckling i VGR\",\"url\":\"https:\/\/vgrblogg.se\/utveckling\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"sv-SE\",\"@id\":\"https:\/\/vgrblogg.se\/utveckling\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/vgrblogg.se\/utveckling\/wp-content\/uploads\/sites\/3\/2018\/02\/cropped-logotype_color-1.png\",\"contentUrl\":\"https:\/\/vgrblogg.se\/utveckling\/wp-content\/uploads\/sites\/3\/2018\/02\/cropped-logotype_color-1.png\",\"width\":1234,\"height\":250,\"caption\":\"Utveckling i VGR\"},\"image\":{\"@id\":\"https:\/\/vgrblogg.se\/utveckling\/#\/schema\/logo\/image\/\"}},{\"@type\":\"Person\",\"@id\":\"https:\/\/vgrblogg.se\/utveckling\/#\/schema\/person\/5a867bf0a80df151ec2e483ec15ff3c9\",\"name\":\"Magnus Nilsson\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"sv-SE\",\"@id\":\"https:\/\/vgrblogg.se\/utveckling\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/aa666eaf797c3ca4d0492450cd59249b?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/aa666eaf797c3ca4d0492450cd59249b?s=96&d=mm&r=g\",\"caption\":\"Magnus Nilsson\"},\"url\":\"https:\/\/vgrblogg.se\/utveckling\/author\/magnusnilssonvgr\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Spatial SQL #2 — Utveckling i VGR","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/vgrblogg.se\/utveckling\/2018\/01\/09\/spatial-sql-2\/","og_locale":"sv_SE","og_type":"article","og_title":"Spatial SQL #2 — Utveckling i VGR","og_description":"Spatial SQL \u201dLite mindre prosa, lite fler till\u00e4mpningar\u201d skrev jag nyligen. H\u00e4r kommer d\u00e4rf\u00f6r inl\u00e4gg #2 om vad jag l\u00e4r mig inom spatial SQL. #1 hittar du h\u00e4r. Precis som f\u00f6rra g\u00e5ngen \u00e4r det en sammanst\u00e4llning av exempel som jag anv\u00e4nder mig av och inte ett helt\u00e4ckande utbildningsmaterial. Kanske \u00e4r det fler som har nytta … Forts\u00e4tt l\u00e4sa \u201dSpatial SQL #2\u201d","og_url":"https:\/\/vgrblogg.se\/utveckling\/2018\/01\/09\/spatial-sql-2\/","og_site_name":"Utveckling i VGR","article_published_time":"2018-01-09T08:30:23+00:00","article_modified_time":"2018-01-18T14:49:40+00:00","og_image":[{"url":"https:\/\/vgrblogg.se\/utveckling\/wp-content\/uploads\/sites\/3\/2018\/01\/sql_befolkning.jpg","type":"","width":"","height":""}],"author":"Magnus Nilsson","twitter_card":"summary_large_image","twitter_misc":{"Skriven av":"Magnus Nilsson","Ber\u00e4knad l\u00e4stid":"3 minuter"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/vgrblogg.se\/utveckling\/2018\/01\/09\/spatial-sql-2\/#article","isPartOf":{"@id":"https:\/\/vgrblogg.se\/utveckling\/2018\/01\/09\/spatial-sql-2\/"},"author":{"name":"Magnus Nilsson","@id":"https:\/\/vgrblogg.se\/utveckling\/#\/schema\/person\/5a867bf0a80df151ec2e483ec15ff3c9"},"headline":"Spatial SQL #2","datePublished":"2018-01-09T08:30:23+00:00","dateModified":"2018-01-18T14:49:40+00:00","mainEntityOfPage":{"@id":"https:\/\/vgrblogg.se\/utveckling\/2018\/01\/09\/spatial-sql-2\/"},"wordCount":110,"commentCount":0,"publisher":{"@id":"https:\/\/vgrblogg.se\/utveckling\/#organization"},"image":{"@id":"https:\/\/vgrblogg.se\/utveckling\/2018\/01\/09\/spatial-sql-2\/#primaryimage"},"thumbnailUrl":"https:\/\/vgrblogg.se\/utveckling\/wp-content\/uploads\/sites\/3\/2018\/01\/sql_befolkning.jpg","keywords":["Statistik","Structured Query Language (SQL)"],"articleSection":["Geo-perspektiv"],"inLanguage":"sv-SE","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/vgrblogg.se\/utveckling\/2018\/01\/09\/spatial-sql-2\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/vgrblogg.se\/utveckling\/2018\/01\/09\/spatial-sql-2\/","url":"https:\/\/vgrblogg.se\/utveckling\/2018\/01\/09\/spatial-sql-2\/","name":"Spatial SQL #2 — Utveckling i VGR","isPartOf":{"@id":"https:\/\/vgrblogg.se\/utveckling\/#website"},"primaryImageOfPage":{"@id":"https:\/\/vgrblogg.se\/utveckling\/2018\/01\/09\/spatial-sql-2\/#primaryimage"},"image":{"@id":"https:\/\/vgrblogg.se\/utveckling\/2018\/01\/09\/spatial-sql-2\/#primaryimage"},"thumbnailUrl":"https:\/\/vgrblogg.se\/utveckling\/wp-content\/uploads\/sites\/3\/2018\/01\/sql_befolkning.jpg","datePublished":"2018-01-09T08:30:23+00:00","dateModified":"2018-01-18T14:49:40+00:00","breadcrumb":{"@id":"https:\/\/vgrblogg.se\/utveckling\/2018\/01\/09\/spatial-sql-2\/#breadcrumb"},"inLanguage":"sv-SE","potentialAction":[{"@type":"ReadAction","target":["https:\/\/vgrblogg.se\/utveckling\/2018\/01\/09\/spatial-sql-2\/"]}]},{"@type":"ImageObject","inLanguage":"sv-SE","@id":"https:\/\/vgrblogg.se\/utveckling\/2018\/01\/09\/spatial-sql-2\/#primaryimage","url":"https:\/\/vgrblogg.se\/utveckling\/wp-content\/uploads\/sites\/3\/2018\/01\/sql_befolkning.jpg","contentUrl":"https:\/\/vgrblogg.se\/utveckling\/wp-content\/uploads\/sites\/3\/2018\/01\/sql_befolkning.jpg","width":613,"height":441},{"@type":"BreadcrumbList","@id":"https:\/\/vgrblogg.se\/utveckling\/2018\/01\/09\/spatial-sql-2\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Hem","item":"https:\/\/vgrblogg.se\/utveckling\/"},{"@type":"ListItem","position":2,"name":"Spatial SQL #2"}]},{"@type":"WebSite","@id":"https:\/\/vgrblogg.se\/utveckling\/#website","url":"https:\/\/vgrblogg.se\/utveckling\/","name":"Utveckling i VGR","description":"Inblick i utvecklingsarbetet inom VGR","publisher":{"@id":"https:\/\/vgrblogg.se\/utveckling\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/vgrblogg.se\/utveckling\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"sv-SE"},{"@type":"Organization","@id":"https:\/\/vgrblogg.se\/utveckling\/#organization","name":"Utveckling i VGR","url":"https:\/\/vgrblogg.se\/utveckling\/","logo":{"@type":"ImageObject","inLanguage":"sv-SE","@id":"https:\/\/vgrblogg.se\/utveckling\/#\/schema\/logo\/image\/","url":"https:\/\/vgrblogg.se\/utveckling\/wp-content\/uploads\/sites\/3\/2018\/02\/cropped-logotype_color-1.png","contentUrl":"https:\/\/vgrblogg.se\/utveckling\/wp-content\/uploads\/sites\/3\/2018\/02\/cropped-logotype_color-1.png","width":1234,"height":250,"caption":"Utveckling i VGR"},"image":{"@id":"https:\/\/vgrblogg.se\/utveckling\/#\/schema\/logo\/image\/"}},{"@type":"Person","@id":"https:\/\/vgrblogg.se\/utveckling\/#\/schema\/person\/5a867bf0a80df151ec2e483ec15ff3c9","name":"Magnus Nilsson","image":{"@type":"ImageObject","inLanguage":"sv-SE","@id":"https:\/\/vgrblogg.se\/utveckling\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/aa666eaf797c3ca4d0492450cd59249b?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/aa666eaf797c3ca4d0492450cd59249b?s=96&d=mm&r=g","caption":"Magnus Nilsson"},"url":"https:\/\/vgrblogg.se\/utveckling\/author\/magnusnilssonvgr\/"}]}},"_links":{"self":[{"href":"https:\/\/vgrblogg.se\/utveckling\/wp-json\/wp\/v2\/posts\/1313"}],"collection":[{"href":"https:\/\/vgrblogg.se\/utveckling\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/vgrblogg.se\/utveckling\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/vgrblogg.se\/utveckling\/wp-json\/wp\/v2\/users\/4"}],"replies":[{"embeddable":true,"href":"https:\/\/vgrblogg.se\/utveckling\/wp-json\/wp\/v2\/comments?post=1313"}],"version-history":[{"count":2,"href":"https:\/\/vgrblogg.se\/utveckling\/wp-json\/wp\/v2\/posts\/1313\/revisions"}],"predecessor-version":[{"id":1395,"href":"https:\/\/vgrblogg.se\/utveckling\/wp-json\/wp\/v2\/posts\/1313\/revisions\/1395"}],"wp:attachment":[{"href":"https:\/\/vgrblogg.se\/utveckling\/wp-json\/wp\/v2\/media?parent=1313"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/vgrblogg.se\/utveckling\/wp-json\/wp\/v2\/categories?post=1313"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/vgrblogg.se\/utveckling\/wp-json\/wp\/v2\/tags?post=1313"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}