Data source: data.sfgov.org
This data as json, CSV (advanced)
Link | rowid ▼ | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
24286 | 24286 | 249978 | Undocumented 2 | Brugmansia spp :: Angel trumpet 137 | 13 Napier Ln | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 13 | Width 0ft | 6011650.66928 | 2120187.96882 | 37.8022880343123 | -122.403859153579 | (37.8022880343123, -122.403859153579) | |||
24993 | 24993 | 205648 | Undocumented 2 | Brugmansia spp :: Angel trumpet 137 | 146 Forest Hill Path | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 8 | Width 3ft | 5994467.18853 | 2101084.43805 | 37.7488598520055 | -122.461935856854 | (37.7488598520055, -122.461935856854) | |||
26819 | 26819 | 202073 | Undocumented 2 | Brugmansia spp :: Angel trumpet 137 | 1 Gould St | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 12 | 6012686.9776800005 | 2090655.72307 | 37.721256863288396 | -122.398199843161 | (37.7212568632884, -122.398199843161) | ||||
29325 | 29325 | 220762 | Undocumented 2 | Brugmansia spp :: Angel trumpet 137 | 610 Waller St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 3ft | 6002755.41611 | 2108896.6334700002 | 37.7707839340556 | -122.433833507015 | (37.7707839340556, -122.433833507015) | |||
29424 | 29424 | 175583 | Undocumented 2 | Brugmansia spp :: Angel trumpet 137 | 662 Cayuga Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 13 | Width 10ft | 6001642.89616 | 2093267.5366599998 | 37.727806960324 | -122.43656287568899 | (37.727806960324, -122.436562875689) | |||
30719 | 30719 | 249951 | Undocumented 2 | Brugmansia spp :: Angel trumpet 137 | 303 Filbert St | 4 | Side Yard : Yard 17 | Tree 1 | Private 1 | 15 | Width 0ft | 6011370.2265099995 | 2120056.34585 | 37.8019109584873 | -122.40482035527799 | (37.8019109584873, -122.404820355278) | |||
31705 | 31705 | 249964 | Undocumented 2 | Brugmansia spp :: Angel trumpet 137 | 265 Filbert St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 5 | Width 0ft | 6011637.77879 | 2120097.34238 | 37.802038476045496 | -122.403897380163 | (37.8020384760455, -122.403897380163) | |||
35929 | 35929 | 220744 | Undocumented 2 | Brugmansia spp :: Angel trumpet 137 | 257 Capp St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6007201.29771 | 2105688.2100400003 | 37.7622256401098 | -122.41822756794599 | (37.7622256401098, -122.418227567946) | |||
36357 | 36357 | 188842 | Undocumented 2 | Brugmansia spp :: Angel trumpet 137 | 1689 Jerrold Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 1ft | 6014873.05165 | 2097305.05057 | 37.739636100214895 | -122.391107675301 | (37.7396361002149, -122.391107675301) | |||
38197 | 38197 | 218300 | Undocumented 2 | Brugmansia spp :: Angel trumpet 137 | 1 Ardenwood Way | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | Width 8ft | 5991308.149669999 | 2096394.11086 | 37.7357990419939 | -122.472517802556 | (37.7357990419939, -122.472517802556) | |||
39571 | 39571 | 175574 | Undocumented 2 | Brugmansia spp :: Angel trumpet 137 | 262 Taber Pl | 1 | : 4 | Tree 1 | Private 1 | 16 | Width 3ft | 6009969.129269999 | 2086111.4112900002 | 37.708627351035794 | -122.407274531388 | (37.7086273510358, -122.407274531388) | |||
40076 | 40076 | 125730 | Undocumented 2 | Brugmansia spp :: Angel trumpet 137 | 12 Golden Ct | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 9 | Width 5ft | 6008213.33936 | 2116550.24737 | 37.7921071233077 | -122.415496332316 | (37.7921071233077, -122.415496332316) | |||
40318 | 40318 | 249851 | Undocumented 2 | Brugmansia spp :: Angel trumpet 137 | 285 Greenwich St | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 6 | Width 0ft | 6011475.66665 | 2120406.51075 | 37.8028783187521 | -122.40448014355101 | (37.8028783187521, -122.404480143551) | |||
40694 | 40694 | 220758 | Undocumented 2 | Brugmansia spp :: Angel trumpet 137 | 82 Belcher St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6003788.39116 | 2107838.47841 | 37.7679370608715 | -122.43018492511999 | (37.7679370608715, -122.43018492512) | |||
41225 | 41225 | 175584 | Undocumented 2 | Brugmansia spp :: Angel trumpet 137 | 748 Prague St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6002484.573419999 | 2087205.8872099998 | 37.711210811905396 | -122.433220242236 | (37.7112108119054, -122.433220242236) | |||
41473 | 41473 | 220751 | Undocumented 2 | Brugmansia spp :: Angel trumpet 137 | 121 Montcalm St | 5 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | Width 3ft | 6010324.2816 | 2099838.28761 | 37.7463383463405 | -122.407013950129 | (37.7463383463405, -122.407013950129) | |||
41718 | 41718 | 220739 | Undocumented 2 | Brugmansia spp :: Angel trumpet 137 | 112 San Carlos St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6006641.651869999 | 2105417.60595 | 37.761451107091396 | -122.420143969269 | (37.7614511070914, -122.420143969269) | |||
42111 | 42111 | 249852 | Undocumented 2 | Brugmansia spp :: Angel trumpet 137 | 285 Greenwich St | 3 | Front Yard : Yard 7 | Tree 1 | Private 1 | 7 | Width 0ft | 6011471.43471 | 2120405.6011799998 | 37.8028755847944 | -122.404494724258 | (37.8028755847944, -122.404494724258) | |||
43738 | 43738 | 188843 | Undocumented 2 | Brugmansia spp :: Angel trumpet 137 | 1689 Jerrold Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 1ft | 6014878.742190001 | 2097300.92271 | 37.739625081743704 | -122.391087711252 | (37.7396250817437, -122.391087711252) | |||
43804 | 43804 | 175578 | Undocumented 2 | Brugmansia spp :: Angel trumpet 137 | 120 Farragut Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 10 | Width 3ft | 5997343.094880001 | 2087383.57073 | 37.7114056806055 | -122.451003186346 | (37.7114056806055, -122.451003186346) | |||
45614 | 45614 | 220743 | Undocumented 2 | Brugmansia spp :: Angel trumpet 137 | 825 Shotwell St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6007978.005469999 | 2102998.07168 | 37.754882825806206 | -122.415350771647 | (37.7548828258062, -122.415350771647) | |||
48780 | 48780 | 220750 | Undocumented 2 | Brugmansia spp :: Angel trumpet 137 | 3910 22nd St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | Width 2ft | 6002358.12438 | 2102989.6732400004 | 37.7545423038021 | -122.43478526673901 | (37.7545423038021, -122.434785266739) | |||
50438 | 50438 | 205639 | Undocumented 2 | Brugmansia spp :: Angel trumpet 137 | 212 Hearst Ave | 6 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 105 | 5999981.368430001 | 2094392.7205 | 37.7308018951744 | -122.442387538165 | (37.7308018951744, -122.442387538165) | ||||
54204 | 54204 | 175575 | Undocumented 2 | Brugmansia spp :: Angel trumpet 137 | 120 Farragut Ave | 5 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 12 | Width 3ft | 5997380.39092 | 2087342.89408 | 37.711296126994206 | -122.45087135113701 | (37.7112961269942, -122.450871351137) | |||
57354 | 57354 | 205640 | Undocumented 2 | Brugmansia spp :: Angel trumpet 137 | 1215 Capitol Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 3ft | 5995031.70006 | 2092006.18046 | 37.7239656716754 | -122.459326452373 | (37.7239656716754, -122.459326452373) | |||
60638 | 60638 | 72777 | Undocumented 2 | Brugmansia spp :: Angel trumpet 137 | 545 Lisbon St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/14/1998 12:00:00 AM | 2 | 6001963.48566 | 2090308.61683 | 37.7197006458587 | -122.43524303694099 | (37.7197006458587, -122.435243036941) | ||
61165 | 61165 | 205645 | Undocumented 2 | Brugmansia spp :: Angel trumpet 137 | 263 Byxbee St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | Width 10ft | 5991925.81935 | 2090233.9868299998 | 37.718920602690396 | -122.469933919041 | (37.7189206026904, -122.469933919041) | |||
62781 | 62781 | 249850 | Undocumented 2 | Brugmansia spp :: Angel trumpet 137 | 285 Greenwich St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 14 | Width 0ft | 6011479.212780001 | 2120408.00843 | 37.8028826291885 | -122.40446797753401 | (37.8028826291885, -122.404467977534) | |||
63765 | 63765 | 205647 | Undocumented 2 | Brugmansia spp :: Angel trumpet 137 | 385 Head St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 6ft | 5993464.366640001 | 2088398.3364099998 | 37.7139691639231 | -122.46448259659999 | (37.7139691639231, -122.4644825966) | |||
63924 | 63924 | 220746 | Undocumented 2 | Brugmansia spp :: Angel trumpet 137 | 804 Shotwell St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6007928.5496 | 2103189.4230299997 | 37.755405453309 | -122.41553535119499 | (37.755405453309, -122.415535351195) | |||
64443 | 64443 | 175577 | Undocumented 2 | Brugmansia spp :: Angel trumpet 137 | 120 Farragut Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 3ft | 5997349.38321 | 2087377.6940799998 | 37.71138990468 | -122.450981028875 | (37.71138990468, -122.450981028875) | |||
65085 | 65085 | 220745 | Undocumented 2 | Brugmansia spp :: Angel trumpet 137 | 846 Shotwell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6007942.06069 | 2102996.56552 | 37.7548766699288 | -122.415474972491 | (37.7548766699288, -122.415474972491) | |||
69051 | 69051 | 220742 | Undocumented 2 | Brugmansia spp :: Angel trumpet 137 | 825 Shotwell St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6007983.3878 | 2102896.74599 | 37.7546049110055 | -122.415324985374 | (37.7546049110055, -122.415324985374) | |||
69587 | 69587 | 175572 | Undocumented 2 | Brugmansia spp :: Angel trumpet 137 | 1785 Cayuga Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 1ft | 5997902.91361 | 2088443.5284099998 | 37.7143481157506 | -122.449144629432 | (37.7143481157506, -122.449144629432) | |||
71628 | 71628 | 220734 | Undocumented 2 | Brugmansia spp :: Angel trumpet 137 | 180 Elsie St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 12 | Width 3ft | 6006948.49697 | 2098161.8012099997 | 37.741545605554 | -122.418568179892 | (37.741545605554, -122.418568179892) | |||
72103 | 72103 | 205646 | Undocumented 2 | Brugmansia spp :: Angel trumpet 137 | 515 Arch St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 10 | Width 10ft | 5992711.01905 | 2090597.79132 | 37.7199648792589 | -122.467246253725 | (37.7199648792589, -122.467246253725) | |||
72397 | 72397 | 205644 | Undocumented 2 | Brugmansia spp :: Angel trumpet 137 | 273 Minerva St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | 5994319.24056 | 2089002.7011099998 | 37.7156778488284 | -122.461571642214 | (37.7156778488284, -122.461571642214) | ||||
74183 | 74183 | 220747 | Undocumented 2 | Brugmansia spp :: Angel trumpet 137 | 804 Shotwell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6007928.36679 | 2103202.3547 | 37.7554409504533 | -122.41553689892 | (37.7554409504533, -122.41553689892) | |||
129596 | 129596 | 220736 | Undocumented 2 | Brugmansia spp :: Angel trumpet 137 | 1201 Vermont St | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 2 | Width 6ft | 6011468.53951 | 2101932.71337 | 37.7521531495563 | -122.40320452358401 | (37.7521531495563, -122.403204523584) | |||
133072 | 133072 | 249886 | Undocumented 2 | Brugmansia spp :: Angel trumpet 137 | 230 Greenwich St | 22 | Back Yard : Yard 13 | Tree 1 | Private 1 | 10 | Width 0ft | 6011494.30214 | 2120434.10693 | 37.8029551325349 | -122.404417598416 | (37.8029551325349, -122.404417598416) | |||
134667 | 134667 | 220737 | Undocumented 2 | Brugmansia spp :: Angel trumpet 137 | 98 Crescent Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 12 | Width 2ft | 6005788.78972 | 2095836.9730000002 | 37.7350967901794 | -122.422412909327 | (37.7350967901794, -122.422412909327) | |||
134941 | 134941 | 188840 | Undocumented 2 | Brugmansia spp :: Angel trumpet 137 | 1301 Minnesota St | 21 | Front Yard : Yard 7 | Tree 1 | Private 1 | 15 | 6015386.40596 | 2102397.08701 | 37.753646246280496 | -122.389688258224 | (37.7536462462805, -122.389688258224) | ||||
135131 | 135131 | 125734 | Undocumented 2 | Brugmansia spp :: Angel trumpet 137 | 420 Vallejo St | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | 6011455.71965 | 2119041.2530400003 | 37.799128538798 | -122.404453013718 | (37.799128538798, -122.404453013718) | ||||
136160 | 136160 | 220749 | Undocumented 2 | Brugmansia spp :: Angel trumpet 137 | 4165 23rd St | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 13 | Width 3ft | 6002130.38932 | 2102336.43505 | 37.7527357357851 | -122.435526104843 | (37.7527357357851, -122.435526104843) | |||
136563 | 136563 | 220754 | Undocumented 2 | Brugmansia spp :: Angel trumpet 137 | 4226 20th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6002223.13887 | 2104142.86102 | 37.7577010159989 | -122.43533456543899 | (37.7577010159989, -122.435334565439) | |||
136820 | 136820 | 205642 | Undocumented 2 | Brugmansia spp :: Angel trumpet 137 | 1209 Capitol Ave | 5 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 3ft | 5995030.50949 | 2091927.98963 | 37.7237509099679 | -122.459324908227 | (37.7237509099679, -122.459324908227) | |||
138164 | 138164 | 220752 | Undocumented 2 | Brugmansia spp :: Angel trumpet 137 | 3348 18th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6007230.490259999 | 2105595.2598599996 | 37.7619720636839 | -122.41812001174299 | (37.7619720636839, -122.418120011743) | |||
149818 | 149818 | 175582 | Undocumented 2 | Brugmansia spp :: Angel trumpet 137 | 263 Flournoy St | 8 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 9 | 5993786.39269 | 2086775.2603200001 | 37.7095311400252 | -122.463251858209 | (37.7095311400252, -122.463251858209) | ||||
152498 | 152498 | 220735 | Undocumented 2 | Brugmansia spp :: Angel trumpet 137 | 1201 Vermont St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 4ft | 6011463.995709999 | 2101889.5444900002 | 37.7520343634986 | -122.40321720042601 | (37.7520343634986, -122.403217200426) | |||
152623 | 152623 | 175580 | Undocumented 2 | Brugmansia spp :: Angel trumpet 137 | 151 Elliot St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 25 | Width 3ft | 6008987.85777 | 2088562.90463 | 37.7153036804931 | -122.410838966457 | (37.7153036804931, -122.410838966457) | |||
157417 | 157417 | 175573 | Undocumented 2 | Brugmansia spp :: Angel trumpet 137 | 256 Taber Pl | 1 | : 4 | Tree 1 | Private 1 | 17 | Width 3ft | 6009978.06824 | 2086136.62452 | 37.7086970817661 | -122.40724541316901 | (37.7086970817661, -122.407245413169) | |||
157825 | 157825 | 125731 | Undocumented 2 | Brugmansia spp :: Angel trumpet 137 | 1590 Larkin St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 25 | Width 3ft | 6007145.64127 | 2116497.28043 | 37.791901618321 | -122.41918683072399 | (37.791901618321, -122.419186830724) | |||
159059 | 159059 | 220759 | Undocumented 2 | Brugmansia spp :: Angel trumpet 137 | 18 Roosevelt Way | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6001662.90861 | 2107443.94917 | 37.766733166334895 | -122.437508459743 | (37.7667331663349, -122.437508459743) | |||
164235 | 164235 | 220756 | Undocumented 2 | Brugmansia spp :: Angel trumpet 137 | 101 Alpine Ter | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 3ft | 6001697.30135 | 2108238.12942 | 37.768915744503104 | -122.437446377774 | (37.7689157445031, -122.437446377774) | |||
166977 | 166977 | 220738 | Undocumented 2 | Brugmansia spp :: Angel trumpet 137 | 400 Prospect Ave | 13 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 18 | 6006213.31471 | 2097622.37536 | 37.7400230461147 | -122.421071901465 | (37.7400230461147, -122.421071901465) | ||||
167969 | 167969 | 220741 | Undocumented 2 | Brugmansia spp :: Angel trumpet 137 | 100 Webster St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 4ft | 6004286.58651 | 2109133.76252 | 37.771521801725 | -122.428554063022 | (37.771521801725, -122.428554063022) | |||
169252 | 169252 | 125733 | Undocumented 2 | Brugmansia spp :: Angel trumpet 137 | 400 Vallejo St | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 6 | 6011529.836730001 | 2119068.83076 | 37.7992084021962 | -122.40419848399799 | (37.7992084021962, -122.404198483998) | ||||
169459 | 169459 | 249955 | Undocumented 2 | Brugmansia spp :: Angel trumpet 137 | 285 Filbert St | 1 | Side Yard : Yard 17 | Tree 1 | Private 1 | 6 | Width 0ft | 6011505.97031 | 2120064.83328 | 37.801941849301 | -122.404351213161 | (37.801941849301, -122.404351213161) | |||
171499 | 171499 | 249885 | Undocumented 2 | Brugmansia spp :: Angel trumpet 137 | 230 Greenwich St | 21 | Back Yard : Yard 13 | Tree 1 | Private 1 | 9 | Width 0ft | 6011498.61175 | 2120434.8744 | 37.8029574806516 | -122.404402738904 | (37.8029574806516, -122.404402738904) | |||
171621 | 171621 | 175576 | Undocumented 2 | Brugmansia spp :: Angel trumpet 137 | 120 Farragut Ave | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 2 | Width 3ft | 5997371.298769999 | 2087352.6593099998 | 37.7113224195784 | -122.45090347943199 | (37.7113224195784, -122.450903479432) | |||
171755 | 171755 | 220757 | Undocumented 2 | Brugmansia spp :: Angel trumpet 137 | 101 Alpine Ter | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 3ft | 6001698.075230001 | 2108250.13972 | 37.768948765811295 | -122.43744456114099 | (37.7689487658113, -122.437444561141) | |||
173534 | 173534 | 249884 | Undocumented 2 | Brugmansia spp :: Angel trumpet 137 | 230 Greenwich St | 20 | Back Yard : Yard 13 | Tree 1 | Private 1 | 5 | Width 0ft | 6011503.3679 | 2120436.4879799997 | 37.8029621769312 | -122.404386393712 | (37.8029621769312, -122.404386393712) | |||
173769 | 173769 | 175581 | Undocumented 2 | Brugmansia spp :: Angel trumpet 137 | 251 De Long St | 4 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 7 | Width 10ft | 5993749.01127 | 2086801.62677 | 37.7096013824625 | -122.46338296584699 | (37.7096013824625, -122.463382965847) | |||
173888 | 173888 | 188846 | Undocumented 2 | Brugmansia spp :: Angel trumpet 137 | 65 Langton St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 2ft | 6009957.95402 | 2110976.93617 | 37.776902044424205 | -122.409066486348 | (37.7769020444242, -122.409066486348) | |||
174693 | 174693 | 205643 | Undocumented 2 | Brugmansia spp :: Angel trumpet 137 | 36 Harold Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | 5996822.86383 | 2090404.06477 | 37.719669458245896 | -122.45301912284401 | (37.7196694582459, -122.453019122844) | ||||
175155 | 175155 | 220740 | Undocumented 2 | Brugmansia spp :: Angel trumpet 137 | 104 Webster St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6004285.19288 | 2109146.5879 | 37.771556938230205 | -122.428559798021 | (37.7715569382302, -122.428559798021) | |||
175169 | 175169 | 249972 | Undocumented 2 | Brugmansia spp :: Angel trumpet 137 | 222 Filbert St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 5 | Width 0ft | 6011689.8424 | 2120121.99827 | 37.802109083637 | -122.403718950166 | (37.802109083637, -122.403718950166) | |||
176207 | 176207 | 125728 | Undocumented 2 | Brugmansia spp :: Angel trumpet 137 | 181 Marina Blvd | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 10 | Width 10ft | 6002661.4842300005 | 2121606.35825 | 37.805676263401104 | -122.435067578312 | (37.8056762634011, -122.435067578312) | |||
176250 | 176250 | 205641 | Undocumented 2 | Brugmansia spp :: Angel trumpet 137 | 1209 Capitol Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | Width 3ft | 5995031.09016 | 2091955.7206700002 | 37.7238270861355 | -122.459324908228 | (37.7238270861355, -122.459324908228) | |||
176360 | 176360 | 220753 | Undocumented 2 | Brugmansia spp :: Angel trumpet 137 | 178 Hancock St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6003125.888730001 | 2105073.90703 | 37.7603086713261 | -122.43227898028499 | (37.7603086713261, -122.432278980285) | |||
177677 | 177677 | 220748 | Undocumented 2 | Brugmansia spp :: Angel trumpet 137 | 2498 Harrison St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6008830.89382 | 2103969.50732 | 37.757598067002 | -122.41246989777001 | (37.757598067002, -122.41246989777) | |||
179356 | 179356 | 188841 | Undocumented 2 | Brugmansia spp :: Angel trumpet 137 | 998 Rhode Island St | 1 | : 4 | Tree 1 | Private 1 | 5 | Width 2ft | 6011857.52585 | 2103846.79049 | 37.7574305017281 | -122.401993886805 | (37.7574305017281, -122.401993886805) | |||
180703 | 180703 | 220755 | Undocumented 2 | Brugmansia spp :: Angel trumpet 137 | 3995 20th St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 11 | Width 3ft | 6003754.16601 | 2104184.8059900003 | 37.7579030154167 | -122.430042637968 | (37.7579030154167, -122.430042637968) | |||
182957 | 182957 | 125732 | Undocumented 2 | Brugmansia spp :: Angel trumpet 137 | 17 Marion Pl | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | 6008332.476290001 | 2119429.57357 | 37.8000197363681 | -122.41528803492099 | (37.8000197363681, -122.415288034921) | ||||
183508 | 183508 | 220760 | Undocumented 2 | Brugmansia spp :: Angel trumpet 137 | 66 States St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | Width 3ft | 6001879.64589 | 2106238.56129 | 37.7634357867453 | -122.43667251202 | (37.7634357867453, -122.43667251202) | |||
184330 | 184330 | 125729 | Undocumented 2 | Brugmansia spp :: Angel trumpet 137 | 21 Golden Ct | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | Width 5ft | 6008205.85765 | 2116548.7373200003 | 37.792102556547604 | -122.415522112249 | (37.7921025565476, -122.415522112249) | |||
185025 | 185025 | 113310 | Undocumented 2 | Brugmansia spp :: Angel trumpet 137 | 775 Goettingen St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | 3x3 | 6010835.4889 | 2091114.0302900001 | 37.7224119768082 | -122.40463219374399 | (37.7224119768082, -122.404632193744) | |||
186539 | 186539 | 175579 | Undocumented 2 | Brugmansia spp :: Angel trumpet 137 | 608 Naples St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6002720.207140001 | 2090077.4740099998 | 37.719108922530296 | -122.43261082115299 | (37.7191089225303, -122.432610821153) | |||
188199 | 188199 | 220761 | Undocumented 2 | Brugmansia spp :: Angel trumpet 137 | 610 Waller St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6002768.97838 | 2108899.53778 | 37.7707926781724 | -122.433786802518 | (37.7707926781724, -122.433786802518) |
JSON shape: default, array, newline-delimited
CREATE TABLE "Street_Tree_List" ( "TreeID" INTEGER, "qLegalStatus" INTEGER, "qSpecies" INTEGER, "qAddress" TEXT, "SiteOrder" INTEGER, "qSiteInfo" INTEGER, "PlantType" INTEGER, "qCaretaker" INTEGER, "qCareAssistant" INTEGER, "PlantDate" TEXT, "DBH" INTEGER, "PlotSize" TEXT, "PermitNotes" TEXT, "XCoord" REAL, "YCoord" REAL, "Latitude" REAL, "Longitude" REAL, "Location" TEXT , FOREIGN KEY ("PlantType") REFERENCES [PlantType](id), FOREIGN KEY ("qCaretaker") REFERENCES [qCaretaker](id), FOREIGN KEY ("qSpecies") REFERENCES [qSpecies](id), FOREIGN KEY ("qSiteInfo") REFERENCES [qSiteInfo](id), FOREIGN KEY ("qCareAssistant") REFERENCES [qCareAssistant](id), FOREIGN KEY ("qLegalStatus") REFERENCES [qLegalStatus](id)); CREATE INDEX ["Street_Tree_List_PlantType"] ON [Street_Tree_List]("PlantType"); CREATE INDEX ["Street_Tree_List_qCaretaker"] ON [Street_Tree_List]("qCaretaker"); CREATE INDEX ["Street_Tree_List_qSpecies"] ON [Street_Tree_List]("qSpecies"); CREATE INDEX ["Street_Tree_List_qSiteInfo"] ON [Street_Tree_List]("qSiteInfo"); CREATE INDEX ["Street_Tree_List_qCareAssistant"] ON [Street_Tree_List]("qCareAssistant"); CREATE INDEX ["Street_Tree_List_qLegalStatus"] ON [Street_Tree_List]("qLegalStatus");