Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, SiteOrder, qSiteInfo, qCaretaker, qCareAssistant, DBH, PlotSize
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord ▼ | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 137746 | 137746 | 118929 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 875 La Playa | 5 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 4ft | 5980750.23602 | 2109645.2788 | 37.7715662158284 | -122.510004109936 | (37.7715662158284, -122.510004109936) | |||
| 28260 | 28260 | 92446 | Permitted Site 1 | Afrocarpus gracilior :: Fern Pine 70 | 1554 46th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/30/2009 12:00:00 AM | 4 | 3x3 | Permit Number 52837 | 5981923.4 | 2104509.6 | 37.7575342433798 | -122.505565385243 | (37.7575342433798, -122.505565385243) |
| 119063 | 119063 | 86884 | Permitted Site 1 | Afrocarpus gracilior :: Fern Pine 70 | 2534 46th Ave | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/23/2007 12:00:00 AM | 3x3 | Permit Number 49809 | 5982151.4 | 2097835.7 | 37.73922299278121 | -122.504282496051 | (37.7392229927812, -122.504282496051) | |||
| 145266 | 145266 | 39223 | Permitted Site 1 | Afrocarpus gracilior :: Fern Pine 70 | 842 44th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/26/2000 12:00:00 AM | 1 | Permit Number 42693 | 5982336.537280001 | 2109997.98133 | 37.77262806827861 | -122.50454323337 | (37.7726280682786, -122.50454323337) | |
| 174700 | 174700 | 118571 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 7940 Geary Blvd | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 6 | 5982344.86422 | 2112440.78156 | 37.779335773230294 | -122.50469546097601 | (37.7793357732303, -122.504695460976) | ||||
| 65850 | 65850 | 92445 | Permitted Site 1 | Afrocarpus gracilior :: Fern Pine 70 | 2646 45th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/30/2009 12:00:00 AM | 5 | 3x3 | Permit Number 52836 | 5982487.2 | 2097095.3 | 37.737209800771296 | -122.503066669454 | (37.7372098007713, -122.503066669454) |
| 173180 | 173180 | 66747 | Permitted Site 1 | Afrocarpus gracilior :: Fern Pine 70 | 731 41st Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/02/1996 12:00:00 AM | 4 | Permit Number 32132 | 5983183.98032 | 2110807.82823 | 37.7749014841497 | -122.501671811672 | (37.7749014841497, -122.501671811672) | |
| 137603 | 137603 | 117918 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 731 41st Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 4ft | 5983185.43658 | 2110793.02592 | 37.774860926834606 | -122.501665678898 | (37.7748609268346, -122.501665678898) | |||
| 143032 | 143032 | 69035 | Permitted Site 1 | Afrocarpus gracilior :: Fern Pine 70 | 1407 38th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/06/1994 12:00:00 AM | Permit Number 33041 | 5984298.37219271 | 2105588.33319884 | 37.7606356257767 | -122.497431537078 | (37.7606356257767, -122.497431537078) | ||
| 65098 | 65098 | 92415 | Permitted Site 1 | Afrocarpus gracilior :: Fern Pine 70 | 1507 37th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/29/2009 12:00:00 AM | 0 | 3x3 | Permit Number 52808 | 5984617.9 | 2104898.8 | 37.758761083263 | -122.49627557459499 | (37.758761083263, -122.496275574595) |
| 84013 | 84013 | 92416 | Permitted Site 1 | Afrocarpus gracilior :: Fern Pine 70 | 1507 37th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/29/2009 12:00:00 AM | 3x3 | Permit Number 52808 | 5984617.9 | 2104898.8 | 37.758761083263 | -122.49627557459499 | (37.758761083263, -122.496275574595) | |
| 111926 | 111926 | 92417 | Permitted Site 1 | Afrocarpus gracilior :: Fern Pine 70 | 1579 37th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/29/2009 12:00:00 AM | 3x3 | Permit Number 52809 | 5984633.3 | 2104450.5 | 37.757531078434205 | -122.496189239645 | (37.7575310784342, -122.496189239645) | |
| 44557 | 44557 | 119343 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 462 32nd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 5985960.41468 | 2112779.42827 | 37.7804776215792 | -122.49221287963199 | (37.7804776215792, -122.492212879632) | |||
| 128844 | 128844 | 34278 | Permitted Site 1 | Afrocarpus gracilior :: Fern Pine 70 | 239 28th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/22/1997 12:00:00 AM | Permit Number 38235 | 5987102.15938314 | 2114264.59763142 | 37.784622151593794 | -122.48837227738501 | (37.7846221515938, -122.488372277385) | ||
| 77169 | 77169 | 34187 | Permitted Site 1 | Afrocarpus gracilior :: Fern Pine 70 | 2701 Lake St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/14/1997 12:00:00 AM | Permit Number 38079 | 5987120.3446635 | 2114449.05125045 | 37.785129669395104 | -122.488322923297 | (37.7851296693951, -122.488322923297) | ||
| 91942 | 91942 | 34190 | Permitted Site 1 | Afrocarpus gracilior :: Fern Pine 70 | 2701 Lake St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/14/1997 12:00:00 AM | Permit Number 38079 | 5987120.3446635 | 2114449.05125045 | 37.785129669395104 | -122.488322923297 | (37.7851296693951, -122.488322923297) | ||
| 102103 | 102103 | 34189 | Permitted Site 1 | Afrocarpus gracilior :: Fern Pine 70 | 2701 Lake St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/04/2010 12:00:00 AM | Permit Number 38079 | 5987120.3446635 | 2114449.05125045 | 37.785129669395104 | -122.488322923297 | (37.7851296693951, -122.488322923297) | ||
| 112894 | 112894 | 34186 | Permitted Site 1 | Afrocarpus gracilior :: Fern Pine 70 | 2701 Lake St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/14/1997 12:00:00 AM | Permit Number 38079 | 5987120.3446635 | 2114449.05125045 | 37.785129669395104 | -122.488322923297 | (37.7851296693951, -122.488322923297) | ||
| 122433 | 122433 | 34188 | Permitted Site 1 | Afrocarpus gracilior :: Fern Pine 70 | 2701 Lake St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/14/1997 12:00:00 AM | Permit Number 38079 | 5987120.3446635 | 2114449.05125045 | 37.785129669395104 | -122.488322923297 | (37.7851296693951, -122.488322923297) | ||
| 127638 | 127638 | 34191 | Permitted Site 1 | Afrocarpus gracilior :: Fern Pine 70 | 2701 Lake St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/14/1997 12:00:00 AM | Permit Number 38079 | 5987120.3446635 | 2114449.05125045 | 37.785129669395104 | -122.488322923297 | (37.7851296693951, -122.488322923297) | ||
| 129084 | 129084 | 34184 | Permitted Site 1 | Afrocarpus gracilior :: Fern Pine 70 | 2701 Lake St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/04/2010 12:00:00 AM | Permit Number 38079 | 5987120.3446635 | 2114449.05125045 | 37.785129669395104 | -122.488322923297 | (37.7851296693951, -122.488322923297) | ||
| 53779 | 53779 | 120025 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 743 28th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 4ft | 5987224.82866 | 2110876.6376900002 | 37.775326931785294 | -122.487698901899 | (37.7753269317853, -122.487698901899) | |||
| 64345 | 64345 | 35678 | Permitted Site 1 | Afrocarpus gracilior :: Fern Pine 70 | 373 26th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/08/1998 12:00:00 AM | 3 | Permit Number 39754 | 5987751.633830001 | 2113488.06207 | 37.7825278787916 | -122.486068320452 | (37.7825278787916, -122.486068320452) | ||
| 35258 | 35258 | 120266 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 100 24th Ave | 2 | Side Yard : Yard 17 | Tree 1 | Private 1 | 5 | 5988365.77159 | 2115120.59325 | 37.78704611790379 | -122.48406345051399 | (37.7870461179038, -122.484063450514) | ||||
| 152994 | 152994 | 37651 | Permitted Site 1 | Afrocarpus gracilior :: Fern Pine 70 | 1707 Balboa St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/26/1998 12:00:00 AM | 11 | Permit Number 40063 | 5990221.82835 | 2111258.8860400002 | 37.776550828957504 | -122.477359640658 | (37.7765508289575, -122.477359640658) | |
| 179368 | 179368 | 37653 | Permitted Site 1 | Afrocarpus gracilior :: Fern Pine 70 | 1707 Balboa St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/26/1998 12:00:00 AM | 4 | Permit Number 40063 | 5990244.837669999 | 2111259.2640400003 | 37.7765532018856 | -122.477280073273 | (37.7765532018856, -122.477280073273) | |
| 170476 | 170476 | 37652 | Permitted Site 1 | Afrocarpus gracilior :: Fern Pine 70 | 1707 Balboa St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/26/1998 12:00:00 AM | 5 | Permit Number 40063 | 5990267.40387 | 2111259.21957 | 37.7765543890648 | -122.477202007865 | (37.7765543890648, -122.477202007865) | |
| 58639 | 58639 | 203477 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 2331 18th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 5990713.76496 | 2099522.32344 | 37.7443538888309 | -122.47480105801701 | (37.7443538888309, -122.474801058017) | |||
| 175990 | 175990 | 203450 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 1515 16th Ave | 3 | Side Yard : Yard 17 | Tree 1 | Private 1 | 9 | Width 8ft | 5991181.21192 | 2105021.0246 | 37.7594789613077 | -122.47358576280001 | (37.7594789613077, -122.4735857628) | |||
| 157854 | 157854 | 203451 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 1515 16th Ave | 4 | Side Yard : Yard 17 | Tree 1 | Private 1 | 8 | Width 8ft | 5991183.11857 | 2105012.94014 | 37.7594568739424 | -122.473578579008 | (37.7594568739424, -122.473578579008) | |||
| 173419 | 173419 | 203452 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 1515 16th Ave | 5 | Side Yard : Yard 17 | Tree 1 | Private 1 | 10 | Width 8ft | 5991186.2272 | 2105007.12865 | 37.7594410971589 | -122.473567404026 | (37.7594410971589, -122.473567404026) | |||
| 24227 | 24227 | 203475 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 2357 16th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 8 | Width 3ft | 5991280.398630001 | 2099387.14513 | 37.7440155431828 | -122.472831922275 | (37.7440155431828, -122.472831922275) | |||
| 185557 | 185557 | 203448 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 1880 16th Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 5ft | 5991280.817840001 | 2102617.4638400003 | 37.752885184220204 | -122.473065997797 | (37.7528851842202, -122.473065997797) | |||
| 36428 | 36428 | 203476 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 2357 16th Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 7 | Width 3ft | 5991292.10233 | 2099373.67062 | 37.743979223173106 | -122.472790471621 | (37.7439792231731, -122.472790471621) | |||
| 28571 | 28571 | 203474 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 663 16th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 5991409.42461 | 2097303.39162 | 37.7383015575699 | -122.472233919881 | (37.7383015575699, -122.472233919881) | |||
| 105572 | 105572 | 50076 | Permitted Site 1 | Afrocarpus gracilior :: Fern Pine 70 | 2659 16th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/28/2003 12:00:00 AM | Permit Number 46808 | 5991410.12918009 | 2097327.15671334 | 37.738366851245104 | -122.472233215714 | (37.7383668512451, -122.472233215714) | ||
| 88563 | 88563 | 50078 | Permitted Site 1 | Afrocarpus gracilior :: Fern Pine 70 | 2663 16th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/28/2003 12:00:00 AM | Permit Number 46810 | 5991411.04399471 | 2097301.04699111 | 37.7382952135341 | -122.47222815003599 | (37.7382952135341, -122.472228150036) | ||
| 20258 | 20258 | 50073 | Permitted Site 1 | Afrocarpus gracilior :: Fern Pine 70 | 2622 16th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/28/2003 12:00:00 AM | Permit Number 46804 | 5991453.86395603 | 2097563.96514649 | 37.739019597898505 | -122.472099259809 | (37.7390195978985, -122.472099259809) | ||
| 31567 | 31567 | 203453 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 2658 16th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 5991457.8354 | 2097316.5348 | 37.738340446961104 | -122.47206749851001 | (37.7383404469611, -122.47206749851) | |||
| 82919 | 82919 | 50074 | Permitted Site 1 | Afrocarpus gracilior :: Fern Pine 70 | 2654 16th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/28/2003 12:00:00 AM | Permit Number 46807 | 5991461.18247601 | 2097355.08728319 | 37.7384464959625 | -122.472058735315 | (37.7384464959625, -122.472058735315) | ||
| 104293 | 104293 | 38940 | Permitted Site 1 | Afrocarpus gracilior :: Fern Pine 70 | 153 Lunado Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/02/1998 12:00:00 AM | Permit Number 40740 | 5991575.72353287 | 2092547.36275219 | 37.7252523189339 | -122.47131251444401 | (37.7252523189339, -122.471312514444) | ||
| 99946 | 99946 | 38942 | Permitted Site 1 | Afrocarpus gracilior :: Fern Pine 70 | 157 Lunado Way | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/03/1998 12:00:00 AM | Permit Number 40741 | 5991578.31713669 | 2092588.28918632 | 37.72536484280229 | -122.471306529261 | (37.7253648428023, -122.471306529261) | ||
| 120539 | 120539 | 38941 | Permitted Site 1 | Afrocarpus gracilior :: Fern Pine 70 | 157 Lunado Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/17/2001 12:00:00 AM | Permit Number 40741 | 5991578.31713669 | 2092588.28918632 | 37.72536484280229 | -122.471306529261 | (37.7253648428023, -122.471306529261) | ||
| 82144 | 82144 | 40782 | Permitted Site 1 | Afrocarpus gracilior :: Fern Pine 70 | 140 Lunado Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/16/1999 12:00:00 AM | Permit Number 41738 | 5991628.17520198 | 2092552.84395046 | 37.7252704029333 | -122.471131595058 | (37.7252704029333, -122.471131595058) | ||
| 111438 | 111438 | 38936 | Permitted Site 1 | Afrocarpus gracilior :: Fern Pine 70 | 144 Lunado Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/02/1998 12:00:00 AM | Permit Number 40738 | 5991631.60246352 | 2092606.92529954 | 37.725419095146606 | -122.471123685701 | (37.7254190951466, -122.471123685701) | ||
| 113313 | 113313 | 38937 | Permitted Site 1 | Afrocarpus gracilior :: Fern Pine 70 | 144 Lunado Way | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/02/1998 12:00:00 AM | Permit Number 40738 | 5991631.60246352 | 2092606.92529954 | 37.725419095146606 | -122.471123685701 | (37.7254190951466, -122.471123685701) | ||
| 116956 | 116956 | 45807 | Permitted Site 1 | Afrocarpus gracilior :: Fern Pine 70 | 1993 14th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/28/2001 12:00:00 AM | Permit Number 44435 | 5991886.15341897 | 2101900.86240585 | 37.7509526116716 | -122.47092045652599 | (37.7509526116716, -122.470920456526) | |||
| 86242 | 86242 | 42581 | Permitted Site 1 | Afrocarpus gracilior :: Fern Pine 70 | 175 San Rafael Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/26/2000 12:00:00 AM | Permit Number 42660 | 5991893.22788807 | 2095086.42724375 | 37.732242319303104 | -122.47039977177499 | (37.7322423193031, -122.470399771775) | ||
| 27160 | 27160 | 203449 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 1474 Funston Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 5992141.42239 | 2105406.9692 | 37.7605942249661 | -122.47029301742901 | (37.7605942249661, -122.470293017429) | |||
| 185548 | 185548 | 203447 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 327 Ralston St | 1 | : 4 | Tree 1 | Private 1 | 3 | Width 3ft | 5992190.092759999 | 2090032.52678 | 37.7183827154591 | -122.469005784505 | (37.7183827154591, -122.469005784505) | |||
| 40602 | 40602 | 203478 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 2453 Funston Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 5992323.79318 | 2098755.04508 | 37.74234030496479 | -122.469178135975 | (37.7423403049648, -122.469178135975) | |||
| 70578 | 70578 | 70577 | Permitted Site 1 | Afrocarpus gracilior :: Fern Pine 70 | 201 11th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/07/2008 12:00:00 AM | 3 | 4x4 | Permit Number 50063 | 5992415.28352 | 2114057.951 | 37.7843633240791 | -122.469975767472 | (37.7843633240791, -122.469975767472) | |
| 46755 | 46755 | 37601 | Permitted Site 1 | Afrocarpus gracilior :: Fern Pine 70 | 781 11th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/26/1998 12:00:00 AM | 11 | 6x9 | Permit Number 40028 | 5992556.63358 | 2110168.87379 | 37.7736931455181 | -122.469203595419 | (37.7736931455181, -122.469203595419) |
| 49575 | 49575 | 123145 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 562 10th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 5992857.65671 | 2111637.4840599997 | 37.7777429430313 | -122.468269178657 | (37.7777429430313, -122.468269178657) | |||
| 33827 | 33827 | 203454 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 5 Madrone Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 5993011.06637 | 2099068.7919400004 | 37.743241463417796 | -122.466824576891 | (37.7432414634178, -122.466824576891) | |||
| 164035 | 164035 | 203455 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 5 Madrone Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 5993020.02718 | 2099098.31016 | 37.7433230301343 | -122.466795738355 | (37.7433230301343, -122.466795738355) | |||
| 105569 | 105569 | 50096 | Permitted Site 1 | Afrocarpus gracilior :: Fern Pine 70 | 5 Madrone Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/28/2005 12:00:00 AM | Permit Number 47882 | 5993030.04532242 | 2099099.0201688 | 37.743325557815105 | -122.466761150098 | (37.7433255578151, -122.466761150098) | ||
| 142346 | 142346 | 46752 | Permitted Site 1 | Afrocarpus gracilior :: Fern Pine 70 | 375 Victoria St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/24/2002 12:00:00 AM | Permit Number 44854 | 5993218.00754376 | 2089670.83747573 | 37.7174489416695 | -122.465426481993 | (37.7174489416695, -122.465426481993) | ||
| 161024 | 161024 | 44822 | Permitted Site 1 | Afrocarpus gracilior :: Fern Pine 70 | 209 08th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/18/2001 12:00:00 AM | 1 | Permit Number 43915 | 5993346.02796 | 2114050.28592 | 37.784396036829705 | -122.46675518501101 | (37.7843960368297, -122.466755185011) | ||
| 91561 | 91561 | 33364 | Permitted Site 1 | Afrocarpus gracilior :: Fern Pine 70 | 65 Manor Dr | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/14/1996 12:00:00 AM | Permit Number 37497 | 5993537.09779252 | 2093371.5770822 | 37.7276286729381 | -122.46459211219299 | (37.7276286729381, -122.464592112193) | ||
| 145080 | 145080 | 33365 | Permitted Site 1 | Afrocarpus gracilior :: Fern Pine 70 | 65 Manor Dr | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/14/1996 12:00:00 AM | Permit Number 37497 | 5993537.09779252 | 2093371.5770822 | 37.7276286729381 | -122.46459211219299 | (37.7276286729381, -122.464592112193) | ||
| 178911 | 178911 | 203459 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 65 Manor Dr | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 2ft | 5993538.98145 | 2093351.56708 | 37.727573838962606 | -122.464584148065 | (37.7275738389626, -122.464584148065) | |||
| 167329 | 167329 | 203458 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 65 Manor Dr | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 2ft | 5993554.49033 | 2093381.1926 | 37.7276560774418 | -122.464532684353 | (37.7276560774418, -122.464532684353) | |||
| 107258 | 107258 | 33366 | Permitted Site 1 | Afrocarpus gracilior :: Fern Pine 70 | 89 Manor Dr | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/14/1996 12:00:00 AM | Permit Number 37498 | 5993623.03189123 | 2093524.69495183 | 37.728054050760896 | -122.464306151281 | (37.7280540507609, -122.464306151281) | ||
| 108145 | 108145 | 33367 | Permitted Site 1 | Afrocarpus gracilior :: Fern Pine 70 | 89 Manor Dr | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/14/1996 12:00:00 AM | Permit Number 37498 | 5993623.03189123 | 2093524.69495183 | 37.728054050760896 | -122.464306151281 | (37.7280540507609, -122.464306151281) | ||
| 126893 | 126893 | 203457 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 89 Manor Dr | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 2ft | 5993628.67358 | 2093513.96157 | 37.7280249047113 | -122.464285869009 | (37.7280249047113, -122.464285869009) | |||
| 163005 | 163005 | 203456 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 89 Manor Dr | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 2ft | 5993632.52713 | 2093523.8641700002 | 37.7280523169437 | -122.46427326591001 | (37.7280523169437, -122.46427326591) | |||
| 68669 | 68669 | 203481 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 90 Manor Dr | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 5993650.092119999 | 2093481.6421299998 | 37.7279373979817 | -122.464209479697 | (37.7279373979817, -122.464209479697) | |||
| 43774 | 43774 | 203480 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 90 Manor Dr | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 5993659.30191 | 2093497.00296 | 37.7279801058879 | -122.464178756148 | (37.7279801058879, -122.464178756148) | |||
| 121106 | 121106 | 102478 | Significant Tree 6 | Afrocarpus gracilior :: Fern Pine 70 | 760 Victoria St | 4 | Front Yard : Yard 7 | Tree 1 | Private 1 | 5993664.7 | 2092172.3 | 37.7243431058269 | -122.464063971167 | (37.7243431058269, -122.464063971167) | |||||
| 152920 | 152920 | 203479 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 90 Manor Dr | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 5993668.24229 | 2093512.36945 | 37.7280228137991 | -122.464148964325 | (37.7280228137991, -122.464148964325) | |||
| 89745 | 89745 | 33370 | Permitted Site 1 | Afrocarpus gracilior :: Fern Pine 70 | 90 Manor Dr | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/14/1996 12:00:00 AM | Permit Number 37499 | 5993674.94282707 | 2093510.9416498002 | 37.7280192795988 | -122.464125696941 | (37.7280192795988, -122.464125696941) | ||
| 108997 | 108997 | 33369 | Permitted Site 1 | Afrocarpus gracilior :: Fern Pine 70 | 90 Manor Dr | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/14/1996 12:00:00 AM | Permit Number 37499 | 5993674.94282707 | 2093510.9416498002 | 37.7280192795988 | -122.464125696941 | (37.7280192795988, -122.464125696941) | ||
| 118540 | 118540 | 33368 | Permitted Site 1 | Afrocarpus gracilior :: Fern Pine 70 | 90 Manor Dr | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/14/1996 12:00:00 AM | Permit Number 37499 | 5993674.94282707 | 2093510.9416498002 | 37.7280192795988 | -122.464125696941 | (37.7280192795988, -122.464125696941) | ||
| 170748 | 170748 | 203482 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 43 Dorado Ter | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 3ft | 5994625.10613 | 2092859.45738 | 37.726285178816205 | -122.460793782631 | (37.7262851788162, -122.460793782631) | |||
| 26400 | 26400 | 203471 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 410 Faxon Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | Width 1ft | 5994790.95036 | 2091337.27547 | 37.7221151744519 | -122.460110243003 | (37.7221151744519, -122.460110243003) | |||
| 187869 | 187869 | 203446 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 1 Marne Ave | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 2ft | 5995218.706569999 | 2097826.55093 | 37.739957742754704 | -122.459101255842 | (37.7399577427547, -122.459101255842) | |||
| 171195 | 171195 | 203445 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 1 Marne Ave | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 2ft | 5995218.972519999 | 2097817.06527 | 37.7399317127649 | -122.459099649629 | (37.7399317127649, -122.459099649629) | |||
| 178983 | 178983 | 203444 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 1 Marne Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 2ft | 5995221.104719999 | 2097808.00302 | 37.7399069526404 | -122.459091621397 | (37.7399069526404, -122.459091621397) | |||
| 54933 | 54933 | 203443 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 1 Marne Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 2ft | 5995223.6819 | 2097798.00617 | 37.7398796519151 | -122.459081986971 | (37.7398796519151, -122.459081986971) | |||
| 31097 | 31097 | 123452 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 735 02nd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 5995332.97895 | 2110593.9249 | 37.7750202604257 | -122.459630642924 | (37.7750202604257, -122.459630642924) | |||
| 157223 | 157223 | 123467 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 708 02nd Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 5995387.69315 | 2110690.84094 | 37.775289512367 | -122.45944839629601 | (37.775289512367, -122.459448396296) | |||
| 185700 | 185700 | 203483 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 459 Colon Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | Width 3ft | 5995499.06215 | 2095368.93495 | 37.733225844180105 | -122.457954104018 | (37.7332258441801, -122.457954104018) | |||
| 94135 | 94135 | 101466 | Significant Tree 6 | Afrocarpus gracilior :: Fern Pine 70 | 301 Hazelwood Ave | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 5996219.7 | 2095283.8 | 37.733033461480495 | -122.45545652663701 | (37.7330334614805, -122.455456526637) | |||||
| 97412 | 97412 | 50391 | Permitted Site 1 | Afrocarpus gracilior :: Fern Pine 70 | 295 Hazelwood Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/01/2003 12:00:00 AM | Permit Number 47042 | 5996257.45116044 | 2095209.02576685 | 37.732830315621705 | -122.455320609685 | (37.7328303156217, -122.455320609685) | ||
| 137268 | 137268 | 203489 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 296 Cresta Vista Dr | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 5996836.5401099995 | 2096166.78672 | 37.7354933057555 | -122.45338768751101 | (37.7354933057555, -122.453387687511) | |||
| 163571 | 163571 | 203488 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 296 Cresta Vista Dr | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 5996843.32855 | 2096168.5125900002 | 37.735498433689706 | -122.45336434200199 | (37.7354984336897, -122.453364342002) | |||
| 77178 | 77178 | 220638 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 222 Parnassus Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 7ft | 5997115.15152 | 2106725.56313 | 37.7645010544003 | -122.453186433611 | (37.7645010544003, -122.453186433611) | |||
| 142705 | 142705 | 96486 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 1202 Stanyan St | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 5997433.0 | 2105848.0 | 37.762109700699895 | -122.452023768999 | (37.7621097006999, -122.452023768999) | |||||
| 132131 | 132131 | 220639 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 1202 Stanyan St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 11 | Width 3ft | 5997451.780119999 | 2105807.14899 | 37.7619986098677 | -122.451955868771 | (37.7619986098677, -122.451955868771) | |||
| 189070 | 189070 | 203497 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 585 Mangels Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 5997548.43133 | 2095250.42463 | 37.733017974899504 | -122.45086036952299 | (37.7330179748995, -122.450860369523) | |||
| 173556 | 173556 | 246911 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 459 Frederick St | 2 | : 4 | Tree 1 | Private 1 | 3 | Width 3ft | 5997556.58518 | 2107424.48902 | 37.766445417441204 | -122.451710064262 | (37.7664454174412, -122.451710064262) | |||
| 173963 | 173963 | 203499 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 379 Staples Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 4ft | 5997569.0689199995 | 2093791.20398 | 37.7290124835419 | -122.45068384968799 | (37.7290124835419, -122.450683849688) | |||
| 60321 | 60321 | 203473 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 128 Howth St | 1 | : 4 | Tree 1 | Private 1 | 10 | Width 3ft | 5997584.72507 | 2091125.26044 | 37.7216933258806 | -122.450437617121 | (37.7216933258806, -122.450437617121) | |||
| 63274 | 63274 | 203472 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 126 Howth St | 1 | : 4 | Tree 1 | Private 1 | 5 | Width 3ft | 5997592.47815 | 2091138.0222 | 37.721728810427706 | -122.450411736413 | (37.7217288104277, -122.450411736413) | |||
| 124922 | 124922 | 17121 | Permitted Site 1 | Afrocarpus gracilior :: Fern Pine 70 | 1931 Oak St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 5997743.8504099995 | 2109170.01524 | 37.7712489089965 | -122.45118824582701 | (37.7712489089965, -122.451188245827) | |||
| 19541 | 19541 | 31130 | Permitted Site 1 | Afrocarpus gracilior :: Fern Pine 70 | 127 Foerster St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/21/1995 12:00:00 AM | 2 | 3x3 | Permit Number 34845 | 5998083.60465 | 2093967.1558599998 | 37.729525044927705 | -122.448917737661 | (37.7295250449277, -122.448917737661) |
| 28352 | 28352 | 125438 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 250 Euclid Ave | 0 | Front Yard : Yard 7 | Tree 1 | Private 1 | 15 | 5998091.24108 | 2114006.2469099998 | 37.78454782955 | -122.45033529224199 | (37.78454782955, -122.450335292242) | ||||
| 185062 | 185062 | 203496 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 531 Foerster St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 5998101.393730001 | 2095150.6752900002 | 37.732775726305206 | -122.448941459085 | (37.7327757263052, -122.448941459085) | |||
| 53096 | 53096 | 125439 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 99 Collins St | 0 | Side Yard : Yard 17 | Tree 1 | Private 1 | 7 | 5998117.25486 | 2114050.06951 | 37.7846696436241 | -122.450248453727 | (37.7846696436241, -122.450248453727) |
JSON shape: default, array, newline-delimited
CREATE TABLE "Street_Tree_List" (
"TreeID" INTEGER,
"qLegalStatus" INTEGER,
"qSpecies" INTEGER,
"qAddress" TEXT,
"SiteOrder" INTEGER,
"qSiteInfo" INTEGER,
"PlantType" INTEGER,
"qCaretaker" INTEGER,
"qCareAssistant" INTEGER,
"PlantDate" TEXT,
"DBH" INTEGER,
"PlotSize" TEXT,
"PermitNotes" TEXT,
"XCoord" REAL,
"YCoord" REAL,
"Latitude" REAL,
"Longitude" REAL,
"Location" TEXT
,
FOREIGN KEY ("PlantType") REFERENCES [PlantType](id),
FOREIGN KEY ("qCaretaker") REFERENCES [qCaretaker](id),
FOREIGN KEY ("qSpecies") REFERENCES [qSpecies](id),
FOREIGN KEY ("qSiteInfo") REFERENCES [qSiteInfo](id),
FOREIGN KEY ("qCareAssistant") REFERENCES [qCareAssistant](id),
FOREIGN KEY ("qLegalStatus") REFERENCES [qLegalStatus](id));
CREATE INDEX ["Street_Tree_List_PlantType"] ON [Street_Tree_List]("PlantType");
CREATE INDEX ["Street_Tree_List_qCaretaker"] ON [Street_Tree_List]("qCaretaker");
CREATE INDEX ["Street_Tree_List_qSpecies"] ON [Street_Tree_List]("qSpecies");
CREATE INDEX ["Street_Tree_List_qSiteInfo"] ON [Street_Tree_List]("qSiteInfo");
CREATE INDEX ["Street_Tree_List_qCareAssistant"] ON [Street_Tree_List]("qCareAssistant");
CREATE INDEX ["Street_Tree_List_qLegalStatus"] ON [Street_Tree_List]("qLegalStatus");