com.nutiteq.db

Class MBTilesDbHelper

java.lang.Object

com.nutiteq.db.MBTilesDbHelper

public class MBTilesDbHelper
extends Object

Universal helper for SQLite tile database.

Author:

jaak

Field Summary

Fields

Modifier and Type	Field and Description
android.database.sqlite.SQLiteDatabase	database

Constructor Summary

Constructors

Constructor and Description
MBTilesDbHelper(android.content.Context ctx, String databaseName) Construct database helper with own tile table format.

Method Summary

Methods

Modifier and Type	Method and Description
void	close()
boolean	containsKey(int z, int x, int y, String table)
byte[]	getGrid(int zoom, int x, int y)
HashMap<String,String>	getMetadata()
android.database.Cursor	getTables()
byte[]	getTileImg(int z, int x, int y)
Map<String,String>	getUtfGridTooltips(com.nutiteq.components.MapTile clickedTile, com.nutiteq.components.MutableMapPos tilePos) Query UTFGrid tooltip values from database for given hover/clicked location
int[]	getZoomRange()
void	open()
int[]	tileBounds(int zoom)

Methods inherited from class java.lang.Object

clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

Field Detail

database

public android.database.sqlite.SQLiteDatabase database

Constructor Detail

MBTilesDbHelper

public MBTilesDbHelper(android.content.Context ctx,
               String databaseName)

Construct database helper with own tile table format.

Parameters:

ctx - Android application context

databaseName - Database file path

tileTable - Tile table name, e.g. "tiles"

keyZoom - column name for zoom

keyX - table column name for x/column

keyY - table column name for y/row

keyData - column for binary data (blob)

tableWhere - where SQL clause for tile row search, as prepared statement e.g. "zoom_level = ? and tile_column = ? and tile_row = ?"

tableWhere2 -

keyGridJson -

keyGridName -

keyGrid -

keyTileData -

Method Detail

open

public void open()

close

public void close()

containsKey

public boolean containsKey(int z,
                  int x,
                  int y,
                  String table)

getTileImg

public byte[] getTileImg(int z,
                int x,
                int y)

getGrid

public byte[] getGrid(int zoom,
             int x,
             int y)

getZoomRange

public int[] getZoomRange()

tileBounds

public int[] tileBounds(int zoom)

getTables

public android.database.Cursor getTables()

getMetadata

public HashMap<String,String> getMetadata()

getUtfGridTooltips

public Map<String,String> getUtfGridTooltips(com.nutiteq.components.MapTile clickedTile,
                                    com.nutiteq.components.MutableMapPos tilePos)

Query UTFGrid tooltip values from database for given hover/clicked location

Parameters:

p - position on map, in EPSG3857

zoom - current map zoom

Returns:

KV map with data from JSON. If template is given then templated_teaser and templated_full values are added with HTML