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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 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 | ||||||
| 4889 | 4889 | 253706 | Planning Code 138.1 required 4 | Eriobotrya deflexa :: Bronze Loquat 49 | 98X Shotwell St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/31/2017 12:00:00 AM | 3 | 3x4 | Permit Number 775137 | ||||||
| 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 | |||||||||
| 13904 | 13904 | 47479 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/14/2002 12:00:00 AM | Permit Number 45375 | |||||||||
| 4209 | 4209 | 180663 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 355 Chicago Way | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 10/10/2017 01:48:00 PM | 3 | Width 6ft | 6002383.84355 | 2086445.14687 | 37.709116270155604 | -122.43351405884898 | (37.7091162701556, -122.433514058849) | ||
| 3065 | 3065 | 175836 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 101 Rhine St | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | Width 3ft | 5994366.585519999 | 2086543.72285 | 37.70892880020671 | -122.46122985488998 | (37.7089288002067, -122.46122985489) | |||
| 1840 | 1840 | 251759 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 248 Winding Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6001757.0 | 2086582.0 | 37.709456453529796 | -122.43569030601002 | (37.7094564535298, -122.43569030601) | ||||
| 3929 | 3929 | 251760 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 242 Winding Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/04/2017 10:24:00 AM | 3 | 3x3 | 6001791.0 | 2086587.0 | 37.709472113614396 | -122.43557315397499 | (37.7094721136144, -122.435573153975) | ||
| 1849 | 1849 | 251761 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 236 Winding Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6001827.0 | 2086593.0 | 37.709490632951706 | -122.43544916105199 | (37.7094906329517, -122.435449161052) | ||||
| 3406 | 3406 | 172261 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 230 Winding Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 3ft | 6001860.0 | 2086600.0 | 37.7095117275676 | -122.435335608043 | (37.7095117275676, -122.435335608043) | |||
| 4195 | 4195 | 181063 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 280 Guttenberg St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/10/2017 04:21:00 PM | 3 | Width 3ft | 5999687.90058 | 2086653.1482400002 | 37.7095340664096 | -122.44284654223999 | (37.7095340664096, -122.44284654224) | ||
| 10539 | 10539 | 97421 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 84 Liebig St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/02/2011 12:00:00 AM | 3 | 6x15 | Permit Number 768371 | 5995500.38132 | 2086681.7504200002 | 37.709372977163504 | -122.457321298761 | (37.7093729771635, -122.457321298761) | |
| 4389 | 4389 | 177791 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 400 Cordova St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/11/2017 11:44:00 AM | 3 | Width 8ft | 6001956.24423 | 2086810.19432 | 37.710094340458 | -122.435017995105 | (37.710094340458, -122.435017995105) | ||
| 4071 | 4071 | 251734 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 856 Prague St | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 10/05/2017 08:08:00 AM | 3 | Width 6ft | 6002039.2106099995 | 2086908.72872 | 37.7103696049432 | -122.434738288839 | (37.7103696049432, -122.434738288839) | ||
| 3953 | 3953 | 44431 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 859 Prague St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/04/2017 11:19:00 AM | 3 | Permit Number 43768 | 6002228.37284 | 2086951.06128 | 37.71049657842789 | -122.434087529513 | (37.7104965784279, -122.434087529513) | |
| 1827 | 1827 | 251744 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 70 Winding Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6002620.0 | 2086992.0 | 37.710631205907 | -122.43273690550899 | (37.710631205907, -122.432736905509) | ||||
| 3991 | 3991 | 44420 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 859 Prague St | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/05/2017 08:03:00 AM | 3 | Permit Number 43768 | 6002331.23577 | 2087017.31055 | 37.710684321803896 | -122.433736745364 | (37.7106843218039, -122.433736745364) | |
| 4059 | 4059 | 251733 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 824 Prague St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/05/2017 08:24:00 AM | 3 | Width 6ft | 6002320.95082 | 2087061.4224099999 | 37.7108048597154 | -122.43377544319401 | (37.7108048597154, -122.433775443194) | ||
| 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) | ||
| 4108 | 4108 | 180634 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 824 Prague St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/05/2017 08:16:00 AM | 3 | Width 6ft | 6002320.95082 | 2087061.4224099999 | 37.7108048597154 | -122.43377544319401 | (37.7108048597154, -122.433775443194) | ||
| 171876 | 171876 | 176267 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 273 Curtis St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 1 | Width 6ft | 6000986.70381 | 2087103.4067099998 | 37.710844337262294 | -122.43838990328899 | (37.7108443372623, -122.438389903289) | |||
| 3993 | 3993 | 180622 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 771 Prague St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/05/2017 10:19:00 AM | 3 | Width 6ft | 6002476.28052 | 2087135.9896900002 | 37.7110184181363 | -122.433243913293 | (37.7110184181363, -122.433243913293) | ||
| 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) | |||
| 4114 | 4114 | 180623 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 755 Prague St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/05/2017 10:23:00 AM | 3 | Width 6ft | 6002495.21129 | 2087156.5558200001 | 37.711075962150204 | -122.43317995261499 | (37.7110759621502, -122.433179952615) | ||
| 27081 | 27081 | 176269 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 273 Curtis St | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 2 | Width 6ft | 6000993.66237 | 2087160.73145 | 37.711002134104795 | -122.43836995721901 | (37.7110021341048, -122.438369957219) | |||
| 3996 | 3996 | 251731 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 749 Prague St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/05/2017 10:28:00 AM | 3 | 3x3 | 6002542.0 | 2087174.0 | 37.7111265141547 | -122.433019485161 | (37.7111265141547, -122.433019485161) | ||
| 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) | |||
| 3437 | 3437 | 180625 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 18 Winding Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 6ft | 6002816.84046 | 2087215.85653 | 37.711257028952495 | -122.432072557104 | (37.7112570289525, -122.432072557104) | |||
| 4207 | 4207 | 251781 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 1237 Naples St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/10/2017 09:14:00 AM | 3 | 3x3 | 6001070.0 | 2087245.0 | 37.711237858655295 | -122.438112149268 | (37.7112378586553, -122.438112149268) | ||
| 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) | |
| 1861 | 1861 | 251780 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 1219 Naples St | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6001110.0 | 2087312.0 | 37.7114241006266 | -122.437978695611 | (37.7114241006266, -122.437978695611) | ||||
| 3988 | 3988 | 159293 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 486 Ellington Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/05/2017 11:16:00 AM | 3 | Width 0ft | 5998231.36405 | 2087340.7209 | 37.711338838486206 | -122.44793002935499 | (37.7113388384862, -122.447930029355) | ||
| 4210 | 4210 | 251779 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 1207 Naples St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/10/2017 09:23:00 AM | 3 | 3x3 | 6001136.0 | 2087356.0 | 37.7115463934242 | -122.437891982586 | (37.7115463934242, -122.437891982586) | ||
| 4020 | 4020 | 159292 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 482 Ellington Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/05/2017 11:20:00 AM | 3 | Width 0ft | 5998250.20897 | 2087358.72103 | 37.7113893399111 | -122.447866191868 | (37.7113893399111, -122.447866191868) | ||
| 4017 | 4017 | 159290 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 476 Ellington Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/05/2017 12:01:00 PM | 3 | Width 0ft | 5998270.831130001 | 2087378.17542 | 37.71144393594879 | -122.447796316346 | (37.7114439359488, -122.447796316346) | ||
| 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) | ||
| 4218 | 4218 | 181054 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 120 Brunswick St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/10/2017 09:03:00 AM | 3 | Width 2ft | 6000669.11916 | 2087419.81595 | 37.711695057256605 | -122.439510213951 | (37.7116950572566, -122.439510213951) | ||
| 4183 | 4183 | 180766 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 1206 Naples St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 10/10/2017 09:29:00 AM | 3 | Width 8ft | 6001093.57723 | 2087421.33847 | 37.7117233858917 | -122.438043283865 | (37.7117233858917, -122.438043283865) | ||
| 74059 | 74059 | 31015 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 1200 Naples St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/13/1995 12:00:00 AM | 9 | Permit Number 34784 | 6001104.8718 | 2087440.4366099997 | 37.7117764674692 | -122.438005613962 | (37.7117764674692, -122.438005613962) | ||
| 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) | ||||
| 1874 | 1874 | 251773 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 90x Seville St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6002045.0 | 2087474.0 | 37.7119220445534 | -122.434758675533 | (37.7119220445534, -122.434758675533) | ||||
| 2516 | 2516 | 251771 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 90x Seville St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6002045.0 | 2087474.0 | 37.7119220445534 | -122.434758675533 | (37.7119220445534, -122.434758675533) | ||||
| 68683 | 68683 | 176235 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 19 Brunswick St | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 6 | Width 5ft | 6001042.78255 | 2087493.5862099999 | 37.711918873330205 | -122.43822401612499 | (37.7119188733302, -122.438224016125) | |||
| 129925 | 129925 | 176236 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 19 Brunswick St | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 6 | Width 5ft | 6001058.00654 | 2087498.50838 | 37.711933254377 | -122.438171750223 | (37.711933254377, -122.438171750223) | |||
| 113714 | 113714 | 31017 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 1200 Naples St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/13/1995 12:00:00 AM | Permit Number 34784 | 6001138.87641909 | 2087503.16195668 | 37.711950631123294 | -122.43789257478399 | (37.7119506311233, -122.437892574784) | |||
| 139860 | 139860 | 31016 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 1200 Naples St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/13/1995 12:00:00 AM | Permit Number 34784 | 6001138.87641909 | 2087503.16195668 | 37.711950631123294 | -122.43789257478399 | (37.7119506311233, -122.437892574784) | |||
| 3901 | 3901 | 253246 | Planning Code 138.1 required 4 | Eriobotrya deflexa :: Bronze Loquat 49 | 1192 Naples St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/09/2017 12:00:00 AM | 3 | 4x4 | Permit Number 780462 | 6001173.0 | 2087586.0 | 37.7121800264355 | -122.437780563503 | (37.7121800264355, -122.437780563503) | |
| 76101 | 76101 | 207607 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 241 Sadowa St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 5994570.6284300005 | 2087741.5143099998 | 37.71222939484579 | -122.460611398307 | (37.7122293948458, -122.460611398307) | |||
| 4253 | 4253 | 216859 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 249 Sadowa St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/10/2017 08:28:00 AM | 3 | Width 3ft | 5994500.65492 | 2087744.1970099998 | 37.712232734922104 | -122.46085344003299 | (37.7122327349221, -122.460853440033) | ||
| 3890 | 3890 | 161753 | Planning Code 138.1 required 4 | Eriobotrya deflexa :: Bronze Loquat 49 | 175x Newton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/09/2017 12:00:00 AM | 3 | 4x4 | Permit Number 780462 | 6001022.0 | 2087749.0 | 37.7126190008501 | -122.43831413288 | (37.7126190008501, -122.43831413288) | |
| 4293 | 4293 | 216862 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 272 Sadowa St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 10/10/2017 08:43:00 AM | 3 | Width 3ft | 5994260.82584 | 2087785.69998 | 37.7123328897311 | -122.461685361516 | (37.7123328897311, -122.461685361516) | ||
| 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) | ||
| 134321 | 134321 | 176238 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 2018 Bay Shore Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 2ft | 6012153.04029 | 2088061.68652 | 37.7141044057814 | -122.399863463036 | (37.7141044057814, -122.399863463036) | |||
| 68381 | 68381 | 176237 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 2014 Bay Shore Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 2ft | 6012237.04254 | 2088170.85532 | 37.7144088442801 | -122.39958077733401 | (37.7144088442801, -122.399580777334) | |||
| 10622 | 10622 | 15860 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 5366 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3x3 | 5999545.5765 | 2088270.5652 | 37.7139670145471 | -122.44345454060199 | (37.7139670145471, -122.443454540602) | |||
| 77926 | 77926 | 67015 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 379 Capitol Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/20/1992 12:00:00 AM | Permit Number 30370 | 5995013.54183778 | 2088325.60684353 | 37.7138586475181 | -122.459122836548 | (37.7138586475181, -122.459122836548) | ||
| 4315 | 4315 | 216902 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 174 Bright St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 10/11/2017 11:02:00 AM | 3 | Width 3ft | 5993764.72474 | 2088364.55203 | 37.7138937098892 | -122.46344200363899 | (37.7138937098892, -122.463442003639) | ||
| 109483 | 109483 | 1769 | DPW Maintained 3 | Eriobotrya deflexa :: Bronze Loquat 49 | 2000X Bay Shore Blvd | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 06/11/2011 12:00:00 AM | 3 | 3x3 | 6012375.8565272 | 2088505.2474916999 | 37.7153347551878 | -122.399124435859 | (37.7153347551878, -122.399124435859) | ||
| 117970 | 117970 | 96201 | DPW Maintained 3 | Eriobotrya deflexa :: Bronze Loquat 49 | 2000X Bay Shore Blvd | 13 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 06/11/2011 12:00:00 AM | 3 | 3x3 | 6012318.2 | 2088514.6 | 37.715357222040005 | -122.399324379639 | (37.71535722204, -122.399324379639) | ||
| 163670 | 163670 | 176226 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 915 Vienna St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 2ft | 6002121.3261 | 2088534.6306099999 | 37.7148386356627 | -122.43457066150499 | (37.7148386356627, -122.434570661505) | |||
| 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) | ||||
| 2035 | 2035 | 252855 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 926 Edinburgh St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6001578.0 | 2088750.0 | 37.7153991335272 | -122.43646402536001 | (37.7153991335272, -122.43646402536) | ||||
| 128266 | 128266 | 91088 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 132 Ralston St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/31/2008 12:00:00 AM | 3x3 | Permit Number 51983 | 5992207.0 | 2088751.0 | 37.7148649307688 | -122.468854138233 | (37.7148649307688, -122.468854138233) | ||
| 159047 | 159047 | 176234 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 46 Rolph St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6000330.77387 | 2088762.22962 | 37.71536176231729 | -122.44077585683998 | (37.7153617623173, -122.44077585684) | |||
| 66740 | 66740 | 91087 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 134 Ralston St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/31/2008 12:00:00 AM | 3x3 | Permit Number 51982 | 5992207.0 | 2088764.0 | 37.7149006256244 | -122.46885508368 | (37.7149006256244, -122.46885508368) | |||
| 10856 | 10856 | 108684 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 46 Rolph St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/31/2014 12:00:00 AM | 3 | Permit Number 774614 | 6000319.87619 | 2088768.81693 | 37.71537922895679 | -122.44081399618601 | (37.7153792289568, -122.440813996186) | |
| 47949 | 47949 | 207615 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 134 Ralston St | 1 | : 4 | Tree 1 | Private 1 | 4 | Width 3ft | 5992209.13787 | 2088815.67824 | 37.7150426450832 | -122.46885145275 | (37.7150426450832, -122.46885145275) | |||
| 48099 | 48099 | 207613 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 171 Caine Ave | 1 | : 4 | Tree 1 | Private 1 | 4 | Width 3ft | 5997069.50028 | 2088848.5087700002 | 37.7154123950516 | -122.45205442099 | (37.7154123950516, -122.45205442099) | |||
| 91081 | 91081 | 52641 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 171@ LAKEVIEW Caine Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/09/2006 12:00:00 AM | Permit Number 48723 | 5997085.87939987 | 2088850.31270085 | 37.715418286429895 | -122.451997937847 | (37.7154182864299, -122.451997937847) | |||
| 102547 | 102547 | 112688 | Section 143 8 | Eriobotrya deflexa :: Bronze Loquat 49 | 259 BRIGHT ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/18/2015 12:00:00 AM | 3 | 5x4 | 5993720.0 | 2088919.0 | 37.71541351482001 | -122.46363680360001 | (37.71541351482, -122.4636368036) | ||
| 40355 | 40355 | 207621 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 259 Bright St | 1 | : 4 | Tree 1 | Private 1 | 1 | Width 3ft | 5993736.2843 | 2088924.46634 | 37.7154294623887 | -122.463580914754 | (37.7154294623887, -122.463580914754) | |||
| 91147 | 91147 | 88310 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 401 Amazon Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/10/2008 12:00:00 AM | 3x3 | Permit Number 51301 | 6001480.2 | 2088981.7 | 37.7160297722944 | -122.436818641634 | (37.7160297722944, -122.436818641634) | ||
| 91442 | 91442 | 88308 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 401 Amazon Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/10/2008 12:00:00 AM | 3x3 | Permit Number 51301 | 6001480.2 | 2088981.7 | 37.7160297722944 | -122.436818641634 | (37.7160297722944, -122.436818641634) | ||
| 99152 | 99152 | 88309 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 401 Amazon Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/10/2008 12:00:00 AM | 3x3 | Permit Number 51301 | 6001480.2 | 2088981.7 | 37.7160297722944 | -122.436818641634 | (37.7160297722944, -122.436818641634) | ||
| 126451 | 126451 | 88307 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 401 Amazon Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/10/2008 12:00:00 AM | 3x3 | Permit Number 51301 | 6001480.2 | 2088981.7 | 37.7160297722944 | -122.436818641634 | (37.7160297722944, -122.436818641634) | ||
| 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) | |||
| 161612 | 161612 | 176228 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 883 Madrid St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6001469.88954 | 2089023.1179400003 | 37.7161429107373 | -122.43685724267901 | (37.7161429107373, -122.436857242679) | |||
| 48530 | 48530 | 176229 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 883 Madrid St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6001482.8368 | 2089045.33875 | 37.7162046599834 | -122.43681408062 | (37.7162046599834, -122.43681408062) | |||
| 158823 | 158823 | 207612 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 157 Majestic Ave | 1 | : 4 | Tree 1 | Private 1 | 7 | Width 3ft | 5996901.64922 | 2089066.51215 | 37.7160013655568 | -122.452650309965 | (37.7160013655568, -122.452650309965) | |||
| 175048 | 175048 | 176230 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 883 Madrid St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6001498.44538 | 2089067.7688 | 37.7162671349894 | -122.436761734667 | (37.7162671349894, -122.436761734667) | |||
| 121739 | 121739 | 28261 | DPW Maintained 3 | Eriobotrya deflexa :: Bronze Loquat 49 | 3574 San Bruno Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 06/22/2011 12:00:00 AM | 3 | 3x3 | 6012138.719425799 | 2089093.5243211002 | 37.7169368272436 | -122.399985378545 | (37.7169368272436, -122.399985378545) | ||
| 109954 | 109954 | 60469 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 157 Majestic Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/24/1982 12:00:00 AM | Permit Number 20062 | 5996935.23090665 | 2089095.72294646 | 37.716083495746204 | -122.452536343277 | (37.7160834957462, -122.452536343277) | ||
| 4635 | 4635 | 160567 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 790 Naples St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/18/2017 11:57:00 AM | 3 | Width 0ft | 6002104.08605 | 2089098.7371 | 37.716386568565 | -122.43467056358999 | (37.716386568565, -122.43467056359) | |
| 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) | |||
| 94962 | 94962 | 51679 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 126 Majestic Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/13/2005 12:00:00 AM | Permit Number 47959 | 5997000.93217055 | 2089281.06298021 | 37.716596160573104 | -122.45232261590401 | (37.7165961605731, -122.452322615904) | ||
| 111428 | 111428 | 53552 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 124 Majestic Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/24/1982 12:00:00 AM | Permit Number 20052 | 5997008.15708783 | 2089291.43789618 | 37.7166250615868 | -122.452298391323 | (37.7166250615868, -122.452298391323) | ||
| 4654 | 4654 | 160563 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 750 Naples St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/18/2017 01:34:00 PM | 3 | Width 0ft | 6002231.24921 | 2089300.0903 | 37.7169466582377 | -122.434245412715 | (37.7169466582377, -122.434245412715) | |
| 71398 | 71398 | 176251 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 25 Ervine St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 2ft | 6009692.49199 | 2089304.87658 | 37.717380467816 | -122.408455736945 | (37.717380467816, -122.408455736945) | |||
| 4662 | 4662 | 50502 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 744 Naples St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/18/2017 01:37:00 PM | 3 | 3x3 | Permit Number 767517 | 6002255.61475 | 2089339.38797 | 37.7170559438579 | -122.434164000676 | (37.7170559438579, -122.434164000676) |
| 147928 | 147928 | 176249 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 3502 San Bruno Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6012088.82637 | 2089370.3173 | 37.717694063212704 | -122.400177264384 | (37.7176940632127, -122.400177264384) | |||
| 99558 | 99558 | 28257 | DPW Maintained 3 | Eriobotrya deflexa :: Bronze Loquat 49 | 3508X San Bruno Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/08/2014 12:00:00 AM | 3 | 3x3 | 6012088.3375369 | 2089388.4108582002 | 37.717743717221396 | -122.400180224111 | (37.7177437172214, -122.400180224111) | ||
| 115446 | 115446 | 87531 | DPW Maintained 3 | Eriobotrya deflexa :: Bronze Loquat 49 | 3508X San Bruno Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/08/2014 12:00:00 AM | 3 | 3x3 | 6012093.266153 | 2089389.252949 | 37.717746304247605 | -122.400163247094 | (37.7177463042476, -122.400163247094) | ||
| 147800 | 147800 | 176248 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 3500 San Bruno Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6012084.62968 | 2089393.6592 | 37.717757921362704 | -122.40019340899099 | (37.7177579213627, -122.400193408991) | |||
| 4653 | 4653 | 160561 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 730 Naples St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/18/2017 01:42:00 PM | 3 | Width 0ft | 6002306.04947 | 2089419.84324 | 37.7172797185636 | -122.43399542008001 | (37.7172797185636, -122.43399542008) | |
| 19278 | 19278 | 39942 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 27 Ervine St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/25/1999 12:00:00 AM | Permit Number 41213 | 6009741.23684285 | 2089425.45829631 | 37.7177142900305 | -122.408295747981 | (37.7177142900305, -122.408295747981) | ||
| 78633 | 78633 | 66232 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 218 Lakeview Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/24/1990 12:00:00 AM | 12 | Permit Number 29329 | 5997099.27039938 | 2089468.87131755 | 37.7171174718407 | -122.451996253737 | (37.7171174718407, -122.451996253737) | |
| 4648 | 4648 | 160560 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 718 Naples St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/18/2017 01:51:00 PM | 3 | Width 0ft | 6002343.44923 | 2089479.7194599998 | 37.7174462478135 | -122.43387042418301 | (37.7174462478135, -122.433870424183) | |
| 179313 | 179313 | 207614 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 218 Lakeview Ave | 1 | : 4 | Tree 1 | Private 1 | 8 | Width 3ft | 5997036.49742 | 2089508.9624599998 | 37.7172239569865 | -122.452216120002 | (37.7172239569865, -122.452216120002) | |||
| 10698 | 10698 | 117442 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 683 Vienna St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/14/2016 12:00:00 AM | 3 | Permit Number 778575 | 6002740.92134 | 2089524.8599 | 37.7175927411032 | -122.432499770158 | (37.7175927411032, -122.432499770158) |
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");