Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, qSiteInfo, qCaretaker, qCareAssistant, DBH, PlotSize
| Link | rowid ▼ | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 145 | 145 | 111561 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 1498x Kansas St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/28/2017 12:00:00 AM | 3 | 3x3 | Permit Number 779654 | 6011715.78319 | 2101470.3886700002 | 37.7508975116216 | -122.40231700873699 | (37.7508975116216, -122.402317008737) | |
| 469 | 469 | 85530 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 101X 12th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/29/2007 12:00:00 AM | 6 | 6007333.48731 | 2109350.5044400003 | 37.772288880253704 | -122.418030010287 | (37.7722888802537, -122.418030010287) | |||
| 1009 | 1009 | 223537 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 1300 Noe St | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 15 | Width 5ft | 6003218.0959 | 2100594.3408 | 37.7480140720016 | -122.431640256605 | (37.7480140720016, -122.431640256605) | |||
| 1859 | 1859 | 251772 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 90x Seville St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6002045.0 | 2087474.0 | 37.7119220445534 | -122.434758675533 | (37.7119220445534, -122.434758675533) | ||||
| 2026 | 2026 | 252856 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 926 Edinburgh St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6001578.0 | 2088750.0 | 37.7153991335272 | -122.43646402536001 | (37.7153991335272, -122.43646402536) | ||||
| 2608 | 2608 | 115877 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 1880 Jackson St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/01/2016 12:00:00 AM | 3 | Permit Number 775798 | 6005144.10497 | 2117158.82947 | 37.7936051429156 | -122.42615927543999 | (37.7936051429156, -122.42615927544) | ||
| 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) | ||
| 3478 | 3478 | 180626 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 18 Winding Way | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 6ft | 6002802.39914 | 2087193.02957 | 37.7111935323316 | -122.432120840807 | (37.7111935323316, -122.432120840807) | |||
| 3749 | 3749 | 223601 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 280x Shotwell St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6007724.0 | 2106220.0 | 37.7637152201621 | -122.41645740380899 | (37.7637152201621, -122.416457403809) | |||
| 3916 | 3916 | 179075 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 2 Edinburgh St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/27/2017 08:37:00 AM | 3 | Width 3ft | 6004507.82534 | 2093430.5210099998 | 37.7284168670376 | -122.426670354762 | (37.7284168670376, -122.426670354762) | ||
| 4069 | 4069 | 251732 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 824 Prague St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/05/2017 08:20:00 AM | 3 | Width 6ft | 6002320.95082 | 2087061.4224099999 | 37.7108048597154 | -122.43377544319401 | (37.7108048597154, -122.433775443194) | ||
| 4304 | 4304 | 181055 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 120 Brunswick St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/10/2017 09:09:00 AM | 3 | Width 2ft | 6000651.24572 | 2087413.96665 | 37.711677979129604 | -122.43957157019899 | (37.7116779791296, -122.439571570199) | ||
| 4506 | 4506 | 253629 | DPW Maintained 3 | Eriobotrya deflexa :: Bronze Loquat 49 | 123 Eddy St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6009831.1503800005 | 2113653.7445799997 | 37.7842448233884 | -122.409694124829 | (37.7842448233884, -122.409694124829) | |||||
| 4728 | 4728 | 160846 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 669 Vienna St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/24/2017 12:20:00 PM | 3 | Width 0ft | 6002781.71244 | 2089588.8302099998 | 37.717770702526295 | -122.432363340291 | (37.7177707025263, -122.432363340291) | |
| 4880 | 4880 | 253705 | Planning Code 138.1 required 4 | Eriobotrya deflexa :: Bronze Loquat 49 | 98X Shotwell St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/31/2017 12:00:00 AM | 3 | 3x4 | Permit Number 775137 | ||||||
| 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) | |
| 9052 | 9052 | 90537 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 508 Cabrillo St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/14/2008 12:00:00 AM | 3 | 3x3 | 5994022.026869999 | 2110770.5827599997 | 37.7754298449829 | -122.464178302965 | (37.7754298449829, -122.464178302965) | ||
| 9137 | 9137 | 7679 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 299X Cabrillo St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/08/2008 12:00:00 AM | 18 | 3x3 | 5994818.31491 | 2110743.00765 | 37.7753999939995 | -122.461421774878 | (37.7753999939995, -122.461421774878) | ||
| 11880 | 11880 | 47474 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/14/2002 12:00:00 AM | Permit Number 45375 | |||||||||
| 13465 | 13465 | 85534 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 110 12th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/29/2007 12:00:00 AM | 6 | 6007347.01879 | 2109279.74931 | 37.7720953650306 | -122.417978186861 | (37.7720953650306, -122.417978186861) | |||
| 13743 | 13743 | 26579 | DPW Maintained 3 | Eriobotrya deflexa :: Bronze Loquat 49 | 241 Bay Shore Blvd | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/22/1998 12:00:00 AM | 6 | 3X3 | 6011098.44545 | 2099048.11598 | 37.7442119973787 | -122.40428136282 | (37.7442119973787, -122.40428136282) | ||
| 14022 | 14022 | 25548 | DPW Maintained 3 | Eriobotrya deflexa :: Bronze Loquat 49 | 141 Industrial St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/06/2013 12:00:00 AM | 3 | 2x3 | 6011568.628409999 | 2097178.44526 | 37.7391045433316 | -122.402524116297 | (37.7391045433316, -122.402524116297) | ||
| 14391 | 14391 | 26581 | DPW Maintained 3 | Eriobotrya deflexa :: Bronze Loquat 49 | 235 Bay Shore Blvd | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/11/2006 12:00:00 AM | 3 | 3X3 | 6011124.08251 | 2099133.7568 | 37.7444485811329 | -122.404198741189 | (37.7444485811329, -122.404198741189) | ||
| 14582 | 14582 | 26572 | DPW Maintained 3 | Eriobotrya deflexa :: Bronze Loquat 49 | 353 Bay Shore Blvd | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/22/1998 12:00:00 AM | 6 | 3X3 | 6010658.7205300005 | 2098280.84549 | 37.742080657198294 | -122.405747809912 | (37.7420806571983, -122.405747809912) | ||
| 15177 | 15177 | 26109 | DPW Maintained 3 | Eriobotrya deflexa :: Bronze Loquat 49 | 1509 Oakdale Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/09/2010 12:00:00 AM | 3 | 3x3 | 6015436.4421 | 2095148.4030000002 | 37.7337456325918 | -122.389009160289 | (37.7337456325918, -122.389009160289) | ||
| 15179 | 15179 | 94749 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 491 Bay Shore Blvd | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/28/2010 12:00:00 AM | 3 | 3x3 | 6010338.73158 | 2097355.9728900003 | 37.739523256888106 | -122.406789069267 | (37.7395232568881, -122.406789069267) | ||
| 15574 | 15574 | 85539 | DPW Maintained 3 | Eriobotrya deflexa :: Bronze Loquat 49 | 180 12th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 05/29/2007 12:00:00 AM | 6 | 6007548.32218 | 2109164.7314400002 | 37.771790880665606 | -122.417273708325 | (37.7717908806656, -122.417273708325) | |||
| 15833 | 15833 | 117147 | Section 143 8 | Eriobotrya deflexa :: Bronze Loquat 49 | 928 Toland St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/13/2016 12:00:00 AM | 3 | 3x3 | Permit Number 774325 | 6011972.25416 | 2098042.58697 | 37.7414998183769 | -122.40118925978001 | (37.7414998183769, -122.40118925978) | |
| 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) | ||
| 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) | ||
| 16065 | 16065 | 26114 | DPW Maintained 3 | Eriobotrya deflexa :: Bronze Loquat 49 | 1505 Oakdale Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/22/1997 12:00:00 AM | 6 | 3x3 | 6015470.5181 | 2095128.0673 | 37.7336916836833 | -122.38888992918699 | (37.7336916836833, -122.388889929187) | ||
| 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) | ||
| 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) | ||
| 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) | |||
| 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) | ||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 29383 | 29383 | 207619 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 724 Head St | 2 | : 4 | Tree 1 | Private 1 | 7 | Width 3ft | 5993530.3141 | 2090655.8864799999 | 37.720171655864604 | -122.46441847134199 | (37.7201716558646, -122.464418471342) | |||
| 29474 | 29474 | 121021 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 1649 Greenwich St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 17 | 3x3 | 6005068.54414 | 2119516.86917 | 37.800075448478204 | -122.42658871161001 | (37.8000754484782, -122.42658871161) | |||
| 29914 | 29914 | 223374 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 14 Lundys Ln | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 2ft | 6007165.43911 | 2099578.0998299997 | 37.7454466559323 | -122.41791844039699 | (37.7454466559323, -122.417918440397) | |||
| 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) | |
| 30932 | 30932 | 74829 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 998 Sansome St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/07/1995 12:00:00 AM | 7 | 6012078.13426 | 2119069.37262 | 37.7992405115981 | -122.402301213024 | (37.7992405115981, -122.402301213024) | ||
| 31314 | 31314 | 52821 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 2850@ ANZA Anza St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/19/2016 12:00:00 AM | 1 | Permit Number 775537 | 5989762.54787 | 2111977.16007 | 37.7784963508186 | -122.479000957003 | (37.7784963508186, -122.479000957003) | ||
| 31518 | 31518 | 223432 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 321 Valencia St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 2ft | 6006137.48741 | 2107733.43659 | 37.7677814116141 | -122.422052190377 | (37.7677814116141, -122.422052190377) | |||
| 34451 | 34451 | 224069 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 4411 17th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 3ft | 5999992.96572 | 2105734.65927 | 37.761944797124706 | -122.44316171774099 | (37.7619447971247, -122.443161717741) | |||
| 35470 | 35470 | 244884 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 1395 Page St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 0ft | 5999983.4478 | 2109160.8819999998 | 37.7713518056431 | -122.443440754039 | (37.7713518056431, -122.443440754039) | |||
| 36353 | 36353 | 95920 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 701 15th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/29/2011 12:00:00 AM | 1 | 3x3 | Permit Number 767618 | 5991287.86259 | 2110556.38381 | 37.7746837464675 | -122.47362070061001 | (37.7746837464675, -122.47362070061) |
| 36647 | 36647 | 176250 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 3562 San Bruno Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6012131.39961 | 2089120.6063 | 37.717010780805104 | -122.40001258053101 | (37.7170107808051, -122.400012580531) | |||
| 36717 | 36717 | 191109 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 2251 24th St | 2 | : 4 | Tree 1 | Private 1 | 6 | Width 3ft | 6011772.01455 | 2102301.09153 | 37.753181579175404 | -122.40218095120399 | (37.7531815791754, -122.402180951204) | |||
| 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) | ||
| 38407 | 38407 | 250069 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 307 Austin St | 2 | : 4 | Tree 1 | Private 1 | 2 | Width 2ft | 6005709.21572 | 2115345.18544 | 37.7886572546664 | -122.424074905926 | (37.7886572546664, -122.424074905926) | |||
| 38621 | 38621 | 224043 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 393 Douglass St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6001164.85207 | 2104167.0832 | 37.7577073670178 | -122.438996283747 | (37.7577073670178, -122.438996283747) | |||
| 38665 | 38665 | 191094 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 1951 23rd St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 4ft | 6012582.07272 | 2102822.21844 | 37.754657662544396 | -122.39941617174401 | (37.7546576625444, -122.399416171744) | |||
| 39850 | 39850 | 207617 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 385 Victoria St | 2 | : 4 | Tree 1 | Private 1 | 6 | Width 3ft | 5993228.76427 | 2089783.4849099999 | 37.717758864755794 | -122.46539747963001 | (37.7177588647558, -122.46539747963) | |||
| 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) | |||
| 40020 | 40020 | 224067 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 198 Corbin Pl | 2 | Side Yard : Yard 17 | Tree 1 | Private 1 | 7 | Width 3ft | 6000076.797040001 | 2105677.0536599997 | 37.7617914060643 | -122.44286764213301 | (37.7617914060643, -122.442867642133) | |||
| 40110 | 40110 | 207692 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 10 Madrone Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 5992959.6562 | 2099040.51355 | 37.743160850889396 | -122.467000282841 | (37.7431608508894, -122.467000282841) | |||
| 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) | |||
| 40591 | 40591 | 191084 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 1050 18th St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 13 | 6014440.039609999 | 2105781.9689 | 37.7628878793072 | -122.393197865211 | (37.7628878793072, -122.393197865211) | ||||
| 41426 | 41426 | 176252 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 95 Delta St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6010107.1247 | 2089599.03617 | 37.7182113811213 | -122.407043259958 | (37.7182113811213, -122.407043259958) | |||
| 41611 | 41611 | 223487 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 315 Park St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 2ft | 6006838.49776 | 2096321.93409 | 37.7364875458659 | -122.41881806641899 | (37.7364875458659, -122.418818066419) | |||
| 41937 | 41937 | 90906 | DPW Maintained 3 | Eriobotrya deflexa :: Bronze Loquat 49 | 901X Cabrillo St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/20/2008 12:00:00 AM | 4 | 3x3 | 5992776.28818 | 2110667.73592 | 37.7750755767076 | -122.46848008510901 | (37.7750755767076, -122.468480085109) | ||
| 42290 | 42290 | 223546 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 384 Sussex St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6000939.020959999 | 2096709.0709799998 | 37.7372165929608 | -122.43924275106899 | (37.7372165929608, -122.439242751069) | |||
| 42420 | 42420 | 223556 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 700 Andover St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 3ft | 6007416.58318 | 2095667.1286 | 37.7347221263083 | -122.41677299908501 | (37.7347221263083, -122.416772999085) | |||
| 42731 | 42731 | 140303 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 154 COLE ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 0ft | 5997832.4894 | 2110000.3166 | 37.773533777498606 | -122.450941522503 | (37.7735337774986, -122.450941522503) | |||
| 43055 | 43055 | 126514 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 54 Casa Way | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6001509.62012 | 2121629.4389400003 | 37.8056741643903 | -122.439055417799 | (37.8056741643903, -122.439055417799) | |||
| 43973 | 43973 | 123776 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 999 Cabrillo St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 5992611.69228 | 2110664.0229 | 37.775055872901504 | -122.469049183134 | (37.7750558729015, -122.469049183134) | |||
| 44060 | 44060 | 126493 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 2901 Buchanan St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6003443.9611599995 | 2118340.85925 | 37.796754452719 | -122.43212636085899 | (37.796754452719, -122.432126360859) | |||
| 44256 | 44256 | 207681 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 2655 16th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 5991411.6864 | 2097337.95206 | 37.738396582641 | -122.47222861836399 | (37.738396582641, -122.472228618364) | |||
| 44316 | 44316 | 191057 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 351 Saint Francis Pl | 2 | : 4 | Tree 1 | Private 1 | 4 | Width 1ft | 6013212.85575 | 2113183.5161599996 | 37.78314260738 | -122.39796154170901 | (37.78314260738, -122.397961541709) | |||
| 44800 | 44800 | 176232 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 490 Lisbon St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 2ft | 6002153.50763 | 2090617.3285 | 37.7205590883176 | -122.434608262185 | (37.7205590883176, -122.434608262185) | |||
| 45044 | 45044 | 126497 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 1651 Filbert St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 6005046.68269 | 2119164.91299 | 37.7991078310233 | -122.426639284086 | (37.7991078310233, -122.426639284086) | |||
| 45309 | 45309 | 126506 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 2300 Francisco St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6000233.97348 | 2119929.48889 | 37.8009338918396 | -122.44334778477 | (37.8009338918396, -122.44334778477) | |||
| 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) | ||
| 45779 | 45779 | 124478 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 286 Willard St North | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 5996252.67686 | 2110874.20088 | 37.775842667159296 | -122.45646949927401 | (37.7758426671593, -122.456469499274) | |||
| 46309 | 46309 | 224083 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 285 Waller St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6004355.4783 | 2109071.91707 | 37.7713558875841 | -122.428311353983 | (37.7713558875841, -122.428311353983) | |||
| 46717 | 46717 | 176263 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 728 Burrows St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6009121.13665 | 2092884.06532 | 37.7271761560436 | -122.410683275834 | (37.7271761560436, -122.410683275834) | |||
| 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) | |||
| 48277 | 48277 | 207628 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 445 Hugo St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 5994326.4302199995 | 2106989.87938 | 37.7650665705984 | -122.462850964727 | (37.7650665705984, -122.462850964727) | |||
| 50512 | 50512 | 176225 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 67 Ruth St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 2ft | 6001455.44817 | 2091671.0484900002 | 37.723412712716495 | -122.437096631405 | (37.7234127127165, -122.437096631405) | |||
| 50518 | 50518 | 189268 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 1721 Oakdale Ave | 2 | : 4 | Tree 1 | Private 1 | 7 | Width 3ft | 6014331.30759 | 2095974.08961 | 37.735951477983704 | -122.39288771511002 | (37.7359514779837, -122.39288771511) | |||
| 50527 | 50527 | 126551 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 953 Sansome St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6012059.41755 | 2118828.1581599996 | 37.79857715006921 | -122.402349010193 | (37.7985771500692, -122.402349010193) | |||
| 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) | |||
| 50577 | 50577 | 191067 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 374 06th St | 2 | : 4 | Tree 1 | Private 1 | 8 | Width 3ft | 6011934.76855 | 2111785.94153 | 37.779233928048 | -122.402284937117 | (37.779233928048, -122.402284937117) | |||
| 51143 | 51143 | 191669 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 240 12th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6007874.13645 | 2108978.90348 | 37.771298965913 | -122.41613352894501 | (37.771298965913, -122.416133528945) | |||
| 51697 | 51697 | 87865 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 65 Avila St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/13/2008 12:00:00 AM | 6 | 3x3 | Permit Number 50830 | 6001049.0728400005 | 2119968.8143 | 37.801088316234704 | -122.440530024452 | (37.8010883162347, -122.440530024452) | |
| 51942 | 51942 | 200114 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 1566 Yosemite Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 0ft | 6014762.2628 | 2092586.3302 | 37.7266733037648 | -122.39116099243 | (37.7266733037648, -122.39116099243) | |||
| 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) | ||
| 53224 | 53224 | 126538 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 846 Union St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6008930.81381 | 2119411.54164 | 37.8000038345594 | -122.413216275735 | (37.8000038345594, -122.413216275735) | |||
| 53543 | 53543 | 189266 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 550 Bay Shore Blvd | 2 | : 4 | Tree 1 | Private 1 | 9 | Width 4ft | 6010210.57589 | 2097161.88665 | 37.7389831663466 | -122.407218500042 | (37.7389831663466, -122.407218500042) | |||
| 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) | |||
| 53881 | 53881 | 200108 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 1538 Yosemite Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 0ft | 6014848.2148 | 2092517.9747 | 37.7264903827113 | -122.390859081597 | (37.7264903827113, -122.390859081597) |
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");