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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 123 | 123 | 18916 | DPW Maintained 3 | Olea europaea :: Olive Tree 41 | 2621 Sacramento St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 14 | 6x5 | 6002236.03231 | 2115724.70658 | 37.7895026155894 | -122.4361187581 | (37.7895026155894, -122.4361187581) | |||
| 175 | 175 | 17881 | DPW Maintained 3 | Olea europaea :: Olive Tree 41 | 2205 Pine St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6003346.6048 | 2115178.7939 | 37.7880667103656 | -122.432237297056 | (37.7880667103656, -122.432237297056) | |||
| 399 | 399 | 17856 | DPW Maintained 3 | Olea europaea :: Olive Tree 41 | 2121 Pine St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/21/2000 12:00:00 AM | 10 | 3X3 | 6003596.6138 | 2115206.3541 | 37.7881565558045 | -122.431374278321 | (37.7881565558045, -122.431374278321) | ||
| 464 | 464 | 18999 | DPW Maintained 3 | Olea europaea :: Olive Tree 41 | 3039 Sacramento St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 24 | 3x3 | 6000252.38525 | 2115449.79519 | 37.7886348840283 | -122.442962190565 | (37.7886348840283, -122.442962190565) | |||
| 949 | 949 | 13070 | DPW Maintained 3 | Olea europaea :: Olive Tree 41 | 630 Lombard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 22 | 3x3 | 6009332.6794 | 2120506.3975 | 37.803032589908106 | -122.4119030734 | (37.8030325899081, -122.4119030734) | |||
| 1289 | 1289 | 131895 | DPW Maintained 3 | Olea europaea :: Olive Tree 41 | 3274 Sacramento St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 16 | Width 4ft | 5999203.0 | 2115426.0 | 37.7885096634197 | -122.446591180632 | (37.7885096634197, -122.446591180632) | |||
| 1294 | 1294 | 6921 | DPW Maintained 3 | Olea europaea :: Olive Tree 41 | 425 Fell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 06/09/2010 12:00:00 AM | 3 | 3X3 | 6005385.421 | 2110602.3829 | 37.7756164008395 | -122.424857632506 | (37.7756164008395, -122.424857632506) | ||
| 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) | |||
| 1745 | 1745 | 17972 | DPW Maintained 3 | Olea europaea :: Olive Tree 41 | 2515 Pine St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3x3 | 6001748.1253 | 2114954.2725 | 37.7873594702652 | -122.437751658759 | (37.7873594702652, -122.437751658759) | |||
| 1778 | 1778 | 17971 | DPW Maintained 3 | Olea europaea :: Olive Tree 41 | 2515 Pine St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3x3 | 6001715.6676 | 2114951.5677 | 37.7873501979521 | -122.437863761621 | (37.7873501979521, -122.437863761621) | |||
| 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) | |||
| 2237 | 2237 | 17958 | DPW Maintained 3 | Olea europaea :: Olive Tree 41 | 2500 Pine St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 05/21/1992 12:00:00 AM | 6 | 3x3 | 6001912.0842 | 2115029.0126 | 37.7875740088989 | -122.437189749529 | (37.7875740088989, -122.437189749529) | ||
| 3109 | 3109 | 19037 | DPW Maintained 3 | Olea europaea :: Olive Tree 41 | 3235 Sacramento St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 5999309.28069 | 2115314.23141 | 37.788208846394895 | -122.446215424205 | (37.7882088463949, -122.446215424205) | |||
| 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) | |||
| 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) | |||
| 3468 | 3468 | 18831 | DPW Maintained 3 | Olea europaea :: Olive Tree 41 | 2001 Sacramento St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6005118.6821099995 | 2116122.7244599997 | 37.79075882281 | -122.426173443361 | (37.79075882281, -122.426173443361) | |||
| 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) | ||
| 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) | |||
| 3750 | 3750 | 253551 | DPW Maintained 3 | Olea europaea :: Olive Tree 41 | 1000 Cayuga Ave | 19 | Back Yard : Yard 13 | Tree 1 | DPW 2 | 09/22/2017 04:40:00 PM | 3 | 3x3 | 6000652.979169999 | 2091201.14277 | 37.7220768117153 | -122.43983693715201 | (37.7220768117153, -122.439836937152) | ||
| 3758 | 3758 | 253548 | DPW Maintained 3 | Olea europaea :: Olive Tree 41 | 1000 Cayuga Ave | 16 | Back Yard : Yard 13 | Tree 1 | DPW 2 | 09/22/2017 04:31:00 PM | 3 | 3x3 | 6000652.979169999 | 2091201.14277 | 37.7220768117153 | -122.43983693715201 | (37.7220768117153, -122.439836937152) | ||
| 3837 | 3837 | 253550 | DPW Maintained 3 | Olea europaea :: Olive Tree 41 | 1000 Cayuga Ave | 18 | Back Yard : Yard 13 | Tree 1 | DPW 2 | 09/27/2017 11:43:00 AM | 3 | 3x3 | 6000652.979169999 | 2091201.14277 | 37.7220768117153 | -122.43983693715201 | (37.7220768117153, -122.439836937152) | ||
| 3840 | 3840 | 253546 | DPW Maintained 3 | Olea europaea :: Olive Tree 41 | 1000 Cayuga Ave | 14 | Back Yard : Yard 13 | Tree 1 | DPW 2 | 09/27/2017 11:50:00 AM | 3 | 3x3 | 6000652.979169999 | 2091201.14277 | 37.7220768117153 | -122.43983693715201 | (37.7220768117153, -122.439836937152) | ||
| 3841 | 3841 | 253549 | DPW Maintained 3 | Olea europaea :: Olive Tree 41 | 1000 Cayuga Ave | 17 | Back Yard : Yard 13 | Tree 1 | DPW 2 | 09/27/2017 11:46:00 AM | 3 | 3x3 | 6000652.979169999 | 2091201.14277 | 37.7220768117153 | -122.43983693715201 | (37.7220768117153, -122.439836937152) | ||
| 3842 | 3842 | 253547 | DPW Maintained 3 | Olea europaea :: Olive Tree 41 | 1000 Cayuga Ave | 15 | Back Yard : Yard 13 | Tree 1 | DPW 2 | 09/27/2017 11:40:00 AM | 3 | 3x3 | 6000652.979169999 | 2091201.14277 | 37.7220768117153 | -122.43983693715201 | (37.7220768117153, -122.439836937152) | ||
| 4341 | 4341 | 13314 | DPW Maintained 3 | Olea europaea :: Olive Tree 41 | 3179X Sacramento St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 5999566.13783 | 2115354.5120599996 | 37.7883341120707 | -122.445329642351 | (37.7883341120707, -122.445329642351) | |||
| 4559 | 4559 | 132044 | DPW Maintained 3 | Olea europaea :: Olive Tree 41 | 444 Washington St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 05/16/2002 12:00:00 AM | 7 | Width 4ft | 6012372.27446 | 2117831.7295 | 37.795858655114 | -122.401196364438 | (37.795858655114, -122.401196364438) | ||
| 4914 | 4914 | 6236 | DPW Maintained 3 | Olea europaea :: Olive Tree 41 | 1250 Ellis St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/12/1995 12:00:00 AM | 12 | 3X3 | 6004877.1927 | 2113359.8717 | 37.78315906739 | -122.42681214119499 | (37.78315906739, -122.426812141195) | ||
| 4990 | 4990 | 3550 | DPW Maintained 3 | Olea europaea :: Olive Tree 41 | 201X Cargo Way | 60 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/16/1990 12:00:00 AM | 6 | 3X3 | 6018708.52549 | 2097590.55589 | 37.7406321362531 | -122.377865918974 | (37.7406321362531, -122.377865918974) | ||
| 5264 | 5264 | 17885 | DPW Maintained 3 | Olea europaea :: Olive Tree 41 | 2214 Pine St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6003222.3202 | 2115211.247 | 37.788148770729705 | -122.43266961876499 | (37.7881487707297, -122.432669618765) | |||
| 5320 | 5320 | 19014 | DPW Maintained 3 | Olea europaea :: Olive Tree 41 | 3122 Sacramento St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 4 | 3X3 | 5999831.14019 | 2115437.85116 | 37.788578063082106 | -122.44441877212401 | (37.7885780630821, -122.444418772124) | |||
| 5347 | 5347 | 18998 | DPW Maintained 3 | Olea europaea :: Olive Tree 41 | 3009 Sacramento St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 07/01/2011 12:00:00 AM | 3 | 3x3 | 6000320.39642 | 2115456.92187 | 37.788658329372396 | -122.442727394678 | (37.7886583293724, -122.442727394678) | ||
| 5418 | 5418 | 19000 | DPW Maintained 3 | Olea europaea :: Olive Tree 41 | 3042 Sacramento St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 4X4 | 6000225.4751699995 | 2115493.68766 | 37.7887538670327 | -122.44305844861401 | (37.7887538670327, -122.443058448614) | |||
| 5480 | 5480 | 87732 | DPW Maintained 3 | Olea europaea :: Olive Tree 41 | 3200X Van Ness Ave | 4 | Median : Cutout 11 | Tree 1 | DPW 2 | 05/10/2008 12:00:00 AM | 3 | 4x4 | 6005468.85489 | 2121438.02655 | 37.8053730758726 | -122.425340270033 | (37.8053730758726, -122.425340270033) | ||
| 5539 | 5539 | 17884 | DPW Maintained 3 | Olea europaea :: Olive Tree 41 | 2210 Pine St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 6003260.8806 | 2115214.139 | 37.7881588981801 | -122.43253641314399 | (37.7881588981801, -122.432536413144) | |||
| 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) | |||
| 5831 | 5831 | 18814 | DPW Maintained 3 | Olea europaea :: Olive Tree 41 | 1921 Sacramento St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6005353.8734800005 | 2116157.5446599997 | 37.7908677208195 | -122.42536217123501 | (37.7908677208195, -122.425362171235) | |||
| 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) | |||
| 5864 | 5864 | 17800 | DPW Maintained 3 | Olea europaea :: Olive Tree 41 | 1855 Pine St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 8 | 3x3 | 6005059.342 | 2115410.1523 | 37.788798924352996 | -122.42632800170901 | (37.788798924353, -122.426328001709) | |||
| 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) | |||
| 5914 | 5914 | 18827 | DPW Maintained 3 | Olea europaea :: Olive Tree 41 | 1911 Sacramento St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6005492.837780001 | 2116179.1366 | 37.7909348570073 | -122.424882897351 | (37.7909348570073, -122.424882897351) | |||
| 5944 | 5944 | 96090 | DPW Maintained 3 | Olea europaea :: Olive Tree 41 | 3122 Sacramento St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 06/04/2011 12:00:00 AM | 3 | 3x3 | 5999797.96737 | 2115433.02091 | 37.7885629076984 | -122.444533197372 | (37.7885629076984, -122.444533197372) | ||
| 5961 | 5961 | 18819 | DPW Maintained 3 | Olea europaea :: Olive Tree 41 | 1850 Sacramento St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6005893.34484 | 2116280.69836 | 37.7912363340264 | -122.423504381436 | (37.7912363340264, -122.423504381436) | |||
| 6026 | 6026 | 13056 | DPW Maintained 3 | Olea europaea :: Olive Tree 41 | 567 Lombard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/06/2016 07:33:00 AM | 3 | 3X3 | 6009638.2249 | 2120505.3867 | 37.8030469515764 | -122.410845650802 | (37.8030469515764, -122.410845650802) | ||
| 6142 | 6142 | 13315 | DPW Maintained 3 | Olea europaea :: Olive Tree 41 | 3179X Sacramento St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 5999602.752730001 | 2115359.85021 | 37.7883508592612 | -122.445203345153 | (37.7883508592612, -122.445203345153) | |||
| 6218 | 6218 | 19042 | DPW Maintained 3 | Olea europaea :: Olive Tree 41 | 3257 Sacramento St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 2X2 | 5999209.87226 | 2115305.32061 | 37.7881787020404 | -122.44655871793002 | (37.7881787020404, -122.44655871793) | |||
| 6241 | 6241 | 19036 | DPW Maintained 3 | Olea europaea :: Olive Tree 41 | 3238 Sacramento St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 15 | 3x3 | 5999312.475430001 | 2115365.10303 | 37.7883487089688 | -122.44620803177 | (37.7883487089688, -122.44620803177) | |||
| 6318 | 6318 | 18908 | DPW Maintained 3 | Olea europaea :: Olive Tree 41 | 2604 Sacramento St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6002262.241669999 | 2115774.64436 | 37.7896412209083 | -122.436031651553 | (37.7896412209083, -122.436031651553) | |||
| 6319 | 6319 | 18822 | DPW Maintained 3 | Olea europaea :: Olive Tree 41 | 1865 Sacramento St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 6005869.22375 | 2116234.13797 | 37.791107129344 | -122.423584528107 | (37.791107129344, -122.423584528107) | |||
| 6388 | 6388 | 17794 | DPW Maintained 3 | Olea europaea :: Olive Tree 41 | 1844 Pine St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6005100.3317 | 2115473.1057 | 37.7889740955094 | -122.426190666694 | (37.7889740955094, -122.426190666694) | |||
| 6441 | 6441 | 26640 | DPW Maintained 3 | Olea europaea :: Olive Tree 41 | 2616 Sacramento St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 11/02/1998 12:00:00 AM | 6 | 3X3 | 6002091.06438 | 2115751.37049 | 37.789567590709794 | -122.436622239943 | (37.7895675907098, -122.436622239943) | ||
| 6468 | 6468 | 26723 | DPW Maintained 3 | Olea europaea :: Olive Tree 41 | 1881 Pine St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 07/15/1999 12:00:00 AM | 3 | 3x3 | 6004971.2268 | 2115402.5662 | 37.788773113656795 | -122.426632327607 | (37.7887731136568, -122.426632327607) | ||
| 6473 | 6473 | 4379 | DPW Maintained 3 | Olea europaea :: Olive Tree 41 | 2425X Hyde St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 11 | 3X3 | 6007005.3355 | 2120662.9996700003 | 37.803331735330204 | -122.419968034 | (37.8033317353302, -122.419968034) | |||
| 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) | |||
| 6807 | 6807 | 18828 | DPW Maintained 3 | Olea europaea :: Olive Tree 41 | 1930 Sacramento St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 14 | 4X4 | 6005538.83813 | 2116230.7825700003 | 37.791079262040604 | -122.424727413533 | (37.7910792620406, -122.424727413533) | |||
| 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) | |||
| 6941 | 6941 | 87735 | DPW Maintained 3 | Olea europaea :: Olive Tree 41 | 3200X Van Ness Ave | 7 | Median : Cutout 11 | Tree 1 | DPW 2 | 05/10/2008 12:00:00 AM | 3 | 4x4 | 6005457.063999999 | 2121526.81323 | 37.8056161950061 | -122.42538739630501 | (37.8056161950061, -122.425387396305) | ||
| 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) | |||
| 7087 | 7087 | 17893 | DPW Maintained 3 | Olea europaea :: Olive Tree 41 | 2250 Pine St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3.5x3.5 | 6003147.3555 | 2115199.7182 | 37.7881128639093 | -122.43292815958901 | (37.7881128639093, -122.432928159589) | |||
| 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) | |||
| 7276 | 7276 | 13053 | DPW Maintained 3 | Olea europaea :: Olive Tree 41 | 551 Lombard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/06/2016 07:36:00 AM | 3 | 3X3 | 6009716.4111 | 2120517.6505 | 37.8030850086189 | -122.410575951119 | (37.8030850086189, -122.410575951119) | ||
| 7277 | 7277 | 18945 | DPW Maintained 3 | Olea europaea :: Olive Tree 41 | 2820 Sacramento St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 6001293.28859 | 2115641.38083 | 37.789220219475204 | -122.439374566504 | (37.7892202194752, -122.439374566504) | |||
| 7401 | 7401 | 17978 | DPW Maintained 3 | Olea europaea :: Olive Tree 41 | 2566 Pine St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3x3 | 6001667.0697 | 2115001.0109 | 37.7874831926794 | -122.43803544289601 | (37.7874831926794, -122.438035442896) | |||
| 7410 | 7410 | 17886 | DPW Maintained 3 | Olea europaea :: Olive Tree 41 | 2216 Pine St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6003201.1119 | 2115208.837 | 37.788140950699 | -122.432742823561 | (37.788140950699, -122.432742823561) | |||
| 7417 | 7417 | 27383 | DPW Maintained 3 | Olea europaea :: Olive Tree 41 | 2560 Hyde St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 13 | 3X3 | 6006988.37342 | 2121139.78035 | 37.8046398981635 | -122.420060587734 | (37.8046398981635, -122.420060587734) | |||
| 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) | |||
| 7485 | 7485 | 18914 | DPW Maintained 3 | Olea europaea :: Olive Tree 41 | 2614 Sacramento St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 2X2 | 6002119.347 | 2115753.8125400003 | 37.7895759031475 | -122.43652456008002 | (37.7895759031475, -122.43652456008) | |||
| 7590 | 7590 | 17792 | DPW Maintained 3 | Olea europaea :: Olive Tree 41 | 1836 Pine St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3x3 | 6005150.5923 | 2115481.6114 | 37.7890002907164 | -122.42601737732402 | (37.7890002907164, -122.426017377324) | |||
| 7615 | 7615 | 17857 | DPW Maintained 3 | Olea europaea :: Olive Tree 41 | 2121 Pine St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/21/2001 12:00:00 AM | 6 | 3X3 | 6003618.2335 | 2115208.8109 | 37.788164526801204 | -122.43129965333401 | (37.7881645268012, -122.431299653334) | ||
| 7738 | 7738 | 6091 | DPW Maintained 3 | Olea europaea :: Olive Tree 41 | 2004 Eddy St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6000795.3066 | 2112440.8396 | 37.780404005029396 | -122.44086783303801 | (37.7804040050294, -122.440867833038) | |||
| 7766 | 7766 | 18061 | DPW Maintained 3 | Olea europaea :: Olive Tree 41 | 2892 Pine St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6000138.8729 | 2114783.4706 | 37.786798857700795 | -122.443307046821 | (37.7867988577008, -122.443307046821) | |||
| 7842 | 7842 | 17887 | DPW Maintained 3 | Olea europaea :: Olive Tree 41 | 2225 Pine St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 05/23/2016 12:00:00 AM | 8 | 3x3 | 6003257.8293 | 2115161.3078 | 37.7880136640849 | -122.432543195006 | (37.7880136640849, -122.432543195006) | ||
| 7854 | 7854 | 13019 | DPW Maintained 3 | Olea europaea :: Olive Tree 41 | 426 Lombard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 06/09/2016 01:54:00 PM | 3 | 4X4 | 6010282.8242 | 2120633.0492 | 37.803433603680396 | -122.408624001449 | (37.8034336036804, -122.408624001449) | ||
| 7863 | 7863 | 19013 | DPW Maintained 3 | Olea europaea :: Olive Tree 41 | 3109 Sacramento St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 5999823.86194 | 2115389.41015 | 37.78844464145371 | -122.44444047095502 | (37.7884446414537, -122.444440470955) | |||
| 8021 | 8021 | 18824 | DPW Maintained 3 | Olea europaea :: Olive Tree 41 | 1871 Sacramento St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 14 | 3X3 | 6005826.024569999 | 2116228.56745 | 37.7910893956089 | -122.423733599744 | (37.7910893956089, -122.423733599744) | |||
| 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) | |||
| 8045 | 8045 | 17795 | DPW Maintained 3 | Olea europaea :: Olive Tree 41 | 1844 Pine St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6005085.8335 | 2115472.9124 | 37.7889727452829 | -122.426240814802 | (37.7889727452829, -122.426240814802) | |||
| 8058 | 8058 | 13044 | DPW Maintained 3 | Olea europaea :: Olive Tree 41 | 532 Lombard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/16/2015 07:51:00 AM | 3 | 3X3 | 6009787.8556 | 2120566.4846 | 37.803223100103295 | -122.41033216474399 | (37.8032231001033, -122.410332164744) | ||
| 8117 | 8117 | 18842 | DPW Maintained 3 | Olea europaea :: Olive Tree 41 | 2101 Sacramento St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 10 | 3x3 | 6004680.66603 | 2116061.68172 | 37.790566447935795 | -122.427684606568 | (37.7905664479358, -122.427684606568) | |||
| 8182 | 8182 | 18907 | DPW Maintained 3 | Olea europaea :: Olive Tree 41 | 2603 Sacramento St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 07/07/2011 12:00:00 AM | 3 | 1x1 | 6002308.81598 | 2115730.88168 | 37.7895237056151 | -122.435867376882 | (37.7895237056151, -122.435867376882) | ||
| 8314 | 8314 | 17796 | DPW Maintained 3 | Olea europaea :: Olive Tree 41 | 1844 Pine St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6005069.2088 | 2115468.6596 | 37.7889601284654 | -122.42629803117799 | (37.7889601284654, -122.426298031178) | |||
| 8419 | 8419 | 17793 | DPW Maintained 3 | Olea europaea :: Olive Tree 41 | 1843 Pine St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3x3 | 6005105.442000001 | 2115417.7383 | 37.7888223593362 | -122.426169042396 | (37.7888223593362, -122.426169042396) | |||
| 8473 | 8473 | 19015 | DPW Maintained 3 | Olea europaea :: Olive Tree 41 | 3135 Sacramento St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 17 | 3X3 | 5999785.512569999 | 2115383.13203 | 37.7884252151982 | -122.444572701871 | (37.7884252151982, -122.444572701871) | |||
| 8572 | 8572 | 17914 | DPW Maintained 3 | Olea europaea :: Olive Tree 41 | 2334 Pine St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/25/2008 12:00:00 AM | 7 | 3X3 | 6002756.0379 | 2115149.5391 | 37.7879528818401 | -122.43427846037201 | (37.7879528818401, -122.434278460372) | ||
| 8701 | 8701 | 18048 | DPW Maintained 3 | Olea europaea :: Olive Tree 41 | 2825 Pine St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 08/12/2016 10:48:00 AM | 3 | 3X3 | 6000177.1728 | 2114733.4163 | 37.7866636055248 | -122.443170942274 | (37.7866636055248, -122.443170942274) | ||
| 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) | |||
| 8793 | 8793 | 6234 | DPW Maintained 3 | Olea europaea :: Olive Tree 41 | 1250 Ellis St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 07/17/1991 12:00:00 AM | 12 | 3X3 | 6004935.7353 | 2113364.5007 | 37.7831750872989 | -122.426609937065 | (37.7831750872989, -122.426609937065) | ||
| 8846 | 8846 | 18825 | DPW Maintained 3 | Olea europaea :: Olive Tree 41 | 1875 Sacramento St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6005783.22199 | 2116219.7593799997 | 37.7910627945724 | -122.42388106877199 | (37.7910627945724, -122.423881068772) | |||
| 8848 | 8848 | 18064 | DPW Maintained 3 | Olea europaea :: Olive Tree 41 | 2902 Pine St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/08/1997 12:00:00 AM | 12 | 3X3 | 6000013.6639 | 2114768.6486 | 37.7867510196451 | -122.44373917398 | (37.7867510196451, -122.44373917398) | ||
| 8886 | 8886 | 18912 | DPW Maintained 3 | Olea europaea :: Olive Tree 41 | 2610 Sacramento St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6002161.87395 | 2115762.44795 | 37.789602030260205 | -122.436378039822 | (37.7896020302602, -122.436378039822) | |||
| 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) | ||
| 9011 | 9011 | 18996 | DPW Maintained 3 | Olea europaea :: Olive Tree 41 | 3001 Sacramento St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 06/10/2011 12:00:00 AM | 6 | 3x3 | 6000347.20569 | 2115461.97657 | 37.78867373653829 | -122.442635001919 | (37.7886737365383, -122.442635001919) | ||
| 9279 | 9279 | 19768 | DPW Maintained 3 | Olea europaea :: Olive Tree 41 | 100 STAIRWAY16 | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 30ST | ||||||||
| 9812 | 9812 | 13084 | DPW Maintained 3 | Olea europaea :: Olive Tree 41 | 660 Lombard St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 10/24/2015 11:03:00 AM | 3 | 3X3 | 6009204.3394 | 2120486.8898 | 37.80297182561711 | -122.41234581877701 | (37.8029718256171, -122.412345818777) | ||
| 9822 | 9822 | 822 | DPW Maintained 3 | Olea europaea :: Olive Tree 41 | 1411 45th Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/02/2015 05:39:00 PM | 3 | 3X3 | 5982129.0913294 | 2105488.1375738997 | 37.7602331322527 | -122.50492654488 | (37.7602331322527, -122.50492654488) | ||
| 10518 | 10518 | 820 | DPW Maintained 3 | Olea europaea :: Olive Tree 41 | 1407 45th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/02/2015 05:29:00 PM | 3 | 3X3 | 5982131.0395 | 2105513.2639 | 37.760302236597 | -122.504921669151 | (37.760302236597, -122.504921669151) | ||
| 10681 | 10681 | 821 | DPW Maintained 3 | Olea europaea :: Olive Tree 41 | 1409 45th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/02/2015 05:34:00 PM | 3 | 3X3 | 5982132.645 | 2105492.3927 | 37.7602450246853 | -122.504914569939 | (37.7602450246853, -122.504914569939) | ||
| 10744 | 10744 | 15929 | DPW Maintained 3 | Olea europaea :: Olive Tree 41 | 5763 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 06/01/1992 12:00:00 AM | 6 | 3X3 | 5997783.780180001 | 2086793.9366099997 | 37.7098118993789 | -122.44943761417 | (37.7098118993789, -122.44943761417) | ||
| 10746 | 10746 | 15961 | DPW Maintained 3 | Olea europaea :: Olive Tree 41 | 5873 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 05/29/2015 12:00:00 AM | 3 | 3X3 | 5997080.5771 | 2086512.6894900003 | 37.7089994077614 | -122.451847724407 | (37.7089994077614, -122.451847724407) | ||
| 11196 | 11196 | 15930 | DPW Maintained 3 | Olea europaea :: Olive Tree 41 | 5763 Mission St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 06/01/1992 12:00:00 AM | 6 | 3X3 | 5997809.15318 | 2086804.3845099998 | 37.709842038350104 | -122.449350673092 | (37.7098420383501, -122.449350673092) | ||
| 12318 | 12318 | 15707 | DPW Maintained 3 | Olea europaea :: Olive Tree 41 | 4298 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/01/2012 12:00:00 AM | 3 | 3x3 | 6003201.3472 | 2093656.0609099998 | 37.72896219882671 | -122.431203002635 | (37.7289621988267, -122.431203002635) |
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");