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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 15790 | 15790 | 87061 | Permitted Site 1 | Eucalyptus Spp :: Eucalyptus 40 | unknown : Yard 19 | Tree 1 | Private 1 | 3x3 | Permit Number 50003 | ||||||||||
| 94650 | 94650 | 61652 | Permitted Site 1 | Eucalyptus Spp :: Eucalyptus 40 | 1 09th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/21/1984 12:00:00 AM | Permit Number 21641 | 5993002.2450542 | 2114941.18121592 | 37.7868223445778 | -122.468009369168 | (37.7868223445778, -122.468009369168) | ||
| 187769 | 187769 | 122180 | Undocumented 2 | Eucalyptus Spp :: Eucalyptus 40 | 100 14th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 21 | Width 3ft | 5991527.0848 | 2114155.02215 | 37.784578471021 | -122.47305567737601 | (37.784578471021, -122.473055677376) | |||
| 8000 | 8000 | 19575 | DPW Maintained 3 | Eucalyptus Spp :: Eucalyptus 40 | 100 STAIRWAY1 | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 36 | 100ST | ||||||||
| 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 | ||||||||
| 11496 | 11496 | 19573 | DPW Maintained 3 | Eucalyptus Spp :: Eucalyptus 40 | 100 STAIRWAY1 | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 100ST | ||||||||
| 12152 | 12152 | 19571 | DPW Maintained 3 | Eucalyptus Spp :: Eucalyptus 40 | 100 STAIRWAY1 | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 24 | 100ST | ||||||||
| 15852 | 15852 | 19567 | DPW Maintained 3 | Eucalyptus Spp :: Eucalyptus 40 | 100 STAIRWAY1 | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 24 | 100ST | ||||||||
| 16486 | 16486 | 19701 | DPW Maintained 3 | Eucalyptus Spp :: Eucalyptus 40 | 100 STAIRWAY12 | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 60 | ||||||||
| 6840 | 6840 | 19703 | DPW Maintained 3 | Eucalyptus Spp :: Eucalyptus 40 | 100 STAIRWAY13 | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 40ST | ||||||||
| 5638 | 5638 | 19734 | DPW Maintained 3 | Eucalyptus Spp :: Eucalyptus 40 | 100 STAIRWAY14 | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 40ST | ||||||||
| 1707 | 1707 | 19767 | DPW Maintained 3 | Eucalyptus Spp :: Eucalyptus 40 | 100 STAIRWAY16 | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 30ST | ||||||||
| 11623 | 11623 | 19765 | DPW Maintained 3 | Eucalyptus Spp :: Eucalyptus 40 | 100 STAIRWAY16 | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 30ST | ||||||||
| 16278 | 16278 | 19770 | DPW Maintained 3 | Eucalyptus Spp :: Eucalyptus 40 | 100 STAIRWAY16 | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 30ST | ||||||||
| 9670 | 9670 | 19824 | DPW Maintained 3 | Eucalyptus Spp :: Eucalyptus 40 | 100 STAIRWAY25 | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 10ST | ||||||||
| 10757 | 10757 | 19823 | DPW Maintained 3 | Eucalyptus Spp :: Eucalyptus 40 | 100 STAIRWAY25 | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 10ST | ||||||||
| 11188 | 11188 | 19822 | DPW Maintained 3 | Eucalyptus Spp :: Eucalyptus 40 | 100 STAIRWAY25 | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 10ST | ||||||||
| 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 | ||||||||
| 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 | ||||||||
| 15768 | 15768 | 19884 | DPW Maintained 3 | Eucalyptus Spp :: Eucalyptus 40 | 100 STAIRWAY33 | 16 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 25ST | ||||||||
| 16222 | 16222 | 19870 | DPW Maintained 3 | Eucalyptus Spp :: Eucalyptus 40 | 100 STAIRWAY33 | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 36 | 25ST | ||||||||
| 16313 | 16313 | 19876 | DPW Maintained 3 | Eucalyptus Spp :: Eucalyptus 40 | 100 STAIRWAY33 | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 25ST | ||||||||
| 2751 | 2751 | 19916 | DPW Maintained 3 | Eucalyptus Spp :: Eucalyptus 40 | 100 STAIRWAY35 | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 120ST | ||||||||
| 15445 | 15445 | 19918 | DPW Maintained 3 | Eucalyptus Spp :: Eucalyptus 40 | 100 STAIRWAY35 | 14 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 120ST | ||||||||
| 16953 | 16953 | 19917 | DPW Maintained 3 | Eucalyptus Spp :: Eucalyptus 40 | 100 STAIRWAY35 | 13 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 120ST | ||||||||
| 14653 | 14653 | 19921 | DPW Maintained 3 | Eucalyptus Spp :: Eucalyptus 40 | 100 STAIRWAY37 | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | ||||||||
| 5580 | 5580 | 19952 | DPW Maintained 3 | Eucalyptus Spp :: Eucalyptus 40 | 100 STAIRWAY39 | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 25ST | ||||||||
| 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 | ||||||||
| 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 | ||||||||
| 13773 | 13773 | 19987 | DPW Maintained 3 | Eucalyptus Spp :: Eucalyptus 40 | 100 STAIRWAY46 | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 40 | ||||||||
| 13560 | 13560 | 20028 | DPW Maintained 3 | Eucalyptus Spp :: Eucalyptus 40 | 100 STAIRWAY49 | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 10 | ||||||||
| 5450 | 5450 | 19643 | DPW Maintained 3 | Eucalyptus Spp :: Eucalyptus 40 | 100 STAIRWAY5 | 42 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 30 | ||||||||
| 5629 | 5629 | 19629 | DPW Maintained 3 | Eucalyptus Spp :: Eucalyptus 40 | 100 STAIRWAY5 | 28 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 30 | ||||||||
| 6130 | 6130 | 19637 | DPW Maintained 3 | Eucalyptus Spp :: Eucalyptus 40 | 100 STAIRWAY5 | 36 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 30 | ||||||||
| 6552 | 6552 | 19622 | DPW Maintained 3 | Eucalyptus Spp :: Eucalyptus 40 | 100 STAIRWAY5 | 21 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 30 | ||||||||
| 9101 | 9101 | 19626 | DPW Maintained 3 | Eucalyptus Spp :: Eucalyptus 40 | 100 STAIRWAY5 | 25 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 30 | ||||||||
| 11523 | 11523 | 19635 | DPW Maintained 3 | Eucalyptus Spp :: Eucalyptus 40 | 100 STAIRWAY5 | 34 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 30 | ||||||||
| 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 | ||||||||
| 13632 | 13632 | 19618 | DPW Maintained 3 | Eucalyptus Spp :: Eucalyptus 40 | 100 STAIRWAY5 | 17 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 30 | ||||||||
| 13883 | 13883 | 19639 | DPW Maintained 3 | Eucalyptus Spp :: Eucalyptus 40 | 100 STAIRWAY5 | 38 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 30 | ||||||||
| 14188 | 14188 | 19617 | DPW Maintained 3 | Eucalyptus Spp :: Eucalyptus 40 | 100 STAIRWAY5 | 16 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 30 | ||||||||
| 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 | ||||||||
| 16376 | 16376 | 19641 | DPW Maintained 3 | Eucalyptus Spp :: Eucalyptus 40 | 100 STAIRWAY5 | 40 | 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 | ||||||||
| 6727 | 6727 | 20046 | DPW Maintained 3 | Eucalyptus Spp :: Eucalyptus 40 | 100 STAIRWAY52 | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3 | 10 | ||||||||
| 31769 | 31769 | 224212 | Undocumented 2 | Eucalyptus Spp :: Eucalyptus 40 | 1000 San Jose Ave | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 9 | 6005187.142969999 | 2097371.8747799997 | 37.739277327390795 | -122.42460216947501 | (37.7392773273908, -122.424602169475) | ||||
| 34116 | 34116 | 224214 | Undocumented 2 | Eucalyptus Spp :: Eucalyptus 40 | 1000 San Jose Ave | 5 | Front Yard : Yard 7 | Tree 1 | Private 1 | 25 | 6005180.62218 | 2097351.71746 | 37.73922161167361 | -122.424623281961 | (37.7392216116736, -122.424623281961) | ||||
| 71049 | 71049 | 224216 | Undocumented 2 | Eucalyptus Spp :: Eucalyptus 40 | 1000 San Jose Ave | 23 | Front Yard : Yard 7 | Tree 1 | Private 1 | 30 | 6005148.6559 | 2097255.3705700003 | 37.73895525948029 | -122.424726954897 | (37.7389552594803, -122.424726954897) | ||||
| 91437 | 91437 | 224213 | Undocumented 2 | Eucalyptus Spp :: Eucalyptus 40 | 1000 San Jose Ave | 3 | Front Yard : Yard 7 | Tree 1 | Private 1 | 20 | 6005183.176969999 | 2097360.09127 | 37.7392447485499 | -122.42461504414801 | (37.7392447485499, -122.424615044148) | ||||
| 133023 | 133023 | 224217 | Undocumented 2 | Eucalyptus Spp :: Eucalyptus 40 | 1000 San Jose Ave | 115 | Front Yard : Yard 7 | Tree 1 | Private 1 | 21 | 6005000.71693 | 2096893.74168 | 37.7379539516063 | -122.42521273450001 | (37.7379539516063, -122.4252127345) | ||||
| 159148 | 159148 | 224215 | Undocumented 2 | Eucalyptus Spp :: Eucalyptus 40 | 1000 San Jose Ave | 14 | Front Yard : Yard 7 | Tree 1 | Private 1 | 26 | 6005165.86979 | 2097298.42463 | 37.739074448424 | -122.424670499065 | (37.739074448424, -122.424670499065) | ||||
| 175024 | 175024 | 224211 | Undocumented 2 | Eucalyptus Spp :: Eucalyptus 40 | 1000 San Jose Ave | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 32 | 6005190.349119999 | 2097382.93272 | 37.739307871065996 | -122.424591870417 | (37.739307871066, -122.424591870417) | ||||
| 78735 | 78735 | 94388 | Permitted Site 1 | Eucalyptus Spp :: Eucalyptus 40 | 1001 Potrero Ave | 12 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | Permit Number 53641 | 6010509.9 | 2103658.3 | 37.7568376430251 | -122.406641253674 | (37.7568376430251, -122.406641253674) | ||||
| 83515 | 83515 | 94380 | Permitted Site 1 | Eucalyptus Spp :: Eucalyptus 40 | 1001 Potrero Ave | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | Permit Number 53641 | 6010509.9 | 2103658.3 | 37.7568376430251 | -122.406641253674 | (37.7568376430251, -122.406641253674) | ||||
| 84196 | 84196 | 94383 | Permitted Site 1 | Eucalyptus Spp :: Eucalyptus 40 | 1001 Potrero Ave | 7 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | Permit Number 53641 | 6010509.9 | 2103658.3 | 37.7568376430251 | -122.406641253674 | (37.7568376430251, -122.406641253674) | ||||
| 87589 | 87589 | 94384 | Permitted Site 1 | Eucalyptus Spp :: Eucalyptus 40 | 1001 Potrero Ave | 8 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | Permit Number 53641 | 6010509.9 | 2103658.3 | 37.7568376430251 | -122.406641253674 | (37.7568376430251, -122.406641253674) | ||||
| 87626 | 87626 | 94379 | Permitted Site 1 | Eucalyptus Spp :: Eucalyptus 40 | 1001 Potrero Ave | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | Permit Number 53641 | 6010509.9 | 2103658.3 | 37.7568376430251 | -122.406641253674 | (37.7568376430251, -122.406641253674) | ||||
| 95304 | 95304 | 94385 | Permitted Site 1 | Eucalyptus Spp :: Eucalyptus 40 | 1001 Potrero Ave | 9 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | Permit Number 53641 | 6010509.9 | 2103658.3 | 37.7568376430251 | -122.406641253674 | (37.7568376430251, -122.406641253674) | ||||
| 100408 | 100408 | 94381 | Permitted Site 1 | Eucalyptus Spp :: Eucalyptus 40 | 1001 Potrero Ave | 5 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | Permit Number 53641 | 6010509.9 | 2103658.3 | 37.7568376430251 | -122.406641253674 | (37.7568376430251, -122.406641253674) | ||||
| 110217 | 110217 | 94377 | Permitted Site 1 | Eucalyptus Spp :: Eucalyptus 40 | 1001 Potrero Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | Permit Number 53641 | 6010509.9 | 2103658.3 | 37.7568376430251 | -122.406641253674 | (37.7568376430251, -122.406641253674) | ||||
| 116794 | 116794 | 94386 | Permitted Site 1 | Eucalyptus Spp :: Eucalyptus 40 | 1001 Potrero Ave | 10 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | Permit Number 53641 | 6010509.9 | 2103658.3 | 37.7568376430251 | -122.406641253674 | (37.7568376430251, -122.406641253674) | ||||
| 125326 | 125326 | 94378 | Permitted Site 1 | Eucalyptus Spp :: Eucalyptus 40 | 1001 Potrero Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | Permit Number 53641 | 6010509.9 | 2103658.3 | 37.7568376430251 | -122.406641253674 | (37.7568376430251, -122.406641253674) | ||||
| 127453 | 127453 | 94387 | Permitted Site 1 | Eucalyptus Spp :: Eucalyptus 40 | 1001 Potrero Ave | 11 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | Permit Number 53641 | 6010509.9 | 2103658.3 | 37.7568376430251 | -122.406641253674 | (37.7568376430251, -122.406641253674) | ||||
| 143608 | 143608 | 94382 | Permitted Site 1 | Eucalyptus Spp :: Eucalyptus 40 | 1001 Potrero Ave | 6 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | Permit Number 53641 | 6010509.9 | 2103658.3 | 37.7568376430251 | -122.406641253674 | (37.7568376430251, -122.406641253674) | ||||
| 25099 | 25099 | 224199 | Undocumented 2 | Eucalyptus Spp :: Eucalyptus 40 | 1001 San Jose Ave | 35 | Front Yard : Yard 7 | Tree 1 | Private 1 | 16 | 6005272.32245 | 2097108.7115200001 | 37.738559550591795 | -122.42428894459299 | (37.7385595505918, -122.424288944593) | ||||
| 39821 | 39821 | 224196 | Undocumented 2 | Eucalyptus Spp :: Eucalyptus 40 | 1001 San Jose Ave | 16 | Front Yard : Yard 7 | Tree 1 | Private 1 | 15 | 6005192.428069999 | 2096936.6445 | 37.73808258165379 | -122.424552945066 | (37.7380825816538, -122.424552945066) | ||||
| 50324 | 50324 | 224208 | Undocumented 2 | Eucalyptus Spp :: Eucalyptus 40 | 1001 San Jose Ave | 66 | Front Yard : Yard 7 | Tree 1 | Private 1 | 22 | Width 8ft | 6005339.07699 | 2097371.10972 | 37.7392838060945 | -122.424076794516 | (37.7392838060945, -122.424076794516) | |||
| 62541 | 62541 | 224210 | Undocumented 2 | Eucalyptus Spp :: Eucalyptus 40 | 1001 San Jose Ave | 72 | Front Yard : Yard 7 | Tree 1 | Private 1 | 37 | 6005362.146369999 | 2097481.1402 | 37.739587227456205 | -122.42400485326401 | (37.7395872274562, -122.424004853264) | ||||
| 131250 | 131250 | 224198 | Undocumented 2 | Eucalyptus Spp :: Eucalyptus 40 | 1001 San Jose Ave | 30 | Front Yard : Yard 7 | Tree 1 | Private 1 | 9 | 6005259.16763 | 2097058.5140200001 | 37.7384209767501 | -122.424330858406 | (37.7384209767501, -122.424330858406) | ||||
| 134007 | 134007 | 224207 | Undocumented 2 | Eucalyptus Spp :: Eucalyptus 40 | 1001 San Jose Ave | 64 | Front Yard : Yard 7 | Tree 1 | Private 1 | 24 | Width 8ft | 6005337.33065 | 2097353.93167 | 37.739236540443294 | -122.42408161128999 | (37.7392365404433, -122.42408161129) | |||
| 151415 | 151415 | 224206 | Undocumented 2 | Eucalyptus Spp :: Eucalyptus 40 | 1001 San Jose Ave | 59 | Front Yard : Yard 7 | Tree 1 | Private 1 | 24 | 6005333.6743 | 2097319.7623400004 | 37.739142512726396 | -122.424091823995 | (37.7391425127264, -122.424091823995) | ||||
| 158093 | 158093 | 224205 | Undocumented 2 | Eucalyptus Spp :: Eucalyptus 40 | 1001 San Jose Ave | 58 | Front Yard : Yard 7 | Tree 1 | Private 1 | 30 | 6005328.89296 | 2097313.9887099997 | 37.7391263896815 | -122.424107945232 | (37.7391263896815, -122.424107945232) | ||||
| 166595 | 166595 | 224209 | Undocumented 2 | Eucalyptus Spp :: Eucalyptus 40 | 1001 San Jose Ave | 70 | Front Yard : Yard 7 | Tree 1 | Private 1 | 20 | 6005356.45271 | 2097454.81484 | 37.7395146225008 | -122.424022667913 | (37.7395146225008, -122.424022667913) | ||||
| 187763 | 187763 | 224197 | Undocumented 2 | Eucalyptus Spp :: Eucalyptus 40 | 1001 San Jose Ave | 28 | Front Yard : Yard 7 | Tree 1 | Private 1 | 13 | 6005251.17489 | 2097047.32393 | 37.738389799949104 | -122.424357697761 | (37.7383897999491, -122.424357697761) | ||||
| 107802 | 107802 | 11214 | DPW Maintained 3 | Eucalyptus Spp :: Eucalyptus 40 | 1001X Ingalls St | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/11/2006 12:00:00 AM | 12 | 3X4 | 6018170.9910099 | 2094117.1281791 | 37.7310651541831 | -122.379483297777 | (37.7310651541831, -122.379483297777) | ||
| 108506 | 108506 | 11213 | DPW Maintained 3 | Eucalyptus Spp :: Eucalyptus 40 | 1001X Ingalls St | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/11/2006 12:00:00 AM | 12 | 3X4 | 6018170.9910099 | 2094117.1281791 | 37.7310651541831 | -122.379483297777 | (37.7310651541831, -122.379483297777) | ||
| 127605 | 127605 | 11204 | DPW Maintained 3 | Eucalyptus Spp :: Eucalyptus 40 | 1001X Ingalls St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 30 | 3X4 | 6018170.9910099 | 2094117.1281791 | 37.7310651541831 | -122.379483297777 | (37.7310651541831, -122.379483297777) | |||
| 128757 | 128757 | 11205 | DPW Maintained 3 | Eucalyptus Spp :: Eucalyptus 40 | 1001X Ingalls St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 3X4 | 6018170.9910099 | 2094117.1281791 | 37.7310651541831 | -122.379483297777 | (37.7310651541831, -122.379483297777) | |||
| 85292 | 85292 | 106578 | DPW Maintained 3 | Eucalyptus Spp :: Eucalyptus 40 | 1001X SAN JOSE AVE | 2 | Median : Yard 3 | Tree 1 | DPW 2 | 24 | 6004855.0 | 2096548.0 | 37.7369963898236 | -122.42569194885799 | (37.7369963898236, -122.425691948858) | ||||
| 95732 | 95732 | 106583 | DPW Maintained 3 | Eucalyptus Spp :: Eucalyptus 40 | 1001X SAN JOSE AVE | 5 | Median : Yard 3 | Tree 1 | DPW 2 | 22 | 6004855.0 | 2096548.0 | 37.7369963898236 | -122.42569194885799 | (37.7369963898236, -122.425691948858) | ||||
| 101111 | 101111 | 106599 | DPW Maintained 3 | Eucalyptus Spp :: Eucalyptus 40 | 1001X SAN JOSE AVE | 12 | Median : Yard 3 | Tree 1 | DPW 2 | 42 | 6004855.0 | 2096548.0 | 37.7369963898236 | -122.42569194885799 | (37.7369963898236, -122.425691948858) | ||||
| 101240 | 101240 | 106579 | DPW Maintained 3 | Eucalyptus Spp :: Eucalyptus 40 | 1001X SAN JOSE AVE | 3 | Median : Yard 3 | Tree 1 | DPW 2 | 26 | 6004855.0 | 2096548.0 | 37.7369963898236 | -122.42569194885799 | (37.7369963898236, -122.425691948858) | ||||
| 107987 | 107987 | 106584 | DPW Maintained 3 | Eucalyptus Spp :: Eucalyptus 40 | 1001X SAN JOSE AVE | 5 | Median : Yard 3 | Tree 1 | DPW 2 | 22 | 6004855.0 | 2096548.0 | 37.7369963898236 | -122.42569194885799 | (37.7369963898236, -122.425691948858) | ||||
| 108041 | 108041 | 106585 | DPW Maintained 3 | Eucalyptus Spp :: Eucalyptus 40 | 1001X SAN JOSE AVE | 6 | Median : Yard 3 | Tree 1 | DPW 2 | 25 | 6004855.0 | 2096548.0 | 37.7369963898236 | -122.42569194885799 | (37.7369963898236, -122.425691948858) | ||||
| 114256 | 114256 | 106577 | DPW Maintained 3 | Eucalyptus Spp :: Eucalyptus 40 | 1001X SAN JOSE AVE | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 10 | 6004855.0 | 2096548.0 | 37.7369963898236 | -122.42569194885799 | (37.7369963898236, -122.425691948858) | ||||
| 115315 | 115315 | 106597 | DPW Maintained 3 | Eucalyptus Spp :: Eucalyptus 40 | 1001X SAN JOSE AVE | 10 | Median : Yard 3 | Tree 1 | DPW 2 | 19 | 6004855.0 | 2096548.0 | 37.7369963898236 | -122.42569194885799 | (37.7369963898236, -122.425691948858) | ||||
| 118789 | 118789 | 106592 | DPW Maintained 3 | Eucalyptus Spp :: Eucalyptus 40 | 1001X SAN JOSE AVE | 9 | Median : Yard 3 | Tree 1 | DPW 2 | 34 | 6004855.0 | 2096548.0 | 37.7369963898236 | -122.42569194885799 | (37.7369963898236, -122.425691948858) | ||||
| 121315 | 121315 | 106581 | DPW Maintained 3 | Eucalyptus Spp :: Eucalyptus 40 | 1001X SAN JOSE AVE | 4 | Median : Yard 3 | Tree 1 | DPW 2 | 9 | 6004855.0 | 2096548.0 | 37.7369963898236 | -122.42569194885799 | (37.7369963898236, -122.425691948858) | ||||
| 125322 | 125322 | 106587 | DPW Maintained 3 | Eucalyptus Spp :: Eucalyptus 40 | 1001X SAN JOSE AVE | 8 | Median : Yard 3 | Tree 1 | DPW 2 | 25 | 6004855.0 | 2096548.0 | 37.7369963898236 | -122.42569194885799 | (37.7369963898236, -122.425691948858) | ||||
| 141868 | 141868 | 106586 | DPW Maintained 3 | Eucalyptus Spp :: Eucalyptus 40 | 1001X SAN JOSE AVE | 7 | Median : Yard 3 | Tree 1 | DPW 2 | 11 | 6004855.0 | 2096548.0 | 37.7369963898236 | -122.42569194885799 | (37.7369963898236, -122.425691948858) | ||||
| 44683 | 44683 | 176302 | DPW Maintained 3 | Eucalyptus Spp :: Eucalyptus 40 | 100x Mansell St | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 18 | Width 0ft | 6011513.54745 | 2090660.92357 | 37.721205711656204 | -122.40225644658301 | (37.7212057116562, -122.402256446583) |
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");