pratham76 commented on code in PR #55207: URL: https://github.com/apache/spark/pull/55207#discussion_r3050477105
########## docs/sql-ref-geospatial-types.md: ########## @@ -142,6 +142,92 @@ SELECT ST_Srid(ST_SetSrid(ST_GeomFromWKB(X'0101000000000000000000F03F00000000000 * **Fixed-SRID columns**: Every value in the column must have the same SRID as the column type. Inserting a value with a different SRID can raise an error (or you can use `ST_SetSrid` to set the value’s SRID to match the column). * **Mixed-SRID columns** (`GEOMETRY(ANY)` or `GEOGRAPHY(ANY)`): Values can have different SRIDs. Only valid SRIDs are allowed. * **Storage**: Parquet, Delta, and Iceberg store geometry/geography with a fixed SRID per column; mixed-SRID types are for in-memory/query use. When writing to these formats, a concrete (fixed) SRID is required. +### Supported SRIDs + +Spark includes a pre-built registry of standard Spatial Reference Identifiers (SRIDs) from the PROJ database, with overrides to support OGC standards. This registry enables validation and proper handling of coordinate systems for geospatial data. + +#### Commonly Used SRIDs + +| SRID | Name | Description | Typical Use Case | +|------|------|-------------|------------------| +| 4326 | WGS 84 | World Geodetic System 1984 (latitude/longitude) | GPS coordinates, global data (default for GEOGRAPHY) | +| 3857 | Web Mercator | Pseudo-Mercator projection used by web mapping services | Web maps (Google Maps, OpenStreetMap, Bing Maps) | +| 2154 | RGF93 / Lambert-93 | French national coordinate system | France-specific mapping and GIS | +| 32633 | WGS 84 / UTM zone 33N | Universal Transverse Mercator, zone 33 North | Central Europe (6°E to 12°E) | +| 32634 | WGS 84 / UTM zone 34N | Universal Transverse Mercator, zone 34 North | Eastern Europe (12°E to 18°E) | +| 32635 | WGS 84 / UTM zone 35N | Universal Transverse Mercator, zone 35 North | Eastern Europe/Western Asia (18°E to 24°E) | Review Comment: Noted! Have added `CRS identifier` column to the table, which contains the corresponding mappings as stated above. I have also introduced a column `type` which indicated if the SRIDs are valid for GEOGRAPHY or GEOMETRY, or both. Along with these i have added some notes based on the above comments. Do inform if this helps. Thanks! ########## docs/sql-ref-geospatial-types.md: ########## @@ -142,6 +142,92 @@ SELECT ST_Srid(ST_SetSrid(ST_GeomFromWKB(X'0101000000000000000000F03F00000000000 * **Fixed-SRID columns**: Every value in the column must have the same SRID as the column type. Inserting a value with a different SRID can raise an error (or you can use `ST_SetSrid` to set the value’s SRID to match the column). * **Mixed-SRID columns** (`GEOMETRY(ANY)` or `GEOGRAPHY(ANY)`): Values can have different SRIDs. Only valid SRIDs are allowed. * **Storage**: Parquet, Delta, and Iceberg store geometry/geography with a fixed SRID per column; mixed-SRID types are for in-memory/query use. When writing to these formats, a concrete (fixed) SRID is required. +### Supported SRIDs + +Spark includes a pre-built registry of standard Spatial Reference Identifiers (SRIDs) from the PROJ database, with overrides to support OGC standards. This registry enables validation and proper handling of coordinate systems for geospatial data. + +#### Commonly Used SRIDs + +| SRID | Name | Description | Typical Use Case | +|------|------|-------------|------------------| +| 4326 | WGS 84 | World Geodetic System 1984 (latitude/longitude) | GPS coordinates, global data (default for GEOGRAPHY) | +| 3857 | Web Mercator | Pseudo-Mercator projection used by web mapping services | Web maps (Google Maps, OpenStreetMap, Bing Maps) | +| 2154 | RGF93 / Lambert-93 | French national coordinate system | France-specific mapping and GIS | +| 32633 | WGS 84 / UTM zone 33N | Universal Transverse Mercator, zone 33 North | Central Europe (6°E to 12°E) | +| 32634 | WGS 84 / UTM zone 34N | Universal Transverse Mercator, zone 34 North | Eastern Europe (12°E to 18°E) | +| 32635 | WGS 84 / UTM zone 35N | Universal Transverse Mercator, zone 35 North | Eastern Europe/Western Asia (18°E to 24°E) | + +The registry includes many additional SRIDs for various UTM zones, national coordinate systems, and other projections. For a complete list, refer to the [EPSG Geodetic Parameter Dataset](https://epsg.org/). Review Comment: Thanks for pointing this out, have updated the note. ########## docs/sql-ref-geospatial-types.md: ########## @@ -142,6 +142,92 @@ SELECT ST_Srid(ST_SetSrid(ST_GeomFromWKB(X'0101000000000000000000F03F00000000000 * **Fixed-SRID columns**: Every value in the column must have the same SRID as the column type. Inserting a value with a different SRID can raise an error (or you can use `ST_SetSrid` to set the value’s SRID to match the column). * **Mixed-SRID columns** (`GEOMETRY(ANY)` or `GEOGRAPHY(ANY)`): Values can have different SRIDs. Only valid SRIDs are allowed. * **Storage**: Parquet, Delta, and Iceberg store geometry/geography with a fixed SRID per column; mixed-SRID types are for in-memory/query use. When writing to these formats, a concrete (fixed) SRID is required. +### Supported SRIDs + +Spark includes a pre-built registry of standard Spatial Reference Identifiers (SRIDs) from the PROJ database, with overrides to support OGC standards. This registry enables validation and proper handling of coordinate systems for geospatial data. + +#### Commonly Used SRIDs + +| SRID | Name | Description | Typical Use Case | +|------|------|-------------|------------------| +| 4326 | WGS 84 | World Geodetic System 1984 (latitude/longitude) | GPS coordinates, global data (default for GEOGRAPHY) | +| 3857 | Web Mercator | Pseudo-Mercator projection used by web mapping services | Web maps (Google Maps, OpenStreetMap, Bing Maps) | +| 2154 | RGF93 / Lambert-93 | French national coordinate system | France-specific mapping and GIS | +| 32633 | WGS 84 / UTM zone 33N | Universal Transverse Mercator, zone 33 North | Central Europe (6°E to 12°E) | +| 32634 | WGS 84 / UTM zone 34N | Universal Transverse Mercator, zone 34 North | Eastern Europe (12°E to 18°E) | +| 32635 | WGS 84 / UTM zone 35N | Universal Transverse Mercator, zone 35 North | Eastern Europe/Western Asia (18°E to 24°E) | + +The registry includes many additional SRIDs for various UTM zones, national coordinate systems, and other projections. For a complete list, refer to the [EPSG Geodetic Parameter Dataset](https://epsg.org/). + +#### Using Different SRIDs + +**Creating tables with specific SRIDs:** Review Comment: Thank you for the comments! have updated the examples. -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. To unsubscribe, e-mail: [email protected] For queries about this service, please contact Infrastructure at: [email protected] --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
