trees
3,587 rows where qSpecies_id = 28 sorted by YCoord 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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
22089 | 86892 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 2500 Mason St | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | Permit Number 49821 | 6008765 | 2122158 | 37.8075356107649 | -122.413984454109 | (37.8075356107649, -122.413984454109) | 3 | 1 | 10 | 308 | 23 | |||
29279 | 86893 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 2500 Mason St | 12 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/24/2007 12:00:00 AM | 3x3 | Permit Number 49821 | 6008765 | 2122158 | 37.8075356107649 | -122.413984454109 | (37.8075356107649, -122.413984454109) | 3 | 1 | 10 | 308 | 23 | ||
121257 | 86891 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 2500 Mason St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | Permit Number 49821 | 6008765 | 2122158 | 37.8075356107649 | -122.413984454109 | (37.8075356107649, -122.413984454109) | 3 | 1 | 10 | 308 | 23 | |||
136340 | 86890 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 2500 Mason St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | Permit Number 49821 | 6008765 | 2122158 | 37.8075356107649 | -122.413984454109 | (37.8075356107649, -122.413984454109) | 3 | 1 | 10 | 308 | 23 | |||
1661 | 126293 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 300 North Point St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 6009210.11859 | 2121881.78828 | 37.8068021921193 | -122.412424475734 | (37.8068021921193, -122.412424475734) | 3 | 1 | 10 | 308 | 23 | |||
113298 | 126294 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 300 North Point St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6009197.28554 | 2121879.69921 | 37.8067957358898 | -122.412468739439 | (37.8067957358898, -122.412468739439) | 3 | 1 | 10 | 308 | 23 | |||
157901 | 126295 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 300 North Point St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 26 | Width 4ft | 6009138.25888 | 2121870.32475 | 37.8067666832919 | -122.412672350444 | (37.8067666832919, -122.412672350444) | 3 | 1 | 10 | 308 | 23 | |||
75097 | 126296 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 300 North Point St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 20 | Width 4ft | 6009109.48206 | 2121867.97371 | 37.8067586127902 | -122.412771772309 | (37.8067586127902, -122.412771772309) | 3 | 1 | 10 | 308 | 23 | |||
187159 | 126297 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 300 North Point St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 4ft | 6009095.83841 | 2121864.72541 | 37.806748927978 | -122.412818759199 | (37.806748927978, -122.412818759199) | 3 | 1 | 10 | 308 | 23 | |||
120188 | 126298 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 300 North Point St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 32 | Width 4ft | 6008998.98319 | 2121852.98911 | 37.8067112661735 | -122.413153116346 | (37.8067112661735, -122.413153116346) | 3 | 1 | 10 | 308 | 23 | |||
44347 | 126299 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 300 North Point St | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 20 | Width 3ft | 6008955.34228 | 2121845.45564 | 37.806688131109 | -122.413303611596 | (37.806688131109, -122.413303611596) | 3 | 1 | 10 | 308 | 23 | |||
25543 | 126300 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 300 North Point St | 12 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 3ft | 6008880.73692 | 2121834.44066 | 37.8066536978683 | -122.413561019128 | (37.8066536978683, -122.413561019128) | 3 | 1 | 10 | 308 | 23 | |||
45551 | 126301 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 300 North Point St | 13 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 3ft | 6008867.14931 | 2121833.93475 | 37.8066515458005 | -122.413608006 | (37.8066515458005, -122.413608006) | 3 | 1 | 10 | 308 | 23 | |||
103532 | 88132 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 1288 Columbus Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 20 | 6007534.97421 | 2121589.88295 | 37.8059065468398 | -122.418200949141 | (37.8059065468398, -122.418200949141) | 5 | 1 | 10 | 308 | 23 | ||||
42643 | 258040 | Undocumented 4 | Corymbia ficifolia :: Red Flowering Gum 28 | 1288 Columbus Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6007535 | 2121589 | 37.8059041239352 | -122.418200797252 | (37.8059041239352, -122.418200797252) | 5 | 1 | 10 | 308 | 23 | ||||
130948 | 258043 | Undocumented 4 | Corymbia ficifolia :: Red Flowering Gum 28 | 1288 Columbus Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6007535 | 2121589 | 37.8059041239352 | -122.418200797252 | (37.8059041239352, -122.418200797252) | 5 | 1 | 10 | 308 | 23 | ||||
135347 | 258042 | Undocumented 4 | Corymbia ficifolia :: Red Flowering Gum 28 | 1288 Columbus Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/13/2019 12:00:00 AM | 3 | 3x3 | 6007535 | 2121589 | 37.8059041239352 | -122.418200797252 | (37.8059041239352, -122.418200797252) | 5 | 1 | 10 | 308 | 23 | ||
166089 | 258044 | Undocumented 4 | Corymbia ficifolia :: Red Flowering Gum 28 | 1288 Columbus Ave | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6007535 | 2121589 | 37.8059041239352 | -122.418200797252 | (37.8059041239352, -122.418200797252) | 5 | 1 | 10 | 308 | 23 | ||||
46872 | 27432 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 1288 Columbus Ave | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 22 | 4X4 | 6007580.92749 | 2121572.89753 | 37.8058624956614 | -122.418040715371 | (37.8058624956614, -122.418040715371) | 5 | 1 | 10 | 308 | 23 | |||
78272 | 126292 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 1198 Columbus Ave | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 20 | Width 4ft | 6007576.38379 | 2121572.19977 | 37.8058603240585 | -122.418056390085 | (37.8058603240585, -122.418056390085) | 5 | 1 | 10 | 308 | 23 | |||
51500 | 126291 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 1198 Columbus Ave | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 4ft | 6007589.25664 | 2121562.16822 | 37.8058335044831 | -122.418011129904 | (37.8058335044831, -122.418011129904) | 5 | 1 | 10 | 308 | 23 | |||
189542 | 27431 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 1288 Columbus Ave | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 16 | 4X4 | 6007595.97622 | 2121559.89845 | 37.8058276504572 | -122.41798771471 | (37.8058276504572, -122.41798771471) | 5 | 1 | 10 | 308 | 23 | |||
24340 | 126290 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 1198 Columbus Ave | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 4ft | 6007603.03986 | 2121549.62811 | 37.8057998482576 | -122.417962541334 | (37.8057998482576, -122.417962541334) | 5 | 1 | 10 | 308 | 23 | |||
166197 | 27430 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 1288 Columbus Ave | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 80 | 4X4 | 6007606.86637 | 2121548.41017 | 37.8057967194592 | -122.417949212693 | (37.8057967194592, -122.417949212693) | 5 | 1 | 10 | 308 | 23 | |||
146260 | 126272 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 743 North Point St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 2ft | 6007155.35459 | 2121542.9483 | 37.8057563012647 | -122.419511352869 | (37.8057563012647, -122.419511352869) | 5 | 1 | 1 | 28858 | 32 | |||
91007 | 256619 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 1255 Columbus Ave | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3X3 | 6007516.58505 | 2121541.63395 | 37.8057730322633 | -122.418261164826 | (37.8057730322633, -122.418261164826) | 5 | 1 | 1 | 308 | 32 | ||||
140424 | 256621 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 1255 Columbus Ave | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3X3 | 6007516.58505 | 2121541.63395 | 37.8057730322633 | -122.418261164826 | (37.8057730322633, -122.418261164826) | 5 | 1 | 1 | 308 | 32 | ||||
158289 | 256620 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 1255 Columbus Ave | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3X3 | 6007516.58505 | 2121541.63395 | 37.8057730322633 | -122.418261164826 | (37.8057730322633, -122.418261164826) | 5 | 1 | 1 | 308 | 32 | ||||
159475 | 256617 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 1255 Columbus Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3X3 | 6007516.58505 | 2121541.63395 | 37.8057730322633 | -122.418261164826 | (37.8057730322633, -122.418261164826) | 5 | 1 | 1 | 308 | 32 | ||||
88654 | 126271 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 757 North Point St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 3ft | 6007135.30447 | 2121541.57652 | 37.8057514053527 | -122.419580642053 | (37.8057514053527, -122.419580642053) | 5 | 1 | 1 | 28858 | 32 | |||
40252 | 126270 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 757 North Point St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 3ft | 6007122.07694 | 2121536.84547 | 37.8057376700126 | -122.419626082101 | (37.8057376700126, -122.419626082101) | 5 | 1 | 1 | 28858 | 32 | |||
150832 | 126269 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 757 North Point St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | Width 3ft | 6007103.42585 | 2121534.93603 | 37.8057313765645 | -122.419690491528 | (37.8057313765645, -122.419690491528) | 5 | 1 | 1 | 28858 | 32 | |||
59629 | 126268 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 757 North Point St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 6007089.07712 | 2121533.77158 | 37.8057273709962 | -122.419740064856 | (37.8057273709962, -122.419740064856) | 5 | 1 | 1 | 28858 | 32 | |||
65772 | 126289 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 1198 Columbus Ave | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 4ft | 6007647.01376 | 2121508.69836 | 37.8056899403132 | -122.417807459567 | (37.8056899403132, -122.417807459567) | 5 | 1 | 10 | 308 | 23 | |||
140649 | 126179 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 2 Marina Blvd | 8 | Sidewalk: Property side : Yard | Tree | Private 2 | 18 | 6003111.16889 | 2121419.1431 | 37.8051877435806 | -122.433497993332 | (37.8051877435806, -122.433497993332) | 13 | 9 | 1 | 57 | 17 | ||||
144087 | 126141 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 3734 Broderick St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 3ft | 5999645.87114 | 2121415.38382 | 37.804980205246 | -122.445489766664 | (37.804980205246, -122.445489766664) | 13 | 9 | 1 | 57 | 17 | |||
156257 | 126142 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 3734 Broderick St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 17 | Width 3ft | 5999648.2874 | 2121389.48257 | 37.8049092253522 | -122.445479541345 | (37.8049092253522, -122.445479541345) | 13 | 9 | 1 | 57 | 17 | |||
26412 | 34885 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 1539 Beach St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 38493 | 6002855.27225509 | 2121286.11305956 | 37.8048079563004 | -122.434374036967 | (37.8048079563004, -122.434374036967) | 13 | 9 | 1 | 57 | 17 | ||||
176116 | 143223 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 291 Francisco St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 0ft | 6009921.7346 | 2121237.0316 | 37.8050717594781 | -122.409916233664 | (37.8050717594781, -122.409916233664) | 3 | 1 | 10 | 308 | 23 | |||
137768 | 126145 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 138 Cervantes Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 17 | Width 3ft | 6001269.24495 | 2121199.42999 | 37.8044797945642 | -122.439856418732 | (37.8044797945642, -122.439856418732) | 13 | 9 | 1 | 57 | 17 | |||
168548 | 249774 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 102 Pfeiffer St | 5 | Side Yard : Yard | Tree | Private 2 | 6 | Width 0ft | 6010412.38512 | 2121159.3166 | 37.8048858591461 | -122.408212787783 | (37.8048858591461, -122.408212787783) | 3 | 1 | 10 | 308 | 23 | |||
151964 | 126316 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 30 Chestnut St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 19 | Width 3ft | 6011523.49407 | 2121154.08896 | 37.8049336581286 | -122.404367285814 | (37.8049336581286, -122.404367285814) | 3 | 1 | 10 | 28860 | 23 | |||
74445 | 249775 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 102 Pfeiffer St | 6 | Side Yard : Yard | Tree | Private 2 | 21 | Width 0ft | 6010401.04426 | 2121152.23114 | 37.8048657692012 | -122.40825153419 | (37.8048657692012, -122.40825153419) | 3 | 1 | 10 | 308 | 23 | |||
62295 | 106457 | Undocumented 4 | Corymbia ficifolia :: Red Flowering Gum 28 | 1x CHESTNUT ST | 14 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6011546 | 2121132 | 37.8048742648975 | -122.404287845465 | (37.8048742648975, -122.404287845465) | 3 | 1 | 10 | 28860 | 6 | |||||
135570 | 126315 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 19 Chestnut St | 15 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 5ft | 6011706.66389 | 2121131.24206 | 37.8048811601877 | -122.403731794293 | (37.8048811601877, -122.403731794293) | 3 | 1 | 10 | 28860 | 6 | |||
177646 | 126314 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 19 Chestnut St | 14 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 22 | Width 5ft | 6011690.09523 | 2121129.11088 | 37.8048743829079 | -122.403788982197 | (37.8048743829079, -122.403788982197) | 3 | 1 | 10 | 28860 | 6 | |||
137569 | 126313 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 19 Chestnut St | 13 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 5ft | 6011665.22297 | 2121124.95419 | 37.8048615801547 | -122.40387476313 | (37.8048615801547, -122.40387476313) | 3 | 1 | 10 | 28860 | 6 | |||
167504 | 126312 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 19 Chestnut St | 11 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 5ft | 6011622.11904 | 2121118.15193 | 37.8048404946454 | -122.404023450725 | (37.8048404946454, -122.404023450725) | 3 | 1 | 10 | 28860 | 6 | |||
15569 | 4741 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 1120 Columbus Ave | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/29/1992 12:00:00 AM | 12 | 3X3 | 6008069.3023022 | 2121114.6784448 | 37.8046318166674 | -122.416318139035 | (37.8046318166674, -122.416318139035) | 5 | 1 | 10 | 308 | 23 | ||
79903 | 126311 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 19 Chestnut St | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 20 | Width 5ft | 6011596.42071 | 2121114.01244 | 37.804827692793 | -122.404112091508 | (37.804827692793, -122.404112091508) | 3 | 1 | 10 | 28860 | 6 | |||
183410 | 126310 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 19 Chestnut St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 5ft | 6011567.70518 | 2121110.48267 | 37.804816396425 | -122.404211216594 | (37.804816396425, -122.404211216594) | 3 | 1 | 10 | 28860 | 6 | |||
64433 | 126309 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 19 Chestnut St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | Width 5ft | 6011549.22604 | 2121109.21321 | 37.8048118782298 | -122.404275076545 | (37.8048118782298, -122.404275076545) | 3 | 1 | 10 | 28860 | 6 | |||
40556 | 126308 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 19 Chestnut St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 22 | Width 5ft | 6011431.79108 | 2121090.48477 | 37.8047538917423 | -122.404680155458 | (37.8047538917423, -122.404680155458) | 3 | 1 | 10 | 28860 | 6 | |||
74115 | 126307 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 19 Chestnut St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 21 | Width 5ft | 6011412.75588 | 2121088.95225 | 37.8047486199155 | -122.404745921109 | (37.8047486199155, -122.404745921109) | 3 | 1 | 10 | 28860 | 6 | |||
81461 | 126306 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 19 Chestnut St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 4ft | 6011394.26023 | 2121086.86047 | 37.8047418426192 | -122.404809780174 | (37.8047418426192, -122.404809780174) | 3 | 1 | 10 | 28860 | 6 | |||
33988 | 126305 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 19 Chestnut St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 22 | Width 5ft | 6011380.98964 | 2121084.38787 | 37.8047343117091 | -122.404855530454 | (37.8047343117091, -122.404855530454) | 3 | 1 | 10 | 28860 | 6 | |||
99963 | 142977 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 1909 Grant Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | Width 0ft | 6010355.8809 | 2121023.9734 | 37.804511076187 | -122.408398775224 | (37.804511076187, -122.408398775224) | 3 | 1 | 10 | 308 | 23 | |||
33792 | 142978 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 1905 Grant Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 19 | Width 0ft | 6010357.7464 | 2121006.2509 | 37.8044625190574 | -122.408391068632 | (37.8044625190574, -122.408391068632) | 3 | 1 | 10 | 308 | 23 | |||
30430 | 102606 | Undocumented 4 | Corymbia ficifolia :: Red Flowering Gum 28 | 300 Chestnut St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4x4 | 6010368 | 2120990 | 37.8044184722981 | -122.408354438035 | (37.8044184722981, -122.408354438035) | 3 | 1 | 10 | 308 | 23 | ||||
157696 | 102605 | Undocumented 4 | Corymbia ficifolia :: Red Flowering Gum 28 | 300 Chestnut St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4x4 | 6010368 | 2120990 | 37.8044184722981 | -122.408354438035 | (37.8044184722981, -122.408354438035) | 3 | 1 | 10 | 308 | 23 | ||||
12205 | 142979 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 302 CHESTNUT ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 34 | Width 0ft | 6010333.0283 | 2120985.7302 | 37.8044047900705 | -122.40847515981 | (37.8044047900705, -122.40847515981) | 3 | 1 | 10 | 308 | 23 | |||
44086 | 142980 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 302 CHESTNUT ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 17 | Width 0ft | 6010297.117 | 2120982.4656 | 37.8043938151268 | -122.408599204074 | (37.8043938151268, -122.408599204074) | 3 | 1 | 10 | 308 | 23 | |||
25886 | 126275 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 2836 Larkin St | 7 | Side Yard : Yard | Tree | Private 2 | 26 | 6006511.2494 | 2120976.42855 | 37.8041644823576 | -122.421700114785 | (37.8041644823576, -122.421700114785) | 5 | 9 | 1 | 28858 | 32 | ||||
57942 | 142990 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 1847 GRANT AVE | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 0ft | 6010376.3672 | 2120881.545 | 37.804121150252 | -122.408317828181 | (37.804121150252, -122.408317828181) | 3 | 1 | 10 | 308 | 23 | |||
193020 | 108614 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 1847 GRANT AVE | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | 3x3 | 6010358.9 | 2120872.9 | 37.8040964350925 | -122.408377664827 | (37.8040964350925, -122.408377664827) | 3 | 1 | 10 | 308 | 23 | |||
193754 | 126302 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 150 Lombard St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 21 | Width 3ft | 6011734.76105 | 2120835.8555 | 37.8040716705345 | -122.403613764588 | (37.8040716705345, -122.403613764588) | 3 | 1 | 10 | 28860 | 6 | |||
160228 | 126303 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 150 Lombard St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 3ft | 6011649.70987 | 2120828.01575 | 37.8040453932491 | -122.403907539796 | (37.8040453932491, -122.403907539796) | 3 | 1 | 10 | 28860 | 6 | |||
31020 | 126304 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 150 Lombard St | 14 | Sidewalk: Property side : Yard | Tree | Private 2 | 13 | Width 3ft | 6011511.53944 | 2120807.30084 | 37.8039807949437 | -122.40438423177 | (37.8039807949437, -122.40438423177) | 3 | 1 | 10 | 28860 | 6 | |||
72445 | 142612 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 2424 JONES ST | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 19 | Width 0ft | 6008004.2032 | 2120805.2808 | 37.8037786279563 | -122.416521491468 | (37.8037786279563, -122.416521491468) | 5 | 1 | 10 | 308 | 32 | |||
37746 | 142611 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 2424 JONES ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 19 | Width 0ft | 6008004.2032 | 2120795.1714 | 37.8037508700928 | -122.416520774929 | (37.8037508700928, -122.416520774929) | 5 | 1 | 10 | 308 | 32 | |||
175939 | 69365 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 3536 Webster St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/18/1994 12:00:00 AM | 15 | 4.5x6 | Permit Number 33459 | 6002661.12901 | 2120784.76321 | 37.8034203599148 | -122.435010010914 | (37.8034203599148, -122.435010010914) | 13 | 9 | 1 | 57 | 17 |
12133 | 133687 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 1451 Bay St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6003859 | 2120749 | 37.803390106055 | -122.430862178125 | (37.803390106055, -122.430862178125) | 13 | 9 | 1 | 28858 | 17 | |||
15622 | 126182 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 1451 Bay St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6003859 | 2120749 | 37.803390106055 | -122.430862178125 | (37.803390106055, -122.430862178125) | 13 | 9 | 1 | 28858 | 17 | |||
188034 | 126181 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 1451 Bay St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 3ft | 6003742.08845 | 2120700.5958 | 37.8032505760096 | -122.431263297686 | (37.8032505760096, -122.431263297686) | 13 | 9 | 1 | 28858 | 17 | |||
174139 | 126184 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 3235 Gough St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 23 | Width 5ft | 6004572.288 | 2120697.68117 | 37.8032895858962 | -122.428390157106 | (37.8032895858962, -122.428390157106) | 13 | 9 | 1 | 28858 | 17 | |||
93311 | 126176 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 3529 Broderick St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 3ft | 5999701.32515 | 2120694.15268 | 37.8030030646038 | -122.445245975747 | (37.8030030646038, -122.445245975747) | 13 | 9 | 1 | 57 | 17 | |||
108997 | 126180 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 1451 Bay St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/31/1985 12:00:00 AM | 10 | Width 3ft | Permit Number 22077 | 6003710.0609 | 2120692.32566 | 37.8032260532978 | -122.431373539285 | (37.8032260532978, -122.431373539285) | 13 | 9 | 1 | 57 | 17 | |
104617 | 126177 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 3529 Broderick St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 3ft | 5999703.19672 | 2120677.23394 | 37.802956717127 | -122.445238282035 | (37.802956717127, -122.445238282035) | 13 | 9 | 1 | 57 | 17 | |||
108456 | 126185 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 3235 Gough St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 32 | Width 5ft | 6004573.69518 | 2120676.94649 | 37.8032327334623 | -122.428383808781 | (37.8032327334623, -122.428383808781) | 13 | 9 | 1 | 28858 | 17 | |||
155403 | 126186 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 3223 Gough St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | Width 2ft | 6004579.06351 | 2120655.52096 | 37.8031742082758 | -122.428363703522 | (37.8031742082758, -122.428363703522) | 13 | 9 | 1 | 28858 | 17 | |||
45512 | 126187 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 3201 Gough St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 23 | Width 4ft | 6004586.52234 | 2120587.15972 | 37.8029869280666 | -122.428333016857 | (37.8029869280666, -122.428333016857) | 13 | 9 | 1 | 57 | 17 | |||
37425 | 126188 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 3201 Gough St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 4ft | 6004588.02388 | 2120570.99055 | 37.8029426166745 | -122.428326667653 | (37.8029426166745, -122.428326667653) | 13 | 9 | 1 | 57 | 17 | |||
119456 | 126189 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 3201 Gough St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 32 | Width 6ft | 6004592.21968 | 2120552.02505 | 37.8028907797349 | -122.42831079551 | (37.8028907797349, -122.42831079551) | 13 | 9 | 1 | 57 | 17 | |||
31368 | 126148 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 1535 Chestnut St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 17 | Width 3ft | 6004474.30573 | 2120123.1658 | 37.8017065704734 | -122.428688249077 | (37.8017065704734, -122.428688249077) | 13 | 9 | 1 | 57 | 17 | |||
78292 | 126147 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 1535 Chestnut St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 3ft | 6004454.32167 | 2120122.09726 | 37.8017025055244 | -122.428757326909 | (37.8017025055244, -122.428757326909) | 13 | 9 | 1 | 57 | 17 | |||
69 | 126274 | Significant Tree 6 | Corymbia ficifolia :: Red Flowering Gum 28 | 1240 Lombard St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 24 | Width 6ft | 6006421.51674 | 2120105.21307 | 37.8017672864012 | -122.421948716173 | (37.8017672864012, -122.421948716173) | 5 | 9 | 1 | 28858 | 32 | |||
122007 | 126273 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 1239 Lombard St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 20 | Width 3ft | 6006424.6577 | 2120048.11066 | 37.8016106748465 | -122.421933788324 | (37.8016106748465, -122.421933788324) | 13 | 9 | 1 | 28858 | 32 | |||
19241 | 26162 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 220 Richardson Ave | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3X3 | 5999090.09548 | 2119848.96049 | 37.8006474865597 | -122.447300272802 | (37.8006474865597, -122.447300272802) | 13 | 9 | 1 | 57 | 17 | |||
50422 | 121422 | Undocumented 4 | Corymbia ficifolia :: Red Flowering Gum 28 | 2466 Francisco St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5999524 | 2119846 | 37.8006641419807 | -122.445798577396 | (37.8006641419807, -122.445798577396) | 13 | 9 | 1 | 57 | 17 | ||||
139850 | 126144 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 2474 Francisco St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 30 | Width 6ft | 5999504.13752 | 2119828.56241 | 37.8006151289325 | -122.445866054678 | (37.8006151289325, -122.445866054678) | 13 | 9 | 1 | 57 | 17 | |||
89043 | 126146 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 41 Magnolia St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 1ft | 6003510.16046 | 2119826.75465 | 37.8008380897709 | -122.432003455008 | (37.8008380897709, -122.432003455008) | 13 | 9 | 1 | 57 | 17 | |||
65316 | 50979 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 201 Richardson Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/06/2004 12:00:00 AM | 3x3 | Permit Number 47465 | 5999116.7 | 2119758.3 | 37.8004000774175 | -122.447201682136 | (37.8004000774175, -122.447201682136) | 13 | 9 | 1 | 57 | 17 | ||
15846 | 75161 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 1500X Greenwich St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 15 | 6005585.43876 | 2119632.07302 | 37.8004209769936 | -122.42480825631 | (37.8004209769936, -122.42480825631) | 13 | 9 | 1 | 57 | 17 | |||
140494 | 126140 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 1500 Greenwich St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 6ft | 6005564.97386 | 2119630.33359 | 37.8004150450641 | -122.424878949302 | (37.8004150450641, -122.424878949302) | 13 | 9 | 1 | 57 | 17 | |||
78962 | 142483 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 502 Union St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 0ft | 6010521.5126 | 2119626.8488 | 37.8006841900348 | -122.407727016144 | (37.8006841900348, -122.407727016144) | 3 | 1 | 10 | 308 | 23 | |||
96489 | 126285 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 1819 Mason St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 22 | Width 3ft | 6009101.69173 | 2119559.34428 | 37.800419255712 | -122.412635425182 | (37.800419255712, -122.412635425182) | 3 | 1 | 10 | 308 | 32 | |||
107942 | 126286 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 1819 Mason St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 6009103.85324 | 2119545.79169 | 37.8003821649739 | -122.412626986872 | (37.8003821649739, -122.412626986872) | 3 | 1 | 10 | 308 | 32 | |||
9240 | 126178 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 2413 Chestnut St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 4ft | 6000282.738 | 2119543.98555 | 37.7998781830919 | -122.44315133689 | (37.7998781830919, -122.44315133689) | 13 | 9 | 1 | 57 | 17 | |||
96784 | 126143 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 3233 Scott St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 4ft | 6000856.10571 | 2119467.95657 | 37.7997021039237 | -122.441161817058 | (37.7997021039237, -122.441161817058) | 13 | 9 | 1 | 57 | 17 | |||
90560 | 142909 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 470 GREEN ST | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 21 | Width 0ft | 6010691.0969 | 2119300.3155 | 37.7997971013368 | -122.407117151967 | (37.7997971013368, -122.407117151967) | 3 | 1 | 10 | 308 | 23 |
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) );