Data source: data.sfgov.org
This data as json, CSV (advanced)
These facets timed out: qLegalStatus
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude ▼ | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 136004 | 136004 | 119197 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 850 La Playa | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 5980800.71853 | 2109703.31069 | 37.771728531734794 | -122.50983380285 | (37.7717285317348, -122.50983380285) | |||
| 41141 | 41141 | 119198 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 850 La Playa | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 5980803.32606 | 2109672.6528 | 37.771644507950896 | -122.50982250562599 | (37.7716445079509, -122.509822505626) | |||
| 131773 | 131773 | 119165 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 850 La Playa | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 5980803.057 | 2109634.63853 | 37.7715401160565 | -122.50982061198098 | (37.7715401160565, -122.509820611981) | |||
| 132935 | 132935 | 118679 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 4749 Balboa St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 4ft | 5980848.5753 | 2110916.87516 | 37.7750634448303 | -122.509758426999 | (37.7750634448303, -122.509758426999) | |||
| 63333 | 63333 | 118678 | Undocumented 2 | Pittosporum crassifolium :: Karo Tree 108 | 4749 Balboa St | 2 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 4 | Width 3ft | 5980862.87698 | 2110909.19366 | 37.77504319711021 | -122.50970838455 | (37.7750431971102, -122.50970838455) | |||
| 38458 | 38458 | 118677 | Undocumented 2 | Pittosporum crassifolium :: Karo Tree 108 | 4749 Balboa St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 8 | Width 3ft | 5980875.63021 | 2110909.60557 | 37.7750450801709 | -122.50966429974702 | (37.7750450801709, -122.509664299747) | |||
| 173832 | 173832 | 183666 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 1301 Lower Great Hwy | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 0ft | 5980807.2532 | 2105649.1672 | 37.7605974181757 | -122.509510037409 | (37.7605974181757, -122.509510037409) | |||
| 58803 | 58803 | 183667 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 1301 Lower Great Hwy | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 0ft | 5980810.0798 | 2105619.8412 | 37.7605170641014 | -122.509498083519 | (37.7605170641014, -122.509498083519) | |||
| 156549 | 156549 | 183668 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 1301 Lower Great Hwy | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 0ft | 5980813.613 | 2105594.4018 | 37.760447423174206 | -122.509483974564 | (37.7604474231742, -122.509483974564) | |||
| 149444 | 149444 | 184330 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 1301 Lower Great Hwy | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 0ft | 5980817.5309 | 2105553.3064 | 37.7603348180604 | -122.50946737235701 | (37.7603348180604, -122.509467372357) | |||
| 159785 | 159785 | 186621 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 1301 Lower Great Hwy | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 0ft | 5980819.2183 | 2105525.4648 | 37.7602584725403 | -122.50945946869 | (37.7602584725403, -122.50945946869) | |||
| 160086 | 160086 | 186622 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 1301 Lower Great Hwy | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 0ft | 5980820.062000001 | 2105514.4969 | 37.760228407593104 | -122.509455736178 | (37.7602284075931, -122.509455736178) | |||
| 60784 | 60784 | 186623 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 1301 Lower Great Hwy | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 0ft | 5980820.9057 | 2105500.9979 | 37.760191392973496 | -122.50945181568198 | (37.7601913929735, -122.509451815682) | |||
| 45218 | 45218 | 250986 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 185 Seal Rock Dr | 1 | : 4 | Tree 1 | Private 1 | 16 | Width 3ft | 5980980.82201 | 2112923.78682 | 37.7805816277787 | -122.50945005058 | (37.7805816277787, -122.50945005058) | |||
| 78490 | 78490 | 108957 | Undocumented 2 | Tree(s) :: 17 | 1401X GREAT HWY | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 02/10/2015 12:00:00 AM | 3 | 4x4 | Permit Number 774900 | 5980823.0 | 2105507.0 | 37.7602079965022 | -122.509445018403 | (37.7602079965022, -122.509445018403) | |
| 86287 | 86287 | 108954 | Undocumented 2 | Tree(s) :: 17 | 1401X GREAT HWY | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 02/10/2015 12:00:00 AM | 3 | 4x4 | Permit Number 774900 | 5980823.0 | 2105507.0 | 37.7602079965022 | -122.509445018403 | (37.7602079965022, -122.509445018403) | |
| 112267 | 112267 | 108955 | Undocumented 2 | Tree(s) :: 17 | 1401X GREAT HWY | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 02/10/2015 12:00:00 AM | 3 | 4x4 | Permit Number 774900 | 5980823.0 | 2105507.0 | 37.7602079965022 | -122.509445018403 | (37.7602079965022, -122.509445018403) | |
| 116607 | 116607 | 108953 | Undocumented 2 | Tree(s) :: 17 | 1401X GREAT HWY | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 02/10/2015 12:00:00 AM | 3 | 4x4 | Permit Number 774900 | 5980823.0 | 2105507.0 | 37.7602079965022 | -122.509445018403 | (37.7602079965022, -122.509445018403) | |
| 141246 | 141246 | 108956 | Undocumented 2 | Tree(s) :: 17 | 1401X GREAT HWY | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 02/10/2015 12:00:00 AM | 3 | 4x4 | Permit Number 774900 | 5980823.0 | 2105507.0 | 37.7602079965022 | -122.509445018403 | (37.7602079965022, -122.509445018403) | |
| 66965 | 66965 | 186624 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 1301 Lower Great Hwy | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 0ft | 5980825.1241 | 2105476.531 | 37.7601244626444 | -122.509435409323 | (37.7601244626444, -122.509435409323) | |||
| 150532 | 150532 | 186487 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 1301 Lower Great Hwy | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 0ft | 5980829.9285 | 2105384.5624 | 37.75987222661821 | -122.509411963006 | (37.7598722266182, -122.509411963006) | |||
| 166500 | 166500 | 184360 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 1301 Lower Great Hwy | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 0ft | 5980832.1706 | 2105363.038 | 37.7598132590094 | -122.50940261021799 | (37.7598132590094, -122.509402610218) | |||
| 31308 | 31308 | 181437 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 1300 Lower Great Hwy | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 0ft | 5980841.348999999 | 2105728.8419999997 | 37.7608181926765 | -122.50939803508601 | (37.7608181926765, -122.509398035086) | |||
| 129643 | 129643 | 181436 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 1300 Lower Great Hwy | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 0ft | 5980846.2956 | 2105673.7233 | 37.7606671442701 | -122.50937683368299 | (37.7606671442701, -122.509376833683) | |||
| 170848 | 170848 | 181602 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 1300 Lower Great Hwy | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 0ft | 5980850.9081 | 2105690.7559 | 37.76071418284771 | -122.5093621464 | (37.7607141828477, -122.5093621464) | |||
| 75339 | 75339 | 103704 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 4700 Cabrillo St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | 4x4 | 5980950.21824 | 2110299.88198 | 37.7733753570212 | -122.50936099615801 | (37.7733753570212, -122.509360996158) | |||
| 118624 | 118624 | 109510 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 7200X FULTON ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5980935.0 | 2109588.0 | 37.7714198408482 | -122.509360757847 | (37.7714198408482, -122.509360757847) | ||||
| 47354 | 47354 | 119238 | Undocumented 2 | Yucca gloriosa :: Spanish Dagger 224 | 4701 Cabrillo St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 3ft | 5980953.58736 | 2110230.22563 | 37.773184299817096 | -122.509344168 | (37.7731842998171, -122.509344168) | |||
| 135357 | 135357 | 181601 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 1300 Lower Great Hwy | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 0ft | 5980856.8807 | 2105634.5433 | 37.7605601913922 | -122.509337315457 | (37.7605601913922, -122.509337315457) | |||
| 27191 | 27191 | 186631 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 1300 Lower Great Hwy | 7 | unknown : Yard 19 | Tree 1 | Private 1 | 2 | Width 0ft | 5980860.0426 | 2105683.7293 | 37.7606954284135 | -122.50933003298901 | (37.7606954284135, -122.509330032989) | |||
| 23578 | 23578 | 181600 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 1300 Lower Great Hwy | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 0ft | 5980858.6373 | 2105611.0043 | 37.7604956636473 | -122.50932949211399 | (37.7604956636473, -122.509329492114) | |||
| 73687 | 73687 | 186630 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 1300 Lower Great Hwy | 6 | unknown : Yard 19 | Tree 1 | Private 1 | 2 | Width 0ft | 5980860.7453 | 2105672.8381 | 37.7606655657469 | -122.50932679385099 | (37.7606655657469, -122.509326793851) | |||
| 155462 | 155462 | 186632 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 1300 Lower Great Hwy | 8 | unknown : Yard 19 | Tree 1 | Private 1 | 5 | Width 0ft | 5980861.0966 | 2105687.2426 | 37.7607051370684 | -122.509326648666 | (37.7607051370684, -122.509326648666) | |||
| 157705 | 157705 | 181599 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 1300 Lower Great Hwy | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 0ft | 5980858.9886 | 2105581.4927 | 37.760414654003 | -122.509326085413 | (37.760414654003, -122.509326085413) | |||
| 170571 | 170571 | 186629 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 1300 Lower Great Hwy | 5 | unknown : Yard 19 | Tree 1 | Private 1 | 3 | Width 0ft | 5980862.5019 | 2105665.4602 | 37.7606454117292 | -122.50932017074 | (37.7606454117292, -122.50932017074) | |||
| 155117 | 155117 | 186636 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1300 Lower Great Hwy | 12 | unknown : Yard 19 | Tree 1 | Private 1 | 3 | Width 0ft | 5980864.6099 | 2105729.0507 | 37.7608201372164 | -122.509317602916 | (37.7608201372164, -122.509317602916) | |||
| 36416 | 36416 | 183338 | Undocumented 2 | :: 54 | 1200 La Playa | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 5980889.0479 | 2106803.3028 | 37.7637711641625 | -122.50931286551399 | (37.7637711641625, -122.509312865514) | |||
| 158735 | 158735 | 186635 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 1300 Lower Great Hwy | 11 | unknown : Yard 19 | Tree 1 | Private 1 | 4 | Width 0ft | 5980866.0152 | 2105705.863 | 37.7607565533288 | -122.50931102062 | (37.7607565533288, -122.50931102062) | |||
| 63003 | 63003 | 118456 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 490 48th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 21 | Width 3ft | 5981010.56733 | 2112424.984 | 37.7792138173967 | -122.50931009492099 | (37.7792138173967, -122.509310094921) | |||
| 182740 | 182740 | 118457 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 490 48th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 21 | Width 3ft | 5981011.746169999 | 2112476.4222 | 37.779355120923 | -122.509309837992 | (37.779355120923, -122.509309837992) | |||
| 67142 | 67142 | 118470 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 510 48th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 5981008.92024 | 2112222.55161 | 37.7786579010228 | -122.50930075514499 | (37.7786579010228, -122.509300755145) | |||
| 43243 | 43243 | 103703 | Undocumented 2 | Pittosporum crassifolium :: Karo Tree 108 | 4700 Cabrillo St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | 4x4 | 5980967.69346 | 2110300.1672 | 37.7733771705098 | -122.509300569193 | (37.7733771705098, -122.509300569193) | |||
| 58204 | 58204 | 183260 | Undocumented 2 | Pittosporum crassifolium :: Karo Tree 108 | 1220 La Playa | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 0ft | 5980890.8145 | 2106708.2585 | 37.763510304179995 | -122.509299696626 | (37.76351030418, -122.509299696626) | |||
| 180173 | 180173 | 186625 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1300 Lower Great Hwy | 1 | unknown : Yard 19 | Tree 1 | Private 1 | 2 | Width 0ft | 5980868.2988 | 2105582.371 | 37.76041761449721 | -122.50929395155 | (37.7604176144972, -122.50929395155) | |||
| 68383 | 68383 | 183259 | Undocumented 2 | Pittosporum crassifolium :: Karo Tree 108 | 1220 La Playa | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 0ft | 5980894.3477 | 2106672.2193 | 37.7634115592808 | -122.50928480005899 | (37.7634115592808, -122.509284800059) | |||
| 52895 | 52895 | 186634 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1300 Lower Great Hwy | 10 | unknown : Yard 19 | Tree 1 | Private 1 | 2 | Width 0ft | 5980874.0957 | 2105690.7559 | 37.7607155500113 | -122.509281952349 | (37.7607155500113, -122.509281952349) | |||
| 133309 | 133309 | 186628 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 1300 Lower Great Hwy | 4 | unknown : Yard 19 | Tree 1 | Private 1 | 5 | Width 0ft | 5980874.0957 | 2105652.4611 | 37.760610403518 | -122.509279108369 | (37.760610403518, -122.509279108369) | |||
| 137510 | 137510 | 118414 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 641 48th Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 26 | 5980997.21538 | 2111360.64896 | 37.7762906814163 | -122.509277221064 | (37.7762906814163, -122.509277221064) | ||||
| 174389 | 174389 | 186633 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 1300 Lower Great Hwy | 9 | unknown : Yard 19 | Tree 1 | Private 1 | 3 | Width 0ft | 5980876.555 | 2105686.5399 | 37.760704119089 | -122.509273133786 | (37.760704119089, -122.509273133786) | |||
| 69172 | 69172 | 186627 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 1300 Lower Great Hwy | 3 | unknown : Yard 19 | Tree 1 | Private 1 | 3 | Width 0ft | 5980877.609 | 2105668.6222 | 37.760654984387706 | -122.509268157881 | (37.7606549843877, -122.509268157881) | |||
| 153024 | 153024 | 186626 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 1300 Lower Great Hwy | 2 | unknown : Yard 19 | Tree 1 | Private 1 | 7 | Width 0ft | 5980879.19 | 2105650.5288 | 37.7606053983358 | -122.509261346313 | (37.7606053983358, -122.509261346313) | |||
| 24690 | 24690 | 103701 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 4700 Cabrillo St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | 4x4 | 5980981.42101 | 2110300.97358 | 37.7733801939619 | -122.50925314442 | (37.7733801939619, -122.50925314442) | |||
| 150810 | 150810 | 186483 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 1400 Lower Great Hwy | 38 | unknown : Yard 19 | Tree 1 | Private 1 | 5 | Width 0ft | 5980878.6055 | 2105409.1394 | 37.7599425780444 | -122.509245441233 | (37.7599425780444, -122.509245441233) | |||
| 61319 | 61319 | 186489 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 1400 Lower Great Hwy | 35 | unknown : Yard 19 | Tree 1 | Private 1 | 4 | Width 0ft | 5980878.6055 | 2105387.9124 | 37.759884294807 | -122.509243864844 | (37.759884294807, -122.509243864844) | |||
| 153493 | 153493 | 118477 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 562 48th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 7 | Width 3ft | 5981021.8691 | 2111857.25612 | 37.7776556713315 | -122.509228826135 | (37.7776556713315, -122.509228826135) | |||
| 51431 | 51431 | 186843 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 1400 Lower Great Hwy | 33 | unknown : Yard 19 | Tree 1 | Private 1 | 7 | Width 0ft | 5980882.2296 | 2105351.6713 | 37.759785000838704 | -122.509228639712 | (37.7597850008387, -122.509228639712) | |||
| 167264 | 167264 | 186490 | Undocumented 2 | Pinus Spp :: Pine Spp 105 | 1400 Lower Great Hwy | 36 | unknown : Yard 19 | Tree 1 | Private 1 | 1 | Width 0ft | 5980883.265 | 2105397.7493 | 37.7599115788226 | -122.509228480711 | (37.7599115788226, -122.509228480711) | |||
| 147843 | 147843 | 186500 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 1400 Lower Great Hwy | 28 | unknown : Yard 19 | Tree 1 | Private 1 | 2 | Width 0ft | 5980882.7473 | 2105316.9833 | 37.7596897880858 | -122.509224273257 | (37.7596897880858, -122.509224273257) | |||
| 63349 | 63349 | 186499 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 1400 Lower Great Hwy | 27 | unknown : Yard 19 | Tree 1 | Private 1 | 1 | Width 0ft | 5980882.7473 | 2105311.2882 | 37.7596741509783 | -122.50922385032601 | (37.7596741509783, -122.509223850326) | |||
| 49608 | 49608 | 186504 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 1400 Lower Great Hwy | 32 | unknown : Yard 19 | Tree 1 | Private 1 | 4 | Width 0ft | 5980883.7828 | 2105343.3876 | 37.7597623477539 | -122.50922265288601 | (37.7597623477539, -122.509222652886) | |||
| 157531 | 157531 | 186484 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 1400 Lower Great Hwy | 24 | unknown : Yard 19 | Tree 1 | Private 1 | 2 | Width 0ft | 5980883.7828 | 2105293.6854 | 37.7596258798004 | -122.50921896188801 | (37.7596258798004, -122.509218961888) | |||
| 70661 | 70661 | 186503 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 1400 Lower Great Hwy | 31 | unknown : Yard 19 | Tree 1 | Private 1 | 4 | Width 0ft | 5980885.336 | 2105334.0684 | 37.759736851483396 | -122.50921658916701 | (37.7597368514834, -122.509216589167) | |||
| 65556 | 65556 | 186486 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 1400 Lower Great Hwy | 26 | unknown : Yard 19 | Tree 1 | Private 1 | 2 | Width 0ft | 5980884.8182 | 2105306.6287 | 37.759661479426796 | -122.509216342217 | (37.7596614794268, -122.509216342217) | |||
| 67642 | 67642 | 118478 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 578 48th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 8 | Width 3ft | 5981024.51617 | 2111800.84509 | 37.7775009394111 | -122.509215478972 | (37.7775009394111, -122.509215478972) | |||
| 30380 | 30380 | 186493 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 1400 Lower Great Hwy | 23 | unknown : Yard 19 | Tree 1 | Private 1 | 2 | Width 0ft | 5980884.8182 | 2105286.9549 | 37.7596074608269 | -122.509214881201 | (37.7596074608269, -122.509214881201) | |||
| 49038 | 49038 | 186494 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 1400 Lower Great Hwy | 19 | unknown : Yard 19 | Tree 1 | Private 1 | 2 | Width 0ft | 5980884.3005 | 2105262.6215 | 37.7595406177816 | -122.50921486458799 | (37.7595406177816, -122.509214864588) | |||
| 58818 | 58818 | 186492 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 1400 Lower Great Hwy | 22 | unknown : Yard 19 | Tree 1 | Private 1 | 2 | Width 0ft | 5980885.336 | 2105278.6712 | 37.759584746696 | -122.509212475259 | (37.759584746696, -122.509212475259) | |||
| 166154 | 166154 | 186488 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 1400 Lower Great Hwy | 34 | unknown : Yard 19 | Tree 1 | Private 1 | 15 | Width 0ft | 5980888.4423 | 2105382.2174 | 37.7598692379346 | -122.50920942183998 | (37.7598692379346, -122.50920942184) | |||
| 167996 | 167996 | 186482 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 1400 Lower Great Hwy | 37 | unknown : Yard 19 | Tree 1 | Private 1 | 3 | Width 0ft | 5980889.9955 | 2105407.5862 | 37.7599389849374 | -122.50920593411199 | (37.7599389849374, -122.509205934112) | |||
| 53673 | 53673 | 103700 | Undocumented 2 | Pittosporum crassifolium :: Karo Tree 108 | 4700 Cabrillo St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | 4x4 | 5980996.66702 | 2110300.42587 | 37.773379588986394 | -122.509200366595 | (37.7733795889864, -122.509200366595) | |||
| 166592 | 166592 | 118482 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 8349 Geary Blvd | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | 5981039.36975 | 2112282.68151 | 37.7788247951526 | -122.509199886896 | (37.7788247951526, -122.509199886896) | ||||
| 69350 | 69350 | 186498 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 1400 Lower Great Hwy | 18 | unknown : Yard 19 | Tree 1 | Private 1 | 2 | Width 0ft | 5980888.4423 | 2105252.2669 | 37.7595124312164 | -122.5091997715 | (37.7595124312164, -122.5091997715) | |||
| 180522 | 180522 | 250985 | Undocumented 2 | Melaleuca nesophila :: Pink Melaleuca 93 | 169 Seal Rock Dr | 1 | : 4 | Tree 1 | Private 1 | 5 | Width 3ft | 5981053.81587 | 2112927.8042099997 | 37.7805969621145 | -122.509197833038 | (37.7805969621145, -122.509197833038) | |||
| 182255 | 182255 | 186502 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 1400 Lower Great Hwy | 30 | unknown : Yard 19 | Tree 1 | Private 1 | 5 | Width 0ft | 5980892.5842 | 2105334.0684 | 37.7597372788194 | -122.509191521679 | (37.7597372788194, -122.509191521679) | |||
| 129570 | 129570 | 186495 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 1400 Lower Great Hwy | 20 | unknown : Yard 19 | Tree 1 | Private 1 | 3 | Width 0ft | 5980891.5487 | 2105262.6215 | 37.7595410451172 | -122.509189797166 | (37.7595410451172, -122.509189797166) | |||
| 151681 | 151681 | 118454 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 8350 Geary Blvd | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | 5981044.43167 | 2112373.0207700003 | 37.7790731383894 | -122.50918908645399 | (37.7790731383894, -122.509189086454) | ||||
| 51060 | 51060 | 183255 | Undocumented 2 | :: 54 | 1300 La Playa | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 5980911.3073 | 2106159.7216 | 37.762005388573606 | -122.509188082818 | (37.7620053885736, -122.509188082818) | |||
| 46197 | 46197 | 186496 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 1400 Lower Great Hwy | 16 | unknown : Yard 19 | Tree 1 | Private 1 | 2 | Width 0ft | 5980891.5487 | 2105237.2527 | 37.7594713896823 | -122.509187913256 | (37.7594713896823, -122.509187913256) | |||
| 47007 | 47007 | 186501 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 1400 Lower Great Hwy | 29 | unknown : Yard 19 | Tree 1 | Private 1 | 3 | Width 0ft | 5980893.6197 | 2105317.501 | 37.7596918505514 | -122.50918671014799 | (37.7596918505514, -122.509186710148) | |||
| 99492 | 99492 | 110751 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 510 48th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/05/2015 12:00:00 AM | 3 | Permit Number 775489 | 5981042.2 | 2112214.0 | 37.778636382962 | -122.509184994454 | (37.778636382962, -122.509184994454) | ||
| 162558 | 162558 | 183254 | Undocumented 2 | :: 54 | 1300 La Playa | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 5980911.6607 | 2106131.1023 | 37.76192682906861 | -122.50918473520399 | (37.7619268290686, -122.509184735204) | |||
| 52894 | 52894 | 186485 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 1400 Lower Great Hwy | 25 | unknown : Yard 19 | Tree 1 | Private 1 | 9 | Width 0ft | 5980894.6551 | 2105298.8627 | 37.7596407361809 | -122.50918174518299 | (37.7596407361809, -122.509181745183) | |||
| 159650 | 159650 | 109509 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 7200X Fulton St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | 3x3 | 5980988.44063 | 2109621.98513 | 37.7715163048766 | -122.50917843155399 | (37.7715163048766, -122.509178431554) | |||
| 58408 | 58408 | 186491 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 1400 Lower Great Hwy | 21 | unknown : Yard 19 | Tree 1 | Private 1 | 8 | Width 0ft | 5980895.1728 | 2105273.4939 | 37.759571111269004 | -122.509178070846 | (37.759571111269, -122.509178070846) | |||
| 24192 | 24192 | 183253 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 1300 La Playa | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 0ft | 5980913.074 | 2106102.483 | 37.7618483320506 | -122.50917772189 | (37.7618483320506, -122.50917772189) | |||
| 23747 | 23747 | 186497 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 1400 Lower Great Hwy | 17 | unknown : Yard 19 | Tree 1 | Private 1 | 2 | Width 0ft | 5980894.6551 | 2105244.501 | 37.7594914745751 | -122.509177708249 | (37.7594914745751, -122.509177708249) | |||
| 29234 | 29234 | 186513 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 1400 Lower Great Hwy | 14 | unknown : Yard 19 | Tree 1 | Private 1 | 5 | Width 0ft | 5980894.1374 | 2105147.1675 | 37.759224194224 | -122.509172270667 | (37.759224194224, -122.509172270667) | |||
| 52773 | 52773 | 183252 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 1300 La Playa | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 0ft | 5980914.4873 | 2106074.2169999997 | 37.761770805091096 | -122.50917073482799 | (37.7617708050911, -122.509170734828) | |||
| 130131 | 130131 | 118484 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 8349 Geary Blvd | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 17 | 5981049.15965 | 2112307.0389 | 37.7788922504996 | -122.50916782963499 | (37.7788922504996, -122.509167829635) | ||||
| 174165 | 174165 | 186511 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 1400 Lower Great Hwy | 12 | unknown : Yard 19 | Tree 1 | Private 1 | 5 | Width 0ft | 5980895.6906 | 2105140.9548 | 37.7592072275053 | -122.509166437696 | (37.7592072275053, -122.509166437696) | |||
| 31425 | 31425 | 119228 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 701 48th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 19 | Width 4ft | 5981020.55796 | 2110899.83837 | 37.7750268077692 | -122.509162246597 | (37.7750268077692, -122.509162246597) | |||
| 27012 | 27012 | 186514 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 1400 Lower Great Hwy | 15 | unknown : Yard 19 | Tree 1 | Private 1 | 4 | Width 0ft | 5980897.7615 | 2105153.3803 | 37.759241466452295 | -122.509160198369 | (37.7592414664523, -122.509160198369) | |||
| 37608 | 37608 | 119226 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 715 48th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 17 | Width 4ft | 5981020.44403 | 2110823.32053 | 37.774816705617106 | -122.509156957318 | (37.7748167056171, -122.509156957318) | |||
| 157477 | 157477 | 119227 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 711 48th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 23 | Width 4ft | 5981021.77199 | 2110849.56022 | 37.7748888303639 | -122.50915431266199 | (37.7748888303639, -122.509154312662) | |||
| 131767 | 131767 | 186507 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 1400 Lower Great Hwy | 8 | unknown : Yard 19 | Tree 1 | Private 1 | 5 | Width 0ft | 5980898.797 | 2105106.7845 | 37.759113588816 | -122.509153157003 | (37.759113588816, -122.509153157003) | |||
| 182655 | 182655 | 186512 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 1400 Lower Great Hwy | 13 | unknown : Yard 19 | Tree 1 | Private 1 | 5 | Width 0ft | 5980899.8324 | 2105147.1675 | 37.7592245299801 | -122.509152574968 | (37.7592245299801, -122.509152574968) | |||
| 127053 | 127053 | 103699 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 4700 Cabrillo St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 4x4 | 5981012.38843 | 2110301.40953 | 37.7733832167065 | -122.509146058065 | (37.7733832167065, -122.509146058065) | |||
| 50995 | 50995 | 186509 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 1400 Lower Great Hwy | 10 | unknown : Yard 19 | Tree 1 | Private 1 | 7 | Width 0ft | 5980901.3856 | 2105130.6001 | 37.759179132228 | -122.509145973072 | (37.759179132228, -122.509145973072) | |||
| 66913 | 66913 | 186510 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 1400 Lower Great Hwy | 11 | unknown : Yard 19 | Tree 1 | Private 1 | 5 | Width 0ft | 5980902.4211 | 2105136.8129 | 37.759196251841395 | -122.509142853237 | (37.7591962518414, -122.509142853237) | |||
| 26095 | 26095 | 119225 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 727 48th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 3ft | 5981023.84612 | 2110741.39714 | 37.7745919686982 | -122.509139104186 | (37.7745919686982, -122.509139104186) |
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");