Street_Tree_List

Data source: data.sfgov.org

79 rows where qLegalStatus = 2 and qSpecies = 137

View and edit SQL

Link rowid ▼ TreeID qLegalStatus qSpecies qAddress SiteOrder qSiteInfo PlantType qCaretaker qCareAssistant PlantDate DBH PlotSize PermitNotes XCoord YCoord Latitude Longitude Location
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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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)

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

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");
Powered by Datasette · Query took 2905.997ms · Data source: data.sfgov.org