Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, qSiteInfo, qCaretaker, qCareAssistant
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize ▼ | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 23186 | 23186 | 17762 | DPW Maintained 3 | Eucalyptus sideroxylon :: Red Ironbark 36 | 1700 Pine St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 23 | 6005688.226009999 | 2115553.43335 | 37.7892278664309 | -122.424162343438 | (37.7892278664309, -122.424162343438) | ||||
| 25340 | 25340 | 199360 | Undocumented 2 | Eucalyptus sideroxylon :: Red Ironbark 36 | 1451 Rhode Island St | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 19 | 6012046.6036 | 2101626.2388 | 37.7513439035983 | -122.401183943899 | (37.7513439035983, -122.401183943899) | ||||
| 25829 | 25829 | 218789 | Undocumented 2 | Eucalyptus sideroxylon :: Red Ironbark 36 | 380 Monterey Blvd | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 30 | 5999445.613919999 | 2094740.51345 | 37.7317263020196 | -122.44426470386101 | (37.7317263020196, -122.444264703861) | ||||
| 27571 | 27571 | 224007 | Undocumented 2 | Eucalyptus sideroxylon :: Red Ironbark 36 | 1000 San Jose Ave | 28 | Front Yard : Yard 7 | Tree 1 | Private 1 | 16 | 6005150.44635 | 2097206.47879 | 37.7388211148085 | -122.42471728718 | (37.7388211148085, -122.42471728718) | ||||
| 28308 | 28308 | 67884 | Permitted Site 1 | Eucalyptus sideroxylon :: Red Ironbark 36 | 5X Lisbon St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/03/1993 12:00:00 AM | 15 | Permit Number 31577 | 6003921.69231 | 2093425.09481 | 37.72836881267121 | -122.428696258429 | (37.7283688126712, -122.428696258429) | ||
| 28860 | 28860 | 51570 | Permitted Site 1 | Eucalyptus sideroxylon :: Red Ironbark 36 | 227 24th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/04/2005 12:00:00 AM | 17 | Permit Number 47867 | 5988337.51894 | 2114460.53389 | 37.7852321378524 | -122.48411277430401 | (37.7852321378524, -122.484112774304) | |
| 29174 | 29174 | 224014 | Undocumented 2 | Eucalyptus sideroxylon :: Red Ironbark 36 | 1000 San Jose Ave | 87 | Front Yard : Yard 7 | Tree 1 | Private 1 | 16 | 6005008.4122 | 2096950.18798 | 37.7381093751439 | -122.425190143511 | (37.7381093751439, -122.425190143511) | ||||
| 29793 | 29793 | 247852 | Undocumented 2 | Eucalyptus sideroxylon :: Red Ironbark 36 | 80 Bradford St | 1 | Side Yard : Yard 17 | Tree 1 | Private 1 | 27 | 6009577.25002 | 2098193.0016099997 | 37.741778919360705 | -122.409481010838 | (37.7417789193607, -122.409481010838) | ||||
| 30472 | 30472 | 247853 | Undocumented 2 | Eucalyptus sideroxylon :: Red Ironbark 36 | 80 Bradford St | 2 | Side Yard : Yard 17 | Tree 1 | Private 1 | 25 | 6009574.28658 | 2098178.5899099996 | 37.7417391819242 | -122.40949024059401 | (37.7417391819242, -122.409490240594) | ||||
| 31630 | 31630 | 199351 | Undocumented 2 | Eucalyptus sideroxylon :: Red Ironbark 36 | 875 Vermont St | 8 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 19 | 6011310.4458099995 | 2104289.7069599996 | 37.7586161031593 | -122.403917085224 | (37.7586161031593, -122.403917085224) | ||||
| 38019 | 38019 | 224020 | Undocumented 2 | Eucalyptus sideroxylon :: Red Ironbark 36 | 1300 San Jose Ave | 19 | Front Yard : Yard 7 | Tree 1 | Private 1 | 12 | 6003561.5892199995 | 2095667.7300200001 | 37.7345061963941 | -122.430101069605 | (37.7345061963941, -122.430101069605) | ||||
| 39216 | 39216 | 224006 | Undocumented 2 | Eucalyptus sideroxylon :: Red Ironbark 36 | 1000 San Jose Ave | 27 | Front Yard : Yard 7 | Tree 1 | Private 1 | 18 | 6005147.55847 | 2097214.3851400004 | 37.738842660756795 | -122.42472783442601 | (37.7388426607568, -122.424727834426) | ||||
| 39572 | 39572 | 247122 | Undocumented 2 | Eucalyptus sideroxylon :: Red Ironbark 36 | 2301 Castro St | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 16 | 6002767.913930001 | 2098805.6060200003 | 37.743077097036796 | -122.433069184902 | (37.7430770970368, -122.433069184902) | ||||
| 40659 | 40659 | 62578 | Permitted Site 1 | Eucalyptus sideroxylon :: Red Ironbark 36 | 739 Vermont St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/01/1986 12:00:00 AM | 9 | Permit Number 22783 | 6011302.7424099995 | 2104925.74778 | 37.7603620991639 | -122.403988486898 | (37.7603620991639, -122.403988486898) | |
| 41851 | 41851 | 224024 | Undocumented 2 | Eucalyptus sideroxylon :: Red Ironbark 36 | 1300 San Jose Ave | 31 | Front Yard : Yard 7 | Tree 1 | Private 1 | 11 | 6003500.27869 | 2095632.3533400001 | 37.7344055874315 | -122.43031051723801 | (37.7344055874315, -122.430310517238) | ||||
| 47085 | 47085 | 218783 | Undocumented 2 | Eucalyptus sideroxylon :: Red Ironbark 36 | 230 Edna St | 3 | Side Yard : Yard 17 | Tree 1 | Private 1 | 9 | 5998795.47023 | 2095343.3571900001 | 37.7333444548841 | -122.44655572948099 | (37.7333444548841, -122.446555729481) | ||||
| 49495 | 49495 | 224027 | Undocumented 2 | Eucalyptus sideroxylon :: Red Ironbark 36 | 1350 Noe St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 24 | 6003197.19524 | 2100390.33495 | 37.7474527349542 | -122.431697967013 | (37.7474527349542, -122.431697967013) | ||||
| 50076 | 50076 | 58511 | Permitted Site 1 | Eucalyptus sideroxylon :: Red Ironbark 36 | 1430 Waller St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/30/1979 12:00:00 AM | Permit Number 17687 | 5998871.25967783 | 2108358.36156462 | 37.7690847998305 | -122.447230081169 | (37.7690847998305, -122.447230081169) | |||
| 52044 | 52044 | 199349 | Undocumented 2 | Eucalyptus sideroxylon :: Red Ironbark 36 | 1501 25th St | 26 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 13 | 6014246.130480001 | 2101970.67081 | 37.752412103042104 | -122.39360177230199 | (37.7524121030421, -122.393601772302) | ||||
| 52746 | 52746 | 224009 | Undocumented 2 | Eucalyptus sideroxylon :: Red Ironbark 36 | 1000 San Jose Ave | 30 | Front Yard : Yard 7 | Tree 1 | Private 1 | 23 | 6005155.305240001 | 2097189.65421 | 37.738775192731296 | -122.42469929085199 | (37.7387751927313, -122.424699290852) | ||||
| 55714 | 55714 | 107425 | Undocumented 2 | Eucalyptus sideroxylon :: Red Ironbark 36 | 1600X Waller St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5997832.17799 | 2108247.26578 | 37.7687203321672 | -122.450816174345 | (37.7687203321672, -122.450816174345) | |||||
| 56034 | 56034 | 247100 | Undocumented 2 | Eucalyptus sideroxylon :: Red Ironbark 36 | 2301 Castro St | 18 | Front Yard : Yard 7 | Tree 1 | Private 1 | 24 | 6002747.30855 | 2098672.19693 | 37.7427096178655 | -122.433130902689 | (37.7427096178655, -122.433130902689) | ||||
| 56985 | 56985 | 224016 | Undocumented 2 | Eucalyptus sideroxylon :: Red Ironbark 36 | 1000 San Jose Ave | 90 | Front Yard : Yard 7 | Tree 1 | Private 1 | 25 | 6005001.85234 | 2096930.1779200002 | 37.7380540614461 | -122.425211400785 | (37.7380540614461, -122.425211400785) | ||||
| 57543 | 57543 | 224011 | Undocumented 2 | Eucalyptus sideroxylon :: Red Ironbark 36 | 1000 San Jose Ave | 84 | Front Yard : Yard 7 | Tree 1 | Private 1 | 32 | 6005029.023080001 | 2096988.2407799999 | 37.738215023894 | -122.42512158818701 | (37.738215023894, -122.425121588187) | ||||
| 57547 | 57547 | 38224 | Permitted Site 1 | Eucalyptus sideroxylon :: Red Ironbark 36 | 1099 Mississippi St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/05/2002 12:00:00 AM | 14 | Permit Number 40351 | 6014264.59569 | 2102044.43409 | 37.7526156672934 | -122.39354307806101 | (37.7526156672934, -122.393543078061) | |
| 58504 | 58504 | 247099 | Undocumented 2 | Eucalyptus sideroxylon :: Red Ironbark 36 | 2301 Castro St | 17 | Front Yard : Yard 7 | Tree 1 | Private 1 | 22 | 6002747.27026 | 2098651.7988 | 37.742653607170894 | -122.433129577966 | (37.7426536071709, -122.433129577966) | ||||
| 59093 | 59093 | 199361 | Undocumented 2 | Eucalyptus sideroxylon :: Red Ironbark 36 | 1433 Rhode Island St | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 17 | 6012042.82381 | 2101683.55055 | 37.7515010583383 | -122.40120104178999 | (37.7515010583383, -122.40120104179) | ||||
| 60423 | 60423 | 224005 | Undocumented 2 | Eucalyptus sideroxylon :: Red Ironbark 36 | 900 San Bruno Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 15 | 6011012.17375 | 2104008.2643 | 37.7578266557966 | -122.40492883511999 | (37.7578266557966, -122.40492883512) | ||||
| 62464 | 62464 | 62579 | Permitted Site 1 | Eucalyptus sideroxylon :: Red Ironbark 36 | 741 Vermont St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/01/1986 12:00:00 AM | 10 | Permit Number 22784 | 6011303.77085 | 2104898.93824 | 37.7602885436105 | -122.40398304329399 | (37.7602885436105, -122.403983043294) | |
| 70104 | 70104 | 247076 | Undocumented 2 | Eucalyptus sideroxylon :: Red Ironbark 36 | 2401 Castro St | 12 | Front Yard : Yard 7 | Tree 1 | Private 1 | 18 | 6002768.97997 | 2098508.28835 | 37.742260792292704 | -122.43304426108 | (37.7422607922927, -122.43304426108) | ||||
| 70451 | 70451 | 176394 | Undocumented 2 | Eucalyptus sideroxylon :: Red Ironbark 36 | 148 Milton St | 1 | Side Yard : Yard 17 | Tree 1 | Private 1 | 21 | 6003833.54644 | 2094691.18415 | 37.731840220943205 | -122.42909121820801 | (37.7318402209432, -122.429091218208) | ||||
| 74211 | 74211 | 247098 | Undocumented 2 | Eucalyptus sideroxylon :: Red Ironbark 36 | 2301 Castro St | 16 | Front Yard : Yard 7 | Tree 1 | Private 1 | 27 | 6002743.01525 | 2098640.44771 | 37.7426221983472 | -122.433143479687 | (37.7426221983472, -122.433143479687) | ||||
| 78284 | 78284 | 36808 | Permitted Site 1 | Eucalyptus sideroxylon :: Red Ironbark 36 | 1290 Egbert Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/26/1998 12:00:00 AM | Permit Number 39532 | 6014916.278192299 | 2090716.3266444001 | 37.721547191141205 | -122.39049795372 | (37.7215471911412, -122.39049795372) | ||
| 78413 | 78413 | 51528 | Permitted Site 1 | Eucalyptus sideroxylon :: Red Ironbark 36 | 2900 Hawes St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/14/2005 12:00:00 AM | Permit Number 47830 | 6014679.41969777 | 2089453.24857655 | 37.7180658851091 | -122.39122846992599 | (37.7180658851091, -122.391228469926) | |||
| 78803 | 78803 | 105667 | Undocumented 2 | Eucalyptus sideroxylon :: Red Ironbark 36 | 301X DORADO TER | 1 | unknown : Yard 19 | Tree 1 | Private 1 | 5994306.4 | 2092922.0 | 37.726438562961896 | -122.461900058607 | (37.7264385629619, -122.461900058607) | |||||
| 81696 | 81696 | 51527 | Permitted Site 1 | Eucalyptus sideroxylon :: Red Ironbark 36 | 2900 Hawes St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/14/2005 12:00:00 AM | Permit Number 47830 | 6014679.41969777 | 2089453.24857655 | 37.7180658851091 | -122.39122846992599 | (37.7180658851091, -122.391228469926) | |||
| 82185 | 82185 | 111319 | Undocumented 2 | Eucalyptus sideroxylon :: Red Ironbark 36 | 200x PENINSULA AVE | 2 | Unaccepted Street : Yard 14 | Tree 1 | Private 1 | 6012569.0 | 2087626.0 | 37.71293127807179 | -122.398395185538 | (37.7129312780718, -122.398395185538) | |||||
| 83073 | 83073 | 109202 | Undocumented 2 | Eucalyptus sideroxylon :: Red Ironbark 36 | 2401x CASTRO ST | 6 | Median : Yard 3 | Tree 1 | DPW 2 | 6002698.0 | 2098487.0 | 37.7421983129634 | -122.43328816691401 | (37.7421983129634, -122.433288166914) | |||||
| 83231 | 83231 | 36833 | Permitted Site 1 | Eucalyptus sideroxylon :: Red Ironbark 36 | 2715 Ingalls St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/26/1998 12:00:00 AM | Permit Number 39537 | 6015005.69395491 | 2090908.83002417 | 37.7220807273762 | -122.390202307194 | (37.7220807273762, -122.390202307194) | ||
| 83393 | 83393 | 92053 | Significant Tree 6 | Eucalyptus sideroxylon :: Red Ironbark 36 | 1001 Potrero Ave | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | Permit Number 52180 | 6010509.9 | 2103658.3 | 37.7568376430251 | -122.406641253674 | (37.7568376430251, -122.406641253674) | |||||
| 84093 | 84093 | 247077 | Undocumented 2 | Eucalyptus sideroxylon :: Red Ironbark 36 | 2401 Castro St | 13 | Front Yard : Yard 7 | Tree 1 | Private 1 | 16 | 6002764.89351 | 2098516.6039400003 | 37.7422833931736 | -122.433058984778 | (37.7422833931736, -122.433058984778) | ||||
| 84347 | 84347 | 106497 | Permitted Site 1 | Eucalyptus sideroxylon :: Red Ironbark 36 | 1890 Page St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Permit Number 772114 | 5997541.6 | 2108881.8 | 37.770445962098705 | -122.451867038975 | (37.7704459620987, -122.451867038975) | ||||
| 85276 | 85276 | 105668 | Undocumented 2 | Eucalyptus sideroxylon :: Red Ironbark 36 | 301X DORADO TER | 2 | unknown : Yard 19 | Tree 1 | Private 1 | 12 | 5994306.4 | 2092922.0 | 37.726438562961896 | -122.461900058607 | (37.7264385629619, -122.461900058607) | ||||
| 85810 | 85810 | 109204 | Undocumented 2 | Eucalyptus sideroxylon :: Red Ironbark 36 | 2401x CASTRO ST | 8 | Median : Yard 3 | Tree 1 | DPW 2 | 6002698.0 | 2098487.0 | 37.7421983129634 | -122.43328816691401 | (37.7421983129634, -122.433288166914) | |||||
| 86474 | 86474 | 109199 | Undocumented 2 | Eucalyptus sideroxylon :: Red Ironbark 36 | 2401x CASTRO ST | 7 | Median : Yard 3 | Tree 1 | DPW 2 | 6002698.0 | 2098487.0 | 37.7421983129634 | -122.43328816691401 | (37.7421983129634, -122.433288166914) | |||||
| 87976 | 87976 | 111318 | Undocumented 2 | Eucalyptus sideroxylon :: Red Ironbark 36 | 200x PENINSULA AVE | 1 | Unaccepted Street : Yard 14 | Tree 1 | Private 1 | 6012569.0 | 2087626.0 | 37.71293127807179 | -122.398395185538 | (37.7129312780718, -122.398395185538) | |||||
| 89868 | 89868 | 36789 | Permitted Site 1 | Eucalyptus sideroxylon :: Red Ironbark 36 | 1314 Donner Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/26/1998 12:00:00 AM | Permit Number 39526 | 6015468.42166203 | 2090653.62366449 | 37.7214056358126 | -122.388584951991 | (37.7214056358126, -122.388584951991) | ||
| 94007 | 94007 | 112375 | Significant Tree 6 | Eucalyptus sideroxylon :: Red Ironbark 36 | 801 ULLOA ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | MTA 6 | 42 | 5993401.0 | 2098089.0 | 37.7405736985828 | -122.46540514019699 | (37.7405736985828, -122.465405140197) | ||||
| 95397 | 95397 | 105511 | Permitted Site 1 | Eucalyptus sideroxylon :: Red Ironbark 36 | 400X Steiner St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Permit Number 772834 | 6003196.1616 | 2109801.36502 | 37.7732931051579 | -122.432373588443 | (37.7732931051579, -122.432373588443) | ||||
| 95666 | 95666 | 36809 | Permitted Site 1 | Eucalyptus sideroxylon :: Red Ironbark 36 | 1290 Egbert Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/26/1998 12:00:00 AM | Permit Number 39532 | 6014916.278192299 | 2090716.3266444001 | 37.721547191141205 | -122.39049795372 | (37.7215471911412, -122.39049795372) | ||
| 96253 | 96253 | 41569 | Permitted Site 1 | Eucalyptus sideroxylon :: Red Ironbark 36 | 63 Ruth St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/05/2000 12:00:00 AM | Permit Number 42084 | 6001453.1346338 | 2091658.26221962 | 37.723377473003104 | -122.437103713844 | (37.7233774730031, -122.437103713844) | |||
| 96793 | 96793 | 224018 | Undocumented 2 | Eucalyptus sideroxylon :: Red Ironbark 36 | 1300 San Jose Ave | 10 | Front Yard : Yard 7 | Tree 1 | Private 1 | 27 | 6003591.19163 | 2095672.05268 | 37.734519741983 | -122.42999903253299 | (37.734519741983, -122.429999032533) | ||||
| 97104 | 97104 | 50378 | Permitted Site 1 | Eucalyptus sideroxylon :: Red Ironbark 36 | 1620 Montgomery St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/01/2003 12:00:00 AM | Permit Number 47039 | 6011351.83248495 | 2120835.88186523 | 37.804050345434 | -122.404938924734 | (37.804050345434, -122.404938924734) | |||
| 100565 | 100565 | 176384 | Undocumented 2 | Eucalyptus sideroxylon :: Red Ironbark 36 | 199 Peninsula Ave | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 10 | 6012519.05604 | 2087598.31836 | 37.712852487431796 | -122.398565868123 | (37.7128524874318, -122.398565868123) | ||||
| 100592 | 100592 | 116998 | Significant Tree 6 | Eucalyptus sideroxylon :: Red Ironbark 36 | 880x MCALLISTER ST | 1 | Front Yard : Cutout 8 | Tree 1 | Private 1 | 6005306.0 | 2112177.0 | 37.779935428414 | -122.42524444144199 | (37.779935428414, -122.425244441442) | |||||
| 102078 | 102078 | 117000 | Significant Tree 6 | Eucalyptus sideroxylon :: Red Ironbark 36 | 880x MCALLISTER ST | 3 | Front Yard : Cutout 8 | Tree 1 | Private 1 | 6005306.0 | 2112177.0 | 37.779935428414 | -122.42524444144199 | (37.779935428414, -122.425244441442) | |||||
| 102914 | 102914 | 112377 | Property Tree 7 | Eucalyptus sideroxylon :: Red Ironbark 36 | 801 ULLOA ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | MTA 6 | 36 | 5993401.0 | 2098089.0 | 37.7405736985828 | -122.46540514019699 | (37.7405736985828, -122.465405140197) | ||||
| 104633 | 104633 | 99112 | Undocumented 2 | Eucalyptus sideroxylon :: Red Ironbark 36 | 80X Bradford St | 1 | Unaccepted Street : Yard 14 | Tree 1 | Private 1 | 6009564.7 | 2098208.3 | 37.741820222197596 | -122.40952548431801 | (37.7418202221976, -122.409525484318) | |||||
| 105675 | 105675 | 109208 | Undocumented 2 | Eucalyptus sideroxylon :: Red Ironbark 36 | 2401x CASTRO ST | 1 | Median : Yard 3 | Tree 1 | DPW 2 | 6002698.0 | 2098487.0 | 37.7421983129634 | -122.43328816691401 | (37.7421983129634, -122.433288166914) | |||||
| 106969 | 106969 | 99110 | Undocumented 2 | Eucalyptus sideroxylon :: Red Ironbark 36 | 94 Bernal Heights Blvd | 1 | Unaccepted Street : Yard 14 | Tree 1 | Private 1 | 6009548.4 | 2098143.7 | 37.741641931317396 | -122.409577286243 | (37.7416419313174, -122.409577286243) | |||||
| 107199 | 107199 | 112376 | Significant Tree 6 | Eucalyptus sideroxylon :: Red Ironbark 36 | 801 ULLOA ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | MTA 6 | 24 | 5993401.0 | 2098089.0 | 37.7405736985828 | -122.46540514019699 | (37.7405736985828, -122.465405140197) | ||||
| 110332 | 110332 | 109200 | Undocumented 2 | Eucalyptus sideroxylon :: Red Ironbark 36 | 2401x CASTRO ST | 7 | Unaccepted Street : Yard 14 | Tree 1 | DPW 2 | 6002698.0 | 2098487.0 | 37.7421983129634 | -122.43328816691401 | (37.7421983129634, -122.433288166914) | |||||
| 116970 | 116970 | 34459 | Permitted Site 1 | Eucalyptus sideroxylon :: Red Ironbark 36 | 1960 Jones St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/21/2015 12:00:00 AM | Permit Number 42077 | 6008233.26269903 | 2119182.7725058 | 37.7993365057546 | -122.415613869084 | (37.7993365057546, -122.415613869084) | ||
| 117616 | 117616 | 36790 | Permitted Site 1 | Eucalyptus sideroxylon :: Red Ironbark 36 | 1314 Donner Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/26/1998 12:00:00 AM | Permit Number 39526 | 6015468.42166203 | 2090653.62366449 | 37.7214056358126 | -122.388584951991 | (37.7214056358126, -122.388584951991) | ||
| 118269 | 118269 | 109197 | Undocumented 2 | Eucalyptus sideroxylon :: Red Ironbark 36 | 2401x CASTRO ST | 3 | Median : Yard 3 | Tree 1 | DPW 2 | 12 | 6002698.0 | 2098487.0 | 37.7421983129634 | -122.43328816691401 | (37.7421983129634, -122.433288166914) | ||||
| 118995 | 118995 | 97217 | DPW Maintained 3 | Eucalyptus sideroxylon :: Red Ironbark 36 | 300X Claremont Blvd | 4 | Back Yard : Cutout 16 | Tree 1 | DPW for City Agency 10 | 18 | 5993486.0 | 2098110.3 | 37.7406370848463 | -122.465112792055 | (37.7406370848463, -122.465112792055) | ||||
| 122748 | 122748 | 111320 | Undocumented 2 | Eucalyptus sideroxylon :: Red Ironbark 36 | 200x PENINSULA AVE | 3 | Unaccepted Street : Yard 14 | Tree 1 | Private 1 | 6012569.0 | 2087626.0 | 37.71293127807179 | -122.398395185538 | (37.7129312780718, -122.398395185538) | |||||
| 123251 | 123251 | 92054 | Significant Tree 6 | Eucalyptus sideroxylon :: Red Ironbark 36 | 1001 Potrero Ave | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | Permit Number 52180 | 6010509.9 | 2103658.3 | 37.7568376430251 | -122.406641253674 | (37.7568376430251, -122.406641253674) | |||||
| 123260 | 123260 | 109205 | Undocumented 2 | Eucalyptus sideroxylon :: Red Ironbark 36 | 2401x CASTRO ST | 9 | Median : Yard 3 | Tree 1 | DPW 2 | 6002698.0 | 2098487.0 | 37.7421983129634 | -122.43328816691401 | (37.7421983129634, -122.433288166914) | |||||
| 123401 | 123401 | 109201 | Undocumented 2 | Eucalyptus sideroxylon :: Red Ironbark 36 | 2401x CASTRO ST | 4 | Median : Yard 3 | Tree 1 | DPW 2 | 6002698.0 | 2098487.0 | 37.7421983129634 | -122.43328816691401 | (37.7421983129634, -122.433288166914) | |||||
| 123678 | 123678 | 97297 | Permitted Site 1 | Eucalyptus sideroxylon :: Red Ironbark 36 | 450 06th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5994062.8 | 2112448.2 | 37.7800384821655 | -122.46415907596202 | (37.7800384821655, -122.464159075962) | |||||
| 124001 | 124001 | 99698 | Significant Tree 6 | Eucalyptus sideroxylon :: Red Ironbark 36 | 1750 Divisadero St | 1 | Front Yard : Cutout 8 | Tree 1 | Private 1 | 6001124.0 | 2114376.0 | 37.7857361748448 | -122.439869519979 | (37.7857361748448, -122.439869519979) | |||||
| 124008 | 124008 | 106918 | Undocumented 2 | Eucalyptus sideroxylon :: Red Ironbark 36 | 274 PUTNAM ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6009044.8 | 2096077.1 | 37.7359392652864 | -122.41117262558201 | (37.7359392652864, -122.411172625582) | |||||
| 124370 | 124370 | 116999 | Significant Tree 6 | Eucalyptus sideroxylon :: Red Ironbark 36 | 880x MCALLISTER ST | 2 | Front Yard : Cutout 8 | Tree 1 | Private 1 | 6005306.0 | 2112177.0 | 37.779935428414 | -122.42524444144199 | (37.779935428414, -122.425244441442) | |||||
| 125797 | 125797 | 109198 | Undocumented 2 | Eucalyptus sideroxylon :: Red Ironbark 36 | 2401x CASTRO ST | 2 | Median : Yard 3 | Tree 1 | DPW 2 | 6002698.0 | 2098487.0 | 37.7421983129634 | -122.43328816691401 | (37.7421983129634, -122.433288166914) | |||||
| 128009 | 128009 | 109203 | Undocumented 2 | Eucalyptus sideroxylon :: Red Ironbark 36 | 2401x CASTRO ST | 9 | Median : Yard 3 | Tree 1 | DPW 2 | 6002698.0 | 2098487.0 | 37.7421983129634 | -122.43328816691401 | (37.7421983129634, -122.433288166914) | |||||
| 128144 | 128144 | 50377 | Permitted Site 1 | Eucalyptus sideroxylon :: Red Ironbark 36 | 1620 Montgomery St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/01/2003 12:00:00 AM | Permit Number 47039 | 6011351.83248495 | 2120835.88186523 | 37.804050345434 | -122.404938924734 | (37.804050345434, -122.404938924734) | |||
| 128360 | 128360 | 106364 | Significant Tree 6 | Eucalyptus sideroxylon :: Red Ironbark 36 | 155 BORICA ST | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 5992696.0 | 2092292.5 | 37.724617268406604 | -122.467421338179 | (37.7246172684066, -122.467421338179) | |||||
| 131355 | 131355 | 247086 | Undocumented 2 | Eucalyptus sideroxylon :: Red Ironbark 36 | 2301 Castro St | 4 | Front Yard : Yard 7 | Tree 1 | Private 1 | 21 | 6002759.04691 | 2098591.69247 | 37.7424892371899 | -122.43308456422501 | (37.7424892371899, -122.433084564225) | ||||
| 133301 | 133301 | 218784 | Undocumented 2 | Eucalyptus sideroxylon :: Red Ironbark 36 | 230 Edna St | 4 | Side Yard : Yard 17 | Tree 1 | Private 1 | 6 | 5998790.64503 | 2095351.5410200001 | 37.733366650131295 | -122.446573000066 | (37.7333666501313, -122.446573000066) | ||||
| 133793 | 133793 | 206299 | Undocumented 2 | Eucalyptus sideroxylon :: Red Ironbark 36 | 231 Edna St | 1 | Side Yard : Yard 17 | Tree 1 | Private 1 | 21 | 5998763.35609 | 2095379.2875599999 | 37.733441276780205 | -122.446669340837 | (37.7334412767802, -122.446669340837) | ||||
| 134377 | 134377 | 224017 | Undocumented 2 | Eucalyptus sideroxylon :: Red Ironbark 36 | 1000 San Jose Ave | 91 | Front Yard : Yard 7 | Tree 1 | Private 1 | 28 | 6004994.74234 | 2096924.0742900001 | 37.7380369005842 | -122.425235549407 | (37.7380369005842, -122.425235549407) | ||||
| 134530 | 134530 | 218787 | Undocumented 2 | Eucalyptus sideroxylon :: Red Ironbark 36 | 230 Edna St | 7 | Side Yard : Yard 17 | Tree 1 | Private 1 | 14 | 5998781.19291 | 2095377.439 | 37.733437219949 | -122.44660754120702 | (37.733437219949, -122.446607541207) | ||||
| 140716 | 140716 | 99699 | Significant Tree 6 | Eucalyptus sideroxylon :: Red Ironbark 36 | 1750 Divisadero St | 2 | Front Yard : Cutout 8 | Tree 1 | Private 1 | 6001124.0 | 2114376.0 | 37.7857361748448 | -122.439869519979 | (37.7857361748448, -122.439869519979) | |||||
| 143072 | 143072 | 97216 | DPW Maintained 3 | Eucalyptus sideroxylon :: Red Ironbark 36 | 300X Claremont Blvd | 3 | Back Yard : Cutout 16 | Tree 1 | DPW for City Agency 10 | 5993486.0 | 2098110.3 | 37.7406370848463 | -122.465112792055 | (37.7406370848463, -122.465112792055) | |||||
| 146060 | 146060 | 106499 | Permitted Site 1 | Eucalyptus sideroxylon :: Red Ironbark 36 | 420X Shrader St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5997462.73555 | 2109001.92463 | 37.770771276139705 | -122.452148498658 | (37.7707712761397, -122.452148498658) | |||||
| 146328 | 146328 | 36834 | Permitted Site 1 | Eucalyptus sideroxylon :: Red Ironbark 36 | 2715 Ingalls St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/26/1998 12:00:00 AM | Permit Number 39537 | 6015005.69395491 | 2090908.83002417 | 37.7220807273762 | -122.390202307194 | (37.7220807273762, -122.390202307194) | ||
| 148918 | 148918 | 62209 | Permitted Site 1 | Eucalyptus sideroxylon :: Red Ironbark 36 | 227 24th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/12/1985 12:00:00 AM | 16 | Permit Number 22331 | 5988338.57879 | 2114482.10714 | 37.7852914335725 | -122.48411069019699 | (37.7852914335725, -122.484110690197) | |
| 152132 | 152132 | 218786 | Undocumented 2 | Eucalyptus sideroxylon :: Red Ironbark 36 | 230 Edna St | 6 | Side Yard : Yard 17 | Tree 1 | Private 1 | 11 | 5998782.33461 | 2095362.2846400002 | 37.733395674875005 | -122.44660250410101 | (37.733395674875, -122.446602504101) | ||||
| 152279 | 152279 | 224022 | Undocumented 2 | Eucalyptus sideroxylon :: Red Ironbark 36 | 1300 San Jose Ave | 21 | Front Yard : Yard 7 | Tree 1 | Private 1 | 25 | 6003540.82213 | 2095652.97051 | 37.7344644939234 | -122.43017181569999 | (37.7344644939234, -122.4301718157) | ||||
| 152285 | 152285 | 199383 | DPW Maintained 3 | Eucalyptus sideroxylon :: Red Ironbark 36 | 400x Cargo Way | 6 | Median : Yard 3 | Tree 1 | DPW 2 | 10 | 6017000.482369999 | 2098965.68052 | 37.7443136810333 | -122.38386746011801 | (37.7443136810333, -122.383867460118) | ||||
| 153494 | 153494 | 199348 | Undocumented 2 | Eucalyptus sideroxylon :: Red Ironbark 36 | 1501 25th St | 23 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | 6014219.92848 | 2101970.08813 | 37.7524090471553 | -122.393692343051 | (37.7524090471553, -122.393692343051) | ||||
| 153777 | 153777 | 224008 | Undocumented 2 | Eucalyptus sideroxylon :: Red Ironbark 36 | 1000 San Jose Ave | 29 | Front Yard : Yard 7 | Tree 1 | Private 1 | 17 | 6005152.83634 | 2097199.08838 | 37.7388009573938 | -122.42470849810499 | (37.7388009573938, -122.424708498105) | ||||
| 158262 | 158262 | 176380 | Undocumented 2 | Eucalyptus sideroxylon :: Red Ironbark 36 | 229 Hester Ave | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 38 | 6012521.81555 | 2087619.26728 | 37.7129101627473 | -122.398557799413 | (37.7129101627473, -122.398557799413) | ||||
| 162867 | 162867 | 224012 | Undocumented 2 | Eucalyptus sideroxylon :: Red Ironbark 36 | 1000 San Jose Ave | 85 | Front Yard : Yard 7 | Tree 1 | Private 1 | 26 | 6005023.67021 | 2096975.18783 | 37.738178881048704 | -122.425139167258 | (37.7381788810487, -122.425139167258) | ||||
| 165042 | 165042 | 218785 | Undocumented 2 | Eucalyptus sideroxylon :: Red Ironbark 36 | 230 Edna St | 5 | Side Yard : Yard 17 | Tree 1 | Private 1 | 8 | 5998782.76063 | 2095352.74135 | 37.733369495591795 | -122.446600344857 | (37.7333694955918, -122.446600344857) | ||||
| 168669 | 168669 | 247078 | Undocumented 2 | Eucalyptus sideroxylon :: Red Ironbark 36 | 2401 Castro St | 14 | Front Yard : Yard 7 | Tree 1 | Private 1 | 25 | 6002758.90176 | 2098529.69857 | 37.7423190081102 | -122.433080637766 | (37.7423190081102, -122.433080637766) | ||||
| 169441 | 169441 | 224010 | Undocumented 2 | Eucalyptus sideroxylon :: Red Ironbark 36 | 1000 San Jose Ave | 31 | Front Yard : Yard 7 | Tree 1 | Private 1 | 18 | 6005156.6976 | 2097181.32171 | 37.738752392204205 | -122.424693884126 | (37.7387523922042, -122.424693884126) | ||||
| 169526 | 169526 | 247073 | Undocumented 2 | Eucalyptus sideroxylon :: Red Ironbark 36 | 2401 Castro St | 9 | Front Yard : Yard 7 | Tree 1 | Private 1 | 24 | 6002776.09275 | 2098476.71227 | 37.742174495166395 | -122.433017411837 | (37.7421744951664, -122.433017411837) | ||||
| 169973 | 169973 | 61914 | Permitted Site 1 | Eucalyptus sideroxylon :: Red Ironbark 36 | 801 Cesar Chavez St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/27/1985 12:00:00 AM | 12 | Permit Number 21965 | 6016347.85341 | 2101137.90293 | 37.75024205603879 | -122.386275546874 | (37.7502420560388, -122.386275546874) |
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");