topic Re: How do you organize your City data? in State & Local Government Questions

How do you organize your City data?

AngelaVanderpas1 — Mon, 04 Feb 2019 21:38:49 GMT

I am looking for sample geodatabase schemas for Cities. I am reorganizing our gis data as we move to enterprise. I haven't found any documentation with suggested organization. I have looked at the local government information model, but this doesn't work. It is difficult to work with and manage data when it is contained in one geodatabase. I am considering using workflow and data reviewer so I know there are some considerations for these.

Below are some questions for those that manage City data:

What feature classes are considered authoritative for Cities? I have seen lists for States but nothing for Cities. Or I am looking in the wrong place.

Do you use separate geodatabases for different functions ie. water, wastewater, parks and rec, fire, police?

In your geodatabases do you use feature datasets?

How do you manage reference data? Do you push it to portal?

Do you use a staging server and a production server?

I am very interested in snapshots of how your data is organized.

thanks

Re: How do you organize your City data?

DanNewcomb2 — Mon, 09 Sep 2019 18:55:55 GMT

Did you find a path forward? I just saw this, and would be happy to share my schema. I hated the localgov model, so I created my own. How things are organized could depend on what your main data silos are, though, along with how they are used.

Re: How do you organize your City data?

AngelaVanderpas1 — Mon, 09 Sep 2019 21:44:12 GMT

Dan,

I punted. I thought this might a question that a lot of us are struggling with - not so much. I also didn't like the local government model. If I have do any thing to one area of data it affects everything. What I ended up doing is geodatabases per division ie public works, community development and also utilities ie water, wastewater, stormwater, transportation. They all sit on the same server and instance of sql. I don't do replication or currently have a test site. I need get that up and testing. Secondary programs that attach limit how that can work. I am including a screenshot of how I set it up. Now I would like to work on creating some basic data schemas to share with folks that are in cities - seems to be a big hole. I also included a screenshot of wastewater - the Assets and AssetsNz are for grouping those assets that are z and m aware and are used with an arrow receiver for high accuracy data collection in collector. And so that I can set up some topologies for QA/QC

Re: How do you organize your City data?

AngelaVanderpas1 — Wed, 11 Sep 2019 23:41:02 GMT

Yes, I would like to see your organizational structure.

Re: How do you organize your City data?

SilasDaniel — Mon, 01 Feb 2021 15:02:39 GMT

Not sure if you are still active on these forums, but if so, I'd love to see your schema if you are still willing to share it. We are working on transitioning from a veritable ocean of shapefiles to something hopefully more organized and easier to manage.