Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, qSiteInfo, PlantType, qCaretaker, qCareAssistant, DBH
| Link | rowid ▲ | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 189003 | 189003 | 198354 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 529 Minna St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6010061.1102599995 | 2112105.44077 | 37.7800064312917 | -122.408789271213 | (37.7800064312917, -122.408789271213) | |||
| 188968 | 188968 | 180471 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 599 University St | 39 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6008133.97671 | 2092747.70208 | 37.7267463349569 | -122.414086246606 | (37.7267463349569, -122.414086246606) | |||
| 188836 | 188836 | 180410 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 2 Still St | 10 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 8ft | 6003389.548769999 | 2094727.9749900002 | 37.7319160967549 | -122.43062883406601 | (37.7319160967549, -122.430628834066) | |||
| 188649 | 188649 | 123336 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 723 04th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 1 | Width 4ft | 5994711.02171 | 2110605.04952 | 37.7750150216931 | -122.461782919201 | (37.7750150216931, -122.461782919201) | |||
| 188175 | 188175 | 198336 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 474 Natoma St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 2ft | 6010520.61484 | 2112310.90634 | 37.7805963181954 | -122.407214118563 | (37.7805963181954, -122.407214118563) | |||
| 188081 | 188081 | 47192 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 383 28th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/08/2002 12:00:00 AM | 8 | Permit Number 45152 | 5987134.96931 | 2113380.92602 | 37.782197756171705 | -122.488193808962 | (37.7821977561717, -122.488193808962) | |
| 187971 | 187971 | 180476 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1138 Bacon St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 2ft | 6008061.923909999 | 2092076.5671299999 | 37.724899494409705 | -122.41428786739999 | (37.7248994944097, -122.4142878674) | |||
| 187916 | 187916 | 123814 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1951 Anza St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 5992603.65065 | 2112025.47068 | 37.7787935752431 | -122.469176110583 | (37.7787935752431, -122.469176110583) | |||
| 187872 | 187872 | 136933 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 2395 Francisco St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 5999921.83043 | 2119840.52401 | 37.8006718131986 | -122.44442153123998 | (37.8006718131986, -122.44442153124) | |||
| 187797 | 187797 | 219451 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 51 Geneva Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 5998010.24374 | 2091127.2252200001 | 37.7217230655433 | -122.44896685955099 | (37.7217230655433, -122.448966859551) | |||
| 187668 | 187668 | 180443 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 599 University St | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6008502.54989 | 2091553.3243 | 37.7234875219066 | -122.412727694727 | (37.7234875219066, -122.412727694727) | |||
| 187580 | 187580 | 242347 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1338 Stevenson St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 2ft | 6006258.64946 | 2108864.05359 | 37.7708926495153 | -122.42171341936199 | (37.7708926495153, -122.421713419362) | |||
| 187454 | 187454 | 198368 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 413 Minna St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6011301.83803 | 2113291.74738 | 37.7833331683237 | -122.404580546568 | (37.7833331683237, -122.404580546568) | |||
| 187335 | 187335 | 33110 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 2626 Filbert St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/05/1996 12:00:00 AM | 9 | Permit Number 37348 | 6000381.41365 | 2118563.70291 | 37.7971922129921 | -122.442739455458 | (37.7971922129921, -122.442739455458) | |
| 187128 | 187128 | 78262 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 501 Wayland St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/30/2000 12:00:00 AM | 6 | 6010118.26182 | 2092179.1105400003 | 37.725296353538795 | -122.40718653543699 | (37.7252963535388, -122.407186535437) | ||
| 186958 | 186958 | 136934 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 685 Marina Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 5999739.15861 | 2121538.2964 | 37.805323015109 | -122.445175778246 | (37.805323015109, -122.445175778246) | |||
| 186938 | 186938 | 180457 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 599 University St | 25 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6008281.899180001 | 2092268.5986400002 | 37.725439126312104 | -122.413541011012 | (37.7254391263121, -122.413541011012) | |||
| 186784 | 186784 | 52475 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 576 Funston Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/27/2005 12:00:00 AM | 3 | 3x3 | Permit Number 48585 | 5991930.93358 | 2111531.3322 | 37.7773979112296 | -122.471467265516 | (37.7773979112296, -122.471467265516) |
| 186093 | 186093 | 219431 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 2606 16th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 5991446.11027 | 2097653.6423299997 | 37.7392653798979 | -122.47213260314301 | (37.7392653798979, -122.472132603143) | |||
| 186062 | 186062 | 198417 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1062 Key Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 6013234.80615 | 2089878.55725 | 37.719153420980604 | -122.39625170116301 | (37.7191534209806, -122.396251701163) | |||
| 185956 | 185956 | 33282 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1250 Jones St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/13/1996 12:00:00 AM | 4 | Permit Number 37445 | 6008545.83527 | 2116894.20233 | 37.793070222573 | -122.41437023629601 | (37.793070222573, -122.414370236296) | |
| 185852 | 185852 | 180408 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 141 Rousseau St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 7ft | 6003605.879 | 2094702.80598 | 37.731859241593106 | -122.429879140314 | (37.7318592415931, -122.429879140314) | |||
| 185844 | 185844 | 68890 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 35 Exeter St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/29/1993 12:00:00 AM | 8 | Permit Number 32862 | 6012596.9510699995 | 2091063.5496200002 | 37.7223716575091 | -122.398539644797 | (37.7223716575091, -122.398539644797) | |
| 185690 | 185690 | 136955 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 700 Grant Ave | 5 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 2 | Width 3ft | 6010930.30149 | 2117074.44992 | 37.793698797424796 | -122.406132508429 | (37.7936987974248, -122.406132508429) | |||
| 185243 | 185243 | 72258 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 230 Paris St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/06/1996 12:00:00 AM | 11 | 6002786.80425 | 2092214.2025900001 | 37.7249796797621 | -122.432533160192 | (37.7249796797621, -122.432533160192) | ||
| 184893 | 184893 | 31070 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1564 15th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/21/1995 12:00:00 AM | 6 | Permit Number 34815 | 6007025.21952 | 2107350.5984 | 37.7667802566181 | -122.41895446839199 | (37.7667802566181, -122.418954468392) | |
| 184889 | 184889 | 136921 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 3000 Lyon St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 5999088.66759 | 2119114.7453799997 | 37.798631447529296 | -122.447252341645 | (37.7986314475293, -122.447252341645) | |||
| 184874 | 184874 | 123811 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 2001 Anza St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 5992437.5114 | 2112016.8247599998 | 37.778760234483705 | -122.469750216689 | (37.7787602344837, -122.469750216689) | |||
| 184538 | 184538 | 100471 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 2 Crane St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/22/2012 12:00:00 AM | 2 | 3x3 | Permit Number 769206 | 6012374.98009 | 2091340.69375 | 37.723120270254 | -122.39932639780899 | (37.723120270254, -122.399326397809) | |
| 184532 | 184532 | 180425 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 223 San Juan Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6001022.23935 | 2092393.12338 | 37.7253707319678 | -122.43864586561001 | (37.7253707319678, -122.43864586561) | |||
| 184495 | 184495 | 242349 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 70 McCoppin St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 4ft | 6006130.70544 | 2109162.10737 | 37.7717038181943 | -122.422177160163 | (37.7717038181943, -122.422177160163) | |||
| 184466 | 184466 | 198267 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 401 16th St | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 5ft | 6015536.948369999 | 2107177.2535099997 | 37.7667799049876 | -122.389501454631 | (37.7667799049876, -122.389501454631) | |||
| 184260 | 184260 | 218161 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1400 Portola Dr | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 2 | Width 5ft | 5993069.62325 | 2097569.10976 | 37.7391270938355 | -122.466513125474 | (37.7391270938355, -122.466513125474) | |||
| 184169 | 184169 | 180446 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 599 University St | 14 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6008445.91914 | 2091731.3401099998 | 37.723973136934205 | -122.412936037975 | (37.7239731369342, -122.412936037975) | |||
| 184089 | 184089 | 180430 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 122 Ocean Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6000838.328869999 | 2091757.95651 | 37.723616244584704 | -122.43923612035299 | (37.7236162445847, -122.439236120353) | |||
| 183910 | 183910 | 219434 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1247 11th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 5992662.02386 | 2106946.976 | 37.764852763058705 | -122.46860456367399 | (37.7648527630587, -122.468604563674) | |||
| 183887 | 183887 | 180412 | DPW Maintained 3 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1104x Alemany Blvd | 2 | Median : Yard 3 | Tree 1 | DPW 2 | 1 | Width 10ft | 6003814.30975 | 2094445.54262 | 37.7311646556118 | -122.42914021505501 | (37.7311646556118, -122.429140215055) | |||
| 183751 | 183751 | 198375 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 413 Minna St | 14 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6011427.189130001 | 2113412.24686 | 37.7836710364202 | -122.40415536240101 | (37.7836710364202, -122.404155362401) | |||
| 183598 | 183598 | 219453 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 51 Geneva Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 5997974.85097 | 2091146.69585 | 37.7217745031653 | -122.449090604454 | (37.7217745031653, -122.449090604454) | |||
| 183492 | 183492 | 198353 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 529 Minna St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6010041.14992 | 2112083.59388 | 37.7799453268562 | -122.408856781511 | (37.7799453268562, -122.408856781511) | |||
| 183395 | 183395 | 198297 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 500 Amador St | 18 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 2 | Width 8ft | 6017533.81233 | 2099583.55419 | 37.7460397048816 | -122.382066271836 | (37.7460397048816, -122.382066271836) | |||
| 183310 | 183310 | 198370 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 413 Minna St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6011333.5587 | 2113320.1137599996 | 37.7834128284905 | -122.404472802393 | (37.7834128284905, -122.404472802393) | |||
| 183248 | 183248 | 136920 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 207 Maple St | 2 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 8 | Width 4ft | 5996591.90102 | 2115549.28793 | 37.788698686447894 | -122.45563404108499 | (37.7886986864479, -122.455634041085) | |||
| 183240 | 183240 | 198313 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 166 South Park | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 2ft | 6014097.81896 | 2112386.50971 | 37.7810034565764 | -122.39484406791 | (37.7810034565764, -122.39484406791) | |||
| 183009 | 183009 | 52766 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 117 Trenton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/04/2006 12:00:00 AM | 4 | Permit Number 48808 | 6010071.7871900005 | 2117939.89762 | 37.7960270495675 | -122.409164153622 | (37.7960270495675, -122.409164153622) | ||
| 182709 | 182709 | 180445 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 599 University St | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6008486.19305 | 2091610.48343 | 37.723643550705 | -122.412788276664 | (37.723643550705, -122.412788276664) | |||
| 182428 | 182428 | 111054 | DPW Maintained 3 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 638 Balboa St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 1 | 3x3 | 5993558.15565 | 2111433.38928 | 37.777222987024004 | -122.465831098866 | (37.777222987024, -122.465831098866) | |||
| 182316 | 182316 | 219430 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 2282 18th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 5990750.15323 | 2099879.22628 | 37.745335960182295 | -122.47470128006 | (37.7453359601823, -122.47470128006) | |||
| 182275 | 182275 | 136954 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 130 Chestnut St | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 6011359.28517 | 2121128.07702 | 37.8048530581732 | -122.404933719313 | (37.8048530581732, -122.404933719313) | |||
| 182205 | 182205 | 242345 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 33 Digby St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | Width 2ft | 6003025.15888 | 2097332.31594 | 37.7390463716034 | -122.43207451582501 | (37.7390463716034, -122.432074515825) | |||
| 181939 | 181939 | 82808 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 637 10th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/30/2005 12:00:00 AM | 4 | 5992833.07706 | 2111118.80762 | 37.776317378073294 | -122.468316464164 | (37.7763173780733, -122.468316464164) | ||
| 181929 | 181929 | 74171 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 466 Clementina St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/09/1995 12:00:00 AM | 1 | 6011049.67315 | 2111947.37062 | 37.7796277285636 | -122.405358235294 | (37.7796277285636, -122.405358235294) | ||
| 181768 | 181768 | 44347 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 638 Minna St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/14/2001 12:00:00 AM | 2 | Permit Number 43729 | 6009245.86368 | 2111366.87268 | 37.7779328014898 | -122.411557389874 | (37.7779328014898, -122.411557389874) | ||
| 181702 | 181702 | 70405 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 225 Oxford St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/21/1994 12:00:00 AM | 8 | 6006525.54367 | 2092869.6574799998 | 37.726990725739 | -122.41965521291999 | (37.726990725739, -122.41965521292) | ||
| 181696 | 181696 | 218773 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1831 17th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 2ft | 5990912.15705 | 2102928.22984 | 37.7537171146574 | -122.474363558528 | (37.7537171146574, -122.474363558528) | |||
| 181510 | 181510 | 180447 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 599 University St | 15 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 4ft | 6008436.67038 | 2091759.83513 | 37.7240508590526 | -122.412970023366 | (37.7240508590526, -122.412970023366) | |||
| 181380 | 181380 | 198379 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 413 Minna St | 18 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6011483.05552 | 2113458.79622 | 37.783801971433 | -122.403965361713 | (37.783801971433, -122.403965361713) | |||
| 181344 | 181344 | 219425 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1351 Funston Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 5992072.68272 | 2106101.95899 | 37.7624985088134 | -122.470581374239 | (37.7624985088134, -122.470581374239) | |||
| 181292 | 181292 | 242874 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 62 Dorland St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6005180.17722 | 2105756.65507 | 37.7622996012591 | -122.425222734963 | (37.7622996012591, -122.425222734963) | |||
| 180988 | 180988 | 198416 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1062 Key Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 6013254.09143 | 2089864.5252900003 | 37.7191159651107 | -122.396184055957 | (37.7191159651107, -122.396184055957) | |||
| 180922 | 180922 | 198304 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 199 New Montgomery St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 4ft | 6012859.7617 | 2114427.83429 | 37.7865395445998 | -122.39927048966801 | (37.7865395445998, -122.399270489668) | |||
| 180856 | 180856 | 72281 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 730 42nd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/20/1996 12:00:00 AM | 8 | 5982929.242880001 | 2110803.7534 | 37.7748753302021 | -122.502552686167 | (37.7748753302021, -122.502552686167) | ||
| 180617 | 180617 | 180455 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 599 University St | 23 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6008364.39889 | 2091998.61159 | 37.7247024313603 | -122.413236732598 | (37.7247024313603, -122.413236732598) | |||
| 180303 | 180303 | 180413 | DPW Maintained 3 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1104x Alemany Blvd | 3 | Median : Yard 3 | Tree 1 | DPW 2 | 1 | Width 10ft | 6003786.93346 | 2094435.4492400002 | 37.731135391684 | -122.42923414026001 | (37.731135391684, -122.42923414026) | |||
| 179921 | 179921 | 198363 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 413 Minna St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6011210.39176 | 2113208.2403 | 37.7830987663473 | -122.404891034816 | (37.7830987663473, -122.404891034816) | |||
| 179834 | 179834 | 67320 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 641 Balboa St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/15/1992 12:00:00 AM | 1 | Permit Number 30802 | 5993536.200019999 | 2111377.87802 | 37.777069301498706 | -122.465903015306 | (37.7770693014987, -122.465903015306) | |
| 179785 | 179785 | 180475 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1138 Bacon St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 2ft | 6008076.47647 | 2092081.3673900003 | 37.724913492352 | -122.414237900184 | (37.724913492352, -122.414237900184) | |||
| 179775 | 179775 | 242346 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1353 Stevenson St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6006282.631569999 | 2108802.50666 | 37.7707250086772 | -122.421626092471 | (37.7707250086772, -122.421626092471) | |||
| 179692 | 179692 | 246859 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1198 Oak St | 3 | : 4 | Tree 1 | Private 1 | 1 | Width 4ft | 6001348.19607 | 2109746.2469900004 | 37.7730368059387 | -122.43876198966998 | (37.7730368059387, -122.43876198967) | |||
| 179499 | 179499 | 136925 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 2940 Broderick St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6000022.969330001 | 2118690.77856 | 37.7975206885925 | -122.44398889348601 | (37.7975206885925, -122.443988893486) | |||
| 179461 | 179461 | 49307 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1800 San Jose Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/20/2003 12:00:00 AM | 7 | Permit Number 46312 | 6000553.97076 | 2093635.29726 | 37.7287548061895 | -122.440353666507 | (37.7287548061895, -122.440353666507) | ||
| 179406 | 179406 | 136936 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 985 Pine St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6009249.138119999 | 2116000.66803 | 37.790656277621004 | -122.411873588818 | (37.790656277621, -122.411873588818) | |||
| 179035 | 179035 | 136942 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1771 Washington St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 4ft | 6006278.23872 | 2116942.55045 | 37.793075331599496 | -122.42221969987699 | (37.7930753315995, -122.422219699877) | |||
| 178966 | 178966 | 96921 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 3208 Pierce St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/09/2011 12:00:00 AM | 2 | 3x3 | Permit Number 767943 | 6001394.57427 | 2119432.51874 | 37.799635457872704 | -122.43929598102501 | (37.7996354578727, -122.439295981025) | |
| 178463 | 178463 | 180481 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1426 Felton St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6006648.24151 | 2092609.1110599998 | 37.7262822326299 | -122.41921257380599 | (37.7262822326299, -122.419212573806) | |||
| 178227 | 178227 | 242905 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 3699 24th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6005206.83897 | 2101930.88885 | 37.751796449653796 | -122.424858329659 | (37.7517964496538, -122.424858329659) | |||
| 178150 | 178150 | 36730 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 8 South Park | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/26/1998 12:00:00 AM | 2 | Permit Number 39511 | 6014600.478619999 | 2112868.92208 | 37.7823559874826 | -122.393138870561 | (37.7823559874826, -122.393138870561) | |
| 177925 | 177925 | 88053 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 2041 Revere Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/24/2008 12:00:00 AM | 5 | 3x3 | Permit Number 51063 | 6012715.7599599995 | 2096090.00312 | 37.736179884201704 | -122.398481475746 | (37.7361798842017, -122.398481475746) | |
| 177790 | 177790 | 36989 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 711 Lake St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/29/1998 12:00:00 AM | 9 | Permit Number 39610 | 5993273.5401 | 2114815.16246 | 37.7864919948194 | -122.46706159406999 | (37.7864919948194, -122.46706159407) | |
| 177474 | 177474 | 198329 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 436 Minna St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6010620.45963 | 2112673.73039 | 37.781598135086796 | -122.406894285459 | (37.7815981350868, -122.406894285459) | |||
| 177436 | 177436 | 70333 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 143 Goettingen St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/30/1994 12:00:00 AM | 7 | 6009984.51803 | 2093871.67123 | 37.7299362833339 | -122.407768169286 | (37.7299362833339, -122.407768169286) | ||
| 177193 | 177193 | 198397 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 16 Moss St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6010215.848259999 | 2111317.9701799997 | 37.7778528877325 | -122.408198405847 | (37.7778528877325, -122.408198405847) | |||
| 177030 | 177030 | 124216 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 107 Stanyan Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 2ft | 5996487.33444 | 2112259.12921 | 37.7796587851836 | -122.45575789701401 | (37.7796587851836, -122.455757897014) | |||
| 176956 | 176956 | 198345 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 451 Tehama St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 2ft | 6010996.3869 | 2112125.34769 | 37.7801134326192 | -122.405555114895 | (37.7801134326192, -122.405555114895) | |||
| 176772 | 176772 | 120687 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 2040 Balboa St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 5989191.37637 | 2111280.32009 | 37.776549837038495 | -122.48092579961501 | (37.7765498370385, -122.480925799615) | |||
| 176526 | 176526 | 242872 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 2650 21st St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 6ft | 6010155.11126 | 2103998.01915 | 37.7577505794312 | -122.407892205568 | (37.7577505794312, -122.407892205568) | |||
| 176525 | 176525 | 136952 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 685 North Point St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 4ft | 6007607.689119999 | 2121607.56476 | 37.8059591892382 | -122.417950561469 | (37.8059591892382, -122.417950561469) | |||
| 176503 | 176503 | 242348 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 70 McCoppin St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 4ft | 6006148.63629 | 2109163.83557 | 37.7717095747744 | -122.422115258931 | (37.7717095747744, -122.422115258931) | |||
| 176463 | 176463 | 201658 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 100 Dore St | 1 | : 4 | Tree 1 | Private 1 | 5 | Width 2ft | 6009046.738390001 | 2109625.79413 | 37.773141038252604 | -122.412123157881 | (37.7731410382526, -122.412123157881) | |||
| 176442 | 176442 | 97961 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 2280X McKinnon Ave | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/06/2011 12:00:00 AM | 2 | 3x3 | Permit Number 768057 | 6011645.30787 | 2098748.77937 | 37.743420626377294 | -122.402369377168 | (37.7434206263773, -122.402369377168) | |
| 176376 | 176376 | 70562 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 164 South Park | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/23/1994 12:00:00 AM | 8 | 6014127.69322 | 2112419.53716 | 37.7810958034577 | -122.39474303089199 | (37.7810958034577, -122.394743030892) | ||
| 176339 | 176339 | 198348 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 550 Minna St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6009856.94052 | 2111939.21808 | 37.779538585085795 | -122.409483854493 | (37.7795385850858, -122.409483854493) | |||
| 176265 | 176265 | 123810 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 2001 Anza St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 5992451.93386 | 2112017.5162 | 37.77876296659429 | -122.469700374559 | (37.7787629665943, -122.469700374559) | |||
| 176200 | 176200 | 242869 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 348 Church St | 3 | : 4 | Tree 1 | Private 1 | 1 | Width 3ft | 6004153.4659400005 | 2106885.51591 | 37.7653411264215 | -122.428854226135 | (37.7653411264215, -122.428854226135) | |||
| 176191 | 176191 | 242339 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1035 Douglass St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6001342.6727 | 2100671.2124799998 | 37.748118662255294 | -122.438130887736 | (37.7481186622553, -122.438130887736) | |||
| 176102 | 176102 | 180470 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 599 University St | 38 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6008144.58637 | 2092721.9532599999 | 37.7266762301091 | -122.414047748408 | (37.7266762301091, -122.414047748408) | |||
| 176058 | 176058 | 198395 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 120 Minna St | 14 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 2ft | 6010955.650090001 | 2112999.3376599997 | 37.7825109262834 | -122.40575762241998 | (37.7825109262834, -122.40575762242) | |||
| 176029 | 176029 | 198305 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 199 New Montgomery St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 4ft | 6012839.768519999 | 2114446.84253 | 37.786590622517096 | -122.39934099648501 | (37.7865906225171, -122.399340996485) | |||
| 175899 | 175899 | 87748 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 301 14th Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/27/2008 12:00:00 AM | 3 | 3x3 | Permit Number 50407 | 5991513.0366 | 2113287.42682 | 37.7821954806674 | -122.473040988135 | (37.7821954806674, -122.473040988135) | |
| 175859 | 175859 | 136944 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 805 Lombard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6008422.88956 | 2120335.2462 | 37.802511568003396 | -122.415039309443 | (37.8025115680034, -122.415039309443) |
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");