trees

713 rows where qSpecies_id = 102 sorted by Police Districts

✎ View and edit SQL

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)
4056 249318 DPW Maintained 1 Crataegus phaenopyrum :: Washington Hawthorn 102 198X Prospect Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF     3x3                      
69555 126401 DPW Maintained 1 Crataegus phaenopyrum :: Washington Hawthorn 102 95 MacOndray Ln 1 Sidewalk: Property side : Yard Tree Private 2     10     6008076.48902 2119089.50826 37.7990716117224 -122.416149753634 (37.7990716117224, -122.416149753634) 5 1 10 308 32
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
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
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
20685 103447 Undocumented 4 Crataegus phaenopyrum :: Washington Hawthorn 102 50X Bluxome St 24 Sidewalk: Property side : Cutout Tree Private 2       2x2   6013250.8 2110869.1 37.7767898637251 -122.397667885183 (37.7767898637251, -122.397667885183) 6 2 9 28856 34
27906 103441 Undocumented 4 Crataegus phaenopyrum :: Washington Hawthorn 102 50X Bluxome St 18 Sidewalk: Property side : Cutout Tree Private 2       2x2   6013250.8 2110869.1 37.7767898637251 -122.397667885183 (37.7767898637251, -122.397667885183) 6 2 9 28856 34
28151 190948 DPW Maintained 1 Crataegus phaenopyrum :: Washington Hawthorn 102 40 Bluxome St 9 Sidewalk: Curb side : Cutout Tree Private 2     1 Width 2ft   6013368.27074 2110817.70841 37.7766552947402 -122.397257911242 (37.7766552947402, -122.397257911242) 6 2 9 28856 34
29107 190945 DPW Maintained 1 Crataegus phaenopyrum :: Washington Hawthorn 102 40 Bluxome St 5 Sidewalk: Curb side : Cutout Tree Private 2     1 Width 2ft   6013445.03636 2110888.0497 37.7768527094247 -122.396997287698 (37.7768527094247, -122.396997287698) 6 2 9 28856 34
31335 42183 Permitted Site 7 Crataegus phaenopyrum :: Washington Hawthorn 102 730 Bryant St 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/21/2000 12:00:00 AM     Permit Number 42467 6012299.41281254 2111097.65921114 37.7773644110039 -122.400975101339 (37.7773644110039, -122.400975101339) 14 2 9 28856 34
55677 103442 Undocumented 4 Crataegus phaenopyrum :: Washington Hawthorn 102 50X Bluxome St 19 Sidewalk: Property side : Cutout Tree Private 2       2x2   6013250.8 2110869.1 37.7767898637251 -122.397667885183 (37.7767898637251, -122.397667885183) 6 2 9 28856 34
67391 173674 Significant Tree 6 Crataegus phaenopyrum :: Washington Hawthorn 102 299x Beale St 4 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6014575 2115523 37.789642061391 -122.393412811769 (37.789642061391, -122.393412811769) 6 2 9 28855 6
73475 103443 Undocumented 4 Crataegus phaenopyrum :: Washington Hawthorn 102 50X Bluxome St 20 Sidewalk: Property side : Cutout Tree Private 2       2x2   6013250.8 2110869.1 37.7767898637251 -122.397667885183 (37.7767898637251, -122.397667885183) 6 2 9 28856 34
81028 103428 Undocumented 4 Crataegus phaenopyrum :: Washington Hawthorn 102 50X Bluxome St 5 Sidewalk: Property side : Cutout Tree Private 2       2x2   6013250.8 2110869.1 37.7767898637251 -122.397667885183 (37.7767898637251, -122.397667885183) 6 2 9 28856 34
83968 103448 Undocumented 4 Crataegus phaenopyrum :: Washington Hawthorn 102 50X Bluxome St 25 Sidewalk: Property side : Cutout Tree Private 2       2x2   6013250.8 2110869.1 37.7767898637251 -122.397667885183 (37.7767898637251, -122.397667885183) 6 2 9 28856 34
92116 173673 Significant Tree 6 Crataegus phaenopyrum :: Washington Hawthorn 102 299x Beale St 3 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6014575 2115523 37.789642061391 -122.393412811769 (37.789642061391, -122.393412811769) 6 2 9 28855 6
92337 103429 Undocumented 4 Crataegus phaenopyrum :: Washington Hawthorn 102 50X Bluxome St 6 Sidewalk: Property side : Cutout Tree Private 2       2x2   6013250.8 2110869.1 37.7767898637251 -122.397667885183 (37.7767898637251, -122.397667885183) 6 2 9 28856 34
101560 88357 Permitted Site 7 Crataegus phaenopyrum :: Washington Hawthorn 102 245 11th St 2 Sidewalk: Curb side : Cutout Tree Private 2   07/10/2008 12:00:00 AM   3x3 Permit Number 51336 6008270 2109444 37.7725982617206 -122.414797136624 (37.7725982617206, -122.414797136624) 8 2 9 28853 34
105813 95818 Permitted Site 7 Crataegus phaenopyrum :: Washington Hawthorn 102 679 Clementina St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 08/29/2011 12:00:00 AM   3x3 Permit Number 767556 6009585 2110509 37.7755963018026 -122.410323605803 (37.7755963018026, -122.410323605803) 8 2 9 28853 34
111529 103439 Undocumented 4 Crataegus phaenopyrum :: Washington Hawthorn 102 50X Bluxome St 16 Sidewalk: Property side : Cutout Tree Private 2       2x2   6013250.8 2110869.1 37.7767898637251 -122.397667885183 (37.7767898637251, -122.397667885183) 6 2 9 28856 34
116228 82950 Permitted Site 7 Crataegus phaenopyrum :: Washington Hawthorn 102 660X Clementina St 7 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/07/2009 12:00:00 AM 3 3x3 Permit Number 52432 6009636 2110586 37.7758105844997 -122.410152621086 (37.7758105844997, -122.410152621086) 8 2 9 28853 34
122814 103435 Undocumented 4 Crataegus phaenopyrum :: Washington Hawthorn 102 50X Bluxome St 12 Sidewalk: Property side : Cutout Tree Private 2       2x2   6013250.8 2110869.1 37.7767898637251 -122.397667885183 (37.7767898637251, -122.397667885183) 6 2 9 28856 34
138883 88356 Permitted Site 7 Crataegus phaenopyrum :: Washington Hawthorn 102 245 11th St 1 Sidewalk: Curb side : Cutout Tree Private 2   07/10/2008 12:00:00 AM   3x3 Permit Number 51336 6008270 2109444 37.7725982617206 -122.414797136624 (37.7725982617206, -122.414797136624) 8 2 9 28853 34
153009 88358 Permitted Site 7 Crataegus phaenopyrum :: Washington Hawthorn 102 245 11th St 3 Sidewalk: Curb side : Cutout Tree Private 2   07/10/2008 12:00:00 AM   3x3 Permit Number 51336 6008270 2109444 37.7725982617206 -122.414797136624 (37.7725982617206, -122.414797136624) 8 2 9 28853 34
159372 103433 Undocumented 4 Crataegus phaenopyrum :: Washington Hawthorn 102 50X Bluxome St 10 Sidewalk: Property side : Cutout Tree Private 2       2x2   6013250.8 2110869.1 37.7767898637251 -122.397667885183 (37.7767898637251, -122.397667885183) 6 2 9 28856 34
160032 103444 Undocumented 4 Crataegus phaenopyrum :: Washington Hawthorn 102 50X Bluxome St 21 Sidewalk: Property side : Cutout Tree Private 2       2x2   6013250.8 2110869.1 37.7767898637251 -122.397667885183 (37.7767898637251, -122.397667885183) 6 2 9 28856 34
162293 84596 Permitted Site 7 Crataegus phaenopyrum :: Washington Hawthorn 102 660-668 Clementina St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 01/18/2008 12:00:00 AM 3 3x3 Permit Number 50124 6009623.56460334 2110595.7986646 37.7758367923088 -122.410196330421 (37.7758367923088, -122.410196330421) 8 2 9 28853 34
165939 103440 Undocumented 4 Crataegus phaenopyrum :: Washington Hawthorn 102 50X Bluxome St 17 Sidewalk: Property side : Cutout Tree Private 2       2x2   6013250.8 2110869.1 37.7767898637251 -122.397667885183 (37.7767898637251, -122.397667885183) 6 2 9 28856 34
182808 173672 Significant Tree 6 Crataegus phaenopyrum :: Washington Hawthorn 102 299x Beale St 2 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6014575 2115523 37.789642061391 -122.393412811769 (37.789642061391, -122.393412811769) 6 2 9 28855 6
185180 42184 Permitted Site 7 Crataegus phaenopyrum :: Washington Hawthorn 102 730 Bryant St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/21/2000 12:00:00 AM     Permit Number 42467 6012299.41281254 2111097.65921114 37.7773644110039 -122.400975101339 (37.7773644110039, -122.400975101339) 14 2 9 28856 34
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
24718 190936 DPW Maintained 1 Crataegus phaenopyrum :: Washington Hawthorn 102 1945 22nd St 1 : Tree Private 2     2 Width 3ft   6012268.87212 2103730.35281 37.7571337389375 -122.400563099634 (37.7571337389375, -122.400563099634) 10 3 8 28856 29
36801 39544 DPW Maintained 1 Crataegus phaenopyrum :: Washington Hawthorn 102 1947 22nd St 3 Sidewalk: Curb side : Cutout Tree Private 2   07/16/2009 12:00:00 AM 3 3x3 Permit Number 52628 6012257.26801 2103730.73131 37.7571341310464 -122.400603257944 (37.7571341310464, -122.400603257944) 10 3 8 28856 29
37015 39548 Permitted Site 7 Crataegus phaenopyrum :: Washington Hawthorn 102 1945 22nd St 7 Sidewalk: Curb side : Cutout Tree Private 2 FUF 12/28/1998 12:00:00 AM     Permit Number 40973 6012286.64815743 2103730.55141744 37.7571352756248 -122.400501636831 (37.7571352756248, -122.400501636831) 10 3 8 28856 29
39104 190941 DPW Maintained 1 Crataegus phaenopyrum :: Washington Hawthorn 102 1701 Newhall St 1 : Tree Private 2     4 Width 3ft   6013964.79274 2095080.10635 37.7334764187035 -122.394092347086 (37.7334764187035, -122.394092347086) 10 3 8 58 1
43021 176078 DPW Maintained 1 Crataegus phaenopyrum :: Washington Hawthorn 102 230 Tocoloma Ave 3 Sidewalk: Curb side : Cutout Tree Private 2     1 Width 3ft   6012689.21584 2087374.22772 37.7122466573345 -122.397962026443 (37.7122466573345, -122.397962026443) 10 3 8 309 1
65127 190935 DPW Maintained 1 Crataegus phaenopyrum :: Washington Hawthorn 102 767 San Bruno Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     4 Width 4ft   6011029.84564 2104766.51746 37.7599096376513 -122.404921103652 (37.7599096376513, -122.404921103652) 10 3 8 28856 29
68909 176076 DPW Maintained 1 Crataegus phaenopyrum :: Washington Hawthorn 102 154 Gillette Ave 3 Sidewalk: Curb side : Cutout Tree Private 2     1 Width 3ft   6012994.7964 2086626.41439 37.7102103233239 -122.396853446553 (37.7102103233239, -122.396853446553) 10 3 8 309 1
74485 190939 DPW Maintained 1 Crataegus phaenopyrum :: Washington Hawthorn 102 1751 Newhall St 3 : Tree Private 2     5 Width 3ft   6013890.69246 2094981.96022 37.733202810741 -122.394341665249 (37.733202810741, -122.394341665249) 10 3 8 58 1
79480 190937 DPW Maintained 1 Crataegus phaenopyrum :: Washington Hawthorn 102 1945 22nd St 2 : Tree Private 2     1 Width 3ft   6012285.9595 2103731.71906 37.7571384433095 -122.400504100505 (37.7571384433095, -122.400504100505) 10 3 8 28856 29
79677 39542 DPW Maintained 1 Crataegus phaenopyrum :: Washington Hawthorn 102 1947 22nd St 1 Sidewalk: Curb side : Cutout Tree Private 2   07/16/2009 12:00:00 AM 4 3x3 Permit Number 52628 6012231.74927 2103730.67877 37.757132563538 -122.400691508412 (37.757132563538, -122.400691508412) 10 3 8 28856 29
92271 39546 Permitted Site 7 Crataegus phaenopyrum :: Washington Hawthorn 102 1945 22nd St 5 Sidewalk: Curb side : Cutout Tree Private 2 FUF 12/28/1998 12:00:00 AM     Permit Number 40973 6012286.64815743 2103730.55141744 37.7571352756248 -122.400501636831 (37.7571352756248, -122.400501636831) 10 3 8 28856 29
94557 66154 DPW Maintained 1 Crataegus phaenopyrum :: Washington Hawthorn 102 1721 Newhall St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 09/04/1990 12:00:00 AM 7   Permit Number 29225 6013940.43146 2095044.01963 37.7333759779235 -122.394174046017 (37.7333759779235, -122.394174046017) 10 3 8 58 1
104003 39545 DPW Maintained 1 Crataegus phaenopyrum :: Washington Hawthorn 102 1945 22nd St 4 Sidewalk: Curb side : Cutout Tree Private 2   07/16/2009 12:00:00 AM 1 3x3 Permit Number 52628 6012317.54572 2103734.07541 37.7571466747898 -122.40039502803 (37.7571466747898, -122.40039502803) 10 3 8 28856 29
104356 199804 DPW Maintained 1 Crataegus phaenopyrum :: Washington Hawthorn 102 1315 Carroll Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     2 Width 0ft   6015572.2876 2090853.6469 37.7219606159851 -122.388239865807 (37.7219606159851, -122.388239865807) 10 3 8 58 1
107999 190940 DPW Maintained 1 Crataegus phaenopyrum :: Washington Hawthorn 102 1721 Newhall St 2 : Tree Private 2     5 Width 3ft   6013954.61402 2095064.64022 37.7334333861362 -122.394126455691 (37.7334333861362, -122.394126455691) 10 3 8 58 1
108831 190930 DPW Maintained 1 Crataegus phaenopyrum :: Washington Hawthorn 102 1101 25th St 5 Sidewalk: Curb side : Yard Tree Private 2     2 Width 9ft   6015277.62058 2102029.1535 37.7526299458258 -122.390038764478 (37.7526299458258, -122.390038764478) 10 3 8 28856 1
114299 190932 DPW Maintained 1 Crataegus phaenopyrum :: Washington Hawthorn 102 1101 25th St 3 Sidewalk: Curb side : Yard Tree Private 2     1 Width 9ft   6015229.59957 2102026.97334 37.7526212961411 -122.390204678629 (37.7526212961411, -122.390204678629) 10 3 8 28856 1
116670 49954 DPW Maintained 1 Crataegus phaenopyrum :: Washington Hawthorn 102 1704@ ARKANSAS 20th St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/25/2003 12:00:00 AM 2 3x3 Permit Number 46735 6012896.20183 2104748.72577 37.7599649342604 -122.39846499386 (37.7599649342604, -122.39846499386) 10 3 8 28856 29
123570 190938 DPW Maintained 1 Crataegus phaenopyrum :: Washington Hawthorn 102 1945 22nd St 3 : Tree Private 2     1 Width 3ft   6012303.18984 2103733.08208 37.7571431467556 -122.400444606729 (37.7571431467556, -122.400444606729) 10 3 8 28856 29
135307 40184 DPW Maintained 1 Crataegus phaenopyrum :: Washington Hawthorn 102 1402 18th St 2 Sidewalk: Curb side : Cutout Tree Private 2   04/27/1999 12:00:00 AM 3 9x6 Permit Number 41371 6013366.18337 2105703.90093 37.7626138064095 -122.396906512841 (37.7626138064095, -122.396906512841) 14 3 8 28856 29
143673 199806 DPW Maintained 1 Crataegus phaenopyrum :: Washington Hawthorn 102 1305 Carroll Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     2 Width 0ft   6015615.5318 2090822.5842 37.7218777199193 -122.388088213537 (37.7218777199193, -122.388088213537) 10 3 8 58 1
145281 39543 DPW Maintained 1 Crataegus phaenopyrum :: Washington Hawthorn 102 1947 22nd St 2 Sidewalk: Curb side : Cutout Tree Private 2   07/16/2009 12:00:00 AM 1 3x3 Permit Number 52628 6012246.93603 2103730.22749 37.7571321714345 -122.400638954732 (37.7571321714345, -122.400638954732) 10 3 8 28856 29
156213 38599 DPW Maintained 1 Crataegus phaenopyrum :: Washington Hawthorn 102 1334 Revere Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 09/17/1998 12:00:00 AM 1   Permit Number 40550 6016508.9427 2093376.549 37.7289398652867 -122.385177756249 (37.7289398652867, -122.385177756249) 10 3 8 58 1
158047 39547 Permitted Site 7 Crataegus phaenopyrum :: Washington Hawthorn 102 1945 22nd St 6 Sidewalk: Curb side : Cutout Tree Private 2 FUF 12/28/1998 12:00:00 AM     Permit Number 40973 6012286.64815743 2103730.55141744 37.7571352756248 -122.400501636831 (37.7571352756248, -122.400501636831) 10 3 8 28856 29
162372 37809 DPW Maintained 1 Crataegus phaenopyrum :: Washington Hawthorn 102 945 Woolsey St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/06/1998 12:00:00 AM 6   Permit Number 40129 6008935.03699 2091336.11474 37.7229153750213 -122.411217322939 (37.7229153750213, -122.411217322939) 9 3 7 309 28
166719 190933 DPW Maintained 1 Crataegus phaenopyrum :: Washington Hawthorn 102 1101 25th St 2 Sidewalk: Curb side : Yard Tree Private 2     2 Width 9ft   6015201.2247 2102025.49065 37.7526156511008 -122.390302701123 (37.7526156511008, -122.390302701123) 10 3 8 28856 1
170665 190942 DPW Maintained 1 Crataegus phaenopyrum :: Washington Hawthorn 102 1701 Newhall St 2 : Tree Private 2     3 Width 3ft   6013977.60623 2095098.09187 37.7335265154282 -122.39404930553 (37.7335265154282, -122.39404930553) 10 3 8 58 1
176182 51654 Permitted Site 7 Crataegus phaenopyrum :: Washington Hawthorn 102 1419 Silver Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   03/16/2005 12:00:00 AM     Permit Number 47937 6009793.07047416 2094495.54898311 37.7316385998268 -122.408474019407 (37.7316385998268, -122.408474019407) 10 3 7 309 28
176902 51363 DPW Maintained 1 Crataegus phaenopyrum :: Washington Hawthorn 102 50 Pomona St 9 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency 10/12/2004 12:00:00 AM 3 3x3 Permit Number 47704 6014143.51923 2094573.18836 37.7320944574823 -122.393438970749 (37.7320944574823, -122.393438970749) 10 3 8 58 1
180455 190931 DPW Maintained 1 Crataegus phaenopyrum :: Washington Hawthorn 102 1101 25th St 4 Sidewalk: Curb side : Yard Tree Private 2     1 Width 9ft   6015254.41614 2102028.26395 37.752626216333 -122.390118948029 (37.752626216333, -122.390118948029) 10 3 8 28856 1
186381 176077 DPW Maintained 1 Crataegus phaenopyrum :: Washington Hawthorn 102 230 Tocoloma Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     3 Width 3ft   6012696.95044 2087397.86987 37.7123120047722 -122.397936950623 (37.7123120047722, -122.397936950623) 10 3 8 309 1
188607 190943 DPW Maintained 1 Crataegus phaenopyrum :: Washington Hawthorn 102 1701 Newhall St 3 : Tree Private 2     2 Width 3ft   6013990.64503 2095115.60513 37.7335753279298 -122.3940054519 (37.7335753279298, -122.3940054519) 10 3 8 58 1
191082 84028 DPW Maintained 1 Crataegus phaenopyrum :: Washington Hawthorn 102 53 Waterville St 1 Sidewalk: Curb side : Cutout Tree Private 2   01/22/2008 12:00:00 AM 3 3x3 Permit Number 50148 6011483.75557 2095836.15931 37.7354141717124 -122.402723197432 (37.7354141717124, -122.402723197432) 10 3 8 58 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
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
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
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
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
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

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