FPDS Query Library
About Us
Contact Us

Is Port Authority

Boolean or coded flag indicating whether the vendor site is classified as a port authority in the award record. It identifies the applicable government-entity type for the vendor site, not the award action itself.

Family: Other Transaction Award
Category: Vendor Site Details
Data Type: boolean_or_code_flag
Semantic Type: flag
Mapping: flattened_fpds_xml_field
AI Confidence: high

Variable Overview

FPDS Query Variable
content__OtherTransactionAward__contractDetail__vendor__vendorSiteDetails__typeOfGovernmentEntity__isPortAuthority
Title
Is Port Authority
FPDS Path
OtherTransactionAward/contractDetail/vendor/vendorSiteDetails/typeOfGovernmentEntity/isPortAuthority
Description
Boolean or coded flag indicating whether the vendor site is classified as a port authority in the award record. It identifies the applicable government-entity type for the vendor site, not the award action itself.
Business Meaning
This field helps analysts identify awards involving port authorities, which can be relevant for transportation, maritime, infrastructure, and quasi-government vendor analysis. It supports segmentation of vendor populations by entity type and can affect compliance, reporting, and market concentration reviews.
Example Value
0
Observed Non-Null Count
38,894

FPDS Compare

FPDS Query Variable
content__OtherTransactionAward__contractDetail__vendor__vendorSiteDetails__typeOfGovernmentEntity__isPortAuthority
FPDS XML Path
OtherTransactionAward/contractDetail/vendor/vendorSiteDetails/typeOfGovernmentEntity/isPortAuthority
Mapping Type
flattened_fpds_xml_field
Comparison Summary
FPDS Query flattens the original nested FPDS XML path 'OtherTransactionAward/contractDetail/vendor/vendorSiteDetails/typeOfGovernmentEntity/isPortAuthority' into the SQL-ready variable 'content__OtherTransactionAward__contractDetail__vendor__vendorSiteDetails__typeOfGovernmentEntity__isPortAuthority'.

Use Cases

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

Common Usage

  • Filter awards involving port authority vendors
  • Segment vendor universe by government-entity type
  • Support compliance or special-entity reporting

Common Mistakes

  • Interpreting the flag as an award-level attribute instead of a vendor-site attribute
  • Assuming all non-1 values mean the same thing without checking the coded domain

Query Guidance

Use the field in WHERE clauses to isolate port authority records, for example `WHERE isPortAuthority = 1` when the dataset uses binary coding. If the dataset contains text or mixed codes, inspect distinct values first and map them before applying filters or aggregations.

SQL Examples

Preview values

SELECT
    content__OtherTransactionAward__contractDetail__vendor__vendorSiteDetails__typeOfGovernmentEntity__isPortAuthority AS is_port_authority
FROM fpds.data
WHERE content__OtherTransactionAward__contractDetail__vendor__vendorSiteDetails__typeOfGovernmentEntity__isPortAuthority IS NOT NULL
LIMIT 25

Flag distribution

SELECT
    content__OtherTransactionAward__contractDetail__vendor__vendorSiteDetails__typeOfGovernmentEntity__isPortAuthority AS flag_value,
    count() AS record_count
FROM fpds.data
WHERE content__OtherTransactionAward__contractDetail__vendor__vendorSiteDetails__typeOfGovernmentEntity__isPortAuthority IS NOT NULL
GROUP BY flag_value
ORDER BY record_count DESC

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