kuwapa

<?xml version="1.0" encoding="utf-8"?>
<RelativeLayout xmlns:android="http://schemas.android.com/apk/res/android"
    android:layout_width="match_parent"
    android:layout_height="wrap_content"
    android:background="@android:color/transparent"
    android:gravity="center"
    android:orientation="vertical">

    <RelativeLayout
        android:layout_width="match_parent"

kuwapa

{
  "version": 8,
  "name": "Bright",
  "metadata": {
    "mapbox:autocomposite": false,
    "mapbox:groups": {
      "1444849242106.713": {
        "collapsed": false,
        "name": "Places"
      },

kuwapa

"sources": {
    "openmaptiles": {
      "type": "vector",
      "url": "mbtiles:///data/user/0/com.example.maplibretest/cache/india_coimbatore.mbtiles"
    }
  }

kuwapa

//Fetching the local styles JSON file from the assets 
val styleJsonInputStream = assets.open("bright.json")

//Creating a new file to which to copy the json content to
val dir = File(filesDir.absolutePath)
val styleFile = File(dir, "bright.json")
//Copying the original JSON content to new file
copyStreamToFile(styleJsonInputStream, styleFile)

//Getting reference to mbtiles file in assets

kuwapa

kuwapa

fun MapboxMap.limitViewToBounds(bounds: LatLngBounds) {

    val newBoundsHeight = bounds.latitudeSpan - projection.visibleRegion.latLngBounds.latitudeSpan
    val newBoundsWidth = bounds.longitudeSpan - projection.visibleRegion.latLngBounds.longitudeSpan

    val leftTopLatLng = LatLng(
        bounds.latNorth - (bounds.latitudeSpan - newBoundsHeight) / 2,
        bounds.lonEast - (bounds.longitudeSpan - newBoundsWidth) / 2 - newBoundsWidth,
    )

kuwapa

map.animateCamera(CameraUpdateFactory.newLatLngBounds(bounds, 0),
    object : MapboxMap.CancelableCallback {
        override fun onCancel() {}

        override fun onFinish() {
            map.setMinZoomPreference(map.cameraPosition.zoom)

            map.limitViewToBounds(bounds)

            map.addOnScaleListener(object : MapboxMap.OnScaleListener {

kuwapa

-- This statement gets the date of 2 days back. Did this becasue if the script is running on 25th,
-- I'm not sure if the data for 24th is ready or not. It depends on what timezone the analytics server
-- is running off of and when do they consider 24th to be over. So 2 days period is safe

DECLARE backup_date DATE DEFAULT DATE_SUB(CURRENT_DATE(), INTERVAL 2 day);
DECLARE date_str STRING;
DECLARE table_name STRING;
DECLARE sql STRING;
DECLARE date_str_folder STRING;
DECLARE date_str_table STRING;

kuwapa

import math
def deg2num(lat_deg, lon_deg, zoom):
  lat_rad = math.radians(lat_deg)
  n = 2.0 ** zoom
  xtile = int((lon_deg + 180.0) / 360.0 * n)
  ytile = int((1.0 - math.asinh(math.tan(lat_rad)) / math.pi) / 2.0 * n)
  return (xtile, ytile)

kuwapa

def getTotalTileCount(leftBottom, rightTop, fromZoom, toZoom):
    totalTileCount = 0
    for zoom in range(fromZoom, toZoom + 1):
        leftBottomTiles = deg2num(leftBottom, zoom)
        rightTopTiles = deg2num(rightTop, zoom)

        currentTileCount = (rightTopTiles[0] - leftBottomTiles[0] + 1) * (leftBottomTiles[1] - rightTopTiles[1] + 1)
        print("zoom = " + str(zoom) + ", leftBottomTiles = " + str(leftBottomTiles) +
              ", rightTopTiles = " + str(rightTopTiles) + ", tileCount = " + str(currentTileCount))