Street_Tree_List

Data source: data.sfgov.org

81 rows where qSpecies = 223

View and edit SQL

Suggested facets: qLegalStatus, SiteOrder, qSiteInfo, qCaretaker, qCareAssistant, DBH, PlotSize, PermitNotes

Link rowid ▼ TreeID qLegalStatus qSpecies qAddress SiteOrder qSiteInfo PlantType qCaretaker qCareAssistant PlantDate DBH PlotSize PermitNotes XCoord YCoord Latitude Longitude Location
4224 5207 DPW Maintained 3 Pyrus calleryana 'New Bradford' :: New Bradford Pear 223 793 Divisadero St 2 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   10/10/2017 09:33:00 AM 3 4X4   6001523.4008 2111070.4968 37.7766828297402 -122.438250821585 (37.7766828297402, -122.438250821585)
4238 5194 DPW Maintained 3 Pyrus calleryana 'New Bradford' :: New Bradford Pear 223 600 Divisadero St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   10/10/2017 10:07:00 AM 3 3x3   6001666.9521 2110501.0686 37.7751274863723 -122.437713444711 (37.7751274863723, -122.437713444711)
4240 5172 DPW Maintained 3 Pyrus calleryana 'New Bradford' :: New Bradford Pear 223 338 Divisadero St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   10/10/2017 09:22:00 AM 3     6001789.9809 2109630.9174 37.7727452631602 -122.43722554432199 (37.7727452631602, -122.437225544322)
9839 91603 Permitted Site 1 Pyrus calleryana 'New Bradford' :: New Bradford Pear 223 780 South Van Ness Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   01/03/2017 10:07:00 AM 3 3x3 Permit Number 779025 6007508.236166 2105121.623309 37.7606871964477 -122.41712583220199 (37.7606871964477, -122.417125832202)
12424 86022 DPW Maintained 3 Pyrus calleryana 'New Bradford' :: New Bradford Pear 223 1466 28th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   02/19/2015 01:16:00 PM 3 3x3   5987457.7377 2105310.6049 37.7600577305468 -122.486484470473 (37.7600577305468, -122.486484470473)
17669 5170 DPW Maintained 3 Pyrus calleryana 'New Bradford' :: New Bradford Pear 223 318 Divisadero St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 DPW 4 02/15/2005 12:00:00 AM 3 3X3   6001801.5136 2109559.6859 37.7725503347821 -122.43718055043101 (37.7725503347821, -122.437180550431)
22018 24636 DPW Maintained 3 Pyrus calleryana 'New Bradford' :: New Bradford Pear 223 443 Divisadero St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 DPW 4 06/17/2014 12:00:00 AM 3 3X4   6001673.68932 2109984.60324 37.773709784823296 -122.437653143592 (37.7737097848233, -122.437653143592)
44053 97599 DPW Maintained 3 Pyrus calleryana 'New Bradford' :: New Bradford Pear 223 857 Divisadero St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 DPW 4   3 3x3   6001483.0 2111323.0 37.7773738419974 -122.43840867438801 (37.7773738419974, -122.438408674388)
48970 213910 Undocumented 2 Pyrus calleryana 'New Bradford' :: New Bradford Pear 223 2083 16th Ave 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     1 Width 3ft   5991275.499919999 2101271.7722099996 37.7491899580666 -122.47298626481 (37.7491899580666, -122.47298626481)
61687 97564 DPW Maintained 3 Pyrus calleryana 'New Bradford' :: New Bradford Pear 223 252 Divisadero St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 DPW 4   3     6001879.6 2109184.5 37.7715246060424 -122.43688357823 (37.7715246060424, -122.43688357823)
76207 239234 Undocumented 2 Pyrus calleryana 'New Bradford' :: New Bradford Pear 223 741 South Van Ness Ave 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     1 Width 3ft   6007547.184880001 2105311.87319 37.7612117696384 -122.417004605998 (37.7612117696384, -122.417004605998)
77844 94858 Permitted Site 1 Pyrus calleryana 'New Bradford' :: New Bradford Pear 223 2595 15th Ave   Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 07/24/2009 12:00:00 AM   3x3 Permit Number 52715 5991705.5 2097813.3 37.739718766740395 -122.47124738715901 (37.7397187667404, -122.471247387159)
79597 90893 DPW Maintained 3 Pyrus calleryana 'New Bradford' :: New Bradford Pear 223 1543 Cabrillo St 2 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   02/20/2008 12:00:00 AM 3 3x3   5990848.858395 2110608.244152 37.7748007067893 -122.47514307566401 (37.7748007067893, -122.475143075664)
80527 97588 DPW Maintained 3 Pyrus calleryana 'New Bradford' :: New Bradford Pear 223 327 Divisadero St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 DPW 4   3     6001736.6 2109522.6 37.7724448159613 -122.437402436672 (37.7724448159613, -122.437402436672)
80675 97585 DPW Maintained 3 Pyrus calleryana 'New Bradford' :: New Bradford Pear 223 850 Divisadero St 2 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     3 3x3   6001611.6 2111343.2 37.777436620070404 -122.43796525309901 (37.7774366200704, -122.437965253099)
83032 28101 DPW Maintained 3 Pyrus calleryana 'New Bradford' :: New Bradford Pear 223 305 Divisadero St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 DPW 4   3 3X3   6001749.0605888 2109439.6370142 37.7722177286516 -122.437353392664 (37.7722177286516, -122.437353392664)
84000 103347 Permitted Site 1 Pyrus calleryana 'New Bradford' :: New Bradford Pear 223 619 Divisadero St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1       3x3   6001601.8 2110515.0 37.775162033747 -122.437939817938 (37.775162033747, -122.437939817938)
84131 103336 Permitted Site 1 Pyrus calleryana 'New Bradford' :: New Bradford Pear 223 201 Divisadero St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1       3x3   6001868.0 2108744.0 37.7703144430335 -122.436892163064 (37.7703144430335, -122.436892163064)
84168 28096 DPW Maintained 3 Pyrus calleryana 'New Bradford' :: New Bradford Pear 223 850 Divisadero St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 DPW 4   3 3X3   6001561.6093482 2111313.2017111 37.77735140937129 -122.43813603744499 (37.7773514093713, -122.438136037445)
84541 82601 Permitted Site 1 Pyrus calleryana 'New Bradford' :: New Bradford Pear 223 1539X 20th St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   07/02/2009 12:00:00 AM   3x3 Permit Number 52377 6013275.21379985 2104716.05721549 37.7598963404579 -122.397151874959 (37.7598963404579, -122.397151874959)
84637 90876 DPW Maintained 3 Pyrus calleryana 'New Bradford' :: New Bradford Pear 223 1935 Cabrillo St 2 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2 Cleary Bros. Landscape 8 02/20/2008 12:00:00 AM 3 3x3   5989632.284630001 2110564.0911 37.7746088893469 -122.47934817793801 (37.7746088893469, -122.479348177938)
87103 94856 Permitted Site 1 Pyrus calleryana 'New Bradford' :: New Bradford Pear 223 2595 15th Ave   Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 07/24/2009 12:00:00 AM   3x3 Permit Number 52715 5991705.5 2097813.3 37.739718766740395 -122.47124738715901 (37.7397187667404, -122.471247387159)
88343 97566 DPW Maintained 3 Pyrus calleryana 'New Bradford' :: New Bradford Pear 223 338 Divisadero St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 DPW 4   3     6001793.0 2109569.0 37.7725754250276 -122.437210666805 (37.7725754250276, -122.437210666805)
89912 121214 Undocumented 2 Pyrus calleryana 'New Bradford' :: New Bradford Pear 223 428 South Van Ness Ave 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     3 3x3   6007392.0 2107190.0 37.7663599374838 -122.417674448479 (37.7663599374838, -122.417674448479)
91810 121316 Undocumented 2 Pyrus calleryana 'New Bradford' :: New Bradford Pear 223 1272 South Van Ness Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     2 3x3   6007671.0 2102251.0 37.7528142772775 -122.41635957329201 (37.7528142772775, -122.416359573292)
96755 90870 DPW Maintained 3 Pyrus calleryana 'New Bradford' :: New Bradford Pear 223 2045 Cabrillo St 3 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2 Cleary Bros. Landscape 8 02/19/2008 12:00:00 AM 3 3x3   5989292.971461 2110551.77641 37.7745553629802 -122.48052101423 (37.7745553629802, -122.48052101423)
99964 91622 Permitted Site 1 Pyrus calleryana 'New Bradford' :: New Bradford Pear 223 1362 South Van Ness Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   09/12/2016 12:00:00 AM 3 3x3 Permit Number 777634 6007695.98109 2101723.729287 37.7513679161611 -122.416235842859 (37.7513679161611, -122.416235842859)
100514 97565 DPW Maintained 3 Pyrus calleryana 'New Bradford' :: New Bradford Pear 223 258 Divisadero St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 DPW 4   3     6001879.6 2109184.5 37.7715246060424 -122.43688357823 (37.7715246060424, -122.43688357823)
100898 28100 Permitted Site 1 Pyrus calleryana 'New Bradford' :: New Bradford Pear 223 333 Divisadero St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   03/17/2004 12:00:00 AM 3 3X4   6001700.99637 2109613.90642 37.7726934964711 -122.437532132705 (37.7726934964711, -122.437532132705)
100957 24625 Permitted Site 1 Pyrus calleryana 'New Bradford' :: New Bradford Pear 223 260 Divisadero St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   03/27/1990 12:00:00 AM 3 3X3   6001846.40208 2109219.06112 37.7716176154118 -122.437000886177 (37.7716176154118, -122.437000886177)
104363 24644 DPW Maintained 3 Pyrus calleryana 'New Bradford' :: New Bradford Pear 223 845 Divisadero St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 DPW 4 12/17/2001 12:00:00 AM 3 3X3   6001484.9123945 2111282.0018462 37.7772613801811 -122.43839912079099 (37.7772613801811, -122.438399120791)
105302 121213 Undocumented 2 Pyrus calleryana 'New Bradford' :: New Bradford Pear 223 428 South Van Ness Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     3 3x3   6007392.0 2107190.0 37.7663599374838 -122.417674448479 (37.7663599374838, -122.417674448479)
105955 24643 DPW Maintained 3 Pyrus calleryana 'New Bradford' :: New Bradford Pear 223 801X Divisadero St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 DPW 4 05/04/2010 12:00:00 AM 3 4x4   6001519.6000152 2111126.7877173 37.776837174254 -122.438268003206 (37.776837174254, -122.438268003206)
106030 108428 Permitted Site 1 Pyrus calleryana 'New Bradford' :: New Bradford Pear 223 3041 26th St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 12/22/2014 12:00:00 AM 3 3x3 Permit Number 773727 6009384.50414 2100992.21105 37.74945413070979 -122.41034506487301 (37.7494541307098, -122.410345064873)
106746 97598 DPW Maintained 3 Pyrus calleryana 'New Bradford' :: New Bradford Pear 223 701X Divisadero St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 DPW 4   3 4x3   6001578.0 2110798.0 37.7759377272515 -122.438042423333 (37.7759377272515, -122.438042423333)
106828 24629 DPW Maintained 3 Pyrus calleryana 'New Bradford' :: New Bradford Pear 223 616 Divisadero St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 DPW 4 12/06/2006 12:00:00 AM 3 3x3   6001670.9205271 2110518.3359108996 37.7751751237236 -122.437700953995 (37.7751751237236, -122.437700953995)
106954 109794 Permitted Site 1 Pyrus calleryana 'New Bradford' :: New Bradford Pear 223 2083 16th Ave 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 03/03/2015 12:00:00 AM 3 3x3 Permit Number 775060 5991259.8 2101279.3 37.7492097184614 -122.47304110371999 (37.7492097184614, -122.47304110372)
107478 90565 DPW Maintained 3 Pyrus calleryana 'New Bradford' :: New Bradford Pear 223 1798X Cabrillo St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   02/14/2008 12:00:00 AM 3 3x3   5990060.203422 2110619.647941 37.7747862779908 -122.47787200048501 (37.7747862779908, -122.477872000485)
108016 28093 DPW Maintained 3 Pyrus calleryana 'New Bradford' :: New Bradford Pear 223 508 Divisadero St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 DPW 4   3 3X3   6001722.1241568 2110151.9438084 37.7741720139963 -122.43749758605 (37.7741720139963, -122.43749758605)
108200 97586 DPW Maintained 3 Pyrus calleryana 'New Bradford' :: New Bradford Pear 223 285 Divisadero St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 DPW 4   3     6001769.0 2109329.0 37.771915080469 -122.437276497302 (37.771915080469, -122.437276497302)
108359 59302 Permitted Site 1 Pyrus calleryana 'New Bradford' :: New Bradford Pear 223 52 06th St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   07/23/2014 12:00:00 AM 3 5x5 Permit Number 773592 6009877.34953227 2112642.20965748 37.781469977428 -122.40946287804701 (37.781469977428, -122.409462878047)
109216 90573 DPW Maintained 3 Pyrus calleryana 'New Bradford' :: New Bradford Pear 223 1942 Cabrillo St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2 Cleary Bros. Landscape 8 02/15/2008 12:00:00 AM 3 3x3   5989607.117119 2110603.2040279997 37.7747148208537 -122.47943809850099 (37.7747148208537, -122.479438098501)
109643 50465 Permitted Site 1 Pyrus calleryana 'New Bradford' :: New Bradford Pear 223 3861 24th St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   04/06/2016 12:00:00 AM 3   Permit Number 777923 6004067.99679008 2101865.11785477 37.7515514669378 -122.428791912654 (37.7515514669378, -122.428791912654)
109678 97597 DPW Maintained 3 Pyrus calleryana 'New Bradford' :: New Bradford Pear 223 701X Divisadero St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 DPW 4   3 4x3   6001578.0 2110798.0 37.7759377272515 -122.438042423333 (37.7759377272515, -122.438042423333)
111805 94857 Permitted Site 1 Pyrus calleryana 'New Bradford' :: New Bradford Pear 223 2595 15th Ave   Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 07/24/2009 12:00:00 AM   3x3 Permit Number 52715 5991705.5 2097813.3 37.739718766740395 -122.47124738715901 (37.7397187667404, -122.471247387159)
112376 92280 Permitted Site 1 Pyrus calleryana 'New Bradford' :: New Bradford Pear 223 551 Vicente St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   07/27/2009 12:00:00 AM   3x3 Permit Number 52729 5991264.0 2097696.0 37.739371142832 -122.47276534056002 (37.739371142832, -122.47276534056)
113192 103335 DPW Maintained 3 Pyrus calleryana 'New Bradford' :: New Bradford Pear 223 211 Divisadero St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2       3x3   6001839.0 2108819.0 37.7705187261581 -122.436997844091 (37.7705187261581, -122.436997844091)
113485 97567 DPW Maintained 3 Pyrus calleryana 'New Bradford' :: New Bradford Pear 223 342 Divisadero St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 DPW 4   3     6001791.0 2109583.0 37.772613751849605 -122.43721858759199 (37.7726137518496, -122.437218587592)
114010 103334 DPW Maintained 3 Pyrus calleryana 'New Bradford' :: New Bradford Pear 223 223 Divisadero St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2       3x3   6001827.0 2108903.0 37.770748687247604 -122.437045366963 (37.7707486872476, -122.437045366963)
114103 121216 Undocumented 2 Pyrus calleryana 'New Bradford' :: New Bradford Pear 223 428 South Van Ness Ave 4 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     3 3x3   6007392.0 2107190.0 37.7663599374838 -122.417674448479 (37.7663599374838, -122.417674448479)
114335 5184 DPW Maintained 3 Pyrus calleryana 'New Bradford' :: New Bradford Pear 223 460X Divisadero St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 DPW 4 04/21/2016 12:00:00 AM 3 3x3   6001745.349517 2109984.4298688998 37.7737133829934 -122.437405247826 (37.7737133829934, -122.437405247826)
116328 5157 DPW Maintained 3 Pyrus calleryana 'New Bradford' :: New Bradford Pear 223 270 Divisadero St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 DPW 4   0     6001849.8958745 2109240.8779841997 37.7716777176824 -122.43699036314301 (37.7716777176824, -122.436990363143)
117253 97580 DPW Maintained 3 Pyrus calleryana 'New Bradford' :: New Bradford Pear 223 700X Divisadero St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 DPW 4   3 3x3   6001615.5 2110795.9 37.7759340937147 -122.437912550894 (37.7759340937147, -122.437912550894)
118370 97563 DPW Maintained 3 Pyrus calleryana 'New Bradford' :: New Bradford Pear 223 250 Divisadero St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 DPW 4 09/21/2015 12:00:00 AM 3 5x5   6001845.0 2109086.0 37.771252182937296 -122.436996208247 (37.7712521829373, -122.436996208247)
118803 97587 DPW Maintained 3 Pyrus calleryana 'New Bradford' :: New Bradford Pear 223 319 Divisadero St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 DPW 4   3     6001745.0 2109492.0 37.772361273527004 -122.437371188758 (37.772361273527, -122.437371188758)
118867 90887 DPW Maintained 3 Pyrus calleryana 'New Bradford' :: New Bradford Pear 223 1643 Cabrillo St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   02/20/2008 12:00:00 AM 3 3x3   5990539.067555999 2110597.000965 37.7747518763368 -122.476213873596 (37.7747518763368, -122.476213873596)
119523 97603 DPW Maintained 3 Pyrus calleryana 'New Bradford' :: New Bradford Pear 223 823 Divisadero St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 DPW 4   3 3x3   6001500.0 2111204.0 37.777048064939706 -122.438341338421 (37.7770480649397, -122.438341338421)
119623 91636 DPW Maintained 3 Pyrus calleryana 'New Bradford' :: New Bradford Pear 223 1515 South Van Ness Ave 4 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   10/05/2016 12:00:00 AM 3 3x3   6007819.0 2100813.0 37.7488741754589 -122.415745948384 (37.7488741754589, -122.415745948384)
119651 97570 DPW Maintained 3 Pyrus calleryana 'New Bradford' :: New Bradford Pear 223 546 Divisadero St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 DPW 4   3     6001754.3 2110345.0 37.7747039272721 -122.437400111383 (37.7747039272721, -122.437400111383)
119913 97600 DPW Maintained 3 Pyrus calleryana 'New Bradford' :: New Bradford Pear 223 857 Divisadero St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 DPW 4   3 3x3   6001483.0 2111323.0 37.7773738419974 -122.43840867438801 (37.7773738419974, -122.438408674388)
120836 24637 DPW Maintained 3 Pyrus calleryana 'New Bradford' :: New Bradford Pear 223 425 Divisadero St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 DPW 4 10/25/2011 12:00:00 AM 3 3X3   6001690.3813095 2109822.1283023 37.773264618286 -122.437583765683 (37.773264618286, -122.437583765683)
121851 97594 DPW Maintained 3 Pyrus calleryana 'New Bradford' :: New Bradford Pear 223 601X Divisadero St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 DPW 4   3 3x3   6001572.2 2110512.7 37.7751540352305 -122.43804204596901 (37.7751540352305, -122.438042045969)
124693 82719 Permitted Site 1 Pyrus calleryana 'New Bradford' :: New Bradford Pear 223 2595 15th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   07/24/2009 12:00:00 AM   3x3 Permit Number 52715 5991720.59617436 2097783.87715418 37.739638852304296 -122.471193048427 (37.7396388523043, -122.471193048427)
124975 90867 DPW Maintained 3 Pyrus calleryana 'New Bradford' :: New Bradford Pear 223 2133 Cabrillo St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2 Cleary Bros. Landscape 8 02/19/2008 12:00:00 AM 3 3x3   5989018.500813 2110541.8150979998 37.774512057064904 -122.481469721054 (37.7745120570649, -122.481469721054)
125387 84443 Permitted Site 1 Pyrus calleryana 'New Bradford' :: New Bradford Pear 223 2434 16th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   07/24/2009 12:00:00 AM   3x3 Permit Number 52716 5991409.96468472 2098844.30973007 37.7425325563657 -122.4723443524 (37.7425325563657, -122.4723443524)
127760 92281 Permitted Site 1 Pyrus calleryana 'New Bradford' :: New Bradford Pear 223 551 Vicente St 4 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   07/27/2009 12:00:00 AM   3x3 Permit Number 52729 5991264.0 2097696.0 37.739371142832 -122.47276534056002 (37.739371142832, -122.47276534056)
127863 50467 Permitted Site 1 Pyrus calleryana 'New Bradford' :: New Bradford Pear 223 3861 24th St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   04/06/2016 12:00:00 AM 3   Permit Number 777923 6004067.99679008 2101865.11785477 37.7515514669378 -122.428791912654 (37.7515514669378, -122.428791912654)
128291 5191 Permitted Site 1 Pyrus calleryana 'New Bradford' :: New Bradford Pear 223 541 Divisadero St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   06/29/2007 12:00:00 AM 3 3x3   6001615.92994 2110244.1499099997 37.774419150778705 -122.43787153558901 (37.7744191507787, -122.437871535589)
129201 121215 Undocumented 2 Pyrus calleryana 'New Bradford' :: New Bradford Pear 223 428 South Van Ness Ave 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     3 3x3   6007392.0 2107190.0 37.7663599374838 -122.417674448479 (37.7663599374838, -122.417674448479)
131797 197039 Undocumented 2 Pyrus calleryana 'New Bradford' :: New Bradford Pear 223 1751 Armstrong Ave 20 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     6 Width 4ft   6013908.23302 2092796.76107 37.727203673496795 -122.394128093333 (37.7272036734968, -122.394128093333)
138332 97576 DPW Maintained 3 Pyrus calleryana 'New Bradford' :: New Bradford Pear 223 600 Divisadero St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   04/03/2013 12:00:00 AM 3 3x3   6001656.0 2110448.0 37.774981150555796 -122.437747528771 (37.7749811505558, -122.437747528771)
138704 91592 DPW Maintained 3 Pyrus calleryana 'New Bradford' :: New Bradford Pear 223 590 South Van Ness Ave   Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   03/01/2007 12:00:00 AM 5 3x3 Permit Number 776895 6007446.6064019995 2106234.50211 37.7637394360724 -122.41741785273899 (37.7637394360724, -122.417417852739)
139050 83157 Permitted Site 1 Pyrus calleryana 'New Bradford' :: New Bradford Pear 223 1539X 20th St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   07/02/2009 12:00:00 AM   3x3 Permit Number 52377 6013275.21379985 2104716.05721549 37.7598963404579 -122.397151874959 (37.7598963404579, -122.397151874959)
141399 97582 DPW Maintained 3 Pyrus calleryana 'New Bradford' :: New Bradford Pear 223 744 Divisadero St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 DPW 4   3 3x3   6001602.0 2110950.0 37.7763564458951 -122.43797029127701 (37.7763564458951, -122.437970291277)
143224 97589 DPW Maintained 3 Pyrus calleryana 'New Bradford' :: New Bradford Pear 223 563 Divisadero St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   05/04/2010 12:00:00 AM 3 3x3   6001625.1 2110320.9 37.77463040875271 -122.43784531296001 (37.7746304087527, -122.43784531296)
143644 90881 DPW Maintained 3 Pyrus calleryana 'New Bradford' :: New Bradford Pear 223 1855 Cabrillo St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2 Cleary Bros. Landscape 8 02/20/2008 12:00:00 AM 3 3x3   5989882.489844 2110573.171827 37.7746483516209 -122.478483342296 (37.7746483516209, -122.478483342296)
143690 90889 DPW Maintained 3 Pyrus calleryana 'New Bradford' :: New Bradford Pear 223 1643 Cabrillo St 3 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   02/20/2008 12:00:00 AM 3 3x3   5990539.067555999 2110597.000965 37.7747518763368 -122.476213873596 (37.7747518763368, -122.476213873596)
144879 24627 DPW Maintained 3 Pyrus calleryana 'New Bradford' :: New Bradford Pear 223 444 Divisadero St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 DPW 4 12/06/2006 12:00:00 AM 3 3X4   6001753.1685929 2109931.6605583 37.7735689361616 -122.43737442109699 (37.7735689361616, -122.437374421097)
145991 97568 DPW Maintained 3 Pyrus calleryana 'New Bradford' :: New Bradford Pear 223 500 Divisadero St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 DPW 4   3     6001703.0 2110108.0 37.7740502679918 -122.437560592174 (37.7740502679918, -122.437560592174)
155741 239233 Undocumented 2 Pyrus calleryana 'New Bradford' :: New Bradford Pear 223 741 South Van Ness Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     1 Width 3ft   6007548.09398 2105288.36934 37.761147284644295 -122.41699979641899 (37.7611472846443, -122.416999796419)
173100 197038 Undocumented 2 Pyrus calleryana 'New Bradford' :: New Bradford Pear 223 2401 Mendell St 2 Sidewalk: Property side : Yard 9 Tree 1 Private 1     4 Width 9ft   6013437.73435 2093129.7743099998 37.728091897903 -122.395777939219 (37.728091897903, -122.395777939219)

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" TEXT,
  "DBH" INTEGER,
  "PlotSize" TEXT,
  "PermitNotes" TEXT,
  "XCoord" REAL,
  "YCoord" REAL,
  "Latitude" REAL,
  "Longitude" REAL,
  "Location" TEXT
,
FOREIGN KEY ("PlantType") REFERENCES [PlantType](id),
    FOREIGN KEY ("qCaretaker") REFERENCES [qCaretaker](id),
    FOREIGN KEY ("qSpecies") REFERENCES [qSpecies](id),
    FOREIGN KEY ("qSiteInfo") REFERENCES [qSiteInfo](id),
    FOREIGN KEY ("qCareAssistant") REFERENCES [qCareAssistant](id),
    FOREIGN KEY ("qLegalStatus") REFERENCES [qLegalStatus](id));
CREATE INDEX ["Street_Tree_List_PlantType"] ON [Street_Tree_List]("PlantType");
CREATE INDEX ["Street_Tree_List_qCaretaker"] ON [Street_Tree_List]("qCaretaker");
CREATE INDEX ["Street_Tree_List_qSpecies"] ON [Street_Tree_List]("qSpecies");
CREATE INDEX ["Street_Tree_List_qSiteInfo"] ON [Street_Tree_List]("qSiteInfo");
CREATE INDEX ["Street_Tree_List_qCareAssistant"] ON [Street_Tree_List]("qCareAssistant");
CREATE INDEX ["Street_Tree_List_qLegalStatus"] ON [Street_Tree_List]("qLegalStatus");
Powered by Datasette · Query took 46.731ms · Data source: data.sfgov.org