trees
147 rows where qSpecies_id = 138 sorted by PlotSize
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
133149 | 132362 | DPW Maintained 1 | Pittosporum eugenioides :: Tarata 138 | 3455 Washington St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 5998243.11414 | 2115825.02859 | 37.7895504145686 | -122.449940991703 | (37.7895504145686, -122.449940991703) | 13 | 6 | 1 | 54 | 31 | |||
140645 | 249601 | DPW Maintained 1 | Pittosporum eugenioides :: Tarata 138 | 2200 Golden Gate Ave | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 17 | Width 3ft | 5998898.09787 | 2111497.4092 | 37.7777053557513 | -122.447363215433 | (37.7777053557513, -122.447363215433) | 15 | 6 | 2 | 54 | 16 | |||
142731 | 178394 | DPW Maintained 1 | Pittosporum eugenioides :: Tarata 138 | 25 Capistrano Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6001248.99944 | 2093921.66441 | 37.7295806536223 | -122.437971416359 | (37.7295806536223, -122.437971416359) | 9 | 7 | 6 | 28861 | 25 | |||
154576 | 233974 | DPW Maintained 1 | Pittosporum eugenioides :: Tarata 138 | 2315 15th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6002049.59534 | 2107034.31873 | 37.7656303987394 | -122.436141661111 | (37.7656303987394, -122.436141661111) | 15 | 5 | 5 | 28862 | 3 | |||
158630 | 211449 | DPW Maintained 1 | Pittosporum eugenioides :: Tarata 138 | 1554 10th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 5993091.38036 | 2104901.42473 | 37.759261008817 | -122.466970818352 | (37.759261008817, -122.466970818352) | 1 | 8 | 4 | 56 | 12 | |||
163790 | 211452 | DPW Maintained 1 | Pittosporum eugenioides :: Tarata 138 | 151 Lippard Ave | 14 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6001868.44075 | 2095314.06759 | 37.7334390806456 | -122.435929538915 | (37.7334390806456, -122.435929538915) | 9 | 7 | 5 | 63 | 40 | |||
164530 | 211446 | DPW Maintained 1 | Pittosporum eugenioides :: Tarata 138 | 1313 Bosworth St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 3ft | 6000201.81389 | 2096459.5971 | 37.7364896179085 | -122.441773706798 | (37.7364896179085, -122.441773706798) | 2 | 7 | 5 | 63 | 7 | |||
169303 | 123101 | DPW Maintained 1 | Pittosporum eugenioides :: Tarata 138 | 507 11th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 5992491.93935 | 2111979.13383 | 37.7786598912114 | -122.469559186337 | (37.7786598912114, -122.469559186337) | 11 | 6 | 2 | 54 | 11 | |||
169974 | 178395 | DPW Maintained 1 | Pittosporum eugenioides :: Tarata 138 | 61 Lisbon St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6003678.4559 | 2093041.21797 | 37.7273010035375 | -122.429509772582 | (37.7273010035375, -122.429509772582) | 9 | 7 | 6 | 28861 | 5 | |||
184853 | 122245 | DPW Maintained 1 | Pittosporum eugenioides :: Tarata 138 | 47 Lake St | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 12 | Width 3ft | 5990779.80056 | 2114787.3723 | 37.7862714344884 | -122.475687193172 | (37.7862714344884, -122.475687193172) | 11 | 6 | 1 | 54 | 33 | |||
185221 | 211447 | DPW Maintained 1 | Pittosporum eugenioides :: Tarata 138 | 4140 19th Ave | 1 | : | Tree | Private 2 | 8 | Width 3ft | 5992076.98829 | 2088316.96105 | 37.7136656526261 | -122.469271936146 | (37.7136656526261, -122.469271936146) | 9 | 8 | 6 | 64 | 24 | |||
7920 | 194579 | DPW Maintained 1 | Pittosporum eugenioides :: Tarata 138 | 588 Missouri St | 2 | Sidewalk: Curb side : Pot | Tree | Private 2 | 3 | Width 4ft | 6013514.83137 | 2104327.63621 | 37.7588431577105 | -122.396295924418 | (37.7588431577105, -122.396295924418) | 10 | 3 | 8 | 28856 | 29 | |||
8856 | 194577 | DPW Maintained 1 | Pittosporum eugenioides :: Tarata 138 | 580 Missouri St | 2 | Sidewalk: Curb side : Pot | Tree | Private 2 | 9 | Width 4ft | 6013511.64038 | 2104375.7087 | 37.7589749767275 | -122.396310329764 | (37.7589749767275, -122.396310329764) | 10 | 3 | 8 | 28856 | 29 | |||
30701 | 233973 | DPW Maintained 1 | Pittosporum eugenioides :: Tarata 138 | 242 Upper Ter | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 11 | Width 4ft | 5999494.67763 | 2106185.26835 | 37.7631536325665 | -122.444917488449 | (37.7631536325665, -122.444917488449) | 15 | 5 | 5 | 29492 | 9 | |||
36806 | 233967 | DPW Maintained 1 | Pittosporum eugenioides :: Tarata 138 | 26 Parnassus Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 4ft | 5998528.05079 | 2106918.36073 | 37.7651113055593 | -122.448313505688 | (37.7651113055593, -122.448313505688) | 15 | 5 | 11 | 29492 | 9 | |||
53957 | 194576 | DPW Maintained 1 | Pittosporum eugenioides :: Tarata 138 | 572 Missouri St | 1 | Sidewalk: Curb side : Pot | Tree | Private 2 | 5 | Width 4ft | 6013508.15849 | 2104424.13067 | 37.7591077391483 | -122.396325765734 | (37.7591077391483, -122.396325765734) | 10 | 3 | 8 | 28856 | 29 | |||
54264 | 194578 | DPW Maintained 1 | Pittosporum eugenioides :: Tarata 138 | 586 Missouri St | 2 | Sidewalk: Curb side : Pot | Tree | Private 2 | 3 | Width 4ft | 6013510.77458 | 2104373.03233 | 37.7589675798212 | -122.396313136545 | (37.7589675798212, -122.396313136545) | 10 | 3 | 8 | 28856 | 29 | |||
71260 | 233964 | DPW Maintained 1 | Pittosporum eugenioides :: Tarata 138 | 16 Parnassus Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 4ft | 5998642.1251 | 2106932.60313 | 37.7651569326801 | -122.447919977648 | (37.7651569326801, -122.447919977648) | 15 | 5 | 11 | 29492 | 9 | |||
75424 | 233965 | DPW Maintained 1 | Pittosporum eugenioides :: Tarata 138 | 16 Parnassus Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 4ft | 5998630.02357 | 2106931.63106 | 37.7651535718969 | -122.447961763741 | (37.7651535718969, -122.447961763741) | 15 | 5 | 11 | 29492 | 9 | |||
85702 | 132381 | DPW Maintained 1 | Pittosporum eugenioides :: Tarata 138 | 1713 Taylor St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 7 | Width 4ft | 6008727.87126 | 2118754.69526 | 37.7981889019448 | -122.413872046978 | (37.7981889019448, -122.413872046978) | 5 | 1 | 10 | 308 | 21 | |||
90214 | 233968 | DPW Maintained 1 | Pittosporum eugenioides :: Tarata 138 | 59 Parnassus Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 4ft | 5998414.25263 | 2106859.15364 | 37.7649422312277 | -122.448702839263 | (37.7649422312277, -122.448702839263) | 15 | 5 | 11 | 29492 | 9 | |||
101306 | 233963 | DPW Maintained 1 | Pittosporum eugenioides :: Tarata 138 | 16 Parnassus Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 17 | Width 4ft | 5998658.62775 | 2106938.30224 | 37.7651735242683 | -122.447863309551 | (37.7651735242683, -122.447863309551) | 15 | 5 | 11 | 29492 | 9 | |||
104902 | 132383 | DPW Maintained 1 | Pittosporum eugenioides :: Tarata 138 | 1713 Taylor St | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 8 | Width 4ft | 6008731.67478 | 2118716.17732 | 37.7980833548266 | -122.413856159533 | (37.7980833548266, -122.413856159533) | 5 | 1 | 10 | 308 | 21 | |||
111410 | 233970 | DPW Maintained 1 | Pittosporum eugenioides :: Tarata 138 | 59 Parnassus Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 4ft | 5998449.53316 | 2106863.19401 | 37.7649553424266 | -122.448581104347 | (37.7649553424266, -122.448581104347) | 15 | 5 | 11 | 29492 | 9 | |||
116208 | 194582 | DPW Maintained 1 | Pittosporum eugenioides :: Tarata 138 | 618 Missouri St | 1 | Sidewalk: Curb side : Pot | Tree | Private 2 | 5 | Width 4ft | 6013519.11255 | 2104217.18281 | 37.7585401149596 | -122.39627337661 | (37.7585401149596, -122.39627337661) | 10 | 3 | 8 | 28856 | 29 | |||
119254 | 194581 | DPW Maintained 1 | Pittosporum eugenioides :: Tarata 138 | 608 Missouri St | 1 | Sidewalk: Curb side : Pot | Tree | Private 2 | 4 | Width 4ft | 6013516.07962 | 2104276.20006 | 37.7587019947082 | -122.396288002304 | (37.7587019947082, -122.396288002304) | 10 | 3 | 8 | 28856 | 29 | |||
122832 | 233961 | DPW Maintained 1 | Pittosporum eugenioides :: Tarata 138 | 107 Valley St | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 4 | Width 4ft | 6005126.40352 | 2099291.88165 | 37.744545799654 | -122.424948746605 | (37.744545799654, -122.424948746605) | 2 | 7 | 5 | 63 | 22 | |||
130439 | 233969 | DPW Maintained 1 | Pittosporum eugenioides :: Tarata 138 | 59 Parnassus Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 4ft | 5998431.96444 | 2106860.62027 | 37.7649472710115 | -122.448641684483 | (37.7649472710115, -122.448641684483) | 15 | 5 | 11 | 29492 | 9 | |||
138004 | 194575 | DPW Maintained 1 | Pittosporum eugenioides :: Tarata 138 | 568 Missouri St | 2 | Sidewalk: Curb side : Pot | Tree | Private 2 | 3 | Width 4ft | 6013510.83994 | 2104426.47875 | 37.7591143356749 | -122.396316656512 | (37.7591143356749, -122.396316656512) | 10 | 3 | 8 | 28856 | 29 | |||
145472 | 233966 | DPW Maintained 1 | Pittosporum eugenioides :: Tarata 138 | 16 Parnassus Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 4ft | 5998617.81903 | 2106930.99425 | 37.76515112575 | -122.448003930257 | (37.76515112575, -122.448003930257) | 15 | 5 | 11 | 29492 | 9 | |||
148763 | 123354 | DPW Maintained 1 | Pittosporum eugenioides :: Tarata 138 | 706 04th Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 10 | Width 4ft | 5994755.71822 | 2110691.45516 | 37.7752548415612 | -122.461634571421 | (37.7752548415612, -122.461634571421) | 11 | 6 | 2 | 54 | 11 | |||
152404 | 194580 | DPW Maintained 1 | Pittosporum eugenioides :: Tarata 138 | 598 Missouri St | 1 | Sidewalk: Curb side : Pot | Tree | Private 2 | 3 | Width 4ft | 6013513.20546 | 2104325.65158 | 37.7588376178753 | -122.39630140851 | (37.7588376178753, -122.39630140851) | 10 | 3 | 8 | 28856 | 29 | |||
164671 | 211450 | DPW Maintained 1 | Pittosporum eugenioides :: Tarata 138 | 186 Merced Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 4ft | 5994246.46565 | 2099200.24413 | 37.7436736209515 | -122.462562455004 | (37.7436736209515, -122.462562455004) | 1 | 8 | 4 | 59 | 40 | |||
167221 | 233972 | DPW Maintained 1 | Pittosporum eugenioides :: Tarata 138 | 242 Upper Ter | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 12 | Width 4ft | 5999499.27806 | 2106191.48034 | 37.7631709516944 | -122.444902023732 | (37.7631709516944, -122.444902023732) | 15 | 5 | 5 | 29492 | 9 | |||
171157 | 233959 | DPW Maintained 1 | Pittosporum eugenioides :: Tarata 138 | 101 Albion St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 4ft | 6005908.69578 | 2106579.49211 | 37.7646000472828 | -122.422761537821 | (37.7646000472828, -122.422761537821) | 8 | 4 | 5 | 28859 | 19 | |||
178657 | 247548 | DPW Maintained 1 | Pittosporum eugenioides :: Tarata 138 | 815 Buena Vista Ave West | 5 | Sidewalk: Curb side : Yard | Tree | Private 2 | 14 | Width 4ft | 6000113.77952 | 2108396.7627 | 37.7692611579062 | -122.442935049924 | (37.7692611579062, -122.442935049924) | 15 | 5 | 11 | 29492 | 9 | |||
187031 | 132382 | DPW Maintained 1 | Pittosporum eugenioides :: Tarata 138 | 1713 Taylor St | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 7 | Width 4ft | 6008728.03476 | 2118737.75818 | 37.7981424061004 | -122.413870282493 | (37.7981424061004, -122.413870282493) | 5 | 1 | 10 | 308 | 21 | |||
188528 | 178398 | DPW Maintained 1 | Pittosporum eugenioides :: Tarata 138 | 300 Gaven St | 6 | Sidewalk: Property side : Yard | Tree | Private 2 | 2 | Width 4ft | 6008862.12496 | 2094845.75943 | 37.7325480233545 | -122.411717230865 | (37.7325480233545, -122.411717230865) | 9 | 3 | 7 | 309 | 28 | |||
58819 | 178400 | DPW Maintained 1 | Pittosporum eugenioides :: Tarata 138 | 802 Excelsior Ave | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 7 | Width 6ft | 6004451.61665 | 2091406.41613 | 37.7228559442383 | -122.426720588195 | (37.7228559442383, -122.426720588195) | 9 | 7 | 6 | 28861 | 5 | |||
86516 | 211436 | DPW Maintained 1 | Pittosporum eugenioides :: Tarata 138 | 220x Vasquez Ave | 1 | Median : Cutout | Tree | DPW 1 | 34 | Width 6ft | 5994537.09641 | 2099112.75591 | 37.7434501331166 | -122.461551189851 | (37.7434501331166, -122.461551189851) | 1 | 8 | 4 | 59 | 40 | |||
122676 | 194590 | DPW Maintained 1 | Pittosporum eugenioides :: Tarata 138 | 13 Bridgeview Way | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 2 | Width 6ft | 6016094.38858 | 2108337.40723 | 37.7699963267064 | -122.387654295729 | (37.7699963267064, -122.387654295729) | 14 | 3 | 9 | 310 | 20 | |||
2040 | 194583 | DPW Maintained 1 | Pittosporum eugenioides :: Tarata 138 | 1698 Galvez Ave | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 13 | Width 8ft | 6015441.64874 | 2098018.63828 | 37.7416270022859 | -122.389191507809 | (37.7416270022859, -122.389191507809) | 10 | 3 | 8 | 58 | 1 | |||
57567 | 194586 | DPW Maintained 1 | Pittosporum eugenioides :: Tarata 138 | 1698 Galvez Ave | 8 | Sidewalk: Property side : Yard | Tree | Private 2 | 13 | Width 8ft | 6015412.99907 | 2098039.7697 | 37.7416834365362 | -122.389292044817 | (37.7416834365362, -122.389292044817) | 10 | 3 | 8 | 58 | 1 | |||
105402 | 194585 | DPW Maintained 1 | Pittosporum eugenioides :: Tarata 138 | 1698 Galvez Ave | 6 | Sidewalk: Property side : Yard | Tree | Private 2 | 13 | Width 8ft | 6015429.91647 | 2098027.47569 | 37.741650617592 | -122.389232691343 | (37.741650617592, -122.389232691343) | 10 | 3 | 8 | 58 | 1 | |||
116106 | 247639 | DPW Maintained 1 | Pittosporum eugenioides :: Tarata 138 | 360 Bradford St | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 8 | Width 8ft | 6009456.29127 | 2096556.43991 | 37.7372784977969 | -122.409783755028 | (37.7372784977969, -122.409783755028) | 10 | 7 | 7 | 28859 | 2 | |||
175166 | 194584 | DPW Maintained 1 | Pittosporum eugenioides :: Tarata 138 | 1698 Galvez Ave | 5 | Sidewalk: Property side : Yard | Tree | Private 2 | 10 | Width 8ft | 6015435.57046 | 2098024.51696 | 37.7416428069711 | -122.389212935026 | (37.7416428069711, -122.389212935026) | 10 | 3 | 8 | 58 | 1 | |||
116899 | 194587 | DPW Maintained 1 | Pittosporum eugenioides :: Tarata 138 | 37 Maddux Ave | 1 | Front Yard : Yard | Tree | Private 2 | 3 | Width 9ft | 6012781.54528 | 2095521.68187 | 37.7346230570026 | -122.398214166653 | (37.7346230570026, -122.398214166653) | 10 | 3 | 8 | 58 | 1 |
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) );