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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 71189 | 71189 | 107181 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 1520 PAGE ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | 6x9 | 5999172.7 | 2109108.7 | 37.7711622584795 | -122.44624140323401 | (37.7711622584795, -122.446241403234) | |||
| 72097 | 72097 | 176499 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 162 Brookdale Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 6ft | 6005745.58119 | 2087451.7768599999 | 37.7120704261874 | -122.421966828522 | (37.7120704261874, -122.421966828522) | |||
| 72606 | 72606 | 219001 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 1225 05th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 2ft | 5994518.05416 | 2107169.56941 | 37.7655709877426 | -122.46220122250799 | (37.7655709877426, -122.462201222508) | |||
| 73383 | 73383 | 225950 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 646 Douglass St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6001193.5542 | 2102647.97152 | 37.7535378869843 | -122.438788164466 | (37.7535378869843, -122.438788164466) | |||
| 73632 | 73632 | 87141 | Permitted Site 1 | Geijera parviflora :: Australian Willow 68 | 169 11th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/29/2011 12:00:00 AM | 12 | 3x3 | Permit Number 767576 | 6007945.36003 | 2109780.43285 | 37.7735037807007 | -122.415943932067 | (37.7735037807007, -122.415943932067) |
| 76270 | 76270 | 67546 | Permitted Site 1 | Geijera parviflora :: Australian Willow 68 | 1139 Rhode Island St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/05/1992 12:00:00 AM | 19 | Permit Number 31092 | 6011964.43282 | 2103102.09088 | 37.755391686497205 | -122.40157181880501 | (37.7553916864972, -122.401571818805) | |
| 76670 | 76670 | 225926 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 448 Valley St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 6002953.29528 | 2099219.1530400002 | 37.7442231148112 | -122.43245771787 | (37.7442231148112, -122.43245771787) | |||
| 77013 | 77013 | 56360 | Permitted Site 1 | Geijera parviflora :: Australian Willow 68 | 2100 Divisadero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/08/2001 12:00:00 AM | 30 | Permit Number 12506 | 6000958.47841613 | 2115569.02150374 | 37.7890024802988 | -122.440527774143 | (37.7890024802988, -122.440527774143) | |
| 77438 | 77438 | 51908 | Permitted Site 1 | Geijera parviflora :: Australian Willow 68 | 490X Noe St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/15/2009 12:00:00 AM | 3 | 3x3 | Permit Number 52601 | 6002971.47862471 | 2105361.83743697 | 37.7610905025589 | -122.43283358188299 | (37.7610905025589, -122.432833581883) |
| 77631 | 77631 | 52211 | Permitted Site 1 | Geijera parviflora :: Australian Willow 68 | 3778 20th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/29/2005 12:00:00 AM | Permit Number 48395 | 6005137.28408737 | 2104311.29818782 | 37.758328569096 | -122.425268231472 | (37.758328569096, -122.425268231472) | ||
| 77677 | 77677 | 67084 | Permitted Site 1 | Geijera parviflora :: Australian Willow 68 | 200 Bennington St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/23/1992 12:00:00 AM | Permit Number 30482 | 6007092.73898781 | 2097018.14574656 | 37.738413501248004 | -122.417988384197 | (37.738413501248, -122.417988384197) | ||
| 77679 | 77679 | 73660 | Permitted Site 1 | Geijera parviflora :: Australian Willow 68 | 157 Miramar Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/14/2013 12:00:00 AM | 15 | Permit Number 770522 | 5995314.794096599 | 2090940.29616255 | 37.72105528015361 | -122.45827073660101 | (37.7210552801536, -122.458270736601) | ||
| 78037 | 78037 | 102652 | Permitted Site 1 | Geijera parviflora :: Australian Willow 68 | 203X Farallones St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5994989.5 | 2088377.3 | 37.7139992025898 | -122.45920967451401 | (37.7139992025898, -122.459209674514) | |||||
| 78504 | 78504 | 59406 | Permitted Site 1 | Geijera parviflora :: Australian Willow 68 | 31 Milton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/22/1993 12:00:00 AM | Permit Number 770712 | 6003751.60013387 | 2095492.67978387 | 37.73403630788339 | -122.42943165971 | (37.7340363078834, -122.42943165971) | ||
| 78703 | 78703 | 105804 | Permitted Site 1 | Geijera parviflora :: Australian Willow 68 | 117 ALPINE TER | 1 | Front Yard : Cutout 8 | Tree 1 | Private 1 | 04/10/2014 12:00:00 AM | 14 | 3x3 | Permit Number 772090 | 6001724.2 | 2108149.5 | 37.7686739192463 | -122.437346990121 | (37.7686739192463, -122.437346990121) | |
| 78706 | 78706 | 36064 | Permitted Site 1 | Geijera parviflora :: Australian Willow 68 | 1398 Bryant St | 1 | 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) | |||
| 79347 | 79347 | 32986 | Permitted Site 1 | Geijera parviflora :: Australian Willow 68 | 10X Sierra St | 1 | 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) | |
| 79458 | 79458 | 45143 | Permitted Site 1 | Geijera parviflora :: Australian Willow 68 | 1306 Page St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/18/2001 12:00:00 AM | Permit Number 43999 | 6000301.66695276 | 2109252.99284462 | 37.7716228610878 | -122.442346636259 | (37.7716228610878, -122.442346636259) | ||
| 79956 | 79956 | 67927 | Permitted Site 1 | Geijera parviflora :: Australian Willow 68 | 123 Milton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/22/1993 12:00:00 AM | Permit Number 31640 | 6003789.22877148 | 2095116.32621568 | 37.733005056394795 | -122.429274738173 | (37.7330050563948, -122.429274738173) | ||
| 80611 | 80611 | 117516 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 1115 YORK ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | 3x3 | 6010054.0 | 2102576.0 | 37.753840371529705 | -122.40814160377899 | (37.7538403715297, -122.408141603779) | |||
| 81265 | 81265 | 10174 | DPW Maintained 3 | Geijera parviflora :: Australian Willow 68 | 1038 Guerrero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 28 | 2x2 | 6005692.3267338 | 2102916.9952861997 | 37.7545314795937 | -122.423249534916 | (37.7545314795937, -122.423249534916) | |||
| 81416 | 81416 | 66557 | Permitted Site 1 | Geijera parviflora :: Australian Willow 68 | 3772 20th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/10/1991 12:00:00 AM | Permit Number 29741 | 6005175.23956871 | 2104313.40408574 | 37.758336495615204 | -122.42513711444799 | (37.7583364956152, -122.425137114448) | ||
| 81707 | 81707 | 35398 | Permitted Site 1 | Geijera parviflora :: Australian Willow 68 | 540 29th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/16/1998 12:00:00 AM | Permit Number 38853 | 6003072.48314636 | 2098933.73753739 | 37.743446188104 | -122.43202521517 | (37.743446188104, -122.43202521517) | ||
| 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) | ||
| 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) | ||
| 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) | |||
| 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) | |
| 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) | ||
| 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) | |||
| 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) | |
| 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) | ||
| 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) | ||
| 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) | |
| 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) | ||
| 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) | ||
| 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) | |
| 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) | ||
| 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) | |||
| 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) | |
| 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) | |||
| 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) | ||
| 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) | ||
| 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) | ||||
| 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) | ||
| 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) | ||
| 128600 | 128600 | 95394 | Permitted Site 1 | Geijera parviflora :: Australian Willow 68 | 208 Day St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/24/2011 12:00:00 AM | 3x3 | Permit Number 767264 | 6004579.0 | 2098715.0 | 37.742930879183604 | -122.426800483584 | (37.7429308791836, -122.426800483584) | |
| 128826 | 128826 | 41155 | Permitted Site 1 | Geijera parviflora :: Australian Willow 68 | 21 Cook St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/22/1999 12:00:00 AM | Permit Number 41884 | 5997452.09163541 | 2113544.02640038 | 37.7832420947214 | -122.452513152989 | (37.7832420947214, -122.452513152989) | |||
| 129311 | 129311 | 94960 | Permitted Site 1 | Geijera parviflora :: Australian Willow 68 | 20 Belvedere St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5998206.0 | 2108519.0 | 37.7694878371786 | -122.44954274107599 | (37.7694878371786, -122.449542741076) | ||||
| 129531 | 129531 | 59939 | Permitted Site 1 | Geijera parviflora :: Australian Willow 68 | 1778 Hayes St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/25/1981 12:00:00 AM | 1 | Permit Number 19412 | 5999341.88585809 | 2110158.12282899 | 37.7740533674999 | -122.44573166712699 | (37.7740533674999, -122.445731667127) | |
| 129939 | 129939 | 225921 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 300 Montcalm St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6009716.79458 | 2099617.55194 | 37.7456982412969 | -122.40909900491998 | (37.7456982412969, -122.40909900492) | |||
| 130263 | 130263 | 192406 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 718 De Haro St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 23 | 6012081.21103 | 2105020.2958 | 37.7606651697825 | -122.401302754214 | (37.7606651697825, -122.401302754214) | ||||
| 130418 | 130418 | 225976 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 348 Eureka St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6001460.81775 | 2103733.76138 | 37.7565344055496 | -122.437941677576 | (37.7565344055496, -122.437941677576) | |||
| 130450 | 130450 | 225902 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 44 Camp St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 3ft | 6005679.36245 | 2106382.2556 | 37.7640455405875 | -122.423540717652 | (37.7640455405875, -122.423540717652) | |||
| 131204 | 131204 | 140348 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 1314 ELLIS ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 0ft | 6004545.774 | 2113311.1445 | 37.7830065306397 | -122.427955242977 | (37.7830065306397, -122.427955242977) | |||
| 131309 | 131309 | 225935 | Permitted Site 1 | Geijera parviflora :: Australian Willow 68 | 1250 Treat Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/15/2001 12:00:00 AM | 10 | Width 3ft | Permit Number 33274 | 6008670.4768900005 | 2101262.07632 | 37.7501550682215 | -122.412833276033 | (37.7501550682215, -122.412833276033) | |
| 131682 | 131682 | 225928 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 1106 Cole St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 5998173.76607 | 2106499.88804 | 37.763942024132206 | -122.44950872894199 | (37.7639420241322, -122.449508728942) | |||
| 131813 | 131813 | 82990 | Permitted Site 1 | Geijera parviflora :: Australian Willow 68 | 737 Clementina St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/18/2008 12:00:00 AM | 4 | 3x3 | Permit Number 50125 | 6009298.17418 | 2110240.35937 | 37.774842595135205 | -122.41129682837901 | (37.7748425951352, -122.411296828379) | |
| 133410 | 133410 | 59942 | Permitted Site 1 | Geijera parviflora :: Australian Willow 68 | 625 Central Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/25/1981 12:00:00 AM | 13 | Permit Number 19416 | 5999638.7469 | 2110673.4971 | 37.775485398815796 | -122.444741829234 | (37.7754853988158, -122.444741829234) | |
| 133714 | 133714 | 49835 | Permitted Site 1 | Geijera parviflora :: Australian Willow 68 | 587 Pennsylvania Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/11/2003 12:00:00 AM | 11 | Permit Number 46618 | 6014427.95757 | 2104386.8638299997 | 37.759056552429705 | -122.393142029905 | (37.7590565524297, -122.393142029905) | |
| 134760 | 134760 | 225975 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 4337 19th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 3ft | 6001561.548219999 | 2104657.76141 | 37.7590772134726 | -122.437659488305 | (37.7590772134726, -122.437659488305) | |||
| 136428 | 136428 | 245455 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 2800 16th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 0ft | 6007994.6854 | 2106818.5473 | 37.7653739107422 | -122.41556356407 | (37.7653739107422, -122.41556356407) | |||
| 139759 | 139759 | 69160 | Permitted Site 1 | Geijera parviflora :: Australian Willow 68 | 3272 25th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/26/1994 12:00:00 AM | Permit Number 33197 | 6007895.60997349 | 2101540.97783702 | 37.750877345046604 | -122.415532563624 | (37.7508773450466, -122.415532563624) |
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");