trees

1,408 rows where qSpecies_id = 113 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)
501 108350 Undocumented 4 Juniperus chinensis :: Juniper 113 1501x RIVERA ST 6 Sidewalk: Property side : Yard Tree Private 2       3x3   5988383 2100343 37.7464719103157 -122.482920391178 (37.7464719103157, -122.482920391178) 1 8 3 29491 35
10469 259580 DPW Maintained 1 Juniperus chinensis :: Juniper 113 398 Public Park 2 Unaccepted Street : Cutout Tree Private 2       3x3   5994369 2098919 37.7429084509163 -122.462118372119 (37.7429084509163, -122.462118372119) 1 8 4 59 40
13953 116804 DPW Maintained 1 Juniperus chinensis :: Juniper 113 131 LAKESHORE DR 1 Median : Yard Landscaping DPW 1       10x100   5984782 2094243 37.7295127607338 -122.494922366174 (37.7295127607338, -122.494922366174) 1 8 4 64 35
14493 258979 DPW Maintained 1 Juniperus chinensis :: Juniper 113 799X Silliman St 3 Sidewalk: Property side : Yard Tree Private 2       Width 5ft   6008526 2093580 37.7290536583746 -122.412789845037 (37.7290536583746, -122.412789845037) 9 3 7 309 28
15840 258303 Private 9 Juniperus chinensis :: Juniper 113 1x Dawnview Way 1 Sidewalk: Property side : Yard Tree Private 2                              
17612 262236 Undocumented 4 Juniperus chinensis :: Juniper 113 3540 Rivera St 1 Sidewalk: Property side : Cutout Landscaping Private 2       3x3   5982153 2100195 37.7457010726591 -122.504451707081 (37.7457010726591, -122.504451707081) 1 8 3 29491 35
17941 258800 Significant Tree 6 Juniperus chinensis :: Juniper 113 566 29th Ave 2 Front Yard : Cutout Tree Private 2       3x3   5986943 2112080 37.7786145821325 -122.488762272653 (37.7786145821325, -122.488762272653) 11 6 2 55 26
19564 264882 Undocumented 4 Juniperus chinensis :: Juniper 113 2801 Lawton St 1 Sidewalk: Property side : Yard Landscaping Private 2       3x3   5985570 2104278 37.7571122644181 -122.49293709397 (37.7571122644181, -122.49293709397) 1 8 3 56 35
19573 254456 Significant Tree 6 Juniperus chinensis :: Juniper 113 1055X Duncan St 1 Side Yard : Yard Tree Private 2                              
22331 254742 Undocumented 4 Juniperus chinensis :: Juniper 113 1301X 39th Ave 2 Sidewalk: Property side : Cutout Tree Private 2       1x4   5984000 2105977 37.7616853026946 -122.498492164913 (37.7616853026946, -122.498492164913) 1 8 3 56 35
22925 96104 Undocumented 4 Juniperus chinensis :: Juniper 113 2780X 18th St 8 Sidewalk: Property side : Cutout Tree Private 2       3x3 Permit Number 767752 6009596.8 2105493.6 37.7618258328219 -122.40992865922 (37.7618258328219, -122.40992865922) 8 4 8 28859 19
23703 108349 Undocumented 4 Juniperus chinensis :: Juniper 113 1501x RIVERA ST 5 Sidewalk: Property side : Yard Tree Private 2       3x3   5988383 2100343 37.7464719103157 -122.482920391178 (37.7464719103157, -122.482920391178) 1 8 3 29491 35
31670 104539 Property Tree 8 Juniperus chinensis :: Juniper 113 1101 Van Ness Ave 2 Front Yard : Yard Tree Private 2           6006375.5 2114401.9 37.7861048214583 -122.421702631224 (37.7861048214583, -122.421702631224) 13 9 11 28858 41
32562 110175 Undocumented 4 Juniperus chinensis :: Juniper 113 901 MONTEREY BLVD 5 Sidewalk: Property side : Yard Tree Private 2       3x3   5996075.7 2094614.5 37.7311874614685 -122.455906001855 (37.7311874614685, -122.455906001855) 9 7 4 28861 40
32748 108347 Undocumented 4 Juniperus chinensis :: Juniper 113 1501x RIVERA ST 3 Sidewalk: Property side : Yard Tree Private 2       3x3   5988383 2100343 37.7464719103157 -122.482920391178 (37.7464719103157, -122.482920391178) 1 8 3 29491 35
34658 104715 Significant Tree 6 Juniperus chinensis :: Juniper 113 3618 22nd St 1 Sidewalk: Property side : Yard Tree Private 2         Permit Number 770676 6004228.3 2103103.8 37.7549616692716 -122.428325838726 (37.7549616692716, -122.428325838726) 2 4 5 28862 22
36148 96832 Permitted Site 7 Juniperus chinensis :: Juniper 113 2908 Baker St 3 Sidewalk: Property side : Cutout Tree Private 2           5999535.9 2118868.1 37.79797976966 -122.445687034796 (37.79797976966, -122.445687034796) 13 9 1 57 17
37022 95985 Significant Tree 6 Juniperus chinensis :: Juniper 113 577 Sanchez St 1 Front Yard : Tree Private 2           6003673 2104901 37.7598649162805 -122.430374442168 (37.7598649162805, -122.430374442168) 2 4 5 28862 3
38004 108351 Undocumented 4 Juniperus chinensis :: Juniper 113 1501x RIVERA ST 7 Sidewalk: Property side : Yard Tree Private 2       3x3   5988383 2100343 37.7464719103157 -122.482920391178 (37.7464719103157, -122.482920391178) 1 8 3 29491 35
42129 111073 Undocumented 4 Juniperus chinensis :: Juniper 113 1450 IRVING ST 2 Sidewalk: Property side : Cutout Tree Fire Dept 16       3x3   5991201 2106639 37.7639226370674 -122.473635352969 (37.7639226370674, -122.473635352969) 11 8 11 56 12
44754 253482 Significant Tree 6 Juniperus chinensis :: Juniper 113 2179 41st Ave 1 Front Yard : Yard Tree Private 2       3x5   5983532 2100331 37.7461555051432 -122.499693454208 (37.7461555051432, -122.499693454208) 1 8 3 29491 35
46536 110171 Undocumented 4 Juniperus chinensis :: Juniper 113 901 MONTEREY BLVD 1 Sidewalk: Property side : Yard Tree Private 2       3x3   5996075.7 2094614.5 37.7311874614685 -122.455906001855 (37.7311874614685, -122.455906001855) 9 7 4 28861 40
49750 104540 Property Tree 8 Juniperus chinensis :: Juniper 113 1101 Van Ness Ave 4 Front Yard : Yard Tree Private 2           6006375.5 2114401.9 37.7861048214583 -122.421702631224 (37.7861048214583, -122.421702631224) 13 9 11 28858 41
50301 254481 Significant Tree 6 Juniperus chinensis :: Juniper 113 1274 11th Ave 1 Sidewalk: Property side : Cutout Tree Private 2       3x3   5992738 2106820 37.7645085090972 -122.468332545675 (37.7645085090972, -122.468332545675) 11 8 11 56 12
52825 104544 Property Tree 8 Juniperus chinensis :: Juniper 113 1101 Van Ness Ave 8 Front Yard : Yard Tree Private 2           6006375.5 2114401.9 37.7861048214583 -122.421702631224 (37.7861048214583, -122.421702631224) 13 9 11 28858 41
53525 109321 Undocumented 4 Juniperus chinensis :: Juniper 113 3699 MARKET ST 1 Sidewalk: Property side : Cutout Tree Private 2       3x3   6000396.5 2103077.7 37.7546724390671 -122.441575379015 (37.7546724390671, -122.441575379015) 2 4 5 63 38
56573 108255 Undocumented 4 Juniperus chinensis :: Juniper 113 1798X Washington St 2 Sidewalk: Property side : Cutout Tree Private 2 Port     2x2   6006327.67988 2116970.1583 37.7931539244622 -122.422050592495 (37.7931539244622, -122.422050592495) 13 9 10 28858 32
57437 108624 Property Tree 8 Juniperus chinensis :: Juniper 113 101 GENEBERN WAY 1 Front Yard : Yard Tree Private 2           6005050.2 2095237.8 37.733409902631 -122.424923866144 (37.733409902631, -122.424923866144) 2 7 7 28861 2
59374 97299 Permitted Site 7 Juniperus chinensis :: Juniper 113 1051 Portola Dr 2 Sidewalk: Property side : Yard Tree Private 2           5995688.7 2098126.6 37.7408086112536 -122.457497926865 (37.7408086112536, -122.457497926865) 9 7 4 59 40
59898 108211 Significant Tree 6 Juniperus chinensis :: Juniper 113 524 45th Ave 2 Front Yard : Yard Tree Private 2         Permit Number 773704 5981973.19232 2112153.30127 37.7785245664452 -122.505959887315 (37.7785245664452, -122.505959887315) 11 6 2 55 26
62300 99828 Significant Tree 6 Juniperus chinensis :: Juniper 113 2398 Broadway 2 Front Yard : Yard Tree Private 2           6002195.8 2117442.8 37.7942177709498 -122.436380971376 (37.7942177709498, -122.436380971376) 13 9 1 29490 27
63394 106833 Significant Tree 6 Juniperus chinensis :: Juniper 113 174 STILLINGS AVE 1 Front Yard : Yard Tree Private 2           5999619.6 2095804.2 37.7346568605649 -122.443739589791 (37.7346568605649, -122.443739589791) 9 7 4 63 40
63505 254741 Undocumented 4 Juniperus chinensis :: Juniper 113 1301X 39th Ave 1 Sidewalk: Property side : Cutout Tree Private 2       1x4   5983905 2106262 37.7624622607408 -122.498841782409 (37.7624622607408, -122.498841782409) 1 8 3 56 35
68299 99852 Significant Tree 6 Juniperus chinensis :: Juniper 113 86 Nordhoff St 1 Front Yard : Yard Tree Private 2           6000395 2095652 37.7342831509698 -122.441047861045 (37.7342831509698, -122.441047861045) 9 7 5 63 40
70408 102912 Undocumented 4 Juniperus chinensis :: Juniper 113 84 Vienna St 1 Sidewalk: Property side : Cutout Tree Private 2           6004823 2092922 37.7270383945734 -122.425544603716 (37.7270383945734, -122.425544603716) 9 7 6 28861 5
71228 253470 Significant Tree 6 Juniperus chinensis :: Juniper 113 3 Valletta Ct 2 Side Yard : Cutout Tree Private 2       6x10   5999319 2096479 37.7364925519579 -122.444827352142 (37.7364925519579, -122.444827352142) 9 7 4 63 40
74370 121732 DPW Maintained 1 Juniperus chinensis :: Juniper 113 1301 Vermont St 7 Front Yard : Yard Tree DPW 1       3x3   6011430 2102074 37.7525389392772 -122.403347738299 (37.7525389392772, -122.403347738299) 10 4 8 28859 19
75959 255488 DPW Maintained 1 Juniperus chinensis :: Juniper 113 77 Federal St 6 Sidewalk: Curb side : Cutout Tree Private 2       2x1   6014784.35432 2113116.8816 37.7830470409324 -122.39252008665 (37.7830470409324, -122.39252008665) 6 2 9 28856 6
79556 108345 Undocumented 4 Juniperus chinensis :: Juniper 113 1501x RIVERA ST 1 Sidewalk: Property side : Yard Tree Private 2       3x3   5988383 2100343 37.7464719103157 -122.482920391178 (37.7464719103157, -122.482920391178) 1 8 3 29491 35
80685 119672 Undocumented 4 Juniperus chinensis :: Juniper 113 2090x 20th St 1 Sidewalk: Property side : Cutout Tree Private 2           6011896 2104722 37.7598357807336 -122.401922349815 (37.7598357807336, -122.401922349815) 10 3 8 28856 29
82918 107986 Significant Tree 6 Juniperus chinensis :: Juniper 113 2401x SCOTT ST 4 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6001257 2116757 37.7922813550603 -122.439580129378 (37.7922813550603, -122.439580129378) 13 6 1 29490 27
83421 113366 Undocumented 4 Juniperus chinensis :: Juniper 113 799X ORTEGA WAY 5 Sidewalk: Property side : Cutout Tree Private 2       3x3   5991631 2102457 37.7524648607614 -122.47184332039 (37.7524648607614, -122.47184332039) 1 8 4 29491 12
83906 96831 Permitted Site 7 Juniperus chinensis :: Juniper 113 2908 Baker St 2 Sidewalk: Property side : Cutout Tree Private 2           5999535.9 2118868.1 37.79797976966 -122.445687034796 (37.79797976966, -122.445687034796) 13 9 1 57 17
85213 88347 Permitted Site 7 Juniperus chinensis :: Juniper 113 100x Vienna St   Sidewalk: Curb side : Cutout Tree Private 2   07/10/2008 12:00:00 AM   3x3 Permit Number 51332 6004738 2092796 37.7266876232591 -122.425829482771 (37.7266876232591, -122.425829482771) 9 7 6 28861 5
86207 104538 Property Tree 8 Juniperus chinensis :: Juniper 113 1101 Van Ness Ave 1 Front Yard : Yard Tree Private 2           6006375.5 2114401.9 37.7861048214583 -122.421702631224 (37.7861048214583, -122.421702631224) 13 9 11 28858 41
88030 108259 Undocumented 4 Juniperus chinensis :: Juniper 113 1798X Washington St 6 Sidewalk: Property side : Cutout Tree Private 2 Port     2x2   6006327.67988 2116970.1583 37.7931539244622 -122.422050592495 (37.7931539244622, -122.422050592495) 13 9 10 28858 32
88093 110173 Undocumented 4 Juniperus chinensis :: Juniper 113 901 MONTEREY BLVD 3 Sidewalk: Property side : Yard Tree Private 2       3x3   5996075.7 2094614.5 37.7311874614685 -122.455906001855 (37.7311874614685, -122.455906001855) 9 7 4 28861 40
93966 254743 Undocumented 4 Juniperus chinensis :: Juniper 113 1301X 39th Ave 3 Sidewalk: Property side : Cutout Tree Private 2       1x4   5984000 2105977 37.7616853026946 -122.498492164913 (37.7616853026946, -122.498492164913) 1 8 3 56 35
94077 103591 Significant Tree 6 Juniperus chinensis :: Juniper 113 55X Laguna St 3 Front Yard : Yard Tree Private 2           6005242.6 2108960.5 37.7711001201992 -122.425234826708 (37.7711001201992, -122.425234826708) 7 9 5 28852 10
98703 96098 Undocumented 4 Juniperus chinensis :: Juniper 113 1999 Bryant St 2 Sidewalk: Property side : Cutout Tree Private 2       3x3 Permit Number 767752 6009553 2105475 37.7617723065941 -122.410078833483 (37.7617723065941, -122.410078833483) 8 4 8 28859 19
99497 104543 Property Tree 8 Juniperus chinensis :: Juniper 113 1101 Van Ness Ave 7 Front Yard : Yard Tree Private 2           6006375.5 2114401.9 37.7861048214583 -122.421702631224 (37.7861048214583, -122.421702631224) 13 9 11 28858 41
101786 104542 Property Tree 8 Juniperus chinensis :: Juniper 113 1101 Van Ness Ave 6 Front Yard : Yard Tree Private 2           6006375.5 2114401.9 37.7861048214583 -122.421702631224 (37.7861048214583, -122.421702631224) 13 9 11 28858 41
102012 254302 DPW Maintained 1 Juniperus chinensis :: Juniper 113 140 Junipero Serra Blvd 5 Median : Cutout Tree Private 2       10x10   5991388 2095260 37.73268968153 -122.472159089582 (37.73268968153, -122.472159089582) 1 8 4 64 40
102497 108353 Undocumented 4 Juniperus chinensis :: Juniper 113 1501x RIVERA ST 9 Sidewalk: Property side : Yard Tree Private 2       3x3   5988383 2100343 37.7464719103157 -122.482920391178 (37.7464719103157, -122.482920391178) 1 8 3 29491 35
103648 99918 Permitted Site 7 Juniperus chinensis :: Juniper 113 1740 Jones St 5 Sidewalk: Property side : Cutout Tree Private 2           6008334 2118406 37.7972093435845 -122.415210266144 (37.7972093435845, -122.415210266144) 5 1 10 308 21
103792 104717 Significant Tree 6 Juniperus chinensis :: Juniper 113 3618 22nd St 3 Sidewalk: Property side : Yard Tree Private 2         Permit Number 770676 6004228.3 2103103.8 37.7549616692716 -122.428325838726 (37.7549616692716, -122.428325838726) 2 4 5 28862 22
104693 108256 Undocumented 4 Juniperus chinensis :: Juniper 113 1798X Washington St 3 Sidewalk: Property side : Cutout Tree Private 2 Port     2x2   6006327.67988 2116970.1583 37.7931539244622 -122.422050592495 (37.7931539244622, -122.422050592495) 13 9 10 28858 32
106382 116072 Significant Tree 6 Juniperus chinensis :: Juniper 113 388 POLARIS WAY 1 Sidewalk: Property side : Cutout Tree Private 2       3x3   6000586 2086414 37.7089285790833 -122.439725431133 (37.7089285790833, -122.439725431133) 9 7 6 28861 5
107201 108346 Undocumented 4 Juniperus chinensis :: Juniper 113 1501x RIVERA ST 2 Sidewalk: Property side : Yard Tree Private 2       3x3   5988383 2100343 37.7464719103157 -122.482920391178 (37.7464719103157, -122.482920391178) 1 8 3 29491 35
114523 110402 Undocumented 4 Juniperus chinensis :: Juniper 113 419X 18TH AVE 3 Sidewalk: Curb side : Cutout Tree DPW for City Agency 14 MTA     3x3   5990240 2112557 37.7801161452828 -122.477391675869 (37.7801161452828, -122.477391675869) 11 6 2 55 26
114624 99917 Permitted Site 7 Juniperus chinensis :: Juniper 113 1740 Jones St 3 Sidewalk: Property side : Cutout Tree Private 2           6008334 2118406 37.7972093435845 -122.415210266144 (37.7972093435845, -122.415210266144) 5 1 10 308 21
118511 99916 Permitted Site 7 Juniperus chinensis :: Juniper 113 1740 Jones St 1 Sidewalk: Property side : Cutout Tree Private 2           6008334 2118406 37.7972093435845 -122.415210266144 (37.7972093435845, -122.415210266144) 5 1 10 308 21
120358 103590 Significant Tree 6 Juniperus chinensis :: Juniper 113 55X Laguna St 2 Front Yard : Yard Tree Private 2           6005242.6 2108960.5 37.7711001201992 -122.425234826708 (37.7711001201992, -122.425234826708) 7 9 5 28852 10
123493 121734 DPW Maintained 1 Juniperus chinensis :: Juniper 113 1301 Vermont St 9 Front Yard : Yard Tree DPW 1       3x3   6011430 2102074 37.7525389392772 -122.403347738299 (37.7525389392772, -122.403347738299) 10 4 8 28859 19
124338 114704 Undocumented 4 Juniperus chinensis :: Juniper 113 524 Staples Ave 2 Sidewalk: Curb side : Cutout Tree Private 2           5996948.70097149 2093858.06219815 37.729160530354 -122.452833321223 (37.729160530354, -122.452833321223) 9 7 4 28861 40
130357 113985 Undocumented 4 Juniperus chinensis :: Juniper 113 109 MADRONE AVE 1 Sidewalk: Property side : Cutout Tree Private 2       3x10   5992778 2098364 37.7412928293111 -122.467579208879 (37.7412928293111, -122.467579208879) 1 8 4 59 40
130441 108258 Undocumented 4 Juniperus chinensis :: Juniper 113 1798X Washington St 5 Sidewalk: Property side : Cutout Tree Private 2 Port     2x2   6006327.67988 2116970.1583 37.7931539244622 -122.422050592495 (37.7931539244622, -122.422050592495) 13 9 10 28858 32
130833 106685 Undocumented 4 Juniperus chinensis :: Juniper 113 100 Yukon St   Front Yard : Cutout Tree Private 2         Permit Number 772768 6000197.4 2104288 37.757984281634 -122.442350801363 (37.757984281634, -122.442350801363) 2 4 5 28862 3
138982 104716 Significant Tree 6 Juniperus chinensis :: Juniper 113 3618 22nd St 2 Sidewalk: Property side : Yard Tree Private 2         Permit Number 770676 6004228.3 2103103.8 37.7549616692716 -122.428325838726 (37.7549616692716, -122.428325838726) 2 4 5 28862 22
139329 110406 Undocumented 4 Juniperus chinensis :: Juniper 113 419X 18TH AVE 7 Sidewalk: Curb side : Cutout Tree DPW for City Agency 14 MTA     3x3   5990240 2112557 37.7801161452828 -122.477391675869 (37.7801161452828, -122.477391675869) 11 6 2 55 26
139843 108680 Property Tree 8 Juniperus chinensis :: Juniper 113 240 SANTA ANA AVE 1 Back Yard : Yard Tree Private 2           5992606.9 2095181.7 37.7325451527527 -122.46793939449 (37.7325451527527, -122.46793939449) 9 8 4 59 40
140038 99919 Permitted Site 7 Juniperus chinensis :: Juniper 113 1740 Jones St 4 Sidewalk: Property side : Cutout Tree Private 2           6008334 2118406 37.7972093435845 -122.415210266144 (37.7972093435845, -122.415210266144) 5 1 10 308 21
144404 108257 Undocumented 4 Juniperus chinensis :: Juniper 113 1798X Washington St 4 Sidewalk: Property side : Cutout Tree Private 2 Port     2x2   6006327.67988 2116970.1583 37.7931539244622 -122.422050592495 (37.7931539244622, -122.422050592495) 13 9 10 28858 32
150675 121326 DPW Maintained 1 Juniperus chinensis :: Juniper 113 19 25th Ave 1 Sidewalk: Property side : Cutout Tree Private 2       3x3   5987896 2115988 37.7894004070969 -122.485752421711 (37.7894004070969, -122.485752421711) 11 6 1 55 33
150737 96105 Undocumented 4 Juniperus chinensis :: Juniper 113 2780X 18th St 7 Sidewalk: Property side : Cutout Tree Private 2       3x3 Permit Number 767752 6009596.8 2105493.6 37.7618258328219 -122.40992865922 (37.7618258328219, -122.40992865922) 8 4 8 28859 19
151110 122636 Significant Tree 6 Juniperus chinensis :: Juniper 113 3698X 19th Ave 1 Sidewalk: Property side : Cutout Tree Private 2       3x3   5990586 2091171 37.7214158684235 -122.474633449984 (37.7214158684235, -122.474633449984) 9 8 4 64 40
153752 96103 Undocumented 4 Juniperus chinensis :: Juniper 113 2780X 18th St 6 Sidewalk: Property side : Cutout Tree Private 2       3x3 Permit Number 767752 6009596.8 2105493.6 37.7618258328219 -122.40992865922 (37.7618258328219, -122.40992865922) 8 4 8 28859 19
153888 96106 Undocumented 4 Juniperus chinensis :: Juniper 113 2780X 18th St 9 Sidewalk: Property side : Cutout Tree Private 2       3x3 Permit Number 767752 6009596.8 2105493.6 37.7618258328219 -122.40992865922 (37.7618258328219, -122.40992865922) 8 4 8 28859 19
154569 103589 Significant Tree 6 Juniperus chinensis :: Juniper 113 55X Laguna St 1 Front Yard : Yard Tree Private 2           6005242.6 2108960.5 37.7711001201992 -122.425234826708 (37.7711001201992, -122.425234826708) 7 9 5 28852 10
159975 97139 DPW Maintained 1 Juniperus chinensis :: Juniper 113 937 Goettingen St   Front Yard : Landscaping Private 2           6011052 2090410 37.7204909525546 -122.403834244644 (37.7204909525546, -122.403834244644) 10 7 8 309 28
160307 110393 Significant Tree 6 Juniperus chinensis :: Juniper 113 451 LOS PALMOS DR 1 Sidewalk: Property side : Cutout Tree Private 2       3x8   5997298 2095759 37.7344000615683 -122.451762846846 (37.7344000615683, -122.451762846846) 9 7 4 59 40
164514 110172 Undocumented 4 Juniperus chinensis :: Juniper 113 901 MONTEREY BLVD 2 Sidewalk: Property side : Yard Tree Private 2       3x3   5996075.7 2094614.5 37.7311874614685 -122.455906001855 (37.7311874614685, -122.455906001855) 9 7 4 28861 40
166621 108254 Undocumented 4 Juniperus chinensis :: Juniper 113 1798X Washington St 1 Sidewalk: Property side : Cutout Tree Private 2 Port     2x2   6006327.67988 2116970.1583 37.7931539244622 -122.422050592495 (37.7931539244622, -122.422050592495) 13 9 10 28858 32
169667 110174 Undocumented 4 Juniperus chinensis :: Juniper 113 901 MONTEREY BLVD 4 Sidewalk: Property side : Yard Tree Private 2       3x3   5996075.7 2094614.5 37.7311874614685 -122.455906001855 (37.7311874614685, -122.455906001855) 9 7 4 28861 40
172848 108210 Significant Tree 6 Juniperus chinensis :: Juniper 113 524 45th Ave 1 Front Yard : Yard Tree Private 2         Permit Number 773704 5981973.19232 2112153.30127 37.7785245664452 -122.505959887315 (37.7785245664452, -122.505959887315) 11 6 2 55 26
173080 105857 Significant Tree 6 Juniperus chinensis :: Juniper 113 1500X Valencia St 1 Sidewalk: Property side : Cutout Tree Private 2       3x3   6006259.2 2100711.5 37.7485076710609 -122.421132539956 (37.7485076710609, -122.421132539956) 2 4 5 28859 19
178383 254277 Significant Tree 6 Juniperus chinensis :: Juniper 113 105 Gladeview Way 1 Front Yard : Cutout Tree Private 2       3x6 Permit Number 781296 5997754 2101950 37.7514251480437 -122.450632514859 (37.7514251480437, -122.450632514859) 1 5 4 63 38
180245 110414 Undocumented 4 Juniperus chinensis :: Juniper 113 419X 18TH AVE 15 Sidewalk: Curb side : Cutout Tree DPW for City Agency 14 MTA     3x3   5990240 2112557 37.7801161452828 -122.477391675869 (37.7801161452828, -122.477391675869) 11 6 2 55 26
180590 251186 DPW Maintained 1 Juniperus chinensis :: Juniper 113 3042 Steiner St 1 Sidewalk: Property side : Cutout Tree Private 2       3x3   6002010 2118654 37.7975328515761 -122.437110618013 (37.7975328515761, -122.437110618013) 13 9 1 57 17
181064 104568 Property Tree 8 Juniperus chinensis :: Juniper 113 1101 Van Ness Ave 9 Front Yard : Yard Tree Private 2           6006375.5 2114401.9 37.7861048214583 -122.421702631224 (37.7861048214583, -122.421702631224) 13 9 11 28858 41
182344 104541 Property Tree 8 Juniperus chinensis :: Juniper 113 1101 Van Ness Ave 5 Front Yard : Yard Tree Private 2           6006375.5 2114401.9 37.7861048214583 -122.421702631224 (37.7861048214583, -122.421702631224) 13 9 11 28858 41
193863 111072 Undocumented 4 Juniperus chinensis :: Juniper 113 1450 IRVING ST 1 Sidewalk: Property side : Cutout Tree Fire Dept 16       3x3   5991277 2106586 37.7637815143869 -122.473368628437 (37.7637815143869, -122.473368628437) 11 8 11 56 12
17115 129350 DPW Maintained 1 Juniperus chinensis :: Juniper 113 1306x Montgomery St 38 Median : Yard Tree DPW 1     1 Width 8ft   6011425.50986 2120159.17711 37.8021963979046 -122.404636291051 (37.8021963979046, -122.404636291051) 3 1 10 308 23
37204 227015 DPW Maintained 1 Juniperus chinensis :: Juniper 113 29 Poppy Ln 1 Back Yard : Yard Tree Private 2     1 Width 2ft   6002114.09151 2096793.82616 37.7375161085743 -122.435186060404 (37.7375161085743, -122.435186060404) 2 7 5 63 7
39179 92458 DPW Maintained 1 Juniperus chinensis :: Juniper 113 3319 Lawton St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/30/2009 12:00:00 AM 1 3x3 Permit Number 52848 5983933.4582 2104246.8072 37.7569307763868 -122.498594490514 (37.7569307763868, -122.498594490514) 1 8 3 56 35
62635 129332 DPW Maintained 1 Juniperus chinensis :: Juniper 113 1101 Greenwich St 10 Front Yard : Yard Tree Private 2     1     6007563.68428 2119863.77685 37.8011687120311 -122.417979152724 (37.8011687120311, -122.417979152724) 5 1 1 28858 32
82430 226865 DPW Maintained 1 Juniperus chinensis :: Juniper 113 1100 San Jose Ave 9 Front Yard : Yard Tree Private 2     1     6004824.42349 2096711.05527 37.7374423749661 -122.425809268297 (37.7374423749661, -122.425809268297) 2 7 5 63 7
86395 129333 DPW Maintained 1 Juniperus chinensis :: Juniper 113 1101 Greenwich St 12 Front Yard : Yard Tree Private 2     1     6007566.18304 2119864.34532 37.8011704135381 -122.417970546228 (37.8011704135381, -122.417970546228) 5 1 1 28858 32
94848 249495 DPW Maintained 1 Juniperus chinensis :: Juniper 113 1801 California St 4 Sidewalk: Property side : Yard Tree Private 2     1 Width 2ft   6005713.46666 2115852.81799 37.7900513270512 -122.424096313394 (37.7900513270512, -122.424096313394) 13 9 1 28858 41
139770 129351 DPW Maintained 1 Juniperus chinensis :: Juniper 113 1306x Montgomery St 39 Median : Yard Tree DPW 1     1 Width 8ft   6011425.67929 2120161.57643 37.8022029953207 -122.404635873741 (37.8022029953207, -122.404635873741) 3 1 10 308 23

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