trees

2,306 rows where qSpecies_id = 15 sorted by qCaretaker_id descending

✎ 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)
4148 111380 Undocumented 4 Pinus radiata :: Monterey Pine 15 301x OCEAN AVE 2 Sidewalk: Property side : Cutout Tree DPW for City Agency 14 MTA   24 3x3   5999454 2091552 37.7229718629586 -122.44400669589 (37.7229718629586, -122.44400669589) 9 7 6 28861 25
119304 111381 Undocumented 4 Pinus radiata :: Monterey Pine 15 301x OCEAN AVE 3 Sidewalk: Property side : Cutout Tree DPW for City Agency 14 MTA   24 3x3   5999454 2091552 37.7229718629586 -122.44400669589 (37.7229718629586, -122.44400669589) 9 7 6 28861 25
128716 108973 Property Tree 8 Pinus radiata :: Monterey Pine 15 3485X SAN BRUNO AVE 1 Median : Yard Tree DPW for City Agency 14           6011510 2091910 37.724635221414 -122.402356490066 (37.724635221414, -122.402356490066) 10 3 7 309 28
168033 111379 Undocumented 4 Pinus radiata :: Monterey Pine 15 301x OCEAN AVE 1 Sidewalk: Property side : Cutout Tree DPW for City Agency 14 MTA   24 3x3   5999454 2091552 37.7229718629586 -122.44400669589 (37.7229718629586, -122.44400669589) 9 7 6 28861 25
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
39088 255806 Undocumented 4 Pinus radiata :: Monterey Pine 15 255X Evelyn Way 1 Median : Yard Tree PUC 8       10x10   5998108 2098711 37.742551901709 -122.449175024155 (37.742551901709, -122.449175024155) 9 7 4 59 40
53415 254271 Property Tree 8 Pinus radiata :: Monterey Pine 15 1201X Junipero Serra Blvd 1 Side Yard : Yard Tree PUC 8       10x10   5991180 2089593 37.717117469349 -122.472465193375 (37.717117469349, -122.472465193375) 9 8 6 64 24
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                    
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
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
20532 20482 DPW Maintained 1 Pinus radiata :: Monterey Pine 15 1204 Sunset Blvd 3 Sidewalk: Curb side : Cutout Tree Rec/Park 5     42 40   5984687.7602675 2107238.1673169 37.7651884221731 -122.496206568741 (37.7651884221731, -122.496206568741) 11 6 2 55 8
31421 20481 DPW Maintained 1 Pinus radiata :: Monterey Pine 15 1204 Sunset Blvd 2 Sidewalk: Curb side : Cutout Tree Rec/Park 5     48 40   5984687.7602675 2107238.1673169 37.7651884221731 -122.496206568741 (37.7651884221731, -122.496206568741) 11 6 2 55 8
37487 20499 DPW Maintained 1 Pinus radiata :: Monterey Pine 15 1204 Sunset Blvd 20 Sidewalk: Curb side : Cutout Tree Rec/Park 5     48 40   5984687.7602675 2107238.1673169 37.7651884221731 -122.496206568741 (37.7651884221731, -122.496206568741) 11 6 2 55 8
59197 20485 DPW Maintained 1 Pinus radiata :: Monterey Pine 15 1204 Sunset Blvd 6 Sidewalk: Curb side : Cutout Tree Rec/Park 5     36 40   5984687.7602675 2107238.1673169 37.7651884221731 -122.496206568741 (37.7651884221731, -122.496206568741) 11 6 2 55 8
81798 20491 DPW Maintained 1 Pinus radiata :: Monterey Pine 15 1204 Sunset Blvd 12 Sidewalk: Curb side : Cutout Tree Rec/Park 5     36 40   5984687.7602675 2107238.1673169 37.7651884221731 -122.496206568741 (37.7651884221731, -122.496206568741) 11 6 2 55 8
100926 20493 DPW Maintained 1 Pinus radiata :: Monterey Pine 15 1204 Sunset Blvd 14 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
108106 20487 DPW Maintained 1 Pinus radiata :: Monterey Pine 15 1204 Sunset Blvd 8 Sidewalk: Curb side : Cutout Tree Rec/Park 5     12 40   5984687.7602675 2107238.1673169 37.7651884221731 -122.496206568741 (37.7651884221731, -122.496206568741) 11 6 2 55 8
109804 20484 DPW Maintained 1 Pinus radiata :: Monterey Pine 15 1204 Sunset Blvd 5 Sidewalk: Curb side : Cutout Tree Rec/Park 5     36 40   5984687.7602675 2107238.1673169 37.7651884221731 -122.496206568741 (37.7651884221731, -122.496206568741) 11 6 2 55 8
109835 20502 DPW Maintained 1 Pinus radiata :: Monterey Pine 15 1204 Sunset Blvd 23 Sidewalk: Curb side : Cutout Tree Rec/Park 5     18 40   5984687.7602675 2107238.1673169 37.7651884221731 -122.496206568741 (37.7651884221731, -122.496206568741) 11 6 2 55 8
115552 20498 DPW Maintained 1 Pinus radiata :: Monterey Pine 15 1204 Sunset Blvd 19 Sidewalk: Curb side : Cutout Tree Rec/Park 5     48 40   5984687.7602675 2107238.1673169 37.7651884221731 -122.496206568741 (37.7651884221731, -122.496206568741) 11 6 2 55 8
126801 20480 DPW Maintained 1 Pinus radiata :: Monterey Pine 15 1204 Sunset Blvd 1 Sidewalk: Curb side : Cutout Tree Rec/Park 5     48 40   5984687.7602675 2107238.1673169 37.7651884221731 -122.496206568741 (37.7651884221731, -122.496206568741) 11 6 2 55 8
131159 20503 DPW Maintained 1 Pinus radiata :: Monterey Pine 15 1204 Sunset Blvd 24 Sidewalk: Curb side : Cutout Tree Rec/Park 5     12 40   5984687.7602675 2107238.1673169 37.7651884221731 -122.496206568741 (37.7651884221731, -122.496206568741) 11 6 2 55 8
132460 20486 DPW Maintained 1 Pinus radiata :: Monterey Pine 15 1204 Sunset Blvd 7 Sidewalk: Curb side : Cutout Tree Rec/Park 5     36 40   5984687.7602675 2107238.1673169 37.7651884221731 -122.496206568741 (37.7651884221731, -122.496206568741) 11 6 2 55 8
142506 20490 DPW Maintained 1 Pinus radiata :: Monterey Pine 15 1204 Sunset Blvd 11 Sidewalk: Curb side : Cutout Tree Rec/Park 5     18 40   5984687.7602675 2107238.1673169 37.7651884221731 -122.496206568741 (37.7651884221731, -122.496206568741) 11 6 2 55 8
152409 20497 DPW Maintained 1 Pinus radiata :: Monterey Pine 15 1204 Sunset Blvd 18 Sidewalk: Curb side : Cutout Tree Rec/Park 5     48 40   5984687.7602675 2107238.1673169 37.7651884221731 -122.496206568741 (37.7651884221731, -122.496206568741) 11 6 2 55 8
161235 20500 DPW Maintained 1 Pinus radiata :: Monterey Pine 15 1204 Sunset Blvd 21 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
172694 20494 DPW Maintained 1 Pinus radiata :: Monterey Pine 15 1204 Sunset Blvd 15 Sidewalk: Curb side : Cutout Tree Rec/Park 5     18 40   5984687.7602675 2107238.1673169 37.7651884221731 -122.496206568741 (37.7651884221731, -122.496206568741) 11 6 2 55 8
181967 20489 DPW Maintained 1 Pinus radiata :: Monterey Pine 15 1204 Sunset Blvd 10 Sidewalk: Curb side : Cutout Tree Rec/Park 5     18 40   5984687.7602675 2107238.1673169 37.7651884221731 -122.496206568741 (37.7651884221731, -122.496206568741) 11 6 2 55 8
192948 20506 DPW Maintained 1 Pinus radiata :: Monterey Pine 15 1211X Sunset Blvd 2 Sidewalk: Curb side : Cutout Tree Rec/Park 5     24 60   5984783.6901595 2107169.3790132 37.7650051676015 -122.495869700491 (37.7650051676015, -122.495869700491) 11 6 2 55 8
15996 258691 Property Tree 8 Pinus radiata :: Monterey Pine 15 100x Whitney Young Cir 10 Sidewalk: Curb side : Cutout Tree SFUSD 4       3x3   6016360 2096059 37.7362970999571 -122.385879567348 (37.7362970999571, -122.385879567348) 10 3 8 58 1
17997 122419 Undocumented 4 Pinus radiata :: Monterey Pine 15 2200 San Jose Ave 1 Sidewalk: Curb side : Cutout Tree MTA 3       3x3   5998886 2091075 37.7216297132481 -122.445935857536 (37.7216297132481, -122.445935857536) 9 7 6 28861 25
32937 178336 Significant Tree 6 Pinus radiata :: Monterey Pine 15 401 Ocean Ave 2 Sidewalk: Property side : Yard Tree MTA 3     29 Width 8ft   5998664.9682 2091522.93582 37.7228470175482 -122.44673211619 (37.7228470175482, -122.44673211619) 9 7 6 28861 25
39321 120597 Significant Tree 6 Pinus radiata :: Monterey Pine 15 499x Ocean Ave 5 Sidewalk: Curb side : Cutout Tree MTA 3       3x3   5998874 2091543 37.7229140478676 -122.446010982458 (37.7229140478676, -122.446010982458) 9 7 6 28861 25
44800 120594 Significant Tree 6 Pinus radiata :: Monterey Pine 15 499x Ocean Ave 2 Sidewalk: Curb side : Cutout Tree MTA 3       3x3   5998874 2091543 37.7229140478676 -122.446010982458 (37.7229140478676, -122.446010982458) 9 7 6 28861 25
54303 178335 Significant Tree 6 Pinus radiata :: Monterey Pine 15 401 Ocean Ave 1 Sidewalk: Property side : Yard Tree MTA 3     33 Width 8ft   5998656.04486 2091523.12147 37.7228470175503 -122.446762975526 (37.7228470175503, -122.446762975526) 9 7 6 28861 25
104414 120596 Significant Tree 6 Pinus radiata :: Monterey Pine 15 499x Ocean Ave 1 Sidewalk: Curb side : Cutout Tree MTA 3     36 3x3   5998874 2091543 37.7229140478676 -122.446010982458 (37.7229140478676, -122.446010982458) 9 7 6 28861 25
114550 178337 Significant Tree 6 Pinus radiata :: Monterey Pine 15 401 Ocean Ave 3 Sidewalk: Property side : Yard Tree MTA 3     29     5998676.28102 2091524.00797 37.7228506076618 -122.446693087413 (37.7228506076618, -122.446693087413) 9 7 6 28861 25
116578 120595 Significant Tree 6 Pinus radiata :: Monterey Pine 15 499x Ocean Ave 3 Sidewalk: Curb side : Cutout Tree MTA 3       3x3   5998874 2091543 37.7229140478676 -122.446010982458 (37.7229140478676, -122.446010982458) 9 7 6 28861 25
166166 120598 Significant Tree 6 Pinus radiata :: Monterey Pine 15 499x Ocean Ave 6 Sidewalk: Curb side : Cutout Tree MTA 3       3x3   5998874 2091543 37.7229140478676 -122.446010982458 (37.7229140478676, -122.446010982458) 9 7 6 28861 25
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
176 194490 DPW Maintained 1 Pinus radiata :: Monterey Pine 15 1501 22nd St 19 Front Yard : Yard Tree Private 2     29     6013346.63868 2103825.44695 37.7574548949481 -122.396842409144 (37.7574548949481, -122.396842409144) 10 3 8 28856 29
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
230 114428 Undocumented 4 Pinus radiata :: Monterey Pine 15 34x HIGUERA AVE 2 Median : Yard Tree Private 2     56     5987903 2090420 37.7191979850677 -122.483852684784 (37.7191979850677, -122.483852684784) 1 8 4 64 14
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
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
567 181420 DPW Maintained 1 Pinus radiata :: Monterey Pine 15 1500 Sunset Blvd 53 Sidewalk: Property side : Yard Tree Private 2     5 Width 0ft   5984891.1718 2104759.369 37.7583942485176 -122.495320206303 (37.7583942485176, -122.495320206303) 1 8 3 56 35
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
724 178311 DPW Maintained 1 Pinus radiata :: Monterey Pine 15 300 Serrano Dr 1 Sidewalk: Curb side : Yard Tree Private 2     38 10x10   5989003 2090507 37.7195008394357 -122.480056810171 (37.7195008394357, -122.480056810171) 1 8 4 64 14
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
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
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
1428 194473 DPW Maintained 1 Pinus radiata :: Monterey Pine 15 851 Indiana St 1 Sidewalk: Property side : Yard Tree Private 2     32 Width 8ft   6014996.92919 2104399.34696 37.7591224196901 -122.391175112734 (37.7591224196901, -122.391175112734) 10 3 8 28856 29
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
1536 187084 DPW Maintained 1 Pinus radiata :: Monterey Pine 15 2600 Sunset Blvd 20 Sidewalk: Property side : Yard Tree Private 2     23 Width 0ft   5985178.0339 2097042.9902 37.7372239657972 -122.493759507537 (37.7372239657972, -122.493759507537) 1 8 3 29491 35
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
2067 211204 DPW Maintained 1 Pinus radiata :: Monterey Pine 15 700 Junipero Serra Blvd 150 : Tree Private 2     8 Width 0ft   5991184.95958 2091479.43645 37.7222974463483 -122.472585508941 (37.7222974463483, -122.472585508941) 9 8 4 64 40
2174 173658 DPW Maintained 1 Pinus radiata :: Monterey Pine 15 1200X JUNIPERO SERRA BLVD 46 Sidewalk: Property side : Yard Tree Private 2   01/20/2017 12:00:00 AM 3     5991123 2089585 37.7170922039834 -122.472661630304 (37.7170922039834, -122.472661630304) 1 8 4 64 14
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
2578 139478 DPW Maintained 1 Pinus radiata :: Monterey Pine 15 416 Masonic Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   10/02/2020 12:00:00 AM 3 Width 0ft   5999096.683 2111385.8942 37.7774105099956 -122.446668218684 (37.7774105099956, -122.446668218684) 15 5 11 29492 16
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
3166 194483 DPW Maintained 1 Pinus radiata :: Monterey Pine 15 930 Kansas St 2 Front Yard : Yard Tree Private 2     31     6011593.09908 2103991.17748 37.7578121947052 -122.402918540071 (37.7578121947052, -122.402918540071) 10 3 8 28856 29
3176 233293 DPW Maintained 1 Pinus radiata :: Monterey Pine 15 200 Eugenia Ave 32 Front Yard : Yard Tree Private 2     24 Width 10ft   6006620.44914 2098098.60188 37.7413536002823 -122.419697976596 (37.7413536002823, -122.419697976596) 2 7 7 28859 2
3462 233333 Significant Tree 6 Pinus radiata :: Monterey Pine 15 188 States St 1 Back Yard : Yard Tree Private 2     14 Width 3ft Permit Number 784841 6001049.9199 2106366.66768 37.763740347549 -122.43955144426 (37.763740347549, -122.43955144426) 15 5 5 28862 3
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
4407 185467 DPW Maintained 1 Pinus radiata :: Monterey Pine 15 2400 Sunset Blvd 19 unknown : Yard Tree Private 2     3 Width 0ft   5985112.4406 2098402.8327 37.7409538906719 -122.494086484448 (37.7409538906719, -122.494086484448) 1 8 3 29491 35
4672 246634 DPW Maintained 1 Pinus radiata :: Monterey Pine 15 3320 Harrison St 5 Front Yard : Yard Tree Private 2     3     6009032.675 2099260.65572 37.7446799344495 -122.411439388921 (37.7446799344495, -122.411439388921) 2 7 7 28859 2
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
4778 201565 DPW Maintained 1 Pinus radiata :: Monterey Pine 15 200 Jerrold Ave 16 Sidewalk: Property side : Yard Tree Private 2     45     6019673.98228 2093813.82501 37.7303151200443 -122.374266134286 (37.7303151200443, -122.374266134286) 10 3 8 58 1
4854 117978 DPW Maintained 1 Pinus radiata :: Monterey Pine 15 428 38th Ave 1 Sidewalk: Curb side : Yard Tree Private 2     14 Width 4ft   5984094.13719 2112920.10602 37.7807546046446 -122.498679507303 (37.7807546046446, -122.498679507303) 11 6 2 55 26
4876 211087 DPW Maintained 1 Pinus radiata :: Monterey Pine 15 1840 Funston Ave 2 Sidewalk: Curb side : Yard Tree Private 2     56     5992084.81362 2102739.60541 37.7532670696221 -122.47029454987 (37.7532670696221, -122.47029454987) 1 8 4 56 12
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
4898 211279 Significant Tree 6 Pinus radiata :: Monterey Pine 15 350 Joost Ave 1 Sidewalk: Property side : Yard Tree Private 2     28 Width 10ft   5999756.13451 2094992.8184 37.7324367835174 -122.443209289192 (37.7324367835174, -122.443209289192) 9 7 4 63 40
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
5963 178185 DPW Maintained 1 Pinus radiata :: Monterey Pine 15 1540 Sunnydale Ave 2 Sidewalk: Property side : Yard Tree Private 2     40 Width 6ft   6007177.62531 2087487.59558 37.7122494380257 -122.417019794631 (37.7122494380257, -122.417019794631) 9 7 8 309 39
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
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
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
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
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

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