+proj=merc +a=6378137 +b=6378137 +lat_ts=0.0 +lon_0=0.0 +x_0=0.0 +y_0=0 +k=1.0 +units=m +nadgrids=@null +wktext +no_defs 3857 3857 EPSG:3857 WGS 84 / Pseudo Mercator merc WGS84 false osFeatures_ba1c1be0_3bef_420c_8262_549b09f175dd meters 18887723.18839794024825096 -5629947.74773571360856295 18887807.18839794024825096 -5629821.74773571360856295 -146 +proj=merc +a=6378137 +b=6378137 +lat_ts=0.0 +lon_0=0.0 +x_0=0.0 +y_0=0 +k=1.0 +units=m +nadgrids=@null +wktext +no_defs 3857 3857 EPSG:3857 WGS 84 / Pseudo Mercator merc WGS84 false 0

0 -5838280 19041600 0 osFeatures_ba1c1be0_3bef_420c_8262_549b09f175dd ./osFeatures.gpkg osFeatures +proj=merc +a=6378137 +b=6378137 +lat_ts=0.0 +lon_0=0.0 +x_0=0.0 +y_0=0 +k=1.0 +units=m +nadgrids=@null +wktext +no_defs 3857 3857 EPSG:3857 WGS 84 / Pseudo Mercator merc WGS84 false 0 0 false ogr 0 0 1 .. 0 0 generatedlayout fid 0 true 0 0 0 true 0 MM 30 3 EPSG:3857 +proj=merc +a=6378137 +b=6378137 +lat_ts=0.0 +lon_0=0.0 +x_0=0.0 +y_0=0 +k=1.0 +units=m +nadgrids=@null +wktext +no_defs 3857 1 true 2 false

false

m2 meters 0 true 16 false true 50 30 false false off 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 disabled disabled disabled disabled disabled disabled disabled disabled disabled disabled disabled disabled disabled disabled disabled disabled disabled disabled disabled disabled disabled disabled disabled disabled disabled disabled disabled disabled disabled disabled disabled disabled advanced 0.000000 0.000000 0.000000 0.000000 0.000000 0.000000 0.000000 0.000000 0.000000 0.000000 0.000000 0.000000 0.000000 0.000000 0.000000 0.000000 0.000000 0.000000 0.000000 0.000000 0.000000 0.000000 0.000000 0.000000 0.000000 0.000000 0.000000 0.000000 0.000000 0.000000 0.000000 0.000000 0 CWGlobalAllRoads20170127001150540 North_Otago_Properties20160204004529432 OSAllBridgesAndTunnels20160820084158651 OSAllFeatures20160722141122527 OSAllOtherPaths20160722142453302 OSAllRoads20160722143454010 OSAllSites20160722143352000 OSGlobalCromwellGorgeProperties20150623022958491 OSGlobalLakes20150519002143431 OSGlobalRivers20150519001937647 OSGlobalVoids20150625212251388 OSGlobalWaterways20150519001834359 OSKingstonLine20160722142405246 OSKingstonLineBranch20150519001133674 OSKingstonLineMain20150519001049427 OSLakeDunstan_f88b0480_e063_494e_b119_2efd1bafbc8d OSLocations20170617033602248 OSMainSouthLine385720160722141307762 OSNoPublishLocations20180324202558019 OSOtagoCentralRailway385720160722141455766 OSTaieriGorgeRailway385720160722142224559 OSTaieriIndustrialLine385720160722142332144 Otago_Contours20150519002659656 Otago_Heights20150519002831819 Otago_Properties20150519002533742 REGC2016_HD_Clipped20170126151249653 nz_aerial_photo_footprints_mainland_nz_1936_2005_polygons20160124020419691 osBuildings20180208190311751 osCluthaRiverbed_d04a20f1_07f3_4f68_82d6_d4f5d86cff3c osStructures20180102164211198 osYards20171230202112784 otago_names20150519002411581 to_vertex_and_segment to_vertex_and_segment to_vertex_and_segment to_vertex_and_segment to_vertex_and_segment to_vertex_and_segment to_vertex_and_segment to_vertex_and_segment to_vertex_and_segment to_vertex_and_segment to_vertex_and_segment to_vertex_and_segment to_vertex_and_segment to_vertex_and_segment to_vertex_and_segment to_vertex_and_segment to_vertex_and_segment to_vertex_and_segment to_vertex_and_segment to_vertex_and_segment to_vertex_and_segment to_vertex_and_segment to_vertex_and_segment to_vertex_and_segment to_vertex_and_segment to_vertex_and_segment to_vertex_and_segment to_vertex_and_segment to_vertex_and_segment to_vertex_and_segment to_vertex_and_segment to_vertex_and_segment 0 0 true MM true 0 2 +proj=merc +a=6378137 +b=6378137 +lat_ts=0.0 +lon_0=0.0 +x_0=0.0 +y_0=0 +k=1.0 +units=m +nadgrids=@null +wktext +no_defs 3857 3857 EPSG:3857 WGS 84 / Pseudo Mercator merc WGS84 false osFeatures_ba1c1be0_3bef_420c_8262_549b09f175dd OSAllFeatures_f90c14be_c985_4b52_ba4f_f6bb0b70f8da meters 18887723.18839794024825096 -5629947.74773571360856295 18887807.18839794024825096 -5629821.74773571360856295 -146 +proj=merc +a=6378137 +b=6378137 +lat_ts=0.0 +lon_0=0.0 +x_0=0.0 +y_0=0 +k=1.0 +units=m +nadgrids=@null +wktext +no_defs 3857 3857 EPSG:3857 WGS 84 / Pseudo Mercator merc WGS84 false 0

18678277.86432968452572823 -5838276.41017805226147175 19041627.99805619195103645 -5578473.79793631564825773 OSAllFeatures_f90c14be_c985_4b52_ba4f_f6bb0b70f8da ./OSAllFeatures.shp OSAllFeatures +proj=merc +a=6378137 +b=6378137 +lat_ts=0.0 +lon_0=0.0 +x_0=0.0 +y_0=0 +k=1.0 +units=m +nadgrids=@null +wktext +no_defs 3857 3857 EPSG:3857 WGS 84 / Pseudo Mercator merc WGS84 false 0 0 true ogr 0 0 1 .. 0 0 generatedlayout 0 -5838280 19041600 0 osFeatures_ba1c1be0_3bef_420c_8262_549b09f175dd ./osFeatures.gpkg osFeatures +proj=merc +a=6378137 +b=6378137 +lat_ts=0.0 +lon_0=0.0 +x_0=0.0 +y_0=0 +k=1.0 +units=m +nadgrids=@null +wktext +no_defs 3857 3857 EPSG:3857 WGS 84 / Pseudo Mercator merc WGS84 false 0 0 false ogr 0 0 1 .. 0 0 generatedlayout fid 0 true 0 0 0 true 0 MM 30 3 EPSG:3857 +proj=merc +a=6378137 +b=6378137 +lat_ts=0.0 +lon_0=0.0 +x_0=0.0 +y_0=0 +k=1.0 +units=m +nadgrids=@null +wktext +no_defs 3857 1 true 2 false

false

m2 meters 0 true 16 false true 50 30 false false off 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 disabled disabled disabled disabled disabled disabled disabled disabled disabled disabled disabled disabled disabled disabled disabled disabled disabled disabled disabled disabled disabled disabled disabled disabled disabled disabled disabled disabled disabled disabled disabled disabled advanced 0.000000 0.000000 0.000000 0.000000 0.000000 0.000000 0.000000 0.000000 0.000000 0.000000 0.000000 0.000000 0.000000 0.000000 0.000000 0.000000 0.000000 0.000000 0.000000 0.000000 0.000000 0.000000 0.000000 0.000000 0.000000 0.000000 0.000000 0.000000 0.000000 0.000000 0.000000 0.000000 0 CWGlobalAllRoads20170127001150540 North_Otago_Properties20160204004529432 OSAllBridgesAndTunnels20160820084158651 OSAllFeatures20160722141122527 OSAllOtherPaths20160722142453302 OSAllRoads20160722143454010 OSAllSites20160722143352000 OSGlobalCromwellGorgeProperties20150623022958491 OSGlobalLakes20150519002143431 OSGlobalRivers20150519001937647 OSGlobalVoids20150625212251388 OSGlobalWaterways20150519001834359 OSKingstonLine20160722142405246 OSKingstonLineBranch20150519001133674 OSKingstonLineMain20150519001049427 OSLakeDunstan_f88b0480_e063_494e_b119_2efd1bafbc8d OSLocations20170617033602248 OSMainSouthLine385720160722141307762 OSNoPublishLocations20180324202558019 OSOtagoCentralRailway385720160722141455766 OSTaieriGorgeRailway385720160722142224559 OSTaieriIndustrialLine385720160722142332144 Otago_Contours20150519002659656 Otago_Heights20150519002831819 Otago_Properties20150519002533742 REGC2016_HD_Clipped20170126151249653 nz_aerial_photo_footprints_mainland_nz_1936_2005_polygons20160124020419691 osBuildings20180208190311751 osCluthaRiverbed_d04a20f1_07f3_4f68_82d6_d4f5d86cff3c osStructures20180102164211198 osYards20171230202112784 otago_names20150519002411581 to_vertex_and_segment to_vertex_and_segment to_vertex_and_segment to_vertex_and_segment to_vertex_and_segment to_vertex_and_segment to_vertex_and_segment to_vertex_and_segment to_vertex_and_segment to_vertex_and_segment to_vertex_and_segment to_vertex_and_segment to_vertex_and_segment to_vertex_and_segment to_vertex_and_segment to_vertex_and_segment to_vertex_and_segment to_vertex_and_segment to_vertex_and_segment to_vertex_and_segment to_vertex_and_segment to_vertex_and_segment to_vertex_and_segment to_vertex_and_segment to_vertex_and_segment to_vertex_and_segment to_vertex_and_segment to_vertex_and_segment to_vertex_and_segment to_vertex_and_segment to_vertex_and_segment to_vertex_and_segment 0 0 true MM true 0 2 SQLite format 3@ 6 '
GP106.B� ����#  1 ���J�=�UWGS 84 / Pseudo-MercatorEPSGPROJCS["WGS 84 / Pseudo-Mercator",GEOGCS["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"]],PROJECTION["Mercator_1SP"],PARAMETER["central_meridian",0],PARAMETER["scale_factor",1],PARAMETER["false_easting",0],PARAMETER["false_northing",0],UNIT["metre",1,AUTHORITY["EPSG","9001"]],AXIS["X",EAST],AXIS["Y",NORTH],EXTENSION["PROJ4","+proj=merc +a=6378137 +b=6378137 +lat_ts=0.0 +lon_0=0.0 +x_0=0.0 +y_0=0 +k=1.0 +units=m +nadgrids=@null +wktext +no_defs"],AUTHORITY["EPSG","3857"]]\=mUndefined geographic SRSNONEundefinedundefined geographic coordinate reference system[���������;
kUndefined cartesian SRSNONE�undefinedundefined cartesian coordinate reference system�f�f +� �WGS 84 geodeticEPSG�GEOGCS["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"]]longitude/latitude coordinates in decimal degrees on the WGS 84 spheroid
��H
!! =osFeaturesfeaturesosFeatures2018-06-30T12:43:38.383Z��8
"�@
�� ! osFeatures
�� ! osFeatures
��
!osFeaturesgeomPOINT
��! osFeaturesgeom
�� ! osFeatures     �
)���| D�GZ �S��
)�TU-�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); 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); END�J Q-�!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�C --
�9tablegpkg_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))?S-
indexsqlite_autoindex_gpkg_tile_matrix_1gpkg_tile_matrix�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 [5
indexsqlite_autoindex_gpkg_tile_matrix_set_1gpkg_tile_matrix_set �77
�tablegpkg_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]7
indexsqlite_autoindex_gpkg_geometry_columns_2gpkg_geometry_columnsI]7
indexsqlite_autoindex_gpkg_geometry_columns_1gpkg_geometry_columns�''
�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_contents�
55
�)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) �� Y � e ������G'�Otriggergpkg_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 | catalogue | schema | taxonomy software | service | collectionHardware | nonGeographicDataset | dimensionGroup') WHERE NOT(NEW.md_scope IN ('undefined','fieldSession','collectionSession','series','dataset', 'featureType','feature','attributeType','attribute','tile','model', 'catalogue','schema','taxonomy','software','service', 'collectionHardware','nonGeographicDataset','dimensionGroup')); END�G'�3triggergpkg_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 | catalogue | schema | taxonomy software | service | collectionHardware | nonGeographicDataset | dimensionGroup') WHERE NOT(NEW.md_scope IN ('undefined','fieldSession','collectionSession','series','dataset', 'featureType','feature','attributeType','attribute','tile','model', 'catalogue','schema','taxonomy','software','service', 'collectionHardware','nonGeographicDataset','dimensionGroup')); END9M'
indexsqlite_autoindex_gpkg_metadata_1gpkg_metadata�''
�Mtablegpkg_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)�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�IU-�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_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); END�IU-�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�YW-�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); END�HW-�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    �0c �-���^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�Pa;�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�`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�Ji;�{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�M;;
�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)) �� ������c
�
4�� '�
��Z�#!!
�ItableosFeaturesosFeaturesCREATE TABLE 'osFeatures' ( "fid" INTEGER PRIMARY KEY AUTOINCREMENT, "geom" POINT, "name" TEXT(80), "caption" TEXT(80), "type" INTEGER, "location" TEXT(80), "yearIns" MEDIUMINT, "yearDel" MEDIUMINT, "CustomFlag" MEDIUMINT)�"];�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]-[0-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�!];�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]-[0-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�) 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�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���~;
��
!osFeatures� ;���O��: � � P �y8��k, � � � C  � � C ��;�u4��t(��;��w6��V��{B
�
�
Y
��7; F
GP


E
ȡ��qA���f��U�ClydeWClydes'7: F
GP


i󞑸�qA �q��U�ClydeHClydes'79 F
GP


<�&���qA���+ǎU�ClydeHClydes'78 F
GP


D�W���qA�xрΎU�ClydeWClydes'67 F
GP


���S~�qA�vlm$�U�OCRAGalloway':6 F
%GP


����qAb���x�U�OCRWChatto Creek':5 F
%GP


������qA`4�P��U�OCRAChatto Creek'74 F
GP


h1V��qA�߭���U�ClydeYClydes'73 F
GP


2y����qA�����U�ClydeWClydes'<2 F
!GP


{����qAQK��U�ClydeEClyde 1907s'b1 F;;
GP


�P�� rAS@�}isU�Hayes Engineering WorksHayes Engineering WorksOturehua�'M0 F''
GP


��|�rA=ے��U�Barewood MineBarewood MineThe Reefs'D/ F-
GP


�M����qA )}`{U�CromwellTram Body Cabins�'I. FA
GP


�u%g�qA��e�M�U�AtholBallast Pit (Hypothetical) '?- F)
GP


C�p�D�qAC���-V�FairfaxPrivate Museum'B, F!)
GP


wW�7��qA��I|�CV�LornevilleFreezing Works'<+ F%
GP


]K�] �qArՅG�V�OrawiaCement Works'@* F)
GP


[����qA]m�h_RY�U�MSLBurnside Cement Works'9 F
GP


��h�rAm �U�DunedinGasworks'J F!9
GP


��)�qAr[@qEV�KL WaikiwiMcSkimmings Pipe Works'< F
GP


���qA0檵V�LimehillsLimeworks'@ F-
GP


u�J�rA�����U�OwhiroFertiliser Store': F
GP


�@�rA�����V�MilburnLimeworks'I F'1
GP


��F;rA�u3��U�Port ChalmersContainer Terminal'; F)
GP


n��7�rA�,k�L�U�MSL[Ravensbourne]'; F!
GP


�?� rA�1��jU�NgaparaFlour Mill'9 F
GP


��O� rA��/]�hU�NgaparaCoal Pit'; F!
GP


�Sc�$rA�) �0�U�KakanuiLime Kilns'5 F
GP


Z�^P,"rA��%�ɺU�Shag PtPits'5 F
GP


���3"rAd
Z��U�Shag PtPits'< F!
GP


�%*�"rA�>gL�U�Shag PointOld Mine'= F!
GP


my�"�"rA�%|r�U�Shag PointCoal Pits'B F+
GP


���� rA #�G�V�ClarendonEwing Phosphate'D F9
GP


��ύ�rA�)�>y�U�HydeHyde Disaster Monument'A F!'
GP


���w�rA�����qU�Wedderburn45th Parallel'? F'
GP


�r rAp�#"�qU�Oturehua45th Parallel'C F%'
GP


� ���(rA [[�qU�Hilderthorpe45th Parallel'H F;
GP


�W�0!rAM�7��qU�WindsorHolcim Sand Quarry Site'F F7
GP


�3� rA�|��JiU�NgaparaHolcim Coal Mine Site'K FE
GP


޿Ǘd$rA_�8zU�LorneHolcim Lime/Tuff Quarry Site'S FU
GP


o��=d$rAq,�E�{U�LorneHolcim Cement Works Site Designation'F F/#
GP


6�v�$rAK01B̋U�McDonalds KakanuiLime Quarry'S F!K
GP


�fk��qA�~}V�MandevilleCroydon Aircraft Company Museum'? F1 GP


��x��rA�;
�U�OCRTHyde Disaster Site'C F9 GP


Ӗ��rA���\rU�OCRTRoute Summit 618 m asl'8 F GP


�0ϗ�rA�:�C8�U�DunedinHillside'8 F
GP


�p�G6rA^KXq�U�TaieriFonterra'= F'
GP


F�rAH�>6��U�TaieriPolarcold/SFF'6
F
GP


M_Z�=rA�F㻵�U�TaieriOdlins' C���U��q9 � � � Q ��m7
��T � � w ?  � � Y ��l0��F ��Y��V��R ��W��wA
�
�
N
��6~ F
GP


�F���rA5�3��U�OCRVMt Allan'6} F
GP


�B��rAe��ޭ�U�OCRVMt Allan'=| F
+GP


8��)�rA�w��U�OCRVLittle Mt Allan'={ F
+GP


:f��rA��RE �U�OCRVLittle Mt Allan'=z F
+GP



f1�rA-o�E��U�OCRVChristmas Creek'=y F
+GP


���rA�};s�U�OCRVChristmas Creek'4x F
GP


X�u�hrA�\���U�OCRVHindon'4w F
GP


�ӇUhrA+��L��U�OCRVHindon'4v F
GP


kY��grAY:^o��U�OCRVHindon'3u F GP


C�nrA�E}���U�OCRVHindon'6t F
GP


�
_2�rA}}�u?�U�OCRVMt Allan';s F
#GP


b}vq rA �;�U�OCRBFlat Stream�';r F
#GP


�"�!rA�GS�U�OCRHFlat Stream�'7q F
GP


�"Ĝ�rAK�uQ�U�OICRFRanfurly':p F
%GP


�9�rAK��a�U�TGRWNorth Taieri'Go F/
GP


ݮ���qAT�A���U�OCRVacuum/|Mobil OilAlexandra��#c�U�OCRPest BoardAlexandra�'>i F!
GP


�.��*�qA*֜��U�OCRDOC OfficeClyde�'Bh F!
GP


q����qA�- l�U�OCRDOC OfficeAlexandra�'9g F
GP


�C�.��qA��o�U�OCRFAlexandra��9f F
GP


`cwQ��qAT��חU�OCRAAlexandra��>e F
'GP


Z%9��qA���{�U�OCRH283Halfway House'7d F
GP


#����qAy��q��U�ClydeHClydes'7c F
GP


������qA�x���U�ClydeHClydes'7b F
GP


���c��qAaW=
ՎU�ClydeHClydes'7a F
GP


d�+��qAb���U�ClydeFClydes':` F
!GP


.��3}rA��9��vU�OCRWWedderburn�':_ F
!GP

��OCRYWedderburn�':^ F
!GP


��,bzrA�#��vU�OCRHWedderburn�':] F
!GP


�6V"rA9�U �vU�OCRHWedderburn�':\ F
!GP

��OCRHWedderburn�':[ F
!GP


��}rAi�O�vU�OCRWWedderburn�'7Z F
GP


���crAh�˙�U�OCRHKokonga�'7Y F
GP


��rAT✂�U�OCRWKokonga�'7X F
GP


" o�rAGJ��ґU�OCREKokonga�'8W F
GP


\ߜ�rAƻ����U�OCRWRanfurly�'8V F
GP


.5��rA�G��"�U�OCRYWaipiata�'6U F
GP


��j�rAB� �U�OCRYMt Allan'6T F
GP


��.��rA&{�
�U�OCRSMt Allan'4S F
GP


��)'rrA�i�NW�U�OCRGSutton'4R F
GP


��I�prA��U�OCRYSutton'7Q F
GP


�urA4�h��U�OCRWNgapuna�'?P F
+GP


+@HcgrA�aW�ͯU�OCRWRock and Pillar�'4O F
GP


�l9t
rA&���U�OCRAOmakau'4N F
GP


d~FrA�:���yU�OCRALauder'4M F
GP


����
rA�\4�U�OCRFOmakau�4L F
GP


��.u
rA"7o��U�OCRWOmakau'4K F
GP


!|��
rA���U�OCRWOmakau'8J F
!GP


r���`rAz���bwU�OCRWIda Valley'8I F
!GP


#9b�^rA��U^wU�OCRHIda Valley'8H F
!GP


�) �^rA���ewU�OCREIda Valley'8G F
!GP



;?drA�F�YwU�OCRHIda Valley'8F F
!GP


-ν�~rA�(GwU�OCRWIda Valley'8E F
!GP


��?�arA.2+�[wU�OCRHIda Valley'8D F
!GP


F�~brA�?cwU�OCRFIda Valley'6C F
GP


M�Q� rA?� ��rU�OCRAOturehua'6B F
GP


��� rAk�� sU�OCRHOturehua'6A F
GP


����� rA'���rU�OCRYOturehua'8@ F
!GP


���frA��#�WwU�OCRHIda Valley'8? F
!GP


��lrAɈ��RwU�OCRHIda Valley'8> F
!GP


��
.trAK��MwU�OCRAIda Valley'6= F
GP


��6 rA,y~rqU�OCREOturehua'7< F
GP


3R����qA۶�l��U�ClydeLClydes' 9��V��zC � � a '��v?��J � � V  � � f *��x>���F��n*��S�t,��J ��R>�7 F#
GP


�IlA�rAsmC�\yU�OCRBallast PitLauderr>�6 F#
GP


A��4�rAֿa[yU�OCRBallast PitLauderq:�5 F
%GP


q�H���qAJE����U�OCRVChatto Creek':�4 F
%GP


��0���qA�b���U�OCRFChatto Creek':�3 F
%GP


��JL��qAn���U�OCREChatto Creek'O�2 F9
%GP


�x����qA�A2W4�U�OCRRails & Sleepers DepotChatto Creek'J�1 F1
GP


��f��qAթ�J�U�OCRRail Trail AmenityAlexandra�'@�0 F
GP


*�f��qAc�B�U�OCRWW DepotAlexandra��E�/ F+
GP


Ҭ����qAr\hV�U�OCRLane & ThompsonAlexandra�Z�. FQ
GP


����qA�hJ岗U�OCRApple & Pear Board|/Freezing WorksAlexandra��>�- F!
GP


�%U"L�qA}E��X�U�OCRMOWD DepotClyde��>�, F!
GP


��=�qA������U�OCRNZED DepotClyde��B�+ F!
GP


�|���qA��b$��U�OCRCaltex OilAlexandra��L�* F5
GP


O+Z���qAL��w�U�OCRFulton Hogan BitumenAlexandra��@�) F!
GP


)�غ�qA� ����U�OCREuropa OilAlexandra�A�( F
GP


p����qA�w{f�U�OCRShell OilAlexandra��>�' F
GP


sH�<��qA��M�q�U�OCRBP OilAlexandra��F�& F1
GP


���+�qA�� ̶�U�OCRRail Trail AmenityClyde�'K�% F;
GP


�頻'�qA��7?��U�OCRRural Fire / CoastguardClyde�'7�$ F
GP


�y��rA{�?��U�OCRVPukerangi'>�# F GP


0O rA�TN&�U�OCRMemorialsThe Reefs'7�" F
GP


}�ihrA����#�U�OCRVThe Reefs'@�! F# GP


��� rA�'�#�U�OCRReefs HotelThe Reefs'7� F
GP


C���ErAZ��4<�U�OCRVThe Reefs'7� F
GP


s�{�rA2�_&�U�OCRVThe Reefs'9� F
#GP


�B���rA�sܟ��U�OCRVThe Notches'9� F
#GP


��x��rA�G�O�U�OCRVFlat Stream'9� F
#GP


��s��rA!M�A��U�OCRVFlat Stream'9� F
#GP


�DPqrAər���U�OCRVFlat Stream'9� F
#GP


�a]!rA%��/C�U�OCRVFlat Stream'9� F
#GP


�7SJ_rA;����U�OCRVSlope Gully'9� F
#GP


(t��XrAV��U�OCRVDeep Stream'9� F
#GP


LeP�rAA�֛�U�OCRVDeep Stream'9� F
#GP


�-�zrA�8�j��U�OCRVDeep Stream';� F
'GP


+�/�rAZ&xx��U�OCRVMachine Creek';� F
'GP


cC�rA�����U�OCRVMachine Creek';� F
'GP


�BP��rA޷{0�U�OCRVMachine Creek'F� F/
GP


�A�rAӣ��څU�OCRRefreshment RoomsRanfurly'4� F
GP


��rA�V��U�OCRVHindon'4� F
GP


�ʢ&3rA�-㽉�U�OCRVHindon'4� F
GP


cllirA31,���U�OCRHHindon':� F
%GP


!,�]%rA�F��U�OCRVNorth Taieri'7� F
GP


�U1%�rA|sXH�U�OCRVWairongoa'7� F
GP



�&*drA� 2���U�OCRVSalisbury'7� F
GP


��ёXrAR)��'�U�OCRVSalisbury'7� F
GP


Ɂ��nrA��U��U�OCRVSalisbury'7� F
GP


Q�{mrA1 �uK�U�OCRVSalisbury'4� F
GP


}b`3-rA�v\*��U�OCRVTaioma'4� F
GP


����rA��~��U�OCRVTaioma'4� F
GP


�c�ޟrAQ�����U�OCRVTaioma'4� F
GP


*5_�rA�L`���U�OCRVParera'4� F
GP


��`��rA}�̡�U�OCRVParera'4� F
GP


p�X �rAn�<��U�OCRVParera'4� F
GP


EDrA��
���U�OCRVParera'6�
F
GP


"(�n6rA���\��U�OCRVMt Allan'6� F
GP


���BrA��(�>�U�OCRVMt Allan'6 F
GP


8� Y�rA��x?�U�OCRVMt Allan'
��R
!-U!osFeaturesgeomgpkg_rtree_indexGeoPackage 1.0 Specification Annex Lwrite-only
��#!- osFeaturesgeomgpkg_rtree_index
�� 
�9����}���������������������|�!s��_U�OmF<�6-�'�g����wqke_YSMGA;5/)# � � � � � � � � � � � � � � � � � � � � � � { u o i c ] W Q K E ? 9 3 - ' !    ��������������������{tmf_XQJC<5.' ������������������xqjc\UNG@9�7
�6
�5
�4
�3
�2
�1
�0
�/
�.
�-
�,
�+
�*
�)
�(
�'
�&
�%
�$
�#
�"
�!
� 
�
�
�
�
�
�
�
�
�
�
�
�
�
�
�
�
�
�
� 
�
�
� 
� 
�
�
�
�
�
�
�
�

�

~
}
|
{
z
y
x
w
v
u
t
s
r
q
p
o
n
m
l
k
j
i
h
g
f
e
d
c
b
a
`
_
^
]
\
[
Z
Y
X
W
V
U
T
S
R
Q
P
O
N
M
L
K
J
I
H
G
F
E
D
C
B
A
@
?
>
=
<
;
:
9
8
7
6


1
-
+

 






(
#
 




0


2
BB4
/
[
,
*
[)
'
[&
[$
"
�!
~.
%

�

�
�

�
�5


� 

� 
�3

��

 ������     
�-Z
��P�$)K��MK��Nʲ+�ʲ+�,K���K���ʲDʲB*K���K���ʱ��ʱ��)K��K��ʱ��ʱ��-K��%K��&ʱoFʱoDK���K���ʰͯʰͭK�`{K�`|ʰ�xʰ�w+K��K��ʰ�Dʰ�BK�h�K�h�ʰ��ʰ��%K��.K��/ʰ�kʰ�iK�^{K�^|ʰ[�ʰ[�&K�F6K�F7ʯ�wʯ�u.K�39K�3:ʮ mʮ k7K���K���ʬ�%ʬ�#2K���K���ʬxBʬx@3K���K���ʬx!ʬx4K���K���ʬw�ʬw�8K��WK��Xʬvuʬvt9K��gK��hʬv;ʬv9K��?ʮ��ʮ��wK��BK��Cʮ�lʮ�jxK��GK��Hʮ�Bʮ�@rK��K�� ʮʙʮʘsK��K��ʮ��ʮ��0K���K���ʮ�=ʮ�;SK�{�K�{�ʮJ�ʮJ�RK�{�K�{�ʮHxʮHvK��K��ʭ�<ʭ�:K��K��ʭ�ʭ�QK��{K��|ʭ��ʭ��K�aK�cʭ�Oʭ�MK�9K�:ʭ�eʭ�c'K��K��ʭ�$ʭ�"PK��;K��<ʭ~qʭ~oK��DK��FʭC�ʭC�K��4K��5ʭ@�ʭ@��K��KK��Mʮ�oʮ�m�K���K���ʮ�Nʮ�M�K��(K��)ʯ�ʯ��K���K���ʮ��ʮ���K��K��
ʮ��ʮ���K��1K��3ʮ��ʮ���K���K���ʮ�ʮ��K��K��ʮ��ʮ���K���K���ʮ�qʮ�o�K���K���ʮ�,ʮ�+�K�� K��ʮ�ʮ��K���K���ʮ��ʮ���K���K���ʮ�Kʮ�J�K���K���ʮ��ʮ���K��K��?ʬ5!ʬ5qK�w�K�w�ʬ2�ʬ2�WK�v�K�v�ʬ,�ʬ,�$K�&$K�&%ʫ��ʫ�� K�#!K�#"ʫ݌ʫ݊kK��K��ʫ�ʫ�lK��K�� ʫ��ʫ�� K�#$K�#%ʫ��ʫ��mK�c�K�c�ʫ� ʫ�K� K� �ʫ�>ʫ�< K�F�K�F�ʫ��ʫ��K�K�ʫP(ʫP&K��K��ʫJWʫJUK�JK�LʫF[ʫFZ(K���K���ʪ=�ʪ=��K�w7K�w9ʬ.�ʬ.��K��=K��>ʬ�ʬ��K���K���ʬ}�ʬ}��K���K���ʬ�ʬ��K��aK��bʬ��ʬ���K���K���ʬA�ʬA��K��2K��4ʬ0ʬ0�K��4K��5ʬ0/ʬ0-�K��>K��?ʬ5Mʬ5K�K��K��ʫ��ʫ���K�BK�Cʫ��ʫ���P�$!5K��K�;�K�;�ʫ�nʫ�lFK�;�K�;�ʫ�;ʫ�9^K�c�K�c�ʫ��ʫ��[K�c�K�c�ʫ��ʫ��]K�c�K�c�ʫ�zʫ�y`K�c�K�c�ʫ��ʫ��1K�L�K�L�ʫ�Lʫ�KBK�N�K�N�ʫ�jʫ�hCK�N�K�N�ʫ��ʫ��AK�OK�Oʫ��ʫ��K�^�K�^�ʫ��ʫ��K�P�K�P�ʫ�Rʫ�QK�^�K�^�ʫ��ʫ��=K�Q�K�Q�ʫ��ʫ��eK��$K��%ʬ�ʬ�_\ d��u � T� � =eBd�[0E!�[triggerrtree_osFeatures_geom_deleteosFeaturesCREATE TRIGGER "rtree_osFeatures_geom_delete" AFTER DELETE ON "osFeatures" WHEN old."geom" NOT NULL BEGIN DELETE FROM "rtree_osFeatures_geom" WHERE id = OLD."fid"; END� /G!�ctriggerrtree_osFeatures_geom_update4osFeaturesCREATE TRIGGER "rtree_osFeatures_geom_update4" AFTER UPDATE ON "osFeatures" WHEN OLD."fid" != NEW."fid" AND (NEW."geom" ISNULL OR ST_IsEmpty(NEW."geom")) BEGIN DELETE FROM "rtree_osFeatures_geom" WHERE id IN (OLD."fid", NEW."fid"); END�7.G!�triggerrtree_osFeatures_geom_update3osFeaturesCREATE TRIGGER "rtree_osFeatures_geom_update3" AFTER UPDATE OF "geom" ON "osFeatures" WHEN OLD."fid" != NEW."fid" AND (NEW."geom" NOTNULL AND NOT ST_IsEmpty(NEW."geom")) BEGIN DELETE FROM "rtree_osFeatures_geom" WHERE id = OLD."fid"; INSERT OR REPLACE INTO "rtree_osFeatures_geom" VALUES (NEW."fid",ST_MinX(NEW."geom"), ST_MaxX(NEW."geom"),ST_MinY(NEW."geom"), ST_MaxY(NEW."geom")); END�-G!�Ytriggerrtree_osFeatures_geom_update2osFeaturesCREATE TRIGGER "rtree_osFeatures_geom_update2" AFTER UPDATE OF "geom" ON "osFeatures" WHEN OLD."fid" = NEW."fid" AND (NEW."geom" ISNULL OR ST_IsEmpty(NEW."geom")) BEGIN DELETE FROM "rtree_osFeatures_geom" WHERE id = OLD."fid"; END�|,G!�triggerrtree_osFeatures_geom_update1osFeaturesCREATE TRIGGER "rtree_osFeatures_geom_update1" AFTER UPDATE OF "geom" ON "osFeatures" WHEN OLD."fid" = NEW."fid" AND (NEW."geom" NOTNULL AND NOT ST_IsEmpty(NEW."geom")) BEGIN INSERT OR REPLACE INTO "rtree_osFeatures_geom" VALUES (NEW."fid",ST_MinX(NEW."geom"), ST_MaxX(NEW."geom"),ST_MinY(NEW."geom"), ST_MaxY(NEW."geom")); END�W+E!�Striggerrtree_osFeatures_geom_insertosFeaturesCREATE TRIGGER "rtree_osFeatures_geom_insert" AFTER INSERT ON "osFeatures" WHEN (new."geom" NOT NULL AND NOT ST_IsEmpty(NEW."geom")) BEGIN INSERT OR REPLACE INTO "rtree_osFeatures_geom" VALUES (NEW."fid",ST_MinX(NEW."geom"), ST_MaxX(NEW."geom"),ST_MinY(NEW."geom"), ST_MaxY(NEW."geom")); END� *EE
�Ctablertree_osFeatures_geom_parentrtree_osFeatures_geom_parentCREATE TABLE "rtree_osFeatures_geom_parent"(nodeno INTEGER PRIMARY KEY, parentnode INTEGER)�)CC
�7tablertree_osFeatures_geom_rowidrtree_osFeatures_geom_rowidCREATE TABLE "rtree_osFeatures_geom_rowid"(rowid INTEGER PRIMARY KEY, nodeno INTEGER)�(AA
�-tablertree_osFeatures_geom_nodertree_osFeatures_geom_nodeCREATE TABLE "rtree_osFeatures_geom_node"(nodeno INTEGER PRIMARY KEY, data BLOB)� '77�5tablertree_osFeatures_geomrtree_osFeatures_geomCREATE VIRTUAL TABLE "rtree_osFeatures_geom" USING rtree(id, minx, maxx, miny, maxy)=&Q+
indexsqlite_autoindex_gpkg_extensions_1gpkg_extensions�w%++
�%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)�-
85�� �-
85�� ����������������