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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 8992 | 8992 | 8761 | DPW Maintained 3 | Olea europaea :: Olive Tree 41 | 3355 Geary Blvd | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 11/10/1994 12:00:00 AM | 3 | 3X3 | 5996781.7933 | 2112879.265 | 37.7813784089154 | -122.454784059286 | (37.7813784089154, -122.454784059286) | ||
| 81198 | 81198 | 8894 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 4375X Geary Blvd | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/10/1994 12:00:00 AM | 3 | 3X3 | 5993510.5115 | 2112736.2897099997 | 37.780797651526704 | -122.46609061586399 | (37.7807976515267, -122.466090615864) | ||
| 117564 | 117564 | 8962 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 5011 Geary Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 5991525.868530001 | 2112664.68093 | 37.7804863348081 | -122.472951170268 | (37.7804863348081, -122.472951170268) | |||
| 94932 | 94932 | 8976 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 5099X Geary Blvd | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 3X3 | 5991393.24434 | 2112659.90412 | 37.7804655400069 | -122.473409626847 | (37.7804655400069, -122.473409626847) | |||
| 22758 | 22758 | 8985 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 5133 Geary Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 3X3 | 5991037.8127 | 2112647.8841 | 37.78041194791 | -122.474638342176 | (37.78041194791, -122.474638342176) | |||
| 146166 | 146166 | 8989 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 5145 Geary Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 5990994.34586 | 2112623.6372700003 | 37.7803428541028 | -122.47478694253 | (37.7803428541028, -122.47478694253) | |||
| 90579 | 90579 | 9001 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 5240 Geary Blvd | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 5990780.2624 | 2112729.94687 | 37.780622342937896 | -122.475535313697 | (37.7806223429379, -122.475535313697) | |||
| 22565 | 22565 | 9029 | DPW Maintained 3 | Olea europaea :: Olive Tree 41 | 5351 Geary Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 5990343.7121 | 2112622.3264 | 37.780301530706296 | -122.47703766733 | (37.7803015307063, -122.47703766733) | |||
| 22442 | 22442 | 9062 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 5525 Geary Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 3X3 | 5989837.7609 | 2112604.3144 | 37.7802227097378 | -122.478786649669 | (37.7802227097378, -122.478786649669) | |||
| 22686 | 22686 | 9063 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 5529 Geary Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 5989797.972999999 | 2112602.4325 | 37.7802152322039 | -122.478924155076 | (37.7802152322039, -122.478924155076) | |||
| 22374 | 22374 | 9065 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 5537 Geary Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3x3 | 5989786.9858 | 2112602.3503 | 37.7802143684845 | -122.478962158407 | (37.7802143684845, -122.478962158407) | |||
| 85146 | 85146 | 9066 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 5539 Geary Blvd | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 3x3 | 5989796.615780001 | 2112601.55216 | 37.780212736223 | -122.478928785863 | (37.780212736223, -122.478928785863) | |||
| 22523 | 22523 | 9112 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 5731 Geary Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 5989195.2404 | 2112580.9255 | 37.7801211615255 | -122.481007684457 | (37.7801211615255, -122.481007684457) | |||
| 22739 | 22739 | 9114 | DPW Maintained 3 | Olea europaea :: Olive Tree 41 | 5757 Geary Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/12/2011 12:00:00 AM | 3 | 3x3 | 5989097.9213 | 2112579.3125 | 37.780111075033396 | -122.48134423338301 | (37.7801110750334, -122.481344233383) | ||
| 22436 | 22436 | 9115 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 5757 Geary Blvd | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 3X3 | 5989122.1167 | 2112578.7748 | 37.7801110053489 | -122.48126049209499 | (37.7801110053489, -122.481260492095) | |||
| 22453 | 22453 | 9128 | DPW Maintained 3 | Olea europaea :: Olive Tree 41 | 5840 Geary Blvd | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3x3 | 5988869.9475 | 2112669.6418 | 37.7803458369415 | -122.482139508426 | (37.7803458369415, -122.482139508426) | |||
| 22765 | 22765 | 9129 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 5843 Geary Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 3x3 | 5988848.4406 | 2112566.946 | 37.7800626121426 | -122.482206383921 | (37.7800626121426, -122.482206383921) | |||
| 22722 | 22722 | 9130 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 5843 Geary Blvd | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 3x3 | 5988875.3243 | 2112569.0967 | 37.780070081021705 | -122.48211353976002 | (37.7800700810217, -122.48211353976) | |||
| 22458 | 22458 | 9163 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 6001 Geary Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 5988313.9515 | 2112548.4697 | 37.7799807782466 | -122.484054045264 | (37.7799807782466, -122.484054045264) | |||
| 22613 | 22613 | 9164 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 6001 Geary Blvd | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 5988336.7568 | 2112550.1465 | 37.779986709952794 | -122.48397527547199 | (37.7799867099528, -122.483975275472) | |||
| 22665 | 22665 | 9165 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 6001 Geary Blvd | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 5988358.8914 | 2112549.8112 | 37.779987077901204 | -122.48389867831101 | (37.7799870779012, -122.483898678311) | |||
| 22791 | 22791 | 9166 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 6001 Geary Blvd | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 5988380.3553 | 2112551.8234 | 37.7799938523312 | -122.483824573547 | (37.7799938523312, -122.483824573547) | |||
| 117180 | 117180 | 9168 | DPW Maintained 3 | Olea europaea :: Olive Tree 41 | 6039 Geary Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 11/14/2012 12:00:00 AM | 3 | 3X3 | 5988224.924240001 | 2112522.53315 | 37.77990438026679 | -122.484360123846 | (37.7799043802668, -122.484360123846) | ||
| 86468 | 86468 | 9169 | DPW Maintained 3 | Olea europaea :: Olive Tree 41 | 6037 Geary Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/02/1998 12:00:00 AM | 9 | 3X3 | 5988226.75232 | 2112484.2258099997 | 37.7797993055455 | -122.484350989435 | (37.7797993055455, -122.484350989435) | ||
| 22752 | 22752 | 9190 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 6128 Geary Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 4X4 | 5987955.2707 | 2112636.8403 | 37.7802025302416 | -122.48530135353799 | (37.7802025302416, -122.485301353538) | |||
| 22740 | 22740 | 9192 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 6138 Geary Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | 4X4 | 5987910.6661 | 2112635.8342 | 37.780197169187296 | -122.485455585501 | (37.7801971691873, -122.485455585501) | |||
| 145754 | 145754 | 9199 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 6200 Geary Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/19/2005 12:00:00 AM | 3 | 3X3 | 5987748.35465 | 2112645.73467 | 37.780214895385704 | -122.486017814968 | (37.7802148953857, -122.486017814968) | ||
| 141070 | 141070 | 9200 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 6200 Geary Blvd | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/19/2005 12:00:00 AM | 3 | 3X3 | 5987748.35465 | 2112645.73467 | 37.780214895385704 | -122.486017814968 | (37.7802148953857, -122.486017814968) | ||
| 105051 | 105051 | 9724 | DPW Maintained 3 | Olea europaea :: Olive Tree 41 | 605X Gough St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 8 | 4x4 | 6005802.58314 | 2111825.66599 | 37.7789987924589 | -122.423501552072 | (37.7789987924589, -122.423501552072) | |||
| 6521 | 6521 | 9725 | DPW Maintained 3 | Olea europaea :: Olive Tree 41 | 621 Gough St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 4x4 | 6005796.9989 | 2111889.3567 | 37.779173356417 | -122.42352539952 | (37.779173356417, -122.42352539952) | |||
| 3680 | 3680 | 9726 | DPW Maintained 3 | Olea europaea :: Olive Tree 41 | 621 Gough St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 4x4 | 6005799.3606 | 2111864.1645 | 37.779104318085295 | -122.42351543791099 | (37.7791043180853, -122.423515437911) | |||
| 5703 | 5703 | 9727 | DPW Maintained 3 | Olea europaea :: Olive Tree 41 | 621 Gough St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 4x4 | 6005801.3288 | 2111846.4513 | 37.779055793051 | -122.423507369454 | (37.779055793051, -122.423507369454) | |||
| 8024 | 8024 | 9728 | DPW Maintained 3 | Olea europaea :: Olive Tree 41 | 629 Gough St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 4x4 | 6005789.7168 | 2111936.3952 | 37.779302101626705 | -122.423553936469 | (37.7793021016267, -122.423553936469) | |||
| 141681 | 141681 | 9729 | DPW Maintained 3 | Olea europaea :: Olive Tree 41 | 633 Gough St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 4x4 | 6005786.04675 | 2111952.13361 | 37.7793451083039 | -122.423567751964 | (37.7793451083039, -122.423567751964) | |||
| 5862 | 5862 | 9730 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 637 Gough St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 4x4 | 6005783.8123 | 2111973.7899 | 37.779404445065396 | -122.42357702198099 | (37.7794044450654, -122.423577021981) | |||
| 1656 | 1656 | 9731 | DPW Maintained 3 | Olea europaea :: Olive Tree 41 | 641 Gough St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 2 | 4x4 | 6005777.9079 | 2111995.4394 | 37.7794635560295 | -122.42359898745899 | (37.7794635560295, -122.423598987459) | |||
| 3640 | 3640 | 9732 | DPW Maintained 3 | Olea europaea :: Olive Tree 41 | 645 Gough St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 06/14/2011 12:00:00 AM | 3 | 4x4 | 6005775.5462 | 2112013.5463 | 37.7795131398465 | -122.423608445305 | (37.7795131398465, -122.423608445305) | ||
| 143688 | 143688 | 9733 | DPW Maintained 3 | Olea europaea :: Olive Tree 41 | 649 Gough St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 8 | 4x4 | 6005777.60667 | 2112009.54549 | 37.7795022709045 | -122.42360103272699 | (37.7795022709045, -122.423601032727) | |||
| 5839 | 5839 | 9898 | DPW Maintained 3 | Olea europaea :: Olive Tree 41 | 1800X Pine St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 3X3 | 6004962.1152 | 2115451.6483 | 37.788907365673204 | -122.42666734903999 | (37.7889073656732, -122.42666734904) | |||
| 94057 | 94057 | 9899 | DPW Maintained 3 | Olea europaea :: Olive Tree 41 | 1820 PINE ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3 | 3X3 | 6005214.0 | 2115481.0 | 37.789002195347294 | -122.425797951343 | (37.7890021953473, -122.425797951343) | |||
| 119041 | 119041 | 9900 | DPW Maintained 3 | Olea europaea :: Olive Tree 41 | 1820 PINE ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6005214.0 | 2115481.0 | 37.789002195347294 | -122.425797951343 | (37.7890021953473, -122.425797951343) | |||
| 6976 | 6976 | 9913 | DPW Maintained 3 | Olea europaea :: Olive Tree 41 | 1901X Sacramento St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 6x6 | 6005586.32531 | 2116197.05094 | 37.7909893253357 | -122.424560708918 | (37.7909893253357, -122.424560708918) | |||
| 9180 | 9180 | 9916 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 1990X Sacramento St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 3X3 | 6005305.17759 | 2116200.067 | 37.790981725181 | -122.42553368453301 | (37.790981725181, -122.425533684533) | |||
| 20963 | 20963 | 10267 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 229X Haight St | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 24 | 4x5 | 6004928.575180001 | 2109497.01592 | 37.7725555175436 | -122.4263592559 | (37.7725555175436, -122.4263592559) | |||
| 23002 | 23002 | 10268 | DPW Maintained 3 | Olea europaea :: Olive Tree 41 | 215X Haight St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 2 | 6005053.18335 | 2109512.97249 | 37.772606373329396 | -122.42592935924601 | (37.7726063733294, -122.425929359246) | ||||
| 17955 | 17955 | 10276 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 215X Haight St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 90 | 3X3 | 6004948.0554599995 | 2109498.71961 | 37.7725612966014 | -122.42629199289699 | (37.7725612966014, -122.426291992897) | |||
| 21478 | 21478 | 10278 | DPW Maintained 3 | Olea europaea :: Olive Tree 41 | 215X Haight St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 08/12/1996 12:00:00 AM | 6 | 6X6 | 6005000.61509 | 2109505.63565 | 37.7725832571536 | -122.42611067607099 | (37.7725832571536, -122.426110676071) | ||
| 20014 | 20014 | 10374 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 1292 Haight St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/21/2001 12:00:00 AM | 6 | 3X3 | 6000060.6155 | 2108870.7918 | 37.7705596914501 | -122.44315299047199 | (37.7705596914501, -122.443152990472) | ||
| 17053 | 17053 | 10375 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 1296 Haight St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/12/2007 12:00:00 AM | 12 | 3X3 | 6000028.8313 | 2108866.5222 | 37.7705461558325 | -122.443262625265 | (37.7705461558325, -122.443262625265) | ||
| 13814 | 13814 | 10604 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 18 Hawkins Ln | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/27/1992 12:00:00 AM | 6 | 3X3 | 6017010.864569999 | 2095475.59177 | 37.73473117440221 | -122.383588632512 | (37.7347311744022, -122.383588632512) | ||
| 125198 | 125198 | 11131 | DPW Maintained 3 | Olea europaea :: Olive Tree 41 | 2400X Hyde St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 6007074.907250499 | 2120528.613771 | 37.802966665104 | -122.41971773705099 | (37.802966665104, -122.419717737051) | |||
| 110668 | 110668 | 11132 | DPW Maintained 3 | Olea europaea :: Olive Tree 41 | 2425 Hyde St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6007002.1553976 | 2120687.0718744 | 37.803397652325 | -122.41998074815399 | (37.803397652325, -122.419980748154) | |||
| 3427 | 3427 | 11134 | DPW Maintained 3 | Olea europaea :: Olive Tree 41 | 2454 Hyde St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 45 | 3X3 | 6007041.13953 | 2120754.1462 | 37.8035840176492 | -122.41985060413299 | (37.8035840176492, -122.419850604133) | |||
| 3162 | 3162 | 11135 | DPW Maintained 3 | Olea europaea :: Olive Tree 41 | 2454 Hyde St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 45 | 3X3 | 6007038.94291 | 2120769.9344599997 | 37.8036272444521 | -122.41985932665199 | (37.8036272444521, -122.419859326652) | |||
| 7429 | 7429 | 11136 | DPW Maintained 3 | Olea europaea :: Olive Tree 41 | 2454 Hyde St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 45 | 3X3 | 6007037.38216 | 2120783.1998 | 37.803663579779204 | -122.41986566958299 | (37.8036635797792, -122.419865669583) | |||
| 98696 | 98696 | 11137 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 2455X Hyde St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 24 | 3X3 | 6006975.507678599 | 2120876.6023828997 | 37.8039165535698 | -122.420086422377 | (37.8039165535698, -122.420086422377) | |||
| 122047 | 122047 | 11138 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 2455X Hyde St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 45 | 3X3 | 6006975.507678599 | 2120876.6023828997 | 37.8039165535698 | -122.420086422377 | (37.8039165535698, -122.420086422377) | |||
| 121329 | 121329 | 11140 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 2455X Hyde St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 30 | 3X3 | 6006975.507678599 | 2120876.6023828997 | 37.8039165535698 | -122.420086422377 | (37.8039165535698, -122.420086422377) | |||
| 118702 | 118702 | 11141 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 2455X Hyde St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 45 | 3X3 | 6006975.507678599 | 2120876.6023828997 | 37.8039165535698 | -122.420086422377 | (37.8039165535698, -122.420086422377) | |||
| 2990 | 2990 | 11143 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 2553X Hyde St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | PUC 13 | 36 | 3X3 | 6006932.12852 | 2121148.49105 | 37.804660646434996 | -122.42025584765301 | (37.804660646435, -122.420255847653) | |||
| 1980 | 1980 | 11144 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 2553X Hyde St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | PUC 13 | 36 | 3X3 | 6006934.8566 | 2121129.59308 | 37.8046089111446 | -122.42024506476801 | (37.8046089111446, -122.420245064768) | |||
| 103862 | 103862 | 11145 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 2595X Hyde St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | PUC 13 | 36 | 3X3 | 6006932.7654086 | 2121177.816266 | 37.804741201891495 | -122.420255726238 | (37.8047412018915, -122.420255726238) | |||
| 128539 | 128539 | 11146 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 2595X Hyde St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | PUC 13 | 40 | 3X3 | 6006932.7654086 | 2121177.816266 | 37.804741201891495 | -122.420255726238 | (37.8047412018915, -122.420255726238) | |||
| 140009 | 140009 | 11147 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 2595X Hyde St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | PUC 13 | 6 | 3X3 | 6006932.7654086 | 2121177.816266 | 37.804741201891495 | -122.420255726238 | (37.8047412018915, -122.420255726238) | |||
| 101063 | 101063 | 11148 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 2595X Hyde St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | PUC 13 | 40 | 3X3 | 6006932.7654086 | 2121177.816266 | 37.804741201891495 | -122.420255726238 | (37.8047412018915, -122.420255726238) | |||
| 120483 | 120483 | 11149 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 2595X Hyde St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | PUC 13 | 36 | 3X3 | 6006932.7654086 | 2121177.816266 | 37.804741201891495 | -122.420255726238 | (37.8047412018915, -122.420255726238) | |||
| 99823 | 99823 | 11150 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 2595X Hyde St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | PUC 13 | 36 | 3X3 | 6006932.7654086 | 2121177.816266 | 37.804741201891495 | -122.420255726238 | (37.8047412018915, -122.420255726238) | |||
| 138383 | 138383 | 11151 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 2595X Hyde St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | PUC 13 | 36 | 3X3 | 6006932.7654086 | 2121177.816266 | 37.804741201891495 | -122.420255726238 | (37.8047412018915, -122.420255726238) | |||
| 113524 | 113524 | 11152 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 2595X Hyde St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | PUC 13 | 36 | 3X3 | 6006932.7654086 | 2121177.816266 | 37.804741201891495 | -122.420255726238 | (37.8047412018915, -122.420255726238) | |||
| 6132 | 6132 | 11153 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 2603 Hyde St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 30 | 3X3 | 6006916.69653 | 2121280.21725 | 37.8050214634311 | -122.420318606842 | (37.8050214634311, -122.420318606842) | |||
| 8511 | 8511 | 11154 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 2603 Hyde St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 30 | 3X3 | 6006919.78752 | 2121256.3248099997 | 37.804956035058495 | -122.420306213261 | (37.8049560350585, -122.420306213261) | |||
| 1926 | 1926 | 11155 | DPW Maintained 3 | Olea europaea :: Olive Tree 41 | 2615 Hyde St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 30 | 3X3 | 6006917.28019 | 2121296.80497 | 37.805067041968 | -122.420317765078 | (37.805067041968, -122.420317765078) | |||
| 9210 | 9210 | 11156 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 2618 Hyde St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 3X3 | 6006962.612869999 | 2121312.5054900004 | 37.80511270594771 | -122.420162000697 | (37.8051127059477, -122.420162000697) | |||
| 9303 | 9303 | 11157 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 2621 Hyde St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | 3X3 | 6006915.48876 | 2121316.55267 | 37.8051211631688 | -122.420325367033 | (37.8051211631688, -122.420325367033) | |||
| 8736 | 8736 | 11158 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 2626 Hyde St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 3X3 | 6006955.38483 | 2121356.90745 | 37.8052342151411 | -122.42019016746599 | (37.8052342151411, -122.420190167466) | |||
| 6828 | 6828 | 11159 | DPW Maintained 3 | Olea europaea :: Olive Tree 41 | 2627 Hyde St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 24 | 3X3 | 6006915.19061 | 2121341.6845 | 37.8051901519615 | -122.420328183697 | (37.8051901519615, -122.420328183697) | |||
| 9132 | 9132 | 11160 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 2632 Hyde St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 30 | 3X3 | 6006954.37609 | 2121379.1362 | 37.80529519278 | -122.420195236936 | (37.80529519278, -122.420195236936) | |||
| 103231 | 103231 | 11161 | DPW Maintained 3 | Olea europaea :: Olive Tree 41 | 2638 Hyde St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 30 | 3X3 | 6006954.2638733005 | 2121382.2190943 | 37.805303651298296 | -122.420195844212 | (37.8053036512983, -122.420195844212) | |||
| 142500 | 142500 | 11162 | DPW Maintained 3 | Olea europaea :: Olive Tree 41 | 2640 Hyde St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6006953.557207401 | 2121387.1992738997 | 37.8053172857834 | -122.420198643397 | (37.8053172857834, -122.420198643397) | |||
| 9087 | 9087 | 11163 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 2646 Hyde St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | 3X3 | 6006947.21164 | 2121442.50233 | 37.8054687763153 | -122.420224530547 | (37.8054687763153, -122.420224530547) | |||
| 7672 | 7672 | 11164 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 2650 Hyde St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 30 | 3x3 | 6006942.2149 | 2121476.64604 | 37.8055622446775 | -122.42024424728999 | (37.8055622446775, -122.42024424729) | |||
| 7807 | 7807 | 11165 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 2655 Hyde St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 6006893.18193 | 2121482.83945 | 37.8055764872155 | -122.42041437295 | (37.8055764872155, -122.42041437295) | |||
| 6990 | 6990 | 11166 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 2655 Hyde St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 30 | 3X3 | 6006897.54428 | 2121449.5194099997 | 37.8054852447207 | -122.420396909886 | (37.8054852447207, -122.420396909886) | |||
| 3589 | 3589 | 11167 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 2655 Hyde St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | 3X3 | 6006899.01173 | 2121433.76541 | 37.805442070952 | -122.42039071266501 | (37.805442070952, -122.420390712665) | |||
| 18405 | 18405 | 11168 | DPW Maintained 3 | Olea europaea :: Olive Tree 41 | 2666 Hyde St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 11 | 3X3 | 6006944.2763295 | 2121452.6056321 | 37.8054963520093 | -122.420235406119 | (37.8054963520093, -122.420235406119) | |||
| 5888 | 5888 | 11169 | DPW Maintained 3 | Olea europaea :: Olive Tree 41 | 2700 Hyde St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 36 | 3X3 | 6006924.13035 | 2121583.86925 | 37.8058556331999 | -122.420314446577 | (37.8058556331999, -122.420314446577) | |||
| 8792 | 8792 | 11170 | DPW Maintained 3 | Olea europaea :: Olive Tree 41 | 2706 Hyde St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 36 | 3X3 | 6006921.64786 | 2121607.86712 | 37.805921385333 | -122.42032474199 | (37.805921385333, -122.42032474199) | |||
| 6289 | 6289 | 11171 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 2714 Hyde St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 36 | 3X3 | 6006919.28151 | 2121625.44427 | 37.805969514352604 | -122.420334179488 | (37.8059695143526, -122.420334179488) | |||
| 9009 | 9009 | 11172 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 2717 Hyde St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 3X3 | 6006856.95142 | 2121692.8865 | 37.80615118099271 | -122.42055467348301 | (37.8061511809927, -122.420554673483) | |||
| 126649 | 126649 | 11174 | DPW Maintained 3 | Olea europaea :: Olive Tree 41 | 2721 Hyde St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 36 | 3X3 | 6006871.9159428 | 2121607.3582758 | 37.8059171856884 | -122.420496811264 | (37.8059171856884, -122.420496811264) | |||
| 7265 | 7265 | 11178 | DPW Maintained 3 | Olea europaea :: Olive Tree 41 | 2741 Hyde St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 40 | 3X3 | 6006856.2652 | 2121744.00393 | 37.806291497706106 | -122.42056067914899 | (37.8062914977061, -122.420560679149) | |||
| 81923 | 81923 | 11183 | DPW Maintained 3 | Olea europaea :: Olive Tree 41 | 2765 Hyde St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/15/1997 12:00:00 AM | 12 | 3X3 | 6006851.5978528 | 2121751.8788051005 | 37.8063128570627 | -122.420577390706 | (37.8063128570627, -122.420577390706) | ||
| 97969 | 97969 | 11184 | DPW Maintained 3 | Olea europaea :: Olive Tree 41 | 2765 Hyde St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 36 | 3X3 | 6006851.5978528 | 2121751.8788051005 | 37.8063128570627 | -122.420577390706 | (37.8063128570627, -122.420577390706) | |||
| 89578 | 89578 | 11198 | DPW Maintained 3 | Olea europaea :: Olive Tree 41 | 186 Idora Ave | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 6 | 8 | 5995344.6608195 | 2099448.7962231003 | 37.74441926622529 | -122.45878317784799 | (37.7444192662253, -122.458783177848) | |||
| 110940 | 110940 | 11431 | DPW Maintained 3 | Olea europaea :: Olive Tree 41 | 301X Jackson St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 05/15/2002 12:00:00 AM | 3 | 3X3 | 6012526.011002599 | 2118137.4589098 | 37.796706690547 | -122.40068589218399 | (37.796706690547, -122.400685892184) | ||
| 98513 | 98513 | 12193 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 1465 La Salle Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 3X3 | 6016272.6778818 | 2095480.4561363999 | 37.7347037020974 | -122.386141159163 | (37.7347037020974, -122.386141159163) | |||
| 14191 | 14191 | 12216 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 1523 La Salle Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/25/1992 12:00:00 AM | 15 | 3X3 | 6015935.5625 | 2095820.8342 | 37.735619647499 | -122.387330428498 | (37.735619647499, -122.387330428498) | ||
| 89289 | 89289 | 12445 | DPW Maintained 3 | Olea europaea :: Olive Tree 41 | 2001X Pine St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 05/21/1992 12:00:00 AM | 9 | 3X3 | 6004358.038801401 | 2115316.8218262 | 37.788502995764 | -122.42874775597299 | (37.788502995764, -122.428747755973) | ||
| 85121 | 85121 | 12449 | DPW Maintained 3 | Olea europaea :: Olive Tree 41 | 2000X Pine St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/21/2000 12:00:00 AM | 3 | 3x3 | 6004305.4732621 | 2115359.9984935 | 37.7886185728388 | -122.42893270408301 | (37.7886185728388, -122.428932704083) | ||
| 124074 | 124074 | 12506 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 2 LAKE ST | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | 3x3 | 5995351.0 | 2115102.0 | 37.7873992668989 | -122.459894934345 | (37.7873992668989, -122.459894934345) |
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");