trees
665 rows where qSpecies_id = 89 sorted by Neighborhoods (old) 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) ▲ |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
33499 | 246911 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 459 Frederick St | 2 | : | Tree | Private 2 | 3 | Width 3ft | 5997556.58518 | 2107424.48902 | 37.7664454174412 | -122.451710064262 | (37.7664454174412, -122.451710064262) | 15 | 5 | 11 | 29492 | 9 | |||
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 | |||
102881 | 220639 | Undocumented 4 | Afrocarpus gracilior :: Fern Pine 89 | 1202 Stanyan St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 11 | Width 3ft | 5997451.78012 | 2105807.14899 | 37.7619986098677 | -122.451955868771 | (37.7619986098677, -122.451955868771) | 15 | 5 | 11 | 29492 | 9 | |||
129730 | 221766 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 712 Waller St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6002158.80169 | 2108813.78872 | 37.7705225892682 | -122.435891276388 | (37.7705225892682, -122.435891276388) | 15 | 5 | 11 | 29492 | 9 | |||
184630 | 17102 | Permitted Site 7 | Afrocarpus gracilior :: Fern Pine 89 | 1711 Oak St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | 3X3 | 5998685.53291 | 2109300.56616 | 37.771661239802 | -122.447940341436 | (37.771661239802, -122.447940341436) | 15 | 5 | 11 | 29492 | 9 | |||
186373 | 96486 | Undocumented 4 | Afrocarpus gracilior :: Fern Pine 89 | 1202 Stanyan St | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | 5997433 | 2105848 | 37.7621097006999 | -122.452023768999 | (37.7621097006999, -122.452023768999) | 15 | 5 | 11 | 29492 | 9 | |||||
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 | |||
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 | |||
74822 | 27714 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 5587 Diamond Heights Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3 | 3X3 | 6001610.45471 | 2097108.73364 | 37.7383521588292 | -122.436949905209 | (37.7383521588292, -122.436949905209) | 2 | 7 | 5 | 63 | 7 | |||
86050 | 221773 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 5587 Diamond Heights Blvd | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 2ft | 6001626.70915 | 2097120.97663 | 37.7383866990834 | -122.436894581628 | (37.7383866990834, -122.436894581628) | 2 | 7 | 5 | 63 | 7 | |||
105770 | 221768 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 1888 Church St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6004580.21183 | 2097666.30062 | 37.7400514583975 | -122.426721628722 | (37.7400514583975, -122.426721628722) | 2 | 7 | 5 | 63 | 7 | |||
131367 | 221774 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 5587 Diamond Heights Blvd | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | Width 2ft | 6001628.85719 | 2097123.02869 | 37.7383924556487 | -122.43688730163 | (37.7383924556487, -122.43688730163) | 2 | 7 | 5 | 63 | 7 | |||
135354 | 221772 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 71 Miguel St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6003850.95701 | 2097297.26656 | 37.7389969178725 | -122.429216785123 | (37.7389969178725, -122.429216785123) | 2 | 7 | 5 | 63 | 7 | |||
160075 | 221770 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 155 Conrad St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 2ft | 6001816.47531 | 2096513.16567 | 37.7367285749736 | -122.436194979235 | (37.7367285749736, -122.436194979235) | 2 | 7 | 5 | 63 | 7 | |||
178418 | 221769 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 155 Conrad St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 2ft | 6001830.02285 | 2096488.5302 | 37.7366617013818 | -122.436146377158 | (37.7366617013818, -122.436146377158) | 2 | 7 | 5 | 63 | 7 | |||
179956 | 220635 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 628 Chenery St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 2ft | 6002826.10631 | 2095715.40994 | 37.7345954316319 | -122.432647280541 | (37.7345954316319, -122.432647280541) | 2 | 7 | 5 | 63 | 7 | |||
180034 | 220634 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 628 Chenery St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 3ft | 6002844.7092 | 2095716.31094 | 37.7345989605548 | -122.432583028494 | (37.7345989605548, -122.432583028494) | 2 | 7 | 5 | 63 | 7 | |||
192892 | 220637 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 79 Bemis St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6003700.73164 | 2096802.65879 | 37.7376303323698 | -122.429700927958 | (37.7376303323698, -122.429700927958) | 2 | 7 | 5 | 63 | 7 | |||
194147 | 221775 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 21 Addison St | 14 | Back Yard : Yard | Tree | Private 2 | 10 | Width 3ft | 6003667.46569 | 2096848.61536 | 37.737754634878 | -122.429819221204 | (37.737754634878, -122.429819221204) | 2 | 7 | 5 | 63 | 7 | |||
22266 | 189179 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 1 Anthony St | 5 | Sidewalk: Curb side : Yard | Tree | Private 2 | 1 | Width 5ft | 6012646.32236 | 2115321.24239 | 37.7889807363318 | -122.400071707361 | (37.7889807363318, -122.400071707361) | 12 | 2 | 9 | 28855 | 6 | |||
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 | |||
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 | ||
67570 | 189177 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 1 Anthony St | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 1 | Width 5ft | 6012656.64503 | 2115309.49846 | 37.7889490657959 | -122.400035166996 | (37.7889490657959, -122.400035166996) | 12 | 2 | 9 | 28855 | 6 | |||
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 | ||
93816 | 189197 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 453 Bryant St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6014136.4691 | 2112772.98188 | 37.7820667700107 | -122.394737429894 | (37.7820667700107, -122.394737429894) | 6 | 2 | 9 | 28856 | 6 | |||
118456 | 62043 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 453 Bryant St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/29/1993 12:00:00 AM | 3 | Permit Number 31992 | 6014123.24012 | 2112760.57959 | 37.7820319806273 | -122.394782327659 | (37.7820319806273, -122.394782327659) | 6 | 2 | 9 | 28856 | 6 | ||
119465 | 189175 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 1 Anthony St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 1 | Width 5ft | 6012666.59913 | 2115298.53532 | 37.7889195185657 | -122.399999956726 | (37.7889195185657, -122.399999956726) | 12 | 2 | 9 | 28855 | 6 | |||
162391 | 189180 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 123 Clementina St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 2ft | 6012900.45208 | 2113712.93045 | 37.7845788525671 | -122.399079511431 | (37.7845788525671, -122.399079511431) | 6 | 2 | 9 | 28853 | 6 | |||
176265 | 189176 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 1 Anthony St | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 1 | Width 5ft | 6012661.31608 | 2115304.65409 | 37.7889360247231 | -122.400018665349 | (37.7889360247231, -122.400018665349) | 12 | 2 | 9 | 28855 | 6 | |||
191382 | 33001 | Permitted Site 7 | Afrocarpus gracilior :: Fern Pine 89 | 255 03rd St | 1 | 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 | ||
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 | ||||
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 | ||
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
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 | ||||
70271 | 110030 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 327 Edinburgh St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/19/2015 12:00:00 AM | 3 | 3x3 | Permit Number 774319 | 6003526.63098 | 2091782.51819 | 37.7238362969822 | -122.429944883475 | (37.7238362969822, -122.429944883475) | 9 | 7 | 6 | 28861 | 5 |
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 | ||
100507 | 175171 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 399 Vienna St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | Width 3ft | 6003766.26192 | 2091125.79977 | 37.7220466613948 | -122.429069717203 | (37.7220466613948, -122.429069717203) | 9 | 7 | 6 | 28861 | 5 | |||
103260 | 175173 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 399 Vienna St | 5 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | Width 3ft | 6003787.7125 | 2091165.48018 | 37.7221568292683 | -122.428998395553 | (37.7221568292683, -122.428998395553) | 9 | 7 | 6 | 28861 | 5 | |||
115910 | 253132 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 522 Avalon Ave | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Width 3ft | 6004047.94044 | 2092448.57496 | 37.7256946506667 | -122.428190247706 | (37.7256946506667, -122.428190247706) | 9 | 7 | 6 | 28861 | 5 | ||||
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 | ||
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 | ||
163550 | 175166 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 218 Congdon St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6004672.7463 | 2094000.25869 | 37.7299905627997 | -122.426140758388 | (37.7299905627997, -122.426140758388) | 9 | 7 | 6 | 28861 | 5 | |||
170949 | 175170 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 364 Moscow St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6004288.38035 | 2091053.98491 | 37.7218790151804 | -122.427259769545 | (37.7218790151804, -122.427259769545) | 9 | 7 | 6 | 28861 | 5 | |||
10211 | 249538 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 201 Myrtle St | 7 | : | Tree | Private 2 | 4 | Width 3ft | 6006360.10871 | 2114050.01147 | 37.7851377542393 | -122.421730877876 | (37.7851377542393, -122.421730877876) | 13 | 9 | 11 | 28858 | 41 | |||
20069 | 249536 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 201 Myrtle St | 5 | : | Tree | Private 2 | 6 | Width 3ft | 6006331.73852 | 2114045.88325 | 37.7851248193023 | -122.421828736708 | (37.7851248193023, -122.421828736708) | 13 | 9 | 11 | 28858 | 41 | |||
20279 | 7125 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 300X Fern St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/02/1990 12:00:00 AM | 6 | 3X3 | 6005738.17658 | 2115026.96294 | 37.7877851299198 | -122.423952067531 | (37.7877851299198, -122.423952067531) | 13 | 9 | 1 | 28858 | 41 | ||
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 | ||
30986 | 7123 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 300X Fern St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/02/1990 12:00:00 AM | 9 | 3x3 | 6005797.9204 | 2115035.94869 | 37.7878131752727 | -122.423746004087 | (37.7878131752727, -122.423746004087) | 13 | 9 | 1 | 28858 | 41 | ||
32049 | 249535 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 201 Myrtle St | 4 | : | Tree | Private 2 | 5 | Width 3ft | 6006279.61488 | 2114039.53426 | 37.7851044469537 | -122.422008617322 | (37.7851044469537, -122.422008617322) | 13 | 9 | 11 | 28858 | 41 | |||
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 | ||
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 | ||
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 | ||||
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 | ||
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
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 | ||||
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 | ||
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 | ||
77242 | 27669 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 310 Austin St | 2 | 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 | |||
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 | |||
82689 | 24521 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 365 Austin St | 5 | 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 | |||
84543 | 256847 | Undocumented 4 | Afrocarpus gracilior :: Fern Pine 89 | 1298x Post St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6006137 | 2114500 | 37.7863607279306 | -122.422534752155 | (37.7863607279306, -122.422534752155) | 13 | 9 | 11 | 28858 | 41 | ||||
87861 | 27666 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 300 Austin St | 2 | 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 | |||
88708 | 256845 | Undocumented 4 | Afrocarpus gracilior :: Fern Pine 89 | 1298x Post St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6006137 | 2114500 | 37.7863607279306 | -122.422534752155 | (37.7863607279306, -122.422534752155) | 13 | 9 | 11 | 28858 | 41 | ||||
90775 | 249549 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 380 Fern St | 1 | : | Tree | Private 2 | 8 | Width 2ft | 6005525.06192 | 2114997.09858 | 37.7876910959164 | -122.424687279516 | (37.7876910959164, -122.424687279516) | 13 | 9 | 1 | 28858 | 41 | |||
94418 | 249544 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 298 Myrtle St | 1 | : | Tree | Private 2 | 6 | Width 3ft | 6006142.87898 | 2114042.34322 | 37.7851044469485 | -122.422481881052 | (37.7851044469485, -122.422481881052) | 13 | 9 | 11 | 28858 | 41 | |||
94779 | 256849 | Undocumented 4 | Afrocarpus gracilior :: Fern Pine 89 | 1298x Post St | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6006137 | 2114500 | 37.7863607279306 | -122.422534752155 | (37.7863607279306, -122.422534752155) | 13 | 9 | 11 | 28858 | 41 | ||||
96258 | 256848 | Undocumented 4 | Afrocarpus gracilior :: Fern Pine 89 | 1298x Post St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6006137 | 2114500 | 37.7863607279306 | -122.422534752155 | (37.7863607279306, -122.422534752155) | 13 | 9 | 11 | 28858 | 41 | ||||
96919 | 249550 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 380 Fern St | 2 | : | Tree | Private 2 | 7 | Width 2ft | 6005507.22761 | 2114996.10092 | 37.7876873493358 | -122.424748911848 | (37.7876873493358, -122.424748911848) | 13 | 9 | 1 | 28858 | 41 | |||
98180 | 7129 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 399X Fern St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/02/1990 12:00:00 AM | 4 | 3X3 | 6005508.68317 | 2114972.65603 | 37.7876230577135 | -122.424742207381 | (37.7876230577135, -122.424742207381) | 13 | 9 | 1 | 28858 | 41 | ||
98279 | 256844 | Undocumented 4 | Afrocarpus gracilior :: Fern Pine 89 | 1298x Post St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6006137 | 2114500 | 37.7863607279306 | -122.422534752155 | (37.7863607279306, -122.422534752155) | 13 | 9 | 11 | 28858 | 41 | ||||
98897 | 7122 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 300X Fern St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/28/2003 12:00:00 AM | 3 | 3x3 | 6005816.45791 | 2115038.11546 | 37.787820171109 | -122.423682021812 | (37.787820171109, -122.423682021812) | 13 | 9 | 1 | 28858 | 41 | ||
99651 | 249529 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 1035 Van Ness Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 4ft | 6006430.75514 | 2114125.51985 | 37.7853490652506 | -122.4214918273 | (37.7853490652506, -122.4214918273) | 13 | 9 | 11 | 28858 | 41 | |||
101500 | 250077 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 399 Austin St | 3 | : | Tree | Private 2 | 13 | Width 3ft | 6005420.83643 | 2115306.80822 | 37.7885355944018 | -122.425069924841 | (37.7885355944018, -122.425069924841) | 13 | 9 | 1 | 28858 | 41 | |||
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 | |||
104419 | 256840 | Undocumented 4 | Afrocarpus gracilior :: Fern Pine 89 | 1298x Post St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6006137 | 2114500 | 37.7863607279306 | -122.422534752155 | (37.7863607279306, -122.422534752155) | 13 | 9 | 11 | 28858 | 41 | ||||
114436 | 250079 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 399 Austin St | 5 | : | Tree | Private 2 | 13 | Width 3ft | 6005448.26526 | 2115310.78255 | 37.7885480563034 | -122.424975308091 | (37.7885480563034, -122.424975308091) | 13 | 9 | 1 | 28858 | 41 | |||
117100 | 256841 | Undocumented 4 | Afrocarpus gracilior :: Fern Pine 89 | 1298x Post St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6006137 | 2114500 | 37.7863607279306 | -122.422534752155 | (37.7863607279306, -122.422534752155) | 13 | 9 | 11 | 28858 | 41 | ||||
128405 | 28059 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 399X Fern St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/28/2003 12:00:00 AM | 3 | 3X3 | 6005443.48959 | 2114960.28563 | 37.7875854093804 | -122.42496688413 | (37.7875854093804, -122.42496688413) | 13 | 9 | 1 | 28858 | 41 | ||
128595 | 256842 | Undocumented 4 | Afrocarpus gracilior :: Fern Pine 89 | 1298x Post St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6006137 | 2114500 | 37.7863607279306 | -122.422534752155 | (37.7863607279306, -122.422534752155) | 13 | 9 | 11 | 28858 | 41 | ||||
129154 | 17785 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 1798X Pine St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3x3 | 6005398.04469 | 2115519.90556 | 37.7891194189645 | -122.425163949857 | (37.7891194189645, -122.425163949857) | 13 | 9 | 1 | 28858 | 41 | |||
131522 | 24519 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 365 Austin St | 3 | 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 | |||
134937 | 27667 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 300 Austin St | 3 | 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 | |||
135907 | 24520 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 365 Austin St | 4 | 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 | |||
136505 | 249533 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 201 Myrtle St | 2 | : | Tree | Private 2 | 3 | Width 3ft | 6006226.92854 | 2114031.46887 | 37.78507932978 | -122.42219032262 | (37.78507932978, -122.42219032262) | 13 | 9 | 11 | 28858 | 41 | |||
138069 | 250078 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 399 Austin St | 4 | : | Tree | Private 2 | 8 | Width 3ft | 6005435.52045 | 2115308.45101 | 37.7885409345647 | -122.425019237271 | (37.7885409345647, -122.425019237271) | 13 | 9 | 1 | 28858 | 41 | |||
139279 | 7126 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 300X Fern St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/02/1990 12:00:00 AM | 6 | 3x3 | 6005719.58539 | 2115024.09543 | 37.7877762068484 | -122.424016185622 | (37.7877762068484, -122.424016185622) | 13 | 9 | 1 | 28858 | 41 | ||
139288 | 24518 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 365 Austin St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 3X3 | 6005518.5465766 | 2115307.531712 | 37.7885430999734 | -122.424731913891 | (37.7885430999734, -122.424731913891) | 13 | 9 | 1 | 28858 | 41 |
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) );