Use these queries to work with Precisely Property Attributes Assessment datasets in the United States of America.
Use case 1: Find ZIP code for a given PreciselyID
Query:
SELECT PBKEY AS PreciselyID, ZIPCODE
FROM PROPERTY_ATTRIBUTES_ASSESSMENT
WHERE PBKEY = 'P0000OE7GQPK';Output: Returns the ZIP code associated with the specified PreciselyID.
Use case 2: Find top 10 properties by market value in Los Angeles County
Query:
SELECT PAID, ADDRESS, CITY, STATE, MRKTVAL_IMP
FROM PROPERTY_ATTRIBUTES_ASSESSMENT
WHERE FIPS = '06037'
ORDER BY MRKTVAL_IMP DESC
LIMIT 10;Output: Returns the top 10 properties with the highest market improvement value in Los Angeles County.
Use case 3: Identify vacant properties in Texas
Query:
SELECT PAID, ADDRESS, CITY, STATE, VACANT
FROM PROPERTY_ATTRIBUTES_ASSESSMENT
WHERE STATE = 'TX' AND VACANT = 'Y';Output: Returns all vacant properties located in Texas.
Use case 4: Join Property Attributes with Parcel Boundaries
Query:
SELECT p.PAID, p.ADDRESS, p.CITY, p.STATE, parcel.PRCLID
FROM PROPERTY_ATTRIBUTES_ASSESSMENT p
JOIN PARCEL_BOUNDARIES parcel ON p.PLINKID = parcel.PLINKID
WHERE p.STATE = 'FL';Output: Returns property details along with parcel IDs for properties in Florida.
Use case 5: Find properties missing physical address
Query:
SELECT PAID, PROP_APN, CITY, STATE
FROM PROPERTY_ATTRIBUTES_ASSESSMENT
WHERE ADDRESS IS NULL OR ADDRESS = '';Output: Returns all property records that do not have a physical address.
Use case 6: Get average tax amount by state
Query:
SELECT STATE, AVG(TAX_AMT) AS AvgTaxAmount
FROM PROPERTY_ATTRIBUTES_ASSESSMENT
GROUP BY STATE
ORDER BY AvgTaxAmount DESC;Output: Returns the average property tax amount for each state.
Use case 7: List properties built before 1950
Query:
SELECT PAID, ADDRESS, CITY, STATE, BLDG_YRBLD
FROM PROPERTY_ATTRIBUTES_ASSESSMENT
WHERE BLDG_YRBLD < 1950
ORDER BY BLDG_YRBLD;Output: Returns all properties built before the year 1950.
Use case 8: Get top 5 county-level regions by total assessed land value
Query:
SELECT FIPS, SUM(ASSED_LANDVAL) AS TotalLandValue
FROM PROPERTY_ATTRIBUTES_ASSESSMENT
GROUP BY FIPS
ORDER BY TotalLandValue DESC
LIMIT 5;Output: Returns the top 5 county-level regions with the highest total assessed land value.
Use case 9: Find properties owned by businesses
Query:
SELECT PAID, ADDRESS, CITY, STATE, OWNTYPE
FROM PROPERTY_ATTRIBUTES_ASSESSMENT
WHERE OWNTYPE = 'Business';Output: Returns all properties owned by businesses or trusts.
Use case 10: Land use distribution by state
Query:
SELECT STATE, PROP_ST_LANDUSE, COUNT(*) AS PropertyCount
FROM PROPERTY_ATTRIBUTES_ASSESSMENT
GROUP BY STATE, PROP_ST_LANDUSE
ORDER BY STATE, PropertyCount DESC;Output: Shows the count of properties by standardized land use code for each state.
Use case 11: Identify properties with extreme tax amounts
Query:
SELECT PAID, ADDRESS, CITY, STATE, TAX_AMT
FROM PROPERTY_ATTRIBUTES_ASSESSMENT
WHERE TAX_AMT > 100000
ORDER BY TAX_AMT DESC;Output: Returns properties with tax amounts greater than $100,000.
Use case 12: Filter properties by heating type
Query:
SELECT PAID, ADDRESS, CITY, STATE, HEAT_TYPE
FROM PROPERTY_ATTRIBUTES_ASSESSMENT
WHERE HEAT_TYPE = 'Forced Air';Output: Returns all properties that use forced air heating.