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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 28137 | 28137 | 131814 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 145 Capra Way | 5 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 8ft | 6001091.88484 | 2120522.1645299997 | 37.802610106719996 | -122.440421585107 | (37.80261010672, -122.440421585107) | |||
| 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) | ||||
| 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) | |||
| 30412 | 30412 | 131862 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 3640 Lyon St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 7ft | 5998877.1278 | 2121309.5311 | 37.8046456466411 | -122.448142451907 | (37.8046456466411, -122.448142451907) | |||
| 30422 | 30422 | 233781 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 10 Saturn St | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | Width 3ft | 6000622.86001 | 2106032.19557 | 37.762797654817604 | -122.44100451216299 | (37.7627976548176, -122.441004512163) | |||
| 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) | ||||
| 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) | |||
| 33801 | 33801 | 233782 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 10 Saturn St | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 12 | Width 3ft | 6000620.83206 | 2106027.61812 | 37.762784970763896 | -122.441011197703 | (37.7627849707639, -122.441011197703) | |||
| 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) | ||||
| 34368 | 34368 | 131798 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 3550 Baker St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | Width 5ft | 5999217.12066 | 2121060.49219 | 37.8039812832582 | -122.446947946285 | (37.8039812832582, -122.446947946285) | |||
| 34430 | 34430 | 194169 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 760 San Bruno Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | 6010966.1557599995 | 2104754.45059 | 37.7598729443885 | -122.40514052741699 | (37.7598729443885, -122.405140527417) | ||||
| 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) | ||||
| 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) | ||||
| 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) | |||
| 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) | |||
| 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) | ||||
| 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) | |||
| 39000 | 39000 | 131839 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 2325 Lyon St | 8 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 22 | 5999268.60171 | 2116764.1225799997 | 37.7921875424622 | -122.44646051556002 | (37.7921875424622, -122.44646051556) | ||||
| 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) | |||
| 40992 | 40992 | 131854 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 2561 Chestnut St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 5ft | 5999582.7736599995 | 2119421.9193599997 | 37.7995030857465 | -122.44556468468299 | (37.7995030857465, -122.445564684683) | |||
| 41116 | 41116 | 131906 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 2300 Lyon St | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 11 | Width 5ft | 5999332.61261 | 2116722.13595 | 37.7920759141309 | -122.446236016002 | (37.7920759141309, -122.446236016002) | |||
| 42151 | 42151 | 194170 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 719 Kansas St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 13 | Width 5ft | 6011587.08129 | 2104962.23844 | 37.7604781764565 | -122.403007652101 | (37.7604781764565, -122.403007652101) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | ||||
| 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) | |||
| 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) | |||
| 46748 | 46748 | 131855 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 2561 Chestnut St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 5ft | 5999583.43559 | 2119428.0305 | 37.799519903091394 | -122.445562833863 | (37.7995199030914, -122.445562833863) | |||
| 47979 | 47979 | 131824 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 599 Spruce St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | 5997098.15866 | 2113893.82945 | 37.784182276729204 | -122.45376288107501 | (37.7841822767292, -122.453762881075) | ||||
| 48342 | 48342 | 232992 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 1001 Ashbury St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 14 | Width 4ft | 5999171.207330001 | 2106627.37895 | 37.764349091448395 | -122.446068061312 | (37.7643490914484, -122.446068061312) | |||
| 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) | |||
| 51108 | 51108 | 233783 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 10 Saturn St | 5 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | Width 3ft | 6000623.49703 | 2106025.6379400003 | 37.7627796854658 | -122.441001838469 | (37.7627796854658, -122.441001838469) | |||
| 52217 | 52217 | 131905 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 2300 Lyon St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | Width 5ft | 5999332.9847099995 | 2116712.83345 | 37.7920503931741 | -122.446234059074 | (37.7920503931741, -122.446234059074) | |||
| 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) | |||
| 53000 | 53000 | 131837 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 2325 Lyon St | 6 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 25 | 5999265.5562 | 2116805.62915 | 37.792301334578795 | -122.446474040467 | (37.7923013345788, -122.446474040467) | ||||
| 53099 | 53099 | 131907 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 2300 Lyon St | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 14 | Width 5ft | 5999331.1857 | 2116735.12189 | 37.7921114886004 | -122.446241887658 | (37.7921114886004, -122.446241887658) | |||
| 53553 | 53553 | 131975 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 1256 Lombard St | 8 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 3ft | 6006342.12001 | 2120093.96931 | 37.8017319358348 | -122.42222266674999 | (37.8017319358348, -122.42222266675) | |||
| 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) | |||
| 55633 | 55633 | 233784 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 54 Lower Ter | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 11 | Width 3ft | 6000491.33203 | 2106195.44998 | 37.7632384188315 | -122.44147113529101 | (37.7632384188315, -122.441471135291) | |||
| 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) | |||
| 56677 | 56677 | 131833 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 2325 Lyon St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 24 | 5999254.62224 | 2116910.03669 | 37.7925873855434 | -122.44651938697399 | (37.7925873855434, -122.446519386974) | ||||
| 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) | ||||
| 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) | |||
| 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) | |||
| 60115 | 60115 | 131976 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 12 Hastings Ter | 10 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 2 | 6007259.618480001 | 2119272.09247 | 37.7995269780524 | -122.418989364782 | (37.7995269780524, -122.418989364782) | ||||
| 60366 | 60366 | 131908 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 2300 Lyon St | 5 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 5ft | 5999329.15646 | 2116759.94991 | 37.7921795438926 | -122.446250695616 | (37.7921795438926, -122.446250695616) | |||
| 60421 | 60421 | 233779 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 10 Saturn St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 10 | Width 3ft | 6000624.58928 | 2106041.01354 | 37.762821965281 | -122.44099916388001 | (37.762821965281, -122.44099916388) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | ||||
| 63379 | 63379 | 233742 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 3899 19th St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 14 | Width 3ft | 6003711.48611 | 2104766.66572 | 37.7594982463696 | -122.43023175369 | (37.7594982463696, -122.43023175369) | |||
| 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) | |||
| 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) | |||
| 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) | ||||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 68441 | 68441 | 131840 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 3100 Lyon St | 6 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 25 | Width 10ft | 5999063.8869199995 | 2119477.76228 | 37.79962677850121 | -122.447364232598 | (37.7996267785012, -122.447364232598) | |||
| 68799 | 68799 | 194163 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 2000 18th St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | 6011751.89319 | 2105625.22058 | 37.7623077797072 | -122.40248426014999 | (37.7623077797072, -122.40248426015) | ||||
| 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) | |||
| 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) | ||||
| 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) | |||
| 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) | |||
| 73130 | 73130 | 131832 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 2325 Lyon St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 21 | 5999253.705019999 | 2116932.2658599997 | 37.7926483685714 | -122.446524160568 | (37.7926483685714, -122.446524160568) | ||||
| 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) | |||
| 74510 | 74510 | 131861 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 3640 Lyon St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 9ft | 5998876.901959999 | 2121298.6839099997 | 37.8046158502946 | -122.448142451919 | (37.8046158502946, -122.448142451919) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | ||
| 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) |
| 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) | ||||
| 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) | |||
| 118484 | 118484 | 132009 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 14 Havens St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 12 | 6007582.42635 | 2119387.53409 | 37.7998621238889 | -122.41788051869 | (37.7998621238889, -122.41788051869) | ||||
| 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) | |||
| 129801 | 129801 | 233780 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 10 Saturn St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | Width 3ft | 6000618.75311 | 2106039.2097 | 37.7628166799724 | -122.44101921967501 | (37.7628166799724, -122.441019219675) | |||
| 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) | |||
| 130315 | 130315 | 131904 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 2300 Lyon St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 15 | Width 5ft | 5999334.39992 | 2116699.28439 | 37.792013271856796 | -122.446228187384 | (37.7920132718568, -122.446228187384) | |||
| 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) | ||||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | ||||
| 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) | |||
| 133878 | 133878 | 132011 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 43 Havens St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 10 | 6007585.3855 | 2119382.38752 | 37.799848159233 | -122.41786991387899 | (37.799848159233, -122.417869913879) | ||||
| 135922 | 135922 | 233785 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 54 Lower Ter | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 11 | Width 3ft | 6000482.28178 | 2106206.41652 | 37.763268014640104 | -122.441503224013 | (37.7632680146401, -122.441503224013) | |||
| 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) | ||||
| 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) |
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");