trees
430 rows where qSpecies_id = 99 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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
70794 | 242793 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 2x Coso Ave | 1 | Median : Yard | Tree | DPW 1 | 30 | Width 9ft | 6007083.58829 | 2099965.0449 | 37.746504513177 | -122.418228897148 | (37.746504513177, -122.418228897148) | 2 | 7 | 7 | 28859 | 2 | |||
23519 | 180581 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 1394 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 22 | Width 5ft | 6002394.23037 | 2093854.80651 | 37.7294621373592 | -122.434007462878 | (37.7294621373592, -122.434007462878) | 9 | 7 | 5 | 28861 | 25 | |||
41289 | 124637 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 124 Arguello Blvd | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 31 | Width 5ft | 5995537.16304 | 2115311.02189 | 37.7879838891542 | -122.459265995172 | (37.7879838891542, -122.459265995172) | 11 | 6 | 1 | 54 | 31 | ||||
59579 | 123469 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 772 02nd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 26 | Width 5ft | 5995383.36925 | 2110442.32995 | 37.7746069181393 | -122.459445351917 | (37.7746069181393, -122.459445351917) | 11 | 6 | 2 | 54 | 11 | |||
95286 | 180588 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 1447 Alemany Blvd | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 19 | Width 5ft | 6002392.55611 | 2093716.48474 | 37.7290822421508 | -122.434003367375 | (37.7290822421508, -122.434003367375) | 9 | 7 | 6 | 28861 | 25 | |||
139940 | 180580 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 1282 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 5ft | 6002752.91911 | 2094123.24132 | 37.7302195481937 | -122.432786610727 | (37.7302195481937, -122.432786610727) | 9 | 7 | 5 | 28861 | 25 | |||
161460 | 137077 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 2955 Steiner St | 1 | Front Yard : Yard | Tree | Private 2 | 5 | Width 5ft | 6001974.03932 | 2118352.39854 | 37.796702688621 | -122.437213445266 | (37.796702688621, -122.437213445266) | 13 | 9 | 1 | 57 | 17 | |||
189616 | 137075 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 689 Hayes St | 1 | : | Tree | Private 2 | 24 | Width 5ft | 6004617.55273 | 2110839.21576 | 37.776223284701 | -122.42753075415 | (37.776223284701, -122.42753075415) | 7 | 9 | 11 | 28852 | 10 | |||
1332 | 215594 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 260 Sagamore St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 4ft | 5994385 | 2087488 | 37.7115226229707 | -122.461234615187 | (37.7115226229707, -122.461234615187) | 9 | 8 | 6 | 28861 | 24 | |||
12102 | 180591 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 1830 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 22 | Width 4ft | 6001183.24158 | 2091479.89441 | 37.7228723703333 | -122.438023911598 | (37.7228723703333, -122.438023911598) | 9 | 7 | 6 | 28861 | 25 | |||
14050 | 180592 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 1830 Alemany Blvd | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 33 | Width 4ft | 6001143.73267 | 2091406.40414 | 37.72266833577 | -122.438155223402 | (37.72266833577, -122.438155223402) | 9 | 7 | 6 | 28861 | 25 | |||
34810 | 137072 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 3598 Clay St | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 26 | Width 4ft | 5997679.8137 | 2115460.24424 | 37.7885165665196 | -122.451863614513 | (37.7885165665196, -122.451863614513) | 11 | 6 | 1 | 54 | 31 | |||
47119 | 180584 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 1114 Alemany Blvd | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 22 | Width 4ft | 6003732.95256 | 2094463.14814 | 37.7312083905422 | -122.429422736186 | (37.7312083905422, -122.429422736186) | 9 | 7 | 5 | 28861 | 25 | |||
65775 | 180589 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 1241 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 20 | Width 4ft | 6003010.99045 | 2094126.19284 | 37.7302422857354 | -122.431894635246 | (37.7302422857354, -122.431894635246) | 9 | 7 | 6 | 28861 | 25 | |||
69972 | 180587 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 1473 Alemany Blvd | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 23 | Width 4ft | 6002172.86661 | 2093413.14517 | 37.7282368704302 | -122.434741167586 | (37.7282368704302, -122.434741167586) | 9 | 7 | 6 | 28861 | 25 | |||
84318 | 124687 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 460 Arguello Blvd | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 19 | Width 4ft | 5995608.47806 | 2113376.19737 | 37.7826754805595 | -122.45887912132 | (37.7826754805595, -122.45887912132) | 11 | 6 | 1 | 54 | 31 | |||
107856 | 124694 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 460 Arguello Blvd | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 4ft | 5995618.45318 | 2113098.44712 | 37.78191342592 | -122.458824496585 | (37.78191342592, -122.458824496585) | 11 | 6 | 1 | 54 | 31 | |||
113204 | 137074 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 3598 Clay St | 4 | Sidewalk: Curb side : Yard | Tree | Private 2 | 21 | Width 4ft | 5997641.85824 | 2115456.61364 | 37.7885044238892 | -122.45199467184 | (37.7885044238892, -122.45199467184) | 11 | 6 | 1 | 54 | 31 | |||
119308 | 180582 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 1110 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 26 | Width 4ft | 6003793.49913 | 2094480.4258 | 37.7312592588934 | -122.429214647441 | (37.7312592588934, -122.429214647441) | 9 | 7 | 5 | 28861 | 25 | |||
126133 | 124686 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 460 Arguello Blvd | 11 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 4ft | 5995607.11329 | 2113402.43136 | 37.7827474336358 | -122.458885742796 | (37.7827474336358, -122.458885742796) | 11 | 6 | 1 | 54 | 31 | |||
136001 | 180590 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 1159 Alemany Blvd | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 24 | Width 4ft | 6003628.44812 | 2094335.41976 | 37.7308517598817 | -122.429774919684 | (37.7308517598817, -122.429774919684) | 9 | 7 | 6 | 28861 | 25 | |||
142118 | 124672 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 390 Arguello Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 34 | Width 4ft | 5995591.07711 | 2113866.14003 | 37.7840197317356 | -122.458974806266 | (37.7840197317356, -122.458974806266) | 11 | 6 | 1 | 54 | 31 | |||
151809 | 180583 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 1114 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 25 | Width 4ft | 6003761.56491 | 2094470.84041 | 37.7312311316907 | -122.429324366526 | (37.7312311316907, -122.429324366526) | 9 | 7 | 5 | 28861 | 25 | |||
152819 | 124688 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 460 Arguello Blvd | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 19 | Width 4ft | 5995612.53793 | 2113341.5687 | 37.7825806328494 | -122.458862568059 | (37.7825806328494, -122.458862568059) | 11 | 6 | 1 | 54 | 31 | |||
154835 | 137076 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 689 Hayes St | 4 | : | Tree | Private 2 | 19 | Width 4ft | 6004731.62731 | 2110853.90859 | 37.7762700791404 | -122.427137185641 | (37.7762700791404, -122.427137185641) | 7 | 9 | 11 | 28852 | 10 | |||
155029 | 180579 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 2500 Bay Shore Blvd | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 21 | Width 4ft | 6010790.74354 | 2086511.28723 | 37.7097712796836 | -122.404463040238 | (37.7097712796836, -122.404463040238) | 10 | 3 | 8 | 309 | 1 | |||
161310 | 137073 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 3598 Clay St | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 16 | Width 4ft | 5997662.02457 | 2115459.05462 | 37.7885122812527 | -122.451925075987 | (37.7885122812527, -122.451925075987) | 11 | 6 | 1 | 54 | 31 | |||
174705 | 180593 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 2136 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 20 | Width 4ft | 6000017.35738 | 2089840.46995 | 37.7183045122206 | -122.441936504777 | (37.7183045122206, -122.441936504777) | 9 | 7 | 6 | 28861 | 25 | |||
176937 | 137070 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 7 Laurel St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 4ft | 5997942.37701 | 2116329.50618 | 37.7909183634316 | -122.451017898383 | (37.7909183634316, -122.451017898383) | 11 | 6 | 1 | 54 | 31 | |||
825 | 175382 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 80x Junipero Serra Blvd | 19 | Sidewalk: Curb side : Yard | Tree | DPW 1 | 2 | Width 3ft | 5991305.51807 | 2089124.29272 | 37.7158377779634 | -122.471997198511 | (37.7158377779634, -122.471997198511) | 9 | 8 | 6 | 64 | 24 | |||
1798 | 242795 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 1671 Peralta Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6009731.24755 | 2099988.43526 | 37.7467174150944 | -122.409075193563 | (37.7467174150944, -122.409075193563) | 2 | 7 | 7 | 28859 | 2 | |||
5701 | 215593 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 103 Sagamore St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 17 | Width 3ft | 5995757.42889 | 2087376.90008 | 37.7112964570463 | -122.456483140498 | (37.7112964570463, -122.456483140498) | 9 | 8 | 6 | 28861 | 24 | |||
11055 | 212275 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 751 Junipero Serra Blvd | 8 | Sidewalk: Curb side : Yard | Tree | Private 2 | 23 | Width 3ft | 5991369.83991 | 2092286.4262 | 37.7245239402122 | -122.47200521689 | (37.7245239402122, -122.47200521689) | 9 | 8 | 4 | 59 | 40 | |||
18681 | 215586 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 751 Junipero Serra Blvd | 18 | Sidewalk: Curb side : Yard | Tree | Private 2 | 13 | Width 3ft | 5991393.38259 | 2092629.96723 | 37.725468580903 | -122.471948860848 | (37.725468580903, -122.471948860848) | 9 | 8 | 4 | 59 | 40 | |||
27130 | 137079 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 1639 Taylor St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6008755.55812 | 2118570.22529 | 37.7976839479247 | -122.413763186745 | (37.7976839479247, -122.413763186745) | 5 | 1 | 10 | 308 | 21 | |||
32172 | 215592 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 177 Sagamore St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 3ft | 5995226.8577 | 2087383.90223 | 37.7112852083174 | -122.458317422904 | (37.7112852083174, -122.458317422904) | 9 | 8 | 6 | 28861 | 24 | |||
42710 | 175378 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 80X Junipero Serra Blvd | 11 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3 | Width 3ft | 5991360.88178 | 2088922.01369 | 37.715285572641 | -122.471791104494 | (37.715285572641, -122.471791104494) | 9 | 8 | 6 | 64 | 24 | |||
43102 | 137067 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 7 Laurel St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 3ft | 5997931.48984 | 2116393.73013 | 37.791094081978 | -122.45106020067 | (37.791094081978, -122.45106020067) | 11 | 6 | 1 | 54 | 31 | |||
43276 | 215577 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 95 Kirkham St | 5 | Sidewalk: Curb side : Yard | Tree | Private 2 | 48 | Width 3ft | 5994760.78175 | 2105295.21675 | 37.7604384740771 | -122.461225807922 | (37.7604384740771, -122.461225807922) | 15 | 5 | 4 | 56 | 12 | |||
44462 | 215584 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 751 Junipero Serra Blvd | 15 | Sidewalk: Curb side : Yard | Tree | Private 2 | 17 | Width 3ft | 5991387.10122 | 2092540.18841 | 37.7252217070935 | -122.471964034223 | (37.7252217070935, -122.471964034223) | 9 | 8 | 4 | 59 | 40 | |||
45200 | 215576 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 95 Kirkham St | 4 | Sidewalk: Curb side : Yard | Tree | Private 2 | 39 | Width 3ft | 5994736.06961 | 2105294.2713 | 37.7604344559039 | -122.461311206651 | (37.7604344559039, -122.461311206651) | 15 | 5 | 4 | 56 | 12 | |||
47049 | 215580 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 751 Junipero Serra Blvd | 6 | Sidewalk: Curb side : Yard | Tree | Private 2 | 24 | Width 3ft | 5991366.74972 | 2092229.04743 | 37.7243662135233 | -122.472011718965 | (37.7243662135233, -122.472011718965) | 9 | 8 | 4 | 59 | 40 | |||
56066 | 137081 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 1627 Taylor St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6008775.75798 | 2118410.46159 | 37.7972464106437 | -122.413681983361 | (37.7972464106437, -122.413681983361) | 5 | 1 | 10 | 308 | 21 | |||
57726 | 177713 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 80X Junipero Serra Blvd | 18 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 16 | Width 3ft | 5991322.37032 | 2089056.90035 | 37.7156537101333 | -122.471934040933 | (37.7156537101333, -122.471934040933) | 9 | 8 | 6 | 64 | 24 | |||
66722 | 215590 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 501 Junipero Serra Blvd | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 26 | Width 3ft | 5991474.9385 | 2093941.2931 | 37.7290738739428 | -122.471762454787 | (37.7290738739428, -122.471762454787) | 9 | 8 | 4 | 59 | 40 | |||
74287 | 137080 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 1639 Taylor St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6008758.62885 | 2118554.07509 | 37.7976397759128 | -122.41375141819 | (37.7976397759128, -122.41375141819) | 5 | 1 | 10 | 308 | 21 | |||
82136 | 215651 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 2105 09th Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 25 | Width 3ft | 5993642.48221 | 2101265.67926 | 37.7493099806718 | -122.464800828005 | (37.7493099806718, -122.464800828005) | 1 | 8 | 4 | 29491 | 40 | |||
85602 | 175377 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 80X Junipero Serra Blvd | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 5991371.46907 | 2088876.77956 | 37.7151619833268 | -122.471751215951 | (37.7151619833268, -122.471751215951) | 9 | 8 | 6 | 64 | 24 | |||
89904 | 215582 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 751 Junipero Serra Blvd | 11 | Sidewalk: Curb side : Yard | Tree | Private 2 | 25 | Width 3ft | 5991378.73804 | 2092411.11653 | 37.7248668238178 | -122.47198354143 | (37.7248668238178, -122.47198354143) | 9 | 8 | 4 | 59 | 40 | |||
92226 | 137068 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 7 Laurel St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 3ft | 5997936.78651 | 2116362.08959 | 37.7910075087313 | -122.45103959183 | (37.7910075087313, -122.45103959183) | 11 | 6 | 1 | 54 | 31 | |||
94860 | 215583 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 751 Junipero Serra Blvd | 12 | Sidewalk: Curb side : Yard | Tree | Private 2 | 25 | Width 3ft | 5991379.44831 | 2092444.81871 | 37.7249594027384 | -122.471983541404 | (37.7249594027384, -122.471983541404) | 9 | 8 | 4 | 59 | 40 | |||
95397 | 123958 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 295 07th Ave | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 5993672.37881 | 2113557.39213 | 37.7830615134244 | -122.465590312648 | (37.7830615134244, -122.465590312648) | 11 | 6 | 2 | 54 | 11 | |||
102794 | 215587 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 751 Junipero Serra Blvd | 29 | Sidewalk: Curb side : Yard | Tree | Private 2 | 27 | Width 3ft | 5991411.41096 | 2092949.8935 | 37.7263480620905 | -122.47190984556 | (37.7263480620905, -122.47190984556) | 9 | 8 | 4 | 59 | 40 | |||
107113 | 137069 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 7 Laurel St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 3ft | 5997939.35301 | 2116349.86097 | 37.7909740791344 | -122.451029829681 | (37.7909740791344, -122.451029829681) | 11 | 6 | 1 | 54 | 31 | |||
111676 | 137071 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 7 Laurel St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 3ft | 5997945.51163 | 2116314.45646 | 37.7908772203684 | -122.451005967078 | (37.7908772203684, -122.451005967078) | 11 | 6 | 1 | 54 | 31 | |||
116110 | 215578 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 851 Junipero Serra Blvd | 7 | Sidewalk: Curb side : Yard | Tree | Private 2 | 25 | Width 3ft | 5991318.68956 | 2091495.76578 | 37.7223500225082 | -122.472124430111 | (37.7223500225082, -122.472124430111) | 9 | 8 | 4 | 59 | 40 | |||
121575 | 215579 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 851 Junipero Serra Blvd | 12 | Sidewalk: Curb side : Yard | Tree | Private 2 | 12 | Width 3ft | 5991331.01602 | 2091664.09591 | 37.7228129287478 | -122.472094084291 | (37.7228129287478, -122.472094084291) | 9 | 8 | 4 | 59 | 40 | |||
127765 | 215585 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 751 Junipero Serra Blvd | 16 | Sidewalk: Curb side : Yard | Tree | Private 2 | 18 | Width 3ft | 5991388.97305 | 2092569.49487 | 37.7253022836674 | -122.471959698575 | (37.7253022836674, -122.471959698575) | 9 | 8 | 4 | 59 | 40 | |||
137645 | 215575 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 95 Kirkham St | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 41 | Width 3ft | 5994715.1652 | 2105292.66043 | 37.76042882975 | -122.461383388048 | (37.76042882975, -122.461383388048) | 15 | 5 | 4 | 56 | 12 | |||
139373 | 215588 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 551 Junipero Serra Blvd | 9 | Sidewalk: Curb side : Yard | Tree | Private 2 | 12 | Width 3ft | 5991446.82162 | 2093469.8712 | 37.7277778402634 | -122.471825312909 | (37.7277778402634, -122.471825312909) | 9 | 8 | 4 | 59 | 40 | |||
150849 | 215589 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 551 Junipero Serra Blvd | 16 | Sidewalk: Curb side : Yard | Tree | Private 2 | 12 | Width 3ft | 5991458.35334 | 2093660.05844 | 37.7283007142025 | -122.47179930269 | (37.7283007142025, -122.47179930269) | 9 | 8 | 4 | 59 | 40 | |||
153831 | 124641 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 60 Arguello Blvd | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 15 | Width 3ft | 5995529.17868 | 2115583.09769 | 37.7887304767053 | -122.459313330112 | (37.7887304767053, -122.459313330112) | 11 | 6 | 1 | 54 | 31 | |||
156814 | 123644 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 499 Arguello Blvd | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 17 | Width 3ft | 5995555.16132 | 2113176.03479 | 37.7821228227737 | -122.459049075391 | (37.7821228227737, -122.459049075391) | 11 | 6 | 2 | 54 | 11 | |||
159736 | 124642 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 50 Arguello Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 5995529.95307 | 2115590.13506 | 37.7887498439417 | -122.459311160683 | (37.7887498439417, -122.459311160683) | 11 | 6 | 1 | 54 | 31 | |||
166456 | 175374 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 80x Junipero Serra Blvd | 6 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 2 | Width 3ft | 5991412.70367 | 2088734.17301 | 37.7147728061926 | -122.471598306927 | (37.7147728061926, -122.471598306927) | 9 | 8 | 6 | 64 | 24 | |||
167355 | 215581 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 751 Junipero Serra Blvd | 9 | Sidewalk: Curb side : Yard | Tree | Private 2 | 25 | Width 3ft | 5991373.01779 | 2092318.20321 | 37.7246113758903 | -122.471996546509 | (37.7246113758903, -122.471996546509) | 9 | 8 | 4 | 59 | 40 | |||
174305 | 137082 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 1627 Taylor St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6008777.37552 | 2118389.76877 | 37.7971896841052 | -122.413674921875 | (37.7971896841052, -122.413674921875) | 5 | 1 | 10 | 308 | 21 | |||
178273 | 175047 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 80X Junipero Serra Blvd | 8 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 21 | Width 3ft | 5991389.20246 | 2088805.53688 | 37.7149673943122 | -122.47168473357 | (37.7149673943122, -122.47168473357) | 9 | 8 | 6 | 64 | 24 | |||
179277 | 215591 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 233 Sagamore St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 3ft | 5994635.36944 | 2087388.76073 | 37.7112645410012 | -122.460362092762 | (37.7112645410012, -122.460362092762) | 9 | 8 | 6 | 28861 | 24 | |||
181960 | 123470 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 778 02nd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 20 | Width 3ft | 5995383.59468 | 2110411.06724 | 37.7745210919414 | -122.459442307531 | (37.7745210919414, -122.459442307531) | 11 | 6 | 2 | 54 | 11 | |||
191892 | 137078 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 1639 Taylor St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6008753.16727 | 2118586.36158 | 37.7977281199218 | -122.413772601749 | (37.7977281199218, -122.413772601749) | 5 | 1 | 10 | 308 | 21 | |||
50531 | 242796 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 140 Belgrave Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 23 | Width 2ft | 5997883.86583 | 2104916.82278 | 37.7595787374877 | -122.450397275322 | (37.7595787374877, -122.450397275322) | 15 | 5 | 11 | 29492 | 12 | |||
55899 | 180586 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 177 Santa Rosa Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 2ft | 6001346.13618 | 2093162.98872 | 37.7275030272355 | -122.437581294937 | (37.7275030272355, -122.437581294937) | 9 | 7 | 6 | 28861 | 25 | |||
107794 | 180585 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 177 Santa Rosa Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 2ft | 6001325.27813 | 2093179.51545 | 37.7275472199251 | -122.43765458429 | (37.7275472199251, -122.43765458429) | 9 | 7 | 6 | 28861 | 25 | |||
5037 | 215607 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 900 Junipero Serra Blvd | 47 | : | Tree | Private 2 | 2 | Width 0ft | 5991157.54734 | 2090681.21679 | 37.7201041455671 | -122.472622096933 | (37.7201041455671, -122.472622096933) | 9 | 8 | 4 | 64 | 40 | |||
5897 | 199851 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 1601 Armstrong Ave | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 30 | Width 0ft | 6014366.3226 | 2092462.8184 | 37.7263121847089 | -122.392521119846 | (37.7263121847089, -122.392521119846) | 10 | 3 | 8 | 58 | 1 | |||
5950 | 185691 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 2101 Sunset Blvd | 23 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 0ft | 5984865.9917 | 2100533.4848 | 37.746789659782 | -122.49509567655 | (37.746789659782, -122.49509567655) | 1 | 8 | 3 | 29491 | 35 | |||
9603 | 215597 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 700 Junipero Serra Blvd | 44 | : | Tree | Private 2 | 15 | Width 0ft | 5991275.01695 | 2092498.39745 | 37.7251004730822 | -122.472348449425 | (37.7251004730822, -122.472348449425) | 9 | 8 | 4 | 64 | 40 | |||
14370 | 185713 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 2101 Sunset Blvd | 44 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 0ft | 5984850.6272 | 2100403.3767 | 37.7464315188861 | -122.495139211963 | (37.7464315188861, -122.495139211963) | 1 | 8 | 3 | 29491 | 35 | |||
15030 | 215614 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 900 Junipero Serra Blvd | 55 | : | Tree | Private 2 | 5 | Width 0ft | 5991140.92054 | 2090646.29638 | 37.7200073002795 | -122.472677024844 | (37.7200073002795, -122.472677024844) | 9 | 8 | 4 | 64 | 40 | |||
18478 | 215618 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 900 Junipero Serra Blvd | 60 | : | Tree | Private 2 | 8 | Width 0ft | 5991156.49559 | 2090631.32735 | 37.7199671005808 | -122.472622096952 | (37.7199671005808, -122.472622096952) | 9 | 8 | 4 | 64 | 40 | |||
21007 | 215640 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 900 Junipero Serra Blvd | 83 | : | Tree | Private 2 | 5 | Width 0ft | 5991139.98278 | 2090571.01197 | 37.7198005335596 | -122.472674780143 | (37.7198005335596, -122.472674780143) | 9 | 8 | 4 | 64 | 40 | |||
21569 | 215609 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 900 Junipero Serra Blvd | 49 | : | Tree | Private 2 | 6 | Width 0ft | 5991151.21969 | 2090669.88886 | 37.7200726755881 | -122.472643143781 | (37.7200726755881, -122.472643143781) | 9 | 8 | 4 | 64 | 40 | |||
22196 | 185716 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 2101 Sunset Blvd | 48 | Sidewalk: Property side : Yard | Tree | Private 2 | 2 | Width 0ft | 5984901.6243 | 2100400.4346 | 37.7464264261744 | -122.494962655496 | (37.7464264261744, -122.494962655496) | 1 | 8 | 3 | 29491 | 35 | |||
25798 | 215644 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 900 Junipero Serra Blvd | 87 | : | Tree | Private 2 | 4 | Width 0ft | 5991153.98366 | 2090558.88602 | 37.7197680491356 | -122.472625500878 | (37.7197680491356, -122.472625500878) | 9 | 8 | 4 | 64 | 40 | |||
26371 | 215624 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 900 Junipero Serra Blvd | 66 | : | Tree | Private 2 | 4 | Width 0ft | 5991139.11135 | 2090614.21248 | 37.7199191010706 | -122.472680940482 | (37.7199191010706, -122.472680940482) | 9 | 8 | 4 | 64 | 40 | |||
29564 | 215637 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 900 Junipero Serra Blvd | 80 | : | Tree | Private 2 | 4 | Width 0ft | 5991151.99496 | 2090577.2658 | 37.7198184003677 | -122.472633714397 | (37.7198184003677, -122.472633714397) | 9 | 8 | 4 | 64 | 40 | |||
30014 | 199844 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 1601 Armstrong Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 32 | Width 0ft | 6014142.1837 | 2092625.4409 | 37.7267462633936 | -122.393307337928 | (37.7267462633936, -122.393307337928) | 10 | 3 | 8 | 58 | 1 | |||
31061 | 215630 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 900 Junipero Serra Blvd | 73 | : | Tree | Private 2 | 9 | Width 0ft | 5991138.04395 | 2090591.75646 | 37.7198573805858 | -122.47268299364 | (37.7198573805858, -122.47268299364) | 9 | 8 | 4 | 64 | 40 | |||
33545 | 215612 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 900 Junipero Serra Blvd | 53 | : | Tree | Private 2 | 1 | Width 0ft | 5991154.50456 | 2090649.59615 | 37.720017146953 | -122.472630310457 | (37.720017146953, -122.472630310457) | 9 | 8 | 4 | 64 | 40 | |||
33957 | 185719 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 2101 Sunset Blvd | 51 | Sidewalk: Property side : Yard | Tree | Private 2 | 14 | Width 0ft | 5984913.7198 | 2100361.206 | 37.7463194231796 | -122.494917939299 | (37.7463194231796, -122.494917939299) | 1 | 8 | 3 | 29491 | 35 | |||
37019 | 215613 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 900 Junipero Serra Blvd | 54 | : | Tree | Private 2 | 6 | Width 0ft | 5991146.23554 | 2090648.32868 | 37.7200131881383 | -122.472658800987 | (37.7200131881383, -122.472658800987) | 9 | 8 | 4 | 64 | 40 | |||
38604 | 215638 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 900 Junipero Serra Blvd | 81 | : | Tree | Private 2 | 17 | Width 0ft | 5991161.28352 | 2090567.01377 | 37.7197907884826 | -122.472600860358 | (37.7197907884826, -122.472600860358) | 9 | 8 | 4 | 64 | 40 | |||
38637 | 215605 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 900 Junipero Serra Blvd | 39 | : | Tree | Private 2 | 6 | Width 0ft | 5991158.3667 | 2090738.6198 | 37.7202618075092 | -122.472623447724 | (37.7202618075092, -122.472623447724) | 9 | 8 | 4 | 64 | 40 | |||
42318 | 215622 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 900 Junipero Serra Blvd | 64 | : | Tree | Private 2 | 3 | Width 0ft | 5991146.64961 | 2090624.80021 | 37.7199486087273 | -122.472655655135 | (37.7199486087273, -122.472655655135) | 9 | 8 | 4 | 64 | 40 | |||
60170 | 181893 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 2370 29th Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 14 | Width 0ft | 5987361.9916 | 2099162.5217 | 37.7431711693476 | -122.486364226347 | (37.7431711693476, -122.486364226347) | 1 | 8 | 3 | 29491 | 35 | |||
68257 | 215598 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 700 Junipero Serra Blvd | 48 | : | Tree | Private 2 | 13 | Width 0ft | 5991274.41833 | 2092469.99796 | 37.7250224604947 | -122.472348449422 | (37.7250224604947, -122.472348449422) | 9 | 8 | 4 | 64 | 40 | |||
68561 | 215635 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 900 Junipero Serra Blvd | 78 | : | Tree | Private 2 | 3 | Width 0ft | 5991140.25702 | 2090584.02001 | 37.7198362663069 | -122.47267478013 | (37.7198362663069, -122.47267478013) | 9 | 8 | 4 | 64 | 40 | |||
69394 | 215626 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 900 Junipero Serra Blvd | 68 | : | Tree | Private 2 | 3 | Width 0ft | 5991156.30566 | 2090612.66695 | 37.7199158527268 | -122.472621393671 | (37.7199158527268, -122.472621393671) | 9 | 8 | 4 | 64 | 40 | |||
69926 | 215610 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 900 Junipero Serra Blvd | 50 | : | Tree | Private 2 | 6 | Width 0ft | 5991146.77446 | 2090663.32778 | 37.7200544031655 | -122.472658031161 | (37.7200544031655, -122.472658031161) | 9 | 8 | 4 | 64 | 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) );