trees
665 rows where qSpecies_id = 89 sorted by PlotSize 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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | |||
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 | |||
43086 | 203451 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 1515 16th Ave | 4 | Side Yard : Yard | Tree | Private 2 | 8 | Width 8ft | 5991183.11857 | 2105012.94014 | 37.7594568739424 | -122.473578579008 | (37.7594568739424, -122.473578579008) | 1 | 8 | 4 | 56 | 12 | |||
113481 | 203452 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 1515 16th Ave | 5 | Side Yard : Yard | Tree | Private 2 | 10 | Width 8ft | 5991186.2272 | 2105007.12865 | 37.7594410971589 | -122.473567404026 | (37.7594410971589, -122.473567404026) | 1 | 8 | 4 | 56 | 12 | |||
153760 | 203450 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 1515 16th Ave | 3 | Side Yard : Yard | Tree | Private 2 | 9 | Width 8ft | 5991181.21192 | 2105021.0246 | 37.7594789613077 | -122.4735857628 | (37.7594789613077, -122.4735857628) | 1 | 8 | 4 | 56 | 12 | |||
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 | |||
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 | |||
84618 | 125504 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 1001 Lombard St | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 7ft | 6007489.69173 | 2120199.07294 | 37.8020851859507 | -122.418258985774 | (37.8020851859507, -122.418258985774) | 5 | 1 | 1 | 28858 | 32 | |||
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 | |||
178268 | 125503 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 1001 Lombard St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | Width 7ft | 6007472.5485 | 2120196.70062 | 37.8020777071716 | -122.418318141382 | (37.8020777071716, -122.418318141382) | 5 | 1 | 1 | 28858 | 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 | |||
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 | |||
116507 | 203463 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 112 Baden St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | Width 6ft | 6000775.43585 | 2094454.02267 | 37.7310154446029 | -122.439646720241 | (37.7310154446029, -122.439646720241) | 9 | 7 | 4 | 63 | 40 | |||
121531 | 203462 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 112 Baden St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 6ft | 6000775.11209 | 2094438.40357 | 37.7309725397368 | -122.439646720213 | (37.7309725397368, -122.439646720213) | 9 | 7 | 4 | 63 | 40 | |||
10180 | 125521 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 900 Green St | 33 | Sidewalk: Property side : Yard | Tree | Private 2 | 2 | Width 5ft | 6008568.41134 | 2119026.06198 | 37.7989250510158 | -122.414443039112 | (37.7989250510158, -122.414443039112) | 5 | 1 | 10 | 308 | 32 | |||
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 | |||
24223 | 125520 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 900 Green St | 32 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 5ft | 6008570.50339 | 2119026.46396 | 37.7989262722777 | -122.414435828363 | (37.7989262722777, -122.414435828363) | 5 | 1 | 10 | 308 | 32 | |||
24813 | 125514 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 900 Green St | 24 | Sidewalk: Property side : Yard | Tree | Private 2 | 2 | Width 5ft | 6008590.31929 | 2119027.39259 | 37.7989299352366 | -122.414367324317 | (37.7989299352366, -122.414367324317) | 5 | 1 | 10 | 308 | 32 | |||
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
95831 | 125519 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 900 Green St | 31 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 5ft | 6008571.89831 | 2119026.74658 | 37.7989271266439 | -122.414431021472 | (37.7989271266439, -122.414431021472) | 5 | 1 | 10 | 308 | 32 | |||
100032 | 221755 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 14 Vicksburg St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 5ft | 6004062.6885 | 2102905.39693 | 37.7544075287057 | -122.428884426296 | (37.7544075287057, -122.428884426296) | 2 | 4 | 5 | 28862 | 22 | |||
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 | |||
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 | |||
146670 | 125518 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 900 Green St | 30 | Sidewalk: Property side : Yard | Tree | Private 2 | 2 | Width 5ft | 6008573.08581 | 2119026.43144 | 37.7989263280573 | -122.414426890005 | (37.7989263280573, -122.414426890005) | 5 | 1 | 10 | 308 | 32 | |||
159811 | 125516 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 900 Green St | 26 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 5ft | 6008584.50737 | 2119027.0667 | 37.7989287139392 | -122.414387412476 | (37.7989287139392, -122.414387412476) | 5 | 1 | 10 | 308 | 32 | |||
165325 | 203448 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 1880 16th Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | Width 5ft | 5991280.81784 | 2102617.46384 | 37.7528851842202 | -122.473065997797 | (37.7528851842202, -122.473065997797) | 1 | 8 | 4 | 56 | 12 | |||
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 | |||
3711 | 125506 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 7 Fallon Pl | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 8 | Width 4ft | 6008920.97468 | 2118571.47788 | 37.7976966751291 | -122.413190886946 | (37.7976966751291, -122.413190886946) | 3 | 1 | 10 | 308 | 21 | |||
7190 | 120690 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 358 22nd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/14/2018 12:00:00 AM | 3 | Width 4ft | Permit Number 782203 | 5989057.83806 | 2112937.05315 | 37.7810910000946 | -122.481509105367 | (37.7810910000946, -122.481509105367) | 11 | 6 | 2 | 55 | 26 | |
23673 | 125501 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 1115 Filbert St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 8 | Width 4ft | 6007553.74728 | 2119514.62481 | 37.8002094690578 | -122.417988773678 | (37.8002094690578, -122.417988773678) | 5 | 1 | 1 | 28858 | 32 | |||
27231 | 118929 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 875 La Playa | 5 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | Width 4ft | 5980750.23602 | 2109645.2788 | 37.7715662158284 | -122.510004109936 | (37.7715662158284, -122.510004109936) | 11 | 6 | 2 | 55 | 26 | |||
29202 | 125468 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 1177 California St | 4 | Sidewalk: Curb side : Pot | Tree | Private 2 | 5 | Width 4ft | 6008726.14199 | 2116272.16952 | 37.7913723996763 | -122.413702344902 | (37.7913723996763, -122.413702344902) | 5 | 1 | 10 | 28857 | 21 | |||
36532 | 175163 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 229 Delano Ave | 12 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 4ft | 6000100.60606 | 2092317.35748 | 37.7251102235329 | -122.441826421457 | (37.7251102235329, -122.441826421457) | 9 | 7 | 6 | 28861 | 25 | |||
37925 | 125477 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 150 Sproule Ln | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 4ft | 6009239.02025 | 2116870.71678 | 37.793044652131 | -122.411970106748 | (37.793044652131, -122.411970106748) | 3 | 1 | 10 | 28857 | 21 | |||
38146 | 220652 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 324 Park St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 4ft | 6006873.24491 | 2096273.48816 | 37.7363564804515 | -122.418694495969 | (37.7363564804515, -122.418694495969) | 2 | 7 | 7 | 28859 | 2 | |||
45630 | 120025 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 743 28th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 4ft | 5987224.82866 | 2110876.63769 | 37.7753269317853 | -122.487698901899 | (37.7753269317853, -122.487698901899) | 11 | 6 | 2 | 55 | 26 | |||
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
83370 | 175160 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 229 Delano Ave | 8 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 4ft | 6000093.42571 | 2092311.2225 | 37.7250929691415 | -122.44185080298 | (37.7250929691415, -122.44185080298) | 9 | 7 | 6 | 28861 | 25 | |||
84672 | 175155 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 229 Delano Ave | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 4ft | 6000081.06235 | 2092299.82458 | 37.7250609685792 | -122.441892723985 | (37.7250609685792, -122.441892723985) | 9 | 7 | 6 | 28861 | 25 | |||
86571 | 125453 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 2401 Broadway | 12 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | Width 4ft | 6002078.25785 | 2117342.70193 | 37.793936248105 | -122.436780510733 | (37.793936248105, -122.436780510733) | 13 | 9 | 1 | 29490 | 27 | |||
87547 | 125475 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 150 Sproule Ln | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 4ft | 6009249.92549 | 2116801.26294 | 37.7928545606515 | -122.411927463576 | (37.7928545606515, -122.411927463576) | 3 | 1 | 10 | 28857 | 21 | |||
88253 | 125522 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 1087 Greenwich St | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 11 | Width 4ft | 6007750.4574 | 2119887.81691 | 37.8012452299295 | -122.417334539369 | (37.8012452299295, -122.417334539369) | 5 | 1 | 1 | 308 | 32 | |||
90041 | 125462 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 125 Mason St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/28/2017 12:00:00 AM | 3 | Width 4ft | Permit Number 52121 | 6009895.29665 | 2113891.24599 | 37.7849005400769 | -122.409488968035 | (37.7849005400769, -122.409488968035) | 14 | 10 | 9 | 28852 | 36 | |
90579 | 125457 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 2807 Steiner St | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 8 | Width 4ft | 6002053.50035 | 2117793.13608 | 37.7951716162211 | -122.436898435221 | (37.7951716162211, -122.436898435221) | 13 | 9 | 1 | 57 | 27 | |||
97812 | 125456 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 2401 Broadway | 18 | Sidewalk: Property side : Yard | Tree | Private 2 | 11 | Width 4ft | 6002104.20596 | 2117349.59529 | 37.7939566501408 | -122.436691221543 | (37.7939566501408, -122.436691221543) | 13 | 9 | 1 | 29490 | 27 | |||
98062 | 117918 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 731 41st Ave | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | Width 4ft | 5983185.43658 | 2110793.02592 | 37.7748609268346 | -122.501665678898 | (37.7748609268346, -122.501665678898) | 11 | 6 | 2 | 55 | 26 | |||
98841 | 175159 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 229 Delano Ave | 7 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 4ft | 6000090.18527 | 2092307.21266 | 37.7250817743959 | -122.441861717141 | (37.7250817743959, -122.441861717141) | 9 | 7 | 6 | 28861 | 25 | |||
99030 | 125463 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 935 O'Farrell St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 4ft | 6006804.24109 | 2113922.09635 | 37.7848115656375 | -122.420185233786 | (37.7848115656375, -122.420185233786) | 7 | 9 | 9 | 28858 | 36 | |||
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 | |||
100277 | 220612 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 9 Bradford St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 4ft | 6009640.52107 | 2098655.41337 | 37.7430521462403 | -122.409294863773 | (37.7430521462403, -122.409294863773) | 10 | 7 | 7 | 28859 | 2 | |||
101180 | 125474 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 150 Sproule Ln | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 4ft | 6009252.35721 | 2116781.07333 | 37.792799261332 | -122.411917622313 | (37.792799261332, -122.411917622313) | 3 | 1 | 10 | 28857 | 21 | |||
106323 | 125469 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 1177 California St | 5 | Sidewalk: Curb side : Pot | Tree | Private 2 | 4 | Width 4ft | 6008779.73096 | 2116281.55689 | 37.7914011842588 | -122.413517591782 | (37.7914011842588, -122.413517591782) | 5 | 1 | 10 | 28857 | 21 | |||
111278 | 175161 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 229 Delano Ave | 9 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 4ft | 6000095.42068 | 2092313.25863 | 37.7250986735632 | -122.44184405267 | (37.7250986735632, -122.44184405267) | 9 | 7 | 6 | 28861 | 25 | |||
115820 | 125476 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 150 Sproule Ln | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 4ft | 6009246.74599 | 2116823.51326 | 37.7929154762237 | -122.41194003791 | (37.7929154762237, -122.41194003791) | 3 | 1 | 10 | 28857 | 21 | |||
123622 | 203499 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 379 Staples Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 4ft | 5997569.06892 | 2093791.20398 | 37.7290124835419 | -122.450683849688 | (37.7290124835419, -122.450683849688) | 9 | 7 | 4 | 28861 | 40 | |||
125410 | 175162 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 229 Delano Ave | 11 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 4ft | 6000098.01412 | 2092315.01212 | 37.7251036360216 | -122.441835213242 | (37.7251036360216, -122.441835213242) | 9 | 7 | 6 | 28861 | 25 | |||
125968 | 125466 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 1177 California St | 2 | Sidewalk: Curb side : Pot | Tree | Private 2 | 3 | Width 4ft | 6008683.65979 | 2116266.52541 | 37.7913545166392 | -122.413848933479 | (37.7913545166392, -122.413848933479) | 5 | 1 | 10 | 28857 | 21 | |||
130988 | 125455 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 2401 Broadway | 17 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | Width 4ft | 6002099.50591 | 2117347.8348 | 37.7939515491883 | -122.436707358076 | (37.7939515491883, -122.436707358076) | 13 | 9 | 1 | 29490 | 27 | |||
133109 | 175164 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 229 Delano Ave | 13 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 4ft | 6000102.23368 | 2092318.39014 | 37.7251131517233 | -122.441820869043 | (37.7251131517233, -122.441820869043) | 9 | 7 | 6 | 28861 | 25 | |||
137492 | 125478 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 150 Sproule Ln | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 4ft | 6009235.21214 | 2116893.1375 | 37.7931060003053 | -122.411984868232 | (37.7931060003053, -122.411984868232) | 3 | 1 | 10 | 28857 | 21 | |||
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 | |||
138499 | 125449 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 3101 Clay St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 4ft | 5999876.27718 | 2115725.03781 | 37.7893691777902 | -122.444283251471 | (37.7893691777902, -122.444283251471) | 13 | 6 | 1 | 29490 | 27 | |||
143706 | 125451 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 2601 Vallejo St | 10 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | Width 4ft | 6001095.19419 | 2117566.78183 | 37.7944955940578 | -122.440198075675 | (37.7944955940578, -122.440198075675) | 13 | 9 | 1 | 57 | 27 | |||
145209 | 220631 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 901 Elizabeth St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 4ft | 6000591.19408 | 2101959.06133 | 37.7516120185002 | -122.440821836477 | (37.7516120185002, -122.440821836477) | 2 | 4 | 5 | 28862 | 22 | |||
145791 | 246824 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 402 Franconia St | 1 | : | Tree | Private 2 | 10 | Width 4ft | 6009972.67277 | 2098701.67929 | 37.7431977860534 | -122.408149630203 | (37.7431977860534, -122.408149630203) | 10 | 7 | 7 | 28859 | 2 | |||
147929 | 175156 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 229 Delano Ave | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 4ft | 6000083.66792 | 2092301.69867 | 37.7250662628724 | -122.441883851284 | (37.7250662628724, -122.441883851284) | 9 | 7 | 6 | 28861 | 25 | |||
148572 | 220620 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 747 Duncan St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 8 | Width 4ft | 6001698.74806 | 2099680.01267 | 37.745417306567 | -122.43682864783 | (37.745417306567, -122.43682864783) | 2 | 7 | 5 | 63 | 22 | |||
148998 | 175154 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 229 Delano Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 4ft | 6000079.77144 | 2092298.5573 | 37.7250574153596 | -122.441897095593 | (37.7250574153596, -122.441897095593) | 9 | 7 | 6 | 28861 | 25 | |||
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 | |||
162245 | 125461 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 1845 Green St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 11 | Width 4ft | 6004195.45414 | 2118342.02418 | 37.7968002290978 | -122.429526106064 | (37.7968002290978, -122.429526106064) | 13 | 9 | 1 | 57 | 17 | |||
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 | |||
170126 | 220628 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 907 Elizabeth St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 8 | Width 4ft | 6000553.10276 | 2101957.71166 | 37.751606143208 | -122.440953463952 | (37.751606143208, -122.440953463952) | 2 | 4 | 5 | 28862 | 22 | |||
182154 | 125467 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 1177 California St | 3 | Sidewalk: Curb side : Pot | Tree | Private 2 | 6 | Width 4ft | 6008702.23207 | 2116269.4831 | 37.7913636807268 | -122.413784882888 | (37.7913636807268, -122.413784882888) | 5 | 1 | 10 | 28857 | 21 | |||
182415 | 125459 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 2371 Broadway | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | Width 4ft | 6002302.24315 | 2117372.64149 | 37.7940311814406 | -122.436007644151 | (37.7940311814406, -122.436007644151) | 13 | 9 | 1 | 29490 | 27 | |||
190539 | 125507 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 7 Fallon Pl | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 4ft | 6008925.22265 | 2118571.08085 | 37.7976958234636 | -122.413176159668 | (37.7976958234636, -122.413176159668) | 3 | 1 | 10 | 308 | 21 |
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) );