340 rows where Police Districts = 3 and qSpecies_id = 8 sorted by qCaretaker_id

View and edit SQL

Police Districts

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)
32 264850 DPW Maintained 1 Eriobotrya deflexa :: Bronze Loquat 8 172 University St 1 Sidewalk: Curb side : Cutout Tree DPW 1   11/01/2020 12:00:00 AM 3     6007951 2093149 37.7278379340298 -122.414747181337 (37.7278379340298, -122.414747181337) 9 3 7 309 5
1793 260413 DPW Maintained 1 Eriobotrya deflexa :: Bronze Loquat 8 1510 Jerrold Ave 1 Sidewalk: Curb side : Cutout Tree DPW 1       3x3   6015825 2096697 37.7380192974637 -122.387773802776 (37.7380192974637, -122.387773802776) 10 3 8 58 1
6256 25549 DPW Maintained 1 Eriobotrya deflexa :: Bronze Loquat 8 141 Industrial St 3 Sidewalk: Curb side : Cutout Tree DPW 1   04/24/1998 12:00:00 AM 3 2X3   6011617.33955 2097194.17651 37.739150457318 -122.402356800142 (37.739150457318, -122.402356800142) 10 3 8 58 1
11677 26000 DPW Maintained 1 Eriobotrya deflexa :: Bronze Loquat 8 1715 Oakdale Ave 1 Sidewalk: Curb side : Cutout Tree DPW 1   04/25/2012 12:00:00 AM 3 3x3   6014353.43695 2095957.87317 37.7359081801195 -122.39281007034 (37.7359081801195, -122.39281007034) 10 3 8 58 1
14120 11922 DPW Maintained 1 Eriobotrya deflexa :: Bronze Loquat 8 620X Keith St 6 Sidewalk: Curb side : Cutout Tree DPW 1   05/10/2016 12:00:00 AM 3 3X4   6017350.6902257 2096387.6229349 37.7372542074531 -122.382477163454 (37.7372542074531, -122.382477163454) 10 3 8 58 1
21036 26579 DPW Maintained 1 Eriobotrya deflexa :: Bronze Loquat 8 241 Bay Shore Blvd 2 Sidewalk: Curb side : Cutout Tree DPW 1   01/22/1998 12:00:00 AM 6 3X3   6011098.44545 2099048.11598 37.7442119973787 -122.40428136282 (37.7442119973787, -122.40428136282) 10 3 8 58 1
24529 27530 DPW Maintained 1 Eriobotrya deflexa :: Bronze Loquat 8 1898X Oakdale Ave 1 Sidewalk: Curb side : Cutout Tree DPW 1     5 3X3   6013528.91672 2096649.27619 37.7377607988237 -122.395709213912 (37.7377607988237, -122.395709213912) 10 3 8 58 1
27617 26468 DPW Maintained 1 Eriobotrya deflexa :: Bronze Loquat 8 300X Keith St 5 Sidewalk: Curb side : Cutout Tree DPW 1   06/04/1998 12:00:00 AM 3 3X3   6017600.4401851 2096710.4383408 37.7381543871139 -122.381636098386 (37.7381543871139, -122.381636098386) 10 3 8 58 1
34407 25915 DPW Maintained 1 Eriobotrya deflexa :: Bronze Loquat 8 1800 Oakdale Ave 5 Sidewalk: Curb side : Cutout Tree DPW 1   06/16/2015 12:17:00 PM 3 3X3   6013847.66398 2096411.7192 37.737126242566 -122.394590512161 (37.737126242566, -122.394590512161) 10 3 8 58 1
34932 25993 DPW Maintained 1 Eriobotrya deflexa :: Bronze Loquat 8 1789 Oakdale Ave 1 Sidewalk: Curb side : Cutout Tree DPW 1   04/25/2012 12:00:00 AM 3 3x3   6014037.23638 2096196.21513 37.7365450503068 -122.393919988427 (37.7365450503068, -122.393919988427) 10 3 8 58 1
35198 6735 DPW Maintained 1 Eriobotrya deflexa :: Bronze Loquat 8 1300X Fairfax Ave 5 Sidewalk: Curb side : Cutout Tree DPW 1   12/14/2007 12:00:00 AM 2 3x3   6017028.4506 2097182.15302 37.7394180218109 -122.383646604615 (37.7394180218109, -122.383646604615) 10 3 8 58 1
45011 26562 DPW Maintained 1 Eriobotrya deflexa :: Bronze Loquat 8 550 Bay Shore Blvd 1 Sidewalk: Curb side : Cutout Tree DPW 1   01/14/1999 12:00:00 AM 6 3X3   6010221.3990328 2097223.1768194 37.7391520616783 -122.407185397649 (37.7391520616783, -122.407185397649) 10 3 7 58 2
45086 25999 DPW Maintained 1 Eriobotrya deflexa :: Bronze Loquat 8 1717 Oakdale Ave 1 Sidewalk: Curb side : Cutout Tree DPW 1   04/22/1997 12:00:00 AM 3 3x3   6014332.85691 2095971.76656 37.7359451854222 -122.392882195975 (37.7359451854222, -122.392882195975) 10 3 8 58 1
46268 15048 DPW Maintained 1 Eriobotrya deflexa :: Bronze Loquat 8 1119 Mendell St 1 Sidewalk: Curb side : Cutout Tree DPW 1   01/20/2000 12:00:00 AM 6 3X3   6015497.5853 2096021.456 37.7361462484719 -122.388858698526 (37.7361462484719, -122.388858698526) 10 3 8 58 1
50009 29491 DPW Maintained 1 Eriobotrya deflexa :: Bronze Loquat 8 1628X Ingalls St 4 Sidewalk: Curb side : Cutout Tree DPW 1   08/05/2015 07:30:00 AM 3 3x3   6016725.73414 2093293.65862 37.7287242549235 -122.384422514278 (37.7287242549235, -122.384422514278) 10 3 8 58 1
51068 25548 DPW Maintained 1 Eriobotrya deflexa :: Bronze Loquat 8 141 Industrial St 2 Sidewalk: Curb side : Cutout Tree DPW 1   04/06/2013 12:00:00 AM 3 2x3   6011568.62841 2097178.44526 37.7391045433316 -122.402524116297 (37.7391045433316, -122.402524116297) 10 3 8 58 1
60990 26105 DPW Maintained 1 Eriobotrya deflexa :: Bronze Loquat 8 1547 Oakdale Ave 1 Sidewalk: Curb side : Cutout Tree DPW 1   11/16/2009 12:00:00 AM 3 3x3   6015325.4204 2095230.2952 37.733964337308 -122.389398715375 (37.733964337308, -122.389398715375) 10 3 8 58 1
62116 26636 DPW Maintained 1 Eriobotrya deflexa :: Bronze Loquat 8 585X Bay Shore Blvd 1 Sidewalk: Curb side : Cutout Tree DPW 1   01/16/1998 12:00:00 AM 3 3X3   6010330.4322368 2096858.6143875 37.7381571529353 -122.406782722291 (37.7381571529353, -122.406782722291) 10 3 8 58 1
62754 26572 DPW Maintained 1 Eriobotrya deflexa :: Bronze Loquat 8 353 Bay Shore Blvd 2 Sidewalk: Curb side : Cutout Tree DPW 1   01/22/1998 12:00:00 AM 6 3X3   6010658.72053 2098280.84549 37.7420806571983 -122.405747809912 (37.7420806571983, -122.405747809912) 10 3 8 58 1
64088 26581 DPW Maintained 1 Eriobotrya deflexa :: Bronze Loquat 8 235 Bay Shore Blvd 2 Sidewalk: Curb side : Cutout Tree DPW 1   03/11/2006 12:00:00 AM 3 3X3   6011124.08251 2099133.7568 37.7444485811329 -122.404198741189 (37.7444485811329, -122.404198741189) 10 3 8 58 1
65573 26097 DPW Maintained 1 Eriobotrya deflexa :: Bronze Loquat 8 1583X Oakdale Ave 1 Sidewalk: Curb side : Cutout Tree DPW 1   02/08/2003 12:00:00 AM 6 3x3   6015137.4531 2095367.1486 37.7343296857828 -122.390058138496 (37.7343296857828, -122.390058138496) 10 3 8 58 1
71069 6736 DPW Maintained 1 Eriobotrya deflexa :: Bronze Loquat 8 1300X Fairfax Ave 6 Sidewalk: Curb side : Cutout Tree DPW 1   06/30/2011 12:00:00 AM 2 3x3   6017621.9936242 2096730.3826429 37.7382103402349 -122.381562963191 (37.7382103402349, -122.381562963191) 10 3 8 58 1
78610 26108 DPW Maintained 1 Eriobotrya deflexa :: Bronze Loquat 8 1509 Oakdale Ave 1 Sidewalk: Curb side : Cutout Tree DPW 1   02/08/2003 12:00:00 AM 3 3x3   6015422.1522 2095159.3952 37.7337750228344 -122.389059332361 (37.7337750228344, -122.389059332361) 10 3 8 58 1
80495 6734 DPW Maintained 1 Eriobotrya deflexa :: Bronze Loquat 8 1300X Fairfax Ave 4 Sidewalk: Curb side : Cutout Tree DPW 1     18 3x3   6017044.07799 2097171.21021 37.7393888388325 -122.383591809817 (37.7393888388325, -122.383591809817) 10 3 8 58 1
82554 26578 DPW Maintained 1 Eriobotrya deflexa :: Bronze Loquat 8 241 Bay Shore Blvd 1 Sidewalk: Curb side : Cutout Tree DPW 1   01/22/1998 12:00:00 AM 6 3X3   6011090.3987 2099026.28851 37.7441516142074 -122.404307650877 (37.7441516142074, -122.404307650877) 10 3 8 58 1
83138 6733 DPW Maintained 1 Eriobotrya deflexa :: Bronze Loquat 8 1300X Fairfax Ave 3 Sidewalk: Curb side : Cutout Tree DPW 1     20 3x3   6017061.2899 2097158.62505 37.7393552338433 -122.383531422133 (37.7393552338433, -122.383531422133) 10 3 8 58 1
83625 26617 DPW Maintained 1 Eriobotrya deflexa :: Bronze Loquat 8 1345X Bay Shore Blvd 3 Sidewalk: Curb side : Cutout Tree DPW 1   01/13/1998 12:00:00 AM 6 3X3   6011655.80292 2092935.6294354 37.7274595264664 -122.401924529742 (37.7274595264664, -122.401924529742) 10 3 8 58 1
85606 25919 DPW Maintained 1 Eriobotrya deflexa :: Bronze Loquat 8 1894X Oakdale Ave 2 Sidewalk: Curb side : Cutout Tree DPW 1   03/10/2007 12:00:00 AM 3 3X3   6013501.35934 2096660.10843 37.7377890089073 -122.395805252575 (37.7377890089073, -122.395805252575) 10 3 8 58 1
86822 26576 DPW Maintained 1 Eriobotrya deflexa :: Bronze Loquat 8 345 Bay Shore Blvd 2 Sidewalk: Curb side : Cutout Tree DPW 1   03/05/2006 12:00:00 AM 6 3X3   6010697.3878905 2098349.5702175 37.7422715227695 -122.405618949101 (37.7422715227695, -122.405618949101) 10 3 8 58 1
87822 26099 DPW Maintained 1 Eriobotrya deflexa :: Bronze Loquat 8 1583 Oakdale Ave 1 Sidewalk: Curb side : Cutout Tree DPW 1   01/19/2000 12:00:00 AM 6 3x3   6015122.55548 2095354.29386 37.7342935630106 -122.39010874709 (37.7342935630106, -122.39010874709) 10 3 8 58 1
89263 6737 DPW Maintained 1 Eriobotrya deflexa :: Bronze Loquat 8 1300X Fairfax Ave 7 Sidewalk: Curb side : Cutout Tree DPW 1   08/30/2012 12:00:00 AM 1 3x3   6017621.9936242 2096730.3826429 37.7382103402349 -122.381562963191 (37.7382103402349, -122.381562963191) 10 3 8 58 1
93997 26580 DPW Maintained 1 Eriobotrya deflexa :: Bronze Loquat 8 235 Bay Shore Blvd 1 Sidewalk: Curb side : Cutout Tree DPW 1   01/22/1998 12:00:00 AM 3 3X3   6011115.92553 2099106.52375 37.7443733492673 -122.404225030173 (37.7443733492673, -122.404225030173) 10 3 8 58 1
97080 26616 DPW Maintained 1 Eriobotrya deflexa :: Bronze Loquat 8 1345X Bay Shore Blvd 2 Sidewalk: Curb side : Cutout Tree DPW 1   01/13/1998 12:00:00 AM 6 3X3   6011655.80292 2092935.6294354 37.7274595264664 -122.401924529742 (37.7274595264664, -122.401924529742) 10 3 8 58 1
100528 26612 DPW Maintained 1 Eriobotrya deflexa :: Bronze Loquat 8 1365 Bay Shore Blvd 1 Sidewalk: Curb side : Cutout Tree DPW 1   04/11/2016 12:00:00 AM 3 3X3   6011668.1233381 2092874.095386 37.7272912542879 -122.401877614076 (37.7272912542879, -122.401877614076) 10 3 8 58 1
106253 26574 DPW Maintained 1 Eriobotrya deflexa :: Bronze Loquat 8 355 Bay Shore Blvd 4 Sidewalk: Curb side : Cutout Tree DPW 1   03/18/2006 12:00:00 AM 3 3X3   6010658.7520522 2098287.1955653 37.742098094898 -122.4057481481 (37.742098094898, -122.4057481481) 10 3 8 58 1
112276 26109 DPW Maintained 1 Eriobotrya deflexa :: Bronze Loquat 8 1509 Oakdale Ave 2 Sidewalk: Curb side : Cutout Tree DPW 1   01/09/2010 12:00:00 AM 3 3x3   6015436.4421 2095148.403 37.7337456325918 -122.389009160289 (37.7337456325918, -122.389009160289) 10 3 8 58 1
114959 26613 DPW Maintained 1 Eriobotrya deflexa :: Bronze Loquat 8 1355 Bay Shore Blvd 1 Sidewalk: Curb side : Cutout Tree DPW 1   02/26/2015 10:59:00 PM 3 3X3   6011681.24548 2092829.46631 37.7271694443921 -122.401829114846 (37.7271694443921, -122.401829114846) 10 3 8 58 1
117124 25547 DPW Maintained 1 Eriobotrya deflexa :: Bronze Loquat 8 141 Industrial St 1 Sidewalk: Curb side : Cutout Tree DPW 1   03/01/2014 12:00:00 AM 3 2x3   6011520.04511 2097161.49572 37.7390552910796 -122.402690904578 (37.7390552910796, -122.402690904578) 10 3 8 58 1
117963 26101 DPW Maintained 1 Eriobotrya deflexa :: Bronze Loquat 8 1567 Oakdale Ave 1 Sidewalk: Curb side : Cutout Tree DPW 1   10/30/2015 08:01:00 AM 3 3x3   6015220.6525535 2095312.3188681 37.7341837485135 -122.389766660198 (37.7341837485135, -122.389766660198) 10 3 8 58 1
119510 102645 DPW Maintained 1 Eriobotrya deflexa :: Bronze Loquat 8 1800 Oakdale Ave 8 Sidewalk: Curb side : Cutout Tree DPW 1   06/16/2015 12:33:00 PM 3 3x3   6013980.4 2096382.2 37.7370525675082 -122.394129514082 (37.7370525675082, -122.394129514082) 10 3 8 58 1
130010 27245 DPW Maintained 1 Eriobotrya deflexa :: Bronze Loquat 8 1840X Oakdale Ave 1 Sidewalk: Curb side : Cutout Tree DPW 1   03/11/2006 12:00:00 AM 3 3X3   6013813.10368 2096437.28943 37.7371945316856 -122.394711793835 (37.7371945316856, -122.394711793835) 10 3 8 58 1
135088 26590 DPW Maintained 1 Eriobotrya deflexa :: Bronze Loquat 8 1645 Bay Shore Blvd 2 Sidewalk: Curb side : Cutout Tree DPW 1   02/18/1998 12:00:00 AM 6 3X3   6012121.9317 2091099.07322 37.7224427228244 -122.400184180161 (37.7224427228244, -122.400184180161) 10 3 8 58 1
137477 26114 DPW Maintained 1 Eriobotrya deflexa :: Bronze Loquat 8 1505 Oakdale Ave 2 Sidewalk: Curb side : Cutout Tree DPW 1   04/22/1997 12:00:00 AM 6 3x3   6015470.5181 2095128.0673 37.7336916836833 -122.388889929187 (37.7336916836833, -122.388889929187) 10 3 8 58 1
139957 29367 DPW Maintained 1 Eriobotrya deflexa :: Bronze Loquat 8 367X Bay Shore Blvd 1 Sidewalk: Curb side : Cutout Tree DPW 1   03/20/2006 12:00:00 AM 3 3X3   6010545.10979 2098098.42904 37.7415734269678 -122.40612779327 (37.7415734269678, -122.40612779327) 10 3 8 58 1
140260 15015 DPW Maintained 1 Eriobotrya deflexa :: Bronze Loquat 8 650 Mendell St 1 Sidewalk: Curb side : Cutout Tree DPW 1   05/14/2014 12:00:00 AM 6 3x3   6016271.14274 2097128.24206 37.7392281047953 -122.386261308815 (37.7392281047953, -122.386261308815) 10 3 8 58 1
154718 26418 DPW Maintained 1 Eriobotrya deflexa :: Bronze Loquat 8 1438 Oakdale Ave 1 Sidewalk: Curb side : Cutout Tree DPW 1   04/22/1997 12:00:00 AM 3 3   6015934.46626 2094872.09535 37.733014540811 -122.387268060397 (37.733014540811, -122.387268060397) 10 3 8 58 1
156569 26634 DPW Maintained 1 Eriobotrya deflexa :: Bronze Loquat 8 959X Bay Shore Blvd 1 Sidewalk: Curb side : Cutout Tree DPW 1   01/16/1998 12:00:00 AM 3 3x3   6010948.2451591 2094911.3215655 37.7328448487082 -122.404509586514 (37.7328448487082, -122.404509586514) 10 3 8 58 1
163366 26556 DPW Maintained 1 Eriobotrya deflexa :: Bronze Loquat 8 228 Bay Shore Blvd 1 Sidewalk: Curb side : Cutout Tree DPW 1   01/09/1998 12:00:00 AM 12 3x3   6011088.04001 2099355.12223 37.7450543887552 -122.404338947303 (37.7450543887552, -122.404338947303) 10 3 7 58 2
166323 26112 DPW Maintained 1 Eriobotrya deflexa :: Bronze Loquat 8 1509 Oakdale Ave 5 Sidewalk: Curb side : Cutout Tree DPW 1   02/08/2003 12:00:00 AM 3 3x3   6015459.73624 2095054.56513 37.7334892639404 -122.388922075695 (37.7334892639404, -122.388922075695) 10 3 8 58 1
166708 26100 DPW Maintained 1 Eriobotrya deflexa :: Bronze Loquat 8 1577 Oakdale Ave 1 Sidewalk: Curb side : Cutout Tree DPW 1     12 3x3   6015169.8802 2095341.3169 37.7342605555935 -122.389944222732 (37.7342605555935, -122.389944222732) 10 3 8 58 1
172955 26119 DPW Maintained 1 Eriobotrya deflexa :: Bronze Loquat 8 1475 Oakdale Ave 1 Sidewalk: Curb side : Cutout Tree DPW 1   02/08/2003 12:00:00 AM 3 3X3   6015692.20395 2094932.76911 37.7331677192347 -122.388109864863 (37.7331677192347, -122.388109864863) 10 3 8 58 1
192708 15051 DPW Maintained 1 Eriobotrya deflexa :: Bronze Loquat 8 1137 Mendell St 1 Sidewalk: Curb side : Cutout Tree DPW 1   01/20/2000 12:00:00 AM 3 8X18   6015459.2819 2095972.4779 37.736009641441 -122.388987711638 (37.736009641441, -122.388987711638) 10 3 8 58 1
10 264794 Undocumented 4 Eriobotrya deflexa :: Bronze Loquat 8 31 Dwight St 1 Sidewalk: Curb side : Cutout Tree Private 2   11/01/2020 12:00:00 AM 3 3x3   6011433 2091603 37.7237879639177 -122.40260109208 (37.7237879639177, -122.40260109208) 10 3 7 309 28
806 189267 DPW Maintained 1 Eriobotrya deflexa :: Bronze Loquat 8 1300 Fairfax Ave 6 : Tree Private 2     1 Width 4ft   6017011.55747 2097196.03632 37.7394552087924 -122.383705980546 (37.7394552087924, -122.383705980546) 10 3 8 58 1
1268 261097 DPW Maintained 1 Eriobotrya deflexa :: Bronze Loquat 8 1999 Carroll Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   10/19/2019 12:00:00 AM 3 4x6   6012390 2093339 37.7286080475288 -122.399414697344 (37.7286080475288, -122.399414697344) 10 3 8 58 1
1530 191101 DPW Maintained 1 Eriobotrya deflexa :: Bronze Loquat 8 2041 26th St 5 Sidewalk: Curb side : Cutout Tree Private 2     6 Width 2ft   6012369.93883 2101402.46492 37.7507475020033 -122.400050093052 (37.7507475020033, -122.400050093052) 10 3 8 28856 1
1997 61779 DPW Maintained 1 Eriobotrya deflexa :: Bronze Loquat 8 2227 24th St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 01/22/1985 12:00:00 AM 9   Permit Number 21800 6011831.44367 2102306.03776 37.7531984774519 -122.401975779864 (37.7531984774519, -122.401975779864) 10 3 8 28856 29
2148 154032 DPW Maintained 1 Eriobotrya deflexa :: Bronze Loquat 8 1662 Kirkwood Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     3 Width 3ft   6014879.40227 2097032.81009 37.7388889362706 -122.391066694069 (37.7388889362706, -122.391066694069) 10 3 8 58 1
3646 189251 DPW Maintained 1 Eriobotrya deflexa :: Bronze Loquat 8 120 Loomis St 1 : Tree Private 2     1 Width 4ft   6010844.92077 2097998.29295 37.7413152397136 -122.405084094075 (37.7413152397136, -122.405084094075) 10 3 8 58 1
3755 200657 DPW Maintained 1 Eriobotrya deflexa :: Bronze Loquat 8 1520 Oakdale Ave 11 Sidewalk: Curb side : Cutout Tree Private 2     3 Width 0ft   6015286.398 2095330.3246 37.7342368342044 -122.389540612503 (37.7342368342044, -122.389540612503) 10 3 8 58 1
4551 189261 DPW Maintained 1 Eriobotrya deflexa :: Bronze Loquat 8 2215 Newcomb Ave 1 : Tree Private 2     1 Width 3ft   6011901.66973 2098145.68488 37.7417789652237 -122.401440561855 (37.7417789652237, -122.401440561855) 10 3 8 58 1
4634 61780 DPW Maintained 1 Eriobotrya deflexa :: Bronze Loquat 8 2127 24th St 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF 01/22/1985 12:00:00 AM 9   Permit Number 21802 6012087.28443 2102320.53166 37.7532525500908 -122.401092043975 (37.7532525500908, -122.401092043975) 10 3 8 28856 29
5283 71380 DPW Maintained 1 Eriobotrya deflexa :: Bronze Loquat 8 1415 Lane St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF   7     6015545.815 2094978.0232 37.7332838660921 -122.388619133184 (37.7332838660921, -122.388619133184) 10 3 8 58 1
5548 64543 Permitted Site 7 Eriobotrya deflexa :: Bronze Loquat 8 1547 Oakdale Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/25/1988 12:00:00 AM     Permit Number 25426 6015321.62159268 2095235.25021997 37.7339777321734 -122.389412195042 (37.7339777321734, -122.389412195042) 10 3 8 58 1
6010 162250 DPW Maintained 1 Eriobotrya deflexa :: Bronze Loquat 8 40 Olmstead St 1 Sidewalk: Curb side : Cutout Tree Private 2   10/23/2020 12:00:00 AM 3 Width 0ft   6011508.76761 2091210.5075 37.7227144898747 -122.402311591215 (37.7227144898747, -122.402311591215) 10 3 7 309 28
6046 81390 DPW Maintained 1 Eriobotrya deflexa :: Bronze Loquat 8 1588 Indiana St 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF   5     6015103.68734 2101191.55999 37.750320442739 -122.390581737352 (37.750320442739, -122.390581737352) 10 3 8 28856 1
6326 117138 Section 143 10 Eriobotrya deflexa :: Bronze Loquat 8 2203x NEWCOMB AVE 3 Sidewalk: Curb side : Cutout Tree Private 2   07/13/2016 12:00:00 AM 3 3x3 Permit Number 774325 6011983 2098083 37.7416113834488 -122.4011549432 (37.7416113834488, -122.4011549432) 10 3 8 58 1
7390 27682 Permitted Site 7 Eriobotrya deflexa :: Bronze Loquat 8 141 Industrial St 5 Sidewalk: Curb side : Cutout Tree Private 2   09/19/2009 12:00:00 AM 3 2X3   6011440.5288809 2097124.3937126 37.738948976933 -122.402963228074 (37.738948976933, -122.402963228074) 10 3 8 58 1
8512 117149 Section 806 (d) 5 Eriobotrya deflexa :: Bronze Loquat 8 928 Toland St 4 Sidewalk: Curb side : Cutout Tree Private 2   07/13/2016 12:00:00 AM 3 3x3 Permit Number 774325 6011929.15518 2097982.19203 37.7413315821976 -122.401334038935 (37.7413315821976, -122.401334038935) 10 3 8 58 1
8525 117146 Section 806 (d) 5 Eriobotrya deflexa :: Bronze Loquat 8 928 Toland St 1 Sidewalk: Curb side : Cutout Tree Private 2   07/13/2016 12:00:00 AM 3 3x3 Permit Number 774325 6011982.52405 2098055.99364 37.741537203178 -122.401154691646 (37.741537203178, -122.401154691646) 10 3 8 58 1
9764 150815 DPW Maintained 1 Eriobotrya deflexa :: Bronze Loquat 8 640 Texas St 1 Sidewalk: Curb side : Cutout Tree Private 2     3 Width 3ft   6013813.37874 2104087.70708 37.7582009725247 -122.395246594574 (37.7582009725247, -122.395246594574) 10 3 8 28856 29
10285 64550 DPW Maintained 1 Eriobotrya deflexa :: Bronze Loquat 8 1407 Lane St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/25/1988 12:00:00 AM 9   Permit Number 25433 6015557.9064 2094994.5115 37.7333298097375 -122.388578480063 (37.7333298097375, -122.388578480063) 10 3 8 58 1
10433 189238 DPW Maintained 1 Eriobotrya deflexa :: Bronze Loquat 8 2126 24th St 1 : Tree Private 2     13 Width 3ft   6012108.67622 2102369.63804 37.75338857883 -122.401021516451 (37.75338857883, -122.401021516451) 10 3 8 28856 29
10674 117147 Section 806 (d) 5 Eriobotrya deflexa :: Bronze Loquat 8 928 Toland St 2 Sidewalk: Curb side : Cutout Tree Private 2   07/13/2016 12:00:00 AM 3 3x3 Permit Number 774325 6011972.25416 2098042.58697 37.7414998183769 -122.40118925978 (37.7414998183769, -122.40118925978) 10 3 8 58 1
11137 46998 Permitted Site 7 Eriobotrya deflexa :: Bronze Loquat 8 2011 26th St 15 Sidewalk: Curb side : Cutout Tree Private 2   05/01/2002 12:00:00 AM     Permit Number 44999 6012426.60175733 2101420.79231292 37.7508009841444 -122.399855433268 (37.7508009841444, -122.399855433268) 10 3 8 28856 1
11488 71394 DPW Maintained 1 Eriobotrya deflexa :: Bronze Loquat 8 1549 Kirkwood Ave 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF   15     6015490.02353 2096504.22569 37.7374714167655 -122.388918537456 (37.7374714167655, -122.388918537456) 10 3 8 58 1
11678 262547 DPW Maintained 1 Eriobotrya deflexa :: Bronze Loquat 8 1329 Egbert Ave 3 Sidewalk: Curb side : Cutout Tree Private 2   08/20/2020 12:00:00 AM   Width 0ft   6014600.2068 2090881.6643 37.7219836364279 -122.391602089471 (37.7219836364279, -122.391602089471) 10 3 8 58 1
11903 73567 DPW Maintained 1 Eriobotrya deflexa :: Bronze Loquat 8 1549 Kirkwood Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF   17     6015475.76559 2096515.71199 37.7375021654981 -122.388968635992 (37.7375021654981, -122.388968635992) 10 3 8 58 1
12361 61778 DPW Maintained 1 Eriobotrya deflexa :: Bronze Loquat 8 2219 24th St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 01/22/1985 12:00:00 AM 13   Permit Number 21799 6011858.65617 2102307.02304 37.7532027015499 -122.401881742259 (37.7532027015499, -122.401881742259) 10 3 8 28856 29
13100 176239 DPW Maintained 1 Eriobotrya deflexa :: Bronze Loquat 8 901 Olmstead St 1 Sidewalk: Curb side : Cutout Tree Private 2     2 Width 3ft   6009040.83689 2090406.80665 37.7203696227506 -122.410785993677 (37.7203696227506, -122.410785993677) 9 3 7 309 28
13864 38641 DPW Maintained 1 Eriobotrya deflexa :: Bronze Loquat 8 1595 Shafter Ave 3 Sidewalk: Curb side : Cutout Tree Private 2 FUF 09/17/1998 12:00:00 AM 16 4x10 Permit Number 40566 6014964.8748 2094103.3153 37.7308498822776 -122.39056651931 (37.7308498822776, -122.39056651931) 10 3 8 58 1
15768 61783 DPW Maintained 1 Eriobotrya deflexa :: Bronze Loquat 8 2104 24th St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 01/22/1985 12:00:00 AM 13   Permit Number 21805 6012173.04745 2102374.48428 37.7534054761945 -122.400799246287 (37.7534054761945, -122.400799246287) 10 3 8 28856 29
16058 111561 DPW Maintained 1 Eriobotrya deflexa :: Bronze Loquat 8 1498x Kansas St 2 Sidewalk: Curb side : Cutout Tree Private 2   03/28/2017 12:00:00 AM 3 3x3 Permit Number 779654 6011715.78319 2101470.38867 37.7508975116216 -122.402317008737 (37.7508975116216, -122.402317008737) 10 3 8 28856 29
16994 261098 DPW Maintained 1 Eriobotrya deflexa :: Bronze Loquat 8 1999 Carroll Ave 2 Sidewalk: Curb side : Cutout Tree Private 2   10/19/2019 12:00:00 AM 3 4x6   6012390 2093339 37.7286080475288 -122.399414697344 (37.7286080475288, -122.399414697344) 10 3 8 58 1
18014 117148 Section 806 (d) 5 Eriobotrya deflexa :: Bronze Loquat 8 928 Toland St 3 Sidewalk: Curb side : Cutout Tree Private 2   07/13/2016 12:00:00 AM 3 3x3 Permit Number 774325 6011961.8463 2098027.63913 37.7414581941431 -122.401224196662 (37.7414581941431, -122.401224196662) 10 3 8 58 1
19092 150813 DPW Maintained 1 Eriobotrya deflexa :: Bronze Loquat 8 25 Sierra St 6 Sidewalk: Curb side : Cutout Tree Private 2     3 Width 3ft   6013747.19893 2104113.81693 37.758268983752 -122.395477303948 (37.758268983752, -122.395477303948) 10 3 8 28856 29
19307 191107 DPW Maintained 1 Eriobotrya deflexa :: Bronze Loquat 8 2021 26th St 2 Sidewalk: Curb side : Cutout Tree Private 2     5 Width 2ft   6012536.97765 2101462.04256 37.7509204011789 -122.399476636765 (37.7509204011789, -122.399476636765) 10 3 8 28856 1
19885 191110 DPW Maintained 1 Eriobotrya deflexa :: Bronze Loquat 8 2251 24th St 3 : Tree Private 2     7 Width 3ft   6011791.4986 2102301.92631 37.7531849588319 -122.40211362974 (37.7531849588319, -122.40211362974) 10 3 8 28856 29
20316 200101 DPW Maintained 1 Eriobotrya deflexa :: Bronze Loquat 8 1528 Yosemite Ave 6 Sidewalk: Curb side : Cutout Tree Private 2     1 Width 0ft   6015012.674 2092395.4762 37.7261631500088 -122.39028199338 (37.7261631500088, -122.39028199338) 10 3 8 58 1
22344 189270 DPW Maintained 1 Eriobotrya deflexa :: Bronze Loquat 8 59 Robblee Ave 1 : Tree Private 2     1 Width 3ft   6012477.87962 2095853.3507 37.735516831132 -122.39928732315 (37.735516831132, -122.39928732315) 10 3 8 58 1
23656 191084 DPW Maintained 1 Eriobotrya deflexa :: Bronze Loquat 8 1050 18th St 2 Sidewalk: Property side : Yard Tree Private 2     13     6014440.03961 2105781.9689 37.7628878793072 -122.393197865211 (37.7628878793072, -122.393197865211) 14 3 8 28856 29
24039 189257 DPW Maintained 1 Eriobotrya deflexa :: Bronze Loquat 8 2231 Newcomb Ave 1 : Tree Private 2     1 Width 3ft   6011833.55798 2098197.58892 37.7419176820557 -122.40167971856 (37.7419176820557, -122.40167971856) 10 3 8 58 1
25666 84783 DPW Maintained 1 Eriobotrya deflexa :: Bronze Loquat 8 280 Charter Oak Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   05/09/2007 12:00:00 AM 7   Permit No. 49320 6010967.59518 2095106.34893 37.7333814341037 -122.404456411357 (37.7333814341037, -122.404456411357) 10 3 8 58 1
28331 94753 DPW Maintained 1 Eriobotrya deflexa :: Bronze Loquat 8 491 Bay Shore Blvd 6 Sidewalk: Curb side : Cutout Tree Private 2   10/28/2010 12:00:00 AM 5 3x3   6010359.28963 2097585.56035 37.7401548048867 -122.406734163873 (37.7401548048867, -122.406734163873) 10 3 8 58 1
29467 191681 DPW Maintained 1 Eriobotrya deflexa :: Bronze Loquat 8 1241 Oakdale Ave 3 Sidewalk: Curb side : Cutout Tree Private 2     2 Width 3ft   6017111.18893 2093915.90803 37.7304541363294 -122.383133251796 (37.7304541363294, -122.383133251796) 10 3 8 58 1
29812 99390 DPW Maintained 1 Eriobotrya deflexa :: Bronze Loquat 8 1590 Yosemite Ave 13 Sidewalk: Curb side : Cutout Tree Private 2   05/09/2012 12:00:00 AM   3x3 Permit Number 768917 6014911.1 2092490.7 37.726418980856 -122.390639783135 (37.726418980856, -122.390639783135) 10 3 8 58 1
30232 99397 DPW Maintained 1 Eriobotrya deflexa :: Bronze Loquat 8 1590 Yosemite Ave 20 Sidewalk: Curb side : Cutout Tree Private 2   05/09/2012 12:00:00 AM   3x3 Permit Number 768917 6014911.1 2092490.7 37.726418980856 -122.390639783135 (37.726418980856, -122.390639783135) 10 3 8 58 1
30856 15055 DPW Maintained 1 Eriobotrya deflexa :: Bronze Loquat 8 1224 Mendell St 1 Sidewalk: Curb side : Cutout Tree Private 2   03/11/2006 12:00:00 AM 3 3x3   6015288.0468 2095812.3346 37.7355604273252 -122.389568564294 (37.7355604273252, -122.389568564294) 10 3 8 58 1
31011 189240 DPW Maintained 1 Eriobotrya deflexa :: Bronze Loquat 8 690 Texas St 1 : Tree Private 2     6 Width 3ft   6013877.57271 2103955.2138 37.7578407445781 -122.39501530244 (37.7578407445781, -122.39501530244) 10 3 8 28856 29
31365 189263 DPW Maintained 1 Eriobotrya deflexa :: Bronze Loquat 8 2211 Newcomb Ave 1 : Tree Private 2     1 Width 3ft   6011935.60653 2098120.24236 37.7417109989595 -122.401321431357 (37.7417109989595, -122.401321431357) 10 3 8 58 1

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)
);