LGIM wHydrant/wHydrantInspection Relationship

1154
1
08-03-2016 10:42 AM
KalenMyers
New Contributor III

Hi there,

I'm in the process of migrating data into the Local Government Information Model. I'm currently working on hydrant data and identified wHydrant and wHydrantInspection as two feature classes I need to populate/append. My question is: how are these two feature classes related? I don't see a relationship class between the two in the LGIM yet it appears as if the OPERABLE and LASTSERVICE fields in wHydrant should link to updates from the wHydrantInspection layer. Has anyone using the LGIM and tracking hydrant maintenance come across this issue?

Thanks in advance for feedback!

-Kalen

0 Kudos
1 Reply
NorthPark
New Contributor III

I am in the process of implementing the LGIM with some modifications and I am planning to set up the same kind of relationships for a number of tracking log tables. For example, a Hydrant Service Log that will update a field in the hydrant layer as part of adding a new record to the table. Looking forward to see how others have implemented something like this. This schema change has been a great exercise in really thinking through my data model and coming up with ways of making much more use of other non spatial tables to cut down on data duplication by using relates.