Data source: data.sfgov.org
This data as json, CSV (advanced)
Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord ▼ | Latitude | Longitude | Location |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
172986 | 172986 | 178202 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 121 Santos St | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 19 | Width 6ft | 6006601.88887 | 2086790.1113 | 37.710301888699796 | -122.418960276213 | (37.7103018886998, -122.418960276213) | |||
23244 | 23244 | 24275 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 350X Winding Way | 13 | Median : Cutout 11 | Tree 1 | DPW 2 | 38 | 8 | 6000843.90644 | 2086792.8315400002 | 37.709983443260995 | -122.438861201091 | (37.709983443261, -122.438861201091) | |||
142086 | 142086 | 110077 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 4099x ALEMANY BLVD | Median : Cutout 11 | Tree 1 | Private 1 | 48 | 5991599.0 | 2086829.0 | 37.7095524384103 | -122.470815701049 | (37.7095524384103, -122.470815701049) | |||||
63849 | 63849 | 178200 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 122 Santos St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 24 | Width 6ft | 6006610.83252 | 2086895.84997 | 37.710592728548605 | -122.418936859664 | (37.7105927285486, -122.418936859664) | |||
32064 | 32064 | 178199 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 121 Blythdale Ave | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 29 | Width 6ft | 6006562.8379999995 | 2086935.5981299998 | 37.7106991659919 | -122.419105557176 | (37.7106991659919, -122.419105557176) | |||
137591 | 137591 | 178198 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 121 Blythdale Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 28 | Width 6ft | 6006547.0126 | 2086935.9227099998 | 37.71069916600771 | -122.419160276437 | (37.7106991660077, -122.419160276437) | |||
182806 | 182806 | 178197 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 121 Blythdale Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 52 | Width 6ft | 6006521.5193300005 | 2086937.9712099999 | 37.7107033550432 | -122.419248532308 | (37.7107033550432, -122.419248532308) | |||
176861 | 176861 | 178196 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 147 Blythdale Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 38 | Width 6ft | 6006332.21017 | 2086970.8429400001 | 37.710782950433995 | -122.41990515969 | (37.710782950434, -122.41990515969) | |||
131700 | 131700 | 178213 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 120 Blythdale Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 42 | Width 6ft | 6006498.09731 | 2086981.8198900002 | 37.7108224351885 | -122.419332592836 | (37.7108224351885, -122.419332592836) | |||
55116 | 55116 | 178214 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 120 Blythdale Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 43 | Width 6ft | 6006445.48172 | 2086993.01913 | 37.7108502224358 | -122.419515238836 | (37.7108502224358, -122.419515238836) | |||
2976 | 2976 | 198801 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 150 Executive Park Blvd | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 0 | Width 4ft | 6013745.097 | 2086994.3966599999 | 37.7112624653484 | -122.394285983735 | (37.7112624653484, -122.394285983735) | |||
129798 | 129798 | 178203 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 51 Santos St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 29 | Width 6ft | 6006694.4363400005 | 2087041.2111799999 | 37.710996567319896 | -122.418658207409 | (37.7109965673199, -122.418658207409) | |||
5176 | 5176 | 253818 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 219 Concord St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 5999956.6131 | 2087048.59536 | 37.7106351918399 | -122.44194619318 | (37.7106351918399, -122.44194619318) | ||||
137772 | 137772 | 178195 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 171 Brookdale Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 47 | Width 6ft | 6005642.36131 | 2087076.03846 | 37.7110329062255 | -122.422296907602 | (37.7110329062255, -122.422296907602) | |||
64329 | 64329 | 178204 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 51 Santos St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 38 | Width 6ft | 6006695.95711 | 2087082.33383 | 37.7111095671182 | -122.418655865573 | (37.7111095671182, -122.418655865573) | |||
50330 | 50330 | 178241 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 240 Hahn St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 43 | Width 10ft | 6007345.15685 | 2087110.69087 | 37.7112239590886 | -122.416414074268 | (37.7112239590886, -122.416414074268) | |||
77103 | 77103 | 178215 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 250 Blythdale Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 48 | Width 6ft | 6005849.57581 | 2087139.50656 | 37.7112188626237 | -122.42158522818701 | (37.7112188626237, -122.421585228187) | |||
28096 | 28096 | 178240 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 230 Hahn St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 41 | Width 10ft | 6007365.51864 | 2087166.49263 | 37.7113783241319 | -122.416347648527 | (37.7113783241319, -122.416347648527) | |||
156726 | 156726 | 178205 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 21 Santos St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 31 | Width 6ft | 6006695.10117 | 2087172.7552200002 | 37.7113577971033 | -122.418665232027 | (37.7113577971033, -122.418665232027) | |||
101345 | 101345 | 104689 | Private 5 | Pinus radiata :: Monterey Pine 3 | 657 PALMETTO AVE | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 30 | 5991786.0 | 2087190.1 | 37.7105547448876 | -122.470195680575 | (37.7105547448876, -122.470195680575) | ||||
160634 | 160634 | 178239 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 226 Hahn St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 34 | Width 10ft | 6007375.6791 | 2087193.3972599998 | 37.711452769994004 | -122.416314435664 | (37.711452769994, -122.416314435664) | |||
151660 | 151660 | 178206 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 21 Santos St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 29 | Width 6ft | 6006695.7649 | 2087205.12492 | 37.7114467148783 | -122.41866523203001 | (37.7114467148783, -122.41866523203) | |||
37353 | 37353 | 178207 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 21 Santos St | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 36 | Width 6ft | 6006695.6684 | 2087233.4626200001 | 37.71152451882379 | -122.418667573848 | (37.7115245188238, -122.418667573848) | |||
59269 | 59269 | 178216 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 150 Brookdale Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 47 | Width 6ft | 6005697.331590001 | 2087247.87962 | 37.711507846275794 | -122.42211911702499 | (37.7115078462758, -122.422119117025) | |||
159089 | 159089 | 178238 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 1501 Hahn St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 59 | Width 10ft | 6007397.50689 | 2087251.0490299999 | 37.7116122971515 | -122.416243073555 | (37.7116122971515, -122.416243073555) | |||
67984 | 67984 | 178208 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 21 Santos St | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 36 | Width 6ft | 6006691.70234 | 2087271.32425 | 37.7116282556175 | -122.418683964897 | (37.7116282556175, -122.418683964897) | |||
9985 | 9985 | 120925 | Significant Tree 6 | Pinus radiata :: Monterey Pine 3 | 3995X Alemany Blvd | 8 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 3X3 | Permit Number 778829 | 5992394.0 | 2087287.0 | 37.7108559409462 | -122.468101362588 | (37.7108559409462, -122.468101362588) | |||
9986 | 9986 | 1263 | Significant Tree 6 | Pinus radiata :: Monterey Pine 3 | 3995X Alemany Blvd | 3 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 12/02/1998 12:00:00 AM | 10 | 3X3 | Permit Number 778829 | 5992394.0 | 2087287.0 | 37.7108559409462 | -122.468101362588 | (37.7108559409462, -122.468101362588) | |
9994 | 9994 | 120923 | Significant Tree 6 | Pinus radiata :: Monterey Pine 3 | 3995X Alemany Blvd | 6 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 3X3 | Permit Number 778829 | 5992394.0 | 2087287.0 | 37.7108559409462 | -122.468101362588 | (37.7108559409462, -122.468101362588) | |||
9998 | 9998 | 120931 | Significant Tree 6 | Pinus radiata :: Monterey Pine 3 | 3995X Alemany Blvd | 14 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 3X3 | Permit Number 778829 | 5992394.0 | 2087287.0 | 37.7108559409462 | -122.468101362588 | (37.7108559409462, -122.468101362588) | |||
9999 | 9999 | 120922 | Significant Tree 6 | Pinus radiata :: Monterey Pine 3 | 3995X Alemany Blvd | 5 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 3X3 | Permit Number 778829 | 5992394.0 | 2087287.0 | 37.7108559409462 | -122.468101362588 | (37.7108559409462, -122.468101362588) | |||
10006 | 10006 | 120927 | Significant Tree 6 | Pinus radiata :: Monterey Pine 3 | 3995X Alemany Blvd | 10 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 3X3 | Permit Number 778829 | 5992394.0 | 2087287.0 | 37.7108559409462 | -122.468101362588 | (37.7108559409462, -122.468101362588) | |||
10015 | 10015 | 120928 | Significant Tree 6 | Pinus radiata :: Monterey Pine 3 | 3995X Alemany Blvd | 11 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 3X3 | Permit Number 778829 | 5992394.0 | 2087287.0 | 37.7108559409462 | -122.468101362588 | (37.7108559409462, -122.468101362588) | |||
10021 | 10021 | 120935 | Significant Tree 6 | Pinus radiata :: Monterey Pine 3 | 3995X Alemany Blvd | 18 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 3X3 | Permit Number 778829 | 5992394.0 | 2087287.0 | 37.7108559409462 | -122.468101362588 | (37.7108559409462, -122.468101362588) | |||
79421 | 79421 | 120930 | Significant Tree 6 | Pinus radiata :: Monterey Pine 3 | 3995X Alemany Blvd | 13 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 3X3 | 5992394.0 | 2087287.0 | 37.7108559409462 | -122.468101362588 | (37.7108559409462, -122.468101362588) | ||||
156534 | 156534 | 178217 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 150 Brookdale Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 45 | Width 6ft | 6005712.43963 | 2087290.74695 | 37.711626403007 | -122.42206994298901 | (37.711626403007, -122.422069942989) | |||
57753 | 57753 | 178209 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 21 Santos St | 5 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 26 | Width 6ft | 6006691.744109999 | 2087306.4052 | 37.7117245828943 | -122.418686306739 | (37.7117245828943, -122.418686306739) | |||
186865 | 186865 | 178210 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 21 Santos St | 6 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 32 | Width 6ft | 6006691.01182 | 2087336.7797299998 | 37.711807943747104 | -122.41869099041 | (37.7118079437471, -122.41869099041) | |||
170195 | 170195 | 178211 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 21 Santos St | 7 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 32 | Width 6ft | 6006699.73291 | 2087365.61068 | 37.711887598496396 | -122.41866289109699 | (37.7118875984964, -122.418662891097) | |||
25318 | 25318 | 178237 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 1501 Sunnydale Ave | 5 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 53 | Width 10ft | 6007383.79648 | 2087366.7973099998 | 37.7119293468405 | -122.416298653474 | (37.7119293468405, -122.416298653474) | |||
171862 | 171862 | 178194 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 162 Brookdale Ave | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 41 | Width 6ft | 6005696.94597 | 2087371.4071400003 | 37.7118470049107 | -122.422129220003 | (37.7118470049107, -122.422129220003) | |||
174250 | 174250 | 178218 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 49 Brookdale Ave | 6 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 44 | Width 6ft | 6006609.77482 | 2087372.85272 | 37.7119024184269 | -122.41897432542801 | (37.7119024184269, -122.418974325428) | |||
161965 | 161965 | 178236 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 1501 Sunnydale Ave | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 51 | Width 10ft | 6007352.75953 | 2087377.91644 | 37.7119581323275 | -122.416406713298 | (37.7119581323275, -122.416406713298) | |||
68421 | 68421 | 178235 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 1501 Sunnydale Ave | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 51 | Width 10ft | 6007325.54279 | 2087388.64 | 37.711986046404796 | -122.416501541435 | (37.7119860464048, -122.416501541435) | |||
187331 | 187331 | 178212 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 21 Santos St | 8 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 31 | Width 6ft | 6006711.0522 | 2087388.9913599999 | 37.711952434221296 | -122.418625425333 | (37.7119524342213, -122.418625425333) | |||
51304 | 51304 | 178234 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 1501 Sunnydale Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 53 | Width 10ft | 6007305.28319 | 2087396.3617599998 | 37.712006109362996 | -122.41657211120899 | (37.712006109363, -122.416572111209) | |||
176444 | 176444 | 178182 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 1500 Sunnydale Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 32 | Width 6ft | 6007434.89131 | 2087402.51035 | 37.712030280443294 | -122.416124582492 | (37.7120302804433, -122.416124582492) | |||
168987 | 168987 | 178233 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 1501 Sunnydale Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 47 | Width 10ft | 6007279.31595 | 2087405.7889599998 | 37.7120305340486 | -122.41666252905 | (37.7120305340486, -122.41666252905) | |||
54502 | 54502 | 178193 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 162 Brookdale Ave | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 28 | Width 6ft | 6005717.5857 | 2087406.58185 | 37.7119447513323 | -122.422060380499 | (37.7119447513323, -122.422060380499) | |||
26718 | 26718 | 178187 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 2 Brookdale Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 37 | Width 6ft | 6006632.31277 | 2087409.6759400002 | 37.712004796352 | -122.418899037766 | (37.712004796352, -122.418899037766) | |||
189042 | 189042 | 178219 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 49 Santos St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 44 | Width 6ft | 6006726.5178 | 2087416.33462 | 37.712028383779895 | -122.41857390945499 | (37.7120283837799, -122.418573909455) | |||
148721 | 148721 | 178188 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 2 Brookdale Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 41 | Width 6ft | 6006522.72539 | 2087420.06026 | 37.712027138203396 | -122.41927853998301 | (37.7120271382034, -122.419278539983) | |||
187681 | 187681 | 178232 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 1617 Sunnydale Ave | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 52 | Width 10ft | 6007195.0497 | 2087434.8361799999 | 37.712105551909 | -122.41695583486 | (37.712105551909, -122.41695583486) | |||
173256 | 173256 | 178189 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 2 Brookdale Ave | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 36 | Width 6ft | 6006392.34206 | 2087435.2297599998 | 37.7120614464552 | -122.41973025866501 | (37.7120614464552, -122.419730258665) | |||
135589 | 135589 | 178220 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 49 Santos St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 33 | Width 6ft | 6006744.56776 | 2087437.55352 | 37.7120876626009 | -122.418513027154 | (37.7120876626009, -122.418513027154) | |||
68297 | 68297 | 178231 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 1617 Sunnydale Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 42 | Width 10ft | 6007162.151740001 | 2087448.53527 | 37.712141316132396 | -122.417070510095 | (37.7121413161324, -122.417070510095) | |||
134835 | 134835 | 178221 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 49 Santos St | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 28 | Width 6ft | 6006759.0933300005 | 2087452.0979400002 | 37.7121284162619 | -122.41846385312999 | (37.7121284162619, -122.41846385313) | |||
58453 | 58453 | 178230 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 1617 Sunnydale Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 40 | Width 10ft | 6007131.69415 | 2087456.78381 | 37.7121622514644 | -122.4171763648 | (37.7121622514644, -122.4171763648) | |||
3034 | 3034 | 253070 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 132 Sagamore St | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | Width 0ft | Permit Number 780451 | 5995539.3842400005 | 2087458.9579900003 | 37.7115092483173 | -122.45724268539699 | (37.7115092483173, -122.457242685397) | |||
134381 | 134381 | 178222 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 49 Santos St | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 46 | Width 6ft | 6006780.48758 | 2087471.22385 | 37.7121821363765 | -122.418391263473 | (37.7121821363765, -122.418391263473) | |||
29491 | 29491 | 178184 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 1500 Sunnydale Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 34 | Width 6ft | 6007231.9474 | 2087473.93548 | 37.7122149858952 | -122.416831073707 | (37.7122149858952, -122.416831073707) | |||
161440 | 161440 | 178190 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 2 Brookdale Ave | 8 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 37 | Width 6ft | 6006112.32871 | 2087479.8450200001 | 37.71216817260479 | -122.42070123239901 | (37.7121681726048, -122.420701232399) | |||
163039 | 163039 | 178183 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 1500 Sunnydale Ave | 5 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 34 | Width 6ft | 6007182.72348 | 2087480.17188 | 37.7122293408858 | -122.417001648133 | (37.7122293408858, -122.417001648133) | |||
163010 | 163010 | 178229 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 1617 Sunnydale Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 42 | Width 10ft | 6007006.92231 | 2087486.34386 | 37.7122363969755 | -122.417609707629 | (37.7122363969755, -122.417609707629) | |||
58835 | 58835 | 178191 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 2 Brookdale Ave | 9 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 40 | Width 6ft | 6006087.46106 | 2087487.47527 | 37.712187722052896 | -122.420787723789 | (37.7121877220529, -122.420787723789) | |||
50252 | 50252 | 178185 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 1500 Sunnydale Ave | 6 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 40 | Width 6ft | 6007177.62531 | 2087487.59558 | 37.7122494380257 | -122.417019794631 | (37.7122494380257, -122.417019794631) | |||
158571 | 158571 | 178186 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 2 Santos St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 32 | Width 6ft | 6006754.952769999 | 2087500.5504700001 | 37.71226122363729 | -122.418481597663 | (37.7122612236373, -122.418481597663) | |||
182572 | 182572 | 178192 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 144 Brookdale Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 34 | Width 6ft | 6005819.1035400005 | 2087500.6137299999 | 37.7122086681568 | -122.421716180273 | (37.7122086681568, -122.421716180273) | |||
169505 | 169505 | 178249 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 525 Morse St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 13 | Width 4ft | 5999648.3814 | 2087534.2831 | 37.7119512120476 | -122.443046364399 | (37.7119512120476, -122.443046364399) | |||
18836 | 18836 | 30076 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 410X Brotherhood Way | 11 | Median : Cutout 11 | Tree 1 | DPW 2 | 03/10/2007 12:00:00 AM | 6 | M | 5993748.152574 | 2087576.478532 | 37.7117288925291 | -122.463442127126 | (37.7117288925291, -122.463442127126) | ||
78093 | 78093 | 30079 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 410X Brotherhood Way | 14 | Median : Cutout 11 | Tree 1 | DPW 2 | 03/10/2007 12:00:00 AM | 6 | M | 5993748.152574 | 2087576.478532 | 37.7117288925291 | -122.463442127126 | (37.7117288925291, -122.463442127126) | ||
78725 | 78725 | 30075 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 410X Brotherhood Way | 20 | Median : Cutout 11 | Tree 1 | DPW 2 | 03/10/2007 12:00:00 AM | 6 | M | 5993748.152574 | 2087576.478532 | 37.7117288925291 | -122.463442127126 | (37.7117288925291, -122.463442127126) | ||
78951 | 78951 | 30081 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 410X Brotherhood Way | 16 | Median : Cutout 11 | Tree 1 | DPW 2 | 03/10/2007 12:00:00 AM | 6 | M | 5993748.152574 | 2087576.478532 | 37.7117288925291 | -122.463442127126 | (37.7117288925291, -122.463442127126) | ||
80123 | 80123 | 30074 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 410X Brotherhood Way | 10 | Median : Cutout 11 | Tree 1 | DPW 2 | 03/10/2007 12:00:00 AM | 6 | M | 5993748.152574 | 2087576.478532 | 37.7117288925291 | -122.463442127126 | (37.7117288925291, -122.463442127126) | ||
81270 | 81270 | 30085 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 410X Brotherhood Way | 21 | Median : Cutout 11 | Tree 1 | DPW 2 | 03/10/2007 12:00:00 AM | 6 | M | 5993748.152574 | 2087576.478532 | 37.7117288925291 | -122.463442127126 | (37.7117288925291, -122.463442127126) | ||
81632 | 81632 | 30080 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 410X Brotherhood Way | 15 | Median : Cutout 11 | Tree 1 | DPW 2 | 03/10/2007 12:00:00 AM | 6 | M | 5993748.152574 | 2087576.478532 | 37.7117288925291 | -122.463442127126 | (37.7117288925291, -122.463442127126) | ||
87983 | 87983 | 30092 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 410X Brotherhood Way | 28 | Median : Cutout 11 | Tree 1 | DPW 2 | 03/10/2007 12:00:00 AM | 6 | M | 5993748.152574 | 2087576.478532 | 37.7117288925291 | -122.463442127126 | (37.7117288925291, -122.463442127126) | ||
88652 | 88652 | 30089 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 410X Brotherhood Way | 25 | Median : Cutout 11 | Tree 1 | DPW 2 | 03/10/2007 12:00:00 AM | 6 | M | 5993748.152574 | 2087576.478532 | 37.7117288925291 | -122.463442127126 | (37.7117288925291, -122.463442127126) | ||
88804 | 88804 | 30087 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 410X Brotherhood Way | 23 | Median : Cutout 11 | Tree 1 | DPW 2 | 03/10/2007 12:00:00 AM | 6 | M | 5993748.152574 | 2087576.478532 | 37.7117288925291 | -122.463442127126 | (37.7117288925291, -122.463442127126) | ||
89220 | 89220 | 30088 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 410X Brotherhood Way | 24 | Median : Cutout 11 | Tree 1 | DPW 2 | 03/10/2007 12:00:00 AM | 6 | M | 5993748.152574 | 2087576.478532 | 37.7117288925291 | -122.463442127126 | (37.7117288925291, -122.463442127126) | ||
96346 | 96346 | 30091 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 410X Brotherhood Way | 27 | Median : Cutout 11 | Tree 1 | DPW 2 | 03/10/2007 12:00:00 AM | 6 | M | 5993748.152574 | 2087576.478532 | 37.7117288925291 | -122.463442127126 | (37.7117288925291, -122.463442127126) | ||
103437 | 103437 | 30077 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 410X Brotherhood Way | 12 | Median : Cutout 11 | Tree 1 | DPW 2 | 03/10/2007 12:00:00 AM | 6 | M | 5993748.152574 | 2087576.478532 | 37.7117288925291 | -122.463442127126 | (37.7117288925291, -122.463442127126) | ||
104997 | 104997 | 30090 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 410X Brotherhood Way | 26 | Median : Cutout 11 | Tree 1 | DPW 2 | 03/10/2007 12:00:00 AM | 6 | M | 5993748.152574 | 2087576.478532 | 37.7117288925291 | -122.463442127126 | (37.7117288925291, -122.463442127126) | ||
108467 | 108467 | 30082 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 410X Brotherhood Way | 17 | Median : Cutout 11 | Tree 1 | DPW 2 | 03/10/2007 12:00:00 AM | 6 | M | 5993748.152574 | 2087576.478532 | 37.7117288925291 | -122.463442127126 | (37.7117288925291, -122.463442127126) | ||
111837 | 111837 | 30073 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 410X Brotherhood Way | 9 | Median : Cutout 11 | Tree 1 | DPW 2 | 03/10/2007 12:00:00 AM | 6 | M | 5993748.152574 | 2087576.478532 | 37.7117288925291 | -122.463442127126 | (37.7117288925291, -122.463442127126) | ||
117903 | 117903 | 30078 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 410X Brotherhood Way | 13 | Median : Cutout 11 | Tree 1 | DPW 2 | 03/10/2007 12:00:00 AM | 6 | M | 5993748.152574 | 2087576.478532 | 37.7117288925291 | -122.463442127126 | (37.7117288925291, -122.463442127126) | ||
119283 | 119283 | 30083 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 410X Brotherhood Way | 18 | Median : Cutout 11 | Tree 1 | DPW 2 | 03/10/2007 12:00:00 AM | 6 | M | 5993748.152574 | 2087576.478532 | 37.7117288925291 | -122.463442127126 | (37.7117288925291, -122.463442127126) | ||
120582 | 120582 | 30072 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 410X Brotherhood Way | 6 | Median : Cutout 11 | Tree 1 | DPW 2 | 03/10/2007 12:00:00 AM | 3 | M | 5993748.152574 | 2087576.478532 | 37.7117288925291 | -122.463442127126 | (37.7117288925291, -122.463442127126) | ||
121193 | 121193 | 30070 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 410X Brotherhood Way | 4 | Median : Cutout 11 | Tree 1 | DPW 2 | 03/10/2007 12:00:00 AM | 6 | M | 5993748.152574 | 2087576.478532 | 37.7117288925291 | -122.463442127126 | (37.7117288925291, -122.463442127126) | ||
127654 | 127654 | 30086 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 410X Brotherhood Way | 22 | Median : Cutout 11 | Tree 1 | DPW 2 | 03/10/2007 12:00:00 AM | 6 | M | 5993748.152574 | 2087576.478532 | 37.7117288925291 | -122.463442127126 | (37.7117288925291, -122.463442127126) | ||
139498 | 139498 | 30084 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 410X Brotherhood Way | 19 | Median : Cutout 11 | Tree 1 | DPW 2 | 03/10/2007 12:00:00 AM | 6 | M | 5993748.152574 | 2087576.478532 | 37.7117288925291 | -122.463442127126 | (37.7117288925291, -122.463442127126) | ||
142281 | 142281 | 30071 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 410X Brotherhood Way | 5 | Median : Cutout 11 | Tree 1 | DPW 2 | 03/10/2007 12:00:00 AM | 3 | M | 5993748.152574 | 2087576.478532 | 37.7117288925291 | -122.463442127126 | (37.7117288925291, -122.463442127126) | ||
26736 | 26736 | 178228 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 1701 Sunnydale Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 46 | Width 10ft | 6006676.947980001 | 2087600.4049200001 | 37.7125310112787 | -122.418758283074 | (37.7125310112787, -122.418758283074) | |||
154209 | 154209 | 178227 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 1701 Sunnydale Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 38 | Width 10ft | 6006634.76355 | 2087621.1473 | 37.7125855902332 | -122.41890555606001 | (37.7125855902332, -122.41890555606) | |||
175105 | 175105 | 178223 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 1700 Sunnydale Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 26 | Width 10ft | 6006618.16278 | 2087672.71077 | 37.7127262378868 | -122.418966588549 | (37.7127262378868, -122.418966588549) | |||
163909 | 163909 | 178224 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 1750 Sunnydale Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 21 | Width 10ft | 6006608.98524 | 2087674.4278900002 | 37.712730435941204 | -122.41899843083598 | (37.7127304359412, -122.418998430836) | |||
120316 | 120316 | 121151 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 1X Payson St | 1 | Side Yard : Yard 17 | Tree 1 | DPW 2 | 25 | 3x3 | 5992041.0 | 2087761.0 | 37.7121370380572 | -122.469355880776 | (37.7121370380572, -122.469355880776) | |||
178075 | 178075 | 178250 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 287 Hester Ave | 1 | Side Yard : Yard 17 | Tree 1 | Private 1 | 23 | 6012202.6988699995 | 2087794.30309 | 37.713372992543896 | -122.39967306036199 | (37.7133729925439, -122.399673060362) | ||||
117494 | 117494 | 107817 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 501X BROTHERHOOD WAY | unknown : Yard 19 | Tree 1 | DPW 2 | 5991892.0 | 2087849.0 | 37.712370053151204 | -122.469877266524 | (37.7123700531512, -122.469877266524) | ||||||
79209 | 79209 | 30065 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 510X Brotherhood Way | 10 | Median : Cutout 11 | Tree 1 | DPW 2 | 03/10/2007 12:00:00 AM | 6 | M | 5992600.642523999 | 2087870.68608 | 37.7124705349467 | -122.46742958077101 | (37.7124705349467, -122.467429580771) |
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");