trees
349 rows where qSpecies_id = 155 sorted by Location
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 | ||||||||||||||
| 69156 | 117179 | DPW Maintained 1 | Sequoia sempervirens :: Coast Redwood 155 | 350x Winding Way | 1 | Median : Cutout | Tree | DPW 1 | 30 | 3x3 | 6001167.67306 | 2086580.24641 | 37.7094181465037 | -122.437726988707 | (37.7094181465037, -122.437726988707) | 9 | 7 | 6 | 28861 | 5 | |||
| 166518 | 179495 | DPW Maintained 1 | Sequoia sempervirens :: Coast Redwood 155 | 350x Winding Way | 3 | Median : Cutout | Tree | DPW 1 | 13 | Width 0ft | 6001141.42857 | 2086583.09342 | 37.7094244714452 | -122.43781789759 | (37.7094244714452, -122.43781789759) | 9 | 7 | 6 | 28861 | 5 | |||
| 70534 | 104510 | Private 9 | Sequoia sempervirens :: Coast Redwood 155 | 254 ALLISON ST | 1 | Back Yard : Yard | Tree | Private 2 | 40 | 6000052 | 2087408 | 37.7116274717654 | -122.441642291463 | (37.7116274717654, -122.441642291463) | 9 | 7 | 6 | 28861 | 5 | ||||
| 62904 | 187562 | DPW Maintained 1 | Sequoia sempervirens :: Coast Redwood 155 | 136 Alpha St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 2ft | 6010924.81275 | 2088138.49847 | 37.7142467657541 | -122.404114113194 | (37.7142467657541, -122.404114113194) | 9 | 7 | 8 | 309 | 39 | |||
| 152363 | 179494 | DPW Maintained 1 | Sequoia sempervirens :: Coast Redwood 155 | 861 Lisbon St | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 2 | Width 6ft | 6001008.19959 | 2088780.17342 | 37.7154495883121 | -122.43843566439 | (37.7154495883121, -122.43843566439) | 9 | 7 | 6 | 28861 | 5 | |||
| 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 | |||
| 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 | |||
| 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 | ||||
| 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 | ||
| 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 | ||
| 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 | |
| 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 | |
| 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 | |
| 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 | |
| 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 | ||||
| 4559 | 109532 | - 12 | Sequoia sempervirens :: Coast Redwood 155 | 818 Goettingen St | 1 | Back Yard : Yard | Tree | Private 2 | 6010847.3 | 2090865.3 | 37.7217296747854 | -122.404573864697 | (37.7217296747854, -122.404573864697) | 10 | 3 | 7 | 309 | 28 | |||||
| 14046 | 262297 | Private 9 | Sequoia sempervirens :: Coast Redwood 155 | 666 Hamilton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6009767 | 2091318 | 37.722912259595 | -122.408340109411 | (37.722912259595, -122.408340109411) | 9 | 3 | 7 | 309 | 28 | ||||
| 166770 | 107222 | DPW Maintained 1 | Sequoia sempervirens :: Coast Redwood 155 | 327 Vienna St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/29/2014 12:00:00 AM | 3 | 6x5 | Permit Number 773943 | 6003989.60354 | 2091508.12122 | 37.7231090719178 | -122.428324915783 | (37.7231090719178, -122.428324915783) | 9 | 7 | 6 | 28861 | 5 | |
| 190122 | 187590 | DPW Maintained 1 | Sequoia sempervirens :: Coast Redwood 155 | 700 Goettingen St | 1 | Front Yard : Yard | Tree | Private 2 | 4 | 6010709.76883 | 2091388.98151 | 37.7231599087791 | -122.405086131946 | (37.7231599087791, -122.405086131946) | 10 | 3 | 7 | 309 | 28 | ||||
| 22779 | 179498 | DPW Maintained 1 | Sequoia sempervirens :: Coast Redwood 155 | 892 Peru Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 35 | 6005545.45161 | 2091807.84398 | 37.7240199601485 | -122.422967943043 | (37.7240199601485, -122.422967943043) | 9 | 7 | 6 | 309 | 5 | ||||
| 153056 | 6389 | DPW Maintained 1 | Sequoia sempervirens :: Coast Redwood 155 | 40 Entrada Ct | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3 | 60M | 5992282.41809 | 2092443.27672 | 37.7250073785701 | -122.468861992007 | (37.7250073785701, -122.468861992007) | 9 | 8 | 4 | 59 | 40 | |||
| 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 | ||||
| 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 | ||||
| 152740 | 11673 | DPW Maintained 1 | Sequoia sempervirens :: Coast Redwood 155 | 700X Junipero Serra Blvd | 10 | Median : Cutout | Tree | DPW 1 | 03/30/2006 12:00:00 AM | 3 | 3X3 | 5991295.14519 | 2092921.61878 | 37.7262636985024 | -122.472309706624 | (37.7262636985024, -122.472309706624) | 9 | 8 | 4 | 64 | 40 | ||
| 111807 | 179496 | DPW Maintained 1 | Sequoia sempervirens :: Coast Redwood 155 | 653 Peru Ave | 8 | Side Yard : Yard | Tree | Private 2 | 6 | 6005058.40423 | 2092646.41058 | 37.7262949850043 | -122.424711217658 | (37.7262949850043, -122.424711217658) | 9 | 7 | 6 | 28861 | 5 | ||||
| 41875 | 179497 | DPW Maintained 1 | Sequoia sempervirens :: Coast Redwood 155 | 653 Peru Ave | 9 | Side Yard : Yard | Tree | Private 2 | 8 | 6005046.66321 | 2092646.92983 | 37.7262957476241 | -122.424751842734 | (37.7262957476241, -122.424751842734) | 9 | 7 | 6 | 28861 | 5 | ||||
| 114785 | 179499 | DPW Maintained 1 | Sequoia sempervirens :: Coast Redwood 155 | 1151 Felton St | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | Width 2ft | 6007548.78788 | 2092831.16716 | 37.7269426263769 | -122.416115141404 | (37.7269426263769, -122.416115141404) | 9 | 3 | 7 | 309 | 28 | |||
| 144425 | 215038 | DPW Maintained 1 | Sequoia sempervirens :: Coast Redwood 155 | 314 Staples Ave | 6 | Sidewalk: Property side : Yard | Tree | Private 2 | 13 | 5997989.53732 | 2093829.39983 | 37.7291414193406 | -122.449233015693 | (37.7291414193406, -122.449233015693) | 9 | 7 | 4 | 28861 | 40 | ||||
| 165114 | 215037 | DPW Maintained 1 | Sequoia sempervirens :: Coast Redwood 155 | 314 Staples Ave | 7 | Sidewalk: Property side : Yard | Tree | Private 2 | 13 | 5997982.72892 | 2093830.46071 | 37.7291439428352 | -122.449256629186 | (37.7291439428352, -122.449256629186) | 9 | 7 | 4 | 28861 | 40 | ||||
| 8504 | 109669 | Undocumented 4 | Sequoia sempervirens :: Coast Redwood 155 | 200X GELLERT DR | 33 | Median : Cutout | Tree | DPW 1 | 02/26/2015 01:37:00 PM | 3 | 30x200 | 5985380 | 2094516.3 | 37.730298158605 | -122.492875173009 | (37.730298158605, -122.492875173009) | 1 | 8 | 4 | 64 | 35 | ||
| 25852 | 215035 | DPW Maintained 1 | Sequoia sempervirens :: Coast Redwood 155 | 639 Hearst Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 22 | 5997171.50868 | 2094376.6234 | 37.7305971411271 | -122.452100459987 | (37.7305971411271, -122.452100459987) | 9 | 7 | 4 | 28861 | 40 | ||||
| 127656 | 215036 | DPW Maintained 1 | Sequoia sempervirens :: Coast Redwood 155 | 694 Hearst Ave | 5 | Sidewalk: Property side : Yard | Tree | Private 2 | 16 | 5996922.84392 | 2094438.19015 | 37.7307519414457 | -122.452964569069 | (37.7307519414457, -122.452964569069) | 9 | 7 | 4 | 59 | 40 | ||||
| 92802 | 256419 | Undocumented 4 | Sequoia sempervirens :: Coast Redwood 155 | 3001 Sunset Blvd | 7 | Median : Yard | Tree | Private 2 | 10x10 | 5984960 | 2094729 | 37.7308576064943 | -122.49434282122 | (37.7308576064943, -122.49434282122) | 1 | 8 | 4 | 64 | 35 | ||||
| 101955 | 256418 | Undocumented 4 | Sequoia sempervirens :: Coast Redwood 155 | 3001 Sunset Blvd | 6 | Median : Yard | Tree | Private 2 | 10x10 | 5984960 | 2094729 | 37.7308576064943 | -122.49434282122 | (37.7308576064943, -122.49434282122) | 1 | 8 | 4 | 64 | 35 | ||||
| 180754 | 96273 | Significant Tree 6 | Sequoia sempervirens :: Coast Redwood 155 | 55@ Alemany Trumbull St | 1 | Back Yard : Yard | Tree | Private 2 | 6004020.1 | 2094407.4 | 37.7310715719205 | -122.428426044208 | (37.7310715719205, -122.428426044208) | 9 | 7 | 6 | 28861 | 5 | |||||
| 126376 | 215041 | DPW Maintained 1 | Sequoia sempervirens :: Coast Redwood 155 | 497 Joost Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | Width 10ft | 5998794.49638 | 2094951.64479 | 37.7322688495091 | -122.446530924367 | (37.7322688495091, -122.446530924367) | 9 | 7 | 4 | 59 | 40 | |||
| 94058 | 215043 | DPW Maintained 1 | Sequoia sempervirens :: Coast Redwood 155 | 798 Joost Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 14 | 5996915.73734 | 2095029.56264 | 37.732375301382 | -122.453031809567 | (37.732375301382, -122.453031809567) | 9 | 7 | 4 | 59 | 40 | ||||
| 19674 | 215042 | DPW Maintained 1 | Sequoia sempervirens :: Coast Redwood 155 | 689 Mangels Ave | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 34 | Width 10ft | 5996876.31142 | 2095244.73411 | 37.732963851 | -122.453183641224 | (37.732963851, -122.453183641224) | 9 | 7 | 4 | 59 | 40 | |||
| 30542 | 98548 | Property Tree 8 | Sequoia sempervirens :: Coast Redwood 155 | 132 Hamerton Ave | 1 | Front Yard : Yard | Tree | Private 2 | 6001332.8 | 2095440.7 | 37.7337563407686 | -122.437790462907 | (37.7337563407686, -122.437790462907) | 9 | 7 | 5 | 63 | 40 | |||||
| 14234 | 111268 | DPW Maintained 1 | Sequoia sempervirens :: Coast Redwood 155 | 700X BOSWORTH ST | 6 | Front Yard : Yard | Tree | DPW 1 | 3 | 6002150 | 2095428 | 37.7337679036822 | -122.434964255854 | (37.7337679036822, -122.434964255854) | 2 | 7 | 5 | 63 | 7 | ||||
| 72583 | 111269 | DPW Maintained 1 | Sequoia sempervirens :: Coast Redwood 155 | 700X BOSWORTH ST | 7 | Front Yard : Yard | Tree | DPW 1 | 3 | 6002150 | 2095428 | 37.7337679036822 | -122.434964255854 | (37.7337679036822, -122.434964255854) | 2 | 7 | 5 | 63 | 7 | ||||
| 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 | |||
| 47483 | 113358 | Significant Tree 6 | Sequoia sempervirens :: Coast Redwood 155 | 702 Foerster St | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | 5998153.40008835 | 2095558.62470631 | 37.7338988325043 | -122.448791034412 | (37.7338988325043, -122.448791034412) | 9 | 7 | 4 | 59 | 40 | |||||
| 110581 | 113359 | Significant Tree 6 | Sequoia sempervirens :: Coast Redwood 155 | 702 Foerster St | 2 | Sidewalk: Property side : Cutout | Tree | Private 2 | 5998153.40008835 | 2095558.62470631 | 37.7338988325043 | -122.448791034412 | (37.7338988325043, -122.448791034412) | 9 | 7 | 4 | 59 | 40 | |||||
| 13310 | 263635 | Undocumented 4 | Sequoia sempervirens :: Coast Redwood 155 | 702 Foerster St | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | 6x10 | 5998173 | 2095582 | 37.733964136305 | -122.448724954929 | (37.733964136305, -122.448724954929) | 9 | 7 | 4 | 59 | 40 | ||||
| 7906 | 262219 | Significant Tree 6 | Sequoia sempervirens :: Coast Redwood 155 | 21X Stillings Ave | 1 | Back Yard : Yard | Tree | Private 2 | 3x3 | 6000348 | 2095645 | 37.7342612534616 | -122.441209852629 | (37.7342612534616, -122.441209852629) | 9 | 7 | 5 | 63 | 40 | ||||
| 3054 | 109568 | Significant Tree 6 | Sequoia sempervirens :: Coast Redwood 155 | 95 Nordhoff St | 1 | Back Yard : Yard | Tree | Private 2 | Permit Number 777169 | 6000348.8 | 2095645.6 | 37.7342629464917 | -122.441207129815 | (37.7342629464917, -122.441207129815) | 9 | 7 | 5 | 63 | 40 | ||||
| 173461 | 185096 | DPW Maintained 1 | Sequoia sempervirens :: Coast Redwood 155 | 2801 Sunset Blvd | 24 | Sidewalk: Property side : Yard | Tree | Private 2 | 2 | Width 0ft | 5985018.6615 | 2095986.0271 | 37.7343125019956 | -122.494232639372 | (37.7343125019956, -122.494232639372) | 1 | 8 | 3 | 29491 | 35 | |||
| 44152 | 185095 | DPW Maintained 1 | Sequoia sempervirens :: Coast Redwood 155 | 2801 Sunset Blvd | 23 | Sidewalk: Property side : Yard | Tree | Private 2 | 2 | Width 0ft | 5985029.9671 | 2095999.845 | 37.7343511038502 | -122.494194570965 | (37.7343511038502, -122.494194570965) | 1 | 8 | 3 | 29491 | 35 | |||
| 53710 | 185092 | DPW Maintained 1 | Sequoia sempervirens :: Coast Redwood 155 | 2801 Sunset Blvd | 20 | Sidewalk: Property side : Yard | Tree | Private 2 | 2 | Width 0ft | 5985016.1492 | 2096009.4757 | 37.7343767385902 | -122.494243052853 | (37.7343767385902, -122.494243052853) | 1 | 8 | 3 | 29491 | 35 | |||
| 184053 | 109576 | Significant Tree 6 | Sequoia sempervirens :: Coast Redwood 155 | 21X STILLINGS AVE | 1 | Back Yard : Yard | Tree | Private 2 | 60 | 6000417 | 2095694 | 37.7343997262189 | -122.44097481224 | (37.7343997262189, -122.44097481224) | 9 | 7 | 5 | 63 | 40 | ||||
| 18463 | 262218 | Landmark tree 11 | Sequoia sempervirens :: Coast Redwood 155 | 46 Stillings Ave | 1 | Back Yard : Yard | Tree | Private 2 | 3x3 | 6000246 | 2095728 | 37.7344833413152 | -122.441568452522 | (37.7344833413152, -122.441568452522) | 9 | 7 | 5 | 63 | 40 | ||||
| 76123 | 240596 | DPW Maintained 1 | Sequoia sempervirens :: Coast Redwood 155 | 1300 San Jose Ave | 8 | Front Yard : Yard | Tree | Private 2 | 20 | 6003644.77453 | 2095717.83373 | 37.7346484808287 | -122.429817043043 | (37.7346484808287, -122.429817043043) | 2 | 7 | 5 | 63 | 7 | ||||
| 147229 | 240595 | DPW Maintained 1 | Sequoia sempervirens :: Coast Redwood 155 | 1300 San Jose Ave | 7 | Front Yard : Yard | Tree | Private 2 | 27 | 6003654.00301 | 2095729.23304 | 37.7346803033401 | -122.429785949874 | (37.7346803033401, -122.429785949874) | 2 | 7 | 5 | 63 | 7 | ||||
| 8497 | 186967 | DPW Maintained 1 | Sequoia sempervirens :: Coast Redwood 155 | 2800 Sunset Blvd | 41 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | Width 0ft | 5985210.5401 | 2096146.418 | 37.7347641193316 | -122.493581077021 | (37.7347641193316, -122.493581077021) | 1 | 8 | 3 | 29491 | 35 | |||
| 85976 | 186968 | DPW Maintained 1 | Sequoia sempervirens :: Coast Redwood 155 | 2800 Sunset Blvd | 42 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 0ft | 5985205.8316 | 2096154.4897 | 37.7347860066264 | -122.49359795025 | (37.7347860066264, -122.49359795025) | 1 | 8 | 3 | 29491 | 35 | |||
| 119876 | 186856 | DPW Maintained 1 | Sequoia sempervirens :: Coast Redwood 155 | 2700 Sunset Blvd | 5 | Sidewalk: Property side : Yard | Tree | Private 2 | 2 | Width 0ft | 5985217.4528 | 2096293.5766 | 37.7351685820648 | -122.493568017359 | (37.7351685820648, -122.493568017359) | 1 | 8 | 3 | 29491 | 35 | |||
| 30831 | 186891 | DPW Maintained 1 | Sequoia sempervirens :: Coast Redwood 155 | 2700 Sunset Blvd | 40 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | Width 0ft | 5985178.2577 | 2096509.7223 | 37.7357597676042 | -122.493719449451 | (37.7357597676042, -122.493719449451) | 1 | 8 | 3 | 29491 | 35 | |||
| 71263 | 184997 | DPW Maintained 1 | Sequoia sempervirens :: Coast Redwood 155 | 2701 Sunset Blvd | 23 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 0ft | 5985027.6641 | 2096515.5033 | 37.7357668292904 | -122.494240528594 | (37.7357668292904, -122.494240528594) | 1 | 8 | 3 | 29491 | 35 | |||
| 111475 | 184995 | DPW Maintained 1 | Sequoia sempervirens :: Coast Redwood 155 | 2701 Sunset Blvd | 21 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 0ft | 5985022.2207 | 2096528.9025 | 37.7358033013739 | -122.494260335606 | (37.7358033013739, -122.494260335606) | 1 | 8 | 3 | 29491 | 35 | |||
| 187226 | 215029 | DPW Maintained 1 | Sequoia sempervirens :: Coast Redwood 155 | 100 Terrace Dr | 24 | Sidewalk: Curb side : Yard | Tree | Private 2 | 12 | 5993749.23334 | 2096552.64498 | 37.7363753284443 | -122.464089591065 | (37.7363753284443, -122.464089591065) | 1 | 8 | 4 | 59 | 40 | ||||
| 183908 | 215028 | DPW Maintained 1 | Sequoia sempervirens :: Coast Redwood 155 | 100 Terrace Dr | 23 | Sidewalk: Curb side : Yard | Tree | Private 2 | 13 | 5993755.12546 | 2096561.9752 | 37.7364012864951 | -122.464069896803 | (37.7364012864951, -122.464069896803) | 1 | 8 | 4 | 59 | 40 | ||||
| 108685 | 215027 | DPW Maintained 1 | Sequoia sempervirens :: Coast Redwood 155 | 100 Terrace Dr | 22 | Sidewalk: Curb side : Yard | Tree | Private 2 | 14 | 5993761.26762 | 2096568.14898 | 37.7364185921533 | -122.464049108976 | (37.7364185921533, -122.464049108976) | 1 | 8 | 4 | 59 | 40 | ||||
| 142343 | 215026 | DPW Maintained 1 | Sequoia sempervirens :: Coast Redwood 155 | 100 Terrace Dr | 21 | Sidewalk: Curb side : Yard | Tree | Private 2 | 13 | 5993767.12006 | 2096575.58918 | 37.7364393583851 | -122.464029414719 | (37.7364393583851, -122.464029414719) | 1 | 8 | 4 | 59 | 40 | ||||
| 78989 | 186922 | DPW Maintained 1 | Sequoia sempervirens :: Coast Redwood 155 | 2700 Sunset Blvd | 71 | Sidewalk: Property side : Yard | Tree | Private 2 | 2 | Width 0ft | 5985180.0914 | 2096773.3145 | 37.7364836287386 | -122.493732527554 | (37.7364836287386, -122.493732527554) | 1 | 8 | 3 | 29491 | 35 | |||
| 40752 | 186924 | DPW Maintained 1 | Sequoia sempervirens :: Coast Redwood 155 | 2700 Sunset Blvd | 73 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 0ft | 5985155.3367 | 2096781.1077 | 37.7365035785089 | -122.493818687918 | (37.7365035785089, -122.493818687918) | 1 | 8 | 3 | 29491 | 35 | |||
| 156166 | 186923 | DPW Maintained 1 | Sequoia sempervirens :: Coast Redwood 155 | 2700 Sunset Blvd | 72 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 0ft | 5985171.3814 | 2096790.2761 | 37.7365296911913 | -122.493763890804 | (37.7365296911913, -122.493763890804) | 1 | 8 | 3 | 29491 | 35 | |||
| 158728 | 240594 | DPW Maintained 1 | Sequoia sempervirens :: Coast Redwood 155 | 216 Bemis St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 47 | 6003152.3623 | 2096416.56449 | 37.7365391390774 | -122.431569345074 | (37.7365391390774, -122.431569345074) | 2 | 7 | 5 | 63 | 7 | ||||
| 87089 | 215025 | DPW Maintained 1 | Sequoia sempervirens :: Coast Redwood 155 | 100 Terrace Dr | 14 | Sidewalk: Curb side : Yard | Tree | Private 2 | 10 | 5993646.76934 | 2096691.56193 | 37.7367508538673 | -122.464453932502 | (37.7367508538673, -122.464453932502) | 1 | 8 | 4 | 59 | 40 | ||||
| 121642 | 215024 | DPW Maintained 1 | Sequoia sempervirens :: Coast Redwood 155 | 100 Terrace Dr | 13 | Sidewalk: Curb side : Yard | Tree | Private 2 | 12 | 5993634.34816 | 2096702.85203 | 37.7367811376468 | -122.464497697112 | (37.7367811376468, -122.464497697112) | 1 | 8 | 4 | 59 | 40 | ||||
| 123200 | 215023 | DPW Maintained 1 | Sequoia sempervirens :: Coast Redwood 155 | 100 Terrace Dr | 12 | Sidewalk: Curb side : Yard | Tree | Private 2 | 12 | 5993620.60867 | 2096711.64912 | 37.736804500228 | -122.464545838734 | (37.736804500228, -122.464545838734) | 1 | 8 | 4 | 59 | 40 | ||||
| 77920 | 215022 | DPW Maintained 1 | Sequoia sempervirens :: Coast Redwood 155 | 100 Terrace Dr | 11 | Sidewalk: Curb side : Yard | Tree | Private 2 | 12 | 5993608.12799 | 2096720.10438 | 37.7368269967784 | -122.464589603347 | (37.7368269967784, -122.464589603347) | 1 | 8 | 4 | 59 | 40 | ||||
| 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 | |||
| 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 | |||
| 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 | |||
| 67057 | 240631 | DPW Maintained 1 | Sequoia sempervirens :: Coast Redwood 155 | 57 Poppy Ln | 1 | Back Yard : Yard | Tree | Private 2 | 4 | Width 2ft | 6002629.35658 | 2096548.63014 | 37.7368721031581 | -122.433387031387 | (37.7368721031581, -122.433387031387) | 2 | 7 | 5 | 63 | 7 | |||
| 26601 | 258075 | Undocumented 4 | Sequoia sempervirens :: Coast Redwood 155 | 1300X Wawona St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 10x10 | 5988924 | 2097013 | 37.7373600650942 | -122.480805942066 | (37.7373600650942, -122.480805942066) | 1 | 8 | 3 | 29491 | 35 | ||||
| 140063 | 95435 | Undocumented 4 | Sequoia sempervirens :: Coast Redwood 155 | 2675 25th Ave | 2 | Unaccepted Street : Yard | Tree | Private 2 | 12 | 5988610 | 2097126.3 | 37.7376529013161 | -122.481899870051 | (37.7376529013161, -122.481899870051) | 1 | 8 | 3 | 29491 | 35 | ||||
| 150450 | 95432 | Undocumented 4 | Sequoia sempervirens :: Coast Redwood 155 | 2675 25th Ave | 1 | Unaccepted Street : Yard | Tree | Private 2 | 12 | 5988610 | 2097126.3 | 37.7376529013161 | -122.481899870051 | (37.7376529013161, -122.481899870051) | 1 | 8 | 3 | 29491 | 35 |
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) );