Razvan
Razvan
What are all the values that can be exported so I can think to a scheme
why do you need array? you can save fields from array like values in a table with same structure like array
ok, tomorrow I will send how I think is ok schema for sqlite
What you say about this structure? # POI - id - openstreetmap id - name - countrycode - iso3166-2 country code (2 letters) - alternatenames - location - middle location...
alternatenames - will be a string text or varchar, here depends on how long are alternatenames, and is the name in other language separated by coma I think HEXEWKB is...
Or maybe you have a better idea for storing shapes
why to store them in json format? if you store like that then will need to parse json and get values, another operation that is not needed. simple text just...
ok, then store them like json if is easy for you
I don't know chinese :)
Thanks, also maybe is a good idea to set type of inputs according with data type for these data types: number, email, phone or url. Is there a way to...