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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 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 | ||||||||
| 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 | ||||||||
| 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 | ||||||||
| 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 | ||||||||
| 14653 | 14653 | 19921 | DPW Maintained 3 | Eucalyptus Spp :: Eucalyptus 40 | 100 STAIRWAY37 | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | ||||||||
| 15445 | 15445 | 19918 | DPW Maintained 3 | Eucalyptus Spp :: Eucalyptus 40 | 100 STAIRWAY35 | 14 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 120ST | ||||||||
| 15768 | 15768 | 19884 | DPW Maintained 3 | Eucalyptus Spp :: Eucalyptus 40 | 100 STAIRWAY33 | 16 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 25ST | ||||||||
| 15790 | 15790 | 87061 | Permitted Site 1 | Eucalyptus Spp :: Eucalyptus 40 | unknown : Yard 19 | Tree 1 | Private 1 | 3x3 | Permit Number 50003 | ||||||||||
| 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 | ||||||||
| 16486 | 16486 | 19701 | DPW Maintained 3 | Eucalyptus Spp :: Eucalyptus 40 | 100 STAIRWAY12 | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 60 | ||||||||
| 16953 | 16953 | 19917 | DPW Maintained 3 | Eucalyptus Spp :: Eucalyptus 40 | 100 STAIRWAY35 | 13 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 120ST | ||||||||
| 161444 | 161444 | 176333 | DPW Maintained 3 | Eucalyptus Spp :: Eucalyptus 40 | 12x Canyon Dr | 12 | Median : Cutout 11 | Tree 1 | DPW 2 | 12 | Width 0ft | 6002752.1139 | 2086168.71447 | 37.708378134509296 | -122.43222153339899 | (37.7083781345093, -122.432221533399) | |||
| 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) | ||
| 156289 | 156289 | 54758 | Permitted Site 1 | Eucalyptus Spp :: Eucalyptus 40 | 324 Lathrop Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/08/1972 12:00:00 AM | 8 | Permit Number 10607 | 6012398.45595 | 2086740.4083099999 | 37.710490116783 | -122.39892252845699 | (37.710490116783, -122.398922528457) | ||
| 106367 | 106367 | 1854 | DPW Maintained 3 | Eucalyptus Spp :: Eucalyptus 40 | 2500 Bay Shore Blvd | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 12 | 6 | 6010837.5147418 | 2086759.4488696998 | 37.7104552954566 | -122.404318844881 | (37.7104552954566, -122.404318844881) | |||
| 138313 | 138313 | 1855 | DPW Maintained 3 | Eucalyptus Spp :: Eucalyptus 40 | 2500 Bay Shore Blvd | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | 6 | 6010837.5147418 | 2086759.4488696998 | 37.7104552954566 | -122.404318844881 | (37.7104552954566, -122.404318844881) | |||
| 101382 | 101382 | 108685 | DPW Maintained 3 | Eucalyptus Spp :: Eucalyptus 40 | 301X CHESTER AVE | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | DPW 2 | 18 | 5991720.0 | 2087146.0 | 37.7104298409998 | -122.47042057923099 | (37.7104298409998, -122.470420579231) | ||||
| 88629 | 88629 | 117549 | DPW Maintained 3 | Eucalyptus Spp :: Eucalyptus 40 | 24X KEMPTON AVE | 3 | Side Yard : Yard 17 | Tree 1 | DPW 2 | 30x30 | 5992274.0 | 2087683.0 | 37.7119363308651 | -122.46854490041599 | (37.7119363308651, -122.468544900416) | ||||
| 112585 | 112585 | 117548 | DPW Maintained 3 | Eucalyptus Spp :: Eucalyptus 40 | 24X KEMPTON AVE | 2 | Side Yard : Yard 17 | Tree 1 | DPW 2 | 30x30 | 5992274.0 | 2087683.0 | 37.7119363308651 | -122.46854490041599 | (37.7119363308651, -122.468544900416) | ||||
| 121639 | 121639 | 117546 | DPW Maintained 3 | Eucalyptus Spp :: Eucalyptus 40 | 24X KEMPTON AVE | 1 | Side Yard : Yard 17 | Tree 1 | DPW 2 | 30x30 | 5992274.0 | 2087683.0 | 37.7119363308651 | -122.46854490041599 | (37.7119363308651, -122.468544900416) | ||||
| 126638 | 126638 | 117550 | DPW Maintained 3 | Eucalyptus Spp :: Eucalyptus 40 | 24X KEMPTON AVE | 4 | Side Yard : Yard 17 | Tree 1 | DPW 2 | 30x30 | 5992274.0 | 2087683.0 | 37.7119363308651 | -122.46854490041599 | (37.7119363308651, -122.468544900416) | ||||
| 146070 | 146070 | 121081 | DPW Maintained 3 | Eucalyptus Spp :: Eucalyptus 40 | 24X KEMPTON AVE | 5 | Side Yard : Yard 17 | Tree 1 | DPW 2 | 30x30 | 5992274.0 | 2087683.0 | 37.7119363308651 | -122.46854490041599 | (37.7119363308651, -122.468544900416) | ||||
| 95293 | 95293 | 104649 | Undocumented 2 | Eucalyptus Spp :: Eucalyptus 40 | 200 Wheeler Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 6012242.2 | 2087732.7 | 37.7132060446128 | -122.399532207425 | (37.7132060446128, -122.399532207425) | |||||
| 93072 | 93072 | 65615 | Permitted Site 1 | Eucalyptus Spp :: Eucalyptus 40 | 907 Madrid St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/07/1990 12:00:00 AM | Permit Number 28522 | 6001416.70920324 | 2088928.18069936 | 37.71587921156971 | -122.43703426598101 | (37.7158792115697, -122.437034265981) | ||
| 114250 | 114250 | 65614 | Permitted Site 1 | Eucalyptus Spp :: Eucalyptus 40 | 901 Madrid St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/07/1990 12:00:00 AM | 3x3 | Permit Number 28521 | 6001429.80797007 | 2088950.28994853 | 37.715940663173704 | -122.43699057256201 | (37.7159406631737, -122.436990572562) | |
| 106325 | 106325 | 69542 | Permitted Site 1 | Eucalyptus Spp :: Eucalyptus 40 | 775 Edinburg St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/28/1998 12:00:00 AM | 8 | Permit Number 38643 | 6001970.16460074 | 2089302.5400568 | 37.71693856245 | -122.43514802944901 | (37.71693856245, -122.435148029449) | |
| 37917 | 37917 | 199398 | Undocumented 2 | Eucalyptus Spp :: Eucalyptus 40 | 1027 Jamestown Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | 6013845.577380001 | 2089711.9694400001 | 37.718729970701396 | -122.394128826289 | (37.7187299707014, -122.394128826289) | ||||
| 185034 | 185034 | 176332 | DPW Maintained 3 | Eucalyptus Spp :: Eucalyptus 40 | 700x Mansell St | 40 | Median : Cutout 11 | Tree 1 | DPW 2 | 10 | Width 0ft | 6009122.37089 | 2089940.9339 | 37.7190950046208 | -122.410471276831 | (37.7190950046208, -122.410471276831) | |||
| 166853 | 166853 | 176331 | DPW Maintained 3 | Eucalyptus Spp :: Eucalyptus 40 | 700x Mansell St | 36 | Median : Cutout 11 | Tree 1 | DPW 2 | 27 | Width 0ft | 6009160.31915 | 2089943.1989099998 | 37.7191033512163 | -122.410340263619 | (37.7191033512163, -122.410340263619) | |||
| 28478 | 28478 | 176327 | DPW Maintained 3 | Eucalyptus Spp :: Eucalyptus 40 | 700x Mansell St | 31 | Median : Cutout 11 | Tree 1 | DPW 2 | 46 | Width 0ft | 6009212.31958 | 2089948.46975 | 37.7191207387124 | -122.41016088932699 | (37.7191207387124, -122.410160889327) | |||
| 158228 | 158228 | 176328 | DPW Maintained 3 | Eucalyptus Spp :: Eucalyptus 40 | 700x Mansell St | 32 | Median : Cutout 11 | Tree 1 | DPW 2 | 11 | Width 0ft | 6009200.77281 | 2089956.05158 | 37.7191409096134 | -122.41020133724899 | (37.7191409096134, -122.410201337249) | |||
| 42868 | 42868 | 176330 | DPW Maintained 3 | Eucalyptus Spp :: Eucalyptus 40 | 700x Mansell St | 35 | Median : Cutout 11 | Tree 1 | DPW 2 | 7 | Width 0ft | 6009184.10476 | 2089961.98667 | 37.7191562718235 | -122.41025937136801 | (37.7191562718235, -122.410259371368) | |||
| 156596 | 156596 | 176329 | DPW Maintained 3 | Eucalyptus Spp :: Eucalyptus 40 | 700x Mansell St | 33 | Median : Cutout 11 | Tree 1 | DPW 2 | 11 | Width 0ft | 6009197.90265 | 2089964.9760099999 | 37.719165253359 | -122.41021188808399 | (37.719165253359, -122.410211888084) | |||
| 130335 | 130335 | 176324 | DPW Maintained 3 | Eucalyptus Spp :: Eucalyptus 40 | 700x Mansell St | 24 | Median : Cutout 11 | Tree 1 | DPW 2 | 43 | Width 0ft | 6009336.81226 | 2089985.3560799998 | 37.719228998190204 | -122.409733166348 | (37.7192289981902, -122.409733166348) | |||
| 40506 | 40506 | 176323 | DPW Maintained 3 | Eucalyptus Spp :: Eucalyptus 40 | 700x Mansell St | 23 | Median : Cutout 11 | Tree 1 | DPW 2 | 31 | Width 0ft | 6009342.20287 | 2090002.90208 | 37.719277477945 | -122.40971577078399 | (37.719277477945, -122.409715770784) | |||
| 62801 | 62801 | 176326 | DPW Maintained 3 | Eucalyptus Spp :: Eucalyptus 40 | 700x Mansell St | 26 | Median : Cutout 11 | Tree 1 | DPW 2 | 11 | Width 0ft | 6009300.414580001 | 2090007.1642099998 | 37.719286839006706 | -122.40986051846701 | (37.7192868390067, -122.409860518467) | |||
| 75997 | 75997 | 176325 | DPW Maintained 3 | Eucalyptus Spp :: Eucalyptus 40 | 700x Mansell St | 25 | Median : Cutout 11 | Tree 1 | DPW 2 | 7 | Width 0ft | 6009306.38792 | 2090008.2878700001 | 37.7192902591068 | -122.40983995006701 | (37.7192902591068, -122.409839950067) | |||
| 72173 | 72173 | 176321 | DPW Maintained 3 | Eucalyptus Spp :: Eucalyptus 40 | 700x Mansell St | 10 | Median : Cutout 11 | Tree 1 | DPW 2 | 20 | Width 0ft | 6009491.13352 | 2090035.22052 | 37.7193745624679 | -122.409203250746 | (37.7193745624679, -122.409203250746) | |||
| 66989 | 66989 | 176322 | DPW Maintained 3 | Eucalyptus Spp :: Eucalyptus 40 | 700x Mansell St | 11 | Median : Cutout 11 | Tree 1 | DPW 2 | 11 | Width 0ft | 6009482.932019999 | 2090051.6391099999 | 37.7194191850237 | -122.40923275838699 | (37.7194191850237, -122.409232758387) | |||
| 178932 | 178932 | 176320 | DPW Maintained 3 | Eucalyptus Spp :: Eucalyptus 40 | 700x Mansell St | 5 | Median : Cutout 11 | Tree 1 | DPW 2 | 15 | Width 0ft | 6009693.65645 | 2090109.67926 | 37.7195903547889 | -122.408508450717 | (37.7195903547889, -122.408508450717) | |||
| 177490 | 177490 | 176319 | DPW Maintained 3 | Eucalyptus Spp :: Eucalyptus 40 | 700x Mansell St | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 18 | Width 0ft | 6009753.29629 | 2090123.38013 | 37.7196313144016 | -122.40830326229602 | (37.7196313144016, -122.408303262296) | |||
| 64735 | 64735 | 176318 | DPW Maintained 3 | Eucalyptus Spp :: Eucalyptus 40 | 600x Mansell St | 6 | Median : Cutout 11 | Tree 1 | DPW 2 | 24 | Width 0ft | 6009900.75619 | 2090162.07565 | 37.71974582058 | -122.40779627129 | (37.71974582058, -122.40779627129) | |||
| 37371 | 37371 | 176317 | DPW Maintained 3 | Eucalyptus Spp :: Eucalyptus 40 | 600x Mansell St | 5 | Median : Cutout 11 | Tree 1 | DPW 2 | 20 | Width 0ft | 6009952.88344 | 2090194.2340000002 | 37.7198370388417 | -122.40761835123199 | (37.7198370388417, -122.407618351232) | |||
| 73620 | 73620 | 176316 | DPW Maintained 3 | Eucalyptus Spp :: Eucalyptus 40 | 600x Mansell St | 4 | Median : Cutout 11 | Tree 1 | DPW 2 | 20 | Width 0ft | 6009975.17316 | 2090196.6271099998 | 37.7198448575227 | -122.40754147176001 | (37.7198448575227, -122.40754147176) | |||
| 174476 | 174476 | 176315 | DPW Maintained 3 | Eucalyptus Spp :: Eucalyptus 40 | 600x Mansell St | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 36 | Width 0ft | 6010056.94301 | 2090202.23729 | 37.7198648386596 | -122.40725921596399 | (37.7198648386596, -122.407259215964) | |||
| 152213 | 152213 | 176314 | DPW Maintained 3 | Eucalyptus Spp :: Eucalyptus 40 | 500x Mansell St | 19 | Median : Cutout 11 | Tree 1 | DPW 2 | 35 | Width 0ft | 6010185.666130001 | 2090251.18564 | 37.720006444117296 | -122.406817710885 | (37.7200064441173, -122.406817710885) | |||
| 23642 | 23642 | 176313 | DPW Maintained 3 | Eucalyptus Spp :: Eucalyptus 40 | 500x Mansell St | 18 | Median : Cutout 11 | Tree 1 | DPW 2 | 38 | Width 0ft | 6010259.13784 | 2090270.57035 | 37.7200637812891 | -122.40656510840799 | (37.7200637812891, -122.406565108408) | |||
| 152100 | 152100 | 176311 | DPW Maintained 3 | Eucalyptus Spp :: Eucalyptus 40 | 500x Mansell St | 16 | Median : Cutout 11 | Tree 1 | DPW 2 | 15 | Width 0ft | 6010356.570719999 | 2090296.4274 | 37.7201402299675 | -122.40623013522499 | (37.7201402299675, -122.406230135225) | |||
| 64522 | 64522 | 176312 | DPW Maintained 3 | Eucalyptus Spp :: Eucalyptus 40 | 500x Mansell St | 15 | Median : Cutout 11 | Tree 1 | DPW 2 | 13 | Width 0ft | 6010340.9019 | 2090322.69069 | 37.720211467072296 | -122.406286146812 | (37.7202114670723, -122.406286146812) | |||
| 153553 | 153553 | 176310 | DPW Maintained 3 | Eucalyptus Spp :: Eucalyptus 40 | 500x Mansell St | 8 | Median : Cutout 11 | Tree 1 | DPW 2 | 29 | Width 0ft | 6010469.51848 | 2090335.25755 | 37.720253166839704 | -122.40584244467199 | (37.7202531668397, -122.405842444672) | |||
| 108971 | 108971 | 115772 | Permitted Site 1 | Eucalyptus Spp :: Eucalyptus 40 | 1204 Egbert Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/24/2016 12:00:00 AM | 3 | Permit Number 775363 | 6015358.9 | 2090410.1 | 37.7207308974409 | -122.38894654781099 | (37.7207308974409, -122.388946547811) | ||
| 62350 | 62350 | 176309 | DPW Maintained 3 | Eucalyptus Spp :: Eucalyptus 40 | 300x Mansell St | 21 | Median : Cutout 11 | Tree 1 | DPW 2 | 24 | Width 0ft | 6010760.4946 | 2090426.07331 | 37.720518796898 | -122.404843021812 | (37.720518796898, -122.404843021812) | |||
| 30294 | 30294 | 176308 | DPW Maintained 3 | Eucalyptus Spp :: Eucalyptus 40 | 300x Mansell St | 12 | Median : Cutout 11 | Tree 1 | DPW 2 | 23 | Width 0ft | 6010842.734619999 | 2090461.59096 | 37.7206209176161 | -122.404561241708 | (37.7206209176161, -122.404561241708) | |||
| 36490 | 36490 | 176307 | DPW Maintained 3 | Eucalyptus Spp :: Eucalyptus 40 | 300x Mansell St | 7 | Median : Cutout 11 | Tree 1 | DPW 2 | 14 | Width 0ft | 6010889.97096 | 2090468.7148799999 | 37.7206431182563 | -122.404398460825 | (37.7206431182563, -122.404398460825) | |||
| 70430 | 70430 | 176306 | DPW Maintained 3 | Eucalyptus Spp :: Eucalyptus 40 | 300x Mansell St | 5 | Median : Cutout 11 | Tree 1 | DPW 2 | 17 | Width 0ft | 6010916.0273400005 | 2090472.38873 | 37.7206546619672 | -122.40430865004299 | (37.7206546619672, -122.404308650043) | |||
| 158945 | 158945 | 176305 | DPW Maintained 3 | Eucalyptus Spp :: Eucalyptus 40 | 300x Mansell St | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 28 | Width 0ft | 6010925.6651800005 | 2090483.18833 | 37.7206848540134 | -122.404276094583 | (37.7206848540134, -122.404276094583) |
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");