Data source: data.sfgov.org
This data as json, CSV (advanced)
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location ▼ |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 35602 | 35602 | 217547 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 102 Broad St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 0ft | 5995842.2441 | 2088093.8487 | 37.713269899907104 | -122.45624180431801 | (37.7132698999071, -122.456241804318) | |||
| 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) | |||
| 60326 | 60326 | 187453 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 4621 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 0ft | 6002078.4831 | 2091980.9842 | 37.724299121454 | -122.43496507260201 | (37.724299121454, -122.434965072602) | |||
| 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) | |||
| 162336 | 162336 | 217617 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 1830 Ocean Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 0ft | 5994396.9504 | 2092455.3654 | 37.7251625099423 | -122.46155321589701 | (37.7251625099423, -122.461553215897) | |||
| 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) | |||
| 184834 | 184834 | 217619 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 1830 Ocean Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 0ft | 5994357.3344 | 2092471.2741 | 37.7252039110132 | -122.461691316268 | (37.7252039110132, -122.461691316268) | |||
| 24837 | 24837 | 217620 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 1830 Ocean Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 0ft | 5994327.7005 | 2092483.4396 | 37.7252356086447 | -122.461794638623 | (37.7252356086447, -122.461794638623) | |||
| 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) | |||
| 180017 | 180017 | 217621 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 1830 Ocean Ave | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 0ft | 5994307.7366 | 2092494.0455 | 37.725263580598 | -122.461864420033 | (37.725263580598, -122.461864420033) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 67059 | 67059 | 185225 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 2519 34th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 0ft | 5985800.5083 | 2098072.0747 | 37.7400859553966 | -122.491683090969 | (37.7400859553966, -122.491683090969) | |||
| 154252 | 154252 | 245378 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 3550 Mission St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 0ft | 6005581.5521 | 2097815.7311 | 37.7405183234498 | -122.42327002037099 | (37.7405183234498, -122.423270020371) | |||
| 44905 | 44905 | 182129 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 2650 Ulloa St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 0ft | 5987716.6576 | 2098310.3756 | 37.740852067466506 | -122.485075392772 | (37.7408520674665, -122.485075392772) | |||
| 71966 | 71966 | 182128 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 2650 Ulloa St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 0ft | 5987739.3319 | 2098310.7141 | 37.7408543176455 | -122.48499701931601 | (37.7408543176455, -122.484997019316) | |||
| 134981 | 134981 | 182109 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 2443 28th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | Width 0ft | 5987643.897000001 | 2098649.745 | 37.741779647708995 | -122.48535186527599 | (37.741779647709, -122.485351865276) | |||
| 31784 | 31784 | 98024 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 1639 Taraval St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 3x3 | 5988098.058999999 | 2098940.517 | 37.742604479099 | -122.483802857352 | (37.742604479099, -122.483802857352) | |||
| 188134 | 188134 | 181943 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 1635 Taraval St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 0ft | 5988119.3796 | 2098941.1939 | 37.7426075787892 | -122.483729187458 | (37.7426075787892, -122.483729187458) | |||
| 29051 | 29051 | 181932 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 2378 36th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 18 | Width 0ft | 5985195.246 | 2099024.2764 | 37.74266505256279 | -122.49384596323 | (37.7426650525628, -122.49384596323) | |||
| 58272 | 58272 | 181891 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 2362 34th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 0ft | 5985808.0433 | 2099163.7908 | 37.7430839555722 | -122.491737385137 | (37.7430839555722, -122.491737385137) | |||
| 39439 | 39439 | 181853 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 2318 32nd Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 4 | Width 0ft | 5986420.3329 | 2099445.95 | 37.7438944556176 | -122.48964102637699 | (37.7438944556176, -122.489641026377) | |||
| 41163 | 41163 | 181854 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 2318 32nd Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 6 | Width 0ft | 5986419.9945 | 2099457.4563 | 37.7439260290789 | -122.48964304245001 | (37.7439260290789, -122.48964304245) | |||
| 148571 | 148571 | 183823 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 2235 27th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 0ft | 5987905.9224 | 2100064.0482 | 37.7456782117444 | -122.48454959408501 | (37.7456782117444, -122.484549594085) | |||
| 159251 | 159251 | 183822 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 2235 27th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 4 | Width 0ft | 5987905.4957 | 2100075.9969 | 37.7457109948541 | -122.484551945811 | (37.7457109948541, -122.484551945811) | |||
| 110431 | 110431 | 113408 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 1450 SANCHEZ ST | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6003890.0 | 2099760.0 | 37.74576122776671 | -122.429257354108 | (37.7457612277667, -122.429257354108) | ||||
| 78346 | 78346 | 113409 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 401x DUNCAN ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6003916.0 | 2099815.0 | 37.745913716911 | -122.429171370863 | (37.745913716911, -122.429171370863) | ||||
| 116559 | 116559 | 113410 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 401x DUNCAN ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6003916.0 | 2099815.0 | 37.745913716911 | -122.429171370863 | (37.745913716911, -122.429171370863) | ||||
| 183473 | 183473 | 184489 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 1866 40th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 0ft | 5983834.6211 | 2102450.9664 | 37.7519941007524 | -122.49880363397499 | (37.7519941007524, -122.498803633975) | |||
| 157088 | 157088 | 184487 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 1862 40th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 0ft | 5983833.6059 | 2102475.6712 | 37.75206187373821 | -122.498808969569 | (37.7520618737382, -122.498808969569) | |||
| 60650 | 60650 | 245421 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 2895 24th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 0ft | 6009555.5127 | 2102167.7354 | 37.752691443997996 | -122.40983667839501 | (37.752691443998, -122.409836678395) | |||
| 168438 | 168438 | 245420 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 2855 24th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | Width 0ft | 6009712.0846 | 2102179.2059 | 37.7527317128259 | -122.409296032004 | (37.7527317128259, -122.409296032004) | |||
| 133730 | 133730 | 245419 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 2839 24th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 19 | Width 0ft | 6009862.9212 | 2102186.0881 | 37.7527590594841 | -122.408774895147 | (37.7527590594841, -122.408774895147) | |||
| 188438 | 188438 | 245412 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 2802 24th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 19 | Width 0ft | 6009963.8161 | 2102233.787 | 37.7528956807716 | -122.408429345015 | (37.7528956807716, -122.408429345015) | |||
| 1904 | 1904 | 245410 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 2782 24th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 19 | Width 0ft | 6010125.3081 | 2102244.3008 | 37.752933591707794 | -122.40787161420401 | (37.7529335917078, -122.407871614204) | |||
| 39668 | 39668 | 245409 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 2778 24th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 20 | Width 0ft | 6010163.1606 | 2102247.1684 | 37.7529435845832 | -122.40774091468 | (37.7529435845832, -122.40774091468) | |||
| 130123 | 130123 | 245414 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 2736 24th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 23 | Width 0ft | 6010338.0852 | 2102254.0506 | 37.752972272430206 | -122.40713647446998 | (37.7529722724302, -122.40713647447) | |||
| 137830 | 137830 | 245413 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 2726 24th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 20 | Width 0ft | 6010382.82 | 2102257.4918 | 37.7529842245941 | -122.406982014782 | (37.7529842245941, -122.406982014782) | |||
| 181828 | 181828 | 245472 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 2700 24th St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 19 | Width 0ft | 6010432.7166 | 2102259.7859 | 37.7529933156944 | -122.406809623625 | (37.7529933156944, -122.406809623625) | |||
| 130725 | 130725 | 245471 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 2700 24th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 20 | Width 0ft | 6010463.1133 | 2102261.5065 | 37.7529997408326 | -122.406704626743 | (37.7529997408326, -122.406704626743) | |||
| 177119 | 177119 | 245470 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 2700 24th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 21 | Width 0ft | 6010486.0542 | 2102262.08 | 37.753002599060295 | -122.40662533272899 | (37.7530025990603, -122.406625332729) | |||
| 44212 | 44212 | 184648 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 1691 40th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 0ft | 5983748.1287 | 2103659.9866 | 37.755308660398505 | -122.49919205978998 | (37.7553086603985, -122.49919205979) | |||
| 43401 | 43401 | 182246 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 1455 33rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 0ft | 5985863.116 | 2105312.6885 | 37.759970370515106 | -122.491999577939 | (37.7599703705151, -122.491999577939) | |||
| 18161 | 18161 | 107661 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 1312 CLAYTON ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | 3x3 | 5999086.9 | 2105066.2 | 37.7600576690463 | -122.446247345124 | (37.7600576690463, -122.446247345124) | |||
| 72332 | 72332 | 182039 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 1323 23rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 0ft | 5988935.747 | 2106319.8798 | 37.7629149697028 | -122.481446720354 | (37.7629149697028, -122.481446720354) | |||
| 55161 | 55161 | 246282 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 2125 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 0ft | 6006871.6187 | 2105950.8046 | 37.762928100871896 | -122.41938643496401 | (37.7629281008719, -122.419386434964) | |||
| 187140 | 187140 | 183273 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 1251 40th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 0ft | 5983646.3542 | 2106625.2038 | 37.7634443416971 | -122.49976317535801 | (37.7634443416971, -122.499763175358) | |||
| 58145 | 58145 | 183272 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 1251 40th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 0ft | 5983645.262999999 | 2106639.9345 | 37.7634847239936 | -122.49976803825199 | (37.7634847239936, -122.499768038252) | |||
| 42976 | 42976 | 113471 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 450 CHURCH ST | 28 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | 6x6 | 6004088.0 | 2106523.0 | 37.764342039298896 | -122.429054808288 | (37.7643420392989, -122.429054808288) | ||||
| 80997 | 80997 | 113469 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 450 CHURCH ST | 26 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | 6x6 | 6004088.0 | 2106523.0 | 37.764342039298896 | -122.429054808288 | (37.7643420392989, -122.429054808288) | ||||
| 87131 | 87131 | 113474 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 450 CHURCH ST | 31 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | 6x6 | 6004088.0 | 2106523.0 | 37.764342039298896 | -122.429054808288 | (37.7643420392989, -122.429054808288) | ||||
| 89483 | 89483 | 113468 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 450 CHURCH ST | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | 06/21/2016 02:14:00 PM | 3 | 6x7 | 6004088.0 | 2106523.0 | 37.764342039298896 | -122.429054808288 | (37.7643420392989, -122.429054808288) | ||
| 92566 | 92566 | 113466 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 450 CHURCH ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | 6x6 | 6004088.0 | 2106523.0 | 37.764342039298896 | -122.429054808288 | (37.7643420392989, -122.429054808288) | ||||
| 96050 | 96050 | 113472 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 450 CHURCH ST | 29 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | 6x6 | 6004088.0 | 2106523.0 | 37.764342039298896 | -122.429054808288 | (37.7643420392989, -122.429054808288) | ||||
| 111779 | 111779 | 113467 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 450 CHURCH ST | 24 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | 6x6 | 6004088.0 | 2106523.0 | 37.764342039298896 | -122.429054808288 | (37.7643420392989, -122.429054808288) | ||||
| 112823 | 112823 | 113475 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 450 CHURCH ST | 32 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | 6x6 | 6004088.0 | 2106523.0 | 37.764342039298896 | -122.429054808288 | (37.7643420392989, -122.429054808288) | ||||
| 124165 | 124165 | 113473 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 450 CHURCH ST | 30 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | 6x6 | 6004088.0 | 2106523.0 | 37.764342039298896 | -122.429054808288 | (37.7643420392989, -122.429054808288) | ||||
| 126562 | 126562 | 113465 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 450 CHURCH ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | 20 | 6x6 | 6004088.0 | 2106523.0 | 37.764342039298896 | -122.429054808288 | (37.7643420392989, -122.429054808288) | |||
| 144168 | 144168 | 113470 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 450 CHURCH ST | 27 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | 6x6 | 6004088.0 | 2106523.0 | 37.764342039298896 | -122.429054808288 | (37.7643420392989, -122.429054808288) | ||||
| 40899 | 40899 | 181727 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 2755 29th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 0ft | 5987094.0342 | 2107004.1542 | 37.76468654333279 | -122.487866760897 | (37.7646865433328, -122.487866760897) | |||
| 67589 | 67589 | 181728 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 2755 29th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 0ft | 5987089.3098 | 2107026.595 | 37.7647478839827 | -122.487884750055 | (37.7647478839827, -122.487884750055) | |||
| 163380 | 163380 | 245439 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 2940 16th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 22 | Width 0ft | 6007210.058999999 | 2106771.9452 | 37.7652018171161 | -122.418274106734 | (37.7652018171161, -122.418274106734) | |||
| 146420 | 146420 | 245460 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 2940 16th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 20 | Width 0ft | 6007306.1163 | 2106778.6027 | 37.7652255036159 | -122.41794233876101 | (37.7652255036159, -122.417942338761) | |||
| 157627 | 157627 | 245462 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 2886 16th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 17 | Width 0ft | 6007544.8329 | 2106792.8686 | 37.7652781065022 | -122.41711768386001 | (37.7652781065022, -122.41711768386) | |||
| 63246 | 63246 | 245461 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 2886 16th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 19 | Width 0ft | 6007563.8542 | 2106794.7707 | 37.7652843992631 | -122.417052028294 | (37.7652843992631, -122.417052028294) | |||
| 57912 | 57912 | 200832 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 2000 16th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 0ft | 6010535.924 | 2106957.4024 | 37.7658976908793 | -122.406783753376 | (37.7658976908793, -122.406783753376) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 48254 | 48254 | 248610 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 872 Shrader St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 0ft | 5997691.4278 | 2107516.4386 | 37.7667056091614 | -122.4512503025 | (37.7667056091614, -122.4512503025) | |||
| 60986 | 60986 | 248611 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 862 Shrader St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 0ft | 5997689.6108 | 2107534.9111 | 37.7667562259025 | -122.45125791953001 | (37.7667562259025, -122.45125791953) | |||
| 154058 | 154058 | 248533 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 174 Belvedere St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 0ft | 5998320.7066 | 2107735.9897 | 37.7673444513971 | -122.449089561777 | (37.7673444513971, -122.449089561777) | |||
| 149998 | 149998 | 248465 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 772 Stanyan St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 0ft | 5997147.6982 | 2107925.2578 | 37.767796974534605 | -122.45316047633601 | (37.7677969745346, -122.453160476336) |
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");