Results of 1 - 2 of about 2 for SetCRS (0.001 sec.)
- Geometry Functions 11228
- This section describes the functions for examining and manipulating GEOMETRY values. The spatial extension provides additional functions for working with GEOMETRY values, which are documented in the Spatial Functions section. Geometry Opera
...the geometries bounding boxes intersect ST_CRS Returns the Coordinate Reference System (CRS) identifier of the geometry ST_SetCRS Sets the Coordinate Reference System (CRS) identifier of the geometry ST_GeomFromWKB function | Description | Creates a ge...tem (CRS) identifier of the geometry | | Example | ST_CRS('POINT(1 2)'::GEOMETRY('OGC:CRS84')) | | Result | OGC:CRS84 | ST_SetCRS function | Description | Sets the Coordinate Reference System (CRS) identifier of the geometry | | Example | typeof(ST_Set... - https://man.mtool.work/duckdb/2.0/sql/functions/geometry.html
- Geometry Data Type 7485
- Name Description GEOMETRY Geospatial entity The GEOMETRY data type is used to store and manipulate geometric objects, such as points, lines, and polygons. The GEOMETRY type was part of the spatial extension but became a built-in data type i
...───┤ │ POINT (545139.3387790163 6868755.38408516) │ └────────────────────────────────────────────┘ You can also use the ST_SetCRS(geom, crs) function to assign a CRS to a geometry that doesn't have one, or to reassign a CRS without transforming coordin...ates (e.g., when the data is already in the correct coordinate system but lacks the correct CRS). SELECT ST_SetCRS('POINT(4.897070 52.377956)'::GEOMETRY, 'OGC:CRS84') AS with_crs; ---- ┌───────────────────────────┐ │ with_crs │ │ geometr...no_crs │ │ geometry │ ├───────────────────────────┤ │ POINT (4.89707 52.377956) │ └───────────────────────────┘ SELECT ST_SetCRS('POINT(4.897070 52.377956)'::GEOMETRY('OGC:CRS84'), '') AS no_crs; ---- ┌───────────────────────────┐ │ no_crs │ │ geometr... - https://man.mtool.work/duckdb/2.0/sql/data_types/geometry.html
PREV
1
NEXT
DuckDB 2.0 Documentation / man.mtool.work