Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, qCaretaker, DBH, PlotSize
Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH ▼ | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
14525 | 14525 | 43623 | Permitted Site 1 | Melaleuca nesophila :: Pink Melaleuca 93 | 210 35th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/20/2000 12:00:00 AM | Permit Number 43272 | ||||||||
18556 | 18556 | 31172 | Permitted Site 1 | Melaleuca nesophila :: Pink Melaleuca 93 | 100 Shields St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/21/1995 12:00:00 AM | Permit Number 34871 | 5993759.19888335 | 2089860.63162869 | 37.7180012684503 | -122.46356961432801 | (37.7180012684503, -122.463569614328) | |||
58677 | 58677 | 31171 | Permitted Site 1 | Melaleuca nesophila :: Pink Melaleuca 93 | 100 Shields St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/21/1995 12:00:00 AM | Permit Number 34871 | 5993759.19888335 | 2089860.63162869 | 37.7180012684503 | -122.46356961432801 | (37.7180012684503, -122.463569614328) | |||
78297 | 78297 | 31635 | Permitted Site 1 | Melaleuca nesophila :: Pink Melaleuca 93 | 2538 Great Hwy | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/22/1995 12:00:00 AM | Permit Number 35152 | 5981511.7242527 | 2097800.56430497 | 37.739088877646395 | -122.506491564023 | (37.7390888776464, -122.506491564023) | ||
78788 | 78788 | 40218 | Permitted Site 1 | Melaleuca nesophila :: Pink Melaleuca 93 | 139 Seal Rock Dr | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/06/1999 12:00:00 AM | Permit Number 41397 | 5981206.29115693 | 2112930.16439571 | 37.7806124308083 | -122.50867053303499 | (37.7806124308083, -122.508670533035) | ||
79217 | 79217 | 43824 | Permitted Site 1 | Melaleuca nesophila :: Pink Melaleuca 93 | 2539 35th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/27/2000 12:00:00 AM | Permit Number 43452 | 5985490.59688758 | 2097934.34218836 | 37.7396896615859 | -122.492744480822 | (37.7396896615859, -122.492744480822) | ||
80008 | 80008 | 31638 | Permitted Site 1 | Melaleuca nesophila :: Pink Melaleuca 93 | 2562 Great Hwy | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/22/1995 12:00:00 AM | Permit Number 35155 | 5981524.37597425 | 2097644.9749882 | 37.7386624172308 | -122.506436285686 | (37.7386624172308, -122.506436285686) | ||
81901 | 81901 | 31640 | Permitted Site 1 | Melaleuca nesophila :: Pink Melaleuca 93 | 2594 Great Hwy | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/22/1995 12:00:00 AM | Permit Number 35156 | 5981541.24493631 | 2097437.52256583 | 37.738093803256 | -122.50636258222201 | (37.738093803256, -122.506362582222) | ||
83318 | 83318 | 31642 | Permitted Site 1 | Melaleuca nesophila :: Pink Melaleuca 93 | 3601 Taraval St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/22/1995 12:00:00 AM | Permit Number 35157 | 5982065.15070434 | 2098736.73871701 | 37.7416919237879 | -122.504647444825 | (37.7416919237879, -122.504647444825) | ||
83587 | 83587 | 114672 | Permitted Site 1 | Melaleuca nesophila :: Pink Melaleuca 93 | 85X Peralta Ave | 2 | Side Yard : Yard 17 | Tree 1 | Private 1 | 11/30/2015 12:00:00 AM | Permit Number 775155 | 6010502.29579 | 2100335.12269 | 37.7477125069204 | -122.40643339757601 | (37.7477125069204, -122.406433397576) | |||
84488 | 84488 | 37087 | Permitted Site 1 | Melaleuca nesophila :: Pink Melaleuca 93 | 1431 46th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/01/1998 12:00:00 AM | Permit Number 39687 | 5981822.5647819 | 2105347.10091721 | 37.7598278475269 | -122.50597620053001 | (37.7598278475269, -122.50597620053) | ||
86011 | 86011 | 43610 | Permitted Site 1 | Melaleuca nesophila :: Pink Melaleuca 93 | 2174 33rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/20/2000 12:00:00 AM | Permit Number 43264 | 5986078.58326706 | 2100441.09799391 | 37.746606905591996 | -122.49089591351401 | (37.746606905592, -122.490895913514) | ||
86051 | 86051 | 38919 | Permitted Site 1 | Melaleuca nesophila :: Pink Melaleuca 93 | 739 Lakeview Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/25/2002 12:00:00 AM | Permit Number 40729 | 5994644.0321122 | 2089899.68618843 | 37.7181594465135 | -122.460513981509 | (37.7181594465135, -122.460513981509) | ||
86529 | 86529 | 37248 | Permitted Site 1 | Melaleuca nesophila :: Pink Melaleuca 93 | 3038 Pacheco St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/12/1998 12:00:00 AM | Permit Number 39801 | 5985578.39129143 | 2101634.00517992 | 37.7498530704582 | -122.492713344722 | (37.7498530704582, -122.492713344722) | ||
86628 | 86628 | 39996 | Permitted Site 1 | Melaleuca nesophila :: Pink Melaleuca 93 | 870 Innes Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/03/1999 12:00:00 AM | Permit Number 41254 | 6019158.47829216 | 2094538.87688533 | 37.7322776068337 | -122.376098579608 | (37.7322776068337, -122.376098579608) | ||
88155 | 88155 | 114671 | Permitted Site 1 | Melaleuca nesophila :: Pink Melaleuca 93 | 85X Peralta Ave | 1 | Side Yard : Yard 17 | Tree 1 | Private 1 | 11/30/2015 12:00:00 AM | Permit Number 775155 | 6010502.29579 | 2100335.12269 | 37.7477125069204 | -122.40643339757601 | (37.7477125069204, -122.406433397576) | |||
89643 | 89643 | 46398 | Permitted Site 1 | Melaleuca nesophila :: Pink Melaleuca 93 | 2363 46th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/05/2002 12:00:00 AM | Permit Number 44628 | 5982038.69993379 | 2099019.08157606 | 37.7424656032555 | -122.504759817001 | (37.7424656032555, -122.504759817001) | |||
90351 | 90351 | 37484 | Permitted Site 1 | Melaleuca nesophila :: Pink Melaleuca 93 | 1246 17th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/22/1998 12:00:00 AM | Permit Number 39953 | 5990822.12261544 | 2106914.97361747 | 37.7646584370326 | -122.47496590913099 | (37.7646584370326, -122.474965909131) | ||
90838 | 90838 | 31634 | Permitted Site 1 | Melaleuca nesophila :: Pink Melaleuca 93 | 2526 Great Hwy | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/22/1995 12:00:00 AM | Permit Number 35151 | 5981505.3983929 | 2097878.35895124 | 37.739302107799894 | -122.506519203426 | (37.7393021077999, -122.506519203426) | ||
91487 | 91487 | 35511 | Permitted Site 1 | Melaleuca nesophila :: Pink Melaleuca 93 | 3484 22nd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/23/1998 12:00:00 AM | Permit Number 38913 | 6005154.64040446 | 2103144.1330954 | 37.75512478765 | -122.42512515813999 | (37.75512478765, -122.42512515814) | ||
94765 | 94765 | 38360 | Permitted Site 1 | Melaleuca nesophila :: Pink Melaleuca 93 | 1610 Great Hwy | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/06/1999 12:00:00 AM | Permit Number 41156 | 5980983.59087853 | 2104088.99570474 | 37.756324030904395 | -122.50878433832399 | (37.7563240309044, -122.508784338324) | ||
97252 | 97252 | 37811 | Permitted Site 1 | Melaleuca nesophila :: Pink Melaleuca 93 | 354 Athens St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/07/1998 12:00:00 AM | Permit Number 40131 | 6004085.30799236 | 2091240.01678916 | 37.722378331197206 | -122.427974988755 | (37.7223783311972, -122.427974988755) | ||
98714 | 98714 | 38927 | Permitted Site 1 | Melaleuca nesophila :: Pink Melaleuca 93 | 30 Lunado Way | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/02/1998 12:00:00 AM | Permit Number 40735 | 5991530.391079799 | 2091455.54556163 | 37.7222518366051 | -122.47138970523199 | (37.7222518366051, -122.471389705232) | ||
99708 | 99708 | 30671 | Permitted Site 1 | Melaleuca nesophila :: Pink Melaleuca 93 | 39 McCoppin St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/30/1995 12:00:00 AM | Permit Number 34597 | 6006368.06236527 | 2109117.19408355 | 37.7715938820876 | -122.421352936259 | (37.7715938820876, -122.421352936259) | |||
100012 | 100012 | 37107 | Permitted Site 1 | Melaleuca nesophila :: Pink Melaleuca 93 | 4501 Irving St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/01/1998 12:00:00 AM | Permit Number 39705 | 5981809.38189346 | 2106215.79884963 | 37.7622122675222 | -122.506086203855 | (37.7622122675222, -122.506086203855) | ||
100449 | 100449 | 35513 | Permitted Site 1 | Melaleuca nesophila :: Pink Melaleuca 93 | 3488 22nd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/21/2006 12:00:00 AM | Permit Number 38915 | 6005128.06949501 | 2103142.26204564 | 37.755118149138 | -122.42521691501899 | (37.755118149138, -122.425216915019) | ||
102014 | 102014 | 31632 | Permitted Site 1 | Melaleuca nesophila :: Pink Melaleuca 93 | 2518 Great Hwy | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/22/1995 12:00:00 AM | Permit Number 35149 | 5981501.18115239 | 2097930.22205683 | 37.7394442612499 | -122.506537629785 | (37.7394442612499, -122.506537629785) | ||
103759 | 103759 | 40210 | Permitted Site 1 | Melaleuca nesophila :: Pink Melaleuca 93 | 418 45th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/06/1999 12:00:00 AM | Permit Number 41392 | 5981924.63262302 | 2112926.84029829 | 37.780645617869894 | -122.506185243392 | (37.7806456178699, -122.506185243392) | ||
104329 | 104329 | 37633 | Permitted Site 1 | Melaleuca nesophila :: Pink Melaleuca 93 | 793 18th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/26/1998 12:00:00 AM | Permit Number 40051 | 5990357.97842308 | 2109989.05024853 | 37.773072107347495 | -122.476795862973 | (37.7730721073475, -122.476795862973) | ||
104475 | 104475 | 46397 | Permitted Site 1 | Melaleuca nesophila :: Pink Melaleuca 93 | 2363 46th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/05/2002 12:00:00 AM | Permit Number 44628 | 5982038.69993379 | 2099019.08157606 | 37.7424656032555 | -122.504759817001 | (37.7424656032555, -122.504759817001) | |||
104871 | 104871 | 40219 | Permitted Site 1 | Melaleuca nesophila :: Pink Melaleuca 93 | 165 Seal Rock Dr | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/06/1999 12:00:00 AM | Permit Number 41398 | 5981062.91201163 | 2112924.76539407 | 37.780589154708295 | -122.50916613998699 | (37.7805891547083, -122.509166139987) | ||
106401 | 106401 | 39832 | Permitted Site 1 | Melaleuca nesophila :: Pink Melaleuca 93 | 1900 48th Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/06/1999 12:00:00 AM | Permit Number 41153 | 5981364.12857436 | 2102124.06115885 | 37.7509513011754 | -122.507322554156 | (37.7509513011754, -122.507322554156) | ||
107890 | 107890 | 35514 | Permitted Site 1 | Melaleuca nesophila :: Pink Melaleuca 93 | 3492 22nd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/23/1998 12:00:00 AM | Permit Number 38916 | 6005101.49857239 | 2103140.39099496 | 37.7551115105514 | -122.425308671927 | (37.7551115105514, -122.425308671927) | ||
109235 | 109235 | 31643 | Permitted Site 1 | Melaleuca nesophila :: Pink Melaleuca 93 | 3601 Taraval St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/22/1995 12:00:00 AM | Permit Number 35157 | 5982065.15070434 | 2098736.73871701 | 37.7416919237879 | -122.504647444825 | (37.7416919237879, -122.504647444825) | ||
109535 | 109535 | 31636 | Permitted Site 1 | Melaleuca nesophila :: Pink Melaleuca 93 | 2542 Great Hwy | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/29/1996 12:00:00 AM | Permit Number 37115 | 5981513.83287394 | 2097774.63274006 | 37.73901780088121 | -122.506482350919 | (37.7390178008812, -122.506482350919) | ||
109875 | 109875 | 39831 | Permitted Site 1 | Melaleuca nesophila :: Pink Melaleuca 93 | 1900 48th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/06/1999 12:00:00 AM | Permit Number 41153 | 5981364.12857436 | 2102124.06115885 | 37.7509513011754 | -122.507322554156 | (37.7509513011754, -122.507322554156) | ||
110105 | 110105 | 31641 | Permitted Site 1 | Melaleuca nesophila :: Pink Melaleuca 93 | 2594 Great Hwy | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/22/1995 12:00:00 AM | Permit Number 35156 | 5981541.24493631 | 2097437.52256583 | 37.738093803256 | -122.50636258222201 | (37.738093803256, -122.506362582222) | ||
110594 | 110594 | 44258 | Permitted Site 1 | Melaleuca nesophila :: Pink Melaleuca 93 | 401 Diamond St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/20/2001 12:00:00 AM | Permit Number 43691 | 6001829.66372376 | 2103503.31899472 | 37.7559226344565 | -122.436649584408 | (37.7559226344565, -122.436649584408) | |||
110671 | 110671 | 40211 | Permitted Site 1 | Melaleuca nesophila :: Pink Melaleuca 93 | 418 45th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/06/1999 12:00:00 AM | Permit Number 41392 | 5981924.63262302 | 2112926.84029829 | 37.780645617869894 | -122.506185243392 | (37.7806456178699, -122.506185243392) | |||
112258 | 112258 | 114673 | Permitted Site 1 | Melaleuca nesophila :: Pink Melaleuca 93 | 85X Peralta Ave | 3 | Side Yard : Yard 17 | Tree 1 | Private 1 | 11/30/2015 12:00:00 AM | Permit Number 775155 | 6010502.29579 | 2100335.12269 | 37.7477125069204 | -122.40643339757601 | (37.7477125069204, -122.406433397576) | |||
112675 | 112675 | 48954 | Permitted Site 1 | Melaleuca nesophila :: Pink Melaleuca 93 | 1425 Florida St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/26/2002 12:00:00 AM | Permit Number 46141 | 6009586.08390989 | 2100908.24074194 | 37.7492348647629 | -122.409642067631 | (37.7492348647629, -122.409642067631) | ||
113920 | 113920 | 40206 | Permitted Site 1 | Melaleuca nesophila :: Pink Melaleuca 93 | 540 43rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/06/1999 12:00:00 AM | Permit Number 41388 | 5982575.37732497 | 2112101.53347145 | 37.778417854750096 | -122.503872900243 | (37.7784178547501, -122.503872900243) | ||
114723 | 114723 | 31628 | Permitted Site 1 | Melaleuca nesophila :: Pink Melaleuca 93 | 2518 47th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/22/1995 12:00:00 AM | Permit Number 35145 | 5981817.84640139 | 2097939.09313644 | 37.7394872587943 | -122.505443416468 | (37.7394872587943, -122.505443416468) | ||
117097 | 117097 | 39998 | Permitted Site 1 | Melaleuca nesophila :: Pink Melaleuca 93 | 880 Innes Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/03/1999 12:00:00 AM | Permit Number 41256 | 6019141.64317919 | 2094551.4292426002 | 37.732311146345296 | -122.376157653218 | (37.7323111463453, -122.376157653218) | ||
120495 | 120495 | 37116 | Permitted Site 1 | Melaleuca nesophila :: Pink Melaleuca 93 | 4542 Irving St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/01/1998 12:00:00 AM | Permit Number 39708 | 5981682.74450716 | 2106263.49145698 | 37.762335762281 | -122.506527724058 | (37.762335762281, -122.506527724058) | ||
121472 | 121472 | 37635 | Permitted Site 1 | Melaleuca nesophila :: Pink Melaleuca 93 | 797 18th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/26/1998 12:00:00 AM | Permit Number 40053 | 5990358.92841621 | 2109962.95608948 | 37.7730005150319 | -122.476790669979 | (37.7730005150319, -122.476790669979) | ||
121538 | 121538 | 49208 | Permitted Site 1 | Melaleuca nesophila :: Pink Melaleuca 93 | 1425 Waller St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/05/2003 12:00:00 AM | Permit Number 46297 | 5998885.49389444 | 2108307.84265086 | 37.768946901017706 | -122.447177209779 | (37.7689469010177, -122.447177209779) | |||
122101 | 122101 | 39993 | Permitted Site 1 | Melaleuca nesophila :: Pink Melaleuca 93 | 860 Innes Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/27/1999 12:00:00 AM | Permit Number 41251 | 6019175.31340513 | 2094526.32452806 | 37.73224406729229 | -122.376039506051 | (37.7322440672923, -122.376039506051) | ||
122518 | 122518 | 39825 | Permitted Site 1 | Melaleuca nesophila :: Pink Melaleuca 93 | 2311 46th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/06/1999 12:00:00 AM | Permit Number 41150 | 5982026.95424167 | 2099360.52748006 | 37.7434024282005 | -122.504825724634 | (37.7434024282005, -122.504825724634) | ||
123186 | 123186 | 31639 | Permitted Site 1 | Melaleuca nesophila :: Pink Melaleuca 93 | 2594 Great Hwy | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/22/1995 12:00:00 AM | Permit Number 35156 | 5981541.24493631 | 2097437.52256583 | 37.738093803256 | -122.50636258222201 | (37.738093803256, -122.506362582222) | ||
128271 | 128271 | 119904 | Undocumented 2 | Melaleuca nesophila :: Pink Melaleuca 93 | 517 Laidley St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6003302.0 | 2096146.0 | 37.7358047110715 | -122.43103267909099 | (37.7358047110715, -122.431032679091) | ||||
129052 | 129052 | 39836 | Permitted Site 1 | Melaleuca nesophila :: Pink Melaleuca 93 | 2048 Great Hwy | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/06/1999 12:00:00 AM | Permit Number 41158 | 5981224.57274912 | 2101126.86261798 | 37.7482050538241 | -122.50773115252399 | (37.7482050538241, -122.507731152524) | ||
129115 | 129115 | 40541 | Permitted Site 1 | Melaleuca nesophila :: Pink Melaleuca 93 | 389 San Benito Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/30/2005 12:00:00 AM | Permit Number 48035 | 5992634.70647519 | 2093966.0670834 | 37.7292089323345 | -122.467754881103 | (37.7292089323345, -122.467754881103) | ||
129256 | 129256 | 39830 | Permitted Site 1 | Melaleuca nesophila :: Pink Melaleuca 93 | 1900 48th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/06/1999 12:00:00 AM | Permit Number 41153 | 5981364.12857436 | 2102124.06115885 | 37.7509513011754 | -122.507322554156 | (37.7509513011754, -122.507322554156) | ||
139347 | 139347 | 51245 | Permitted Site 1 | Melaleuca nesophila :: Pink Melaleuca 93 | 35 Majestic Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/17/2004 12:00:00 AM | Permit Number 47620 | 5997371.20755939 | 2089722.08093206 | 37.7178282993487 | -122.451074550694 | (37.7178282993487, -122.451074550694) | ||
139703 | 139703 | 31626 | Permitted Site 1 | Melaleuca nesophila :: Pink Melaleuca 93 | 2562 46th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/22/1995 12:00:00 AM | Permit Number 35143 | 5982137.33816038 | 2097664.20833434 | 37.738751296749705 | -122.50431841396299 | (37.7387512967497, -122.504318413963) | ||
140057 | 140057 | 31631 | Permitted Site 1 | Melaleuca nesophila :: Pink Melaleuca 93 | 2506 Great Hwy | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/09/2000 12:00:00 AM | Permit Number 35148 | 5981494.85529112 | 2098008.01672128 | 37.739657491429796 | -122.506565269459 | (37.7396574914298, -122.506565269459) | ||
140746 | 140746 | 44259 | Permitted Site 1 | Melaleuca nesophila :: Pink Melaleuca 93 | 401 Diamond St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/20/2001 12:00:00 AM | Permit Number 43691 | 6001829.66372376 | 2103503.31899472 | 37.7559226344565 | -122.436649584408 | (37.7559226344565, -122.436649584408) | |||
140797 | 140797 | 37132 | Permitted Site 1 | Melaleuca nesophila :: Pink Melaleuca 93 | 4447 Kirkham St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/01/1998 12:00:00 AM | Permit Number 39714 | 5981086.08651436 | 2104832.07084282 | 37.7583703439041 | -122.508485038953 | (37.7583703439041, -122.508485038953) | ||
141727 | 141727 | 38353 | Permitted Site 1 | Melaleuca nesophila :: Pink Melaleuca 93 | 1800 48th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/31/1998 12:00:00 AM | Permit Number 40421 | 5981341.25756614 | 2102804.1865841 | 37.7528173861664 | -122.507452100184 | (37.7528173861664, -122.507452100184) | ||
142338 | 142338 | 43216 | Permitted Site 1 | Melaleuca nesophila :: Pink Melaleuca 93 | 44 Dunsmuir St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/11/2000 12:00:00 AM | Permit Number 43006 | 6008111.99433178 | 2094081.5468642 | 37.73040755168461 | -122.41425657074 | (37.7304075516846, -122.41425657074) | ||
142496 | 142496 | 31633 | Permitted Site 1 | Melaleuca nesophila :: Pink Melaleuca 93 | 2522 Great Hwy | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/22/1995 12:00:00 AM | Permit Number 35150 | 5981503.28977265 | 2097904.29050404 | 37.739373184525704 | -122.506528416597 | (37.7393731845257, -122.506528416597) | ||
144523 | 144523 | 30672 | Permitted Site 1 | Melaleuca nesophila :: Pink Melaleuca 93 | 39 McCoppin St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/08/2003 12:00:00 AM | Permit Number 34597 | 6006368.06236527 | 2109117.19408355 | 37.7715938820876 | -122.421352936259 | (37.7715938820876, -122.421352936259) | ||
145753 | 145753 | 31644 | Permitted Site 1 | Melaleuca nesophila :: Pink Melaleuca 93 | 3601 Taraval St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/22/1995 12:00:00 AM | Permit Number 35157 | 5982065.15070434 | 2098736.73871701 | 37.7416919237879 | -122.504647444825 | (37.7416919237879, -122.504647444825) | ||
28357 | 28357 | 31627 | Permitted Site 1 | Melaleuca nesophila :: Pink Melaleuca 93 | 2430 47th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/22/1995 12:00:00 AM | 0 | Permit Number 35144 | 5981797.10260903 | 2098537.8771738 | 37.7411301336904 | -122.50555951218399 | (37.7411301336904, -122.505559512184) | |
36904 | 36904 | 31305 | Permitted Site 1 | Melaleuca nesophila :: Pink Melaleuca 93 | 561 Birch St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/12/1995 12:00:00 AM | 0 | Permit Number 34946 | 6005105.48028119 | 2111430.55673025 | 37.7778745481219 | -122.425884980842 | (37.7778745481219, -122.425884980842) | |
134786 | 134786 | 37114 | Permitted Site 1 | Melaleuca nesophila :: Pink Melaleuca 93 | 4540 Irving St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/01/1998 12:00:00 AM | 0 | Permit Number 39707 | 5981688.69009077 | 2106263.69511954 | 37.7623366715481 | -122.506507175967 | (37.7623366715481, -122.506507175967) | |
135660 | 135660 | 37119 | Permitted Site 1 | Melaleuca nesophila :: Pink Melaleuca 93 | 4731 Irving St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/01/1998 12:00:00 AM | 0 | Permit Number 39709 | 5981101.19035238 | 2106191.54023256 | 37.762103946482505 | -122.508533725105 | (37.7621039464825, -122.508533725105) | |
150825 | 150825 | 31310 | Permitted Site 1 | Melaleuca nesophila :: Pink Melaleuca 93 | 577 Birch St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/12/1995 12:00:00 AM | 0 | Permit Number 34948 | 6005032.34705274 | 2111420.35666119 | 37.777842407995294 | -122.42613724809999 | (37.7778424079953, -122.4261372481) | |
157476 | 157476 | 31309 | Permitted Site 1 | Melaleuca nesophila :: Pink Melaleuca 93 | 577 Birch St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/12/1995 12:00:00 AM | 0 | Permit Number 34948 | 6005032.34705274 | 2111420.35666119 | 37.777842407995294 | -122.42613724809999 | (37.7778424079953, -122.4261372481) | |
164869 | 164869 | 37115 | Permitted Site 1 | Melaleuca nesophila :: Pink Melaleuca 93 | 4540 Irving St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/01/1998 12:00:00 AM | 0 | Permit Number 39707 | 5981688.69009077 | 2106263.69511954 | 37.7623366715481 | -122.506507175967 | (37.7623366715481, -122.506507175967) | |
174810 | 174810 | 31307 | Permitted Site 1 | Melaleuca nesophila :: Pink Melaleuca 93 | 569 Birch St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/12/1995 12:00:00 AM | 0 | Permit Number 34947 | 6005068.91365842 | 2111425.45669453 | 37.7778584781223 | -122.42601111452801 | (37.7778584781223, -122.426011114528) | |
178533 | 178533 | 31308 | Permitted Site 1 | Melaleuca nesophila :: Pink Melaleuca 93 | 569 Birch St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/12/1995 12:00:00 AM | 0 | Permit Number 34947 | 6005068.91365842 | 2111425.45669453 | 37.7778584781223 | -122.42601111452801 | (37.7778584781223, -122.426011114528) | |
180771 | 180771 | 31306 | Permitted Site 1 | Melaleuca nesophila :: Pink Melaleuca 93 | 561 Birch St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/12/1995 12:00:00 AM | 0 | Permit Number 34946 | 6005105.48028119 | 2111430.55673025 | 37.7778745481219 | -122.425884980842 | (37.7778745481219, -122.425884980842) | |
182887 | 182887 | 37113 | Permitted Site 1 | Melaleuca nesophila :: Pink Melaleuca 93 | 4523 IRVING ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/01/1998 12:00:00 AM | 0 | Permit Number 39706 | 5981665.2 | 2106185.8 | 37.7621214108202 | -122.506582640723 | (37.7621214108202, -122.506582640723) | |
187630 | 187630 | 47074 | Permitted Site 1 | Melaleuca nesophila :: Pink Melaleuca 93 | 106 Beaumont Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/03/2002 12:00:00 AM | 0 | Permit Number 45062 | 5996796.88091549 | 2112360.28017641 | 37.7799542788822 | -122.454694357616 | (37.7799542788822, -122.454694357616) | |
159827 | 159827 | 193548 | DPW Maintained 3 | Melaleuca nesophila :: Pink Melaleuca 93 | 1300x De Haro St | 12 | Median : Yard 3 | Tree 1 | DPW 2 | 1 | 6012271.58863 | 2102171.1791 | 37.7528527402726 | -122.400444188549 | (37.7528527402726, -122.400444188549) | ||||
5374 | 5374 | 120897 | Undocumented 2 | Melaleuca nesophila :: Pink Melaleuca 93 | 3760 Webster St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/04/2016 12:00:00 AM | 3 | 2x5 | Permit Number 778876 | 6002560.418 | 2121574.39052 | 37.805582749215105 | -122.43541504397301 | (37.8055827492151, -122.435415043973) | |
54311 | 54311 | 46406 | Permitted Site 1 | Melaleuca nesophila :: Pink Melaleuca 93 | 2443 44th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/03/2008 12:00:00 AM | 3 | 3x3 | Permit Number 51149 | 5982682.2949 | 2098486.1858 | 37.741040257888706 | -122.50249506178801 | (37.7410402578887, -122.502495061788) | |
56979 | 56979 | 193543 | Undocumented 2 | Melaleuca nesophila :: Pink Melaleuca 93 | 610 22nd St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 5ft | 6016026.74063 | 2103985.73325 | 37.7580438195766 | -122.38758464502399 | (37.7580438195766, -122.387584645024) | |||
80926 | 80926 | 87297 | Permitted Site 1 | Melaleuca nesophila :: Pink Melaleuca 93 | 4227 Lincoln Way | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/16/2014 12:00:00 AM | 3 | 3x3 | Permit Number 773956 | 5982573.0 | 2106897.6 | 37.764129220397294 | -122.50349567213001 | (37.7641292203973, -122.50349567213) | ||
81132 | 81132 | 15073 | DPW Maintained 3 | Melaleuca nesophila :: Pink Melaleuca 93 | 30X Minerva St | 5 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | 11 | 5996426.1222644 | 2089040.1488729 | 37.7159017196126 | -122.45429204268801 | (37.7159017196126, -122.454292042688) | |||
89003 | 89003 | 15081 | DPW Maintained 3 | Melaleuca nesophila :: Pink Melaleuca 93 | 80X Minerva St | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | 11 | 5996060.1066716 | 2089044.9734463 | 37.7158939701237 | -122.455557504311 | (37.7158939701237, -122.455557504311) | |||
186695 | 186695 | 193542 | Undocumented 2 | Melaleuca nesophila :: Pink Melaleuca 93 | 610 22nd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 5ft | 6016043.65792 | 2103986.82395 | 37.7580477514291 | -122.387526213378 | (37.7580477514291, -122.387526213378) | |||
53662 | 53662 | 210096 | Undocumented 2 | Melaleuca nesophila :: Pink Melaleuca 93 | 300 Junipero Serra Blvd | 45 | : 4 | Tree 1 | Private 1 | 4 | Width 0ft | 5991386.500659999 | 2094355.8588400001 | 37.73020705030461 | -122.47209839385201 | (37.7302070503046, -122.472098393852) | |||
61265 | 61265 | 184530 | Undocumented 2 | Melaleuca nesophila :: Pink Melaleuca 93 | 4045 Ortega St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 0ft | 5981394.5999 | 2102116.7749 | 37.7509330899515 | -122.50721664272801 | (37.7509330899515, -122.507216642728) | |||
131557 | 131557 | 210095 | DPW Maintained 3 | Melaleuca nesophila :: Pink Melaleuca 93 | 1x Minerva St | 47 | Median : Cutout 11 | Tree 1 | DPW 2 | 4 | Width 0ft | 5996479.95925 | 2088997.21564 | 37.7157869222034 | -122.454102858955 | (37.7157869222034, -122.454102858955) | |||
176806 | 176806 | 38370 | Permitted Site 1 | Melaleuca nesophila :: Pink Melaleuca 93 | 4245 Lawton St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/06/1999 12:00:00 AM | 4 | Permit Number 41159 | 5981126.11155374 | 2104152.1959616 | 37.7565059606627 | -122.508296152224 | (37.7565059606627, -122.508296152224) | |
6133 | 6133 | 27582 | Permitted Site 1 | Melaleuca nesophila :: Pink Melaleuca 93 | 1777 Turk St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/25/2015 12:00:00 AM | 5 | 3X3 | 6001533.8276 | 2112150.0507 | 37.7796476052413 | -122.438292110376 | (37.7796476052413, -122.438292110376) | ||
17904 | 17904 | 27583 | Permitted Site 1 | Melaleuca nesophila :: Pink Melaleuca 93 | 1781 Turk St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/25/2015 12:00:00 AM | 5 | 3X3 | 6001531.97079 | 2112100.50741 | 37.7795114663002 | -122.43829498357901 | (37.7795114663002, -122.438294983579) | ||
45817 | 45817 | 39814 | Permitted Site 1 | Melaleuca nesophila :: Pink Melaleuca 93 | 2079 45th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/06/1999 12:00:00 AM | 5 | Permit Number 41145 | 5982286.3414 | 2100973.7552 | 37.747847159841704 | -122.50404831238701 | (37.7478471598417, -122.504048312387) | |
56108 | 56108 | 183035 | Undocumented 2 | Melaleuca nesophila :: Pink Melaleuca 93 | 2522 Lower Great Hwy | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 0ft | 5981504.4178 | 2097898.5163 | 37.7393573965741 | -122.506524088332 | (37.7393573965741, -122.506524088332) | |||
137605 | 137605 | 80263 | Permitted Site 1 | Melaleuca nesophila :: Pink Melaleuca 93 | 2074 45th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/09/2008 12:00:00 AM | 5 | 3x3 | Permit Number 50734 | 5982335.751 | 2100990.6763 | 37.747896525944796 | -122.50387871228399 | (37.7478965259448, -122.503878712284) | |
146438 | 146438 | 43057 | Permitted Site 1 | Melaleuca nesophila :: Pink Melaleuca 93 | 1922 48th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/27/2010 12:00:00 AM | 5 | 3x3 | Permit Number 53821 | 5981365.4957 | 2101971.9303 | 37.750533673272706 | -122.507306541093 | (37.7505336732727, -122.507306541093) |
174219 | 174219 | 40023 | Permitted Site 1 | Melaleuca nesophila :: Pink Melaleuca 93 | 1571 McKinnon Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/03/1999 12:00:00 AM | 5 | Permit Number 41268 | 6015526.3634 | 2095776.2911 | 37.73547467040311 | -122.388742090508 | (37.7354746704031, -122.388742090508) | |
180522 | 180522 | 250985 | Undocumented 2 | Melaleuca nesophila :: Pink Melaleuca 93 | 169 Seal Rock Dr | 1 | : 4 | Tree 1 | Private 1 | 5 | Width 3ft | 5981053.81587 | 2112927.8042099997 | 37.7805969621145 | -122.509197833038 | (37.7805969621145, -122.509197833038) | |||
59532 | 59532 | 250982 | Undocumented 2 | Melaleuca nesophila :: Pink Melaleuca 93 | 145 Seal Rock Dr | 2 | : 4 | Tree 1 | Private 1 | 6 | Width 3ft | 5981196.97714 | 2112934.78303 | 37.7806245632172 | -122.50870309708901 | (37.7806245632172, -122.508703097089) | |||
71380 | 71380 | 141700 | Undocumented 2 | Melaleuca nesophila :: Pink Melaleuca 93 | 150 BEAUMONT AVE | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 0ft | 5996841.3555 | 2111986.1699 | 37.778929621332004 | -122.454513467721 | (37.778929621332, -122.454513467721) | |||
71672 | 71672 | 46376 | Permitted Site 1 | Melaleuca nesophila :: Pink Melaleuca 93 | 2231 43rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/05/2002 12:00:00 AM | 6 | Permit Number 44613 | 5982943.5226 | 2099924.3833 | 37.7450044993486 | -122.501698223647 | (37.7450044993486, -122.501698223647) | |
136846 | 136846 | 39815 | Permitted Site 1 | Melaleuca nesophila :: Pink Melaleuca 93 | 2090 45th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/06/1999 12:00:00 AM | 6 | Permit Number 41146 | 5982333.7204 | 2100889.1498 | 37.747617643049104 | -122.50387821553801 | (37.7476176430491, -122.503878215538) |
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");