trees
356 rows where qSpecies_id = 91 sorted by Location 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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | |||
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 | |||
132367 | 69363 | DPW Maintained 1 | Schinus molle :: California Pepper 91 | 3524 Webster St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/18/1994 12:00:00 AM | 12 | Permit Number 33457 | 6002667.84891 | 2120741.39075 | 37.8033016521051 | -122.434983652687 | (37.8033016521051, -122.434983652687) | 13 | 9 | 1 | 57 | 17 | |
136874 | 136371 | DPW Maintained 1 | Schinus molle :: California Pepper 91 | 3518 Webster St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 6002669.28578 | 2120724.92735 | 37.8032565295236 | -122.434977502225 | (37.8032565295236, -122.434977502225) | 13 | 9 | 1 | 57 | 17 | |||
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 | |
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 | |||
187275 | 136365 | DPW Maintained 1 | Schinus molle :: California Pepper 91 | 2624 Greenwich St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 19 | Width 3ft | 6000330.31034 | 2118901.65056 | 37.7981172142989 | -122.442940566381 | (37.7981172142989, -122.442940566381) | 13 | 9 | 1 | 57 | 17 | |||
23970 | 136382 | DPW Maintained 1 | Schinus molle :: California Pepper 91 | 1015 Vallejo St | 1 | Front Yard : Yard | Tree | Private 2 | 14 | 6008613.87178 | 2118642.82165 | 37.7978753218528 | -122.414258600758 | (37.7978753218528, -122.414258600758) | 5 | 1 | 10 | 308 | 21 | ||||
31200 | 53044 | DPW Maintained 1 | Schinus molle :: California Pepper 91 | 2945 Scott St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/10/2006 12:00:00 AM | 11 | 3x3 | Permit Number 49022 | 6000981.43692 | 2118569.50402 | 37.797242328631 | -122.440663646636 | (37.797242328631, -122.440663646636) | 13 | 9 | 1 | 57 | 17 | |
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 | |||
107727 | 136369 | DPW Maintained 1 | Schinus molle :: California Pepper 91 | 2945 Scott St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 4ft | 6000984.79842 | 2118544.66291 | 37.7971743129098 | -122.440650232318 | (37.7971743129098, -122.440650232318) | 13 | 9 | 1 | 57 | 17 | |||
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 | |||
3391 | 122720 | DPW Maintained 1 | Schinus molle :: California Pepper 91 | 1023 Broadway | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6008692.81337 | 2118287.13673 | 37.796903132994 | -122.413960264957 | (37.796903132994, -122.413960264957) | 5 | 1 | 10 | 308 | 21 | ||||
40901 | 122721 | DPW Maintained 1 | Schinus molle :: California Pepper 91 | 1023 Broadway | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6008692.81337 | 2118287.13673 | 37.796903132994 | -122.413960264957 | (37.796903132994, -122.413960264957) | 5 | 1 | 10 | 308 | 21 | ||||
81419 | 136381 | DPW Maintained 1 | Schinus molle :: California Pepper 91 | 1023 Broadway | 2 | Sidewalk: Curb side : Pot | Tree | Private 2 | 15 | Width 3ft | 6008695.6423 | 2118278.07408 | 37.7968784080765 | -122.413949834731 | (37.7968784080765, -122.413949834731) | 5 | 1 | 10 | 308 | 21 | |||
141132 | 136380 | DPW Maintained 1 | Schinus molle :: California Pepper 91 | 1023 Broadway | 1 | Sidewalk: Curb side : Pot | Tree | Private 2 | 12 | Width 3ft | 6008680.39017 | 2118276.96424 | 37.7968745041214 | -122.414002532311 | (37.7968745041214, -122.414002532311) | 5 | 1 | 10 | 308 | 21 | |||
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 | |||
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 | |||
133494 | 136375 | DPW Maintained 1 | Schinus molle :: California Pepper 91 | 2880 Vallejo St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 21 | Width 4ft | 5999802.94718 | 2117441.8408 | 37.7940788832989 | -122.44466041095 | (37.7940788832989, -122.44466041095) | 13 | 9 | 1 | 57 | 27 | |||
43385 | 136376 | DPW Maintained 1 | Schinus molle :: California Pepper 91 | 2880 Vallejo St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 25 | Width 4ft | 5999781.6675 | 2117438.62155 | 37.7940688297731 | -122.444733809114 | (37.7940688297731, -122.444733809114) | 13 | 9 | 1 | 57 | 27 | |||
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 | |||
153086 | 136379 | DPW Maintained 1 | Schinus molle :: California Pepper 91 | 1 Nob Hill Pl | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 1ft | 6009499.81555 | 2116296.95751 | 37.7914838769232 | -122.411027191854 | (37.7914838769232, -122.411027191854) | 5 | 1 | 10 | 28857 | 21 | |||
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 | |||
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 | |||
130978 | 20249 | DPW Maintained 1 | Schinus molle :: California Pepper 91 | 1880 Steiner St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 05/16/2000 12:00:00 AM | 10 | 3X3 | 6002546.9119 | 2114591.5393 | 37.7864088846335 | -122.43496207541 | (37.7864088846335, -122.43496207541) | 13 | 9 | 11 | 29490 | 27 | ||
109460 | 122117 | DPW Maintained 1 | Schinus molle :: California Pepper 91 | 141 16th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 5990819.37104 | 2114444.89613 | 37.7853333844834 | -122.475525275427 | (37.7853333844834, -122.475525275427) | 11 | 6 | 2 | 54 | 26 | |||
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 | ||
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 | |||
57476 | 55227 | DPW Maintained 1 | Schinus molle :: California Pepper 91 | 211 23rd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/12/1972 12:00:00 AM | 13 | Permit Number 11145 | 5988668.09914 | 2113889.94192 | 37.7836846949952 | -122.48292724876 | (37.7836846949952, -122.48292724876) | 11 | 6 | 2 | 55 | 26 | ||
26202 | 32764 | Permitted Site 7 | Schinus molle :: California Pepper 91 | 274 02nd Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/29/1996 12:00:00 AM | Permit Number 37139 | 5995268.23997636 | 2113729.87048347 | 37.7836270090334 | -122.460081822154 | (37.7836270090334, -122.460081822154) | 11 | 6 | 2 | 54 | 11 | |||
159315 | 32765 | Permitted Site 7 | Schinus molle :: California Pepper 91 | 274 02nd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/29/1996 12:00:00 AM | Permit Number 37139 | 5995268.23997636 | 2113729.87048347 | 37.7836270090334 | -122.460081822154 | (37.7836270090334, -122.460081822154) | 11 | 6 | 2 | 54 | 11 | |||
44107 | 111384 | DPW Maintained 1 | Schinus molle :: California Pepper 91 | 340 Brannan St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 21 | 3x5 | 6014593.21542 | 2112428.75748 | 37.7811469919725 | -122.393133189548 | (37.7811469919725, -122.393133189548) | 6 | 2 | 9 | 28856 | 6 | |||
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 | ||
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 | ||
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 | ||
176454 | 103991 | DPW Maintained 1 | Schinus molle :: California Pepper 91 | 490 12th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | 6X9 | 5992225.21796 | 2112091.38371 | 37.7789526802379 | -122.470490047579 | (37.7789526802379, -122.470490047579) | 11 | 6 | 2 | 54 | 11 | |||
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 | ||
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 | ||
32623 | 138856 | DPW Maintained 1 | Schinus molle :: California Pepper 91 | 601 LAGUNA ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 20 | Width 0ft | 6004940.3956 | 2111052.9695 | 37.7768284552741 | -122.426429175067 | (37.7768284552741, -122.426429175067) | 7 | 9 | 11 | 28852 | 10 | |||
104806 | 12260 | DPW Maintained 1 | Schinus molle :: California Pepper 91 | 611 LAGUNA ST | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 21 | 3X3 | 6004921 | 2111005 | 37.7766956463335 | -122.426492853872 | (37.7766956463335, -122.426492853872) | 7 | 9 | 11 | 28852 | 10 | |||
113901 | 12257 | DPW Maintained 1 | Schinus molle :: California Pepper 91 | 601 Laguna St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6004946.44345 | 2111002.77203 | 37.7766909671748 | -122.426404678747 | (37.7766909671748, -122.426404678747) | 7 | 9 | 11 | 28852 | 10 | |||
179961 | 138858 | DPW Maintained 1 | Schinus molle :: California Pepper 91 | 601 LAGUNA ST | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 0ft | 6004946.3367 | 2111001.3561 | 37.7766870733429 | -122.426404947187 | (37.7766870733429, -122.426404947187) | 7 | 9 | 11 | 28852 | 10 | |||
70623 | 138859 | DPW Maintained 1 | Schinus molle :: California Pepper 91 | 601 LAGUNA ST | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 0ft | 6004948.1933 | 2110978.3343 | 37.7766239660594 | -122.426396885095 | (37.7766239660594, -122.426396885095) | 7 | 9 | 11 | 28852 | 10 | |||
51033 | 12258 | DPW Maintained 1 | Schinus molle :: California Pepper 91 | 601 Laguna St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6004950.99275 | 2110977.71573 | 37.7766224258639 | -122.426387156922 | (37.7766224258639, -122.426387156922) | 7 | 9 | 11 | 28852 | 10 | |||
126077 | 138851 | DPW Maintained 1 | Schinus molle :: California Pepper 91 | 602 Hayes St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | Width 0ft | 6004934.5518 | 2110939.3444 | 37.7765161381936 | -122.426441298216 | (37.7765161381936, -122.426441298216) | 7 | 9 | 11 | 28852 | 10 | |||
108429 | 117357 | DPW Maintained 1 | Schinus molle :: California Pepper 91 | 602 Hayes St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 19 | 3x3 | 6004937.66325 | 2110937.75927 | 37.7765119617013 | -122.426430421921 | (37.7765119617013, -122.426430421921) | 7 | 9 | 11 | 28852 | 10 | |||
182586 | 138852 | DPW Maintained 1 | Schinus molle :: California Pepper 91 | 604 Hayes St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 17 | Width 0ft | 6004921.1795 | 2110937.9117 | 37.776511448416 | -122.426487454824 | (37.776511448416, -122.426487454824) | 7 | 9 | 11 | 28852 | 10 | |||
189330 | 117358 | DPW Maintained 1 | Schinus molle :: California Pepper 91 | 602 Hayes St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | 3x3 | 6004920.03397 | 2110936.25791 | 37.7765068427555 | -122.426491299758 | (37.7765068427555, -122.426491299758) | 7 | 9 | 11 | 28852 | 10 | |||
19961 | 142238 | DPW Maintained 1 | Schinus molle :: California Pepper 91 | 689 HAYES ST | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 0ft | 6004757.5201 | 2110863.998 | 37.776299246383 | -122.427048334097 | (37.776299246383, -122.427048334097) | 7 | 9 | 11 | 28852 | 10 | |||
54807 | 136367 | DPW Maintained 1 | Schinus molle :: California Pepper 91 | 689 Hayes St | 5 | : | Tree | Private 2 | 16 | Width 3ft | 6004762.56149 | 2110859.02755 | 37.7762858838177 | -122.427030540428 | (37.7762858838177, -122.427030540428) | 7 | 9 | 11 | 28852 | 10 | |||
89257 | 33655 | DPW Maintained 1 | Schinus molle :: California Pepper 91 | 542 Linden St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/03/1996 12:00:00 AM | 22 | Permit Number 37744 | 6004783.29295 | 2110728.72543 | 37.775929278336 | -122.426949542114 | (37.775929278336, -122.426949542114) | 7 | 9 | 11 | 28852 | 10 | ||
89477 | 142226 | DPW Maintained 1 | Schinus molle :: California Pepper 91 | 542 LINDEN ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 0ft | 6004780.8856 | 2110726.6251 | 37.7759233752217 | -122.426957720143 | (37.7759233752217, -122.426957720143) | 7 | 9 | 11 | 28852 | 10 | |||
4861 | 40879 | Permitted Site 7 | Schinus molle :: California Pepper 91 | 38 Washburn St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/26/1976 12:00:00 AM | Permit Number 41789 | 6008346.99191908 | 2110451.53839796 | 37.775369049965 | -122.414602124139 | (37.775369049965, -122.414602124139) | 8 | 2 | 9 | 28853 | 34 | |||
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 | |
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 |
78357 | 197485 | DPW Maintained 1 | Schinus molle :: California Pepper 91 | 15 Lafayette St | 2 | : | Tree | Private 2 | 13 | Width 3ft | 6007471.02195 | 2109700.81958 | 37.773258502312 | -122.417579097413 | (37.773258502312, -122.417579097413) | 8 | 2 | 9 | 28853 | 19 | |||
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 | ||
38542 | 197482 | DPW Maintained 1 | Schinus molle :: California Pepper 91 | 99 Lafayette St | 1 | : | Tree | Private 2 | 10 | Width 3ft | 6007465.83226 | 2109669.87011 | 37.7731732303985 | -122.417594855315 | (37.7731732303985, -122.417594855315) | 8 | 2 | 9 | 28853 | 19 | |||
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 | |||
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 | |||
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 | |
184088 | 108112 | Permitted Site 7 | Schinus molle :: California Pepper 91 | 690 Page St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6003299.11292 | 2109682.74913 | 37.7729732522628 | -122.432008994211 | (37.7729732522628, -122.432008994211) | 15 | 9 | 11 | 29492 | 10 | |||||
128413 | 244460 | DPW Maintained 1 | Schinus molle :: California Pepper 91 | 690 Page St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 0ft | 6003277.2679 | 2109662.4318 | 37.7729162274022 | -122.432083107592 | (37.7729162274022, -122.432083107592) | 15 | 9 | 11 | 29492 | 10 | |||
63478 | 42173 | DPW Maintained 1 | Schinus molle :: California Pepper 91 | 466 08th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/21/2000 12:00:00 AM | 11 | Permit Number 42461 | 6010347.47254 | 2109513.35928 | 37.7729052153318 | -122.407615799844 | (37.7729052153318, -122.407615799844) | 14 | 2 | 9 | 28853 | 34 | |
99586 | 117533 | Undocumented 4 | Schinus molle :: California Pepper 91 | 870 PAGE ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6x6 | 6002404 | 2109622 | 37.7727556633357 | -122.435100948925 | (37.7727556633357, -122.435100948925) | 15 | 5 | 11 | 29492 | 9 | ||||
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 | |||
87765 | 247489 | DPW Maintained 1 | Schinus molle :: California Pepper 91 | 868 Page St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 0ft | 6002408.5917 | 2109542.1708 | 37.7725367328675 | -122.435079355167 | (37.7725367328675, -122.435079355167) | 15 | 5 | 11 | 29492 | 9 | |||
152697 | 244482 | DPW Maintained 1 | Schinus molle :: California Pepper 91 | 235 Broderick St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 0ft | 6001259.6239 | 2109499.111 | 37.7723531930337 | -122.43905065598 | (37.7723531930337, -122.43905065598) | 15 | 5 | 11 | 29492 | 9 | |||
75526 | 108931 | Undocumented 4 | Schinus molle :: California Pepper 91 | 1099x NATOMA ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | 2x2 | Permit Number 774500 | 6007500 | 2109279 | 37.772101916333 | -122.417448958018 | (37.772101916333, -122.417448958018) | 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 | |||
117522 | 45371 | Permitted Site 7 | Schinus molle :: California Pepper 91 | 165 Divisadero St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/18/2003 12:00:00 AM | Permit Number 49668 | 6001878.15662511 | 2108576.11606242 | 37.7698540525754 | -122.436845011254 | (37.7698540525754, -122.436845011254) | 15 | 5 | 5 | 29492 | 9 | |||
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 | |||
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 | ||
80743 | 247658 | DPW Maintained 1 | Schinus molle :: California Pepper 91 | 129 Divisadero St | 1 | : | Tree | Private 2 | 10 | Width 3ft | 6001895.26535 | 2108435.04385 | 37.7694676755344 | -122.436775732636 | (37.7694676755344, -122.436775732636) | 15 | 5 | 5 | 29492 | 9 | |||
160098 | 247665 | DPW Maintained 1 | Schinus molle :: California Pepper 91 | 126 Divisadero St | 1 | : | Tree | Private 2 | 13 | Width 3ft | 6001954.04638 | 2108418.01268 | 37.7694242526446 | -122.436571192619 | (37.7694242526446, -122.436571192619) | 15 | 5 | 5 | 29492 | 9 | |||
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 | |||
65791 | 247660 | DPW Maintained 1 | Schinus molle :: California Pepper 91 | 117 Divisadero St | 1 | : | Tree | Private 2 | 10 | Width 4ft | 6001900.46366 | 2108395.08084 | 37.7693582424224 | -122.436754890829 | (37.7693582424224, -122.436754890829) | 15 | 5 | 5 | 29492 | 9 | |||
52252 | 247663 | DPW Maintained 1 | Schinus molle :: California Pepper 91 | 108 Divisadero St | 2 | : | Tree | Private 2 | 11 | Width 3ft | 6001959.36889 | 2108361.77304 | 37.7692701349494 | -122.436548756347 | (37.7692701349494, -122.436548756347) | 15 | 5 | 5 | 29492 | 9 | |||
167969 | 41655 | Permitted Site 7 | Schinus molle :: California Pepper 91 | 112 Divisadero St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/08/2000 12:00:00 AM | Permit Number 42124 | 6001962.23129662 | 2108338.50531125 | 37.7692064101731 | -122.436537189813 | (37.7692064101731, -122.436537189813) | 15 | 5 | 5 | 29492 | 9 | |||
148800 | 84811 | Permitted Site 7 | Schinus molle :: California Pepper 91 | 654 Shrader St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/20/2007 12:00:00 AM | Permit No. 49280 | 5997579.9 | 2108309.3 | 37.7688762175244 | -122.451693255762 | (37.7688762175244, -122.451693255762) | 15 | 5 | 11 | 29492 | 9 | |||
23853 | 35615 | Permitted Site 7 | Schinus molle :: California Pepper 91 | 42 Walter St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/30/1998 12:00:00 AM | Permit Number 38971 | 6003128.23907612 | 2108063.84146095 | 37.7685184402848 | -122.432484413704 | (37.7685184402848, -122.432484413704) | 15 | 5 | 5 | 28862 | 3 | |||
35370 | 35616 | Permitted Site 7 | Schinus molle :: California Pepper 91 | 42 Walter St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/30/1998 12:00:00 AM | Permit Number 38971 | 6003128.23907612 | 2108063.84146095 | 37.7685184402848 | -122.432484413704 | (37.7685184402848, -122.432484413704) | 15 | 5 | 5 | 28862 | 3 | |||
173467 | 35617 | Permitted Site 7 | Schinus molle :: California Pepper 91 | 42 Walter St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/30/1998 12:00:00 AM | Permit Number 38971 | 6003128.23907612 | 2108063.84146095 | 37.7685184402848 | -122.432484413704 | (37.7685184402848, -122.432484413704) | 15 | 5 | 5 | 28862 | 3 | |||
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 | |||
55243 | 239585 | DPW Maintained 1 | Schinus molle :: California Pepper 91 | 838 Clayton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | Width 4ft | 5998709.19727 | 2107219.09568 | 37.7659474025784 | -122.44770861806 | (37.7659474025784, -122.44770861806) | 15 | 5 | 11 | 29492 | 9 | |||
168249 | 239583 | DPW Maintained 1 | Schinus molle :: California Pepper 91 | 857 Clayton St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 3ft | 5998663.26171 | 2107205.3997 | 37.7659071714014 | -122.447866512943 | (37.7659071714014, -122.447866512943) | 15 | 5 | 11 | 29492 | 9 | |||
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 | |||
84224 | 239582 | DPW Maintained 1 | Schinus molle :: California Pepper 91 | 43 Carl St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 3ft | 5998416.52248 | 2107203.63932 | 37.765888231668 | -122.448719802287 | (37.765888231668, -122.448719802287) | 15 | 5 | 11 | 29492 | 9 | |||
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 | |||
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 | |||
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 | |||
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 | |||
177046 | 239605 | DPW Maintained 1 | Schinus molle :: California Pepper 91 | 217 Carl St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 4ft | 5997066.3771 | 2107014.18212 | 37.7652907329028 | -122.453375969329 | (37.7652907329028, -122.453375969329) | 15 | 5 | 11 | 29492 | 12 | |||
86676 | 214165 | DPW Maintained 1 | Schinus molle :: California Pepper 91 | 428 Carl St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 4ft | 5996451.80809 | 2106977.82649 | 37.7651556637169 | -122.455498978198 | (37.7651556637169, -122.455498978198) | 15 | 5 | 11 | 29492 | 12 | |||
319 | 96811 | Permitted Site 7 | Schinus molle :: California Pepper 91 | 356 Carl St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5996379.5 | 2106960.2 | 37.7651031164685 | -122.455747798641 | (37.7651031164685, -122.455747798641) | 15 | 5 | 11 | 29492 | 12 | ||||
131919 | 239655 | DPW Maintained 1 | Schinus molle :: California Pepper 91 | 315 Sanchez St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | Width 3ft | 6003584.30488 | 2106480.06785 | 37.7641956329586 | -122.430793883956 | (37.7641956329586, -122.430793883956) | 8 | 4 | 5 | 28862 | 3 | |||
76756 | 239659 | DPW Maintained 1 | Schinus molle :: California Pepper 91 | 155 States St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | Width 3ft | 6001303.69127 | 2106216.90984 | 37.7633435891615 | -122.438662997693 | (37.7633435891615, -122.438662997693) | 15 | 5 | 5 | 28862 | 3 | |||
21141 | 51696 | Permitted Site 7 | Schinus molle :: California Pepper 91 | 4384@ TEMPLE 17th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/29/2005 12:00:00 AM | Permit Number 47972 | 6000123.14739521 | 2105790.85513139 | 37.7621065191401 | -122.442715506918 | (37.7621065191401, -122.442715506918) | 15 | 5 | 5 | 28862 | 3 | |||
82754 | 239645 | DPW Maintained 1 | Schinus molle :: California Pepper 91 | 4 Ford St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 6003486.01122 | 2105681.39131 | 37.7619970900117 | -122.431076844836 | (37.7619970900117, -122.431076844836) | 15 | 4 | 5 | 28862 | 3 | |||
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 |
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) );