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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 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) | ||
| 51113 | 51113 | 53752 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 251 Francisco St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/27/1972 12:00:00 AM | 13 | Permit Number 9432 | 6010125.6 | 2121266.3833 | 37.805163775279205 | -122.40921280301701 | (37.8051637752792, -122.409212803017) | ||
| 1336 | 1336 | 7171 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 801 Fillmore St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3x3 | Permit Number 780067 | 6003475.9145 | 2111120.5411 | 37.7769310959731 | -122.431500078765 | (37.7769310959731, -122.431500078765) | ||
| 1340 | 1340 | 7172 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 801 Fillmore St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3x3 | Permit Number 780067 | 6003478.683999999 | 2111101.7087 | 37.7768795438362 | -122.43148915347099 | (37.7768795438362, -122.431489153471) | ||
| 1343 | 1343 | 7169 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 801 Fillmore St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3x3 | Permit Number 780067 | 6003470.3756 | 2111160.9753 | 37.777041804334296 | -122.43152212680799 | (37.7770418043343, -122.431522126808) | ||
| 1345 | 1345 | 7170 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 801 Fillmore St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3x3 | Permit Number 780067 | 6003473.1451 | 2111141.589 | 37.776988731328295 | -122.43151116193 | (37.7769887313283, -122.43151116193) | ||
| 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) | |
| 7264 | 7264 | 121250 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 31 Orben Pl | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | 4x3 | Permit Number 778957 | 6003136.4072 | 2115361.6956 | 37.788556991677495 | -122.432977615629 | (37.7885569916775, -122.432977615629) | ||
| 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) | ||
| 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) | ||
| 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) | ||
| 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) | |||
| 2797 | 2797 | 142505 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 620 Vallejo St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/17/2014 12:00:00 AM | 22 | Width 0ft | Permit Number 774306 | 6010566.6807 | 2118940.2612 | 37.7988015168915 | -122.407522281284 | (37.7988015168915, -122.407522281284) | |
| 3219 | 3219 | 142514 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 624 VALLEJO ST | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/17/2014 12:00:00 AM | 20 | Width 0ft | Permit Number 774306 | 6010535.3238 | 2118936.1488 | 37.7987884700296 | -122.407630496745 | (37.7987884700296, -122.407630496745) | |
| 3249 | 3249 | 142515 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 624 VALLEJO ST | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/17/2014 12:00:00 AM | 21 | Width 0ft | Permit Number 774306 | 6010502.9388 | 2118931.0084 | 37.7987725428783 | -122.40774219721901 | (37.7987725428783, -122.407742197219) | |
| 74568 | 74568 | 97937 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 2133 Stockton St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/02/2011 12:00:00 AM | 8 | 3x3 | Permit Number 768327 | 6009817.5879999995 | 2121415.668 | 37.8055564131765 | -122.410289267199 | (37.8055564131765, -122.410289267199) | |
| 181919 | 181919 | 53486 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 3360 Geary Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/31/1969 12:00:00 AM | 14 | Permit Number 6395 | 5996703.1102 | 2112969.116 | 37.7816206023811 | -122.455062757544 | (37.7816206023811, -122.455062757544) | ||
| 49979 | 49979 | 53483 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 647 Chestnut St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/04/1969 12:00:00 AM | 16 | Permit Number 6392 | 6008737.1169 | 2120721.7235 | 37.80359039074771 | -122.413979278997 | (37.8035903907477, -122.413979278997) | ||
| 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) | |
| 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) | |
| 164818 | 164818 | 87369 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 926 Taraval St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/11/2008 12:00:00 AM | 10 | 3x3 | Permit Number 50349 | 5990243.3148 | 2099080.9621 | 37.7431147521003 | -122.476395524083 | (37.7431147521003, -122.476395524083) | |
| 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) | ||
| 36487 | 36487 | 49516 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 1910@ BUSH ST Steiner St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Permit Number 46422 | 6002507.7627 | 2114881.9371 | 37.7872040200664 | -122.43511829939699 | (37.7872040200664, -122.435118299397) | |||
| 66427 | 66427 | 49435 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 1919 Pierce St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/27/2003 12:00:00 AM | 8 | Permit Number 46373 | 6001939.0069 | 2115153.2685 | 37.7879167140987 | -122.437105502206 | (37.7879167140987, -122.437105502206) | ||
| 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) | |
| 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) | |
| 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) | |
| 39524 | 39524 | 47470 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 2902 Bush St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/14/2002 12:00:00 AM | 14 | Permit Number 45371 | 5999554.6801 | 2114357.1647 | 37.7855950025795 | -122.445297547197 | (37.7855950025795, -122.445297547197) | ||
| 24888 | 24888 | 45611 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 1100 Fillmore St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/06/2001 12:00:00 AM | 16 | Permit Number 44335 | 6003449.1823 | 2112117.4289 | 37.7796667869975 | -122.43166374401001 | (37.7796667869975, -122.43166374401) | ||
| 131817 | 131817 | 45603 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 1100 Fillmore St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/06/2001 12:00:00 AM | 14 | Permit Number 44335 | 6003434.2619 | 2112117.4289 | 37.779665941263104 | -122.43171536011101 | (37.7796659412631, -122.431715360111) | ||
| 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) | ||
| 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) | |||
| 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) | |
| 49361 | 49361 | 38058 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 2844 Bush St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/10/1998 12:00:00 AM | 15 | Permit Number 40253 | 5999884.3012 | 2114402.2303 | 37.7857375510232 | -122.44416039717 | (37.7857375510232, -122.44416039717) | |
| 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) | ||
| 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) | |
| 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) | ||
| 46391 | 46391 | 35162 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 521 Pierce St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/02/1998 12:00:00 AM | 9 | Permit Number 38693 | 6002611.6162 | 2110373.5603 | 37.7748310484791 | -122.434436527113 | (37.7748310484791, -122.434436527113) | |
| 31733 | 31733 | 33694 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 401 Ivy St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/03/1996 12:00:00 AM | 12 | Permit Number 37765 | 6005381.091 | 2111139.6901 | 37.777091471020704 | -122.424910846803 | (37.7770914710207, -122.424910846803) | ||
| 75416 | 75416 | 33693 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 401 Ivy St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/03/1996 12:00:00 AM | 13 | Permit Number 37765 | 6005397.8063 | 2111143.0332 | 37.7771015944949 | -122.42485326118401 | (37.7771015944949, -122.424853261184) | ||
| 169263 | 169263 | 33692 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 401 Ivy St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/03/1996 12:00:00 AM | 11 | Permit Number 37765 | 6005361.9877 | 2111137.3022 | 37.7770838353758 | -122.42497676123001 | (37.7770838353758, -122.42497676123) | ||
| 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) | ||
| 36366 | 36366 | 33642 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 462 Linden St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/03/1996 12:00:00 AM | 10 | Permit Number 37736 | 6005186.1558 | 2110786.6502 | 37.776111096903 | -122.42556005736999 | (37.776111096903, -122.42556005737) | |
| 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) | |
| 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) | |
| 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) | ||
| 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) | ||
| 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) | ||
| 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) | ||
| 30976 | 30976 | 31653 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 1708 Laguna St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/05/1995 12:00:00 AM | 8 | Permit Number 35163 | 6004466.8826 | 2114789.0769 | 37.787060100362794 | -122.428333544653 | (37.7870601003628, -122.428333544653) | ||
| 130563 | 130563 | 31656 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 1708 Laguna St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/05/1995 12:00:00 AM | 9 | 3x3 | Permit Number 35163 | 6004478.3831 | 2114720.074 | 37.7868712864461 | -122.428288835726 | (37.7868712864461, -122.428288835726) | |
| 66174 | 66174 | 30889 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 412 Hayes St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/08/1995 12:00:00 AM | 21 | 4x4 | Permit Number 34719 | 6005803.6075 | 2111060.8215 | 37.776898773465796 | -122.42344361968 | (37.7768987734658, -122.42344361968) | |
| 176429 | 176429 | 30888 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 412 Hayes St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/08/1995 12:00:00 AM | 19 | 4x4 | Permit Number 34719 | 6005821.6341 | 2111061.5148 | 37.7769016945255 | -122.4233813094 | (37.7769016945255, -122.4233813094) | |
| 184098 | 184098 | 30887 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 412 Hayes St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/08/1995 12:00:00 AM | 21 | 4x5 | Permit Number 34719 | 6005841.0474 | 2111067.7548 | 37.7769199237056 | -122.42331459648399 | (37.7769199237056, -122.423314596484) | |
| 165971 | 165971 | 30704 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 369 Oak St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/31/1995 12:00:00 AM | 12 | Permit Number 34615 | 6005232.8948 | 2110236.794 | 37.774603966343605 | -122.42535923638 | (37.7746039663436, -122.42535923638) | |
| 75917 | 75917 | 68430 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 501 Fulton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/26/1993 12:00:00 AM | 6 | Permit Number 32281 | 6005253.5217 | 2111626.0919 | 37.7784198049854 | -122.425386771844 | (37.7784198049854, -122.425386771844) | ||
| 133205 | 133205 | 62731 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 2307 35th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/20/1993 12:00:00 AM | 10 | Permit Number 32015 | 5985442.2939 | 2099497.5593 | 37.7439790107491 | -122.49302661105 | (37.7439790107491, -122.49302661105) | ||
| 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) | |
| 162434 | 162434 | 67469 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 500 Broderick St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/08/1992 12:00:00 AM | 13 | Permit Number 30990 | 6001172.0898 | 2110442.123 | 37.774937486349 | -122.439421053126 | (37.774937486349, -122.439421053126) | |
| 134965 | 134965 | 63910 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 2135 Powell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/18/1991 12:00:00 AM | 14 | Permit Number 30246 | 6009385.3216 | 2121038.8544 | 37.804497537044895 | -122.411758548847 | (37.8044975370449, -122.411758548847) | ||
| 69466 | 69466 | 66825 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 2047 Hayes St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/06/1991 12:00:00 AM | 9 | Permit Number 30121 | 5998040.6169 | 2109928.3267 | 37.77334802445179 | -122.450216391954 | (37.7733480244518, -122.450216391954) | |
| 180558 | 180558 | 66720 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 819 Lyon St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/13/1991 12:00:00 AM | 14 | Permit Number 29962 | 5999956.9512 | 2111893.0193 | 37.778852049002 | -122.44372871968399 | (37.778852049002, -122.443728719684) | ||
| 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) | |
| 57074 | 57074 | 66506 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 2458 Bush St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/21/1991 12:00:00 AM | 15 | Permit Number 29669 | 6001738.4652 | 2114659.4492 | 37.7865494118178 | -122.43776395706001 | (37.7865494118178, -122.43776395706) | |
| 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) | |
| 174672 | 174672 | 66381 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 648 Fillmore St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/04/1991 12:00:00 AM | 13 | Permit Number 29507 | 6003596.4072 | 2110594.4854 | 37.775493505524004 | -122.43104570278601 | (37.775493505524, -122.431045702786) | |
| 60560 | 60560 | 60603 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 630 Fillmore St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/04/1991 12:00:00 AM | 9 | Permit Number 29505 | 6003603.285 | 2110552.7276 | 37.775379238631004 | -122.431018929857 | (37.775379238631, -122.431018929857) | |
| 131001 | 131001 | 66378 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 624 Fillmore St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/22/1992 12:00:00 AM | 8 | Permit Number 29503 | 6003604.7588 | 2110527.1817 | 37.7753091794017 | -122.43101200799299 | (37.7753091794017, -122.431012007993) | |
| 155737 | 155737 | 64843 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 618 Fillmore St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/04/1991 12:00:00 AM | 11 | Permit Number 29500 | 6003607.7064 | 2110511.4611 | 37.7752661815317 | -122.431000689329 | (37.7752661815317, -122.431000689329) | |
| 161016 | 161016 | 66368 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 5 Cook St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/04/1991 12:00:00 AM | 10 | Permit Number 29490 | 5997440.3621 | 2113655.9431 | 37.7835487164216 | -122.452561811691 | (37.7835487164216, -122.452561811691) | |
| 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) | |
| 35499 | 35499 | 66182 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 1819 Laguna St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/06/1990 12:00:00 AM | 12 | Permit Number 29259 | 6004371.7533 | 2115130.5363 | 37.7879922787707 | -122.42868702120701 | (37.7879922787707, -122.428687021207) | ||
| 53528 | 53528 | 65955 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 1234 Grove St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/21/1990 12:00:00 AM | 13 | Permit Number 28976 | 6001892.8907 | 2110857.546 | 37.7761191282962 | -122.436957400422 | (37.7761191282962, -122.436957400422) | ||
| 47060 | 47060 | 65627 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 2116 Sutter St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/21/1990 12:00:00 AM | 12 | 6x6 | Permit Number 28535 | 6002451.5098 | 2114409.7678 | 37.7859043690694 | -122.435279135393 | (37.7859043690694, -122.435279135393) |
| 181868 | 181868 | 65538 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 2180 Sutter St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/20/1990 12:00:00 AM | 16 | 6x6 | Permit Number 28435 | 6002182.4791 | 2114372.5672 | 37.7857869442252 | -122.43620724273501 | (37.7857869442252, -122.436207242735) |
| 35309 | 35309 | 64038 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 16 Loyola Ter | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/12/1988 12:00:00 AM | 10 | Permit Number 25745 | 5998453.4174 | 2110814.7286 | 37.7758054707119 | -122.44885232426 | (37.7758054707119, -122.44885232426) | ||
| 54324 | 54324 | 58879 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 2900 Bush St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/18/1988 12:00:00 AM | 13 | Permit Number 25516 | 5999589.5873 | 2114362.4153 | 37.785611411881106 | -122.44517715647801 | (37.7856114118811, -122.445177156478) | ||
| 164315 | 164315 | 64505 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 412 Broderick St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/20/1988 12:00:00 AM | 9 | Permit Number 25386 | 6001213.6317 | 2110153.0182 | 37.7741460412807 | -122.439256624823 | (37.7741460412807, -122.439256624823) | |
| 25536 | 25536 | 59622 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 448 Broderick St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/20/1988 12:00:00 AM | 8 | Permit Number 25385 | 6001193.7685 | 2110273.1905 | 37.7744748738878 | -122.439333950555 | (37.7744748738878, -122.439333950555) | |
| 25581 | 25581 | 64501 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 545 Broderick St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/09/1989 12:00:00 AM | 13 | Permit Number 25381 | 6001107.084 | 2110608.9242 | 37.7753917807448 | -122.439657882213 | (37.7753917807448, -122.439657882213) | |
| 29034 | 29034 | 64425 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 259 Francisco St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/09/1988 12:00:00 AM | 9 | Permit Number 25277 | 6010096.4211 | 2121261.5999 | 37.8051490065079 | -122.409313442808 | (37.8051490065079, -122.409313442808) | ||
| 174864 | 174864 | 64376 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 69 Beaumont Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/21/1988 12:00:00 AM | 11 | Permit Number 25215 | 5996673.1599 | 2112554.0417 | 37.7804791997483 | -122.45513636713801 | (37.7804791997483, -122.455136367138) | ||
| 147652 | 147652 | 64012 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 10 Loyola Ter | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/08/1987 12:00:00 AM | 10 | Permit Number 24766 | 5998456.7381 | 2110792.4322 | 37.7757444404433 | -122.44883923078999 | (37.7757444404433, -122.44883923079) | ||
| 175202 | 175202 | 63909 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 2119 Powell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/03/1987 12:00:00 AM | 12 | Permit Number 24624 | 6009399.6734 | 2120957.786 | 37.804275748547504 | -122.41170315133301 | (37.8042757485475, -122.411703151333) | ||
| 29179 | 29179 | 63908 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 2125 Powell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/03/1987 12:00:00 AM | 14 | Permit Number 24623 | 6009389.9763 | 2121003.9446 | 37.8044019445665 | -122.411739972568 | (37.8044019445665, -122.411739972568) | ||
| 166843 | 166843 | 63488 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 811 Lyon St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/07/1987 12:00:00 AM | 12 | Permit Number 24085 | 5999970.1497 | 2111784.3859 | 37.7785545222825 | -122.443675254762 | (37.7785545222825, -122.443675254762) | |
| 152460 | 152460 | 62957 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 159 Clayton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/18/1986 12:00:00 AM | 12 | Permit Number 23343 | 5998260.9157 | 2110109.071 | 37.7738569063547 | -122.449467376934 | (37.7738569063547, -122.449467376934) | ||
| 137082 | 137082 | 62689 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 523 Union St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/12/1986 12:00:00 AM | 14 | Permit Number 23025 | 6010433.276000001 | 2119569.2907 | 37.8005212097535 | -122.408028291205 | (37.8005212097535, -122.408028291205) | ||
| 165188 | 165188 | 62369 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 137 Clayton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/10/1985 12:00:00 AM | 9 | 3x3 | Permit Number 22515 | 5998258.1694 | 2110129.1192 | 37.773911796453596 | -122.44947832162799 | (37.7739117964536, -122.449478321628) | |
| 71959 | 71959 | 62365 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 2132 Sutter St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/09/1985 12:00:00 AM | 14 | 6x4 | Permit Number 22511 | 6002365.7866 | 2114401.6807 | 37.7858772955002 | -122.43557513482 | (37.7858772955002, -122.43557513482) | |
| 166552 | 166552 | 62362 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 1905 Laguna St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/09/1985 12:00:00 AM | 13 | Permit Number 22507 | 6004330.152000001 | 2115433.2423 | 37.7888210787145 | -122.42885254308399 | (37.7888210787145, -122.428852543084) | ||
| 177440 | 177440 | 61824 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 568 Hayes St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/04/1985 12:00:00 AM | 19 | Permit Number 21857 | 6005139.9121 | 2110969.4321 | 37.7766103583758 | -122.425733039566 | (37.7766103583758, -122.425733039566) | ||
| 64657 | 64657 | 61337 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 650 Presidio Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/22/1984 12:00:00 AM | 10 | 5x6 | Permit Number 21242 | 5999250.392000001 | 2114334.8634 | 37.785516394870896 | -122.446348686743 | (37.7855163948709, -122.446348686743) | |
| 171478 | 171478 | 61148 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 2237 Fulton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/28/1983 12:00:00 AM | 7 | Permit Number 21005 | 5997050.2982 | 2110479.7459 | 37.7748053558267 | -122.453681848705 | (37.7748053558267, -122.453681848705) | ||
| 60145 | 60145 | 61078 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 2590 Post St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/01/1983 12:00:00 AM | 13 | Permit Number 20915 | 5999806.8161 | 2113697.9026 | 37.7837992291467 | -122.44437783777398 | (37.7837992291467, -122.444377837774) | ||
| 26993 | 26993 | 101263 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 2000 Irving St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Permit Number 20727 | 5989478.8752 | 2106534.6445 | 37.76353621964879 | -122.479583963683 | (37.7635362196488, -122.479583963683) | |||
| 165135 | 165135 | 101264 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 2000 Irving St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Permit Number 20727 | 5989453.6006 | 2106533.1127 | 37.7635305455459 | -122.479671267422 | (37.7635305455459, -122.479671267422) | |||
| 171803 | 171803 | 60926 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 2000 Irving St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/13/1983 12:00:00 AM | 13 | Permit Number 20727 | 5989507.2134 | 2106536.1763 | 37.7635420716385 | -122.479486064031 | (37.7635420716385, -122.479486064031) | ||
| 171274 | 171274 | 59153 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 20 Bellair Pl | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/23/1982 12:00:00 AM | 11 | Permit Number 19779 | 6010063.4155 | 2121130.5341 | 37.8047872831513 | -122.40941840765801 | (37.8047872831513, -122.409418407658) |
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");