trees
527 rows where SiteOrder = 1 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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
162222 | 179478 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 0 Serrano Dr | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 9 | 5989807.06872 | 2090726.39006 | 37.720149915678 | -122.477293493993 | (37.720149915678, -122.477293493993) | 1 | 8 | 4 | 64 | 14 | ||||
126597 | 33954 | Permitted Site 7 | Schinus terebinthifolius :: Brazilian Pepper 93 | 1 Arbor St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/18/1999 12:00:00 AM | Permit Number 48991 | 6002287.3237241 | 2097040.91143479 | 37.7382043832783 | -122.434604778209 | (37.7382043832783, -122.434604778209) | 2 | 7 | 5 | 63 | 7 | |||
136787 | 245058 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 1 Baker St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 0ft | 6000819.4043 | 2109108.2246 | 37.7712548590423 | -122.440545371757 | (37.7712548590423, -122.440545371757) | 15 | 5 | 11 | 29492 | 9 | |||
11580 | 247184 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 1 Buena Vista Ave East | 1 | : | Tree | Private 2 | 11/09/2017 12:00:00 AM | 3 | Width 4ft | Permit Number 780753 | 6001013.06071 | 2108893.70983 | 37.7706768805726 | -122.439860124855 | (37.7706768805726, -122.439860124855) | 15 | 5 | 11 | 29492 | 9 | |
31221 | 136411 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 10 Jackson St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 4ft | 6013381 | 2118288 | 37.7971676890736 | -122.397737980255 | (37.7971676890736, -122.397737980255) | 3 | 1 | 10 | 28860 | 6 | |||
38184 | 54244 | Permitted Site 7 | Schinus terebinthifolius :: Brazilian Pepper 93 | 10 Sharon St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/16/1972 12:00:00 AM | 24 | Permit Number 9985 | 6003826.70188878 | 2107089.19403693 | 37.7658818771202 | -122.429998956827 | (37.7658818771202, -122.429998956827) | 8 | 4 | 5 | 28862 | 3 | ||
42999 | 197560 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 100 15th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 5ft | 6011918.46378 | 2107507.65941 | 37.7674858323444 | -122.402040494185 | (37.7674858323444, -122.402040494185) | 8 | 2 | 8 | 28853 | 20 | |||
12797 | 62238 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 100 Capistrano Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/03/1985 12:00:00 AM | 21 | Permit Number 22364 | 6001428.6005 | 2093653.63751 | 37.7288549250112 | -122.437331333801 | (37.7288549250112, -122.437331333801) | 9 | 7 | 6 | 28861 | 25 | |
2386 | 19745 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 100 STAIRWAY15 | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 3X3 | |||||||||||||
102044 | 179480 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 100 Serrano Dr | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 11 | 5989599 | 2090767 | 37.7202493457345 | -122.478015677124 | (37.7202493457345, -122.478015677124) | 1 | 8 | 4 | 64 | 14 | ||||
112112 | 66607 | Permitted Site 7 | Schinus terebinthifolius :: Brazilian Pepper 93 | 100 Serrano Dr | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/01/1991 12:00:00 AM | 12 | Permit Number 29802 | 5989869.39246895 | 2090726.40504468 | 37.7201535727537 | -122.477078065149 | (37.7201535727537, -122.477078065149) | 1 | 8 | 4 | 64 | 14 | ||
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 | |||
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 | |||
67001 | 197543 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 101 Rhode Island St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 24 | Width 4ft | 6011744.4821 | 2107062.59215 | 37.7662540659871 | -122.402610975528 | (37.7662540659871, -122.402610975528) | 8 | 2 | 8 | 28853 | 20 | |||
146370 | 105020 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 101X ORD ST | 1 | Median : Yard | Tree | DPW 1 | 12 | 6000863 | 2105739 | 37.7620062865301 | -122.440152928616 | (37.7620062865301, -122.440152928616) | 15 | 5 | 5 | 28862 | 3 | ||||
132607 | 66239 | Permitted Site 7 | Schinus terebinthifolius :: Brazilian Pepper 93 | 1023 Plymouth Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/24/1990 12:00:00 AM | Permit Number 29337 | 5995901.80991046 | 2090714.82365274 | 37.720469900548 | -122.456225313763 | (37.720469900548, -122.456225313763) | 9 | 8 | 6 | 28861 | 24 | ||
62829 | 240524 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 1023 Stanyan St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 21 | Width 4ft | 5997228.03932 | 2107019.29645 | 37.7653140406215 | -122.452817189965 | (37.7653140406215, -122.452817189965) | 15 | 5 | 11 | 29492 | 12 | |||
18859 | 14566 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 1030 Masonic Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 45 | 3X3 | 5999382.6721 | 2109282.399 | 37.7716511811815 | -122.445527596882 | (37.7716511811815, -122.445527596882) | 15 | 5 | 11 | 29492 | 9 | |||
11220 | 239703 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 1048 Cole St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 21 | Width 3ft | 5998155.79673 | 2106630.88901 | 37.7643006917393 | -122.449580319477 | (37.7643006917393, -122.449580319477) | 15 | 5 | 11 | 29492 | 9 | |||
167487 | 17371 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 1050X Masonic Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 90 | 3X3 | 5999379.15193 | 2109268.47217 | 37.7716127406754 | -122.445538771694 | (37.7716127406754, -122.445538771694) | 15 | 5 | 11 | 29492 | 9 | |||
47409 | 96967 | Undocumented 4 | Schinus terebinthifolius :: Brazilian Pepper 93 | 1060 Noe St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7x9 | Created tree record on 8/15/2011; marked tree basin for expansion. C.Buck | 6003141 | 2102066 | 37.7520505318065 | -122.432011924137 | (37.7520505318065, -122.432011924137) | 2 | 4 | 5 | 28862 | 22 | |||
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 | |||
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 | ||
81823 | 62229 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 107 Capistrano Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/30/1985 12:00:00 AM | 9 | Permit Number 22354 | 6001481.45016 | 2093645.47099 | 37.7288355059294 | -122.437148044757 | (37.7288355059294, -122.437148044757) | 9 | 7 | 6 | 28861 | 25 | |
138687 | 245014 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 1070 Masonic Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | Width 0ft | 5999399.1249 | 2109164.2378 | 37.771327679754 | -122.44546218799 | (37.771327679754, -122.44546218799) | 15 | 5 | 11 | 29492 | 9 | |||
76734 | 68000 | Permitted Site 7 | Schinus terebinthifolius :: Brazilian Pepper 93 | 1090 Plymouth Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/01/1993 12:00:00 AM | Permit Number 31725 | 5995961.29385488 | 2091144.32738343 | 37.7216526305362 | -122.456050733712 | (37.7216526305362, -122.456050733712) | 9 | 8 | 6 | 28861 | 24 | ||
101282 | 215002 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 1090 Plymouth Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 5995954.15999 | 2091115.97449 | 37.7215743707347 | -122.456073344621 | (37.7215743707347, -122.456073344621) | 9 | 8 | 6 | 28861 | 24 | |||
163502 | 41628 | Permitted Site 7 | Schinus terebinthifolius :: Brazilian Pepper 93 | 1095 Natoma St | 1 | 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 | |||
114122 | 246227 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 110 Frederick St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 0ft | 5999464.6435 | 2107744.6203 | 37.7674335084717 | -122.445133479177 | (37.7674335084717, -122.445133479177) | 15 | 5 | 11 | 29492 | 9 | |||
74066 | 179461 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 110 Italy Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 2ft | 6000982.14926 | 2089697.75779 | 37.7179675875255 | -122.43859141349 | (37.7179675875255, -122.43859141349) | 9 | 7 | 6 | 28861 | 5 | |||
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 | |||
98297 | 30941 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 1101 Plymouth Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/13/1995 12:00:00 AM | 10 | Permit Number 34750 | 5995913.71268 | 2091275.1809 | 37.7220091920614 | -122.456224664532 | (37.7220091920614, -122.456224664532) | 9 | 8 | 4 | 28861 | 24 | |
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 | |||
112860 | 240566 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 111 Caselli Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 3ft | 6000512.65205 | 2104881.02417 | 37.759630543828 | -122.441303078972 | (37.759630543828, -122.441303078972) | 2 | 4 | 5 | 28862 | 3 | |||
60890 | 239696 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 112 Parnassus Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 22 | Width 4ft | 5997951.3916 | 2106835.98646 | 37.7648521416436 | -122.450302081196 | (37.7648521416436, -122.450302081196) | 15 | 5 | 11 | 29492 | 9 | |||
37780 | 136408 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 1120 Vallejo St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 3ft | 6008149.75151 | 2118608.08883 | 37.7977538729053 | -122.415862131533 | (37.7977538729053, -122.415862131533) | 5 | 1 | 10 | 28858 | 21 | |||
160176 | 217708 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 1125 Ocean Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 0ft | 5996389.2535 | 2091794.3451 | 37.7234619803781 | -122.454618335706 | (37.7234619803781, -122.454618335706) | 9 | 8 | 4 | 28861 | 24 | |||
56923 | 136400 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 1128 Bush St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 3ft | 6007907.63985 | 2115517.19966 | 37.7892534404542 | -122.416480851612 | (37.7892534404542, -122.416480851612) | 13 | 1 | 10 | 28858 | 21 | |||
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 | |
93783 | 179490 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 117 Naylor St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 4ft | 6002435.0144 | 2087009.10974 | 37.7106676924198 | -122.433377477905 | (37.7106676924198, -122.433377477905) | 9 | 7 | 6 | 28861 | 5 | |||
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 | |||
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 | |||
59403 | 46760 | Permitted Site 7 | Schinus terebinthifolius :: Brazilian Pepper 93 | 1180X Bush St | 1 | 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 | |||
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 | |||
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 | |||
6032 | 50628 | Permitted Site 7 | Schinus terebinthifolius :: Brazilian Pepper 93 | 1198 Gilman Ave | 1 | 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 | |||
78267 | 240528 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 1206 Stanyan St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 3ft | 5997448.87335 | 2105784.7399 | 37.7619369136818 | -122.451964305322 | (37.7619369136818, -122.451964305322) | 15 | 5 | 11 | 29492 | 9 | |||
42392 | 245011 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 1209 Page St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 0ft | 6000668.5479 | 2109254.8115 | 37.7716487585204 | -122.441077707327 | (37.7716487585204, -122.441077707327) | 15 | 5 | 11 | 29492 | 9 | |||
161000 | 239709 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 121 Frederick St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 3ft | 5999261.27725 | 2107669.14595 | 37.7672146651436 | -122.445831464074 | (37.7672146651436, -122.445831464074) | 15 | 5 | 5 | 29492 | 9 | |||
2071 | 179437 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 121 Santos St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 7 | Width 6ft | 6006551.53826 | 2086713.55756 | 37.7100888527847 | -122.419128872099 | (37.7100888527847, -122.419128872099) | 9 | 7 | 8 | 309 | 39 | |||
127036 | 245017 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 1221 Page St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 5 | Width 0ft | 6000631.5454 | 2109250.0676 | 37.7716336252812 | -122.441205360431 | (37.7716336252812, -122.441205360431) | 15 | 5 | 11 | 29492 | 9 | |||
160392 | 122800 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 1223 Quesada Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 17 | 3x3 | 6017230.3941 | 2093111.7012 | 37.7282525286375 | -122.382665199331 | (37.7282525286375, -122.382665199331) | 10 | 3 | 8 | 58 | 1 | |||
176752 | 64740 | Permitted Site 7 | Schinus terebinthifolius :: Brazilian Pepper 93 | 1225 Page St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/17/1988 12:00:00 AM | Permit Number 25701 | 6000702.83668032 | 2109256.16819914 | 37.7716544366578 | -122.440959198032 | (37.7716544366578, -122.440959198032) | 15 | 5 | 11 | 29492 | 9 | ||
156932 | 245018 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 1227 Page St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 16 | Width 0ft | 6000617.788 | 2109248.6444 | 37.7716289338677 | -122.441252845835 | (37.7716289338677, -122.441252845835) | 15 | 5 | 11 | 29492 | 9 | |||
144377 | 2754 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 123 Cabrillo St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | 3X3 | 5995213.94147 | 2110758.8179 | 37.7754661672939 | -122.460054364765 | (37.7754661672939, -122.460054364765) | 11 | 6 | 2 | 54 | 11 | |||
104142 | 5261 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 1234 Divisadero St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 4X4 | 6001382.11052 | 2112701.66304 | 37.7811535623212 | -122.438856504476 | (37.7811535623212, -122.438856504476) | 15 | 5 | 11 | 29490 | 41 | |||
27418 | 6356 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 1234X Divisadero St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 24 | 3X3 | 6001371.4698 | 2112650.1535 | 37.7810115248297 | -122.438889623593 | (37.7810115248297, -122.438889623593) | 15 | 5 | 11 | 29490 | 41 | |||
20400 | 84536 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 124 23rd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 6 | 5988694.18379 | 2114506.16667 | 37.7853781914991 | -122.482882183887 | (37.7853781914991, -122.482882183887) | 11 | 6 | 2 | 55 | 26 | |||
20507 | 2755 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 124 Cabrillo St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3X3 | 5995208.65957 | 2110814.76075 | 37.7756194677712 | -122.460076689691 | (37.7756194677712, -122.460076689691) | 11 | 6 | 2 | 54 | 11 | |||
17629 | 71250 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 1240 Broadway | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11 | 6x3 | 6007647.94637 | 2118195.049 | 37.7965915450137 | -122.417569230932 | (37.7965915450137, -122.417569230932) | 5 | 1 | 10 | 28858 | 32 | ||
137317 | 245128 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 1260 Page St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 0ft | 6000529.8828 | 2109280.0723 | 37.7717102191807 | -122.441559169968 | (37.7717102191807, -122.441559169968) | 15 | 5 | 11 | 29492 | 9 | |||
174056 | 179446 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 127 Brookdale Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 10 | Width 6ft | 6006032.90525 | 2087456.20206 | 37.712098777304 | -122.420974066009 | (37.712098777304, -122.420974066009) | 9 | 7 | 8 | 309 | 39 | |||
146996 | 5639 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 1273 Dolores St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 106 | 6X6 | 6005219.14783 | 2100952.73682 | 37.7491113654052 | -122.424746185103 | (37.7491113654052, -122.424746185103) | 2 | 4 | 5 | 28859 | 19 | |||
133546 | 51034 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 1275 Harrison St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/08/2004 12:00:00 AM | 13 | Permit Number 47509 | 6009703.0212 | 2109410.10707 | 37.7725856133573 | -122.409837753032 | (37.7725856133573, -122.409837753032) | 14 | 2 | 9 | 28853 | 34 | |
15470 | 105248 | Undocumented 4 | Schinus terebinthifolius :: Brazilian Pepper 93 | 1301 COLE ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | 4x5 | 5998246 | 2105821 | 37.7620821004846 | -122.44920998149 | (37.7620821004846, -122.44920998149) | 15 | 5 | 11 | 29492 | 9 | |||
162841 | 179488 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 1309 Silliman St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 19 | Width 3ft | 6006965.96518 | 2093139.94616 | 37.7277576792711 | -122.418151834246 | (37.7277576792711, -122.418151834246) | 9 | 3 | 7 | 309 | 5 | |||
7442 | 240565 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 131 Caselli Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 3ft | 6000404.48259 | 2104877.48466 | 37.7596146626978 | -122.441676928051 | (37.7596146626978, -122.441676928051) | 2 | 4 | 5 | 28862 | 3 | |||
39490 | 215006 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 1315 03rd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 4ft | 5995155.47354 | 2106606.49729 | 37.764061618685 | -122.459955752961 | (37.764061618685, -122.459955752961) | 15 | 5 | 11 | 56 | 12 | |||
33159 | 67820 | Permitted Site 7 | Schinus terebinthifolius :: Brazilian Pepper 93 | 133 Vicksburg St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/17/1992 12:00:00 AM | Permit Number 31476 | 6004140.16165068 | 2102371.71829749 | 37.7529465572746 | -122.428578465138 | (37.7529465572746, -122.428578465138) | 2 | 4 | 5 | 28862 | 22 | ||
60627 | 240555 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 133 Vicksburg St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 5ft | 6004136.97088 | 2102299.45232 | 37.752747951271 | -122.428584348611 | (37.752747951271, -122.428584348611) | 2 | 4 | 5 | 28862 | 22 | |||
28691 | 10384 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 1330 Haight St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 70 | 3X3 | 5999747.97928 | 2108852.64514 | 37.7704920339747 | -122.44423309424 | (37.7704920339747, -122.44423309424) | 15 | 5 | 11 | 29492 | 9 | |||
175855 | 10385 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 1330 Haight St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 07/17/2017 12:00:00 AM | 24 | 3X3 | 5999759.298 | 2108827.6222 | 37.7704239730353 | -122.444192144461 | (37.7704239730353, -122.444192144461) | 15 | 5 | 11 | 29492 | 9 | ||
168629 | 214171 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 1337 06th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 2ft | 5994229.27069 | 2106420.50927 | 37.7634976322383 | -122.46314569683 | (37.7634976322383, -122.46314569683) | 1 | 5 | 11 | 56 | 12 | |||
34589 | 5333 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 135 Dolores St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 21 | 3X3 | 6004851.68413 | 2107592.33342 | 37.7673213724137 | -122.426489583844 | (37.7673213724137, -122.426489583844) | 8 | 4 | 5 | 28862 | 19 | |||
70797 | 239676 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 1356 Utah St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 3ft | 6010842.92295 | 2102014.50671 | 37.7523427770036 | -122.405373771977 | (37.7523427770036, -122.405373771977) | 10 | 4 | 8 | 28859 | 19 | |||
134565 | 114875 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 1362 Masonic Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/16/2015 12:00:00 AM | 3x3 | 5999587.7 | 2108019.3 | 37.7681947328922 | -122.444727590707 | (37.7681947328922, -122.444727590707) | 15 | 5 | 11 | 29492 | 9 | |||
169518 | 246203 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 1362 Masonic Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 0ft | 5999565.7884 | 2108011.1099 | 37.7681709945121 | -122.444802791675 | (37.7681709945121, -122.444802791675) | 15 | 5 | 11 | 29492 | 9 | |||
155923 | 214172 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 1370 12th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 19 | Width 4ft | 5992428.9422 | 2106122.35536 | 37.76257510589 | -122.469350698796 | (37.76257510589, -122.469350698796) | 1 | 8 | 11 | 56 | 12 | |||
28287 | 10404 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 1372 Haight St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 60 | 3X3 | 5999585.1964 | 2108804.377 | 37.7703502135529 | -122.444792689196 | (37.7703502135529, -122.444792689196) | 15 | 5 | 11 | 29492 | 9 | |||
60930 | 63546 | Permitted Site 7 | Schinus terebinthifolius :: Brazilian Pepper 93 | 1374 Fulton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/14/1994 12:00:00 AM | Permit Number 33370 | 6001184.87437591 | 2111109.12550893 | 37.7767696347038 | -122.439424651157 | (37.7767696347038, -122.439424651157) | 15 | 5 | 11 | 29492 | 41 | ||
85542 | 10223 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 1377X Guerrero St | 1 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 12 | 3X3 | 6005871.04446 | 2100967.56548 | 37.7491888788632 | -122.42249296967 | (37.7491888788632, -122.42249296967) | 2 | 4 | 5 | 28859 | 19 | |||
21269 | 197529 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 1399 18th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 4ft | 6013534.71133 | 2105671.72801 | 37.7625348459264 | -122.396321376134 | (37.7625348459264, -122.396321376134) | 14 | 3 | 8 | 28856 | 29 | |||
109902 | 62343 | Permitted Site 7 | Schinus terebinthifolius :: Brazilian Pepper 93 | 14 28th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/28/1985 12:00:00 AM | Permit Number 22485 | 6005822.8575705 | 2099672.01958419 | 37.7456288871148 | -122.422567552448 | (37.7456288871148, -122.422567552448) | 2 | 7 | 5 | 28859 | 22 | ||
29321 | 701 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 1401X Dolores St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 24 | 3X3 | 6005272.9475237 | 2100137.7446563 | 37.7468766226068 | -122.424502181659 | (37.7468766226068, -122.424502181659) | 2 | 7 | 5 | 28859 | 22 | |||
883 | 240584 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 141 Lower Ter | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 17 | Width 3ft | 6000210.52128 | 2106191.60222 | 37.7632118519771 | -122.442442087458 | (37.7632118519771, -122.442442087458) | 15 | 5 | 5 | 28862 | 3 | |||
79980 | 10424 | Permitted Site 7 | Schinus terebinthifolius :: Brazilian Pepper 93 | 1417 Haight St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 25 | 3x3 | 5999343.5805 | 2108720.18711 | 37.7701052580123 | -122.445622380313 | (37.7701052580123, -122.445622380313) | 15 | 5 | 11 | 29492 | 9 | |||
125228 | 245993 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 1419 Haight St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 0ft | 5999291.5767 | 2108712.9163 | 37.7700823250716 | -122.445801737198 | (37.7700823250716, -122.445801737198) | 15 | 5 | 11 | 29492 | 9 | |||
11016 | 53933 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 144 09th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/27/1972 12:00:00 AM | 17 | Permit Number 9647 | 5993062.86441 | 2114500.7791 | 37.7856166217584 | -122.467767599839 | (37.7856166217584, -122.467767599839) | 11 | 6 | 2 | 54 | 11 | ||
188526 | 106721 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 1445 Lyon St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3x3 | 5999673.9299 | 2113871.5922 | 37.7842685529811 | -122.444850062171 | (37.7842685529811, -122.444850062171) | 15 | 6 | 11 | 29490 | 31 | |||
11285 | 239736 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 1449 Noe St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 4ft | 6003357 | 2099848 | 37.7459726666437 | -122.431106669912 | (37.7459726666437, -122.431106669912) | 2 | 7 | 5 | 63 | 22 | |||
94623 | 239735 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 1449 Noe St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 4ft | 6003316.0935 | 2099809.08635 | 37.7458635007156 | -122.431245341826 | (37.7458635007156, -122.431245341826) | 2 | 7 | 5 | 63 | 22 | |||
102585 | 214200 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 145 Maywood Dr | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 2ft | 5994280.88933 | 2095617.06263 | 37.7338370774039 | -122.462183616499 | (37.7338370774039, -122.462183616499) | 9 | 8 | 4 | 59 | 40 | |||
117160 | 239707 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 1461 Shrader St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 4ft | 5997824.21441 | 2105678.04069 | 37.7616654362365 | -122.450658460926 | (37.7616654362365, -122.450658460926) | 15 | 5 | 11 | 29492 | 9 | |||
35143 | 10438 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 1474 Haight St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 40 | 3X3 | 5999064.8261 | 2108729.1491 | 37.770113946782 | -122.446587229644 | (37.770113946782, -122.446587229644) | 15 | 5 | 11 | 29492 | 9 | |||
23373 | 53934 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 148 09th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/15/1992 12:00:00 AM | 16 | Permit Number 30776 | 5993063.90435 | 2114472.77746 | 37.7855397969799 | -122.467761964704 | (37.7855397969799, -122.467761964704) | 11 | 6 | 2 | 54 | 11 | ||
185793 | 240521 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 149 Bemis St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 15 | Width 5ft | 6003423.1831 | 2096576.89641 | 37.7369947203295 | -122.430644439989 | (37.7369947203295, -122.430644439989) | 2 | 7 | 5 | 63 | 7 | |||
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 | ||||
186613 | 50160 | Permitted Site 7 | Schinus terebinthifolius :: Brazilian Pepper 93 | 150 15th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/02/2008 12:00:00 AM | 3x3 | Permit Number 50543 | 6011831.59667013 | 2107504.61941603 | 37.7674726364822 | -122.402340743885 | (37.7674726364822, -122.402340743885) | 8 | 2 | 8 | 28853 | 20 | ||
1613 | 112905 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 1500 Bancroft Ave | 1 | Front Yard : Yard | Tree | DPW 1 | 25 | 6014696 | 2091834 | 37.7246038778524 | -122.391337493735 | (37.7246038778524, -122.391337493735) | 10 | 3 | 8 | 58 | 1 | ||||
44049 | 26131 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 1500 Oakdale Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 12 | 3x3 | 6015558.456 | 2095125.3192 | 37.7336890117673 | -122.388585707606 | (37.7336890117673, -122.388585707606) | 10 | 3 | 8 | 58 | 1 |
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) );