FPDS Query Library
About Us
Contact Us

Street Address2

Text field containing the vendor location's second street address line, such as a suite, mail stop, building identifier, or post office box. It complements Street Address 1 and is part of the award-level vendor site location details.

Family: Award
Category: Vendor Site Details
Data Type: string
Semantic Type: attribute
Mapping: flattened_fpds_xml_field
AI Confidence: high

Variable Overview

FPDS Query Variable
content__award__vendor__vendorSiteDetails__vendorLocation__streetAddress2
Title
Street Address2
FPDS Path
award/vendor/vendorSiteDetails/vendorLocation/streetAddress2
Description
Text field containing the vendor location's second street address line, such as a suite, mail stop, building identifier, or post office box. It complements Street Address 1 and is part of the award-level vendor site location details.
Business Meaning
This field helps analysts resolve vendor location details when matching award records to addresses, geographies, or external vendor master data. It can improve entity identification, office-level grouping, and location-based analysis when the primary address line is incomplete or ambiguous.
Example Value
P.O. BOX 5800, MS-0180, 87185-0180
Observed Non-Null Count
1,889,737

FPDS Compare

FPDS Query Variable
content__award__vendor__vendorSiteDetails__vendorLocation__streetAddress2
FPDS XML Path
award/vendor/vendorSiteDetails/vendorLocation/streetAddress2
Mapping Type
flattened_fpds_xml_field
Comparison Summary
FPDS Query flattens the original nested FPDS XML path 'award/vendor/vendorSiteDetails/vendorLocation/streetAddress2' into the SQL-ready variable 'content__award__vendor__vendorSiteDetails__vendorLocation__streetAddress2'.

Use Cases

  • Dictionary lookup and field explanation
  • SQL filtering and grouping
  • Analytical reporting and reusable query building
  • Contractor profiling and competitor analysis

Common Usage

  • supplementing vendor address parsing and normalization
  • supporting vendor entity matching and deduplication
  • improving location-based filtering and reporting

Common Mistakes

  • assuming the field always contains a second street line rather than a mailing or office identifier
  • using it alone to geocode or classify vendor location

Query Guidance

Use it as a nullable text attribute in SELECT, WHERE, and GROUP BY only when you need address-detail slicing. For address matching or geocoding, concatenate with other vendor location fields and normalize whitespace, punctuation, and abbreviations before comparison.

SQL Examples

Preview values

SELECT
    content__award__vendor__vendorSiteDetails__vendorLocation__streetAddress2 AS street_address2
FROM fpds.data
WHERE content__award__vendor__vendorSiteDetails__vendorLocation__streetAddress2 IS NOT NULL
LIMIT 25

Top values

SELECT
    content__award__vendor__vendorSiteDetails__vendorLocation__streetAddress2 AS value,
    count() AS record_count
FROM fpds.data
WHERE content__award__vendor__vendorSiteDetails__vendorLocation__streetAddress2 IS NOT NULL
GROUP BY value
ORDER BY record_count DESC
LIMIT 25

Each dictionary item includes SQL-ready examples generated alongside the variable metadata, allowing immediate use in FPDS Query for filtering, aggregation, and analysis.