Latest Contributions by RPGIS

Hi @IsaacFuller, In pro, there is an option where you have the ability to join either as a one to one or as a one to many such that, if there are multiple records with the same field, then you can join the larger of the datasets with the smaller one and a single joined record will be created for every duplicate row with that exact id. If it is a true one to one but the polygons have some manner of overlap then a spatial join might be best. You can also use the join features tool to join the two datasets. ... View more

Hi @AJR, So when it comes to displaying large datasets where you simply want to view a small subset of that dataset, then I would highly recommend creating a query layer so that it only pulls records based on what parameters you set and it can also limit the number of records that get returned. A query layer, if you don't know, can directly access a database table and pull records using a SQL query rather than trying to connect to the database and read the records in pro. Just a suggestion. ... View more

Hi Matt, An option that you can try is using linear referencing to pick an approximate location rather than using an address. It works similar to addressing but will locate using a specified distance along a route using the address number rather than a full address. You can build that as part of the addressing so that locations can be identified at set intervals along routes. ... View more

As @KenBuja has mentioned, It isn't atypical for arcade to pull the first record which makes testing difficult. Try Filtering for any other record to see if you get the same result. If not then that points to the fact that the first record simply either exists outside of the image(ry) and cannot get the pixel value or it is something else. ... View more

You could simply create a dummy hosted service for the sole purpose of using it as a markup layer. We have done that from time to time and it also helps that we can download that layer if needed for other things. ... View more

Hi @wizgis, So one of the many recommendations, especially when it comes to having multiple layers, is to have the layers published separately rather than all at once. The reasoning behind that is there might be some layers that are more intensive processing wise than others which could potentially consume more resources. The other things to check are: Drawing scale: Some layers drawn at higher extents will consume more resources than those drawn at lower extents. Sample Records or Maximum Return Records: This will determine how many records will be read and displayed by the server and the higher this number is the more resources will get consumed. Coded domains: If there are not many coded domains then try diminishing the count. Tile service: Try publishing a tile service vs a regular map service since tile services typically render faster since the pyramids are manually created using the data rather than dynamically. Try the options above and see if that improves the performance of your map services. ... View more

I think the erase tool may help to some extent also. That might indicate which one is not the duplicate but I would need to test that. Another option is to run the frequency tool on both datasets and do a comparison that way. Otherwise, assuming the addresses have matching values, @DanPatterson recommendation would be best. ... View more

Hi @MarkChambers1, I personally have never used Monitor before but I did some simple calculations and the only thing that I can think of is that Monitor may be looking at the different view states whereas your sql table might be the base table. Try comparing the total number of records the sql table but look under views and see if those record totals match what Monitor is looking at. We look at the view table rather than the base table to see how many active records exist before the base table is updated. ... View more

Hi @RemWilson, Have you tried using any of the options below: Using an arcade field calculation to generate the necessary polygons. This may work for some features but if there are any records that lack any geometry then that could also return an error. Running python to generate the polygons. The other thing I would recommend checking is if there might be some slight change in the permissions since this can also cause some minor issues at times. ... View more

Hi @JuliaReisemann_3J  Is your data hosted because, as unfortunate as this might seem, it isn't unusual for hosted services to have some minor corruption. There isn't really a fix for that but if there is calculated geometry information that can referenced or scraped then that might be the only fix. ... View more

Hi @TinaKwitkoski, So there a couple of things to check: The full extent. It might be possible that some are not drawing given that either the feature layer drawing might be set too low so that only a handful are showing. The extent in the tool may have been manually set which could be why some are not showing. Try updating that to see if that fixes the issues. It might be that some of the attributes are not populated so that could be it also. Is there a definition query on a layer. Check those and if that doesn't fix your issue then it might be something else. ... View more

Thank you very much @MDB_GIS, I will be sure to test this out and see how this works to align with our CAD coordinate system since that has been somewhat of a boondoggle.  ... View more

You can also use the following: vr G = Geometry($feature) ; var Paths = G.paths: for( var p in Paths ){ var lastpnt = p[-1] ; console(lastpnt ) } ... View more

Yes. Simply because tenants may vary but generally the building will have similar utilities and safety requirements. We have it setup so the building will primarily house anything regarding safety but the tenants will have their own unique attributes. Both the building footprint and tenant table schemas are nearly identical. This is to identify if a building is the same as a tenant or if it houses multiple tenants. It also keeps the data clean and easily configurable. The other thing to consider is, as tenants are vacated in multi-tenant buildings, then that may impact other workflows such as addressing, billing, etc. We are working to create a dynamic addressing system so that instead of maintaining points, instead we will use a tool that will derive the information from the attributes and construct temporary address points. ... View more

We had this exact conversation since I had been tasked with overhauling our preplan solution. We tried using the Esri solution, but that solution will only work if: You have clean data to work with or are starting from scratch You are not having to consolidate several datasets into a single working dataset The addresses, buildings, and anything else is updated in a timely manner The workflow we created is we built ours in house in our enterprise sde and are using the building footprints as the base working feature and have it setup in this manner: Building Feature/Footprint (polygon fc) Property Table The table is related to the building feature using a single numerical field The relationship created is a one to one Tenant Table The table is related to the building using the building id as the relational field The relationship to the building is a one to many ... View more