XML Dataset to SQL
Budget: €18 – €36 EUR
Hello. We are looking for a freelancer that can convert a Dutch Open Data XML dataset, called: 'BAG Kadaster' files to an SQL database. In the final SQL database we need the following columns (at least):
,[BAGId]
,[Type]
,[Purpose]
,[Year]
,[Street]
,[Number]
,[Letter]
,[Addition]
,[Postcode]
,[Surface]
,[Nen5825_street]
,[Nen5825_postcode]
,[City_id]
,[City_label]
,[Municipality_id]
,[Municipality_label]
,[Province_id]
,[Province_label]
,[Centerpoint_lat]
,[Centerpoint_lng]
The files of the BAG can be downloaded at*:
https://extracten.bag.kadaster.nl/lvbag/extracten/
https://www.kadaster.nl/zakelijk/producten/adressen-en-gebouwen/bag-extract
* To test you can access the "Gemeente LVC" for smaller files. All the files are XML files and are related in some way.
We need the end script to update our SQL database once a month. We can do this on our own if we can get the final script/program.
We have found a article that gives more information about the dataset: https://pixcels.nl/bag-postcodetabel/
Could you let me know if you can do this and if so, what are the estimate costs?
Greetings,
Joey
,[BAGId]
,[Type]
,[Purpose]
,[Year]
,[Street]
,[Number]
,[Letter]
,[Addition]
,[Postcode]
,[Surface]
,[Nen5825_street]
,[Nen5825_postcode]
,[City_id]
,[City_label]
,[Municipality_id]
,[Municipality_label]
,[Province_id]
,[Province_label]
,[Centerpoint_lat]
,[Centerpoint_lng]
The files of the BAG can be downloaded at*:
https://extracten.bag.kadaster.nl/lvbag/extracten/
https://www.kadaster.nl/zakelijk/producten/adressen-en-gebouwen/bag-extract
* To test you can access the "Gemeente LVC" for smaller files. All the files are XML files and are related in some way.
We need the end script to update our SQL database once a month. We can do this on our own if we can get the final script/program.
We have found a article that gives more information about the dataset: https://pixcels.nl/bag-postcodetabel/
Could you let me know if you can do this and if so, what are the estimate costs?
Greetings,
Joey