Data source: data.sfgov.org
This data as json, CSV (advanced)
Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord ▼ | YCoord | Latitude | Longitude | Location |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
89242 | 89242 | 50787 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 6900 Geary Blvd | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/04/2004 12:00:00 AM | Permit Number 47313 | 5985644.2903515 | 2112526.34575893 | 37.7797642444003 | -122.493287836243 | (37.7797642444003, -122.493287836243) | |||
125717 | 125717 | 50788 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 6900 Geary Blvd | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/04/2004 12:00:00 AM | Permit Number 47313 | 5985644.2903515 | 2112526.34575893 | 37.7797642444003 | -122.493287836243 | (37.7797642444003, -122.493287836243) | |||
54862 | 54862 | 183412 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 2350 Wawona St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 0ft | 5985653.7417 | 2097035.0769 | 37.7372300576086 | -122.492114208587 | (37.7372300576086, -122.492114208587) | |||
128771 | 128771 | 102810 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 490 33rd Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/24/2013 12:00:00 AM | 3 | 3x3 | Permit Number 770137 | 5985656.77163 | 2112663.0068900003 | 37.780140206640205 | -122.493254729507 | (37.7801402066402, -122.493254729507) | |
104917 | 104917 | 102809 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 490 33rd Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3x3 | Permit Number 33567 | 5985658.04889 | 2112631.72376 | 37.780054386858794 | -122.493248005621 | (37.7800543868588, -122.493248005621) | ||
153072 | 153072 | 183411 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 2350 Wawona St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 0ft | 5985672.7267 | 2097039.7501 | 37.737243998747 | -122.49204891364201 | (37.737243998747, -122.492048913642) | |||
183024 | 183024 | 185612 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 2101 34th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | Width 0ft | 5985702.4651 | 2100891.7117 | 37.7478221885491 | -122.492229646849 | (37.7478221885491, -122.492229646849) | |||
136915 | 136915 | 95445 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 2201 34th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/01/2011 12:00:00 AM | 2 | 3x3 | Permit Number 767307 | 5985726.3556 | 2100198.6842 | 37.7459207192562 | -122.492096016775 | (37.7459207192562, -122.492096016775) |
151451 | 151451 | 95446 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 2205 34th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/01/2011 12:00:00 AM | 2 | 3x3 | Permit Number 767308 | 5985726.3556 | 2100168.8125 | 37.7458386996409 | -122.49209381774901 | (37.7458386996409, -122.492093817749) |
62988 | 62988 | 92393 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 2223 34th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/29/2009 12:00:00 AM | 2 | 3x3 | Permit Number 52798 | 5985729.7695 | 2100081.3311 | 37.745598698912204 | -122.49207557319401 | (37.7455986989122, -122.492075573194) |
79803 | 79803 | 43861 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 2345 Wawona St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/27/2000 12:00:00 AM | Permit Number 43481 | 5985730.68059538 | 2097009.14058612 | 37.7371633406591 | -122.491846290454 | (37.7371633406591, -122.491846290454) | ||
111978 | 111978 | 43863 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 2345 Wawona St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/27/2000 12:00:00 AM | Permit Number 43481 | 5985730.68059538 | 2097009.14058612 | 37.7371633406591 | -122.491846290454 | (37.7371633406591, -122.491846290454) | ||
116072 | 116072 | 43862 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 2345 Wawona St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/27/2000 12:00:00 AM | Permit Number 43481 | 5985730.68059538 | 2097009.14058612 | 37.7371633406591 | -122.491846290454 | (37.7371633406591, -122.491846290454) | ||
46911 | 46911 | 95592 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 2210 34th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/01/2011 12:00:00 AM | 1 | 3x3 | Permit Number 767309 | 5985769.8829 | 2100165.3986 | 37.7458318703149 | -122.491943057318 | (37.7458318703149, -122.491943057318) |
74407 | 74407 | 95447 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 2210 34th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/01/2011 12:00:00 AM | 1 | 3x3 | Permit Number 767309 | 5985770.3096 | 2100149.6093 | 37.745788542103206 | -122.49194041962099 | (37.7457885421032, -122.491940419621) |
67347 | 67347 | 92397 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 2290 34th Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/29/2009 12:00:00 AM | 2 | 3x3 | Permit Number 52799 | 5985786.098999999 | 2099670.3819 | 37.7444736358369 | -122.491850548624 | (37.7444736358369, -122.491850548624) |
52716 | 52716 | 92396 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 2290 34th Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/29/2009 12:00:00 AM | 2 | 3x3 | Permit Number 52799 | 5985787.3792 | 2099657.153 | 37.7444373876676 | -122.491845148303 | (37.7444373876676, -122.491845148303) |
69989 | 69989 | 92394 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 2290 34th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/29/2009 12:00:00 AM | 2 | 3x3 | Permit Number 52799 | 5985787.8059 | 2099633.6824 | 37.7443729686632 | -122.491841945332 | (37.7443729686632, -122.491841945332) |
137052 | 137052 | 92395 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 2290 34th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/29/2009 12:00:00 AM | 2 | 3x3 | Permit Number 52799 | 5985787.8059 | 2099646.4846 | 37.7444081200554 | -122.491842887636 | (37.7444081200554, -122.491842887636) |
188651 | 188651 | 185046 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 2767 34th Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 2 | Width 0ft | 5985833.5409 | 2096575.126 | 37.7359776633696 | -122.491458724203 | (37.7359776633696, -122.491458724203) | |||
10899 | 10899 | 92314 | Significant Tree 6 | Prunus serrulata :: Ornamental Cherry 35 | 2783 34th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/18/2008 12:00:00 AM | 3 | 3x3 | 5985837.7861 | 2096464.2212 | 37.7356733962807 | -122.491435886509 | (37.7356733962807, -122.491435886509) | |
10597 | 10597 | 92315 | Significant Tree 6 | Prunus serrulata :: Ornamental Cherry 35 | 2783 34th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/18/2008 12:00:00 AM | 3 | 3x3 | 5985839.9086 | 2096474.3035 | 37.73570120363421 | -122.491429290175 | (37.7357012036342, -122.491429290175) | |
13114 | 13114 | 92316 | Significant Tree 6 | Prunus serrulata :: Ornamental Cherry 35 | 2787 34th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/18/2008 12:00:00 AM | 3 | 3x3 | 5985840.4393 | 2096424.4229 | 37.7355642757438 | -122.49142378511002 | (37.7355642757438, -122.49142378511) | |
12690 | 12690 | 92317 | Significant Tree 6 | Prunus serrulata :: Ornamental Cherry 35 | 2787 34th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/18/2008 12:00:00 AM | 3 | 3x3 | 5985840.9699 | 2096433.9745 | 37.7355905329114 | -122.491422653463 | (37.7355905329114, -122.491422653463) | |
12500 | 12500 | 92318 | Significant Tree 6 | Prunus serrulata :: Ornamental Cherry 35 | 2787 34th Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/18/2008 12:00:00 AM | 3 | 3x3 | 5985842.0312 | 2096446.1793 | 37.7356241060746 | -122.49141988222999 | (37.7356241060746, -122.49141988223) | |
166127 | 166127 | 185265 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 2616 34th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 0ft | 5985852.1135 | 2097401.8704 | 37.7382487690483 | -122.491455345913 | (37.7382487690483, -122.491455345913) | |||
10461 | 10461 | 92319 | Significant Tree 6 | Prunus serrulata :: Ornamental Cherry 35 | 2788 34th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/18/2008 12:00:00 AM | 3 | 3x3 | 5985889.2586 | 2096423.8922 | 37.7355656712712 | -122.491254961509 | (37.7355656712712, -122.491254961509) | |
10790 | 10790 | 80073 | Significant Tree 6 | Prunus serrulata :: Ornamental Cherry 35 | 2788 34th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/18/2008 12:00:00 AM | 3 | 5985889.2586 | 2096432.3825 | 37.735588983385 | -122.49125558617901 | (37.735588983385, -122.491255586179) | ||
59178 | 59178 | 182739 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 1755 33rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 0ft | 5985933.2204 | 2103292.5347 | 37.7544276818477 | -122.491608417213 | (37.7544276818477, -122.491608417213) | |||
156078 | 156078 | 92366 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 1915 33rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/28/2009 12:00:00 AM | 1 | 3x3 | Permit Number 52779 | 5985969.6964 | 2102174.4618 | 37.7513598906592 | -122.49139998707199 | (37.7513598906592, -122.491399987072) |
73741 | 73741 | 37222 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 2075 33rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/12/1998 12:00:00 AM | 5 | Permit Number 39786 | 5986006.8021 | 2101124.4403 | 37.748478985005896 | -122.49119440423401 | (37.7484789850059, -122.491194404234) | |
180063 | 180063 | 83723 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 2215 33rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 2 | 5986042.1421 | 2100161.1312 | 37.7458360633129 | -122.491001322638 | (37.7458360633129, -122.491001322638) | |||
24861 | 24861 | 182367 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 1511 32nd Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | Width 0ft | 5986186.5787 | 2104935.6262 | 37.758953963431 | -122.49085314669901 | (37.758953963431, -122.490853146699) | |||
30623 | 30623 | 182368 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 1511 32nd Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 0ft | 5986188.3183 | 2104920.5503 | 37.758912670790004 | -122.490846021107 | (37.75891267079, -122.490846021107) | |||
33475 | 33475 | 37204 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 1575 32nd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/12/1998 12:00:00 AM | 2 | Permit Number 39771 | 5986202.8143 | 2104523.3582 | 37.75782293745029 | -122.49076666265499 | (37.7578229374503, -122.490766662655) | |
151321 | 151321 | 84041 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 1514 32nd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/23/2009 12:00:00 AM | 1 | 3x3 | Permit Number 52690 | 5986231.2266 | 2104899.676 | 37.758857862275704 | -122.49069609034099 | (37.7588578622757, -122.490696090341) | |
47132 | 47132 | 182844 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 1819 32nd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 0ft | 5986260.4974 | 2102849.4662 | 37.7532302577495 | -122.49044403080799 | (37.7532302577495, -122.490444030808) | |||
66440 | 66440 | 182858 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 1826 32nd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 0ft | 5986304.0542 | 2102796.2301 | 37.7530866298604 | -122.49028948878201 | (37.7530866298604, -122.490289488782) | |||
44345 | 44345 | 181814 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 2169 Santiago St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 0ft | 5986311.3611 | 2099566.4282 | 37.7442188936716 | -122.49002668010799 | (37.7442188936716, -122.490026680108) | |||
107031 | 107031 | 58127 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 1291 31st Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/05/1990 12:00:00 AM | Permit Number 29453 | 5986440.58306347 | 2106473.88273378 | 37.763192426611795 | -122.490087838111 | (37.7631924266118, -122.490087838111) | ||
32121 | 32121 | 66333 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 1291 31st Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/05/1990 12:00:00 AM | 6 | Permit Number 29454 | 5986445.8362 | 2106470.4022 | 37.763183176794705 | -122.490069413492 | (37.7631831767947, -122.490069413492) | |
167537 | 167537 | 183513 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 2538 32nd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 0ft | 5986470.4078 | 2097964.8461 | 37.739830662789004 | -122.489359001455 | (37.739830662789, -122.489359001455) | |||
133718 | 133718 | 182549 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 1408 31st Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 0ft | 5986517.2893 | 2105614.7843 | 37.7608380588456 | -122.489759356723 | (37.7608380588456, -122.489759356723) | |||
37082 | 37082 | 182550 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 1408 31st Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 0ft | 5986517.6568 | 2105641.9803 | 37.760912753017394 | -122.48976008582899 | (37.7609127530174, -122.489760085829) | |||
74048 | 74048 | 182548 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 1408 31st Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 0ft | 5986518.7594 | 2105601.9213 | 37.760802826429796 | -122.489753326371 | (37.7608028264298, -122.489753326371) | |||
179376 | 179376 | 182553 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 2545 Judah St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 0ft | 5986583.8092 | 2105694.5347 | 37.7610609151296 | -122.48953516150299 | (37.7610609151296, -122.489535161503) | |||
135959 | 135959 | 95525 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 2925 Lincoln Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/01/2011 12:00:00 AM | 2 | 3x3 | Permit Number 767317 | 5986606.408 | 2107060.1496 | 37.764811835149295 | -122.489557426261 | (37.7648118351493, -122.489557426261) |
51079 | 51079 | 182554 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 2535 Judah St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 0ft | 5986607.6975 | 2105696.3722 | 37.7610673549786 | -122.489452678447 | (37.7610673549786, -122.489452678447) | |||
25020 | 25020 | 182555 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 2535 Judah St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 0ft | 5986616.8854 | 2105696.0047 | 37.761066882292 | -122.489420874881 | (37.761066882292, -122.489420874881) | |||
44471 | 44471 | 182556 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 2535 Judah St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 0ft | 5986624.9706 | 2105696.7397 | 37.7610693723866 | -122.48939296609501 | (37.7610693723866, -122.489392966095) | |||
186001 | 186001 | 95591 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 2925 Lincoln Way | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/01/2011 12:00:00 AM | 2 | 3x3 | Permit Number 767317 | 5986627.6602 | 2107061.3303 | 37.7648163177268 | -122.48948400821001 | (37.7648163177268, -122.48948400821) |
164556 | 164556 | 92332 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 2178 31st Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/28/2009 12:00:00 AM | 1 | 3x3 | Permit Number 52764 | 5986694.1348 | 2100449.0089 | 37.746664568430795 | -122.488768011117 | (37.7466645684308, -122.488768011117) |
136725 | 136725 | 92333 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 2182 31st Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/28/2009 12:00:00 AM | 2 | 3x3 | Permit Number 52765 | 5986695.3951 | 2100425.9019 | 37.7466011963621 | -122.488761954977 | (37.7466011963621, -122.488761954977) |
29283 | 29283 | 95438 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 2186 31st Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/01/2011 12:00:00 AM | 1 | 3x3 | Permit Number 767300 | 5986698.9662 | 2100381.1584 | 37.746478551124504 | -122.48874631833598 | (37.7464785511245, -122.488746318336) |
35810 | 35810 | 92326 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 1343 30th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/28/2009 12:00:00 AM | 3 | 3x3 | Permit Number 52758 | 5986769.8307 | 2106099.7914 | 37.7621844965801 | -122.488921594092 | (37.7621844965801, -122.488921594092) |
179211 | 179211 | 92327 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 1347 30th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/28/2009 12:00:00 AM | 3 | 3x3 | Permit Number 52759 | 5986769.8307 | 2106074.1568 | 37.7621141110413 | -122.488919709577 | (37.7621141110413, -122.488919709577) |
51429 | 51429 | 69307 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 1522 30th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/16/1994 12:00:00 AM | 2 | Permit Number 33386 | 5986858.656 | 2104872.1171 | 37.758818824109 | -122.48852415134701 | (37.758818824109, -122.488524151347) | |
146393 | 146393 | 81679 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 1942 Vicente St | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | FUF 1 | 07/31/2009 12:00:00 AM | 2 | 3x3 | Permit Number 52863 | 5986874.2463 | 2097598.6809 | 37.738848836056 | -122.487935819213 | (37.738848836056, -122.487935819213) |
166830 | 166830 | 181326 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 2020 Taraval St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 0ft | 5986900.7227 | 2098966.9139 | 37.742607185371206 | -122.48794478148399 | (37.7426071853712, -122.487944781484) | |||
12005 | 12005 | 93421 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 2014 Taraval St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/20/2009 12:00:00 AM | 3 | 3x3 | 5986933.5496 | 2098966.2371 | 37.7426072419271 | -122.487831227416 | (37.7426072419271, -122.487831227416) | ||
68429 | 68429 | 185590 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 2086 30th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 0ft | 5986989.5241 | 2101082.1958 | 37.748420363683294 | -122.487793111063 | (37.7484203636833, -122.487793111063) | |||
161319 | 161319 | 181747 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 1231 29th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 0ft | 5987052.1054 | 2106842.9351 | 37.7642414343948 | -122.48799993277099 | (37.7642414343948, -122.487999932771) | |||
11411 | 11411 | 93457 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 1951 Taraval St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/23/2009 12:00:00 AM | 3 | 3x3 | 5987093.9615 | 2098905.6596 | 37.74245026783021 | -122.487272128606 | (37.7424502678302, -122.487272128606) | ||
52984 | 52984 | 69922 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 1479 29th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/17/1990 12:00:00 AM | 6 | 5987109.7204 | 2105224.4854 | 37.7598009776001 | -122.487681752733 | (37.7598009776001, -122.487681752733) | ||
12106 | 12106 | 93458 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 1951 Taraval St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/26/2009 12:00:00 AM | 3 | 3x3 | 5987115.9589 | 2098905.998 | 37.7424524797237 | -122.487196094011 | (37.7424524797237, -122.487196094011) | ||
46491 | 46491 | 38115 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 1342 29th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/28/2003 12:00:00 AM | 5 | Permit Number 40279 | 5987120.6367 | 2106124.4711 | 37.7622727278914 | -122.487710118761 | (37.7622727278914, -122.487710118761) | |
76635 | 76635 | 38116 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 1346 29th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/13/1998 12:00:00 AM | 4 | Permit Number 40280 | 5987121.6044 | 2106101.731 | 37.7622103462776 | -122.487705101187 | (37.7622103462776, -122.487705101187) | |
99434 | 99434 | 51238 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 1342 29th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/17/2004 12:00:00 AM | Permit Number 47609 | 5987125.87683066 | 2106129.95545111 | 37.762288092049296 | -122.487692398291 | (37.7622880920493, -122.487692398291) | |||
24750 | 24750 | 182725 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 1734 29th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 0ft | 5987217.2069 | 2103447.5916 | 37.7549283802803 | -122.487179505586 | (37.7549283802803, -122.487179505586) | |||
99390 | 99390 | 87844 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 536 28th Ave | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/09/2008 12:00:00 AM | 3x3 | Permit Number 50751 | 5987246.0 | 2112270.7 | 37.7791558680057 | -122.487728106826 | (37.7791558680057, -122.487728106826) | |||
13001 | 13001 | 93459 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 1901X Taraval St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/26/2009 12:00:00 AM | 3 | 3x3 | 5987294.6457 | 2098913.1049 | 37.742482411351396 | -122.486578778111 | (37.7424824113514, -122.486578778111) | ||
92238 | 92238 | 104081 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 2610 Lake St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5987336.5 | 2114673.6 | 37.7857588250819 | -122.487591604742 | (37.7857588250819, -122.487591604742) | |||||
56036 | 56036 | 42854 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 2471 29th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/03/2000 12:00:00 AM | 6 | Permit Number 42783 | 5987340.671 | 2098461.3118 | 37.74124459004229 | -122.486386476099 | (37.7412445900423, -122.486386476099) | |
12156 | 12156 | 86038 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 1261 28th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/12/2007 12:00:00 AM | 3 | 3x3 | 5987366.2761 | 2106684.0781 | 37.7638235791025 | -122.486901653076 | (37.7638235791025, -122.486901653076) | ||
121675 | 121675 | 53179 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 2610@ 27th Ave Lake St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/21/2008 12:00:00 AM | 3x3 | Permit Number 51476 | 5987391.86463584 | 2114656.62979524 | 37.785715458645704 | -122.487398814258 | (37.7857154586457, -122.487398814258) | ||
80735 | 80735 | 48847 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 211@ Lake St 27th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/07/2002 12:00:00 AM | Permit Number 46061 | 5987400.97577089 | 2114545.21286522 | 37.785410070991205 | -122.487359105809 | (37.7854100709912, -122.487359105809) | |||
61952 | 61952 | 44806 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 1284 28th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/12/2001 12:00:00 AM | 2 | Permit Number 43901 | 5987417.062999999 | 2106562.4256 | 37.7634925157287 | -122.486717065387 | (37.7634925157287, -122.486717065387) | |
11635 | 11635 | 93417 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 1850 Taraval St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/17/2009 12:00:00 AM | 3 | 3x3 | 5987422.9075 | 2098985.1887 | 37.7426878104075 | -122.486140583017 | (37.7426878104075, -122.486140583017) | ||
10775 | 10775 | 93460 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 1855X Taraval St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/26/2009 12:00:00 AM | 3 | 3x3 | 5987430.6912 | 2098918.5196 | 37.7425052083655 | -122.486108776631 | (37.7425052083655, -122.486108776631) | ||
13104 | 13104 | 93461 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 1855X Taraval St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/26/2009 12:00:00 AM | 3 | 3x3 | 5987454.3807 | 2098917.8428 | 37.7425047306499 | -122.48602681673599 | (37.7425047306499, -122.486026816736) | ||
188674 | 188674 | 181914 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 1830 Taraval St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 0ft | 5987457.4265 | 2098985.8656 | 37.742691680738 | -122.48602127745 | (37.742691680738, -122.48602127745) | |||
12811 | 12811 | 86059 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 1821 28th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/12/2007 12:00:00 AM | 3 | 3x3 | 5987499.4352 | 2102865.9001 | 37.7533476658044 | -122.486160793796 | (37.7533476658044, -122.486160793796) | ||
12806 | 12806 | 86011 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 1662 28th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/12/2007 12:00:00 AM | 3 | 3x3 | 5987503.8484 | 2103979.9523 | 37.7564068087083 | -122.486227310645 | (37.7564068087083, -122.486227310645) | ||
10767 | 10767 | 86061 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 1877 28th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/12/2007 12:00:00 AM | 3 | 3x3 | 5987508.8564 | 2102515.9989 | 37.752387480581206 | -122.48610253041201 | (37.7523874805812, -122.486102530412) | ||
11720 | 11720 | 86062 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 1885 28th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/12/2007 12:00:00 AM | 3 | 3x3 | 5987513.2384 | 2102452.8984 | 37.7522144789944 | -122.486082745357 | (37.7522144789944, -122.486082745357) | ||
11725 | 11725 | 86063 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 1907 28th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/12/2007 12:00:00 AM | 3 | 3x3 | 5987519.4966 | 2102278.4539 | 37.7517358660999 | -122.48604829983401 | (37.7517358660999, -122.486048299834) | ||
13087 | 13087 | 86010 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 1706 28th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/12/2007 12:00:00 AM | 3 | 3x3 | 5987520.2506 | 2103632.0177 | 37.7554524306337 | -122.486145046236 | (37.7554524306337, -122.486145046236) | ||
10502 | 10502 | 86009 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 1722 28th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/12/2007 12:00:00 AM | 3 | 3x3 | 5987523.9067 | 2103537.3673 | 37.755192759360106 | -122.486125454711 | (37.7551927593601, -122.486125454711) | ||
58689 | 58689 | 53262 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 1742 28th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/28/1969 12:00:00 AM | 2 | Permit Number 6152 | 5987525.5316 | 2103414.2811 | 37.7548548926849 | -122.486110800407 | (37.7548548926849, -122.486110800407) | ||
10467 | 10467 | 86008 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 1726 28th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/12/2007 12:00:00 AM | 3 | 3x3 | 5987525.9378 | 2103513.8062 | 37.7551281853344 | -122.48611670118099 | (37.7551281853344, -122.486116701181) | ||
12471 | 12471 | 86064 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 1931 28th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/12/2007 12:00:00 AM | 3 | 3x3 | 5987527.1305 | 2102126.3201 | 37.7513185925094 | -122.486010735012 | (37.7513185925094, -122.486010735012) | ||
10754 | 10754 | 86066 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 1959 28th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/12/2007 12:00:00 AM | 3 | 3x3 | 5987532.0381 | 2101952.375 | 37.7508412720312 | -122.48598099746 | (37.7508412720312, -122.48598099746) | ||
12356 | 12356 | 86067 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 1963 28th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/12/2007 12:00:00 AM | 3 | 3x3 | 5987532.5834 | 2101927.292 | 37.7507724326317 | -122.485977270831 | (37.7507724326317, -122.485977270831) | ||
11573 | 11573 | 86006 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 1766 28th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/12/2007 12:00:00 AM | 3 | 3x3 | 5987532.8436 | 2103268.4464 | 37.7544548962014 | -122.48607480922199 | (37.7544548962014, -122.486074809222) | ||
11141 | 11141 | 86005 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 1770 28th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/12/2007 12:00:00 AM | 3 | 3x3 | 5987533.6561 | 2103240.4169 | 37.754377982127295 | -122.486069942013 | (37.7543779821273, -122.486069942013) | ||
11594 | 11594 | 86068 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 1975 28th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/12/2007 12:00:00 AM | 3 | 3x3 | 5987534.2192 | 2101849.8619 | 37.7505599257071 | -122.485965931252 | (37.7505599257071, -122.485965931252) | ||
10619 | 10619 | 86004 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 1774 28th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/12/2007 12:00:00 AM | 3 | 3x3 | 5987534.4685 | 2103215.2309 | 37.7543088755282 | -122.486065283877 | (37.7543088755282, -122.486065283877) | ||
12786 | 12786 | 86003 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 1786 28th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/12/2007 12:00:00 AM | 3 | 3x3 | 5987537.7183 | 2103137.642 | 37.7540960267794 | -122.486048350317 | (37.7540960267794, -122.486048350317) | ||
10736 | 10736 | 86002 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 1824 28th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/12/2007 12:00:00 AM | 3 | 3x3 | 5987543.255 | 2102835.2262 | 37.7532659973414 | -122.486007006329 | (37.7532659973414, -122.486007006329) | ||
11053 | 11053 | 86001 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 1828 28th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/12/2007 12:00:00 AM | 3 | 3x3 | 5987544.5696 | 2102809.3725 | 37.753195086669294 | -122.486000562627 | (37.7531950866693, -122.486000562627) |
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");