trees
665 rows where qSpecies_id = 89 sorted by DBH
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 | ||||||||||||||
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 | ||
14704 | 255211 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 7 Burrows St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | ||||||||||||||
18869 | 261135 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 401 Avalon Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Width 3ft | 6003851 | 2092597 | 37.7260910477872 | -122.428881632271 | (37.7260910477872, -122.428881632271) | 9 | 7 | 6 | 28861 | 5 | ||||
20586 | 45268 | Permitted Site 7 | Afrocarpus gracilior :: Fern Pine 89 | 656 Banks St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/12/2001 12:00:00 AM | Permit Number 44114 | 6008478.34688269 | 2095821.77218586 | 37.7352064067106 | -122.413113037779 | (37.7352064067106, -122.413113037779) | 10 | 7 | 7 | 28859 | 2 | ||
21321 | 42092 | Permitted Site 7 | Afrocarpus gracilior :: Fern Pine 89 | 37 Stoneman St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/21/2000 12:00:00 AM | Permit Number 42398 | 6008159.28675644 | 2099396.47385495 | 37.7450038344364 | -122.414469013279 | (37.7450038344364, -122.414469013279) | 2 | 7 | 7 | 28859 | 2 | ||
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 | ||
29617 | 50533 | Permitted Site 7 | Afrocarpus gracilior :: Fern Pine 89 | 481 Mississippi St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/06/2003 12:00:00 AM | Permit Number 47172 | 6014106.88689945 | 2104884.78697192 | 37.760405899811 | -122.394287314563 | (37.760405899811, -122.394287314563) | 10 | 3 | 8 | 28856 | 29 | |||
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 | ||
30401 | 42094 | Permitted Site 7 | Afrocarpus gracilior :: Fern Pine 89 | 45 Stoneman St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/21/2000 12:00:00 AM | Permit Number 42400 | 6008105.01217426 | 2099392.98476779 | 37.744991204982 | -122.414656438734 | (37.744991204982, -122.414656438734) | 2 | 7 | 7 | 28859 | 2 | ||
31263 | 30606 | Permitted Site 7 | Afrocarpus gracilior :: Fern Pine 89 | 40 12th St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/30/1995 12:00:00 AM | Permit Number 34571 | 6006862.94085785 | 2109917.12606637 | 37.773818193258 | -122.419697886953 | (37.773818193258, -122.419697886953) | 8 | 2 | 9 | 28853 | 19 | ||
32554 | 99407 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 2200X Keith St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/09/2012 12:00:00 AM | 3x3 | Permit Number 768917 | 6014766.6 | 2092880.6 | 37.7274815503989 | -122.391166558925 | (37.7274815503989, -122.391166558925) | 10 | 3 | 8 | 58 | 1 | ||
33164 | 96256 | Permitted Site 7 | Afrocarpus gracilior :: Fern Pine 89 | 192@ Congdon Ney St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/18/2011 12:00:00 AM | 3x3 | Permit Number 58762 | 6004645 | 2094034 | 37.7300816406458 | -122.42623908205 | (37.7300816406458, -122.42623908205) | 9 | 7 | 6 | 28861 | 5 | ||
34102 | 31948 | Permitted Site 7 | Afrocarpus gracilior :: Fern Pine 89 | 1677 Bush St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/26/1995 12:00:00 AM | Permit Number 35359 | 6005487.56868066 | 2115128.64858681 | 37.7880501818667 | -122.424826361466 | (37.7880501818667, -122.424826361466) | 13 | 9 | 1 | 28858 | 41 | ||
34602 | 97033 | Property Tree 8 | Afrocarpus gracilior :: Fern Pine 89 | 61 Vicksburg St | Back Yard : Yard | Tree | Private 2 | Possible significant tree; Nellie RoW; rear yard | 6004120 | 2102703 | 37.753855038047 | -122.428671801406 | (37.753855038047, -122.428671801406) | 2 | 4 | 5 | 28862 | 22 | |||||
35568 | 51459 | Permitted Site 7 | Afrocarpus gracilior :: Fern Pine 89 | 816 Crescent Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/20/2004 12:00:00 AM | Permit Number 47775 | 6008159.08468648 | 2095638.69714743 | 37.7346857944121 | -122.414203898561 | (37.7346857944121, -122.414203898561) | 2 | 7 | 7 | 28859 | 2 | ||
42265 | 96059 | Permitted Site 7 | Afrocarpus gracilior :: Fern Pine 89 | 101 Montcalm St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/03/2011 12:00:00 AM | 3x3 | Permit Number 767687 | 6010479 | 2099916 | 37.7465603843487 | -122.406484424587 | (37.7465603843487, -122.406484424587) | 2 | 7 | 7 | 28859 | 2 | |
43755 | 256846 | Undocumented 4 | Afrocarpus gracilior :: Fern Pine 89 | 1298x Post St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6006137 | 2114500 | 37.7863607279306 | -122.422534752155 | (37.7863607279306, -122.422534752155) | 13 | 9 | 11 | 28858 | 41 | ||||
44498 | 32128 | Permitted Site 7 | Afrocarpus gracilior :: Fern Pine 89 | 45 Ross Aly | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/15/1995 12:00:00 AM | Permit Number 35490 | 6010568.1937078 | 2117713.19841403 | 37.7954323857446 | -122.407430491589 | (37.7954323857446, -122.407430491589) | 3 | 1 | 10 | 28857 | 4 | ||
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 | ||
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 | |
51367 | 65437 | Permitted Site 7 | Afrocarpus gracilior :: Fern Pine 89 | 175 Turk St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/03/1989 12:00:00 AM | Permit Number 28311 | 6009164.55626174 | 2113209.72407625 | 37.7829882723647 | -122.411968925085 | (37.7829882723647, -122.411968925085) | 14 | 10 | 9 | 28852 | 36 | ||
51677 | 251747 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 706 Rolph St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6002959 | 2087321 | 37.7115537887528 | -122.431588720074 | (37.7115537887528, -122.431588720074) | 9 | 7 | 6 | 28861 | 5 | ||||
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 | ||
55080 | 32135 | Permitted Site 7 | Afrocarpus gracilior :: Fern Pine 89 | 858 Washington St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/15/1995 12:00:00 AM | Permit Number 35495 | 6010580.68586277 | 2117592.53204935 | 37.7951017643418 | -122.40737875552 | (37.7951017643418, -122.40737875552) | 3 | 1 | 10 | 28857 | 4 | ||
58068 | 51467 | Permitted Site 7 | Afrocarpus gracilior :: Fern Pine 89 | 450X Tompkins Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/20/2004 12:00:00 AM | Permit Number 47780 | 6008359.74436357 | 2096491.87705801 | 37.7370397099418 | -122.413570470462 | (37.7370397099418, -122.413570470462) | 2 | 7 | 7 | 28859 | 2 | ||
58303 | 81183 | Permitted Site 7 | Afrocarpus gracilior :: Fern Pine 89 | 461 Andover St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/18/2008 12:00:00 AM | 3x3 | Permit Number 50918 | 6007526.59353608 | 2096789.07906061 | 37.7378089430444 | -122.416472100986 | (37.7378089430444, -122.416472100986) | 2 | 7 | 7 | 28859 | 2 | ||
58880 | 33006 | Permitted Site 7 | Afrocarpus gracilior :: Fern Pine 89 | 255 03rd St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/03/2002 12:00:00 AM | Permit Number 45106 | 6012763.62735273 | 2113645.89457982 | 37.7843871619555 | -122.399548173715 | (37.7843871619555, -122.399548173715) | 6 | 2 | 9 | 28853 | 6 | ||
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 | ||
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 | ||
62900 | 32709 | Permitted Site 7 | Afrocarpus gracilior :: Fern Pine 89 | 1005 Hyde St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/29/1996 12:00:00 AM | Permit Number 37107 | 6007675.42771265 | 2115829.29953352 | 37.7900973284958 | -122.417306405748 | (37.7900973284958, -122.417306405748) | 13 | 1 | 10 | 28858 | 21 | ||
63826 | 256843 | Undocumented 4 | Afrocarpus gracilior :: Fern Pine 89 | 1298x Post St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6006137 | 2114500 | 37.7863607279306 | -122.422534752155 | (37.7863607279306, -122.422534752155) | 13 | 9 | 11 | 28858 | 41 | ||||
64382 | 66177 | Permitted Site 7 | Afrocarpus gracilior :: Fern Pine 89 | 10 Bronte St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/05/1990 12:00:00 AM | Permit Number 29250 | 6009347.85081362 | 2097405.9142613 | 37.7396048925803 | -122.41021864302 | (37.7396048925803, -122.41021864302) | 10 | 7 | 7 | 28859 | 2 | ||
68515 | 65417 | Permitted Site 7 | Afrocarpus gracilior :: Fern Pine 89 | 887 Bush St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/27/1989 12:00:00 AM | Permit Number 28274 | 6009256.60978604 | 2115652.27846796 | 37.7897001035195 | -122.411823108686 | (37.7897001035195, -122.411823108686) | 5 | 1 | 10 | 28857 | 21 | ||
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 | ||
69885 | 63536 | Permitted Site 7 | Afrocarpus gracilior :: Fern Pine 89 | 337 San Carlos St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/10/1987 12:00:00 AM | Permit Number 24149 | 6006745.70850466 | 2104155.29441199 | 37.7579909553953 | -122.419694511877 | (37.7579909553953, -122.419694511877) | 2 | 4 | 7 | 28859 | 19 | ||
72046 | 96257 | Permitted Site 7 | Afrocarpus gracilior :: Fern Pine 89 | 192@ Congdon Ney St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/18/2011 12:00:00 AM | 3x3 | Permit Number 58762 | 6004645 | 2094034 | 37.7300816406458 | -122.42623908205 | (37.7300816406458, -122.42623908205) | 9 | 7 | 6 | 28861 | 5 | ||
77561 | 30608 | Permitted Site 7 | Afrocarpus gracilior :: Fern Pine 89 | 40 12th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/30/1995 12:00:00 AM | Permit Number 34571 | 6006862.94085785 | 2109917.12606637 | 37.773818193258 | -122.419697886953 | (37.773818193258, -122.419697886953) | 8 | 2 | 9 | 28853 | 19 | ||
77564 | 33004 | Permitted Site 7 | Afrocarpus gracilior :: Fern Pine 89 | 255 03rd St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/03/2002 12:00:00 AM | Permit Number 45106 | 6012763.62735273 | 2113645.89457982 | 37.7843871619555 | -122.399548173715 | (37.7843871619555, -122.399548173715) | 6 | 2 | 9 | 28853 | 6 | ||
77931 | 32708 | Permitted Site 7 | Afrocarpus gracilior :: Fern Pine 89 | 1005 Hyde St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/29/1996 12:00:00 AM | Permit Number 37107 | 6007675.42771265 | 2115829.29953352 | 37.7900973284958 | -122.417306405748 | (37.7900973284958, -122.417306405748) | 13 | 1 | 10 | 28858 | 21 | ||
78118 | 66176 | Permitted Site 7 | Afrocarpus gracilior :: Fern Pine 89 | 16 Bronte St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/05/1990 12:00:00 AM | Permit Number 29249 | 6009344.53220754 | 2097370.35407631 | 37.7395070660178 | -122.410227607366 | (37.7395070660178, -122.410227607366) | 10 | 7 | 7 | 28859 | 2 | ||
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 | |||||
79790 | 51611 | Permitted Site 7 | Afrocarpus gracilior :: Fern Pine 89 | 999 Van Ness Ave | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/04/2005 12:00:00 AM | Permit Number 47908 | 6006486.39229912 | 2113910.68802822 | 37.7847623267063 | -122.421284078173 | (37.7847623267063, -122.421284078173) | 13 | 9 | 11 | 28858 | 41 | |||
82115 | 42786 | Permitted Site 7 | Afrocarpus gracilior :: Fern Pine 89 | 269 Lily St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/26/2000 12:00:00 AM | Permit Number 42753 | 6005259.26650222 | 2110063.08095744 | 37.7741284823912 | -122.425255647592 | (37.7741284823912, -122.425255647592) | 7 | 9 | 11 | 28852 | 10 | ||
83244 | 32142 | Permitted Site 7 | Afrocarpus gracilior :: Fern Pine 89 | 163X Hickory St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/15/1995 12:00:00 AM | Permit Number 35497 | 6006158.88889094 | 2110709.34290145 | 37.7759537443519 | -122.422189614353 | (37.7759537443519, -122.422189614353) | 7 | 9 | 11 | 28852 | 10 | ||
84543 | 256847 | Undocumented 4 | Afrocarpus gracilior :: Fern Pine 89 | 1298x Post St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6006137 | 2114500 | 37.7863607279306 | -122.422534752155 | (37.7863607279306, -122.422534752155) | 13 | 9 | 11 | 28858 | 41 | ||||
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 | ||
84641 | 88118 | Permitted Site 7 | Afrocarpus gracilior :: Fern Pine 89 | 956 Corbett Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/01/2008 12:00:00 AM | 3x3 | Permit Number 51122 | 5999752.6 | 2102008.2 | 37.7516991466356 | -122.443725322035 | (37.7516991466356, -122.443725322035) | 2 | 5 | 5 | 63 | 38 | ||
86100 | 32141 | Permitted Site 7 | Afrocarpus gracilior :: Fern Pine 89 | 163X Hickory St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/15/1995 12:00:00 AM | Permit Number 35497 | 6006158.88889094 | 2110709.34290145 | 37.7759537443519 | -122.422189614353 | (37.7759537443519, -122.422189614353) | 7 | 9 | 11 | 28852 | 10 | ||
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 | ||
87449 | 30702 | Permitted Site 7 | Afrocarpus gracilior :: Fern Pine 89 | 361 Oak St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/31/1995 12:00:00 AM | Permit Number 34614 | 6005271.42565012 | 2110238.90565505 | 37.7746119412537 | -122.425226100731 | (37.7746119412537, -122.425226100731) | 7 | 9 | 11 | 28852 | 10 | ||
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 | ||
87958 | 66924 | Permitted Site 7 | Afrocarpus gracilior :: Fern Pine 89 | 118 Andover St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/18/1991 12:00:00 AM | Permit Number 30245 | 6007569.63661842 | 2098095.56578905 | 37.7413986874365 | -122.416415794383 | (37.7413986874365, -122.416415794383) | 2 | 7 | 7 | 28859 | 2 | ||
88139 | 42095 | Permitted Site 7 | Afrocarpus gracilior :: Fern Pine 89 | 45 Stoneman St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/21/2000 12:00:00 AM | Permit Number 42400 | 6008105.01217426 | 2099392.98476779 | 37.744991204982 | -122.414656438734 | (37.744991204982, -122.414656438734) | 2 | 7 | 7 | 28859 | 2 | |||
88708 | 256845 | Undocumented 4 | Afrocarpus gracilior :: Fern Pine 89 | 1298x Post St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6006137 | 2114500 | 37.7863607279306 | -122.422534752155 | (37.7863607279306, -122.422534752155) | 13 | 9 | 11 | 28858 | 41 | ||||
90963 | 32134 | Permitted Site 7 | Afrocarpus gracilior :: Fern Pine 89 | 842 Washington St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/15/1995 12:00:00 AM | Permit Number 35494 | 6010631.11006318 | 2117599.53652258 | 37.7951238190257 | -122.407204773258 | (37.7951238190257, -122.407204773258) | 3 | 1 | 10 | 28857 | 4 | ||
94779 | 256849 | Undocumented 4 | Afrocarpus gracilior :: Fern Pine 89 | 1298x Post St | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6006137 | 2114500 | 37.7863607279306 | -122.422534752155 | (37.7863607279306, -122.422534752155) | 13 | 9 | 11 | 28858 | 41 | ||||
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 | ||
96258 | 256848 | Undocumented 4 | Afrocarpus gracilior :: Fern Pine 89 | 1298x Post St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6006137 | 2114500 | 37.7863607279306 | -122.422534752155 | (37.7863607279306, -122.422534752155) | 13 | 9 | 11 | 28858 | 41 | ||||
97400 | 97940 | Undocumented 4 | Afrocarpus gracilior :: Fern Pine 89 | 491 Greenwich St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6010516 | 2120277 | 37.8024690368502 | -122.407791962119 | (37.8024690368502, -122.407791962119) | 3 | 1 | 10 | 308 | 23 | |||||
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 | ||
98279 | 256844 | Undocumented 4 | Afrocarpus gracilior :: Fern Pine 89 | 1298x Post St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6006137 | 2114500 | 37.7863607279306 | -122.422534752155 | (37.7863607279306, -122.422534752155) | 13 | 9 | 11 | 28858 | 41 | ||||
98782 | 66897 | Permitted Site 7 | Afrocarpus gracilior :: Fern Pine 89 | 147 Andover St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/06/1991 12:00:00 AM | Permit Number 30215 | 6007611.30400663 | 2097973.85799157 | 37.7410668478925 | -122.416263104572 | (37.7410668478925, -122.416263104572) | 2 | 7 | 7 | 28859 | 2 | ||
101343 | 94131 | Permitted Site 7 | Afrocarpus gracilior :: Fern Pine 89 | 101 Montcalm St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/11/2010 12:00:00 AM | 3x3 | Permit Number 53497 | 6010479 | 2099916 | 37.7465603843487 | -122.406484424587 | (37.7465603843487, -122.406484424587) | 2 | 7 | 7 | 28859 | 2 | ||
104419 | 256840 | Undocumented 4 | Afrocarpus gracilior :: Fern Pine 89 | 1298x Post St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6006137 | 2114500 | 37.7863607279306 | -122.422534752155 | (37.7863607279306, -122.422534752155) | 13 | 9 | 11 | 28858 | 41 | ||||
104611 | 96061 | Permitted Site 7 | Afrocarpus gracilior :: Fern Pine 89 | 101 Montcalm St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/03/2011 12:00:00 AM | 3x3 | Permit Number 767687 | 6010479 | 2099916 | 37.7465603843487 | -122.406484424587 | (37.7465603843487, -122.406484424587) | 2 | 7 | 7 | 28859 | 2 | |
106011 | 91377 | Permitted Site 7 | Afrocarpus gracilior :: Fern Pine 89 | 49 Seward St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | Permit Number 52069 | 6000873 | 2104304 | 37.7580666971462 | -122.440015443053 | (37.7580666971462, -122.440015443053) | 2 | 4 | 5 | 28862 | 38 | |||
106703 | 66898 | Permitted Site 7 | Afrocarpus gracilior :: Fern Pine 89 | 130 Andover St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/06/1991 12:00:00 AM | Permit Number 30216 | 6007565.29124938 | 2098045.32566765 | 37.7412604948415 | -122.416427261414 | (37.7412604948415, -122.416427261414) | 2 | 7 | 7 | 28859 | 2 | ||
108670 | 38318 | Permitted Site 7 | Afrocarpus gracilior :: Fern Pine 89 | 1810 Harrison St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/29/2011 12:00:00 AM | 3x3 | Permit Number 767577 | 6008623.68390919 | 2107918.42733823 | 37.7684292621485 | -122.413465790173 | (37.7684292621485, -122.413465790173) | 8 | 4 | 7 | 28853 | 19 | |
114783 | 99408 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 2200X Keith St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/09/2012 12:00:00 AM | 3x3 | Permit Number 768917 | 6014766.6 | 2092880.6 | 37.7274815503989 | -122.391166558925 | (37.7274815503989, -122.391166558925) | 10 | 3 | 8 | 58 | 1 | ||
115495 | 59475 | Permitted Site 7 | Afrocarpus gracilior :: Fern Pine 89 | 45 Pearl St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/12/1991 12:00:00 AM | Permit Number 30019 | 6005649.89083993 | 2108784.60921416 | 37.7706401673343 | -122.423813483184 | (37.7706401673343, -122.423813483184) | 8 | 2 | 5 | 28853 | 19 | ||
115910 | 253132 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 522 Avalon Ave | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Width 3ft | 6004047.94044 | 2092448.57496 | 37.7256946506667 | -122.428190247706 | (37.7256946506667, -122.428190247706) | 9 | 7 | 6 | 28861 | 5 | ||||
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 | ||
117100 | 256841 | Undocumented 4 | Afrocarpus gracilior :: Fern Pine 89 | 1298x Post St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6006137 | 2114500 | 37.7863607279306 | -122.422534752155 | (37.7863607279306, -122.422534752155) | 13 | 9 | 11 | 28858 | 41 | ||||
117721 | 64654 | Permitted Site 7 | Afrocarpus gracilior :: Fern Pine 89 | 1315 Polk St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/12/1988 12:00:00 AM | Permit Number 25578 | 6006760.4974846 | 2115419.54547338 | 37.7889207278004 | -122.420442899695 | (37.7889207278004, -122.420442899695) | 13 | 9 | 10 | 28858 | 21 | ||
117987 | 92782 | Permitted Site 7 | Afrocarpus gracilior :: Fern Pine 89 | 527 Bryant St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | Permit Number 52999 | 6013573 | 2112256 | 37.7806159117786 | -122.396650538079 | (37.7806159117786, -122.396650538079) | 6 | 2 | 9 | 28856 | 34 | |||
119583 | 31957 | Permitted Site 7 | Afrocarpus gracilior :: Fern Pine 89 | 935 O'Farrell St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/26/1995 12:00:00 AM | Permit Number 35362 | 6006823.22516911 | 2113923.34802193 | 37.7848160720716 | -122.42011964381 | (37.7848160720716, -122.42011964381) | 7 | 9 | 9 | 28858 | 36 | ||
120598 | 42093 | Permitted Site 7 | Afrocarpus gracilior :: Fern Pine 89 | 41 Stoneman St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/21/2000 12:00:00 AM | Permit Number 42399 | 6008132.14946535 | 2099394.72931137 | 37.7449975197465 | -122.414562726014 | (37.7449975197465, -122.414562726014) | 2 | 7 | 7 | 28859 | 2 | ||
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 | ||||
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 | ||
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 | ||
128595 | 256842 | Undocumented 4 | Afrocarpus gracilior :: Fern Pine 89 | 1298x Post St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6006137 | 2114500 | 37.7863607279306 | -122.422534752155 | (37.7863607279306, -122.422534752155) | 13 | 9 | 11 | 28858 | 41 | ||||
128631 | 45289 | Permitted Site 7 | Afrocarpus gracilior :: Fern Pine 89 | 600 Gates St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/12/2001 12:00:00 AM | Permit Number 44129 | 6008139.59757362 | 2096081.06824752 | 37.7358993545079 | -122.414302561575 | (37.7358993545079, -122.414302561575) | 2 | 7 | 7 | 28859 | 2 | |||
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 | ||
129408 | 99404 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 2200X Keith St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/09/2012 12:00:00 AM | 3x3 | Permit Number 768917 | 6014766.6 | 2092880.6 | 37.7274815503989 | -122.391166558925 | (37.7274815503989, -122.391166558925) | 10 | 3 | 8 | 58 | 1 | ||
129704 | 32136 | Permitted Site 7 | Afrocarpus gracilior :: Fern Pine 89 | 858 Washington St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/15/1995 12:00:00 AM | Permit Number 35495 | 6010580.68586277 | 2117592.53204935 | 37.7951017643418 | -122.40737875552 | (37.7951017643418, -122.40737875552) | 3 | 1 | 10 | 28857 | 4 | ||
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 | ||
131175 | 91501 | Permitted Site 7 | Afrocarpus gracilior :: Fern Pine 89 | 125 Mason St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/23/2008 12:00:00 AM | 3x3 | Permit Number 52121 | 6009912 | 2113772 | 37.7845740549071 | -122.409422761042 | (37.7845740549071, -122.409422761042) | 14 | 10 | 9 | 28852 | 36 | ||
131214 | 95368 | Permitted Site 7 | Afrocarpus gracilior :: Fern Pine 89 | 960 Corbett Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/11/2011 12:00:00 AM | 3x3 | Permit Number 767465 | 5999728 | 2101957 | 37.7515571607552 | -122.443806713729 | (37.7515571607552, -122.443806713729) | 2 | 5 | 5 | 63 | 38 | ||
131468 | 95783 | Permitted Site 7 | Afrocarpus gracilior :: Fern Pine 89 | 3117 20th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/19/2011 12:00:00 AM | 3x3 | Permit Number 767527 | 6009054 | 2104485 | 37.7590260110101 | -122.411734726588 | (37.7590260110101, -122.411734726588) | 2 | 4 | 7 | 28859 | 19 | |
132417 | 49036 | Permitted Site 7 | Afrocarpus gracilior :: Fern Pine 89 | 1190 Sanchez St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/07/2003 12:00:00 AM | Permit Number 46211 | 6003822.41781324 | 2101344.45239948 | 37.7501079390792 | -122.429604025448 | (37.7501079390792, -122.429604025448) | 2 | 4 | 5 | 28862 | 22 | ||
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 | ||
134207 | 33294 | Permitted Site 7 | Afrocarpus gracilior :: Fern Pine 89 | 158 Sproule Ln | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/14/1996 12:00:00 AM | Permit Number 37451 | 6009246.88754349 | 2116916.88448981 | 37.7931718587847 | -122.411946149383 | (37.7931718587847, -122.411946149383) | 3 | 1 | 10 | 28857 | 21 | ||
135153 | 57875 | Permitted Site 7 | Afrocarpus gracilior :: Fern Pine 89 | 411 O'Farrell St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/26/1997 12:00:00 AM | Permit Number 16823 | 6009320.51611206 | 2114267.52405605 | 37.7859014867053 | -122.411504124328 | (37.7859014867053, -122.411504124328) | 14 | 10 | 9 | 28852 | 36 | ||
136678 | 96255 | Permitted Site 7 | Afrocarpus gracilior :: Fern Pine 89 | 192@ Congdon Ney St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/18/2011 12:00:00 AM | 3x3 | Permit Number 58762 | 6004645 | 2094034 | 37.7300816406458 | -122.42623908205 | (37.7300816406458, -122.42623908205) | 9 | 7 | 6 | 28861 | 5 | ||
139862 | 99405 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 2200X Keith St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/09/2012 12:00:00 AM | 3x3 | Permit Number 768917 | 6014766.6 | 2092880.6 | 37.7274815503989 | -122.391166558925 | (37.7274815503989, -122.391166558925) | 10 | 3 | 8 | 58 | 1 | ||
140669 | 99403 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 2200X Keith St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/09/2012 12:00:00 AM | 3x3 | Permit Number 768917 | 6014766.6 | 2092880.6 | 37.7274815503989 | -122.391166558925 | (37.7274815503989, -122.391166558925) | 10 | 3 | 8 | 58 | 1 |
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) );