7,322 rows where qSpecies_id = 1

View and edit SQL

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
52 264970 Undocumented 4 Tristaniopsis laurina :: Swamp Myrtle 1 1026 Ingerson Ave 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6014048 2089990 37.7195046364539 -122.393448574201 (37.7195046364539, -122.393448574201) 10 3 8 58 1
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
585 75271 Private 9 Tristaniopsis laurina :: Swamp Myrtle 1 499 Illinois St 6 Sidewalk: Curb side : Cutout Tree Private 2   07/15/2016 12:00:00 AM 3 5x5   6015975.8041 2106880.05369 37.7659881814233 -122.387962771269 (37.7659881814233, -122.387962771269) 14 3 9 310 20
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
680 47114 Permitted Site 7 Tristaniopsis laurina :: Swamp Myrtle 1 65 Ellsworth St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 05/03/2002 12:00:00 AM     Permit Number 45098 6008176.0434029 2098254.72889507 37.7418697970416 -122.414330302805 (37.7418697970416, -122.414330302805) 2 7 7 28859 2
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
733 218511 Permitted Site 7 Tristaniopsis laurina :: Swamp Myrtle 1 318 Lakeview Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   07/25/2000 12:00:00 AM 7 Width 3ft Permit Number 43359 5996829.51445 2089654.64111 37.7176120972009 -122.45294206803 (37.7176120972009, -122.45294206803) 9 8 6 28861 24
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
1080 169338 Planning Code 138.1 required 2 Tristaniopsis laurina :: Swamp Myrtle 1 1029 Geary St 1 Sidewalk: Curb side : Cutout Tree Private 2   08/15/2019 12:00:00 AM 3 Width 4ft   6006781.41851 2114264.09095 37.7857493130165 -122.420288474132 (37.7857493130165, -122.420288474132) 13 9 9 28858 36
1095 255202 DPW Maintained 1 Tristaniopsis laurina :: Swamp Myrtle 1 301X Burrows St 3 Sidewalk: Curb side : Cutout Tree DPW 1 FUF                            
1112 8732 Permitted Site 7 Tristaniopsis laurina :: Swamp Myrtle 1 3210 Geary Blvd 2 Sidewalk: Curb side : Cutout Tree Private 2   02/21/1996 12:00:00 AM 6 3X3   5997102.31429 2113088.26659 37.7819706522719 -122.453690315182 (37.7819706522719, -122.453690315182) 11 6 1 54 31
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
1125 101207 Permitted Site 7 Tristaniopsis laurina :: Swamp Myrtle 1 800X Illinois St 3 Sidewalk: Property side : Yard Tree Private 2   10/03/2012 12:00:00 AM     Permit Number 769306 6015895.4 2105131.7 37.7611831239758 -122.388118852688 (37.7611831239758, -122.388118852688) 10 3 8 28856 29
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
1229 264907 Undocumented 4 Tristaniopsis laurina :: Swamp Myrtle 1 259 Clara St 5 Sidewalk: Curb side : Cutout Tree DPW 1       3x3   6011556 2111491 37.778402936715 -122.403574504421 (37.778402936715, -122.403574504421) 14 2 9 28856 34
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
1247 214916 Permitted Site 7 Tristaniopsis laurina :: Swamp Myrtle 1 20 Pinehurst Way 1 Sidewalk: Curb side : Cutout Tree Private 2   08/09/1993 12:00:00 AM 13 Width 2ft Permit Number 32246 5993222.12997 2093186.27538 37.7271017173463 -122.465667493867 (37.7271017173463, -122.465667493867) 9 8 4 59 40
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
1358 109891 Permitted Site 7 Tristaniopsis laurina :: Swamp Myrtle 1 1398x MARIPOSA ST 2 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6013218 2106201 37.7639704813344 -122.397453893083 (37.7639704813344, -122.397453893083) 14 3 8 28856 29
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
1551 260493 Undocumented 4 Tristaniopsis laurina :: Swamp Myrtle 1 1799 Washington St 4 Sidewalk: Curb side : Cutout Tree Private 2   09/05/2019 12:00:00 AM 3 3x3   6006327 2116970 37.7931534514646 -122.422052933674 (37.7931534514646, -122.422052933674) 13 9 10 28858 32
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
1651 37169 Permitted Site 7 Tristaniopsis laurina :: Swamp Myrtle 1 151 Duncan St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/08/1998 12:00:00 AM     Permit Number 39743 6005565.93572779 2099898.57048032 37.7462364463923 -122.423472053683 (37.7462364463923, -122.423472053683) 2 7 5 28859 22
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
2007 188784 Private 9 Tristaniopsis laurina :: Swamp Myrtle 1 499 Illinois St 3 Sidewalk: Curb side : Cutout Tree Private 2     4 Width 6ft   6015979.83831 2106803.95395 37.7657794514949 -122.387943506912 (37.7657794514949, -122.387943506912) 14 3 9 310 20
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
2168 254831 Undocumented 4 Tristaniopsis laurina :: Swamp Myrtle 1 2800 San Jose Ave 2 Sidewalk: Curb side : Cutout Tree Private 2   10/05/2018 02:34:00 PM 3 3x3   5996454 2087913 37.7128084296521 -122.454114323504 (37.7128084296521, -122.454114323504) 9 8 6 28861 24
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

Next page

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options:

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)
);