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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
185918 | 185918 | 248310 | Undocumented 2 | :: 54 | 1361 Waller St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 5999210.5699 | 2108358.152 | 37.7691036064762 | -122.446056416567 | (37.7691036064762, -122.446056416567) | |||
167154 | 167154 | 181693 | Undocumented 2 | :: 54 | 1367 35th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 5985223.881 | 2105891.4732 | 37.761522166301106 | -122.494253012254 | (37.7615221663011, -122.494253012254) | |||
57516 | 57516 | 183251 | Undocumented 2 | :: 54 | 1370 La Playa | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 5980924.7337 | 2105743.1516 | 37.7608623989944 | -122.50911071225599 | (37.7608623989944, -122.509110712256) | |||
74359 | 74359 | 200626 | Undocumented 2 | :: 54 | 1370 Newcomb Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 6016343.0854 | 2094895.2737 | 37.7331008048792 | -122.38585695867201 | (37.7331008048792, -122.385856958672) | |||
109430 | 109430 | 181696 | Undocumented 2 | :: 54 | 1375 35th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 5985223.881 | 2105845.6432 | 37.7613963299035 | -122.49424963408701 | (37.7613963299035, -122.494249634087) | |||
151530 | 151530 | 183258 | Undocumented 2 | :: 54 | 1386 La Playa | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 5980928.6203 | 2105658.3536 | 37.760629797231395 | -122.50909097348301 | (37.7606297972314, -122.509090973483) | |||
37163 | 37163 | 140497 | Undocumented 2 | :: 54 | 1390 GOLDEN GATE AVE | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 6002947.4227 | 2112049.4711 | 37.7794517381965 | -122.433394688734 | (37.7794517381965, -122.433394688734) | |||
55449 | 55449 | 183888 | Undocumented 2 | :: 54 | 1390 Quintara St | 4 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | Width 0ft | 5988941.521000001 | 2101013.106 | 37.7483443270077 | -122.48103816738501 | (37.7483443270077, -122.481038167385) | |||
63252 | 63252 | 183894 | Undocumented 2 | :: 54 | 1390 Quintara St | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 0ft | 5989083.3554 | 2101019.0158 | 37.7483687977509 | -122.480548145718 | (37.7483687977509, -122.480548145718) | |||
65435 | 65435 | 183890 | Undocumented 2 | :: 54 | 1390 Quintara St | 6 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | Width 0ft | 5988977.7676 | 2101017.0459 | 37.748357251925604 | -122.480913117409 | (37.7483572519256, -122.480913117409) | |||
133057 | 133057 | 183886 | Undocumented 2 | :: 54 | 1390 Quintara St | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | Width 0ft | 5988900.5466 | 2101013.106 | 37.7483419450285 | -122.48117985419901 | (37.7483419450285, -122.481179854199) | |||
151138 | 151138 | 183895 | Undocumented 2 | :: 54 | 1390 Quintara St | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 0ft | 5989106.2065 | 2101019.8038 | 37.74837228939921 | -122.480469185732 | (37.7483722893992, -122.480469185732) | |||
166129 | 166129 | 183896 | Undocumented 2 | :: 54 | 1390 Quintara St | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 0ft | 5989127.4817 | 2101020.5917 | 37.7483756891409 | -122.48039567509501 | (37.7483756891409, -122.480395675095) | |||
167807 | 167807 | 183887 | Undocumented 2 | :: 54 | 1390 Quintara St | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | Width 0ft | 5988922.6098 | 2101013.894 | 37.748345391297 | -122.481103618778 | (37.748345391297, -122.481103618778) | |||
169919 | 169919 | 183889 | Undocumented 2 | :: 54 | 1390 Quintara St | 5 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | Width 0ft | 5988959.6443 | 2101014.682 | 37.748349707800706 | -122.480975613562 | (37.7483497078007, -122.480975613562) | |||
173500 | 173500 | 183897 | Undocumented 2 | :: 54 | 1390 Quintara St | 13 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 0ft | 5989145.605 | 2101022.1677 | 37.7483810695929 | -122.480333121199 | (37.7483810695929, -122.480333121199) | |||
178904 | 178904 | 183885 | Undocumented 2 | :: 54 | 1390 Quintara St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 5988878.4835 | 2101013.894 | 37.7483428259954 | -122.481256204658 | (37.7483428259954, -122.481256204658) | |||
131825 | 131825 | 141805 | Undocumented 2 | :: 54 | 1398 WILLOW ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 6004242.7853 | 2113058.4117 | 37.78229544352121 | -122.428985434597 | (37.7822954435212, -122.428985434597) | |||
3620 | 3620 | 139511 | Undocumented 2 | :: 54 | 1400 Fulton St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 6001017.0 | 2111110.0 | 37.776762480662704 | -122.440005440059 | (37.7767624806627, -122.440005440059) | |||
159736 | 159736 | 182495 | Undocumented 2 | :: 54 | 1400 Lawton St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 5989908.6148 | 2104504.8472 | 37.7579878947596 | -122.477949247809 | (37.7579878947596, -122.477949247809) | |||
163269 | 163269 | 182498 | Undocumented 2 | :: 54 | 1400 Lawton St | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 5989876.9695 | 2104503.8264 | 37.7579832551541 | -122.478058614852 | (37.7579832551541, -122.478058614852) | |||
51976 | 51976 | 181517 | Undocumented 2 | :: 54 | 1400 Sunset Blvd | 77 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 0ft | 5984871.9567 | 2105586.7319 | 37.7606648313705 | -122.49544767930401 | (37.7606648313705, -122.495447679304) | |||
79036 | 79036 | 116326 | Undocumented 2 | :: 54 | 1400X Potrero Ave | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 6010648.284969999 | 2101378.4314900003 | 37.7505853701643 | -122.40600205927099 | (37.7505853701643, -122.406002059271) | |||||
88078 | 88078 | 116321 | Undocumented 2 | :: 54 | 1400X Potrero Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 6010648.284969999 | 2101378.4314900003 | 37.7505853701643 | -122.40600205927099 | (37.7505853701643, -122.406002059271) | |||||
88387 | 88387 | 116329 | Undocumented 2 | :: 54 | 1400X Potrero Ave | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 6010648.284969999 | 2101378.4314900003 | 37.7505853701643 | -122.40600205927099 | (37.7505853701643, -122.406002059271) | |||||
91482 | 91482 | 116332 | Undocumented 2 | :: 54 | 1400X Potrero Ave | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 6010648.284969999 | 2101378.4314900003 | 37.7505853701643 | -122.40600205927099 | (37.7505853701643, -122.406002059271) | |||||
93124 | 93124 | 116328 | Undocumented 2 | :: 54 | 1400X Potrero Ave | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 6010648.284969999 | 2101378.4314900003 | 37.7505853701643 | -122.40600205927099 | (37.7505853701643, -122.406002059271) | |||||
94078 | 94078 | 116333 | Undocumented 2 | :: 54 | 1400X Potrero Ave | 13 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 6010648.284969999 | 2101378.4314900003 | 37.7505853701643 | -122.40600205927099 | (37.7505853701643, -122.406002059271) | |||||
95183 | 95183 | 116324 | Undocumented 2 | :: 54 | 1400X Potrero Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 6010648.284969999 | 2101378.4314900003 | 37.7505853701643 | -122.40600205927099 | (37.7505853701643, -122.406002059271) | |||||
98178 | 98178 | 116335 | Undocumented 2 | :: 54 | 1400X Potrero Ave | 15 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 6010648.284969999 | 2101378.4314900003 | 37.7505853701643 | -122.40600205927099 | (37.7505853701643, -122.406002059271) | |||||
107067 | 107067 | 116330 | Undocumented 2 | :: 54 | 1400X Potrero Ave | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 6010648.284969999 | 2101378.4314900003 | 37.7505853701643 | -122.40600205927099 | (37.7505853701643, -122.406002059271) | |||||
107184 | 107184 | 116334 | Undocumented 2 | :: 54 | 1400X Potrero Ave | 14 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 6010648.284969999 | 2101378.4314900003 | 37.7505853701643 | -122.40600205927099 | (37.7505853701643, -122.406002059271) | |||||
108927 | 108927 | 116338 | Undocumented 2 | :: 54 | 1400X Potrero Ave | 18 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 6010648.284969999 | 2101378.4314900003 | 37.7505853701643 | -122.40600205927099 | (37.7505853701643, -122.406002059271) | |||||
112628 | 112628 | 116325 | Undocumented 2 | :: 54 | 1400X Potrero Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 6010648.284969999 | 2101378.4314900003 | 37.7505853701643 | -122.40600205927099 | (37.7505853701643, -122.406002059271) | |||||
113797 | 113797 | 116339 | Undocumented 2 | :: 54 | 1400X Potrero Ave | 19 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 6010648.284969999 | 2101378.4314900003 | 37.7505853701643 | -122.40600205927099 | (37.7505853701643, -122.406002059271) | |||||
118898 | 118898 | 116327 | Undocumented 2 | :: 54 | 1400X Potrero Ave | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 6010648.284969999 | 2101378.4314900003 | 37.7505853701643 | -122.40600205927099 | (37.7505853701643, -122.406002059271) | |||||
121543 | 121543 | 116331 | Undocumented 2 | :: 54 | 1400X Potrero Ave | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 6010648.284969999 | 2101378.4314900003 | 37.7505853701643 | -122.40600205927099 | (37.7505853701643, -122.406002059271) | |||||
124407 | 124407 | 116322 | Undocumented 2 | :: 54 | 1400X Potrero Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 6010648.284969999 | 2101378.4314900003 | 37.7505853701643 | -122.40600205927099 | (37.7505853701643, -122.406002059271) | |||||
125361 | 125361 | 116323 | Undocumented 2 | :: 54 | 1400X Potrero Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 6010648.284969999 | 2101378.4314900003 | 37.7505853701643 | -122.40600205927099 | (37.7505853701643, -122.406002059271) | |||||
143572 | 143572 | 116337 | Undocumented 2 | :: 54 | 1400X Potrero Ave | 17 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 6010648.284969999 | 2101378.4314900003 | 37.7505853701643 | -122.40600205927099 | (37.7505853701643, -122.406002059271) | |||||
144301 | 144301 | 116336 | Undocumented 2 | :: 54 | 1400X Potrero Ave | 16 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 6010648.284969999 | 2101378.4314900003 | 37.7505853701643 | -122.40600205927099 | (37.7505853701643, -122.406002059271) | |||||
129662 | 129662 | 200808 | Undocumented 2 | :: 54 | 1401 Oakdale Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 6016065.8568 | 2094678.3259 | 37.732489764259896 | -122.386800296411 | (37.7324897642599, -122.386800296411) | |||
77134 | 77134 | 186639 | Undocumented 2 | :: 54 | 1401 Sunset Blvd | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 5984754.4469 | 2105410.0332 | 37.7601727847523 | -122.495841051742 | (37.7601727847523, -122.495841051742) | |||
177950 | 177950 | 181597 | Undocumented 2 | :: 54 | 1402 Judah St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 5981283.949 | 2105512.8626 | 37.7602512624102 | -122.507851276945 | (37.7602512624102, -122.507851276945) | |||
153683 | 153683 | 183615 | Undocumented 2 | :: 54 | 1407 42nd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 5983066.03 | 2105519.8865 | 37.7603753832784 | -122.501688517419 | (37.7603753832784, -122.501688517419) | |||
72123 | 72123 | 139091 | Undocumented 2 | :: 54 | 1408 LYON ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 5999733.102000001 | 2113785.5627 | 37.7840357150055 | -122.44463916277901 | (37.7840357150055, -122.444639162779) | |||
163706 | 163706 | 248457 | Undocumented 2 | :: 54 | 141 Belvedere St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 0ft | 5998243.6366 | 2107963.8685 | 37.767965740451395 | -122.44937255538 | (37.7679657404514, -122.44937255538) | |||
64588 | 64588 | 183617 | Undocumented 2 | :: 54 | 1411 42nd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 5983064.0231 | 2105493.3962 | 37.7603025305329 | -122.50169349836099 | (37.7603025305329, -122.501693498361) | |||
51211 | 51211 | 183619 | Undocumented 2 | :: 54 | 1415 42nd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 5983065.6286 | 2105470.5181 | 37.760239808047295 | -122.501686253156 | (37.7602398080473, -122.501686253156) | |||
53766 | 53766 | 248316 | Undocumented 2 | :: 54 | 1415 Waller St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 0ft | 5998917.5828 | 2108317.7243 | 37.7689758669537 | -122.44706692803001 | (37.7689758669537, -122.44706692803) | |||
29958 | 29958 | 182143 | Undocumented 2 | :: 54 | 1417 25th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 5988335.378 | 2105652.5628 | 37.7610477734155 | -122.483474239769 | (37.7610477734155, -122.483474239769) | |||
149942 | 149942 | 245941 | Undocumented 2 | :: 54 | 142 Belvedere St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 0ft | 5998288.6068 | 2107942.2163 | 37.7679088612974 | -122.44921544906 | (37.7679088612974, -122.44921544906) | |||
157549 | 157549 | 182229 | Undocumented 2 | :: 54 | 1423 29th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 5987097.96 | 2105557.0847 | 37.7607135181111 | -122.487746861315 | (37.7607135181111, -122.487746861315) | |||
183358 | 183358 | 182230 | Undocumented 2 | :: 54 | 1423 30th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 5986783.0013 | 2105561.4949 | 37.7607072513694 | -122.48883647166402 | (37.7607072513694, -122.488836471664) | |||
170096 | 170096 | 182240 | Undocumented 2 | :: 54 | 1427 34th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 5985548.7085 | 2105482.2958 | 37.7604176820805 | -122.49309944026001 | (37.7604176820805, -122.49309944026) | |||
98032 | 98032 | 114972 | Permitted Site 1 | :: 54 | 1431 Grove St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/28/2015 12:00:00 AM | 3x3 | 6000962.5 | 2110659.8 | 37.775523242518794 | -122.440161680014 | (37.7755232425188, -122.440161680014) | |||
181424 | 181424 | 182239 | Undocumented 2 | :: 54 | 1434 34th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 5985592.8101 | 2105449.5872 | 37.7603304525285 | -122.492944506053 | (37.7603304525285, -122.492944506053) | |||
51444 | 51444 | 182242 | Undocumented 2 | :: 54 | 1434 35th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 5985282.2615 | 2105425.6988 | 37.760246695704296 | -122.49401677245301 | (37.7602466957043, -122.494016772453) | |||
130242 | 130242 | 182243 | Undocumented 2 | :: 54 | 1434 35th Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 5985284.8341 | 2105439.6643 | 37.760285191609704 | -122.49400890443701 | (37.7602851916097, -122.494008904437) | |||
161554 | 161554 | 183621 | Undocumented 2 | :: 54 | 1434 45th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 5982180.4079 | 2105318.1983 | 37.7597695463285 | -122.504736476063 | (37.7597695463285, -122.504736476063) | |||
124115 | 124115 | 139041 | Undocumented 2 | :: 54 | 1434 BAKER ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 6000198.6419 | 2113946.9888 | 37.7845055034656 | -122.443040165571 | (37.7845055034656, -122.443040165571) | |||
180411 | 180411 | 139043 | Undocumented 2 | :: 54 | 1434 BAKER ST | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 6000190.2907 | 2114006.1429 | 37.7846674491742 | -122.443073307519 | (37.7846674491742, -122.443073307519) | |||
184028 | 184028 | 139040 | Undocumented 2 | :: 54 | 1434 BAKER ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 6000201.4256 | 2113926.1108 | 37.7844483365891 | -122.44302903507099 | (37.7844483365891, -122.443029035071) | |||
85350 | 85350 | 40070 | Permitted Site 1 | :: 54 | 1434 Thomas Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/19/1999 12:00:00 AM | Permit Number 41296 | 6015644.04223078 | 2093317.32333735 | 37.7287293601115 | -122.388163675017 | (37.7287293601115, -122.388163675017) | ||
181084 | 181084 | 182237 | Undocumented 2 | :: 54 | 1435 32nd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 5986169.2544 | 2105448.3009 | 37.760360614583995 | -122.490950787293 | (37.760360614584, -122.490950787293) | |||
74940 | 74940 | 183620 | Undocumented 2 | :: 54 | 1435 43rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 5982754.5672 | 2105435.1976 | 37.7601245522633 | -122.502759435641 | (37.7601245522633, -122.502759435641) | |||
165425 | 165425 | 200939 | Undocumented 2 | :: 54 | 1435 Folsom St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 6008734.9445 | 2109359.299 | 37.7723918057631 | -122.413182848986 | (37.7723918057631, -122.413182848986) | |||
39726 | 39726 | 182241 | Undocumented 2 | :: 54 | 1438 29th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 5987144.2667 | 2105475.1293 | 37.7604911919338 | -122.48758068859199 | (37.7604911919338, -122.487580688592) | |||
169695 | 169695 | 182245 | Undocumented 2 | :: 54 | 1438 34th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 5985593.9126 | 2105419.8186 | 37.760248780689395 | -122.492938500284 | (37.7602487806894, -122.492938500284) | |||
66774 | 66774 | 182249 | Undocumented 2 | :: 54 | 1439 34th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 5985551.6486 | 2105407.6907 | 37.760213009140394 | -122.49308377605301 | (37.7602130091404, -122.493083776053) | |||
82852 | 82852 | 182257 | Undocumented 2 | :: 54 | 1439 35th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 5985240.365 | 2105399.9729 | 37.760173608006795 | -122.494159774452 | (37.7601736080068, -122.494159774452) | |||
183785 | 183785 | 141123 | Undocumented 2 | :: 54 | 144 Anza St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 5998637.0216 | 2112710.0541 | 37.7810200422428 | -122.448353710975 | (37.7810200422428, -122.448353710975) | |||
39908 | 39908 | 183623 | Undocumented 2 | :: 54 | 1443 41st Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 5983380.9044 | 2105304.9531 | 37.7598037265775 | -122.50058363770201 | (37.7598037265775, -122.500583637702) | |||
95693 | 95693 | 117514 | Undocumented 2 | :: 54 | 1445 DIAMOND ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6002056.0 | 2099801.0 | 37.7457698069611 | -122.435601983861 | (37.7457698069611, -122.435601983861) | ||||
173497 | 173497 | 200570 | Undocumented 2 | :: 54 | 1445 La Salle Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 6016341.8296 | 2095299.657 | 37.7342110910182 | -122.38588947759399 | (37.7342110910182, -122.385889477594) | |||
153577 | 153577 | 183633 | Undocumented 2 | :: 54 | 1448 La Playa | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 5980945.5944 | 2105199.3929 | 37.759370623772 | -122.50899818869699 | (37.759370623772, -122.508998188697) | |||
178124 | 178124 | 140889 | Undocumented 2 | :: 54 | 145 COMMONWEALTH AVE | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 5996520.3624 | 2113408.7259 | 37.7828171689042 | -122.455726761043 | (37.7828171689042, -122.455726761043) | |||
64173 | 64173 | 182244 | Undocumented 2 | :: 54 | 1451 34th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 5985553.1187 | 2105344.1109 | 37.76003852263371 | -122.49307400807 | (37.7600385226337, -122.49307400807) | |||
149711 | 149711 | 183631 | Undocumented 2 | :: 54 | 1451 45th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 5982139.8696 | 2105211.8354 | 37.7594751192783 | -122.50486879402 | (37.7594751192783, -122.50486879402) | |||
72532 | 72532 | 116318 | Undocumented 2 | :: 54 | 1451 Hampshire St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 6010547.7 | 2101110.8 | 37.749844886729996 | -122.406331036849 | (37.74984488673, -122.406331036849) | |||||
94106 | 94106 | 116320 | Undocumented 2 | :: 54 | 1451 Hampshire St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 6010547.7 | 2101110.8 | 37.749844886729996 | -122.406331036849 | (37.74984488673, -122.406331036849) | |||||
99142 | 99142 | 116319 | Undocumented 2 | :: 54 | 1451 Hampshire St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 6010547.7 | 2101110.8 | 37.749844886729996 | -122.406331036849 | (37.74984488673, -122.406331036849) | |||||
123446 | 123446 | 182145 | Undocumented 2 | :: 54 | 1452 Moraga St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 5989717.6723 | 2103818.6604 | 37.7560927247983 | -122.47855942154101 | (37.7560927247983, -122.478559421541) | |||
177991 | 177991 | 182247 | Undocumented 2 | :: 54 | 1454 34th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 5985597.5878 | 2105309.9322 | 37.759947278047 | -122.49291769541 | (37.759947278047, -122.49291769541) | |||
150058 | 150058 | 182258 | Undocumented 2 | :: 54 | 1454 Kirkham St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 5984978.1444 | 2105303.8682 | 37.7598943836638 | -122.49505957106001 | (37.7598943836638, -122.49505957106) | |||
187469 | 187469 | 200742 | Undocumented 2 | :: 54 | 1454 Oakdale Ave | 1 | unknown : Yard 19 | Tree 1 | Private 1 | 0 | Width 0ft | 6015834.4667 | 2094922.2745 | 37.733146784173606 | -122.38761728786601 | (37.7331467841736, -122.387617287866) | |||
75993 | 75993 | 184194 | Undocumented 2 | :: 54 | 1455 37th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 5984623.2527 | 2105271.116 | 37.75978367262321 | -122.496284533471 | (37.7597836726232, -122.496284533471) | |||
61992 | 61992 | 184196 | Undocumented 2 | :: 54 | 1455 40th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 5983694.2415 | 2105244.3749 | 37.759655785236895 | -122.49949549884899 | (37.7596557852369, -122.499495498849) | |||
137192 | 137192 | 140325 | Undocumented 2 | :: 54 | 1455 LAGUNA ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 6004557.9993 | 2113847.3125 | 37.7844794061151 | -122.42795116719601 | (37.7844794061151, -122.427951167196) | |||
153742 | 153742 | 182259 | Undocumented 2 | :: 54 | 1458 34th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 5985599.4253 | 2105281.2662 | 37.759868676617295 | -122.49290922894899 | (37.7598686766173, -122.492909228949) | |||
183796 | 183796 | 182261 | Undocumented 2 | :: 54 | 1458 36th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 5984977.3774 | 2105263.7356 | 37.759784145824796 | -122.495059264357 | (37.7597841458248, -122.495059264357) | |||
93194 | 93194 | 184195 | Undocumented 2 | :: 54 | 1459 37th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 5984624.9154 | 2105245.6219 | 37.759713770345 | -122.49627690203998 | (37.759713770345, -122.49627690204) | |||
28730 | 28730 | 140456 | Undocumented 2 | :: 54 | 1459 Eddy St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 6003479.0697 | 2112771.1641 | 37.7814634747388 | -122.431607035931 | (37.7814634747388, -122.431607035931) | |||
89249 | 89249 | 113382 | Undocumented 2 | :: 54 | 146 CASTENADA AVE | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 3x3 | 5994461.0 | 2101055.0 | 37.7487786662853 | -122.46195512222401 | (37.7487786662853, -122.461955122224) | |||
111918 | 111918 | 109831 | Permitted Site 1 | :: 54 | 146 Staples Ave | 1 | Sidewalk: Property side : Cutout 5 | Landscaping 2 | Private 1 | 12x15.3 | 5999109.5 | 2093827.3 | 37.7291996500545 | -122.445361075989 | (37.7291996500545, -122.445361075989) | ||||
102413 | 102413 | 108826 | Undocumented 2 | :: 54 | 146-150X Gillette Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 6013072.89275 | 2086799.9167400002 | 37.7106910734067 | -122.39659568235001 | (37.7106910734067, -122.39659568235) | ||||
34038 | 34038 | 140392 | Undocumented 2 | :: 54 | 1460 Steiner St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 6002728.4059 | 2113323.2276 | 37.782936725289204 | -122.434243446651 | (37.7829367252892, -122.434243446651) | |||
123440 | 123440 | 182019 | Undocumented 2 | :: 54 | 1462 23rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 5989010.2708 | 2105406.8058 | 37.7604122485648 | -122.481122109635 | (37.7604122485648, -122.481122109635) | |||
104342 | 104342 | 95908 | Permitted Site 1 | :: 54 | 1463 28th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/27/2011 12:00:00 AM | 3x3 | Permit Number 767609 | 5987396.4 | 2105326.0 | 37.760096425656705 | -122.486697735896 | (37.7600964256567, -122.486697735896) | |
160820 | 160820 | 184200 | Undocumented 2 | :: 54 | 1466 38th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 5984360.2753 | 2105208.7663 | 37.759597069474395 | -122.497189426429 | (37.7595970694744, -122.497189426429) |
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");