tinyows_parcel.sql

SELECT "saopyr_id",ST_AsGML(ST_Transform("geom"::geometry,3857),0,0) AS "geom" ,"print_key","roll_yr","parcel_id","owner","street_nbr","street","full_parcel_adress","type_of_property","building_style","sbl","usd_land_assesed_value","usd_total_assesed_value","usd_county_taxable_value","usd_town_taxable_value","usd_school_taxable_value","usd_village_taxable_value","usd_star_town_taxable_value","usd_star_school_taxable_value","usd_total_assesed_value_sqft","deed_book","deed_page","usd_full_market_value","yr_built","usd_sales_price","usd_sales_price_sqft","sales_date","usd_exeption_amount","surface_building_square_footage","surface_lot_size","bathroom_nbr","bedroom_nbr","fireplace_nbr","basement_type","nbhd_code","admin_nbhd_code","image_path" FROM citylkpt21 WHERE ST_Intersects("geom",ST_Transform(ST_SetSRID('0103000020110F000001000000050000007C6B61FDCDB560C190C8C2F7835D54417C6B61FDCDB560C1FCEC4EA0845D544146591BA9CDB560C1FCEC4EA0845D544146591BA9CDB560C190C8C2F7835D54417C6B61FDCDB560C190C8C2F7835D5441'::geometry,3857),26917))