trees
182 rows where SiteOrder = 2 and qSpecies_id = 93 sorted by qAddress
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
127628 | 179481 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 0 Serrano Dr | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 15 | 5988902.49405 | 2090393.59661 | 37.7191836220039 | -122.480395922129 | (37.7191836220039, -122.480395922129) | 1 | 8 | 4 | 64 | 14 | ||||
176933 | 179484 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 0 Serrano Dr | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 9 | 5988536.49014 | 2090373.27915 | 37.7191065591004 | -122.481659555971 | (37.7191065591004, -122.481659555971) | 1 | 8 | 4 | 64 | 14 | ||||
105323 | 251187 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 1 Baker St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6000800 | 2109063 | 37.7711295786607 | -122.440609247553 | (37.7711295786607, -122.440609247553) | 15 | 5 | 11 | 29492 | 9 | ||||
135661 | 245059 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 1 Baker St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 0ft | 6000823.1995 | 2109073.1196 | 37.7711586856136 | -122.44052972578 | (37.7711586856136, -122.44052972578) | 15 | 5 | 11 | 29492 | 9 | |||
85114 | 247185 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 1 Buena Vista Ave East | 2 | : | Tree | Private 2 | 13 | Width 4ft | 6000997.16935 | 2108899.56704 | 37.7706920584128 | -122.439915513203 | (37.7706920584128, -122.439915513203) | 15 | 5 | 11 | 29492 | 9 | |||
35678 | 240563 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 10 Hancock St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6004179.51855 | 2105131.83325 | 37.7605274080343 | -122.42863909662 | (37.7605274080343, -122.42863909662) | 2 | 4 | 5 | 28862 | 3 | |||
192856 | 197561 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 100 15th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 5ft | 6011901.49708 | 2107505.77021 | 37.7674796980447 | -122.402099047246 | (37.7674796980447, -122.402099047246) | 8 | 2 | 8 | 28853 | 20 | |||
93273 | 179485 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 100 Capistrano Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 4ft | 6001441.34691 | 2093639.06415 | 37.7288156345119 | -122.437286225591 | (37.7288156345119, -122.437286225591) | 9 | 7 | 6 | 28861 | 25 | |||
13044 | 197544 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 101 Rhode Island St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 20 | Width 3ft | 6011744.68904 | 2107088.20402 | 37.766324401967 | -122.402612061007 | (37.766324401967, -122.402612061007) | 8 | 2 | 8 | 28853 | 20 | |||
66304 | 123757 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 103 Cabrillo St | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 5 | Width 4ft | 5995251.69378 | 2110760.63793 | 37.7754733358801 | -122.459923903312 | (37.7754733358801, -122.459923903312) | 11 | 6 | 2 | 54 | 11 | |||
75678 | 197519 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 1055 Natoma St | 2 | : | Tree | Private 2 | 7 | Width 3ft | 6007591.22918 | 2109427.92338 | 37.7725159572842 | -122.417143942455 | (37.7725159572842, -122.417143942455) | 8 | 2 | 9 | 28853 | 19 | |||
108379 | 41627 | Permitted Site 7 | Schinus terebinthifolius :: Brazilian Pepper 93 | 1095 Natoma St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/01/2000 12:00:00 AM | Permit Number 42109 | 6007646.45182189 | 2109473.56842462 | 37.7726443942379 | -122.416956155908 | (37.7726443942379, -122.416956155908) | 8 | 2 | 9 | 28853 | 19 | |||
116428 | 246228 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 110 Frederick St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 22 | Width 0ft | 5999452.5303 | 2107741.8948 | 37.7674253335335 | -122.445175180965 | (37.7674253335335, -122.445175180965) | 15 | 5 | 11 | 29492 | 9 | |||
157153 | 179460 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 110 Italy Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 2ft | 6000997.30077 | 2089688.71555 | 37.7179436214658 | -122.438538393947 | (37.7179436214658, -122.438538393947) | 9 | 7 | 6 | 28861 | 5 | |||
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 | |||
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 | |||
118609 | 136401 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 1128 Bush St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 6007893.03777 | 2115514.03443 | 37.7892439283227 | -122.416531148891 | (37.7892439283227, -122.416531148891) | 13 | 1 | 10 | 28858 | 21 | |||
186974 | 179491 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 117 Naylor St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 4ft | 6002422.82198 | 2087024.8993 | 37.7107103553801 | -122.433420745181 | (37.7107103553801, -122.433420745181) | 9 | 7 | 6 | 28861 | 5 | |||
121835 | 46759 | Permitted Site 7 | Schinus terebinthifolius :: Brazilian Pepper 93 | 1180X Bush St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/24/2002 12:00:00 AM | Permit Number 44858 | 6007776.04474552 | 2115482.02501481 | 37.7891494581332 | -122.416933662921 | (37.7891494581332, -122.416933662921) | 13 | 1 | 10 | 28858 | 21 | |||
152092 | 50629 | Permitted Site 7 | Schinus terebinthifolius :: Brazilian Pepper 93 | 1198 Gilman Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/14/2004 12:00:00 AM | Permit Number 47728 | 6014541.97081926 | 2090297.22948146 | 37.7203756614272 | -122.39176255443 | (37.7203756614272, -122.39176255443) | 10 | 3 | 8 | 58 | 1 | |||
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 | |||
1203 | 179432 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 122 Santos St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 12 | Width 6ft | 6006549.42501 | 2086808.72834 | 37.7103500527955 | -122.419142922204 | (37.7103500527955, -122.419142922204) | 9 | 7 | 8 | 309 | 39 | |||
85062 | 87200 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 123 Cabrillo St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/08/2008 12:00:00 AM | 2 | 3x3 | 5995204.25641 | 2110758.61891 | 37.7754650638757 | -122.460087853041 | (37.7754650638757, -122.460087853041) | 11 | 6 | 2 | 54 | 11 | ||
49551 | 5262 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 1234 Divisadero St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 4X4 | 6001365.3782 | 2112681.2883 | 37.7810966664945 | -122.438912929299 | (37.7810966664945, -122.438912929299) | 15 | 5 | 11 | 29490 | 41 | |||
143552 | 197507 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 1275 Harrison St | 2 | : | Tree | Private 2 | 7 | Width 3ft | 6009714.36956 | 2109423.21347 | 37.7726222364622 | -122.409799423029 | (37.7726222364622, -122.409799423029) | 14 | 2 | 9 | 28853 | 34 | |||
126956 | 94034 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 1300X Lane St | 2 | Sidewalk: Property side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 24 | 3x3 | 6015674.4242 | 2095246.7836 | 37.7340289546749 | -122.388193241926 | (37.7340289546749, -122.388193241926) | 10 | 3 | 8 | 58 | 1 | ||
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 | |||
43916 | 98255 | Permitted Site 7 | Schinus terebinthifolius :: Brazilian Pepper 93 | 1375 Noe St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 22 | 5x5 | Permit Number 25808 | 6003289 | 2100236 | 37.7470341706262 | -122.431369496968 | (37.7470341706262, -122.431369496968) | 2 | 7 | 5 | 63 | 22 | ||
145601 | 239737 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 1375 Noe St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 22 | Width 5ft | 6003294.62667 | 2100231.18022 | 37.7470212555198 | -122.431349696436 | (37.7470212555198, -122.431349696436) | 2 | 7 | 5 | 63 | 22 | |||
121929 | 239680 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 14 Fair Oaks St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 6ft | 6005352.16587 | 2103533.57017 | 37.7562052473857 | -122.424469755997 | (37.7562052473857, -122.424469755997) | 2 | 4 | 5 | 28859 | 19 | |||
135371 | 122960 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 140 09th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 4ft | 5993063.2627 | 2114539.09095 | 37.7857218385904 | -122.467769009292 | (37.7857218385904, -122.467769009292) | 11 | 6 | 2 | 54 | 11 | |||
21972 | 197530 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 1400 18th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 6ft | 6013404.894 | 2105708.82045 | 37.7626294689928 | -122.396772970689 | (37.7626294689928, -122.396772970689) | 14 | 3 | 8 | 28856 | 29 | |||
64596 | 52688 | Permitted Site 7 | Schinus terebinthifolius :: Brazilian Pepper 93 | 1401@ RIVOLI Shrader St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/30/2006 12:00:00 AM | Permit Number 48758 | 5997782.1418349 | 2105912.5855129 | 37.76230702883 | -122.450820884323 | (37.76230702883, -122.450820884323) | 15 | 5 | 11 | 29492 | 9 | |||
141318 | 10425 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 1419 Haight St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 90 | 3x3 | 5999323.0709 | 2108716.5502 | 37.7700941010229 | -122.445693060933 | (37.7700941010229, -122.445693060933) | 15 | 5 | 11 | 29492 | 9 | |||
124231 | 214201 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 145 Maywood Dr | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 2ft | 5994272.70142 | 2095629.8656 | 37.7338717597584 | -122.462212852568 | (37.7338717597584, -122.462212852568) | 9 | 8 | 4 | 59 | 40 | |||
154674 | 21843 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 148 Balboa St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3X3 | 5995171.12407 | 2111491.00238 | 37.7774740890587 | -122.460255539349 | (37.7774740890587, -122.460255539349) | 11 | 6 | 2 | 54 | 11 | |||
102524 | 258404 | Significant Tree 6 | Schinus terebinthifolius :: Brazilian Pepper 93 | 15 Junipero Serra Blvd | 2 | 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 | ||||
100923 | 111027 | Permitted Site 7 | Schinus terebinthifolius :: Brazilian Pepper 93 | 150 15th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6011831.59667013 | 2107504.61941603 | 37.7674726364822 | -122.402340743885 | (37.7674726364822, -122.402340743885) | 8 | 2 | 8 | 28853 | 20 | ||||
107916 | 123827 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 1501 Anza St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 3ft | 5993999.90025 | 2112075.97538 | 37.7790128280473 | -122.46434964043 | (37.7790128280473, -122.46434964043) | 11 | 6 | 2 | 54 | 11 | |||
169480 | 200672 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 1535 Newcomb Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 0ft | 6015595.8297 | 2095380.8889 | 37.7343928257308 | -122.388474327143 | (37.7343928257308, -122.388474327143) | 10 | 3 | 8 | 58 | 1 | |||
145312 | 98611 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 1537 Revere Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | 3x3 | 6015388.0762 | 2094133.544 | 37.730956353088 | -122.389105540873 | (37.730956353088, -122.389105540873) | 10 | 3 | 8 | 58 | 1 | |||
89864 | 200830 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 1550 16th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 0ft | 6011811.2987 | 2107032.5363 | 37.7661752695362 | -122.402377754798 | (37.7661752695362, -122.402377754798) | 8 | 3 | 8 | 28853 | 20 | |||
3578 | 261993 | Significant Tree 6 | Schinus terebinthifolius :: Brazilian Pepper 93 | 1557x Bancroft Ave | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 6014548 | 2092008 | 37.7250734320456 | -122.391861276019 | (37.7250734320456, -122.391861276019) | 10 | 3 | 8 | 58 | 1 | ||||
23706 | 239699 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 157 Rivoli St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 5997863.73891 | 2105916.05553 | 37.7623212272736 | -122.450538922143 | (37.7623212272736, -122.450538922143) | 15 | 5 | 11 | 29492 | 9 | |||
162846 | 179453 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 1657 Sunnydale Ave | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | Width 10ft | 6006878.87058 | 2087495.95749 | 37.7122555876031 | -122.418052974468 | (37.7122555876031, -122.418052974468) | 9 | 7 | 8 | 309 | 39 | |||
78515 | 239684 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 1664 Alabama St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 3ft | 6009268.13 | 2099680.20873 | 37.7458451383533 | -122.41065485094 | (37.7458451383533, -122.41065485094) | 2 | 7 | 7 | 28859 | 2 | |||
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 | |||
37849 | 240519 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 167 Bemis St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6003354.83441 | 2096529.99607 | 37.7368620703274 | -122.430877405766 | (37.7368620703274, -122.430877405766) | 2 | 7 | 5 | 63 | 7 | |||
99055 | 40859 | Permitted Site 7 | Schinus terebinthifolius :: Brazilian Pepper 93 | 1670 Florida St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/21/2000 12:00:00 AM | Permit Number 42380 | 6009721.65724328 | 2100087.27684169 | 37.7469882750849 | -122.409115329349 | (37.7469882750849, -122.409115329349) | 2 | 7 | 7 | 28859 | 2 | ||
25497 | 40380 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 1700 Jones St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/02/1999 12:00:00 AM | 6 | Permit Number 41492 | 6008347.41967 | 2118338.88738 | 37.7970258231379 | -122.415159077534 | (37.7970258231379, -122.415159077534) | 5 | 1 | 10 | 308 | 21 | ||
41995 | 40570 | Permitted Site 7 | Schinus terebinthifolius :: Brazilian Pepper 93 | 1750 Taylor St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/15/1999 12:00:00 AM | Permit Number 41613 | 6008764.95036499 | 2118846.2736549 | 37.7984424358323 | -122.41375022293 | (37.7984424358323, -122.41375022293) | 3 | 1 | 10 | 308 | 21 | |||
7566 | 264756 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 176 Hahn St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 6007577 | 2087516 | 37.7123498887131 | -122.4156414431 | (37.7123498887131, -122.4156414431) | 9 | 7 | 8 | 309 | 39 | ||||
154530 | 138491 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 1800 Pierce St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 0ft | 6002045.7921 | 2114746.8959 | 37.7868069882912 | -122.43670694528 | (37.7868069882912, -122.43670694528) | 13 | 6 | 11 | 29490 | 27 | |||
131378 | 138488 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 1850 PIERCE ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 0ft | 6002039.4918 | 2114807.7995 | 37.7869738559463 | -122.43673310409 | (37.7869738559463, -122.43673310409) | 13 | 6 | 11 | 29490 | 27 | |||
120689 | 10523 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 1855 Haight St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 50 | 3X3 | 5997295.7816 | 2108435.9791 | 37.7692077702137 | -122.452685140494 | (37.7692077702137, -122.452685140494) | 15 | 5 | 11 | 29492 | 9 | |||
94667 | 197523 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 1919 16th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6010718.52588 | 2106914.57132 | 37.7657903018022 | -122.406149150388 | (37.7657903018022, -122.406149150388) | 8 | 4 | 8 | 28853 | 19 | |||
117461 | 200842 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 1919 16th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 0ft | 6010705.6887 | 2106916.0312 | 37.7657935922594 | -122.40619365455 | (37.7657935922594, -122.40619365455) | 8 | 4 | 8 | 28853 | 19 | |||
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 | |||
93708 | 34503 | Permitted Site 7 | Schinus terebinthifolius :: Brazilian Pepper 93 | 1x GUY PL | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/17/1997 12:00:00 AM | Permit Number 38225 | 6014462 | 2114376 | 37.7864863849761 | -122.393723467778 | (37.7864863849761, -122.393723467778) | 6 | 2 | 9 | 28855 | 6 | |||
23628 | 179425 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 2 Santos St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 13 | Width 6ft | 6006737.87137 | 2087492.25298 | 37.7122374788398 | -122.418540048182 | (37.7122374788398, -122.418540048182) | 9 | 7 | 8 | 309 | 39 | |||
20941 | 179443 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 20 Santos St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 11 | Width 6ft | 6006639.5983 | 2087274.41681 | 37.7116338134302 | -122.418864269997 | (37.7116338134302, -122.418864269997) | 9 | 7 | 8 | 309 | 39 | |||
36630 | 197555 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 200 Kansas St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 25 | Width 4ft | 6011386.38473 | 2107363.2099 | 37.7670594952368 | -122.403870728771 | (37.7670594952368, -122.403870728771) | 8 | 2 | 8 | 28853 | 20 | |||
36627 | 47707 | Permitted Site 7 | Schinus terebinthifolius :: Brazilian Pepper 93 | 200 Randall St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/22/2002 12:00:00 AM | Permit Number 45502 | 6004240.85369341 | 2097554.18637259 | 37.7397244258614 | -122.42788700337 | (37.7397244258614, -122.42788700337) | 2 | 7 | 5 | 63 | 7 | |||
163557 | 240591 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 200 Randall St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 4ft | 6004224.31251 | 2097557.73547 | 37.7397332350934 | -122.42794444859 | (37.7397332350934, -122.42794444859) | 2 | 7 | 5 | 63 | 7 | |||
128364 | 5349 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 200X Dolores St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 07/22/2010 12:00:00 AM | 12 | 3x3 | Permit Number 53640 | 6004790.70557 | 2107143.57223 | 37.7660857344886 | -122.426668539926 | (37.7660857344886, -122.426668539926) | 8 | 4 | 5 | 28862 | 3 | |
66614 | 123759 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 201 Cabrillo St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/16/2016 12:00:00 AM | 18 | Width 5ft | 5994972.58843 | 2110752.02511 | 37.7754336316323 | -122.460888764015 | (37.7754336316323, -122.460888764015) | 11 | 6 | 2 | 54 | 11 | ||
96965 | 239687 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 201 Valencia St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 3ft | 6006096.7615 | 2108447.15285 | 37.7697388094304 | -122.422243770256 | (37.7697388094304, -122.422243770256) | 8 | 4 | 7 | 28853 | 19 | |||
57063 | 240572 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 210 Collingwood St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 19 | Width 3ft | 6002036.98136 | 2104624.07975 | 37.7590117527075 | -122.436012807155 | (37.7590117527075, -122.436012807155) | 2 | 4 | 5 | 28862 | 3 | |||
157428 | 183899 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 2101 22nd Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 0ft | 5989428.0919 | 2100803.1123 | 37.7477960125827 | -122.479340275734 | (37.7477960125827, -122.479340275734) | 1 | 8 | 3 | 29491 | 35 | |||
62536 | 112022 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 2101x 22nd Ave | 2 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | 5x5 | 6011761 | 2103726 | 37.75709344993 | -122.402319220858 | (37.75709344993, -122.402319220858) | 10 | 3 | 8 | 28856 | 29 | ||||
65498 | 140194 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 2177 FELL ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 0ft | 5997033.6803 | 2109487.6013 | 37.772080231598 | -122.45366767652 | (37.772080231598, -122.45366767652) | 15 | 5 | 11 | 29492 | 16 | |||
48218 | 27409 | Permitted Site 7 | Schinus terebinthifolius :: Brazilian Pepper 93 | 2178 Fell St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/01/1999 12:00:00 AM | 6 | 3X3 | 5997014.41754 | 2109490.27003 | 37.7720864549253 | -122.453734500333 | (37.7720864549253, -122.453734500333) | 15 | 5 | 11 | 29492 | 16 | ||
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 | |||
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 | |||
134763 | 215008 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 230 Granville Way | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 4ft | 5994122.16655 | 2098836.84765 | 37.7426686663343 | -122.462965888181 | (37.7426686663343, -122.462965888181) | 1 | 8 | 4 | 59 | 40 | |||
163290 | 114214 | Undocumented 4 | Schinus terebinthifolius :: Brazilian Pepper 93 | 230 SERRANO DR | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 13 | 5988981 | 2090766 | 37.7202107101289 | -122.480151800691 | (37.7202107101289, -122.480151800691) | 1 | 8 | 4 | 64 | 14 | ||||
97829 | 30957 | Permitted Site 7 | Schinus terebinthifolius :: Brazilian Pepper 93 | 2390 Bush St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/13/1995 12:00:00 AM | Permit Number 34752 | 6002079.96472002 | 2114704.99678528 | 37.7866938860132 | -122.436585716056 | (37.7866938860132, -122.436585716056) | 13 | 6 | 11 | 29490 | 27 | ||
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 | |||
15213 | 78534 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 240 Wayland St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11 | 6010805.45879 | 2092437.25464 | 37.7260435984308 | -122.404829115572 | (37.7260435984308, -122.404829115572) | 10 | 3 | 7 | 309 | 28 | |||
183911 | 30960 | Permitted Site 7 | Schinus terebinthifolius :: Brazilian Pepper 93 | 2401 Bush St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/13/1995 12:00:00 AM | Permit Number 34753 | 6002022.0507417 | 2114644.40993289 | 37.7865242387809 | -122.436781745524 | (37.7865242387809, -122.436781745524) | 13 | 6 | 1 | 29490 | 27 | ||
108154 | 28531 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 241 06th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/11/2012 12:00:00 AM | 18 | 3X3 | Permit Number 769387 | 6010735.41269 | 2111831.43795 | 37.7792918290844 | -122.406437232011 | (37.7792918290844, -122.406437232011) | 14 | 2 | 9 | 28853 | 34 | |
152421 | 179430 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 241 Blythdale Ave | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 8 | Width 6ft | 6006173.52059 | 2087002.57891 | 37.7108611491941 | -122.420455879341 | (37.7108611491941, -122.420455879341) | 9 | 7 | 8 | 309 | 39 | |||
162504 | 179476 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 245 Wilson St | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 4 | 5994306.08107 | 2086649.96822 | 37.7092170428021 | -122.461446662549 | (37.7092170428021, -122.461446662549) | 9 | 8 | 6 | 28861 | 25 | ||||
47509 | 43759 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 249 17th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/26/2000 12:00:00 AM | 9 | Permit Number 43395 | 5990535.98179 | 2113705.55195 | 37.7832869196807 | -122.476451677439 | (37.7832869196807, -122.476451677439) | 11 | 6 | 2 | 55 | 26 | ||
79932 | 138325 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 2492 Bush St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 0ft | 6001603.2252 | 2114641.6748 | 37.7864929170324 | -122.438230579455 | (37.7864929170324, -122.438230579455) | 13 | 6 | 11 | 29490 | 27 | |||
112473 | 109297 | Undocumented 4 | Schinus terebinthifolius :: Brazilian Pepper 93 | 251 RHODE ISLAND ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6011759.4 | 2107238.5 | 37.7667379021668 | -122.402571748171 | (37.7667379021668, -122.402571748171) | 8 | 2 | 8 | 28853 | 20 | ||||
108229 | 214175 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 2574 16th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 5991436.71189 | 2097914.45578 | 37.7399809632369 | -122.472184104624 | (37.7399809632369, -122.472184104624) | 1 | 8 | 4 | 29491 | 40 | |||
167389 | 102832 | Undocumented 4 | Schinus terebinthifolius :: Brazilian Pepper 93 | 25X Lansing St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3x3 | 6014531.5 | 2114230.8 | 37.7860915609161 | -122.393472847757 | (37.7860915609161, -122.393472847757) | 6 | 2 | 9 | 28855 | 6 | |||
170620 | 101979 | Significant Tree 6 | Schinus terebinthifolius :: Brazilian Pepper 93 | 25X Tiffany Ave | 2 | Front Yard : Yard | Tree | Private 2 | 6006415.7 | 2099833.4 | 37.7461054290546 | -122.420529042399 | (37.7461054290546, -122.420529042399) | 2 | 7 | 7 | 28859 | 2 | |||||
115664 | 5372 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 266 Dolores St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 24 | 5x5 | 6004807.33386 | 2106790.92069 | 37.7651183778313 | -122.426585912012 | (37.7651183778313, -122.426585912012) | 8 | 4 | 5 | 28862 | 3 | |||
163960 | 40639 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 2740 Golden Gate Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/10/1999 12:00:00 AM | 12 | Permit Number 41638 | 5996441.36597 | 2111293.50073 | 37.7770047854178 | -122.455847097036 | (37.7770047854178, -122.455847097036) | 11 | 6 | 2 | 54 | 16 | ||
101186 | 32425 | Permitted Site 7 | Schinus terebinthifolius :: Brazilian Pepper 93 | 275 Maywood Dr | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 36952 | 5994490.2461397 | 2094811.13335462 | 37.7316362454296 | -122.461401406739 | (37.7316362454296, -122.461401406739) | 9 | 8 | 4 | 59 | 40 | ||||
43202 | 40608 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 2756 Golden Gate Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/16/1999 12:00:00 AM | 12 | Permit Number 41618 | 5996415.12538 | 2111289.35266 | 37.7769918898751 | -122.45593757087 | (37.7769918898751, -122.45593757087) | 11 | 6 | 2 | 54 | 16 | ||
102339 | 179465 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 291 France Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 2ft | 6001702.1853 | 2090068.84403 | 37.7190274412447 | -122.436129108381 | (37.7190274412447, -122.436129108381) | 9 | 7 | 6 | 28861 | 5 | |||
26919 | 2770 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 300 Cabrillo St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 20 | 3X3 | 5994656.76542 | 2110790.98006 | 37.7755224141133 | -122.461984087937 | (37.7755224141133, -122.461984087937) | 11 | 6 | 2 | 54 | 11 | |||
186525 | 18089 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 3000 Pine St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | 3X3 | 5999515.0867 | 2114695.0726 | 37.786520549412 | -122.445458834419 | (37.786520549412, -122.445458834419) | 15 | 6 | 1 | 29490 | 31 | |||
88167 | 197527 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 301 Utah St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 4ft | 6010651.56665 | 2106560.03091 | 37.7648130687996 | -122.406355766009 | (37.7648130687996, -122.406355766009) | 8 | 4 | 8 | 28853 | 19 | |||
28657 | 80831 | Permitted Site 7 | Schinus terebinthifolius :: Brazilian Pepper 93 | 3100 Turk Blvd | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/24/2007 12:00:00 AM | 4 | 4x4 | Permit Number 50050 | 5996132.20264074 | 2111467.88216918 | 37.7774658426 | -122.456929197984 | (37.7774658426, -122.456929197984) | 11 | 6 | 2 | 54 | 16 | |
66667 | 31499 | Permitted Site 7 | Schinus terebinthifolius :: Brazilian Pepper 93 | 3244 21st St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 35060 | 6006677.13820069 | 2103812.71234735 | 37.7570464414299 | -122.419907347924 | (37.7570464414299, -122.419907347924) | 2 | 4 | 7 | 28859 | 19 | ||||
168976 | 2775 | Permitted Site 7 | Schinus terebinthifolius :: Brazilian Pepper 93 | 325 Cabrillo St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 40 | 3X3 | 5994586.46007 | 2110712.87272 | 37.7753039042477 | -122.462221623284 | (37.7753039042477, -122.462221623284) | 11 | 6 | 2 | 54 | 11 |
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) );