trees
665 rows where qSpecies_id = 89 sorted by qCareAssistant
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
45841 | 249532 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 201 Myrtle St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6006202.66878 | 2114026.79682 | 37.7850651330954 | -122.422273921828 | (37.7850651330954, -122.422273921828) | 13 | 9 | 11 | 28858 | 41 | |||
45904 | 27672 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 310 Austin St | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 3X3 | 6005758.15165 | 2115391.49838 | 37.7887871812497 | -122.423908889223 | (37.7887871812497, -122.423908889223) | 13 | 9 | 1 | 28858 | 41 | |||
46149 | 220646 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 816 Crescent Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6008205.0189 | 2095636.66757 | 37.7346828016745 | -122.414044944318 | (37.7346828016745, -122.414044944318) | 2 | 7 | 7 | 28859 | 2 | |||
46336 | 125437 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 1921 Jefferson St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 4ft | 6000052.89269 | 2121248.37983 | 37.8045448847905 | -122.444069220022 | (37.8045448847905, -122.444069220022) | 13 | 9 | 1 | 57 | 17 | |||
46462 | 189178 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 1 Anthony St | 4 | Sidewalk: Curb side : Yard | Tree | Private 2 | 1 | Width 5ft | 6012651.66778 | 2115316.04533 | 37.7889667644596 | -122.400052847677 | (37.7889667644596, -122.400052847677) | 12 | 2 | 9 | 28855 | 6 | |||
46905 | 175167 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 218 Congdon St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6004673.57343 | 2093985.3797 | 37.7299497551534 | -122.426136840057 | (37.7299497551534, -122.426136840057) | 9 | 7 | 6 | 28861 | 5 | |||
47611 | 189171 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 672 Missouri St | 2 | : | Tree | Private 2 | 4 | Width 1ft | 6013547.27138 | 2103937.27162 | 37.7577731065529 | -122.396156373043 | (37.7577731065529, -122.396156373043) | 10 | 3 | 8 | 28856 | 29 | |||
48346 | 203469 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 300 Flood Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | 5998711.43854 | 2094111.50955 | 37.7299572914866 | -122.446757644361 | (37.7299572914866, -122.446757644361) | 9 | 7 | 4 | 28861 | 40 | ||||
48353 | 175174 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 399 Vienna St | 7 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 3ft | 6003793.29108 | 2091173.56486 | 37.7221793437874 | -122.428979687879 | (37.7221793437874, -122.428979687879) | 9 | 7 | 6 | 28861 | 5 | |||
48506 | 125464 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 887 Eddy St | 6 | Sidewalk: Property side : Yard | Tree | Private 2 | 11 | Width 4ft | 6006280.54306 | 2113153.33425 | 37.7826712115607 | -122.4219424317 | (37.7826712115607, -122.4219424317) | 7 | 9 | 11 | 28852 | 41 | |||
48705 | 27670 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 310 Austin St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 3X3 | 6005758.15165 | 2115391.49838 | 37.7887871812497 | -122.423908889223 | (37.7887871812497, -122.423908889223) | 13 | 9 | 1 | 28858 | 41 | |||
49659 | 28777 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 365 Austin St | 6 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6005518.5465766 | 2115307.531712 | 37.7885430999734 | -122.424731913891 | (37.7885430999734, -122.424731913891) | 13 | 9 | 1 | 28858 | 41 | |||
49713 | 189182 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 40 Bluxome St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 2ft | 6013480.92655 | 2110921.93119 | 37.7769477380782 | -122.3968755078 | (37.7769477380782, -122.3968755078) | 6 | 2 | 9 | 28856 | 34 | |||
49839 | 175172 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 399 Vienna St | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | Width 3ft | 6003774.22148 | 2091143.66189 | 37.7220961573958 | -122.42904347589 | (37.7220961573958, -122.42904347589) | 9 | 7 | 6 | 28861 | 5 | |||
50122 | 125517 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 900 Green St | 29 | Sidewalk: Property side : Yard | Tree | Private 2 | 2 | Width 5ft | 6008575.41519 | 2119026.37821 | 37.7989263127569 | -122.414418825785 | (37.7989263127569, -122.414418825785) | 5 | 1 | 10 | 308 | 32 | |||
50975 | 189168 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 606 Kansas St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 3ft | 6011490.76938 | 2105489.27118 | 37.7619199120061 | -122.40337783013 | (37.7619199120061, -122.40337783013) | 10 | 3 | 8 | 28856 | 29 | |||
51090 | 220645 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 816 Crescent Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6008216.92283 | 2095637.52522 | 37.7346858251821 | -122.414003848906 | (37.7346858251821, -122.414003848906) | 2 | 7 | 7 | 28859 | 2 | |||
51119 | 220615 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 3117 20th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6009011.32623 | 2104478.69915 | 37.75900631631 | -122.411881867955 | (37.75900631631, -122.411881867955) | 2 | 4 | 7 | 28859 | 19 | |||
51514 | 125509 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 900 Green St | 13 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | Width 5ft | 6008633.29576 | 2119030.27082 | 37.7989402522368 | -122.414218814773 | (37.7989402522368, -122.414218814773) | 5 | 1 | 10 | 308 | 32 | |||
51637 | 125493 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 1207 Chestnut St | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 3ft | 6006021.47381 | 2120333.65457 | 37.8023719590496 | -122.423349300554 | (37.8023719590496, -122.423349300554) | 5 | 9 | 1 | 28858 | 32 | |||
51653 | 125485 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 1237x Robert C Levy Tunl | 3 | Median : Yard | Tree | DPW 1 | 10 | 6007640.9414 | 2118138.07584 | 37.796434716745 | -122.417589429708 | (37.796434716745, -122.417589429708) | 5 | 1 | 10 | 28858 | 32 | ||||
51677 | 251747 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 706 Rolph St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6002959 | 2087321 | 37.7115537887528 | -122.431588720074 | (37.7115537887528, -122.431588720074) | 9 | 7 | 6 | 28861 | 5 | ||||
51778 | 102757 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 2807 Steiner St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | 3x3 | 6002051.95846 | 2117801.73169 | 37.7951951298959 | -122.436904386043 | (37.7951951298959, -122.436904386043) | 13 | 9 | 1 | 57 | 27 | |||
52978 | 220603 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 418 Valley St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 2ft | 6003167.3476 | 2099231.48151 | 37.7442691016478 | -122.431718451765 | (37.7442691016478, -122.431718451765) | 2 | 7 | 5 | 63 | 22 | |||
54016 | 249820 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 1690 Kearny St | 2 | Front Yard : Yard | Tree | Private 2 | 13 | Width 0ft | 6010902.80513 | 2120614.31353 | 37.8034168633488 | -122.406477200573 | (37.8034168633488, -122.406477200573) | 3 | 1 | 10 | 308 | 23 | |||
54339 | 249939 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 331 Filbert St | 1 | Front Yard : Yard | Tree | Private 2 | 7 | Width 0ft | 6011281.55151 | 2120038.154 | 37.8018560512652 | -122.40512593233 | (37.8018560512652, -122.40512593233) | 3 | 1 | 10 | 308 | 23 | |||
54441 | 125460 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 2416 Webster St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 4ft | 6003175.77984 | 2117097.00502 | 37.7933239410913 | -122.432965418428 | (37.7933239410913, -122.432965418428) | 13 | 9 | 1 | 29490 | 27 | |||
54594 | 220611 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 1 Bradford St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 4ft | 6009641.7814 | 2098664.71567 | 37.7430777589371 | -122.409291162184 | (37.7430777589371, -122.409291162184) | 10 | 7 | 7 | 28859 | 2 | |||
55157 | 125470 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 655 Powell St | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | Width 2ft | 6010075.12389 | 2116032.87575 | 37.7907910167417 | -122.409017984115 | (37.7907910167417, -122.409017984115) | 5 | 1 | 10 | 28857 | 21 | |||
55420 | 189193 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 30 15th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 4ft | 6012073.86009 | 2107513.44954 | 37.7675104026963 | -122.401503402873 | (37.7675104026963, -122.401503402873) | 14 | 3 | 8 | 28856 | 20 | |||
55814 | 125511 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 900 Green St | 15 | Sidewalk: Property side : Yard | Tree | Private 2 | 2 | Width 5ft | 6008625.76186 | 2119029.22421 | 37.7989369553212 | -122.414244810558 | (37.7989369553212, -122.414244810558) | 5 | 1 | 10 | 308 | 32 | |||
56067 | 203470 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 100 Staples Ave | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 17 | 5999333.68862 | 2093807.88656 | 37.72915914047 | -122.444584644873 | (37.72915914047, -122.444584644873) | 9 | 7 | 4 | 28861 | 40 | ||||
56489 | 220609 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 385 Nevada St | 1 | Sidewalk: Curb side : Pot | Tree | Private 2 | 6 | Width 2ft | 6008945.60793 | 2096515.87148 | 37.737138473362 | -122.411546563846 | (37.737138473362, -122.411546563846) | 10 | 7 | 7 | 28859 | 2 | |||
56555 | 220659 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 998 Alabama St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6009137.78882 | 2103468.55533 | 37.756239784054 | -122.411373136768 | (37.756239784054, -122.411373136768) | 2 | 4 | 7 | 28859 | 19 | |||
57639 | 189157 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 100 Shipley St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6012230.29612 | 2112453.73281 | 37.7810840205508 | -122.401309519845 | (37.7810840205508, -122.401309519845) | 6 | 2 | 9 | 28856 | 34 | |||
57858 | 189153 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 100 Shipley St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6012332.53447 | 2112551.48713 | 37.7813581348078 | -122.400962694499 | (37.7813581348078, -122.400962694499) | 6 | 2 | 9 | 28856 | 34 | |||
58064 | 189174 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 14 Waterville St | 1 | : | Tree | Private 2 | 10 | Width 1ft | 6011435.76202 | 2096086.73565 | 37.7360995216629 | -122.402906748143 | (37.7360995216629, -122.402906748143) | 10 | 3 | 8 | 58 | 1 | |||
58303 | 81183 | Permitted Site 7 | Afrocarpus gracilior :: Fern Pine 89 | 461 Andover St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/18/2008 12:00:00 AM | 3x3 | Permit Number 50918 | 6007526.59353608 | 2096789.07906061 | 37.7378089430444 | -122.416472100986 | (37.7378089430444, -122.416472100986) | 2 | 7 | 7 | 28859 | 2 | ||
59297 | 125452 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 2401 Broadway | 9 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | Width 4ft | 6002068.61749 | 2117342.59163 | 37.7939353973611 | -122.436813859368 | (37.7939353973611, -122.436813859368) | 13 | 9 | 1 | 29490 | 27 | |||
60268 | 220638 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 222 Parnassus Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 7ft | 5997115.15152 | 2106725.56313 | 37.7645010544003 | -122.453186433611 | (37.7645010544003, -122.453186433611) | 15 | 5 | 11 | 29492 | 12 | |||
60903 | 220636 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 628 Chenery St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 6002799.74223 | 2095713.64114 | 37.734589079726 | -122.432738303627 | (37.734589079726, -122.432738303627) | 2 | 7 | 5 | 63 | 7 | |||
61578 | 106492 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 1747 MCALLISTER ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/02/2018 12:00:00 AM | 12 | 3x3 | Permit Number 773396 | 6000787.4 | 2111331.2 | 37.7773567666582 | -122.440815564147 | (37.7773567666582, -122.440815564147) | 15 | 5 | 11 | 29492 | 41 | |
61917 | 27665 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 300 Austin St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 3X3 | 6005803.78776 | 2115397.87528 | 37.7888072668978 | -122.423751448163 | (37.7888072668978, -122.423751448163) | 13 | 9 | 1 | 28858 | 41 | |||
62496 | 203458 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 65 Manor Dr | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 2ft | 5993554.49033 | 2093381.1926 | 37.7276560774418 | -122.464532684353 | (37.7276560774418, -122.464532684353) | 9 | 8 | 4 | 59 | 40 | |||
62733 | 27668 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 310 Austin St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 3X3 | 6005758.15165 | 2115391.49838 | 37.7887871812497 | -122.423908889223 | (37.7887871812497, -122.423908889223) | 13 | 9 | 1 | 28858 | 41 | |||
62853 | 250093 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 1700 Gough St | 7 | Sidewalk: Curb side : Pot | Tree | Private 2 | 1 | Width 2ft | 6005332.30774 | 2115621.39854 | 37.7893943794989 | -122.425398617158 | (37.7893943794989, -122.425398617158) | 13 | 9 | 1 | 28858 | 41 | |||
62927 | 221751 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 4000 25th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6003801.92979 | 2101310.951 | 37.7500147919711 | -122.429672485102 | (37.7500147919711, -122.429672485102) | 2 | 4 | 5 | 28862 | 22 | |||
63181 | 203460 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 451 Hearst Ave | 19 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 2ft | 5998498.64412 | 2094367.64391 | 37.7306484177731 | -122.447511726809 | (37.7306484177731, -122.447511726809) | 9 | 7 | 4 | 28861 | 40 | |||
63523 | 189189 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 40 Bluxome St | 13 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 2ft | 6013286.37012 | 2110737.42351 | 37.776430290657 | -122.397535599396 | (37.776430290657, -122.397535599396) | 6 | 2 | 9 | 28856 | 34 | |||
63826 | 256843 | Undocumented 4 | Afrocarpus gracilior :: Fern Pine 89 | 1298x Post St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6006137 | 2114500 | 37.7863607279306 | -122.422534752155 | (37.7863607279306, -122.422534752155) | 13 | 9 | 11 | 28858 | 41 | ||||
63927 | 125438 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 250 Euclid Ave | 0 | Front Yard : Yard | Tree | Private 2 | 15 | 5998091.24108 | 2114006.24691 | 37.78454782955 | -122.450335292242 | (37.78454782955, -122.450335292242) | 15 | 6 | 1 | 54 | 31 | ||||
64387 | 104356 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 1671 Filbert St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/25/2013 12:00:00 AM | 3 | Permit Number 770626 | 6004967.00865 | 2119154.82266 | 37.7990756208885 | -122.426914264396 | (37.7990756208885, -122.426914264396) | 13 | 9 | 1 | 57 | 17 | ||
64447 | 125502 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 1001 Lombard St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | Width 7ft | 6007468.42884 | 2120195.87716 | 37.8020752142594 | -122.418332338987 | (37.8020752142594, -122.418332338987) | 5 | 1 | 1 | 28858 | 32 | |||
64501 | 203457 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 89 Manor Dr | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 2ft | 5993628.67358 | 2093513.96157 | 37.7280249047113 | -122.464285869009 | (37.7280249047113, -122.464285869009) | 9 | 8 | 4 | 59 | 40 | |||
64506 | 125523 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 220 Lombard St | 7 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | Width 9ft | 6011207.16585 | 2120734.52957 | 37.8037639692824 | -122.405432414094 | (37.8037639692824, -122.405432414094) | 3 | 1 | 10 | 308 | 23 | |||
64715 | 125443 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 2298 Beach St | 8 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 5ft | 5999265.80635 | 2120844.85189 | 37.8033919746241 | -122.446763941418 | (37.8033919746241, -122.446763941418) | 13 | 9 | 1 | 57 | 17 | |||
64779 | 125512 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 900 Green St | 17 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 5ft | 6008620.72695 | 2119028.05639 | 37.7989334659598 | -122.414262150401 | (37.7989334659598, -122.414262150401) | 5 | 1 | 10 | 308 | 32 | |||
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 | |||
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 | ||
66854 | 220621 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 714 Duncan St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | Width 4ft | 6001868.87894 | 2099747.43156 | 37.7456120907355 | -122.43624518749 | (37.7456120907355, -122.43624518749) | 2 | 7 | 5 | 63 | 22 | |||
67061 | 220629 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 907 Elizabeth St | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 7 | Width 4ft | 6000561.39368 | 2101957.84527 | 37.7516069822761 | -122.440924802556 | (37.7516069822761, -122.440924802556) | 2 | 4 | 5 | 28862 | 22 | |||
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 | |||
67376 | 220630 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 901 Elizabeth St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | Width 4ft | 6000579.18981 | 2101957.47614 | 37.7516069822848 | -122.44086323496 | (37.7516069822848, -122.44086323496) | 2 | 4 | 5 | 28862 | 22 | |||
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 | |||
67909 | 220608 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 385 Nevada St | 2 | Sidewalk: Curb side : Pot | Tree | Private 2 | 5 | Width 2ft | 6008946.36134 | 2096525.74548 | 37.7371656274845 | -122.411544656368 | (37.7371656274845, -122.411544656368) | 10 | 7 | 7 | 28859 | 2 | |||
68453 | 125538 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 11 Miller Pl | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 2ft | 6010079.83492 | 2116873.25499 | 37.7930987589554 | -122.409061006782 | (37.7930987589554, -122.409061006782) | 3 | 1 | 10 | 28857 | 4 | |||
68950 | 220597 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 452 Shotwell St | 3 | : | Tree | Private 2 | 4 | Width 3ft | 6007815.2262 | 2105168.52935 | 37.7608332548635 | -122.416067410784 | (37.7608332548635, -122.416067410784) | 2 | 4 | 7 | 28859 | 19 | |||
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 | ||
69444 | 220605 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 51 Arnold Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 2ft | 6006588.43416 | 2095556.27849 | 37.7343711416034 | -122.419628336682 | (37.7343711416034, -122.419628336682) | 2 | 7 | 7 | 28859 | 2 | |||
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 | |||
70682 | 125454 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 2401 Broadway | 16 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | Width 4ft | 6002093.86703 | 2117345.78422 | 37.7939455983674 | -122.43672672227 | (37.7939455983674, -122.43672672227) | 13 | 9 | 1 | 29490 | 27 | |||
71039 | 220661 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 40 Leese St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6005456.84136 | 2096363.09768 | 37.7365226796806 | -122.423597969391 | (37.7365226796806, -122.423597969391) | 2 | 7 | 7 | 28859 | 2 | |||
71615 | 125510 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 900 Green St | 14 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 5ft | 6008630.57528 | 2119029.65242 | 37.7989384014533 | -122.414228184789 | (37.7989384014533, -122.414228184789) | 5 | 1 | 10 | 308 | 32 | |||
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 | ||
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 | |||
72741 | 125513 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 900 Green St | 22 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 5ft | 6008593.29487 | 2119027.33171 | 37.798929935227 | -122.414357023482 | (37.798929935227, -122.414357023482) | 5 | 1 | 10 | 308 | 32 | |||
73410 | 125496 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 1207 Chestnut St | 8 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | Width 3ft | 6006063.84143 | 2120339.68716 | 37.8023909140602 | -122.423203116649 | (37.8023909140602, -122.423203116649) | 5 | 9 | 1 | 28858 | 32 | |||
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 | |||
74610 | 125446 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 3615 Buchanan St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6003103.60158 | 2120772.63456 | 37.8034121715947 | -122.433477951057 | (37.8034121715947, -122.433477951057) | 13 | 9 | 1 | 57 | 17 | |||
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 | |||
75027 | 203443 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 1 Marne Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 2ft | 5995223.6819 | 2097798.00617 | 37.7398796519151 | -122.459081986971 | (37.7398796519151, -122.459081986971) | 9 | 7 | 4 | 59 | 40 | |||
76065 | 175158 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 229 Delano Ave | 6 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 4ft | 6000088.06493 | 2092305.57905 | 37.7250771680567 | -122.441868929714 | (37.7250771680567, -122.441868929714) | 9 | 7 | 6 | 28861 | 25 | |||
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 | |||
76702 | 125458 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 2371 Broadway | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | Width 4ft | 6002284.26434 | 2117368.32549 | 37.7940183094364 | -122.436069543591 | (37.7940183094364, -122.436069543591) | 13 | 9 | 1 | 29490 | 27 | |||
77039 | 248092 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 8 Brewster St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 2ft | 6010451.32651 | 2099884.28332 | 37.7464717490664 | -122.406577882357 | (37.7464717490664, -122.406577882357) | 2 | 7 | 7 | 28859 | 2 | |||
77046 | 203495 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 363 Joost Ave | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | Width 3ft | 5999677.59639 | 2094931.24105 | 37.7322632278502 | -122.443476391437 | (37.7322632278502, -122.443476391437) | 9 | 7 | 4 | 63 | 40 | |||
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 | |||
77540 | 203488 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 296 Cresta Vista Dr | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 5996843.32855 | 2096168.51259 | 37.7354984336897 | -122.453364342002 | (37.7354984336897, -122.453364342002) | 9 | 7 | 4 | 59 | 40 | |||
77696 | 220591 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 45 Pearl St | 1 | : | Tree | Private 2 | 11 | Width 3ft | 6005640.71146 | 2108782.82006 | 37.7706347365469 | -122.423845107576 | (37.7706347365469, -122.423845107576) | 8 | 2 | 5 | 28853 | 19 | |||
77941 | 125515 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 900 Green St | 25 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 5ft | 6008587.48018 | 2119026.85751 | 37.7989283065533 | -122.414377110727 | (37.7989283065533, -122.414377110727) | 5 | 1 | 10 | 308 | 32 | |||
78299 | 220619 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 618 28th St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 11 | 6001863.58646 | 2099454.05886 | 37.7448062577002 | -122.436242496718 | (37.7448062577002, -122.436242496718) | 2 | 7 | 5 | 63 | 22 | ||||
78343 | 101466 | Significant Tree 6 | Afrocarpus gracilior :: Fern Pine 89 | 301 Hazelwood Ave | 1 | Front Yard : Yard | Tree | Private 2 | 5996219.7 | 2095283.8 | 37.7330334614805 | -122.455456526637 | (37.7330334614805, -122.455456526637) | 9 | 7 | 4 | 59 | 40 | |||||
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 | |||
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 | |||
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 | |||
80015 | 125526 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 29 Miller Pl | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6010063.61505 | 2116985.54141 | 37.7934061616158 | -122.409125055588 | (37.7934061616158, -122.409125055588) | 3 | 1 | 10 | 28857 | 4 | |||
80070 | 107943 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 44x MacOndray Ln | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | 3x3 | 6008438.53642 | 2119159.8208 | 37.7992850226339 | -122.41490192268 | (37.7992850226339, -122.41490192268) | 5 | 1 | 10 | 308 | 32 | |||
80095 | 125508 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 7 Fallon Pl | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | Width 6ft | 6008930.42147 | 2118571.4914 | 37.7976972425915 | -122.413158199313 | (37.7976972425915, -122.413158199313) | 3 | 1 | 10 | 308 | 21 | |||
80821 | 220604 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 446 27th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 4ft | 6003586.44761 | 2100127.58593 | 37.7467533438884 | -122.430333215209 | (37.7467533438884, -122.430333215209) | 2 | 7 | 5 | 63 | 22 | |||
81158 | 203493 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 227 Stillings Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 8 | Width 6ft | 5999314.08769 | 2095746.28692 | 37.7344804146435 | -122.444791684116 | (37.7344804146435, -122.444791684116) | 9 | 7 | 4 | 59 | 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) );