trees

665 rows where qSpecies_id = 89 sorted by qLegalStatus_id descending

✎ View and edit SQL

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)
6336 261055 Private 9 Afrocarpus gracilior :: Fern Pine 89 1948 Quesada Ave 1 Front Yard : Cutout Tree Private 2 DPW 11/20/2019 12:00:00 AM 3 3x3 Permit Number 780729 6013389.35902 2096036.97619 37.7360717858924 -122.396148836191 (37.7360717858924, -122.396148836191) 10 3 8 58 1
8824 261056 Private 9 Afrocarpus gracilior :: Fern Pine 89 1952 Quesada Ave 1 Front Yard : Cutout Tree Private 2 DPW 11/20/2019 12:00:00 AM 3 3x3 Permit Number 780727 6013369.93114 2096051.4395 37.7361104181421 -122.396217020065 (37.7361104181421, -122.396217020065) 10 3 8 58 1
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
414 8435 Permitted Site 7 Afrocarpus gracilior :: Fern Pine 89 1730 Geary Blvd 2 Sidewalk: Curb side : Cutout Tree Private 2   05/28/1997 12:00:00 AM 13 3X3   6003010.73492 2113853.74303 37.784409407274 -122.433304626878 (37.784409407274, -122.433304626878) 13 9 11 29490 13
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
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
24461 16391 Permitted Site 7 Afrocarpus gracilior :: Fern Pine 89 248X Myrtle St 1 Sidewalk: Curb side : Cutout Tree Private 2   03/20/2003 12:00:00 AM 3 3X3   6006237.34556 2114081.50477 37.7852173036048 -122.422157838958 (37.7852173036048, -122.422157838958) 13 9 11 28858 41
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
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
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
37507 17121 Permitted Site 7 Afrocarpus gracilior :: Fern Pine 89 1931 Oak St 3 Sidewalk: Curb side : Cutout Tree Private 2     12 3X3   5997743.85041 2109170.01524 37.7712489089965 -122.451188245827 (37.7712489089965, -122.451188245827) 15 5 11 29492 9
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
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
44580 16399 Permitted Site 7 Afrocarpus gracilior :: Fern Pine 89 299X Myrtle St 5 Sidewalk: Curb side : Cutout Tree Private 2   01/15/1990 12:00:00 AM 12 3X3   6006028.76056 2113989.39072 37.7849526140265 -122.422872930887 (37.7849526140265, -122.422872930887) 13 9 11 28858 41
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
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
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
66789 16404 Permitted Site 7 Afrocarpus gracilior :: Fern Pine 89 299X Myrtle St 10 Sidewalk: Curb side : Cutout Tree Private 2   01/15/1990 12:00:00 AM 6 3X3   6006028.76056 2113989.39072 37.7849526140265 -122.422872930887 (37.7849526140265, -122.422872930887) 13 9 11 28858 41
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
69039 16401 Permitted Site 7 Afrocarpus gracilior :: Fern Pine 89 299X Myrtle St 7 Sidewalk: Curb side : Cutout Tree Private 2   01/15/1990 12:00:00 AM 6 3X3   6006028.76056 2113989.39072 37.7849526140265 -122.422872930887 (37.7849526140265, -122.422872930887) 13 9 11 28858 41
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
72406 51468 Permitted Site 7 Afrocarpus gracilior :: Fern Pine 89 450X Tompkins Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 10/20/2004 12:00:00 AM 10 3x3 Permit Number 47780 6008359.74436357 2096491.87705801 37.7370397099418 -122.413570470462 (37.7370397099418, -122.413570470462) 2 7 7 28859 2
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
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
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
87885 16912 Permitted Site 7 Afrocarpus gracilior :: Fern Pine 89 474 Oak St 1 Sidewalk: Property side : Cutout Tree Private 2     10 3X3   6004730.16481 2110223.37403 37.7745387026084 -122.427097323497 (37.7745387026084, -122.427097323497) 7 9 11 28852 10
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
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
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
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
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
101124 71559 Permitted Site 7 Afrocarpus gracilior :: Fern Pine 89 919 South Van Ness Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 12/22/2014 12:00:00 AM 3 3x3 Permit Number 772718 6007599.61852401 2104303.467284 37.758445868977 -122.416751817847 (37.758445868977, -122.416751817847) 2 4 7 28859 19
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
103800 24506 Permitted Site 7 Afrocarpus gracilior :: Fern Pine 89 360X Fern St 3 Sidewalk: Curb side : Cutout Tree Private 2     3 3x3   6005494.49314 2114994.92622 37.7876834046589 -122.424792887097 (37.7876834046589, -122.424792887097) 13 9 1 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
105504 18245 Permitted Site 7 Afrocarpus gracilior :: Fern Pine 89 1815X Post St 1 Sidewalk: Curb side : Cutout Tree Private 2     6 3x3   6003482.1216 2114150.20266 37.7852501414757 -122.431694966286 (37.7852501414757, -122.431694966286) 13 9 11 29490 13
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
115360 66399 Permitted Site 7 Afrocarpus gracilior :: Fern Pine 89 512 Andover St 1 Sidewalk: Curb side : Cutout Tree Private 2   01/08/1991 12:00:00 AM 11 4.5x12 Permit Number 29525 6007445.41695715 2096473.5258201 37.7369379378565 -122.41673042001 (37.7369379378565, -122.41673042001) 2 7 7 28859 2
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
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
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
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
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
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
131213 16913 Permitted Site 7 Afrocarpus gracilior :: Fern Pine 89 477 Oak St 1 Sidewalk: Curb side : Cutout Tree Private 2     6 3X3   6004718.6652 2110142.96999 37.7743172824327 -122.42713137469 (37.7743172824327, -122.42713137469) 7 9 11 28852 10
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
142171 33292 Permitted Site 7 Afrocarpus gracilior :: Fern Pine 89 160 Sproule Ln 4 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
142231 31949 Permitted Site 7 Afrocarpus gracilior :: Fern Pine 89 1677 Bush St 2 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
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
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
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
152220 96259 Permitted Site 7 Afrocarpus gracilior :: Fern Pine 89 192@ Congdon Ney St 5 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
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
154300 37067 Permitted Site 7 Afrocarpus gracilior :: Fern Pine 89 345 Valley St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/01/1998 12:00:00 AM     Permit Number 39669 6003676.44308345 2099207.16082517 37.7442311672419 -122.429956374539 (37.7442311672419, -122.429956374539) 2 7 5 63 22

Next page

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options: 

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)
);