trees
665 rows where qSpecies_id = 89 sorted by XCoord 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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
111284 | 189200 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 625 Mendell St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | Width 5ft | 6016323.4017 | 2097117.36023 | 37.7392011179238 | -122.386079860717 | (37.7392011179238, -122.386079860717) | 10 | 3 | 8 | 58 | 1 | |||
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 | |||
13613 | 261072 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 1301 Egbert Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/08/2020 04:47:00 PM | 3 | 4x6 | 6014770 | 2090698 | 37.7214887539174 | -122.391002321697 | (37.7214887539174, -122.391002321697) | 10 | 3 | 8 | 58 | 1 | |
32554 | 99407 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 2200X Keith St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/09/2012 12:00:00 AM | 3x3 | Permit Number 768917 | 6014766.6 | 2092880.6 | 37.7274815503989 | -122.391166558925 | (37.7274815503989, -122.391166558925) | 10 | 3 | 8 | 58 | 1 | ||
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 | |
103501 | 99402 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 2201X Keith St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/09/2012 12:00:00 AM | 7 | 3x3 | Permit Number 768917 | 6014766.6 | 2092880.6 | 37.7274815503989 | -122.391166558925 | (37.7274815503989, -122.391166558925) | 10 | 3 | 8 | 58 | 1 | |
114783 | 99408 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 2200X Keith St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/09/2012 12:00:00 AM | 3x3 | Permit Number 768917 | 6014766.6 | 2092880.6 | 37.7274815503989 | -122.391166558925 | (37.7274815503989, -122.391166558925) | 10 | 3 | 8 | 58 | 1 | ||
129408 | 99404 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 2200X Keith St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/09/2012 12:00:00 AM | 3x3 | Permit Number 768917 | 6014766.6 | 2092880.6 | 37.7274815503989 | -122.391166558925 | (37.7274815503989, -122.391166558925) | 10 | 3 | 8 | 58 | 1 | ||
139862 | 99405 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 2200X Keith St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/09/2012 12:00:00 AM | 3x3 | Permit Number 768917 | 6014766.6 | 2092880.6 | 37.7274815503989 | -122.391166558925 | (37.7274815503989, -122.391166558925) | 10 | 3 | 8 | 58 | 1 | ||
140669 | 99403 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 2200X Keith St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/09/2012 12:00:00 AM | 3x3 | Permit Number 768917 | 6014766.6 | 2092880.6 | 37.7274815503989 | -122.391166558925 | (37.7274815503989, -122.391166558925) | 10 | 3 | 8 | 58 | 1 | ||
184139 | 99406 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 2200X Keith St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/09/2012 12:00:00 AM | 3x3 | Permit Number 768917 | 6014766.6 | 2092880.6 | 37.7274815503989 | -122.391166558925 | (37.7274815503989, -122.391166558925) | 10 | 3 | 8 | 58 | 1 | ||
20384 | 189165 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 1000 Pennsylvania Ave | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 7 | Width 3ft | 6014460.44489 | 2102480.94268 | 37.753825107047 | -122.392896328823 | (37.753825107047, -122.392896328823) | 10 | 3 | 8 | 28856 | 29 | |||
182127 | 189164 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 900 Pennsylvania Ave | 12 | Sidewalk: Property side : Yard | Tree | Private 2 | 2 | 6014453.29453 | 2102557.37778 | 37.7540345843346 | -122.392926403935 | (37.7540345843346, -122.392926403935) | 10 | 3 | 8 | 28856 | 29 | ||||
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 | ||
94900 | 34852 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 481 Mississippi St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/30/1997 12:00:00 AM | 9 | Permit Number 38475 | 6014107.65557 | 2104887.53933 | 37.760413499915 | -122.394284848775 | (37.760413499915, -122.394284848775) | 10 | 3 | 8 | 28856 | 29 | ||
29617 | 50533 | Permitted Site 7 | Afrocarpus gracilior :: Fern Pine 89 | 481 Mississippi St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/06/2003 12:00:00 AM | Permit Number 47172 | 6014106.88689945 | 2104884.78697192 | 37.760405899811 | -122.394287314563 | (37.760405899811, -122.394287314563) | 10 | 3 | 8 | 28856 | 29 | |||
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 | |||
117987 | 92782 | Permitted Site 7 | Afrocarpus gracilior :: Fern Pine 89 | 527 Bryant St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | Permit Number 52999 | 6013573 | 2112256 | 37.7806159117786 | -122.396650538079 | (37.7806159117786, -122.396650538079) | 6 | 2 | 9 | 28856 | 34 | |||
158434 | 92783 | Permitted Site 7 | Afrocarpus gracilior :: Fern Pine 89 | 527 Bryant St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/15/2009 12:00:00 AM | 3x3 | Permit Number 52999 | 6013573 | 2112256 | 37.7806159117786 | -122.396650538079 | (37.7806159117786, -122.396650538079) | 6 | 2 | 9 | 28856 | 34 | ||
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 | |||
178492 | 189181 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 40 Bluxome St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 17 | Width 2ft | 6013494.87898 | 2110935.49205 | 37.7769857497279 | -122.396828192679 | (37.7769857497279, -122.396828192679) | 6 | 2 | 9 | 28856 | 34 | |||
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 | |||
13876 | 189183 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 40 Bluxome St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 2ft | 6013471.29582 | 2110911.40867 | 37.7769183095594 | -122.396908085761 | (37.7769183095594, -122.396908085761) | 6 | 2 | 9 | 28856 | 34 | |||
123590 | 189184 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 40 Bluxome St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 2ft | 6013459.66135 | 2110901.5969 | 37.776890721054 | -122.396947645136 | (37.776890721054, -122.396947645136) | 6 | 2 | 9 | 28856 | 34 | |||
162596 | 189172 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 1947 Quesada Ave | 1 | : | Tree | Private 2 | 2 | Width 2ft | 6013391.6303 | 2095988.75639 | 37.7359395106896 | -122.396137605077 | (37.7359395106896, -122.396137605077) | 10 | 3 | 8 | 58 | 1 | |||
6336 | 261055 | Private 9 | Afrocarpus gracilior :: Fern Pine 89 | 1948 Quesada Ave | 1 | Front Yard : Cutout | Tree | Private 2 | DPW | 11/20/2019 12:00:00 AM | 3 | 3x3 | Permit Number 780729 | 6013389.35902 | 2096036.97619 | 37.7360717858924 | -122.396148836191 | (37.7360717858924, -122.396148836191) | 10 | 3 | 8 | 58 | 1 |
167693 | 189185 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 40 Bluxome St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 2ft | 6013378.56954 | 2110827.99397 | 37.7766841099114 | -122.397223005848 | (37.7766841099114, -122.397223005848) | 6 | 2 | 9 | 28856 | 34 | |||
8824 | 261056 | Private 9 | Afrocarpus gracilior :: Fern Pine 89 | 1952 Quesada Ave | 1 | Front Yard : Cutout | Tree | Private 2 | DPW | 11/20/2019 12:00:00 AM | 3 | 3x3 | Permit Number 780727 | 6013369.93114 | 2096051.4395 | 37.7361104181421 | -122.396217020065 | (37.7361104181421, -122.396217020065) | 10 | 3 | 8 | 58 | 1 |
86693 | 189186 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 40 Bluxome St | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 17 | Width 2ft | 6013353.39902 | 2110803.04971 | 37.7766142173155 | -122.397308329042 | (37.7766142173155, -122.397308329042) | 6 | 2 | 9 | 28856 | 34 | |||
72478 | 189173 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 1960 Quesada Ave | 1 | : | Tree | Private 2 | 4 | Width 2ft | 6013345.84088 | 2096070.7044 | 37.7361619750843 | -122.396301660307 | (37.7361619750843, -122.396301660307) | 10 | 3 | 8 | 58 | 1 | |||
104873 | 189187 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 40 Bluxome St | 11 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 17 | Width 2ft | 6013322.92845 | 2110771.0682 | 37.7765247068749 | -122.397411492965 | (37.7765247068749, -122.397411492965) | 6 | 2 | 9 | 28856 | 34 | |||
86176 | 189188 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 40 Bluxome St | 12 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 2ft | 6013301.8737 | 2110750.05964 | 37.7764658498439 | -122.397482854168 | (37.7764658498439, -122.397482854168) | 6 | 2 | 9 | 28856 | 34 | |||
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 | |||
131146 | 189190 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 40 Bluxome St | 14 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 2ft | 6013250.96845 | 2110705.54176 | 37.7763407793478 | -122.397655827955 | (37.7763407793478, -122.397655827955) | 6 | 2 | 9 | 28856 | 34 | |||
121744 | 189191 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 40 Bluxome St | 15 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 2ft | 6013220.72643 | 2110673.77845 | 37.7762518804538 | -122.397758215766 | (37.7762518804538, -122.397758215766) | 6 | 2 | 9 | 28856 | 34 | |||
9227 | 249036 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 14 Carr St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/19/2019 12:00:00 AM | 3 | 4x6 | 6013092.81558 | 2091032.06192 | 37.7223128112827 | -122.396823338154 | (37.7223128112827, -122.396823338154) | 10 | 3 | 8 | 58 | 1 | |
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 | |||
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 | ||
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 | ||
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 | ||
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
1725 | 261074 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 545 Thornton Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/19/2019 12:00:00 AM | 3 | 4x6 | 6012421 | 2094417 | 37.7315697407484 | -122.399383175238 | (37.7315697407484, -122.399383175238) | 10 | 3 | 8 | 58 | 1 | |
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 | |||
108852 | 189154 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 100 Shipley St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6012314.00092 | 2112536.43535 | 37.7813157722581 | -122.401025754031 | (37.7813157722581, -122.401025754031) | 6 | 2 | 9 | 28856 | 34 | |||
32468 | 189167 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 1300x De Haro St | 18 | Median : Yard | Tree | DPW 1 | 1 | 6012264.80612 | 2102152.75254 | 37.7528017667079 | -122.40046634965 | (37.7528017667079, -122.40046634965) | 10 | 3 | 8 | 28856 | 29 | ||||
144036 | 189155 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 100 Shipley St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6012260.87565 | 2112478.52323 | 37.7811537953404 | -122.401205471869 | (37.7811537953404, -122.401205471869) | 6 | 2 | 9 | 28856 | 34 | |||
179959 | 189166 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 1300x De Haro St | 20 | Median : Yard | Tree | DPW 1 | 1 | 6012257.93832 | 2102144.48011 | 37.752778669414 | -122.40048951887 | (37.752778669414, -122.40048951887) | 10 | 3 | 8 | 28856 | 29 | ||||
23055 | 189156 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 100 Shipley St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6012246.95244 | 2112466.10025 | 37.7811189079475 | -122.401252766302 | (37.7811189079475, -122.401252766302) | 6 | 2 | 9 | 28856 | 34 | |||
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 | |||
180103 | 95587 | Permitted Site 7 | Afrocarpus gracilior :: Fern Pine 89 | 821 Folsom St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/10/2009 12:00:00 AM | 3x3 | Permit Number 767377 | 6012153 | 2112651 | 37.7816213577124 | -122.401590796207 | (37.7816213577124, -122.401590796207) | 6 | 2 | 9 | 28856 | 34 | |
185797 | 114540 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 804 De Haro St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/24/2015 12:00:00 AM | 1 | 3x3 | Permit Number 774890 | 6012104.44502 | 2104594.78019 | 37.7594980943773 | -122.401192496453 | (37.7594980943773, -122.401192496453) | 10 | 3 | 8 | 28856 | 29 | |
79287 | 189192 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 30 15th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 4ft | 6012099.20346 | 2107516.84427 | 37.7675211379264 | -122.401415981588 | (37.7675211379264, -122.401415981588) | 14 | 3 | 8 | 28856 | 20 | |||
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 | |||
149326 | 189194 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 30 15th St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 4ft | 6012053.23647 | 2107512.8913 | 37.7675077191257 | -122.40157469843 | (37.7675077191257, -122.40157469843) | 14 | 3 | 8 | 28856 | 20 | |||
73766 | 189195 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 30 15th St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 4ft | 6012037.52857 | 2107512.72185 | 37.7675063773463 | -122.401629018386 | (37.7675063773463, -122.401629018386) | 14 | 3 | 8 | 28856 | 20 | |||
138354 | 189196 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 30 15th St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 4ft | 6012020.7847 | 2107509.88543 | 37.7674976548329 | -122.401686734167 | (37.7674976548329, -122.401686734167) | 14 | 3 | 8 | 28856 | 20 | |||
157070 | 189169 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 2098 20th St | 5 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | Width 7ft | 6011892.76134 | 2104699.04319 | 37.7597725656737 | -122.401931937014 | (37.7597725656737, -122.401931937014) | 10 | 3 | 8 | 28856 | 29 | |||
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 | |
172548 | 94178 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 1379 Kansas St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/22/2010 12:00:00 AM | 5 | 3x3 | Permit Number 53590 | 6011748.15969 | 2101956.87191 | 37.7522350957877 | -122.402239247057 | (37.7522350957877, -122.402239247057) | 10 | 3 | 8 | 28856 | 29 | |
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 | |
1616 | 249984 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 226 Filbert St | 2 | Front Yard : Yard | Tree | Private 2 | 10 | Width 0ft | 6011604.5053 | 2120111.99388 | 37.8020768465317 | -122.404013554575 | (37.8020768465317, -122.404013554575) | 3 | 1 | 10 | 308 | 23 | |||
31461 | 249983 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 226 Filbert St | 1 | Front Yard : Yard | Tree | Private 2 | 13 | Width 0ft | 6011603.53088 | 2120119.93244 | 37.8020985894405 | -122.404017485543 | (37.8020985894405, -122.404017485543) | 3 | 1 | 10 | 308 | 23 | |||
67291 | 249985 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 228 Filbert St | 1 | Front Yard : Yard | Tree | Private 2 | 4 | Width 0ft | 6011591.62105 | 2120106.88257 | 37.802062092258 | -122.404057780558 | (37.802062092258, -122.404057780558) | 3 | 1 | 10 | 308 | 23 | |||
133816 | 249986 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 228 Filbert St | 2 | Front Yard : Yard | Tree | Private 2 | 4 | Width 0ft | 6011589.33259 | 2120106.08083 | 37.802059763014 | -122.404065643309 | (37.802059763014, -122.404065643309) | 3 | 1 | 10 | 308 | 23 | |||
125066 | 249987 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 228 Filbert St | 3 | Front Yard : Yard | Tree | Private 2 | 3 | Width 0ft | 6011587.32256 | 2120104.99043 | 37.802056656736 | -122.404072522227 | (37.802056656736, -122.404072522227) | 3 | 1 | 10 | 308 | 23 | |||
34762 | 249988 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 228 Filbert St | 4 | Front Yard : Yard | Tree | Private 2 | 3 | Width 0ft | 6011583.89861 | 2120104.21147 | 37.8020543265962 | -122.404084315938 | (37.8020543265962, -122.404084315938) | 3 | 1 | 10 | 308 | 23 | |||
64944 | 249989 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 228 Filbert St | 5 | Front Yard : Yard | Tree | Private 2 | 2 | Width 0ft | 6011581.89407 | 2120103.40396 | 37.8020519973709 | -122.404091195777 | (37.8020519973709, -122.404091195777) | 3 | 1 | 10 | 308 | 23 | |||
116144 | 249990 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 228 Filbert St | 6 | Front Yard : Yard | Tree | Private 2 | 2 | Width 0ft | 6011580.18498 | 2120103.15607 | 37.802051221233 | -122.404097092619 | (37.802051221233, -122.404097092619) | 3 | 1 | 10 | 308 | 23 | |||
150432 | 249991 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 228 Filbert St | 7 | Front Yard : Yard | Tree | Private 2 | 2 | Width 0ft | 6011578.47013 | 2120102.62532 | 37.8020496681084 | -122.404102989475 | (37.8020496681084, -122.404102989475) | 3 | 1 | 10 | 308 | 23 | |||
164019 | 189199 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 380 Clementina St | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 3ft | 6011498.9088 | 2112374.96394 | 37.7808269070747 | -122.403834223497 | (37.7808269070747, -122.403834223497) | 6 | 2 | 9 | 28853 | 34 | |||
89640 | 116047 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 650x Kansas St | 3 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 11 | 5x12 | 6011496.1211 | 2105415.82819 | 37.761718552879 | -122.403354153666 | (37.761718552879, -122.403354153666) | 10 | 3 | 8 | 28856 | 29 | ||
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 | |||
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 | |||
182215 | 249950 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 303 Filbert St | 5 | Side Yard : Yard | Tree | Private 2 | 9 | Width 0ft | 6011359.33086 | 2120056.95578 | 37.8019120241928 | -122.404858102512 | (37.8019120241928, -122.404858102512) | 3 | 1 | 10 | 308 | 23 | |||
127021 | 249949 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 303 Filbert St | 6 | Side Yard : Yard | Tree | Private 2 | 14 | Width 0ft | 6011354.62644 | 2120055.4997 | 37.801907763195 | -122.404874279527 | (37.801907763195, -122.404874279527) | 3 | 1 | 10 | 308 | 23 | |||
190022 | 249946 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 305 Filbert St | 1 | Front Yard : Yard | Tree | Private 2 | 12 | Width 0ft | 6011346.83837 | 2120055.65824 | 37.8019077631812 | -122.404901241218 | (37.8019077631812, -122.404901241218) | 3 | 1 | 10 | 308 | 23 | |||
70085 | 249947 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 305 Filbert St | 2 | Front Yard : Yard | Tree | Private 2 | 7 | Width 0ft | 6011342.9125 | 2120054.18632 | 37.8019035022036 | -122.40491472295 | (37.8019035022036, -122.40491472295) | 3 | 1 | 10 | 308 | 23 | |||
121322 | 249948 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 305 Filbert St | 3 | Front Yard : Yard | Tree | Private 2 | 18 | Width 0ft | 6011338.9869 | 2120052.71472 | 37.8018992421182 | -122.40492820377 | (37.8018992421182, -122.40492820377) | 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 | |||
79988 | 201923 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 125 Elmira St | 1 | : | Tree | Private 2 | 13 | Width 4ft | 6011215.48386 | 2096005.8192 | 37.7358650396404 | -122.403662651736 | (37.7358650396404, -122.403662651736) | 10 | 3 | 8 | 58 | 1 | |||
189345 | 125524 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 220 Lombard St | 8 | Sidewalk: Property side : Yard | Tree | Private 2 | 8 | Width 9ft | 6011207.68462 | 2120726.93894 | 37.8037431562814 | -122.405430083952 | (37.8037431562814, -122.405430083952) | 3 | 1 | 10 | 308 | 23 | |||
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 | |||
144847 | 125525 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 220 Lombard St | 9 | Sidewalk: Property side : Yard | Tree | Private 2 | 8 | Width 9ft | 6011203.66326 | 2120729.63027 | 37.8037503211682 | -122.405444189817 | (37.8037503211682, -122.405444189817) | 3 | 1 | 10 | 308 | 23 | |||
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 | |||
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 | |||
178236 | 249821 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 1690 Kearny St | 3 | Front Yard : Yard | Tree | Private 2 | 14 | Width 0ft | 6010901.87597 | 2120623.17353 | 37.8034411387496 | -122.406481040676 | (37.8034411387496, -122.406481040676) | 3 | 1 | 10 | 308 | 23 | |||
161804 | 249822 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 1690 Kearny St | 4 | Front Yard : Yard | Tree | Private 2 | 10 | Width 0ft | 6010893.58143 | 2120633.65684 | 37.8034694593133 | -122.406510483572 | (37.8034694593133, -122.406510483572) | 3 | 1 | 10 | 308 | 23 | |||
105236 | 249818 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 1690 Kearny St | 7 | Front Yard : Yard | Tree | Private 2 | 24 | Width 0ft | 6010887.46579 | 2120660.30432 | 37.803542284602 | -122.406533525994 | (37.803542284602, -122.406533525994) | 3 | 1 | 10 | 308 | 23 | |||
106507 | 249823 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 1690 Kearny St | 5 | Front Yard : Yard | Tree | Private 2 | 14 | Width 0ft | 6010881.14413 | 2120640.5408 | 37.8034876651725 | -122.406554008974 | (37.8034876651725, -122.406554008974) | 3 | 1 | 10 | 308 | 23 | |||
168658 | 189163 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 2324 19th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 4ft | 6010839.47216 | 2105097.25682 | 37.7608071304715 | -122.405602811334 | (37.7608071304715, -122.405602811334) | 10 | 3 | 8 | 28856 | 29 | |||
30380 | 220601 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 75 Montcalm St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6010687.7942 | 2100021.12984 | 37.7468607265348 | -122.405769837005 | (37.7468607265348, -122.405769837005) | 2 | 7 | 7 | 28859 | 2 | |||
128586 | 220600 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 75 Montcalm St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6010666.22738 | 2100038.82593 | 37.7469081100366 | -122.405845659758 | (37.7469081100366, -122.405845659758) | 2 | 7 | 7 | 28859 | 2 | |||
90963 | 32134 | Permitted Site 7 | Afrocarpus gracilior :: Fern Pine 89 | 842 Washington St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/15/1995 12:00:00 AM | Permit Number 35494 | 6010631.11006318 | 2117599.53652258 | 37.7951238190257 | -122.407204773258 | (37.7951238190257, -122.407204773258) | 3 | 1 | 10 | 28857 | 4 | ||
187634 | 32133 | Permitted Site 7 | Afrocarpus gracilior :: Fern Pine 89 | 842 Washington St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/15/1995 12:00:00 AM | Permit Number 35494 | 6010631.11006318 | 2117599.53652258 | 37.7951238190257 | -122.407204773258 | (37.7951238190257, -122.407204773258) | 3 | 1 | 10 | 28857 | 4 | ||
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 |
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) );