Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qCaretaker
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize ▼ | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 940 | 940 | 51496 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 1350 REVISED Fell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/16/2005 12:00:00 AM | Permit Number 47808 | 6000958.86990754 | 2110035.78536621 | 37.773809648853 | -122.44012948036101 | (37.773809648853, -122.440129480361) | |||
| 3571 | 3571 | 39975 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 0 Steiner St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Permit Number 41235 | |||||||||
| 7234 | 7234 | 113746 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 840X Broadway | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 6009590.33174 | 2118455.97825 | 37.7974170965836 | -122.410866557642 | (37.7974170965836, -122.410866557642) | ||||
| 7251 | 7251 | 67295 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 2021 Baker St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/13/2015 12:00:00 AM | 3 | Permit Number 775844 | 5999878.81667 | 2115908.61359 | 37.7898733737087 | -122.444287662668 | (37.7898733737087, -122.444287662668) | ||
| 8469 | 8469 | 46251 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 2683 Green St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/25/2016 12:00:00 AM | 7 | Permit Number 777339 | 6000247.41446 | 2117804.02133 | 37.7950986884031 | -122.44314853640101 | (37.7950986884031, -122.443148536401) | ||
| 8491 | 8491 | 67001 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 840X Broadway | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/20/1992 12:00:00 AM | 3 | Permit Number 30356 | 6009653.005480001 | 2118469.06923 | 37.7974565552432 | -122.410650614256 | (37.7974565552432, -122.410650614256) | ||
| 11073 | 11073 | 30310 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 228 Jordan Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Permit Number 8 | |||||||||
| 13382 | 13382 | 39972 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 0 Steiner St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Permit Number 41235 | |||||||||
| 14068 | 14068 | 30309 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 228 Jordan Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Permit Number 8 | |||||||||
| 18193 | 18193 | 39379 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 1354 Natoma St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/21/1998 12:00:00 AM | Permit Number 40920 | 6007143.93712268 | 2107602.08417603 | 37.7674774616365 | -122.41856167807501 | (37.7674774616365, -122.418561678075) | |||
| 19654 | 19654 | 104292 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 2245 Beach St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5999485.4 | 2120797.2 | 37.8032736772553 | -122.446000602494 | (37.8032736772553, -122.446000602494) | |||||
| 19684 | 19684 | 50106 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 1550 Portola Dr | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/28/2003 12:00:00 AM | Permit Number 46830 | 5992376.29027554 | 2096837.8582672002 | 37.7370792283941 | -122.468857136293 | (37.7370792283941, -122.468857136293) | ||
| 20617 | 20617 | 87007 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 7070 California St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/05/2007 12:00:00 AM | Permit Number 49944 | 5985878.0 | 2113896.0 | 37.7835385880022 | -122.49258024231199 | (37.7835385880022, -122.492580242312) | |||
| 22305 | 22305 | 68937 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 518 11th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/06/2017 12:00:00 AM | 3 | Permit Number 779489 | 5992539.41235 | 2111890.04765 | 37.7784180283155 | -122.46938847408998 | (37.7784180283155, -122.46938847409) | |
| 23512 | 23512 | 49013 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 2450 Francisco St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/31/2002 12:00:00 AM | 12 | Permit Number 46199 | 5999595.37201 | 2119840.2569999998 | 37.8006524480994 | -122.44555118855601 | (37.8006524480994, -122.445551188556) | ||
| 23976 | 23976 | 68013 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 2245 Beach St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/21/1993 12:00:00 AM | 21 | Permit Number 770742 | 5999478.9581699995 | 2120820.4060400003 | 37.803337026932894 | -122.446024564694 | (37.8033370269329, -122.446024564694) | ||
| 27654 | 27654 | 30297 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 2734 Buchanan St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/24/1956 12:00:00 AM | 9 | Permit Number 140 | 6003569.97515 | 2117774.33074 | 37.7952060548567 | -122.43164985595 | (37.7952060548567, -122.43164985595) | ||
| 30134 | 30134 | 34162 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 1321 Diamond St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/27/1997 12:00:00 AM | Permit Number 37995 | 6002005.24557776 | 2100252.01136141 | 37.747005294912896 | -122.435809748575 | (37.7470052949129, -122.435809748575) | |||
| 33086 | 33086 | 59887 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 21 Atalaya Ter | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/07/1981 12:00:00 AM | 23 | Permit Number 19353 | 5998815.1407 | 2110971.0405 | 37.776255342115604 | -122.447612291383 | (37.7762553421156, -122.447612291383) | |
| 34140 | 34140 | 106242 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 580 De Haro St | 5 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Permit Number 770844 | 6012041.04445 | 2105749.16688 | 37.7626642466674 | -122.401492899679 | (37.7626642466674, -122.401492899679) | |||
| 36388 | 36388 | 87087 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 20501 Lyon St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/20/2007 12:00:00 AM | 28 | Permit Number 50035 | 5999440.60645 | 2115900.3485 | 37.7898256691591 | -122.44580322984 | (37.7898256691591, -122.44580322984) | ||
| 38645 | 38645 | 32303 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 750 17th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Permit Number 36880 | 5990706.9497 | 2110266.1077900003 | 37.773853068141605 | -122.47560897417699 | (37.7738530681416, -122.475608974177) | |||
| 39721 | 39721 | 49030 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 2763 Green St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/06/2003 12:00:00 AM | 5 | Permit Number 46206 | 5999822.18303 | 2117741.39677 | 37.7949024824292 | -122.444615393602 | (37.7949024824292, -122.444615393602) | ||
| 39815 | 39815 | 38562 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 1620 McKinnon Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/17/1998 12:00:00 AM | 6 | Permit Number 40527 | 6015255.0701 | 2096054.7136 | 37.736224122234205 | -122.389699501807 | (37.7362241222342, -122.389699501807) | |
| 40274 | 40274 | 30342 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 3789 Fillmore St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Permit Number 27 | 6001955.9140099995 | 2121688.85818 | 37.8058626973628 | -122.437515213673 | (37.8058626973628, -122.437515213673) | |||
| 40979 | 40979 | 106249 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 580 De Haro St | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Permit Number 770844 | 6012059.457280001 | 2105702.6288 | 37.7625374908356 | -122.401425945147 | (37.7625374908356, -122.401425945147) | |||
| 41066 | 41066 | 49029 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 2763 Green St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/06/2003 12:00:00 AM | 6 | Permit Number 46206 | 5999835.8174 | 2117744.2115599997 | 37.7949109890951 | -122.444568419294 | (37.7949109890951, -122.444568419294) | ||
| 41597 | 41597 | 102629 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 168 25th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Permit Number 769953 | 5988063.8153 | 2114882.99878 | 37.7863761669029 | -122.485090700066 | (37.7863761669029, -122.485090700066) | |||
| 42983 | 42983 | 30852 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 99 South Van Ness Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/16/1995 12:00:00 AM | Permit Number 34698 | 6007267.59353144 | 2109330.19931681 | 37.772229418327 | -122.418256503442 | (37.772229418327, -122.418256503442) | |||
| 43180 | 43180 | 40179 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 1724 Pierce St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/27/1999 12:00:00 AM | 24 | Permit Number 41370 | 6002078.2803 | 2114497.9921 | 37.786125408317396 | -122.43657672143499 | (37.7861254083174, -122.436576721435) | ||
| 43203 | 43203 | 54713 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 2701 Pacific Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/22/1972 12:00:00 AM | 14 | Permit Number 11467 | 6001165.76206 | 2116883.2589 | 37.7926228359235 | -122.43990487063999 | (37.7926228359235, -122.43990487064) | ||
| 45050 | 45050 | 51789 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 1238 28th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/01/2005 12:00:00 AM | 13 | Permit Number 48038 | 5987411.1576 | 2106813.4078 | 37.7641812994666 | -122.486755921101 | (37.7641812994666, -122.486755921101) | ||
| 45398 | 45398 | 58302 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 3233 Jackson St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/02/1978 12:00:00 AM | 16 | Permit Number 17321 | 5998757.69678 | 2116224.86065 | 37.7906776778817 | -122.44818940014 | (37.7906776778817, -122.44818940014) | ||
| 47275 | 47275 | 30324 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 720 Montgomery St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/17/1956 12:00:00 AM | Permit Number 16 | 6011772.9424544005 | 2117800.56968196 | 37.7957396438077 | -122.403267984357 | (37.7957396438077, -122.403267984357) | |||
| 48911 | 48911 | 68331 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 2338 Anza St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/09/1993 12:00:00 AM | 9 | Permit Number 32146 | 5991366.81812 | 2112033.7901 | 37.778744872635606 | -122.473455364804 | (37.7787448726356, -122.473455364804) | ||
| 49151 | 49151 | 51005 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 674 03rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/23/2004 12:00:00 AM | 14 | Permit Number 47484 | 5995056.39173 | 2110967.50064 | 37.776030092024 | -122.460614488586 | (37.776030092024, -122.460614488586) | ||
| 49926 | 49926 | 30343 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 3789 Fillmore St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Permit Number 27 | 6001958.2216300005 | 2121669.55401 | 37.8058098244409 | -122.437505844543 | (37.8058098244409, -122.437505844543) | |||
| 51035 | 51035 | 68988 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 3336 Scott St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/04/1994 12:00:00 AM | 15 | Permit Number 32980 | 6000849.989680001 | 2119837.16995 | 37.8007155175595 | -122.441209485631 | (37.8007155175595, -122.441209485631) | |
| 51260 | 51260 | 40095 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 2249 Sutter St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/11/1999 12:00:00 AM | Permit Number 41318 | 6001849.57530622 | 2114273.14459713 | 37.7854950354219 | -122.437351872267 | (37.7854950354219, -122.437351872267) | |||
| 52209 | 52209 | 55630 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 836 Montgomery St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/06/1985 12:00:00 AM | 17 | Permit Number 22564 | 6011707.80627 | 2118223.6548200003 | 37.7968976958139 | -122.40352314977699 | (37.7968976958139, -122.403523149777) | ||
| 52657 | 52657 | 56020 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 2580 McAllister St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/12/1973 12:00:00 AM | 11 | Permit Number 12105 | 5996803.4076 | 2110776.9649 | 37.7756072847096 | -122.454557365701 | (37.7756072847096, -122.454557365701) | ||
| 53245 | 53245 | 93875 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 110 Beulah St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5997572.0 | 2107825.0 | 37.76754600118029 | -122.451685641377 | (37.7675460011803, -122.451685641377) | |||||
| 54385 | 54385 | 57519 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 1360 Taylor St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/30/1976 12:00:00 AM | 20 | Permit Number 16376 | 6008935.4598199995 | 2117576.8667900003 | 37.7949665312373 | -122.41307040029301 | (37.7949665312373, -122.413070400293) | ||
| 56042 | 56042 | 58355 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 1340 Taylor St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/13/1978 12:00:00 AM | 8 | Permit Number 17382 | 6008945.8597800005 | 2117518.1337200003 | 37.7948058484612 | -122.41303025994301 | (37.7948058484612, -122.413030259943) | ||
| 58950 | 58950 | 121048 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 2652 Polk St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 6006192.78395747 | 2119877.54417008 | 37.80112926306921 | -122.422724050002 | (37.8011292630692, -122.422724050002) | ||||
| 62537 | 62537 | 62749 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 3757 Washington St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/16/1988 12:00:00 AM | 12 | Permit Number 25749 | 5996846.35998 | 2115630.8360599997 | 37.7889371947488 | -122.454759549329 | (37.7889371947488, -122.454759549329) | ||
| 63651 | 63651 | 109426 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 132 Locust St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/13/2015 12:00:00 AM | 3 | 5997544.3 | 2115966.4 | 37.7898985728773 | -122.452369007612 | (37.7898985728773, -122.452369007612) | ||||
| 64542 | 64542 | 32423 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 2641 Union St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/08/1996 12:00:00 AM | 12 | Permit Number 36950 | 6000352.62092 | 2118166.6035700003 | 37.796100241774894 | -122.44281055586599 | (37.7961002417749, -122.442810555866) | ||
| 66181 | 66181 | 64574 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 2872 Golden Gate Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/28/1988 12:00:00 AM | 25 | Permit Number 25468 | 5995849.04615 | 2111058.0388 | 37.776324256889296 | -122.45787905836 | (37.7763242568893, -122.45787905836) | ||
| 67457 | 67457 | 43163 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 222 Madison St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/11/2000 12:00:00 AM | 8 | Permit Number 42973 | 6005640.84958 | 2092540.2669400002 | 37.7260364164322 | -122.42269019099301 | (37.7260364164322, -122.422690190993) | |
| 71789 | 71789 | 50877 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 2601on STEINER Sacramento St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/20/2004 12:00:00 AM | 14 | Permit Number 47387 | 6002325.5669599995 | 2115734.74753 | 37.789535271782 | -122.43580969708599 | (37.789535271782, -122.435809697086) | ||
| 72087 | 72087 | 42958 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 2243 Steiner St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/05/2000 12:00:00 AM | 13 | Permit Number 42847 | 6002313.59628 | 2115979.02805 | 37.7902053233739 | -122.435868599962 | (37.7902053233739, -122.435868599962) | ||
| 72364 | 72364 | 50989 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 3880 Washington St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Permit Number 47473 | 5996269.10887 | 2115596.09858 | 37.7888086870176 | -122.45675423481899 | (37.7888086870176, -122.456754234819) | |||
| 73211 | 73211 | 64087 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 474 Filbert St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/30/1987 12:00:00 AM | 19 | Permit Number 24849 | 6010630.0202 | 2119988.0407 | 37.801682008022496 | -122.407377010865 | (37.8016820080225, -122.407377010865) | ||
| 73295 | 73295 | 52034 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 2960 Steiner St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 17 | Permit Number 48246 | 6002027.71863 | 2118348.63065 | 37.7966953942316 | -122.437027433096 | (37.7966953942316, -122.437027433096) | |||
| 74119 | 74119 | 106241 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 580 De Haro St | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 10 | Permit Number 770844 | 6012039.11056 | 2105754.27928 | 37.7626781762725 | -122.401499947673 | (37.7626781762725, -122.401499947673) | |||
| 74534 | 74534 | 30341 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 3789 Fillmore St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/15/1956 12:00:00 AM | 10 | Permit Number 27 | 6001954.75028 | 2121707.36831 | 37.8059134550954 | -122.437520567314 | (37.8059134550954, -122.437520567314) | ||
| 77600 | 77600 | 99908 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 2001X Washington St | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Permit Number 768908 | 6005125.9 | 2116783.4 | 37.792573279433 | -122.426195525639 | (37.792573279433, -122.426195525639) | ||||
| 77907 | 77907 | 97260 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 1994@ Octavia Jackson St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6004661.4 | 2117107.1 | 37.7934358122691 | -122.427825787413 | (37.7934358122691, -122.427825787413) | |||||
| 77928 | 77928 | 40094 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 2249 Sutter St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/11/1999 12:00:00 AM | Permit Number 41318 | 6001849.57530622 | 2114273.14459713 | 37.7854950354219 | -122.437351872267 | (37.7854950354219, -122.437351872267) | |||
| 78040 | 78040 | 99901 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 2001X Washington St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Permit Number 768908 | 6005125.9 | 2116783.4 | 37.792573279433 | -122.426195525639 | (37.792573279433, -122.426195525639) | ||||
| 80213 | 80213 | 99606 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 2801X Buchanan St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Permit Number 43709 | 6003513.0 | 2117956.0 | 37.7957016423098 | -122.43185997681299 | (37.7957016423098, -122.431859976813) | ||||
| 80341 | 80341 | 99902 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 2001X Washington St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Permit Number 768908 | 6005125.9 | 2116783.4 | 37.792573279433 | -122.426195525639 | (37.792573279433, -122.426195525639) | ||||
| 80803 | 80803 | 47791 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 415 Ulloa St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/30/2002 12:00:00 AM | Permit Number 45915 | 5995369.31891331 | 2098249.44976906 | 37.741127575703004 | -122.45861111062 | (37.741127575703, -122.45861111062) | ||
| 81571 | 81571 | 30419 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 599 Jackson St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/24/1956 12:00:00 AM | Permit Number 74 | 6011244.65303661 | 2117958.27162773 | 37.7961431366669 | -122.40510708151699 | (37.7961431366669, -122.405107081517) | |||
| 81600 | 81600 | 87004 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 7070 California St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/05/2007 12:00:00 AM | Permit Number 49944 | 5985878.0 | 2113896.0 | 37.7835385880022 | -122.49258024231199 | (37.7835385880022, -122.492580242312) | |||
| 81857 | 81857 | 53099 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 370@HILL WAY Parnassus Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/30/2006 12:00:00 AM | Permit Number 49061 | 5996124.75088045 | 2106531.46709728 | 37.763911303006296 | -122.45659790095199 | (37.7639113030063, -122.456597900952) | |||
| 82012 | 82012 | 38955 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 1322 Masonic Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/13/1998 12:00:00 AM | Permit Number 40750 | 5999535.03970594 | 2108258.16543211 | 37.768847591977796 | -122.44492690983 | (37.7688475919778, -122.44492690983) | |||
| 84689 | 84689 | 49310 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 499@ Taylor Bay St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/20/2003 12:00:00 AM | Permit Number 46313 | 6008403.82866353 | 2121370.35158903 | 37.8053526360585 | -122.415178583983 | (37.8053526360585, -122.415178583983) | |||
| 84840 | 84840 | 44378 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 2914 Pacific Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/20/2001 12:00:00 AM | Permit Number 43741 | 6000185.55647701 | 2116798.34873064 | 37.7923338489092 | -122.443290306111 | (37.7923338489092, -122.443290306111) | |||
| 85496 | 85496 | 40557 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 1494 Noe St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/22/2002 12:00:00 AM | Permit Number 46100 | 6003279.18698139 | 2099536.66435899 | 37.74511340174829 | -122.431353516201 | (37.7451134017483, -122.431353516201) | |||
| 85602 | 85602 | 39261 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 6 Merced Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/14/1998 12:00:00 AM | Permit Number 40878 | 5995333.92231656 | 2100243.53450835 | 37.7466008020426 | -122.458877837799 | (37.7466008020426, -122.458877837799) | |||
| 86002 | 86002 | 50101 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 1520 Portola Dr | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/28/2003 12:00:00 AM | Permit Number 46828 | 5992463.83947388 | 2096912.47054003 | 37.7372891525979 | -122.46855986898599 | (37.7372891525979, -122.468559868986) | ||
| 86043 | 86043 | 48969 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 420 Stanyan St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/03/2002 12:00:00 AM | Permit Number 46156 | 5996812.82347571 | 2110321.29788885 | 37.77435668197629 | -122.454491869748 | (37.7743566819763, -122.454491869748) | |||
| 86265 | 86265 | 41311 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 41 Garcia Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/13/2002 12:00:00 AM | Permit Number 41984 | 5995254.05842615 | 2099498.8895679 | 37.7445516019752 | -122.459100086565 | (37.7445516019752, -122.459100086565) | ||
| 86484 | 86484 | 46614 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 1 Sola Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/12/2002 12:00:00 AM | Permit Number 44737 | 5995007.33907927 | 2100649.9152063 | 37.7476978436736 | -122.46003655522199 | (37.7476978436736, -122.460036555222) | |||
| 87192 | 87192 | 51553 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 3800 Washington St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/03/2005 12:00:00 AM | Permit Number 47852 | 5996586.74903344 | 2115641.8686237 | 37.788952592538706 | -122.455658560713 | (37.7889525925387, -122.455658560713) | |||
| 87663 | 87663 | 52883 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 1801@ NORIEGA 08th Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Permit Number 48888 | 5993719.57975271 | 2103223.93352011 | 37.7546912902093 | -122.464676406209 | (37.7546912902093, -122.464676406209) | ||||
| 88002 | 88002 | 109049 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 2146 Bay St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Permit Number 774033 | 6000515.3 | 2120331.0 | 37.802052372900896 | -122.442403120222 | (37.8020523729009, -122.442403120222) | ||||
| 88260 | 88260 | 30316 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 1190 Sacramento St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/24/1955 12:00:00 AM | Permit Number 12 | 6009097.70753924 | 2116729.99483623 | 37.792650334753205 | -122.412449106972 | (37.7926503347532, -122.412449106972) | |||
| 88277 | 88277 | 98819 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 62 Baker St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Permit Number 768816 | 6000868.0 | 2109174.0 | 37.7714382288844 | -122.440381995657 | (37.7714382288844, -122.440381995657) | ||||
| 88576 | 88576 | 30420 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 599 Jackson St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/24/1956 12:00:00 AM | Permit Number 74 | 6011244.65303661 | 2117958.27162773 | 37.7961431366669 | -122.40510708151699 | (37.7961431366669, -122.405107081517) | |||
| 88587 | 88587 | 51791 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 485 Colon Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/03/2005 12:00:00 AM | Permit Number 48040 | 5995434.95012874 | 2095496.4695716 | 37.733572339482 | -122.458184982463 | (37.733572339482, -122.458184982463) | |||
| 88642 | 88642 | 51704 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 171 Alpine Ter | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/18/2016 12:00:00 AM | 3 | Permit Number 777735 | 6001742.29918465 | 2107821.21142041 | 37.767773548810204 | -122.437260877297 | (37.7677735488102, -122.437260877297) | ||
| 89685 | 89685 | 94648 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 1811 Pierce St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Permit Number 53785 | 6001987.8 | 2114705.4 | 37.786689755292 | -122.436904612265 | (37.786689755292, -122.436904612265) | ||||
| 90561 | 90561 | 48354 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 18 Buena Vista Ter | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/17/2002 12:00:00 AM | Permit Number 45763 | 6001410.60770745 | 2108152.23015211 | 37.768663583108605 | -122.43843187465299 | (37.7686635831086, -122.438431874653) | |||
| 91072 | 91072 | 32418 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 1300 Ortega St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/08/1996 12:00:00 AM | Permit Number 36947 | 5990009.30581449 | 2102467.22445118 | 37.752398967394 | -122.477452096473 | (37.752398967394, -122.477452096473) | |||
| 91353 | 91353 | 95374 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 2270 Beach St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5999358.0 | 2120844.0 | 37.8033949017064 | -122.446444841619 | (37.8033949017064, -122.446444841619) | |||||
| 91365 | 91365 | 46254 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 2161 North Point St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Permit Number 44539 | 6000422.21933345 | 2120600.45809947 | 37.8027869270392 | -122.442744582339 | (37.8027869270392, -122.442744582339) | ||||
| 92300 | 92300 | 50099 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 1510 Portola Dr | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/28/2003 12:00:00 AM | Permit Number 46827 | 5992486.72879777 | 2096933.93018279 | 37.7373493975579 | -122.468482291601 | (37.7373493975579, -122.468482291601) | ||
| 92380 | 92380 | 43901 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 2940 Pacific Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/04/2000 12:00:00 AM | Permit Number 43503 | 6000066.19718413 | 2116781.74083104 | 37.7922814409941 | -122.44370209708401 | (37.7922814409941, -122.443702097084) | |||
| 92887 | 92887 | 121667 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 243 Vicente St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5992346.75268289 | 2097836.73381964 | 37.7398201819052 | -122.469031933295 | (37.7398201819052, -122.469031933295) | |||||
| 92902 | 92902 | 85305 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 365 Hazelwood Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/31/2007 12:00:00 AM | Permit Number 49591 | 5995968.6 | 2095545.0 | 37.733736241833704 | -122.456343520233 | (37.7337362418337, -122.456343520233) | |||
| 92936 | 92936 | 34180 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 104 Presidio Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/05/1997 12:00:00 AM | Permit Number 38006 | 5998990.33122805 | 2116224.12146592 | 37.7906889445626 | -122.447384447462 | (37.7906889445626, -122.447384447462) | |||
| 93440 | 93440 | 50998 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 2404 Broadway | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/23/2004 12:00:00 AM | Permit Number 47480 | 6002104.70119173 | 2117406.84878453 | 37.7941138815303 | -122.43669360820499 | (37.7941138815303, -122.436693608205) | |||
| 93502 | 93502 | 97262 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 1994@ Octavia Jackson St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6004661.4 | 2117107.1 | 37.7934358122691 | -122.427825787413 | (37.7934358122691, -122.427825787413) | |||||
| 93554 | 93554 | 87293 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 763 45th Ave | 3 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 03/19/2008 12:00:00 AM | Permit Number 50306 | 5981945.1 | 2110561.2 | 37.7741514699411 | -122.505938997766 | (37.7741514699411, -122.505938997766) | |||
| 93574 | 93574 | 100394 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 1800X Lincoln Way | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Permit Number 18187 | 5990148.1 | 2107238.4 | 37.7655073938756 | -122.477320788075 | (37.7655073938756, -122.477320788075) | ||||
| 93820 | 93820 | 50105 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 1550 Portola Dr | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/28/2003 12:00:00 AM | Permit Number 46830 | 5992376.29027554 | 2096837.8582672002 | 37.7370792283941 | -122.468857136293 | (37.7370792283941, -122.468857136293) | ||
| 94246 | 94246 | 39249 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 3168 Cesar Chavez St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/14/1998 12:00:00 AM | Permit Number 40877 | 6008614.08848489 | 2100618.91579037 | 37.7483859278404 | -122.41298280187401 | (37.7483859278404, -122.412982801874) |
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");