Blair,
* Blair Deaver (blairdea...@gmail.com) wrote:
With that said, I have been looking into the new capabilities available
with PostgreSQL HStore
Uhm.. hstore isn't exactly new. It's been around since something like
8.0.. It is amusing how people are just now coming to see. :)
- Can
* Paragon Corporation (l...@pcorp.us) wrote:
The cross streets feature takes a different algorithm. We do have that
coded as a sub process in one of our projects, but it's not committed in
tiger geocoder. Feel free to post a ticket under tiger_geocoder
if you are interested in seeing it
Steve,
* Stephen Woodbridge (wood...@swoodbridge.com) wrote:
This is probably a fairly clean and only little more complex than
hello world, but not majorly so, if you want to try your hand at it.
Pretty sure that I could manage it- but I'm curious.. Do you use an
external sources or bits of
* Paragon Corporation (l...@pcorp.us) wrote:
I would almost go with forcing everyone to change their existing tables to
typmod if they want to reap the benefits of PostGIS 2.0,
but most of my clients will not go to 2.0 then.
What I havn't heard yet is any explanation or description of *why*
All,
* Sandro Santilli (s...@keybit.net) wrote:
On Fri, May 20, 2011 at 03:15:26AM -0400, Paragon Corporation wrote:
So that is why I was proposing a hybrid -- geometry_columns -- so new
PostGIS can work with older tools
Having a hybrid may work for backwards-compatibility reasons, but we
* Paragon Corporation (l...@pcorp.us) wrote:
I'm not sure how much preplanning will help. Because plans are cached in
PostgreSQL for these dynamic like queries and I think they are actually
cached across sessions using shared memory. So upping shared memory helps
quite a bit.
We're using
Stephen,
* Stephen Woodbridge (wood...@swoodbridge.com) wrote:
In a geocoder I wrote in 2000, I mapped city, state and/or zipcode
into a list of counties, then only searched those counties. This
greatly reduced the 3300 counties in Tiger to a small handful that
needed to be searched. The
* Johnathan Leppert (johnathan.lepp...@gmail.com) wrote:
Ok, I have it working, but it's very very slow. It takes about two seconds
to geocode a single record. This isn't very realistic for large datasets.
Anyone have any ideas on possible optimization? It appears to have created
proper
Brian,
* Brian Hamlin (mapl...@light42.com) wrote:
I am guessing that work_mem is the wildcard that is causing the
large allocations..
Comments / Suggestions on this ?
Yes, work_mem is used to determine, for each sort/hash/etc, if it
should be done in-memory or done on disk. If you have a
* Stephen Woodbridge (wood...@swoodbridge.com) wrote:
Thanks! that is exactly what I needed to know. I'm in the painful
process of downloading the NED data from there seamless download
application - I can not tell you how frustrating these stupid apps are.
Just give me a simple ftp site
* Paragon Corporation (l...@pcorp.us) wrote:
4) Do you want all your state edges in one table or separated by county.
When doing all state I tend to lump all the data in a state table and forget
about county tables, unless a state is sufficiently big where breaking by
county makes things a bit
Jeff,
* Jeff Davis (pg...@j-davis.com) wrote:
I would like to query my latitude/longitude points for distance in a
way that uses the index. The points are in lat/lon, so st_dwithin(g1,
g2, [meters]) makes no sense.
What is the recommended way to do this? I think what I need is a
function
* Stephen Woodbridge ([EMAIL PROTECTED]) wrote:
Would this be an appropriate list to ask OSGeo to host?
Sounds like a reasonable idea, I'd certainly like to participate in one.
If you create one, please be sure to let us all know. :)
Thanks,
Stephen
signature.asc
* Chris Hermansen ([EMAIL PROTECTED]) wrote:
Paul Ramsey wrote:
Trust me, Chris, the maintenance of GEOMETRY_COLUMNS has been a
longstanding bug'a'bear and in retrospect we probably would have been
better off without it. In order to get an automagic GEOMETRY_COLUMNS
though, we
Stephen,
* Stephen Woodbridge ([EMAIL PROTECTED]) wrote:
Have look into using inherited tables? This would allow you to have a
nation view or a state view of the county data. View being used in the
literal not postgres in this case.
Honestly, I havn't. I'm really not all that keen on
inheiritance and whatnot.
Thanks,
Stephen
On Fri, Apr 4, 2008 at 11:10 AM, Stephen Frost [EMAIL PROTECTED] wrote:
Stephen,
* Stephen Woodbridge ([EMAIL PROTECTED]) wrote:
Have look into using inherited tables? This would allow you to have a
nation view
!
Stephen
On Thu, 2008-04-03 at 17:07 -0400, Stephen Frost wrote:
* Stephen Frost ([EMAIL PROTECTED]) wrote:
I think they may have also upgraded their pipe.. I got about 1.41MB/s
(11 Mb/s) for the whole transfer. It's about 22G all told. I'll
probably be trying to load
.)
Thanks,
Jonathan
2 attachments: TIGER2007andOSM.png, TIGER2007andGoogle.png
On Thu, 2008-04-03 at 19:18 -0400, Stephen Frost wrote:
Jonathan,
* Jonathan W. Lowe ([EMAIL PROTECTED]) wrote:
Have you yet tried overlaying TIGER 2007 linework or census block/tract
polygons
,
-Stephen Woodbridge
http://imaptools.com/
Thanks!
Stephen
On Thu, 2008-04-03 at 17:07 -0400, Stephen Frost wrote:
* Stephen Frost ([EMAIL PROTECTED]) wrote:
I think they may have also upgraded their pipe.. I got about 1.41MB/s
(11 Mb/s) for the whole transfer. It's
Stephen,
* Stephen Woodbridge ([EMAIL PROTECTED]) wrote:
I added to process_tiger.sh:
# User to connect to database with or use USER=$LOGNAME
USER=postgres
Ah, sure, makes sense. We user Kerberos for our authentication, so I
tend to forget about user/pw authentication issues.
and in vi
,
Stephen
On Mon, 2008-03-31 at 20:57 -0400, Stephen Frost wrote:
* Peter Foley ([EMAIL PROTECTED]) wrote:
For those of you who have been waiting, the Census bureau finally released
the new TIGER/Line shapefiles.
The information page and download links are here:
http
is that you just scan through all of them. That's really not
that hard to do. It's certainly what I'm planning to do with the tiger
geocoder that I maintain as part of the PostGIS extras..
Thanks,
Stephen
On Mon, 2008-03-31 at 22:18 -0400, Stephen Frost wrote:
Dan
* Stephen Woodbridge ([EMAIL PROTECTED]) wrote:
I'm wondering if the Debian maintainer for postgis is on this list?
Uh, yes, and no, you don't need to also Cc me.
I just upgraded to Etch and I'm sad to find out the the GIS stack is
terribly out of date.
Etch is Debian/stable. It's intended
Jason,
* Jason Horning ([EMAIL PROTECTED]) wrote:
While we understand that what we have is still essentially a prototype,
we are thinking that what we have done to date could be of some use to
the people who are focussed on mapping and geocoding projects and would
be happy to provide it for
* Michael Welter ([EMAIL PROTECTED]) wrote:
Out of the box, the script loads CompleteChain and Landmarks.
Yeah, these are the more 'straight-forward' imports.
Loading PolyChainLink and AreaLandmarks are commented out, and I assume
I'll have to rerun the script with these.
If you want
Greetings,
* Santosh Gaikwad ([EMAIL PROTECTED]) wrote:
I would like to know how to use TIGEr geocoder in PostGIS new version
1.3.1. I would also like to have information how to load TIGER line data
into PostGIS database i.e. which files to be loaded of the zip file
provided on TIGER website
* Santosh Gaikwad ([EMAIL PROTECTED]) wrote:
Does anybody know how to use tiger_geocoder? Please also explain me how
to load TIGER/line data into postgis. There are many files when you
unzip the tiger/line data folder. Which files to be loaded into the
database?
I'd strongly encourage you to
Marvin,
* Marvin ([EMAIL PROTECTED]) wrote:
It looks like that there are more problems than I expected. I tried to run
Not sure if you've been following along, but the stuff I'm currently
using is now loaded into PostGIS SVN. Feel free to take a peek at it
and try using it- might go more
* Chetan Tiwari ([EMAIL PROTECTED]) wrote:
I have a little perl script that reads CSV files uploaded via a browser and
inserts the data into a table in postgres. I'll be happy to share that with
you. It's setup to run with active perl and apache on windows, but it would
be fairly easy to tweak
* Shuo Liu ([EMAIL PROTECTED]) wrote:
I'm working on a GIS project and trying to use TIGER Geocoder from the
refractions website on TIGER data. The two sql files in the Geocoder
generated some errors when being loaded, complaining that some tables
(gazetteer_places, tiger_geocode_roads,
uses. Now I can tell from your script.
Thank you very much.
Sure.
Stephen
On 6/28/07, Stephen Frost [EMAIL PROTECTED] wrote:
* Shuo Liu ([EMAIL PROTECTED]) wrote:
I'm working on a GIS project and trying to use TIGER Geocoder from the
refractions website on TIGER data. The two
on the street_type_lookup
it bombs, iirc.
Is there someone I can work with on improving it? Submit patches to,
etc? Or should I just find a way to post what I've done that's not
specific to my organization and assume maintenance?
Thanks,
Stephen
On 6/28/07, Stephen Frost [EMAIL
* Marvin ([EMAIL PROTECTED]) wrote:
I seem to be able to geocode an address after running your script. A new
question I have now is the schema of the result returned from geocode. It
seems that a geocoded result may come from one of functions in your script (
e.g., geocode_address_state or
33 matches
Mail list logo
