trees
1,069 rows where qSpecies_id = 93 sorted by SiteOrder
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
37368 | 240575 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 3971 20th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6003902.14198 | 2104194.35497 | 37.7579376141555 | -122.429531555935 | (37.7579376141555, -122.429531555935) | 2 | 4 | 5 | 28862 | 3 | |||
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 | ||
37454 | 239698 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 157 Rivoli St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 4ft | 5997845.27898 | 2105913.04775 | 37.7623119120732 | -122.450602550973 | (37.7623119120732, -122.450602550973) | 15 | 5 | 11 | 29492 | 9 | |||
37678 | 240590 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 84 Whitney St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 3ft | 6004278.14417 | 2097692.06256 | 37.7401051119636 | -122.427767890078 | (37.7401051119636, -122.427767890078) | 2 | 7 | 5 | 63 | 7 | |||
37780 | 136408 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 1120 Vallejo St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 3ft | 6008149.75151 | 2118608.08883 | 37.7977538729053 | -122.415862131533 | (37.7977538729053, -122.415862131533) | 5 | 1 | 10 | 28858 | 21 | |||
38184 | 54244 | Permitted Site 7 | Schinus terebinthifolius :: Brazilian Pepper 93 | 10 Sharon St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/16/1972 12:00:00 AM | 24 | Permit Number 9985 | 6003826.70188878 | 2107089.19403693 | 37.7658818771202 | -122.429998956827 | (37.7658818771202, -122.429998956827) | 8 | 4 | 5 | 28862 | 3 | ||
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 | |||
39225 | 5692 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 1546 Dolores St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 50 | 3X3 | 6005220.41395 | 2099376.74782 | 37.7447841325786 | -122.424629712984 | (37.7447841325786, -122.424629712984) | 2 | 7 | 5 | 63 | 22 | |||
39481 | 101978 | Significant Tree 6 | Schinus terebinthifolius :: Brazilian Pepper 93 | 25X Tiffany Ave | 1 | Front Yard : Yard | Tree | Private 2 | 12 | 6006502 | 2099737 | 37.7458455996049 | -122.420223786963 | (37.7458455996049, -122.420223786963) | 2 | 7 | 7 | 28859 | 2 | ||||
39490 | 215006 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 1315 03rd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 4ft | 5995155.47354 | 2106606.49729 | 37.764061618685 | -122.459955752961 | (37.764061618685, -122.459955752961) | 15 | 5 | 11 | 56 | 12 | |||
40367 | 239689 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 218 28th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 4ft | 6004444.11087 | 2099592.42792 | 37.7453324672159 | -122.427329383366 | (37.7453324672159, -122.427329383366) | 2 | 7 | 5 | 63 | 22 | |||
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 | ||
41227 | 27410 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 2184 Fell St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/01/1999 12:00:00 AM | 8 | 3X3 | 5997011.7697 | 2109487.1799 | 37.7720778184275 | -122.453743436192 | (37.7720778184275, -122.453743436192) | 15 | 5 | 11 | 29492 | 16 | ||
42292 | 138490 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 1800 Pierce St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 0ft | 6002048.5923 | 2114731.495 | 37.7867648604943 | -122.436696154429 | (37.7867648604943, -122.436696154429) | 13 | 6 | 11 | 29490 | 27 | |||
42392 | 245011 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 1209 Page St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 0ft | 6000668.5479 | 2109254.8115 | 37.7716487585204 | -122.441077707327 | (37.7716487585204, -122.441077707327) | 15 | 5 | 11 | 29492 | 9 | |||
42999 | 197560 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 100 15th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 5ft | 6011918.46378 | 2107507.65941 | 37.7674858323444 | -122.402040494185 | (37.7674858323444, -122.402040494185) | 8 | 2 | 8 | 28853 | 20 | |||
43689 | 245039 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 17 Baker St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 19 | Width 0ft | 6000809.9165 | 2109164.6772 | 37.77140932347 | -122.440582240102 | (37.77140932347, -122.440582240102) | 15 | 5 | 11 | 29492 | 9 | |||
43720 | 240588 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 74 Whitney St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 6004274.45467 | 2097751.30027 | 37.7402675564928 | -122.427784866605 | (37.7402675564928, -122.427784866605) | 2 | 7 | 5 | 63 | 7 | |||
44049 | 26131 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 1500 Oakdale Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 12 | 3x3 | 6015558.456 | 2095125.3192 | 37.7336890117673 | -122.388585707606 | (37.7336890117673, -122.388585707606) | 10 | 3 | 8 | 58 | 1 | |||
44097 | 96379 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 531 Grove St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/09/2012 12:00:00 AM | 10 | 3x3 | Permit Number 768930 | 6005269 | 2111284 | 37.7774813787572 | -122.425308876718 | (37.7774813787572, -122.425308876718) | 7 | 9 | 11 | 28852 | 10 | |
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 | ||
44524 | 106689 | Undocumented 4 | Schinus terebinthifolius :: Brazilian Pepper 93 | 3756 22ND ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | 6x5 | 6003424 | 2103059.4 | 37.7547942135386 | -122.431104165828 | (37.7547942135386, -122.431104165828) | 2 | 4 | 5 | 28862 | 22 | |||
45910 | 250462 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 290 Seacliff Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 11 | Width 3ft | 5986816.96544 | 2115727.4811 | 37.7886221640356 | -122.489466544563 | (37.7886221640356, -122.489466544563) | 11 | 6 | 1 | 55 | 33 | |||
46066 | 107120 | Undocumented 4 | Schinus terebinthifolius :: Brazilian Pepper 93 | 249 HOLLOWAY AVE | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3x3 | 5996083 | 2091212 | 37.7218454285066 | -122.455634919471 | (37.7218454285066, -122.455634919471) | 9 | 8 | 6 | 28861 | 24 | |||
46553 | 123742 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 301 Cabrillo St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 4ft | 5994695.24651 | 2110740.9683 | 37.7753873104579 | -122.461847346358 | (37.7753873104579, -122.461847346358) | 11 | 6 | 2 | 54 | 11 | |||
46670 | 40143 | Permitted Site 7 | Schinus terebinthifolius :: Brazilian Pepper 93 | 560X Stanyan St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/01/1999 12:00:00 AM | 2 | 3x3 | Permit Number 41343 | 5996910.70022428 | 2109465.35547876 | 37.7720120993682 | -122.454091465131 | (37.7720120993682, -122.454091465131) | 15 | 5 | 11 | 29492 | 16 | |
47132 | 179464 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 291 France Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 2ft | 6001719.61303 | 2090058.37784 | 37.7189996935499 | -122.436068119042 | (37.7189996935499, -122.436068119042) | 9 | 7 | 6 | 28861 | 5 | |||
47324 | 214178 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 229 Granville Way | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 5ft | 5994148.82976 | 2098782.7623 | 37.7425216973119 | -122.462869772235 | (37.7425216973119, -122.462869772235) | 1 | 8 | 4 | 59 | 40 | |||
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 | |||
47513 | 214197 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 175 Upland Dr | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 5994005.53316 | 2093797.66398 | 37.7288255972015 | -122.463003639022 | (37.7288255972015, -122.463003639022) | 9 | 8 | 4 | 59 | 40 | |||
47750 | 240576 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 3959 20th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 6003949.10391 | 2104197.56099 | 37.7579490759979 | -122.429369370405 | (37.7579490759979, -122.429369370405) | 2 | 4 | 5 | 28862 | 3 | |||
48484 | 108585 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 36 Goettingen St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3x3 | 6009820.40384 | 2094253.93436 | 37.7309767080873 | -122.408362486264 | (37.7309767080873, -122.408362486264) | 10 | 3 | 7 | 309 | 28 | |||
49058 | 105202 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 708 38th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | 4x6 | 5984164.05462 | 2110996.44068 | 37.7754768768809 | -122.49829551345 | (37.7754768768809, -122.49829551345) | 11 | 6 | 2 | 55 | 26 | |||
49397 | 240526 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 872 Ashbury St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 5999192.4287 | 2107247.1158 | 37.766051945173 | -122.446039241644 | (37.766051945173, -122.446039241644) | 15 | 5 | 5 | 29492 | 9 | |||
50090 | 239732 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 553 Duncan St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 6002955.84762 | 2099760.28761 | 37.7457090889122 | -122.432487535773 | (37.7457090889122, -122.432487535773) | 2 | 7 | 5 | 63 | 22 | |||
50254 | 239671 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 761 Dolores St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 5ft | 6005055.20153 | 2103892.32562 | 37.7571735312626 | -122.425522291914 | (37.7571735312626, -122.425522291914) | 2 | 4 | 5 | 28859 | 19 | |||
51974 | 215003 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 240 Grafton Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 5996037.07731 | 2090573.06283 | 37.7200884227106 | -122.45574749866 | (37.7200884227106, -122.45574749866) | 9 | 8 | 6 | 28861 | 24 | |||
53227 | 214194 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 335 San Benito Way | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 5992857.93725 | 2094480.72645 | 37.7306349468323 | -122.467020561646 | (37.7306349468323, -122.467020561646) | 9 | 8 | 4 | 59 | 40 | |||
54229 | 240538 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 57 28th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 3ft | 6005573.72478 | 2099614.71997 | 37.7454574972629 | -122.423424944317 | (37.7454574972629, -122.423424944317) | 2 | 7 | 5 | 28859 | 22 | |||
54243 | 215017 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 832 Detroit St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 5999463.89862 | 2095685.88724 | 37.7343231196096 | -122.444269401028 | (37.7343231196096, -122.444269401028) | 9 | 7 | 4 | 63 | 40 | |||
54292 | 2774 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 325 Cabrillo St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 25 | 4X6 | 5994591.7075 | 2110737.91873 | 37.7753729760761 | -122.462205288187 | (37.7753729760761, -122.462205288187) | 11 | 6 | 2 | 54 | 11 | |||
54668 | 22632 | Permitted Site 7 | Schinus terebinthifolius :: Brazilian Pepper 93 | 1171 Turk St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 30 | 3X3 | 6004419.15464 | 2112535.54329 | 37.7808697581914 | -122.428337997055 | (37.7808697581914, -122.428337997055) | 7 | 9 | 11 | 29490 | 41 | |||
54813 | 43677 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 656 02nd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/25/2000 12:00:00 AM | 8 | Permit Number 43320 | 5995359.11762 | 2111077.33678 | 37.7763490847186 | -122.459575243791 | (37.7763490847186, -122.459575243791) | 11 | 6 | 2 | 54 | 11 | |
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 | ||
55798 | 179451 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 1848 Sunnydale Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 10 | Width 10ft | 6006175.92265 | 2087836.63994 | 37.7131514400558 | -122.420506743187 | (37.7131514400558, -122.420506743187) | 9 | 7 | 8 | 309 | 39 | |||
55892 | 240569 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 22 Caselli Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 17 | Width 3ft | 6000897.89001 | 2104935.427 | 37.7598018583783 | -122.439974637337 | (37.7598018583783, -122.439974637337) | 2 | 4 | 5 | 28862 | 3 | |||
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 | ||
56897 | 14749 | Permitted Site 7 | Schinus terebinthifolius :: Brazilian Pepper 93 | 940 McAllister St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 4X4 | 6004580.51193 | 2112075.36147 | 37.7796153416711 | -122.427746985107 | (37.7796153416711, -122.427746985107) | 7 | 9 | 11 | 29490 | 41 | |||
56923 | 136400 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 1128 Bush St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 3ft | 6007907.63985 | 2115517.19966 | 37.7892534404542 | -122.416480851612 | (37.7892534404542, -122.416480851612) | 13 | 1 | 10 | 28858 | 21 | |||
56958 | 10262 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 212 Haight St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 80 | 3X3 | 6005067.14002 | 2109566.55049 | 37.7727542742761 | -122.425884896112 | (37.7727542742761, -122.425884896112) | 7 | 9 | 11 | 28852 | 10 | |||
57183 | 24291 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 300 Winfield St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3X3 | 6006664.25165 | 2098042.76581 | 37.7412027542911 | -122.41954256204 | (37.7412027542911, -122.41954256204) | 2 | 7 | 7 | 28859 | 2 | |||
58010 | 56642 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 345 Locust St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/18/1981 12:00:00 AM | 12 | Permit Number 19074 | 5997614.66831 | 2115182.98817 | 37.7877515636362 | -122.452068994515 | (37.7877515636362, -122.452068994515) | 11 | 6 | 1 | 54 | 31 | ||
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 | |||
58320 | 240520 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 161 Bemis St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 19 | Width 5ft | 6003392.36274 | 2096552.7059 | 37.7369265526056 | -122.430749273954 | (37.7369265526056, -122.430749273954) | 2 | 7 | 5 | 63 | 7 | |||
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 | |||
59692 | 217596 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 1637 Ocean Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 0ft | 5994881.6994 | 2092227.6519 | 37.7245651536401 | -122.459861012566 | (37.7245651536401, -122.459861012566) | 9 | 8 | 4 | 28861 | 24 | |||
59824 | 40145 | Permitted Site 7 | Schinus terebinthifolius :: Brazilian Pepper 93 | 580X Stanyan St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/01/1999 12:00:00 AM | 10 | 3x3 | Permit Number 41343 | 6004642 | 2110547 | 37.7754223144781 | -122.427425362403 | (37.7754223144781, -122.427425362403) | 7 | 9 | 11 | 28852 | 10 | |
60627 | 240555 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 133 Vicksburg St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 5ft | 6004136.97088 | 2102299.45232 | 37.752747951271 | -122.428584348611 | (37.752747951271, -122.428584348611) | 2 | 4 | 5 | 28862 | 22 | |||
60818 | 214199 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 159 Maywood Dr | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 2ft | 5994376.25623 | 2095510.50299 | 37.7335499814343 | -122.46184618277 | (37.7335499814343, -122.46184618277) | 9 | 8 | 4 | 59 | 40 | |||
60890 | 239696 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 112 Parnassus Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 22 | Width 4ft | 5997951.3916 | 2106835.98646 | 37.7648521416436 | -122.450302081196 | (37.7648521416436, -122.450302081196) | 15 | 5 | 11 | 29492 | 9 | |||
60920 | 98610 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 1537 Revere Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 26 | 3x3 | 6015377.6336 | 2094141.2385 | 37.7309769017577 | -122.389142180051 | (37.7309769017577, -122.389142180051) | 10 | 3 | 8 | 58 | 1 | |||
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 | ||
61164 | 57496 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 2090 Vallejo St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/15/1988 12:00:00 AM | 15 | Permit Number 25529 | 6003581.68174 | 2117969.32312 | 37.7957421173574 | -122.431623277394 | (37.7957421173574, -122.431623277394) | 13 | 9 | 1 | 57 | 17 | ||
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 | ||
62829 | 240524 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 1023 Stanyan St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 21 | Width 4ft | 5997228.03932 | 2107019.29645 | 37.7653140406215 | -122.452817189965 | (37.7653140406215, -122.452817189965) | 15 | 5 | 11 | 29492 | 12 | |||
63953 | 240580 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 3570 21st St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 3ft | 6004566.70015 | 2103688.08598 | 37.7565851237183 | -122.427197171329 | (37.7565851237183, -122.427197171329) | 2 | 4 | 5 | 28862 | 3 | |||
64694 | 240561 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 3920 19th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6003501.01364 | 2104802.03657 | 37.7595834427499 | -122.430962195664 | (37.7595834427499, -122.430962195664) | 2 | 4 | 5 | 28862 | 3 | |||
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 | ||||
65135 | 246583 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 98 Waller St | 1 | : | Tree | Private 2 | 14 | Width 3ft | 6005277.33485 | 2109248.26095 | 37.7718922045878 | -122.425135156289 | (37.7718922045878, -122.425135156289) | 7 | 9 | 11 | 28852 | 10 | |||
65785 | 215012 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 170 Upland Dr | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 5994032.15409 | 2093824.68861 | 37.7289013336223 | -122.462913569218 | (37.7289013336223, -122.462913569218) | 9 | 8 | 4 | 59 | 40 | |||
66788 | 179470 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 755 Vienna St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 4ft | 6002483.16702 | 2089112.03412 | 37.7164445928267 | -122.43336122534 | (37.7164445928267, -122.43336122534) | 9 | 7 | 6 | 28861 | 5 | |||
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 | ||
67001 | 197543 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 101 Rhode Island St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 24 | Width 4ft | 6011744.4821 | 2107062.59215 | 37.7662540659871 | -122.402610975528 | (37.7662540659871, -122.402610975528) | 8 | 2 | 8 | 28853 | 20 | |||
67016 | 179457 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 949 Vienna St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 1ft | 6002045.64816 | 2088406.8974 | 37.714483612097 | -122.434823106621 | (37.714483612097, -122.434823106621) | 9 | 7 | 6 | 28861 | 5 | |||
67112 | 105255 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 162 Prague St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3x3 | 6004396.67956 | 2090207.02373 | 37.7195595692124 | -122.426825119088 | (37.7195595692124, -122.426825119088) | 9 | 7 | 6 | 28861 | 5 | |||
67130 | 23587 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 3251X Van Ness Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 24 | 3X3 | 6005329.9297952 | 2121916.8669395 | 37.8066799978444 | -122.425855144407 | (37.8066799978444, -122.425855144407) | 13 | 1 | 1 | 28858 | 17 | |||
67223 | 250321 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 247 27th Ave | 1 | : | Tree | Private 2 | 8 | Width 3ft | 5987414.73446 | 2114306.16368 | 37.7847545126541 | -122.487293940769 | (37.7847545126541, -122.487293940769) | 11 | 6 | 1 | 55 | 33 | |||
67473 | 179442 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 20 Santos St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 11 | Width 6ft | 6006642.58468 | 2087353.9641 | 37.7118524017357 | -122.418859586325 | (37.7118524017357, -122.418859586325) | 9 | 7 | 8 | 309 | 39 | |||
67554 | 23458 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 2252 Van Ness Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 17 | 4X4 | 6005965.50421 | 2118183.1057 | 37.7964639393172 | -122.423390011952 | (37.7964639393172, -122.423390011952) | 13 | 9 | 10 | 28858 | 32 | |||
68293 | 4163 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 3755 Cesar Chavez St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/28/1989 12:00:00 AM | 12 | 3X3 | 6005492.3082 | 2100481.88372 | 37.7478339350877 | -122.423768117516 | (37.7478339350877, -122.423768117516) | 2 | 4 | 5 | 28859 | 22 | ||
68428 | 113589 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 370 Drumm St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | 3x3 | 6013618.31729 | 2118086.59987 | 37.7966279046102 | -122.396902670038 | (37.7966279046102, -122.396902670038) | 3 | 1 | 10 | 28860 | 6 | |||
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 | |||
69697 | 69405 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 781 Prague St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/09/1994 12:00:00 AM | 11 | Permit Number 33509 | 6002439.0824 | 2087100.62464 | 37.7109192031396 | -122.43336995327 | (37.7109192031396, -122.43336995327) | 9 | 7 | 6 | 28861 | 5 | |
69813 | 54921 | Permitted Site 7 | Schinus terebinthifolius :: Brazilian Pepper 93 | 363 San Benito Way | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/10/1972 12:00:00 AM | 13 | 4x6 | Permit Number 10790 | 5992776.0461415 | 2094204.68994573 | 37.7298722918639 | -122.467283605749 | (37.7298722918639, -122.467283605749) | 9 | 8 | 4 | 59 | 40 | |
70094 | 28530 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 241 06th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | 3X3 | Permit Number 769387 | 6010745.98493 | 2111818.73382 | 37.7792575379423 | -122.406399762653 | (37.7792575379423, -122.406399762653) | 14 | 2 | 9 | 28853 | 34 | ||
70797 | 239676 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 1356 Utah St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 3ft | 6010842.92295 | 2102014.50671 | 37.7523427770036 | -122.405373771977 | (37.7523427770036, -122.405373771977) | 10 | 4 | 8 | 28859 | 19 | |||
70824 | 240525 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 870 Ashbury St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 4ft | 5999190.09937 | 2107262.31066 | 37.7660935334247 | -122.446048391324 | (37.7660935334247, -122.446048391324) | 15 | 5 | 5 | 29492 | 9 | |||
71020 | 197528 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 301 Utah St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 4ft | 6010653.38226 | 2106522.32736 | 37.7647096449648 | -122.406346829457 | (37.7647096449648, -122.406346829457) | 8 | 4 | 8 | 28853 | 19 | |||
71412 | 214177 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 225 Granville Way | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 5ft | 5994177.64343 | 2098765.47338 | 37.7424758858443 | -122.462768889883 | (37.7424758858443, -122.462768889883) | 1 | 8 | 4 | 59 | 40 | |||
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 | ||
72064 | 2791 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 451 Cabrillo St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3X3 | 5994200.86487 | 2110721.92095 | 37.7753065385693 | -122.463556132466 | (37.7753065385693, -122.463556132466) | 11 | 6 | 2 | 54 | 11 | |||
72079 | 240535 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 3256 21st St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 19 | Width 3ft | 6006601.37219 | 2103804.03084 | 37.7570183352502 | -122.420168759998 | (37.7570183352502, -122.420168759998) | 2 | 4 | 7 | 28859 | 19 | |||
74066 | 179461 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 110 Italy Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 2ft | 6000982.14926 | 2089697.75779 | 37.7179675875255 | -122.43859141349 | (37.7179675875255, -122.43859141349) | 9 | 7 | 6 | 28861 | 5 | |||
74616 | 136410 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 1700 Jones St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 4ft | 6008350.5752 | 2118320.27531 | 37.7969748963406 | -122.415146840471 | (37.7969748963406, -122.415146840471) | 5 | 1 | 10 | 308 | 21 | |||
75286 | 240549 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 426 Hill St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 21 | Width 3ft | 6003562.13775 | 2103342.68871 | 37.7555798840224 | -122.430646661337 | (37.7555798840224, -122.430646661337) | 2 | 4 | 5 | 28862 | 22 | |||
76103 | 215000 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 315 Holloway Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 3ft | 5995844.93384 | 2091196.36007 | 37.7217888203826 | -122.456456717528 | (37.7217888203826, -122.456456717528) | 9 | 8 | 6 | 28861 | 24 | |||
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 |
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) );