Maurizio,
Thank you very much for pointing to me right direction.
On Mon, Jul 15, 2019 at 11:03 AM Maurizio Napolitano
wrote:
> You can find all the answers to your questions here
> https://www.stevegattuso.me/2019/05/29/postgis-reverse-geocoder.html
> Enjoy
>
> Il lun 15 lug 20
Hi,
Our environment has Postgres database with PostGIS extension.
User/application run postGIS query. Works fine.
Normally we get millions of point ( lat/lon) and our requirement to assign
addresses to most of the point.
Currently we use Google API/ 3rd party service and call reverse geocode ap
take a couple of
> minutes - but it worked...
>
> Brent Wood
>
> ------
> *From:* suraj birla
> *To:* PostGIS Users Discussion
> *Sent:* Saturday, January 5, 2019 2:01 PM
> *Subject:* [postgis-users] Timeseries display of points
>
> Need suggest
Need suggestions.
I've postgis database which has a table with timestamp, lat/lon
we have 600K sensors around the world and it send sends data for every 30
seconds if the sensor is active.. Data get stored in the database table
I need to show this on a map and show when the sensor were active in
>
> Cheers,
> Mike
>
> On 18 September 2017 at 12:16, suraj birla wrote:
> > Hi,
> >
> > Is it possible to find posted speed for a given lat/lon in POSTGIS by
> > loading road shapfile?
> >
> > Currently we are using google API to get the posted sp
Hi,
Is it possible to find posted speed for a given lat/lon in POSTGIS by
loading road shapfile?
Currently we are using google API to get the posted speed.
Thanks
Suraj
___
postgis-users mailing list
postgis-users@lists.osgeo.org
https://lists.osgeo.or
Hi,
We have a requirement to find all events occurring on a particular road. we
do have event with lat/lon. What would be the best way to get the match
road to events.
Can you please help,
Thanks
Suraj
___
postgis-users mailing list
postgis-users@lists
70-90 second to get TZ from tz_world table is good for
100K records on a 32 segment cluster?
2. Another requirement we have is to show 3 digit timezone code( for eg,
PST/PDT, EST/EDT , GMT , etc) for the derived tz_id (America/Los_Angeles)?
On Mon, Mar 27, 2017 at 9:47 PM, suraj birla wrote:
>
Hi ,
I've a requirement to get the address ( country, state/provinces, postal
code) for a given lat/lon. I need to this for 100 million+ records.
I'm planning to do this in 3 phases
First find the country using world polygon
Second find the state/provinces for the identified country
Postal code ??
rom
>
> *http://efele.net/maps/tz/world/ <http://efele.net/maps/tz/world/>*
>
>
> --
> John Abraham
> j...@hbaspecto.com
>
> On Mar 22, 2017, at 3:23 PM, suraj birla wrote:
>
> How to find the timezone for a given lat/long using postgis?
>
> We have to
How to find the timezone for a given lat/long using postgis?
We have to requirement to fnd the local timezone for millions of records
which has UTC timestamp and lat/long info.
Google provide API but it's single request per call.. Not feasible for
milion records.
Any suggestion?
Thanks
Suraj
kouski
*Sent:* Tuesday, November 15, 2016 1:43 PM
*To:* postgis-users@lists.osgeo.org
*Subject:* Re: [postgis-users] PostGIS on Greenplum - Performance issue
Hey,
did you create a gist index on geometry? can you show the query plans?
your e-mail also contains confidentiality notice and goes to a public list
Hi,
We have greenplum database with PostGIS extension.
Greenplum version :
PostgreSQL 8.2.15 (Greenplum Database 4.3.9.0 build 1) on
x86_64-unknown-linux-gnu, compiled by GCC gcc (GCC) 4.4.2 compiled on Aug 8
2016 05:36:26
PostGIS version
POSTGIS="2.0.3 r11128" GEOS="3.3.8-CAPI-1.7.8" PROJ="R
Hi,
We have greenplum database with PostGIS extension.
Greenplum version :
PostgreSQL 8.2.15 (Greenplum Database 4.3.9.0 build 1) on
x86_64-unknown-linux-gnu, compiled by GCC gcc (GCC) 4.4.2 compiled on Aug 8
2016 05:36:26
PostGIS version
POSTGIS="2.0.3 r11128" GEOS="3.3.8-CAPI-1.7.8" PROJ="Re
14 matches
Mail list logo
