trees
1,069 rows where qSpecies_id = 93 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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3780 | 14742 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 900 McAllister St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 4X4 | 6004772.182 | 2111961.3352 | 37.7793130940377 | -122.427075791541 | (37.7793130940377, -122.427075791541) | 7 | 9 | 11 | 29490 | 41 | |||
7377 | 14771 | Permitted Site 7 | Schinus terebinthifolius :: Brazilian Pepper 93 | 1000X McAllister St | 6 | Sidewalk: Curb side : Cutout | Tree | Office of Mayor 9 | 18 | 4x4 | 6004368.8552829 | 2111899.4426369 | 37.7791203368819 | -122.428466654288 | (37.7791203368819, -122.428466654288) | 7 | 9 | 11 | 29490 | 41 | |||
8307 | 141930 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 1050 MCALLISTER ST | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 20 | Width 0ft | 6004152.017 | 2111873.3634 | 37.7790364568014 | -122.429214926277 | (37.7790364568014, -122.429214926277) | 7 | 9 | 11 | 29490 | 41 | |||
10308 | 141912 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 900 MCALLISTER ST | 12 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 23 | Width 0ft | 6004447.1952 | 2111915.047 | 37.7791676154415 | -122.42819675688 | (37.7791676154415, -122.42819675688) | 7 | 9 | 11 | 29490 | 41 | |||
12227 | 33648 | Permitted Site 7 | Schinus terebinthifolius :: Brazilian Pepper 93 | 530 Linden St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/03/1996 12:00:00 AM | Permit Number 37739 | 6004854.0578934 | 2110753.28886702 | 37.7760007246145 | -122.426706497307 | (37.7760007246145, -122.426706497307) | 7 | 9 | 11 | 28852 | 10 | |||
13703 | 40148 | Permitted Site 7 | Schinus terebinthifolius :: Brazilian Pepper 93 | 580X Stanyan St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/01/1999 12:00:00 AM | 10 | 3x3 | Permit Number 41343 | 6004642 | 2110547 | 37.7754223144781 | -122.427425362403 | (37.7754223144781, -122.427425362403) | 7 | 9 | 11 | 28852 | 10 | |
14684 | 246599 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 52 Waller St | 5 | : | Tree | Private 2 | 18 | Width 3ft | 6005448.39533 | 2109271.63735 | 37.7719660524162 | -122.42454510839 | (37.7719660524162, -122.42454510839) | 7 | 9 | 11 | 28852 | 10 | |||
16227 | 138388 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 1955 STEINER ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 0ft | 6002442.7156 | 2115026.9125 | 37.7875983916864 | -122.435353722329 | (37.7875983916864, -122.435353722329) | 13 | 9 | 11 | 29490 | 27 | |||
21443 | 22619 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 1107 Turk St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 25 | 3X3 | 6004653.0794 | 2112584.8191 | 37.7810182911755 | -122.427532248108 | (37.7810182911755, -122.427532248108) | 7 | 9 | 11 | 29490 | 41 | |||
22630 | 59288 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 2067 Greenwich St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/20/1980 12:00:00 AM | 17 | Permit Number 18625 | 6003010.51633 | 2119230.45541 | 37.7991724689015 | -122.433689789967 | (37.7991724689015, -122.433689789967) | 13 | 9 | 1 | 57 | 17 | ||
26019 | 14743 | Permitted Site 7 | Schinus terebinthifolius :: Brazilian Pepper 93 | 900 McAllister St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 4X4 | 6004580.51193 | 2112075.36147 | 37.7796153416711 | -122.427746985107 | (37.7796153416711, -122.427746985107) | 7 | 9 | 11 | 29490 | 41 | |||
27097 | 12333 | Permitted Site 7 | Schinus terebinthifolius :: Brazilian Pepper 93 | 1105X Turk St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | 3X3 | 6004706.62549 | 2112590.71039 | 37.7810374956819 | -122.427347425327 | (37.7810374956819, -122.427347425327) | 7 | 9 | 11 | 29490 | 41 | |||
28456 | 239669 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 89 Webster St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 15 | Width 4ft | 6004261.58964 | 2108988.28216 | 37.7711209334157 | -122.428630156483 | (37.7711209334157, -122.428630156483) | 7 | 9 | 11 | 29492 | 10 | |||
30751 | 141929 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 1050 MCALLISTER ST | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 26 | Width 0ft | 6004201.9404 | 2111879.6644 | 37.7790565838512 | -122.429042670434 | (37.7790565838512, -122.429042670434) | 7 | 9 | 11 | 29490 | 41 | |||
32237 | 14772 | Permitted Site 7 | Schinus terebinthifolius :: Brazilian Pepper 93 | 1000X McAllister St | 7 | Sidewalk: Curb side : Cutout | Tree | Office of Mayor 9 | 06/30/1994 12:00:00 AM | 18 | 4X4 | 6004368.8552829 | 2111899.4426369 | 37.7791203368819 | -122.428466654288 | (37.7791203368819, -122.428466654288) | 7 | 9 | 11 | 29490 | 41 | ||
36218 | 116694 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 536 Linden St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | 3x4 | 6004835.97758 | 2110737.29191 | 37.7759557786585 | -122.426767902416 | (37.7759557786585, -122.426767902416) | 7 | 9 | 11 | 28852 | 10 | |||
37191 | 14744 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 900 McAllister St | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 4X4 | 6004580.51193 | 2112075.36147 | 37.7796153416711 | -122.427746985107 | (37.7796153416711, -122.427746985107) | 7 | 9 | 11 | 29490 | 41 | |||
38038 | 141910 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 900 MCALLISTER ST | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 21 | Width 0ft | 6004551.4043 | 2111926.6796 | 37.7792054513567 | -122.427837083851 | (37.7792054513567, -122.427837083851) | 7 | 9 | 11 | 29490 | 41 | |||
44097 | 96379 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 531 Grove St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/09/2012 12:00:00 AM | 10 | 3x3 | Permit Number 768930 | 6005269 | 2111284 | 37.7774813787572 | -122.425308876718 | (37.7774813787572, -122.425308876718) | 7 | 9 | 11 | 28852 | 10 | |
49782 | 14776 | Permitted Site 7 | Schinus terebinthifolius :: Brazilian Pepper 93 | 1000X McAllister St | 11 | Sidewalk: Curb side : Cutout | Tree | Office of Mayor 9 | 06/30/1994 12:00:00 AM | 12 | 4X4 | 6004368.8552829 | 2111899.4426369 | 37.7791203368819 | -122.428466654288 | (37.7791203368819, -122.428466654288) | 7 | 9 | 11 | 29490 | 41 | ||
54587 | 246597 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 52 Waller St | 3 | : | Tree | Private 2 | 16 | Width 3ft | 6005485.46938 | 2109277.24468 | 37.7719835424264 | -122.42441726525 | (37.7719835424264, -122.42441726525) | 7 | 9 | 11 | 28852 | 10 | |||
54668 | 22632 | Permitted Site 7 | Schinus terebinthifolius :: Brazilian Pepper 93 | 1171 Turk St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 30 | 3X3 | 6004419.15464 | 2112535.54329 | 37.7808697581914 | -122.428337997055 | (37.7808697581914, -122.428337997055) | 7 | 9 | 11 | 29490 | 41 | |||
54725 | 246598 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 52 Waller St | 4 | : | Tree | Private 2 | 20 | Width 3ft | 6005467.40356 | 2109274.31341 | 37.7719744736758 | -122.424479547814 | (37.7719744736758, -122.424479547814) | 7 | 9 | 11 | 28852 | 10 | |||
55264 | 136396 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 3651 Baker St | 9 | Sidewalk: Property side : Yard | Tree | Private 2 | 11 | Width 5ft | 5999117.86509 | 2121345.13243 | 37.8047571571746 | -122.447311924407 | (37.8047571571746, -122.447311924407) | 13 | 9 | 1 | 57 | 17 | |||
56897 | 14749 | Permitted Site 7 | Schinus terebinthifolius :: Brazilian Pepper 93 | 940 McAllister St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 4X4 | 6004580.51193 | 2112075.36147 | 37.7796153416711 | -122.427746985107 | (37.7796153416711, -122.427746985107) | 7 | 9 | 11 | 29490 | 41 | |||
56958 | 10262 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 212 Haight St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 80 | 3X3 | 6005067.14002 | 2109566.55049 | 37.7727542742761 | -122.425884896112 | (37.7727542742761, -122.425884896112) | 7 | 9 | 11 | 28852 | 10 | |||
57986 | 40147 | Permitted Site 7 | Schinus terebinthifolius :: Brazilian Pepper 93 | 580X Stanyan St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/01/1999 12:00:00 AM | 10 | 3x3 | Permit Number 41343 | 6004642 | 2110547 | 37.7754223144781 | -122.427425362403 | (37.7754223144781, -122.427425362403) | 7 | 9 | 11 | 28852 | 10 | |
58515 | 22676 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 1340 Turk St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3X3 | 6003587.61727 | 2112577.28894 | 37.7809372939052 | -122.431217671135 | (37.7809372939052, -122.431217671135) | 15 | 9 | 11 | 29490 | 41 | |||
59514 | 141904 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 900 MCALLISTER ST | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 0ft | 6004738.7382 | 2111954.0648 | 37.7792912400822 | -122.427190969626 | (37.7792912400822, -122.427190969626) | 7 | 9 | 11 | 29490 | 41 | |||
59824 | 40145 | Permitted Site 7 | Schinus terebinthifolius :: Brazilian Pepper 93 | 580X Stanyan St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/01/1999 12:00:00 AM | 10 | 3x3 | Permit Number 41343 | 6004642 | 2110547 | 37.7754223144781 | -122.427425362403 | (37.7754223144781, -122.427425362403) | 7 | 9 | 11 | 28852 | 10 | |
60311 | 136398 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 536 Linden St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 22 | Width 3ft | 6004816.14787 | 2110734.28179 | 37.7759463924382 | -122.426836284165 | (37.7759463924382, -122.426836284165) | 7 | 9 | 11 | 28852 | 10 | |||
61164 | 57496 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 2090 Vallejo St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/15/1988 12:00:00 AM | 15 | Permit Number 25529 | 6003581.68174 | 2117969.32312 | 37.7957421173574 | -122.431623277394 | (37.7957421173574, -122.431623277394) | 13 | 9 | 1 | 57 | 17 | ||
63439 | 9536 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 1100X Golden Gate Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 10/14/1994 12:00:00 AM | 3 | 3X3 | 6004118.455 | 2112215.6365 | 37.779974353933 | -122.42935544492 | (37.779974353933, -122.42935544492) | 7 | 9 | 11 | 29490 | 41 | ||
63504 | 138391 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 1955 STEINER ST | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 0ft | 6002452.5162 | 2114975.8094 | 37.7874586321962 | -122.435316157397 | (37.7874586321962, -122.435316157397) | 13 | 9 | 11 | 29490 | 27 | |||
65135 | 246583 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 98 Waller St | 1 | : | Tree | Private 2 | 14 | Width 3ft | 6005277.33485 | 2109248.26095 | 37.7718922045878 | -122.425135156289 | (37.7718922045878, -122.425135156289) | 7 | 9 | 11 | 28852 | 10 | |||
67554 | 23458 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 2252 Van Ness Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 17 | 4X4 | 6005965.50421 | 2118183.1057 | 37.7964639393172 | -122.423390011952 | (37.7964639393172, -122.423390011952) | 13 | 9 | 10 | 28858 | 32 | |||
71403 | 14754 | Permitted Site 7 | Schinus terebinthifolius :: Brazilian Pepper 93 | 950X McAllister St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | 4X4 | 6004580.51193 | 2112075.36147 | 37.7796153416711 | -122.427746985107 | (37.7796153416711, -122.427746985107) | 7 | 9 | 11 | 29490 | 41 | |||
74166 | 138389 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 1955 STEINER ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 0ft | 6002444.1157 | 2115010.1115 | 37.7875523399426 | -122.435347676 | (37.7875523399426, -122.435347676) | 13 | 9 | 11 | 29490 | 27 | |||
80568 | 30967 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 1904 Steiner St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/13/1995 12:00:00 AM | 10 | Permit Number 34758 | 6002512.7183 | 2114848.7346 | 37.7871131358628 | -122.435098778488 | (37.7871131358628, -122.435098778488) | 13 | 9 | 11 | 29490 | 27 | |
80575 | 142222 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 536 LINDEN ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 21 | Width 0ft | 6004811.0996 | 2110732.6679 | 37.7759416756566 | -122.426853632489 | (37.7759416756566, -122.426853632489) | 7 | 9 | 11 | 28852 | 10 | |||
82261 | 68986 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 1990 Jefferson St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/04/1994 12:00:00 AM | 18 | Permit Number 32976 | 5999758.99431 | 2121250.9256 | 37.8045351046614 | -122.44508646209 | (37.8045351046614, -122.44508646209) | 13 | 9 | 1 | 57 | 17 | |
83546 | 246591 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 22 Waller St | 2 | : | Tree | Private 2 | 20 | Width 3ft | 6005592.78222 | 2109289.94448 | 37.7720244723693 | -122.424046964897 | (37.7720244723693, -122.424046964897) | 7 | 9 | 11 | 28852 | 10 | |||
84963 | 141901 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 900 MCALLISTER ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 0ft | 6004790.1275 | 2111962.5056 | 37.7793173224289 | -122.427013793928 | (37.7793173224289, -122.427013793928) | 7 | 9 | 11 | 29490 | 41 | |||
86102 | 219588 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 98x Waller St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6005256 | 2109297 | 37.7720248250001 | -122.42521242385 | (37.7720248250001, -122.42521242385) | 7 | 9 | 11 | 28852 | 10 | ||||
96485 | 141902 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 900 MCALLISTER ST | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 0ft | 6004761.5188 | 2111959.3964 | 37.7793071675848 | -122.427112541879 | (37.7793071675848, -122.427112541879) | 7 | 9 | 11 | 29490 | 41 | |||
97960 | 14745 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 910 McAllister St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 4X4 | 6004580.51193 | 2112075.36147 | 37.7796153416711 | -122.427746985107 | (37.7796153416711, -122.427746985107) | 7 | 9 | 11 | 29490 | 41 | |||
98734 | 246592 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 22 Waller St | 3 | : | Tree | Private 2 | 20 | Width 3ft | 6005574.15853 | 2109287.40717 | 37.7720164540359 | -122.42411120528 | (37.7720164540359, -122.42411120528) | 7 | 9 | 11 | 28852 | 10 | |||
101602 | 141908 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 900 MCALLISTER ST | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 0ft | 6004604.7205 | 2111934.4347 | 37.7792297609062 | -122.427653193772 | (37.7792297609062, -122.427653193772) | 7 | 9 | 11 | 29490 | 41 | |||
112659 | 141903 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 900 MCALLISTER ST | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 0ft | 6004752.7943 | 2111956.4883 | 37.7792986892944 | -122.427142516377 | (37.7792986892944, -122.427142516377) | 7 | 9 | 11 | 29490 | 41 | |||
115880 | 14775 | Permitted Site 7 | Schinus terebinthifolius :: Brazilian Pepper 93 | 1000X McAllister St | 10 | Sidewalk: Curb side : Cutout | Tree | Office of Mayor 9 | 12 | 4X4 | 6004368.8552829 | 2111899.4426369 | 37.7791203368819 | -122.428466654288 | (37.7791203368819, -122.428466654288) | 7 | 9 | 11 | 29490 | 41 | |||
116236 | 108004 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 520 Hayes St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | 4x4 | Permit Number 773433 | 6005298.14108 | 2111058.38089 | 37.776863530054 | -122.425192009758 | (37.776863530054, -122.425192009758) | 7 | 9 | 11 | 28852 | 10 | ||
118823 | 9537 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 1100X Golden Gate Ave | 5 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 05/14/1992 12:00:00 AM | 3 | 3X3 | 6004100.4915 | 2112210.9093 | 37.7799603572012 | -122.429417251502 | (37.7799603572012, -122.429417251502) | 7 | 9 | 11 | 29490 | 41 | ||
121328 | 136399 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 1667 Green St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 4ft | 6005091.5128 | 2118475.84475 | 37.7972183598879 | -122.42643506692 | (37.7972183598879, -122.42643506692) | 13 | 9 | 1 | 57 | 17 | |||
128300 | 40086 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 1667 Green St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/19/1999 12:00:00 AM | 9 | Permit Number 41307 | 6005062.9841 | 2118469.14548 | 37.7971983526666 | -122.426533306168 | (37.7971983526666, -122.426533306168) | 13 | 9 | 1 | 57 | 17 | ||
139426 | 141933 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 1050 MCALLISTER ST | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 0ft | 6004066.711 | 2111861.7308 | 37.7789996869773 | -122.429509204364 | (37.7789996869773, -122.429509204364) | 7 | 9 | 11 | 29490 | 41 | |||
141055 | 138390 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 1955 STEINER ST | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 0ft | 6002448.3159 | 2114992.6104 | 37.7875045249199 | -122.435331891812 | (37.7875045249199, -122.435331891812) | 13 | 9 | 11 | 29490 | 27 | |||
141904 | 14751 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 940 McAllister St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 4X4 | 6004580.51193 | 2112075.36147 | 37.7796153416711 | -122.427746985107 | (37.7796153416711, -122.427746985107) | 7 | 9 | 11 | 29490 | 41 | |||
143267 | 116981 | Undocumented 4 | Schinus terebinthifolius :: Brazilian Pepper 93 | 89 WEBSTER ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6004230 | 2108988 | 37.7711183708566 | -122.428739406059 | (37.7711183708566, -122.428739406059) | 7 | 9 | 11 | 29492 | 10 | |||||
143677 | 41343 | Permitted Site 7 | Schinus terebinthifolius :: Brazilian Pepper 93 | 340 Steiner St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/25/2000 12:00:00 AM | Permit Number 41997 | 6003273.15240269 | 2109435.92669423 | 37.7722940667741 | -122.43208116562 | (37.7722940667741, -122.43208116562) | 15 | 9 | 11 | 29492 | 10 | ||
144095 | 68014 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 3400 Baker St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/01/1993 12:00:00 AM | 1 | Permit Number 31744 | 5999283.32146 | 2120515.04352 | 37.8024874104189 | -122.446679585917 | (37.8024874104189, -122.446679585917) | 13 | 9 | 1 | 57 | 17 | ||
147782 | 240586 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 117 Germania St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/04/1996 12:00:00 AM | 2 | Width 3ft | Permit Number 37769 | 6003553.87833 | 2108799.61563 | 37.770562824039 | -122.431064686005 | (37.770562824039, -122.431064686005) | 15 | 9 | 11 | 29492 | 10 | |
147812 | 141823 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 1000 Golden Gate Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 17 | Width 0ft | 6004743.395 | 2112299.7812 | 37.7802407554337 | -122.427199492081 | (37.7802407554337, -122.427199492081) | 7 | 9 | 11 | 29490 | 41 | |||
156764 | 40149 | Permitted Site 7 | Schinus terebinthifolius :: Brazilian Pepper 93 | 580X Stanyan St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/01/1999 12:00:00 AM | 10 | 3x3 | Permit Number 41343 | 6004642 | 2110547 | 37.7754223144781 | -122.427425362403 | (37.7754223144781, -122.427425362403) | 7 | 9 | 11 | 28852 | 10 | |
159229 | 141911 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 900 MCALLISTER ST | 11 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 20 | Width 0ft | 6004522.3227 | 2111922.8021 | 37.7791931595072 | -122.427937412735 | (37.7791931595072, -122.427937412735) | 7 | 9 | 11 | 29490 | 41 | |||
161010 | 141934 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 1050 MCALLISTER ST | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 0ft | 6004016.7876 | 2111854.945 | 37.7789782281051 | -122.429681425362 | (37.7789782281051, -122.429681425362) | 7 | 9 | 11 | 29490 | 41 | |||
163269 | 239688 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 214 Haight St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 3ft | 6005063.05276 | 2109561.17817 | 37.7727392922036 | -122.425898651924 | (37.7727392922036, -122.425898651924) | 7 | 9 | 11 | 28852 | 10 | |||
165709 | 14777 | Permitted Site 7 | Schinus terebinthifolius :: Brazilian Pepper 93 | 1000X McAllister St | 12 | Sidewalk: Curb side : Cutout | Tree | Office of Mayor 9 | 12 | 4X4 | 6004368.8552829 | 2111899.4426369 | 37.7791203368819 | -122.428466654288 | (37.7791203368819, -122.428466654288) | 7 | 9 | 11 | 29490 | 41 | |||
167002 | 48770 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 560 Hayes St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/17/2002 12:00:00 AM | 15 | 3x3 | Permit Number 46028 | 6005170.9549 | 2110973.7304 | 37.7766239145875 | -122.425625959395 | (37.7766239145875, -122.425625959395) | 7 | 9 | 11 | 28852 | 10 | |
169348 | 48771 | Permitted Site 7 | Schinus terebinthifolius :: Brazilian Pepper 93 | 562 Hayes St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/17/2002 12:00:00 AM | Permit Number 773432 | 6005160.4427442 | 2110970.099276 | 37.77661335041 | -122.425662065534 | (37.77661335041, -122.425662065534) | 7 | 9 | 11 | 28852 | 10 | |||
174064 | 138844 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 560 HAYES ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 0ft | 6005153.7619 | 2110972.2976 | 37.7766190089592 | -122.425685333039 | (37.7766190089592, -122.425685333039) | 7 | 9 | 11 | 28852 | 10 | |||
175086 | 9540 | Permitted Site 7 | Schinus terebinthifolius :: Brazilian Pepper 93 | 1100X Golden Gate Ave | 8 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 10/14/1994 12:00:00 AM | 3 | 3X3 | 6004321.7721316 | 2112240.3684222 | 37.7800537702914 | -122.428653843346 | (37.7800537702914, -122.428653843346) | 7 | 9 | 11 | 29490 | 41 | ||
177367 | 6886 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 289X Fell St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 24 | 5x6 | 6006058.26796 | 2110694.64672 | 37.7759077162141 | -122.422536644348 | (37.7759077162141, -122.422536644348) | 7 | 9 | 11 | 28852 | 10 | |||
177695 | 12322 | Permitted Site 7 | Schinus terebinthifolius :: Brazilian Pepper 93 | 1008X Golden Gate Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | 3X3 | 6004729.34594 | 2112297.27395 | 37.7802330766406 | -122.427247915616 | (37.7802330766406, -122.427247915616) | 7 | 9 | 11 | 29490 | 41 | |||
179654 | 14752 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 940 McAllister St | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 4X4 | 6004580.51193 | 2112075.36147 | 37.7796153416711 | -122.427746985107 | (37.7796153416711, -122.427746985107) | 7 | 9 | 11 | 29490 | 41 | |||
180537 | 9533 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 1100X Golden Gate Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 6 | 3X3 | 6004176.1272 | 2112221.7819 | 37.7799944925987 | -122.429156369266 | (37.7799944925987, -122.429156369266) | 7 | 9 | 11 | 29490 | 41 | |||
180708 | 141935 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 1050 MCALLISTER ST | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 0ft | 6003990.6142 | 2111850.0981 | 37.7789634376361 | -122.429771623844 | (37.7789634376361, -122.429771623844) | 7 | 9 | 11 | 29490 | 41 | |||
186462 | 30968 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 1902 Steiner St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/13/1995 12:00:00 AM | 9 | Permit Number 34759 | 6002518.1694 | 2114816.0277 | 37.7870236405814 | -122.435077578769 | (37.7870236405814, -122.435077578769) | 13 | 9 | 11 | 29490 | 27 | |
186586 | 141838 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 1103 Turk St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 0ft | 6004708.7161 | 2112593.1646 | 37.7810443525714 | -122.427340367744 | (37.7810443525714, -122.427340367744) | 7 | 9 | 11 | 29490 | 41 | |||
186845 | 141832 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 1171 TURK ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 24 | Width 0ft | 6004383.2413 | 2112546.5688 | 37.7808979992964 | -122.428463024993 | (37.7808979992964, -122.428463024993) | 7 | 9 | 11 | 29490 | 41 | |||
187896 | 22636 | Permitted Site 7 | Schinus terebinthifolius :: Brazilian Pepper 93 | 1181 Turk St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 32 | 3X3 | 6004533.51826 | 2112418.26728 | 37.7805542178607 | -122.427933997943 | (37.7805542178607, -122.427933997943) | 7 | 9 | 11 | 29490 | 41 | |||
188949 | 141831 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 1181 TURK ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 22 | Width 0ft | 6004346.382 | 2112542.3961 | 37.7808844562183 | -122.42859024189 | (37.7808844562183, -122.42859024189) | 7 | 9 | 11 | 29490 | 41 | |||
194298 | 262528 | Significant Tree 6 | Schinus terebinthifolius :: Brazilian Pepper 93 | 3400 Laguna St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/07/2020 12:00:00 AM | 3 | 3x3 | 6003691 | 2120547 | 37.8028259466608 | -122.431429119577 | (37.8028259466608, -122.431429119577) | 13 | 9 | 1 | 57 | 17 | ||
4000 | 79751 | Significant Tree 6 | Schinus terebinthifolius :: Brazilian Pepper 93 | 15 Junipero Serra Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4x10 | 5991685.90264393 | 2095891.27109779 | 37.7344402285305 | -122.471175151585 | (37.7344402285305, -122.471175151585) | 9 | 8 | 4 | 59 | 40 | ||||
4235 | 215001 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 1063 Plymouth Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 3ft | 5995907.45606 | 2090967.94562 | 37.7211652376617 | -122.45622408897 | (37.7211652376617, -122.45622408897) | 9 | 8 | 6 | 28861 | 24 | |||
5678 | 214198 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 165 Upland Dr | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 5994046.02682 | 2093769.86979 | 37.7287516135932 | -122.462861635163 | (37.7287516135932, -122.462861635163) | 9 | 8 | 4 | 59 | 40 | |||
6864 | 214183 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 347 Santa Ana Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 17 | Width 3ft | 5992610.48002 | 2094547.79644 | 37.7308048179917 | -122.467880927762 | (37.7308048179917, -122.467880927762) | 9 | 8 | 4 | 59 | 40 | |||
7076 | 215009 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 220 Santa Ana Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 5ft | 5992622.02484 | 2095272.12308 | 37.7327943054026 | -122.467893679258 | (37.7327943054026, -122.467893679258) | 9 | 8 | 4 | 59 | 40 | |||
16461 | 183905 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 2101 22nd Ave | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 17 | Width 0ft | 5989441.4873 | 2100495.8044 | 37.7469530039163 | -122.479271477973 | (37.7469530039163, -122.479271477973) | 1 | 8 | 3 | 29491 | 35 | |||
18292 | 214176 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 2570 16th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 5991436.65565 | 2097934.35886 | 37.7400356087611 | -122.4721857495 | (37.7400356087611, -122.4721857495) | 1 | 8 | 4 | 29491 | 40 | |||
22787 | 215004 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 240 Grafton Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 5996022.14356 | 2090574.20231 | 37.7200906944015 | -122.455799201591 | (37.7200906944015, -122.455799201591) | 9 | 8 | 6 | 28861 | 24 | |||
26869 | 66993 | Permitted Site 7 | Schinus terebinthifolius :: Brazilian Pepper 93 | 325 Holloway Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/12/1992 12:00:00 AM | Permit Number 30346 | 5995859.19605633 | 2091190.56071344 | 37.7217737155135 | -122.456406997913 | (37.7217737155135, -122.456406997913) | 9 | 8 | 6 | 28861 | 24 | ||
27009 | 214185 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 333 Santa Ana Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 3ft | 5992626.04523 | 2094642.7577 | 37.7310664568338 | -122.467834020931 | (37.7310664568338, -122.467834020931) | 9 | 8 | 4 | 59 | 40 | |||
32589 | 183903 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 2101 22nd Ave | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 0ft | 5989437.5475 | 2100612.4238 | 37.7472729813132 | -122.479293631278 | (37.7472729813132, -122.479293631278) | 1 | 8 | 3 | 29491 | 35 | |||
38007 | 217714 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 1199 Ocean Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 0ft | 5996346.1405 | 2091806.7339 | 37.7234935241877 | -122.454768263296 | (37.7234935241877, -122.454768263296) | 9 | 8 | 4 | 28861 | 24 | |||
39658 | 215015 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 99 Fernwood Dr | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 5994765.23071 | 2095304.12361 | 37.7330056991393 | -122.460486446495 | (37.7330056991393, -122.460486446495) | 9 | 8 | 4 | 59 | 40 | |||
44330 | 67999 | Permitted Site 7 | Schinus terebinthifolius :: Brazilian Pepper 93 | 1063 Plymouth Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/20/1993 12:00:00 AM | Permit Number 31724 | 5995906.21686349 | 2090968.00525531 | 37.7211653302718 | -122.456228376798 | (37.7211653302718, -122.456228376798) | 9 | 8 | 6 | 28861 | 24 | ||
44983 | 215010 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 220 Santa Ana Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 5ft | 5992623.69978 | 2095247.7676 | 37.7327275280451 | -122.467886117771 | (37.7327275280451, -122.467886117771) | 9 | 8 | 4 | 59 | 40 | |||
46066 | 107120 | Undocumented 4 | Schinus terebinthifolius :: Brazilian Pepper 93 | 249 HOLLOWAY AVE | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3x3 | 5996083 | 2091212 | 37.7218454285066 | -122.455634919471 | (37.7218454285066, -122.455634919471) | 9 | 8 | 6 | 28861 | 24 | |||
47324 | 214178 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 229 Granville Way | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 5ft | 5994148.82976 | 2098782.7623 | 37.7425216973119 | -122.462869772235 | (37.7425216973119, -122.462869772235) | 1 | 8 | 4 | 59 | 40 | |||
47513 | 214197 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 175 Upland Dr | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 5994005.53316 | 2093797.66398 | 37.7288255972015 | -122.463003639022 | (37.7288255972015, -122.463003639022) | 9 | 8 | 4 | 59 | 40 |
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) );