Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, SiteOrder, qSiteInfo, DBH, PlotSize
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress ▼ | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 114410 | 114410 | 37147 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1 27th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/05/1998 12:00:00 AM | Permit Number 39729 | 6006163.65409791 | 2100221.79185056 | 37.7471576573064 | -122.42142816381799 | (37.7471576573064, -122.421428163818) | ||
| 122248 | 122248 | 37149 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1 27th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/05/1998 12:00:00 AM | Permit Number 39729 | 6006163.65409791 | 2100221.79185056 | 37.7471576573064 | -122.42142816381799 | (37.7471576573064, -122.421428163818) | ||
| 145907 | 145907 | 37148 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1 27th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/05/1998 12:00:00 AM | Permit Number 39729 | 6006163.65409791 | 2100221.79185056 | 37.7471576573064 | -122.42142816381799 | (37.7471576573064, -122.421428163818) | ||
| 117708 | 117708 | 36932 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1 Hoffman Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/15/2003 12:00:00 AM | Permit Number 39573 | 6000605.12386462 | 2102858.71031165 | 37.7540830303141 | -122.440838195083 | (37.7540830303141, -122.440838195083) | ||
| 142370 | 142370 | 36933 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1 Hoffman Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/27/1998 12:00:00 AM | Permit Number 39573 | 6000605.12386462 | 2102858.71031165 | 37.7540830303141 | -122.440838195083 | (37.7540830303141, -122.440838195083) | ||
| 145075 | 145075 | 36931 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1 Hoffman Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/27/1998 12:00:00 AM | Permit Number 39573 | 6000605.12386462 | 2102858.71031165 | 37.7540830303141 | -122.440838195083 | (37.7540830303141, -122.440838195083) | ||
| 30093 | 30093 | 30664 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1 McCoppin St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/26/2003 12:00:00 AM | 3 | Permit Number 46640 | 6006594.41261 | 2109123.24947 | 37.7716232677391 | -122.420570406196 | (37.7716232677391, -122.420570406196) | |
| 56201 | 56201 | 30662 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1 McCoppin St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/26/2003 12:00:00 AM | 2 | Permit Number 46640 | 6006559.28152 | 2109117.66624 | 37.771605957578394 | -122.42069153050801 | (37.7716059575784, -122.420691530508) | |
| 113758 | 113758 | 30668 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1 McCoppin St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/30/1995 12:00:00 AM | Permit Number 34595 | 6006663.15128516 | 2109148.64693366 | 37.7716968767803 | -122.42033443755 | (37.7716968767803, -122.42033443755) | ||
| 141337 | 141337 | 30667 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1 McCoppin St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/30/1995 12:00:00 AM | Permit Number 34595 | 6006663.15128516 | 2109148.64693366 | 37.7716968767803 | -122.42033443755 | (37.7716968767803, -122.42033443755) | ||
| 168897 | 168897 | 30669 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1 McCoppin St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/26/2003 12:00:00 AM | 2 | Permit Number 46640 | 6006474.54027 | 2109116.5589 | 37.7715981406638 | -122.42098457729999 | (37.7715981406638, -122.4209845773) | |
| 177721 | 177721 | 30663 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1 McCoppin St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/26/2003 12:00:00 AM | 3 | Permit Number 46640 | 6006564.909030001 | 2109121.1634 | 37.7716158771129 | -122.420672312891 | (37.7716158771129, -122.420672312891) | |
| 62981 | 62981 | 56298 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 100 09th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/30/1993 12:00:00 AM | 7 | Permit Number 32247 | 5993056.25051 | 2114776.86302 | 37.7863742905451 | -122.467810568951 | (37.7863742905451, -122.467810568951) | |
| 94536 | 94536 | 36309 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 100 Colon Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/14/1998 12:00:00 AM | Permit Number 39290 | 5996171.57528841 | 2093770.15553217 | 37.72887459674929 | -122.455513542245 | (37.7288745967493, -122.455513542245) | ||
| 96299 | 96299 | 36312 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 100 Colon Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/14/1998 12:00:00 AM | Permit Number 39290 | 5996171.57528841 | 2093770.15553217 | 37.72887459674929 | -122.455513542245 | (37.7288745967493, -122.455513542245) | ||
| 113904 | 113904 | 36310 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 100 Colon Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/14/1998 12:00:00 AM | Permit Number 39290 | 5996171.57528841 | 2093770.15553217 | 37.72887459674929 | -122.455513542245 | (37.7288745967493, -122.455513542245) | ||
| 142467 | 142467 | 36308 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 100 Colon Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/14/1998 12:00:00 AM | Permit Number 39290 | 5996171.57528841 | 2093770.15553217 | 37.72887459674929 | -122.455513542245 | (37.7288745967493, -122.455513542245) | ||
| 145414 | 145414 | 36311 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 100 Colon Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/14/1998 12:00:00 AM | Permit Number 39290 | 5996171.57528841 | 2093770.15553217 | 37.72887459674929 | -122.455513542245 | (37.7288745967493, -122.455513542245) | ||
| 166038 | 166038 | 75713 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 100 Goettingen St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/30/1994 12:00:00 AM | 8 | 6009899.57579 | 2093995.19407 | 37.7302706953269 | -122.408070533924 | (37.7302706953269, -122.408070533924) | ||
| 134966 | 134966 | 63038 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1000 Post St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/17/1986 12:00:00 AM | 7 | Permit Number 23508 | 6007306.538930001 | 2114741.30314 | 37.7870891967428 | -122.41850555290002 | (37.7870891967428, -122.4185055529) | |
| 37305 | 37305 | 31761 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1007 Taraval St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/19/1995 12:00:00 AM | 4 | Permit Number 35247 | 5990066.9971 | 2099007.5245 | 37.7429028843685 | -122.47699981190901 | (37.7429028843685, -122.476999811909) | |
| 37903 | 37903 | 31762 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1007 Taraval St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/19/1995 12:00:00 AM | 5 | Permit Number 35247 | 5990024.3559 | 2099006.1709 | 37.7428966939048 | -122.477147152853 | (37.7428966939048, -122.477147152853) | |
| 86968 | 86968 | 60636 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 101 Fairmount St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/25/1991 12:00:00 AM | 3x3 | Permit Number 29895 | 6004821.44439287 | 2097233.75118826 | 37.738877411473105 | -122.42585676358601 | (37.7388774114731, -122.425856763586) | |
| 141734 | 141734 | 112979 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 101 Fairmount St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 3x3 | 6004821.44439287 | 2097233.75118826 | 37.738877411473105 | -122.42585676358601 | (37.7388774114731, -122.425856763586) | |||
| 144971 | 144971 | 112978 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 101 Fairmount St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 3x3 | 6004821.44439287 | 2097233.75118826 | 37.738877411473105 | -122.42585676358601 | (37.7388774114731, -122.425856763586) | |||
| 122325 | 122325 | 42193 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1016 Bryant St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/21/2000 12:00:00 AM | Permit Number 42470 | 6010410.48288619 | 2109291.59089856 | 37.772299817533 | -122.407382201369 | (37.772299817533, -122.407382201369) | ||
| 123581 | 123581 | 42194 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1016 Bryant St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/21/2000 12:00:00 AM | Permit Number 42470 | 6010410.48288619 | 2109291.59089856 | 37.772299817533 | -122.407382201369 | (37.772299817533, -122.407382201369) | ||
| 86392 | 86392 | 31763 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1018 Taraval St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/19/1995 12:00:00 AM | 5 | Permit Number 35248 | 5990018.1797 | 2099070.5556 | 37.7430731192473 | -122.477173212243 | (37.7430731192473, -122.477173212243) | |
| 88740 | 88740 | 31764 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1018 Taraval St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/19/1995 12:00:00 AM | Permit Number 35248 | 5990072.01927063 | 2099066.23490799 | 37.7430643792619 | -122.476986735886 | (37.7430643792619, -122.476986735886) | ||
| 43466 | 43466 | 61653 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 101X 09th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/26/2015 12:00:00 AM | 1 | Permit Number 773687 | 5993009.87039 | 2114787.90553 | 37.7864019320171 | -122.467971834489 | (37.7864019320171, -122.467971834489) | |
| 171523 | 171523 | 74199 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1020 Post St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/20/1988 12:00:00 AM | 5 | 6007263.22393 | 2114733.09636 | 37.787064224370205 | -122.418654831377 | (37.7870642243702, -122.418654831377) | ||
| 145472 | 145472 | 38184 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 103 Dwight St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/28/2013 12:00:00 AM | Permit Number 769585 | 6011280.82748459 | 2091572.16346792 | 37.7236947961561 | -122.403124961994 | (37.7236947961561, -122.403124961994) | ||
| 132162 | 132162 | 67370 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1033 Cabrillo St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/27/1992 12:00:00 AM | 2 | Permit Number 30863 | 5992388.573530001 | 2110655.28285 | 37.7750189809249 | -122.46982035623199 | (37.7750189809249, -122.469820356232) | |
| 146929 | 146929 | 42195 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1045 Bryant St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/23/2000 12:00:00 AM | 3 | Permit Number 42471 | 6010370.94214 | 2109173.76071 | 37.771974069876705 | -122.407510668177 | (37.7719740698767, -122.407510668177) | |
| 52787 | 52787 | 68366 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 105 Cayuga Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/30/1993 12:00:00 AM | 9 | 6x4 | Permit Number 32187 | 6003399.15519 | 2094463.9674799999 | 37.731191735989206 | -122.43057679118999 | (37.7311917359892, -122.43057679119) |
| 82368 | 82368 | 31007 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 106 Drake St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/13/1995 12:00:00 AM | Permit Number 34781 | 6001462.17793128 | 2086756.21041895 | 37.7099180463866 | -122.43672172056601 | (37.7099180463866, -122.436721720566) | ||
| 83812 | 83812 | 47246 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1060 Key Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/09/2002 12:00:00 AM | Permit Number 45193 | 6013087.98009516 | 2089992.50143255 | 37.7194581178311 | -122.39676721011699 | (37.7194581178311, -122.396767210117) | ||
| 95926 | 95926 | 47247 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1060 Key Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/09/2002 12:00:00 AM | Permit Number 45193 | 6013087.98009516 | 2089992.50143255 | 37.7194581178311 | -122.39676721011699 | (37.7194581178311, -122.396767210117) | ||
| 96087 | 96087 | 47244 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1060 Key Ave | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/09/2002 12:00:00 AM | Permit Number 45193 | 6013087.98009516 | 2089992.50143255 | 37.7194581178311 | -122.39676721011699 | (37.7194581178311, -122.396767210117) | ||
| 103547 | 103547 | 47245 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1060 Key Ave | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/09/2002 12:00:00 AM | Permit Number 45193 | 6013087.98009516 | 2089992.50143255 | 37.7194581178311 | -122.39676721011699 | (37.7194581178311, -122.396767210117) | ||
| 107163 | 107163 | 47250 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1060 Key Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/09/2002 12:00:00 AM | Permit Number 45193 | 6013087.98009516 | 2089992.50143255 | 37.7194581178311 | -122.39676721011699 | (37.7194581178311, -122.396767210117) | ||
| 108910 | 108910 | 47249 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1060 Key Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/09/2002 12:00:00 AM | Permit Number 45193 | 6013087.98009516 | 2089992.50143255 | 37.7194581178311 | -122.39676721011699 | (37.7194581178311, -122.396767210117) | ||
| 147599 | 147599 | 42925 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 108 Cole St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/05/2000 12:00:00 AM | 6 | Permit Number 42830 | 5997806.9486 | 2110184.8695 | 37.7740390499347 | -122.45104318248998 | (37.7740390499347, -122.45104318249) | |
| 97176 | 97176 | 37167 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 109 Duncan St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/08/1998 12:00:00 AM | Permit Number 39741 | 6005833.27332998 | 2099912.8997159 | 37.7462908767398 | -122.42254864979799 | (37.7462908767398, -122.422548649798) | ||
| 40603 | 40603 | 52369 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1090 Post St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/14/2005 12:00:00 AM | 6 | 3x3 | Permit Number 48501 | 6006953.33636 | 2114687.7048400003 | 37.786922138678605 | -122.41972375385099 | (37.7869221386786, -122.419723753851) |
| 131472 | 131472 | 62172 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 11 Rudden Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/26/1985 12:00:00 AM | 9 | Permit Number 22288 | 6000332.12983 | 2091919.6967900002 | 37.724031528122204 | -122.440997555008 | (37.7240315281222, -122.440997555008) | |
| 130654 | 130654 | 50398 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 11 Sylvan Dr | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/06/2003 12:00:00 AM | 5 | Permit Number 47049 | 5987519.13546 | 2095787.0700400001 | 37.7339122247558 | -122.485573207637 | (37.7339122247558, -122.485573207637) | |
| 18382 | 18382 | 36313 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 110 Colon Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/14/1998 12:00:00 AM | Permit Number 39291 | 5996172.05456486 | 2093809.43581436 | 37.7289824784834 | -122.455514723268 | (37.7289824784834, -122.455514723268) | ||
| 46263 | 46263 | 71785 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1100 Montgomery St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/21/1995 12:00:00 AM | 8 | 6011579.56023 | 2119131.56016 | 37.7993834201653 | -122.404030839573 | (37.7993834201653, -122.404030839573) | ||
| 57483 | 57483 | 74953 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1104 Vicente St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/20/1995 12:00:00 AM | 7 | 5989482.2278 | 2097687.6237 | 37.7392448382864 | -122.47892523985901 | (37.7392448382864, -122.478925239859) | ||
| 99418 | 99418 | 36314 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 111 Colon Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/14/1998 12:00:00 AM | Permit Number 39292 | 5996120.05843519 | 2093810.07024261 | 37.728981236660296 | -122.455694522542 | (37.7289812366603, -122.455694522542) | ||
| 149003 | 149003 | 53164 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1127@ HAWES Fitzgerald Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/02/2006 12:00:00 AM | 3 | Permit Number 49085 | 6015043.003 | 2090204.3749 | 37.720148501668895 | -122.390024151494 | (37.7201485016689, -122.390024151494) | |
| 157210 | 157210 | 35354 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1137 Kansas St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/12/2005 12:00:00 AM | 5 | Permit Number 38816 | 6011684.12521 | 2103052.0597099997 | 37.75523866684679 | -122.402537695179 | (37.7552386668468, -122.402537695179) | |
| 33420 | 33420 | 61144 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 115 Cole St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/01/1983 12:00:00 AM | 8 | Permit Number 20998 | 5997762.4582 | 2110187.0666 | 37.7740425353843 | -122.451197240135 | (37.7740425353843, -122.451197240135) | |
| 53431 | 53431 | 40663 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 115 Gladstone Dr | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/10/1999 12:00:00 AM | 6 | Permit Number 41653 | 6006176.26096 | 2093712.27916 | 37.7292846993062 | -122.420922478205 | (37.7292846993062, -122.420922478205) | |
| 62964 | 62964 | 40662 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 115 Gladstone Dr | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/10/1999 12:00:00 AM | 6 | Permit Number 41653 | 6006154.91629 | 2093710.8304599999 | 37.7292795183208 | -122.420996165933 | (37.7292795183208, -122.420996165933) | |
| 89679 | 89679 | 113662 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 115 Wisconsin St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 3x3 | 6012589.13870894 | 2106969.27475819 | 37.766044958315604 | -122.399682898168 | (37.7660449583156, -122.399682898168) | |||
| 119432 | 119432 | 113663 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 115 Wisconsin St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 3x3 | 6012589.13870894 | 2106969.27475819 | 37.766044958315604 | -122.399682898168 | (37.7660449583156, -122.399682898168) | |||
| 59706 | 59706 | 64718 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1151 Post St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/14/1988 12:00:00 AM | 6 | Permit Number 25672 | 6006650.94354 | 2114593.23793 | 37.7866457167759 | -122.420763256822 | (37.7866457167759, -122.420763256822) | |
| 30338 | 30338 | 75645 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1154 Kearny St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/07/1995 12:00:00 AM | 7 | 6011131.8005 | 2118945.02958 | 37.7988462254172 | -122.405567109137 | (37.7988462254172, -122.405567109137) | ||
| 52484 | 52484 | 75703 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1154 Kearny St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/07/1995 12:00:00 AM | 6 | 6011133.22449 | 2118927.9427400003 | 37.7987993887319 | -122.405560977554 | (37.7987993887319, -122.405560977554) | ||
| 177346 | 177346 | 75759 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1154 Kearny St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/07/1995 12:00:00 AM | 6 | 6011137.27895 | 2118914.3314799997 | 37.7987622422292 | -122.405545988575 | (37.7987622422292, -122.405545988575) | ||
| 31144 | 31144 | 41113 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 117 Cole St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/18/1999 12:00:00 AM | 7 | Permit Number 41861 | 5997766.8523 | 2110158.7794 | 37.7739651176251 | -122.451179999872 | (37.7739651176251, -122.451179999872) | |
| 86685 | 86685 | 32600 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1200 35th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/23/1996 12:00:00 AM | Permit Number 37067 | 5985231.92181857 | 2107024.54943344 | 37.764633747264 | -122.494308725231 | (37.764633747264, -122.494308725231) | ||
| 112970 | 112970 | 32601 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1200 35th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/07/2002 12:00:00 AM | Permit Number 37067 | 5985231.92181857 | 2107024.54943344 | 37.764633747264 | -122.494308725231 | (37.764633747264, -122.494308725231) | ||
| 117437 | 117437 | 32602 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1200 35th Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/23/1996 12:00:00 AM | Permit Number 37067 | 5985231.92181857 | 2107024.54943344 | 37.764633747264 | -122.494308725231 | (37.764633747264, -122.494308725231) | ||
| 34224 | 34224 | 76155 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1200 Folsom St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/10/1994 12:00:00 AM | 5 | 6009557.4611 | 2110236.6613 | 37.774846979750706 | -122.41039963593501 | (37.7748469797507, -122.410399635935) | ||
| 70535 | 70535 | 76201 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1200 Folsom St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/10/1994 12:00:00 AM | 4 | 6009589.6321 | 2110267.6834 | 37.7749339625844 | -122.410290540065 | (37.7749339625844, -122.410290540065) | ||
| 27917 | 27917 | 31593 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1201 Ortega St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/10/1995 12:00:00 AM | 4 | Permit Number 35122 | 5990086.846 | 2102416.3668 | 37.7522638247523 | -122.477180236453 | (37.7522638247523, -122.477180236453) | |
| 45362 | 45362 | 31590 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1201 Ortega St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/10/1995 12:00:00 AM | 7 | Permit Number 35122 | 5990187.3877 | 2102420.0324 | 37.752279722243294 | -122.476832818906 | (37.7522797222433, -122.476832818906) | |
| 45728 | 45728 | 31591 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1201 Ortega St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/10/1995 12:00:00 AM | 7 | Permit Number 35122 | 5990136.5932 | 2102417.9378 | 37.7522710244136 | -122.47700831941499 | (37.7522710244136, -122.477008319415) | |
| 55737 | 55737 | 31594 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1201 Ortega St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/10/1995 12:00:00 AM | 7 | Permit Number 35122 | 5990210.4285 | 2102421.6034 | 37.7522853723154 | -122.476753255786 | (37.7522853723154, -122.476753255786) | |
| 63825 | 63825 | 31587 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1201 Ortega St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/10/1995 12:00:00 AM | 7 | Permit Number 35122 | 5990160.6813 | 2102419.5088 | 37.7522767353587 | -122.476925134627 | (37.7522767353587, -122.476925134627) | |
| 131245 | 131245 | 31589 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1201 Ortega St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/10/1995 12:00:00 AM | 7 | Permit Number 35122 | 5990232.9456 | 2102422.127 | 37.752288116073295 | -122.476675427158 | (37.7522881160733, -122.476675427158) | |
| 164963 | 164963 | 31588 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1201 Ortega St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/10/1995 12:00:00 AM | 7 | Permit Number 35122 | 5990259.652000001 | 2102422.6507 | 37.7522911030368 | -122.47658311141899 | (37.7522911030368, -122.476583111419) | |
| 168195 | 168195 | 31592 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1201 Ortega St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/10/1995 12:00:00 AM | 7 | Permit Number 35122 | 5990113.0287 | 2102417.9378 | 37.752269657338 | -122.477089808307 | (37.752269657338, -122.477089808307) | |
| 152257 | 152257 | 46407 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1212 19th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/12/2005 12:00:00 AM | 4 | Permit Number 44639 | 6013940.43366 | 2105273.90099 | 37.76146506819121 | -122.394890256177 | (37.7614650681912, -122.394890256177) | |
| 182474 | 182474 | 95520 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1214 35th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/01/2011 12:00:00 AM | 2 | 3x3 | Permit Number 767312 | 5985232.1017 | 2106922.0105 | 37.7643522146303 | -122.49430054433998 | (37.7643522146303, -122.49430054434) |
| 75836 | 75836 | 92434 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1226 43rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/30/2009 12:00:00 AM | 1 | 3x3 | Permit Number 52824 | 5982753.5838 | 2106746.8454 | 37.7637259061718 | -122.502859934877 | (37.7637259061718, -122.502859934877) |
| 129417 | 129417 | 37483 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1231 17th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/22/1998 12:00:00 AM | Permit Number 39952 | 5990766.46629453 | 2107018.80014303 | 37.764940291176295 | -122.475165987831 | (37.7649402911763, -122.475165987831) | ||
| 34619 | 34619 | 37081 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1233 45th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/01/1998 12:00:00 AM | 5 | Permit Number 39682 | 5982089.3021 | 2106698.5454 | 37.7635542250983 | -122.50515386108201 | (37.7635542250983, -122.505153861082) | |
| 36112 | 36112 | 92435 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1234 43rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/30/2009 12:00:00 AM | 2 | 3x3 | Permit Number 52825 | 5982757.3475 | 2106713.6 | 37.7636348449871 | -122.50284445643801 | (37.7636348449871, -122.502844456438) |
| 59672 | 59672 | 92302 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1238 23rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/27/2009 12:00:00 AM | 2 | 3x3 | Permit Number 52746 | 5988957.6818 | 2106889.6381 | 37.7644806463757 | -122.48141258420601 | (37.7644806463757, -122.481412584206) |
| 74938 | 74938 | 37090 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1241 47th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/01/1998 12:00:00 AM | 5 | Permit Number 39690 | 5981472.6931 | 2106630.1727 | 37.7633301936195 | -122.507281405917 | (37.7633301936195, -122.507281405917) | |
| 89528 | 89528 | 36105 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1247 11th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/29/1998 12:00:00 AM | Permit Number 39202 | 5992660.90558351 | 2106977.61989132 | 37.7649368384766 | -122.468610661322 | (37.7649368384766, -122.468610661322) | ||
| 103639 | 103639 | 36104 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1247 11th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/29/1998 12:00:00 AM | Permit Number 39202 | 5992660.90558351 | 2106977.61989132 | 37.7649368384766 | -122.468610661322 | (37.7649368384766, -122.468610661322) | ||
| 177107 | 177107 | 37352 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 125 Curtis St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/15/1998 12:00:00 AM | 2 | Permit Number 39858 | 6000714.467180001 | 2087754.59862 | 37.7126168767351 | -122.43937746140101 | (37.7126168767351, -122.439377461401) | |
| 38781 | 38781 | 44730 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1250 Quintara St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/03/2001 12:00:00 AM | 3 | Permit Number 43848 | 5989567.2499 | 2101094.6235 | 37.7486045071607 | -122.47888039772499 | (37.7486045071607, -122.478880397725) | |
| 42805 | 42805 | 44732 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1250 Quintara St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/03/2001 12:00:00 AM | 4 | Permit Number 43848 | 5989535.4536 | 2101093.9541 | 37.7486008227669 | -122.47899029874901 | (37.7486008227669, -122.478990298749) | |
| 60860 | 60860 | 44731 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1250 Quintara St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/03/2001 12:00:00 AM | 4 | Permit Number 43848 | 5989552.8579 | 2101094.6235 | 37.7486036714361 | -122.478930164526 | (37.7486036714361, -122.478930164526) | |
| 66062 | 66062 | 44729 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1250 Quintara St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/03/2001 12:00:00 AM | 3 | Permit Number 43848 | 5989582.3113 | 2101095.9623 | 37.7486090577263 | -122.478828414076 | (37.7486090577263, -122.478828414076) | |
| 171402 | 171402 | 44733 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1250 Quintara St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/03/2001 12:00:00 AM | 4 | Permit Number 43848 | 5989516.7105 | 2101093.2847 | 37.7485978963189 | -122.479055062469 | (37.7485978963189, -122.479055062469) | |
| 26757 | 26757 | 92423 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1251 39th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/29/2009 12:00:00 AM | 2 | 3x3 | Permit Number 52816 | 5983956.38 | 2106631.2052 | 37.7634790074381 | -122.49869135601999 | (37.7634790074381, -122.49869135602) |
| 50989 | 50989 | 92422 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1251 39th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/29/2009 12:00:00 AM | 2 | 3x3 | Permit Number 52816 | 5983956.6528 | 2106653.574 | 37.7635404418395 | -122.49869206504499 | (37.7635404418395, -122.498692065045) |
| 167261 | 167261 | 71959 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1253 Bush St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/18/1995 12:00:00 AM | 4 | 6007487.95581 | 2115400.40107 | 37.7889091295876 | -122.417924628633 | (37.7889091295876, -122.417924628633) | ||
| 42450 | 42450 | 95773 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 126 Vienna St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/07/2011 12:00:00 AM | 5 | 3x3 | Permit Number 767508 | 6004644.83085 | 2092643.2046400001 | 37.7262628153707 | -122.426140692752 | (37.7262628153707, -122.426140692752) |
| 137583 | 137583 | 37223 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1275 34th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/12/1998 12:00:00 AM | 8 | Permit Number 39787 | 5985506.0184 | 2106556.0011 | 37.763363280972 | -122.493326189315 | (37.763363280972, -122.493326189315) | |
| 77078 | 77078 | 47076 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 128 Beaumont Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/03/2002 12:00:00 AM | 3 | Permit Number 45063 | 5996821.727000001 | 2112136.4292 | 37.779341068099704 | -122.454592228214 | (37.7793410680997, -122.454592228214) | |
| 46756 | 46756 | 32588 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1283 34th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/22/1996 12:00:00 AM | 6 | 4.5x6.5 | Permit Number 37057 | 5985512.5122 | 2106502.2804 | 37.763216158758794 | -122.49329977168999 | (37.7632161587588, -122.49329977169) |
| 68899 | 68899 | 71587 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 129 Goethe St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/30/1995 12:00:00 AM | 5 | 5994891.94658 | 2086476.6908099998 | 37.7087749666595 | -122.459409293405 | (37.7087749666595, -122.459409293405) |
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");