The Finance Department requested an easier way to retrieve City owned and/or maintained structures and addresses after weather related damage occurred. Most structures have an address attached to them now. If the damage occurred to a fence or irrigation asset, then the site address would be used for the claim.

The structures can be highlighted, viewed in a table, and then exported to a .csv.

The Feature Dataset used from the WebEdit106 database connection is SDE.DBO.Structures. The Feature Class is SDE.DBO.stBuilding. Also included in the service is the SDE.DBO.trCountyCenterline Feature Class from the SDE.DBO.Transportation dataset. County transportation lines are included in the service so that the user can view the roads near the Madison well stations. Transportation is not editable.

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 Campbell and Crook County transportation centerlines are 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, Local Name, Roof Repair Warranty Expiration, Roof Construction Warranty Expiration, Insurance Number, Finance Comment, 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:

Structure Buildings: LIFECYCLE = 'Active' And ISCITY = 'CITY'

Transportation County Centerlines: LIFECYCLE = 'Active' And SOURCEENTITY IN ('CRGIS', 'CCGIS')

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 retrieve City owned and/or maintained structures and addresses after weather related damage occurred. Most structures have an address attached to them. If the damage occurs to a fence or irrigation asset, then the site address would be used for the claim.

The structures can be highlighted, viewed in a table, and then exported to a .csv.

The Feature Dataset from the WebEdit106 database connection is SDE.DBO.Structures. The Feature Class is SDE.DBO.stBuilding.

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, Local Name, Roof Repair Warranty Expiration, Roof Construction Warranty Expiration, Insurance Number, Finance Comment, Municipality Name, Full Address, State Abbreviation, GIS Comment, Subtype Code, Location ID, Location Description, along with ArcGIS standard fields.

Some Feature Classes have definition queries assigned:

Structure Buildings: LIFECYCLE = 'Active' And ISCITY = 'CITY'

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 City of Gillette GIS at (307) 686-5364 or gisadmin@gillettewy.gov.