trees
349 rows where qSpecies_id = 155 sorted by Neighborhoods (old)
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) ▼ |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1476 | 20456 | DPW Maintained 1 | Sequoia sempervirens :: Coast Redwood 155 | 495X Sunset Blvd | 21 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 36 | 60 | |||||||||||||
3222 | 20014 | DPW Maintained 1 | Sequoia sempervirens :: Coast Redwood 155 | 100 STAIRWAY47 | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 100ST | |||||||||||||
3904 | 121227 | DPW Maintained 1 | Sequoia sempervirens :: Coast Redwood 155 | 4299x 17th St | 3 | Front Yard : Yard | Tree | DPW 1 | |||||||||||||||
7510 | 20015 | DPW Maintained 1 | Sequoia sempervirens :: Coast Redwood 155 | 100 STAIRWAY47 | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 100ST | |||||||||||||
8551 | 19592 | DPW Maintained 1 | Sequoia sempervirens :: Coast Redwood 155 | 100 STAIRWAY4 | 15 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3 | 60 | |||||||||||||
8687 | 19815 | DPW Maintained 1 | Sequoia sempervirens :: Coast Redwood 155 | 100 STAIRWAY24 | 6 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 100ST | |||||||||||||
11754 | 20074 | DPW Maintained 1 | Sequoia sempervirens :: Coast Redwood 155 | 100 STAIRWAY55 | 7 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 24 | 27X | |||||||||||||
16052 | 19578 | DPW Maintained 1 | Sequoia sempervirens :: Coast Redwood 155 | 100 STAIRWAY4 | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 36 | 8 | |||||||||||||
16197 | 19811 | DPW Maintained 1 | Sequoia sempervirens :: Coast Redwood 155 | 100 STAIRWAY24 | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 24 | 100ST | |||||||||||||
16768 | 19816 | DPW Maintained 1 | Sequoia sempervirens :: Coast Redwood 155 | 100 STAIRWAY24 | 7 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 100ST | |||||||||||||
17000 | 19593 | DPW Maintained 1 | Sequoia sempervirens :: Coast Redwood 155 | 100 STAIRWAY4 | 16 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3 | 60 | |||||||||||||
19465 | 96173 | Permitted Site 7 | Sequoia sempervirens :: Coast Redwood 155 | Unaccepted Street : Cutout | Tree | Private 2 | 04/04/2011 12:00:00 AM | 3x3 | Permit Number 767806 | ||||||||||||||
4006 | 261988 | DPW Maintained 1 | Sequoia sempervirens :: Coast Redwood 155 | 1599x Armstrong Ave | 2 | Sidewalk: Property side : Cutout | Tree | DPW 1 | 3x3 | 6014700 | 2092264 | 37.7257847940592 | -122.391353711711 | (37.7257847940592, -122.391353711711) | 10 | 3 | 8 | 58 | 1 | ||||
17522 | 261989 | DPW Maintained 1 | Sequoia sempervirens :: Coast Redwood 155 | 1501x Armstrong Ave | 3 | Sidewalk: Property side : Cutout | Tree | DPW 1 | 3x3 | 6014836 | 2092075 | 37.7252733848281 | -122.390870362971 | (37.7252733848281, -122.390870362971) | 10 | 3 | 8 | 58 | 1 | ||||
22499 | 200496 | DPW Maintained 1 | Sequoia sempervirens :: Coast Redwood 155 | 3239 Jennings St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 0ft | 6013542.8885 | 2090062.874 | 37.7196766561509 | -122.395199674544 | (37.7196766561509, -122.395199674544) | 10 | 3 | 8 | 58 | 1 | |||
82381 | 98597 | Permitted Site 7 | Sequoia sempervirens :: Coast Redwood 155 | 400X Steiner St | 3 | Sidewalk: Property side : Cutout | Tree | Private 2 | Permit Number 768529 | 6004639 | 2109849 | 37.7735056071657 | -122.427386005439 | (37.7735056071657, -122.427386005439) | 7 | 9 | 11 | 28852 | 10 | ||||
190820 | 53580 | DPW Maintained 1 | Sequoia sempervirens :: Coast Redwood 155 | 148 06th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/15/1973 12:00:00 AM | 34 | Permit Number 12426 | 5993993.68572 | 2114568.59854 | 37.7858565385613 | -122.464552179077 | (37.7858565385613, -122.464552179077) | 11 | 6 | 1 | 54 | 11 | ||
39128 | 251719 | Significant Tree 6 | Sequoia sempervirens :: Coast Redwood 155 | 1301 Clayton St | 1 | Side Yard : Yard | Tree | Private 2 | 5999055 | 2105304 | 37.7607087868046 | -122.446374778866 | (37.7607087868046, -122.446374778866) | 15 | 5 | 5 | 28862 | 12 | |||||
119143 | 113163 | Significant Tree 6 | Sequoia sempervirens :: Coast Redwood 155 | 1300X STANYAN ST | 2 | Front Yard : Yard | Tree | Private 2 | 40 | 3x3 | 5997565 | 2104877 | 37.7594511396077 | -122.451497194349 | (37.7594511396077, -122.451497194349) | 15 | 5 | 11 | 28862 | 12 | |||
145840 | 113162 | Significant Tree 6 | Sequoia sempervirens :: Coast Redwood 155 | 1300X STANYAN ST | 1 | Front Yard : Yard | Tree | Private 2 | 40 | 3x3 | 5997565 | 2104877 | 37.7594511396077 | -122.451497194349 | (37.7594511396077, -122.451497194349) | 15 | 5 | 11 | 28862 | 12 | |||
194374 | 265048 | Significant Tree 6 | Sequoia sempervirens :: Coast Redwood 155 | 959 Kirkham St | 1 | Front Yard : Yard | Tree | Private 2 | 20x20 | 5991956 | 2105209 | 37.7600399316741 | -122.470919881603 | (37.7600399316741, -122.470919881603) | 1 | 8 | 4 | 56 | 12 | ||||
22018 | 106361 | Significant Tree 6 | Sequoia sempervirens :: Coast Redwood 155 | 1645 WEBSTER ST | 2 | Front Yard : Yard | Tree | Private 2 | 30 | 6003301.2 | 2114333.7 | 37.7857437219688 | -122.432334009178 | (37.7857437219688, -122.432334009178) | 13 | 9 | 11 | 29490 | 13 | ||||
82071 | 106360 | Significant Tree 6 | Sequoia sempervirens :: Coast Redwood 155 | 1820 POST ST | 1 | Front Yard : Yard | Tree | Private 2 | 30 | 6003351.1 | 2114201.6 | 37.785383838011 | -122.432151932321 | (37.785383838011, -122.432151932321) | 13 | 9 | 11 | 29490 | 13 | ||||
109809 | 106362 | Significant Tree 6 | Sequoia sempervirens :: Coast Redwood 155 | 1645 WEBSTER ST | 1 | Front Yard : Yard | Tree | Private 2 | 12 | 6003301.2 | 2114333.7 | 37.7857437219688 | -122.432334009178 | (37.7857437219688, -122.432334009178) | 13 | 9 | 11 | 29490 | 13 | ||||
9828 | 372 | Permitted Site 7 | Sequoia sempervirens :: Coast Redwood 155 | 3711X 19th Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/11/2008 12:00:00 AM | 6 | 3x3 | Permit Number 51718 | 5990365.2788562 | 2091006.8640877 | 37.720952400174 | -122.475384436189 | (37.720952400174, -122.475384436189) | 1 | 8 | 4 | 64 | 14 | |
14561 | 378 | Permitted Site 7 | Sequoia sempervirens :: Coast Redwood 155 | 3711X 19th Ave | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/11/2008 12:00:00 AM | 3 | 3x3 | Permit Number 51718 | 5990365.2788562 | 2091006.8640877 | 37.720952400174 | -122.475384436189 | (37.720952400174, -122.475384436189) | 1 | 8 | 4 | 64 | 14 | |
29220 | 379 | Permitted Site 7 | Sequoia sempervirens :: Coast Redwood 155 | 3711X 19th Ave | 11 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/11/2008 12:00:00 AM | 3 | 3x3 | Permit Number 51718 | 5990365.2788562 | 2091006.8640877 | 37.720952400174 | -122.475384436189 | (37.720952400174, -122.475384436189) | 1 | 8 | 4 | 64 | 14 | |
31285 | 377 | Permitted Site 7 | Sequoia sempervirens :: Coast Redwood 155 | 3711X 19th Ave | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/11/2008 12:00:00 AM | 12 | 3x3 | Permit Number 51718 | 5990365.2788562 | 2091006.8640877 | 37.720952400174 | -122.475384436189 | (37.720952400174, -122.475384436189) | 1 | 8 | 4 | 64 | 14 | |
62934 | 370 | Permitted Site 7 | Sequoia sempervirens :: Coast Redwood 155 | 3711X 19th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/11/2008 12:00:00 AM | 3 | 3x3 | Permit Number 51718 | 5990365.2788562 | 2091006.8640877 | 37.720952400174 | -122.475384436189 | (37.720952400174, -122.475384436189) | 1 | 8 | 4 | 64 | 14 | |
71693 | 88838 | Permitted Site 7 | Sequoia sempervirens :: Coast Redwood 155 | 3711 19th Ave | 14 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/11/2008 12:00:00 AM | 3x3 | Permit Number 51718 | 5990297.3 | 2090806 | 37.7203969366505 | -122.475604756889 | (37.7203969366505, -122.475604756889) | 1 | 8 | 4 | 64 | 14 | ||
78542 | 375 | Permitted Site 7 | Sequoia sempervirens :: Coast Redwood 155 | 3711X 19th Ave | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/11/2008 12:00:00 AM | 3 | 3x3 | Permit Number 51718 | 5990365.2788562 | 2091006.8640877 | 37.720952400174 | -122.475384436189 | (37.720952400174, -122.475384436189) | 1 | 8 | 4 | 64 | 14 | |
90791 | 376 | Permitted Site 7 | Sequoia sempervirens :: Coast Redwood 155 | 3711X 19th Ave | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/11/2008 12:00:00 AM | 3 | 3x3 | Permit Number 51718 | 5990365.2788562 | 2091006.8640877 | 37.720952400174 | -122.475384436189 | (37.720952400174, -122.475384436189) | 1 | 8 | 4 | 64 | 14 | |
104772 | 373 | Permitted Site 7 | Sequoia sempervirens :: Coast Redwood 155 | 3711X 19th Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/11/2008 12:00:00 AM | 3 | 3x3 | Permit Number 51718 | 5990365.2788562 | 2091006.8640877 | 37.720952400174 | -122.475384436189 | (37.720952400174, -122.475384436189) | 1 | 8 | 4 | 64 | 14 | |
107662 | 381 | Permitted Site 7 | Sequoia sempervirens :: Coast Redwood 155 | 3711X 19th Ave | 13 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/11/2008 12:00:00 AM | 16 | 3x3 | Permit Number 51718 | 5990365.2788562 | 2091006.8640877 | 37.720952400174 | -122.475384436189 | (37.720952400174, -122.475384436189) | 1 | 8 | 4 | 64 | 14 | |
120109 | 105769 | Undocumented 4 | Sequoia sempervirens :: Coast Redwood 155 | 1 Gonzalez Dr | 1 | Front Yard : Yard | Tree | Private 2 | 02/24/2014 12:00:00 AM | Permit Number 772589 | 5990111.8 | 2090190.8 | 37.7186969947407 | -122.476201051717 | (37.7186969947407, -122.476201051717) | 1 | 8 | 4 | 64 | 14 | |||
129216 | 380 | Permitted Site 7 | Sequoia sempervirens :: Coast Redwood 155 | 3711X 19th Ave | 12 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/11/2008 12:00:00 AM | 16 | 3x3 | Permit Number 51718 | 5990365.2788562 | 2091006.8640877 | 37.720952400174 | -122.475384436189 | (37.720952400174, -122.475384436189) | 1 | 8 | 4 | 64 | 14 | |
144579 | 88839 | Permitted Site 7 | Sequoia sempervirens :: Coast Redwood 155 | 3711 19th Ave | 15 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/11/2008 12:00:00 AM | 3x3 | Permit Number 51718 | 5990297.3 | 2090806 | 37.7203969366505 | -122.475604756889 | (37.7203969366505, -122.475604756889) | 1 | 8 | 4 | 64 | 14 | ||
153904 | 371 | Permitted Site 7 | Sequoia sempervirens :: Coast Redwood 155 | 3711X 19th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/11/2008 12:00:00 AM | 6 | 3x3 | Permit Number 51718 | 5990365.2788562 | 2091006.8640877 | 37.720952400174 | -122.475384436189 | (37.720952400174, -122.475384436189) | 1 | 8 | 4 | 64 | 14 | |
159673 | 27532 | Permitted Site 7 | Sequoia sempervirens :: Coast Redwood 155 | 3711X 19th Ave | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/11/2008 12:00:00 AM | 3 | 3x3 | Permit Number 51718 | 5990365.2788562 | 2091006.8640877 | 37.720952400174 | -122.475384436189 | (37.720952400174, -122.475384436189) | 1 | 8 | 4 | 64 | 14 | |
166244 | 374 | Permitted Site 7 | Sequoia sempervirens :: Coast Redwood 155 | 3711X 19th Ave | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/11/2008 12:00:00 AM | 3 | 3x3 | Permit Number 51718 | 5990365.2788562 | 2091006.8640877 | 37.720952400174 | -122.475384436189 | (37.720952400174, -122.475384436189) | 1 | 8 | 4 | 64 | 14 | |
170932 | 102752 | Property Tree 8 | Sequoia sempervirens :: Coast Redwood 155 | 2452 Green St | Back Yard : Yard | Tree | Private 2 | 6001313 | 2117994 | 37.7956810212331 | -122.43947508164 | (37.7956810212331, -122.43947508164) | 13 | 9 | 1 | 57 | 17 | ||||||
105934 | 99256 | Property Tree 8 | Sequoia sempervirens :: Coast Redwood 155 | 1466 York St | Back Yard : Yard | Tree | Private 2 | 6010099 | 2100741 | 37.7488043872035 | -122.407856595429 | (37.7488043872035, -122.407856595429) | 2 | 4 | 7 | 28859 | 19 | ||||||
120274 | 2370 | DPW Maintained 1 | Sequoia sempervirens :: Coast Redwood 155 | 2516 Bryant St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 4X4PL | 6009703.1421 | 2102664.68486 | 37.7540642287015 | -122.409361214875 | (37.7540642287015, -122.409361214875) | 2 | 4 | 7 | 28859 | 19 | |||
146386 | 107343 | Significant Tree 6 | Sequoia sempervirens :: Coast Redwood 155 | 110 JULIAN AVE | 2 | Back Yard : Yard | Tree | Private 2 | 15 | 6006340.8 | 2107214.1 | 37.7663669011591 | -122.421312071366 | (37.7663669011591, -122.421312071366) | 8 | 4 | 7 | 28853 | 19 | ||||
148856 | 240599 | DPW Maintained 1 | Sequoia sempervirens :: Coast Redwood 155 | 3229 21st St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 21 | Width 3ft | 6006780.56286 | 2103771.69804 | 37.7569396517722 | -122.41954675558 | (37.7569396517722, -122.41954675558) | 2 | 4 | 7 | 28859 | 19 | |||
163159 | 197580 | DPW Maintained 1 | Sequoia sempervirens :: Coast Redwood 155 | 2151 17th St | 1 | Front Yard : Yard | Tree | Private 2 | 23 | 6010976.50521 | 2106453.15639 | 37.764537787215 | -122.405224355037 | (37.764537787215, -122.405224355037) | 8 | 4 | 8 | 28859 | 19 | ||||
188227 | 240598 | DPW Maintained 1 | Sequoia sempervirens :: Coast Redwood 155 | 2106 Folsom St | 3 | Sidewalk: Curb side : Pot | Tree | Private 2 | 5 | Width 2ft | 6008077.42241 | 2106097.35182 | 37.763398325498 | -122.415226338718 | (37.763398325498, -122.415226338718) | 8 | 4 | 7 | 28859 | 19 | |||
939 | 240597 | DPW Maintained 1 | Sequoia sempervirens :: Coast Redwood 155 | 601x Powhattan Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 29 | 6008567.55649 | 2098119.23198 | 37.7415197374453 | -122.412966995358 | (37.7415197374453, -122.412966995358) | 10 | 7 | 7 | 28859 | 2 | ||||
7947 | 247597 | DPW Maintained 1 | Sequoia sempervirens :: Coast Redwood 155 | 900 Tompkins Ave | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 12 | Width 8ft | 6009155.97098 | 2096407.45458 | 37.7368525815689 | -122.41081158571 | (37.7368525815689, -122.41081158571) | 10 | 7 | 7 | 28859 | 2 | |||
50332 | 247596 | DPW Maintained 1 | Sequoia sempervirens :: Coast Redwood 155 | 900 Tompkins Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 13 | Width 8ft | 6009145.02453 | 2096408.71868 | 37.73685543873 | -122.410849521814 | (37.73685543873, -122.410849521814) | 10 | 7 | 7 | 28859 | 2 | |||
54187 | 246775 | DPW Maintained 1 | Sequoia sempervirens :: Coast Redwood 155 | 925 Esmeralda Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 7 | 6009505.54739 | 2098718.43829 | 37.7432176358792 | -122.409766015896 | (37.7432176358792, -122.409766015896) | 2 | 7 | 7 | 28859 | 2 | ||||
63157 | 116234 | Significant Tree 6 | Sequoia sempervirens :: Coast Redwood 155 | 450 PERALTA AVE | 1 | Front Yard : Yard | Tree | Private 2 | 3x3 | 6009750 | 2099218 | 37.744603019334 | -122.408955999129 | (37.744603019334, -122.408955999129) | 2 | 7 | 7 | 28859 | 2 | ||||
66311 | 247908 | DPW Maintained 1 | Sequoia sempervirens :: Coast Redwood 155 | 582 Esmeralda Ave | 6 | Side Yard : Yard | Tree | Private 2 | 12 | 6009856.31482 | 2098721.18962 | 37.7432448412741 | -122.408553343056 | (37.7432448412741, -122.408553343056) | 10 | 7 | 7 | 28859 | 2 | ||||
66374 | 248054 | DPW Maintained 1 | Sequoia sempervirens :: Coast Redwood 155 | 19 Rutledge St | 3 | Front Yard : Yard | Tree | Private 2 | 10 | 6010623.78947 | 2099366.66931 | 37.7450601408245 | -122.405945064536 | (37.7450601408245, -122.405945064536) | 2 | 7 | 7 | 28859 | 2 | ||||
74061 | 248065 | DPW Maintained 1 | Sequoia sempervirens :: Coast Redwood 155 | 18 Rutledge St | 7 | Side Yard : Yard | Tree | Private 2 | 8 | 6010648.08166 | 2099392.59133 | 37.7451326756473 | -122.405862891685 | (37.7451326756473, -122.405862891685) | 2 | 7 | 7 | 28859 | 2 | ||||
80763 | 248068 | DPW Maintained 1 | Sequoia sempervirens :: Coast Redwood 155 | 20 Rutledge St | 2 | Side Yard : Yard | Tree | Private 2 | 6 | 6010623.83336 | 2099392.33092 | 37.7451306044855 | -122.405946720167 | (37.7451306044855, -122.405946720167) | 2 | 7 | 7 | 28859 | 2 | ||||
82049 | 116660 | DPW Maintained 1 | Sequoia sempervirens :: Coast Redwood 155 | 199x Esmeralda Ave | 13 | Unaccepted Street : Yard | Tree | DPW 1 | 8 | 6007213.11808 | 2098808.04206 | 37.7433349329997 | -122.417699002452 | (37.7433349329997, -122.417699002452) | 2 | 7 | 7 | 28859 | 2 | ||||
91810 | 247598 | DPW Maintained 1 | Sequoia sempervirens :: Coast Redwood 155 | 900 Tompkins Ave | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 13 | Width 10ft | 6009167.82306 | 2096407.90626 | 37.7368544863348 | -122.410770639572 | (37.7368544863348, -122.410770639572) | 10 | 7 | 7 | 28859 | 2 | |||
97217 | 122496 | Undocumented 4 | Sequoia sempervirens :: Coast Redwood 155 | 69x Bonview St | 12 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 6007716 | 2099172 | 37.7443625662885 | -122.415985930063 | (37.7443625662885, -122.415985930063) | 2 | 7 | 7 | 28859 | 2 | ||||
98282 | 246713 | DPW Maintained 1 | Sequoia sempervirens :: Coast Redwood 155 | 1 Bonview St | 19 | Sidewalk: Curb side : Yard | Tree | Private 2 | 20 | 6007763.89494 | 2099225.75212 | 37.7445128502976 | -122.415824124379 | (37.7445128502976, -122.415824124379) | 2 | 7 | 7 | 28859 | 2 | ||||
99868 | 248066 | DPW Maintained 1 | Sequoia sempervirens :: Coast Redwood 155 | 18 Rutledge St | 8 | Side Yard : Yard | Tree | Private 2 | 7 | 6010646.65948 | 2099397.14706 | 37.7451451051559 | -122.405868130216 | (37.7451451051559, -122.405868130216) | 2 | 7 | 7 | 28859 | 2 | ||||
111744 | 248053 | DPW Maintained 1 | Sequoia sempervirens :: Coast Redwood 155 | 19 Rutledge St | 2 | Front Yard : Yard | Tree | Private 2 | 18 | 6010622.54759 | 2099378.68509 | 37.7450930640901 | -122.405950205054 | (37.7450930640901, -122.405950205054) | 2 | 7 | 7 | 28859 | 2 | ||||
116198 | 240600 | DPW Maintained 1 | Sequoia sempervirens :: Coast Redwood 155 | 237 Murray St | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 10 | Width 10ft | 6005707.57123 | 2095372.66085 | 37.7338173103055 | -122.422660726511 | (37.7338173103055, -122.422660726511) | 2 | 7 | 7 | 28861 | 2 | |||
153377 | 248058 | DPW Maintained 1 | Sequoia sempervirens :: Coast Redwood 155 | 17 Rutledge St | 4 | Side Yard : Yard | Tree | Private 2 | 5 | 6010687.47782 | 2099346.14687 | 37.7450073524216 | -122.405723395139 | (37.7450073524216, -122.405723395139) | 2 | 7 | 7 | 28859 | 2 | ||||
155030 | 113150 | Significant Tree 6 | Sequoia sempervirens :: Coast Redwood 155 | 45 BRONTE ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | 3x3 | 6009384 | 2097185 | 37.7390003361927 | -122.410078062228 | (37.7390003361927, -122.410078062228) | 10 | 7 | 7 | 28859 | 2 | |||
156862 | 247974 | DPW Maintained 1 | Sequoia sempervirens :: Coast Redwood 155 | 346 Peralta Ave | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 20 | 6009790.92788 | 2099185.07173 | 37.7445148980554 | -122.408812155357 | (37.7445148980554, -122.408812155357) | 2 | 7 | 7 | 28859 | 2 | ||||
159242 | 248069 | DPW Maintained 1 | Sequoia sempervirens :: Coast Redwood 155 | 20 Rutledge St | 3 | Side Yard : Yard | Tree | Private 2 | 8 | 6010620.26598 | 2099403.15406 | 37.7451601229588 | -122.405959817907 | (37.7451601229588, -122.405959817907) | 2 | 7 | 7 | 28859 | 2 | ||||
187083 | 247905 | DPW Maintained 1 | Sequoia sempervirens :: Coast Redwood 155 | 582 Esmeralda Ave | 3 | Side Yard : Yard | Tree | Private 2 | 4 | 6009839.52244 | 2098719.28889 | 37.7432386818184 | -122.408611272911 | (37.7432386818184, -122.408611272911) | 10 | 7 | 7 | 28859 | 2 | ||||
129998 | 197590 | DPW Maintained 1 | Sequoia sempervirens :: Coast Redwood 155 | 200 Kansas St | 9 | Sidewalk: Property side : Yard | Tree | Private 2 | 33 | Width 4ft | 6011401.81383 | 2107103.92491 | 37.7663484192558 | -122.403799114839 | (37.7663484192558, -122.403799114839) | 8 | 2 | 8 | 28853 | 20 | |||
57200 | 136428 | DPW Maintained 1 | Sequoia sempervirens :: Coast Redwood 155 | 7 Kimball Pl | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 15 | Width 0ft | 6007991.83691 | 2116437.43612 | 37.791784918695 | -122.416254742289 | (37.791784918695, -122.416254742289) | 5 | 1 | 10 | 28858 | 21 | |||
8804 | 240602 | DPW Maintained 1 | Sequoia sempervirens :: Coast Redwood 155 | 609 28th St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 2ft | 6001920.90533 | 2099400.25112 | 37.7446617708226 | -122.436040449628 | (37.7446617708226, -122.436040449628) | 2 | 7 | 5 | 63 | 22 | |||
25282 | 240601 | DPW Maintained 1 | Sequoia sempervirens :: Coast Redwood 155 | 609 28th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 2ft | 6001917.09097 | 2099400.07719 | 37.744661076553 | -122.436053626473 | (37.744661076553, -122.436053626473) | 2 | 7 | 5 | 63 | 22 | |||
35501 | 240607 | DPW Maintained 1 | Sequoia sempervirens :: Coast Redwood 155 | 888 Elizabeth St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 21 | Width 4ft | 6000718.67811 | 2102015.72187 | 37.7517748542418 | -122.44038504473 | (37.7517748542418, -122.44038504473) | 2 | 4 | 5 | 28862 | 22 | |||
37696 | 240603 | DPW Maintained 1 | Sequoia sempervirens :: Coast Redwood 155 | 609 28th St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 2ft | 6001924.96846 | 2099400.16705 | 37.7446617708161 | -122.436026394128 | (37.7446617708161, -122.436026394128) | 2 | 7 | 5 | 63 | 22 | |||
57451 | 240608 | DPW Maintained 1 | Sequoia sempervirens :: Coast Redwood 155 | 3932 22nd St | 1 | Sidewalk: Curb side : Pot | Tree | Private 2 | 11 | Width 4ft | 6002275.44669 | 2102986.99037 | 37.7545302429786 | -122.435070995746 | (37.7545302429786, -122.435070995746) | 2 | 4 | 5 | 28862 | 22 | |||
61269 | 240609 | DPW Maintained 1 | Sequoia sempervirens :: Coast Redwood 155 | 3944 22nd St | 5 | Front Yard : Yard | Tree | Private 2 | 8 | 6002189.65903 | 2102971.08087 | 37.7544816876836 | -122.435366533665 | (37.7544816876836, -122.435366533665) | 2 | 4 | 5 | 28862 | 22 | ||||
84644 | 118371 | Property Tree 8 | Sequoia sempervirens :: Coast Redwood 155 | 4808 25th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5999981 | 2101110 | 37.7492459313263 | -122.442870994168 | (37.7492459313263, -122.442870994168) | 2 | 4 | 5 | 28862 | 22 | ||||
85358 | 246442 | DPW Maintained 1 | Sequoia sempervirens :: Coast Redwood 155 | 485 Duncan St | 4 | Front Yard : Yard | Tree | Private 2 | 40 | 6003379.46073 | 2099778.50621 | 37.7457831256083 | -122.431024044746 | (37.7457831256083, -122.431024044746) | 2 | 7 | 5 | 63 | 22 | ||||
92231 | 240614 | DPW Maintained 1 | Sequoia sempervirens :: Coast Redwood 155 | 3637 22nd St | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 3 | Width 3ft | 6003933.58317 | 2103025.57629 | 37.7547302045579 | -122.429339475147 | (37.7547302045579, -122.429339475147) | 2 | 4 | 5 | 28862 | 22 | |||
118706 | 54927 | Permitted Site 7 | Sequoia sempervirens :: Coast Redwood 155 | 485 Duncan St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/16/1972 12:00:00 AM | 10 | Permit Number 10801 | 6003402.69319537 | 2099776.66443458 | 37.7457793849362 | -122.430943578835 | (37.7457793849362, -122.430943578835) | 2 | 7 | 5 | 63 | 22 | ||
130861 | 240606 | DPW Maintained 1 | Sequoia sempervirens :: Coast Redwood 155 | 2112 Castro St | 1 | Sidewalk: Curb side : Pot | Tree | Private 2 | 35 | Width 10ft | 6002638.80724 | 2099263.13099 | 37.7443260296246 | -122.433548290621 | (37.7443260296246, -122.433548290621) | 2 | 7 | 5 | 63 | 22 | |||
154122 | 240613 | DPW Maintained 1 | Sequoia sempervirens :: Coast Redwood 155 | 3637 22nd St | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 5 | Width 3ft | 6003938.94874 | 2103022.28304 | 37.7547214658369 | -122.42932068472 | (37.7547214658369, -122.42932068472) | 2 | 4 | 5 | 28862 | 22 | |||
158533 | 240612 | DPW Maintained 1 | Sequoia sempervirens :: Coast Redwood 155 | 3637 22nd St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 4 | Width 3ft | 6003932.88521 | 2103022.72642 | 37.7547223399723 | -122.429341685671 | (37.7547223399723, -122.429341685671) | 2 | 4 | 5 | 28862 | 22 | |||
159546 | 240605 | DPW Maintained 1 | Sequoia sempervirens :: Coast Redwood 155 | 500 Grand View Ave | 3 | Front Yard : Yard | Tree | Private 2 | 2 | 5999980.41761 | 2101731.19658 | 37.7509515536903 | -122.442917611181 | (37.7509515536903, -122.442917611181) | 2 | 4 | 5 | 28862 | 22 | ||||
171356 | 240610 | DPW Maintained 1 | Sequoia sempervirens :: Coast Redwood 155 | 3944 22nd St | 6 | Front Yard : Yard | Tree | Private 2 | 8 | 6002190.86574 | 2102965.81607 | 37.7544673003333 | -122.435361983973 | (37.7544673003333, -122.435361983973) | 2 | 4 | 5 | 28862 | 22 | ||||
173994 | 240611 | DPW Maintained 1 | Sequoia sempervirens :: Coast Redwood 155 | 255 Jersey St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6003497.9531 | 2101542.75011 | 37.7506340408268 | -122.430740191717 | (37.7506340408268, -122.430740191717) | 2 | 4 | 5 | 28862 | 22 | |||
190990 | 240604 | DPW Maintained 1 | Sequoia sempervirens :: Coast Redwood 155 | 500 Grand View Ave | 1 | Front Yard : Yard | Tree | Private 2 | 3 | 5999982.42979 | 2101700.47656 | 37.750867318677 | -122.442908447093 | (37.750867318677, -122.442908447093) | 2 | 4 | 5 | 28862 | 22 | ||||
22478 | 249959 | DPW Maintained 1 | Sequoia sempervirens :: Coast Redwood 155 | 273 Filbert St | 1 | Front Yard : Yard | Tree | Private 2 | 23 | Width 0ft | 6011558.55656 | 2120064.53903 | 37.8019439797819 | -122.404169218243 | (37.8019439797819, -122.404169218243) | 3 | 1 | 10 | 308 | 23 | |||
34175 | 87149 | Significant Tree 6 | Sequoia sempervirens :: Coast Redwood 155 | 4 Bellair Pl | 2 | Back Yard : Yard | Tree | Private 2 | 6010093 | 2120950 | 37.8042932388788 | -122.409303278994 | (37.8042932388788, -122.409303278994) | 3 | 1 | 10 | 308 | 23 | |||||
65969 | 87150 | Significant Tree 6 | Sequoia sempervirens :: Coast Redwood 155 | 4 Bellair Pl | 2 | Back Yard : Yard | Tree | Private 2 | Permit Number 50135 | 6010093 | 2120950 | 37.8042932388788 | -122.409303278994 | (37.8042932388788, -122.409303278994) | 3 | 1 | 10 | 308 | 23 | ||||
135411 | 250201 | DPW Maintained 1 | Sequoia sempervirens :: Coast Redwood 155 | 203 Union St | 2 | Side Yard : Yard | Tree | Private 2 | 29 | Width 0ft | 6011763.02504 | 2119743.52194 | 37.8010739675505 | -122.403439059581 | (37.8010739675505, -122.403439059581) | 3 | 1 | 10 | 308 | 23 | |||
142994 | 112559 | Significant Tree 6 | Sequoia sempervirens :: Coast Redwood 155 | 1735x GRANT AVE | 1 | Back Yard : Yard | Tree | Private 2 | 6010373 | 2120454 | 37.8029470287696 | -122.408299306743 | (37.8029470287696, -122.408299306743) | 3 | 1 | 10 | 308 | 23 | |||||
157512 | 250200 | DPW Maintained 1 | Sequoia sempervirens :: Coast Redwood 155 | 203 Union St | 1 | Side Yard : Yard | Tree | Private 2 | 33 | Width 0ft | 6011776.4013 | 2119745.07747 | 37.8010789857668 | -122.403392881194 | (37.8010789857668, -122.403392881194) | 3 | 1 | 10 | 308 | 23 | |||
122518 | 215039 | DPW Maintained 1 | Sequoia sempervirens :: Coast Redwood 155 | 179 Ashton Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 32 | 5994134.23715 | 2091156.84385 | 37.7215819583195 | -122.462367242757 | (37.7215819583195, -122.462367242757) | 9 | 8 | 6 | 28861 | 24 | ||||
185995 | 215040 | DPW Maintained 1 | Sequoia sempervirens :: Coast Redwood 155 | 88 Ashton Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 13 | 5994178.77111 | 2090487.70986 | 37.7197472415137 | -122.46216479907 | (37.7197472415137, -122.46216479907) | 9 | 8 | 6 | 28861 | 24 | ||||
22789 | 118610 | DPW Maintained 1 | Sequoia sempervirens :: Coast Redwood 155 | 349 Point Lobos Ave | 2 | Side Yard : Yard | Tree | Private 2 | 5 | 5981717.62769 | 2112632.61479 | 37.7798255733952 | -122.506879529548 | (37.7798255733952, -122.506879529548) | 11 | 6 | 2 | 55 | 26 | ||||
26627 | 24794 | DPW Maintained 1 | Sequoia sempervirens :: Coast Redwood 155 | 7633 Geary Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | 3X3 | 5983299.41691 | 2112375.19824 | 37.7792118059508 | -122.50138846509 | (37.7792118059508, -122.50138846509) | 11 | 6 | 2 | 55 | 26 | |||
29828 | 118443 | DPW Maintained 1 | Sequoia sempervirens :: Coast Redwood 155 | 5201 Anza St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 8 | Width 3ft | 5982458.0361 | 2111659.95745 | 37.7771985159381 | -122.504246101222 | (37.7771985159381, -122.504246101222) | 11 | 6 | 2 | 55 | 26 | |||
62301 | 118611 | DPW Maintained 1 | Sequoia sempervirens :: Coast Redwood 155 | 349 Point Lobos Ave | 3 | Side Yard : Yard | Tree | Private 2 | 6 | 5981718.68572 | 2112644.15815 | 37.7798573303546 | -122.506876725888 | (37.7798573303546, -122.506876725888) | 11 | 6 | 2 | 55 | 26 | ||||
85509 | 119951 | DPW Maintained 1 | Sequoia sempervirens :: Coast Redwood 155 | 300 28th Ave | 4 | Sidewalk: Curb side : Yard | Tree | Private 2 | 30 | Width 3ft | 5987162.07649 | 2113890.44215 | 37.783598323431 | -122.488137483705 | (37.783598323431, -122.488137483705) | 11 | 6 | 2 | 55 | 26 |
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) );