Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, SiteOrder, qSiteInfo, PlantType, qCaretaker, qCareAssistant, DBH
| Link | rowid ▲ | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 188820 | 188820 | 244490 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 1316 Page St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 0ft | 6000139.8345 | 2109225.3958 | 37.7715378614524 | -122.442904440425 | (37.7715378614524, -122.442904440425) | |||
| 188754 | 188754 | 223383 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 1 Cumberland St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 5ft | 6005540.24064 | 2104579.79946 | 37.759088567411794 | -122.423893721341 | (37.7590885674118, -122.423893721341) | |||
| 188750 | 188750 | 31037 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 722 Prague St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/13/1995 12:00:00 AM | 9 | Permit Number 34796 | 6002553.27762 | 2087290.2882 | 37.7114464558494 | -122.43298880977899 | (37.7114464558494, -122.432988809779) | |
| 188743 | 188743 | 223394 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 29 Oakwood St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 4ft | 6005256.12895 | 2105270.01288 | 37.76096768734 | -122.424925421792 | (37.76096768734, -122.424925421792) | |||
| 188615 | 188615 | 61889 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 1583 24th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/15/1985 12:00:00 AM | 10 | Permit Number 21932 | 5988683.0577 | 2104556.6784 | 37.75805900104321 | -122.48219149098301 | (37.7580590010432, -122.482191490983) | |
| 188504 | 188504 | 224036 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 1511 Castro St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6002606.663369999 | 2101060.9954 | 37.7492607194187 | -122.433787912303 | (37.7492607194187, -122.433787912303) | |||
| 188373 | 188373 | 32498 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 676 Andover St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/15/1996 12:00:00 AM | 9 | Permit Number 37003 | 6007391.76195 | 2095838.15833 | 37.73519034034379 | -122.41687092807301 | (37.7351903403438, -122.416870928073) | |
| 188247 | 188247 | 223414 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 308 Montcalm St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 3ft | 6009647.06904 | 2099615.2237400003 | 37.7456879422558 | -122.40933994229799 | (37.7456879422558, -122.409339942298) | |||
| 188244 | 188244 | 224100 | DPW Maintained 3 | Eriobotrya deflexa :: Bronze Loquat 49 | 2x Gough St | 4 | Median : Yard 3 | Tree 1 | DPW 2 | 2 | Width 10ft | 6006621.45587 | 2109260.75005 | 37.772002335561794 | -122.42048662356899 | (37.7720023355618, -122.420486623569) | |||
| 188234 | 188234 | 54841 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 241 Ashbury St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/29/2008 12:00:00 AM | 3 | 3x3 | Permit Number 50287 | 5998779.2598 | 2109863.0763 | 37.7732111059754 | -122.447656635795 | (37.7732111059754, -122.447656635795) | |
| 188172 | 188172 | 224064 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 253 Corbett Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 5999797.090969999 | 2105500.9321 | 37.761291869548 | -122.44382237682301 | (37.761291869548, -122.443822376823) | |||
| 188147 | 188147 | 123783 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 950 Cabrillo St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 5992630.21461 | 2110720.88883 | 37.7752130815921 | -122.468989250215 | (37.7752130815921, -122.468989250215) | |||
| 187829 | 187829 | 224058 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 3628 16th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6002712.47217 | 2106530.01609 | 37.7642833447214 | -122.433812870289 | (37.7642833447214, -122.433812870289) | |||
| 187788 | 187788 | 126543 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 2007 Jones St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6008144.06268 | 2119447.51141 | 37.8000583982326 | -122.415941290758 | (37.8000583982326, -122.415941290758) | |||
| 187774 | 187774 | 47461 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 1818 Baker St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/14/2002 12:00:00 AM | 6 | Permit Number 45366 | 6000024.694680001 | 2115221.2908900003 | 37.787994486693 | -122.443733540863 | (37.787994486693, -122.443733540863) | |
| 187770 | 187770 | 33945 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 2858 Gough St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/28/2002 12:00:00 AM | 8 | Permit Number 45901 | 6004794.02705 | 2119422.7642900003 | 37.799801537482296 | -122.42753193854601 | (37.7998015374823, -122.427531938546) | |
| 187744 | 187744 | 207546 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 1249 07th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 4ft | 5993899.6739 | 2106983.20983 | 37.7650236684223 | -122.46432651386002 | (37.7650236684223, -122.46432651386) | |||
| 187611 | 187611 | 51093 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 70 Waterville St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/26/2004 12:00:00 AM | 4 | Permit Number 47550 | 6011455.69814 | 2095723.6306 | 37.7351036250145 | -122.402812291464 | (37.7351036250145, -122.402812291464) | ||
| 187607 | 187607 | 223555 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 700 Andover St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6007416.45129 | 2095644.8678700002 | 37.7346609957998 | -122.416771878526 | (37.7346609957998, -122.416771878526) | |||
| 187496 | 187496 | 73575 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 1088 Sansome St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/07/1995 12:00:00 AM | 6 | 6012040.57569 | 2119341.71147 | 37.7999861916725 | -122.40245033952 | (37.7999861916725, -122.40245033952) | ||
| 187416 | 187416 | 223524 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 4120 24th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6002344.76473 | 2101815.8426099997 | 37.751318486070396 | -122.434747532969 | (37.7513184860704, -122.434747532969) | |||
| 187351 | 187351 | 207566 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 1465 09th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 5993331.08215 | 2105529.0811799997 | 37.7609982220075 | -122.466187433302 | (37.7609982220075, -122.466187433302) | |||
| 187234 | 187234 | 176259 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 2 Edinburgh St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6004478.9263 | 2093384.6524599998 | 37.728289288300296 | -122.42676699502701 | (37.7282892883003, -122.426766995027) | |||
| 187222 | 187222 | 51407 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 1554 22nd Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/14/2004 12:00:00 AM | 5 | Permit Number 47732 | 5989341.6825 | 2104766.5057 | 37.7586734173793 | -122.479929065557 | (37.7586734173793, -122.479929065557) | |
| 186921 | 186921 | 244168 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 1636 Page St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 0ft | 5998742.2377 | 2109031.524 | 37.7709257596852 | -122.447724825562 | (37.7709257596852, -122.447724825562) | |||
| 186882 | 186882 | 61980 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 3105 Octavia St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/03/1985 12:00:00 AM | 11 | Permit Number 22047 | 6004204.10885 | 2119849.9786 | 37.8009411736685 | -122.42960375979999 | (37.8009411736685, -122.4296037598) | |
| 186820 | 186820 | 191108 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 2251 24th St | 1 | : 4 | Tree 1 | Private 1 | 8 | Width 3ft | 6011748.829919999 | 2102300.63955 | 37.753179044 | -122.40226109699499 | (37.753179044, -122.402261096995) | |||
| 186789 | 186789 | 176247 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 10 Ordway St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 6011833.809309999 | 2090345.7505400002 | 37.720358182462704 | -122.401127251532 | (37.7203581824627, -122.401127251532) | |||
| 186782 | 186782 | 38856 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 1530 22nd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/02/1998 12:00:00 AM | 3 | Permit Number 40683 | 5989340.55843436 | 2104922.50162386 | 37.7591016749524 | -122.479944368724 | (37.7591016749524, -122.479944368724) | |
| 186771 | 186771 | 223597 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 306 Shotwell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 5ft | 6007773.4938900005 | 2106023.20364 | 37.7631776462561 | -122.416272279958 | (37.7631776462561, -122.416272279958) | |||
| 186763 | 186763 | 120490 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 2101 Cabrillo St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 5989039.20971 | 2110535.30773 | 37.7744953937056 | -122.481397609154 | (37.7744953937056, -122.481397609154) | |||
| 186597 | 186597 | 176268 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 273 Curtis St | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 2 | Width 6ft | 6000987.65781 | 2087139.8501 | 37.7109444570035 | -122.43838921531 | (37.7109444570035, -122.43838921531) | |||
| 186382 | 186382 | 223393 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 29 Oakwood St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 4ft | 6005258.037409999 | 2105246.6088799997 | 37.7609035332795 | -122.424917156109 | (37.7609035332795, -122.424917156109) | |||
| 186210 | 186210 | 176239 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 901 Olmstead St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6009040.83689 | 2090406.80665 | 37.7203696227506 | -122.41078599367701 | (37.7203696227506, -122.410785993677) | |||
| 186164 | 186164 | 5105 | DPW Maintained 3 | Eriobotrya deflexa :: Bronze Loquat 49 | 2638 Diamond St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 06/10/2002 12:00:00 AM | 3 | 3X3 | 6002275.8937 | 2096498.7145900002 | 37.7367149871144 | -122.43460553902399 | (37.7367149871144, -122.434605539024) | ||
| 186115 | 186115 | 224109 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 33 Gough St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 4ft | 6006481.46308 | 2109309.6411099997 | 37.7721286885111 | -122.420974342101 | (37.7721286885111, -122.420974342101) | |||
| 186102 | 186102 | 58393 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 511 Hayes St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/17/2008 12:00:00 AM | 20 | 3x3 | Permit Number 51724 | 6005404.80617926 | 2110951.74140997 | 37.7765767492195 | -122.424815434114 | (37.7765767492195, -122.424815434114) | |
| 186042 | 186042 | 72426 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 4250X Fulton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/09/1996 12:00:00 AM | 11 | 3x3 | Permit Number 773790 | 5990138.03134 | 2109951.66223 | 37.772956689267204 | -122.47755394624 | (37.7729566892672, -122.47755394624) |
| 185922 | 185922 | 223412 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 1726 Alabama St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6009299.39544 | 2099281.89074 | 37.7447531977014 | -122.410518617161 | (37.7447531977014, -122.410518617161) | |||
| 185693 | 185693 | 223509 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 3351 23rd St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 6006634.2551 | 2102596.1896900004 | 37.7537037345613 | -122.41996932812201 | (37.7537037345613, -122.419969328122) | |||
| 185608 | 185608 | 31224 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 1386 Masonic Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/04/1995 12:00:00 AM | 0 | Permit Number 42098 | 5999592.83400965 | 2107841.48506455 | 37.767706790759995 | -122.444697050343 | (37.76770679076, -122.444697050343) | ||
| 185551 | 185551 | 71394 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 1549 Kirkwood Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/21/1988 12:00:00 AM | 15 | 6015490.02353 | 2096504.2256900002 | 37.7374714167655 | -122.388918537456 | (37.7374714167655, -122.388918537456) | ||
| 185463 | 185463 | 137813 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 1804 Octavia St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 0ft | 6004855.4082 | 2115502.2955 | 37.789040396844605 | -122.42704014968001 | (37.7890403968446, -122.42704014968) | |||
| 185386 | 185386 | 207687 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 2479 18th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 5990748.39034 | 2098537.74279 | 37.7416524908805 | -122.474609488939 | (37.7416524908805, -122.474609488939) | |||
| 185264 | 185264 | 84126 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 1045 Girard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/05/2008 12:00:00 AM | 6 | 3x3 | Permit Number 50691 | 6011772.837180001 | 2090087.8836 | 37.7196467305931 | -122.401319901612 | (37.7196467305931, -122.401319901612) | |
| 185187 | 185187 | 223364 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 1451 Hampshire St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 4ft | 6010383.8577 | 2101121.66239 | 37.749865545865504 | -122.40689837915501 | (37.7498655458655, -122.406898379155) | |||
| 185115 | 185115 | 207576 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 1245 09th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 4ft | 5993280.81145 | 2107003.85945 | 37.765044675683704 | -122.46646848852899 | (37.7650446756837, -122.466468488529) | |||
| 184919 | 184919 | 32226 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 1524 Treat Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/22/1995 12:00:00 AM | 10 | Permit Number 35545 | 6008720.30382 | 2099880.58736 | 37.7463646038601 | -122.412563325657 | (37.7463646038601, -122.412563325657) | |
| 184804 | 184804 | 123735 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 398 Cabrillo St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 4ft | 5994515.7932400005 | 2110787.16748 | 37.775503828728795 | -122.46247146438401 | (37.7755038287288, -122.462471464384) | |||
| 184678 | 184678 | 223437 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 512 29th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6003198.53842 | 2098939.40251 | 37.743468888488295 | -122.431589752474 | (37.7434688884883, -122.431589752474) | |||
| 184422 | 184422 | 124533 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 951 Balboa St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 5992637.1881099995 | 2111348.1817799998 | 37.776935861412795 | -122.469010789113 | (37.7769358614128, -122.469010789113) | |||
| 184408 | 184408 | 101123 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 1500 Clement St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | 3x3 | 5990813.05778 | 2113422.53635 | 37.78252590291729 | -122.475472443708 | (37.7825259029173, -122.475472443708) | |||
| 184372 | 184372 | 123727 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 598 Cabrillo St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 5993898.69651 | 2110767.5362400003 | 37.775414370970395 | -122.46460470717 | (37.7754143709704, -122.46460470717) | |||
| 184298 | 184298 | 64968 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 1674 Filbert St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/03/1989 12:00:00 AM | 1 | Permit Number 26003 | 6004952.75334 | 2119199.4547099997 | 37.799197363023794 | -122.426966773099 | (37.7991973630238, -122.426966773099) | |
| 184233 | 184233 | 223598 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 304 Shotwell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 5ft | 6007773.137630001 | 2106049.50965 | 37.763249856425396 | -122.41627537542 | (37.7632498564254, -122.41627537542) | |||
| 184164 | 184164 | 72399 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 794-798 19th Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/27/2013 12:00:00 AM | 3 | 3x3 | Permit Number 769948 | 5990094.17599 | 2109997.0392299998 | 37.7730787370976 | -122.477708963104 | (37.7730787370976, -122.477708963104) |
| 184138 | 184138 | 223486 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 361 Elsie St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 4ft | 6006465.939069999 | 2097117.1466700002 | 37.7386500385602 | -122.420162581636 | (37.7386500385602, -122.420162581636) | |||
| 184033 | 184033 | 224099 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 33 Harper St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 5ft | 6003688.866090001 | 2098162.22587 | 37.7413627203269 | -122.42983890015101 | (37.7413627203269, -122.429838900151) | |||
| 184002 | 184002 | 223444 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 319 28th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 4ft | 6003651.97677 | 2099506.05827 | 37.7450504848013 | -122.430062291736 | (37.7450504848013, -122.430062291736) | |||
| 183991 | 183991 | 207532 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 1638 17th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 2ft | 5990908.40478 | 2104231.6006400003 | 37.757295609713005 | -122.474471644475 | (37.757295609713, -122.474471644475) | |||
| 183925 | 183925 | 191091 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 150 Wisconsin St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 6012554.29768 | 2106630.7365599996 | 37.765113465742395 | -122.399779633617 | (37.7651134657424, -122.399779633617) | |||
| 183877 | 183877 | 223654 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 360 Bosworth St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6003584.62935 | 2095264.4412 | 37.733400161580704 | -122.42999265365299 | (37.7334001615807, -122.429992653653) | |||
| 183826 | 183826 | 223480 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 630 Moultrie St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6007639.21465 | 2096394.9634599998 | 37.7367331210324 | -122.41605481128599 | (37.7367331210324, -122.416054811286) | |||
| 183787 | 183787 | 191666 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 535 Brannan St | 13 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 2ft | 6013244.57038 | 2111045.61556 | 37.777274188396795 | -122.397701819284 | (37.7772741883968, -122.397701819284) | |||
| 183783 | 183783 | 137622 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 2055 TURK BLVD | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 0ft | 6000170.6646 | 2111954.7813 | 37.779033818769896 | -122.442993839351 | (37.7790338187699, -122.442993839351) | |||
| 183545 | 183545 | 223548 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 854 Ashbury St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 4ft | 5999175.87751 | 2107341.63153 | 37.766310516447504 | -122.44610328774901 | (37.7663105164475, -122.446103287749) | |||
| 183474 | 183474 | 207701 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 86 San Jacinto Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 5993894.771819999 | 2095194.29652 | 37.7326540264533 | -122.46348786009199 | (37.7326540264533, -122.463487860092) | |||
| 183373 | 183373 | 38109 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 1243 29th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/13/1998 12:00:00 AM | 4 | Permit Number 40277 | 5987050.95818325 | 2106810.63919781 | 37.7641526918478 | -122.488001527428 | (37.7641526918478, -122.488001527428) | |
| 183175 | 183175 | 54136 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 2443 Vallejo St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/22/1972 12:00:00 AM | 15 | Permit Number 9869 | 6001890.1565 | 2117687.62066 | 37.7948726132212 | -122.437456069748 | (37.7948726132212, -122.437456069748) | ||
| 183168 | 183168 | 207597 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 484 Faxon Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 4ft | 5994785.91009 | 2091770.6841799999 | 37.7233049208652 | -122.46015905009399 | (37.7233049208652, -122.460159050094) | |||
| 183046 | 183046 | 43598 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 2320 31st Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/20/2000 12:00:00 AM | 3 | Permit Number 43256 | 5986732.527000001 | 2099427.1676 | 37.743861106273606 | -122.48856016571301 | (37.7438611062736, -122.488560165713) | |
| 182894 | 182894 | 245937 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 798 Stanyan St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 0ft | 5997164.9595 | 2107795.0413 | 37.7674404226959 | -122.453091370784 | (37.7674404226959, -122.453091370784) | |||
| 182831 | 182831 | 223448 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 1209 Stanyan St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 5997400.9085 | 2105772.15119 | 37.7618996008164 | -122.452129287752 | (37.7618996008164, -122.452129287752) | |||
| 182754 | 182754 | 223635 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 3351 Bartlett St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 3ft | 6006712.94406 | 2102318.00043 | 37.752944323627204 | -122.41967746664 | (37.7529443236272, -122.41967746664) | |||
| 182751 | 182751 | 223539 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 1661 Noe St | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 8 | Width 4ft | 6003387.19904 | 2098534.7214900004 | 37.742368419572294 | -122.43090853672301 | (37.7423684195723, -122.430908536723) | |||
| 182554 | 182554 | 126550 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 953 Sansome St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6012056.66231 | 2118852.08433 | 37.79864269176171 | -122.402360227452 | (37.7986426917617, -122.402360227452) | |||
| 182527 | 182527 | 176255 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 781 Cayuga Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 2ft | 6001324.49693 | 2092468.5490400002 | 37.7255950237874 | -122.437606390539 | (37.7255950237874, -122.437606390539) | |||
| 182187 | 182187 | 42137 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 491 15th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/21/2000 12:00:00 AM | 4 | Permit Number 42432 | 5991232.2676099995 | 2112071.30225 | 37.7788400781617 | -122.47392356042 | (37.7788400781617, -122.47392356042) | |
| 182041 | 182041 | 223573 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 800 Crescent Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6008156.49487 | 2095642.89016 | 37.7346971620413 | -122.414213149027 | (37.7346971620413, -122.414213149027) | |||
| 182033 | 182033 | 244888 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 158 Central Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 0ft | 5999901.22 | 2109095.6532 | 37.771168014196704 | -122.44372049599899 | (37.7711680141967, -122.443720495999) | |||
| 181972 | 181972 | 224050 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 3864 21st St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 6002642.02171 | 2103582.88147 | 37.7561872258806 | -122.433845873598 | (37.7561872258806, -122.433845873598) | |||
| 181924 | 181924 | 223471 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 956 Clayton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 20 | Width 3ft | 5998814.740180001 | 2106663.16945 | 37.764427000625 | -122.447303552626 | (37.764427000625, -122.447303552626) | |||
| 181830 | 181830 | 207662 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 1203 Willard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 5996707.43605 | 2107271.27987 | 37.7659760765509 | -122.45463603013799 | (37.7659760765509, -122.454636030138) | |||
| 181783 | 181783 | 124029 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 101 Funston Ave | 4 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 14 | Width 3ft | 5991795.62331 | 2114277.55052 | 37.7849304438848 | -122.47213556804701 | (37.7849304438848, -122.472135568047) | |||
| 181772 | 181772 | 99645 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 1795 34th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | 3x3 | Permit Number 768958 | 5985624.4813 | 2103086.5856 | 37.7538441541808 | -122.49266093445699 | (37.7538441541808, -122.492660934457) | ||
| 181659 | 181659 | 207634 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 1377 05th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 4ft | 5994548.5579699995 | 2106167.4368 | 37.762821148712504 | -122.46202303893499 | (37.7628211487125, -122.462023038935) | |||
| 181503 | 181503 | 224068 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 4411 17th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 5999966.77675 | 2105730.1132900002 | 37.761930821663206 | -122.443251968323 | (37.7619308216632, -122.443251968323) | |||
| 181330 | 181330 | 31671 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 1435 Larkin St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/08/2003 12:00:00 AM | 11 | Permit Number 35179 | 6007129.43317 | 2116257.26195 | 37.79124167420971 | -122.419225877479 | (37.7912416742097, -122.419225877479) | |
| 181272 | 181272 | 207690 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 642 Taraval St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 5991148.86446 | 2099110.57767 | 37.743248544694204 | -122.473266566413 | (37.7432485446942, -122.473266566413) | |||
| 181202 | 181202 | 200709 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 1399 Lane St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 0ft | 6015661.7831 | 2095130.2658 | 37.7337083198644 | -122.388228817428 | (37.7337083198644, -122.388228817428) | |||
| 180731 | 180731 | 223567 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 500 Crescent Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6007671.39008 | 2095684.7494400002 | 37.7347848378312 | -122.41589328943701 | (37.7347848378312, -122.415893289437) | |||
| 180710 | 180710 | 223475 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 259 Crescent Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6006730.85862 | 2095808.36248 | 37.735071330371106 | -122.419153803122 | (37.7350713303711, -122.419153803122) | |||
| 180698 | 180698 | 126554 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 1005 Sansome St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 4ft | 6011981.00581 | 2119393.57508 | 37.8001252709281 | -122.402660124387 | (37.8001252709281, -122.402660124387) | |||
| 180689 | 180689 | 223585 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 490 Tompkins Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 4ft | 6007537.470430001 | 2096557.5689 | 37.7371738787611 | -122.41641810052099 | (37.7371738787611, -122.416418100521) | |||
| 180664 | 180664 | 176227 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 883 Madrid St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6001457.22396 | 2089001.6852400003 | 37.7160833414588 | -122.436899487435 | (37.7160833414588, -122.436899487435) | |||
| 180532 | 180532 | 223599 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 300 Shotwell St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 5ft | 6007767.1377 | 2106084.40018 | 37.763345320342495 | -122.41629859860501 | (37.7633453203425, -122.416298598605) | |||
| 180348 | 180348 | 223500 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 269 Bartlett St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6006752.007069999 | 2102225.6927799997 | 37.7526930683357 | -122.419535830631 | (37.7526930683357, -122.419535830631) | |||
| 180197 | 180197 | 43031 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 2121 26th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/06/2000 12:00:00 AM | 5 | Permit Number 42892 | 6012197.347 | 2101360.5481 | 37.75062278311479 | -122.400643990055 | (37.7506227831148, -122.400643990055) | ||
| 180123 | 180123 | 223533 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 53 Newburg St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 9 | Width 10ft | 6002432.22452 | 2099844.0691299997 | 37.7459094263876 | -122.43430413393601 | (37.7459094263876, -122.434304133936) | |||
| 180062 | 180062 | 223531 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 650 29th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 19 | Width 3ft | 6002360.62699 | 2098888.4177 | 37.743281367239796 | -122.434483391309 | (37.7432813672398, -122.434483391309) |
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");