|
POST
|
Nice. My solution space is so constrained with Esri-tech by three walls: bugs, licensing, and strategy. I just bloodied my face on the bug wall again. ArcGIS Pro 2.2.2, hours burned, no Spyder.
... View more
09-11-2018
04:20 PM
|
0
|
13
|
1548
|
|
IDEA
|
Data providers deploy, change over time, and retire Open Data items. Item retirement and some item changes (item ID, URL, fields, etc.) can bust people's stuff. Courteous change management procedures include notification to data consumers and overlapping availability of resources that will enable them to make necessary changes to their solutions. Enabling consumers of Open Data items to subscribe to an RSS feed would enable courteous change management practices by data providers. Not so long ago, Open Data items had a direct path to the item's details page, where a data consumer could find and subscribe to the RSS feed. Not so anymore. Busted. It would be useful if Esri would expose the item's RSS subscription directly on the Open Data page for the item. Check it out: RSS feed here: https://www.arcgis.com/home/item.html?id=16e535bd10a94cab80625cda820a8959 No RSS feed here: http://geo.wa.gov/datasets/WADSHS::dshs-nursing-homes ...and, no path back to here: https://www.arcgis.com/home/item.html?id=16e535bd10a94cab80625cda820a8959 tim
... View more
08-24-2018
01:08 PM
|
16
|
1
|
1923
|
|
POST
|
This change made the RSS feed in the item details page essentially unavailable to Open Data users, which was how they could get notified if they cared about changes I make to the items I share. Typically schema changes (URL, fields, etc.) or item ID changes will bust people's stuff, so I thought it would courteous, if not full on ITIL Service Operation adherent, to let them know ahead of time. It would be nice for Esri to re-expose the RSS feed in the Open Data item presentation page. I guess I'm headed over to "ideas" to see what happens... tim
... View more
08-24-2018
12:38 PM
|
0
|
0
|
1022
|
|
POST
|
Hi Dan, I essentially need control over the data types that Esri's tools write to their geodatabase structure after reading from a CSV file. This control is not provided in Esri's tools or in their documentation. The workaround suggested by technical services gets me where I'm going, albeit with a time-consuming detour. So, I've posted the workaround as my own online documentation that I can find later when I need it again, and maybe help out others who discover they have the same need for control. The two examples I've shared above are cases where Esri's tools make incorrect assumptions about the data types in the CSV and write different, unhelpful, and incorrect values into their geodatabase structure. tim
... View more
07-19-2018
03:57 PM
|
1
|
2
|
5366
|
|
POST
|
Hi Dan - I cannot post rows from an actual CSV, but here are rows that can be used to demonstrate the user experience I describe: RowID,PKID,ReleaseVersion 1,0009198045,1.0 2,0009198046,1.1 3,0009198047,1.2 4,0009198048,1.3 5,0009198049,1.4 6,0009198050,1.5 7,0009198051,1.6 8,0009198052,1.7 9,0009198053,1.8 10,0009198054,1.9 11,0009198055,1.10 12,0009198056,1.11 13,0009198057,1.12 14,0009198058,1.13 15,0009198059,1.14 16,0009198060,1.15 17,0009198061,1.16 18,0009198062,1.17 19,0009198063,1.18 20,0009198064,1.19
... View more
07-18-2018
08:10 AM
|
0
|
4
|
5366
|
|
POST
|
ArcGIS Pro (and ArcMap before it) would make some assumptions about the column values in a CSV file. Too often in my experience, the assumptions were just plain wrong, causing speed bumps, gnashing of teeth, and general furrowing of brows. It turns out that Esri's customers who use ArcGIS Pro can remedy the assumptions being made by using a schema.ini file to tell ArcGIS Pro how to perceive the column values. It also turns out that as of 7/17/2018, it's really hard to find this information, which can lead to time spent interacting with the Esri support teams. So, I'm sharing some info here, where I might be able to find it when I need it again. Background This becomes a problem when you need to import text values that are composed of: numerals (0009198045), and keep the leading zeros numerals and dots (1.0), and need the resulting value to specify a release version in text format instead of "1" and probably some other cases I don't remember GP tools and other functions don't seem to expose any control over how ArcGIS Pro should perceive column values. For example, in the Append GP tool, specify a CSV file as input, click on a field name in the "Field Map" area of the dialog, click "Source", and hover over the field name. ArcGIS Pro will show you a "tooltip" (or something) that tells you what type of value it has assumed is in the field. There is very little info about this situation in the ArcGIS Pro Help documentation. Esri support referred me to this, which appears to be related: http://resources.arcgis.com/en/help/main/10.1/index.html#//005s00000010000000. I just didn't think to look there for help with ArcGIS Pro. I probably need to up my game . Schema.ini info - (random search result) Schema.ini File (Text File Driver) | Microsoft Docs Edit: Esri Support Services reports that Esri does not document how to import CSV files in the ArcGIS Pro help because Esri's view is that the issue is not with the tool, rather "the issue is with the CSV" (maybe they mean that the issue is in how they have chosen to design and develop their tools to work with CSV files... maybe not). I don't buy this proposed notion because from the user perspective, Esri's tools read the correct value and write an incorrect value. As a user, I don't care if the developers use a stick to scratch in the sand to make their function work correctly or if they use the Microsoft ODBC Text File driver. Maybe my idea posting will get some traction, or maybe this is an edge case that no one cares about. https://community.esri.com/ideas/15278 Workaround - from an Esri support request for ArcMap, tested and adjusted for ArcGIS Pro Add the csv file to the Contents of an ArcGIS Pro map. Export the csv file to a new folder outputting the same file name as the input. ArcGIS Pro will write out the CSV file and a "schema.ini" file. Using Windows Explorer go to the output location and copy the schema.ini file that gets created. Paste it into the original location (original folder). Right-click and edit the schema.ini file to specify the correct field type. Note that the header specifies the target CSV file name. Edit: Note that you'll need to make the column number indicators and specified fields line up with your source CSV. During step 2 above, ArcGIS Pro adds its OBJECTID field and writes that specification to the schema.ini table. If your CSV file does not have an OBJECTID field, then things may not go well when you use it, unless you fix it. Now, when you use the CSV file with ArcGIS Pro, it should (hopefully - haven't tested all cases) notice the schema.ini file and use it to override the assumptions it has made about your input. ArcGIS Ideas Expose the ability for the user to override ArcGIS Pro assumptions and specify CSV file input field definitions in all ArcGIS Pro tools and functions that accept CSV as input Document the capability and/or the workaround in the ArcGIS Pro Help instead of causing support requests and Geonet posts. Edit: Alright, enough of that... back to work! tim
... View more
07-17-2018
11:02 AM
|
4
|
9
|
7006
|
|
POST
|
Thanks everyone. the info you shared helped me resolve our similar problem. I then prevented our problem from happening again, and share back in case the info is useful. When Esri enables or creates a 10.5 enterprise geodatabase in SQL Server, the "Data viewer" "type of user" indicated here (Privileges for geodatabases in SQL Server—Help | ArcGIS Desktop) by default is allowed to create domains and feature datasets, although Esri doesn't mention this situation in the help documentation (as of now, maybe they'll update it, maybe not). These enterprise geodatabase objects get stored in the GDB_ITEMS table in the enterprise geodatabase schema. During configuration, Esri grants delete, insert, and update to the PUBLIC server role. We have our "Data viewer" users in the PUBLIC server role and require that they cannot create anything in our enterprise geodatabases, so I obtained this fix during an Esri technical support request: --stop allowing "Data viewer" database users to create, update, and delete domains and feature datasets REVOKE DELETE ON sde.GDB_ITEMS FROM PUBLIC CASCADE; REVOKE INSERT ON sde.GDB_ITEMS FROM PUBLIC CASCADE; REVOKE UPDATE ON sde.GDB_ITEMS FROM PUBLIC CASCADE; GO --let the "Data creator" database user ("DataCreator" below) or any other user you want continue to create, update, and delete domains and feature datasets GRANT INSERT ON sde.GDB_ITEMS TO DataCreator; GRANT UPDATE ON sde.GDB_ITEMS TO DataCreator; GRANT DELETE ON sde.GDB_ITEMS TO DataCreator; GO
... View more
06-06-2018
11:26 AM
|
3
|
0
|
859
|
|
IDEA
|
ArcMap has a time-saving feature where if you specify a geodatabase feature dataset as the output location for geoprocessing tools that output feature classes, then the software would automatically project the incoming data to the spatial reference system defined for the feature dataset. I've blown a couple of hours trying to figure out how to get ArcGIS Pro 2.1.2 to behave this way. At the moment, it looks as if I have to manually assign the desired output spatial reference system each and every time no matter what. It would be great if ArcGIS Pro would behave similarly to ArcMap when targeting GP tool output feature classes to geodatabase feature datasets.
... View more
05-04-2018
01:51 PM
|
2
|
1
|
588
|
|
DOC
|
Thanks Jake Skinner, that's pretty much where I ended up with my wild guesses after poking at the code with my favorite stick. There seems to be some discussion around the subject here - https://community.esri.com/thread/191593-how-to-connect-to-my-portal-when-our-security-is-adfs, but I'm not yet clear about it applying to my environment. No biggie, I ended up rolling some tunes and getting manual with it just to get it done.
... View more
04-23-2018
09:31 AM
|
0
|
0
|
4618
|
|
DOC
|
Nice work, Jake Skinner! I like it... I'm trying to use it with our Portal deployment, which uses ADFS for security, and am getting this message: URLError: <urlopen error [Errno 10061] No connection could be made because the target machine actively refused it> My starting point for troubleshooting the code is to assume that it does not support ADFS. I'm going to start hacking as soon as I sign off here, and I thought you might be able to point me in a good direction... Ooh! just had a thought. be right back. Nope, dang. I thought "ArcGIS Administrator > Connect to Portal > ArcMap > Sign In to Portal > then try to run tool" So, anyway, I'm hitting the documentation and messing with the code. Let me know if you have ideas about how to proceed.
... View more
04-20-2018
01:07 PM
|
0
|
0
|
4618
|
|
IDEA
|
Hi Bruce, Nope. I'm looking to configure ArcGIS Online to use my internally hosted locator and to never use the premium locator provided with ArcGIS Online for batch geocoding. Thanks, tim
... View more
03-15-2018
01:09 PM
|
1
|
0
|
1114
|
|
IDEA
|
Hi Bruce, Nope. I'm looking to configure ArcGIS Online to use my internally hosted locator and to never use the premium locator provided with ArcGIS Online for batch geocoding. Thanks, tim
... View more
03-15-2018
01:09 PM
|
1
|
0
|
993
|
|
IDEA
|
hmm. idea submitted in 2013. Not finding that it has been implemented in early 2018, I just voted it up as a representative of more people in my organization who want it, too. Distinctly unsatisfying way to reiterate the need for a fairly common capability... No indication as to whether or not this idea submission has been reviewed, ignored, added to product plan, scheduled, etc. tim
... View more
01-19-2018
10:11 AM
|
1
|
0
|
4626
|
|
IDEA
|
Support internal locators as geocoders for batch geocoding (i.e. not external only as presently documented - https://doc.arcgis.com/en/arcgis-online/reference/geocode.htm#ESRI_SECTION1_CD53FF34D6A54AB8880A3AE98F805F74) for ArcGIS Online subscription accounts that are signed in. The idea is to enable customers to use secured, protected locators within the ArcGIS Online and ArcGIS Enterprise Portal component environments.
... View more
12-15-2017
03:08 PM
|
3
|
2
|
1070
|
|
IDEA
|
Support configuration (enable/don’t enable) of Esri World Geocoder “Allow geosearch” and “Allow batch geocoding” capabilities. This improvement would be used in conjunction with configuring ArcGIS Online and maybe ArcGIS Enterprise "portal" component for use with local locators that are not premium services that charge credits. The idea is to force the system to use the local locator and not to use the premium service.
... View more
12-15-2017
03:05 PM
|
7
|
3
|
1617
|
| Title | Kudos | Posted |
|---|---|---|
| 1 | 10-24-2024 02:51 PM | |
| 1 | 10-24-2024 02:39 PM | |
| 1 | 10-22-2024 02:31 PM | |
| 1 | 02-07-2024 09:16 AM | |
| 1 | 02-07-2024 08:11 AM |