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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 954 | 954 | 251405 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 540 LOMBARD ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/21/2016 12:08:00 PM | Width 0ft | 6009678.016 | 2120549.6995 | 37.8031708545804 | -122.410711083519 | (37.8031708545804, -122.410711083519) | |||
| 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) | ||||
| 20080 | 20080 | 38646 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 209 29th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/22/1998 12:00:00 AM | Permit Number 40570 | 6005214.92856016 | 2099001.03793316 | 37.7437522091261 | -122.42462195934401 | (37.7437522091261, -122.424621959344) | |||
| 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) | ||||
| 81079 | 81079 | 54103 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 2317 Jackson St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/19/1972 12:00:00 AM | 3x3 | Permit Number 9832 | 6003101.11509235 | 2116824.39264322 | 37.792571182193605 | -122.43320427561301 | (37.7925711821936, -122.433204275613) | ||
| 86975 | 86975 | 53539 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 322 02nd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/11/1969 12:00:00 AM | Permit Number 776401 | 5995280.52661988 | 2113383.63166464 | 37.78267703677329 | -122.460014224406 | (37.7826770367733, -122.460014224406) | |||
| 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) | ||||
| 92442 | 92442 | 37059 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 1450 Sanchez St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/01/1998 12:00:00 AM | 3x3 | Permit Number 39663 | 6003906.83973736 | 2099821.31146391 | 37.745930528166596 | -122.429203495744 | (37.7459305281666, -122.429203495744) | ||
| 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) | ||||
| 111616 | 111616 | 37061 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 1450 Sanchez St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/01/1998 12:00:00 AM | 3x3 | Permit Number 39663 | 6003906.83973736 | 2099821.31146391 | 37.745930528166596 | -122.429203495744 | (37.7459305281666, -122.429203495744) | |
| 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) | ||||
| 139908 | 139908 | 37062 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 1450 Sanchez St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/01/1998 12:00:00 AM | 3x3 | Permit Number 39663 | 6003906.83973736 | 2099821.31146391 | 37.745930528166596 | -122.429203495744 | (37.7459305281666, -122.429203495744) | ||
| 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) | |||
| 160458 | 160458 | 106408 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 650 Presidio Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | 5x9 | 5999241.4715 | 2114391.8555 | 37.7856723708173 | -122.44638365037399 | (37.7856723708173, -122.446383650374) | |||
| 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) | |||
| 26569 | 26569 | 32778 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 555 Broderick St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/29/1996 12:00:00 AM | 2 | Permit Number 37147 | 6001101.7087 | 2110645.4763 | 37.775491837653796 | -122.43967909765101 | (37.7754918376538, -122.439679097651) | |
| 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) | |||
| 1873 | 1873 | 20151 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 1043 Steiner St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/13/2016 12:00:00 AM | 3 | 3x3 | Permit Number 778996 | 6002888.3687 | 2111863.5194 | 37.7789378108444 | -122.433585688352 | (37.7789378108444, -122.433585688352) | |
| 4440 | 4440 | 28068 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 3445 Geary Blvd | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3 | 3X3 | 5996452.8473 | 2112841.7002 | 37.78125639187 | -122.455919329089 | (37.78125639187, -122.455919329089) | |||
| 6541 | 6541 | 33662 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 453 Linden St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/11/2016 12:00:00 AM | 3 | Permit Number 37750 | 6005235.3039 | 2110769.7304 | 37.7760674161616 | -122.425388836438 | (37.7760674161616, -122.425388836438) | ||
| 7961 | 7961 | 28067 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 3445 Geary Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3 | 3X3 | 5996427.4656 | 2112840.3465 | 37.7812512181791 | -122.456007038851 | (37.7812512181791, -122.456007038851) | |||
| 8458 | 8458 | 7176 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 821 Fillmore St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3X3 | 6003466.4983 | 2111179.8077 | 37.777093293678206 | -122.43153688437401 | (37.7770932936782, -122.431536884374) | |||
| 9238 | 9238 | 4685 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 716 Columbus Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/14/2012 12:00:00 AM | 3 | 3x3 | 6009342.0114 | 2119967.9552 | 37.801554684737894 | -122.411832709398 | (37.8015546847379, -122.411832709398) | ||
| 17292 | 17292 | 540 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 2869 24th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3 | 3X3 | 6009646.1294 | 2102175.7647 | 37.75271856860871 | -122.409523875049 | (37.7527185686087, -122.409523875049) | |||
| 17307 | 17307 | 15307 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 1650 Mission St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 06/29/2007 12:00:00 AM | 3 | 4X4 | 6006881.466 | 2109048.7514 | 37.771434887034104 | -122.419572183108 | (37.7714348870341, -122.419572183108) | ||
| 17403 | 17403 | 17098 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 1705 Oak St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3X3 | 5998777.5925 | 2109332.4141 | 37.7717539478166 | -122.447624196011 | (37.7717539478166, -122.447624196011) | |||
| 17687 | 17687 | 9652 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 75 Gough St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/07/1995 12:00:00 AM | 3 | 2x3 | 6006083.2108 | 2109791.7339 | 37.773429942464205 | -122.42238619158998 | (37.7734299424642, -122.42238619159) | ||
| 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) | |||
| 155188 | 155188 | 87083 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 1711 Broderick St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/23/2010 12:00:00 AM | 3 | 3x3 | Permit Number 53300 | 6000537.4917 | 2114630.4681 | 37.7864014751637 | -122.44191693732799 | (37.7864014751637, -122.441916937328) | |
| 157150 | 157150 | 43881 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 1245 47th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/03/2000 12:00:00 AM | 3 | Permit Number 43494 | 5981473.1113 | 2106617.2091 | 37.7632946239394 | -122.507278997702 | (37.7632946239394, -122.507278997702) | ||
| 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) | |||
| 21249 | 21249 | 15334 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 1720 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/30/2006 12:00:00 AM | 4 | 3x3 | 6006687.4636 | 2108380.8364 | 37.7695900216736 | -122.420195837478 | (37.7695900216736, -122.420195837478) | ||
| 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) | |||
| 162063 | 162063 | 53066 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 2161 Sutter St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/09/2006 12:00:00 AM | 4 | Permit Number 49038 | 6002280.6463 | 2114328.4092 | 37.7856712745428 | -122.435864451687 | (37.7856712745428, -122.435864451687) | ||
| 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) | |||
| 164557 | 164557 | 59351 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 503 Lyon St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/17/2009 12:00:00 AM | 4 | 3x3 | Permit Number 52085 | 6000121.1922 | 2110676.4601 | 37.7755210539143 | -122.44307315376899 | (37.7755210539143, -122.443073153769) | |
| 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) | |||
| 27948 | 27948 | 58051 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 1609 Polk St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/12/1977 12:00:00 AM | 5 | Permit Number 17020 | 6006619.5836 | 2116449.4594 | 37.791740674082796 | -122.421003598405 | (37.7917406740828, -122.421003598405) | ||
| 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) | |||
| 136991 | 136991 | 66504 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 2456 Bush St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/21/1991 12:00:00 AM | 5 | Permit Number 29667 | 6001757.7853 | 2114663.6996 | 37.786562180873 | -122.437697418913 | (37.786562180873, -122.437697418913) | |
| 162322 | 162322 | 66562 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 144 Collins St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/10/1991 12:00:00 AM | 5 | Permit Number 29750 | 5998095.4621 | 2113585.8052 | 37.783393648613796 | -122.45029037155099 | (37.7833936486138, -122.450290371551) | |
| 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) | |||
| 1064 | 1064 | 7177 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 827 Fillmore St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 3X3 | 6003463.7289 | 2111198.6401 | 37.7771448458144 | -122.431547809387 | (37.7771448458144, -122.431547809387) | |||
| 2173 | 2173 | 21585 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 1500 Sutter St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 2X2 | 6005366.3574 | 2114813.7602 | 37.7871787298771 | -122.425223316098 | (37.7871787298771, -122.425223316098) | |||
| 3990 | 3990 | 21628 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 1615 Sutter St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 06/29/1994 12:00:00 AM | 6 | 4X4 | 6004654.6857 | 2114664.3643 | 37.786728295749896 | -122.427674898563 | (37.7867282957499, -122.427674898563) | ||
| 5382 | 5382 | 7155 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 710 Fillmore St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 3X3 | 6003553.4142 | 2110901.6518 | 37.776334472306 | -122.431216355856 | (37.776334472306, -122.431216355856) |
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");