IDEA
|
@BenWalker - It looks like this post has an update.
... View more
11-20-2021
03:07 PM
|
0
|
0
|
1389
|
IDEA
|
In ArcGIS Online, it would be helpful if we could create feature layers with calculated fields. For example, if there is a CLASS field with the value 'A', I want to concatenate 'A' || 'B' as a CLASS_CONCAT field (value='AB'). And then serve that up as a dynamic feature layer for integration purposes (not a one-time thing). Thanks.
... View more
11-18-2021
07:18 AM
|
3
|
0
|
242
|
POST
|
In ArcGIS Online, is it possible to create a feature layer with calculated fields? For example, if there is a CLASS field with the value 'A', is there a way to dynamically concatenate 'A' || 'B' as a CLASS_CONCAT field (value='AB')? And then serve that up as a dynamic feature layer for integration purposes (not a one-time thing). I'm hoping it's possible to do that without the need to import into ArcGIS Enterprise as an intermediary step. Thanks.
... View more
11-18-2021
06:59 AM
|
0
|
1
|
555
|
IDEA
|
SampleServer6 is a handy testing tool when developing GIS integrations. Example: https://sampleserver6.arcgisonline.com/arcgis/rest/services/ServiceRequest/MapServer/1/query?where=1%3D1&outFields=*&f=pjson I wonder if ESRI could consider the following: Set up a few dummy pages/URLs that deliberately return error text. For errors like ERROR 400, 401, 403, 404, 500 As a novice, I was able to fake an ERROR 400 by putting a random 'x' in the URL: https://sampleserver6.arcgisonline.com/arcgis/rest/services/ServiceRequest/xMapServer/1/query?where=1%3D1&outFields=*&f=pjson But I don't know how I would test for other errors/scenarios. If we had some sample map service layers that returned errors...then that would be helpful for testing purposes when developing GIS integrations. Thanks.
... View more
11-13-2021
04:56 PM
|
1
|
0
|
1000
|
POST
|
Related: Musky's 5-Step Engineering Protocol: https://cleantechnica.com/2021/08/16/elon-musk-reveals-his-5-step-engineering-protocol/ 1. Make The Requirements Less Dumb “Step one: Make the requirements less dumb. The requirements are definitely dumb; it does not matter who gave them to you. It’s particularly dangerous when they come from an intelligent person, as you may not question them enough. Everyone’s wrong. No matter who you are, everyone is wrong some of the time. All designs are wrong, it’s just a matter of how wrong,” explains Musk. 2. Try And Delete Part Of The Process “Step two: try very hard to delete the part or process. If parts are not being added back into the design at least 10% of the time, [it means that] not enough parts are being deleted. The bias tends to be very strongly toward ‘let’s add this part or process step in case we need it’. Additionally, each required part and process must come from a name, not a department, as a department cannot be asked why a requirement exists, but a person can,” says Musk. 3. Simplify Or Optimize “Step three: simplify and optimize the design. This is the most common error of a smart engineer — to optimize something that should simply not exist,” according to Musk. He, himself, has been a victim of implementing these steps out of order. He refers to a “mental straightjacket” that happens in traditional schools where you always have to answer the question regardless of whether the premise makes any sense at all. 4. Optimize / Accelerate Cycle Time “Step four: accelerate cycle time. You’re moving too slowly, go faster! But don’t go faster until you’ve worked on the other three things first,” explains Musk. Here he uses another example of how these steps should occur in order. During a wrongheaded process you should simply stop, not accelerate. He says, “If you’re digging your grave, don’t dig it faster.” 5. Automate “The final step is: automate. An important part of this is to remove in-process testing after the problems have been diagnosed; if a product is reaching the end of a production line with a high acceptance rate, there is no need for in-process testing. I have personally made the mistake of going backwards on all five steps multiple times. In making Tesla’s Model 3, I literally automated, accelerated, simplified and then deleted,” says Musk. "Elon reveals the five steps he believes are essential to engineering something wholly new. What’s important, however, is that these five steps occur in precisely the order he lays out."
... View more
11-06-2021
01:54 PM
|
0
|
0
|
501
|
POST
|
A mechanic colleague mentioned his "3 rules for troubleshooting" the other day. I've found those rules useful for troubleshooting technical issues in general (including GIS issues). I thought I'd share: Try the easiest thing first. Is it plugged in? (and connected to the network) Turn it off and on again. Clear the data/cache. Check privileges. "Tested" is a lie. If someone says they tested something, assume they're wrong or lying. "It should work now" often means one bug might have been fixed, but two more were created. And no, it wasn't tested properly. 90% of issues are caused by operator error. What simple rules for troubleshooting do you use?
... View more
11-06-2021
11:10 AM
|
1
|
1
|
551
|
IDEA
|
It would be helpful if there were an OOB mechanism in ArcGIS Enterprise that made it easy to precompute a field in a FC on a schedule. For example, on a nightly basis, set up the geodatabase so that it updates a MIDPOINT field in a line feature class -- via a mechanism that is built right in to SDE. Make it so a power user (i.e. a Data Creator) could set this up, without needing to involve the DBA Don't require extra software like Notebook Server or FME Don't require setting up mechanisms like Oracle Scheduler or Windows Scheduled tasks on the server One of ArcGIS's biggest advantages is that it empowers everyday users to get their work done. We're not at the mercy of IT administration staff -- we can make progress without needing to wait for other software to be purchased/installed or mechanisms to be set up on a server. For example, as a Data Creator, I can create database views (and other database objects) on my own. I can actually solve my own problems using the Data Creator privileges! Fantastic! With that said, automation like precomputing a field on a schedule seems to be a gap in the ArcGIS Enterprise platform. I know there is some lightweight automation built in to Notebook Server that works for some specific use cases. But, it's not really practical to buy and implement Notebook Server just for one little piece of technology like scheduled notebooks (if anything, we'd buy FME, not Notebook Server for automation). It really seems like basic automation functionality should be built right in to ArcGIS enterprise. For example, in the work management industry, IBM is one of ESRI/CityWorks' main competitors. IBM's Maximo product has automation built right into the core product. It's called escalations -- and is extremely handy. Escalations can be used to automate anything, including precomputing fields and even emailing data-driven notifications via SMTP. And we can do all of that without a single line of code. That's an example where other companies have outperformed ESRI when it comes to automation. There are other examples too. Related: What levels of the ArcGIS Enterprise stack support scheduled jobs?
... View more
11-04-2021
10:54 AM
|
2
|
0
|
548
|
POST
|
What Oracle Spatial/SDO_Geometry books or resources can you recommend? Here are a few that I've found: Pro Oracle Spatial for Oracle Database 11g Various answers on GIS StackExchange posted by Albert Godfrind Also, check out the [Spatial] tag on Stack Overflow and DBA Stack Exchange Oracle Spatial and Graph: What’s New? Oracle Spatial Forum Are there any other resources you can recommend? (By the way, Oracle Spatial is now free with all versions of Oracle database.)
... View more
10-20-2021
06:21 PM
|
0
|
0
|
612
|
POST
|
A few other SQL data analysis books: Data Mining & Statistical Analysis Using SQL SQL for Data Scientists: A Beginner's Guide for Building Datasets for Analysis SQL for Data Science: Data Cleaning, Wrangling and Analytics with Relational Databases (Data-Centric Systems and Applications) Practical SQL: A Beginner's Guide to Storytelling with Data
... View more
10-20-2021
12:09 AM
|
2
|
0
|
1070
|
POST
|
What are some SQL data analysis books/resources that you like? 1. For example, I like the Profiling: Distributions and Profiling: Data Quality sections in this book: SQL for Data Analysis by Cathy Tanimura 2. When I was first learning SQL, I liked these books (they're clear and short): SQL by Ben Forta (generic SQL; 5th edition) Oracle PL/SQL by Ben Forta (1st edition) Microsoft SQL Server T-SQL (2nd edition) 3. And these video courses cover advanced SQL topics like window functions: Advanced SQL Queries in Oracle and SQL Server by Scott Hecht; PluralSight video course SQL Data Wrangling in Oracle by Scott Hecht; PluralSight video course Are there any others you would suggest?
... View more
10-18-2021
10:06 PM
|
2
|
1
|
1127
|
IDEA
|
Oracle: It would be really helpful if we could get a function in ST_Geometry that would let us select the vertices of a feature as rows. Oracle’s SDO_Geometry has a function called GetVertices. It is extremely handy. https://docs.oracle.com/en/database/oracle/oracle-database/21/spatl/SDO_UTIL-reference.html#GUID-9CF1E8A9-EBCB-4938-BBB6-C2AAFE4897A7 We need to be able to easily access ST_Geometry feature vertices using SQL -- without using clunky workarounds like cross joins or custom types/functions.
... View more
09-18-2021
09:19 PM
|
0
|
0
|
638
|
POST
|
What levels of the ArcGIS Enterprise stack support (or don't support) scheduled jobs? Y - GIS server operating system (example: Windows scheduled tasks, SDE connection, and ArcPy script) Y - Database (example: Oracle scheduler; making use of spatial datatypes & functions) N - ArcGIS Server N - ArcGIS Portal Y - ArcGIS Notebook Server Y - 3rd party applications (example: FME) Types of GIS scheduled jobs: Precompute calculated fields or entire tables Scheduled queries and reports --> email results via SMTP What are our options? Is the above list correct? Thanks.
... View more
08-27-2021
05:18 AM
|
0
|
1
|
894
|
POST
|
ArcGIS Enterprise; Oracle I want to set up a scheduled report based on Oracle GDB data: The report/task would run weekly and would be emailed to a list of recipients (via an SMTP server) The filetype could be anything (PDF, excel, or just a table in an email). The important part is that people get notified of records in a resultset by email — so that they can follow-up as needed. The report would be emailed out if the resultset/count meets certain conditions (i.e. send the report if the resultset has >0 records). Question: Are there any mechanisms in ArcGIS Enterprise that would allow users to create and manage scheduled reports?
... View more
05-06-2021
07:03 AM
|
0
|
1
|
927
|
POST
|
Is it possible to send scheduled/emailed reports via ArcGIS Notebook Server scheduled tasks? An example of a scheduled report would be: Report/task runs weekly Emailed to a list of recipients (via an STMP server) The report filetype could be anything; the important part is that people get notified of records in a resultset by email — so that they can follow-up as needed. The report would be emailed out if the resultset/count meets certain conditions (i.e. send the report if the resultset has >0 records).
... View more
05-06-2021
06:55 AM
|
0
|
1
|
983
|
IDEA
|
It would be helpful if a timestamp column could be added to the SDE.GDB_ITEMS table (Oracle). Reason: So we can know when a GDB item, such as a domain, was last updated. Example: For integrations to external systems, we need to know if any domain descriptions have been changed, so that we can re-sync the data to the external system. Currently, there is no way to know if/when the values in a domain have been changed. Thank you.
... View more
02-15-2021
06:45 PM
|
2
|
0
|
762
|
Title | Kudos | Posted |
---|---|---|
1 | 05-10-2024 10:22 PM | |
1 | 05-22-2024 10:21 PM | |
1 | 06-12-2024 06:39 AM | |
3 | Friday | |
1 | 04-04-2024 11:08 AM |