trees
11,761 rows where qSpecies_id = 17 sorted by Police Districts descending
This data as json, CSV (advanced)
rowid | TreeID | qLegalStatus_id | qSpecies_id | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker_id | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location | Fire Prevention Districts | Police Districts ▲ | Supervisor Districts | Zip Codes | Neighborhoods (old) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
29 | 264952 | Significant Tree 6 | Tree(s) :: 17 | 20X Cleary Ct | 2 | Front Yard : Yard | Tree | Private 2 | 11/13/2020 12:00:00 AM | 3 | 6004818 | 2113712 | 37.7841225773231 | -122.427042012496 | (37.7841225773231, -122.427042012496) | 13 | 9 | 11 | 28858 | 41 | |||
31 | 264951 | Significant Tree 6 | Tree(s) :: 17 | 20X Cleary Ct | 1 | Front Yard : Yard | Tree | Private 2 | 11/13/2020 12:00:00 AM | 3 | 6004818 | 2113712 | 37.7841225773231 | -122.427042012496 | (37.7841225773231, -122.427042012496) | 13 | 9 | 11 | 28858 | 41 | |||
376 | 33627 | Permitted Site 7 | Tree(s) :: 17 | 315 Lily St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/02/1996 12:00:00 AM | Permit Number 37728 | 6005028.27785393 | 2110030.93274628 | 37.7740271589488 | -122.426052389372 | (37.7740271589488, -122.426052389372) | 7 | 9 | 11 | 28852 | 10 | |||
949 | 38398 | Permitted Site 7 | Tree(s) :: 17 | 1000 Van Ness Ave | 17 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/30/1998 12:00:00 AM | Permit Number 40450 | 6006538.75328643 | 2113902.05144478 | 37.7847415646224 | -122.421102312622 | (37.7847415646224, -122.421102312622) | 7 | 9 | 9 | 28858 | 36 | |||
1292 | 102259 | DPW Maintained 1 | Tree(s) :: 17 | 904 Steiner St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/09/2013 12:00:00 AM | 9 | 3x3 | Permit Number 769677 | 6003013.4 | 2111448.1 | 37.7778042661218 | -122.433123466086 | (37.7778042661218, -122.433123466086) | 15 | 9 | 11 | 29492 | 41 | |
1730 | 121323 | Undocumented 4 | Tree(s) :: 17 | 3699X Laguna St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6003556 | 2121083 | 37.8042900105203 | -122.431934584375 | (37.8042900105203, -122.431934584375) | 13 | 9 | 1 | 28858 | 17 | ||||
1748 | 56640 | Permitted Site 7 | Tree(s) :: 17 | 2016 Pine St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6004277.89575757 | 2115357.17634953 | 37.7886092629589 | -122.429027916831 | (37.7886092629589, -122.429027916831) | 13 | 9 | 11 | 29490 | 27 | |||||
2294 | 84947 | Permitted Site 7 | Tree(s) :: 17 | 1812 Webster St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6003475 | 2114918 | 37.7873579154126 | -122.431774444579 | (37.7873579154126, -122.431774444579) | 13 | 9 | 11 | 29490 | 27 | |||||
2733 | 107738 | Undocumented 4 | Tree(s) :: 17 | 155x HAYES ST | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/04/2016 12:00:00 AM | 3 | 3x3 | Permit Number 774227 | 6007127.8 | 2111172.9 | 37.7772811641179 | -122.41887077508 | (37.7772811641179, -122.41887077508) | 7 | 9 | 9 | 28852 | 36 | |
2856 | 64671 | Permitted Site 7 | Tree(s) :: 17 | 825 Van Ness Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/11/1988 12:00:00 AM | Permit Number 25617 | 6006551.01917293 | 2113304.1780681 | 37.7831006421796 | -122.421017411704 | (37.7831006421796, -122.421017411704) | 7 | 9 | 11 | 28858 | 41 | |||
3436 | 103654 | Significant Tree 6 | Tree(s) :: 17 | 307X Octavia St | 3 | Front Yard : Yard | Tree | DPW for City Agency 14 | 06/07/2013 12:00:00 AM | Permit Number 770306 | 6005538.74006 | 2110314.20336 | 37.7748337884081 | -122.424306762839 | (37.7748337884081, -122.424306762839) | 7 | 9 | 11 | 28852 | 10 | |||
4131 | 38411 | Permitted Site 7 | Tree(s) :: 17 | 1000 Van Ness Ave | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/30/1998 12:00:00 AM | Permit Number 40450 | 6006538.75328643 | 2113902.05144478 | 37.7847415646224 | -122.421102312622 | (37.7847415646224, -122.421102312622) | 7 | 9 | 9 | 28858 | 36 | |||
4249 | 98418 | DPW Maintained 1 | Tree(s) :: 17 | 1501X Steiner St | 2 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 3x3 | Permit Number 768629 | 6002677.2 | 2113386.1 | 37.7831064505465 | -122.434425094313 | (37.7831064505465, -122.434425094313) | 13 | 9 | 11 | 29490 | 41 | |||
4754 | 101985 | Undocumented 4 | Tree(s) :: 17 | 205X Rose St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6005538.6 | 2109749.6 | 37.7732835163003 | -122.424267082997 | (37.7732835163003, -122.424267082997) | 7 | 9 | 11 | 28852 | 10 | ||||
4853 | 107519 | Undocumented 4 | Tree(s) :: 17 | 100x CHURCH ST | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6004015.5 | 2108290.9 | 37.7691921614924 | -122.429431648714 | (37.7691921614924, -122.429431648714) | 7 | 9 | 5 | 28862 | 3 | ||||||
5178 | 53028 | Permitted Site 7 | Tree(s) :: 17 | 2709@ UNION Baker St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/06/2006 12:00:00 AM | Permit Number 49007 | 5999568.7122913 | 2118115.36126644 | 37.7959148228215 | -122.445519339313 | (37.7959148228215, -122.445519339313) | 13 | 9 | 1 | 57 | 17 | |||
5262 | 63631 | Permitted Site 7 | Tree(s) :: 17 | 3011 Steiner St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/22/1987 12:00:00 AM | Permit Number 24274 | 6001965.52820466 | 2118455.53354324 | 37.7969853865901 | -122.437250284017 | (37.7969853865901, -122.437250284017) | 13 | 9 | 1 | 57 | 17 | |||
5412 | 261620 | Planning Code 138.1 required 2 | Tree(s) :: 17 | 1633 Washington St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/05/2020 12:00:00 AM | 3 | 3x3 | 6006860 | 2117000 | 37.7932658708928 | -122.420210847334 | (37.7932658708928, -122.420210847334) | 13 | 9 | 10 | 28858 | 32 | ||
5664 | 50654 | Permitted Site 7 | Tree(s) :: 17 | 2824 Octavia St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/30/2003 12:00:00 AM | Permit Number 47236 | 6004394.14845271 | 2118840.16150037 | 37.7981792344265 | -122.428874109151 | (37.7981792344265, -122.428874109151) | 13 | 9 | 1 | 57 | 17 | |||
5842 | 52901 | Permitted Site 7 | Tree(s) :: 17 | 2460 Lyon St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/10/2006 12:00:00 AM | Permit Number 48895 | 5999270.65065072 | 2117331.25061337 | 37.7937448428959 | -122.446494245637 | (37.7937448428959, -122.446494245637) | 13 | 9 | 1 | 57 | 27 | |||
6159 | 61799 | Permitted Site 7 | Tree(s) :: 17 | 150 Steiner St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/24/1985 12:00:00 AM | Permit Number 21825 | 6003367 | 2108901.1 | 37.7708308840658 | -122.431718346405 | (37.7708308840658, -122.431718346405) | 15 | 9 | 11 | 29492 | 10 | |||
6748 | 57527 | Permitted Site 7 | Tree(s) :: 17 | 700 Laguna St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/05/1976 12:00:00 AM | Permit Number 16386 | 6004962.9591132 | 2111265.64001346 | 37.7774136719189 | -122.426366266738 | (37.7774136719189, -122.426366266738) | 7 | 9 | 11 | 28852 | 10 | |||
6818 | 102380 | Permitted Site 7 | Tree(s) :: 17 | 2050 Chestnut St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/01/2013 12:00:00 AM | 14 | 3x3 | Permit Number 771000 | 6001969 | 2119823 | 37.8007402883162 | -122.437336238425 | (37.8007402883162, -122.437336238425) | 13 | 9 | 1 | 57 | 17 | |
7885 | 57193 | Permitted Site 7 | Tree(s) :: 17 | 633 Larkin St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/12/1974 12:00:00 AM | Permit Number 14473 | 6007510.46945444 | 2113541.05571027 | 37.7838050881462 | -122.417714890881 | (37.7838050881462, -122.417714890881) | 7 | 9 | 9 | 28858 | 36 | |||
8352 | 84946 | Permitted Site 7 | Tree(s) :: 17 | 1812 Webster St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6003475 | 2114918 | 37.7873579154126 | -122.431774444579 | (37.7873579154126, -122.431774444579) | 13 | 9 | 11 | 29490 | 27 | |||||
8885 | 60056 | Permitted Site 7 | Tree(s) :: 17 | 2806 Vallejo St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/02/1982 12:00:00 AM | Permit Number 19555 | 6000126.85269277 | 2117488.31614972 | 37.7942249702165 | -122.443543007615 | (37.7942249702165, -122.443543007615) | 13 | 9 | 1 | 57 | 27 | |||
9622 | 64841 | Permitted Site 7 | Tree(s) :: 17 | 2715 Scott St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/19/1989 12:00:00 AM | Permit Number 25853 | 6001106.5651027 | 2117655.58396036 | 37.7947400688298 | -122.440165102012 | (37.7947400688298, -122.440165102012) | 13 | 9 | 1 | 57 | 27 | |||
9842 | 114329 | Permitted Site 7 | Tree(s) :: 17 | 1701X Green St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/10/2015 12:00:00 AM | 3x3 | Permit Number 776565 | 6004666.60531 | 2118440.00919 | 37.7970959359465 | -122.427902799084 | (37.7970959359465, -122.427902799084) | 13 | 9 | 1 | 57 | 17 | ||
10233 | 48519 | Permitted Site 7 | Tree(s) :: 17 | 1(REVISED) Church St | 11 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/22/2002 12:00:00 AM | Permit Number 45844 | 6004110.55275805 | 2108703.1215343 | 37.7703294028669 | -122.429132262601 | (37.7703294028669, -122.429132262601) | 7 | 9 | 5 | 29492 | 10 | |||
10599 | 63494 | Permitted Site 7 | Tree(s) :: 17 | 2513 Broadway | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/07/1987 12:00:00 AM | Permit Number 24091 | 6001599.24421586 | 2117284.80982338 | 37.7937500563512 | -122.438433791844 | (37.7937500563512, -122.438433791844) | 13 | 9 | 1 | 29490 | 27 | |||
10874 | 57412 | Permitted Site 7 | Tree(s) :: 17 | 2250 Bush St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/01/1976 12:00:00 AM | Permit Number 16579 | 6002738.79121903 | 2114797.05697252 | 37.7869840767613 | -122.434312920752 | (37.7869840767613, -122.434312920752) | 13 | 9 | 11 | 29490 | 27 | |||
12638 | 23783 | Permitted Site 7 | Tree(s) :: 17 | 1010 Webster St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/02/2014 12:00:00 AM | 30 | 3X3 | Permit Number 771274 | 6003903.8361546 | 2112182.8886989 | 37.7798722837048 | -122.430095570639 | (37.7798722837048, -122.430095570639) | 7 | 9 | 11 | 29490 | 41 | |
13917 | 106712 | Permitted Site 7 | Tree(s) :: 17 | 3713 Scott St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/28/2014 12:00:00 AM | 3x3 | Permit Number 772877 | 6000611 | 2121098.3 | 37.804164627793 | -122.442127063949 | (37.804164627793, -122.442127063949) | 13 | 9 | 1 | 57 | 17 | ||
14469 | 173738 | DPW Maintained 1 | Tree(s) :: 17 | 2500X Lyon St | 5 | Median : Yard | Tree | Private 2 | 3x3 | 5999276 | 2117538 | 37.7943128273924 | -122.446490617691 | (37.7943128273924, -122.446490617691) | 13 | 9 | 1 | 57 | 27 | ||||
14622 | 58380 | Permitted Site 7 | Tree(s) :: 17 | 1942 Pacific Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/22/1979 12:00:00 AM | Permit Number 17512 | 6004837.57646053 | 2117446.27673196 | 37.7943770702204 | -122.427240374859 | (37.7943770702204, -122.427240374859) | 13 | 9 | 1 | 28858 | 27 | |||
15160 | 260680 | Significant Tree 6 | Tree(s) :: 17 | 1450x Laguna St | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | 3x3 | 6004617 | 2113883 | 37.7845807327875 | -122.42774958855 | (37.7845807327875, -122.42774958855) | 13 | 9 | 11 | 28858 | 41 | ||||
15196 | 35624 | Permitted Site 7 | Tree(s) :: 17 | 701 Hayes St | 16 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/30/1998 12:00:00 AM | Permit Number 38975 | 6004496.45349332 | 2110824.80795168 | 37.7761768741411 | -122.427948642674 | (37.7761768741411, -122.427948642674) | 7 | 9 | 11 | 28852 | 10 | |||
15615 | 94975 | Permitted Site 7 | Tree(s) :: 17 | 2040@Jackson Franklin St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/14/2010 12:00:00 AM | 9 | 3x3 | Permit Number 54005 | 6005619 | 2117006 | 37.7932123416077 | -122.42450522172 | (37.7932123416077, -122.42450522172) | 13 | 9 | 1 | 28858 | 27 | |
15720 | 46217 | Permitted Site 7 | Tree(s) :: 17 | 1888 Lombard St | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/10/2002 12:00:00 AM | Permit Number 44530 | 6003335.27744655 | 2119677.01043482 | 37.8004170150887 | -122.432597920925 | (37.8004170150887, -122.432597920925) | 13 | 9 | 1 | 57 | 17 | |||
16247 | 57235 | Permitted Site 7 | Tree(s) :: 17 | 2032 Webster St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/13/1975 12:00:00 AM | Permit Number 14522 | 6003376.0386691 | 2115678.16974905 | 37.7894395384443 | -122.432171137582 | (37.7894395384443, -122.432171137582) | 13 | 9 | 1 | 29490 | 27 | |||
16310 | 38334 | Permitted Site 7 | Tree(s) :: 17 | 1 Oak St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/28/1998 12:00:00 AM | Permit Number 40402 | 6006951.79358069 | 2110471.67174177 | 37.7753458477676 | -122.419429879592 | (37.7753458477676, -122.419429879592) | 7 | 9 | 11 | 28852 | 10 | |||
16401 | 46226 | Permitted Site 7 | Tree(s) :: 17 | 1888 Lombard St | 11 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/10/2002 12:00:00 AM | Permit Number 44530 | 6003335.27744655 | 2119677.01043482 | 37.8004170150887 | -122.432597920925 | (37.8004170150887, -122.432597920925) | 13 | 9 | 1 | 57 | 17 | |||
16455 | 61898 | Permitted Site 7 | Tree(s) :: 17 | 1109 Geary Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/20/1985 12:00:00 AM | 3x3 | Permit Number 21941 | 6006414.68057735 | 2114214.88071456 | 37.7855935218483 | -122.42155378935 | (37.7855935218483, -122.42155378935) | 13 | 9 | 11 | 28858 | 41 | ||
16475 | 110244 | Permitted Site 7 | Tree(s) :: 17 | 2582 Filbert St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/08/2015 12:00:00 AM | 3 | Permit Number 775248 | 6000594.1 | 2118607.8 | 37.7973254142876 | -122.442006676457 | (37.7973254142876, -122.442006676457) | 13 | 9 | 1 | 57 | 17 | ||
17156 | 60894 | Permitted Site 7 | Tree(s) :: 17 | 1859 Filbert St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/11/1983 12:00:00 AM | Permit Number 20679 | 6004057.39639007 | 2119023.78706692 | 37.7986643569133 | -122.430052476684 | (37.7986643569133, -122.430052476684) | 13 | 9 | 1 | 57 | 17 | |||
18526 | 250107 | Private 9 | Tree(s) :: 17 | 1688 Pine St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 4ft | 6005911.45005 | 2115583.38163 | 37.7893226981327 | -122.423392144226 | (37.7893226981327, -122.423392144226) | 13 | 9 | 1 | 28858 | 41 | |||
19179 | 61614 | Permitted Site 7 | Tree(s) :: 17 | 1554 Vallejo St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/21/1984 12:00:00 AM | Permit Number 21591 | 6006117.49406792 | 2118322.72943572 | 37.7968558879091 | -122.422874021655 | (37.7968558879091, -122.422874021655) | 13 | 9 | 10 | 28858 | 32 | |||
19721 | 67241 | Permitted Site 7 | Tree(s) :: 17 | 396 Hermann St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/08/1992 12:00:00 AM | Permit Number 30705 | 6003381.2703104 | 2108640.29948082 | 37.7701155985482 | -122.431650362308 | (37.7701155985482, -122.431650362308) | 15 | 9 | 11 | 29492 | 10 | |||
20021 | 88145 | Significant Tree 6 | Tree(s) :: 17 | 1475 Fillmore St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/07/2000 12:00:00 AM | 3x3 | Permit Number 51176 | 6003147.8 | 2113351.1 | 37.7830370509294 | -122.43279450975 | (37.7830370509294, -122.43279450975) | 15 | 9 | 11 | 29490 | 41 | ||
20159 | 33697 | Permitted Site 7 | Tree(s) :: 17 | 105 Germania St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/04/1996 12:00:00 AM | Permit Number 37768 | 6003706.50118853 | 2108806.36692016 | 37.7705900086038 | -122.43053724406 | (37.7705900086038, -122.43053724406) | 15 | 9 | 11 | 29492 | 10 | |||
20207 | 105239 | Significant Tree 6 | Tree(s) :: 17 | 20X Cleary Ct | 6 | Front Yard : Yard | Tree | Private 2 | 01/06/2014 12:00:00 AM | Permit Number 770859 | 6005004.4 | 2113886.9 | 37.7846133478309 | -122.426409592351 | (37.7846133478309, -122.426409592351) | 13 | 9 | 11 | 28858 | 41 | |||
20302 | 55897 | DPW Maintained 1 | Tree(s) :: 17 | 3312 Broderick St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/11/2019 12:00:00 AM | 3 | Permit Number 11954 | 5999849.06827 | 2119940.56013 | 37.8009423337905 | -122.444680511705 | (37.8009423337905, -122.444680511705) | 13 | 9 | 1 | 57 | 17 | ||
20576 | 33686 | Permitted Site 7 | Tree(s) :: 17 | 610 Ivy St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/03/1996 12:00:00 AM | Permit Number 37763 | 6004420.66783798 | 2111040.26799248 | 37.7767641867681 | -122.428226164884 | (37.7767641867681, -122.428226164884) | 7 | 9 | 11 | 28852 | 10 | |||
20630 | 62423 | Permitted Site 7 | Tree(s) :: 17 | 98 Cervantes Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/13/1985 12:00:00 AM | Permit Number 22580 | 6001470.60482532 | 2121060.78917044 | 37.8041105836027 | -122.439149653649 | (37.8041105836027, -122.439149653649) | 13 | 9 | 1 | 57 | 17 | |||
20701 | 57977 | Permitted Site 7 | Tree(s) :: 17 | 2125 Lombard St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/30/2016 12:00:00 AM | 3 | 3x3 | Permit Number 778617 | 6002220.55772622 | 2119423.39733981 | 37.7996573817274 | -122.436437129274 | (37.7996573817274, -122.436437129274) | 13 | 9 | 1 | 57 | 17 | |
21367 | 33681 | DPW Maintained 1 | Tree(s) :: 17 | 417 Ivy St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/03/1996 12:00:00 AM | 11 | Permit Number 37761 | 6005353.591048 | 2111118.12961634 | 37.7770307178387 | -122.425004443456 | (37.7770307178387, -122.425004443456) | 7 | 9 | 11 | 28852 | 10 | ||
21729 | 64691 | Permitted Site 7 | Tree(s) :: 17 | 919 Van Ness Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/13/1988 12:00:00 AM | Permit Number 25633 | 6006503.31942727 | 2113632.2098976 | 37.7839986483416 | -122.421205734476 | (37.7839986483416, -122.421205734476) | 7 | 9 | 11 | 28858 | 41 | |||
21895 | 66281 | Permitted Site 7 | Tree(s) :: 17 | 2875 Vallejo St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/15/1990 12:00:00 AM | Permit Number 29392 | 5999821.86705648 | 2117393.37879266 | 37.7939468990456 | -122.444591461654 | (37.7939468990456, -122.444591461654) | 13 | 9 | 1 | 57 | 27 | |||
22280 | 121321 | Undocumented 4 | Tree(s) :: 17 | 3699X Laguna St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6003556 | 2121083 | 37.8042900105203 | -122.431934584375 | (37.8042900105203, -122.431934584375) | 13 | 9 | 1 | 28858 | 17 | ||||
22340 | 62702 | Permitted Site 7 | Tree(s) :: 17 | 1057 Steiner St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/16/1986 12:00:00 AM | Permit Number 23042 | 6002883.34526395 | 2111864.34010779 | 37.7789397792782 | -122.433603125076 | (37.7789397792782, -122.433603125076) | 15 | 9 | 11 | 29490 | 41 | |||
22401 | 57521 | Permitted Site 7 | Tree(s) :: 17 | 1791 Union St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/04/1976 12:00:00 AM | Permit Number 16378 | 6004435.19836053 | 2118729.32057407 | 37.7978772170328 | -122.428724158647 | (37.7978772170328, -122.428724158647) | 13 | 9 | 1 | 57 | 17 | |||
22539 | 64375 | Permitted Site 7 | Tree(s) :: 17 | 638 Oak St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/21/1988 12:00:00 AM | Permit Number 25214 | 6003934.28024758 | 2110105.31807706 | 37.7741695117897 | -122.429842020183 | (37.7741695117897, -122.429842020183) | 7 | 9 | 11 | 29492 | 10 | |||
22824 | 64238 | Permitted Site 7 | Tree(s) :: 17 | 333 Page St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/11/1988 12:00:00 AM | Permit Number 25031 | 6004969.03880511 | 2109849.15639367 | 37.7735246970263 | -122.426244363272 | (37.7735246970263, -122.426244363272) | 7 | 9 | 11 | 28852 | 10 | |||
23117 | 58301 | Permitted Site 7 | Tree(s) :: 17 | 1090 Eddy St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/02/1978 12:00:00 AM | Permit Number 17320 | 6005213.85129062 | 2113060.26139405 | 37.7823554404248 | -122.425626106655 | (37.7823554404248, -122.425626106655) | 7 | 9 | 11 | 28858 | 41 | |||
23220 | 66886 | Permitted Site 7 | Tree(s) :: 17 | 2249 Webster St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/21/1991 12:00:00 AM | Permit Number 30199 | 6003226.63727619 | 2116373.42012034 | 37.791340046819 | -122.432737735018 | (37.791340046819, -122.432737735018) | 13 | 9 | 1 | 29490 | 27 | |||
23407 | 57700 | Permitted Site 7 | Tree(s) :: 17 | 175 Germania St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/17/1976 12:00:00 AM | Permit Number 16608 | 6003445.21229819 | 2108770.175516 | 37.770475830543 | -122.431438460675 | (37.770475830543, -122.431438460675) | 15 | 9 | 11 | 29492 | 10 | |||
23643 | 107825 | Permitted Site 7 | Tree(s) :: 17 | 2861 Webster St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/29/2014 12:00:00 AM | 3 | Permit Number 774091 | 6002902.37192 | 2118468.54816 | 37.7970743326809 | -122.434009513998 | (37.7970743326809, -122.434009513998) | 13 | 9 | 1 | 57 | 17 | ||
24876 | 61817 | Permitted Site 7 | Tree(s) :: 17 | 395X Waller St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/16/2014 12:00:00 AM | Permit Number 771213 | 6003829.57810709 | 2108926.55853344 | 37.7709269969198 | -122.430120095385 | (37.7709269969198, -122.430120095385) | 7 | 9 | 11 | 29492 | 10 | ||
24953 | 104416 | Permitted Site 7 | Tree(s) :: 17 | 335 Marina Blvd | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/02/2013 12:00:00 AM | Permit Number 770730 | 6001759.6 | 2121793 | 37.806137479917 | -122.438202052281 | (37.806137479917, -122.438202052281) | 13 | 9 | 1 | 57 | 17 | |||
25006 | 59334 | Permitted Site 7 | Tree(s) :: 17 | 110 Gough St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/03/1980 12:00:00 AM | Permit Number 18681 | 6006099.03604482 | 2110096.18467635 | 37.7742667837032 | -122.422353085571 | (37.7742667837032, -122.422353085571) | 7 | 9 | 11 | 28852 | 10 | |||
25114 | 58359 | Permitted Site 7 | Tree(s) :: 17 | 2670 Chestnut St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/20/1978 12:00:00 AM | Permit Number 17386 | 5999142.02257036 | 2119433.60632134 | 37.799510002673 | -122.44709067649 | (37.799510002673, -122.44709067649) | 13 | 9 | 1 | 57 | 17 | |||
25194 | 124757 | DPW Maintained 1 | Tree(s) :: 17 | 2040 Broadway | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/19/2017 12:00:00 AM | 3 | Width 4ft | Permit Number 779873 | 6003680.83051 | 2117635.79331 | 37.7948319494745 | -122.431256385468 | (37.7948319494745, -122.431256385468) | 13 | 9 | 1 | 29490 | 27 | |
25451 | 105226 | Significant Tree 6 | Tree(s) :: 17 | 1150X Golden Gate Ave | 1 | Front Yard : Yard | Tree | Private 2 | 01/02/2014 12:00:00 AM | Permit Number 771276 | 6004329.61165 | 2112216.22051 | 37.7799879097685 | -122.428625001082 | (37.7799879097685, -122.428625001082) | 7 | 9 | 11 | 29490 | 41 | |||
25620 | 57718 | Permitted Site 7 | Tree(s) :: 17 | 100 Webster St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/17/1976 12:00:00 AM | Permit Number 16631 | 6004293.25658032 | 2109092.39566489 | 37.7714085958701 | -122.428528041776 | (37.7714085958701, -122.428528041776) | 7 | 9 | 11 | 28852 | 10 | |||
25742 | 62988 | Permitted Site 7 | Tree(s) :: 17 | 1229 Chestnut St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/03/1986 12:00:00 AM | Permit Number 23389 | 6005959.26624719 | 2120329.44553981 | 37.8023568910519 | -122.423564270122 | (37.8023568910519, -122.423564270122) | 5 | 9 | 1 | 28858 | 32 | |||
25747 | 61981 | Permitted Site 7 | Tree(s) :: 17 | 3140 Octavia St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/05/1985 12:00:00 AM | Permit Number 22048 | 6004245.88694506 | 2119904.47592296 | 37.8010931746855 | -122.429463078489 | (37.8010931746855, -122.429463078489) | 13 | 9 | 1 | 57 | 17 | |||
26110 | 35625 | Permitted Site 7 | Tree(s) :: 17 | 701 Hayes St | 15 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/30/1998 12:00:00 AM | Permit Number 38975 | 6004496.45349332 | 2110824.80795168 | 37.7761768741411 | -122.427948642674 | (37.7761768741411, -122.427948642674) | 7 | 9 | 11 | 28852 | 10 | |||
26280 | 107595 | Undocumented 4 | Tree(s) :: 17 | 1846 POST ST | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | 12 | 3x3 | 6003338.5 | 2114199.3 | 37.7853768084061 | -122.432195360195 | (37.7853768084061, -122.432195360195) | 13 | 9 | 11 | 29490 | 13 | |||
26293 | 107520 | Undocumented 4 | Tree(s) :: 17 | 2 CHURCH ST | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6004041.5 | 2108639.2 | 37.7701499806884 | -122.429366557007 | (37.7701499806884, -122.429366557007) | 7 | 9 | 5 | 29492 | 10 | ||||||
26526 | 65954 | Permitted Site 7 | Tree(s) :: 17 | 149 Fillmore St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/05/2016 12:00:00 AM | 3 | Permit Number 28975 | 6003781.06757049 | 2108897.79251854 | 37.7708452648467 | -122.430285841944 | (37.7708452648467, -122.430285841944) | 15 | 9 | 11 | 29492 | 10 | ||
26529 | 239014 | Permitted Site 7 | Tree(s) :: 17 | 119 Church St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/20/2018 12:00:00 AM | 3 | 3x3 | Permit Number 781143 | 6004145.78363 | 2108186.6069 | 37.7689131733214 | -122.428973567998 | (37.7689131733214, -122.428973567998) | 7 | 9 | 5 | 28862 | 3 | |
26600 | 62723 | Permitted Site 7 | Tree(s) :: 17 | 1737 Sutter St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/30/1986 12:00:00 AM | Permit Number 23069 | 6004288.48253688 | 2114611.9926594 | 37.786563775195 | -122.428938139314 | (37.786563775195, -122.428938139314) | 13 | 9 | 11 | 29490 | 13 | |||
26827 | 59293 | Permitted Site 7 | Tree(s) :: 17 | 2238 Vallejo St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/20/1980 12:00:00 AM | Permit Number 18630 | 6002854.57798819 | 2117868.1515112 | 37.7954230864895 | -122.434131950138 | (37.7954230864895, -122.434131950138) | 13 | 9 | 1 | 57 | 17 | |||
26948 | 51932 | Permitted Site 7 | Tree(s) :: 17 | 2430 Pacific Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/22/2005 12:00:00 AM | Permit Number 48160 | 6002509.80131586 | 2117120.57540062 | 37.7933508621986 | -122.435271434099 | (37.7933508621986, -122.435271434099) | 13 | 9 | 1 | 29490 | 27 | |||
27307 | 40187 | Permitted Site 7 | Tree(s) :: 17 | 2250 Union St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/30/1999 12:00:00 AM | Permit Number 41373 | 6002227.88904638 | 2118474.60160592 | 37.7970526532072 | -122.436343819296 | (37.7970526532072, -122.436343819296) | 13 | 9 | 1 | 57 | 17 | |||
27333 | 92772 | Permitted Site 7 | Tree(s) :: 17 | 1299 Bush St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/14/2009 12:00:00 AM | 3x3 | Permit Number 52992 | 6007284 | 2115381 | 37.7888443784502 | -122.418628913256 | (37.7888443784502, -122.418628913256) | 13 | 9 | 10 | 28858 | 21 | ||
27353 | 51102 | Permitted Site 7 | Tree(s) :: 17 | 2595 Clay St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/11/2006 12:00:00 AM | Permit Number 48820 | 6002357.70130801 | 2116065.62310838 | 37.7904455964692 | -122.435722198209 | (37.7904455964692, -122.435722198209) | 13 | 9 | 1 | 29490 | 27 | |||
27763 | 105240 | Significant Tree 6 | Tree(s) :: 17 | 20X Cleary Ct | 10 | Front Yard : Yard | Tree | Private 2 | 01/06/2014 12:00:00 AM | Permit Number 770859 | 6005004.4 | 2113886.9 | 37.7846133478309 | -122.426409592351 | (37.7846133478309, -122.426409592351) | 13 | 9 | 11 | 28858 | 41 | |||
27828 | 45391 | Permitted Site 7 | Tree(s) :: 17 | 2231 Chestnut St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 44203 | 6001199.66794622 | 2119667.53839019 | 37.8002696664222 | -122.439987287022 | (37.8002696664222, -122.439987287022) | 13 | 9 | 1 | 57 | 17 | ||||
28023 | 45624 | Permitted Site 7 | Tree(s) :: 17 | 1100 Fillmore St | 24 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 44335 | 6003389.50485138 | 2112095.5826587 | 37.7796034198271 | -122.431868633724 | (37.7796034198271, -122.431868633724) | 15 | 9 | 11 | 29490 | 41 | ||||
28147 | 47811 | Permitted Site 7 | Tree(s) :: 17 | 2850 Steiner St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/08/2016 12:00:00 AM | 3 | Permit Number 778456 | 6002093.59395592 | 2117912.97567521 | 37.7955029432508 | -122.436768288123 | (37.7955029432508, -122.436768288123) | 13 | 9 | 1 | 57 | 17 | ||
28213 | 64353 | Permitted Site 7 | Tree(s) :: 17 | 265 Hickory St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/21/1988 12:00:00 AM | Permit Number 25189 | 6005707.61893626 | 2110473.86835785 | 37.7752817243886 | -122.423733929911 | (37.7752817243886, -122.423733929911) | 7 | 9 | 11 | 28852 | 10 | |||
28403 | 57809 | Permitted Site 7 | Tree(s) :: 17 | 2400 Lombard St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/09/1977 12:00:00 AM | Permit Number 16745 | 6000902.92825837 | 2119318.48864399 | 37.7992943715099 | -122.440989065574 | (37.7992943715099, -122.440989065574) | 13 | 9 | 1 | 57 | 17 | |||
28629 | 35636 | Permitted Site 7 | Tree(s) :: 17 | 701 Hayes St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/30/1998 12:00:00 AM | Permit Number 38975 | 6004496.45349332 | 2110824.80795168 | 37.7761768741411 | -122.427948642674 | (37.7761768741411, -122.427948642674) | 7 | 9 | 11 | 28852 | 10 | |||
28888 | 62424 | Permitted Site 7 | Tree(s) :: 17 | 2465 Chestnut St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/13/1985 12:00:00 AM | Permit Number 22581 | 6000063.62646554 | 2119509.36822019 | 37.7997706371417 | -122.443907053939 | (37.7997706371417, -122.443907053939) | 13 | 9 | 1 | 57 | 17 | |||
29114 | 103653 | Significant Tree 6 | Tree(s) :: 17 | 307X Octavia St | 2 | Front Yard : Yard | Tree | DPW for City Agency 14 | 06/07/2013 12:00:00 AM | Permit Number 770306 | 6005538.74006 | 2110314.20336 | 37.7748337884081 | -122.424306762839 | (37.7748337884081, -122.424306762839) | 7 | 9 | 11 | 28852 | 10 | |||
29339 | 38410 | Permitted Site 7 | Tree(s) :: 17 | 1000 Van Ness Ave | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/30/1998 12:00:00 AM | Permit Number 40450 | 6006538.75328643 | 2113902.05144478 | 37.7847415646224 | -122.421102312622 | (37.7847415646224, -122.421102312622) | 7 | 9 | 9 | 28858 | 36 | |||
29441 | 57704 | Permitted Site 7 | Tree(s) :: 17 | 154 Hermann St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/17/1976 12:00:00 AM | Permit Number 16613 | 6004527.59214262 | 2108799.07776083 | 37.7706164744198 | -122.427696561309 | (37.7706164744198, -122.427696561309) | 7 | 9 | 11 | 28852 | 10 | |||
29523 | 61996 | Permitted Site 7 | Tree(s) :: 17 | 3327 Octavia St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/03/1985 12:00:00 AM | Permit Number 53663 | 6004104.65949489 | 2120541.05254542 | 37.8028330520495 | -122.429997221543 | (37.8028330520495, -122.429997221543) | 13 | 9 | 1 | 57 | 17 | |||
29577 | 101809 | Undocumented 4 | Tree(s) :: 17 | 370 Hermann St | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | 3x3 | 6003497 | 2108649 | 37.7701460471638 | -122.43125067595 | (37.7701460471638, -122.43125067595) | 15 | 9 | 11 | 29492 | 10 |
Advanced export
JSON shape: default, array, newline-delimited, object
CREATE TABLE "trees" ( [rowid] INTEGER PRIMARY KEY, [TreeID] TEXT, [qLegalStatus_id] INTEGER REFERENCES [qLegalStatus]([id]), [qSpecies_id] INTEGER, [qAddress] TEXT, [SiteOrder] TEXT, [qSiteInfo] TEXT, [PlantType] TEXT, [qCaretaker_id] INTEGER REFERENCES [qCaretaker]([id]), [qCareAssistant] TEXT, [PlantDate] TEXT, [DBH] TEXT, [PlotSize] TEXT, [PermitNotes] TEXT, [XCoord] TEXT, [YCoord] TEXT, [Latitude] TEXT, [Longitude] TEXT, [Location] TEXT, [Fire Prevention Districts] TEXT, [Police Districts] TEXT, [Supervisor Districts] TEXT, [Zip Codes] TEXT, [Neighborhoods (old)] TEXT, FOREIGN KEY(qSpecies_id) REFERENCES qSpecies(id) );