search

CartoDB / cartodb

Location Intelligence & Data Visualization tool
http://carto.com
BSD 3-Clause "New" or "Revised" License
2.75k stars 651 forks source link

Intersecting data (points and polygons), error. #8601

Closed nygeog closed 8 years ago

nygeog commented 8 years ago

Trying to intersect TRI sites, buffered (polygons 1 km) with schools (points) in NY state, and I got the following error.

screen shot 2016-07-06 at 6 46 46 pm

I'm @danny on slack if any more questions.

saleiva commented 8 years ago

Can you try again? We fixed some stuff related with this yesterday. If it keeps happening, please reopen

nygeog commented 8 years ago

I'm still not getting the intersect to work. And if I try the different cardinality where Source is points it won't let the Target Layer of polygon be selected.

screen shot 2016-07-07 at 7 47 50 am

saleiva commented 8 years ago

Can you go to the network panel, click on that request and send me the response information? Thanks!

nygeog commented 8 years ago

Not totally sure if this is the info you asked for. Let me know if something else.

screen shot 2016-07-07 at 7 58 52 am

screen shot 2016-07-07 at 7 59 04 am

saleiva commented 8 years ago

perfect thanks

nygeog commented 8 years ago

If its helpful, I'm also running a similar Intersect on another Map with a different set layers (NYC only instead of Statewide) and just worked.

nygeog commented 8 years ago

screen shot 2016-07-07 at 8 17 50 am

I tried same process minus one step (without filtering by CHEMICAL = 'LEAD'). Same error.

nygeog commented 8 years ago

Sanity-check, do I have the cardinality of this intersection conceptually correct (re: target, source)? screen shot 2016-07-07 at 8 20 01 am

nygeog commented 8 years ago

Got it to work for a subset in size and col's, I'll have someone try same steps w/ these datasets. And if that works will incrementally bring in datasets with more and more of the original data until I can identify what is going on. I'm going to close this until I figure out what the issue is. It may be data-related rather than BUILDER-related.

nygeog commented 8 years ago

Yeah, its now working with all the schools in the state. This may have been a data issue, not a builder issue.