trees
7,322 rows where qSpecies_id = 1 sorted by YCoord
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 | ||||||||||||||
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 | ||
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 | ||
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 | ||
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 | ||
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 | |||
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 | ||
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 | ||
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 | ||||
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 | |||
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 | ||||
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 | ||
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 | |||
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 | ||
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 | ||
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 | ||
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 | ||
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 | |||
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 | ||
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 | ||
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 | |||
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 | ||
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 | |||
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 | |||
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 | ||
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 | ||
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 | ||
190109 | 30548 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 401 Tunnel Ave | 18 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/25/1995 12:00:00 AM | 7 | Permit Number 34540 | 6011718.12319 | 2086532.40482 | 37.709881047334 | -122.401259311572 | (37.709881047334, -122.401259311572) | 10 | 3 | 8 | 309 | 1 | ||
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 | ||
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 | |||
153111 | 30547 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 401 Tunnel Ave | 19 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/25/1995 12:00:00 AM | 7 | Permit Number 34540 | 6011718.16033 | 2086553.89012 | 37.7099400437706 | -122.401260692024 | (37.7099400437706, -122.401260692024) | 10 | 3 | 8 | 309 | 1 | ||
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 | ||||
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 | |
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 | ||||
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 | |||
101217 | 30546 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 401 Tunnel Ave | 20 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/25/1995 12:00:00 AM | 8 | Permit Number 34540 | 6011718.58864 | 2086574.96985 | 37.7099979484159 | -122.401260692029 | (37.7099979484159, -122.401260692029) | 10 | 3 | 8 | 309 | 1 | ||
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 | ||
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 | |||
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 | ||
179566 | 30545 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 401 Tunnel Ave | 21 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/25/1995 12:00:00 AM | 7 | Permit Number 34540 | 6011719.78338 | 2086594.44223 | 37.7100514823568 | -122.401257930211 | (37.7100514823568, -122.401257930211) | 10 | 3 | 8 | 309 | 1 | ||
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 | |||
86921 | 30544 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 401 Tunnel Ave | 22 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/25/1995 12:00:00 AM | 10 | Permit Number 34540 | 6011720.93771 | 2086611.92604 | 37.7100995538248 | -122.401255168406 | (37.7100995538248, -122.401255168406) | 10 | 3 | 8 | 309 | 1 | ||
132641 | 180216 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 75 Garrison Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 2ft | 6008232.1427 | 2086617.22115 | 37.7099188332604 | -122.413313545478 | (37.7099188332604, -122.413313545478) | 9 | 7 | 8 | 309 | 39 | |||
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 | |||
189240 | 180185 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 2500 Bay Shore Blvd | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6010852.50351 | 2086625.63078 | 37.7100886954045 | -122.404257627902 | (37.7100886954045, -122.404257627902) | 10 | 3 | 8 | 309 | 1 | |||
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 | |||
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 | |||
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 | ||
44999 | 180215 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 67 Garrison Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 2ft | 6008244.87242 | 2086654.93829 | 37.7100231114573 | -122.413272214455 | (37.7100231114573, -122.413272214455) | 9 | 7 | 8 | 309 | 39 | |||
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 | |||
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 | |||
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 | |||
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 | ||||
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 | ||
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 | ||||
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 | |||
140326 | 180214 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 61 Garrison Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 2ft | 6008256.77817 | 2086683.98233 | 37.7101035288322 | -122.41323311822 | (37.7101035288322, -122.41323311822) | 9 | 7 | 8 | 309 | 39 | |||
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 | ||||
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 | ||||
174697 | 180213 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 57 Garrison Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 2ft | 6008263.9243 | 2086701.53775 | 37.7101521335973 | -122.413209660291 | (37.7101521335973, -122.413209660291) | 9 | 7 | 8 | 309 | 39 | |||
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 | |
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 | ||||
67781 | 31020 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 239 Naylor St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/23/2001 12:00:00 AM | 7 | Permit Number 43764 | 6002665.06815 | 2086718.08858 | 37.7098816606848 | -122.432561587743 | (37.7098816606848, -122.432561587743) | 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 | |||
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 | ||||
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 | |||
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 |
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) );