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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
48440 | 48440 | 186534 | Undocumented 2 | Pittosporum crassifolium :: Karo Tree 108 | 1501 Sunset Blvd | 5 | unknown : Yard 19 | Tree 1 | Private 1 | 2 | Width 0ft | 5984706.503 | 2104895.4217 | 37.758756997201 | -122.49596890002701 | (37.758756997201, -122.495968900027) | |||
48606 | 48606 | 185487 | Undocumented 2 | Cedrus deodara :: Deodar Cedar 129 | 2400 Sunset Blvd | 40 | unknown : Yard 19 | Tree 1 | Private 1 | 1 | Width 0ft | 5985139.0022 | 2098533.6484 | 37.7413146295557 | -122.49400428423901 | (37.7413146295557, -122.494004284239) | |||
48984 | 48984 | 200734 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 1434 Oakdale Ave | 1 | unknown : Yard 19 | Tree 1 | Private 1 | 7 | Width 0ft | 6015941.8417 | 2094834.993 | 37.7329130736504 | -122.387239974213 | (37.7329130736504, -122.387239974213) | |||
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) | |||
49295 | 49295 | 186515 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 1400 Lower Great Hwy | 1 | unknown : Yard 19 | Tree 1 | Private 1 | 3 | Width 0ft | 5980905.2686 | 2104984.8589 | 37.7587791976552 | -122.509121721574 | (37.7587791976552, -122.509121721574) | |||
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) | |||
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) | |||
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) | |||
51500 | 51500 | 185486 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 2400 Sunset Blvd | 39 | unknown : Yard 19 | Tree 1 | Private 1 | 3 | Width 0ft | 5985131.6978 | 2098522.3598 | 37.7412832067047 | -122.494028708144 | (37.7412832067047, -122.494028708144) | |||
52467 | 52467 | 200157 | Undocumented 2 | :: 54 | 1091 Hollister Ave | 1 | unknown : Yard 19 | Tree 1 | Private 1 | 0 | Width 0ft | 6014392.094 | 2090006.3557 | 37.7195686584119 | -122.39226030100401 | (37.7195686584119, -122.392260301004) | |||
52764 | 52764 | 185481 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 2400 Sunset Blvd | 34 | unknown : Yard 19 | Tree 1 | Private 1 | 26 | Width 0ft | 5985135.017999999 | 2098495.7982 | 37.741210469977105 | -122.49401527111799 | (37.7412104699771, -122.494015271118) | |||
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) | |||
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) | |||
53374 | 53374 | 185417 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 2300 Sunset Blvd | 33 | unknown : Yard 19 | Tree 1 | Private 1 | 24 | Width 0ft | 5985081.6412 | 2099246.8736 | 37.7432695969748 | -122.49425517376801 | (37.7432695969748, -122.494255173768) | |||
53419 | 53419 | 186531 | Undocumented 2 | Pinus pinea :: Italian Stone Pine 143 | 1501 Sunset Blvd | 2 | unknown : Yard 19 | Tree 1 | Private 1 | 9 | Width 0ft | 5984751.3064 | 2104919.289 | 37.7588251541556 | -122.49581571217699 | (37.7588251541556, -122.495815712177) | |||
53561 | 53561 | 138259 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 2600 GEARY BLVD | 27 | unknown : Yard 19 | Tree 1 | Private 1 | 19 | Width 0ft | 5999063.9407 | 2113176.2302 | 37.782324439437204 | -122.44691034713499 | (37.7823244394372, -122.446910347135) | |||
53840 | 53840 | 185397 | Undocumented 2 | Quercus agrifolia :: Coast Live Oak 180 | 2300 Sunset Blvd | 10 | unknown : Yard 19 | Tree 1 | Private 1 | 2 | Width 0ft | 5985126.1289 | 2099011.9385 | 37.742627131937 | -122.49408403757799 | (37.742627131937, -122.494084037578) | |||
53924 | 53924 | 185395 | Undocumented 2 | Araucaria heterophylla :: Norfolk Island Pine 24 | 2300 Sunset Blvd | 7 | unknown : Yard 19 | Tree 1 | Private 1 | 1 | Width 0ft | 5985077.1425 | 2098975.4486 | 37.7425240740104 | -122.494250726815 | (37.7425240740104, -122.494250726815) | |||
55166 | 55166 | 185499 | Undocumented 2 | Cedrus deodara :: Deodar Cedar 129 | 2400 Sunset Blvd | 53 | unknown : Yard 19 | Tree 1 | Private 1 | 1 | Width 0ft | 5985130.3697 | 2098685.0494 | 37.741729830798995 | -122.494045287668 | (37.741729830799, -122.494045287668) | |||
55366 | 55366 | 200178 | Undocumented 2 | :: 54 | 3201 Ingerson Ave | 1 | unknown : Yard 19 | Tree 1 | Private 1 | 0 | Width 0ft | 6014218.378 | 2089782.3359 | 37.7189438969212 | -122.39284511455 | (37.7189438969212, -122.39284511455) | |||
55505 | 55505 | 186565 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 1501 Sunset Blvd | 36 | unknown : Yard 19 | Tree 1 | Private 1 | 2 | Width 0ft | 5984733.8247 | 2104692.236 | 37.7582007060302 | -122.49585942192302 | (37.7582007060302, -122.495859421923) | |||
55634 | 55634 | 185460 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 2400 Sunset Blvd | 10 | unknown : Yard 19 | Tree 1 | Private 1 | 3 | Width 0ft | 5985122.4012 | 2098351.0376 | 37.7408122581003 | -122.49404822844801 | (37.7408122581003, -122.494048228448) | |||
55679 | 55679 | 200228 | Undocumented 2 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 1079 Ingerson Ave | 2 | unknown : Yard 19 | Tree 1 | Private 1 | 7 | Width 0ft | 6013685.1573 | 2090181.4131 | 37.7200100518893 | -122.394716195485 | (37.7200100518893, -122.394716195485) | |||
57083 | 57083 | 185434 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 2300 Sunset Blvd | 50 | unknown : Yard 19 | Tree 1 | Private 1 | 20 | Width 0ft | 5985080.6415 | 2099410.3284 | 37.7437183411386 | -122.494270675975 | (37.7437183411386, -122.494270675975) | |||
57323 | 57323 | 185506 | Undocumented 2 | Pittosporum crassifolium :: Karo Tree 108 | 2400 Sunset Blvd | 60 | unknown : Yard 19 | Tree 1 | Private 1 | 4 | Width 0ft | 5985096.5037 | 2098790.6317 | 37.7420177496615 | -122.494170163503 | (37.7420177496615, -122.494170163503) | |||
57892 | 57892 | 185452 | Undocumented 2 | Quercus agrifolia :: Coast Live Oak 180 | 2400 Sunset Blvd | 2 | unknown : Yard 19 | Tree 1 | Private 1 | 1 | Width 0ft | 5985111.1125 | 2098241.4711 | 37.7405107574318 | -122.49407918667299 | (37.7405107574318, -122.494079186673) | |||
57913 | 57913 | 185415 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 2300 Sunset Blvd | 31 | unknown : Yard 19 | Tree 1 | Private 1 | 16 | Width 0ft | 5985091.6384 | 2099216.8819 | 37.743187832897 | -122.494218396427 | (37.743187832897, -122.494218396427) | |||
58301 | 58301 | 200156 | Undocumented 2 | :: 54 | 1047 Ingerson Ave | 1 | unknown : Yard 19 | Tree 1 | Private 1 | 0 | Width 0ft | 6013914.5428 | 2090009.7093 | 37.7195513382693 | -122.39391126933 | (37.7195513382693, -122.39391126933) | |||
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) | |||
58500 | 58500 | 186538 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 1501 Sunset Blvd | 9 | unknown : Yard 19 | Tree 1 | Private 1 | 29 | Width 0ft | 5984747.9566 | 2104882.4413 | 37.7587237844572 | -122.495824579043 | (37.7587237844572, -122.495824579043) | |||
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) | |||
59085 | 59085 | 185502 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 2400 Sunset Blvd | 56 | unknown : Yard 19 | Tree 1 | Private 1 | 8 | Width 0ft | 5985117.0889 | 2098738.1726 | 37.7418749156753 | -122.494095121998 | (37.7418749156753, -122.494095121998) | |||
59949 | 59949 | 186544 | Undocumented 2 | Pittosporum crassifolium :: Karo Tree 108 | 1501 Sunset Blvd | 15 | unknown : Yard 19 | Tree 1 | Private 1 | 1 | Width 0ft | 5984717.8085 | 2104869.8796 | 37.7586875278599 | -122.495927916751 | (37.7586875278599, -122.495927916751) | |||
60439 | 60439 | 185423 | Undocumented 2 | Araucaria heterophylla :: Norfolk Island Pine 24 | 2300 Sunset Blvd | 39 | unknown : Yard 19 | Tree 1 | Private 1 | 1 | Width 0ft | 5985071.643999999 | 2099284.3632 | 37.7433719482454 | -122.494292503743 | (37.7433719482454, -122.494292503743) | |||
60508 | 60508 | 185418 | Undocumented 2 | Pittosporum crassifolium :: Karo Tree 108 | 2300 Sunset Blvd | 34 | unknown : Yard 19 | Tree 1 | Private 1 | 3 | Width 0ft | 5985092.1383 | 2099264.8686 | 37.7433196206545 | -122.494220204145 | (37.7433196206545, -122.494220204145) | |||
60510 | 60510 | 181353 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 2300 Sunset Blvd | 15 | unknown : Yard 19 | Tree 1 | Private 1 | 34 | Width 0ft | 5985103.1353 | 2099041.4304 | 37.7427067632535 | -122.49416571483 | (37.7427067632535, -122.49416571483) | |||
61127 | 61127 | 200498 | Undocumented 2 | :: 54 | 1055 Ingerson Ave | 1 | unknown : Yard 19 | Tree 1 | Private 1 | 0 | Width 0ft | 6013869.6047 | 2090039.2209 | 37.7196298737115 | -122.394068670065 | (37.7196298737115, -122.394068670065) | |||
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) | |||
61772 | 61772 | 185468 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 2400 Sunset Blvd | 20 | unknown : Yard 19 | Tree 1 | Private 1 | 6 | Width 0ft | 5985131.0337 | 2098396.1923 | 37.7409367458634 | -122.494021708019 | (37.7409367458634, -122.494021708019) | |||
62482 | 62482 | 185414 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 2300 Sunset Blvd | 30 | unknown : Yard 19 | Tree 1 | Private 1 | 3 | Width 0ft | 5985079.1419 | 2099209.8838 | 37.743167886728 | -122.494261089675 | (37.743167886728, -122.494261089675) | |||
62916 | 62916 | 186533 | Undocumented 2 | Pittosporum crassifolium :: Karo Tree 108 | 1501 Sunset Blvd | 4 | unknown : Yard 19 | Tree 1 | Private 1 | 2 | Width 0ft | 5984732.4639 | 2104901.2839 | 37.7587746136444 | -122.495879549084 | (37.7587746136444, -122.495879549084) | |||
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) | |||
64027 | 64027 | 186552 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 1501 Sunset Blvd | 23 | unknown : Yard 19 | Tree 1 | Private 1 | 2 | Width 0ft | 5984760.623 | 2104776.3995 | 37.758433365006105 | -122.49577295137699 | (37.7584333650061, -122.495772951377) | |||
64302 | 64302 | 181358 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 2400 Sunset Blvd | 14 | unknown : Yard 19 | Tree 1 | Private 1 | 11 | Width 0ft | 5985132.3618 | 2098384.2396 | 37.7409040046765 | -122.49401623531 | (37.7409040046765, -122.49401623531) | |||
64449 | 64449 | 185478 | Undocumented 2 | Quercus agrifolia :: Coast Live Oak 180 | 2400 Sunset Blvd | 30 | unknown : Yard 19 | Tree 1 | Private 1 | 1 | Width 0ft | 5985137.6741 | 2098467.2445 | 37.7411322246193 | -122.494003983523 | (37.7411322246193, -122.494003983523) | |||
65093 | 65093 | 185504 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 2400 Sunset Blvd | 58 | unknown : Yard 19 | Tree 1 | Private 1 | 6 | Width 0ft | 5985115.0968 | 2098786.6474 | 37.7420078978362 | -122.49410558184499 | (37.7420078978362, -122.494105581845) | |||
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) | |||
65848 | 65848 | 186549 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 1501 Sunset Blvd | 20 | unknown : Yard 19 | Tree 1 | Private 1 | 12 | Width 0ft | 5984751.8298 | 2104797.3357 | 37.7584903350171 | -122.495804906083 | (37.7584903350171, -122.495804906083) | |||
66692 | 66692 | 185457 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 2400 Sunset Blvd | 7 | unknown : Yard 19 | Tree 1 | Private 1 | 13 | Width 0ft | 5985129.0416 | 2098307.8751 | 37.740694134038 | -122.494022088477 | (37.740694134038, -122.494022088477) | |||
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) | |||
67056 | 67056 | 138263 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 2600 GEARY BLVD | 31 | unknown : Yard 19 | Tree 1 | Private 1 | 17 | Width 0ft | 5999038.5591 | 2113167.7696 | 37.7822997587534 | -122.44699754685101 | (37.7822997587534, -122.446997546851) | |||
67708 | 67708 | 185471 | Undocumented 2 | Pittosporum crassifolium :: Karo Tree 108 | 2400 Sunset Blvd | 23 | unknown : Yard 19 | Tree 1 | Private 1 | 2 | Width 0ft | 5985135.682 | 2098419.4337 | 37.7410008324731 | -122.494007348608 | (37.7410008324731, -122.494007348608) | |||
67760 | 67760 | 186557 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 1501 Sunset Blvd | 28 | unknown : Yard 19 | Tree 1 | Private 1 | 36 | Width 0ft | 5984754.7609 | 2104747.5076 | 37.758353692586 | -122.49579109362101 | (37.758353692586, -122.495791093621) | |||
68374 | 68374 | 185458 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 2400 Sunset Blvd | 8 | unknown : Yard 19 | Tree 1 | Private 1 | 22 | Width 0ft | 5985125.7214 | 2098330.4524 | 37.7407559309555 | -122.49403523184401 | (37.7407559309555, -122.494035231844) | |||
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) | |||
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) | |||
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) | |||
70982 | 70982 | 185472 | Undocumented 2 | Cedrus deodara :: Deodar Cedar 129 | 2400 Sunset Blvd | 24 | unknown : Yard 19 | Tree 1 | Private 1 | 1 | Width 0ft | 5985147.6347 | 2098429.3943 | 37.741028880966894 | -122.493966755049 | (37.7410288809669, -122.493966755049) | |||
72947 | 72947 | 186547 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 1501 Sunset Blvd | 18 | unknown : Yard 19 | Tree 1 | Private 1 | 49 | Width 0ft | 5984724.5081 | 2104844.7562 | 37.7586189383832 | -122.495902893491 | (37.7586189383832, -122.495902893491) | |||
73057 | 73057 | 185408 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 2300 Sunset Blvd | 23 | unknown : Yard 19 | Tree 1 | Private 1 | 10 | Width 0ft | 5985102.6354 | 2099127.4066 | 37.742942801420796 | -122.49417377884599 | (37.7429428014208, -122.494173778846) | |||
73420 | 73420 | 200232 | Undocumented 2 | :: 54 | 923 Ingerson Ave | 1 | unknown : Yard 19 | Tree 1 | Private 1 | 0 | Width 0ft | 6014491.3602 | 2089577.767 | 37.7183973497527 | -122.391887217647 | (37.7183973497527, -122.391887217647) | |||
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) | |||
74158 | 74158 | 138257 | Undocumented 2 | Yucca gloriosa :: Spanish Dagger 224 | 2600 GEARY BLVD | 2 | unknown : Yard 19 | Tree 1 | Private 1 | 4 | Width 0ft | 5999359.7213 | 2113228.3471 | 37.7824844323354 | -122.445890830511 | (37.7824844323354, -122.445890830511) | |||
74346 | 74346 | 200162 | Undocumented 2 | :: 54 | 1035 Ingerson Ave | 1 | unknown : Yard 19 | Tree 1 | Private 1 | 0 | Width 0ft | 6013970.2124 | 2089969.4662 | 37.7194439323961 | -122.393716023061 | (37.7194439323961, -122.393716023061) | |||
75550 | 75550 | 186581 | Undocumented 2 | Sequoia sempervirens :: Coast Redwood 116 | 1501 Sunset Blvd | 52 | unknown : Yard 19 | Tree 1 | Private 1 | 2 | Width 0ft | 5984771.5099 | 2104576.6683 | 37.75788559627829 | -122.495720567601 | (37.7578855962783, -122.495720567601) | |||
76180 | 76180 | 185454 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 2400 Sunset Blvd | 4 | unknown : Yard 19 | Tree 1 | Private 1 | 25 | Width 0ft | 5985131.0337 | 2098272.681 | 37.7405976170701 | -122.494012607503 | (37.7405976170701, -122.494012607503) | |||
76866 | 76866 | 185401 | Undocumented 2 | Pittosporum crassifolium :: Karo Tree 108 | 2300 Sunset Blvd | 14 | unknown : Yard 19 | Tree 1 | Private 1 | 3 | Width 0ft | 5985086.14 | 2099023.9352 | 37.74265773164 | -122.494223189599 | (37.74265773164, -122.494223189599) | |||
77313 | 77313 | 185489 | Undocumented 2 | Pittosporum crassifolium :: Karo Tree 108 | 2400 Sunset Blvd | 42 | unknown : Yard 19 | Tree 1 | Private 1 | 3 | Width 0ft | 5985101.1519 | 2098546.2652 | 37.7413470571288 | -122.494136085042 | (37.7413470571288, -122.494136085042) | |||
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) | |||
130262 | 130262 | 200159 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1043 Ingerson Ave | 1 | unknown : Yard 19 | Tree 1 | Private 1 | 9 | Width 0ft | 6013947.408 | 2089985.5634 | 37.719486864857004 | -122.39379597620301 | (37.719486864857, -122.393795976203) | |||
131257 | 131257 | 185403 | Undocumented 2 | Quercus agrifolia :: Coast Live Oak 180 | 2300 Sunset Blvd | 17 | unknown : Yard 19 | Tree 1 | Private 1 | 1 | Width 0ft | 5985110.6332 | 2099073.9214 | 37.742796413512 | -122.49414218382499 | (37.742796413512, -122.494142183825) | |||
131395 | 131395 | 183037 | Undocumented 2 | Lyonothamnus floribundus subsp. asplenifolius :: Santa Cruz Ironwood 8 | 2523 43rd Ave | 1 | unknown : Yard 19 | Tree 1 | Private 1 | 15 | Width 0ft | 5983009.062000001 | 2097931.9719 | 37.7395377337872 | -122.50132425344299 | (37.7395377337872, -122.501324253443) | |||
131653 | 131653 | 185498 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 2400 Sunset Blvd | 52 | unknown : Yard 19 | Tree 1 | Private 1 | 33 | Width 0ft | 5985102.48 | 2098665.7923 | 37.74167532404589 | -122.494140300571 | (37.7416753240459, -122.494140300571) | |||
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) | |||
131768 | 131768 | 200212 | Undocumented 2 | :: 54 | 1101 Ingerson Ave | 1 | unknown : Yard 19 | Tree 1 | Private 1 | 0 | Width 0ft | 6013545.647999999 | 2090276.655 | 37.720263809593604 | -122.395205102903 | (37.7202638095936, -122.395205102903) | |||
132337 | 132337 | 186535 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 1501 Sunset Blvd | 6 | unknown : Yard 19 | Tree 1 | Private 1 | 2 | Width 0ft | 5984732.8826 | 2104894.5843 | 37.7587562429314 | -122.495877606831 | (37.7587562429314, -122.495877606831) | |||
132393 | 132393 | 185426 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 2300 Sunset Blvd | 42 | unknown : Yard 19 | Tree 1 | Private 1 | 8 | Width 0ft | 5985086.6398 | 2099317.3541 | 37.7434634098799 | -122.49424308404801 | (37.7434634098799, -122.494243084048) | |||
132494 | 132494 | 185500 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 2400 Sunset Blvd | 54 | unknown : Yard 19 | Tree 1 | Private 1 | 6 | Width 0ft | 5985111.7766 | 2098706.9627 | 37.7417889108579 | -122.49411119019399 | (37.7417889108579, -122.494111190194) | |||
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) | |||
133594 | 133594 | 200166 | Undocumented 2 | :: 54 | 1023 Ingerson Ave | 1 | unknown : Yard 19 | Tree 1 | Private 1 | 0 | Width 0ft | 6014031.9185 | 2089919.1624 | 37.7193092369184 | -122.393499207549 | (37.7193092369184, -122.393499207549) | |||
133868 | 133868 | 185475 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 2400 Sunset Blvd | 27 | unknown : Yard 19 | Tree 1 | Private 1 | 7 | Width 0ft | 5985123.7293 | 2098442.675 | 37.7410639474436 | -122.494050388555 | (37.7410639474436, -122.494050388555) | |||
134120 | 134120 | 185507 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 2400 Sunset Blvd | 61 | unknown : Yard 19 | Tree 1 | Private 1 | 40 | Width 0ft | 5985116.4249 | 2098801.2563 | 37.7420480876484 | -122.494102066238 | (37.7420480876484, -122.494102066238) | |||
134264 | 134264 | 185433 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 2300 Sunset Blvd | 49 | unknown : Yard 19 | Tree 1 | Private 1 | 2 | Width 0ft | 5985073.6434 | 2099396.3323 | 37.7436795021074 | -122.49429384193199 | (37.7436795021074, -122.494293841932) | |||
134829 | 134829 | 186518 | Undocumented 2 | Syagrus romanzoffianum :: Queen Palm 142 | 1400 Lower Great Hwy | 4 | unknown : Yard 19 | Tree 1 | Private 1 | 3 | Width 0ft | 5980903.7154 | 2105000.9085 | 37.758823173681606 | -122.50912828496901 | (37.7588231736816, -122.509128284969) | |||
135953 | 135953 | 185480 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 2400 Sunset Blvd | 33 | unknown : Yard 19 | Tree 1 | Private 1 | 16 | Width 0ft | 5985125.7214 | 2098482.5174 | 37.7411734605092 | -122.49404643640601 | (37.7411734605092, -122.494046436406) | |||
136486 | 136486 | 186550 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 1501 Sunset Blvd | 21 | unknown : Yard 19 | Tree 1 | Private 1 | 42 | Width 0ft | 5984736.7558 | 2104791.4736 | 37.7584733565115 | -122.49585660551 | (37.7584733565115, -122.49585660551) | |||
137300 | 137300 | 142638 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 333 BAY ST | 2 | unknown : Yard 19 | Tree 1 | Private 1 | 8 | Width 0ft | 6009068.3546 | 2121458.9525 | 37.8056332348144 | -122.41288516543301 | (37.8056332348144, -122.412885165433) | |||
137444 | 137444 | 142738 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 333 BAY ST | 3 | unknown : Yard 19 | Tree 1 | Private 1 | 11 | Width 0ft | 6009098.7568 | 2121462.5595 | 37.805644845194 | -122.412780209055 | (37.805644845194, -122.412780209055) | |||
137668 | 137668 | 200250 | Undocumented 2 | Eucalyptus sideroxylon :: Red Ironbark 36 | 917 Ingerson Ave | 1 | unknown : Yard 19 | Tree 1 | Private 1 | 5 | Width 0ft | 6014641.601 | 2089467.7692 | 37.7181036570096 | -122.391360208379 | (37.7181036570096, -122.391360208379) | |||
137771 | 137771 | 181360 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 2400 Sunset Blvd | 49 | unknown : Yard 19 | Tree 1 | Private 1 | 47 | Width 0ft | 5985113.1047 | 2098629.2701 | 37.7415756656355 | -122.494100873291 | (37.7415756656355, -122.494100873291) | |||
137799 | 137799 | 186560 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 1501 Sunset Blvd | 31 | unknown : Yard 19 | Tree 1 | Private 1 | 3 | Width 0ft | 5984754.3422 | 2104716.1033 | 37.7582674405997 | -122.495790225123 | (37.7582674405997, -122.495790225123) | |||
137933 | 137933 | 185406 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 2300 Sunset Blvd | 21 | unknown : Yard 19 | Tree 1 | Private 1 | 15 | Width 0ft | 5985111.1331 | 2099102.9134 | 37.742876046964604 | -122.494142591708 | (37.7428760469646, -122.494142591708) | |||
138059 | 138059 | 200229 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 1079 Ingerson Ave | 3 | unknown : Yard 19 | Tree 1 | Private 1 | 4 | Width 0ft | 6013701.2545 | 2090170.6816 | 37.719981480300795 | -122.39465980145201 | (37.7199814803008, -122.394659801452) | |||
144780 | 144780 | 200169 | Undocumented 2 | :: 54 | 1061 Hollister Ave | 1 | unknown : Yard 19 | Tree 1 | Private 1 | 0 | Width 0ft | 6014525.5668 | 2089911.1138 | 37.719314553356206 | -122.391792274296 | (37.7193145533562, -122.391792274296) | |||
146760 | 146760 | 186517 | Undocumented 2 | Pinus halepensis :: Allepo Pine 164 | 1400 Lower Great Hwy | 3 | unknown : Yard 19 | Tree 1 | Private 1 | 9 | Width 0ft | 5980906.8218 | 2104997.2844 | 37.7588134060814 | -122.509117272676 | (37.7588134060814, -122.509117272676) | |||
146842 | 146842 | 186566 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 1501 Sunset Blvd | 37 | unknown : Yard 19 | Tree 1 | Private 1 | 3 | Width 0ft | 5984742.1992 | 2104682.6054 | 37.7581747535408 | -122.49582974929 | (37.7581747535408, -122.49582974929) | |||
147019 | 147019 | 186536 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 1501 Sunset Blvd | 7 | unknown : Yard 19 | Tree 1 | Private 1 | 23 | Width 0ft | 5984741.2571 | 2104889.1409 | 37.758741787333705 | -122.495848242848 | (37.7587417873337, -122.495848242848) | |||
147039 | 147039 | 200193 | Undocumented 2 | :: 54 | 975 Ingerson Ave | 1 | unknown : Yard 19 | Tree 1 | Private 1 | 0 | Width 0ft | 6014303.5592 | 2089724.6542 | 37.7187902452961 | -122.392546641558 | (37.7187902452961, -122.392546641558) | |||
147307 | 147307 | 186567 | Undocumented 2 | Pittosporum crassifolium :: Karo Tree 108 | 1501 Sunset Blvd | 38 | unknown : Yard 19 | Tree 1 | Private 1 | 1 | Width 0ft | 5984755.1796 | 2104685.1177 | 37.7581824118079 | -122.49578504343799 | (37.7581824118079, -122.495785043438) | |||
147744 | 147744 | 200731 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 1462 Oakdale Ave | 1 | unknown : Yard 19 | Tree 1 | Private 1 | 4 | Width 0ft | 6015811.2335 | 2094944.8797 | 37.7332075665853 | -122.387699188627 | (37.7332075665853, -122.387699188627) |
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");