Largest private acerage owners in each county
Download the Scalable Vector Graphic of the Largest private acerage owners in each county.
About SVGZ Graphic: Largest private acerage owners in each county ....
What private property owner has the most acerage by county? I've been playing with these queries in R, trying to pull this data to make maps and analysis by using overly complex postgresql queries. At some point I'll upload the R code up into Github, but for now, here is the PostgresSQL query that actually ran relatively quickly -- 25 seconds or so on my old laptop.
SELECT
primary_owner,
county_name,
avg(ST_X(geom)) as x,
avg(ST_Y(geom)) as y,
sum(acres) as av
INTO TEMPORARY propTot
FROM
nytax_ctr_point
WHERE
"roll_section"='1' AND
"owner_type"='8' AND
"acres" < 1000
GROUP BY
primary_owner, county_name;
SELECT
t1.*
FROM
propTot t1
RIGHT JOIN (
SELECT county_name, max(av) as av
FROM propTot
GROUP BY county_name
) t2
ON t1.county_name = t2.county_name AND
t1.av = t2.av;
More about New York State...
New York is a state in the Northeastern region of the United States. New York is the 27th-most extensive, the 3rd-most populous, and the 7th-most densely populated of the 50 United States. New York is bordered by New Jersey and Pennsylvania to the south, and by Connecticut, Massachusetts and Vermont to the east. The state has a maritime border with Rhode Island east of Long Island, as well as an international border with the Canadian provinces of Ontario to the west and north, and Quebec to the north. The state of New York is often referred to as New York State to distinguish it from New York City.
