Revision 5709b824612b70f1eb93c77fc88963ced34a16df authored by Juergen E. Fischer on 18 March 2022, 12:04:18 UTC, committed by Juergen E. Fischer on 18 March 2022, 12:04:18 UTC
1 parent 240d988
spatialite.db
SQLite format 3 @ ö ûö ç êúôîç Ýs ¤p y
 «ñ f++tablespatial_ref_sysspatial_ref_sysCREATE TABLE spatial_ref_sys (
srid INTEGER NOT NULL PRIMARY KEY,
auth_name VARCHAR(256) NOT NULL,
auth_srid INTEGER NOT NULL,
ref_sys_name VARCHAR(256),
proj4text VARCHAR(2048) NOT NULL)C1+3triggerfkd_refsys_geocolsspatial_ref_sys CREATE TRIGGER fkd_refsys_geocols BEFORE DELETE ON spatial_ref_sys
FOR EACH ROW BEGIN
SELECT RAISE(ROLLBACK, 'delete on table ''spatial_ref_sys'' violates constraint: ''geometry_columns.srid''')
WHERE (SELECT srid FROM geometry_columns WHERE srid = OLD.srid) IS NOT NULL;
END--Ktablegeometry_columnsgeometry_columnsCREATE TABLE geometry_columns (
f_table_name VARCHAR(256) NOT NULL,
f_geometry_column VARCHAR(256) NOT NULL,
type VARCHAR(30) NOT NULL,
coord_dimension INTEGER NOT NULL,
srid INTEGER,
spatial_index_enabled INTEGER NOT NULL)
D D£ \1-ctriggerfki_geocols_refsysgeometry_columns CREATE TRIGGER fki_geocols_refsys BEFORE INSERT ON geometry_columns
FOR EACH ROW BEGIN
SELECT RAISE(ROLLBACK, 'insert on table ''geometry_columns'' violates constraint: ''spatial_ref_sys.srid''')
WHERE NEW."srid" IS NOT NULL
AND (SELECT srid FROM spatial_ref_sys WHERE srid = NEW.srid) IS NULL;
ENDZ1-_triggerfku_geocols_refsysgeometry_columns CREATE TRIGGER fku_geocols_refsys BEFORE UPDATE ON geometry_columns
FOR EACH ROW BEGIN
SELECT RAISE(ROLLBACK, 'update on table ''geometry_columns'' violates constraint: ''spatial_ref_sys.srid''')
WHERE NEW.srid IS NOT NULL
AND (SELECT srid FROM spatial_ref_sys WHERE srid = NEW.srid) IS NULL;
END
J JÉ }#-7indexidx_geocolsgeometry_columnsCREATE UNIQUE INDEX idx_geocols ON geometry_columns
(f_table_name, f_geometry_column)4//viewgeom_cols_ref_sysgeom_cols_ref_sys CREATE VIEW geom_cols_ref_sys AS
SELECT f_table_name, f_geometry_column, type,
coord_dimension, spatial_ref_sys.srid AS srid,
auth_name, auth_srid, ref_sys_name, proj4text
FROM geometry_columns, spatial_ref_sys
WHERE geometry_columns.srid = spatial_ref_sys.srid
%Å@ P ]]epsgÐAnguilla 1957 / British West Indies Grid+proj=tmerc +lat_0=0 +lon_0=-62 +k=0.9995000000000001 +x_0=400000 +y_0=0 +ellps=clrk80 +units=m +no_defsQ []epsgÑAntigua 1943 / British West Indies Grid+proj=tmerc +lat_0=0 +lon_0=-62 +k=0.9995000000000001 +x_0=400000 +y_0=0 +ellps=clrk80 +units=m +no_defs:R ]epsgÒDominica 1945 / British West Indies Grid+proj=tmerc +lat_0=0 +lon_0=-62 +k=0.9995000000000001 +x_0=400000 +y_0=0 +ellps=clrk80 +towgs84=725,685,536,0,0,0,0 +units=m +no_defs9S [epsgÓGrenada 1953 / British West Indies Grid+proj=tmerc +lat_0=0 +lon_0=-62 +k=0.9995000000000001 +x_0=400000 +y_0=0 +ellps=clrk80 +towgs84=72,213.7,93,0,0,0,0 +units=m +no_defs<T aepsgÔMontserrat 1958 / British West Indies Grid+proj=tmerc +lat_0=0 +lon_0=-62 +k=0.9995000000000001 +x_0=400000 +y_0=0 +ellps=clrk80 +towgs84=174,359,365,0,0,0,0 +units=m +no_defs
5 5 ×bìv U _]epsgÕSt. Kitts 1955 / British West Indies Grid+proj=tmerc +lat_0=0 +lon_0=-62 +k=0.9995000000000001 +x_0=400000 +y_0=0 +ellps=clrk80 +units=m +no_defs<V _epsgÖSt. Lucia 1955 / British West Indies Grid+proj=tmerc +lat_0=0 +lon_0=-62 +k=0.9995000000000001 +x_0=400000 +y_0=0 +ellps=clrk80 +towgs84=-149,128,296,0,0,0,0 +units=m +no_defsGW _/epsg×St. Vincent 45 / British West Indies Grid+proj=tmerc +lat_0=0 +lon_0=-62 +k=0.9995000000000001 +x_0=400000 +y_0=0 +ellps=clrk80 +towgs84=195.671,332.517,274.607,0,0,0,0 +units=m +no_defsX CIepsgØNAD27(CGQ77) / SCoPQ zone 2+proj=tmerc +lat_0=0 +lon_0=-55.5 +k=0.9999 +x_0=304800 +y_0=0 +ellps=clrk66 +units=m +no_defsY CIepsgÙNAD27(CGQ77) / SCoPQ zone 3+proj=tmerc +lat_0=0 +lon_0=-58.5 +k=0.9999 +x_0=304800 +y_0=0 +ellps=clrk66 +units=m +no_defsZ CIepsgÚNAD27(CGQ77) / SCoPQ zone 4+proj=tmerc +lat_0=0 +lon_0=-61.5 +k=0.9999 +x_0=304800 +y_0=0 +ellps=clrk66 +units=m +no_defs
>