trees
142,615 rows where qLegalStatus_id = 1 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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1 | 264847 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 109 Felton St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 11/01/2020 12:00:00 AM | 3 | 6010522 | 2093730 | 37.729577358437 | -122.405900044893 | (37.729577358437, -122.405900044893) | 10 | 3 | 7 | 309 | 28 | |||
4 | 264831 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 230 Wilde Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 11/01/2020 12:00:00 AM | 3 | 4x6 | 6011678 | 2088870 | 37.7162973770842 | -122.401562170369 | (37.7162973770842, -122.401562170369) | 10 | 7 | 8 | 309 | 39 | ||
26 | 259857 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1255 Brussels St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 11/01/2020 12:00:00 AM | 3 | 6011768.59367 | 2089078.72926 | 37.7168755602396 | -122.401263692233 | (37.7168755602396, -122.401263692233) | 10 | 7 | 8 | 309 | 39 | ||
41 | 159866 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 20 Ruth St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/19/2020 12:00:00 AM | 3 | 4x6 | 6001590.27181 | 2091627.71254 | 37.7233013847479 | -122.436627471279 | (37.7233013847479, -122.436627471279) | 9 | 7 | 6 | 28861 | 25 | ||
44 | 159867 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 20 Ruth St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/19/2020 12:00:00 AM | 3 | 4x6 | 6001543.73914 | 2091652.70256 | 37.7233673572035 | -122.436790113668 | (37.7233673572035, -122.436790113668) | 9 | 7 | 6 | 28861 | 25 | ||
48 | 159865 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 20 Ruth St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/19/2020 12:00:00 AM | 3 | 4x6 | 6001621.37029 | 2091612.17517 | 37.7232604898693 | -122.436518858358 | (37.7232604898693, -122.436518858358) | 9 | 7 | 6 | 28861 | 25 | ||
49 | 261834 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 20x Ruth St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 11/19/2020 12:00:00 AM | 3 | 4x6 | 6001536 | 2091749 | 37.7236313283612 | -122.436823756643 | (37.7236313283612, -122.436823756643) | 9 | 7 | 6 | 28861 | 25 | ||
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 | |||||||||||||
200 | 10663 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 963 Hayes St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/25/1992 12:00:00 AM | 3 | 3x3 | 6003244.5235 | 2110652.1051 | 37.7756317694487 | -122.432267067771 | (37.7756317694487, -122.432267067771) | 15 | 9 | 11 | 29492 | 10 | ||
283 | 78989 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 2319 26th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 1 | 5988235.2891 | 2099507.8812 | 37.7441702991504 | -122.483369943638 | (37.7441702991504, -122.483369943638) | 1 | 8 | 3 | 29491 | 35 | |||
287 | 39813 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 2000 41st Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/12/2019 12:00:00 AM | 3 | 3x10 | Permit Number 41144 | 5983552 | 2101519 | 37.7494185989562 | -122.499712087956 | (37.7494185989562, -122.499712087956) | 1 | 8 | 3 | 29491 | 35 |
310 | 218546 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 25 Elmhurst Dr | 5 | : | Tree | Private 2 | 7 | Width 3ft | 5991216.07157 | 2094485.7269 | 37.730553771324 | -122.472697049151 | (37.730553771324, -122.472697049151) | 9 | 8 | 4 | 64 | 40 | |||
411 | 247779 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 254 30th St | 1 | : | Tree | Private 2 | 6 | Width 3ft | 6004930.81683 | 2098452.72536 | 37.7422306182373 | -122.42556533529 | (37.7422306182373, -122.42556533529) | 2 | 7 | 5 | 63 | 22 | |||
540 | 35140 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 911 Naples St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/28/1998 12:00:00 AM | 7 | Permit Number 38670 | 6001882.60594 | 2088665.49745 | 37.7151844124098 | -122.435405132561 | (37.7151844124098, -122.435405132561) | 9 | 7 | 6 | 28861 | 5 | |
605 | 52150 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1646 McKinnon Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/31/2005 12:00:00 AM | 5 | Permit Number 48341 | 6014994.17904 | 2096246.44188 | 37.7367360986871 | -122.390614910664 | (37.7367360986871, -122.390614910664) | 10 | 3 | 8 | 58 | 1 | |
616 | 243196 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1330 Stevenson St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 2ft | 6006254.26009 | 2108909.80844 | 37.771018033881 | -122.421731852741 | (37.771018033881, -122.421731852741) | 8 | 2 | 9 | 28853 | 19 | |||
617 | 241734 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 161 Church St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6004159.0543 | 2107968.96381 | 37.7683163292566 | -122.428912146976 | (37.7683163292566, -122.428912146976) | 7 | 9 | 5 | 28862 | 3 | |||
672 | 218447 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 468 Flood Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 2ft | 5997663.70622 | 2094120.17429 | 37.7299211747216 | -122.450380387859 | (37.7299211747216, -122.450380387859) | 9 | 7 | 4 | 28861 | 40 | |||
679 | 258141 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 312 Walnut St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 3 | 1x3 | 5998583.51543 | 2115521.94134 | 37.7887376884438 | -122.448741405189 | (37.7887376884438, -122.448741405189) | 13 | 6 | 1 | 54 | 31 | ||
725 | 183610 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1954 33rd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 0ft | 5986022.0269 | 2101933.6639 | 37.7507017829524 | -122.491201304809 | (37.7507017829524, -122.491201304809) | 1 | 8 | 3 | 29491 | 35 | |||
759 | 181983 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 2478 32nd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 0ft | 5986456.7133 | 2098393.9658 | 37.7410081118776 | -122.489437895882 | (37.7410081118776, -122.489437895882) | 1 | 8 | 3 | 29491 | 35 | |||
762 | 161390 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 467 Madrid St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/23/2020 12:00:00 AM | 3 | Width 0ft | 6002831.42521 | 2091188.97801 | 37.7221671723558 | -122.432305723439 | (37.7221671723558, -122.432305723439) | 9 | 7 | 6 | 28861 | 5 | ||
764 | 163220 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 45 Farallones St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/03/2020 12:00:00 AM | 3 | Width 0ft | 5996567.29942 | 2088361.68289 | 37.714046904924 | -122.453755106407 | (37.714046904924, -122.453755106407) | 9 | 8 | 6 | 28861 | 24 | ||
805 | 259342 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 124 Bacon St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 04/27/2019 12:00:00 AM | 3 | 6011093.06151 | 2093005.0494 | 37.7276187164247 | -122.403874822512 | (37.7276187164247, -122.403874822512) | 10 | 3 | 7 | 309 | 28 | ||
811 | 160771 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 667 Moscow St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/05/2019 12:00:00 AM | 0 | Width 0ft | 6003251.82484 | 2089320.66382 | 37.7170610223232 | -122.430719246496 | (37.7170610223232, -122.430719246496) | 9 | 7 | 6 | 28861 | 5 | ||
812 | 210575 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 222 Ridgewood Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/07/2018 12:00:00 AM | 3 | Width 2ft | Permit Number 778918 | 5996813.55952 | 2094844.51305 | 37.7318613433091 | -122.453371704763 | (37.7318613433091, -122.453371704763) | 9 | 7 | 4 | 59 | 40 | |
827 | 258419 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1838 Irving St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/25/2019 05:59:00 PM | 3 | 3x3 | 5990003 | 2106579 | 37.7636884395526 | -122.477774444731 | (37.7636884395526, -122.477774444731) | 1 | 8 | 3 | 56 | 35 | ||
828 | 120806 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 447 20th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/18/2019 12:00:00 AM | 3 | 5x6 | 5989655.6717 | 2112300.70253 | 37.7793785014336 | -122.479394354392 | (37.7793785014336, -122.479394354392) | 11 | 6 | 2 | 55 | 26 | ||
840 | 1046 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 2009X Alemany Blvd | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 06/15/1992 12:00:00 AM | 12 | 4X4 | 6000674.20134 | 2090359.18139 | 37.7197661846273 | -122.439703245137 | (37.7197661846273, -122.439703245137) | 9 | 7 | 6 | 28861 | 25 | ||
882 | 31596 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1319 Ortega St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/10/1995 12:00:00 AM | 3 | Permit Number 35123 | 5989912.9927 | 2102412.7013 | 37.7522436720962 | -122.477781174123 | (37.7522436720962, -122.477781174123) | 1 | 8 | 3 | 29491 | 35 | |
897 | 136834 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 2189 Jackson St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 4ft | 6003723.70254 | 2116916.18398 | 37.7928585158644 | -122.43105665684 | (37.7928585158644, -122.43105665684) | 13 | 9 | 1 | 29490 | 27 | |||
916 | 247786 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 310 30th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6004309 | 2098427 | 37.7421248276758 | -122.427713553768 | (37.7421248276758, -122.427713553768) | 2 | 7 | 5 | 63 | 22 | |||
927 | 260891 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 839 34th Ave | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 05/18/2019 12:00:00 AM | 3 | 5985392.72943 | 2110161.55054 | 37.7732564760791 | -122.493983752439 | (37.7732564760791, -122.493983752439) | 11 | 6 | 2 | 55 | 26 | |||
950 | 72251 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 437 London St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 9 | 6001865.6588 | 2091176.05062 | 37.7220768687262 | -122.435643214558 | (37.7220768687262, -122.435643214558) | 9 | 7 | 6 | 28861 | 5 | |||
951 | 258181 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 332 Silliman St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 3 | 4x5 | 6009802.23856 | 2094053.68877 | 37.7304258589231 | -122.408411167734 | (37.7304258589231, -122.408411167734) | 10 | 3 | 7 | 309 | 28 | ||
965 | 184959 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 2000 41st Ave | 17 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/14/2019 12:00:00 AM | 3 | 3x10 | 5983552 | 2101519 | 37.7494185989562 | -122.499712087956 | (37.7494185989562, -122.499712087956) | 1 | 8 | 3 | 29491 | 35 | |
976 | 258329 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 105 Whipple Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4x4 | 5998052 | 2087327 | 37.7112909098977 | -122.448548966881 | (37.7112909098977, -122.448548966881) | 9 | 7 | 6 | 28861 | 25 | ||||
1020 | 256741 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1494 27th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 3 | 3x3 | 5987774.09162 | 2105131.6228 | 37.7595847299836 | -122.485377233769 | (37.7595847299836, -122.485377233769) | 1 | 8 | 3 | 56 | 35 | ||
1030 | 260915 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1307 Waller St | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 09/21/2019 12:00:00 AM | 3 | 5999454.48308 | 2108393.47297 | 37.7692145145226 | -122.445215277932 | (37.7692145145226, -122.445215277932) | 15 | 5 | 11 | 29492 | 9 | |||
1041 | 109054 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 200 Shipley St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | 3x3 | 6011721.75389 | 2111961.27607 | 37.7797034631784 | -122.403034183007 | (37.7797034631784, -122.403034183007) | 14 | 2 | 9 | 28856 | 34 | |||
1046 | 84218 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 666 06th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/04/2008 12:00:00 AM | 2 | 3x3 | Permit Number 51573 | 5994122.60618 | 2110981.10556 | 37.7760136809116 | -122.463845662192 | (37.7760136809116, -122.463845662192) | 11 | 6 | 2 | 54 | 11 | |
1065 | 180355 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1900 San Jose Ave | 33 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 5999392.39561 | 2091826.25637 | 37.7237213933189 | -122.444239347485 | (37.7237213933189, -122.444239347485) | 9 | 7 | 6 | 28861 | 25 | |||
1073 | 108979 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 3298 Pierce St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/30/2017 12:00:00 AM | 3 | 3x3 | 6001360.79576 | 2119668.58087 | 37.800281699894 | -122.43942979746 | (37.800281699894, -122.43942979746) | 13 | 9 | 1 | 57 | 17 | ||
1095 | 255202 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 301X Burrows St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | ||||||||||||||
1117 | 119284 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 651 28th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/13/2019 12:00:00 AM | 3 | 3x3 | 5987187 | 2111505 | 37.7770500309996 | -122.487875935939 | (37.7770500309996, -122.487875935939) | 11 | 6 | 2 | 55 | 26 | ||
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 | ||||||||||||
1141 | 171735 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1124 Silliman St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 0 | 3x5 | 6007457.06473 | 2093337.1735 | 37.7283268529824 | -122.416468054284 | (37.7283268529824, -122.416468054284) | 9 | 3 | 7 | 309 | 5 | ||
1221 | 154034 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1670 Kirkwood Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 3x4 | 6014842.11456 | 2097062.95564 | 37.7389696405262 | -122.391197725313 | (37.7389696405262, -122.391197725313) | 10 | 3 | 8 | 58 | 1 | |||
1222 | 16326 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 789X Monterey Blvd | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/10/1993 12:00:00 AM | 3 | 3X3 | 5996873.6825 | 2094683.9462 | 37.7314239112697 | -122.45315226118 | (37.7314239112697, -122.45315226118) | 9 | 7 | 4 | 59 | 40 | ||
1226 | 264874 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 2218 36th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/24/2020 12:00:00 AM | 3 | 4x6 | 5985178 | 2100085 | 37.7455765035143 | -122.493983750596 | (37.7455765035143, -122.493983750596) | 1 | 8 | 3 | 29491 | 35 | |
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 | ||
1253 | 86079 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 2321 28th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 01/12/2007 12:00:00 AM | 3 | 3x3 | 5987612.7621 | 2099475.5619 | 37.7440453083682 | -122.485520107247 | (37.7440453083682, -122.485520107247) | 1 | 8 | 3 | 29491 | 35 | ||
1267 | 244161 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 441 Page St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 0ft | 6004421.3191 | 2109776.7375 | 37.7732948782123 | -122.428133844936 | (37.7732948782123, -122.428133844936) | 7 | 9 | 11 | 28852 | 10 | |||
1271 | 256035 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1478 Shafter Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 3 | 3x5 | 6015597 | 2093725 | 37.7298461523087 | -122.388354746587 | (37.7298461523087, -122.388354746587) | 10 | 3 | 8 | 58 | 1 | ||
1284 | 72257 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 671 Naples St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 5 | 6002561.32843 | 2089744.29585 | 37.7181850777589 | -122.433136210491 | (37.7181850777589, -122.433136210491) | 9 | 7 | 6 | 28861 | 5 | |||
1291 | 122854 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 3000X Alemany Blvd | 1 | Median : Cutout | Tree | DPW 1 | 12/08/2016 01:40:00 PM | 3 | 3x3 | 5996671.62099 | 2087298.1542 | 37.7111326815096 | -122.453317797602 | (37.7111326815096, -122.453317797602) | 9 | 7 | 6 | 28861 | 25 | ||
1312 | 71251 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1364 Broadway | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 6 | 6007075.57639 | 2118114.43065 | 37.7963379640898 | -122.419544039651 | (37.7963379640898, -122.419544039651) | 5 | 1 | 10 | 28858 | 32 | |||
1345 | 143782 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 454 34th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/25/2020 12:00:00 AM | 3 | Width 3ft | 5985339.75062 | 2112824.82274 | 37.7805659588822 | -122.494363364799 | (37.7805659588822, -122.494363364799) | 11 | 6 | 2 | 55 | 26 | ||
1375 | 84555 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 838 31st Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 3 | 5986366.07727 | 2110177.34593 | 37.7733567490821 | -122.490618019642 | (37.7733567490821, -122.490618019642) | 11 | 6 | 2 | 55 | 26 | |||
1391 | 71539 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 277 Shipley St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 1 | 6011318.23655 | 2111544.70179 | 37.7785371054488 | -122.40440080265 | (37.7785371054488, -122.40440080265) | 14 | 2 | 9 | 28856 | 34 | |||
1478 | 242990 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1330 Stevenson St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 5x2.5 | 6006256.26412 | 2108953.61059 | 37.7711384171253 | -122.421728032423 | (37.7711384171253, -122.421728032423) | 8 | 2 | 9 | 28853 | 19 | |||
1499 | 262277 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 301X Lee Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5996515 | 2091798 | 37.7234792274288 | -122.454183919247 | (37.7234792274288, -122.454183919247) | 9 | 8 | 4 | 28861 | 24 | ||||
1557 | 33639 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 440 Linden St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/03/1996 12:00:00 AM | 5 | Permit Number 37734 | 6005272.3664 | 2110799.1387 | 37.7761502580876 | -122.425262720434 | (37.7761502580876, -122.425262720434) | 7 | 9 | 11 | 28852 | 10 | |
1580 | 31821 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 195 07th St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/19/1995 12:00:00 AM | 4 | Permit Number 35284 | 6009820.27489 | 2111475.42861 | 37.7782630739317 | -122.409577954154 | (37.7782630739317, -122.409577954154) | 14 | 2 | 9 | 28853 | 34 | |
1604 | 15896 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 5635 Mission St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/01/1995 12:00:00 AM | 6 | 3X3 | 5998509.62683 | 2087220.10589 | 37.7110235586697 | -122.446959612304 | (37.7110235586697, -122.446959612304) | 9 | 7 | 6 | 28861 | 5 | ||
1636 | 199812 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1450 Armstrong Ave | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 0ft | 6015205.5584 | 2091901.4217 | 37.7248172716421 | -122.389580707536 | (37.7248172716421, -122.389580707536) | 10 | 3 | 8 | 58 | 1 | |||
1687 | 241878 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 701 Cortland Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 2ft | 6007932 | 2097222 | 37.739020439369 | -122.415101044746 | (37.739020439369, -122.415101044746) | 2 | 7 | 7 | 28859 | 2 | |||
1721 | 86502 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1410 27th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/21/2006 12:00:00 AM | 3 | 3x3 | 5987758.3934 | 2105633.7162 | 37.7609624268951 | -122.48546837117 | (37.7609624268951, -122.48546837117) | 1 | 8 | 3 | 56 | 35 | ||
1729 | 75952 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 6555 Geary Blvd | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 8 | 5986669.94788 | 2112490.96622 | 37.7797270399513 | -122.489737083171 | (37.7797270399513, -122.489737083171) | 11 | 6 | 2 | 55 | 26 | |||
1737 | 121771 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1501x Illinois St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | 3x3 | 6016276.86465 | 2101451.8833 | 37.7511002511867 | -122.386542923434 | (37.7511002511867, -122.386542923434) | 10 | 3 | 8 | 58 | 1 | |||
1768 | 166879 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 125 Jersey St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 0 | Width 3ft | 6004296.66973 | 2101583.94341 | 37.7507923673753 | -122.427981098658 | (37.7507923673753, -122.427981098658) | 2 | 4 | 5 | 28862 | 22 | |||
1788 | 262276 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 301X Lee Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5996515 | 2091798 | 37.7234792274288 | -122.454183919247 | (37.7234792274288, -122.454183919247) | 9 | 8 | 4 | 28861 | 24 | ||||
1834 | 241942 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 759x San Jose Ave | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6005779.29325 | 2098911.20923 | 37.7435374168158 | -122.422664135861 | (37.7435374168158, -122.422664135861) | 2 | 7 | 7 | 28859 | 2 | |||
1854 | 241885 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 118 Ellert St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 2ft | 6007147.65495 | 2096997.64072 | 37.7383602895823 | -122.417797058006 | (37.7383602895823, -122.417797058006) | 2 | 7 | 7 | 28859 | 2 | |||
1867 | 241893 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1305 Eugenia Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 2ft | 6008569.76439 | 2097675.06736 | 37.7403002828328 | -122.412927964755 | (37.7403002828328, -122.412927964755) | 10 | 7 | 7 | 28859 | 2 | |||
1870 | 70434 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 855 43rd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 8 | 3x3 | 5982604.49779 | 2109922.26737 | 37.772435937677 | -122.503610737191 | (37.772435937677, -122.503610737191) | 11 | 6 | 2 | 55 | 26 | ||
1897 | 84137 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 316 Wilde Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 4 | 6011309.96937 | 2088940.1025 | 37.7164693214661 | -122.402839197385 | (37.7164693214661, -122.402839197385) | 10 | 7 | 8 | 309 | 39 | |||
1916 | 123041 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 584 Funston Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 7 | Width 4ft | 5991932.61991 | 2111495.58679 | 37.7772998616253 | -122.471458826729 | (37.7772998616253, -122.471458826729) | 11 | 6 | 2 | 54 | 11 | |||
1973 | 247787 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 310 30th St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6004309 | 2098427 | 37.7421248276758 | -122.427713553768 | (37.7421248276758, -122.427713553768) | 2 | 7 | 5 | 63 | 22 | |||
1999 | 18283 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 2000 Post St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 01/10/1994 12:00:00 AM | 6 | 4X4 | 6002545.1088 | 2114076.0503 | 37.7849933804768 | -122.434931434249 | (37.7849933804768, -122.434931434249) | 13 | 6 | 11 | 29490 | 13 | ||
2032 | 71654 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 442 Vallejo St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 9 | 6011342.51966 | 2119044.79856 | 37.7991319472408 | -122.404844976017 | (37.7991319472408, -122.404844976017) | 3 | 1 | 10 | 308 | 23 | |||
2075 | 75757 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 2194 26th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 6 | 5988246.235 | 2100404.2075 | 37.7466320110547 | -122.483397789712 | (37.7466320110547, -122.483397789712) | 1 | 8 | 3 | 29491 | 35 | |||
2128 | 52629 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 77 Otsego Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/01/2006 12:00:00 AM | 5 | Permit Number 48714 | 6000818.47433 | 2092706.59424 | 37.7262198574511 | -122.439372720173 | (37.7262198574511, -122.439372720173) | 9 | 7 | 6 | 28861 | 25 | |
2142 | 84383 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 2101 Jerrold Ave | 15 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 4 | 6012616.61055 | 2098993.72766 | 37.7441473756935 | -122.399028026147 | (37.7441473756935, -122.399028026147) | 10 | 3 | 8 | 58 | 1 | |||
2181 | 144909 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 626 19th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 11/18/2019 12:00:00 AM | 0 | Width 3ft | 5990056.22711 | 2111077.42304 | 37.7760429715406 | -122.477919227901 | (37.7760429715406, -122.477919227901) | 11 | 6 | 2 | 55 | 26 | ||
2195 | 258431 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 2450 Irving St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/25/2019 05:45:00 PM | 3 | 3x3 | 5988181.8432 | 2106487.3051 | 37.7633308106608 | -122.484066458576 | (37.7633308106608, -122.484066458576) | 1 | 8 | 3 | 56 | 35 | ||
2227 | 28919 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 230 07th St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/11/2006 12:00:00 AM | 3 | 3x3 | 6009994.1526974 | 2111207.6693813 | 37.7775376115192 | -122.408957547154 | (37.7775376115192, -122.408957547154) | 8 | 2 | 9 | 28853 | 34 | ||
2232 | 26076 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 269 Broad St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/31/1997 12:00:00 AM | 12 | 3X3 | 5994312.4294 | 2088054.8516 | 37.7130748868127 | -122.461526506385 | (37.7130748868127, -122.461526506385) | 9 | 8 | 6 | 28861 | 24 | ||
2259 | 124122 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 4500 Geary Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/22/1996 12:00:00 AM | 7 | Width 3ft | 5992964.88575 | 2112821.48622 | 37.7810000844067 | -122.467984383057 | (37.7810000844067, -122.467984383057) | 11 | 6 | 2 | 54 | 11 | ||
2270 | 139543 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 254 Saint Joseph's Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 0ft | 6000646.9933 | 2113045.3455 | 37.7820553756462 | -122.441424306243 | (37.7820553756462, -122.441424306243) | 15 | 5 | 1 | 29490 | 41 | |||
2284 | 122861 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 3000X Alemany Blvd | 8 | Median : Cutout | Tree | DPW 1 | 12/08/2016 01:43:00 PM | 3 | 3x3 | 5996437.5077 | 2087153.60444 | 37.7107223595138 | -122.454116512475 | (37.7107223595138, -122.454116512475) | 9 | 7 | 6 | 28861 | 25 | ||
2334 | 15528 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 2792 Mission St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 06/08/2018 12:00:00 AM | 3 | 3X3 | 6007034.2153 | 2102142.536 | 37.7524806306406 | -122.418554005951 | (37.7524806306406, -122.418554005951) | 2 | 4 | 7 | 28859 | 19 | ||
2354 | 65134 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 608 38th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/26/1989 12:00:00 AM | 8 | Permit Number 27109 | 5984138.754 | 2111678.31461 | 37.7773476222303 | -122.498433409341 | (37.7773476222303, -122.498433409341) | 11 | 6 | 2 | 55 | 26 | |
2368 | 232423 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 3590 21st St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6004499.74747 | 2103689.91865 | 37.7565863692953 | -122.427428848357 | (37.7565863692953, -122.427428848357) | 2 | 4 | 5 | 28862 | 3 | |||
2372 | 254866 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 2828 San Jose Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/05/2018 02:34:00 PM | 3 | 3x6 | 5996346 | 2087845 | 37.7126155239422 | -122.454482695042 | (37.7126155239422, -122.454482695042) | 9 | 8 | 6 | 28861 | 24 | ||
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 | ||||||||||||
2476 | 61679 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 75 Williams Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/29/1984 12:00:00 AM | 11 | Permit Number 21676 | 6013741.75867 | 2093626.49588 | 37.729472702598 | -122.394761681005 | (37.729472702598, -122.394761681005) | 10 | 3 | 8 | 58 | 1 | |
2477 | 26317 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 2045 San Jose Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/17/1997 12:00:00 AM | 3 | 3X3 | 5999556.95115 | 2091956.24005 | 37.7240876853785 | -122.443679842351 | (37.7240876853785, -122.443679842351) | 9 | 7 | 6 | 28861 | 25 | ||
2533 | 198095 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1218 Rhode Island St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6011929.10622 | 2102668.35998 | 37.7541987852492 | -122.401663505566 | (37.7541987852492, -122.401663505566) | 10 | 3 | 8 | 28856 | 29 | |||
2576 | 241978 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 290X Tompkins Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6007949.4317 | 2096517.7297 | 37.7370876472613 | -122.414990939375 | (37.7370876472613, -122.414990939375) | 2 | 7 | 7 | 28859 | 2 |
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) );