home / trees

Street_Tree_List

Data source: data.sfgov.org

91 rows where qSpecies = 61

View and edit SQL

Suggested facets: qLegalStatus, SiteOrder, qSiteInfo, qCaretaker, PlantDate, DBH, PlotSize, PermitNotes, Fire Prevention Districts, Police Districts, Supervisor Districts, Zip Codes, Neighborhoods

Link rowid TreeID qLegalStatus qSpecies qAddress SiteOrder qSiteInfo PlantType qCaretaker qCareAssistant PlantDate DBH PlotSize PermitNotes XCoord YCoord Latitude Longitude Location Fire Prevention Districts Police Districts Supervisor Districts Zip Codes Neighborhoods
308 100316 Permitted Site 2 Pyrus spp :: Pear Tree 61 1683 Galvez Ave 4 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2   08/08/2012 12:00:00 AM 10 3x3 Permit Number 769149 6015429.5 2097921.2 37.7413587833137 -122.38922671216999 (37.7413587833137, -122.38922671217) 10 3 8 58 1
1283 101450 Permitted Site 2 Pyrus spp :: Pear Tree 61 331X 08th Ave 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2 FUF 2         5993377.6 2113262.5 37.7822348132756 -122.46658867692301 (37.7822348132756, -122.466588676923) 11 6 2 54 11
1284 101451 Permitted Site 2 Pyrus spp :: Pear Tree 61 331X 08th Ave 2 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2 FUF 2     3x3   5993377.6 2113262.5 37.7822348132756 -122.46658867692301 (37.7822348132756, -122.466588676923) 11 6 2 54 11
2958 103307 Significant Tree 4 Pyrus spp :: Pear Tree 61 1467 Willard St 1 Front Yard : Yard 4 Tree 1 Private 2   04/02/2013 12:00:00 AM 5 6x6 Permit Number 768689 5996817.5 2106175.0 37.7629722844649 -122.45417615462699 (37.7629722844649, -122.454176154627) 15 5 11 29492 12
3127 103493 Undocumented 3 Pyrus spp :: Pear Tree 61 108 Merrill St 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2       3x3   6009514.0 2094792.0 37.73243695849371 -122.40945973975599 (37.7324369584937, -122.409459739756) 10 3 7 309 28
3128 103494 Undocumented 3 Pyrus spp :: Pear Tree 61 108 Merrill St 2 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2       3x3   6009514.0 2094792.0 37.73243695849371 -122.40945973975599 (37.7324369584937, -122.409459739756) 10 3 7 309 28
3152 103515 Undocumented 3 Pyrus spp :: Pear Tree 61 1205 04th Ave 2 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2       5x9   5994806.3 2107305.7 37.7659613594124 -122.461214120153 (37.7659613594124, -122.461214120153) 15 5 11 56 12
4726 105350 Permitted Site 2 Pyrus spp :: Pear Tree 61 2040 Jackson St 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2   01/16/2014 12:00:00 AM     Permit Number 769933 6004382.6 2117068.4 37.793313776360996 -122.42878769617701 (37.793313776361, -122.428787696177) 13 9 1 28858 27
5886 106788 Undocumented 3 Pyrus spp :: Pear Tree 61 2900 Buchanan St 4 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2           6003450.81306 2118445.0192299997 37.7970408376177 -122.43211009377701 (37.7970408376177, -122.432110093777) 13 9 1 57 17
10726 112273 Undocumented 3 Pyrus spp :: Pear Tree 61 3250 17TH ST 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2       3x3   6007126.0 2106171.0 37.763547030123 -122.418522230845 (37.763547030123, -122.418522230845) 8 4 7 28859 19
11538 113169 Undocumented 3 Pyrus spp :: Pear Tree 61 1721X Armstrong Ave 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2           6013664.616780001 2093012.65223 37.7277829232836 -122.394985393491 (37.7277829232836, -122.394985393491) 10 3 8 58 1
11540 113170 Undocumented 3 Pyrus spp :: Pear Tree 61 1721X Armstrong Ave 2 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2           6013664.616780001 2093012.65223 37.7277829232836 -122.394985393491 (37.7277829232836, -122.394985393491) 10 3 8 58 1
11541 113171 Undocumented 3 Pyrus spp :: Pear Tree 61 1721X Armstrong Ave 3 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2           6013664.616780001 2093012.65223 37.7277829232836 -122.394985393491 (37.7277829232836, -122.394985393491) 10 3 8 58 1
11542 113172 Undocumented 3 Pyrus spp :: Pear Tree 61 1721X Armstrong Ave 4 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2           6013664.616780001 2093012.65223 37.7277829232836 -122.394985393491 (37.7277829232836, -122.394985393491) 10 3 8 58 1
11543 113173 Undocumented 3 Pyrus spp :: Pear Tree 61 1721X Armstrong Ave 5 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2           6013664.616780001 2093012.65223 37.7277829232836 -122.394985393491 (37.7277829232836, -122.394985393491) 10 3 8 58 1
11544 113174 Undocumented 3 Pyrus spp :: Pear Tree 61 1721X Armstrong Ave 6 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2           6013664.616780001 2093012.65223 37.7277829232836 -122.394985393491 (37.7277829232836, -122.394985393491) 10 3 8 58 1
11545 113175 Undocumented 3 Pyrus spp :: Pear Tree 61 1721X Armstrong Ave 7 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2           6013664.616780001 2093012.65223 37.7277829232836 -122.394985393491 (37.7277829232836, -122.394985393491) 10 3 8 58 1
11546 113176 Undocumented 3 Pyrus spp :: Pear Tree 61 1721X Armstrong Ave 8 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2           6013664.616780001 2093012.65223 37.7277829232836 -122.394985393491 (37.7277829232836, -122.394985393491) 10 3 8 58 1
11547 113177 Undocumented 3 Pyrus spp :: Pear Tree 61 1721X Armstrong Ave 9 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2           6013664.616780001 2093012.65223 37.7277829232836 -122.394985393491 (37.7277829232836, -122.394985393491) 10 3 8 58 1
11548 113178 Undocumented 3 Pyrus spp :: Pear Tree 61 1721X Armstrong Ave 10 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2           6013664.616780001 2093012.65223 37.7277829232836 -122.394985393491 (37.7277829232836, -122.394985393491) 10 3 8 58 1
15867 117741 DPW Maintained 1 Pyrus spp :: Pear Tree 61 475 39th Ave 3 Sidewalk: Curb side : Yard 7 Tree 1 Private 2     6 Width 4ft   5983747.447380001 2112666.97892 37.7800392524883 -122.49986014062 (37.7800392524883, -122.49986014062) 11 6 2 55 26
17747 120260 DPW Maintained 1 Pyrus spp :: Pear Tree 61 130 24th Ave 2 Sidewalk: Curb side : Yard 7 Tree 1 Private 2     11 Width 4ft   5988368.12376 2114994.7713599997 37.7867007837837 -122.484046082469 (37.7867007837837, -122.484046082469) 11 6 1 55 33
17748 120261 DPW Maintained 1 Pyrus spp :: Pear Tree 61 130 24th Ave 1 Sidewalk: Curb side : Yard 7 Tree 1 Private 2     9 Width 4ft   5988366.78111 2114978.8034 37.7866568621454 -122.484049556271 (37.7866568621454, -122.484049556271) 11 6 1 55 33
21972 124515 DPW Maintained 1 Pyrus spp :: Pear Tree 61 2636 McAllister St 2 Sidewalk: Property side : Yard 5 Tree 1 Private 2     2 Width 3ft   5996550.39828 2110818.71081 37.7757073936912 -122.455435599477 (37.7757073936912, -122.455435599477) 11 6 2 54 16
41543 142910 DPW Maintained 1 Pyrus spp :: Pear Tree 61 478 GREEN ST 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     5 Width 0ft   6010663.8646 2119301.4269999997 37.7997986292339 -122.407211464682 (37.7997986292339, -122.407211464682) 3 1 10 308 23
41647 143003 DPW Maintained 1 Pyrus spp :: Pear Tree 61 99 Julius St 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     4 Width 0ft   6010486.8105 2120810.1381 37.8039312684383 -122.407930590774 (37.8039312684383, -122.407930590774) 3 1 10 308 23
50572 179282 DPW Maintained 1 Pyrus spp :: Pear Tree 61 170 Brookdale Ave 4 Sidewalk: Property side : Yard 5 Tree 1 Private 2     3 Width 6ft   6005657.15316 2087249.1537 37.7115090783656 -122.422258074876 (37.7115090783656, -122.422258074876) 9 7 8 309 18
64662 19308 DPW Maintained 1 Pyrus spp :: Pear Tree 61 375 07th St 1 Sidewalk: Curb side : Cutout 2 Tree 1 DPW 1     8 3X3   6010658.6989499 2110585.1273498 37.7758654588782 -122.406614766861 (37.7758654588782, -122.406614766861) 14 2 9 28853 34
64673 19309 DPW Maintained 1 Pyrus spp :: Pear Tree 61 375 07th St 2 Sidewalk: Curb side : Cutout 2 Tree 1 DPW 1     8 3X3   6010658.6989499 2110585.1273498 37.7758654588782 -122.406614766861 (37.7758654588782, -122.406614766861) 14 2 9 28853 34
69015 197057 DPW Maintained 1 Pyrus spp :: Pear Tree 61 2000 18th St 4 Sidewalk: Property side : Yard 5 Tree 1 Private 2     3     6011726.09311 2105623.31685 37.7623011121306 -122.402573359597 (37.7623011121306, -122.402573359597) 8 3 8 28856 29
69016 197058 DPW Maintained 1 Pyrus spp :: Pear Tree 61 2000 18th St 5 Sidewalk: Property side : Yard 5 Tree 1 Private 2     1     6011723.1195 2105623.0605900004 37.762300242483704 -122.40258362623699 (37.7623002424837, -122.402583626237) 8 3 8 28856 29
69017 197059 DPW Maintained 1 Pyrus spp :: Pear Tree 61 2000 18th St 8 Sidewalk: Property side : Yard 5 Tree 1 Private 2     2     6011675.5931400005 2105621.49354 37.76229328623621 -122.40274789282199 (37.7622932862362, -122.402747892822) 8 3 8 28856 29
69019 197060 DPW Maintained 1 Pyrus spp :: Pear Tree 61 2000 18th St 9 Sidewalk: Property side : Yard 5 Tree 1 Private 2     1     6011671.34373 2105621.05197 37.7622918365206 -122.402762558964 (37.7622918365206, -122.402762558964) 8 3 8 28856 29
69020 197061 DPW Maintained 1 Pyrus spp :: Pear Tree 61 2000 18th St 10 Sidewalk: Property side : Yard 5 Tree 1 Private 2     2     6011668.6879900005 2105620.78925 37.762290966867795 -122.40277172574699 (37.7622909668678, -122.402771725747) 8 3 8 28856 29
69021 197062 DPW Maintained 1 Pyrus spp :: Pear Tree 61 2000 18th St 11 Sidewalk: Property side : Yard 5 Tree 1 Private 2     2     6011664.44905 2105620.87545 37.7622909668723 -122.402786392795 (37.7622909668723, -122.402786392795) 8 3 8 28856 29
69022 197063 DPW Maintained 1 Pyrus spp :: Pear Tree 61 2000 18th St 12 Sidewalk: Property side : Yard 5 Tree 1 Private 2     2     6011661.58362 2105620.72246 37.762290386803606 -122.402796292538 (37.7622903868036, -122.402796292538) 8 3 8 28856 29
69023 197064 DPW Maintained 1 Pyrus spp :: Pear Tree 61 617 Rhode Island St 1 : 14 Tree 1 Private 2     8 Width 3ft   6011832.82769 2105447.84725 37.7618252700399 -122.40219186538499 (37.7618252700399, -122.402191865385) 10 3 8 28856 29
69024 197065 DPW Maintained 1 Pyrus spp :: Pear Tree 61 1750 22nd St 5 Side Yard : Yard 27 Tree 1 Private 2     1     6012833.7263400005 2103797.94864 37.7573508280876 -122.398614346997 (37.7573508280876, -122.398614346997) 10 3 8 28856 29
69025 197066 DPW Maintained 1 Pyrus spp :: Pear Tree 61 1800 Illinois St 8 Sidewalk: Curb side : Yard 7 Tree 1 Private 2     2 Width 4ft   6016257.10018 2100639.51638 37.7488685664372 -122.38655463261101 (37.7488685664372, -122.386554632611) 10 3 8 58 1
69026 197067 DPW Maintained 1 Pyrus spp :: Pear Tree 61 1700 Armstrong Ave 1 Side Yard : Yard 27 Tree 1 Private 2     1     6013902.76145 2092874.5647599997 37.7274170025835 -122.394152453295 (37.7274170025835, -122.394152453295) 10 3 8 58 1
73108 201541 DPW Maintained 1 Pyrus spp :: Pear Tree 61 601 Innes Ave 10 Sidewalk: Curb side : Yard 7 Tree 1 Private 2     2     6020571.225269999 2093411.7582900003 37.7292604275206 -122.371136408139 (37.7292604275206, -122.371136408139) 10 3 8 58 1
94931 22382 Private 7 Pyrus spp :: Pear Tree 61 2499X Mendell St 2 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2   05/13/1997 12:00:00 AM 3 3X3   6014045.0718623 2092725.5085003 37.7270156330804 -122.393650054041 (37.7270156330804, -122.393650054041) 10 3 8 58 1
94975 22386 Private 7 Pyrus spp :: Pear Tree 61 1769X Armstrong Ave 6 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     3 3X3   6014045.0718623 2092725.5085003 37.7270156330804 -122.393650054041 (37.7270156330804, -122.393650054041) 10 3 8 58 1
111598 239235 DPW Maintained 1 Pyrus spp :: Pear Tree 61 1101 San Jose Ave 13 Front Yard : Yard 4 Tree 1 Private 2     20     6004808.52644 2096397.91285 37.736581658121096 -122.42584194876999 (37.7365816581211, -122.42584194877) 2 7 5 28859 2
111599 239236 DPW Maintained 1 Pyrus spp :: Pear Tree 61 400 Prospect Ave 9 Sidewalk: Property side : Yard 5 Tree 1 Private 2     13     6006240.78075 2097639.08375 37.7400704718884 -122.420978121045 (37.7400704718884, -122.420978121045) 2 7 7 28859 2
111600 239237 DPW Maintained 1 Pyrus spp :: Pear Tree 61 215 Grand View Ave 3 Sidewalk: Property side : Yard 5 Tree 1 Private 2     9 Width 5ft   6000736.454969999 2103194.69167 37.7550130323385 -122.440408115949 (37.7550130323385, -122.440408115949) 2 4 5 28862 22
111601 239238 DPW Maintained 1 Pyrus spp :: Pear Tree 61 215 Grand View Ave 4 Sidewalk: Property side : Yard 5 Tree 1 Private 2     6 Width 5ft   6000739.59043 2103198.58127 37.7550238907662 -122.4403975516 (37.7550238907662, -122.4403975516) 2 4 5 28862 22
112672 240208 DPW Maintained 1 Pyrus spp :: Pear Tree 61 614 28th St 2 Sidewalk: Property side : Yard 5 Tree 1 Private 2     15     6001885.70044 2099454.61302 37.744809035718795 -122.436166070531 (37.7448090357188, -122.436166070531) 2 7 5 63 22
132486 31842 DPW Maintained 1 Pyrus spp :: Pear Tree 61 1265 Folsom St 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2 FUF 2 07/13/2015 12:00:00 AM 9   Permit Number 775724 6009358.6897 2109957.4623 37.77406921986329 -122.411067505232 (37.7740692198633, -122.411067505232) 8 2 9 28853 34
141577 40212 DPW Maintained 1 Pyrus spp :: Pear Tree 61 477 45th Ave 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2 FUF 2 05/06/1999 12:00:00 AM 9   Permit Number 41393 5981888.09405 2112558.21735 37.7796313371332 -122.506284303142 (37.7796313371332, -122.506284303142) 11 6 2 55 26
141578 40213 DPW Maintained 1 Pyrus spp :: Pear Tree 61 477 45th Ave 2 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2 FUF 2 05/06/1999 12:00:00 AM 5   Permit Number 41393 5981888.3284 2112543.9564099996 37.779592194598706 -122.506282434653 (37.7795921945987, -122.506282434653) 11 6 2 55 26
145946 44265 Permitted Site 2 Pyrus spp :: Pear Tree 61 212 Amherst St 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2   02/20/2001 12:00:00 AM     Permit Number 43694 6007447.45814488 2092780.96885075 37.7267990946728 -122.416461883011 (37.7267990946728, -122.416461883011) 9 3 7 309 28
151624 49550 Permitted Site 2 Pyrus spp :: Pear Tree 61 549 Jersey St 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2   04/29/2003 12:00:00 AM     Permit Number 46440 6001603.97118249 2101432.39429039 37.750223543553 -122.437281823397 (37.750223543553, -122.437281823397) 2 4 5 28862 22
152184 50068 Permitted Site 2 Pyrus spp :: Pear Tree 61 849 Sanchez St 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2   04/07/2008 12:00:00 AM   3x3 Permit Number 50340 6003762.74209872 2103351.67000746 37.755615907284 -122.42995354966801 (37.755615907284, -122.429953549668) 2 4 5 28862 22
152356 50225 Permitted Site 2 Pyrus spp :: Pear Tree 61 470@ NOE 27th St 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2   08/19/2015 12:00:00 AM     Permit Number 776169 6003463.98803486 2100125.52863455 37.7467407577194 -122.43075652138201 (37.7467407577194, -122.430756521382) 2 7 5 63 22
158972 56376 DPW Maintained 1 Pyrus spp :: Pear Tree 61 1150 Clement St 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2   08/06/1973 12:00:00 AM 3   Permit Number 12523 5991915.34825 2113464.50763 37.7827049800091 -122.47166209211201 (37.7827049800091, -122.471662092112) 11 6 2 54 11
164740 61806 Permitted Site 2 Pyrus spp :: Pear Tree 61 579 Waller St 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2 FUF 2 08/27/2010 12:00:00 AM     Permit Number 53702 6002929.53125078 2108870.97596244 37.7707233636609 -122.433229406241 (37.7707233636609, -122.433229406241) 15 5 5 29492 9
174682 74860 DPW Maintained 1 Pyrus spp :: Pear Tree 61 465 Missouri St 2 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2   06/22/2010 12:00:00 AM 2 3x3 Permit Number 53589 6013552.24086 2104827.2631900003 37.7602171059641 -122.396201560366 (37.7602171059641, -122.396201560366) 10 3 8 28856 29
176026 80513 Undocumented 3 Pyrus spp :: Pear Tree 61 1769X Armstrong Ave 10 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2   09/07/2002 12:00:00 AM 4     6014044.43135761 2092726.27645989 37.7270177061512 -122.393652321999 (37.7270177061512, -122.393652321999) 10 3 8 58 1
176027 80514 Private 7 Pyrus spp :: Pear Tree 61 1769X Armstrong Ave 9 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2   09/07/2002 12:00:00 AM 4     6014044.43135761 2092726.27645989 37.7270177061512 -122.393652321999 (37.7270177061512, -122.393652321999) 10 3 8 58 1
176028 80515 Private 7 Pyrus spp :: Pear Tree 61 1769X Armstrong Ave 8 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2   09/07/2002 12:00:00 AM 4     6014044.43135761 2092726.27645989 37.7270177061512 -122.393652321999 (37.7270177061512, -122.393652321999) 10 3 8 58 1
176029 80516 Private 7 Pyrus spp :: Pear Tree 61 1769X Armstrong Ave 7 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2   09/07/2002 12:00:00 AM 4     6014044.43135761 2092726.27645989 37.7270177061512 -122.393652321999 (37.7270177061512, -122.393652321999) 10 3 8 58 1
176030 80517 Private 7 Pyrus spp :: Pear Tree 61 1769X Armstrong Ave 5 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2   09/07/2002 12:00:00 AM 3     6014044.43135761 2092726.27645989 37.7270177061512 -122.393652321999 (37.7270177061512, -122.393652321999) 10 3 8 58 1
176031 80518 Private 7 Pyrus spp :: Pear Tree 61 1769X Armstrong Ave 4 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2   09/07/2002 12:00:00 AM 5     6014044.43135761 2092726.27645989 37.7270177061512 -122.393652321999 (37.7270177061512, -122.393652321999) 10 3 8 58 1
176032 80519 Undocumented 3 Pyrus spp :: Pear Tree 61 1769X Armstrong Ave 3 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2   09/07/2002 12:00:00 AM 3     6014044.43135761 2092726.27645989 37.7270177061512 -122.393652321999 (37.7270177061512, -122.393652321999) 10 3 8 58 1
176034 80520 Private 7 Pyrus spp :: Pear Tree 61 2499X Mendell St 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2   09/07/2002 12:00:00 AM 2     6014044.43135761 2092726.27645989 37.7270177061512 -122.393652321999 (37.7270177061512, -122.393652321999) 10 3 8 58 1
176685 8254 DPW Maintained 1 Pyrus spp :: Pear Tree 61 1525 GALVEZ AVE 4 Sidewalk: Curb side : Cutout 2 Tree 1 DPW 1     4 3x3   6016246.0 2097351.0 37.739838361172204 -122.38636376878901 (37.7398383611722, -122.386363768789) 10 3 8 58 1
178217 85044 Permitted Site 2 Pyrus spp :: Pear Tree 61 3130 Pacific Ave 4 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2   06/26/2007 12:00:00 AM     Permit Number 49389 5999161.2 2116695.3 37.7919924388881 -122.446827171413 (37.7919924388881, -122.446827171413) 11 6 1 29490 30
181798 89010 Permitted Site 2 Pyrus spp :: Pear Tree 61 4601 03rd St 2 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2   09/29/2008 12:00:00 AM   4x4 Permit Number 51762 6015147.0 2096120.0 37.7363973921404 -122.390077707197 (37.7363973921404, -122.390077707197) 10 3 8 58 1
181799 89011 Permitted Site 2 Pyrus spp :: Pear Tree 61 4601 03rd St 3 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2   09/29/2008 12:00:00 AM   4x4 Permit Number 51762 6015147.0 2096120.0 37.7363973921404 -122.390077707197 (37.7363973921404, -122.390077707197) 10 3 8 58 1
181800 89012 Permitted Site 2 Pyrus spp :: Pear Tree 61 4601 03rd St 4 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2   09/29/2008 12:00:00 AM   4x4 Permit Number 51762 6015147.0 2096120.0 37.7363973921404 -122.390077707197 (37.7363973921404, -122.390077707197) 10 3 8 58 1
181801 89013 Permitted Site 2 Pyrus spp :: Pear Tree 61 4601 03rd St 5 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2   09/29/2008 12:00:00 AM   4x4 Permit Number 51762 6015147.0 2096120.0 37.7363973921404 -122.390077707197 (37.7363973921404, -122.390077707197) 10 3 8 58 1
185787 93750 Undocumented 3 Pyrus spp :: Pear Tree 61 61X Napoleon St 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2           6013237.1 2100058.8 37.7471063957658 -122.396957155424 (37.7471063957658, -122.396957155424) 10 3 8 58 1
185788 93751 Undocumented 3 Pyrus spp :: Pear Tree 61 61X Napoleon St 2 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2           6013237.1 2100058.8 37.7471063957658 -122.396957155424 (37.7471063957658, -122.396957155424) 10 3 8 58 1
185789 93754 Undocumented 3 Pyrus spp :: Pear Tree 61 61X Napoleon St 5 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2           6013237.1 2100058.8 37.7471063957658 -122.396957155424 (37.7471063957658, -122.396957155424) 10 3 8 58 1
185790 93755 Undocumented 3 Pyrus spp :: Pear Tree 61 61X Napoleon St 6 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2           6013237.1 2100058.8 37.7471063957658 -122.396957155424 (37.7471063957658, -122.396957155424) 10 3 8 58 1
185791 93756 Undocumented 3 Pyrus spp :: Pear Tree 61 61X Napoleon St 7 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2           6013237.1 2100058.8 37.7471063957658 -122.396957155424 (37.7471063957658, -122.396957155424) 10 3 8 58 1
185792 93757 Undocumented 3 Pyrus spp :: Pear Tree 61 61X Napoleon St 8 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2           6013237.1 2100058.8 37.7471063957658 -122.396957155424 (37.7471063957658, -122.396957155424) 10 3 8 58 1
185793 93758 Undocumented 3 Pyrus spp :: Pear Tree 61 61X Napoleon St 9 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2           6013237.1 2100058.8 37.7471063957658 -122.396957155424 (37.7471063957658, -122.396957155424) 10 3 8 58 1
185794 93759 Undocumented 3 Pyrus spp :: Pear Tree 61 61X Napoleon St 10 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2           6013237.1 2100058.8 37.7471063957658 -122.396957155424 (37.7471063957658, -122.396957155424) 10 3 8 58 1
185796 93760 Undocumented 3 Pyrus spp :: Pear Tree 61 61X Napoleon St 11 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2           6013237.1 2100058.8 37.7471063957658 -122.396957155424 (37.7471063957658, -122.396957155424) 10 3 8 58 1
185797 93762 Undocumented 3 Pyrus spp :: Pear Tree 61 61X Napoleon St 13 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2           6013237.1 2100058.8 37.7471063957658 -122.396957155424 (37.7471063957658, -122.396957155424) 10 3 8 58 1
185798 93763 Undocumented 3 Pyrus spp :: Pear Tree 61 61X Napoleon St 14 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2           6013237.1 2100058.8 37.7471063957658 -122.396957155424 (37.7471063957658, -122.396957155424) 10 3 8 58 1
185799 93764 Undocumented 3 Pyrus spp :: Pear Tree 61 61X Napoleon St 15 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2           6013237.1 2100058.8 37.7471063957658 -122.396957155424 (37.7471063957658, -122.396957155424) 10 3 8 58 1
185800 93765 Undocumented 3 Pyrus spp :: Pear Tree 61 61X Napoleon St 16 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2           6013237.1 2100058.8 37.7471063957658 -122.396957155424 (37.7471063957658, -122.396957155424) 10 3 8 58 1
186469 94620 Permitted Site 2 Pyrus spp :: Pear Tree 61 1799X Armstrong Ave 3 Sidewalk: Property side : Cutout 9 Tree 1 Private 2   10/13/2010 12:00:00 AM 4   Permit Number 53777 6014054.0 2092727.0 37.7270202245482 -122.393619293726 (37.7270202245482, -122.393619293726) 10 3 8 58 1
186470 94621 Permitted Site 2 Pyrus spp :: Pear Tree 61 1769X Armstrong Ave 2 Sidewalk: Property side : Cutout 9 Tree 1 Private 2   10/13/2010 12:00:00 AM 2   Permit Number 53777 6014054.0 2092727.0 37.7270202245482 -122.393619293726 (37.7270202245482, -122.393619293726) 10 3 8 58 1
186471 94622 Permitted Site 2 Pyrus spp :: Pear Tree 61 1769 Armstrong Ave 1 Sidewalk: Property side : Cutout 9 Tree 1 Private 2   10/13/2010 12:00:00 AM 3   Permit Number 53777 6014054.0 2092727.0 37.7270202245482 -122.393619293726 (37.7270202245482, -122.393619293726) 10 3 8 58 1
188775 97052 Property Tree 5 Pyrus spp :: Pear Tree 61 795 Wisconsin St   Sidewalk: Property side : Yard 5 Tree 1 Private 2 FUF 2 08/19/2011 12:00:00 AM     Permit Number 767554 6012787.8 2103832.3 37.7574425906128 -122.39877559017401 (37.7574425906128, -122.398775590174) 10 3 8 28856 29
190165 98595 Permitted Site 2 Pyrus spp :: Pear Tree 61 400X Steiner St 1 Sidewalk: Property side : Cutout 9 Tree 1 Private 2   03/01/2012 12:00:00 AM     Permit Number 768529 6004639.0 2109849.0 37.7735056071657 -122.42738600543899 (37.7735056071657, -122.427386005439) 7 9 11 28852 10
190166 98596 Permitted Site 2 Pyrus spp :: Pear Tree 61 400X Steiner St 2 Sidewalk: Property side : Cutout 9 Tree 1 Private 2   03/01/2012 12:00:00 AM     Permit Number 768529 6004639.0 2109849.0 37.7735056071657 -122.42738600543899 (37.7735056071657, -122.427386005439) 7 9 11 28852 10

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

CREATE TABLE "Street_Tree_List" (
"TreeID" INTEGER,
  "qLegalStatus" INTEGER,
  "qSpecies" INTEGER,
  "qAddress" TEXT,
  "SiteOrder" INTEGER,
  "qSiteInfo" INTEGER,
  "PlantType" INTEGER,
  "qCaretaker" INTEGER,
  "qCareAssistant" INTEGER,
  "PlantDate" REAL,
  "DBH" INTEGER,
  "PlotSize" TEXT,
  "PermitNotes" REAL,
  "XCoord" REAL,
  "YCoord" REAL,
  "Latitude" REAL,
  "Longitude" REAL,
  "Location" TEXT,
  "Fire Prevention Districts" INTEGER,
  "Police Districts" INTEGER,
  "Supervisor Districts" INTEGER,
  "Zip Codes" INTEGER,
  "Neighborhoods" INTEGER
,
FOREIGN KEY ("PlantType") REFERENCES [PlantType](id),
    FOREIGN KEY ("qCareAssistant") REFERENCES [qCareAssistant](id),
    FOREIGN KEY ("qCaretaker") REFERENCES [qCaretaker](id),
    FOREIGN KEY ("qLegalStatus") REFERENCES [qLegalStatus](id),
    FOREIGN KEY ("qSiteInfo") REFERENCES [qSiteInfo](id),
    FOREIGN KEY ("qSpecies") REFERENCES [qSpecies](id))
Powered by Datasette · Query took 19.409ms · Data source: data.sfgov.org