Use "within" instead of "contains" as the spatial operator is referencing the points and the points don't "contain", but are "within" the RING (polygon).
Add Column "ring" (pop00 )From points Set To sum(Pop00) Where within Ben Greenberg GIS Coordinator NAI MLG Commercial 262-797-9400 -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Monday, February 09, 2004 3:08 PM To: [EMAIL PROTECTED] Subject: MI-L Update Column I have a problem that may have a simple answer but has me stumped. Hope y'all can help. I'm trying to update a field "Pop00" in a region know as "Ring" from a point file named "Ak_points". The "AK_points" file is several point locations based on lat/lons of block group centroids where I'm trying to sum the centroids within the ring using the following Mapbasic command. It just ain't working. Any hints? Add Column "Ring" (Pop00 )From ak_points Set To sum(Pop00) Where contains Both Pop00 field are Dec(10,0), I've indexed the ak_point Pop00 field and even tried converting the Ring file to Regions under Objects\Convert to Regions. No Luck. [EMAIL PROTECTED] --------------------------------------------------------------------- List hosting provided by Directions Magazine | www.directionsmag.com | To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] Message number: 10336
