trees
665 rows where qSpecies_id = 89 sorted by XCoord
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2382 | 255210 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 1 Burrows St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | ||||||||||||||
9003 | 259743 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 1300x Quesada Ave | 1 | Side Yard : Cutout | Tree | DPW 1 | FUF | 10/13/2018 12:00:00 AM | 3 | ||||||||||||
14680 | 259744 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 1300x Quesada Ave | 2 | Side Yard : Cutout | Tree | DPW 1 | FUF | 10/13/2018 12:00:00 AM | 3 | ||||||||||||
14704 | 255211 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 7 Burrows St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | ||||||||||||||
15364 | 259745 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 1300x Quesada Ave | 3 | Side Yard : Cutout | Tree | DPW 1 | FUF | 10/13/2018 12:00:00 AM | 3 | ||||||||||||
27231 | 118929 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 875 La Playa | 5 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | Width 4ft | 5980750.23602 | 2109645.2788 | 37.7715662158284 | -122.510004109936 | (37.7715662158284, -122.510004109936) | 11 | 6 | 2 | 55 | 26 | |||
133085 | 92446 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 1554 46th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/30/2009 12:00:00 AM | 4 | 3x3 | Permit Number 52837 | 5981923.4 | 2104509.6 | 37.7575342433798 | -122.505565385243 | (37.7575342433798, -122.505565385243) | 1 | 8 | 3 | 56 | 35 |
159467 | 86884 | Permitted Site 7 | Afrocarpus gracilior :: Fern Pine 89 | 2534 46th Ave | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/23/2007 12:00:00 AM | 3x3 | Permit Number 49809 | 5982151.4 | 2097835.7 | 37.7392229927812 | -122.504282496051 | (37.7392229927812, -122.504282496051) | 1 | 8 | 3 | 29491 | 35 | |||
151616 | 39223 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 842 44th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/26/2000 12:00:00 AM | 1 | Permit Number 42693 | 5982336.53728 | 2109997.98133 | 37.7726280682786 | -122.50454323337 | (37.7726280682786, -122.50454323337) | 11 | 6 | 2 | 55 | 26 | |
34435 | 118571 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 7940 Geary Blvd | 1 | Back Yard : Yard | Tree | Private 2 | 6 | 5982344.86422 | 2112440.78156 | 37.7793357732303 | -122.504695460976 | (37.7793357732303, -122.504695460976) | 11 | 6 | 2 | 55 | 26 | ||||
177681 | 92445 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 2646 45th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/30/2009 12:00:00 AM | 5 | 3x3 | Permit Number 52836 | 5982487.2 | 2097095.3 | 37.7372098007713 | -122.503066669454 | (37.7372098007713, -122.503066669454) | 1 | 8 | 3 | 29491 | 35 |
3907 | 66747 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 731 41st Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/09/1993 12:00:00 AM | 4 | Permit Number 32132 | 5983183.98032 | 2110807.82823 | 37.7749014841497 | -122.501671811672 | (37.7749014841497, -122.501671811672) | 11 | 6 | 2 | 55 | 26 | |
98062 | 117918 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 731 41st Ave | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | Width 4ft | 5983185.43658 | 2110793.02592 | 37.7748609268346 | -122.501665678898 | (37.7748609268346, -122.501665678898) | 11 | 6 | 2 | 55 | 26 | |||
185576 | 69035 | Permitted Site 7 | Afrocarpus gracilior :: Fern Pine 89 | 1407 38th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/06/1994 12:00:00 AM | Permit Number 33041 | 5984298.37219271 | 2105588.33319884 | 37.7606356257767 | -122.497431537078 | (37.7606356257767, -122.497431537078) | 1 | 8 | 3 | 56 | 35 | ||
49047 | 92416 | Permitted Site 7 | Afrocarpus gracilior :: Fern Pine 89 | 1507 37th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/29/2009 12:00:00 AM | 3x3 | Permit Number 52808 | 5984617.9 | 2104898.8 | 37.758761083263 | -122.496275574595 | (37.758761083263, -122.496275574595) | 1 | 8 | 3 | 56 | 35 | |
131834 | 92415 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 1507 37th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/29/2009 12:00:00 AM | 0 | 3x3 | Permit Number 52808 | 5984617.9 | 2104898.8 | 37.758761083263 | -122.496275574595 | (37.758761083263, -122.496275574595) | 1 | 8 | 3 | 56 | 35 |
142633 | 92417 | Permitted Site 7 | Afrocarpus gracilior :: Fern Pine 89 | 1579 37th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/29/2009 12:00:00 AM | 3x3 | Permit Number 52809 | 5984633.3 | 2104450.5 | 37.7575310784342 | -122.496189239645 | (37.7575310784342, -122.496189239645) | 1 | 8 | 3 | 56 | 35 | |
110279 | 119343 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 462 32nd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 5985960.41468 | 2112779.42827 | 37.7804776215792 | -122.492212879632 | (37.7804776215792, -122.492212879632) | 11 | 6 | 2 | 55 | 26 | |||
30160 | 34278 | Permitted Site 7 | Afrocarpus gracilior :: Fern Pine 89 | 239 28th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/22/1997 12:00:00 AM | Permit Number 38235 | 5987102.15938314 | 2114264.59763142 | 37.7846221515938 | -122.488372277385 | (37.7846221515938, -122.488372277385) | 11 | 6 | 1 | 55 | 33 | ||
24509 | 34187 | Permitted Site 7 | Afrocarpus gracilior :: Fern Pine 89 | 2701 Lake St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/14/1997 12:00:00 AM | Permit Number 38079 | 5987120.3446635 | 2114449.05125045 | 37.7851296693951 | -122.488322923297 | (37.7851296693951, -122.488322923297) | 11 | 6 | 1 | 55 | 33 | ||
27673 | 34184 | Permitted Site 7 | Afrocarpus gracilior :: Fern Pine 89 | 2701 Lake St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/04/2010 12:00:00 AM | Permit Number 38079 | 5987120.3446635 | 2114449.05125045 | 37.7851296693951 | -122.488322923297 | (37.7851296693951, -122.488322923297) | 11 | 6 | 1 | 55 | 33 | ||
28791 | 34191 | Permitted Site 7 | Afrocarpus gracilior :: Fern Pine 89 | 2701 Lake St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/14/1997 12:00:00 AM | Permit Number 38079 | 5987120.3446635 | 2114449.05125045 | 37.7851296693951 | -122.488322923297 | (37.7851296693951, -122.488322923297) | 11 | 6 | 1 | 55 | 33 | ||
86838 | 34190 | Permitted Site 7 | Afrocarpus gracilior :: Fern Pine 89 | 2701 Lake St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/14/1997 12:00:00 AM | Permit Number 38079 | 5987120.3446635 | 2114449.05125045 | 37.7851296693951 | -122.488322923297 | (37.7851296693951, -122.488322923297) | 11 | 6 | 1 | 55 | 33 | ||
95499 | 34189 | Permitted Site 7 | Afrocarpus gracilior :: Fern Pine 89 | 2701 Lake St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/04/2010 12:00:00 AM | Permit Number 38079 | 5987120.3446635 | 2114449.05125045 | 37.7851296693951 | -122.488322923297 | (37.7851296693951, -122.488322923297) | 11 | 6 | 1 | 55 | 33 | ||
150762 | 34186 | Permitted Site 7 | Afrocarpus gracilior :: Fern Pine 89 | 2701 Lake St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/14/1997 12:00:00 AM | Permit Number 38079 | 5987120.3446635 | 2114449.05125045 | 37.7851296693951 | -122.488322923297 | (37.7851296693951, -122.488322923297) | 11 | 6 | 1 | 55 | 33 | ||
165775 | 34188 | Permitted Site 7 | Afrocarpus gracilior :: Fern Pine 89 | 2701 Lake St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/14/1997 12:00:00 AM | Permit Number 38079 | 5987120.3446635 | 2114449.05125045 | 37.7851296693951 | -122.488322923297 | (37.7851296693951, -122.488322923297) | 11 | 6 | 1 | 55 | 33 | ||
45630 | 120025 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 743 28th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 4ft | 5987224.82866 | 2110876.63769 | 37.7753269317853 | -122.487698901899 | (37.7753269317853, -122.487698901899) | 11 | 6 | 2 | 55 | 26 | |||
135510 | 35678 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 373 26th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/08/1998 12:00:00 AM | 3 | Permit Number 39754 | 5987751.63383 | 2113488.06207 | 37.7825278787916 | -122.486068320452 | (37.7825278787916, -122.486068320452) | 11 | 6 | 2 | 55 | 26 | ||
44125 | 120266 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 100 24th Ave | 2 | Side Yard : Yard | Tree | Private 2 | 5 | 5988365.77159 | 2115120.59325 | 37.7870461179038 | -122.484063450514 | (37.7870461179038, -122.484063450514) | 11 | 6 | 1 | 55 | 33 | ||||
7190 | 120690 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 358 22nd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/14/2018 12:00:00 AM | 3 | Width 4ft | Permit Number 782203 | 5989057.83806 | 2112937.05315 | 37.7810910000946 | -122.481509105367 | (37.7810910000946, -122.481509105367) | 11 | 6 | 2 | 55 | 26 | |
163458 | 37651 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 1707 Balboa St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/26/1998 12:00:00 AM | 11 | Permit Number 40063 | 5990221.82835 | 2111258.88604 | 37.7765508289575 | -122.477359640658 | (37.7765508289575, -122.477359640658) | 11 | 6 | 2 | 55 | 26 | |
19869 | 37653 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 1707 Balboa St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/26/1998 12:00:00 AM | 4 | Permit Number 40063 | 5990244.83767 | 2111259.26404 | 37.7765532018856 | -122.477280073273 | (37.7765532018856, -122.477280073273) | 11 | 6 | 2 | 55 | 26 | |
105438 | 37652 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 1707 Balboa St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/26/1998 12:00:00 AM | 5 | Permit Number 40063 | 5990267.40387 | 2111259.21957 | 37.7765543890648 | -122.477202007865 | (37.7765543890648, -122.477202007865) | 11 | 6 | 2 | 55 | 26 | |
131502 | 203477 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 2331 18th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 5990713.76496 | 2099522.32344 | 37.7443538888309 | -122.474801058017 | (37.7443538888309, -122.474801058017) | 1 | 8 | 4 | 29491 | 40 | |||
153760 | 203450 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 1515 16th Ave | 3 | Side Yard : Yard | Tree | Private 2 | 9 | Width 8ft | 5991181.21192 | 2105021.0246 | 37.7594789613077 | -122.4735857628 | (37.7594789613077, -122.4735857628) | 1 | 8 | 4 | 56 | 12 | |||
43086 | 203451 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 1515 16th Ave | 4 | Side Yard : Yard | Tree | Private 2 | 8 | Width 8ft | 5991183.11857 | 2105012.94014 | 37.7594568739424 | -122.473578579008 | (37.7594568739424, -122.473578579008) | 1 | 8 | 4 | 56 | 12 | |||
113481 | 203452 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 1515 16th Ave | 5 | Side Yard : Yard | Tree | Private 2 | 10 | Width 8ft | 5991186.2272 | 2105007.12865 | 37.7594410971589 | -122.473567404026 | (37.7594410971589, -122.473567404026) | 1 | 8 | 4 | 56 | 12 | |||
130229 | 203475 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 2357 16th Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 8 | Width 3ft | 5991280.39863 | 2099387.14513 | 37.7440155431828 | -122.472831922275 | (37.7440155431828, -122.472831922275) | 1 | 8 | 4 | 29491 | 40 | |||
165325 | 203448 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 1880 16th Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | Width 5ft | 5991280.81784 | 2102617.46384 | 37.7528851842202 | -122.473065997797 | (37.7528851842202, -122.473065997797) | 1 | 8 | 4 | 56 | 12 | |||
129489 | 203476 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 2357 16th Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 7 | Width 3ft | 5991292.10233 | 2099373.67062 | 37.7439792231731 | -122.472790471621 | (37.7439792231731, -122.472790471621) | 1 | 8 | 4 | 29491 | 40 | |||
142886 | 203474 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 663 16th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 5991409.42461 | 2097303.39162 | 37.7383015575699 | -122.472233919881 | (37.7383015575699, -122.472233919881) | 1 | 8 | 4 | 29491 | 40 | |||
116961 | 50076 | Permitted Site 7 | Afrocarpus gracilior :: Fern Pine 89 | 2659 16th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/28/2003 12:00:00 AM | Permit Number 46808 | 5991410.12918009 | 2097327.15671334 | 37.7383668512451 | -122.472233215714 | (37.7383668512451, -122.472233215714) | 1 | 8 | 4 | 29491 | 40 | ||
68653 | 50078 | Permitted Site 7 | Afrocarpus gracilior :: Fern Pine 89 | 2663 16th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/28/2003 12:00:00 AM | Permit Number 46810 | 5991411.04399471 | 2097301.04699111 | 37.7382952135341 | -122.472228150036 | (37.7382952135341, -122.472228150036) | 1 | 8 | 4 | 29491 | 40 | ||
5122 | 50073 | Permitted Site 7 | Afrocarpus gracilior :: Fern Pine 89 | 2622 16th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/28/2003 12:00:00 AM | Permit Number 46804 | 5991453.86395603 | 2097563.96514649 | 37.7390195978985 | -122.472099259809 | (37.7390195978985, -122.472099259809) | 1 | 8 | 4 | 29491 | 40 | ||
126408 | 203453 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 2658 16th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 5991457.8354 | 2097316.5348 | 37.7383404469611 | -122.47206749851 | (37.7383404469611, -122.47206749851) | 1 | 8 | 4 | 29491 | 40 | |||
53152 | 50074 | Permitted Site 7 | Afrocarpus gracilior :: Fern Pine 89 | 2654 16th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/28/2003 12:00:00 AM | Permit Number 46807 | 5991461.18247601 | 2097355.08728319 | 37.7384464959625 | -122.472058735315 | (37.7384464959625, -122.472058735315) | 1 | 8 | 4 | 29491 | 40 | ||
122238 | 254735 | Significant Tree 6 | Afrocarpus gracilior :: Fern Pine 89 | 363 14th Ave | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | Permit Number 781538 | 5991507 | 2112990 | 37.781378479082 | -122.473040175374 | (37.781378479082, -122.473040175374) | 11 | 6 | 2 | 54 | 26 | ||||
131045 | 38940 | Permitted Site 7 | Afrocarpus gracilior :: Fern Pine 89 | 153 Lunado Way | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/02/1998 12:00:00 AM | Permit Number 40740 | 5991575.72353287 | 2092547.36275219 | 37.7252523189339 | -122.471312514444 | (37.7252523189339, -122.471312514444) | 9 | 8 | 4 | 59 | 40 | ||
97585 | 38942 | Permitted Site 7 | Afrocarpus gracilior :: Fern Pine 89 | 157 Lunado Way | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/03/1998 12:00:00 AM | Permit Number 40741 | 5991578.31713669 | 2092588.28918632 | 37.7253648428023 | -122.471306529261 | (37.7253648428023, -122.471306529261) | 9 | 8 | 4 | 59 | 40 | ||
152789 | 38941 | Permitted Site 7 | Afrocarpus gracilior :: Fern Pine 89 | 157 Lunado Way | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/17/2001 12:00:00 AM | Permit Number 40741 | 5991578.31713669 | 2092588.28918632 | 37.7253648428023 | -122.471306529261 | (37.7253648428023, -122.471306529261) | 9 | 8 | 4 | 59 | 40 | ||
45637 | 40782 | Permitted Site 7 | Afrocarpus gracilior :: Fern Pine 89 | 140 Lunado Way | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/16/1999 12:00:00 AM | Permit Number 41738 | 5991628.17520198 | 2092552.84395046 | 37.7252704029333 | -122.471131595058 | (37.7252704029333, -122.471131595058) | 9 | 8 | 4 | 59 | 40 | ||
134140 | 38936 | Permitted Site 7 | Afrocarpus gracilior :: Fern Pine 89 | 144 Lunado Way | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/02/1998 12:00:00 AM | Permit Number 40738 | 5991631.60246352 | 2092606.92529954 | 37.7254190951466 | -122.471123685701 | (37.7254190951466, -122.471123685701) | 9 | 8 | 4 | 59 | 40 | ||
148923 | 38937 | Permitted Site 7 | Afrocarpus gracilior :: Fern Pine 89 | 144 Lunado Way | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/02/1998 12:00:00 AM | Permit Number 40738 | 5991631.60246352 | 2092606.92529954 | 37.7254190951466 | -122.471123685701 | (37.7254190951466, -122.471123685701) | 9 | 8 | 4 | 59 | 40 | ||
170131 | 45807 | Permitted Site 7 | Afrocarpus gracilior :: Fern Pine 89 | 1993 14th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/28/2001 12:00:00 AM | Permit Number 44435 | 5991886.15341897 | 2101900.86240585 | 37.7509526116716 | -122.470920456526 | (37.7509526116716, -122.470920456526) | 1 | 8 | 4 | 29491 | 12 | |||
59057 | 42581 | Permitted Site 7 | Afrocarpus gracilior :: Fern Pine 89 | 175 San Rafael Way | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/26/2000 12:00:00 AM | Permit Number 42660 | 5991893.22788807 | 2095086.42724375 | 37.7322423193031 | -122.470399771775 | (37.7322423193031, -122.470399771775) | 9 | 8 | 4 | 59 | 40 | ||
160014 | 203449 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 1474 Funston Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 5992141.42239 | 2105406.9692 | 37.7605942249661 | -122.470293017429 | (37.7605942249661, -122.470293017429) | 1 | 8 | 4 | 56 | 12 | |||
116310 | 203447 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 327 Ralston St | 1 | : | Tree | Private 2 | 3 | Width 3ft | 5992190.09276 | 2090032.52678 | 37.7183827154591 | -122.469005784505 | (37.7183827154591, -122.469005784505) | 9 | 8 | 6 | 64 | 24 | |||
192901 | 203478 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 2453 Funston Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 5992323.79318 | 2098755.04508 | 37.7423403049648 | -122.469178135975 | (37.7423403049648, -122.469178135975) | 1 | 8 | 4 | 29491 | 40 | |||
89307 | 70577 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 201 11th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/07/2008 12:00:00 AM | 3 | 4x4 | Permit Number 50063 | 5992415.28352 | 2114057.951 | 37.7843633240791 | -122.469975767472 | (37.7843633240791, -122.469975767472) | 11 | 6 | 2 | 54 | 11 | |
169473 | 37601 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 781 11th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/26/1998 12:00:00 AM | 11 | 6x9 | Permit Number 40028 | 5992556.63358 | 2110168.87379 | 37.7736931455181 | -122.469203595419 | (37.7736931455181, -122.469203595419) | 11 | 6 | 2 | 54 | 11 |
131258 | 123145 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 562 10th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 5992857.65671 | 2111637.48406 | 37.7777429430313 | -122.468269178657 | (37.7777429430313, -122.468269178657) | 11 | 6 | 2 | 54 | 11 | |||
76087 | 203454 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 5 Madrone Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 5993011.06637 | 2099068.79194 | 37.7432414634178 | -122.466824576891 | (37.7432414634178, -122.466824576891) | 1 | 8 | 4 | 59 | 40 | |||
192377 | 203455 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 5 Madrone Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 5993020.02718 | 2099098.31016 | 37.7433230301343 | -122.466795738355 | (37.7433230301343, -122.466795738355) | 1 | 8 | 4 | 59 | 40 | |||
129213 | 50096 | Permitted Site 7 | Afrocarpus gracilior :: Fern Pine 89 | 5 Madrone Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/28/2005 12:00:00 AM | Permit Number 47882 | 5993030.04532242 | 2099099.0201688 | 37.7433255578151 | -122.466761150098 | (37.7433255578151, -122.466761150098) | 1 | 8 | 4 | 59 | 40 | ||
184137 | 46752 | Permitted Site 7 | Afrocarpus gracilior :: Fern Pine 89 | 375 Victoria St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/24/2002 12:00:00 AM | Permit Number 44854 | 5993218.00754376 | 2089670.83747573 | 37.7174489416695 | -122.465426481993 | (37.7174489416695, -122.465426481993) | 9 | 8 | 6 | 64 | 24 | ||
82943 | 44822 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 209 08th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/18/2001 12:00:00 AM | 1 | Permit Number 43915 | 5993346.02796 | 2114050.28592 | 37.7843960368297 | -122.466755185011 | (37.7843960368297, -122.466755185011) | 11 | 6 | 2 | 54 | 11 | ||
84592 | 33364 | Permitted Site 7 | Afrocarpus gracilior :: Fern Pine 89 | 65 Manor Dr | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/14/1996 12:00:00 AM | Permit Number 37497 | 5993537.09779252 | 2093371.5770822 | 37.7276286729381 | -122.464592112193 | (37.7276286729381, -122.464592112193) | 9 | 8 | 4 | 59 | 40 | ||
189904 | 33365 | Permitted Site 7 | Afrocarpus gracilior :: Fern Pine 89 | 65 Manor Dr | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/14/1996 12:00:00 AM | Permit Number 37497 | 5993537.09779252 | 2093371.5770822 | 37.7276286729381 | -122.464592112193 | (37.7276286729381, -122.464592112193) | 9 | 8 | 4 | 59 | 40 | ||
159786 | 203459 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 65 Manor Dr | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 2ft | 5993538.98145 | 2093351.56708 | 37.7275738389626 | -122.464584148065 | (37.7275738389626, -122.464584148065) | 9 | 8 | 4 | 59 | 40 | |||
62496 | 203458 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 65 Manor Dr | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 2ft | 5993554.49033 | 2093381.1926 | 37.7276560774418 | -122.464532684353 | (37.7276560774418, -122.464532684353) | 9 | 8 | 4 | 59 | 40 | |||
127734 | 33366 | Permitted Site 7 | Afrocarpus gracilior :: Fern Pine 89 | 89 Manor Dr | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/14/1996 12:00:00 AM | Permit Number 37498 | 5993623.03189123 | 2093524.69495183 | 37.7280540507609 | -122.464306151281 | (37.7280540507609, -122.464306151281) | 9 | 8 | 4 | 59 | 40 | ||
127927 | 33367 | Permitted Site 7 | Afrocarpus gracilior :: Fern Pine 89 | 89 Manor Dr | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/14/1996 12:00:00 AM | Permit Number 37498 | 5993623.03189123 | 2093524.69495183 | 37.7280540507609 | -122.464306151281 | (37.7280540507609, -122.464306151281) | 9 | 8 | 4 | 59 | 40 | ||
64501 | 203457 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 89 Manor Dr | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 2ft | 5993628.67358 | 2093513.96157 | 37.7280249047113 | -122.464285869009 | (37.7280249047113, -122.464285869009) | 9 | 8 | 4 | 59 | 40 | |||
114646 | 203456 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 89 Manor Dr | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 2ft | 5993632.52713 | 2093523.86417 | 37.7280523169437 | -122.46427326591 | (37.7280523169437, -122.46427326591) | 9 | 8 | 4 | 59 | 40 | |||
109866 | 203481 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 90 Manor Dr | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 5993650.09212 | 2093481.64213 | 37.7279373979817 | -122.464209479697 | (37.7279373979817, -122.464209479697) | 9 | 8 | 4 | 59 | 40 | |||
116295 | 203480 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 90 Manor Dr | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 5993659.30191 | 2093497.00296 | 37.7279801058879 | -122.464178756148 | (37.7279801058879, -122.464178756148) | 9 | 8 | 4 | 59 | 40 | |||
155948 | 102478 | Significant Tree 6 | Afrocarpus gracilior :: Fern Pine 89 | 760 Victoria St | 4 | Front Yard : Yard | Tree | Private 2 | 5993664.7 | 2092172.3 | 37.7243431058269 | -122.464063971167 | (37.7243431058269, -122.464063971167) | 9 | 8 | 4 | 59 | 40 | |||||
137655 | 203479 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 90 Manor Dr | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 5993668.24229 | 2093512.36945 | 37.7280228137991 | -122.464148964325 | (37.7280228137991, -122.464148964325) | 9 | 8 | 4 | 59 | 40 | |||
60502 | 33370 | Permitted Site 7 | Afrocarpus gracilior :: Fern Pine 89 | 90 Manor Dr | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/14/1996 12:00:00 AM | Permit Number 37499 | 5993674.94282707 | 2093510.9416498 | 37.7280192795988 | -122.464125696941 | (37.7280192795988, -122.464125696941) | 9 | 8 | 4 | 59 | 40 | ||
126772 | 33369 | Permitted Site 7 | Afrocarpus gracilior :: Fern Pine 89 | 90 Manor Dr | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/14/1996 12:00:00 AM | Permit Number 37499 | 5993674.94282707 | 2093510.9416498 | 37.7280192795988 | -122.464125696941 | (37.7280192795988, -122.464125696941) | 9 | 8 | 4 | 59 | 40 | ||
167613 | 33368 | Permitted Site 7 | Afrocarpus gracilior :: Fern Pine 89 | 90 Manor Dr | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/14/1996 12:00:00 AM | Permit Number 37499 | 5993674.94282707 | 2093510.9416498 | 37.7280192795988 | -122.464125696941 | (37.7280192795988, -122.464125696941) | 9 | 8 | 4 | 59 | 40 | ||
173833 | 203482 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 43 Dorado Ter | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 3ft | 5994625.10613 | 2092859.45738 | 37.7262851788162 | -122.460793782631 | (37.7262851788162, -122.460793782631) | 9 | 8 | 4 | 28861 | 40 | |||
164597 | 203471 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 410 Faxon Ave | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 7 | Width 1ft | 5994790.95036 | 2091337.27547 | 37.7221151744519 | -122.460110243003 | (37.7221151744519, -122.460110243003) | 9 | 8 | 4 | 28861 | 24 | |||
117582 | 203446 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 1 Marne Ave | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 2ft | 5995218.70657 | 2097826.55093 | 37.7399577427547 | -122.459101255842 | (37.7399577427547, -122.459101255842) | 9 | 7 | 4 | 59 | 40 | |||
175290 | 203445 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 1 Marne Ave | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 2ft | 5995218.97252 | 2097817.06527 | 37.7399317127649 | -122.459099649629 | (37.7399317127649, -122.459099649629) | 9 | 7 | 4 | 59 | 40 | |||
84837 | 203444 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 1 Marne Ave | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 2ft | 5995221.10472 | 2097808.00302 | 37.7399069526404 | -122.459091621397 | (37.7399069526404, -122.459091621397) | 9 | 7 | 4 | 59 | 40 | |||
75027 | 203443 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 1 Marne Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 2ft | 5995223.6819 | 2097798.00617 | 37.7398796519151 | -122.459081986971 | (37.7398796519151, -122.459081986971) | 9 | 7 | 4 | 59 | 40 | |||
124092 | 123452 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 735 02nd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 5995332.97895 | 2110593.9249 | 37.7750202604257 | -122.459630642924 | (37.7750202604257, -122.459630642924) | 11 | 6 | 2 | 54 | 11 | |||
182821 | 123467 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 708 02nd Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 5995387.69315 | 2110690.84094 | 37.775289512367 | -122.459448396296 | (37.775289512367, -122.459448396296) | 11 | 6 | 2 | 54 | 11 | |||
15512 | 203483 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 459 Colon Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 7 | Width 3ft | 5995499.06215 | 2095368.93495 | 37.7332258441801 | -122.457954104018 | (37.7332258441801, -122.457954104018) | 9 | 7 | 4 | 59 | 40 | |||
78343 | 101466 | Significant Tree 6 | Afrocarpus gracilior :: Fern Pine 89 | 301 Hazelwood Ave | 1 | Front Yard : Yard | Tree | Private 2 | 5996219.7 | 2095283.8 | 37.7330334614805 | -122.455456526637 | (37.7330334614805, -122.455456526637) | 9 | 7 | 4 | 59 | 40 | |||||
87846 | 50391 | Permitted Site 7 | Afrocarpus gracilior :: Fern Pine 89 | 295 Hazelwood Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/01/2003 12:00:00 AM | Permit Number 47042 | 5996257.45116044 | 2095209.02576685 | 37.7328303156217 | -122.455320609685 | (37.7328303156217, -122.455320609685) | 9 | 7 | 4 | 59 | 40 | ||
165467 | 203489 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 296 Cresta Vista Dr | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 5996836.54011 | 2096166.78672 | 37.7354933057555 | -122.453387687511 | (37.7354933057555, -122.453387687511) | 9 | 7 | 4 | 59 | 40 | |||
77540 | 203488 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 296 Cresta Vista Dr | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 5996843.32855 | 2096168.51259 | 37.7354984336897 | -122.453364342002 | (37.7354984336897, -122.453364342002) | 9 | 7 | 4 | 59 | 40 | |||
60268 | 220638 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 222 Parnassus Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 7ft | 5997115.15152 | 2106725.56313 | 37.7645010544003 | -122.453186433611 | (37.7645010544003, -122.453186433611) | 15 | 5 | 11 | 29492 | 12 | |||
186373 | 96486 | Undocumented 4 | Afrocarpus gracilior :: Fern Pine 89 | 1202 Stanyan St | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | 5997433 | 2105848 | 37.7621097006999 | -122.452023768999 | (37.7621097006999, -122.452023768999) | 15 | 5 | 11 | 29492 | 9 | |||||
102881 | 220639 | Undocumented 4 | Afrocarpus gracilior :: Fern Pine 89 | 1202 Stanyan St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 11 | Width 3ft | 5997451.78012 | 2105807.14899 | 37.7619986098677 | -122.451955868771 | (37.7619986098677, -122.451955868771) | 15 | 5 | 11 | 29492 | 9 | |||
95335 | 203497 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 585 Mangels Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 5997548.43133 | 2095250.42463 | 37.7330179748995 | -122.450860369523 | (37.7330179748995, -122.450860369523) | 9 | 7 | 4 | 59 | 40 | |||
33499 | 246911 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 459 Frederick St | 2 | : | Tree | Private 2 | 3 | Width 3ft | 5997556.58518 | 2107424.48902 | 37.7664454174412 | -122.451710064262 | (37.7664454174412, -122.451710064262) | 15 | 5 | 11 | 29492 | 9 | |||
123622 | 203499 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 379 Staples Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 4ft | 5997569.06892 | 2093791.20398 | 37.7290124835419 | -122.450683849688 | (37.7290124835419, -122.450683849688) | 9 | 7 | 4 | 28861 | 40 |
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) );