2018-11-19_Att1-BPP_Data_Elements-VT_4_LPOEs.docx

DOCX document 717 KB Posted

Attached to
Historical Preservation Plan for the Beecher, Canaan, East Richford, and Richford VT Land Ports of Entry
Solicitation number
47PB0019Q0003
Issued by

About this file

Attachment 1 BPP Data Elements

View the file

Other files

On GovTribe

Work with this file

  • Download the original file
  • Contacts named in this file
  • Similar government files
  • Ask GovTribe AI about this file

Text version

GSA New England Region 1 VT - Beecher Falls LPOE, VT – Canaan LPOE, VT – East Richford LPOE and VT – Richford LPOE Building Preservation Plan November 19, 2018 Attachment 1 – BPP Requirements Chart

Attachment 1 – BPP REQUIREMENTS CHART

Preamble More than one fourth of GSA’s 1,600 owned buildings are listed in or eligible for the National Register of Historic Places, the nation’s listing of historic properties, and approximately half of these are more than fifty years old. The National Historic Preservation Act of 1966, as well as an array of executive orders, compels PBS to properly perform and maintain preservation plans and to promptly respond to sundry inquiries regarding the historic properties within its portfolio.

GSA’s Center for Historic Buildings requires a technical solution that will allow or otherwise enable contractors (i.e. preservation architects and/or specialists) to efficiently and effectively perform preservation surveys and assessments at federal, historically designated properties; collect and/or create all (or most) documentation on-site; and then either enter or upload same into a “tool” accessible outside the GSA firewall.

The tool that is presently being utilized to accommodate the development and maintenance of historic preservation plans is called Building Preservation Plan (BPP); however, this tool has proved to be so inadequate that some regional preservation officers have ceased to use it to capture and maintain preservation plans. An antiquated IT asset, BPP has had no major enhancement or modernization in over ten years. The Classic ASP technology on which the application is built (released by Microsoft in the mid-1990s) is no longer supported and as a result BPP has become susceptible to a multitude of security vulnerabilities that render it noncompliant with NIST[footnoteRef:1] policies and controls. [1: National Institute of Science and Technology]

Center for Historic Buildings’ Business Need The following identifies and defines eleven (11) components of an historic preservation plan, each of which records or otherwise documents aspects of a designated property[footnoteRef:2]. [2: These components were developed by National Institute of Building Sciences for GSA as templates reflecting industry standard and/or best practices. ]

System Interconnections At minimum building data residing in the system of record (REXUS[footnoteRef:3]) shall be incorporated via BI[footnoteRef:4]. [3: Real Estate Across the United States] [4: Business Intelligence (data warehouse)]

User Roles

1. PBS portal users shall default to Read Only role that will enable the user to view all content without the ability to write to the record.

2. Regional Administrator role enables the user to assign buildings within a designated region to a user for data entry.

3. System Administrator role, similar to its regional variant, enables the user to assign buildings in any region to a user for data entry; additionally, this user may archive selected buildings.

4. Data Entry role enables the user to write to the record (aka creating a preservation plan) for an assigned building or buildings. All (or most) data entry will occur outside the GSA firewall (and is presently facilitated through Citrix).

Document Management Regardless of file format (e.g. .png, .jpeg, .pdf, .doc, .xls, et al.[footnoteRef:5]) documents or files may be uploaded to the system or tool in batches (as opposed to being limited to uploading one file at a time). Documents and/or images may be opened within the tool and viewed or may be download and saved externally. [5: With the exception of .gif file format, which shall be excluded systematically]

Archiving The tool will enable a user with System Administrator privileges to archive selected buildings to a compartmentalized area in the event of disposal, re-designation, etc.

Reports Regardless of type, e.g. Inspections, Images, etc., all reporting will be generated through BI Framework.

GSA.gov Interface Presently updates within BPP are exported to the Historic Buildings page at GSA.gov (http://www.gsa.gov/portal/ext/html/site/hb/category/25431/hostUri/portal) on a monthly basis. The Collaboration Branch (Web and Content Management team) manipulates this data to accommodate the GSA.gov user interface. While such manipulations occur outside the purview of PB-ITS it remains relevant when evaluating the requirements below and in formulating an associated technical solution.

Preservation Plan Components and Subcomponents

Building Information
Building History
Historic Designation
Inspections
Architectural Description
Physical History
Integrity and Significance
Zones
Elements and Materials
Images
Documents and References
General
Construction or Alteration
National Register
Inspection 1
Narrative
Narrative
Narrative
Coordinates
Function or Use
GSA Determination
Inspection 2
Attributes
Name
State or Local Designation
Inspection 3

Inspection 4

Data Elements to Satisfy Center for Historic Buildings Preservation Plan Needs Building Information

Attribute
Source
Data Element
Field Type
Definition
Comments
1
General
BPP[footnoteRef:6] [6: The REXUS Location Name field is limited to 60 characters and typically (based on a large sample performed by Center staff) reflects truncated, inconsistently abbreviated, or simply incorrect building name. For this reason the Current Building Name field in BPP is the most accurate source record at GSA and reflects the legal and public name of the historic property. This field should accommodate 100 characters. (The REXUS team was not able to accommodate any database change to correct said limitation.)]
Building Name
Text
Current Building Name
2
General
REXUS
Building Number
Unknown
Location Code
3
General
NEW[footnoteRef:7] [7: Or rather, amended: Heating Plant, Training Facility, Dining Hall, Gymnasium, and Dormitory must be added to existing BPP drop-down values ]
Type
Drop-down
Building Type
To include the following: Courthouse (CT); Custom House (CU); Post Office (PO); CT/CU; PO/CU; PO/CT; FB/PO/CT; CU/Office Building; CT/Office Building; PO/Office Building; Office Building; Federal Center; Record Center; Warehouse; Border Station; Immigration Station; Hospital; Quarantine Station; Laboratory; Residence; Garage; Heating Plant; Training Facility; Dining Hall; Gymnasium; Dormitory; and Other.
4
General
BPP
Status
Drop-down
Building Status
To include the following: Leased; Owned; and Disposed (per NIBS); however, the following resides in BPP:
5
General
REXUS
Building Address
Text; Drop-down (City and County)
Street Address, Address 2, City, County, ZIP Code
State field appears to be pre-populated
6
General
REXUS
Region
Drop-down
Region
7
General
NEW
Complex Name
Text
NA
8
General
NEW
Complex Map
Submit Button
Graphical representation of address
Utilizing the building address from REXUS this selection will launch a new window and display the location in Google maps.
9
General
NEW
Complex Aerial
Submit Button
Graphical representation of address
Utilizing the building address from REXUS this selection will launch a new window and display an aerial view via Google maps (see below).
10
General
NEW
HABS/HAER/HALS[footnoteRef:8] Identification [8: Historic American Building Survey, Historic American Engineering Record, Historic American Landscape Survey]
Alpha-numeric
NA
These values are not imported; rather, they will be entered by the user.
11
General
BPP
Location Description
Text
NA
Under Architectural Description Note: This is a new text field as per the LOB/SME (06/26/2015)
12
Coordinates
BPP
UTM[footnoteRef:9] Northing [9: Universal Transverse Mercator]
Numeric
Northing
13
Coordinates
BPP
UTM Easting
Numeric
Easting
14
Coordinates
REXUS
GIS Latitude
Numeric
Latitude
Latitude for building; located as a pre-filled cell at Building Address Information:
15
Coordinates
REXUS
GIS Longitude
Numeric
Longitude
Longitude for building (and see above)
16
Attributes
REXUS
Gross Floor Area
Numeric
Gross Sqft
Located at Space Summary:
17
Attributes
REXUS
Rentable Floor Area
Numeric
Rentable Sqft
See above
18
Attributes
REXUS
Stories or Levels
Numeric
Tot Num Floors
Located at Structural Information:
19
Attributes
BPP
Perimeter
Numeric
Perimeter
Located under Dimensions
20
Attributes
BPP
Depth
Numeric
Depth
As above
21
Attributes
BPP
Height
Numeric
Height
As above
22
Attributes
BPP
Length
Numeric
Length
As above

Building History

Attribute
Source
Data Element
Field Type
Definition
Comments
1
Construction or Alteration
NEW
Type
Text
NA
Note: Not new data elements.
2
Construction or Alteration
NEW
Beginning Date
Date
NA
REXUS doesn’t appear to utilize begin and end dates (if only from a format perspective). Such dates shall remain the domain of the preservation plan tool.
3
Construction or Alteration
NEW
Ending Date
Date
NA
As above
4
Construction or Alteration
NEW
Description
Text
NA
5
Construction or Alteration
BPP
Architect
Text
Architect
Located in Construction History
6
Construction or Alteration
BPP
Style
Drop-down
Style
The list of values includes:

· Adam Style

· Art Deco

· Art Moderne

· Beaux Arts

· Brutalist

· Bungaloid

· Chateausque

· Commercial Style

· Eastlake Style

· Egyptian Revival

· Federal

· Georgian Revival

· Gothic Revival

· High Victorian Gothic

· High Victorian Italianate

· International Style

· Italianate

· Jacobethan Revival

· Jeffersonian Classic

· Late Gothic Revival

· Miesian

· Mission Style

· Modernistic

· Neo-Classical Revival

· Neo-Expressionist

· New Formation

· Octagon Mode

· Prairie Style

· Pueblo Style

· Queen Anne

· Renaissance Revival

· Richardsonian Romanesque

· Romanesque Revival

· Second Empire

· Second Renaissance Revival

· Shingle Style

· Spanish Colonial Revival

· Stick Style

· Stripped Classical

· Sullivanesque

· Undetermined

· Western Stick Style

· Wrightian

7
Function or Use
BPP
Usage
Drop-down
Usage
Drop-down values are captured here:
8
Function or Use
NEW
Beginning Date
Date
NA
See item 2 above
9
Function or Use
NEW
Ending Date
Date
NA
As above
10
Function or Use
NEW
Comments
Text
NA
11
Name
BPP
Name
Text
Name
12
Name
BPP
Beginning Date
Text
From
13
Name
BPP
Ending Date
Text
To
14
Name
NEW
Comments
Text
NA

Historic Designation

Attribute
Source
Data Element
Field Type
Definition
Comments
1
National Register
BPP
National Register Name
Text (Box)
New Name
Located in Location Summary
2
National Register
REXUS
National Register Designation
Drop-down
Historical Status[footnoteRef:10] [10: The drop-down is comprised of the following values: National Historic Landmark, National Register Listed, National Register Eligible, Non-Contributing Element, Not Evaluated, and Evaluated - Not Historic]
3
National Register
BPP
National Register Date
Date
NR Date
4
National Register
BPP
National Register Number
Numeric
NR Number
5
National Register
NEW
National Register District Number
Numeric
NA
6
National Register
BPP
National Register District Name
Text
District Name
7
National Register
NEW
National Historic Landmarks Date
Date
8
National Register
NEW
National Historic Landmarks Number
Numeric
9
GSA Determination
BPP
Determined Eligible
Radio Button
Yes/No
Located in Historic Designation
10
GSA Determination
BPP
GSA Date
Date
GSA Date
As above
11
GSA Determination
BPP
Criteria
Drop-down
Criteria
As above:
12
State or Local Designation
NEW
Designation Name
Text
NA
13
State or Local Designation
BPP
Date
Date
State/Local Date
14
State or Local Designation
BPP
District Name
Drop-down
District
See above
15
State or Local Designation
BPP
Jurisdiction Name
Text
Jurisdiction Name

Inspections

Attribute
Source
Data Element
Field Type
Definition
Comments
1
Inspection 1…
BPP
Firm
Text
Firm
Located in Inspections
2
Inspection 1…
BPP
Street Address
Text
Address 1
As above
3
Inspection 1…
BPP
City
Text
City
As above
4
Inspection 1…
BPP
State
Drop-down
State
As above
5
Inspection 1…
BPP
ZIP Code
Numeric
Zip
As above
6
Inspection 1…
BPP
Phone Number
Numeric
Work
As above
7
Inspection 1…
NEW
Web Site Address
Hyperlink
URL
Company URL; not presently captured in BPP.

Architectural Description

Attribute
Source
Data Element
Field Type
Definition
Comments
1
Narrative
BPP
General
Text
Architectural Description
There is no distinction made between interior or exterior relative to input format
2
Narrative
NEW
Site
Text
NA
3
Narrative
NEW
Exterior
Text
NA
4
Narrative
NEW
Interior
Text
NA

Physical History

Attribute
Source
Data Element
Field Type
Definition
Comments
1
Narrative
NEW
Site History (Archeology)
Text
NA
2
Narrative
BPP
Building History
Text
Physical History

Integrity & Significance

Attribute
Source
Data Element
Field Type
Definition
Comments
1
Narrative
NEW
Integrity
Text
NA
BPP text is not broken out or otherwise differentiated as “Integrity” or “Significance” related; ergo, these will necessarily be new data fields.
2
Narrative
NEW
Significance
Text
NA
As above

Zones

Attribute
Source
Data Element
Field Type
Definition
Comments
1
NA
BPP
Zone
Drop-down
Zone
Located in Space Descriptions:
2
NA
NEW
Space Name
Text
NA
3
NA
BPP
Description
Text
General Description
See image above.
4
NA
NEW
Alterations
Text
NA
I was not able to locate such a data field in BPP.
5
NA
NEW
Integrity
Text
NA
I was not able to locate such a data field in BPP.
6
NA
BPP
Recommendations
Text
Recommendations
Located in Architectural Elements: Correction: Inventory of Spaces & Elements

Elements & Materials

Attribute
Source
Data Element
Field Type
Definition
Comments
1
NA
BPP
Element/Material Name
Drop-down
Material
May be located in Architectural Elements (if Element/Material Name = Material):
2
NA
BPP
Space
Drop-down
Space Type
May be located in Space Descriptions (if Space = Space Type):
3
NA
BPP
Description
Text
Description
Appears to be located in Architectural Elements:
4
NA
BPP
Conditions
Text
Condition
A collection of data resides in BPP in Architectural Elements (Conditions).
5
NA
BPP
Recommendations
Text
Recommendations
Located in Architectural Elements:
6
NA
NEW
Treat/Technical Procedure
Text
NA
7
NA
NEW
Primary Exterior Materials
Drop-down
NA
Menu selections to include the following:

Wood Brick Stone Terracotta Cast Stone (Architectural Concrete) Concrete Concrete Block Stucco Metal Glass Other

8
NA
NEW
Secondary Exterior Materials
Drop-down
NA
Menu selections to include the following:

Wood Brick Stone Terracotta Cast Stone (Architectural Concrete) Concrete Concrete Block Stucco Metal Glass Other

9
NA
NEW
Structural System
Drop-down
NA
Menu selections to include the following:

Wood Frame Steel Frame Concrete Frame Bearing Masonry Wall Other

10
NA
NEW
Primary Roofing Material
Drop-down
NA
Menu selections to include the following:

Slate Clay Tile Metal Membrane Built Up Other

11
NA
NEW
Secondary Roofing Material
Drop-down
NA
Menu selections to include the following:

Slate Clay Tile Metal Membrane Built Up Other

Images

Attribute
Source
Data Element
Field Type
Definition
Comments
1
NA
BPP
File Name
Character
Id
A product of the file that is uploaded.
2
NA
BPP
Type
Drop-down
Type
Add under Image Library:
3
NA
BPP
Photographer/Artist
Text
Photographer Artist
Located in the Image Library:
4
NA
BPP
Subject/Description
Text
Subject
As above; however, broken into two fields: Subject and Description.
5
NA
BPP
Date
Date
Date
Located in the Image Library
6
NA
BPP
Publication Source
Text
Publication
As above
7
NA
BPP
Copyright
Radio button
Copyright
As above: options = Unknown, Yes, and No
8
NA
BPP
Space
Drop-down
Space Type
(If applicable) located in Inventory of Elements (Space Description).
9
NA
BPP
Element/Material
Drop-down
Element Material
(If applicable) located in Architectural Elements, but as separate drop-down fields.

Documents & References

Attribute
Source
Data Element
Field Type
Definition
Comments
1
NA
BPP
Title
Text
Title
Located in Bibliography:
2
NA
BPP
Author(s)
Text
Author
See above: Authors may listed and separate by commas
3
NA
BPP
Publisher/Source
Text
Source Name
Located in Bibliography
4
NA
BPP
Identification Number
Text
Document ID
As above; note: LC (Library of Congress) Number is also an option in BPP, but not recommended by NIBS[footnoteRef:11]. [11: Government Printing Office (GPO) Number is also not recommended by NIBS]
5
NA
BPP
Publication Date
Date
Date
Located in Bibliography
6
NA
BPP
Document Type
Drop-down
Document Type
NIBS proposes a more comprehensive list; namely,

Archeology Report Article BIM Product Building Analysis Building Engineering/Evaluation Report Building Preservation Plan Drawings Historic Structure Report Other Paint Analysis Photograph Publication Recommended Treatment Report Special Study Survey Documentation Unknown Website

7
NA
NEW
URL
Hypertext
URL
Reference or document shall open in a separate window; URL may be edited by data entry (owner), regional and system administrators.
8
NA
NEW
File Name
Character
NA

Addendum: Operational Process and Procedures The preservationist (typically a contractor) shall be assigned the property on which the preservation plan is to be performed by the Regional Historic Preservation Officer (or RHPO, always a federal employee). The contractor will document the historic space in a manner organized or guided by the eleven categories or components articulated above. Insofar as much of the documenting shall occur on site at the historic property the contractor must be able to access the tool outside the GSA firewall as an authenticated Data Entry user. The tool must accommodate the following at a minimum.

· Any given historic property may have numerous preservation plans attached to it that have been performed over time. Such plans shall not be overwritten; rather, each plan associated with a property shall be retained and date stamped.

· The Data Entry user shall be able to select and upload multiple files at one time.

· All work created by the Data Entry user shall reside in a staging area within the tool to enable the RHPO’s review prior to deployment to production.

· The preservation plan (i.e. all content associated with the eleven components and subcomponents) shall be exportable and printable.

Once the preservation plan has been completed in satisfactory fashion it is submitted to the RHPO (and/or COR[footnoteRef:12]) as a contract deliverable. [12: Contracting Officer’s Representative ]

Note:

To promote consistency, use the following terms:

Asphalt Brick Carpet Cast Stone Concrete Glass Gypsum Board Metal Paint Plaster Plastic Rubber Slate Stone Stucco Terra Cotta Terrazzo Tile Wood image2.png image3.png image4.png image5.png image6.png image7.png image8.png image9.emf

BUILDING_USE_DropDown Values.xlsx Export Worksheet

USE_ID USE_CODE DESCRIPTION

1 01A Single Dwelling

2 01B Multiple Dwelling

3 01C Secondary Structure

4 01D Hotel

5 01E Institutional Housing

6 02A Commercial

7 02B Professional

8 02C Organizatonal

9 02D Financial Institution

10 02E Retail - Specialty Store

11 02F Retail - Department Store

12 02G Restaurant

13 02H Warehouse

14 02I Trade

15 03A Meeting Hall (Frat./Patr.)

16 03B Clubhouse (Social, Garden)

17 03C Civic (Salvation Army, Comm.)

18 04A Capitol

19 04B City Hall (Town Hall)

20 04C Correctional Facility (Jail)

21 04D Fire Station

22 04E Government Office

23 04F Diplomatic Building

24 04G Customs House

25 04H Post Office

26 04I Public Works

27 04J Courthouse

28 05A Secondary School

29 05B College

30 05C Library

31 05D Research Facility (Lab/Obsv.)

32 05E Educational Related Housing

33 06A Religious Structure (Church)

34 06B Ceremonial Site

35 06C Church School

36 06D Church-related Residence

37 07A Cemetery

38 07B Grave/Burial

39 07C Mortuary (Crypt)

40 08A Theater (Cinema)

41 08B Auditorium

42 08C Museum (Exhibition Hall)

43 08D Music Facility

44 08E Sport Facility

45 08F Outdoor Recreation

46 08H Outdoor Sculpture

47 09A Processing

48 09B Storage (Granary, Silo)

49 09D Animal Facility

50 09F Agricultural Outbuilding

51 09G Horticultural Facility

52 09H Irrigation Facility

53 100 No Potential Use

54 10A Manufacturing Facility

55 10B Extractive Facility

56 10D Energy Facility

57 10E Communications Facility

58 10F Processing Site

59 12A Hospital (Mental Hospital)

60 12B Clinic (Dispensary)

61 12C Sanitarium (Nursing,Rest Home)

62 12D Medical Business/Office

63 12E Resort (Spa)

64 13A Arms Storage

65 13B Fortification

66 13C Military Facility

67 13D Battle Site

68 13E Coast Guard Facility

69 13F Naval Facility

70 13G Air Facility

71 15C Plaza/Public Space

72 15D Garden/Res. Ground/Est./Plant.

73 15E Memorial/Ceremonial

74 15G Recreational Ground

75 15H Subdivision/Planned Community

76 16A Rail Related

77 16B Air Related

78 16C Water Related

79 16E Pedestrian Related

80 96 Work in Progress

81 97 Unknown

82 98 Vacant/Not in Use

83 98A Ruin

84 99 Other

101 95 EXCESSED

SQL

select * from BUILDING_USE image10.png image11.png image12.png image13.png image14.png image15.png image16.png image17.png image18.png image19.png image20.png image21.png image22.png image23.png image24.png image25.png image26.png image1.png

File details come from the government source that posted it.