Re: [postgis-users] PostGIS Day cards
Perfect - just what I need for my original suggestion. Now to find the scissors and the kids and the scotch! cheers Ben On 17/11/2011, at 10:07 AM, Paragon Corporation wrote: > Well GIS Day is just about over and Post GIS day is slowly arriving around > the world. > > To celebrate this new day, we have prepared some Post GIS playing cards. > > http://www.postgis.us/post_gis_day_cards.html > > http://www.postgis.us/downloads/post_gis_day_cards_letter.pdf > > http://www.postgis.us/downloads/post_gis_day_cards_a4.pdf > > If per chance you can't figure out how to put to good use any of these > functions, you can always > > 1) Reference the PostGIS manuals: http://www.postgis.org/documentation/ > > and/or > 2) our book > > > http://www.postgis.us/page_buy_book > > Thanks, > Regina and Leo > ___ > postgis-users mailing list > postgis-users@postgis.refractions.net > http://postgis.refractions.net/mailman/listinfo/postgis-users ___ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users
[postgis-users] PostGIS Day cards
Well GIS Day is just about over and Post GIS day is slowly arriving around the world. To celebrate this new day, we have prepared some Post GIS playing cards. http://www.postgis.us/post_gis_day_cards.html http://www.postgis.us/downloads/post_gis_day_cards_letter.pdf http://www.postgis.us/downloads/post_gis_day_cards_a4.pdf If per chance you can't figure out how to put to good use any of these functions, you can always 1) Reference the PostGIS manuals: http://www.postgis.org/documentation/ and/or 2) our book http://www.postgis.us/page_buy_book Thanks, Regina and Leo ___ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users
Re: [postgis-users] PostGIS Day
That would be awesome. I guess the script will have problems reading the t-dimension, but i will try it later today. As for the scientific community, reading NetCDF would be a huge improvement. At least for anyone working with climatology, oceanography etc. Andreas 2011/11/15 Mateusz Łoskot > On 15 November 2011 19:58, Andreas Forø Tollefsen > wrote: > > However, GDAL supports netCDF so maybe there is a way for > raster2pgsql.py to > > read these files? > > http://www.gdal.org/frmt_netcdf.html > > Yes, it should be possible. > I don't say it will work straight away, perhaps raster2pgsql.py needs > to be patched. > In theory, however, whatever GDAL can consume, raster2pgsql.py can > consume it too. > > Best regards, > -- > Mateusz Loskot, http://mateusz.loskot.net > Charter Member of OSGeo, http://osgeo.org > Member of ACCU, http://accu.org > ___ > postgis-users mailing list > postgis-users@postgis.refractions.net > http://postgis.refractions.net/mailman/listinfo/postgis-users > ___ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users
Re: [postgis-users] PostGIS Day
On 15 November 2011 19:58, Andreas Forø Tollefsen wrote: > However, GDAL supports netCDF so maybe there is a way for raster2pgsql.py to > read these files? > http://www.gdal.org/frmt_netcdf.html Yes, it should be possible. I don't say it will work straight away, perhaps raster2pgsql.py needs to be patched. In theory, however, whatever GDAL can consume, raster2pgsql.py can consume it too. Best regards, -- Mateusz Loskot, http://mateusz.loskot.net Charter Member of OSGeo, http://osgeo.org Member of ACCU, http://accu.org ___ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users
Re: [postgis-users] PostGIS Day
However, GDAL supports netCDF so maybe there is a way for raster2pgsql.py
to read these files?
http://www.gdal.org/frmt_netcdf.html
2011/11/15 Andreas Forø Tollefsen
> Hi,
>
> The netCDF is read using scipy.io.netcdf and each coordinate pair and
> "pixel" value is inserted into a table.
> Then the user can add a geometry column and update it according to
> coordinate pair.
> I would love to be able to read netcdf using the raster2pgsql.py, but i am
> not sure if that will be implemented though.
>
> Andreas
>
> 2011/11/15 Mateusz Łoskot
>
>> It looks like a custom structure, not PostGIS really.
>>
>> cur.execute("CREATE TABLE precipud19002008 (gid serial PRIMARY KEY not
>> null, year int, month int, lon decimal, lat decimal, prec decimal);")
>>
>> --
>> Mateusz Łoskot
>> Sent from my mobile (excuse me for not quoting or top-posting possible)
>>
>> ___
>> postgis-users mailing list
>> postgis-users@postgis.refractions.net
>> http://postgis.refractions.net/mailman/listinfo/postgis-users
>>
>>
>
___
postgis-users mailing list
postgis-users@postgis.refractions.net
http://postgis.refractions.net/mailman/listinfo/postgis-users
Re: [postgis-users] PostGIS Day
Hi,
The netCDF is read using scipy.io.netcdf and each coordinate pair and
"pixel" value is inserted into a table.
Then the user can add a geometry column and update it according to
coordinate pair.
I would love to be able to read netcdf using the raster2pgsql.py, but i am
not sure if that will be implemented though.
Andreas
2011/11/15 Mateusz Łoskot
> It looks like a custom structure, not PostGIS really.
>
> cur.execute("CREATE TABLE precipud19002008 (gid serial PRIMARY KEY not
> null, year int, month int, lon decimal, lat decimal, prec decimal);")
>
> --
> Mateusz Łoskot
> Sent from my mobile (excuse me for not quoting or top-posting possible)
>
> ___
> postgis-users mailing list
> postgis-users@postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users
>
>
___
postgis-users mailing list
postgis-users@postgis.refractions.net
http://postgis.refractions.net/mailman/listinfo/postgis-users
Re: [postgis-users] PostGIS Day
It looks like a custom structure, not PostGIS really.
cur.execute("CREATE TABLE precipud19002008 (gid serial PRIMARY KEY not
null, year int, month int, lon decimal, lat decimal, prec decimal);")
--
Mateusz Łoskot
Sent from my mobile (excuse me for not quoting or top-posting possible)
___
postgis-users mailing list
postgis-users@postgis.refractions.net
http://postgis.refractions.net/mailman/listinfo/postgis-users
Re: [postgis-users] PostGIS Day
I think PostGIS word play and bad puns are in order, myself. Stephen Mather Geographic Information Systems (GIS) Manager (216) 635-3243 s...@clevelandmetroparks.com clevelandmetroparks.com -Original Message- From: postgis-users-boun...@postgis.refractions.net [mailto:postgis-users-boun...@postgis.refractions.net] On Behalf Of Paul Ramsey Sent: Friday, November 11, 2011 11:21 PM To: PostGIS Users Discussion Subject: [postgis-users] PostGIS Day PostGIS day is coming up (November 17, the day after GIS day), any suggestions on ideas for how to mark this special day? P. ___ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users ___ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users
Re: [postgis-users] PostGIS Day
Are those data vector based or raster based? > -Original Message- > From: postgis-users-boun...@postgis.refractions.net [mailto:postgis-users- > boun...@postgis.refractions.net] On Behalf Of Andreas Forø Tollefsen > Sent: Tuesday, November 15, 2011 5:05 AM > To: PostGIS Users Discussion > Subject: Re: [postgis-users] PostGIS Day > > Hi Bob, > > I wrote a short blog post about it here: > http://www.gisintersect.com/?p=186 > > It is a simple Scipy.io.NetCDF python script that eventually outputs to > PostGIS > using the psycopg2 python module. > > Feel free to comment about improvements! > > Andreas > > > 2011/11/14 Bob and Deb > > > Hi Andreas, > > I'm curious about how you enter netCDF files into Postgis? > > Regards, > Bob > > On Nov 14, 2011 12:40 AM, "Andreas Forø Tollefsen" > wrote: > > > What Sveen Atle said. > > I think I will wear my OpenGeo PostGIS t-shirt and find a > solution to how i can import NetCDF to PostGIS quicker than i currently do. > > > 2011/11/14 Sveen Atle Frenvik (Geomatikk IKT) > > > > On 11/12/2011 05:21 AM, Paul Ramsey wrote: > > PostGIS day is coming up (November 17, the day after > GIS day), any > > suggestions on ideas for how to mark this special > day? > > > > At least some "official" statement on the website (or a > related blog), > so my co-workwers won't take PostGIS day as a joke > (which they did last > year :)) > > -a > > > > P. > > > ___ > > postgis-users mailing list > > postgis-users@postgis.refractions.net > > > http://postgis.refractions.net/mailman/listinfo/postgis-users > > > > -- > Atle Frenvik Sveen > Utvikler > Geomatikk IKT AS > tlf: 45 27 86 89 > atle.frenvik.sv...@geomatikk.no > > > ___ > postgis-users mailing list > postgis-users@postgis.refractions.net > http://postgis.refractions.net/mailman/listinfo/postgis- > users > > > > > ___ > postgis-users mailing list > postgis-users@postgis.refractions.net > http://postgis.refractions.net/mailman/listinfo/postgis-users > > > > > ___ > postgis-users mailing list > postgis-users@postgis.refractions.net > http://postgis.refractions.net/mailman/listinfo/postgis-users > > > ___ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users
Re: [postgis-users] PostGIS Day
Hi Bob, I wrote a short blog post about it here: http://www.gisintersect.com/?p=186 It is a simple Scipy.io.NetCDF python script that eventually outputs to PostGIS using the psycopg2 python module. Feel free to comment about improvements! Andreas 2011/11/14 Bob and Deb > Hi Andreas, > > I'm curious about how you enter netCDF files into Postgis? > > Regards, > Bob > On Nov 14, 2011 12:40 AM, "Andreas Forø Tollefsen" > wrote: > >> What Sveen Atle said. >> >> I think I will wear my OpenGeo PostGIS t-shirt and find a solution to how >> i can import NetCDF to PostGIS quicker than i currently do. >> >> 2011/11/14 Sveen Atle Frenvik (Geomatikk IKT) < >> atle.frenvik.sv...@geomatikk.no> >> >>> On 11/12/2011 05:21 AM, Paul Ramsey wrote: >>> > PostGIS day is coming up (November 17, the day after GIS day), any >>> > suggestions on ideas for how to mark this special day? >>> > >>> At least some "official" statement on the website (or a related blog), >>> so my co-workwers won't take PostGIS day as a joke (which they did last >>> year :)) >>> >>> -a >>> >>> > P. >>> > ___ >>> > postgis-users mailing list >>> > postgis-users@postgis.refractions.net >>> > http://postgis.refractions.net/mailman/listinfo/postgis-users >>> >>> >>> -- >>> Atle Frenvik Sveen >>> Utvikler >>> Geomatikk IKT AS >>> tlf: 45 27 86 89 >>> atle.frenvik.sv...@geomatikk.no >>> ___ >>> postgis-users mailing list >>> postgis-users@postgis.refractions.net >>> http://postgis.refractions.net/mailman/listinfo/postgis-users >>> >> >> >> ___ >> postgis-users mailing list >> postgis-users@postgis.refractions.net >> http://postgis.refractions.net/mailman/listinfo/postgis-users >> >> > ___ > postgis-users mailing list > postgis-users@postgis.refractions.net > http://postgis.refractions.net/mailman/listinfo/postgis-users > > ___ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users
Re: [postgis-users] PostGIS Day
Hi Andreas, I'm curious about how you enter netCDF files into Postgis? Regards, Bob On Nov 14, 2011 12:40 AM, "Andreas Forø Tollefsen" wrote: > What Sveen Atle said. > > I think I will wear my OpenGeo PostGIS t-shirt and find a solution to how > i can import NetCDF to PostGIS quicker than i currently do. > > 2011/11/14 Sveen Atle Frenvik (Geomatikk IKT) < > atle.frenvik.sv...@geomatikk.no> > >> On 11/12/2011 05:21 AM, Paul Ramsey wrote: >> > PostGIS day is coming up (November 17, the day after GIS day), any >> > suggestions on ideas for how to mark this special day? >> > >> At least some "official" statement on the website (or a related blog), >> so my co-workwers won't take PostGIS day as a joke (which they did last >> year :)) >> >> -a >> >> > P. >> > ___ >> > postgis-users mailing list >> > postgis-users@postgis.refractions.net >> > http://postgis.refractions.net/mailman/listinfo/postgis-users >> >> >> -- >> Atle Frenvik Sveen >> Utvikler >> Geomatikk IKT AS >> tlf: 45 27 86 89 >> atle.frenvik.sv...@geomatikk.no >> ___ >> postgis-users mailing list >> postgis-users@postgis.refractions.net >> http://postgis.refractions.net/mailman/listinfo/postgis-users >> > > > ___ > postgis-users mailing list > postgis-users@postgis.refractions.net > http://postgis.refractions.net/mailman/listinfo/postgis-users > > ___ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users
Re: [postgis-users] PostGIS Day
What Sveen Atle said. I think I will wear my OpenGeo PostGIS t-shirt and find a solution to how i can import NetCDF to PostGIS quicker than i currently do. 2011/11/14 Sveen Atle Frenvik (Geomatikk IKT) < atle.frenvik.sv...@geomatikk.no> > On 11/12/2011 05:21 AM, Paul Ramsey wrote: > > PostGIS day is coming up (November 17, the day after GIS day), any > > suggestions on ideas for how to mark this special day? > > > At least some "official" statement on the website (or a related blog), > so my co-workwers won't take PostGIS day as a joke (which they did last > year :)) > > -a > > > P. > > ___ > > postgis-users mailing list > > postgis-users@postgis.refractions.net > > http://postgis.refractions.net/mailman/listinfo/postgis-users > > > -- > Atle Frenvik Sveen > Utvikler > Geomatikk IKT AS > tlf: 45 27 86 89 > atle.frenvik.sv...@geomatikk.no > ___ > postgis-users mailing list > postgis-users@postgis.refractions.net > http://postgis.refractions.net/mailman/listinfo/postgis-users > ___ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users
Re: [postgis-users] PostGIS Day
On 11/12/2011 05:21 AM, Paul Ramsey wrote: > PostGIS day is coming up (November 17, the day after GIS day), any > suggestions on ideas for how to mark this special day? > At least some "official" statement on the website (or a related blog), so my co-workwers won't take PostGIS day as a joke (which they did last year :)) -a > P. > ___ > postgis-users mailing list > postgis-users@postgis.refractions.net > http://postgis.refractions.net/mailman/listinfo/postgis-users -- Atle Frenvik Sveen Utvikler Geomatikk IKT AS tlf: 45 27 86 89 atle.frenvik.sv...@geomatikk.no ___ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users
Re: [postgis-users] PostGIS Day
I'm planning on biting the bullet and learning about use the raster functionality with a beer in my hand... is that the sort of thing you were after? cheers Ben On 12/11/2011, at 12:21 PM, Paul Ramsey wrote: > PostGIS day is coming up (November 17, the day after GIS day), any > suggestions on ideas for how to mark this special day? > > P. > ___ > postgis-users mailing list > postgis-users@postgis.refractions.net > http://postgis.refractions.net/mailman/listinfo/postgis-users ___ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users
[postgis-users] PostGIS Day
PostGIS day is coming up (November 17, the day after GIS day), any suggestions on ideas for how to mark this special day? P. ___ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users
