I have a shapefile that contains property information such as deed holder, physical address, etc. Is there a way to bring that shapefile in and assign one or more of the attributes of the shape file to the customer meter ID or label? Currently CU-## is auto generated but to make it more easily understood is there a way to personalize it so to speak. Thanks!
Joeri's suggestion could work but ModelBuilder now has spatial join capability built in. You'll just need to convert the polygon to a point first.
Regards,
Jesse DringoliTechnical Support Manager, OpenFlowsBentley Communities Site AdministratorBentley Systems, Inc.
What you might try is:
1. Export all customer meters from WaterGEMS using a flextable export to shapefile (make sure to include the current CU-xxx labels).
2. In ArcGIS create a Spatial Join on the exported customer meter shapefile to the property polygon shapefile, this creates a shapefile/table which contains both the CU-xxx label and any information included in the polygon in which it is located.
3. Use this table/shapefile in WaterGEMS modelbuilder to assign, for example, GIS-ID's to each customer meter (using the original CU-xxx labels as the linking variable between the shapefile and the model). You could also bring in any additional information of the property polygons in this way.
I will play around and get back to you. I obtain the file from our county GIS system and I know we are working in the same coordinate system. I will just have to try and figure out how to convert to point data and bring in.
I should add that this method may not necessarily work well if the centroid of the polygon is not always closest to the correct customer meter, or if there are multiple customer meters within the polygon and you want all of them to get the same information. If that is the case, a few screenshots or illustrations of some of the situations you're encountering may help us determine other possible solutions.
That is why you need to convert the polygon to point first, because customer meters are point features and pump stations are the only polygon feature. This can be accomplished with ArcGIS