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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 5103 | 5103 | 253796 | Planning Code 138.1 required 4 | Eriobotrya deflexa :: Bronze Loquat 49 | 100 Scotia Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/07/2017 12:00:00 AM | 3 | Permit Number 779938 | 6011980.63004 | 2095004.60122 | 37.733158617067296 | -122.40094689916799 | (37.7331586170673, -122.400946899168) | ||
| 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 | ||||||
| 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 | ||||||
| 4475 | 4475 | 253631 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 39 Mason St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | DPW 4 | 6009957.290080001 | 2113442.89538 | 37.783672949399204 | -122.409242840109 | (37.7836729493992, -122.409242840109) | ||||
| 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) | |||||
| 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) | |
| 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) | ||
| 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) | ||
| 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) | ||||
| 3083 | 3083 | 252820 | Planning Code 138.1 required 4 | Eriobotrya deflexa :: Bronze Loquat 49 | 2339 41st Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/21/2017 12:00:00 AM | 3 | 3x3 | 5983590.30233 | 2099230.6863599997 | 37.743137766616 | -122.49941055724301 | (37.743137766616, -122.499410557243) | ||
| 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) | ||
| 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) | ||||
| 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) | ||
| 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) | ||||
| 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) | ||||
| 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) | ||||
| 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) | ||||
| 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) | ||
| 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) | ||||
| 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) | ||||
| 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) | ||
| 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) | ||
| 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) | ||
| 3997 | 3997 | 251702 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 910 Plymouth Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/05/2017 08:10:00 AM | 3 | 3x3 | 5995959.0 | 2089989.0 | 37.7184802428284 | -122.455975181765 | (37.7184802428284, -122.455975181765) | ||
| 3923 | 3923 | 251683 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 46 Lee Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/04/2017 02:00:00 PM | 3 | 3x3 | 5996555.0 | 2090205.0 | 37.7191075183288 | -122.453930658436 | (37.7191075183288, -122.453930658436) | ||
| 3948 | 3948 | 251682 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 40 Lee Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/04/2017 02:02:00 PM | 3 | 3x3 | 5996554.0 | 2090155.0 | 37.7189701727187 | -122.45393050605401 | (37.7189701727187, -122.453930506054) | ||
| 1562 | 1562 | 251589 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 339 Crescent Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/23/2017 12:00:00 AM | 3 | 3x3 | Permit Number 778123 | 6007098.02705 | 2095773.46513 | 37.7349961804395 | -122.417881894445 | (37.7349961804395, -122.417881894445) | |
| 644 | 644 | 251319 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 399X 12th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6008830.0 | 2108632.0 | 37.7704001487298 | -122.41280261366998 | (37.7704001487298, -122.41280261367) | ||||
| 541 | 541 | 251317 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 399X 12th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6008830.0 | 2108632.0 | 37.7704001487298 | -122.41280261366998 | (37.7704001487298, -122.41280261367) | ||||
| 645 | 645 | 251316 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 399X 12th St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6008830.0 | 2108632.0 | 37.7704001487298 | -122.41280261366998 | (37.7704001487298, -122.41280261367) | ||||
| 635 | 635 | 251315 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 399X 12th St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6008830.0 | 2108632.0 | 37.7704001487298 | -122.41280261366998 | (37.7704001487298, -122.41280261367) | ||||
| 38407 | 38407 | 250069 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 307 Austin St | 2 | : 4 | Tree 1 | Private 1 | 2 | Width 2ft | 6005709.21572 | 2115345.18544 | 37.7886572546664 | -122.424074905926 | (37.7886572546664, -122.424074905926) | |||
| 147235 | 147235 | 250068 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 307 Austin St | 1 | : 4 | Tree 1 | Private 1 | 2 | Width 2ft | 6005700.31875 | 2115344.38579 | 37.7886545567034 | -122.424105631271 | (37.7886545567034, -122.424105631271) | |||
| 160312 | 160312 | 248581 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 368 Frederick St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 0ft | 5998189.1274 | 2107567.4653 | 37.7668741998102 | -122.44953252918002 | (37.7668741998102, -122.44953252918) | |||
| 46387 | 46387 | 248575 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 185 Belvedere St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 0ft | 5998282.3988 | 2107687.3856 | 37.7672088058363 | -122.449218560454 | (37.7672088058363, -122.449218560454) | |||
| 2771 | 2771 | 248515 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 170 Belvedere St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/10/1979 12:00:00 AM | 14 | Width 0ft | Permit Number 17884 | 5998314.3472 | 2107764.7584 | 37.7674230792249 | -122.44911363069099 | (37.7674230792249, -122.449113630691) | |
| 27871 | 27871 | 248510 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 167 Belvedere St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 0ft | 5998265.1375 | 2107816.9964 | 37.767563696861004 | -122.449287603561 | (37.767563696861, -122.449287603561) | |||
| 148922 | 148922 | 248419 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 726 Ashbury St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 0ft | 5999075.0539 | 2108056.9885 | 37.7682689481267 | -122.446503486875 | (37.7682689481267, -122.446503486875) | |||
| 179279 | 179279 | 248256 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 116 Lundy's Ln | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6006785.81091 | 2098870.27842 | 37.743481764973005 | -122.419180937446 | (37.743481764973, -122.419180937446) | |||
| 76579 | 76579 | 248098 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 11 Brewster St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6010471.50543 | 2099820.33523 | 37.746297290485295 | -122.40650360018 | (37.7462972904853, -122.40650360018) | |||
| 150194 | 150194 | 246625 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 3300 Harrison St | 3 | Side Yard : Yard 17 | Tree 1 | Private 1 | 1 | 6009033.3388 | 2099395.8346 | 37.7450511430894 | -122.411446641942 | (37.7450511430894, -122.411446641942) | ||||
| 34552 | 34552 | 246582 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 198 Laguna St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 14 | Width 6ft | 6005203.89906 | 2109501.9724 | 37.7725846861634 | -122.425407234452 | (37.7725846861634, -122.425407234452) | |||
| 35931 | 35931 | 246581 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 184 Laguna St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | Width 6ft | 6005207.86965 | 2109476.17522 | 37.772514077680995 | -122.425391663601 | (37.772514077681, -122.425391663601) | |||
| 163964 | 163964 | 246580 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 182 Laguna St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 6 | Width 6ft | 6005210.93182 | 2109452.28431 | 37.7724486520281 | -122.425379370776 | (37.7724486520281, -122.425379370776) | |||
| 56916 | 56916 | 246579 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 140 Laguna St | 1 | : 4 | Tree 1 | Private 1 | 9 | Width 3ft | 6005220.7586 | 2109411.73941 | 37.772337880726 | -122.425342493187 | (37.772337880726, -122.425342493187) | |||
| 153130 | 153130 | 246578 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 126 Laguna St | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 13 | Width 6ft | 6005224.61763 | 2109380.5183200003 | 37.7722523731835 | -122.425326922304 | (37.7722523731835, -122.425326922304) | |||
| 46450 | 46450 | 246577 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 126 Laguna St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 13 | Width 6ft | 6005225.24464 | 2109364.93457 | 37.7722096193969 | -122.425323644264 | (37.7722096193969, -122.425323644264) | |||
| 160036 | 160036 | 246576 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 100 Laguna St | 5 | : 4 | Tree 1 | Private 1 | 11 | Width 3ft | 6005228.37861 | 2109333.02061 | 37.7721221684335 | -122.42531053216001 | (37.7721221684335, -122.42531053216) | |||
| 29324 | 29324 | 246575 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 100 Laguna St | 4 | : 4 | Tree 1 | Private 1 | 11 | Width 3ft | 6005230.8128 | 2109313.1532400004 | 37.7720677549581 | -122.425300698072 | (37.7720677549581, -122.425300698072) | |||
| 167170 | 167170 | 246574 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 100 Laguna St | 3 | : 4 | Tree 1 | Private 1 | 10 | Width 3ft | 6005235.59585 | 2109292.2935900004 | 37.7720107496197 | -122.425282668482 | (37.7720107496197, -122.425282668482) | |||
| 157957 | 157957 | 246573 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 100 Laguna St | 2 | : 4 | Tree 1 | Private 1 | 9 | Width 3ft | 6005236.998 | 2109273.038 | 37.771957957636 | -122.42527644787701 | (37.771957957636, -122.425276447877) | |||
| 44765 | 44765 | 246572 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 100 Laguna St | 1 | : 4 | Tree 1 | Private 1 | 12 | Width 3ft | 6005238.2187 | 2109262.1859999998 | 37.7719282296287 | -122.42527145302601 | (37.7719282296287, -122.425271453026) | |||
| 24000 | 24000 | 246500 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 273 Duncan St | 1 | : 4 | Tree 1 | Private 1 | 10 | Width 5ft | 6004745.35521 | 2099854.76299 | 37.746069811469 | -122.426306403626 | (37.746069811469, -122.426306403626) | |||
| 138180 | 138180 | 246490 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 399 Duncan St | 4 | : 4 | Tree 1 | Private 1 | 11 | Width 3ft | 6004063.56102 | 2099816.02709 | 37.7459248893202 | -122.428661198349 | (37.7459248893202, -122.428661198349) | |||
| 71390 | 71390 | 246489 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 399 Duncan St | 3 | : 4 | Tree 1 | Private 1 | 10 | Width 3ft | 6004042.8614 | 2099814.35756 | 37.745919133669 | -122.42873265580299 | (37.745919133669, -122.428732655803) | |||
| 50565 | 50565 | 246488 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 399 Duncan St | 2 | : 4 | Tree 1 | Private 1 | 5 | Width 3ft | 6004022.94651 | 2099813.62498 | 37.7459159950372 | -122.428801466541 | (37.7459159950372, -122.428801466541) | |||
| 161029 | 161029 | 246486 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 346 Duncan St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 7 | Width 3ft | 6004013.8028 | 2099862.02066 | 37.746048360848896 | -122.4288365338 | (37.7460483608489, -122.4288365338) | |||
| 39807 | 39807 | 246473 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 300 Duncan St | 4 | : 4 | Tree 1 | Private 1 | 9 | Width 3ft | 6004475.07524 | 2099887.00412 | 37.7461430567683 | -122.427243293056 | (37.7461430567683, -122.427243293056) | |||
| 178506 | 178506 | 246472 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 300 Duncan St | 3 | : 4 | Tree 1 | Private 1 | 9 | Width 3ft | 6004489.61116 | 2099886.70473 | 37.7461430567511 | -122.42719300834999 | (37.7461430567511, -122.42719300835) | |||
| 172748 | 172748 | 246471 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 300 Duncan St | 2 | : 4 | Tree 1 | Private 1 | 6 | Width 3ft | 6004508.79253 | 2099888.97742 | 37.7461503817506 | -122.427126843434 | (37.7461503817506, -122.427126843434) | |||
| 168133 | 168133 | 246470 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 300 Duncan St | 1 | : 4 | Tree 1 | Private 1 | 5 | Width 3ft | 6004524.4919 | 2099889.41625 | 37.7461524744566 | -122.42707258823 | (37.7461524744566, -122.42707258823) | |||
| 76430 | 76430 | 246381 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 1655 Mission St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 0ft | 6006946.7351 | 2109071.9998 | 37.771502397852394 | -122.419348063063 | (37.7715023978524, -122.419348063063) | |||
| 130791 | 130791 | 246163 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 642 Shrader St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 2 | Width 0ft | 5997583.9235 | 2108279.5679 | 37.7687948112177 | -122.451677193811 | (37.7687948112177, -122.451677193811) | |||
| 70429 | 70429 | 246160 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 654 Shrader St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 2 | Width 0ft | 5997594.3711 | 2108214.0054 | 37.7686153917025 | -122.451636326624 | (37.7686153917025, -122.451636326624) | |||
| 131168 | 131168 | 246060 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 627 Clayton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 0ft | 5998490.4423 | 2108448.6979 | 37.7693110734878 | -122.44855380708799 | (37.7693110734878, -122.448553807088) | |||
| 33588 | 33588 | 246054 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 634 Clayton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 0ft | 5998531.0214 | 2108461.1139 | 37.76934748481371 | -122.448414340817 | (37.7693474848137, -122.448414340817) | |||
| 2978 | 2978 | 246035 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 640 Ashbury St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/27/2001 12:00:00 AM | 6 | Width 0ft | Permit Number 44478 | 5999014.0338 | 2108493.5166 | 37.7694640582811 | -122.446745961985 | (37.7694640582811, -122.446745961985) | |
| 179999 | 179999 | 246031 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 632 Ashbury St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 0ft | 5999010.3999 | 2108524.1023 | 37.7695478312752 | -122.446760732499 | (37.7695478312752, -122.446760732499) | |||
| 130815 | 130815 | 245968 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 788 Clayton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 0ft | 5998638.0715 | 2107697.5304 | 37.7672569980651 | -122.447989076388 | (37.7672569980651, -122.447989076388) | |||
| 155575 | 155575 | 245940 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 798 Stanyan St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 0ft | 5997158.2972 | 2107852.8817 | 37.767598855780605 | -122.453118590527 | (37.7675988557806, -122.453118590527) | |||
| 136651 | 136651 | 245939 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 798 Stanyan St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 0ft | 5997159.5085 | 2107834.7119 | 37.76754903559 | -122.45311308902299 | (37.76754903559, -122.453113089023) | |||
| 72739 | 72739 | 245938 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 798 Stanyan St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 0ft | 5997162.5368 | 2107813.8167 | 37.767491836283895 | -122.453101106035 | (37.7674918362839, -122.453101106035) | |||
| 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) | |||
| 150096 | 150096 | 245045 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 145 Baker St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 0ft | 6000757.5634 | 2109534.6757 | 37.7724222651654 | -122.44078987699699 | (37.7724222651654, -122.440789876997) | |||
| 27771 | 27771 | 245044 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 155 Baker St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 0ft | 6000750.251 | 2109577.8851 | 37.7725404908768 | -122.440818271359 | (37.7725404908768, -122.440818271359) | |||
| 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) | |||
| 35470 | 35470 | 244884 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 1395 Page St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 0ft | 5999983.4478 | 2109160.8819999998 | 37.7713518056431 | -122.443440754039 | (37.7713518056431, -122.443440754039) | |||
| 170806 | 170806 | 244883 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 1395 Page St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 0ft | 5999962.5746 | 2109158.9845 | 37.7713454052089 | -122.443512818846 | (37.7713454052089, -122.443512818846) | |||
| 76687 | 76687 | 244882 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 1397 Page St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 0ft | 5999938.3807 | 2109154.2405 | 37.771330999572704 | -122.443596165541 | (37.7713309995727, -122.443596165541) | |||
| 153296 | 153296 | 244881 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 1397 Page St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 0ft | 5999919.405 | 2109151.3942 | 37.7713221021012 | -122.44366159862601 | (37.7713221021012, -122.443661598626) | |||
| 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) | |||
| 51498 | 51498 | 244489 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 1314 Page St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 0ft | 6000169.4163 | 2109230.0491 | 37.771552324721206 | -122.442802449862 | (37.7715523247212, -122.442802449862) | |||
| 176608 | 176608 | 244451 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 600 Page St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 0ft | 6003597.7695 | 2109704.6031 | 37.7730501849709 | -122.430977465184 | (37.7730501849709, -122.430977465184) | |||
| 27391 | 27391 | 244450 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 600 Page St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 0ft | 6003616.0838 | 2109707.0129 | 37.773057839402796 | -122.430914285765 | (37.7730578394028, -122.430914285765) | |||
| 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) | |||
| 4873 | 4873 | 243284 | Planning Code 138.1 required 4 | Eriobotrya deflexa :: Bronze Loquat 49 | 1450 15th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/31/2017 12:00:00 AM | 3 | 3x4 | Permit Number 775137 | 6007678.08789 | 2107386.86578 | 37.766916579475 | -122.416698868869 | (37.766916579475, -122.416698868869) | |
| 5159 | 5159 | 242086 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 4185 25th St | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6002948.22198 | 2101215.85126 | 37.7497052929799 | -122.432617857444 | (37.7497052929799, -122.432617857444) | |||
| 4887 | 4887 | 236267 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 98X Shotwell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/31/2017 12:00:00 AM | 3 | Width 3ft | Permit Number 775137 | 6007694.337 | 2107447.14933 | 37.76708301789029 | -122.41664693661998 | (37.7670830178903, -122.41664693662) | |
| 851 | 851 | 234149 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 3652 23rd St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 17 | Width 4ft | 6005288.48907 | 2102558.72214 | 37.753524945734 | -122.42462062893601 | (37.753524945734, -122.424620628936) | |||
| 158063 | 158063 | 224110 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 33 Gough St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 4ft | 6006506.1757 | 2109285.6019900003 | 37.7720640758221 | -122.42088715194599 | (37.7720640758221, -122.420887151946) | |||
| 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) | |||
| 154440 | 154440 | 224108 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 33 Gough St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 4ft | 6006456.73439 | 2109332.89582 | 37.7721911464267 | -122.42106153228998 | (37.7721911464267, -122.42106153229) | |||
| 29213 | 29213 | 224107 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 33 Gough St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 4ft | 6006435.98558 | 2109358.16079 | 37.7722593483308 | -122.421135098612 | (37.7722593483308, -122.421135098612) | |||
| 132964 | 132964 | 224106 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 35 Gough St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6006301.05377 | 2109500.02866 | 37.7726412760089 | -122.42161191827101 | (37.7726412760089, -122.421611918271) | |||
| 161856 | 161856 | 224105 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 35 Gough St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6006280.26739 | 2109523.46395 | 37.7727044515829 | -122.421685485523 | (37.7727044515829, -122.421685485523) | |||
| 33395 | 33395 | 224104 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 35 Gough St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6006259.41691 | 2109543.76315 | 37.772759012544704 | -122.42175905183399 | (37.7727590125447, -122.421759051834) | |||
| 67152 | 67152 | 224103 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 46 Gough St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6006296.39827 | 2109605.75372 | 37.7729313091609 | -122.42163553265301 | (37.7729313091609, -122.421635532653) |
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");