o Nrf@sfddlZddlZddlZddlZddlZddZddZddZdd Z d d Z d d Z dddZ dS)NcCs4t|||\}}t||d|d\}}||||fS)zbconvert Google-style Mercator tile coordinate to (minlat, maxlat, minlng, maxlng) bounding box)get_lng_lat_from_tile_pos)zoomxyZminlngZminlatZmaxlngZmaxlatrZ/var/www/html/software/conda/envs/catlas/lib/python3.10/site-packages/clodius/tiles/geo.py get_tile_boxs r cCsNtjdtj|d|}t|}|dtj}dd|d|}||fS)zZconvert Google-style Mercator tile coordinate to (lng, lat) of top-left corner of tilef@gfv@)mathpi gudermannian)rrrlat_radlatlngrrrrs rcCsN|tjd}t|}d||dd}d|tj|dtj}||fS)z[convert lng/lat to Google-style Mercator tile coordinate (x, y) at the given zoom levelr r r )r rinv_gudermannian)rrrrrrrrrget_tile_pos_from_lng_lat"s rcCsdtt|tjdSNr )r atanexpr)rrrrr0rcCstt|tjddSr)r logtanr)rrrrr4rrc Csvtj|s ddiSt|}|d}|d|d|d|d|dg|d |d g|dd|dd }|S) NerrorzTileset info is not available!zSELECT * FROM tileset_inforrr )Z zoom_stepZ tile_sizeZmax_zoomZmin_posZmax_posZmax_data_length)ospathisfilesqlite3connectexecuteZfetchone)filepathdbresorrr tileset_info8s   r*rcCs2t|}|}t|||\}} } } t|||d||d\} } } } d} || ||| | | f}tt}t |||D]}t |||D]}g|||f<qIq@|D]}z |d d}Wn t ym|d}Ynwz |d d}Wn t y|d}Ynwt |d|d|\}}t |d|d|\}}z t |d }Wn tyd }Ynwz t |d }Wn tyd }Ynwt |||D]C}t |||D]9}||dkr||kr||dkr||kr|||f|d|d|d|d|d ||||d g7<qqqU||S)a Retrieve a contiguous set of tiles from a 2D db tile file. Parameters ---------- db_file: str The filename of the sqlite db file zoom: int The zoom level x: int The x position of the first tile y: int The y position of the first tile width: int The width of the block of tiles to retrieve height: int The height of the block of tiles to retrieve Returns ------- tiles: {pos: tile_value} A set of tiles, indexed by position raO SELECT minLng, maxLng, maxLat, minLat, uid, importance, geometry, properties, intervals.id FROM intervals, position_index WHERE intervals.id=position_index.id AND zoomLevel <= ? AND rMaxLng >= ? AND rMinLng <= ? AND rMinLat <= ? AND rMaxLat >= ? rzutf-8rr rrNr) ZxStartZxEndZyStartZyEndZ importanceuidgeometry propertiesid)r#r$cursorr r%Zfetchallcol defaultdictlistrangedecodeAttributeErrorrjsonloads Exceptionclose)Zdb_filerrrwidthheightconncZlng_from_Zlat_fromZlng_toZlat_toqueryrowsZnew_rowsijrr-r0Zx_startZy_startZx_endZy_endr.r/rrr get_tilesLsp $       0 rF)rr) r8r r r# collectionsr2r rrrrr*rFrrrrs