From 4f56801e9737e1f9201ea5e2d1f23f759d65d437 Mon Sep 17 00:00:00 2001 From: Guilhem Moulin Date: Sat, 19 Oct 2024 17:08:33 +0200 Subject: =?UTF-8?q?Add=20layers=20from=20Svenska=20Kraftn=C3=A4t=20(SvK).?= MIME-Version: 1.0 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: 8bit --- config.yml | 100 ++ layers/.gitignore | 3 + layers/custom/svk/transmissionsnatsprojekt.geojson | 1797 ++++++++++++++++++++ schema.sql | 309 ++++ webmap-download | 2 +- webmap-publish | 9 +- 6 files changed, 2218 insertions(+), 2 deletions(-) create mode 100644 layers/.gitignore create mode 100644 layers/custom/svk/transmissionsnatsprojekt.geojson 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 @@ -2286,6 +2286,171 @@ ALTER TABLE postgis."sks:UtfordAvverk_ogc_fid_seq" OWNER TO webmap_import; ALTER SEQUENCE postgis."sks:UtfordAvverk_ogc_fid_seq" OWNED BY postgis."sks:UtfordAvverk".ogc_fid; +-- +-- 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 -- @@ -2784,6 +2949,34 @@ ALTER TABLE ONLY postgis."sks:AvverkAnm" ALTER COLUMN ogc_fid SET DEFAULT nextva ALTER TABLE ONLY postgis."sks:UtfordAvverk" ALTER COLUMN ogc_fid SET DEFAULT nextval('postgis."sks:UtfordAvverk_ogc_fid_seq"'::regclass); +-- +-- 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 -- @@ -3605,6 +3798,38 @@ ALTER TABLE ONLY postgis."sks:UtfordAvverk" ADD CONSTRAINT "sks:UtfordAvverk_pkey" PRIMARY KEY (ogc_fid); +-- +-- 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 -- @@ -3953,6 +4178,34 @@ CREATE INDEX "sks:AvverkAnm_wkb_geometry_geom_idx" ON postgis."sks:AvverkAnm" US CREATE INDEX "sks:UtfordAvverk_wkb_geometry_geom_idx" ON postgis."sks:UtfordAvverk" USING gist (wkb_geometry); +-- +-- 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 -- @@ -4627,6 +4880,62 @@ GRANT SELECT,USAGE ON SEQUENCE postgis."sks:UtfordAvverk_ogc_fid_seq" TO webmap_ 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' -- cgit v1.2.3