POST
|
Hi MariusVerdes, this is definitely possible. Are you trying to make a living Excel document in a shared location that your users have access to, or are you sending a new Excel sheet for every record that is added/updated? With both options, I do find it easier to store data in a SharePoint List first then give the users access to the List or write in your Flow to export the list to a CSV. If you want features added or updated on your spreadsheet instantly, you may want to make two flows, one with a trigger for "when a feature is updated" and one for "when a feature is added". Another option would be to create a script using the ArcGIS API for Python and set it on a task scheduler. This wouldn't be triggered when records are added or updated, but if you set the time interval to a reasonable schedule, your users may not even notice. Here's an example of some code: import arcpy
from arcgis.gis import GIS
import pandas as pd
csv = 'file location of end product'
#Your enterprise credentials
portal = GIS(url="YourEnterpiseURL", username="yourUsername", password="yourPassword")
#access the layer
url = 'the layer you are querying'
layer = FeatureLayer(url)
feature_set = layer.query(where="1=1", out_fields = ','.join(fields))
#Convert to spatial data frame
sdf = feature_set.sdf
#Export to CSV
sdf.to_csv(csv, index=False)
... View more
09-12-2023
09:02 AM
|
0
|
1
|
403
|
POST
|
Hi Ray, I have not made a submitted survey editable in Experience Builder, but I have done it in ArcGIS Dashboard and I imagine the workflow is similar. You'll need to create a list widget that will show all your submitted surveys and an embed widget with the URL to your survey. When a user clicks a submitted survey from your list widget, it should pass the globalID attribute to your embed widget. You manually set the URL in the embed widget to be the appropriate case for your use. Yours would be something like https://yoursurveyURL/share/surveyID?mode=edit&globalId={globalid from record you selected} You can find more info in these blogs: https://community.esri.com/t5/arcgis-survey123-blog/survey123-tricks-of-the-trade-embedding-a-survey/ba-p/899140 https://community.esri.com/t5/arcgis-survey123-ideas/survey123-edit-mode-custom-url-scheme/idi-p/940040
... View more
08-17-2023
08:45 AM
|
0
|
0
|
689
|
POST
|
Hi AriLukas, I may be wrong, but it looks like you're using the Laserfiche. If that's the case, you need to add the search command after weblink so you can search on the document's metadata. You'll also need to verify that the document has the attribute you are searching for as part of its metadata. For example, in the link below, I am searching for records within the Recorded Documents template that have a book number of 357 and a page number of 19 - both these numbers were retrieved by clicking the parcel on a web app and then using a dynamic hyperlink within the popup. https://records.cupertino.org/weblink/search.aspx?startid=676&dbid=0&searchcommand={[Recorded%20Documents]:[Book]=%22357%22,[Page]=%2219%22} Here's more info about searching for documents via laserfiche weblinks: https://www.laserfiche.com/resources/blog/customize-search-in-laserfiche-weblink/ https://www.laserfiche.com/resources/blog/how-to-enhance-your-laserfiche-weblink-portal-with-search-urls/
... View more
08-15-2023
08:16 AM
|
0
|
0
|
145
|
POST
|
Hi Ciara, I also have a similar workflow that you may find useful. This is the python script I use. It spatial joins your parcels layer to the facilities layer and will output a new layer with just the APN and the facility ID with a single APN and a list of all the facility IDs. I run this same function to against multiple layers and then join them all together using the APN field so I can have a master parcel layer that has the APN, a list of addresses on the parcel, a list of facility IDs on the parcel, any related tract map information on the parcel, treeIDs on the parcel, etc. You would have to update line 3 so that the value after apnField is the actual name of your APN field and value after apn_Layer is the name of your parcel layer. then in line 55, you update the values of your actual facility layer, the name of the facility ID field, the name you want the facility ID field to have in your new layer, the path of the new layer, and then set the length of the field. Some of the layers I join to my parcel layer have a lot of intersecting records, so the field length can vary. Hope this helps! import arcpy
def comma_join(inputLayer, inputField, outputLayer, fieldName, fieldLength, apnField="APN_SPACE", apnLayer = "Your_PARCEL_Layer", mergeRule="Join"):
"""
Performs a spatial join and keeps a target field with values joined by commas.
Parameters:
- inputLayer: Layer on which the spatial join is performed.
- inputField: Field in the input layer whose values need to be comma joined.
- outputLayer: The resulting layer after spatial join.
- fieldName: The name of the new field where the joined values will be stored.
- fieldLength: The length of the new field.
- apnField: Name of the APN field. Default is "APN_SPACE".
- apnLayer: Name of your Parcel layer or layer with APN vales. Set the default here if you want to use this code on multiple layers
- mergeRule: Rule for merging the fields. Default is "Join".
"""
#Names of fields you want in your output layer
keepers = [apnField, inputField]
#Maps fields from APN layer and target layer to new layer
fieldmappings = arcpy.FieldMappings()
fieldmappings.addTable(inputLayer)
fieldmappings.addTable(apnLayer)
#Remove all non-APN values
for field in fieldmappings.fields:
if field.name not in keepers:
if 'APN' in field.name:
pass
else:
fieldmappings.removeFieldMap(
fieldmappings.findFieldMapIndex(field.name))
fNames = arcpy.ListFields(inputLayer)
for f in fNames:
if f.name == inputField:
fidx = fieldmappings.findFieldMapIndex(f.name)
fmap = fieldmappings.getFieldMap(fidx)
fmap.mergeRule = mergeRule
fmap.joinDelimiter = ","
theField = fmap.outputField
theField.length = fieldLength
theField.name = fieldName
theField.aliasName = fieldName
fmap.outputField = theField
fieldmappings.replaceFieldMap(fidx, fmap)
#The spatial join
arcpy.SpatialJoin_analysis(apnLlayer, inputLayer, outputLayer, "", "",
fieldmappings, "", "", "")
comma_join(*FACILITY_LAYER*,*FACILITY_ID_FIELD*,*NEW JOINED FEATURE PATH*, *NEW_FACILITY_ID_FIELD_NAME*,*SET A LENGTH OF THE FIELD*)
... View more
08-10-2023
08:21 AM
|
0
|
0
|
296
|
POST
|
It looks like Topographic with Hillshade with their own data on top as an overlay. If you're looking for a more muted basemap and one of the existing ones is close to what you're trying to do, you can try to use the Vector Tile Style Editor https://www.arcgis.com/apps/vtseditor/en/. If you haven't used it before, you can use it to modify colors, styles, and labels. We use this often because we like the light gray basemap, but the neighborhood labels will conflict with our own project area labels. Using the style editor, we can remove Esri's neighborhood labels, but keep labels for streets and use the rest of the basemap. Hope this helps!
... View more
08-07-2023
07:54 AM
|
0
|
0
|
214
|
POST
|
I have deployed a minimal gallery for my organization. Users are able to search for tags and titles, but searches must be lowercase. This is problematic, especially for mobile users. Is there a way to change the settings of the search to be able to search without case-sensitivity?
... View more
04-17-2019
11:19 AM
|
0
|
1
|
347
|
DOC
|
Love this widget! Has anyone else had any issues with attribute expressions displaying incorrectly? For some reason, our site will display the attribute expression when the feature is selected from the map, but will not show the expression when I use the search widget. For example, searching for a property, I find that the water service and sanitary district are missing phone numbers and have broken links, but if I click that same property on the map, I see those fields populated. Not sure if this is a question for pop-up panel or for search widget... On Search On Click I opened this case with Esri and they also appear to be stumped...
... View more
03-26-2019
05:12 PM
|
0
|
0
|
3693
|
POST
|
I have a dataset: Legends with symbology our end users would find useful. Currently, I am telling requesters to download that set from our open data site, and then download the portal item from ArcGIS online: http://cupertino.maps.arcgis.com/home/item.html?id=75276e5893cc465cafef5584be506d0c by clicking "view on arcdesktop" Or I send them the portalID http://cupertino.maps.arcgis.com/sharing/rest/content/items/75276e5893cc465cafef5584be506d0c/item.pitem Are there any plans of allowing symbology downloads in Open Data Portal or is there a better practice of sending symbology that I am unaware of? Thanks, Adam
... View more
09-29-2016
04:00 PM
|
1
|
0
|
638
|
POST
|
I am trying to link the table from this dataset: Dataset | City of Cupertino on a separate Junar open data site City of Cupertino Open Data Site . I've tried copying the json, but for some reason it hasn't been working. Does anyone have any experience with this, or have an idea what might work?
... View more
02-04-2016
10:44 AM
|
0
|
0
|
1717
|
POST
|
On ArcGIS online a user can see how many ratings, comments, and views a layer gets. We are trying to establish some sort of metric to keep track of what data is popular among our users. I know an application gets a view for every time the application is loaded, but how is a layer view counted? Does it count as one view once the layer is projected on the map on the open data site, or does the layer actually have to be downloaded?
... View more
02-01-2016
10:03 AM
|
0
|
1
|
2386
|
POST
|
Also having the same problem. We just noticed ours today. Oddly enough, one of the layers that was having that message this morning seems to have resolved itself. The rest of my layers are still carrying the error message
... View more
01-20-2016
10:32 AM
|
1
|
0
|
1003
|
Title | Kudos | Posted |
---|---|---|
1 | 09-29-2016 04:00 PM | |
1 | 01-20-2016 10:32 AM |
Online Status |
Offline
|
Date Last Visited |
11-10-2023
12:00 AM
|