Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, SiteOrder, qSiteInfo, qCaretaker, qCareAssistant, PlantDate, PlotSize, PermitNotes
| Link | rowid ▼ | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 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) | |
| 2540 | 2540 | 141909 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 900 MCALLISTER ST | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 0ft | 6004576.1236 | 2111931.0419 | 37.779218827498205 | -122.427751880486 | (37.7792188274982, -122.427751880486) | |||
| 2565 | 2565 | 191072 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 396 12th St | 4 | : 4 | Tree 1 | Private 1 | 5 | Width 3ft | Permit Number 779704 | 6008614.31812 | 2108613.9778 | 37.770338555601505 | -122.41354738542101 | (37.7703385556015, -122.413547385421) | ||
| 2674 | 2674 | 223658 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 336 Bosworth St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | Permit Number 18811 | 6003665.26948 | 2095270.38526 | 37.7334210492488 | -122.429714281988 | (37.7334210492488, -122.429714281988) | ||
| 2678 | 2678 | 223657 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 336 Bosworth St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | Permit Number 18811 | 6003655.959980001 | 2095270.88152 | 37.7334218847062 | -122.429746502924 | (37.7334218847062, -122.429746502924) | ||
| 2685 | 2685 | 223659 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 336 Bosworth St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | Permit Number 18811 | 6003694.10013 | 2095275.57225 | 37.7334369240608 | -122.42961497614901 | (37.7334369240608, -122.429614976149) | ||
| 3065 | 3065 | 175836 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 101 Rhine St | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | Width 3ft | 5994366.585519999 | 2086543.72285 | 37.70892880020671 | -122.46122985488998 | (37.7089288002067, -122.46122985489) | |||
| 7638 | 7638 | 52428 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 1809X Octavia St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/22/2005 12:00:00 AM | 5 | 3x3 | Permit Number 48544 | 6004799.3483 | 2115577.2997 | 37.7892431693813 | -122.427239454587 | (37.7892431693813, -122.427239454587) |
| 9453 | 9453 | 90543 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 642 Cabrillo St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/14/2008 12:00:00 AM | 5 | 3x3 | 5993540.28402 | 2110753.93051 | 37.775356344693996 | -122.465843541425 | (37.775356344694, -122.465843541425) | ||
| 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) | |||
| 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) | |
| 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) | |||
| 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) | |||
| 29878 | 29878 | 223592 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 1142 Alabama St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6009191.70637 | 2102498.92995 | 37.7535804348003 | -122.411118182576 | (37.7535804348003, -122.411118182576) | |||
| 32578 | 32578 | 189248 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 1575 Bay Shore Blvd | 13 | : 4 | Tree 1 | Private 1 | 5 | Width 3ft | 6011796.69629 | 2092248.5093 | 37.7255806984826 | -122.401389189886 | (37.7255806984826, -122.401389189886) | |||
| 33174 | 33174 | 94748 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 491 Bay Shore Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/28/2010 12:00:00 AM | 5 | 3x3 | 6010334.01877 | 2097301.80143 | 37.739374250017796 | -122.40680154737 | (37.7393742500178, -122.40680154737) | ||
| 33537 | 33537 | 223576 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 18 Bennington St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6007174.02692 | 2097594.37425 | 37.7400002716996 | -122.417748161849 | (37.7400002716996, -122.417748161849) | |||
| 33740 | 33740 | 223519 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 118 Milton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 2ft | 6003743.87449 | 2095119.74297 | 37.7330118702979 | -122.429431783351 | (37.7330118702979, -122.429431783351) | |||
| 34265 | 34265 | 207541 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 1231 04th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 5994826.21474 | 2107149.24647 | 37.7655329248259 | -122.461133898112 | (37.7655329248259, -122.461133898112) | |||
| 35931 | 35931 | 246581 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 184 Laguna St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | Width 6ft | 6005207.86965 | 2109476.17522 | 37.772514077680995 | -122.425391663601 | (37.772514077681, -122.425391663601) | |||
| 36333 | 36333 | 189242 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 690 Texas St | 3 | : 4 | Tree 1 | Private 1 | 5 | Width 3ft | 6013899.94699 | 2103926.17826 | 37.757762263422705 | -122.394935888703 | (37.7577622634227, -122.394935888703) | |||
| 36614 | 36614 | 207680 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 2475 15th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 5991693.59154 | 2098601.29032 | 37.7418816983798 | -122.471345960741 | (37.7418816983798, -122.471345960741) | |||
| 37880 | 37880 | 70231 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 535 Hayes St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/20/1993 12:00:00 AM | 5 | 6005265.5585 | 2110935.6138 | 37.7765246008409 | -122.425295984643 | (37.7765246008409, -122.425295984643) | ||
| 37991 | 37991 | 46987 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 2011 26th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/24/2010 12:00:00 AM | 5 | Permit Number 53455 | 6012596.87958 | 2101472.71362 | 37.75095304025211 | -122.39927023785 | (37.7509530402521, -122.39927023785) | ||
| 38763 | 38763 | 68965 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 2271 Bay St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/11/2009 12:00:00 AM | 5 | 3x3 | Permit Number 52893 | 5999938.800530001 | 2120187.4575099996 | 37.8016253679701 | -122.444387754501 | (37.8016253679701, -122.444387754501) | |
| 39260 | 39260 | 122258 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 1300 Clement St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 5991414.12952 | 2113444.52375 | 37.7826210986154 | -122.473394620723 | (37.7826210986154, -122.473394620723) | |||
| 39678 | 39678 | 78352 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 647 Madrid St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/12/2000 12:00:00 AM | 5 | 6002178.01905 | 2090148.09572 | 37.71927207124 | -122.43449000133499 | (37.71927207124, -122.434490001335) | ||
| 39950 | 39950 | 176266 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 928 Excelsior Ave | 2 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 5 | Width 5ft | 6004692.43448 | 2091256.7125 | 37.7224585032472 | -122.425877480072 | (37.7224585032472, -122.425877480072) | |||
| 40237 | 40237 | 189241 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 690 Texas St | 2 | : 4 | Tree 1 | Private 1 | 5 | Width 3ft | 6013889.32799 | 2103940.39875 | 37.75780071933279 | -122.394973609851 | (37.7578007193328, -122.394973609851) | |||
| 40465 | 40465 | 84616 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 65 Avila St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/13/2008 12:00:00 AM | 5 | 3x3 | Permit Number 50830 | 6001046.02752 | 2119987.7015 | 37.8011400020673 | -122.440541917971 | (37.8011400020673, -122.440541917971) | |
| 42199 | 42199 | 207620 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 724 Head St | 3 | : 4 | Tree 1 | Private 1 | 5 | Width 3ft | 5993530.060819999 | 2090669.11588 | 37.7202079660024 | -122.46442030687099 | (37.7202079660024, -122.464420306871) | |||
| 42996 | 42996 | 52427 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 1815X Octavia St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/22/2005 12:00:00 AM | 5 | 3x3 | Permit Number 48544 | 6004786.32091155 | 2115731.58720361 | 37.7896660673411 | -122.427295522794 | (37.7896660673411, -122.427295522794) |
| 43044 | 43044 | 101126 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 1500 Clement St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | 3x3 | 5990758.62584 | 2113423.68557 | 37.7825259029155 | -122.47566083662 | (37.7825259029155, -122.47566083662) | |||
| 43159 | 43159 | 52433 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 1807 Octavia St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/22/2005 12:00:00 AM | 5 | Permit Number 48548 | 6004803.7724 | 2115546.524 | 37.7891589172332 | -122.427221954641 | (37.7891589172332, -122.427221954641) | |
| 43699 | 43699 | 37992 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 650 Texas St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/08/1998 12:00:00 AM | 5 | Permit Number 40210 | 6013843.225980001 | 2104002.4986900003 | 37.7579686686468 | -122.39513740068999 | (37.7579686686468, -122.39513740069) | ||
| 44010 | 44010 | 46258 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 22 Leo St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/30/2002 12:00:00 AM | 5 | Permit Number 44543 | 6001485.63381 | 2091410.0324 | 37.72269773728679 | -122.436973607764 | (37.7226977372868, -122.436973607764) | ||
| 44490 | 44490 | 224082 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 285 Waller St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6004326.71028 | 2109072.08218 | 37.7713547130825 | -122.428410875685 | (37.7713547130825, -122.428410875685) | |||
| 45452 | 45452 | 71627 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 955 Sansome St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/07/1995 12:00:00 AM | 5 | 6012042.50926 | 2118962.60831 | 37.798945373890604 | -122.402416977385 | (37.7989453738906, -122.402416977385) | ||
| 46847 | 46847 | 191076 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 320 12th St | 2 | : 4 | Tree 1 | Private 1 | 5 | Width 3ft | 6008335.79472 | 2108708.57829 | 37.7705826631 | -122.414517495805 | (37.7705826631, -122.414517495805) | |||
| 50565 | 50565 | 246488 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 399 Duncan St | 2 | : 4 | Tree 1 | Private 1 | 5 | Width 3ft | 6004022.94651 | 2099813.62498 | 37.7459159950372 | -122.428801466541 | (37.7459159950372, -122.428801466541) | |||
| 50944 | 50944 | 141437 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 535 HAYES ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 0ft | 6005239.6877 | 2110933.7323 | 37.7765179730819 | -122.42538534531602 | (37.7765179730819, -122.425385345316) | |||
| 51858 | 51858 | 223518 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 988 Corbett Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 5999648.8119 | 2101706.51559 | 37.7508648743372 | -122.444062558736 | (37.7508648743372, -122.444062558736) | |||
| 53170 | 53170 | 37231 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 1815 35th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/23/2002 12:00:00 AM | 5 | Permit Number 46003 | 5985330.0834 | 2102828.2693 | 37.7531176701023 | -122.493659982631 | (37.7531176701023, -122.493659982631) | |
| 53446 | 53446 | 207632 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 1314 06th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 5994271.867880001 | 2106534.82687 | 37.763813972349 | -122.463006662539 | (37.763813972349, -122.463006662539) | |||
| 54885 | 54885 | 223581 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 85 Bessie St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6008353.87265 | 2100058.3229099996 | 37.746832054349106 | -122.41384297638399 | (37.7468320543491, -122.413842976384) | |||
| 55547 | 55547 | 52985 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 483 Harkness Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/08/2006 12:00:00 AM | 5 | Permit Number 48967 | 6010218.63808 | 2089641.8160400002 | 37.7183350855707 | -122.40666081696101 | (37.7183350855707, -122.406660816961) | ||
| 55966 | 55966 | 191103 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 2041 26th St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 2ft | 6012409.65437 | 2101419.9709400004 | 37.750797784011205 | -122.399913981553 | (37.7507977840112, -122.399913981553) | |||
| 58248 | 58248 | 85535 | DPW Maintained 3 | Eriobotrya deflexa :: Bronze Loquat 49 | 110 12th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 05/29/2007 12:00:00 AM | 5 | 6007364.04136 | 2109271.5858400003 | 37.7720739081089 | -122.41791872548 | (37.7720739081089, -122.41791872548) | |||
| 60664 | 60664 | 126491 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 3041 Webster St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6002852.033969999 | 2119100.62162 | 37.7988069853068 | -122.434228905666 | (37.7988069853068, -122.434228905666) | |||
| 61380 | 61380 | 126499 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 1636 Filbert St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6005076.86043 | 2119214.79365 | 37.7992464965988 | -122.426538412535 | (37.7992464965988, -122.426538412535) | |||
| 62357 | 62357 | 207702 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 182 Stillings Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 5999557.67926 | 2095791.1114 | 37.7346173903777 | -122.44395272994 | (37.7346173903777, -122.44395272994) | |||
| 62371 | 62371 | 207536 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 1422 14th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 5991820.20399 | 2105720.0126799997 | 37.761435182799396 | -122.471426765747 | (37.7614351827994, -122.471426765747) | |||
| 63506 | 63506 | 138230 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 101 Anza St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 0ft | 5998494.0384 | 2112624.2642 | 37.78077630983061 | -122.44884217738701 | (37.7807763098306, -122.448842177387) | |||
| 63796 | 63796 | 224054 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 259 Liberty St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6004598.76073 | 2103939.28595 | 37.7572766727063 | -122.42710418591801 | (37.7572766727063, -122.427104185918) | |||
| 65646 | 65646 | 100781 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 211 12th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | 3x3 | 6007785.147480001 | 2109092.4486 | 37.771605730051704 | -122.416449390639 | (37.7716057300517, -122.416449390639) | |||
| 65952 | 65952 | 191070 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 396 12th St | 2 | : 4 | Tree 1 | Private 1 | 5 | Width 3ft | 6008653.1077 | 2108592.5301900003 | 37.770281843468794 | -122.413411694812 | (37.7702818434688, -122.413411694812) | |||
| 67669 | 67669 | 224042 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 202 Vicksburg St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6004105.71465 | 2102139.30363 | 37.7523064515919 | -122.42868102302099 | (37.7523064515919, -122.428681023021) | |||
| 68961 | 68961 | 78365 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 671 Madrid St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/12/2000 12:00:00 AM | 5 | 6002103.17705 | 2090031.785 | 37.7189484591704 | -122.434740388752 | (37.7189484591704, -122.434740388752) | ||
| 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) | |
| 69540 | 69540 | 189239 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 670 Texas St | 1 | : 4 | Tree 1 | Private 1 | 5 | Width 3ft | 6013865.85822 | 2103972.02889 | 37.7578862637531 | -122.39505699408998 | (37.7578862637531, -122.39505699409) | |||
| 69655 | 69655 | 223652 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 360 Bosworth St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6003548.82407 | 2095261.8327099998 | 37.7333909714052 | -122.430116256482 | (37.7333909714052, -122.430116256482) | |||
| 70028 | 70028 | 46999 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 2011 26th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/24/2010 12:00:00 AM | 5 | Permit Number 53455 | 6012582.01898 | 2101471.73036 | 37.7509495122074 | -122.399321558558 | (37.7509495122074, -122.399321558558) | ||
| 70107 | 70107 | 182614 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 1866 21st Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 0ft | 5989725.7736 | 2102651.2747 | 37.752887864299105 | -122.47844604391199 | (37.7528878642991, -122.478446043912) | |||
| 70665 | 70665 | 223366 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 1451 Hampshire St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 4ft | 6010372.8016800005 | 2101145.39248 | 37.7499300848135 | -122.406938283899 | (37.7499300848135, -122.406938283899) | |||
| 70966 | 70966 | 46985 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 2011 26th St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/01/2002 12:00:00 AM | 5 | Permit Number 44999 | 6012611.41785 | 2101473.70376 | 37.7509565692018 | -122.39922003227501 | (37.7509565692018, -122.399220032275) | ||
| 71578 | 71578 | 207669 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 1767 10th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 5993090.082880001 | 2103453.39463 | 37.7552850196943 | -122.466870038526 | (37.7552850196943, -122.466870038526) | |||
| 72739 | 72739 | 245938 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 798 Stanyan St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 0ft | 5997162.5368 | 2107813.8167 | 37.767491836283895 | -122.453101106035 | (37.7674918362839, -122.453101106035) | |||
| 74588 | 74588 | 176265 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 928 Excelsior Ave | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 5 | Width 5ft | 6004683.740019999 | 2091261.8142 | 37.7224720200432 | -122.42590789782601 | (37.7224720200432, -122.425907897826) | |||
| 75087 | 75087 | 94754 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 491 Bay Shore Blvd | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/28/2010 12:00:00 AM | 5 | 3x3 | 6010365.49883 | 2097628.45401 | 37.7402729290463 | -122.406715716973 | (37.7402729290463, -122.406715716973) | ||
| 76227 | 76227 | 207633 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 1391 05th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 5994552.52419 | 2106074.9918 | 37.7625675470791 | -122.462002617128 | (37.7625675470791, -122.462002617128) | |||
| 76788 | 76788 | 207577 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 1863 18th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 5990606.99166 | 2102703.3769 | 37.753082043103596 | -122.475402462551 | (37.7530820431036, -122.475402462551) | |||
| 78761 | 78761 | 103367 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 290X Bartlett St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | 3x3 | 6006718.6 | 2102097.0 | 37.7523378256517 | -122.41964222832199 | (37.7523378256517, -122.419642228322) | |||
| 84004 | 84004 | 52464 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 635 07th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/27/2005 12:00:00 AM | 5 | 3x4 | Permit Number 48575 | 5993761.556419999 | 2111156.7218 | 37.776475063376004 | -122.46510737655399 | (37.776475063376, -122.465107376554) |
| 84763 | 84763 | 99032 | DPW Maintained 3 | Eriobotrya deflexa :: Bronze Loquat 49 | 200X Bartlett St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 5 | 3x3 | 6006692.0 | 2102600.1 | 37.7537177245237 | -122.419769910314 | (37.7537177245237, -122.419769910314) | ||
| 99991 | 99991 | 52429 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 1815X Octavia St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/22/2005 12:00:00 AM | 5 | 3x3 | Permit Number 48544 | 6004786.32091155 | 2115731.58720361 | 37.7896660673411 | -122.427295522794 | (37.7896660673411, -122.427295522794) |
| 102733 | 102733 | 47029 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 121 Steiner St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/02/2002 12:00:00 AM | 5 | Permit Number 778397 | 6003325.68265754 | 2108679.50884572 | 37.7702201068925 | -122.43184543930599 | (37.7702201068925, -122.431845439306) | |
| 103810 | 103810 | 40253 | DPW Maintained 3 | Eriobotrya deflexa :: Bronze Loquat 49 | 3351X 23rd St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 05/13/1999 12:00:00 AM | 5 | 3x3 | Permit Number 41415 | 6006702.84210434 | 2102592.14346256 | 37.7536964884672 | -122.419731851285 | (37.7536964884672, -122.419731851285) |
| 130041 | 130041 | 97054 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 214 Gaven St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/17/2011 12:00:00 AM | 5 | 3x3 | Permit Number 768120 | 6009377.072380001 | 2095012.7741200002 | 37.7330354837976 | -122.40994871225901 | (37.7330354837976, -122.409948712259) | |
| 131120 | 131120 | 191104 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 2031 26th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 2ft | 6012452.226869999 | 2101435.1702 | 37.75084189126421 | -122.399767828221 | (37.7508418912642, -122.399767828221) | |||
| 131450 | 131450 | 223594 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 376 Shotwell St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6007794.5106 | 2105672.41812 | 37.7622156522408 | -122.416174744881 | (37.7622156522408, -122.416174744881) | |||
| 131882 | 131882 | 114653 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 2200 Post St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | 3x3 | 6001412.8316 | 2113920.3557 | 37.7845015292891 | -122.43883758329599 | (37.7845015292891, -122.438837583296) | |||
| 132290 | 132290 | 81390 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 1588 Indiana St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/05/2003 12:00:00 AM | 5 | 6015103.68734 | 2101191.55999 | 37.750320442739 | -122.39058173735201 | (37.750320442739, -122.390581737352) | ||
| 133959 | 133959 | 224096 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 310 Hermann St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6003743.84038 | 2108689.19941 | 37.7702704103723 | -122.43039972637301 | (37.7702704103723, -122.430399726373) | |||
| 135201 | 135201 | 54187 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 1540 Kirkwood Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/02/2009 12:00:00 AM | 5 | 3x3 | Permit Number 52350 | 6015552.16986 | 2096532.8786900002 | 37.7375535365611 | -122.388705666158 | (37.7375535365611, -122.388705666158) | |
| 136651 | 136651 | 245939 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 798 Stanyan St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 0ft | 5997159.5085 | 2107834.7119 | 37.76754903559 | -122.45311308902299 | (37.76754903559, -122.453113089023) | |||
| 137127 | 137127 | 207603 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 122 Brighton Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 5996240.91229 | 2090722.7587 | 37.7205111481621 | -122.455053725648 | (37.7205111481621, -122.455053725648) | |||
| 147839 | 147839 | 200655 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 1516 Oakdale Ave | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 0ft | 6015384.228999999 | 2095258.3254 | 37.7340445629032 | -122.389197350847 | (37.7340445629032, -122.389197350847) | |||
| 148327 | 148327 | 191668 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 535 Brannan St | 17 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 2ft | 6013300.95519 | 2111099.53181 | 37.7774253698298 | -122.397510546978 | (37.7774253698298, -122.397510546978) | |||
| 149436 | 149436 | 223513 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 3345 17th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6006561.96009 | 2106094.72257 | 37.763305820334296 | -122.42046765508101 | (37.7633058203343, -122.420467655081) | |||
| 151584 | 151584 | 126511 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 251 Alhambra St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6000979.360280001 | 2119998.9635799997 | 37.8011671283179 | -122.44077342326 | (37.8011671283179, -122.44077342326) | |||
| 153642 | 153642 | 223653 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 360 Bosworth St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6003566.55526 | 2095262.2275 | 37.7333930596415 | -122.430054982967 | (37.7333930596415, -122.430054982967) | |||
| 153756 | 153756 | 87110 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 2932` Jackson St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/02/2008 12:00:00 AM | 5 | 3x3 | Permit Number 50060 | 6000132.04641 | 2116463.71551 | 37.79141198242971 | -122.443451403763 | (37.7914119824297, -122.443451403763) | |
| 155393 | 155393 | 191661 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 535 Brannan St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 2ft | 6013060.069630001 | 2110865.5961 | 37.7767696201591 | -122.398327437183 | (37.7767696201591, -122.398327437183) | |||
| 155575 | 155575 | 245940 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 798 Stanyan St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 0ft | 5997158.2972 | 2107852.8817 | 37.767598855780605 | -122.453118590527 | (37.7675988557806, -122.453118590527) | |||
| 156287 | 156287 | 223468 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 61 Parnassus Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 4ft | 5998354.918269999 | 2106850.9643099997 | 37.764916352335504 | -122.448907471004 | (37.7649163523355, -122.448907471004) | |||
| 157006 | 157006 | 138228 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 101 Anza St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 0ft | 5998518.0663 | 2112627.9868 | 37.7807879051601 | -122.448759321794 | (37.7807879051601, -122.448759321794) | |||
| 160396 | 160396 | 191660 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 535 Brannan St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 2ft | 6013043.397999999 | 2110850.10481 | 37.7767261559098 | -122.3983840225 | (37.7767261559098, -122.3983840225) | |||
| 163166 | 163166 | 94753 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 491 Bay Shore Blvd | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/28/2010 12:00:00 AM | 5 | 3x3 | 6010359.2896300005 | 2097585.56035 | 37.74015480488671 | -122.40673416387301 | (37.7401548048867, -122.406734163873) | ||
| 165832 | 165832 | 191107 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 2021 26th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 2ft | 6012536.97765 | 2101462.04256 | 37.7509204011789 | -122.399476636765 | (37.7509204011789, -122.399476636765) | |||
| 166638 | 166638 | 114655 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 2200 Post St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | 3x3 | 6001302.3779 | 2113905.5111 | 37.7844544851842 | -122.43921865019199 | (37.7844544851842, -122.439218650192) |
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");