Latest Contributions by MichaelKohler

I figured it out. Gotta love the 999999 error. It should have said the table schemas to not match. See the definition for the query table below. tableList = ['{}\PropertyIndex'.format(src_fgdb),\ '{}\SiteLocation'.format(src_fgdb), '{}\Parcels'.format(src_fgdb),\ '{}\LegalDescription'.format(src_fgdb),\ '{}\PropertyOwnership'.format(src_fgdb)] fieldList = [["PropertyIndex.OBJECTID",'OBJECTID'],\ ["PropertyIndex.ParcelID",'ParcelID'],\ ["SiteLocation.StreetDirection",'StreetDirection'],\ ["SiteLocation.StreetName",'StreetName'],\ ["SiteLocation.StreetWay",'StreetWay'],\ ["SiteLocation.UnitNumber",'UnitNumber'],\ ["SiteLocation.LocationCity",'LocationCity'],\ ["SiteLocation.LocationPostal",'LocationPostal'],\ ["SiteLocation.SiteAddress",'SiteAddress'],\ ["PropertyOwnership.OwnerFirstName",'OwnerFirstName'],\ ["PropertyOwnership.OwnerLastName",'OwnerLastName'],\ ["PropertyOwnership.Owner2FirstName",'Owner2FirstName'],\ ["PropertyOwnership.Owner2LastName",'Owner2LastName'],\ ["PropertyOwnership.Owner3FirstName",'Owner3FirstName'],\ ["PropertyOwnership.Owner3LastName",'Owner3LastName'],\ ["PropertyOwnership.Street1",'Street1'],\ ["PropertyOwnership.Street2",'Street2'],\ ["PropertyOwnership.City",'City'],\ ["PropertyOwnership.StateProvince",'StateProvince'],\ ["PropertyOwnership.PostalCodeFull",'PostalCodeFull'],\ ["PropertyOwnership.Country",'Country'],\ ["LegalDescription.LegalDescription",'LegalDescription'],\ ["PropertyIndex.PropertyID",'PropertyID'],\ ["Parcels.XCOORD",'XCOORD'],\ ["Parcels.YCOORD",'YCOORD'],\ ["SiteLocation.LocationStartNumber",'LocationStartNumber'],\ ["Parcels.isConfidential",'isConfidential'],\ ["Parcels.PropLatitude",'PropLatitude'],\ ["Parcels.PropLongitude",'PropLongitude']] whereClause = "PropertyIndex.PropertyID = Parcels.AccountNumber and "\ "PropertyIndex.PropertyID = SiteLocation.PropertyID and "\ "PropertyIndex.PropertyID = LegalDescription.PropertyID and "\ "PropertyIndex.PropertyID = PropertyOwnership.PropertyID and "\ "SiteLocation.LocationCity = 'Port Saint Lucie'" keyField = "PropertyIndex.OBJECTID" lyrNamePN = "SphinxPN" arcpy.management.MakeQueryTable(tableList, lyrNamePN,"USE_KEY_FIELDS", keyField, fieldList, whereClause) arcpy.management.CopyRows(lyrNamePN, finalTable) When using using 2.x (Desktop), the field name is just the second name in the field item. ["Parcels.PropLatitude",'PropLatitude'] would be written to the fGDB as PropLatitude. When using using 3.x (Pro), the field would be written to the fGDB as Parcels_PropLatitude. So in 3.x, the two feature classes would produce different fields while in 2.x the fields are the same. see the attached image. Have to use a field map to resolve.

Thanks for the comments I'm using fGDB's. I thought it might be a fGDB version thing because the fGDB comes from an outside source. Unfortunately, the database is the proper version.

Moving from older Desktop 2.x script to 3.x in Pro. For some reason, the script fails in 3.x when trying to Append. Two query tables are created with the exact same fields and joins from different layers. One is created and written to a table, then the other one is created with a query table an appended to the first.Script has been working for years. Tried with and without the brackets. arcpy.management.Append([lyrNameVN], finalTable,"NO_TEST") The error is the ever helpful "ERROR 999999: Something unexpected caused the tool to fail"

Not sure when it happened, but upgrading to different versions of ArcGIS Pro 2.x caused python 3 scripts to fail in the task manager. I couldn't figure out why my Python 3 scripts weren't working anymore while my Python 2 scripts were working fine. The task manager was not helpful in providing clues so I resorted to running them manually. When I found this post the other day, I was hoping this would be a fix. I tried scheduling a batch file in the past and that was working intermittently as well. But today I confirmed I had a python 3 script take 3 tries before it was successful by looking at the log. Thank you very much!

‎03-12-2024

Needed to add the outFields parameter set to return all fields. const template = { "title": "Address: {Property_Address}", "content": [{ type: "text", outFields: ["*"], text: "<ul><li>Description: {CaseDesc} </li>"+ "<li>Status: {CaseStatus} </li>"+ "<li>Date of Infraction: {DateOfInfraction} </li>"+ "<li>Inspector: {InspectorFullName} </li>"+ "<li>Owner Name: {Property_OwnerName} </li>"+ "<li>Legal Description {Property_LegalDescription} </li>"+ "<li>Narrative {Narrative} </li></ul>" }], actions: [openSphinxAction,openPaAction] }; made a code pen with one of the examples. fiddle around with the popup template to see. https://codepen.io/BiiGreen/pen/poBbeEG

‎03-11-2024

I appreciate your help. Below is a picture of inspecting the results in chrome and showing that when a field that is in the data but not in the popup is referenced in the feature action, it comes back as 'undefined'. And the style tag isn't working. const popupCase = { "title": "Address: {Property_Address}", "content": [{ type: "text", text: "<ul><li>Description: {CaseDesc} </li>"+ "<li>Status: {CaseStatus} </li>"+ "<li>Date of Infraction: {DateOfInfraction} </li>"+ "<li>Inspector: {InspectorFullName} </li>"+ "<li>Owner Name: {Property_OwnerName} </li>"+ "<li>Legal Description {Property_LegalDescription} </li>"+ "<li>Narrative {Narrative} </li>"+ "<li>OriginalID: {OriginalId} </li>"+ "<li style='display:none;'>OriginalID: {OriginalId} </li>"+ "<li>Property Id: {Property_PropertyId}</li></ul>" }], actions: [openSphinxAction,openPaAction] }; This code gave the below result. The data is coming from an array out of an API and turned into graphics and then the graphics are turned into a feature layer. Perhaps that has something to do with the necessity of the attribute being in the popup to be accessed in the feature action function. Principal GIS Architech City of Port St Lucie, FL

‎03-11-2024

The data needs to be in the popup to use with the popup feature action and open the link. function openPaLink(){ const paId = view.popup.selectedFeature.attributes.Property_PropertyId; let url = 'https://www.******.gov/RECard/#/propCard/' + paId; window.open(url, '', 'width=400, height=400'); } The style tag didn't work. I tried changing the color and display earlier with style and no luck. The browser shows "Uncaught SyntaxError: Unexpected identifier 'display' at ...." "<li>Legal Description {Property_LegalDescription} </li>"+ "<li>Narrative {Narrative} </li>"+ "<li style="display:none;">OriginalID: {OriginalId} </li>"+ "<li>Property Id: {Property_PropertyId}</li></ul>"

‎03-11-2024

This is what I did with my tiled aerials. They are hosted in AGOL. Not sure if it will help but... using 4.29 "esri/layers/TileLayer" ...... var latestAerialLayer = new TileLayer({ url: "https://tiles.arcgis.com/tiles//arcgis/rest/services/FDOT23_Aerials/MapServer", id: "latestAerial", visible: "true", listMode: "hide-children" });

‎03-11-2024

Hi, I'm trying to see if there is a way to include data in a popup template but not have it show in the popup itself. The reason is that there are 2 fields that are needed to run the feature actions that are meaningless to the user. One is global id and the other is a long integer id. Both of these fields are used in feature actions to open up web pages based on the feature. Here is the popup code const popupCase = { "title": "Address: {Property_Address}", "content": [{ type: "text", text: "<ul><li>Description: {CaseDesc} </li>"+ "<li>Status: {CaseStatus} </li>"+ "<li>Date of Infraction: {DateOfInfraction} </li>"+ "<li>Inspector: {InspectorFullName} </li>"+ "<li>Owner Name: {Property_OwnerName} </li>"+ "<li>Legal Description {Property_LegalDescription} </li>"+ "<li>Narrative {Narrative} </li>"+ "<li>OriginalID: {OriginalId} </li>"+ "<li>Property Id:<\b> {Property_PropertyId}</li></ul>" }], actions: [openSphinxAction,openPaAction] }; Thanks!

‎02-28-2024

My issue was the inconsistent field naming across the different items. In order for this to work, the search field name has to be used everywhere. My search field name was property and the key to the tables was siteid. The hosted table and the csv table had to have a field named siteid and property. In the choices spreadsheet, there had to be a row for the select_one property see choices.png In the survey row for the select_one property, the formula in the appearance column is below autocomplete search('property?url=https://services1.arcgis.com/*/arcgis/rest/services/PropertyTables/FeatureServer/3','matches','site',${siteid}) the table parameter in the search function has to start with property as well. to get the same result from the csv file autocomplete search('PropSched','matches','site',${siteid}) And thanks to Tyler for pointing out my rogue apostrophe. 🙂

‎02-28-2024

I'm trying to populate a select_multiple field list from a feature service I have a feature service of polygons with a "siteid" field. User clicks on map and the location is used to spatially query the feature service and return the "siteid" for the polygon. No problem with a script. From this siteid, I want to select all assets that are associated with the siteid from a hosted feature table and return a description of the asset. Then, when an asset description is selected, I need to return the asset id for that asset and store in hidden field. I've put the data in a csv file in the survey123 linked content and tried the below and nothing is returned. autocomplete search('PropSched','matches','site','${siteid}) I've also tried to do the search using the hosted table like below and nothing is returned. autocomplete search('prop?url=https://services1.arcgis.com/********/arcgis/rest/services/Property_Tables/FeatureServer/3','matches','site','${siteid}) I am able to use a script to return all the assets for a site in json and could format that as needed. But, don't know how to use that to populate the select_multiple. No idea where I'm going wrong and I've spent way too much time on this. Any help would be greatly appreciated.

‎02-20-2024

Thank you I was having issues with a very simple join between a feature class and table in a FGDB. Nothing that I did, no matter where the data was located or stored, ever worked. I made sure that the "Index Joined Field" box and the "Rebuild Join Field Indexes" were both checked, and the Join worked. Running ArcPro 3.2.2

‎01-17-2024

Hi, I have a strange problem. We are moving all the services located on our local arcgis server to arcgis online. I'm trying to update an in-house form application that uses these services. When I publish the same data to arcgis online, the find.find comes back with an error shown in the attached RejectedPromise.png image. // The find() performs a LIKE SQL query based on the provided text value // showResults() is called once the promise returned here resolves find.find(findUrl, params).then(showResults).catch(rejectedPromise); The app was running in 4.7 for several years, until we started moving to agol. When I called tech support this morning, they told me to update it to 4.28 and see what happens. Anyway, i took their find sample on the sdk site: Developers Find Sample I edited it to use local services and hosted services by commenting out a line. // Create a URL pointing to a map service const findUrl = "https://services1.arcgis.com/*********/arcgis/rest/services/Partest/FeatureServer"; //const findUrl = "https://***********/rest/services/RealEstate/Parcels/MapServer"; // Set parameters to only query the Counties layer by name const params = new FindParameters({ layerIds: [0], searchFields: ["PARCELID"] }); The exact same data in a local service works while the hosted service bombs. I tried it with other services we are moving like addresses and it's the same thing. I even modified the find example to work with our garbage collection hosted service that has always been hosted published right from Pro and it's the same thing. The only difference is the type of service, Feature Server or Map Server. Their find example uses a Map Service. I will call support tomorrow and show them the testing app I made and see what happens. Does anyone have any information that might help me find a resolution. Thanks in advance, Michael

‎10-31-2023

Hello again! we are moving all our content to AGOL and losing our local servers in an effort to reduce costs, maintenance and increase security associated with on prem servers. I'm losing my local ArcGIS Server which holds secured feature services that are accessed by various applications. Besides not being able to use our printing and geoprocessing services from our AGS, we are losing the security features provided by our local AGS. We have feature services that are accessed through javascript apps via a proxy. Now that we are losing the security model offered by AGS, how can we replicate this with a hosted feature service. We've implemented the oauth option that requires users to sign in and that works for the services that have minimal users with AGOL logins. The problem arises when we have a service used by multiple departments and multiple users in each department and the users can and do change frequently. Acquiring licenses for this is cost prohibitive and definitely not what anyone wants to do. Is there anyway to allow access to this secured service without having a user login?

‎10-11-2023

Hi, Trying to link to an ArcGIS Online WebAppBuilder app. I know this is the standalone developer section but it should likely be the same. I want to query for a feature and set the scale. The parameters work individually but when put together, only the query parameter seems to be used. https://pslgis.maps.arcgis.com/apps/webappviewer/index.html?id=954ca00870d54fd780f4388e32662ae6&scale=1500&query=PZWEB_2771,PROJNO,P22-253 This parameter by itself works. The &scale=1500 works by itself. &query=PZWEB_2771,PROJNO,P22-253 Is this possible or, as usual, am I missing something. Thanks

Online Status	Offline
Date Last Visited	a week ago

My Ideas

Latest Contributions by MichaelKohler

Re: Append works in 2.x but not 3.x

Re: Append works in 2.x but not 3.x

Append works in 2.x but not 3.x

Re: Error code 246 when attempting to import ArcGIS API for Python through CMD prompt

Re: Hide data in popup

Re: Hide data in popup

Re: Hide data in popup

Re: Upgrading from 3 to 4: TiledMapServiceLayer (how to)?

Hide data in popup

Re: create select_one items from feature service and return multiple attributes

create select_one items from feature service and return multiple attributes

Re: Simple join between shapefile and table producing no matches upon validation

Find.find works with local Map Service but not with Hosted Feature Service

Access a secured hosted feature service with JavaScript 4

Multiple Query Parameters in web app doesn't seem to be working

Re: Append works in 2.x but not 3.x

Invalid JSON Primitive using applyEdits

Re: Problem with the Capital Projects Solution Dep...

ZoomToSelectedAsync keeps zooming in

Re: Map Series Extent indicator not updating