trees
8,298 rows where qLegalStatus_id = 4 sorted by qSpecies_id
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
91024 | 107690 | Undocumented 4 | Tristaniopsis laurina :: Swamp Myrtle 1 | 2199 Jackson St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4x4 | 6003671 | 2116909 | 37.7928358039924 | -122.431238497045 | (37.7928358039924, -122.431238497045) | 13 | 9 | 1 | 29490 | 27 | ||||
91161 | 79439 | Undocumented 4 | Tristaniopsis laurina :: Swamp Myrtle 1 | 360 Lily St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/12/2007 12:00:00 AM | 4 | 2x3 | Permit Number 49769 | 6004809.08231089 | 2110052.92705889 | 37.7740751590965 | -122.426812191246 | (37.7740751590965, -122.426812191246) | 7 | 9 | 11 | 28852 | 10 | |
91191 | 180655 | Undocumented 4 | Tristaniopsis laurina :: Swamp Myrtle 1 | 128 South Hill Blvd | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 31 | Width 6ft | 6003064.16129 | 2086909.24662 | 37.7104291634552 | -122.431195883608 | (37.7104291634552, -122.431195883608) | 9 | 7 | 6 | 28861 | 5 | |||
93002 | 121378 | Undocumented 4 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1195x Lincoln Way | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5992103 | 2107224 | 37.7655810886811 | -122.470558244073 | (37.7655810886811, -122.470558244073) | 11 | 8 | 11 | 56 | 12 | ||||
93999 | 107692 | Undocumented 4 | Tristaniopsis laurina :: Swamp Myrtle 1 | 2199 Jackson St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4x4 | 6003671 | 2116909 | 37.7928358039924 | -122.431238497045 | (37.7928358039924, -122.431238497045) | 13 | 9 | 1 | 29490 | 27 | ||||
94295 | 112302 | Undocumented 4 | Tristaniopsis laurina :: Swamp Myrtle 1 | 25x WALLER ST | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4x4 | 6005453 | 2109246 | 37.7718959184753 | -122.424527356528 | (37.7718959184753, -122.424527356528) | 7 | 9 | 5 | 28852 | 10 | ||||
95712 | 121690 | Undocumented 4 | Tristaniopsis laurina :: Swamp Myrtle 1 | 2421 16th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6009364 | 2106805 | 37.7654135871473 | -122.410826446835 | (37.7654135871473, -122.410826446835) | 8 | 4 | 7 | 28859 | 19 | ||||
96492 | 98011 | Undocumented 4 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1515 Taraval St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/19/2016 01:11:00 PM | 3 | 3x3 | 5988539 | 2098972 | 37.7427165815391 | -122.48228053628 | (37.7427165815391, -122.48228053628) | 1 | 8 | 3 | 29491 | 35 | ||
96602 | 98126 | Undocumented 4 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1298X Utah St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 3x3 | 6010839.8 | 2102289.6 | 37.7530979479228 | -122.40540394341 | (37.7530979479228, -122.40540394341) | 10 | 4 | 8 | 28859 | 19 | |||
97231 | 99575 | Undocumented 4 | Tristaniopsis laurina :: Swamp Myrtle 1 | 650X Brunswick St | 17 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | 3x6 | 5998578.4 | 2086902.6 | 37.710155688278 | -122.446699086535 | (37.710155688278, -122.446699086535) | 9 | 7 | 6 | 28861 | 5 | |||
97304 | 101311 | Undocumented 4 | Tristaniopsis laurina :: Swamp Myrtle 1 | 4244X 19th St | 1 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 5 | 3x3 | 6001912 | 2104709 | 37.7592378221466 | -122.436451128899 | (37.7592378221466, -122.436451128899) | 2 | 4 | 5 | 28862 | 3 | |||
99038 | 107265 | Undocumented 4 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1X Long Bridge St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6011042.63982 | 2114087.82857 | 37.7855045301642 | -122.405533360616 | (37.7855045301642, -122.405533360616) | 12 | 2 | 9 | 28853 | 34 | ||||
99885 | 99952 | Undocumented 4 | Tristaniopsis laurina :: Swamp Myrtle 1 | 420 Kirkham St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/07/2016 12:00:00 AM | 3 | 3x3 | Permit Number 778491 | 5993609 | 2105311 | 37.760415458577 | -122.465210403501 | (37.760415458577, -122.465210403501) | 1 | 8 | 11 | 56 | 12 | |
104831 | 108619 | Undocumented 4 | Tristaniopsis laurina :: Swamp Myrtle 1 | 150-198X Webster St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6005405 | 2109611 | 37.7728954095296 | -122.424719362301 | (37.7728954095296, -122.424719362301) | 7 | 9 | 11 | 28852 | 10 | |||||
105078 | 121379 | Undocumented 4 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1195x Lincoln Way | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5992103 | 2107224 | 37.7655810886811 | -122.470558244073 | (37.7655810886811, -122.470558244073) | 11 | 8 | 11 | 56 | 12 | ||||
105950 | 116993 | Undocumented 4 | Tristaniopsis laurina :: Swamp Myrtle 1 | 300x BRODERICK ST | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4x4 | 6001353 | 2109892 | 37.7734372805127 | -122.438755818588 | (37.7734372805127, -122.438755818588) | 15 | 5 | 11 | 29492 | 10 | ||||
107789 | 137954 | Undocumented 4 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1615 SUTTER ST | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Width 0ft | 6004801.2336 | 2114685.8103 | 37.7867954695312 | -122.427169405594 | (37.7867954695312, -122.427169405594) | 13 | 9 | 11 | 28858 | 13 | ||||
111153 | 121692 | Undocumented 4 | Tristaniopsis laurina :: Swamp Myrtle 1 | 2421 16th St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6009364 | 2106805 | 37.7654135871473 | -122.410826446835 | (37.7654135871473, -122.410826446835) | 8 | 4 | 7 | 28859 | 19 | ||||
113529 | 102032 | Undocumented 4 | Tristaniopsis laurina :: Swamp Myrtle 1 | 165X Chattanooga St | 12 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 3 | 3x3 | 6004753 | 2102714 | 37.7539210456637 | -122.426483522656 | (37.7539210456637, -122.426483522656) | 2 | 4 | 5 | 28862 | 22 | ||
114477 | 102313 | Undocumented 4 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1330 Stevenson St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 3x3 | 6006027 | 2108860 | 37.7708684537788 | -122.422514413679 | (37.7708684537788, -122.422514413679) | 8 | 2 | 9 | 28853 | 19 | |||
115027 | 121691 | Undocumented 4 | Tristaniopsis laurina :: Swamp Myrtle 1 | 2421 16th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6009364 | 2106805 | 37.7654135871473 | -122.410826446835 | (37.7654135871473, -122.410826446835) | 8 | 4 | 7 | 28859 | 19 | ||||
115497 | 111718 | Undocumented 4 | Tristaniopsis laurina :: Swamp Myrtle 1 | 2390x MASON ST | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6008938 | 2121373 | 37.8053899130211 | -122.413330195558 | (37.8053899130211, -122.413330195558) | 3 | 1 | 10 | 308 | 23 | ||||
117024 | 96891 | Undocumented 4 | Tristaniopsis laurina :: Swamp Myrtle 1 | 202 Hoffman Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/22/2002 12:00:00 AM | 3x3 | 6000536.2 | 2102231.9 | 37.7523580354324 | -122.441031584455 | (37.7523580354324, -122.441031584455) | 2 | 4 | 5 | 28862 | 22 | ||
118128 | 101640 | Undocumented 4 | Tristaniopsis laurina :: Swamp Myrtle 1 | 689X Amazon Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6002123.8 | 2088649.6 | 37.7151544566445 | -122.434570326444 | (37.7151544566445, -122.434570326444) | 9 | 7 | 6 | 28861 | 5 | ||||
118514 | 107269 | Undocumented 4 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1X Long Bridge St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6011042.63982 | 2114087.82857 | 37.7855045301642 | -122.405533360616 | (37.7855045301642, -122.405533360616) | 12 | 2 | 9 | 28853 | 34 | ||||
118816 | 102311 | Undocumented 4 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1330 Stevenson St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 3x3 | 6006027 | 2108860 | 37.7708684537788 | -122.422514413679 | (37.7708684537788, -122.422514413679) | 8 | 2 | 9 | 28853 | 19 | |||
118895 | 115075 | Undocumented 4 | Tristaniopsis laurina :: Swamp Myrtle 1 | 2371X MASON ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 3x3 | 6008645 | 2121254 | 37.8050467143555 | -122.414335738873 | (37.8050467143555, -122.414335738873) | 3 | 1 | 10 | 308 | 23 | |||
119261 | 116991 | Undocumented 4 | Tristaniopsis laurina :: Swamp Myrtle 1 | 300x BRODERICK ST | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4x4 | 6001353 | 2109892 | 37.7734372805127 | -122.438755818588 | (37.7734372805127, -122.438755818588) | 15 | 5 | 11 | 29492 | 10 | ||||
119807 | 110227 | Undocumented 4 | Tristaniopsis laurina :: Swamp Myrtle 1 | 125x CHURCH ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6004113 | 2108242 | 37.7690634136215 | -122.429090914444 | (37.7690634136215, -122.429090914444) | 7 | 9 | 5 | 28862 | 3 | ||||
124536 | 110121 | Undocumented 4 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1356 SACRAMENTO ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6008282.6 | 2116630.5 | 37.7923313700749 | -122.41526237244 | (37.7923313700749, -122.41526237244) | 5 | 1 | 10 | 28858 | 21 | ||||
125199 | 241863 | Undocumented 4 | Tristaniopsis laurina :: Swamp Myrtle 1 | 3662 Folsom St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6008454.47494 | 2097793.64514 | 37.7406193991667 | -122.413334974535 | (37.7406193991667, -122.413334974535) | 2 | 7 | 7 | 28859 | 2 | |||
128196 | 107691 | Undocumented 4 | Tristaniopsis laurina :: Swamp Myrtle 1 | 2199 Jackson St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4x4 | 6003671 | 2116909 | 37.7928358039924 | -122.431238497045 | (37.7928358039924, -122.431238497045) | 13 | 9 | 1 | 29490 | 27 | ||||
129144 | 255891 | Undocumented 4 | Tristaniopsis laurina :: Swamp Myrtle 1 | 50 Columbia Square St | 12 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6010942 | 2111079 | 37.7772373644855 | -122.405669544588 | (37.7772373644855, -122.405669544588) | 14 | 2 | 9 | 28853 | 34 | ||||
129482 | 102027 | Undocumented 4 | Tristaniopsis laurina :: Swamp Myrtle 1 | 165X Chattanooga St | 7 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 3 | 3x3 | 6004753 | 2102714 | 37.7539210456637 | -122.426483522656 | (37.7539210456637, -122.426483522656) | 2 | 4 | 5 | 28862 | 22 | ||
129878 | 121693 | Undocumented 4 | Tristaniopsis laurina :: Swamp Myrtle 1 | 2421 16th St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6009364 | 2106805 | 37.7654135871473 | -122.410826446835 | (37.7654135871473, -122.410826446835) | 8 | 4 | 7 | 28859 | 19 | ||||
130000 | 102029 | Undocumented 4 | Tristaniopsis laurina :: Swamp Myrtle 1 | 165X Chattanooga St | 9 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 3 | 3x3 | 6004753 | 2102714 | 37.7539210456637 | -122.426483522656 | (37.7539210456637, -122.426483522656) | 2 | 4 | 5 | 28862 | 22 | ||
130609 | 256635 | Undocumented 4 | Tristaniopsis laurina :: Swamp Myrtle 1 | 350 Laguna Honda Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5995221 | 2100899 | 37.7483940544242 | -122.459315767742 | (37.7483940544242, -122.459315767742) | 1 | 8 | 4 | 29491 | 40 | ||||
131415 | 116747 | Undocumented 4 | Tristaniopsis laurina :: Swamp Myrtle 1 | 9x BLANKEN AVE | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6011671 | 2087411 | 37.7122908654107 | -122.40148388608 | (37.7122908654107, -122.40148388608) | 10 | 3 | 8 | 309 | 1 | ||||
131878 | 112062 | Undocumented 4 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1199 VISITACION AVE | 4 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 08/18/2015 12:00:00 AM | 4x4 | 6009231 | 2087548 | 37.7125305915537 | -122.409926954579 | (37.7125305915537, -122.409926954579) | 9 | 7 | 8 | 309 | 39 | ||
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 | ||||
134891 | 110222 | Undocumented 4 | Tristaniopsis laurina :: Swamp Myrtle 1 | 195x CHURCH ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6004291 | 2107903 | 37.7681426760471 | -122.428451057009 | (37.7681426760471, -122.428451057009) | 7 | 9 | 5 | 28862 | 3 | ||||
135552 | 102034 | Undocumented 4 | Tristaniopsis laurina :: Swamp Myrtle 1 | 165X Chattanooga St | 14 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 3 | 3x3 | 6004753 | 2102714 | 37.7539210456637 | -122.426483522656 | (37.7539210456637, -122.426483522656) | 2 | 4 | 5 | 28862 | 22 | ||
135935 | 255890 | Undocumented 4 | Tristaniopsis laurina :: Swamp Myrtle 1 | 50 Columbia Square St | 11 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6010942 | 2111079 | 37.7772373644855 | -122.405669544588 | (37.7772373644855, -122.405669544588) | 14 | 2 | 9 | 28853 | 34 | ||||
137882 | 96358 | Undocumented 4 | Tristaniopsis laurina :: Swamp Myrtle 1 | 261 Bradford St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/07/2011 12:00:00 AM | 24 | 3x3 | Permit Number 767870 | 6009536 | 2097078 | 37.7387150557005 | -122.409544964001 | (37.7387150557005, -122.409544964001) | 10 | 7 | 7 | 28859 | 2 | |
138462 | 107693 | Undocumented 4 | Tristaniopsis laurina :: Swamp Myrtle 1 | 2199 Jackson St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4x4 | 6003671 | 2116909 | 37.7928358039924 | -122.431238497045 | (37.7928358039924, -122.431238497045) | 13 | 9 | 1 | 29490 | 27 | ||||
139161 | 99569 | Undocumented 4 | Tristaniopsis laurina :: Swamp Myrtle 1 | 650X Brunswick St | 11 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | 3x6 | 5998578.4 | 2086902.6 | 37.710155688278 | -122.446699086535 | (37.710155688278, -122.446699086535) | 9 | 7 | 6 | 28861 | 5 | |||
139432 | 180234 | Undocumented 4 | Tristaniopsis laurina :: Swamp Myrtle 1 | 3353 19th Ave | 8 | : | Tree | Private 2 | 1 | Width 3ft | 5990557.66801 | 2094210.25193 | 37.7297592517825 | -122.474953123507 | (37.7297592517825, -122.474953123507) | 1 | 8 | 4 | 64 | 14 | |||
142602 | 101642 | Undocumented 4 | Tristaniopsis laurina :: Swamp Myrtle 1 | 689X Amazon Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6002123.8 | 2088649.6 | 37.7151544566445 | -122.434570326444 | (37.7151544566445, -122.434570326444) | 9 | 7 | 6 | 28861 | 5 | ||||
142679 | 116983 | Undocumented 4 | Tristaniopsis laurina :: Swamp Myrtle 1 | 437 ROSE ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6004435 | 2109631 | 37.7728954926097 | -122.42807613315 | (37.7728954926097, -122.42807613315) | 7 | 9 | 11 | 28852 | 10 | ||||
144221 | 107272 | Undocumented 4 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1X Long Bridge St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6011042.63982 | 2114087.82857 | 37.7855045301642 | -122.405533360616 | (37.7855045301642, -122.405533360616) | 12 | 2 | 9 | 28853 | 34 | ||||
147395 | 102308 | Undocumented 4 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1320 Stevenson St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 3x3 | 6006027 | 2108860 | 37.7708684537788 | -122.422514413679 | (37.7708684537788, -122.422514413679) | 8 | 2 | 9 | 28853 | 19 | |||
148326 | 102285 | Undocumented 4 | Tristaniopsis laurina :: Swamp Myrtle 1 | 106 Hoffman Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | 4x4 | 6000567.8 | 2102477.2 | 37.7530333697051 | -122.440939902641 | (37.7530333697051, -122.440939902641) | 2 | 4 | 5 | 28862 | 22 | |||
148736 | 121937 | Undocumented 4 | Tristaniopsis laurina :: Swamp Myrtle 1 | 272 16th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 5990898.98746 | 2113570.58807 | 37.7829373926434 | -122.475185979075 | (37.7829373926434, -122.475185979075) | 11 | 6 | 2 | 54 | 26 | |||
152298 | 107610 | Undocumented 4 | Tristaniopsis laurina :: Swamp Myrtle 1 | 130 Taraval St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/29/2014 12:00:00 AM | 3 | Permit Number 773863 | 5993062.86174 | 2099209.06962 | 37.7436296195879 | -122.466655678001 | (37.7436296195879, -122.466655678001) | 1 | 8 | 4 | 29491 | 40 | ||
152945 | 111717 | Undocumented 4 | Tristaniopsis laurina :: Swamp Myrtle 1 | 2390x MASON ST | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6008938 | 2121373 | 37.8053899130211 | -122.413330195558 | (37.8053899130211, -122.413330195558) | 3 | 1 | 10 | 308 | 23 | ||||
154079 | 107694 | Undocumented 4 | Tristaniopsis laurina :: Swamp Myrtle 1 | 2199 Jackson St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4x4 | 6003671 | 2116909 | 37.7928358039924 | -122.431238497045 | (37.7928358039924, -122.431238497045) | 13 | 9 | 1 | 29490 | 27 | ||||
154395 | 112063 | Undocumented 4 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1199 VISITACION AVE | 5 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 4x4 | 6009231 | 2087548 | 37.7125305915537 | -122.409926954579 | (37.7125305915537, -122.409926954579) | 9 | 7 | 8 | 309 | 39 | |||
155467 | 98124 | Undocumented 4 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1298X Utah St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 3x3 | 6010839.8 | 2102289.6 | 37.7530979479228 | -122.40540394341 | (37.7530979479228, -122.40540394341) | 10 | 4 | 8 | 28859 | 19 | |||
156017 | 116748 | Undocumented 4 | Tristaniopsis laurina :: Swamp Myrtle 1 | 9x BLANKEN AVE | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6011671 | 2087411 | 37.7122908654107 | -122.40148388608 | (37.7122908654107, -122.40148388608) | 10 | 3 | 8 | 309 | 1 | ||||
156719 | 108322 | Undocumented 4 | Tristaniopsis laurina :: Swamp Myrtle 1 | 22 ARLETA AVE | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/09/2015 12:00:00 AM | 3 | 3x3 | Permit Number 774396 | 6011232.7 | 2087548.1 | 37.7126428486885 | -122.403008427372 | (37.7126428486885, -122.403008427372) | 9 | 7 | 8 | 309 | 39 | |
159171 | 112058 | Undocumented 4 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1199 VISITACION AVE | 1 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 4x4 | 6009231 | 2087548 | 37.7125305915537 | -122.409926954579 | (37.7125305915537, -122.409926954579) | 9 | 7 | 8 | 309 | 39 | |||
159742 | 102303 | Undocumented 4 | Tristaniopsis laurina :: Swamp Myrtle 1 | 767 Corbett Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/25/2013 12:00:00 AM | 4 | 3x3 | Permit Number 770010 | 6000230.9 | 2103020.8 | 37.7545067693378 | -122.442143982636 | (37.7545067693378, -122.442143982636) | 2 | 5 | 5 | 63 | 38 | |
159977 | 258039 | Undocumented 4 | Tristaniopsis laurina :: Swamp Myrtle 1 | 2337 Ocean Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5992315 | 2094093 | 37.7295389930171 | -122.468869357049 | (37.7295389930171, -122.468869357049) | 9 | 8 | 4 | 59 | 40 | ||||
162365 | 99806 | Undocumented 4 | Tristaniopsis laurina :: Swamp Myrtle 1 | 4141 23rd St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | 3x3 | 6002241 | 2102354 | 37.7527902465656 | -122.435144849965 | (37.7527902465656, -122.435144849965) | 2 | 4 | 5 | 28862 | 22 | |||
163715 | 107271 | Undocumented 4 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1X Long Bridge St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6011042.63982 | 2114087.82857 | 37.7855045301642 | -122.405533360616 | (37.7855045301642, -122.405533360616) | 12 | 2 | 9 | 28853 | 34 | ||||
164307 | 71729 | Undocumented 4 | Tristaniopsis laurina :: Swamp Myrtle 1 | 701x 27TH ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/11/1995 12:00:00 AM | 6001948 | 2099969 | 37.7462249605563 | -122.435987450823 | (37.7462249605563, -122.435987450823) | 2 | 7 | 5 | 63 | 22 | ||||
167233 | 102031 | Undocumented 4 | Tristaniopsis laurina :: Swamp Myrtle 1 | 165X Chattanooga St | 11 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 3 | 3x3 | 6004753 | 2102714 | 37.7539210456637 | -122.426483522656 | (37.7539210456637, -122.426483522656) | 2 | 4 | 5 | 28862 | 22 | ||
170222 | 102309 | Undocumented 4 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1320 Stevenson St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 3x3 | 6006027 | 2108860 | 37.7708684537788 | -122.422514413679 | (37.7708684537788, -122.422514413679) | 8 | 2 | 9 | 28853 | 19 | |||
171284 | 112358 | Undocumented 4 | Tristaniopsis laurina :: Swamp Myrtle 1 | 333 TAYLOR ST | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6009361 | 2114091 | 37.7854190646881 | -122.411351585686 | (37.7854190646881, -122.411351585686) | 14 | 10 | 9 | 28852 | 36 | ||||
173283 | 255889 | Undocumented 4 | Tristaniopsis laurina :: Swamp Myrtle 1 | 50 Columbia Square St | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6010942 | 2111079 | 37.7772373644855 | -122.405669544588 | (37.7772373644855, -122.405669544588) | 14 | 2 | 9 | 28853 | 34 | ||||
174238 | 97957 | Undocumented 4 | Tristaniopsis laurina :: Swamp Myrtle 1 | 2270 McKinnon Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/06/2011 12:00:00 AM | 3x3 | Permit Number 768057 | 6011896.3 | 2098543.4 | 37.7428707065024 | -122.401487073764 | (37.7428707065024, -122.401487073764) | 10 | 3 | 8 | 58 | 1 | ||
175443 | 110229 | Undocumented 4 | Tristaniopsis laurina :: Swamp Myrtle 1 | 125x CHURCH ST | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6004113 | 2108242 | 37.7690634136215 | -122.429090914444 | (37.7690634136215, -122.429090914444) | 7 | 9 | 5 | 28862 | 3 | ||||
176522 | 99782 | Undocumented 4 | Tristaniopsis laurina :: Swamp Myrtle 1 | 4238-4240 24th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6001648 | 2101771 | 37.7511557768566 | -122.437153809999 | (37.7511557768566, -122.437153809999) | 2 | 4 | 5 | 28862 | 22 | ||||
177090 | 120898 | Undocumented 4 | Tristaniopsis laurina :: Swamp Myrtle 1 | 200 Douglass St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | 3x3 | 6001048 | 2105186 | 37.7604984146453 | -122.439473444132 | (37.7604984146453, -122.439473444132) | 2 | 4 | 5 | 28862 | 3 | |||
177368 | 102023 | Undocumented 4 | Tristaniopsis laurina :: Swamp Myrtle 1 | 165X Chattanooga St | 3 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 3 | 3x3 | 6004753 | 2102714 | 37.7539210456637 | -122.426483522656 | (37.7539210456637, -122.426483522656) | 2 | 4 | 5 | 28862 | 22 | ||
177453 | 255892 | Undocumented 4 | Tristaniopsis laurina :: Swamp Myrtle 1 | 50 Columbia Square St | 13 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6010942 | 2111079 | 37.7772373644855 | -122.405669544588 | (37.7772373644855, -122.405669544588) | 14 | 2 | 9 | 28853 | 34 | ||||
177927 | 112300 | Undocumented 4 | Tristaniopsis laurina :: Swamp Myrtle 1 | 25x WALLER ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4x4 | 6005453 | 2109246 | 37.7718959184753 | -122.424527356528 | (37.7718959184753, -122.424527356528) | 7 | 9 | 5 | 28852 | 10 | ||||
178370 | 112061 | Undocumented 4 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1199 VISITACION AVE | 3 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 4x4 | 6009231 | 2087548 | 37.7125305915537 | -122.409926954579 | (37.7125305915537, -122.409926954579) | 9 | 7 | 8 | 309 | 39 | |||
178589 | 110230 | Undocumented 4 | Tristaniopsis laurina :: Swamp Myrtle 1 | 125x CHURCH ST | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6004113 | 2108242 | 37.7690634136215 | -122.429090914444 | (37.7690634136215, -122.429090914444) | 7 | 9 | 5 | 28862 | 3 | ||||
180505 | 112060 | Undocumented 4 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1199 VISITACION AVE | 2 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 4x4 | 6009231 | 2087548 | 37.7125305915537 | -122.409926954579 | (37.7125305915537, -122.409926954579) | 9 | 7 | 8 | 309 | 39 | |||
180506 | 111199 | Undocumented 4 | Tristaniopsis laurina :: Swamp Myrtle 1 | 801x CAYUGA AVE | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6001252 | 2092235 | 37.7249496290087 | -122.437840285791 | (37.7249496290087, -122.437840285791) | 9 | 7 | 6 | 28861 | 25 | ||||
181618 | 99566 | Undocumented 4 | Tristaniopsis laurina :: Swamp Myrtle 1 | 650X Brunswick St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | 3x6 | 5998578.4 | 2086902.6 | 37.710155688278 | -122.446699086535 | (37.710155688278, -122.446699086535) | 9 | 7 | 6 | 28861 | 5 | |||
183316 | 110223 | Undocumented 4 | Tristaniopsis laurina :: Swamp Myrtle 1 | 195x CHURCH ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6004291 | 2107903 | 37.7681426760471 | -122.428451057009 | (37.7681426760471, -122.428451057009) | 7 | 9 | 5 | 28862 | 3 | ||||
183626 | 142645 | Undocumented 4 | Tristaniopsis laurina :: Swamp Myrtle 1 | 2380 Mason St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6008890.0639 | 2121379.5977 | 37.805405337199 | -122.41349655223 | (37.805405337199, -122.41349655223) | 3 | 1 | 10 | 308 | 23 | |||||
183789 | 255426 | Undocumented 4 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1634 30th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 3x3 | 5986904 | 2104124 | 37.756767344902 | -122.488312354714 | (37.756767344902, -122.488312354714) | 1 | 8 | 3 | 56 | 35 | |||
184417 | 256636 | Undocumented 4 | Tristaniopsis laurina :: Swamp Myrtle 1 | 350 Laguna Honda Blvd | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5995221 | 2100899 | 37.7483940544242 | -122.459315767742 | (37.7483940544242, -122.459315767742) | 1 | 8 | 4 | 29491 | 40 | ||||
184452 | 255734 | Undocumented 4 | Tristaniopsis laurina :: Swamp Myrtle 1 | 301x Congdon St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/04/2018 11:59:00 AM | 3 | 3x5 | 6004745 | 2093607 | 37.7289148453459 | -122.425862986743 | (37.7289148453459, -122.425862986743) | 9 | 7 | 6 | 28861 | 5 | ||
184869 | 115076 | Undocumented 4 | Tristaniopsis laurina :: Swamp Myrtle 1 | 2371X MASON ST | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | 3x3 | 6008645 | 2121254 | 37.8050467143555 | -122.414335738873 | (37.8050467143555, -122.414335738873) | 3 | 1 | 10 | 308 | 23 | |||
185565 | 251753 | Undocumented 4 | Tristaniopsis laurina :: Swamp Myrtle 1 | 128 South Hill Blvd | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | Width 6ft | 6003064.16129 | 2086909.24662 | 37.7104291634552 | -122.431195883608 | (37.7104291634552, -122.431195883608) | 9 | 7 | 6 | 28861 | 5 | ||||
185598 | 110399 | Undocumented 4 | Tristaniopsis laurina :: Swamp Myrtle 1 | 166 DUNCAN ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6x6 | 6005484 | 2099956 | 37.7463895097475 | -122.423759460429 | (37.7463895097475, -122.423759460429) | 2 | 7 | 5 | 28859 | 22 | ||||
185959 | 102026 | Undocumented 4 | Tristaniopsis laurina :: Swamp Myrtle 1 | 165X Chattanooga St | 6 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 3 | 3x3 | 6004753 | 2102714 | 37.7539210456637 | -122.426483522656 | (37.7539210456637, -122.426483522656) | 2 | 4 | 5 | 28862 | 22 | ||
186675 | 100522 | Undocumented 4 | Tristaniopsis laurina :: Swamp Myrtle 1 | 2601 Harrison St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | 3x3 | 6008910 | 2103320 | 37.7558191060193 | -122.412150412844 | (37.7558191060193, -122.412150412844) | 2 | 4 | 7 | 28859 | 19 | |||
188825 | 102612 | Undocumented 4 | Tristaniopsis laurina :: Swamp Myrtle 1 | 376 Chestnut St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6010060 | 2120948 | 37.8042858984606 | -122.409417337419 | (37.8042858984606, -122.409417337419) | 3 | 1 | 10 | 308 | 23 | ||||
192133 | 112301 | Undocumented 4 | Tristaniopsis laurina :: Swamp Myrtle 1 | 25x WALLER ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4x4 | 6005453 | 2109246 | 37.7718959184753 | -122.424527356528 | (37.7718959184753, -122.424527356528) | 7 | 9 | 5 | 28852 | 10 | ||||
192268 | 121197 | Undocumented 4 | Tristaniopsis laurina :: Swamp Myrtle 1 | 2112 18th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3x3 | 5990734 | 2100991 | 37.7483876657955 | -122.474838269225 | (37.7483876657955, -122.474838269225) | 1 | 8 | 4 | 29491 | 40 | |||
192424 | 106899 | Undocumented 4 | Tristaniopsis laurina :: Swamp Myrtle 1 | 63 BROSNAN ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | 2x3 | 6005693 | 2108028.3 | 37.7685659568303 | -122.423610587475 | (37.7685659568303, -122.423610587475) | 8 | 4 | 5 | 28853 | 19 | |||
193524 | 255735 | Undocumented 4 | Tristaniopsis laurina :: Swamp Myrtle 1 | 301x Congdon St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x5 | 6004745 | 2093607 | 37.7289148453459 | -122.425862986743 | (37.7289148453459, -122.425862986743) | 9 | 7 | 6 | 28861 | 5 | ||||
11859 | 262397 | Undocumented 4 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 498 Alabama St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/13/2020 12:00:00 AM | 3 | 3x3 | 6008907 | 2105964 | 37.7630787595522 | -122.412347662048 | (37.7630787595522, -122.412347662048) | 8 | 4 | 7 | 28859 | 19 | ||
42638 | 230392 | Undocumented 4 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 3416 22nd St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6005586.33797 | 2103162.25218 | 37.7551989159029 | -122.423633508794 | (37.7551989159029, -122.423633508794) | 2 | 4 | 5 | 28859 | 19 | |||
108744 | 230393 | Undocumented 4 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 3420 22nd St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6005567.36067 | 2103163.57677 | 37.7552014816894 | -122.423699232135 | (37.7552014816894, -122.423699232135) | 2 | 4 | 5 | 28859 | 19 |
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) );