trees
341 rows where qLegalStatus_id = 8 sorted by Neighborhoods (old)
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) ▼ |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
149052 | 105232 | Property Tree 8 | Pinus radiata :: Monterey Pine 15 | 460X ROOSEVELT WAY | 2 | Front Yard : Yard | Tree | Private 2 | 17 | 5999944 | 2106286 | 37.7634558498539 | -122.443370673769 | (37.7634558498539, -122.443370673769) | 15 | 5 | 5 | 29492 | 3 | ||||
149268 | 106458 | Property Tree 8 | Tree(s) :: 17 | 71 HANCOCK ST | Back Yard : Yard | Tree | Private 2 | 6003861.6 | 2105050 | 37.7602847161222 | -122.429732794413 | (37.7602847161222, -122.429732794413) | 2 | 4 | 5 | 28862 | 3 | ||||||
156111 | 96589 | Property Tree 8 | Eriobotrya deflexa :: Bronze Loquat 8 | 450 Church St | Sidewalk: Property side : Cutout | Tree | SFUSD 4 | FUF | 6004088.8 | 2106523.6 | 37.7643437320395 | -122.429052084094 | (37.7643437320395, -122.429052084094) | 8 | 4 | 5 | 28862 | 3 | |||||
158127 | 104008 | Property Tree 8 | Pinus radiata :: Monterey Pine 15 | 357 Collingwood St | 1 | Back Yard : Yard | Tree | Private 2 | 36 | 6002124 | 2103789 | 37.7567237682266 | -122.435652112093 | (37.7567237682266, -122.435652112093) | 2 | 4 | 5 | 28862 | 3 | ||||
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 | ||||||
175776 | 256557 | Property Tree 8 | Acer rubrum :: Red Maple 75 | 3401X 16th St | 6 | Side Yard : Yard | Tree | SFUSD 4 | 02/08/2019 08:44:00 AM | 3 | 3x3 | 6004088 | 2106523 | 37.7643420392989 | -122.429054808288 | (37.7643420392989, -122.429054808288) | 8 | 4 | 5 | 28862 | 3 | ||
176971 | 256553 | Property Tree 8 | Acer rubrum :: Red Maple 75 | 3401X 16th St | 2 | Side Yard : Yard | Tree | SFUSD 4 | 02/08/2019 09:24:00 AM | 3 | 3x3 | 6004088 | 2106523 | 37.7643420392989 | -122.429054808288 | (37.7643420392989, -122.429054808288) | 8 | 4 | 5 | 28862 | 3 | ||
179317 | 103673 | Property Tree 8 | :: 45 | 64 Henry St | Back Yard : Yard | Tree | Private 2 | 6003097 | 2107420 | 37.7667488371496 | -122.432546472662 | (37.7667488371496, -122.432546472662) | 15 | 5 | 5 | 28862 | 3 | ||||||
183841 | 252835 | Property Tree 8 | Eucalyptus nicholii :: Nichol's Willow-Leafed Peppermint 230 | 98 Prosper St | 3 | Sidewalk: Property side : Cutout | Tree | Private 2 | 6003330 | 2106021 | 37.7629207320267 | -122.431640673814 | (37.7629207320267, -122.431640673814) | 15 | 4 | 5 | 28862 | 3 | |||||
184992 | 96603 | Property Tree 8 | Citrus × meyeri 'Improved' :: Improved Meyer Lemon 317 | 325 Sanchez St | Sidewalk: Property side : Cutout | Tree | SFUSD 4 | FUF | 6003898 | 2106263.7 | 37.7636193068731 | -122.429693469686 | (37.7636193068731, -122.429693469686) | 8 | 4 | 5 | 28862 | 3 | |||||
186894 | 96605 | Property Tree 8 | Citrus × meyeri 'Improved' :: Improved Meyer Lemon 317 | 325 Sanchez St | Sidewalk: Property side : Cutout | Tree | SFUSD 4 | FUF | 6003898 | 2106263.7 | 37.7636193068731 | -122.429693469686 | (37.7636193068731, -122.429693469686) | 8 | 4 | 5 | 28862 | 3 | |||||
189291 | 256552 | Property Tree 8 | Acer rubrum :: Red Maple 75 | 3401X 16th St | 1 | Side Yard : Yard | Tree | SFUSD 4 | 02/08/2019 08:54:00 AM | 3 | 3x3 | 6004088 | 2106523 | 37.7643420392989 | -122.429054808288 | (37.7643420392989, -122.429054808288) | 8 | 4 | 5 | 28862 | 3 | ||
136282 | 110181 | Property Tree 8 | Magnolia grandiflora :: Southern Magnolia 19 | 2620 Sutter St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | 1.5x4 | 5999902.8272 | 2114053.62 | 37.7847814144727 | -122.444071244627 | (37.7847814144727, -122.444071244627) | 15 | 6 | 1 | 29490 | 31 | |||
46823 | 103516 | Property Tree 8 | Cupressus macrocarpa :: Monterey Cypress 41 | 980 Green St | 1 | Back Yard : Yard | Tree | Private 2 | 6008298 | 2118971 | 37.7987586699451 | -122.415374854445 | (37.7987586699451, -122.415374854445) | 5 | 1 | 10 | 308 | 32 | |||||
20715 | 99276 | Property Tree 8 | Tree(s) :: 17 | 85X 10th St | 2 | Front Yard : Yard | Tree | Private 2 | 04/25/2012 12:00:00 AM | Permit Number 768878 | 6007907.6 | 2110517 | 37.7755240963356 | -122.416126724722 | (37.7755240963356, -122.416126724722) | 8 | 2 | 9 | 28853 | 34 | |||
30353 | 105684 | Property Tree 8 | Ficus microcarpa :: Chinese Banyan 97 | 635 08TH ST | 1 | Front Yard : Pot | Tree | Private 2 | 10 | 6011418.5 | 2109097.9 | 37.7718243537934 | -122.403881727597 | (37.7718243537934, -122.403881727597) | 14 | 2 | 9 | 28853 | 34 | ||||
33251 | 105685 | Property Tree 8 | Ficus microcarpa :: Chinese Banyan 97 | 635 08TH ST | 2 | Front Yard : Pot | Tree | Private 2 | 8 | 6011418.5 | 2109097.9 | 37.7718243537934 | -122.403881727597 | (37.7718243537934, -122.403881727597) | 14 | 2 | 9 | 28853 | 34 | ||||
89589 | 99277 | Property Tree 8 | Tree(s) :: 17 | 85X 10th St | 3 | Front Yard : Yard | Tree | Private 2 | 04/25/2012 12:00:00 AM | Permit Number 768878 | 6007907.6 | 2110517 | 37.7755240963356 | -122.416126724722 | (37.7755240963356, -122.416126724722) | 8 | 2 | 9 | 28853 | 34 | |||
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 | ||||
103261 | 99275 | Property Tree 8 | Tree(s) :: 17 | 85X 10th St | 1 | Front Yard : Yard | Tree | Private 2 | 04/25/2012 12:00:00 AM | Permit Number 768878 | 6007907.6 | 2110517 | 37.7755240963356 | -122.416126724722 | (37.7755240963356, -122.416126724722) | 8 | 2 | 9 | 28853 | 34 | |||
104699 | 114731 | Property Tree 8 | Eucalyptus globulus :: Blue Gum 56 | 934 BRANNAN ST | Back Yard : Yard | Tree | Private 2 | Dept of Real Estate | 10x10 | 6010724 | 2108745 | 37.7708165471861 | -122.406259194073 | (37.7708165471861, -122.406259194073) | 14 | 2 | 9 | 28853 | 34 | ||||
145638 | 105686 | Property Tree 8 | Ficus microcarpa :: Chinese Banyan 97 | 635 08TH ST | 3 | Front Yard : Pot | Tree | Private 2 | 6 | 6011418.5 | 2109097.9 | 37.7718243537934 | -122.403881727597 | (37.7718243537934, -122.403881727597) | 14 | 2 | 9 | 28853 | 34 | ||||
183366 | 251343 | Property Tree 8 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 42 | 934 Brannan St | 1 | Back Yard : Yard | Tree | Private 2 | 3x3 | 6010724 | 2108745 | 37.7708165471861 | -122.406259194073 | (37.7708165471861, -122.406259194073) | 14 | 2 | 9 | 28853 | 34 | ||||
189109 | 120533 | Property Tree 8 | Eucalyptus globulus :: Blue Gum 56 | 951 Brannan St | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | 22 | 3x3 | 6010745 | 2108673 | 37.7706200263658 | -122.406181480785 | (37.7706200263658, -122.406181480785) | 14 | 2 | 9 | 28853 | 34 | |||
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 | ||||
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 | ||||
96282 | 117254 | Property Tree 8 | Pinus radiata :: Monterey Pine 15 | 2067 33RD AVE | 1 | Back Yard : Yard | Tree | Private 2 | 3x3 | 5985987 | 2101171 | 37.7486056682842 | -122.491266304796 | (37.7486056682842, -122.491266304796) | 1 | 8 | 3 | 29491 | 35 | ||||
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 | ||||
112077 | 253339 | Property Tree 8 | Cupressus macrocarpa :: Monterey Cypress 41 | 2019X 24th Ave | 1 | Sidewalk: Property side : Yard | Tree | PUC 8 | 3x3 | 5988853 | 2101569 | 37.7498655183494 | -122.481384971136 | (37.7498655183494, -122.481384971136) | 1 | 8 | 3 | 29491 | 35 | ||||
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 | |||
168913 | 114365 | Property Tree 8 | Pinus radiata :: Monterey Pine 15 | 2546 28th Ave | 1 | Back Yard : Yard | Tree | Private 2 | 35 | 5987735.7 | 2097954.4 | 37.7398757613896 | -122.484983441996 | (37.7398757613896, -122.484983441996) | 1 | 8 | 3 | 29491 | 35 | ||||
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 | |||||
19898 | 98265 | Property Tree 8 | Pinus pinea :: Italian Stone Pine 63 | 755 O'Farrell St | Back Yard : Yard | Tree | Private 2 | Backyard tree; not significant | 6007700 | 2113968.3 | 37.7849888609023 | -122.417089467607 | (37.7849888609023, -122.417089467607) | 7 | 10 | 9 | 28858 | 36 | |||||
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 | ||||
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 | ||||
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 | ||||
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 | ||||
10460 | 258772 | Property Tree 8 | Cupressus spp :: Cypress species 337 | 20 Crestline Dr | 1 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | Private | 3x3 | 5999139 | 2101332 | 37.7498074496931 | -122.445798597569 | (37.7498074496931, -122.445798597569) | 2 | 5 | 5 | 63 | 38 | |||
15601 | 99374 | Property Tree 8 | Pinus radiata :: Monterey Pine 15 | 21 Panorama Dr | Back Yard : Yard | Tree | Private 2 | 24 | 5998009 | 2100230 | 37.7467170430405 | -122.449626769288 | (37.7467170430405, -122.449626769288) | 1 | 5 | 4 | 63 | 38 | |||||
30200 | 98503 | Property Tree 8 | Cupressus macrocarpa :: Monterey Cypress 41 | 208 Glenview Dr | Back Yard : Yard | Tree | Private 2 | 5998871 | 2100779 | 37.7482737407191 | -122.446685565827 | (37.7482737407191, -122.446685565827) | 2 | 5 | 5 | 63 | 38 | ||||||
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 | ||||||
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 | ||||
54211 | 98502 | Property Tree 8 | Tree(s) :: 17 | 244 Glenview Dr | Back Yard : Yard | Landscaping | Private 2 | 5999066 | 2100737 | 37.7481695560511 | -122.446008243376 | (37.7481695560511, -122.446008243376) | 2 | 5 | 5 | 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 | ||||
90504 | 98893 | Property Tree 8 | Tree(s) :: 17 | 216 Glenview Dr | Back Yard : Yard | Landscaping | Private 2 | 5998910 | 2100761 | 37.7482265448319 | -122.446549410607 | (37.7482265448319, -122.446549410607) | 2 | 5 | 5 | 63 | 38 | ||||||
92957 | 257936 | Property Tree 8 | Pinus radiata :: Monterey Pine 15 | 375 Woodside Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 3x3 | 5997267 | 2099886 | 37.7457300260474 | -122.452167701039 | (37.7457300260474, -122.452167701039) | 1 | 5 | 4 | 59 | 38 | ||||
99841 | 98436 | Property Tree 8 | Tree(s) :: 17 | 238 Glenview Dr | Back Yard : Yard | Tree | Private 2 | 5999035 | 2100736 | 37.7481650400364 | -122.446115368035 | (37.7481650400364, -122.446115368035) | 2 | 5 | 5 | 63 | 38 | ||||||
105747 | 98892 | Property Tree 8 | Tree(s) :: 17 | 220 Glenview Dr | Back Yard : Yard | Landscaping | Private 2 | 5998935 | 2100753 | 37.7482060067302 | -122.44646238624 | (37.7482060067302, -122.44646238624) | 2 | 5 | 5 | 63 | 38 | ||||||
113384 | 98890 | Property Tree 8 | Tree(s) :: 17 | 256 Glenview Dr | Back Yard : Yard | Landscaping | Private 2 | 5999134 | 2100748 | 37.7482036421854 | -122.44577389345 | (37.7482036421854, -122.44577389345) | 2 | 5 | 5 | 63 | 38 | ||||||
124235 | 122518 | Property Tree 8 | Pinus radiata :: Monterey Pine 15 | 772X Panorama Dr | 1 | Back Yard : Cutout | Tree | Private 2 | 3x3 | 5996713 | 2102901 | 37.7539767153501 | -122.45430108189 | (37.7539767153501, -122.45430108189) | 1 | 5 | 4 | 63 | 38 | ||||
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 | ||||||
137488 | 98501 | Property Tree 8 | Tree(s) :: 17 | 232 Glenview Dr | Back Yard : Yard | Landscaping | Private 2 | 5998998 | 2100740 | 37.7481739100487 | -122.446243600021 | (37.7481739100487, -122.446243600021) | 2 | 5 | 5 | 63 | 38 | ||||||
176576 | 257935 | Property Tree 8 | Pinus radiata :: Monterey Pine 15 | 375 Woodside Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 3x3 | 5997267 | 2099886 | 37.7457300260474 | -122.452167701039 | (37.7457300260474, -122.452167701039) | 1 | 5 | 4 | 59 | 38 | ||||
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 | ||||||
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 | ||||||
13403 | 261178 | Property Tree 8 | Phoenix canariensis :: Canary Island Date Palm 160 | 205 Leland Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6009827 | 2087549 | 37.7125667222905 | -122.407867055005 | (37.7125667222905, -122.407867055005) | 9 | 7 | 8 | 309 | 39 | ||||
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 | ||||
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 | ||||
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 | |||||
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 | ||||
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 | ||||
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 | ||||
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 | ||||
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 | |||||
13832 | 259913 | Property Tree 8 | Pinus radiata :: Monterey Pine 15 | 23 Cresta Vista Dr | 1 | Back Yard : Yard | Tree | Private 2 | 3x3 | 5995254 | 2096176 | 37.7354277647167 | -122.45885975654 | (37.7354277647167, -122.45885975654) | 9 | 7 | 4 | 59 | 40 | ||||
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 | ||||
20664 | 121198 | Property Tree 8 | Cordyline australis :: Dracena Palm 64 | 2521 18th Ave | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | 3 | 3x3 | 5990743 | 2098231 | 37.740809941753 | -122.47460574514 | (37.740809941753, -122.47460574514) | 1 | 8 | 4 | 29491 | 40 | |||
30075 | 100070 | Property Tree 8 | Tree(s) :: 17 | 331 Serrano Dr | 1 | Front Yard : Yard | Tree | Private 2 | Permit Number 777990 | 5990400 | 2090718 | 37.7201612636948 | -122.475243338807 | (37.7201612636948, -122.475243338807) | 1 | 8 | 4 | 64 | 40 | ||||
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 | |||||
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 | ||||
44661 | 102745 | Property Tree 8 | Cupressus macrocarpa :: Monterey Cypress 41 | 222 Moncada Way | 1 | Front Yard : Yard | Tree | Private 2 | 5992354 | 2093377.4 | 37.7275763858966 | -122.468682482409 | (37.7275763858966, -122.468682482409) | 9 | 8 | 4 | 59 | 40 | |||||
53937 | 94690 | Property Tree 8 | Brachychiton populneus :: Bottle Tree 348 | 749 Congo St | Front Yard : Yard | Tree | Private 2 | 10/28/2010 12:00:00 AM | Permit Number 53820 | 6000274 | 2096023 | 37.735294937499 | -122.441492809367 | (37.735294937499, -122.441492809367) | 9 | 7 | 4 | 63 | 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 | ||||
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 | |||
75016 | 98140 | Property Tree 8 | Cupressus macrocarpa :: Monterey Cypress 41 | 315 San Marcos Ave | Front Yard : Yard | Tree | Private 2 | 5992920.8 | 2100212.1 | 37.7463754865467 | -122.467219803339 | (37.7463754865467, -122.467219803339) | 1 | 8 | 4 | 29491 | 40 | ||||||
75714 | 114950 | Property Tree 8 | Pinus radiata :: Monterey Pine 15 | 1X WOODACRE DR | 2 | unknown : Yard | Tree | DPW 1 | 30x100 | 5991187 | 2095315 | 37.7328290635508 | -122.472857998502 | (37.7328290635508, -122.472857998502) | 1 | 8 | 4 | 64 | 40 | ||||
89692 | 122453 | Property Tree 8 | Pinus radiata :: Monterey Pine 15 | 217 San Marcos Ave | 1 | Back Yard : Yard | Tree | Private 2 | 10x10 | 5993325.07095 | 2100296.14299 | 37.7466295758311 | -122.465827998209 | (37.7466295758311, -122.465827998209) | 1 | 8 | 4 | 29491 | 40 | ||||
97665 | 121104 | Property Tree 8 | Pinus radiata :: Monterey Pine 15 | 477 Myra Way | 1 | Back Yard : Yard | Tree | Private 2 | 3x3 | 5997298 | 2097021 | 37.7378652095891 | -122.45185385939 | (37.7378652095891, -122.45185385939) | 9 | 7 | 4 | 59 | 40 | ||||
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 | ||||
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 | ||||
107546 | 112377 | Property Tree 8 | Eucalyptus sideroxylon :: Red Ironbark 127 | 801 ULLOA ST | 3 | Sidewalk: Curb side : Cutout | Tree | MTA 3 | 36 | 5993401 | 2098089 | 37.7405736985828 | -122.465405140197 | (37.7405736985828, -122.465405140197) | 1 | 8 | 4 | 59 | 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 | ||||
129920 | 106227 | Property Tree 8 | Eucalyptus globulus :: Blue Gum 56 | 38 Stanford Heights Ave | 1 | Back Yard : Yard | Tree | Private 2 | 5997884 | 2095808.5 | 37.7345695210024 | -122.44974042874 | (37.7345695210024, -122.44974042874) | 9 | 7 | 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 | ||||
131293 | 254124 | Property Tree 8 | Pinus radiata :: Monterey Pine 15 | 365 Edgehill Way | 1 | Back Yard : Cutout | Tree | Private 2 | 3x3 | 5994964 | 2098864 | 37.7427916745102 | -122.460057057879 | (37.7427916745102, -122.460057057879) | 1 | 8 | 4 | 59 | 40 | ||||
133884 | 114949 | Property Tree 8 | Pinus radiata :: Monterey Pine 15 | 1X WOODACRE DR | 1 | unknown : Yard | Tree | DPW 1 | 30 | 30x100 | 5991187 | 2095315 | 37.7328290635508 | -122.472857998502 | (37.7328290635508, -122.472857998502) | 1 | 8 | 4 | 64 | 40 | |||
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 | |||||
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 | ||||
148738 | 252848 | Property Tree 8 | Pinus halepensis :: Allepo Pine 330 | 99 Reposa Way | 1 | Back Yard : Yard | Tree | Private 2 | 3x3 | 5998022 | 2098104 | 37.7408803073177 | -122.44942865965 | (37.7408803073177, -122.44942865965) | 9 | 7 | 4 | 59 | 40 | ||||
150726 | 106275 | Property Tree 8 | Eucalyptus globulus :: Blue Gum 56 | 42 Stanford Heights Ave | 1 | Back Yard : Yard | Tree | Private 2 | 5997882.5 | 2095834.4 | 37.7346405503947 | -122.449747480555 | (37.7346405503947, -122.449747480555) | 9 | 7 | 4 | 59 | 40 | |||||
157400 | 97685 | Property Tree 8 | Cupressus macrocarpa :: Monterey Cypress 41 | 84 Coventry Ct | Back Yard : Yard | Tree | Private 2 | 5997084 | 2096485 | 37.7363812239889 | -122.452555087132 | (37.7363812239889, -122.452555087132) | 9 | 7 | 4 | 59 | 40 | ||||||
167578 | 100472 | Property Tree 8 | Pinus radiata :: Monterey Pine 15 | 70 Stanford Heights Ave | Back Yard : Yard | Tree | Private 2 | 5997872.4 | 2096006.9 | 37.735113616296 | -122.449794826729 | (37.735113616296, -122.449794826729) | 9 | 7 | 4 | 59 | 40 | ||||||
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 | ||||
176195 | 102381 | Property Tree 8 | Pinus radiata :: Monterey Pine 15 | 258 Molimo Dr | Back Yard : Yard | Tree | Private 2 | 5997615 | 2096604 | 37.7367383790998 | -122.450727783905 | (37.7367383790998, -122.450727783905) | 9 | 7 | 4 | 59 | 40 | ||||||
176836 | 102639 | Property Tree 8 | Pinus radiata :: Monterey Pine 15 | 251 Dorado Ter | 1 | Back Yard : Yard | Tree | Private 2 | 5994312.1 | 2092840.7 | 37.7262156610351 | -122.461874461465 | (37.7262156610351, -122.461874461465) | 9 | 8 | 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 | ||||
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 | ||||
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 | ||||
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 |
Advanced export
JSON shape: default, array, newline-delimited, object
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) );