Data source: data.sfgov.org
This data as json, CSV (advanced)
Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord ▼ | Latitude | Longitude | Location |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
65025 | 65025 | 179986 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 818 Brunswick St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 5997558.28952 | 2086239.87811 | 37.708277679339 | -122.450177037641 | (37.708277679339, -122.450177037641) | |||
113003 | 113003 | 112634 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 800x BRUNSWICK ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5x6 | 5997602.0 | 2086276.0 | 37.70837936312 | -122.450028571713 | (37.70837936312, -122.450028571713) | ||||
53016 | 53016 | 180001 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 62 Tomaso Ct | 6 | Front Yard : Yard 7 | Tree 1 | Private 1 | 22 | Width 8ft | 6009181.15123 | 2086279.38185 | 37.709044431429604 | -122.41000974567899 | (37.7090444314296, -122.410009745679) | |||
27333 | 27333 | 180168 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 5935 Mission St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 5996569.70599 | 2086304.01805 | 37.7083971704608 | -122.453598302421 | (37.7083971704608, -122.453598302421) | |||
4188 | 4188 | 181057 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 5931 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/10/2017 03:33:00 PM | 3 | Width 3ft | 5996618.07355 | 2086323.26043 | 37.7084527782463 | -122.453432527712 | (37.7084527782463, -122.453432527712) | ||
152808 | 152808 | 180169 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 5921 Mission St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 5996782.55272 | 2086390.1360799999 | 37.7086458303022 | -122.45286889471001 | (37.7086458303022, -122.45286889471) | |||
30355 | 30355 | 180399 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 349 Chicago Way | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 2 | Width 6ft | 6002410.48398 | 2086459.29818 | 37.7091566380421 | -122.433422996175 | (37.7091566380421, -122.433422996175) | |||
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) | ||
165253 | 165253 | 73605 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 129 Goethe St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/30/1995 12:00:00 AM | 5 | 5994880.25496 | 2086485.81008 | 37.7087993338054 | -122.459450360941 | (37.7087993338054, -122.459450360941) | ||
164072 | 164072 | 180400 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 511 Cordova St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 6ft | 6002102.27199 | 2086536.9163099998 | 37.709352269366995 | -122.434493768575 | (37.709352269367, -122.434493768575) | |||
10115 | 10115 | 173855 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 511 Cordova St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5xt | 6002114.0 | 2086554.0 | 37.7093998431938 | -122.43445445536699 | (37.7093998431938, -122.434454455367) | ||||
3439 | 3439 | 251741 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 300 Naylor St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6002771.0 | 2086560.0 | 37.7094535905361 | -122.432184185389 | (37.7094535905361, -122.432184185389) | ||||
61136 | 61136 | 71581 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 237 Flournoy St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/30/1995 12:00:00 AM | 5 | 5994022.886390001 | 2086563.0023 | 37.70896195100121 | -122.46241911655301 | (37.7089619510012, -122.462419116553) | ||
64171 | 64171 | 180218 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 241 Flournoy St | 1 | : 4 | Tree 1 | Private 1 | 1 | Width 3ft | 5994016.46026 | 2086567.8312400002 | 37.70897484008071 | -122.462441676038 | (37.7089748400807, -122.462441676038) | |||
137561 | 137561 | 180217 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 91 Garrison Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 2ft | 6008216.77598 | 2086576.98292 | 37.7098074845964 | -122.41336381219999 | (37.7098074845964, -122.4133638122) | |||
48866 | 48866 | 180170 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 5845 Mission St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 4ft | 5997301.475190001 | 2086598.6429400002 | 37.7092480658079 | -122.45109046644501 | (37.7092480658079, -122.451090466445) | |||
51423 | 51423 | 180184 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 5818 Mission St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 3ft | 5997152.40975 | 2086607.26455 | 37.7092632032078 | -122.451606278907 | (37.7092632032078, -122.451606278907) | |||
61969 | 61969 | 180216 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 75 Garrison Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 2ft | 6008232.1427 | 2086617.22115 | 37.709918833260396 | -122.413313545478 | (37.7099188332604, -122.413313545478) | |||
183586 | 183586 | 180171 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 5845 Mission St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 4ft | 5997361.4678 | 2086623.37535 | 37.709319409930394 | -122.450884905728 | (37.7093194099304, -122.450884905728) | |||
33733 | 33733 | 180185 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 2500 Bay Shore Blvd | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6010852.50351 | 2086625.63078 | 37.7100886954045 | -122.404257627902 | (37.7100886954045, -122.404257627902) | |||
171613 | 171613 | 180183 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 5810 Mission St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 4ft | 5997223.97549 | 2086636.40948 | 37.7093473266958 | -122.451361038275 | (37.7093473266958, -122.451361038275) | |||
68232 | 68232 | 180182 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 5800 Mission St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 4ft | 5997258.08151 | 2086650.3270400001 | 37.7093874940164 | -122.45124416598999 | (37.7093874940164, -122.45124416599) | |||
45187 | 45187 | 180215 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 67 Garrison Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 2ft | 6008244.87242 | 2086654.9382900002 | 37.710023111457296 | -122.41327221445499 | (37.7100231114573, -122.413272214455) | |||
134205 | 134205 | 180181 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 5800 Mission St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 4ft | 5997274.84313 | 2086656.60213 | 37.709405683693 | -122.451186687614 | (37.709405683693, -122.451186687614) | |||
130669 | 130669 | 180221 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 248 Wilson St | 2 | : 4 | Tree 1 | Private 1 | 7 | Width 3ft | 5994358.2246 | 2086656.8417599997 | 37.70923891700821 | -122.461266945616 | (37.7092389170082, -122.461266945616) | |||
178151 | 178151 | 180180 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 5800 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 4ft | 5997294.9638 | 2086664.4628599999 | 37.7094284194653 | -122.451117714107 | (37.7094284194653, -122.451117714107) | |||
42326 | 42326 | 179980 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 670 Brunswick St | 14 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 7 | 5998613.38234 | 2086668.65922 | 37.7095153380418 | -122.446561361025 | (37.7095153380418, -122.446561361025) | ||||
4394 | 4394 | 251740 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 240 Naylor St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/11/2017 08:43:00 AM | 3 | 3x3 | 6002635.0 | 2086674.0 | 37.709758897844296 | -122.432662361521 | (37.7097588978443, -122.432662361521) | ||
137512 | 137512 | 179979 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 670 Brunswick St | 13 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 7 | 5998643.39451 | 2086681.70368 | 37.709552869435896 | -122.44645857210399 | (37.7095528694359, -122.446458572104) | ||||
163068 | 163068 | 71608 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 250 Wilson St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/30/1995 12:00:00 AM | 7 | 5994331.5401 | 2086682.33238 | 37.7093073724942 | -122.46136101741502 | (37.7093073724942, -122.461361017415) | ||
99052 | 99052 | 180214 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 61 Garrison Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 2ft | 6008256.77817 | 2086683.98233 | 37.7101035288322 | -122.41323311821999 | (37.7101035288322, -122.41323311822) | |||
67095 | 67095 | 179978 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 670 Brunswick St | 12 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 6 | 5998663.42353 | 2086686.16888 | 37.709566273845894 | -122.446389669661 | (37.7095662738459, -122.446389669661) | ||||
67547 | 67547 | 179977 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 670 Brunswick St | 11 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 7 | 5998676.25855 | 2086690.45816 | 37.7095787843051 | -122.446345618154 | (37.7095787843051, -122.446345618154) | ||||
28554 | 28554 | 180213 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 57 Garrison Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 2ft | 6008263.9243 | 2086701.53775 | 37.7101521335973 | -122.413209660291 | (37.7101521335973, -122.413209660291) | |||
53213 | 53213 | 179976 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 670 Brunswick St | 9 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 7 | 5998720.79345 | 2086710.36043 | 37.709635974902504 | -122.446193129116 | (37.7096359749025, -122.446193129116) | ||||
151119 | 151119 | 180011 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1 Lawrence Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 5997275.602999999 | 2086720.88269 | 37.7095822269181 | -122.451188694021 | (37.7095822269181, -122.451188694021) | |||
130318 | 130318 | 179975 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 670 Brunswick St | 4 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 8 | 5998755.4264 | 2086725.5872 | 37.7096797619799 | -122.446074526535 | (37.7096797619799, -122.446074526535) | ||||
174890 | 174890 | 180010 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1 Lawrence Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 5997262.56254 | 2086737.01263 | 37.7096257693921 | -122.45123492637501 | (37.7096257693921, -122.451234926375) | |||
162187 | 162187 | 180219 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 254 Wilson St | 1 | : 4 | Tree 1 | Private 1 | 6 | Width 3ft | 5994266.2336800005 | 2086739.00195 | 37.7094592149324 | -122.46159083107901 | (37.7094592149324, -122.461590831079) | |||
34487 | 34487 | 180172 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 5775 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 3ft | 5997650.14628 | 2086739.63291 | 37.709655148435296 | -122.44989556423599 | (37.7096551484353, -122.449895564236) | |||
175880 | 175880 | 180179 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 5750 Mission St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 3ft | 5997506.02305 | 2086750.31915 | 37.709676242925795 | -122.450394446945 | (37.7096762429258, -122.450394446945) | |||
115843 | 115843 | 180220 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 254 Wilson St | 2 | : 4 | Tree 1 | Private 1 | 6 | Width 3ft | 5994253.3591 | 2086751.7904 | 37.7094935879269 | -122.46163625403601 | (37.7094935879269, -122.461636254036) | |||
37301 | 37301 | 180009 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1 Lawrence Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 5997247.3865 | 2086752.55268 | 37.7096675698642 | -122.45128849717399 | (37.7096675698642, -122.451288497174) | |||
74913 | 74913 | 180008 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1 Lawrence Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 5997232.2014 | 2086767.6701 | 37.7097082093476 | -122.451342068885 | (37.7097082093476, -122.451342068885) | |||
41283 | 41283 | 180212 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 51 Garrison Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 2ft | 6008290.64939 | 2086775.65834 | 37.7103571538246 | -122.413122530382 | (37.7103571538246, -122.413122530382) | |||
4721 | 4721 | 253670 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1063 Prague St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6001095.0 | 2086792.0 | 37.7099954426001 | -122.437993315946 | (37.7099954426001, -122.437993315946) | ||||
4736 | 4736 | 253671 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1063 Prague St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6001095.0 | 2086792.0 | 37.7099954426001 | -122.437993315946 | (37.7099954426001, -122.437993315946) | ||||
56951 | 56951 | 180211 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 39 Garrison Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 2ft | 6008309.72741 | 2086823.54448 | 37.7104897103039 | -122.41305997625099 | (37.7104897103039, -122.413059976251) | |||
68479 | 68479 | 179981 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 23 Whittier St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 5ft | 5998169.97204 | 2086845.49283 | 37.7099755454025 | -122.448106579751 | (37.7099755454025, -122.448106579751) | |||
66382 | 66382 | 180206 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 530 Visitacion Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6010632.30731 | 2086848.9077700002 | 37.7106894623249 | -122.405034384026 | (37.7106894623249, -122.405034384026) | |||
181006 | 181006 | 179982 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 23 Whittier St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 5ft | 5998163.8312800005 | 2086864.4965400002 | 37.710027374234706 | -122.44812917073901 | (37.7100273742347, -122.448129170739) | |||
4324 | 4324 | 251737 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 228 Chicago Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/11/2017 08:13:00 AM | 3 | 3x3 | 6002872.0 | 2086877.0 | 37.7103297297312 | -122.43185773233601 | (37.7103297297312, -122.431857732336) | ||
43977 | 43977 | 179983 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 23 Whittier St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 5ft | 5998155.09065 | 2086884.2051799998 | 37.710080990013296 | -122.448160798105 | (37.7100809900133, -122.448160798105) | |||
78477 | 78477 | 99570 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 650X Brunswick St | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 3x6 | 5998578.4 | 2086902.6 | 37.710155688278 | -122.44669908653499 | (37.710155688278, -122.446699086535) | |||
86231 | 86231 | 99568 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 650X Brunswick St | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 3x6 | 5998578.4 | 2086902.6 | 37.710155688278 | -122.44669908653499 | (37.710155688278, -122.446699086535) | |||
96638 | 96638 | 99562 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 650X Brunswick St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 3x6 | 5998578.4 | 2086902.6 | 37.710155688278 | -122.44669908653499 | (37.710155688278, -122.446699086535) | |||
98094 | 98094 | 99575 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 650X Brunswick St | 17 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 3x6 | 5998578.4 | 2086902.6 | 37.710155688278 | -122.44669908653499 | (37.710155688278, -122.446699086535) | |||
111968 | 111968 | 99569 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 650X Brunswick St | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 3x6 | 5998578.4 | 2086902.6 | 37.710155688278 | -122.44669908653499 | (37.710155688278, -122.446699086535) | |||
124043 | 124043 | 99572 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 650X Brunswick St | 14 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 3x6 | 5998578.4 | 2086902.6 | 37.710155688278 | -122.44669908653499 | (37.710155688278, -122.446699086535) | |||
125970 | 125970 | 99571 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 650X Brunswick St | 13 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | 3x6 | 5998578.4 | 2086902.6 | 37.710155688278 | -122.44669908653499 | (37.710155688278, -122.446699086535) | |||
140140 | 140140 | 99566 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 650X Brunswick St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 3x6 | 5998578.4 | 2086902.6 | 37.710155688278 | -122.44669908653499 | (37.710155688278, -122.446699086535) | |||
4259 | 4259 | 252872 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 5700 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/10/2017 03:41:00 PM | 3 | 3x3 | 5997704.0 | 2086907.0 | 37.7101177815644 | -122.449721490093 | (37.7101177815644, -122.449721490093) | ||
169989 | 169989 | 179984 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 23 Whittier St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 5ft | 5998143.81112 | 2086907.5465900002 | 37.710144435400295 | -122.44820146183201 | (37.7101444354003, -122.448201461832) | |||
3423 | 3423 | 251752 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 128 South Hill Blvd | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | Width 6ft | 6003064.16129 | 2086909.24662 | 37.7104291634552 | -122.431195883608 | (37.7104291634552, -122.431195883608) | ||||
3432 | 3432 | 180655 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 128 South Hill Blvd | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 31 | Width 6ft | 6003064.16129 | 2086909.24662 | 37.7104291634552 | -122.431195883608 | (37.7104291634552, -122.431195883608) | |||
3488 | 3488 | 251753 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 128 South Hill Blvd | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | Width 6ft | 6003064.16129 | 2086909.24662 | 37.7104291634552 | -122.431195883608 | (37.7104291634552, -122.431195883608) | ||||
4473 | 4473 | 180841 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 25 Farragut Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/13/2017 12:10:00 PM | 3 | Width 2ft | 5997726.08242 | 2086911.31353 | 37.710130888906896 | -122.449645479868 | (37.7101308889069, -122.449645479868) | ||
118114 | 118114 | 180210 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 11 Garrison Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 2ft | 6008343.95421 | 2086916.8221 | 37.7107477527694 | -122.412948271445 | (37.7107477527694, -122.412948271445) | |||
4433 | 4433 | 180628 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 339 Cordova St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/11/2017 11:40:00 AM | 3 | Width 8ft | 6001976.18123 | 2086917.49182 | 37.710390087913794 | -122.43495675757299 | (37.7103900879138, -122.434956757573) | ||
72783 | 72783 | 179985 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 23 Whittier St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 5ft | 5998139.51533 | 2086920.9795799998 | 37.7101810737559 | -122.448217275509 | (37.7101810737559, -122.448217275509) | |||
4366 | 4366 | 251751 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 125 South Hill Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/11/2017 08:38:00 AM | 3 | 3x3 | 6003144.0 | 2086928.0 | 37.710485180250004 | -122.430921281744 | (37.71048518025, -122.430921281744) | ||
4396 | 4396 | 251750 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 125 South Hill Blvd | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/11/2017 08:46:00 AM | 3 | 3x3 | 6003144.0 | 2086928.0 | 37.710485180250004 | -122.430921281744 | (37.71048518025, -122.430921281744) | ||
166922 | 166922 | 180167 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 388 Pope St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6000605.77227 | 2086933.0298099997 | 37.7103548452706 | -122.43969428086099 | (37.7103548452706, -122.439694280861) | |||
133875 | 133875 | 180007 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 25 Farragut Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 2ft | 5997703.617219999 | 2086934.20431 | 37.71019245649521 | -122.449724772183 | (37.7101924564952, -122.449724772183) | |||
40761 | 40761 | 180203 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 650 Visitacion Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6010383.47623 | 2086944.2281 | 37.710937279492796 | -122.40590111464701 | (37.7109372794928, -122.405901114647) | |||
61398 | 61398 | 180166 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 388 Pope St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6000602.0664 | 2086944.56458 | 37.710386306254 | -122.43970791550801 | (37.710386306254, -122.439707915508) | |||
41160 | 41160 | 180204 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 650 Visitacion Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6010365.23615 | 2086949.58295 | 37.7109509626975 | -122.40596453395901 | (37.7109509626975, -122.405964533959) | |||
4466 | 4466 | 180840 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 25 Farragut Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/13/2017 12:05:00 PM | 3 | Width 2ft | 5997679.45955 | 2086959.0123599998 | 37.7102591915804 | -122.449810052203 | (37.7102591915804, -122.449810052203) | ||
55762 | 55762 | 180205 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 650 Visitacion Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6010334.9036 | 2086961.82833 | 37.7109828895218 | -122.406070233066 | (37.7109828895218, -122.406070233066) | |||
66537 | 66537 | 179987 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 765 Morse St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 2ft | 5998296.14725 | 2087014.5042 | 37.710446824338604 | -122.447682654627 | (37.7104468243386, -122.447682654627) | |||
29399 | 29399 | 180000 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1207 Sunnydale Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 2ft | 6008297.27699 | 2087017.51562 | 37.7110216161269 | -122.413116714483 | (37.7110216161269, -122.413116714483) | |||
4044 | 4044 | 159331 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 562 Ellington Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/05/2017 11:06:00 AM | 3 | Width 0ft | 5997894.14042 | 2087019.0117 | 37.7104362168201 | -122.449072394069 | (37.7104362168201, -122.449072394069) | ||
3409 | 3409 | 180620 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 50 Naylor St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 3ft | 6002386.3591599995 | 2087019.9409599998 | 37.71069467209271 | -122.43354641464501 | (37.7106946720927, -122.433546414645) | |||
33930 | 33930 | 179988 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 765 Morse St | 3 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 2 | Width 5ft | 5998318.043769999 | 2087022.65362 | 37.7104704522241 | -122.447607562158 | (37.7104704522241, -122.447607562158) | |||
69338 | 69338 | 179989 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 765 Morse St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 5ft | 5998350.145880001 | 2087034.76993 | 37.7105055554714 | -122.447497482426 | (37.7105055554714, -122.447497482426) | |||
31317 | 31317 | 180012 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 2168 Cayuga Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 2ft | 5996377.63541 | 2087048.98271 | 37.710431659053604 | -122.454315891261 | (37.7104316590536, -122.454315891261) | |||
42485 | 42485 | 179997 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1237 Sunnydale Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 2ft | 6008181.66174 | 2087059.5867700002 | 37.711130643633794 | -122.413519283384 | (37.7111306436338, -122.413519283384) | |||
52536 | 52536 | 71085 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 336 Allison St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/03/1990 12:00:00 AM | 7 | 6000237.45691 | 2087069.9768 | 37.7107099003031 | -122.440977070243 | (37.7107099003031, -122.440977070243) | ||
72444 | 72444 | 180013 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 2168 Cayuga Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 2ft | 5996393.76853 | 2087077.91648 | 37.7105120296854 | -122.454262220628 | (37.7105120296854, -122.454262220628) | |||
68495 | 68495 | 179999 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1255 Sunnydale Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 2ft | 6008115.02398 | 2087084.9825400002 | 37.711196633191 | -122.413751395721 | (37.711196633191, -122.413751395721) | |||
4032 | 4032 | 253155 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 546 Ellington Ave | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/05/2017 11:02:00 AM | 3 | 3x3 | 5997941.0 | 2087090.0 | 37.710633814489604 | -122.44891554828999 | (37.7106338144896, -122.44891554829) | |||
40417 | 40417 | 179998 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1261 Sunnydale Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 2ft | 6008092.10883 | 2087093.28829 | 37.7112181521801 | -122.413831183558 | (37.7112181521801, -122.413831183558) | |||
158704 | 158704 | 179996 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1267 Sunnydale Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 2ft | 6008066.08955 | 2087103.74717 | 37.711245408829704 | -122.413921852338 | (37.7112454088297, -122.413921852338) | |||
171046 | 171046 | 179995 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1279 Sunnydale Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 4ft | 6008040.0489300005 | 2087113.16137 | 37.711269795735795 | -122.414012521085 | (37.7112697957358, -122.414012521085) | |||
172953 | 172953 | 179994 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1285 Sunnydale Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 4ft | 6007995.26741 | 2087129.7512299998 | 37.7113128327965 | -122.414168470721 | (37.7113128327965, -122.414168470721) | |||
55564 | 55564 | 179993 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1297 Sunnydale Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 10ft | 6007905.78975 | 2087167.1090000002 | 37.7114103831536 | -122.414480370891 | (37.7114103831536, -122.414480370891) | |||
152565 | 152565 | 179992 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1301 Sunnydale Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 2ft | 6007862.0464 | 2087183.1554400001 | 37.7114519858033 | -122.414632694466 | (37.7114519858033, -122.414632694466) | |||
36429 | 36429 | 180165 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 309 Allison St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 2ft | 6000235.245680001 | 2087185.2549700001 | 37.7110263025015 | -122.440992977441 | (37.7110263025015, -122.440992977441) | |||
146985 | 146985 | 179991 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1307 Sunnydale Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 2ft | 6007807.38599 | 2087204.1273299998 | 37.711506499108 | -122.414823098908 | (37.711506499108, -122.414823098908) | |||
76023 | 76023 | 179990 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1321 Sunnydale Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 1ft | 6007776.62569 | 2087213.6387 | 37.7115308869208 | -122.41493008764799 | (37.7115308869208, -122.414930087648) |
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");