trees
2,694 rows where qSpecies_id = 84 sorted by qCaretaker_id
This data as json, CSV (advanced)
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 |
Advanced export
JSON shape: default, array, newline-delimited, object
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) );