trees

2,306 rows where qSpecies_id = 15 sorted by DBH

✎ 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)
34 262408 Property Tree 8 Pinus radiata :: Monterey Pine 15 66X Edgehill Way 1 Unaccepted Street : Yard Tree Private 2       3x3   5994840 2098758 37.7424934921887 -122.46047813267 (37.7424934921887, -122.46047813267) 1 8 4 59 40
63 264975 Significant Tree 6 Pinus radiata :: Monterey Pine 15 445 Ortega St 1 Front Yard : Yard Tree Private 2       10x30   5992686 2102646 37.7530447932571 -122.468208733714 (37.7530447932571, -122.468208733714) 1 8 4 56 12
68 264976 Significant Tree 6 Pinus radiata :: Monterey Pine 15 445 Ortega St 2 Front Yard : Yard Tree Private 2       10x30   5992686 2102646 37.7530447932571 -122.468208733714 (37.7530447932571, -122.468208733714) 1 8 4 56 12
159 117627 Undocumented 4 Pinus radiata :: Monterey Pine 15 890x VERMONT ST 4 Unaccepted Street : Yard Tree Private 2           6011292 2104239 37.7584758425658 -122.403977311201 (37.7584758425658, -122.403977311201) 10 3 8 28856 29
170 108637 Property Tree 8 Pinus radiata :: Monterey Pine 15 15 TUCKER AVE   Back Yard : Yard Tree Private 2           6011049.2 2088423.2 37.7150354478954 -122.403704200211 (37.7150354478954, -122.403704200211) 9 7 8 309 39
228 256437 Undocumented 4 Pinus radiata :: Monterey Pine 15 3001 Sunset Blvd 25 Median : Yard Tree Private 2       10x10   5984960 2094729 37.7308576064943 -122.49434282122 (37.7308576064943, -122.49434282122) 1 8 4 64 35
245 251484 DPW Maintained 1 Pinus radiata :: Monterey Pine 15 900 Bosworth St 7 Front Yard : Yard Tree DPW 1           6001649 2095572 37.7341348351459 -122.436706663072 (37.7341348351459, -122.436706663072) 9 7 5 63 7
256 254254 Significant Tree 6 Pinus radiata :: Monterey Pine 15 45X Everglade Dr 1 Sidewalk: Property side : Yard Tree Private 2       3x3   5986312 2095495 37.7330398702545 -122.489725113139 (37.7330398702545, -122.489725113139) 1 8 4 64 35
342 115652 Property Tree 8 Pinus radiata :: Monterey Pine 15 81x ELSIE ST 18 Back Yard : Cutout Tree DPW 1       3x3   6007403 2098902 37.7436036039275 -122.417049094013 (37.7436036039275, -122.417049094013) 2 7 7 28859 2
390 255918 Property Tree 8 Pinus radiata :: Monterey Pine 15 80 Molimo Dr 1 Back Yard : Yard Tree Private 2       10x10   5998634.42423 2096706.77911 37.7370788872961 -122.447210599537 (37.7370788872961, -122.447210599537) 9 7 4 59 40
451 114938 Undocumented 4 Pinus radiata :: Monterey Pine 15 4400x OCEAN AVE 14 Front Yard : Cutout Tree Private 2       3x3   5985931 2095134 37.7320264068308 -122.491015755892 (37.7320264068308, -122.491015755892) 1 8 4 64 35
483 173928 DPW Maintained 1 Pinus radiata :: Monterey Pine 15 51 Vulcan Stwy 1 Front Yard : Cutout Tree Private 2           6000543 2106304 37.7635394137592 -122.441300222472 (37.7635394137592, -122.441300222472) 15 5 5 28862 3
515 262251 Undocumented 4 Pinus radiata :: Monterey Pine 15 4210 Ocean Ave 4 Sidewalk: Property side : Yard Tree Private 2       3x3   5986512 2095174 37.7321701636719 -122.489010079787 (37.7321701636719, -122.489010079787) 1 8 4 64 35
533 257925 Property Tree 8 Pinus radiata :: Monterey Pine 15 274 Staples Ave   Back Yard : Yard Tree Private 2       10x10   5998272.17919 2093819.44967 37.7291302611298 -122.448255187535 (37.7291302611298, -122.448255187535) 9 7 4 28861 40
628 256542 Property Tree 8 Pinus radiata :: Monterey Pine 15 133 Olympia Way 1 Back Yard : Yard Tree Private 2       3x3   5996852 2101844 37.7510824274474 -122.453744067192 (37.7510824274474, -122.453744067192) 1 5 4 63 38
689 119914 DPW Maintained 1 Pinus radiata :: Monterey Pine 15 400X Brotherhood Way 1 Front Yard : Yard Tree DPW 1       100x100                      
748 259270 Significant Tree 6 Pinus radiata :: Monterey Pine 15 3580X 19th Ave 8 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
844 254210 DPW Maintained 1 Pinus radiata :: Monterey Pine 15 300x Esmeralda Ave 20 Unaccepted Street : Yard Tree DPW 1                              
873 113043 Significant Tree 6 Pinus radiata :: Monterey Pine 15 500 RAYMOND AVE 2 Front Yard : Cutout Tree Private 2   10/06/2015 12:00:00 AM   3x3   6008527 2088690 37.7156268060035 -122.412440877248 (37.7156268060035, -122.412440877248) 9 7 8 309 18
932 111099 Undocumented 4 Pinus radiata :: Monterey Pine 15 480X LAKESHORE DR 20 Median : Cutout Tree DPW 1       30x200   5984942 2095282 37.7323749444343 -122.494445798495 (37.7323749444343, -122.494445798495) 1 8 4 64 35
1038 259268 Significant Tree 6 Pinus radiata :: Monterey Pine 15 3580X 19th Ave 6 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
1176 119263 DPW Maintained 1 Pinus radiata :: Monterey Pine 15 495X Lakeshore Dr 1 Median : Yard Tree DPW 1       10x30                      
1189 261265 Property Tree 8 Pinus radiata :: Monterey Pine 15 1100X Portola Dr 5 Median : Yard Tree DPW 1       10x10   5995262 2098056 37.7405902419398 -122.458968175006 (37.7405902419398, -122.458968175006) 1 7 4 59 40
1523 260685 Undocumented 4 Pinus radiata :: Monterey Pine 15 198X Miraloma Dr 2 Median : Yard Tree Private 2       10x10   5994595 2096392 37.7359829456919 -122.461153801837 (37.7359829456919, -122.461153801837) 9 8 4 59 40
1978 87100 Permitted Site 7 Pinus radiata :: Monterey Pine 15 700 Connecticut St 1 Front Yard : Yard Tree Rec/Park 5       3x3 Permit Number 50056                    
2030 112443 DPW Maintained 1 Pinus radiata :: Monterey Pine 15 2199x 25TH ST 3 Sidewalk: Property side : Yard Tree DPW 1       3x3   6012503 2101856 37.7520002291367 -122.399621792735 (37.7520002291367, -122.399621792735) 10 3 8 28856 29
2059 264900 Property Tree 8 Pinus radiata :: Monterey Pine 15 35X Parkridge Dr 1 Median : Yard Tree Private 2       3x3   5999060 2101975 37.7515684597407 -122.446118026985 (37.7515684597407, -122.446118026985) 2 5 5 63 38
2194 261477 DPW Maintained 1 Pinus radiata :: Monterey Pine 15 1000 Portola Dr 6 Median : Yard Tree DPW 1       10x10   5995664 2098286 37.741244865522 -122.457594860017 (37.741244865522, -122.457594860017) 1 8 4 59 40
2266 87917 Permitted Site 7 Pinus radiata :: Monterey Pine 15 160 Gardenside Dr 2 Sidewalk: Curb side : Cutout Tree Private 2   06/18/2008 12:00:00 AM   3x3 Permit Number 50940 5999367 2102115 37.7519703925615 -122.445066449965 (37.7519703925615, -122.445066449965) 2 5 5 63 38
2352 101748 Significant Tree 6 Pinus radiata :: Monterey Pine 15 700X Panorama Dr 1 Back Yard : Yard Tree Private 2           5997177.2 2102739.1 37.7535587877907 -122.452684092588 (37.7535587877907, -122.452684092588) 1 5 4 63 38
2512 99518 DPW Maintained 1 Pinus radiata :: Monterey Pine 15 1501@Clearfield Sloat Blvd 2 Sidewalk: Property side : Cutout Tree Private 2   05/22/2012 12:00:00 AM     Permit Number 768821 5986536.9 2095861.8 37.7340601352242 -122.488974540344 (37.7340601352242, -122.488974540344) 1 8 4 64 35
2688 253070 DPW Maintained 1 Pinus radiata :: Monterey Pine 15 134 Sagamore St 1 Front Yard : Yard Tree Private 2       Width 0ft Permit Number 780451 5995517 2087474 37.7115492645372 -122.45732113821 (37.7115492645372, -122.45732113821) 9 8 6 28861 24
2713 121088 Significant Tree 6 Pinus radiata :: Monterey Pine 15 1X Grand View Ave 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6000227 2103854 37.7567943109509 -122.442217277848 (37.7567943109509, -122.442217277848) 2 4 5 28862 38
2808 261474 DPW Maintained 1 Pinus radiata :: Monterey Pine 15 1000 Portola Dr 4 Median : Yard Tree DPW 1       10x10   5995664 2098286 37.741244865522 -122.457594860017 (37.741244865522, -122.457594860017) 1 8 4 59 40
3020 260513 Property Tree 8 Pinus radiata :: Monterey Pine 15 1990 41st Ave 1 Back Yard : Yard Tree Health Dept 13       10x10   5983703 2101544 37.7494961014415 -122.499191781388 (37.7494961014415, -122.499191781388) 1 8 3 29491 35
3197 261564 Undocumented 4 Pinus radiata :: Monterey Pine 15 1801 25th St 9 Sidewalk: Property side : Yard Tree DPW 1       3x3   6013134 2101730 37.751689413587 -122.397430852298 (37.751689413587, -122.397430852298) 10 3 8 28856 29
3872 262252 Undocumented 4 Pinus radiata :: Monterey Pine 15 4210 Ocean Ave 5 Sidewalk: Property side : Yard Tree Private 2       3x3   5986512 2095174 37.7321701636719 -122.489010079787 (37.7321701636719, -122.489010079787) 1 8 4 64 35
4239 258982 Property Tree 8 Pinus radiata :: Monterey Pine 15 239 Panorama Dr 1 Back Yard : Yard Tree Private 2       3x3   5997275 2101153 37.7492093542443 -122.452231443092 (37.7492093542443, -122.452231443092) 1 5 4 63 38
4737 261021 Significant Tree 6 Pinus radiata :: Monterey Pine 15 3440X 19th Ave 2 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
4884 260462 Private 9 Pinus radiata :: Monterey Pine 15 119 Moffitt St 1 Back Yard : Yard Tree Private 2       3x3   6002736 2096650 37.7371564911538 -122.433025558613 (37.7371564911538, -122.433025558613) 2 7 5 63 7
4918 104883 Undocumented 4 Pinus radiata :: Monterey Pine 15 132 Gonzalez Dr 1 Sidewalk: Curb side : Yard Tree Private 2           5990322.1 2090011.1 37.7182157760013 -122.475461023549 (37.7182157760013, -122.475461023549) 1 8 4 64 14
5017 262484 Undocumented 4 Pinus radiata :: Monterey Pine 15 10X Alpha St 2 Median : Yard Tree Private 2       3x3   6011300 2088596 37.7155239289484 -122.402849469545 (37.7155239289484, -122.402849469545) 9 7 8 309 39
5205 261497 DPW Maintained 1 Pinus radiata :: Monterey Pine 15 1200X Portola Dr 4 Median : Yard Tree Private 2       10x10   5994638 2097987 37.7403648954334 -122.46112071093 (37.7403648954334, -122.46112071093) 1 8 4 59 40
5279 258778 Undocumented 4 Pinus radiata :: Monterey Pine 15 701X Ortega Way 1 Unaccepted Street : Yard Tree Private 2       10x10   5991876 2102480 37.7525421857889 -122.470997752755 (37.7525421857889, -122.470997752755) 1 8 4 29491 12
5304 261473 DPW Maintained 1 Pinus radiata :: Monterey Pine 15 1000 Portola Dr 3 Median : Yard Tree DPW 1       10x10   5995664 2098286 37.741244865522 -122.457594860017 (37.741244865522, -122.457594860017) 1 8 4 59 40
5888 261561 DPW Maintained 1 Pinus radiata :: Monterey Pine 15 1801 25th St 6 Sidewalk: Property side : Yard Tree DPW 1       3x3   6013134 2101730 37.751689413587 -122.397430852298 (37.751689413587, -122.397430852298) 10 3 8 28856 29
5905 261162 Significant Tree 6 Pinus radiata :: Monterey Pine 15 595 Newhall St 1 Sidewalk: Property side : Cutout Tree DPW 1 Private     3x3   6016024 2097656 37.7406635379999 -122.387152626875 (37.7406635379999, -122.387152626875) 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
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
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
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
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
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
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
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
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
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
8781 94862 Permitted Site 7 Pinus radiata :: Monterey Pine 15   2 Sidewalk: Curb side : Cutout Tree Private 2       3x3 Permit Number 53932                    
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
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
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
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                    
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
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
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
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
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                              
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
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
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
12659 122532 DPW Maintained 1 Pinus radiata :: Monterey Pine 15 1900X Castro St 1 Unaccepted Street : Yard Tree Private 2                              
12948 258070 DPW Maintained 1 Pinus radiata :: Monterey Pine 15 1X Selma Way 1 Unaccepted Street : Yard Tree Private 2       6x10   5992537 2103375 37.7550378314458 -122.468777042949 (37.7550378314458, -122.468777042949) 1 8 4 56 12
13075 261490 Property Tree 8 Pinus radiata :: Monterey Pine 15 1100X Portola Dr 4 Median : Yard Tree DPW 1       10x10   5995262 2098056 37.7405902419398 -122.458968175006 (37.7405902419398, -122.458968175006) 1 7 4 59 40
13422 261500 DPW Maintained 1 Pinus radiata :: Monterey Pine 15 1200X Portola Dr 7 Median : Yard Tree Private 2       10x10   5994638 2097987 37.7403648954334 -122.46112071093 (37.7403648954334, -122.46112071093) 1 8 4 59 40
13472 259334 DPW Maintained 1 Pinus radiata :: Monterey Pine 15 179X Midcrest Way 1 Front Yard : Yard Tree DPW 1       30x30   5998457 2101296 37.7496696385244 -122.448154381331 (37.7496696385244, -122.448154381331) 1 5 4 63 38
13614 258670 Property Tree 8 Pinus radiata :: Monterey Pine 15 152 Kensington Way   Front Yard : Yard Tree Private 2       3x3   5994743 2098651 37.7421941161526 -122.460805774677 (37.7421941161526, -122.460805774677) 1 8 4 59 40
13721 261493 DPW Maintained 1 Pinus radiata :: Monterey Pine 15 1100X Portola Dr 9 Sidewalk: Property side : Yard Tree DPW 1       10x10   5995262 2098056 37.7405902419398 -122.458968175006 (37.7405902419398, -122.458968175006) 1 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)
);