Re: [postgis-users] query a certain row from a table. (Willem Hoffmans)

Presumably if that is the case, you should be able to check that by having more, or less information in the metadata? More data fields would presumably decrease the error record. On 23/03/20 22:12, Willem wrote: I'm pretty sure it's the limitations of the Shapefile (or, more precisely, the

Re: [postgis-users] query a certain row from a table.

Very punny > On Mar 23, 2020, at 9:54 AM, Martin Davis wrote: > > Ah yes, good point! > > On Mon, Mar 23, 2020 at 8:30 AM Paul Ramsey wrote: > Challenge accepted > > pramsey=# select st_isvalid(st_makepoint('NaN'::float8,1)); > NOTICE: Invalid Coordinate at or near point nan 1 >

Re: [postgis-users] query a certain row from a table.

Ah yes, good point! On Mon, Mar 23, 2020 at 8:30 AM Paul Ramsey wrote: > Challenge accepted > > pramsey=# select st_isvalid(st_makepoint('NaN'::float8,1)); > NOTICE: Invalid Coordinate at or near point nan 1 > st_isvalid > > f > (1 row) > > > > > > On Mar 21, 2020, at 10:51

Re: [postgis-users] query a certain row from a table.

Challenge accepted pramsey=# select st_isvalid(st_makepoint('NaN'::float8,1)); NOTICE: Invalid Coordinate at or near point nan 1 st_isvalid f (1 row) > On Mar 21, 2020, at 10:51 PM, Martin Davis wrote: > > Not surprising - I'm not sure it's possible to make an invalid

Re: [postgis-users] query a certain row from a table. (Willem Hoffmans)

Thanks, Willem. I'll try that instead. best regards, John On 3/23/2020 2:12 AM, Willem wrote: I'm pretty sure it's the limitations of the Shapefile (or, more precisely, the underlying .dbf format) that gives the error. Those .dbf files can only contain 2GB of data, see also:

Re: [postgis-users] query a certain row from a table. (Willem Hoffmans)

I'm pretty sure it's the limitations of the Shapefile (or, more precisely, the underlying .dbf format) that gives the error. Those .dbf files can only contain 2GB of data, see also: https://en.wikipedia.org/wiki/Shapefile So ask yourself the question: why export to shapefile? Try Geopackage,

Re: [postgis-users] query a certain row from a table.

Not surprising - I'm not sure it's possible to make an invalid point. On Sat, Mar 21, 2020 at 10:07 PM john polo wrote: > I used > > SELECT "SAMPLING_EVENT_IDENTIFIER" FROM p_loc.ebird_sel_spt > WHERE ST_IsValid(geom) is false > ; > > No rows are returned. > > > On 3/21/2020 4:13 PM, Alexander

Re: [postgis-users] query a certain row from a table.

I used SELECT "SAMPLING_EVENT_IDENTIFIER" FROM p_loc.ebird_sel_spt WHERE ST_IsValid(geom) is false ; No rows are returned. On 3/21/2020 4:13 PM, Alexander Gataric wrote: Write a query using predicate ST_IsValid(geom_column) is false Get BlueMail for Android

Re: [postgis-users] query a certain row from a table.

That could definitely be possible. I have a shapefile with similar columns and just about as many rows as the one I am trying to export and it's just under 10 GB. I can load it into QGIS, but it obviously slows things down. I hadn't considered any kind of limitation like that. Is the limit

Re: [postgis-users] query a certain row from a table.

Is it possible you are simply exceeding the allowable size for a shapefile? The SHP file is limited to a size of 2 GB. On Fri, Mar 20, 2020 at 9:35 PM john polo wrote: > Hi, > > I'm trying to export a table of points to a shapefile. The table has > over 8,000,000 rows. I'm using PostGIS 3.0

Re: [postgis-users] query a certain row from a table.

Write a query using predicate ST_IsValid(geom_column) is false ⁣Get BlueMail for Android ​ On Mar 21, 2020, 10:06 AM, at 10:06 AM, John Polo wrote: >They are stored as Point. One per row. > > > >On Saturday, March 21, 2020, Alexander Gataric wrote: > >> What format are the points stored in?

Re: [postgis-users] query a certain row from a table.

They are stored as Point. One per row. On Saturday, March 21, 2020, Alexander Gataric wrote: > What format are the points stored in? Point, multipoint? How many points > per row? > > Get BlueMail for Android > On Mar 20, 2020, at 11:36 PM, john polo wrote:

Re: [postgis-users] query a certain row from a table.

What format are the points stored in? Point, multipoint? How many points per row? ⁣Get BlueMail for Android ​ On Mar 20, 2020, 11:36 PM, at 11:36 PM, john polo wrote: >Hi, > >I'm trying to export a table of points to a shapefile. The table has >over 8,000,000 rows. I'm using PostGIS 3.0 and

[postgis-users] query a certain row from a table.

Hi, I'm trying to export a table of points to a shapefile. The table has over 8,000,000 rows. I'm using PostGIS 3.0 and PostGIS Shapefile Import/Export Manager on Windows 10. When I try to run the export, I keep getting this error: Error: record 3329432 could not be created I'm not sure