The Finance Department requested an easier way to get the address data from City owned structures after weather related storm damage occurs. Not every City owned structure has an address. Therefore, site/parcel addresses were used instead. The goal will be to select the damaged structures, view them in a table and be able to export them to a .csv. The Datasets used from the WebRead106 database connection are SDE.DBO.Addresses, SDE.DBO.Structures, and SDE.DBO.Transportation. The feature classes are SDE.DBO.adCity, SDE.DBO.stBuilding and SDE.DBO.trCountyCenterline.

The ownership of County transportation centerlines belongs to Campbell County. The City does not have a separate service in ArcGIS Portal for it because of that. However, there is a need to see County transportation centerlines for the City owned structures outside of City Limits. For that reason, the County transportation centerlines is included in the. aprx.

This service has numerous types over many fields. Please refer to the data to find the appropriate information.

Important fields in the service include, but are not limited to, Municipality Name, Full Address, State Abbreviation, GIS Comment, Subtype Code, Location ID, Location Description, House Number, House Number Suffix, Street Name, Unit Name, Street Pre-Direction, Street Type, Unit Type, and Zipcode 5-digit, Residential Building Type, Number of Floors (including a basement), Munis Code, Is Primary?, Dwelling Count, Year Constructed, Number of Stories (above the ground), General Zoning, Subtype Code, and a Building Footprint Area along with ArcGIS standard fields.

Some Feature Classes have definition queries assigned:

City Addresses = LIFECYCLE = 'Active' And MUNISF7 = 'CITY'

Structure Buildings = LIFECYCLE = 'Active' And (ADMIN = 'City' Or MAINT IN ('Electrical', 'Facility', 'Parks', 'SCADA', 'Signs', 'Solid', 'Streets', 'Waste', 'Water'))

Transportation County Centerlines = SOURCEENTITY = 'CRGIS'

Relate tables are associated with these Feature Classes:

Structure Buildings = SDE.DBO.stBuildingHasstImages

Structure Buildings = SDE.DBO.stBuildingHasstVacant

There are no Database Views associated with this service.

This service may include information regarding when data was acquired or created. Refer to the Source fields: Source Entity, Source Type and Source Date. To identify information regarding when data was last updated refer to the Last field: Last Update Date. It may include a Lifecycle field that can potentially contain abandoned, active, inactive, proposed, possible, and/or removed features. Additional information regarding the feature class name feature class can be found within the table, table name and uses the relationship class relationship class name. Some services have database views as well, and a service can have many types in it. For more information, please contact the City of Gillette GIS Division at (307) 686-5364 or gisadmin@gillettewy.gov.

The Finance Department requested an easier way to get the address data from City owned structures after weather related storm damage occurs. Not every City owned structure has an address. Therefore, site/parcel addresses were used instead. The goal will be to select the damaged structures, view them in a table and be able to export them to a .csv. The Datasets used from the WebRead106 database connection are SDE.DBO.Addresses, SDE.DBO.Structures, and SDE.DBO.Transportation. The feature classes are SDE.DBO.adCity, SDE.DBO.stBuilding and SDE.DBO.trCountyCenterline.

The ownership of County transportation centerlines belongs to Campbell County. The City does not have a separate service in ArcGIS Portal for it because of that. However, there is a need to see County transportation centerlines for the City owned structures outside of City Limits. For that reason, the County transportation centerlines is included in the. aprx.

This service has numerous types over many fields. Please refer to the data to find the appropriate information.

Important fields in the service include, but are not limited to, Municipality Name, Full Address, State Abbreviation, GIS Comment, Subtype Code, Location ID, Location Description, House Number, House Number Suffix, Street Name, Unit Name, Street Pre-Direction, Street Type, Unit Type, and Zipcode 5-digit, Residential Building Type, Number of Floors (including a basement), Munis Code, Is Primary?, Dwelling Count, Year Constructed, Number of Stories (above the ground), General Zoning, Subtype Code, and a Building Footprint Area along with ArcGIS standard fields.

Some Feature Classes have definition queries assigned:

City Addresses = LIFECYCLE = 'Active' And MUNISF7 = 'CITY'

Structure Buildings = LIFECYCLE = 'Active' And (ADMIN = 'City' Or MAINT IN ('Electrical', 'Facility', 'Parks', 'SCADA', 'Signs', 'Solid', 'Streets', 'Waste', 'Water'))

Transportation County Centerlines = SOURCEENTITY = 'CRGIS'

Relate tables are associated with these Feature Classes:

Structure Buildings = SDE.DBO.stBuildingHasstImages

Structure Buildings = SDE.DBO.stBuildingHasstVacant

There are no Database Views associated with this service.

This service may include information regarding when data was acquired or created. Refer to the Source fields: Source Entity, Source Type and Source Date. To identify information regarding when data was last updated refer to the Last field: Last Update Date. It may include a Lifecycle field that can potentially contain abandoned, active, inactive, proposed, possible, and/or removed features. Additional information regarding the feature class name feature class can be found within the table, table name and uses the relationship class relationship class name. Some services have database views as well, and a service can have many types in it. For more information, please contact the City of Gillette GIS Division at (307) 686-5364 or gisadmin@gillettewy.gov.