SQLite format 3@  'GPKG.zq   h <'ueUndefined SRSGDALLOCAL_CS["Undefined SRS",LOCAL_DATUM["unknown",32767],UNIT["unknown",0],AXIS["Easting",EAST],AXIS["Northing",NORTH]]Custom undefined coordinate reference system\=mUndefined geographic SRSNONEundefinedundefined geographic coordinate reference system[;kUndefined Cartesian SRSNONEundefinedundefined Cartesian coordinate reference systemf +iWGS 84 geodeticEPSGGEOGCS["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"]],AXIS["Latitude",NORTH],AXIS["Longitude",EAST],AUTHORITY["EPSG","4326"]]longitude/latitude coordinates in decimal degrees on the WGS 84 spheroid r 11 =capannoli_cimiterifeaturescapannoli_cimiteri2025-06-03T13:07:51.450ZA8|ERARh咇A8򅔀ARij7 1 capannoli_cimiteri 1 capannoli_cimiteri 1capannoli_cimiteri 1 capannoli_cimiteri ,1%capannoli_cimiterigeomMULTIPOLYGON 1 capannoli_cimiterigeom 1 capannoli_cimiteri     M |  h k~ w8MTU-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); ENDDU-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); 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<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); END? S-indexsqlite_autoindex_gpkg_tile_matrix_1gpkg_tile_matrixC --9tablegpkg_tile_matrixgpkg_tile_matrix CREATE 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)) 55_tablegpkg_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 77tablegpkg_geometry_columnsgpkg_geometry_columnsCREATE TABLE gpkg_geometry_columns (table_name TEXT NOT NULL,column_name TEXT NOT NULL,geometry_type_name TEXT NOT NULL,srs_id INTEGER NOT NULL,z TINYINT 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_2gpkg_geometry_columns I]7indexsqlite_autoindex_gpkg_geometry_columns_1gpkg_geometry_columns //[tablegpkg_ogr_contentsgpkg_ogr_contentsCREATE TABLE gpkg_ogr_contents(table_name TEXT NOT NULL PRIMARY KEY,feature_count INTEGER DEFAULT NULL)AU/indexsqlite_autoindex_gpkg_ogr_contents_1gpkg_ogr_contents''wtablegpkg_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 DATETIME NOT NULL DEFAULT (strftime('%Y-%m-%dT%H:%M:%fZ','now')),min_x DOUBLE, min_y DOUBLE,max_x DOUBLE, max_y DOUBLE,srs_id INTEGER,CONSTRAINT fk_gc_r_srs_id FOREIGN KEY (srs_id) REFERENCES gpkg_spatial_ref_sys(srs_id))9M'indexsqlite_autoindex_gpkg_contents_2gpkg_contents9M'indexsqlite_autoindex_gpkg_contents_1gpkg_contents55)tablegpkg_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) (4i o 0 ; 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); 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); ENDYU-;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_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); ENDYW-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); 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/UUAtablertree_capannoli_cimiteri_geom_parentrtree_capannoli_cimiteri_geom_parentCREATE TABLE "rtree_capannoli_cimiteri_geom_parent"(nodeno INTEGER PRIMARY KEY,parentnode)#QQ1tablertree_capannoli_cimiteri_geom_nodertree_capannoli_cimiteri_geom_nodeCREATE TABLE "rtree_capannoli_cimiteri_geom_node"(nodeno INTEGER PRIMARY KEY,data)'SS5tablertree_capannoli_cimiteri_geom_rowidrtree_capannoli_cimiteri_geom_rowidCREATE TABLE "rtree_capannoli_cimiteri_geom_rowid"(rowid INTEGER PRIMARY KEY,nodeno)"GGEtablertree_capannoli_cimiteri_geomrtree_capannoli_cimiteri_geomCREATE VIRTUAL TABLE "rtree_capannoli_cimiteri_geom" USING rtree(id, minx, maxx, miny, maxy)=Q+indexsqlite_autoindex_gpkg_extensions_1gpkg_extensionsw++%tablegpkg_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))P++Ytablesqlite_sequencesqlite_sequenceCREATE TABLE sqlite_sequence(name,seq)B11/tablecapannoli_cimitericapannoli_cimiteriCREATE TABLE "capannoli_cimiteri" ( "fid" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "geom" MULTIPOLYGON, "ZONA" TEXT(16), "TIPO" TEXT(30), "DESCRIZION" TEXT(150), "COLOR" MEDIUMINT, "SIMBOLOGIA" TEXT(100), "AREA" REAL, "PERIMETER" REAL, "HECTARES" REAL, "SIGLA" TEXT(16)) a aV H#GPtT8A,{8A[ hRAiRAtT8AiRA T8AiRAO?a\8A_iRA@b8AiRADߚd8Au iRA)p8A9iRAW9p8AhiRA$rp8ABiRA==t8ABiRA,{8A[ hRAϵyd8AA6hRA}W8AghRAHT8A iRAtT8AiRAsantopietrocimitero@nhr!@aKnP?5?|hT HGPRE|8A>?8AV` iRA7jiRAfR8A^)iRAp8AiRA:8AVHiRA^L8AEiRAU8A0٥iRAd8A iRA>?8AwiRAYYӲ8AViRAaM8APiRA)8AjiRA8A'3iRAۛ#8A$kiRAAS8AohiRAg@8AYriRAqތ8ALڰiRA_!8AyiRA ;8Ay iRAQ8A(ٕiRAǺh8A iRA%8A_-iRA}8Ap]iRA8AiRAq8AZCiRAS8A^VqiRA(88ATiRA5D8AI䬬iRAg8A/{,iRAō8AO iRA|t8AQ%iRA 8AhpiRA!<8Au-"iRAI8AfiRA?8AoIliRA])8A뙩2iRAWC8A2 iRA`>8ApciRAr8A)6[iRA*8AZiRA8A֑iRA68ACiRAT|8AKܧiRA@+8A liRA:*8A1iRAR8A^)iRAcapannolicimitero@hr @|9XbN?Ql GPLP8A8AhRAζiRA 8AxhRAޞ8A#z)7hRArw8Ah hRA8ALhRAk8AhRA8AhRA= 8A0hRAnv8A5nhRA_p8AדhRA p8AhRA(Ii8AGhRAλh8AfhRAh8A7hRA/i8AKW{hRAi8AW{hRA$\8AU)GehRA\W8AphRA ףU8AQ8hRAz.T8AhRA333sS8AP chRA~Q8A)33chRALP8AMiRA XR8AζiRAvU8A0hRAdWy8A%FIhRA 8AxhRAcimitero@JWO;@rİ ě?nO 1capannoli_cimiteri 5i;'w!gpkg_metadata_referencegpkg_metadatahttp://www.geopackage.org/spec120/#extension_metadataread-write_''w!gpkg_metadatagpkg_metadatahttp://www.geopackage.org/spec120/#extension_metadataread-writeh1-q!capannoli_cimiterigeomgpkg_rtree_indexhttp://www.geopackage.org/spec120/#extension_rtreewrite-only *;'gpkg_metadata_referencegpkg_metadata ''gpkg_metadatagpkg_metadata+1- capannoli_cimiterigeomgpkg_rtree_index     - -P$IǒIǔ-JG+JH INjIǐ JLJNIǒIǓJGJH  L_4. "4'k1Wtriggertrigger_delete_feature_count_capannoli_cimitericapannoli_cimiteriCREATE TRIGGER "trigger_delete_feature_count_capannoli_cimiteri" AFTER DELETE ON "capannoli_cimiteri" BEGIN UPDATE gpkg_ogr_contents SET feature_count = feature_count - 1 WHERE lower(table_name) = lower('capannoli_cimiteri'); END4&k1Wtriggertrigger_insert_feature_count_capannoli_cimitericapannoli_cimiteriCREATE TRIGGER "trigger_insert_feature_count_capannoli_cimiteri" AFTER INSERT ON "capannoli_cimiteri" BEGIN UPDATE gpkg_ogr_contents SET feature_count = feature_count + 1 WHERE lower(table_name) = lower('capannoli_cimiteri'); END%U1 triggerrtree_capannoli_cimiteri_geom_deletecapannoli_cimiteriCREATE TRIGGER "rtree_capannoli_cimiteri_geom_delete" AFTER DELETE ON "capannoli_cimiteri" WHEN old."geom" NOT NULL BEGIN DELETE FROM "rtree_capannoli_cimiteri_geom" WHERE id = OLD."fid"; ENDH$W1triggerrtree_capannoli_cimiteri_geom_update4capannoli_cimiteriCREATE TRIGGER "rtree_capannoli_cimiteri_geom_update4" AFTER UPDATE ON "capannoli_cimiteri" WHEN OLD."fid" != NEW."fid" AND (NEW."geom" ISNULL OR ST_IsEmpty(NEW."geom")) BEGIN DELETE FROM "rtree_capannoli_cimiteri_geom" WHERE id IN (OLD."fid", NEW."fid"); END]#W1=triggerrtree_capannoli_cimiteri_geom_update3capannoli_cimiteriCREATE TRIGGER "rtree_capannoli_cimiteri_geom_update3" AFTER UPDATE ON "capannoli_cimiteri" WHEN OLD."fid" != NEW."fid" AND (NEW."geom" NOTNULL AND NOT ST_IsEmpty(NEW."geom")) BEGIN DELETE FROM "rtree_capannoli_cimiteri_geom" WHERE id = OLD."fid"; INSERT OR REPLACE INTO "rtree_capannoli_cimiteri_geom" VALUES (NEW."fid",ST_MinX(NEW."geom"), ST_MaxX(NEW."geom"),ST_MinY(NEW."geom"), ST_MaxY(NEW."geom")); ENDC"W1 triggerrtree_capannoli_cimiteri_geom_update2capannoli_cimiteriCREATE TRIGGER "rtree_capannoli_cimiteri_geom_update2" AFTER UPDATE OF "geom" ON "capannoli_cimiteri" WHEN OLD."fid" = NEW."fid" AND (NEW."geom" ISNULL OR ST_IsEmpty(NEW."geom")) BEGIN DELETE FROM "rtree_capannoli_cimiteri_geom" WHERE id = OLD."fid"; END$!W1Ktriggerrtree_capannoli_cimiteri_geom_update1capannoli_cimiteriCREATE TRIGGER "rtree_capannoli_cimiteri_geom_update1" AFTER UPDATE OF "geom" ON "capannoli_cimiteri" WHEN OLD."fid" = NEW."fid" AND (NEW."geom" NOTNULL AND NOT ST_IsEmpty(NEW."geom")) BEGIN INSERT OR REPLACE INTO "rtree_capannoli_cimiteri_geom" VALUES (NEW."fid",ST_MinX(NEW."geom"), ST_MaxX(NEW."geom"),ST_MinY(NEW."geom"), ST_MaxY(NEW."geom")); END U1triggerrtree_capannoli_cimiteri_geom_insertcapannoli_cimiteriCREATE TRIGGER "rtree_capannoli_cimiteri_geom_insert" AFTER INSERT ON "capannoli_cimiteri" WHEN (new."geom" NOT NULL AND NOT ST_IsEmpty(NEW."geom")) BEGIN INSERT OR REPLACE INTO "rtree_capannoli_cimiteri_geom" VALUES (NEW."fid",ST_MinX(NEW."geom"), ST_MaxX(NEW."geom"),ST_MinY(NEW."geom"), ST_MaxY(NEW."geom")); ENDTM);;1tablegpkg_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','now')),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)) (''Utablegpkg_metadatagpkg_metadataCREATE TABLE gpkg_metadata (id INTEGER CONSTRAINT m_pk PRIMARY KEY ASC NOT NULL,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 DEFAULT '') V x x x[=gdatasethttp://mrcc.com/qgis.dtdtext/xml dataset 0 0 false 81=tablecapannoli_cimiteri2025-06-03T13:07:52.067Z9