{"id":1157,"date":"2017-09-28T10:29:55","date_gmt":"2017-09-28T08:29:55","guid":{"rendered":"https:\/\/vgrutv.wordpress.com\/?p=1157"},"modified":"2017-09-28T10:29:55","modified_gmt":"2017-09-28T08:29:55","slug":"spatial-sql-mha-postgis","status":"publish","type":"post","link":"https:\/\/vgrblogg.se\/utveckling\/2017\/09\/28\/spatial-sql-mha-postgis\/","title":{"rendered":"Spatial SQL mha PostGIS"},"content":{"rendered":"

\"PostGIS\"<\/p>\n

N\u00e5gra av landets v\u00e4stligaste v\u00e5rdcentraler ihop med Topografisk Webbkarta Visning \u00a9 Lantm\u00e4teriet.<\/em><\/p>\n

Ja, det st\u00e4mmer att jag h\u00e5ller p\u00e5 att putsa p\u00e5 mina kunskaper i PostGIS. Jag tror att det \u00e4r klokt att ha kunskap om flera metoder och verktyg f\u00f6r att l\u00f6sa en uppgift och jag har l\u00e4nge k\u00e4nt behov av ett personligt kunskapslyft inom PostGIS. Eftersom n\u00e4tverksdisken brukar vara b\u00e4ttre \u00e4n jag p\u00e5 att komma ih\u00e5g SQL-detaljerna, sparar jag de flesta av mina SQL-fr\u00e5gor d\u00e4r. Det \u00e4r aningen or\u00e4ttvist att den som vill l\u00e4ra sig mer om detta verktyg, men inte kommer \u00e5t n\u00e4tverket, inte f\u00e5r tillg\u00e5ng till samlingen, s\u00e5 jag l\u00e4gger ut ett axplock h\u00e4r p\u00e5 bloggen. Syftet \u00e4r inte att utg\u00f6ra ett utbildningsmaterial eller att vara helt\u00e4ckande, utan det \u00e4r endast en sammanst\u00e4llning av ett antal SQL-fr\u00e5gor som har hj\u00e4lp mig i arbetet. F\u00f6rhoppningsvis \u00e4r det n\u00e5gon mer som har nytta av dem. Jag r\u00e4knar med att \u00e5terkomma med fler exempel fram\u00f6ver. Nog s\u00e5, h\u00e4r kommer det.<\/p>\n

L\u00e4gg till extensions<\/strong>\nCREATE EXTENSION postgis;\nCREATE EXTENSION postgis_topology;\nCREATE EXTENSION postgis_sfcgal;\nCREATE EXTENSION fuzzystrmatch;\nCREATE EXTENSION pgrouting;<\/pre>\n
Version av PostgreSQL, PostGIS och pgRouting<\/strong>\nSELECT version();\nSELECT postgis_full_version();\nSELECT pgr_version();<\/pre>\n
<\/p>\n
Lista alla tabeller i schemat public<\/strong>\nSELECT table_name FROM information_schema.tables WHERE table_schema = 'public';<\/pre>\n
L\u00e4gg till kommentar om tabell<\/strong>\nCOMMENT ON TABLE public.adresser IS 'Adresser f\u00f6r V\u00e4stra G\u00f6taland';<\/pre>\n
Tilldela beh\u00f6righeter till tabell<\/strong>\nGRANT SELECT, INSERT, UPDATE, DELETE ON tabell TO user;<\/pre>\n
L\u00e4gg till kolumn f\u00f6r punktgeometri<\/strong>\nALTER TABLE tabell ADD COLUMN geom geometry(POINT,3006);<\/pre>\n
R\u00e4kna antalet poster i en tabell<\/strong>\nSELECT count(*) FROM routes;<\/pre>\n
Ta reda p\u00e5 referenssystem f\u00f6r en tabell<\/strong>\nSELECT Find_SRID('public', 'sjukhus', 'geom');<\/pre>\n
Ta reda p\u00e5 geometrityp<\/strong>\nSELECT ST_GeometryType(geom) \nFROM kommunytor_vg;<\/pre>\n
V\u00e4lj unika v\u00e4rden<\/strong>\nSELECT DISTINCT ort FROM vardcentraler;<\/pre>\n
Skapa linjer fr\u00e5n polygoner<\/strong>\nSELECT id, kommunnamn, ST_Boundary(geom) \nFROM kommunytor_vg;<\/pre>\n
Buffra 100 m runt v\u00e5rdcentraler<\/strong>\nSELECT id, namn, ST_Buffer(vardcentraler_vg.geom, 100)\n FROM vardcentraler_vg;<\/pre>\n
Ber\u00e4kna area<\/strong>\nSELECT kommunkod, kommunnamn, ST_Area(geom), geom FROM kommunytor;<\/pre>\n
Summera area (i km2)<\/strong>\nSELECT sum(ST_Area(geom))\/1000000 FROM kommunytor_vg;<\/pre>\n
Ber\u00e4kna linjel\u00e4ngd och l\u00e4gg v\u00e4rdet i ett attribut<\/strong>\nUPDATE vagnat SET length = ST_Length(geom);<\/pre>\n
Summera linjel\u00e4ngder f\u00f6r hela tabellen<\/strong>\nSELECT sum(ST_Length(geom)) FROM tabell;<\/pre>\n
Summera linjel\u00e4ngd f\u00f6r linjer i resp. kommun<\/strong>\nSELECT kommunytor_vg.kommunnamn, sum(ST_Length(kollektivtrafik_linjeriktningar.geom)\/1000) AS total_langd\nFROM kollektivtrafik_linjeriktningar, kommunytor_vg \nWHERE st_intersects(kommunytor_vg.geom,kollektivtrafik_linjeriktningar.geom) \nGROUP BY kommunytor_vg.id\nORDER BY kommunnamn;<\/pre>\n
Hitta alla punkter inom specifik polygon<\/strong>\nSELECT tandlakare_folktandvarden.id, tandlakare_folktandvarden.namn, tandlakare_folktandvarden.geom\nFROM\n kommunytor_vg JOIN tandlakare_folktandvarden\nON ST_Contains(kommunytor_vg.geom, tandlakare_folktandvarden.geom)\nWHERE\n kommunytor_vg.kommunkod=1496;<\/pre>\n
R\u00e4kna v\u00e5rdcentraler, gruppera p\u00e5 kommun<\/strong>\nSELECT kommunnamn, count(*) AS antal_vc FROM vardcentraler_vg, kommunytor_vg \nWHERE st_intersects(kommunytor_vg.geom,vardcentraler_vg.geom) \nGROUP BY kommunytor_vg.id\nORDER BY kommunnamn;<\/pre>\n
S\u00f6k punkter inom 5km fr\u00e5n koordinat<\/strong>\nSELECT * FROM skolenheter \nWHERE ST_DWithin(geom, ST_SetSRID(ST_Point(319409, 6399807), 3006), 5000);<\/pre>\n
S\u00e5, med detta i \u00e5tanke kan du, n\u00e4sta g\u00e5ng du ser VGR:s logga, t\u00e4nka p\u00e5 v\u00e5ra v\u00e5rdcentraler, sjukhus, Folktandv\u00e5rden, G\u00f6teborgsOperan, G\u00f6teborgs Symfoniker, Film i V\u00e4st… och spatial SQL.<\/p>\n
En mer komplett sammanst\u00e4llning om funktionerna finner du p\u00e5 http:\/\/postgis.net\/docs\/manual-2.4\/reference.html<\/a>.<\/p>\n","protected":false},"excerpt":{"rendered":"
N\u00e5gra av landets v\u00e4stligaste v\u00e5rdcentraler ihop med Topografisk Webbkarta Visning \u00a9 Lantm\u00e4teriet. Ja, det st\u00e4mmer att jag h\u00e5ller p\u00e5 att putsa p\u00e5 mina kunskaper i PostGIS. Jag tror att det \u00e4r klokt att ha kunskap om flera metoder och verktyg f\u00f6r att l\u00f6sa en uppgift och jag har l\u00e4nge k\u00e4nt behov av ett personligt kunskapslyft … <\/p>\n
Forts\u00e4tt l\u00e4sa \u201dSpatial SQL mha PostGIS\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":[],"class_list":["post-1157","post","type-post","status-publish","format-standard","hentry","category-geo-perspektiv"],"yoast_head":"\nSpatial SQL mha PostGIS — 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\/2017\/09\/28\/spatial-sql-mha-postgis\/\" \/>\n<meta property=\"og:locale\" content=\"sv_SE\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Spatial SQL mha PostGIS — Utveckling i VGR\" \/>\n<meta property=\"og:description\" content=\"N\u00e5gra av landets v\u00e4stligaste v\u00e5rdcentraler ihop med Topografisk Webbkarta Visning \u00a9 Lantm\u00e4teriet. Ja, det st\u00e4mmer att jag h\u00e5ller p\u00e5 att putsa p\u00e5 mina kunskaper i PostGIS. Jag tror att det \u00e4r klokt att ha kunskap om flera metoder och verktyg f\u00f6r att l\u00f6sa en uppgift och jag har l\u00e4nge k\u00e4nt behov av ett personligt kunskapslyft … Forts\u00e4tt l\u00e4sa \u201dSpatial SQL mha PostGIS\u201d\" \/>\n<meta property=\"og:url\" content=\"https:\/\/vgrblogg.se\/utveckling\/2017\/09\/28\/spatial-sql-mha-postgis\/\" \/>\n<meta property=\"og:site_name\" content=\"Utveckling i VGR\" \/>\n<meta property=\"article:published_time\" content=\"2017-09-28T08:29:55+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/vgrblogg.se\/utveckling\/wp-content\/uploads\/sites\/3\/2017\/09\/postgis.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\/2017\/09\/28\/spatial-sql-mha-postgis\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/vgrblogg.se\/utveckling\/2017\/09\/28\/spatial-sql-mha-postgis\/\"},\"author\":{\"name\":\"Magnus Nilsson\",\"@id\":\"https:\/\/vgrblogg.se\/utveckling\/#\/schema\/person\/5a867bf0a80df151ec2e483ec15ff3c9\"},\"headline\":\"Spatial SQL mha PostGIS\",\"datePublished\":\"2017-09-28T08:29:55+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/vgrblogg.se\/utveckling\/2017\/09\/28\/spatial-sql-mha-postgis\/\"},\"wordCount\":251,\"commentCount\":2,\"publisher\":{\"@id\":\"https:\/\/vgrblogg.se\/utveckling\/#organization\"},\"image\":{\"@id\":\"https:\/\/vgrblogg.se\/utveckling\/2017\/09\/28\/spatial-sql-mha-postgis\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/vgrblogg.se\/utveckling\/wp-content\/uploads\/sites\/3\/2017\/09\/postgis.jpg\",\"articleSection\":[\"Geo-perspektiv\"],\"inLanguage\":\"sv-SE\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/vgrblogg.se\/utveckling\/2017\/09\/28\/spatial-sql-mha-postgis\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/vgrblogg.se\/utveckling\/2017\/09\/28\/spatial-sql-mha-postgis\/\",\"url\":\"https:\/\/vgrblogg.se\/utveckling\/2017\/09\/28\/spatial-sql-mha-postgis\/\",\"name\":\"Spatial SQL mha PostGIS — Utveckling i VGR\",\"isPartOf\":{\"@id\":\"https:\/\/vgrblogg.se\/utveckling\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/vgrblogg.se\/utveckling\/2017\/09\/28\/spatial-sql-mha-postgis\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/vgrblogg.se\/utveckling\/2017\/09\/28\/spatial-sql-mha-postgis\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/vgrblogg.se\/utveckling\/wp-content\/uploads\/sites\/3\/2017\/09\/postgis.jpg\",\"datePublished\":\"2017-09-28T08:29:55+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/vgrblogg.se\/utveckling\/2017\/09\/28\/spatial-sql-mha-postgis\/#breadcrumb\"},\"inLanguage\":\"sv-SE\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/vgrblogg.se\/utveckling\/2017\/09\/28\/spatial-sql-mha-postgis\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"sv-SE\",\"@id\":\"https:\/\/vgrblogg.se\/utveckling\/2017\/09\/28\/spatial-sql-mha-postgis\/#primaryimage\",\"url\":\"https:\/\/vgrblogg.se\/utveckling\/wp-content\/uploads\/sites\/3\/2017\/09\/postgis.jpg\",\"contentUrl\":\"https:\/\/vgrblogg.se\/utveckling\/wp-content\/uploads\/sites\/3\/2017\/09\/postgis.jpg\",\"width\":982,\"height\":565},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/vgrblogg.se\/utveckling\/2017\/09\/28\/spatial-sql-mha-postgis\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Hem\",\"item\":\"https:\/\/vgrblogg.se\/utveckling\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Spatial SQL mha PostGIS\"}]},{\"@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 mha PostGIS — 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\/2017\/09\/28\/spatial-sql-mha-postgis\/","og_locale":"sv_SE","og_type":"article","og_title":"Spatial SQL mha PostGIS — Utveckling i VGR","og_description":"N\u00e5gra av landets v\u00e4stligaste v\u00e5rdcentraler ihop med Topografisk Webbkarta Visning \u00a9 Lantm\u00e4teriet. Ja, det st\u00e4mmer att jag h\u00e5ller p\u00e5 att putsa p\u00e5 mina kunskaper i PostGIS. Jag tror att det \u00e4r klokt att ha kunskap om flera metoder och verktyg f\u00f6r att l\u00f6sa en uppgift och jag har l\u00e4nge k\u00e4nt behov av ett personligt kunskapslyft … Forts\u00e4tt l\u00e4sa \u201dSpatial SQL mha PostGIS\u201d","og_url":"https:\/\/vgrblogg.se\/utveckling\/2017\/09\/28\/spatial-sql-mha-postgis\/","og_site_name":"Utveckling i VGR","article_published_time":"2017-09-28T08:29:55+00:00","og_image":[{"url":"https:\/\/vgrblogg.se\/utveckling\/wp-content\/uploads\/sites\/3\/2017\/09\/postgis.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\/2017\/09\/28\/spatial-sql-mha-postgis\/#article","isPartOf":{"@id":"https:\/\/vgrblogg.se\/utveckling\/2017\/09\/28\/spatial-sql-mha-postgis\/"},"author":{"name":"Magnus Nilsson","@id":"https:\/\/vgrblogg.se\/utveckling\/#\/schema\/person\/5a867bf0a80df151ec2e483ec15ff3c9"},"headline":"Spatial SQL mha PostGIS","datePublished":"2017-09-28T08:29:55+00:00","mainEntityOfPage":{"@id":"https:\/\/vgrblogg.se\/utveckling\/2017\/09\/28\/spatial-sql-mha-postgis\/"},"wordCount":251,"commentCount":2,"publisher":{"@id":"https:\/\/vgrblogg.se\/utveckling\/#organization"},"image":{"@id":"https:\/\/vgrblogg.se\/utveckling\/2017\/09\/28\/spatial-sql-mha-postgis\/#primaryimage"},"thumbnailUrl":"https:\/\/vgrblogg.se\/utveckling\/wp-content\/uploads\/sites\/3\/2017\/09\/postgis.jpg","articleSection":["Geo-perspektiv"],"inLanguage":"sv-SE","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/vgrblogg.se\/utveckling\/2017\/09\/28\/spatial-sql-mha-postgis\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/vgrblogg.se\/utveckling\/2017\/09\/28\/spatial-sql-mha-postgis\/","url":"https:\/\/vgrblogg.se\/utveckling\/2017\/09\/28\/spatial-sql-mha-postgis\/","name":"Spatial SQL mha PostGIS — Utveckling i VGR","isPartOf":{"@id":"https:\/\/vgrblogg.se\/utveckling\/#website"},"primaryImageOfPage":{"@id":"https:\/\/vgrblogg.se\/utveckling\/2017\/09\/28\/spatial-sql-mha-postgis\/#primaryimage"},"image":{"@id":"https:\/\/vgrblogg.se\/utveckling\/2017\/09\/28\/spatial-sql-mha-postgis\/#primaryimage"},"thumbnailUrl":"https:\/\/vgrblogg.se\/utveckling\/wp-content\/uploads\/sites\/3\/2017\/09\/postgis.jpg","datePublished":"2017-09-28T08:29:55+00:00","breadcrumb":{"@id":"https:\/\/vgrblogg.se\/utveckling\/2017\/09\/28\/spatial-sql-mha-postgis\/#breadcrumb"},"inLanguage":"sv-SE","potentialAction":[{"@type":"ReadAction","target":["https:\/\/vgrblogg.se\/utveckling\/2017\/09\/28\/spatial-sql-mha-postgis\/"]}]},{"@type":"ImageObject","inLanguage":"sv-SE","@id":"https:\/\/vgrblogg.se\/utveckling\/2017\/09\/28\/spatial-sql-mha-postgis\/#primaryimage","url":"https:\/\/vgrblogg.se\/utveckling\/wp-content\/uploads\/sites\/3\/2017\/09\/postgis.jpg","contentUrl":"https:\/\/vgrblogg.se\/utveckling\/wp-content\/uploads\/sites\/3\/2017\/09\/postgis.jpg","width":982,"height":565},{"@type":"BreadcrumbList","@id":"https:\/\/vgrblogg.se\/utveckling\/2017\/09\/28\/spatial-sql-mha-postgis\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Hem","item":"https:\/\/vgrblogg.se\/utveckling\/"},{"@type":"ListItem","position":2,"name":"Spatial SQL mha PostGIS"}]},{"@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\/1157"}],"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=1157"}],"version-history":[{"count":0,"href":"https:\/\/vgrblogg.se\/utveckling\/wp-json\/wp\/v2\/posts\/1157\/revisions"}],"wp:attachment":[{"href":"https:\/\/vgrblogg.se\/utveckling\/wp-json\/wp\/v2\/media?parent=1157"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/vgrblogg.se\/utveckling\/wp-json\/wp\/v2\/categories?post=1157"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/vgrblogg.se\/utveckling\/wp-json\/wp\/v2\/tags?post=1157"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}