Street_Tree_List

Data source: data.sfgov.org

219 rows where qSpecies = 99 sorted by Location

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 ▼
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)
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)
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)
150193 206044 Undocumented 2 Chamaerops humilis :: Mediterranean Fan Palm 99 275 Byxbee St 1 Sidewalk: Property side : Yard 9 Tree 1 Private 1     5 Width 6ft   5991926.36894 2090353.75557 37.7192494901497 -122.46994073500099 (37.7192494901497, -122.469940735001)
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)
183433 206043 Undocumented 2 Chamaerops humilis :: Mediterranean Fan Palm 99 621 Holloway Ave 10 Sidewalk: Property side : Yard 9 Tree 1 Private 1     9 Width 3ft   5994997.50397 2091203.21567 37.721758956587294 -122.459386538764 (37.7217589565873, -122.459386538764)
168817 206042 Undocumented 2 Chamaerops humilis :: Mediterranean Fan Palm 99 621 Holloway Ave 9 Sidewalk: Property side : Yard 9 Tree 1 Private 1     9 Width 3ft   5994983.67365 2091204.0797700002 37.7217605339977 -122.45943440879101 (37.7217605339977, -122.459434408791)
178979 206041 Undocumented 2 Chamaerops humilis :: Mediterranean Fan Palm 99 621 Holloway Ave 8 Sidewalk: Property side : Yard 9 Tree 1 Private 1     9 Width 3ft   5994962.333219999 2091204.5266599997 37.7217605340024 -122.459508208932 (37.7217605340024, -122.459508208932)
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)
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)
173741 206038 Undocumented 2 Chamaerops humilis :: Mediterranean Fan Palm 99 280 Brighton Ave 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     10 Width 3ft   5996260.86716 2091785.79325 37.72343113441671 -122.45506152366998 (37.7234311344167, -122.45506152367)
162917 206039 Undocumented 2 Chamaerops humilis :: Mediterranean Fan Palm 99 280 Brighton Ave 4 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     10 Width 3ft   5996261.11762 2091797.78089 37.723464064001895 -122.455061523695 (37.7234640640019, -122.455061523695)
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)
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)
163945 206035 DPW Maintained 3 Chamaerops humilis :: Mediterranean Fan Palm 99 700x Monterey Blvd 18 Median : Cutout 11 Tree 1 DPW 2     6 Width 4ft   5996866.22235 2094722.0274099999 37.7315280455795 -122.453180800271 (37.7315280455795, -122.453180800271)
63471 206034 DPW Maintained 3 Chamaerops humilis :: Mediterranean Fan Palm 99 700x Monterey Blvd 17 Median : Cutout 11 Tree 1 DPW 2     8 Width 4ft   5996882.83192 2094722.4323900002 37.731530109506295 -122.453123407313 (37.7315301095063, -122.453123407313)
17832 16310 DPW Maintained 3 Chamaerops humilis :: Mediterranean Fan Palm 99 700X Monterey Blvd 2 Median : Cutout 11 Tree 1 DPW 2   02/02/2003 12:00:00 AM 18 5   5997364.820830001 2094712.7517799998 37.7315311410332 -122.45145638890499 (37.7315311410332, -122.451456388905)
22067 16311 DPW Maintained 3 Chamaerops humilis :: Mediterranean Fan Palm 99 700X Monterey Blvd 3 Median : Cutout 11 Tree 1 DPW 2   02/02/2003 12:00:00 AM 3 5   5997346.34886 2094713.5127 37.7315321725506 -122.45152030461901 (37.7315321725506, -122.451520304619)
19514 16309 DPW Maintained 3 Chamaerops humilis :: Mediterranean Fan Palm 99 700X Monterey Blvd 1 Median : Cutout 11 Tree 1 DPW 2   02/02/2003 12:00:00 AM 18 5   5997384.824659999 2094713.0859599998 37.7315332040811 -122.45138725623801 (37.7315332040811, -122.451387256238)
71306 206033 DPW Maintained 3 Chamaerops humilis :: Mediterranean Fan Palm 99 700x Monterey Blvd 16 Median : Cutout 11 Tree 1 DPW 2     8 Width 4ft   5996901.71225 2094723.16535 37.7315332040984 -122.453058187605 (37.7315332040984, -122.453058187605)
61557 206031 DPW Maintained 3 Chamaerops humilis :: Mediterranean Fan Palm 99 601x Monterey Blvd 11 Median : Cutout 11 Tree 1 DPW 2     7 Width 4ft   5997540.974909999 2094710.58133 37.731535267123 -122.450847236737 (37.731535267123, -122.450847236737)
188264 206032 DPW Maintained 3 Chamaerops humilis :: Mediterranean Fan Palm 99 601x Monterey Blvd 12 Median : Cutout 11 Tree 1 DPW 2     7 Width 4ft   5997524.38886 2094711.3028099998 37.7315362986421 -122.450904629644 (37.7315362986421, -122.450904629644)
18826 16271 DPW Maintained 3 Chamaerops humilis :: Mediterranean Fan Palm 99 601X Monterey Blvd 3 Median : Cutout 11 Tree 1 DPW 2   02/02/2003 12:00:00 AM 18 5   5997920.42958 2094705.3029200002 37.731542488687204 -122.449535014353 (37.7315424886872, -122.449535014353)
21427 16246 DPW Maintained 3 Chamaerops humilis :: Mediterranean Fan Palm 99 601X Monterey Blvd 2 Median : Cutout 11 Tree 1 DPW 2   02/02/2003 12:00:00 AM 12 5   5997938.93286 2094706.04445 37.731545583255 -122.44947109863001 (37.731545583255, -122.44947109863)
19777 16245 DPW Maintained 3 Chamaerops humilis :: Mediterranean Fan Palm 99 601X Monterey Blvd 1 Median : Cutout 11 Tree 1 DPW 2   02/02/2003 12:00:00 AM 12 5   5997958.54401 2094705.63588 37.7315455832604 -122.44940326996401 (37.7315455832604, -122.449403269964)
173541 206030 DPW Maintained 3 Chamaerops humilis :: Mediterranean Fan Palm 99 501x Monterey Blvd 9 Median : Cutout 11 Tree 1 DPW 2     5 Width 4ft   5998284.310380001 2094699.8261099998 37.7315482605292 -122.44827661909201 (37.7315482605292, -122.448276619092)
149755 206029 DPW Maintained 3 Chamaerops humilis :: Mediterranean Fan Palm 99 501x Monterey Blvd 8 Median : Cutout 11 Tree 1 DPW 2     7 Width 4ft   5998304.86283 2094699.93665 37.731549739012706 -122.448205573546 (37.7315497390127, -122.448205573546)
158983 206028 DPW Maintained 3 Chamaerops humilis :: Mediterranean Fan Palm 99 501x Monterey Blvd 7 Median : Cutout 11 Tree 1 DPW 2     7 Width 4ft   5998324.94212 2094699.61096 37.7315499926202 -122.448136132397 (37.7315499926202, -122.448136132397)
20510 16215 DPW Maintained 3 Chamaerops humilis :: Mediterranean Fan Palm 99 501X Monterey Blvd 2 Median : Cutout 11 Tree 1 DPW 2   02/02/2003 12:00:00 AM 12 5   5998684.93347 2094693.5890400002 37.7315540305774 -122.446891144221 (37.7315540305774, -122.446891144221)
17666 16203 DPW Maintained 3 Chamaerops humilis :: Mediterranean Fan Palm 99 501X Monterey Blvd 3 Median : Cutout 11 Tree 1 DPW 2   02/02/2003 12:00:00 AM 12 5   5998659.38581 2094694.1828400001 37.731554201452106 -122.446979509806 (37.7315542014521, -122.446979509806)
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)
181426 201513 Undocumented 2 Chamaerops humilis :: Mediterranean Fan Palm 99 1001 Innes Ave 11 Sidewalk: Property side : Yard 9 Tree 1 Private 1     1 Width 4ft   6018634.55292 2094871.3359599998 37.7331616173072 -122.377932996723 (37.7331616173072, -122.377932996723)
166097 201509 Undocumented 2 Chamaerops humilis :: Mediterranean Fan Palm 99 1001 Innes Ave 7 Sidewalk: Property side : Yard 9 Tree 1 Private 1     1 Width 4ft   6018596.778580001 2094899.20439 37.73323605689679 -122.378065528029 (37.7332360568968, -122.378065528029)
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)
153857 201507 Undocumented 2 Chamaerops humilis :: Mediterranean Fan Palm 99 1001 Innes Ave 5 Sidewalk: Property side : Yard 9 Tree 1 Private 1     1 Width 4ft   6018590.61876 2094904.2906900002 37.733249683412296 -122.37808717738599 (37.7332496834123, -122.378087177386)
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)
97575 27646 DPW Maintained 3 Chamaerops humilis :: Mediterranean Fan Palm 99 2260 Sloat Blvd 1 Median : Cutout 11 Tree 1 DPW 2   06/06/1999 12:00:00 AM 12 4X4   5983743.832098301 2096000.4658733997 37.7342774634165 -122.498641133162 (37.7342774634165, -122.498641133162)
12298 27647 DPW Maintained 3 Chamaerops humilis :: Mediterranean Fan Palm 99 2300 Sloat Blvd 1 Median : Cutout 11 Tree 1 DPW 2     12 4X4   5983545.7870000005 2096052.8205 37.7344095981993 -122.499329695326 (37.7344095981993, -122.499329695326)
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)
143088 27648 DPW Maintained 3 Chamaerops humilis :: Mediterranean Fan Palm 99 2400 Sloat Blvd 1 Median : Cutout 11 Tree 1 DPW 2   06/06/1999 12:00:00 AM 12 4X4   5983342.3231549 2096264.1854035999 37.7349780102042 -122.50004874464199 (37.7349780102042, -122.500048744642)
147217 186971 DPW Maintained 3 Chamaerops humilis :: Mediterranean Fan Palm 99 2300x Sloat Blvd 2 Median : Cutout 11 Tree 1 DPW 2     9 Width 0ft   5983094.6287 2096334.4526 37.7351564048044 -122.50091029299801 (37.7351564048044, -122.500910292998)
11897 27649 DPW Maintained 3 Chamaerops humilis :: Mediterranean Fan Palm 99 2500 Sloat Blvd 1 Median : Cutout 11 Tree 1 DPW 2   06/06/1999 12:00:00 AM 12 4X4   5982997.5613 2096369.9984 37.7352483041994 -122.501248513045 (37.7352483041994, -122.501248513045)
45626 186972 DPW Maintained 3 Chamaerops humilis :: Mediterranean Fan Palm 99 2500x Sloat Blvd 2 Median : Cutout 11 Tree 1 DPW 2     6 Width 0ft   5982510.8573 2096452.0272 37.7354449395599 -122.50293726958999 (37.7354449395599, -122.50293726959)
10585 27651 DPW Maintained 3 Chamaerops humilis :: Mediterranean Fan Palm 99 2700 Sloat Blvd 1 Median : Cutout 11 Tree 1 DPW 2   06/06/1999 12:00:00 AM 12 4X4   5982420.6256 2096461.5972 37.73546591249 -122.503249937577 (37.73546591249, -122.503249937577)
10607 27653 DPW Maintained 3 Chamaerops humilis :: Mediterranean Fan Palm 99 2900X Sloat Blvd 1 Median : Cutout 11 Tree 1 DPW 2   06/06/1999 12:00:00 AM 12 4X4   5981776.6997 2096484.8387 37.7354918543068 -122.505477915571 (37.7354918543068, -122.505477915571)
106072 27650 DPW Maintained 3 Chamaerops humilis :: Mediterranean Fan Palm 99 2650 Sloat Blvd 1 Median : Cutout 11 Tree 1 DPW 2   06/06/1999 12:00:00 AM 12 4X4   5982609.4890242005 2096515.7957863999 37.735625827225796 -122.502600986809 (37.7356258272258, -122.502600986809)
78812 27652 DPW Maintained 3 Chamaerops humilis :: Mediterranean Fan Palm 99 2830 Sloat Blvd 1 Median : Cutout 11 Tree 1 DPW 2   06/06/1999 12:00:00 AM 12 4X4   5982048.7143342 2096528.9941474 37.7356290969828 -122.50454074467 (37.7356290969828, -122.50454074467)
79507 27654 DPW Maintained 3 Chamaerops humilis :: Mediterranean Fan Palm 99 2968 Sloat Blvd 1 Median : Cutout 11 Tree 1 DPW 2   06/06/1999 12:00:00 AM 12 4X4   5981673.036337901 2096540.7284095 37.7356392111548 -122.50584045491001 (37.7356392111548, -122.50584045491)
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)
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)
150545 225149 Undocumented 2 Chamaerops humilis :: Mediterranean Fan Palm 99 369 Prentiss St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     13 Width 2ft   6008818.14298 2097106.89478 37.7387541440918 -122.41202902491999 (37.7387541440918, -122.41202902492)
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)
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)
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)
159626 206047 Undocumented 2 Chamaerops humilis :: Mediterranean Fan Palm 99 575 Rockdale Dr 1 Sidewalk: Property side : Yard 9 Tree 1 Private 1     6 Width 3ft   5997894.62452 2097851.39191 37.7401794193521 -122.449850874237 (37.7401794193521, -122.449850874237)
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)
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)
148481 225146 Undocumented 2 Chamaerops humilis :: Mediterranean Fan Palm 99 1706 Dolores St 3 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     10 Width 6ft   6005275.161069999 2098395.65522 37.7420933673216 -122.424370639893 (37.7420933673216, -122.424370639893)
17649 30005 DPW Maintained 3 Chamaerops humilis :: Mediterranean Fan Palm 99 795X San Jose Ave 1 Median : Cutout 11 Tree 1 DPW 2   03/24/2007 12:00:00 AM 3 3x3   6005615.08127 2098546.14287 37.7425257613504 -122.423205996259 (37.7425257613504, -122.423205996259)
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)
19998 30014 DPW Maintained 3 Chamaerops humilis :: Mediterranean Fan Palm 99 738X San Jose Ave 6 Median : Cutout 11 Tree 1 DPW 2   03/24/2007 12:00:00 AM 3 3x3   6005753.20487 2098967.8779700003 37.7436915444264 -122.422758369527 (37.7436915444264, -122.422758369527)
21577 30015 DPW Maintained 3 Chamaerops humilis :: Mediterranean Fan Palm 99 738X San Jose Ave 7 Median : Cutout 11 Tree 1 DPW 2   03/24/2007 12:00:00 AM 3 3x3   6005757.33905 2098980.75435 37.7437271333024 -122.422744989392 (37.7437271333024, -122.422744989392)
150087 225171 Undocumented 2 Chamaerops humilis :: Mediterranean Fan Palm 99 106 Coleridge St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     6 Width 3ft   6006678.67564 2099088.45084 37.7440747833339 -122.419566860849 (37.7440747833339, -122.419566860849)
21753 7651 DPW Maintained 3 Chamaerops humilis :: Mediterranean Fan Palm 99 3309 Folsom St 2 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     18 4X4   6008514.76673 2099315.4507400002 37.7448013267216 -122.413234094881 (37.7448013267216, -122.413234094881)
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)
20789 29999 DPW Maintained 3 Chamaerops humilis :: Mediterranean Fan Palm 99 681X San Jose Ave 13 Median : Cutout 11 Tree 1 DPW 2   03/24/2007 12:00:00 AM 3 3x3   6005890.72277 2099411.68829 37.7449179049514 -122.422314391296 (37.7449179049514, -122.422314391296)
148722 225150 Undocumented 2 Chamaerops humilis :: Mediterranean Fan Palm 99 21 Prospect Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     6 Width 2ft   6007236.93234 2099402.00378 37.744967159016596 -122.417658748554 (37.7449671590166, -122.417658748554)
17378 29984 DPW Maintained 3 Chamaerops humilis :: Mediterranean Fan Palm 99 1622X Guerrero St 5 Median : Cutout 11 Tree 1 DPW 2   03/24/2007 12:00:00 AM 3 3x3   6005923.58357 2099590.01571 37.7454094051301 -122.422213431617 (37.7454094051301, -122.422213431617)
35962 225200 DPW Maintained 3 Chamaerops humilis :: Mediterranean Fan Palm 99 1622x Guerrero St 6 Median : Cutout 11 Tree 1 DPW 2     7 Width 3ft   6005924.11488 2099598.76228 37.74543345119329 -122.42221221572599 (37.7454334511933, -122.422212215726)
149483 225211 Undocumented 2 Chamaerops humilis :: Mediterranean Fan Palm 99 83 Tiffany Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     17 Width 4ft   6006284.028469999 2099592.34977 37.74543613838021 -122.42096723475402 (37.7454361383802, -122.420967234754)
19536 29706 DPW Maintained 3 Chamaerops humilis :: Mediterranean Fan Palm 99 1594X Guerrero St 1 Median : Cutout 11 Tree 1 DPW 2   03/30/2006 12:00:00 AM 3     6005915.3087 2099718.0441099997 37.745760475271204 -122.422251139273 (37.7457604752712, -122.422251139273)
20337 29707 DPW Maintained 3 Chamaerops humilis :: Mediterranean Fan Palm 99 1594X Guerrero St 2 Median : Cutout 11 Tree 1 DPW 2   03/30/2006 12:00:00 AM 3     6005916.90216 2099727.1189900003 37.74578548271 -122.422246273943 (37.74578548271, -122.422246273943)
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)
131163 225201 DPW Maintained 3 Chamaerops humilis :: Mediterranean Fan Palm 99 1594x Guerrero St 11 Median : Cutout 11 Tree 1 DPW 2     6 Width 3ft   6005907.02025 2099862.53576 37.7461567489521 -122.422290063739 (37.7461567489521, -122.422290063739)
52220 225202 DPW Maintained 3 Chamaerops humilis :: Mediterranean Fan Palm 99 1594x Guerrero St 12 Median : Cutout 11 Tree 1 DPW 2     6 Width 3ft   6005906.49686 2099871.3036700003 37.7461807941146 -122.422292496403 (37.7461807941146, -122.422292496403)
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)
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)
183926 225156 Undocumented 2 Chamaerops humilis :: Mediterranean Fan Palm 99 104 Franconia St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     10 Width 2ft   6010015.03813 2099834.46528 37.746310541115896 -122.408083012937 (37.7463105411159, -122.408083012937)
157715 225155 Undocumented 2 Chamaerops humilis :: Mediterranean Fan Palm 99 104 Franconia St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     10 Width 2ft   6010008.90641 2099846.42229 37.7463430291237 -122.40810505891199 (37.7463430291237, -122.408105058912)
172815 225154 Undocumented 2 Chamaerops humilis :: Mediterranean Fan Palm 99 104 Franconia St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     8 Width 2ft   6010002.80385 2099859.8218 37.7463794795488 -122.40812710578999 (37.7463794795488, -122.40812710579)
27590 225203 DPW Maintained 3 Chamaerops humilis :: Mediterranean Fan Palm 99 1534x Guerrero St 2 Median : Cutout 11 Tree 1 DPW 2     6 Width 3ft   6005899.22105 2100030.8366400003 37.746618424914296 -122.422328988218 (37.7466184249143, -122.422328988218)
18341 29708 DPW Maintained 3 Chamaerops humilis :: Mediterranean Fan Palm 99 1534X Guerrero St 3 Median : Cutout 11 Tree 1 DPW 2   03/30/2006 12:00:00 AM 6     6005897.61494 2100055.38982 37.746685751754605 -122.422336286217 (37.7466857517546, -122.422336286217)
21879 29710 DPW Maintained 3 Chamaerops humilis :: Mediterranean Fan Palm 99 1534X Guerrero St 5 Median : Cutout 11 Tree 1 DPW 2   03/30/2006 12:00:00 AM 3     6005894.4456400005 2100106.5973900002 37.7468261772965 -122.422350883111 (37.7468261772965, -122.422350883111)
17658 29711 DPW Maintained 3 Chamaerops humilis :: Mediterranean Fan Palm 99 1534X Guerrero St 6 Median : Cutout 11 Tree 1 DPW 2   03/30/2006 12:00:00 AM 6     6005892.92513 2100118.18846 37.7468579179619 -122.422356964326 (37.7468579179619, -122.422356964326)
19578 29700 DPW Maintained 3 Chamaerops humilis :: Mediterranean Fan Palm 99 1488X Guerrero St 2 Median : Cutout 11 Tree 1 DPW 2   03/30/2006 12:00:00 AM 6     6005880.5001300005 2100335.27269 37.747453280849 -122.422415350984 (37.747453280849, -122.422415350984)
21912 29701 DPW Maintained 3 Chamaerops humilis :: Mediterranean Fan Palm 99 1488X Guerrero St 3 Median : Cutout 11 Tree 1 DPW 2   03/30/2006 12:00:00 AM 6     6005878.92208 2100344.0622799997 37.7474773260372 -122.42242143222201 (37.7474773260372, -122.422421432222)
17470 29703 DPW Maintained 3 Chamaerops humilis :: Mediterranean Fan Palm 99 1488X Guerrero St 5 Median : Cutout 11 Tree 1 DPW 2   03/30/2006 12:00:00 AM 6     6005875.752859999 2100395.2692 37.7476177497694 -122.42243602910901 (37.7476177497694, -122.422436029109)
22275 29704 DPW Maintained 3 Chamaerops humilis :: Mediterranean Fan Palm 99 1488X Guerrero St 6 Median : Cutout 11 Tree 1 DPW 2   03/30/2006 12:00:00 AM 6     6005876.958869999 2100402.60074 37.7476379485377 -122.422432379649 (37.7476379485377, -122.422432379649)
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)
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)
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)
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)
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)
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)
176930 225167 Undocumented 2 Chamaerops humilis :: Mediterranean Fan Palm 99 338 Hoffman Ave 6 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     7 Width 4ft   6000621.34497 2101755.16217 37.7510538776544 -122.44070294699699 (37.7510538776544, -122.440702946997)
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)
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)
176416 225206 Undocumented 2 Chamaerops humilis :: Mediterranean Fan Palm 99 3816 24th St 1 Sidewalk: Curb side : Pot 10 Tree 1 Private 1     5 Width 3ft   6004315.95235 2101927.5657 37.751736964897106 -122.427938900685 (37.7517369648971, -122.427938900685)
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)

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