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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 109 | 109 | 9895 | DPW Maintained 3 | Eucalyptus Spp :: Eucalyptus 40 | 1800X Pine St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 6005051.0377 | 2115464.4068 | 37.7889474242075 | -122.426360597873 | (37.7889474242075, -122.426360597873) | |||
| 1707 | 1707 | 19767 | DPW Maintained 3 | Eucalyptus Spp :: Eucalyptus 40 | 100 STAIRWAY16 | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 30ST | ||||||||
| 1811 | 1811 | 19991 | DPW Maintained 3 | Eucalyptus Spp :: Eucalyptus 40 | 100 STAIRWAY46 | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 40 | ||||||||
| 1842 | 1842 | 19990 | DPW Maintained 3 | Eucalyptus Spp :: Eucalyptus 40 | 100 STAIRWAY46 | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 40 | ||||||||
| 2751 | 2751 | 19916 | DPW Maintained 3 | Eucalyptus Spp :: Eucalyptus 40 | 100 STAIRWAY35 | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 120ST | ||||||||
| 5450 | 5450 | 19643 | DPW Maintained 3 | Eucalyptus Spp :: Eucalyptus 40 | 100 STAIRWAY5 | 42 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 30 | ||||||||
| 5580 | 5580 | 19952 | DPW Maintained 3 | Eucalyptus Spp :: Eucalyptus 40 | 100 STAIRWAY39 | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 25ST | ||||||||
| 5629 | 5629 | 19629 | DPW Maintained 3 | Eucalyptus Spp :: Eucalyptus 40 | 100 STAIRWAY5 | 28 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 30 | ||||||||
| 5638 | 5638 | 19734 | DPW Maintained 3 | Eucalyptus Spp :: Eucalyptus 40 | 100 STAIRWAY14 | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 40ST | ||||||||
| 6130 | 6130 | 19637 | DPW Maintained 3 | Eucalyptus Spp :: Eucalyptus 40 | 100 STAIRWAY5 | 36 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 30 | ||||||||
| 6465 | 6465 | 20050 | DPW Maintained 3 | Eucalyptus Spp :: Eucalyptus 40 | 100 STAIRWAY52 | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 10 | ||||||||
| 6552 | 6552 | 19622 | DPW Maintained 3 | Eucalyptus Spp :: Eucalyptus 40 | 100 STAIRWAY5 | 21 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 30 | ||||||||
| 6727 | 6727 | 20046 | DPW Maintained 3 | Eucalyptus Spp :: Eucalyptus 40 | 100 STAIRWAY52 | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3 | 10 | ||||||||
| 6840 | 6840 | 19703 | DPW Maintained 3 | Eucalyptus Spp :: Eucalyptus 40 | 100 STAIRWAY13 | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 40ST | ||||||||
| 6859 | 6859 | 19881 | DPW Maintained 3 | Eucalyptus Spp :: Eucalyptus 40 | 100 STAIRWAY33 | 13 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 25ST | ||||||||
| 7127 | 7127 | 19877 | DPW Maintained 3 | Eucalyptus Spp :: Eucalyptus 40 | 100 STAIRWAY33 | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 24 | 25ST | ||||||||
| 8000 | 8000 | 19575 | DPW Maintained 3 | Eucalyptus Spp :: Eucalyptus 40 | 100 STAIRWAY1 | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 36 | 100ST | ||||||||
| 8376 | 8376 | 17629 | DPW Maintained 3 | Eucalyptus Spp :: Eucalyptus 40 | 150 Phelps St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 10M | ||||||||
| 8874 | 8874 | 19879 | DPW Maintained 3 | Eucalyptus Spp :: Eucalyptus 40 | 100 STAIRWAY33 | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 25ST | ||||||||
| 8891 | 8891 | 19873 | DPW Maintained 3 | Eucalyptus Spp :: Eucalyptus 40 | 100 STAIRWAY33 | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 30 | 25ST | ||||||||
| 9101 | 9101 | 19626 | DPW Maintained 3 | Eucalyptus Spp :: Eucalyptus 40 | 100 STAIRWAY5 | 25 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 30 | ||||||||
| 9670 | 9670 | 19824 | DPW Maintained 3 | Eucalyptus Spp :: Eucalyptus 40 | 100 STAIRWAY25 | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 10ST | ||||||||
| 10110 | 10110 | 17260 | DPW Maintained 3 | Eucalyptus Spp :: Eucalyptus 40 | 29 Osceola Ln | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/27/2017 12:00:00 AM | 18 | 3X3 | 6017247.640204701 | 2094279.3298336002 | 37.73145956022589 | -122.382686794637 | (37.7314595602259, -122.382686794637) | ||
| 10584 | 10584 | 19572 | DPW Maintained 3 | Eucalyptus Spp :: Eucalyptus 40 | 100 STAIRWAY1 | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 24 | 100ST | ||||||||
| 10624 | 10624 | 19574 | DPW Maintained 3 | Eucalyptus Spp :: Eucalyptus 40 | 100 STAIRWAY1 | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 100ST | ||||||||
| 10757 | 10757 | 19823 | DPW Maintained 3 | Eucalyptus Spp :: Eucalyptus 40 | 100 STAIRWAY25 | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 10ST | ||||||||
| 10946 | 10946 | 19995 | DPW Maintained 3 | Eucalyptus Spp :: Eucalyptus 40 | 100 STAIRWAY46 | 15 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 40 | ||||||||
| 11109 | 11109 | 19996 | DPW Maintained 3 | Eucalyptus Spp :: Eucalyptus 40 | 100 STAIRWAY46 | 16 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 40 | ||||||||
| 11188 | 11188 | 19822 | DPW Maintained 3 | Eucalyptus Spp :: Eucalyptus 40 | 100 STAIRWAY25 | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 10ST | ||||||||
| 11496 | 11496 | 19573 | DPW Maintained 3 | Eucalyptus Spp :: Eucalyptus 40 | 100 STAIRWAY1 | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 100ST | ||||||||
| 11523 | 11523 | 19635 | DPW Maintained 3 | Eucalyptus Spp :: Eucalyptus 40 | 100 STAIRWAY5 | 34 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 30 | ||||||||
| 11623 | 11623 | 19765 | DPW Maintained 3 | Eucalyptus Spp :: Eucalyptus 40 | 100 STAIRWAY16 | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 30ST | ||||||||
| 12152 | 12152 | 19571 | DPW Maintained 3 | Eucalyptus Spp :: Eucalyptus 40 | 100 STAIRWAY1 | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 24 | 100ST | ||||||||
| 12720 | 12720 | 19640 | DPW Maintained 3 | Eucalyptus Spp :: Eucalyptus 40 | 100 STAIRWAY5 | 39 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 30 | ||||||||
| 12830 | 12830 | 19619 | DPW Maintained 3 | Eucalyptus Spp :: Eucalyptus 40 | 100 STAIRWAY5 | 18 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 30 | ||||||||
| 12952 | 12952 | 19628 | DPW Maintained 3 | Eucalyptus Spp :: Eucalyptus 40 | 100 STAIRWAY5 | 27 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 30 | ||||||||
| 13122 | 13122 | 19636 | DPW Maintained 3 | Eucalyptus Spp :: Eucalyptus 40 | 100 STAIRWAY5 | 35 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 30 | ||||||||
| 13156 | 13156 | 20391 | DPW Maintained 3 | Eucalyptus Spp :: Eucalyptus 40 | 262X Sunset Blvd | 37 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 60 | ||||||||
| 13294 | 13294 | 187652 | Undocumented 2 | Eucalyptus Spp :: Eucalyptus 40 | 46 Cragmont Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5992908.0 | 2101735.0 | 37.750556241076204 | -122.467374782979 | (37.7505562410762, -122.467374782979) | ||||
| 13560 | 13560 | 20028 | DPW Maintained 3 | Eucalyptus Spp :: Eucalyptus 40 | 100 STAIRWAY49 | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 10 | ||||||||
| 13632 | 13632 | 19618 | DPW Maintained 3 | Eucalyptus Spp :: Eucalyptus 40 | 100 STAIRWAY5 | 17 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 30 | ||||||||
| 13773 | 13773 | 19987 | DPW Maintained 3 | Eucalyptus Spp :: Eucalyptus 40 | 100 STAIRWAY46 | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 40 | ||||||||
| 13854 | 13854 | 11422 | DPW Maintained 3 | Eucalyptus Spp :: Eucalyptus 40 | 803X Mendell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 24 | 3X3 | 6016040.90005 | 2096755.8649799998 | 37.738192886184 | -122.38703142706001 | (37.738192886184, -122.38703142706) | |||
| 13883 | 13883 | 19639 | DPW Maintained 3 | Eucalyptus Spp :: Eucalyptus 40 | 100 STAIRWAY5 | 38 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 30 | ||||||||
| 14157 | 14157 | 17628 | DPW Maintained 3 | Eucalyptus Spp :: Eucalyptus 40 | 150 Phelps St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 10M | ||||||||
| 14188 | 14188 | 19617 | DPW Maintained 3 | Eucalyptus Spp :: Eucalyptus 40 | 100 STAIRWAY5 | 16 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 30 | ||||||||
| 14354 | 14354 | 17473 | DPW Maintained 3 | Eucalyptus Spp :: Eucalyptus 40 | 2050X Palou Ave | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 11/17/1992 12:00:00 AM | 12 | 3X3 | 6012341.587169999 | 2097177.38743 | 37.73914476102 | -122.39985148498 | (37.73914476102, -122.39985148498) | ||
| 14387 | 14387 | 22148 | DPW Maintained 3 | Eucalyptus Spp :: Eucalyptus 40 | 3800 03rd St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 3x3 | 6015737.9632 | 2098284.4406 | 37.7423732631069 | -122.388185488874 | (37.7423732631069, -122.388185488874) | |||
| 14502 | 14502 | 17475 | DPW Maintained 3 | Eucalyptus Spp :: Eucalyptus 40 | 2050X Palou Ave | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6012301.79777 | 2097206.74854 | 37.7392231621197 | -122.399991120917 | (37.7392231621197, -122.399991120917) | |||
| 14653 | 14653 | 19921 | DPW Maintained 3 | Eucalyptus Spp :: Eucalyptus 40 | 100 STAIRWAY37 | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | ||||||||
| 15123 | 15123 | 116637 | Undocumented 2 | Eucalyptus Spp :: Eucalyptus 40 | 2100 20th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/13/2016 12:00:00 AM | 3 | 3x3 | 6011768.89448 | 2104683.8431599997 | 37.759723915951206 | -122.40235926517799 | (37.7597239159512, -122.402359265178) | ||
| 15242 | 15242 | 22432 | DPW Maintained 3 | Eucalyptus Spp :: Eucalyptus 40 | 6000 03rd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 6013579.8961 | 2091555.5712 | 37.7237773618259 | -122.39517625529 | (37.7237773618259, -122.39517625529) | |||
| 15445 | 15445 | 19918 | DPW Maintained 3 | Eucalyptus Spp :: Eucalyptus 40 | 100 STAIRWAY35 | 14 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 120ST | ||||||||
| 15480 | 15480 | 116639 | Undocumented 2 | Eucalyptus Spp :: Eucalyptus 40 | 2100 20th St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/13/2016 12:00:00 AM | 3 | 3x3 | 6011723.51737 | 2104681.2870400003 | 37.7597143642338 | -122.402516023304 | (37.7597143642338, -122.402516023304) | ||
| 15768 | 15768 | 19884 | DPW Maintained 3 | Eucalyptus Spp :: Eucalyptus 40 | 100 STAIRWAY33 | 16 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 25ST | ||||||||
| 15852 | 15852 | 19567 | DPW Maintained 3 | Eucalyptus Spp :: Eucalyptus 40 | 100 STAIRWAY1 | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 24 | 100ST | ||||||||
| 15947 | 15947 | 19630 | DPW Maintained 3 | Eucalyptus Spp :: Eucalyptus 40 | 100 STAIRWAY5 | 29 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 30 | ||||||||
| 16203 | 16203 | 19623 | DPW Maintained 3 | Eucalyptus Spp :: Eucalyptus 40 | 100 STAIRWAY5 | 22 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 30 | ||||||||
| 16222 | 16222 | 19870 | DPW Maintained 3 | Eucalyptus Spp :: Eucalyptus 40 | 100 STAIRWAY33 | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 36 | 25ST | ||||||||
| 16278 | 16278 | 19770 | DPW Maintained 3 | Eucalyptus Spp :: Eucalyptus 40 | 100 STAIRWAY16 | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 30ST | ||||||||
| 16313 | 16313 | 19876 | DPW Maintained 3 | Eucalyptus Spp :: Eucalyptus 40 | 100 STAIRWAY33 | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 25ST | ||||||||
| 16376 | 16376 | 19641 | DPW Maintained 3 | Eucalyptus Spp :: Eucalyptus 40 | 100 STAIRWAY5 | 40 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 30 | ||||||||
| 16404 | 16404 | 15023 | Permitted Site 1 | Eucalyptus Spp :: Eucalyptus 40 | 835 Mendell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/23/2005 12:00:00 AM | 3 | 3x3 | 6015961.32258 | 2096647.62103 | 37.7378912634786 | -122.387299020359 | (37.7378912634786, -122.387299020359) | ||
| 16486 | 16486 | 19701 | DPW Maintained 3 | Eucalyptus Spp :: Eucalyptus 40 | 100 STAIRWAY12 | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 60 | ||||||||
| 16694 | 16694 | 104424 | Undocumented 2 | Eucalyptus Spp :: Eucalyptus 40 | 917 Rhode Island St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3x3 | 6011907.00978 | 2104135.17777 | 37.7582251112167 | -122.401843021952 | (37.7582251112167, -122.401843021952) | |||
| 16837 | 16837 | 116638 | Undocumented 2 | Eucalyptus Spp :: Eucalyptus 40 | 2100 20th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/13/2016 12:00:00 AM | 3 | 3x3 | 6011745.2802099995 | 2104684.37435 | 37.75972405623921 | -122.402440973074 | (37.7597240562392, -122.402440973074) | ||
| 16953 | 16953 | 19917 | DPW Maintained 3 | Eucalyptus Spp :: Eucalyptus 40 | 100 STAIRWAY35 | 13 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 120ST | ||||||||
| 18187 | 18187 | 40261 | Permitted Site 1 | Eucalyptus Spp :: Eucalyptus 40 | 3543 24th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/16/2005 12:00:00 AM | Permit Number 47928 | 6005992.45992589 | 2101968.12777251 | 37.751943042038704 | -122.422144186794 | (37.7519430420387, -122.422144186794) | ||
| 19129 | 19129 | 12492 | Permitted Site 1 | Eucalyptus Spp :: Eucalyptus 40 | 307 Lake Merced Blvd | 37 | Sidewalk: Curb side : Cutout 1 | Tree 1 | PUC 13 | 36 | 90M | 5985224.7663097 | 2094165.6248746999 | 37.7293262181041 | -122.49338600271003 | (37.7293262181041, -122.49338600271) | |||
| 19504 | 19504 | 52712 | Permitted Site 1 | Eucalyptus Spp :: Eucalyptus 40 | 53@ FAIR AVE Coleridge St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/31/2006 12:00:00 AM | Permit Number 48768 | 6006913.27477728 | 2099421.81000315 | 37.745003324352204 | -122.418779304454 | (37.7450033243522, -122.418779304454) | ||
| 26478 | 26478 | 63265 | Permitted Site 1 | Eucalyptus Spp :: Eucalyptus 40 | 1760 Golden Gate Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/13/1987 12:00:00 AM | 25 | Permit Number 24158 | 6001156.49330664 | 2111800.30825294 | 37.7786658324282 | -122.439572390689 | (37.7786658324282, -122.439572390689) | |
| 29001 | 29001 | 137844 | Undocumented 2 | Eucalyptus Spp :: Eucalyptus 40 | 1957 WEBSTER ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 0ft | 6003342.7396 | 2115504.846 | 37.7889617474845 | -122.43227396506398 | (37.7889617474845, -122.432273965064) | |||
| 30521 | 30521 | 17266 | DPW Maintained 3 | Eucalyptus Spp :: Eucalyptus 40 | 40 Osceola Dr | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 6017197.543092299 | 2094354.669125 | 37.7316636592684 | -122.382865232677 | (37.7316636592684, -122.382865232677) | |||
| 32548 | 32548 | 244479 | Undocumented 2 | Eucalyptus Spp :: Eucalyptus 40 | 124 Lily St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 0ft | 6005906.1302 | 2110197.2252 | 37.7745333330343 | -122.423027565946 | (37.7745333330343, -122.423027565946) | |||
| 35856 | 35856 | 142225 | Undocumented 2 | Eucalyptus Spp :: Eucalyptus 40 | 641 HAYES ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 0ft | 6004777.6628 | 2110866.818 | 37.7763081284007 | -122.42697885578698 | (37.7763081284007, -122.426978855787) | |||
| 39778 | 39778 | 122380 | Undocumented 2 | Eucalyptus Spp :: Eucalyptus 40 | 557 Grove St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 3x3 | 6005149.0 | 2111246.0 | 37.777370259808 | -122.42572129147301 | (37.777370259808, -122.425721291473) | |||
| 40004 | 40004 | 34491 | Permitted Site 1 | Eucalyptus Spp :: Eucalyptus 40 | 1723 Alabama St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/15/1997 12:00:00 AM | Permit Number 38214 | 6009344.79247114 | 2099429.66611089 | 37.745161501342295 | -122.410372074504 | (37.7451615013423, -122.410372074504) | ||
| 49638 | 49638 | 25447 | DPW Maintained 3 | Eucalyptus Spp :: Eucalyptus 40 | 1261X La Salle Ave | 15 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 6017141.6501925 | 2094501.7221284 | 37.732064349457005 | -122.383068698568 | (37.732064349457, -122.383068698568) | |||
| 50313 | 50313 | 69180 | Permitted Site 1 | Eucalyptus Spp :: Eucalyptus 40 | 1310 45th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/26/1994 12:00:00 AM | 8 | Permit Number 33219 | 5982156.72464205 | 2106168.22486515 | 37.7621020835294 | -122.504881372035 | (37.7621020835294, -122.504881372035) | |
| 53591 | 53591 | 113159 | Undocumented 2 | Eucalyptus Spp :: Eucalyptus 40 | 555 GROVE ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6005146.0 | 2111243.0 | 37.777361853017 | -122.425731455878 | (37.777361853017, -122.425731455878) | ||||
| 56266 | 56266 | 9287 | DPW Maintained 3 | Eucalyptus Spp :: Eucalyptus 40 | 13X George Ct | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 6017208.549763201 | 2094048.0250586998 | 37.7308222832509 | -122.38280584856301 | (37.7308222832509, -122.382805848563) | |||
| 61013 | 61013 | 199410 | Undocumented 2 | Eucalyptus Spp :: Eucalyptus 40 | 822 Mendell St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 27 | Width 4ft | 6015932.24155 | 2096672.73443 | 37.7379586091972 | -122.387401320018 | (37.7379586091972, -122.387401320018) | |||
| 67534 | 67534 | 121262 | Undocumented 2 | Eucalyptus Spp :: Eucalyptus 40 | 505 Grove St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 3x3 | 6005321.0 | 2111256.0 | 37.7774074352434 | -122.42512699851002 | (37.7774074352434, -122.42512699851) | |||
| 68584 | 68584 | 139748 | Undocumented 2 | Eucalyptus Spp :: Eucalyptus 40 | 1330 Laguna St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 20 | Width 0ft | 6004640.4611 | 2113601.4606 | 37.783809022804206 | -122.427648355277 | (37.7838090228042, -122.427648355277) | |||
| 69668 | 69668 | 66337 | Permitted Site 1 | Eucalyptus Spp :: Eucalyptus 40 | 1230 31st Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/10/1990 12:00:00 AM | 12 | Permit Number 29458 | 5986478.94641131 | 2106871.16119587 | 37.7642854833106 | -122.489984375656 | (37.7642854833106, -122.489984375656) | |
| 72418 | 72418 | 54847 | Permitted Site 1 | Eucalyptus Spp :: Eucalyptus 40 | 2056 Grove St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/10/1972 12:00:00 AM | 20 | 3x3 | Permit Number 10705 | 5997976.78501928 | 2110316.64994342 | 37.7744106068743 | -122.45046519400199 | (37.7744106068743, -122.450465194002) | |
| 76398 | 76398 | 17253 | DPW Maintained 3 | Eucalyptus Spp :: Eucalyptus 40 | 15 Osceola Ln | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 24 | 3X3 | 6017345.102761 | 2094248.0837328997 | 37.7313791485056 | -122.382347671583 | (37.7313791485056, -122.382347671583) | |||
| 76630 | 76630 | 54757 | Permitted Site 1 | Eucalyptus Spp :: Eucalyptus 40 | 330 Lathrop Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/08/1972 12:00:00 AM | 14 | Permit Number 10606 | 6012426.81669 | 2086731.5712700002 | 37.7104674323033 | -122.39882388720801 | (37.7104674323033, -122.398823887208) | ||
| 77748 | 77748 | 11361 | DPW Maintained 3 | Eucalyptus Spp :: Eucalyptus 40 | 1350X Ingalls St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 80 | 3X3 | 6017253.696644001 | 2093959.2156363998 | 37.7305809242894 | -122.382643589629 | (37.7305809242894, -122.382643589629) | |||
| 77778 | 77778 | 64888 | Permitted Site 1 | Eucalyptus Spp :: Eucalyptus 40 | 2418 22nd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/01/1989 12:00:00 AM | Permit Number 25914 | 5989547.06003251 | 2098884.34921412 | 37.742534500381105 | -122.478788583135 | (37.7425345003811, -122.478788583135) | ||
| 77867 | 77867 | 12494 | Permitted Site 1 | Eucalyptus Spp :: Eucalyptus 40 | 307 Lake Merced Blvd | 39 | Sidewalk: Curb side : Cutout 1 | Tree 1 | PUC 13 | 12 | 90M | 5985224.7663097 | 2094165.6248746999 | 37.7293262181041 | -122.49338600271003 | (37.7293262181041, -122.49338600271) | |||
| 78038 | 78038 | 11356 | DPW Maintained 3 | Eucalyptus Spp :: Eucalyptus 40 | 1339 Ingalls St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 90 | 3X3 | 6017292.9099838 | 2093920.0801467 | 37.7304756321775 | -122.382505299944 | (37.7304756321775, -122.382505299944) | |||
| 78081 | 78081 | 12493 | Permitted Site 1 | Eucalyptus Spp :: Eucalyptus 40 | 307 Lake Merced Blvd | 38 | Sidewalk: Curb side : Cutout 1 | Tree 1 | PUC 13 | 18 | 90M | 5985224.7663097 | 2094165.6248746999 | 37.7293262181041 | -122.49338600271003 | (37.7293262181041, -122.49338600271) | |||
| 78083 | 78083 | 113326 | Undocumented 2 | Eucalyptus Spp :: Eucalyptus 40 | 237 Fairmount St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6004215.8 | 2097159.4 | 37.7386390150291 | -122.427945503988 | (37.7386390150291, -122.427945503988) | ||||
| 78473 | 78473 | 105080 | Undocumented 2 | Eucalyptus Spp :: Eucalyptus 40 | 3770 24TH ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | 3x4 | 6004633.1 | 2101955.7 | 37.7518321521274 | -122.426844164794 | (37.7518321521274, -122.426844164794) | |||
| 80454 | 80454 | 12087 | DPW Maintained 3 | Eucalyptus Spp :: Eucalyptus 40 | 1261X La Salle Ave | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6017141.6501925 | 2094501.7221284 | 37.732064349457005 | -122.383068698568 | (37.732064349457, -122.383068698568) | |||
| 80713 | 80713 | 12013 | DPW Maintained 3 | Eucalyptus Spp :: Eucalyptus 40 | 1230X La Salle Ave | 14 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 45 | 3X3 | 6017323.1168478 | 2094452.6646717 | 37.7319396729967 | -122.382437910438 | (37.7319396729967, -122.382437910438) | |||
| 81197 | 81197 | 11295 | DPW Maintained 3 | Eucalyptus Spp :: Eucalyptus 40 | 1199X Ingalls St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 60 | 3X3 | 6017612.0195749 | 2093925.7037957 | 37.730508696225705 | -122.38140247160801 | (37.7305086962257, -122.381402471608) | |||
| 81240 | 81240 | 9288 | DPW Maintained 3 | Eucalyptus Spp :: Eucalyptus 40 | 13X George Ct | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 6017208.549763201 | 2094048.0250586998 | 37.7308222832509 | -122.38280584856301 | (37.7308222832509, -122.382805848563) | |||
| 81361 | 81361 | 63362 | Permitted Site 1 | Eucalyptus Spp :: Eucalyptus 40 | 401 Holly Park Cir | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/20/1991 12:00:00 AM | Permit Number 30039 | 6006709.37395927 | 2096284.55563078 | 37.7363776416136 | -122.41926185234301 | (37.7363776416136, -122.419261852343) |
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");