Latest Contributions by TanuHoque

@LouiePang  You should be able to publish as a map service on your ArcGIS Server, and consume that as a map image layer in your webmap/app. But I doubt if you can add that as a feature layer in your app and do edits. ... View more

@ahargreaves_FW  Are you saying that, in this scenario, I should NOT publish the associated Feature Service with my (referenced) Vector tile service and rely on the Map Service for query capability? I'm not an expert in vector tile/basemap workflow. Therefore I can't comment on your workflow. I was simply trying to reply to your original query where you asked why a map service is needed instead of a feature service (as mentioned in the help), and you thought that would cause some unnecessary burden on your machine resources. I hope that I was able to state it clearly that it doesn't need any additional resources and puts no additional burdens on your machine compare to an enterprise feature service. If your workflow requires editing capability via web app, then you have to have feature service. I didn't say you should not. I'm sorry if it came out that way. In enterprise setup, as you know and I mentioned previously, a feature service is an extension of a map service. You can't have an enterprise feature service without a map service. Hosted feature services are different, as you know, they don't require map services but you need to publish it by copying data on your server managed data store. ... View more

I'm glad that it worked. Just for folks who might come across this post in future. The suggestion that @StevenBowden mentioned would work as well. This is the one I briefly mentioned in my very comment with 'sql windowing function'. The difference between these two solutions are (as far as I can think of😞 The windowing function gives you unique (mostly sequential and without any gaps) id. FYI: sql windowing functions are very powerful and provides a lot of advanced capabilities That said, you might perform slower especially while processing a lot of records. I believe indexing fields used in ORDER BY clause would help also the field(s) you are using in the ORDER BY clause can't produce unique identifier for each row, then you row_number() might not deterministic especially with rows with same values. whereas, the option that provided is brain-dead simple, but you might run into some gaps in objectid... also i don't see any issue in performance   ... View more

Thanks @ahargreaves_FW  Please note, this is the case where we are talking about 'using data by reference off a registered database'. Since data don't get copied (and there is no need) in this case, the hosted feature service is not an option to begin with. Now, the enterprise feature service that you are talking about is technically an extension of a map service. Therefore, a map service will always get created, and feature service extension gets enabled off it. When you don't have any editing workflow (which is case in here), there are no reasons for enabling feature service extension. That is extra. Both map and feature service are on par when it comes to query functionalities. Added benefit with map service, as you know, is that now you should be able to use file geodatabase or other workspace type that are not supported by feature services in general. Lastly and the most important point (as I was reminded by @GarimaTiwari) - map services are not burdening your server resources as they get published as shared instances. Please let me know if you have any question. We hope you find this helpful. ... View more

@ahargreaves_FW  are you asking about this part of the doc? If your active portal is an ArcGIS Enterprise portal and you want the vector tile to reference registered data sources, click Vector Tile under Reference registered data. A map image layer and web feature layer are automatically included when referencing registered data. ... View more

@MarcusVowell_Uniti  As @jcarlson said above, you can also use query layer if you want. Query layer can have parameters too. And that is how you can update values in a where clause without re-create (or updating the source of) the query layer. See screenshots below. As you know these queries can be very complex. Here is the help on query layer parameters. https://pro.arcgis.com/en/pro-app/latest/help/mapping/layer-properties/define-parameters-in-a-query-layer.htm  TanuHoque_0-1648845874811.png TanuHoque_1-1648845880451.png   ... View more

@MarcusVowell_Uniti  Many of the databases we use have a chain of foreign keys that need to be used to select the right subset of data. In fact, what I would dearly love to see is the ability to utilize nested SELECT statements in the WHERE clause: SELECT * FROM cable WHERE ownership NOT IN (SELECT id FROM owner WHERE status = 'Inactive') But I know that's probably a long shot. Just being able to consider more than one table in a SELECT criteria would be fantastic. Technically you can do it today. We do not have any UI that allows you to construct that kind of where clause with subqueries but you can simply switch to the SQL mode and write your sql in there. Here is a screenshot where I selected airports that has runways (in a separate table) longer than or equal to 10,000 ft. TanuHoque_0-1648836013529.png Of course, you use do the same in the Definition Query page to filter them out instead of selecting them.   There are two version of the sql I'm providing here:   -- option#1 exists (select 1 from AIRPORT_RUNWAYS r where r.LENGTH >= 10000 and AIRPORT_FACILITY.FKOBJECTID = r.FKOBJECTID) -- option#2 FKOBJECTID in (select FKOBJECTID from AIRPORT_RUNWAYS r where r.LENGTH >= 10000)   ... View more

Thanks @BruceHarold and @MarcusVowell_Uniti for providing clarifications. They are very helpful.   ... View more

Good point. Thanks for your suggestion, we will revisit that article. ... View more

@BrianFausel  I tried attribute rotation too and that worked for me as well. No rush, please give the newer version a try when you get a chance and let us know what you find. TanuHoque_0-1648655440637.png TanuHoque_1-1648655447203.png   ... View more

hi @Nathan_A_Wood  Even though, the Catalog pane does not list raster layers when you drill into a map service, but you can use Add Data from Path command and paste the url pointing to the raster layer off a map service and you will add a map service layer (aka map image layer) containing just one layer in it. please let me know if it doesn't work for you or you have any suggestions. Thanks NB: you can also share your map as a webmap and it should work when you open that in map viewer. That said, I don't think you can directly add a raster layer in Map Viewer the way we allow it in Pro TanuHoque_0-1648058876242.png TanuHoque_1-1648059594361.png   ... View more