trees
1,985 rows where qSpecies_id = 83 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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
971 | 16508 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 325 Newhall St | 10 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3x3 | 6016639.93914 | 2098306.03692 | 37.7424824967653 | -122.385068203435 | (37.7424824967653, -122.385068203435) | 10 | 3 | 8 | 58 | 1 | |||
1699 | 5933 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 1355 Eddy St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/28/1990 12:00:00 AM | 3 | 4X4 | 6004029.33456 | 2112693.29822 | 37.781280848415 | -122.429697830179 | (37.781280848415, -122.429697830179) | 7 | 9 | 11 | 29490 | 41 | ||
2151 | 258135 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 988 Howard St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 3 | 6010589.4479 | 2112082.95565 | 37.7799742710855 | -122.40695991983 | (37.7799742710855, -122.40695991983) | 14 | 2 | 9 | 28853 | 34 | |||
2159 | 23089 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 1360 Valencia St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/03/1992 12:00:00 AM | 3 | 3X3 | 6006386.45124 | 2101639.17827 | 37.751062036612 | -122.420758355385 | (37.751062036612, -122.420758355385) | 2 | 4 | 5 | 28859 | 19 | ||
3095 | 28342 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 3115 Mission St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 01/10/2004 12:00:00 AM | 3 | 3X3 | 6007068 | 2100404 | 37.7477089074097 | -122.418313917469 | (37.7477089074097, -122.418313917469) | 2 | 7 | 7 | 28859 | 2 | ||
3470 | 260424 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 751 Goettingen St | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 08/17/2019 12:00:00 AM | 3 | 6010808.85842 | 2091198.73798 | 37.7226430782423 | -122.404730210147 | (37.7226430782423, -122.404730210147) | 10 | 3 | 7 | 309 | 28 | |||
5967 | 252969 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 101 Whipple Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 5998071 | 2087307 | 37.7112370808248 | -122.448481858962 | (37.7112370808248, -122.448481858962) | 9 | 7 | 6 | 28861 | 25 | ||||
6129 | 85658 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 1643 Quesada Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/30/2007 12:00:00 AM | 3 | 3x3 | 6015004.908 | 2094769.8823 | 37.7326823614983 | -122.3904746745 | (37.7326823614983, -122.3904746745) | 10 | 3 | 8 | 58 | 1 | ||
7715 | 260428 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 745 Silliman St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 08/17/2019 12:00:00 AM | 3 | ||||||||||||
8128 | 90393 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 98 12th St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 10/31/2016 12:00:00 AM | 3 | 3x3 | 6007146.175112 | 2109626.370927 | 37.7730357998282 | -122.418697508419 | (37.7730357998282, -122.418697508419) | 8 | 2 | 9 | 28853 | 19 | ||
9288 | 85617 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 1274 Quesada Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/30/2007 12:00:00 AM | 3 | 3x3 | 6017015.0778 | 2093348.1164 | 37.7288897808137 | -122.383426014631 | (37.7288897808137, -122.383426014631) | 10 | 3 | 8 | 58 | 1 | ||
9559 | 90383 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 20 12th St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/21/2008 12:00:00 AM | 3 | 3x3 | 6006777.292282 | 2110019.638696 | 37.7740948433326 | -122.420001435971 | (37.7740948433326, -122.420001435971) | 8 | 2 | 9 | 28853 | 19 | ||
11654 | 259082 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 1023 Visitacion Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 06/01/2019 12:00:00 AM | 3 | 6009473.49904 | 2087244.25049 | 37.7117101453965 | -122.409067379874 | (37.7117101453965, -122.409067379874) | 9 | 7 | 8 | 309 | 39 | |||
11829 | 259084 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 1041 Visitacion Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 06/01/2019 12:00:00 AM | 3 | 6009428.83146 | 2087260.92835 | 37.7117534370142 | -122.409222939968 | (37.7117534370142, -122.409222939968) | 9 | 7 | 8 | 309 | 39 | |||
12336 | 85628 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 1470 Quesada Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/30/2007 12:00:00 AM | 3 | 3x3 | 6015957.8963 | 2094137.5833 | 37.7309990152261 | -122.387135841638 | (37.7309990152261, -122.387135841638) | 10 | 3 | 8 | 58 | 1 | ||
13512 | 259080 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 1001 Visitacion Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 06/01/2019 12:00:00 AM | 3 | |||||||||||||
13556 | 264663 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 1078 Hollister Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 09/10/2020 12:00:00 AM | 3x3 | 6014476.86082 | 2089998.27904 | 37.7195511879651 | -122.391966726039 | (37.7195511879651, -122.391966726039) | 10 | 3 | 8 | 58 | 1 | |||
14084 | 258134 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 131 Woolsey St | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 3 | 4x5 | 6011357.19142 | 2092082.52958 | 37.7251004206417 | -122.402896861649 | (37.7251004206417, -122.402896861649) | 10 | 3 | 7 | 309 | 28 | |||
15188 | 180603 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 100 Hamilton St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 3 | Width 3ft | 6009034.51206 | 2093748.44623 | 37.7295447050207 | -122.411043765455 | (37.7295447050207, -122.411043765455) | 9 | 3 | 7 | 309 | 28 | ||
15527 | 19972 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 100 STAIRWAY44 | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3 | 36 | |||||||||||||
15913 | 258136 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 125 Woolsey St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 3 | 4x4 | 6011373.95167 | 2092087.62826 | 37.7251153564238 | -122.402839281337 | (37.7251153564238, -122.402839281337) | 10 | 3 | 7 | 309 | 28 | ||
16016 | 5120 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 2725 Diamond St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/21/2016 10:06:00 AM | 3 | 5X5 | 6002461.05615 | 2096042.42458 | 37.7354726294434 | -122.433932747209 | (37.7354726294434, -122.433932747209) | 2 | 7 | 5 | 63 | 7 | ||
17572 | 7280 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 1805 Fillmore St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/04/2020 02:03:00 PM | 3 | 4X4 | 6002990.933 | 2114560.8146 | 37.7863497234839 | -122.433423679579 | (37.7863497234839, -122.433423679579) | 13 | 9 | 11 | 29490 | 27 | ||
19372 | 259083 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 1029 Visitacion Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 06/01/2019 12:00:00 AM | 3 | 6009458.60985 | 2087249.80978 | 37.7117245759679 | -122.409119233208 | (37.7117245759679, -122.409119233208) | 9 | 7 | 8 | 309 | 39 | |||
22287 | 1701 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 46 Baldwin Ct | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/04/2015 02:11:00 PM | 3 | 3X3 | 6017792.761567 | 2093643.6318374 | 37.7297441585391 | -122.380758013182 | (37.7297441585391, -122.380758013182) | 10 | 3 | 8 | 58 | 1 | ||
22372 | 18655 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 85 Reuel Ct | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 11/18/1999 12:00:00 AM | 3 | 3X4 | 6017364.7700717 | 2096131.8258237 | 37.7365526173752 | -122.382410690517 | (37.7365526173752, -122.382410690517) | 10 | 3 | 8 | 58 | 1 | ||
23938 | 237023 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 8 Octavia St | 4 | : | Tree | DPW 1 | 04/15/2017 01:44:00 PM | 3 | Width 6ft | 6005765.01716 | 2109438.39176 | 37.7724417955802 | -122.423461745458 | (37.7724417955802, -122.423461745458) | 7 | 9 | 11 | 28852 | 10 | ||
25176 | 85636 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 1161 Quesada Ave | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/30/2007 12:00:00 AM | 3 | 3x3 | 6017631.370144 | 2092826.687243 | 37.7274920796749 | -122.381259184857 | (37.7274920796749, -122.381259184857) | 10 | 3 | 8 | 58 | 1 | ||
25213 | 18261 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 1870 Post St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 01/30/1991 12:00:00 AM | 6 | 4X4 | 6003225.4707245 | 2114168.1799394 | 37.7852849514104 | -122.432584183534 | (37.7852849514104, -122.432584183534) | 13 | 9 | 11 | 29490 | 13 | ||
27277 | 18635 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 20 Reuel Ct | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/11/2006 12:00:00 AM | 0 | 3X3 | 6017095.3922155 | 2096110.4018038 | 37.736478907812 | -122.3833405631 | (37.736478907812, -122.3833405631) | 10 | 3 | 8 | 58 | 1 | ||
27648 | 21211 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 2392X Sunset Blvd | 14 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3 | 60 | 5984971.1169577 | 2098921.2732344 | 37.7423691180201 | -122.494613333405 | (37.7423691180201, -122.494613333405) | 1 | 8 | 3 | 29491 | 35 | |||
27855 | 2465 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 1832 Buchanan St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 05/15/2000 12:00:00 AM | 3 | 4X4 | 6003995.9995029 | 2114715.2873188 | 37.7868308367846 | -122.429957429665 | (37.7868308367846, -122.429957429665) | 13 | 9 | 11 | 29490 | 27 | ||
27982 | 85620 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 1344 Quesada Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/30/2007 12:00:00 AM | 3 | 3x3 | 6016632.8917 | 2093635.0593 | 37.729656539473 | -122.384767252586 | (37.729656539473, -122.384767252586) | 10 | 3 | 8 | 58 | 1 | ||
28102 | 4618 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 354 Columbus Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 9 | 3x3 | 6010598.00994 | 2118821.58602 | 37.7984774173787 | -122.407405500457 | (37.7984774173787, -122.407405500457) | 3 | 1 | 10 | 308 | 23 | |||
28771 | 8049 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 600 Fulton St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/08/2001 12:00:00 AM | 12 | 3X3 | 6004627.99576 | 2111737.28964 | 37.7786897656705 | -122.427558625827 | (37.7786897656705, -122.427558625827) | 7 | 9 | 11 | 28852 | 41 | ||
29386 | 8257 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 1525 GALVEZ AVE | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 11/13/1992 12:00:00 AM | 6 | 3x3 | 6016246 | 2097351 | 37.7398383611722 | -122.386363768789 | (37.7398383611722, -122.386363768789) | 10 | 3 | 8 | 58 | 1 | ||
31031 | 1693 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 26 Baldwin Ct | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/31/1996 12:00:00 AM | 3 | 3X3 | 6017694.7378197 | 2093654.8040295 | 37.7297694248505 | -122.381097672052 | (37.7297694248505, -122.381097672052) | 10 | 3 | 8 | 58 | 1 | ||
32894 | 85619 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 1338 Quesada Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/30/2007 12:00:00 AM | 3 | 3x3 | 6016653.5768 | 2093624.593 | 37.7296289450877 | -122.384695012523 | (37.7296289450877, -122.384695012523) | 10 | 3 | 8 | 58 | 1 | ||
33810 | 85643 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 1235 Quesada Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/30/2007 12:00:00 AM | 3 | 3x3 | 6017171.4256 | 2093155.5219 | 37.7283695937915 | -122.382872106202 | (37.7283695937915, -122.382872106202) | 10 | 3 | 8 | 58 | 1 | ||
33994 | 12670 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 1128 Lake St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/07/1998 12:00:00 AM | 6 | 3X3 | 5991921.00031 | 2114824.39199 | 37.786439173997 | -122.471741673868 | (37.786439173997, -122.471741673868) | 11 | 6 | 1 | 54 | 11 | ||
35912 | 24578 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 2301 Fillmore St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 07/12/1996 12:00:00 AM | 6 | 3x3 | 6002768.23016 | 2116232.67907 | 37.7909275993488 | -122.434313744932 | (37.7909275993488, -122.434313744932) | 13 | 9 | 1 | 29490 | 27 | ||
38222 | 7333 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 2066 Fillmore St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 3X3 | 6002924.90365 | 2115430.77271 | 37.7887346608959 | -122.433714323915 | (37.7887346608959, -122.433714323915) | 13 | 9 | 1 | 29490 | 27 | |||
38398 | 26478 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 120 Gold Mine Dr | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/30/2009 12:00:00 AM | 3 | 3X3 | 6001175.6711954 | 2098684.4538551 | 37.7426539948984 | -122.438566040387 | (37.7426539948984, -122.438566040387) | 2 | 7 | 5 | 63 | 7 | ||
40124 | 85656 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 1699X Quesada Ave | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/30/2007 12:00:00 AM | 3 | 3x3 | 6014788.408146 | 2094944.773563 | 37.7331505648623 | -122.391235394882 | (37.7331505648623, -122.391235394882) | 10 | 3 | 8 | 58 | 1 | ||
40192 | 85647 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 1351 Quesada Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/30/2007 12:00:00 AM | 3 | 3x3 | 6016557.1838 | 2093613.7118 | 37.7295937360014 | -122.385027498588 | (37.7295937360014, -122.385027498588) | 10 | 3 | 8 | 58 | 1 | ||
42075 | 85613 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 1190 Quesada Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/30/2007 12:00:00 AM | 3 | 3x3 | 6017458.1534 | 2093022.4369 | 37.728020006278 | -122.38187161186 | (37.728020006278, -122.38187161186) | 10 | 3 | 8 | 58 | 1 | ||
42867 | 18277 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 1950 Post St | 6 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/27/2007 12:00:00 AM | 6 | 4X4 | 6002776.9831 | 2114109.0569 | 37.7850971709049 | -122.434131584258 | (37.7850971709049, -122.434131584258) | 13 | 9 | 11 | 29490 | 13 | ||
42954 | 7334 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 2095X Fillmore St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 10 | 3X3 | 6002864.90775 | 2115441.94118 | 37.7887619221715 | -122.433922699489 | (37.7887619221715, -122.433922699489) | 13 | 9 | 1 | 29490 | 27 | |||
44763 | 90488 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 125 25th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/27/2008 12:00:00 AM | 6 | 3x3 | 5987997.51268 | 2115126.89685 | 37.7870419790043 | -122.485337990995 | (37.7870419790043, -122.485337990995) | 11 | 6 | 1 | 55 | 33 | ||
44842 | 85625 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 1430 Quesada Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/30/2007 12:00:00 AM | 3 | 3x3 | 6016164.799973 | 2093969.832807 | 37.7305498611727 | -122.386408842499 | (37.7305498611727, -122.386408842499) | 10 | 3 | 8 | 58 | 1 | ||
45127 | 4223 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 3975 Cesar Chavez St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6004059.37365 | 2100401.32602 | 37.7475317476004 | -122.428717394312 | (37.7475317476004, -122.428717394312) | 2 | 4 | 5 | 63 | 22 | |||
45531 | 85641 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 1215 Quesada Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/30/2007 12:00:00 AM | 3 | 3x3 | 6017274.7558 | 2093081.4055 | 37.7281717932443 | -122.382509730509 | (37.7281717932443, -122.382509730509) | 10 | 3 | 8 | 58 | 1 | ||
47357 | 18650 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 75 Reuel Ct | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 11/18/1999 12:00:00 AM | 3 | 3X4 | 6017333.6171273 | 2096134.4813377 | 37.7365581880217 | -122.382518585342 | (37.7365581880217, -122.382518585342) | 10 | 3 | 8 | 58 | 1 | ||
47740 | 85646 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 1321 Quesada Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/30/2007 12:00:00 AM | 3 | 3x3 | 6016609.4363 | 2093572.233 | 37.7294827335965 | -122.38484396609 | (37.7294827335965, -122.38484396609) | 10 | 3 | 8 | 58 | 1 | ||
47888 | 24563 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 1897 Fillmore St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 07/18/1996 12:00:00 AM | 6 | 3X3 | 6002968.48938 | 2114735.50901 | 37.7868281166698 | -122.433513817626 | (37.7868281166698, -122.433513817626) | 13 | 9 | 11 | 29490 | 27 | ||
48144 | 85622 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 1360 Quesada Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/30/2007 12:00:00 AM | 3 | 3x3 | 6016552.9396 | 2093696.0654 | 37.7298196279301 | -122.385047906896 | (37.7298196279301, -122.385047906896) | 10 | 3 | 8 | 58 | 1 | ||
48659 | 16518 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 330 Newhall St | 9 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/30/2006 12:00:00 AM | 3 | 3X3 | 6016409.9700879 | 2098376.06541 | 37.7426620571468 | -122.385868255606 | (37.7426620571468, -122.385868255606) | 10 | 3 | 8 | 58 | 1 | ||
49059 | 85653 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 1541 Quesada Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/30/2007 12:00:00 AM | 3 | 3x3 | 6015555.708 | 2094360.5338 | 37.7315889126514 | -122.388541843069 | (37.7315889126514, -122.388541843069) | 10 | 3 | 8 | 58 | 1 | ||
49154 | 87400 | - 12 | Pyrus kawakamii :: Evergreen Pear 83 | 400X Monterey Blvd | 10 | Median : Cutout | Tree | DPW 1 | 03/17/2008 12:00:00 AM | 3 | 3x3 | 5999413.960874 | 2094696.855647 | 37.7316046219852 | -122.44437099815 | (37.7316046219852, -122.44437099815) | 9 | 7 | 4 | 59 | 40 | ||
50797 | 16754 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 1795 O'Farrell St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 05/26/1992 12:00:00 AM | 6 | 4X4 | 6002743.54981 | 2113352.23837 | 37.783017241069 | -122.434193129672 | (37.783017241069, -122.434193129672) | 15 | 9 | 11 | 29490 | 41 | ||
51007 | 27085 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 747 Silver Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 2X3 | 6006317.37103 | 2093607.15152 | 37.729003994832 | -122.420427188268 | (37.729003994832, -122.420427188268) | 9 | 7 | 7 | 309 | 5 | |||
52624 | 1689 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 20 Baldwin Ct | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/02/2015 03:07:00 PM | 3 | 3X3 | 6017662.0080572 | 2093645.216342 | 37.7297412922242 | -122.381210157278 | (37.7297412922242, -122.381210157278) | 10 | 3 | 8 | 58 | 1 | ||
53362 | 16755 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 1795 O'Farrell St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 4X4 | 6002763.89978 | 2113354.27748 | 37.7830239949229 | -122.434122873023 | (37.7830239949229, -122.434122873023) | 15 | 9 | 11 | 29490 | 41 | |||
53704 | 18254 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 1830 Post St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/07/1998 12:00:00 AM | 12 | 4X4 | 6003416.3649635 | 2114195.205569 | 37.7853699806014 | -122.431925678527 | (37.7853699806014, -122.431925678527) | 13 | 9 | 11 | 29490 | 13 | ||
53938 | 7989 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 2148 Franklin St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 07/26/2012 12:00:00 AM | 3 | 3x3 | 6005571.0767989 | 2117355.4773403 | 37.7941692118946 | -122.4246959118 | (37.7941692118946, -122.4246959118) | 13 | 9 | 1 | 28858 | 27 | ||
54028 | 7329 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 2043 Fillmore St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 6002875.62738 | 2115359.09835 | 37.7885350652007 | -122.433879687382 | (37.7885350652007, -122.433879687382) | 13 | 9 | 1 | 29490 | 27 | ||||
54499 | 85635 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 1101 Quesada Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/30/2007 12:00:00 AM | 3 | 3x3 | 6017893.31364 | 2092631.421507 | 37.7269703746724 | -122.380340070254 | (37.7269703746724, -122.380340070254) | 10 | 3 | 8 | 58 | 1 | ||
55456 | 24180 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 101X Whitney Young Cir | 13 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 30 | 3x3 | 6016621.33395 | 2095295.74377 | 37.7342158098126 | -122.384922860422 | (37.7342158098126, -122.384922860422) | 10 | 3 | 8 | 58 | 1 | |||
56431 | 138440 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 1820 POST ST | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 07/16/2014 12:00:00 AM | 6 | Width 0ft | 6003498.0109 | 2114207.9928 | 37.7854097192823 | -122.431644121578 | (37.7854097192823, -122.431644121578) | 13 | 9 | 11 | 29490 | 13 | ||
57262 | 18634 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 15 Reuel Ct | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/04/1998 12:00:00 AM | 3 | 3X4 | 6017078.2420673 | 2096202.8624203 | 37.7367318383598 | -122.383406293435 | (37.7367318383598, -122.383406293435) | 10 | 3 | 8 | 58 | 1 | ||
57953 | 1698 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 39 Baldwin Ct | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/03/1992 12:00:00 AM | 12 | 3X3 | 6017750.7960904 | 2093602.6298867 | 37.72962925906 | -122.380900244658 | (37.72962925906, -122.380900244658) | 10 | 3 | 8 | 58 | 1 | ||
58251 | 85632 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 1582 Quesada Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/30/2007 12:00:00 AM | 3 | 3x3 | 6015365.5421 | 2094575.4322 | 37.7321684400373 | -122.38921428964 | (37.7321684400373, -122.38921428964) | 10 | 3 | 8 | 58 | 1 | ||
60316 | 10444 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 1508 Haight St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/04/1999 12:00:00 AM | 6 | 3x3 | 5998873.5099 | 2108710.5533 | 37.7700519575457 | -122.447247648975 | (37.7700519575457, -122.447247648975) | 15 | 5 | 11 | 29492 | 9 | ||
61213 | 7313 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 1950X Fillmore St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6002971.5982 | 2115063.05298 | 37.7877276455751 | -122.433526478312 | (37.7877276455751, -122.433526478312) | 13 | 9 | 11 | 29490 | 27 | |||
62004 | 18260 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 1870 Post St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/01/1990 12:00:00 AM | 6 | 4X4 | 6003225.4707245 | 2114168.1799394 | 37.7852849514104 | -122.432584183534 | (37.7852849514104, -122.432584183534) | 13 | 9 | 11 | 29490 | 13 | ||
62572 | 112504 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 601 WILLOW ST | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 01/14/2016 10:27:00 AM | 3 | 2x2 | 6004423 | 2113018 | 37.7821946822097 | -122.42835909049 | (37.7821946822097, -122.42835909049) | 7 | 9 | 11 | 29490 | 41 | ||
63378 | 6645 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 495X Newhall St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/16/1992 12:00:00 AM | 6 | 3x3 | 6016063.3688156 | 2097887.7750356 | 37.7413021249823 | -122.38703266472 | (37.7413021249823, -122.38703266472) | 10 | 3 | 8 | 58 | 1 | ||
63941 | 16550 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 500X Newhall St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/12/1998 12:00:00 AM | 3 | 3x3 | 6016006.287148 | 2097894.9109735 | 37.7413185578473 | -122.387230532448 | (37.7413185578473, -122.387230532448) | 10 | 3 | 8 | 58 | 1 | ||
64663 | 24178 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 101X Whitney Young Cir | 11 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/15/2001 12:00:00 AM | 4 | 4x3 | 6016619.18629 | 2095310.93644 | 37.7342574070589 | -122.384931343733 | (37.7342574070589, -122.384931343733) | 10 | 3 | 8 | 58 | 1 | ||
64888 | 85655 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 1699X Quesada Ave | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/30/2007 12:00:00 AM | 3 | 3x3 | 6014788.408146 | 2094944.773563 | 37.7331505648623 | -122.391235394882 | (37.7331505648623, -122.391235394882) | 10 | 3 | 8 | 58 | 1 | ||
66623 | 85652 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 1519 Quesada Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/30/2007 12:00:00 AM | 3 | 3x3 | 6015655.7374 | 2094284.1377 | 37.7313846871586 | -122.388190689138 | (37.7313846871586, -122.388190689138) | 10 | 3 | 8 | 58 | 1 | ||
66628 | 7304 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 1908 Fillmore St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 7 | 3X3 | 6002992.4511 | 2114925.4093 | 37.7873508941206 | -122.433444491336 | (37.7873508941206, -122.433444491336) | 13 | 9 | 11 | 29490 | 27 | |||
67141 | 29137 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 90x Jones St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 11/19/2005 12:00:00 AM | 3 | 3x3 | 6009115.3969879 | 2112842.7343052 | 37.7819778479132 | -122.412113051935 | (37.7819778479132, -122.412113051935) | 14 | 10 | 9 | 28852 | 36 | ||
67739 | 7327 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 2042 Fillmore St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 4X4 | 6002940.62895 | 2115331.17345 | 37.7884620789862 | -122.433652795594 | (37.7884620789862, -122.433652795594) | 13 | 9 | 1 | 29490 | 27 | |||
67812 | 18652 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 80 Reuel Ct | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 11/18/1999 12:00:00 AM | 3 | 6017340.7956251 | 2096041.6846084 | 37.7363037832445 | -122.382487311287 | (37.7363037832445, -122.382487311287) | 10 | 3 | 8 | 58 | 1 | |||
68326 | 7325 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 2027 Fillmore St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6002881.7283 | 2115306.8957 | 37.7883920762372 | -122.433854846414 | (37.7883920762372, -122.433854846414) | 13 | 9 | 1 | 29490 | 27 | |||
68572 | 24482 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 103X Sussex St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 3X3 | 6002240.5138934 | 2096668.0977393 | 37.7371780656004 | -122.434739971035 | (37.7371780656004, -122.434739971035) | 2 | 7 | 5 | 63 | 7 | |||
70918 | 16558 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 500X Newhall St | 9 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/27/1997 12:00:00 AM | 3 | 3x3 | 6016006.287148 | 2097894.9109735 | 37.7413185578473 | -122.387230532448 | (37.7413185578473, -122.387230532448) | 10 | 3 | 8 | 58 | 1 | ||
71111 | 15636 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 3620 Mission St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 3X3 | 6005333.6922 | 2097119.1421 | 37.7385916557518 | -122.424077498789 | (37.7385916557518, -122.424077498789) | 2 | 7 | 5 | 28859 | 2 | |||
72221 | 18272 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 1950 Post St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/27/2007 12:00:00 AM | 6 | 4X4 | 6002831.4981407 | 2114113.4681378 | 37.78511237688 | -122.433943294941 | (37.78511237688, -122.433943294941) | 13 | 9 | 11 | 29490 | 13 | ||
72830 | 7255 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 1940X Post St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/28/2011 12:00:00 AM | 3 | 3x3 | 6002883.2030311 | 2114120.5638209 | 37.7851347939031 | -122.433764919711 | (37.7851347939031, -122.433764919711) | 13 | 9 | 11 | 29490 | 13 | ||
73038 | 5934 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 1355 Eddy St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 4X4 | 6004029.33456 | 2112693.29822 | 37.781280848415 | -122.429697830179 | (37.781280848415, -122.429697830179) | 7 | 9 | 11 | 29490 | 41 | |||
76064 | 4354 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 15X Burnside Ave | 8 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/05/2008 12:00:00 AM | 3 | 3X3 | 6001141.00413 | 2095696.99513 | 37.7344491599181 | -122.438471913289 | (37.7344491599181, -122.438471913289) | 9 | 7 | 5 | 63 | 7 | ||
78779 | 8084 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 755X Fulton St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/14/2007 12:00:00 AM | 3 | 3X3 | 6004115.11785 | 2111289.80956 | 37.7774320731857 | -122.429300951982 | (37.7774320731857, -122.429300951982) | 7 | 9 | 11 | 28852 | 10 | ||
80776 | 16494 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 305X Newhall St | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 01/30/2003 12:00:00 AM | 3 | 3x3 | 6016769.45238 | 2098282.55627 | 37.7424251869258 | -122.384618745617 | (37.7424251869258, -122.384618745617) | 10 | 3 | 8 | 58 | 1 | ||
83069 | 85627 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 1466 Quesada Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/30/2007 12:00:00 AM | 3 | 3x3 | 6015977.8277 | 2094121.4228 | 37.7309557454266 | -122.387065808076 | (37.7309557454266, -122.387065808076) | 10 | 3 | 8 | 58 | 1 | ||
83082 | 16560 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 702X Newhall St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/03/1992 12:00:00 AM | 12 | 3X3 | 6015615.61867 | 2097370.07413 | 37.7398558207833 | -122.388544712683 | (37.7398558207833, -122.388544712683) | 10 | 3 | 8 | 58 | 1 | ||
85412 | 4406 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 1060 Church St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 10 | 3X3 | 6004384.57785 | 2102734.51473 | 37.7539565402887 | -122.427759074928 | (37.7539565402887, -122.427759074928) | 2 | 4 | 5 | 28862 | 22 | |||
87382 | 16010 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 100X Monterey Blvd | 4 | Median : Cutout | Tree | DPW 1 | 2 | 4 | 6001411.9312264 | 2094682.0759854 | 37.7316778334432 | -122.437462576871 | (37.7316778334432, -122.437462576871) | 9 | 7 | 4 | 63 | 40 | |||
88049 | 87399 | - 12 | Pyrus kawakamii :: Evergreen Pear 83 | 400X Monterey Blvd | 9 | Median : Cutout | Tree | DPW 1 | 03/17/2008 12:00:00 AM | 3 | 3x3 | 5999413.960874 | 2094696.855647 | 37.7316046219852 | -122.44437099815 | (37.7316046219852, -122.44437099815) | 9 | 7 | 4 | 59 | 40 |
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) );