trees

Custom SQL query returning 15 rows (hide)

Query parameters

This data as json, CSV

rowidTreeIDqLegalStatus_idqSpecies_idqAddressSiteOrderqSiteInfoPlantTypeqCaretaker_idqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocationFire Prevention DistrictsPolice DistrictsSupervisor DistrictsZip CodesNeighborhoods (old)
170119 103480 7 53 1247 06th Ave 2 Sidewalk: Curb side : Cutout Tree 2     12 5x5 Permit Number 31998 5994182.5 2107061.8 37.765255754741 -122.463353999562 (37.765255754741, -122.463353999562) 11 5 11 56 12
135459 106967 4 53 1225 02ND AVE   Sidewalk: Curb side : Cutout Tree 2           5995419.1 2107212.6 37.7657409782079 -122.459087842629 (37.7657409782079, -122.459087842629) 15 5 11 56 12
36005 111369 4 53 724 IRVING ST 1 Sidewalk: Curb side : Cutout Tree 2       3x3   5993485 2106687 37.7641864431876 -122.465739233402 (37.7641864431876, -122.465739233402) 11 8 11 56 12
156343 113279 7 53 2 Hugo St 2 Sidewalk: Curb side : Cutout Tree 2       5x5   5995790.34429445 2107089.36315796 37.7654239364323 -122.457794878244 (37.7654239364323, -122.457794878244) 15 5 11 56 12
118732 117200 4 53 1321 23RD AVE 1 Sidewalk: Curb side : Cutout Tree 2     10 3x3   5988915 2106334 37.7629525336189 -122.481519510385 (37.7629525336189, -122.481519510385) 1 8 3 56 35
70103 121337 7 53 44 Hugo St 2 Sidewalk: Curb side : Cutout Tree 2       4x4   5995656.55399656 2107084.69972772 37.7654034448102 -122.458257287589 (37.7654034448102, -122.458257287589) 15 5 11 56 12
79333 33008 7 53 1311 06th Ave 1 Sidewalk: Curb side : Cutout Tree 2   11/05/1996 12:00:00 AM   6x4 Permit Number 37302 5994224.05093468 2106581.50911401 37.7639393951455 -122.463175433011 (37.7639393951455, -122.463175433011) 1 5 11 56 12
155542 54199 7 53 44 Hugo St 1 Sidewalk: Curb side : Cutout Tree 2   07/10/1972 12:00:00 AM   4x4 Permit Number 9937 5995656.55399656 2107084.69972772 37.7654034448102 -122.458257287589 (37.7654034448102, -122.458257287589) 15 5 11 56 12
140268 54410 7 53 1248 09th Ave 1 Sidewalk: Curb side : Cutout Tree 2   06/20/1972 12:00:00 AM     Permit Number 10182 5993332.64911234 2106987.54521442 37.765002872173 -122.46628801063 (37.765002872173, -122.46628801063) 11 8 11 56 12
124630 54736 7 53 1247 06th Ave 1 Sidewalk: Curb side : Cutout Tree 2   07/19/1993 12:00:00 AM 12 5x5 Permit Number 31998 5994208.55249488 2107032.01090972 37.7651754625969 -122.463261729084 (37.7651754625969, -122.463261729084) 11 5 11 56 12
140944 54742 7 53 1374 07th Ave 1 Sidewalk: Curb side : Cutout Tree 2   07/31/1972 12:00:00 AM   3x3 Permit Number 10588 5993980.75543943 2106156.09216002 37.7627572927027 -122.463986029849 (37.7627572927027, -122.463986029849) 1 5 11 56 12
49452 86740 7 53 1275 02nd Ave   Sidewalk: Curb side : Cutout Tree 2         Permit Number 49708 5995441.8 2106872.8 37.7648092803065 -122.458984723243 (37.7648092803065, -122.458984723243) 15 5 11 56 12
35372 94058 4 53 1401X 08th Ave 1 Sidewalk: Curb side : Cutout Tree 2     6 3x3   5993648 2105942 37.7621502689837 -122.465121353228 (37.7621502689837, -122.465121353228) 1 8 11 56 12
153860 94059 4 53 1401X 08th Ave 2 Sidewalk: Curb side : Cutout Tree 2     6 3x3   5993648 2105942 37.7621502689837 -122.465121353228 (37.7621502689837, -122.465121353228) 1 8 11 56 12
27991 97561 4 53 1251X 04th Ave 1 Sidewalk: Property side : Cutout Tree 2       3x3   5994791.4 2106981 37.7650689602603 -122.461242116604 (37.7650689602603, -122.461242116604) 15 5 11 56 12