Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, SiteOrder, qSiteInfo, qCaretaker, PlotSize
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes ▲ | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 3164 | 3164 | 10171 | Permitted Site 1 | Geijera parviflora :: Australian Willow 68 | 1032 Guerrero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/23/2017 12:00:00 AM | 3 | 2x3 | Permit Number 779560 | 6005695.79144 | 2102951.17521 | 37.7546255252659 | -122.423239982539 | (37.7546255252659, -122.423239982539) | |
| 9818 | 9818 | 46930 | Permitted Site 1 | Geijera parviflora :: Australian Willow 68 | 1 Pacheco St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/29/2016 12:00:00 AM | 3 | Permit Number 779184 | 5995168.47040897 | 2099126.50126016 | 37.743524195830396 | -122.459369067857 | (37.7435241958304, -122.459369067857) | |
| 9820 | 9820 | 46927 | Permitted Site 1 | Geijera parviflora :: Australian Willow 68 | 1 Pacheco St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/29/2016 12:00:00 AM | 3 | Permit Number 779184 | 5995168.47040897 | 2099126.50126016 | 37.743524195830396 | -122.459369067857 | (37.7435241958304, -122.459369067857) | |
| 9821 | 9821 | 46929 | Permitted Site 1 | Geijera parviflora :: Australian Willow 68 | 1 Pacheco St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/29/2016 12:00:00 AM | 3 | Permit Number 779184 | 5995168.47040897 | 2099126.50126016 | 37.743524195830396 | -122.459369067857 | (37.7435241958304, -122.459369067857) | |
| 9825 | 9825 | 46928 | Permitted Site 1 | Geijera parviflora :: Australian Willow 68 | 1 Pacheco St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/29/2016 12:00:00 AM | 3 | Permit Number 779184 | 5995168.47040897 | 2099126.50126016 | 37.743524195830396 | -122.459369067857 | (37.7435241958304, -122.459369067857) | ||
| 142869 | 142869 | 116342 | Permitted Site 1 | Geijera parviflora :: Australian Willow 68 | 611 YORK ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/10/2016 12:00:00 AM | 3 | 3x3 | Permit Number 778005 | 6009887.0 | 2105445.0 | 37.7617086481783 | -122.40892153916599 | (37.7617086481783, -122.408921539166) | |
| 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) | |||
| 9953 | 9953 | 107188 | Permitted Site 1 | Geijera parviflora :: Australian Willow 68 | 1500 PAGE ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/15/2014 12:00:00 AM | 3 | 3x3 | Permit Number 773122 | 5999274.2 | 2109122.8 | 37.771206769657205 | -122.445891326497 | (37.7712067696572, -122.445891326497) | |
| 14322 | 14322 | 115881 | Permitted Site 1 | Geijera parviflora :: Australian Willow 68 | 1663 La Salle Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/01/2016 12:00:00 AM | 3 | Permit Number 773046 | 6015043.9945 | 2096491.0960099997 | 37.737410632491 | -122.39045976502199 | (37.737410632491, -122.390459765022) | ||
| 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) |
| 11919 | 11919 | 108571 | Permitted Site 1 | Geijera parviflora :: Australian Willow 68 | 223 Sweeny St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/24/2014 12:00:00 AM | 3 | 3x3 | Permit Number 772573 | 6009406.56 | 2094751.33642 | 37.732319284403204 | -122.409828317318 | (37.7323192844032, -122.409828317318) |
| 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) | |
| 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) | ||
| 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) | |
| 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) | ||
| 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) | ||
| 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) | ||
| 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) | |||
| 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) |
| 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) | |
| 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) | |
| 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) | |
| 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) | |
| 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) | |||
| 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) |
| 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) | ||
| 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) | ||
| 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) |
| 186145 | 186145 | 81695 | Permitted Site 1 | Geijera parviflora :: Australian Willow 68 | 539 17th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/09/2009 12:00:00 AM | 5 | 3x3 | Permit Number 52514 | 5990609.143069999 | 2111709.86868 | 37.7778115687685 | -122.476052767078 | (37.7778115687685, -122.476052767078) | |
| 154398 | 154398 | 82843 | Permitted Site 1 | Geijera parviflora :: Australian Willow 68 | 719 Clementina St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/07/2009 12:00:00 AM | 4 | 3x3 | Permit Number 52435 | 6009401.3474 | 2110338.98679 | 37.7751191888227 | -122.410946896775 | (37.7751191888227, -122.410946896775) | |
| 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) | ||
| 154004 | 154004 | 81925 | Permitted Site 1 | Geijera parviflora :: Australian Willow 68 | 2316 Leavenworth St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/04/2008 12:00:00 AM | 6 | 3x3 | Permit Number 50640 | 6007582.8644 | 2120346.37282 | 37.80249487840621 | -122.417947010953 | (37.8024948784062, -122.417947010953) | |
| 163455 | 163455 | 82278 | Permitted Site 1 | Geijera parviflora :: Australian Willow 68 | 245 10th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/03/2008 12:00:00 AM | 5 | 3x3 | Permit Number 50610 | 5992733.47806 | 2113805.1753 | 37.783687659814795 | -122.46885653402398 | (37.7836876598148, -122.468856534024) | |
| 50087 | 50087 | 84421 | Permitted Site 1 | Geijera parviflora :: Australian Willow 68 | 3450 19th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/02/2008 12:00:00 AM | 3x3 | Permit Number 50587 | 6006545.62237249 | 2104975.62835635 | 37.7602321285391 | -122.420444723128 | (37.7602321285391, -122.420444723128) | ||
| 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) | |
| 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) | ||
| 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) | |
| 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) | |||
| 183815 | 183815 | 51725 | Permitted Site 1 | Geijera parviflora :: Australian Willow 68 | 1904 20th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/22/2005 12:00:00 AM | 6 | Permit Number 48537 | 6012320.61849 | 2104715.4197400003 | 37.7598414015724 | -122.40045333106701 | (37.7598414015724, -122.400453331067) | ||
| 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) | ||
| 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) | |
| 1016 | 1016 | 225959 | Permitted Site 1 | Geijera parviflora :: Australian Willow 68 | 20 Newman St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/15/2005 12:00:00 AM | 12 | Width 3ft | Permit Number 48238 | 6006979.14621 | 2096796.63822 | 37.7377988968125 | -122.41836543223101 | (37.7377988968125, -122.418365432231) | |
| 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) | ||
| 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) | |
| 141466 | 141466 | 51066 | Permitted Site 1 | Geijera parviflora :: Australian Willow 68 | 10 South Van Ness Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/14/2004 12:00:00 AM | Permit Number 47529 | 6006972.51081745 | 2110293.55168859 | 37.7748579396097 | -122.419345575047 | (37.7748579396097, -122.419345575047) | |||
| 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) | |||
| 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) | |||
| 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) | |
| 13521 | 13521 | 49830 | Permitted Site 1 | Geijera parviflora :: Australian Willow 68 | 225 Missouri St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/11/2003 12:00:00 AM | 5 | 3x3 | Permit Number 46613 | 6013486.20588 | 2106002.24827 | 37.7634396826096 | -122.396512309398 | (37.7634396826096, -122.396512309398) | |
| 57240 | 57240 | 41187 | Permitted Site 1 | Geijera parviflora :: Australian Willow 68 | 380 Connecticut St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/11/2003 12:00:00 AM | 8 | Permit Number 46607 | 6013185.95339 | 2105307.79412 | 37.761516150579205 | -122.39750208615 | (37.7615161505792, -122.39750208615) | |
| 24972 | 24972 | 49768 | Permitted Site 1 | Geijera parviflora :: Australian Willow 68 | 333 Schwerin St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/04/2003 12:00:00 AM | 7 | Permit Number 46559 | 6008671.05987 | 2086426.1944 | 37.7094189460104 | -122.411783070238 | (37.7094189460104, -122.411783070238) | |
| 31008 | 31008 | 49769 | Permitted Site 1 | Geijera parviflora :: Australian Willow 68 | 333 Schwerin St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/04/2003 12:00:00 AM | 4 | Permit Number 46559 | 6008658.89925 | 2086391.1157900002 | 37.70932194511621 | -122.411822622426 | (37.7093219451162, -122.411822622426) | |
| 33600 | 33600 | 49767 | Permitted Site 1 | Geijera parviflora :: Australian Willow 68 | 333 Schwerin St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/04/2003 12:00:00 AM | 7 | Permit Number 46559 | 6008676.28834 | 2086439.38255 | 37.7094554512839 | -122.41176593097 | (37.7094554512839, -122.41176593097) | |
| 35468 | 35468 | 49765 | Permitted Site 1 | Geijera parviflora :: Australian Willow 68 | 333 Schwerin St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/04/2003 12:00:00 AM | 5 | Permit Number 46559 | 6008653.27394 | 2086377.17589 | 37.7092833534188 | -122.411841080097 | (37.7092833534188, -122.411841080097) | |
| 157971 | 157971 | 49772 | Permitted Site 1 | Geijera parviflora :: Australian Willow 68 | 333 Schwerin St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/04/2003 12:00:00 AM | 6 | Permit Number 46559 | 6008665.3182 | 2086406.55888 | 37.7093647087858 | -122.41180152792299 | (37.7093647087858, -122.411801527923) | |
| 179575 | 179575 | 49771 | Permitted Site 1 | Geijera parviflora :: Australian Willow 68 | 333 Schwerin St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/04/2003 12:00:00 AM | 1 | Permit Number 46559 | 6008634.11039 | 2086335.4029299999 | 37.70916757830379 | -122.411904362692 | (37.7091675783038, -122.411904362692) | |
| 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) | |||
| 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) | |||
| 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) | |||
| 28224 | 28224 | 48556 | Permitted Site 1 | Geijera parviflora :: Australian Willow 68 | 615 Central Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/23/2002 12:00:00 AM | 3 | Permit Number 45872 | 5999645.29400405 | 2110579.50430317 | 37.7752276921804 | -122.444712423834 | (37.7752276921804, -122.444712423834) | |
| 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) | ||
| 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) | |
| 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) | ||
| 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) | ||
| 159246 | 159246 | 32928 | Permitted Site 1 | Geijera parviflora :: Australian Willow 68 | 1550 17th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/19/2001 12:00:00 AM | 11 | Permit Number 44256 | 6012662.29085 | 2106602.53119 | 37.765042039783395 | -122.39940412891899 | (37.7650420397834, -122.399404128919) | |
| 12244 | 12244 | 45154 | Permitted Site 1 | Geijera parviflora :: Australian Willow 68 | 1683 Precita Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/22/2001 12:00:00 AM | Permit Number 44007 | ||||||||
| 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) | ||
| 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) | ||
| 2992 | 2992 | 43017 | Permitted Site 1 | Geijera parviflora :: Australian Willow 68 | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/05/2000 12:00:00 AM | Permit Number 42880 | |||||||||
| 3545 | 3545 | 43015 | Permitted Site 1 | Geijera parviflora :: Australian Willow 68 | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/05/2000 12:00:00 AM | Permit Number 42880 | |||||||||
| 3668 | 3668 | 43018 | Permitted Site 1 | Geijera parviflora :: Australian Willow 68 | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/05/2000 12:00:00 AM | Permit Number 42880 | |||||||||
| 5586 | 5586 | 43016 | Permitted Site 1 | Geijera parviflora :: Australian Willow 68 | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/05/2000 12:00:00 AM | Permit Number 42880 | |||||||||
| 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) |
| 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) | |||
| 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) | ||
| 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) | ||||
| 509 | 509 | 38234 | Permitted Site 1 | Geijera parviflora :: Australian Willow 68 | 0 16th St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/21/1998 12:00:00 AM | Permit Number 40352 | ||||||||
| 5326 | 5326 | 38231 | Permitted Site 1 | Geijera parviflora :: Australian Willow 68 | 0 16th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/21/1998 12:00:00 AM | Permit Number 40352 | ||||||||
| 7991 | 7991 | 38232 | Permitted Site 1 | Geijera parviflora :: Australian Willow 68 | 0 16th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/21/1998 12:00:00 AM | Permit Number 40352 | ||||||||
| 10511 | 10511 | 38233 | Permitted Site 1 | Geijera parviflora :: Australian Willow 68 | 0 16th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/21/1998 12:00:00 AM | Permit Number 40352 | ||||||||
| 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) | ||
| 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) | |||
| 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) | |||
| 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) | |||
| 128444 | 128444 | 36065 | Permitted Site 1 | Geijera parviflora :: Australian Willow 68 | 1398 Bryant St | 2 | 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) | |||
| 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) | ||
| 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) | ||
| 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) | ||
| 142985 | 142985 | 35568 | Permitted Site 1 | Geijera parviflora :: Australian Willow 68 | 25 Hill St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/23/1998 12:00:00 AM | Permit Number 38937 | 6006180.09920883 | 2103440.54844158 | 37.7559965511416 | -122.421599868894 | (37.7559965511416, -122.421599868894) | ||
| 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) | ||
| 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) | ||
| 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) | ||
| 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) | |
| 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) | ||
| 26806 | 26806 | 34502 | Permitted Site 1 | Geijera parviflora :: Australian Willow 68 | 1415 20th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/17/1997 12:00:00 AM | 9 | Permit Number 38224 | 6013698.3172 | 2104744.62684 | 37.759998331483494 | -122.39569055749399 | (37.7599983314835, -122.395690557494) | |
| 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) | ||
| 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) | ||
| 4435 | 4435 | 34068 | Permitted Site 1 | Geijera parviflora :: Australian Willow 68 | 955 Kennedy Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/05/1997 12:00:00 AM | Permit Number 37965 | ||||||||
| 6607 | 6607 | 34069 | Permitted Site 1 | Geijera parviflora :: Australian Willow 68 | 955 Kennedy Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/05/1997 12:00:00 AM | Permit Number 37965 | ||||||||
| 7043 | 7043 | 34072 | Permitted Site 1 | Geijera parviflora :: Australian Willow 68 | 955 Kennedy Ave | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/05/1997 12:00:00 AM | Permit Number 37965 |
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");