trees
527 rows where SiteOrder = 1 and qSpecies_id = 93 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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3871 | 260928 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 293 Amber Dr | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 5999961.28455 | 2099340.35663 | 37.7443857918882 | -122.442812113441 | (37.7443857918882, -122.442812113441) | 2 | 7 | 5 | 63 | 22 | |||||
4000 | 79751 | Significant Tree 6 | Schinus terebinthifolius :: Brazilian Pepper 93 | 15 Junipero Serra Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4x10 | 5991685.90264393 | 2095891.27109779 | 37.7344402285305 | -122.471175151585 | (37.7344402285305, -122.471175151585) | 9 | 8 | 4 | 59 | 40 | ||||
4683 | 62258 | Permitted Site 7 | Schinus terebinthifolius :: Brazilian Pepper 93 | 49 Capistrano Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/03/1985 12:00:00 AM | Permit Number 22384 | 6001321.62543581 | 2093848.87962555 | 37.7293849331116 | -122.437715130621 | (37.7293849331116, -122.437715130621) | 9 | 7 | 6 | 28861 | 25 | ||
6032 | 50628 | Permitted Site 7 | Schinus terebinthifolius :: Brazilian Pepper 93 | 1198 Gilman Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/14/2004 12:00:00 AM | Permit Number 47728 | 6014541.97081926 | 2090297.22948146 | 37.7203756614272 | -122.39176255443 | (37.7203756614272, -122.39176255443) | 10 | 3 | 8 | 58 | 1 | |||
7213 | 62827 | Permitted Site 7 | Schinus terebinthifolius :: Brazilian Pepper 93 | 1835 San Jose Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/08/1986 12:00:00 AM | Permit Number 23192 | 6000500.63320764 | 2093420.59763273 | 37.7281622534397 | -122.44052266477 | (37.7281622534397, -122.44052266477) | 9 | 7 | 6 | 28861 | 25 | ||
9502 | 65156 | Permitted Site 7 | Schinus terebinthifolius :: Brazilian Pepper 93 | 832 Alvarado St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/24/1989 12:00:00 AM | Permit Number 27135 | 6001006.03746235 | 2102623.98500372 | 37.7534613558838 | -122.439434917257 | (37.7534613558838, -122.439434917257) | 2 | 4 | 5 | 28862 | 22 | ||
11444 | 261994 | Significant Tree 6 | Schinus terebinthifolius :: Brazilian Pepper 93 | 1557x Bancroft Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 6014548 | 2092008 | 37.7250734320456 | -122.391861276019 | (37.7250734320456, -122.391861276019) | 10 | 3 | 8 | 58 | 1 | ||||
14741 | 33010 | Permitted Site 7 | Schinus terebinthifolius :: Brazilian Pepper 93 | 3622 24th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/20/2000 12:00:00 AM | Permit Number 42195 | 6005636.60974519 | 2102002.04320044 | 37.7520160884207 | -122.423377179853 | (37.7520160884207, -122.423377179853) | 2 | 4 | 5 | 28859 | 19 | ||
17604 | 261710 | Significant Tree 6 | Schinus terebinthifolius :: Brazilian Pepper 93 | 3555 16th St | 1 | Front Yard : Yard | Tree | Public Library 12 | 8x8 | 6003221.95473 | 2106496.25325 | 37.7642195378276 | -122.432048304209 | (37.7642195378276, -122.432048304209) | 15 | 4 | 5 | 28862 | 3 | ||||
18752 | 51349 | Permitted Site 7 | Schinus terebinthifolius :: Brazilian Pepper 93 | 6401 23rd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/12/2004 12:00:00 AM | Permit Number 47697 | |||||||||||||
20356 | 39764 | Permitted Site 7 | Schinus terebinthifolius :: Brazilian Pepper 93 | 670 Noe St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/06/1999 12:00:00 AM | Permit Number 41130 | 6003007.22096458 | 2104433.1722566 | 37.7585426381862 | -122.432643626683 | (37.7585426381862, -122.432643626683) | 2 | 4 | 5 | 28862 | 3 | ||
20931 | 39484 | Permitted Site 7 | Schinus terebinthifolius :: Brazilian Pepper 93 | 3828 23rd St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/28/2003 12:00:00 AM | Permit Number 46800 | 6004242.77277465 | 2102507.2235091 | 37.7533244292691 | -122.428233272856 | (37.7533244292691, -122.428233272856) | 2 | 4 | 5 | 28862 | 22 | ||
21426 | 35154 | Permitted Site 7 | Schinus terebinthifolius :: Brazilian Pepper 93 | 838 Page St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/06/2004 12:00:00 AM | Permit Number 47291 | 6002552.46430035 | 2109566.25151631 | 37.7726110209677 | -122.43458340802 | (37.7726110209677, -122.43458340802) | 15 | 5 | 11 | 29492 | 9 | ||
23571 | 59786 | Permitted Site 7 | Schinus terebinthifolius :: Brazilian Pepper 93 | 401 Ashbury St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/13/2004 12:00:00 AM | Permit Number 19235 | 5998844.30042115 | 2109361.70149477 | 37.7718381757148 | -122.447395558288 | (37.7718381757148, -122.447395558288) | 15 | 5 | 11 | 29492 | 9 | ||
25848 | 34445 | Permitted Site 7 | Schinus terebinthifolius :: Brazilian Pepper 93 | 78 Whitney St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/15/1997 12:00:00 AM | Permit Number 38189 | 6004271.49317697 | 2097724.19157363 | 37.7401929546681 | -122.427793175192 | (37.7401929546681, -122.427793175192) | 2 | 7 | 5 | 63 | 7 | ||
26869 | 66993 | Permitted Site 7 | Schinus terebinthifolius :: Brazilian Pepper 93 | 325 Holloway Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/12/1992 12:00:00 AM | Permit Number 30346 | 5995859.19605633 | 2091190.56071344 | 37.7217737155135 | -122.456406997913 | (37.7217737155135, -122.456406997913) | 9 | 8 | 6 | 28861 | 24 | ||
29722 | 39913 | Permitted Site 7 | Schinus terebinthifolius :: Brazilian Pepper 93 | 2116 Divisadero St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/25/1999 12:00:00 AM | Permit Number 770988 | 6000956 | 2115624 | 37.7891532958703 | -122.440540293957 | (37.7891532958703, -122.440540293957) | 13 | 6 | 1 | 29490 | 27 | ||
30995 | 30954 | Permitted Site 7 | Schinus terebinthifolius :: Brazilian Pepper 93 | 2390 Bush St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/13/1995 12:00:00 AM | Permit Number 34752 | 6002079.96472002 | 2114704.99678528 | 37.7866938860132 | -122.436585716056 | (37.7866938860132, -122.436585716056) | 13 | 6 | 11 | 29490 | 27 | ||
31257 | 92610 | Permitted Site 7 | Schinus terebinthifolius :: Brazilian Pepper 93 | 3971 20th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/27/2009 12:00:00 AM | 3x3 | Permit Number 52921 | 6003876 | 2104198 | 37.7579461423488 | -122.429622225876 | (37.7579461423488, -122.429622225876) | 2 | 4 | 5 | 28862 | 3 | ||
31371 | 47783 | Permitted Site 7 | Schinus terebinthifolius :: Brazilian Pepper 93 | 411 Francisco St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/11/2002 12:00:00 AM | Permit Number 45557 | 6009328.94293981 | 2121149.73408628 | 37.8047988220658 | -122.4119614934 | (37.8047988220658, -122.4119614934) | 3 | 1 | 10 | 308 | 23 | |||
31796 | 62829 | Permitted Site 7 | Schinus terebinthifolius :: Brazilian Pepper 93 | 1901 San Jose Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/08/1986 12:00:00 AM | Permit Number 23194 | 6000247.30252359 | 2092964.84623807 | 37.7268964366151 | -122.441365747367 | (37.7268964366151, -122.441365747367) | 9 | 7 | 6 | 28861 | 25 | ||
33159 | 67820 | Permitted Site 7 | Schinus terebinthifolius :: Brazilian Pepper 93 | 133 Vicksburg St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/17/1992 12:00:00 AM | Permit Number 31476 | 6004140.16165068 | 2102371.71829749 | 37.7529465572746 | -122.428578465138 | (37.7529465572746, -122.428578465138) | 2 | 4 | 5 | 28862 | 22 | ||
36565 | 109296 | Undocumented 4 | Schinus terebinthifolius :: Brazilian Pepper 93 | 251 RHODE ISLAND ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6011759.4 | 2107238.5 | 37.7667379021668 | -122.402571748171 | (37.7667379021668, -122.402571748171) | 8 | 2 | 8 | 28853 | 20 | ||||
37417 | 66527 | Permitted Site 7 | Schinus terebinthifolius :: Brazilian Pepper 93 | 553 Duncan St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/22/1991 12:00:00 AM | Permit Number 29701 | 6002956.65812754 | 2099750.66235095 | 37.7456827061595 | -122.432484045791 | (37.7456827061595, -122.432484045791) | 2 | 7 | 5 | 63 | 22 | ||
38500 | 50055 | Permitted Site 7 | Schinus terebinthifolius :: Brazilian Pepper 93 | 646 Church St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/28/2003 12:00:00 AM | Permit Number 46785 | 6004256.47851591 | 2105135.14617147 | 37.7605408596837 | -122.42837316341 | (37.7605408596837, -122.42837316341) | 2 | 4 | 5 | 28862 | 3 | |||
40936 | 64307 | Permitted Site 7 | Schinus terebinthifolius :: Brazilian Pepper 93 | 1521 Sanchez St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/10/1988 12:00:00 AM | Permit Number 25118 | 6003982.1529298 | 2099419.88813882 | 37.7448325757503 | -122.428914459055 | (37.7448325757503, -122.428914459055) | 2 | 7 | 5 | 63 | 22 | ||
41029 | 67197 | Permitted Site 7 | Schinus terebinthifolius :: Brazilian Pepper 93 | 155 Alma St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/06/1992 12:00:00 AM | Permit Number 30649 | 5997964.57682635 | 2106171.52478331 | 37.7630284524752 | -122.450208578402 | (37.7630284524752, -122.450208578402) | 15 | 5 | 11 | 29492 | 9 | ||
44330 | 67999 | Permitted Site 7 | Schinus terebinthifolius :: Brazilian Pepper 93 | 1063 Plymouth Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/20/1993 12:00:00 AM | Permit Number 31724 | 5995906.21686349 | 2090968.00525531 | 37.7211653302718 | -122.456228376798 | (37.7211653302718, -122.456228376798) | 9 | 8 | 6 | 28861 | 24 | ||
47409 | 96967 | Undocumented 4 | Schinus terebinthifolius :: Brazilian Pepper 93 | 1060 Noe St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7x9 | Created tree record on 8/15/2011; marked tree basin for expansion. C.Buck | 6003141 | 2102066 | 37.7520505318065 | -122.432011924137 | (37.7520505318065, -122.432011924137) | 2 | 4 | 5 | 28862 | 22 | |||
55375 | 58367 | Permitted Site 7 | Schinus terebinthifolius :: Brazilian Pepper 93 | 48 Mateo St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/24/1994 12:00:00 AM | Permit Number 17397 | 6003645.80101321 | 2096628.46720423 | 37.7371489313999 | -122.42987842787 | (37.7371489313999, -122.42987842787) | 2 | 7 | 5 | 63 | 7 | ||
56839 | 30962 | Permitted Site 7 | Schinus terebinthifolius :: Brazilian Pepper 93 | 1900 Pierce St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/13/1995 12:00:00 AM | Permit Number 34754 | 6002009.52813319 | 2115026.44418956 | 37.7875724953607 | -122.436852429478 | (37.7875724953607, -122.436852429478) | 13 | 6 | 1 | 29490 | 27 | ||
58081 | 33457 | Permitted Site 7 | Schinus terebinthifolius :: Brazilian Pepper 93 | 300 Winfield St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/27/1996 12:00:00 AM | Permit Number 37712 | 6006656.20982267 | 2098052.1703387 | 37.7412281240479 | -122.419571034944 | (37.7412281240479, -122.419571034944) | 2 | 7 | 7 | 28859 | 2 | |||
59029 | 101259 | Undocumented 4 | Schinus terebinthifolius :: Brazilian Pepper 93 | 1830 Irving St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5990081.34478 | 2106545.17551 | 37.763600113076 | -122.477501005027 | (37.763600113076, -122.477501005027) | 1 | 8 | 3 | 56 | 35 | ||||
59121 | 119660 | Undocumented 4 | Schinus terebinthifolius :: Brazilian Pepper 93 | 699x Missouri St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 6013712 | 2104098 | 37.7582235960409 | -122.395597929962 | (37.7582235960409, -122.395597929962) | 10 | 3 | 8 | 28856 | 29 | |||||
59403 | 46760 | Permitted Site 7 | Schinus terebinthifolius :: Brazilian Pepper 93 | 1180X Bush St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/24/2002 12:00:00 AM | Permit Number 44858 | 6007776.04474552 | 2115482.02501481 | 37.7891494581332 | -122.416933662921 | (37.7891494581332, -122.416933662921) | 13 | 1 | 10 | 28858 | 21 | |||
60930 | 63546 | Permitted Site 7 | Schinus terebinthifolius :: Brazilian Pepper 93 | 1374 Fulton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/14/1994 12:00:00 AM | Permit Number 33370 | 6001184.87437591 | 2111109.12550893 | 37.7767696347038 | -122.439424651157 | (37.7767696347038, -122.439424651157) | 15 | 5 | 11 | 29492 | 41 | ||
62282 | 41713 | Permitted Site 7 | Schinus terebinthifolius :: Brazilian Pepper 93 | 395 Sussex St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/19/2000 12:00:00 AM | Permit Number 42160 | 6000832.46516562 | 2096676.37340252 | 37.7371207489149 | -122.439608818975 | (37.7371207489149, -122.439608818975) | 2 | 7 | 5 | 63 | 7 | ||
65095 | 101807 | Permitted Site 7 | Schinus terebinthifolius :: Brazilian Pepper 93 | 733 Treat Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 19463 | 6008567.7 | 2104253 | 37.7583616995478 | -122.413400180344 | (37.7583616995478, -122.413400180344) | 2 | 4 | 7 | 28859 | 19 | ||||
66810 | 51492 | Permitted Site 7 | Schinus terebinthifolius :: Brazilian Pepper 93 | 375 Elizabeth St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/12/2005 12:00:00 AM | Permit Number 47803 | 6003974.63917877 | 2102132.0432857 | 37.7522790972887 | -122.429133785293 | (37.7522790972887, -122.429133785293) | 2 | 4 | 5 | 28862 | 22 | ||
69528 | 253807 | Significant Tree 6 | Schinus terebinthifolius :: Brazilian Pepper 93 | 2 Garfield St | 1 | Side Yard : Yard | Tree | Private 2 | 10x2 | Permit Number 780744 | 5993976 | 2090624 | 37.7201097842726 | -122.462875584037 | (37.7201097842726, -122.462875584037) | 9 | 8 | 6 | 64 | 24 | |||
71743 | 47706 | Permitted Site 7 | Schinus terebinthifolius :: Brazilian Pepper 93 | 200 Randall St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/22/2002 12:00:00 AM | Permit Number 45502 | 6004240.85369341 | 2097554.18637259 | 37.7397244258614 | -122.42788700337 | (37.7397244258614, -122.42788700337) | 2 | 7 | 5 | 63 | 7 | ||
76734 | 68000 | Permitted Site 7 | Schinus terebinthifolius :: Brazilian Pepper 93 | 1090 Plymouth Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/01/1993 12:00:00 AM | Permit Number 31725 | 5995961.29385488 | 2091144.32738343 | 37.7216526305362 | -122.456050733712 | (37.7216526305362, -122.456050733712) | 9 | 8 | 6 | 28861 | 24 | ||
77377 | 62793 | Permitted Site 7 | Schinus terebinthifolius :: Brazilian Pepper 93 | 1759 San Jose Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/24/1986 12:00:00 AM | Permit Number 23150 | 6000967.03927329 | 2093906.16285207 | 37.7295220513987 | -122.438945068917 | (37.7295220513987, -122.438945068917) | 9 | 7 | 6 | 28861 | 25 | ||
78374 | 40569 | Permitted Site 7 | Schinus terebinthifolius :: Brazilian Pepper 93 | 1750 Taylor St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/15/1999 12:00:00 AM | Permit Number 41613 | 6008764.95036499 | 2118846.2736549 | 37.7984424358323 | -122.41375022293 | (37.7984424358323, -122.41375022293) | 3 | 1 | 10 | 308 | 21 | |||
78808 | 48868 | Permitted Site 7 | Schinus terebinthifolius :: Brazilian Pepper 93 | 351 San Benito Way | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/15/2002 12:00:00 AM | Permit Number 46076 | 5992826.30636272 | 2094323.11375055 | 37.7302003556086 | -122.467118458519 | (37.7302003556086, -122.467118458519) | 9 | 8 | 4 | 59 | 40 | |||
80921 | 34505 | Permitted Site 7 | Schinus terebinthifolius :: Brazilian Pepper 93 | 1x GUY PL | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/17/1997 12:00:00 AM | Permit Number 38225 | 6014462 | 2114376 | 37.7864863849761 | -122.393723467778 | (37.7864863849761, -122.393723467778) | 6 | 2 | 9 | 28855 | 6 | |||
81367 | 62611 | Permitted Site 7 | Schinus terebinthifolius :: Brazilian Pepper 93 | 2262 22nd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/07/1986 12:00:00 AM | Permit Number 22921 | 5989510.16412079 | 2099957.30856958 | 37.7454784240667 | -122.478994620655 | (37.7454784240667, -122.478994620655) | 1 | 8 | 3 | 29491 | 35 | ||
85000 | 68407 | Permitted Site 7 | Schinus terebinthifolius :: Brazilian Pepper 93 | 165 Upland Dr | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/09/1993 12:00:00 AM | Permit Number 32242 | 5993958.38777264 | 2093823.43780185 | 37.7288936500159 | -122.463168491943 | (37.7288936500159, -122.463168491943) | 9 | 8 | 4 | 59 | 40 | ||
85248 | 69541 | Permitted Site 7 | Schinus terebinthifolius :: Brazilian Pepper 93 | 643 Edinburg St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/28/1998 12:00:00 AM | Permit Number 38636 | 6002429.0315791 | 2090033.16165602 | 37.7189707335787 | -122.43361413687 | (37.7189707335787, -122.43361413687) | 9 | 7 | 6 | 28861 | 5 | ||
86102 | 219588 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 98x Waller St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6005256 | 2109297 | 37.7720248250001 | -122.42521242385 | (37.7720248250001, -122.42521242385) | 7 | 9 | 11 | 28852 | 10 | ||||
88925 | 52283 | Permitted Site 7 | Schinus terebinthifolius :: Brazilian Pepper 93 | 176 Tiffany Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/29/2005 12:00:00 AM | Permit Number 48441 | 6006024.37896521 | 2099203.00634212 | 37.7443524500258 | -122.421837411698 | (37.7443524500258, -122.421837411698) | 2 | 7 | 5 | 28859 | 2 | ||
89421 | 50433 | Permitted Site 7 | Schinus terebinthifolius :: Brazilian Pepper 93 | 403 Ashbury St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/11/2004 12:00:00 AM | Permit Number 47583 | 5998845.21508396 | 2109355.09330434 | 37.7718200835759 | -122.447391918702 | (37.7718200835759, -122.447391918702) | 15 | 5 | 11 | 29492 | 9 | |||
90936 | 68409 | Permitted Site 7 | Schinus terebinthifolius :: Brazilian Pepper 93 | 175 Upland Dr | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/09/1993 12:00:00 AM | Permit Number 32245 | 5993925.68682399 | 2093845.21689491 | 37.7289515662137 | -122.463283120302 | (37.7289515662137, -122.463283120302) | 9 | 8 | 4 | 59 | 40 | ||
94617 | 38649 | Permitted Site 7 | Schinus terebinthifolius :: Brazilian Pepper 93 | 594 Lisbon St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/28/1998 12:00:00 AM | Permit Number 40572 | 6001752.37819216 | 2090069.92124104 | 37.7190332505533 | -122.43595568835 | (37.7190332505533, -122.43595568835) | 9 | 7 | 6 | 28861 | 5 | ||
97849 | 62802 | Permitted Site 7 | Schinus terebinthifolius :: Brazilian Pepper 93 | 1975 San Jose Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/24/1986 12:00:00 AM | Permit Number 23159 | 5999892.27432069 | 2092450.57844744 | 37.7254641444646 | -122.442556160778 | (37.7254641444646, -122.442556160778) | 9 | 7 | 6 | 28861 | 25 | ||
100878 | 62344 | Permitted Site 7 | Schinus terebinthifolius :: Brazilian Pepper 93 | 16 28th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/28/1985 12:00:00 AM | Permit Number 22486 | 6005809.69914418 | 2099671.2694643 | 37.7456260851044 | -122.422612999068 | (37.7456260851044, -122.422612999068) | 2 | 7 | 5 | 28859 | 22 | ||
105212 | 32424 | Permitted Site 7 | Schinus terebinthifolius :: Brazilian Pepper 93 | 275 Maywood Dr | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 36952 | 5994490.2461397 | 2094811.13335462 | 37.7316362454296 | -122.461401406739 | (37.7316362454296, -122.461401406739) | 9 | 8 | 4 | 59 | 40 | ||||
106600 | 5405 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 381 Dolores St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/04/2016 12:00:00 AM | 3X3 | 6004938.1878622 | 2106152.8168866 | 37.7633736936511 | -122.426087889681 | (37.7633736936511, -122.426087889681) | 8 | 4 | 5 | 28859 | 19 | |||
106799 | 62237 | Permitted Site 7 | Schinus terebinthifolius :: Brazilian Pepper 93 | 61 Capistrano Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/03/1985 12:00:00 AM | Permit Number 22363 | 6001374.44401127 | 2093790.00837779 | 37.7292262892939 | -122.437528318003 | (37.7292262892939, -122.437528318003) | 9 | 7 | 6 | 28861 | 25 | ||
108442 | 67011 | Permitted Site 7 | Schinus terebinthifolius :: Brazilian Pepper 93 | 319 Holloway Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/20/1992 12:00:00 AM | Permit Number 30366 | 5995876.19861024 | 2091190.26348134 | 37.7217738754672 | -122.456348203392 | (37.7217738754672, -122.456348203392) | 9 | 8 | 6 | 28861 | 24 | ||
109902 | 62343 | Permitted Site 7 | Schinus terebinthifolius :: Brazilian Pepper 93 | 14 28th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/28/1985 12:00:00 AM | Permit Number 22485 | 6005822.8575705 | 2099672.01958419 | 37.7456288871148 | -122.422567552448 | (37.7456288871148, -122.422567552448) | 2 | 7 | 5 | 28859 | 22 | ||
109955 | 95070 | Undocumented 4 | Schinus terebinthifolius :: Brazilian Pepper 93 | 2165 Irving St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5989059 | 2106465 | 37.7633205959205 | -122.481031062121 | (37.7633205959205, -122.481031062121) | 1 | 8 | 3 | 56 | 35 | ||||
110587 | 62804 | Permitted Site 7 | Schinus terebinthifolius :: Brazilian Pepper 93 | 1999 San Jose Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/24/1986 12:00:00 AM | Permit Number 23161 | 5999778.16418017 | 2092287.72080324 | 37.7250104697039 | -122.442938938279 | (37.7250104697039, -122.442938938279) | 9 | 7 | 6 | 28861 | 25 | ||
111364 | 62348 | Permitted Site 7 | Schinus terebinthifolius :: Brazilian Pepper 93 | 57 28th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/28/1985 12:00:00 AM | Permit Number 22491 | 6005543.85080152 | 2099604.02987317 | 37.745426458533 | -122.423527484038 | (37.745426458533, -122.423527484038) | 2 | 7 | 5 | 28859 | 22 | ||
115157 | 34444 | Permitted Site 7 | Schinus terebinthifolius :: Brazilian Pepper 93 | 74 Whitney St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/15/1997 12:00:00 AM | Permit Number 38188 | 6004269.61043081 | 2097757.70943651 | 37.7402848805672 | -122.427802072604 | (37.7402848805672, -122.427802072604) | 2 | 7 | 5 | 63 | 7 | ||
117538 | 30959 | Permitted Site 7 | Schinus terebinthifolius :: Brazilian Pepper 93 | 2401 Bush St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/13/1995 12:00:00 AM | Permit Number 34753 | 6002022.0507417 | 2114644.40993289 | 37.7865242387809 | -122.436781745524 | (37.7865242387809, -122.436781745524) | 13 | 6 | 1 | 29490 | 27 | ||
119001 | 67758 | Permitted Site 7 | Schinus terebinthifolius :: Brazilian Pepper 93 | 4394 25th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/25/1995 12:00:00 AM | Permit Number 31437 | 6001339.65304045 | 2101178.10506013 | 37.7495102967122 | -122.43817763612 | (37.7495102967122, -122.43817763612) | 2 | 4 | 5 | 28862 | 22 | ||
120349 | 71234 | Undocumented 4 | Schinus terebinthifolius :: Brazilian Pepper 93 | 921 Alvarado St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/17/1989 12:00:00 AM | 6000521.03642361 | 2102545.13668815 | 37.7532172438785 | -122.441106493393 | (37.7532172438785, -122.441106493393) | 2 | 4 | 5 | 28862 | 22 | ||||
121175 | 67802 | Permitted Site 7 | Schinus terebinthifolius :: Brazilian Pepper 93 | 4022 Cesar Chavez St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/17/1992 12:00:00 AM | Permit Number 31449 | 6003744.51176452 | 2100434.22126683 | 37.7476042452744 | -122.429808512801 | (37.7476042452744, -122.429808512801) | 2 | 4 | 5 | 63 | 22 | ||
122831 | 67990 | Permitted Site 7 | Schinus terebinthifolius :: Brazilian Pepper 93 | 324 Holloway Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/20/1993 12:00:00 AM | Permit Number 31715 | 5995860.10496142 | 2091242.55276948 | 37.7219165255419 | -122.45640761374 | (37.7219165255419, -122.45640761374) | 9 | 8 | 4 | 28861 | 24 | ||
125622 | 112609 | Undocumented 4 | Schinus terebinthifolius :: Brazilian Pepper 93 | 333 SANTA ANA AVE | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5992649 | 2094625 | 37.7310190240744 | -122.467753372021 | (37.7310190240744, -122.467753372021) | 9 | 8 | 4 | 59 | 40 | ||||
126597 | 33954 | Permitted Site 7 | Schinus terebinthifolius :: Brazilian Pepper 93 | 1 Arbor St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/18/1999 12:00:00 AM | Permit Number 48991 | 6002287.3237241 | 2097040.91143479 | 37.7382043832783 | -122.434604778209 | (37.7382043832783, -122.434604778209) | 2 | 7 | 5 | 63 | 7 | |||
128267 | 122452 | Undocumented 4 | Schinus terebinthifolius :: Brazilian Pepper 93 | 203 Addison St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6002642 | 2097220 | 37.7387162474086 | -122.433391278876 | (37.7387162474086, -122.433391278876) | 2 | 7 | 5 | 63 | 7 | ||||
129693 | 32286 | Permitted Site 7 | Schinus terebinthifolius :: Brazilian Pepper 93 | 1800 Scott St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/15/1996 12:00:00 AM | Permit Number 36869 | 6001579.61916409 | 2114619.58179026 | 37.7864309126762 | -122.438310666952 | (37.7864309126762, -122.438310666952) | 13 | 6 | 11 | 29490 | 27 | |||
129814 | 47778 | Permitted Site 7 | Schinus terebinthifolius :: Brazilian Pepper 93 | 872 Ashbury St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/11/2002 12:00:00 AM | Permit Number 45554 | 5999190.57637215 | 2107256.51251673 | 37.7660776404196 | -122.446046324392 | (37.7660776404196, -122.446046324392) | 15 | 5 | 5 | 29492 | 9 | |||
132607 | 66239 | Permitted Site 7 | Schinus terebinthifolius :: Brazilian Pepper 93 | 1023 Plymouth Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/24/1990 12:00:00 AM | Permit Number 29337 | 5995901.80991046 | 2090714.82365274 | 37.720469900548 | -122.456225313763 | (37.720469900548, -122.456225313763) | 9 | 8 | 6 | 28861 | 24 | ||
134533 | 68795 | Permitted Site 7 | Schinus terebinthifolius :: Brazilian Pepper 93 | 2574 16th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/22/1993 12:00:00 AM | Permit Number 32734 | 5991441.9162308 | 2097904.96501407 | 37.7399552051973 | -122.472165418715 | (37.7399552051973, -122.472165418715) | 1 | 8 | 4 | 29491 | 40 | ||
134565 | 114875 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 1362 Masonic Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/16/2015 12:00:00 AM | 3x3 | 5999587.7 | 2108019.3 | 37.7681947328922 | -122.444727590707 | (37.7681947328922, -122.444727590707) | 15 | 5 | 11 | 29492 | 9 | |||
135321 | 34446 | Permitted Site 7 | Schinus terebinthifolius :: Brazilian Pepper 93 | 84 Whitney St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/15/1997 12:00:00 AM | Permit Number 38190 | 6004274.31729793 | 2097673.91474862 | 37.7400550657314 | -122.427779829106 | (37.7400550657314, -122.427779829106) | 2 | 7 | 5 | 63 | 7 | ||
135640 | 66524 | Permitted Site 7 | Schinus terebinthifolius :: Brazilian Pepper 93 | 625 Duncan St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/12/1992 12:00:00 AM | Permit Number 30334 | 6002498.75858532 | 2099723.40130775 | 37.7455818770993 | -122.434065444251 | (37.7455818770993, -122.434065444251) | 2 | 7 | 5 | 63 | 22 | ||
135718 | 50043 | Permitted Site 7 | Schinus terebinthifolius :: Brazilian Pepper 93 | 3920@ SANCHEZ 19th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/28/2003 12:00:00 AM | Permit Number 46774 | 6003513.59033802 | 2104807.4010588 | 37.759598884966 | -122.430919082048 | (37.759598884966, -122.430919082048) | 2 | 4 | 5 | 28862 | 3 | |||
139566 | 87081 | Permitted Site 7 | Schinus terebinthifolius :: Brazilian Pepper 93 | 172 Divisadero St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/19/2007 12:00:00 AM | 3x3 | Permit Number 50022 | 6001920 | 2108624 | 37.7699879080732 | -122.436703704361 | (37.7699879080732, -122.436703704361) | 15 | 5 | 5 | 29492 | 9 | ||
143267 | 116981 | Undocumented 4 | Schinus terebinthifolius :: Brazilian Pepper 93 | 89 WEBSTER ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6004230 | 2108988 | 37.7711183708566 | -122.428739406059 | (37.7711183708566, -122.428739406059) | 7 | 9 | 11 | 29492 | 10 | |||||
143677 | 41343 | Permitted Site 7 | Schinus terebinthifolius :: Brazilian Pepper 93 | 340 Steiner St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/25/2000 12:00:00 AM | Permit Number 41997 | 6003273.15240269 | 2109435.92669423 | 37.7722940667741 | -122.43208116562 | (37.7722940667741, -122.43208116562) | 15 | 9 | 11 | 29492 | 10 | ||
144596 | 62792 | Permitted Site 7 | Schinus terebinthifolius :: Brazilian Pepper 93 | 1745 San Jose Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/24/1986 12:00:00 AM | Permit Number 23149 | 6001049.88033752 | 2093967.86468253 | 37.7296961834546 | -122.438663099148 | (37.7296961834546, -122.438663099148) | 9 | 7 | 6 | 28861 | 25 | ||
146432 | 62345 | Permitted Site 7 | Schinus terebinthifolius :: Brazilian Pepper 93 | 21 28th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/14/1989 12:00:00 AM | Permit Number 27053 | 6005775.86880093 | 2099617.25647877 | 37.7454758690666 | -122.422726141692 | (37.7454758690666, -122.422726141692) | 2 | 7 | 5 | 28859 | 22 | ||
150529 | 49695 | Permitted Site 7 | Schinus terebinthifolius :: Brazilian Pepper 93 | 4227 25th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/06/2006 12:00:00 AM | Permit Number 46516 | 6002391.92264985 | 2101184.34624044 | 37.7495872238662 | -122.434539307309 | (37.7495872238662, -122.434539307309) | 2 | 4 | 5 | 28862 | 22 | ||
152346 | 49884 | Permitted Site 7 | Schinus terebinthifolius :: Brazilian Pepper 93 | 438@ SANCHEZ Duncan St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/01/2003 12:00:00 AM | Permit Number 46657 | 6003687.07481325 | 2099844.22133211 | 37.7459809898986 | -122.429965046522 | (37.7459809898986, -122.429965046522) | 2 | 7 | 5 | 63 | 22 | ||
153538 | 64837 | Permitted Site 7 | Schinus terebinthifolius :: Brazilian Pepper 93 | 220 28th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/02/1992 12:00:00 AM | Permit Number 30263 | 6004446.78862161 | 2099595.17558793 | 37.7453401631208 | -122.427320319833 | (37.7453401631208, -122.427320319833) | 2 | 7 | 5 | 63 | 22 | ||
153954 | 52473 | Permitted Site 7 | Schinus terebinthifolius :: Brazilian Pepper 93 | 454@ ANZA Funston Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/27/2005 12:00:00 AM | Permit Number 48584 | 5991906.61756296 | 2112344.10243716 | 37.7796281496591 | -122.471610624408 | (37.7796281496591, -122.471610624408) | 11 | 6 | 2 | 54 | 11 | ||
155805 | 66517 | Permitted Site 7 | Schinus terebinthifolius :: Brazilian Pepper 93 | 4172 25th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/22/1991 12:00:00 AM | Permit Number 29684 | 6002746.62066356 | 2101256.12020049 | 37.7498044269933 | -122.43331787905 | (37.7498044269933, -122.43331787905) | 2 | 4 | 5 | 28862 | 22 | ||
159024 | 121236 | Undocumented 4 | Schinus terebinthifolius :: Brazilian Pepper 93 | 3512 21st St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6004884 | 2103735 | 37.7567318772846 | -122.42610317358 | (37.7567318772846, -122.42610317358) | 2 | 4 | 5 | 28862 | 3 | ||||
162241 | 62350 | Permitted Site 7 | Schinus terebinthifolius :: Brazilian Pepper 93 | 74 28th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/28/1985 12:00:00 AM | Permit Number 22493 | 6005428.10472053 | 2099649.51598417 | 37.7455448191665 | -122.423930949775 | (37.7455448191665, -122.423930949775) | 2 | 7 | 5 | 28859 | 22 | ||
163383 | 50263 | Permitted Site 7 | Schinus terebinthifolius :: Brazilian Pepper 93 | 519 Holly Park Cir | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/27/2003 12:00:00 AM | Permit Number 46969 | 6006390.76852581 | 2096193.21285802 | 37.7361088859688 | -122.420356925459 | (37.7361088859688, -122.420356925459) | 2 | 7 | 7 | 28859 | 2 | ||
163502 | 41628 | Permitted Site 7 | Schinus terebinthifolius :: Brazilian Pepper 93 | 1095 Natoma St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/01/2000 12:00:00 AM | Permit Number 42109 | 6007646.45182189 | 2109473.56842462 | 37.7726443942379 | -122.416956155908 | (37.7726443942379, -122.416956155908) | 8 | 2 | 9 | 28853 | 19 | |||
167756 | 68408 | Permitted Site 7 | Schinus terebinthifolius :: Brazilian Pepper 93 | 170 Upland Dr | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/09/1993 12:00:00 AM | Permit Number 32243 | 5994001.22714578 | 2093857.38366654 | 37.7289893248225 | -122.463022856253 | (37.7289893248225, -122.463022856253) | 9 | 8 | 4 | 59 | 40 | ||
173907 | 48950 | Permitted Site 7 | Schinus terebinthifolius :: Brazilian Pepper 93 | 2911 23rd St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/25/2002 12:00:00 AM | Permit Number 46135 | 6009399.56446616 | 2102741.17443943 | 37.7542572383471 | -122.410416464523 | (37.7542572383471, -122.410416464523) | 2 | 4 | 7 | 28859 | 19 | ||
176752 | 64740 | Permitted Site 7 | Schinus terebinthifolius :: Brazilian Pepper 93 | 1225 Page St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/17/1988 12:00:00 AM | Permit Number 25701 | 6000702.83668032 | 2109256.16819914 | 37.7716544366578 | -122.440959198032 | (37.7716544366578, -122.440959198032) | 15 | 5 | 11 | 29492 | 9 | ||
179233 | 62796 | Permitted Site 7 | Schinus terebinthifolius :: Brazilian Pepper 93 | 1872 San Jose Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/24/1986 12:00:00 AM | Permit Number 23153 | 6000282.71540486 | 2093136.39817936 | 37.7273694960454 | -122.441255629685 | (37.7273694960454, -122.441255629685) | 9 | 7 | 6 | 28861 | 25 | ||
184922 | 39497 | Permitted Site 7 | Schinus terebinthifolius :: Brazilian Pepper 93 | 430 Alvarado St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/28/1998 12:00:00 AM | Permit Number 40954 | 6003565.0004553 | 2102762.00333018 | 37.7539856215362 | -122.430595327752 | (37.7539856215362, -122.430595327752) | 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) );