trees
292 rows where Supervisor Districts = 9 and qSpecies_id = 53 sorted by PlantDate descending
This data as json, CSV (advanced)
rowid | TreeID | qLegalStatus_id | qSpecies_id | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker_id | qCareAssistant | PlantDate ▲ | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location | Fire Prevention Districts | Police Districts | Supervisor Districts | Zip Codes | Neighborhoods (old) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
153446 | 44127 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 1455 Market St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/06/2000 12:00:00 AM | Permit Number 43631 | 6007204.94423628 | 2110535.86362082 | 37.7755363583765 | -122.418558723581 | (37.7755363583765, -122.418558723581) | 8 | 2 | 9 | 28853 | 34 | |||
20107 | 41196 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 500 16th St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/24/1999 12:00:00 AM | Permit Number 41907 | 6015636.41824938 | 2107244.95796966 | 37.7669713213554 | -122.389162129842 | (37.7669713213554, -122.389162129842) | 14 | 3 | 9 | 310 | 20 | ||
78771 | 41194 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 500 16th St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/24/1999 12:00:00 AM | Permit Number 41907 | 6015636.41824938 | 2107244.95796966 | 37.7669713213554 | -122.389162129842 | (37.7669713213554, -122.389162129842) | 14 | 3 | 9 | 310 | 20 | ||
79179 | 41198 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 500 16th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/24/1999 12:00:00 AM | Permit Number 41907 | 6015636.41824938 | 2107244.95796966 | 37.7669713213554 | -122.389162129842 | (37.7669713213554, -122.389162129842) | 14 | 3 | 9 | 310 | 20 | ||
82003 | 41199 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 500 16th St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/24/1999 12:00:00 AM | Permit Number 41907 | 6015636.41824938 | 2107244.95796966 | 37.7669713213554 | -122.389162129842 | (37.7669713213554, -122.389162129842) | 14 | 3 | 9 | 310 | 20 | ||
156118 | 41200 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 500 16th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/24/1999 12:00:00 AM | Permit Number 41907 | 6015636.41824938 | 2107244.95796966 | 37.7669713213554 | -122.389162129842 | (37.7669713213554, -122.389162129842) | 14 | 3 | 9 | 310 | 20 | ||
165827 | 41193 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 500 16th St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/24/1999 12:00:00 AM | Permit Number 41907 | 6015636.41824938 | 2107244.95796966 | 37.7669713213554 | -122.389162129842 | (37.7669713213554, -122.389162129842) | 14 | 3 | 9 | 310 | 20 | ||
176242 | 41192 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 500 16th St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/24/1999 12:00:00 AM | Permit Number 41907 | 6015636.41824938 | 2107244.95796966 | 37.7669713213554 | -122.389162129842 | (37.7669713213554, -122.389162129842) | 14 | 3 | 9 | 310 | 20 | ||
52966 | 66275 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 1065 Natoma St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/01/1990 12:00:00 AM | 3x3 | Permit Number 768678 | 6007678.31560988 | 2109516.6646006 | 37.7727645184447 | -122.416848989215 | (37.7727645184447, -122.416848989215) | 8 | 2 | 9 | 28853 | 19 | ||
66641 | 32646 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 379 TEHAMA ST | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/23/1996 12:00:00 AM | 8 | Permit Number 37086 | 6011447 | 2112547 | 37.7812963779039 | -122.404025912764 | (37.7812963779039, -122.404025912764) | 6 | 2 | 9 | 28853 | 34 | |
72803 | 32647 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 379 TEHAMA ST | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/23/1996 12:00:00 AM | 8 | Permit Number 37086 | 6011447 | 2112547 | 37.7812963779039 | -122.404025912764 | (37.7812963779039, -122.404025912764) | 6 | 2 | 9 | 28853 | 34 | |
140527 | 15263 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 1500 Mission St | 8 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 09/30/2008 12:00:00 AM | 12 | 3x3 | Permit Number 51766 | 6007587.5132074 | 2110099.4827033 | 37.7743596907053 | -122.417204392502 | (37.7743596907053, -122.417204392502) | 8 | 2 | 9 | 28853 | 19 | |
46738 | 113373 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 88 HOWARD ST | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/22/2015 12:00:00 AM | 3x3 | 6014757 | 2116474 | 37.7922633974731 | -122.39284966575 | (37.7922633974731, -122.39284966575) | 12 | 2 | 9 | 28855 | 6 | |||
40462 | 48697 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 405 Howard St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/19/2002 12:00:00 AM | Permit Number 45976 | 6014070.00775547 | 2115349.03612356 | 37.7891363266664 | -122.395147855931 | (37.7891363266664, -122.395147855931) | 6 | 2 | 9 | 28855 | 6 | |||
53416 | 48709 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 405 Howard St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/19/2002 12:00:00 AM | Permit Number 45976 | 6014070.00775547 | 2115349.03612356 | 37.7891363266664 | -122.395147855931 | (37.7891363266664, -122.395147855931) | 6 | 2 | 9 | 28855 | 6 | |||
70254 | 48702 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 405 Howard St | 14 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/19/2002 12:00:00 AM | Permit Number 45976 | 6014070.00775547 | 2115349.03612356 | 37.7891363266664 | -122.395147855931 | (37.7891363266664, -122.395147855931) | 6 | 2 | 9 | 28855 | 6 | |||
84798 | 48704 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 405 Howard St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/19/2002 12:00:00 AM | Permit Number 45976 | 6014070.00775547 | 2115349.03612356 | 37.7891363266664 | -122.395147855931 | (37.7891363266664, -122.395147855931) | 6 | 2 | 9 | 28855 | 6 | |||
95808 | 48700 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 405 Howard St | 12 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/19/2002 12:00:00 AM | Permit Number 45976 | 6014070.00775547 | 2115349.03612356 | 37.7891363266664 | -122.395147855931 | (37.7891363266664, -122.395147855931) | 6 | 2 | 9 | 28855 | 6 | |||
100582 | 48699 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 405 Howard St | 11 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/19/2002 12:00:00 AM | Permit Number 45976 | 6014070.00775547 | 2115349.03612356 | 37.7891363266664 | -122.395147855931 | (37.7891363266664, -122.395147855931) | 6 | 2 | 9 | 28855 | 6 | |||
132203 | 48698 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 405 Howard St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/19/2002 12:00:00 AM | Permit Number 45976 | 6014070.00775547 | 2115349.03612356 | 37.7891363266664 | -122.395147855931 | (37.7891363266664, -122.395147855931) | 6 | 2 | 9 | 28855 | 6 | |||
145539 | 48701 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 405 Howard St | 13 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/19/2002 12:00:00 AM | Permit Number 45976 | 6014070.00775547 | 2115349.03612356 | 37.7891363266664 | -122.395147855931 | (37.7891363266664, -122.395147855931) | 6 | 2 | 9 | 28855 | 6 | |||
168885 | 48703 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 405 Howard St | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/19/2002 12:00:00 AM | Permit Number 45976 | 6014070.00775547 | 2115349.03612356 | 37.7891363266664 | -122.395147855931 | (37.7891363266664, -122.395147855931) | 6 | 2 | 9 | 28855 | 6 | |||
61686 | 100705 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 220X 01st St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/05/2012 12:00:00 AM | 3x3 | Permit Number 768932 | 6013902 | 2115015 | 37.7882097965006 | -122.395705731652 | (37.7882097965006, -122.395705731652) | 6 | 2 | 9 | 28855 | 6 | ||
105004 | 100707 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 220X 01st St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/05/2012 12:00:00 AM | 3x3 | Permit Number 768932 | 6013902 | 2115015 | 37.7882097965006 | -122.395705731652 | (37.7882097965006, -122.395705731652) | 6 | 2 | 9 | 28855 | 6 | ||
132195 | 100706 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 220X 01st St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/05/2012 12:00:00 AM | 3x3 | Permit Number 768932 | 6013902 | 2115015 | 37.7882097965006 | -122.395705731652 | (37.7882097965006, -122.395705731652) | 6 | 2 | 9 | 28855 | 6 | ||
182718 | 100710 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 220X 01st St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/05/2012 12:00:00 AM | 3x3 | Permit Number 768932 | 6013902 | 2115015 | 37.7882097965006 | -122.395705731652 | (37.7882097965006, -122.395705731652) | 6 | 2 | 9 | 28855 | 6 | ||
188290 | 100708 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 220X 01st St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/05/2012 12:00:00 AM | 3x3 | Permit Number 768932 | 6013902 | 2115015 | 37.7882097965006 | -122.395705731652 | (37.7882097965006, -122.395705731652) | 6 | 2 | 9 | 28855 | 6 | ||
97368 | 64484 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 436 Bryant St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/19/1988 12:00:00 AM | Permit Number 778749 | 6014198.52964849 | 2112913.46772182 | 37.782455962378 | -122.39453256733 | (37.782455962378, -122.39453256733) | 6 | 2 | 9 | 28856 | 6 | |||
60538 | 32649 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 379 TEHAMA ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/28/2005 12:00:00 AM | 8 | Permit Number 37086 | 6011447 | 2112547 | 37.7812963779039 | -122.404025912764 | (37.7812963779039, -122.404025912764) | 6 | 2 | 9 | 28853 | 34 | |
83229 | 51761 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 379 Tehama St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/28/2005 12:00:00 AM | 8 | Permit Number 48028 | 6011451.43524212 | 2112543.5849209 | 37.781287248696 | -122.404010328515 | (37.781287248696, -122.404010328515) | 6 | 2 | 9 | 28853 | 34 | ||
182282 | 32648 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 379 TEHAMA ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/28/2005 12:00:00 AM | 8 | Permit Number 37086 | 6011447 | 2112547 | 37.7812963779039 | -122.404025912764 | (37.7812963779039, -122.404025912764) | 6 | 2 | 9 | 28853 | 34 | |
43665 | 94218 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 246 01st St | 3 | Sidewalk: Property side : Pot | Tree | Private 2 | 06/25/2010 12:00:00 AM | 2x3 | Permit Number 53568 | 6014001.8 | 2114912.7 | 37.7879344554838 | -122.395353268636 | (37.7879344554838, -122.395353268636) | 6 | 2 | 9 | 28855 | 6 | ||
59324 | 94216 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 1X Tehama St | 1 | Sidewalk: Property side : Pot | Tree | Private 2 | 06/25/2010 12:00:00 AM | 2x3 | Permit Number 53568 | 6013910.7 | 2114841.3 | 37.7877333404996 | -122.395663455814 | (37.7877333404996, -122.395663455814) | 6 | 2 | 9 | 28855 | 6 | ||
170512 | 94219 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 246 01st St | 4 | Sidewalk: Property side : Pot | Tree | Private 2 | 06/25/2010 12:00:00 AM | Permit Number 53568 | 6014001.8 | 2114912.7 | 37.7879344554838 | -122.395353268636 | (37.7879344554838, -122.395353268636) | 6 | 2 | 9 | 28855 | 6 | |||
187881 | 94217 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 246 01st St | 2 | Sidewalk: Property side : Pot | Tree | Private 2 | 06/25/2010 12:00:00 AM | 2x3 | Permit Number 53568 | 6014001.8 | 2114912.7 | 37.7879344554838 | -122.395353268636 | (37.7879344554838, -122.395353268636) | 6 | 2 | 9 | 28855 | 6 | ||
1212 | 40354 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 379 TEHAMA ST | 12 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/17/1999 12:00:00 AM | 8 | Permit Number 41479 | 6011447 | 2112547 | 37.7812963779039 | -122.404025912764 | (37.7812963779039, -122.404025912764) | 6 | 2 | 9 | 28853 | 34 | ||
2027 | 32641 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 379 TEHAMA ST | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/17/1999 12:00:00 AM | 8 | Permit Number 37086 | 6011447 | 2112547 | 37.7812963779039 | -122.404025912764 | (37.7812963779039, -122.404025912764) | 6 | 2 | 9 | 28853 | 34 | |
24140 | 32644 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 379 TEHAMA ST | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/17/1999 12:00:00 AM | 8 | Permit Number 37086 | 6011447 | 2112547 | 37.7812963779039 | -122.404025912764 | (37.7812963779039, -122.404025912764) | 6 | 2 | 9 | 28853 | 34 | |
24912 | 32645 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 379 TEHAMA ST | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/17/1999 12:00:00 AM | 8 | Permit Number 37086 | 6011447 | 2112547 | 37.7812963779039 | -122.404025912764 | (37.7812963779039, -122.404025912764) | 6 | 2 | 9 | 28853 | 34 | |
58892 | 40350 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 379 Tehama St | 11 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/17/1999 12:00:00 AM | 8 | Permit Number 41479 | 6011468.97735143 | 2112560.39183232 | 37.7813343766323 | -122.403950824176 | (37.7813343766323, -122.403950824176) | 6 | 2 | 9 | 28853 | 34 | ||
83380 | 40353 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 379 TEHAMA ST | 13 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/17/1999 12:00:00 AM | 8 | Permit Number 41479 | 6011447 | 2112547 | 37.7812963779039 | -122.404025912764 | (37.7812963779039, -122.404025912764) | 6 | 2 | 9 | 28853 | 34 | ||
153427 | 40357 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 379 TEHAMA ST | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/17/1999 12:00:00 AM | 8 | Permit Number 41479 | 6011447 | 2112547 | 37.7812963779039 | -122.404025912764 | (37.7812963779039, -122.404025912764) | 6 | 2 | 9 | 28853 | 34 | ||
182731 | 40355 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 379 TEHAMA ST | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/17/1999 12:00:00 AM | 8 | Permit Number 41479 | 6011447 | 2112547 | 37.7812963779039 | -122.404025912764 | (37.7812963779039, -122.404025912764) | 6 | 2 | 9 | 28853 | 34 | ||
147048 | 47565 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 920 Harrison St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/14/2002 12:00:00 AM | Permit Number 45425 | 6011901.71412119 | 2111593.71793264 | 37.7787042813354 | -122.402385767126 | (37.7787042813354, -122.402385767126) | 14 | 2 | 9 | 28856 | 34 | |||
159363 | 58908 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 353 10th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/07/1980 12:00:00 AM | 13 | 3x3 | Permit Number 780019 | 6009109.47745 | 2109280.29041 | 37.7721958858688 | -122.411881715065 | (37.7721958858688, -122.411881715065) | 8 | 2 | 9 | 28853 | 34 | |
3993 | 49288 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 2X Spear St | 19 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/07/2003 12:00:00 AM | Permit Number 46305 | 6014371 | 2116872 | 37.7933347653256 | -122.394213120763 | (37.7933347653256, -122.394213120763) | 12 | 2 | 9 | 28855 | 6 | |||
40156 | 49286 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 2X Spear St | 14 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/07/2003 12:00:00 AM | Permit Number 46305 | 6014371 | 2116872 | 37.7933347653256 | -122.394213120763 | (37.7933347653256, -122.394213120763) | 12 | 2 | 9 | 28855 | 6 | |||
45439 | 49260 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 2X Spear St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/07/2003 12:00:00 AM | Permit Number 46305 | 6014371 | 2116872 | 37.7933347653256 | -122.394213120763 | (37.7933347653256, -122.394213120763) | 12 | 2 | 9 | 28855 | 6 | |||
60857 | 49274 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 2X Spear St | 20 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/07/2003 12:00:00 AM | Permit Number 46305 | 6014371 | 2116872 | 37.7933347653256 | -122.394213120763 | (37.7933347653256, -122.394213120763) | 12 | 2 | 9 | 28855 | 6 | |||
69985 | 49269 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 2X Spear St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/07/2003 12:00:00 AM | Permit Number 46305 | 6014371 | 2116872 | 37.7933347653256 | -122.394213120763 | (37.7933347653256, -122.394213120763) | 12 | 2 | 9 | 28855 | 6 | |||
81758 | 49264 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 2X Spear St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/07/2003 12:00:00 AM | Permit Number 46305 | 6014371 | 2116872 | 37.7933347653256 | -122.394213120763 | (37.7933347653256, -122.394213120763) | 12 | 2 | 9 | 28855 | 6 | |||
91238 | 49276 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 2X Spear St | 16 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/07/2003 12:00:00 AM | Permit Number 46305 | 6014371 | 2116872 | 37.7933347653256 | -122.394213120763 | (37.7933347653256, -122.394213120763) | 12 | 2 | 9 | 28855 | 6 | |||
95381 | 49285 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 2X Spear St | 13 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/07/2003 12:00:00 AM | Permit Number 46305 | 6014371 | 2116872 | 37.7933347653256 | -122.394213120763 | (37.7933347653256, -122.394213120763) | 12 | 2 | 9 | 28855 | 6 | |||
95982 | 49266 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 2X Spear St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/07/2003 12:00:00 AM | Permit Number 46305 | 6014371 | 2116872 | 37.7933347653256 | -122.394213120763 | (37.7933347653256, -122.394213120763) | 12 | 2 | 9 | 28855 | 6 | |||
103493 | 49277 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 2X Spear St | 15 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/07/2003 12:00:00 AM | Permit Number 46305 | 6014371 | 2116872 | 37.7933347653256 | -122.394213120763 | (37.7933347653256, -122.394213120763) | 12 | 2 | 9 | 28855 | 6 | |||
117139 | 49290 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 2X Spear St | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/07/2003 12:00:00 AM | Permit Number 46305 | 6014371 | 2116872 | 37.7933347653256 | -122.394213120763 | (37.7933347653256, -122.394213120763) | 12 | 2 | 9 | 28855 | 6 | |||
118155 | 49258 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 2X Spear St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/07/2003 12:00:00 AM | Permit Number 46305 | 6014371 | 2116872 | 37.7933347653256 | -122.394213120763 | (37.7933347653256, -122.394213120763) | 12 | 2 | 9 | 28855 | 6 | |||
129463 | 49287 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 2X Spear St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/07/2003 12:00:00 AM | Permit Number 46305 | 6014371 | 2116872 | 37.7933347653256 | -122.394213120763 | (37.7933347653256, -122.394213120763) | 12 | 2 | 9 | 28855 | 6 | |||
136842 | 49263 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 2X Spear St | 17 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/07/2003 12:00:00 AM | Permit Number 46305 | 6014371 | 2116872 | 37.7933347653256 | -122.394213120763 | (37.7933347653256, -122.394213120763) | 12 | 2 | 9 | 28855 | 6 | |||
144032 | 49294 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 2X Spear St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/07/2003 12:00:00 AM | Permit Number 46305 | 6014371 | 2116872 | 37.7933347653256 | -122.394213120763 | (37.7933347653256, -122.394213120763) | 12 | 2 | 9 | 28855 | 6 | |||
147296 | 49297 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 2X Spear St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/07/2003 12:00:00 AM | Permit Number 46305 | 6014371 | 2116872 | 37.7933347653256 | -122.394213120763 | (37.7933347653256, -122.394213120763) | 12 | 2 | 9 | 28855 | 6 | |||
151649 | 49289 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 2X Spear St | 11 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/07/2003 12:00:00 AM | Permit Number 46305 | 6014371 | 2116872 | 37.7933347653256 | -122.394213120763 | (37.7933347653256, -122.394213120763) | 12 | 2 | 9 | 28855 | 6 | |||
172671 | 49251 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 2X Spear St | 18 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/07/2003 12:00:00 AM | Permit Number 46305 | 6014371 | 2116872 | 37.7933347653256 | -122.394213120763 | (37.7933347653256, -122.394213120763) | 12 | 2 | 9 | 28855 | 6 | |||
174050 | 49256 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 2X Spear St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/07/2003 12:00:00 AM | Permit Number 46305 | 6014371 | 2116872 | 37.7933347653256 | -122.394213120763 | (37.7933347653256, -122.394213120763) | 12 | 2 | 9 | 28855 | 6 | |||
177069 | 49259 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 2X Spear St | 12 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/07/2003 12:00:00 AM | Permit Number 46305 | 6014371 | 2116872 | 37.7933347653256 | -122.394213120763 | (37.7933347653256, -122.394213120763) | 12 | 2 | 9 | 28855 | 6 | |||
40083 | 49240 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 500 Howard St | 24 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/05/2003 12:00:00 AM | Permit Number 46300 | 6013774.5913005 | 2115138.38416874 | 37.7885414925604 | -122.396155198 | (37.7885414925604, -122.396155198) | 12 | 2 | 9 | 28855 | 6 | |||
45931 | 49235 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 500 Howard St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/05/2003 12:00:00 AM | Permit Number 46300 | 6013774.5913005 | 2115138.38416874 | 37.7885414925604 | -122.396155198 | (37.7885414925604, -122.396155198) | 12 | 2 | 9 | 28855 | 6 | |||
114688 | 49239 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 500 Howard St | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/05/2003 12:00:00 AM | Permit Number 46300 | 6013774.5913005 | 2115138.38416874 | 37.7885414925604 | -122.396155198 | (37.7885414925604, -122.396155198) | 12 | 2 | 9 | 28855 | 6 | |||
125521 | 49234 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 500 Howard St | 29 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/05/2003 12:00:00 AM | Permit Number 46300 | 6013774.5913005 | 2115138.38416874 | 37.7885414925604 | -122.396155198 | (37.7885414925604, -122.396155198) | 12 | 2 | 9 | 28855 | 6 | |||
128922 | 49236 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 500 Howard St | 21 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/05/2003 12:00:00 AM | Permit Number 46300 | 6013774.5913005 | 2115138.38416874 | 37.7885414925604 | -122.396155198 | (37.7885414925604, -122.396155198) | 12 | 2 | 9 | 28855 | 6 | |||
129993 | 49238 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 500 Howard St | 16 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/05/2003 12:00:00 AM | Permit Number 46300 | 6013774.5913005 | 2115138.38416874 | 37.7885414925604 | -122.396155198 | (37.7885414925604, -122.396155198) | 12 | 2 | 9 | 28855 | 6 | |||
156149 | 49237 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 500 Howard St | 18 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/05/2003 12:00:00 AM | Permit Number 46300 | 6013774.5913005 | 2115138.38416874 | 37.7885414925604 | -122.396155198 | (37.7885414925604, -122.396155198) | 12 | 2 | 9 | 28855 | 6 | |||
54273 | 41195 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 500 16th St | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/03/1996 12:00:00 AM | Permit Number 41907 | 6015636.41824938 | 2107244.95796966 | 37.7669713213554 | -122.389162129842 | (37.7669713213554, -122.389162129842) | 14 | 3 | 9 | 310 | 20 | ||
347 | 108327 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 86 11TH ST | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6007396 | 2110315 | 37.7749406737789 | -122.417882154347 | (37.7749406737789, -122.417882154347) | 8 | 2 | 9 | 28853 | 19 | ||||
371 | 251215 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 175X Otis St | 11 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3X3 | 6006718.5849914 | 2108715.6870946 | 37.7705111956623 | -122.420111956743 | (37.7705111956623, -122.420111956743) | 8 | 2 | 9 | 28853 | 19 | ||||
770 | 111807 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 50X COLUMBIA SQUARE ST | 4 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 3x3 | 6010857 | 2110997 | 37.7770074580074 | -122.405957810357 | (37.7770074580074, -122.405957810357) | 14 | 2 | 9 | 28853 | 34 | ||||
3630 | 258965 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 398x Bryant St | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 6014405 | 2113268 | 37.7834409032593 | -122.393843088876 | (37.7834409032593, -122.393843088876) | 6 | 2 | 9 | 28856 | 6 | ||||
5064 | 258966 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 398x Bryant St | 6 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 6014405 | 2113268 | 37.7834409032593 | -122.393843088876 | (37.7834409032593, -122.393843088876) | 6 | 2 | 9 | 28856 | 6 | ||||
5722 | 255886 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 50 Columbia Square St | 7 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | Private | 3x3 | 6010942 | 2111079 | 37.7772373644855 | -122.405669544588 | (37.7772373644855, -122.405669544588) | 14 | 2 | 9 | 28853 | 34 | |||
6188 | 111792 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 55X SHERMAN ST | 9 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 3x3 | 6010857 | 2110997 | 37.7770074580074 | -122.405957810357 | (37.7770074580074, -122.405957810357) | 14 | 2 | 9 | 28853 | 34 | ||||
6270 | 258961 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 398x Bryant St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 6014405 | 2113268 | 37.7834409032593 | -122.393843088876 | (37.7834409032593, -122.393843088876) | 6 | 2 | 9 | 28856 | 6 | ||||
7207 | 249360 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 601 Leavenworth St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 3ft | 6008338.71076 | 2114562.35621 | 37.7866559051821 | -122.41492178511 | (37.7866559051821, -122.41492178511) | 13 | 1 | 9 | 28858 | 36 | |||
8874 | 15149 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 895X Mission St | 3 | Sidewalk: Curb side : Cutout | Tree | Dept of Real Estate 7 | 12 | 4x4 | 6010810.7123748 | 2113108.5528643 | 37.7828026992214 | -122.406266743907 | (37.7828026992214, -122.406266743907) | 12 | 2 | 9 | 28853 | 34 | |||
9438 | 115058 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 499X BRANNAN ST | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6013762 | 2111312 | 37.7780344196247 | -122.395930522096 | (37.7780344196247, -122.395930522096) | 6 | 2 | 9 | 28856 | 34 | ||||
9626 | 258963 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 398x Bryant St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 6014405 | 2113268 | 37.7834409032593 | -122.393843088876 | (37.7834409032593, -122.393843088876) | 6 | 2 | 9 | 28856 | 6 | ||||
9664 | 258964 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 398x Bryant St | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 6014405 | 2113268 | 37.7834409032593 | -122.393843088876 | (37.7834409032593, -122.393843088876) | 6 | 2 | 9 | 28856 | 6 | ||||
10154 | 258967 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 398x Bryant St | 7 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 6014405 | 2113268 | 37.7834409032593 | -122.393843088876 | (37.7834409032593, -122.393843088876) | 6 | 2 | 9 | 28856 | 6 | ||||
11514 | 258968 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 398x Bryant St | 8 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 6014405 | 2113268 | 37.7834409032593 | -122.393843088876 | (37.7834409032593, -122.393843088876) | 6 | 2 | 9 | 28856 | 6 | ||||
15941 | 85313 | Significant Tree 6 | Ficus nitida :: Laurel Fig 53 | 610 Brannan St | 1 | unknown : Cutout | Tree | Private 2 | Permit Number 49594 | 6012704.2 | 2110820.8 | 37.7766267904106 | -122.399555358584 | (37.7766267904106, -122.399555358584) | 14 | 2 | 9 | 28856 | 34 | ||||
16987 | 17305 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 51X Otis St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3x3 | 6006870.5020453 | 2109341.6908091 | 37.7722386113234 | -122.419630895813 | (37.7722386113234, -122.419630895813) | 8 | 2 | 9 | 28853 | 19 | |||
17682 | 258962 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 398x Bryant St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 6014405 | 2113268 | 37.7834409032593 | -122.393843088876 | (37.7834409032593, -122.393843088876) | 6 | 2 | 9 | 28856 | 6 | ||||
18544 | 258969 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 398x Bryant St | 9 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 6014405 | 2113268 | 37.7834409032593 | -122.393843088876 | (37.7834409032593, -122.393843088876) | 6 | 2 | 9 | 28856 | 6 | ||||
18772 | 115057 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 499X BRANNAN ST | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6013762 | 2111312 | 37.7780344196247 | -122.395930522096 | (37.7780344196247, -122.395930522096) | 6 | 2 | 9 | 28856 | 34 | ||||
19070 | 15154 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 895X Mission St | 8 | Sidewalk: Curb side : Cutout | Tree | Dept of Real Estate 7 | 18 | 4x4 | 6010810.7123748 | 2113108.5528643 | 37.7828026992214 | -122.406266743907 | (37.7828026992214, -122.406266743907) | 12 | 2 | 9 | 28853 | 34 | |||
19705 | 95415 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 49X South Van Ness Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3x3 | Created record for this tree on 2/28/2011 although tree is approxmiately 20 years old. | 6007102.30356 | 2110018.85993 | 37.7741110108752 | -122.418877107651 | (37.7741110108752, -122.418877107651) | 8 | 2 | 9 | 28853 | 19 | ||
20034 | 255882 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 50 Columbia Square St | 3 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | Private | 3x3 | 6010942 | 2111079 | 37.7772373644855 | -122.405669544588 | (37.7772373644855, -122.405669544588) | 14 | 2 | 9 | 28853 | 34 | |||
20552 | 15171 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 941 Mission St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3X3 | 6010472.08374 | 2112774.72891 | 37.7818671496492 | -122.407414720255 | (37.7818671496492, -122.407414720255) | 14 | 2 | 9 | 28853 | 34 | |||
20820 | 111597 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 398X BRYANT ST | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6014483 | 2113360 | 37.7836978486164 | -122.393579678281 | (37.7836978486164, -122.393579678281) | 6 | 2 | 9 | 28856 | 6 | ||||
24565 | 10586 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 1050X Harrison St | 4 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 75 | 3X3 | 6011036.2882597 | 2110765.2479161 | 37.7763811461579 | -122.405321269139 | (37.7763811461579, -122.405321269139) | 14 | 2 | 9 | 28853 | 34 | |||
26170 | 124732 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 198X Division St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6010680 | 2108566 | 37.7703225929477 | -122.406398777104 | (37.7703225929477, -122.406398777104) | 14 | 2 | 9 | 28853 | 34 |
Advanced export
JSON shape: default, array, newline-delimited, object
CREATE TABLE "trees" ( [rowid] INTEGER PRIMARY KEY, [TreeID] TEXT, [qLegalStatus_id] INTEGER REFERENCES [qLegalStatus]([id]), [qSpecies_id] INTEGER, [qAddress] TEXT, [SiteOrder] TEXT, [qSiteInfo] TEXT, [PlantType] TEXT, [qCaretaker_id] INTEGER REFERENCES [qCaretaker]([id]), [qCareAssistant] TEXT, [PlantDate] TEXT, [DBH] TEXT, [PlotSize] TEXT, [PermitNotes] TEXT, [XCoord] TEXT, [YCoord] TEXT, [Latitude] TEXT, [Longitude] TEXT, [Location] TEXT, [Fire Prevention Districts] TEXT, [Police Districts] TEXT, [Supervisor Districts] TEXT, [Zip Codes] TEXT, [Neighborhoods (old)] TEXT, FOREIGN KEY(qSpecies_id) REFERENCES qSpecies(id) );