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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 82775 | 82775 | 51909 | Permitted Site 1 | Geijera parviflora :: Australian Willow 68 | 490X Noe St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/18/2005 12:00:00 AM | 3 | 3x3 | Permit Number 48114 | 6002971.47862471 | 2105361.83743697 | 37.7610905025589 | -122.43283358188299 | (37.7610905025589, -122.432833581883) | |
| 83461 | 83461 | 32486 | Permitted Site 1 | Geijera parviflora :: Australian Willow 68 | 212 States St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/10/1996 12:00:00 AM | Permit Number 36993 | 6000839.718784099 | 2106514.92813142 | 37.764135468546904 | -122.440289096409 | (37.7641354685469, -122.440289096409) | ||
| 83486 | 83486 | 108472 | Permitted Site 1 | Geijera parviflora :: Australian Willow 68 | 462 09th Ave | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 3x3 | Permit Number 773779 | 5993142.3505 | 2112335.01081 | 37.7796746015568 | -122.467335065866 | (37.7796746015568, -122.467335065866) | |||
| 83663 | 83663 | 60140 | Permitted Site 1 | Geijera parviflora :: Australian Willow 68 | 1807 16th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/28/1982 12:00:00 AM | Permit Number 19670 | 5991211.56683637 | 2103102.96288703 | 37.7542142276367 | -122.473340885597 | (37.7542142276367, -122.473340885597) | ||
| 83684 | 83684 | 34073 | Permitted Site 1 | Geijera parviflora :: Australian Willow 68 | 2055 Folsom St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/05/1997 12:00:00 AM | Permit Number 37966 | 6008112.18575803 | 2106463.32400128 | 37.764405154005 | -122.415132009891 | (37.764405154005, -122.415132009891) | ||
| 83902 | 83902 | 113388 | Permitted Site 1 | Geijera parviflora :: Australian Willow 68 | 185 CASTENADA AVE | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 5994493.0 | 2100782.0 | 37.7480309194949 | -122.461824674651 | (37.7480309194949, -122.461824674651) | ||||
| 83940 | 83940 | 32089 | Permitted Site 1 | Geijera parviflora :: Australian Willow 68 | 3976 19th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/09/1995 12:00:00 AM | Permit Number 35462 | 6003168.80356063 | 2104788.27114216 | 37.7595268169135 | -122.43211015988899 | (37.7595268169135, -122.432110159889) | ||
| 84306 | 84306 | 60044 | Permitted Site 1 | Geijera parviflora :: Australian Willow 68 | 126 Fairmount St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/14/2008 12:00:00 AM | 3x3 | Permit Number 51412 | 6004702.07588502 | 2097279.21146554 | 37.7389954885734 | -122.426272720335 | (37.7389954885734, -122.426272720335) | ||
| 84403 | 84403 | 6257 | DPW Maintained 3 | Geijera parviflora :: Australian Willow 68 | 1324X Ellis St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6004503.4535 | 2113305.70612 | 37.782989203891 | -122.428101266861 | (37.782989203891, -122.428101266861) | |||
| 85572 | 85572 | 115126 | Permitted Site 1 | Geijera parviflora :: Australian Willow 68 | 499X MAIN ST | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | 6015842.0 | 2114626.0 | 37.7872494168956 | -122.388966430338 | (37.7872494168956, -122.388966430338) | ||||
| 85922 | 85922 | 33910 | Permitted Site 1 | Geijera parviflora :: Australian Willow 68 | 1456 Fulton St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/05/1997 12:00:00 AM | Permit Number 37880 | 6000788.78339737 | 2111054.09529381 | 37.776595986143796 | -122.440790896143 | (37.7765959861438, -122.440790896143) | |||
| 87311 | 87311 | 29766 | DPW Maintained 3 | Geijera parviflora :: Australian Willow 68 | 570 Francisco St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 4x4 | 6008571.0386595 | 2121096.2836166 | 37.8046095098754 | -122.414580523895 | (37.8046095098754, -122.414580523895) | |||
| 87659 | 87659 | 71877 | Permitted Site 1 | Geijera parviflora :: Australian Willow 68 | 157 Miramar Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/14/2013 12:00:00 AM | 10 | Permit Number 770522 | 5995314.794096599 | 2090940.29616255 | 37.72105528015361 | -122.45827073660101 | (37.7210552801536, -122.458270736601) | ||
| 87942 | 87942 | 67933 | Permitted Site 1 | Geijera parviflora :: Australian Willow 68 | 114 Rousseau St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/22/1993 12:00:00 AM | Permit Number 31646 | 6003490.581697099 | 2095075.42432118 | 37.73287583730961 | -122.43030432183001 | (37.7328758373096, -122.43030432183) | ||
| 89137 | 89137 | 95571 | Permitted Site 1 | Geijera parviflora :: Australian Willow 68 | 960 Noe St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/02/2011 12:00:00 AM | 3x3 | Permit Number 767362 | 6003109.0 | 2102648.0 | 37.753646751876296 | -122.43216414381901 | (37.7536467518763, -122.432164143819) | |
| 89572 | 89572 | 105311 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 455 17TH AVE | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 4x3 | 5990571.2 | 2112282.7 | 37.77938220530879 | -122.476225875432 | (37.7793822053088, -122.476225875432) | |||
| 90002 | 90002 | 10124 | DPW Maintained 3 | Geijera parviflora :: Australian Willow 68 | 877 Guerrero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3 | 3X3 | 6005714.7162163 | 2103867.2939474997 | 37.7571420422058 | -122.42323965318998 | (37.7571420422058, -122.42323965319) | |||
| 90319 | 90319 | 421 | DPW Maintained 3 | Geijera parviflora :: Australian Willow 68 | 685X Guerrero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 2X2 | 6005653.198434 | 2104994.6037312 | 37.7602338989595 | -122.423532549649 | (37.7602338989595, -122.423532549649) | |||
| 90348 | 90348 | 36002 | Permitted Site 1 | Geijera parviflora :: Australian Willow 68 | 183 Precita Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/27/1998 12:00:00 AM | Permit Number 39151 | 6007567.43623945 | 2100291.02417946 | 37.747426802297 | -122.416578887563 | (37.747426802297, -122.416578887563) | ||
| 90483 | 90483 | 47716 | Permitted Site 1 | Geijera parviflora :: Australian Willow 68 | 47 Milton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/22/2002 12:00:00 AM | Permit Number 45512 | 6003756.95954941 | 2095440.56895285 | 37.7338935267661 | -122.42940941566499 | (37.7338935267661, -122.429409415665) | ||
| 90827 | 90827 | 93902 | Permitted Site 1 | Geijera parviflora :: Australian Willow 68 | 546 Page St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/07/2011 12:00:00 AM | 3x3 | Permit Number 768056 | 6003947.0 | 2109752.0 | 37.773200107256606 | -122.42977281454901 | (37.7732001072566, -122.429772814549) | ||
| 91176 | 91176 | 32985 | Permitted Site 1 | Geijera parviflora :: Australian Willow 68 | 10X Sierra St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/01/1996 12:00:00 AM | 5x9 | Permit Number 37296 | 6013812.07366772 | 2104214.5102771 | 37.7585490739971 | -122.395259990599 | (37.7585490739971, -122.395259990599) | |
| 91267 | 91267 | 34040 | Permitted Site 1 | Geijera parviflora :: Australian Willow 68 | 2741 16th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/05/1997 12:00:00 AM | Permit Number 37955 | 6008443.32721054 | 2106790.24036099 | 37.7653213944342 | -122.414009808345 | (37.7653213944342, -122.414009808345) | ||
| 92009 | 92009 | 98256 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 2800X 16th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | 3x3 | 6007899.1 | 2106885.5 | 37.7655523739417 | -122.41589891426099 | (37.7655523739417, -122.415898914261) | |||
| 92381 | 92381 | 108167 | Permitted Site 1 | Geijera parviflora :: Australian Willow 68 | 2x FRANCONIA ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 6009908.0 | 2100009.0 | 37.7467837814289 | -122.40846544893999 | (37.7467837814289, -122.40846544894) | ||||
| 92783 | 92783 | 50169 | Permitted Site 1 | Geijera parviflora :: Australian Willow 68 | 89@ DUBOCE Alpine Ter | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/14/2003 12:00:00 AM | Permit Number 46880 | 6001684.35285968 | 2108342.8233287 | 37.7692024719005 | -122.437498663894 | (37.7692024719005, -122.437498663894) | |||
| 93765 | 93765 | 52137 | Permitted Site 1 | Geijera parviflora :: Australian Willow 68 | 541 Steiner St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/26/2005 12:00:00 AM | 4 | 3x3 | Permit Number 48316 | 6003127.26918681 | 2110108.47893411 | 37.774132457488896 | -122.432633838295 | (37.7741324574889, -122.432633838295) | |
| 93780 | 93780 | 48957 | Permitted Site 1 | Geijera parviflora :: Australian Willow 68 | 1521 Florida St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/26/2002 12:00:00 AM | Permit Number 46145 | 6009607.60540748 | 2100518.70293664 | 37.7481664860313 | -122.40954015648 | (37.7481664860313, -122.40954015648) | |||
| 94395 | 94395 | 105962 | Permitted Site 1 | Geijera parviflora :: Australian Willow 68 | 10X Sierra St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5x9 | 6013706.37383 | 2104134.52437 | 37.758323571072204 | -122.39561994684401 | (37.7583235710722, -122.395619946844) | ||||
| 94408 | 94408 | 69223 | Permitted Site 1 | Geijera parviflora :: Australian Willow 68 | 1256 Treat Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/31/1994 12:00:00 AM | Permit Number 33275 | 6008667.10840058 | 2101226.16540452 | 37.7500562758063 | -122.41284238591601 | (37.7500562758063, -122.412842385916) | ||
| 95253 | 95253 | 32807 | Permitted Site 1 | Geijera parviflora :: Australian Willow 68 | 1686 Hayes St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/29/1996 12:00:00 AM | Permit Number 37166 | 5999791.91343358 | 2110220.51293563 | 37.7742503589901 | -122.44417943364999 | (37.7742503589901, -122.44417943365) | ||
| 95370 | 95370 | 72237 | Permitted Site 1 | Geijera parviflora :: Australian Willow 68 | 365 Hill St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/09/2009 12:00:00 AM | 3x3 | Permit Number 53060 | 6003968.6918684 | 2103317.11324706 | 37.7555326838578 | -122.429238846799 | (37.7555326838578, -122.429238846799) | ||
| 95415 | 95415 | 34747 | Permitted Site 1 | Geijera parviflora :: Australian Willow 68 | 2747 Harrison St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/28/1997 12:00:00 AM | Permit Number 38395 | 6008968.42681544 | 2102467.18370323 | 37.7534807427404 | -122.41188809190201 | (37.7534807427404, -122.411888091902) | ||
| 95528 | 95528 | 113389 | Permitted Site 1 | Geijera parviflora :: Australian Willow 68 | 185 CASTENADA AVE | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 5994493.0 | 2100782.0 | 37.7480309194949 | -122.461824674651 | (37.7480309194949, -122.461824674651) | ||||
| 95529 | 95529 | 67080 | Permitted Site 1 | Geijera parviflora :: Australian Willow 68 | 343 Bennington St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/23/1992 12:00:00 AM | Permit Number 30477 | 6007097.80000141 | 2096683.93673196 | 37.7374961220492 | -122.417947200602 | (37.7374961220492, -122.417947200602) | ||
| 95785 | 95785 | 69219 | Permitted Site 1 | Geijera parviflora :: Australian Willow 68 | 1232 Treat Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/31/1994 12:00:00 AM | Permit Number 33271 | 6008659.77445957 | 2101360.31284296 | 37.7504242029934 | -122.412877230419 | (37.7504242029934, -122.412877230419) | ||
| 96915 | 96915 | 103262 | Permitted Site 1 | Geijera parviflora :: Australian Willow 68 | 53 Woodward St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/30/2014 12:00:00 AM | 3 | 3x3 | Permit Number 770698 | 6006511.0 | 2108178.0 | 37.769023136516 | -122.420791817714 | (37.769023136516, -122.420791817714) | |
| 97628 | 97628 | 102653 | Permitted Site 1 | Geijera parviflora :: Australian Willow 68 | 203X Farallones St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5994989.5 | 2088377.3 | 37.7139992025898 | -122.45920967451401 | (37.7139992025898, -122.459209674514) | ||||
| 97711 | 97711 | 62524 | Permitted Site 1 | Geijera parviflora :: Australian Willow 68 | 342 Scott St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/02/1998 12:00:00 AM | Permit Number 38698 | 6002273.08197673 | 2109652.09551148 | 37.7728308633198 | -122.43555596174299 | (37.7728308633198, -122.435555961743) | ||
| 98596 | 98596 | 115128 | Private 5 | Geijera parviflora :: Australian Willow 68 | 499X MAIN ST | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | 6015842.0 | 2114626.0 | 37.7872494168956 | -122.388966430338 | (37.7872494168956, -122.388966430338) | ||||
| 98661 | 98661 | 45152 | Permitted Site 1 | Geijera parviflora :: Australian Willow 68 | 1619 Alabama St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/22/2001 12:00:00 AM | Permit Number 44005 | 6009316.84366878 | 2099994.11121489 | 37.7467097764312 | -122.410508567135 | (37.7467097764312, -122.410508567135) | ||
| 100066 | 100066 | 48959 | Permitted Site 1 | Geijera parviflora :: Australian Willow 68 | 1521 Florida St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/26/2002 12:00:00 AM | Permit Number 46145 | 6009607.60540748 | 2100518.70293664 | 37.7481664860313 | -122.40954015648 | (37.7481664860313, -122.40954015648) | |||
| 101465 | 101465 | 96194 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 1640 Jerrold Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 4x50 | 6015077.4 | 2097255.4 | 37.7395111076977 | -122.39039765239299 | (37.7395111076977, -122.390397652393) | |||
| 101490 | 101490 | 34074 | Permitted Site 1 | Geijera parviflora :: Australian Willow 68 | 2055 Folsom St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/05/1997 12:00:00 AM | Permit Number 37966 | 6008112.18575803 | 2106463.32400128 | 37.764405154005 | -122.415132009891 | (37.764405154005, -122.415132009891) | ||
| 101741 | 101741 | 95562 | Permitted Site 1 | Geijera parviflora :: Australian Willow 68 | 467 Duncan St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/02/2011 12:00:00 AM | 3x3 | Permit Number 767356 | 6003496.0 | 2099787.0 | 37.7458130504625 | -122.430621674841 | (37.7458130504625, -122.430621674841) | |
| 103290 | 103290 | 62468 | Permitted Site 1 | Geijera parviflora :: Australian Willow 68 | 400 Cole St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/04/2011 12:00:00 AM | Permit Number 767707 | 5997942.58905548 | 2109236.69156954 | 37.7714433619175 | -122.45050561148199 | (37.7714433619175, -122.450505611482) | |||
| 104406 | 104406 | 95583 | Permitted Site 1 | Geijera parviflora :: Australian Willow 68 | 320 Hill St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/02/2011 12:00:00 AM | 3x3 | Permit Number 767373 | 6004245.0 | 2103375.0 | 37.7557072655698 | -122.428287412943 | (37.7557072655698, -122.428287412943) | |
| 104521 | 104521 | 115129 | Private 5 | Geijera parviflora :: Australian Willow 68 | 499X MAIN ST | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 6015842.0 | 2114626.0 | 37.7872494168956 | -122.388966430338 | (37.7872494168956, -122.388966430338) | ||||
| 105535 | 105535 | 10695 | DPW Maintained 3 | Geijera parviflora :: Australian Willow 68 | 1250 Hayes St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6001856.34415 | 2110522.16346 | 37.7751961745675 | -122.43705980731701 | (37.7751961745675, -122.437059807317) | |||
| 106102 | 106102 | 34039 | Permitted Site 1 | Geijera parviflora :: Australian Willow 68 | 2741 16th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/05/1997 12:00:00 AM | Permit Number 37955 | 6008443.32721054 | 2106790.24036099 | 37.7653213944342 | -122.414009808345 | (37.7653213944342, -122.414009808345) | ||
| 106266 | 106266 | 65468 | Permitted Site 1 | Geijera parviflora :: Australian Willow 68 | 55 Granada Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/08/1989 12:00:00 AM | Permit Number 28348 | 5995598.18541989 | 2090265.07086982 | 37.7192175521634 | -122.457242320925 | (37.7192175521634, -122.457242320925) | ||
| 106631 | 106631 | 59938 | Permitted Site 1 | Geijera parviflora :: Australian Willow 68 | 1774 Hayes St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/25/1981 12:00:00 AM | Permit Number 19411 | 5999360.65261909 | 2110160.72458075 | 37.774061582719895 | -122.44566693704701 | (37.7740615827199, -122.445666937047) | ||
| 107237 | 107237 | 65670 | Permitted Site 1 | Geijera parviflora :: Australian Willow 68 | 954 Teresita Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/13/1990 12:00:00 AM | Permit Number 28590 | 5998557.99448518 | 2095716.03586207 | 37.7343541747365 | -122.44740356075899 | (37.7343541747365, -122.447403560759) | ||
| 107364 | 107364 | 26544 | DPW Maintained 3 | Geijera parviflora :: Australian Willow 68 | 530 Francisco St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 06/19/1997 12:00:00 AM | 3 | 4X4 | 6008751.4918274 | 2121120.9717011 | 37.8046874335197 | -122.41395779393 | (37.8046874335197, -122.41395779393) | ||
| 107909 | 107909 | 98179 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 50-60 Camp St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6005725.0 | 2106380.0 | 37.7640419231114 | -122.423382710222 | (37.7640419231114, -122.423382710222) | ||||
| 109039 | 109039 | 46907 | Permitted Site 1 | Geijera parviflora :: Australian Willow 68 | 1461 07th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/29/2002 12:00:00 AM | Permit Number 44964 | 5993949.00931755 | 2105566.46922701 | 37.7611365120681 | -122.464053023285 | (37.7611365120681, -122.464053023285) | ||
| 109049 | 109049 | 38842 | Permitted Site 1 | Geijera parviflora :: Australian Willow 68 | 1273 Hayes St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Permit Number 40672 | 6001780.14804372 | 2110445.45784357 | 37.7749812288155 | -122.437317892677 | (37.7749812288155, -122.437317892677) | ||||
| 109428 | 109428 | 85304 | Permitted Site 1 | Geijera parviflora :: Australian Willow 68 | 417 Ashbury St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/31/2007 12:00:00 AM | Permit Number 49590 | 5998857.0 | 2109314.0 | 37.7717079252645 | -122.44734819583599 | (37.7717079252645, -122.447348195836) | |||
| 110418 | 110418 | 29761 | DPW Maintained 3 | Geijera parviflora :: Australian Willow 68 | 500 Francisco St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 3x3 | 6008886.831703201 | 2121139.4877643995 | 37.804745874094294 | -122.4134907456 | (37.8047458740943, -122.4134907456) | |||
| 110666 | 110666 | 98258 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 2800X 16th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | 3x3 | 6007899.1 | 2106885.5 | 37.7655523739417 | -122.41589891426099 | (37.7655523739417, -122.415898914261) | |||
| 110815 | 110815 | 42034 | Permitted Site 1 | Geijera parviflora :: Australian Willow 68 | 357 29th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/29/2008 12:00:00 AM | 5 | 3x3 | Permit Number 50466 | 6004260.0 | 2098933.0 | 37.743511415711104 | -122.427919028307 | (37.7435114157111, -122.427919028307) | |
| 111305 | 111305 | 98257 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 2800X 16th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | 3x3 | 6007899.1 | 2106885.5 | 37.7655523739417 | -122.41589891426099 | (37.7655523739417, -122.415898914261) | |||
| 111886 | 111886 | 98260 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 2800X 16th St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | 3x3 | 6007899.1 | 2106885.5 | 37.7655523739417 | -122.41589891426099 | (37.7655523739417, -122.415898914261) | |||
| 112121 | 112121 | 59771 | Permitted Site 1 | Geijera parviflora :: Australian Willow 68 | 38 Newman St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/23/1992 12:00:00 AM | Permit Number 30471 | 6006914.85070557 | 2096794.9528112998 | 37.737790649484296 | -122.41858761398001 | (37.7377906494843, -122.41858761398) | ||
| 113742 | 113742 | 35091 | Permitted Site 1 | Geijera parviflora :: Australian Willow 68 | 920 Kirkham St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/20/2000 12:00:00 AM | 15 | 3x3 | Permit Number 42238 | 5992055.93239281 | 2105259.4330846 | 37.760184186645105 | -122.47057793992701 | (37.7601841866451, -122.470577939927) |
| 113830 | 113830 | 66548 | Permitted Site 1 | Geijera parviflora :: Australian Willow 68 | 3444 22nd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/10/1991 12:00:00 AM | Permit Number 29730 | 6005443.81991983 | 2103160.76453772 | 37.755186785440294 | -122.42412627289801 | (37.7551867854403, -122.424126272898) | ||
| 114017 | 114017 | 52023 | Permitted Site 1 | Geijera parviflora :: Australian Willow 68 | 20 Newman St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/15/2005 12:00:00 AM | Permit Number 48238 | 6006866.55802505 | 2096801.82623419 | 37.7378068034281 | -122.41875507285299 | (37.7378068034281, -122.418755072853) | ||
| 114440 | 114440 | 67087 | Permitted Site 1 | Geijera parviflora :: Australian Willow 68 | 2x FRANCONIA ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/23/1992 12:00:00 AM | Permit Number 30488 | 6009949.0 | 2099997.0 | 37.74675312806 | -122.40832282803001 | (37.74675312806, -122.40832282803) | ||
| 114949 | 114949 | 60696 | Permitted Site 1 | Geijera parviflora :: Australian Willow 68 | 2839 22nd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/05/1983 12:00:00 AM | Permit Number 20342 | 6009224.45070504 | 2103317.03242809 | 37.7558285965659 | -122.411062726793 | (37.7558285965659, -122.411062726793) | ||
| 116317 | 116317 | 114483 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 784 CLEMENTINA ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | 3x2 | 6009096.0 | 2110140.0 | 37.7745556909018 | -122.41198909995701 | (37.7745556909018, -122.411989099957) | |||
| 116480 | 116480 | 94704 | Permitted Site 1 | Geijera parviflora :: Australian Willow 68 | 670 12th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/28/2010 12:00:00 AM | 2 | 3x3 | Permit Number 53844 | 5992265.910069999 | 2110887.9473900003 | 37.7756507238334 | -122.470261618584 | (37.7756507238334, -122.470261618584) |
| 116534 | 116534 | 69220 | Permitted Site 1 | Geijera parviflora :: Australian Willow 68 | 1244 Treat Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/31/1994 12:00:00 AM | 3x3 | Permit Number 33272 | 6008663.44143065 | 2101293.23911329 | 37.7502402393754 | -122.412859808121 | (37.7502402393754, -122.412859808121) | |
| 117059 | 117059 | 35576 | Permitted Site 1 | Geijera parviflora :: Australian Willow 68 | 85 Liberty St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/23/1998 12:00:00 AM | Permit Number 38944 | 6005785.83921356 | 2104003.6408016 | 37.7575204324701 | -122.42300337283999 | (37.7575204324701, -122.42300337284) | ||
| 117209 | 117209 | 35153 | Permitted Site 1 | Geijera parviflora :: Australian Willow 68 | 546 Page St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/02/1998 12:00:00 AM | Permit Number 38684 | 6003946.04415605 | 2109759.28063083 | 37.7732200439593 | -122.429776640335 | (37.7732200439593, -122.429776640335) | ||
| 117714 | 117714 | 60139 | Permitted Site 1 | Geijera parviflora :: Australian Willow 68 | 1825 16th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/28/1982 12:00:00 AM | Permit Number 19669 | 5991215.553912099 | 2102985.82371421 | 37.753892825076704 | -122.473318554461 | (37.7538928250767, -122.473318554461) | ||
| 117939 | 117939 | 67684 | Permitted Site 1 | Geijera parviflora :: Australian Willow 68 | 312 Joost Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/05/1992 12:00:00 AM | 3.5x6 | Permit Number 31288 | 6000001.77226965 | 2094984.07917219 | 37.7324267912213 | -122.44235943700701 | (37.7324267912213, -122.442359437007) | ||
| 118429 | 118429 | 59772 | Permitted Site 1 | Geijera parviflora :: Australian Willow 68 | 131 Newman St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/25/1981 12:00:00 AM | Permit Number 19217 | 6007221.04974766 | 2096803.89603525 | 37.7378324395755 | -122.417529566585 | (37.7378324395755, -122.417529566585) | ||
| 118437 | 118437 | 57311 | Permitted Site 1 | Geijera parviflora :: Australian Willow 68 | 50- 60 Camp St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/27/1976 12:00:00 AM | Permit Number 16134 | 6005724.56470965 | 2106391.56239992 | 37.764073646157996 | -122.423385037786 | (37.764073646158, -122.423385037786) | |||
| 118833 | 118833 | 98259 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 2800X 16TH ST | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | 3x3 | 6008057.0 | 2106814.0 | 37.7653649274264 | -122.415347709739 | (37.7653649274264, -122.415347709739) | |||
| 119140 | 119140 | 46336 | Permitted Site 1 | Geijera parviflora :: Australian Willow 68 | 3458 26th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/13/2002 12:00:00 AM | Permit Number 44586 | 6006755.84747481 | 2100893.1278825 | 37.7490343653145 | -122.41942802130501 | (37.7490343653145, -122.419428021305) | ||
| 121204 | 121204 | 68770 | Permitted Site 1 | Geijera parviflora :: Australian Willow 68 | 616 Noe St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/16/1993 12:00:00 AM | Permit Number 32698 | 6002993.73826974 | 2104676.98539815 | 37.7592113259791 | -122.432707672319 | (37.7592113259791, -122.432707672319) | ||
| 121526 | 121526 | 105214 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 2400X 21ST AVE | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | 3x3 | 5989837.0 | 2098691.0 | 37.7420204448441 | -122.477771936587 | (37.7420204448441, -122.477771936587) | |||
| 121618 | 121618 | 95169 | Permitted Site 1 | Geijera parviflora :: Australian Willow 68 | 195x BARTLETT ST | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | Permit Number 54079 | 6006751.0 | 2102668.0 | 37.7539074858503 | -122.41957069165701 | (37.7539074858503, -122.419570691657) | |||
| 121755 | 121755 | 36066 | Permitted Site 1 | Geijera parviflora :: Australian Willow 68 | 1398 Bryant St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/28/1998 12:00:00 AM | Permit Number 39186 | 6009394.0 | 2107812.0 | 37.76818025927739 | -122.410793808029 | (37.7681802592774, -122.410793808029) | |||
| 121812 | 121812 | 29765 | DPW Maintained 3 | Geijera parviflora :: Australian Willow 68 | 570 Francisco St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 4x4 | 6008571.0386595 | 2121096.2836166 | 37.8046095098754 | -122.414580523895 | (37.8046095098754, -122.414580523895) | |||
| 121878 | 121878 | 67769 | Permitted Site 1 | Geijera parviflora :: Australian Willow 68 | 3668 16th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/15/1992 12:00:00 AM | Permit Number 31399 | 6002481.45062456 | 2106510.50272194 | 37.7642166536125 | -122.43461051210501 | (37.7642166536125, -122.434610512105) | ||
| 122436 | 122436 | 35092 | Permitted Site 1 | Geijera parviflora :: Australian Willow 68 | 920 Kirkham St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/26/1998 12:00:00 AM | 25 | 3x3 | Permit Number 38633 | 5992055.93239281 | 2105259.4330846 | 37.760184186645105 | -122.47057793992701 | (37.7601841866451, -122.470577939927) | |
| 122979 | 122979 | 37469 | Permitted Site 1 | Geijera parviflora :: Australian Willow 68 | 557 Peralta Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/19/1998 12:00:00 AM | Permit Number 39940 | 6009863.21581356 | 2098931.68283254 | 37.7438231962188 | -122.408544326388 | (37.7438231962188, -122.408544326388) | ||
| 123059 | 123059 | 98178 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 44- 46 Camp St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6005746.0 | 2106381.0 | 37.7640458540826 | -122.42331014839701 | (37.7640458540826, -122.423310148397) | ||||
| 123160 | 123160 | 94129 | Permitted Site 1 | Geijera parviflora :: Australian Willow 68 | 420 Holladay Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/11/2010 12:00:00 AM | 3x3 | Permit Number 53495 | 6010221.9 | 2098587.9 | 37.7428993246027 | -122.407279845082 | (37.7428993246027, -122.407279845082) | ||
| 123727 | 123727 | 142340 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 520 Central Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 0ft | 5999729.6682 | 2110321.6281 | 37.774524444251206 | -122.444402018718 | (37.7745244442512, -122.444402018718) | |||
| 124344 | 124344 | 36067 | Permitted Site 1 | Geijera parviflora :: Australian Willow 68 | 1398 Bryant St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/28/1998 12:00:00 AM | Permit Number 39186 | 6009394.0 | 2107812.0 | 37.76818025927739 | -122.410793808029 | (37.7681802592774, -122.410793808029) | |||
| 124791 | 124791 | 105310 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 355 17TH AVE | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3 x4 | 5990544.7 | 2113008.3 | 37.781372965217 | -122.476370566984 | (37.781372965217, -122.476370566984) | |||
| 125022 | 125022 | 67067 | Permitted Site 1 | Geijera parviflora :: Australian Willow 68 | 22 Newman St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/22/1992 12:00:00 AM | Permit Number 30456 | 6006871.92388007 | 2096801.0625202998 | 37.7378050085566 | -122.418736466303 | (37.7378050085566, -122.418736466303) | ||
| 125703 | 125703 | 69447 | Permitted Site 1 | Geijera parviflora :: Australian Willow 68 | 479 32nd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/16/1994 12:00:00 AM | Permit Number 33557 | 5985917.32246977 | 2112668.61009419 | 37.7801708274431 | -122.492353790965 | (37.7801708274431, -122.492353790965) | ||
| 126187 | 126187 | 29763 | DPW Maintained 3 | Geijera parviflora :: Australian Willow 68 | 530 Francisco St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 3x3 | 6008751.4918274 | 2121120.9717011 | 37.8046874335197 | -122.41395779393 | (37.8046874335197, -122.41395779393) | |||
| 126970 | 126970 | 49877 | Permitted Site 1 | Geijera parviflora :: Australian Willow 68 | 1331@ IRVING 10th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/30/2003 12:00:00 AM | Permit Number 46643 | 5992989.81423972 | 2106408.90402865 | 37.763394289018294 | -122.467431700246 | (37.7633942890183, -122.467431700246) | |||
| 127688 | 127688 | 48958 | Permitted Site 1 | Geijera parviflora :: Australian Willow 68 | 1521 Florida St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/26/2002 12:00:00 AM | Permit Number 46145 | 6009607.60540748 | 2100518.70293664 | 37.7481664860313 | -122.40954015648 | (37.7481664860313, -122.40954015648) | |||
| 127899 | 127899 | 36001 | Permitted Site 1 | Geijera parviflora :: Australian Willow 68 | 172 Precita Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/27/1998 12:00:00 AM | Permit Number 39150 | 6007547.55752373 | 2100224.75713647 | 37.7472437298861 | -122.41664293336001 | (37.7472437298861, -122.41664293336) | ||
| 128111 | 128111 | 39576 | Permitted Site 1 | Geijera parviflora :: Australian Willow 68 | 300 Montcalm St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/28/1998 12:00:00 AM | Permit Number 40993 | 6009738.16770437 | 2099629.76502916 | 37.7457329730731 | -122.409025961078 | (37.7457329730731, -122.409025961078) |
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");