SELECT key, value FROM metadata WHERE key IN ('DATABASE.LAYOUT.VERSION.MAJOR', 'DATABASE.LAYOUT.VERSION.MINOR');
SELECT type FROM crs_view WHERE auth_name = 'EPSG' AND code = '4326';
SELECT name, type, coordinate_system_auth_name, coordinate_system_code, datum_auth_name, datum_code, text_definition, deprecated, description FROM geodetic_crs WHERE auth_name = 'EPSG' AND code = '4326';
SELECT extent.description, extent.south_lat, extent.north_lat, extent.west_lon, extent.east_lon, scope.scope, 0 AS score FROM extent, scope WHERE extent.code = 1262 and scope.code = 1183;
SELECT axis.name, abbrev, orientation, uom_auth_name, uom_code, cs.type FROM axis LEFT JOIN coordinate_system cs ON axis.coordinate_system_auth_name = cs.auth_name AND axis.coordinate_system_code = cs.code WHERE coordinate_system_auth_name = 'EPSG' AND coordinate_system_code = '6422' ORDER BY coordinate_system_order;
SELECT name, conv_factor, type, deprecated FROM unit_of_measure WHERE auth_name = 'EPSG' AND code = '9122';
SELECT name, ellipsoid_auth_name, ellipsoid_code, prime_meridian_auth_name, prime_meridian_code, publication_date, frame_reference_epoch, ensemble_accuracy, anchor, deprecated FROM geodetic_datum WHERE auth_name = 'EPSG' AND code = '6326';
SELECT extent.description, extent.south_lat, extent.north_lat, extent.west_lon, extent.east_lon, scope.scope, (CASE WHEN scope.scope LIKE '%large scale%' THEN 0 ELSE 1 END) AS score FROM usage JOIN extent ON usage.extent_auth_name = extent.auth_name AND usage.extent_code = extent.code JOIN scope ON usage.scope_auth_name = scope.auth_name AND usage.scope_code = scope.code WHERE object_table_name = 'geodetic_datum' AND object_auth_name = 'EPSG' AND object_code = '6326' AND NOT (usage.extent_auth_name = 'PROJ' AND usage.extent_code = 'EXTENT_UNKNOWN') AND NOT (usage.scope_auth_name = 'PROJ' AND usage.scope_code = 'SCOPE_UNKNOWN') ORDER BY score, usage.auth_name, usage.code;
SELECT member_auth_name, member_code FROM geodetic_datum_ensemble_member WHERE ensemble_auth_name = 'EPSG' AND ensemble_code = '6326' ORDER BY sequence;
SELECT 'geodetic_datum' FROM geodetic_datum WHERE auth_name = 'EPSG' AND code = '1166' UNION ALL SELECT 'vertical_datum' FROM vertical_datum WHERE auth_name = 'EPSG' AND code = '1166';
SELECT name, ellipsoid_auth_name, ellipsoid_code, prime_meridian_auth_name, prime_meridian_code, publication_date, frame_reference_epoch, ensemble_accuracy, anchor, deprecated FROM geodetic_datum WHERE auth_name = 'EPSG' AND code = '1166';
SELECT extent.description, extent.south_lat, extent.north_lat, extent.west_lon, extent.east_lon, scope.scope, (CASE WHEN scope.scope LIKE '%large scale%' THEN 0 ELSE 1 END) AS score FROM usage JOIN extent ON usage.extent_auth_name = extent.auth_name AND usage.extent_code = extent.code JOIN scope ON usage.scope_auth_name = scope.auth_name AND usage.scope_code = scope.code WHERE object_table_name = 'geodetic_datum' AND object_auth_name = 'EPSG' AND object_code = '1166' AND NOT (usage.extent_auth_name = 'PROJ' AND usage.extent_code = 'EXTENT_UNKNOWN') AND NOT (usage.scope_auth_name = 'PROJ' AND usage.scope_code = 'SCOPE_UNKNOWN') ORDER BY score, usage.auth_name, usage.code;
SELECT ellipsoid.name, ellipsoid.semi_major_axis, ellipsoid.uom_auth_name, ellipsoid.uom_code, ellipsoid.inv_flattening, ellipsoid.semi_minor_axis, celestial_body.name AS body_name, ellipsoid.deprecated FROM ellipsoid JOIN celestial_body ON ellipsoid.celestial_body_auth_name = celestial_body.auth_name AND ellipsoid.celestial_body_code = celestial_body.code WHERE ellipsoid.auth_name = 'EPSG' AND ellipsoid.code = '7030';
SELECT name, conv_factor, type, deprecated FROM unit_of_measure WHERE auth_name = 'EPSG' AND code = '9001';
SELECT name, longitude, uom_auth_name, uom_code, deprecated FROM prime_meridian WHERE auth_name = 'EPSG' AND code = '8901';
SELECT name, conv_factor, type, deprecated FROM unit_of_measure WHERE auth_name = 'EPSG' AND code = '9102';
SELECT 'geodetic_datum' FROM geodetic_datum WHERE auth_name = 'EPSG' AND code = '1152' UNION ALL SELECT 'vertical_datum' FROM vertical_datum WHERE auth_name = 'EPSG' AND code = '1152';
SELECT name, ellipsoid_auth_name, ellipsoid_code, prime_meridian_auth_name, prime_meridian_code, publication_date, frame_reference_epoch, ensemble_accuracy, anchor, deprecated FROM geodetic_datum WHERE auth_name = 'EPSG' AND code = '1152';
SELECT extent.description, extent.south_lat, extent.north_lat, extent.west_lon, extent.east_lon, scope.scope, (CASE WHEN scope.scope LIKE '%large scale%' THEN 0 ELSE 1 END) AS score FROM usage JOIN extent ON usage.extent_auth_name = extent.auth_name AND usage.extent_code = extent.code JOIN scope ON usage.scope_auth_name = scope.auth_name AND usage.scope_code = scope.code WHERE object_table_name = 'geodetic_datum' AND object_auth_name = 'EPSG' AND object_code = '1152' AND NOT (usage.extent_auth_name = 'PROJ' AND usage.extent_code = 'EXTENT_UNKNOWN') AND NOT (usage.scope_auth_name = 'PROJ' AND usage.scope_code = 'SCOPE_UNKNOWN') ORDER BY score, usage.auth_name, usage.code;
SELECT 'geodetic_datum' FROM geodetic_datum WHERE auth_name = 'EPSG' AND code = '1153' UNION ALL SELECT 'vertical_datum' FROM vertical_datum WHERE auth_name = 'EPSG' AND code = '1153';
SELECT name, ellipsoid_auth_name, ellipsoid_code, prime_meridian_auth_name, prime_meridian_code, publication_date, frame_reference_epoch, ensemble_accuracy, anchor, deprecated FROM geodetic_datum WHERE auth_name = 'EPSG' AND code = '1153';
SELECT extent.description, extent.south_lat, extent.north_lat, extent.west_lon, extent.east_lon, scope.scope, (CASE WHEN scope.scope LIKE '%large scale%' THEN 0 ELSE 1 END) AS score FROM usage JOIN extent ON usage.extent_auth_name = extent.auth_name AND usage.extent_code = extent.code JOIN scope ON usage.scope_auth_name = scope.auth_name AND usage.scope_code = scope.code WHERE object_table_name = 'geodetic_datum' AND object_auth_name = 'EPSG' AND object_code = '1153' AND NOT (usage.extent_auth_name = 'PROJ' AND usage.extent_code = 'EXTENT_UNKNOWN') AND NOT (usage.scope_auth_name = 'PROJ' AND usage.scope_code = 'SCOPE_UNKNOWN') ORDER BY score, usage.auth_name, usage.code;
SELECT 'geodetic_datum' FROM geodetic_datum WHERE auth_name = 'EPSG' AND code = '1154' UNION ALL SELECT 'vertical_datum' FROM vertical_datum WHERE auth_name = 'EPSG' AND code = '1154';
SELECT name, ellipsoid_auth_name, ellipsoid_code, prime_meridian_auth_name, prime_meridian_code, publication_date, frame_reference_epoch, ensemble_accuracy, anchor, deprecated FROM geodetic_datum WHERE auth_name = 'EPSG' AND code = '1154';
SELECT extent.description, extent.south_lat, extent.north_lat, extent.west_lon, extent.east_lon, scope.scope, (CASE WHEN scope.scope LIKE '%large scale%' THEN 0 ELSE 1 END) AS score FROM usage JOIN extent ON usage.extent_auth_name = extent.auth_name AND usage.extent_code = extent.code JOIN scope ON usage.scope_auth_name = scope.auth_name AND usage.scope_code = scope.code WHERE object_table_name = 'geodetic_datum' AND object_auth_name = 'EPSG' AND object_code = '1154' AND NOT (usage.extent_auth_name = 'PROJ' AND usage.extent_code = 'EXTENT_UNKNOWN') AND NOT (usage.scope_auth_name = 'PROJ' AND usage.scope_code = 'SCOPE_UNKNOWN') ORDER BY score, usage.auth_name, usage.code;
SELECT 'geodetic_datum' FROM geodetic_datum WHERE auth_name = 'EPSG' AND code = '1155' UNION ALL SELECT 'vertical_datum' FROM vertical_datum WHERE auth_name = 'EPSG' AND code = '1155';
SELECT name, ellipsoid_auth_name, ellipsoid_code, prime_meridian_auth_name, prime_meridian_code, publication_date, frame_reference_epoch, ensemble_accuracy, anchor, deprecated FROM geodetic_datum WHERE auth_name = 'EPSG' AND code = '1155';
SELECT extent.description, extent.south_lat, extent.north_lat, extent.west_lon, extent.east_lon, scope.scope, (CASE WHEN scope.scope LIKE '%large scale%' THEN 0 ELSE 1 END) AS score FROM usage JOIN extent ON usage.extent_auth_name = extent.auth_name AND usage.extent_code = extent.code JOIN scope ON usage.scope_auth_name = scope.auth_name AND usage.scope_code = scope.code WHERE object_table_name = 'geodetic_datum' AND object_auth_name = 'EPSG' AND object_code = '1155' AND NOT (usage.extent_auth_name = 'PROJ' AND usage.extent_code = 'EXTENT_UNKNOWN') AND NOT (usage.scope_auth_name = 'PROJ' AND usage.scope_code = 'SCOPE_UNKNOWN') ORDER BY score, usage.auth_name, usage.code;
SELECT 'geodetic_datum' FROM geodetic_datum WHERE auth_name = 'EPSG' AND code = '1156' UNION ALL SELECT 'vertical_datum' FROM vertical_datum WHERE auth_name = 'EPSG' AND code = '1156';
SELECT name, ellipsoid_auth_name, ellipsoid_code, prime_meridian_auth_name, prime_meridian_code, publication_date, frame_reference_epoch, ensemble_accuracy, anchor, deprecated FROM geodetic_datum WHERE auth_name = 'EPSG' AND code = '1156';
SELECT extent.description, extent.south_lat, extent.north_lat, extent.west_lon, extent.east_lon, scope.scope, (CASE WHEN scope.scope LIKE '%large scale%' THEN 0 ELSE 1 END) AS score FROM usage JOIN extent ON usage.extent_auth_name = extent.auth_name AND usage.extent_code = extent.code JOIN scope ON usage.scope_auth_name = scope.auth_name AND usage.scope_code = scope.code WHERE object_table_name = 'geodetic_datum' AND object_auth_name = 'EPSG' AND object_code = '1156' AND NOT (usage.extent_auth_name = 'PROJ' AND usage.extent_code = 'EXTENT_UNKNOWN') AND NOT (usage.scope_auth_name = 'PROJ' AND usage.scope_code = 'SCOPE_UNKNOWN') ORDER BY score, usage.auth_name, usage.code;
SELECT 'geodetic_datum' FROM geodetic_datum WHERE auth_name = 'EPSG' AND code = '1309' UNION ALL SELECT 'vertical_datum' FROM vertical_datum WHERE auth_name = 'EPSG' AND code = '1309';
SELECT name, ellipsoid_auth_name, ellipsoid_code, prime_meridian_auth_name, prime_meridian_code, publication_date, frame_reference_epoch, ensemble_accuracy, anchor, deprecated FROM geodetic_datum WHERE auth_name = 'EPSG' AND code = '1309';
SELECT extent.description, extent.south_lat, extent.north_lat, extent.west_lon, extent.east_lon, scope.scope, (CASE WHEN scope.scope LIKE '%large scale%' THEN 0 ELSE 1 END) AS score FROM usage JOIN extent ON usage.extent_auth_name = extent.auth_name AND usage.extent_code = extent.code JOIN scope ON usage.scope_auth_name = scope.auth_name AND usage.scope_code = scope.code WHERE object_table_name = 'geodetic_datum' AND object_auth_name = 'EPSG' AND object_code = '1309' AND NOT (usage.extent_auth_name = 'PROJ' AND usage.extent_code = 'EXTENT_UNKNOWN') AND NOT (usage.scope_auth_name = 'PROJ' AND usage.scope_code = 'SCOPE_UNKNOWN') ORDER BY score, usage.auth_name, usage.code;
SELECT type FROM crs_view WHERE auth_name = 'EPSG' AND code = '4258';
SELECT name, type, coordinate_system_auth_name, coordinate_system_code, datum_auth_name, datum_code, text_definition, deprecated, description FROM geodetic_crs WHERE auth_name = 'EPSG' AND code = '4258';
SELECT extent.description, extent.south_lat, extent.north_lat, extent.west_lon, extent.east_lon, scope.scope, (CASE WHEN scope.scope LIKE '%large scale%' THEN 0 ELSE 1 END) AS score FROM usage JOIN extent ON usage.extent_auth_name = extent.auth_name AND usage.extent_code = extent.code JOIN scope ON usage.scope_auth_name = scope.auth_name AND usage.scope_code = scope.code WHERE object_table_name = 'geodetic_crs' AND object_auth_name = 'EPSG' AND object_code = '4258' AND NOT (usage.extent_auth_name = 'PROJ' AND usage.extent_code = 'EXTENT_UNKNOWN') AND NOT (usage.scope_auth_name = 'PROJ' AND usage.scope_code = 'SCOPE_UNKNOWN') ORDER BY score, usage.auth_name, usage.code;
SELECT name, ellipsoid_auth_name, ellipsoid_code, prime_meridian_auth_name, prime_meridian_code, publication_date, frame_reference_epoch, ensemble_accuracy, anchor, deprecated FROM geodetic_datum WHERE auth_name = 'EPSG' AND code = '6258';
SELECT extent.description, extent.south_lat, extent.north_lat, extent.west_lon, extent.east_lon, scope.scope, (CASE WHEN scope.scope LIKE '%large scale%' THEN 0 ELSE 1 END) AS score FROM usage JOIN extent ON usage.extent_auth_name = extent.auth_name AND usage.extent_code = extent.code JOIN scope ON usage.scope_auth_name = scope.auth_name AND usage.scope_code = scope.code WHERE object_table_name = 'geodetic_datum' AND object_auth_name = 'EPSG' AND object_code = '6258' AND NOT (usage.extent_auth_name = 'PROJ' AND usage.extent_code = 'EXTENT_UNKNOWN') AND NOT (usage.scope_auth_name = 'PROJ' AND usage.scope_code = 'SCOPE_UNKNOWN') ORDER BY score, usage.auth_name, usage.code;
SELECT member_auth_name, member_code FROM geodetic_datum_ensemble_member WHERE ensemble_auth_name = 'EPSG' AND ensemble_code = '6258' ORDER BY sequence;
SELECT 'geodetic_datum' FROM geodetic_datum WHERE auth_name = 'EPSG' AND code = '1178' UNION ALL SELECT 'vertical_datum' FROM vertical_datum WHERE auth_name = 'EPSG' AND code = '1178';
SELECT name, ellipsoid_auth_name, ellipsoid_code, prime_meridian_auth_name, prime_meridian_code, publication_date, frame_reference_epoch, ensemble_accuracy, anchor, deprecated FROM geodetic_datum WHERE auth_name = 'EPSG' AND code = '1178';
SELECT extent.description, extent.south_lat, extent.north_lat, extent.west_lon, extent.east_lon, scope.scope, (CASE WHEN scope.scope LIKE '%large scale%' THEN 0 ELSE 1 END) AS score FROM usage JOIN extent ON usage.extent_auth_name = extent.auth_name AND usage.extent_code = extent.code JOIN scope ON usage.scope_auth_name = scope.auth_name AND usage.scope_code = scope.code WHERE object_table_name = 'geodetic_datum' AND object_auth_name = 'EPSG' AND object_code = '1178' AND NOT (usage.extent_auth_name = 'PROJ' AND usage.extent_code = 'EXTENT_UNKNOWN') AND NOT (usage.scope_auth_name = 'PROJ' AND usage.scope_code = 'SCOPE_UNKNOWN') ORDER BY score, usage.auth_name, usage.code;
SELECT ellipsoid.name, ellipsoid.semi_major_axis, ellipsoid.uom_auth_name, ellipsoid.uom_code, ellipsoid.inv_flattening, ellipsoid.semi_minor_axis, celestial_body.name AS body_name, ellipsoid.deprecated FROM ellipsoid JOIN celestial_body ON ellipsoid.celestial_body_auth_name = celestial_body.auth_name AND ellipsoid.celestial_body_code = celestial_body.code WHERE ellipsoid.auth_name = 'EPSG' AND ellipsoid.code = '7019';
SELECT 'geodetic_datum' FROM geodetic_datum WHERE auth_name = 'EPSG' AND code = '1179' UNION ALL SELECT 'vertical_datum' FROM vertical_datum WHERE auth_name = 'EPSG' AND code = '1179';
SELECT name, ellipsoid_auth_name, ellipsoid_code, prime_meridian_auth_name, prime_meridian_code, publication_date, frame_reference_epoch, ensemble_accuracy, anchor, deprecated FROM geodetic_datum WHERE auth_name = 'EPSG' AND code = '1179';
SELECT extent.description, extent.south_lat, extent.north_lat, extent.west_lon, extent.east_lon, scope.scope, (CASE WHEN scope.scope LIKE '%large scale%' THEN 0 ELSE 1 END) AS score FROM usage JOIN extent ON usage.extent_auth_name = extent.auth_name AND usage.extent_code = extent.code JOIN scope ON usage.scope_auth_name = scope.auth_name AND usage.scope_code = scope.code WHERE object_table_name = 'geodetic_datum' AND object_auth_name = 'EPSG' AND object_code = '1179' AND NOT (usage.extent_auth_name = 'PROJ' AND usage.extent_code = 'EXTENT_UNKNOWN') AND NOT (usage.scope_auth_name = 'PROJ' AND usage.scope_code = 'SCOPE_UNKNOWN') ORDER BY score, usage.auth_name, usage.code;
SELECT 'geodetic_datum' FROM geodetic_datum WHERE auth_name = 'EPSG' AND code = '1180' UNION ALL SELECT 'vertical_datum' FROM vertical_datum WHERE auth_name = 'EPSG' AND code = '1180';
SELECT name, ellipsoid_auth_name, ellipsoid_code, prime_meridian_auth_name, prime_meridian_code, publication_date, frame_reference_epoch, ensemble_accuracy, anchor, deprecated FROM geodetic_datum WHERE auth_name = 'EPSG' AND code = '1180';
SELECT extent.description, extent.south_lat, extent.north_lat, extent.west_lon, extent.east_lon, scope.scope, (CASE WHEN scope.scope LIKE '%large scale%' THEN 0 ELSE 1 END) AS score FROM usage JOIN extent ON usage.extent_auth_name = extent.auth_name AND usage.extent_code = extent.code JOIN scope ON usage.scope_auth_name = scope.auth_name AND usage.scope_code = scope.code WHERE object_table_name = 'geodetic_datum' AND object_auth_name = 'EPSG' AND object_code = '1180' AND NOT (usage.extent_auth_name = 'PROJ' AND usage.extent_code = 'EXTENT_UNKNOWN') AND NOT (usage.scope_auth_name = 'PROJ' AND usage.scope_code = 'SCOPE_UNKNOWN') ORDER BY score, usage.auth_name, usage.code;
SELECT 'geodetic_datum' FROM geodetic_datum WHERE auth_name = 'EPSG' AND code = '1181' UNION ALL SELECT 'vertical_datum' FROM vertical_datum WHERE auth_name = 'EPSG' AND code = '1181';
SELECT name, ellipsoid_auth_name, ellipsoid_code, prime_meridian_auth_name, prime_meridian_code, publication_date, frame_reference_epoch, ensemble_accuracy, anchor, deprecated FROM geodetic_datum WHERE auth_name = 'EPSG' AND code = '1181';
SELECT extent.description, extent.south_lat, extent.north_lat, extent.west_lon, extent.east_lon, scope.scope, (CASE WHEN scope.scope LIKE '%large scale%' THEN 0 ELSE 1 END) AS score FROM usage JOIN extent ON usage.extent_auth_name = extent.auth_name AND usage.extent_code = extent.code JOIN scope ON usage.scope_auth_name = scope.auth_name AND usage.scope_code = scope.code WHERE object_table_name = 'geodetic_datum' AND object_auth_name = 'EPSG' AND object_code = '1181' AND NOT (usage.extent_auth_name = 'PROJ' AND usage.extent_code = 'EXTENT_UNKNOWN') AND NOT (usage.scope_auth_name = 'PROJ' AND usage.scope_code = 'SCOPE_UNKNOWN') ORDER BY score, usage.auth_name, usage.code;
SELECT 'geodetic_datum' FROM geodetic_datum WHERE auth_name = 'EPSG' AND code = '1182' UNION ALL SELECT 'vertical_datum' FROM vertical_datum WHERE auth_name = 'EPSG' AND code = '1182';
SELECT name, ellipsoid_auth_name, ellipsoid_code, prime_meridian_auth_name, prime_meridian_code, publication_date, frame_reference_epoch, ensemble_accuracy, anchor, deprecated FROM geodetic_datum WHERE auth_name = 'EPSG' AND code = '1182';
SELECT extent.description, extent.south_lat, extent.north_lat, extent.west_lon, extent.east_lon, scope.scope, (CASE WHEN scope.scope LIKE '%large scale%' THEN 0 ELSE 1 END) AS score FROM usage JOIN extent ON usage.extent_auth_name = extent.auth_name AND usage.extent_code = extent.code JOIN scope ON usage.scope_auth_name = scope.auth_name AND usage.scope_code = scope.code WHERE object_table_name = 'geodetic_datum' AND object_auth_name = 'EPSG' AND object_code = '1182' AND NOT (usage.extent_auth_name = 'PROJ' AND usage.extent_code = 'EXTENT_UNKNOWN') AND NOT (usage.scope_auth_name = 'PROJ' AND usage.scope_code = 'SCOPE_UNKNOWN') ORDER BY score, usage.auth_name, usage.code;
SELECT 'geodetic_datum' FROM geodetic_datum WHERE auth_name = 'EPSG' AND code = '1183' UNION ALL SELECT 'vertical_datum' FROM vertical_datum WHERE auth_name = 'EPSG' AND code = '1183';
SELECT name, ellipsoid_auth_name, ellipsoid_code, prime_meridian_auth_name, prime_meridian_code, publication_date, frame_reference_epoch, ensemble_accuracy, anchor, deprecated FROM geodetic_datum WHERE auth_name = 'EPSG' AND code = '1183';
SELECT extent.description, extent.south_lat, extent.north_lat, extent.west_lon, extent.east_lon, scope.scope, (CASE WHEN scope.scope LIKE '%large scale%' THEN 0 ELSE 1 END) AS score FROM usage JOIN extent ON usage.extent_auth_name = extent.auth_name AND usage.extent_code = extent.code JOIN scope ON usage.scope_auth_name = scope.auth_name AND usage.scope_code = scope.code WHERE object_table_name = 'geodetic_datum' AND object_auth_name = 'EPSG' AND object_code = '1183' AND NOT (usage.extent_auth_name = 'PROJ' AND usage.extent_code = 'EXTENT_UNKNOWN') AND NOT (usage.scope_auth_name = 'PROJ' AND usage.scope_code = 'SCOPE_UNKNOWN') ORDER BY score, usage.auth_name, usage.code;
SELECT 'geodetic_datum' FROM geodetic_datum WHERE auth_name = 'EPSG' AND code = '1184' UNION ALL SELECT 'vertical_datum' FROM vertical_datum WHERE auth_name = 'EPSG' AND code = '1184';
SELECT name, ellipsoid_auth_name, ellipsoid_code, prime_meridian_auth_name, prime_meridian_code, publication_date, frame_reference_epoch, ensemble_accuracy, anchor, deprecated FROM geodetic_datum WHERE auth_name = 'EPSG' AND code = '1184';
SELECT extent.description, extent.south_lat, extent.north_lat, extent.west_lon, extent.east_lon, scope.scope, (CASE WHEN scope.scope LIKE '%large scale%' THEN 0 ELSE 1 END) AS score FROM usage JOIN extent ON usage.extent_auth_name = extent.auth_name AND usage.extent_code = extent.code JOIN scope ON usage.scope_auth_name = scope.auth_name AND usage.scope_code = scope.code WHERE object_table_name = 'geodetic_datum' AND object_auth_name = 'EPSG' AND object_code = '1184' AND NOT (usage.extent_auth_name = 'PROJ' AND usage.extent_code = 'EXTENT_UNKNOWN') AND NOT (usage.scope_auth_name = 'PROJ' AND usage.scope_code = 'SCOPE_UNKNOWN') ORDER BY score, usage.auth_name, usage.code;
SELECT 'geodetic_datum' FROM geodetic_datum WHERE auth_name = 'EPSG' AND code = '1185' UNION ALL SELECT 'vertical_datum' FROM vertical_datum WHERE auth_name = 'EPSG' AND code = '1185';
SELECT name, ellipsoid_auth_name, ellipsoid_code, prime_meridian_auth_name, prime_meridian_code, publication_date, frame_reference_epoch, ensemble_accuracy, anchor, deprecated FROM geodetic_datum WHERE auth_name = 'EPSG' AND code = '1185';
SELECT extent.description, extent.south_lat, extent.north_lat, extent.west_lon, extent.east_lon, scope.scope, (CASE WHEN scope.scope LIKE '%large scale%' THEN 0 ELSE 1 END) AS score FROM usage JOIN extent ON usage.extent_auth_name = extent.auth_name AND usage.extent_code = extent.code JOIN scope ON usage.scope_auth_name = scope.auth_name AND usage.scope_code = scope.code WHERE object_table_name = 'geodetic_datum' AND object_auth_name = 'EPSG' AND object_code = '1185' AND NOT (usage.extent_auth_name = 'PROJ' AND usage.extent_code = 'EXTENT_UNKNOWN') AND NOT (usage.scope_auth_name = 'PROJ' AND usage.scope_code = 'SCOPE_UNKNOWN') ORDER BY score, usage.auth_name, usage.code;
SELECT 'geodetic_datum' FROM geodetic_datum WHERE auth_name = 'EPSG' AND code = '1186' UNION ALL SELECT 'vertical_datum' FROM vertical_datum WHERE auth_name = 'EPSG' AND code = '1186';
SELECT name, ellipsoid_auth_name, ellipsoid_code, prime_meridian_auth_name, prime_meridian_code, publication_date, frame_reference_epoch, ensemble_accuracy, anchor, deprecated FROM geodetic_datum WHERE auth_name = 'EPSG' AND code = '1186';
SELECT extent.description, extent.south_lat, extent.north_lat, extent.west_lon, extent.east_lon, scope.scope, (CASE WHEN scope.scope LIKE '%large scale%' THEN 0 ELSE 1 END) AS score FROM usage JOIN extent ON usage.extent_auth_name = extent.auth_name AND usage.extent_code = extent.code JOIN scope ON usage.scope_auth_name = scope.auth_name AND usage.scope_code = scope.code WHERE object_table_name = 'geodetic_datum' AND object_auth_name = 'EPSG' AND object_code = '1186' AND NOT (usage.extent_auth_name = 'PROJ' AND usage.extent_code = 'EXTENT_UNKNOWN') AND NOT (usage.scope_auth_name = 'PROJ' AND usage.scope_code = 'SCOPE_UNKNOWN') ORDER BY score, usage.auth_name, usage.code;
SELECT 'geodetic_datum' FROM geodetic_datum WHERE auth_name = 'EPSG' AND code = '1204' UNION ALL SELECT 'vertical_datum' FROM vertical_datum WHERE auth_name = 'EPSG' AND code = '1204';
SELECT name, ellipsoid_auth_name, ellipsoid_code, prime_meridian_auth_name, prime_meridian_code, publication_date, frame_reference_epoch, ensemble_accuracy, anchor, deprecated FROM geodetic_datum WHERE auth_name = 'EPSG' AND code = '1204';
SELECT extent.description, extent.south_lat, extent.north_lat, extent.west_lon, extent.east_lon, scope.scope, (CASE WHEN scope.scope LIKE '%large scale%' THEN 0 ELSE 1 END) AS score FROM usage JOIN extent ON usage.extent_auth_name = extent.auth_name AND usage.extent_code = extent.code JOIN scope ON usage.scope_auth_name = scope.auth_name AND usage.scope_code = scope.code WHERE object_table_name = 'geodetic_datum' AND object_auth_name = 'EPSG' AND object_code = '1204' AND NOT (usage.extent_auth_name = 'PROJ' AND usage.extent_code = 'EXTENT_UNKNOWN') AND NOT (usage.scope_auth_name = 'PROJ' AND usage.scope_code = 'SCOPE_UNKNOWN') ORDER BY score, usage.auth_name, usage.code;
SELECT 'geodetic_datum' FROM geodetic_datum WHERE auth_name = 'EPSG' AND code = '1206' UNION ALL SELECT 'vertical_datum' FROM vertical_datum WHERE auth_name = 'EPSG' AND code = '1206';
SELECT name, ellipsoid_auth_name, ellipsoid_code, prime_meridian_auth_name, prime_meridian_code, publication_date, frame_reference_epoch, ensemble_accuracy, anchor, deprecated FROM geodetic_datum WHERE auth_name = 'EPSG' AND code = '1206';
SELECT extent.description, extent.south_lat, extent.north_lat, extent.west_lon, extent.east_lon, scope.scope, (CASE WHEN scope.scope LIKE '%large scale%' THEN 0 ELSE 1 END) AS score FROM usage JOIN extent ON usage.extent_auth_name = extent.auth_name AND usage.extent_code = extent.code JOIN scope ON usage.scope_auth_name = scope.auth_name AND usage.scope_code = scope.code WHERE object_table_name = 'geodetic_datum' AND object_auth_name = 'EPSG' AND object_code = '1206' AND NOT (usage.extent_auth_name = 'PROJ' AND usage.extent_code = 'EXTENT_UNKNOWN') AND NOT (usage.scope_auth_name = 'PROJ' AND usage.scope_code = 'SCOPE_UNKNOWN') ORDER BY score, usage.auth_name, usage.code;
SELECT allowed_authorities FROM authority_to_authority_preference WHERE source_auth_name = 'EPSG' AND target_auth_name = 'EPSG';
SELECT cov.source_crs_auth_name, cov.source_crs_code, cov.target_crs_auth_name, cov.target_crs_code, cov.auth_name, cov.code, cov.table_name, extent.south_lat, extent.west_lon, extent.north_lat, extent.east_lon, ss.replacement_auth_name, ss.replacement_code, (gt.auth_name IS NOT NULL) AS replacement_is_grid_transform, (ga.proj_grid_name IS NOT NULL) AS replacement_is_known_grid FROM coordinate_operation_view cov JOIN usage ON usage.object_table_name = cov.table_name AND usage.object_auth_name = cov.auth_name AND usage.object_code = cov.code JOIN extent ON extent.auth_name = usage.extent_auth_name AND extent.code = usage.extent_code LEFT JOIN supersession ss ON ss.superseded_table_name = cov.table_name AND ss.superseded_auth_name = cov.auth_name AND ss.superseded_code = cov.code AND ss.superseded_table_name = ss.replacement_table_name AND ss.same_source_target_crs = 1 LEFT JOIN grid_transformation gt ON gt.auth_name = ss.replacement_auth_name AND gt.code = ss.replacement_code LEFT JOIN grid_alternatives ga ON ga.original_grid_name = gt.grid_name WHERE ((cov.source_crs_auth_name = 'EPSG' AND cov.source_crs_code = '4326' AND cov.target_crs_auth_name = 'EPSG' AND cov.target_crs_code = '4258') OR (cov.source_crs_auth_name = 'EPSG' AND cov.source_crs_code = '4258' AND cov.target_crs_auth_name = 'EPSG' AND cov.target_crs_code = '4326')) AND cov.deprecated = 0 AND cov.auth_name = 'PROJ' ORDER BY (CASE WHEN cov.accuracy is NULL THEN 1 ELSE 0 END), cov.accuracy;
SELECT cov.source_crs_auth_name, cov.source_crs_code, cov.target_crs_auth_name, cov.target_crs_code, cov.auth_name, cov.code, cov.table_name, extent.south_lat, extent.west_lon, extent.north_lat, extent.east_lon, ss.replacement_auth_name, ss.replacement_code, (gt.auth_name IS NOT NULL) AS replacement_is_grid_transform, (ga.proj_grid_name IS NOT NULL) AS replacement_is_known_grid FROM coordinate_operation_view cov JOIN usage ON usage.object_table_name = cov.table_name AND usage.object_auth_name = cov.auth_name AND usage.object_code = cov.code JOIN extent ON extent.auth_name = usage.extent_auth_name AND extent.code = usage.extent_code LEFT JOIN supersession ss ON ss.superseded_table_name = cov.table_name AND ss.superseded_auth_name = cov.auth_name AND ss.superseded_code = cov.code AND ss.superseded_table_name = ss.replacement_table_name AND ss.same_source_target_crs = 1 LEFT JOIN grid_transformation gt ON gt.auth_name = ss.replacement_auth_name AND gt.code = ss.replacement_code LEFT JOIN grid_alternatives ga ON ga.original_grid_name = gt.grid_name WHERE ((cov.source_crs_auth_name = 'EPSG' AND cov.source_crs_code = '4326' AND cov.target_crs_auth_name = 'EPSG' AND cov.target_crs_code = '4258') OR (cov.source_crs_auth_name = 'EPSG' AND cov.source_crs_code = '4258' AND cov.target_crs_auth_name = 'EPSG' AND cov.target_crs_code = '4326')) AND cov.deprecated = 0 AND cov.auth_name = 'EPSG' ORDER BY (CASE WHEN cov.accuracy is NULL THEN 1 ELSE 0 END), cov.accuracy;
SELECT name, description, method_auth_name, method_code, method_name, source_crs_auth_name, source_crs_code, target_crs_auth_name, target_crs_code, accuracy, tx, ty, tz, translation_uom_auth_name, translation_uom_code, rx, ry, rz, rotation_uom_auth_name, rotation_uom_code, scale_difference, scale_difference_uom_auth_name, scale_difference_uom_code, rate_tx, rate_ty, rate_tz, rate_translation_uom_auth_name, rate_translation_uom_code, rate_rx, rate_ry, rate_rz, rate_rotation_uom_auth_name, rate_rotation_uom_code, rate_scale_difference, rate_scale_difference_uom_auth_name, rate_scale_difference_uom_code, epoch, epoch_uom_auth_name, epoch_uom_code, px, py, pz, pivot_uom_auth_name, pivot_uom_code, operation_version, deprecated FROM helmert_transformation WHERE auth_name = 'EPSG' AND code = '1149';
SELECT extent.description, extent.south_lat, extent.north_lat, extent.west_lon, extent.east_lon, scope.scope, (CASE WHEN scope.scope LIKE '%large scale%' THEN 0 ELSE 1 END) AS score FROM usage JOIN extent ON usage.extent_auth_name = extent.auth_name AND usage.extent_code = extent.code JOIN scope ON usage.scope_auth_name = scope.auth_name AND usage.scope_code = scope.code WHERE object_table_name = 'helmert_transformation' AND object_auth_name = 'EPSG' AND object_code = '1149' AND NOT (usage.extent_auth_name = 'PROJ' AND usage.extent_code = 'EXTENT_UNKNOWN') AND NOT (usage.scope_auth_name = 'PROJ' AND usage.scope_code = 'SCOPE_UNKNOWN') ORDER BY score, usage.auth_name, usage.code;
SELECT name, ellipsoid_auth_name, ellipsoid_code, prime_meridian_auth_name, prime_meridian_code, publication_date, frame_reference_epoch, ensemble_accuracy, anchor, deprecated FROM geodetic_datum WHERE auth_name = 'EPSG' AND code = '6326';
SELECT extent.description, extent.south_lat, extent.north_lat, extent.west_lon, extent.east_lon, scope.scope, (CASE WHEN scope.scope LIKE '%large scale%' THEN 0 ELSE 1 END) AS score FROM usage JOIN extent ON usage.extent_auth_name = extent.auth_name AND usage.extent_code = extent.code JOIN scope ON usage.scope_auth_name = scope.auth_name AND usage.scope_code = scope.code WHERE object_table_name = 'geodetic_datum' AND object_auth_name = 'EPSG' AND object_code = '6326' AND NOT (usage.extent_auth_name = 'PROJ' AND usage.extent_code = 'EXTENT_UNKNOWN') AND NOT (usage.scope_auth_name = 'PROJ' AND usage.scope_code = 'SCOPE_UNKNOWN') ORDER BY score, usage.auth_name, usage.code;
SELECT name, ellipsoid_auth_name, ellipsoid_code, prime_meridian_auth_name, prime_meridian_code, publication_date, frame_reference_epoch, ensemble_accuracy, anchor, deprecated FROM geodetic_datum WHERE auth_name = 'EPSG' AND code = '6258';
SELECT extent.description, extent.south_lat, extent.north_lat, extent.west_lon, extent.east_lon, scope.scope, (CASE WHEN scope.scope LIKE '%large scale%' THEN 0 ELSE 1 END) AS score FROM usage JOIN extent ON usage.extent_auth_name = extent.auth_name AND usage.extent_code = extent.code JOIN scope ON usage.scope_auth_name = scope.auth_name AND usage.scope_code = scope.code WHERE object_table_name = 'geodetic_datum' AND object_auth_name = 'EPSG' AND object_code = '6258' AND NOT (usage.extent_auth_name = 'PROJ' AND usage.extent_code = 'EXTENT_UNKNOWN') AND NOT (usage.scope_auth_name = 'PROJ' AND usage.scope_code = 'SCOPE_UNKNOWN') ORDER BY score, usage.auth_name, usage.code;
SELECT name FROM "geodetic_datum" WHERE auth_name = 'EPSG' AND code = '6326';
SELECT alt_name FROM alias_name WHERE table_name = 'geodetic_datum' AND auth_name = 'EPSG' AND code = '6326';
