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.

https://gisservices.its.ny.gov/arcgis/rest/services/NYSTaxAssessmentLookup/GPServer/TaxAssessment/execute

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.