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

View and edit SQL

These facets timed out: 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)
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
72397 176240 DPW Maintained 1 Eriobotrya deflexa :: Bronze Loquat 8 901 Olmstead St 2 Sidewalk: Curb side : Cutout Tree Private 2     2 Width 3ft   6009052.31678 2090410.35877 37.7203800198047 -122.41074656201 (37.7203800198047, -122.41074656201) 9 3 7 309 28
140001 176241 DPW Maintained 1 Eriobotrya deflexa :: Bronze Loquat 8 901 Olmstead St 3 Sidewalk: Curb side : Cutout Tree Private 2     2 Width 3ft   6009064.84821 2090413.67882 37.7203898385876 -122.410703479104 (37.7203898385876, -122.410703479104) 9 3 7 309 28
81467 176242 DPW Maintained 1 Eriobotrya deflexa :: Bronze Loquat 8 901 Olmstead St 4 Sidewalk: Curb side : Cutout Tree Private 2     1 Width 3ft   6009078.67243 2090418.23511 37.7204031242939 -122.41065601467 (37.7204031242939, -122.41065601467) 9 3 7 309 28
55786 95669 Permitted Site 7 Eriobotrya deflexa :: Bronze Loquat 8 800 Colby St 4 Sidewalk: Curb side : Cutout Tree Private 2 FUF 03/08/2011 12:00:00 AM   3x3 Permit Number 767425 6009110 2090446 37.7204811172617 -122.41054968459 (37.7204811172617, -122.41054968459) 9 3 7 309 28
69871 95668 Permitted Site 7 Eriobotrya deflexa :: Bronze Loquat 8 800 Colby St 3 Sidewalk: Curb side : Cutout Tree Private 2 FUF 03/08/2011 12:00:00 AM   3x3 Permit Number 767425 6009110 2090446 37.7204811172617 -122.41054968459 (37.7204811172617, -122.41054968459) 9 3 7 309 28
74862 95670 Permitted Site 7 Eriobotrya deflexa :: Bronze Loquat 8 800 Colby St 5 Sidewalk: Curb side : Cutout Tree Private 2 FUF 03/08/2011 12:00:00 AM   3x3 Permit Number 767425 6009110 2090446 37.7204811172617 -122.41054968459 (37.7204811172617, -122.41054968459) 9 3 7 309 28
188535 95671 Permitted Site 7 Eriobotrya deflexa :: Bronze Loquat 8 800 Colby St 6 Sidewalk: Curb side : Cutout Tree Private 2 FUF 03/08/2011 12:00:00 AM   3x3 Permit Number 767425 6009110 2090446 37.7204811172617 -122.41054968459 (37.7204811172617, -122.41054968459) 9 3 7 309 28
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
48749 103917 Permitted Site 7 Eriobotrya deflexa :: Bronze Loquat 8 1300X Fitzgerald Ave 4 Sidewalk: Property side : Yard Tree Private 2   06/19/2013 12:00:00 AM     Permit Number 770276 6014139.7 2090933.3 37.7220998454463 -122.393197569728 (37.7220998454463, -122.393197569728) 10 3 8 58 1
76198 103919 Permitted Site 7 Eriobotrya deflexa :: Bronze Loquat 8 1300X Fitzgerald Ave 6 Sidewalk: Property side : Yard Tree Private 2   06/19/2013 12:00:00 AM     Permit Number 770276 6014139.7 2090933.3 37.7220998454463 -122.393197569728 (37.7220998454463, -122.393197569728) 10 3 8 58 1
159416 103923 Permitted Site 7 Eriobotrya deflexa :: Bronze Loquat 8 1300X Fitzgerald Ave 10 Sidewalk: Property side : Yard Tree Private 2   06/19/2013 12:00:00 AM     Permit Number 770276 6014139.7 2090933.3 37.7220998454463 -122.393197569728 (37.7220998454463, -122.393197569728) 10 3 8 58 1
179325 103921 Permitted Site 7 Eriobotrya deflexa :: Bronze Loquat 8 1300X Fitzgerald Ave 8 Sidewalk: Property side : Yard Tree Private 2   06/19/2013 12:00:00 AM     Permit Number 770276 6014139.7 2090933.3 37.7220998454463 -122.393197569728 (37.7220998454463, -122.393197569728) 10 3 8 58 1
187500 103915 Permitted Site 7 Eriobotrya deflexa :: Bronze Loquat 8 1300X Fitzgerald Ave 2 Sidewalk: Property side : Yard Tree Private 2   06/19/2013 12:00:00 AM     Permit Number 770276 6014139.7 2090933.3 37.7220998454463 -122.393197569728 (37.7220998454463, -122.393197569728) 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
98398 189247 DPW Maintained 1 Eriobotrya deflexa :: Bronze Loquat 8 1645 Bay Shore Blvd 3 : Tree Private 2     11 Width 3ft   6012112.47662 2091125.23091 37.7225140193029 -122.400218700647 (37.7225140193029, -122.400218700647) 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
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
182774 255792 Planning Code 138.1 required 2 Eriobotrya deflexa :: Bronze Loquat 8 368 Princeton St 1 Sidewalk: Curb side : Cutout Tree Private 2   07/18/2018 12:00:00 AM 3 3x3   6007843 2092137 37.7250531301082 -122.415048939995 (37.7250531301082, -122.415048939995) 9 3 7 309 28
161725 189248 DPW Maintained 1 Eriobotrya deflexa :: Bronze Loquat 8 1575 Bay Shore Blvd 13 : Tree Private 2     5 Width 3ft   6011796.69629 2092248.5093 37.7255806984826 -122.401389189886 (37.7255806984826, -122.401389189886) 10 3 8 58 1
57195 200096 DPW Maintained 1 Eriobotrya deflexa :: Bronze Loquat 8 1528 Yosemite Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     1 Width 0ft   6015074.2617 2092350.8083 37.7260439168499 -122.390065967336 (37.7260439168499, -122.390065967336) 10 3 8 58 1
80616 200100 DPW Maintained 1 Eriobotrya deflexa :: Bronze Loquat 8 1528 Yosemite Ave 5 Sidewalk: Curb side : Cutout Tree Private 2     1 Width 0ft   6015024.8562 2092385.3244 37.7261359509126 -122.390239170909 (37.7261359509126, -122.390239170909) 10 3 8 58 1
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
90719 200102 DPW Maintained 1 Eriobotrya deflexa :: Bronze Loquat 8 1528 Yosemite Ave 7 Sidewalk: Curb side : Cutout Tree Private 2     1 Width 0ft   6014998.4615 2092408.3352 37.7261976699 -122.390332023639 (37.7261976699, -122.390332023639) 10 3 8 58 1
110041 200106 DPW Maintained 1 Eriobotrya deflexa :: Bronze Loquat 8 1536 Yosemite Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     1 Width 0ft   6014892.206 2092484.8121 37.726401765616 -122.390704688118 (37.726401765616, -122.390704688118) 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
32256 99396 DPW Maintained 1 Eriobotrya deflexa :: Bronze Loquat 8 1590 Yosemite Ave 19 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
38088 99382 DPW Maintained 1 Eriobotrya deflexa :: Bronze Loquat 8 1590 Yosemite Ave 5 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
48395 99378 DPW Maintained 1 Eriobotrya deflexa :: Bronze Loquat 8 1590 Yosemite Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   05/09/2012 12:00:00 AM 1 3x3 Permit Number 768917 6014911.1 2092490.7 37.726418980856 -122.390639783135 (37.726418980856, -122.390639783135) 10 3 8 58 1
56655 99384 DPW Maintained 1 Eriobotrya deflexa :: Bronze Loquat 8 1590 Yosemite Ave 7 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
74544 99389 DPW Maintained 1 Eriobotrya deflexa :: Bronze Loquat 8 1590 Yosemite Ave 12 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
95979 99388 DPW Maintained 1 Eriobotrya deflexa :: Bronze Loquat 8 1590 Yosemite Ave 11 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
147844 99392 DPW Maintained 1 Eriobotrya deflexa :: Bronze Loquat 8 1590 Yosemite Ave 15 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
165704 99383 DPW Maintained 1 Eriobotrya deflexa :: Bronze Loquat 8 1590 Yosemite Ave 6 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
181547 99391 DPW Maintained 1 Eriobotrya deflexa :: Bronze Loquat 8 1590 Yosemite Ave 14 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
57053 200107 DPW Maintained 1 Eriobotrya deflexa :: Bronze Loquat 8 1538 Yosemite Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     1 Width 0ft   6014865.1345 2092505.1157 37.726456013252 -122.390799692144 (37.726456013252, -122.390799692144) 10 3 8 58 1
158966 200108 DPW Maintained 1 Eriobotrya deflexa :: Bronze Loquat 8 1538 Yosemite Ave 2 Sidewalk: Curb side : Cutout Tree Private 2     1 Width 0ft   6014848.2148 2092517.9747 37.7264903827113 -122.390859081597 (37.7264903827113, -122.390859081597) 10 3 8 58 1
112916 200109 DPW Maintained 1 Eriobotrya deflexa :: Bronze Loquat 8 1550 Yosemite Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     1 Width 0ft   6014832.6487 2092528.8033 37.7265192521755 -122.390913649883 (37.7265192521755, -122.390913649883) 10 3 8 58 1
172874 200110 DPW Maintained 1 Eriobotrya deflexa :: Bronze Loquat 8 1550 Yosemite Ave 2 Sidewalk: Curb side : Cutout Tree Private 2     1 Width 0ft   6014819.7897 2092537.6015 37.7265426967552 -122.390958717949 (37.7265426967552, -122.390958717949) 10 3 8 58 1
132797 200114 DPW Maintained 1 Eriobotrya deflexa :: Bronze Loquat 8 1566 Yosemite Ave 2 Sidewalk: Curb side : Cutout Tree Private 2     1 Width 0ft   6014762.2628 2092586.3302 37.7266733037648 -122.39116099243 (37.7266733037648, -122.39116099243) 10 3 8 58 1
117367 26611 DPW Maintained 1 Eriobotrya deflexa :: Bronze Loquat 8 1485 Bay Shore Blvd 10 Sidewalk: Curb side : Cutout Tree Private 2   01/15/1998 12:00:00 AM 12 3X3   6011726.3053 2092603.41849 37.7265512783073 -122.401657461237 (37.7265512783073, -122.401657461237) 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
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
87986 176263 DPW Maintained 1 Eriobotrya deflexa :: Bronze Loquat 8 728 Burrows St 2 Sidewalk: Curb side : Cutout Tree Private 2     4 Width 3ft   6009121.13665 2092884.06532 37.7271761560436 -122.410683275834 (37.7271761560436, -122.410683275834) 9 3 7 309 28
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
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
175105 189249 DPW Maintained 1 Eriobotrya deflexa :: Bronze Loquat 8 1301 Bay Shore Blvd 3 : Tree Private 2     10 Width 4ft   6011651.62195 2092980.93303 37.7275836874237 -122.401942166815 (37.7275836874237, -122.401942166815) 10 3 8 58 1
139451 189250 DPW Maintained 1 Eriobotrya deflexa :: Bronze Loquat 8 1301 Bay Shore Blvd 4 : Tree Private 2     11 Width 5ft   6011646.80648 2093004.20248 37.7276473117623 -122.401960449138 (37.7276473117623, -122.401960449138) 10 3 8 58 1
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
144162 26619 DPW Maintained 1 Eriobotrya deflexa :: Bronze Loquat 8 1291 Bay Shore Blvd 1 Sidewalk: Curb side : Cutout Tree Private 2   01/13/1998 12:00:00 AM 6 3X3   6011585.48367 2093253.8886 37.728329475411 -122.402189991188 (37.728329475411, -122.402189991188) 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
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
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
117037 200072 DPW Maintained 1 Eriobotrya deflexa :: Bronze Loquat 8 1910 Keith St 2 Sidewalk: Curb side : Cutout Tree Private 2     3 Width 0ft   6015166.0329 2093422.0709 37.7289904795126 -122.389823510971 (37.7289904795126, -122.389823510971) 10 3 8 58 1
149129 176262 DPW Maintained 1 Eriobotrya deflexa :: Bronze Loquat 8 56 University St 1 Sidewalk: Curb side : Cutout Tree Private 2     7 Width 2ft   6007768.4416 2093799.07984 37.7296126542007 -122.415424294819 (37.7296126542007, -122.415424294819) 9 3 7 309 28
47493 38141 DPW Maintained 1 Eriobotrya deflexa :: Bronze Loquat 8 100 Felton St 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/15/1998 12:00:00 AM 4   Permit Number 40298 6010551.38823 2093805.12649 37.7297852835414 -122.40580373606 (37.7297852835414, -122.40580373606) 10 3 7 309 28
156919 94866 DPW Maintained 1 Eriobotrya deflexa :: Bronze Loquat 8 433 Bowdoin St 1 Sidewalk: Curb side : Cutout Tree Private 2   11/19/2010 12:00:00 AM 4 3x3 Permit Number 53937 6008724.4272 2093890.29208 37.7299167896154 -122.412125784778 (37.7299167896154, -122.412125784778) 9 3 7 309 28
145332 176264 DPW Maintained 1 Eriobotrya deflexa :: Bronze Loquat 8 165 Brussels St 1 Sidewalk: Curb side : Cutout Tree Private 2     2 Width 3ft   6010291.19923 2093895.21089 37.7300180820504 -122.406709588991 (37.7300180820504, -122.406709588991) 10 3 7 309 28
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
163425 17171 Permitted Site 7 Eriobotrya deflexa :: Bronze Loquat 8 1221X Oakdale Ave 3 Sidewalk: Curb side : Cutout Tree Private 2   03/10/2007 12:00:00 AM 3 3x3   6017100.78201 2093930.01601 37.7304922989818 -122.383170211952 (37.7304922989818, -122.383170211952) 10 3 8 58 1
157578 191680 DPW Maintained 1 Eriobotrya deflexa :: Bronze Loquat 8 1241 Oakdale Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     3 Width 3ft   6017088.63788 2093939.5635 37.7305178434155 -122.383212860684 (37.7305178434155, -122.383212860684) 10 3 8 58 1
46455 17169 Permitted Site 7 Eriobotrya deflexa :: Bronze Loquat 8 1221X Oakdale Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   03/10/2007 12:00:00 AM 3 3x3   6017071.13101 2093953.96501 37.7305564196556 -122.383274387156 (37.7305564196556, -122.383274387156) 10 3 8 58 1
102920 38634 DPW Maintained 1 Eriobotrya deflexa :: Bronze Loquat 8 1595 Shafter Ave 4 Sidewalk: Curb side : Cutout Tree Private 2 FUF 08/16/2011 12:00:00 AM 16 4x10 Permit Number 767658 6014976.9663 2094092.323 37.7308203704303 -122.390523948894 (37.7308203704303, -122.390523948894) 10 3 8 58 1
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
126278 38632 DPW Maintained 1 Eriobotrya deflexa :: Bronze Loquat 8 1595 Shafter Ave 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF 08/16/2011 12:00:00 AM 17 6x60 Permit Number 767658 6014957.1802 2094111.5595 37.7308720923122 -122.390593696874 (37.7308720923122, -122.390593696874) 10 3 8 58 1
122226 38633 DPW Maintained 1 Eriobotrya deflexa :: Bronze Loquat 8 1595 Shafter Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 08/16/2011 12:00:00 AM 4 3x3 Permit Number 767658 6014946.188 2094119.254 37.7308926100283 -122.390632236495 (37.7308926100283, -122.390632236495) 10 3 8 58 1
133236 35731 Permitted Site 7 Eriobotrya deflexa :: Bronze Loquat 8 2 Dunsmuir St 3 Sidewalk: Curb side : Cutout Tree Private 2 FUF 04/14/1998 12:00:00 AM     Permit Number 39008 6008063.83773317 2094291.11517944 37.7309802758886 -122.414437878529 (37.7309802758886, -122.414437878529) 9 3 7 309 28
151895 35732 Permitted Site 7 Eriobotrya deflexa :: Bronze Loquat 8 2 Dunsmuir St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 04/14/1998 12:00:00 AM     Permit Number 39008 6008063.83773317 2094291.11517944 37.7309802758886 -122.414437878529 (37.7309802758886, -122.414437878529) 9 3 7 309 28
156725 35729 Permitted Site 7 Eriobotrya deflexa :: Bronze Loquat 8 2 Dunsmuir St 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF 04/14/1998 12:00:00 AM     Permit Number 39008 6008063.83773317 2094291.11517944 37.7309802758886 -122.414437878529 (37.7309802758886, -122.414437878529) 9 3 7 309 28
140580 94897 Permitted Site 7 Eriobotrya deflexa :: Bronze Loquat 8 1375 Keith St   Sidewalk: Curb side : Cutout Tree Private 2 FUF     3x3 Permit Number 53955 6016208.4 2094705 37.7325708970962 -122.386309345138 (37.7325708970962, -122.386309345138) 10 3 8 58 1
41775 64530 DPW Maintained 1 Eriobotrya deflexa :: Bronze Loquat 8 1400 Oakdale Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 11/23/2010 12:00:00 AM 3 20x30 Permit Number 53955 6016100.7066 2094719.4549 37.7326046257158 -122.386682678289 (37.7326046257158, -122.386682678289) 10 3 8 58 1
137257 26128 DPW Maintained 1 Eriobotrya deflexa :: Bronze Loquat 8 1415 Oakdale Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   01/09/2010 12:00:00 AM 3 3X3   6016013.7391 2094719.7689 37.7326006727272 -122.386983370719 (37.7326006727272, -122.386983370719) 10 3 8 58 1
118101 64526 Permitted Site 7 Eriobotrya deflexa :: Bronze Loquat 8 1419 Oakdale Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/22/1988 12:00:00 AM     Permit Number 25408 6015994.96935812 2094728.94048025 37.7326248167159 -122.387048902328 (37.7326248167159, -122.387048902328) 10 3 8 58 1
79070 26127 DPW Maintained 1 Eriobotrya deflexa :: Bronze Loquat 8 1419 Oakdale Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     12 3X3   6015993.0176 2094731.6994 37.7326322840804 -122.387055842452 (37.7326322840804, -122.387055842452) 10 3 8 58 1
51453 64531 DPW Maintained 1 Eriobotrya deflexa :: Bronze Loquat 8 1410 Oakdale Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/22/1988 12:00:00 AM 0   Permit Number 25413 6016066.97411905 2094739.83359707 37.7326587139482 -122.386800721401 (37.7326587139482, -122.386800721401) 10 3 8 58 1
42729 64533 Permitted Site 7 Eriobotrya deflexa :: Bronze Loquat 8 1423 Oakdale Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/22/1988 12:00:00 AM     Permit Number 25415 6015974.60065069 2094744.26862441 37.732665776815 -122.387120391311 (37.732665776815, -122.387120391311) 10 3 8 58 1
52892 64551 Permitted Site 7 Eriobotrya deflexa :: Bronze Loquat 8 1315 Keith St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/25/1988 12:00:00 AM     Permit Number 25434 6016281.43381852 2094844.2486814 37.7329572884599 -122.386066550856 (37.7329572884599, -122.386066550856) 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
33503 64537 DPW Maintained 1 Eriobotrya deflexa :: Bronze Loquat 8 1448 Oakdale Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/25/1988 12:00:00 AM 4   Permit Number 25419 6015877.1655 2094890.2503 37.7330612171639 -122.387467432023 (37.7330612171639, -122.387467432023) 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
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
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
121083 64539 Permitted Site 7 Eriobotrya deflexa :: Bronze Loquat 8 1487 Oakdale Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/25/1988 12:00:00 AM     Permit Number 25422 6015648.7013223 2094989.51893827 37.7333211324836 -122.38826422578 (37.7333211324836, -122.38826422578) 10 3 8 58 1
186562 26117 DPW Maintained 1 Eriobotrya deflexa :: Bronze Loquat 8 1487 Oakdale Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   02/08/2003 12:00:00 AM 3 3X3   6015648.6011 2094991.9741 37.7333278683102 -122.38826474357 (37.7333278683102, -122.38826474357) 10 3 8 58 1
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
152438 55068 DPW Maintained 1 Eriobotrya deflexa :: Bronze Loquat 8 1408 Lane St 1 Sidewalk: Curb side : Cutout Tree Private 2   09/13/1972 12:00:00 AM 11   Permit Number 10962 6015508.9909 2094998.9084 37.7333391717852 -122.388747902809 (37.7333391717852, -122.388747902809) 10 3 8 58 1
145785 253796 Planning Code 138.1 required 2 Eriobotrya deflexa :: Bronze Loquat 8 100 Scotia Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   11/07/2017 12:00:00 AM 3   Permit Number 779938 6011980.63004 2095004.60122 37.7331586170673 -122.400946899168 (37.7331586170673, -122.400946899168) 10 3 8 58 1
133281 97054 DPW Maintained 1 Eriobotrya deflexa :: Bronze Loquat 8 214 Gaven St 1 Sidewalk: Curb side : Cutout Tree Private 2   08/17/2011 12:00:00 AM 5 3x3 Permit Number 768120 6009377.07238 2095012.77412 37.7330354837976 -122.409948712259 (37.7330354837976, -122.409948712259) 10 3 7 309 28
93376 55067 DPW Maintained 1 Eriobotrya deflexa :: Bronze Loquat 8 1404 Lane St 1 Sidewalk: Curb side : Cutout Tree Private 2   09/13/1972 12:00:00 AM 11   Permit Number 10961 6015524.9297 2095021.4425 37.7334019292539 -122.388694369981 (37.7334019292539, -122.388694369981) 10 3 8 58 1
183141 64538 DPW Maintained 1 Eriobotrya deflexa :: Bronze Loquat 8 1486 Oakdale Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/25/1988 12:00:00 AM 0   Permit Number 25421 6015679.96866361 2095031.06834702 37.7334369512525 -122.388159023613 (37.7334369512525, -122.388159023613) 10 3 8 58 1
53959 64549 Permitted Site 7 Eriobotrya deflexa :: Bronze Loquat 8 1414 Lane St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/25/1988 12:00:00 AM     Permit Number 25432 6015539.44017214 2095047.54254922 37.7334743989165 -122.388646024077 (37.7334743989165, -122.388646024077) 10 3 8 58 1
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
41340 26143 Permitted Site 7 Eriobotrya deflexa :: Bronze Loquat 8 1500 Oakdale Ave 13 Sidewalk: Curb side : Cutout Tree Rec/Park 5   02/08/2003 12:00:00 AM 3 3x3   6015586.3934773 2095100.209325 37.7336216133372 -122.388487366626 (37.7336216133372, -122.388487366626) 10 3 8 58 1
71289 26142 Permitted Site 7 Eriobotrya deflexa :: Bronze Loquat 8 1500 Oakdale Ave 12 Sidewalk: Curb side : Cutout Tree Rec/Park 5   03/21/2006 12:00:00 AM 3 3x3   6015586.3934773 2095100.209325 37.7336216133372 -122.388487366626 (37.7336216133372, -122.388487366626) 10 3 8 58 1
100379 26141 Permitted Site 7 Eriobotrya deflexa :: Bronze Loquat 8 1500 Oakdale Ave 11 Sidewalk: Curb side : Cutout Tree Rec/Park 5   03/21/2006 12:00:00 AM 3 3x3   6015586.3934773 2095100.209325 37.7336216133372 -122.388487366626 (37.7336216133372, -122.388487366626) 10 3 8 58 1
157261 26139 Permitted Site 7 Eriobotrya deflexa :: Bronze Loquat 8 1500 Oakdale Ave 9 Sidewalk: Curb side : Cutout Tree Rec/Park 5   11/05/2005 12:00:00 AM 4 3x3   6015586.3934773 2095100.209325 37.7336216133372 -122.388487366626 (37.7336216133372, -122.388487366626) 10 3 8 58 1
52958 64541 Permitted Site 7 Eriobotrya deflexa :: Bronze Loquat 8 1513 Oakdale Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/25/1988 12:00:00 AM     Permit Number 25424 6015494.68772587 2095105.29398738 37.7336304924024 -122.388804777662 (37.7336304924024, -122.388804777662) 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
161205 84784 Permitted Site 7 Eriobotrya deflexa :: Bronze Loquat 8 280 Charter Oak Ave 2 Sidewalk: Curb side : Cutout Tree Private 2   05/09/2007 12:00:00 AM     Permit No. 49320 6010961.8 2095107.4 37.7333839962575 -122.40447652098 (37.7333839962575, -122.40447652098) 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)
);