ThinkGeo.com    |     Documentation    |     Premium Support

New OSM SQLite tables

#1

Hi,



I’ve downloaded a new World OSM SQLite database (WorldMapKit-3857-20150919-1108924155) and see seven(?) new tables like osm_boundary_country_state_county_linestring, osm_road_streets_linestring, osm_place_city_town_point, etc.

Do you have a new OsmWorldMapKitLayer code which includes layers for the new tables?



Are there any changes in other OSM SQLite database tables structure and layers?



Thanks,

Gene



#2

Hi Gene,



You are right we did a structure changes on database to make the performance better  as you noticed. For the corresponding layer changes, please try the development dlls as we only applied the changes on development branch rather than production.



Please let us know if the development dlls works for the latest database.



Thanks,



Troy

#3

Hi Troy,



Thank you for your reply.



Yes, I see differences in the latest OsmWorldMapKitLayer dll and I can review new layers list by zoom in the OsmWorldMapKitExplorer tool.

We have our customized version of the OsmWorldMapKitLayer  code and dll which we would like to migrate to the latest OSM data and layers settings.

The WMK SDK v 9.0.77.0 download includes an old version of the OsmWorldMapKitLayer project. 



When can I get the latest version of the OsmWorldMapKitLayer code?



Thanks,

Gene










#4

Hi Gene, 



Today our version is 9.0.98.0. 



I think you should want to get a newer version. 



It looks the version in product center hadn’t been updated to the latest one, I will let our release manager knows that and it should be get refresh.



Regards, 



Don

#5

Hi Don, 
  
 The Daily Full Development 9.0.98.0 version still includes an old version of the World Map Kit Layer Source Code. The following is the list of OSM Layers. Please let me know when the new version of the World Map Kit Layer Source Code is available. 
  
 layers.Add("ne_baseland30m_polygon", GetBaseLand30mPolygonLayer()); 
             layers.Add("ne_state5m_polygon", GetStateLabelLayer()); 
             layers.Add("ne_ocean1m_polygon", GetOceanLabelLayer()); 
             layers.Add("ne_place2m_point", GetPlace2mLabelLayer()); 
             layers.Add("osm_place_point", GetPlaceLabelLayer()); 
             layers.Add("osm_baseland1m_polygon", GetBaseLand1mPolygonLayer()); 
             layers.Add("osm_baseland_polygon", GetBaseLandPolygonLayer()); 
             layers.Add("osm_land300k_polygon", GetLand300kPolygonLayer()); 
             layers.Add("osm_land100k_polygon", GetLand100kPolygonLayer()); 
             layers.Add("osm_land_polygon", GetLandPolygonLayer()); 
             layers.Add("ne_water10m_polygon", GetWater10mPolygonLayer()); 
             layers.Add("osm_water1m_polygon", GetWater1mPolygonLayer()); 
             layers.Add("osm_water_polygon", GetWaterPolygonLayer()); 
             layers.Add("osm_water100k_linestring", GetWater100kLinestringLayer()); 
             layers.Add("osm_water_linestring", GetWaterLinestringLayer()); 
             layers.Add("osm_transport_polygon", GetTransportPolygonLayer()); 
             layers.Add("osm_transport_linestring", GetTransportLinestringLayer()); 
             layers.Add("ne_road10m_linestring", GetRoad10mLinestringLayer()); 
             layers.Add("osm_road5m_linestring", GetRoad5mLinestringLayer()); 
             layers.Add("osm_road300k_linestring", GetRoad300kLinestringLayer()); 
             layers.Add("osm_road_linestring", GetRoadLinestringLayer()); 
             layers.Add("osm_poi_point", GetPoiPointLayer()); 
             layers.Add("osm_contruct_polygon", GetConstructPolygonLayer()); 
             layers.Add("osm_construct_linestring", GetConstructLinestringLayer()); 
             layers.Add("osm_construct_point", GetConstructPointLayer()); 
             layers.Add("ne_state2m_linestring", GetState2mLinestringLayer()); 
             layers.Add("ne_country10m_linestring", GetCountry10mLinestringLayer()); 
             layers.Add("osm_boundary_linestring", GetBoundaryLinestringLayer()); 
  
 Thanks, 
 Gene

#6

Hi Gene,



I think the 98 should based on the latest code because it uploaded by our release manager before he leave for vacation.



But I found the latest render code should like as below:



layers.Add(“ne_baseland30m_polygon”, GetBaseLand30mPolygonLayer());
            layers.Add(“ne_state5m_polygon”, GetStateLabelLayer());
            layers.Add(“ne_ocean1m_polygon”, GetOceanLabelLayer());
            layers.Add(“ne_place2m_point”, GetPlace2mLabelLayer());
            layers.Add(“osm_place_city_point”, GetPlaceCityLabelLayer());
            layers.Add(“osm_place_city_town_point”, GetPlaceCityTownLabelLayer());
            layers.Add(“osm_place_point”, GetPlaceLabelLayer());
            layers.Add(“osm_baseland1m_polygon”, GetBaseLand1mPolygonLayer());
            layers.Add(“osm_baseland_polygon”, GetBaseLandPolygonLayer());
            layers.Add(“osm_land300k_polygon”, GetLand300kPolygonLayer());
            layers.Add(“osm_land100k_polygon”, GetLand100kPolygonLayer());
            layers.Add(“osm_land_polygon”, GetLandPolygonLayer());
            layers.Add(“ne_water10m_polygon”, GetWater10mPolygonLayer());
            layers.Add(“osm_water1m_polygon”, GetWater1mPolygonLayer());
            layers.Add(“osm_water_large_polygon”, GetWaterLargePolygonLayer());
            layers.Add(“osm_water_polygon”, GetWaterPolygonLayer());
            layers.Add(“osm_water100k_linestring”, GetWater100kLinestringLayer());
            layers.Add(“osm_water_linestring”, GetWaterLinestringLayer());
            layers.Add(“osm_transport_polygon”, GetTransportPolygonLayer());
            layers.Add(“osm_transport_linestring”, GetTransportLinestringLayer());
            layers.Add(“ne_road20m_linestring”, GetRoad20mLinestringLayer());
            layers.Add(“ne_road10m_linestring”, GetRoad10mLinestringLayer());
            layers.Add(“osm_road5m_linestring”, GetRoad5mLinestringLayer());
            layers.Add(“osm_road3m_linestring”, GetRoad3mLinestringLayer());
            layers.Add(“osm_road300k_linestring”, GetRoad300kLinestringLayer());
            layers.Add(“osm_road_streets_linestring”, GetStreetRoadLinestringLayer());
            layers.Add(“osm_road_linestring”, GetRoadLinestringLayer());
            layers.Add(“osm_poi_point”, GetPoiPointLayer());
            layers.Add(“osm_contruct_large_polygon”, GetLargeConstructPolygonLayer());
            layers.Add(“osm_contruct_polygon”, GetConstructPolygonLayer());
            layers.Add(“osm_construct_linestring”, GetConstructLinestringLayer());
            layers.Add(“osm_construct_point”, GetConstructPointLayer());
            layers.Add(“ne_state2m_linestring”, GetState2mLinestringLayer());
            layers.Add(“ne_country10m_linestring”, GetCountry10mLinestringLayer());
            layers.Add(“osm_boundary_country_state_linestring”, GetCountryStateBoundaryLinestringLayer());
            layers.Add(“osm_boundary_country_state_county_linestring”, GetCountryStateCountyBoundaryLinestringLayer());
            layers.Add(“osm_boundary_linestring”, GetBoundaryLinestringLayer());



I am sorry I cannot help you get another build before release manager return, but please see attached text file which should contains the functions which are not included in your version.



Regards,



Don

MoreCode.txt (6.77 KB)

#7

The …\ThinkGeo\Map Suite 9.0\Map Suite World Map Kit SDK<strong>Daily Full Development 9.0.107.0\World Map Kit Layer Source Code\OsmWorldMapKitLayer<strong>OsmWorldMapKitLayer.cs code still has an old version:



 protected override void OpenCore()
        {
            layers.Add("ne_baseland30m_polygon", GetBaseLand30mPolygonLayer());
            layers.Add("ne_state5m_polygon", GetStateLabelLayer());
            layers.Add("ne_ocean1m_polygon", GetOceanLabelLayer());
            layers.Add("ne_place2m_point", GetPlace2mLabelLayer());
            layers.Add("osm_place_point", GetPlaceLabelLayer());
            layers.Add("osm_baseland1m_polygon", GetBaseLand1mPolygonLayer());
            layers.Add("osm_baseland_polygon", GetBaseLandPolygonLayer());
            layers.Add("osm_land300k_polygon", GetLand300kPolygonLayer());
            layers.Add("osm_land100k_polygon", GetLand100kPolygonLayer());
            layers.Add("osm_land_polygon", GetLandPolygonLayer());
            layers.Add("ne_water10m_polygon", GetWater10mPolygonLayer());
            layers.Add("osm_water1m_polygon", GetWater1mPolygonLayer());
            layers.Add("osm_water_polygon", GetWaterPolygonLayer());
            layers.Add("osm_water100k_linestring", GetWater100kLinestringLayer());
            layers.Add("osm_water_linestring", GetWaterLinestringLayer());
            layers.Add("osm_transport_polygon", GetTransportPolygonLayer());
            layers.Add("osm_transport_linestring", GetTransportLinestringLayer());
            layers.Add("ne_road10m_linestring", GetRoad10mLinestringLayer());
            layers.Add("osm_road5m_linestring", GetRoad5mLinestringLayer());
            layers.Add("osm_road300k_linestring", GetRoad300kLinestringLayer());
            layers.Add("osm_road_linestring", GetRoadLinestringLayer());
            layers.Add("osm_poi_point", GetPoiPointLayer());
            layers.Add("osm_contruct_polygon", GetConstructPolygonLayer());
            layers.Add("osm_construct_linestring", GetConstructLinestringLayer());
            layers.Add("osm_construct_point", GetConstructPointLayer());
            layers.Add("ne_state2m_linestring", GetState2mLinestringLayer());
            layers.Add("ne_country10m_linestring", GetCountry10mLinestringLayer());
            layers.Add("osm_boundary_linestring", GetBoundaryLinestringLayer());



Could you please release the latest version of the OsmWorldMapKitLayer project code?



Thanks,

Gene

#8

and the Daily Full Development 9.0.111.0 still includes the old version.

#9

Hi Gene, 
  
 Our release manager had handled this problem, please wait the latest version. 
  
 Regards, 
  
 Don