FrieseWoudloper

# https://towardsdatascience.com/sqlalchemy-python-tutorial-79a577141a91
# https://medium.com/@JasonWyatt/squeezing-performance-from-sqlite-indexes-indexes-c4e175f3c346
# https://medium.com/@JasonWyatt/squeezing-performance-from-sqlite-insertions-971aff98eef2
# https://medium.com/analytics-vidhya/programming-with-databases-in-python-using-sqlite-4cecbef51ab9

import sqlalchemy as db
import pandas as pd
# engine = db.create_engine('sqlite:///c:/Temp/Udemy/customer.db')
# connection = engine.connect()
# metadata = db.MetaData()

FrieseWoudloper

FrieseWoudloper

license: gpl-3.0
height: 400
scrolling: no
border: no

FrieseWoudloper

FrieseWoudloper

This is a TopoJSON file of municipalities in the north of The Netherlands visualized with D3.js. The TopoJSON file was created using Mapshaper.org.

FrieseWoudloper

This gist consists of the following files:

• gemeenten.json, a TopoJSON file of municipalities in the north of The Netherlands including a bounding box.
• gemeenten_without_bb.json, a TopoJSON file of municipalities in the north of the Netherlands without bounding box.
• gemeenten_qp_1000000.json, a TopoJSON file without bounding box and the quantization parameter set to 1000000.
• gemeenten_rhr.json, a TopoJSON file with bounding box and Orientator transformer in FME Desktop set to right hand rule.
• index.html, containting D3 JavaScript code to visualize the files mentioned above.

Because of the mixed winding orders of polygons, I get a rectangle when I visualize the municipalities with D3.js. The TopoJSON files were created using FME Desktop 2019.

FrieseWoudloper

license: gpl-3.0
height: 600
scrolling: no
border: no

FrieseWoudloper

In dit voorbeeld GeoJSON (EPSG:4326) opgevraagd bij WFS + reverse winding order in FME + wegschrijven naar TopoJSON

FrieseWoudloper

license: gpl-3.0
height: 400
scrolling: no
border: no

FrieseWoudloper

license: gpl-3.0
height: 400
scrolling: no
border: no