SQLite format 3 @
' GPKG
.f
h
Um % WGS 84 / NSIDC Sea Ice Polar Stereographic NorthEPSG
UPROJCS["WGS 84 / NSIDC Sea Ice Polar Stereographic North",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["Polar_Stereographic"],PARAMETER["latitude_of_origin",70],PARAMETER["central_meridian",-45],PARAMETER["false_easting",0],PARAMETER["false_northing",0],UNIT["metre",1,AUTHORITY["EPSG","9001"]],AXIS["Easting",SOUTH],AXIS["Northing",SOUTH],AUTHORITY["EPSG","3413"]]\ = 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
z z CC
=hotosm_grl_sea_ports_pointsfeatureshotosm_grl_sea_ports_points2023-05-10T00:31:50.478Z:I:(z@a @
U
C hotosm_grl_sea_ports_points
C hotosm_grl_sea_ports_points
Chotosm_grl_sea_ports_points
C hotosm_grl_sea_ports_points
-Chotosm_grl_sea_ports_pointsgeomPOINT
U
#C hotosm_grl_sea_ports_pointsgeom
C hotosm_grl_sea_ports_points
M | hk~ w8 M 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); 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_setCREATE 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 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 ]7 indexsqlite_autoindex_gpkg_geometry_columns_2gpkg_geometry_columns
I]7 indexsqlite_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_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)
w ,(N
T
7 w w 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 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))''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 '')=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)]CCAtablehotosm_grl_sea_ports_pointshotosm_grl_sea_ports_pointsCREATE TABLE "hotosm_grl_sea_ports_points" ( "fid" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "geom" POINT, "osm_id" REAL, "building" TEXT(80), "name" TEXT(80), "operatorty" TEXT(80), "port" TEXT(80), "addrfull" TEXT(80), "addrcity" TEXT(80), "source" TEXT(80), "amenity" TEXT(80))
>n1
m
&X\
`
! = F )GP U
ʉlKlk4.$A ϻferry_terminal= F )GP U
kݢr
fT*i`A nferry_terminal= F )GP U
BCuޥ6A pferry_terminal= F )GP U
BCuޥ6A pferry_terminal= F )GP U
BCuޥ6A pferry_terminal= F )GP U
f/Ɇ=H Jferry_terminal= F )GP U
}G!hVH 7"ferry_terminal= F )GP U
'Ȝ" H *1ferry_terminal= F )GP U
NMьP6'XH *ferry_terminal= F )GP U
l6LqQH *{ferry_terminal= F )GP U
Vn$H *^?ferry_terminal=
F )GP U
HΘ/}A &DEferry_terminalN F / )GP U
Mg}
TAA ;ѳArctic Umiaq Lineferry_terminalE F )GP U
mGQ1YH RKongeBroferry_terminal=
F )GP U
[9P$Lw].C ʻferry_terminal= F )GP U
a@z):I A-ferry_terminalD F )GP U
P(LpV[nDsOManiitsoqferry_terminal; F )GP U
BCuޥ6ArT&ferry_terminalC F )GP U
'LaICrJSisimiutferry_terminalE F ! )GP U
:~@
DrJKangaamiutferry_terminalB F )GP U
2ǡl(Al]-Rodebayferry_terminalF F # )GP U
.@k,Port Victorferry_terminal; F )GP U
fzYƐ-CG߯ferry_terminal; F )GP U
A6$A;1ferry_terminal
Chotosm_grl_sea_ports_points
4 qC-q!hotosm_grl_sea_ports_pointsgeomgpkg_rtree_indexhttp://www.geopackage.org/spec120/#extension_rtreewrite-onlyi; 'w!gpkg_metadata_referencegpkg_metadatahttp://www.geopackage.org/spec120/#extension_metadataread-write_' 'w!gpkg_metadatagpkg_metadatahttp://www.geopackage.org/spec120/#extension_metadataread-write
5C-hotosm_grl_sea_ports_pointsgeomgpkg_rtree_index*; 'gpkg_metadata_referencegpkg_metadata' ' gpkg_metadatagpkg_metadata
U +mdatasethttp://gdal.orgtext/xml
2021-03-05
UTF-8
UTF-8
UTF-8
@C = tablehotosm_grl_sea_ports_points2023-05-10T00:31:50.427Z
- - P $ ȤȤ ! ! t{t{ll E@E>wv ff Cf Ce ȼPȼP n n ȺgȺgPN ț\țZ
g
f ȵm,ȵm*#r#r XXII
҇҅rr ddEE k