trees
665 rows where qSpecies_id = 89
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
34992 | 125491 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 1207 Chestnut St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | Width 3ft | 6005994.09185 | 2120329.47146 | 37.8023589278732 | -122.423443758146 | (37.8023589278732, -122.423443758146) | 5 | 9 | 1 | 28858 | 32 | |||
35518 | 125505 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 45 Havens St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 11 | 6007613.99229 | 2119386.63886 | 37.7998614422209 | -122.41777122496 | (37.7998614422209, -122.41777122496) | 5 | 1 | 1 | 28858 | 32 | ||||
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 | ||
36154 | 64967 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 1671 Filbert St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/25/2013 12:00:00 AM | 3 | Permit Number 770626 | 6004948.17442 | 2119151.63157 | 37.7990657940144 | -122.426979209822 | (37.7990657940144, -122.426979209822) | 13 | 9 | 1 | 57 | 17 | |
36532 | 175163 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 229 Delano Ave | 12 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 4ft | 6000100.60606 | 2092317.35748 | 37.7251102235329 | -122.441826421457 | (37.7251102235329, -122.441826421457) | 9 | 7 | 6 | 28861 | 25 | |||
37305 | 189152 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 1665 Hudson Ave | 1 | : | Tree | Private 2 | 2 | Width 3ft | 6015368.44602 | 2097645.03721 | 37.7405971121722 | -122.389418536259 | (37.7405971121722, -122.389418536259) | 10 | 3 | 8 | 58 | 1 | |||
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 | |||
37925 | 125477 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 150 Sproule Ln | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 4ft | 6009239.02025 | 2116870.71678 | 37.793044652131 | -122.411970106748 | (37.793044652131, -122.411970106748) | 3 | 1 | 10 | 28857 | 21 | |||
38146 | 220652 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 324 Park St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 4ft | 6006873.24491 | 2096273.48816 | 37.7363564804515 | -122.418694495969 | (37.7363564804515, -122.418694495969) | 2 | 7 | 7 | 28859 | 2 | |||
38197 | 28058 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 399X Fern St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/28/2003 12:00:00 AM | 7 | 3X3 | 6005467.03901 | 2114965.36006 | 37.7876006726807 | -122.424885768876 | (37.7876006726807, -122.424885768876) | 13 | 9 | 1 | 28858 | 41 | ||
38269 | 175168 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 218 Congdon St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6004674.59943 | 2093952.62434 | 37.7298598742113 | -122.426130962075 | (37.7298598742113, -122.426130962075) | 9 | 7 | 6 | 28861 | 5 | |||
38406 | 220594 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 1 14th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6008571.39642 | 2107977.23283 | 37.7685877923289 | -122.413650808341 | (37.7685877923289, -122.413650808341) | 8 | 4 | 7 | 28853 | 19 | |||
40013 | 203466 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 480 Hearst Ave | 8 | Sidewalk: Property side : Yard | Tree | Private 2 | 11 | Width 2ft | 5998189.16786 | 2094420.93356 | 37.7307770478103 | -122.448585465162 | (37.7307770478103, -122.448585465162) | 9 | 7 | 4 | 59 | 40 | |||
40160 | 125440 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 3517 Divisadero St | 1 | : | Tree | Private 2 | 4 | Width 2ft | 6000220.82214 | 2120372.11662 | 37.8021484793247 | -122.443425105788 | (37.8021484793247, -122.443425105788) | 13 | 9 | 1 | 57 | 17 | |||
41103 | 175165 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 218 Congdon St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6004671.92277 | 2094015.32561 | 37.730031886663 | -122.42614467765 | (37.730031886663, -122.42614467765) | 9 | 7 | 6 | 28861 | 5 | |||
41180 | 220663 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 1190 Sanchez St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6003819.29636 | 2101374.54384 | 37.7501903863949 | -122.42961696547 | (37.7501903863949, -122.42961696547) | 2 | 4 | 5 | 28862 | 22 | |||
41938 | 125534 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 11 Miller Pl | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 2ft | 6010079.0906 | 2116883.16981 | 37.793125940953 | -122.409064282098 | (37.793125940953, -122.409064282098) | 3 | 1 | 10 | 28857 | 4 | |||
41972 | 248095 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 8 Brewster St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 2ft | 6010444.10359 | 2099844.52048 | 37.746362164885 | -122.406600056945 | (37.746362164885, -122.406600056945) | 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 | |
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 | |||
43231 | 99401 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 2201X Keith St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/09/2012 12:00:00 AM | 12 | 3x3 | Permit Number 768917 | 6014766.6 | 2092880.6 | 37.7274815503989 | -122.391166558925 | (37.7274815503989, -122.391166558925) | 10 | 3 | 8 | 58 | 1 | |
43617 | 189198 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 450 Tehama St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6010926.82993 | 2112099.93954 | 37.7800397781655 | -122.405793955035 | (37.7800397781655, -122.405793955035) | 14 | 2 | 9 | 28853 | 34 | |||
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 | ||||
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 | ||||
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 | ||
44607 | 4490 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 1602 Church St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 01/30/2002 12:00:00 AM | 3 | 3X3 | 6004561.8284 | 2099527.9975 | 37.7451622129677 | -122.426917747467 | (37.7451622129677, -122.426917747467) | 2 | 7 | 5 | 63 | 22 | ||
44724 | 125536 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 11 Miller Pl | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 2ft | 6010079.47478 | 2116878.80155 | 37.7931139682908 | -122.409062644439 | (37.7931139682908, -122.409062644439) | 3 | 1 | 10 | 28857 | 4 | |||
45527 | 189170 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 360 Texas St | 1 | Sidewalk: Curb side : Pot | Tree | Private 2 | 10 | Width 3ft | 6013732.7365 | 2105419.19303 | 37.7618524574395 | -122.395618779897 | (37.7618524574395, -122.395618779897) | 10 | 3 | 8 | 28856 | 29 | |||
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 | |||
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 | ||
45841 | 249532 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 201 Myrtle St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6006202.66878 | 2114026.79682 | 37.7850651330954 | -122.422273921828 | (37.7850651330954, -122.422273921828) | 13 | 9 | 11 | 28858 | 41 | |||
45904 | 27672 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 310 Austin St | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 3X3 | 6005758.15165 | 2115391.49838 | 37.7887871812497 | -122.423908889223 | (37.7887871812497, -122.423908889223) | 13 | 9 | 1 | 28858 | 41 | |||
46149 | 220646 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 816 Crescent Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6008205.0189 | 2095636.66757 | 37.7346828016745 | -122.414044944318 | (37.7346828016745, -122.414044944318) | 2 | 7 | 7 | 28859 | 2 | |||
46336 | 125437 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 1921 Jefferson St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 4ft | 6000052.89269 | 2121248.37983 | 37.8045448847905 | -122.444069220022 | (37.8045448847905, -122.444069220022) | 13 | 9 | 1 | 57 | 17 | |||
46462 | 189178 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 1 Anthony St | 4 | Sidewalk: Curb side : Yard | Tree | Private 2 | 1 | Width 5ft | 6012651.66778 | 2115316.04533 | 37.7889667644596 | -122.400052847677 | (37.7889667644596, -122.400052847677) | 12 | 2 | 9 | 28855 | 6 | |||
46905 | 175167 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 218 Congdon St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6004673.57343 | 2093985.3797 | 37.7299497551534 | -122.426136840057 | (37.7299497551534, -122.426136840057) | 9 | 7 | 6 | 28861 | 5 | |||
47611 | 189171 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 672 Missouri St | 2 | : | Tree | Private 2 | 4 | Width 1ft | 6013547.27138 | 2103937.27162 | 37.7577731065529 | -122.396156373043 | (37.7577731065529, -122.396156373043) | 10 | 3 | 8 | 28856 | 29 | |||
48346 | 203469 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 300 Flood Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | 5998711.43854 | 2094111.50955 | 37.7299572914866 | -122.446757644361 | (37.7299572914866, -122.446757644361) | 9 | 7 | 4 | 28861 | 40 | ||||
48353 | 175174 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 399 Vienna St | 7 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 3ft | 6003793.29108 | 2091173.56486 | 37.7221793437874 | -122.428979687879 | (37.7221793437874, -122.428979687879) | 9 | 7 | 6 | 28861 | 5 | |||
48506 | 125464 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 887 Eddy St | 6 | Sidewalk: Property side : Yard | Tree | Private 2 | 11 | Width 4ft | 6006280.54306 | 2113153.33425 | 37.7826712115607 | -122.4219424317 | (37.7826712115607, -122.4219424317) | 7 | 9 | 11 | 28852 | 41 | |||
48705 | 27670 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 310 Austin St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 3X3 | 6005758.15165 | 2115391.49838 | 37.7887871812497 | -122.423908889223 | (37.7887871812497, -122.423908889223) | 13 | 9 | 1 | 28858 | 41 | |||
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 | |
49659 | 28777 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 365 Austin St | 6 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6005518.5465766 | 2115307.531712 | 37.7885430999734 | -122.424731913891 | (37.7885430999734, -122.424731913891) | 13 | 9 | 1 | 28858 | 41 | |||
49713 | 189182 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 40 Bluxome St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 2ft | 6013480.92655 | 2110921.93119 | 37.7769477380782 | -122.3968755078 | (37.7769477380782, -122.3968755078) | 6 | 2 | 9 | 28856 | 34 | |||
49839 | 175172 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 399 Vienna St | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | Width 3ft | 6003774.22148 | 2091143.66189 | 37.7220961573958 | -122.42904347589 | (37.7220961573958, -122.42904347589) | 9 | 7 | 6 | 28861 | 5 | |||
50122 | 125517 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 900 Green St | 29 | Sidewalk: Property side : Yard | Tree | Private 2 | 2 | Width 5ft | 6008575.41519 | 2119026.37821 | 37.7989263127569 | -122.414418825785 | (37.7989263127569, -122.414418825785) | 5 | 1 | 10 | 308 | 32 | |||
50975 | 189168 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 606 Kansas St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 3ft | 6011490.76938 | 2105489.27118 | 37.7619199120061 | -122.40337783013 | (37.7619199120061, -122.40337783013) | 10 | 3 | 8 | 28856 | 29 | |||
51090 | 220645 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 816 Crescent Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6008216.92283 | 2095637.52522 | 37.7346858251821 | -122.414003848906 | (37.7346858251821, -122.414003848906) | 2 | 7 | 7 | 28859 | 2 | |||
51119 | 220615 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 3117 20th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6009011.32623 | 2104478.69915 | 37.75900631631 | -122.411881867955 | (37.75900631631, -122.411881867955) | 2 | 4 | 7 | 28859 | 19 | |||
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 | ||
51514 | 125509 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 900 Green St | 13 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | Width 5ft | 6008633.29576 | 2119030.27082 | 37.7989402522368 | -122.414218814773 | (37.7989402522368, -122.414218814773) | 5 | 1 | 10 | 308 | 32 | |||
51637 | 125493 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 1207 Chestnut St | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 3ft | 6006021.47381 | 2120333.65457 | 37.8023719590496 | -122.423349300554 | (37.8023719590496, -122.423349300554) | 5 | 9 | 1 | 28858 | 32 | |||
51653 | 125485 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 1237x Robert C Levy Tunl | 3 | Median : Yard | Tree | DPW 1 | 10 | 6007640.9414 | 2118138.07584 | 37.796434716745 | -122.417589429708 | (37.796434716745, -122.417589429708) | 5 | 1 | 10 | 28858 | 32 | ||||
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 | ||||
51778 | 102757 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 2807 Steiner St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | 3x3 | 6002051.95846 | 2117801.73169 | 37.7951951298959 | -122.436904386043 | (37.7951951298959, -122.436904386043) | 13 | 9 | 1 | 57 | 27 | |||
52978 | 220603 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 418 Valley St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 2ft | 6003167.3476 | 2099231.48151 | 37.7442691016478 | -122.431718451765 | (37.7442691016478, -122.431718451765) | 2 | 7 | 5 | 63 | 22 | |||
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 | ||
53345 | 79776 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 2331 25th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/30/2015 12:00:00 AM | 1 | Permit Number 774959 | 6011828.97856 | 2101840.08638 | 37.7519189391152 | -122.401951552136 | (37.7519189391152, -122.401951552136) | 10 | 3 | 8 | 28856 | 29 | |
54016 | 249820 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 1690 Kearny St | 2 | Front Yard : Yard | Tree | Private 2 | 13 | Width 0ft | 6010902.80513 | 2120614.31353 | 37.8034168633488 | -122.406477200573 | (37.8034168633488, -122.406477200573) | 3 | 1 | 10 | 308 | 23 | |||
54339 | 249939 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 331 Filbert St | 1 | Front Yard : Yard | Tree | Private 2 | 7 | Width 0ft | 6011281.55151 | 2120038.154 | 37.8018560512652 | -122.40512593233 | (37.8018560512652, -122.40512593233) | 3 | 1 | 10 | 308 | 23 | |||
54441 | 125460 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 2416 Webster St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 4ft | 6003175.77984 | 2117097.00502 | 37.7933239410913 | -122.432965418428 | (37.7933239410913, -122.432965418428) | 13 | 9 | 1 | 29490 | 27 | |||
54594 | 220611 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 1 Bradford St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 4ft | 6009641.7814 | 2098664.71567 | 37.7430777589371 | -122.409291162184 | (37.7430777589371, -122.409291162184) | 10 | 7 | 7 | 28859 | 2 | |||
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 | ||
55157 | 125470 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 655 Powell St | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | Width 2ft | 6010075.12389 | 2116032.87575 | 37.7907910167417 | -122.409017984115 | (37.7907910167417, -122.409017984115) | 5 | 1 | 10 | 28857 | 21 | |||
55420 | 189193 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 30 15th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 4ft | 6012073.86009 | 2107513.44954 | 37.7675104026963 | -122.401503402873 | (37.7675104026963, -122.401503402873) | 14 | 3 | 8 | 28856 | 20 | |||
55814 | 125511 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 900 Green St | 15 | Sidewalk: Property side : Yard | Tree | Private 2 | 2 | Width 5ft | 6008625.76186 | 2119029.22421 | 37.7989369553212 | -122.414244810558 | (37.7989369553212, -122.414244810558) | 5 | 1 | 10 | 308 | 32 | |||
56067 | 203470 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 100 Staples Ave | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 17 | 5999333.68862 | 2093807.88656 | 37.72915914047 | -122.444584644873 | (37.72915914047, -122.444584644873) | 9 | 7 | 4 | 28861 | 40 | ||||
56489 | 220609 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 385 Nevada St | 1 | Sidewalk: Curb side : Pot | Tree | Private 2 | 6 | Width 2ft | 6008945.60793 | 2096515.87148 | 37.737138473362 | -122.411546563846 | (37.737138473362, -122.411546563846) | 10 | 7 | 7 | 28859 | 2 | |||
56555 | 220659 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 998 Alabama St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6009137.78882 | 2103468.55533 | 37.756239784054 | -122.411373136768 | (37.756239784054, -122.411373136768) | 2 | 4 | 7 | 28859 | 19 | |||
57639 | 189157 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 100 Shipley St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6012230.29612 | 2112453.73281 | 37.7810840205508 | -122.401309519845 | (37.7810840205508, -122.401309519845) | 6 | 2 | 9 | 28856 | 34 | |||
57858 | 189153 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 100 Shipley St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6012332.53447 | 2112551.48713 | 37.7813581348078 | -122.400962694499 | (37.7813581348078, -122.400962694499) | 6 | 2 | 9 | 28856 | 34 | |||
58064 | 189174 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 14 Waterville St | 1 | : | Tree | Private 2 | 10 | Width 1ft | 6011435.76202 | 2096086.73565 | 37.7360995216629 | -122.402906748143 | (37.7360995216629, -122.402906748143) | 10 | 3 | 8 | 58 | 1 | |||
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 | ||
59297 | 125452 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 2401 Broadway | 9 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | Width 4ft | 6002068.61749 | 2117342.59163 | 37.7939353973611 | -122.436813859368 | (37.7939353973611, -122.436813859368) | 13 | 9 | 1 | 29490 | 27 | |||
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 | |||
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 | ||
60903 | 220636 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 628 Chenery St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 6002799.74223 | 2095713.64114 | 37.734589079726 | -122.432738303627 | (37.734589079726, -122.432738303627) | 2 | 7 | 5 | 63 | 7 | |||
61578 | 106492 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 1747 MCALLISTER ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/02/2018 12:00:00 AM | 12 | 3x3 | Permit Number 773396 | 6000787.4 | 2111331.2 | 37.7773567666582 | -122.440815564147 | (37.7773567666582, -122.440815564147) | 15 | 5 | 11 | 29492 | 41 | |
61917 | 27665 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 300 Austin St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 3X3 | 6005803.78776 | 2115397.87528 | 37.7888072668978 | -122.423751448163 | (37.7888072668978, -122.423751448163) | 13 | 9 | 1 | 28858 | 41 | |||
62150 | 67492 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 1119 Kansas St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/28/2015 12:00:00 AM | 3 | Permit Number 774343 | 6011679.29477 | 2103189.50582 | 37.7556157939465 | -122.402564065097 | (37.7556157939465, -122.402564065097) | 10 | 3 | 8 | 28856 | 29 | |
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 | |||
62733 | 27668 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 310 Austin St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 3X3 | 6005758.15165 | 2115391.49838 | 37.7887871812497 | -122.423908889223 | (37.7887871812497, -122.423908889223) | 13 | 9 | 1 | 28858 | 41 | |||
62853 | 250093 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 1700 Gough St | 7 | Sidewalk: Curb side : Pot | Tree | Private 2 | 1 | Width 2ft | 6005332.30774 | 2115621.39854 | 37.7893943794989 | -122.425398617158 | (37.7893943794989, -122.425398617158) | 13 | 9 | 1 | 28858 | 41 | |||
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 | ||
62927 | 221751 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 4000 25th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6003801.92979 | 2101310.951 | 37.7500147919711 | -122.429672485102 | (37.7500147919711, -122.429672485102) | 2 | 4 | 5 | 28862 | 22 | |||
63181 | 203460 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 451 Hearst Ave | 19 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 2ft | 5998498.64412 | 2094367.64391 | 37.7306484177731 | -122.447511726809 | (37.7306484177731, -122.447511726809) | 9 | 7 | 4 | 28861 | 40 | |||
63523 | 189189 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 40 Bluxome St | 13 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 2ft | 6013286.37012 | 2110737.42351 | 37.776430290657 | -122.397535599396 | (37.776430290657, -122.397535599396) | 6 | 2 | 9 | 28856 | 34 | |||
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 | ||||
63927 | 125438 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 250 Euclid Ave | 0 | Front Yard : Yard | Tree | Private 2 | 15 | 5998091.24108 | 2114006.24691 | 37.78454782955 | -122.450335292242 | (37.78454782955, -122.450335292242) | 15 | 6 | 1 | 54 | 31 | ||||
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 | ||
64387 | 104356 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 1671 Filbert St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/25/2013 12:00:00 AM | 3 | Permit Number 770626 | 6004967.00865 | 2119154.82266 | 37.7990756208885 | -122.426914264396 | (37.7990756208885, -122.426914264396) | 13 | 9 | 1 | 57 | 17 | ||
64447 | 125502 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 1001 Lombard St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | Width 7ft | 6007468.42884 | 2120195.87716 | 37.8020752142594 | -122.418332338987 | (37.8020752142594, -122.418332338987) | 5 | 1 | 1 | 28858 | 32 | |||
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 | |||
64506 | 125523 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 220 Lombard St | 7 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | Width 9ft | 6011207.16585 | 2120734.52957 | 37.8037639692824 | -122.405432414094 | (37.8037639692824, -122.405432414094) | 3 | 1 | 10 | 308 | 23 | |||
64715 | 125443 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 2298 Beach St | 8 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 5ft | 5999265.80635 | 2120844.85189 | 37.8033919746241 | -122.446763941418 | (37.8033919746241, -122.446763941418) | 13 | 9 | 1 | 57 | 17 | |||
64779 | 125512 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 900 Green St | 17 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 5ft | 6008620.72695 | 2119028.05639 | 37.7989334659598 | -122.414262150401 | (37.7989334659598, -122.414262150401) | 5 | 1 | 10 | 308 | 32 |
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) );