Data source: data.sfgov.org
This data as json, CSV (advanced)
Link | rowid | TreeID | qLegalStatus | qSpecies ▼ | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
24784 | 24784 | 232225 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 4 Germania St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 8 | Width 3ft | 6004247.320040001 | 2108919.60304 | 37.7709315496771 | -122.42867461895099 | (37.7709315496771, -122.428674618951) | |||
24937 | 24937 | 250897 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 257 29th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 7 | Width 4ft | 5986796.26236 | 2114206.96718 | 37.7844460622777 | -122.489426325065 | (37.7844460622777, -122.489426325065) | |||
25276 | 25276 | 183998 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1600 Sunset Blvd | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 18 | Width 0ft | 5984888.9105 | 2103901.6725 | 37.756039119583896 | -122.495264775736 | (37.7560391195839, -122.495264775736) | |||
25670 | 25670 | 232568 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 947 Elizabeth St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 18 | Width 4ft | 6000344.26845 | 2101952.87409 | 37.7515809640038 | -122.441675290387 | (37.7515809640038, -122.441675290387) | |||
25868 | 25868 | 250400 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 15 Seacliff Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 16 | Width 4ft | 5988097.76743 | 2115798.38338 | 37.78889152896829 | -122.485040420476 | (37.7888915289683, -122.485040420476) | |||
25989 | 25989 | 118011 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 450 37th Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 12 | Width 6ft | 5984411.11276 | 2112748.04652 | 37.7803007642443 | -122.49757024513599 | (37.7803007642443, -122.497570245136) | |||
26090 | 26090 | 213188 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 2 Miramar Ave | 4 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 17 | Width 3ft | 5995345.1879900005 | 2090017.69868 | 37.7185237930134 | -122.45809893804301 | (37.7185237930134, -122.458098938043) | |||
26093 | 26093 | 184237 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1560 43rd Ave | 5 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 6 | Width 0ft | 5982827.6965 | 2104602.0583 | 37.7578412848543 | -122.502444857851 | (37.7578412848543, -122.502444857851) | |||
26198 | 26198 | 185271 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 2601 Sunset Blvd | 4 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 25 | Width 0ft | 5985035.5152 | 2097142.4375 | 37.7374886824299 | -122.494259580727 | (37.7374886824299, -122.494259580727) | |||
26331 | 26331 | 250442 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 120 Seacliff Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 11 | Width 4ft | 5987556.70189 | 2115799.09081 | 37.788861940370495 | -122.486912460967 | (37.7888619403705, -122.486912460967) | |||
26455 | 26455 | 250503 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 27 27th Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 12 | 5987219.4973 | 2115634.05688 | 37.7883891388944 | -122.488066995303 | (37.7883891388944, -122.488066995303) | ||||
26566 | 26566 | 250534 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 70 25th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 15 | Width 5ft | 5988031.60804 | 2115549.24332 | 37.7882036078474 | -122.485251031835 | (37.7882036078474, -122.485251031835) | |||
26931 | 26931 | 186521 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1501 Sunset Blvd | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 1 | Width 0ft | 5984773.9175 | 2104835.1255 | 37.758595388813895 | -122.49573130554701 | (37.7585953888139, -122.495731305547) | |||
27136 | 27136 | 185855 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 2000 Sunset Blvd | 5 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 19 | Width 0ft | 5984970.1707 | 2101389.2867 | 37.7491455567358 | -122.494798527696 | (37.7491455567358, -122.494798527696) | |||
27308 | 27308 | 250384 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 50 25th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 15 | Width 4ft | 5988135.84849 | 2115619.53248 | 37.7884026736885 | -122.48489554060801 | (37.7884026736885, -122.484895540608) | |||
27392 | 27392 | 141239 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 27 COMMONWEALTH AVE | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 8 | Width 0ft | 5996486.1818 | 2114396.2408 | 37.7855266603489 | -122.455916422904 | (37.7855266603489, -122.455916422904) | |||
27677 | 27677 | 118507 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 8149 Geary Blvd | 6 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 19 | 5981701.912719999 | 2112329.1151099997 | 37.7789913275143 | -122.506911374832 | (37.7789913275143, -122.506911374832) | ||||
27686 | 27686 | 118503 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 8149 Geary Blvd | 7 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 21 | 5981708.0026 | 2112322.43934 | 37.7789733564528 | -122.506889812546 | (37.7789733564528, -122.506889812546) | ||||
27693 | 27693 | 183999 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1600 Sunset Blvd | 4 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 20 | Width 0ft | 5984882.0685 | 2103992.5736 | 37.7562883082283 | -122.49529514071399 | (37.7562883082283, -122.495295140714) | |||
27761 | 27761 | 185148 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 2500 Sunset Blvd | 4 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 16 | Width 0ft | 5985103.2864 | 2097852.3368 | 37.739441841296895 | -122.494077573061 | (37.7394418412969, -122.494077573061) | |||
27854 | 27854 | 186004 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1900 Sunset Blvd | 4 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 7 | Width 0ft | 5984957.0471 | 2102005.2828 | 37.7508361451113 | -122.49488932117599 | (37.7508361451113, -122.494889321176) | |||
27976 | 27976 | 232209 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 6 Park Hill Ave | 12 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 9 | Width 3ft | 6001153.56951 | 2107660.61538 | 37.767299106985895 | -122.43928570537201 | (37.7672991069859, -122.439285705372) | |||
28280 | 28280 | 184225 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1500 Sunset Blvd | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 15 | Width 0ft | 5984863.4973 | 2104582.9422 | 37.757908209196295 | -122.495402904025 | (37.7579082091963, -122.495402904025) | |||
28356 | 28356 | 218340 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 15 Montalvo Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 18 | Width 0ft | 5993385.71505 | 2099910.6129400004 | 37.745574506277 | -122.465590295159 | (37.745574506277, -122.465590295159) | |||
28520 | 28520 | 184001 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1600 Sunset Blvd | 6 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 18 | Width 0ft | 5984878.1588 | 2104167.5339 | 37.75676847179471 | -122.49532156409501 | (37.7567684717947, -122.495321564095) | |||
28606 | 28606 | 231203 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 100 27th St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 12 | Width 6ft | 6005825.85771 | 2100250.83508 | 37.747218351845 | -122.42259830188401 | (37.747218351845, -122.422598301884) | |||
28753 | 28753 | 185147 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 2500 Sunset Blvd | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | Width 0ft | 5985105.4901 | 2097791.7341 | 37.7392755715004 | -122.49406548841002 | (37.7392755715004, -122.49406548841) | |||
29024 | 29024 | 250839 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 279 30th Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 11 | Width 4ft | 5986490.65681 | 2114065.90845 | 37.784040910496394 | -122.490473219563 | (37.7840409104964, -122.490473219563) | |||
29048 | 29048 | 122293 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1251 Cabrillo St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 11 | Width 4ft | 5991705.57718 | 2110632.0046 | 37.7749155630287 | -122.472181268961 | (37.7749155630287, -122.472181268961) | |||
29219 | 29219 | 183568 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1924 Vicente St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 12 | Width 0ft | 5986954.5181 | 2097602.4506 | 37.7388638688835 | -122.48765855727801 | (37.7388638688835, -122.487658557278) | |||
29371 | 29371 | 213185 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 19 Miramar Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 18 | Width 3ft | 5995302.01612 | 2090045.76886 | 37.718598386389395 | -122.45825019500799 | (37.7185983863894, -122.458250195008) | |||
29505 | 29505 | 232202 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 6 Park Hill Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 10 | Width 3ft | 6001140.121230001 | 2107884.16884 | 37.7679121640509 | -122.439348246927 | (37.7679121640509, -122.439348246927) | |||
29567 | 29567 | 232600 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 4250 22nd St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 12 | Width 3ft | 6000850.48097 | 2102900.2544400003 | 37.754211070904 | -122.43999267144899 | (37.754211070904, -122.439992671449) | |||
29996 | 29996 | 131246 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 2759 Broderick St | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 12 | Width 6ft | 6000062.75843 | 2118080.3525400003 | 37.7958468901791 | -122.443807334766 | (37.7958468901791, -122.443807334766) | |||
30344 | 30344 | 186528 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1501 Sunset Blvd | 9 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | Width 0ft | 5984787.1073 | 2104437.5473 | 37.7575045220907 | -122.49565636460301 | (37.7575045220907, -122.495656364603) | |||
30608 | 30608 | 177659 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 100 Mansell St | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 12 | Width 3ft | 6011473.42215 | 2090717.42054 | 37.7213586009108 | -122.402399119539 | (37.7213586009108, -122.402399119539) | |||
30687 | 30687 | 140795 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 84 COMMONWEALTH AVE | 4 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 14 | Width 0ft | 5996553.5278 | 2114036.4984 | 37.7845427685934 | -122.455657414651 | (37.7845427685934, -122.455657414651) | |||
30864 | 30864 | 185856 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 2000 Sunset Blvd | 6 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 19 | Width 0ft | 5984965.8819 | 2101478.1255 | 37.7493892327353 | -122.494819907364 | (37.7493892327353, -122.494819907364) | |||
30891 | 30891 | 184223 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1500 Sunset Blvd | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 10 | Width 0ft | 5984870.3393 | 2104425.5758 | 37.7574765253969 | -122.49536763632099 | (37.7574765253969, -122.495367636321) | |||
31492 | 31492 | 186408 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1601 Sunset Blvd | 4 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 19 | Width 0ft | 5984803.9609 | 2103958.4227 | 37.7561899658562 | -122.49556274094601 | (37.7561899658562, -122.495562740946) | |||
31752 | 31752 | 250543 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 98 25th Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 15 | Width 5ft | 5988034.75992 | 2115431.27896 | 37.78787989509 | -122.485231467955 | (37.78787989509, -122.485231467955) | |||
31755 | 31755 | 177719 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 0 Higuera Ave | 8 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 4 | 5987711.1405 | 2090208.21579 | 37.7186053084801 | -122.484500336223 | (37.7186053084801, -122.484500336223) | ||||
31868 | 31868 | 250675 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 711 El Camino Del Mar | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | Width 4ft | 5986399.94455 | 2114829.9306 | 37.78613339638721 | -122.4908432843 | (37.7861333963872, -122.4908432843) | |||
31987 | 31987 | 250506 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 55 27th Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 14 | 5987256.92022 | 2115565.6906 | 37.7882036078544 | -122.48793249451 | (37.7882036078544, -122.48793249451) | ||||
32436 | 32436 | 184257 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 3917 Kirkham St | 4 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 9 | Width 0ft | 5982725.806 | 2104886.1449 | 37.758615318801496 | -122.502818261057 | (37.7586153188015, -122.502818261057) | |||
32480 | 32480 | 185620 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 2100 Sunset Blvd | 6 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 7 | Width 0ft | 5984996.6239 | 2100742.4906 | 37.7473711796046 | -122.494659375818 | (37.7473711796046, -122.494659375818) | |||
32514 | 32514 | 117996 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 14 Shore View Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | Width 4ft | 5984555.86945 | 2112874.1993299997 | 37.7806556272848 | -122.49707878672899 | (37.7806556272848, -122.497078786729) | |||
32628 | 32628 | 185664 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 2101 Sunset Blvd | 5 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 1 | Width 0ft | 5984923.8539 | 2100573.0403 | 37.7469016557071 | -122.494898513668 | (37.7469016557071, -122.494898513668) | |||
32994 | 32994 | 250707 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 25 McLaren Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 12 | Width 4ft | 5986921.717 | 2114846.1272400003 | 37.7862083350811 | -122.489039305424 | (37.7862083350811, -122.489039305424) | |||
33026 | 33026 | 184247 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 3801 Kirkham St | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 8 | Width 0ft | 5982890.9609 | 2104892.1033 | 37.7586413836843 | -122.50224753087099 | (37.7586413836843, -122.502247530871) | |||
33028 | 33028 | 177673 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 800 Mansell St | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 11 | Width 3ft | 6009467.626730001 | 2090103.60345 | 37.71956101082179 | -122.40928932843501 | (37.7195610108218, -122.409289328435) | |||
33133 | 33133 | 186806 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1200 Sunset Blvd | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 6 | Width 0ft | 5984792.4243 | 2106694.4532 | 37.7637016664238 | -122.49580445562401 | (37.7637016664238, -122.495804455624) | |||
33239 | 33239 | 250504 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 35 27th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 10 | 5987226.17362 | 2115615.6145599997 | 37.7883388910724 | -122.488042540952 | (37.7883388910724, -122.488042540952) | ||||
33459 | 33459 | 250465 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 320 Seacliff Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 8 | Width 3ft | 5986796.94996 | 2115622.67425 | 37.7883332262404 | -122.48952808427299 | (37.7883332262404, -122.489528084273) | |||
33742 | 33742 | 210346 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1300 Ulloa St | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 13 | Width 3ft | 5991988.67989 | 2098451.25598 | 37.7414868078607 | -122.470314727069 | (37.7414868078607, -122.470314727069) | |||
33755 | 33755 | 209950 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 235 Dorantes Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 31 | Width 3ft | 5993511.163980001 | 2099700.45258 | 37.745004694007605 | -122.465141253767 | (37.7450046940076, -122.465141253767) | |||
34088 | 34088 | 250848 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 237 30th Ave | 5 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 6 | Width 4ft | 5986485.50682 | 2114208.69339 | 37.7844326560738 | -122.490501544617 | (37.7844326560738, -122.490501544617) | |||
34154 | 34154 | 250700 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 80 McLaren Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 8 | 5986776.39864 | 2114896.79403 | 37.786338968822704 | -122.489545789219 | (37.7863389688227, -122.489545789219) | ||||
34155 | 34155 | 209805 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 4994 19th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 16 | Width 3ft | 5990631.220980001 | 2093516.7238 | 37.7278592603924 | -122.47464824882299 | (37.7278592603924, -122.474648248823) | |||
34232 | 34232 | 187136 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 2301 Sunset Blvd | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 14 | Width 0ft | 5984969.052999999 | 2099291.7064 | 37.7433861065054 | -122.494647773186 | (37.7433861065054, -122.494647773186) | |||
34486 | 34486 | 140850 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 581 Euclid Ave | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 14 | Width 0ft | 5996614.9513 | 2113807.556 | 37.7839176783176 | -122.455428359231 | (37.7839176783176, -122.455428359231) | |||
34722 | 34722 | 250627 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 155 28th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 13 | Width 4ft | 5987098.48709 | 2114794.1473 | 37.786075928810895 | -122.488423913753 | (37.7860759288109, -122.488423913753) | |||
34862 | 34862 | 250420 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 49 Seacliff Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 7 | Width 4ft | 5987862.8229 | 2115790.71812 | 37.7888567944474 | -122.48585272324101 | (37.7888567944474, -122.485852723241) | |||
34917 | 34917 | 186186 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1701 Sunset Blvd | 5 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 21 | Width 0ft | 5984843.8671 | 2103210.0672 | 37.754137525404 | -122.495369544862 | (37.754137525404, -122.495369544862) | |||
35043 | 35043 | 250674 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 711 El Camino Del Mar | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | Width 4ft | 5986384.134819999 | 2114826.0342099997 | 37.7861217744312 | -122.490897694196 | (37.7861217744312, -122.490897694196) | |||
35167 | 35167 | 250443 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 120 Seacliff Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 14 | Width 4ft | 5987542.94428 | 2115793.76045 | 37.788846502613104 | -122.48695966816601 | (37.7888465026131, -122.486959668166) | |||
35509 | 35509 | 250368 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 45 Scenic Way | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 15 | Width 4ft | 5987776.34966 | 2115573.7477599997 | 37.7882560167615 | -122.48613597099501 | (37.7882560167615, -122.486135970995) | |||
35526 | 35526 | 131605 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 982 Green St | 4 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 9 | 6008358.64628 | 2118966.19584 | 37.7987488873077 | -122.41516465784599 | (37.7987488873077, -122.415164657846) | ||||
35535 | 35535 | 186182 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1701 Sunset Blvd | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 4 | Width 0ft | 5984824.6526 | 2103493.4063 | 37.754914371203796 | -122.49545688804199 | (37.7549143712038, -122.495456888042) | |||
35647 | 35647 | 250395 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 43 25th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 15 | Width 4ft | 5988176.9191 | 2115766.42096 | 37.788808379445896 | -122.48476422430099 | (37.7888083794459, -122.484764224301) | |||
35755 | 35755 | 184966 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 2701 Sunset Blvd | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 35 | Width 0ft | 5985048.1816 | 2096734.4959 | 37.7363693251245 | -122.494185728641 | (37.7363693251245, -122.494185728641) | |||
35830 | 35830 | 250708 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 25 McLaren Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 15 | Width 4ft | 5986979.34687 | 2114848.5621599997 | 37.786218384106604 | -122.48884010288201 | (37.7862183841066, -122.488840102882) | |||
36420 | 36420 | 250353 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 90 Scenic Way | 6 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 15 | 5987585.69001 | 2115723.97833 | 37.7886573931578 | -122.486806649401 | (37.7886573931578, -122.486806649401) | ||||
36576 | 36576 | 250440 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 95 Seacliff Ave | 4 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 14 | Width 4ft | 5987663.2299 | 2115786.0526900003 | 37.788832351789395 | -122.486542935823 | (37.7888323517894, -122.486542935823) | |||
37012 | 37012 | 184241 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1560 43rd Ave | 9 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 4 | Width 0ft | 5982820.835 | 2104772.4768 | 37.7583088027406 | -122.502481200295 | (37.7583088027406, -122.502481200295) | |||
37067 | 37067 | 185385 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 2300 Sunset Blvd | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 13 | Width 0ft | 5985055.3332 | 2099090.1134 | 37.7428376362899 | -122.494334586063 | (37.7428376362899, -122.494334586063) | |||
37205 | 37205 | 186189 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1701 Sunset Blvd | 8 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 19 | Width 0ft | 5984842.0777 | 2103046.1247 | 37.753687279781396 | -122.495363643069 | (37.7536872797814, -122.495363643069) | |||
37330 | 37330 | 246723 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 51 Stoneman St | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 2 | 6007993.984209999 | 2099385.4725900004 | 37.7449643396286 | -122.415039822929 | (37.7449643396286, -122.415039822929) | ||||
37613 | 37613 | 187061 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 2600 Sunset Blvd | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 6 | Width 0ft | 5985115.8313 | 2097150.9951 | 37.7375168790235 | -122.493982524741 | (37.7375168790235, -122.493982524741) | |||
37621 | 37621 | 250510 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 75 27th Ave | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 12 | Width 5ft | 5987308.66603 | 2115522.71145 | 37.788088617839705 | -122.487750306256 | (37.7880886178397, -122.487750306256) | |||
38171 | 38171 | 213229 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 180 Bright St | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 16 | Width 3ft | 5993764.508330001 | 2088438.47213 | 37.714096664410796 | -122.463448112758 | (37.7140966644108, -122.463448112758) | |||
38206 | 38206 | 183996 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1600 Sunset Blvd | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 19 | Width 0ft | 5984892.555 | 2103720.738 | 37.755542536917794 | -122.495238829567 | (37.7555425369178, -122.495238829567) | |||
38224 | 38224 | 186331 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1801 37th Ave | 8 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 16 | Width 0ft | 5984860.1569 | 2102438.1276 | 37.752018945789 | -122.495256288218 | (37.752018945789, -122.495256288218) | |||
38425 | 38425 | 250800 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 282 31st Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 8 | Width 4ft | 5986227.80831 | 2114029.63012 | 37.7839259447618 | -122.491379896262 | (37.7839259447618, -122.491379896262) | |||
38434 | 38434 | 250776 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 260 32nd Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 9 | Width 3ft | 5985911.62928 | 2114163.9729299997 | 37.7842763305386 | -122.492483640508 | (37.7842763305386, -122.492483640508) | |||
38467 | 38467 | 186005 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1900 Sunset Blvd | 5 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 17 | Width 0ft | 5984955.1961 | 2102099.6831 | 37.7510952340813 | -122.49490268161001 | (37.7510952340813, -122.49490268161) | |||
38504 | 38504 | 141055 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 182 JORDAN AVE | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 6 | Width 0ft | 5996267.0537 | 2113098.5624 | 37.781951002136296 | -122.456580660401 | (37.7819510021363, -122.456580660401) | |||
38633 | 38633 | 250514 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 40 27th Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 13 | Width 5ft | 5987350.46748 | 2115543.99511 | 37.788149494743706 | -122.487607246587 | (37.7881494947437, -122.487607246587) | |||
38797 | 38797 | 182007 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 2480 34th Ave | 4 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 6 | Width 0ft | 5985837.909 | 2098328.1428 | 37.740791235686295 | -122.491572620674 | (37.7407912356863, -122.491572620674) | |||
38915 | 38915 | 232207 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 6 Park Hill Ave | 10 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 14 | Width 3ft | 6001151.33694 | 2107705.93413 | 37.7674234139945 | -122.43929667619499 | (37.7674234139945, -122.439296676195) | |||
39177 | 39177 | 213228 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 180 Bright St | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 15 | Width 3ft | 5993764.44098 | 2088418.4106299998 | 37.71404157642979 | -122.46344689056002 | (37.7140415764298, -122.46344689056) | |||
39189 | 39189 | 184245 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 3801 Kirkham St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 7 | Width 0ft | 5982856.1271 | 2104890.5755 | 37.75863514211029 | -122.502367886933 | (37.7586351421103, -122.502367886933) | |||
39241 | 39241 | 250668 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 700 El Camino Del Mar | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | Width 4ft | 5986478.64441 | 2114912.91017 | 37.7863658315516 | -122.49057711466699 | (37.7863658315516, -122.490577114667) | |||
39391 | 39391 | 123331 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 747 04th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 10 | Width 4ft | 5994715.6922699995 | 2110494.61301 | 37.7747120611904 | -122.461758753624 | (37.7747120611904, -122.461758753624) | |||
39420 | 39420 | 210331 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 640 Quintara St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 1 | Width 6ft | 5991415.73964 | 2101156.59668 | 37.7488818341381 | -122.47249292281401 | (37.7488818341381, -122.472492922814) | |||
39540 | 39540 | 131592 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 999 Green St | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 11 | 6008355.8018 | 2118946.79635 | 37.7986954612792 | -122.41517312674601 | (37.7986954612792, -122.415173126746) | ||||
39667 | 39667 | 121886 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 50 18th Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 9 | Width 5ft | 5990230.2479 | 2114806.89873 | 37.786293173551 | -122.47758991028499 | (37.786293173551, -122.477589910285) | |||
39774 | 39774 | 250383 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 70 25th Ave | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 15 | Width 4ft | 5988107.19356 | 2115599.52486 | 37.7883460694705 | -122.484993212388 | (37.7883460694705, -122.484993212388) | |||
39789 | 39789 | 177674 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 800 Mansell St | 5 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 6 | Width 3ft | 6009447.589819999 | 2090098.23275 | 37.719545141378 | -122.40935821023199 | (37.719545141378, -122.409358210232) | |||
39943 | 39943 | 232215 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 86 Park Hill Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 15 | Width 3ft | 6001107.70818 | 2107488.37216 | 37.7668235598871 | -122.439431984608 | (37.7668235598871, -122.439431984608) |
JSON shape: default, array, newline-delimited
CREATE TABLE "Street_Tree_List" ( "TreeID" INTEGER, "qLegalStatus" INTEGER, "qSpecies" INTEGER, "qAddress" TEXT, "SiteOrder" INTEGER, "qSiteInfo" INTEGER, "PlantType" INTEGER, "qCaretaker" INTEGER, "qCareAssistant" INTEGER, "PlantDate" TEXT, "DBH" INTEGER, "PlotSize" TEXT, "PermitNotes" TEXT, "XCoord" REAL, "YCoord" REAL, "Latitude" REAL, "Longitude" REAL, "Location" TEXT , FOREIGN KEY ("PlantType") REFERENCES [PlantType](id), FOREIGN KEY ("qCaretaker") REFERENCES [qCaretaker](id), FOREIGN KEY ("qSpecies") REFERENCES [qSpecies](id), FOREIGN KEY ("qSiteInfo") REFERENCES [qSiteInfo](id), FOREIGN KEY ("qCareAssistant") REFERENCES [qCareAssistant](id), FOREIGN KEY ("qLegalStatus") REFERENCES [qLegalStatus](id)); CREATE INDEX ["Street_Tree_List_PlantType"] ON [Street_Tree_List]("PlantType"); CREATE INDEX ["Street_Tree_List_qCaretaker"] ON [Street_Tree_List]("qCaretaker"); CREATE INDEX ["Street_Tree_List_qSpecies"] ON [Street_Tree_List]("qSpecies"); CREATE INDEX ["Street_Tree_List_qSiteInfo"] ON [Street_Tree_List]("qSiteInfo"); CREATE INDEX ["Street_Tree_List_qCareAssistant"] ON [Street_Tree_List]("qCareAssistant"); CREATE INDEX ["Street_Tree_List_qLegalStatus"] ON [Street_Tree_List]("qLegalStatus");