trees

Custom SQL query returning 33 rows (hide)

Query parameters

This data as json, CSV

rowidTreeIDqLegalStatus_idqSpecies_idqAddressSiteOrderqSiteInfoPlantTypeqCaretaker_idqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocationFire Prevention DistrictsPolice DistrictsSupervisor DistrictsZip CodesNeighborhoods (old)
143620 106469 4 66 100X HENRY ST 1 Sidewalk: Curb side : Cutout Tree 2     4 5x5   6002548 2107375 37.7665941299684 -122.434442151396 (37.7665941299684, -122.434442151396) 15 5 5 28862 3
161681 4313 1 66 727 Chenery St 1 Sidewalk: Curb side : Cutout Landscaping 1   08/17/2013 12:00:00 AM   3X3   6002321.25178 2095689.19659 37.7344948117373 -122.434390856497 (37.7344948117373, -122.434390856497) 2 7 5 63 7
28607 19363 1 66 738 Shields St 1 Sidewalk: Curb side : Cutout Tree 1     3 3X3   5992103.0127542 2089880.5617979 37.7179604248963 -122.469295726054 (37.7179604248963, -122.469295726054) 9 8 6 64 24
44868 37377 7 66 755 Morse St 11 Sidewalk: Property side : Cutout Tree 2 FUF 06/15/1998 12:00:00 AM 2 3x3 Permit Number 39872 5998400.39464019 2087052.25152553 37.7105564274343 -122.447325069993 (37.7105564274343, -122.447325069993) 9 7 6 28861 5
51790 37371 7 66 755 Morse St 5 Sidewalk: Property side : Cutout Tree 2 FUF 06/15/1998 12:00:00 AM 2 3x3 Permit Number 39872 5998400.39464019 2087052.25152553 37.7105564274343 -122.447325069993 (37.7105564274343, -122.447325069993) 9 7 6 28861 5
68664 94197 7 66 355 Ocean Ave 5 Sidewalk: Curb side : Cutout Tree 2   05/25/2010 12:00:00 AM   3x3 Permit Number 53723 5999419.6 2091436.9 37.7226538624451 -122.444117342662 (37.7226538624451, -122.444117342662) 9 7 6 28861 25
80964 15877 1 66 5508 Mission St 1 Sidewalk: Curb side : Cutout Tree 1   12/15/1997 12:00:00 AM 3 3X3   5999048.25069 2087729.15393 37.7124520473945 -122.445134579389 (37.7124520473945, -122.445134579389) 9 7 6 28861 25
92606 15888 1 66 5625 Mission St 1 Sidewalk: Curb side : Cutout Tree 1     3 3X3   5998561.46984 2087228.13524 37.7110485671916 -122.446781008521 (37.7110485671916, -122.446781008521) 9 7 6 28861 5
96160 94198 7 66 355 Ocean Ave 6 Sidewalk: Curb side : Cutout Tree 2   05/25/2010 12:00:00 AM   3x3 Permit Number 53723 5999419.6 2091436.9 37.7226538624451 -122.444117342662 (37.7226538624451, -122.444117342662) 9 7 6 28861 25
175412 37379 7 66 755 Morse St 13 Sidewalk: Property side : Cutout Tree 2 FUF 06/15/1998 12:00:00 AM 2 3x3 Permit Number 39872 5998400.39464019 2087052.25152553 37.7105564274343 -122.447325069993 (37.7105564274343, -122.447325069993) 9 7 6 28861 5
182004 99583 4 66 650X Brunswick St 23 Sidewalk: Curb side : Cutout Tree 2     3 3x6   5998578.4 2086902.6 37.710155688278 -122.446699086535 (37.710155688278, -122.446699086535) 9 7 6 28861 5
186666 65625 7 66 238 Ney St 1 Sidewalk: Curb side : Cutout Tree 2 FUF 02/07/1990 12:00:00 AM     Permit Number 28533 6004892.15539073 2094035.47955331 37.7300996701998 -122.425384739364 (37.7300996701998, -122.425384739364) 9 7 6 28861 5
186 30163 1 66 410X Mansell St 20 Median : Cutout Tree 1     0 POT   6010678.994322 2090457.626596 37.7206008798567 -122.405126964413 (37.7206008798567, -122.405126964413) 10 3 7 309 28
455 30164 1 66 410X Mansell St 21 Median : Cutout Tree 1     0 POT   6010678.994322 2090457.626596 37.7206008798567 -122.405126964413 (37.7206008798567, -122.405126964413) 10 3 7 309 28
1279 221708 1 66 222 Gates St 1 Sidewalk: Curb side : Cutout Tree 2     11 3x3   6008257.68745 2097584.33547 37.7400336302449 -122.41400058886 (37.7400336302449, -122.41400058886) 2 7 7 28859 2
3213 26499 1 66 2710 Harrison St 3 Sidewalk: Curb side : Cutout Tree 1     3 4x3   6008889.7812 2102567.01926 37.7537504562032 -122.412167121652 (37.7537504562032, -122.412167121652) 2 4 7 28859 19
14115 61098 7 66 806 Shotwell St 1 Sidewalk: Curb side : Cutout Tree 2 FUF 09/24/1988 12:00:00 AM   3x3 Permit Number 25594 6007925.06671696 2103219.75918175 37.7554885536992 -122.415549543793 (37.7554885536992, -122.415549543793) 2 4 7 28859 19
22629 106932 1 66 358 SHOTWELL ST 1 Sidewalk: Curb side : Cutout Landscaping 2       8x10   6007793.2 2105846.4 37.7626932925098 -122.416191600332 (37.7626932925098, -122.416191600332) 8 4 7 28859 19
28034 113803 7 66 806 SHOTWELL ST 2 Sidewalk: Curb side : Cutout Tree 2 FUF     3x3   6007931 2103220 37.755489548438 -122.415529041662 (37.755489548438, -122.415529041662) 2 4 7 28859 19
38858 98972 1 66 825 Shotwell St 6 Sidewalk: Curb side : Cutout Tree 4 DPW for City Agency   0 5x5   6008234.2 2102998.9 37.7548994960031 -122.414464835105 (37.7548994960031, -122.414464835105) 2 4 7 28859 19
43687 117610 1 66 391 NEVADA ST 1 Unaccepted Street : Yard Landscaping 2       3x3   6008958 2096497 37.7370873514658 -122.411502385785 (37.7370873514658, -122.411502385785) 10 7 7 28859 2
79158 30166 1 66 410X Mansell St 25 Median : Cutout Tree 1     0 POT   6010678.994322 2090457.626596 37.7206008798567 -122.405126964413 (37.7206008798567, -122.405126964413) 10 3 7 309 28
99453 30165 1 66 410X Mansell St 22 Median : Cutout Tree 1     0 POT   6010678.994322 2090457.626596 37.7206008798567 -122.405126964413 (37.7206008798567, -122.405126964413) 10 3 7 309 28
116531 30139 1 66 410X Mansell St 1 Median : Cutout Tree 1     0 POT   6010678.994322 2090457.626596 37.7206008798567 -122.405126964413 (37.7206008798567, -122.405126964413) 10 3 7 309 28
129104 30145 1 66 410X Mansell St 7 Median : Cutout Tree 1     0 POT   6010678.994322 2090457.626596 37.7206008798567 -122.405126964413 (37.7206008798567, -122.405126964413) 10 3 7 309 28
158368 30141 1 66 410X Mansell St 3 Median : Cutout Tree 1     0 POT   6010678.994322 2090457.626596 37.7206008798567 -122.405126964413 (37.7206008798567, -122.405126964413) 10 3 7 309 28
184604 30143 1 66 410X Mansell St 5 Median : Cutout Tree 1     0 POT   6010678.994322 2090457.626596 37.7206008798567 -122.405126964413 (37.7206008798567, -122.405126964413) 10 3 7 309 28
28264 4893 1 66 745X Mansell St 1 Sidewalk: Curb side : Cutout Tree 1     12 3X3   6009751.8988059 2090059.5024837 37.7194558413593 -122.408303589874 (37.7194558413593, -122.408303589874) 9 3 8 309 18
44729 114527 4 66 1 TIOGA AVE 3 Sidewalk: Curb side : Yard Tree 2           6011351 2088602 37.7155432513192 -122.402673611341 (37.7155432513192, -122.402673611341) 9 7 8 309 39
73123 119673 4 66 1207 De Haro St 1 Front Yard : Yard Tree 2           6012287 2102743 37.7544236952833 -122.400431054928 (37.7544236952833, -122.400431054928) 10 3 8 28856 29
76533 27143 1 66 1775 Silver Ave 4 Sidewalk: Curb side : Cutout Tree 1     12 2X3   6011388.84182 2095356.57174 37.7340920254878 -122.403017629645 (37.7340920254878, -122.403017629645) 10 3 8 58 1
88436 114528 4 66 1 TIOGA AVE 4 Sidewalk: Curb side : Yard Tree 2           6011351 2088602 37.7155432513192 -122.402673611341 (37.7155432513192, -122.402673611341) 9 7 8 309 39
154894 104034 4 66 722 Wisconsin St 1 Sidewalk: Curb side : Cutout Tree 2       3x3   6012694 2104139 37.7582794948464 -122.39912151779 (37.7582794948464, -122.39912151779) 10 3 8 28856 29