trees
356 rows where qSpecies_id = 91 sorted by DBH 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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
13603 | 239638 | DPW Maintained 1 | Schinus molle :: California Pepper 91 | 3689 21st St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6003857.31467 | 2103604.80906 | 37.7563163226577 | -122.429644541356 | (37.7563163226577, -122.429644541356) | 2 | 4 | 5 | 28862 | 22 | |||
25942 | 197503 | DPW Maintained 1 | Schinus molle :: California Pepper 91 | 1799 25th St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 9 | Width 8ft | 6013488.947 | 2101929.32561 | 37.7522564753565 | -122.396217358746 | (37.7522564753565, -122.396217358746) | 10 | 3 | 8 | 28856 | 1 | |||
30132 | 62463 | DPW Maintained 1 | Schinus molle :: California Pepper 91 | 1906 McAllister St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/17/1985 12:00:00 AM | 9 | Permit Number 22631 | 5999997.0295 | 2111289.4853 | 37.7771971847485 | -122.443546707231 | (37.7771971847485, -122.443546707231) | 15 | 5 | 11 | 29490 | 16 | ||
34897 | 136370 | DPW Maintained 1 | Schinus molle :: California Pepper 91 | 2945 Scott St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 4ft | 6000983.74683 | 2118556.26599 | 37.7972061120278 | -122.440654703763 | (37.7972061120278, -122.440654703763) | 13 | 9 | 1 | 57 | 17 | |||
48994 | 249781 | DPW Maintained 1 | Schinus molle :: California Pepper 91 | 119 Pfeiffer St | 1 | Back Yard : Yard | Tree | Private 2 | 9 | Width 0ft | 6010443.51385 | 2121141.6092 | 37.8048389819848 | -122.408103813361 | (37.8048389819848, -122.408103813361) | 3 | 1 | 10 | 308 | 23 | |||
54411 | 214169 | DPW Maintained 1 | Schinus molle :: California Pepper 91 | 266 Joost Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6000318.85701 | 2094968.44865 | 37.7324019411004 | -122.441262082491 | (37.7324019411004, -122.441262082491) | 9 | 7 | 5 | 63 | 40 | |||
78868 | 239576 | DPW Maintained 1 | Schinus molle :: California Pepper 91 | 3971 26th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 2ft | 6004073.25036 | 2100697.787 | 37.7483465459652 | -122.428690539642 | (37.7483465459652, -122.428690539642) | 2 | 4 | 5 | 63 | 22 | |||
82801 | 239584 | DPW Maintained 1 | Schinus molle :: California Pepper 91 | 863 Clayton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 5998665.55754 | 2107188.82134 | 37.7658617826328 | -122.447857378524 | (37.7658617826328, -122.447857378524) | 15 | 5 | 11 | 29492 | 9 | |||
89962 | 239567 | DPW Maintained 1 | Schinus molle :: California Pepper 91 | 3435 26th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 5ft | 6006895.64188 | 2100851.73373 | 37.7489285791008 | -122.418941674643 | (37.7489285791008, -122.418941674643) | 2 | 4 | 7 | 28859 | 19 | |||
95974 | 239591 | DPW Maintained 1 | Schinus molle :: California Pepper 91 | 1436 Diamond St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6001977.64645 | 2099818.19455 | 37.7458125684911 | -122.435874148776 | (37.7458125684911, -122.435874148776) | 2 | 7 | 5 | 63 | 22 | |||
98928 | 136366 | DPW Maintained 1 | Schinus molle :: California Pepper 91 | 2323 Greenwich St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6001763.72183 | 2119055.52403 | 37.7986213292711 | -122.437991580064 | (37.7986213292711, -122.437991580064) | 13 | 9 | 1 | 57 | 17 | |||
102833 | 214157 | DPW Maintained 1 | Schinus molle :: California Pepper 91 | 100 Vista Verde Ct | 8 | Sidewalk: Curb side : Yard | Tree | Private 2 | 9 | Width 10ft | 5999199.91271 | 2096059.32177 | 37.7353334179866 | -122.445208921854 | (37.7353334179866, -122.445208921854) | 9 | 7 | 4 | 63 | 40 | |||
103494 | 239624 | DPW Maintained 1 | Schinus molle :: California Pepper 91 | 817 Castro St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6002470.85858 | 2103435.32507 | 37.7557723569304 | -122.434427263721 | (37.7557723569304, -122.434427263721) | 2 | 4 | 5 | 28862 | 22 | |||
114455 | 239593 | DPW Maintained 1 | Schinus molle :: California Pepper 91 | 636 Douglass St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 9 | Width 4ft | 6001191.36102 | 2102681.58859 | 37.7536300665832 | -122.438798157734 | (37.7536300665832, -122.438798157734) | 2 | 4 | 5 | 28862 | 22 | |||
116094 | 197488 | DPW Maintained 1 | Schinus molle :: California Pepper 91 | 1301 Minnesota St | 29 | Front Yard : Yard | Tree | Private 2 | 9 | 6015374.95978 | 2102473.44448 | 37.753855273025 | -122.389733174866 | (37.753855273025, -122.389733174866) | 10 | 3 | 8 | 28856 | 29 | ||||
120041 | 197495 | DPW Maintained 1 | Schinus molle :: California Pepper 91 | 651 Missouri St | 15 | Sidewalk: Property side : Yard | Tree | Private 2 | 9 | 6013600.82032 | 2103923.07952 | 37.757737117488 | -122.39597018278 | (37.757737117488, -122.39597018278) | 10 | 3 | 8 | 28856 | 29 | ||||
135825 | 239592 | DPW Maintained 1 | Schinus molle :: California Pepper 91 | 1643 Diamond St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 9 | Width 6ft | 6002072.60016 | 2099184.21674 | 37.7440772079026 | -122.435500467872 | (37.7440772079026, -122.435500467872) | 2 | 7 | 5 | 63 | 22 | |||
158509 | 136378 | DPW Maintained 1 | Schinus molle :: California Pepper 91 | 1 Nob Hill Pl | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 2ft | 6009539.87257 | 2116302.4428 | 37.7915011843851 | -122.410888982239 | (37.7915011843851, -122.410888982239) | 5 | 1 | 10 | 28857 | 21 | |||
158611 | 214152 | DPW Maintained 1 | Schinus molle :: California Pepper 91 | 1414 18th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 5ft | 5990551.39802 | 2105727.60563 | 37.7613825499841 | -122.47581554727 | (37.7613825499841, -122.47581554727) | 1 | 8 | 4 | 56 | 12 | |||
161220 | 244226 | DPW Maintained 1 | Schinus molle :: California Pepper 91 | 340 Steiner St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 0ft | 6003259.6765 | 2109534.4722 | 37.7725638844758 | -122.432134818626 | (37.7725638844758, -122.432134818626) | 15 | 9 | 11 | 29492 | 10 | |||
175035 | 239590 | DPW Maintained 1 | Schinus molle :: California Pepper 91 | 732 Duncan St | 1 | Sidewalk: Curb side : Pot | Tree | Private 2 | 9 | Width 10ft | 6001765.51317 | 2099741.92053 | 37.745591085263 | -122.436602215635 | (37.745591085263, -122.436602215635) | 2 | 7 | 5 | 63 | 22 | |||
179689 | 239646 | DPW Maintained 1 | Schinus molle :: California Pepper 91 | 211 Cumberland St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6004207.2629 | 2104504.88213 | 37.7588075193625 | -122.428498452559 | (37.7588075193625, -122.428498452559) | 2 | 4 | 5 | 28862 | 3 | |||
188324 | 197498 | DPW Maintained 1 | Schinus molle :: California Pepper 91 | 651 Missouri St | 22 | Sidewalk: Property side : Yard | Tree | Private 2 | 9 | 6013596.26371 | 2103973.99117 | 37.757876656309 | -122.395989509211 | (37.757876656309, -122.395989509211) | 10 | 3 | 8 | 28856 | 29 | ||||
17498 | 49624 | DPW Maintained 1 | Schinus molle :: California Pepper 91 | 180 11th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/13/2003 12:00:00 AM | 8 | Permit Number 46480 | 6007909.99126 | 2109730.21129 | 37.7733638956484 | -122.416062720842 | (37.7733638956484, -122.416062720842) | 8 | 2 | 9 | 28853 | 19 | |
20260 | 197489 | DPW Maintained 1 | Schinus molle :: California Pepper 91 | 1301 Minnesota St | 42 | Front Yard : Yard | Tree | Private 2 | 8 | 6015361.30396 | 2102471.04633 | 37.753847930956 | -122.389780232768 | (37.753847930956, -122.389780232768) | 10 | 3 | 8 | 28856 | 29 | ||||
36697 | 33682 | DPW Maintained 1 | Schinus molle :: California Pepper 91 | 417 Ivy St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/03/1996 12:00:00 AM | 8 | Permit Number 37761 | 6005332.3776 | 2111131.0936 | 37.7770651154691 | -122.425078750067 | (37.7770651154691, -122.425078750067) | 7 | 9 | 11 | 28852 | 10 | ||
37249 | 35756 | DPW Maintained 1 | Schinus molle :: California Pepper 91 | 6838 Geary Blvd | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/20/1998 12:00:00 AM | 8 | Permit Number 39022 | 5985797.58958 | 2112563.51135 | 37.7798752557854 | -122.492760252761 | (37.7798752557854, -122.492760252761) | 11 | 6 | 2 | 55 | 26 | ||
59190 | 183549 | DPW Maintained 1 | Schinus molle :: California Pepper 91 | 2593 23rd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 0ft | 5989226.3762 | 2097721.7265 | 37.7393236152619 | -122.479812344828 | (37.7393236152619, -122.479812344828) | 1 | 8 | 3 | 29491 | 35 | |||
104997 | 245452 | DPW Maintained 1 | Schinus molle :: California Pepper 91 | 2700 16th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 0ft | 6008618.5823 | 2106848.9813 | 37.7654925250272 | -122.413407794567 | (37.7654925250272, -122.413407794567) | 8 | 4 | 7 | 28853 | 19 | |||
115611 | 214163 | DPW Maintained 1 | Schinus molle :: California Pepper 91 | 274 Tara St | 1 | : | Tree | Private 2 | 8 | Width 3ft | 5997748.47431 | 2090294.62139 | 37.7194219549502 | -122.449811751014 | (37.7194219549502, -122.449811751014) | 9 | 8 | 6 | 28861 | 24 | |||
131504 | 68701 | DPW Maintained 1 | Schinus molle :: California Pepper 91 | 174 Funston Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/02/1993 12:00:00 AM | 8 | Permit Number 32613 | 5991836.39041 | 2114296.24984 | 37.7849841461432 | -122.471995891724 | (37.7849841461432, -122.471995891724) | 11 | 6 | 2 | 54 | 11 | ||
139465 | 247659 | DPW Maintained 1 | Schinus molle :: California Pepper 91 | 129 Divisadero St | 2 | : | Tree | Private 2 | 8 | Width 3ft | 6001899.88473 | 2108418.65056 | 37.7694229261437 | -122.436758580761 | (37.7694229261437, -122.436758580761) | 15 | 5 | 5 | 29492 | 9 | |||
146935 | 239586 | DPW Maintained 1 | Schinus molle :: California Pepper 91 | 103 Winfield St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 2ft | 6007116.95324 | 2098786.33455 | 37.743269917082 | -122.418029977927 | (37.743269917082, -122.418029977927) | 2 | 7 | 7 | 28859 | 2 | |||
148920 | 69361 | DPW Maintained 1 | Schinus molle :: California Pepper 91 | 3518 Webster St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/18/1994 12:00:00 AM | 8 | Permit Number 33455 | 6002672.47282 | 2120707.16348 | 37.8032079355658 | -122.4349652022 | (37.8032079355658, -122.4349652022) | 13 | 9 | 1 | 57 | 17 | |
169751 | 249770 | DPW Maintained 1 | Schinus molle :: California Pepper 91 | 102 Pfeiffer St | 1 | Side Yard : Yard | Tree | Private 2 | 8 | Width 0ft | 6010494.56062 | 2121168.81632 | 37.8049165440205 | -122.407929079557 | (37.8049165440205, -122.407929079557) | 3 | 1 | 10 | 308 | 23 | |||
181076 | 197484 | DPW Maintained 1 | Schinus molle :: California Pepper 91 | 99 Lafayette St | 3 | : | Tree | Private 2 | 8 | Width 3ft | 6007489.31465 | 2109652.98843 | 37.7731281986314 | -122.417512429769 | (37.7731281986314, -122.417512429769) | 8 | 2 | 9 | 28853 | 19 | |||
193261 | 247657 | DPW Maintained 1 | Schinus molle :: California Pepper 91 | 165 Divisadero St | 1 | : | Tree | Private 2 | 8 | Width 3ft | 6001871.68544 | 2108600.41157 | 37.7699203942357 | -122.436869134409 | (37.7699203942357, -122.436869134409) | 15 | 5 | 5 | 29492 | 9 | |||
23040 | 239637 | DPW Maintained 1 | Schinus molle :: California Pepper 91 | 3691 21st St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6003808.38299 | 2103603.27195 | 37.7563093313217 | -122.429813654389 | (37.7563093313217, -122.429813654389) | 2 | 4 | 5 | 28862 | 22 | |||
32012 | 35755 | DPW Maintained 1 | Schinus molle :: California Pepper 91 | 6838 Geary Blvd | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/20/1998 12:00:00 AM | 7 | Permit Number 39022 | 5985827.97682 | 2112563.40957 | 37.7798767531698 | -122.49265512383 | (37.7798767531698, -122.49265512383) | 11 | 6 | 2 | 55 | 26 | ||
47859 | 239656 | DPW Maintained 1 | Schinus molle :: California Pepper 91 | 701 Church St | 39 | Front Yard : Yard | Tree | Private 2 | 7 | Width 3ft | 6004336.93411 | 2104791.99581 | 37.759603202641 | -122.428070449907 | (37.759603202641, -122.428070449907) | 2 | 4 | 5 | 28862 | 3 | |||
60322 | 49747 | DPW Maintained 1 | Schinus molle :: California Pepper 91 | 1266 Brussels St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/04/2003 12:00:00 AM | 7 | Permit Number 46546 | 6011753.83246 | 2088984.50512 | 37.7166160162035 | -122.401308097113 | (37.7166160162035, -122.401308097113) | 10 | 7 | 8 | 309 | 39 | |
65868 | 197492 | DPW Maintained 1 | Schinus molle :: California Pepper 91 | 1501 25th St | 20 | Sidewalk: Curb side : Yard | Tree | Private 2 | 7 | 6014180.0421 | 2101964.05724 | 37.7523902711102 | -122.393829855665 | (37.7523902711102, -122.393829855665) | 10 | 3 | 8 | 28856 | 1 | ||||
71330 | 42296 | Permitted Site 7 | Schinus molle :: California Pepper 91 | 250 Detroit St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/23/2000 12:00:00 AM | 7 | 4x5 | Permit Number 42524 | 5999448.10009127 | 2093930.90110115 | 37.7295034375942 | -122.444197952384 | (37.7295034375942, -122.444197952384) | 9 | 7 | 4 | 63 | 40 |
74800 | 214156 | DPW Maintained 1 | Schinus molle :: California Pepper 91 | 495 Pacheco St | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 7 | Width 6ft | 5993555.55486 | 2101853.98601 | 37.7509203085364 | -122.465144146879 | (37.7509203085364, -122.465144146879) | 1 | 8 | 4 | 29491 | 40 | |||
90218 | 197483 | DPW Maintained 1 | Schinus molle :: California Pepper 91 | 99 Lafayette St | 2 | : | Tree | Private 2 | 7 | Width 3ft | 6007475.11808 | 2109661.30518 | 37.7731502356402 | -122.417562127216 | (37.7731502356402, -122.417562127216) | 8 | 2 | 9 | 28853 | 19 | |||
95494 | 136372 | DPW Maintained 1 | Schinus molle :: California Pepper 91 | 2005 Lyon St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 4ft | 5999418.04323 | 2115732.63691 | 37.7893638888782 | -122.445869229291 | (37.7893638888782, -122.445869229291) | 13 | 6 | 1 | 29490 | 31 | |||
97929 | 217735 | DPW Maintained 1 | Schinus molle :: California Pepper 91 | 723 Frederick St | 1 | : | Tree | Private 2 | 7 | Width 3ft | 5996116.65034 | 2107229.99676 | 37.7658288206775 | -122.456676438985 | (37.7658288206775, -122.456676438985) | 15 | 5 | 11 | 29492 | 12 | |||
117755 | 35754 | DPW Maintained 1 | Schinus molle :: California Pepper 91 | 6838 Geary Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/20/1998 12:00:00 AM | 7 | Permit Number 39022 | 5985859.7786 | 2112565.45862 | 37.7798842387291 | -122.492545259885 | (37.7798842387291, -122.492545259885) | 11 | 6 | 2 | 55 | 26 | ||
119469 | 214167 | DPW Maintained 1 | Schinus molle :: California Pepper 91 | 1911 09th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 5993435.67173 | 2102452.28847 | 37.7525561798324 | -122.465602172524 | (37.7525561798324, -122.465602172524) | 1 | 8 | 4 | 29491 | 12 | |||
140313 | 197502 | DPW Maintained 1 | Schinus molle :: California Pepper 91 | 1799 25th St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 7 | Width 8ft | 6013459.53083 | 2101928.68892 | 37.752253090306 | -122.396319040597 | (37.752253090306, -122.396319040597) | 10 | 3 | 8 | 28856 | 1 | |||
141927 | 197501 | DPW Maintained 1 | Schinus molle :: California Pepper 91 | 1101 Connecticut St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 7 | Width 8ft | 6013434.27998 | 2101904.95506 | 37.752186517095 | -122.396404699215 | (37.752186517095, -122.396404699215) | 10 | 3 | 8 | 28856 | 1 | |||
189202 | 239636 | DPW Maintained 1 | Schinus molle :: California Pepper 91 | 3691 21st St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6003794.28038 | 2103601.33494 | 37.7563032141343 | -122.429862287926 | (37.7563032141343, -122.429862287926) | 2 | 4 | 5 | 28862 | 22 | |||
8068 | 32395 | DPW Maintained 1 | Schinus molle :: California Pepper 91 | 222 Richland Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/03/1996 12:00:00 AM | 6 | 8x6 | Permit Number 36936 | 6005810.68419 | 2096104.55108 | 37.735832735077 | -122.42235621788 | (37.735832735077, -122.42235621788) | 2 | 7 | 7 | 28859 | 2 |
20349 | 124365 | DPW Maintained 1 | Schinus molle :: California Pepper 91 | 69 Palm Ave | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | Width 2ft | 5995847.94198 | 2114000.61223 | 37.7844037185844 | -122.458095888318 | (37.7844037185844, -122.458095888318) | 11 | 6 | 1 | 54 | 31 | |||
36540 | 49625 | DPW Maintained 1 | Schinus molle :: California Pepper 91 | 180 11th St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/13/2003 12:00:00 AM | 6 | Permit Number 768701 | 6007969.67353 | 2109667.22612 | 37.773194308705 | -122.415851810006 | (37.773194308705, -122.415851810006) | 8 | 2 | 9 | 28853 | 19 | ||
46065 | 136368 | DPW Maintained 1 | Schinus molle :: California Pepper 91 | 2945 Scott St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 4ft | 6000986.41607 | 2118529.18744 | 37.797131913463 | -122.440643524276 | (37.797131913463, -122.440643524276) | 13 | 9 | 1 | 57 | 17 | |||
52524 | 136373 | DPW Maintained 1 | Schinus molle :: California Pepper 91 | 2858 Vallejo St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 4ft | 5999883.33678 | 2117451.31751 | 37.7941094908262 | -122.444382936819 | (37.7941094908262, -122.444382936819) | 13 | 9 | 1 | 57 | 27 | |||
89326 | 239635 | DPW Maintained 1 | Schinus molle :: California Pepper 91 | 3691 21st St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6003778.26076 | 2103599.43748 | 37.7562970969591 | -122.429917553956 | (37.7562970969591, -122.429917553956) | 2 | 4 | 5 | 28862 | 22 | |||
112280 | 239644 | DPW Maintained 1 | Schinus molle :: California Pepper 91 | 4 Ford St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6003494.59862 | 2105679.78343 | 37.7619931617634 | -122.431047029612 | (37.7619931617634, -122.431047029612) | 15 | 4 | 5 | 28862 | 3 | |||
60629 | 106612 | Significant Tree 6 | Schinus molle :: California Pepper 91 | 1189 TENNESSEE ST | Front Yard : Yard | Tree | Private 2 | 55 | 6015654.1 | 2103577.3 | 37.7569017014681 | -122.388844893024 | (37.7569017014681, -122.388844893024) | 10 | 3 | 8 | 28856 | 29 | |||||
59453 | 49620 | DPW Maintained 1 | Schinus molle :: California Pepper 91 | 180 11th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/30/2008 12:00:00 AM | 5 | 3x3 | Permit Number 768701 | 6007925.38179 | 2109711.75094 | 37.7733140732115 | -122.416008175135 | (37.7733140732115, -122.416008175135) | 8 | 2 | 9 | 28853 | 19 |
62623 | 239602 | DPW Maintained 1 | Schinus molle :: California Pepper 91 | 890 Castro St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 5 | Width 4ft | 6002438.31508 | 2103064.33818 | 37.7547518683248 | -122.434513284763 | (37.7547518683248, -122.434513284763) | 2 | 4 | 5 | 28862 | 22 | |||
62891 | 214155 | DPW Maintained 1 | Schinus molle :: California Pepper 91 | 495 Pacheco St | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 5 | Width 6ft | 5993543.01566 | 2101855.50119 | 37.7509237457529 | -122.46518761832 | (37.7509237457529, -122.46518761832) | 1 | 8 | 4 | 29491 | 40 | |||
73636 | 136377 | DPW Maintained 1 | Schinus molle :: California Pepper 91 | 633 Taylor St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 4ft | 6009222.09013 | 2115205.65792 | 37.7884718549403 | -122.41191097002 | (37.7884718549403, -122.41191097002) | 5 | 1 | 10 | 28852 | 21 | |||
87375 | 187555 | DPW Maintained 1 | Schinus molle :: California Pepper 91 | 3960 Somerset St | 2 | Side Yard : Yard | Tree | Private 2 | 5 | 6011363.78669 | 2088352.31881 | 37.714858391064 | -122.402611866762 | (37.714858391064, -122.402611866762) | 10 | 7 | 8 | 309 | 39 | ||||
95933 | 217745 | DPW Maintained 1 | Schinus molle :: California Pepper 91 | 641 Frederick St | 2 | : | Tree | Private 2 | 5 | Width 3ft | 5996420.96236 | 2107271.42438 | 37.7659600380538 | -122.45562688879 | (37.7659600380538, -122.45562688879) | 15 | 5 | 11 | 29492 | 12 | |||
98337 | 239657 | DPW Maintained 1 | Schinus molle :: California Pepper 91 | 671 Church St | 4 | Front Yard : Yard | Tree | Private 2 | 5 | Width 3ft | 6004329.6886 | 2104859.6882 | 37.7597886599416 | -122.428100332557 | (37.7597886599416, -122.428100332557) | 2 | 4 | 5 | 28862 | 3 | |||
108016 | 239647 | DPW Maintained 1 | Schinus molle :: California Pepper 91 | 211 Cumberland St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6004225.35965 | 2104505.85925 | 37.7588112263749 | -122.428435935269 | (37.7588112263749, -122.428435935269) | 2 | 4 | 5 | 28862 | 3 | |||
164670 | 217740 | DPW Maintained 1 | Schinus molle :: California Pepper 91 | 689 Frederick St | 1 | : | Tree | Private 2 | 5 | Width 3ft | 5996243.38999 | 2107249.52604 | 37.7658897191639 | -122.456239488074 | (37.7658897191639, -122.456239488074) | 15 | 5 | 11 | 29492 | 12 | |||
176676 | 214164 | DPW Maintained 1 | Schinus molle :: California Pepper 91 | 900 Junipero Serra Blvd | 99 | : | Tree | Private 2 | 5 | Width 0ft | 5991142.14923 | 2090504.71444 | 37.7196186222819 | -122.47266246032 | (37.7196186222819, -122.47266246032) | 9 | 8 | 4 | 64 | 40 | |||
179865 | 214168 | DPW Maintained 1 | Schinus molle :: California Pepper 91 | 250 Maywood Dr | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 5994367.37708 | 2095058.85535 | 37.7323093567717 | -122.46184414221 | (37.7323093567717, -122.46184414221) | 9 | 8 | 4 | 59 | 40 | |||
888 | 246022 | DPW Maintained 1 | Schinus molle :: California Pepper 91 | 625 Ashbury St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 0ft | 5998964.2184 | 2108548.4801 | 37.769612128289 | -122.446922226392 | (37.769612128289, -122.446922226392) | 15 | 5 | 11 | 29492 | 9 | |||
6990 | 97154 | Section 806 (d) 5 | Schinus molle :: California Pepper 91 | 1079 Le Conte Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/25/2011 12:00:00 AM | 4 | Permit Number 768080 | 6012676.26956 | 2089874.1029 | 37.7191100952408 | -122.398182049174 | (37.7191100952408, -122.398182049174) | 10 | 3 | 8 | 58 | 1 | ||
11956 | 72875 | DPW Maintained 1 | Schinus molle :: California Pepper 91 | 2506 23rd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 4 | 5989254.9412 | 2098243.205 | 37.7407571191622 | -122.47975172868 | (37.7407571191622, -122.47975172868) | 1 | 8 | 3 | 29491 | 35 | |||
59784 | 45068 | DPW Maintained 1 | Schinus molle :: California Pepper 91 | 2227 27th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/08/2001 12:00:00 AM | 4 | Permit Number 43949 | 5987902.9352 | 2100130.6194 | 37.7458608246267 | -122.4845648054 | (37.7458608246267, -122.4845648054) | 1 | 8 | 3 | 29491 | 35 | |
76751 | 49937 | DPW Maintained 1 | Schinus molle :: California Pepper 91 | 2591 26th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/02/2003 12:00:00 AM | 4 | Permit Number 46696 | 5988296.2269 | 2097703.198 | 37.7392186595719 | -122.483026991295 | (37.7392186595719, -122.483026991295) | 1 | 8 | 3 | 29491 | 35 | |
77871 | 214162 | DPW Maintained 1 | Schinus molle :: California Pepper 91 | 56 Miramar Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 5995350.86908 | 2090273.63849 | 37.7192268694992 | -122.458097813856 | (37.7192268694992, -122.458097813856) | 9 | 8 | 6 | 28861 | 24 | |||
83952 | 109126 | Private 9 | Schinus molle :: California Pepper 91 | 890x CASTRO ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | 3x3 | 6002411 | 2103002 | 37.7545791519678 | -122.434603290485 | (37.7545791519678, -122.434603290485) | 2 | 4 | 5 | 28862 | 22 | |||
101688 | 50158 | DPW Maintained 1 | Schinus molle :: California Pepper 91 | 1863@ ORTEGA 33rd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/07/2003 12:00:00 AM | 4 | Permit Number 46871 | 5985958.4054 | 2102559.7986 | 37.7524172606528 | -122.491467392102 | (37.7524172606528, -122.491467392102) | 1 | 8 | 3 | 56 | 35 | ||
146750 | 239581 | DPW Maintained 1 | Schinus molle :: California Pepper 91 | 3537 21st St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6004768.88841 | 2103660.24792 | 37.756520118925 | -122.426495949253 | (37.756520118925, -122.426495949253) | 2 | 4 | 5 | 28862 | 22 | |||
161884 | 214154 | DPW Maintained 1 | Schinus molle :: California Pepper 91 | 495 Pacheco St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 4 | Width 6ft | 5993534.5206 | 2101855.05369 | 37.750922027151 | -122.46521696231 | (37.750922027151, -122.46521696231) | 1 | 8 | 4 | 29491 | 40 | |||
5132 | 239574 | DPW Maintained 1 | Schinus molle :: California Pepper 91 | 322 28th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 37 | 12x9 | 6003766 | 2099569 | 37.7452297653441 | -122.429672508032 | (37.7452297653441, -122.429672508032) | 2 | 7 | 5 | 63 | 22 | |||
15530 | 239630 | DPW Maintained 1 | Schinus molle :: California Pepper 91 | 431 Alvarado St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 37 | Width 3ft | 6003562.89343 | 2102710.70444 | 37.7538446475336 | -122.430598954102 | (37.7538446475336, -122.430598954102) | 2 | 4 | 5 | 28862 | 22 | |||
77030 | 239621 | DPW Maintained 1 | Schinus molle :: California Pepper 91 | 489 Diamond St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 37 | Width 3ft | 6001854.41167 | 2103000.82295 | 37.7545443074853 | -122.436528033262 | (37.7545443074853, -122.436528033262) | 2 | 4 | 5 | 28862 | 22 | |||
40288 | 239571 | DPW Maintained 1 | Schinus molle :: California Pepper 91 | 254 Day St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 33 | Width 3ft | 6004273.21361 | 2098704.8278 | 37.742885654747 | -122.427857083959 | (37.742885654747, -122.427857083959) | 2 | 7 | 5 | 63 | 22 | |||
33743 | 5505 | DPW Maintained 1 | Schinus molle :: California Pepper 91 | 785 Dolores St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 30 | 6X8 | 6005062.26258 | 2103781.17825 | 37.756868745618 | -122.425489962193 | (37.756868745618, -122.425489962193) | 2 | 4 | 5 | 28859 | 19 | |||
2766 | 247224 | DPW Maintained 1 | Schinus molle :: California Pepper 91 | 135 Divisadero St | 1 | : | Tree | Private 2 | 08/07/2019 12:00:00 AM | 3 | Width 3ft | 6001887.60725 | 2108459.11842 | 37.7695333431173 | -122.436803945272 | (37.7695333431173, -122.436803945272) | 15 | 5 | 5 | 29492 | 9 | ||
6293 | 97158 | Section 806 (d) 5 | Schinus molle :: California Pepper 91 | 1079 Le Conte Ave | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/25/2011 12:00:00 AM | 3 | Permit Number 768080 | 6012744.23117 | 2089823.98249 | 37.7189762599209 | -122.397943616401 | (37.7189762599209, -122.397943616401) | 10 | 3 | 8 | 58 | 1 | ||
11330 | 166753 | Planning Code 138.1 required 2 | Schinus molle :: California Pepper 91 | 350 Jersey St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/26/2019 12:00:00 AM | 3 | 4x4 | Permit Number 781737 | 6002856.72425 | 2101550.76622 | 37.7506197011549 | -122.43295818429 | (37.7506197011549, -122.43295818429) | 2 | 4 | 5 | 28862 | 22 | |
12625 | 97159 | Section 806 (d) 5 | Schinus molle :: California Pepper 91 | 1079 Le Conte Ave | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/25/2011 12:00:00 AM | 3 | Permit Number 768080 | 6012757.60574 | 2089814.3813 | 37.7189506418481 | -122.397896712286 | (37.7189506418481, -122.397896712286) | 10 | 3 | 8 | 58 | 1 | ||
12626 | 97156 | Section 806 (d) 5 | Schinus molle :: California Pepper 91 | 1079 Le Conte Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/25/2011 12:00:00 AM | 3 | Permit Number 768080 | 6012721.62132 | 2089840.20593 | 37.7190195469812 | -122.398022907844 | (37.7190195469812, -122.398022907844) | 10 | 3 | 8 | 58 | 1 | ||
13181 | 239606 | DPW Maintained 1 | Schinus molle :: California Pepper 91 | 179 Carl St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 5997457.76068 | 2107065.24918 | 37.7654533761877 | -122.452025957451 | (37.7654533761877, -122.452025957451) | 15 | 5 | 11 | 29492 | 9 | |||
16158 | 19973 | DPW Maintained 1 | Schinus molle :: California Pepper 91 | 100 STAIRWAY44 | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3 | 36 | |||||||||||||
18196 | 54018 | DPW Maintained 1 | Schinus molle :: California Pepper 91 | 850 35th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/28/2020 12:00:00 AM | 3 | 3x3 | Permit Number 785014 | 5985129.09281 | 2110070.96029 | 37.7729923119367 | -122.494889012959 | (37.7729923119367, -122.494889012959) | 11 | 6 | 2 | 55 | 26 | |
18353 | 97155 | Section 806 (d) 5 | Schinus molle :: California Pepper 91 | 1079 Le Conte Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/25/2011 12:00:00 AM | 3 | Permit Number 768080 | 6012703.24235 | 2089857.95173 | 37.7190672497343 | -122.398087681509 | (37.7190672497343, -122.398087681509) | 10 | 3 | 8 | 58 | 1 | ||
36387 | 251333 | DPW Maintained 1 | Schinus molle :: California Pepper 91 | 1245 South Van Ness Ave | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/08/2017 12:00:00 AM | 3 | 3x3 | Permit Number 779528 | 6007705.96721 | 2102462.31706 | 37.7533964721949 | -122.416253615419 | (37.7533964721949, -122.416253615419) | 2 | 4 | 7 | 28859 | 19 | |
40104 | 156622 | DPW Maintained 1 | Schinus molle :: California Pepper 91 | 1245 South Van Ness Ave | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/08/2017 12:00:00 AM | 3 | 3x3 | Permit Number 779528 | 6007708.67537 | 2102405.47581 | 37.7532405513196 | -122.416240224501 | (37.7532405513196, -122.416240224501) | 2 | 4 | 7 | 28859 | 19 | |
61318 | 136374 | DPW Maintained 1 | Schinus molle :: California Pepper 91 | 2858 Vallejo St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 4ft | 5999876.11536 | 2117451.30478 | 37.7941090438496 | -122.444407922699 | (37.7941090438496, -122.444407922699) | 13 | 9 | 1 | 57 | 27 | |||
63400 | 242003 | DPW Maintained 1 | Schinus molle :: California Pepper 91 | 920 Shotwell St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/08/2017 12:00:00 AM | 3 | 3x3 | Permit Number 779528 | 6007974.01021 | 2102435.99237 | 37.7533392591026 | -122.415324800104 | (37.7533392591026, -122.415324800104) | 2 | 4 | 7 | 28859 | 19 | |
91095 | 197506 | DPW Maintained 1 | Schinus molle :: California Pepper 91 | 1079 Le Conte Ave | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 4ft | 6012767.16405 | 2089807.75284 | 37.7189329737454 | -122.397863208018 | (37.7189329737454, -122.397863208018) | 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) );