713 rows where qSpecies_id = 102

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)
415 190934 DPW Maintained 1 Crataegus phaenopyrum :: Washington Hawthorn 102 1101 25th St 1 Sidewalk: Curb side : Yard Tree Private 2     2 Width 9ft   6015168.60212 2102024.17667 37.7526102335912 -122.390415424833 (37.7526102335912, -122.390415424833) 10 3 8 28856 1
646 223229 DPW Maintained 1 Crataegus phaenopyrum :: Washington Hawthorn 102 3856 23rd St 1 Sidewalk: Curb side : Cutout Tree Private 2     5 Width 5ft   6004052.87626 2102494.4926 37.7532787266382 -122.428889066793 (37.7532787266382, -122.428889066793) 2 4 5 28862 22
1016 84387 DPW Maintained 1 Crataegus phaenopyrum :: Washington Hawthorn 102 2101 Jerrold Ave 11 Sidewalk: Curb side : Cutout Tree Private 2 FUF   3     6012577.97369 2099023.613 37.7442272813575 -122.399163722146 (37.7442272813575, -122.399163722146) 10 3 8 58 1
1537 258399 DPW Maintained 1 Crataegus phaenopyrum :: Washington Hawthorn 102 580 Naples St 1 Sidewalk: Curb side : Cutout Tree DPW 1 FUF     5x5   6002841.49317 2090269.24655 37.7196423649312 -122.432205270462 (37.7196423649312, -122.432205270462) 9 7 6 28861 5
1593 259756 DPW Maintained 1 Crataegus phaenopyrum :: Washington Hawthorn 102 1523 Innes Ave   Sidewalk: Curb side : Cutout Tree DPW 1 FUF 10/13/2018 12:00:00 AM 3     6015921.70632 2096895.74231 37.7385703600528 -122.387453298811 (37.7385703600528, -122.387453298811) 10 3 8 58 1
1780 223125 DPW Maintained 1 Crataegus phaenopyrum :: Washington Hawthorn 102 1105 Alabama St 1 Sidewalk: Curb side : Cutout Tree Private 2     5 Width 4ft   6009223.64941 2102625.89478 37.7539308430518 -122.411016683293 (37.7539308430518, -122.411016683293) 2 4 7 28859 19
1820 223236 DPW Maintained 1 Crataegus phaenopyrum :: Washington Hawthorn 102 4537 20th St 1 Sidewalk: Curb side : Cutout Tree Private 2   09/11/2020 12:00:00 AM 3 Width 3ft Permit Number 787681 6001259.34989 2104046.86599 37.7573826560002 -122.438660858237 (37.7573826560002, -122.438660858237) 2 4 5 28862 3
1861 65043 DPW Maintained 1 Crataegus phaenopyrum :: Washington Hawthorn 102 744 44th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   01/16/2020 12:00:00 AM 3   Permit Number 26096 5982313.7707 2110666.72217 37.7744628966917 -122.504671542451 (37.7744628966917, -122.504671542451) 11 6 2 55 26
2625 161272 DPW Maintained 1 Crataegus phaenopyrum :: Washington Hawthorn 102 562 Naples St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 10/25/2017 03:33:00 PM 3 Width 0ft   6002894.24566 2090355.62698 37.719882537321 -122.432029089275 (37.719882537321, -122.432029089275) 9 7 6 28861 5
3123 261802 DPW Maintained 1 Crataegus phaenopyrum :: Washington Hawthorn 102 2319 32nd Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   02/28/2020 12:00:00 AM 3 5x5   5986356 2099450 37.7439018196285 -122.489863769411 (37.7439018196285, -122.489863769411) 1 8 3 29491 35
3357 223122 DPW Maintained 1 Crataegus phaenopyrum :: Washington Hawthorn 102 148 Ellert St 2 Sidewalk: Curb side : Cutout Tree Private 2     11 Width 2ft   6007428.54288 2096958.74229 37.7382692862941 -122.416823127285 (37.7382692862941, -122.416823127285) 2 7 7 28859 2
3902 223217 DPW Maintained 1 Crataegus phaenopyrum :: Washington Hawthorn 102 1191 Noe St 1 Sidewalk: Curb side : Cutout Tree Private 2     8 Width 5ft   6003256 2101366 37.75013501563 -122.431564267794 (37.75013501563, -122.431564267794) 2 4 5 28862 22
4056 249318 DPW Maintained 1 Crataegus phaenopyrum :: Washington Hawthorn 102 198X Prospect Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF     3x3                      
4149 169685 DPW Maintained 1 Crataegus phaenopyrum :: Washington Hawthorn 102 2585 Diamond St 1 Sidewalk: Curb side : Cutout Tree Private 2     3 3x5   6002269.97794 2096798.3861 37.7375374800648 -122.43464741415 (37.7375374800648, -122.43464741415) 2 7 5 63 7
4325 261136 DPW Maintained 1 Crataegus phaenopyrum :: Washington Hawthorn 102 4200 Mission St 1 Sidewalk: Curb side : Cutout Tree Private 2   11/27/2019 12:00:00 AM 3 3x3   6003439 2093988 37.729887093701 -122.43040509359 (37.729887093701, -122.43040509359) 9 7 6 28861 25
4450 95446 DPW Maintained 1 Crataegus phaenopyrum :: Washington Hawthorn 102 2205 34th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 09/26/2020 12:00:00 AM 3 4x6 Permit Number 767308 5985726.3556 2100168.8125 37.7458386996409 -122.492093817749 (37.7458386996409, -122.492093817749) 1 8 3 29491 35
4597 190929 DPW Maintained 1 Crataegus phaenopyrum :: Washington Hawthorn 102 1101 25th St 6 Sidewalk: Curb side : Yard Tree Private 2     2 Width 9ft   6015301.73602 2102030.54675 37.752635108841 -122.389955465678 (37.752635108841, -122.389955465678) 10 3 8 28856 1
4742 243755 DPW Maintained 1 Crataegus phaenopyrum :: Washington Hawthorn 102 51 Van Buren St 1 Sidewalk: Curb side : Cutout Tree Private 2     3 3x5   6002062.89469 2096349.46794 37.7362930962328 -122.43533129551 (37.7362930962328, -122.43533129551) 2 7 5 63 7
4875 261114 DPW Maintained 1 Crataegus phaenopyrum :: Washington Hawthorn 102 331 Thornton Ave 4 Sidewalk: Curb side : Cutout Tree Private 2 FUF 10/19/2019 12:00:00 AM 3 4x6   6013544 2094213 37.731072125738 -122.395486430266 (37.731072125738, -122.395486430266) 10 3 8 58 1
4932 37209 DPW Maintained 1 Crataegus phaenopyrum :: Washington Hawthorn 102 1915 32nd Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/12/1998 12:00:00 AM 3   Permit Number 39775 5986283.2112 2102182.1445 37.7513993005965 -122.490316396609 (37.7513993005965, -122.490316396609) 1 8 3 29491 35
5030 171365 DPW Maintained 1 Crataegus phaenopyrum :: Washington Hawthorn 102 12 Avalon Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   11/27/2019 12:00:00 AM 3 Width 3ft   6002871.58236 2093130.52409 37.7275005001327 -122.432305504906 (37.7275005001327, -122.432305504906) 9 7 6 28861 5
5271 78323 DPW Maintained 1 Crataegus phaenopyrum :: Washington Hawthorn 102 50 Pomona St 24 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency   3 3x3   6014072.33534 2094216.70422 37.7311116693492 -122.393660129315 (37.7311116693492, -122.393660129315) 10 3 8 58 1
5746 258377 DPW Maintained 1 Crataegus phaenopyrum :: Washington Hawthorn 102 1036 Silliman St 1 Sidewalk: Curb side : Cutout Tree DPW 1 FUF     3x3   6007782.72545 2093434.59134 37.7286126501976 -122.415349121053 (37.7286126501976, -122.415349121053) 9 3 7 309 5
5755 261117 DPW Maintained 1 Crataegus phaenopyrum :: Washington Hawthorn 102 331 Thornton Ave 7 Sidewalk: Curb side : Cutout Tree Private 2 FUF 10/19/2019 12:00:00 AM 3 4x6   6013544 2094213 37.731072125738 -122.395486430266 (37.731072125738, -122.395486430266) 10 3 8 58 1
5995 258380 DPW Maintained 1 Crataegus phaenopyrum :: Washington Hawthorn 102 80 Somerset St 1 Sidewalk: Curb side : Cutout Tree DPW 1 FUF     4x5   6009574.25344 2094049.89218 37.7304026643572 -122.409199080219 (37.7304026643572, -122.409199080219) 9 3 7 309 28
6222 180532 DPW Maintained 1 Crataegus phaenopyrum :: Washington Hawthorn 102 401 Persia Ave 2 Sidewalk: Curb side : Cutout Tree Private 2   10/05/2019 12:00:00 AM 15 Width 4ft   6002770.13876 2090966.12434 37.7215517905727 -122.432501665928 (37.7215517905727, -122.432501665928) 9 7 6 28861 5
6277 223139 DPW Maintained 1 Crataegus phaenopyrum :: Washington Hawthorn 102 512 Clipper St 2 Sidewalk: Curb side : Cutout Tree Private 2     2 Width 4ft   6001868.53101 2100910.74029 37.7488062416211 -122.43632963112 (37.7488062416211, -122.43632963112) 2 4 5 28862 22
6305 223216 DPW Maintained 1 Crataegus phaenopyrum :: Washington Hawthorn 102 1199 Noe St 2 Sidewalk: Curb side : Cutout Tree Private 2     7 Width 5ft   6003236.71936 2101328.34532 37.7500305318879 -122.431628253337 (37.7500305318879, -122.431628253337) 2 4 5 28862 22
6349 78274 DPW Maintained 1 Crataegus phaenopyrum :: Washington Hawthorn 102 1715 Yosemite Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF   8     6013961.91267 2093099.05364 37.7280366912377 -122.393963673903 (37.7280366912377, -122.393963673903) 10 3 8 58 1
6404 73766 DPW Maintained 1 Crataegus phaenopyrum :: Washington Hawthorn 102 3834 Sacramento St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF   5     5996504.18251 2114976.06965 37.7871197485358 -122.45589607746 (37.7871197485358, -122.45589607746) 11 6 1 54 31
6544 223185 DPW Maintained 1 Crataegus phaenopyrum :: Washington Hawthorn 102 105x Bennington St 2 Sidewalk: Curb side : Cutout Tree Private 2     7 Width 3ft   6007139 2097159 37.7388028593756 -122.417838417363 (37.7388028593756, -122.417838417363) 2 7 7 28859 2
6879 223230 DPW Maintained 1 Crataegus phaenopyrum :: Washington Hawthorn 102 3856 23rd St 2 Sidewalk: Curb side : Cutout Tree Private 2   08/07/2017 12:00:00 AM 3 3x3 Permit Number 780428 6004041.47078 2102494.505 37.7532781151154 -122.428928510165 (37.7532781151154, -122.428928510165) 2 4 5 28862 22
7017 223186 DPW Maintained 1 Crataegus phaenopyrum :: Washington Hawthorn 102 105x Bennington St 3 Sidewalk: Curb side : Cutout Tree Private 2     3 Width 3ft   6007192 2097251 37.7390584535481 -122.417661686747 (37.7390584535481, -122.417661686747) 2 7 7 28859 2
7023 261112 DPW Maintained 1 Crataegus phaenopyrum :: Washington Hawthorn 102 331 Thornton Ave 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF 10/19/2019 12:00:00 AM 3 4x6   6013544 2094213 37.731072125738 -122.395486430266 (37.731072125738, -122.395486430266) 10 3 8 58 1
7113 51366 DPW Maintained 1 Crataegus phaenopyrum :: Washington Hawthorn 102 50 Pomona St 5 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency 10/12/2004 12:00:00 AM 3 3x3 Permit Number 47704 6014162.99112 2094669.44393 37.7323598375173 -122.393378385216 (37.7323598375173, -122.393378385216) 10 3 8 58 1
7281 258376 DPW Maintained 1 Crataegus phaenopyrum :: Washington Hawthorn 102 1030 Silliman St 1 Sidewalk: Curb side : Cutout Tree DPW 1 FUF     3x3   6007799.31029 2093439.67558 37.7286275425489 -122.415292145905 (37.7286275425489, -122.415292145905) 9 3 7 309 5
7857 78321 DPW Maintained 1 Crataegus phaenopyrum :: Washington Hawthorn 102 50 Pomona St 26 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency   3 3x3   6014066.05948 2094191.20422 37.7310413028018 -122.3936800421 (37.7310413028018, -122.3936800421) 10 3 8 58 1
8049 51364 DPW Maintained 1 Crataegus phaenopyrum :: Washington Hawthorn 102 50 Pomona St 7 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency 10/12/2004 12:00:00 AM 3 3x3 Permit Number 47704 6014150.64944 2094610.63008 37.7321976609735 -122.393416939157 (37.7321976609735, -122.393416939157) 10 3 8 58 1
8184 82951 Permitted Site 7 Crataegus phaenopyrum :: Washington Hawthorn 102 660X Clementina St 6 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/11/2005 12:00:00 AM 3 3x3 Permit Number 52432 6009636 2110586 37.7758105844997 -122.410152621086 (37.7758105844997, -122.410152621086) 8 2 9 28853 34
8484 180531 DPW Maintained 1 Crataegus phaenopyrum :: Washington Hawthorn 102 401 Persia Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   10/05/2019 12:00:00 AM 4 Width 2ft   6002788.2945 2090951.75373 37.721513361625 -122.432437880612 (37.721513361625, -122.432437880612) 9 7 6 28861 5
8494 261111 DPW Maintained 1 Crataegus phaenopyrum :: Washington Hawthorn 102 331 Thornton Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 10/19/2019 12:00:00 AM 3 4x6   6013544 2094213 37.731072125738 -122.395486430266 (37.731072125738, -122.395486430266) 10 3 8 58 1
8537 78846 DPW Maintained 1 Crataegus phaenopyrum :: Washington Hawthorn 102 259 Saint Charles Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF   4     5992056.72748 2086721.95578 37.7092849811889 -122.469225944831 (37.7092849811889, -122.469225944831) 9 8 4 64 24
8633 264870 DPW Maintained 1 Crataegus phaenopyrum :: Washington Hawthorn 102 1674 35th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   10/24/2020 12:00:00 AM 3 4x6   5985361 2103822 37.755847989753 -122.493626286002 (37.755847989753, -122.493626286002) 1 8 3 56 35
9024 46096 Permitted Site 7 Crataegus phaenopyrum :: Washington Hawthorn 102 647 Los Palmos Dr 3 Sidewalk: Curb side : Cutout Tree Private 2   12/18/2001 12:00:00 AM     Permit Number 44466 5995953.68098218 2095998.76752974 37.734981320791 -122.456427900432 (37.734981320791, -122.456427900432) 9 7 4 59 40
9083 39724 Permitted Site 7 Crataegus phaenopyrum :: Washington Hawthorn 102 295 Valdez Ave 3 Sidewalk: Curb side : Cutout Tree Private 2 FUF 01/05/1999 12:00:00 AM     Permit Number 41100 5996021.32504537 2095122.64012846 37.7325795705533 -122.456130709172 (37.7325795705533, -122.456130709172) 9 7 4 59 40
9100 84393 DPW Maintained 1 Crataegus phaenopyrum :: Washington Hawthorn 102 2101 Jerrold Ave 5 Sidewalk: Curb side : Cutout Tree Private 2 FUF   2     6012494.05335 2099085.01558 37.7443912025977 -122.399458212338 (37.7443912025977, -122.399458212338) 10 3 8 58 1
9146 32509 DPW Maintained 1 Crataegus phaenopyrum :: Washington Hawthorn 102 718 Moultrie St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 10/15/1996 12:00:00 AM 6 2.5x3 Permit Number 37011 6007605.33765 2096031.84482 37.7357341720927 -122.416146230064 (37.7357341720927, -122.416146230064) 2 7 7 28859 2
9182 223199 DPW Maintained 1 Crataegus phaenopyrum :: Washington Hawthorn 102 2957 23rd St 1 Sidewalk: Curb side : Cutout Tree Private 2     5 Width 3ft   6009122.48149 2102727.86117 37.7542051461569 -122.411373750107 (37.7542051461569, -122.411373750107) 2 4 7 28859 19
10416 42198 Permitted Site 7 Crataegus phaenopyrum :: Washington Hawthorn 102 1108 Bryant St 3 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/23/2000 12:00:00 AM     Permit Number 42472 6010019.96061049 2108918.62513791 37.7712538746338 -122.408706742901 (37.7712538746338, -122.408706742901) 8 2 9 28853 34
11345 140075 DPW Maintained 1 Crataegus phaenopyrum :: Washington Hawthorn 102 544 GROVE ST 1 Sidewalk: Curb side : Cutout Tree Private 2     7 Width 0ft   6005143.7718 2111312.9909 37.7775539050019 -122.425744146907 (37.7775539050019, -122.425744146907) 7 9 11 28852 10
11449 37884 Permitted Site 7 Crataegus phaenopyrum :: Washington Hawthorn 102 661 Miramar Ave 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/07/1998 12:00:00 AM     Permit Number 40161 5995348.10661971 2093729.21592258 37.7287148993258 -122.458357350083 (37.7287148993258, -122.458357350083) 9 7 4 28861 40
11533 259758 DPW Maintained 1 Crataegus phaenopyrum :: Washington Hawthorn 102 1547 Innes Ave   Sidewalk: Curb side : Cutout Tree DPW 1 FUF 10/13/2018 12:00:00 AM 3     6015798.86195 2096987.35115 37.7388150947049 -122.387884430038 (37.7388150947049, -122.387884430038) 10 3 8 58 1
11641 223098 DPW Maintained 1 Crataegus phaenopyrum :: Washington Hawthorn 102 120 Webster St 1 Sidewalk: Curb side : Cutout Tree Private 2     2 Width 2ft   6004264.58531 2109293.13989 37.7719581680779 -122.428641529305 (37.7719581680779, -122.428641529305) 7 9 11 28852 10
11774 158438 DPW Maintained 1 Crataegus phaenopyrum :: Washington Hawthorn 102 55 Van Buren St 2 Sidewalk: Curb side : Cutout Tree Private 2     3 3x5   6002040.0229 2096307.75742 37.7361772698529 -122.43540738986 (37.7361772698529, -122.43540738986) 2 7 5 63 7
11985 206738 DPW Maintained 1 Crataegus phaenopyrum :: Washington Hawthorn 102 2110 09th Ave 3 Sidewalk: Curb side : Yard Tree Private 2     5 Width 4ft   5993654.98108 2101316.80215 37.7494510717083 -122.46476131899 (37.7494510717083, -122.46476131899) 1 8 4 29491 40
12117 223149 DPW Maintained 1 Crataegus phaenopyrum :: Washington Hawthorn 102 3925 21st St 1 Front Yard : Yard Tree Private 2     13     6002289.78631 2103524.74331 37.7560075979872 -122.435059863923 (37.7560075979872, -122.435059863923) 2 4 5 28862 22
12137 48604 Permitted Site 7 Crataegus phaenopyrum :: Washington Hawthorn 102 45 Granville Way 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF 08/30/2002 12:00:00 AM     Permit Number 45912 5994629.49748523 2098086.8895364 37.7406386779703 -122.461157347766 (37.7406386779703, -122.461157347766) 1 8 4 59 40
12195 206712 DPW Maintained 1 Crataegus phaenopyrum :: Washington Hawthorn 102 1831 08th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     2 Width 3ft   5993729.968 2103029.70657 37.7541585918487 -122.464626378423 (37.7541585918487, -122.464626378423) 1 8 4 56 12
12296 206714 DPW Maintained 1 Crataegus phaenopyrum :: Washington Hawthorn 102 201 Moraga St 2 Sidewalk: Curb side : Cutout Tree Private 2     3 Width 3ft   5993663.54553 2103899.42942 37.7565427971281 -122.464919240823 (37.7565427971281, -122.464919240823) 1 8 4 56 12
12335 32449 DPW Maintained 1 Crataegus phaenopyrum :: Washington Hawthorn 102 4351 17th St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 10/10/1996 12:00:00 AM 4   Permit Number 36968 6000424.87812 2105754.35735 37.7620235013126 -122.441669319785 (37.7620235013126, -122.441669319785) 15 5 5 28862 3
12526 206776 DPW Maintained 1 Crataegus phaenopyrum :: Washington Hawthorn 102 339 Ulloa St 2 Sidewalk: Curb side : Yard Tree Private 2     7 Width 3ft   5995718.3884 2098491.52687 37.7418123157002 -122.457421671194 (37.7418123157002, -122.457421671194) 1 8 4 59 40
12597 144628 DPW Maintained 1 Crataegus phaenopyrum :: Washington Hawthorn 102 230 24th Ave 1 Sidewalk: Curb side : Cutout Tree DPW 1     3 5x5   5988384.27006 2114435.54017 37.7851662339868 -122.4839491984 (37.7851662339868, -122.4839491984) 11 6 2 55 26
13116 49003 Permitted Site 7 Crataegus phaenopyrum :: Washington Hawthorn 102 428 Elizabeth St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 12/16/2002 12:00:00 AM 6   Permit Number 46190 6003609.57090194 2102180.87163122 37.7523924957508 -122.430399732377 (37.7523924957508, -122.430399732377) 2 4 5 28862 22
13176 78329 DPW Maintained 1 Crataegus phaenopyrum :: Washington Hawthorn 102 50 Pomona St 18 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency   3 3x3   6014093.60126 2094328.91133 37.7314209489083 -122.39359445904 (37.7314209489083, -122.39359445904) 10 3 8 58 1
13398 51356 DPW Maintained 1 Crataegus phaenopyrum :: Washington Hawthorn 102 50 Pomona St 1 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency 10/12/2004 12:00:00 AM 3 3x3 Permit Number 47704 6014174.8382 2094728.02379 37.7325213440762 -122.393341524701 (37.7325213440762, -122.393341524701) 10 3 8 58 1
13495 223059 DPW Maintained 1 Crataegus phaenopyrum :: Washington Hawthorn 102 154 Tiffany Ave 2 Sidewalk: Curb side : Cutout Tree Private 2     6 Width 6ft   6006099.59544 2099325.6028 37.7446933136478 -122.421586033986 (37.7446933136478, -122.421586033986) 2 7 5 28859 2
13635 261439 Undocumented 4 Crataegus phaenopyrum :: Washington Hawthorn 102 374x Crescent Ave 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6007239 2095686 37.7347639531109 -122.417388303298 (37.7347639531109, -122.417388303298) 2 7 7 28859 2
13666 46097 Permitted Site 7 Crataegus phaenopyrum :: Washington Hawthorn 102 647 Los Palmos Dr 4 Sidewalk: Curb side : Cutout Tree Private 2   12/18/2001 12:00:00 AM     Permit Number 44466 5995953.68098218 2095998.76752974 37.734981320791 -122.456427900432 (37.734981320791, -122.456427900432) 9 7 4 59 40
13687 223210 DPW Maintained 1 Crataegus phaenopyrum :: Washington Hawthorn 102 4096 25th St 1 Sidewalk: Curb side : Cutout Tree Private 2     4 Width 3ft   6003278.99066 2101283.19814 37.749908964249 -122.431478854381 (37.749908964249, -122.431478854381) 2 4 5 28862 22
13909 261115 DPW Maintained 1 Crataegus phaenopyrum :: Washington Hawthorn 102 331 Thornton Ave 5 Sidewalk: Curb side : Cutout Tree Private 2 FUF 10/19/2019 12:00:00 AM 3 4x6   6013544 2094213 37.731072125738 -122.395486430266 (37.731072125738, -122.395486430266) 10 3 8 58 1
14040 190944 DPW Maintained 1 Crataegus phaenopyrum :: Washington Hawthorn 102 1701 Newhall St 4 : Tree Private 2     5 Width 3ft   6014004.94796 2095137.53702 37.7336363433234 -122.393957536921 (37.7336363433234, -122.393957536921) 10 3 8 58 1
14186 261520 DPW Maintained 1 Crataegus phaenopyrum :: Washington Hawthorn 102 750 42nd Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 01/15/2020 12:24:00 PM       5982933.06329 2110647.13754 37.7744455330351 -122.502527876502 (37.7744455330351, -122.502527876502) 11 6 2 55 26
14459 223187 DPW Maintained 1 Crataegus phaenopyrum :: Washington Hawthorn 102 105x Bennington St 4 Sidewalk: Curb side : Cutout Tree Private 2     8 Width 3ft   6007139 2097159 37.7388028593756 -122.417838417363 (37.7388028593756, -122.417838417363) 2 7 7 28859 2
14770 223263 DPW Maintained 1 Crataegus phaenopyrum :: Washington Hawthorn 102 1713 Sanchez St 1 Sidewalk: Curb side : Cutout Tree Private 2     4 Width 3ft   6003981.90505 2098315.20086 37.7417993447574 -122.42883657696 (37.7417993447574, -122.42883657696) 2 7 5 63 7
15106 78327 DPW Maintained 1 Crataegus phaenopyrum :: Washington Hawthorn 102 50 Pomona St 20 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency   3 3x3   6014087.33436 2094297.79766 37.7313351688787 -122.393613948242 (37.7313351688787, -122.393613948242) 10 3 8 58 1
15179 261113 DPW Maintained 1 Crataegus phaenopyrum :: Washington Hawthorn 102 331 Thornton Ave 3 Sidewalk: Curb side : Cutout Tree Private 2 FUF 10/19/2019 12:00:00 AM 3 4x6   6013544 2094213 37.731072125738 -122.395486430266 (37.731072125738, -122.395486430266) 10 3 8 58 1
15984 52285 Permitted Site 7 Crataegus phaenopyrum :: Washington Hawthorn 102 49 Valley St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 11/29/2005 12:00:00 AM     Permit Number 48443 6005568.13669376 2099312.5052799 37.7446273691442 -122.423422786255 (37.7446273691442, -122.423422786255) 2 7 5 28859 22
15986 55366 Permitted Site 7 Crataegus phaenopyrum :: Washington Hawthorn 102 160 San Aleso Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 05/16/2003 12:00:00 AM     Permit Number 46504 5993337.43694089 2094535.94135118 37.7308142184714 -122.465366881335 (37.7308142184714, -122.465366881335) 9 8 4 59 40
16303 261116 DPW Maintained 1 Crataegus phaenopyrum :: Washington Hawthorn 102 331 Thornton Ave 6 Sidewalk: Curb side : Cutout Tree Private 2 FUF 10/19/2019 12:00:00 AM 3 4x6   6013544 2094213 37.731072125738 -122.395486430266 (37.731072125738, -122.395486430266) 10 3 8 58 1
16611 258381 DPW Maintained 1 Crataegus phaenopyrum :: Washington Hawthorn 102 80 Somerset St 2 Sidewalk: Curb side : Cutout Tree DPW 1 FUF     4x5   6009574.25344 2094049.89218 37.7304026643572 -122.409199080219 (37.7304026643572, -122.409199080219) 9 3 7 309 28
16997 38011 Permitted Site 7 Crataegus phaenopyrum :: Washington Hawthorn 102 2537 15th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/08/1998 12:00:00 AM     Permit Number 40222 5991707.38932153 2098162.62971781 37.7406780464622 -122.471266299952 (37.7406780464622, -122.471266299952) 1 8 4 29491 40
17067 223124 DPW Maintained 1 Crataegus phaenopyrum :: Washington Hawthorn 102 99x Tompkins Ave 2 Sidewalk: Curb side : Cutout Tree Private 2     8 Width 2ft   6007651 2096616 37.7373407014575 -122.416029712695 (37.7373407014575, -122.416029712695) 2 7 7 28859 2
17578 223163 DPW Maintained 1 Crataegus phaenopyrum :: Washington Hawthorn 102 220 Nevada St 1 Sidewalk: Curb side : Yard Tree Private 2     3 Width 3ft   6008988.9604 2097329.9937 37.7393763076577 -122.411454173775 (37.7393763076577, -122.411454173775) 10 7 7 28859 2
17649 223213 DPW Maintained 1 Crataegus phaenopyrum :: Washington Hawthorn 102 1229 Noe St 2 Sidewalk: Curb side : Cutout Tree Private 2     8 Width 3ft   6003245.25071 2101106.06647 37.7494206899277 -122.431582884368 (37.7494206899277, -122.431582884368) 2 4 5 28862 22
17734 47651 DPW Maintained 1 Crataegus phaenopyrum :: Washington Hawthorn 102 363 Arkansas St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 05/21/2002 12:00:00 AM 4   Permit Number 45455 6012960.30928 2105372.99833 37.761682620471 -122.3982870765 (37.761682620471, -122.3982870765) 10 3 8 28856 29
17766 94165 Permitted Site 7 Crataegus phaenopyrum :: Washington Hawthorn 102 201 Moraga St 1 Sidewalk: Curb side : Cutout Tree Private 2   06/15/2010 12:00:00 AM   3x3 Permit Number 53528 5993721 2103904 37.7565586593184 -122.46472087623 (37.7565586593184, -122.46472087623) 1 8 4 56 12
18133 48935 Permitted Site 7 Crataegus phaenopyrum :: Washington Hawthorn 102 2743 Harrison St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 11/25/2002 12:00:00 AM     Permit Number 46123 6008967.24880953 2102489.58925571 37.7535421972635 -122.411893748881 (37.7535421972635, -122.411893748881) 2 4 7 28859 19
18209 78205 DPW Maintained 1 Crataegus phaenopyrum :: Washington Hawthorn 102 70 Latona St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF   3     6014348.06009 2094265.06475 37.7312597751042 -122.392710275271 (37.7312597751042, -122.392710275271) 10 3 8 58 1
18239 120242 DPW Maintained 1 Crataegus phaenopyrum :: Washington Hawthorn 102 288 24th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     1 Width 3ft   5988397.89946 2114035.20565 37.7840678224086 -122.483872680677 (37.7840678224086, -122.483872680677) 11 6 2 55 26
18307 206786 DPW Maintained 1 Crataegus phaenopyrum :: Washington Hawthorn 102 301 Joost Ave 3 Sidewalk: Property side : Yard Tree Private 2     16 Width 10ft   6000024.48409 2094930.02996 37.732279679167 -122.442277038462 (37.732279679167, -122.442277038462) 9 7 4 63 40
18332 223062 DPW Maintained 1 Crataegus phaenopyrum :: Washington Hawthorn 102 257 14th St 1 Sidewalk: Curb side : Cutout Tree Private 2     4 Width 3ft   6007025.24447 2107893.6932 37.7682714683756 -122.41899290632 (37.7682714683756, -122.41899290632) 8 4 7 28853 19
18412 147497 DPW Maintained 1 Crataegus phaenopyrum :: Washington Hawthorn 102 455 20th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   11/18/2019 12:00:00 AM 3 Width 4ft   5989658.48818 2112247.31744 37.7792320844204 -122.479380704451 (37.7792320844204, -122.479380704451) 11 6 2 55 26
18431 51369 DPW Maintained 1 Crataegus phaenopyrum :: Washington Hawthorn 102 50 Pomona St 3 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency 10/12/2004 12:00:00 AM 3 3x3 Permit Number 47704 6014169.21344 2094698.3618 37.7324395857978 -122.39335889599 (37.7324395857978, -122.39335889599) 10 3 8 58 1
19006 259153 DPW Maintained 1 Crataegus phaenopyrum :: Washington Hawthorn 102 207 Andover St 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6007591 2097689 37.7402835491894 -122.416313137546 (37.7402835491894, -122.416313137546) 2 7 7 28859 2
19146 223231 DPW Maintained 1 Crataegus phaenopyrum :: Washington Hawthorn 102 3609 21st St 1 Sidewalk: Curb side : Cutout Tree Private 2     3 Width 3ft   6004263.07305 2103628.9074 37.7564054580508 -122.428243005513 (37.7564054580508, -122.428243005513) 2 4 5 28862 22
19290 36416 Permitted Site 7 Crataegus phaenopyrum :: Washington Hawthorn 102 665 Miramar Ave 3 Sidewalk: Curb side : Cutout Tree Private 2 FUF 05/18/1998 12:00:00 AM     Permit Number 39335 5995348.52277962 2093755.44427738 37.7287869399676 -122.458357809087 (37.7287869399676, -122.458357809087) 9 7 4 28861 40
19525 118867 DPW Maintained 1 Crataegus phaenopyrum :: Washington Hawthorn 102 686 47th Ave 1 Sidewalk: Curb side : Yard Tree Private 2   01/16/2020 12:00:00 AM 3 Width 3ft   5981365.93161 2111081.95893 37.7755472130957 -122.507981064387 (37.7755472130957, -122.507981064387) 11 6 2 55 26
19857 223198 DPW Maintained 1 Crataegus phaenopyrum :: Washington Hawthorn 102 2901 23rd St 1 Sidewalk: Curb side : Cutout Tree Private 2     5 Width 3ft   6009412.47335 2102745.855 37.7542708137705 -122.410372152653 (37.7542708137705, -122.410372152653) 2 4 7 28859 19
19895 223061 DPW Maintained 1 Crataegus phaenopyrum :: Washington Hawthorn 102 3705 25th St 1 Sidewalk: Curb side : Cutout Tree Private 2     5 Width 3ft   6005700.15311 2101372.39104 37.750290794794 -122.423112686203 (37.750290794794, -122.423112686203) 2 4 5 28859 19
20547 190947 DPW Maintained 1 Crataegus phaenopyrum :: Washington Hawthorn 102 40 Bluxome St 7 Sidewalk: Curb side : Cutout Tree Private 2     18 Width 2ft   6013395.86609 2110840.5938 37.7767196691005 -122.397164055286 (37.7767196691005, -122.397164055286) 6 2 9 28856 34

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