trees
105 rows where qSpecies_id = 207
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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1899 | 211289 | DPW Maintained 1 | Pinus thunbergii :: Japanese Black Pine 207 | 100x Idora Ave | 8 | Median : Yard | Tree | DPW 1 | 5 | Width 9ft | 5995366.53481 | 2099407.60632 | 37.7443074262592 | -122.458704561274 | (37.7443074262592, -122.458704561274) | 1 | 8 | 4 | 59 | 40 | |||
| 3909 | 72619 | DPW Maintained 1 | Pinus thunbergii :: Japanese Black Pine 207 | 1501 25th St | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 3 | 6014112.41044 | 2101961.52593 | 37.7523795619766 | -122.394063561604 | (37.7523795619766, -122.394063561604) | 10 | 3 | 8 | 28856 | 1 | |||
| 5296 | 211304 | DPW Maintained 1 | Pinus thunbergii :: Japanese Black Pine 207 | 100 Melrose Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 14 | Width 5ft | 5999410.34082 | 2095532.95691 | 37.7339001531733 | -122.444443579902 | (37.7339001531733, -122.444443579902) | 9 | 7 | 4 | 59 | 40 | |||
| 10111 | 233339 | DPW Maintained 1 | Pinus thunbergii :: Japanese Black Pine 207 | 4750 17th St | 1 | Sidewalk: Curb side : Pot | Tree | Private 2 | 4 | Width 4ft | 5998413.40576 | 2105689.21442 | 37.7617298240875 | -122.448621500105 | (37.7617298240875, -122.448621500105) | 15 | 5 | 11 | 29492 | 9 | |||
| 11225 | 194523 | DPW Maintained 1 | Pinus thunbergii :: Japanese Black Pine 207 | 900x Carolina St | 72 | Median : Yard | Tree | DPW 1 | 3 | 6012512.86953 | 2102814.17539 | 37.7546317206991 | -122.399654931846 | (37.7546317206991, -122.399654931846) | 10 | 3 | 8 | 28856 | 29 | ||||
| 15369 | 95709 | DPW Maintained 1 | Pinus thunbergii :: Japanese Black Pine 207 | 277 Athens St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/12/2009 12:00:00 AM | 6 | 3x3 | Permit Number 767467 | 6004405.41934 | 2091654.97001 | 37.7235358065292 | -122.426897975887 | (37.7235358065292, -122.426897975887) | 9 | 7 | 6 | 28861 | 5 |
| 16014 | 132209 | DPW Maintained 1 | Pinus thunbergii :: Japanese Black Pine 207 | 2430 Francisco St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 10 | Width 4ft | 5999675.04653 | 2119861.25281 | 37.8007146452294 | -122.445276993363 | (37.8007146452294, -122.445276993363) | 13 | 9 | 1 | 57 | 17 | |||
| 17211 | 178354 | DPW Maintained 1 | Pinus thunbergii :: Japanese Black Pine 207 | 103 Bowdoin St | 7 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | Width 6ft | 6008475.65787 | 2094541.35345 | 37.7316905027125 | -122.413031829249 | (37.7316905027125, -122.413031829249) | 9 | 3 | 7 | 309 | 28 | |||
| 17393 | 74252 | DPW Maintained 1 | Pinus thunbergii :: Japanese Black Pine 207 | 1501 25th St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 9 | 6014087.4266 | 2101965.31447 | 37.7523885758791 | -122.394150225664 | (37.7523885758791, -122.394150225664) | 10 | 3 | 8 | 28856 | 1 | |||
| 25737 | 248090 | DPW Maintained 1 | Pinus thunbergii :: Japanese Black Pine 207 | 14 Montcalm St | 4 | Side Yard : Yard | Tree | Private 2 | 10 | 6010640.27543 | 2100283.5284 | 37.7475785582158 | -122.40595263501 | (37.7475785582158, -122.40595263501) | 2 | 7 | 7 | 28859 | 2 | ||||
| 26718 | 806 | DPW Maintained 1 | Pinus thunbergii :: Japanese Black Pine 207 | 600X 39th Ave | 4 | Median : Cutout | Tree | DPW 1 | 6 | 6-HOA | 5983808.23309 | 2111660.75491 | 37.7772800206503 | -122.499575472587 | (37.7772800206503, -122.499575472587) | 11 | 6 | 2 | 55 | 26 | |||
| 27005 | 233358 | DPW Maintained 1 | Pinus thunbergii :: Japanese Black Pine 207 | 297 Addison St | 6 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 8ft | 6002502.18245 | 2097693.83155 | 37.7400093458678 | -122.433908560839 | (37.7400093458678, -122.433908560839) | 2 | 7 | 5 | 63 | 7 | |||
| 27363 | 194521 | DPW Maintained 1 | Pinus thunbergii :: Japanese Black Pine 207 | 331 Pennsylvania Ave | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 13 | Width 7ft | 6014370.45648 | 2105571.44717 | 37.7623059666689 | -122.393423797368 | (37.7623059666689, -122.393423797368) | 10 | 3 | 8 | 28856 | 29 | |||
| 27665 | 211302 | DPW Maintained 1 | Pinus thunbergii :: Japanese Black Pine 207 | 90 Melrose Ave | 11 | Sidewalk: Property side : Yard | Tree | Private 2 | 8 | Width 8ft | 5999487.07126 | 2095531.52008 | 37.7339005857431 | -122.444178197174 | (37.7339005857431, -122.444178197174) | 9 | 7 | 4 | 63 | 40 | |||
| 28828 | 250705 | DPW Maintained 1 | Pinus thunbergii :: Japanese Black Pine 207 | 50 McLaren Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 12 | 5986855.91408 | 2114891.44355 | 37.7863289197747 | -122.489270296302 | (37.7863289197747, -122.489270296302) | 11 | 6 | 1 | 55 | 33 | ||||
| 28972 | 183499 | DPW Maintained 1 | Pinus thunbergii :: Japanese Black Pine 207 | 2547 22nd Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 0ft | 5989528.9054 | 2098003.093 | 37.7401137456724 | -122.478786917737 | (37.7401137456724, -122.478786917737) | 1 | 8 | 3 | 29491 | 35 | |||
| 30268 | 185707 | DPW Maintained 1 | Pinus thunbergii :: Japanese Black Pine 207 | 2101 Sunset Blvd | 39 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | Width 0ft | 5984860.1074 | 2100466.1424 | 37.7466044114129 | -122.495111058564 | (37.7466044114129, -122.495111058564) | 1 | 8 | 3 | 29491 | 35 | |||
| 30485 | 248236 | DPW Maintained 1 | Pinus thunbergii :: Japanese Black Pine 207 | 298 Esmeralda Ave | 1 | Side Yard : Yard | Tree | Private 2 | 15 | 6006718.26384 | 2099043.39902 | 37.7439533110004 | -122.419426777927 | (37.7439533110004, -122.419426777927) | 2 | 7 | 7 | 28859 | 2 | ||||
| 30668 | 211298 | DPW Maintained 1 | Pinus thunbergii :: Japanese Black Pine 207 | 401 Orizaba Ave | 1 | Sidewalk: Curb side : Pot | Tree | Private 2 | 17 | Width 5ft | 5993996.41913 | 2089243.48122 | 37.7163203865396 | -122.462704908526 | (37.7163203865396, -122.462704908526) | 9 | 8 | 6 | 64 | 24 | |||
| 31658 | 250463 | DPW Maintained 1 | Pinus thunbergii :: Japanese Black Pine 207 | 285 Seacliff Ave | 1 | : | Tree | Private 2 | 12 | Width 4ft | 5986841.00712 | 2115627.98923 | 37.7883503915961 | -122.489376046686 | (37.7883503915961, -122.489376046686) | 11 | 6 | 1 | 55 | 33 | |||
| 32338 | 186068 | DPW Maintained 1 | Pinus thunbergii :: Japanese Black Pine 207 | 1901 Sunset Blvd | 14 | Sidewalk: Property side : Yard | Tree | Private 2 | 2 | Width 0ft | 5984805.0303 | 2102059.3421 | 37.750975677225 | -122.495418987844 | (37.750975677225, -122.495418987844) | 1 | 8 | 3 | 29491 | 35 | |||
| 34151 | 250343 | DPW Maintained 1 | Pinus thunbergii :: Japanese Black Pine 207 | 26 25th Ave | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 20 | Width 3ft | 5988241.89624 | 2115839.31927 | 37.7890123214057 | -122.484544764541 | (37.7890123214057, -122.484544764541) | 11 | 6 | 1 | 61 | 33 | |||
| 36879 | 183498 | DPW Maintained 1 | Pinus thunbergii :: Japanese Black Pine 207 | 2547 22nd Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 6 | Width 0ft | 5989527.6597 | 2098025.0998 | 37.7401740983062 | -122.478792833917 | (37.7401740983062, -122.478792833917) | 1 | 8 | 3 | 29491 | 35 | |||
| 39340 | 211295 | DPW Maintained 1 | Pinus thunbergii :: Japanese Black Pine 207 | 139 De Montfort Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 5994867.97921 | 2091874.32239 | 37.7235942066902 | -122.459882858411 | (37.7235942066902, -122.459882858411) | 9 | 8 | 4 | 28861 | 24 | |||
| 40101 | 211305 | DPW Maintained 1 | Pinus thunbergii :: Japanese Black Pine 207 | 517 Mangels Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 7 | Width 10ft | 5998007.82489 | 2095231.9936 | 37.7329936554237 | -122.449270805203 | (37.7329936554237, -122.449270805203) | 9 | 7 | 4 | 59 | 40 | |||
| 45526 | 211299 | DPW Maintained 1 | Pinus thunbergii :: Japanese Black Pine 207 | 212 Vernon St | 1 | Sidewalk: Curb side : Pot | Tree | Private 2 | 4 | Width 3ft | 5992481.14355 | 2089300.95007 | 37.7163907953652 | -122.467946569297 | (37.7163907953652, -122.467946569297) | 9 | 8 | 6 | 64 | 24 | |||
| 48010 | 233350 | DPW Maintained 1 | Pinus thunbergii :: Japanese Black Pine 207 | 565 Duncan St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | Width 10ft | 6002880.03103 | 2099748.36188 | 37.7456720440331 | -122.43274884639 | (37.7456720440331, -122.43274884639) | 2 | 7 | 5 | 63 | 22 | |||
| 49541 | 118626 | DPW Maintained 1 | Pinus thunbergii :: Japanese Black Pine 207 | 499 46th Ave | 1 | Side Yard : Yard | Tree | Private 2 | 7 | Width 10ft | 5981578.2503 | 2112431.17888 | 37.7792642811872 | -122.507346739716 | (37.7792642811872, -122.507346739716) | 11 | 6 | 2 | 55 | 26 | |||
| 50455 | 194522 | DPW Maintained 1 | Pinus thunbergii :: Japanese Black Pine 207 | 1901 20th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6012357.59837 | 2104667.69844 | 37.7597124315988 | -122.400322083115 | (37.7597124315988, -122.400322083115) | 10 | 3 | 8 | 28856 | 29 | |||
| 52603 | 121699 | DPW Maintained 1 | Pinus thunbergii :: Japanese Black Pine 207 | 1002 Pennsylvania Ave | 1 | Front Yard : Yard | Tree | Private 2 | 13 | 6014459.10408 | 2102474.46412 | 37.753807243829 | -122.392900512462 | (37.753807243829, -122.392900512462) | 10 | 3 | 8 | 28856 | 29 | ||||
| 52979 | 16145 | DPW Maintained 1 | Pinus thunbergii :: Japanese Black Pine 207 | 370 Monterey Blvd | 8 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3X3 | 5999721.38347 | 2094725.6667 | 37.7317012658025 | -122.443310249792 | (37.7317012658025, -122.443310249792) | 9 | 7 | 4 | 63 | 40 | |||
| 54678 | 249769 | DPW Maintained 1 | Pinus thunbergii :: Japanese Black Pine 207 | 1690 Kearny St | 8 | Side Yard : Yard | Tree | Private 2 | 17 | Width 0ft | 6010840.59654 | 2120830.53405 | 37.8040070713206 | -122.406707723804 | (37.8040070713206, -122.406707723804) | 3 | 1 | 10 | 308 | 23 | |||
| 55688 | 178353 | DPW Maintained 1 | Pinus thunbergii :: Japanese Black Pine 207 | 648 Peru Ave | 5 | Side Yard : Yard | Tree | Private 2 | 5 | 6005050.25442 | 2092601.27902 | 37.7261706033722 | -122.424736181946 | (37.7261706033722, -122.424736181946) | 9 | 7 | 6 | 28861 | 5 | ||||
| 56185 | 211306 | DPW Maintained 1 | Pinus thunbergii :: Japanese Black Pine 207 | 380 Monterey Blvd | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 8 | Width 8ft | 5999601.46819 | 2094724.09535 | 37.7316901124036 | -122.443724706826 | (37.7316901124036, -122.443724706826) | 9 | 7 | 4 | 63 | 40 | |||
| 56727 | 186056 | DPW Maintained 1 | Pinus thunbergii :: Japanese Black Pine 207 | 1901 Sunset Blvd | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 2 | Width 0ft | 5984841.3927 | 2102202.6369 | 37.7513712544474 | -122.495303811437 | (37.7513712544474, -122.495303811437) | 1 | 8 | 3 | 29491 | 35 | |||
| 58328 | 211292 | DPW Maintained 1 | Pinus thunbergii :: Japanese Black Pine 207 | 611 Joost Ave | 6 | Sidewalk: Property side : Yard | Tree | Private 2 | 15 | 5998050.98458 | 2094962.27649 | 37.7322555449463 | -122.449102167954 | (37.7322555449463, -122.449102167954) | 9 | 7 | 4 | 59 | 40 | ||||
| 58991 | 211309 | DPW Maintained 1 | Pinus thunbergii :: Japanese Black Pine 207 | 200 Judson Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | 5998727.09419 | 2093528.84239 | 37.728358318479 | -122.446661614764 | (37.728358318479, -122.446661614764) | 9 | 7 | 4 | 28861 | 40 | ||||
| 59149 | 211293 | DPW Maintained 1 | Pinus thunbergii :: Japanese Black Pine 207 | 532 Flood Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 7 | 5997196.70248 | 2094134.43006 | 37.7299335790692 | -122.451995894888 | (37.7299335790692, -122.451995894888) | 9 | 7 | 4 | 28861 | 40 | ||||
| 60055 | 118582 | DPW Maintained 1 | Pinus thunbergii :: Japanese Black Pine 207 | 110 Point Lobos Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 16 | 5982455.82259 | 2112616.16545 | 37.7798238523395 | -122.504324612183 | (37.7798238523395, -122.504324612183) | 11 | 6 | 2 | 55 | 26 | ||||
| 64019 | 178349 | DPW Maintained 1 | Pinus thunbergii :: Japanese Black Pine 207 | 111 Brunswick St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 20 | Width 1ft | 6000769.98227 | 2087401.03003 | 37.7116492152228 | -122.439160258941 | (37.7116492152228, -122.439160258941) | 9 | 7 | 6 | 28861 | 5 | |||
| 64085 | 178350 | DPW Maintained 1 | Pinus thunbergii :: Japanese Black Pine 207 | 239 Peninsula Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 9 | Width 6ft | 6012479.39817 | 2087413.73927 | 37.7123434603661 | -122.398689994354 | (37.7123434603661, -122.398689994354) | 10 | 3 | 8 | 309 | 1 | |||
| 69044 | 233356 | DPW Maintained 1 | Pinus thunbergii :: Japanese Black Pine 207 | 174 Moreland St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 7 | Width 4ft | 6002109.14644 | 2097518.88743 | 37.7395066779031 | -122.435255005132 | (37.7395066779031, -122.435255005132) | 2 | 7 | 5 | 63 | 7 | |||
| 69411 | 117760 | DPW Maintained 1 | Pinus thunbergii :: Japanese Black Pine 207 | 446 39th Ave | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 12 | Width 6ft | 5983798.11714 | 2112817.23967 | 37.7804547980537 | -122.49969596271 | (37.7804547980537, -122.49969596271) | 11 | 6 | 2 | 55 | 26 | |||
| 71858 | 185958 | DPW Maintained 1 | Pinus thunbergii :: Japanese Black Pine 207 | 2001 Sunset Blvd | 17 | Sidewalk: Property side : Yard | Tree | Private 2 | 2 | Width 0ft | 5984827.369 | 2101371.4447 | 37.749088207558 | -122.495291014826 | (37.749088207558, -122.495291014826) | 1 | 8 | 3 | 29491 | 35 | |||
| 74659 | 66366 | DPW Maintained 1 | Pinus thunbergii :: Japanese Black Pine 207 | 2 Collins St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/04/1991 12:00:00 AM | 6 | Permit Number 29488 | 5998129.63122 | 2114497.84593 | 37.7858998280554 | -122.450237923565 | (37.7858998280554, -122.450237923565) | 15 | 6 | 1 | 54 | 31 | |
| 75995 | 233340 | DPW Maintained 1 | Pinus thunbergii :: Japanese Black Pine 207 | 181 Elsie St | 1 | Sidewalk: Curb side : Pot | Tree | Private 2 | 16 | 6006969.35222 | 2098138.0175 | 37.7414814748898 | -122.418494383305 | (37.7414814748898, -122.418494383305) | 2 | 7 | 7 | 28859 | 2 | ||||
| 76182 | 233352 | DPW Maintained 1 | Pinus thunbergii :: Japanese Black Pine 207 | 592 Duncan St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | Width 5ft | 6002775.30192 | 2099794.2981 | 37.7457922339331 | -122.433114265229 | (37.7457922339331, -122.433114265229) | 2 | 7 | 5 | 63 | 22 | |||
| 76545 | 233343 | DPW Maintained 1 | Pinus thunbergii :: Japanese Black Pine 207 | 880 Duncan St | 3 | Sidewalk: Curb side : Pot | Tree | Private 2 | 3 | Width 3ft | 6000897.1676 | 2099687.48578 | 37.7453922361643 | -122.439600913267 | (37.7453922361643, -122.439600913267) | 2 | 4 | 5 | 63 | 22 | |||
| 81276 | 114097 | Significant Tree 6 | Pinus thunbergii :: Japanese Black Pine 207 | 221x VIDAL DR | 1 | Front Yard : Yard | Tree | Private 2 | 14 | 5987664 | 2090556 | 37.7195574904968 | -122.484688777519 | (37.7195574904968, -122.484688777519) | 1 | 8 | 4 | 64 | 14 | ||||
| 83551 | 132210 | DPW Maintained 1 | Pinus thunbergii :: Japanese Black Pine 207 | 21 Hastings Ter | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 2 | Width 10ft | 6007287.11511 | 2119268.83757 | 37.7995195892196 | -122.418893985392 | (37.7995195892196, -122.418893985392) | 5 | 1 | 1 | 28858 | 32 | |||
| 83993 | 250469 | DPW Maintained 1 | Pinus thunbergii :: Japanese Black Pine 207 | 330 Seacliff Ave | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 9 | Width 4ft | 5986766.23887 | 2115556.12451 | 37.7881487069317 | -122.489629442364 | (37.7881487069317, -122.489629442364) | 11 | 6 | 1 | 55 | 33 | |||
| 85910 | 194525 | DPW Maintained 1 | Pinus thunbergii :: Japanese Black Pine 207 | 3525 Jennings St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 5 | 6013063.15415 | 2089423.86391 | 37.7178953710405 | -122.3968131803 | (37.7178953710405, -122.3968131803) | 10 | 3 | 8 | 58 | 1 | ||||
| 86881 | 233349 | DPW Maintained 1 | Pinus thunbergii :: Japanese Black Pine 207 | 1847 Castro St | 1 | Sidewalk: Curb side : Pot | Tree | Private 2 | 10 | 6002644.43653 | 2100086.75284 | 37.7465878218663 | -122.433587675538 | (37.7465878218663, -122.433587675538) | 2 | 7 | 5 | 63 | 22 | ||||
| 86978 | 123318 | DPW Maintained 1 | Pinus thunbergii :: Japanese Black Pine 207 | 614 05th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 4ft | 5994420.93417 | 2111300.62416 | 37.7769081808925 | -122.462836860428 | (37.7769081808925, -122.462836860428) | 11 | 6 | 2 | 54 | 11 | |||
| 92221 | 233357 | DPW Maintained 1 | Pinus thunbergii :: Japanese Black Pine 207 | 100 Beacon St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 13 | Width 9ft | 6003400.53287 | 2097174.07927 | 37.7386331645932 | -122.43076535563 | (37.7386331645932, -122.43076535563) | 2 | 7 | 5 | 63 | 7 | |||
| 92489 | 233353 | DPW Maintained 1 | Pinus thunbergii :: Japanese Black Pine 207 | 470 Beacon St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 12 | Width 10ft | 6002255.72146 | 2098533.86414 | 37.7423018904126 | -122.43482077735 | (37.7423018904126, -122.43482077735) | 2 | 7 | 5 | 63 | 7 | |||
| 96001 | 211303 | DPW Maintained 1 | Pinus thunbergii :: Japanese Black Pine 207 | 806 Detroit St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 7 | Width 8ft | 5999473.71224 | 2095555.42571 | 37.7339654628389 | -122.444226100474 | (37.7339654628389, -122.444226100474) | 9 | 7 | 4 | 63 | 40 | |||
| 99603 | 124178 | DPW Maintained 1 | Pinus thunbergii :: Japanese Black Pine 207 | 8X Almaden Ct | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 2 | Width 9ft | 5995876 | 2112606 | 37.7805760973259 | -122.457897862346 | (37.7805760973259, -122.457897862346) | 11 | 6 | 2 | 54 | 16 | |||
| 100033 | 233338 | DPW Maintained 1 | Pinus thunbergii :: Japanese Black Pine 207 | 284 28th St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 2ft | 6004000.47711 | 2099567.89749 | 37.7452400124089 | -122.42886164734 | (37.7452400124089, -122.42886164734) | 2 | 7 | 5 | 63 | 22 | |||
| 101664 | 247233 | DPW Maintained 1 | Pinus thunbergii :: Japanese Black Pine 207 | 760 Duboce Ave | 5 | : | Tree | Private 2 | 14 | Width 3ft | 6001988.83207 | 2108291.886 | 37.7690799166222 | -122.436441842217 | (37.7690799166222, -122.436441842217) | 15 | 5 | 5 | 29492 | 9 | |||
| 102279 | 233351 | DPW Maintained 1 | Pinus thunbergii :: Japanese Black Pine 207 | 554 Duncan St | 1 | Sidewalk: Curb side : Pot | Tree | Private 2 | 2 | Width 2ft | 6002951.61028 | 2099802.94851 | 37.7458259854938 | -122.432505234436 | (37.7458259854938, -122.432505234436) | 2 | 7 | 5 | 63 | 22 | |||
| 102947 | 4282 | DPW Maintained 1 | Pinus thunbergii :: Japanese Black Pine 207 | 4301 Cesar Chavez St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/07/1995 12:00:00 AM | 3 | 3X3 | 6001859.22547 | 2100283.37005 | 37.7470831028056 | -122.436316916491 | (37.7470831028056, -122.436316916491) | 2 | 4 | 5 | 63 | 22 | ||
| 105103 | 117689 | DPW Maintained 1 | Pinus thunbergii :: Japanese Black Pine 207 | 420 43rd Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 4 | Width 3ft | 5982541.98731 | 2112946.86538 | 37.7807369244015 | -122.50405103744 | (37.7807369244015, -122.50405103744) | 11 | 6 | 2 | 55 | 26 | |||
| 106650 | 182723 | DPW Maintained 1 | Pinus thunbergii :: Japanese Black Pine 207 | 1711 26th Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 3 | Width 0ft | 5988092.6268 | 2103646.3239 | 37.7555250536563 | -122.484166667612 | (37.7555250536563, -122.484166667612) | 1 | 8 | 3 | 56 | 35 | |||
| 106962 | 233355 | DPW Maintained 1 | Pinus thunbergii :: Japanese Black Pine 207 | 45 Clarendon Ave | 1 | : | Tree | Private 2 | 1 | Width 3ft | 5998067.99243 | 2104637.92376 | 37.758823486839 | -122.449740378141 | (37.758823486839, -122.449740378141) | 15 | 5 | 4 | 28862 | 38 | |||
| 107755 | 211287 | DPW Maintained 1 | Pinus thunbergii :: Japanese Black Pine 207 | 1549 15th Ave | 8 | Side Yard : Yard | Tree | Private 2 | 8 | 5991543.24459 | 2104910.37541 | 37.7591961074458 | -122.472325621056 | (37.7591961074458, -122.472325621056) | 1 | 8 | 4 | 56 | 12 | ||||
| 109476 | 211290 | DPW Maintained 1 | Pinus thunbergii :: Japanese Black Pine 207 | 415 Flood Ave | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 15 | Width 8ft | 5998037.33347 | 2094068.58839 | 37.7298009083751 | -122.449085005264 | (37.7298009083751, -122.449085005264) | 9 | 7 | 4 | 28861 | 40 | |||
| 110556 | 211297 | DPW Maintained 1 | Pinus thunbergii :: Japanese Black Pine 207 | 915 Capitol Ave | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | Width 8ft | 5994996.28556 | 2090021.99149 | 37.7185155264564 | -122.459305252661 | (37.7185155264564, -122.459305252661) | 9 | 8 | 6 | 28861 | 24 | |||
| 125383 | 211288 | DPW Maintained 1 | Pinus thunbergii :: Japanese Black Pine 207 | 800x Miramar Ave | 6 | Median : Yard | Tree | DPW 1 | 16 | 5995401.87913 | 2094414.4819 | 37.7305995639058 | -122.458221033587 | (37.7305995639058, -122.458221033587) | 9 | 7 | 4 | 28861 | 40 | ||||
| 126558 | 118584 | DPW Maintained 1 | Pinus thunbergii :: Japanese Black Pine 207 | 110 Point Lobos Ave | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 7 | 5982432.95165 | 2112629.56969 | 37.7798593112778 | -122.504404724819 | (37.7798593112778, -122.504404724819) | 11 | 6 | 2 | 55 | 26 | ||||
| 128642 | 211308 | DPW Maintained 1 | Pinus thunbergii :: Japanese Black Pine 207 | 279 Staples Ave | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 10 | 5998250.2565 | 2093776.28669 | 37.7290104924178 | -122.448327868763 | (37.7290104924178, -122.448327868763) | 9 | 7 | 4 | 28861 | 40 | ||||
| 133403 | 211296 | DPW Maintained 1 | Pinus thunbergii :: Japanese Black Pine 207 | 131 De Montfort Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 5994879.33842 | 2091873.53193 | 37.7235926895479 | -122.459843534659 | (37.7235926895479, -122.459843534659) | 9 | 8 | 4 | 28861 | 24 | |||
| 135618 | 248089 | DPW Maintained 1 | Pinus thunbergii :: Japanese Black Pine 207 | 14 Montcalm St | 3 | Side Yard : Yard | Tree | Private 2 | 6 | 6010641.03165 | 2100300.14916 | 37.7476242374868 | -122.405951190707 | (37.7476242374868, -122.405951190707) | 2 | 7 | 7 | 28859 | 2 | ||||
| 136379 | 194524 | DPW Maintained 1 | Pinus thunbergii :: Japanese Black Pine 207 | 776 Rhode Island St | 1 | Sidewalk: Curb side : Pot | Tree | Private 2 | 4 | Width 6ft | 6011804.85621 | 2104776.18304 | 37.759979468185 | -122.402241382936 | (37.759979468185, -122.402241382936) | 10 | 3 | 8 | 28856 | 29 | |||
| 140928 | 118583 | DPW Maintained 1 | Pinus thunbergii :: Japanese Black Pine 207 | 110 Point Lobos Ave | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | 5982437.33611 | 2112624.20449 | 37.7798448378945 | -122.504389159707 | (37.7798448378945, -122.504389159707) | 11 | 6 | 2 | 55 | 26 | ||||
| 143987 | 250706 | DPW Maintained 1 | Pinus thunbergii :: Japanese Black Pine 207 | 50 McLaren Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 12 | 5986887.67372 | 2114887.10881 | 37.7863188716619 | -122.489160098754 | (37.7863188716619, -122.489160098754) | 11 | 6 | 1 | 55 | 33 | ||||
| 144825 | 233337 | DPW Maintained 1 | Pinus thunbergii :: Japanese Black Pine 207 | 251 Coso Ave | 1 | Back Yard : Yard | Tree | Private 2 | 8 | 6007732.48322 | 2099500.473 | 37.7452654065818 | -122.415952190562 | (37.7452654065818, -122.415952190562) | 2 | 7 | 7 | 28859 | 2 | ||||
| 146116 | 113194 | DPW Maintained 1 | Pinus thunbergii :: Japanese Black Pine 207 | 699X Noe St | 1 | Median : Yard | Tree | DPW 1 | 12 | 6003039.77971 | 2104315.51778 | 37.7582214335608 | -122.432522620301 | (37.7582214335608, -122.432522620301) | 2 | 4 | 5 | 28862 | 3 | ||||
| 146594 | 178351 | DPW Maintained 1 | Pinus thunbergii :: Japanese Black Pine 207 | 20 Tucker Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 14 | Width 5ft | 6011047.67899 | 2088492.73765 | 37.7152262992376 | -122.403714347453 | (37.7152262992376, -122.403714347453) | 9 | 7 | 8 | 309 | 39 | |||
| 148194 | 211301 | DPW Maintained 1 | Pinus thunbergii :: Japanese Black Pine 207 | 22 Sargent St | 2 | Sidewalk: Property side : Yard | Tree | DPW 1 | 16 | Width 4ft | 5993918.24857 | 2089205.75013 | 37.7162122835381 | -122.462972366002 | (37.7162122835381, -122.462972366002) | 9 | 8 | 6 | 64 | 24 | |||
| 149695 | 255521 | Undocumented 4 | Pinus thunbergii :: Japanese Black Pine 207 | 2061 10th Ave | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | 3x3 | Permit Number 781979 | 5993167.34823 | 2101456.73677 | 37.7498071704373 | -122.466457721745 | (37.7498071704373, -122.466457721745) | 1 | 8 | 4 | 29491 | 12 | |||
| 152320 | 185552 | DPW Maintained 1 | Pinus thunbergii :: Japanese Black Pine 207 | 2201 Sunset Blvd | 36 | Sidewalk: Property side : Yard | Tree | Private 2 | 2 | Width 0ft | 5984872.5433 | 2099849.2038 | 37.7449111938902 | -122.49502257363 | (37.7449111938902, -122.49502257363) | 1 | 8 | 3 | 29491 | 35 | |||
| 156243 | 118585 | DPW Maintained 1 | Pinus thunbergii :: Japanese Black Pine 207 | 110 Point Lobos Ave | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 18 | 5982437.76166 | 2112637.90018 | 37.7798824672597 | -122.504388702469 | (37.7798824672597, -122.504388702469) | 11 | 6 | 2 | 55 | 26 | ||||
| 156881 | 233347 | DPW Maintained 1 | Pinus thunbergii :: Japanese Black Pine 207 | 630 Alvarado St | 3 | Sidewalk: Curb side : Pot | Tree | Private 2 | 10 | Width 4ft | 6002310.34466 | 2102682.07456 | 37.753694998543 | -122.43492850446 | (37.753694998543, -122.43492850446) | 2 | 4 | 5 | 28862 | 22 | |||
| 158040 | 211291 | DPW Maintained 1 | Pinus thunbergii :: Japanese Black Pine 207 | 733 Joost Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 8ft | 5997213.95847 | 2094973.7768 | 37.732239213275 | -122.451996771739 | (37.732239213275, -122.451996771739) | 9 | 7 | 4 | 59 | 40 | |||
| 158325 | 248091 | DPW Maintained 1 | Pinus thunbergii :: Japanese Black Pine 207 | 14 Montcalm St | 5 | Side Yard : Yard | Tree | Private 2 | 10 | 6010638.35138 | 2100271.09071 | 37.7475442994263 | -122.405958412248 | (37.7475442994263, -122.405958412248) | 2 | 7 | 7 | 28859 | 2 | ||||
| 158522 | 178352 | DPW Maintained 1 | Pinus thunbergii :: Japanese Black Pine 207 | 326 Naglee Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 7 | 5997716.4842 | 2088561.01593 | 37.7146600447076 | -122.449797461695 | (37.7146600447076, -122.449797461695) | 9 | 7 | 6 | 28861 | 25 | ||||
| 161991 | 201524 | DPW Maintained 1 | Pinus thunbergii :: Japanese Black Pine 207 | 740 Earl St | 1 | Front Yard : Yard | Tree | Private 2 | 4 | 6020392.93719 | 2093745.64338 | 37.7301674216776 | -122.371775862971 | (37.7301674216776, -122.371775862971) | 10 | 3 | 8 | 58 | 1 | ||||
| 162259 | 233344 | DPW Maintained 1 | Pinus thunbergii :: Japanese Black Pine 207 | 729 Duncan St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 10ft | 6001803.82877 | 2099686.32578 | 37.7454406124978 | -122.436465748002 | (37.7454406124978, -122.436465748002) | 2 | 7 | 5 | 63 | 22 | |||
| 164082 | 233345 | DPW Maintained 1 | Pinus thunbergii :: Japanese Black Pine 207 | 719 Duncan St | 1 | Sidewalk: Curb side : Pot | Tree | Private 2 | 7 | Width 6ft | 6001851.32104 | 2099690.11771 | 37.7454537228095 | -122.436301798912 | (37.7454537228095, -122.436301798912) | 2 | 7 | 5 | 63 | 22 | |||
| 172864 | 233342 | DPW Maintained 1 | Pinus thunbergii :: Japanese Black Pine 207 | 515 Powhattan Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 23 | 6008414.51458 | 2098134.88784 | 37.7415541329249 | -122.413497270696 | (37.7415541329249, -122.413497270696) | 2 | 7 | 7 | 28859 | 2 | ||||
| 172896 | 233348 | DPW Maintained 1 | Pinus thunbergii :: Japanese Black Pine 207 | 500 Grand View Ave | 2 | Front Yard : Yard | Tree | Private 2 | 2 | 5999981.0891 | 2101715.6786 | 37.7509089833601 | -122.442914174867 | (37.7509089833601, -122.442914174867) | 2 | 4 | 5 | 28862 | 22 | ||||
| 173206 | 114216 | Undocumented 4 | Pinus thunbergii :: Japanese Black Pine 207 | 2X ACEVEDO AVE | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 14 | 5987907 | 2090895 | 37.72050244758 | -122.483873669144 | (37.72050244758, -122.483873669144) | 1 | 8 | 4 | 64 | 14 | ||||
| 173239 | 211294 | DPW Maintained 1 | Pinus thunbergii :: Japanese Black Pine 207 | 166 Marston Ave | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | 5998423.33487 | 2093227.80064 | 37.7275143721919 | -122.447690057855 | (37.7275143721919, -122.447690057855) | 9 | 7 | 4 | 28861 | 40 | ||||
| 173927 | 247234 | DPW Maintained 1 | Pinus thunbergii :: Japanese Black Pine 207 | 760 Duboce Ave | 6 | : | Tree | Private 2 | 14 | Width 3ft | 6001984.23869 | 2108361.47681 | 37.7692707347891 | -122.436462711904 | (37.7692707347891, -122.436462711904) | 15 | 5 | 5 | 29492 | 9 | |||
| 173984 | 1342 | DPW Maintained 1 | Pinus thunbergii :: Japanese Black Pine 207 | 175 Amber Dr | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 11 | 3x3 | 5999365.68441 | 2099383.1046 | 37.7444691945119 | -122.444874639375 | (37.7444691945119, -122.444874639375) | 2 | 7 | 5 | 63 | 22 | |||
| 175667 | 218382 | DPW Maintained 1 | Pinus thunbergii :: Japanese Black Pine 207 | 398 Castenada Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 7 | Width 0ft | 5993337.23674 | 2100038.78351 | 37.7459236338716 | -122.465767234987 | (37.7459236338716, -122.465767234987) | 1 | 8 | 4 | 29491 | 40 | |||
| 177378 | 16141 | DPW Maintained 1 | Pinus thunbergii :: Japanese Black Pine 207 | 370 Monterey Blvd | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 7 | CUT | 5999730.64272 | 2094724.12039 | 37.7316975479964 | -122.443278127781 | (37.7316975479964, -122.443278127781) | 9 | 7 | 4 | 63 | 40 | |||
| 178329 | 233341 | DPW Maintained 1 | Pinus thunbergii :: Japanese Black Pine 207 | 181 Elsie St | 2 | Sidewalk: Curb side : Pot | Tree | Private 2 | 13 | 6006970.42421 | 2098142.10929 | 37.7414927703813 | -122.418490966799 | (37.7414927703813, -122.418490966799) | 2 | 7 | 7 | 28859 | 2 | ||||
| 180473 | 211300 | DPW Maintained 1 | Pinus thunbergii :: Japanese Black Pine 207 | 414 Bright St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 8 | Width 10ft | 5993792.16913 | 2089952.0558 | 37.7182541969442 | -122.463462282481 | (37.7182541969442, -122.463462282481) | 9 | 8 | 6 | 64 | 24 |
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) );