FPDS Query Library
About Us
Contact Us

Is Port Authority

Boolean or coded indicator showing whether the vendor site is identified as a port authority in the IDV vendor site details. It records the presence of that government-entity type for the vendor site, rather than describing the entity in free text.

Family: IDV
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__IDV__vendor__vendorSiteDetails__typeOfGovernmentEntity__isPortAuthority
Title
Is Port Authority
FPDS Path
IDV/vendor/vendorSiteDetails/typeOfGovernmentEntity/isPortAuthority
Description
Boolean or coded indicator showing whether the vendor site is identified as a port authority in the IDV vendor site details. It records the presence of that government-entity type for the vendor site, rather than describing the entity in free text.
Business Meaning
This field helps analysts isolate awards involving port authorities, which can be relevant for public infrastructure, transportation, and regional economic activity analysis. It also supports compliance, set-aside, and vendor-segmentation reviews when the legal status of the supplier matters.
Example Value
0
Observed Non-Null Count
5,862,557

FPDS Compare

FPDS Query Variable
content__IDV__vendor__vendorSiteDetails__typeOfGovernmentEntity__isPortAuthority
FPDS XML Path
IDV/vendor/vendorSiteDetails/typeOfGovernmentEntity/isPortAuthority
Mapping Type
flattened_fpds_xml_field
Comparison Summary
FPDS Query flattens the original nested FPDS XML path 'IDV/vendor/vendorSiteDetails/typeOfGovernmentEntity/isPortAuthority' into the SQL-ready variable 'content__IDV__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 IDVs or vendors associated with port authorities
  • Segment procurement activity by government-entity vendor type
  • Support compliance or exception reviews involving public-sector suppliers

Common Mistakes

  • Assuming the field identifies the awardee's legal form for all records rather than the specific vendor site classification
  • Filtering on a single literal value without verifying how the flag is encoded in the loaded data

Query Guidance

Use this field in WHERE clauses to isolate port-authority records, but first confirm whether the stored values are numeric, boolean, or text codes. If a description companion field exists, use the code field for filtering and the description field only for reporting or validation.

SQL Examples

Preview values

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

Flag distribution

SELECT
    content__IDV__vendor__vendorSiteDetails__typeOfGovernmentEntity__isPortAuthority AS flag_value,
    count() AS record_count
FROM fpds.data
WHERE content__IDV__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.