Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, SiteOrder, qCaretaker, PlantDate, DBH, PlotSize, PermitNotes
Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location ▼ |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
67404 | 67404 | 177922 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 0 Cambon Dr | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | Width 5ft | 5990625.846609999 | 2089245.25322 | 37.7161305522573 | -122.474355255986 | (37.7161305522573, -122.474355255986) | |||
72659 | 72659 | 177921 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 0 Cambon Dr | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | Width 5ft | 5990636.51581 | 2089256.00468 | 37.7161606912434 | -122.47431916261499 | (37.7161606912434, -122.474319162615) | |||
46191 | 46191 | 210732 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 486 Arch St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 8ft | 5992756.333330001 | 2090404.7555 | 37.719437465534 | -122.46707559208201 | (37.719437465534, -122.467075592082) | |||
52452 | 52452 | 210730 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 599 Arch St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 10ft | 5992718.10768 | 2091174.58463 | 37.721549022462 | -122.467263668211 | (37.721549022462, -122.467263668211) | |||
64446 | 64446 | 210702 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 495 Faxon Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 15 | Width 3ft | 5994735.30528 | 2091846.72997 | 37.7235108134601 | -122.46033948738199 | (37.7235108134601, -122.460339487382) | |||
176392 | 176392 | 178000 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 964 Avalon Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 3ft | 6005277.15219 | 2092117.50935 | 37.7248550903643 | -122.423917422954 | (37.7248550903643, -122.423917422954) | |||
133738 | 133738 | 178001 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 199 Athens St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 2 | 6004683.62284 | 2092152.0672799998 | 37.7249164529191 | -122.42597164450301 | (37.7249164529191, -122.425971644503) | ||||
31841 | 31841 | 178002 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 214 Athens St | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | 6004671.81576 | 2092168.4342200002 | 37.724960725638795 | -122.42601362482701 | (37.7249607256388, -122.426013624827) | ||||
35319 | 35319 | 178005 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 214 Athens St | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | 6004661.22391 | 2092172.31663 | 37.7249707872555 | -122.42605051593901 | (37.7249707872555, -122.426050515939) | ||||
35575 | 35575 | 178004 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 214 Athens St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 2 | 6004666.19434 | 2092181.37563 | 37.7249959421932 | -122.4260339783 | (37.7249959421932, -122.4260339783) | ||||
137518 | 137518 | 178003 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 214 Athens St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 2 | 6004675.59533 | 2092196.02868 | 37.725036707559994 | -122.426002522716 | (37.72503670756, -122.426002522716) | ||||
21199 | 21199 | 97237 | Property Tree 7 | Olea europaea :: Olive Tree 41 | 125 Excelsior Ave | Sidewalk: Property side : Yard 9 | Tree 1 | SFUSD 4 | FUF 1 | 09/07/2011 12:00:00 AM | Permit Number 767513 | 6002911.0 | 2092621.3 | 37.7261045201699 | -122.43213288829399 | (37.7261045201699, -122.432132888294) | |||
100052 | 100052 | 97238 | Property Tree 7 | Olea europaea :: Olive Tree 41 | 125 Excelsior Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | SFUSD 4 | FUF 1 | 09/07/2011 12:00:00 AM | 3 | 3x3 | Permit Number 767513 | 6002911.0 | 2092621.3 | 37.7261045201699 | -122.43213288829399 | (37.7261045201699, -122.432132888294) |
132478 | 132478 | 210873 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 62 Marston Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 9 | Width 8ft | 5998923.839269999 | 2093227.89544 | 37.7275432251404 | -122.445959824297 | (37.7275432251404, -122.445959824297) | |||
189009 | 189009 | 210872 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 371 Staples Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 9 | Width 8ft | 5997627.30354 | 2093781.8331900002 | 37.72899008680061 | -122.450481853864 | (37.7289900868006, -122.450481853864) | |||
132103 | 132103 | 210868 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 21 Flood Ave | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 2ft | 6000252.08808 | 2094037.4276299998 | 37.7298417699638 | -122.441426135001 | (37.7298417699638, -122.441426135001) | |||
178262 | 178262 | 210869 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 158 Flood Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | 5999679.41111 | 2094102.69585 | 37.7299883396845 | -122.44341062492799 | (37.7299883396845, -122.443410624928) | ||||
57370 | 57370 | 177965 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 1703 San Jose Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | 6001599.27369 | 2094156.6391200002 | 37.7302457535263 | -122.43677729835699 | (37.7302457535263, -122.436777298357) | ||||
107455 | 107455 | 177858 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 1601 San Jose Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | 6001601.40934 | 2094159.02355 | 37.7302524219998 | -122.43677008576401 | (37.7302524219998, -122.436770085764) | ||||
33891 | 33891 | 177966 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 1703 San Jose Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | 6001621.06552 | 2094170.26367 | 37.730284401888206 | -122.436702936114 | (37.7302844018882, -122.436702936114) | ||||
185682 | 185682 | 177859 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 1601 San Jose Ave | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | 6001617.87138 | 2094170.6936700002 | 37.7302854010441 | -122.43671400943701 | (37.7302854010441, -122.436714009437) | ||||
65146 | 65146 | 210687 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 270 Hearst Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 10 | Width 8ft | 5999611.40538 | 2094395.78433 | 37.7307892138454 | -122.443666775201 | (37.7307892138454, -122.443666775201) | |||
66805 | 66805 | 210831 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 100 El Verano Way | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 3ft | 5994495.152530001 | 2094669.90963 | 37.7312487620154 | -122.461374210478 | (37.7312487620154, -122.461374210478) | |||
182313 | 182313 | 210832 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 100 El Verano Way | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 2 | Width 3ft | 5994491.87078 | 2094685.88565 | 37.731292439379395 | -122.461386713728 | (37.7312924393794, -122.461386713728) | |||
66050 | 66050 | 210866 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 110 Monterey Blvd | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 6ft | 6001326.245569999 | 2094696.7194700001 | 37.7317131692257 | -122.437759857137 | (37.7317131692257, -122.437759857137) | |||
165406 | 165406 | 210867 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 774 Joost Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 10 | Width 6ft | 5996972.318969999 | 2095027.1901599998 | 37.7323720296365 | -122.452836023577 | (37.7323720296365, -122.452836023577) | |||
35405 | 35405 | 210862 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 412 Joost Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 9 | Width 6ft | 5999352.48487 | 2094990.83835 | 37.7324083217769 | -122.444604653878 | (37.7324083217769, -122.444604653878) | |||
44923 | 44923 | 210863 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 412 Joost Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 6ft | 5999336.30619 | 2094992.2158 | 37.7324111807223 | -122.44466068613501 | (37.7324111807223, -122.444660686135) | |||
69915 | 69915 | 210852 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 330 Baden St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 6ft | 6000786.85539 | 2095109.56492 | 37.732816061802 | -122.439654219669 | (37.732816061802, -122.439654219669) | |||
160671 | 160671 | 210864 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 585 Mangels Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | 5997550.306419999 | 2095241.3957900002 | 37.732993291202796 | -122.45085323608299 | (37.7329932912028, -122.450853236083) | ||||
76839 | 76839 | 210860 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 458 Mangels Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 2 | Width 9ft | 5998392.85645 | 2095276.6341799998 | 37.7331382439186 | -122.447942868994 | (37.7331382439186, -122.447942868994) | |||
185499 | 185499 | 210857 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 300 Mangels Ave | 7 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 2 | 5999360.350819999 | 2095260.17688 | 37.7331483109495 | -122.444596810892 | (37.7331483109495, -122.444596810892) | ||||
171012 | 171012 | 210859 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 300 Mangels Ave | 12 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | 5999336.203480001 | 2095262.51223 | 37.7331533453405 | -122.444680462235 | (37.7331533453405, -122.444680462235) | ||||
186177 | 186177 | 210858 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 300 Mangels Ave | 10 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 2 | 5999351.90422 | 2095271.3522 | 37.7331785137649 | -122.444626815895 | (37.7331785137649, -122.444626815895) | ||||
157877 | 157877 | 210853 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 179 Hamerton Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 5ft | 6001331.13679 | 2095231.8134599999 | 37.733182692031896 | -122.43778125741501 | (37.7331826920319, -122.437781257415) | |||
116414 | 116414 | 98290 | Significant Tree 6 | Olea europaea :: Olive Tree 41 | 300 Mangels Ave | 6 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 01/24/2012 12:00:00 AM | Permit Number 768637 | 5999381.8 | 2095276.6 | 37.7331946288913 | -122.444523835506 | (37.7331946288913, -122.444523835506) | |||
119061 | 119061 | 98288 | Significant Tree 6 | Olea europaea :: Olive Tree 41 | 300 Mangels Ave | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 01/24/2012 12:00:00 AM | Permit Number 768637 | 5999381.8 | 2095276.6 | 37.7331946288913 | -122.444523835506 | (37.7331946288913, -122.444523835506) | |||
127682 | 127682 | 98289 | Significant Tree 6 | Olea europaea :: Olive Tree 41 | 300 Mangels Ave | 5 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 01/24/2012 12:00:00 AM | Permit Number 768637 | 5999381.8 | 2095276.6 | 37.7331946288913 | -122.444523835506 | (37.7331946288913, -122.444523835506) | |||
187985 | 187985 | 177913 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 2924 21st Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | Width 8ft | 5990007.1003 | 2095790.68963 | 37.7340668092368 | -122.476971913545 | (37.7340668092368, -122.476971913545) | |||
25936 | 25936 | 210838 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 459 Hazelwood Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 3ft | 5995438.73644 | 2095838.0782299999 | 37.7345105311276 | -122.458196607982 | (37.7345105311276, -122.458196607982) | |||
42792 | 42792 | 194229 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 7 Hawkins Ln | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 5ft | 6016979.331809999 | 2095396.8970400002 | 37.734513351414705 | -122.38369217597601 | (37.7345133514147, -122.383692175976) | |||
169950 | 169950 | 194228 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 9 Hawkins Ln | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 5ft | 6016962.87933 | 2095412.7362900001 | 37.7345559334103 | -122.38375016066001 | (37.7345559334103, -122.38375016066) | |||
61673 | 61673 | 194226 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 2 Jakey Ct | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 6ft | 6016841.98922 | 2095417.85433 | 37.734563303344295 | -122.38416847851101 | (37.7345633033443, -122.384168478511) | |||
152408 | 152408 | 194227 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 8 Jakey Ct | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | Width 6ft | 6016817.60054 | 2095485.74545 | 37.7347483703482 | -122.384257525772 | (37.7347483703482, -122.384257525772) | |||
29804 | 29804 | 194225 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 9 Jakey Ct | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 3ft | 6016755.26705 | 2095536.04747 | 37.734883042913395 | -122.384476538576 | (37.7348830429134, -122.384476538576) | |||
35401 | 35401 | 194224 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 11 Jakey Ct | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 3ft | 6016749.98334 | 2095555.73275 | 37.7349368025769 | -122.384496177064 | (37.7349368025769, -122.384496177064) | |||
170909 | 170909 | 194233 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 78 Hawkins Ln | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 2ft | 6016686.67059 | 2095602.00775 | 37.735060363144605 | -122.38471829610701 | (37.7350603631446, -122.384718296107) | |||
179901 | 179901 | 194232 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 70 Hawkins Ln | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 5ft | 6016747.54449 | 2095620.76311 | 37.7351152280806 | -122.38450913719 | (37.7351152280806, -122.38450913719) | |||
65635 | 65635 | 194231 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 62 Hawkins Ln | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 11 | Width 5ft | 6016795.73668 | 2095634.4055 | 37.7351553522317 | -122.384343467669 | (37.7351553522317, -122.384343467669) | |||
56125 | 56125 | 194230 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 58 Hawkins Ln | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 4ft | 6016826.40406 | 2095640.34928 | 37.7351733683505 | -122.38423785221902 | (37.7351733683505, -122.384237852219) | |||
44540 | 44540 | 194234 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 21 Hillview Ct | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 7ft | 6016584.85791 | 2095721.5603900002 | 37.7353829994301 | -122.385078629298 | (37.7353829994301, -122.385078629298) | |||
50639 | 50639 | 194235 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 19 Hillview Ct | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 7ft | 6016602.67648 | 2095728.9552900002 | 37.7354042899791 | -122.385017538329 | (37.7354042899791, -122.385017538329) | |||
63902 | 63902 | 194236 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 17 Hillview Ct | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 7ft | 6016647.59382 | 2095743.55851 | 37.7354468719595 | -122.384863257848 | (37.7354468719595, -122.384863257848) | |||
26262 | 26262 | 194237 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 11 Hillview Ct | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | Width 3ft | 6016697.0495 | 2095760.45578 | 37.735496003732 | -122.38469344603901 | (37.735496003732, -122.384693446039) | |||
183369 | 183369 | 194238 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 6 Hillview Ct | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 11 | Width 7ft | 6016710.45664 | 2095786.72783 | 37.735568882989796 | -122.384648921526 | (37.7355688829898, -122.384648921526) | |||
61547 | 61547 | 194239 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 17 Mabrey Ct | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 5ft | 6016431.077330001 | 2095866.9452 | 37.7357736892058 | -122.385620440254 | (37.7357736892058, -122.385620440254) | |||
74426 | 74426 | 194240 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 17 Mabrey Ct | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 4ft | 6016449.3803900005 | 2095875.6026700002 | 37.735798473604795 | -122.385557761994 | (37.7357984736048, -122.385557761994) | |||
168379 | 168379 | 194241 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 4 Mabrey Ct | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | Width 6ft | 6016531.12407 | 2095935.7497 | 37.735968147815704 | -122.385279329202 | (37.7359681478157, -122.385279329202) | |||
165957 | 165957 | 210839 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 44 Molimo Dr | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 3ft | 5998761.631469999 | 2096521.8618 | 37.7365784160531 | -122.44675748696599 | (37.7365784160531, -122.446757486966) | |||
156868 | 156868 | 185356 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 2601 Sunset Blvd | 81 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 0ft | 5985014.265 | 2096945.9513 | 37.736947940348294 | -122.49431857261001 | (37.7369479403483, -122.49431857261) | |||
45237 | 45237 | 185266 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 2301 Vicente St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 13 | Width 0ft | 5985748.3724 | 2097496.5905 | 37.7385027823228 | -122.491820997516 | (37.7385027823228, -122.491820997516) | |||
179104 | 179104 | 187244 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 2401 Sunset Blvd | 27 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 2 | Width 0ft | 5984957.2356 | 2098537.5785 | 37.7413147833906 | -122.494633049632 | (37.7413147833906, -122.494633049632) | |||
76535 | 76535 | 187242 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 2401 Sunset Blvd | 25 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 0ft | 5984947.0235 | 2098562.0875 | 37.7413814807711 | -122.494670165431 | (37.7413814807711, -122.494670165431) | |||
130341 | 130341 | 247057 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 5399 Diamond Heights Blvd | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | 6002040.3049 | 2098349.1442299997 | 37.741782460002206 | -122.43555240912201 | (37.7417824600022, -122.435552409122) | ||||
168303 | 168303 | 187200 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 2301 Sunset Blvd | 62 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 0ft | 5984910.7598 | 2099021.3208 | 37.7426402887161 | -122.49482940193998 | (37.7426402887161, -122.49482940194) | |||
32457 | 32457 | 246727 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 159 Ripley St | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 12 | Width 3ft | 6008928.07801 | 2099130.49875 | 37.7443166847779 | -122.41179187100401 | (37.7443166847779, -122.411791871004) | |||
24257 | 24257 | 246725 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 159 Ripley St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 12 | Width 3ft | 6008962.35356 | 2099130.96939 | 37.744319899838295 | -122.411673386218 | (37.7443198998383, -122.411673386218) | |||
58363 | 58363 | 246726 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 159 Ripley St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 12 | Width 3ft | 6008943.04853 | 2099131.53117 | 37.7443203594052 | -122.41174017886001 | (37.7443203594052, -122.41174017886) | |||
70968 | 70968 | 233063 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 1407 Douglass St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 10ft | 6001406.76989 | 2099594.91194 | 37.745167041419 | -122.437832165315 | (37.745167041419, -122.437832165315) | |||
162025 | 162025 | 233125 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 590 Duncan St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 12 | Width 5ft | 6002801.85343 | 2099797.0474799997 | 37.74580128919229 | -122.43302265039301 | (37.7458012891923, -122.433022650393) | |||
53554 | 53554 | 185769 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 2162 42nd Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 2 | Width 0ft | 5983287.4484 | 2100417.9653 | 37.7463799348929 | -122.500545498316 | (37.7463799348929, -122.500545498316) | |||
84812 | 84812 | 96294 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 417 Dewey Blvd | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 04/25/2011 12:00:00 AM | 3x3 | Permit Number 57003 | 5995136.0 | 2100316.9 | 37.7467908665237 | -122.45956754031602 | (37.7467908665237, -122.459567540316) | ||
64945 | 64945 | 233073 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 4379 Cesar Chavez St | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | 6001415.66952 | 2100249.72902 | 37.746965520055795 | -122.43784828388 | (37.7469655200558, -122.43784828388) | ||||
70603 | 70603 | 233075 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 4379 Cesar Chavez St | 5 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | 6001421.5597 | 2100250.4049 | 37.7469677107999 | -122.437827964602 | (37.7469677107999, -122.437827964602) | ||||
34890 | 34890 | 233078 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 4379 Cesar Chavez St | 8 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | 6001429.57501 | 2100250.5048599998 | 37.7469684410418 | -122.437800255583 | (37.7469684410418, -122.437800255583) | ||||
29269 | 29269 | 233076 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 4379 Cesar Chavez St | 6 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | 6001425.33603 | 2100252.18871 | 37.7469728234536 | -122.437815034154 | (37.7469728234536, -122.437815034154) | ||||
62762 | 62762 | 233077 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 4379 Cesar Chavez St | 7 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | 6001428.84563 | 2100253.97771 | 37.74697793518929 | -122.437803026403 | (37.7469779351893, -122.437803026403) | ||||
186754 | 186754 | 233079 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 4379 Cesar Chavez St | 9 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | 6001435.52575 | 2100254.1053299997 | 37.7469786654515 | -122.437779936321 | (37.7469786654515, -122.437779936321) | ||||
166266 | 166266 | 233074 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 4379 Cesar Chavez St | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | 6001421.11934 | 2100254.93591 | 37.7469801268377 | -122.437829811798 | (37.7469801268377, -122.437829811798) | ||||
150016 | 150016 | 233072 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 4379 Cesar Chavez St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | 6001415.52367 | 2100255.5837 | 37.7469815873239 | -122.43784920748399 | (37.7469815873239, -122.437849207484) | ||||
38163 | 38163 | 194192 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 1601 Kansas St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 9ft | 6011834.442419999 | 2100473.73914 | 37.748167551187 | -122.401836621487 | (37.748167551187, -122.401836621487) | |||
171948 | 171948 | 194193 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 1601 Kansas St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 9ft | 6011834.442419999 | 2100473.73914 | 37.748167551187 | -122.401836621487 | (37.748167551187, -122.401836621487) | |||
60762 | 60762 | 210584 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 2090 17th Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 5ft | 5991019.92015 | 2101200.62469 | 37.7489798053925 | -122.47386486469101 | (37.7489798053925, -122.473864864691) | |||
185004 | 185004 | 186299 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 1800 Sunset Blvd | 37 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 0ft | 5985021.1385 | 2102711.497 | 37.7527789669048 | -122.49471975093701 | (37.7527789669048, -122.494719750937) | |||
76965 | 76965 | 184009 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 1600 Sunset Blvd | 8 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 0ft | 5984939.2377 | 2103728.7585 | 37.755567292052795 | -122.495077980088 | (37.7555672920528, -122.495077980088) | |||
147236 | 147236 | 184010 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 1600 Sunset Blvd | 9 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 2 | Width 0ft | 5984951.0048 | 2103730.9648 | 37.755574038818104 | -122.49503744907301 | (37.7555740388181, -122.495037449073) | |||
130267 | 130267 | 184018 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 1600 Sunset Blvd | 18 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 0ft | 5984912.6418 | 2103753.8138 | 37.7556345299307 | -122.495171803184 | (37.7556345299307, -122.495171803184) | |||
39133 | 39133 | 184025 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 1600 Sunset Blvd | 25 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 0ft | 5984931.5337 | 2103784.5063 | 37.7557199090675 | -122.495108733182 | (37.7557199090675, -122.495108733182) | |||
133852 | 133852 | 184026 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 1600 Sunset Blvd | 26 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 0ft | 5984920.3345 | 2103785.5463 | 37.7557221089671 | -122.495147539697 | (37.7557221089671, -122.495147539697) | |||
137954 | 137954 | 184027 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 1600 Sunset Blvd | 27 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 0ft | 5984931.8298 | 2103786.2121 | 37.7557246100571 | -122.495107834969 | (37.7557246100571, -122.495107834969) | |||
147099 | 147099 | 184031 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 1600 Sunset Blvd | 31 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 0ft | 5984927.2534 | 2103793.0767 | 37.755743190427204 | -122.495124167563 | (37.7557431904272, -122.495124167563) | |||
173503 | 173503 | 184034 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 1600 Sunset Blvd | 34 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 0ft | 5984925.6803 | 2103804.9468 | 37.7557756903402 | -122.49513048303801 | (37.7557756903402, -122.495130483038) | |||
167786 | 167786 | 184036 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 1600 Sunset Blvd | 36 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 0ft | 5984928.8265 | 2103810.0952 | 37.7557900106144 | -122.49511998225799 | (37.7557900106144, -122.495119982258) | |||
59223 | 59223 | 184039 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 1600 Sunset Blvd | 39 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 0ft | 5984935.4051 | 2103815.5297 | 37.755805317385004 | -122.4950976324 | (37.755805317385, -122.4950976324) | |||
133187 | 133187 | 210586 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 1677 16th Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 20 | Width 5ft | 5991138.28819 | 2103959.4374700002 | 37.7565616379133 | -122.47365677234 | (37.7565616379133, -122.47365677234) | |||
131401 | 131401 | 210585 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 1677 16th Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 21 | Width 5ft | 5991143.28102 | 2103974.0449900003 | 37.756602035466706 | -122.47364057105499 | (37.7566020354667, -122.473640571055) | |||
44949 | 44949 | 194175 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 651 Missouri St | 7 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | 6013644.331680001 | 2103874.0702400003 | 37.7576049693161 | -122.39581626740299 | (37.7576049693161, -122.395816267403) | ||||
160594 | 160594 | 194176 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 651 Missouri St | 14 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | 6013621.312469999 | 2103918.9432599996 | 37.7577269002821 | -122.395899022122 | (37.7577269002821, -122.395899022122) | ||||
149190 | 149190 | 194177 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 651 Missouri St | 19 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | 6013615.77637 | 2103967.79396 | 37.7578607257013 | -122.395921591509 | (37.7578607257013, -122.395921591509) | ||||
25290 | 25290 | 233726 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 84 Seward St | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 13 | Width 3ft | 6000741.8111 | 2104532.41656 | 37.7586864040831 | -122.44048553140699 | (37.7586864040831, -122.440485531407) |
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");