SQLite format 3@ ZyyGP10Z.? f WGS84epsgGEOGCS["WGS 84",DATUM["WGS_1984",SPHEROID["WGS 84",6378137,298.257223563,AUTHORITY["EPSG","7030"]],AUTHORITY["EPSG","6326"]],PRIMEM["Greenwich",0,AUTHORITY["EPSG","8901"]],UNIT["degree",0.0174532925199433,AUTHORITY["EPSG","9122"]],AUTHORITY["EPSG","4326"]](5Undefined GeographicNONEUndefined(3Undefined CartesianNONEUndefinedY !SH=1]gr}% test_pk! geo2d geo2dm geo3dz geo3dzm gc3dzm gc3dz gc2dmgc2d mpt2d mpt2dm mpt3dz mpt3dzm mln3dzm mln3dz mln2dm mln2d mpg2d mpg2dm mpg3dz mpg3dzm pg3dzm pg3dz pg2dm pg2d ln3dzm ln3dz ln2dmln2d pt3dzm pt3dz pt2dm pt2d !SH=1]gr}% test_pk! geo2d geo2dm geo3dz geo3dzm gc3dzm gc3dz gc2dmgc2d mpt2d mpt2dm mpt3dz mpt3dzm mln3dzm mln3dz mln2dm mln2d mpg2d mpg2dm mpg3dz mpg3dzm pg3dzm pg3dz pg2dm pg2d ln3dzm ln3dz ln2dmln2d pt3dzm pt3dz pt2dm pt2dgf !paQ 0@ ,<{l]Mtest_pkgeom!geo2dgeom geo2dmgeomgeo3dzgeomgeo3dzmgeomgc3dzmgeomgc3dzgeomgc2dmgeom gc2dgeommpt2dgeommpt2dmgeommpt3dzgeommpt3dzmgeommln3dzmgeommln3dzgeommln2dmgeommln2dgeommpg2dgeommpg2dmgeommpg3dzgeommpg3dzmgeom pg3dzmgeom pg3dzgeom pg2dmgeom pg2dgeom ln3dzmgeomln3dzgeomln2dmgeom ln2dgeompt3dzmgeompt3dzgeompt2dmgeom  pt2dgeom !SH=1]gr}% test_pk! geo2d geo2dm geo3dz geo3dzm gc3dzm gc3dz gc2dmgc2d mpt2d mpt2dm mpt3dz mpt3dzm mln3dzm mln3dz mln2dm mln2d mpg2d mpg2dm mpg3dz mpg3dzm pg3dzm pg3dz pg2dm pg2d ln3dzm ln3dz ln2dmln2d pt3dzm pt3dz pt2dm pt2d    555tablegpkg_spatial_ref_sysgpkg_spatial_ref_sysCREATE TABLE gpkg_spatial_ref_sys ( srs_name TEXT NOT NULL, srs_id INTEGER NOT NULL PRIMARY KEY, organization TEXT NOT NULL, organization_coordsys_id INTEGER NOT NULL, definition TEXT NOT NULL, description TEXT )+''tablegpkg_contentsgpkg_contentsCREATE TABLE gpkg_contents ( table_name TEXT NOT NULL PRIMARY KEY, data_type TEXT NOT NULL, identifier TEXT UNIQUE, description TEXT DEFAULT '', last_change TEXT NOT NULL DEFAULT (strftime('%Y-%m-%dT%H:%M:%fZ',CURRENT_TIMESTAMP)), min_x DOUBLE, min_y DOUBLE, max_x DOUBLE, max_y DOUBLE, srs_id INTEGER, CONSTRAINT fk_gc_r_srid FOREIGN KEY (srs_id) REFERENCES gpkg_spatial_ref_sys(srs_id))9M'indexsqlite_autoindex_gpkg_contents_1gpkg_contents 44oj9M'indexsqlite_autoindex_gpkg_contents_2gpkg_contentsx77tablegpkg_geometry_columnsgpkg_geometry_columnsCREATE TABLE gpkg_geometry_columns ( table_name TEXT NOT NULL, column_name TEXT, geometry_type_name TEXT, srs_id INTEGER NOT NULL, z INTEGER NOT NULL, m TINYINT NOT NULL, CONSTRAINT pk_geom_cols PRIMARY KEY (table_name, column_name), CONSTRAINT uk_gc_table_name UNIQUE (table_name), CONSTRAINT fk_gc_tn FOREIGN KEY (table_name) REFERENCES gpkg_contents(table_name), CONSTRAINT fk_gc_srs FOREIGN KEY (srs_id) REFERENCES gpkg_spatial_ref_sys (srs_id))I]7indexsqlite_autoindex_gpkg_geometry_columns_1gpkg_geometry_columnsI]7indexsqlite_autoindex_gpkg_geometry_columns_2gpkg_geometry_columns   >>0&55otablegpkg_tile_matrix_setgpkg_tile_matrix_set CREATE TABLE gpkg_tile_matrix_set ( table_name TEXT NOT NULL PRIMARY KEY, srs_id INTEGER NOT NULL, min_x DOUBLE NOT NULL, min_y DOUBLE NOT NULL, max_x DOUBLE NOT NULL, max_y DOUBLE NOT NULL, CONSTRAINT fk_gtms_table_name FOREIGN KEY (table_name) REFERENCES gpkg_contents(table_name), CONSTRAINT fk_gtms_srs FOREIGN KEY (srs_id) REFERENCES gpkg_spatial_ref_sys (srs_id))G [5indexsqlite_autoindex_gpkg_tile_matrix_set_1gpkg_tile_matrix_set M --Mtablegpkg_tile_matrixgpkg_tile_matrixCREATE TABLE gpkg_tile_matrix ( table_name TEXT NOT NULL, zoom_level INTEGER NOT NULL, matrix_width INTEGER NOT NULL, matrix_height INTEGER NOT NULL, tile_width INTEGER NOT NULL, tile_height INTEGER NOT NULL, pixel_x_size DOUBLE NOT NULL, pixel_y_size DOUBLE NOT NULL, CONSTRAINT pk_ttm PRIMARY KEY (table_name, zoom_level), CONSTRAINT fk_tmm_table_name FOREIGN KEY (table_name) REFERENCES gpkg_contents(table_name))   ssZ? S-indexsqlite_autoindex_gpkg_tile_matrix_1gpkg_tile_matrix` //otablegpkg_data_columnsgpkg_data_columnsCREATE TABLE gpkg_data_columns ( table_name TEXT NOT NULL, column_name TEXT NOT NULL, name TEXT, title TEXT, description TEXT, mime_type TEXT, constraint_name TEXT, CONSTRAINT pk_gdc PRIMARY KEY (table_name, column_name), CONSTRAINT fk_gdc_tn FOREIGN KEY (table_name) REFERENCES gpkg_contents(table_name))A U/indexsqlite_autoindex_gpkg_data_columns_1gpkg_data_columnsJEEtablegpkg_data_column_constraintsgpkg_data_column_constraintsCREATE TABLE gpkg_data_column_constraints ( constraint_name TEXT NOT NULL, constraint_type TEXT NOT NULL, value TEXT, min NUMERIC, minIsInclusive BOOLEAN, max NUMERIC, maxIsInclusive BOOLEAN, CONSTRAINT gdcc_ntv UNIQUE (constraint_name, constraint_type, value))WkEindexsqlite_autoindex_gpkg_data_column_constraints_1gpkg_data_column_constraints        ''Wtablegpkg_metadatagpkg_metadataCREATE TABLE gpkg_metadata ( id INTEGER CONSTRAINT m_pk PRIMARY KEY ASC NOT NULL UNIQUE, md_scope TEXT NOT NULL DEFAULT 'dataset', md_standard_uri TEXT NOT NULL, mime_type TEXT NOT NULL DEFAULT 'text/xml', metadata TEXT NOT NULL)9M'indexsqlite_autoindex_gpkg_metadata_1gpkg_metadatab;;[tablegpkg_metadata_referencegpkg_metadata_referenceCREATE TABLE gpkg_metadata_reference ( reference_scope TEXT NOT NULL, table_name TEXT, column_name TEXT, row_id_value INTEGER, timestamp DATETIME NOT NULL DEFAULT (strftime('%Y-%m-%dT%H:%M:%fZ',CURRENT_TIMESTAMP)), md_file_id INTEGER NOT NULL, md_parent_id INTEGER, CONSTRAINT crmr_mfi_fk FOREIGN KEY (md_file_id) REFERENCES gpkg_metadata(id), CONSTRAINT crmr_mpi_fk FOREIGN KEY (md_parent_id) REFERENCES gpkg_metadata(id)) R/X MB7,q!QP U3U+Ampt3dzmgeomgpkg_geometry_type_trigger=d -pg3dzmgeomgpkg_rtree_index$ -mpg2dgeomgpkg_rtree_index0!3ln2dgeomgpkg_srs_id_trigger 555t}++1tablegpkg_extensionsgpkg_extensionsCREATE TABLE gpkg_extensions ( table_name TEXT, column_name TEXT, extension_name TEXT NOT NULL, definition TEXT NOT NULL, scope TEXT NOT NULL, CONSTRAINT ge_tce UNIQUE (table_name, column_name, extension_name))=Q+indexsqlite_autoindex_gpkg_extensions_1gpkg_extensions<Q-triggergpkg_tile_matrix_zoom_level_insertgpkg_tile_matrixCREATE TRIGGER 'gpkg_tile_matrix_zoom_level_insert' BEFORE INSERT ON 'gpkg_tile_matrix' FOR EACH ROW BEGIN SELECT RAISE(ABORT, 'insert on table ''gpkg_tile_matrix'' violates constraint: zoom_level cannot be less than 0') WHERE (NEW.zoom_level < 0); ENDJQ-!triggergpkg_tile_matrix_zoom_level_updategpkg_tile_matrixCREATE TRIGGER 'gpkg_tile_matrix_zoom_level_update' BEFORE UPDATE of zoom_level ON 'gpkg_tile_matrix' FOR EACH ROW BEGIN SELECT RAISE(ABORT, 'update on table ''gpkg_tile_matrix'' violates constraint: zoom_level cannot be less than 0') WHERE (NEW.zoom_level < 0); END ^DU-triggergpkg_tile_matrix_matrix_width_insertgpkg_tile_matrixCREATE TRIGGER 'gpkg_tile_matrix_matrix_width_insert' BEFORE INSERT ON 'gpkg_tile_matrix' FOR EACH ROW BEGIN SELECT RAISE(ABORT, 'insert on table ''gpkg_tile_matrix'' violates constraint: matrix_width cannot be less than 1') WHERE (NEW.matrix_width < 1); ENDTU-1triggergpkg_tile_matrix_matrix_width_updategpkg_tile_matrixCREATE TRIGGER 'gpkg_tile_matrix_matrix_width_update' BEFORE UPDATE OF matrix_width ON 'gpkg_tile_matrix' FOR EACH ROW BEGIN SELECT RAISE(ABORT, 'update on table ''gpkg_tile_matrix'' violates constraint: matrix_width cannot be less than 1') WHERE (NEW.matrix_width < 1); ENDHW-triggergpkg_tile_matrix_matrix_height_insertgpkg_tile_matrixCREATE TRIGGER 'gpkg_tile_matrix_matrix_height_insert' BEFORE INSERT ON 'gpkg_tile_matrix' FOR EACH ROW BEGIN SELECT RAISE(ABORT, 'insert on table ''gpkg_tile_matrix'' violates constraint: matrix_height cannot be less than 1') WHERE (NEW.matrix_height < 1); END XXYW-9triggergpkg_tile_matrix_matrix_height_updategpkg_tile_matrixCREATE TRIGGER 'gpkg_tile_matrix_matrix_height_update' BEFORE UPDATE OF matrix_height ON 'gpkg_tile_matrix' FOR EACH ROW BEGIN SELECT RAISE(ABORT, 'update on table ''gpkg_tile_matrix'' violates constraint: matrix_height cannot be less than 1') WHERE (NEW.matrix_height < 1); ENDIU-triggergpkg_tile_matrix_pixel_x_size_insertgpkg_tile_matrixCREATE TRIGGER 'gpkg_tile_matrix_pixel_x_size_insert' BEFORE INSERT ON 'gpkg_tile_matrix' FOR EACH ROW BEGIN SELECT RAISE(ABORT, 'insert on table ''gpkg_tile_matrix'' violates constraint: pixel_x_size must be greater than 0') WHERE NOT (NEW.pixel_x_size > 0); END XXYU-;triggergpkg_tile_matrix_pixel_x_size_updategpkg_tile_matrixCREATE TRIGGER 'gpkg_tile_matrix_pixel_x_size_update' BEFORE UPDATE OF pixel_x_size ON 'gpkg_tile_matrix' FOR EACH ROW BEGIN SELECT RAISE(ABORT, 'update on table ''gpkg_tile_matrix'' violates constraint: pixel_x_size must be greater than 0') WHERE NOT (NEW.pixel_x_size > 0); ENDIU-triggergpkg_tile_matrix_pixel_y_size_insertgpkg_tile_matrixCREATE TRIGGER 'gpkg_tile_matrix_pixel_y_size_insert' BEFORE INSERT ON 'gpkg_tile_matrix' FOR EACH ROW BEGIN SELECT RAISE(ABORT, 'insert on table ''gpkg_tile_matrix'' violates constraint: pixel_y_size must be greater than 0') WHERE NOT (NEW.pixel_y_size > 0); END YU-;triggergpkg_tile_matrix_pixel_y_size_updategpkg_tile_matrixCREATE TRIGGER 'gpkg_tile_matrix_pixel_y_size_update' BEFORE UPDATE OF pixel_y_size ON 'gpkg_tile_matrix' FOR EACH ROW BEGIN SELECT RAISE(ABORT, 'update on table ''gpkg_tile_matrix'' violates constraint: pixel_y_size must be greater than 0') WHERE NOT (NEW.pixel_y_size > 0); END  G'/triggergpkg_metadata_md_scope_insertgpkg_metadataCREATE TRIGGER 'gpkg_metadata_md_scope_insert' BEFORE INSERT ON 'gpkg_metadata' FOR EACH ROW BEGIN SELECT RAISE(ABORT, 'insert on table gpkg_metadata violates constraint: md_scope must be one of undefined | fieldSession | collectionSession | series | dataset | featureType | feature | attributeType | attribute | tile | model | catalog | schema | taxonomy | software | service | collectionHardware | nonGeographicDataset | dimensionGroup') WHERE NOT(NEW.md_scope IN ('undefined','fieldSession','collectionSession','series','dataset', 'featureType','feature','attributeType','attribute','tile','model', 'catalog','schema','taxonomy','software','service', 'collectionHardware','nonGeographicDataset','dimensionGroup')); END  G'Ktriggergpkg_metadata_md_scope_updategpkg_metadataCREATE TRIGGER 'gpkg_metadata_md_scope_update' BEFORE UPDATE OF 'md_scope' ON 'gpkg_metadata' FOR EACH ROW BEGIN SELECT RAISE(ABORT, 'update on table gpkg_metadata violates constraint: md_scope must be one of undefined | fieldSession | collectionSession | series | dataset | featureType | feature | attributeType | attribute | tile | model | catalog | schema | taxonomy | software | service | collectionHardware | nonGeographicDataset | dimensionGroup') WHERE NOT(NEW.md_scope IN ('undefined','fieldSession','collectionSession','series','dataset', 'featureType','feature','attributeType','attribute','tile','model', 'catalog','schema','taxonomy','software','service', 'collectionHardware','nonGeographicDataset','dimensionGroup')); END OOK!i;}triggergpkg_metadata_reference_reference_scope_insertgpkg_metadata_referenceCREATE TRIGGER 'gpkg_metadata_reference_reference_scope_insert' BEFORE INSERT ON 'gpkg_metadata_reference' FOR EACH ROW BEGIN SELECT RAISE(ABORT, 'insert on table gpkg_metadata_reference violates constraint: reference_scope must be one of "geopackage", "table", "column", "row", "row/col"') WHERE NOT NEW.reference_scope IN ('geopackage','table','column','row','row/col'); END`"i;'triggergpkg_metadata_reference_reference_scope_updategpkg_metadata_referenceCREATE TRIGGER 'gpkg_metadata_reference_reference_scope_update' BEFORE UPDATE OF 'reference_scope' ON 'gpkg_metadata_reference' FOR EACH ROW BEGIN SELECT RAISE(ABORT, 'update on table gpkg_metadata_reference violates constraint: reference_scope must be one of "geopackage", "table", "column", "row", "row/col"') WHERE NOT NEW.reference_scope IN ('geopackage','table','column','row','row/col'); END O#a; triggergpkg_metadata_reference_column_name_insertgpkg_metadata_referenceCREATE TRIGGER 'gpkg_metadata_reference_column_name_insert' BEFORE INSERT ON 'gpkg_metadata_reference' FOR EACH ROW BEGIN SELECT RAISE(ABORT, 'insert on table gpkg_metadata_reference violates constraint: column name must be NULL when reference_scope is "geopackage", "table" or "row"') WHERE (NEW.reference_scope IN ('geopackage','table','row') AND NEW.column_name IS NOT NULL); SELECT RAISE(ABORT, 'insert on table gpkg_metadata_reference violates constraint: column name must be defined for the specified table when reference_scope is "column" or "row/col"') WHERE (NEW.reference_scope IN ('column','row/col') AND NOT NEW.table_name IN (SELECT name FROM SQLITE_MASTER WHERE type = 'table' AND name = NEW.table_name AND sql LIKE ('%' || NEW.column_name || '%'))); END ]$a;)triggergpkg_metadata_reference_column_name_updategpkg_metadata_referenceCREATE TRIGGER 'gpkg_metadata_reference_column_name_update' BEFORE UPDATE OF column_name ON 'gpkg_metadata_reference' FOR EACH ROW BEGIN SELECT RAISE(ABORT, 'update on table gpkg_metadata_reference violates constraint: column name must be NULL when reference_scope is "geopackage", "table" or "row"') WHERE (NEW.reference_scope IN ('geopackage','table','row') AND NEW.column_nameIS NOT NULL); SELECT RAISE(ABORT, 'update on table gpkg_metadata_reference violates constraint: column name must be defined for the specified table when reference_scope is "column" or "row/col"') WHERE (NEW.reference_scope IN ('column','row/col') AND NOT NEW.table_name IN (SELECT name FROM SQLITE_MASTER WHERE type = 'table' AND name = NEW.table_name AND sql LIKE ('%' || NEW.column_name || '%'))); END %c;triggergpkg_metadata_reference_row_id_value_insertgpkg_metadata_referenceCREATE TRIGGER 'gpkg_metadata_reference_row_id_value_insert' BEFORE INSERT ON 'gpkg_metadata_reference' FOR EACH ROW BEGIN SELECT RAISE(ABORT, 'insert on table gpkg_metadata_reference violates constraint: row_id_value must be NULL when reference_scope is "geopackage", "table" or "column"') WHERE NEW.reference_scope IN ('geopackage','table','column') AND NEW.row_id_value IS NOT NULL; SELECT RAISE(ABORT, 'insert on table gpkg_metadata_reference violates constraint: row_id_value must exist in specified table when reference_scope is "row" or "row/col"') WHERE NEW.reference_scope IN ('row','row/col') AND NOT EXISTS (SELECT rowid FROM (SELECT NEW.table_name AS table_name) WHERE rowid = NEW.row_id_value); END )&c;?triggergpkg_metadata_reference_row_id_value_updategpkg_metadata_referenceCREATE TRIGGER 'gpkg_metadata_reference_row_id_value_update' BEFORE UPDATE OF 'row_id_value' ON 'gpkg_metadata_reference' FOR EACH ROW BEGIN SELECT RAISE(ABORT, 'update on table gpkg_metadata_reference violates constraint: row_id_value must be NULL when reference_scope is "geopackage", "table" or "column"') WHERE NEW.reference_scope IN ('geopackage','table','column') AND NEW.row_id_value IS NOT NULL; SELECT RAISE(ABORT, 'update on table gpkg_metadata_reference violates constraint: row_id_value must exist in specified table when reference_scope is "row" or "row/col"') WHERE NEW.reference_scope IN ('row','row/col') AND NOT EXISTS (SELECT rowid FROM (SELECT NEW.table_name AS table_name) WHERE rowid = NEW.row_id_value); END '];triggergpkg_metadata_reference_timestamp_insertgpkg_metadata_referenceCREATE TRIGGER 'gpkg_metadata_reference_timestamp_insert' BEFORE INSERT ON 'gpkg_metadata_reference' FOR EACH ROW BEGIN SELECT RAISE(ABORT, 'insert on table gpkg_metadata_reference violates constraint: timestamp must be a valid time in ISO 8601 "yyyy-mm-ddThh-mm-ss.cccZ" form') WHERE NOT (NEW.timestamp GLOB '[1-2][0-9][0-9][0-9]-[0-1][0-9]-[1-3][0-9]T[0-2][0-9]:[0-5][0-9]:[0-5][0-9].[0-9][0-9][0-9]Z' AND strftime('%s',NEW.timestamp) NOT NULL); END (];1triggergpkg_metadata_reference_timestamp_updategpkg_metadata_referenceCREATE TRIGGER 'gpkg_metadata_reference_timestamp_update' BEFORE UPDATE OF 'timestamp' ON 'gpkg_metadata_reference' FOR EACH ROW BEGIN SELECT RAISE(ABORT, 'update on table gpkg_metadata_reference violates constraint: timestamp must be a valid time in ISO 8601 "yyyy-mm-ddThh-mm-ss.cccZ" form') WHERE NOT (NEW.timestamp GLOB '[1-2][0-9][0-9][0-9]-[0-1][0-9]-[1-3][0-9]T[0-2][0-9]:[0-5][0-9]:[0-5][0-9].[0-9][0-9][0-9]Z' AND strftime('%s',NEW.timestamp) NOT NULL); END<)I7triggergpkg_geometry_columns_z_insertgpkg_geometry_columnsCREATE TRIGGER 'gpkg_geometry_columns_z_insert' BEFORE INSERT ON 'gpkg_geometry_columns' FOR EACH ROW BEGIN SELECT RAISE(ABORT, 'insert on table gpkg_geometry_columns violates constraint: z must be one of 0, 1 or 2') WHERE NOT(NEW.z IN (0, 1, 2)); END 77|B*I7triggergpkg_geometry_columns_z_updategpkg_geometry_columnsCREATE TRIGGER 'gpkg_geometry_columns_z_update' BEFORE UPDATE OF 'z' ON 'gpkg_geometry_columns' FOR EACH ROW BEGIN SELECT RAISE(ABORT, 'update on table gpkg_geometry_columns violates constraint: z must be one of 0, 1 or 2') WHERE NOT NEW.z IN (0, 1, 2); END<+I7triggergpkg_geometry_columns_m_insertgpkg_geometry_columnsCREATE TRIGGER 'gpkg_geometry_columns_m_insert' BEFORE INSERT ON 'gpkg_geometry_columns' FOR EACH ROW BEGIN SELECT RAISE(ABORT, 'insert on table gpkg_geometry_columns violates constraint: m must be one of 0, 1 or 2') WHERE NOT(NEW.m IN (0, 1, 2)); ENDB,I7triggergpkg_geometry_columns_m_updategpkg_geometry_columnsCREATE TRIGGER 'gpkg_geometry_columns_m_update' BEFORE UPDATE OF 'm' ON 'gpkg_geometry_columns' FOR EACH ROW BEGIN SELECT RAISE(ABORT, 'update on table gpkg_geometry_columns violates constraint: m must be one of 0, 1 or 2') WHERE NOT NEW.m IN (0, 1, 2); END o& deltaGgammaGP??@@?@FbetaGP??@@?@GalphaGP?????? -tablept2dpt2d*CREATE TABLE "pt2d" ( "id" "INTEGER" NOT NULL, "name" "TEXT" NOT NULL, geom BLOB, CONSTRAINT "pk_pt2d" PRIMARY KEY ("id"))e.)triggerfgti_pt2d_geompt2dCREATE TRIGGER "fgti_pt2d_geom" BEFORE INSERT ON "pt2d" FOR EACH ROW BEGIN SELECT RAISE (ROLLBACK, 'insert on "pt2d" violates constraint: ST_GeometryType("geom") is not assignable from gpkg_geometry_columns.geometry_type_name value') WHERE (SELECT geometry_type_name FROM gpkg_geometry_columns WHERE Lower(table_name) = Lower('geom') AND Lower(column_name) = Lower('geom') AND gpkg_IsAssignable(geometry_type_name, ST_GeometryType(NEW."geom")) = 0); END mmiy/)?triggerfgtu_pt2d_geompt2dCREATE TRIGGER "fgtu_pt2d_geom" BEFORE UPDATE OF "geom" ON "pt2d" FOR EACH ROW BEGIN SELECT RAISE (ROLLBACK, 'update of "pt2d" on "geom" violates constraint: ST_GeometryType("geom") is not assignable from gpkg_geometry_columns.geometry_type_name value') WHERE (SELECT geometry_type_name FROM gpkg_geometry_columns WHERE Lower(table_name) = Lower('geom') AND Lower(column_name) = Lower('geom') AND gpkg_IsAssignable(geometry_type_name, ST_GeometryType(NEW."geom")) = 0); END0)utriggerfgsi_pt2d_geompt2dCREATE TRIGGER "fgsi_pt2d_geom" BEFORE INSERT ON "pt2d" FOR EACH ROW BEGIN SELECT RAISE (ROLLBACK, 'insert on "pt2d" violates constraint: ST_SRID("geom") does not match gpkg_geometry_columns.srs_id value') WHERE (SELECT srs_id FROM gpkg_geometry_columns WHERE Lower(table_name) = Lower('geom') AND Lower(column_name) = Lower('geom') AND ST_SRID(NEW."geom") <> srs_id); END (1)triggerfgsu_pt2d_geompt2dCREATE TRIGGER "fgsu_pt2d_geom" BEFORE UPDATE OF "geom" ON "pt2d" FOR EACH ROW BEGIN SELECT RAISE (ROLLBACK, 'update of "pt2d" on "geom" violates constraint: ST_SRID("geom") does not match gpkg_geometry_columns.srs_id value') WHERE (SELECT srs_id FROM gpkg_geometry_columns WHERE Lower(table_name) = Lower('geom') AND Lower(column_name) = Lower('geom') AND ST_SRID(NEW."geom") <> srs_id); END;293triggerrtree_pt2d_geom_insertpt2dCREATE TRIGGER "rtree_pt2d_geom_insert" AFTER INSERT ON "pt2d" WHEN (new."geom" NOT NULL AND NOT ST_IsEmpty(NEW."geom")) BEGIN INSERT OR REPLACE INTO "rtree_pt2d_geom" VALUES (NEW.ROWID, ST_MinX(NEW."geom"), ST_MaxX(NEW."geom"), ST_MinY(NEW."geom"), ST_MaxY(NEW."geom")); END a3;}triggerrtree_pt2d_geom_update1pt2dCREATE TRIGGER "rtree_pt2d_geom_update1" AFTER UPDATE OF "geom" ON "pt2d" WHEN OLD.ROWID = NEW.ROWID AND (NEW."geom" NOT NULL AND NOT ST_IsEmpty(NEW."geom")) BEGIN INSERT OR REPLACE INTO "rtree_pt2d_geom" VALUES (NEW.ROWID, ST_MinX(NEW."geom"), ST_MaxX(NEW."geom"), ST_MinY(NEW."geom"), ST_MaxY(NEW."geom")); END~4;7triggerrtree_pt2d_geom_update2pt2dCREATE TRIGGER "rtree_pt2d_geom_update2" AFTER UPDATE OF "geom" ON "pt2d" WHEN OLD.ROWID = NEW.ROWID AND (NEW."geom" IS NULL OR ST_IsEmpty(NEW."geom")) BEGIN DELETE FROM "rtree_pt2d_geom" WHERE id = OLD.ROWID; END ;A5;gtriggerrtree_pt2d_geom_update3pt2dCREATE TRIGGER "rtree_pt2d_geom_update3" AFTER UPDATE OF "geom" ON "pt2d" WHEN OLD.ROWID != NEW.ROWID AND (NEW."geom" NOT NULL AND NOT ST_IsEmpty(NEW."geom")) BEGIN DELETE FROM "rtree_pt2d_geom" WHERE id = OLD.ROWID; INSERT OR REPLACE INTO "rtree_pt2d_geom" VALUES (NEW.ROWID, ST_MinX(NEW."geom"), ST_MaxX(NEW."geom"), ST_MinY(NEW."geom"), ST_MaxY(NEW."geom")); END6;Atriggerrtree_pt2d_geom_update4pt2dCREATE TRIGGER "rtree_pt2d_geom_update4" AFTER UPDATE ON "pt2d" WHEN OLD.ROWID != NEW.ROWID AND (NEW."geom" IS NULL OR ST_IsEmpty(NEW."geom")) BEGIN DELETE FROM "rtree_pt2d_geom" WHERE id IN (OLD.ROWID, NEW.ROWID); END<795triggerrtree_pt2d_geom_deletept2dCREATE TRIGGER "rtree_pt2d_geom_delete" AFTER DELETE ON "pt2d"WHEN old."geom" NOT NULL BEGIN DELETE FROM "rtree_pt2d_geom" WHERE id = OLD.ROWID; END 99D ??????@ff@fg??@ @ RRMgx8++)tablertree_pt2d_geomrtree_pt2d_geomCREATE VIRTUAL TABLE "rtree_pt2d_geom" USING rtree(id, minx, maxx, miny, maxy)955!tablertree_pt2d_geom_nodertree_pt2d_geom_node0CREATE TABLE "rtree_pt2d_geom_node"(nodeno INTEGER PRIMARY KEY, data BLOB):77+tablertree_pt2d_geom_rowidrtree_pt2d_geom_rowid2CREATE TABLE "rtree_pt2d_geom_rowid"(rowid INTEGER PRIMARY KEY, nodeno INTEGER);997tablertree_pt2d_geom_parentrtree_pt2d_geom_parent3CREATE TABLE "rtree_pt2d_geom_parent"(nodeno INTEGER PRIMARY KEY, parentnode INTEGER)< tablept2dmpt2dm4CREATE TABLE "pt2dm" ( "id" "INTEGER" NOT NULL, "name" "TEXT" NOT NULL, geom BLOB, CONSTRAINT "pk_pt2dm" PRIMARY KEY ("id"))     TOgammaGP??????$@NbetaGP??????&@ deltaOalphaGP??333333?333333??333333?"@ j=+triggerfgti_pt2dm_geompt2dmCREATE TRIGGER "fgti_pt2dm_geom" BEFORE INSERT ON "pt2dm" FOR EACH ROW BEGIN SELECT RAISE (ROLLBACK, 'insert on "pt2dm" violates constraint: ST_GeometryType("geom") is not assignable from gpkg_geometry_columns.geometry_type_name value') WHERE (SELECT geometry_type_name FROM gpkg_geometry_columns WHERE Lower(table_name) = Lower('geom') AND Lower(column_name) = Lower('geom') AND gpkg_IsAssignable(geometry_type_name, ST_GeometryType(NEW."geom")) = 0); END~>+Etriggerfgtu_pt2dm_geompt2dmCREATE TRIGGER "fgtu_pt2dm_geom" BEFORE UPDATE OF "geom" ON "pt2dm" FOR EACH ROW BEGIN SELECT RAISE (ROLLBACK, 'update of "pt2dm" on "geom" violates constraint: ST_GeometryType("geom") is not assignable from gpkg_geometry_columns.geometry_type_name value') WHERE (SELECT geometry_type_name FROM gpkg_geometry_columns WHERE Lower(table_name) = Lower('geom') AND Lower(column_name) = Lower('geom') AND gpkg_IsAssignable(geometry_type_name, ST_GeometryType(NEW."geom")) = 0); END P?+{triggerfgsi_pt2dm_geompt2dmCREATE TRIGGER "fgsi_pt2dm_geom" BEFORE INSERT ON "pt2dm" FOR EACH ROW BEGIN SELECT RAISE (ROLLBACK, 'insert on "pt2dm" violates constraint: ST_SRID("geom") does not match gpkg_geometry_columns.srs_id value') WHERE (SELECT srs_id FROM gpkg_geometry_columns WHERE Lower(table_name) = Lower('geom') AND Lower(column_name) = Lower('geom') AND ST_SRID(NEW."geom") <> srs_id); END-@+#triggerfgsu_pt2dm_geompt2dmCREATE TRIGGER "fgsu_pt2dm_geom" BEFORE UPDATE OF "geom" ON "pt2dm" FOR EACH ROW BEGIN SELECT RAISE (ROLLBACK, 'update of "pt2dm" on "geom" violates constraint: ST_SRID("geom") does not match gpkg_geometry_columns.srs_id value') WHERE (SELECT srs_id FROM gpkg_geometry_columns WHERE Lower(table_name) = Lower('geom') AND Lower(column_name) = Lower('geom') AND ST_SRID(NEW."geom") <> srs_id); END NN@A;9triggerrtree_pt2dm_geom_insertpt2dmCREATE TRIGGER "rtree_pt2dm_geom_insert" AFTER INSERT ON "pt2dm" WHEN (new."geom" NOT NULL AND NOT ST_IsEmpty(NEW."geom")) BEGIN INSERT OR REPLACE INTO "rtree_pt2dm_geom" VALUES (NEW.ROWID, ST_MinX(NEW."geom"), ST_MaxX(NEW."geom"), ST_MinY(NEW."geom"), ST_MaxY(NEW."geom")); ENDfB=triggerrtree_pt2dm_geom_update1pt2dmCREATE TRIGGER "rtree_pt2dm_geom_update1" AFTER UPDATE OF "geom" ON "pt2dm" WHEN OLD.ROWID = NEW.ROWID AND (NEW."geom" NOT NULL AND NOT ST_IsEmpty(NEW."geom")) BEGIN INSERT OR REPLACE INTO "rtree_pt2dm_geom" VALUES (NEW.ROWID, ST_MinX(NEW."geom"), ST_MaxX(NEW."geom"), ST_MinY(NEW."geom"), ST_MaxY(NEW."geom")); ENDC==triggerrtree_pt2dm_geom_update2pt2dmCREATE TRIGGER "rtree_pt2dm_geom_update2" AFTER UPDATE OF "geom" ON "pt2dm" WHEN OLD.ROWID = NEW.ROWID AND (NEW."geom" IS NULL OR ST_IsEmpty(NEW."geom")) BEGIN DELETE FROM "rtree_pt2dm_geom" WHERE id = OLD.ROWID; END 1<D=otriggerrtree_pt2dm_geom_update3pt2dmCREATE TRIGGER "rtree_pt2dm_geom_update3" AFTER UPDATE OF "geom" ON "pt2dm" WHEN OLD.ROWID != NEW.ROWID AND (NEW."geom" NOT NULL AND NOT ST_IsEmpty(NEW."geom")) BEGIN DELETE FROM "rtree_pt2dm_geom" WHERE id = OLD.ROWID; INSERT OR REPLACE INTO "rtree_pt2dm_geom" VALUES (NEW.ROWID, ST_MinX(NEW."geom"), ST_MaxX(NEW."geom"), ST_MinY(NEW."geom"), ST_MaxY(NEW."geom")); ENDE=Gtriggerrtree_pt2dm_geom_update4pt2dmCREATE TRIGGER "rtree_pt2dm_geom_update4" AFTER UPDATE ON "pt2dm" WHEN OLD.ROWID != NEW.ROWID AND (NEW."geom" IS NULL OR ST_IsEmpty(NEW."geom")) BEGIN DELETE FROM "rtree_pt2dm_geom" WHERE id IN (OLD.ROWID, NEW.ROWID); ENDAF;;triggerrtree_pt2dm_geom_deletept2dmCREATE TRIGGER "rtree_pt2dm_geom_delete" AFTER DELETE ON "pt2dm"WHEN old."geom" NOT NULL BEGIN DELETE FROM "rtree_pt2dm_geom" WHERE id = OLD.ROWID; END 99D ?????ff?fh?ff?fh???? EEGg{G--+tablertree_pt2dm_geomrtree_pt2dm_geomCREATE VIRTUAL TABLE "rtree_pt2dm_geom" USING rtree(id, minx, maxx, miny, maxy)H77#tablertree_pt2dm_geom_nodertree_pt2dm_geom_node9CREATE TABLE "rtree_pt2dm_geom_node"(nodeno INTEGER PRIMARY KEY, data BLOB) I99-tablertree_pt2dm_geom_rowidrtree_pt2dm_geom_rowid;CREATE TABLE "rtree_pt2dm_geom_rowid"(rowid INTEGER PRIMARY KEY, nodeno INTEGER)J;;9tablertree_pt2dm_geom_parentrtree_pt2dm_geom_parent srs_id); END-O+#triggerfgsu_pt3dz_geompt3dzCREATE TRIGGER "fgsu_pt3dz_geom" BEFORE UPDATE OF "geom" ON "pt3dz" FOR EACH ROW BEGIN SELECT RAISE (ROLLBACK, 'update of "pt3dz" on "geom" violates constraint: ST_SRID("geom") does not match gpkg_geometry_columns.srs_id value') WHERE (SELECT srs_id FROM gpkg_geometry_columns WHERE Lower(table_name) = Lower('geom') AND Lower(column_name) = Lower('geom') AND ST_SRID(NEW."geom") <> srs_id); END NN@P;9triggerrtree_pt3dz_geom_insertpt3dzCREATE TRIGGER "rtree_pt3dz_geom_insert" AFTER INSERT ON "pt3dz" WHEN (new."geom" NOT NULL AND NOT ST_IsEmpty(NEW."geom")) BEGIN INSERT OR REPLACE INTO "rtree_pt3dz_geom" VALUES (NEW.ROWID, ST_MinX(NEW."geom"), ST_MaxX(NEW."geom"), ST_MinY(NEW."geom"), ST_MaxY(NEW."geom")); ENDfQ=triggerrtree_pt3dz_geom_update1pt3dzCREATE TRIGGER "rtree_pt3dz_geom_update1" AFTER UPDATE OF "geom" ON "pt3dz" WHEN OLD.ROWID = NEW.ROWID AND (NEW."geom" NOT NULL AND NOT ST_IsEmpty(NEW."geom")) BEGIN INSERT OR REPLACE INTO "rtree_pt3dz_geom" VALUES (NEW.ROWID, ST_MinX(NEW."geom"), ST_MaxX(NEW."geom"), ST_MinY(NEW."geom"), ST_MaxY(NEW."geom")); ENDR==triggerrtree_pt3dz_geom_update2pt3dzCREATE TRIGGER "rtree_pt3dz_geom_update2" AFTER UPDATE OF "geom" ON "pt3dz" WHEN OLD.ROWID = NEW.ROWID AND (NEW."geom" IS NULL OR ST_IsEmpty(NEW."geom")) BEGIN DELETE FROM "rtree_pt3dz_geom" WHERE id = OLD.ROWID; END 1<S=otriggerrtree_pt3dz_geom_update3pt3dzCREATE TRIGGER "rtree_pt3dz_geom_update3" AFTER UPDATE OF "geom" ON "pt3dz" WHEN OLD.ROWID != NEW.ROWID AND (NEW."geom" NOT NULL AND NOT ST_IsEmpty(NEW."geom")) BEGIN DELETE FROM "rtree_pt3dz_geom" WHERE id = OLD.ROWID; INSERT OR REPLACE INTO "rtree_pt3dz_geom" VALUES (NEW.ROWID, ST_MinX(NEW."geom"), ST_MaxX(NEW."geom"), ST_MinY(NEW."geom"), ST_MaxY(NEW."geom")); ENDT=Gtriggerrtree_pt3dz_geom_update4pt3dzCREATE TRIGGER "rtree_pt3dz_geom_update4" AFTER UPDATE ON "pt3dz" WHEN OLD.ROWID != NEW.ROWID AND (NEW."geom" IS NULL OR ST_IsEmpty(NEW."geom")) BEGIN DELETE FROM "rtree_pt3dz_geom" WHERE id IN (OLD.ROWID, NEW.ROWID); ENDAU;;triggerrtree_pt3dz_geom_deletept3dzCREATE TRIGGER "rtree_pt3dz_geom_delete" AFTER DELETE ON "pt3dz"WHEN old."geom" NOT NULL BEGIN DELETE FROM "rtree_pt3dz_geom" WHERE id = OLD.ROWID; END 99D ??????@ @ @&ff@&fh@ @ AACc{V--+tablertree_pt3dz_geomrtree_pt3dz_geomCREATE VIRTUAL TABLE "rtree_pt3dz_geom" USING rtree(id, minx, maxx, miny, maxy)W77#tablertree_pt3dz_geom_nodertree_pt3dz_geom_nodeBCREATE TABLE "rtree_pt3dz_geom_node"(nodeno INTEGER PRIMARY KEY, data BLOB) X99-tablertree_pt3dz_geom_rowidrtree_pt3dz_geom_rowidDCREATE TABLE "rtree_pt3dz_geom_rowid"(rowid INTEGER PRIMARY KEY, nodeno INTEGER)Y;;9tablertree_pt3dz_geom_parentrtree_pt3dz_geom_parentECREATE TABLE "rtree_pt3dz_geom_parent"(nodeno INTEGER PRIMARY KEY, parentnode INTEGER)Ztablept3dzmpt3dzmFCREATE TABLE "pt3dzm" ( "id" "INTEGER" NOT NULL, "name" "TEXT" NOT NULL, geom BLOB, CONSTRAINT "pk_pt3dzm" PRIMARY KEY ("id"))     O deltaW&gammaGPffffff@ffffff@ @ @ ffffff@ @@@V&betaGP?? @ @ ? @@@W&alphaGP@@@@ @@&@@ o[-#triggerfgti_pt3dzm_geompt3dzmCREATE TRIGGER "fgti_pt3dzm_geom" BEFORE INSERT ON "pt3dzm" FOR EACH ROW BEGIN SELECT RAISE (ROLLBACK, 'insert on "pt3dzm" violates constraint: ST_GeometryType("geom") is not assignable from gpkg_geometry_columns.geometry_type_name value') WHERE (SELECT geometry_type_name FROM gpkg_geometry_columns WHERE Lower(table_name) = Lower('geom') AND Lower(column_name) = Lower('geom') AND gpkg_IsAssignable(geometry_type_name, ST_GeometryType(NEW."geom")) = 0); END YY_\-Ktriggerfgtu_pt3dzm_geompt3dzmCREATE TRIGGER "fgtu_pt3dzm_geom" BEFORE UPDATE OF "geom" ON "pt3dzm" FOR EACH ROW BEGIN SELECT RAISE (ROLLBACK, 'update of "pt3dzm" on "geom" violates constraint: ST_GeometryType("geom") is not assignable from gpkg_geometry_columns.geometry_type_name value') WHERE (SELECT geometry_type_name FROM gpkg_geometry_columns WHERE Lower(table_name) = Lower('geom') AND Lower(column_name) = Lower('geom') AND gpkg_IsAssignable(geometry_type_name, ST_GeometryType(NEW."geom")) = 0); END]-triggerfgsi_pt3dzm_geompt3dzmCREATE TRIGGER "fgsi_pt3dzm_geom" BEFORE INSERT ON "pt3dzm" FOR EACH ROW BEGIN SELECT RAISE (ROLLBACK, 'insert on "pt3dzm" violates constraint: ST_SRID("geom") does not match gpkg_geometry_columns.srs_id value') WHERE (SELECT srs_id FROM gpkg_geometry_columns WHERE Lower(table_name) = Lower('geom') AND Lower(column_name) = Lower('geom') AND ST_SRID(NEW."geom") <> srs_id); END 2^-)triggerfgsu_pt3dzm_geompt3dzmCREATE TRIGGER "fgsu_pt3dzm_geom" BEFORE UPDATE OF "geom" ON "pt3dzm" FOR EACH ROW BEGIN SELECT RAISE (ROLLBACK, 'update of "pt3dzm" on "geom" violates constraint: ST_SRID("geom") does not match gpkg_geometry_columns.srs_id value') WHERE (SELECT srs_id FROM gpkg_geometry_columns WHERE Lower(table_name) = Lower('geom') AND Lower(column_name) = Lower('geom') AND ST_SRID(NEW."geom") <> srs_id); ENDE_=?triggerrtree_pt3dzm_geom_insertpt3dzmCREATE TRIGGER "rtree_pt3dzm_geom_insert" AFTER INSERT ON "pt3dzm" WHEN (new."geom" NOT NULL AND NOT ST_IsEmpty(NEW."geom")) BEGIN INSERT OR REPLACE INTO "rtree_pt3dzm_geom" VALUES (NEW.ROWID, ST_MinX(NEW."geom"), ST_MaxX(NEW."geom"), ST_MinY(NEW."geom"), ST_MaxY(NEW."geom")); END k`? triggerrtree_pt3dzm_geom_update1pt3dzmCREATE TRIGGER "rtree_pt3dzm_geom_update1" AFTER UPDATE OF "geom" ON "pt3dzm" WHEN OLD.ROWID = NEW.ROWID AND (NEW."geom" NOT NULL AND NOT ST_IsEmpty(NEW."geom")) BEGIN INSERT OR REPLACE INTO "rtree_pt3dzm_geom" VALUES (NEW.ROWID, ST_MinX(NEW."geom"), ST_MaxX(NEW."geom"), ST_MinY(NEW."geom"), ST_MaxY(NEW."geom")); ENDa?Ctriggerrtree_pt3dzm_geom_update2pt3dzmCREATE TRIGGER "rtree_pt3dzm_geom_update2" AFTER UPDATE OF "geom" ON "pt3dzm" WHEN OLD.ROWID = NEW.ROWID AND (NEW."geom" IS NULL OR ST_IsEmpty(NEW."geom")) BEGIN DELETE FROM "rtree_pt3dzm_geom" WHERE id = OLD.ROWID; END '7"b?wtriggerrtree_pt3dzm_geom_update3pt3dzmCREATE TRIGGER "rtree_pt3dzm_geom_update3" AFTER UPDATE OF "geom" ON "pt3dzm" WHEN OLD.ROWID != NEW.ROWID AND (NEW."geom" NOT NULL AND NOT ST_IsEmpty(NEW."geom")) BEGIN DELETE FROM "rtree_pt3dzm_geom" WHERE id = OLD.ROWID; INSERT OR REPLACE INTO "rtree_pt3dzm_geom" VALUES (NEW.ROWID, ST_MinX(NEW."geom"), ST_MaxX(NEW."geom"), ST_MinY(NEW."geom"), ST_MaxY(NEW."geom")); END c?Mtriggerrtree_pt3dzm_geom_update4pt3dzmCREATE TRIGGER "rtree_pt3dzm_geom_update4" AFTER UPDATE ON "pt3dzm" WHEN OLD.ROWID != NEW.ROWID AND (NEW."geom" IS NULL OR ST_IsEmpty(NEW."geom")) BEGIN DELETE FROM "rtree_pt3dzm_geom" WHERE id IN (OLD.ROWID, NEW.ROWID); ENDFd=Atriggerrtree_pt3dzm_geom_deletept3dzmCREATE TRIGGER "rtree_pt3dzm_geom_delete" AFTER DELETE ON "pt3dzm"WHEN old."geom" NOT NULL BEGIN DELETE FROM "rtree_pt3dzm_geom" WHERE id = OLD.ROWID; END ==Ek~e//-tablertree_pt3dzm_geomrtree_pt3dzm_geomCREATE VIRTUAL TABLE "rtree_pt3dzm_geom" USING rtree(id, minx, maxx, miny, maxy)f99%tablertree_pt3dzm_geom_nodertree_pt3dzm_geom_nodeMCREATE TABLE "rtree_pt3dzm_geom_node"(nodeno INTEGER PRIMARY KEY, data BLOB) g;;/tablertree_pt3dzm_geom_rowidrtree_pt3dzm_geom_rowidNCREATE TABLE "rtree_pt3dzm_geom_rowid"(rowid INTEGER PRIMARY KEY, nodeno INTEGER)h==;tablertree_pt3dzm_geom_parentrtree_pt3dzm_geom_parentOCREATE TABLE "rtree_pt3dzm_geom_parent"(nodeno INTEGER PRIMARY KEY, parentnode INTEGER)itableln2dln2dRCREATE TABLE "ln2d" ( "id" "INTEGER" NOT NULL, "name" "TEXT" NOT NULL, geom BLOB, CONSTRAINT "pk_ln2d" PRIMARY KEY ("id")) 99D @&ff@&fh@ @ ??@L@L@33@35@L@L     hW ^dhQ 3U!pt3dzmgeomgpkg_srs_id_triggerGeoPackage 1.0 Specification Annex Nwrite-onlyX AU!pt3dzmgeomgpkg_geometry_type_triggerGeoPackage 1.0 Specification Annex Nwrite-onlyM -U!pt3dzgeomgpkg_rtree_indexGeoPackage 1.0 Specification Annex Lwrite-onlyP3U!pt3dzgeomgpkg_srs_id_triggerGeoPackage 1.0 Specification Annex Nwrite-onlyWAU!pt3dzgeomgpkg_geometry_type_triggerGeoPackage 1.0 Specification Annex Nwrite-onlyM-U!pt2dmgeomgpkg_rtree_indexGeoPackage 1.0 Specification Annex Lwrite-onlyP3U!pt2dmgeomgpkg_srs_id_triggerGeoPackage 1.0 Specification Annex Nwrite-onlyWAU!pt2dmgeomgpkg_geometry_type_triggerGeoPackage 1.0 Specification Annex Nwrite-onlyL-U!pt2dgeomgpkg_rtree_indexGeoPackage 1.0 Specification Annex Lwrite-onlyO3U!pt2dgeomgpkg_srs_id_triggerGeoPackage 1.0 Specification Annex Nwrite-onlyVAU!pt2dgeomgpkg_geometry_type_triggerGeoPackage 1.0 Specification Annex Nwrite-only kX`fkXAU!ln3dzmgeomgpkg_geometry_type_triggerGeoPackage 1.0 Specification Annex Nwrite-onlyM-U!ln3dzgeomgpkg_rtree_indexGeoPackage 1.0 Specification Annex Lwrite-onlyP3U!ln3dzgeomgpkg_srs_id_triggerGeoPackage 1.0 Specification Annex Nwrite-onlyWAU!ln3dzgeomgpkg_geometry_type_triggerGeoPackage 1.0 Specification Annex Nwrite-onlyM-U!ln2dmgeomgpkg_rtree_indexGeoPackage 1.0 Specification Annex Lwrite-onlyP3U!ln2dmgeomgpkg_srs_id_triggerGeoPackage 1.0 Specification Annex Nwrite-onlyWAU!ln2dmgeomgpkg_geometry_type_triggerGeoPackage 1.0 Specification Annex Nwrite-onlyL-U!ln2dgeomgpkg_rtree_indexGeoPackage 1.0 Specification Annex Lwrite-onlyO3U!ln2dgeomgpkg_srs_id_triggerGeoPackage 1.0 Specification Annex Nwrite-onlyV AU!ln2dgeomgpkg_geometry_type_triggerGeoPackage 1.0 Specification Annex Nwrite-onlyN -U!pt3dzmgeomgpkg_rtree_indexGeoPackage 1.0 Specification Annex Lwrite-only 7 delta[.gammaGP????jNbetaGP?$@?$@$@?$@$@?$@[.alphaGP?@?@??@@ ej)triggerfgti_ln2d_geomln2dCREATE TRIGGER "fgti_ln2d_geom" BEFORE INSERT ON "ln2d" FOR EACH ROW BEGIN SELECT RAISE (ROLLBACK, 'insert on "ln2d" violates constraint: ST_GeometryType("geom") is not assignable from gpkg_geometry_columns.geometry_type_name value') WHERE (SELECT geometry_type_name FROM gpkg_geometry_columns WHERE Lower(table_name) = Lower('geom') AND Lower(column_name) = Lower('geom') AND gpkg_IsAssignable(geometry_type_name, ST_GeometryType(NEW."geom")) = 0); ENDyk)?triggerfgtu_ln2d_geomln2dCREATE TRIGGER "fgtu_ln2d_geom" BEFORE UPDATE OF "geom" ON "ln2d" FOR EACH ROW BEGIN SELECT RAISE (ROLLBACK, 'update of "ln2d" on "geom" violates constraint: ST_GeometryType("geom") is not assignable from gpkg_geometry_columns.geometry_type_name value') WHERE (SELECT geometry_type_name FROM gpkg_geometry_columns WHERE Lower(table_name) = Lower('geom') AND Lower(column_name) = Lower('geom') AND gpkg_IsAssignable(geometry_type_name, ST_GeometryType(NEW."geom")) = 0); END Ul)utriggerfgsi_ln2d_geomln2dCREATE TRIGGER "fgsi_ln2d_geom" BEFORE INSERT ON "ln2d" FOR EACH ROW BEGIN SELECT RAISE (ROLLBACK, 'insert on "ln2d" violates constraint: ST_SRID("geom") does not match gpkg_geometry_columns.srs_id value') WHERE (SELECT srs_id FROM gpkg_geometry_columns WHERE Lower(table_name) = Lower('geom') AND Lower(column_name) = Lower('geom') AND ST_SRID(NEW."geom") <> srs_id); END(m)triggerfgsu_ln2d_geomln2dCREATE TRIGGER "fgsu_ln2d_geom" BEFORE UPDATE OF "geom" ON "ln2d" FOR EACH ROW BEGIN SELECT RAISE (ROLLBACK, 'update of "ln2d" on "geom" violates constraint: ST_SRID("geom") does not match gpkg_geometry_columns.srs_id value') WHERE (SELECT srs_id FROM gpkg_geometry_columns WHERE Lower(table_name) = Lower('geom') AND Lower(column_name) = Lower('geom') AND ST_SRID(NEW."geom") <> srs_id); END ]];n93triggerrtree_ln2d_geom_insertln2dCREATE TRIGGER "rtree_ln2d_geom_insert" AFTER INSERT ON "ln2d" WHEN (new."geom" NOT NULL AND NOT ST_IsEmpty(NEW."geom")) BEGIN INSERT OR REPLACE INTO "rtree_ln2d_geom" VALUES (NEW.ROWID, ST_MinX(NEW."geom"), ST_MaxX(NEW."geom"), ST_MinY(NEW."geom"), ST_MaxY(NEW."geom")); ENDao;}triggerrtree_ln2d_geom_update1ln2dCREATE TRIGGER "rtree_ln2d_geom_update1" AFTER UPDATE OF "geom" ON "ln2d" WHEN OLD.ROWID = NEW.ROWID AND (NEW."geom" NOT NULL AND NOT ST_IsEmpty(NEW."geom")) BEGIN INSERT OR REPLACE INTO "rtree_ln2d_geom" VALUES (NEW.ROWID, ST_MinX(NEW."geom"), ST_MaxX(NEW."geom"), ST_MinY(NEW."geom"), ST_MaxY(NEW."geom")); END~p;7triggerrtree_ln2d_geom_update2ln2dCREATE TRIGGER "rtree_ln2d_geom_update2" AFTER UPDATE OF "geom" ON "ln2d" WHEN OLD.ROWID = NEW.ROWID AND (NEW."geom" IS NULL OR ST_IsEmpty(NEW."geom")) BEGIN DELETE FROM "rtree_ln2d_geom" WHERE id = OLD.ROWID; END ;Aq;gtriggerrtree_ln2d_geom_update3ln2dCREATE TRIGGER "rtree_ln2d_geom_update3" AFTER UPDATE OF "geom" ON "ln2d" WHEN OLD.ROWID != NEW.ROWID AND (NEW."geom" NOT NULL AND NOT ST_IsEmpty(NEW."geom")) BEGIN DELETE FROM "rtree_ln2d_geom" WHERE id = OLD.ROWID; INSERT OR REPLACE INTO "rtree_ln2d_geom" VALUES (NEW.ROWID, ST_MinX(NEW."geom"), ST_MaxX(NEW."geom"), ST_MinY(NEW."geom"), ST_MaxY(NEW."geom")); ENDr;Atriggerrtree_ln2d_geom_update4ln2dCREATE TRIGGER "rtree_ln2d_geom_update4" AFTER UPDATE ON "ln2d" WHEN OLD.ROWID != NEW.ROWID AND (NEW."geom" IS NULL OR ST_IsEmpty(NEW."geom")) BEGIN DELETE FROM "rtree_ln2d_geom" WHERE id IN (OLD.ROWID, NEW.ROWID); END srs_id); END-|+#triggerfgsu_ln2dm_geomln2dmCREATE TRIGGER "fgsu_ln2dm_geom" BEFORE UPDATE OF "geom" ON "ln2dm" FOR EACH ROW BEGIN SELECT RAISE (ROLLBACK, 'update of "ln2dm" on "geom" violates constraint: ST_SRID("geom") does not match gpkg_geometry_columns.srs_id value') WHERE (SELECT srs_id FROM gpkg_geometry_columns WHERE Lower(table_name) = Lower('geom') AND Lower(column_name) = Lower('geom') AND ST_SRID(NEW."geom") <> srs_id); END NN@};9triggerrtree_ln2dm_geom_insertln2dmCREATE TRIGGER "rtree_ln2dm_geom_insert" AFTER INSERT ON "ln2dm" WHEN (new."geom" NOT NULL AND NOT ST_IsEmpty(NEW."geom")) BEGIN INSERT OR REPLACE INTO "rtree_ln2dm_geom" VALUES (NEW.ROWID, ST_MinX(NEW."geom"), ST_MaxX(NEW."geom"), ST_MinY(NEW."geom"), ST_MaxY(NEW."geom")); ENDf~=triggerrtree_ln2dm_geom_update1ln2dmCREATE TRIGGER "rtree_ln2dm_geom_update1" AFTER UPDATE OF "geom" ON "ln2dm" WHEN OLD.ROWID = NEW.ROWID AND (NEW."geom" NOT NULL AND NOT ST_IsEmpty(NEW."geom")) BEGIN INSERT OR REPLACE INTO "rtree_ln2dm_geom" VALUES (NEW.ROWID, ST_MinX(NEW."geom"), ST_MaxX(NEW."geom"), ST_MinY(NEW."geom"), ST_MaxY(NEW."geom")); END==triggerrtree_ln2dm_geom_update2ln2dmCREATE TRIGGER "rtree_ln2dm_geom_update2" AFTER UPDATE OF "geom" ON "ln2dm" WHEN OLD.ROWID = NEW.ROWID AND (NEW."geom" IS NULL OR ST_IsEmpty(NEW."geom")) BEGIN DELETE FROM "rtree_ln2dm_geom" WHERE id = OLD.ROWID; END /;=otriggerrtree_ln2dm_geom_update3ln2dmCREATE TRIGGER "rtree_ln2dm_geom_update3" AFTER UPDATE OF "geom" ON "ln2dm" WHEN OLD.ROWID != NEW.ROWID AND (NEW."geom" NOT NULL AND NOT ST_IsEmpty(NEW."geom")) BEGIN DELETE FROM "rtree_ln2dm_geom" WHERE id = OLD.ROWID; INSERT OR REPLACE INTO "rtree_ln2dm_geom" VALUES (NEW.ROWID, ST_MinX(NEW."geom"), ST_MaxX(NEW."geom"), ST_MinY(NEW."geom"), ST_MaxY(NEW."geom")); END=Gtriggerrtree_ln2dm_geom_update4ln2dmCREATE TRIGGER "rtree_ln2dm_geom_update4" AFTER UPDATE ON "ln2dm" WHEN OLD.ROWID != NEW.ROWID AND (NEW."geom" IS NULL OR ST_IsEmpty(NEW."geom")) BEGIN DELETE FROM "rtree_ln2dm_geom" WHERE id IN (OLD.ROWID, NEW.ROWID); ENDA;;triggerrtree_ln2dm_geom_deleteln2dmCREATE TRIGGER "rtree_ln2dm_geom_delete" AFTER DELETE ON "ln2dm"WHEN old."geom" NOT NULL BEGIN DELETE FROM "rtree_ln2dm_geom" WHERE id = OLD.ROWID; END 99D ??@@???? @@Df{--+tablertree_ln2dm_geomrtree_ln2dm_geomCREATE VIRTUAL TABLE "rtree_ln2dm_geom" USING rtree(id, minx, maxx, miny, maxy)77#tablertree_ln2dm_geom_nodertree_ln2dm_geom_node`CREATE TABLE "rtree_ln2dm_geom_node"(nodeno INTEGER PRIMARY KEY, data BLOB) 99-tablertree_ln2dm_geom_rowidrtree_ln2dm_geom_rowidbCREATE TABLE "rtree_ln2dm_geom_rowid"(rowid INTEGER PRIMARY KEY, nodeno INTEGER);;9tablertree_ln2dm_geom_parentrtree_ln2dm_geom_parentcCREATE TABLE "rtree_ln2dm_geom_parent"(nodeno INTEGER PRIMARY KEY, parentnode INTEGER) tableln3dzln3dzdCREATE TABLE "ln3dz" ( "id" "INTEGER" NOT NULL, "name" "TEXT" NOT NULL, geom BLOB, CONSTRAINT "pk_ln3dz" PRIMARY KEY ("id"))      deltakNgammaGP$@$@$@?$@@~betaGP@@@$@@@$@@@ @@$@@kNalphaGP?333333??333333???$@333333?333333?@ j+triggerfgti_ln3dz_geomln3dzCREATE TRIGGER "fgti_ln3dz_geom" BEFORE INSERT ON "ln3dz" FOR EACH ROW BEGIN SELECT RAISE (ROLLBACK, 'insert on "ln3dz" violates constraint: ST_GeometryType("geom") is not assignable from gpkg_geometry_columns.geometry_type_name value') WHERE (SELECT geometry_type_name FROM gpkg_geometry_columns WHERE Lower(table_name) = Lower('geom') AND Lower(column_name) = Lower('geom') AND gpkg_IsAssignable(geometry_type_name, ST_GeometryType(NEW."geom")) = 0); END~ +Etriggerfgtu_ln3dz_geomln3dzCREATE TRIGGER "fgtu_ln3dz_geom" BEFORE UPDATE OF "geom" ON "ln3dz" FOR EACH ROW BEGIN SELECT RAISE (ROLLBACK, 'update of "ln3dz" on "geom" violates constraint: ST_GeometryType("geom") is not assignable from gpkg_geometry_columns.geometry_type_name value') WHERE (SELECT geometry_type_name FROM gpkg_geometry_columns WHERE Lower(table_name) = Lower('geom') AND Lower(column_name) = Lower('geom') AND gpkg_IsAssignable(geometry_type_name, ST_GeometryType(NEW."geom")) = 0); END O +{triggerfgsi_ln3dz_geomln3dzCREATE TRIGGER "fgsi_ln3dz_geom" BEFORE INSERT ON "ln3dz" FOR EACH ROW BEGIN SELECT RAISE (ROLLBACK, 'insert on "ln3dz" violates constraint: ST_SRID("geom") does not match gpkg_geometry_columns.srs_id value') WHERE (SELECT srs_id FROM gpkg_geometry_columns WHERE Lower(table_name) = Lower('geom') AND Lower(column_name) = Lower('geom') AND ST_SRID(NEW."geom") <> srs_id); END- +#triggerfgsu_ln3dz_geomln3dzCREATE TRIGGER "fgsu_ln3dz_geom" BEFORE UPDATE OF "geom" ON "ln3dz" FOR EACH ROW BEGIN SELECT RAISE (ROLLBACK, 'update of "ln3dz" on "geom" violates constraint: ST_SRID("geom") does not match gpkg_geometry_columns.srs_id value') WHERE (SELECT srs_id FROM gpkg_geometry_columns WHERE Lower(table_name) = Lower('geom') AND Lower(column_name) = Lower('geom') AND ST_SRID(NEW."geom") <> srs_id); END KK@ ;9triggerrtree_ln3dz_geom_insertln3dzCREATE TRIGGER "rtree_ln3dz_geom_insert" AFTER INSERT ON "ln3dz" WHEN (new."geom" NOT NULL AND NOT ST_IsEmpty(NEW."geom")) BEGIN INSERT OR REPLACE INTO "rtree_ln3dz_geom" VALUES (NEW.ROWID, ST_MinX(NEW."geom"), ST_MaxX(NEW."geom"), ST_MinY(NEW."geom"), ST_MaxY(NEW."geom")); ENDf =triggerrtree_ln3dz_geom_update1ln3dzCREATE TRIGGER "rtree_ln3dz_geom_update1" AFTER UPDATE OF "geom" ON "ln3dz" WHEN OLD.ROWID = NEW.ROWID AND (NEW."geom" NOT NULL AND NOT ST_IsEmpty(NEW."geom")) BEGIN INSERT OR REPLACE INTO "rtree_ln3dz_geom" VALUES (NEW.ROWID, ST_MinX(NEW."geom"), ST_MaxX(NEW."geom"), ST_MinY(NEW."geom"), ST_MaxY(NEW."geom")); END==triggerrtree_ln3dz_geom_update2ln3dzCREATE TRIGGER "rtree_ln3dz_geom_update2" AFTER UPDATE OF "geom" ON "ln3dz" WHEN OLD.ROWID = NEW.ROWID AND (NEW."geom" IS NULL OR ST_IsEmpty(NEW."geom")) BEGIN DELETE FROM "rtree_ln3dz_geom" WHERE id = OLD.ROWID; END /;=otriggerrtree_ln3dz_geom_update3ln3dzCREATE TRIGGER "rtree_ln3dz_geom_update3" AFTER UPDATE OF "geom" ON "ln3dz" WHEN OLD.ROWID != NEW.ROWID AND (NEW."geom" NOT NULL AND NOT ST_IsEmpty(NEW."geom")) BEGIN DELETE FROM "rtree_ln3dz_geom" WHERE id = OLD.ROWID; INSERT OR REPLACE INTO "rtree_ln3dz_geom" VALUES (NEW.ROWID, ST_MinX(NEW."geom"), ST_MaxX(NEW."geom"), ST_MinY(NEW."geom"), ST_MaxY(NEW."geom")); END=Gtriggerrtree_ln3dz_geom_update4ln3dzCREATE TRIGGER "rtree_ln3dz_geom_update4" AFTER UPDATE ON "ln3dz" WHEN OLD.ROWID != NEW.ROWID AND (NEW."geom" IS NULL OR ST_IsEmpty(NEW."geom")) BEGIN DELETE FROM "rtree_ln3dz_geom" WHERE id IN (OLD.ROWID, NEW.ROWID); ENDA;;triggerrtree_ln3dz_geom_deleteln3dzCREATE TRIGGER "rtree_ln3dz_geom_delete" AFTER DELETE ON "ln3dz"WHEN old."geom" NOT NULL BEGIN DELETE FROM "rtree_ln3dz_geom" WHERE id = OLD.ROWID; END 99D ????@@@A A A <<@b{--+tablertree_ln3dz_geomrtree_ln3dz_geomCREATE VIRTUAL TABLE "rtree_ln3dz_geom" USING rtree(id, minx, maxx, miny, maxy)77#tablertree_ln3dz_geom_nodertree_ln3dz_geom_nodeiCREATE TABLE "rtree_ln3dz_geom_node"(nodeno INTEGER PRIMARY KEY, data BLOB) 99-tablertree_ln3dz_geom_rowidrtree_ln3dz_geom_rowidkCREATE TABLE "rtree_ln3dz_geom_rowid"(rowid INTEGER PRIMARY KEY, nodeno INTEGER);;9tablertree_ln3dz_geom_parentrtree_ln3dz_geom_parentlCREATE TABLE "rtree_ln3dz_geom_parent"(nodeno INTEGER PRIMARY KEY, parentnode INTEGER)tableln3dzmln3dzmmCREATE TABLE "ln3dzm" ( "id" "INTEGER" NOT NULL, "name" "TEXT" NOT NULL, geom BLOB, CONSTRAINT "pk_ln3dzm" PRIMARY KEY ("id"))     ^i^ delta{ngammaGP$@$@ $@?@$@@@.betaGP$@$@ ?@$@@@$@$@@@{nalphaGP$@$@ ?@$@$@@@   o-#triggerfgti_ln3dzm_geomln3dzmCREATE TRIGGER "fgti_ln3dzm_geom" BEFORE INSERT ON "ln3dzm" FOR EACH ROW BEGIN SELECT RAISE (ROLLBACK, 'insert on "ln3dzm" violates constraint: ST_GeometryType("geom") is not assignable from gpkg_geometry_columns.geometry_type_name value') WHERE (SELECT geometry_type_name FROM gpkg_geometry_columns WHERE Lower(table_name) = Lower('geom') AND Lower(column_name) = Lower('geom') AND gpkg_IsAssignable(geometry_type_name, ST_GeometryType(NEW."geom")) = 0); END WW^-Ktriggerfgtu_ln3dzm_geomln3dzmCREATE TRIGGER "fgtu_ln3dzm_geom" BEFORE UPDATE OF "geom" ON "ln3dzm" FOR EACH ROW BEGIN SELECT RAISE (ROLLBACK, 'update of "ln3dzm" on "geom" violates constraint: ST_GeometryType("geom") is not assignable from gpkg_geometry_columns.geometry_type_name value') WHERE (SELECT geometry_type_name FROM gpkg_geometry_columns WHERE Lower(table_name) = Lower('geom') AND Lower(column_name) = Lower('geom') AND gpkg_IsAssignable(geometry_type_name, ST_GeometryType(NEW."geom")) = 0); END-triggerfgsi_ln3dzm_geomln3dzmCREATE TRIGGER "fgsi_ln3dzm_geom" BEFORE INSERT ON "ln3dzm" FOR EACH ROW BEGIN SELECT RAISE (ROLLBACK, 'insert on "ln3dzm" violates constraint: ST_SRID("geom") does not match gpkg_geometry_columns.srs_id value') WHERE (SELECT srs_id FROM gpkg_geometry_columns WHERE Lower(table_name) = Lower('geom') AND Lower(column_name) = Lower('geom') AND ST_SRID(NEW."geom") <> srs_id); END 2-)triggerfgsu_ln3dzm_geomln3dzmCREATE TRIGGER "fgsu_ln3dzm_geom" BEFORE UPDATE OF "geom" ON "ln3dzm" FOR EACH ROW BEGIN SELECT RAISE (ROLLBACK, 'update of "ln3dzm" on "geom" violates constraint: ST_SRID("geom") does not match gpkg_geometry_columns.srs_id value') WHERE (SELECT srs_id FROM gpkg_geometry_columns WHERE Lower(table_name) = Lower('geom') AND Lower(column_name) = Lower('geom') AND ST_SRID(NEW."geom") <> srs_id); ENDE=?triggerrtree_ln3dzm_geom_insertln3dzmCREATE TRIGGER "rtree_ln3dzm_geom_insert" AFTER INSERT ON "ln3dzm" WHEN (new."geom" NOT NULL AND NOT ST_IsEmpty(NEW."geom")) BEGIN INSERT OR REPLACE INTO "rtree_ln3dzm_geom" VALUES (NEW.ROWID, ST_MinX(NEW."geom"), ST_MaxX(NEW."geom"), ST_MinY(NEW."geom"), ST_MaxY(NEW."geom")); END r]f lrM!-U!pg3dzgeomgpkg_rtree_indexGeoPackage 1.0 Specification Annex Lwrite-onlyP 3U!pg3dzgeomgpkg_srs_id_triggerGeoPackage 1.0 Specification Annex Nwrite-onlyWAU!pg3dzgeomgpkg_geometry_type_triggerGeoPackage 1.0 Specification Annex Nwrite-onlyM-U!pg2dmgeomgpkg_rtree_indexGeoPackage 1.0 Specification Annex Lwrite-onlyP3U!pg2dmgeomgpkg_srs_id_triggerGeoPackage 1.0 Specification Annex Nwrite-onlyWAU!pg2dmgeomgpkg_geometry_type_triggerGeoPackage 1.0 Specification Annex Nwrite-onlyL-U!pg2dgeomgpkg_rtree_indexGeoPackage 1.0 Specification Annex Lwrite-onlyO3U!pg2dgeomgpkg_srs_id_triggerGeoPackage 1.0 Specification Annex Nwrite-onlyVAU!pg2dgeomgpkg_geometry_type_triggerGeoPackage 1.0 Specification Annex Nwrite-onlyN-U!ln3dzmgeomgpkg_rtree_indexGeoPackage 1.0 Specification Annex Lwrite-onlyQ3U!ln3dzmgeomgpkg_srs_id_triggerGeoPackage 1.0 Specification Annex Nwrite-only k? triggerrtree_ln3dzm_geom_update1ln3dzmCREATE TRIGGER "rtree_ln3dzm_geom_update1" AFTER UPDATE OF "geom" ON "ln3dzm" WHEN OLD.ROWID = NEW.ROWID AND (NEW."geom" NOT NULL AND NOT ST_IsEmpty(NEW."geom")) BEGIN INSERT OR REPLACE INTO "rtree_ln3dzm_geom" VALUES (NEW.ROWID, ST_MinX(NEW."geom"), ST_MaxX(NEW."geom"), ST_MinY(NEW."geom"), ST_MaxY(NEW."geom")); END?Ctriggerrtree_ln3dzm_geom_update2ln3dzmCREATE TRIGGER "rtree_ln3dzm_geom_update2" AFTER UPDATE OF "geom" ON "ln3dzm" WHEN OLD.ROWID = NEW.ROWID AND (NEW."geom" IS NULL OR ST_IsEmpty(NEW."geom")) BEGIN DELETE FROM "rtree_ln3dzm_geom" WHERE id = OLD.ROWID; END %6"?wtriggerrtree_ln3dzm_geom_update3ln3dzmCREATE TRIGGER "rtree_ln3dzm_geom_update3" AFTER UPDATE OF "geom" ON "ln3dzm" WHEN OLD.ROWID != NEW.ROWID AND (NEW."geom" NOT NULL AND NOT ST_IsEmpty(NEW."geom")) BEGIN DELETE FROM "rtree_ln3dzm_geom" WHERE id = OLD.ROWID; INSERT OR REPLACE INTO "rtree_ln3dzm_geom" VALUES (NEW.ROWID, ST_MinX(NEW."geom"), ST_MaxX(NEW."geom"), ST_MinY(NEW."geom"), ST_MaxY(NEW."geom")); END ?Mtriggerrtree_ln3dzm_geom_update4ln3dzmCREATE TRIGGER "rtree_ln3dzm_geom_update4" AFTER UPDATE ON "ln3dzm" WHEN OLD.ROWID != NEW.ROWID AND (NEW."geom" IS NULL OR ST_IsEmpty(NEW."geom")) BEGIN DELETE FROM "rtree_ln3dzm_geom" WHERE id IN (OLD.ROWID, NEW.ROWID); ENDF =Atriggerrtree_ln3dzm_geom_deleteln3dzmCREATE TRIGGER "rtree_ln3dzm_geom_delete" AFTER DELETE ON "ln3dzm"WHEN old."geom" NOT NULL BEGIN DELETE FROM "rtree_ln3dzm_geom" WHERE id = OLD.ROWID; END 88Bj~!//-tablertree_ln3dzm_geomrtree_ln3dzm_geomCREATE VIRTUAL TABLE "rtree_ln3dzm_geom" USING rtree(id, minx, maxx, miny, maxy)"99%tablertree_ln3dzm_geom_nodertree_ln3dzm_geom_nodeuCREATE TABLE "rtree_ln3dzm_geom_node"(nodeno INTEGER PRIMARY KEY, data BLOB) #;;/tablertree_ln3dzm_geom_rowidrtree_ln3dzm_geom_rowidvCREATE TABLE "rtree_ln3dzm_geom_rowid"(rowid INTEGER PRIMARY KEY, nodeno INTEGER)$==;tablertree_ln3dzm_geom_parentrtree_ln3dzm_geom_parentwCREATE TABLE "rtree_ln3dzm_geom_parent"(nodeno INTEGER PRIMARY KEY, parentnode INTEGER)%tablepg2dpg2dxCREATE TABLE "pg2d" ( "id" "INTEGER" NOT NULL, "name" "TEXT" NOT NULL, geom BLOB, CONSTRAINT "pk_pg2d" PRIMARY KEY ("id")) 99D A A A A A A      n deltaSgammaGP$@.@@$@.@.@@$@@$@(@@*@@*@@(@@~vbetaGP(@*@@@(@@*@@*@@(@@alphaGP?????? e&)triggerfgti_pg2d_geompg2dCREATE TRIGGER "fgti_pg2d_geom" BEFORE INSERT ON "pg2d" FOR EACH ROW BEGIN SELECT RAISE (ROLLBACK, 'insert on "pg2d" violates constraint: ST_GeometryType("geom") is not assignable from gpkg_geometry_columns.geometry_type_name value') WHERE (SELECT geometry_type_name FROM gpkg_geometry_columns WHERE Lower(table_name) = Lower('geom') AND Lower(column_name) = Lower('geom') AND gpkg_IsAssignable(geometry_type_name, ST_GeometryType(NEW."geom")) = 0); ENDy')?triggerfgtu_pg2d_geompg2dCREATE TRIGGER "fgtu_pg2d_geom" BEFORE UPDATE OF "geom" ON "pg2d" FOR EACH ROW BEGIN SELECT RAISE (ROLLBACK, 'update of "pg2d" on "geom" violates constraint: ST_GeometryType("geom") is not assignable from gpkg_geometry_columns.geometry_type_name value') WHERE (SELECT geometry_type_name FROM gpkg_geometry_columns WHERE Lower(table_name) = Lower('geom') AND Lower(column_name) = Lower('geom') AND gpkg_IsAssignable(geometry_type_name, ST_GeometryType(NEW."geom")) = 0); END T()utriggerfgsi_pg2d_geompg2dCREATE TRIGGER "fgsi_pg2d_geom" BEFORE INSERT ON "pg2d" FOR EACH ROW BEGIN SELECT RAISE (ROLLBACK, 'insert on "pg2d" violates constraint: ST_SRID("geom") does not match gpkg_geometry_columns.srs_id value') WHERE (SELECT srs_id FROM gpkg_geometry_columns WHERE Lower(table_name) = Lower('geom') AND Lower(column_name) = Lower('geom') AND ST_SRID(NEW."geom") <> srs_id); END())triggerfgsu_pg2d_geompg2dCREATE TRIGGER "fgsu_pg2d_geom" BEFORE UPDATE OF "geom" ON "pg2d" FOR EACH ROW BEGIN SELECT RAISE (ROLLBACK, 'update of "pg2d" on "geom" violates constraint: ST_SRID("geom") does not match gpkg_geometry_columns.srs_id value') WHERE (SELECT srs_id FROM gpkg_geometry_columns WHERE Lower(table_name) = Lower('geom') AND Lower(column_name) = Lower('geom') AND ST_SRID(NEW."geom") <> srs_id); END ZZ;*93triggerrtree_pg2d_geom_insertpg2dCREATE TRIGGER "rtree_pg2d_geom_insert" AFTER INSERT ON "pg2d" WHEN (new."geom" NOT NULL AND NOT ST_IsEmpty(NEW."geom")) BEGIN INSERT OR REPLACE INTO "rtree_pg2d_geom" VALUES (NEW.ROWID, ST_MinX(NEW."geom"), ST_MaxX(NEW."geom"), ST_MinY(NEW."geom"), ST_MaxY(NEW."geom")); ENDa+;}triggerrtree_pg2d_geom_update1pg2dCREATE TRIGGER "rtree_pg2d_geom_update1" AFTER UPDATE OF "geom" ON "pg2d" WHEN OLD.ROWID = NEW.ROWID AND (NEW."geom" NOT NULL AND NOT ST_IsEmpty(NEW."geom")) BEGIN INSERT OR REPLACE INTO "rtree_pg2d_geom" VALUES (NEW.ROWID, ST_MinX(NEW."geom"), ST_MaxX(NEW."geom"), ST_MinY(NEW."geom"), ST_MaxY(NEW."geom")); END~,;7triggerrtree_pg2d_geom_update2pg2dCREATE TRIGGER "rtree_pg2d_geom_update2" AFTER UPDATE OF "geom" ON "pg2d" WHEN OLD.ROWID = NEW.ROWID AND (NEW."geom" IS NULL OR ST_IsEmpty(NEW."geom")) BEGIN DELETE FROM "rtree_pg2d_geom" WHERE id = OLD.ROWID; END 9@-;gtriggerrtree_pg2d_geom_update3pg2dCREATE TRIGGER "rtree_pg2d_geom_update3" AFTER UPDATE OF "geom" ON "pg2d" WHEN OLD.ROWID != NEW.ROWID AND (NEW."geom" NOT NULL AND NOT ST_IsEmpty(NEW."geom")) BEGIN DELETE FROM "rtree_pg2d_geom" WHERE id = OLD.ROWID; INSERT OR REPLACE INTO "rtree_pg2d_geom" VALUES (NEW.ROWID, ST_MinX(NEW."geom"), ST_MaxX(NEW."geom"), ST_MinY(NEW."geom"), ST_MaxY(NEW."geom")); END.;Atriggerrtree_pg2d_geom_update4pg2dCREATE TRIGGER "rtree_pg2d_geom_update4" AFTER UPDATE ON "pg2d" WHEN OLD.ROWID != NEW.ROWID AND (NEW."geom" IS NULL OR ST_IsEmpty(NEW."geom")) BEGIN DELETE FROM "rtree_pg2d_geom" WHERE id IN (OLD.ROWID, NEW.ROWID); END srs_id); END-8+#triggerfgsu_pg2dm_geompg2dmCREATE TRIGGER "fgsu_pg2dm_geom" BEFORE UPDATE OF "geom" ON "pg2dm" FOR EACH ROW BEGIN SELECT RAISE (ROLLBACK, 'update of "pg2dm" on "geom" violates constraint: ST_SRID("geom") does not match gpkg_geometry_columns.srs_id value') WHERE (SELECT srs_id FROM gpkg_geometry_columns WHERE Lower(table_name) = Lower('geom') AND Lower(column_name) = Lower('geom') AND ST_SRID(NEW."geom") <> srs_id); END KK@9;9triggerrtree_pg2dm_geom_insertpg2dmCREATE TRIGGER "rtree_pg2dm_geom_insert" AFTER INSERT ON "pg2dm" WHEN (new."geom" NOT NULL AND NOT ST_IsEmpty(NEW."geom")) BEGIN INSERT OR REPLACE INTO "rtree_pg2dm_geom" VALUES (NEW.ROWID, ST_MinX(NEW."geom"), ST_MaxX(NEW."geom"), ST_MinY(NEW."geom"), ST_MaxY(NEW."geom")); ENDf:=triggerrtree_pg2dm_geom_update1pg2dmCREATE TRIGGER "rtree_pg2dm_geom_update1" AFTER UPDATE OF "geom" ON "pg2dm" WHEN OLD.ROWID = NEW.ROWID AND (NEW."geom" NOT NULL AND NOT ST_IsEmpty(NEW."geom")) BEGIN INSERT OR REPLACE INTO "rtree_pg2dm_geom" VALUES (NEW.ROWID, ST_MinX(NEW."geom"), ST_MaxX(NEW."geom"), ST_MinY(NEW."geom"), ST_MaxY(NEW."geom")); END;==triggerrtree_pg2dm_geom_update2pg2dmCREATE TRIGGER "rtree_pg2dm_geom_update2" AFTER UPDATE OF "geom" ON "pg2dm" WHEN OLD.ROWID = NEW.ROWID AND (NEW."geom" IS NULL OR ST_IsEmpty(NEW."geom")) BEGIN DELETE FROM "rtree_pg2dm_geom" WHERE id = OLD.ROWID; END /;<=otriggerrtree_pg2dm_geom_update3pg2dmCREATE TRIGGER "rtree_pg2dm_geom_update3" AFTER UPDATE OF "geom" ON "pg2dm" WHEN OLD.ROWID != NEW.ROWID AND (NEW."geom" NOT NULL AND NOT ST_IsEmpty(NEW."geom")) BEGIN DELETE FROM "rtree_pg2dm_geom" WHERE id = OLD.ROWID; INSERT OR REPLACE INTO "rtree_pg2dm_geom" VALUES (NEW.ROWID, ST_MinX(NEW."geom"), ST_MaxX(NEW."geom"), ST_MinY(NEW."geom"), ST_MaxY(NEW."geom")); END==Gtriggerrtree_pg2dm_geom_update4pg2dmCREATE TRIGGER "rtree_pg2dm_geom_update4" AFTER UPDATE ON "pg2dm" WHEN OLD.ROWID != NEW.ROWID AND (NEW."geom" IS NULL OR ST_IsEmpty(NEW."geom")) BEGIN DELETE FROM "rtree_pg2dm_geom" WHERE id IN (OLD.ROWID, NEW.ROWID); ENDA>;;triggerrtree_pg2dm_geom_deletepg2dmCREATE TRIGGER "rtree_pg2dm_geom_delete" AFTER DELETE ON "pg2dm"WHEN old."geom" NOT NULL BEGIN DELETE FROM "rtree_pg2dm_geom" WHERE id = OLD.ROWID; END 99D ??A@AP@@@A Ap@ <<Ae{?--+tablertree_pg2dm_geomrtree_pg2dm_geomCREATE VIRTUAL TABLE "rtree_pg2dm_geom" USING rtree(id, minx, maxx, miny, maxy)@77#tablertree_pg2dm_geom_nodertree_pg2dm_geom_nodeCREATE TABLE "rtree_pg2dm_geom_node"(nodeno INTEGER PRIMARY KEY, data BLOB) A99-tablertree_pg2dm_geom_rowidrtree_pg2dm_geom_rowidCREATE TABLE "rtree_pg2dm_geom_rowid"(rowid INTEGER PRIMARY KEY, nodeno INTEGER)B;;9tablertree_pg2dm_geom_parentrtree_pg2dm_geom_parentCREATE TABLE "rtree_pg2dm_geom_parent"(nodeno INTEGER PRIMARY KEY, parentnode INTEGER)C tablepg3dzpg3dzCREATE TABLE "pg3dz" ( "id" "INTEGER" NOT NULL, "name" "TEXT" NOT NULL, geom BLOB, CONSTRAINT "pk_pg3dz" PRIMARY KEY ("id"))     |F| delta.gammaGP$@.@@$@@.@@.@@@$@@ @$@@(@@@*@@@*@@@(@@@6betaGP(@*@@@(@@@*@@@*@@ @(@@@7falphaGP??@?@??@?@@ jD+triggerfgti_pg3dz_geompg3dzCREATE TRIGGER "fgti_pg3dz_geom" BEFORE INSERT ON "pg3dz" FOR EACH ROW BEGIN SELECT RAISE (ROLLBACK, 'insert on "pg3dz" violates constraint: ST_GeometryType("geom") is not assignable from gpkg_geometry_columns.geometry_type_name value') WHERE (SELECT geometry_type_name FROM gpkg_geometry_columns WHERE Lower(table_name) = Lower('geom') AND Lower(column_name) = Lower('geom') AND gpkg_IsAssignable(geometry_type_name, ST_GeometryType(NEW."geom")) = 0); END~E+Etriggerfgtu_pg3dz_geompg3dzCREATE TRIGGER "fgtu_pg3dz_geom" BEFORE UPDATE OF "geom" ON "pg3dz" FOR EACH ROW BEGIN SELECT RAISE (ROLLBACK, 'update of "pg3dz" on "geom" violates constraint: ST_GeometryType("geom") is not assignable from gpkg_geometry_columns.geometry_type_name value') WHERE (SELECT geometry_type_name FROM gpkg_geometry_columns WHERE Lower(table_name) = Lower('geom') AND Lower(column_name) = Lower('geom') AND gpkg_IsAssignable(geometry_type_name, ST_GeometryType(NEW."geom")) = 0); END OF+{triggerfgsi_pg3dz_geompg3dzCREATE TRIGGER "fgsi_pg3dz_geom" BEFORE INSERT ON "pg3dz" FOR EACH ROW BEGIN SELECT RAISE (ROLLBACK, 'insert on "pg3dz" violates constraint: ST_SRID("geom") does not match gpkg_geometry_columns.srs_id value') WHERE (SELECT srs_id FROM gpkg_geometry_columns WHERE Lower(table_name) = Lower('geom') AND Lower(column_name) = Lower('geom') AND ST_SRID(NEW."geom") <> srs_id); END-G+#triggerfgsu_pg3dz_geompg3dzCREATE TRIGGER "fgsu_pg3dz_geom" BEFORE UPDATE OF "geom" ON "pg3dz" FOR EACH ROW BEGIN SELECT RAISE (ROLLBACK, 'update of "pg3dz" on "geom" violates constraint: ST_SRID("geom") does not match gpkg_geometry_columns.srs_id value') WHERE (SELECT srs_id FROM gpkg_geometry_columns WHERE Lower(table_name) = Lower('geom') AND Lower(column_name) = Lower('geom') AND ST_SRID(NEW."geom") <> srs_id); END KK@H;9triggerrtree_pg3dz_geom_insertpg3dzCREATE TRIGGER "rtree_pg3dz_geom_insert" AFTER INSERT ON "pg3dz" WHEN (new."geom" NOT NULL AND NOT ST_IsEmpty(NEW."geom")) BEGIN INSERT OR REPLACE INTO "rtree_pg3dz_geom" VALUES (NEW.ROWID, ST_MinX(NEW."geom"), ST_MaxX(NEW."geom"), ST_MinY(NEW."geom"), ST_MaxY(NEW."geom")); ENDfI=triggerrtree_pg3dz_geom_update1pg3dzCREATE TRIGGER "rtree_pg3dz_geom_update1" AFTER UPDATE OF "geom" ON "pg3dz" WHEN OLD.ROWID = NEW.ROWID AND (NEW."geom" NOT NULL AND NOT ST_IsEmpty(NEW."geom")) BEGIN INSERT OR REPLACE INTO "rtree_pg3dz_geom" VALUES (NEW.ROWID, ST_MinX(NEW."geom"), ST_MaxX(NEW."geom"), ST_MinY(NEW."geom"), ST_MaxY(NEW."geom")); ENDJ==triggerrtree_pg3dz_geom_update2pg3dzCREATE TRIGGER "rtree_pg3dz_geom_update2" AFTER UPDATE OF "geom" ON "pg3dz" WHEN OLD.ROWID = NEW.ROWID AND (NEW."geom" IS NULL OR ST_IsEmpty(NEW."geom")) BEGIN DELETE FROM "rtree_pg3dz_geom" WHERE id = OLD.ROWID; END /;K=otriggerrtree_pg3dz_geom_update3pg3dzCREATE TRIGGER "rtree_pg3dz_geom_update3" AFTER UPDATE OF "geom" ON "pg3dz" WHEN OLD.ROWID != NEW.ROWID AND (NEW."geom" NOT NULL AND NOT ST_IsEmpty(NEW."geom")) BEGIN DELETE FROM "rtree_pg3dz_geom" WHERE id = OLD.ROWID; INSERT OR REPLACE INTO "rtree_pg3dz_geom" VALUES (NEW.ROWID, ST_MinX(NEW."geom"), ST_MaxX(NEW."geom"), ST_MinY(NEW."geom"), ST_MaxY(NEW."geom")); ENDL=Gtriggerrtree_pg3dz_geom_update4pg3dzCREATE TRIGGER "rtree_pg3dz_geom_update4" AFTER UPDATE ON "pg3dz" WHEN OLD.ROWID != NEW.ROWID AND (NEW."geom" IS NULL OR ST_IsEmpty(NEW."geom")) BEGIN DELETE FROM "rtree_pg3dz_geom" WHERE id IN (OLD.ROWID, NEW.ROWID); ENDAM;;triggerrtree_pg3dz_geom_deletepg3dzCREATE TRIGGER "rtree_pg3dz_geom_delete" AFTER DELETE ON "pg3dz"WHEN old."geom" NOT NULL BEGIN DELETE FROM "rtree_pg3dz_geom" WHERE id = OLD.ROWID; END 99D ??A@AP@@@A Ap@ 88=a{N--+tablertree_pg3dz_geomrtree_pg3dz_geomCREATE VIRTUAL TABLE "rtree_pg3dz_geom" USING rtree(id, minx, maxx, miny, maxy)O77#tablertree_pg3dz_geom_nodertree_pg3dz_geom_nodeCREATE TABLE "rtree_pg3dz_geom_node"(nodeno INTEGER PRIMARY KEY, data BLOB) P99-tablertree_pg3dz_geom_rowidrtree_pg3dz_geom_rowidCREATE TABLE "rtree_pg3dz_geom_rowid"(rowid INTEGER PRIMARY KEY, nodeno INTEGER)Q;;9tablertree_pg3dz_geom_parentrtree_pg3dz_geom_parentCREATE TABLE "rtree_pg3dz_geom_parent"(nodeno INTEGER PRIMARY KEY, parentnode INTEGER)Rtablepg3dzmpg3dzmCREATE TABLE "pg3dzm" ( "id" "INTEGER" NOT NULL, "name" "TEXT" NOT NULL, geom BLOB, CONSTRAINT "pk_pg3dzm" PRIMARY KEY ("id"))     ] deltac>gammaGP$@.@@ $@@@.@@@.@@@@$@@ @@$@@@(@@@@*@@@@*@@@@(@@@@>vbetaGP(@*@@@ (@@@@*@@@@*@@ @@(@@@@_6alphaGP?? @@?@@??@@?@@@@   oS-#triggerfgti_pg3dzm_geompg3dzmCREATE TRIGGER "fgti_pg3dzm_geom" BEFORE INSERT ON "pg3dzm" FOR EACH ROW BEGIN SELECT RAISE (ROLLBACK, 'insert on "pg3dzm" violates constraint: ST_GeometryType("geom") is not assignable from gpkg_geometry_columns.geometry_type_name value') WHERE (SELECT geometry_type_name FROM gpkg_geometry_columns WHERE Lower(table_name) = Lower('geom') AND Lower(column_name) = Lower('geom') AND gpkg_IsAssignable(geometry_type_name, ST_GeometryType(NEW."geom")) = 0); END WW^T-Ktriggerfgtu_pg3dzm_geompg3dzmCREATE TRIGGER "fgtu_pg3dzm_geom" BEFORE UPDATE OF "geom" ON "pg3dzm" FOR EACH ROW BEGIN SELECT RAISE (ROLLBACK, 'update of "pg3dzm" on "geom" violates constraint: ST_GeometryType("geom") is not assignable from gpkg_geometry_columns.geometry_type_name value') WHERE (SELECT geometry_type_name FROM gpkg_geometry_columns WHERE Lower(table_name) = Lower('geom') AND Lower(column_name) = Lower('geom') AND gpkg_IsAssignable(geometry_type_name, ST_GeometryType(NEW."geom")) = 0); ENDU-triggerfgsi_pg3dzm_geompg3dzmCREATE TRIGGER "fgsi_pg3dzm_geom" BEFORE INSERT ON "pg3dzm" FOR EACH ROW BEGIN SELECT RAISE (ROLLBACK, 'insert on "pg3dzm" violates constraint: ST_SRID("geom") does not match gpkg_geometry_columns.srs_id value') WHERE (SELECT srs_id FROM gpkg_geometry_columns WHERE Lower(table_name) = Lower('geom') AND Lower(column_name) = Lower('geom') AND ST_SRID(NEW."geom") <> srs_id); END 2V-)triggerfgsu_pg3dzm_geompg3dzmCREATE TRIGGER "fgsu_pg3dzm_geom" BEFORE UPDATE OF "geom" ON "pg3dzm" FOR EACH ROW BEGIN SELECT RAISE (ROLLBACK, 'update of "pg3dzm" on "geom" violates constraint: ST_SRID("geom") does not match gpkg_geometry_columns.srs_id value') WHERE (SELECT srs_id FROM gpkg_geometry_columns WHERE Lower(table_name) = Lower('geom') AND Lower(column_name) = Lower('geom') AND ST_SRID(NEW."geom") <> srs_id); ENDEW=?triggerrtree_pg3dzm_geom_insertpg3dzmCREATE TRIGGER "rtree_pg3dzm_geom_insert" AFTER INSERT ON "pg3dzm" WHEN (new."geom" NOT NULL AND NOT ST_IsEmpty(NEW."geom")) BEGIN INSERT OR REPLACE INTO "rtree_pg3dzm_geom" VALUES (NEW.ROWID, ST_MinX(NEW."geom"), ST_MaxX(NEW."geom"), ST_MinY(NEW."geom"), ST_MaxY(NEW."geom")); END YSTVYQ,3U!mpg2dmgeomgpkg_srs_id_triggerGeoPackage 1.0 Specification Annex Nwrite-onlyX+AU!mpg2dmgeomgpkg_geometry_type_triggerGeoPackage 1.0 Specification Annex Nwrite-onlyN*-U!mpg3dzgeomgpkg_rtree_indexGeoPackage 1.0 Specification Annex Lwrite-onlyQ)3U!mpg3dzgeomgpkg_srs_id_triggerGeoPackage 1.0 Specification Annex Nwrite-onlyX(AU!mpg3dzgeomgpkg_geometry_type_triggerGeoPackage 1.0 Specification Annex Nwrite-onlyO'-U!mpg3dzmgeomgpkg_rtree_indexGeoPackage 1.0 Specification Annex Lwrite-onlyR&3U!mpg3dzmgeomgpkg_srs_id_triggerGeoPackage 1.0 Specification Annex Nwrite-onlyY%AU!mpg3dzmgeomgpkg_geometry_type_triggerGeoPackage 1.0 Specification Annex Nwrite-onlyN$-U!pg3dzmgeomgpkg_rtree_indexGeoPackage 1.0 Specification Annex Lwrite-onlyQ#3U!pg3dzmgeomgpkg_srs_id_triggerGeoPackage 1.0 Specification Annex Nwrite-onlyX"AU!pg3dzmgeomgpkg_geometry_type_triggerGeoPackage 1.0 Specification Annex Nwrite-only kX? triggerrtree_pg3dzm_geom_update1pg3dzmCREATE TRIGGER "rtree_pg3dzm_geom_update1" AFTER UPDATE OF "geom" ON "pg3dzm" WHEN OLD.ROWID = NEW.ROWID AND (NEW."geom" NOT NULL AND NOT ST_IsEmpty(NEW."geom")) BEGIN INSERT OR REPLACE INTO "rtree_pg3dzm_geom" VALUES (NEW.ROWID, ST_MinX(NEW."geom"), ST_MaxX(NEW."geom"), ST_MinY(NEW."geom"), ST_MaxY(NEW."geom")); ENDY?Ctriggerrtree_pg3dzm_geom_update2pg3dzmCREATE TRIGGER "rtree_pg3dzm_geom_update2" AFTER UPDATE OF "geom" ON "pg3dzm" WHEN OLD.ROWID = NEW.ROWID AND (NEW."geom" IS NULL OR ST_IsEmpty(NEW."geom")) BEGIN DELETE FROM "rtree_pg3dzm_geom" WHERE id = OLD.ROWID; END %6"Z?wtriggerrtree_pg3dzm_geom_update3pg3dzmCREATE TRIGGER "rtree_pg3dzm_geom_update3" AFTER UPDATE OF "geom" ON "pg3dzm" WHEN OLD.ROWID != NEW.ROWID AND (NEW."geom" NOT NULL AND NOT ST_IsEmpty(NEW."geom")) BEGIN DELETE FROM "rtree_pg3dzm_geom" WHERE id = OLD.ROWID; INSERT OR REPLACE INTO "rtree_pg3dzm_geom" VALUES (NEW.ROWID, ST_MinX(NEW."geom"), ST_MaxX(NEW."geom"), ST_MinY(NEW."geom"), ST_MaxY(NEW."geom")); END [?Mtriggerrtree_pg3dzm_geom_update4pg3dzmCREATE TRIGGER "rtree_pg3dzm_geom_update4" AFTER UPDATE ON "pg3dzm" WHEN OLD.ROWID != NEW.ROWID AND (NEW."geom" IS NULL OR ST_IsEmpty(NEW."geom")) BEGIN DELETE FROM "rtree_pg3dzm_geom" WHERE id IN (OLD.ROWID, NEW.ROWID); ENDF\=Atriggerrtree_pg3dzm_geom_deletepg3dzmCREATE TRIGGER "rtree_pg3dzm_geom_delete" AFTER DELETE ON "pg3dzm"WHEN old."geom" NOT NULL BEGIN DELETE FROM "rtree_pg3dzm_geom" WHERE id = OLD.ROWID; END ((3]~]//-tablertree_pg3dzm_geomrtree_pg3dzm_geomCREATE VIRTUAL TABLE "rtree_pg3dzm_geom" USING rtree(id, minx, maxx, miny, maxy)^99%tablertree_pg3dzm_geom_nodertree_pg3dzm_geom_nodeCREATE TABLE "rtree_pg3dzm_geom_node"(nodeno INTEGER PRIMARY KEY, data BLOB) _;;/tablertree_pg3dzm_geom_rowidrtree_pg3dzm_geom_rowidCREATE TABLE "rtree_pg3dzm_geom_rowid"(rowid INTEGER PRIMARY KEY, nodeno INTEGER)`==;tablertree_pg3dzm_geom_parentrtree_pg3dzm_geom_parentCREATE TABLE "rtree_pg3dzm_geom_parent"(nodeno INTEGER PRIMARY KEY, parentnode INTEGER)atablempg3dzmmpg3dzmCREATE TABLE "mpg3dzm" ( "id" "INTEGER" NOT NULL, "name" "TEXT" NOT NULL, geom BLOB, CONSTRAINT "pk_mpg3dzm" PRIMARY KEY ("id")) 99D ??A@AP@@@A Ap@      deltaHgammaGP?@@@?@@@  ?@?@@@@@?@@@?@@@@@?@?@@@GbetaGP5@6@5@6@  5@5@@@6@5@@@5@6@@@5@5@@@U"alphaGP4@?@4@?@  4@4@@@5@4@@@4@5@@@4@4@@@ >@>@@@?@>@@@>@?@@@>@>@@@ tb/)triggerfgti_mpg3dzm_geommpg3dzmCREATE TRIGGER "fgti_mpg3dzm_geom" BEFORE INSERT ON "mpg3dzm" FOR EACH ROW BEGIN SELECT RAISE (ROLLBACK, 'insert on "mpg3dzm" violates constraint: ST_GeometryType("geom") is not assignable from gpkg_geometry_columns.geometry_type_name value') WHERE (SELECT geometry_type_name FROM gpkg_geometry_columns WHERE Lower(table_name) = Lower('geom') AND Lower(column_name) = Lower('geom') AND gpkg_IsAssignable(geometry_type_name, ST_GeometryType(NEW."geom")) = 0); END MMYc/Qtriggerfgtu_mpg3dzm_geommpg3dzmCREATE TRIGGER "fgtu_mpg3dzm_geom" BEFORE UPDATE OF "geom" ON "mpg3dzm" FOR EACH ROW BEGIN SELECT RAISE (ROLLBACK, 'update of "mpg3dzm" on "geom" violates constraint: ST_GeometryType("geom") is not assignable from gpkg_geometry_columns.geometry_type_name value') WHERE (SELECT geometry_type_name FROM gpkg_geometry_columns WHERE Lower(table_name) = Lower('geom') AND Lower(column_name) = Lower('geom') AND gpkg_IsAssignable(geometry_type_name, ST_GeometryType(NEW."geom")) = 0); END#d/triggerfgsi_mpg3dzm_geommpg3dzmCREATE TRIGGER "fgsi_mpg3dzm_geom" BEFORE INSERT ON "mpg3dzm" FOR EACH ROW BEGIN SELECT RAISE (ROLLBACK, 'insert on "mpg3dzm" violates constraint: ST_SRID("geom") does not match gpkg_geometry_columns.srs_id value') WHERE (SELECT srs_id FROM gpkg_geometry_columns WHERE Lower(table_name) = Lower('geom') AND Lower(column_name) = Lower('geom') AND ST_SRID(NEW."geom") <> srs_id); END 7e//triggerfgsu_mpg3dzm_geommpg3dzmCREATE TRIGGER "fgsu_mpg3dzm_geom" BEFORE UPDATE OF "geom" ON "mpg3dzm" FOR EACH ROW BEGIN SELECT RAISE (ROLLBACK, 'update of "mpg3dzm" on "geom" violates constraint: ST_SRID("geom") does not match gpkg_geometry_columns.srs_id value') WHERE (SELECT srs_id FROM gpkg_geometry_columns WHERE Lower(table_name) = Lower('geom') AND Lower(column_name) = Lower('geom') AND ST_SRID(NEW."geom") <> srs_id); ENDJf?Etriggerrtree_mpg3dzm_geom_insertmpg3dzmCREATE TRIGGER "rtree_mpg3dzm_geom_insert" AFTER INSERT ON "mpg3dzm" WHEN (new."geom" NOT NULL AND NOT ST_IsEmpty(NEW."geom")) BEGIN INSERT OR REPLACE INTO "rtree_mpg3dzm_geom" VALUES (NEW.ROWID, ST_MinX(NEW."geom"), ST_MaxX(NEW."geom"), ST_MinY(NEW."geom"), ST_MaxY(NEW."geom")); END {{pgAtriggerrtree_mpg3dzm_geom_update1mpg3dzmCREATE TRIGGER "rtree_mpg3dzm_geom_update1" AFTER UPDATE OF "geom" ON "mpg3dzm" WHEN OLD.ROWID = NEW.ROWID AND (NEW."geom" NOT NULL AND NOT ST_IsEmpty(NEW."geom")) BEGIN INSERT OR REPLACE INTO "rtree_mpg3dzm_geom" VALUES (NEW.ROWID, ST_MinX(NEW."geom"), ST_MaxX(NEW."geom"), ST_MinY(NEW."geom"), ST_MaxY(NEW."geom")); END hAItriggerrtree_mpg3dzm_geom_update2mpg3dzmCREATE TRIGGER "rtree_mpg3dzm_geom_update2" AFTER UPDATE OF "geom" ON "mpg3dzm" WHEN OLD.ROWID = NEW.ROWID AND (NEW."geom" IS NULL OR ST_IsEmpty(NEW."geom")) BEGIN DELETE FROM "rtree_mpg3dzm_geom" WHERE id = OLD.ROWID; END oo1(iAtriggerrtree_mpg3dzm_geom_update3mpg3dzmCREATE TRIGGER "rtree_mpg3dzm_geom_update3" AFTER UPDATE OF "geom" ON "mpg3dzm" WHEN OLD.ROWID != NEW.ROWID AND (NEW."geom" NOT NULL AND NOT ST_IsEmpty(NEW."geom")) BEGIN DELETE FROM "rtree_mpg3dzm_geom" WHERE id = OLD.ROWID; INSERT OR REPLACE INTO "rtree_mpg3dzm_geom" VALUES (NEW.ROWID, ST_MinX(NEW."geom"), ST_MaxX(NEW."geom"), ST_MinY(NEW."geom"), ST_MaxY(NEW."geom")); ENDjAStriggerrtree_mpg3dzm_geom_update4mpg3dzmCREATE TRIGGER "rtree_mpg3dzm_geom_update4" AFTER UPDATE ON "mpg3dzm" WHEN OLD.ROWID != NEW.ROWID AND (NEW."geom" IS NULL OR ST_IsEmpty(NEW."geom")) BEGIN DELETE FROM "rtree_mpg3dzm_geom" WHERE id IN (OLD.ROWID, NEW.ROWID); ENDKk?Gtriggerrtree_mpg3dzm_geom_deletempg3dzmCREATE TRIGGER "rtree_mpg3dzm_geom_delete" AFTER DELETE ON "mpg3dzm"WHEN old."geom" NOT NULL BEGIN DELETE FROM "rtree_mpg3dzm_geom" WHERE id = OLD.ROWID; END 1al11/tablertree_mpg3dzm_geomrtree_mpg3dzm_geomCREATE VIRTUAL TABLE "rtree_mpg3dzm_geom" USING rtree(id, minx, maxx, miny, maxy) m;;'tablertree_mpg3dzm_geom_nodertree_mpg3dzm_geom_nodeCREATE TABLE "rtree_mpg3dzm_geom_node"(nodeno INTEGER PRIMARY KEY, data BLOB)n==1tablertree_mpg3dzm_geom_rowidrtree_mpg3dzm_geom_rowidCREATE TABLE "rtree_mpg3dzm_geom_rowid"(rowid INTEGER PRIMARY KEY, nodeno INTEGER)o??=tablertree_mpg3dzm_geom_parentrtree_mpg3dzm_geom_parentCREATE TABLE "rtree_mpg3dzm_geom_parent"(nodeno INTEGER PRIMARY KEY, parentnode INTEGER)ptablempg3dzmpg3dzCREATE TABLE "mpg3dz" ( "id" "INTEGER" NOT NULL, "name" "TEXT" NOT NULL, geom BLOB, CONSTRAINT "pk_mpg3dz" PRIMARY KEY ("id")) 99D AAAAAAAAABAB     > delta(HgammaGP?@@@?@@@?@?@@@@?@@?@@@@?@?@@'HbetaGP5@6@5@6@5@5@@6@5@@5@6@@5@5@@"alphaGP4@?@4@?@4@4@@5@4@@4@5@@4@4@@>@>@@?@>@@>@?@@>@>@@   oq-#triggerfgti_mpg3dz_geommpg3dzCREATE TRIGGER "fgti_mpg3dz_geom" BEFORE INSERT ON "mpg3dz" FOR EACH ROW BEGIN SELECT RAISE (ROLLBACK, 'insert on "mpg3dz" violates constraint: ST_GeometryType("geom") is not assignable from gpkg_geometry_columns.geometry_type_name value') WHERE (SELECT geometry_type_name FROM gpkg_geometry_columns WHERE Lower(table_name) = Lower('geom') AND Lower(column_name) = Lower('geom') AND gpkg_IsAssignable(geometry_type_name, ST_GeometryType(NEW."geom")) = 0); END WW^r-Ktriggerfgtu_mpg3dz_geommpg3dzCREATE TRIGGER "fgtu_mpg3dz_geom" BEFORE UPDATE OF "geom" ON "mpg3dz" FOR EACH ROW BEGIN SELECT RAISE (ROLLBACK, 'update of "mpg3dz" on "geom" violates constraint: ST_GeometryType("geom") is not assignable from gpkg_geometry_columns.geometry_type_name value') WHERE (SELECT geometry_type_name FROM gpkg_geometry_columns WHERE Lower(table_name) = Lower('geom') AND Lower(column_name) = Lower('geom') AND gpkg_IsAssignable(geometry_type_name, ST_GeometryType(NEW."geom")) = 0); ENDs-triggerfgsi_mpg3dz_geommpg3dzCREATE TRIGGER "fgsi_mpg3dz_geom" BEFORE INSERT ON "mpg3dz" FOR EACH ROW BEGIN SELECT RAISE (ROLLBACK, 'insert on "mpg3dz" violates constraint: ST_SRID("geom") does not match gpkg_geometry_columns.srs_id value') WHERE (SELECT srs_id FROM gpkg_geometry_columns WHERE Lower(table_name) = Lower('geom') AND Lower(column_name) = Lower('geom') AND ST_SRID(NEW."geom") <> srs_id); END 2t-)triggerfgsu_mpg3dz_geommpg3dzCREATE TRIGGER "fgsu_mpg3dz_geom" BEFORE UPDATE OF "geom" ON "mpg3dz" FOR EACH ROW BEGIN SELECT RAISE (ROLLBACK, 'update of "mpg3dz" on "geom" violates constraint: ST_SRID("geom") does not match gpkg_geometry_columns.srs_id value') WHERE (SELECT srs_id FROM gpkg_geometry_columns WHERE Lower(table_name) = Lower('geom') AND Lower(column_name) = Lower('geom') AND ST_SRID(NEW."geom") <> srs_id); ENDEu=?triggerrtree_mpg3dz_geom_insertmpg3dzCREATE TRIGGER "rtree_mpg3dz_geom_insert" AFTER INSERT ON "mpg3dz" WHEN (new."geom" NOT NULL AND NOT ST_IsEmpty(NEW."geom")) BEGIN INSERT OR REPLACE INTO "rtree_mpg3dz_geom" VALUES (NEW.ROWID, ST_MinX(NEW."geom"), ST_MaxX(NEW."geom"), ST_MinY(NEW."geom"), ST_MaxY(NEW."geom")); END kv? triggerrtree_mpg3dz_geom_update1mpg3dzCREATE TRIGGER "rtree_mpg3dz_geom_update1" AFTER UPDATE OF "geom" ON "mpg3dz" WHEN OLD.ROWID = NEW.ROWID AND (NEW."geom" NOT NULL AND NOT ST_IsEmpty(NEW."geom")) BEGIN INSERT OR REPLACE INTO "rtree_mpg3dz_geom" VALUES (NEW.ROWID, ST_MinX(NEW."geom"), ST_MaxX(NEW."geom"), ST_MinY(NEW."geom"), ST_MaxY(NEW."geom")); ENDw?Ctriggerrtree_mpg3dz_geom_update2mpg3dzCREATE TRIGGER "rtree_mpg3dz_geom_update2" AFTER UPDATE OF "geom" ON "mpg3dz" WHEN OLD.ROWID = NEW.ROWID AND (NEW."geom" IS NULL OR ST_IsEmpty(NEW."geom")) BEGIN DELETE FROM "rtree_mpg3dz_geom" WHERE id = OLD.ROWID; END %6"x?wtriggerrtree_mpg3dz_geom_update3mpg3dzCREATE TRIGGER "rtree_mpg3dz_geom_update3" AFTER UPDATE OF "geom" ON "mpg3dz" WHEN OLD.ROWID != NEW.ROWID AND (NEW."geom" NOT NULL AND NOT ST_IsEmpty(NEW."geom")) BEGIN DELETE FROM "rtree_mpg3dz_geom" WHERE id = OLD.ROWID; INSERT OR REPLACE INTO "rtree_mpg3dz_geom" VALUES (NEW.ROWID, ST_MinX(NEW."geom"), ST_MaxX(NEW."geom"), ST_MinY(NEW."geom"), ST_MaxY(NEW."geom")); END y?Mtriggerrtree_mpg3dz_geom_update4mpg3dzCREATE TRIGGER "rtree_mpg3dz_geom_update4" AFTER UPDATE ON "mpg3dz" WHEN OLD.ROWID != NEW.ROWID AND (NEW."geom" IS NULL OR ST_IsEmpty(NEW."geom")) BEGIN DELETE FROM "rtree_mpg3dz_geom" WHERE id IN (OLD.ROWID, NEW.ROWID); ENDFz=Atriggerrtree_mpg3dz_geom_deletempg3dzCREATE TRIGGER "rtree_mpg3dz_geom_delete" AFTER DELETE ON "mpg3dz"WHEN old."geom" NOT NULL BEGIN DELETE FROM "rtree_mpg3dz_geom" WHERE id = OLD.ROWID; END ,,7a~{//-tablertree_mpg3dz_geomrtree_mpg3dz_geomCREATE VIRTUAL TABLE "rtree_mpg3dz_geom" USING rtree(id, minx, maxx, miny, maxy)|99%tablertree_mpg3dz_geom_nodertree_mpg3dz_geom_nodeCREATE TABLE "rtree_mpg3dz_geom_node"(nodeno INTEGER PRIMARY KEY, data BLOB) };;/tablertree_mpg3dz_geom_rowidrtree_mpg3dz_geom_rowidCREATE TABLE "rtree_mpg3dz_geom_rowid"(rowid INTEGER PRIMARY KEY, nodeno INTEGER)~==;tablertree_mpg3dz_geom_parentrtree_mpg3dz_geom_parentCREATE TABLE "rtree_mpg3dz_geom_parent"(nodeno INTEGER PRIMARY KEY, parentnode INTEGER)tablempg2dmmpg2dmCREATE TABLE "mpg2dm" ( "id" "INTEGER" NOT NULL, "name" "TEXT" NOT NULL, geom BLOB, CONSTRAINT "pk_mpg2dm" PRIMARY KEY ("id")) 99D AAAAAAAAABAB     > delta(HgammaGP?@@@?@@@?@?@@@@?@@?@@@@?@?@@'HbetaGP5@6@5@6@5@5@@6@5@@5@6@@5@5@@"alphaGP4@?@4@?@4@4@@5@4@@4@5@@4@4@@>@>@@?@>@@>@?@@>@>@@   o-#triggerfgti_mpg2dm_geommpg2dmCREATE TRIGGER "fgti_mpg2dm_geom" BEFORE INSERT ON "mpg2dm" FOR EACH ROW BEGIN SELECT RAISE (ROLLBACK, 'insert on "mpg2dm" violates constraint: ST_GeometryType("geom") is not assignable from gpkg_geometry_columns.geometry_type_name value') WHERE (SELECT geometry_type_name FROM gpkg_geometry_columns WHERE Lower(table_name) = Lower('geom') AND Lower(column_name) = Lower('geom') AND gpkg_IsAssignable(geometry_type_name, ST_GeometryType(NEW."geom")) = 0); END WW^-Ktriggerfgtu_mpg2dm_geommpg2dmCREATE TRIGGER "fgtu_mpg2dm_geom" BEFORE UPDATE OF "geom" ON "mpg2dm" FOR EACH ROW BEGIN SELECT RAISE (ROLLBACK, 'update of "mpg2dm" on "geom" violates constraint: ST_GeometryType("geom") is not assignable from gpkg_geometry_columns.geometry_type_name value') WHERE (SELECT geometry_type_name FROM gpkg_geometry_columns WHERE Lower(table_name) = Lower('geom') AND Lower(column_name) = Lower('geom') AND gpkg_IsAssignable(geometry_type_name, ST_GeometryType(NEW."geom")) = 0); END-triggerfgsi_mpg2dm_geommpg2dmCREATE TRIGGER "fgsi_mpg2dm_geom" BEFORE INSERT ON "mpg2dm" FOR EACH ROW BEGIN SELECT RAISE (ROLLBACK, 'insert on "mpg2dm" violates constraint: ST_SRID("geom") does not match gpkg_geometry_columns.srs_id value') WHERE (SELECT srs_id FROM gpkg_geometry_columns WHERE Lower(table_name) = Lower('geom') AND Lower(column_name) = Lower('geom') AND ST_SRID(NEW."geom") <> srs_id); END 2-)triggerfgsu_mpg2dm_geommpg2dmCREATE TRIGGER "fgsu_mpg2dm_geom" BEFORE UPDATE OF "geom" ON "mpg2dm" FOR EACH ROW BEGIN SELECT RAISE (ROLLBACK, 'update of "mpg2dm" on "geom" violates constraint: ST_SRID("geom") does not match gpkg_geometry_columns.srs_id value') WHERE (SELECT srs_id FROM gpkg_geometry_columns WHERE Lower(table_name) = Lower('geom') AND Lower(column_name) = Lower('geom') AND ST_SRID(NEW."geom") <> srs_id); ENDE=?triggerrtree_mpg2dm_geom_insertmpg2dmCREATE TRIGGER "rtree_mpg2dm_geom_insert" AFTER INSERT ON "mpg2dm" WHEN (new."geom" NOT NULL AND NOT ST_IsEmpty(NEW."geom")) BEGIN INSERT OR REPLACE INTO "rtree_mpg2dm_geom" VALUES (NEW.ROWID, ST_MinX(NEW."geom"), ST_MaxX(NEW."geom"), ST_MinY(NEW."geom"), ST_MaxY(NEW."geom")); END k? triggerrtree_mpg2dm_geom_update1mpg2dmCREATE TRIGGER "rtree_mpg2dm_geom_update1" AFTER UPDATE OF "geom" ON "mpg2dm" WHEN OLD.ROWID = NEW.ROWID AND (NEW."geom" NOT NULL AND NOT ST_IsEmpty(NEW."geom")) BEGIN INSERT OR REPLACE INTO "rtree_mpg2dm_geom" VALUES (NEW.ROWID, ST_MinX(NEW."geom"), ST_MaxX(NEW."geom"), ST_MinY(NEW."geom"), ST_MaxY(NEW."geom")); END?Ctriggerrtree_mpg2dm_geom_update2mpg2dmCREATE TRIGGER "rtree_mpg2dm_geom_update2" AFTER UPDATE OF "geom" ON "mpg2dm" WHEN OLD.ROWID = NEW.ROWID AND (NEW."geom" IS NULL OR ST_IsEmpty(NEW."geom")) BEGIN DELETE FROM "rtree_mpg2dm_geom" WHERE id = OLD.ROWID; END %6"?wtriggerrtree_mpg2dm_geom_update3mpg2dmCREATE TRIGGER "rtree_mpg2dm_geom_update3" AFTER UPDATE OF "geom" ON "mpg2dm" WHEN OLD.ROWID != NEW.ROWID AND (NEW."geom" NOT NULL AND NOT ST_IsEmpty(NEW."geom")) BEGIN DELETE FROM "rtree_mpg2dm_geom" WHERE id = OLD.ROWID; INSERT OR REPLACE INTO "rtree_mpg2dm_geom" VALUES (NEW.ROWID, ST_MinX(NEW."geom"), ST_MaxX(NEW."geom"), ST_MinY(NEW."geom"), ST_MaxY(NEW."geom")); END ?Mtriggerrtree_mpg2dm_geom_update4mpg2dmCREATE TRIGGER "rtree_mpg2dm_geom_update4" AFTER UPDATE ON "mpg2dm" WHEN OLD.ROWID != NEW.ROWID AND (NEW."geom" IS NULL OR ST_IsEmpty(NEW."geom")) BEGIN DELETE FROM "rtree_mpg2dm_geom" WHERE id IN (OLD.ROWID, NEW.ROWID); ENDF =Atriggerrtree_mpg2dm_geom_deletempg2dmCREATE TRIGGER "rtree_mpg2dm_geom_delete" AFTER DELETE ON "mpg2dm"WHEN old."geom" NOT NULL BEGIN DELETE FROM "rtree_mpg2dm_geom" WHERE id = OLD.ROWID; END 00;e~ //-tablertree_mpg2dm_geomrtree_mpg2dm_geomCREATE VIRTUAL TABLE "rtree_mpg2dm_geom" USING rtree(id, minx, maxx, miny, maxy) 99%tablertree_mpg2dm_geom_nodertree_mpg2dm_geom_nodeCREATE TABLE "rtree_mpg2dm_geom_node"(nodeno INTEGER PRIMARY KEY, data BLOB) ;;/tablertree_mpg2dm_geom_rowidrtree_mpg2dm_geom_rowidCREATE TABLE "rtree_mpg2dm_geom_rowid"(rowid INTEGER PRIMARY KEY, nodeno INTEGER) ==;tablertree_mpg2dm_geom_parentrtree_mpg2dm_geom_parentCREATE TABLE "rtree_mpg2dm_geom_parent"(nodeno INTEGER PRIMARY KEY, parentnode INTEGER) tablempg2dmpg2dCREATE TABLE "mpg2d" ( "id" "INTEGER" NOT NULL, "name" "TEXT" NOT NULL, geom BLOB, CONSTRAINT "pk_mpg2d" PRIMARY KEY ("id")) 99D AAAAAAAAABAB     eW] beX7AU!mln3dzgeomgpkg_geometry_type_triggerGeoPackage 1.0 Specification Annex Nwrite-onlyN6-U!mln2dmgeomgpkg_rtree_indexGeoPackage 1.0 Specification Annex Lwrite-onlyQ53U!mln2dmgeomgpkg_srs_id_triggerGeoPackage 1.0 Specification Annex Nwrite-onlyX4AU!mln2dmgeomgpkg_geometry_type_triggerGeoPackage 1.0 Specification Annex Nwrite-onlyM3-U!mln2dgeomgpkg_rtree_indexGeoPackage 1.0 Specification Annex Lwrite-onlyP23U!mln2dgeomgpkg_srs_id_triggerGeoPackage 1.0 Specification Annex Nwrite-onlyW1AU!mln2dgeomgpkg_geometry_type_triggerGeoPackage 1.0 Specification Annex Nwrite-onlyM0-U!mpg2dgeomgpkg_rtree_indexGeoPackage 1.0 Specification Annex Lwrite-onlyP/3U!mpg2dgeomgpkg_srs_id_triggerGeoPackage 1.0 Specification Annex Nwrite-onlyW.AU!mpg2dgeomgpkg_geometry_type_triggerGeoPackage 1.0 Specification Annex Nwrite-onlyN--U!mpg2dmgeomgpkg_rtree_indexGeoPackage 1.0 Specification Annex Lwrite-only 6N^"n2v6> =mpg3dzfeaturesmpg3dz 2014-05-22T09:02:18.210Z @ =mpg3dzmfeaturesmpg3dzm 2014-05-22T09:02:17.992Z < =pg3dzmfeaturespg3dzm 2014-05-22T09:02:17.552Z: =pg3dzfeaturespg3dz 2014-05-22T09:02:17.284Z: =pg2dmfeaturespg2dm 2014-05-22T09:02:16.968Z8 =pg2dfeaturespg2d 2014-05-22T09:02:16.674Z< =ln3dzmfeaturesln3dzm 2014-05-22T09:02:16.375Z : =ln3dzfeaturesln3dz 2014-05-22T09:02:16.028Z : =ln2dmfeaturesln2dm 2014-05-22T09:02:15.535Z8 =ln2dfeaturesln2d 2014-05-22T09:02:15.189Z Z =pt3dzmfeaturespt3dzm 2014-05-22T09:02:14.912Z?@@ffffff@ X =pt3dzfeaturespt3dz 2014-05-22T09:02:14.643Z??333333@@X =pt2dmfeaturespt2dm 2014-05-22T09:02:14.211Z?񙙙?񙙙??V =pt2dfeaturespt2d 2014-05-22T09:02:13.902Z?񙙙?񙙙?@ LD@G L@ =geo3dzmfeaturesgeo3dzm 2014-05-22T09:02:21.920Z = = gc3dzmfeaturesgc3dzm 2014-05-22T09:02:21.704Z; = gc3dzfeaturesgc3dz 2014-05-22T09:02:21.398Z; = gc2dmfeaturesgc2dm 2014-05-22T09:02:21.232Z9 = gc2dfeaturesgc2d 2014-05-22T09:02:21.071Z< =mpt2dfeaturesmpt2d 2014-05-22T09:02:20.751Z> =mpt2dmfeaturesmpt2dm 2014-05-22T09:02:20.501Z> =mpt3dzfeaturesmpt3dz 2014-05-22T09:02:20.158Z@ =mpt3dzmfeaturesmpt3dzm 2014-05-22T09:02:19.937Z@ =mln3dzmfeaturesmln3dzm 2014-05-22T09:02:19.774Z> =mln3dzfeaturesmln3dz 2014-05-22T09:02:19.546Z> =mln2dmfeaturesmln2dm 2014-05-22T09:02:19.179Z< =mln2dfeaturesmln2d 2014-05-22T09:02:18.960Z< =mpg2dfeaturesmpg2d 2014-05-22T09:02:18.692Z > =mpg2dmfeaturesmpg2dm 2014-05-22T09:02:18.478Z  (gammaGP?@@@?@@@?@?@@@?@?@@@?@?@betaGP5@6@5@6@5@5@6@5@5@6@5@5@ deltaU"alphaGP4@?@4@?@4@4@5@4@4@5@4@4@>@>@?@>@>@?@>@>@ j+triggerfgti_mpg2d_geommpg2dCREATE TRIGGER "fgti_mpg2d_geom" BEFORE INSERT ON "mpg2d" FOR EACH ROW BEGIN SELECT RAISE (ROLLBACK, 'insert on "mpg2d" violates constraint: ST_GeometryType("geom") is not assignable from gpkg_geometry_columns.geometry_type_name value') WHERE (SELECT geometry_type_name FROM gpkg_geometry_columns WHERE Lower(table_name) = Lower('geom') AND Lower(column_name) = Lower('geom') AND gpkg_IsAssignable(geometry_type_name, ST_GeometryType(NEW."geom")) = 0); END~+Etriggerfgtu_mpg2d_geommpg2dCREATE TRIGGER "fgtu_mpg2d_geom" BEFORE UPDATE OF "geom" ON "mpg2d" FOR EACH ROW BEGIN SELECT RAISE (ROLLBACK, 'update of "mpg2d" on "geom" violates constraint: ST_GeometryType("geom") is not assignable from gpkg_geometry_columns.geometry_type_name value') WHERE (SELECT geometry_type_name FROM gpkg_geometry_columns WHERE Lower(table_name) = Lower('geom') AND Lower(column_name) = Lower('geom') AND gpkg_IsAssignable(geometry_type_name, ST_GeometryType(NEW."geom")) = 0); END O+{triggerfgsi_mpg2d_geommpg2dCREATE TRIGGER "fgsi_mpg2d_geom" BEFORE INSERT ON "mpg2d" FOR EACH ROW BEGIN SELECT RAISE (ROLLBACK, 'insert on "mpg2d" violates constraint: ST_SRID("geom") does not match gpkg_geometry_columns.srs_id value') WHERE (SELECT srs_id FROM gpkg_geometry_columns WHERE Lower(table_name) = Lower('geom') AND Lower(column_name) = Lower('geom') AND ST_SRID(NEW."geom") <> srs_id); END-+#triggerfgsu_mpg2d_geommpg2dCREATE TRIGGER "fgsu_mpg2d_geom" BEFORE UPDATE OF "geom" ON "mpg2d" FOR EACH ROW BEGIN SELECT RAISE (ROLLBACK, 'update of "mpg2d" on "geom" violates constraint: ST_SRID("geom") does not match gpkg_geometry_columns.srs_id value') WHERE (SELECT srs_id FROM gpkg_geometry_columns WHERE Lower(table_name) = Lower('geom') AND Lower(column_name) = Lower('geom') AND ST_SRID(NEW."geom") <> srs_id); END KK@;9triggerrtree_mpg2d_geom_insertmpg2dCREATE TRIGGER "rtree_mpg2d_geom_insert" AFTER INSERT ON "mpg2d" WHEN (new."geom" NOT NULL AND NOT ST_IsEmpty(NEW."geom")) BEGIN INSERT OR REPLACE INTO "rtree_mpg2d_geom" VALUES (NEW.ROWID, ST_MinX(NEW."geom"), ST_MaxX(NEW."geom"), ST_MinY(NEW."geom"), ST_MaxY(NEW."geom")); ENDf=triggerrtree_mpg2d_geom_update1mpg2dCREATE TRIGGER "rtree_mpg2d_geom_update1" AFTER UPDATE OF "geom" ON "mpg2d" WHEN OLD.ROWID = NEW.ROWID AND (NEW."geom" NOT NULL AND NOT ST_IsEmpty(NEW."geom")) BEGIN INSERT OR REPLACE INTO "rtree_mpg2d_geom" VALUES (NEW.ROWID, ST_MinX(NEW."geom"), ST_MaxX(NEW."geom"), ST_MinY(NEW."geom"), ST_MaxY(NEW."geom")); END==triggerrtree_mpg2d_geom_update2mpg2dCREATE TRIGGER "rtree_mpg2d_geom_update2" AFTER UPDATE OF "geom" ON "mpg2d" WHEN OLD.ROWID = NEW.ROWID AND (NEW."geom" IS NULL OR ST_IsEmpty(NEW."geom")) BEGIN DELETE FROM "rtree_mpg2d_geom" WHERE id = OLD.ROWID; END /;=otriggerrtree_mpg2d_geom_update3mpg2dCREATE TRIGGER "rtree_mpg2d_geom_update3" AFTER UPDATE OF "geom" ON "mpg2d" WHEN OLD.ROWID != NEW.ROWID AND (NEW."geom" NOT NULL AND NOT ST_IsEmpty(NEW."geom")) BEGIN DELETE FROM "rtree_mpg2d_geom" WHERE id = OLD.ROWID; INSERT OR REPLACE INTO "rtree_mpg2d_geom" VALUES (NEW.ROWID, ST_MinX(NEW."geom"), ST_MaxX(NEW."geom"), ST_MinY(NEW."geom"), ST_MaxY(NEW."geom")); END=Gtriggerrtree_mpg2d_geom_update4mpg2dCREATE TRIGGER "rtree_mpg2d_geom_update4" AFTER UPDATE ON "mpg2d" WHEN OLD.ROWID != NEW.ROWID AND (NEW."geom" IS NULL OR ST_IsEmpty(NEW."geom")) BEGIN DELETE FROM "rtree_mpg2d_geom" WHERE id IN (OLD.ROWID, NEW.ROWID); ENDA;;triggerrtree_mpg2d_geom_deletempg2dCREATE TRIGGER "rtree_mpg2d_geom_delete" AFTER DELETE ON "mpg2d"WHEN old."geom" NOT NULL BEGIN DELETE FROM "rtree_mpg2d_geom" WHERE id = OLD.ROWID; END 99D AAAAAAAAABAB <<Ae{--+tablertree_mpg2d_geomrtree_mpg2d_geomCREATE VIRTUAL TABLE "rtree_mpg2d_geom" USING rtree(id, minx, maxx, miny, maxy)77#tablertree_mpg2d_geom_nodertree_mpg2d_geom_nodeCREATE TABLE "rtree_mpg2d_geom_node"(nodeno INTEGER PRIMARY KEY, data BLOB) 99-tablertree_mpg2d_geom_rowidrtree_mpg2d_geom_rowidCREATE TABLE "rtree_mpg2d_geom_rowid"(rowid INTEGER PRIMARY KEY, nodeno INTEGER);;9tablertree_mpg2d_geom_parentrtree_mpg2d_geom_parentCREATE TABLE "rtree_mpg2d_geom_parent"(nodeno INTEGER PRIMARY KEY, parentnode INTEGER) tablemln2dmln2dCREATE TABLE "mln2d" ( "id" "INTEGER" NOT NULL, "name" "TEXT" NOT NULL, geom BLOB, CONSTRAINT "pk_mln2d" PRIMARY KEY ("id"))     p {p delta gammaGP@6@@6@6@(@(@6@@@&@&@ betaGP@5@@5@5@&@&@5@@@$@$@d@alphaGP$@4@$@4@4@$@$@4@ j+triggerfgti_mln2d_geommln2dCREATE TRIGGER "fgti_mln2d_geom" BEFORE INSERT ON "mln2d" FOR EACH ROW BEGIN SELECT RAISE (ROLLBACK, 'insert on "mln2d" violates constraint: ST_GeometryType("geom") is not assignable from gpkg_geometry_columns.geometry_type_name value') WHERE (SELECT geometry_type_name FROM gpkg_geometry_columns WHERE Lower(table_name) = Lower('geom') AND Lower(column_name) = Lower('geom') AND gpkg_IsAssignable(geometry_type_name, ST_GeometryType(NEW."geom")) = 0); END~+Etriggerfgtu_mln2d_geommln2dCREATE TRIGGER "fgtu_mln2d_geom" BEFORE UPDATE OF "geom" ON "mln2d" FOR EACH ROW BEGIN SELECT RAISE (ROLLBACK, 'update of "mln2d" on "geom" violates constraint: ST_GeometryType("geom") is not assignable from gpkg_geometry_columns.geometry_type_name value') WHERE (SELECT geometry_type_name FROM gpkg_geometry_columns WHERE Lower(table_name) = Lower('geom') AND Lower(column_name) = Lower('geom') AND gpkg_IsAssignable(geometry_type_name, ST_GeometryType(NEW."geom")) = 0); END O +{triggerfgsi_mln2d_geommln2dCREATE TRIGGER "fgsi_mln2d_geom" BEFORE INSERT ON "mln2d" FOR EACH ROW BEGIN SELECT RAISE (ROLLBACK, 'insert on "mln2d" violates constraint: ST_SRID("geom") does not match gpkg_geometry_columns.srs_id value') WHERE (SELECT srs_id FROM gpkg_geometry_columns WHERE Lower(table_name) = Lower('geom') AND Lower(column_name) = Lower('geom') AND ST_SRID(NEW."geom") <> srs_id); END-!+#triggerfgsu_mln2d_geommln2dCREATE TRIGGER "fgsu_mln2d_geom" BEFORE UPDATE OF "geom" ON "mln2d" FOR EACH ROW BEGIN SELECT RAISE (ROLLBACK, 'update of "mln2d" on "geom" violates constraint: ST_SRID("geom") does not match gpkg_geometry_columns.srs_id value') WHERE (SELECT srs_id FROM gpkg_geometry_columns WHERE Lower(table_name) = Lower('geom') AND Lower(column_name) = Lower('geom') AND ST_SRID(NEW."geom") <> srs_id); END KK@";9triggerrtree_mln2d_geom_insertmln2dCREATE TRIGGER "rtree_mln2d_geom_insert" AFTER INSERT ON "mln2d" WHEN (new."geom" NOT NULL AND NOT ST_IsEmpty(NEW."geom")) BEGIN INSERT OR REPLACE INTO "rtree_mln2d_geom" VALUES (NEW.ROWID, ST_MinX(NEW."geom"), ST_MaxX(NEW."geom"), ST_MinY(NEW."geom"), ST_MaxY(NEW."geom")); ENDf#=triggerrtree_mln2d_geom_update1mln2dCREATE TRIGGER "rtree_mln2d_geom_update1" AFTER UPDATE OF "geom" ON "mln2d" WHEN OLD.ROWID = NEW.ROWID AND (NEW."geom" NOT NULL AND NOT ST_IsEmpty(NEW."geom")) BEGIN INSERT OR REPLACE INTO "rtree_mln2d_geom" VALUES (NEW.ROWID, ST_MinX(NEW."geom"), ST_MaxX(NEW."geom"), ST_MinY(NEW."geom"), ST_MaxY(NEW."geom")); END$==triggerrtree_mln2d_geom_update2mln2dCREATE TRIGGER "rtree_mln2d_geom_update2" AFTER UPDATE OF "geom" ON "mln2d" WHEN OLD.ROWID = NEW.ROWID AND (NEW."geom" IS NULL OR ST_IsEmpty(NEW."geom")) BEGIN DELETE FROM "rtree_mln2d_geom" WHERE id = OLD.ROWID; END /;%=otriggerrtree_mln2d_geom_update3mln2dCREATE TRIGGER "rtree_mln2d_geom_update3" AFTER UPDATE OF "geom" ON "mln2d" WHEN OLD.ROWID != NEW.ROWID AND (NEW."geom" NOT NULL AND NOT ST_IsEmpty(NEW."geom")) BEGIN DELETE FROM "rtree_mln2d_geom" WHERE id = OLD.ROWID; INSERT OR REPLACE INTO "rtree_mln2d_geom" VALUES (NEW.ROWID, ST_MinX(NEW."geom"), ST_MaxX(NEW."geom"), ST_MinY(NEW."geom"), ST_MaxY(NEW."geom")); END&=Gtriggerrtree_mln2d_geom_update4mln2dCREATE TRIGGER "rtree_mln2d_geom_update4" AFTER UPDATE ON "mln2d" WHEN OLD.ROWID != NEW.ROWID AND (NEW."geom" IS NULL OR ST_IsEmpty(NEW."geom")) BEGIN DELETE FROM "rtree_mln2d_geom" WHERE id IN (OLD.ROWID, NEW.ROWID); ENDA';;triggerrtree_mln2d_geom_deletemln2dCREATE TRIGGER "rtree_mln2d_geom_delete" AFTER DELETE ON "mln2d"WHEN old."geom" NOT NULL BEGIN DELETE FROM "rtree_mln2d_geom" WHERE id = OLD.ROWID; END 99D A AA A@A@A@A@A 88=a{(--+tablertree_mln2d_geomrtree_mln2d_geomCREATE VIRTUAL TABLE "rtree_mln2d_geom" USING rtree(id, minx, maxx, miny, maxy))77#tablertree_mln2d_geom_nodertree_mln2d_geom_nodeCREATE TABLE "rtree_mln2d_geom_node"(nodeno INTEGER PRIMARY KEY, data BLOB) *99-tablertree_mln2d_geom_rowidrtree_mln2d_geom_rowidCREATE TABLE "rtree_mln2d_geom_rowid"(rowid INTEGER PRIMARY KEY, nodeno INTEGER)+;;9tablertree_mln2d_geom_parentrtree_mln2d_geom_parentCREATE TABLE "rtree_mln2d_geom_parent"(nodeno INTEGER PRIMARY KEY, parentnode INTEGER),tablemln2dmmln2dmCREATE TABLE "mln2dm" ( "id" "INTEGER" NOT NULL, "name" "TEXT" NOT NULL, geom BLOB, CONSTRAINT "pk_mln2dm" PRIMARY KEY ("id"))       -RgammaGP@6@@6@6@(@@(@6@@@@@&@&@@,RbetaGP@5@@5@5@&@@&@5@@@@@$@$@@ deltat`alphaGP$@4@$@4@4@$@@$@4@@   o--#triggerfgti_mln2dm_geommln2dmCREATE TRIGGER "fgti_mln2dm_geom" BEFORE INSERT ON "mln2dm" FOR EACH ROW BEGIN SELECT RAISE (ROLLBACK, 'insert on "mln2dm" violates constraint: ST_GeometryType("geom") is not assignable from gpkg_geometry_columns.geometry_type_name value') WHERE (SELECT geometry_type_name FROM gpkg_geometry_columns WHERE Lower(table_name) = Lower('geom') AND Lower(column_name) = Lower('geom') AND gpkg_IsAssignable(geometry_type_name, ST_GeometryType(NEW."geom")) = 0); END WW^.-Ktriggerfgtu_mln2dm_geommln2dmCREATE TRIGGER "fgtu_mln2dm_geom" BEFORE UPDATE OF "geom" ON "mln2dm" FOR EACH ROW BEGIN SELECT RAISE (ROLLBACK, 'update of "mln2dm" on "geom" violates constraint: ST_GeometryType("geom") is not assignable from gpkg_geometry_columns.geometry_type_name value') WHERE (SELECT geometry_type_name FROM gpkg_geometry_columns WHERE Lower(table_name) = Lower('geom') AND Lower(column_name) = Lower('geom') AND gpkg_IsAssignable(geometry_type_name, ST_GeometryType(NEW."geom")) = 0); END/-triggerfgsi_mln2dm_geommln2dmCREATE TRIGGER "fgsi_mln2dm_geom" BEFORE INSERT ON "mln2dm" FOR EACH ROW BEGIN SELECT RAISE (ROLLBACK, 'insert on "mln2dm" violates constraint: ST_SRID("geom") does not match gpkg_geometry_columns.srs_id value') WHERE (SELECT srs_id FROM gpkg_geometry_columns WHERE Lower(table_name) = Lower('geom') AND Lower(column_name) = Lower('geom') AND ST_SRID(NEW."geom") <> srs_id); END 20-)triggerfgsu_mln2dm_geommln2dmCREATE TRIGGER "fgsu_mln2dm_geom" BEFORE UPDATE OF "geom" ON "mln2dm" FOR EACH ROW BEGIN SELECT RAISE (ROLLBACK, 'update of "mln2dm" on "geom" violates constraint: ST_SRID("geom") does not match gpkg_geometry_columns.srs_id value') WHERE (SELECT srs_id FROM gpkg_geometry_columns WHERE Lower(table_name) = Lower('geom') AND Lower(column_name) = Lower('geom') AND ST_SRID(NEW."geom") <> srs_id); ENDE1=?triggerrtree_mln2dm_geom_insertmln2dmCREATE TRIGGER "rtree_mln2dm_geom_insert" AFTER INSERT ON "mln2dm" WHEN (new."geom" NOT NULL AND NOT ST_IsEmpty(NEW."geom")) BEGIN INSERT OR REPLACE INTO "rtree_mln2dm_geom" VALUES (NEW.ROWID, ST_MinX(NEW."geom"), ST_MaxX(NEW."geom"), ST_MinY(NEW."geom"), ST_MaxY(NEW."geom")); END k2? triggerrtree_mln2dm_geom_update1mln2dmCREATE TRIGGER "rtree_mln2dm_geom_update1" AFTER UPDATE OF "geom" ON "mln2dm" WHEN OLD.ROWID = NEW.ROWID AND (NEW."geom" NOT NULL AND NOT ST_IsEmpty(NEW."geom")) BEGIN INSERT OR REPLACE INTO "rtree_mln2dm_geom" VALUES (NEW.ROWID, ST_MinX(NEW."geom"), ST_MaxX(NEW."geom"), ST_MinY(NEW."geom"), ST_MaxY(NEW."geom")); END3?Ctriggerrtree_mln2dm_geom_update2mln2dmCREATE TRIGGER "rtree_mln2dm_geom_update2" AFTER UPDATE OF "geom" ON "mln2dm" WHEN OLD.ROWID = NEW.ROWID AND (NEW."geom" IS NULL OR ST_IsEmpty(NEW."geom")) BEGIN DELETE FROM "rtree_mln2dm_geom" WHERE id = OLD.ROWID; END %6"4?wtriggerrtree_mln2dm_geom_update3mln2dmCREATE TRIGGER "rtree_mln2dm_geom_update3" AFTER UPDATE OF "geom" ON "mln2dm" WHEN OLD.ROWID != NEW.ROWID AND (NEW."geom" NOT NULL AND NOT ST_IsEmpty(NEW."geom")) BEGIN DELETE FROM "rtree_mln2dm_geom" WHERE id = OLD.ROWID; INSERT OR REPLACE INTO "rtree_mln2dm_geom" VALUES (NEW.ROWID, ST_MinX(NEW."geom"), ST_MaxX(NEW."geom"), ST_MinY(NEW."geom"), ST_MaxY(NEW."geom")); END 5?Mtriggerrtree_mln2dm_geom_update4mln2dmCREATE TRIGGER "rtree_mln2dm_geom_update4" AFTER UPDATE ON "mln2dm" WHEN OLD.ROWID != NEW.ROWID AND (NEW."geom" IS NULL OR ST_IsEmpty(NEW."geom")) BEGIN DELETE FROM "rtree_mln2dm_geom" WHERE id IN (OLD.ROWID, NEW.ROWID); ENDF6=Atriggerrtree_mln2dm_geom_deletemln2dmCREATE TRIGGER "rtree_mln2dm_geom_delete" AFTER DELETE ON "mln2dm"WHEN old."geom" NOT NULL BEGIN DELETE FROM "rtree_mln2dm_geom" WHERE id = OLD.ROWID; END ,,7a~7//-tablertree_mln2dm_geomrtree_mln2dm_geomCREATE VIRTUAL TABLE "rtree_mln2dm_geom" USING rtree(id, minx, maxx, miny, maxy)899%tablertree_mln2dm_geom_nodertree_mln2dm_geom_nodeCREATE TABLE "rtree_mln2dm_geom_node"(nodeno INTEGER PRIMARY KEY, data BLOB) 9;;/tablertree_mln2dm_geom_rowidrtree_mln2dm_geom_rowidCREATE TABLE "rtree_mln2dm_geom_rowid"(rowid INTEGER PRIMARY KEY, nodeno INTEGER):==;tablertree_mln2dm_geom_parentrtree_mln2dm_geom_parentCREATE TABLE "rtree_mln2dm_geom_parent"(nodeno INTEGER PRIMARY KEY, parentnode INTEGER);tablemln3dzmln3dzCREATE TABLE "mln3dz" ( "id" "INTEGER" NOT NULL, "name" "TEXT" NOT NULL, geom BLOB, CONSTRAINT "pk_mln3dz" PRIMARY KEY ("id")) 99D A AA A@A@A@A@A     ==`@l Kl"3mpg2dgeomgpkg_srs_id_trigger/*Ampg2dmgeomgpkg_geometry_type_trigger+ -mpg2dmgeomgpkg_rtree_index-#3mpg2dmgeomgpkg_srs_id_trigger,*Ampg3dzgeomgpkg_geometry_type_trigger( -mpg3dzgeomgpkg_rtree_index*#3mpg3dzgeomgpkg_srs_id_trigger)+Ampg3dzmgeomgpkg_geometry_type_trigger%!-mpg3dzmgeomgpkg_rtree_index'$3mpg3dzmgeomgpkg_srs_id_trigger&)Ampt2dgeomgpkg_geometry_type_triggerF-mpt2dgeomgpkg_rtree_indexH"3mpt2dgeomgpkg_srs_id_triggerG*Ampt2dmgeomgpkg_geometry_type_triggerC -mpt2dmgeomgpkg_rtree_indexE#3mpt2dmgeomgpkg_srs_id_triggerD*Ampt3dzgeomgpkg_geometry_type_trigger@ -mpt3dzgeomgpkg_rtree_indexB#3mpt3dzgeomgpkg_srs_id_triggerA   -RgammaGP@6@@6@6@(@@(@6@@@@@&@&@@,RbetaGP@5@@5@5@&@@&@5@@@@@$@$@@ deltat`alphaGP$@4@$@4@4@$@@$@4@@   o<-#triggerfgti_mln3dz_geommln3dzCREATE TRIGGER "fgti_mln3dz_geom" BEFORE INSERT ON "mln3dz" FOR EACH ROW BEGIN SELECT RAISE (ROLLBACK, 'insert on "mln3dz" violates constraint: ST_GeometryType("geom") is not assignable from gpkg_geometry_columns.geometry_type_name value') WHERE (SELECT geometry_type_name FROM gpkg_geometry_columns WHERE Lower(table_name) = Lower('geom') AND Lower(column_name) = Lower('geom') AND gpkg_IsAssignable(geometry_type_name, ST_GeometryType(NEW."geom")) = 0); END WW^=-Ktriggerfgtu_mln3dz_geommln3dzCREATE TRIGGER "fgtu_mln3dz_geom" BEFORE UPDATE OF "geom" ON "mln3dz" FOR EACH ROW BEGIN SELECT RAISE (ROLLBACK, 'update of "mln3dz" on "geom" violates constraint: ST_GeometryType("geom") is not assignable from gpkg_geometry_columns.geometry_type_name value') WHERE (SELECT geometry_type_name FROM gpkg_geometry_columns WHERE Lower(table_name) = Lower('geom') AND Lower(column_name) = Lower('geom') AND gpkg_IsAssignable(geometry_type_name, ST_GeometryType(NEW."geom")) = 0); END>-triggerfgsi_mln3dz_geommln3dzCREATE TRIGGER "fgsi_mln3dz_geom" BEFORE INSERT ON "mln3dz" FOR EACH ROW BEGIN SELECT RAISE (ROLLBACK, 'insert on "mln3dz" violates constraint: ST_SRID("geom") does not match gpkg_geometry_columns.srs_id value') WHERE (SELECT srs_id FROM gpkg_geometry_columns WHERE Lower(table_name) = Lower('geom') AND Lower(column_name) = Lower('geom') AND ST_SRID(NEW."geom") <> srs_id); END 2?-)triggerfgsu_mln3dz_geommln3dzCREATE TRIGGER "fgsu_mln3dz_geom" BEFORE UPDATE OF "geom" ON "mln3dz" FOR EACH ROW BEGIN SELECT RAISE (ROLLBACK, 'update of "mln3dz" on "geom" violates constraint: ST_SRID("geom") does not match gpkg_geometry_columns.srs_id value') WHERE (SELECT srs_id FROM gpkg_geometry_columns WHERE Lower(table_name) = Lower('geom') AND Lower(column_name) = Lower('geom') AND ST_SRID(NEW."geom") <> srs_id); ENDE@=?triggerrtree_mln3dz_geom_insertmln3dzCREATE TRIGGER "rtree_mln3dz_geom_insert" AFTER INSERT ON "mln3dz" WHEN (new."geom" NOT NULL AND NOT ST_IsEmpty(NEW."geom")) BEGIN INSERT OR REPLACE INTO "rtree_mln3dz_geom" VALUES (NEW.ROWID, ST_MinX(NEW."geom"), ST_MaxX(NEW."geom"), ST_MinY(NEW."geom"), ST_MaxY(NEW."geom")); END `]]]`NB-U!mpt3dzgeomgpkg_rtree_indexGeoPackage 1.0 Specification Annex Lwrite-onlyQA3U!mpt3dzgeomgpkg_srs_id_triggerGeoPackage 1.0 Specification Annex Nwrite-onlyX@AU!mpt3dzgeomgpkg_geometry_type_triggerGeoPackage 1.0 Specification Annex Nwrite-onlyO?-U!mpt3dzmgeomgpkg_rtree_indexGeoPackage 1.0 Specification Annex Lwrite-onlyR>3U!mpt3dzmgeomgpkg_srs_id_triggerGeoPackage 1.0 Specification Annex Nwrite-onlyY=AU!mpt3dzmgeomgpkg_geometry_type_triggerGeoPackage 1.0 Specification Annex Nwrite-onlyO<-U!mln3dzmgeomgpkg_rtree_indexGeoPackage 1.0 Specification Annex Lwrite-onlyR;3U!mln3dzmgeomgpkg_srs_id_triggerGeoPackage 1.0 Specification Annex Nwrite-onlyY:AU!mln3dzmgeomgpkg_geometry_type_triggerGeoPackage 1.0 Specification Annex Nwrite-onlyN9-U!mln3dzgeomgpkg_rtree_indexGeoPackage 1.0 Specification Annex Lwrite-onlyQ83U!mln3dzgeomgpkg_srs_id_triggerGeoPackage 1.0 Specification Annex Nwrite-only B?Ctriggerrtree_mln3dz_geom_update2mln3dzCREATE TRIGGER "rtree_mln3dz_geom_update2" AFTER UPDATE OF "geom" ON "mln3dz" WHEN OLD.ROWID = NEW.ROWID AND (NEW."geom" IS NULL OR ST_IsEmpty(NEW."geom")) BEGIN DELETE FROM "rtree_mln3dz_geom" WHERE id = OLD.ROWID; ENDkA? triggerrtree_mln3dz_geom_update1mln3dzCREATE TRIGGER "rtree_mln3dz_geom_update1" AFTER UPDATE OF "geom" ON "mln3dz" WHEN OLD.ROWID = NEW.ROWID AND (NEW."geom" NOT NULL AND NOT ST_IsEmpty(NEW."geom")) BEGIN INSERT OR REPLACE INTO "rtree_mln3dz_geom" VALUES (NEW.ROWID, ST_MinX(NEW."geom"), ST_MaxX(NEW."geom"), ST_MinY(NEW."geom"), ST_MaxY(NEW."geom")); ENDe $).38=BGLQV[`ejoty~ "(.4:@FLRX^djpv|    ! ""##$$%%&&''()),+.,0-2.4/71<5>6@7C8F:K>M?O@RAUCZG[H]I_JaKdLiSkTmUpVsXx\z]|^_ae f ghjnoprs t%y'z){,|/~468;>CEGJMRSUWY\abdfhkpqsuwz ZI{FE=Atriggerrtree_mln3dz_geom_deletemln3dzCREATE TRIGGER "rtree_mln3dz_geom_delete" AFTER DELETE ON "mln3dz"WHEN old."geom" NOT NULL BEGIN DELETE FROM "rtree_mln3dz_geom" WHERE id = OLD.ROWID; END D?Mtriggerrtree_mln3dz_geom_update4mln3dzCREATE TRIGGER "rtree_mln3dz_geom_update4" AFTER UPDATE ON "mln3dz" WHEN OLD.ROWID != NEW.ROWID AND (NEW."geom" IS NULL OR ST_IsEmpty(NEW."geom")) BEGIN DELETE FROM "rtree_mln3dz_geom" WHERE id IN (OLD.ROWID, NEW.ROWID); END"C?wtriggerrtree_mln3dz_geom_update3mln3dzCREATE TRIGGER "rtree_mln3dz_geom_update3" AFTER UPDATE OF "geom" ON "mln3dz" WHEN OLD.ROWID != NEW.ROWID AND (NEW."geom" NOT NULL AND NOT ST_IsEmpty(NEW."geom")) BEGIN DELETE FROM "rtree_mln3dz_geom" WHERE id = OLD.ROWID; INSERT OR REPLACE INTO "rtree_mln3dz_geom" VALUES (NEW.ROWID, ST_MinX(NEW."geom"), ST_MaxX(NEW."geom"), ST_MinY(NEW."geom"), ST_MaxY(NEW."geom")); END (d(Jtablemln3dzmmln3dzmCREATE TABLE "mln3dzm" ( "id" "INTEGER" NOT NULL, "name" "TEXT" NOT NULL, geom BLOB, CONSTRAINT "pk_mln3dzm" PRIMARY KEY ("id"))I==;tablertree_mln3dz_geom_parentrtree_mln3dz_geom_parentCREATE TABLE "rtree_mln3dz_geom_parent"(nodeno INTEGER PRIMARY KEY, parentnode INTEGER) H;;/tablertree_mln3dz_geom_rowidrtree_mln3dz_geom_rowidCREATE TABLE "rtree_mln3dz_geom_rowid"(rowid INTEGER PRIMARY KEY, nodeno INTEGER)G99%tablertree_mln3dz_geom_nodertree_mln3dz_geom_nodeCREATE TABLE "rtree_mln3dz_geom_node"(nodeno INTEGER PRIMARY KEY, data BLOB)~F//-tablertree_mln3dz_geomrtree_mln3dz_geomCREATE VIRTUAL TABLE "rtree_mln3dz_geom" USING rtree(id, minx, maxx, miny, maxy) 99D A AA A@A@A@A@A     y deltaMgammaGP@6@@6@  6@(@@@(@6@@@ @@@@&@&@@"@LbetaGP@5@@5@  5@&@@@&@5@@@ @@@?$@$@@@alphaGP$@4@$@4@  4@$@@@$@4@@@ tK/)triggerfgti_mln3dzm_geommln3dzmCREATE TRIGGER "fgti_mln3dzm_geom" BEFORE INSERT ON "mln3dzm" FOR EACH ROW BEGIN SELECT RAISE (ROLLBACK, 'insert on "mln3dzm" violates constraint: ST_GeometryType("geom") is not assignable from gpkg_geometry_columns.geometry_type_name value') WHERE (SELECT geometry_type_name FROM gpkg_geometry_columns WHERE Lower(table_name) = Lower('geom') AND Lower(column_name) = Lower('geom') AND gpkg_IsAssignable(geometry_type_name, ST_GeometryType(NEW."geom")) = 0); END MM#M/triggerfgsi_mln3dzm_geommln3dzmCREATE TRIGGER "fgsi_mln3dzm_geom" BEFORE INSERT ON "mln3dzm" FOR EACH ROW BEGIN SELECT RAISE (ROLLBACK, 'insert on "mln3dzm" violates constraint: ST_SRID("geom") does not match gpkg_geometry_columns.srs_id value') WHERE (SELECT srs_id FROM gpkg_geometry_columns WHERE Lower(table_name) = Lower('geom') AND Lower(column_name) = Lower('geom') AND ST_SRID(NEW."geom") <> srs_id); ENDL/Qtriggerfgtu_mln3dzm_geommln3dzmCREATE TRIGGER "fgtu_mln3dzm_geom" BEFORE UPDATE OF "geom" ON "mln3dzm" FOR EACH ROW BEGIN SELECT RAISE (ROLLBACK, 'update of "mln3dzm" on "geom" violates constraint: ST_GeometryType("geom") is not assignable from gpkg_geometry_columns.geometry_type_name value') WHERE (SELECT geometry_type_name FROM gpkg_geometry_columns WHERE Lower(table_name) = Lower('geom') AND Lower(column_name) = Lower('geom') AND gpkg_IsAssignable(geometry_type_name, ST_GeometryType(NEW."geom")) = 0); END EJO?Etriggerrtree_mln3dzm_geom_insertmln3dzmCREATE TRIGGER "rtree_mln3dzm_geom_insert" AFTER INSERT ON "mln3dzm" WHEN (new."geom" NOT NULL AND NOT ST_IsEmpty(NEW."geom")) BEGIN INSERT OR REPLACE INTO "rtree_mln3dzm_geom" VALUES (NEW.ROWID, ST_MinX(NEW."geom"), ST_MaxX(NEW."geom"), ST_MinY(NEW."geom"), ST_MaxY(NEW."geom")); END7N//triggerfgsu_mln3dzm_geommln3dzmCREATE TRIGGER "fgsu_mln3dzm_geom" BEFORE UPDATE OF "geom" ON "mln3dzm" FOR EACH ROW BEGIN SELECT RAISE (ROLLBACK, 'update of "mln3dzm" on "geom" violates constraint: ST_SRID("geom") does not match gpkg_geometry_columns.srs_id value') WHERE (SELECT srs_id FROM gpkg_geometry_columns WHERE Lower(table_name) = Lower('geom') AND Lower(column_name) = Lower('geom') AND ST_SRID(NEW."geom") <> srs_id); END {{ QAItriggerrtree_mln3dzm_geom_update2mln3dzmCREATE TRIGGER "rtree_mln3dzm_geom_update2" AFTER UPDATE OF "geom" ON "mln3dzm" WHEN OLD.ROWID = NEW.ROWID AND (NEW."geom" IS NULL OR ST_IsEmpty(NEW."geom")) BEGIN DELETE FROM "rtree_mln3dzm_geom" WHERE id = OLD.ROWID; ENDpPAtriggerrtree_mln3dzm_geom_update1mln3dzmCREATE TRIGGER "rtree_mln3dzm_geom_update1" AFTER UPDATE OF "geom" ON "mln3dzm" WHEN OLD.ROWID = NEW.ROWID AND (NEW."geom" NOT NULL AND NOT ST_IsEmpty(NEW."geom")) BEGIN INSERT OR REPLACE INTO "rtree_mln3dzm_geom" VALUES (NEW.ROWID, ST_MinX(NEW."geom"), ST_MaxX(NEW."geom"), ST_MinY(NEW."geom"), ST_MaxY(NEW."geom")); END oT>okKT?Gtriggerrtree_mln3dzm_geom_deletemln3dzmCREATE TRIGGER "rtree_mln3dzm_geom_delete" AFTER DELETE ON "mln3dzm"WHEN old."geom" NOT NULL BEGIN DELETE FROM "rtree_mln3dzm_geom" WHERE id = OLD.ROWID; ENDSAStriggerrtree_mln3dzm_geom_update4mln3dzmCREATE TRIGGER "rtree_mln3dzm_geom_update4" AFTER UPDATE ON "mln3dzm" WHEN OLD.ROWID != NEW.ROWID AND (NEW."geom" IS NULL OR ST_IsEmpty(NEW."geom")) BEGIN DELETE FROM "rtree_mln3dzm_geom" WHERE id IN (OLD.ROWID, NEW.ROWID); END(RAtriggerrtree_mln3dzm_geom_update3mln3dzmCREATE TRIGGER "rtree_mln3dzm_geom_update3" AFTER UPDATE OF "geom" ON "mln3dzm" WHEN OLD.ROWID != NEW.ROWID AND (NEW."geom" NOT NULL AND NOT ST_IsEmpty(NEW."geom")) BEGIN DELETE FROM "rtree_mln3dzm_geom" WHERE id = OLD.ROWID; INSERT OR REPLACE INTO "rtree_mln3dzm_geom" VALUES (NEW.ROWID, ST_MinX(NEW."geom"), ST_MaxX(NEW."geom"), ST_MinY(NEW."geom"), ST_MaxY(NEW."geom")); END {ZYtablempt3dzmmpt3dzmCREATE TABLE "mpt3dzm" ( "id" "INTEGER" NOT NULL, "name" "TEXT" NOT NULL, geom BLOB, CONSTRAINT "pk_mpt3dzm" PRIMARY KEY ("id"))X??=tablertree_mln3dzm_geom_parentrtree_mln3dzm_geom_parentCREATE TABLE "rtree_mln3dzm_geom_parent"(nodeno INTEGER PRIMARY KEY, parentnode INTEGER)W==1tablertree_mln3dzm_geom_rowidrtree_mln3dzm_geom_rowidCREATE TABLE "rtree_mln3dzm_geom_rowid"(rowid INTEGER PRIMARY KEY, nodeno INTEGER) V;;'tablertree_mln3dzm_geom_nodertree_mln3dzm_geom_nodeCREATE TABLE "rtree_mln3dzm_geom_node"(nodeno INTEGER PRIMARY KEY, data BLOB)U11/tablertree_mln3dzm_geomrtree_mln3dzm_geomCREATE VIRTUAL TABLE "rtree_mln3dzm_geom" USING rtree(id, minx, maxx, miny, maxy) 99D A AA A@A@A@A@A      `8gammaGP$@$@@@  $@@?@ deltabetaGP$@4@$@4@  $@4@@@ 4@$@@@`8alphaGP@@@@  @@@@ tZ/)triggerfgti_mpt3dzm_geommpt3dzmCREATE TRIGGER "fgti_mpt3dzm_geom" BEFORE INSERT ON "mpt3dzm" FOR EACH ROW BEGIN SELECT RAISE (ROLLBACK, 'insert on "mpt3dzm" violates constraint: ST_GeometryType("geom") is not assignable from gpkg_geometry_columns.geometry_type_name value') WHERE (SELECT geometry_type_name FROM gpkg_geometry_columns WHERE Lower(table_name) = Lower('geom') AND Lower(column_name) = Lower('geom') AND gpkg_IsAssignable(geometry_type_name, ST_GeometryType(NEW."geom")) = 0); END MM#\/triggerfgsi_mpt3dzm_geommpt3dzmCREATE TRIGGER "fgsi_mpt3dzm_geom" BEFORE INSERT ON "mpt3dzm" FOR EACH ROW BEGIN SELECT RAISE (ROLLBACK, 'insert on "mpt3dzm" violates constraint: ST_SRID("geom") does not match gpkg_geometry_columns.srs_id value') WHERE (SELECT srs_id FROM gpkg_geometry_columns WHERE Lower(table_name) = Lower('geom') AND Lower(column_name) = Lower('geom') AND ST_SRID(NEW."geom") <> srs_id); END[/Qtriggerfgtu_mpt3dzm_geommpt3dzmCREATE TRIGGER "fgtu_mpt3dzm_geom" BEFORE UPDATE OF "geom" ON "mpt3dzm" FOR EACH ROW BEGIN SELECT RAISE (ROLLBACK, 'update of "mpt3dzm" on "geom" violates constraint: ST_GeometryType("geom") is not assignable from gpkg_geometry_columns.geometry_type_name value') WHERE (SELECT geometry_type_name FROM gpkg_geometry_columns WHERE Lower(table_name) = Lower('geom') AND Lower(column_name) = Lower('geom') AND gpkg_IsAssignable(geometry_type_name, ST_GeometryType(NEW."geom")) = 0); END EJ^?Etriggerrtree_mpt3dzm_geom_insertmpt3dzmCREATE TRIGGER "rtree_mpt3dzm_geom_insert" AFTER INSERT ON "mpt3dzm" WHEN (new."geom" NOT NULL AND NOT ST_IsEmpty(NEW."geom")) BEGIN INSERT OR REPLACE INTO "rtree_mpt3dzm_geom" VALUES (NEW.ROWID, ST_MinX(NEW."geom"), ST_MaxX(NEW."geom"), ST_MinY(NEW."geom"), ST_MaxY(NEW."geom")); END7]//triggerfgsu_mpt3dzm_geommpt3dzmCREATE TRIGGER "fgsu_mpt3dzm_geom" BEFORE UPDATE OF "geom" ON "mpt3dzm" FOR EACH ROW BEGIN SELECT RAISE (ROLLBACK, 'update of "mpt3dzm" on "geom" violates constraint: ST_SRID("geom") does not match gpkg_geometry_columns.srs_id value') WHERE (SELECT srs_id FROM gpkg_geometry_columns WHERE Lower(table_name) = Lower('geom') AND Lower(column_name) = Lower('geom') AND ST_SRID(NEW."geom") <> srs_id); END {{ `AItriggerrtree_mpt3dzm_geom_update2mpt3dzmCREATE TRIGGER "rtree_mpt3dzm_geom_update2" AFTER UPDATE OF "geom" ON "mpt3dzm" WHEN OLD.ROWID = NEW.ROWID AND (NEW."geom" IS NULL OR ST_IsEmpty(NEW."geom")) BEGIN DELETE FROM "rtree_mpt3dzm_geom" WHERE id = OLD.ROWID; ENDp_Atriggerrtree_mpt3dzm_geom_update1mpt3dzmCREATE TRIGGER "rtree_mpt3dzm_geom_update1" AFTER UPDATE OF "geom" ON "mpt3dzm" WHEN OLD.ROWID = NEW.ROWID AND (NEW."geom" NOT NULL AND NOT ST_IsEmpty(NEW."geom")) BEGIN INSERT OR REPLACE INTO "rtree_mpt3dzm_geom" VALUES (NEW.ROWID, ST_MinX(NEW."geom"), ST_MaxX(NEW."geom"), ST_MinY(NEW."geom"), ST_MaxY(NEW."geom")); ENDat &,28>DJPV\bhntz "(.4:@FLRX^djpv|sr‚ÂĂłǂ˂̂!͂$΂'Ђ,Ԃ-Ղ/ւ1ׂ3؂6ق;߂<>@BEJKMOQTYZ\^`chikmorw x z |~   ! #$'&(()+*/,315274:5>7B;CI?L@QERFTGVHXI[J`OaPcQeSgTjUo[p\r]t^v_y`~hijk m oT>okKc?Gtriggerrtree_mpt3dzm_geom_deletempt3dzmCREATE TRIGGER "rtree_mpt3dzm_geom_delete" AFTER DELETE ON "mpt3dzm"WHEN old."geom" NOT NULL BEGIN DELETE FROM "rtree_mpt3dzm_geom" WHERE id = OLD.ROWID; ENDbAStriggerrtree_mpt3dzm_geom_update4mpt3dzmCREATE TRIGGER "rtree_mpt3dzm_geom_update4" AFTER UPDATE ON "mpt3dzm" WHEN OLD.ROWID != NEW.ROWID AND (NEW."geom" IS NULL OR ST_IsEmpty(NEW."geom")) BEGIN DELETE FROM "rtree_mpt3dzm_geom" WHERE id IN (OLD.ROWID, NEW.ROWID); END(aAtriggerrtree_mpt3dzm_geom_update3mpt3dzmCREATE TRIGGER "rtree_mpt3dzm_geom_update3" AFTER UPDATE OF "geom" ON "mpt3dzm" WHEN OLD.ROWID != NEW.ROWID AND (NEW."geom" NOT NULL AND NOT ST_IsEmpty(NEW."geom")) BEGIN DELETE FROM "rtree_mpt3dzm_geom" WHERE id = OLD.ROWID; INSERT OR REPLACE INTO "rtree_mpt3dzm_geom" VALUES (NEW.ROWID, ST_MinX(NEW."geom"), ST_MaxX(NEW."geom"), ST_MinY(NEW."geom"), ST_MaxY(NEW."geom")); END {Zhtablempt3dzmpt3dzCREATE TABLE "mpt3dz" ( "id" "INTEGER" NOT NULL, "name" "TEXT" NOT NULL, geom BLOB, CONSTRAINT "pk_mpt3dz" PRIMARY KEY ("id"))g??=tablertree_mpt3dzm_geom_parentrtree_mpt3dzm_geom_parentCREATE TABLE "rtree_mpt3dzm_geom_parent"(nodeno INTEGER PRIMARY KEY, parentnode INTEGER)f==1tablertree_mpt3dzm_geom_rowidrtree_mpt3dzm_geom_rowidCREATE TABLE "rtree_mpt3dzm_geom_rowid"(rowid INTEGER PRIMARY KEY, nodeno INTEGER) e;;'tablertree_mpt3dzm_geom_nodertree_mpt3dzm_geom_nodeCREATE TABLE "rtree_mpt3dzm_geom_node"(nodeno INTEGER PRIMARY KEY, data BLOB)d11/tablertree_mpt3dzm_geomrtree_mpt3dzm_geomCREATE VIRTUAL TABLE "rtree_mpt3dzm_geom" USING rtree(id, minx, maxx, miny, maxy) 99D @@@@A AA AA A @@     0 deltaX(gammaGP$@$@@@$@@?tbbetaGP$@4@$@4@$@4@@4@$@@X(alphaGP@@@@@@@   oi-#triggerfgti_mpt3dz_geommpt3dzCREATE TRIGGER "fgti_mpt3dz_geom" BEFORE INSERT ON "mpt3dz" FOR EACH ROW BEGIN SELECT RAISE (ROLLBACK, 'insert on "mpt3dz" violates constraint: ST_GeometryType("geom") is not assignable from gpkg_geometry_columns.geometry_type_name value') WHERE (SELECT geometry_type_name FROM gpkg_geometry_columns WHERE Lower(table_name) = Lower('geom') AND Lower(column_name) = Lower('geom') AND gpkg_IsAssignable(geometry_type_name, ST_GeometryType(NEW."geom")) = 0); END WWk-triggerfgsi_mpt3dz_geommpt3dzCREATE TRIGGER "fgsi_mpt3dz_geom" BEFORE INSERT ON "mpt3dz" FOR EACH ROW BEGIN SELECT RAISE (ROLLBACK, 'insert on "mpt3dz" violates constraint: ST_SRID("geom") does not match gpkg_geometry_columns.srs_id value') WHERE (SELECT srs_id FROM gpkg_geometry_columns WHERE Lower(table_name) = Lower('geom') AND Lower(column_name) = Lower('geom') AND ST_SRID(NEW."geom") <> srs_id); ENDj-Ktriggerfgtu_mpt3dz_geommpt3dzCREATE TRIGGER "fgtu_mpt3dz_geom" BEFORE UPDATE OF "geom" ON "mpt3dz" FOR EACH ROW BEGIN SELECT RAISE (ROLLBACK, 'update of "mpt3dz" on "geom" violates constraint: ST_GeometryType("geom") is not assignable from gpkg_geometry_columns.geometry_type_name value') WHERE (SELECT geometry_type_name FROM gpkg_geometry_columns WHERE Lower(table_name) = Lower('geom') AND Lower(column_name) = Lower('geom') AND gpkg_IsAssignable(geometry_type_name, ST_GeometryType(NEW."geom")) = 0); END JEm=?triggerrtree_mpt3dz_geom_insertmpt3dzCREATE TRIGGER "rtree_mpt3dz_geom_insert" AFTER INSERT ON "mpt3dz" WHEN (new."geom" NOT NULL AND NOT ST_IsEmpty(NEW."geom")) BEGIN INSERT OR REPLACE INTO "rtree_mpt3dz_geom" VALUES (NEW.ROWID, ST_MinX(NEW."geom"), ST_MaxX(NEW."geom"), ST_MinY(NEW."geom"), ST_MaxY(NEW."geom")); END2l-)triggerfgsu_mpt3dz_geommpt3dzCREATE TRIGGER "fgsu_mpt3dz_geom" BEFORE UPDATE OF "geom" ON "mpt3dz" FOR EACH ROW BEGIN SELECT RAISE (ROLLBACK, 'update of "mpt3dz" on "geom" violates constraint: ST_SRID("geom") does not match gpkg_geometry_columns.srs_id value') WHERE (SELECT srs_id FROM gpkg_geometry_columns WHERE Lower(table_name) = Lower('geom') AND Lower(column_name) = Lower('geom') AND ST_SRID(NEW."geom") <> srs_id); END o?Ctriggerrtree_mpt3dz_geom_update2mpt3dzCREATE TRIGGER "rtree_mpt3dz_geom_update2" AFTER UPDATE OF "geom" ON "mpt3dz" WHEN OLD.ROWID = NEW.ROWID AND (NEW."geom" IS NULL OR ST_IsEmpty(NEW."geom")) BEGIN DELETE FROM "rtree_mpt3dz_geom" WHERE id = OLD.ROWID; ENDkn? triggerrtree_mpt3dz_geom_update1mpt3dzCREATE TRIGGER "rtree_mpt3dz_geom_update1" AFTER UPDATE OF "geom" ON "mpt3dz" WHEN OLD.ROWID = NEW.ROWID AND (NEW."geom" NOT NULL AND NOT ST_IsEmpty(NEW."geom")) BEGIN INSERT OR REPLACE INTO "rtree_mpt3dz_geom" VALUES (NEW.ROWID, ST_MinX(NEW."geom"), ST_MaxX(NEW."geom"), ST_MinY(NEW."geom"), ST_MaxY(NEW."geom")); END ZI{Fr=Atriggerrtree_mpt3dz_geom_deletempt3dzCREATE TRIGGER "rtree_mpt3dz_geom_delete" AFTER DELETE ON "mpt3dz"WHEN old."geom" NOT NULL BEGIN DELETE FROM "rtree_mpt3dz_geom" WHERE id = OLD.ROWID; END q?Mtriggerrtree_mpt3dz_geom_update4mpt3dzCREATE TRIGGER "rtree_mpt3dz_geom_update4" AFTER UPDATE ON "mpt3dz" WHEN OLD.ROWID != NEW.ROWID AND (NEW."geom" IS NULL OR ST_IsEmpty(NEW."geom")) BEGIN DELETE FROM "rtree_mpt3dz_geom" WHERE id IN (OLD.ROWID, NEW.ROWID); END"p?wtriggerrtree_mpt3dz_geom_update3mpt3dzCREATE TRIGGER "rtree_mpt3dz_geom_update3" AFTER UPDATE OF "geom" ON "mpt3dz" WHEN OLD.ROWID != NEW.ROWID AND (NEW."geom" NOT NULL AND NOT ST_IsEmpty(NEW."geom")) BEGIN DELETE FROM "rtree_mpt3dz_geom" WHERE id = OLD.ROWID; INSERT OR REPLACE INTO "rtree_mpt3dz_geom" VALUES (NEW.ROWID, ST_MinX(NEW."geom"), ST_MaxX(NEW."geom"), ST_MinY(NEW."geom"), ST_MaxY(NEW."geom")); END ,d,wtablempt2dmmpt2dm CREATE TABLE "mpt2dm" ( "id" "INTEGER" NOT NULL, "name" "TEXT" NOT NULL, geom BLOB, CONSTRAINT "pk_mpt2dm" PRIMARY KEY ("id"))v==;tablertree_mpt3dz_geom_parentrtree_mpt3dz_geom_parentCREATE TABLE "rtree_mpt3dz_geom_parent"(nodeno INTEGER PRIMARY KEY, parentnode INTEGER) u;;/tablertree_mpt3dz_geom_rowidrtree_mpt3dz_geom_rowidCREATE TABLE "rtree_mpt3dz_geom_rowid"(rowid INTEGER PRIMARY KEY, nodeno INTEGER)t99%tablertree_mpt3dz_geom_nodertree_mpt3dz_geom_nodeCREATE TABLE "rtree_mpt3dz_geom_node"(nodeno INTEGER PRIMARY KEY, data BLOB)~s//-tablertree_mpt3dz_geomrtree_mpt3dz_geomCREATE VIRTUAL TABLE "rtree_mpt3dz_geom" USING rtree(id, minx, maxx, miny, maxy) 99D @@@@A AA AA A @@     0 deltaX(gammaGP$@$@@@$@@?tbbetaGP$@4@$@4@$@4@@4@$@@X(alphaGP@@@@@@@   ox-#triggerfgti_mpt2dm_geommpt2dmCREATE TRIGGER "fgti_mpt2dm_geom" BEFORE INSERT ON "mpt2dm" FOR EACH ROW BEGIN SELECT RAISE (ROLLBACK, 'insert on "mpt2dm" violates constraint: ST_GeometryType("geom") is not assignable from gpkg_geometry_columns.geometry_type_name value') WHERE (SELECT geometry_type_name FROM gpkg_geometry_columns WHERE Lower(table_name) = Lower('geom') AND Lower(column_name) = Lower('geom') AND gpkg_IsAssignable(geometry_type_name, ST_GeometryType(NEW."geom")) = 0); END WWz-triggerfgsi_mpt2dm_geommpt2dmCREATE TRIGGER "fgsi_mpt2dm_geom" BEFORE INSERT ON "mpt2dm" FOR EACH ROW BEGIN SELECT RAISE (ROLLBACK, 'insert on "mpt2dm" violates constraint: ST_SRID("geom") does not match gpkg_geometry_columns.srs_id value') WHERE (SELECT srs_id FROM gpkg_geometry_columns WHERE Lower(table_name) = Lower('geom') AND Lower(column_name) = Lower('geom') AND ST_SRID(NEW."geom") <> srs_id); ENDy-Ktriggerfgtu_mpt2dm_geommpt2dmCREATE TRIGGER "fgtu_mpt2dm_geom" BEFORE UPDATE OF "geom" ON "mpt2dm" FOR EACH ROW BEGIN SELECT RAISE (ROLLBACK, 'update of "mpt2dm" on "geom" violates constraint: ST_GeometryType("geom") is not assignable from gpkg_geometry_columns.geometry_type_name value') WHERE (SELECT geometry_type_name FROM gpkg_geometry_columns WHERE Lower(table_name) = Lower('geom') AND Lower(column_name) = Lower('geom') AND gpkg_IsAssignable(geometry_type_name, ST_GeometryType(NEW."geom")) = 0); END JE|=?triggerrtree_mpt2dm_geom_insertmpt2dmCREATE TRIGGER "rtree_mpt2dm_geom_insert" AFTER INSERT ON "mpt2dm" WHEN (new."geom" NOT NULL AND NOT ST_IsEmpty(NEW."geom")) BEGIN INSERT OR REPLACE INTO "rtree_mpt2dm_geom" VALUES (NEW.ROWID, ST_MinX(NEW."geom"), ST_MaxX(NEW."geom"), ST_MinY(NEW."geom"), ST_MaxY(NEW."geom")); END2{-)triggerfgsu_mpt2dm_geommpt2dmCREATE TRIGGER "fgsu_mpt2dm_geom" BEFORE UPDATE OF "geom" ON "mpt2dm" FOR EACH ROW BEGIN SELECT RAISE (ROLLBACK, 'update of "mpt2dm" on "geom" violates constraint: ST_SRID("geom") does not match gpkg_geometry_columns.srs_id value') WHERE (SELECT srs_id FROM gpkg_geometry_columns WHERE Lower(table_name) = Lower('geom') AND Lower(column_name) = Lower('geom') AND ST_SRID(NEW."geom") <> srs_id); END gSX `gPM3U!gc2dmgeomgpkg_srs_id_triggerGeoPackage 1.0 Specification Annex Nwrite-onlyWLAU!gc2dmgeomgpkg_geometry_type_triggerGeoPackage 1.0 Specification Annex Nwrite-onlyLK-U!gc2dgeomgpkg_rtree_indexGeoPackage 1.0 Specification Annex Lwrite-onlyOJ3U!gc2dgeomgpkg_srs_id_triggerGeoPackage 1.0 Specification Annex Nwrite-onlyVIAU!gc2dgeomgpkg_geometry_type_triggerGeoPackage 1.0 Specification Annex Nwrite-onlyMH-U!mpt2dgeomgpkg_rtree_indexGeoPackage 1.0 Specification Annex Lwrite-onlyPG3U!mpt2dgeomgpkg_srs_id_triggerGeoPackage 1.0 Specification Annex Nwrite-onlyWFAU!mpt2dgeomgpkg_geometry_type_triggerGeoPackage 1.0 Specification Annex Nwrite-onlyNE-U!mpt2dmgeomgpkg_rtree_indexGeoPackage 1.0 Specification Annex Lwrite-onlyQD3U!mpt2dmgeomgpkg_srs_id_triggerGeoPackage 1.0 Specification Annex Nwrite-onlyXCAU!mpt2dmgeomgpkg_geometry_type_triggerGeoPackage 1.0 Specification Annex Nwrite-only ~?Ctriggerrtree_mpt2dm_geom_update2mpt2dmCREATE TRIGGER "rtree_mpt2dm_geom_update2" AFTER UPDATE OF "geom" ON "mpt2dm" WHEN OLD.ROWID = NEW.ROWID AND (NEW."geom" IS NULL OR ST_IsEmpty(NEW."geom")) BEGIN DELETE FROM "rtree_mpt2dm_geom" WHERE id = OLD.ROWID; ENDk}? triggerrtree_mpt2dm_geom_update1mpt2dmCREATE TRIGGER "rtree_mpt2dm_geom_update1" AFTER UPDATE OF "geom" ON "mpt2dm" WHEN OLD.ROWID = NEW.ROWID AND (NEW."geom" NOT NULL AND NOT ST_IsEmpty(NEW."geom")) BEGIN INSERT OR REPLACE INTO "rtree_mpt2dm_geom" VALUES (NEW.ROWID, ST_MinX(NEW."geom"), ST_MaxX(NEW."geom"), ST_MinY(NEW."geom"), ST_MaxY(NEW."geom")); END ZI{F=Atriggerrtree_mpt2dm_geom_deletempt2dmCREATE TRIGGER "rtree_mpt2dm_geom_delete" AFTER DELETE ON "mpt2dm"WHEN old."geom" NOT NULL BEGIN DELETE FROM "rtree_mpt2dm_geom" WHERE id = OLD.ROWID; END ?Mtriggerrtree_mpt2dm_geom_update4mpt2dmCREATE TRIGGER "rtree_mpt2dm_geom_update4" AFTER UPDATE ON "mpt2dm" WHEN OLD.ROWID != NEW.ROWID AND (NEW."geom" IS NULL OR ST_IsEmpty(NEW."geom")) BEGIN DELETE FROM "rtree_mpt2dm_geom" WHERE id IN (OLD.ROWID, NEW.ROWID); END"?wtriggerrtree_mpt2dm_geom_update3mpt2dmCREATE TRIGGER "rtree_mpt2dm_geom_update3" AFTER UPDATE OF "geom" ON "mpt2dm" WHEN OLD.ROWID != NEW.ROWID AND (NEW."geom" NOT NULL AND NOT ST_IsEmpty(NEW."geom")) BEGIN DELETE FROM "rtree_mpt2dm_geom" WHERE id = OLD.ROWID; INSERT OR REPLACE INTO "rtree_mpt2dm_geom" VALUES (NEW.ROWID, ST_MinX(NEW."geom"), ST_MaxX(NEW."geom"), ST_MinY(NEW."geom"), ST_MaxY(NEW."geom")); END 0d0 tablempt2dmpt2dCREATE TABLE "mpt2d" ( "id" "INTEGER" NOT NULL, "name" "TEXT" NOT NULL, geom BLOB, CONSTRAINT "pk_mpt2d" PRIMARY KEY ("id"))==;tablertree_mpt2dm_geom_parentrtree_mpt2dm_geom_parentCREATE TABLE "rtree_mpt2dm_geom_parent"(nodeno INTEGER PRIMARY KEY, parentnode INTEGER) ;;/tablertree_mpt2dm_geom_rowidrtree_mpt2dm_geom_rowidCREATE TABLE "rtree_mpt2dm_geom_rowid"(rowid INTEGER PRIMARY KEY, nodeno INTEGER)99%tablertree_mpt2dm_geom_nodertree_mpt2dm_geom_nodeCREATE TABLE "rtree_mpt2dm_geom_node"(nodeno INTEGER PRIMARY KEY, data BLOB)~//-tablertree_mpt2dm_geomrtree_mpt2dm_geomCREATE VIRTUAL TABLE "rtree_mpt2dm_geom" USING rtree(id, minx, maxx, miny, maxy) 99D @@@@A AA AA A @@     H deltaPgammaGP@@"@"@@"@dBbetaGP$@4@$@4@$@4@4@$@PalphaGP@@@@@@ ~+Etriggerfgtu_mpt2d_geommpt2dCREATE TRIGGER "fgtu_mpt2d_geom" BEFORE UPDATE OF "geom" ON "mpt2d" FOR EACH ROW BEGIN SELECT RAISE (ROLLBACK, 'update of "mpt2d" on "geom" violates constraint: ST_GeometryType("geom") is not assignable from gpkg_geometry_columns.geometry_type_name value') WHERE (SELECT geometry_type_name FROM gpkg_geometry_columns WHERE Lower(table_name) = Lower('geom') AND Lower(column_name) = Lower('geom') AND gpkg_IsAssignable(geometry_type_name, ST_GeometryType(NEW."geom")) = 0); ENDj+triggerfgti_mpt2d_geommpt2dCREATE TRIGGER "fgti_mpt2d_geom" BEFORE INSERT ON "mpt2d" FOR EACH ROW BEGIN SELECT RAISE (ROLLBACK, 'insert on "mpt2d" violates constraint: ST_GeometryType("geom") is not assignable from gpkg_geometry_columns.geometry_type_name value') WHERE (SELECT geometry_type_name FROM gpkg_geometry_columns WHERE Lower(table_name) = Lower('geom') AND Lower(column_name) = Lower('geom') AND gpkg_IsAssignable(geometry_type_name, ST_GeometryType(NEW."geom")) = 0); END c- +#triggerfgsu_mpt2d_geommpt2dCREATE TRIGGER "fgsu_mpt2d_geom" BEFORE UPDATE OF "geom" ON "mpt2d" FOR EACH ROW BEGIN SELECT RAISE (ROLLBACK, 'update of "mpt2d" on "geom" violates constraint: ST_SRID("geom") does not match gpkg_geometry_columns.srs_id value') WHERE (SELECT srs_id FROM gpkg_geometry_columns WHERE Lower(table_name) = Lower('geom') AND Lower(column_name) = Lower('geom') AND ST_SRID(NEW."geom") <> srs_id); END +{triggerfgsi_mpt2d_geommpt2dCREATE TRIGGER "fgsi_mpt2d_geom" BEFORE INSERT ON "mpt2d" FOR EACH ROW BEGIN SELECT RAISE (ROLLBACK, 'insert on "mpt2d" violates constraint: ST_SRID("geom") does not match gpkg_geometry_columns.srs_id value') WHERE (SELECT srs_id FROM gpkg_geometry_columns WHERE Lower(table_name) = Lower('geom') AND Lower(column_name) = Lower('geom') AND ST_SRID(NEW."geom") <> srs_id); END KRK ==triggerrtree_mpt2d_geom_update2mpt2dCREATE TRIGGER "rtree_mpt2d_geom_update2" AFTER UPDATE OF "geom" ON "mpt2d" WHEN OLD.ROWID = NEW.ROWID AND (NEW."geom" IS NULL OR ST_IsEmpty(NEW."geom")) BEGIN DELETE FROM "rtree_mpt2d_geom" WHERE id = OLD.ROWID; ENDf =triggerrtree_mpt2d_geom_update1mpt2dCREATE TRIGGER "rtree_mpt2d_geom_update1" AFTER UPDATE OF "geom" ON "mpt2d" WHEN OLD.ROWID = NEW.ROWID AND (NEW."geom" NOT NULL AND NOT ST_IsEmpty(NEW."geom")) BEGIN INSERT OR REPLACE INTO "rtree_mpt2d_geom" VALUES (NEW.ROWID, ST_MinX(NEW."geom"), ST_MaxX(NEW."geom"), ST_MinY(NEW."geom"), ST_MaxY(NEW."geom")); END@ ;9triggerrtree_mpt2d_geom_insertmpt2dCREATE TRIGGER "rtree_mpt2d_geom_insert" AFTER INSERT ON "mpt2d" WHEN (new."geom" NOT NULL AND NOT ST_IsEmpty(NEW."geom")) BEGIN INSERT OR REPLACE INTO "rtree_mpt2d_geom" VALUES (NEW.ROWID, ST_MinX(NEW."geom"), ST_MaxX(NEW."geom"), ST_MinY(NEW."geom"), ST_MaxY(NEW."geom")); END `T{--+tablertree_mpt2d_geomrtree_mpt2d_geomCREATE VIRTUAL TABLE "rtree_mpt2d_geom" USING rtree(id, minx, maxx, miny, maxy)A;;triggerrtree_mpt2d_geom_deletempt2dCREATE TRIGGER "rtree_mpt2d_geom_delete" AFTER DELETE ON "mpt2d"WHEN old."geom" NOT NULL BEGIN DELETE FROM "rtree_mpt2d_geom" WHERE id = OLD.ROWID; END=Gtriggerrtree_mpt2d_geom_update4mpt2dCREATE TRIGGER "rtree_mpt2d_geom_update4" AFTER UPDATE ON "mpt2d" WHEN OLD.ROWID != NEW.ROWID AND (NEW."geom" IS NULL OR ST_IsEmpty(NEW."geom")) BEGIN DELETE FROM "rtree_mpt2d_geom" WHERE id IN (OLD.ROWID, NEW.ROWID); END=otriggerrtree_mpt2d_geom_update3mpt2dCREATE TRIGGER "rtree_mpt2d_geom_update3" AFTER UPDATE OF "geom" ON "mpt2d" WHEN OLD.ROWID != NEW.ROWID AND (NEW."geom" NOT NULL AND NOT ST_IsEmpty(NEW."geom")) BEGIN DELETE FROM "rtree_mpt2d_geom" WHERE id = OLD.ROWID; INSERT OR REPLACE INTO "rtree_mpt2d_geom" VALUES (NEW.ROWID, ST_MinX(NEW."geom"), ST_MaxX(NEW."geom"), ST_MinY(NEW."geom"), ST_MaxY(NEW."geom")); END 99D @@@@A AA A@@AA yUtablegc2dgc2dCREATE TABLE "gc2d" ( "id" "INTEGER" NOT NULL, "name" "TEXT" NOT NULL, geom BLOB, CONSTRAINT "pk_gc2d" PRIMARY KEY ("id"));;9tablertree_mpt2d_geom_parentrtree_mpt2d_geom_parentCREATE TABLE "rtree_mpt2d_geom_parent"(nodeno INTEGER PRIMARY KEY, parentnode INTEGER) 99-tablertree_mpt2d_geom_rowidrtree_mpt2d_geom_rowidCREATE TABLE "rtree_mpt2d_geom_rowid"(rowid INTEGER PRIMARY KEY, nodeno INTEGER)77#tablertree_mpt2d_geom_nodertree_mpt2d_geom_nodeCREATE TABLE "rtree_mpt2d_geom_node"(nodeno INTEGER PRIMARY KEY, data BLOB)     `UPgammaGP"@"@@@"@@xjbetaGP@4@@4@@@$@$@4@4@ delta2alphaGP?6@@6@?@5@5@6@5@5@6@5@5@ y)?triggerfgtu_gc2d_geomgc2dCREATE TRIGGER "fgtu_gc2d_geom" BEFORE UPDATE OF "geom" ON "gc2d" FOR EACH ROW BEGIN SELECT RAISE (ROLLBACK, 'update of "gc2d" on "geom" violates constraint: ST_GeometryType("geom") is not assignable from gpkg_geometry_columns.geometry_type_name value') WHERE (SELECT geometry_type_name FROM gpkg_geometry_columns WHERE Lower(table_name) = Lower('geom') AND Lower(column_name) = Lower('geom') AND gpkg_IsAssignable(geometry_type_name, ST_GeometryType(NEW."geom")) = 0); ENDe)triggerfgti_gc2d_geomgc2dCREATE TRIGGER "fgti_gc2d_geom" BEFORE INSERT ON "gc2d" FOR EACH ROW BEGIN SELECT RAISE (ROLLBACK, 'insert on "gc2d" violates constraint: ST_GeometryType("geom") is not assignable from gpkg_geometry_columns.geometry_type_name value') WHERE (SELECT geometry_type_name FROM gpkg_geometry_columns WHERE Lower(table_name) = Lower('geom') AND Lower(column_name) = Lower('geom') AND gpkg_IsAssignable(geometry_type_name, ST_GeometryType(NEW."geom")) = 0); END h()triggerfgsu_gc2d_geomgc2dCREATE TRIGGER "fgsu_gc2d_geom" BEFORE UPDATE OF "geom" ON "gc2d" FOR EACH ROW BEGIN SELECT RAISE (ROLLBACK, 'update of "gc2d" on "geom" violates constraint: ST_SRID("geom") does not match gpkg_geometry_columns.srs_id value') WHERE (SELECT srs_id FROM gpkg_geometry_columns WHERE Lower(table_name) = Lower('geom') AND Lower(column_name) = Lower('geom') AND ST_SRID(NEW."geom") <> srs_id); END)utriggerfgsi_gc2d_geomgc2dCREATE TRIGGER "fgsi_gc2d_geom" BEFORE INSERT ON "gc2d" FOR EACH ROW BEGIN SELECT RAISE (ROLLBACK, 'insert on "gc2d" violates constraint: ST_SRID("geom") does not match gpkg_geometry_columns.srs_id value') WHERE (SELECT srs_id FROM gpkg_geometry_columns WHERE Lower(table_name) = Lower('geom') AND Lower(column_name) = Lower('geom') AND ST_SRID(NEW."geom") <> srs_id); END Z\Z~;7triggerrtree_gc2d_geom_update2gc2dCREATE TRIGGER "rtree_gc2d_geom_update2" AFTER UPDATE OF "geom" ON "gc2d" WHEN OLD.ROWID = NEW.ROWID AND (NEW."geom" IS NULL OR ST_IsEmpty(NEW."geom")) BEGIN DELETE FROM "rtree_gc2d_geom" WHERE id = OLD.ROWID; ENDa;}triggerrtree_gc2d_geom_update1gc2dCREATE TRIGGER "rtree_gc2d_geom_update1" AFTER UPDATE OF "geom" ON "gc2d" WHEN OLD.ROWID = NEW.ROWID AND (NEW."geom" NOT NULL AND NOT ST_IsEmpty(NEW."geom")) BEGIN INSERT OR REPLACE INTO "rtree_gc2d_geom" VALUES (NEW.ROWID, ST_MinX(NEW."geom"), ST_MaxX(NEW."geom"), ST_MinY(NEW."geom"), ST_MaxY(NEW."geom")); END;93triggerrtree_gc2d_geom_insertgc2dCREATE TRIGGER "rtree_gc2d_geom_insert" AFTER INSERT ON "gc2d" WHEN (new."geom" NOT NULL AND NOT ST_IsEmpty(NEW."geom")) BEGIN INSERT OR REPLACE INTO "rtree_gc2d_geom" VALUES (NEW.ROWID, ST_MinX(NEW."geom"), ST_MaxX(NEW."geom"), ST_MinY(NEW."geom"), ST_MaxY(NEW."geom")); END $f_$ x ++)tablertree_gc2d_geomrtree_gc2d_geomCREATE VIRTUAL TABLE "rtree_gc2d_geom" USING rtree(id, minx, maxx, miny, maxy)<95triggerrtree_gc2d_geom_deletegc2dCREATE TRIGGER "rtree_gc2d_geom_delete" AFTER DELETE ON "gc2d"WHEN old."geom" NOT NULL BEGIN DELETE FROM "rtree_gc2d_geom" WHERE id = OLD.ROWID; END;Atriggerrtree_gc2d_geom_update4gc2dCREATE TRIGGER "rtree_gc2d_geom_update4" AFTER UPDATE ON "gc2d" WHEN OLD.ROWID != NEW.ROWID AND (NEW."geom" IS NULL OR ST_IsEmpty(NEW."geom")) BEGIN DELETE FROM "rtree_gc2d_geom" WHERE id IN (OLD.ROWID, NEW.ROWID); END;gtriggerrtree_gc2d_geom_update3gc2dCREATE TRIGGER "rtree_gc2d_geom_update3" AFTER UPDATE OF "geom" ON "gc2d" WHEN OLD.ROWID != NEW.ROWID AND (NEW."geom" NOT NULL AND NOT ST_IsEmpty(NEW."geom")) BEGIN DELETE FROM "rtree_gc2d_geom" WHERE id = OLD.ROWID; INSERT OR REPLACE INTO "rtree_gc2d_geom" VALUES (NEW.ROWID, ST_MinX(NEW."geom"), ST_MaxX(NEW."geom"), ST_MinY(NEW."geom"), ST_MaxY(NEW."geom")); END 99D ?A@@A@A@@AAA@@ |^$ tablegc2dmgc2dm&CREATE TABLE "gc2dm" ( "id" "INTEGER" NOT NULL, "name" "TEXT" NOT NULL, geom BLOB, CONSTRAINT "pk_gc2dm" PRIMARY KEY ("id"))#997tablertree_gc2d_geom_parentrtree_gc2d_geom_parent%CREATE TABLE "rtree_gc2d_geom_parent"(nodeno INTEGER PRIMARY KEY, parentnode INTEGER)"77+tablertree_gc2d_geom_rowidrtree_gc2d_geom_rowid$CREATE TABLE "rtree_gc2d_geom_rowid"(rowid INTEGER PRIMARY KEY, nodeno INTEGER)!55!tablertree_gc2d_geom_nodertree_gc2d_geom_node"CREATE TABLE "rtree_gc2d_geom_node"(nodeno INTEGER PRIMARY KEY, data BLOB)     @8-@X(gammaGP"@"@@@"@@@betaGP@4@@4@@@@$@$@@4@4@ @ deltaEalphaGP?6@@6@?@@5@5@@6@5@@5@6@ @5@5@@ ~&+Etriggerfgtu_gc2dm_geomgc2dmCREATE TRIGGER "fgtu_gc2dm_geom" BEFORE UPDATE OF "geom" ON "gc2dm" FOR EACH ROW BEGIN SELECT RAISE (ROLLBACK, 'update of "gc2dm" on "geom" violates constraint: ST_GeometryType("geom") is not assignable from gpkg_geometry_columns.geometry_type_name value') WHERE (SELECT geometry_type_name FROM gpkg_geometry_columns WHERE Lower(table_name) = Lower('geom') AND Lower(column_name) = Lower('geom') AND gpkg_IsAssignable(geometry_type_name, ST_GeometryType(NEW."geom")) = 0); ENDj%+triggerfgti_gc2dm_geomgc2dmCREATE TRIGGER "fgti_gc2dm_geom" BEFORE INSERT ON "gc2dm" FOR EACH ROW BEGIN SELECT RAISE (ROLLBACK, 'insert on "gc2dm" violates constraint: ST_GeometryType("geom") is not assignable from gpkg_geometry_columns.geometry_type_name value') WHERE (SELECT geometry_type_name FROM gpkg_geometry_columns WHERE Lower(table_name) = Lower('geom') AND Lower(column_name) = Lower('geom') AND gpkg_IsAssignable(geometry_type_name, ST_GeometryType(NEW."geom")) = 0); END c-(+#triggerfgsu_gc2dm_geomgc2dmCREATE TRIGGER "fgsu_gc2dm_geom" BEFORE UPDATE OF "geom" ON "gc2dm" FOR EACH ROW BEGIN SELECT RAISE (ROLLBACK, 'update of "gc2dm" on "geom" violates constraint: ST_SRID("geom") does not match gpkg_geometry_columns.srs_id value') WHERE (SELECT srs_id FROM gpkg_geometry_columns WHERE Lower(table_name) = Lower('geom') AND Lower(column_name) = Lower('geom') AND ST_SRID(NEW."geom") <> srs_id); END'+{triggerfgsi_gc2dm_geomgc2dmCREATE TRIGGER "fgsi_gc2dm_geom" BEFORE INSERT ON "gc2dm" FOR EACH ROW BEGIN SELECT RAISE (ROLLBACK, 'insert on "gc2dm" violates constraint: ST_SRID("geom") does not match gpkg_geometry_columns.srs_id value') WHERE (SELECT srs_id FROM gpkg_geometry_columns WHERE Lower(table_name) = Lower('geom') AND Lower(column_name) = Lower('geom') AND ST_SRID(NEW."geom") <> srs_id); END KRK+==triggerrtree_gc2dm_geom_update2gc2dmCREATE TRIGGER "rtree_gc2dm_geom_update2" AFTER UPDATE OF "geom" ON "gc2dm" WHEN OLD.ROWID = NEW.ROWID AND (NEW."geom" IS NULL OR ST_IsEmpty(NEW."geom")) BEGIN DELETE FROM "rtree_gc2dm_geom" WHERE id = OLD.ROWID; ENDf*=triggerrtree_gc2dm_geom_update1gc2dmCREATE TRIGGER "rtree_gc2dm_geom_update1" AFTER UPDATE OF "geom" ON "gc2dm" WHEN OLD.ROWID = NEW.ROWID AND (NEW."geom" NOT NULL AND NOT ST_IsEmpty(NEW."geom")) BEGIN INSERT OR REPLACE INTO "rtree_gc2dm_geom" VALUES (NEW.ROWID, ST_MinX(NEW."geom"), ST_MaxX(NEW."geom"), ST_MinY(NEW."geom"), ST_MaxY(NEW."geom")); END@);9triggerrtree_gc2dm_geom_insertgc2dmCREATE TRIGGER "rtree_gc2dm_geom_insert" AFTER INSERT ON "gc2dm" WHEN (new."geom" NOT NULL AND NOT ST_IsEmpty(NEW."geom")) BEGIN INSERT OR REPLACE INTO "rtree_gc2dm_geom" VALUES (NEW.ROWID, ST_MinX(NEW."geom"), ST_MaxX(NEW."geom"), ST_MinY(NEW."geom"), ST_MaxY(NEW."geom")); END `T{/--+tablertree_gc2dm_geomrtree_gc2dm_geomCREATE VIRTUAL TABLE "rtree_gc2dm_geom" USING rtree(id, minx, maxx, miny, maxy)A.;;triggerrtree_gc2dm_geom_deletegc2dmCREATE TRIGGER "rtree_gc2dm_geom_delete" AFTER DELETE ON "gc2dm"WHEN old."geom" NOT NULL BEGIN DELETE FROM "rtree_gc2dm_geom" WHERE id = OLD.ROWID; END-=Gtriggerrtree_gc2dm_geom_update4gc2dmCREATE TRIGGER "rtree_gc2dm_geom_update4" AFTER UPDATE ON "gc2dm" WHEN OLD.ROWID != NEW.ROWID AND (NEW."geom" IS NULL OR ST_IsEmpty(NEW."geom")) BEGIN DELETE FROM "rtree_gc2dm_geom" WHERE id IN (OLD.ROWID, NEW.ROWID); END,=otriggerrtree_gc2dm_geom_update3gc2dmCREATE TRIGGER "rtree_gc2dm_geom_update3" AFTER UPDATE OF "geom" ON "gc2dm" WHEN OLD.ROWID != NEW.ROWID AND (NEW."geom" NOT NULL AND NOT ST_IsEmpty(NEW."geom")) BEGIN DELETE FROM "rtree_gc2dm_geom" WHERE id = OLD.ROWID; INSERT OR REPLACE INTO "rtree_gc2dm_geom" VALUES (NEW.ROWID, ST_MinX(NEW."geom"), ST_MaxX(NEW."geom"), ST_MinY(NEW."geom"), ST_MaxY(NEW."geom")); END 99D ?A@@A@A@@AAA@@ yU3 tablegc3dzgc3dz0CREATE TABLE "gc3dz" ( "id" "INTEGER" NOT NULL, "name" "TEXT" NOT NULL, geom BLOB, CONSTRAINT "pk_gc3dz" PRIMARY KEY ("id"))2;;9tablertree_gc2dm_geom_parentrtree_gc2dm_geom_parent.CREATE TABLE "rtree_gc2dm_geom_parent"(nodeno INTEGER PRIMARY KEY, parentnode INTEGER) 199-tablertree_gc2dm_geom_rowidrtree_gc2dm_geom_rowid-CREATE TABLE "rtree_gc2dm_geom_rowid"(rowid INTEGER PRIMARY KEY, nodeno INTEGER)077#tablertree_gc2dm_geom_nodertree_gc2dm_geom_node+CREATE TABLE "rtree_gc2dm_geom_node"(nodeno INTEGER PRIMARY KEY, data BLOB)     `X] _ `XXAU!geo3dzgeomgpkg_geometry_type_triggerGeoPackage 1.0 Specification Annex Nwrite-onlyOW-U!geo3dzmgeomgpkg_rtree_indexGeoPackage 1.0 Specification Annex Lwrite-onlyRV3U!geo3dzmgeomgpkg_srs_id_triggerGeoPackage 1.0 Specification Annex Nwrite-onlyYUAU!geo3dzmgeomgpkg_geometry_type_triggerGeoPackage 1.0 Specification Annex Nwrite-onlyNT-U!gc3dzmgeomgpkg_rtree_indexGeoPackage 1.0 Specification Annex Lwrite-onlyQS3U!gc3dzmgeomgpkg_srs_id_triggerGeoPackage 1.0 Specification Annex Nwrite-onlyXRAU!gc3dzmgeomgpkg_geometry_type_triggerGeoPackage 1.0 Specification Annex Nwrite-onlyMQ-U!gc3dzgeomgpkg_rtree_indexGeoPackage 1.0 Specification Annex Lwrite-onlyPP3U!gc3dzgeomgpkg_srs_id_triggerGeoPackage 1.0 Specification Annex Nwrite-onlyWOAU!gc3dzgeomgpkg_geometry_type_triggerGeoPackage 1.0 Specification Annex Nwrite-onlyMN-U!gc2dmgeomgpkg_rtree_indexGeoPackage 1.0 Specification Annex Lwrite-only @8-@X(gammaGP"@"@@@"@@@betaGP@4@@4@@@@$@$@@4@4@ @ deltaEalphaGP?6@@6@?@@5@5@@6@5@@5@6@ @5@5@@ ~5+Etriggerfgtu_gc3dz_geomgc3dzCREATE TRIGGER "fgtu_gc3dz_geom" BEFORE UPDATE OF "geom" ON "gc3dz" FOR EACH ROW BEGIN SELECT RAISE (ROLLBACK, 'update of "gc3dz" on "geom" violates constraint: ST_GeometryType("geom") is not assignable from gpkg_geometry_columns.geometry_type_name value') WHERE (SELECT geometry_type_name FROM gpkg_geometry_columns WHERE Lower(table_name) = Lower('geom') AND Lower(column_name) = Lower('geom') AND gpkg_IsAssignable(geometry_type_name, ST_GeometryType(NEW."geom")) = 0); ENDj4+triggerfgti_gc3dz_geomgc3dzCREATE TRIGGER "fgti_gc3dz_geom" BEFORE INSERT ON "gc3dz" FOR EACH ROW BEGIN SELECT RAISE (ROLLBACK, 'insert on "gc3dz" violates constraint: ST_GeometryType("geom") is not assignable from gpkg_geometry_columns.geometry_type_name value') WHERE (SELECT geometry_type_name FROM gpkg_geometry_columns WHERE Lower(table_name) = Lower('geom') AND Lower(column_name) = Lower('geom') AND gpkg_IsAssignable(geometry_type_name, ST_GeometryType(NEW."geom")) = 0); END c-7+#triggerfgsu_gc3dz_geomgc3dzCREATE TRIGGER "fgsu_gc3dz_geom" BEFORE UPDATE OF "geom" ON "gc3dz" FOR EACH ROW BEGIN SELECT RAISE (ROLLBACK, 'update of "gc3dz" on "geom" violates constraint: ST_SRID("geom") does not match gpkg_geometry_columns.srs_id value') WHERE (SELECT srs_id FROM gpkg_geometry_columns WHERE Lower(table_name) = Lower('geom') AND Lower(column_name) = Lower('geom') AND ST_SRID(NEW."geom") <> srs_id); END6+{triggerfgsi_gc3dz_geomgc3dzCREATE TRIGGER "fgsi_gc3dz_geom" BEFORE INSERT ON "gc3dz" FOR EACH ROW BEGIN SELECT RAISE (ROLLBACK, 'insert on "gc3dz" violates constraint: ST_SRID("geom") does not match gpkg_geometry_columns.srs_id value') WHERE (SELECT srs_id FROM gpkg_geometry_columns WHERE Lower(table_name) = Lower('geom') AND Lower(column_name) = Lower('geom') AND ST_SRID(NEW."geom") <> srs_id); END )Mu#Mm$3test_pkgeomgpkg_srs_id_triggerb+Atest_pkgeomgpkg_geometry_type_triggera#3pg3dzmgeomgpkg_srs_id_trigger#'A pt2dgeomgpkg_geometry_type_trigger-pt2dgeomgpkg_rtree_index!3pt2dgeomgpkg_srs_id_trigger)Apt2dmgeomgpkg_geometry_type_trigger-pt2dmgeomgpkg_rtree_index"3pt2dmgeomgpkg_srs_id_trigger)Apt3dzgeomgpkg_geometry_type_trigger-pt3dzgeomgpkg_rtree_index "3pt3dzgeomgpkg_srs_id_trigger*Apt3dzmgeomgpkg_geometry_type_trigger -pt3dzmgeomgpkg_rtree_index #3pt3dzmgeomgpkg_srs_id_trigger KRK:==triggerrtree_gc3dz_geom_update2gc3dzCREATE TRIGGER "rtree_gc3dz_geom_update2" AFTER UPDATE OF "geom" ON "gc3dz" WHEN OLD.ROWID = NEW.ROWID AND (NEW."geom" IS NULL OR ST_IsEmpty(NEW."geom")) BEGIN DELETE FROM "rtree_gc3dz_geom" WHERE id = OLD.ROWID; ENDf9=triggerrtree_gc3dz_geom_update1gc3dzCREATE TRIGGER "rtree_gc3dz_geom_update1" AFTER UPDATE OF "geom" ON "gc3dz" WHEN OLD.ROWID = NEW.ROWID AND (NEW."geom" NOT NULL AND NOT ST_IsEmpty(NEW."geom")) BEGIN INSERT OR REPLACE INTO "rtree_gc3dz_geom" VALUES (NEW.ROWID, ST_MinX(NEW."geom"), ST_MaxX(NEW."geom"), ST_MinY(NEW."geom"), ST_MaxY(NEW."geom")); END@8;9triggerrtree_gc3dz_geom_insertgc3dzCREATE TRIGGER "rtree_gc3dz_geom_insert" AFTER INSERT ON "gc3dz" WHEN (new."geom" NOT NULL AND NOT ST_IsEmpty(NEW."geom")) BEGIN INSERT OR REPLACE INTO "rtree_gc3dz_geom" VALUES (NEW.ROWID, ST_MinX(NEW."geom"), ST_MaxX(NEW."geom"), ST_MinY(NEW."geom"), ST_MaxY(NEW."geom")); END `T{>--+tablertree_gc3dz_geomrtree_gc3dz_geomCREATE VIRTUAL TABLE "rtree_gc3dz_geom" USING rtree(id, minx, maxx, miny, maxy)A=;;triggerrtree_gc3dz_geom_deletegc3dzCREATE TRIGGER "rtree_gc3dz_geom_delete" AFTER DELETE ON "gc3dz"WHEN old."geom" NOT NULL BEGIN DELETE FROM "rtree_gc3dz_geom" WHERE id = OLD.ROWID; END<=Gtriggerrtree_gc3dz_geom_update4gc3dzCREATE TRIGGER "rtree_gc3dz_geom_update4" AFTER UPDATE ON "gc3dz" WHEN OLD.ROWID != NEW.ROWID AND (NEW."geom" IS NULL OR ST_IsEmpty(NEW."geom")) BEGIN DELETE FROM "rtree_gc3dz_geom" WHERE id IN (OLD.ROWID, NEW.ROWID); END;=otriggerrtree_gc3dz_geom_update3gc3dzCREATE TRIGGER "rtree_gc3dz_geom_update3" AFTER UPDATE OF "geom" ON "gc3dz" WHEN OLD.ROWID != NEW.ROWID AND (NEW."geom" NOT NULL AND NOT ST_IsEmpty(NEW."geom")) BEGIN DELETE FROM "rtree_gc3dz_geom" WHERE id = OLD.ROWID; INSERT OR REPLACE INTO "rtree_gc3dz_geom" VALUES (NEW.ROWID, ST_MinX(NEW."geom"), ST_MaxX(NEW."geom"), ST_MinY(NEW."geom"), ST_MaxY(NEW."geom")); END 99D ?A@@A@A@@AAA@@ yUBtablegc3dzmgc3dzm:CREATE TABLE "gc3dzm" ( "id" "INTEGER" NOT NULL, "name" "TEXT" NOT NULL, geom BLOB, CONSTRAINT "pk_gc3dzm" PRIMARY KEY ("id"))A;;9tablertree_gc3dz_geom_parentrtree_gc3dz_geom_parent9CREATE TABLE "rtree_gc3dz_geom_parent"(nodeno INTEGER PRIMARY KEY, parentnode INTEGER) @99-tablertree_gc3dz_geom_rowidrtree_gc3dz_geom_rowid8CREATE TABLE "rtree_gc3dz_geom_rowid"(rowid INTEGER PRIMARY KEY, nodeno INTEGER)?77#tablertree_gc3dz_geom_nodertree_gc3dz_geom_node6CREATE TABLE "rtree_gc3dz_geom_node"(nodeno INTEGER PRIMARY KEY, data BLOB)     e delta`8gammaGP"@"@@@  "@@@@(JbetaGP@4@@4@  @@@ @ $@$@@?4@4@ @@mRalphaGP?6@@6@  ?@@@ 5@5@@@6@5@@@5@6@ @ @5@5@@@   oC-#triggerfgti_gc3dzm_geomgc3dzmCREATE TRIGGER "fgti_gc3dzm_geom" BEFORE INSERT ON "gc3dzm" FOR EACH ROW BEGIN SELECT RAISE (ROLLBACK, 'insert on "gc3dzm" violates constraint: ST_GeometryType("geom") is not assignable from gpkg_geometry_columns.geometry_type_name value') WHERE (SELECT geometry_type_name FROM gpkg_geometry_columns WHERE Lower(table_name) = Lower('geom') AND Lower(column_name) = Lower('geom') AND gpkg_IsAssignable(geometry_type_name, ST_GeometryType(NEW."geom")) = 0); END WWE-triggerfgsi_gc3dzm_geomgc3dzmCREATE TRIGGER "fgsi_gc3dzm_geom" BEFORE INSERT ON "gc3dzm" FOR EACH ROW BEGIN SELECT RAISE (ROLLBACK, 'insert on "gc3dzm" violates constraint: ST_SRID("geom") does not match gpkg_geometry_columns.srs_id value') WHERE (SELECT srs_id FROM gpkg_geometry_columns WHERE Lower(table_name) = Lower('geom') AND Lower(column_name) = Lower('geom') AND ST_SRID(NEW."geom") <> srs_id); ENDD-Ktriggerfgtu_gc3dzm_geomgc3dzmCREATE TRIGGER "fgtu_gc3dzm_geom" BEFORE UPDATE OF "geom" ON "gc3dzm" FOR EACH ROW BEGIN SELECT RAISE (ROLLBACK, 'update of "gc3dzm" on "geom" violates constraint: ST_GeometryType("geom") is not assignable from gpkg_geometry_columns.geometry_type_name value') WHERE (SELECT geometry_type_name FROM gpkg_geometry_columns WHERE Lower(table_name) = Lower('geom') AND Lower(column_name) = Lower('geom') AND gpkg_IsAssignable(geometry_type_name, ST_GeometryType(NEW."geom")) = 0); END JEG=?triggerrtree_gc3dzm_geom_insertgc3dzmCREATE TRIGGER "rtree_gc3dzm_geom_insert" AFTER INSERT ON "gc3dzm" WHEN (new."geom" NOT NULL AND NOT ST_IsEmpty(NEW."geom")) BEGIN INSERT OR REPLACE INTO "rtree_gc3dzm_geom" VALUES (NEW.ROWID, ST_MinX(NEW."geom"), ST_MaxX(NEW."geom"), ST_MinY(NEW."geom"), ST_MaxY(NEW."geom")); END2F-)triggerfgsu_gc3dzm_geomgc3dzmCREATE TRIGGER "fgsu_gc3dzm_geom" BEFORE UPDATE OF "geom" ON "gc3dzm" FOR EACH ROW BEGIN SELECT RAISE (ROLLBACK, 'update of "gc3dzm" on "geom" violates constraint: ST_SRID("geom") does not match gpkg_geometry_columns.srs_id value') WHERE (SELECT srs_id FROM gpkg_geometry_columns WHERE Lower(table_name) = Lower('geom') AND Lower(column_name) = Lower('geom') AND ST_SRID(NEW."geom") <> srs_id); END I?Ctriggerrtree_gc3dzm_geom_update2gc3dzmCREATE TRIGGER "rtree_gc3dzm_geom_update2" AFTER UPDATE OF "geom" ON "gc3dzm" WHEN OLD.ROWID = NEW.ROWID AND (NEW."geom" IS NULL OR ST_IsEmpty(NEW."geom")) BEGIN DELETE FROM "rtree_gc3dzm_geom" WHERE id = OLD.ROWID; ENDkH? triggerrtree_gc3dzm_geom_update1gc3dzmCREATE TRIGGER "rtree_gc3dzm_geom_update1" AFTER UPDATE OF "geom" ON "gc3dzm" WHEN OLD.ROWID = NEW.ROWID AND (NEW."geom" NOT NULL AND NOT ST_IsEmpty(NEW."geom")) BEGIN INSERT OR REPLACE INTO "rtree_gc3dzm_geom" VALUES (NEW.ROWID, ST_MinX(NEW."geom"), ST_MaxX(NEW."geom"), ST_MinY(NEW."geom"), ST_MaxY(NEW."geom")); END ZI{FL=Atriggerrtree_gc3dzm_geom_deletegc3dzmCREATE TRIGGER "rtree_gc3dzm_geom_delete" AFTER DELETE ON "gc3dzm"WHEN old."geom" NOT NULL BEGIN DELETE FROM "rtree_gc3dzm_geom" WHERE id = OLD.ROWID; END K?Mtriggerrtree_gc3dzm_geom_update4gc3dzmCREATE TRIGGER "rtree_gc3dzm_geom_update4" AFTER UPDATE ON "gc3dzm" WHEN OLD.ROWID != NEW.ROWID AND (NEW."geom" IS NULL OR ST_IsEmpty(NEW."geom")) BEGIN DELETE FROM "rtree_gc3dzm_geom" WHERE id IN (OLD.ROWID, NEW.ROWID); END"J?wtriggerrtree_gc3dzm_geom_update3gc3dzmCREATE TRIGGER "rtree_gc3dzm_geom_update3" AFTER UPDATE OF "geom" ON "gc3dzm" WHEN OLD.ROWID != NEW.ROWID AND (NEW."geom" NOT NULL AND NOT ST_IsEmpty(NEW."geom")) BEGIN DELETE FROM "rtree_gc3dzm_geom" WHERE id = OLD.ROWID; INSERT OR REPLACE INTO "rtree_gc3dzm_geom" VALUES (NEW.ROWID, ST_MinX(NEW."geom"), ST_MaxX(NEW."geom"), ST_MinY(NEW."geom"), ST_MaxY(NEW."geom")); END (d(Qtablegeo3dzmgeo3dzmDCREATE TABLE "geo3dzm" ( "id" "INTEGER" NOT NULL, "name" "TEXT" NOT NULL, geom BLOB, CONSTRAINT "pk_geo3dzm" PRIMARY KEY ("id"))P==;tablertree_gc3dzm_geom_parentrtree_gc3dzm_geom_parentCCREATE TABLE "rtree_gc3dzm_geom_parent"(nodeno INTEGER PRIMARY KEY, parentnode INTEGER) O;;/tablertree_gc3dzm_geom_rowidrtree_gc3dzm_geom_rowidBCREATE TABLE "rtree_gc3dzm_geom_rowid"(rowid INTEGER PRIMARY KEY, nodeno INTEGER)N99%tablertree_gc3dzm_geom_nodertree_gc3dzm_geom_nodeACREATE TABLE "rtree_gc3dzm_geom_node"(nodeno INTEGER PRIMARY KEY, data BLOB)~M//-tablertree_gc3dzm_geomrtree_gc3dzm_geomCREATE VIRTUAL TABLE "rtree_gc3dzm_geom" USING rtree(id, minx, maxx, miny, maxy) 99D ?A@@A@A@@AAA@@     +i^W"epsilonGP4@?@4@?@  4@4@@@5@4@@@4@5@@@4@4@@@ >@>@@@?@>@@@>@?@@@>@>@@@ delta?vgammaGP4@5@4@5@ 4@4@@@5@4@@@4@5@@@4@4@@@znbetaGP&@(@@ @ &@@@@(@ @@@W&alphaGP$@$@@@ $@@@@ tR/)triggerfgti_geo3dzm_geomgeo3dzmCREATE TRIGGER "fgti_geo3dzm_geom" BEFORE INSERT ON "geo3dzm" FOR EACH ROW BEGIN SELECT RAISE (ROLLBACK, 'insert on "geo3dzm" violates constraint: ST_GeometryType("geom") is not assignable from gpkg_geometry_columns.geometry_type_name value') WHERE (SELECT geometry_type_name FROM gpkg_geometry_columns WHERE Lower(table_name) = Lower('geom') AND Lower(column_name) = Lower('geom') AND gpkg_IsAssignable(geometry_type_name, ST_GeometryType(NEW."geom")) = 0); END MM#T/triggerfgsi_geo3dzm_geomgeo3dzmCREATE TRIGGER "fgsi_geo3dzm_geom" BEFORE INSERT ON "geo3dzm" FOR EACH ROW BEGIN SELECT RAISE (ROLLBACK, 'insert on "geo3dzm" violates constraint: ST_SRID("geom") does not match gpkg_geometry_columns.srs_id value') WHERE (SELECT srs_id FROM gpkg_geometry_columns WHERE Lower(table_name) = Lower('geom') AND Lower(column_name) = Lower('geom') AND ST_SRID(NEW."geom") <> srs_id); ENDS/Qtriggerfgtu_geo3dzm_geomgeo3dzmCREATE TRIGGER "fgtu_geo3dzm_geom" BEFORE UPDATE OF "geom" ON "geo3dzm" FOR EACH ROW BEGIN SELECT RAISE (ROLLBACK, 'update of "geo3dzm" on "geom" violates constraint: ST_GeometryType("geom") is not assignable from gpkg_geometry_columns.geometry_type_name value') WHERE (SELECT geometry_type_name FROM gpkg_geometry_columns WHERE Lower(table_name) = Lower('geom') AND Lower(column_name) = Lower('geom') AND gpkg_IsAssignable(geometry_type_name, ST_GeometryType(NEW."geom")) = 0); END EJV?Etriggerrtree_geo3dzm_geom_insertgeo3dzmCREATE TRIGGER "rtree_geo3dzm_geom_insert" AFTER INSERT ON "geo3dzm" WHEN (new."geom" NOT NULL AND NOT ST_IsEmpty(NEW."geom")) BEGIN INSERT OR REPLACE INTO "rtree_geo3dzm_geom" VALUES (NEW.ROWID, ST_MinX(NEW."geom"), ST_MaxX(NEW."geom"), ST_MinY(NEW."geom"), ST_MaxY(NEW."geom")); END7U//triggerfgsu_geo3dzm_geomgeo3dzmCREATE TRIGGER "fgsu_geo3dzm_geom" BEFORE UPDATE OF "geom" ON "geo3dzm" FOR EACH ROW BEGIN SELECT RAISE (ROLLBACK, 'update of "geo3dzm" on "geom" violates constraint: ST_SRID("geom") does not match gpkg_geometry_columns.srs_id value') WHERE (SELECT srs_id FROM gpkg_geometry_columns WHERE Lower(table_name) = Lower('geom') AND Lower(column_name) = Lower('geom') AND ST_SRID(NEW."geom") <> srs_id); END {{ XAItriggerrtree_geo3dzm_geom_update2geo3dzmCREATE TRIGGER "rtree_geo3dzm_geom_update2" AFTER UPDATE OF "geom" ON "geo3dzm" WHEN OLD.ROWID = NEW.ROWID AND (NEW."geom" IS NULL OR ST_IsEmpty(NEW."geom")) BEGIN DELETE FROM "rtree_geo3dzm_geom" WHERE id = OLD.ROWID; ENDpWAtriggerrtree_geo3dzm_geom_update1geo3dzmCREATE TRIGGER "rtree_geo3dzm_geom_update1" AFTER UPDATE OF "geom" ON "geo3dzm" WHEN OLD.ROWID = NEW.ROWID AND (NEW."geom" NOT NULL AND NOT ST_IsEmpty(NEW."geom")) BEGIN INSERT OR REPLACE INTO "rtree_geo3dzm_geom" VALUES (NEW.ROWID, ST_MinX(NEW."geom"), ST_MaxX(NEW."geom"), ST_MinY(NEW."geom"), ST_MaxY(NEW."geom")); END oT>okK[?Gtriggerrtree_geo3dzm_geom_deletegeo3dzmCREATE TRIGGER "rtree_geo3dzm_geom_delete" AFTER DELETE ON "geo3dzm"WHEN old."geom" NOT NULL BEGIN DELETE FROM "rtree_geo3dzm_geom" WHERE id = OLD.ROWID; ENDZAStriggerrtree_geo3dzm_geom_update4geo3dzmCREATE TRIGGER "rtree_geo3dzm_geom_update4" AFTER UPDATE ON "geo3dzm" WHEN OLD.ROWID != NEW.ROWID AND (NEW."geom" IS NULL OR ST_IsEmpty(NEW."geom")) BEGIN DELETE FROM "rtree_geo3dzm_geom" WHERE id IN (OLD.ROWID, NEW.ROWID); END(YAtriggerrtree_geo3dzm_geom_update3geo3dzmCREATE TRIGGER "rtree_geo3dzm_geom_update3" AFTER UPDATE OF "geom" ON "geo3dzm" WHEN OLD.ROWID != NEW.ROWID AND (NEW."geom" NOT NULL AND NOT ST_IsEmpty(NEW."geom")) BEGIN DELETE FROM "rtree_geo3dzm_geom" WHERE id = OLD.ROWID; INSERT OR REPLACE INTO "rtree_geo3dzm_geom" VALUES (NEW.ROWID, ST_MinX(NEW."geom"), ST_MaxX(NEW."geom"), ST_MinY(NEW."geom"), ST_MaxY(NEW."geom")); END {Z`tablegeo3dzgeo3dzNCREATE TABLE "geo3dz" ( "id" "INTEGER" NOT NULL, "name" "TEXT" NOT NULL, geom BLOB, CONSTRAINT "pk_geo3dz" PRIMARY KEY ("id"))_??=tablertree_geo3dzm_geom_parentrtree_geo3dzm_geom_parentMCREATE TABLE "rtree_geo3dzm_geom_parent"(nodeno INTEGER PRIMARY KEY, parentnode INTEGER)^==1tablertree_geo3dzm_geom_rowidrtree_geo3dzm_geom_rowidLCREATE TABLE "rtree_geo3dzm_geom_rowid"(rowid INTEGER PRIMARY KEY, nodeno INTEGER) ];;'tablertree_geo3dzm_geom_nodertree_geo3dzm_geom_nodeKCREATE TABLE "rtree_geo3dzm_geom_node"(nodeno INTEGER PRIMARY KEY, data BLOB)\11/tablertree_geo3dzm_geomrtree_geo3dzm_geomCREATE VIRTUAL TABLE "rtree_geo3dzm_geom" USING rtree(id, minx, maxx, miny, maxy) 99D A A @@A0A@@AAAAAAAAA      |C|"epsilonGP4@?@4@?@4@4@@5@4@@4@5@@4@4@@>@>@@?@>@@>@?@@>@>@@ delta6gammaGP4@5@4@5@4@4@@5@4@@4@5@@4@4@@jNbetaGP&@(@@ @&@@@(@ @@OalphaGP$@$@@@$@@@   oa-#triggerfgti_geo3dz_geomgeo3dzCREATE TRIGGER "fgti_geo3dz_geom" BEFORE INSERT ON "geo3dz" FOR EACH ROW BEGIN SELECT RAISE (ROLLBACK, 'insert on "geo3dz" violates constraint: ST_GeometryType("geom") is not assignable from gpkg_geometry_columns.geometry_type_name value') WHERE (SELECT geometry_type_name FROM gpkg_geometry_columns WHERE Lower(table_name) = Lower('geom') AND Lower(column_name) = Lower('geom') AND gpkg_IsAssignable(geometry_type_name, ST_GeometryType(NEW."geom")) = 0); END WWc-triggerfgsi_geo3dz_geomgeo3dzCREATE TRIGGER "fgsi_geo3dz_geom" BEFORE INSERT ON "geo3dz" FOR EACH ROW BEGIN SELECT RAISE (ROLLBACK, 'insert on "geo3dz" violates constraint: ST_SRID("geom") does not match gpkg_geometry_columns.srs_id value') WHERE (SELECT srs_id FROM gpkg_geometry_columns WHERE Lower(table_name) = Lower('geom') AND Lower(column_name) = Lower('geom') AND ST_SRID(NEW."geom") <> srs_id); ENDb-Ktriggerfgtu_geo3dz_geomgeo3dzCREATE TRIGGER "fgtu_geo3dz_geom" BEFORE UPDATE OF "geom" ON "geo3dz" FOR EACH ROW BEGIN SELECT RAISE (ROLLBACK, 'update of "geo3dz" on "geom" violates constraint: ST_GeometryType("geom") is not assignable from gpkg_geometry_columns.geometry_type_name value') WHERE (SELECT geometry_type_name FROM gpkg_geometry_columns WHERE Lower(table_name) = Lower('geom') AND Lower(column_name) = Lower('geom') AND gpkg_IsAssignable(geometry_type_name, ST_GeometryType(NEW."geom")) = 0); END JEe=?triggerrtree_geo3dz_geom_insertgeo3dzCREATE TRIGGER "rtree_geo3dz_geom_insert" AFTER INSERT ON "geo3dz" WHEN (new."geom" NOT NULL AND NOT ST_IsEmpty(NEW."geom")) BEGIN INSERT OR REPLACE INTO "rtree_geo3dz_geom" VALUES (NEW.ROWID, ST_MinX(NEW."geom"), ST_MaxX(NEW."geom"), ST_MinY(NEW."geom"), ST_MaxY(NEW."geom")); END2d-)triggerfgsu_geo3dz_geomgeo3dzCREATE TRIGGER "fgsu_geo3dz_geom" BEFORE UPDATE OF "geom" ON "geo3dz" FOR EACH ROW BEGIN SELECT RAISE (ROLLBACK, 'update of "geo3dz" on "geom" violates constraint: ST_SRID("geom") does not match gpkg_geometry_columns.srs_id value') WHERE (SELECT srs_id FROM gpkg_geometry_columns WHERE Lower(table_name) = Lower('geom') AND Lower(column_name) = Lower('geom') AND ST_SRID(NEW."geom") <> srs_id); END ]`f Rb3U!test_pkgeomgpkg_srs_id_triggerGeoPackage 1.0 Specification Annex Nwrite-onlyYaAU!test_pkgeomgpkg_geometry_type_triggerGeoPackage 1.0 Specification Annex Nwrite-onlyM`-U!geo2dgeomgpkg_rtree_indexGeoPackage 1.0 Specification Annex Lwrite-onlyP_3U!geo2dgeomgpkg_srs_id_triggerGeoPackage 1.0 Specification Annex Nwrite-onlyW^AU!geo2dgeomgpkg_geometry_type_triggerGeoPackage 1.0 Specification Annex Nwrite-onlyN]-U!geo2dmgeomgpkg_rtree_indexGeoPackage 1.0 Specification Annex Lwrite-onlyQ\3U!geo2dmgeomgpkg_srs_id_triggerGeoPackage 1.0 Specification Annex Nwrite-onlyX[AU!geo2dmgeomgpkg_geometry_type_triggerGeoPackage 1.0 Specification Annex Nwrite-onlyNZ-U!geo3dzgeomgpkg_rtree_indexGeoPackage 1.0 Specification Annex Lwrite-onlyQY3U!geo3dzgeomgpkg_srs_id_triggerGeoPackage 1.0 Specification Annex Nwrite-only g?Ctriggerrtree_geo3dz_geom_update2geo3dzCREATE TRIGGER "rtree_geo3dz_geom_update2" AFTER UPDATE OF "geom" ON "geo3dz" WHEN OLD.ROWID = NEW.ROWID AND (NEW."geom" IS NULL OR ST_IsEmpty(NEW."geom")) BEGIN DELETE FROM "rtree_geo3dz_geom" WHERE id = OLD.ROWID; ENDkf? triggerrtree_geo3dz_geom_update1geo3dzCREATE TRIGGER "rtree_geo3dz_geom_update1" AFTER UPDATE OF "geom" ON "geo3dz" WHEN OLD.ROWID = NEW.ROWID AND (NEW."geom" NOT NULL AND NOT ST_IsEmpty(NEW."geom")) BEGIN INSERT OR REPLACE INTO "rtree_geo3dz_geom" VALUES (NEW.ROWID, ST_MinX(NEW."geom"), ST_MaxX(NEW."geom"), ST_MinY(NEW."geom"), ST_MaxY(NEW."geom")); END ZI{Fj=Atriggerrtree_geo3dz_geom_deletegeo3dzCREATE TRIGGER "rtree_geo3dz_geom_delete" AFTER DELETE ON "geo3dz"WHEN old."geom" NOT NULL BEGIN DELETE FROM "rtree_geo3dz_geom" WHERE id = OLD.ROWID; END i?Mtriggerrtree_geo3dz_geom_update4geo3dzCREATE TRIGGER "rtree_geo3dz_geom_update4" AFTER UPDATE ON "geo3dz" WHEN OLD.ROWID != NEW.ROWID AND (NEW."geom" IS NULL OR ST_IsEmpty(NEW."geom")) BEGIN DELETE FROM "rtree_geo3dz_geom" WHERE id IN (OLD.ROWID, NEW.ROWID); END"h?wtriggerrtree_geo3dz_geom_update3geo3dzCREATE TRIGGER "rtree_geo3dz_geom_update3" AFTER UPDATE OF "geom" ON "geo3dz" WHEN OLD.ROWID != NEW.ROWID AND (NEW."geom" NOT NULL AND NOT ST_IsEmpty(NEW."geom")) BEGIN DELETE FROM "rtree_geo3dz_geom" WHERE id = OLD.ROWID; INSERT OR REPLACE INTO "rtree_geo3dz_geom" VALUES (NEW.ROWID, ST_MinX(NEW."geom"), ST_MaxX(NEW."geom"), ST_MinY(NEW."geom"), ST_MaxY(NEW."geom")); END ,d,otablegeo2dmgeo2dmZCREATE TABLE "geo2dm" ( "id" "INTEGER" NOT NULL, "name" "TEXT" NOT NULL, geom BLOB, CONSTRAINT "pk_geo2dm" PRIMARY KEY ("id"))n==;tablertree_geo3dz_geom_parentrtree_geo3dz_geom_parentXCREATE TABLE "rtree_geo3dz_geom_parent"(nodeno INTEGER PRIMARY KEY, parentnode INTEGER) m;;/tablertree_geo3dz_geom_rowidrtree_geo3dz_geom_rowidWCREATE TABLE "rtree_geo3dz_geom_rowid"(rowid INTEGER PRIMARY KEY, nodeno INTEGER)l99%tablertree_geo3dz_geom_nodertree_geo3dz_geom_nodeVCREATE TABLE "rtree_geo3dz_geom_node"(nodeno INTEGER PRIMARY KEY, data BLOB)~k//-tablertree_geo3dz_geomrtree_geo3dz_geomCREATE VIRTUAL TABLE "rtree_geo3dz_geom" USING rtree(id, minx, maxx, miny, maxy) 99D A A @@A0A@@AAAAAAAAA      B>! =test_pkfeaturestest_pk 2014-05-22T09:02:22.751Z < =geo2dfeaturesgeo2d 2014-05-22T09:02:22.625Z > =geo2dmfeaturesgeo2dm 2014-05-22T09:02:22.368Z > =geo3dzfeaturesgeo3dz 2014-05-22T09:02:22.201Z  |C|"epsilonGP4@?@4@?@4@4@@5@4@@4@5@@4@4@@>@>@@?@>@@>@?@@>@>@@ delta6gammaGP4@5@4@5@4@4@@5@4@@4@5@@4@4@@jNbetaGP&@(@@ @&@@@(@ @@OalphaGP$@$@@@$@@@   op-#triggerfgti_geo2dm_geomgeo2dmCREATE TRIGGER "fgti_geo2dm_geom" BEFORE INSERT ON "geo2dm" FOR EACH ROW BEGIN SELECT RAISE (ROLLBACK, 'insert on "geo2dm" violates constraint: ST_GeometryType("geom") is not assignable from gpkg_geometry_columns.geometry_type_name value') WHERE (SELECT geometry_type_name FROM gpkg_geometry_columns WHERE Lower(table_name) = Lower('geom') AND Lower(column_name) = Lower('geom') AND gpkg_IsAssignable(geometry_type_name, ST_GeometryType(NEW."geom")) = 0); END WWr-triggerfgsi_geo2dm_geomgeo2dmCREATE TRIGGER "fgsi_geo2dm_geom" BEFORE INSERT ON "geo2dm" FOR EACH ROW BEGIN SELECT RAISE (ROLLBACK, 'insert on "geo2dm" violates constraint: ST_SRID("geom") does not match gpkg_geometry_columns.srs_id value') WHERE (SELECT srs_id FROM gpkg_geometry_columns WHERE Lower(table_name) = Lower('geom') AND Lower(column_name) = Lower('geom') AND ST_SRID(NEW."geom") <> srs_id); ENDq-Ktriggerfgtu_geo2dm_geomgeo2dmCREATE TRIGGER "fgtu_geo2dm_geom" BEFORE UPDATE OF "geom" ON "geo2dm" FOR EACH ROW BEGIN SELECT RAISE (ROLLBACK, 'update of "geo2dm" on "geom" violates constraint: ST_GeometryType("geom") is not assignable from gpkg_geometry_columns.geometry_type_name value') WHERE (SELECT geometry_type_name FROM gpkg_geometry_columns WHERE Lower(table_name) = Lower('geom') AND Lower(column_name) = Lower('geom') AND gpkg_IsAssignable(geometry_type_name, ST_GeometryType(NEW."geom")) = 0); END JEt=?triggerrtree_geo2dm_geom_insertgeo2dmCREATE TRIGGER "rtree_geo2dm_geom_insert" AFTER INSERT ON "geo2dm" WHEN (new."geom" NOT NULL AND NOT ST_IsEmpty(NEW."geom")) BEGIN INSERT OR REPLACE INTO "rtree_geo2dm_geom" VALUES (NEW.ROWID, ST_MinX(NEW."geom"), ST_MaxX(NEW."geom"), ST_MinY(NEW."geom"), ST_MaxY(NEW."geom")); END2s-)triggerfgsu_geo2dm_geomgeo2dmCREATE TRIGGER "fgsu_geo2dm_geom" BEFORE UPDATE OF "geom" ON "geo2dm" FOR EACH ROW BEGIN SELECT RAISE (ROLLBACK, 'update of "geo2dm" on "geom" violates constraint: ST_SRID("geom") does not match gpkg_geometry_columns.srs_id value') WHERE (SELECT srs_id FROM gpkg_geometry_columns WHERE Lower(table_name) = Lower('geom') AND Lower(column_name) = Lower('geom') AND ST_SRID(NEW."geom") <> srs_id); END v?Ctriggerrtree_geo2dm_geom_update2geo2dmCREATE TRIGGER "rtree_geo2dm_geom_update2" AFTER UPDATE OF "geom" ON "geo2dm" WHEN OLD.ROWID = NEW.ROWID AND (NEW."geom" IS NULL OR ST_IsEmpty(NEW."geom")) BEGIN DELETE FROM "rtree_geo2dm_geom" WHERE id = OLD.ROWID; ENDku? triggerrtree_geo2dm_geom_update1geo2dmCREATE TRIGGER "rtree_geo2dm_geom_update1" AFTER UPDATE OF "geom" ON "geo2dm" WHEN OLD.ROWID = NEW.ROWID AND (NEW."geom" NOT NULL AND NOT ST_IsEmpty(NEW."geom")) BEGIN INSERT OR REPLACE INTO "rtree_geo2dm_geom" VALUES (NEW.ROWID, ST_MinX(NEW."geom"), ST_MaxX(NEW."geom"), ST_MinY(NEW."geom"), ST_MaxY(NEW."geom")); END ZI{Fy=Atriggerrtree_geo2dm_geom_deletegeo2dmCREATE TRIGGER "rtree_geo2dm_geom_delete" AFTER DELETE ON "geo2dm"WHEN old."geom" NOT NULL BEGIN DELETE FROM "rtree_geo2dm_geom" WHERE id = OLD.ROWID; END x?Mtriggerrtree_geo2dm_geom_update4geo2dmCREATE TRIGGER "rtree_geo2dm_geom_update4" AFTER UPDATE ON "geo2dm" WHEN OLD.ROWID != NEW.ROWID AND (NEW."geom" IS NULL OR ST_IsEmpty(NEW."geom")) BEGIN DELETE FROM "rtree_geo2dm_geom" WHERE id IN (OLD.ROWID, NEW.ROWID); END"w?wtriggerrtree_geo2dm_geom_update3geo2dmCREATE TRIGGER "rtree_geo2dm_geom_update3" AFTER UPDATE OF "geom" ON "geo2dm" WHEN OLD.ROWID != NEW.ROWID AND (NEW."geom" NOT NULL AND NOT ST_IsEmpty(NEW."geom")) BEGIN DELETE FROM "rtree_geo2dm_geom" WHERE id = OLD.ROWID; INSERT OR REPLACE INTO "rtree_geo2dm_geom" VALUES (NEW.ROWID, ST_MinX(NEW."geom"), ST_MaxX(NEW."geom"), ST_MinY(NEW."geom"), ST_MaxY(NEW."geom")); END 0d0~ tablegeo2dgeo2deCREATE TABLE "geo2d" ( "id" "INTEGER" NOT NULL, "name" "TEXT" NOT NULL, geom BLOB, CONSTRAINT "pk_geo2d" PRIMARY KEY ("id"))}==;tablertree_geo2dm_geom_parentrtree_geo2dm_geom_parentcCREATE TABLE "rtree_geo2dm_geom_parent"(nodeno INTEGER PRIMARY KEY, parentnode INTEGER) |;;/tablertree_geo2dm_geom_rowidrtree_geo2dm_geom_rowidbCREATE TABLE "rtree_geo2dm_geom_rowid"(rowid INTEGER PRIMARY KEY, nodeno INTEGER){99%tablertree_geo2dm_geom_nodertree_geo2dm_geom_nodeaCREATE TABLE "rtree_geo2dm_geom_node"(nodeno INTEGER PRIMARY KEY, data BLOB)~z//-tablertree_geo2dm_geomrtree_geo2dm_geomCREATE VIRTUAL TABLE "rtree_geo2dm_geom" USING rtree(id, minx, maxx, miny, maxy) 99D A A @@A0A@@AAAAAAAAA      JJl%Eh!-mpt3dzmgeomgpkg_rtree_index?$3mpt3dzmgeomgpkg_srs_id_trigger>(Apg2dgeomgpkg_geometry_type_trigger-pg2dgeomgpkg_rtree_index!3pg2dgeomgpkg_srs_id_trigger)Apg2dmgeomgpkg_geometry_type_trigger-pg2dmgeomgpkg_rtree_index"3pg2dmgeomgpkg_srs_id_trigger)Apg3dzgeomgpkg_geometry_type_trigger-pg3dzgeomgpkg_rtree_index!"3pg3dzgeomgpkg_srs_id_trigger *Apg3dzmgeomgpkg_geometry_type_trigger" [W"epsilonGP4@?@4@?@4@4@5@4@4@5@4@4@>@>@?@>@>@?@>@>@ deltavgammaGP4@5@4@5@4@4@5@4@4@5@4@4@Z.betaGP&@(@@ @&@@(@ @GalphaGP$@$@@@$@@ HaC$ uT4eF(eH geo2dmgeomGEOMETRY geo3dzgeomGEOMETRY geo3dzmgeomGEOMETRY!) gc3dzmgeomGEOMCOLLECTION ) gc3dzgeomGEOMCOLLECTION ) gc2dmgeomGEOMCOLLECTION)gc2dgeomGEOMCOLLECTION!mpt2dgeomMULTIPOINT! mpt2dmgeomMULTIPOINT! mpt3dzgeomMULTIPOINT! mpt3dzmgeomMULTIPOINT#+ mln3dzmgeomMULTILINESTRING"+ mln3dzgeomMULTILINESTRING"+ mln2dmgeomMULTILINESTRING!+mln2dgeomMULTILINESTRING%mpg2dgeomMULTIPOLYGON% mpg2dmgeomMULTIPOLYGON% mpg3dzgeomMULTIPOLYGON % mpg3dzmgeomMULTIPOLYGON  pg3dzmgeomPOLYGON  pg3dzgeomPOLYGON  pg2dmgeomPOLYGON pg2dgeomPOLYGON! ln3dzmgeomLINESTRING! ln3dzgeomLINESTRING! ln2dmgeomLINESTRING!ln2dgeomLINESTRING pt3dzmgeomPOINT pt3dzgeomPOINT pt2dmgeomPOINTpt2dgeomPOINT !test_pkgeomGEOMETRY geo2dgeomGEOMETRY ~+Etriggerfgtu_geo2d_geomgeo2dCREATE TRIGGER "fgtu_geo2d_geom" BEFORE UPDATE OF "geom" ON "geo2d" FOR EACH ROW BEGIN SELECT RAISE (ROLLBACK, 'update of "geo2d" on "geom" violates constraint: ST_GeometryType("geom") is not assignable from gpkg_geometry_columns.geometry_type_name value') WHERE (SELECT geometry_type_name FROM gpkg_geometry_columns WHERE Lower(table_name) = Lower('geom') AND Lower(column_name) = Lower('geom') AND gpkg_IsAssignable(geometry_type_name, ST_GeometryType(NEW."geom")) = 0); ENDj+triggerfgti_geo2d_geomgeo2dCREATE TRIGGER "fgti_geo2d_geom" BEFORE INSERT ON "geo2d" FOR EACH ROW BEGIN SELECT RAISE (ROLLBACK, 'insert on "geo2d" violates constraint: ST_GeometryType("geom") is not assignable from gpkg_geometry_columns.geometry_type_name value') WHERE (SELECT geometry_type_name FROM gpkg_geometry_columns WHERE Lower(table_name) = Lower('geom') AND Lower(column_name) = Lower('geom') AND gpkg_IsAssignable(geometry_type_name, ST_GeometryType(NEW."geom")) = 0); END c-+#triggerfgsu_geo2d_geomgeo2dCREATE TRIGGER "fgsu_geo2d_geom" BEFORE UPDATE OF "geom" ON "geo2d" FOR EACH ROW BEGIN SELECT RAISE (ROLLBACK, 'update of "geo2d" on "geom" violates constraint: ST_SRID("geom") does not match gpkg_geometry_columns.srs_id value') WHERE (SELECT srs_id FROM gpkg_geometry_columns WHERE Lower(table_name) = Lower('geom') AND Lower(column_name) = Lower('geom') AND ST_SRID(NEW."geom") <> srs_id); END+{triggerfgsi_geo2d_geomgeo2dCREATE TRIGGER "fgsi_geo2d_geom" BEFORE INSERT ON "geo2d" FOR EACH ROW BEGIN SELECT RAISE (ROLLBACK, 'insert on "geo2d" violates constraint: ST_SRID("geom") does not match gpkg_geometry_columns.srs_id value') WHERE (SELECT srs_id FROM gpkg_geometry_columns WHERE Lower(table_name) = Lower('geom') AND Lower(column_name) = Lower('geom') AND ST_SRID(NEW."geom") <> srs_id); END KRK==triggerrtree_geo2d_geom_update2geo2dCREATE TRIGGER "rtree_geo2d_geom_update2" AFTER UPDATE OF "geom" ON "geo2d" WHEN OLD.ROWID = NEW.ROWID AND (NEW."geom" IS NULL OR ST_IsEmpty(NEW."geom")) BEGIN DELETE FROM "rtree_geo2d_geom" WHERE id = OLD.ROWID; ENDf=triggerrtree_geo2d_geom_update1geo2dCREATE TRIGGER "rtree_geo2d_geom_update1" AFTER UPDATE OF "geom" ON "geo2d" WHEN OLD.ROWID = NEW.ROWID AND (NEW."geom" NOT NULL AND NOT ST_IsEmpty(NEW."geom")) BEGIN INSERT OR REPLACE INTO "rtree_geo2d_geom" VALUES (NEW.ROWID, ST_MinX(NEW."geom"), ST_MaxX(NEW."geom"), ST_MinY(NEW."geom"), ST_MaxY(NEW."geom")); END@;9triggerrtree_geo2d_geom_insertgeo2dCREATE TRIGGER "rtree_geo2d_geom_insert" AFTER INSERT ON "geo2d" WHEN (new."geom" NOT NULL AND NOT ST_IsEmpty(NEW."geom")) BEGIN INSERT OR REPLACE INTO "rtree_geo2d_geom" VALUES (NEW.ROWID, ST_MinX(NEW."geom"), ST_MaxX(NEW."geom"), ST_MinY(NEW."geom"), ST_MaxY(NEW."geom")); END `T{ --+tablertree_geo2d_geomrtree_geo2d_geomCREATE VIRTUAL TABLE "rtree_geo2d_geom" USING rtree(id, minx, maxx, miny, maxy)A;;triggerrtree_geo2d_geom_deletegeo2dCREATE TRIGGER "rtree_geo2d_geom_delete" AFTER DELETE ON "geo2d"WHEN old."geom" NOT NULL BEGIN DELETE FROM "rtree_geo2d_geom" WHERE id = OLD.ROWID; END=Gtriggerrtree_geo2d_geom_update4geo2dCREATE TRIGGER "rtree_geo2d_geom_update4" AFTER UPDATE ON "geo2d" WHEN OLD.ROWID != NEW.ROWID AND (NEW."geom" IS NULL OR ST_IsEmpty(NEW."geom")) BEGIN DELETE FROM "rtree_geo2d_geom" WHERE id IN (OLD.ROWID, NEW.ROWID); END=otriggerrtree_geo2d_geom_update3geo2dCREATE TRIGGER "rtree_geo2d_geom_update3" AFTER UPDATE OF "geom" ON "geo2d" WHEN OLD.ROWID != NEW.ROWID AND (NEW."geom" NOT NULL AND NOT ST_IsEmpty(NEW."geom")) BEGIN DELETE FROM "rtree_geo2d_geom" WHERE id = OLD.ROWID; INSERT OR REPLACE INTO "rtree_geo2d_geom" VALUES (NEW.ROWID, ST_MinX(NEW."geom"), ST_MaxX(NEW."geom"), ST_MinY(NEW."geom"), ST_MaxY(NEW."geom")); END 99D A A @@A0A@@AAAAAAAAA Q$yU$ x Etabletest_pktest_pkpCREATE TABLE "test_pk" ( "first_name" "TEXT" NOT NULL, "last_name" "TEXT" NOT NULL, "value1" "DOUBLE" NOT NULL, "value2" "DOUBLE" NOT NULL, geom BLOB, CONSTRAINT "pk_test_pk" PRIMARY KEY ("last_name", "first_name")).Aindexsqlite_autoindex_test_pk_1test_pkq ;;9tablertree_geo2d_geom_parentrtree_geo2d_geom_parentoCREATE TABLE "rtree_geo2d_geom_parent"(nodeno INTEGER PRIMARY KEY, parentnode INTEGER) 99-tablertree_geo2d_geom_rowidrtree_geo2d_geom_rowidnCREATE TABLE "rtree_geo2d_geom_rowid"(rowid INTEGER PRIMARY KEY, nodeno INTEGER) 77#tablertree_geo2d_geom_nodertree_geo2d_geom_nodelCREATE TABLE "rtree_geo2d_geom_node"(nodeno INTEGER PRIMARY KEY, data BLOB)      YO.hepsilonfive@@I@GP@@"@"@@"@deltafour@@D333333r.gammathree@ ffffff@>LGP????vbetatwo@@4333333GP(@*@@@(@@*@@*@@(@@$alphaone?񙙙@$333333GP?????? fiveepsilonfourdeltathreegamma twobeta  onealpha t/)triggerfgti_test_pk_geomtest_pkCREATE TRIGGER "fgti_test_pk_geom" BEFORE INSERT ON "test_pk" FOR EACH ROW BEGIN SELECT RAISE (ROLLBACK, 'insert on "test_pk" violates constraint: ST_GeometryType("geom") is not assignable from gpkg_geometry_columns.geometry_type_name value') WHERE (SELECT geometry_type_name FROM gpkg_geometry_columns WHERE Lower(table_name) = Lower('geom') AND Lower(column_name) = Lower('geom') AND gpkg_IsAssignable(geometry_type_name, ST_GeometryType(NEW."geom")) = 0); END MM#/triggerfgsi_test_pk_geomtest_pkCREATE TRIGGER "fgsi_test_pk_geom" BEFORE INSERT ON "test_pk" FOR EACH ROW BEGIN SELECT RAISE (ROLLBACK, 'insert on "test_pk" violates constraint: ST_SRID("geom") does not match gpkg_geometry_columns.srs_id value') WHERE (SELECT srs_id FROM gpkg_geometry_columns WHERE Lower(table_name) = Lower('geom') AND Lower(column_name) = Lower('geom') AND ST_SRID(NEW."geom") <> srs_id); END/Qtriggerfgtu_test_pk_geomtest_pkCREATE TRIGGER "fgtu_test_pk_geom" BEFORE UPDATE OF "geom" ON "test_pk" FOR EACH ROW BEGIN SELECT RAISE (ROLLBACK, 'update of "test_pk" on "geom" violates constraint: ST_GeometryType("geom") is not assignable from gpkg_geometry_columns.geometry_type_name value') WHERE (SELECT geometry_type_name FROM gpkg_geometry_columns WHERE Lower(table_name) = Lower('geom') AND Lower(column_name) = Lower('geom') AND gpkg_IsAssignable(geometry_type_name, ST_GeometryType(NEW."geom")) = 0); END EEOOWb7//triggerfgsu_test_pk_geomtest_pkCREATE TRIGGER "fgsu_test_pk_geom" BEFORE UPDATE OF "geom" ON "test_pk" FOR EACH ROW BEGIN SELECT RAISE (ROLLBACK, 'update of "test_pk" on "geom" violates constraint: ST_SRID("geom") does not match gpkg_geometry_columns.srs_id value') WHERE (SELECT srs_id FROM gpkg_geometry_columns WHERE Lower(table_name) = Lower('geom') AND Lower(column_name) = Lower('geom') AND ST_SRID(NEW."geom") <> srs_id); ENDxvwu