+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 SRSNONEundefinedundefined cartesian coordinate reference systemff + WGS 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"]],AUTHORITY["EPSG","4326"]]longitude/latitude coordinates in decimal degrees on the WGS 84 spheroid H !! =osFeaturesfeaturesosFeatures2018-06-30T12:43:38.383Z8"@  ! 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); 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); ENDJ 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); ENDC --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))? 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 [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_columnsI]7indexsqlite_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_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)  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); 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    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 || '%'))); ENDPa;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'); ENDJi;{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'); ENDM;;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))  c4 '  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); ENDc;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 ;u4t(;w6V{BY 7; FGPEȡqAfUClydeWClydes'7: FGPi󞑸qA qUClydeHClydes'79 FGP<&qA+ǎUClydeHClydes'78 FGPDWqAxрΎUClydeWClydes'67 FGPS~qAvlm$UOCRAGalloway':6 F%GPqAbxUOCRWChatto Creek':5 F%GPqA`4PUOCRAChatto Creek'74 FGPh1VqA߭UClydeYClydes'73 FGP2yqAUClydeWClydes'<2 F!GP{qAQKUClydeEClyde 1907s'b1 F;;GPP rAS@}isUHayes Engineering WorksHayes Engineering WorksOturehua'M0 F''GP|rA= ےUBarewood MineBarewood MineThe Reefs'D/ F-GPMqA )}`{UCromwellTram Body Cabins'I. FAGPu%gqAeMUAtholBallast Pit (Hypothetical) '?- F)GPCpDqAC-VFairfaxPrivate Museum'B, F!)GPwW7qAI|CVLornevilleFreezing Works'<+ F%GP]K] qArՅGVOrawiaCement Works'@* F)GP[qA]mh_RYUMSLBurnside Cement Works'9 FGP hrAm UDunedinGasworks'J F!9GP)qAr[@qEVKL WaikiwiMcSkimmings Pipe Works'< FGPqA0檵VLimehillsLimeworks'@ F-GPuJrAUOwhiroFertiliser Store': FGP@ rAVMilburnLimeworks'I F'1GPF;rAu3UPort ChalmersContainer Terminal'; F)GPn7rA,kLUMSL[Ravensbourne]'; F!GP? rA1jUNgaparaFlour Mill'9 FGPO rA/]hUNgaparaCoal Pit'; F!GPSc$rA) 0UKakanuiLime Kilns'5 FGPZ^P,"rA%ɺUShag PtPits'5 FGP3"rAdZUShag PtPits'< F!GP%*"rA>gLUShag PointOld Mine'= F!GPmy""rA%|rUShag PointCoal Pits'B F+GP rA #GVClarendonEwing Phosphate'D F9GPύrA)>yUHydeHyde Disaster Monument'A F!'GPw rAqUWedderburn45th Parallel'? F'GPr rAp#"qUOturehua45th Parallel'C F%'GP (rA [[qUHilderthorpe45th Parallel'H F;GPW0!rAM7qUWindsorHolcim Sand Quarry Site'F F7GP3 rA|JiUNgaparaHolcim Coal Mine Site'K FEGP޿Ǘd$rA_8zULorneHolcim Lime/Tuff Quarry Site'S FUGPo=d$rAq,E{ULorneHolcim Cement Works Site Designation'F F/#GP6v$rAK01B̋UMcDonalds KakanuiLime Quarry'S F!KGPfkqA~} VMandevilleCroydon Aircraft Company Museum'? F1 GPxrA;UOCRTHyde Disaster Site'C F9 GPӖ rA\rUOCRTRoute Summit 618 m asl'8 F GP0ϗrA:C8UDunedinHillside'8 FGPpG6rA^KXqUTaieriFonterra'= F'GPFrAH>6UTaieriPolarcold/SFF'6 FGPM_Z=rAF㻵UTaieriOdlins' CUq9 Q  m 7  T  w ?  Y l0F YVR WwA N6~ FGPFrA53UOCRVMt Allan'6} FGPBrAeޭUOCRVMt Allan'=| F+GP8)rAwUOCRVLittle Mt Allan'={ F+GP:frARE UOCRVLittle Mt Allan'=z F+GPf1rA-oEUOCRVChristmas Creek'=y F+GPrA};sUOCRVChristmas Creek'4x FGPXuhrA\UOCRVHindon'4w FGPӇUhrA+LUOCRVHindon'4v FGPkYgrAY:^oUOCRVHindon'3u F GPCnrAE}UOCRVHindon'6t FGP_2rA}}u?UOCRVMt Allan';s F#GPb}vq rA ;UOCRBFlat Stream';r F#GP"!rAGSUOCRHFlat Stream'7q FGP"ĜrAKuQUOICRFRanfurly':p F%GP9rAKaUTGRWNorth Taieri'Go F/GPݮqATAUOCRVacuum/|Mobil OilAlexandra#cUOCRPest BoardAlexandra'>i F!GP.*qA*֜UOCRDOC OfficeClyde'Bh F!GPqqA- lUOCRDOC OfficeAlexandra'9g FGPC.qA oUOCRFAlexandra9f FGP`cwQqATחUOCRAAlexandra>e F'GPZ%9qA{UOCRH283Halfway House'7d FGP#qAyqUClydeHClydes'7c FGPqAxUClydeHClydes'7b FGPcqAaW=ՎUClydeHClydes'7a FGPd+qAbUClydeFClydes':` F!GP.3} rA9vUOCRWWedderburn':_ F!GPOCRYWedderburn':^ F!GP,bz rA#vUOCRHWedderburn':] F!GP6V" rA9U vUOCRHWedderburn':\ F!GPOCRHWedderburn':[ F!GP} rAiOvUOCRWWedderburn'7Z FGPcrAh˙UOCRHKokonga'7Y FGPrAT✂UOCRWKokonga'7X FGP" orAGJґUOCREKokonga'8W FGP\ߜrAƻUOCRWRanfurly'8V FGP.5rAG"UOCRYWaipiata'6U FGPjrAB UOCRYMt Allan'6T FGP.rA&{UOCRSMt Allan'4S FGP)'rrAiNWUOCRGSutton'4R FGPIprAUOCRYSutton'7Q FGPurA4hUOCRWNgapuna'?P F+GP+@HcgrAaWͯUOCRWRock and Pillar'4O FGPl9trA&UOCRAOmakau'4N FGPd~FrA:yUOCRALauder'4M FGPrA\4UOCRFOmakau4L FGP.urA"7oUOCRWOmakau'4K FGP!|rA UOCRWOmakau'8J F!GPr`rAzbwUOCRWIda Valley'8I F!GP#9b^rAU^wUOCRHIda Valley'8H F!GP) ^rAewUOCREIda Valley'8G F!GP;?drAFYwUOCRHIda Valley'8F F!GP-ν~rA(GwUOCRWIda Valley'8E F!GP?arA.2+[wUOCRHIda Valley'8D F!GPF~brA?cwUOCRFIda Valley'6C FGPM Q rA? rUOCRAOturehua'6B FGP  rAk sUOCRHOturehua'6A FGP rA'rUOCRYOturehua'8@ F!GPfrA#WwUOCRHIda Valley'8? F!GPlrAɈRwUOCRHIda Valley'8> F!GP.trAKMwUOCRAIda Valley'6= FGP6 rA,y~rqUOCREOturehua'7< FGP3RqA۶lUClydeLClydes' 9VzC a ' v ?  J V  f *x>Fn*St,J R>7 F#GPIlArAsmC\yUOCRBallast PitLauderr>6 F#GPA4rAֿa[yUOCRBallast PitLauderq:5 F%GPqHqAJEUOCRVChatto Creek':4 F%GP0qAbUOCRFChatto Creek':3 F%GPJLqAnUOCREChatto Creek'O2 F9%GPxqAA2W4UOCRRails & Sleepers DepotChatto Creek'J1 F1GPfqAթJUOCRRail Trail AmenityAlexandra'@0 FGP*fqAcB UOCRWW DepotAlexandraE/ F+GPҬqAr \hVUOCRLane & ThompsonAlexandraZ. FQGPqAhJ岗UOCRApple & Pear Board|/Freezing WorksAlexandra>- F!GP%U"LqA}EXUOCRMOWD DepotClyde>, F!GP=qAUOCRNZED DepotClydeB+ F!GP|qAb$UOCRCaltex OilAlexandraL* F5GPO+ZqALwUOCRFulton Hogan BitumenAlexandra@) F!GP)غqA UOCREuropa OilAlexandraA( FGPpqAw{fUOCRShell OilAlexandra>' FGPsH# F GP0O rATN&UOCRMemorialsThe Reefs'7" FGP}ihrA#UOCRVThe Reefs'@! F# GP rA'#UOCRReefs HotelThe Reefs'7 FGPCErAZ4UOCRVMt Allan'6 FGP8 YrAx?UOCRVMt Allan' R!-U!osFeaturesgeomgpkg_rtree_indexGeoPackage 1.0 Specification Annex Lwrite-only #!- osFeaturesgeomgpkg_rtree_index  9}|!s_UOmF<6-'gwqke_YSMGA;5/)#  { u o i c ] W Q K E ? 9 3 - ' !     { t m f _ X Q J C < 5 . '     x q j c \ U N G @ 976543210/.-,+*)('&%$#"!      ~}|{zyxwvutsrqponmlkjihgfedcba`_^]\[ZYXWVUTSRQPONMLKJIHGFEDCBA@?>=<;:98761-+  (# 0 2BB4/[,*[)'[&[$"!~.%5   3       -ZP$)KMKNʲ+ʲ+,KKʲDʲB*KKʱʱ)KKʱʱ-K%K&ʱoFʱoDKKʰͯʰͭK`{K`|ʰxʰw+KKʰDʰBKhKhʰʰ%K.K/ʰkʰiK^{K^|ʰ[ʰ[&KF6KF7ʯwʯu.K39K3:ʮ mʮ k7KKʬ%ʬ#2KKʬxBʬx@3KKʬx!ʬx4KKʬwʬw8KWKXʬvuʬvt9KgKhʬv;ʬv9K?ʮʮwKBKCʮlʮjxKGKHʮBʮ@rKK ʮʙʮʘsKKʮʮ0KKʮ=ʮ;SK{K{ʮJʮJRK{K{ʮHxʮHvKKʭ<ʭ:KKʭʭQK{K|ʭʭKaKcʭOʭMK9K:ʭeʭc'KKʭ$ʭ"PK;K<ʭ~qʭ~oKDKFʭCʭCK4K5ʭ@ʭ@KKKMʮoʮmKKʮNʮMK(K)ʯʯKKʮʮKKʮʮK1K3ʮʮKKʮʮKKʮʮKKʮqʮoKKʮ,ʮ+K K ʮʮKKʮʮKKʮKʮJKKʮʮKK?ʬ5!ʬ5qKwKwʬ2ʬ2WKvKvʬ,ʬ,$K&$K&%ʫʫ K#!K#"ʫ݌ʫ݊kKKʫʫlKK ʫʫ K#$K#%ʫʫmKcKcʫ ʫ K K ʫ>ʫ< KFKFʫʫKKʫP(ʫP& KKʫJWʫJUKJKLʫF[ʫFZ(KKʪ=ʪ=Kw7Kw9ʬ.ʬ.K=K>ʬʬKKʬ}ʬ}KKʬʬKaKbʬʬKKʬAʬAK2K4ʬ0ʬ0K4K5ʬ0/ʬ0-K>K?ʬ5Mʬ5KKKʫʫKBKCʫʫP$!5KK;K;ʫnʫlFK;K;ʫ;ʫ9^KcKcʫʫ[KcKcʫʫ]KcKcʫzʫy`KcKcʫʫ1KLKLʫLʫKBKNKNʫjʫhCKNKNʫʫAKOKOʫʫK^K^ʫʫKPKPʫRʫQK^K^ʫʫ=KQKQʫʫeK$K%ʬ ʬ _\ du 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"); END7.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")); ENDW+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 *EECtablertree_osFeatures_geom_parentrtree_osFeatures_geom_parentCREATE TABLE "rtree_osFeatures_geom_parent"(nodeno INTEGER PRIMARY KEY, parentnode INTEGER))CC7tablertree_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) '775tablertree_osFeatures_geomrtree_osFeatures_geomCREATE VIRTUAL TABLE "rtree_osFeatures_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)-85 -85