GeoWill

with
--    n as (select 'Highland' as name),
-- n as (select 'Na h-Eileanan an Iar' as name),
    n as (select 'City of London' as name),
--    n as (select 'Bristol City Council' as name),
buffered as (
	select
		n.name, oo.common_name, f.factor, st_buffer(st_simplify(largest_poly.geom, 0.01), -f.factor) as geom, largest_poly.geom as orig_geom
	from
		n, organisations_organisation oo

GeoWill

Keybase proof

I hereby claim:

• I am geowill on github.
• I am willroper (https://keybase.io/willroper) on keybase.
• I have a public key ASCXa4HJfVcw30ifHtn7jgvURYLi9OPLUZZ8oN1KdyRQDgo

To claim this, I am signing this object:

GeoWill

jq -s '.[0] + .[1]' original.json new.json > updated.json 

GeoWill

"""
Make place names be lowercase ascii only with '-' instead of ' '.
"""

from qgis.core import *
from qgis.gui import *

ascii_dict = {ord(u'ß'): u'ss', ord(u'à'): u'a', ord(u'á'): u'a', ord(u'â'): u'a', ord(u'ã'): u'a', ord(u'ä'): u'a', ord(u'å'): u'a', ord(u'æ'): u'ae', ord(u'ç'): u'c', ord(u'è'): u'e', ord(u'é'): u'e', ord(u'ê'): u'e', ord(u'ë'): u'e', ord(u'ì'): u'i', ord(u'í'): u'i', ord(u'î'): u'i', ord(u'ï'): u'i', ord(u'ð'): u'd', ord(u'ñ'): u'n', ord(u'ò'): u'o', ord(u'ó'): u'o', ord(u'ô'): u'o', ord(u'õ'): u'o', ord(u'ö'): u'o', ord(u'÷'): u'/', ord(u'ø'): u'o', ord(u'ù'): u'u', ord(u'ú'): u'u', ord(u'û'): u'u', ord(u'ü'): u'u', ord(u'ý'): u'y', ord(u'þ'): u'p', ord(u'ÿ'): u'y', ord(u'’'):u"'"}

@qgsfunction(args='auto', group='Custom')

GeoWill

#!/bin/bash

# To call the script open the terminal in the same folder as the script
# Ensure it is executable: $ chmod u+x merge-reproject.sh
# Call it with $ ./merge-distrito-local-reproject.sh

# SET TO PATH WHERE YOU WANT THE SHP TO BE CREATED
FILE='/enter/path/here/DISTRITO_LOCAL-wgs1984.shp' # name of file to be merged to

GeoWill

#!/bin/bash
# To call the script open the terminal in the same folder as the script
# Ensure it is executable: $ chmod u+x merge-reproject.sh
# Call it with the layer you wish to combine: eg. $ merge-reproject.sh ENTIDAD
# LAYERS are 'SECCION' 'ENTIDAD' and 'DISTRITO'

LYR=$1


#SET TO PATH WHERE YOU WANT THE SHP TO BE CREATED

GeoWill

county,town
雲林縣,麥寮鄉
彰化縣,員林市
連江縣,南竿鄉
連江縣,北竿鄉
連江縣,莒光鄉
連江縣,東引鄉
金門縣,金城鎮
金門縣,金沙鎮
金門縣,金湖鎮

GeoWill

VILLCODE,COUNTYNAME,TOWNNAME,VILLNAME,VILLENG,COUNTYID,COUNTYCODE,TOWNID,TOWNCODE,NOTE
10013030S01,屏東縣,東港鎮,,,T,10013,T03,10013030,未編定村里
64000130006,高雄市,林園區,中門里,Zhongmen Vil.,E,64000,E13,64000130,
10018010054,新竹市,東區,關新里,Guanxin  Vil.,O,10018,O01,10018010,
64000130008,高雄市,林園區,港埔里,Gangpu Vil.,E,64000,E13,64000130,
64000100010,高雄市,旗津區,上竹里,Shangzhu Vil.,E,64000,E10,64000100,
64000100013,高雄市,旗津區,中興里,Zhongxing Vil.,E,64000,E10,64000100,
09007010006,連江縣,南竿鄉,津沙村,Jinsha Vil.,Z,09007,Z01,09007010,
09007010007,連江縣,南竿鄉,馬祖村,Mazu Vil.,Z,09007,Z01,09007010,
09007010009,連江縣,南竿鄉,四維村,Siwei Vil.,Z,09007,Z01,09007010,

GeoWill

VILLCODE,COUNTYNAME,TOWNNAME,VILLNAME,VILLENG,COUNTYID,COUNTYCODE,TOWNID,TOWNCODE,NOTE
10013030S01,屏東縣,東港鎮,,,T,10013,T03,10013030,未編定村里
64000130006,高雄市,林園區,中門里,Zhongmen Vil.,E,64000,E13,64000130,
10018010054,新竹市,東區,關新里,Guanxin  Vil.,O,10018,O01,10018010,
64000130008,高雄市,林園區,港埔里,Gangpu Vil.,E,64000,E13,64000130,
64000100010,高雄市,旗津區,上竹里,Shangzhu Vil.,E,64000,E10,64000100,
64000100013,高雄市,旗津區,中興里,Zhongxing Vil.,E,64000,E10,64000100,
09007010006,連江縣,南竿鄉,津沙村,Jinsha Vil.,Z,09007,Z01,09007010,
09007010007,連江縣,南竿鄉,馬祖村,Mazu Vil.,Z,09007,Z01,09007010,
09007010009,連江縣,南竿鄉,四維村,Siwei Vil.,Z,09007,Z01,09007010,

GeoWill