trees

1,408 rows where qSpecies_id = 113 sorted by qLegalStatus_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)
15840 258303 Private 9 Juniperus chinensis :: Juniper 113 1x Dawnview Way 1 Sidewalk: Property side : Yard Tree Private 2                              
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
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
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
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
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
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
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
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
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
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
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
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
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
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
187571 93020 Permitted Site 7 Juniperus chinensis :: Juniper 113 1403 11th Ave 3 Sidewalk: Property side : Cutout Tree Private 2     10 2x2 Tree 3 5992673.9 2105865.8 37.7618848250494 -122.468484819075 (37.7618848250494, -122.468484819075) 1 8 4 56 12
3385 223764 Significant Tree 6 Juniperus chinensis :: Juniper 113 126 Bradford St 2 Sidewalk: Property side : Yard Tree Private 2     12 Width 3ft   6009530.67949 2097860.55808 37.7408634922583 -122.409618578359 (37.7408634922583, -122.409618578359) 10 7 7 28859 2
4813 223765 Significant Tree 6 Juniperus chinensis :: Juniper 113 126 Bradford St 3 Sidewalk: Property side : Yard Tree Private 2     9 Width 3ft   6009530.59471 2097856.4038 37.7408520807582 -122.409618578357 (37.7408520807582, -122.409618578357) 10 7 7 28859 2
7930 223763 Significant Tree 6 Juniperus chinensis :: Juniper 113 126 Bradford St 1 Sidewalk: Property side : Yard Tree Private 2     11 Width 3ft   6009530.79254 2097866.09723 37.7408787078943 -122.409618578334 (37.7408787078943, -122.409618578334) 10 7 7 28859 2
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
19573 254456 Significant Tree 6 Juniperus chinensis :: Juniper 113 1055X Duncan St 1 Side Yard : Yard Tree Private 2                              
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
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
38960 103564 Significant Tree 6 Juniperus chinensis :: Juniper 113 878 14th St 2 Front Yard : Yard Tree Private 2     13   Permit Number 770193 6002986 2107714 37.7675497941952 -122.432951409123 (37.7675497941952, -122.432951409123) 15 5 5 28862 3
40123 256065 Significant Tree 6 Juniperus chinensis :: Juniper 113 2800 Fillmore St 1 Sidewalk: Curb side : Cutout Tree Private 2   09/07/2018 12:00:00 AM 3 3x3   6002545 2117972 37.7956906526811 -122.435210571933 (37.7956906526811, -122.435210571933) 13 9 1 57 17
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
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
50909 103563 Significant Tree 6 Juniperus chinensis :: Juniper 113 878 14th St 1 Front Yard : Yard Tree Private 2     15   Permit Number 770193 6002986 2107714 37.7675497941952 -122.432951409123 (37.7675497941952, -122.432951409123) 15 5 5 28862 3
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
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
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
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
87223 103565 Significant Tree 6 Juniperus chinensis :: Juniper 113 878 14th St 3 Front Yard : Yard Tree Private 2     9   Permit Number 770193 6002986 2107714 37.7675497941952 -122.432951409123 (37.7675497941952, -122.432951409123) 15 5 5 28862 3
92381 116164 Significant Tree 6 Juniperus chinensis :: Juniper 113 2411 OCTAVIA ST 1 Sidewalk: Curb side : Yard Tree Private 2     13 15x4   6004495 2117637 37.7948813682629 -122.428439330772 (37.7948813682629, -122.428439330772) 13 9 1 28858 27
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
100702 109040 Significant Tree 6 Juniperus chinensis :: Juniper 113 654 Precita Ave   Front Yard : Yard Tree Private 2     30     6009911.5 2100416.7 37.7479034320272 -122.408482100152 (37.7479034320272, -122.408482100152) 2 7 7 28859 2
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
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
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
125570 253265 Significant Tree 6 Juniperus chinensis :: Juniper 113 180 San Aleso Ave 1 Front Yard : Cutout Tree Private 2   09/19/2017 12:00:00 AM 3 3x3   5993319 2094440 37.7305497238902 -122.465423653439 (37.7305497238902, -122.465423653439) 9 8 4 59 40
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
149078 117438 Significant Tree 6 Juniperus chinensis :: Juniper 113 230 AMBER DR 1 Sidewalk: Property side : Cutout Tree Private 2     25 3X3   5999593 2099199 37.7439766577846 -122.444075405191 (37.7439766577846, -122.444075405191) 2 7 5 63 22
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
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
159697 226945 Significant Tree 6 Juniperus chinensis :: Juniper 113 998 Chenery St 4 Sidewalk: Property side : Yard Tree Private 2     21 Width 1ft   6001140.61217 2096125.61153 37.7356260187109 -122.438503967885 (37.7356260187109, -122.438503967885) 2 7 5 63 7
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
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
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
11113 107054 Undocumented 4 Juniperus chinensis :: Juniper 113 98X ROTTECK ST 3 Sidewalk: Curb side : Cutout Tree Private 2     12 2x2   6003385 2094496 37.7312788881427 -122.43062801307 (37.7312788881427, -122.43062801307) 9 7 5 28861 25
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
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
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
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
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
40697 108348 Undocumented 4 Juniperus chinensis :: Juniper 113 1501x RIVERA ST 4 Sidewalk: Property side : Yard Tree Private 2     8 3x3   5988501 2100296 37.7463497260509 -122.482508921927 (37.7463497260509, -122.482508921927) 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
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
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
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
63852 254397 Undocumented 4 Juniperus chinensis :: Juniper 113 317X Dorado Ter 1 Side Yard : Yard Tree Private 2   01/09/2019 12:00:00 AM 3 3x6 Permit Number 782774 5994307 2093018 37.7267021901994 -122.461904942649 (37.7267021901994, -122.461904942649) 9 8 4 28861 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
78350 107828 Undocumented 4 Juniperus chinensis :: Juniper 113 2601 Van Ness Ave 2 Front Yard : Yard Tree Private 2     35   Permit Number 774138 6005744.5 2119283.2 37.7994720432373 -122.424233014169 (37.7994720432373, -122.424233014169) 13 9 1 28858 17
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
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
86076 116295 Undocumented 4 Juniperus chinensis :: Juniper 113 699X DETROIT ST 1 Sidewalk: Property side : Yard Tree Private 2     28 3x20   5999400 2095202 37.7329908332996 -122.444455553893 (37.7329908332996, -122.444455553893) 9 7 4 59 40
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
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
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
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
107023 254398 Undocumented 4 Juniperus chinensis :: Juniper 113 317X Dorado Ter 2 Side Yard : Yard Tree Private 2   01/09/2019 12:00:00 AM 3 3x6 Permit Number 782774 5994307 2093018 37.7267021901994 -122.461904942649 (37.7267021901994, -122.461904942649) 9 8 4 28861 40
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
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
126076 106802 Undocumented 4 Juniperus chinensis :: Juniper 113 1850 BRYANT ST 2 Sidewalk: Property side : Cutout Tree Private 2     30 3x2   6009455.7 2106195.7 37.7637457302458 -122.410466248693 (37.7637457302458, -122.410466248693) 8 4 7 28859 19
127833 106801 Undocumented 4 Juniperus chinensis :: Juniper 113 1850 BRYANT ST 1 Sidewalk: Property side : Cutout Tree Private 2     25 2x3   6009455.7 2106195.7 37.7637457302458 -122.410466248693 (37.7637457302458, -122.410466248693) 8 4 7 28859 19
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
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
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
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
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
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

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