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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 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) | ||
| 128278 | 128278 | 32806 | Permitted Site 1 | Geijera parviflora :: Australian Willow 68 | 1686 Hayes St | 2 | 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) | ||
| 35324 | 35324 | 245162 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 1308 Page St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 0ft | 6000247.8581 | 2109240.6853 | 37.7715860006418 | -122.44253187989901 | (37.7715860006418, -122.442531879899) | |||
| 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) | ||
| 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) | ||
| 10930 | 10930 | 109686 | Permitted Site 1 | Geijera parviflora :: Australian Willow 68 | 190 Onondaga Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/27/2015 12:00:00 AM | 3 | 3x3 | Permit Number 772797 | 6000260.82873 | 2091434.8524 | 37.7226961949641 | -122.441209260793 | (37.7226961949641, -122.441209260793) |
| 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) | |||
| 129969 | 129969 | 225951 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 4401 24th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6000607.24532 | 2101675.7007299997 | 37.750834892731596 | -122.440746005644 | (37.7508348927316, -122.440746005644) | |||
| 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) | |
| 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) | ||
| 27127 | 27127 | 225952 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 800 Alvarado St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6001178.257669999 | 2102625.59939 | 37.753475588250396 | -122.438839459988 | (37.7534755882504, -122.438839459988) | |||
| 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) | |||
| 70033 | 70033 | 128871 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 2610 Clay St | 21 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 19 | Width 5ft | 6001562.056059999 | 2116003.40074 | 37.790229524119795 | -122.438470613846 | (37.7902295241198, -122.438470613846) | |||
| 181461 | 181461 | 128870 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 2610 Clay St | 20 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 5ft | 6001597.99168 | 2116010.93406 | 37.790252252691495 | -122.43834681946501 | (37.7902522526915, -122.438346819465) | |||
| 186358 | 186358 | 128869 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 2610 Clay St | 19 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 5ft | 6001642.59008 | 2116017.92803 | 37.7902739929064 | -122.438193013824 | (37.7902739929064, -122.438193013824) | |||
| 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) | |||
| 180600 | 180600 | 128868 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 2610 Clay St | 17 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 6001720.521000001 | 2116028.9102 | 37.790308579028 | -122.43792416596202 | (37.790308579028, -122.437924165962) | |||
| 53402 | 53402 | 128867 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 2610 Clay St | 16 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6001756.03579 | 2116033.5731 | 37.7903234016642 | -122.437801621649 | (37.7903234016642, -122.437801621649) | |||
| 162647 | 162647 | 47473 | Permitted Site 1 | Geijera parviflora :: Australian Willow 68 | 2713 Clay St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/14/2002 12:00:00 AM | 3 | Permit Number 45374 | 6001758.37714 | 2115982.9514900004 | 37.790184540925395 | -122.43778989361601 | (37.7901845409254, -122.437789893616) | |
| 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) | |||
| 157898 | 157898 | 128866 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 2610 Clay St | 15 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 3ft | 6001800.9878 | 2116040.20004 | 37.790344153503604 | -122.43764656594 | (37.7903441535036, -122.43764656594) | |||
| 29018 | 29018 | 247759 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 75 Alpine Ter | 1 | : 4 | Tree 1 | Private 1 | 10 | Width 3ft | 6001668.74952 | 2108376.80716 | 37.7692948959648 | -122.437555068929 | (37.7692948959648, -122.437555068929) | |||
| 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) | |||
| 169326 | 169326 | 128865 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 2610 Clay St | 13 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 3ft | 6001864.710469999 | 2116045.7184900003 | 37.7903629286659 | -122.437426485651 | (37.7903629286659, -122.437426485651) | |||
| 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) | |
| 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) | ||||
| 5795 | 5795 | 10694 | DPW Maintained 3 | Geijera parviflora :: Australian Willow 68 | 1250 Hayes St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6001838.4236 | 2110502.6134 | 37.7751414763631 | -122.43712039839399 | (37.7751414763631, -122.437120398394) | |||
| 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) | |||
| 7187 | 7187 | 22760 | DPW Maintained 3 | Geijera parviflora :: Australian Willow 68 | 1620 Turk St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3 | 4X4 | 6002287.3238 | 2112301.156 | 37.7801053300032 | -122.43569625863701 | (37.7801053300032, -122.435696258637) | |||
| 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) | ||
| 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) | ||
| 65167 | 65167 | 225973 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 478 Noe St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6002948.31867 | 2105450.2559599997 | 37.761331964925 | -122.432919999069 | (37.761331964925, -122.432919999069) | |||
| 73222 | 73222 | 225974 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 478 Noe St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6002948.609680001 | 2105430.29379 | 37.761277170124394 | -122.43291756641001 | (37.7612771701244, -122.43291756641) | |||
| 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) |
| 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) | |
| 23948 | 23948 | 32109 | Permitted Site 1 | Geijera parviflora :: Australian Willow 68 | 431 Noe St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/09/1995 12:00:00 AM | 11 | Permit Number 35479 | 6002988.87793 | 2105732.43045 | 37.7621090484283 | -122.43279988020299 | (37.7621090484283, -122.432799880203) | |
| 69483 | 69483 | 32107 | Permitted Site 1 | Geijera parviflora :: Australian Willow 68 | 429 Noe St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/09/1995 12:00:00 AM | 10 | Permit Number 35478 | 6002990.68319 | 2105750.27702 | 37.7621581531882 | -122.432794911471 | (37.7621581531882, -122.432794911471) | |
| 61608 | 61608 | 32108 | Permitted Site 1 | Geijera parviflora :: Australian Willow 68 | 431 Noe St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/09/1995 12:00:00 AM | 11 | Permit Number 35479 | 6002991.887619999 | 2105721.63802 | 37.7620795857172 | -122.432788699839 | (37.7620795857172, -122.432788699839) | |
| 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) | ||
| 158147 | 158147 | 247455 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 541 Steiner St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 0ft | 6003122.801 | 2110193.1484 | 37.7743646855214 | -122.432655343876 | (37.7743646855214, -122.432655343876) | |||
| 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) | |
| 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) | |||
| 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) | |
| 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) | ||
| 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) | ||
| 70913 | 70913 | 32088 | Permitted Site 1 | Geijera parviflora :: Australian Willow 68 | 3972 19th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/09/1995 12:00:00 AM | 12 | Permit Number 35461 | 6003219.31552 | 2104788.31954 | 37.759529813480604 | -122.43193546805901 | (37.7595298134806, -122.431935468059) | |
| 31018 | 31018 | 244415 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 630 Page St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 0ft | 6003443.0612 | 2109684.1199 | 37.7729851758016 | -122.43151115772899 | (37.7729851758016, -122.431511157729) | |||
| 177519 | 177519 | 225979 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 171 Germania St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 6003500.9012 | 2108793.5344 | 37.7705431243846 | -122.431247500167 | (37.7705431243846, -122.431247500167) | |||
| 151104 | 151104 | 225972 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 111 Hancock St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6003502.63381 | 2105046.7258599997 | 37.760255392804496 | -122.430974055914 | (37.7602553928045, -122.430974055914) | |||
| 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) | |
| 185415 | 185415 | 246444 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 467 Duncan St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 1 | Width 3ft | 6003499.43256 | 2099785.6606799997 | 37.7458095674622 | -122.430609709989 | (37.7458095674622, -122.430609709989) | |||
| 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) | ||
| 53261 | 53261 | 225947 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 114 Rousseau St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 2ft | 6003497.57041 | 2095097.9657299998 | 37.7329381267755 | -122.430281767707 | (37.7329381267755, -122.430281767707) | |||
| 184026 | 184026 | 225978 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 737 Sanchez St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 22 | Width 3ft | 6003705.65415 | 2103955.3434599997 | 37.757270218256394 | -122.430194042444 | (37.7572702182564, -122.430194042444) | |||
| 65253 | 65253 | 225977 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 310 Liberty St | 61 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 14 | Width 3ft | 6003712.20285 | 2103924.7270400003 | 37.7571865237503 | -122.43016921035499 | (37.7571865237503, -122.430169210355) | |||
| 81680 | 81680 | 34425 | Permitted Site 1 | Geijera parviflora :: Australian Willow 68 | 245 Roanoke St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/04/2008 12:00:00 AM | 3x3 | Permit Number 50336 | 6003617.84008567 | 2095979.02625995 | 37.735364130918796 | -122.429928789613 | (37.7353641309188, -122.429928789613) | ||
| 25801 | 25801 | 225955 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 245 Roanoke St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6003637.7380800005 | 2095933.74555 | 37.735240927214704 | -122.42985676608299 | (37.7352409272147, -122.429856766083) | |||
| 39534 | 39534 | 244202 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 546 Page St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 0ft | 6003923.0756 | 2109749.7244 | 37.7731925042221 | -122.429855409854 | (37.7731925042221, -122.429855409854) | |||
| 66905 | 66905 | 244210 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 546 Page St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 0ft | 6003934.6479 | 2109752.6175 | 37.7732011032912 | -122.429815586143 | (37.7732011032912, -122.429815586143) | |||
| 149617 | 149617 | 225954 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 245 Roanoke St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6003654.86904 | 2095911.56632 | 37.735180998192206 | -122.429795956641 | (37.7351809981922, -122.429795956641) | |||
| 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) | ||
| 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) | ||
| 163367 | 163367 | 225953 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 245 Roanoke St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6003670.68661 | 2095891.30011 | 37.735126247484104 | -122.42973982455901 | (37.7351262474841, -122.429739824559) | |||
| 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) | ||
| 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) | ||
| 152964 | 152964 | 225949 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 119 Milton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 2ft | 6003777.8476 | 2095128.93714 | 37.733039038820294 | -122.429314984812 | (37.7330390388203, -122.429314984812) | |||
| 66285 | 66285 | 225948 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 123 Milton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 2ft | 6003779.75499 | 2095097.5175400001 | 37.732952875676496 | -122.429306150766 | (37.7329528756765, -122.429306150766) | |||
| 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) | ||
| 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) | ||
| 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) | |
| 148398 | 148398 | 225925 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 357 29th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6004205.07883 | 2098948.09387 | 37.743549752810296 | -122.428110007472 | (37.7435497528103, -122.428110007472) | |||
| 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) | |||
| 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) | |||
| 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) | |
| 183419 | 183419 | 128864 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 628 Buchanan St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 4ft | 6004541.11924 | 2110775.90598 | 37.7760451281037 | -122.42779064652599 | (37.7760451281037, -122.427790646526) | |||
| 147884 | 147884 | 142233 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 600 BUCHANAN ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 0ft | 6004546.0223 | 2110772.1475 | 37.7760350855974 | -122.427773417679 | (37.7760350855974, -122.427773417679) | |||
| 59849 | 59849 | 128863 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 628 Buchanan St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 4ft | 6004545.79116 | 2110745.60377 | 37.7759621899439 | -122.42777232553499 | (37.7759621899439, -122.427772325535) | |||
| 167999 | 167999 | 142232 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 600 BUCHANAN ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 0ft | 6004552.0651 | 2110734.2793 | 37.775931450627205 | -122.427749815271 | (37.7759314506272, -122.427749815271) | |||
| 130809 | 130809 | 142235 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 689 HAYES ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 0ft | 6004665.6696 | 2110849.8982 | 37.7762553374912 | -122.42736506585 | (37.7762553374912, -122.42736506585) | |||
| 153603 | 153603 | 128862 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 689 Hayes St | 2 | : 4 | Tree 1 | Private 1 | 3 | Width 3ft | 6004674.24665 | 2110845.64244 | 37.7762441372985 | -122.427335092236 | (37.7762441372985, -122.427335092236) | |||
| 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) | |
| 140768 | 140768 | 115822 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 122 COLLEGE AVE | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 24 | 3x3 | 6004593.0 | 2095924.0 | 37.7352682180932 | -122.42655338079099 | (37.7352682180932, -122.426553380791) | |||
| 27086 | 27086 | 225956 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 126 Fairmount St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6004690.92985 | 2097272.0847099996 | 37.738975290087104 | -122.426310750952 | (37.7389752900871, -122.426310750952) | |||
| 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) | ||
| 36653 | 36653 | 225927 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 172 Day St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 4ft | 6004830.8864400005 | 2098735.49496 | 37.7430013921091 | -122.425930987935 | (37.7430013921091, -122.425930987935) | |||
| 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) | ||
| 162031 | 162031 | 225916 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 3778 20th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 6005165.83624 | 2104308.70302 | 37.758323056384796 | -122.425169300823 | (37.7583230563848, -122.425169300823) | |||
| 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) | ||
| 19662 | 19662 | 10000 | Permitted Site 1 | Geijera parviflora :: Australian Willow 68 | 136 Guerrero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 90 | 2X2 | 6005403.547780001 | 2108183.22689 | 37.7689750062251 | -122.424622801709 | (37.7689750062251, -122.424622801709) | |||
| 20120 | 20120 | 10020 | Permitted Site 1 | Geijera parviflora :: Australian Willow 68 | 250 Guerrero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 32 | 2x2 | 6005442.42406 | 2107520.98643 | 37.767158847823 | -122.42444122050101 | (37.767158847823, -122.424441220501) | |||
| 161173 | 161173 | 225924 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 145 Guerrero St | 6 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 18 | Width 2ft | 6005469.65475 | 2108205.8081400003 | 37.7690407421536 | -122.424395748072 | (37.7690407421536, -122.424395748072) | |||
| 21505 | 21505 | 10026 | Permitted Site 1 | Geijera parviflora :: Australian Willow 68 | 290 Guerrero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 24 | 2x3 | 6005455.03663 | 2107324.1386599997 | 37.7666190630424 | -122.424383592842 | (37.7666190630424, -122.424383592842) | |||
| 21713 | 21713 | 10001 | DPW Maintained 3 | Geijera parviflora :: Australian Willow 68 | 145 Guerrero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X2 | 6005474.27283 | 2108090.23028 | 37.768723653813204 | -122.42437155270201 | (37.7687236538132, -122.424371552702) | |||
| 39266 | 39266 | 225908 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 3772 25th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 4ft | 6005343.316000001 | 2101393.98229 | 37.7503299359862 | -122.424348189214 | (37.7503299359862, -122.424348189214) | |||
| 44681 | 44681 | 225910 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 99 Fair Oaks St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 5ft | 6005408.28506 | 2103204.3544 | 37.7553044666341 | -122.42425226303101 | (37.7553044666341, -122.424252263031) | |||
| 144912 | 144912 | 93025 | Permitted Site 1 | Geijera parviflora :: Australian Willow 68 | 3772 25th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6005372.0 | 2101391.0 | 37.7503233669919 | -122.424248785816 | (37.7503233669919, -122.424248785816) | |||||
| 134421 | 134421 | 225909 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 99 Fair Oaks St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 5ft | 6005410.68329 | 2103188.80406 | 37.755261904439394 | -122.424242863321 | (37.7552619044394, -122.424242863321) | |||
| 21573 | 21573 | 10054 | DPW Maintained 3 | Geijera parviflora :: Australian Willow 68 | 426 Guerrero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 80 | 3X2 | 6005501.955709999 | 2106458.62904 | 37.764245228771 | -122.42415974799201 | (37.764245228771, -122.424159747992) | |||
| 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) | ||
| 19491 | 19491 | 10032 | Permitted Site 1 | Geijera parviflora :: Australian Willow 68 | 315 Guerrero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 3X2 | 6005527.20527 | 2107119.43239 | 37.7660610633959 | -122.424119414293 | (37.7660610633959, -122.424119414293) |
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");