how not to enforce lowercase on spatialite

المشرف العام

Administrator
طاقم الإدارة
I use a geojson file to publish a webmap. when i need to update the data, i convert it to spatialite and add the data then again convert back to geojson.

Recently in qgis 2.8, i found that the column names were converted to lowercase. Before it was a mixture of Uppercase and lowercase and the map had a parsing mechanism. Now the map is broken and it takes a lot of coding to fix it plus the processing time also increases.

Is there a way that spatialite or any other format that

  1. preserves case of column name
  2. handles long column name (shapefiles could not handle long names)
  3. allow editing (adding, removing and changing values)
  4. offline (the data is too large for geojson.io)

أكثر...
 
أعلى