trees
356 rows where qSpecies_id = 91 sorted by DBH
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | ||||
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 | ||||
3509 | 99817 | Undocumented 4 | Schinus molle :: California Pepper 91 | 1134 Castro St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7x6 | 6002486 | 2102282 | 37.7526064609065 | -122.434292449268 | (37.7526064609065, -122.434292449268) | 2 | 4 | 5 | 28862 | 22 | ||||
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 | |||
6035 | 264650 | DPW Maintained 1 | Schinus molle :: California Pepper 91 | 2400 Keith St | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 6014365 | 2092317 | 37.7259117231873 | -122.392515496721 | (37.7259117231873, -122.392515496721) | 10 | 3 | 8 | 58 | 1 | ||||
7042 | 264648 | DPW Maintained 1 | Schinus molle :: California Pepper 91 | 2400 Keith St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 6014365 | 2092317 | 37.7259117231873 | -122.392515496721 | (37.7259117231873, -122.392515496721) | 10 | 3 | 8 | 58 | 1 | ||||
7939 | 264649 | DPW Maintained 1 | Schinus molle :: California Pepper 91 | 2400 Keith St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 6014365 | 2092317 | 37.7259117231873 | -122.392515496721 | (37.7259117231873, -122.392515496721) | 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 | |||
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 | |||
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 | ||||
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 | ||
17499 | 264647 | DPW Maintained 1 | Schinus molle :: California Pepper 91 | 2400 Keith St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 6014365 | 2092317 | 37.7259117231873 | -122.392515496721 | (37.7259117231873, -122.392515496721) | 10 | 3 | 8 | 58 | 1 | ||||
20090 | 104219 | Permitted Site 7 | Schinus molle :: California Pepper 91 | 642-652 Castro St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6002365 | 2104465 | 37.7585935873912 | -122.434866988999 | (37.7585935873912, -122.434866988999) | 2 | 4 | 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 | |||
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 | |||
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 | |||
33717 | 99818 | Undocumented 4 | Schinus molle :: California Pepper 91 | 1134 Castro St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6x6 | 6002486 | 2102282 | 37.7526064609065 | -122.434292449268 | (37.7526064609065, -122.434292449268) | 2 | 4 | 5 | 28862 | 22 | ||||
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 | |||
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 | ||
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 | ||||
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 | ||
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 | |||
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 | ||
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 | |||
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 | ||
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 | ||
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 | ||
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 | |||
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 | ||
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 | |||||
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 | ||||
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 | ||
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 | ||||
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 | |||||
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 | |||
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 | |||
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 | |||||
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 | |||
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 | ||
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 | |||
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 | |||
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 | |||||
158555 | 104220 | Permitted Site 7 | Schinus molle :: California Pepper 91 | 642-652 Castro St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6002365 | 2104465 | 37.7585935873912 | -122.434866988999 | (37.7585935873912, -122.434866988999) | 2 | 4 | 5 | 28862 | 3 | ||||
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 | ||||
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 | |||
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 | |||
162055 | 99797 | Undocumented 4 | Schinus molle :: California Pepper 91 | 703-705 Elizabeth St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6001860 | 2102041 | 37.7519091810186 | -122.436440015083 | (37.7519091810186, -122.436440015083) | 2 | 4 | 5 | 28862 | 22 | ||||
164036 | 46334 | Permitted Site 7 | Schinus molle :: California Pepper 91 | 3776 25th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/13/2002 12:00:00 AM | Permit Number 44584 | 6005338.11992395 | 2101398.90311865 | 37.7503431540329 | -122.424366507573 | (37.7503431540329, -122.424366507573) | 2 | 4 | 5 | 28859 | 19 | ||
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 | |||
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 | ||
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 | ||||
172414 | 256223 | Property Tree 8 | Schinus molle :: California Pepper 91 | 116X Brewster St | 1 | Sidewalk: Property side : Yard | Tree | Rec/Park 5 | 6x6 | 6010334 | 2099321 | 37.7449185312124 | -122.406943891675 | (37.7449185312124, -122.406943891675) | 2 | 7 | 7 | 28859 | 2 | ||||
172673 | 32951 | Permitted Site 7 | Schinus molle :: California Pepper 91 | 673X Missouri St | 5 | 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 | |||
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 | |||
178192 | 64253 | Permitted Site 7 | Schinus molle :: California Pepper 91 | 238 Day St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/03/1988 12:00:00 AM | Permit Number 25052 | 6004384.37597616 | 2098713.60490953 | 37.7429160426191 | -122.427473340495 | (37.7429160426191, -122.427473340495) | 2 | 7 | 5 | 63 | 22 | ||
180003 | 119664 | Undocumented 4 | Schinus molle :: California Pepper 91 | 699x Missouri St | 5 | Sidewalk: Property side : Yard | Tree | Private 2 | 6013712 | 2104098 | 37.7582235960409 | -122.395597929962 | (37.7582235960409, -122.395597929962) | 10 | 3 | 8 | 28856 | 29 | |||||
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 | |||||
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 | ||
189872 | 60508 | Permitted Site 7 | Schinus molle :: California Pepper 91 | 282 28th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/02/1987 12:00:00 AM | 3x3 | Permit Number 24310 | 6004065.51901322 | 2099574.2006491 | 37.7452610006153 | -122.428637192649 | (37.7452610006153, -122.428637192649) | 2 | 7 | 5 | 63 | 22 | |
191230 | 88822 | Permitted Site 7 | Schinus molle :: California Pepper 91 | 1011 Castro St | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | Permit Number 51709 | 6002511 | 2102645 | 37.7536045914774 | -122.434231943794 | (37.7536045914774, -122.434231943794) | 2 | 4 | 5 | 28862 | 22 | ||||
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 | |
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 | ||||
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 | ||||
162473 | 239604 | DPW Maintained 1 | Schinus molle :: California Pepper 91 | 3980 22nd St | 1 | : | Tree | Private 2 | 1 | 6001965.58933 | 2102953.14284 | 37.7544197064144 | -122.436140140357 | (37.7544197064144, -122.436140140357) | 2 | 4 | 5 | 28862 | 22 | ||||
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 | |||
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 | |||
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 | |||
58835 | 197505 | DPW Maintained 1 | Schinus molle :: California Pepper 91 | 1705 Newcomb Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 10 | Width 4ft | 6014625.38984 | 2096105.59346 | 37.7363288910633 | -122.391880139859 | (37.7363288910633, -122.391880139859) | 10 | 3 | 8 | 58 | 1 | |||
63489 | 113030 | Undocumented 4 | Schinus molle :: California Pepper 91 | 200x ESMERALDA AVE | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | 9x9 | 6007093 | 2098828 | 37.7433829729046 | -122.41811575542 | (37.7433829729046, -122.41811575542) | 2 | 7 | 7 | 28859 | 2 | |||
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 | |||
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 | ||
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 | |||
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 | |||
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 | |||
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 | ||
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 | |||
137756 | 239587 | DPW Maintained 1 | Schinus molle :: California Pepper 91 | 105 Elsie St | 1 | Sidewalk: Curb side : Pot | Tree | Private 2 | 10 | Width 5ft | 6007266.87289 | 2098693.35025 | 37.7430230396951 | -122.417505004957 | (37.7430230396951, -122.417505004957) | 2 | 7 | 7 | 28859 | 2 |
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) );