trees
340 rows where Police Districts = 3 and qSpecies_id = 8 sorted by rowid descending
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
194328 | 258403 | Section 806 (d) 5 | Eriobotrya deflexa :: Bronze Loquat 8 | 1052 Rhode Island St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/10/2019 12:00:00 AM | 3 | 3x5 | 6011869 | 2103486 | 37.7564404909426 | -122.401928842587 | (37.7564404909426, -122.401928842587) | 10 | 3 | 8 | 28856 | 29 | ||
194119 | 191080 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 901 24th St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6015525.99309 | 2102510.04982 | 37.7539641575461 | -122.389213417992 | (37.7539641575461, -122.389213417992) | 10 | 3 | 8 | 28856 | 29 | |||
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 | ||
190937 | 189272 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1789 Oakdale Ave | 1 | : | Tree | Private 2 | 4 | Width 3ft | 6014048.88892 | 2096189.76773 | 37.7365279946626 | -122.393879249144 | (37.7365279946626, -122.393879249144) | 10 | 3 | 8 | 58 | 1 | |||
190222 | 52804 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 25@ TEXAS Sierra St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/25/2006 12:00:00 AM | 4 | Permit Number 48835 | 6013685.88605 | 2104111.17484 | 37.758258318682 | -122.395689167119 | (37.758258318682, -122.395689167119) | 10 | 3 | 8 | 28856 | 29 | ||
189516 | 189262 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 2215 Newcomb Ave | 2 | : | Tree | Private 2 | 1 | Width 3ft | 6011918.91443 | 2098133.46059 | 37.7417463620964 | -122.401380076136 | (37.7417463620964, -122.401380076136) | 10 | 3 | 8 | 58 | 1 | |||
189244 | 189253 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 120 Loomis St | 3 | : | Tree | Private 2 | 1 | Width 4ft | 6010832.24307 | 2097967.49844 | 37.7412299758817 | -122.405125761461 | (37.7412299758817, -122.405125761461) | 10 | 3 | 8 | 58 | 1 | |||
189133 | 189265 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 2203 Newcomb Ave | 1 | : | Tree | Private 2 | 1 | Width 3ft | 6011972.28331 | 2098093.92114 | 37.7416407727111 | -122.40119276536 | (37.7416407727111, -122.40119276536) | 10 | 3 | 8 | 58 | 1 | |||
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 | |
188224 | 46989 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 2011 26th St | 6 | 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 | |||
188152 | 64547 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 1563 Oakdale Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/25/1988 12:00:00 AM | Permit Number 25430 | 6015240.17870423 | 2095296.4060958 | 37.7341411380387 | -122.389698040486 | (37.7341411380387, -122.389698040486) | 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 | |||
186728 | 189259 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 2227 Newcomb Ave | 1 | : | Tree | Private 2 | 1 | Width 3ft | 6011864.29034 | 2098174.02921 | 37.7418547070232 | -122.401571799894 | (37.7418547070232, -122.401571799894) | 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 | ||
186400 | 191083 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1050 18th St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 13 | 6014452.20409 | 2105784.61715 | 37.7628958266015 | -122.39315597749 | (37.7628958266015, -122.39315597749) | 14 | 3 | 8 | 28856 | 29 | ||||
183330 | 25956 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 2695X Oakdale Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/11/2006 12:00:00 AM | 3 | 2x3 | 6011407.61362 | 2098218.76868 | 37.7419520589748 | -122.403153994092 | (37.7419520589748, -122.403153994092) | 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 | |
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 | ||
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 | ||
180956 | 191112 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 2121 24th St | 2 | : | Tree | Private 2 | 12 | Width 3ft | 6012137.40992 | 2102323.82129 | 37.7532643788521 | -122.400918929861 | (37.7532643788521, -122.400918929861) | 10 | 3 | 8 | 28856 | 29 | |||
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 | |||
178699 | 191105 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 2031 26th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 2ft | 6012471.08809 | 2101442.49761 | 37.7508630621826 | -122.39970311841 | (37.7508630621826, -122.39970311841) | 10 | 3 | 8 | 28856 | 1 | |||
178055 | 191098 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 2041 26th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 2ft | 6012312.12427 | 2101383.39868 | 37.75069192661 | -122.400248683139 | (37.75069192661, -122.400248683139) | 10 | 3 | 8 | 28856 | 1 | |||
177312 | 37991 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 650 Texas St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/08/1998 12:00:00 AM | 4 | Permit Number 40210 | 6013832.0389 | 2104017.01631 | 37.7580079087535 | -122.395177107536 | (37.7580079087535, -122.395177107536) | 10 | 3 | 8 | 28856 | 29 | ||
176741 | 43028 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 2131 26th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/06/2000 12:00:00 AM | Permit Number 42891 | 6012232.74483127 | 2101350.9845752 | 37.7505984979091 | -122.400520909002 | (37.7505984979091, -122.400520909002) | 10 | 3 | 8 | 28856 | 1 | |||
175743 | 191097 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 2041 26th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 2ft | 6012299.11366 | 2101378.20136 | 37.7506769304023 | -122.400293310212 | (37.7506769304023, -122.400293310212) | 10 | 3 | 8 | 28856 | 1 | |||
175686 | 189258 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 2231 Newcomb Ave | 2 | : | Tree | Private 2 | 1 | Width 3ft | 6011848.21009 | 2098186.58426 | 37.741888283226 | -122.401628282713 | (37.741888283226, -122.401628282713) | 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 | |||
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 | ||
172911 | 114448 | Undocumented 4 | Eriobotrya deflexa :: Bronze Loquat 8 | 367 BAY SHORE BLVD | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4x4 | 6010572 | 2098095 | 37.7415655155901 | -122.406034574078 | (37.7415655155901, -122.406034574078) | 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 | |||
172332 | 117144 | Section 143 10 | Eriobotrya deflexa :: Bronze Loquat 8 | 2203x NEWCOMB AVE | 9 | 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 | |
170486 | 95807 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 10993 Mississippi St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/19/2011 12:00:00 AM | 3x3 | Permit Number 767551 | 6014326.8 | 2102083.7 | 37.752726939242 | -122.393330710599 | (37.752726939242, -122.393330710599) | 10 | 3 | 8 | 28856 | 29 | |
169572 | 94174 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 1101 Carolina St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/22/2010 12:00:00 AM | 3x3 | Permit Number 53593 | 6012553 | 2102835 | 37.7546911374705 | -122.399517610991 | (37.7546911374705, -122.399517610991) | 10 | 3 | 8 | 28856 | 29 | ||
167748 | 46986 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 2011 26th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/24/2010 12:00:00 AM | 4 | Permit Number 53455 | 6012562.93976 | 2101469.54753 | 37.7509424552537 | -122.399387383547 | (37.7509424552537, -122.399387383547) | 10 | 3 | 8 | 28856 | 1 | ||
167623 | 117139 | Section 143 10 | Eriobotrya deflexa :: Bronze Loquat 8 | 2203x NEWCOMB AVE | 4 | 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 | |
166907 | 26106 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1539X Oakdale Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/19/2000 12:00:00 AM | 12 | 3x3 | 6015355.6491 | 2095208.8603 | 37.7339071573226 | -122.389292708309 | (37.7339071573226, -122.389292708309) | 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 | |||
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 | ||
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 | ||
164893 | 67391 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 176X Wisconsin St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/15/1992 12:00:00 AM | Permit Number 30888 | 6012577.17209413 | 2106598.24360902 | 37.7650255224957 | -122.399698234444 | (37.7650255224957, -122.399698234444) | 14 | 3 | 8 | 28856 | 20 | ||
164702 | 37992 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 650 Texas St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/08/1998 12:00:00 AM | 5 | Permit Number 40210 | 6013843.22598 | 2104002.49869 | 37.7579686686468 | -122.39513740069 | (37.7579686686468, -122.39513740069) | 10 | 3 | 8 | 28856 | 29 | ||
164537 | 52805 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 25@ TEXAS Sierra St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/25/2006 12:00:00 AM | 3 | Permit Number 48835 | 6013721.70041 | 2104112.27723 | 37.758263337788 | -122.395565381751 | (37.758263337788, -122.395565381751) | 10 | 3 | 8 | 28856 | 29 | ||
164084 | 191108 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 2251 24th St | 1 | : | Tree | Private 2 | 8 | Width 3ft | 6011748.82992 | 2102300.63955 | 37.753179044 | -122.402261096995 | (37.753179044, -122.402261096995) | 10 | 3 | 8 | 28856 | 29 | |||
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 | ||
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 | ||
162471 | 191682 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1540 Kirkwood Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 22 | Width 3ft | 6015538.54688 | 2096541.66085 | 37.7375768955577 | -122.388753380563 | (37.7375768955577, -122.388753380563) | 10 | 3 | 8 | 58 | 1 | |||
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 | |||
161565 | 191090 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 150 Wisconsin St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6012554.60334 | 2106645.79178 | 37.765154821059 | -122.399779633629 | (37.765154821059, -122.399779633629) | 14 | 3 | 8 | 28856 | 20 | |||
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 | |||
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 | |||
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 | |||
158056 | 200708 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1399 Lane St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 0ft | 6015645.8444 | 2095108.8309 | 37.7336485807976 | -122.388282427214 | (37.7336485807976, -122.388282427214) | 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 | |||
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 | ||
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 | |
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 | ||
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 | ||
156342 | 64545 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 1583 Oakdale Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/25/1988 12:00:00 AM | Permit Number 25428 | 6015138.37508416 | 2095372.85094775 | 37.734345394408 | -122.390055349092 | (37.734345394408, -122.390055349092) | 10 | 3 | 8 | 58 | 1 | ||
154897 | 111560 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1498x Kansas St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | 3x3 | 6011715.03072 | 2101496.45297 | 37.7509690365089 | -122.402321443274 | (37.7509690365089, -122.402321443274) | 10 | 3 | 8 | 28856 | 29 | |||
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 | ||
154253 | 117141 | Section 143 10 | Eriobotrya deflexa :: Bronze Loquat 8 | 2203x NEWCOMB AVE | 6 | 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 | |
153010 | 53155 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1785@ 3RD ST Quesada Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/02/2006 12:00:00 AM | 7 | Permit Number 49078 | 6014228.24564 | 2095345.46405 | 37.7342196759901 | -122.393200070342 | (37.7342196759901, -122.393200070342) | 10 | 3 | 8 | 58 | 1 | ||
152676 | 27635 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 141 Industrial St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/19/2009 12:00:00 AM | 3 | 2X3 | 6011682.97129 | 2097216.25233 | 37.7392147363678 | -122.402131425551 | (37.7392147363678, -122.402131425551) | 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 | ||
152232 | 189242 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 690 Texas St | 3 | : | Tree | Private 2 | 5 | Width 3ft | 6013899.94699 | 2103926.17826 | 37.7577622634227 | -122.394935888703 | (37.7577622634227, -122.394935888703) | 10 | 3 | 8 | 28856 | 29 | |||
152105 | 46999 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 2011 26th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/24/2010 12:00:00 AM | 5 | Permit Number 53455 | 6012582.01898 | 2101471.73036 | 37.7509495122074 | -122.399321558558 | (37.7509495122074, -122.399321558558) | 10 | 3 | 8 | 28856 | 1 | ||
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 | ||
151834 | 94759 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 491 Bay Shore Blvd | 12 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/28/2010 12:00:00 AM | 4 | 3x3 | 6010436.49463 | 2097901.66936 | 37.7410270915281 | -122.406489488003 | (37.7410270915281, -122.406489488003) | 10 | 3 | 8 | 58 | 1 | ||
151246 | 94751 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 491 Bay Shore Blvd | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/28/2010 12:00:00 AM | 4 | 3x3 | 6010352.46754 | 2097498.7285 | 37.7399160016228 | -122.406751634101 | (37.7399160016228, -122.406751634101) | 10 | 3 | 8 | 58 | 1 | ||
149422 | 114447 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 367 Bay Shore Blvd | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | 4x4 | 6010564.67556 | 2098126.12029 | 37.7416505555295 | -122.406062091517 | (37.7416505555295, -122.406062091517) | 10 | 3 | 8 | 58 | 1 | |||
149315 | 26433 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1679 Oakdale Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/19/2000 12:00:00 AM | 3 | 3X3 | 6014598.59548 | 2095777.3145 | 37.7354260166954 | -122.391949831041 | (37.7354260166954, -122.391949831041) | 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 | |||
148937 | 114446 | Undocumented 4 | Eriobotrya deflexa :: Bronze Loquat 8 | 367 BAY SHORE BLVD | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4x4 | 6010572 | 2098095 | 37.7415655155901 | -122.406034574078 | (37.7415655155901, -122.406034574078) | 10 | 3 | 8 | 58 | 1 | ||||
148788 | 46995 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 2011 26th St | 12 | 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 | |||
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 | ||
147450 | 64542 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 1535 Oakdale Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/25/1988 12:00:00 AM | Permit Number 25425 | 6015382.7037495 | 2095189.38332023 | 37.7338551773356 | -122.389197811817 | (37.7338551773356, -122.389197811817) | 10 | 3 | 8 | 58 | 1 | ||
146469 | 94754 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 491 Bay Shore Blvd | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/28/2010 12:00:00 AM | 5 | 3x3 | 6010365.49883 | 2097628.45401 | 37.7402729290463 | -122.406715716973 | (37.7402729290463, -122.406715716973) | 10 | 3 | 8 | 58 | 1 | ||
146350 | 191094 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1951 23rd St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 4ft | 6012582.07272 | 2102822.21844 | 37.7546576625444 | -122.399416171744 | (37.7546576625444, -122.399416171744) | 10 | 3 | 8 | 28856 | 29 | |||
146226 | 52806 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 25@ TEXAS Sierra St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/25/2006 12:00:00 AM | Permit Number 48835 | 6013772.92448179 | 2104112.24559711 | 37.7582661000564 | -122.39538822301 | (37.7582661000564, -122.39538822301) | 10 | 3 | 8 | 28856 | 29 | |||
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 | ||
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 | |||
145145 | 43030 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 2121 26th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/06/2000 12:00:00 AM | 6 | Permit Number 42892 | 6012174.28913 | 2101359.6022 | 37.7506188998561 | -122.400723660095 | (37.7506188998561, -122.400723660095) | 10 | 3 | 8 | 28856 | 1 | ||
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 | ||
143699 | 117137 | Section 143 10 | Eriobotrya deflexa :: Bronze Loquat 8 | 2203x NEWCOMB AVE | 2 | 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 | |
141928 | 191093 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1951 23rd St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 4ft | 6012569.60579 | 2102821.43848 | 37.7546548260739 | -122.399459231268 | (37.7546548260739, -122.399459231268) | 10 | 3 | 8 | 28856 | 29 | |||
141839 | 191089 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 150 Wisconsin St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6012552.52179 | 2106660.8958 | 37.7651961772892 | -122.399787893906 | (37.7651961772892, -122.399787893906) | 14 | 3 | 8 | 28856 | 20 | |||
140946 | 43029 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 2131 26th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/06/2000 12:00:00 AM | 6 | Permit Number 42891 | 6012151.06584 | 2101359.39792 | 37.7506170436447 | -122.400803954262 | (37.7506170436447, -122.400803954262) | 10 | 3 | 8 | 28856 | 1 | ||
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 | |||
140396 | 66887 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1324 20th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/06/1991 12:00:00 AM | 9 | Permit Number 30200 | 6013938.0874 | 2104806.5934 | 37.7601818129701 | -122.394865641745 | (37.7601818129701, -122.394865641745) | 10 | 3 | 8 | 28856 | 29 | ||
140307 | 191091 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 150 Wisconsin St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6012554.29768 | 2106630.73656 | 37.7651134657424 | -122.399779633617 | (37.7651134657424, -122.399779633617) | 14 | 3 | 8 | 28856 | 20 | |||
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 | ||
140117 | 191684 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1531 Kirkwood Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6015574.65567 | 2096443.50916 | 37.7373093922023 | -122.388621684764 | (37.7373093922023, -122.388621684764) | 10 | 3 | 8 | 58 | 1 | |||
140065 | 117142 | Section 143 10 | Eriobotrya deflexa :: Bronze Loquat 8 | 2203x NEWCOMB AVE | 7 | 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 | |
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 | |||
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 | ||
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 | |||
139174 | 189244 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 690 Texas St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/16/2017 12:00:00 AM | 3 | 3x3 | Permit Number 780809 | 6013923.09543 | 2103892.83973 | 37.7576720101792 | -122.394853496397 | (37.7576720101792, -122.394853496397) | 10 | 3 | 8 | 28856 | 29 | |
138524 | 189243 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 690 Texas St | 4 | : | Tree | Private 2 | 4 | Width 3ft | 6013912.25282 | 2103910.20868 | 37.757719098672 | -122.3948922113 | (37.757719098672, -122.3948922113) | 10 | 3 | 8 | 28856 | 29 | |||
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 |
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) );