Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qCareAssistant
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude ▼ | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 4555 | 4555 | 253633 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1907 Judah St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/21/2016 12:00:00 AM | 3x3 | Permit Number 777409 | ||||||
| 7270 | 7270 | 98268 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 401X Esmeralda Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 3x3 | ||||||||
| 7799 | 7799 | 36854 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/26/1998 12:00:00 AM | Permit Number 39538 | |||||||||
| 9099 | 9099 | 36836 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/26/1998 12:00:00 AM | Permit Number 39538 | |||||||||
| 9535 | 9535 | 36839 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/26/1998 12:00:00 AM | Permit Number 39538 | |||||||||
| 13906 | 13906 | 36837 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/26/1998 12:00:00 AM | Permit Number 39538 | |||||||||
| 15723 | 15723 | 36838 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/26/1998 12:00:00 AM | Permit Number 39538 | |||||||||
| 16572 | 16572 | 36840 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/26/1998 12:00:00 AM | Permit Number 39538 | |||||||||
| 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) | ||||
| 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) | |||
| 10341 | 10341 | 15974 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 5933 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 09/30/2016 12:00:00 AM | 3 | 3X3 | 5996593.31856 | 2086313.8422700001 | 37.708425499112394 | -122.453517403906 | (37.7084254991124, -122.453517403906) | ||
| 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) | |||
| 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) | ||
| 26228 | 26228 | 30542 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 401 Tunnel Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/25/1995 12:00:00 AM | 3 | Permit Number 34540 | 6011709.315719999 | 2086131.9776 | 37.7087810622767 | -122.401261631812 | (37.7087810622767, -122.401261631812) | ||
| 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) | ||
| 171925 | 171925 | 30540 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 401 Tunnel Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/25/1995 12:00:00 AM | 4 | Permit Number 34540 | 6011709.69759 | 2086150.77213 | 37.7088326896354 | -122.40126163184601 | (37.7088326896354, -122.401261631846) | ||
| 69006 | 69006 | 30551 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 401 Tunnel Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/25/1995 12:00:00 AM | 3 | Permit Number 34540 | 6011709.667330001 | 2086170.88712 | 37.708887919721796 | -122.401263148996 | (37.7088879197218, -122.401263148996) | ||
| 136313 | 136313 | 30560 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 401 Tunnel Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/25/1995 12:00:00 AM | 3 | Permit Number 34540 | 6011710.935930001 | 2086190.1008799998 | 37.7089407476737 | -122.401260113786 | (37.7089407476737, -122.401260113786) | ||
| 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) | |||
| 76222 | 76222 | 30559 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 401 Tunnel Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/25/1995 12:00:00 AM | 4 | Permit Number 34540 | 6011712.00106 | 2086211.4280599998 | 37.708999367305495 | -122.40125793021299 | (37.7089993673055, -122.401257930213) | ||
| 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) | |||
| 11556 | 11556 | 15959 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 5865 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/01/1995 12:00:00 AM | 6 | 3X3 | 5997123.14276 | 2086529.76075 | 37.7090487194007 | -122.45170184265899 | (37.7090487194007, -122.451701842659) | ||
| 146453 | 146453 | 30558 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 401 Tunnel Ave | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/25/1995 12:00:00 AM | 3 | Permit Number 34540 | 6011712.43745 | 2086232.9055700002 | 37.7090583646351 | -122.401257930224 | (37.7090583646351, -122.401257930224) | ||
| 49317 | 49317 | 30557 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 401 Tunnel Ave | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/25/1995 12:00:00 AM | 5 | Permit Number 34540 | 6011712.35311 | 2086248.4251400002 | 37.7091009735907 | -122.401259311574 | (37.7091009735907, -122.401259311574) | ||
| 101994 | 101994 | 94597 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 2555 Bay Shore Blvd | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3x3 | 6010710.5 | 2086281.9 | 37.7091369436285 | -122.404724239792 | (37.7091369436285, -122.404724239792) | ||||
| 71332 | 71332 | 30556 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 401 Tunnel Ave | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/25/1995 12:00:00 AM | 4 | Permit Number 34540 | 6011713.13245 | 2086267.1107299998 | 37.709152323994395 | -122.40125793023 | (37.7091523239944, -122.40125793023) | ||
| 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) | |||
| 58807 | 58807 | 69328 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 244 Lowell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/23/1994 12:00:00 AM | 11 | Permit Number 33411 | 5998992.03694 | 2086536.8188 | 37.709174955430704 | -122.445243198623 | (37.7091749554307, -122.445243198623) | ||
| 94231 | 94231 | 15946 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 5809 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/23/2005 12:00:00 AM | 3 | 3X3 | 5997438.5856 | 2086576.5906200001 | 37.7091953641971 | -122.450615004797 | (37.7091953641971, -122.450615004797) | ||
| 12447 | 12447 | 15954 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 5845 Mission St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 11/20/2013 12:00:00 AM | 3 | 4x6 | 5997263.95979 | 2086584.52293 | 37.709207147548 | -122.451219107291 | (37.709207147548, -122.451219107291) | ||
| 178770 | 178770 | 30555 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 401 Tunnel Ave | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/25/1995 12:00:00 AM | 3 | Permit Number 34540 | 6011713.20166 | 2086290.18715 | 37.7092156911269 | -122.401259311564 | (37.7092156911269, -122.401259311564) | ||
| 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) | |||
| 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) | |||
| 186634 | 186634 | 30554 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 401 Tunnel Ave | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/25/1995 12:00:00 AM | 4 | Permit Number 34540 | 6011714.03756 | 2086311.65654 | 37.7092746884476 | -122.401257930228 | (37.7092746884476, -122.401257930228) | ||
| 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) | ||
| 179194 | 179194 | 30553 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 401 Tunnel Ave | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/25/1995 12:00:00 AM | 3 | Permit Number 34540 | 6011714.36082 | 2086327.5657799998 | 37.7093183900986 | -122.40125793020701 | (37.7093183900986, -122.401257930207) | ||
| 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) | |||
| 91890 | 91890 | 15937 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 5810X MISSION ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 8 | 4X4 | 5997175.0 | 2086632.0 | 37.7093324147693 | -122.451529986796 | (37.7093324147693, -122.451529986796) | |||
| 125217 | 125217 | 15936 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 5810X MISSION ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 4X4 | 5997175.0 | 2086632.0 | 37.7093324147693 | -122.451529986796 | (37.7093324147693, -122.451529986796) | |||
| 96741 | 96741 | 15950 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 5823 MISSION ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/30/2014 12:00:00 AM | 3 | 3X3 | 5997354.0 | 2086632.0 | 37.7093426637375 | -122.450911336997 | (37.7093426637375, -122.450911336997) | ||
| 121724 | 121724 | 15949 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 5823 MISSION ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/25/2015 12:00:00 AM | 3 | 4X4 | 5997354.0 | 2086632.0 | 37.7093426637375 | -122.450911336997 | (37.7093426637375, -122.450911336997) | ||
| 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) | |||
| 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) | |||
| 158233 | 158233 | 30552 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 401 Tunnel Ave | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/25/1995 12:00:00 AM | 4 | Permit Number 34540 | 6011714.8537800005 | 2086351.82742 | 37.709385035249795 | -122.401257930217 | (37.7093850352498, -122.401257930217) | ||
| 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) | |||
| 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) | ||||
| 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) | |||
| 11586 | 11586 | 15945 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 5805 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/01/1995 12:00:00 AM | 6 | 3X3 | 5997438.4638 | 2086653.8674299999 | 37.7094075417074 | -122.450620993373 | (37.7094075417074, -122.450620993373) | ||
| 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) | |||
| 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) | ||||
| 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) | |||
| 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) | |||
| 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) | ||||
| 36791 | 36791 | 30549 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 401 Tunnel Ave | 13 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/25/1995 12:00:00 AM | 6 | Permit Number 34540 | 6011714.66567 | 2086401.56807 | 37.709521602706 | -122.4012620734 | (37.709521602706, -122.4012620734) | ||
| 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) | ||||
| 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) | ||||
| 178864 | 178864 | 30543 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 401 Tunnel Ave | 14 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/25/1995 12:00:00 AM | 5 | Permit Number 34540 | 6011714.287140001 | 2086422.26625 | 37.7095784146801 | -122.401264835207 | (37.7095784146801, -122.401264835207) | ||
| 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) | ||||
| 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) | |||
| 12839 | 12839 | 15933 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 5777 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/01/1995 12:00:00 AM | 6 | 3X3 | 5997625.743840001 | 2086728.6782200001 | 37.7096236730671 | -122.449979113963 | (37.7096236730671, -122.449979113963) | ||
| 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) | |||
| 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) | ||||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | ||||
| 12860 | 12860 | 15932 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 5771 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/01/1995 12:00:00 AM | 6 | 3X3 | 5997674.88478 | 2086749.4837200001 | 37.709683611969 | -122.44981077346 | (37.709683611969, -122.44981077346) | ||
| 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) | |||
| 161267 | 161267 | 30541 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 401 Tunnel Ave | 15 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/25/1995 12:00:00 AM | 6 | Permit Number 34540 | 6011717.72591 | 2086473.5246599999 | 37.709719351946795 | -122.40125654977601 | (37.7097193519468, -122.401256549776) | ||
| 12612 | 12612 | 15931 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 5767 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/01/1995 12:00:00 AM | 6 | 3x3 | 5997735.60664 | 2086774.39401 | 37.7097554839914 | -122.449602702713 | (37.7097554839914, -122.449602702713) | ||
| 32239 | 32239 | 68739 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1 Lawrence Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/16/1993 12:00:00 AM | 8 | Permit Number 32659 | 5997216.23373 | 2086785.97531 | 37.709757556936495 | -122.45139857511101 | (37.7097575569365, -122.451398575111) | ||
| 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) | ||
| 172897 | 172897 | 32268 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 30 Lawrence Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/15/1996 12:00:00 AM | 6 | Permit Number 36854 | 5997257.50064 | 2086789.55506 | 37.709769749051205 | -122.45125620791599 | (37.7097697490512, -122.451256207916) | ||
| 59025 | 59025 | 30550 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 401 Tunnel Ave | 16 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/25/1995 12:00:00 AM | 5 | Permit Number 34540 | 6011719.36058 | 2086494.9778200001 | 37.7097783492625 | -122.40125240657801 | (37.7097783492625, -122.401252406578) | ||
| 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) | |||
| 11514 | 11514 | 15925 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 5732 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/26/2012 12:00:00 AM | 3 | 3x3 | 5997636.25268 | 2086801.42761 | 37.709824027618 | -122.449948033398 | (37.709824027618, -122.449948033398) | ||
| 178336 | 178336 | 30561 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 401 Tunnel Ave | 17 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/25/1995 12:00:00 AM | 6 | Permit Number 34540 | 6011718.102469999 | 2086511.71476 | 37.7098242353839 | -122.401257930218 | (37.7098242353839, -122.401257930218) | ||
| 101931 | 101931 | 15924 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 5732 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/23/1995 12:00:00 AM | 6 | 3X3 | 5997611.35068 | 2086807.7712599998 | 37.709840020923295 | -122.450034555797 | (37.7098400209233, -122.450034555797) | ||
| 72054 | 72054 | 31019 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 239 Naylor St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/23/2001 12:00:00 AM | 7 | Permit Number 43764 | 6002675.61901 | 2086708.2112 | 37.7098551378742 | -122.43252441698401 | (37.7098551378742, -122.432524416984) | |
| 12524 | 12524 | 15922 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 5718 Mission St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/23/1995 12:00:00 AM | 3 | 3X3 | 5997668.40751 | 2086814.8341299999 | 37.7098626786949 | -122.449837866439 | (37.7098626786949, -122.449837866439) | ||
| 76384 | 76384 | 30548 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 401 Tunnel Ave | 18 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/25/1995 12:00:00 AM | 7 | Permit Number 34540 | 6011718.12319 | 2086532.40482 | 37.709881047334 | -122.401259311572 | (37.709881047334, -122.401259311572) | ||
| 67527 | 67527 | 31020 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 239 Naylor St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/23/2001 12:00:00 AM | 7 | Permit Number 43764 | 6002665.06815 | 2086718.08858 | 37.70988166068479 | -122.432561587743 | (37.7098816606848, -122.432561587743) | |
| 11208 | 11208 | 15921 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 5718 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/25/1999 12:00:00 AM | 3 | 3X3 | 5997690.80196 | 2086825.40786 | 37.7098929930475 | -122.44976122890499 | (37.7098929930475, -122.449761228905) | ||
| 167337 | 167337 | 102734 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 5735 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/22/2013 12:00:00 AM | 1 | 3x3 | Permit Number 770005 | 5997875.716469999 | 2086830.45832 | 37.7099174384228 | -122.449122496232 | (37.7099174384228, -122.449122496232) | |
| 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) | ||
| 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) | |||
| 62429 | 62429 | 102735 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 5735 Mission St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/22/2013 12:00:00 AM | 1 | 3x3 | Permit Number 770005 | 5997893.47207 | 2086837.6698 | 37.7099382550256 | -122.44906164897199 | (37.7099382550256, -122.449061648972) | |
| 152616 | 152616 | 30547 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 401 Tunnel Ave | 19 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/25/1995 12:00:00 AM | 7 | Permit Number 34540 | 6011718.16033 | 2086553.89012 | 37.7099400437706 | -122.401260692024 | (37.7099400437706, -122.401260692024) | ||
| 10689 | 10689 | 44737 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 220 Saint Charles Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/03/2001 12:00:00 AM | 10 | Permit Number 43854 | 5992028.1183 | 2086972.4785799999 | 37.7099712034746 | -122.469343044645 | (37.7099712034746, -122.469343044645) | |
| 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) | |||
| 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) | ||||
| 158569 | 158569 | 30546 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 401 Tunnel Ave | 20 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/25/1995 12:00:00 AM | 8 | Permit Number 34540 | 6011718.58864 | 2086574.96985 | 37.7099979484159 | -122.401260692029 | (37.7099979484159, -122.401260692029) | ||
| 78681 | 78681 | 15919 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 5700 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 05/11/2016 12:00:00 AM | 3 | 3x3 | 5997805.8876412995 | 2086862.4796366 | 37.710001367541 | -122.44936614231199 | (37.710001367541, -122.449366142312) | ||
| 87050 | 87050 | 51974 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 5700 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/18/2005 12:00:00 AM | Permit Number 48194 | 5997805.51500265 | 2086863.40763228 | 37.7100038942899 | -122.44936749703399 | (37.7100038942899, -122.449367497034) | |||
| 122857 | 122857 | 36234 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 5698 Mission St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/05/1998 12:00:00 AM | 2 | 3x3 | Permit Number 39264 | 5997821.10019036 | 2086869.6666529 | 37.710021971633296 | -122.449314082525 | (37.7100219716333, -122.449314082525) |
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");