trees
356 rows where qSpecies_id = 91 sorted by PlotSize
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3568 | 197493 | DPW Maintained 1 | Schinus molle :: California Pepper 91 | 950x Kansas St | 7 | Median : Yard | Tree | DPW 1 | 25 | 6011595.70122 | 2103803.27065 | 37.7572963894245 | -122.402896325021 | (37.7572963894245, -122.402896325021) | 10 | 3 | 8 | 28856 | 29 | ||||
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 | |||
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 | ||
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 | ||
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 | |||
9816 | 32952 | Permitted Site 7 | Schinus molle :: California Pepper 91 | 673X Missouri St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/01/1996 12:00:00 AM | Permit Number 37269 | 6013554 | 2103938 | 37.7577754809094 | -122.396133153567 | (37.7577754809094, -122.396133153567) | 10 | 3 | 8 | 28856 | 29 | |||
11161 | 247593 | DPW Maintained 1 | Schinus molle :: California Pepper 91 | 800 Tompkins Ave | 14 | Front Yard : Yard | Tree | Private 2 | 11 | 6009015.3685 | 2096434.58029 | 37.736919178173 | -122.411299627995 | (37.736919178173, -122.411299627995) | 10 | 7 | 7 | 28859 | 2 | ||||
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 | |||
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 | ||
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 | |||
16110 | 173720 | DPW Maintained 1 | Schinus molle :: California Pepper 91 | 1799x 25th St | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | 6013424 | 2101939 | 37.7522794251173 | -122.396442635345 | (37.7522794251173, -122.396442635345) | 10 | 3 | 8 | 28856 | 1 | |||||
16131 | 55409 | Permitted Site 7 | Schinus molle :: California Pepper 91 | 872 Sanchez St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/27/1987 12:00:00 AM | Permit Number 11349 | 6003719.33886967 | 2103195.40450941 | 37.7551843810696 | -122.430092504551 | (37.7551843810696, -122.430092504551) | 2 | 4 | 5 | 28862 | 22 | ||
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 | |
17752 | 70594 | DPW Maintained 1 | Schinus molle :: California Pepper 91 | 342 Athens St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 16 | 6004127.79616 | 2091299.57805 | 37.7225442769693 | -122.427832358882 | (37.7225442769693, -122.427832358882) | 9 | 7 | 6 | 28861 | 5 | |||
18330 | 97157 | Section 806 (d) 5 | Schinus molle :: California Pepper 91 | 1079 Le Conte Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/25/2011 12:00:00 AM | 2 | Permit Number 768080 | 6012734.70575 | 2089832.2191 | 37.7189983454895 | -122.397977119771 | (37.7189983454895, -122.397977119771) | 10 | 3 | 8 | 58 | 1 | ||
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 | ||
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 | ||||
20433 | 239596 | DPW Maintained 1 | Schinus molle :: California Pepper 91 | 1816 Castro St | 6 | Sidewalk: Property side : Yard | Tree | Private 2 | 15 | 6002590.68382 | 2100212.92694 | 37.7469312162962 | -122.433782563125 | (37.7469312162962, -122.433782563125) | 2 | 7 | 5 | 63 | 22 | ||||
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 | |||
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 | |||
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 | ||||
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 | |||
27405 | 33584 | Permitted Site 7 | Schinus molle :: California Pepper 91 | 149 Bonview St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/26/1996 12:00:00 AM | Permit Number 37692 | 6007187.40748461 | 2098136.50319387 | 37.7414895902405 | -122.417740314034 | (37.7414895902405, -122.417740314034) | 2 | 7 | 7 | 28859 | 2 | |||
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 | ||
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 | ||
33981 | 59467 | Permitted Site 7 | Schinus molle :: California Pepper 91 | 225 Bosworth St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/04/1980 12:00:00 AM | Permit Number 18832 | 6003936.96875248 | 2095250.30733216 | 37.7333813011767 | -122.428773510363 | (37.7333813011767, -122.428773510363) | 9 | 7 | 5 | 28861 | 25 | |||
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 | ||
35105 | 46070 | Permitted Site 7 | Schinus molle :: California Pepper 91 | 3746 21st St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/12/2001 12:00:00 AM | Permit Number 44454 | 6003440.19743527 | 2103634.04731282 | 37.7563729765603 | -122.431089163341 | (37.7563729765603, -122.431089163341) | 2 | 4 | 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 | |||
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 | ||
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 | ||
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 | ||
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 | ||
43893 | 66181 | DPW Maintained 1 | Schinus molle :: California Pepper 91 | 1705 Newcomb Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/06/1990 12:00:00 AM | 14 | Permit Number 29258 | 6014623.91982 | 2096111.26058 | 37.7363443702049 | -122.391885618526 | (37.7363443702049, -122.391885618526) | 10 | 3 | 8 | 58 | 1 | |
44499 | 197504 | DPW Maintained 1 | Schinus molle :: California Pepper 91 | 1798 Revere Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 12 | 6014086.53204 | 2095170.83461 | 37.733732305508 | -122.393677804596 | (37.733732305508, -122.393677804596) | 10 | 3 | 8 | 58 | 1 | ||||
46169 | 197497 | DPW Maintained 1 | Schinus molle :: California Pepper 91 | 651 Missouri St | 18 | Sidewalk: Property side : Yard | Tree | Private 2 | 14 | 6013599.16401 | 2103957.68535 | 37.7578320454303 | -122.395978336045 | (37.7578320454303, -122.395978336045) | 10 | 3 | 8 | 28856 | 29 | ||||
47659 | 53355 | Permitted Site 7 | Schinus molle :: California Pepper 91 | 4131 23rd St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/12/1969 12:00:00 AM | Permit Number 6248 | 6002301.07087845 | 2102348.37639489 | 37.752778216412 | -122.434936712045 | (37.752778216412, -122.434936712045) | 2 | 4 | 5 | 28862 | 22 | |||
48977 | 173723 | DPW Maintained 1 | Schinus molle :: California Pepper 91 | 1799x 25th St | 2 | Sidewalk: Property side : Cutout | Tree | Private 2 | 6013424 | 2101939 | 37.7522794251173 | -122.396442635345 | (37.7522794251173, -122.396442635345) | 10 | 3 | 8 | 28856 | 1 | |||||
49320 | 32953 | Permitted Site 7 | Schinus molle :: California Pepper 91 | 673X Missouri St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/01/1996 12:00:00 AM | Permit Number 37269 | 6013554 | 2103938 | 37.7577754809094 | -122.396133153567 | (37.7577754809094, -122.396133153567) | 10 | 3 | 8 | 28856 | 29 | |||
56212 | 197490 | DPW Maintained 1 | Schinus molle :: California Pepper 91 | 1301 Minnesota St | 43 | Front Yard : Yard | Tree | Private 2 | 13 | 6015358.4418 | 2102466.66646 | 37.7538357460423 | -122.38978982496 | (37.7538357460423, -122.38978982496) | 10 | 3 | 8 | 28856 | 29 | ||||
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 | ||
58030 | 197487 | DPW Maintained 1 | Schinus molle :: California Pepper 91 | 1301 Minnesota St | 28 | Front Yard : Yard | Tree | Private 2 | 11 | 6015378.84744 | 2102468.94598 | 37.7538431366753 | -122.389719416144 | (37.7538431366753, -122.389719416144) | 10 | 3 | 8 | 28856 | 29 | ||||
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 | |
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 | |
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 | |||||
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 | ||
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 | |
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 | ||
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 | ||||
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 | ||
67494 | 197496 | DPW Maintained 1 | Schinus molle :: California Pepper 91 | 651 Missouri St | 17 | Sidewalk: Property side : Yard | Tree | Private 2 | 11 | 6013599.60524 | 2103941.4739 | 37.7577875568584 | -122.395975674052 | (37.7577875568584, -122.395975674052) | 10 | 3 | 8 | 28856 | 29 | ||||
68839 | 119665 | Undocumented 4 | Schinus molle :: California Pepper 91 | 699x Missouri St | 6 | Sidewalk: Property side : Yard | Tree | Private 2 | 6013712 | 2104098 | 37.7582235960409 | -122.395597929962 | (37.7582235960409, -122.395597929962) | 10 | 3 | 8 | 28856 | 29 | |||||
70184 | 50941 | Permitted Site 7 | Schinus molle :: California Pepper 91 | 871 Sanchez St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/17/2004 12:00:00 AM | Permit Number 47603 | 6003770.24487259 | 2103216.54935313 | 37.7552453228177 | -122.429917964884 | (37.7552453228177, -122.429917964884) | 2 | 4 | 5 | 28862 | 22 | ||
75500 | 32955 | Permitted Site 7 | Schinus molle :: California Pepper 91 | 673X Missouri St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/01/1996 12:00:00 AM | Permit Number 37269 | 6013554 | 2103938 | 37.7577754809094 | -122.396133153567 | (37.7577754809094, -122.396133153567) | 10 | 3 | 8 | 28856 | 29 | |||
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 | |
81470 | 61782 | Permitted Site 7 | Schinus molle :: California Pepper 91 | 2107 24th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/26/1985 12:00:00 AM | 20 | Permit Number 21804 | 6012179.15182 | 2102325.12749 | 37.7532702936903 | -122.400774668711 | (37.7532702936903, -122.400774668711) | 10 | 3 | 8 | 28856 | 29 | |
86380 | 173724 | DPW Maintained 1 | Schinus molle :: California Pepper 91 | 1101 Connecticut St | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | 6013424 | 2101939 | 37.7522794251173 | -122.396442635345 | (37.7522794251173, -122.396442635345) | 10 | 3 | 8 | 28856 | 1 | |||||
86523 | 179423 | DPW Maintained 1 | Schinus molle :: California Pepper 91 | 103 Vienna St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 18 | 6004767.82112 | 2092745.17359 | 37.7265497503523 | -122.425722776001 | (37.7265497503523, -122.425722776001) | 9 | 7 | 6 | 28861 | 5 | ||||
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 | ||||
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 | ||
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 | ||
93453 | 53873 | Permitted Site 7 | Schinus molle :: California Pepper 91 | 3669 21st St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/05/1987 12:00:00 AM | Permit Number 24724 | 6003927.57680575 | 2103608.86941248 | 37.7563314496504 | -122.429401840118 | (37.7563314496504, -122.429401840118) | 2 | 4 | 5 | 28862 | 22 | ||
94142 | 46335 | Permitted Site 7 | Schinus molle :: California Pepper 91 | 3441 26th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/13/2002 12:00:00 AM | Permit Number 44585 | 6006853.77058428 | 2100846.52070985 | 37.7489119074947 | -122.419086096292 | (37.7489119074947, -122.419086096292) | 2 | 4 | 7 | 28859 | 19 | ||
94363 | 63682 | Permitted Site 7 | Schinus molle :: California Pepper 91 | 1366 Sanchez St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/03/1987 12:00:00 AM | Permit Number 24337 | 6003879.47043965 | 2100314.74724677 | 37.7472838389262 | -122.429333315407 | (37.7472838389262, -122.429333315407) | 2 | 7 | 5 | 63 | 22 | ||
96475 | 63982 | Permitted Site 7 | Schinus molle :: California Pepper 91 | 744 Church St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/06/1987 12:00:00 AM | Permit Number 24725 | 6004289.96903589 | 2104522.67899109 | 37.7588610652906 | -122.428213684799 | (37.7588610652906, -122.428213684799) | 2 | 4 | 5 | 28862 | 3 | ||
99964 | 97673 | Permitted Site 7 | Schinus molle :: California Pepper 91 | 547 29th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6003039 | 2098885 | 37.7433104678167 | -122.43213751159 | (37.7433104678167, -122.43213751159) | 2 | 7 | 5 | 63 | 22 | |||||
100527 | 187546 | DPW Maintained 1 | Schinus molle :: California Pepper 91 | 1399 Somerset St | 2 | Side Yard : Yard | Tree | Private 2 | 24 | 6011366.67431 | 2088362.22575 | 37.7148857547405 | -122.402602582141 | (37.7148857547405, -122.402602582141) | 10 | 7 | 8 | 309 | 39 | ||||
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 | ||
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 | ||
112295 | 63956 | Permitted Site 7 | Schinus molle :: California Pepper 91 | 4232 25th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/31/1992 12:00:00 AM | 6002352.24062254 | 2101234.22323777 | 37.7497219215876 | -122.434680095003 | (37.7497219215876, -122.434680095003) | 2 | 4 | 5 | 28862 | 22 | |||
115227 | 239665 | DPW Maintained 1 | Schinus molle :: California Pepper 91 | 3977 22nd St | 7 | : | Tree | Private 2 | 1 | 6001970.62949 | 2102924.44279 | 37.7543411893077 | -122.436120656556 | (37.7543411893077, -122.436120656556) | 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 | ||||
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 | |||
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 | ||
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 | ||||
121062 | 46566 | Permitted Site 7 | Schinus molle :: California Pepper 91 | 3900 22nd St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/02/2002 12:00:00 AM | Permit Number 44701 | 6002455.82917315 | 2102994.91492425 | 37.7545622428397 | -122.434447752947 | (37.7545622428397, -122.434447752947) | 2 | 4 | 5 | 28862 | 22 | |||
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 | ||
125492 | 119663 | Undocumented 4 | Schinus molle :: California Pepper 91 | 699x Missouri St | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 6013712 | 2104098 | 37.7582235960409 | -122.395597929962 | (37.7582235960409, -122.395597929962) | 10 | 3 | 8 | 28856 | 29 | |||||
128125 | 197491 | DPW Maintained 1 | Schinus molle :: California Pepper 91 | 900x Carolina St | 23 | Median : Yard | Tree | DPW 1 | 1 | 6012477.42612 | 2103497.47149 | 37.7565059267156 | -122.399825482885 | (37.7565059267156, -122.399825482885) | 10 | 3 | 8 | 28856 | 29 | ||||
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 | ||
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 | |
132843 | 119662 | Undocumented 4 | Schinus molle :: California Pepper 91 | 699x Missouri St | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 6013712 | 2104098 | 37.7582235960409 | -122.395597929962 | (37.7582235960409, -122.395597929962) | 10 | 3 | 8 | 28856 | 29 | |||||
132958 | 32950 | Permitted Site 7 | Schinus molle :: California Pepper 91 | 673X Missouri St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/01/1996 12:00:00 AM | Permit Number 37269 | 6013554 | 2103938 | 37.7577754809094 | -122.396133153567 | (37.7577754809094, -122.396133153567) | 10 | 3 | 8 | 28856 | 29 | |||
133977 | 187556 | DPW Maintained 1 | Schinus molle :: California Pepper 91 | 3960 Somerset St | 3 | Side Yard : Yard | Tree | Private 2 | 23 | 6011365.57696 | 2088364.56073 | 37.7148921048592 | -122.402606539166 | (37.7148921048592, -122.402606539166) | 10 | 7 | 8 | 309 | 39 | ||||
136995 | 46069 | Permitted Site 7 | Schinus molle :: California Pepper 91 | 3746 21st St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/12/2001 12:00:00 AM | Permit Number 44454 | 6003440.19743527 | 2103634.04731282 | 37.7563729765603 | -122.431089163341 | (37.7563729765603, -122.431089163341) | 2 | 4 | 5 | 28862 | 3 | |||
138709 | 52003 | Permitted Site 7 | Schinus molle :: California Pepper 91 | 375 30th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/06/2005 12:00:00 AM | Permit Number 48220 | 6004122.23435698 | 2098354.44856915 | 37.7419150515767 | -122.428354161004 | (37.7419150515767, -122.428354161004) | 2 | 7 | 5 | 63 | 7 | ||
144402 | 187554 | DPW Maintained 1 | Schinus molle :: California Pepper 91 | 3960 Somerset St | 3 | Side Yard : Yard | Tree | Private 2 | 12 | 6011368.52295 | 2088357.85007 | 37.7148738432156 | -122.402595884908 | (37.7148738432156, -122.402595884908) | 10 | 7 | 8 | 309 | 39 | ||||
145663 | 119666 | Undocumented 4 | Schinus molle :: California Pepper 91 | 699x Missouri St | 7 | Sidewalk: Property side : Yard | Tree | Private 2 | 6013712 | 2104098 | 37.7582235960409 | -122.395597929962 | (37.7582235960409, -122.395597929962) | 10 | 3 | 8 | 28856 | 29 | |||||
148145 | 119668 | Undocumented 4 | Schinus molle :: California Pepper 91 | 699x Missouri St | 9 | Sidewalk: Property side : Yard | Tree | Private 2 | 6013712 | 2104098 | 37.7582235960409 | -122.395597929962 | (37.7582235960409, -122.395597929962) | 10 | 3 | 8 | 28856 | 29 | |||||
148538 | 66525 | Permitted Site 7 | Schinus molle :: California Pepper 91 | 4121 23rd St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/22/1991 12:00:00 AM | Permit Number 29699 | 6002362.5628629 | 2102351.70560046 | 37.7527908488566 | -122.434724299907 | (37.7527908488566, -122.434724299907) | 2 | 4 | 5 | 28862 | 22 | ||
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 | |||
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 | |
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 | |||
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 | ||||
156347 | 63010 | Permitted Site 7 | Schinus molle :: California Pepper 91 | 9 Powhattan Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/23/1986 12:00:00 AM | Permit Number 23424 | 6007395.1381387 | 2098224.27155142 | 37.7417422703287 | -122.417028268249 | (37.7417422703287, -122.417028268249) | 2 | 7 | 7 | 28859 | 2 | ||
156673 | 63979 | Permitted Site 7 | Schinus molle :: California Pepper 91 | 801 Sanchez St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/05/1987 12:00:00 AM | Permit Number 24719 | 6003748.05431866 | 2103616.18796413 | 37.7563413791419 | -122.430023213091 | (37.7563413791419, -122.430023213091) | 2 | 4 | 5 | 28862 | 22 | ||
158396 | 115363 | Undocumented 4 | Schinus molle :: California Pepper 91 | 1709 REVERE AVE | 1 | Front Yard : Yard | Tree | Private 2 | 6014548 | 2094736 | 37.7325639703463 | -122.392051962294 | (37.7325639703463, -122.392051962294) | 10 | 3 | 8 | 58 | 1 | |||||
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 |
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) );