341 rows where qLegalStatus_id = 8 sorted by qAddress

View and edit SQL

qCareAssistant

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)
134313 255008 Property Tree 8 Pittosporum undulatum :: Victorian Box 36 1 Villa Ter 1 Back Yard : Yard Tree Private 2       3x3   5998933 2105018 37.7599165333482 -122.446776141106 (37.7599165333482, -122.446776141106) 15 5 5 28862 12
137033 114410 Property Tree 8 Pinus radiata :: Monterey Pine 15 10 GARDENSIDE DR   Sidewalk: Curb side : Cutout Tree Private 2           5999306 2102458 37.7529087049134 -122.445302055175 (37.7529087049134, -122.445302055175) 2 5 5 63 38
169065 108625 Property Tree 8 Persea americana :: Avocado 34 100 GENEBERN WAY 1 Front Yard : Yard Tree Private 2     12     6004991.8 2095242.4 37.7334192343039 -122.425126098693 (37.7334192343039, -122.425126098693) 2 7 7 28861 2
43876 114817 Property Tree 8 Pinus radiata :: Monterey Pine 15 100 RACCOON DR 1 Back Yard : Cutout Tree Private 2           5998725 2104028 37.757186355085 -122.447424250084 (37.757186355085, -122.447424250084) 15 5 5 63 3
113507 253768 Property Tree 8 Cupressus macrocarpa :: Monterey Cypress 41 100 Raccoon Dr 1 Back Yard : Yard Tree Private 2           5998692 2104165 37.7575606372552 -122.447548237739 (37.7575606372552, -122.447548237739) 15 5 5 28862 3
6335 262305 Property Tree 8 Casuarina cunninghamiana :: Horsetail pine 112 100 Saint Elmo Way 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   5994960 2094889 37.7318770738882 -122.459783023889 (37.7318770738882, -122.459783023889) 9 8 4 59 40
130825 255872 Property Tree 8 Tree(s) :: 17 100 Stonecrest Dr 1 Back Yard : Cutout Tree Private 2       3x3   5990801 2093784 37.7286029699614 -122.474080817952 (37.7286029699614, -122.474080817952) 9 8 4 64 40
12415 258693 Property Tree 8 Pinus canariensis :: Canary Island Pine 35 100 Whitney Young Cir 11 Sidewalk: Curb side : Cutout Tree SFUSD 4       3x3   6016360 2096059 37.7362970999571 -122.385879567348 (37.7362970999571, -122.385879567348) 10 3 8 58 1
4401 258690 Property Tree 8 Metrosideros excelsa :: New Zealand Xmas Tree 16 100x Whitney Young Cir 11 Sidewalk: Curb side : Cutout Tree SFUSD 4       3x3   6016360 2096059 37.7362970999571 -122.385879567348 (37.7362970999571, -122.385879567348) 10 3 8 58 1
7677 258687 Property Tree 8 Acacia melanoxylon :: Blackwood Acacia 70 100x Whitney Young Cir 9 Sidewalk: Curb side : Yard Tree SFUSD 4       3x3   6016360 2096059 37.7362970999571 -122.385879567348 (37.7362970999571, -122.385879567348) 10 3 8 58 1
9009 258692 Property Tree 8 Pinus canariensis :: Canary Island Pine 35 100x Whitney Young Cir   Sidewalk: Curb side : Cutout Tree SFUSD 4       3x3   6016360 2096059 37.7362970999571 -122.385879567348 (37.7362970999571, -122.385879567348) 10 3 8 58 1
12066 258686 Property Tree 8 Acacia melanoxylon :: Blackwood Acacia 70 100x Whitney Young Cir 8 Sidewalk: Curb side : Yard Tree SFUSD 4       3x3   6016360 2096059 37.7362970999571 -122.385879567348 (37.7362970999571, -122.385879567348) 10 3 8 58 1
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
17872 258685 Property Tree 8 Metrosideros excelsa :: New Zealand Xmas Tree 16 100x Whitney Young Cir 2 Sidewalk: Curb side : Yard Tree SFUSD 4       3x3   6016360 2096059 37.7362970999571 -122.385879567348 (37.7362970999571, -122.385879567348) 10 3 8 58 1
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
192549 98880 Property Tree 8 Cupressus macrocarpa :: Monterey Cypress 41 101 Lansdale Ave 1 Front Yard : Yard Tree Private 2     11     5994747.9 2097283.1 37.7384384842789 -122.460689725403 (37.7384384842789, -122.460689725403) 9 7 4 59 40
5745 193934 Property Tree 8 Metrosideros excelsa :: New Zealand Xmas Tree 16 101 Whitney Young Cir 6 Sidewalk: Curb side : Cutout Tree SFUSD 4     3 Width 3ft   6016623.26344 2095403.70542 37.7345123576517 -122.384923708478 (37.7345123576517, -122.384923708478) 10 3 8 58 1
56515 102470 Property Tree 8 Pinus radiata :: Monterey Pine 15 1021 Kirkham St 2 Back Yard : Yard Tree Private 2           5991773 2105198 37.7599991432047 -122.471551983129 (37.7599991432047, -122.471551983129) 1 8 4 56 12
134592 102469 Property Tree 8 Pinus radiata :: Monterey Pine 15 1021 Kirkham St 1 Back Yard : Yard Tree Private 2           5991773 2105198 37.7599991432047 -122.471551983129 (37.7599991432047, -122.471551983129) 1 8 4 56 12
162706 94228 Property Tree 8 Acer palmatum :: Japanese Maple 216 1097 Church St   Front Yard : Yard Tree Private 2   06/25/2010 12:00:00 AM     Permit Number 53567 6004455 2102510 37.7533440588084 -122.427499544702 (37.7533440588084, -122.427499544702) 2 4 5 28862 22
192149 98878 Property Tree 8 Tree(s) :: 17 11 Panorama Dr   Back Yard : Yard Landscaping Private 2           5998029 2100213 37.7466715093679 -122.449556386849 (37.7466715093679, -122.449556386849) 2 5 4 63 38
194461 265095 Property Tree 8 Pinus canariensis :: Canary Island Pine 35 1100 Junipero Serra Blvd 1 Side Yard : Cutout Tree Private 2       10x10   5991104 2090006 37.7182470667789 -122.472757983106 (37.7182470667789, -122.472757983106) 9 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
54121 101901 Property Tree 8 Metrosideros excelsa :: New Zealand Xmas Tree 16 1100 Ocean Ave 2 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
128219 101903 Property Tree 8 Washingtonia robusta :: Mexican Fan Palm 72 1100 Ocean Ave 4 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
144842 101905 Property Tree 8 Washingtonia robusta :: Mexican Fan Palm 72 1100 Ocean Ave 6 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
191552 101904 Property Tree 8 Washingtonia robusta :: Mexican Fan Palm 72 1100 Ocean Ave 5 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
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
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
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
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
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
26017 109376 Property Tree 8 Populus nigra 'Italica' :: Lombardy Poplar 59 111 BAY ST 3 Back Yard : Yard Tree Private 2           6010193.2 2121519.2 37.8058617340589 -122.408996713259 (37.8058617340589, -122.408996713259) 3 1 10 308 23
64778 109377 Property Tree 8 Populus nigra 'Italica' :: Lombardy Poplar 59 111 BAY ST 4 Back Yard : Yard Tree Private 2           6010193.2 2121519.2 37.8058617340589 -122.408996713259 (37.8058617340589, -122.408996713259) 3 1 10 308 23
84676 109375 Property Tree 8 Populus nigra 'Italica' :: Lombardy Poplar 59 111 BAY ST 2 Back Yard : Yard Tree Private 2           6010193.2 2121519.2 37.8058617340589 -122.408996713259 (37.8058617340589, -122.408996713259) 3 1 10 308 23
137889 109378 Property Tree 8 Populus nigra 'Italica' :: Lombardy Poplar 59 111 BAY ST 5 Back Yard : Yard Tree Private 2           6010193.2 2121519.2 37.8058617340589 -122.408996713259 (37.8058617340589, -122.408996713259) 3 1 10 308 23
155569 109374 Property Tree 8 Populus nigra 'Italica' :: Lombardy Poplar 59 111 BAY ST 1 Back Yard : Yard Tree Private 2           6010193.2 2121519.2 37.8058617340589 -122.408996713259 (37.8058617340589, -122.408996713259) 3 1 10 308 23
173335 117644 Property Tree 8 Cupressus macrocarpa :: Monterey Cypress 41 1111X SANSOME ST 1 Back Yard : Yard Tree Private 2       3x30   6011937 2119613 37.8007253016149 -122.402827843034 (37.8007253016149, -122.402827843034) 3 1 10 308 23
194103 109076 Property Tree 8 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 1137 Munich St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF     3x3 Permit Number 772744 6001554.7 2087011.6 37.7106245477128 -122.436420213894 (37.7106245477128, -122.436420213894) 9 7 6 28861 5
172414 256223 Property Tree 8 Schinus molle :: California Pepper 91 116X Brewster St 1 Sidewalk: Property side : Yard Tree Rec/Park 5       6x6   6010334 2099321 37.7449185312124 -122.406943891675 (37.7449185312124, -122.406943891675) 2 7 7 28859 2
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
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
7701 97237 Property Tree 8 Olea europaea :: Olive Tree 9 125 Excelsior Ave   Sidewalk: Property side : Yard Tree SFUSD 4 FUF 09/07/2011 12:00:00 AM     Permit Number 767513 6002911 2092621.3 37.7261045201699 -122.432132888294 (37.7261045201699, -122.432132888294) 9 7 6 28861 5
21821 97236 Property Tree 8 Citrus × meyeri 'Improved' :: Improved Meyer Lemon 317 125 Excelsior Ave   Sidewalk: Property side : Yard Tree SFUSD 4 FUF 09/07/2011 12:00:00 AM     Permit Number 767513 6002911 2092621.3 37.7261045201699 -122.432132888294 (37.7261045201699, -122.432132888294) 9 7 6 28861 5
106561 97238 Property Tree 8 Olea europaea :: Olive Tree 9 125 Excelsior Ave 1 Sidewalk: Property side : Yard Tree SFUSD 4 FUF 09/07/2011 12:00:00 AM 3 3x3 Permit Number 767513 6002911 2092621.3 37.7261045201699 -122.432132888294 (37.7261045201699, -122.432132888294) 9 7 6 28861 5
71797 256101 Property Tree 8 Populus spp :: Poplar Spp 262 1255 Oak St 1 Back Yard : Cutout Tree Private 2       3x3   6001013 2109627 37.7726903083913 -122.439912920243 (37.7726903083913, -122.439912920243) 15 5 11 29492 9
53202 102251 Property Tree 8 Citrus × meyeri 'Improved' :: Improved Meyer Lemon 317 125X Powhattan Ave 4 Front Yard : Yard Tree Private 2   01/07/2013 12:00:00 AM     Permit Number 768486 6007606 2098071 37.7413332800665 -122.416288322592 (37.7413332800665, -122.416288322592) 2 7 7 28859 2
101616 102250 Property Tree 8 Olea europaea :: Olive Tree 9 125X Powhattan Ave 3 Front Yard : Yard Tree Private 2   01/07/2013 12:00:00 AM     Permit Number 768486 6007606 2098071 37.7413332800665 -122.416288322592 (37.7413332800665, -122.416288322592) 2 7 7 28859 2
108303 102249 Property Tree 8 Olea europaea :: Olive Tree 9 125X Powhattan Ave 2 Front Yard : Yard Tree Private 2   01/07/2013 12:00:00 AM     Permit Number 768486 6007606 2098071 37.7413332800665 -122.416288322592 (37.7413332800665, -122.416288322592) 2 7 7 28859 2
117229 102248 Property Tree 8 Olea europaea :: Olive Tree 9 125X Powhattan Ave 1 Front Yard : Yard Tree Private 2   01/07/2013 12:00:00 AM     Permit Number 768486 6007606 2098071 37.7413332800665 -122.416288322592 (37.7413332800665, -122.416288322592) 2 7 7 28859 2
35596 254587 Property Tree 8 Sequoia sempervirens :: Coast Redwood 155 1270 24th Ave 1 Back Yard : Cutout Tree Private 2       3x3   5988678 2106679 37.7638860263594 -122.482364481098 (37.7638860263594, -122.482364481098) 1 8 3 56 35
163139 112668 Property Tree 8 Pinus radiata :: Monterey Pine 15 129 Henry St   Back Yard : Yard Tree Private 2           6002668 2107340.8 37.7665070360696 -122.434024647923 (37.7665070360696, -122.434024647923) 15 5 5 28862 3
155860 96938 Property Tree 8 Tree(s) :: 17 1306 Cole St   Back Yard : Yard Tree Private 2         Backyard tree on private property 5998246 2105961 37.7624665052811 -122.449220068104 (37.7624665052811, -122.449220068104) 15 5 11 29492 9
30542 98548 Property Tree 8 Sequoia sempervirens :: Coast Redwood 155 132 Hamerton Ave 1 Front Yard : Yard Tree Private 2           6001332.8 2095440.7 37.7337563407686 -122.437790462907 (37.7337563407686, -122.437790462907) 9 7 5 63 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
177432 102706 Property Tree 8 Cupressus macrocarpa :: Monterey Cypress 41 1342 Funston Ave 1 Back Yard : Yard Tree Private 2           5992135.4 2106294.8 37.7630316255695 -122.470378504645 (37.7630316255695, -122.470378504645) 1 8 11 56 12
51917 256537 Property Tree 8 Pinus radiata :: Monterey Pine 15 139 Olympia Way 1 Back Yard : Cutout Tree Private 2       3x3   5996818 2101849 37.7510942069084 -122.453862003079 (37.7510942069084, -122.453862003079) 1 5 4 63 38
89545 256543 Property Tree 8 Pinus radiata :: Monterey Pine 15 139 Olympia Way 1 Back Yard : Yard Tree Private 2       3x3   5996818 2101849 37.7510942069084 -122.453862003079 (37.7510942069084, -122.453862003079) 1 5 4 63 38
103546 113379 Property Tree 8 Fagus sylvatica :: European Beech 272 140 CASTENADA AVE 1 Front Yard : Yard Tree Private 2     50     5994437 2101097 37.7488926059174 -122.462041158848 (37.7488926059174, -122.462041158848) 1 8 4 29491 40
159644 120526 Property Tree 8 Pinus radiata :: Monterey Pine 15 1439 47th Ave 1 Back Yard : Yard Tree Private 2     20 3x3   5981489 2105275 37.7596102388302 -122.50712446854 (37.7596102388302, -122.50712446854) 1 8 3 56 35
122314 97023 Property Tree 8 Jacaranda mimosifolia :: Jacaranda 50 1443 Alabama St   Sidewalk: Curb side : Cutout Tree Private 2   08/16/2011 12:00:00 AM     Permit Number 768190 6009347.4 2100788.9 37.7488938036461 -122.410459018192 (37.7488938036461, -122.410459018192) 2 4 7 28859 19
94159 97024 Property Tree 8 Jacaranda mimosifolia :: Jacaranda 50 1455 Alabama St   Sidewalk: Curb side : Cutout Tree Private 2   08/16/2011 12:00:00 AM     Permit Number 768189 6009349 2100759.5 37.7488131674601 -122.410451409671 (37.7488131674601, -122.410451409671) 2 4 7 28859 19
105934 99256 Property Tree 8 Sequoia sempervirens :: Coast Redwood 155 1466 York St   Back Yard : Yard Tree Private 2           6010099 2100741 37.7488043872035 -122.407856595429 (37.7488043872035, -122.407856595429) 2 4 7 28859 19
177799 103504 Property Tree 8 Pinus radiata :: Monterey Pine 15 148 Huntington Dr 1 Back Yard : Yard Tree Private 2           5984515 2095210 37.7321522522788 -122.49591670505 (37.7321522522788, -122.49591670505) 1 8 4 64 35
39981 256672 Property Tree 8 Pinus radiata :: Monterey Pine 15 15 Kenwood Way 11 Back Yard : Yard Tree Private 2       30x30   5994751 2093714 37.7286387886762 -122.4604204683 (37.7286387886762, -122.4604204683) 9 8 4 59 40
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
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
95526 100139 Property Tree 8 Tree(s) :: 17 155 05th St 2 Front Yard : Yard Tree Private 2         Permit Number 769024 6011029.6 2112857.4 37.7821253339557 -122.405491786923 (37.7821253339557, -122.405491786923) 12 2 9 28853 34
20402 257888 Property Tree 8 Corymbia ficifolia :: Red Flowering Gum 28 155X Magellan Ave 1 Front Yard : Yard Tree MTA 3       10x10   5995070 2100842 37.7482288640106 -122.459833790503 (37.7482288640106, -122.459833790503) 1 8 4 29491 40
105992 258053 Property Tree 8 Pinus radiata :: Monterey Pine 15 1651 Portola Dr 1 Sidewalk: Property side : Yard Tree DPW 1       Width 5ft   5991822.8552 2096210.84451 37.7353256172728 -122.470724935722 (37.7353256172728, -122.470724935722) 1 8 4 59 40
46471 253626 Property Tree 8 Cupressus macrocarpa :: Monterey Cypress 41 1671 Funston Ave 1 Back Yard : Yard Tree Private 2       10x10   5992125 2104081 37.7569525124502 -122.470253253306 (37.7569525124502, -122.470253253306) 1 8 4 56 12
183601 256482 Property Tree 8 Pinus radiata :: Monterey Pine 15 168 Moultrie St 1 Back Yard : Cutout Tree Private 2       3x3   6007766 2098288 37.7419381097545 -122.415750458671 (37.7419381097545, -122.415750458671) 2 7 7 28859 2
171323 253471 Property Tree 8 Sequoiadendron giganteum :: Sierra Redwood 240 17 Valletta Ct 1 Side Yard : Yard Tree Private 2       6x10   5999337 2096545 37.7366747995559 -122.444769861358 (37.7366747995559, -122.444769861358) 9 7 4 63 40
3739 261012 Property Tree 8 Pinus canariensis :: Canary Island Pine 35 170 Otis St 2 Front Yard : Cutout Tree Private 2       3x3   6006561 2108839 37.7708409033816 -122.420665800575 (37.7708409033816, -122.420665800575) 8 2 9 28853 19
18405 261011 Property Tree 8 Pinus canariensis :: Canary Island Pine 35 170 Otis St 1 Front Yard : Cutout Tree Private 2       3x3   6006561 2108839 37.7708409033816 -122.420665800575 (37.7708409033816, -122.420665800575) 8 2 9 28853 19
99909 96676 Property Tree 8 Prunus spp :: Cherry 68 1701 21st Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   06/22/2011 12:00:00 AM       5989644.3 2103769.9 37.7559545815884 -122.478809598698 (37.7559545815884, -122.478809598698) 1 8 3 56 35
28785 122558 Property Tree 8 Pinus radiata :: Monterey Pine 15 1760 Diamond St 1 Back Yard : Yard Tree Private 2     20 3x3   6001927 2098732 37.7428272563398 -122.435971568238 (37.7428272563398, -122.435971568238) 2 7 5 63 22
9668 264919 Property Tree 8 Olea Majestic Beauty :: 183 1833 Page St 1 Sidewalk: Property side : Yard Tree Public Library 12       3x3   5997789 2108763 37.7701339345343 -122.451002717521 (37.7701339345343, -122.451002717521) 15 5 11 29492 9
142995 108574 Property Tree 8 Tree(s) :: 17 1891 15th St 1 Back Yard : Yard Tree Private 2       7x8   6004884.86016 2107160.44126 37.7661373754728 -122.426344078904 (37.7661373754728, -122.426344078904) 8 4 5 28853 19
22321 256538 Property Tree 8 Cupressus macrocarpa :: Monterey Cypress 41 19 Miguel St 1 Back Yard : Yard Tree Private 2       3x3   6003470 2097467 37.7394413932778 -122.430546066859 (37.7394413932778, -122.430546066859) 2 7 5 63 7
135134 113440 Property Tree 8 Cupressus macrocarpa :: Monterey Cypress 41 190 BEACON ST   Back Yard : Yard Tree Private 2     32 3x3   6003193 2097540 37.7396261385587 -122.431509020833 (37.7396261385587, -122.431509020833) 2 7 5 63 7
45129 98465 Property Tree 8 Tree(s) :: 17 190 Portola Dr   Back Yard : Yard Landscaping Private 2           5999550.3 2100620.3 37.7478767693988 -122.444325170302 (37.7478767693988, -122.444325170302) 2 5 5 63 38
55834 121404 Property Tree 8 Sequoia sempervirens :: Coast Redwood 155 1900 08th Ave 1 Back Yard : Yard Tree Private 2     3 10x10   5993817 2102486 37.7526707300666 -122.464285931649 (37.7526707300666, -122.464285931649) 1 8 4 29491 40
30618 97004 Property Tree 8 Callistemon viminalis :: Weeping Bottlebrush 60 195A Kiska Rd   Sidewalk: Property side : Cutout Tree Housing Authority 15 FUF         6019164.1 2093438.1 37.7292553954157 -122.376002845114 (37.7292553954157, -122.376002845114) 10 3 8 58 1
125967 96999 Property Tree 8 Callistemon viminalis :: Weeping Bottlebrush 60 195A Kiska Rd   Sidewalk: Property side : Cutout Tree Housing Authority 15 FUF         6019164.1 2093438.1 37.7292553954157 -122.376002845114 (37.7292553954157, -122.376002845114) 10 3 8 58 1
28806 97041 Property Tree 8 Hakea suaveolens :: Sweet Hakea Tree 73 195B Kiska Rd   Sidewalk: Property side : Cutout Tree Housing Authority 15 FUF         6019164.1 2093438.1 37.7292553954157 -122.376002845114 (37.7292553954157, -122.376002845114) 10 3 8 58 1
30764 97025 Property Tree 8 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 195B Kiska Rd   Sidewalk: Property side : Cutout Tree Housing Authority 15 FUF         6019164.1 2093438.1 37.7292553954157 -122.376002845114 (37.7292553954157, -122.376002845114) 10 3 8 58 1
33597 97039 Property Tree 8 Hakea suaveolens :: Sweet Hakea Tree 73 195B Kiska Rd   Sidewalk: Property side : Cutout Tree Housing Authority 15 FUF         6019164.1 2093438.1 37.7292553954157 -122.376002845114 (37.7292553954157, -122.376002845114) 10 3 8 58 1
35599 97045 Property Tree 8 Olea europaea 'Wilsonii' :: Wilson Olive Semi-fruitless 181 195B Kiska Rd   Sidewalk: Property side : Cutout Tree Housing Authority 15 FUF         6019164.1 2093438.1 37.7292553954157 -122.376002845114 (37.7292553954157, -122.376002845114) 10 3 8 58 1
40665 97022 Property Tree 8 Umbellularia californica :: California Bay 326 195B Kiska Rd   Sidewalk: Property side : Cutout Tree Housing Authority 15 FUF         6019164.1 2093438.1 37.7292553954157 -122.376002845114 (37.7292553954157, -122.376002845114) 10 3 8 58 1
41028 97042 Property Tree 8 Heteromeles arbutifolia :: Toyon 186 195B Kiska Rd   Sidewalk: Property side : Cutout Tree Housing Authority 15 FUF         6019164.1 2093438.1 37.7292553954157 -122.376002845114 (37.7292553954157, -122.376002845114) 10 3 8 58 1
41321 97014 Property Tree 8 Prunus ilicifoia :: Holly-leaved Cherry 245 195B Kiska Rd   Sidewalk: Property side : Cutout Tree Housing Authority 15 FUF         6019164.1 2093438.1 37.7292553954157 -122.376002845114 (37.7292553954157, -122.376002845114) 10 3 8 58 1
44692 97015 Property Tree 8 Prunus ilicifoia :: Holly-leaved Cherry 245 195B Kiska Rd   Sidewalk: Property side : Cutout Tree Housing Authority 15 FUF         6019164.1 2093438.1 37.7292553954157 -122.376002845114 (37.7292553954157, -122.376002845114) 10 3 8 58 1
56664 97021 Property Tree 8 Quercus agrifolia :: Coast Live Oak 172 195B Kiska Rd   Sidewalk: Property side : Cutout Tree Housing Authority 15 FUF         6019164.1 2093438.1 37.7292553954157 -122.376002845114 (37.7292553954157, -122.376002845114) 10 3 8 58 1
62691 97040 Property Tree 8 Hakea suaveolens :: Sweet Hakea Tree 73 195B Kiska Rd   Sidewalk: Property side : Cutout Tree Housing Authority 15 FUF         6019164.1 2093438.1 37.7292553954157 -122.376002845114 (37.7292553954157, -122.376002845114) 10 3 8 58 1

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