trees
6,714 rows where qSpecies_id = 7 sorted by SiteOrder 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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
12977 | 235705 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 50 Scott St | 9 | : | Tree | Private 2 | 6 | Width 3ft | 6002413.688 | 2108646.89138 | 37.7700788062318 | -122.434997685721 | (37.7700788062318, -122.434997685721) | 15 | 5 | 5 | 29492 | 9 | |||
38021 | 236563 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 1050 South Van Ness Ave | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6007584.63883 | 2103498.36122 | 37.756234389913 | -122.416746587786 | (37.756234389913, -122.416746587786) | 2 | 4 | 7 | 28859 | 19 | |||
40148 | 237562 | Undocumented 4 | Prunus cerasifera :: Cherry Plum 7 | 268 Dorland St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6003657.48862 | 2105720.4016 | 37.7621139182326 | -122.430486555019 | (37.7621139182326, -122.430486555019) | 8 | 4 | 5 | 28862 | 3 | |||
53654 | 142540 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 2100 POWELL ST | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 0ft | 6009421.7884 | 2121061.7254 | 37.8045623807522 | -122.411633968656 | (37.8045623807522, -122.411633968656) | 3 | 1 | 10 | 308 | 23 | |||
61562 | 246789 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 175 Brewster St | 9 | Sidewalk: Curb side : Yard | Tree | Private 2 | 4 | 6010127.86298 | 2098745.31101 | 37.7433262775831 | -122.407616096612 | (37.7433262775831, -122.407616096612) | 2 | 7 | 7 | 28859 | 2 | ||||
63314 | 214207 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 400x Marietta Dr | 9 | Median : Cutout | Tree | DPW 1 | 8 | Width 3ft | 5999489.79352 | 2097033.53781 | 37.7380249270166 | -122.444276686425 | (37.7380249270166, -122.444276686425) | 9 | 7 | 4 | 59 | 40 | |||
64171 | 249873 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 230 Greenwich St | 9 | Back Yard : Yard | Tree | Private 2 | 26 | Width 0ft | 6011670.78297 | 2120474.23594 | 37.8030751776447 | -122.403809705266 | (37.8030751776447, -122.403809705266) | 3 | 1 | 10 | 28860 | 6 | |||
65392 | 196171 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 150 Loomis St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/27/2017 12:00:00 AM | 3 | Width 4ft | 6010696.43689 | 2097532.57901 | 37.7400281875625 | -122.405564708871 | (37.7400281875625, -122.405564708871) | 10 | 3 | 8 | 58 | 1 | ||
80571 | 247009 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 401 Valley St | 9 | Side Yard : Yard | Tree | Private 2 | 13 | Width 8ft | 6003278.48209 | 2099193.13161 | 37.744170100677 | -122.431331435716 | (37.744170100677, -122.431331435716) | 2 | 7 | 5 | 63 | 22 | |||
89075 | 135831 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 900 Green St | 9 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | Width 5ft | 6008642.51144 | 2119028.50949 | 37.7989359337052 | -122.414186800682 | (37.7989359337052, -122.414186800682) | 5 | 1 | 10 | 308 | 32 | |||
91181 | 235729 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 2727 Mariposa St | 9 | : | Tree | Private 2 | 7 | Width 3ft | 6009350.44407 | 2105901.57906 | 37.762932240148 | -122.410809524455 | (37.762932240148, -122.410809524455) | 8 | 4 | 7 | 28859 | 19 | |||
101353 | 237853 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 204 Addison St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 2ft | 6002645.38192 | 2097459.0193 | 37.7393727310656 | -122.433396661342 | (37.7393727310656, -122.433396661342) | 2 | 7 | 5 | 63 | 7 | |||
108570 | 201982 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 1651 Carroll Ave | 9 | : | Tree | Private 2 | 2 | Width 3ft | 6013638.14457 | 2092296.94833 | 37.7258162731896 | -122.395026801165 | (37.7258162731896, -122.395026801165) | 10 | 3 | 8 | 58 | 1 | |||
112231 | 201254 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 75 Orsi Cir | 9 | Sidewalk: Curb side : Yard | Tree | Private 2 | 2 | Width 2ft | 6012906.67074 | 2093256.57941 | 37.7284105214187 | -122.397622746406 | (37.7284105214187, -122.397622746406) | 10 | 3 | 8 | 58 | 1 | |||
118794 | 124587 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 3991 Washington St | 9 | Sidewalk: Curb side : Yard | Tree | Private 2 | 8 | Width 6ft | 5995618.65925 | 2115459.66963 | 37.7883967207528 | -122.458994801868 | (37.7883967207528, -122.458994801868) | 11 | 6 | 1 | 54 | 31 | |||
122181 | 196090 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 888 Tennessee St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6015457.19385 | 2104954.19153 | 37.7606714353517 | -122.389622035738 | (37.7606714353517, -122.389622035738) | 10 | 3 | 8 | 28856 | 29 | |||
125056 | 249810 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 258 Chestnut St | 9 | Back Yard : Yard | Tree | Private 2 | 5 | Width 0ft | 6010696.08755 | 2121019.21593 | 37.8045170588744 | -122.407221117962 | (37.8045170588744, -122.407221117962) | 3 | 1 | 10 | 308 | 23 | |||
125431 | 48715 | Permitted Site 7 | Prunus cerasifera :: Cherry Plum 7 | 51 Karen Ct | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/19/2002 12:00:00 AM | Permit Number 45979 | 6010303.31031399 | 2091494.58114447 | 37.7234271327762 | -122.406498623752 | (37.7234271327762, -122.406498623752) | 10 | 3 | 7 | 309 | 28 | |||
125804 | 196206 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 10 Freelon St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 2ft | 6013551.06217 | 2111704.71777 | 37.7791009956579 | -122.39668777432 | (37.7791009956579, -122.39668777432) | 6 | 2 | 9 | 28856 | 34 | |||
128040 | 31273 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 2555 17th Ave | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/04/1995 12:00:00 AM | 3 | Permit Number 34928 | 5991084.11448 | 2097836.49496 | 37.7397464910963 | -122.473397543673 | (37.7397464910963, -122.473397543673) | 1 | 8 | 4 | 29491 | 40 | |
128965 | 135853 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 12 Filbert St | 9 | Sidewalk: Curb side : Pot | Tree | Private 2 | 26 | 6012286.0131 | 2120198.43277 | 37.8023522396158 | -122.401661277048 | (37.8023522396158, -122.401661277048) | 3 | 1 | 10 | 28860 | 6 | ||||
133713 | 24817 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 400X Alemany Blvd | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/17/2015 12:00:00 AM | 4 | 3x3 | 6007985.05958 | 2094993.50903 | 37.7329044714678 | -122.414759918861 | (37.7329044714678, -122.414759918861) | 2 | 7 | 7 | 28859 | 2 | ||
137850 | 236685 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 625 Douglass St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6001228.28825 | 2102781.78076 | 37.7539072709268 | -122.438677634189 | (37.7539072709268, -122.438677634189) | 2 | 4 | 5 | 28862 | 22 | |||
138155 | 201943 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 1650 Carroll Ave | 9 | : | Tree | Private 2 | 2 | Width 3ft | 6013641.01292 | 2092357.44861 | 37.7259825542392 | -122.39502112104 | (37.7259825542392, -122.39502112104) | 10 | 3 | 8 | 58 | 1 | |||
142496 | 235805 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 101 Clinton Park | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 2ft | 6005967.26033 | 2108264.27436 | 37.7692293632676 | -122.422678713849 | (37.7692293632676, -122.422678713849) | 8 | 4 | 5 | 28853 | 19 | |||
145172 | 40521 | Permitted Site 7 | Prunus cerasifera :: Cherry Plum 7 | 141 Junipero Serra Blvd | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/23/1999 12:00:00 AM | Permit Number 41578 | 5991646.63736433 | 2095256.52671108 | 37.7326951089402 | -122.471264671772 | (37.7326951089402, -122.471264671772) | 9 | 8 | 4 | 59 | 40 | ||
145370 | 235838 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 1960 Bryant St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6009505.89629 | 2105563.85798 | 37.7620136501362 | -122.410248021024 | (37.7620136501362, -122.410248021024) | 8 | 4 | 7 | 28859 | 19 | |||
151325 | 39040 | Permitted Site 7 | Prunus cerasifera :: Cherry Plum 7 | 1900 Bryant St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/18/1998 12:00:00 AM | Permit Number 40772 | 6009495.908 | 2105657.588 | 37.7622704515257 | -122.410289184909 | (37.7622704515257, -122.410289184909) | 8 | 4 | 7 | 28859 | 19 | ||
154983 | 109598 | Permitted Site 7 | Prunus cerasifera :: Cherry Plum 7 | 1050 South Van Ness Ave | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6007567.1 | 2103584.6 | 37.7564701953683 | -122.416813352731 | (37.7564701953683, -122.416813352731) | 2 | 4 | 7 | 28859 | 19 | |||||
157756 | 214284 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 317 Staples Ave | 9 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | Width 10ft | 5998054.67 | 2093771.84046 | 37.7289871001564 | -122.449003702981 | (37.7289871001564, -122.449003702981) | 9 | 7 | 4 | 28861 | 40 | |||
160119 | 218008 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 2555 18th Ave | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 5990816.87796 | 2097918.21853 | 37.7399554045269 | -122.474327486723 | (37.7399554045269, -122.474327486723) | 1 | 8 | 4 | 29491 | 40 | |||
161408 | 135730 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 3170 Sacramento St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 5999561.88174 | 2115399.47464 | 37.788457324591 | -122.445347601815 | (37.788457324591, -122.445347601815) | 13 | 6 | 1 | 29490 | 27 | |||
164705 | 236579 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 2928 19th St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 4ft | 6009105.36991 | 2105002.4908 | 37.760449804642 | -122.411593627169 | (37.760449804642, -122.411593627169) | 2 | 4 | 7 | 28859 | 19 | |||
169059 | 235655 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 101 Clinton Park | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 2ft | 6005977.35609 | 2108271.55166 | 37.7692499145823 | -122.422644310309 | (37.7692499145823, -122.422644310309) | 8 | 4 | 5 | 28853 | 19 | |||
179127 | 41665 | Permitted Site 7 | Prunus cerasifera :: Cherry Plum 7 | 500 Corbett Ave | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/19/2000 12:00:00 AM | Permit Number 42131 | 5999528.76445246 | 2104225.15584588 | 37.7577735947767 | -122.444658701666 | (37.7577735947767, -122.444658701666) | 2 | 5 | 5 | 28862 | 3 | ||
179652 | 38778 | Permitted Site 7 | Prunus cerasifera :: Cherry Plum 7 | 534 04th St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/20/1998 12:00:00 AM | Permit Number 40639 | 6013303.96708897 | 2111684.86517271 | 37.7790327294989 | -122.397541189965 | (37.7790327294989, -122.397541189965) | 6 | 2 | 9 | 28856 | 34 | ||
180695 | 213024 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 20 Belmont Ave | 9 | Sidewalk: Curb side : Yard | Tree | Private 2 | 18 | 5996733.15757 | 2106189.67252 | 37.7630077346534 | -122.454468924419 | (37.7630077346534, -122.454468924419) | 15 | 5 | 11 | 29492 | 12 | ||||
184420 | 213112 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 102 Omar Way | 9 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 3ft | 5998102.48269 | 2097542.14739 | 37.7393421990827 | -122.449109915589 | (37.7393421990827, -122.449109915589) | 9 | 7 | 4 | 59 | 40 | |||
187513 | 196089 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 899 Tennessee St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6015514.72199 | 2105046.29907 | 37.7609275325861 | -122.389429502571 | (37.7609275325861, -122.389429502571) | 10 | 3 | 8 | 28856 | 29 | |||
10164 | 212975 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 1350 07th Ave | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 2ft | 5993969.17632 | 2106486.34131 | 37.7636634033545 | -122.46405005237 | (37.7636634033545, -122.46405005237) | 1 | 5 | 11 | 56 | 12 | |||
17193 | 178814 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 101 Dartmouth St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 2ft | 6008515.4618 | 2093543.1863 | 37.7289519843287 | -122.412823674893 | (37.7289519843287, -122.412823674893) | 9 | 3 | 7 | 309 | 28 | |||
19250 | 79912 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 888 Tennessee St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 3 | 6015455.9807 | 2104968.54211 | 37.7607107716933 | -122.389627233809 | (37.7607107716933, -122.389627233809) | 10 | 3 | 8 | 28856 | 29 | |||
21806 | 235804 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 101 Clinton Park | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 2ft | 6005947.41662 | 2108263.38345 | 37.7692257974626 | -122.422747288973 | (37.7692257974626, -122.422747288973) | 8 | 4 | 5 | 28853 | 19 | |||
26203 | 31272 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 2555 17th Ave | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/04/1995 12:00:00 AM | 3 | Permit Number 34928 | 5991082.4572 | 2097854.85146 | 37.7397967973808 | -122.473404612326 | (37.7397967973808, -122.473404612326) | 1 | 8 | 4 | 29491 | 40 | |
26793 | 237561 | Undocumented 4 | Prunus cerasifera :: Cherry Plum 7 | 268 Dorland St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6003676.04768 | 2105721.46641 | 37.7621178932611 | -122.43042244235 | (37.7621178932611, -122.43042244235) | 8 | 4 | 5 | 28862 | 3 | |||
34106 | 31711 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 1250X Shrader St | 8 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 06/19/1995 12:00:00 AM | 6 | 3x3 | Permit Number 35211 | 5997882.313818 | 2106467.94501531 | 37.7638376395234 | -122.450514467435 | (37.7638376395234, -122.450514467435) | 15 | 5 | 11 | 29492 | 9 |
36212 | 236562 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 1050 South Van Ness Ave | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6007584.89714 | 2103510.97173 | 37.7562690300153 | -122.416746587807 | (37.7562690300153, -122.416746587807) | 2 | 4 | 7 | 28859 | 19 | |||
52923 | 249809 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 258 Chestnut St | 8 | Back Yard : Yard | Tree | Private 2 | 5 | Width 0ft | 6010708.45628 | 2121025.23541 | 37.8045342790877 | -122.407178739215 | (37.8045342790877, -122.407178739215) | 3 | 1 | 10 | 308 | 23 | |||
57035 | 236457 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 1210 Shrader St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 5997756.09829 | 2106400.46801 | 37.7636451399269 | -122.450946140561 | (37.7636451399269, -122.450946140561) | 15 | 5 | 11 | 29492 | 9 | |||
62884 | 39044 | Permitted Site 7 | Prunus cerasifera :: Cherry Plum 7 | 1900 Bryant St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/18/1998 12:00:00 AM | Permit Number 40772 | 6009495.908 | 2105668.873 | 37.7623014375638 | -122.410289981728 | (37.7623014375638, -122.410289981728) | 8 | 4 | 7 | 28859 | 19 | ||
63151 | 235654 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 101 Clinton Park | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 2ft | 6005956.27341 | 2108269.65644 | 37.7692435212993 | -122.422717099611 | (37.7692435212993, -122.422717099611) | 8 | 4 | 5 | 28853 | 19 | |||
66692 | 135729 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 3170 Sacramento St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 5999572.21649 | 2115398.89164 | 37.7884563137663 | -122.445311803397 | (37.7884563137663, -122.445311803397) | 13 | 6 | 1 | 29490 | 27 | |||
67858 | 235837 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 1960 Bryant St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6009505.12151 | 2105579.26147 | 37.7620559011817 | -122.410251788293 | (37.7620559011817, -122.410251788293) | 8 | 4 | 7 | 28859 | 19 | |||
72891 | 196079 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 1301 Minnesota St | 8 | Front Yard : Yard | Tree | Private 2 | 5 | 6015395.01764 | 2102273.41777 | 37.75330715422 | -122.389649840082 | (37.75330715422, -122.389649840082) | 10 | 3 | 8 | 28856 | 29 | ||||
74014 | 196088 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 899 Tennessee St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6015515.50483 | 2105016.50834 | 37.7608457770442 | -122.389424714573 | (37.7608457770442, -122.389424714573) | 10 | 3 | 8 | 28856 | 29 | |||
79330 | 202168 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 10 Kalmanovitz St | 8 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | Width 1ft | 6013157.76295 | 2093232.82928 | 37.7283592870497 | -122.396753038148 | (37.7283592870497, -122.396753038148) | 10 | 3 | 8 | 58 | 1 | |||
79716 | 237837 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 173 Addison St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6002613.10879 | 2097430.23104 | 37.7392918541361 | -122.433506190679 | (37.7392918541361, -122.433506190679) | 2 | 7 | 5 | 63 | 7 | |||
81173 | 256733 | Undocumented 4 | Prunus cerasifera :: Cherry Plum 7 | 55x Stillman St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6014056 | 2112804 | 37.7821474643612 | -122.395017991678 | (37.7821474643612, -122.395017991678) | 6 | 2 | 9 | 28856 | 6 | ||||
84288 | 109597 | Permitted Site 7 | Prunus cerasifera :: Cherry Plum 7 | 1050 South Van Ness Ave | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6007567.1 | 2103584.6 | 37.7564701953683 | -122.416813352731 | (37.7564701953683, -122.416813352731) | 2 | 4 | 7 | 28859 | 19 | |||||
88320 | 48716 | Permitted Site 7 | Prunus cerasifera :: Cherry Plum 7 | 51 Karen Ct | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/19/2002 12:00:00 AM | Permit Number 45979 | 6010303.31031399 | 2091494.58114447 | 37.7234271327762 | -122.406498623752 | (37.7234271327762, -122.406498623752) | 10 | 3 | 7 | 309 | 28 | |||
89294 | 236578 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 2928 19th St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 4ft | 6009116.59014 | 2105002.26158 | 37.7604498046336 | -122.411554805226 | (37.7604498046336, -122.411554805226) | 2 | 4 | 7 | 28859 | 19 | |||
94334 | 218007 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 2555 18th Ave | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 5990818.0403 | 2097903.53362 | 37.7399151508696 | -122.474322396563 | (37.7399151508696, -122.474322396563) | 1 | 8 | 4 | 29491 | 40 | |||
97810 | 39035 | Permitted Site 7 | Prunus cerasifera :: Cherry Plum 7 | 2701X Mariposa St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/18/1998 12:00:00 AM | 3x3 | Permit Number 40772 | 6009429.068 | 2105914.533 | 37.7629722168899 | -122.410538505147 | (37.7629722168899, -122.410538505147) | 8 | 4 | 7 | 28859 | 19 | |
105555 | 31453 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 625 Douglass St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/01/1995 12:00:00 AM | 4 | Permit Number 35026 | 6001228.2731 | 2102757.74093 | 37.7538412624867 | -122.438675964135 | (37.7538412624867, -122.438675964135) | 2 | 4 | 5 | 28862 | 22 | |
108634 | 50597 | Permitted Site 7 | Prunus cerasifera :: Cherry Plum 7 | 1700 Buchanan St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/26/2003 12:00:00 AM | Permit Number 47204 | 6004061.24207522 | 2114267.02341516 | 37.7856037113433 | -122.429699722138 | (37.7856037113433, -122.429699722138) | 13 | 9 | 11 | 29490 | 13 | |||
114173 | 201983 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 1651 Carroll Ave | 8 | : | Tree | Private 2 | 2 | Width 3ft | 6013616.63963 | 2092305.22026 | 37.7258377903696 | -122.395101721872 | (37.7258377903696, -122.395101721872) | 10 | 3 | 8 | 58 | 1 | |||
116604 | 41061 | Permitted Site 7 | Prunus cerasifera :: Cherry Plum 7 | 220 10th St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/26/1999 12:00:00 AM | Permit Number 41830 | 6008482.96704788 | 2109848.1149541 | 37.7737198300469 | -122.41408905371 | (37.7737198300469, -122.41408905371) | 8 | 2 | 9 | 28853 | 34 | ||
119993 | 213023 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 20 Belmont Ave | 8 | Sidewalk: Curb side : Yard | Tree | Private 2 | 13 | 5996741.30489 | 2106184.57068 | 37.7629941935602 | -122.454440377224 | (37.7629941935602, -122.454440377224) | 15 | 5 | 11 | 29492 | 12 | ||||
123723 | 235928 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 899 Hampshire St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 6010205.26353 | 2104100.74939 | 37.7580354612818 | -122.407726000963 | (37.7580354612818, -122.407726000963) | 10 | 4 | 7 | 28859 | 19 | |||
135853 | 34185 | Permitted Site 7 | Prunus cerasifera :: Cherry Plum 7 | 2701 Lake St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/09/1997 12:00:00 AM | Permit Number 38010 | 5987120.3446635 | 2114449.05125045 | 37.7851296693951 | -122.488322923297 | (37.7851296693951, -122.488322923297) | 11 | 6 | 1 | 55 | 33 | ||
135976 | 196170 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 150 Loomis St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 4ft | 6010699.32224 | 2097570.42606 | 37.7401322687757 | -122.40555739738 | (37.7401322687757, -122.40555739738) | 10 | 3 | 8 | 58 | 1 | |||
139083 | 95608 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 345 08th Ave | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | 3x3 | 5993382.42961 | 2113039.50659 | 37.7816228126445 | -122.466555755447 | (37.7816228126445, -122.466555755447) | 11 | 6 | 2 | 54 | 11 | |||
149821 | 212582 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 698 Hearst Ave | 8 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | Width 5ft | 5996839.75246 | 2094438.55281 | 37.7307481750864 | -122.453251853909 | (37.7307481750864, -122.453251853909) | 9 | 7 | 4 | 59 | 40 | |||
152059 | 196205 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 10 Freelon St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 2ft | 6013581.78975 | 2111736.47585 | 37.7791899062397 | -122.396583701171 | (37.7791899062397, -122.396583701171) | 6 | 2 | 9 | 28856 | 34 | |||
154197 | 237790 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 10 Loma Vista Ter | 8 | Sidewalk: Curb side : Yard | Tree | Private 2 | 5 | Width 3ft | 5999973.59103 | 2106866.6906 | 37.7650519691887 | -122.443310039322 | (37.7650519691887, -122.443310039322) | 15 | 5 | 5 | 29492 | 3 | |||
157643 | 237689 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 435 Church St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 6004236.6224 | 2106501.13374 | 37.7642904115845 | -122.428539206238 | (37.7642904115845, -122.428539206238) | 8 | 4 | 5 | 28862 | 3 | |||
160875 | 246788 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 175 Brewster St | 8 | Sidewalk: Curb side : Yard | Tree | Private 2 | 4 | 6010114.00808 | 2098736.68699 | 37.743301822332 | -122.407663395564 | (37.743301822332, -122.407663395564) | 2 | 7 | 7 | 28859 | 2 | ||||
161513 | 38785 | Permitted Site 7 | Prunus cerasifera :: Cherry Plum 7 | 534 04th St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/20/1998 12:00:00 AM | Permit Number 40639 | 6013303.96708897 | 2111684.86517271 | 37.7790327294989 | -122.397541189965 | (37.7790327294989, -122.397541189965) | 6 | 2 | 9 | 28856 | 34 | ||
168816 | 213113 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 102 Omar Way | 8 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | Width 3ft | 5998111.37586 | 2097542.73119 | 37.7393443106943 | -122.449079209133 | (37.7393443106943, -122.449079209133) | 9 | 7 | 4 | 59 | 40 | |||
170915 | 201942 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 1650 Carroll Ave | 8 | : | Tree | Private 2 | 2 | Width 3ft | 6013661.36989 | 2092347.25444 | 37.7259556950922 | -122.394950034125 | (37.7259556950922, -122.394950034125) | 10 | 3 | 8 | 58 | 1 | |||
173350 | 81702 | Permitted Site 7 | Prunus cerasifera :: Cherry Plum 7 | 728 20th St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/21/2007 12:00:00 AM | 3x3 | Permit Number 50044 | 6015682.09798099 | 2104903.80699852 | 37.7605455583769 | -122.388840669387 | (37.7605455583769, -122.388840669387) | 10 | 3 | 8 | 28856 | 29 | ||
185398 | 135769 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 2574 Broadway | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 4ft | 6001286.49237 | 2117300.22497 | 37.7937745877738 | -122.439517044291 | (37.7937745877738, -122.439517044291) | 13 | 9 | 1 | 57 | 27 | |||
188107 | 41666 | Permitted Site 7 | Prunus cerasifera :: Cherry Plum 7 | 500 Corbett Ave | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/19/2000 12:00:00 AM | Permit Number 42131 | 5999528.76445246 | 2104225.15584588 | 37.7577735947767 | -122.444658701666 | (37.7577735947767, -122.444658701666) | 2 | 5 | 5 | 28862 | 3 | ||
190558 | 237852 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 204 Addison St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 2ft | 6002664.59723 | 2097398.56275 | 37.7392078214825 | -122.433325904463 | (37.7392078214825, -122.433325904463) | 2 | 7 | 5 | 63 | 7 | |||
191936 | 100987 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 2190 Powell St | 8 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW | 3x3 | 6009638.6 | 2121046.2 | 37.8045319114054 | -122.41088257169 | (37.8045319114054, -122.41088257169) | 3 | 1 | 10 | 308 | 23 | |||
192586 | 135830 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 900 Green St | 8 | Front Yard : Yard | Tree | Private 2 | 2 | 6008645.65329 | 2119014.61059 | 37.7988979472514 | -122.414174944941 | (37.7988979472514, -122.414174944941) | 5 | 1 | 10 | 308 | 32 | ||||
189 | 178694 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 184 Mount Vernon Ave | 7 | Side Yard : Yard | Tree | Private 2 | 9 | 5998957.82756 | 2089383.479 | 37.7169892861082 | -122.445565994978 | (37.7169892861082, -122.445565994978) | 9 | 7 | 6 | 28861 | 25 | ||||
816 | 248050 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 38 Rutledge St | 7 | Side Yard : Yard | Tree | Private 2 | 5 | 6010496.13368 | 2099436.61391 | 37.7452450531093 | -122.406391405264 | (37.7452450531093, -122.406391405264) | 2 | 7 | 7 | 28859 | 2 | ||||
1074 | 80599 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 888 Tennessee St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 3 | 6015456.30873 | 2104984.78613 | 37.7607553924711 | -122.389627233831 | (37.7607553924711, -122.389627233831) | 10 | 3 | 8 | 28856 | 29 | |||
4349 | 212581 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 698 Hearst Ave | 7 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 5ft | 5996847.55389 | 2094438.38996 | 37.7307481750846 | -122.453224871536 | (37.7307481750846, -122.453224871536) | 9 | 7 | 4 | 59 | 40 | |||
5448 | 140339 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 1300x WEBSTER ST | 7 | Median : Cutout | Tree | DPW 1 | 6 | Width 0ft | 6003689.95 | 2113371.7397 | 37.7831244557567 | -122.430920367043 | (37.7831244557567, -122.430920367043) | 15 | 9 | 11 | 29490 | 41 | |||
12181 | 212499 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 65 Sotelo Ave | 7 | Sidewalk: Curb side : Yard | Tree | Private 2 | 2 | Width 4ft | 5993890.56554 | 2101313.40966 | 37.7494553362962 | -122.463946421708 | (37.7494553362962, -122.463946421708) | 1 | 8 | 4 | 29491 | 40 | |||
13237 | 236458 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 1210 Shrader St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 5997758.4442 | 2106385.26645 | 37.7636035345904 | -122.450936930613 | (37.7636035345904, -122.450936930613) | 15 | 5 | 11 | 29492 | 9 | |||
17315 | 236909 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 1180 Stanyan St | 7 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 12 | Width 3ft | 5997408.17858 | 2106084.98197 | 37.7627589713618 | -122.452126715679 | (37.7627589713618, -122.452126715679) | 15 | 5 | 11 | 29492 | 9 | |||
19681 | 237560 | Undocumented 4 | Prunus cerasifera :: Cherry Plum 7 | 268 Dorland St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6003694.93304 | 2105720.71488 | 37.7621168995038 | -122.430357071532 | (37.7621168995038, -122.430357071532) | 8 | 4 | 5 | 28862 | 3 | |||
20174 | 49363 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 1875@ EVANS Marin St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/07/2003 12:00:00 AM | 3 | Permit Number 46338 | 6014150.89902 | 2100527.87809 | 37.748445208788 | -122.39383011827 | (37.748445208788, -122.39383011827) | 10 | 3 | 8 | 58 | 1 | ||
20295 | 202167 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 10 Kalmanovitz St | 7 | Sidewalk: Curb side : Yard | Tree | Private 2 | 6 | Width 2ft | 6013164.54762 | 2093230.83795 | 37.7283541968866 | -122.396729443526 | (37.7283541968866, -122.396729443526) | 10 | 3 | 8 | 58 | 1 | |||
28547 | 95607 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 345 08th Ave | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 3x3 | 5993380.81309 | 2113072.51492 | 37.7817133512738 | -122.466563747739 | (37.7817133512738, -122.466563747739) | 11 | 6 | 2 | 54 | 11 | |||
30048 | 81703 | Permitted Site 7 | Prunus cerasifera :: Cherry Plum 7 | 728 20th St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/21/2007 12:00:00 AM | 3x3 | Permit Number 50044 | 6015682.09798099 | 2104903.80699852 | 37.7605455583769 | -122.388840669387 | (37.7605455583769, -122.388840669387) | 10 | 3 | 8 | 28856 | 29 | ||
30762 | 41667 | Permitted Site 7 | Prunus cerasifera :: Cherry Plum 7 | 500 Corbett Ave | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/19/2000 12:00:00 AM | Permit Number 42131 | 5999528.76445246 | 2104225.15584588 | 37.7577735947767 | -122.444658701666 | (37.7577735947767, -122.444658701666) | 2 | 5 | 5 | 28862 | 3 |
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) );