Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: SiteOrder, qSiteInfo, DBH, PlotSize
| Link | rowid ▼ | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 479 | 479 | 85531 | DPW Maintained 3 | Eriobotrya deflexa :: Bronze Loquat 49 | 101X 12th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 05/29/2007 12:00:00 AM | 6 | 6007317.968280001 | 2109362.68703 | 37.7723214572932 | -122.418084555959 | (37.7723214572932, -122.418084555959) | |||
| 490 | 490 | 85529 | DPW Maintained 3 | Eriobotrya deflexa :: Bronze Loquat 49 | 101 12th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 05/29/2007 12:00:00 AM | 6 | 3x3 | 6007351.89443 | 2109342.45047 | 37.7722678019432 | -122.417965767207 | (37.7722678019432, -122.417965767207) | ||
| 1100 | 1100 | 2952 | DPW Maintained 3 | Eriobotrya deflexa :: Bronze Loquat 49 | 2001 California St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 45 | 3X3 | 6004785.43 | 2115651.1441 | 37.789445140420604 | -122.427292872615 | (37.7894451404206, -122.427292872615) | |||
| 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) | |
| 4458 | 4458 | 253080 | DPW Maintained 3 | Eriobotrya deflexa :: Bronze Loquat 49 | 2849X Alemany Blvd | 13 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 10/13/2017 11:00:00 AM | 3 | 3X3 | 5997618.33471 | 2088040.74004 | 37.7132258706419 | -122.45009922742399 | (37.7132258706419, -122.450099227424) | ||
| 4465 | 4465 | 253081 | DPW Maintained 3 | Eriobotrya deflexa :: Bronze Loquat 49 | 2849X Alemany Blvd | 14 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 10/13/2017 10:35:00 AM | 3 | 3X3 | 5997618.33471 | 2088040.74004 | 37.7132258706419 | -122.45009922742399 | (37.7132258706419, -122.450099227424) | ||
| 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) | |||||
| 4520 | 4520 | 253628 | DPW Maintained 3 | Eriobotrya deflexa :: Bronze Loquat 49 | 123 Eddy St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6009831.1503800005 | 2113653.7445799997 | 37.7842448233884 | -122.409694124829 | (37.7842448233884, -122.409694124829) | |||||
| 4902 | 4902 | 91003 | DPW Maintained 3 | Eriobotrya deflexa :: Bronze Loquat 49 | 2449 Balboa St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 11/02/2016 12:00:00 AM | 3 | 3x3 | 5987916.77213 | 2111175.55765 | 37.776188016519605 | -122.48532727858999 | (37.7761880165196, -122.48532727859) | ||
| 4907 | 4907 | 91006 | DPW Maintained 3 | Eriobotrya deflexa :: Bronze Loquat 49 | 2401X Balboa St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 11/02/2016 12:00:00 AM | 3 | 3x3 | 5988072.26413 | 2111179.36369 | 37.7762075240837 | -122.48478967552099 | (37.7762075240837, -122.484789675521) | ||
| 6880 | 6880 | 18913 | DPW Maintained 3 | Eriobotrya deflexa :: Bronze Loquat 49 | 2612 Sacramento St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6002139.88643 | 2115759.87525 | 37.789593716919704 | -122.43645393002599 | (37.7895937169197, -122.436453930026) | |||
| 8142 | 8142 | 14641 | DPW Maintained 3 | Eriobotrya deflexa :: Bronze Loquat 49 | 600X McAllister St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 06/01/1998 12:00:00 AM | 8 | 4x4 | 6006147.64251 | 2112148.2738 | 37.77990406506721 | -122.422330778736 | (37.7799040650672, -122.422330778736) | ||
| 10434 | 10434 | 15775 | DPW Maintained 3 | Eriobotrya deflexa :: Bronze Loquat 49 | 4808 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 06/05/1997 12:00:00 AM | 10 | 3X3 | Permit Number 773279 | 6001261.3736 | 2090797.0594 | 37.7210019026793 | -122.437704946106 | (37.7210019026793, -122.437704946106) | |
| 13423 | 13423 | 26000 | DPW Maintained 3 | Eriobotrya deflexa :: Bronze Loquat 49 | 1715 Oakdale Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/25/2012 12:00:00 AM | 3 | 3x3 | 6014353.43695 | 2095957.87317 | 37.7359081801195 | -122.39281007033999 | (37.7359081801195, -122.39281007034) | ||
| 13618 | 13618 | 25915 | DPW Maintained 3 | Eriobotrya deflexa :: Bronze Loquat 49 | 1800 Oakdale Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 06/16/2015 12:17:00 PM | 3 | 3X3 | 6013847.663980001 | 2096411.7192 | 37.737126242566 | -122.394590512161 | (37.737126242566, -122.394590512161) | ||
| 13664 | 13664 | 6735 | DPW Maintained 3 | Eriobotrya deflexa :: Bronze Loquat 49 | 1300X Fairfax Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/14/2007 12:00:00 AM | 2 | 3x3 | 6017028.4506 | 2097182.15302 | 37.7394180218109 | -122.383646604615 | (37.7394180218109, -122.383646604615) | ||
| 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) | ||
| 13937 | 13937 | 25993 | DPW Maintained 3 | Eriobotrya deflexa :: Bronze Loquat 49 | 1789 Oakdale Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/25/2012 12:00:00 AM | 3 | 3x3 | 6014037.236380001 | 2096196.21513 | 37.736545050306795 | -122.39391998842699 | (37.7365450503068, -122.393919988427) | ||
| 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) | ||
| 14072 | 14072 | 15048 | DPW Maintained 3 | Eriobotrya deflexa :: Bronze Loquat 49 | 1119 Mendell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/20/2000 12:00:00 AM | 6 | 3X3 | 6015497.5853 | 2096021.456 | 37.7361462484719 | -122.38885869852601 | (37.7361462484719, -122.388858698526) | ||
| 14085 | 14085 | 25999 | DPW Maintained 3 | Eriobotrya deflexa :: Bronze Loquat 49 | 1717 Oakdale Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/22/1997 12:00:00 AM | 3 | 3x3 | 6014332.85691 | 2095971.76656 | 37.7359451854222 | -122.392882195975 | (37.7359451854222, -122.392882195975) | ||
| 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) | ||
| 14462 | 14462 | 26105 | DPW Maintained 3 | Eriobotrya deflexa :: Bronze Loquat 49 | 1547 Oakdale Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 11/16/2009 12:00:00 AM | 3 | 3x3 | 6015325.4204 | 2095230.2952 | 37.733964337308 | -122.38939871537501 | (37.733964337308, -122.389398715375) | ||
| 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) | ||
| 14642 | 14642 | 85538 | DPW Maintained 3 | Eriobotrya deflexa :: Bronze Loquat 49 | 180 12th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 05/29/2007 12:00:00 AM | 6 | 6007511.05272 | 2109187.82256 | 37.771852186555705 | -122.417404262918 | (37.7718521865557, -122.417404262918) | |||
| 14726 | 14726 | 6733 | DPW Maintained 3 | Eriobotrya deflexa :: Bronze Loquat 49 | 1300X Fairfax Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 20 | 3x3 | 6017061.2899 | 2097158.62505 | 37.7393552338433 | -122.383531422133 | (37.7393552338433, -122.383531422133) | |||
| 14736 | 14736 | 6734 | DPW Maintained 3 | Eriobotrya deflexa :: Bronze Loquat 49 | 1300X Fairfax Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3x3 | 6017044.07799 | 2097171.2102099997 | 37.739388838832504 | -122.383591809817 | (37.7393888388325, -122.383591809817) | |||
| 14864 | 14864 | 26580 | DPW Maintained 3 | Eriobotrya deflexa :: Bronze Loquat 49 | 235 Bay Shore Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/22/1998 12:00:00 AM | 3 | 3X3 | 6011115.925530001 | 2099106.52375 | 37.7443733492673 | -122.404225030173 | (37.7443733492673, -122.404225030173) | ||
| 14884 | 14884 | 26578 | DPW Maintained 3 | Eriobotrya deflexa :: Bronze Loquat 49 | 241 Bay Shore Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/22/1998 12:00:00 AM | 6 | 3X3 | 6011090.3987 | 2099026.28851 | 37.7441516142074 | -122.404307650877 | (37.7441516142074, -122.404307650877) | ||
| 14921 | 14921 | 26108 | DPW Maintained 3 | Eriobotrya deflexa :: Bronze Loquat 49 | 1509 Oakdale Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/08/2003 12:00:00 AM | 3 | 3x3 | 6015422.1522 | 2095159.3952 | 37.733775022834394 | -122.38905933236099 | (37.7337750228344, -122.389059332361) | ||
| 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) | ||
| 15330 | 15330 | 85542 | DPW Maintained 3 | Eriobotrya deflexa :: Bronze Loquat 49 | 240 12th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 05/29/2007 12:00:00 AM | 6 | 6007856.4505900005 | 2108988.3497099997 | 37.7713239085987 | -122.416195374412 | (37.7713239085987, -122.416195374412) | |||
| 15346 | 15346 | 27245 | DPW Maintained 3 | Eriobotrya deflexa :: Bronze Loquat 49 | 1840X Oakdale Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/11/2006 12:00:00 AM | 3 | 3X3 | 6013813.103680001 | 2096437.28943 | 37.7371945316856 | -122.39471179383499 | (37.7371945316856, -122.394711793835) | ||
| 15442 | 15442 | 25547 | DPW Maintained 3 | Eriobotrya deflexa :: Bronze Loquat 49 | 141 Industrial St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/01/2014 12:00:00 AM | 3 | 2x3 | 6011520.04511 | 2097161.49572 | 37.7390552910796 | -122.402690904578 | (37.7390552910796, -122.402690904578) | ||
| 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) | |||
| 15668 | 15668 | 26613 | DPW Maintained 3 | Eriobotrya deflexa :: Bronze Loquat 49 | 1355 Bay Shore Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/26/2015 10:59:00 PM | 3 | 3X3 | 6011681.24548 | 2092829.4663099998 | 37.727169444392096 | -122.401829114846 | (37.7271694443921, -122.401829114846) | ||
| 15766 | 15766 | 15015 | DPW Maintained 3 | Eriobotrya deflexa :: Bronze Loquat 49 | 650 Mendell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 05/14/2014 12:00:00 AM | 6 | 3x3 | 6016271.14274 | 2097128.2420599998 | 37.7392281047953 | -122.38626130881501 | (37.7392281047953, -122.386261308815) | ||
| 15846 | 15846 | 29367 | DPW Maintained 3 | Eriobotrya deflexa :: Bronze Loquat 49 | 367X Bay Shore Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/20/2006 12:00:00 AM | 3 | 3X3 | 6010545.10979 | 2098098.4290400003 | 37.7415734269678 | -122.40612779327 | (37.7415734269678, -122.40612779327) | ||
| 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) | ||
| 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) | ||
| 16117 | 16117 | 26556 | DPW Maintained 3 | Eriobotrya deflexa :: Bronze Loquat 49 | 228 Bay Shore Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/09/1998 12:00:00 AM | 12 | 3x3 | 6011088.04001 | 2099355.12223 | 37.7450543887552 | -122.404338947303 | (37.7450543887552, -122.404338947303) | ||
| 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) | |||
| 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) | ||
| 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) | ||
| 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) | |||
| 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) | |||
| 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) | ||
| 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) | ||
| 31976 | 31976 | 25549 | DPW Maintained 3 | Eriobotrya deflexa :: Bronze Loquat 49 | 141 Industrial St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 11/11/2005 12:00:00 AM | 3 | 2X3 | 6011617.33955 | 2097194.1765099997 | 37.739150457318004 | -122.402356800142 | (37.739150457318, -122.402356800142) | ||
| 33337 | 33337 | 90910 | DPW Maintained 3 | Eriobotrya deflexa :: Bronze Loquat 49 | 701 Cabrillo St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/20/2008 12:00:00 AM | 2 | 3x3 | 5993421.38614 | 2110692.4955700003 | 37.775180801458504 | -122.46625036777999 | (37.7751808014585, -122.46625036778) | ||
| 34308 | 34308 | 90326 | DPW Maintained 3 | Eriobotrya deflexa :: Bronze Loquat 49 | 1901X Balboa St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/27/2008 12:00:00 AM | 3 | 3x3 | 5989640.77384 | 2111238.69513 | 37.77646165861329 | -122.479368175716 | (37.7764616586133, -122.479368175716) | ||
| 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) | ||
| 48566 | 48566 | 90172 | DPW Maintained 3 | Eriobotrya deflexa :: Bronze Loquat 49 | 1500X Balboa St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/26/2008 12:00:00 AM | 3 | 3x3 | 5990908.22712 | 2111337.0984900002 | 37.7768053819444 | -122.474990924283 | (37.7768053819444, -122.474990924283) | ||
| 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) | |||
| 61152 | 61152 | 90191 | DPW Maintained 3 | Eriobotrya deflexa :: Bronze Loquat 49 | 1860X Balboa St | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/26/2008 12:00:00 AM | 3 | 3x3 | 5989777.17693 | 2111298.4454200002 | 37.776633638000604 | -122.478900695137 | (37.7766336380006, -122.478900695137) | |||
| 77377 | 77377 | 90183 | DPW Maintained 3 | Eriobotrya deflexa :: Bronze Loquat 49 | 1650 Balboa St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/26/2008 12:00:00 AM | 3 | 3x3 | 5990402.31364 | 2111319.28606 | 37.776727141439 | -122.476739710576 | (37.776727141439, -122.476739710576) | ||
| 77491 | 77491 | 7681 | DPW Maintained 3 | Eriobotrya deflexa :: Bronze Loquat 49 | 315X Cabrillo St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 06/22/2011 12:00:00 AM | 3 | 3x3 | 5994678.74309 | 2110742.5512099997 | 37.7753907066265 | -122.46190454994301 | (37.7753907066265, -122.461904549943) | ||
| 77859 | 77859 | 90215 | DPW Maintained 3 | Eriobotrya deflexa :: Bronze Loquat 49 | 2434 Balboa St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/21/2008 12:00:00 AM | 3 | 3x3 | 5987937.95416 | 2111227.93997 | 37.7763330776559 | -122.485257849615 | (37.7763330776559, -122.485257849615) | ||
| 78766 | 78766 | 90347 | DPW Maintained 3 | Eriobotrya deflexa :: Bronze Loquat 49 | 1351 Balboa St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/28/2008 12:00:00 AM | 3 | 3x3 | 5991383.395219999 | 2111300.2697400004 | 37.776731786489 | -122.473344504612 | (37.776731786489, -122.473344504612) | ||
| 78800 | 78800 | 90432 | DPW Maintained 3 | Eriobotrya deflexa :: Bronze Loquat 49 | 49X Gough St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/22/2008 12:00:00 AM | 3 | 3x3 | 6006339.227867 | 2109481.166325 | 37.7725916370239 | -122.42147852996 | (37.7725916370239, -122.42147852996) | ||
| 79493 | 79493 | 90998 | DPW Maintained 3 | Eriobotrya deflexa :: Bronze Loquat 49 | 2545 Balboa St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 11/14/2008 12:00:00 AM | 3 | 3x3 | 5987618.415159999 | 2111163.66443 | 37.7761379752311 | -122.486358489761 | (37.7761379752311, -122.486358489761) | ||
| 80107 | 80107 | 90178 | DPW Maintained 3 | Eriobotrya deflexa :: Bronze Loquat 49 | 1542 Balboa St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/26/2008 12:00:00 AM | 3 | 3x3 | 5990743.86008 | 2111332.6529200003 | 37.7767836486034 | -122.475559188643 | (37.7767836486034, -122.475559188643) | ||
| 80214 | 80214 | 29491 | DPW Maintained 3 | Eriobotrya deflexa :: Bronze Loquat 49 | 1628X Ingalls St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 08/05/2015 07:30:00 AM | 3 | 3x3 | 6016725.73414 | 2093293.6586200001 | 37.7287242549235 | -122.38442251427799 | (37.7287242549235, -122.384422514278) | ||
| 80324 | 80324 | 90539 | DPW Maintained 3 | Eriobotrya deflexa :: Bronze Loquat 49 | 546 Cabrillo St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/14/2008 12:00:00 AM | 3 | 3x3 | 5993965.73496 | 2110768.06622 | 37.7754196906156 | -122.464372845695 | (37.7754196906156, -122.464372845695) | ||
| 80512 | 80512 | 90161 | DPW Maintained 3 | Eriobotrya deflexa :: Bronze Loquat 49 | 1000X Balboa St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/12/2008 12:00:00 AM | 3 | 3x3 | 5992485.27988 | 2111393.76315 | 37.7770522373591 | -122.46953960037901 | (37.7770522373591, -122.469539600379) | ||
| 81064 | 81064 | 26562 | DPW Maintained 3 | Eriobotrya deflexa :: Bronze Loquat 49 | 550 Bay Shore Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/14/1999 12:00:00 AM | 6 | 3X3 | 6010221.3990327995 | 2097223.1768194 | 37.7391520616783 | -122.407185397649 | (37.7391520616783, -122.407185397649) | ||
| 81865 | 81865 | 90187 | DPW Maintained 3 | Eriobotrya deflexa :: Bronze Loquat 49 | 1826 Balboa St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/26/2008 12:00:00 AM | 3 | 3x3 | 5989876.689130001 | 2111302.12921 | 37.776649530669 | -122.478556726612 | (37.776649530669, -122.478556726612) | ||
| 82010 | 82010 | 90166 | DPW Maintained 3 | Eriobotrya deflexa :: Bronze Loquat 49 | 1300 Balboa St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/26/2008 12:00:00 AM | 3 | 3x3 | 5991544.41484 | 2111361.65556 | 37.7769096577615 | -122.47279197242099 | (37.7769096577615, -122.472791972421) | ||
| 82289 | 82289 | 90181 | DPW Maintained 3 | Eriobotrya deflexa :: Bronze Loquat 49 | 1640 Balboa St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/26/2008 12:00:00 AM | 3 | 3x3 | 5990451.673780001 | 2111322.99271 | 37.776740181884605 | -122.476569231876 | (37.7767401818846, -122.476569231876) | ||
| 82767 | 82767 | 90176 | DPW Maintained 3 | Eriobotrya deflexa :: Bronze Loquat 49 | 1528 Balboa St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/17/2016 07:32:00 AM | 3 | 3x3 | 5990794.25741 | 2111335.28271 | 37.776793790701 | -122.47538504305 | (37.776793790701, -122.47538504305) | ||
| 82916 | 82916 | 90553 | DPW Maintained 3 | Eriobotrya deflexa :: Bronze Loquat 49 | 1090 Cabrillo St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/14/2008 12:00:00 AM | 3 | 3x3 | 5992323.628330001 | 2110709.32554 | 37.7751636133682 | -122.470048949636 | (37.7751636133682, -122.470048949636) | ||
| 83628 | 83628 | 90164 | DPW Maintained 3 | Eriobotrya deflexa :: Bronze Loquat 49 | 1108 Balboa St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/10/2008 12:00:00 AM | 3 | 3x3 | 5992192.4340470005 | 2111377.6526 | 37.776991073192 | -122.470551462384 | (37.776991073192, -122.470551462384) | ||
| 83774 | 83774 | 90350 | DPW Maintained 3 | Eriobotrya deflexa :: Bronze Loquat 49 | 1045 Balboa St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/12/2008 12:00:00 AM | 3 | 3x3 | 5992328.99634 | 2111334.95536 | 37.7768817336944 | -122.470075945794 | (37.7768817336944, -122.470075945794) | ||
| 84034 | 84034 | 91007 | DPW Maintained 3 | Eriobotrya deflexa :: Bronze Loquat 49 | 2401X Balboa St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 11/14/2008 12:00:00 AM | 3 | 3x3 | 5988091.7784 | 2111178.02295 | 37.7762049792996 | -122.484722072811 | (37.7762049792996, -122.484722072811) | ||
| 84462 | 84462 | 7682 | DPW Maintained 3 | Eriobotrya deflexa :: Bronze Loquat 49 | 315X Cabrillo St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 06/22/2011 12:00:00 AM | 3 | 3x3 | 5994678.74309 | 2110742.5512099997 | 37.7753907066265 | -122.46190454994301 | (37.7753907066265, -122.461904549943) | ||
| 84862 | 84862 | 90325 | DPW Maintained 3 | Eriobotrya deflexa :: Bronze Loquat 49 | 1921 Balboa St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/27/2008 12:00:00 AM | 3 | 3x3 | 5989582.35832 | 2111234.7631 | 37.7764474692851 | -122.47956996156601 | (37.7764474692851, -122.479569961566) | ||
| 85049 | 85049 | 90904 | DPW Maintained 3 | Eriobotrya deflexa :: Bronze Loquat 49 | 925 Cabrillo St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/20/2008 12:00:00 AM | 3 | 3x3 | 5992720.2562 | 2110664.48698 | 37.77506341928439 | -122.468673673873 | (37.7750634192844, -122.468673673873) | ||
| 85511 | 85511 | 90328 | DPW Maintained 3 | Eriobotrya deflexa :: Bronze Loquat 49 | 1849X Balboa St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/27/2008 12:00:00 AM | 3 | 3x3 | 5989790.54801 | 2111243.58929 | 37.7764837946672 | -122.478850428089 | (37.7764837946672, -122.478850428089) | ||
| 86024 | 86024 | 90438 | DPW Maintained 3 | Eriobotrya deflexa :: Bronze Loquat 49 | 48X Gough St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/22/2008 12:00:00 AM | 3 | 3x3 | 6006368.067431 | 2109508.884182 | 37.772669369655205 | -122.421380739497 | (37.7726693696552, -122.421380739497) | ||
| 86228 | 86228 | 90540 | DPW Maintained 3 | Eriobotrya deflexa :: Bronze Loquat 49 | 550X Cabrillo St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/29/2014 12:00:00 AM | 3 | 3x3 | 5993951.099186 | 2110760.95535 | 37.7753993224191 | -122.46442295748301 | (37.7753993224191, -122.464422957483) | ||
| 86604 | 86604 | 90435 | DPW Maintained 3 | Eriobotrya deflexa :: Bronze Loquat 49 | 2 Gough St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/22/2008 12:00:00 AM | 3 | 3x3 | 6006637.011883 | 2109229.0558849997 | 37.7719161875872 | -122.42043056397199 | (37.7719161875872, -122.420430563972) | ||
| 87735 | 87735 | 90339 | DPW Maintained 3 | Eriobotrya deflexa :: Bronze Loquat 49 | 1617 Balboa St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/28/2008 12:00:00 AM | 3 | 3x3 | 5990541.50098 | 2111271.1479 | 37.7766030398525 | -122.476254708345 | (37.7766030398525, -122.476254708345) | ||
| 87804 | 87804 | 90431 | DPW Maintained 3 | Eriobotrya deflexa :: Bronze Loquat 49 | 49X Gough St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/21/2014 12:00:00 AM | 3 | 3x3 | Permit Number 770519 | 6006339.227867 | 2109481.166325 | 37.7725916370239 | -122.42147852996 | (37.7725916370239, -122.42147852996) | |
| 88012 | 88012 | 26636 | DPW Maintained 3 | Eriobotrya deflexa :: Bronze Loquat 49 | 585X Bay Shore Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/16/1998 12:00:00 AM | 3 | 3X3 | 6010330.4322368 | 2096858.6143875 | 37.738157152935294 | -122.406782722291 | (37.7381571529353, -122.406782722291) | ||
| 88308 | 88308 | 91000 | DPW Maintained 3 | Eriobotrya deflexa :: Bronze Loquat 49 | 2533 Balboa St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 11/14/2008 12:00:00 AM | 3 | 3x3 | 5987666.18452 | 2111163.5769599997 | 37.7761405192841 | -122.486193238376 | (37.7761405192841, -122.486193238376) | ||
| 89235 | 89235 | 90546 | DPW Maintained 3 | Eriobotrya deflexa :: Bronze Loquat 49 | 826 Cabrillo St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/14/2008 12:00:00 AM | 2 | 3x3 | 5993034.20515 | 2110734.5298200003 | 37.775273869360596 | -122.467592759821 | (37.7752738693606, -122.467592759821) | ||
| 89828 | 89828 | 90324 | DPW Maintained 3 | Eriobotrya deflexa :: Bronze Loquat 49 | 1949 Balboa St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/27/2008 12:00:00 AM | 3 | 3x3 | 5989502.24352 | 2111235.4245 | 37.7764446312789 | -122.479847146645 | (37.7764446312789, -122.479847146645) | ||
| 90346 | 90346 | 6736 | DPW Maintained 3 | Eriobotrya deflexa :: Bronze Loquat 49 | 1300X Fairfax Ave | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 06/30/2011 12:00:00 AM | 2 | 3x3 | 6017621.9936242 | 2096730.3826429 | 37.7382103402349 | -122.381562963191 | (37.7382103402349, -122.381562963191) | ||
| 90394 | 90394 | 75463 | DPW Maintained 3 | Eriobotrya deflexa :: Bronze Loquat 49 | 1806 Balboa St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/22/2013 12:00:00 AM | 3 | 3x3 | 5989925.9266 | 2111303.98207 | 37.7766574766255 | -122.47838653717 | (37.7766574766255, -122.47838653717) | ||
| 90454 | 90454 | 10192 | DPW Maintained 3 | Eriobotrya deflexa :: Bronze Loquat 49 | 1169 Guerrero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 07/16/2016 04:46:00 AM | 3 | 3X3 | 6005808.6696938 | 2102164.8077902 | 37.7524727119111 | -122.42279373679199 | (37.7524727119111, -122.422793736792) | ||
| 90555 | 90555 | 7680 | DPW Maintained 3 | Eriobotrya deflexa :: Bronze Loquat 49 | 299X Cabrillo St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/08/2008 12:00:00 AM | 6 | 3x3 | 5994929.5013 | 2110751.87573 | 37.7754307421541 | -122.46103780069299 | (37.7754307421541, -122.461037800693) | ||
| 91137 | 91137 | 91019 | DPW Maintained 3 | Eriobotrya deflexa :: Bronze Loquat 49 | 30 Gough St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 11/17/2008 12:00:00 AM | 3 | 3x3 | 6006519.340216001 | 2109351.489576 | 37.772245729412205 | -122.420846293315 | (37.7722457294122, -122.420846293315) | ||
| 91184 | 91184 | 6737 | DPW Maintained 3 | Eriobotrya deflexa :: Bronze Loquat 49 | 1300X Fairfax Ave | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 08/30/2012 12:00:00 AM | 1 | 3x3 | 6017621.9936242 | 2096730.3826429 | 37.7382103402349 | -122.381562963191 | (37.7382103402349, -122.381562963191) | ||
| 91594 | 91594 | 26576 | DPW Maintained 3 | Eriobotrya deflexa :: Bronze Loquat 49 | 345 Bay Shore Blvd | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/05/2006 12:00:00 AM | 6 | 3X3 | 6010697.3878905 | 2098349.5702175 | 37.7422715227695 | -122.40561894910101 | (37.7422715227695, -122.405618949101) | ||
| 92537 | 92537 | 26099 | DPW Maintained 3 | Eriobotrya deflexa :: Bronze Loquat 49 | 1583 Oakdale Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/19/2000 12:00:00 AM | 6 | 3x3 | 6015122.555480001 | 2095354.2938599999 | 37.7342935630106 | -122.39010874709 | (37.7342935630106, -122.39010874709) |
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");