Street_Tree_List

Data source: data.sfgov.org

219 rows where qSpecies = 99 sorted by qLegalStatus

View and edit SQL

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

Link rowid TreeID qLegalStatus ▼ qSpecies qAddress SiteOrder qSiteInfo PlantType qCaretaker qCareAssistant PlantDate DBH PlotSize PermitNotes XCoord YCoord Latitude Longitude Location
601 225172 Permitted Site 1 Chamaerops humilis :: Mediterranean Fan Palm 99 248 Prospect Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   12/02/2002 12:00:00 AM 9 Width 3ft Permit Number 46150 6006535.621280001 2098220.1400900004 37.7416825381227 -122.419999905071 (37.7416825381227, -122.419999905071)
16169 100329 Permitted Site 1 Chamaerops humilis :: Mediterranean Fan Palm 99 555 04th St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   04/01/2012 12:00:00 AM 3 3x3 Permit Number 768623 6013411.2884599995 2111661.36797 37.7789741867392 -122.39716827132 (37.7789741867392, -122.39716827132)
16787 100332 Permitted Site 1 Chamaerops humilis :: Mediterranean Fan Palm 99 555 04th St 6 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   04/01/2012 12:00:00 AM 3 3x3 Permit Number 768623 6013356.21451 2111717.71239 37.779125829518705 -122.397362747904 (37.7791258295187, -122.397362747904)
17622 638 Permitted Site 1 Chamaerops humilis :: Mediterranean Fan Palm 99 3203 24th St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   04/01/1991 12:00:00 AM 18 3X3   6007578.42744 2102058.8333799997 37.752281425265295 -122.41666609486401 (37.7522814252653, -122.416666094864)
21501 639 Permitted Site 1 Chamaerops humilis :: Mediterranean Fan Palm 99 3203 24th St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   04/01/1991 12:00:00 AM 18 3X3   6007596.74853 2102059.47083 37.7522842059666 -122.416602782609 (37.7522842059666, -122.416602782609)
22913 100331 Permitted Site 1 Chamaerops humilis :: Mediterranean Fan Palm 99 555 04th St 5 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     22 3x3   6013371.56305 2111703.84537 37.779088608380206 -122.397308677969 (37.7790886083802, -122.397308677969)
43790 100327 Permitted Site 1 Chamaerops humilis :: Mediterranean Fan Palm 99 555 04th St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     24 3x3   6013441.178619999 2111631.13985 37.7788928511631 -122.39706274847299 (37.7788928511631, -122.397062748473)
57603 100328 Permitted Site 1 Chamaerops humilis :: Mediterranean Fan Palm 99 555 04th St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     20 3x3   6013422.40904 2111650.3481099997 37.778944547796705 -122.397129027591 (37.7789445477967, -122.397129027591)
90022 73786 Permitted Site 1 Chamaerops humilis :: Mediterranean Fan Palm 99 240 Shotwell St 8 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 12/21/1996 12:00:00 AM 6 3x3   6007780.97837226 2105869.55428135 37.7627561815899 -122.41623551068999 (37.7627561815899, -122.41623551069)
152589 32693 Permitted Site 1 Chamaerops humilis :: Mediterranean Fan Palm 99 3732 23rd St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   10/29/1996 12:00:00 AM 1   Permit Number 37102 6004859.3884 2102538.49197 37.7534451551954 -122.42610311279199 (37.7534451551954, -122.426103112792)
155078 32061 Permitted Site 1 Chamaerops humilis :: Mediterranean Fan Palm 99 3641 17th St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 08/09/1995 12:00:00 AM 7   Permit Number 35437 6004606.11173 2105983.62755 37.762890365909 -122.4272243812 (37.762890365909, -122.4272243812)
167510 100330 Permitted Site 1 Chamaerops humilis :: Mediterranean Fan Palm 99 555 04th St 4 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     26 3x3   6013394.216680001 2111677.27832 37.7790169225246 -122.39722844584601 (37.7790169225246, -122.397228445846)
181963 104417 Permitted Site 1 Chamaerops humilis :: Mediterranean Fan Palm 99 335 Marina Blvd 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   10/02/2013 12:00:00 AM 12   Permit Number 770730 6001763.35391 2121819.4095799997 37.8062102070855 -122.438190954371 (37.8062102070855, -122.438190954371)
187574 31676 Permitted Site 1 Chamaerops humilis :: Mediterranean Fan Palm 99 335 Marina Blvd 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     12   Permit Number 770730 6001735.33868 2121814.4309799997 37.806194943810894 -122.438287548749 (37.8061949438109, -122.438287548749)
23690 126012 Undocumented 2 Chamaerops humilis :: Mediterranean Fan Palm 99 2600 Lyon St 10 Sidewalk: Property side : Yard 9 Tree 1 Private 1     9 Width 7ft   5999234.571959999 2117780.83993 37.7949772349663 -122.446651443424 (37.7949772349663, -122.446651443424)
24138 225161 Undocumented 2 Chamaerops humilis :: Mediterranean Fan Palm 99 2957 Harrison St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     7 Width 3ft   6009038.45977 2101249.93986 37.7501423922716 -122.411559907065 (37.7501423922716, -122.411559907065)
25509 190026 Undocumented 2 Chamaerops humilis :: Mediterranean Fan Palm 99 1400 03rd St 12 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     14 Width 5ft   6015544.83514 2108320.68008 37.769919941866895 -122.389554039808 (37.7699199418669, -122.389554039808)
25803 225170 Undocumented 2 Chamaerops humilis :: Mediterranean Fan Palm 99 84 Putnam St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     13 Width 3ft   6009137.3737 2096981.67824 37.7384282324737 -122.410916429557 (37.7384282324737, -122.410916429557)
26101 225190 Undocumented 2 Chamaerops humilis :: Mediterranean Fan Palm 99 500 Capp St 4 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     9 Width 3ft   6007254.11935 2103898.21255 37.7573136941774 -122.41791798353998 (37.7573136941774, -122.41791798354)
27211 190009 Undocumented 2 Chamaerops humilis :: Mediterranean Fan Palm 99 499 Arkansas St 2 Sidewalk: Curb side : Pot 10 Tree 1 Private 1     12 Width 3ft   6013000.6424 2104780.97852 37.7600593109036 -122.39810604475099 (37.7600593109036, -122.398106044751)
27326 190005 Undocumented 2 Chamaerops humilis :: Mediterranean Fan Palm 99 700 Arkansas St 2 Front Yard : Yard 7 Tree 1 Private 1     2     6012982.63799 2103818.56401 37.757415728567295 -122.398100794529 (37.7574157285673, -122.398100794529)
27402 201678 Undocumented 2 Chamaerops humilis :: Mediterranean Fan Palm 99 401 08th St 14 Front Yard : Yard 7 Tree 1 Private 1     4     6010253.38486 2109790.37511 37.7736605694093 -122.407960800466 (37.7736605694093, -122.407960800466)
27419 190015 Undocumented 2 Chamaerops humilis :: Mediterranean Fan Palm 99 1530 03rd St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     16 Width 5ft   6015573.49943 2107841.28907 37.768605228364 -122.38942140686899 (37.768605228364, -122.389421406869)
29299 225151 Undocumented 2 Chamaerops humilis :: Mediterranean Fan Palm 99 14 Montezuma St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     10 Width 3ft   6007510.1037 2099736.8177900002 37.7459018513879 -122.416737884151 (37.7459018513879, -122.416737884151)
31524 175845 Undocumented 2 Chamaerops humilis :: Mediterranean Fan Palm 99 98 Newton St 2 Sidewalk: Property side : Yard 9 Tree 1 Private 1     23 Width 10ft   6000912.9484 2087984.8955700002 37.7132605143345 -122.43870794134399 (37.7132605143345, -122.438707941344)
31570 225166 Undocumented 2 Chamaerops humilis :: Mediterranean Fan Palm 99 338 Hoffman Ave 5 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     8 Width 4ft   6000619.1665199995 2101783.32951 37.7511310943237 -122.440712500502 (37.7511310943237, -122.440712500502)
32476 126017 Undocumented 2 Chamaerops humilis :: Mediterranean Fan Palm 99 500 Post St 3 Sidewalk: Curb side : Pot 10 Tree 1 Private 1     6 Width 3ft   6009644.05128 2115053.2571900003 37.788077063340204 -122.410440279012 (37.7880770633402, -122.410440279012)
34064 126015 Undocumented 2 Chamaerops humilis :: Mediterranean Fan Palm 99 500 Post St 1 Sidewalk: Curb side : Pot 10 Tree 1 Private 1     6 Width 3ft   6009674.03362 2115055.86699 37.788085909974605 -122.410336729273 (37.7880859099746, -122.410336729273)
34445 189999 Undocumented 2 Chamaerops humilis :: Mediterranean Fan Palm 99 700 Carolina St 1 Sidewalk: Property side : Yard 9 Tree 1 Private 1     12 Width 3ft   6012378.8382 2104615.7006200003 37.759570841431604 -122.400244972539 (37.7595708414316, -122.400244972539)
34786 126022 Undocumented 2 Chamaerops humilis :: Mediterranean Fan Palm 99 550 Geary St 3 Sidewalk: Curb side : Pot 10 Tree 1 Private 1     4 Width 4ft   6009023.96612 2114628.9203 37.786877155513004 -122.412555665234 (37.786877155513, -122.412555665234)
34889 175846 Undocumented 2 Chamaerops humilis :: Mediterranean Fan Palm 99 210 Tocoloma Ave 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     8 Width 3ft   6012734.12087 2087510.3732 37.7126229867466 -122.397816364158 (37.7126229867466, -122.397816364158)
37075 225178 Undocumented 2 Chamaerops humilis :: Mediterranean Fan Palm 99 858 Shotwell St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     7 Width 3ft   6007945.63288 2102930.5151400003 37.754695511392605 -122.41545794294301 (37.7546955113926, -122.415457942943)
37175 126019 Undocumented 2 Chamaerops humilis :: Mediterranean Fan Palm 99 542 Geary St 1 Sidewalk: Curb side : Pot 10 Tree 1 Private 1     11 Width 4ft   6009096.37686 2114637.77725 37.7869055381056 -122.412305766101 (37.7869055381056, -122.412305766101)
38579 190011 Undocumented 2 Chamaerops humilis :: Mediterranean Fan Palm 99 1599 Newhall St 1 : 4 Tree 1 Private 1     10 Width 4ft   6014210.748430001 2095415.1555299999 37.7344100624646 -122.39326543937 (37.7344100624646, -122.39326543937)
38646 201508 Undocumented 2 Chamaerops humilis :: Mediterranean Fan Palm 99 1001 Innes Ave 6 Sidewalk: Property side : Yard 9 Tree 1 Private 1     1 Width 4ft   6018593.65925 2094901.94124 37.7332433998449 -122.378076502435 (37.7332433998449, -122.378076502435)
39929 225188 Undocumented 2 Chamaerops humilis :: Mediterranean Fan Palm 99 500 Capp St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     10 Width 3ft   6007247.90987 2103966.5437 37.757500966319604 -122.417944302192 (37.7575009663196, -122.417944302192)
40599 190014 Undocumented 2 Chamaerops humilis :: Mediterranean Fan Palm 99 888 07th St 9 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     29 Width 8ft   6012452.605140001 2108628.1137900003 37.770592145536 -122.400271663513 (37.770592145536, -122.400271663513)
40866 225175 Undocumented 2 Chamaerops humilis :: Mediterranean Fan Palm 99 3309 Folsom St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     3 Width 3ft   6008515.82219 2099330.37365 37.7448423609829 -122.41323150034901 (37.7448423609829, -122.413231500349)
42322 225209 Undocumented 2 Chamaerops humilis :: Mediterranean Fan Palm 99 338 Cumberland St 4 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     5 Width 3ft   6003378.3537099995 2104496.9744599997 37.7587388642274 -122.431364637772 (37.7587388642274, -122.431364637772)
42492 247161 Undocumented 2 Chamaerops humilis :: Mediterranean Fan Palm 99 2399 Market St 1 Sidewalk: Curb side : Pot 10 Tree 1 Private 1     28 Width 5ft   6002372.95372 2105936.54637 37.7626345492748 -122.43494472103998 (37.7626345492748, -122.43494472104)
44500 225198 Undocumented 2 Chamaerops humilis :: Mediterranean Fan Palm 99 3160 21st St 5 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     9 Width 3ft   6007149.23047 2103831.77129 37.757125358151704 -122.41827602071501 (37.7571253581517, -122.418276020715)
44503 225169 Undocumented 2 Chamaerops humilis :: Mediterranean Fan Palm 99 225 Banks St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     4 Width 3ft   6008644.12934 2097539.28369 37.7399316246566 -122.412661242936 (37.7399316246566, -122.412661242936)
44856 190023 Undocumented 2 Chamaerops humilis :: Mediterranean Fan Palm 99 1400 03rd St 6 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     16 Width 5ft   6015540.26875 2108442.1367599997 37.770253182080396 -122.38957831879499 (37.7702531820804, -122.389578318795)
45328 225157 Undocumented 2 Chamaerops humilis :: Mediterranean Fan Palm 99 104 Franconia St 4 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     9 Width 2ft   6010022.83769 2099819.01097 37.7462685436666 -122.408054953167 (37.7462685436666, -122.408054953167)
45520 190006 Undocumented 2 Chamaerops humilis :: Mediterranean Fan Palm 99 700 Arkansas St 4 Front Yard : Yard 7 Tree 1 Private 1     4     6012982.38984 2103806.3309400002 37.7573821254062 -122.398100794542 (37.7573821254062, -122.398100794542)
45931 190000 Undocumented 2 Chamaerops humilis :: Mediterranean Fan Palm 99 770 De Haro St 1 Sidewalk: Property side : Yard 9 Tree 1 Private 1     3 Width 3ft   6012104.84568 2104756.14819 37.7599411975544 -122.401202450128 (37.7599411975544, -122.401202450128)
47236 225176 Undocumented 2 Chamaerops humilis :: Mediterranean Fan Palm 99 1020 Alabama St 1 Sidewalk: Curb side : Pot 10 Tree 1 Private 1     7 Width 3ft   6009156.40291 2103118.80305 37.7552804871291 -122.411284056222 (37.7552804871291, -122.411284056222)
49236 190022 Undocumented 2 Chamaerops humilis :: Mediterranean Fan Palm 99 1400 03rd St 4 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     15 Width 5ft   6015535.32333 2108481.6321099997 37.770361353431895 -122.389598183934 (37.7703613534319, -122.389598183934)
49570 225173 Undocumented 2 Chamaerops humilis :: Mediterranean Fan Palm 99 98 Santa Marina St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     9 Width 3ft   6006194.79816 2097580.2396 37.7399063069243 -122.42113293303998 (37.7399063069243, -122.42113293304)
49752 225207 Undocumented 2 Chamaerops humilis :: Mediterranean Fan Palm 99 3816 24th St 3 Sidewalk: Curb side : Pot 10 Tree 1 Private 1     6 Width 3ft   6004299.338409999 2101924.10637 37.7517265264651 -122.427996107428 (37.7517265264651, -122.427996107428)
49887 190019 Undocumented 2 Chamaerops humilis :: Mediterranean Fan Palm 99 1530 03rd St 10 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     14 Width 5ft   6015583.6961 2107674.48805 37.7681477945165 -122.389374487455 (37.7681477945165, -122.389374487455)
49897 225168 Undocumented 2 Chamaerops humilis :: Mediterranean Fan Palm 99 4400 24th St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     7 Width 3ft   6000595.27715 2101716.78753 37.750947025601 -122.44079033950399 (37.750947025601, -122.440790339504)
50903 225174 Undocumented 2 Chamaerops humilis :: Mediterranean Fan Palm 99 1000 Jarboe Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     10 Width 3ft   6009367.84971 2096849.47647 37.738078156068894 -122.410110221514 (37.7380781560689, -122.410110221514)
52213 190002 Undocumented 2 Chamaerops humilis :: Mediterranean Fan Palm 99 790 De Haro St 2 Sidewalk: Property side : Yard 9 Tree 1 Private 1     16     6012104.02513 2104748.44893 37.759920011313206 -122.401204746997 (37.7599200113132, -122.401204746997)
54105 206046 Undocumented 2 Chamaerops humilis :: Mediterranean Fan Palm 99 82 Ventura Ave 3 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     5 Width 3ft   5994334.26497 2101814.09479 37.750855650885605 -122.462448420067 (37.7508556508856, -122.462448420067)
54322 206026 Undocumented 2 Chamaerops humilis :: Mediterranean Fan Palm 99 804 Faxon Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     10 Width 10ft   5994921.599769999 2093400.11628 37.727786752547296 -122.45980797188601 (37.7277867525473, -122.459807971886)
55039 225145 Undocumented 2 Chamaerops humilis :: Mediterranean Fan Palm 99 450 Florida St 9 Sidewalk: Property side : Yard 9 Tree 1 Private 1     18     6009179.2133599995 2106266.6276700003 37.76392497748579 -122.41142754574899 (37.7639249774858, -122.411427545749)
57244 126010 Undocumented 2 Chamaerops humilis :: Mediterranean Fan Palm 99 85 Toledo Way 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     10 Width 3ft   6001465.00623 2119940.72568 37.801034867711 -122.43908870440599 (37.801034867711, -122.439088704406)
57727 117702 Undocumented 2 Chamaerops humilis :: Mediterranean Fan Palm 99 4021 Clement St 1 Sidewalk: Property side : Yard 9 Tree 1 Private 1     9 Width 7ft   5983001.87469 2113075.50324 37.781117159673705 -122.50246961447901 (37.7811171596737, -122.502469614479)
57805 206027 Undocumented 2 Chamaerops humilis :: Mediterranean Fan Palm 99 804 Faxon Ave 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     10 Width 10ft   5994921.23721 2093409.63408 37.7278128652723 -122.459809914392 (37.7278128652723, -122.459809914392)
58330 206036 Undocumented 2 Chamaerops humilis :: Mediterranean Fan Palm 99 280 Brighton Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     10 Width 3ft   5996259.37903 2091732.03952 37.7232834540474 -122.455062785437 (37.7232834540474, -122.455062785437)
59914 206025 Undocumented 2 Chamaerops humilis :: Mediterranean Fan Palm 99 1366 16th Ave 6 Sidewalk: Curb side : Pot 10 Tree 1 Private 1     5 Width 3ft   5991157.5258599995 2106131.34791 37.76252624212071 -122.473748679463 (37.7625262421207, -122.473748679463)
60112 225210 Undocumented 2 Chamaerops humilis :: Mediterranean Fan Palm 99 3641 17th St 3 Sidewalk: Curb side : Pot 10 Tree 1 Private 1     7 Width 3ft   6004615.0966300005 2105985.22525 37.7628952609247 -122.427193419352 (37.7628952609247, -122.427193419352)
60204 189997 Undocumented 2 Chamaerops humilis :: Mediterranean Fan Palm 99 1809 19th St 7 Sidewalk: Property side : Yard 9 Tree 1 Private 1     18 Width 6ft   6012307.781769999 2105132.0490099997 37.760984657528894 -122.40052699363501 (37.7609846575289, -122.400526993635)
61054 247121 Undocumented 2 Chamaerops humilis :: Mediterranean Fan Palm 99 2301 Castro St 3 Sidewalk: Property side : Yard 9 Tree 1 Private 1     5     6002764.34837 2098855.27399 37.743213271472705 -122.433085061551 (37.7432132714727, -122.433085061551)
62061 206040 Undocumented 2 Chamaerops humilis :: Mediterranean Fan Palm 99 621 Holloway Ave 7 Sidewalk: Property side : Yard 9 Tree 1 Private 1     9 Width 3ft   5994946.74244 2091203.9910900001 37.7217581669755 -122.45956206304899 (37.7217581669755, -122.459562063049)
63388 225185 Undocumented 2 Chamaerops humilis :: Mediterranean Fan Palm 99 240 Shotwell St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     7 Width 3ft   6007746.072980001 2106673.2030700003 37.764960851679 -122.41641316324 (37.764960851679, -122.41641316324)
63791 201677 Undocumented 2 Chamaerops humilis :: Mediterranean Fan Palm 99 401 08th St 13 Front Yard : Yard 7 Tree 1 Private 1     8     6010264.4203699995 2109791.71635 37.7736648699818 -122.407922721364 (37.7736648699818, -122.407922721364)
65401 190004 Undocumented 2 Chamaerops humilis :: Mediterranean Fan Palm 99 1745 20th St 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     25 Width 3ft   6012733.96255 2104688.60274 37.7597908102085 -122.399021884672 (37.7597908102085, -122.399021884672)
66360 190027 Undocumented 2 Chamaerops humilis :: Mediterranean Fan Palm 99 1500 03rd St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     15 Width 5ft   6015553.64576 2108193.7384099998 37.7695718763733 -122.389514697159 (37.7695718763733, -122.389514697159)
66694 225148 Undocumented 2 Chamaerops humilis :: Mediterranean Fan Palm 99 1199 Capp St 1 Sidewalk: Property side : Yard 9 Tree 1 Private 1     3 Width 9ft   6007231.69522 2100624.49408 37.7483235475968 -122.417763493512 (37.7483235475968, -122.417763493512)
67172 175847 Undocumented 2 Chamaerops humilis :: Mediterranean Fan Palm 99 210 Tocoloma Ave 4 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     8 Width 3ft   6012727.81245 2087493.92668 37.7125774765391 -122.397837015259 (37.7125774765391, -122.397837015259)
67868 206024 Undocumented 2 Chamaerops humilis :: Mediterranean Fan Palm 99 1366 16th Ave 2 Sidewalk: Curb side : Pot 10 Tree 1 Private 1     5 Width 3ft   5991156.52884 2106111.8053099997 37.7624725256075 -122.473750702041 (37.7624725256075, -122.473750702041)
68768 190029 Undocumented 2 Chamaerops humilis :: Mediterranean Fan Palm 99 1500 03rd St 8 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     16 Width 5ft   6015559.81581 2108067.16285 37.7692246696975 -122.38948451411999 (37.7692246696975, -122.38948451412)
69677 201679 Undocumented 2 Chamaerops humilis :: Mediterranean Fan Palm 99 401 08th St 15 Front Yard : Yard 7 Tree 1 Private 1     5     6010240.772059999 2109788.80533 37.7736555529973 -122.40800431955799 (37.7736555529973, -122.408004319558)
70063 225186 Undocumented 2 Chamaerops humilis :: Mediterranean Fan Palm 99 252 Capp St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     5 Width 3ft   6007150.88723 2105850.08612 37.762667276482894 -122.418413397566 (37.7626672764829, -122.418413397566)
70258 201675 Undocumented 2 Chamaerops humilis :: Mediterranean Fan Palm 99 401 08th St 11 Front Yard : Yard 7 Tree 1 Private 1     4     6010282.589459999 2109782.99387 37.7736419372697 -122.40785925619801 (37.7736419372697, -122.407859256198)
70642 206037 Undocumented 2 Chamaerops humilis :: Mediterranean Fan Palm 99 280 Brighton Ave 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     10 Width 3ft   5996260.563569999 2091771.26312 37.72339122070879 -122.45506152367201 (37.7233912207088, -122.455061523672)
70787 201506 Undocumented 2 Chamaerops humilis :: Mediterranean Fan Palm 99 1001 Innes Ave 4 Sidewalk: Property side : Yard 9 Tree 1 Private 1     1 Width 4ft   6018588.36983 2094906.5368 37.7332557268509 -122.378095108499 (37.7332557268509, -122.378095108499)
71331 225208 Undocumented 2 Chamaerops humilis :: Mediterranean Fan Palm 99 338 Cumberland St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     5 Width 3ft   6003395.5499 2104500.55449 37.758749668692495 -122.431305421031 (37.7587496686925, -122.431305421031)
71985 190021 Undocumented 2 Chamaerops humilis :: Mediterranean Fan Palm 99 1400 03rd St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     13 Width 5ft   6015535.23888 2108524.8420599997 37.7704799937881 -122.389601494338 (37.7704799937881, -122.389601494338)
72268 201680 Undocumented 2 Chamaerops humilis :: Mediterranean Fan Palm 99 401 08th St 16 Front Yard : Yard 7 Tree 1 Private 1     5     6010229.21797 2109787.73605 37.7736519701026 -122.40804421168998 (37.7736519701026, -122.40804421169)
72634 225193 Undocumented 2 Chamaerops humilis :: Mediterranean Fan Palm 99 2973 23rd St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     10 Width 3ft   6009010.89225 2102726.9922700003 37.7541965009837 -122.41175959345 (37.7541965009837, -122.41175959345)
73909 225153 Undocumented 2 Chamaerops humilis :: Mediterranean Fan Palm 99 105 Franconia St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     13 Width 3ft   6010058.65262 2099813.08608 37.7462542804284 -122.407930691168 (37.7462542804284, -122.407930691168)
74897 206045 Undocumented 2 Chamaerops humilis :: Mediterranean Fan Palm 99 260 San Leandro Way 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     9 Width 3ft   5992364.28925 2095097.86508 37.732300949933 -122.468772052499 (37.732300949933, -122.468772052499)
75852 225160 Undocumented 2 Chamaerops humilis :: Mediterranean Fan Palm 99 3191 21st St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     6 Width 3ft   6007035.27064 2103785.32086 37.756991400544294 -122.418666844507 (37.7569914005443, -122.418666844507)
76779 225196 Undocumented 2 Chamaerops humilis :: Mediterranean Fan Palm 99 3160 21st St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     9 Width 3ft   6007182.851 2103832.80652 37.7571300930895 -122.41815982112699 (37.7571300930895, -122.418159821127)
76939 225183 Undocumented 2 Chamaerops humilis :: Mediterranean Fan Palm 99 240 Shotwell St 5 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     7 Width 3ft   6007749.18821 2106563.04323 37.7646585535855 -122.416394585035 (37.7646585535855, -122.416394585035)
84096 225197 Undocumented 2 Chamaerops humilis :: Mediterranean Fan Palm 99 3160 21st St 4 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     9 Width 3ft   6007163.79352 2103832.50742 37.7571281991351 -122.418225708166 (37.7571281991351, -122.418225708166)
89297 201672 Undocumented 2 Chamaerops humilis :: Mediterranean Fan Palm 99 401 08th St 8 Front Yard : Yard 7 Tree 1 Private 1     5     6010270.770690001 2109756.0907799997 37.773567405955 -122.407898241816 (37.773567405955, -122.407898241816)
97571 225162 Undocumented 2 Chamaerops humilis :: Mediterranean Fan Palm 99 2859 16th St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     9 Width 3ft   6007695.93122 2106747.75341 37.765162729690296 -122.41659187291701 (37.7651627296903, -122.416591872917)
106572 225189 Undocumented 2 Chamaerops humilis :: Mediterranean Fan Palm 99 500 Capp St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     10 Width 3ft   6007250.88683 2103937.06131 37.757420182006605 -122.41793191673901 (37.7574201820066, -122.417931916739)
109054 225205 Undocumented 2 Chamaerops humilis :: Mediterranean Fan Palm 99 3993 25th St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     4 Width 3ft   6003915.45765 2101274.6592 37.749921570934895 -122.429277312204 (37.7499215709349, -122.429277312204)
130881 225147 Undocumented 2 Chamaerops humilis :: Mediterranean Fan Palm 99 1706 Dolores St 9 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     11 Width 6ft   6005278.315280001 2098374.8158 37.7420363251164 -122.424358251742 (37.7420363251164, -122.424358251742)
130988 190030 Undocumented 2 Chamaerops humilis :: Mediterranean Fan Palm 99 1500 03rd St 10 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     14 Width 5ft   6015562.57352 2108029.9349599998 37.7691226029579 -122.389472375051 (37.7691226029579, -122.389472375051)
131158 225165 Undocumented 2 Chamaerops humilis :: Mediterranean Fan Palm 99 4318 26th St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     13 Width 3ft   6001787.26659 2100614.3133 37.7479877056879 -122.436589428169 (37.7479877056879, -122.436589428169)
131352 126018 Undocumented 2 Chamaerops humilis :: Mediterranean Fan Palm 99 500 Post St 4 Sidewalk: Curb side : Pot 10 Tree 1 Private 1     6 Width 3ft   6009631.44446 2115049.8898 37.788067110556604 -122.41048365871 (37.7880671105566, -122.41048365871)
132041 190025 Undocumented 2 Chamaerops humilis :: Mediterranean Fan Palm 99 1400 03rd St 10 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     14 Width 5ft   6015543.83866 2108366.1327 37.7700446895441 -122.389560661497 (37.7700446895441, -122.389560661497)
132078 225152 Undocumented 2 Chamaerops humilis :: Mediterranean Fan Palm 99 339 Elsie St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     5 Width 4ft   6006495.85243 2097173.79313 37.738807262551205 -122.42006317417801 (37.7388072625512, -122.420063174178)
134762 201676 Undocumented 2 Chamaerops humilis :: Mediterranean Fan Palm 99 401 08th St 12 Front Yard : Yard 7 Tree 1 Private 1     5     6010275.73936 2109794.09532 37.7736720357783 -122.40788373484301 (37.7736720357783, -122.407883734843)

Next page

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