trees
7,322 rows where qSpecies_id = 1 sorted by Location
This data as json, CSV (advanced)
rowid | TreeID | qLegalStatus_id | qSpecies_id | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker_id | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location ▼ | Fire Prevention Districts | Police Districts | Supervisor Districts | Zip Codes | Neighborhoods (old) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
90 | 259864 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1398x Brussels St | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 03/30/2019 12:00:00 AM | 3 | |||||||||||||
1095 | 255202 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 301X Burrows St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | ||||||||||||||
1138 | 260594 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 3090x Jennings St | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 08/24/2019 12:00:00 AM | 3 | ||||||||||||
2475 | 259866 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 101x Desmond St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 03/30/2019 12:00:00 AM | 3 | ||||||||||||
4112 | 255223 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1051 Silver Ave | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | ||||||||||||||
6640 | 255204 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 301X Burrows St | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | ||||||||||||||
6981 | 259867 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 101x Desmond St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 03/30/2019 12:00:00 AM | 3 | ||||||||||||
7570 | 36838 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/26/1998 12:00:00 AM | Permit Number 39538 | ||||||||||||||
7587 | 259089 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1201 Visitacion Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 06/01/2019 12:00:00 AM | 3 | |||||||||||||
7844 | 36854 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/26/1998 12:00:00 AM | Permit Number 39538 | ||||||||||||||
8196 | 255225 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 400 Bacon St | 6 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | ||||||||||||||
8832 | 260593 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 3090x Jennings St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 08/24/2019 12:00:00 AM | 3 | ||||||||||||
10581 | 260591 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 3090x Jennings St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 08/24/2019 12:00:00 AM | 3 | ||||||||||||
11185 | 98268 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 401X Esmeralda Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 3x3 | |||||||||||||
11245 | 255201 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 301X Burrows St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | ||||||||||||||
11633 | 259865 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 101x Desmond St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 03/30/2019 12:00:00 AM | 3 | ||||||||||||
11767 | 255200 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 301X Burrows St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | ||||||||||||||
12758 | 260592 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 3090x Jennings St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 08/24/2019 12:00:00 AM | 3 | ||||||||||||
13636 | 36840 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/26/1998 12:00:00 AM | Permit Number 39538 | ||||||||||||||
13881 | 255222 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1051 Silver Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | ||||||||||||||
14357 | 36839 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/26/1998 12:00:00 AM | Permit Number 39538 | ||||||||||||||
14394 | 36837 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/26/1998 12:00:00 AM | Permit Number 39538 | ||||||||||||||
15903 | 255203 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 301X Burrows St | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | ||||||||||||||
18459 | 36836 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/26/1998 12:00:00 AM | Permit Number 39538 | ||||||||||||||
96228 | 179986 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 818 Brunswick St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 5997558.28952 | 2086239.87811 | 37.708277679339 | -122.450177037641 | (37.708277679339, -122.450177037641) | 9 | 7 | 6 | 28861 | 5 | |||
134879 | 112634 | Undocumented 4 | Tristaniopsis laurina :: Swamp Myrtle 1 | 800x BRUNSWICK ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5x6 | 5997602 | 2086276 | 37.70837936312 | -122.450028571713 | (37.70837936312, -122.450028571713) | 9 | 7 | 6 | 28861 | 5 | ||||
123015 | 180168 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 5935 Mission St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 5996569.70599 | 2086304.01805 | 37.7083971704608 | -122.453598302421 | (37.7083971704608, -122.453598302421) | 9 | 7 | 6 | 28861 | 5 | |||
1231 | 15974 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 5933 Mission St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 09/30/2016 12:00:00 AM | 3 | 3X3 | 5996593.31856 | 2086313.84227 | 37.7084254991124 | -122.453517403906 | (37.7084254991124, -122.453517403906) | 9 | 7 | 6 | 28861 | 5 | ||
12960 | 181057 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 5931 Mission St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/10/2017 03:33:00 PM | 3 | Width 3ft | 5996618.07355 | 2086323.26043 | 37.7084527782463 | -122.453432527712 | (37.7084527782463, -122.453432527712) | 9 | 7 | 6 | 28861 | 5 | ||
64788 | 180169 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 5921 Mission St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 5996782.55272 | 2086390.13608 | 37.7086458303022 | -122.45286889471 | (37.7086458303022, -122.45286889471) | 9 | 7 | 6 | 28861 | 5 | |||
18270 | 71587 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 129 Goethe St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 5 | 5994891.94658 | 2086476.69081 | 37.7087749666595 | -122.459409293405 | (37.7087749666595, -122.459409293405) | 9 | 8 | 6 | 28861 | 25 | |||
191624 | 30542 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 401 Tunnel Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/25/1995 12:00:00 AM | 3 | Permit Number 34540 | 6011709.31572 | 2086131.9776 | 37.7087810622767 | -122.401261631812 | (37.7087810622767, -122.401261631812) | 10 | 3 | 8 | 309 | 1 | ||
7504 | 73605 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 129 Goethe St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 5 | 5994880.25496 | 2086485.81008 | 37.7087993338054 | -122.459450360941 | (37.7087993338054, -122.459450360941) | 9 | 8 | 6 | 28861 | 25 | |||
58778 | 30540 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 401 Tunnel Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/25/1995 12:00:00 AM | 4 | Permit Number 34540 | 6011709.69759 | 2086150.77213 | 37.7088326896354 | -122.401261631846 | (37.7088326896354, -122.401261631846) | 10 | 3 | 8 | 309 | 1 | ||
22760 | 30551 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 401 Tunnel Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/25/1995 12:00:00 AM | 3 | Permit Number 34540 | 6011709.66733 | 2086170.88712 | 37.7088879197218 | -122.401263148996 | (37.7088879197218, -122.401263148996) | 10 | 3 | 8 | 309 | 1 | ||
146694 | 30560 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 401 Tunnel Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/25/1995 12:00:00 AM | 3 | Permit Number 34540 | 6011710.93593 | 2086190.10088 | 37.7089407476737 | -122.401260113786 | (37.7089407476737, -122.401260113786) | 10 | 3 | 8 | 309 | 1 | ||
5422 | 122567 | Planning Code 138.1 required 2 | Tristaniopsis laurina :: Swamp Myrtle 1 | 241 Flournoy St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/02/2020 12:00:00 AM | 3 | 3x3 | Permit Number 777809 | 5994026.14526 | 2086558.74537 | 37.7089504501359 | -122.46240754496 | (37.7089504501359, -122.46240754496) | 9 | 8 | 6 | 28861 | 25 | |
15462 | 71581 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 237 Flournoy St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 5 | 5994022.88639 | 2086563.0023 | 37.7089619510012 | -122.462419116553 | (37.7089619510012, -122.462419116553) | 9 | 8 | 6 | 28861 | 25 | |||
179759 | 180218 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 241 Flournoy St | 1 | : | Tree | Private 2 | 1 | Width 3ft | 5994016.46026 | 2086567.83124 | 37.7089748400807 | -122.462441676038 | (37.7089748400807, -122.462441676038) | 9 | 8 | 6 | 28861 | 25 | |||
9203 | 30559 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 401 Tunnel Ave | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/25/1995 12:00:00 AM | 4 | Permit Number 34540 | 6011712.00106 | 2086211.42806 | 37.7089993673055 | -122.401257930213 | (37.7089993673055, -122.401257930213) | 10 | 3 | 8 | 309 | 1 | ||
137131 | 180001 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 62 Tomaso Ct | 6 | Front Yard : Yard | Tree | Private 2 | 22 | Width 8ft | 6009181.15123 | 2086279.38185 | 37.7090444314296 | -122.410009745679 | (37.7090444314296, -122.410009745679) | 9 | 7 | 8 | 309 | 39 | |||
104678 | 15959 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 5865 Mission St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/01/1995 12:00:00 AM | 6 | 3X3 | 5997123.14276 | 2086529.76075 | 37.7090487194007 | -122.451701842659 | (37.7090487194007, -122.451701842659) | 9 | 7 | 6 | 28861 | 5 | ||
151156 | 30558 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 401 Tunnel Ave | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/25/1995 12:00:00 AM | 3 | Permit Number 34540 | 6011712.43745 | 2086232.90557 | 37.7090583646351 | -122.401257930224 | (37.7090583646351, -122.401257930224) | 10 | 3 | 8 | 309 | 1 | ||
31547 | 30557 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 401 Tunnel Ave | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/25/1995 12:00:00 AM | 5 | Permit Number 34540 | 6011712.35311 | 2086248.42514 | 37.7091009735907 | -122.401259311574 | (37.7091009735907, -122.401259311574) | 10 | 3 | 8 | 309 | 1 | ||
112028 | 94597 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 2555 Bay Shore Blvd | 12 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 6010710.5 | 2086281.9 | 37.7091369436285 | -122.404724239792 | (37.7091369436285, -122.404724239792) | 10 | 3 | 8 | 309 | 1 | ||||
5743 | 30556 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 401 Tunnel Ave | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/25/1995 12:00:00 AM | 4 | Permit Number 34540 | 6011713.13245 | 2086267.11073 | 37.7091523239944 | -122.40125793023 | (37.7091523239944, -122.40125793023) | 10 | 3 | 8 | 309 | 1 | ||
104818 | 180399 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 349 Chicago Way | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 2 | Width 6ft | 6002410.48398 | 2086459.29818 | 37.7091566380421 | -122.433422996175 | (37.7091566380421, -122.433422996175) | 9 | 7 | 6 | 28861 | 5 | |||
94527 | 69328 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 244 Lowell St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/23/1994 12:00:00 AM | 11 | Permit Number 33411 | 5998992.03694 | 2086536.8188 | 37.7091749554307 | -122.445243198623 | (37.7091749554307, -122.445243198623) | 9 | 7 | 6 | 28861 | 5 | ||
91614 | 15946 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 5809 Mission St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/23/2005 12:00:00 AM | 3 | 3X3 | 5997438.5856 | 2086576.59062 | 37.7091953641971 | -122.450615004797 | (37.7091953641971, -122.450615004797) | 9 | 7 | 6 | 28861 | 5 | ||
135499 | 15954 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 5845 Mission St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 11/20/2013 12:00:00 AM | 3 | 4x6 | 5997263.95979 | 2086584.52293 | 37.709207147548 | -122.451219107291 | (37.709207147548, -122.451219107291) | 9 | 7 | 6 | 28861 | 5 | ||
119532 | 30555 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 401 Tunnel Ave | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/25/1995 12:00:00 AM | 3 | Permit Number 34540 | 6011713.20166 | 2086290.18715 | 37.7092156911269 | -122.401259311564 | (37.7092156911269, -122.401259311564) | 10 | 3 | 8 | 309 | 1 | ||
61027 | 180221 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 248 Wilson St | 2 | : | Tree | Private 2 | 7 | Width 3ft | 5994358.2246 | 2086656.84176 | 37.7092389170082 | -122.461266945616 | (37.7092389170082, -122.461266945616) | 9 | 8 | 6 | 28861 | 25 | |||
25672 | 180170 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 5845 Mission St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 4ft | 5997301.47519 | 2086598.64294 | 37.7092480658079 | -122.451090466445 | (37.7092480658079, -122.451090466445) | 9 | 7 | 6 | 28861 | 5 | |||
88277 | 180184 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 5818 Mission St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 0 | Width 3ft | 5997152.40975 | 2086607.26455 | 37.7092632032078 | -122.451606278907 | (37.7092632032078, -122.451606278907) | 9 | 7 | 6 | 28861 | 25 | |||
45386 | 30554 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 401 Tunnel Ave | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/25/1995 12:00:00 AM | 4 | Permit Number 34540 | 6011714.03756 | 2086311.65654 | 37.7092746884476 | -122.401257930228 | (37.7092746884476, -122.401257930228) | 10 | 3 | 8 | 309 | 1 | ||
10045 | 71608 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 250 Wilson St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 7 | 5994331.5401 | 2086682.33238 | 37.7093073724942 | -122.461361017415 | (37.7093073724942, -122.461361017415) | 9 | 8 | 6 | 28861 | 25 | |||
25709 | 30553 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 401 Tunnel Ave | 11 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/25/1995 12:00:00 AM | 3 | Permit Number 34540 | 6011714.36082 | 2086327.56578 | 37.7093183900986 | -122.401257930207 | (37.7093183900986, -122.401257930207) | 10 | 3 | 8 | 309 | 1 | ||
18042 | 180171 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 5845 Mission St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 4ft | 5997361.4678 | 2086623.37535 | 37.7093194099304 | -122.450884905728 | (37.7093194099304, -122.450884905728) | 9 | 7 | 6 | 28861 | 5 | |||
25625 | 15936 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 5810X MISSION ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | 4X4 | 5997175 | 2086632 | 37.7093324147693 | -122.451529986796 | (37.7093324147693, -122.451529986796) | 9 | 7 | 6 | 28861 | 25 | |||
80676 | 15937 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 5810X MISSION ST | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 8 | 4X4 | 5997175 | 2086632 | 37.7093324147693 | -122.451529986796 | (37.7093324147693, -122.451529986796) | 9 | 7 | 6 | 28861 | 25 | |||
94566 | 15950 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 5823 MISSION ST | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 01/30/2014 12:00:00 AM | 3 | 3X3 | 5997354 | 2086632 | 37.7093426637375 | -122.450911336997 | (37.7093426637375, -122.450911336997) | 9 | 7 | 6 | 28861 | 5 | ||
163078 | 15949 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 5823 MISSION ST | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/25/2015 12:00:00 AM | 3 | 4X4 | 5997354 | 2086632 | 37.7093426637375 | -122.450911336997 | (37.7093426637375, -122.450911336997) | 9 | 7 | 6 | 28861 | 5 | ||
171064 | 180183 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 5810 Mission St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 4ft | 5997223.97549 | 2086636.40948 | 37.7093473266958 | -122.451361038275 | (37.7093473266958, -122.451361038275) | 9 | 7 | 6 | 28861 | 25 | |||
36242 | 180400 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 511 Cordova St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 6ft | 6002102.27199 | 2086536.91631 | 37.709352269367 | -122.434493768575 | (37.709352269367, -122.434493768575) | 9 | 7 | 6 | 28861 | 5 | |||
118363 | 30552 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 401 Tunnel Ave | 12 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/25/1995 12:00:00 AM | 4 | Permit Number 34540 | 6011714.85378 | 2086351.82742 | 37.7093850352498 | -122.401257930217 | (37.7093850352498, -122.401257930217) | 10 | 3 | 8 | 309 | 1 | ||
131981 | 180182 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 5800 Mission St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 4ft | 5997258.08151 | 2086650.32704 | 37.7093874940164 | -122.45124416599 | (37.7093874940164, -122.45124416599) | 9 | 7 | 6 | 28861 | 25 | |||
158803 | 173855 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 511 Cordova St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5xt | 6002114 | 2086554 | 37.7093998431938 | -122.434454455367 | (37.7093998431938, -122.434454455367) | 9 | 7 | 6 | 28861 | 5 | ||||
86204 | 180181 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 5800 Mission St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 4ft | 5997274.84313 | 2086656.60213 | 37.709405683693 | -122.451186687614 | (37.709405683693, -122.451186687614) | 9 | 7 | 6 | 28861 | 25 | |||
166231 | 15945 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 5805 Mission St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/01/1995 12:00:00 AM | 6 | 3X3 | 5997438.4638 | 2086653.86743 | 37.7094075417074 | -122.450620993373 | (37.7094075417074, -122.450620993373) | 9 | 7 | 6 | 28861 | 5 | ||
143885 | 180180 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 5800 Mission St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 4ft | 5997294.9638 | 2086664.46286 | 37.7094284194653 | -122.451117714107 | (37.7094284194653, -122.451117714107) | 9 | 7 | 6 | 28861 | 25 | |||
88641 | 251741 | Undocumented 4 | Tristaniopsis laurina :: Swamp Myrtle 1 | 300 Naylor St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6002771 | 2086560 | 37.7094535905361 | -122.432184185389 | (37.7094535905361, -122.432184185389) | 9 | 7 | 6 | 28861 | 5 | ||||
193289 | 180219 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 254 Wilson St | 1 | : | Tree | Private 2 | 6 | Width 3ft | 5994266.23368 | 2086739.00195 | 37.7094592149324 | -122.461590831079 | (37.7094592149324, -122.461590831079) | 9 | 8 | 6 | 28861 | 25 | |||
70140 | 180220 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 254 Wilson St | 2 | : | Tree | Private 2 | 6 | Width 3ft | 5994253.3591 | 2086751.7904 | 37.7094935879269 | -122.461636254036 | (37.7094935879269, -122.461636254036) | 9 | 8 | 6 | 28861 | 25 | |||
50424 | 179980 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 670 Brunswick St | 14 | Sidewalk: Curb side : Pot | Tree | Private 2 | 7 | 5998613.38234 | 2086668.65922 | 37.7095153380418 | -122.446561361025 | (37.7095153380418, -122.446561361025) | 9 | 7 | 6 | 28861 | 5 | ||||
86807 | 30549 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 401 Tunnel Ave | 13 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/25/1995 12:00:00 AM | 6 | Permit Number 34540 | 6011714.66567 | 2086401.56807 | 37.709521602706 | -122.4012620734 | (37.709521602706, -122.4012620734) | 10 | 3 | 8 | 309 | 1 | ||
153557 | 179979 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 670 Brunswick St | 13 | Sidewalk: Curb side : Pot | Tree | Private 2 | 7 | 5998643.39451 | 2086681.70368 | 37.7095528694359 | -122.446458572104 | (37.7095528694359, -122.446458572104) | 9 | 7 | 6 | 28861 | 5 | ||||
43236 | 179978 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 670 Brunswick St | 12 | Sidewalk: Curb side : Pot | Tree | Private 2 | 6 | 5998663.42353 | 2086686.16888 | 37.7095662738459 | -122.446389669661 | (37.7095662738459, -122.446389669661) | 9 | 7 | 6 | 28861 | 5 | ||||
171000 | 30543 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 401 Tunnel Ave | 14 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/25/1995 12:00:00 AM | 5 | Permit Number 34540 | 6011714.28714 | 2086422.26625 | 37.7095784146801 | -122.401264835207 | (37.7095784146801, -122.401264835207) | 10 | 3 | 8 | 309 | 1 | ||
174888 | 179977 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 670 Brunswick St | 11 | Sidewalk: Curb side : Pot | Tree | Private 2 | 7 | 5998676.25855 | 2086690.45816 | 37.7095787843051 | -122.446345618154 | (37.7095787843051, -122.446345618154) | 9 | 7 | 6 | 28861 | 5 | ||||
49352 | 180011 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1 Lawrence Ave | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 5997275.603 | 2086720.88269 | 37.7095822269181 | -122.451188694021 | (37.7095822269181, -122.451188694021) | 9 | 7 | 6 | 28861 | 25 | |||
149166 | 15933 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 5777 Mission St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/01/1995 12:00:00 AM | 6 | 3X3 | 5997625.74384 | 2086728.67822 | 37.7096236730671 | -122.449979113963 | (37.7096236730671, -122.449979113963) | 9 | 7 | 6 | 28861 | 5 | ||
97740 | 180010 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1 Lawrence Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 5997262.56254 | 2086737.01263 | 37.7096257693921 | -122.451234926375 | (37.7096257693921, -122.451234926375) | 9 | 7 | 6 | 28861 | 25 | |||
6371 | 179976 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 670 Brunswick St | 9 | Sidewalk: Curb side : Pot | Tree | Private 2 | 7 | 5998720.79345 | 2086710.36043 | 37.7096359749025 | -122.446193129116 | (37.7096359749025, -122.446193129116) | 9 | 7 | 6 | 28861 | 5 | ||||
50607 | 180172 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 5775 Mission St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 0 | Width 3ft | 5997650.14628 | 2086739.63291 | 37.7096551484353 | -122.449895564236 | (37.7096551484353, -122.449895564236) | 9 | 7 | 6 | 28861 | 5 | |||
93974 | 180009 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1 Lawrence Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 5997247.3865 | 2086752.55268 | 37.7096675698642 | -122.451288497174 | (37.7096675698642, -122.451288497174) | 9 | 7 | 6 | 28861 | 25 | |||
95707 | 180179 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 5750 Mission St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 0 | Width 3ft | 5997506.02305 | 2086750.31915 | 37.7096762429258 | -122.450394446945 | (37.7096762429258, -122.450394446945) | 9 | 7 | 6 | 28861 | 25 | |||
174295 | 179975 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 670 Brunswick St | 4 | Sidewalk: Curb side : Pot | Tree | Private 2 | 8 | 5998755.4264 | 2086725.5872 | 37.7096797619799 | -122.446074526535 | (37.7096797619799, -122.446074526535) | 9 | 7 | 6 | 28861 | 5 | ||||
136989 | 15932 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 5771 Mission St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/01/1995 12:00:00 AM | 6 | 3X3 | 5997674.88478 | 2086749.48372 | 37.709683611969 | -122.44981077346 | (37.709683611969, -122.44981077346) | 9 | 7 | 6 | 28861 | 5 | ||
10319 | 180008 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1 Lawrence Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 5997232.2014 | 2086767.6701 | 37.7097082093476 | -122.451342068885 | (37.7097082093476, -122.451342068885) | 9 | 7 | 6 | 28861 | 25 | |||
100004 | 30541 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 401 Tunnel Ave | 15 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/25/1995 12:00:00 AM | 6 | Permit Number 34540 | 6011717.72591 | 2086473.52466 | 37.7097193519468 | -122.401256549776 | (37.7097193519468, -122.401256549776) | 10 | 3 | 8 | 309 | 1 | ||
168252 | 15931 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 5767 Mission St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/01/1995 12:00:00 AM | 6 | 3x3 | 5997735.60664 | 2086774.39401 | 37.7097554839914 | -122.449602702713 | (37.7097554839914, -122.449602702713) | 9 | 7 | 6 | 28861 | 5 | ||
121029 | 68739 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1 Lawrence Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/16/1993 12:00:00 AM | 8 | Permit Number 32659 | 5997216.23373 | 2086785.97531 | 37.7097575569365 | -122.451398575111 | (37.7097575569365, -122.451398575111) | 9 | 7 | 6 | 28861 | 25 | ||
84635 | 251740 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 240 Naylor St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/11/2017 08:43:00 AM | 3 | 3x3 | 6002635 | 2086674 | 37.7097588978443 | -122.432662361521 | (37.7097588978443, -122.432662361521) | 9 | 7 | 6 | 28861 | 5 | ||
39685 | 32268 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 30 Lawrence Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/15/1996 12:00:00 AM | 6 | Permit Number 36854 | 5997257.50064 | 2086789.55506 | 37.7097697490512 | -122.451256207916 | (37.7097697490512, -122.451256207916) | 9 | 7 | 6 | 28861 | 25 | ||
82330 | 30550 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 401 Tunnel Ave | 16 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/25/1995 12:00:00 AM | 5 | Permit Number 34540 | 6011719.36058 | 2086494.97782 | 37.7097783492625 | -122.401252406578 | (37.7097783492625, -122.401252406578) | 10 | 3 | 8 | 309 | 1 | ||
125937 | 180217 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 91 Garrison Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 2ft | 6008216.77598 | 2086576.98292 | 37.7098074845964 | -122.4133638122 | (37.7098074845964, -122.4133638122) | 9 | 7 | 8 | 309 | 39 | |||
90301 | 15925 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 5732 Mission St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/26/2012 12:00:00 AM | 3 | 3x3 | 5997636.25268 | 2086801.42761 | 37.709824027618 | -122.449948033398 | (37.709824027618, -122.449948033398) | 9 | 7 | 6 | 28861 | 25 | ||
174121 | 30561 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 401 Tunnel Ave | 17 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/25/1995 12:00:00 AM | 6 | Permit Number 34540 | 6011718.10247 | 2086511.71476 | 37.7098242353839 | -122.401257930218 | (37.7098242353839, -122.401257930218) | 10 | 3 | 8 | 309 | 1 | ||
98503 | 15924 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 5732 Mission St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/23/1995 12:00:00 AM | 6 | 3X3 | 5997611.35068 | 2086807.77126 | 37.7098400209233 | -122.450034555797 | (37.7098400209233, -122.450034555797) | 9 | 7 | 6 | 28861 | 25 | ||
74529 | 31019 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 239 Naylor St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/23/2001 12:00:00 AM | 7 | Permit Number 43764 | 6002675.61901 | 2086708.2112 | 37.7098551378742 | -122.432524416984 | (37.7098551378742, -122.432524416984) | 9 | 7 | 6 | 28861 | 5 |
Advanced export
JSON shape: default, array, newline-delimited, object
CREATE TABLE "trees" ( [rowid] INTEGER PRIMARY KEY, [TreeID] TEXT, [qLegalStatus_id] INTEGER REFERENCES [qLegalStatus]([id]), [qSpecies_id] INTEGER, [qAddress] TEXT, [SiteOrder] TEXT, [qSiteInfo] TEXT, [PlantType] TEXT, [qCaretaker_id] INTEGER REFERENCES [qCaretaker]([id]), [qCareAssistant] TEXT, [PlantDate] TEXT, [DBH] TEXT, [PlotSize] TEXT, [PermitNotes] TEXT, [XCoord] TEXT, [YCoord] TEXT, [Latitude] TEXT, [Longitude] TEXT, [Location] TEXT, [Fire Prevention Districts] TEXT, [Police Districts] TEXT, [Supervisor Districts] TEXT, [Zip Codes] TEXT, [Neighborhoods (old)] TEXT, FOREIGN KEY(qSpecies_id) REFERENCES qSpecies(id) );