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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 3362 | 3362 | 114879 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 1454 HAYES ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6000868.0 | 2110394.0 | 37.7747880422892 | -122.440469509771 | (37.7747880422892, -122.440469509771) | ||||
| 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) | ||||
| 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) | ||||
| 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) | ||||
| 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) | ||||
| 108810 | 108810 | 113054 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 25 FILLMORE ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6003823.0 | 2108493.0 | 37.7697361782825 | -122.430111915017 | (37.7697361782825, -122.430111915017) | ||||
| 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) | ||||
| 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) | ||||
| 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) | ||||
| 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) | ||||
| 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) | ||||
| 145969 | 145969 | 113486 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 30 PRESIDIO AVE | 2 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 3x3 | 5998975.0 | 2116473.0 | 37.7913714231174 | -122.44745541416201 | (37.7913714231174, -122.447455414162) | ||||
| 70528 | 70528 | 143389 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 1800 UNION ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 0ft | 6004330.7069 | 2118766.2088 | 37.7979725882879 | -122.42908836006399 | (37.7979725882879, -122.429088360064) | |||
| 147790 | 147790 | 138486 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 1910 STEINER ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 0ft | 6002505.7805 | 2114896.8038 | 37.7872447276766 | -122.435126221094 | (37.7872447276766, -122.435126221094) | |||
| 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) | |||
| 184932 | 184932 | 142820 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 1754 POLK ST | 2 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 1 | Width 0ft | 6006598.3556 | 2116937.7026 | 37.793080071640894 | -122.42111173056101 | (37.7930800716409, -122.421111730561) | |||
| 37099 | 37099 | 141488 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 2901 TURK BLVD | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 0ft | 5996896.3984 | 2111514.1702 | 37.7776367906711 | -122.454288950996 | (37.7776367906711, -122.454288950996) | |||
| 58484 | 58484 | 138743 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 2965 Bush St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 0ft | 5999307.6319 | 2114263.2516 | 37.7853230365302 | -122.446145501349 | (37.7853230365302, -122.446145501349) | |||
| 58556 | 58556 | 143036 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 502 Lombard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 0ft | 6009910.3575 | 2120582.9753 | 37.8032752457109 | -122.409909406146 | (37.8032752457109, -122.409909406146) | |||
| 68249 | 68249 | 138745 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 2965 Bush St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 0ft | 5999354.2167 | 2114269.6942 | 37.7853433864461 | -122.445984796208 | (37.7853433864461, -122.445984796208) | |||
| 96109 | 96109 | 141490 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 2901 TURK BLVD | 14 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 0ft | 5996921.6348 | 2111517.4619 | 37.7776472759958 | -122.454201888036 | (37.7776472759958, -122.454201888036) | |||
| 156651 | 156651 | 105961 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 313 Ivy St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | 6005800.4768 | 2111198.1428 | 37.777275647690296 | -122.42346421459601 | (37.7772756476903, -122.423464214596) | ||||
| 164399 | 164399 | 141486 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 2901 TURK BLVD | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 0ft | 5996862.6584 | 2111508.4097 | 37.77761903893 | -122.454405252217 | (37.77761903893, -122.454405252217) | |||
| 172803 | 172803 | 143014 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 488 LOMBARD ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 0ft | 6010067.5326 | 2120604.4864 | 37.8033431173057 | -122.409367013095 | (37.8033431173057, -122.409367013095) | |||
| 64636 | 64636 | 246098 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 700 Stanyan St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 0ft | 5997112.7214 | 2108174.1833 | 37.7684784553517 | -122.45329942957198 | (37.7684784553517, -122.453299429572) | |||
| 74307 | 74307 | 137574 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 1135 STEINER ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 0ft | 6002846.9387 | 2112168.7066 | 37.7797734277366 | -122.43375082949801 | (37.7797734277366, -122.433750829498) | |||
| 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) | ||
| 137714 | 137714 | 138741 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 2965 Bush St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 0ft | 5999272.4455 | 2114257.3047 | 37.7853046984356 | -122.446266807223 | (37.7853046984356, -122.446266807223) | |||
| 186639 | 186639 | 138707 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 2874 BUSH ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 0ft | 5999741.1485 | 2114383.1871 | 37.7856770956012 | -122.44465429395099 | (37.7856770956012, -122.444654293951) | |||
| 23838 | 23838 | 140159 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 251 ASHBURY ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 0ft | 5998783.859 | 2109828.5826 | 37.77311665794689 | -122.44763824308501 | (37.7731166579469, -122.447638243085) | |||
| 24233 | 24233 | 140776 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 77 TERRA VISTA AVE | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 0ft | 6000147.5673 | 2112813.1036 | 37.7813892348129 | -122.443135402805 | (37.7813892348129, -122.443135402805) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 64849 | 64849 | 111733 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 313 Ivy St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | 2.5x3 | 6005854.5902 | 2111208.289 | 37.777306560799 | -122.42327774010201 | (37.777306560799, -122.423277740102) | |||
| 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) | |||
| 149439 | 149439 | 140593 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 950 STEINER ST | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 0ft | 6002965.1287 | 2111621.7183 | 37.7782782403601 | -122.43330286230899 | (37.7782782403601, -122.433302862309) | |||
| 149550 | 149550 | 138744 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 2965 Bush St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 0ft | 5999334.3934 | 2114268.2075 | 37.7853381723766 | -122.44605327160801 | (37.7853381723766, -122.446053271608) | |||
| 153429 | 153429 | 113988 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 2183 Sutter St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | 3x3 | 6002243.1253 | 2114325.3833 | 37.7856608347208 | -122.43599404678801 | (37.7856608347208, -122.435994046788) | |||
| 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) | |||
| 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) | |||
| 163651 | 163651 | 117047 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 2183 Sutter St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | 3x3 | 6002170.5041 | 2114314.4901 | 37.7856267989414 | -122.43624451502701 | (37.7856267989414, -122.436244515027) | |||
| 176087 | 176087 | 137986 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 1826 WEBSTER ST | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 4 | Width 0ft | 6003453.629 | 2115096.2902 | 37.7878462437049 | -122.431861119013 | (37.7878462437049, -122.431861119013) | |||
| 180137 | 180137 | 138742 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 2965 Bush St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 0ft | 5999291.2776 | 2114261.7649 | 37.7853180204784 | -122.446201975075 | (37.7853180204784, -122.446201975075) | |||
| 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) | |||
| 24010 | 24010 | 248469 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 145 Belvedere St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 0ft | 5998248.1791 | 2107933.2828 | 37.7678820197346 | -122.449354639507 | (37.7678820197346, -122.449354639507) | |||
| 24338 | 24338 | 142592 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 365 COLUMBUS AVE | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 0ft | 6008300.8769 | 2120835.2204 | 37.803877514381 | -122.415496953155 | (37.803877514381, -122.415496953155) | |||
| 29701 | 29701 | 138739 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 700 PRESIDIO AVE | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 0ft | 5999270.4631 | 2114185.9407 | 37.7851086382869 | -122.446268530298 | (37.7851086382869, -122.446268530298) | |||
| 36580 | 36580 | 142827 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 1714 POLK ST | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 5 | Width 0ft | 6006619.3625 | 2116773.8493 | 37.7926313555217 | -122.421027406021 | (37.7926313555217, -122.421027406021) | |||
| 39156 | 39156 | 248312 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 1375 Waller St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 0ft | 5999157.272000001 | 2108349.6728 | 37.769077281031606 | -122.44624016016199 | (37.7690772810316, -122.446240160162) | |||
| 40459 | 40459 | 138740 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 700 PRESIDIO AVE | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 0ft | 5999265.5073 | 2114223.1094 | 37.7852104108131 | -122.44628835045299 | (37.7852104108131, -122.446288350453) | |||
| 47229 | 47229 | 246151 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 1622 Waller St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 0ft | 5997783.0336 | 2108202.195 | 37.7685937659628 | -122.450982909765 | (37.7685937659628, -122.450982909765) | |||
| 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) | |||
| 64396 | 64396 | 98493 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 1703 Polk St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 5 | 6006578.8967 | 2116733.3834 | 37.7925179651008 | -122.421164544764 | (37.7925179651008, -122.421164544764) | ||||
| 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) | |||
| 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) | |||
| 73100 | 73100 | 141695 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 392 EWING TER | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 0ft | 5998748.3741 | 2112341.6402 | 37.78001483889879 | -122.44794195643499 | (37.7800148388988, -122.447941956435) | |||
| 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) | |||
| 124097 | 124097 | 137887 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 38 ORBEN PL | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 0ft | 6003163.7564 | 2115374.8880000003 | 37.788594765883005 | -122.432883934493 | (37.788594765883, -122.432883934493) | |||
| 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) | |||
| 134800 | 134800 | 140932 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 5 COOK ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 0ft | 5997447.8074 | 2113631.9151 | 37.783483168451 | -122.452534319363 | (37.783483168451, -122.452534319363) | |||
| 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) | |||
| 163000 | 163000 | 143333 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 1718 UNION ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 0ft | 6004746.2843 | 2118826.5974 | 37.7981619155795 | -122.42765464763201 | (37.7981619155795, -122.427654647632) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 31071 | 31071 | 247300 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 815 Page St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 0ft | 6002551.3233 | 2109517.7945 | 37.772477905220796 | -122.434583889381 | (37.7724779052208, -122.434583889381) | |||
| 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) | |||
| 34969 | 34969 | 140050 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 501 FULTON ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 0ft | 6005278.6254 | 2111629.2967 | 37.778430022863496 | -122.425300156764 | (37.7784300228635, -122.425300156764) | |||
| 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) | |||
| 47412 | 47412 | 141681 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 2340 TURK BLVD | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 0ft | 5998731.3741 | 2111830.7737 | 37.77861116004 | -122.447963975147 | (37.77861116004, -122.447963975147) | |||
| 47603 | 47603 | 142594 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 365 COLUMBUS AVE | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 0ft | 6008329.6499 | 2120808.0026 | 37.8038043983711 | -122.41539545409401 | (37.8038043983711, -122.415395454094) | |||
| 50203 | 50203 | 247450 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 917 Oak St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 0ft | 6002601.5894 | 2109867.0536 | 37.773439737619704 | -122.43443498999599 | (37.7734397376197, -122.434434989996) | |||
| 59398 | 59398 | 141694 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 392 EWING TER | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 0ft | 5998733.647999999 | 2112339.0414 | 37.780006861514 | -122.44799271326 | (37.780006861514, -122.44799271326) | |||
| 63167 | 63167 | 142150 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 20 Stanyan Blvd | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 0ft | 5996389.5624 | 2112799.0591 | 37.7811356783284 | -122.456135178495 | (37.7811356783284, -122.456135178495) | |||
| 63234 | 63234 | 142593 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 365 COLUMBUS AVE | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 0ft | 6008314.0969 | 2120822.0003 | 37.8038419583694 | -122.415450267897 | (37.8038419583694, -122.415450267897) | |||
| 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) | |||
| 72787 | 72787 | 141678 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 2340 TURK BLVD | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 0ft | 5998817.5652 | 2111841.8183 | 37.7786464120147 | -122.44766660351101 | (37.7786464120147, -122.447666603511) | |||
| 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) | |||
| 76520 | 76520 | 141343 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 462 BRODERICK ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 0ft | 6001184.3335 | 2110341.7185 | 37.7746624976237 | -122.43937150108499 | (37.7746624976237, -122.439371501085) | |||
| 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) | |||
| 130431 | 130431 | 142597 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 365 COLUMBUS AVE | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 0ft | 6008368.5325 | 2120773.0083 | 37.8037104981311 | -122.41525841948 | (37.8037104981311, -122.41525841948) | |||
| 137944 | 137944 | 141075 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 189 COMMONWEALTH AVE | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 0ft | 5996533.8993 | 2113075.3805 | 37.7819026676704 | -122.45565582670099 | (37.7819026676704, -122.455655826701) | |||
| 152688 | 152688 | 141696 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 392 EWING TER | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 0ft | 5998768.2977 | 2112343.8058 | 37.7800219238864 | -122.447873187985 | (37.7800219238864, -122.447873187985) | |||
| 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) | |||
| 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) | |||
| 156752 | 156752 | 142993 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 365 COLUMBUS AVE | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 0ft | 6008349.8689 | 2120789.339 | 37.803754289201606 | -122.415324162836 | (37.8037542892016, -122.415324162836) | |||
| 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) | |||
| 163737 | 163737 | 143168 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 189 Bay St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 0ft | 6009887.869 | 2121571.9902 | 37.8059895743176 | -122.410057091761 | (37.8059895743176, -122.410057091761) | |||
| 163956 | 163956 | 108011 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 419X Ivy St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 6005290.828 | 2111124.4075 | 37.7770444098803 | -122.42522200735 | (37.7770444098803, -122.42522200735) | ||||
| 164164 | 164164 | 142598 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 365 COLUMBUS AVE | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 0ft | 6008376.308999999 | 2120765.2318 | 37.8036895828586 | -122.415230957587 | (37.8036895828586, -122.415230957587) | |||
| 167035 | 167035 | 142595 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 365 COLUMBUS AVE | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 0ft | 6008339.7594 | 2120798.6708 | 37.803779343791795 | -122.415359808453 | (37.8037793437918, -122.415359808453) | |||
| 167676 | 167676 | 142591 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 365 COLUMBUS AVE | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 0ft | 6008291.5451 | 2120841.4416 | 37.8038940717069 | -122.41552968724 | (37.8038940717069, -122.41552968724) | |||
| 168080 | 168080 | 141679 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 2340 TURK BLVD | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 0ft | 5998783.9983 | 2111836.4043 | 37.778629628102 | -122.44778233403 | (37.778629628102, -122.44778233403) | |||
| 168944 | 168944 | 140051 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 501 FULTON ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 0ft | 6005299.4561 | 2111632.5014 | 37.7784399990073 | -122.42522832358 | (37.7784399990073, -122.42522832358) |
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");