Government
NPR
5 Interesting Facts About Martin Van Buren
The Life of Martin Van Buren, Heir-Apparent to the ‘Government,’ and the Appointed Successor of General Andrew Jackson. Containing Every Authentic Particular by Which His Extraordinary Character Has Been Formed. With a Concise History of the Events … | Northern Illinois University Digital Library
STATESMEN are gamesters, and the people are the cards they play with. And it is curious to see how good the comparison holds as to all the games, the shuffling, and the tricks performed with them sort of books, as they are sometimes called. From "three up" to "whist" from a "constable" to a "president" the hands are always dealing out; and in both cases, the way they cut and shuffle is a surprise to all young beginners.
The present "government" has been a great sportsman in his time; and he has played at both games with equal success: and not content with his own good luck, he is actually giving item in favour of another, and has so shuffled and stocked the cards, that unless we can cut the pack in the right place, he will turn up a Jack upon the country.
I have gone far enough on this hook to show what I mean: the people are tricked and cheated, and what is worse, they are satisfied to stay so. If any one tells them that they are used by political 4 gamblers as a blacksmith uses his tongs, they fly into a passion and say it is all a trick to abuse Jackson. If you ask them what it is that makes Van Buren fit for a president, and why it is that General Jackson has appointed him for his successor, they answer, "he has been persecuted for Jackson's sake." Jackson, they say, has done enough, not only to reign himself as long as he wants to, but to say who shall reign after him. But the good of this joke is, these same people call themselves democratic republicans! Republicans! unable to choose for themselves, and consenting to give that right to a single individual. What think you of that?
How to Look Up Any Tax Assessment Record in New York State by Coordinate
How to Look Up Any Tax Assessment Record in New York State by Coordinate
I was studying the various data services available and discovered a handy little website put out by the state for public use to find out tax assessment records for all counties in New York State.
Required Fields:
Y = Latitude
X = Longitude
SpatialReference = 4326 if you want to use latitude and longitude
Kind of a handy endpoint, for your use. It returns a json string. You can also automate the process by using a GET or POST request. For example to pull the tax record for a point at Cole Hill State Forest and get the data back as a JSON text string.
https://gisservices.its.ny.gov/arcgis/rest/services/NYSTaxAssessmentLookup/GPServer/TaxAssessment/execute?X=-74.10192&Y=42.59518&SpatialReference=4326&env%3AoutSR=&env%3AprocessSR=&returnZ=false&returnM=false&returnTrueCurves=false&returnFeatureCollection=false&context=&f=json
Here is what that URL will output it when you request it.
{"results":[{"paramName":"OBJECTID","dataType":"GPString","value":"30986"}, {"paramName":"COUNTY_NAME","dataType":"GPString","value":"Albany"}, {"paramName":"MUNI_NAME","dataType":"GPString","value":"Berne"}, {"paramName":"SWIS","dataType":"GPString","value":"012000"}, {"paramName":"PARCEL_ADDR","dataType":"GPString","value":"Willsie Rd"}, {"paramName":"PRINT_KEY","dataType":"GPString","value":"90.-1-14"}, {"paramName":"SBL","dataType":"GPString","value":"09000000010140000000"}, {"paramName":"CITYTOWN_NAME","dataType":"GPString","value":"Berne"}, {"paramName":"CITYTOWN_SWIS","dataType":"GPString","value":"012000"}, {"paramName":"LOC_ST_NBR","dataType":"GPString","value":"Null"}, {"paramName":"LOC_STREET","dataType":"GPString","value":"Willsie Rd"}, {"paramName":"LOC_UNIT","dataType":"GPString","value":"Null"}, {"paramName":"LOC_ZIP","dataType":"GPString","value":"Null"}, {"paramName":"PROP_CLASS","dataType":"GPString","value":"941"}, {"paramName":"ROLL_SECTION","dataType":"GPString","value":"3"}, {"paramName":"LAND_AV","dataType":"GPString","value":"579885"}, {"paramName":"TOTAL_AV","dataType":"GPString","value":"579885"}, {"paramName":"FULL_MARKET_VAL","dataType":"GPString","value":"982856"}, {"paramName":"YR_BLT","dataType":"GPString","value":"Null"}, {"paramName":"FRONT","dataType":"GPString","value":"0"}, {"paramName":"DEPTH","dataType":"GPString","value":"0"}, {"paramName":"SQ_FT","dataType":"GPString","value":"0"}, {"paramName":"ACRES","dataType":"GPString","value":"506.28"}, {"paramName":"SCHOOL_CODE","dataType":"GPString","value":"012001"}, {"paramName":"SCHOOL_NAME","dataType":"GPString","value":"Berne-Knox-Westerlo"}, {"paramName":"SEWER_TYPE","dataType":"GPString","value":"1"}, {"paramName":"SEWER_DESC","dataType":"GPString","value":"None"}, {"paramName":"WATER_SUPP","dataType":"GPString","value":"1"}, {"paramName":"WATER_DESC","dataType":"GPString","value":"None"}, {"paramName":"UTILITIES","dataType":"GPString","value":"3"}, {"paramName":"UTILITIES_DESC","dataType":"GPString","value":"Electric"}, {"paramName":"BLDG_STYLE","dataType":"GPString","value":"Null"}, {"paramName":"BLDG_STYLE_DESC","dataType":"GPString","value":"Null"}, {"paramName":"HEAT_TYPE","dataType":"GPString","value":"Null"}, {"paramName":"HEAT_TYPE_DESC","dataType":"GPString","value":"Null"}, {"paramName":"FUEL_TYPE","dataType":"GPString","value":"Null"}, {"paramName":"FUEL_TYPE_DESC","dataType":"GPString","value":"Null"}, {"paramName":"SQFT_LIVING","dataType":"GPString","value":"Null"}, {"paramName":"NBR_KITCHENS","dataType":"GPString","value":"Null"}, {"paramName":"NBR_FULL_BATHS","dataType":"GPString","value":"Null"}, {"paramName":"NBR_BEDROOMS","dataType":"GPString","value":"Null"}, {"paramName":"USED_AS_CODE","dataType":"GPString","value":"Null"}, {"paramName":"USED_AS_DESC","dataType":"GPString","value":"Null"}, {"paramName":"AG_DIST_CODE","dataType":"GPString","value":"Null"}, {"paramName":"AG_DIST_NAME","dataType":"GPString","value":"Null"}, {"paramName":"PRIMARY_OWNER","dataType":"GPString","value":"NYS Reforestation Land"}, {"paramName":"MAIL_ADDR","dataType":"GPString","value":"112 State St Rm 810"}, {"paramName":"PO_BOX","dataType":"GPString","value":"Null"}, {"paramName":"MAIL_CITY","dataType":"GPString","value":"Albany"}, {"paramName":"MAIL_STATE","dataType":"GPString","value":"NY"}, {"paramName":"MAIL_ZIP","dataType":"GPString","value":"12207"}, {"paramName":"ADD_OWNER","dataType":"GPString","value":"Null"}, {"paramName":"ADD_MAIL_ADDR","dataType":"GPString","value":""}, {"paramName":"ADD_MAIL_PO_BOX","dataType":"GPString","value":"Null"}, {"paramName":"ADD_MAIL_CITY","dataType":"GPString","value":"Null"}, {"paramName":"ADD_MAIL_STATE","dataType":"GPString","value":"Null"}, {"paramName":"ADD_MAIL_ZIP","dataType":"GPString","value":"Null"}, {"paramName":"BOOK","dataType":"GPString","value":"Null"}, {"paramName":"PAGE","dataType":"GPString","value":"Null"}, {"paramName":"GRID_EAST","dataType":"GPString","value":"561180"}, {"paramName":"GRID_NORTH","dataType":"GPString","value":"945822"}, {"paramName":"MUNI_PARCEL_ID","dataType":"GPString","value":"0120001026"}, {"paramName":"SWIS_SBL_ID","dataType":"GPString","value":"01200009000000010140000000"}, {"paramName":"SWIS_PRINT_KEY_ID","dataType":"GPString","value":"01200090.-1-14"}, {"paramName":"ROLL_YR","dataType":"GPString","value":"2019"}, {"paramName":"SPATIAL_YR","dataType":"GPString","value":"2019"}, {"paramName":"OWNER_TYPE","dataType":"GPString","value":"2"}, {"paramName":"NYS_NAME","dataType":"GPString","value":"New York State- DEC"}, {"paramName":"NYS_NAME_SOURCE","dataType":"GPString","value":"1-2-SA-a"}, {"paramName":"DUP_GEO","dataType":"GPString","value":"Null"}, {"paramName":"CALC_ACRES","dataType":"GPString","value":"498.300342"}, {"paramName":"ServiceMessage","dataType":"GPString","value":"Match found for entered X:-74.10192 & Y:42.59518."}],"messages":[]}
I found this handy enough, I wrote short PHP script that I can execute as needed to pull up property data and output it into a CSV spreadsheet format for bringing up in OpenOffice Calc. If you enter more then two words, it searches by address, otherwise it uses the first and second parameters as coordinates.
if ($argc > 2) { $address = ""; for ($i = 1; $i <= $argc; $i++) $address .= "$argv[$i] "; $address = urlencode($address); $json = file_get_contents("https://gisservices.its.ny.gov/arcgis/rest/services/Locators/Street_and_Address_Composite/GeocodeServer/findAddressCandidates?Street=&City=&State=&ZIP=&SingleLine={$address}&outFields=&maxLocations=1&matchOutOfRange=true&langCode=&locationType=&sourceCountry=&category=&location=&distance=&searchExtent=&outSR=4326&magicKey=&f=pjson"); $coord = json_decode($json); $lat = $coord->candidates[0]->location->y; $lng = $coord->candidates[0]->location->x; } else { $lat = $argv[1]; $lng = $argv[2]; } if ($lng > 0) $lng *= -1; $json = file_get_contents("https://gisservices.its.ny.gov/arcgis/rest/services/NYSTaxAssessmentLookup/GPServer/TaxAssessment/execute?X={$lng}&Y={$lat}&SpatialReference=4326&env%3AoutSR=&env%3AprocessSR=&returnZ=false&returnM=false&returnTrueCurves=false&returnFeatureCollection=false&context=&f=json"); $prop = json_decode($json); foreach ($prop->results as $line) { echo '"'.addslashes($line->paramName).'","'.addslashes($line->value).""n"; }
With this script, you can load a nice version of tax record in your favorite spreadsheet.
OBJECTID | 30986 |
COUNTY_NAME | Albany |
MUNI_NAME | Berne |
SWIS | 12000 |
PARCEL_ADDR | Willsie Rd |
PRINT_KEY | 90.-1-14 |
SBL | 9.00000001014E+018 |
CITYTOWN_NAME | Berne |
CITYTOWN_SWIS | 12000 |
LOC_ST_NBR | Null |
LOC_STREET | Willsie Rd |
LOC_UNIT | Null |
LOC_ZIP | Null |
PROP_CLASS | 941 |
ROLL_SECTION | 3 |
LAND_AV | 579885 |
TOTAL_AV | 579885 |
FULL_MARKET_VAL | 982856 |
YR_BLT | Null |
FRONT | 0 |
DEPTH | 0 |
SQ_FT | 0 |
ACRES | 506.28 |
SCHOOL_CODE | 12001 |
SCHOOL_NAME | Berne-Knox-Westerlo |
SEWER_TYPE | 1 |
SEWER_DESC | None |
WATER_SUPP | 1 |
WATER_DESC | None |
UTILITIES | 3 |
UTILITIES_DESC | Electric |
BLDG_STYLE | Null |
BLDG_STYLE_DESC | Null |
HEAT_TYPE | Null |
HEAT_TYPE_DESC | Null |
FUEL_TYPE | Null |
FUEL_TYPE_DESC | Null |
SQFT_LIVING | Null |
NBR_KITCHENS | Null |
NBR_FULL_BATHS | Null |
NBR_BEDROOMS | Null |
USED_AS_CODE | Null |
USED_AS_DESC | Null |
AG_DIST_CODE | Null |
AG_DIST_NAME | Null |
PRIMARY_OWNER | NYS Reforestation Land |
MAIL_ADDR | 112 State St Rm 810 |
PO_BOX | Null |
MAIL_CITY | Albany |
MAIL_STATE | NY |
MAIL_ZIP | 12207 |
ADD_OWNER | Null |
ADD_MAIL_ADDR | |
ADD_MAIL_PO_BOX | Null |
ADD_MAIL_CITY | Null |
ADD_MAIL_STATE | Null |
ADD_MAIL_ZIP | Null |
BOOK | Null |
PAGE | Null |
GRID_EAST | 561180 |
GRID_NORTH | 945822 |
MUNI_PARCEL_ID | 120001026 |
SWIS_SBL_ID | 1.20000900000001E+024 |
SWIS_PRINT_KEY_ID | 01200090.-1-14 |
ROLL_YR | 2019 |
SPATIAL_YR | 2019 |
OWNER_TYPE | 2 |
NYS_NAME | New York State- DEC |
NYS_NAME_SOURCE | 1-2-SA-a |
DUP_GEO | Null |
CALC_ACRES | 498.300342 |
ServiceMessage | Match found for entered X:-74.08836 & Y:42.59480. |
Some Useful Investigative Open Data Resources
Usually when I want to research a New York organization I start at NY Open Government, which is a website put out by the NY Attorney General and brings together several open datasets.
NY Open Government: nyopengovernment.com
One way to find people’s addresses is to find them in the voter file. Voter Ref contains the voter files for several states, which can be handy for looking up people’s addresses, date of birth, party registration.
Voter Ref: voteref.com
You can confirm the latest information on people’s voting registration and address by using the state board of election’s voter lookup. You will need their county, date of birth and zip code which you can get from Voter Ref.
NY Voter Lookup: voterlookup.elections.ny.gov
See Through NY has listings of many though not all government employees, which can be useful when you are trying to find information on government workers. No addresses here, but you can find salaries and who people work for in government. If you need bulk data, I wrote a scraping script.
See Through NY: seethroughny.net/payrolls
Another good way to gleam people’s addresses and the candidates they search is NYS Campaign Finance Search. If you think somebody might work for a candidate or campaign, you can search the campaign expenses section.
NYS Campaign Finance Search: publicreporting.elections.ny.gov
The FEC Campaign Search includes a contributor’s address and reported employer, which can provide useful information.
FEC Campaign Search: https://www.fec.gov/data/receipts/individual-contributions/
Every county in New York State is required to post their tax rolls to their website. Tax rolls can be usually found by searching on Google: “XXXX County Tax Rolls
” without the quotes. Not only can you find all of the properties owned by a person that way, you can find their address, assessed value and other information. Often the county tax rolls include information on tax exemptions, such as the Guilderland Solar Exemption and Veterans STAR Reduction, which can help you find people who have solar on their homes or are Veterans. I wrote a script to convert the PDFs into Excel spreadsheets.
- Albany County Tax Rolls: albanycounty.com/departments/management-and-budget/real-property-tax-service-agency/assessment-rolls
- Rensselear County Tax Rolls: rensco.com/411/County-Property-Tax-Rolls
If you need to search a whole county or the even the state, you will want to get the full roll from NYS GIS. You don’t need mapping or GIS software to use the Shapefiles — Microsoft Excel and OpenOffice can natively open .DBF which contain the data tables. NYS GIS offers selected countys tax-maps as a Shapefile or GeoPackage too.
NYS GIS Parcels Program: https://gis.ny.gov/parcels/
NYS GIS Tax Parcels Centroid Points: gis.ny.gov/gisdata/inventories/details.cfm?DSID=1300
In addition, most counties offer their tax maps as ArcGIS REST/Services that can be used in a GIS Program like QGIS. You can find them by searching on Google: “XXX County “REST/Services” parcel”.
How to download ArcGIS Rest/Services as KML Google Maps File: mappingsupport.com/p2/kmz_demo/How_to_download_arcgis_data_as_kmz.pdf
ArcPuller is a Great Way to Get this Data in R: andyarthur.org/youll-like-arcpullr.html
In addition, Joseph Elfelt maintains a list of many open government REST/Services:
PDF: https://mappingsupport.com/p/surf_gis/list-federal-state-county-
city-GIS-servers.pdf
txt file: https://mappingsupport.com/p/surf_gis/list-federal-state-county-city-GIS-servers.t
xt
csv file: https://mappingsupport.com/p/surf_gis/list-federal-state-county-city-GIS-servers.c
sv
An easier to read version can be found here: https://servers.cartobin.com/state/New%20York
Sometimes it’s useful to find what state contracts people have:
NY Open Book Contracts Search: wwe2.osc.state.ny.us/transparency/contracts/contractsearch.cfm
See how local governments like counties and cities send their money:
Local Government Reports: wwe2.osc.state.ny.us/transparency/LocalGov/LocalGovIntro.cfm
Many different data sets can be found on data.ny.gov