trees
356 rows where qSpecies_id = 91 sorted by XCoord
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
6247 | 20077 | DPW Maintained 1 | Schinus molle :: California Pepper 91 | 100 STAIRWAY55 | 10 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 40ST | |||||||||||||
8265 | 19714 | DPW Maintained 1 | Schinus molle :: California Pepper 91 | 100 STAIRWAY13 | 12 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 40ST | |||||||||||||
15670 | 19820 | DPW Maintained 1 | Schinus molle :: California Pepper 91 | 100 STAIRWAY25 | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 24 | 10ST | |||||||||||||
16158 | 19973 | DPW Maintained 1 | Schinus molle :: California Pepper 91 | 100 STAIRWAY44 | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3 | 36 | |||||||||||||
18879 | 19971 | DPW Maintained 1 | Schinus molle :: California Pepper 91 | 100 STAIRWAY44 | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 15 | |||||||||||||
159362 | 68308 | DPW Maintained 1 | Schinus molle :: California Pepper 91 | 2178 47th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/09/1993 12:00:00 AM | 0 | Permit Number 32119 | 5981736.58109187 | 2100266.85539552 | 37.7458738657157 | -122.505896923616 | (37.7458738657157, -122.505896923616) | 1 | 8 | 3 | 29491 | 35 | |
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 | |
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 | ||
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 | ||
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 | ||
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 | ||
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 | |
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 | ||
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 | |||
147452 | 183550 | DPW Maintained 1 | Schinus molle :: California Pepper 91 | 2593 23rd Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 0ft | 5989227.3726 | 2097702.4617 | 37.7392707770079 | -122.479807490437 | (37.7392707770079, -122.479807490437) | 1 | 8 | 3 | 29491 | 35 | |||
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 | |||
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 | |||
61023 | 46902 | Permitted Site 7 | Schinus molle :: California Pepper 91 | 1416 18th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/29/2002 12:00:00 AM | Permit Number 44958 | 5990552.94389775 | 2105736.96364621 | 37.7614083342209 | -122.47581088419 | (37.7614083342209, -122.47581088419) | 1 | 8 | 4 | 56 | 12 | ||
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 | |||
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 | |||
139364 | 29613 | DPW Maintained 1 | Schinus molle :: California Pepper 91 | 900X Junipero Serra Blvd | 22 | Median : Cutout | Tree | DPW 1 | 03/30/2006 12:00:00 AM | 3 | 3X3 | 5991166.63654 | 2090933.64994 | 37.7207977908582 | -122.472609073865 | (37.7207977908582, -122.472609073865) | 9 | 8 | 4 | 64 | 40 | ||
186600 | 29610 | DPW Maintained 1 | Schinus molle :: California Pepper 91 | 900X Junipero Serra Blvd | 19 | Median : Cutout | Tree | DPW 1 | 03/30/2006 12:00:00 AM | 3 | 3X3 | 5991173.75038 | 2091017.49654 | 37.7210284247022 | -122.472590593675 | (37.7210284247022, -122.472590593675) | 9 | 8 | 4 | 64 | 40 | ||
168964 | 29596 | DPW Maintained 1 | Schinus molle :: California Pepper 91 | 900X Junipero Serra Blvd | 5 | Median : Cutout | Tree | DPW 1 | 03/30/2006 12:00:00 AM | 3 | 3X3 | 5991179.03639 | 2091124.89815 | 37.7213236289735 | -122.472580148063 | (37.7213236289735, -122.472580148063) | 9 | 8 | 4 | 64 | 40 | ||
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 | ||
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 | |||
29837 | 214153 | DPW Maintained 1 | Schinus molle :: California Pepper 91 | 391 Santa Ana Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 3ft | 5992476.67943 | 2094212.83068 | 37.7298773579434 | -122.46831913414 | (37.7298773579434, -122.46831913414) | 9 | 8 | 4 | 59 | 40 | |||
92722 | 37473 | Permitted Site 7 | Schinus molle :: California Pepper 91 | 1453 11th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/26/2002 12:00:00 AM | Permit Number 44951 | 5992709.117019 | 2105576.23529487 | 37.7610917906482 | -122.468341951453 | (37.7610917906482, -122.468341951453) | 1 | 8 | 4 | 56 | 12 | ||
34168 | 68064 | Permitted Site 7 | Schinus molle :: California Pepper 91 | 1911 09th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/26/1993 12:00:00 AM | Permit Number 31801 | 5993434.8119843 | 2102472.74927138 | 37.7526123103472 | -122.465606631992 | (37.7526123103472, -122.465606631992) | 1 | 8 | 4 | 29491 | 12 | ||
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 | |||
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 | |||
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 | |||
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 | |||
194508 | 203796 | DPW Maintained 1 | Schinus molle :: California Pepper 91 | 460 Pacheco St | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 1 | Width 6ft | 5993728.30174 | 2101878.83793 | 37.7509985054805 | -122.464548580761 | (37.7509985054805, -122.464548580761) | 1 | 8 | 4 | 29491 | 12 | |||
13005 | 40812 | Permitted Site 7 | Schinus molle :: California Pepper 91 | 240 Maywood Dr | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/25/1999 12:00:00 AM | Permit Number 41757 | 5994290.46519005 | 2095120.08849436 | 37.732473059968 | -122.462114481375 | (37.732473059968, -122.462114481375) | 9 | 8 | 4 | 59 | 40 | |||
149656 | 40810 | Permitted Site 7 | Schinus molle :: California Pepper 91 | 240 Maywood Dr | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/25/1999 12:00:00 AM | Permit Number 41757 | 5994290.46519005 | 2095120.08849436 | 37.732473059968 | -122.462114481375 | (37.732473059968, -122.462114481375) | 9 | 8 | 4 | 59 | 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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
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 | ||||
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 | |||
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 | |||
99414 | 214166 | DPW Maintained 1 | Schinus molle :: California Pepper 91 | 25 Hazelwood Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 11 | Width 3ft | 5996590.09341 | 2093838.6494 | 37.729086671304 | -122.454071648891 | (37.729086671304, -122.454071648891) | 9 | 7 | 4 | 28861 | 40 | |||
158697 | 214158 | DPW Maintained 1 | Schinus molle :: California Pepper 91 | 675 Hearst Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 1ft | 5996963.77337 | 2094391.63977 | 37.7306264707198 | -122.452819711683 | (37.7306264707198, -122.452819711683) | 9 | 7 | 4 | 28861 | 40 | |||
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 | |||
154950 | 214159 | DPW Maintained 1 | Schinus molle :: California Pepper 91 | 711 Joost Ave | 5 | Sidewalk: Property side : Yard | Tree | Private 2 | 17 | 5997419.66265 | 2094969.48638 | 37.7322392132651 | -122.451285300082 | (37.7322392132651, -122.451285300082) | 9 | 7 | 4 | 59 | 40 | ||||
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
190814 | 214161 | DPW Maintained 1 | Schinus molle :: California Pepper 91 | 112 Marston Ave | 5 | Sidewalk: Property side : Yard | Tree | Private 2 | 2 | 5998700.79375 | 2093221.28064 | 37.7275123235144 | -122.446730415591 | (37.7275123235144, -122.446730415591) | 9 | 7 | 4 | 28861 | 40 | ||||
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 | |||
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 | |||
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 | |||
53347 | 239658 | DPW Maintained 1 | Schinus molle :: California Pepper 91 | 80 Uranus Ter | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 18 | Width 3ft | 5999334.19979 | 2105297.48672 | 37.7607068452574 | -122.445408687374 | (37.7607068452574, -122.445408687374) | 15 | 5 | 5 | 28862 | 3 | |||
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 | |||
125113 | 214170 | DPW Maintained 1 | Schinus molle :: California Pepper 91 | 158 Detroit St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 2ft | 5999431.23761 | 2093723.53638 | 37.7289331003841 | -122.444241352082 | (37.7289331003841, -122.444241352082) | 9 | 7 | 4 | 63 | 40 | |||
136689 | 214160 | DPW Maintained 1 | Schinus molle :: California Pepper 91 | 250 Detroit St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 2ft | 5999436.94421 | 2094022.09374 | 37.7297531948487 | -122.44424306977 | (37.7297531948487, -122.44424306977) | 9 | 7 | 4 | 63 | 40 | |||
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 |
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 | |||
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 | |||
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 | |||
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 | |||
13884 | 258775 | DPW Maintained 1 | Schinus molle :: California Pepper 91 | 833 Corbett Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5999913 | 2102615 | 37.7533744192224 | -122.443214216983 | (37.7533744192224, -122.443214216983) | 2 | 5 | 5 | 63 | 38 | ||||
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 | ||
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 | |||
90678 | 112684 | Undocumented 4 | Schinus molle :: California Pepper 91 | 86 STANTON ST | 1 | Front Yard : Yard | Tree | Private 2 | 3x3 | 6000281 | 2103909 | 37.7569484049338 | -122.442034474193 | (37.7569484049338, -122.442034474193) | 2 | 4 | 5 | 28862 | 38 | ||||
158691 | 112685 | Undocumented 4 | Schinus molle :: California Pepper 91 | 86 STANTON ST | 2 | Front Yard : Yard | Tree | Private 2 | 3x3 | 6000281 | 2103909 | 37.7569484049338 | -122.442034474193 | (37.7569484049338, -122.442034474193) | 2 | 4 | 5 | 28862 | 38 | ||||
169069 | 112686 | Undocumented 4 | Schinus molle :: California Pepper 91 | 86 STANTON ST | 3 | Front Yard : Yard | Tree | Private 2 | 3x3 | 6000281 | 2103909 | 37.7569484049338 | -122.442034474193 | (37.7569484049338, -122.442034474193) | 2 | 4 | 5 | 28862 | 38 | ||||
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 | |||
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 | |||
39126 | 52643 | Permitted Site 7 | Schinus molle :: California Pepper 91 | 4264REVISED 22nd St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/27/2006 12:00:00 AM | Permit Number 48726 | 6000793.82011207 | 2102903.5552845 | 37.7542169085305 | -122.440188854974 | (37.7542169085305, -122.440188854974) | 2 | 4 | 5 | 28862 | 22 | ||
103771 | 62518 | Permitted Site 7 | Schinus molle :: California Pepper 91 | 4367 21st St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/15/1986 12:00:00 AM | Permit Number 22700 | 6000826.50003313 | 2103245.32733573 | 37.7551571922749 | -122.440100345908 | (37.7551571922749, -122.440100345908) | 2 | 4 | 5 | 28862 | 22 | ||
117373 | 239600 | DPW Maintained 1 | Schinus molle :: California Pepper 91 | 4255 22nd St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 21 | Width 4ft | 6000853.41096 | 2102858.4973 | 37.754096582697 | -122.439979544931 | (37.754096582697, -122.439979544931) | 2 | 4 | 5 | 28862 | 22 | |||
41914 | 62527 | Permitted Site 7 | Schinus molle :: California Pepper 91 | 4255 22nd St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/15/1986 12:00:00 AM | Permit Number 22709 | 6000857.54483189 | 2102854.89709726 | 37.7540869327376 | -122.439964990906 | (37.7540869327376, -122.439964990906) | 2 | 4 | 5 | 28862 | 22 | ||
185477 | 52692 | Permitted Site 7 | Schinus molle :: California Pepper 91 | 4362ON CASTRO 21st St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/30/2006 12:00:00 AM | Permit Number 48760 | 6000868.9362336 | 2103304.07672076 | 37.755320919647 | -122.439957801702 | (37.755320919647, -122.439957801702) | 2 | 4 | 5 | 28862 | 38 | ||
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 | |||
122190 | 239601 | DPW Maintained 1 | Schinus molle :: California Pepper 91 | 4315 21st St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 3ft | 6001018.49265 | 2103293.22516 | 37.7552996363918 | -122.439439814104 | (37.7552996363918, -122.439439814104) | 2 | 4 | 5 | 28862 | 22 | |||
168602 | 62517 | Permitted Site 7 | Schinus molle :: California Pepper 91 | 4315 21st St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/15/1986 12:00:00 AM | Permit Number 22698 | 6001100.3292402 | 2103290.9987582 | 37.7552981802714 | -122.439156639775 | (37.7552981802714, -122.439156639775) | 2 | 4 | 5 | 28862 | 22 | ||
47789 | 59597 | Permitted Site 7 | Schinus molle :: California Pepper 91 | 636 Douglass St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/25/1981 12:00:00 AM | 6x25 | Permit Number 18994 | 6001186.92515468 | 2102684.94576678 | 37.7536390322156 | -122.438813738462 | (37.7536390322156, -122.438813738462) | 2 | 4 | 5 | 28862 | 22 | ||
131779 | 4362 | DPW Maintained 1 | Schinus molle :: California Pepper 91 | 951 Chenery St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6001187.63557 | 2096055.63136 | 37.7354365441677 | -122.438336378342 | (37.7354365441677, -122.438336378342) | 2 | 7 | 5 | 63 | 7 | |||
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 | |||
35161 | 239594 | DPW Maintained 1 | Schinus molle :: California Pepper 91 | 636 Douglass St | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 10 | Width 4ft | 6001191.4238 | 2102669.11785 | 37.7535958285084 | -122.43879704705 | (37.7535958285084, -122.43879704705) | 2 | 4 | 5 | 28862 | 22 | |||
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 | |||
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 | |||
159589 | 51810 | Permitted Site 7 | Schinus molle :: California Pepper 91 | 4432 19th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/12/2005 12:00:00 AM | Permit Number 48056 | 6001326.40602228 | 2104686.21381833 | 37.7591419642331 | -122.43847475852 | (37.7591419642331, -122.43847475852) | 2 | 4 | 5 | 28862 | 3 | |||
9411 | 33144 | Permitted Site 7 | Schinus molle :: California Pepper 91 | 4238 21st St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/05/1996 12:00:00 AM | Permit Number 37370 | 6001375.34520428 | 2103384.04824408 | 37.7555693169237 | -122.438212219782 | (37.7555693169237, -122.438212219782) | 2 | 4 | 5 | 28862 | 3 | |||
122621 | 33145 | Permitted Site 7 | Schinus molle :: California Pepper 91 | 4238 21st St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/09/1996 12:00:00 AM | Permit Number 37370 | 6001375.34520428 | 2103384.04824408 | 37.7555693169237 | -122.438212219782 | (37.7555693169237, -122.438212219782) | 2 | 4 | 5 | 28862 | 3 | ||
79145 | 62516 | Permitted Site 7 | Schinus molle :: California Pepper 91 | 4239 21st St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/15/1986 12:00:00 AM | 3x3 | Permit Number 52133 | 6001380.62959357 | 2103332.31744832 | 37.7554275771996 | -122.438190239105 | (37.7554275771996, -122.438190239105) | 2 | 4 | 5 | 28862 | 22 | ||
67293 | 62515 | Permitted Site 7 | Schinus molle :: California Pepper 91 | 4229 21st St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/15/1986 12:00:00 AM | Permit Number 22695 | 6001411.06683037 | 2103335.42666413 | 37.7554378453979 | -122.43808520078 | (37.7554378453979, -122.43808520078) | 2 | 4 | 5 | 28862 | 22 | ||
63611 | 62514 | Permitted Site 7 | Schinus molle :: California Pepper 91 | 4221 21st St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/15/1986 12:00:00 AM | Permit Number 22694 | 6001435.41662208 | 2103337.91403702 | 37.7554460598899 | -122.438001170091 | (37.7554460598899, -122.438001170091) | 2 | 4 | 5 | 28862 | 22 |
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) );