Street_Tree_List

Data source: data.sfgov.org

217 rows where qSiteInfo = 2 and qSpecies = 18 sorted by Longitude

View and edit SQL

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

qSiteInfo

  • Sidewalk: Curb side : Yard · 217
Link rowid TreeID qLegalStatus qSpecies qAddress SiteOrder qSiteInfo PlantType qCaretaker qCareAssistant PlantDate DBH PlotSize PermitNotes XCoord YCoord Latitude Longitude ▼ Location
67642 118478 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 578 48th Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     8 Width 3ft   5981024.51617 2111800.84509 37.7775009394111 -122.509215478972 (37.7775009394111, -122.509215478972)
185931 118627 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 494 46th Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     3 Width 3ft   5981628.0956 2112437.91019 37.7792856992778 -122.50717480668301 (37.7792856992778, -122.507174806683)
75705 250820 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 60 Sea View Ter 3 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     1 Width 4ft   5986182.97775 2114165.47247 37.7842963089586 -122.49154499381599 (37.7842963089586, -122.491544993816)
153946 250819 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 60 Sea View Ter 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     1 Width 4ft   5986191.04243 2114164.9353 37.7842953053345 -122.49151705368999 (37.7842953053345, -122.49151705369)
40381 250676 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 735 El Camino Del Mar 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     6 Width 4ft   5986293.297259999 2114811.88275 37.786077611448 -122.49121092176 (37.786077611448, -122.49121092176)
178867 250677 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 735 El Camino Del Mar 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     7 Width 4ft   5986302.66224 2114812.53014 37.78607993617911 -122.49117856955 (37.7860799361791, -122.49117856955)
166433 250875 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 125 30th Ave 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     5 Width 4ft   5986467.14332 2114671.0752 37.7857011507179 -122.490599105783 (37.7857011507179, -122.490599105783)
71891 250874 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 125 30th Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     3 Width 4ft   5986467.3841 2114682.3933599996 37.7857322411853 -122.490599105779 (37.7857322411853, -122.490599105779)
56077 250876 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 125 30th Ave 3 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     5 Width 4ft   5986468.29527 2114661.08637 37.7856737915584 -122.490594385245 (37.7856737915584, -122.490594385245)
132130 250868 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 133 30th Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     5 Width 4ft   5986468.4993 2114649.30576 37.7856414573183 -122.490592812321 (37.7856414573183, -122.490592812321)
180995 250869 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 133 30th Ave 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     6 Width 4ft   5986468.30668 2114640.25117 37.785616584774104 -122.490592812307 (37.7856165847741, -122.490592812307)
166651 250870 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 133 30th Ave 3 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     6 Width 4ft   5986470.3680300005 2114630.24299 37.7855892256034 -122.490584944137 (37.7855892256034, -122.490584944137)
70024 250882 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 154 29th Ave 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     13 Width 4ft   5986822.39512 2114740.35297 37.7859121118945 -122.48937514824699 (37.7859121118945, -122.489375148247)
172451 250881 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 154 29th Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     8 Width 4ft   5986823.250630001 2114733.9114599996 37.78589447530229 -122.489371714655 (37.7858944753023, -122.489371714655)
126747 250902 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 266 29th Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     10 Width 4ft   5986843.33005 2114156.49339 37.7843102232907 -122.489259776936 (37.7843102232907, -122.489259776936)
57812 250934 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 259 28th Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     7 Width 4ft   5987104.958930001 2114216.89652 37.7844913413477 -122.48835908522699 (37.7844913413477, -122.488359085227)
39369 250521 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 95 26th Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     7 Width 6ft   5987685.5238 2115445.0256 37.787897288863796 -122.48644075485201 (37.7878972888638, -122.486440754852)
26752 250523 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 95 26th Ave 3 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     7 Width 6ft   5987685.92853 2115397.50584 37.78776683682629 -122.48643586433998 (37.7877668368263, -122.48643586434)
132655 250524 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 95 26th Ave 4 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     7 Width 6ft   5987685.45058 2115374.99193 37.7877049922276 -122.486435864334 (37.7877049922276, -122.486435864334)
32529 120326 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 738 23rd Ave 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     3 Width 2ft   5988846.16685 2110288.25768 37.773805837099 -122.48204727167901 (37.773805837099, -122.482047271679)
129524 120701 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 70 22nd Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     13 Width 5ft   5988982.8407 2114887.49266 37.7864419959893 -122.48191147245501 (37.7864419959893, -122.481911472455)
153167 214491 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 1908 16th Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     4 Width 3ft   5991283.85529 2102380.71309 37.752235304435395 -122.473038230333 (37.7522353044354, -122.473038230333)
177005 214490 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 2083 16th Ave 3 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     1 Width 3ft   5991275.47389 2101260.33758 37.7491585600375 -122.47298552109 (37.7491585600375, -122.47298552109)
34050 214489 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 2083 16th Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     1 Width 3ft   5991276.32219 2101284.43599 37.7492247771203 -122.47298434476801 (37.7492247771203, -122.472984344768)
4797 214559 DPW Maintained 3 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 1342 Irving St 1 Sidewalk: Curb side : Yard 2 Tree 1 DPW 2   02/18/2009 12:00:00 AM 3 Width 3ft   5991532.56497 2106606.32246 37.7638521099028 -122.472486197695 (37.7638521099028, -122.472486197695)
4821 214558 DPW Maintained 3 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 1340 Irving St 1 Sidewalk: Curb side : Yard 2 Tree 1 DPW 2   02/18/2009 12:00:00 AM 4 Width 3ft   5991564.93185 2106609.34919 37.7638622938456 -122.472374472204 (37.7638622938456, -122.472374472204)
147395 213428 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 2356 Cecilia Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     7 Width 3ft   5991465.99867 2099400.33215 37.744062494091 -122.472191126522 (37.744062494091, -122.472191126522)
69144 213433 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 2326 Cecilia Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     8 Width 3ft   5991473.33081 2099563.7503299997 37.74451162271421 -122.47217768345699 (37.7445116227142, -122.472177683457)
179381 213434 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 2326 Cecilia Ave 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     1 Width 3ft   5991474.66936 2099581.1439400003 37.7445594585564 -122.47217432268499 (37.7445594585564, -122.472174322685)
47537 213432 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 2330 Cecilia Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     7 Width 3ft   5991474.23883 2099545.3415099997 37.744461129378 -122.472173202136 (37.744461129378, -122.472173202136)
146881 213437 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 2316 Cecilia Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     10 Width 3ft   5991477.149780001 2099652.715 37.7447561178165 -122.47217096194599 (37.7447561178165, -122.472170961946)
179415 213431 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 2336 Cecilia Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     7 Width 3ft   5991475.01091 2099520.48282 37.74439291849001 -122.472168720814 (37.74439291849, -122.472168720814)
71505 213438 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 2310 Cecilia Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     7 Width 3ft   5991478.325209999 2099662.36916 37.7447826936787 -122.472167601152 (37.7447826936787, -122.472167601152)
66957 213435 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 2320 Cecilia Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     12 Width 3ft   5991477.88555 2099610.75787 37.744640956913706 -122.47216536005699 (37.7446409569137, -122.472165360057)
45175 213430 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 2340 Cecilia Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     11 Width 3ft   5991476.167830001 2099498.51961 37.7443326801156 -122.47216311983401 (37.7443326801156, -122.472163119834)
177855 213439 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 2306 Cecilia Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     11 Width 3ft   5991480.5494800005 2099691.03581 37.7448615336422 -122.47216199929501 (37.7448615336422, -122.472161999295)
166260 213436 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 2320 Cecilia Ave 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     10 Width 3ft   5991479.35771 2099619.1153 37.7446639894614 -122.47216087873899 (37.7446639894614, -122.472160878739)
176624 213429 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 2344 Cecilia Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     4 Width 3ft   5991482.19388 2099461.6129099997 37.7442316925378 -122.472139593583 (37.7442316925378, -122.472139593583)
160563 213398 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 621 Quintara St 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     2 Width 3ft   5991517.42633 2101098.4611299997 37.7487280941444 -122.472137056592 (37.7487280941444, -122.472137056592)
51380 213399 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 621 Quintara St 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     2 Width 3ft   5991532.61986 2101100.8826900003 37.74873562236029 -122.472084694454 (37.7487356223603, -122.472084694454)
42855 213400 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 621 Quintara St 3 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     2 Width 3ft   5991548.4151099995 2101099.1787400004 37.7487318577911 -122.472029950926 (37.7487318577911, -122.472029950926)
40670 213401 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 621 Quintara St 4 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     2 Width 3ft   5991567.73676 2101101.51332 37.7487393860095 -122.47196330756 (37.7487393860095, -122.47196330756)
37368 213397 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 2011 15th Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     2 Width 3ft   5991583.99315 2101696.28864 37.7503734254013 -122.47195043737301 (37.7503734254013, -122.471950437373)
77124 123052 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 544 Funston Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     4 Width 4ft   5991924.81576 2111692.51922 37.7778401329349 -122.471500177083 (37.7778401329349, -122.471500177083)
51860 123039 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 586 Funston Ave 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     7 Width 4ft   5991933.9124300005 2111475.88268 37.777245834278 -122.47145291941601 (37.777245834278, -122.471452919416)
175798 123040 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 586 Funston Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     3 Width 4ft   5991933.82363 2111460.09457 37.7772024792906 -122.47145207590499 (37.7772024792906, -122.471452075905)
53702 218238 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 333 Wawona St 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     3 Width 2ft   5992020.14039 2097188.56235 37.738021590525996 -122.47011402534599 (37.738021590526, -122.470114025346)
160348 218239 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 333 Wawona St 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     1 Width 2ft   5992027.82558 2097196.10935 37.738042756963296 -122.47008800346599 (37.7380427569633, -122.470088003466)
163946 218240 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 329 Wawona St 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     10 Width 2ft   5992041.06009 2097211.89095 37.7380868543242 -122.470043394412 (37.7380868543242, -122.470043394412)
29095 218241 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 329 Wawona St 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     8 Width 2ft   5992046.53731 2097216.7007400002 37.7381003774208 -122.470024807225 (37.7381003774208, -122.470024807225)
72276 218242 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 325 Wawona St 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     6 Width 2ft   5992065.00246 2097235.79822 37.738153881691 -122.46996235468599 (37.738153881691, -122.469962354686)
168210 218135 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 0 Noriega St 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     3 Width 0ft   5992409.03176 2103467.31015 37.7552838973381 -122.469226308173 (37.7552838973381, -122.469226308173)
141430 117091 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 2X 09TH AVE 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     3 3x3   5993083.0 2114893.0 37.7866947153523 -122.46772647285 (37.7866947153523, -122.46772647285)
36267 214778 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 1725 Monterey Blvd 3 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     3 Width 4ft   5992728.97885 2095354.01208 37.7330253277621 -122.467529868417 (37.7330253277621, -122.467529868417)
184698 213460 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 360 Dorantes Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     3 Width 3ft   5992857.49918 2099683.78553 37.7449212153419 -122.46740027790199 (37.7449212153419, -122.467400277902)
164635 214779 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 1723 Monterey Blvd 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     6 Width 4ft   5992800.25839 2095349.1682799999 37.7330161429665 -122.467283086348 (37.7330161429665, -122.467283086348)
54107 214780 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 1723 Monterey Blvd 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     4 Width 4ft   5992818.43379 2095348.2287 37.7330146123238 -122.467220181466 (37.7330146123238, -122.467220181466)
187309 214781 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 1723 Monterey Blvd 3 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     5 Width 4ft   5992834.3473 2095346.2214400002 37.733010019498 -122.467165018866 (37.733010019498, -122.467165018866)
41345 213459 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 331 Dorantes Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     8 Width 3ft   5992964.35444 2099654.10226 37.7448458809298 -122.467028637559 (37.7448458809298, -122.467028637559)
49260 213458 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 331 Dorantes Ave 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     2 Width 3ft   5992978.54855 2099656.27544 37.7448526672074 -122.46697971536301 (37.7448526672074, -122.466979715363)
62002 214782 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 1627 Monterey Blvd 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     7 Width 4ft   5992928.85631 2095341.1686900002 37.733001600925 -122.466837912033 (37.733001600925, -122.466837912033)
3800 213446 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 530 Magellan Ave 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     5 Width 3ft   5993033.55222 2099443.36305 37.744271238444206 -122.46677405027799 (37.7442712384442, -122.466774050278)
66724 213447 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 526 Magellan Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     3 Width 3ft   5993054.572480001 2099444.94374 37.744276791733704 -122.46670148220899 (37.7442767917337, -122.466701482209)
135808 213461 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 314 Dorantes Ave 3 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     5 Width 3ft   5993060.97049 2099698.9583900003 37.744974620699 -122.466697820147 (37.744974620699, -122.466697820147)
27459 213462 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 314 Dorantes Ave 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     8 Width 3ft   5993067.05595 2099698.4128799997 37.7449734740606 -122.46667673826201 (37.7449734740606, -122.466676738262)
35919 213457 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 315 Dorantes Ave 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     8 Width 3ft   5993075.78823 2099665.10758 37.7448825301024 -122.466644123432 (37.7448825301024, -122.466644123432)
38356 213463 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 314 Dorantes Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     6 Width 3ft   5993094.88579 2099699.80528 37.7449789032567 -122.46658060972 (37.7449789032567, -122.46658060972)
3683 213464 Permitted Site 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 300 Dorantes Ave 3 Sidewalk: Curb side : Yard 2 Tree 1 Private 1   10/24/2005 12:00:00 AM 2 Width 3ft Permit Number 48287 5993110.29995 2099700.9644 37.7449829754007 -122.46652739502701 (37.7449829754007, -122.466527395027)
24441 213456 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 305 Dorantes Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     12 Width 3ft   5993116.56669 2099668.45247 37.7448940675206 -122.46650336333799 (37.7448940675206, -122.466503363338)
47504 213455 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 305 Dorantes Ave 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     15 Width 3ft   5993130.50239 2099670.13691 37.744899496712996 -122.466455299074 (37.744899496713, -122.466455299074)
69966 213454 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 305 Dorantes Ave 3 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     13 Width 3ft   5993143.6886 2099671.5901599997 37.744904247849604 -122.46640980957899 (37.7449042478496, -122.466409809579)
39553 213453 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 305 Dorantes Ave 4 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     7 Width 3ft   5993154.524540001 2099672.2697099997 37.7449067389721 -122.46637239059099 (37.7449067389721, -122.466372390591)
58558 213452 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 305 Dorantes Ave 5 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     5 Width 3ft   5993170.15918 2099666.95184 37.7448930395731 -122.466317942932 (37.7448930395731, -122.466317942932)
23557 213451 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 4 Cortes Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     11 Width 3ft   5993177.52134 2099659.6696900004 37.7448734694269 -122.466291957027 (37.7448734694269, -122.466291957027)
56005 213450 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 4 Cortes Ave 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     8 Width 3ft   5993181.54452 2099646.75602 37.744838243897206 -122.46627710741801 (37.7448382438972, -122.466277107418)
180675 213449 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 4 Cortes Ave 3 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     13 Width 3ft   5993183.71921 2099631.03001 37.7447951897395 -122.466268445152 (37.7447951897395, -122.466268445152)
3822 253559 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 4 Cortes Ave 5 Sidewalk: Curb side : Yard 2 Tree 1 Private 1       Width 3ft   5993184.39566 2099612.1282900004 37.7447433294416 -122.46626473273199 (37.7447433294416, -122.466264732732)
168168 213448 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 4 Cortes Ave 4 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     2 Width 3ft   5993184.39566 2099612.1282900004 37.7447433294416 -122.46626473273199 (37.7447433294416, -122.466264732732)
186426 214765 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 98 Sotelo Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     5 Width 4ft   5993613.7342 2101408.96874 37.7497017595309 -122.464910643325 (37.7497017595309, -122.464910643325)
124363 214772 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 96 Sotelo Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     5 Width 4ft   5993626.401000001 2101411.46451 37.7497093426138 -122.46486702261801 (37.7497093426138, -122.464867022618)
29824 214773 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 92 Sotelo Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     5 Width 4ft   5993651.47421 2101409.8267 37.74970629121471 -122.464780200252 (37.7497062912147, -122.464780200252)
137946 214774 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 88 Sotelo Ave 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     8 Width 4ft   5993702.75991 2101413.55838 37.7497194941621 -122.464603124653 (37.7497194941621, -122.464603124653)
149609 213602 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 47 Santa Rita Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     4 Width 3ft   5993779.00092 2100704.49945 37.7477769936179 -122.46428801028799 (37.7477769936179, -122.464288010288)
165881 213595 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 444 08th Ave 3 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     10 Width 3ft   5993843.0022599995 2101824.40238 37.7508556508809 -122.46414798674999 (37.7508556508809, -122.46414798675)
59606 213596 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 444 08th Ave 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     14 Width 3ft   5993850.8496 2101807.31108 37.7508091748166 -122.46411960953199 (37.7508091748166, -122.464119609532)
36134 213597 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 444 Pacheco St 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     13 Width 3ft   5993860.18599 2101791.35553 37.750765903044794 -122.46408616556299 (37.7507659030448, -122.464086165563)
34957 214766 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 101 Alton Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     3 Width 3ft   5993866.28574 2101627.27037 37.7503157185921 -122.464053162237 (37.7503157185921, -122.464053162237)
136766 213470 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 396 Magellan Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     6 Width 3ft   5993853.55379 2099589.61797 37.7447201080625 -122.463949296841 (37.7447201080625, -122.463949296841)
76027 213474 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 125 Dorantes Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     2 Width 3ft   5993866.67958 2099897.14622 37.7455652594364 -122.463926229234 (37.7455652594364, -122.463926229234)
47141 213471 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 390 Magellan Ave 3 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     8 Width 3ft   5993863.77689 2099599.9221099997 37.744748989783 -122.463914695418 (37.744748989783, -122.463914695418)
187534 213472 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 390 Magellan Ave 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     5 Width 3ft   5993869.43858 2099604.78571 37.744762670277204 -122.463895471497 (37.7447626702772, -122.463895471497)
100884 214775 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 36 Sotelo Ave 3 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     2 Width 4ft   5993929.10229 2101145.39334 37.7489962269912 -122.463800968038 (37.7489962269912, -122.463800968038)
33752 214776 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 36 Sotelo Ave 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     5 Width 4ft   5993929.139169999 2101136.44437 37.7489716575191 -122.463800191051 (37.7489716575191, -122.463800191051)
49667 214777 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 36 Sotelo Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     2 Width 4ft   5993930.07421 2101127.47655 37.7489470880465 -122.46379630688101 (37.7489470880465, -122.463796306881)
152578 213473 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 45 Dorantes Ave 6 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     2 Width 3ft   5994145.2265 2100030.80799 37.7459483094686 -122.462972759886 (37.7459483094686, -122.462972759886)
135745 214813 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 349 Kensington Way 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     6 Width 4ft   5994166.60375 2099059.892 37.7432836497201 -122.46282841600599 (37.7432836497201, -122.462828416006)
176517 214814 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 349 Kensington Way 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     8 Width 4ft   5994180.976419999 2099052.1679700003 37.7432632692845 -122.462778159201 (37.7432632692845, -122.462778159201)
152202 214767 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 333 Pacheco St 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     1 Width 4ft   5994252.85515 2100808.3467 37.7480894333884 -122.462656990837 (37.7480894333884, -122.462656990837)
163386 214771 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 330 Forest Hill Path 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     4 Width 3ft   5994272.06767 2100993.3623099998 37.748598545893394 -122.46260397398999 (37.7485985458934, -122.46260397399)
61123 213601 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 35 Alton Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     9 Width 3ft   5994302.03638 2101543.53453 37.7501109051904 -122.462540245329 (37.7501109051904, -122.462540245329)

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