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 | ||||||||
119576 | 119576 | 68317 | Permitted Site 1 | Eucalyptus Spp :: Eucalyptus 40 | 1999X 48th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/09/1993 12:00:00 AM | Permit Number 32130 | 5981353.71840295 | 2101490.23529545 | 37.7492103807501 | -122.50731153380801 | (37.7492103807501, -122.507311533808) | ||
121834 | 121834 | 69022 | Permitted Site 1 | Eucalyptus Spp :: Eucalyptus 40 | 2094 48th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/05/1994 12:00:00 AM | Permit Number 33026 | 5981407.07152231 | 2100831.13487358 | 37.7474038185251 | -122.507078153918 | (37.7474038185251, -122.507078153918) | ||
93083 | 93083 | 34702 | Permitted Site 1 | Eucalyptus Spp :: Eucalyptus 40 | 546 46th Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/28/1997 12:00:00 AM | Permit Number 38359 | 5981647.34162822 | 2112027.92469202 | 37.7781611337001 | -122.50707780583099 | (37.7781611337001, -122.507077805831) | ||
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) | |
152160 | 152160 | 51577 | Permitted Site 1 | Eucalyptus Spp :: Eucalyptus 40 | 584 43rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/08/2005 12:00:00 AM | 28 | Permit Number 47871 | 5982583.51771 | 2111812.9357 | 37.7776259284617 | -122.50382336032 | (37.7776259284617, -122.50382336032) | |
165342 | 165342 | 62644 | Permitted Site 1 | Eucalyptus Spp :: Eucalyptus 40 | 1255 42nd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/03/2008 12:00:00 AM | 1 | 3x3 | Permit Number 50627 | 5983022.3246657 | 2106594.48040873 | 37.763323345885404 | -122.50191918393699 | (37.7633233458854, -122.501919183937) | |
85692 | 85692 | 63202 | Permitted Site 1 | Eucalyptus Spp :: Eucalyptus 40 | 7 Shore View Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/18/1986 12:00:00 AM | Permit Number 23744 | 5984650.094069201 | 2112837.90974399 | 37.78056150785579 | -122.496750144554 | (37.7805615078558, -122.496750144554) | ||
182351 | 182351 | 181588 | Undocumented 2 | Eucalyptus Spp :: Eucalyptus 40 | 1227 37th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 0ft | 5984569.5881 | 2106811.9615 | 37.764011258359105 | -122.496583837339 | (37.7640112583591, -122.496583837339) | |||
166229 | 166229 | 183716 | Undocumented 2 | Eucalyptus Spp :: Eucalyptus 40 | 1231 37th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 0ft | 5984571.0948 | 2106790.8677 | 37.7639534289968 | -122.49657706948 | (37.7639534289968, -122.49657706948) | |||
111909 | 111909 | 60551 | Permitted Site 1 | Eucalyptus Spp :: Eucalyptus 40 | 539 35th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/18/1982 12:00:00 AM | Permit Number 20161 | 5985003.93496372 | 2112200.51497155 | 37.7788321315722 | -122.49547903508801 | (37.7788321315722, -122.495479035088) | ||
126005 | 126005 | 60557 | Permitted Site 1 | Eucalyptus Spp :: Eucalyptus 40 | 646 35th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/18/1982 12:00:00 AM | Permit Number 20167 | 5985081.30797731 | 2111459.74994128 | 37.776802733932 | -122.495156735304 | (37.776802733932, -122.495156735304) | ||
99896 | 99896 | 20988 | DPW Maintained 3 | Eucalyptus Spp :: Eucalyptus 40 | 2002X Sunset Blvd | 28 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 200 | 40 | 5984887.616570599 | 2101567.3225095 | 37.7496295616808 | -122.49509712324499 | (37.7496295616808, -122.495097123245) | |||
41295 | 41295 | 187029 | Undocumented 2 | Eucalyptus Spp :: Eucalyptus 40 | 2501 Sunset Blvd | 48 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 38 | Width 0ft | 5984947.4301 | 2097843.1311 | 37.7394074439231 | -122.49461576933999 | (37.7394074439231, -122.49461576934) | |||
43878 | 43878 | 187030 | Undocumented 2 | Eucalyptus Spp :: Eucalyptus 40 | 2501 Sunset Blvd | 49 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 16 | Width 0ft | 5984957.5185 | 2097843.1311 | 37.7394080343891 | -122.49458088860901 | (37.7394080343891, -122.494580888609) | |||
182619 | 182619 | 187037 | Undocumented 2 | Eucalyptus Spp :: Eucalyptus 40 | 2501 Sunset Blvd | 56 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 29 | Width 0ft | 5984959.5362 | 2097794.0341 | 37.7392733453171 | -122.49457029390899 | (37.7392733453171, -122.494570293909) | |||
72098 | 72098 | 187038 | Undocumented 2 | Eucalyptus Spp :: Eucalyptus 40 | 2501 Sunset Blvd | 57 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 0ft | 5984961.8902 | 2097789.6624 | 37.7392614795793 | -122.494561832752 | (37.7392614795793, -122.494561832752) | |||
131781 | 131781 | 187031 | Undocumented 2 | Eucalyptus Spp :: Eucalyptus 40 | 2501 Sunset Blvd | 50 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 19 | Width 0ft | 5984966.2618 | 2097842.7948 | 37.7394076227298 | -122.494550633787 | (37.7394076227298, -122.494550633787) | |||
28658 | 28658 | 187032 | Undocumented 2 | Eucalyptus Spp :: Eucalyptus 40 | 2501 Sunset Blvd | 51 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 11 | Width 0ft | 5984967.607000001 | 2097835.0603 | 37.73938646460329 | -122.494545412715 | (37.7393864646033, -122.494545412715) | |||
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) | |||
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) | |||
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) | |||
82877 | 82877 | 12490 | Permitted Site 1 | Eucalyptus Spp :: Eucalyptus 40 | 307 Lake Merced Blvd | 35 | Sidewalk: Curb side : Cutout 1 | Tree 1 | PUC 13 | 24 | 90M | 5985224.7663097 | 2094165.6248746999 | 37.7293262181041 | -122.49338600271003 | (37.7293262181041, -122.49338600271) | |||
96574 | 96574 | 12496 | Permitted Site 1 | Eucalyptus Spp :: Eucalyptus 40 | 307 Lake Merced Blvd | 41 | Sidewalk: Curb side : Cutout 1 | Tree 1 | PUC 13 | 24 | 90M | 5985224.7663097 | 2094165.6248746999 | 37.7293262181041 | -122.49338600271003 | (37.7293262181041, -122.49338600271) | |||
107551 | 107551 | 12488 | Permitted Site 1 | Eucalyptus Spp :: Eucalyptus 40 | 307 Lake Merced Blvd | 33 | Sidewalk: Curb side : Cutout 1 | Tree 1 | PUC 13 | 24 | 90M | 5985224.7663097 | 2094165.6248746999 | 37.7293262181041 | -122.49338600271003 | (37.7293262181041, -122.49338600271) | |||
108276 | 108276 | 12495 | Permitted Site 1 | Eucalyptus Spp :: Eucalyptus 40 | 307 Lake Merced Blvd | 40 | Sidewalk: Curb side : Cutout 1 | Tree 1 | PUC 13 | 18 | 90M | 5985224.7663097 | 2094165.6248746999 | 37.7293262181041 | -122.49338600271003 | (37.7293262181041, -122.49338600271) | |||
170536 | 170536 | 32593 | Permitted Site 1 | Eucalyptus Spp :: Eucalyptus 40 | 1375 34th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/22/1996 12:00:00 AM | 1 | Permit Number 37061 | 5985530.158172799 | 2105866.8789552 | 37.7614725555795 | -122.49319192882099 | (37.7614725555795, -122.493191928821) | |
36977 | 36977 | 186970 | DPW Maintained 3 | Eucalyptus Spp :: Eucalyptus 40 | 1650x Sloat Blvd | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 10 | Width 0ft | 5986025.4295 | 2095869.2083 | 37.734050611594604 | -122.49074337328301 | (37.7340506115946, -122.490743373283) | |||
104967 | 104967 | 108502 | Undocumented 2 | Eucalyptus Spp :: Eucalyptus 40 | 2300 33RD AVE | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 32 | 5986128.8 | 2099536.7 | 37.7441266056665 | -122.49065574130199 | (37.7441266056665, -122.490655741302) | ||||
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) | |
53330 | 53330 | 186974 | DPW Maintained 3 | Eucalyptus Spp :: Eucalyptus 40 | 1600x Sloat Blvd | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 9 | Width 0ft | 5986249.0864 | 2095869.2083 | 37.7340636742344 | -122.489970132524 | (37.7340636742344, -122.489970132524) | |||
94515 | 94515 | 107708 | Undocumented 2 | Eucalyptus Spp :: Eucalyptus 40 | 1798X 31st Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5986575.46002 | 2103344.33269 | 37.7546074174257 | -122.489391225039 | (37.7546074174257, -122.489391225039) | ||||
100492 | 100492 | 107709 | Undocumented 2 | Eucalyptus Spp :: Eucalyptus 40 | 1798X 31st Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5986575.46002 | 2103344.33269 | 37.7546074174257 | -122.489391225039 | (37.7546074174257, -122.489391225039) | ||||
120953 | 120953 | 107712 | Undocumented 2 | Eucalyptus Spp :: Eucalyptus 40 | 1798X 31st Ave | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5986575.46002 | 2103344.33269 | 37.7546074174257 | -122.489391225039 | (37.7546074174257, -122.489391225039) | ||||
139574 | 139574 | 107711 | Undocumented 2 | Eucalyptus Spp :: Eucalyptus 40 | 1798X 31st Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5986575.46002 | 2103344.33269 | 37.7546074174257 | -122.489391225039 | (37.7546074174257, -122.489391225039) | ||||
81453 | 81453 | 114249 | Significant Tree 6 | Eucalyptus Spp :: Eucalyptus 40 | 499x 24TH AVE | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 3x3 | 5988415.0 | 2112957.0 | 37.78110836988721 | -122.483734439284 | (37.7811083698872, -122.483734439284) | ||||
132300 | 132300 | 185059 | DPW Maintained 3 | Eucalyptus Spp :: Eucalyptus 40 | 700x Sloat Blvd | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 13 | Width 0ft | 5988840.8776 | 2095965.7184 | 37.7344796690595 | -122.481016672562 | (37.7344796690595, -122.481016672562) | |||
58856 | 58856 | 185127 | DPW Maintained 3 | Eucalyptus Spp :: Eucalyptus 40 | 700x Sloat Blvd | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 10 | Width 0ft | 5989015.4133 | 2095969.6432 | 37.734500589899504 | -122.480413539116 | (37.7345005898995, -122.480413539116) | |||
117345 | 117345 | 51287 | Permitted Site 1 | Eucalyptus Spp :: Eucalyptus 40 | 726 21st Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/09/1993 12:00:00 AM | Permit Number 47659 | 5989465.45229129 | 2110387.70383509 | 37.774114887360504 | -122.479912367003 | (37.7741148873605, -122.479912367003) | ||
98498 | 98498 | 109631 | Undocumented 2 | Eucalyptus Spp :: Eucalyptus 40 | 390 BUCKINGHAM WAY | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9x9 | 5989374.0 | 2093588.0 | 37.7279820381776 | -122.478999652651 | (37.7279820381776, -122.478999652651) | |||||
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) | ||
131175 | 131175 | 218283 | DPW Maintained 3 | Eucalyptus Spp :: Eucalyptus 40 | 2x Sloat Blvd | 8 | Median : Yard 3 | Tree 1 | DPW 2 | 10 | 5990775.7158 | 2095986.69925 | 37.7346495609245 | -122.474328895956 | (37.7346495609245, -122.474328895956) | ||||
88646 | 88646 | 69470 | Permitted Site 1 | Eucalyptus Spp :: Eucalyptus 40 | 1570 16th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/16/1994 12:00:00 AM | Permit Number 33586 | 5991155.36555461 | 2104799.07062441 | 37.75886803765071 | -122.47365896033001 | (37.7588680376507, -122.47365896033) | ||
147460 | 147460 | 217803 | DPW Maintained 3 | Eucalyptus Spp :: Eucalyptus 40 | 2x Sloat Blvd | 3 | Median : Yard 3 | Tree 1 | DPW 2 | 34 | 5991018.47185 | 2095992.29774 | 37.734678993934494 | -122.473490022742 | (37.7346789939345, -122.473490022742) | ||||
185691 | 185691 | 217802 | DPW Maintained 3 | Eucalyptus Spp :: Eucalyptus 40 | 2x Sloat Blvd | 2 | Median : Yard 3 | Tree 1 | DPW 2 | 15 | 5991046.80022 | 2095992.48375 | 37.734681145124505 | -122.47339209648001 | (37.7346811451245, -122.47339209648) | ||||
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) |
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");