trees
87 rows where qSpecies_id = 222 sorted by rowid
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2249 | 261938 | DPW Maintained 1 | Brugmansia spp :: Angel trumpet 222 | 1 Verna St | 3 | Unaccepted Street : Yard | Tree | Private 2 | Width 3ft | 5998303 | 2096292 | 37.7359210601709 | -122.448326617787 | (37.7359210601709, -122.448326617787) | 9 | 7 | 4 | 59 | 40 | ||||
3592 | 175572 | DPW Maintained 1 | Brugmansia spp :: Angel trumpet 222 | 1785 Cayuga Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | Width 1ft | 5997902.91361 | 2088443.52841 | 37.7143481157506 | -122.449144629432 | (37.7143481157506, -122.449144629432) | 9 | 7 | 6 | 28861 | 25 | |||
11440 | 188846 | DPW Maintained 1 | Brugmansia spp :: Angel trumpet 222 | 65 Langton St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 2ft | 6009957.95402 | 2110976.93617 | 37.7769020444242 | -122.409066486348 | (37.7769020444242, -122.409066486348) | 8 | 2 | 9 | 28853 | 34 | |||
15007 | 72777 | DPW Maintained 1 | Brugmansia spp :: Angel trumpet 222 | 545 Lisbon St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 2 | 6001963.48566 | 2090308.61683 | 37.7197006458587 | -122.435243036941 | (37.7197006458587, -122.435243036941) | 9 | 7 | 6 | 28861 | 5 | |||
18802 | 251471 | DPW Maintained 1 | Brugmansia spp :: Angel trumpet 222 | 2423 Market St | 1 | Front Yard : Yard | Tree | DPW 1 | |||||||||||||||
19377 | 188842 | DPW Maintained 1 | Brugmansia spp :: Angel trumpet 222 | 1689 Jerrold Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | Width 1ft | 6014873.05165 | 2097305.05057 | 37.7396361002149 | -122.391107675301 | (37.7396361002149, -122.391107675301) | 10 | 3 | 8 | 58 | 1 | |||
21153 | 249851 | DPW Maintained 1 | Brugmansia spp :: Angel trumpet 222 | 285 Greenwich St | 2 | Front Yard : Yard | Tree | Private 2 | 6 | Width 0ft | 6011475.66665 | 2120406.51075 | 37.8028783187521 | -122.404480143551 | (37.8028783187521, -122.404480143551) | 3 | 1 | 10 | 308 | 23 | |||
21526 | 220753 | DPW Maintained 1 | Brugmansia spp :: Angel trumpet 222 | 178 Hancock St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6003125.88873 | 2105073.90703 | 37.7603086713261 | -122.432278980285 | (37.7603086713261, -122.432278980285) | 2 | 4 | 5 | 28862 | 3 | |||
22387 | 205642 | DPW Maintained 1 | Brugmansia spp :: Angel trumpet 222 | 1209 Capitol Ave | 5 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 3ft | 5995030.50949 | 2091927.98963 | 37.7237509099679 | -122.459324908227 | (37.7237509099679, -122.459324908227) | 9 | 8 | 4 | 28861 | 24 | |||
24225 | 220739 | DPW Maintained 1 | Brugmansia spp :: Angel trumpet 222 | 112 San Carlos St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6006641.65187 | 2105417.60595 | 37.7614511070914 | -122.420143969269 | (37.7614511070914, -122.420143969269) | 2 | 4 | 7 | 28859 | 19 | |||
24483 | 205640 | DPW Maintained 1 | Brugmansia spp :: Angel trumpet 222 | 1215 Capitol Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 3ft | 5995031.70006 | 2092006.18046 | 37.7239656716754 | -122.459326452373 | (37.7239656716754, -122.459326452373) | 9 | 8 | 4 | 28861 | 24 | |||
28565 | 202073 | DPW Maintained 1 | Brugmansia spp :: Angel trumpet 222 | 1 Gould St | 2 | Front Yard : Yard | Tree | Private 2 | 12 | 6012686.97768 | 2090655.72307 | 37.7212568632884 | -122.398199843161 | (37.7212568632884, -122.398199843161) | 10 | 3 | 8 | 58 | 1 | ||||
30816 | 125733 | DPW Maintained 1 | Brugmansia spp :: Angel trumpet 222 | 400 Vallejo St | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 6 | 6011529.83673 | 2119068.83076 | 37.7992084021962 | -122.404198483998 | (37.7992084021962, -122.404198483998) | 3 | 1 | 10 | 308 | 23 | ||||
31008 | 220745 | DPW Maintained 1 | Brugmansia spp :: Angel trumpet 222 | 846 Shotwell St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6007942.06069 | 2102996.56552 | 37.7548766699288 | -122.415474972491 | (37.7548766699288, -122.415474972491) | 2 | 4 | 7 | 28859 | 19 | |||
34020 | 30748 | DPW Maintained 1 | Brugmansia spp :: Angel trumpet 222 | 2 Ardenwood Way | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Permit Number 34631 | 5991297.28016 | 2096393.91584 | 37.7357978773698 | -122.47255536813 | (37.7357978773698, -122.47255536813) | 1 | 8 | 4 | 29491 | 40 | |||
35538 | 205648 | DPW Maintained 1 | Brugmansia spp :: Angel trumpet 222 | 146 Forest Hill Path | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 8 | Width 3ft | 5994467.18853 | 2101084.43805 | 37.7488598520055 | -122.461935856854 | (37.7488598520055, -122.461935856854) | 1 | 8 | 4 | 29491 | 40 | |||
43336 | 175583 | DPW Maintained 1 | Brugmansia spp :: Angel trumpet 222 | 662 Cayuga Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 13 | Width 10ft | 6001642.89616 | 2093267.53666 | 37.727806960324 | -122.436562875689 | (37.727806960324, -122.436562875689) | 9 | 7 | 6 | 28861 | 25 | |||
43670 | 249850 | DPW Maintained 1 | Brugmansia spp :: Angel trumpet 222 | 285 Greenwich St | 1 | Front Yard : Yard | Tree | Private 2 | 14 | Width 0ft | 6011479.21278 | 2120408.00843 | 37.8028826291885 | -122.404467977534 | (37.8028826291885, -122.404467977534) | 3 | 1 | 10 | 308 | 23 | |||
45392 | 249852 | DPW Maintained 1 | Brugmansia spp :: Angel trumpet 222 | 285 Greenwich St | 3 | Front Yard : Yard | Tree | Private 2 | 7 | Width 0ft | 6011471.43471 | 2120405.60118 | 37.8028755847944 | -122.404494724258 | (37.8028755847944, -122.404494724258) | 3 | 1 | 10 | 308 | 23 | |||
52949 | 125729 | DPW Maintained 1 | Brugmansia spp :: Angel trumpet 222 | 21 Golden Ct | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 8 | Width 5ft | 6008205.85765 | 2116548.73732 | 37.7921025565476 | -122.415522112249 | (37.7921025565476, -122.415522112249) | 5 | 1 | 10 | 28858 | 21 | |||
54515 | 125728 | DPW Maintained 1 | Brugmansia spp :: Angel trumpet 222 | 181 Marina Blvd | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 10 | Width 10ft | 6002661.48423 | 2121606.35825 | 37.8056762634011 | -122.435067578312 | (37.8056762634011, -122.435067578312) | 13 | 9 | 1 | 57 | 17 | |||
54627 | 220741 | DPW Maintained 1 | Brugmansia spp :: Angel trumpet 222 | 100 Webster St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 4ft | 6004286.58651 | 2109133.76252 | 37.771521801725 | -122.428554063022 | (37.771521801725, -122.428554063022) | 7 | 9 | 11 | 28852 | 10 | |||
57557 | 188841 | DPW Maintained 1 | Brugmansia spp :: Angel trumpet 222 | 998 Rhode Island St | 1 | : | Tree | Private 2 | 5 | Width 2ft | 6011857.52585 | 2103846.79049 | 37.7574305017281 | -122.401993886805 | (37.7574305017281, -122.401993886805) | 10 | 3 | 8 | 28856 | 29 | |||
60148 | 220735 | DPW Maintained 1 | Brugmansia spp :: Angel trumpet 222 | 1201 Vermont St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 4ft | 6011463.99571 | 2101889.54449 | 37.7520343634986 | -122.403217200426 | (37.7520343634986, -122.403217200426) | 10 | 4 | 8 | 28859 | 19 | |||
62156 | 220746 | DPW Maintained 1 | Brugmansia spp :: Angel trumpet 222 | 804 Shotwell St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6007928.5496 | 2103189.42303 | 37.755405453309 | -122.415535351195 | (37.755405453309, -122.415535351195) | 2 | 4 | 7 | 28859 | 19 | |||
66061 | 249885 | DPW Maintained 1 | Brugmansia spp :: Angel trumpet 222 | 230 Greenwich St | 21 | Back Yard : Yard | Tree | Private 2 | 9 | Width 0ft | 6011498.61175 | 2120434.8744 | 37.8029574806516 | -122.404402738904 | (37.8029574806516, -122.404402738904) | 3 | 1 | 10 | 28860 | 6 | |||
66729 | 65181 | DPW Maintained 1 | Brugmansia spp :: Angel trumpet 222 | 1354 Green St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/29/1993 12:00:00 AM | 10 | Permit Number 32892 | 6006547.3784 | 2118725.42434 | 37.7979858332305 | -122.42141513132 | (37.7979858332305, -122.42141513132) | 13 | 9 | 10 | 28858 | 32 | |
67465 | 188840 | DPW Maintained 1 | Brugmansia spp :: Angel trumpet 222 | 1301 Minnesota St | 21 | Front Yard : Yard | Tree | Private 2 | 15 | 6015386.40596 | 2102397.08701 | 37.7536462462805 | -122.389688258224 | (37.7536462462805, -122.389688258224) | 10 | 3 | 8 | 28856 | 29 | ||||
68970 | 188844 | DPW Maintained 1 | Brugmansia spp :: Angel trumpet 222 | 1700x Quesada Ave | 30 | Median : Yard | Tree | DPW 1 | 3 | 6014454.09026 | 2095226.47964 | 37.7339055131326 | -122.392410927825 | (37.7339055131326, -122.392410927825) | 10 | 3 | 8 | 58 | 1 | ||||
70511 | 220762 | DPW Maintained 1 | Brugmansia spp :: Angel trumpet 222 | 610 Waller St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 3ft | 6002755.41611 | 2108896.63347 | 37.7707839340556 | -122.433833507015 | (37.7707839340556, -122.433833507015) | 15 | 5 | 11 | 29492 | 9 | |||
73199 | 220749 | DPW Maintained 1 | Brugmansia spp :: Angel trumpet 222 | 4165 23rd St | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 13 | Width 3ft | 6002130.38932 | 2102336.43505 | 37.7527357357851 | -122.435526104843 | (37.7527357357851, -122.435526104843) | 2 | 4 | 5 | 28862 | 22 | |||
74114 | 188845 | DPW Maintained 1 | Brugmansia spp :: Angel trumpet 222 | 1700x Quesada Ave | 33 | Median : Yard | Tree | DPW 1 | 7 | 6014429.47607 | 2095231.95618 | 37.7339191837097 | -122.392496410174 | (37.7339191837097, -122.392496410174) | 10 | 3 | 8 | 58 | 1 | ||||
81608 | 220756 | DPW Maintained 1 | Brugmansia spp :: Angel trumpet 222 | 101 Alpine Ter | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 3ft | 6001697.30135 | 2108238.12942 | 37.7689157445031 | -122.437446377774 | (37.7689157445031, -122.437446377774) | 15 | 5 | 5 | 29492 | 3 | |||
83020 | 220755 | DPW Maintained 1 | Brugmansia spp :: Angel trumpet 222 | 3995 20th St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 11 | Width 3ft | 6003754.16601 | 2104184.80599 | 37.7579030154167 | -122.430042637968 | (37.7579030154167, -122.430042637968) | 2 | 4 | 5 | 28862 | 3 | |||
83385 | 220757 | DPW Maintained 1 | Brugmansia spp :: Angel trumpet 222 | 101 Alpine Ter | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 3ft | 6001698.07523 | 2108250.13972 | 37.7689487658113 | -122.437444561141 | (37.7689487658113, -122.437444561141) | 15 | 5 | 5 | 29492 | 3 | |||
84434 | 249972 | DPW Maintained 1 | Brugmansia spp :: Angel trumpet 222 | 222 Filbert St | 1 | Front Yard : Yard | Tree | Private 2 | 5 | Width 0ft | 6011689.8424 | 2120121.99827 | 37.802109083637 | -122.403718950166 | (37.802109083637, -122.403718950166) | 3 | 1 | 10 | 308 | 23 | |||
88143 | 220754 | DPW Maintained 1 | Brugmansia spp :: Angel trumpet 222 | 4226 20th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6002223.13887 | 2104142.86102 | 37.7577010159989 | -122.435334565439 | (37.7577010159989, -122.435334565439) | 2 | 4 | 5 | 28862 | 3 | |||
88736 | 249964 | DPW Maintained 1 | Brugmansia spp :: Angel trumpet 222 | 265 Filbert St | 1 | Front Yard : Yard | Tree | Private 2 | 5 | Width 0ft | 6011637.77879 | 2120097.34238 | 37.8020384760455 | -122.403897380163 | (37.8020384760455, -122.403897380163) | 3 | 1 | 10 | 308 | 23 | |||
90035 | 175577 | DPW Maintained 1 | Brugmansia spp :: Angel trumpet 222 | 120 Farragut Ave | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | Width 3ft | 5997349.38321 | 2087377.69408 | 37.71138990468 | -122.450981028875 | (37.71138990468, -122.450981028875) | 9 | 7 | 6 | 28861 | 25 | |||
90136 | 220744 | DPW Maintained 1 | Brugmansia spp :: Angel trumpet 222 | 257 Capp St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6007201.29771 | 2105688.21004 | 37.7622256401098 | -122.418227567946 | (37.7622256401098, -122.418227567946) | 8 | 4 | 7 | 28859 | 19 | |||
98324 | 175580 | DPW Maintained 1 | Brugmansia spp :: Angel trumpet 222 | 151 Elliot St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 25 | Width 3ft | 6008987.85777 | 2088562.90463 | 37.7153036804931 | -122.410838966457 | (37.7153036804931, -122.410838966457) | 9 | 7 | 8 | 309 | 39 | |||
101403 | 220760 | DPW Maintained 1 | Brugmansia spp :: Angel trumpet 222 | 66 States St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 8 | Width 3ft | 6001879.64589 | 2106238.56129 | 37.7634357867453 | -122.43667251202 | (37.7634357867453, -122.43667251202) | 15 | 5 | 5 | 28862 | 3 | |||
105752 | 205647 | DPW Maintained 1 | Brugmansia spp :: Angel trumpet 222 | 385 Head St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | Width 6ft | 5993464.36664 | 2088398.33641 | 37.7139691639231 | -122.4644825966 | (37.7139691639231, -122.4644825966) | 9 | 8 | 6 | 64 | 24 | |||
114446 | 220742 | DPW Maintained 1 | Brugmansia spp :: Angel trumpet 222 | 825 Shotwell St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6007983.3878 | 2102896.74599 | 37.7546049110055 | -122.415324985374 | (37.7546049110055, -122.415324985374) | 2 | 4 | 7 | 28859 | 19 | |||
115098 | 220740 | DPW Maintained 1 | Brugmansia spp :: Angel trumpet 222 | 104 Webster St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6004285.19288 | 2109146.5879 | 37.7715569382302 | -122.428559798021 | (37.7715569382302, -122.428559798021) | 7 | 9 | 11 | 28852 | 10 | |||
115410 | 205644 | DPW Maintained 1 | Brugmansia spp :: Angel trumpet 222 | 273 Minerva St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | 5994319.24056 | 2089002.70111 | 37.7156778488284 | -122.461571642214 | (37.7156778488284, -122.461571642214) | 9 | 8 | 6 | 28861 | 24 | ||||
116045 | 205646 | DPW Maintained 1 | Brugmansia spp :: Angel trumpet 222 | 515 Arch St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 10 | Width 10ft | 5992711.01905 | 2090597.79132 | 37.7199648792589 | -122.467246253725 | (37.7199648792589, -122.467246253725) | 9 | 8 | 6 | 64 | 24 | |||
118141 | 125732 | DPW Maintained 1 | Brugmansia spp :: Angel trumpet 222 | 17 Marion Pl | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 7 | 6008332.47629 | 2119429.57357 | 37.8000197363681 | -122.415288034921 | (37.8000197363681, -122.415288034921) | 5 | 1 | 10 | 308 | 32 | ||||
118730 | 125731 | DPW Maintained 1 | Brugmansia spp :: Angel trumpet 222 | 1540 Larkin St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 25 | Width 3ft | 6007145.64127 | 2116497.28043 | 37.791901618321 | -122.419186830724 | (37.791901618321, -122.419186830724) | 5 | 9 | 10 | 28858 | 21 | |||
120802 | 125730 | DPW Maintained 1 | Brugmansia spp :: Angel trumpet 222 | 12 Golden Ct | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 9 | Width 5ft | 6008213.33936 | 2116550.24737 | 37.7921071233077 | -122.415496332316 | (37.7921071233077, -122.415496332316) | 5 | 1 | 10 | 28858 | 21 | |||
121816 | 220747 | DPW Maintained 1 | Brugmansia spp :: Angel trumpet 222 | 804 Shotwell St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6007928.36679 | 2103202.3547 | 37.7554409504533 | -122.41553689892 | (37.7554409504533, -122.41553689892) | 2 | 4 | 7 | 28859 | 19 | |||
124863 | 205643 | DPW Maintained 1 | Brugmansia spp :: Angel trumpet 222 | 36 Harold Ave | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | 5996822.86383 | 2090404.06477 | 37.7196694582459 | -122.453019122844 | (37.7196694582459, -122.453019122844) | 9 | 8 | 6 | 28861 | 24 | ||||
126315 | 175575 | DPW Maintained 1 | Brugmansia spp :: Angel trumpet 222 | 120 Farragut Ave | 5 | Sidewalk: Property side : Yard | Tree | Private 2 | 12 | Width 3ft | 5997380.39092 | 2087342.89408 | 37.7112961269942 | -122.450871351137 | (37.7112961269942, -122.450871351137) | 9 | 7 | 6 | 28861 | 25 | |||
126728 | 205639 | DPW Maintained 1 | Brugmansia spp :: Angel trumpet 222 | 212 Hearst Ave | 6 | Sidewalk: Property side : Yard | Tree | Private 2 | 105 | 5999981.36843 | 2094392.7205 | 37.7308018951744 | -122.442387538165 | (37.7308018951744, -122.442387538165) | 9 | 7 | 4 | 63 | 40 | ||||
127284 | 249951 | DPW Maintained 1 | Brugmansia spp :: Angel trumpet 222 | 303 Filbert St | 4 | Side Yard : Yard | Tree | Private 2 | 15 | Width 0ft | 6011370.22651 | 2120056.34585 | 37.8019109584873 | -122.404820355278 | (37.8019109584873, -122.404820355278) | 3 | 1 | 10 | 308 | 23 | |||
130188 | 220758 | DPW Maintained 1 | Brugmansia spp :: Angel trumpet 222 | 82 Belcher St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6003788.39116 | 2107838.47841 | 37.7679370608715 | -122.43018492512 | (37.7679370608715, -122.43018492512) | 7 | 9 | 5 | 28862 | 3 | |||
130659 | 175582 | DPW Maintained 1 | Brugmansia spp :: Angel trumpet 222 | 263 Flournoy St | 8 | Sidewalk: Curb side : Yard | Tree | Private 2 | 9 | 5993786.39269 | 2086775.26032 | 37.7095311400252 | -122.463251858209 | (37.7095311400252, -122.463251858209) | 9 | 8 | 6 | 28861 | 25 | ||||
134212 | 220761 | DPW Maintained 1 | Brugmansia spp :: Angel trumpet 222 | 610 Waller St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6002768.97838 | 2108899.53778 | 37.7707926781724 | -122.433786802518 | (37.7707926781724, -122.433786802518) | 15 | 5 | 11 | 29492 | 9 | |||
135381 | 220748 | DPW Maintained 1 | Brugmansia spp :: Angel trumpet 222 | 2498 Harrison St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6008830.89382 | 2103969.50732 | 37.757598067002 | -122.41246989777 | (37.757598067002, -122.41246989777) | 2 | 4 | 7 | 28859 | 19 | |||
136158 | 175584 | DPW Maintained 1 | Brugmansia spp :: Angel trumpet 222 | 748 Prague St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6002484.57342 | 2087205.88721 | 37.7112108119054 | -122.433220242236 | (37.7112108119054, -122.433220242236) | 9 | 7 | 6 | 28861 | 5 | |||
142120 | 175581 | DPW Maintained 1 | Brugmansia spp :: Angel trumpet 222 | 251 De Long St | 4 | Sidewalk: Curb side : Yard | Tree | Private 2 | 7 | Width 10ft | 5993749.01127 | 2086801.62677 | 37.7096013824625 | -122.463382965847 | (37.7096013824625, -122.463382965847) | 9 | 8 | 6 | 28861 | 25 | |||
142897 | 175578 | DPW Maintained 1 | Brugmansia spp :: Angel trumpet 222 | 120 Farragut Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 10 | Width 3ft | 5997343.09488 | 2087383.57073 | 37.7114056806055 | -122.451003186346 | (37.7114056806055, -122.451003186346) | 9 | 7 | 6 | 28861 | 25 | |||
142921 | 5368 | DPW Maintained 1 | Brugmansia spp :: Angel trumpet 222 | 254 Dolores St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 3X3 | 6004803.99463 | 2106877.36791 | 37.7653555524466 | -122.42660361788 | (37.7653555524466, -122.42660361788) | 8 | 4 | 5 | 28862 | 3 | |||
143714 | 220738 | DPW Maintained 1 | Brugmansia spp :: Angel trumpet 222 | 400 Prospect Ave | 13 | Sidewalk: Property side : Yard | Tree | Private 2 | 18 | 6006213.31471 | 2097622.37536 | 37.7400230461147 | -122.421071901465 | (37.7400230461147, -122.421071901465) | 2 | 7 | 7 | 28859 | 2 | ||||
154916 | 205645 | DPW Maintained 1 | Brugmansia spp :: Angel trumpet 222 | 263 Byxbee St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 7 | Width 10ft | 5991925.81935 | 2090233.98683 | 37.7189206026904 | -122.469933919041 | (37.7189206026904, -122.469933919041) | 9 | 8 | 6 | 64 | 24 | |||
158229 | 1288 | DPW Maintained 1 | Brugmansia spp :: Angel trumpet 222 | 3958 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3 | 3X3 | 5992343.3701 | 2087389.3259 | 37.7111339792152 | -122.468283788987 | (37.7111339792152, -122.468283788987) | 9 | 8 | 4 | 64 | 24 | |||
159574 | 220736 | DPW Maintained 1 | Brugmansia spp :: Angel trumpet 222 | 1201 Vermont St | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 2 | Width 6ft | 6011468.53951 | 2101932.71337 | 37.7521531495563 | -122.403204523584 | (37.7521531495563, -122.403204523584) | 10 | 4 | 8 | 28859 | 19 | |||
159958 | 113310 | DPW Maintained 1 | Brugmansia spp :: Angel trumpet 222 | 775 Goettingen St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | 3x3 | 6010835.4889 | 2091114.03029 | 37.7224119768082 | -122.404632193744 | (37.7224119768082, -122.404632193744) | 10 | 3 | 7 | 309 | 28 | |||
162483 | 175576 | DPW Maintained 1 | Brugmansia spp :: Angel trumpet 222 | 120 Farragut Ave | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 2 | Width 3ft | 5997371.29877 | 2087352.65931 | 37.7113224195784 | -122.450903479432 | (37.7113224195784, -122.450903479432) | 9 | 7 | 6 | 28861 | 25 | |||
168717 | 220743 | DPW Maintained 1 | Brugmansia spp :: Angel trumpet 222 | 825 Shotwell St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6007978.00547 | 2102998.07168 | 37.7548828258062 | -122.415350771647 | (37.7548828258062, -122.415350771647) | 2 | 4 | 7 | 28859 | 19 | |||
168992 | 220751 | DPW Maintained 1 | Brugmansia spp :: Angel trumpet 222 | 121 Montcalm St | 5 | Sidewalk: Property side : Yard | Tree | Private 2 | 7 | Width 3ft | 6010324.2816 | 2099838.28761 | 37.7463383463405 | -122.407013950129 | (37.7463383463405, -122.407013950129) | 2 | 7 | 7 | 28859 | 2 | |||
169997 | 220752 | DPW Maintained 1 | Brugmansia spp :: Angel trumpet 222 | 3348 18th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6007230.49026 | 2105595.25986 | 37.7619720636839 | -122.418120011743 | (37.7619720636839, -122.418120011743) | 8 | 4 | 7 | 28859 | 19 | |||
171240 | 249978 | DPW Maintained 1 | Brugmansia spp :: Angel trumpet 222 | 13 Napier Ln | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 13 | Width 0ft | 6011650.66928 | 2120187.96882 | 37.8022880343123 | -122.403859153579 | (37.8022880343123, -122.403859153579) | 3 | 1 | 10 | 308 | 23 | |||
173226 | 205641 | DPW Maintained 1 | Brugmansia spp :: Angel trumpet 222 | 1209 Capitol Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 8 | Width 3ft | 5995031.09016 | 2091955.72067 | 37.7238270861355 | -122.459324908228 | (37.7238270861355, -122.459324908228) | 9 | 8 | 4 | 28861 | 24 | |||
173551 | 188843 | DPW Maintained 1 | Brugmansia spp :: Angel trumpet 222 | 1689 Jerrold Ave | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | Width 1ft | 6014878.74219 | 2097300.92271 | 37.7396250817437 | -122.391087711252 | (37.7396250817437, -122.391087711252) | 10 | 3 | 8 | 58 | 1 | |||
173957 | 220750 | DPW Maintained 1 | Brugmansia spp :: Angel trumpet 222 | 3910 22nd St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 7 | Width 2ft | 6002358.12438 | 2102989.67324 | 37.7545423038021 | -122.434785266739 | (37.7545423038021, -122.434785266739) | 2 | 4 | 5 | 28862 | 22 | |||
175011 | 249884 | DPW Maintained 1 | Brugmansia spp :: Angel trumpet 222 | 230 Greenwich St | 20 | Back Yard : Yard | Tree | Private 2 | 5 | Width 0ft | 6011503.3679 | 2120436.48798 | 37.8029621769312 | -122.404386393712 | (37.8029621769312, -122.404386393712) | 3 | 1 | 10 | 28860 | 6 | |||
175725 | 175573 | DPW Maintained 1 | Brugmansia spp :: Angel trumpet 222 | 256 Taber Pl | 1 | : | Tree | Private 2 | 17 | Width 3ft | 6009978.06824 | 2086136.62452 | 37.7086970817661 | -122.407245413169 | (37.7086970817661, -122.407245413169) | 9 | 7 | 8 | 309 | 39 | |||
180242 | 249955 | DPW Maintained 1 | Brugmansia spp :: Angel trumpet 222 | 285 Filbert St | 1 | Side Yard : Yard | Tree | Private 2 | 6 | Width 0ft | 6011505.97031 | 2120064.83328 | 37.801941849301 | -122.404351213161 | (37.801941849301, -122.404351213161) | 3 | 1 | 10 | 308 | 23 | |||
185302 | 218300 | DPW Maintained 1 | Brugmansia spp :: Angel trumpet 222 | 1 Ardenwood Way | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 5 | Width 8ft | 5991308.14967 | 2096394.11086 | 37.7357990419939 | -122.472517802556 | (37.7357990419939, -122.472517802556) | 1 | 8 | 4 | 29491 | 40 | |||
186550 | 175579 | DPW Maintained 1 | Brugmansia spp :: Angel trumpet 222 | 608 Naples St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6002720.20714 | 2090077.47401 | 37.7191089225303 | -122.432610821153 | (37.7191089225303, -122.432610821153) | 9 | 7 | 6 | 28861 | 5 | |||
187599 | 220734 | DPW Maintained 1 | Brugmansia spp :: Angel trumpet 222 | 180 Elsie St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 12 | Width 3ft | 6006948.49697 | 2098161.80121 | 37.741545605554 | -122.418568179892 | (37.741545605554, -122.418568179892) | 2 | 7 | 7 | 28859 | 2 | |||
187858 | 175574 | DPW Maintained 1 | Brugmansia spp :: Angel trumpet 222 | 262 Taber Pl | 1 | : | Tree | Private 2 | 16 | Width 3ft | 6009969.12927 | 2086111.41129 | 37.7086273510358 | -122.407274531388 | (37.7086273510358, -122.407274531388) | 9 | 7 | 8 | 309 | 39 | |||
190139 | 125734 | DPW Maintained 1 | Brugmansia spp :: Angel trumpet 222 | 420 Vallejo St | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 5 | 6011455.71965 | 2119041.25304 | 37.799128538798 | -122.404453013718 | (37.799128538798, -122.404453013718) | 3 | 1 | 10 | 308 | 23 | ||||
191104 | 220737 | DPW Maintained 1 | Brugmansia spp :: Angel trumpet 222 | 98 Crescent Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 12 | Width 2ft | 6005788.78972 | 2095836.973 | 37.7350967901794 | -122.422412909327 | (37.7350967901794, -122.422412909327) | 2 | 7 | 7 | 28859 | 2 | |||
191787 | 249886 | DPW Maintained 1 | Brugmansia spp :: Angel trumpet 222 | 230 Greenwich St | 22 | Back Yard : Yard | Tree | Private 2 | 10 | Width 0ft | 6011494.30214 | 2120434.10693 | 37.8029551325349 | -122.404417598416 | (37.8029551325349, -122.404417598416) | 3 | 1 | 10 | 28860 | 6 | |||
191959 | 220759 | DPW Maintained 1 | Brugmansia spp :: Angel trumpet 222 | 18 Roosevelt Way | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6001662.90861 | 2107443.94917 | 37.7667331663349 | -122.437508459743 | (37.7667331663349, -122.437508459743) | 15 | 5 | 5 | 28862 | 3 |
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) );