Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: SiteOrder, qSiteInfo, qCareAssistant
qCaretaker ✖
qLegalStatus ✖
Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude ▼ | Location |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
7848 | 7848 | 51578 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/04/2005 12:00:00 AM | Permit Number 47872 | |||||||||
10202 | 10202 | 173900 | Private 5 | Ligustrum lucidum :: Glossy Privet 55 | 601x Hearst Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | ||||||||||
10204 | 10204 | 173902 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 601x Hearst Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | ||||||||||
12636 | 12636 | 99746 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 4250 Clipper St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | |||||||||
185883 | 185883 | 67262 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 511 47th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/08/1992 12:00:00 AM | 6 | Permit Number 30729 | 5981280.933019999 | 2112230.5095 | 37.7786957851972 | -122.508360365452 | (37.7786957851972, -122.508360365452) | |
171311 | 171311 | 67223 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 555 47th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/26/1992 12:00:00 AM | 6 | Permit Number 30682 | 5981290.9854 | 2111950.9362 | 37.7779287520405 | -122.508304833393 | (37.7779287520405, -122.508304833393) | |
70184 | 70184 | 67244 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 5524 Anza St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/08/1992 12:00:00 AM | 7 | Permit Number 30708 | 5981494.88729 | 2111682.33433 | 37.7772032645806 | -122.50757954173599 | (37.7772032645806, -122.507579541736) | |
70732 | 70732 | 46972 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 1686 44th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/01/2002 12:00:00 AM | 2 | Permit Number 44991 | 5982549.0126 | 2103652.333 | 37.755217228081996 | -122.50333832645 | (37.755217228082, -122.50333832645) | |
50486 | 50486 | 46971 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 1686 44th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/01/2002 12:00:00 AM | 2 | Permit Number 44991 | 5982549.6238 | 2103640.11 | 37.7551837030962 | -122.50333530778 | (37.7551837030962, -122.50333530778) | |
71064 | 71064 | 183299 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 1286 42nd Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 2 | Width 0ft | 5983077.482999999 | 2106392.3859 | 37.7627716918826 | -122.501713459776 | (37.7627716918826, -122.501713459776) | |||
160628 | 160628 | 183298 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 1286 42nd Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | Width 0ft | 5983077.482999999 | 2106384.7622 | 37.762750759369105 | -122.501712895715 | (37.7627507593691, -122.501712895715) | |||
56852 | 56852 | 183625 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 1431 41st Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 0ft | 5983375.6866 | 2105398.8736 | 37.7600612994594 | -122.50060862808701 | (37.7600612994594, -122.500608628087) | |||
122515 | 122515 | 100230 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 701X 39th Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3x3 | 5983807.86909 | 2110960.60417 | 37.7753575879766 | -122.49952497559799 | (37.7753575879766, -122.499524975598) | |||
19637 | 19637 | 100232 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 701X 39th Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3x3 | 5983809.619390001 | 2110917.38856 | 37.775239033091104 | -122.499515726535 | (37.7752390330911, -122.499515726535) | |||
68444 | 68444 | 184122 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 3340 Lawton St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 0ft | 5983807.3681 | 2104294.0393 | 37.7570530669968 | -122.49903404016001 | (37.7570530669968, -122.49903404016) | |||
154101 | 154101 | 62594 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 735 37th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/22/1986 12:00:00 AM | 9 | Permit Number 22900 | 5984433.86075 | 2110817.8986299997 | 37.7750024687546 | -122.497349020618 | (37.7750024687546, -122.497349020618) | |
159008 | 159008 | 62593 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 731 37th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/22/1986 12:00:00 AM | 9 | Permit Number 22899 | 5984434.98291 | 2110845.2368799997 | 37.7750775975018 | -122.49734715750401 | (37.7750775975018, -122.497347157504) | |
121186 | 121186 | 62592 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 763 37th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/22/1986 12:00:00 AM | Permit Number 22898 | 5984437.65774708 | 2110651.26442232 | 37.7745451616246 | -122.497323582278 | (37.7745451616246, -122.497323582278) | ||
64603 | 64603 | 62591 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 759 37th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/22/1986 12:00:00 AM | 9 | Permit Number 22897 | 5984439.68457 | 2110661.64848 | 37.774573792054795 | -122.497317337939 | (37.7745737920548, -122.497317337939) | |
75651 | 75651 | 118275 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 763 37th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 5984440.01732 | 2110639.37608 | 37.7745126579414 | -122.497314542381 | (37.7745126579414, -122.497314542381) | |||
41938 | 41938 | 62597 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 765 37th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/22/1986 12:00:00 AM | 7 | Permit Number 22903 | 5984441.0146 | 2110622.99108 | 37.7744677278845 | -122.49730988283301 | (37.7744677278845, -122.497309882833) | |
158341 | 158341 | 118272 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 801 37th Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 1ft | 5984451.19382 | 2110333.53689 | 37.7736735662944 | -122.497253299741 | (37.7736735662944, -122.497253299741) | |||
26884 | 26884 | 54531 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 855 37th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/31/1972 12:00:00 AM | 12 | Permit Number 10326 | 5984466.31691 | 2110015.99536 | 37.7728025745037 | -122.497177542996 | (37.7728025745037, -122.497177542996) | ||
175876 | 175876 | 118089 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 7049 Geary Blvd | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 9 | Width 1ft | 5985075.84275 | 2112426.03783 | 37.7794555626476 | -122.49524691703199 | (37.7794555626476, -122.495246917032) | |||
24921 | 24921 | 185624 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 2100 Sunset Blvd | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 2 | Width 0ft | 5985032.5384 | 2100289.574 | 37.74612969593421 | -122.49450180509399 | (37.7461296959342, -122.494501805094) | |||
38825 | 38825 | 186910 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 2700 Sunset Blvd | 59 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 0ft | 5985181.9251 | 2096700.884 | 37.7362848611965 | -122.49372085206998 | (37.7362848611965, -122.49372085207) | |||
40802 | 40802 | 182830 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 1811 34th Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 0ft | 5985639.2314 | 2102838.2271 | 37.7531630922797 | -122.49259163632401 | (37.7531630922797, -122.492591636324) | |||
159993 | 159993 | 119447 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 895 32nd Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | 5986012.28825 | 2109834.94123 | 37.7723959307274 | -122.49181659590599 | (37.7723959307274, -122.491816595906) | ||||
172508 | 172508 | 182848 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 1795 33rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 0ft | 5985939.7457 | 2103040.5574 | 37.7537362025059 | -122.491567304651 | (37.7537362025059, -122.491567304651) | |||
130474 | 130474 | 119507 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 725 31st Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 1ft | 5986293.694519999 | 2110943.52758 | 37.7754562387381 | -122.49092478893101 | (37.7754562387381, -122.490924788931) | |||
65846 | 65846 | 37203 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 1574 32nd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/12/1998 12:00:00 AM | 5 | Permit Number 39770 | 5986243.4033 | 2104539.0139 | 37.7578682946863 | -122.49062744276699 | (37.7578682946863, -122.490627442767) | |
151314 | 151314 | 119942 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 346 30th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 5986553.230140001 | 2113597.32948 | 37.7827579817147 | -122.490222261455 | (37.7827579817147, -122.490222261455) | |||
180317 | 180317 | 185606 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 2123 29th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 0ft | 5987259.0828 | 2100808.0996 | 37.7476834885004 | -122.48684086956699 | (37.7476834885004, -122.486840869567) | |||
179715 | 179715 | 120187 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 218 26th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 5987760.31768 | 2114496.30361 | 37.7852967290916 | -122.486112314519 | (37.7852967290916, -122.486112314519) | |||
148718 | 148718 | 59149 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 218 26th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/01/1980 12:00:00 AM | 7 | Permit Number 18458 | 5987761.12595 | 2114471.82373 | 37.7852295614332 | -122.48610772054501 | (37.7852295614332, -122.486107720545) | ||
175991 | 175991 | 101635 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 1800X 27th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 3x3 | 5987855.0174 | 2102962.611 | 37.753633925344296 | -122.484938226474 | (37.7536339253443, -122.484938226474) | |||
122091 | 122091 | 114098 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 219x VIDAL DR | 1 | Front Yard : Cutout 8 | Tree 1 | Private 1 | 40 | 5987664.0 | 2090565.0 | 37.719582202213104 | -122.48468943736401 | (37.7195822022131, -122.484689437364) | ||||
88441 | 88441 | 114094 | Significant Tree 6 | Ligustrum lucidum :: Glossy Privet 55 | 239x VIDAL DR | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 24 | 5987668.0 | 2090475.0 | 37.7193353179991 | -122.484669012602 | (37.7193353179991, -122.484669012602) | ||||
184181 | 184181 | 120484 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 2309 Lake St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 1ft | 5988270.499009999 | 2114625.30582 | 37.785680652510294 | -122.48435672889299 | (37.7856806525103, -122.484356728893) | |||
64567 | 64567 | 120483 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 2309 Lake St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 1ft | 5988277.53401 | 2114625.15663 | 37.7856806525102 | -122.48433237916201 | (37.7856806525102, -122.484332379162) | |||
33362 | 33362 | 55257 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 810 25th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/18/1972 12:00:00 AM | 5 | Permit Number 11179 | 5988221.44369 | 2110421.88962 | 37.7741363990758 | -122.48421806494801 | (37.7741363990758, -122.484218064948) | ||
58329 | 58329 | 120302 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 361 24th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 2ft | 5988369.83373 | 2113569.61422 | 37.7827878063085 | -122.483935624743 | (37.7827878063085, -122.483935624743) | |||
124121 | 124121 | 12823 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 2201 Lake St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/05/2007 12:00:00 AM | 3 | 5 | 5988577.51702 | 2114639.82314 | 37.785738385289896 | -122.483295611932 | (37.7857383852899, -122.483295611932) | ||
68485 | 68485 | 120482 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 2201 Lake St | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 1ft | 5988588.087169999 | 2114640.4078900004 | 37.7857406059941 | -122.483259085533 | (37.7857406059941, -122.483259085533) | |||
54144 | 54144 | 120481 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 2201 Lake St | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 1ft | 5988593.25091 | 2114641.37666 | 37.7857435664695 | -122.48324129171101 | (37.7857435664695, -122.483241291711) | |||
157541 | 157541 | 120479 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 2201 Lake St | 5 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 1ft | 5988612.47401 | 2114641.5086 | 37.785745047419 | -122.48317479571301 | (37.785745047419, -122.483174795713) | |||
69652 | 69652 | 120478 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 2201 Lake St | 6 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 1ft | 5988614.91495 | 2114641.72629 | 37.78574578718071 | -122.483166366817 | (37.7857457871807, -122.483166366817) | |||
147156 | 147156 | 182589 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 2483 26th Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 1 | Width 0ft | 5988272.3462 | 2098420.0243 | 37.741185487105 | -122.483162087393 | (37.741185487105, -122.483162087393) | |||
185708 | 185708 | 120477 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 2201 Lake St | 8 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | Width 1ft | 5988623.03819 | 2114641.82381 | 37.785746527658 | -122.483138270198 | (37.785746527658, -122.483138270198) | |||
168055 | 168055 | 120397 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 101 23rd Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 14 | Width 1ft | 5988633.138590001 | 2114628.42785 | 37.785710333915404 | -122.48310234386899 | (37.7857103339154, -122.483102343869) | |||
182263 | 182263 | 120396 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 101 23rd Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | Width 1ft | 5988633.9259 | 2114634.88666 | 37.7857281137897 | -122.48310009361099 | (37.7857281137897, -122.483100093611) | |||
177288 | 177288 | 101277 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 2323 Irving St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 3x3 | 5988481.6146 | 2106443.4757 | 37.7632279152074 | -122.48302644728001 | (37.7632279152074, -122.48302644728) | |||
149295 | 149295 | 120400 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 163 23rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 5988653.91402 | 2114240.5156099997 | 37.7846464457785 | -122.483002026322 | (37.7846464457785, -122.483002026322) | |||
154151 | 154151 | 101278 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 2323 Irving St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | 3x3 | 5988527.6084 | 2106443.4757 | 37.763230591454395 | -122.482867371906 | (37.7632305914544, -122.482867371906) | |||
11487 | 11487 | 110355 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 2300 Irving St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3x3 | 5988563.2444 | 2106497.4984 | 37.763380996470005 | -122.482748079472 | (37.76338099647, -122.482748079472) | |||
32562 | 32562 | 183926 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 1595 Quintara St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 0ft | 5988583.1369 | 2101004.688 | 37.7483003735732 | -122.482276819356 | (37.7483003735732, -122.482276819356) | |||
29382 | 29382 | 183930 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 1595 Quintara St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 0ft | 5988704.6498 | 2101009.2638 | 37.748320004874 | -122.48185697108299 | (37.748320004874, -122.481856971083) | |||
168157 | 168157 | 101109 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 1790 24th Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3X3 | Permit Number 14067 | 5988776.9552 | 2103216.747 | 37.754385370533704 | -122.48176861229099 | (37.7543853705337, -122.481768612291) | ||
187811 | 187811 | 101108 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 1790 24th Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | 3X3 | Permit Number 14067 | 5988777.5028 | 2103198.1315 | 37.754334289199704 | -122.481765355128 | (37.7543342891997, -122.481765355128) | ||
44679 | 44679 | 101107 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 1790 24th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | 3X3 | Permit Number 14067 | 5988779.1453 | 2103160.9003 | 37.7542321578078 | -122.48175694812299 | (37.7542321578078, -122.481756948123) | ||
60756 | 60756 | 56836 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 1790 24th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/02/1974 12:00:00 AM | 2 | 3X3 | Permit Number 14067 | 5988782.4304 | 2103136.262 | 37.7541646986668 | -122.48174378301701 | (37.7541646986668, -122.481743783017) | |
66400 | 66400 | 183931 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 1595 Quintara St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 0ft | 5988739.7309 | 2101009.2638 | 37.748322044963395 | -122.48173566297301 | (37.7483220449634, -122.481735662973) | |||
164311 | 164311 | 181320 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 2130 Irving St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 0ft | 5989076.012999999 | 2106520.0924 | 37.7634728536567 | -122.48097625438999 | (37.7634728536567, -122.48097625439) | |||
99192 | 99192 | 101266 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 2126 Irving St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5989175.0 | 2106519.0 | 37.7634756077712 | -122.48063381405599 | (37.7634756077712, -122.480633814056) | ||||
26544 | 26544 | 101281 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 2049 Irving St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | 3x3 | 5989322.9543 | 2106470.5284 | 37.763351115778796 | -122.48011854571301 | (37.7633511157788, -122.480118545713) | |||
151635 | 151635 | 101284 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 2034 Irving St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 3x3 | 5989388.4992 | 2106533.1127 | 37.7635267635243 | -122.479896429915 | (37.7635267635243, -122.479896429915) | |||
107084 | 107084 | 101265 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 2034 Irving St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5989459.10715 | 2106523.8610900003 | 37.7635054630097 | -122.47965154526001 | (37.7635054630097, -122.47965154526) | ||||
57258 | 57258 | 61503 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 174 20th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/02/1986 12:00:00 AM | 8 | Permit Number 23383 | 5989631.93083 | 2114222.6944 | 37.784654374553206 | -122.479617149177 | (37.7846543745532, -122.479617149177) | |
34167 | 34167 | 181337 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 1943 Irving St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 0ft | 5989659.6191 | 2106483.3237 | 37.7634058040829 | -122.478955080908 | (37.7634058040829, -122.478955080908) | |||
10520 | 10520 | 95069 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 1924 Irving St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 5989718.6012 | 2106543.0694 | 37.7635732745448 | -122.478755452983 | (37.7635732745448, -122.478755452983) | ||||
145747 | 145747 | 101261 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 1945 Irving St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5989742.0 | 2106485.0 | 37.763415190264894 | -122.478670277794 | (37.7634151902649, -122.478670277794) | ||||
47167 | 47167 | 182701 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 1706 21st Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 8 | Width 0ft | 5989689.5329 | 2103706.6241 | 37.75578346921429 | -122.478648542868 | (37.7557834692143, -122.478648542868) | |||
60829 | 60829 | 101260 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 1900 Irving St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3x3 | 5989805.9135 | 2106546.133 | 37.7635867556905 | -122.47845369468399 | (37.7635867556905, -122.478453694684) | |||
24097 | 24097 | 177096 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 0 Serrano Dr | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 32 | 5989524.60255 | 2090740.4518099998 | 37.720172132521206 | -122.47827090148199 | (37.7201721325212, -122.478270901482) | ||||
55289 | 55289 | 177095 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 0 Serrano Dr | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 48 | 5989637.49515 | 2090738.06528 | 37.720172132515 | -122.47788049948 | (37.720172132515, -122.47788049948) | ||||
63108 | 63108 | 56420 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 231 18th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/20/1973 12:00:00 AM | 7 | Permit Number 12580 | 5990219.564180001 | 2113818.4640099998 | 37.783578588527796 | -122.47755460021799 | (37.7835785885278, -122.477554600218) | ||
178868 | 178868 | 56417 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 222 18th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/20/1973 12:00:00 AM | 10 | Permit Number 12577 | 5990267.02613 | 2113888.22786 | 37.783772894624 | -122.47739550229299 | (37.783772894624, -122.477395502293) | ||
132975 | 132975 | 56418 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 226 18th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/20/1973 12:00:00 AM | 9 | Permit Number 12578 | 5990267.28978 | 2113858.89022 | 37.783692356954205 | -122.477392445306 | (37.7836923569542, -122.477392445306) | ||
165885 | 165885 | 56421 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 232 18th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/20/1973 12:00:00 AM | 12 | 5x5 | Permit Number 12581 | 5990270.934780001 | 2113836.22748 | 37.7836303428936 | -122.47737817827 | (37.7836303428936, -122.47737817827) | |
33941 | 33941 | 40560 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 458 18th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/06/1999 12:00:00 AM | 7 | Permit Number 41604 | 5990324.44539 | 2112242.31069 | 37.779256995112 | -122.47707654197399 | (37.779256995112, -122.477076541974) | |
74160 | 74160 | 122271 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 1600 Balboa St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 5990587.5386 | 2111332.78753 | 37.776774954972204 | -122.476099955577 | (37.7767749549722, -122.476099955577) | |||
135631 | 135631 | 122270 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 1600 Balboa St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 5990596.49847 | 2111330.4876599996 | 37.7767691597055 | -122.47606879302 | (37.7767691597055, -122.47606879302) | |||
158754 | 158754 | 67388 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 779 17th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/28/1992 12:00:00 AM | 12 | Permit Number 30885 | 5990666.23465 | 2110099.72843 | 37.7733938754744 | -122.475737660544 | (37.7733938754744, -122.475737660544) | |
118589 | 118589 | 34242 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 1263 17th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/07/1997 12:00:00 AM | Permit Number 38052 | 5990773.84225381 | 2106807.51859079 | 37.7643605962692 | -122.47512505139099 | (37.7643605962692, -122.475125051391) | |||
41939 | 41939 | 207892 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 2119 18th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 5990666.05125 | 2100929.33737 | 37.7482144184726 | -122.47506873135299 | (37.7482144184726, -122.475068731353) | |||
164052 | 164052 | 55004 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 585 16th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/12/1972 12:00:00 AM | 9 | Permit Number 10882 | 5990928.49024 | 2111392.95682 | 37.7769599278948 | -122.474924907094 | (37.7769599278948, -122.474924907094) | ||
170030 | 170030 | 122095 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 585 16th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 4ft | 5990929.30413 | 2111377.25898 | 37.776916873099 | -122.474920945501 | (37.776916873099, -122.474920945501) | |||
187706 | 187706 | 55001 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 546 16th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/12/1972 12:00:00 AM | 12 | Permit Number 10879 | 5990967.23553 | 2111663.9992 | 37.777706381155205 | -122.474810664746 | (37.7777063811552, -122.474810664746) | ||
150383 | 150383 | 56174 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 701 16th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/03/1973 12:00:00 AM | 9 | Permit Number 12282 | 5990956.32694 | 2110582.1012 | 37.774735153466295 | -122.474769414984 | (37.7747351534663, -122.474769414984) | ||
136063 | 136063 | 122093 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 701 16th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 5990957.61701 | 2110561.8313599997 | 37.774679572778204 | -122.474763472642 | (37.7746795727782, -122.474763472642) | |||
172427 | 172427 | 56173 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 680 16th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/03/1973 12:00:00 AM | 9 | Permit Number 12281 | 5990998.5556 | 2110774.78809 | 37.7752666659576 | -122.474637404879 | (37.7752666659576, -122.474637404879) | ||
46096 | 46096 | 122133 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 1 15th Ave | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 17 | 5991114.065719999 | 2115007.37065 | 37.7868948615896 | -122.474546795399 | (37.7868948615896, -122.474546795399) | ||||
34798 | 34798 | 122131 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 1 15th Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 14 | 5991115.120209999 | 2115013.7594 | 37.786912464412104 | -122.47454361357 | (37.7869124644121, -122.47454361357) | ||||
167324 | 167324 | 122130 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 1 15th Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 19 | 5991115.18782 | 2115016.9633400002 | 37.7869212654547 | -122.474543613569 | (37.7869212654547, -122.474543613569) | ||||
167000 | 167000 | 122135 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 1 15th Ave | 6 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 20 | 5991115.45698 | 2114997.03818 | 37.78686657212 | -122.47454122766099 | (37.78686657212, -122.474541227661) | ||||
44820 | 44820 | 122132 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 1 15th Ave | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 14 | 5991115.98152 | 2115010.99351 | 37.7869049199545 | -122.47454043173401 | (37.7869049199545, -122.474540431734) | ||||
182203 | 182203 | 122137 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 1 15th Ave | 8 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 18 | 5991115.84231 | 2114982.60549 | 37.786826966306 | -122.47453884083001 | (37.786826966306, -122.47453884083) | ||||
155404 | 155404 | 122134 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 1 15th Ave | 5 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 14 | 5991116.74625 | 2115003.65081 | 37.78688480325761 | -122.4745372499 | (37.7868848032576, -122.4745372499) | ||||
24194 | 24194 | 122139 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 1 15th Ave | 10 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | 5991116.38675 | 2114975.72508 | 37.7868081061645 | -122.474536454895 | (37.7868081061645, -122.474536454895) | ||||
186663 | 186663 | 122136 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 1 15th Ave | 7 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 13 | 5991117.00305 | 2114994.0290099997 | 37.786858399358294 | -122.47453565898 | (37.7868583993583, -122.47453565898) |
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");