search

dancingsushii / geo-specific-diffpriv

Plugin for PostgersSQL achieving data minimisation with a help of differential privacy on geospatial databases.
MIT License
0 stars 0 forks source link

DP: Investigate and start building code for Geo DP to use in our proxy #11

Open mariidpm opened 2 years ago

mariidpm commented 2 years ago

@ingastrelnikova assigning to you, as you already started to investigate. (I can help if needed)

mariidpm commented 2 years ago

Pending: Clean script Generate new points (noise) for all polygons/cells.. right now we're only doing 1 cell Add command to send file to vm: either scp or copy-files User queries request? -> we filter the dataset (per date or county/state) and then we do DP with our implementation and then with the new table generated and then we can do the spatial functions..

mariidpm commented 2 years ago

scp command to send file to vm: gcloud compute scp test-vm.txt vm-postgis-03:~ where test-vm.txt is the local path/file.. This assumes the project is already set to ours, we can create a quick script for it, if needed, it should do: gcloud config set project peng-geodp gcloud config set compute/region europe-west3 gcloud config set compute/zone europe-west3-c