aboutsummaryrefslogtreecommitdiffstats
diff options
context:
space:
mode:
authorGuilhem Moulin <guilhem@fripost.org>2024-10-19 17:08:33 +0200
committerGuilhem Moulin <guilhem@fripost.org>2024-10-19 18:12:10 +0200
commit4f56801e9737e1f9201ea5e2d1f23f759d65d437 (patch)
tree912a7bbf58c45e6f1859bd3d8ba43d61cea3fe53
parente61fd88fe81363d8f84e8f9c42b52c64314c4286 (diff)
Add layers from Svenska Kraftnät (SvK).
-rw-r--r--config.yml100
-rw-r--r--layers/.gitignore3
-rw-r--r--layers/custom/svk/transmissionsnatsprojekt.geojson1797
-rw-r--r--schema.sql309
-rwxr-xr-xwebmap-download2
-rwxr-xr-xwebmap-publish9
6 files changed, 2218 insertions, 2 deletions
diff --git a/config.yml b/config.yml
index f543c5c..7c2066b 100644
--- a/config.yml
+++ b/config.yml
@@ -67,6 +67,7 @@ layer-groups:
vbk: 'vbk:*'
mrr: 'mrr:*'
ri: 'ri:*'
+ svk: 'svk:*'
# Global GDAL/OGR configuration options, cf. https://gdal.org/user/configoptions.html and
@@ -3892,3 +3893,102 @@ layers:
format: ESRI Shapefile
layername: lst.LST_RI_Skyddade_vattendrag_MB4kap6
publish: skyddade_vattendrag
+
+ 'svk:ledningar':
+ # https://ext-geodatakatalog-forv.lansstyrelsen.se/PlaneringsKatalogen/GetMetaDataById?id=08ec56a0-6b5c-4f83-b29e-375e6f1a34b9_C
+ description: Kraftledningar (befintliga)
+ create:
+ geometry-type: MULTILINESTRING
+ fields:
+ - name: Placement
+ type: String
+ width: 32
+ - name: Voltage
+ # XXX convert to V?
+ type: Integer
+ source:
+ download: 'https://gis-services.metria.se/svkfeed/filer/SVK_STAMNAT.zip'
+ cache: svk/
+ unar:
+ format: zip
+ patterns:
+ - 'SVK_LEDNINGAR.*'
+ import:
+ path: 'SVK_LEDNINGAR.shp'
+ format: ESRI Shapefile
+ layername: SVK_LEDNINGAR
+ field-map:
+ 'FÖRLÄGGN': Placement
+ 'SPÄNNING': Voltage
+ value-map:
+ 'SPÄNNING':
+ - replace: 'Okänd'
+ with: null
+ - replace: '0'
+ with: null
+ publish: ledningar
+
+ 'svk:stolpar':
+ description: Stolpar (befintliga)
+ create:
+ geometry-type: POINTZ
+ fields: []
+ source:
+ download: 'https://gis-services.metria.se/svkfeed/filer/SVK_STAMNAT.zip'
+ cache: svk/
+ unar:
+ format: zip
+ patterns:
+ - 'SVK_STOLPAR.*'
+ import:
+ path: 'SVK_STOLPAR.shp'
+ format: ESRI Shapefile
+ layername: SVK_STOLPAR
+ publish: stolpar
+
+ 'svk:stationsomraden':
+ description: Stationsomraden
+ create:
+ geometry-type: MULTIPOLYGONZ
+ fields: []
+ source:
+ download: 'https://gis-services.metria.se/svkfeed/filer/SVK_STAMNAT.zip'
+ cache: svk/
+ unar:
+ format: zip
+ patterns:
+ - 'STATIONSOMRADEN.*'
+ import:
+ path: 'STATIONSOMRADEN.shp'
+ format: ESRI Shapefile
+ layername: STATIONSOMRADEN
+ publish:
+ stationer:
+ transform-geometry: centroid
+ maxzoom: 6
+ stationsomraden:
+ minzoom: 7
+
+ 'svk:transmissionsnatsprojekt':
+ # https://www.svk.se/utveckling-av-kraftsystemet/transmissionsnatet/transmissionsnatsprojekt/
+ description: Transmissionsnätsprojekt
+ create:
+ geometry-type: MULTILINESTRING
+ fields:
+ - name: Name
+ type: String
+ width: 254
+ - name: Voltage
+ # XXX convert to V?
+ type: Integer
+ - name: Url
+ type: String
+ width: 254
+ import:
+ path: custom/svk/transmissionsnatsprojekt.geojson
+ format: GeoJSON
+ field-map:
+ 'name': Name
+ 'voltage': Voltage
+ 'url': Url
+ publish: transmissionsnatsprojekt
diff --git a/layers/.gitignore b/layers/.gitignore
new file mode 100644
index 0000000..b86e025
--- /dev/null
+++ b/layers/.gitignore
@@ -0,0 +1,3 @@
+!/custom/
+/*.zip
+/*/
diff --git a/layers/custom/svk/transmissionsnatsprojekt.geojson b/layers/custom/svk/transmissionsnatsprojekt.geojson
new file mode 100644
index 0000000..b0cee50
--- /dev/null
+++ b/layers/custom/svk/transmissionsnatsprojekt.geojson
@@ -0,0 +1,1797 @@
+{
+ "type": "FeatureCollection",
+ "name": "Transmissionsnätsprojekt",
+ "crs": {
+ "type": "name",
+ "properties": {
+ "name": "urn:ogc:def:crs:EPSG::3006"
+ }
+ },
+ "features": [
+ {
+ "type": "Feature",
+ "properties": {
+ "name": "Aurora Line",
+ "voltage": 400,
+ "url": "https://www.svk.se/utveckling-av-kraftsystemet/transmissionsnatet/transmissionsnatsprojekt/aurora-line/"
+ },
+ "geometry": {
+ "type": "MultiLineString",
+ "coordinates": [
+ [
+ [
+ 735379.35,
+ 7405916.15
+ ],
+ [
+ 735417.71,
+ 7405943.93
+ ],
+ [
+ 736428.42,
+ 7405666.12
+ ],
+ [
+ 739150.98,
+ 7401022.68
+ ],
+ [
+ 743016.55,
+ 7396794.64
+ ],
+ [
+ 747728.78,
+ 7394254.64
+ ],
+ [
+ 748238.57,
+ 7393821.85
+ ],
+ [
+ 748847.11,
+ 7392705.3
+ ],
+ [
+ 754540.95,
+ 7382465.93
+ ],
+ [
+ 754707.63,
+ 7382315.12
+ ],
+ [
+ 767185.38,
+ 7380470.97
+ ],
+ [
+ 771905.55,
+ 7379309.45
+ ],
+ [
+ 772731.05,
+ 7379087.2
+ ],
+ [
+ 772979.76,
+ 7379050.16
+ ],
+ [
+ 776675.99,
+ 7378883.47
+ ],
+ [
+ 777512.07,
+ 7378804.1
+ ],
+ [
+ 777893.07,
+ 7378743.24
+ ],
+ [
+ 780591.82,
+ 7378097.66
+ ],
+ [
+ 784682.28,
+ 7377751.05
+ ],
+ [
+ 789913.09,
+ 7376793.26
+ ],
+ [
+ 790362.88,
+ 7376748.28
+ ],
+ [
+ 792905.53,
+ 7376716.53
+ ],
+ [
+ 795837.11,
+ 7375488.87
+ ],
+ [
+ 799091.49,
+ 7375345.99
+ ],
+ [
+ 803200.47,
+ 7374319.41
+ ],
+ [
+ 807841.26,
+ 7374663.37
+ ],
+ [
+ 812209.53,
+ 7374708.35
+ ],
+ [
+ 825070.93,
+ 7371853.49
+ ],
+ [
+ 830923.51,
+ 7371358.72
+ ],
+ [
+ 834154.07,
+ 7370713.14
+ ],
+ [
+ 835555.75,
+ 7370931.77
+ ],
+ [
+ 836733.43,
+ 7370995.54
+ ],
+ [
+ 836826.96,
+ 7370961.53
+ ],
+ [
+ 836963.01,
+ 7370668.17
+ ],
+ [
+ 837090.56,
+ 7370506.61
+ ],
+ [
+ 837715.53,
+ 7370260.02
+ ],
+ [
+ 840660.18,
+ 7369858.53
+ ],
+ [
+ 841284.59,
+ 7369961.72
+ ],
+ [
+ 841681.47,
+ 7369948.49
+ ],
+ [
+ 842067.76,
+ 7369797.68
+ ],
+ [
+ 850148.13,
+ 7369543.68
+ ],
+ [
+ 850410.07,
+ 7369556.91
+ ],
+ [
+ 852471.18,
+ 7369324.07
+ ],
+ [
+ 856529.88,
+ 7367180.95
+ ],
+ [
+ 862599.43,
+ 7367538.14
+ ],
+ [
+ 864798.11,
+ 7367979.99
+ ],
+ [
+ 865148.21,
+ 7368247.42
+ ],
+ [
+ 865437.93,
+ 7368342.67
+ ],
+ [
+ 865842.74,
+ 7368295.04
+ ],
+ [
+ 866203.05,
+ 7368260.45
+ ],
+ [
+ 868340.88,
+ 7368697.01
+ ],
+ [
+ 871566.16,
+ 7369252.64
+ ],
+ [
+ 871899.53,
+ 7369451.07
+ ],
+ [
+ 872209.09,
+ 7369525.16
+ ],
+ [
+ 872573.74,
+ 7369501.54
+ ],
+ [
+ 872833.51,
+ 7369466.95
+ ],
+ [
+ 876339.24,
+ 7370078.14
+ ],
+ [
+ 881110.53,
+ 7369513.45
+ ]
+ ],
+ [
+ [
+ 881181.77,
+ 7369503.0
+ ],
+ [
+ 883850.76,
+ 7369189.14
+ ],
+ [
+ 886967.55,
+ 7368443.01
+ ],
+ [
+ 890659.34,
+ 7367564.79
+ ],
+ [
+ 895637.95,
+ 7366781.43
+ ],
+ [
+ 895981.43,
+ 7366806.76
+ ],
+ [
+ 896779.15,
+ 7367136.17
+ ]
+ ]
+ ]
+ }
+ },
+ {
+ "type": "Feature",
+ "properties": {
+ "name": "Letsi–Svartbyn",
+ "voltage": 400,
+ "url": "https://www.svk.se/utveckling-av-kraftsystemet/transmissionsnatet/transmissionsnatsprojekt/letsisvartbyn/"
+ },
+ "geometry": {
+ "type": "LineString",
+ "coordinates": [
+ [
+ 739618.45,
+ 7386746.89
+ ],
+ [
+ 739605.88,
+ 7386843.79
+ ],
+ [
+ 739910.15,
+ 7386870.25
+ ],
+ [
+ 740330.84,
+ 7386798.81
+ ],
+ [
+ 740666.86,
+ 7386677.1
+ ],
+ [
+ 743063.98,
+ 7385637.29
+ ],
+ [
+ 746096.11,
+ 7384420.21
+ ],
+ [
+ 750488.19,
+ 7382520.5
+ ],
+ [
+ 751363.96,
+ 7383094.64
+ ],
+ [
+ 751729.09,
+ 7383142.27
+ ],
+ [
+ 752078.34,
+ 7383060.25
+ ],
+ [
+ 754017.73,
+ 7382427.89
+ ],
+ [
+ 754576.0,
+ 7382319.42
+ ],
+ [
+ 759063.34,
+ 7378072.85
+ ],
+ [
+ 761616.57,
+ 7374987.81
+ ],
+ [
+ 766233.55,
+ 7369431.56
+ ],
+ [
+ 768511.61,
+ 7366690.48
+ ],
+ [
+ 770956.36,
+ 7363729.79
+ ],
+ [
+ 773409.05,
+ 7359597.0
+ ],
+ [
+ 774181.63,
+ 7358567.77
+ ],
+ [
+ 775239.96,
+ 7357228.98
+ ],
+ [
+ 775374.9,
+ 7357022.6
+ ],
+ [
+ 777028.55,
+ 7354485.25
+ ],
+ [
+ 779468.0,
+ 7350738.75
+ ],
+ [
+ 779621.46,
+ 7350606.46
+ ],
+ [
+ 780333.19,
+ 7350336.58
+ ],
+ [
+ 781997.42,
+ 7349622.21
+ ],
+ [
+ 783365.32,
+ 7348550.64
+ ],
+ [
+ 784997.8,
+ 7347262.12
+ ],
+ [
+ 786913.38,
+ 7345931.27
+ ],
+ [
+ 787095.94,
+ 7345777.81
+ ],
+ [
+ 787810.32,
+ 7344690.37
+ ],
+ [
+ 788434.73,
+ 7342610.75
+ ],
+ [
+ 792014.55,
+ 7338422.39
+ ],
+ [
+ 792162.71,
+ 7338287.46
+ ],
+ [
+ 794237.05,
+ 7336930.14
+ ],
+ [
+ 796306.09,
+ 7335967.06
+ ],
+ [
+ 797464.96,
+ 7334802.89
+ ],
+ [
+ 799203.27,
+ 7332281.42
+ ],
+ [
+ 800573.82,
+ 7330918.81
+ ],
+ [
+ 801912.61,
+ 7329894.87
+ ],
+ [
+ 803182.61,
+ 7329058.79
+ ],
+ [
+ 803838.77,
+ 7328175.08
+ ],
+ [
+ 804383.82,
+ 7326312.42
+ ],
+ [
+ 805942.21,
+ 7324037.0
+ ],
+ [
+ 808019.19,
+ 7321708.67
+ ],
+ [
+ 811016.92,
+ 7316972.62
+ ],
+ [
+ 812398.05,
+ 7315395.71
+ ]
+ ]
+ }
+ },
+ {
+ "type": "Feature",
+ "properties": {
+ "name": "Naalojärvi–Messaure",
+ "voltage": 400,
+ "url": "https://www.svk.se/utveckling-av-kraftsystemet/transmissionsnatet/transmissionsnatsprojekt/naalojarvimessaure/"
+ },
+ "geometry": {
+ "type": "LineString",
+ "coordinates": [
+ [
+ 735364.93,
+ 7405933.67
+ ],
+ [
+ 735409.57,
+ 7405968.74
+ ],
+ [
+ 735658.28,
+ 7405906.03
+ ],
+ [
+ 735896.37,
+ 7406357.76
+ ],
+ [
+ 736209.39,
+ 7406819.58
+ ],
+ [
+ 736497.43,
+ 7407426.49
+ ],
+ [
+ 737096.37,
+ 7408013.73
+ ],
+ [
+ 743143.13,
+ 7464295.67
+ ]
+ ]
+ }
+ },
+ {
+ "type": "Feature",
+ "properties": {
+ "name": "Porjusberget–Naalojärvi (Vitåfors)",
+ "voltage": 400,
+ "url": "https://www.svk.se/utveckling-av-kraftsystemet/transmissionsnatet/transmissionsnatsprojekt/porjusberget-naalojarvi-vitafors/"
+ },
+ "geometry": {
+ "type": "LineString",
+ "coordinates": [
+ [
+ 743103.45,
+ 7464377.87
+ ],
+ [
+ 742615.94,
+ 7464230.48
+ ],
+ [
+ 742366.51,
+ 7463524.73
+ ],
+ [
+ 741567.22,
+ 7463040.05
+ ],
+ [
+ 741082.55,
+ 7462433.5
+ ],
+ [
+ 739529.32,
+ 7460429.6
+ ],
+ [
+ 738731.8,
+ 7459407.45
+ ],
+ [
+ 738268.78,
+ 7458626.93
+ ],
+ [
+ 737072.86,
+ 7456309.18
+ ],
+ [
+ 736509.3,
+ 7455332.86
+ ],
+ [
+ 735429.8,
+ 7453483.43
+ ],
+ [
+ 734768.34,
+ 7452348.36
+ ],
+ [
+ 734630.76,
+ 7452213.43
+ ],
+ [
+ 732813.07,
+ 7450975.18
+ ],
+ [
+ 732225.69,
+ 7450607.41
+ ],
+ [
+ 729624.84,
+ 7448945.82
+ ],
+ [
+ 728828.44,
+ 7448551.59
+ ],
+ [
+ 728547.98,
+ 7448466.93
+ ],
+ [
+ 721883.13,
+ 7447157.24
+ ],
+ [
+ 720242.71,
+ 7446162.41
+ ],
+ [
+ 719136.76,
+ 7445220.49
+ ],
+ [
+ 717874.69,
+ 7443326.07
+ ],
+ [
+ 716176.07,
+ 7441399.91
+ ],
+ [
+ 714837.28,
+ 7439881.2
+ ],
+ [
+ 712543.34,
+ 7436039.45
+ ],
+ [
+ 711403.19,
+ 7434742.25
+ ],
+ [
+ 711474.42,
+ 7434118.57
+ ],
+ [
+ 711197.45,
+ 7434117.11
+ ]
+ ]
+ }
+ },
+ {
+ "type": "Feature",
+ "properties": {
+ "name": "Svartbyn–Hällmyran",
+ "voltage": 400,
+ "url": "https://www.svk.se/utveckling-av-kraftsystemet/transmissionsnatet/transmissionsnatsprojekt/svartbyn-hallmyran/"
+ },
+ "geometry": {
+ "type": "LineString",
+ "coordinates": [
+ [
+ 812586.71,
+ 7315147.79
+ ],
+ [
+ 812658.14,
+ 7315026.09
+ ],
+ [
+ 812779.85,
+ 7314224.4
+ ],
+ [
+ 812867.17,
+ 7313891.02
+ ],
+ [
+ 815100.25,
+ 7309303.15
+ ],
+ [
+ 816637.48,
+ 7306821.36
+ ],
+ [
+ 816830.62,
+ 7306509.15
+ ],
+ [
+ 817613.79,
+ 7305030.13
+ ],
+ [
+ 819460.58,
+ 7303130.42
+ ],
+ [
+ 821593.12,
+ 7303225.67
+ ],
+ [
+ 823723.02,
+ 7300892.04
+ ],
+ [
+ 825839.69,
+ 7299346.88
+ ],
+ [
+ 828895.62,
+ 7300439.61
+ ],
+ [
+ 829998.94,
+ 7299778.15
+ ],
+ [
+ 830912.0,
+ 7298910.61
+ ]
+ ]
+ }
+ },
+ {
+ "type": "Feature",
+ "properties": {
+ "name": "Svartbyn–Keminmaa",
+ "voltage": 400,
+ "url": "https://www.svk.se/utveckling-av-kraftsystemet/transmissionsnatet/transmissionsnatsprojekt/svartbynkeminmaa/"
+ },
+ "geometry": {
+ "type": "MultiLineString",
+ "coordinates": [
+ [
+ [
+ 812567.92,
+ 7315225.09
+ ],
+ [
+ 812605.26,
+ 7315194.93
+ ],
+ [
+ 812858.05,
+ 7315355.8
+ ],
+ [
+ 813034.72,
+ 7315480.04
+ ],
+ [
+ 813165.42,
+ 7315573.4
+ ],
+ [
+ 813566.86,
+ 7315859.22
+ ],
+ [
+ 813768.66,
+ 7315968.38
+ ],
+ [
+ 814079.62,
+ 7316135.71
+ ],
+ [
+ 814778.88,
+ 7316512.21
+ ],
+ [
+ 816162.65,
+ 7317213.35
+ ],
+ [
+ 816904.8,
+ 7317585.09
+ ],
+ [
+ 817936.68,
+ 7318101.03
+ ],
+ [
+ 818877.27,
+ 7318578.6
+ ],
+ [
+ 819541.38,
+ 7318795.56
+ ],
+ [
+ 821155.33,
+ 7319332.67
+ ],
+ [
+ 822880.42,
+ 7319901.52
+ ],
+ [
+ 824318.43,
+ 7320376.45
+ ],
+ [
+ 824792.03,
+ 7320537.84
+ ],
+ [
+ 826794.93,
+ 7321195.33
+ ],
+ [
+ 827310.87,
+ 7321364.67
+ ],
+ [
+ 829395.78,
+ 7323872.92
+ ],
+ [
+ 830507.03,
+ 7325206.42
+ ],
+ [
+ 830929.04,
+ 7325481.58
+ ],
+ [
+ 832077.33,
+ 7325783.21
+ ],
+ [
+ 833994.24,
+ 7325947.25
+ ],
+ [
+ 835900.56,
+ 7326106.0
+ ],
+ [
+ 838026.49,
+ 7326284.59
+ ],
+ [
+ 839435.4,
+ 7326403.66
+ ],
+ [
+ 840170.94,
+ 7326747.61
+ ],
+ [
+ 840796.68,
+ 7327079.67
+ ],
+ [
+ 841184.29,
+ 7327278.1
+ ],
+ [
+ 841775.64,
+ 7327573.11
+ ],
+ [
+ 842277.02,
+ 7327828.44
+ ],
+ [
+ 842619.66,
+ 7328226.63
+ ],
+ [
+ 843638.3,
+ 7330244.08
+ ],
+ [
+ 845228.45,
+ 7332023.41
+ ],
+ [
+ 846294.72,
+ 7333215.35
+ ],
+ [
+ 847285.58,
+ 7333446.86
+ ],
+ [
+ 848219.56,
+ 7333464.06
+ ],
+ [
+ 849287.16,
+ 7333654.56
+ ],
+ [
+ 850865.4,
+ 7333940.31
+ ],
+ [
+ 855557.78,
+ 7333879.46
+ ],
+ [
+ 856440.17,
+ 7333867.55
+ ],
+ [
+ 858126.89,
+ 7333039.41
+ ],
+ [
+ 860422.15,
+ 7332622.69
+ ],
+ [
+ 860647.04,
+ 7332584.32
+ ],
+ [
+ 861477.83,
+ 7331582.87
+ ],
+ [
+ 862029.49,
+ 7330921.42
+ ],
+ [
+ 862743.87,
+ 7330818.23
+ ],
+ [
+ 862997.87,
+ 7330822.2
+ ],
+ [
+ 863312.72,
+ 7330852.62
+ ],
+ [
+ 864597.27,
+ 7331031.22
+ ],
+ [
+ 867748.46,
+ 7330840.72
+ ],
+ [
+ 870346.67,
+ 7330685.94
+ ],
+ [
+ 871529.36,
+ 7330613.18
+ ],
+ [
+ 871549.2,
+ 7330540.42
+ ]
+ ],
+ [
+ [
+ 871627.25,
+ 7330553.65
+ ],
+ [
+ 871643.13,
+ 7330606.56
+ ],
+ [
+ 872784.8,
+ 7330537.77
+ ],
+ [
+ 874914.7,
+ 7331256.11
+ ],
+ [
+ 875232.2,
+ 7331367.24
+ ],
+ [
+ 876294.5,
+ 7331543.19
+ ],
+ [
+ 877925.66,
+ 7331814.38
+ ],
+ [
+ 878122.77,
+ 7331843.49
+ ],
+ [
+ 879288.26,
+ 7332191.42
+ ],
+ [
+ 881362.6,
+ 7332799.96
+ ],
+ [
+ 883460.74,
+ 7333423.05
+ ],
+ [
+ 885355.16,
+ 7333976.03
+ ],
+ [
+ 885971.64,
+ 7334161.24
+ ],
+ [
+ 888113.44,
+ 7334204.9
+ ],
+ [
+ 889056.68,
+ 7334038.21
+ ],
+ [
+ 890800.28,
+ 7334588.54
+ ],
+ [
+ 893225.19,
+ 7335738.16
+ ],
+ [
+ 893852.25,
+ 7336068.88
+ ],
+ [
+ 894905.29,
+ 7336627.16
+ ],
+ [
+ 896193.81,
+ 7337315.07
+ ],
+ [
+ 897082.81,
+ 7337788.68
+ ],
+ [
+ 898498.33,
+ 7338542.74
+ ],
+ [
+ 899991.91,
+ 7339337.81
+ ],
+ [
+ 900334.54,
+ 7339519.05
+ ],
+ [
+ 900494.62,
+ 7339615.62
+ ],
+ [
+ 902056.98,
+ 7340557.54
+ ],
+ [
+ 903788.68,
+ 7341602.65
+ ],
+ [
+ 905171.13,
+ 7342434.76
+ ],
+ [
+ 907155.5,
+ 7343635.97
+ ],
+ [
+ 909487.8,
+ 7344460.15
+ ],
+ [
+ 910362.25,
+ 7345091.18
+ ]
+ ]
+ ]
+ }
+ },
+ {
+ "type": "Feature",
+ "properties": {
+ "name": "Malånäset–Högnäs",
+ "voltage": 400,
+ "url": "https://www.svk.se/utveckling-av-kraftsystemet/transmissionsnatet/transmissionsnatsprojekt/malanaset-hognas/"
+ },
+ "geometry": {
+ "type": "MultiLineString",
+ "coordinates": [
+ [
+ [
+ 720662.85,
+ 7218641.46
+ ],
+ [
+ 720466.34,
+ 7218380.7
+ ],
+ [
+ 720375.64,
+ 7217995.23
+ ],
+ [
+ 720005.28,
+ 7215357.38
+ ],
+ [
+ 721698.34,
+ 7214473.06
+ ],
+ [
+ 724132.11,
+ 7213191.93
+ ],
+ [
+ 727094.97,
+ 7211623.58
+ ],
+ [
+ 728459.24,
+ 7210901.76
+ ],
+ [
+ 729566.53,
+ 7210822.4
+ ],
+ [
+ 730190.09,
+ 7210444.49
+ ],
+ [
+ 733013.12,
+ 7208774.1
+ ],
+ [
+ 736550.4,
+ 7205879.27
+ ],
+ [
+ 739721.11,
+ 7203921.67
+ ],
+ [
+ 741701.38,
+ 7203511.64
+ ],
+ [
+ 742245.58,
+ 7203300.0
+ ],
+ [
+ 744475.28,
+ 7200004.59
+ ],
+ [
+ 746281.71,
+ 7199025.79
+ ],
+ [
+ 748791.07,
+ 7197105.98
+ ],
+ [
+ 750892.28,
+ 7195594.32
+ ],
+ [
+ 751995.79,
+ 7193795.44
+ ],
+ [
+ 753628.38,
+ 7192586.11
+ ],
+ [
+ 758193.59,
+ 7191920.98
+ ]
+ ]
+ ]
+ }
+ },
+ {
+ "type": "Feature",
+ "properties": {
+ "name": "Betåsen–Nässe",
+ "voltage": 400,
+ "url": "https://www.svk.se/utveckling-av-kraftsystemet/transmissionsnatet/transmissionsnatsprojekt/betasen--nasse/"
+ },
+ "geometry": {
+ "type": "LineString",
+ "coordinates": [
+ [
+ 588903.66,
+ 7047292.75
+ ],
+ [
+ 588828.25,
+ 7047255.71
+ ],
+ [
+ 588637.75,
+ 7046234.42
+ ],
+ [
+ 587952.48,
+ 7045853.42
+ ],
+ [
+ 587978.94,
+ 7045570.31
+ ],
+ [
+ 589495.0,
+ 7042696.94
+ ],
+ [
+ 590743.83,
+ 7040384.48
+ ],
+ [
+ 591577.27,
+ 7038320.73
+ ],
+ [
+ 591577.27,
+ 7038042.92
+ ],
+ [
+ 591844.5,
+ 7037347.06
+ ],
+ [
+ 591751.9,
+ 7036651.21
+ ],
+ [
+ 592386.9,
+ 7035965.94
+ ],
+ [
+ 593688.65,
+ 7035317.71
+ ],
+ [
+ 594122.56,
+ 7034886.44
+ ],
+ [
+ 595088.29,
+ 7033608.5
+ ],
+ [
+ 595270.85,
+ 7033320.1
+ ],
+ [
+ 595887.33,
+ 7032137.42
+ ],
+ [
+ 597202.31,
+ 7029666.21
+ ],
+ [
+ 597874.35,
+ 7028359.17
+ ],
+ [
+ 598824.21,
+ 7027070.65
+ ],
+ [
+ 599123.19,
+ 7026665.83
+ ],
+ [
+ 599401.0,
+ 7025602.21
+ ],
+ [
+ 599631.19,
+ 7025043.94
+ ],
+ [
+ 599922.23,
+ 7024673.52
+ ],
+ [
+ 600218.56,
+ 7023964.44
+ ],
+ [
+ 601213.4,
+ 7021554.08
+ ],
+ [
+ 602517.79,
+ 7018453.17
+ ],
+ [
+ 604097.36,
+ 7014815.15
+ ],
+ [
+ 605356.77,
+ 7011902.08
+ ],
+ [
+ 605555.21,
+ 7011439.06
+ ],
+ [
+ 605613.42,
+ 7011171.83
+ ],
+ [
+ 606343.67,
+ 7010391.31
+ ],
+ [
+ 606600.31,
+ 7010147.9
+ ],
+ [
+ 606894.0,
+ 7009708.69
+ ],
+ [
+ 607219.44,
+ 7008412.23
+ ],
+ [
+ 606682.33,
+ 7007621.12
+ ],
+ [
+ 606333.08,
+ 7007086.67
+ ],
+ [
+ 606049.98,
+ 7007094.6
+ ]
+ ]
+ }
+ },
+ {
+ "type": "Feature",
+ "properties": {
+ "name": "Nässe–Vattjom",
+ "voltage": 400,
+ "url": "https://www.svk.se/utveckling-av-kraftsystemet/transmissionsnatet/transmissionsnatsprojekt/nasse-vattjom/"
+ },
+ "geometry": {
+ "type": "MultiLineString",
+ "coordinates": [
+ [
+ [
+ 606044.69,
+ 7006864.42
+ ],
+ [
+ 606174.33,
+ 7006864.42
+ ],
+ [
+ 606282.81,
+ 7006684.5
+ ],
+ [
+ 606169.04,
+ 7005803.44
+ ],
+ [
+ 605761.58,
+ 7004940.9
+ ],
+ [
+ 604433.38,
+ 7002170.71
+ ],
+ [
+ 604211.13,
+ 7001392.83
+ ],
+ [
+ 603615.81,
+ 6999180.92
+ ],
+ [
+ 602975.52,
+ 6996826.12
+ ],
+ [
+ 602478.11,
+ 6995008.44
+ ],
+ [
+ 602369.63,
+ 6994587.75
+ ],
+ [
+ 602383.01,
+ 6994207.18
+ ],
+ [
+ 602881.86,
+ 6993912.41
+ ],
+ [
+ 603055.7,
+ 6993579.85
+ ],
+ [
+ 604000.49,
+ 6992718.2
+ ],
+ [
+ 604756.32,
+ 6992393.19
+ ],
+ [
+ 605716.22,
+ 6991380.38
+ ],
+ [
+ 608422.09,
+ 6987695.71
+ ],
+ [
+ 610039.57,
+ 6986607.31
+ ],
+ [
+ 611052.38,
+ 6985337.52
+ ],
+ [
+ 611203.55,
+ 6983890.1
+ ],
+ [
+ 610432.6,
+ 6983784.29
+ ],
+ [
+ 607311.02,
+ 6982567.4
+ ],
+ [
+ 603970.25,
+ 6982068.55
+ ],
+ [
+ 601846.37,
+ 6981713.31
+ ],
+ [
+ 601504.44,
+ 6981083.42
+ ],
+ [
+ 600882.67,
+ 6976014.0
+ ],
+ [
+ 600469.92,
+ 6972807.25
+ ],
+ [
+ 600747.73,
+ 6970415.42
+ ],
+ [
+ 601075.81,
+ 6967597.6
+ ],
+ [
+ 601340.4,
+ 6965277.21
+ ],
+ [
+ 601099.63,
+ 6963515.08
+ ],
+ [
+ 600692.17,
+ 6960422.1
+ ],
+ [
+ 600668.36,
+ 6959620.42
+ ],
+ [
+ 600700.11,
+ 6959517.23
+ ],
+ [
+ 600692.17,
+ 6959178.56
+ ],
+ [
+ 600652.48,
+ 6959160.04
+ ],
+ [
+ 600536.06,
+ 6955162.19
+ ],
+ [
+ 600591.63,
+ 6955151.6
+ ],
+ [
+ 600549.29,
+ 6953431.81
+ ],
+ [
+ 600602.21,
+ 6953323.33
+ ],
+ [
+ 600522.83,
+ 6953278.35
+ ],
+ [
+ 600472.56,
+ 6951211.96
+ ],
+ [
+ 600583.69,
+ 6947060.65
+ ],
+ [
+ 600620.73,
+ 6945925.58
+ ],
+ [
+ 600385.25,
+ 6944258.71
+ ],
+ [
+ 600051.88,
+ 6941438.25
+ ],
+ [
+ 599636.48,
+ 6938038.35
+ ],
+ [
+ 599655.0,
+ 6937853.15
+ ],
+ [
+ 599580.92,
+ 6937625.6
+ ],
+ [
+ 599475.08,
+ 6936678.4
+ ],
+ [
+ 599615.31,
+ 6936141.29
+ ],
+ [
+ 599588.85,
+ 6936117.48
+ ]
+ ],
+ [
+ [
+ 599371.9,
+ 6935921.69
+ ],
+ [
+ 598975.02,
+ 6932789.02
+ ],
+ [
+ 599112.6,
+ 6931190.94
+ ],
+ [
+ 599107.31,
+ 6930227.85
+ ],
+ [
+ 599123.19,
+ 6928471.02
+ ],
+ [
+ 599162.88,
+ 6927420.62
+ ],
+ [
+ 599305.75,
+ 6923623.85
+ ],
+ [
+ 599350.73,
+ 6923467.75
+ ],
+ [
+ 599464.5,
+ 6920951.56
+ ],
+ [
+ 599840.21,
+ 6918795.21
+ ],
+ [
+ 600067.75,
+ 6917519.92
+ ]
+ ]
+ ]
+ }
+ },
+ {
+ "type": "Feature",
+ "properties": {
+ "name": "Ramsele–Kilforsen",
+ "voltage": 400,
+ "url": "https://www.svk.se/utveckling-av-kraftsystemet/transmissionsnatet/transmissionsnatsprojekt/ramsele-kilforsen/"
+ },
+ "geometry": {
+ "type": "LineString",
+ "coordinates": [
+ [
+ 565961.45,
+ 7051614.37
+ ],
+ [
+ 566006.8,
+ 7052067.86
+ ],
+ [
+ 566921.36,
+ 7051848.67
+ ],
+ [
+ 571222.03,
+ 7051115.52
+ ],
+ [
+ 574638.38,
+ 7050397.48
+ ],
+ [
+ 581644.93,
+ 7048980.3
+ ],
+ [
+ 582400.76,
+ 7048836.69
+ ],
+ [
+ 584622.9,
+ 7048526.8
+ ],
+ [
+ 586682.53,
+ 7047362.82
+ ],
+ [
+ 587272.08,
+ 7046841.3
+ ],
+ [
+ 587411.91,
+ 7046935.78
+ ]
+ ]
+ }
+ },
+ {
+ "type": "Feature",
+ "properties": {
+ "name": "Indalsringen Ragunda",
+ "voltage": 400,
+ "url": "https://www.svk.se/utveckling-av-kraftsystemet/transmissionsnatet/transmissionsnatsprojekt/indalsringen-ragunda/"
+ },
+ "geometry": {
+ "type": "LineString",
+ "coordinates": [
+ [
+ 554072.25,
+ 7002389.99
+ ],
+ [
+ 554136.49,
+ 7002114.11
+ ],
+ [
+ 555863.56,
+ 7001528.34
+ ],
+ [
+ 556929.28,
+ 7001271.36
+ ],
+ [
+ 557764.48,
+ 7001203.34
+ ],
+ [
+ 561250.74,
+ 7000439.95
+ ],
+ [
+ 566244.89,
+ 6999353.44
+ ],
+ [
+ 567526.02,
+ 6998986.86
+ ],
+ [
+ 567510.9,
+ 6998506.91
+ ],
+ [
+ 567699.86,
+ 6997325.93
+ ],
+ [
+ 567983.3,
+ 6996683.47
+ ],
+ [
+ 568603.08,
+ 6995264.4
+ ],
+ [
+ 568901.63,
+ 6994625.73
+ ],
+ [
+ 569294.66,
+ 6994225.14
+ ],
+ [
+ 573776.73,
+ 6991700.66
+ ],
+ [
+ 575870.38,
+ 6990166.33
+ ],
+ [
+ 579037.31,
+ 6987713.66
+ ],
+ [
+ 580435.6,
+ 6986678.17
+ ],
+ [
+ 583028.09,
+ 6985022.91
+ ],
+ [
+ 583829.27,
+ 6983911.84
+ ],
+ [
+ 584003.12,
+ 6983926.95
+ ]
+ ]
+ }
+ }
+ ]
+}
diff --git a/schema.sql b/schema.sql
index c915ddd..78429a1 100644
--- a/schema.sql
+++ b/schema.sql
@@ -2287,6 +2287,171 @@ ALTER SEQUENCE postgis."sks:UtfordAvverk_ogc_fid_seq" OWNED BY postgis."sks:Utfo
--
+-- Name: svk:ledningar; Type: TABLE; Schema: postgis; Owner: webmap_import
+--
+
+CREATE TABLE postgis."svk:ledningar" (
+ ogc_fid bigint NOT NULL,
+ "Placement" character varying(32),
+ "Voltage" integer,
+ wkb_geometry postgis.geometry(MultiLineString,3006)
+);
+
+
+ALTER TABLE postgis."svk:ledningar" OWNER TO webmap_import;
+
+--
+-- Name: TABLE "svk:ledningar"; Type: COMMENT; Schema: postgis; Owner: webmap_import
+--
+
+COMMENT ON TABLE postgis."svk:ledningar" IS 'Kraftledningar (befintliga)';
+
+
+--
+-- Name: svk:ledningar_ogc_fid_seq; Type: SEQUENCE; Schema: postgis; Owner: webmap_import
+--
+
+CREATE SEQUENCE postgis."svk:ledningar_ogc_fid_seq"
+ START WITH 1
+ INCREMENT BY 1
+ NO MINVALUE
+ NO MAXVALUE
+ CACHE 1;
+
+
+ALTER TABLE postgis."svk:ledningar_ogc_fid_seq" OWNER TO webmap_import;
+
+--
+-- Name: svk:ledningar_ogc_fid_seq; Type: SEQUENCE OWNED BY; Schema: postgis; Owner: webmap_import
+--
+
+ALTER SEQUENCE postgis."svk:ledningar_ogc_fid_seq" OWNED BY postgis."svk:ledningar".ogc_fid;
+
+
+--
+-- Name: svk:stationsomraden; Type: TABLE; Schema: postgis; Owner: webmap_import
+--
+
+CREATE TABLE postgis."svk:stationsomraden" (
+ ogc_fid bigint NOT NULL,
+ wkb_geometry postgis.geometry(MultiPolygonZ,3006)
+);
+
+
+ALTER TABLE postgis."svk:stationsomraden" OWNER TO webmap_import;
+
+--
+-- Name: TABLE "svk:stationsomraden"; Type: COMMENT; Schema: postgis; Owner: webmap_import
+--
+
+COMMENT ON TABLE postgis."svk:stationsomraden" IS 'Stationsomraden';
+
+
+--
+-- Name: svk:stationsomraden_ogc_fid_seq; Type: SEQUENCE; Schema: postgis; Owner: webmap_import
+--
+
+CREATE SEQUENCE postgis."svk:stationsomraden_ogc_fid_seq"
+ START WITH 1
+ INCREMENT BY 1
+ NO MINVALUE
+ NO MAXVALUE
+ CACHE 1;
+
+
+ALTER TABLE postgis."svk:stationsomraden_ogc_fid_seq" OWNER TO webmap_import;
+
+--
+-- Name: svk:stationsomraden_ogc_fid_seq; Type: SEQUENCE OWNED BY; Schema: postgis; Owner: webmap_import
+--
+
+ALTER SEQUENCE postgis."svk:stationsomraden_ogc_fid_seq" OWNED BY postgis."svk:stationsomraden".ogc_fid;
+
+
+--
+-- Name: svk:stolpar; Type: TABLE; Schema: postgis; Owner: webmap_import
+--
+
+CREATE TABLE postgis."svk:stolpar" (
+ ogc_fid bigint NOT NULL,
+ wkb_geometry postgis.geometry(PointZ,3006)
+);
+
+
+ALTER TABLE postgis."svk:stolpar" OWNER TO webmap_import;
+
+--
+-- Name: TABLE "svk:stolpar"; Type: COMMENT; Schema: postgis; Owner: webmap_import
+--
+
+COMMENT ON TABLE postgis."svk:stolpar" IS 'Stolpar (befintliga)';
+
+
+--
+-- Name: svk:stolpar_ogc_fid_seq; Type: SEQUENCE; Schema: postgis; Owner: webmap_import
+--
+
+CREATE SEQUENCE postgis."svk:stolpar_ogc_fid_seq"
+ START WITH 1
+ INCREMENT BY 1
+ NO MINVALUE
+ NO MAXVALUE
+ CACHE 1;
+
+
+ALTER TABLE postgis."svk:stolpar_ogc_fid_seq" OWNER TO webmap_import;
+
+--
+-- Name: svk:stolpar_ogc_fid_seq; Type: SEQUENCE OWNED BY; Schema: postgis; Owner: webmap_import
+--
+
+ALTER SEQUENCE postgis."svk:stolpar_ogc_fid_seq" OWNED BY postgis."svk:stolpar".ogc_fid;
+
+
+--
+-- Name: svk:transmissionsnatsprojekt; Type: TABLE; Schema: postgis; Owner: webmap_import
+--
+
+CREATE TABLE postgis."svk:transmissionsnatsprojekt" (
+ ogc_fid bigint NOT NULL,
+ "Name" character varying(254),
+ "Voltage" integer,
+ "Url" character varying(254),
+ wkb_geometry postgis.geometry(MultiLineString,3006)
+);
+
+
+ALTER TABLE postgis."svk:transmissionsnatsprojekt" OWNER TO webmap_import;
+
+--
+-- Name: TABLE "svk:transmissionsnatsprojekt"; Type: COMMENT; Schema: postgis; Owner: webmap_import
+--
+
+COMMENT ON TABLE postgis."svk:transmissionsnatsprojekt" IS 'Transmissionsnätsprojekt';
+
+
+--
+-- Name: svk:transmissionsnatsprojekt_ogc_fid_seq; Type: SEQUENCE; Schema: postgis; Owner: webmap_import
+--
+
+CREATE SEQUENCE postgis."svk:transmissionsnatsprojekt_ogc_fid_seq"
+ START WITH 1
+ INCREMENT BY 1
+ NO MINVALUE
+ NO MAXVALUE
+ CACHE 1;
+
+
+ALTER TABLE postgis."svk:transmissionsnatsprojekt_ogc_fid_seq" OWNER TO webmap_import;
+
+--
+-- Name: svk:transmissionsnatsprojekt_ogc_fid_seq; Type: SEQUENCE OWNED BY; Schema: postgis; Owner: webmap_import
+--
+
+ALTER SEQUENCE postgis."svk:transmissionsnatsprojekt_ogc_fid_seq" OWNED BY postgis."svk:transmissionsnatsprojekt".ogc_fid;
+
+
+--
-- Name: vbk:havsbaserad_vindkraft; Type: TABLE; Schema: postgis; Owner: webmap_import
--
@@ -2785,6 +2950,34 @@ ALTER TABLE ONLY postgis."sks:UtfordAvverk" ALTER COLUMN ogc_fid SET DEFAULT nex
--
+-- Name: svk:ledningar ogc_fid; Type: DEFAULT; Schema: postgis; Owner: webmap_import
+--
+
+ALTER TABLE ONLY postgis."svk:ledningar" ALTER COLUMN ogc_fid SET DEFAULT nextval('postgis."svk:ledningar_ogc_fid_seq"'::regclass);
+
+
+--
+-- Name: svk:stationsomraden ogc_fid; Type: DEFAULT; Schema: postgis; Owner: webmap_import
+--
+
+ALTER TABLE ONLY postgis."svk:stationsomraden" ALTER COLUMN ogc_fid SET DEFAULT nextval('postgis."svk:stationsomraden_ogc_fid_seq"'::regclass);
+
+
+--
+-- Name: svk:stolpar ogc_fid; Type: DEFAULT; Schema: postgis; Owner: webmap_import
+--
+
+ALTER TABLE ONLY postgis."svk:stolpar" ALTER COLUMN ogc_fid SET DEFAULT nextval('postgis."svk:stolpar_ogc_fid_seq"'::regclass);
+
+
+--
+-- Name: svk:transmissionsnatsprojekt ogc_fid; Type: DEFAULT; Schema: postgis; Owner: webmap_import
+--
+
+ALTER TABLE ONLY postgis."svk:transmissionsnatsprojekt" ALTER COLUMN ogc_fid SET DEFAULT nextval('postgis."svk:transmissionsnatsprojekt_ogc_fid_seq"'::regclass);
+
+
+--
-- Name: vbk:havsbaserad_vindkraft ogc_fid; Type: DEFAULT; Schema: postgis; Owner: webmap_import
--
@@ -3606,6 +3799,38 @@ ALTER TABLE ONLY postgis."sks:UtfordAvverk"
--
+-- Name: svk:ledningar svk:ledningar_pkey; Type: CONSTRAINT; Schema: postgis; Owner: webmap_import
+--
+
+ALTER TABLE ONLY postgis."svk:ledningar"
+ ADD CONSTRAINT "svk:ledningar_pkey" PRIMARY KEY (ogc_fid);
+
+
+--
+-- Name: svk:stationsomraden svk:stationsomraden_pkey; Type: CONSTRAINT; Schema: postgis; Owner: webmap_import
+--
+
+ALTER TABLE ONLY postgis."svk:stationsomraden"
+ ADD CONSTRAINT "svk:stationsomraden_pkey" PRIMARY KEY (ogc_fid);
+
+
+--
+-- Name: svk:stolpar svk:stolpar_pkey; Type: CONSTRAINT; Schema: postgis; Owner: webmap_import
+--
+
+ALTER TABLE ONLY postgis."svk:stolpar"
+ ADD CONSTRAINT "svk:stolpar_pkey" PRIMARY KEY (ogc_fid);
+
+
+--
+-- Name: svk:transmissionsnatsprojekt svk:transmissionsnatsprojekt_pkey; Type: CONSTRAINT; Schema: postgis; Owner: webmap_import
+--
+
+ALTER TABLE ONLY postgis."svk:transmissionsnatsprojekt"
+ ADD CONSTRAINT "svk:transmissionsnatsprojekt_pkey" PRIMARY KEY (ogc_fid);
+
+
+--
-- Name: vbk:havsbaserad_vindkraft vbk:havsbaserad_vindkraft_pkey; Type: CONSTRAINT; Schema: postgis; Owner: webmap_import
--
@@ -3954,6 +4179,34 @@ CREATE INDEX "sks:UtfordAvverk_wkb_geometry_geom_idx" ON postgis."sks:UtfordAvve
--
+-- Name: svk:ledningar_wkb_geometry_geom_idx; Type: INDEX; Schema: postgis; Owner: webmap_import
+--
+
+CREATE INDEX "svk:ledningar_wkb_geometry_geom_idx" ON postgis."svk:ledningar" USING gist (wkb_geometry);
+
+
+--
+-- Name: svk:stationsomraden_wkb_geometry_geom_idx; Type: INDEX; Schema: postgis; Owner: webmap_import
+--
+
+CREATE INDEX "svk:stationsomraden_wkb_geometry_geom_idx" ON postgis."svk:stationsomraden" USING gist (wkb_geometry);
+
+
+--
+-- Name: svk:stolpar_wkb_geometry_geom_idx; Type: INDEX; Schema: postgis; Owner: webmap_import
+--
+
+CREATE INDEX "svk:stolpar_wkb_geometry_geom_idx" ON postgis."svk:stolpar" USING gist (wkb_geometry);
+
+
+--
+-- Name: svk:transmissionsnatsprojekt_wkb_geometry_geom_idx; Type: INDEX; Schema: postgis; Owner: webmap_import
+--
+
+CREATE INDEX "svk:transmissionsnatsprojekt_wkb_geometry_geom_idx" ON postgis."svk:transmissionsnatsprojekt" USING gist (wkb_geometry);
+
+
+--
-- Name: vbk:havsbaserad_vindkraft_wkb_geometry_geom_idx; Type: INDEX; Schema: postgis; Owner: webmap_import
--
@@ -4628,6 +4881,62 @@ GRANT SELECT ON TABLE postgis.spatial_ref_sys TO webmap_guest;
--
+-- Name: TABLE "svk:ledningar"; Type: ACL; Schema: postgis; Owner: webmap_import
+--
+
+GRANT SELECT ON TABLE postgis."svk:ledningar" TO webmap_guest;
+
+
+--
+-- Name: SEQUENCE "svk:ledningar_ogc_fid_seq"; Type: ACL; Schema: postgis; Owner: webmap_import
+--
+
+GRANT SELECT,USAGE ON SEQUENCE postgis."svk:ledningar_ogc_fid_seq" TO webmap_guest;
+
+
+--
+-- Name: TABLE "svk:stationsomraden"; Type: ACL; Schema: postgis; Owner: webmap_import
+--
+
+GRANT SELECT ON TABLE postgis."svk:stationsomraden" TO webmap_guest;
+
+
+--
+-- Name: SEQUENCE "svk:stationsomraden_ogc_fid_seq"; Type: ACL; Schema: postgis; Owner: webmap_import
+--
+
+GRANT SELECT,USAGE ON SEQUENCE postgis."svk:stationsomraden_ogc_fid_seq" TO webmap_guest;
+
+
+--
+-- Name: TABLE "svk:stolpar"; Type: ACL; Schema: postgis; Owner: webmap_import
+--
+
+GRANT SELECT ON TABLE postgis."svk:stolpar" TO webmap_guest;
+
+
+--
+-- Name: SEQUENCE "svk:stolpar_ogc_fid_seq"; Type: ACL; Schema: postgis; Owner: webmap_import
+--
+
+GRANT SELECT,USAGE ON SEQUENCE postgis."svk:stolpar_ogc_fid_seq" TO webmap_guest;
+
+
+--
+-- Name: TABLE "svk:transmissionsnatsprojekt"; Type: ACL; Schema: postgis; Owner: webmap_import
+--
+
+GRANT SELECT ON TABLE postgis."svk:transmissionsnatsprojekt" TO webmap_guest;
+
+
+--
+-- Name: SEQUENCE "svk:transmissionsnatsprojekt_ogc_fid_seq"; Type: ACL; Schema: postgis; Owner: webmap_import
+--
+
+GRANT SELECT,USAGE ON SEQUENCE postgis."svk:transmissionsnatsprojekt_ogc_fid_seq" TO webmap_guest;
+
+
+--
-- Name: TABLE "vbk:havsbaserad_vindkraft"; Type: ACL; Schema: postgis; Owner: webmap_import
--
diff --git a/webmap-download b/webmap-download
index fc5ceee..917f178 100755
--- a/webmap-download
+++ b/webmap-download
@@ -194,7 +194,7 @@ if __name__ == '__main__':
cache = source.get('cache', None)
dest = None if cache is None else cache.get('path', None)
if dest is None:
- raise Exception('Impossible')
+ continue
dest = str(dest) # convert from Path()
if dest in downloads:
diff --git a/webmap-publish b/webmap-publish
index 1c1e9a2..f3c6c5d 100755
--- a/webmap-publish
+++ b/webmap-publish
@@ -212,7 +212,14 @@ def getSourceLayer(ds_src, layerdef, extent=None):
elif ogr.GT_IsSubClassOf(geomType, ogr.wkbCurve) or ogr.GT_IsSubClassOf(geomType, ogr.wkbMultiCurve):
columns.append('ROUND(CAST(ST_Length(m.' + geomFieldName_esc + ') * '
+ str(linearUnits) + ' AS numeric), 2) AS "GeomLength"')
- columns.append('m.' + geomFieldName_esc)
+
+ transform_geometry = layerdef.get('transform-geometry', None)
+ if transform_geometry is None:
+ columns.append('m.' + geomFieldName_esc)
+ elif transform_geometry == 'centroid':
+ columns.append('ST_Centroid(m.' + geomFieldName_esc + ') AS ' + geomFieldName_esc)
+ else:
+ raise Exception(f'Unsupported geometry transformation: {transform_geometry}')
query = 'SELECT ' + ', '.join(columns) + ' FROM ' + escapeIdentifier(lyr_src.GetName()) + ' m'