trees
563 rows where qSpecies_id = 52 sorted by Zip Codes
This data as json, CSV (advanced)
rowid | TreeID | qLegalStatus_id | qSpecies_id | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker_id | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location | Fire Prevention Districts | Police Districts | Supervisor Districts | Zip Codes ▼ | Neighborhoods (old) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
900 | 19637 | DPW Maintained 1 | Eucalyptus Spp :: Eucalyptus 52 | 100 STAIRWAY5 | 36 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 30 | |||||||||||||
1171 | 19952 | DPW Maintained 1 | Eucalyptus Spp :: Eucalyptus 52 | 100 STAIRWAY39 | 9 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 25ST | |||||||||||||
1350 | 19628 | DPW Maintained 1 | Eucalyptus Spp :: Eucalyptus 52 | 100 STAIRWAY5 | 27 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 30 | |||||||||||||
1420 | 19991 | DPW Maintained 1 | Eucalyptus Spp :: Eucalyptus 52 | 100 STAIRWAY46 | 11 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 40 | |||||||||||||
2026 | 19643 | DPW Maintained 1 | Eucalyptus Spp :: Eucalyptus 52 | 100 STAIRWAY5 | 42 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 30 | |||||||||||||
2649 | 20050 | DPW Maintained 1 | Eucalyptus Spp :: Eucalyptus 52 | 100 STAIRWAY52 | 6 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 10 | |||||||||||||
3196 | 19917 | DPW Maintained 1 | Eucalyptus Spp :: Eucalyptus 52 | 100 STAIRWAY35 | 13 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 120ST | |||||||||||||
3527 | 19876 | DPW Maintained 1 | Eucalyptus Spp :: Eucalyptus 52 | 100 STAIRWAY33 | 8 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 25ST | |||||||||||||
3552 | 19877 | DPW Maintained 1 | Eucalyptus Spp :: Eucalyptus 52 | 100 STAIRWAY33 | 9 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 24 | 25ST | |||||||||||||
4099 | 19572 | DPW Maintained 1 | Eucalyptus Spp :: Eucalyptus 52 | 100 STAIRWAY1 | 6 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 24 | 100ST | |||||||||||||
4115 | 19918 | DPW Maintained 1 | Eucalyptus Spp :: Eucalyptus 52 | 100 STAIRWAY35 | 14 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 120ST | |||||||||||||
4242 | 19575 | DPW Maintained 1 | Eucalyptus Spp :: Eucalyptus 52 | 100 STAIRWAY1 | 10 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 36 | 100ST | |||||||||||||
4705 | 19622 | DPW Maintained 1 | Eucalyptus Spp :: Eucalyptus 52 | 100 STAIRWAY5 | 21 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 30 | |||||||||||||
4768 | 17628 | DPW Maintained 1 | Eucalyptus Spp :: Eucalyptus 52 | 150 Phelps St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 10M | |||||||||||||
4870 | 19873 | DPW Maintained 1 | Eucalyptus Spp :: Eucalyptus 52 | 100 STAIRWAY33 | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 30 | 25ST | |||||||||||||
5641 | 19822 | DPW Maintained 1 | Eucalyptus Spp :: Eucalyptus 52 | 100 STAIRWAY25 | 6 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 10ST | |||||||||||||
5768 | 87061 | Permitted Site 7 | Eucalyptus Spp :: Eucalyptus 52 | unknown : Yard | Tree | Private 2 | 3x3 | Permit Number 50003 | |||||||||||||||
6428 | 19770 | DPW Maintained 1 | Eucalyptus Spp :: Eucalyptus 52 | 100 STAIRWAY16 | 9 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 30ST | |||||||||||||
6890 | 19879 | DPW Maintained 1 | Eucalyptus Spp :: Eucalyptus 52 | 100 STAIRWAY33 | 11 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 25ST | |||||||||||||
7211 | 19619 | DPW Maintained 1 | Eucalyptus Spp :: Eucalyptus 52 | 100 STAIRWAY5 | 18 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 30 | |||||||||||||
7383 | 17629 | DPW Maintained 1 | Eucalyptus Spp :: Eucalyptus 52 | 150 Phelps St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 10M | |||||||||||||
7681 | 19824 | DPW Maintained 1 | Eucalyptus Spp :: Eucalyptus 52 | 100 STAIRWAY25 | 8 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 10ST | |||||||||||||
8240 | 20391 | DPW Maintained 1 | Eucalyptus Spp :: Eucalyptus 52 | 262X Sunset Blvd | 37 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 60 | |||||||||||||
8446 | 19823 | DPW Maintained 1 | Eucalyptus Spp :: Eucalyptus 52 | 100 STAIRWAY25 | 7 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 10ST | |||||||||||||
8556 | 19623 | DPW Maintained 1 | Eucalyptus Spp :: Eucalyptus 52 | 100 STAIRWAY5 | 22 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 30 | |||||||||||||
8778 | 19630 | DPW Maintained 1 | Eucalyptus Spp :: Eucalyptus 52 | 100 STAIRWAY5 | 29 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 30 | |||||||||||||
9166 | 19571 | DPW Maintained 1 | Eucalyptus Spp :: Eucalyptus 52 | 100 STAIRWAY1 | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 24 | 100ST | |||||||||||||
9314 | 19995 | DPW Maintained 1 | Eucalyptus Spp :: Eucalyptus 52 | 100 STAIRWAY46 | 15 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 40 | |||||||||||||
9456 | 19881 | DPW Maintained 1 | Eucalyptus Spp :: Eucalyptus 52 | 100 STAIRWAY33 | 13 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 25ST | |||||||||||||
9686 | 19629 | DPW Maintained 1 | Eucalyptus Spp :: Eucalyptus 52 | 100 STAIRWAY5 | 28 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 30 | |||||||||||||
9690 | 19636 | DPW Maintained 1 | Eucalyptus Spp :: Eucalyptus 52 | 100 STAIRWAY5 | 35 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 30 | |||||||||||||
9767 | 19990 | DPW Maintained 1 | Eucalyptus Spp :: Eucalyptus 52 | 100 STAIRWAY46 | 10 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 40 | |||||||||||||
10139 | 19618 | DPW Maintained 1 | Eucalyptus Spp :: Eucalyptus 52 | 100 STAIRWAY5 | 17 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 30 | |||||||||||||
10150 | 19701 | DPW Maintained 1 | Eucalyptus Spp :: Eucalyptus 52 | 100 STAIRWAY12 | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 60 | |||||||||||||
10734 | 20046 | DPW Maintained 1 | Eucalyptus Spp :: Eucalyptus 52 | 100 STAIRWAY52 | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3 | 10 | |||||||||||||
11237 | 19870 | DPW Maintained 1 | Eucalyptus Spp :: Eucalyptus 52 | 100 STAIRWAY33 | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 36 | 25ST | |||||||||||||
11589 | 19641 | DPW Maintained 1 | Eucalyptus Spp :: Eucalyptus 52 | 100 STAIRWAY5 | 40 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 30 | |||||||||||||
11997 | 20028 | DPW Maintained 1 | Eucalyptus Spp :: Eucalyptus 52 | 100 STAIRWAY49 | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 10 | |||||||||||||
12219 | 19617 | DPW Maintained 1 | Eucalyptus Spp :: Eucalyptus 52 | 100 STAIRWAY5 | 16 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 30 | |||||||||||||
12413 | 19734 | DPW Maintained 1 | Eucalyptus Spp :: Eucalyptus 52 | 100 STAIRWAY14 | 12 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 40ST | |||||||||||||
12534 | 19640 | DPW Maintained 1 | Eucalyptus Spp :: Eucalyptus 52 | 100 STAIRWAY5 | 39 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 30 | |||||||||||||
13069 | 19574 | DPW Maintained 1 | Eucalyptus Spp :: Eucalyptus 52 | 100 STAIRWAY1 | 8 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 100ST | |||||||||||||
13619 | 19639 | DPW Maintained 1 | Eucalyptus Spp :: Eucalyptus 52 | 100 STAIRWAY5 | 38 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 30 | |||||||||||||
13651 | 19987 | DPW Maintained 1 | Eucalyptus Spp :: Eucalyptus 52 | 100 STAIRWAY46 | 7 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 40 | |||||||||||||
13892 | 19884 | DPW Maintained 1 | Eucalyptus Spp :: Eucalyptus 52 | 100 STAIRWAY33 | 16 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 25ST | |||||||||||||
15245 | 19996 | DPW Maintained 1 | Eucalyptus Spp :: Eucalyptus 52 | 100 STAIRWAY46 | 16 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 40 | |||||||||||||
15612 | 19626 | DPW Maintained 1 | Eucalyptus Spp :: Eucalyptus 52 | 100 STAIRWAY5 | 25 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 30 | |||||||||||||
15637 | 19921 | DPW Maintained 1 | Eucalyptus Spp :: Eucalyptus 52 | 100 STAIRWAY37 | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | |||||||||||||
15654 | 19916 | DPW Maintained 1 | Eucalyptus Spp :: Eucalyptus 52 | 100 STAIRWAY35 | 12 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 120ST | |||||||||||||
16165 | 19703 | DPW Maintained 1 | Eucalyptus Spp :: Eucalyptus 52 | 100 STAIRWAY13 | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 40ST | |||||||||||||
16570 | 19635 | DPW Maintained 1 | Eucalyptus Spp :: Eucalyptus 52 | 100 STAIRWAY5 | 34 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 30 | |||||||||||||
16689 | 19767 | DPW Maintained 1 | Eucalyptus Spp :: Eucalyptus 52 | 100 STAIRWAY16 | 6 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 30ST | |||||||||||||
16816 | 19567 | DPW Maintained 1 | Eucalyptus Spp :: Eucalyptus 52 | 100 STAIRWAY1 | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 24 | 100ST | |||||||||||||
17526 | 19573 | DPW Maintained 1 | Eucalyptus Spp :: Eucalyptus 52 | 100 STAIRWAY1 | 7 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 100ST | |||||||||||||
18251 | 19765 | DPW Maintained 1 | Eucalyptus Spp :: Eucalyptus 52 | 100 STAIRWAY16 | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 30ST | |||||||||||||
116 | 113159 | Undocumented 4 | Eucalyptus Spp :: Eucalyptus 52 | 555 GROVE ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6005146 | 2111243 | 37.777361853017 | -122.425731455878 | (37.777361853017, -122.425731455878) | 7 | 9 | 11 | 28852 | 10 | ||||
3489 | 244479 | DPW Maintained 1 | Eucalyptus Spp :: Eucalyptus 52 | 124 Lily St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 0ft | 6005906.1302 | 2110197.2252 | 37.7745333330343 | -122.423027565946 | (37.7745333330343, -122.423027565946) | 7 | 9 | 11 | 28852 | 10 | |||
3823 | 121262 | DPW Maintained 1 | Eucalyptus Spp :: Eucalyptus 52 | 505 Grove St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | 3x3 | 6005321 | 2111256 | 37.7774074352434 | -122.42512699851 | (37.7774074352434, -122.42512699851) | 7 | 9 | 11 | 28852 | 10 | |||
31523 | 98952 | Significant Tree 6 | Eucalyptus Spp :: Eucalyptus 52 | 302 Ivy St | 18 | Front Yard : Yard | Tree | Private 2 | 6005888.5 | 2111234.3 | 37.7773798943726 | -122.42316228433 | (37.7773798943726, -122.42316228433) | 7 | 9 | 11 | 28852 | 10 | |||||
35379 | 254803 | Undocumented 4 | Eucalyptus Spp :: Eucalyptus 52 | 525 Hayes St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6005345 | 2110923 | 37.7764944541895 | -122.425020275756 | (37.7764944541895, -122.425020275756) | 7 | 9 | 11 | 28852 | 10 | ||||
38428 | 58101 | Permitted Site 7 | Eucalyptus Spp :: Eucalyptus 52 | 535 Buchanan St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/15/1990 12:00:00 AM | Permit Number 29160 | 6004548.41463352 | 2110369.10321649 | 37.774928559979 | -122.427736418344 | (37.774928559979, -122.427736418344) | 7 | 9 | 11 | 28852 | 10 | ||
42746 | 87674 | Permitted Site 7 | Eucalyptus Spp :: Eucalyptus 52 | 770 Golden Gate Ave | 10 | Front Yard : Cutout | Tree | Private 2 | 05/22/2008 12:00:00 AM | 3x3 | Permit Number 50396 | 6005860.1 | 2112469.5 | 37.7807698496384 | -122.423348359154 | (37.7807698496384, -122.423348359154) | 7 | 9 | 11 | 28852 | 41 | ||
70602 | 142225 | DPW Maintained 1 | Eucalyptus Spp :: Eucalyptus 52 | 641 HAYES ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 0ft | 6004777.6628 | 2110866.818 | 37.7763081284007 | -122.426978855787 | (37.7763081284007, -122.426978855787) | 7 | 9 | 11 | 28852 | 10 | |||
77919 | 32699 | Permitted Site 7 | Eucalyptus Spp :: Eucalyptus 52 | 665 Geary St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/29/1996 12:00:00 AM | Permit Number 37104 | 6008544.39382175 | 2114510.13304212 | 37.7865240684083 | -122.414206472781 | (37.7865240684083, -122.414206472781) | 5 | 1 | 9 | 28852 | 36 | ||
137140 | 112418 | DPW Maintained 1 | Eucalyptus Spp :: Eucalyptus 52 | 268X Lily St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2.5x3 | 6005334.87738 | 2110100.0463 | 37.7742342515583 | -122.424996726643 | (37.7742342515583, -122.424996726643) | 7 | 9 | 11 | 28852 | 10 | ||||
140823 | 98951 | Significant Tree 6 | Eucalyptus Spp :: Eucalyptus 52 | 401 Grove St | 11 | Front Yard : Yard | Tree | Private 2 | 6005778.2 | 2111279 | 37.7774964045324 | -122.423547027313 | (37.7774964045324, -122.423547027313) | 7 | 9 | 11 | 28852 | 10 | |||||
146575 | 122380 | DPW Maintained 1 | Eucalyptus Spp :: Eucalyptus 52 | 557 Grove St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | 3x3 | 6005149 | 2111246 | 37.777370259808 | -122.425721291473 | (37.777370259808, -122.425721291473) | 7 | 9 | 11 | 28852 | 10 | |||
150229 | 87675 | Permitted Site 7 | Eucalyptus Spp :: Eucalyptus 52 | 770 Golden Gate Ave | 11 | Front Yard : Cutout | Tree | Private 2 | 05/22/2008 12:00:00 AM | 3x3 | Permit Number 50396 | 6005860.1 | 2112469.5 | 37.7807698496384 | -122.423348359154 | (37.7807698496384, -122.423348359154) | 7 | 9 | 11 | 28852 | 41 | ||
5213 | 84938 | Significant Tree 6 | Eucalyptus Spp :: Eucalyptus 52 | 145 Guerrero St | 1 | Front Yard : Yard | Tree | Private 2 | Permit Number 49347 | 6005480 | 2108218 | 37.7690748022624 | -122.42436083172 | (37.7690748022624, -122.42436083172) | 8 | 4 | 5 | 28853 | 19 | ||||
44857 | 6104 | DPW Maintained 1 | Eucalyptus Spp :: Eucalyptus 52 | 500X 08th St | 6 | Median : Cutout | Tree | DPW 1 | 12 | 18 | 6010526.8124541 | 2109340.6023904 | 37.7724409020578 | -122.406983260044 | (37.7724409020578, -122.406983260044) | 14 | 2 | 9 | 28853 | 34 | |||
48855 | 6103 | DPW Maintained 1 | Eucalyptus Spp :: Eucalyptus 52 | 500X 08th St | 5 | Median : Cutout | Tree | DPW 1 | 3 | 18 | 6010526.8124541 | 2109340.6023904 | 37.7724409020578 | -122.406983260044 | (37.7724409020578, -122.406983260044) | 14 | 2 | 9 | 28853 | 34 | |||
66384 | 66803 | Permitted Site 7 | Eucalyptus Spp :: Eucalyptus 52 | 42 Woodward St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/20/1991 12:00:00 AM | Permit Number 30083 | 6006463.70585844 | 2108242.90937755 | 37.76919869647 | -122.420960014682 | (37.76919869647, -122.420960014682) | 8 | 4 | 7 | 28853 | 19 | ||
82519 | 6106 | DPW Maintained 1 | Eucalyptus Spp :: Eucalyptus 52 | 500X 08th St | 8 | Median : Cutout | Tree | DPW 1 | 18 | 18 | 6010526.8124541 | 2109340.6023904 | 37.7724409020578 | -122.406983260044 | (37.7724409020578, -122.406983260044) | 14 | 2 | 9 | 28853 | 34 | |||
83538 | 6101 | DPW Maintained 1 | Eucalyptus Spp :: Eucalyptus 52 | 500X 08th St | 3 | Median : Cutout | Tree | DPW 1 | 3 | 18 | 6010526.8124541 | 2109340.6023904 | 37.7724409020578 | -122.406983260044 | (37.7724409020578, -122.406983260044) | 14 | 2 | 9 | 28853 | 34 | |||
92481 | 32999 | Permitted Site 7 | Eucalyptus Spp :: Eucalyptus 52 | 666 Folsom St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/01/1996 12:00:00 AM | Permit Number 37299 | 6013145.25876593 | 2113656.86996444 | 37.7844385625752 | -122.39822862272 | (37.7844385625752, -122.39822862272) | 6 | 2 | 9 | 28853 | 6 | ||
108995 | 6102 | DPW Maintained 1 | Eucalyptus Spp :: Eucalyptus 52 | 500X 08th St | 4 | Sidewalk: Property side : Cutout | Tree | DPW 1 | 6 | 18 | 6010526.8124541 | 2109340.6023904 | 37.7724409020578 | -122.406983260044 | (37.7724409020578, -122.406983260044) | 14 | 2 | 9 | 28853 | 34 | |||
140238 | 6100 | DPW Maintained 1 | Eucalyptus Spp :: Eucalyptus 52 | 500X 08th St | 2 | Median : Cutout | Tree | DPW 1 | 24 | 18 | 6010526.8124541 | 2109340.6023904 | 37.7724409020578 | -122.406983260044 | (37.7724409020578, -122.406983260044) | 14 | 2 | 9 | 28853 | 34 | |||
152575 | 6105 | DPW Maintained 1 | Eucalyptus Spp :: Eucalyptus 52 | 500X 08th St | 7 | Sidewalk: Property side : Cutout | Tree | DPW 1 | 3 | 18 | 6010526.8124541 | 2109340.6023904 | 37.7724409020578 | -122.406983260044 | (37.7724409020578, -122.406983260044) | 14 | 2 | 9 | 28853 | 34 | |||
180688 | 32992 | Permitted Site 7 | Eucalyptus Spp :: Eucalyptus 52 | 666 Folsom St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/01/1996 12:00:00 AM | Permit Number 37299 | 6013145.25876593 | 2113656.86996444 | 37.7844385625752 | -122.39822862272 | (37.7844385625752, -122.39822862272) | 6 | 2 | 9 | 28853 | 6 | ||
181750 | 6099 | Significant Tree 6 | Eucalyptus Spp :: Eucalyptus 52 | 500X 08th St | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | 18 | 18 | 6010526.8124541 | 2109340.6023904 | 37.7724409020578 | -122.406983260044 | (37.7724409020578, -122.406983260044) | 14 | 2 | 9 | 28853 | 34 | |||
184426 | 32990 | Permitted Site 7 | Eucalyptus Spp :: Eucalyptus 52 | 666 Folsom St | 11 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/01/1996 12:00:00 AM | Permit Number 37299 | 6013145.25876593 | 2113656.86996444 | 37.7844385625752 | -122.39822862272 | (37.7844385625752, -122.39822862272) | 6 | 2 | 9 | 28853 | 6 | ||
186774 | 32991 | Permitted Site 7 | Eucalyptus Spp :: Eucalyptus 52 | 666 Folsom St | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/01/1996 12:00:00 AM | Permit Number 37299 | 6013145.25876593 | 2113656.86996444 | 37.7844385625752 | -122.39822862272 | (37.7844385625752, -122.39822862272) | 6 | 2 | 9 | 28853 | 6 | ||
12194 | 261567 | Undocumented 4 | Eucalyptus Spp :: Eucalyptus 52 | 1299 Wisconsin St | 12 | Sidewalk: Property side : Yard | Tree | DPW 1 | 3x3 | 6013134 | 2101730 | 37.751689413587 | -122.397430852298 | (37.751689413587, -122.397430852298) | 10 | 3 | 8 | 28856 | 29 | ||||
53177 | 191717 | DPW Maintained 1 | Eucalyptus Spp :: Eucalyptus 52 | 554 Rhode Island St | 1 | : | Tree | Private 2 | 13 | Width 6ft | 6011757.49983 | 2105782.3491 | 37.762739532526 | -122.402475918038 | (37.762739532526, -122.402475918038) | 8 | 3 | 8 | 28856 | 29 | |||
84713 | 116639 | DPW Maintained 1 | Eucalyptus Spp :: Eucalyptus 52 | 2100 20th St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/13/2016 12:00:00 AM | 3 | 3x3 | 6011723.51737 | 2104681.28704 | 37.7597143642338 | -122.402516023304 | (37.7597143642338, -122.402516023304) | 10 | 3 | 8 | 28856 | 29 | ||
85125 | 101217 | Permitted Site 7 | Eucalyptus Spp :: Eucalyptus 52 | 444 De Haro St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6011994.2 | 2106304.5 | 37.7641864535036 | -122.401693953948 | (37.7641864535036, -122.401693953948) | 8 | 3 | 8 | 28856 | 29 | ||||
85215 | 104424 | DPW Maintained 1 | Eucalyptus Spp :: Eucalyptus 52 | 917 Rhode Island St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3x3 | 6011907.00978 | 2104135.17777 | 37.7582251112167 | -122.401843021952 | (37.7582251112167, -122.401843021952) | 10 | 3 | 8 | 28856 | 29 | |||
158313 | 30787 | Permitted Site 7 | Eucalyptus Spp :: Eucalyptus 52 | 488 Bryant St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/31/1995 12:00:00 AM | 3x3 | Permit Number 51964 | 6013865.01842582 | 2112595.14259648 | 37.7815633679001 | -122.395664068446 | (37.7815633679001, -122.395664068446) | 6 | 2 | 9 | 28856 | 6 | ||
160280 | 191716 | DPW Maintained 1 | Eucalyptus Spp :: Eucalyptus 52 | 561 Rhode Island St | 1 | : | Tree | Private 2 | 15 | Width 3ft | 6011818.5901 | 2105765.65198 | 37.7626970962079 | -122.402263453208 | (37.7626970962079, -122.402263453208) | 8 | 3 | 8 | 28856 | 29 | |||
192906 | 61359 | Permitted Site 7 | Eucalyptus Spp :: Eucalyptus 52 | 1234 Washington St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/12/2016 12:00:00 AM | 3x3 | Permit Number 21268 | 6008775.22346441 | 2117343.22168335 | 37.7943160027564 | -122.413608310086 | (37.7943160027564, -122.413608310086) | 5 | 1 | 10 | 28857 | 21 | ||
40971 | 23414 | DPW Maintained 1 | Eucalyptus Spp :: Eucalyptus 52 | 1800X VAN NESS AVE | 2 | Median : Cutout | Tree | DPW 1 | 30 | 9 | 6006192 | 2116736 | 37.7925033310543 | -122.422503407712 | (37.7925033310543, -122.422503407712) | 13 | 9 | 10 | 28858 | 32 | |||
46714 | 9895 | DPW Maintained 1 | Eucalyptus Spp :: Eucalyptus 52 | 1800X Pine St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3X3 | 6005051.0377 | 2115464.4068 | 37.7889474242075 | -122.426360597873 | (37.7889474242075, -122.426360597873) | 13 | 9 | 1 | 28858 | 27 | |||
65566 | 32711 | Permitted Site 7 | Eucalyptus Spp :: Eucalyptus 52 | 920 Larkin St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/01/2002 12:00:00 AM | Permit Number 44986 | 6007431.49416975 | 2114487.39461752 | 37.7863990597284 | -122.418055227286 | (37.7863990597284, -122.418055227286) | 13 | 9 | 9 | 28858 | 36 | ||
124647 | 6173 | DPW Maintained 1 | Eucalyptus Spp :: Eucalyptus 52 | 1075 Ellis St | 8 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3X3 | 6005893.15301 | 2113273.27935 | 37.782978696051 | -122.423291166859 | (37.782978696051, -122.423291166859) | 7 | 9 | 11 | 28858 | 41 | |||
146550 | 32724 | Permitted Site 7 | Eucalyptus Spp :: Eucalyptus 52 | 1082 Post St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/29/1996 12:00:00 AM | Permit Number 37114 | 6006978.17320306 | 2114692.47231461 | 37.7869366280698 | -122.419638162258 | (37.7869366280698, -122.419638162258) | 13 | 9 | 10 | 28858 | 21 | ||
184342 | 139748 | DPW Maintained 1 | Eucalyptus Spp :: Eucalyptus 52 | 1330 Laguna St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 20 | Width 0ft | 6004640.4611 | 2113601.4606 | 37.7838090228042 | -122.427648355277 | (37.7838090228042, -122.427648355277) | 7 | 9 | 11 | 28858 | 41 | |||
3070 | 52712 | Permitted Site 7 | Eucalyptus Spp :: Eucalyptus 52 | 53@ FAIR AVE Coleridge St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/31/2006 12:00:00 AM | Permit Number 48768 | 6006913.27477728 | 2099421.81000315 | 37.7450033243522 | -122.418779304454 | (37.7450033243522, -122.418779304454) | 2 | 7 | 7 | 28859 | 2 | ||
3174 | 224198 | DPW Maintained 1 | Eucalyptus Spp :: Eucalyptus 52 | 1001 San Jose Ave | 30 | Front Yard : Yard | Tree | Private 2 | 9 | 6005259.16763 | 2097058.51402 | 37.7384209767501 | -122.424330858406 | (37.7384209767501, -122.424330858406) | 2 | 7 | 5 | 28859 | 2 | ||||
3480 | 40261 | Permitted Site 7 | Eucalyptus Spp :: Eucalyptus 52 | 3543 24th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/16/2005 12:00:00 AM | Permit Number 47928 | 6005992.45992589 | 2101968.12777251 | 37.7519430420387 | -122.422144186794 | (37.7519430420387, -122.422144186794) | 2 | 4 | 5 | 28859 | 19 | ||
7446 | 243531 | DPW Maintained 1 | Eucalyptus Spp :: Eucalyptus 52 | 2095 Harrison St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 0 | 3x3 | 6008748.77289 | 2106455.16153 | 37.764418495754 | -122.412929646495 | (37.764418495754, -122.412929646495) | 8 | 4 | 7 | 28859 | 19 |
Advanced export
JSON shape: default, array, newline-delimited, object
CREATE TABLE "trees" ( [rowid] INTEGER PRIMARY KEY, [TreeID] TEXT, [qLegalStatus_id] INTEGER REFERENCES [qLegalStatus]([id]), [qSpecies_id] INTEGER, [qAddress] TEXT, [SiteOrder] TEXT, [qSiteInfo] TEXT, [PlantType] TEXT, [qCaretaker_id] INTEGER REFERENCES [qCaretaker]([id]), [qCareAssistant] TEXT, [PlantDate] TEXT, [DBH] TEXT, [PlotSize] TEXT, [PermitNotes] TEXT, [XCoord] TEXT, [YCoord] TEXT, [Latitude] TEXT, [Longitude] TEXT, [Location] TEXT, [Fire Prevention Districts] TEXT, [Police Districts] TEXT, [Supervisor Districts] TEXT, [Zip Codes] TEXT, [Neighborhoods (old)] TEXT, FOREIGN KEY(qSpecies_id) REFERENCES qSpecies(id) );