trees

2,306 rows where qSpecies_id = 15

✎ View and edit SQL

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)
5980 113539 DPW Maintained 1 Pinus radiata :: Monterey Pine 15 100X CASHMERE ST 2 Median : Yard Tree DPW 1     20     6017054 2095889 37.7358686950692 -122.383468266853 (37.7358686950692, -122.383468266853) 10 3 8 58 1
6044 259265 Significant Tree 6 Pinus radiata :: Monterey Pine 15 3580X 19th Ave 3 Sidewalk: Property side : Yard Tree Private 2       3x3 Permit Number 784388 5990529 2092111 37.723993571379 -122.474899060099 (37.723993571379, -122.474899060099) 9 8 4 64 14
6109 20338 DPW Maintained 1 Pinus radiata :: Monterey Pine 15 101X Sunset Blvd 25 Sidewalk: Curb side : Cutout Tree DPW 1     48 40                      
6239 261665 DPW Maintained 1 Pinus radiata :: Monterey Pine 15 401X Greenwich St 1 Unaccepted Street : Cutout Tree DPW 1                              
6296 260461 Significant Tree 6 Pinus radiata :: Monterey Pine 15 99X Lopez Ave 4 Front Yard : Yard Tree Private 2       10x10 Permit Number 784513 5994049 2100330 37.746764271907 -122.463327202712 (37.746764271907, -122.463327202712) 1 8 4 29491 40
6334 104866 Significant Tree 6 Pinus radiata :: Monterey Pine 15 411 Holladay Ave 1 Front Yard : Yard Tree Private 2           6010309.7 2098610.5 37.7429662928376 -122.406977848202 (37.7429662928376, -122.406977848202) 10 7 7 28859 2
6400 181372 DPW Maintained 1 Pinus radiata :: Monterey Pine 15 1500 Sunset Blvd 5 Sidewalk: Property side : Yard Tree Private 2     8 Width 0ft   5984899.4843 2104416.3495 37.757452898982 -122.495266162351 (37.757452898982, -122.495266162351) 1 8 3 56 35
6415 20399 DPW Maintained 1 Pinus radiata :: Monterey Pine 15 262X Sunset Blvd 44 Sidewalk: Curb side : Cutout Tree DPW 1     42 60                      
6472 178231 DPW Maintained 1 Pinus radiata :: Monterey Pine 15 1569 Sunnydale Ave 2 Sidewalk: Property side : Yard Tree Private 2     42 Width 10ft   6007162.15174 2087448.53527 37.7121413161324 -122.417070510095 (37.7121413161324, -122.417070510095) 9 7 8 309 39
6519 251515 Significant Tree 6 Pinus radiata :: Monterey Pine 15 99x Mountview Ct 1 Back Yard : Yard Tree Private 2       3x3   5997620 2100449 37.7472961010623 -122.450987675073 (37.7472961010623, -122.450987675073) 1 5 4 63 38
6524 184984 DPW Maintained 1 Pinus radiata :: Monterey Pine 15 2701 Sunset Blvd 10 Sidewalk: Property side : Yard Tree Private 2     42 Width 0ft   5984993.7475 2096669.1749 37.736186785639 -122.494369113809 (37.736186785639, -122.494369113809) 1 8 3 29491 35
6528 20289 DPW Maintained 1 Pinus radiata :: Monterey Pine 15 20X Sunset Blvd 10 Sidewalk: Curb side : Cutout Tree DPW 1     42 60                      
6585 260539 Property Tree 8 Pinus radiata :: Monterey Pine 15 1230 Twin Peaks Blvd 1 Back Yard : Yard Tree Private 2       3x3   5997905 2100119 37.7464063138276 -122.449978390477 (37.7464063138276, -122.449978390477) 2 5 4 63 38
6606 178232 DPW Maintained 1 Pinus radiata :: Monterey Pine 15 1501 Sunnydale Ave 1 Sidewalk: Property side : Yard Tree Private 2     52 Width 10ft   6007195.0497 2087434.83618 37.712105551909 -122.41695583486 (37.712105551909, -122.41695583486) 9 7 8 309 39
6752 20418 DPW Maintained 1 Pinus radiata :: Monterey Pine 15 453X Sunset Blvd 7 Sidewalk: Curb side : Cutout Tree DPW 1     12 60                      
6758 95372 Significant Tree 6 Pinus radiata :: Monterey Pine 15 180 Yukon St   Back Yard : Cutout Tree Private 2     15   Permit Number 767755 6000174.3 2103956.9 37.7570738455347 -122.442406920559 (37.7570738455347, -122.442406920559) 2 4 5 28862 3
6814 259576 DPW Maintained 1 Pinus radiata :: Monterey Pine 15 300 Public Park 2 Unaccepted Street : Cutout Tree Private 2       4x4   5994278 2098760 37.7424666368704 -122.462421492412 (37.7424666368704, -122.462421492412) 1 8 4 59 40
6919 178219 DPW Maintained 1 Pinus radiata :: Monterey Pine 15 49 Santos St 1 Sidewalk: Property side : Yard Tree Private 2     44 Width 6ft   6006726.5178 2087416.33462 37.7120283837799 -122.418573909455 (37.7120283837799, -122.418573909455) 9 7 8 309 39
6923 186737 DPW Maintained 1 Pinus radiata :: Monterey Pine 15 1200 Sunset Blvd 3 Sidewalk: Property side : Yard Tree Private 2     10 Width 0ft   5984866.449 2106593.1371 37.7634278157856 -122.495540957795 (37.7634278157856, -122.495540957795) 1 8 3 56 35
6936 261840 DPW Maintained 1 Pinus radiata :: Monterey Pine 15 1100X Portola Dr 10 Sidewalk: Property side : Yard Tree DPW 1       10x10   5995262 2098056 37.7405902419398 -122.458968175006 (37.7405902419398, -122.458968175006) 1 7 4 59 40
6943 262154 Property Tree 8 Pinus radiata :: Monterey Pine 15 519 22nd Ave 1 Back Yard : Yard Tree Private 2       3x3   5989039 2111772 37.7778909946523 -122.481488924787 (37.7778909946523, -122.481488924787) 11 6 2 55 26
6984 20069 DPW Maintained 1 Pinus radiata :: Monterey Pine 15 100 STAIRWAY55 2 Sidewalk: Curb side : Cutout Tree DPW 1     36 40ST                      
7000 251607 Significant Tree 6 Pinus radiata :: Monterey Pine 15 52 Amber Dr 2 Back Yard : Yard Tree Private 2           5999455 2100046 37.7462944425817 -122.444613441074 (37.7462944425817, -122.444613441074) 2 7 5 63 22
7026 121414 Significant Tree 6 Pinus radiata :: Monterey Pine 15 150 Raccoon Dr 1 Back Yard : Cutout Tree Private 2     36 3x3   5998776 2103987 37.7570766935068 -122.447244922317 (37.7570766935068, -122.447244922317) 15 5 5 63 3
7041 20329 DPW Maintained 1 Pinus radiata :: Monterey Pine 15 101X Sunset Blvd 17 Sidewalk: Curb side : Cutout Tree DPW 1     42 60                      
7152 261481 DPW Maintained 1 Pinus radiata :: Monterey Pine 15 1000 Portola Dr 10 Median : Yard Tree DPW 1       10x10   5995664 2098286 37.741244865522 -122.457594860017 (37.741244865522, -122.457594860017) 1 8 4 59 40
7194 117622 Undocumented 4 Pinus radiata :: Monterey Pine 15 890x VERMONT ST 1 Front Yard : Yard Tree Rec/Park 5           6011292 2104239 37.7584758425658 -122.403977311201 (37.7584758425658, -122.403977311201) 10 3 8 28856 29
7196 251612 Significant Tree 6 Pinus radiata :: Monterey Pine 15 60R Amber Dr 1 Back Yard : Yard Tree Private 2           5999394 2100048 37.7462964530913 -122.444824514752 (37.7462964530913, -122.444824514752) 2 7 5 63 22
7330 20367 DPW Maintained 1 Pinus radiata :: Monterey Pine 15 262X Sunset Blvd 17 Sidewalk: Curb side : Cutout Tree DPW 1     42 60                      
7403 20408 DPW Maintained 1 Pinus radiata :: Monterey Pine 15 262X Sunset Blvd 53 Sidewalk: Curb side : Cutout Tree DPW 1     12 60                      
7420 20458 DPW Maintained 1 Pinus radiata :: Monterey Pine 15 495X Sunset Blvd 23 Sidewalk: Curb side : Cutout Tree DPW 1     42 60                      
7631 256540 Significant Tree 6 Pinus radiata :: Monterey Pine 15 379X Cresta Vista Dr 2 Sidewalk: Curb side : Cutout Tree Private 2       3x3   5997117 2096261 37.7357680647268 -122.452424833384 (37.7357680647268, -122.452424833384) 9 7 4 59 40
7693 4980 DPW Maintained 1 Pinus radiata :: Monterey Pine 15 5200X Diamond Heights Blvd 16 Median : Cutout Tree DPW 1     36 12   6000724.3855206 2099633.2111664 37.7452333754909 -122.440194472866 (37.7452333754909, -122.440194472866) 2 7 5 63 7
8084 20421 DPW Maintained 1 Pinus radiata :: Monterey Pine 15 453X Sunset Blvd 10 Sidewalk: Curb side : Cutout Tree DPW 1     12 60                      
8135 20290 DPW Maintained 1 Pinus radiata :: Monterey Pine 15 20X Sunset Blvd 11 Sidewalk: Curb side : Cutout Tree DPW 1     42 60                      
8163 82435 Significant Tree 6 Pinus radiata :: Monterey Pine 15 51 Peralta Ave 1 Front Yard : Yard Tree Private 2   04/02/2005 12:00:00 AM 20     6010636.52703341 2100363.58782589 37.7477981742678 -122.405971235802 (37.7477981742678, -122.405971235802) 2 7 7 28859 2
8237 260684 Undocumented 4 Pinus radiata :: Monterey Pine 15 198X Miraloma Dr 1 Median : Yard Tree Private 2       10x10   5994595 2096392 37.7359829456919 -122.461153801837 (37.7359829456919, -122.461153801837) 9 8 4 59 40
8368 173917 DPW Maintained 1 Pinus radiata :: Monterey Pine 15 2160X 09th Ave 5 Median : Cutout Tree DPW 1       6x10   5993671 2100995 37.7485684085064 -122.464682560698 (37.7485684085064, -122.464682560698) 1 8 4 29491 40
8370 264916 DPW Maintained 1 Pinus radiata :: Monterey Pine 15 744 Junipero Serra Blvd 1 Median : Yard Tree Private 2       10x10   5991301 2092678 37.7255951208098 -122.472271716 (37.7255951208098, -122.472271716) 9 8 4 64 40
8513 112444 DPW Maintained 1 Pinus radiata :: Monterey Pine 15 2199x 25TH ST 4 Sidewalk: Property side : Yard Tree DPW 1       3x3   6012503 2101856 37.7520002291367 -122.399621792735 (37.7520002291367, -122.399621792735) 10 3 8 28856 29
8543 20492 DPW Maintained 1 Pinus radiata :: Monterey Pine 15 1204 Sunset Blvd 13 Sidewalk: Curb side : Cutout Tree Rec/Park 5     6 40   5984687.7602675 2107238.1673169 37.7651884221731 -122.496206568741 (37.7651884221731, -122.496206568741) 11 6 2 55 8
8603 185680 DPW Maintained 1 Pinus radiata :: Monterey Pine 15 2101 Sunset Blvd 12 Sidewalk: Property side : Yard Tree Private 2   08/21/2020 12:00:00 AM 3 Width 0ft Permit Number 785560 5984864.6841 2100703.8022 37.7472572283713 -122.495112755215 (37.7472572283713, -122.495112755215) 1 8 3 29491 35
8660 20402 DPW Maintained 1 Pinus radiata :: Monterey Pine 15 262X Sunset Blvd 47 Sidewalk: Curb side : Cutout Tree DPW 1     48 60                      
8757 20337 DPW Maintained 1 Pinus radiata :: Monterey Pine 15 101X Sunset Blvd 24 Sidewalk: Curb side : Cutout Tree DPW 1     48 40                      
8774 186010 DPW Maintained 1 Pinus radiata :: Monterey Pine 15 1900 Sunset Blvd 5 Sidewalk: Property side : Yard Tree Private 2     1 Width 0ft   5985033.6672 2101672.0069 37.749925545641 -122.494599798949 (37.749925545641, -122.494599798949) 1 8 3 29491 35
8781 94862 Permitted Site 7 Pinus radiata :: Monterey Pine 15   2 Sidewalk: Curb side : Cutout Tree Private 2       3x3 Permit Number 53932                    
8847 110165 Undocumented 4 Pinus radiata :: Monterey Pine 15 129x GARCES DR 1 Front Yard : Yard Tree Private 2     23     5989202 2088902 37.7151054701837 -122.479251597893 (37.7151054701837, -122.479251597893) 1 8 4 64 14
8965 261020 Significant Tree 6 Pinus radiata :: Monterey Pine 15 3440X 19th Ave 1 Back Yard : Yard Tree Private 2       10x10 Permit Number 784857 5990714 2092679 37.7255638768787 -122.474300978757 (37.7255638768787, -122.474300978757) 9 8 4 64 40
9020 261496 DPW Maintained 1 Pinus radiata :: Monterey Pine 15 1200X Portola Dr 3 Median : Yard Tree Private 2       10x10   5994638 2097987 37.7403648954334 -122.46112071093 (37.7403648954334, -122.46112071093) 1 8 4 59 40
9033 254440 DPW Maintained 1 Pinus radiata :: Monterey Pine 15 501X Brotherhood Way 20 Median : Yard Tree DPW 1       10x10   5992686 2087818 37.7123307991194 -122.467130733446 (37.7123307991194, -122.467130733446) 9 8 4 64 24
9066 260960 Significant Tree 6 Pinus radiata :: Monterey Pine 15 1001 Potrero Ave 2 Sidewalk: Curb side : Cutout Tree DPW 1       3x3   6010509 2103658 37.7568367689384 -122.406644345083 (37.7568367689384, -122.406644345083) 10 4 8 28859 19
9087 20433 DPW Maintained 1 Pinus radiata :: Monterey Pine 15 485X Sunset Blvd 6 Sidewalk: Curb side : Cutout Tree DPW 1     6 30                      
9165 20427 DPW Maintained 1 Pinus radiata :: Monterey Pine 15 453X Sunset Blvd 16 Sidewalk: Curb side : Cutout Tree DPW 1     12 60                      
9254 87113 Permitted Site 7 Pinus radiata :: Monterey Pine 15 470 West Portal Ave 4 unknown : Yard Tree Private 2   01/03/2008 12:00:00 AM     Permit Number 50062 5991694 2096460 37.7360022829337 -122.471188578306 (37.7360022829337, -122.471188578306) 1 8 4 29491 40
9285 20285 DPW Maintained 1 Pinus radiata :: Monterey Pine 15 20X Sunset Blvd 6 Sidewalk: Curb side : Cutout Tree DPW 1     12 60                      
9341 20735 DPW Maintained 1 Pinus radiata :: Monterey Pine 15 1601X Sunset Blvd 22 Sidewalk: Curb side : Cutout Tree DPW 1     3 60   5984865.3499442 2104298.7792234 37.7571280850658 -122.495375540207 (37.7571280850658, -122.495375540207) 1 8 3 56 35
9368 20394 DPW Maintained 1 Pinus radiata :: Monterey Pine 15 262X Sunset Blvd 39 Sidewalk: Curb side : Cutout Tree DPW 1     36 60                      
9482 185678 DPW Maintained 1 Pinus radiata :: Monterey Pine 15 2101 Sunset Blvd 10 Sidewalk: Property side : Yard Tree Private 2     14 Width 0ft   5984885.606 2100736.1658 37.7473473148238 -122.495042795968 (37.7473473148238, -122.495042795968) 1 8 3 29491 35
9602 98360 Permitted Site 7 Pinus radiata :: Monterey Pine 15 807 Francisco St 1 Sidewalk: Curb side : Yard Tree Private 2         Permit Number 768654 6007370.5 2120864.5 37.8039055703948 -122.418718664572 (37.8039055703948, -122.418718664572) 5 1 1 28858 32
9667 20951 DPW Maintained 1 Pinus radiata :: Monterey Pine 15 1992X Sunset Blvd 28 Sidewalk: Curb side : Cutout Tree DPW 1     48 60   5984875.9454268 2101638.8759791 37.7498253446275 -122.495142757654 (37.7498253446275, -122.495142757654) 1 8 3 29491 35
9803 262258 Undocumented 4 Pinus radiata :: Monterey Pine 15 2 Everglade Dr 2 Sidewalk: Property side : Yard Tree Private 2       3x3   5986312 2095495 37.7330398702545 -122.489725113139 (37.7330398702545, -122.489725113139) 1 8 4 64 35
9819 261478 DPW Maintained 1 Pinus radiata :: Monterey Pine 15 1000 Portola Dr 7 Median : Yard Tree DPW 1       10x10   5995664 2098286 37.741244865522 -122.457594860017 (37.741244865522, -122.457594860017) 1 8 4 59 40
9862 114526 Significant Tree 6 Pinus radiata :: Monterey Pine 15 1 TIOGA AVE 2 Sidewalk: Curb side : Yard Tree Private 2           6011351 2088602 37.7155432513192 -122.402673611341 (37.7155432513192, -122.402673611341) 9 7 8 309 39
9966 251172 Significant Tree 6 Pinus radiata :: Monterey Pine 15 363 Jersey St 2 Front Yard : Yard Tree Private 2           6002784.74363 2101501.25508 37.750479672211 -122.433203561601 (37.750479672211, -122.433203561601) 2 4 5 28862 22
10032 254212 DPW Maintained 1 Pinus radiata :: Monterey Pine 15 81X Elsie St 10 Back Yard : Yard Tree DPW 1                              
10108 94859 Permitted Site 7 Pinus radiata :: Monterey Pine 15   1 Sidewalk: Curb side : Cutout Tree Private 2       3x3 Permit Number 53932                    
10141 211242 DPW Maintained 1 Pinus radiata :: Monterey Pine 15 50x Santa Rita Ave 16 Median : Cutout Tree DPW 1     16 Width 5ft   5993561.81952 2100384.28411 37.7468852429767 -122.465015753384 (37.7468852429767, -122.465015753384) 1 8 4 29491 40
10142 20420 DPW Maintained 1 Pinus radiata :: Monterey Pine 15 453X Sunset Blvd 9 Sidewalk: Curb side : Cutout Tree DPW 1     12 60                      
10159 262253 Undocumented 4 Pinus radiata :: Monterey Pine 15 4210 Ocean Ave 6 Sidewalk: Property side : Yard Tree Private 2       3x3   5986512 2095174 37.7321701636719 -122.489010079787 (37.7321701636719, -122.489010079787) 1 8 4 64 35
10322 181388 DPW Maintained 1 Pinus radiata :: Monterey Pine 15 1500 Sunset Blvd 21 Sidewalk: Property side : Yard Tree Private 2     46 Width 0ft   5984923.155 2104529.1337 37.757763958937 -122.495192617725 (37.757763958937, -122.495192617725) 1 8 3 56 35
10407 260077 DPW Maintained 1 Pinus radiata :: Monterey Pine 15 167X Burlwood Dr 1 Sidewalk: Property side : Yard Tree Private 2       3x3   5997137 2096182 37.7355522955825 -122.452349987086 (37.7355522955825, -122.452349987086) 9 7 4 59 40
10428 4975 DPW Maintained 1 Pinus radiata :: Monterey Pine 15 5200X Diamond Heights Blvd 11 Median : Cutout Tree DPW 1     12 12   6000932.35718 2099423.5316 37.744669483426 -122.439460315968 (37.744669483426, -122.439460315968) 2 7 5 63 7
10560 178279 DPW Maintained 1 Pinus radiata :: Monterey Pine 15 900 Brotherhood Way 6 Front Yard : Yard Tree DPW 1     4 Width 0ft   5987917.15522 2088760.91322 37.7146433748779 -122.483682180705 (37.7146433748779, -122.483682180705) 1 8 4 64 14
10595 262051 DPW Maintained 1 Pinus radiata :: Monterey Pine 15 851X Alemany Blvd 2 Side Yard : Yard Tree DPW 1       3x3   6004188 2094500 37.7313353304363 -122.42785218062 (37.7313353304363, -122.42785218062) 9 7 6 28861 5
10790 261495 DPW Maintained 1 Pinus radiata :: Monterey Pine 15 1200X Portola Dr 2 Median : Yard Tree Private 2       10x10   5994638 2097987 37.7403648954334 -122.46112071093 (37.7403648954334, -122.46112071093) 1 8 4 59 40
10808 262250 Undocumented 4 Pinus radiata :: Monterey Pine 15 4210 Ocean Ave 3 Sidewalk: Property side : Yard Tree Private 2       3x3   5986512 2095174 37.7321701636719 -122.489010079787 (37.7321701636719, -122.489010079787) 1 8 4 64 35
10821 4986 DPW Maintained 1 Pinus radiata :: Monterey Pine 15 5300 Diamond Heights Blvd 3 Median : Cutout Tree DPW 1     12     6001419.5409281 2098992.5811716 37.7435139095193 -122.437744874344 (37.7435139095193, -122.437744874344) 2 7 5 63 7
11046 262155 DPW Maintained 1 Pinus radiata :: Monterey Pine 15 1800 25th St 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6013141 2101984 37.752387232625 -122.397424456513 (37.752387232625, -122.397424456513) 10 3 8 28856 29
11182 261019 Significant Tree 6 Pinus radiata :: Monterey Pine 15 3450X 19th Ave 1 Back Yard : Yard Tree Private 2       10x10 Permit Number 784867 5990575 2092822 37.725948465298 -122.47479191789 (37.725948465298, -122.47479191789) 9 8 4 64 14
11212 20461 DPW Maintained 1 Pinus radiata :: Monterey Pine 15 495X Sunset Blvd 26 Sidewalk: Curb side : Cutout Tree DPW 1     6 60                      
11223 211225 DPW Maintained 1 Pinus radiata :: Monterey Pine 15 2270x 09th Ave 2 Median : Cutout Tree DPW 1     21 Width 3ft   5993181.98406 2100575.01172 37.7473870233022 -122.466343037597 (37.7473870233022, -122.466343037597) 1 8 4 29491 40
11277 186143 DPW Maintained 1 Pinus radiata :: Monterey Pine 15 1700 Sunset Blvd 28 Sidewalk: Property side : Yard Tree Private 2     3 Width 0ft   5984952.2085 2103240.0556 37.7542262082521 -122.494997090381 (37.7542262082521, -122.494997090381) 1 8 3 56 35
11436 20292 DPW Maintained 1 Pinus radiata :: Monterey Pine 15 20X Sunset Blvd 13 Sidewalk: Curb side : Cutout Tree DPW 1     36 60                      
11490 20283 DPW Maintained 1 Pinus radiata :: Monterey Pine 15 20X Sunset Blvd 4 Sidewalk: Curb side : Cutout Tree DPW 1     36 60                      
11544 20435 DPW Maintained 1 Pinus radiata :: Monterey Pine 15 485X Sunset Blvd 8 Sidewalk: Curb side : Cutout Tree DPW 1     6 30                      
11693 261491 DPW Maintained 1 Pinus radiata :: Monterey Pine 15 1100X Portola Dr 7 Sidewalk: Property side : Yard Tree DPW 1       10x10   5995262 2098056 37.7405902419398 -122.458968175006 (37.7405902419398, -122.458968175006) 1 7 4 59 40
11775 173632 DPW Maintained 1 Pinus radiata :: Monterey Pine 15 3300X Market St 1 Side Yard : Yard Tree Private 2                              
11791 20943 DPW Maintained 1 Pinus radiata :: Monterey Pine 15 1992X Sunset Blvd 19 Median : Cutout Tree DPW 1     6 60   5984875.9454268 2101638.8759791 37.7498253446275 -122.495142757654 (37.7498253446275, -122.495142757654) 1 8 3 29491 35
11825 264757 DPW Maintained 1 Pinus radiata :: Monterey Pine 15 176 Hahn St 1 Sidewalk: Curb side : Cutout Tree DPW 1       3x3   6007577 2087516 37.7123498887131 -122.4156414431 (37.7123498887131, -122.4156414431) 9 7 8 309 39
11834 261266 DPW Maintained 1 Pinus radiata :: Monterey Pine 15 1100X Portola Dr 6 Sidewalk: Property side : Yard Tree DPW 1       10x10   5995262 2098056 37.7405902419398 -122.458968175006 (37.7405902419398, -122.458968175006) 1 7 4 59 40
11878 104919 Undocumented 4 Pinus radiata :: Monterey Pine 15 732 Gonzalez Dr 1 Sidewalk: Curb side : Yard Tree Private 2           5990421 2090607 37.719857702396 -122.475162650507 (37.719857702396, -122.475162650507) 1 8 4 64 40
11955 20344 DPW Maintained 1 Pinus radiata :: Monterey Pine 15 101X Sunset Blvd 30 Sidewalk: Curb side : Cutout Tree DPW 1     24 40                      
11962 19853 DPW Maintained 1 Pinus radiata :: Monterey Pine 15 100 STAIRWAY29 3 Sidewalk: Curb side : Cutout Tree DPW 1     12 100ST                      
11983 247089 DPW Maintained 1 Pinus radiata :: Monterey Pine 15 2301 Castro St 7 Front Yard : Yard Tree Private 2     1     6002763.93739 2098596.7389 37.7425033709224 -122.433068014888 (37.7425033709224, -122.433068014888) 2 7 5 63 22
11998 20308 DPW Maintained 1 Pinus radiata :: Monterey Pine 15 50X Sunset Blvd 10 Sidewalk: Curb side : Cutout Tree DPW 1     48 60                      
12060 101900 Property Tree 8 Pinus radiata :: Monterey Pine 15 1100 Ocean Ave 1 Front Yard : Yard Tree DPW 1         Permit Number 769623 5996507.7 2092470.2 37.7253245106519 -122.454257683967 (37.7253245106519, -122.454257683967) 9 7 4 28861 40
12112 20431 DPW Maintained 1 Pinus radiata :: Monterey Pine 15 485X Sunset Blvd 4 Sidewalk: Curb side : Cutout Tree DPW 1     36 30                      
12163 21077 DPW Maintained 1 Pinus radiata :: Monterey Pine 15 2192X Sunset Blvd 13 Sidewalk: Curb side : Cutout Tree DPW 1     42 60   5984923.321673 2100279.0596028 37.7460944336033 -122.494878681905 (37.7460944336033, -122.494878681905) 1 8 3 29491 35
12253 261479 DPW Maintained 1 Pinus radiata :: Monterey Pine 15 1000 Portola Dr 8 Median : Yard Tree DPW 1       10x10   5995664 2098286 37.741244865522 -122.457594860017 (37.741244865522, -122.457594860017) 1 8 4 59 40
12289 254085 Significant Tree 6 Pinus radiata :: Monterey Pine 15 411 Lansdale Ave 1 Front Yard : Cutout Tree Private 2       6x6   5995707 2096451 37.7362088759349 -122.457313463895 (37.7362088759349, -122.457313463895) 9 7 4 59 40

Next page

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options: 

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)
);