trees
665 rows where qSpecies_id = 89 sorted by Police Districts descending
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
145970 | 125447 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 3057 Franklin St | 1 | : | Tree | Private 2 | 5 | Width 2ft | 6005068.76254 | 2120514.19483 | 37.8028138607435 | -122.426659015206 | (37.8028138607435, -122.426659015206) | 13 | 9 | 1 | 57 | 17 | |||
146159 | 250076 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 399 Austin St | 2 | : | Tree | Private 2 | 11 | Width 3ft | 6005407.46076 | 2115305.46211 | 37.7885311427353 | -122.425116106829 | (37.7885311427353, -122.425116106829) | 13 | 9 | 1 | 28858 | 41 | |||
148477 | 7127 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 300X Fern St | 6 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/02/1990 12:00:00 AM | 6 | 3x3 | 6005701.71486 | 2115022.25762 | 37.7877701517306 | -122.424077883603 | (37.7877701517306, -122.424077883603) | 13 | 9 | 1 | 28858 | 41 | ||
149402 | 125492 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 1207 Chestnut St | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 3ft | 6006010.16913 | 2120331.72981 | 37.8023660361287 | -122.423388283439 | (37.8023660361287, -122.423388283439) | 5 | 9 | 1 | 28858 | 32 | |||
149655 | 111999 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 2414 Webster St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/04/2015 12:00:00 AM | 24 | 4x4 | Permit Number 776155 | 6003178.79126 | 2117077.11494 | 37.7932694988467 | -122.432953577047 | (37.7932694988467, -122.432953577047) | 13 | 9 | 1 | 29490 | 27 | |
150651 | 250070 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 399 Austin St | 1 | : | Tree | DPW 1 | 2 | Width 3ft | 6005393.47416 | 2115303.01268 | 37.788523627097 | -122.425164323999 | (37.788523627097, -122.425164323999) | 13 | 9 | 1 | 28858 | 41 | |||
151012 | 7124 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 300X Fern St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/02/1990 12:00:00 AM | 6 | 3X3 | 6005782.02097 | 2115033.60586 | 37.7878058449088 | -122.423800846553 | (37.7878058449088, -122.423800846553) | 13 | 9 | 1 | 28858 | 41 | ||
156024 | 7130 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 399X Fern St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/02/1990 12:00:00 AM | 5 | 3X3 | 6005539.58789 | 2114975.93468 | 37.7876338054953 | -122.42463551632 | (37.7876338054953, -122.42463551632) | 13 | 9 | 1 | 28858 | 41 | ||
156119 | 24504 | Permitted Site 7 | Afrocarpus gracilior :: Fern Pine 89 | 360X Fern St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 3X3 | 6005526.31532 | 2114998.99681 | 37.7876963787723 | -122.424683078077 | (37.7876963787723, -122.424683078077) | 13 | 9 | 1 | 28858 | 41 | |||
159536 | 125444 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 3676 Fillmore St | 3 | : | Tree | Private 2 | 6 | Width 2ft | 6002146.17897 | 2121077.47724 | 37.8041948227854 | -122.436812979831 | (37.8041948227854, -122.436812979831) | 13 | 9 | 1 | 57 | 17 | |||
160051 | 27671 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 310 Austin St | 4 | 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 | |||
161362 | 16907 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 452 Oak St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 3X3 | 6004778.47873 | 2110233.49325 | 37.7745692194762 | -122.426930917012 | (37.7745692194762, -122.426930917012) | 7 | 9 | 11 | 28852 | 10 | |||
161911 | 41212 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 3676 Fillmore St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/29/1999 12:00:00 AM | 6 | Permit Number 41921 | 6002149.73701 | 2121055.69726 | 37.804135222937 | -122.43679910691 | (37.804135222937, -122.43679910691) | 13 | 9 | 1 | 57 | 17 | |
162245 | 125461 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 1845 Green St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 11 | Width 4ft | 6004195.45414 | 2118342.02418 | 37.7968002290978 | -122.429526106064 | (37.7968002290978, -122.429526106064) | 13 | 9 | 1 | 57 | 17 | |||
162324 | 16406 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 299X Myrtle St | 12 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 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 | ||
163753 | 42785 | Permitted Site 7 | Afrocarpus gracilior :: Fern Pine 89 | 269 Lily St | 1 | 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 | ||
164297 | 34667 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 3065 Buchanan St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/28/1997 12:00:00 AM | 3 | Permit Number 38339 | 6003364.40129 | 2118901.01049 | 37.7982879721724 | -122.432441684758 | (37.7982879721724, -122.432441684758) | 13 | 9 | 1 | 57 | 17 | ||
166235 | 16403 | Permitted Site 7 | Afrocarpus gracilior :: Fern Pine 89 | 299X Myrtle St | 9 | 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 | ||
166460 | 16400 | Permitted Site 7 | Afrocarpus gracilior :: Fern Pine 89 | 299X Myrtle St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/13/2005 12:00:00 AM | 3 | 3X3 | 6006028.76056 | 2113989.39072 | 37.7849526140265 | -122.422872930887 | (37.7849526140265, -122.422872930887) | 13 | 9 | 11 | 28858 | 41 | ||
169591 | 249537 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 201 Myrtle St | 6 | : | Tree | Private 2 | 5 | Width 3ft | 6006345.87488 | 2114047.32097 | 37.7851295641198 | -122.421779931396 | (37.7851295641198, -122.421779931396) | 13 | 9 | 11 | 28858 | 41 | |||
170059 | 125445 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 3615 Buchanan St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6003103.29494 | 2120784.42 | 37.8034445139256 | -122.433479854917 | (37.8034445139256, -122.433479854917) | 13 | 9 | 1 | 57 | 17 | |||
173456 | 16405 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 299X Myrtle St | 11 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 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 | ||
174438 | 31950 | Permitted Site 7 | Afrocarpus gracilior :: Fern Pine 89 | 1677 Bush St | 1 | 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 | ||
178524 | 249534 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 201 Myrtle St | 3 | : | Tree | Private 2 | 7 | Width 3ft | 6006252.35701 | 2114034.72493 | 37.7850897043627 | -122.422102579373 | (37.7850897043627, -122.422102579373) | 13 | 9 | 11 | 28858 | 41 | |||
178906 | 249551 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 380 Fern St | 3 | : | Tree | Private 2 | 7 | Width 2ft | 6005490.31575 | 2114993.82461 | 37.7876801439695 | -122.424807261672 | (37.7876801439695, -122.424807261672) | 13 | 9 | 1 | 28858 | 41 | |||
182415 | 125459 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 2371 Broadway | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | Width 4ft | 6002302.24315 | 2117372.64149 | 37.7940311814406 | -122.436007644151 | (37.7940311814406, -122.436007644151) | 13 | 9 | 1 | 29490 | 27 | |||
183777 | 125442 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 3719 Scott St | 1 | : | Tree | Private 2 | 1 | Width 3ft | 6000612.64349 | 2121133.322 | 37.8042608824853 | -122.442123892024 | (37.8042608824853, -122.442123892024) | 13 | 9 | 1 | 57 | 17 | |||
187360 | 24505 | Permitted Site 7 | Afrocarpus gracilior :: Fern Pine 89 | 360X Fern St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 3X3 | 6005509.85054 | 2114996.70292 | 37.787689150419 | -122.424739879851 | (37.787689150419, -122.424739879851) | 13 | 9 | 1 | 28858 | 41 | |||
193686 | 16402 | Permitted Site 7 | Afrocarpus gracilior :: Fern Pine 89 | 299X Myrtle St | 8 | 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 | ||
194134 | 125498 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 1154 Chestnut St | 6 | Sidewalk: Property side : Yard | Tree | Private 2 | 8 | Width 2ft | 6006270.07079 | 2120429.11585 | 37.8026480985929 | -122.422495818752 | (37.8026480985929, -122.422495818752) | 5 | 9 | 1 | 28858 | 32 | |||
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 | ||
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 | |||
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 | |
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 | ||
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 | ||
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 | |||
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 | |||
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 | ||
76087 | 203454 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 5 Madrone Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 5993011.06637 | 2099068.79194 | 37.7432414634178 | -122.466824576891 | (37.7432414634178, -122.466824576891) | 1 | 8 | 4 | 59 | 40 | |||
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 | ||
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 | ||
109866 | 203481 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 90 Manor Dr | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 5993650.09212 | 2093481.64213 | 37.7279373979817 | -122.464209479697 | (37.7279373979817, -122.464209479697) | 9 | 8 | 4 | 59 | 40 | |||
113481 | 203452 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 1515 16th Ave | 5 | Side Yard : Yard | Tree | Private 2 | 10 | Width 8ft | 5991186.2272 | 2105007.12865 | 37.7594410971589 | -122.473567404026 | (37.7594410971589, -122.473567404026) | 1 | 8 | 4 | 56 | 12 | |||
114646 | 203456 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 89 Manor Dr | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 2ft | 5993632.52713 | 2093523.86417 | 37.7280523169437 | -122.46427326591 | (37.7280523169437, -122.46427326591) | 9 | 8 | 4 | 59 | 40 | |||
116295 | 203480 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 90 Manor Dr | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 5993659.30191 | 2093497.00296 | 37.7279801058879 | -122.464178756148 | (37.7279801058879, -122.464178756148) | 9 | 8 | 4 | 59 | 40 | |||
116310 | 203447 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 327 Ralston St | 1 | : | Tree | Private 2 | 3 | Width 3ft | 5992190.09276 | 2090032.52678 | 37.7183827154591 | -122.469005784505 | (37.7183827154591, -122.469005784505) | 9 | 8 | 6 | 64 | 24 | |||
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 | ||
126408 | 203453 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 2658 16th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 5991457.8354 | 2097316.5348 | 37.7383404469611 | -122.47206749851 | (37.7383404469611, -122.47206749851) | 1 | 8 | 4 | 29491 | 40 | |||
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 | ||
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 | ||
129489 | 203476 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 2357 16th Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 7 | Width 3ft | 5991292.10233 | 2099373.67062 | 37.7439792231731 | -122.472790471621 | (37.7439792231731, -122.472790471621) | 1 | 8 | 4 | 29491 | 40 | |||
130229 | 203475 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 2357 16th Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 8 | Width 3ft | 5991280.39863 | 2099387.14513 | 37.7440155431828 | -122.472831922275 | (37.7440155431828, -122.472831922275) | 1 | 8 | 4 | 29491 | 40 | |||
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 | ||
131502 | 203477 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 2331 18th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 5990713.76496 | 2099522.32344 | 37.7443538888309 | -122.474801058017 | (37.7443538888309, -122.474801058017) | 1 | 8 | 4 | 29491 | 40 | |||
131834 | 92415 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 1507 37th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/29/2009 12:00:00 AM | 0 | 3x3 | Permit Number 52808 | 5984617.9 | 2104898.8 | 37.758761083263 | -122.496275574595 | (37.758761083263, -122.496275574595) | 1 | 8 | 3 | 56 | 35 |
133085 | 92446 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 1554 46th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/30/2009 12:00:00 AM | 4 | 3x3 | Permit Number 52837 | 5981923.4 | 2104509.6 | 37.7575342433798 | -122.505565385243 | (37.7575342433798, -122.505565385243) | 1 | 8 | 3 | 56 | 35 |
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 | ||
137655 | 203479 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 90 Manor Dr | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 5993668.24229 | 2093512.36945 | 37.7280228137991 | -122.464148964325 | (37.7280228137991, -122.464148964325) | 9 | 8 | 4 | 59 | 40 | |||
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 | |
142886 | 203474 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 663 16th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 5991409.42461 | 2097303.39162 | 37.7383015575699 | -122.472233919881 | (37.7383015575699, -122.472233919881) | 1 | 8 | 4 | 29491 | 40 | |||
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 | ||
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 | ||
153760 | 203450 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 1515 16th Ave | 3 | Side Yard : Yard | Tree | Private 2 | 9 | Width 8ft | 5991181.21192 | 2105021.0246 | 37.7594789613077 | -122.4735857628 | (37.7594789613077, -122.4735857628) | 1 | 8 | 4 | 56 | 12 | |||
155948 | 102478 | Significant Tree 6 | Afrocarpus gracilior :: Fern Pine 89 | 760 Victoria St | 4 | Front Yard : Yard | Tree | Private 2 | 5993664.7 | 2092172.3 | 37.7243431058269 | -122.464063971167 | (37.7243431058269, -122.464063971167) | 9 | 8 | 4 | 59 | 40 | |||||
159467 | 86884 | Permitted Site 7 | Afrocarpus gracilior :: Fern Pine 89 | 2534 46th Ave | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/23/2007 12:00:00 AM | 3x3 | Permit Number 49809 | 5982151.4 | 2097835.7 | 37.7392229927812 | -122.504282496051 | (37.7392229927812, -122.504282496051) | 1 | 8 | 3 | 29491 | 35 | |||
159786 | 203459 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 65 Manor Dr | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 2ft | 5993538.98145 | 2093351.56708 | 37.7275738389626 | -122.464584148065 | (37.7275738389626, -122.464584148065) | 9 | 8 | 4 | 59 | 40 | |||
159986 | 203472 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 126 Howth St | 1 | : | Tree | Private 2 | 5 | Width 3ft | 5997592.47815 | 2091138.0222 | 37.7217288104277 | -122.450411736413 | (37.7217288104277, -122.450411736413) | 9 | 8 | 6 | 28861 | 24 | |||
160014 | 203449 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 1474 Funston Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 5992141.42239 | 2105406.9692 | 37.7605942249661 | -122.470293017429 | (37.7605942249661, -122.470293017429) | 1 | 8 | 4 | 56 | 12 | |||
164597 | 203471 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 410 Faxon Ave | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 7 | Width 1ft | 5994790.95036 | 2091337.27547 | 37.7221151744519 | -122.460110243003 | (37.7221151744519, -122.460110243003) | 9 | 8 | 4 | 28861 | 24 | |||
165325 | 203448 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 1880 16th Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | Width 5ft | 5991280.81784 | 2102617.46384 | 37.7528851842202 | -122.473065997797 | (37.7528851842202, -122.473065997797) | 1 | 8 | 4 | 56 | 12 | |||
167613 | 33368 | Permitted Site 7 | Afrocarpus gracilior :: Fern Pine 89 | 90 Manor Dr | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/14/1996 12:00:00 AM | Permit Number 37499 | 5993674.94282707 | 2093510.9416498 | 37.7280192795988 | -122.464125696941 | (37.7280192795988, -122.464125696941) | 9 | 8 | 4 | 59 | 40 | ||
170131 | 45807 | Permitted Site 7 | Afrocarpus gracilior :: Fern Pine 89 | 1993 14th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/28/2001 12:00:00 AM | Permit Number 44435 | 5991886.15341897 | 2101900.86240585 | 37.7509526116716 | -122.470920456526 | (37.7509526116716, -122.470920456526) | 1 | 8 | 4 | 29491 | 12 | |||
173833 | 203482 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 43 Dorado Ter | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 3ft | 5994625.10613 | 2092859.45738 | 37.7262851788162 | -122.460793782631 | (37.7262851788162, -122.460793782631) | 9 | 8 | 4 | 28861 | 40 | |||
177681 | 92445 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 2646 45th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/30/2009 12:00:00 AM | 5 | 3x3 | Permit Number 52836 | 5982487.2 | 2097095.3 | 37.7372098007713 | -122.503066669454 | (37.7372098007713, -122.503066669454) | 1 | 8 | 3 | 29491 | 35 |
178388 | 203473 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 128 Howth St | 1 | : | Tree | Private 2 | 10 | Width 3ft | 5997584.72507 | 2091125.26044 | 37.7216933258806 | -122.450437617121 | (37.7216933258806, -122.450437617121) | 9 | 8 | 6 | 28861 | 24 | |||
184137 | 46752 | Permitted Site 7 | Afrocarpus gracilior :: Fern Pine 89 | 375 Victoria St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/24/2002 12:00:00 AM | Permit Number 44854 | 5993218.00754376 | 2089670.83747573 | 37.7174489416695 | -122.465426481993 | (37.7174489416695, -122.465426481993) | 9 | 8 | 6 | 64 | 24 | ||
185576 | 69035 | Permitted Site 7 | Afrocarpus gracilior :: Fern Pine 89 | 1407 38th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/06/1994 12:00:00 AM | Permit Number 33041 | 5984298.37219271 | 2105588.33319884 | 37.7606356257767 | -122.497431537078 | (37.7606356257767, -122.497431537078) | 1 | 8 | 3 | 56 | 35 | ||
189904 | 33365 | Permitted Site 7 | Afrocarpus gracilior :: Fern Pine 89 | 65 Manor Dr | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/14/1996 12:00:00 AM | Permit Number 37497 | 5993537.09779252 | 2093371.5770822 | 37.7276286729381 | -122.464592112193 | (37.7276286729381, -122.464592112193) | 9 | 8 | 4 | 59 | 40 | ||
192377 | 203455 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 5 Madrone Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 5993020.02718 | 2099098.31016 | 37.7433230301343 | -122.466795738355 | (37.7433230301343, -122.466795738355) | 1 | 8 | 4 | 59 | 40 | |||
192901 | 203478 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 2453 Funston Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 5992323.79318 | 2098755.04508 | 37.7423403049648 | -122.469178135975 | (37.7423403049648, -122.469178135975) | 1 | 8 | 4 | 29491 | 40 | |||
2997 | 220656 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 498X Tompkins Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 6008322.74158 | 2096484.80156 | 37.737018204322 | -122.41369790583 | (37.737018204322, -122.41369790583) | 2 | 7 | 7 | 28859 | 2 | |||
4217 | 220655 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 390X Ogden Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6008083.69599 | 2096082.25636 | 37.7358994764657 | -122.414495920166 | (37.7358994764657, -122.414495920166) | 2 | 7 | 7 | 28859 | 2 | |||
4345 | 248094 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 8 Brewster St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 2ft | 6010447.33936 | 2099861.69566 | 37.7464095052133 | -122.406590078085 | (37.7464095052133, -122.406590078085) | 2 | 7 | 7 | 28859 | 2 | |||
4902 | 262165 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 725 Delta St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 09/07/2019 12:00:00 AM | 3 | 6009246.1256 | 2087178.55003 | 37.7115170052904 | -122.409848612702 | (37.7115170052904, -122.409848612702) | 9 | 7 | 8 | 309 | 39 | |||
8154 | 220632 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 18 Kronquist Ct | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | Width 1ft | 6002213.33941 | 2100174.25358 | 37.7468036087954 | -122.435084618683 | (37.7468036087954, -122.435084618683) | 2 | 7 | 5 | 63 | 22 | |||
11971 | 220654 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 390X Ogden Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6008103.73158 | 2096079.3451 | 37.735892608341 | -122.414426443037 | (37.735892608341, -122.414426443037) | 2 | 7 | 7 | 28859 | 2 | |||
14396 | 220653 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 390X Ogden Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6008119.35429 | 2096079.02548 | 37.7358926083592 | -122.41437240636 | (37.7358926083592, -122.41437240636) | 2 | 7 | 7 | 28859 | 2 | |||
14699 | 220657 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 498X Tompkins Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 6008343.07833 | 2096482.99595 | 37.737014388513 | -122.413627464658 | (37.737014388513, -122.413627464658) | 2 | 7 | 7 | 28859 | 2 | |||
14764 | 203487 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 828 Foerster St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 3ft | 5998282.18197 | 2096469.86688 | 37.736408249925 | -122.448411398672 | (37.736408249925, -122.448411398672) | 9 | 7 | 4 | 59 | 40 | |||
15512 | 203483 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 459 Colon Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 7 | Width 3ft | 5995499.06215 | 2095368.93495 | 37.7332258441801 | -122.457954104018 | (37.7332258441801, -122.457954104018) | 9 | 7 | 4 | 59 | 40 | |||
16888 | 171233 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 65 Lisbon St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/27/2019 12:00:00 AM | 3 | Width 3ft | 6003693 | 2093019 | 37.7272408214237 | -122.42945790991 | (37.7272408214237, -122.42945790991) | 9 | 7 | 6 | 28861 | 5 | ||
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 | ||
26386 | 221771 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 155 Conrad St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 2ft | 6001803.9521 | 2096539.96195 | 37.7368014398277 | -122.436240194438 | (37.7368014398277, -122.436240194438) | 2 | 7 | 5 | 63 | 7 | |||
27574 | 203500 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 77 Staples Ave | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 3ft | 5999471.94159 | 2093749.5809 | 37.729006934723 | -122.444102506626 | (37.729006934723, -122.444102506626) | 9 | 7 | 4 | 63 | 40 |
Advanced export
JSON shape: default, array, newline-delimited, object
CREATE TABLE "trees" ( [rowid] INTEGER PRIMARY KEY, [TreeID] TEXT, [qLegalStatus_id] INTEGER REFERENCES [qLegalStatus]([id]), [qSpecies_id] INTEGER, [qAddress] TEXT, [SiteOrder] TEXT, [qSiteInfo] TEXT, [PlantType] TEXT, [qCaretaker_id] INTEGER REFERENCES [qCaretaker]([id]), [qCareAssistant] TEXT, [PlantDate] TEXT, [DBH] TEXT, [PlotSize] TEXT, [PermitNotes] TEXT, [XCoord] TEXT, [YCoord] TEXT, [Latitude] TEXT, [Longitude] TEXT, [Location] TEXT, [Fire Prevention Districts] TEXT, [Police Districts] TEXT, [Supervisor Districts] TEXT, [Zip Codes] TEXT, [Neighborhoods (old)] TEXT, FOREIGN KEY(qSpecies_id) REFERENCES qSpecies(id) );