Latest Contributions by LauraBecht

Hi, i have been using insights for a while, and with my most recent project, have come across an annoying issue. I create summary tables of taxable values by city, etc, and then need to calculate taxable change. Then i want to allow my users to filter by land use with a predefined filter, but the predefined filter won't work. It works fine before i calculate the new field, but not after, on the same summary table. I have tested this multiple times and it is very aggravating. It seems that i have to create the summary outside insights and only use insights to create my report, i can't do the summary analysis in insights.

‎11-20-2020

Hi, I am fairly new to insights and have run into an issue that kind of puzzles me. To give some background, I want to be able to use insights to allow my users to take a parcel point dataset, filter it for a given area from a polygon using a spatial filter, and then export it to shapefile or csv. All using predefined filters. The parcel dataset is too large to show all of it on a map card, so i have a predefined filter that filters by RT to get the total point count down. So the spatial filter is actually being done on a dataset filtered by a predefined filter. My problem comes that when I get my parcel subset using the predefined filter and then try to use the spatial filter which also uses a predefined filter to get a specific cdp for example, it tries to do the spatial filter on the entire dataset. When I make a summary table which shows the subset count and then try to export that it also exports the entire dataset and not my subset. Basically, my predefined filters are showing my subsets in table and map cards, but will not allow me to export those subsets. This is great for the visual, but does little to help my users make use of those subsets. Is this something I am doing wrong? My users need to be able to do this spatial intersect and output a list of parcels. I know if I do a hard filter on the point and polygon datasets I can get the spatial filter to work, but I want my users to be able to use a predefined filter.

‎10-26-2020

I have the same question. I know how to export from my workbook, but I need to be able to export filtered summary tables from a shared page. I don't want the user to potentially be able to change any of the data they are filtering, just export the results. Maybe even be able to export the map card or chart as a pdf or image might be nice as well. But really need the table export.

‎07-02-2019

Yes, this looks like you already have a community parcel dataset that you are planning to add information to which is your source data. I don't think any data is actually obtained from ESRI, it is all data from your organization and government agencies.

‎04-17-2019

I ran my model with the add layer script and got the same error I was getting with calculate value Executing (Add Layer): AddLayer Adara_World_Gateway_BLDG_NO_1000 Start Time: Wed Apr 17 09:35:52 2019 Running script AddLayer... Failed script AddLayer... Traceback (most recent call last): File "D:\Scripts\Add_Layer.py", line 5, in <http://www.ocpafl.org/> <https://www.facebook.com/ocpafl>[cid:twitter_6cdbc742-1f4d-4e8a-9574-da593d6220f1.png]<https://twitter.com/ricksinghocpa>[cid:youtube_8082825c-0b33-4ebb-80c3-d490b789ebca.png]<https://www.youtube.com/user/OCPAFL>[cid:instagram_eddac590-fdb8-4599-aa07-0677c65b9ad6.png]<https://instagram.com/ricksinghocpa>[cid:Flickr_9a626e46-c468-4d00-a657-dd7094e9b498.jpg]<https://www.flickr.com/photos/151885696@N03/albums>

‎04-17-2019

Yes to both, and neither have made any difference. I have written a python script that does the same thing using arcpy.mapping and am going to test that today. I saw a comment elsewhere that you can use calculate value and arcpy.mapping to add a layer to the TOC, but I wasn’t able to get that to work. Either I couldn’t get the syntax quite right, or you just can’t do it using calculate value. This kinda became a puzzle to solve for me. I have spent way too much time playing with this lol. I am currently using 10.3 if that makes any difference. Laura Becht, CFE GIS Analyst – Geoprocessing Representing Rick Singh, CFA | Orange County Property Appraiser 200 S. Orange Ave | Suite 1700 | Orlando, FL 32801 407.836.5908 work | 407.836.5985 fax lbecht@ocpafl.org<mailto:lbecht@ocpafl.org> | www.ocpafl.org<http://www.ocpafl.org> <http://www.ocpafl.org/> <https://www.facebook.com/ocpafl>[cid:twitter_6cdbc742-1f4d-4e8a-9574-da593d6220f1.png]<https://twitter.com/ricksinghocpa>[cid:youtube_8082825c-0b33-4ebb-80c3-d490b789ebca.png]<https://www.youtube.com/user/OCPAFL>[cid:instagram_eddac590-fdb8-4599-aa07-0677c65b9ad6.png]<https://instagram.com/ricksinghocpa>[cid:Flickr_9a626e46-c468-4d00-a657-dd7094e9b498.jpg]<https://www.flickr.com/photos/151885696@N03/albums>

‎04-16-2019

I created a test model that selects from a layer in ArcMap and makes a feature layer. I made the number variable as a multivalue string that I iterated over. When I ran the model, it selected each - in this case building - number and showed it in the existing feature layer. Only problem is it wouldn't create a new feature layer in the table of contents for some reason. It had no problem using the variable in the new layer name, just wouldn't display the new layer.

Online Status	Offline
Date Last Visited	Wednesday

My Ideas

Latest Contributions by LauraBecht

Unable to use predefined filter after calculating field in table in insights

Select records with predifined filter and export them

Re: Export Filtered Results from Table to .csv/.txt File

Re: I need help with Data Assistant and accessing data

Re: ModelBuilder use of Variable in Output Filename possible?

Re: ModelBuilder use of Variable in Output Filename possible?

Re: ModelBuilder use of Variable in Output Filename possible?