Latest Contributions by JoeBryant1

To clarify what Jake is saying for anyone else who finds themselves here: ArcGIS Online accounts assigned the 'Data Editor'  role cannot export layers, because they cannot create new items. Administrators must upgrade users to the 'Publisher' role in order for them to be able to see the Export Files button. * And, yes, this is not intuitive, since the Data Editor role is listed below Administrator and above Publisher in the Roles drop down. Upon closer inspection, this appears to be an alphabetical ordering, and not the hierarchy it implies. ... View more

If I'm interpreting this correctly, the "Media Folder" would be defining a root location on a server within which all CCTV videos are located, and the use of the "Video Location" field would allow separate CCTV inspection projects to be loaded to the this root location within sub-folders? If this is the case, then I agree with Jose - define the path using both. I think this would provide the most flexibility to keep the various video projects organized over time on the server. But I'm curious to see what some other experienced CCTV project manager may prefer. For instance, would this make sharing or exporting the feature class with embedded links to the video more difficult on other platforms or web applications (since the full path would not be included in the Video Location field)? ... View more

FYI: This is now an official bug - #BUG-000129778 Make Query Table tool does not allow clause mode editing of SQL expression parameter. ... View more

Updates: #BUG-000129778 Make Query Table tool does not allow clause mode editing of SQL expression parameter and #BUG-000129607 Add join does not correctly honor definition query on join table ... View more

Bueller? ... Anybody? Should I add this to the "Ideas" forum? ... View more

Thanks Shana. I’ve decided NOT to change the default. Instead, I’ll educate our users on where to find this setting when appropriate. Joe Bryant GIS Coordinator WEST YOST ASSOCIATES direct 530.761.0226 Cell: 916-833-5840 ... View more

Thanks for clarifying, Joshua. I did some tests and found that both "date" and "timestamp" run successfully in the Make Query Table tool. However, only the word "timestamp" auto-completes in blue in the SQL query dialog box; "date" does not. I'm not sure why, but it must have some indication of what's going on behind the scenes in the software.   Dragging the tool history into Model Builder also runs fine inside Model Builder, with no warnings, in Clause and SQL query modes. However, when I save the model and open it as a GP Tool, I get an error saying "Internal Error initializing expression." If I try to switch from SQL to Clause mode, I get a warning that "the source layer or table is not valid". This is with the input layer hard-coded into the tool, not set as a parameter. This definitely backs up your assertion that this is a combination Model Builder / Make Query Table error, and has nothing to do with the data type keyword. ... View more

Hi Ulf, I'm also having problems using the Make Query Table tool in Pro's Model Builder. I did not import this model from Arc, but am building it from scratch. Basically, I want to be able to make the query a parameter of the tool, so users can select a certain date subset of data to use. The tool will run fine the first time in Model Builder, but after saving I can no longer change the expression using a parameter variable. I get the the "can't be edited in Clause mode" warning you mentioned, as well as an error about the expression not being able to be initialized. It looks like this is because the Clause is populated be the input data set choices, and the Model doesn't have access to this information until the process starts running, so there is no way to construct the parameter beforehand. I'm researching it further and trying different methods. Frustratingly, the only reason I'm using this tool is because the Add Join tool does not honor the layer properties definition query on tables the way it did in ArcMap, so I have to use Make Query Table first. I currently have a case with ESRI Support to get this other bug documented (and maybe fixed?). I'll let you know what I find, but wanted to 'bump' this thread in case others are also struggling with this tool. ... View more

Hi Shana, I'm considering pushing out "Method 2: Permanently set the 'Match with no zones' default setting to Yes/True" to my entire organization's address locator install files. We contract with lots of utilities in the US, and the address data we are supplied often does not have zip codes. It looks like you never found your old forum post. Could you briefly explain we we wouldn't want to set the default to 'true'? There must be a compelling reason, since ESRI did not change this setting after it introduced problems way back in 10.1. ... View more

Thanks James! That absolutely worked! It was also a lot more difficult than I expected. I'll have to save that function as I doubt I could write it from scratch. ... View more

Thanks for sharing this "hack", Brian. I imagine that as Gregg points out below, this re-indexes the Global ID field for the layer with attachments enabled. But unlike Gregg, we don't have access to the RDBMS behind the scenes in an ArcGIS Online hosted feature service. FYI: Your method worked for me only after I disabled/enabled attachments for every layer in the feature service. I also attempted to update the service definition by editing the JSON at the rest/admin/service endpoint (accessed by inserting "/admin" between "/rest" and "/service" in the service URL). Just changing "supportsApplyEditsWithGlobalIds" : to "true" did not stick. Re-indexing the Global ID fields seems to be required. I'm not sure if there is method to do this using the API other than the disable/enable workflow you found. Maybe someone else with more developer skills can enlighten us. This would be the preferable method so that we don't lose any current attachments in the re-indexing process. ... View more

This would be soooooo much more useful. I would up-vote twice if I could! ... View more