Community Analyst Record to Feature limit?

[DavidMedeiros]

I'm helping several groups of students use Community Analyst for their class projects. We've been extremely excited about how easily CA lets us explore census data. The problem is CA seems to be very limited in terms of actually letting you use that data directly in ArcGIS.  It has a 100 record join limit and I haven't been able to figure out how to extend the first join into the next set of 100 records.

Is there any way to join more than 100 features or records at a time? I can't see any way to download the raw tabular data instead of the aggregated report.

[Jason_RobinsonRobinson]

I'm helping several groups of students use Community Analyst for their class projects. We've been extremely excited about how easily CA lets us explore census data. The problem is CA seems to be very limited in terms of actually letting you use that data directly in ArcGIS.  It has a 100 record join limit and I haven't been able to figure out how to extend the first join into the next set of 100 records.

Is there any way to join more than 100 features or records at a time? I can't see any way to download the raw tabular data instead of the aggregated report.

David,

If you are using the Import File on the Select Location tab there will be a limit of 100 at a time.

Based on what you are looking to do you might want to take a look at the Community Analyst Add-in for ArcGIS.  It would allow one to not only run CA reports on a polygon feature but also an option to append that reports data back to the polygon layer.  Also no limit of just 100 at a time.

http://www.esri.com/software/arcgis/community-analyst/ca-addin

Regards,
Jason R.

[DavidMedeiros]

David,

If you are using the Import File on the Select Location tab there will be a limit of 100 at a time.

Based on what you are looking to do you might want to take a look at the Community Analyst Add-in for ArcGIS.  It would allow one to not only run CA reports on a polygon feature but also an option to append that reports data back to the polygon layer.  Also no limit of just 100 at a time.

http://www.esri.com/software/arcgis/community-analyst/ca-addin

Regards,
Jason R.

Thanks Jason, although that doesn't make any sense to me. As far as I know, I am already running the CA add-in to ArcGIS. It launches from inside ArcGIS and looks just like the screen shot in that link, but it still limits the number of features it will directly append to.

[Jason_RobinsonRobinson]

Thanks Jason, although that doesn't make any sense to me. As far as I know, I am already running the CA add-in to ArcGIS. It launches from inside ArcGIS and looks just like the screen shot in that link, but it still limits the number of features it will directly append to.

David,

I believe the limit should be around 3500 features unless this somehow changed.  I will double check internally.

Regards,
Jason R.

[DavidMedeiros]

David,

I believe the limit should be around 3500 features unless this somehow changed.  I will double check internally.

Regards,
Jason R.

I just checked again, we are definitely running that add-in. The FAQ for the add-in says 100 records at a time. It says you can batch them 100 records at a time but selecting the next set of 100 records in our feature class doesn't seem to work so not sure how you add more records with out splitting your features up into separate 100 feature tables.

I have groups of students who all found data they need from CA but for hundreds or thousands of records. Splitting their tables up is not really practical and the limit makes CA more or less useless to them.

I was hoping to get a quick forum answer but this is looking like a larger problem for us, I'll probably move over to ESRI help next. Thanks.

[Jason_RobinsonRobinson]

I just checked again, we are definitely running that add-in. The FAQ for the add-in says 100 records at a time. It says you can batch them 100 records at a time but selecting the next set of 100 records in our feature class doesn't seem to work so not sure how you add more records with out splitting your features up into separate 100 feature tables.

I have groups of students who all found data they need from CA but for hundreds or thousands of records. Splitting their tables up is not really practical and the limit makes CA more or less useless to them.

I was hoping to get a quick forum answer but this is looking like a larger problem for us, I'll probably move over to ESRI help next. Thanks.

David,

Actually you are correct.  Was initially thinking about the same API functionality built into Business Analyst Desktop when accessing online data is not nearly as restricted as the BAO/CAO reports add-in as it turns out.  If you'd like I can submit an enhancement request to increase the limit.

Regards,
Jason R.

[DarlaHugaboom]

We have also run into problems with this. Please request this upgrade!