Data source: data.sfgov.org
This data as json, CSV (advanced)
| Link | rowid | TreeID ▼ | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 15984 | 15984 | 26590 | DPW Maintained 3 | Eriobotrya deflexa :: Bronze Loquat 49 | 1645 Bay Shore Blvd | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/18/1998 12:00:00 AM | 6 | 3X3 | 6012121.9317 | 2091099.0732200001 | 37.7224427228244 | -122.400184180161 | (37.7224427228244, -122.400184180161) | ||
| 14946 | 14946 | 26611 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 1485 Bay Shore Blvd | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/15/1998 12:00:00 AM | 12 | 3X3 | 6011726.3053 | 2092603.41849 | 37.7265512783073 | -122.401657461237 | (37.7265512783073, -122.401657461237) | ||
| 98973 | 98973 | 26612 | DPW Maintained 3 | Eriobotrya deflexa :: Bronze Loquat 49 | 1365 Bay Shore Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/11/2016 12:00:00 AM | 3 | 3X3 | 6011668.1233381 | 2092874.0953860001 | 37.7272912542879 | -122.401877614076 | (37.7272912542879, -122.401877614076) | ||
| 15668 | 15668 | 26613 | DPW Maintained 3 | Eriobotrya deflexa :: Bronze Loquat 49 | 1355 Bay Shore Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/26/2015 10:59:00 PM | 3 | 3X3 | 6011681.24548 | 2092829.4663099998 | 37.727169444392096 | -122.401829114846 | (37.7271694443921, -122.401829114846) | ||
| 101425 | 101425 | 26616 | DPW Maintained 3 | Eriobotrya deflexa :: Bronze Loquat 49 | 1345X Bay Shore Blvd | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/13/1998 12:00:00 AM | 6 | 3X3 | 6011655.80292 | 2092935.6294354 | 37.7274595264664 | -122.40192452974199 | (37.7274595264664, -122.401924529742) | ||
| 94517 | 94517 | 26617 | DPW Maintained 3 | Eriobotrya deflexa :: Bronze Loquat 49 | 1345X Bay Shore Blvd | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/13/1998 12:00:00 AM | 6 | 3X3 | 6011655.80292 | 2092935.6294354 | 37.7274595264664 | -122.40192452974199 | (37.7274595264664, -122.401924529742) | ||
| 14690 | 14690 | 26619 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 1291 Bay Shore Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/13/1998 12:00:00 AM | 6 | 3X3 | 6011585.48367 | 2093253.8886 | 37.728329475411 | -122.402189991188 | (37.728329475411, -122.402189991188) | ||
| 118892 | 118892 | 26634 | DPW Maintained 3 | Eriobotrya deflexa :: Bronze Loquat 49 | 959X Bay Shore Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/16/1998 12:00:00 AM | 3 | 3x3 | 6010948.2451591 | 2094911.3215654998 | 37.732844848708204 | -122.404509586514 | (37.7328448487082, -122.404509586514) | ||
| 88012 | 88012 | 26636 | DPW Maintained 3 | Eriobotrya deflexa :: Bronze Loquat 49 | 585X Bay Shore Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/16/1998 12:00:00 AM | 3 | 3X3 | 6010330.4322368 | 2096858.6143875 | 37.738157152935294 | -122.406782722291 | (37.7381571529353, -122.406782722291) | ||
| 87139 | 87139 | 26833 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 1133 Mendell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/22/2008 12:00:00 AM | 0 | 3X3 | 6015479.92911 | 2095965.0534700002 | 37.7359903999296 | -122.388915807139 | (37.7359903999296, -122.388915807139) | ||
| 15680 | 15680 | 26834 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 1129 Mendell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/19/2008 12:00:00 AM | 3 | 3X3 | 6015470.5845 | 2095986.9202 | 37.7360499235694 | -122.388949641676 | (37.7360499235694, -122.388949641676) | ||
| 15346 | 15346 | 27245 | DPW Maintained 3 | Eriobotrya deflexa :: Bronze Loquat 49 | 1840X Oakdale Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/11/2006 12:00:00 AM | 3 | 3X3 | 6013813.103680001 | 2096437.28943 | 37.7371945316856 | -122.39471179383499 | (37.7371945316856, -122.394711793835) | ||
| 16054 | 16054 | 27246 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 1840X Oakdale Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/11/2006 12:00:00 AM | 3 | 3X3 | 6013798.74354 | 2096448.75806 | 37.737225223756106 | -122.394762246699 | (37.7372252237561, -122.394762246699) | ||
| 19912 | 19912 | 27292 | DPW Maintained 3 | Eriobotrya deflexa :: Bronze Loquat 49 | 56 Chilton Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 3X3 | 6001688.66279 | 2095714.9103400002 | 37.7345294879464 | -122.436579762262 | (37.7345294879464, -122.436579762262) | |||
| 21318 | 21318 | 27510 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 1259 Guerrero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 2X2 | 6005834.02618 | 2101632.44152 | 37.751012387419706 | -122.422668221463 | (37.7510123874197, -122.422668221463) | |||
| 23033 | 23033 | 27530 | DPW Maintained 3 | Eriobotrya deflexa :: Bronze Loquat 49 | 1898X Oakdale Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 5 | 3X3 | 6013528.91672 | 2096649.2761900001 | 37.73776079882371 | -122.39570921391199 | (37.7377607988237, -122.395709213912) | |||
| 16301 | 16301 | 27635 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 141 Industrial St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/19/2009 12:00:00 AM | 3 | 2X3 | 6011682.97129 | 2097216.25233 | 37.7392147363678 | -122.40213142555099 | (37.7392147363678, -122.402131425551) | ||
| 32413 | 32413 | 27682 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 141 Industrial St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/19/2009 12:00:00 AM | 3 | 2X3 | 6011440.528880901 | 2097124.3937126 | 37.738948976932996 | -122.402963228074 | (37.738948976933, -122.402963228074) | ||
| 140722 | 140722 | 28242 | DPW Maintained 3 | Eriobotrya deflexa :: Bronze Loquat 49 | 815 Hayes St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/12/2001 12:00:00 AM | 3 | 3X3 | 6003956.63253 | 2110750.38303 | 37.7759419673559 | -122.42981071961 | (37.7759419673559, -122.42981071961) | ||
| 99558 | 99558 | 28257 | DPW Maintained 3 | Eriobotrya deflexa :: Bronze Loquat 49 | 3508X San Bruno Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/08/2014 12:00:00 AM | 3 | 3x3 | 6012088.3375369 | 2089388.4108582002 | 37.717743717221396 | -122.400180224111 | (37.7177437172214, -122.400180224111) | ||
| 121739 | 121739 | 28261 | DPW Maintained 3 | Eriobotrya deflexa :: Bronze Loquat 49 | 3574 San Bruno Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 06/22/2011 12:00:00 AM | 3 | 3x3 | 6012138.719425799 | 2089093.5243211002 | 37.7169368272436 | -122.399985378545 | (37.7169368272436, -122.399985378545) | ||
| 1997 | 1997 | 28906 | DPW Maintained 3 | Eriobotrya deflexa :: Bronze Loquat 49 | 354 05th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/28/2014 12:00:00 AM | 5 | 3X3 | Permit Number 779305 | 6011835.68516 | 2111895.24936 | 37.779528530663704 | -122.402635398413 | (37.7795285306637, -122.402635398413) | |
| 14826 | 14826 | 28997 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 321X 10th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/27/2005 12:00:00 AM | 6 | 3x3 | 6008985.047180001 | 2109404.3491700003 | 37.7725295406243 | -122.412320901705 | (37.7725295406243, -122.412320901705) | ||
| 15846 | 15846 | 29367 | DPW Maintained 3 | Eriobotrya deflexa :: Bronze Loquat 49 | 367X Bay Shore Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/20/2006 12:00:00 AM | 3 | 3X3 | 6010545.10979 | 2098098.4290400003 | 37.7415734269678 | -122.40612779327 | (37.7415734269678, -122.40612779327) | ||
| 80214 | 80214 | 29491 | DPW Maintained 3 | Eriobotrya deflexa :: Bronze Loquat 49 | 1628X Ingalls St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 08/05/2015 07:30:00 AM | 3 | 3x3 | 6016725.73414 | 2093293.6586200001 | 37.7287242549235 | -122.38442251427799 | (37.7287242549235, -122.384422514278) | ||
| 175099 | 175099 | 30609 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 365 12th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/30/1995 12:00:00 AM | 16 | Permit Number 34572 | 6008561.72189 | 2108643.78999 | 37.770417459437496 | -122.41373142536501 | (37.7704174594375, -122.413731425365) | |
| 143657 | 143657 | 30873 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 3881 20th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/16/1995 12:00:00 AM | Permit Number 34707 | 6004466.82267682 | 2104222.01878233 | 37.7580455284889 | -122.427580622152 | (37.7580455284889, -122.427580622152) | |||
| 4088 | 4088 | 30930 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 342 Holloway Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/05/2017 02:15:00 PM | 3 | 4.5x9 | Permit Number 779282 | 5995716.95289 | 2091237.86508 | 37.7218954350219 | -122.45690211214199 | (37.7218954350219, -122.456902112142) |
| 130201 | 130201 | 30935 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 1093 Plymouth Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/25/2016 12:00:00 AM | 1 | Permit Number 775227 | 5995910.73733 | 2091157.41519 | 37.721685664556496 | -122.45622643891501 | (37.7216856645565, -122.456226438915) | |
| 157490 | 157490 | 30936 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 1093 Plymouth Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/25/2016 12:00:00 AM | 1 | Permit Number 775227 | 5995909.9946800005 | 2091121.8923 | 37.7215880844914 | -122.45622643891501 | (37.7215880844914, -122.456226438915) | |
| 74059 | 74059 | 31015 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 1200 Naples St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/13/1995 12:00:00 AM | 9 | Permit Number 34784 | 6001104.8718 | 2087440.4366099997 | 37.7117764674692 | -122.438005613962 | (37.7117764674692, -122.438005613962) | ||
| 139860 | 139860 | 31016 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 1200 Naples St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/13/1995 12:00:00 AM | Permit Number 34784 | 6001138.87641909 | 2087503.16195668 | 37.711950631123294 | -122.43789257478399 | (37.7119506311233, -122.437892574784) | |||
| 113714 | 113714 | 31017 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 1200 Naples St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/13/1995 12:00:00 AM | Permit Number 34784 | 6001138.87641909 | 2087503.16195668 | 37.711950631123294 | -122.43789257478399 | (37.7119506311233, -122.437892574784) | |||
| 188750 | 188750 | 31037 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 722 Prague St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/13/1995 12:00:00 AM | 9 | Permit Number 34796 | 6002553.27762 | 2087290.2882 | 37.7114464558494 | -122.43298880977899 | (37.7114464558494, -122.432988809779) | |
| 4900 | 4900 | 31068 | Planning Code 138.1 required 4 | Eriobotrya deflexa :: Bronze Loquat 49 | 1450 15th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/31/2017 12:00:00 AM | 3 | 3x4 | Permit Number 775137 | 6007659.7746 | 2107385.50696 | 37.7669118184545 | -122.41676211549999 | (37.7669118184545, -122.4167621155) | |
| 185608 | 185608 | 31224 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 1386 Masonic Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/04/1995 12:00:00 AM | 0 | Permit Number 42098 | 5999592.83400965 | 2107841.48506455 | 37.767706790759995 | -122.444697050343 | (37.76770679076, -122.444697050343) | ||
| 177761 | 177761 | 31284 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 2578 17th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/04/1995 12:00:00 AM | 2 | Permit Number 34932 | 5991129.57041 | 2097871.41628 | 37.7398450082307 | -122.473242924144 | (37.7398450082307, -122.473242924144) | |
| 69028 | 69028 | 31346 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 535 Ivy St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/12/1995 12:00:00 AM | 5 | Permit Number 34957 | 6004784.8126 | 2111056.6827 | 37.7768298546653 | -122.42696764831301 | (37.7768298546653, -122.426967648313) | |
| 95564 | 95564 | 31348 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 611 Laguna St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/12/1995 12:00:00 AM | Permit Number 34959 | 6004950.38276667 | 2110982.38504046 | 37.776635212167896 | -122.42638959956999 | (37.7766352121679, -122.42638959957) | ||
| 118671 | 118671 | 31349 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 611 Laguna St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/12/1995 12:00:00 AM | Permit Number 34959 | 6004950.38276667 | 2110982.38504046 | 37.776635212167896 | -122.42638959956999 | (37.7766352121679, -122.42638959957) | ||
| 132487 | 132487 | 31506 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 275 Collins St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/13/1995 12:00:00 AM | 7 | Permit Number 35066 | 5998177.9524 | 2112750.4955 | 37.781104827172705 | -122.44994476744199 | (37.7811048271727, -122.449944767442) | |
| 94453 | 94453 | 31507 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 300 Anza St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/10/2001 12:00:00 AM | 4.5x6 | Permit Number 35067 | 5998199.5847285995 | 2112645.80731224 | 37.780818618472 | -122.44986238382401 | (37.780818618472, -122.449862383824) | |
| 54668 | 54668 | 31560 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 178 Ewing Ter | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/10/1995 12:00:00 AM | Permit Number 35104 | 5998523.78697564 | 2112531.01963796 | 37.7805219856792 | -122.448732545056 | (37.7805219856792, -122.448732545056) | |||
| 158780 | 158780 | 31661 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 4812 17th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/05/1995 12:00:00 AM | 8 | Permit Number 35169 | 5998134.627069999 | 2105673.0184299997 | 37.761669409447705 | -122.44958451213499 | (37.7616694094477, -122.449584512135) | |
| 181330 | 181330 | 31671 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 1435 Larkin St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/08/2003 12:00:00 AM | 11 | Permit Number 35179 | 6007129.43317 | 2116257.26195 | 37.79124167420971 | -122.419225877479 | (37.7912416742097, -122.419225877479) | |
| 24645 | 24645 | 31679 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 4909 17th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/19/1995 12:00:00 AM | 8 | Permit Number 35185 | 5997751.25621 | 2105611.0193 | 37.7614772360152 | -122.450905959737 | (37.7614772360152, -122.450905959737) | |
| 159510 | 159510 | 31680 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 55 Carl St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/19/1995 12:00:00 AM | 9 | Permit Number 35186 | 5998329.535540001 | 2107192.5767200002 | 37.7658528820189 | -122.44901987368999 | (37.7658528820189, -122.44901987369) | |
| 26893 | 26893 | 31681 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 59 Carl St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/19/1995 12:00:00 AM | 8 | Permit Number 35187 | 5998307.66476 | 2107187.9506099997 | 37.7658389290403 | -122.44909518650101 | (37.7658389290403, -122.449095186501) | |
| 178495 | 178495 | 31682 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 61 Carl St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/19/1995 12:00:00 AM | 10 | Permit Number 35188 | 5998292.66632 | 2107186.56904 | 37.765834277768 | -122.449146963179 | (37.765834277768, -122.449146963179) | |
| 122961 | 122961 | 31688 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 816 Clayton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/19/1995 12:00:00 AM | 9 | Permit Number 35192 | 5998677.08875 | 2107434.65955 | 37.766537451377204 | -122.44783519493099 | (37.7665374513772, -122.447835194931) | |
| 157828 | 157828 | 31707 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 492 Frederick St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/19/1995 12:00:00 AM | 6 | 3x3 | Permit Number 35209 | 5997285.6368 | 2107441.337 | 37.7664761565817 | -122.45264843650499 | (37.7664761565817, -122.452648436505) | |
| 147225 | 147225 | 31708 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 498 Frederick St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/19/1995 12:00:00 AM | 7 | Permit Number 35209 | 5997262.9247 | 2107438.6115 | 37.766467371667794 | -122.452726796412 | (37.7664673716678, -122.452726796412) | ||
| 107363 | 107363 | 31709 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 494 Frederick St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/19/1995 12:00:00 AM | 3x3 | Permit Number 35209 | 5997243.8482988 | 2107438.78274184 | 37.7664667487492 | -122.452792790242 | (37.7664667487492, -122.452792790242) | |
| 54012 | 54012 | 31710 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 619 Frederick St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/19/1995 12:00:00 AM | 9 | Permit Number 35210 | 5996583.34698 | 2107294.12432 | 37.7660316834511 | -122.45506687733999 | (37.7660316834511, -122.45506687734) | |
| 131823 | 131823 | 31713 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 100 Rivoli St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/19/1995 12:00:00 AM | 8 | Permit Number 43549 | 5998153.78946 | 2105987.36259 | 37.762533615662704 | -122.44954088871 | (37.7625336156627, -122.44954088871) | |
| 32189 | 32189 | 31714 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 122 Rivoli St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/19/1995 12:00:00 AM | 8 | Permit Number 35214 | 5998115.883119999 | 2105983.06318 | 37.7625196419841 | -122.44967168249799 | (37.7625196419841, -122.449671682498) | |
| 30399 | 30399 | 31893 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 333 12th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/11/1997 12:00:00 AM | 8 | Permit Number 35323 | 6008432.94494 | 2108718.71395 | 37.770615950606704 | -122.41418216828501 | (37.7706159506067, -122.414182168285) | |
| 150788 | 150788 | 32154 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 521 Ivy St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/15/1995 12:00:00 AM | 6 | Permit Number 35505 | 6004839.16565 | 2111059.45396 | 37.776840537087395 | -122.42677982204201 | (37.7768405370874, -122.426779822042) | ||
| 52128 | 52128 | 32155 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 521 Ivy St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/15/1995 12:00:00 AM | 7 | Permit Number 35505 | 6004828.77889 | 2111059.03276 | 37.7768387933121 | -122.42681572299401 | (37.7768387933121, -122.426815722994) | ||
| 184919 | 184919 | 32226 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 1524 Treat Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/22/1995 12:00:00 AM | 10 | Permit Number 35545 | 6008720.30382 | 2099880.58736 | 37.7463646038601 | -122.412563325657 | (37.7463646038601, -122.412563325657) | |
| 188373 | 188373 | 32498 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 676 Andover St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/15/1996 12:00:00 AM | 9 | Permit Number 37003 | 6007391.76195 | 2095838.15833 | 37.73519034034379 | -122.41687092807301 | (37.7351903403438, -122.416870928073) | |
| 116074 | 116074 | 32499 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 707 Andover St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/15/1996 12:00:00 AM | Permit Number 37004 | 6007421.96096236 | 2095649.42060619 | 37.7346738065112 | -122.41675315210199 | (37.7346738065112, -122.416753152102) | ||
| 152205 | 152205 | 32500 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 738 Andover St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/15/1996 12:00:00 AM | 4 | Permit Number 37005 | 6007353.28943 | 2095467.09661 | 37.7341693220512 | -122.416977659594 | (37.7341693220512, -122.416977659594) | |
| 51114 | 51114 | 32504 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 399 Crescent Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/15/1996 12:00:00 AM | 9 | Permit Number 37008 | 6007356.06097 | 2095755.1769700001 | 37.734960483524496 | -122.416988482053 | (37.7349604835245, -122.416988482053) | |
| 121603 | 121603 | 32795 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 1701 Grove St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/29/1996 12:00:00 AM | Permit Number 37158 | 5999667.64263466 | 2110499.43513135 | 37.7750091179441 | -122.444629358923 | (37.7750091179441, -122.444629358923) | ||
| 86058 | 86058 | 32838 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 1414 Castro St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/30/1996 12:00:00 AM | Permit Number 37193 | 6002529.48991502 | 2101462.27171946 | 37.750358149840395 | -122.43408346062701 | (37.7503581498404, -122.434083460627) | ||
| 93777 | 93777 | 32839 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 1414 Castro St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/30/1996 12:00:00 AM | Permit Number 37193 | 6002529.48991502 | 2101462.27171946 | 37.750358149840395 | -122.43408346062701 | (37.7503581498404, -122.434083460627) | ||
| 145571 | 145571 | 32843 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 838 Diamond St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/30/1996 12:00:00 AM | Permit Number 37197 | 6001875.52927375 | 2101649.48990957 | 37.7508350700837 | -122.43635829546001 | (37.7508350700837, -122.43635829546) | ||
| 89433 | 89433 | 33009 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 3616 24th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/05/1996 12:00:00 AM | Permit Number 37303 | 6005672.83784214 | 2102003.77697796 | 37.752022893601996 | -122.42325202087099 | (37.752022893602, -122.423252020871) | ||
| 138767 | 138767 | 33018 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 3638 24th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/05/1996 12:00:00 AM | Permit Number 37306 | 6005540.00148664 | 2101997.41979374 | 37.751997940620605 | -122.423710937024 | (37.7519979406206, -122.423710937024) | ||
| 142708 | 142708 | 33036 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 494 Bartlett St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/05/1996 12:00:00 AM | Permit Number 37315 | 6006779.65662971 | 2100908.40918731 | 37.7490776652966 | -122.41934677281 | (37.7490776652966, -122.41934677281) | |||
| 53590 | 53590 | 33037 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 494 Bartlett St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/05/1996 12:00:00 AM | Permit Number 37315 | 6006779.65662971 | 2100908.40918731 | 37.7490776652966 | -122.41934677281 | (37.7490776652966, -122.41934677281) | |||
| 93764 | 93764 | 33048 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 1192 Guerrero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/05/1996 12:00:00 AM | Permit Number 37324 | 6005740.26598795 | 2102030.16267757 | 37.752099147776704 | -122.423020719371 | (37.7520991477767, -122.423020719371) | ||
| 114936 | 114936 | 33049 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 1259 Guerrero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/05/1996 12:00:00 AM | Permit Number 37325 | 6005839.09502219 | 2101642.93131356 | 37.7510414759561 | -122.422651438228 | (37.7510414759561, -122.422651438228) | ||
| 9003 | 9003 | 33126 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 2527 Greenwich St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/12/2014 12:00:00 AM | 3 | Permit Number 774205 | 6000811.7731800005 | 2118925.97012 | 37.7982114272598 | -122.44127631424601 | (37.7982114272598, -122.441276314246) | |
| 29538 | 29538 | 33172 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 2311 Taraval St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/05/1996 12:00:00 AM | 9 | Permit Number 37388 | 5986066.5372792 | 2098877.4979138 | 37.742312976384504 | -122.490822533573 | (37.7423129763845, -122.490822533573) | |
| 88475 | 88475 | 33202 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 165 Merced Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/02/2008 12:00:00 AM | 3x3 | Permit Number 51141 | 5994405.76875734 | 2099294.92155065 | 37.743942754277 | -122.462018491778 | (37.743942754277, -122.462018491778) | ||
| 35578 | 35578 | 33334 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 3360 Octavia St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/14/1996 12:00:00 AM | 8 | 6x9 | Permit Number 37474 | 6004131.26666 | 2120719.53303 | 37.8033246198945 | -122.42991788581999 | (37.8033246198945, -122.42991788582) |
| 56938 | 56938 | 33335 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 3360 Octavia St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/14/1996 12:00:00 AM | 7 | 9x9 | Permit Number 37474 | 6004127.03344 | 2120735.4068 | 37.8033679654079 | -122.429933668002 | (37.8033679654079, -122.429933668002) |
| 99360 | 99360 | 33722 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 52 Germania St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/04/1996 12:00:00 AM | Permit Number 37790 | 6003978.61539507 | 2108896.55422138 | 37.7708530523079 | -122.429602431291 | (37.7708530523079, -122.429602431291) | |||
| 88310 | 88310 | 33723 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 52 Germania St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/04/1996 12:00:00 AM | Permit Number 37790 | 6003978.61539507 | 2108896.55422138 | 37.7708530523079 | -122.429602431291 | (37.7708530523079, -122.429602431291) | |||
| 187770 | 187770 | 33945 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 2858 Gough St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/28/2002 12:00:00 AM | 8 | Permit Number 45901 | 6004794.02705 | 2119422.7642900003 | 37.799801537482296 | -122.42753193854601 | (37.7998015374823, -122.427531938546) | |
| 161497 | 161497 | 34683 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 1901X Filbert St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/14/2013 12:00:00 AM | 2 | Permit Number 770151 | 6003781.4605 | 2118989.07405 | 37.79855341247529 | -122.43100482351002 | (37.7985534124753, -122.43100482351) | ||
| 79370 | 79370 | 34891 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 95 Ward St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/22/1997 12:00:00 AM | Permit Number 38498 | 6011846.48740204 | 2089823.39477464 | 37.718924606748296 | -122.401046743519 | (37.7189246067483, -122.401046743519) | |||
| 142100 | 142100 | 34892 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 95 Ward St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/22/1997 12:00:00 AM | Permit Number 38498 | 6011846.48740204 | 2089823.39477464 | 37.718924606748296 | -122.401046743519 | (37.7189246067483, -122.401046743519) | |||
| 127294 | 127294 | 34943 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 3968 23rd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/25/2016 12:00:00 AM | 3 | Permit Number 775333 | 6003347.35755113 | 2102457.99102165 | 37.753138543477704 | -122.43132628846001 | (37.7531385434777, -122.43132628846) | ||
| 115595 | 115595 | 35066 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 1767 10th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/26/1998 12:00:00 AM | Permit Number 38621 | 5993091.79613018 | 2103456.13602806 | 37.7552926457444 | -122.466864312925 | (37.7552926457444, -122.466864312925) | ||
| 86662 | 86662 | 35073 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 1541 12th Ave | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/26/1998 12:00:00 AM | Permit Number 38627 | 5992419.71878294 | 2104964.13539049 | 37.759394405692504 | -122.46929829243 | (37.7593944056925, -122.46929829243) | ||
| 103983 | 103983 | 35074 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 1541 12th Ave | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/26/1998 12:00:00 AM | Permit Number 38627 | 5992419.71878294 | 2104964.13539049 | 37.759394405692504 | -122.46929829243 | (37.7593944056925, -122.46929829243) | ||
| 93814 | 93814 | 35075 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 1541 12th Ave | 13 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/26/1998 12:00:00 AM | Permit Number 38627 | 5992419.71878294 | 2104964.13539049 | 37.759394405692504 | -122.46929829243 | (37.7593944056925, -122.46929829243) | ||
| 94687 | 94687 | 35076 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 1541 12th Ave | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/26/1998 12:00:00 AM | Permit Number 38627 | 5992419.71878294 | 2104964.13539049 | 37.759394405692504 | -122.46929829243 | (37.7593944056925, -122.46929829243) | ||
| 128161 | 128161 | 35077 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 1541 12th Ave | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/26/1998 12:00:00 AM | Permit Number 38627 | 5992419.71878294 | 2104964.13539049 | 37.759394405692504 | -122.46929829243 | (37.7593944056925, -122.46929829243) | ||
| 53616 | 53616 | 35078 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 1541 12th Ave | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/26/1998 12:00:00 AM | Permit Number 38627 | 5992419.71878294 | 2104964.13539049 | 37.759394405692504 | -122.46929829243 | (37.7593944056925, -122.46929829243) | ||
| 118877 | 118877 | 35079 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 1541 12th Ave | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/26/1998 12:00:00 AM | Permit Number 38627 | 5992419.71878294 | 2104964.13539049 | 37.759394405692504 | -122.46929829243 | (37.7593944056925, -122.46929829243) | ||
| 86401 | 86401 | 35080 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 1541 12th Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/03/2001 12:00:00 AM | Permit Number 38627 | 5992419.71878294 | 2104964.13539049 | 37.759394405692504 | -122.46929829243 | (37.7593944056925, -122.46929829243) | ||
| 145304 | 145304 | 35081 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 1541 12th Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/03/2001 12:00:00 AM | Permit Number 38627 | 5992419.71878294 | 2104964.13539049 | 37.759394405692504 | -122.46929829243 | (37.7593944056925, -122.46929829243) | ||
| 87209 | 87209 | 35084 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 1541 12th Ave | 14 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/26/1998 12:00:00 AM | Permit Number 38627 | 5992419.71878294 | 2104964.13539049 | 37.759394405692504 | -122.46929829243 | (37.7593944056925, -122.46929829243) | ||
| 127518 | 127518 | 35086 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 1541 12th Ave | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/26/1998 12:00:00 AM | Permit Number 38627 | 5992419.71878294 | 2104964.13539049 | 37.759394405692504 | -122.46929829243 | (37.7593944056925, -122.46929829243) | ||
| 105781 | 105781 | 35298 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 4128 24th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/24/1998 12:00:00 AM | Permit Number 38772 | 6002342.17007059 | 2101820.0635556 | 37.751329928477396 | -122.434756807393 | (37.7513299284774, -122.434756807393) | |||
| 124941 | 124941 | 35299 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 4128 24th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/24/1998 12:00:00 AM | Permit Number 38772 | 6002342.17007059 | 2101820.0635556 | 37.751329928477396 | -122.434756807393 | (37.7513299284774, -122.434756807393) |
JSON shape: default, array, newline-delimited
CREATE TABLE "Street_Tree_List" (
"TreeID" INTEGER,
"qLegalStatus" INTEGER,
"qSpecies" INTEGER,
"qAddress" TEXT,
"SiteOrder" INTEGER,
"qSiteInfo" INTEGER,
"PlantType" INTEGER,
"qCaretaker" INTEGER,
"qCareAssistant" INTEGER,
"PlantDate" TEXT,
"DBH" INTEGER,
"PlotSize" TEXT,
"PermitNotes" TEXT,
"XCoord" REAL,
"YCoord" REAL,
"Latitude" REAL,
"Longitude" REAL,
"Location" TEXT
,
FOREIGN KEY ("PlantType") REFERENCES [PlantType](id),
FOREIGN KEY ("qCaretaker") REFERENCES [qCaretaker](id),
FOREIGN KEY ("qSpecies") REFERENCES [qSpecies](id),
FOREIGN KEY ("qSiteInfo") REFERENCES [qSiteInfo](id),
FOREIGN KEY ("qCareAssistant") REFERENCES [qCareAssistant](id),
FOREIGN KEY ("qLegalStatus") REFERENCES [qLegalStatus](id));
CREATE INDEX ["Street_Tree_List_PlantType"] ON [Street_Tree_List]("PlantType");
CREATE INDEX ["Street_Tree_List_qCaretaker"] ON [Street_Tree_List]("qCaretaker");
CREATE INDEX ["Street_Tree_List_qSpecies"] ON [Street_Tree_List]("qSpecies");
CREATE INDEX ["Street_Tree_List_qSiteInfo"] ON [Street_Tree_List]("qSiteInfo");
CREATE INDEX ["Street_Tree_List_qCareAssistant"] ON [Street_Tree_List]("qCareAssistant");
CREATE INDEX ["Street_Tree_List_qLegalStatus"] ON [Street_Tree_List]("qLegalStatus");