2,694 rows where qSpecies_id = 84 sorted by qCaretaker_id

View and edit SQL

rowid TreeID qLegalStatus_id qSpecies_id qAddress SiteOrder qSiteInfo PlantType qCaretaker_id ▼ qCareAssistant PlantDate DBH PlotSize PermitNotes XCoord YCoord Latitude Longitude Location Fire Prevention Districts Police Districts Supervisor Districts Zip Codes Neighborhoods (old)
282 119806 DPW Maintained 1 Prunus serrulata :: Ornamental Cherry 84 251X Octavia St Frontage West 3 Sidewalk: Curb side : Cutout Tree DPW 1       3x3   6005545 2110174 37.7744491774234 -122.424275134654 (37.7744491774234, -122.424275134654) 7 9 11 28852 10
339 18096 DPW Maintained 1 Prunus serrulata :: Ornamental Cherry 84 3008 Pine St 1 Sidewalk: Curb side : Cutout Tree DPW 1   01/29/1997 12:00:00 AM 6 3X3   5999424.6928 2114682.6521 37.7864812852303 -122.445770680231 (37.7864812852303, -122.445770680231) 15 6 1 29490 31
1086 91876 DPW Maintained 1 Prunus serrulata :: Ornamental Cherry 84 700 Irving St 4 Sidewalk: Curb side : Cutout Tree DPW 1   10/03/2015 02:50:00 PM 3 3x3   5993617.143263 2106666.291015 37.7641372031802 -122.465280687147 (37.7641372031802, -122.465280687147) 11 8 11 56 12
1474 86100 DPW Maintained 1 Prunus serrulata :: Ornamental Cherry 84 2628 24th Ave 1 Sidewalk: Curb side : Cutout Tree DPW 1   01/16/2007 12:00:00 AM 3 3x3   5988972.7801 2097431.8111 37.738512846905 -122.480667939289 (37.738512846905, -122.480667939289) 1 8 3 29491 35
1668 86560 DPW Maintained 1 Prunus serrulata :: Ornamental Cherry 84 1887 27th Ave 1 Sidewalk: Curb side : Cutout Tree DPW 1   12/28/2006 12:00:00 AM 6 3x3   5987821.2541 2102469.8936 37.7522790893532 -122.485018839299 (37.7522790893532, -122.485018839299) 1 8 3 56 35
3027 214407 DPW Maintained 1 Prunus serrulata :: Ornamental Cherry 84 200x Terrace Dr 11 Median : Yard Tree DPW 1     8     5993812.00581 2096497.75562 37.7362282335302 -122.463868579087 (37.7362282335302, -122.463868579087) 1 8 4 59 40
3849 27720 DPW Maintained 1 Prunus serrulata :: Ornamental Cherry 84 1300X Cesar Chavez St 2 Sidewalk: Curb side : Cutout Tree DPW 1   04/11/2015 06:49:00 AM 3 3X3   6015137.8598649 2101142.4987414 37.7501876266135 -122.390460137824 (37.7501876266135, -122.390460137824) 10 3 8 28856 1
4233 27745 DPW Maintained 1 Prunus serrulata :: Ornamental Cherry 84 1399 Cesar Chavez St 6 Sidewalk: Curb side : Cutout Tree DPW 1   03/23/2006 12:00:00 AM 3 3X3   6014867.8526066 2101105.5872465 37.7500712934283 -122.391391267014 (37.7500712934283, -122.391391267014) 10 3 8 28856 1
4516 259272 DPW Maintained 1 Prunus serrulata :: Ornamental Cherry 84 1705 Powell St 1 Sidewalk: Curb side : Cutout Tree DPW 1   05/25/2019 12:00:00 AM 3     6009597.7323 2119503.87292 37.8002947722719 -122.410914999374 (37.8002947722719, -122.410914999374) 3 1 10 308 4
4740 119761 DPW Maintained 1 Prunus serrulata :: Ornamental Cherry 84 101X Octavia St Frontage West 3 Sidewalk: Curb side : Cutout Tree DPW 1       4x4                      
6602 89550 DPW Maintained 1 Prunus serrulata :: Ornamental Cherry 84 5539 Anza St 1 Sidewalk: Curb side : Cutout Tree DPW 1   03/27/2008 12:00:00 AM 3 3x3   5981409.78222 2111623.31383 37.7770361978186 -122.507869561004 (37.7770361978186, -122.507869561004) 11 6 2 55 26
6947 23903 DPW Maintained 1 Prunus serrulata :: Ornamental Cherry 84 1600X Webster St 6 Median : Cutout Tree DPW 1     3 6   6003560.4697 2114360.5617 37.7858321751093 -122.431438928251 (37.7858321751093, -122.431438928251) 13 9 11 29490 13
7392 261325 DPW Maintained 1 Prunus serrulata :: Ornamental Cherry 84 644 Broadway 1 Sidewalk: Curb side : Cutout Tree DPW 1       3x3   6010473 2118597 37.79785376133 -122.407822230627 (37.79785376133, -122.407822230627) 3 1 10 308 4
7546 86580 DPW Maintained 1 Prunus serrulata :: Ornamental Cherry 84 2539 27th Ave 1 Sidewalk: Curb side : Cutout Tree DPW 1   01/05/2007 12:00:00 AM 3 3x3   5987975.8922 2098002.1559 37.7400208741264 -122.484156469463 (37.7400208741264, -122.484156469463) 1 8 3 29491 35
7569 86577 DPW Maintained 1 Prunus serrulata :: Ornamental Cherry 84 2519 27th Ave 1 Sidewalk: Curb side : Cutout Tree DPW 1   01/05/2007 12:00:00 AM 3 3x3   5987971.7931 2098127.9672 37.740366080244 -122.484179866453 (37.740366080244, -122.484179866453) 1 8 3 29491 35
7650 28640 DPW Maintained 1 Prunus serrulata :: Ornamental Cherry 84 1300 Webster St 2 Median : Cutout Tree DPW 1   04/21/2008 12:00:00 AM 3 20   6003714.7015 2113244.5448 37.7827766127993 -122.430825656777 (37.7827766127993, -122.430825656777) 15 9 11 29490 41
8717 119762 DPW Maintained 1 Prunus serrulata :: Ornamental Cherry 84 101X Octavia St Frontage West 4 Sidewalk: Curb side : Cutout Tree DPW 1       4x4                      
9212 259382 DPW Maintained 1 Prunus serrulata :: Ornamental Cherry 84 225 Whipple Ave 2 Sidewalk: Curb side : Cutout Tree DPW 1       3x3   5997701 2087724 37.7123609051901 -122.449790697309 (37.7123609051901, -122.449790697309) 9 7 6 28861 25
9471 119842 DPW Maintained 1 Prunus serrulata :: Ornamental Cherry 84 350 Octavia St Frontage East 2 Sidewalk: Curb side : Cutout Tree DPW 1       4x4   6005602 2110303 37.774806598562 -122.424087136382 (37.774806598562, -122.424087136382) 7 9 11 28852 10
10081 119760 DPW Maintained 1 Prunus serrulata :: Ornamental Cherry 84 101X Octavia St Frontage West 2 Sidewalk: Curb side : Cutout Tree DPW 1       4x4                      
10332 86369 DPW Maintained 1 Prunus serrulata :: Ornamental Cherry 84 1281 26th Ave 1 Sidewalk: Curb side : Cutout Tree DPW 1   12/20/2006 12:00:00 AM 3 3x3   5987992.2676 2106611.2343 37.7636600473858 -122.484731221945 (37.7636600473858, -122.484731221945) 1 8 3 56 35
11347 85990 DPW Maintained 1 Prunus serrulata :: Ornamental Cherry 84 2234 28th Ave 1 Sidewalk: Curb side : Cutout Tree DPW 1   01/12/2007 12:00:00 AM 3 3x3   5987638.7841 2100062.768 37.7456591364178 -122.485473213008 (37.7456591364178, -122.485473213008) 1 8 3 29491 35
12189 9378 DPW Maintained 1 Prunus serrulata :: Ornamental Cherry 84 320 Gold Mine Dr 1 Sidewalk: Curb side : Cutout Tree DPW 1     6 2X2   6001091.8143019 2097867.0769739 37.7404048998329 -122.438797433034 (37.7404048998329, -122.438797433034) 2 7 5 63 7
12670 86450 DPW Maintained 1 Prunus serrulata :: Ornamental Cherry 84 2362 27th Ave 1 Sidewalk: Curb side : Cutout Tree DPW 1   12/29/2006 12:00:00 AM 3 3x3   5987982.1495 2099214.8079 37.7433508614418 -122.4842237451 (37.7433508614418, -122.4842237451) 1 8 3 29491 35
13229 21689 DPW Maintained 1 Prunus serrulata :: Ornamental Cherry 84 1881 Sutter St 4 Sidewalk: Curb side : Cutout Tree DPW 1     12 4x4   6003724.339 2114539.1952 37.7863319437467 -122.43088473956 (37.7863319437467, -122.43088473956) 13 9 11 29490 13
13724 85931 DPW Maintained 1 Prunus serrulata :: Ornamental Cherry 84 1686 26th Ave 1 Sidewalk: Curb side : Cutout Tree DPW 1   12/18/2006 12:00:00 AM 3 3x3   5988131.3934 2103830.0344 37.756031730146 -122.484046073449 (37.756031730146, -122.484046073449) 1 8 3 56 35
14432 178904 DPW Maintained 1 Prunus serrulata :: Ornamental Cherry 84 10x Mansell St 4 Median : Cutout Tree DPW 1     1 Width 0ft   6011792.88406 2090769.73397 37.7215200714836 -122.401298496839 (37.7215200714836, -122.401298496839) 10 3 8 309 28
15189 89400 DPW Maintained 1 Prunus serrulata :: Ornamental Cherry 84 1908 Anza St 1 Sidewalk: Curb side : Cutout Tree DPW 1   02/08/2008 12:00:00 AM 3 3x3   5992787.397851 2112077.494993 37.77894703563 -122.468544248635 (37.77894703563, -122.468544248635) 11 6 2 54 11
15267 119759 DPW Maintained 1 Prunus serrulata :: Ornamental Cherry 84 101X Octavia St Frontage West 1 Sidewalk: Curb side : Cutout Tree DPW 1       4x4                      
15546 86251 DPW Maintained 1 Prunus serrulata :: Ornamental Cherry 84 2230 25th Ave 1 Sidewalk: Curb side : Cutout Tree DPW 1   12/15/2006 12:00:00 AM 3 3x3   5988566.0868 2100132.7531 37.7459052793749 -122.482271903737 (37.7459052793749, -122.482271903737) 1 8 3 29491 35
16758 86256 DPW Maintained 1 Prunus serrulata :: Ornamental Cherry 84 1754 25th Ave 1 Sidewalk: Curb side : Cutout Tree DPW 1   12/12/2006 12:00:00 AM 3 3x3   5988460.2167 2103365.3979 37.7547751017133 -122.482874855725 (37.7547751017133, -122.482874855725) 1 8 3 56 35
17072 259381 DPW Maintained 1 Prunus serrulata :: Ornamental Cherry 84 225 Whipple Ave 1 Sidewalk: Curb side : Cutout Tree DPW 1       3x3   5997701 2087724 37.7123609051901 -122.449790697309 (37.7123609051901, -122.449790697309) 9 7 6 28861 25
17563 85987 DPW Maintained 1 Prunus serrulata :: Ornamental Cherry 84 2286 28th Ave 1 Sidewalk: Curb side : Cutout Tree DPW 1   01/12/2007 12:00:00 AM 3 3x3   5987649.8793 2099748.6884 37.7447974037311 -122.485411804387 (37.7447974037311, -122.485411804387) 1 8 3 29491 35
18417 4023 DPW Maintained 1 Prunus serrulata :: Ornamental Cherry 84 1900 Cesar Chavez St 1 Sidewalk: Curb side : Cutout Tree DPW 1   06/26/2015 02:44:00 PM 3 3X3   6013444.0079121 2101040.051797 37.7498122193832 -122.396310443681 (37.7498122193832, -122.396310443681) 10 3 8 28856 1
20120 85951 DPW Maintained 1 Prunus serrulata :: Ornamental Cherry 84 1390 26th Ave 1 Sidewalk: Curb side : Cutout Tree DPW 1   12/21/2006 12:00:00 AM 3 3x3   5988061.1772 2105842.3097 37.7615528036389 -122.484436487246 (37.7615528036389, -122.484436487246) 1 8 3 56 35
20137 86308 DPW Maintained 1 Prunus serrulata :: Ornamental Cherry 84 1503 25th Ave 1 Sidewalk: Curb side : Cutout Tree DPW 1   12/12/2006 12:00:00 AM 3 3x3   5988358.1168 2105058.904 37.7594190709864 -122.483352077356 (37.7594190709864, -122.483352077356) 1 8 3 56 35
20375 27754 DPW Maintained 1 Prunus serrulata :: Ornamental Cherry 84 1299 Cesar Chavez St 7 Sidewalk: Curb side : Cutout Tree DPW 1   03/23/2006 12:00:00 AM 3 3X3   6015153.848397 2101092.2403929 37.7500505146893 -122.390401336874 (37.7500505146893, -122.390401336874) 10 3 8 58 1
20580 86119 DPW Maintained 1 Prunus serrulata :: Ornamental Cherry 84 2462 24th Ave 1 Sidewalk: Curb side : Cutout Tree DPW 1   01/17/2007 12:00:00 AM 3 3x3   5988932.9456 2098582.1283 37.7416690029042 -122.480889862999 (37.7416690029042, -122.480889862999) 1 8 3 29491 35
21111 86574 DPW Maintained 1 Prunus serrulata :: Ornamental Cherry 84 2435 27th Ave 1 Sidewalk: Curb side : Cutout Tree DPW 1   01/05/2007 12:00:00 AM 3 3x3   5987950.8455 2098721.8965 37.7419956341083 -122.484295842204 (37.7419956341083, -122.484295842204) 1 8 3 29491 35
21318 86004 DPW Maintained 1 Prunus serrulata :: Ornamental Cherry 84 1774 28th Ave 1 Sidewalk: Curb side : Cutout Tree DPW 1   01/12/2007 12:00:00 AM 3 3x3   5987534.4685 2103215.2309 37.7543088755282 -122.486065283877 (37.7543088755282, -122.486065283877) 1 8 3 56 35
21529 86204 DPW Maintained 1 Prunus serrulata :: Ornamental Cherry 84 2427 24th Ave 1 Sidewalk: Curb side : Cutout Tree DPW 1   01/19/2007 12:00:00 AM 3 3x3   5988880.8286 2098804.4715 37.7422764696275 -122.481086340605 (37.7422764696275, -122.481086340605) 1 8 3 29491 35
22074 86106 DPW Maintained 1 Prunus serrulata :: Ornamental Cherry 84 2576 24th Ave 1 Sidewalk: Curb side : Cutout Tree DPW 1   01/17/2007 12:00:00 AM 3 3x3   5988959.241 2097817.061 37.7395698560466 -122.480742946483 (37.7395698560466, -122.480742946483) 1 8 3 29491 35
22876 86247 DPW Maintained 1 Prunus serrulata :: Ornamental Cherry 84 2290 25th Ave 1 Sidewalk: Curb side : Cutout Tree DPW 1   12/21/2006 12:00:00 AM 3 3x3   5988579.3157 2099752.9558 37.7448632256871 -122.482198340398 (37.7448632256871, -122.482198340398) 1 8 3 29491 35
22896 86008 DPW Maintained 1 Prunus serrulata :: Ornamental Cherry 84 1726 28th Ave 1 Sidewalk: Curb side : Cutout Tree DPW 1   01/12/2007 12:00:00 AM 3 3x3   5987525.9378 2103513.8062 37.7551281853344 -122.486116701181 (37.7551281853344, -122.486116701181) 1 8 3 56 35
23534 86573 DPW Maintained 1 Prunus serrulata :: Ornamental Cherry 84 2423 27th Ave 1 Sidewalk: Curb side : Cutout Tree DPW 1   01/05/2007 12:00:00 AM 3 3x3   5987947.4613 2098798.3799 37.7422054403073 -122.484313151634 (37.7422054403073, -122.484313151634) 1 8 3 29491 35
24423 86261 DPW Maintained 1 Prunus serrulata :: Ornamental Cherry 84 1726 25th Ave 1 Sidewalk: Curb side : Cutout Tree DPW 1   12/12/2006 12:00:00 AM 3 3x3   5988455.289 2103558.6714 37.7553054920736 -122.482906060899 (37.7553054920736, -122.482906060899) 1 8 3 56 35
24499 86262 DPW Maintained 1 Prunus serrulata :: Ornamental Cherry 84 1722 25th Ave 1 Sidewalk: Curb side : Cutout Tree DPW 1   12/12/2006 12:00:00 AM 3 3x3   5988454.7415 2103581.1196 37.7553670969368 -122.482909599425 (37.7553670969368, -122.482909599425) 1 8 3 56 35
24568 89655 DPW Maintained 1 Prunus serrulata :: Ornamental Cherry 84 3003 Anza St 1 Sidewalk: Curb side : Cutout Tree DPW 1   04/18/2008 12:00:00 AM 3 3x3   5989317.85585 2111907.93007 37.7782804306874 -122.480534228481 (37.7782804306874, -122.480534228481) 11 6 2 55 26
25273 86253 DPW Maintained 1 Prunus serrulata :: Ornamental Cherry 84 2206 25th Ave 1 Sidewalk: Curb side : Cutout Tree DPW 1   12/15/2006 12:00:00 AM 3 3x3   5988562.6729 2100280.8313 37.7463116644044 -122.482294555654 (37.7463116644044, -122.482294555654) 1 8 3 29491 35
25667 85944 DPW Maintained 1 Prunus serrulata :: Ornamental Cherry 84 1530 26th Ave 1 Sidewalk: Curb side : Cutout Tree DPW 1   12/18/2006 12:00:00 AM 3 3x3   5988094.8611 2104879.1908 37.7589103025977 -122.484249353508 (37.7589103025977, -122.484249353508) 1 8 3 56 35
25815 27759 DPW Maintained 1 Prunus serrulata :: Ornamental Cherry 84 1099X Cesar Chavez St 1 Sidewalk: Curb side : Cutout Tree DPW 1   12/25/2005 12:00:00 AM 4 3x3   6015711.8179102 2101113.2850563 37.750139234821 -122.388473299437 (37.750139234821, -122.388473299437) 10 3 8 58 1
26284 86002 DPW Maintained 1 Prunus serrulata :: Ornamental Cherry 84 1824 28th Ave 1 Sidewalk: Curb side : Cutout Tree DPW 1   01/12/2007 12:00:00 AM 3 3x3   5987543.255 2102835.2262 37.7532659973414 -122.486007006329 (37.7532659973414, -122.486007006329) 1 8 3 56 35
26757 4027 DPW Maintained 1 Prunus serrulata :: Ornamental Cherry 84 2150 Cesar Chavez St 1 Sidewalk: Curb side : Cutout Tree DPW 1   03/23/2006 12:00:00 AM 3 3X3   6012617.9559004 2100994.1740901 37.7496402484926 -122.399163766262 (37.7496402484926, -122.399163766262) 10 3 8 58 1
26901 86368 DPW Maintained 1 Prunus serrulata :: Ornamental Cherry 84 1235 26th Ave 1 Sidewalk: Curb side : Cutout Tree DPW 1   12/20/2006 12:00:00 AM 3 3x3   5987981.928 2106870.8736 37.7643723435277 -122.48478603092 (37.7643723435277, -122.48478603092) 1 8 3 56 35
27494 109159 DPW Maintained 1 Prunus serrulata :: Ornamental Cherry 84 200 Octavia St Frontage East 5 Sidewalk: Curb side : Cutout Tree DPW 1       4x4   6005726 2110076 37.7741903117261 -122.423642051276 (37.7741903117261, -122.423642051276) 7 9 11 28852 10
28839 119865 DPW Maintained 1 Prunus serrulata :: Ornamental Cherry 84 451X Octavia St Frontage West 6 Sidewalk: Curb side : Cutout Tree DPW 1       4x4   6005602 2110303 37.774806598562 -122.424087136382 (37.774806598562, -122.424087136382) 7 9 11 28852 10
29020 86009 DPW Maintained 1 Prunus serrulata :: Ornamental Cherry 84 1722 28th Ave 1 Sidewalk: Curb side : Cutout Tree DPW 1   01/12/2007 12:00:00 AM 3 3x3   5987523.9067 2103537.3673 37.7551927593601 -122.486125454711 (37.7551927593601, -122.486125454711) 1 8 3 56 35
29559 16687 DPW Maintained 1 Prunus serrulata :: Ornamental Cherry 84 500 Noriega St 1 Median : Cutout Tree DPW 1     6 2   5992496.9362665 2103468.0481268 37.7552910027695 -122.468922364571 (37.7552910027695, -122.468922364571) 1 8 4 56 12
29911 85954 DPW Maintained 1 Prunus serrulata :: Ornamental Cherry 84 1370 26th Ave 1 Sidewalk: Curb side : Cutout Tree DPW 1   12/21/2006 12:00:00 AM 3 3x3   5988057.3894 2105986.2433 37.7619477854522 -122.484460144927 (37.7619477854522, -122.484460144927) 1 8 3 56 35
30209 86399 DPW Maintained 1 Prunus serrulata :: Ornamental Cherry 84 1639 26th Ave 1 Sidewalk: Curb side : Cutout Tree DPW 1   12/15/2006 12:00:00 AM 3 3x3   5988077.0028 2104128.4671 37.7568479789363 -122.484256057823 (37.7568479789363, -122.484256057823) 1 8 3 56 35
30564 106986 DPW Maintained 1 Prunus serrulata :: Ornamental Cherry 84 1737-1795 Post St 7 Sidewalk: Curb side : Cutout Tree DPW 1   04/01/2012 12:00:00 AM 2     6003814.6942 2114193.6153 37.7853881873399 -122.430547466156 (37.7853881873399, -122.430547466156) 13 9 11 29490 13
31548 85949 DPW Maintained 1 Prunus serrulata :: Ornamental Cherry 84 1430 26th Ave 1 Sidewalk: Curb side : Cutout Tree DPW 1   12/18/2006 12:00:00 AM 3 3x3   5988070.6928 2105557.2008 37.7607705264222 -122.484382665437 (37.7607705264222, -122.484382665437) 1 8 3 56 35
31646 86231 DPW Maintained 1 Prunus serrulata :: Ornamental Cherry 84 2426 25th Ave 1 Sidewalk: Curb side : Cutout Tree DPW 1   12/15/2006 12:00:00 AM 3 3x3   5988617.0288 2098793.8112 37.7422318603031 -122.481997687782 (37.7422318603031, -122.481997687782) 1 8 3 29491 35
31653 12410 DPW Maintained 1 Prunus serrulata :: Ornamental Cherry 84 1610X Laguna St 1 Sidewalk: Curb side : Cutout Tree DPW 1   09/13/1989 12:00:00 AM 7 4X4   6004460.5933 2114341.7023 37.78583136591 -122.428323406904 (37.78583136591, -122.428323406904) 13 9 11 29490 13
31843 119859 DPW Maintained 1 Prunus serrulata :: Ornamental Cherry 84 431 Octavia St Frontage West 3 Sidewalk: Curb side : Cutout Tree DPW 1       4x4   6005602 2110303 37.774806598562 -122.424087136382 (37.774806598562, -122.424087136382) 7 9 11 28852 10
31905 138183 DPW Maintained 1 Prunus serrulata :: Ornamental Cherry 84 1865 Buchanan St 3 Sidewalk: Curb side : Cutout Tree DPW 1   06/26/2012 12:00:00 AM 2 Width 0ft   6003936.4381 2114774.658 37.7869904804487 -122.430167735302 (37.7869904804487, -122.430167735302) 13 9 11 29490 27
31996 86208 DPW Maintained 1 Prunus serrulata :: Ornamental Cherry 84 2447 24th Ave 1 Sidewalk: Curb side : Cutout Tree DPW 1   01/19/2007 12:00:00 AM 3 3x3   5988885.905 2098662.6727 37.741887422325 -122.481058407886 (37.741887422325, -122.481058407886) 1 8 3 29491 35
33932 86583 DPW Maintained 1 Prunus serrulata :: Ornamental Cherry 84 2567 27th Ave 1 Sidewalk: Curb side : Cutout Tree DPW 1   01/05/2007 12:00:00 AM 3 3x3   5987981.2526 2097846.7049 37.7395943585814 -122.48412653867 (37.7395943585814, -122.48412653867) 1 8 3 29491 35
34840 86571 DPW Maintained 1 Prunus serrulata :: Ornamental Cherry 84 2401X 27th Ave 1 Sidewalk: Curb side : Cutout Tree DPW 1   01/05/2007 12:00:00 AM 3 3x3   5987947.4613 2098914.797 37.7425250909553 -122.484321687901 (37.7425250909553, -122.484321687901) 1 8 3 29491 35
34956 86246 DPW Maintained 1 Prunus serrulata :: Ornamental Cherry 84 2292X 25th Ave 1 Sidewalk: Curb side : Cutout Tree DPW 1   12/21/2006 12:00:00 AM 3 3x3   5988581.0227 2099729.0585 37.7447977092886 -122.482190687534 (37.7447977092886, -122.482190687534) 1 8 3 29491 35
35011 86446 DPW Maintained 1 Prunus serrulata :: Ornamental Cherry 84 2426 27th Ave 1 Sidewalk: Curb side : Cutout Tree DPW 1   12/29/2006 12:00:00 AM 3 3x3   5987996.8709 2098757.0924 37.7420949525843 -122.484139283552 (37.7420949525843, -122.484139283552) 1 8 3 29491 35
36097 115453 Undocumented 4 Prunus serrulata :: Ornamental Cherry 84 300 Octavia St Frontage East 4 Sidewalk: Curb side : Cutout Tree DPW 1       4x4   6005602 2110303 37.774806598562 -122.424087136382 (37.774806598562, -122.424087136382) 7 9 11 28852 10
36317 86398 DPW Maintained 1 Prunus serrulata :: Ornamental Cherry 84 1631 26th Ave 1 Sidewalk: Curb side : Cutout Tree DPW 1   12/15/2006 12:00:00 AM 3 3x3   5988074.1402 2104179.9951 37.7569892942074 -122.484269736563 (37.7569892942074, -122.484269736563) 1 8 3 56 35
37359 93470 DPW Maintained 1 Prunus serrulata :: Ornamental Cherry 84 1445 Taraval St 1 Sidewalk: Curb side : Cutout Tree DPW 1   02/26/2009 12:00:00 AM 3 3x3   5988675.4994 2098958.5529 37.7426875982526 -122.481807581267 (37.7426875982526, -122.481807581267) 1 8 3 29491 35
37546 86111 DPW Maintained 1 Prunus serrulata :: Ornamental Cherry 84 2544 24th Ave 2 Sidewalk: Curb side : Cutout Tree DPW 1   01/17/2007 12:00:00 AM 3 3x3   5988952.3483 2098011.286 37.7401027466921 -122.480780993789 (37.7401027466921, -122.480780993789) 1 8 3 29491 35
38011 85932 DPW Maintained 1 Prunus serrulata :: Ornamental Cherry 84 1666 26th Ave 1 Sidewalk: Curb side : Cutout Tree DPW 1   12/18/2006 12:00:00 AM 3 3x3   5988126.3838 2103953.8446 37.7563713878607 -122.484072477016 (37.7563713878607, -122.484072477016) 1 8 3 56 35
38528 106984 DPW Maintained 1 Prunus serrulata :: Ornamental Cherry 84 1737-1795 Post St 5 Sidewalk: Curb side : Cutout Tree DPW 1   04/01/2012 12:00:00 AM 3     6003775.6189 2114189.0991 37.7853735733153 -122.430682332536 (37.7853735733153, -122.430682332536) 13 9 11 29490 13
38565 85997 DPW Maintained 1 Prunus serrulata :: Ornamental Cherry 84 1852 28th Ave 1 Sidewalk: Curb side : Cutout Tree DPW 1   01/12/2007 12:00:00 AM 3 3x3   5987552.7911 2102660.2851 37.7527862120032 -122.485961188927 (37.7527862120032, -122.485961188927) 1 8 3 56 35
38617 119866 DPW Maintained 1 Prunus serrulata :: Ornamental Cherry 84 451X Octavia St Frontage West 7 Sidewalk: Curb side : Cutout Tree DPW 1       4x4   6005602 2110303 37.774806598562 -122.424087136382 (37.774806598562, -122.424087136382) 7 9 11 28852 10
39227 86445 DPW Maintained 1 Prunus serrulata :: Ornamental Cherry 84 2434 27th Ave 1 Sidewalk: Curb side : Cutout Tree DPW 1   12/29/2006 12:00:00 AM 3 3x3   5987997.5477 2098724.6039 37.7420057871296 -122.484134561433 (37.7420057871296, -122.484134561433) 1 8 3 29491 35
40195 86196 DPW Maintained 1 Prunus serrulata :: Ornamental Cherry 84 2323 24th Ave 1 Sidewalk: Curb side : Cutout Tree DPW 1   01/19/2007 12:00:00 AM 3 3x3   5988857.15 2099475.7669 37.7441182942376 -122.481217358674 (37.7441182942376, -122.481217358674) 1 8 3 29491 35
40667 91895 DPW Maintained 1 Prunus serrulata :: Ornamental Cherry 84 1342 Irving St 1 Sidewalk: Curb side : Cutout Tree DPW 1   02/18/2009 12:00:00 AM 3 3x3   5991627.501572 2106598.137501 37.7638351306782 -122.472157247242 (37.7638351306782, -122.472157247242) 11 8 11 56 12
41636 86194 DPW Maintained 1 Prunus serrulata :: Ornamental Cherry 84 2315 24th Ave 1 Sidewalk: Curb side : Cutout Tree DPW 1   01/19/2007 12:00:00 AM 3 3x3   5988852.7525 2099552.2157 37.7443279469011 -122.481238161111 (37.7443279469011, -122.481238161111) 1 8 3 29491 35
41827 143115 DPW Maintained 1 Prunus serrulata :: Ornamental Cherry 84 1635 LOMBARD ST 1 Sidewalk: Curb side : Cutout Tree DPW 1     8 Width 0ft   6004533.1119 2119761.6458 37.8007172577851 -122.428458969748 (37.8007172577851, -122.428458969748) 13 9 1 57 17
42178 86206 DPW Maintained 1 Prunus serrulata :: Ornamental Cherry 84 2439 24th Ave 1 Sidewalk: Curb side : Cutout Tree DPW 1   01/19/2007 12:00:00 AM 3 3x3   5988884.8897 2098711.7439 37.7420220999833 -122.481065510643 (37.7420220999833, -122.481065510643) 1 8 3 29491 35
42523 86453 DPW Maintained 1 Prunus serrulata :: Ornamental Cherry 84 2330 27th Ave 1 Sidewalk: Curb side : Cutout Tree DPW 1   12/29/2006 12:00:00 AM 3 3x3   5987973.3506 2099428.6905 37.7439376142067 -122.484269851802 (37.7439376142067, -122.484269851802) 1 8 3 29491 35
42803 115684 DPW Maintained 1 Prunus serrulata :: Ornamental Cherry 84 100x Octavia St Frontage East 4 Sidewalk: Curb side : Cutout Tree DPW 1       4x4   6005589 2109665 37.7730540708525 -122.424086724818 (37.7730540708525, -122.424086724818) 7 9 11 28852 10
43629 119810 DPW Maintained 1 Prunus serrulata :: Ornamental Cherry 84 250 Octavia St Frontage East 2 Sidewalk: Curb side : Cutout Tree DPW 1       4x4   6005726 2110076 37.7741903117261 -122.423642051276 (37.7741903117261, -122.423642051276) 7 9 11 28852 10
45064 28647 DPW Maintained 1 Prunus serrulata :: Ornamental Cherry 84 1600X Webster St 9 Median : Cutout Tree DPW 1     8 6   6003547.8453 2114380.4001 37.7858859308492 -122.431484021877 (37.7858859308492, -122.431484021877) 13 9 11 29490 13
45304 86448 DPW Maintained 1 Prunus serrulata :: Ornamental Cherry 84 2410 27th Ave 1 Sidewalk: Curb side : Cutout Tree DPW 1   12/29/2006 12:00:00 AM 3 3x3   5987993.1483 2098903.2906 37.7424961575573 -122.484162874059 (37.7424961575573, -122.484162874059) 1 8 3 29491 35
45496 86395 DPW Maintained 1 Prunus serrulata :: Ornamental Cherry 84 1609 26th Ave 1 Sidewalk: Curb side : Cutout Tree DPW 1   12/15/2006 12:00:00 AM 3 3x3   5988071.9932 2104313.1089 37.7573546636623 -122.48428692393 (37.7573546636623, -122.48428692393) 1 8 3 56 35
45670 86066 DPW Maintained 1 Prunus serrulata :: Ornamental Cherry 84 1959 28th Ave 1 Sidewalk: Curb side : Cutout Tree DPW 1   01/12/2007 12:00:00 AM 3 3x3   5987532.0381 2101952.375 37.7508412720312 -122.48598099746 (37.7508412720312, -122.48598099746) 1 8 3 29491 35
45690 85998 DPW Maintained 1 Prunus serrulata :: Ornamental Cherry 84 1848 28th Ave 1 Sidewalk: Curb side : Cutout Tree DPW 1   01/12/2007 12:00:00 AM 3 3x3   5987552.183 2102681.5677 37.7528446128464 -122.485964853879 (37.7528446128464, -122.485964853879) 1 8 3 56 35
45706 27750 DPW Maintained 1 Prunus serrulata :: Ornamental Cherry 84 1299 Cesar Chavez St 3 Sidewalk: Curb side : Cutout Tree DPW 1   03/23/2006 12:00:00 AM 3 3X3   6015153.848397 2101092.2403929 37.7500505146893 -122.390401336874 (37.7500505146893, -122.390401336874) 10 3 8 58 1
46768 86097 DPW Maintained 1 Prunus serrulata :: Ornamental Cherry 84 2646 24th Ave 1 Sidewalk: Curb side : Cutout Tree DPW 1   01/16/2007 12:00:00 AM 3 3x3   5988975.9803 2097328.4213 37.7382291513586 -122.480649308029 (37.7382291513586, -122.480649308029) 1 8 3 29491 35
47389 87404 DPW Maintained 1 Prunus serrulata :: Ornamental Cherry 84 1300 Webster St 9 Median : Cutout Tree DPW 1   04/21/2008 12:00:00 AM 3 3x3   6003683.0746 2113412.9921 37.7832373349481 -122.430947098227 (37.7832373349481, -122.430947098227) 15 9 11 29490 41
48725 27758 DPW Maintained 1 Prunus serrulata :: Ornamental Cherry 84 1299 Cesar Chavez St 11 Sidewalk: Curb side : Cutout Tree DPW 1   03/23/2006 12:00:00 AM 3 3X3   6015153.848397 2101092.2403929 37.7500505146893 -122.390401336874 (37.7500505146893, -122.390401336874) 10 3 8 58 1
48774 119805 DPW Maintained 1 Prunus serrulata :: Ornamental Cherry 84 251X Octavia St Frontage West 2 Sidewalk: Curb side : Cutout Tree DPW 1       3x3   6005545 2110174 37.7744491774234 -122.424275134654 (37.7744491774234, -122.424275134654) 7 9 11 28852 10
48850 86061 DPW Maintained 1 Prunus serrulata :: Ornamental Cherry 84 1877 28th Ave 1 Sidewalk: Curb side : Cutout Tree DPW 1   01/12/2007 12:00:00 AM 3 3x3   5987508.8564 2102515.9989 37.7523874805812 -122.486102530412 (37.7523874805812, -122.486102530412) 1 8 3 56 35
49239 86400 DPW Maintained 1 Prunus serrulata :: Ornamental Cherry 84 1659 26th Ave 1 Sidewalk: Curb side : Cutout Tree DPW 1   12/15/2006 12:00:00 AM 3 3x3   5988082.0125 2104007.5196 37.7565161814967 -122.484229862839 (37.7565161814967, -122.484229862839) 1 8 3 56 35

Next page

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options:

CREATE TABLE "trees" (
   [rowid] INTEGER PRIMARY KEY,
   [TreeID] TEXT,
   [qLegalStatus_id] INTEGER REFERENCES [qLegalStatus]([id]),
   [qSpecies_id] INTEGER,
   [qAddress] TEXT,
   [SiteOrder] TEXT,
   [qSiteInfo] TEXT,
   [PlantType] TEXT,
   [qCaretaker_id] INTEGER REFERENCES [qCaretaker]([id]),
   [qCareAssistant] TEXT,
   [PlantDate] TEXT,
   [DBH] TEXT,
   [PlotSize] TEXT,
   [PermitNotes] TEXT,
   [XCoord] TEXT,
   [YCoord] TEXT,
   [Latitude] TEXT,
   [Longitude] TEXT,
   [Location] TEXT,
   [Fire Prevention Districts] TEXT,
   [Police Districts] TEXT,
   [Supervisor Districts] TEXT,
   [Zip Codes] TEXT,
   [Neighborhoods (old)] TEXT,
   FOREIGN KEY(qSpecies_id) REFERENCES qSpecies(id)
);