Data source: data.sfgov.org
This data as json, CSV (advanced)
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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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) |
JSON shape: default, array, newline-delimited
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");