81 rows where qSpecies_id = 347

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)
12090 97599 DPW Maintained 1 Pyrus calleryana 'New Bradford' :: New Bradford Pear 347 857 Divisadero St 1 Sidewalk: Curb side : Cutout Tree Private 2 DPW   3 3x3   6001483 2111323 37.7773738419974 -122.438408674388 (37.7773738419974, -122.438408674388) 15 5 11 29492 41
17921 97564 DPW Maintained 1 Pyrus calleryana 'New Bradford' :: New Bradford Pear 347 252 Divisadero St 1 Sidewalk: Curb side : Cutout Tree Private 2 DPW   3     6001879.6 2109184.5 37.7715246060424 -122.43688357823 (37.7715246060424, -122.43688357823) 15 5 11 29492 9
22139 92281 Permitted Site 7 Pyrus calleryana 'New Bradford' :: New Bradford Pear 347 551 Vicente St 4 Sidewalk: Curb side : Cutout Tree Private 2   07/27/2009 12:00:00 AM   3x3 Permit Number 52729 5991264 2097696 37.739371142832 -122.47276534056 (37.739371142832, -122.47276534056) 1 8 4 29491 40
22643 84443 Permitted Site 7 Pyrus calleryana 'New Bradford' :: New Bradford Pear 347 2434 16th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   07/24/2009 12:00:00 AM   3x3 Permit Number 52716 5991409.96468472 2098844.30973007 37.7425325563657 -122.4723443524 (37.7425325563657, -122.4723443524) 1 8 4 29491 40
25482 239233 DPW Maintained 1 Pyrus calleryana 'New Bradford' :: New Bradford Pear 347 741 South Van Ness Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     1 Width 3ft   6007548.09398 2105288.36934 37.7611472846443 -122.416999796419 (37.7611472846443, -122.416999796419) 2 4 7 28859 19
26273 50467 Permitted Site 7 Pyrus calleryana 'New Bradford' :: New Bradford Pear 347 3861 24th St 1 Sidewalk: Curb side : Cutout Tree Private 2   04/06/2016 12:00:00 AM 3   Permit Number 777923 6004067.99679008 2101865.11785477 37.7515514669378 -122.428791912654 (37.7515514669378, -122.428791912654) 2 4 5 28862 22
28262 5191 Permitted Site 7 Pyrus calleryana 'New Bradford' :: New Bradford Pear 347 541 Divisadero St 1 Sidewalk: Curb side : Cutout Tree Private 2   06/29/2007 12:00:00 AM 3 3x3   6001615.92994 2110244.14991 37.7744191507787 -122.437871535589 (37.7744191507787, -122.437871535589) 15 5 11 29492 10
34390 90867 DPW Maintained 1 Pyrus calleryana 'New Bradford' :: New Bradford Pear 347 2133 Cabrillo St 1 Sidewalk: Curb side : Cutout Tree DPW 1 Cleary Bros. Landscape 02/19/2008 12:00:00 AM 3 3x3   5989018.500813 2110541.815098 37.7745120570649 -122.481469721054 (37.7745120570649, -122.481469721054) 11 6 2 55 26
35180 82719 Permitted Site 7 Pyrus calleryana 'New Bradford' :: New Bradford Pear 347 2595 15th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   07/24/2009 12:00:00 AM   3x3 Permit Number 52715 5991720.59617436 2097783.87715418 37.7396388523043 -122.471193048427 (37.7396388523043, -122.471193048427) 1 8 4 29491 40
35362 121215 Undocumented 4 Pyrus calleryana 'New Bradford' :: New Bradford Pear 347 428 South Van Ness Ave 3 Sidewalk: Curb side : Cutout Tree Private 2     3 3x3   6007392 2107190 37.7663599374838 -122.417674448479 (37.7663599374838, -122.417674448479) 8 4 7 28853 19
38107 94858 Permitted Site 7 Pyrus calleryana 'New Bradford' :: New Bradford Pear 347 2595 15th Ave   Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/24/2009 12:00:00 AM   3x3 Permit Number 52715 5991705.5 2097813.3 37.7397187667404 -122.471247387159 (37.7397187667404, -122.471247387159) 1 8 4 29491 40
38753 28096 DPW Maintained 1 Pyrus calleryana 'New Bradford' :: New Bradford Pear 347 850 Divisadero St 1 Sidewalk: Curb side : Cutout Tree Private 2 DPW   3 3X3   6001561.6093482 2111313.2017111 37.7773514093713 -122.438136037445 (37.7773514093713, -122.438136037445) 15 5 11 29492 41
40715 97585 DPW Maintained 1 Pyrus calleryana 'New Bradford' :: New Bradford Pear 347 850 Divisadero St 2 Sidewalk: Curb side : Cutout Tree DPW 1     3 3x3   6001611.6 2111343.2 37.7774366200704 -122.437965253099 (37.7774366200704, -122.437965253099) 15 5 11 29492 41
41312 90893 DPW Maintained 1 Pyrus calleryana 'New Bradford' :: New Bradford Pear 347 1543 Cabrillo St 2 Sidewalk: Curb side : Cutout Tree DPW 1   02/20/2008 12:00:00 AM 3 3x3   5990848.858395 2110608.244152 37.7748007067893 -122.475143075664 (37.7748007067893, -122.475143075664) 11 6 2 54 26
42414 103347 Permitted Site 7 Pyrus calleryana 'New Bradford' :: New Bradford Pear 347 619 Divisadero St 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6001601.8 2110515 37.775162033747 -122.437939817938 (37.775162033747, -122.437939817938) 15 5 11 29492 10
43311 28101 DPW Maintained 1 Pyrus calleryana 'New Bradford' :: New Bradford Pear 347 305 Divisadero St 1 Sidewalk: Curb side : Cutout Tree Private 2 DPW   3 3X3   6001749.0605888 2109439.6370142 37.7722177286516 -122.437353392664 (37.7722177286516, -122.437353392664) 15 5 11 29492 9
43862 97588 DPW Maintained 1 Pyrus calleryana 'New Bradford' :: New Bradford Pear 347 327 Divisadero St 1 Sidewalk: Curb side : Cutout Tree Private 2 DPW   3     6001736.6 2109522.6 37.7724448159613 -122.437402436672 (37.7724448159613, -122.437402436672) 15 5 11 29492 9
48441 5170 DPW Maintained 1 Pyrus calleryana 'New Bradford' :: New Bradford Pear 347 318 Divisadero St 1 Sidewalk: Curb side : Cutout Tree Private 2 DPW 02/15/2005 12:00:00 AM 3 3X3   6001801.5136 2109559.6859 37.7725503347821 -122.437180550431 (37.7725503347821, -122.437180550431) 15 5 11 29492 9
49540 90876 DPW Maintained 1 Pyrus calleryana 'New Bradford' :: New Bradford Pear 347 1935 Cabrillo St 2 Sidewalk: Curb side : Cutout Tree DPW 1 Cleary Bros. Landscape 02/20/2008 12:00:00 AM 3 3x3   5989632.28463 2110564.0911 37.7746088893469 -122.479348177938 (37.7746088893469, -122.479348177938) 11 6 2 55 26
55074 103336 Permitted Site 7 Pyrus calleryana 'New Bradford' :: New Bradford Pear 347 201 Divisadero St 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6001868 2108744 37.7703144430335 -122.436892163064 (37.7703144430335, -122.436892163064) 15 5 5 29492 9
57404 82601 Permitted Site 7 Pyrus calleryana 'New Bradford' :: New Bradford Pear 347 1539X 20th St 2 Sidewalk: Curb side : Cutout Tree Private 2   07/02/2009 12:00:00 AM   3x3 Permit Number 52377 6013275.21379985 2104716.05721549 37.7598963404579 -122.397151874959 (37.7598963404579, -122.397151874959) 10 3 8 28856 29
60488 97566 DPW Maintained 1 Pyrus calleryana 'New Bradford' :: New Bradford Pear 347 338 Divisadero St 1 Sidewalk: Curb side : Cutout Tree Private 2 DPW   3     6001793 2109569 37.7725754250276 -122.437210666805 (37.7725754250276, -122.437210666805) 15 5 11 29492 9
60817 239234 DPW Maintained 1 Pyrus calleryana 'New Bradford' :: New Bradford Pear 347 741 South Van Ness Ave 2 Sidewalk: Curb side : Cutout Tree Private 2     1 Width 3ft   6007547.18488 2105311.87319 37.7612117696384 -122.417004605998 (37.7612117696384, -122.417004605998) 2 4 7 28859 19
61623 94856 Permitted Site 7 Pyrus calleryana 'New Bradford' :: New Bradford Pear 347 2595 15th Ave   Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/24/2009 12:00:00 AM   3x3 Permit Number 52715 5991705.5 2097813.3 37.7397187667404 -122.471247387159 (37.7397187667404, -122.471247387159) 1 8 4 29491 40
67069 121214 Undocumented 4 Pyrus calleryana 'New Bradford' :: New Bradford Pear 347 428 South Van Ness Ave 2 Sidewalk: Curb side : Cutout Tree Private 2     3 3x3   6007392 2107190 37.7663599374838 -122.417674448479 (37.7663599374838, -122.417674448479) 8 4 7 28853 19
78191 197038 DPW Maintained 1 Pyrus calleryana 'New Bradford' :: New Bradford Pear 347 2401 Mendell St 2 Sidewalk: Property side : Yard Tree Private 2     4 Width 9ft   6013437.73435 2093129.77431 37.728091897903 -122.395777939219 (37.728091897903, -122.395777939219) 10 3 8 58 1
79623 121316 Undocumented 4 Pyrus calleryana 'New Bradford' :: New Bradford Pear 347 1272 South Van Ness Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     2 3x3   6007671 2102251 37.7528142772775 -122.416359573292 (37.7528142772775, -122.416359573292) 2 4 7 28859 19
86188 90870 DPW Maintained 1 Pyrus calleryana 'New Bradford' :: New Bradford Pear 347 2045 Cabrillo St 3 Sidewalk: Curb side : Cutout Tree DPW 1 Cleary Bros. Landscape 02/19/2008 12:00:00 AM 3 3x3   5989292.971461 2110551.77641 37.7745553629802 -122.48052101423 (37.7745553629802, -122.48052101423) 11 6 2 55 26
88395 5207 DPW Maintained 1 Pyrus calleryana 'New Bradford' :: New Bradford Pear 347 793 Divisadero St 2 Sidewalk: Curb side : Cutout Tree DPW 1   10/10/2017 09:33:00 AM 3 4X4   6001523.4008 2111070.4968 37.7766828297402 -122.438250821585 (37.7766828297402, -122.438250821585) 15 5 11 29492 10
96147 28100 Permitted Site 7 Pyrus calleryana 'New Bradford' :: New Bradford Pear 347 333 Divisadero St 1 Sidewalk: Curb side : Cutout Tree Private 2   03/17/2004 12:00:00 AM 3 3X4   6001700.99637 2109613.90642 37.7726934964711 -122.437532132705 (37.7726934964711, -122.437532132705) 15 5 11 29492 9
97252 24625 Permitted Site 7 Pyrus calleryana 'New Bradford' :: New Bradford Pear 347 260 Divisadero St 1 Sidewalk: Curb side : Cutout Tree Private 2   03/27/1990 12:00:00 AM 3 3X3   6001846.40208 2109219.06112 37.7716176154118 -122.437000886177 (37.7716176154118, -122.437000886177) 15 5 11 29492 9
101090 97565 DPW Maintained 1 Pyrus calleryana 'New Bradford' :: New Bradford Pear 347 258 Divisadero St 1 Sidewalk: Curb side : Cutout Tree Private 2 DPW   3     6001879.6 2109184.5 37.7715246060424 -122.43688357823 (37.7715246060424, -122.43688357823) 15 5 11 29492 9
103671 5194 DPW Maintained 1 Pyrus calleryana 'New Bradford' :: New Bradford Pear 347 600 Divisadero St 1 Sidewalk: Curb side : Cutout Tree DPW 1   10/10/2017 10:07:00 AM 3 3x3   6001666.9521 2110501.0686 37.7751274863723 -122.437713444711 (37.7751274863723, -122.437713444711) 15 5 11 29492 10
104071 91622 Permitted Site 7 Pyrus calleryana 'New Bradford' :: New Bradford Pear 347 1362 South Van Ness Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   09/12/2016 12:00:00 AM 3 3x3 Permit Number 777634 6007695.98109 2101723.729287 37.7513679161611 -122.416235842859 (37.7513679161611, -122.416235842859) 2 4 7 28859 19
113193 5172 DPW Maintained 1 Pyrus calleryana 'New Bradford' :: New Bradford Pear 347 338 Divisadero St 1 Sidewalk: Curb side : Cutout Tree DPW 1   10/10/2017 09:22:00 AM 3     6001789.9809 2109630.9174 37.7727452631602 -122.437225544322 (37.7727452631602, -122.437225544322) 15 5 11 29492 9
115126 97598 DPW Maintained 1 Pyrus calleryana 'New Bradford' :: New Bradford Pear 347 701X Divisadero St 2 Sidewalk: Curb side : Cutout Tree Private 2 DPW   3 4x3   6001578 2110798 37.7759377272515 -122.438042423333 (37.7759377272515, -122.438042423333) 15 5 11 29492 10
115472 50465 Permitted Site 7 Pyrus calleryana 'New Bradford' :: New Bradford Pear 347 3861 24th St 3 Sidewalk: Curb side : Cutout Tree Private 2   04/06/2016 12:00:00 AM 3   Permit Number 777923 6004067.99679008 2101865.11785477 37.7515514669378 -122.428791912654 (37.7515514669378, -122.428791912654) 2 4 5 28862 22
116298 90565 DPW Maintained 1 Pyrus calleryana 'New Bradford' :: New Bradford Pear 347 1798X Cabrillo St 1 Sidewalk: Curb side : Cutout Tree DPW 1   02/14/2008 12:00:00 AM 3 3x3   5990060.203422 2110619.647941 37.7747862779908 -122.477872000485 (37.7747862779908, -122.477872000485) 11 6 2 55 26
116397 28093 DPW Maintained 1 Pyrus calleryana 'New Bradford' :: New Bradford Pear 347 508 Divisadero St 1 Sidewalk: Curb side : Cutout Tree Private 2 DPW   3 3X3   6001722.1241568 2110151.9438084 37.7741720139963 -122.43749758605 (37.7741720139963, -122.43749758605) 15 5 11 29492 10
118387 24644 DPW Maintained 1 Pyrus calleryana 'New Bradford' :: New Bradford Pear 347 845 Divisadero St 1 Sidewalk: Curb side : Cutout Tree Private 2 DPW 12/17/2001 12:00:00 AM 3 3X3   6001484.9123945 2111282.0018462 37.7772613801811 -122.438399120791 (37.7772613801811, -122.438399120791) 15 5 11 29492 41
121334 108428 Permitted Site 7 Pyrus calleryana 'New Bradford' :: New Bradford Pear 347 3041 26th St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 12/22/2014 12:00:00 AM 3 3x3 Permit Number 773727 6009384.50414 2100992.21105 37.7494541307098 -122.410345064873 (37.7494541307098, -122.410345064873) 2 4 7 28859 19
121387 97597 DPW Maintained 1 Pyrus calleryana 'New Bradford' :: New Bradford Pear 347 701X Divisadero St 1 Sidewalk: Curb side : Cutout Tree Private 2 DPW   3 4x3   6001578 2110798 37.7759377272515 -122.438042423333 (37.7759377272515, -122.438042423333) 15 5 11 29492 10
121572 24643 DPW Maintained 1 Pyrus calleryana 'New Bradford' :: New Bradford Pear 347 801X Divisadero St 1 Sidewalk: Curb side : Cutout Tree Private 2 DPW 05/04/2010 12:00:00 AM 3 4x4   6001519.6000152 2111126.7877173 37.776837174254 -122.438268003206 (37.776837174254, -122.438268003206) 15 5 11 29492 10
122851 24629 DPW Maintained 1 Pyrus calleryana 'New Bradford' :: New Bradford Pear 347 616 Divisadero St 1 Sidewalk: Curb side : Cutout Tree Private 2 DPW 12/06/2006 12:00:00 AM 3 3x3   6001670.9205271 2110518.3359109 37.7751751237236 -122.437700953995 (37.7751751237236, -122.437700953995) 15 5 11 29492 10
123268 97586 DPW Maintained 1 Pyrus calleryana 'New Bradford' :: New Bradford Pear 347 285 Divisadero St 1 Sidewalk: Curb side : Cutout Tree Private 2 DPW   3     6001769 2109329 37.771915080469 -122.437276497302 (37.771915080469, -122.437276497302) 15 5 11 29492 9
123326 109794 Permitted Site 7 Pyrus calleryana 'New Bradford' :: New Bradford Pear 347 2083 16th Ave 3 Sidewalk: Curb side : Cutout Tree Private 2 FUF 03/03/2015 12:00:00 AM 3 3x3 Permit Number 775060 5991259.8 2101279.3 37.7492097184614 -122.47304110372 (37.7492097184614, -122.47304110372) 1 8 4 29491 12
125034 90573 DPW Maintained 1 Pyrus calleryana 'New Bradford' :: New Bradford Pear 347 1942 Cabrillo St 1 Sidewalk: Curb side : Cutout Tree DPW 1 Cleary Bros. Landscape 02/15/2008 12:00:00 AM 3 3x3   5989607.117119 2110603.204028 37.7747148208537 -122.479438098501 (37.7747148208537, -122.479438098501) 11 6 2 55 26
126080 59302 Permitted Site 7 Pyrus calleryana 'New Bradford' :: New Bradford Pear 347 52 06th St 1 Sidewalk: Curb side : Cutout Tree Private 2   07/23/2014 12:00:00 AM 3 5x5 Permit Number 773592 6009877.34953227 2112642.20965748 37.781469977428 -122.409462878047 (37.781469977428, -122.409462878047) 14 2 9 28853 34
127134 121213 Undocumented 4 Pyrus calleryana 'New Bradford' :: New Bradford Pear 347 428 South Van Ness Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     3 3x3   6007392 2107190 37.7663599374838 -122.417674448479 (37.7663599374838, -122.417674448479) 8 4 7 28853 19
133778 103334 DPW Maintained 1 Pyrus calleryana 'New Bradford' :: New Bradford Pear 347 223 Divisadero St 1 Sidewalk: Curb side : Cutout Tree DPW 1       3x3   6001827 2108903 37.7707486872476 -122.437045366963 (37.7707486872476, -122.437045366963) 15 5 11 29492 9
134381 5184 DPW Maintained 1 Pyrus calleryana 'New Bradford' :: New Bradford Pear 347 460X Divisadero St 1 Sidewalk: Curb side : Cutout Tree Private 2 DPW 04/21/2016 12:00:00 AM 3 3x3   6001745.349517 2109984.4298689 37.7737133829934 -122.437405247826 (37.7737133829934, -122.437405247826) 15 5 11 29492 10
136529 86022 DPW Maintained 1 Pyrus calleryana 'New Bradford' :: New Bradford Pear 347 1466 28th Ave 1 Sidewalk: Curb side : Cutout Tree DPW 1   02/19/2015 01:16:00 PM 3 3x3   5987457.7377 2105310.6049 37.7600577305468 -122.486484470473 (37.7600577305468, -122.486484470473) 1 8 3 56 35
136743 103335 DPW Maintained 1 Pyrus calleryana 'New Bradford' :: New Bradford Pear 347 211 Divisadero St 1 Sidewalk: Curb side : Cutout Tree DPW 1       3x3   6001839 2108819 37.7705187261581 -122.436997844091 (37.7705187261581, -122.436997844091) 15 5 11 29492 9
137106 121216 Undocumented 4 Pyrus calleryana 'New Bradford' :: New Bradford Pear 347 428 South Van Ness Ave 4 Sidewalk: Curb side : Cutout Tree Private 2     3 3x3   6007392 2107190 37.7663599374838 -122.417674448479 (37.7663599374838, -122.417674448479) 8 4 7 28853 19
137171 92280 Permitted Site 7 Pyrus calleryana 'New Bradford' :: New Bradford Pear 347 551 Vicente St 3 Sidewalk: Curb side : Cutout Tree Private 2   07/27/2009 12:00:00 AM   3x3 Permit Number 52729 5991264 2097696 37.739371142832 -122.47276534056 (37.739371142832, -122.47276534056) 1 8 4 29491 40
142607 97567 DPW Maintained 1 Pyrus calleryana 'New Bradford' :: New Bradford Pear 347 342 Divisadero St 1 Sidewalk: Curb side : Cutout Tree Private 2 DPW   3     6001791 2109583 37.7726137518496 -122.437218587592 (37.7726137518496, -122.437218587592) 15 5 11 29492 9
143008 5157 DPW Maintained 1 Pyrus calleryana 'New Bradford' :: New Bradford Pear 347 270 Divisadero St 2 Sidewalk: Curb side : Cutout Tree Private 2 DPW   0     6001849.8958745 2109240.8779842 37.7716777176824 -122.436990363143 (37.7716777176824, -122.436990363143) 15 5 11 29492 9
144085 91603 Permitted Site 7 Pyrus calleryana 'New Bradford' :: New Bradford Pear 347 780 South Van Ness Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   01/03/2017 10:07:00 AM 3 3x3 Permit Number 779025 6007508.236166 2105121.623309 37.7606871964477 -122.417125832202 (37.7606871964477, -122.417125832202) 2 4 7 28859 19
145204 213910 DPW Maintained 1 Pyrus calleryana 'New Bradford' :: New Bradford Pear 347 2083 16th Ave 2 Sidewalk: Curb side : Yard Tree Private 2     1 Width 3ft   5991275.49992 2101271.77221 37.7491899580666 -122.47298626481 (37.7491899580666, -122.47298626481) 1 8 4 29491 12
148140 94857 Permitted Site 7 Pyrus calleryana 'New Bradford' :: New Bradford Pear 347 2595 15th Ave   Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/24/2009 12:00:00 AM   3x3 Permit Number 52715 5991705.5 2097813.3 37.7397187667404 -122.471247387159 (37.7397187667404, -122.471247387159) 1 8 4 29491 40
151963 97563 DPW Maintained 1 Pyrus calleryana 'New Bradford' :: New Bradford Pear 347 250 Divisadero St 1 Sidewalk: Curb side : Cutout Tree Private 2 DPW 09/21/2015 12:00:00 AM 3 5x5   6001845 2109086 37.7712521829373 -122.436996208247 (37.7712521829373, -122.436996208247) 15 5 11 29492 9
152268 97600 DPW Maintained 1 Pyrus calleryana 'New Bradford' :: New Bradford Pear 347 857 Divisadero St 2 Sidewalk: Curb side : Cutout Tree Private 2 DPW   3 3x3   6001483 2111323 37.7773738419974 -122.438408674388 (37.7773738419974, -122.438408674388) 15 5 11 29492 41
153235 97576 DPW Maintained 1 Pyrus calleryana 'New Bradford' :: New Bradford Pear 347 600 Divisadero St 1 Sidewalk: Curb side : Cutout Tree DPW 1   04/03/2013 12:00:00 AM 3 3x3   6001656 2110448 37.7749811505558 -122.437747528771 (37.7749811505558, -122.437747528771) 15 5 11 29492 10
154515 97580 DPW Maintained 1 Pyrus calleryana 'New Bradford' :: New Bradford Pear 347 700X Divisadero St 1 Sidewalk: Curb side : Cutout Tree Private 2 DPW   3 3x3   6001615.5 2110795.9 37.7759340937147 -122.437912550894 (37.7759340937147, -122.437912550894) 15 5 11 29492 10
155503 197039 DPW Maintained 1 Pyrus calleryana 'New Bradford' :: New Bradford Pear 347 1751 Armstrong Ave 20 Sidewalk: Curb side : Yard Tree Private 2     6 Width 4ft   6013908.23302 2092796.76107 37.7272036734968 -122.394128093333 (37.7272036734968, -122.394128093333) 10 3 8 58 1
155570 91636 DPW Maintained 1 Pyrus calleryana 'New Bradford' :: New Bradford Pear 347 1515 South Van Ness Ave 4 Sidewalk: Curb side : Cutout Tree DPW 1   10/05/2016 12:00:00 AM 3 3x3   6007819 2100813 37.7488741754589 -122.415745948384 (37.7488741754589, -122.415745948384) 2 4 7 28859 19
159725 97587 DPW Maintained 1 Pyrus calleryana 'New Bradford' :: New Bradford Pear 347 319 Divisadero St 1 Sidewalk: Curb side : Cutout Tree Private 2 DPW   3     6001745 2109492 37.772361273527 -122.437371188758 (37.772361273527, -122.437371188758) 15 5 11 29492 9
160351 97570 DPW Maintained 1 Pyrus calleryana 'New Bradford' :: New Bradford Pear 347 546 Divisadero St 1 Sidewalk: Curb side : Cutout Tree Private 2 DPW   3     6001754.3 2110345 37.7747039272721 -122.437400111383 (37.7747039272721, -122.437400111383) 15 5 11 29492 10
163025 24637 DPW Maintained 1 Pyrus calleryana 'New Bradford' :: New Bradford Pear 347 425 Divisadero St 1 Sidewalk: Curb side : Cutout Tree Private 2 DPW 10/25/2011 12:00:00 AM 3 3X3   6001690.3813095 2109822.1283023 37.773264618286 -122.437583765683 (37.773264618286, -122.437583765683) 15 5 11 29492 10
164267 97594 DPW Maintained 1 Pyrus calleryana 'New Bradford' :: New Bradford Pear 347 601X Divisadero St 1 Sidewalk: Curb side : Cutout Tree Private 2 DPW   3 3x3   6001572.2 2110512.7 37.7751540352305 -122.438042045969 (37.7751540352305, -122.438042045969) 15 5 11 29492 10
165578 90887 DPW Maintained 1 Pyrus calleryana 'New Bradford' :: New Bradford Pear 347 1643 Cabrillo St 1 Sidewalk: Curb side : Cutout Tree DPW 1   02/20/2008 12:00:00 AM 3 3x3   5990539.067556 2110597.000965 37.7747518763368 -122.476213873596 (37.7747518763368, -122.476213873596) 11 6 2 55 26
166604 97603 DPW Maintained 1 Pyrus calleryana 'New Bradford' :: New Bradford Pear 347 823 Divisadero St 1 Sidewalk: Curb side : Cutout Tree Private 2 DPW   3 3x3   6001500 2111204 37.7770480649397 -122.438341338421 (37.7770480649397, -122.438341338421) 15 5 11 29492 41
171741 97582 DPW Maintained 1 Pyrus calleryana 'New Bradford' :: New Bradford Pear 347 744 Divisadero St 1 Sidewalk: Curb side : Cutout Tree Private 2 DPW   3 3x3   6001602 2110950 37.7763564458951 -122.437970291277 (37.7763564458951, -122.437970291277) 15 5 11 29492 10
171919 91592 DPW Maintained 1 Pyrus calleryana 'New Bradford' :: New Bradford Pear 347 590 South Van Ness Ave   Sidewalk: Curb side : Cutout Tree DPW 1   03/01/2007 12:00:00 AM 5 3x3 Permit Number 776895 6007446.606402 2106234.50211 37.7637394360724 -122.417417852739 (37.7637394360724, -122.417417852739) 8 4 7 28859 19
173539 24636 DPW Maintained 1 Pyrus calleryana 'New Bradford' :: New Bradford Pear 347 443 Divisadero St 3 Sidewalk: Curb side : Cutout Tree Private 2 DPW 06/17/2014 12:00:00 AM 3 3X4   6001673.68932 2109984.60324 37.7737097848233 -122.437653143592 (37.7737097848233, -122.437653143592) 15 5 11 29492 10
174175 83157 Permitted Site 7 Pyrus calleryana 'New Bradford' :: New Bradford Pear 347 1539X 20th St 1 Sidewalk: Curb side : Cutout Tree Private 2   07/02/2009 12:00:00 AM   3x3 Permit Number 52377 6013275.21379985 2104716.05721549 37.7598963404579 -122.397151874959 (37.7598963404579, -122.397151874959) 10 3 8 28856 29
181835 90889 DPW Maintained 1 Pyrus calleryana 'New Bradford' :: New Bradford Pear 347 1643 Cabrillo St 3 Sidewalk: Curb side : Cutout Tree DPW 1   02/20/2008 12:00:00 AM 3 3x3   5990539.067556 2110597.000965 37.7747518763368 -122.476213873596 (37.7747518763368, -122.476213873596) 11 6 2 55 26
183615 90881 DPW Maintained 1 Pyrus calleryana 'New Bradford' :: New Bradford Pear 347 1855 Cabrillo St 1 Sidewalk: Curb side : Cutout Tree DPW 1 Cleary Bros. Landscape 02/20/2008 12:00:00 AM 3 3x3   5989882.489844 2110573.171827 37.7746483516209 -122.478483342296 (37.7746483516209, -122.478483342296) 11 6 2 55 26
185372 97589 DPW Maintained 1 Pyrus calleryana 'New Bradford' :: New Bradford Pear 347 563 Divisadero St 1 Sidewalk: Curb side : Cutout Tree DPW 1   05/04/2010 12:00:00 AM 3 3x3   6001625.1 2110320.9 37.7746304087527 -122.43784531296 (37.7746304087527, -122.43784531296) 15 5 11 29492 10
191427 97568 DPW Maintained 1 Pyrus calleryana 'New Bradford' :: New Bradford Pear 347 500 Divisadero St 1 Sidewalk: Curb side : Cutout Tree Private 2 DPW   3     6001703 2110108 37.7740502679918 -122.437560592174 (37.7740502679918, -122.437560592174) 15 5 11 29492 10
193612 24627 DPW Maintained 1 Pyrus calleryana 'New Bradford' :: New Bradford Pear 347 444 Divisadero St 3 Sidewalk: Curb side : Cutout Tree Private 2 DPW 12/06/2006 12:00:00 AM 3 3X4   6001753.1685929 2109931.6605583 37.7735689361616 -122.437374421097 (37.7735689361616, -122.437374421097) 15 5 11 29492 10

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