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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 16121 | 16121 | 26100 | DPW Maintained 3 | Eriobotrya deflexa :: Bronze Loquat 49 | 1577 Oakdale Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3x3 | 6015169.8802 | 2095341.3169 | 37.7342605555935 | -122.38994422273198 | (37.7342605555935, -122.389944222732) | |||
| 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) | ||
| 16567 | 16567 | 26102 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 1563 Oakdale Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3x3 | 6015232.536 | 2095297.3479 | 37.73414330023979 | -122.389724529704 | (37.7341433002398, -122.389724529704) | |||
| 16619 | 16619 | 85558 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 396 12th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/29/2007 12:00:00 AM | 6 | 6008677.32979 | 2108520.19339 | 37.770084583473704 | -122.413322794134 | (37.7700845834737, -122.413322794134) | |||
| 16724 | 16724 | 74019 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 2400 Mariposa St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/23/1996 12:00:00 AM | 10 | 3x3 | 6010272.25282 | 2105997.87843 | 37.7632482996846 | -122.40762808187799 | (37.7632482996846, -122.407628081878) | |
| 16874 | 16874 | 25949 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 2100 Oakdale Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/10/2007 12:00:00 AM | 3 | 3X3 | 6012331.41548 | 2097539.0273700003 | 37.7401371808736 | -122.399912042617 | (37.7401371808736, -122.399912042617) | ||
| 16889 | 16889 | 15051 | DPW Maintained 3 | Eriobotrya deflexa :: Bronze Loquat 49 | 1137 Mendell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/20/2000 12:00:00 AM | 3 | 8X18 | 6015459.2819 | 2095972.4779 | 37.736009641441 | -122.388987711638 | (37.736009641441, -122.388987711638) | ||
| 17112 | 17112 | 5086 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 2575 Diamond St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/26/2011 12:00:00 AM | 3 | 3x3 | 6002278.04095 | 2096864.42797 | 37.737719273515 | -122.4346242575 | (37.737719273515, -122.4346242575) | ||
| 17994 | 17994 | 49868 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 368 Bosworth St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/18/2003 12:00:00 AM | 3x3 | Permit Number 46634 | 6003577.84688999 | 2095267.92973361 | 37.733409356185796 | -122.430016351279 | (37.7334093561858, -122.430016351279) | ||
| 18447 | 18447 | 51025 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 51 Waller St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/08/2004 12:00:00 AM | Permit Number 47502 | 6005670.67188859 | 2109250.29159524 | 37.7719199923513 | -122.423774718207 | (37.7719199923513, -122.423774718207) | |||
| 18623 | 18623 | 117138 | Section 143 8 | Eriobotrya deflexa :: Bronze Loquat 49 | 2203x NEWCOMB AVE | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/13/2016 12:00:00 AM | 3 | 3x3 | Permit Number 774325 | 6011983.0 | 2098083.0 | 37.7416113834488 | -122.4011549432 | (37.7416113834488, -122.4011549432) | |
| 18735 | 18735 | 63382 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 261 Crescent Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/10/1987 12:00:00 AM | Permit Number 23962 | 6006733.60001952 | 2095809.91850213 | 37.735075757248296 | -122.41914443543999 | (37.7350757572483, -122.41914443544) | ||
| 18802 | 18802 | 509 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 2753 Harrison St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | 3x3 | 6008975.21686 | 2102392.50435 | 37.7532760709475 | -122.411859333666 | (37.7532760709475, -122.411859333666) | |||
| 19026 | 19026 | 90220 | DPW Maintained 3 | Eriobotrya deflexa :: Bronze Loquat 49 | 2500 Balboa St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/21/2008 12:00:00 AM | 3 | 3x3 | 5987751.08815 | 2111228.00123 | 37.7763223582458 | -122.48590426741801 | (37.7763223582458, -122.485904267418) | ||
| 19063 | 19063 | 11922 | DPW Maintained 3 | Eriobotrya deflexa :: Bronze Loquat 49 | 620X Keith St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 05/10/2016 12:00:00 AM | 3 | 3X4 | 6017350.6902257 | 2096387.6229349 | 37.737254207453105 | -122.382477163454 | (37.7372542074531, -122.382477163454) | ||
| 19100 | 19100 | 99391 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 1590 Yosemite Ave | 14 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/09/2012 12:00:00 AM | 3x3 | Permit Number 768917 | 6014911.1 | 2092490.7 | 37.726418980855996 | -122.390639783135 | (37.726418980856, -122.390639783135) | ||
| 19278 | 19278 | 39942 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 27 Ervine St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/25/1999 12:00:00 AM | Permit Number 41213 | 6009741.23684285 | 2089425.45829631 | 37.7177142900305 | -122.408295747981 | (37.7177142900305, -122.408295747981) | ||
| 19422 | 19422 | 58438 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 905 Ashbury St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/21/1979 12:00:00 AM | 3x3 | Permit Number 51484 | 5999161.38005537 | 2107089.77623283 | 37.7656181571992 | -122.446135313725 | (37.7656181571992, -122.446135313725) | ||
| 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) | |||
| 19983 | 19983 | 4397 | DPW Maintained 3 | Eriobotrya deflexa :: Bronze Loquat 49 | 1011 Church St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6004431.54351 | 2102978.61798 | 37.7546294472032 | -122.427614046667 | (37.7546294472032, -122.427614046667) | |||
| 20586 | 20586 | 22918 | DPW Maintained 3 | Eriobotrya deflexa :: Bronze Loquat 49 | 333 Valencia St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 20 | 3X3 | 6006138.942840001 | 2107682.09275 | 37.7676405157139 | -122.422043508318 | (37.7676405157139, -122.422043508318) | |||
| 20657 | 20657 | 64543 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 1547 Oakdale Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/25/1988 12:00:00 AM | Permit Number 25426 | 6015321.62159268 | 2095235.25021997 | 37.7339777321734 | -122.389412195042 | (37.7339777321734, -122.389412195042) | ||
| 20683 | 20683 | 12972 | DPW Maintained 3 | Eriobotrya deflexa :: Bronze Loquat 49 | 84 Lippard Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6001913.39953 | 2095585.0292900002 | 37.734185633051894 | -122.435793484091 | (37.7341856330519, -122.435793484091) | |||
| 20979 | 20979 | 85521 | DPW Maintained 3 | Eriobotrya deflexa :: Bronze Loquat 49 | 399X 12th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/06/2013 12:00:00 AM | 3 | 6008760.539183999 | 2108527.457431 | 37.7701092002187 | -122.413035486584 | (37.7701092002187, -122.413035486584) | |||
| 21151 | 21151 | 10207 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 1273 Guerrero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 2X2 | 6005836.971940001 | 2101563.9580099997 | 37.7508245136462 | -122.422653168634 | (37.7508245136462, -122.422653168634) | |||
| 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) | |||
| 21586 | 21586 | 10198 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 1209 Guerrero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/25/1991 12:00:00 AM | 3 | 2X2 | 6005820.58037 | 2101870.80495 | 37.7516661199201 | -122.422731656039 | (37.7516661199201, -122.422731656039) | ||
| 22381 | 22381 | 17744 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 1600X Pine St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 3X3 | 6006169.663819999 | 2115620.29477 | 37.789438622529204 | -122.42250137744101 | (37.7894386225292, -122.422501377441) | |||
| 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) | |||
| 23103 | 23103 | 26097 | DPW Maintained 3 | Eriobotrya deflexa :: Bronze Loquat 49 | 1583X Oakdale Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/08/2003 12:00:00 AM | 6 | 3x3 | 6015137.4531 | 2095367.1486 | 37.7343296857828 | -122.390058138496 | (37.7343296857828, -122.390058138496) | ||
| 23564 | 23564 | 43029 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 2131 26th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/06/2000 12:00:00 AM | 6 | Permit Number 42891 | 6012151.06584 | 2101359.39792 | 37.7506170436447 | -122.400803954262 | (37.7506170436447, -122.400803954262) | ||
| 23709 | 23709 | 223384 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 1 Cumberland St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 5ft | 6005565.506580001 | 2104580.7732 | 37.759092667419 | -122.42380640884701 | (37.759092667419, -122.423806408847) | |||
| 23816 | 23816 | 224059 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 3628 16th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6002696.79261 | 2106527.84926 | 37.76427650537521 | -122.43386694650499 | (37.7642765053752, -122.433866946505) | |||
| 23983 | 23983 | 224070 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 4411 17th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 6000003.97958 | 2105733.8947099997 | 37.7619433258348 | -122.443123570319 | (37.7619433258348, -122.443123570319) | |||
| 24000 | 24000 | 246500 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 273 Duncan St | 1 | : 4 | Tree 1 | Private 1 | 10 | Width 5ft | 6004745.35521 | 2099854.76299 | 37.746069811469 | -122.426306403626 | (37.746069811469, -122.426306403626) | |||
| 24032 | 24032 | 207660 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 1207 Willard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 5996711.4694300005 | 2107231.1786 | 37.7658662000893 | -122.454619182239 | (37.7658662000893, -122.454619182239) | |||
| 24108 | 24108 | 223503 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 3421 25th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 3ft | 6006951.65327 | 2101439.66063 | 37.750546046666706 | -122.41878967662 | (37.7505460466667, -122.41878967662) | |||
| 24291 | 24291 | 207706 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 215 Edna St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 2ft | 5998739.57891 | 2093599.69117 | 37.7285535657887 | -122.446623550035 | (37.7285535657887, -122.446623550035) | |||
| 24319 | 24319 | 176264 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 165 Brussels St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6010291.19923 | 2093895.2108900002 | 37.7300180820504 | -122.40670958899099 | (37.7300180820504, -122.406709588991) | |||
| 24422 | 24422 | 50532 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 315 Parnassus Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/06/2003 12:00:00 AM | Permit Number 47171 | 5996679.82856356 | 2106618.62344586 | 37.764182465684705 | -122.454684361894 | (37.7641824656847, -122.454684361894) | |||
| 24451 | 24451 | 42139 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 583 15th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/21/2000 12:00:00 AM | 5 | Permit Number 42434 | 5991253.848730001 | 2111457.82315 | 37.7771568827635 | -122.4738041366 | (37.7771568827635, -122.4738041366) | |
| 24524 | 24524 | 223397 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 3560 19th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6005876.75311 | 2104933.14392 | 37.7600777604998 | -122.422755010534 | (37.7600777604998, -122.422755010534) | |||
| 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) | |
| 24709 | 24709 | 182142 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 1418 25th Ave | 2 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 6 | Width 0ft | 5988379.3786 | 2105646.1459999997 | 37.761032715479395 | -122.483321592218 | (37.7610327154794, -122.483321592218) | |||
| 24712 | 24712 | 189244 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 690 Texas St | 5 | : 4 | Tree 1 | Private 1 | 4 | Width 3ft | 6013923.095430001 | 2103892.83973 | 37.757672010179206 | -122.394853496397 | (37.7576720101792, -122.394853496397) | |||
| 24989 | 24989 | 223551 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 1143 Shrader St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 19 | Width 3ft | 5997699.39696 | 2106553.80105 | 37.764062907387704 | -122.45115331019 | (37.7640629073877, -122.45115331019) | |||
| 25085 | 25085 | 223541 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 814 Alvarado St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 4ft | 6001016.96065 | 2102616.12439 | 37.7534403941744 | -122.43939657921301 | (37.7534403941744, -122.439396579213) | |||
| 25196 | 25196 | 137812 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 1802 Octavia St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 0ft | 6004857.7279 | 2115477.5519 | 37.7889725883007 | -122.42703036076 | (37.7889725883007, -122.42703036076) | |||
| 25319 | 25319 | 124355 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 1108 Balboa St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 4ft | 5992124.25378 | 2111386.32559 | 37.7770109442204 | -122.470787948699 | (37.7770109442204, -122.470787948699) | |||
| 25410 | 25410 | 46998 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 2011 26th St | 15 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/01/2002 12:00:00 AM | Permit Number 44999 | 6012426.60175733 | 2101420.79231292 | 37.7508009841444 | -122.39985543326799 | (37.7508009841444, -122.399855433268) | |||
| 25711 | 25711 | 223380 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 800 York St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6009884.795080001 | 2104504.34853 | 37.7591257084916 | -122.40886279708499 | (37.7591257084916, -122.408862797085) | |||
| 25760 | 25760 | 223377 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 2801 26th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6010298.3381900005 | 2101037.92652 | 37.7496308398979 | -122.407188209083 | (37.7496308398979, -122.407188209083) | |||
| 25831 | 25831 | 124534 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 951 Balboa St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 5992622.68332 | 2111346.9142400003 | 37.7769315430211 | -122.46906087290701 | (37.7769315430211, -122.469060872907) | |||
| 25939 | 25939 | 223572 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 801 Crescent Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 6008169.79 | 2095684.73442 | 37.7348128040698 | -122.414170142558 | (37.7348128040698, -122.414170142558) | |||
| 25987 | 25987 | 114650 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 2200 Post St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | 3x3 | 6001545.1748 | 2113940.4839 | 37.784564324662 | -122.43838116449301 | (37.784564324662, -122.438381164493) | |||
| 26240 | 26240 | 207694 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 1650 Portola Dr | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 5991855.32533 | 2096348.4574 | 37.7357053452243 | -122.470622695389 | (37.7357053452243, -122.470622695389) | |||
| 26480 | 26480 | 207665 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 315 Parnassus Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 6ft | 5996615.28225 | 2106600.5600799997 | 37.7641291658503 | -122.454906302505 | (37.7641291658503, -122.454906302505) | |||
| 26513 | 26513 | 207686 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 2451 18th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 5990741.806609999 | 2098714.09627 | 37.742136330634 | -122.474645120982 | (37.742136330634, -122.474645120982) | |||
| 26575 | 26575 | 207688 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 1732 Ulloa St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 5990596.01765 | 2098405.20532 | 37.7412797470716 | -122.47512666388799 | (37.7412797470716, -122.475126663888) | |||
| 26626 | 26626 | 123725 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 549 Cabrillo St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 5993866.33866 | 2110708.86626 | 37.7752514134392 | -122.46471237833799 | (37.7752514134392, -122.464712378338) | |||
| 26741 | 26741 | 126534 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 1551 Jones St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6008369.15173 | 2117857.28388 | 37.795704680394 | -122.415049773051 | (37.795704680394, -122.415049773051) | |||
| 26791 | 26791 | 223457 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 31 Rivoli St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 5998436.79798 | 2105994.15168 | 37.7625684428081 | -122.448562558536 | (37.7625684428081, -122.448562558536) | |||
| 26818 | 26818 | 124535 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 951 Balboa St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 5992606.88484 | 2111346.72253 | 37.7769301037952 | -122.469115510242 | (37.7769301037952, -122.469115510242) | |||
| 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) | |
| 26968 | 26968 | 223578 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 165 Prospect Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6006732.92847 | 2098549.7578 | 37.7425987089604 | -122.41934105903799 | (37.7425987089604, -122.419341059038) | |||
| 27081 | 27081 | 176269 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 273 Curtis St | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 2 | Width 6ft | 6000993.66237 | 2087160.73145 | 37.711002134104795 | -122.43836995721901 | (37.7110021341048, -122.438369957219) | |||
| 27090 | 27090 | 99644 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 1795 34th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | 3x3 | Permit Number 768958 | 5985623.9251 | 2103105.496 | 37.7538960444293 | -122.49266425054701 | (37.7538960444293, -122.492664250547) | ||
| 27188 | 27188 | 138860 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 523 IVY ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 0ft | 6004843.1098 | 2111063.3665 | 37.7768515029621 | -122.426766456726 | (37.7768515029621, -122.426766456726) | |||
| 27220 | 27220 | 223532 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 529 28th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6002464.30667 | 2099434.4104 | 37.744786420455604 | -122.434163917953 | (37.7447864204556, -122.434163917953) | |||
| 27265 | 27265 | 207601 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 129 Granada Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 4ft | 5995608.85604 | 2090759.60342 | 37.720576034226 | -122.457241192545 | (37.720576034226, -122.457241192545) | |||
| 27273 | 27273 | 138750 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 2200 POST ST | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 0ft | 6001227.9034 | 2113893.9374 | 37.7844184685956 | -122.439475475851 | (37.7844184685956, -122.439475475851) | |||
| 27391 | 27391 | 244450 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 600 Page St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 0ft | 6003616.0838 | 2109707.0129 | 37.773057839402796 | -122.430914285765 | (37.7730578394028, -122.430914285765) | |||
| 27448 | 27448 | 223517 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 980 Corbett Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 5999663.10864 | 2101754.10727 | 37.7509963650963 | -122.44401653863001 | (37.7509963650963, -122.44401653863) | |||
| 27612 | 27612 | 207552 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 1353 07th Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 5993922.19207 | 2106326.17113 | 37.7632209099368 | -122.464200926233 | (37.7632209099368, -122.464200926233) | |||
| 27771 | 27771 | 245044 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 155 Baker St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 0ft | 6000750.251 | 2109577.8851 | 37.7725404908768 | -122.440818271359 | (37.7725404908768, -122.440818271359) | |||
| 27840 | 27840 | 223489 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 469 Tompkins Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 2ft | 6007880.65482 | 2096572.00473 | 37.737232809540004 | -122.415232573728 | (37.73723280954, -122.415232573728) | |||
| 27871 | 27871 | 248510 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 167 Belvedere St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 0ft | 5998265.1375 | 2107816.9964 | 37.767563696861004 | -122.449287603561 | (37.767563696861, -122.449287603561) | |||
| 27900 | 27900 | 111560 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 1498x Kansas St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | 3x3 | 6011715.03072 | 2101496.45297 | 37.7509690365089 | -122.402321443274 | (37.7509690365089, -122.402321443274) | |||
| 28046 | 28046 | 207672 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 542 Kirkham St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 5993147.42915 | 2105300.29395 | 37.76035943445 | -122.46680597172801 | (37.76035943445, -122.466805971728) | |||
| 28172 | 28172 | 64537 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 1448 Oakdale Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/25/1988 12:00:00 AM | 4 | Permit Number 25419 | 6015877.1655 | 2094890.2503 | 37.73306121716389 | -122.38746743202299 | (37.7330612171639, -122.387467432023) | |
| 28353 | 28353 | 207561 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 1471 12th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 2ft | 5992400.09167 | 2105443.1565799997 | 37.7607085377924 | -122.469401040143 | (37.7607085377924, -122.469401040143) | |||
| 28370 | 28370 | 207590 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 434 Hearst Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 1ft | 5998520.921569999 | 2094401.97974 | 37.7307439689499 | -122.447437181086 | (37.7307439689499, -122.447437181086) | |||
| 28415 | 28415 | 90182 | DPW Maintained 3 | Eriobotrya deflexa :: Bronze Loquat 49 | 1650 Balboa St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/26/2008 12:00:00 AM | 3 | 3x3 | 5990417.752119999 | 2111322.65396 | 37.7767372842601 | -122.47668655097799 | (37.7767372842601, -122.476686550978) | ||
| 28440 | 28440 | 122307 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 1617 Balboa St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 5990526.29521 | 2111270.38864 | 37.7766000733292 | -122.47630725349701 | (37.7766000733292, -122.476307253497) | |||
| 28441 | 28441 | 189265 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 2203 Newcomb Ave | 1 | : 4 | Tree 1 | Private 1 | 1 | Width 3ft | 6011972.28331 | 2098093.92114 | 37.7416407727111 | -122.40119276536001 | (37.7416407727111, -122.40119276536) | |||
| 28506 | 28506 | 223371 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 3527 18th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 5ft | 6006033.70926 | 2105484.59441 | 37.7616007686849 | -122.42225135332899 | (37.7616007686849, -122.422251353329) | |||
| 28518 | 28518 | 47405 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 545 08th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/14/2002 12:00:00 AM | 6 | Permit Number 45316 | 5993431.14199 | 2111760.1937700002 | 37.778112976546396 | -122.466294232497 | (37.7781129765464, -122.466294232497) | |
| 28626 | 28626 | 114447 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 367 Bay Shore Blvd | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | 4x4 | 6010564.675559999 | 2098126.12029 | 37.741650555529496 | -122.40606209151699 | (37.7416505555295, -122.406062091517) | |||
| 28661 | 28661 | 189257 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 2231 Newcomb Ave | 1 | : 4 | Tree 1 | Private 1 | 1 | Width 3ft | 6011833.55798 | 2098197.58892 | 37.7419176820557 | -122.40167971856 | (37.7419176820557, -122.40167971856) | |||
| 28671 | 28671 | 207602 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 121 Brighton Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 5996198.32663 | 2090727.0482700001 | 37.7205204831134 | -122.455201239645 | (37.7205204831134, -122.455201239645) | |||
| 28700 | 28700 | 189264 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 2207 Newcomb Ave | 1 | : 4 | Tree 1 | Private 1 | 1 | Width 3ft | 6011951.89121 | 2098108.4509400004 | 37.741679530779294 | -122.401264295606 | (37.7416795307793, -122.401264295606) | |||
| 28721 | 28721 | 223467 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 812 Clayton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 4ft | 5998670.80107 | 2107458.83461 | 37.7666034705969 | -122.447858683442 | (37.7666034705969, -122.447858683442) | |||
| 28812 | 28812 | 94752 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 491 Bay Shore Blvd | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/28/2010 12:00:00 AM | 4 | 3x3 | 6010356.01767 | 2097548.96974 | 37.7400541518831 | -122.406742898988 | (37.7400541518831, -122.406742898988) | ||
| 28915 | 28915 | 42944 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 30 Shotwell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/05/2000 12:00:00 AM | Permit Number 42839 | 6007671.602079799 | 2107773.96917263 | 37.7679791099284 | -122.416748729284 | (37.7679791099284, -122.416748729284) | ||
| 28935 | 28935 | 223424 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 115 Peralta Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6010291.05729 | 2100231.54093 | 37.7474162746512 | -122.407156552038 | (37.7474162746512, -122.407156552038) | |||
| 29080 | 29080 | 223542 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 4112 22nd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 4ft | 6001417.09599 | 2102930.9043099997 | 37.7543274674466 | -122.43803537522699 | (37.7543274674466, -122.438035375227) | |||
| 29141 | 29141 | 45523 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 153 Jordan Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/23/2001 12:00:00 AM | 4 | Permit Number 44284 | 5996204.70963 | 2113340.17454 | 37.782610825272 | -122.456813820837 | (37.782610825272, -122.456813820837) | ||
| 29213 | 29213 | 224107 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 33 Gough St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 4ft | 6006435.98558 | 2109358.16079 | 37.7722593483308 | -122.421135098612 | (37.7722593483308, -122.421135098612) | |||
| 29267 | 29267 | 223415 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 320 Montcalm St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6009521.39447 | 2099607.71888 | 37.745660293502205 | -122.409773978512 | (37.7456602935022, -122.409773978512) | |||
| 29324 | 29324 | 246575 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 100 Laguna St | 4 | : 4 | Tree 1 | Private 1 | 11 | Width 3ft | 6005230.8128 | 2109313.1532400004 | 37.7720677549581 | -122.425300698072 | (37.7720677549581, -122.425300698072) |
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");