Examples with DataColumnConstraintsDao mil.nga.geopackage.extension.schema.constraints.DataColumnConstraintsDao used on opensource projects

Example 1 with DataColumnConstraintsDao

use of mil.nga.geopackage.extension.schema.constraints.DataColumnConstraintsDao in project geopackage-android-map by ngageoint.

the class ReadmeTest method testGeoPackage.

/**
 * Test GeoPackage
 *
 * @param context        context
 * @param geoPackageFile GeoPackage file
 * @param map            Google map
 * @throws IOException  upon error
 * @throws SQLException upon error
 */
private void testGeoPackage(Context context, File geoPackageFile, GoogleMap map) throws IOException, SQLException {
    // Context context = ...;
    // File geoPackageFile = ...;
    // GoogleMap map = ...;
    // Get a manager
    GeoPackageManager manager = GeoPackageFactory.getManager(context);
    // Import database
    boolean imported = manager.importGeoPackage(geoPackageFile);
    // Available databases
    List<String> databases = manager.databases();
    // Open database
    GeoPackage geoPackage = manager.open(databases.get(0));
    // GeoPackage Table DAOs
    SpatialReferenceSystemDao srsDao = geoPackage.getSpatialReferenceSystemDao();
    ContentsDao contentsDao = geoPackage.getContentsDao();
    GeometryColumnsDao geomColumnsDao = geoPackage.getGeometryColumnsDao();
    TileMatrixSetDao tileMatrixSetDao = geoPackage.getTileMatrixSetDao();
    TileMatrixDao tileMatrixDao = geoPackage.getTileMatrixDao();
    SchemaExtension schemaExtension = new SchemaExtension(geoPackage);
    DataColumnsDao dao = schemaExtension.getDataColumnsDao();
    DataColumnConstraintsDao dataColumnConstraintsDao = schemaExtension.getDataColumnConstraintsDao();
    MetadataExtension metadataExtension = new MetadataExtension(geoPackage);
    MetadataDao metadataDao = metadataExtension.getMetadataDao();
    MetadataReferenceDao metadataReferenceDao = metadataExtension.getMetadataReferenceDao();
    ExtensionsDao extensionsDao = geoPackage.getExtensionsDao();
    // Feature and tile tables
    List<String> features = geoPackage.getFeatureTables();
    List<String> tiles = geoPackage.getTileTables();
    // Query Features
    String featureTable = features.get(0);
    FeatureDao featureDao = geoPackage.getFeatureDao(featureTable);
    GoogleMapShapeConverter converter = new GoogleMapShapeConverter(featureDao.getProjection());
    FeatureCursor featureCursor = featureDao.queryForAll();
    try {
        for (FeatureRow featureRow : featureCursor) {
            GeoPackageGeometryData geometryData = featureRow.getGeometry();
            if (geometryData != null && !geometryData.isEmpty()) {
                Geometry geometry = geometryData.getGeometry();
                GoogleMapShape shape = converter.toShape(geometry);
                GoogleMapShape mapShape = GoogleMapShapeConverter.addShapeToMap(map, shape);
            // ...
            }
        }
    } finally {
        featureCursor.close();
    }
    // Query Tiles
    String tileTable = tiles.get(0);
    TileDao tileDao = geoPackage.getTileDao(tileTable);
    TileCursor tileCursor = tileDao.queryForAll();
    try {
        for (TileRow tileRow : tileCursor) {
            byte[] tileBytes = tileRow.getTileData();
            Bitmap tileBitmap = tileRow.getTileDataBitmap();
        // ...
        }
    } finally {
        tileCursor.close();
    }
    // Retrieve Tiles by XYZ
    GeoPackageTileRetriever retriever = new GeoPackageTileRetriever(tileDao);
    GeoPackageTile geoPackageTile = retriever.getTile(2, 2, 2);
    if (geoPackageTile != null) {
        byte[] tileBytes = geoPackageTile.getData();
        Bitmap tileBitmap = geoPackageTile.getBitmap();
    // ...
    }
    // Retrieve Tiles by Bounding Box
    TileCreator tileCreator = new TileCreator(tileDao, ProjectionFactory.getProjection(ProjectionConstants.EPSG_WORLD_GEODETIC_SYSTEM));
    GeoPackageTile geoPackageTile2 = tileCreator.getTile(new BoundingBox(-90.0, 0.0, 0.0, 66.513260));
    if (geoPackageTile2 != null) {
        byte[] tileBytes = geoPackageTile2.getData();
        Bitmap tileBitmap = geoPackageTile2.getBitmap();
    // ...
    }
    // Tile Provider (GeoPackage or Google API)
    TileProvider overlay = GeoPackageOverlayFactory.getTileProvider(tileDao);
    TileOverlayOptions overlayOptions = new TileOverlayOptions();
    overlayOptions.tileProvider(overlay);
    overlayOptions.zIndex(-1);
    map.addTileOverlay(overlayOptions);
    BoundingBox boundingBox = BoundingBox.worldWebMercator();
    Projection projection = ProjectionFactory.getProjection(ProjectionConstants.EPSG_WEB_MERCATOR);
    // Index Features
    FeatureIndexManager indexer = new FeatureIndexManager(context, geoPackage, featureDao);
    indexer.setIndexLocation(FeatureIndexType.GEOPACKAGE);
    int indexedCount = indexer.index();
    // Query Indexed Features in paginated chunks
    FeatureIndexResults indexResults = indexer.queryForChunk(boundingBox, projection, 50);
    FeaturePaginatedCursor paginatedCursor = indexer.paginate(indexResults);
    for (FeatureRow featureRow : paginatedCursor) {
        GeoPackageGeometryData geometryData = featureRow.getGeometry();
        if (geometryData != null && !geometryData.isEmpty()) {
            Geometry geometry = geometryData.getGeometry();
        // ...
        }
    }
    // Feature Tile Provider (dynamically draw tiles from features)
    FeatureTiles featureTiles = new DefaultFeatureTiles(context, featureDao, context.getResources().getDisplayMetrics().density);
    // Set max features to draw per tile
    featureTiles.setMaxFeaturesPerTile(1000);
    // Custom feature tile implementation
    NumberFeaturesTile numberFeaturesTile = new NumberFeaturesTile(context);
    // Draw feature count tiles when max features passed
    featureTiles.setMaxFeaturesTileDraw(numberFeaturesTile);
    // Set index manager to query feature indices
    featureTiles.setIndexManager(indexer);
    FeatureOverlay featureOverlay = new FeatureOverlay(featureTiles);
    // Set zoom level to start showing tiles
    featureOverlay.setMinZoom(featureDao.getZoomLevel());
    TileOverlayOptions featureOverlayOptions = new TileOverlayOptions();
    featureOverlayOptions.tileProvider(featureOverlay);
    // Draw the feature tiles behind map markers
    featureOverlayOptions.zIndex(-1);
    map.addTileOverlay(featureOverlayOptions);
    // URL Tile Generator (generate tiles from a URL)
    TileGenerator urlTileGenerator = new UrlTileGenerator(context, geoPackage, "url_tile_table", "http://url/{z}/{x}/{y}.png", 0, 0, boundingBox, projection);
    int urlTileCount = urlTileGenerator.generateTiles();
    // Feature Tile Generator (generate tiles from features)
    TileGenerator featureTileGenerator = new FeatureTileGenerator(context, geoPackage, "tiles_" + featureTable, featureTiles, 1, 2, boundingBox, projection);
    int featureTileCount = featureTileGenerator.generateTiles();
    // Close feature tiles (and indexer)
    featureTiles.close();
    // Close database when done
    geoPackage.close();
}

Example 2 with DataColumnConstraintsDao

use of mil.nga.geopackage.extension.schema.constraints.DataColumnConstraintsDao in project geopackage-android-map by ngageoint.

the class TestUtils method createConstraints.

/**
 * Create Data Column Constraints
 *
 * @param geoPackage
 * @throws SQLException
 */
public static void createConstraints(GeoPackage geoPackage) throws SQLException {
    SchemaExtension schemaExtension = new SchemaExtension(geoPackage);
    schemaExtension.createDataColumnConstraintsTable();
    DataColumnConstraintsDao dao = schemaExtension.getDataColumnConstraintsDao();
    DataColumnConstraints sampleRange = new DataColumnConstraints();
    sampleRange.setConstraintName(SAMPLE_RANGE_CONSTRAINT);
    sampleRange.setConstraintType(DataColumnConstraintType.RANGE);
    sampleRange.setMin(BigDecimal.ONE);
    sampleRange.setMinIsInclusive(true);
    sampleRange.setMax(BigDecimal.TEN);
    sampleRange.setMaxIsInclusive(true);
    dao.create(sampleRange);
    DataColumnConstraints sampleEnum1 = new DataColumnConstraints();
    sampleEnum1.setConstraintName(SAMPLE_ENUM_CONSTRAINT);
    sampleEnum1.setConstraintType(DataColumnConstraintType.ENUM);
    sampleEnum1.setValue("1");
    dao.create(sampleEnum1);
    DataColumnConstraints sampleEnum3 = new DataColumnConstraints();
    sampleEnum3.setConstraintName(SAMPLE_ENUM_CONSTRAINT);
    sampleEnum3.setConstraintType(DataColumnConstraintType.ENUM);
    sampleEnum3.setValue("3");
    dao.create(sampleEnum3);
    DataColumnConstraints sampleEnum5 = new DataColumnConstraints();
    sampleEnum5.setConstraintName(SAMPLE_ENUM_CONSTRAINT);
    sampleEnum5.setConstraintType(DataColumnConstraintType.ENUM);
    sampleEnum5.setValue("5");
    dao.create(sampleEnum5);
    DataColumnConstraints sampleEnum7 = new DataColumnConstraints();
    sampleEnum7.setConstraintName(SAMPLE_ENUM_CONSTRAINT);
    sampleEnum7.setConstraintType(DataColumnConstraintType.ENUM);
    sampleEnum7.setValue("7");
    dao.create(sampleEnum7);
    DataColumnConstraints sampleEnum9 = new DataColumnConstraints();
    sampleEnum9.setConstraintName(SAMPLE_ENUM_CONSTRAINT);
    sampleEnum9.setConstraintType(DataColumnConstraintType.ENUM);
    sampleEnum9.setValue("9");
    dao.create(sampleEnum9);
    DataColumnConstraints sampleGlob = new DataColumnConstraints();
    sampleGlob.setConstraintName(SAMPLE_GLOB_CONSTRAINT);
    sampleGlob.setConstraintType(DataColumnConstraintType.GLOB);
    sampleGlob.setValue("[1-2][0-9][0-9][0-9]");
    dao.create(sampleGlob);
}