geopoint_sql 0.2.0 copy "geopoint_sql: ^0.2.0" to clipboard
geopoint_sql: ^0.2.0 copied to clipboard

Sql operations for geospatial data. Admin view for geopoint and geoserie.

Geopoint Sql #

pub package

Sql operations for geospatial data. Uses Geopoint and Geojson for data structures and Sqlcool for database management.

Documentation #

Init a geospatial database #

import 'package:sqlcool/sqlcool.dart';
import 'package:geopoint_sql/geopoint_sql.dart';

final geoDb = Db();
await geoDb
   .init(
      path: "geodb.sqlite",
      schema: [geoPointSchema, geoSerieSchema],
      verbose: true)
   .catchError((dynamic e) {
      throw ("Can not init geo database $e");
   });

Crud operations #

For geopoints:

import 'package:geopoint_sql/geopoint_sql.dart';

final geoPointSql = GeoPointSql(db: geoDb);
// save
geoPointSql.save(
   geoPoint: GeoPoint(name: "point", latitude: 0.0, longitude: 0.0));

For geoseries:

import 'package:geopoint_sql/geopoint_sql.dart';

final geoSerieSql = GeoSerieSql(db: geoDb);
// save
geoSerieSql.save(
   geoSerie: GeoSerie(name: "serie1", geoPoints: <GeoPoint>[]));
// update
geoSerieSql.update(
   geoSerie: GeoSerie(name: "serie1", geoPoints: <GeoPoint>[]));
// delete
geoSerieSql.delete(someExistingGeoserie);

Admin crud view #

import 'package:geopoint_sql/geopoint_sql.dart';

@override
Widget build(BuildContext context) {
   return Scaffold(
      body: GeoCrudNavigationPage(db: geoDb, activeTab: ActiveTab.line));
}

Screenshot

1
likes
40
pub points
0%
popularity

Publisher

unverified uploader

Sql operations for geospatial data. Admin view for geopoint and geoserie.

Repository (GitHub)
View/report issues

License

MIT (LICENSE)

Dependencies

cupertino_icons, extra_pedantic, flutter, geopoint, pedantic, sqlcool, sqlview

More

Packages that depend on geopoint_sql