<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META content="text/html; charset=us-ascii" http-equiv=Content-Type>
<META name=GENERATOR content="MSHTML 9.00.8112.16434"></HEAD>
<BODY>
<DIV><SPAN class=744530504-14092011><FONT size=2 face=Arial>strk and
Andrea,</FONT></SPAN></DIV>
<DIV><SPAN class=744530504-14092011><FONT size=2
face=Arial></FONT></SPAN> </DIV>
<DIV><SPAN class=744530504-14092011><FONT size=2 face=Arial>Perhaps this is just
illegal by specs, but I'm wondering why I couldn't logically create a multi/poly
topogeometry from edges that form the boundary of a polygon? or do the specs
just not</FONT></SPAN></DIV>
<DIV><SPAN class=744530504-14092011><FONT size=2 face=Arial>allow that. I
see the CreateTopoGeom just throws an error if I dear try to create a polygon
from edges.</FONT></SPAN></DIV>
<DIV><SPAN class=744530504-14092011><FONT size=2
face=Arial></FONT></SPAN> </DIV>
<DIV><SPAN class=744530504-14092011><FONT size=2 face=Arial>I was trying to take
my neighborhoods table and convert my geometries to topo geoms. So I used
this update statement. That's a lot of faces though. I think it
would be</FONT></SPAN></DIV>
<DIV><SPAN class=744530504-14092011><FONT size=2 face=Arial>much faster if I
could have built from the edges of the boundaries.</FONT></SPAN></DIV>
<DIV><SPAN class=744530504-14092011><FONT size=2
face=Arial></FONT></SPAN> </DIV>
<DIV><SPAN class=744530504-14092011><FONT size=2 face=Arial>UPDATE
boston.nei<BR> SET topo = <BR>
topology.CreateTopoGeom('topo_boston'<BR>
,3,6<BR> ,
foo.bedges)</FONT></SPAN></DIV>
<DIV><SPAN class=744530504-14092011><FONT size=2 face=Arial>FROM (SELECT
n.gid, topology.TopoElementArray_Agg(DISTINCT ARRAY[f.face_id,3]) As
bedges<BR> FROM boston.nei As
n<BR> INNER
JOIN topo_boston.face As f ON n.geom &&
f.mbr<BR> WHERE ST_Covers(n.geom,
topology.ST_GetFaceGeometry('topo_boston',
f.face_id))<BR>
GROUP BY n.gid) As foo<BR>WHERE foo.gid = boston.nei.gid;</FONT></SPAN></DIV>
<DIV><SPAN class=744530504-14092011><FONT size=2
face=Arial></FONT></SPAN> </DIV>
<DIV><SPAN class=744530504-14092011><FONT size=2 face=Arial>It's also not quite
what I hoped for but that could be because I'm still missing faces or tiger
doesn't care about Boston neighborhoods which is quite possible or who ever drew
the maps idea of streets are not aligned with those of tiger. See attached
images -- my original geometry and the topo column</FONT></SPAN></DIV>
<DIV><SPAN class=744530504-14092011><FONT size=2 face=Arial>generated from
it.</FONT></SPAN></DIV>
<DIV><SPAN class=744530504-14092011><FONT size=2
face=Arial></FONT></SPAN> </DIV>
<DIV><SPAN class=744530504-14092011><FONT size=2 face=Arial>Boston neighborhoods
are kind of dumb since no one can agree on the boundaries and people get into
fist fights about it. I think the same case in
Philadelphia.</FONT></SPAN></DIV>
<DIV><SPAN class=744530504-14092011><FONT size=2
face=Arial></FONT></SPAN> </DIV>
<DIV><SPAN class=744530504-14092011><FONT size=2
face=Arial></FONT></SPAN> </DIV>
<DIV><SPAN class=744530504-14092011><FONT size=2
face=Arial>Thanks,</FONT></SPAN></DIV>
<DIV><SPAN class=744530504-14092011><FONT size=2
face=Arial>Regina</FONT></SPAN></DIV>
<DIV><SPAN class=744530504-14092011><FONT size=2
face=Arial></FONT></SPAN> </DIV>
<DIV><SPAN class=744530504-14092011><FONT size=2
face=Arial></FONT></SPAN> </DIV>
<DIV><SPAN class=744530504-14092011><FONT size=2
face=Arial></FONT></SPAN> </DIV>
<DIV><SPAN class=744530504-14092011><FONT size=2
face=Arial></FONT></SPAN> </DIV>
<DIV><SPAN class=744530504-14092011> </SPAN></DIV></BODY></HTML>