27 #include "../postgis_config.h"
35 #include "access/gist.h"
36 #include "access/itup.h"
39 #include "utils/elog.h"
40 #include "mb/pg_wchar.h"
41 #include "lib/stringinfo.h"
42 #include "utils/array.h"
43 #include "utils/builtins.h"
44 #include "utils/lsyscache.h"
48 #include "lwgeom_cache.h"
49 #include "lwgeom_pg.h"
51 #include "lwgeom_transform.h"
54 #include "access/htup_details.h"
87 char *input = PG_GETARG_CSTRING(0);
88 int32 geom_typmod = -1;
95 if ( (PG_NARGS()>2) && (!PG_ARGISNULL(2)) ) {
96 geom_typmod = PG_GETARG_INT32(2);
102 if (
str[0] ==
'\0' ) {
103 ereport(ERROR,(errmsg(
"parse error - invalid geometry")));
108 if( strncasecmp(
str,
"SRID=",5) == 0 )
112 while ( tmp && *tmp !=
';' )
116 if ( tmp && *(tmp+1) ==
'0' )
132 size_t hexsize = strlen(
str);
141 ret = geometry_serialize(lwgeom);
144 else if (
str[0] ==
'{')
150 srid = GetSRIDCacheBySRS(fcinfo, srs);
154 ret = geometry_serialize(lwgeom);
162 PG_PARSER_ERROR(lwg_parser_result);
165 lwgeom = lwg_parser_result.
geom;
168 ret = geometry_serialize(lwgeom);
172 if ( geom_typmod >= 0 )
175 POSTGIS_DEBUG(3,
"typmod and geometry were consistent");
179 POSTGIS_DEBUG(3,
"typmod was -1");
185 PG_RETURN_POINTER(ret);
215 GSERIALIZED *pg_lwgeom = PG_GETARG_GSERIALIZED_P(0);
216 text *format_text = PG_GETARG_TEXT_P(1);
219 char *format_str = NULL;
221 char * formatted_str;
222 text * formatted_text;
229 lwpgerror(
"Only points are supported, you tried type %s.",
lwtype_name(geom_type));
234 if (format_text == NULL) {
235 lwpgerror(
"ST_AsLatLonText: invalid format string (null");
240 lwpgerror(
"ST_AsLatLonText: invalid coordinate");
244 format_str = text_to_cstring(format_text);
245 assert(format_str != NULL);
249 tmp = (
char *)pg_do_encoding_conversion(
250 (uint8_t *)format_str, strlen(format_str), GetDatabaseEncoding(), PG_UTF8);
252 if ( tmp != format_str ) {
259 assert(formatted_str != NULL);
263 tmp = (
char *)pg_do_encoding_conversion(
264 (uint8_t *)formatted_str, strlen(formatted_str),
265 PG_UTF8, GetDatabaseEncoding());
267 if ( tmp != formatted_str) {
268 pfree(formatted_str);
273 formatted_text = cstring_to_text(formatted_str);
274 pfree(formatted_str);
276 PG_RETURN_POINTER(formatted_text);
305 if ( (PG_NARGS()>1) && (!PG_ARGISNULL(1)) )
307 text *
type = PG_GETARG_TEXT_P(1);
309 if ( ! strncmp(VARDATA(
type),
"xdr", 3) ||
310 ! strncmp(VARDATA(
type),
"XDR", 3) )
351 bytea *bytea_wkb = PG_GETARG_BYTEA_P(0);
354 uint8_t *wkb = (uint8_t*)VARDATA(bytea_wkb);
358 lwpgerror(
"Unable to parse WKB");
360 if ((PG_NARGS() > 1) && (!PG_ARGISNULL(1)))
362 int32 srid = PG_GETARG_INT32(1);
369 geom = geometry_serialize(lwgeom);
371 PG_FREE_IF_COPY(bytea_wkb, 0);
372 PG_RETURN_POINTER(geom);
382 bytea *bytea_twkb = PG_GETARG_BYTEA_P(0);
385 uint8_t *twkb = (uint8_t*)VARDATA(bytea_twkb);
392 geom = geometry_serialize(lwgeom);
394 PG_FREE_IF_COPY(bytea_twkb, 0);
395 PG_RETURN_POINTER(geom);
410 if ( (PG_NARGS()>1) && (!PG_ARGISNULL(1)) )
412 text *
type = PG_GETARG_TEXT_P(1);
414 if ( ! strncmp(VARDATA(
type),
"xdr", 3) ||
415 ! strncmp(VARDATA(
type),
"XDR", 3) )
440 if ( PG_ARGISNULL(0) ) PG_RETURN_NULL();
442 geom = PG_GETARG_GSERIALIZED_P(0);
448 if ( PG_NARGS() > 1 && ! PG_ARGISNULL(1) )
449 sp.precision_xy = PG_GETARG_INT32(1);
452 if ( PG_NARGS() > 2 && ! PG_ARGISNULL(2) )
453 sp.precision_z = PG_GETARG_INT32(2);
456 if ( PG_NARGS() > 3 && ! PG_ARGISNULL(3) )
457 sp.precision_m = PG_GETARG_INT32(3);
463 if ( PG_NARGS() > 4 && ! PG_ARGISNULL(4) && PG_GETARG_BOOL(4) )
467 if ( PG_NARGS() > 5 && ! PG_ARGISNULL(5) && PG_GETARG_BOOL(5) )
479 ArrayType *arr_geoms = NULL;
480 ArrayType *arr_ids = NULL;
481 int num_geoms, num_ids, i = 0;
483 ArrayIterator iter_geoms, iter_ids;
484 bool null_geom, null_id;
485 Datum val_geom, val_id;
487 int is_homogeneous =
true;
488 uint32_t subtype = 0;
492 int64_t *idlist = NULL;
498 if ( PG_NARGS() < 2 || PG_ARGISNULL(0) || PG_ARGISNULL(1) )
501 arr_geoms = PG_GETARG_ARRAYTYPE_P(0);
502 arr_ids = PG_GETARG_ARRAYTYPE_P(1);
504 num_geoms = ArrayGetNItems(ARR_NDIM(arr_geoms), ARR_DIMS(arr_geoms));
505 num_ids = ArrayGetNItems(ARR_NDIM(arr_ids), ARR_DIMS(arr_ids));
507 if ( num_geoms != num_ids )
509 elog(ERROR,
"size of geometry[] and integer[] arrays must match");
516 iter_geoms = array_create_iterator(arr_geoms, 0, NULL);
517 iter_ids = array_create_iterator(arr_ids, 0, NULL);
519 while( array_iterate(iter_geoms, &val_geom, &null_geom) &&
520 array_iterate(iter_ids, &val_id, &null_id) )
525 if ( null_geom || null_id )
527 elog(NOTICE,
"ST_AsTWKB skipping NULL entry at position %d", i);
532 uid = DatumGetInt64(val_id);
542 idlist = palloc0(num_geoms *
sizeof(int64_t));
548 elog(ERROR,
"Geometries have different dimensionality");
549 PG_FREE_IF_COPY(arr_geoms, 0);
550 PG_FREE_IF_COPY(arr_ids, 1);
561 is_homogeneous =
false;
569 array_free_iterator(iter_geoms);
570 array_free_iterator(iter_ids);
574 elog(NOTICE,
"No valid geometry - id pairs found");
575 PG_FREE_IF_COPY(arr_geoms, 0);
576 PG_FREE_IF_COPY(arr_ids, 1);
579 if ( is_homogeneous )
588 if ( PG_NARGS() > 2 && ! PG_ARGISNULL(2) )
589 sp.precision_xy = PG_GETARG_INT32(2);
592 if ( PG_NARGS() > 3 && ! PG_ARGISNULL(3) )
593 sp.precision_z = PG_GETARG_INT32(3);
596 if ( PG_NARGS() > 4 && ! PG_ARGISNULL(4) )
597 sp.precision_m = PG_GETARG_INT32(4);
603 if ( PG_NARGS() > 5 && ! PG_ARGISNULL(5) && PG_GETARG_BOOL(5) )
607 if ( PG_NARGS() > 6 && ! PG_ARGISNULL(6) && PG_GETARG_BOOL(6) )
626 result = geometry_serialize(lwgeom);
628 PG_FREE_IF_COPY(geom, 0);
629 PG_RETURN_POINTER(
result);
640 PG_RETURN_POINTER(geom);
649 elog(ERROR,
"%s",
string);
661 text *wkt_text = PG_GETARG_TEXT_P(0);
666 wkt = text_to_cstring(wkt_text);
671 result = CallerFInfoFunctionCall1(
LWGEOM_in, fcinfo->flinfo, InvalidOid, CStringGetDatum(wkt));
691 StringInfo buf = (StringInfo) PG_GETARG_POINTER(0);
692 int32 geom_typmod = -1;
696 if ( (PG_NARGS()>2) && (!PG_ARGISNULL(2)) ) {
697 geom_typmod = PG_GETARG_INT32(2);
706 buf->cursor = buf->len;
708 geom = geometry_serialize(lwgeom);
711 if ( geom_typmod >= 0 )
714 POSTGIS_DEBUG(3,
"typmod and geometry were consistent");
718 POSTGIS_DEBUG(3,
"typmod was -1");
722 PG_RETURN_POINTER(geom);
730 POSTGIS_DEBUG(2,
"LWGEOM_send called");
743 POSTGIS_DEBUG(2,
"LWGEOM_to_bytea called");
758 POSTGIS_DEBUG(2,
"LWGEOM_from_bytea start");
763 PG_RETURN_POINTER(
result);
char result[OUT_DOUBLE_BUFFER_SIZE]
GSERIALIZED * postgis_valid_typmod(GSERIALIZED *gser, int32_t typmod)
Check the consistency of the metadata we want to enforce in the typmod: srid, type and dimensionality...
int gserialized_has_bbox(const GSERIALIZED *g)
Check if a GSERIALIZED has a bounding box without deserializing first.
int32_t gserialized_get_srid(const GSERIALIZED *g)
Extract the SRID from the serialized form (it is packed into three bytes so this is a handy function)...
LWGEOM * lwgeom_from_gserialized(const GSERIALIZED *g)
Allocate a new LWGEOM from a GSERIALIZED.
uint32_t gserialized_get_type(const GSERIALIZED *g)
Extract the geometry type from the serialized form (it hides in the anonymous data area,...
GSERIALIZED * gserialized_drop_gbox(GSERIALIZED *g)
Remove the bounding box from a GSERIALIZED.
#define LW_PARSER_CHECK_ALL
LWGEOM * lwcollection_as_lwgeom(const LWCOLLECTION *obj)
uint32_t lwtype_get_collectiontype(uint8_t type)
Given an lwtype number, what homogeneous collection can hold it?
int32_t lwgeom_get_srid(const LWGEOM *geom)
Return SRID number.
LWGEOM * lwgeom_from_geojson(const char *geojson, char **srs)
Create an LWGEOM object from a GeoJSON representation.
void lwgeom_set_srid(LWGEOM *geom, int32_t srid)
Set the SRID on an LWGEOM For collections, only the parent gets an SRID, all the children get SRID_UN...
void lwgeom_free(LWGEOM *geom)
#define LW_PARSER_CHECK_NONE
LWGEOM * lwgeom_from_twkb(const uint8_t *twkb, size_t twkb_size, char check)
WKB inputs must have a declared size, to prevent malformed WKB from reading off the end of the memory...
void lwgeom_parser_result_init(LWGEOM_PARSER_RESULT *parser_result)
int lwgeom_parse_wkt(LWGEOM_PARSER_RESULT *parser_result, char *wktstr, int parse_flags)
Parse a WKT geometry string into an LWGEOM structure.
char * lwgeom_to_hexwkb_buffer(const LWGEOM *geom, uint8_t variant)
lwvarlena_t * lwgeom_to_twkb(const LWGEOM *geom, uint8_t variant, int8_t precision_xy, int8_t precision_z, int8_t precision_m)
uint8_t * bytes_from_hexbytes(const char *hexbuf, size_t hexsize)
int lwgeom_needs_bbox(const LWGEOM *geom)
Check whether or not a lwgeom is big enough to warrant a bounding box.
int lwgeom_has_z(const LWGEOM *geom)
Return LW_TRUE if geometry has Z ordinates.
#define POINTTYPE
LWTYPE numbers, used internally by PostGIS.
int lwgeom_isfinite(const LWGEOM *lwgeom)
Check if a LWGEOM has any non-finite (NaN or Inf) coordinates.
LWCOLLECTION * lwcollection_construct_empty(uint8_t type, int32_t srid, char hasz, char hasm)
char * lwpoint_to_latlon(const LWPOINT *p, const char *format)
const char * lwtype_name(uint8_t type)
Return the type name string associated with a type number (e.g.
#define TWKB_DEFAULT_PRECISION
lwvarlena_t * lwgeom_to_hexwkb_varlena(const LWGEOM *geom, uint8_t variant)
LWCOLLECTION * lwcollection_add_lwgeom(LWCOLLECTION *col, const LWGEOM *geom)
Appends geom to the collection managed by col.
lwvarlena_t * lwgeom_to_twkb_with_idlist(const LWGEOM *geom, int64_t *idlist, uint8_t variant, int8_t precision_xy, int8_t precision_z, int8_t precision_m)
Convert LWGEOM to a char* in TWKB format.
LWGEOM * lwgeom_from_wkb(const uint8_t *wkb, const size_t wkb_size, const char check)
WKB inputs must have a declared size, to prevent malformed WKB from reading off the end of the memory...
int lwgeom_has_m(const LWGEOM *geom)
Return LW_TRUE if geometry has M ordinates.
lwvarlena_t * lwgeom_to_wkb_varlena(const LWGEOM *geom, uint8_t variant)
void lwgeom_add_bbox(LWGEOM *lwgeom)
Compute a bbox if not already computed.
void lwgeom_parser_result_free(LWGEOM_PARSER_RESULT *parser_result)
This library is the generic geometry handling section of PostGIS.
Datum WKBFromLWGEOM(PG_FUNCTION_ARGS)
Datum parse_WKT_lwgeom(PG_FUNCTION_ARGS)
Datum TWKBFromLWGEOM(PG_FUNCTION_ARGS)
PG_FUNCTION_INFO_V1(LWGEOM_in)
Datum LWGEOM_in(PG_FUNCTION_ARGS)
Datum LWGEOM_to_latlon(PG_FUNCTION_ARGS)
Datum LWGEOM_out(PG_FUNCTION_ARGS)
Datum LWGEOM_to_bytea(PG_FUNCTION_ARGS)
Datum LWGEOMFromTWKB(PG_FUNCTION_ARGS)
Datum LWGEOM_from_bytea(PG_FUNCTION_ARGS)
Datum TWKBFromLWGEOMArray(PG_FUNCTION_ARGS)
Datum LWGEOM_send(PG_FUNCTION_ARGS)
Datum LWGEOM_dropBBOX(PG_FUNCTION_ARGS)
Datum LWGEOM_to_text(PG_FUNCTION_ARGS)
Datum LWGEOMFromEWKB(PG_FUNCTION_ARGS)
Datum LWGEOM_addBBOX(PG_FUNCTION_ARGS)
void elog_ERROR(const char *string)
Datum LWGEOM_asHEXEWKB(PG_FUNCTION_ARGS)
Datum LWGEOM_recv(PG_FUNCTION_ARGS)
static uint32_t lwgeom_get_type(const LWGEOM *geom)
Return LWTYPE number.
Parser result structure: returns the result of attempting to convert (E)WKT/(E)WKB to LWGEOM.