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'

Related 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.

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'

Related 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.