Hi,
I’ve loaded the entire roads dataset in postGIS. I’ve created indeces and made optimizations to my postGIS instance (both of which have improved response times considerably but they are still way too slow) and queries take quite a while to come back.
I’m looking at http://svn.osgeo.org/geotools/trunk/spike/dblasby/tiger/MajorRoads.java
for the optimizations that were done for the sigma demo. They make sense except for a few things.
The code references a “module” that is used to query the original dataset. I don’t know what this is.
below is the relevant code from the conversion class.
FilterFactory ff = FilterFactory.createFilterFactory();
LikeFilter like = ff.createLikeFilter();
like.setPattern(MODULE + “", "”, “?”, “!”);
like.setValue(ff.createAttributeExpression(null, “module”));
String ps = new String
{
“the_geom”, “cfcc”,
“name”,
“altname1”, “altname2”, “altname3”, “altname4”, “altname5”,
“altname6”, “altname7”, “altname8”, “altname9”
};
Another thing. the altnameX columns, where are these supposed to come from? my roads table does not have the “altnameX” columns. I’m running against 2008 Tiger shapefiles so I understand there will be these differences (like cfcc being mtfcc now).
I’m following this documentation as well:
http://geoserver.org/display/GEOSDOC/Loading+TIGER+roads+major
But I still can’t see the altname issue
Can anyone provide insight?
Thanks!
–
Signed,
Alessandro Ferrucci