Street_Tree_List

Data source: data.sfgov.org

79 rows where qSpecies = 273

View and edit SQL

Suggested facets: qLegalStatus, SiteOrder, qSiteInfo, qCaretaker, DBH, PlotSize

Link rowid ▼ TreeID qLegalStatus qSpecies qAddress SiteOrder qSiteInfo PlantType qCaretaker qCareAssistant PlantDate DBH PlotSize PermitNotes XCoord YCoord Latitude Longitude Location
12271 96127 Undocumented 2 Acer saccharinum :: Silver Maple 273 690 Brussels St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     12 3x3   6010963.14122 2091553.23267 37.7236250696118 -122.404221823196 (37.7236250696118, -122.404221823196)
12773 251 Permitted Site 1 Acer saccharinum :: Silver Maple 273 3063 19th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     30 2   5990548.37754 2094874.7295400002 37.7315832009825 -122.47503372794701 (37.7315832009825, -122.475033727947)
16997 5102 Permitted Site 1 Acer saccharinum :: Silver Maple 273 2629 Diamond St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   06/29/2007 12:00:00 AM 3 3x3   6002333.77794 2096391.6401900002 37.7364242713534 -122.434397755159 (37.7364242713534, -122.434397755159)
20589 566 DPW Maintained 3 Acer saccharinum :: Silver Maple 273 2958 24th St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   07/30/2015 12:00:00 AM 18 3x3   6009133.99064 2102185.59813 37.7527168590152 -122.41129564398199 (37.7527168590152, -122.411295643982)
23701 203433 Undocumented 2 Acer saccharinum :: Silver Maple 273 15 Hearst Ave 6 Sidewalk: Property side : Yard 9 Tree 1 Private 1     10 Width 10ft   6000916.87895 2094326.94897 37.730674579052796 -122.439148624412 (37.7306745790528, -122.439148624412)
23786 97361 DPW Maintained 3 Acer saccharinum :: Silver Maple 273 1351X Broadway 2 Median : Cutout 11 Tree 1 DPW 2     4     6007149.6499 2118062.64447 37.7961999442141 -122.41928405373999 (37.7961999442141, -122.41928405374)
25080 203432 Undocumented 2 Acer saccharinum :: Silver Maple 273 15 Hearst Ave 5 Sidewalk: Property side : Yard 9 Tree 1 Private 1     14 Width 10ft   6000908.66994 2094326.57474 37.730673084387604 -122.439176977342 (37.7306730843876, -122.439176977342)
26450 220510 Undocumented 2 Acer saccharinum :: Silver Maple 273 850 Valencia St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     6 Width 3ft   6006244.58931 2104615.56079 37.7592264982188 -122.421460284477 (37.7592264982188, -122.421460284477)
28086 97371 DPW Maintained 3 Acer saccharinum :: Silver Maple 273 1351X Broadway 7 Median : Cutout 11 Tree 1 DPW 2     4     6007032.43934 2118047.0408099997 37.796150498593995 -122.419688519305 (37.796150498594, -122.419688519305)
30236 97380 DPW Maintained 3 Acer saccharinum :: Silver Maple 273 1401X Broadway 5 Median : Cutout 11 Tree 1 DPW 2     3     6006631.8373300005 2118013.16955 37.7960349222286 -122.421072279161 (37.7960349222286, -122.421072279161)
31458 220522 Undocumented 2 Acer saccharinum :: Silver Maple 273 253 Sanchez St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     16 Width 3ft   6003573.679769999 2106813.02685 37.765109255999704 -122.43085439661002 (37.7651092559997, -122.43085439661)
31707 220506 Undocumented 2 Acer saccharinum :: Silver Maple 273 392 Franconia St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     5 Width 2ft   6009942.5587 2098860.14349 37.7436312080086 -122.408264931397 (37.7436312080086, -122.408264931397)
32263 203428 Undocumented 2 Acer saccharinum :: Silver Maple 273 15 Hearst Ave 1 Sidewalk: Property side : Yard 9 Tree 1 Private 1     20 Width 10ft   6000870.12955 2094326.8287900002 37.7306715888014 -122.439310235275 (37.7306715888014, -122.439310235275)
32402 97365 DPW Maintained 3 Acer saccharinum :: Silver Maple 273 1263X Robert C Levy Tunl 3 Median : Cutout 11 Tree 1 DPW 2     5     6007465.63195 2118105.8226099997 37.7963362913309 -122.418193751644 (37.7963362913309, -122.418193751644)
35696 220508 Undocumented 2 Acer saccharinum :: Silver Maple 273 495 Eureka St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     7 Width 3ft   6001547.79633 2102968.2445099996 37.754437426650796 -122.437586055063 (37.7544374266508, -122.437586055063)
35792 97374 DPW Maintained 3 Acer saccharinum :: Silver Maple 273 1351X Broadway 9 Median : Cutout 11 Tree 1 DPW 2     3     6006998.02946 2118043.30969 37.7961383154753 -122.419807319778 (37.7961383154753, -122.419807319778)
36548 97369 DPW Maintained 3 Acer saccharinum :: Silver Maple 273 1351X Broadway 4 Median : Cutout 11 Tree 1 DPW 2     5     6007107.08679 2118057.51485 37.7961834623584 -122.41943096698601 (37.7961834623584, -122.419430966986)
37690 189119 Undocumented 2 Acer saccharinum :: Silver Maple 273 268 07th St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     2 Width 3ft   6010146.42849 2111035.7799 37.7770741719623 -122.408418644401 (37.7770741719623, -122.408418644401)
37825 97384 DPW Maintained 3 Acer saccharinum :: Silver Maple 273 1401X Broadway 8 Median : Cutout 11 Tree 1 DPW 2     3     6006553.08454 2118002.88363 37.7960022399536 -122.421344048901 (37.7960022399536, -122.421344048901)
37952 97382 DPW Maintained 3 Acer saccharinum :: Silver Maple 273 1401X Broadway 7 Median : Cutout 11 Tree 1 DPW 2     3     6006565.23555 2118004.957 37.7960086179662 -122.42130215128 (37.7960086179662, -122.42130215128)
38810 203434 Undocumented 2 Acer saccharinum :: Silver Maple 273 15 Hearst Ave 7 Sidewalk: Property side : Yard 9 Tree 1 Private 1     10 Width 10ft   6000925.62299 2094326.76777 37.7306745790725 -122.43911838201099 (37.7306745790725, -122.439118382011)
41145 97381 DPW Maintained 3 Acer saccharinum :: Silver Maple 273 1401X Broadway 6 Median : Cutout 11 Tree 1 DPW 2     3     6006582.71632 2118007.67098 37.796017055392205 -122.421241857125 (37.7960170553922, -122.421241857125)
41340 203435 Undocumented 2 Acer saccharinum :: Silver Maple 273 15 Hearst Ave 8 Sidewalk: Property side : Yard 9 Tree 1 Private 1     12 Width 10ft   6000931.91363 2094326.90958 37.7306753263951 -122.439096644513 (37.7306753263951, -122.439096644513)
42331 220511 Undocumented 2 Acer saccharinum :: Silver Maple 273 850 Valencia St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     6 Width 3ft   6006242.286830001 2104635.3968 37.7592808334555 -122.421469656308 (37.7592808334555, -122.421469656308)
48147 203430 Undocumented 2 Acer saccharinum :: Silver Maple 273 15 Hearst Ave 3 Sidewalk: Property side : Yard 9 Tree 1 Private 1     14 Width 10ft   6000891.5708 2094326.6756 37.7306723883144 -122.439236098782 (37.7306723883144, -122.439236098782)
49664 97385 DPW Maintained 3 Acer saccharinum :: Silver Maple 273 1401X Broadway 9 Median : Cutout 11 Tree 1 DPW 2     3     6006527.03038 2118000.68045 37.7959947216224 -122.42143404497 (37.7959947216224, -122.42143404497)
49928 65921 Permitted Site 1 Acer saccharinum :: Silver Maple 273 1173 Howard St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   06/04/1990 12:00:00 AM 5   Permit Number 28937 6009456.041809999 2110921.53262 37.7767217897184 -122.410798846794 (37.7767217897184, -122.410798846794)
50241 125414 Undocumented 2 Acer saccharinum :: Silver Maple 273 2900 Clay St 6 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     13 Width 4ft   6000746.16024 2115895.0696 37.7898856314688 -122.441285768832 (37.7898856314688, -122.441285768832)
55992 125418 DPW Maintained 3 Acer saccharinum :: Silver Maple 273 1401x Broadway 4 Median : Cutout 11 Tree 1 DPW 2     3 Width 3ft   6006653.67621 2118015.97458 37.7960438552017 -122.42099691148199 (37.7960438552017, -122.420996911482)
57364 124338 Undocumented 2 Acer saccharinum :: Silver Maple 273 129 Palm Ave 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     16 Width 4ft   5995877.50801 2113523.1617900003 37.7830944660272 -122.457959037167 (37.7830944660272, -122.457959037167)
57460 203429 Undocumented 2 Acer saccharinum :: Silver Maple 273 15 Hearst Ave 2 Sidewalk: Property side : Yard 9 Tree 1 Private 1     12 Width 10ft   6000879.97236 2094326.89698 37.7306723361569 -122.43927621213699 (37.7306723361569, -122.439276212137)
58098 175148 Undocumented 2 Acer saccharinum :: Silver Maple 273 684 Brussels St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     12 Width 3ft   6010957.34589 2091575.7285799999 37.7236865149035 -122.404243439305 (37.7236865149035, -122.404243439305)
59661 220520 Undocumented 2 Acer saccharinum :: Silver Maple 273 4552 19th St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     3 Width 3ft   6000838.653530001 2104661.99133 37.7590476986102 -122.44015989857901 (37.7590476986102, -122.440159898579)
60048 143082 Undocumented 2 Acer saccharinum :: Silver Maple 273 439 Greenwich St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     18 Width 0ft   6010741.1828 2120308.1382 37.8025671382387 -122.407014910269 (37.8025671382387, -122.407014910269)
60053 124019 Undocumented 2 Acer saccharinum :: Silver Maple 273 266 Funston Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     4 Width 3ft   5991858.1314900005 2113670.9959 37.783268629436606 -122.47187508986799 (37.7832686294366, -122.471875089868)
61932 97360 DPW Maintained 3 Acer saccharinum :: Silver Maple 273 1351X Broadway 1 Median : Cutout 11 Tree 1 DPW 2     4     6007166.97772 2118064.11604 37.796204960647 -122.419224200263 (37.796204960647, -122.419224200263)
62832 97364 DPW Maintained 3 Acer saccharinum :: Silver Maple 273 1351X Broadway 3 Median : Cutout 11 Tree 1 DPW 2     4     6007127.58515 2118060.22624 37.7961920616707 -122.41936023079398 (37.7961920616707, -122.419360230794)
63146 75990 Undocumented 2 Acer saccharinum :: Silver Maple 273 350 Broadway 1 Sidewalk: Curb side : Cutout 1 Tree 1 SFUSD 4 DPW 4 10/07/1995 12:00:00 AM 3 3x3   6011912.57037 2118781.03793 37.7984395708796 -122.40285383475599 (37.7984395708796, -122.402853834756)
64701 97378 DPW Maintained 3 Acer saccharinum :: Silver Maple 273 1401X Broadway 2 Median : Cutout 11 Tree 1 DPW 2     3     6006692.04041 2118019.16357 37.7960547738532 -122.420864390096 (37.7960547738532, -122.420864390096)
65158 220512 Undocumented 2 Acer saccharinum :: Silver Maple 273 123 San Jose Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     12 Width 5ft   6006192.89167 2102262.56952 37.7527628143525 -122.421471972969 (37.7527628143525, -122.421471972969)
65587 97363 DPW Maintained 3 Acer saccharinum :: Silver Maple 273 1263X Robert C Levy Tunl 2 Median : Cutout 11 Tree 1 DPW 2     4     6007504.85482 2118111.0383 37.7963528199735 -122.418058401889 (37.7963528199735, -122.418058401889)
71383 57247 Permitted Site 1 Acer saccharinum :: Silver Maple 273 1245 Bacon St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   01/10/1975 12:00:00 AM 7   Permit Number 14536 6007770.10234 2091944.12999 37.7245194534815 -122.415287292998 (37.7245194534815, -122.415287292998)
73054 189118 Undocumented 2 Acer saccharinum :: Silver Maple 273 1129 Howard St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     3 Width 3ft   6009697.3697 2111155.80547 37.7773785762935 -122.409980560854 (37.7773785762935, -122.409980560854)
75779 97379 DPW Maintained 3 Acer saccharinum :: Silver Maple 273 1401X Broadway 3 Median : Cutout 11 Tree 1 DPW 2     3     6006673.12303 2118017.2022 37.7960483221209 -122.42092970874901 (37.7960483221209, -122.420929708749)
76290 244225 Undocumented 2 Acer saccharinum :: Silver Maple 273 1850 Page St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     16 Width 0ft   5997719.0698 2108890.9391 37.770481218739704 -122.451253832438 (37.7704812187397, -122.451253832438)
82583 110584 Undocumented 2 Acer saccharinum :: Silver Maple 273 1850 PAGE ST 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1       6x13   5997708.0 2108904.0 37.7705164467869 -122.45129306486 (37.7705164467869, -122.45129306486)
87681 57740 Permitted Site 1 Acer saccharinum :: Silver Maple 273 267 DOLORES ST 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   12/29/1976 12:00:00 AM     Permit Number 16658 6004969.3 2106830.6 37.7652364829248 -122.426028535165 (37.7652364829248, -122.426028535165)
93867 55763 Permitted Site 1 Acer saccharinum :: Silver Maple 273 390 FRANCONIA ST 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   05/16/1973 12:00:00 AM 12 2x4 Permit Number 11798 6009952.0 2098902.0 37.7437466655342 -122.40823523705 (37.7437466655342, -122.40823523705)
106455 3017 DPW Maintained 3 Acer saccharinum :: Silver Maple 273 2485X California St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     24 3X3   6002494.78535 2115413.7680900004 37.788663555221206 -122.435201252457 (37.7886635552212, -122.435201252457)
115625 220509 Undocumented 2 Acer saccharinum :: Silver Maple 273 850 Valencia St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     7 Width 3ft   6006243.62087 2104590.3955599996 37.759157345760705 -122.421461846614 (37.7591573457607, -122.421461846614)
117035 220516 Undocumented 2 Acer saccharinum :: Silver Maple 273 1205 Sanchez St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     4 Width 3ft   6003882.37363 2101221.22219 37.749772972356794 -122.429387908148 (37.7497729723568, -122.429387908148)
125306 220507 Undocumented 2 Acer saccharinum :: Silver Maple 273 815 Alvarado St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     7 Width 4ft   6001031.66383 2102578.10343 37.7533368345295 -122.439343007499 (37.7533368345295, -122.439343007499)
131552 220513 Undocumented 2 Acer saccharinum :: Silver Maple 273 123 San Jose Ave 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     8 Width 5ft   6006193.914369999 2102279.6233200002 37.7528096978261 -122.42146964731899 (37.7528096978261, -122.421469647319)
137412 124339 Undocumented 2 Acer saccharinum :: Silver Maple 273 129 Palm Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     22 Width 4ft   5995877.44459 2113536.3004 37.7831305374996 -122.457960207687 (37.7831305374996, -122.457960207687)
137565 203436 Undocumented 2 Acer saccharinum :: Silver Maple 273 1510 Portola Dr 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     7 Width 3ft   5992419.857009999 2096912.8939099999 37.7372877743081 -122.468711966092 (37.7372877743081, -122.468711966092)
146786 143081 Undocumented 2 Acer saccharinum :: Silver Maple 273 439 Greenwich St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     20 Width 0ft   6010727.7925 2120305.8296 37.802560050074895 -122.407061084811 (37.8025600500749, -122.407061084811)
147979 220523 Undocumented 2 Acer saccharinum :: Silver Maple 273 245 Sanchez St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     17 Width 3ft   6003572.38643 2106830.82998 37.765158065813395 -122.430860140593 (37.7651580658134, -122.430860140593)
150762 220518 Undocumented 2 Acer saccharinum :: Silver Maple 273 18 Ford St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     4 Width 3ft   6003295.40043 2105669.58781 37.761953877581604 -122.43173525018999 (37.7619538775816, -122.43173525019)
151668 97383 DPW Maintained 3 Acer saccharinum :: Silver Maple 273 1401X Broadway 4 Median : Cutout 11 Tree 1 DPW 2     3     6006760.98709 2118021.53262 37.7960651646311 -122.420625988822 (37.7960651646311, -122.420625988822)
151886 220504 Undocumented 2 Acer saccharinum :: Silver Maple 273 425 14th St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     9 Width 3ft   6005905.759319999 2107833.83424 37.7680440073566 -122.42286084725 (37.7680440073566, -122.42286084725)
152235 97370 DPW Maintained 3 Acer saccharinum :: Silver Maple 273 1351X Broadway 6 Median : Cutout 11 Tree 1 DPW 2     4     6007049.26457 2118049.56646 37.796158381161796 -122.419630479787 (37.7961583811618, -122.419630479787)
154624 125415 Undocumented 2 Acer saccharinum :: Silver Maple 273 3014 Washington St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     24 Width 3ft   6000214.54146 2116147.89897 37.7905495370722 -122.44314328163799 (37.7905495370722, -122.443143281638)
154698 220521 Undocumented 2 Acer saccharinum :: Silver Maple 273 202 Hartford St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     3 Width 3ft   6002675.1367 2104694.01512 37.75924001144271 -122.433810765858 (37.7592400114427, -122.433810765858)
155675 97368 DPW Maintained 3 Acer saccharinum :: Silver Maple 273 1351X Broadway 5 Median : Cutout 11 Tree 1 DPW 2     4     6007088.45417 2118056.33113 37.7961791626917 -122.41949535574498 (37.7961791626917, -122.419495355745)
155787 203437 Undocumented 2 Acer saccharinum :: Silver Maple 273 160 Mangels Ave 2 Sidewalk: Property side : Yard 9 Tree 1 Private 1     14 Width 10ft   6000362.84265 2095254.36068 37.733189494482104 -122.44113051976801 (37.7331894944821, -122.441130519768)
161437 220519 Undocumented 2 Acer saccharinum :: Silver Maple 273 426 Sanchez St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     5 Width 3ft   6003571.1013 2105783.188 37.76228142056 -122.43078981631001 (37.76228142056, -122.43078981631)
162398 125417 DPW Maintained 3 Acer saccharinum :: Silver Maple 273 1265x Robert C Levy Tunl 2 Median : Cutout 11 Tree 1 DPW 2     5 Width 5ft   6007321.92087 2118086.10575 37.796274063647 -122.41868962435301 (37.796274063647, -122.418689624353)
164058 125416 DPW Maintained 3 Acer saccharinum :: Silver Maple 273 1265x Robert C Levy Tunl 1 Median : Cutout 11 Tree 1 DPW 2     6 Width 5ft   6007342.58792 2118088.16107 37.796280870607205 -122.418618257738 (37.7962808706072, -122.418618257738)
166569 189117 Undocumented 2 Acer saccharinum :: Silver Maple 273 801 Arkansas St 28 Sidewalk: Property side : Yard 9 Tree 1 Private 1     7     6013044.69991 2103780.15916 37.7573137337465 -122.39788346434901 (37.7573137337465, -122.397883464349)
167468 203431 Undocumented 2 Acer saccharinum :: Silver Maple 273 15 Hearst Ave 4 Sidewalk: Property side : Yard 9 Tree 1 Private 1     14 Width 10ft   6000899.9259 2094326.75595 37.7306730843802 -122.439207219743 (37.7306730843802, -122.439207219743)
167965 220515 Undocumented 2 Acer saccharinum :: Silver Maple 273 471 Alvarado St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     6 Width 3ft   6003333.59929 2102700.91879 37.7538047859636 -122.431391207355 (37.7538047859636, -122.431391207355)
171458 97373 DPW Maintained 3 Acer saccharinum :: Silver Maple 273 1351X Broadway 8 Median : Cutout 11 Tree 1 DPW 2     4     6007014.5714300005 2118044.79728 37.796143331891706 -122.419750186728 (37.7961433318917, -122.419750186728)
172324 220505 Undocumented 2 Acer saccharinum :: Silver Maple 273 390 Franconia St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     13 Width 2ft   6009947.64853 2098867.97047 37.7436529841995 -122.40824788385 (37.7436529841995, -122.40824788385)
174730 97362 DPW Maintained 3 Acer saccharinum :: Silver Maple 273 1263X Robert C Levy Tunl 1 Median : Cutout 11 Tree 1 DPW 2     5     6007524.81802 2118113.4619299998 37.796360598225796 -122.41798949673901 (37.7963605982258, -122.417989496739)
177316 97367 DPW Maintained 3 Acer saccharinum :: Silver Maple 273 1263X Robert C Levy Tunl 4 Median : Cutout 11 Tree 1 DPW 2     5     6007448.14227 2118102.63987 37.79632656786411 -122.418254043985 (37.7963265678641, -122.418254043985)
182769 220514 Undocumented 2 Acer saccharinum :: Silver Maple 273 4048 22nd St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     14 Width 3ft   6001567.00144 2102942.84147 37.7543687679287 -122.4375178199 (37.7543687679287, -122.4375178199)
185126 97377 DPW Maintained 3 Acer saccharinum :: Silver Maple 273 1401X Broadway 1 Median : Cutout 11 Tree 1 DPW 2     3     6006713.66086 2118020.1658099997 37.7960587443728 -122.420789650134 (37.7960587443728, -122.420789650134)
187241 220517 Undocumented 2 Acer saccharinum :: Silver Maple 273 4 Ford St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     4 Width 3ft   6003501.06849 2105680.00758 37.7619941438348 -122.43102466886002 (37.7619941438348, -122.43102466886)
187339 189120 Undocumented 2 Acer saccharinum :: Silver Maple 273 268 07th St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     2 Width 3ft   6010155.861190001 2111026.4848 37.7770491780218 -122.408385357803 (37.7770491780218, -122.408385357803)

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 76.827ms · Data source: data.sfgov.org