Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, SiteOrder, qSiteInfo, qCaretaker, PlotSize
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord ▲ | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 175898 | 175898 | 199982 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 1081 Quesada Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 0ft | 6018036.5838 | 2092513.2332 | 37.7266537566215 | -122.379836574534 | (37.7266537566215, -122.379836574534) | |||
| 74755 | 74755 | 199769 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 1197 Thomas Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 0ft | 6016909.41 | 2092306.5247 | 37.726023933628895 | -122.383718829233 | (37.7260239336289, -122.383718829233) | |||
| 74499 | 74499 | 199975 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 1233 Shafter Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 0ft | 6016858.7319 | 2092693.7716 | 37.7270844364031 | -122.38392097441299 | (37.7270844364031, -122.383920974413) | |||
| 16688 | 16688 | 97242 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 1300X Keith St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 3x3 | 6016235.0824 | 2094868.9009 | 37.7330224130953 | -122.386228519291 | (37.7330224130953, -122.386228519291) | |||
| 13740 | 13740 | 97243 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 1300X Keith St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 3x3 | 6016226.9194 | 2094855.7145 | 37.7329857540551 | -122.38625582218701 | (37.7329857540551, -122.386255822187) | |||
| 15892 | 15892 | 97244 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 1300X Keith St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 3x3 | 6016216.2447 | 2094842.5281 | 37.7329489559822 | -122.38629180873501 | (37.7329489559822, -122.386291808735) | |||
| 176490 | 176490 | 38608 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 1570 Revere Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/09/2003 12:00:00 AM | 6 | Permit Number 45423 | 6015284.7491 | 2094285.2369 | 37.7313671428977 | -122.38947335260099 | (37.7313671428977, -122.389473352601) | |
| 61042 | 61042 | 38609 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 1570 Revere Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/15/2002 12:00:00 AM | 6 | Permit Number 45423 | 6015273.2073 | 2094293.4811 | 37.7313891398709 | -122.38951383063 | (37.7313891398709, -122.38951383063) | |
| 185441 | 185441 | 38610 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 1570 Revere Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/15/2002 12:00:00 AM | 6 | Permit Number 45423 | 6015263.8639 | 2094301.7253 | 37.7314112587254 | -122.38954670833701 | (37.7314112587254, -122.389546708337) | |
| 37094 | 37094 | 38611 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 1570 Revere Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/17/1998 12:00:00 AM | 6 | Permit Number 40556 | 6015254.5205 | 2094308.8703 | 37.7314303593885 | -122.389579509324 | (37.7314303593885, -122.389579509324) | |
| 71986 | 71986 | 200997 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 150 Folsom St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 17 | Width 0ft | 6015155.9522 | 2115579.6824 | 37.7898299587744 | -122.39140672399999 | (37.7898299587744, -122.391406724) | |||
| 160752 | 160752 | 200984 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 160 Folsom St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 0ft | 6015113.794 | 2115545.7503 | 37.7897344491206 | -122.391550215359 | (37.7897344491206, -122.391550215359) | |||
| 133602 | 133602 | 199721 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 2300 Jennings St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 0ft | 6015103.6937 | 2092236.9895 | 37.7257330254006 | -122.389956274684 | (37.7257330254006, -122.389956274684) | |||
| 49275 | 49275 | 200985 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 160 Folsom St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 0ft | 6015097.3421 | 2115526.2135 | 37.789679892382495 | -122.39160577131099 | (37.7896798923825, -122.391605771311) | |||
| 173135 | 173135 | 199722 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 2300 Jennings St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 0ft | 6015093.5789 | 2092222.3792 | 37.72569234746 | -122.38999022091998 | (37.72569234746, -122.38999022092) | |||
| 55070 | 55070 | 120657 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 160 Folsom St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3x3 | Permit Number 778623 | 6015078.8336 | 2115510.7898 | 37.7896365150846 | -122.39166873056001 | (37.7896365150846, -122.39166873056) | ||
| 65375 | 65375 | 200196 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 1124 Fitzgerald Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 20 | Width 0ft | 6015063.1024 | 2090263.455 | 37.720311838731 | -122.38995879887301 | (37.720311838731, -122.389958798873) | |||
| 51356 | 51356 | 120658 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 160 Folsom St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3x3 | Permit Number 778623 | 6015062.3817 | 2115495.3661 | 37.789593251915704 | -122.391724574055 | (37.7895932519157, -122.391724574055) | ||
| 163560 | 163560 | 199757 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 1555 Yosemite Ave | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 0ft | 6015056.6652 | 2092285.8367 | 37.7258645418149 | -122.39012226093901 | (37.7258645418149, -122.390122260939) | |||
| 170725 | 170725 | 199724 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 2300 Jennings St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 0ft | 6015054.2433 | 2092170.6809999999 | 37.7255482128528 | -122.390122592124 | (37.7255482128528, -122.390122592124) | |||
| 134413 | 134413 | 120659 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 160 Folsom St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | 3x3 | Permit Number 778623 | 6015041.8167 | 2115476.8576 | 37.7895412902416 | -122.391794432707 | (37.7895412902416, -122.391794432707) | ||
| 169564 | 169564 | 200689 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 4705 03rd St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 0ft | 6015031.9275 | 2095672.1834 | 37.73516139610629 | -122.39044428404699 | (37.7351613961063, -122.390444284047) | |||
| 53527 | 53527 | 200684 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 1618 Oakdale Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 0ft | 6015017.6376 | 2095531.4827 | 37.7347742678836 | -122.39048386170401 | (37.7347742678836, -122.390483861704) | |||
| 73758 | 73758 | 199726 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 2300 Jennings St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 0ft | 6015013.7839 | 2092118.9829 | 37.725404016033295 | -122.390258847729 | (37.7254040160333, -122.390258847729) | |||
| 153096 | 153096 | 199728 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 2300 Jennings St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 0ft | 6014985.6871 | 2092077.3996 | 37.725288278052 | -122.390353072543 | (37.725288278052, -122.390353072543) | |||
| 36681 | 36681 | 199730 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 1500 Armstrong Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 0ft | 6014897.5638 | 2092133.7733 | 37.725438180339 | -122.390661646389 | (37.725438180339, -122.390661646389) | |||
| 170427 | 170427 | 199732 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 1500 Armstrong Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 0ft | 6014820.4695 | 2092191.1459 | 37.7255914365754 | -122.390932164611 | (37.7255914365754, -122.390932164611) | |||
| 71272 | 71272 | 199749 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 1555 Yosemite Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 0ft | 6014744.6664 | 2092522.7122 | 37.7264976449454 | -122.39121737809799 | (37.7264976449454, -122.391217378098) | |||
| 26537 | 26537 | 199734 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 1500 Armstrong Ave | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 0ft | 6014741.5822 | 2092253.0007 | 37.725756899909 | -122.391209195431 | (37.725756899909, -122.391209195431) | |||
| 97930 | 97930 | 199735 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 1500 Armstrong Ave | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 0ft | 6014648.3519 | 2092320.2341 | 37.7259363350419 | -122.391536186534 | (37.7259363350419, -122.391536186534) | |||
| 47388 | 47388 | 199743 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 2392 Keith St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 0ft | 6014556.9144 | 2092538.9669 | 37.7265318557922 | -122.391867570434 | (37.7265318557922, -122.391867570434) | |||
| 69184 | 69184 | 199738 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 1500 Armstrong Ave | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 0ft | 6014531.8139 | 2092406.2929 | 37.7261661660829 | -122.39194506905001 | (37.7261661660829, -122.39194506905) | |||
| 65445 | 65445 | 199741 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 2396 Keith St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 0ft | 6014513.885 | 2092478.0086 | 37.7263620876399 | -122.392012061617 | (37.7263620876399, -122.392012061617) | |||
| 67341 | 67341 | 199739 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 1500 Armstrong Ave | 13 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 0ft | 6014497.7489 | 2092432.2899 | 37.7262356573725 | -122.392064648003 | (37.7262356573725, -122.392064648003) | |||
| 68178 | 68178 | 32290 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 1400 Egbert Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/15/1996 12:00:00 AM | 13 | Permit Number 36872 | 6014301.1518 | 2091179.5011 | 37.7227848326743 | -122.392656680249 | (37.7227848326743, -122.392656680249) | ||
| 177466 | 177466 | 32291 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 1400 Egbert Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/15/1996 12:00:00 AM | 7 | Permit Number 36872 | 6014236.59 | 2091225.7906 | 37.722908348540294 | -122.39288309530001 | (37.7229083485403, -122.3928830953) | ||
| 174955 | 174955 | 199852 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 2501 Keith St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 0ft | 6014213.4453 | 2092166.8088 | 37.7254909106612 | -122.393028911239 | (37.7254909106612, -122.393028911239) | |||
| 73307 | 73307 | 199853 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 2503 Keith St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 0ft | 6014209.1818 | 2092155.2364 | 37.7254588983374 | -122.39304284056499 | (37.7254588983374, -122.393042840565) | |||
| 58026 | 58026 | 199854 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 2505 Keith St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 0ft | 6014200.0457 | 2092143.0549 | 37.7254249428706 | -122.393073571548 | (37.7254249428706, -122.393073571548) | |||
| 68785 | 68785 | 199855 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 2507 Keith St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 0ft | 6014175.0737 | 2092094.9381 | 37.7252914365514 | -122.393156532831 | (37.7252914365514, -122.393156532831) | |||
| 148525 | 148525 | 199856 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 2509 Keith St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 0ft | 6014162.2831 | 2092076.0569 | 37.725238881999395 | -122.393199428445 | (37.7252388819994, -122.393199428445) | |||
| 68835 | 68835 | 199857 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 2511 Keith St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 0ft | 6014147.0563 | 2092057.1756 | 37.725186191812 | -122.39325074575198 | (37.725186191812, -122.393250745752) | |||
| 176045 | 176045 | 199858 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 2513 Keith St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 0ft | 6014132.4385 | 2092038.2943 | 37.7251335354362 | -122.393299957721 | (37.7251335354362, -122.393299957721) | |||
| 69625 | 69625 | 201180 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 608 Folsom St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 0ft | 6013469.6258 | 2113973.5593 | 37.785326180656 | -122.39712863022699 | (37.785326180656, -122.397128630227) | |||
| 185651 | 185651 | 201181 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 608 Folsom St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 0ft | 6013452.1456 | 2113958.1356 | 37.7852828576216 | -122.39718802493 | (37.7852828576216, -122.39718802493) | |||
| 26219 | 26219 | 201182 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 620 Folsom St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 0ft | 6013434.6654 | 2113939.6272 | 37.785231064684204 | -122.39724720317801 | (37.7852310646842, -122.397247203178) | |||
| 130882 | 130882 | 201183 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 620 Folsom St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 0ft | 6013416.1569 | 2113924.2034 | 37.7851876840649 | -122.397310155353 | (37.7851876840649, -122.397310155353) | |||
| 154938 | 154938 | 201882 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 633 Folsom St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 0ft | 6013405.8744 | 2113823.4352 | 37.7849104254124 | -122.397338660811 | (37.7849104254124, -122.397338660811) | |||
| 176185 | 176185 | 201184 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 620 Folsom St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 0ft | 6013400.7332 | 2113908.7797 | 37.78514447543571 | -122.397362434941 | (37.7851444754357, -122.397362434941) | |||
| 44704 | 44704 | 110911 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 633 Folsom St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | 6013393.5354 | 2113814.1809 | 37.784884328260105 | -122.397380700853 | (37.7848843282601, -122.397380700853) | ||||
| 135654 | 135654 | 201185 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 620 Folsom St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 0ft | 6013380.1682 | 2113890.2713 | 37.7850925106546 | -122.397432285471 | (37.7850925106546, -122.397432285471) | |||
| 177611 | 177611 | 110909 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 633 Folsom St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | 6013356.5185 | 2113781.277 | 37.7847919207208 | -122.397506459776 | (37.7847919207208, -122.397506459776) | ||||
| 59550 | 59550 | 110908 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 633 Folsom St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | 6013338.0101 | 2113761.7403 | 37.784737246892796 | -122.39756912252199 | (37.7847372468928, -122.397569122522) | ||||
| 50229 | 50229 | 110907 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 633 Folsom St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | 6013321.5581 | 2113739.1188 | 37.7846742173914 | -122.397624454233 | (37.7846742173914, -122.397624454233) | ||||
| 28900 | 28900 | 98468 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 1500 16th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | 3x3 | 6011948.2516 | 2107041.0959 | 37.7662064164751 | -122.40190466033701 | (37.7662064164751, -122.401904660337) | |||
| 47183 | 47183 | 98470 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 1500 16th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3x3 | 6011914.0134 | 2107036.3406 | 37.7661914486194 | -122.402022750022 | (37.7661914486194, -122.402022750022) | |||
| 181203 | 181203 | 98471 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 1500 16th St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3x3 | 6011899.7475 | 2107035.3895 | 37.7661880408824 | -122.40207202642401 | (37.7661880408824, -122.402072026424) | |||
| 38098 | 38098 | 98472 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 1500 16th St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | 3x3 | 6011885.4815 | 2107033.4874 | 37.766182021887005 | -122.402121236301 | (37.766182021887, -122.402121236301) | |||
| 46381 | 46381 | 98473 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 1500 16th St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3x3 | 6011870.2645 | 2107034.4384 | 37.7661837837598 | -122.402173936122 | (37.7661837837598, -122.402173936122) | |||
| 34183 | 34183 | 32298 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 1616 16th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/17/1999 12:00:00 AM | 12 | Permit Number 36875 | 6011655.3244 | 2107023.9767 | 37.766143058580205 | -122.40291664053001 | (37.7661430585802, -122.40291664053) | |
| 165399 | 165399 | 32294 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 1616 16th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/19/1996 12:00:00 AM | 12 | Permit Number 36875 | 6011626.7926 | 2107023.9767 | 37.7661414653506 | -122.403015326989 | (37.7661414653506, -122.403015326989) | ||
| 156483 | 156483 | 32296 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 1616 16th St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/19/1996 12:00:00 AM | 8 | Permit Number 36875 | 6011540.2459 | 2107019.2214 | 37.7661235750542 | -122.403314342162 | (37.7661235750542, -122.403314342162) | ||
| 167853 | 167853 | 32297 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 1616 16th St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/19/1996 12:00:00 AM | 12 | Permit Number 36875 | 6011502.2034 | 2107015.4172 | 37.766111004805396 | -122.40344565674499 | (37.7661110048054, -122.403445656745) | ||
| 132506 | 132506 | 143556 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 848 KEARNY ST | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 5 | Width 0ft | 6011275.0549 | 2117918.4465 | 37.796035485985705 | -122.40499907891301 | (37.7960354859857, -122.404999078913) | |||
| 169665 | 169665 | 143557 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 848 KEARNY ST | 2 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 5 | Width 0ft | 6011271.7921 | 2117938.489 | 37.7960903354635 | -122.405011780806 | (37.7960903354635, -122.405011780806) | |||
| 148730 | 148730 | 67753 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 900 Kearny St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/04/1992 12:00:00 AM | 11 | 3x3 | Permit Number 31377 | 6011258.7412 | 2118020.5233 | 37.79631485229 | -122.405062718866 | (37.79631485229, -122.405062718866) | |
| 162030 | 162030 | 115983 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 900 Kearny St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | 3x3 | 6011256.8768 | 2118034.0404 | 37.796351862758996 | -122.40507012236701 | (37.796351862759, -122.405070122367) | |||
| 182606 | 182606 | 115984 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 900 Kearny St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | 3x3 | 6011255.4785 | 2118051.2862 | 37.796399137392896 | -122.405076175742 | (37.7963991373929, -122.405076175742) | |||
| 170111 | 170111 | 115985 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 900 Kearny St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | 3x3 | 6011253.147999999 | 2118063.4049 | 37.7964322821358 | -122.405085093558 | (37.7964322821358, -122.405085093558) | |||
| 130403 | 130403 | 143498 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 857 Kearny St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 0ft | 6011217.723999999 | 2117930.0991 | 37.796064276257205 | -122.40519827705499 | (37.7960642762572, -122.405198277055) | |||
| 156337 | 156337 | 143497 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 867 Kearny St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 0ft | 6011217.2579 | 2117938.9551 | 37.796088566637394 | -122.40520051378999 | (37.7960885666374, -122.40520051379) | |||
| 179842 | 179842 | 143496 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 877 Kearny St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 0ft | 6011215.3935 | 2117948.7433 | 37.7961153384403 | -122.405207654625 | (37.7961153384403, -122.405207654625) | |||
| 178515 | 178515 | 142934 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 1201 KEARNY ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 0ft | 6011088.1877 | 2119032.3 | 37.7990834099948 | -122.40572417480699 | (37.7990834099948, -122.405724174807) | |||
| 52503 | 52503 | 142516 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 1205 KEARNY ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 0ft | 6011083.7416 | 2119059.5323 | 37.7991579346332 | -122.40574147910499 | (37.7991579346332, -122.405741479105) | |||
| 23414 | 23414 | 64062 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 1205 Kearny St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/07/1995 12:00:00 AM | 7 | Permit Number 29268 | 6011082.0743 | 2119072.3147 | 37.799192938755 | -122.405748149412 | (37.799192938755, -122.405748149412) | |
| 168656 | 168656 | 142933 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 502 Vallejo St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 0ft | 6011075.0739 | 2119008.1155 | 37.7990162718949 | -122.405767848781 | (37.7990162718949, -122.405767848781) | |||
| 166925 | 166925 | 142506 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 1223 KEARNY ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 0ft | 6011074.9884 | 2119120.527 | 37.7993249217375 | -122.405776067035 | (37.7993249217375, -122.405776067035) | |||
| 172121 | 172121 | 142923 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 1249 KEARNY ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | Width 0ft | 6011057.7598 | 2119245.0173 | 37.7996657782982 | -122.40584445833099 | (37.7996657782982, -122.405844458331) | |||
| 25206 | 25206 | 98347 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 1331 Kearny St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 17 | 3x3 | 6011023.1341 | 2119487.8255 | 37.800330533908294 | -122.40598139081999 | (37.8003305339083, -122.40598139082) | |||
| 146640 | 146640 | 142920 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 1339 KEARNY ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 0ft | 6011019.5196 | 2119515.0732 | 37.800405147287 | -122.405995819069 | (37.800405147287, -122.405995819069) | |||
| 146917 | 146917 | 142466 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 1454 Kearny St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 0ft | 6010993.6362 | 2119929.285 | 37.8015410239646 | -122.40611458444599 | (37.8015410239646, -122.406114584446) | |||
| 74573 | 74573 | 142464 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 1456 Kearny St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 0ft | 6010990.4041 | 2119956.0656 | 37.8016143761567 | -122.406127656852 | (37.8016143761567, -122.406127656852) | |||
| 171052 | 171052 | 142473 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 1429 Kearny St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | Width 0ft | 6010981.054 | 2119812.8124 | 37.8012205149436 | -122.40614991427499 | (37.8012205149436, -122.406149914275) | |||
| 135505 | 135505 | 142472 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 1429 Kearny St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 17 | Width 0ft | 6010978.9762 | 2119829.6657 | 37.8012666737636 | -122.40615829244699 | (37.8012666737636, -122.406158292447) | |||
| 156290 | 156290 | 142471 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 1439 Kearny St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 19 | Width 0ft | 6010974.128 | 2119867.5279 | 37.8013703629213 | -122.406177738482 | (37.8013703629213, -122.406177738482) | |||
| 29158 | 29158 | 142470 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 1443 Kearny St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 0ft | 6010970.8958 | 2119887.8443 | 37.8014259659921 | -122.406190355577 | (37.8014259659921, -122.406190355577) | |||
| 55708 | 55708 | 142468 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 1455 Kearny St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 0ft | 6010964.6624 | 2119932.1708 | 37.801547327044894 | -122.40621505084299 | (37.8015473270449, -122.406215050843) | |||
| 136475 | 136475 | 142465 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 1457 Kearny St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 0ft | 6010961.892000001 | 2119955.2575 | 37.8016105625065 | -122.406226265244 | (37.8016105625065, -122.406226265244) | |||
| 5324 | 5324 | 4600 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 256 Columbus Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 45 | 3X3 | 6010961.6739 | 2118493.2807 | 37.7975963184564 | -122.406123962239 | (37.7975963184564, -122.406123962239) | |||
| 181839 | 181839 | 143491 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 270 COLUMBUS AVE | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 17 | Width 0ft | 6010925.3503 | 2118525.7809 | 37.797683524364096 | -122.40625194331999 | (37.7976835243641, -122.40625194332) | |||
| 151245 | 151245 | 143492 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 270 COLUMBUS AVE | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 0ft | 6010909.4189 | 2118541.7123 | 37.7977263769575 | -122.406308193671 | (37.7977263769575, -122.406308193671) | |||
| 154700 | 154700 | 143480 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 626 PINE ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 0ft | 6010907.472999999 | 2116280.5305 | 37.7915176085666 | -122.40615553742201 | (37.7915176085666, -122.406155537422) | |||
| 7868 | 7868 | 4605 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 270 Columbus Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 70 | 3X3 | 6010895.3992 | 2118554.4574 | 37.7977605876582 | -122.40635760441799 | (37.7977605876582, -122.406357604418) | |||
| 132939 | 132939 | 143481 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 626 PINE ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | Width 0ft | 6010890.3641 | 2116278.8196 | 37.7915119538645 | -122.40621461366999 | (37.7915119538645, -122.40621461367) | |||
| 13519 | 13519 | 113149 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 1035X Folsom St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 14 | 3x3 | 6010826.0688 | 2111360.9298 | 37.7780049945656 | -122.406090456701 | (37.7780049945656, -122.406090456701) | |||
| 6713 | 6713 | 12985 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 306 Lombard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 23 | 3X3 | 6010818.9339 | 2120706.9936 | 37.8036666476299 | -122.406773977327 | (37.8036666476299, -122.406773977327) | |||
| 14753 | 14753 | 7389 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 1035X Folsom St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 30 | 3x3 | 6010809.9838 | 2111345.3995 | 37.7779614523005 | -122.406145006296 | (37.7779614523005, -122.406145006296) | |||
| 14749 | 14749 | 7388 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 1035X Folsom St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 30 | 3x3 | 6010798.3361 | 2111334.861 | 37.7779318645299 | -122.406184557349 | (37.7779318645299, -122.406184557349) | |||
| 14599 | 14599 | 7391 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 1035X Folsom St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 05/28/1992 12:00:00 AM | 30 | 3x3 | 6010784.4697 | 2111320.9947 | 37.77789301527721 | -122.40623154915001 | (37.7778930152772, -122.40623154915) | ||
| 16043 | 16043 | 7390 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 1035X Folsom St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 30 | 3x3 | 6010768.3847 | 2111305.4643 | 37.7778494726714 | -122.40628609857299 | (37.7778494726714, -122.406286098573) |
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");