import { GeoPackageManager } from 'geopackage-ts';

// Open a GeoPackage file
const gp = GeoPackageManager.open('countries.gpkg');

// List tables
console.log('Feature tables:', gp.getFeatureTables());
console.log('Tile tables:', gp.getTileTables());

// Query features as GeoJSON
for (const feature of gp.queryForGeoJSONFeatures('countries')) {
  console.log(feature.properties.name, feature.geometry.type);
}

gp.close();

import { GeoPackageManager, GeoPackageDataType, buildGeometryData, writeGeometryData } from 'geopackage-ts';
import type { Point, UserColumn } from 'geopackage-ts';

const gp = GeoPackageManager.create('cities.gpkg');

// Define additional columns
const columns: UserColumn[] = [
  {
    index: 2, name: 'name', dataType: GeoPackageDataType.TEXT,
    notNull: false, defaultValue: null, primaryKey: false,
    autoincrement: false, unique: false,
  },
  {
    index: 3, name: 'population', dataType: GeoPackageDataType.INTEGER,
    notNull: false, defaultValue: null, primaryKey: false,
    autoincrement: false, unique: false,
  },
];

// Create a feature table with EPSG:4326
gp.createFeatureTable('cities', 'geom', 'POINT', 4326, columns);

// Insert a feature
const dao = gp.getFeatureDao('cities');
const point: Point = { type: 'Point', hasZ: false, hasM: false, coordinates: [13.405, 52.52] };
const geomBuffer = writeGeometryData(buildGeometryData(point, 4326));

dao.insert({
  table: dao.getTable(),
  values: { geom: geomBuffer, name: 'Berlin', population: 3645000 },
});

// Create a spatial index for fast bounding box queries
gp.indexFeatureTable('cities');

gp.close();

const gp = GeoPackageManager.open('cities.gpkg');
const dao = gp.getFeatureDao('cities');

// Query features within a bounding box (uses R-tree if available)
for (const row of dao.queryWithBoundingBox({ minX: 5, maxX: 15, minY: 47, maxY: 55 })) {
  console.log(row.name);
}

// Or get GeoJSON directly
for (const feature of dao.queryForGeoJSONWithBoundingBox({ minX: 5, maxX: 15, minY: 47, maxY: 55 })) {
  console.log(feature.properties, feature.geometry);
}

gp.close();

const gp = GeoPackageManager.create('map.gpkg');

// Create a tile table
gp.createTileTable('world', 3857, {
  minX: -20037508.34, minY: -20037508.34,
  maxX: 20037508.34, maxY: 20037508.34,
});

// Insert tiles
const dao = gp.getTileDao('world');
const pngData = fs.readFileSync('tile_0_0_0.png');
dao.insert({ zoom_level: 0, tile_column: 0, tile_row: 0, tile_data: pngData });

// Query tiles
const tile = dao.queryForTile(0, 0, 0);
if (tile) {
  fs.writeFileSync('output.png', tile.tile_data);
}

// Get available zoom levels
console.log('Zoom levels:', dao.getZoomLevels());

gp.close();

const gp = GeoPackageManager.create('data.gpkg');

const cols: UserColumn[] = [
  { index: 1, name: 'key', dataType: GeoPackageDataType.TEXT, notNull: true, defaultValue: null, primaryKey: false, autoincrement: false, unique: false },
  { index: 2, name: 'value', dataType: GeoPackageDataType.TEXT, notNull: false, defaultValue: null, primaryKey: false, autoincrement: false, unique: false },
];

gp.createAttributeTable('config', cols);
const dao = gp.getAttributeDao('config');

dao.insert({ table: dao.getTable(), values: { key: 'version', value: '1.0' } });

for (const row of dao.queryForAll()) {
  console.log(row);
}

gp.close();

import { readWKB, writeWKB, readWKT, writeWKT, fromGeoJSON, toGeoJSON, ByteOrder } from 'geopackage-ts';

// WKB round-trip
const point = { type: 'Point' as const, hasZ: false, hasM: false, coordinates: [1.5, 2.5] };
const wkb = writeWKB(point, ByteOrder.LITTLE_ENDIAN);
const parsed = readWKB(wkb); // { type: 'Point', coordinates: [1.5, 2.5], ... }

// WKT round-trip
const geom = readWKT('POLYGON ((0 0, 10 0, 10 10, 0 10, 0 0))');
const wkt = writeWKT(geom); // 'POLYGON ((0 0, 10 0, 10 10, 0 10, 0 0))'

// GeoJSON conversion
const gjson = toGeoJSON(geom);       // standard GeoJSON geometry object
const back = fromGeoJSON(gjson);      // internal Geometry type

// GeoPackage Binary (GP header + envelope + WKB)
import { buildGeometryData, writeGeometryData, readGeometryData } from 'geopackage-ts';
const gd = buildGeometryData(geom, 4326);
const blob = writeGeometryData(gd);  // ready to store in a feature table
const decoded = readGeometryData(blob);
console.log(decoded.srsId, decoded.envelope, decoded.geometry);

import { createTransformFromEPSG, transformBoundingBox } from 'geopackage-ts';

const toWebMercator = createTransformFromEPSG(4326, 3857);
const [x, y] = toWebMercator(13.405, 52.52);

const bbox = transformBoundingBox(
  { minX: -180, minY: -85, maxX: 180, maxY: 85 },
  toWebMercator,
);

import { GeoPackageManager } from 'geopackage-ts';

const result = GeoPackageManager.validate('data.gpkg');
if (!result.valid) {
  console.error('Validation errors:', result.errors);
}