trees
1,069 rows where qSpecies_id = 93 sorted by PermitNotes descending
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
31790 | 93029 | Permitted Site 7 | Schinus terebinthifolius :: Brazilian Pepper 93 | 45 Jersey St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | 5x6 | undocumented | 6004830 | 2101620 | 37.7509215289079 | -122.426139360449 | (37.7509215289079, -122.426139360449) | 2 | 4 | 5 | 28862 | 22 | ||
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 | ||
169326 | 240582 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 8 Sharon St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/16/1972 12:00:00 AM | 15 | Width 3ft | Permit Number 9985 | 6003834.4345 | 2107034.98465 | 37.7657334691548 | -122.429968344076 | (37.7657334691548, -122.429968344076) | 8 | 4 | 5 | 28862 | 3 | |
11016 | 53933 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 144 09th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/27/1972 12:00:00 AM | 17 | Permit Number 9647 | 5993062.86441 | 2114500.7791 | 37.7856166217584 | -122.467767599839 | (37.7856166217584, -122.467767599839) | 11 | 6 | 2 | 54 | 11 | ||
188646 | 214192 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 359 San Benito Way | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/23/1972 12:00:00 AM | 16 | Width 3ft | Permit Number 9509 | 5992777.37887 | 2094232.46292 | 37.7299486265111 | -122.46728101702 | (37.7299486265111, -122.46728101702) | 9 | 8 | 4 | 59 | 40 | |
93955 | 214188 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 358 San Benito Way | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/03/1972 12:00:00 AM | 21 | Width 3ft | Permit Number 9461 | 5992780.99407 | 2094319.49866 | 37.7301878137975 | -122.467274844971 | (37.7301878137975, -122.467274844971) | 9 | 8 | 4 | 59 | 40 | |
11580 | 247184 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 1 Buena Vista Ave East | 1 | : | Tree | Private 2 | 11/09/2017 12:00:00 AM | 3 | Width 4ft | Permit Number 780753 | 6001013.06071 | 2108893.70983 | 37.7706768805726 | -122.439860124855 | (37.7706768805726, -122.439860124855) | 15 | 5 | 11 | 29492 | 9 | |
177543 | 247186 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 1 Buena Vista Ave East | 3 | : | Tree | Private 2 | 10 | Width 4ft | Permit Number 780753 | 6000985.28448 | 2108903.00262 | 37.7707008151093 | -122.439956869431 | (37.7707008151093, -122.439956869431) | 15 | 5 | 11 | 29492 | 9 | ||
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 | |||
131235 | 239730 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 1709 Castro St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/30/2017 12:00:00 AM | 3 | Width 4ft | Permit Number 779965 | 6002631.28239 | 2100576.89579 | 37.7479328928997 | -122.433668185542 | (37.7479328928997, -122.433668185542) | 2 | 4 | 5 | 63 | 22 | |
27413 | 101870 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 737 Folsom St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/23/2016 12:00:00 AM | 3 | 3x3 | Permit Number 779151 | 6012595.5925 | 2113052.7427 | 37.7827491368943 | -122.400087849303 | (37.7827491368943, -122.400087849303) | 6 | 2 | 9 | 28856 | 34 | |
193575 | 50422 | Permitted Site 7 | Schinus terebinthifolius :: Brazilian Pepper 93 | 549 HOLLOWAY AVE | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/03/2016 12:00:00 AM | 3 | 3x3 | Permit Number 778616 | 5995097 | 2091149 | 37.721615813455 | -122.459038685652 | (37.721615813455, -122.459038685652) | 9 | 8 | 6 | 28861 | 24 | |
146534 | 104774 | Undocumented 4 | Schinus terebinthifolius :: Brazilian Pepper 93 | 781 CASTRO ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | 3x3 | Permit Number 778365 | 6002484.5 | 2103704 | 37.7565108482623 | -122.434399295862 | (37.7565108482623, -122.434399295862) | 2 | 4 | 5 | 28862 | 3 | ||
110275 | 51012 | Permitted Site 7 | Schinus terebinthifolius :: Brazilian Pepper 93 | 85 Buena Vista Ter | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/29/2016 12:00:00 AM | 3 | Permit Number 778086 | 6001486.35916374 | 2107715.14620283 | 37.7674677672856 | -122.438138542404 | (37.7674677672856, -122.438138542404) | 15 | 5 | 5 | 29492 | 3 | ||
116236 | 108004 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 520 Hayes St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | 4x4 | Permit Number 773433 | 6005298.14108 | 2111058.38089 | 37.776863530054 | -122.425192009758 | (37.776863530054, -122.425192009758) | 7 | 9 | 11 | 28852 | 10 | ||
169348 | 48771 | Permitted Site 7 | Schinus terebinthifolius :: Brazilian Pepper 93 | 562 Hayes St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/17/2002 12:00:00 AM | Permit Number 773432 | 6005160.4427442 | 2110970.099276 | 37.77661335041 | -122.425662065534 | (37.77661335041, -122.425662065534) | 7 | 9 | 11 | 28852 | 10 | |||
117285 | 101868 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 737 Folsom St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/12/2014 12:00:00 AM | 6 | 3x3 | Permit Number 771222 | 6012702 | 2113175 | 37.7830907593936 | -122.399728309071 | (37.7830907593936, -122.399728309071) | 6 | 2 | 9 | 28856 | 34 | |
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 | ||
153019 | 64355 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 230 04th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/21/1988 12:00:00 AM | 8 | Permit Number 770960 | 6011932.302 | 2113111.47227 | 37.7828733899288 | -122.402386698084 | (37.7828733899288, -122.402386698084) | 6 | 2 | 9 | 28853 | 34 | ||
182662 | 30961 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 1900 Pierce St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/02/2013 12:00:00 AM | 8 | Permit Number 770536 | 6001993.3657 | 2115129.3914 | 37.7878542434133 | -122.436915720974 | (37.7878542434133, -122.436915720974) | 13 | 6 | 1 | 29490 | 27 | |
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 | ||
78732 | 28532 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 241 06th St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 20 | 3X3 | Permit Number 769387 | 6010727.06736 | 2111841.54231 | 37.7793191064344 | -122.406466814313 | (37.7793191064344, -122.406466814313) | 14 | 2 | 9 | 28853 | 34 | ||
108154 | 28531 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 241 06th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/11/2012 12:00:00 AM | 18 | 3X3 | Permit Number 769387 | 6010735.41269 | 2111831.43795 | 37.7792918290844 | -122.406437232011 | (37.7792918290844, -122.406437232011) | 14 | 2 | 9 | 28853 | 34 | |
101372 | 101867 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 737 Folsom St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/29/2012 12:00:00 AM | 4 | 3x3 | Permit Number 769242 | 6012649.1 | 2113074.7 | 37.7828124097662 | -122.399904277178 | (37.7828124097662, -122.399904277178) | 6 | 2 | 9 | 28856 | 34 | |
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 | |
141721 | 98795 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 950@Washington Clay St | 7 | Sidewalk: Curb side : Cutout | Tree | DPW for City Agency 14 | 3x3 | Permit Number 768771 | 6010160.7 | 2117472.9 | 37.7947497683853 | -122.408823532788 | (37.7947497683853, -122.408823532788) | 3 | 1 | 10 | 28857 | 4 | |||
128364 | 5349 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 200X Dolores St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 07/22/2010 12:00:00 AM | 12 | 3x3 | Permit Number 53640 | 6004790.70557 | 2107143.57223 | 37.7660857344886 | -122.426668539926 | (37.7660857344886, -122.426668539926) | 8 | 4 | 5 | 28862 | 3 | |
172079 | 214190 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 393 San Benito Way | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/18/2009 12:00:00 AM | 17 | Width 3ft | Permit Number 53039 | 5992606.38416 | 2093945.56472 | 37.7291510025005 | -122.467851302315 | (37.7291510025005, -122.467851302315) | 9 | 8 | 4 | 59 | 40 | |
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 | ||
63152 | 92261 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 4545 Anza St | 9 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 07/23/2009 12:00:00 AM | 12 | 3x3 | Permit Number 52708 | 5984639.1399 | 2111735.34775 | 37.7775335493935 | -122.496706647933 | (37.7775335493935, -122.496706647933) | 11 | 6 | 2 | 55 | 26 | |
97689 | 44030 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 96 Lafayette St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/07/2009 12:00:00 AM | 6 | 3x3 | Permit Number 52444 | 6007681.41962 | 2109502.84398 | 37.7727267448872 | -122.416837272729 | (37.7727267448872, -122.416837272729) | 8 | 2 | 9 | 28853 | 19 | |
49327 | 88393 | Permitted Site 7 | Schinus terebinthifolius :: Brazilian Pepper 93 | 124 23rd Ave | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/10/2008 12:00:00 AM | 3x3 | Permit Number 51371 | 5988714.5 | 2114502.9 | 37.7853704042268 | -122.482811657264 | (37.7853704042268, -122.482811657264) | 11 | 6 | 2 | 55 | 26 | |||
186613 | 50160 | Permitted Site 7 | Schinus terebinthifolius :: Brazilian Pepper 93 | 150 15th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/02/2008 12:00:00 AM | 3x3 | Permit Number 50543 | 6011831.59667013 | 2107504.61941603 | 37.7674726364822 | -122.402340743885 | (37.7674726364822, -122.402340743885) | 8 | 2 | 8 | 28853 | 20 | ||
190567 | 53817 | Permitted Site 7 | Schinus terebinthifolius :: Brazilian Pepper 93 | 651 Upland Dr | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/23/2008 12:00:00 AM | 3x3 | Permit Number 50398 | 5992946.10042753 | 2094372.20791552 | 37.730342070192 | -122.466707885488 | (37.730342070192, -122.466707885488) | 9 | 8 | 4 | 59 | 40 | ||
191269 | 84343 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 2925 Cabrillo St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/11/2008 12:00:00 AM | 5 | 3x3 | Permit Number 50100 | 5986511.98637 | 2110444.25082 | 37.7740981163558 | -122.490132942891 | (37.7740981163558, -122.490132942891) | 11 | 6 | 2 | 55 | 26 | |
28657 | 80831 | Permitted Site 7 | Schinus terebinthifolius :: Brazilian Pepper 93 | 3100 Turk Blvd | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/24/2007 12:00:00 AM | 4 | 4x4 | Permit Number 50050 | 5996132.20264074 | 2111467.88216918 | 37.7774658426 | -122.456929197984 | (37.7774658426, -122.456929197984) | 11 | 6 | 2 | 54 | 16 | |
86507 | 80829 | Permitted Site 7 | Schinus terebinthifolius :: Brazilian Pepper 93 | 3100 Turk Blvd | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/24/2007 12:00:00 AM | 4 | 4x4 | Permit Number 50050 | 5996132.20264074 | 2111467.88216918 | 37.7774658426 | -122.456929197984 | (37.7774658426, -122.456929197984) | 11 | 6 | 2 | 54 | 16 | |
121336 | 80832 | Permitted Site 7 | Schinus terebinthifolius :: Brazilian Pepper 93 | 3100 Turk Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/24/2007 12:00:00 AM | 4 | 4x4 | Permit Number 50050 | 5996132.20264074 | 2111467.88216918 | 37.7774658426 | -122.456929197984 | (37.7774658426, -122.456929197984) | 11 | 6 | 2 | 54 | 16 | |
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 | ||
153856 | 86882 | Permitted Site 7 | Schinus terebinthifolius :: Brazilian Pepper 93 | 801 Howard St | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/23/2007 12:00:00 AM | 3x3 | Permit Number 49807 | 6011833 | 2113224.2 | 37.7831773700909 | -122.402738173851 | (37.7831773700909, -122.402738173851) | 6 | 2 | 9 | 28853 | 34 | |||
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 | |||
64596 | 52688 | Permitted Site 7 | Schinus terebinthifolius :: Brazilian Pepper 93 | 1401@ RIVOLI Shrader St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/30/2006 12:00:00 AM | Permit Number 48758 | 5997782.1418349 | 2105912.5855129 | 37.76230702883 | -122.450820884323 | (37.76230702883, -122.450820884323) | 15 | 5 | 11 | 29492 | 9 | |||
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 | ||
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 | ||
105968 | 46548 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 3042 Jackson St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/28/2005 12:00:00 AM | 7 | Permit Number 47880 | 5999598.88033 | 2116387.07823 | 37.7911711367754 | -122.445290628875 | (37.7911711367754, -122.445290628875) | 13 | 6 | 1 | 29490 | 27 | ||
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 | ||
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 | |||
152092 | 50629 | Permitted Site 7 | Schinus terebinthifolius :: Brazilian Pepper 93 | 1198 Gilman Ave | 2 | 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 | |||
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 | |||||||||||||
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 | |||
133546 | 51034 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 1275 Harrison St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/08/2004 12:00:00 AM | 13 | Permit Number 47509 | 6009703.0212 | 2109410.10707 | 37.7725856133573 | -122.409837753032 | (37.7725856133573, -122.409837753032) | 14 | 2 | 9 | 28853 | 34 | |
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 | ||
181204 | 50265 | Permitted Site 7 | Schinus terebinthifolius :: Brazilian Pepper 93 | 35 Park St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/27/2003 12:00:00 AM | Permit Number 46971 | 6005046.20150954 | 2096458.3536408 | 37.7367610435591 | -122.425024502668 | (37.7367610435591, -122.425024502668) | 2 | 7 | 5 | 28859 | 2 | ||
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 | ||
139891 | 50200 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 582 24th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/21/2003 12:00:00 AM | 8 | 3x4 | Permit Number 46908 | 5988471.49095 | 2112024.91124 | 37.7785524043317 | -122.483470659433 | (37.7785524043317, -122.483470659433) | 11 | 6 | 2 | 55 | 26 |
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 | ||
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 | |||
85310 | 50056 | Permitted Site 7 | Schinus terebinthifolius :: Brazilian Pepper 93 | 646 Church St | 2 | 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 | |||
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 | |||
177149 | 47230 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 890 Girard St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/28/2003 12:00:00 AM | 6 | Permit Number 46770 | 6011503.10296 | 2090822.57098 | 37.7216489793918 | -122.40230391012 | (37.7216489793918, -122.40230391012) | 10 | 3 | 7 | 309 | 28 | |
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 | ||
171923 | 49833 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 418@ 19th ST Pennsylvania Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/11/2003 12:00:00 AM | 12 | Permit Number 46616 | 6014316.07851 | 2105148.78787 | 37.7611424148166 | -122.393582289386 | (37.7611424148166, -122.393582289386) | 10 | 3 | 8 | 28856 | 29 | |
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 | ||
84021 | 49096 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 550 Davis St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/14/2003 12:00:00 AM | 3 | Permit Number 46244 | 6013227.23366 | 2118310.02974 | 37.7972196135456 | -122.398271600054 | (37.7972196135456, -122.398271600054) | 3 | 1 | 10 | 28860 | 6 | ||
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 | ||
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 | |||
167002 | 48770 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 560 Hayes St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/17/2002 12:00:00 AM | 15 | 3x3 | Permit Number 46028 | 6005170.9549 | 2110973.7304 | 37.7766239145875 | -122.425625959395 | (37.7766239145875, -122.425625959395) | 7 | 9 | 11 | 28852 | 10 | |
105842 | 47786 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 445 Francisco St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/11/2002 12:00:00 AM | 8 | Permit Number 45558 | 6009129.7041 | 2121124.5774 | 37.8047185679867 | -122.41264920319 | (37.8047185679867, -122.41264920319) | 3 | 1 | 10 | 308 | 23 | ||
108020 | 47787 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 445 Francisco St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/11/2002 12:00:00 AM | 7 | Permit Number 45558 | 6009109.534 | 2121122.2501 | 37.8047110457521 | -122.412718839471 | (37.8047110457521, -122.412718839471) | 3 | 1 | 10 | 308 | 23 | ||
168461 | 47789 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 445 Francisco St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/11/2002 12:00:00 AM | 7 | Permit Number 45558 | 6009148.3227 | 2121126.9048 | 37.8047260033811 | -122.412584936044 | (37.8047260033811, -122.412584936044) | 3 | 1 | 10 | 308 | 23 | ||
193333 | 47788 | Permitted Site 7 | Schinus terebinthifolius :: Brazilian Pepper 93 | 445 Francisco St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/11/2002 12:00:00 AM | Permit Number 45558 | 6009171.86340947 | 2121127.78288236 | 37.8047297355065 | -122.412503532854 | (37.8047297355065, -122.412503532854) | 3 | 1 | 10 | 308 | 23 | |||
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 | |||
152570 | 47784 | Permitted Site 7 | Schinus terebinthifolius :: Brazilian Pepper 93 | 411 Francisco St | 2 | 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 | |||
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 | |||
36627 | 47707 | Permitted Site 7 | Schinus terebinthifolius :: Brazilian Pepper 93 | 200 Randall St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 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 | |||
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 | ||
99948 | 47471 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 2950 Bush St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/14/2002 12:00:00 AM | 4 | Permit Number 45372 | 5999383.7039 | 2114336.8457 | 37.7855294507074 | -122.445887611108 | (37.7855294507074, -122.445887611108) | 15 | 6 | 1 | 29490 | 31 | |
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 | |||
121835 | 46759 | Permitted Site 7 | Schinus terebinthifolius :: Brazilian Pepper 93 | 1180X Bush St | 2 | 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 | |||
147347 | 46758 | Permitted Site 7 | Schinus terebinthifolius :: Brazilian Pepper 93 | 1180X Bush St | 3 | 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 | |||
17552 | 46597 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 170St. 09th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/09/2002 12:00:00 AM | 11 | Permit Number 44725 | 5993070.73118 | 2114361.72785 | 37.7852352793736 | -122.467730266741 | (37.7852352793736, -122.467730266741) | 11 | 6 | 2 | 54 | 11 | |
94455 | 46476 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 454 Funston Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/26/2002 12:00:00 AM | 6 | Permit Number 44671 | 5991902.97979 | 2112323.35635 | 37.7795709761183 | -122.471621696685 | (37.7795709761183, -122.471621696685) | 11 | 6 | 2 | 54 | 11 | ||
14424 | 46330 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 548 Stanyan St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/12/2002 12:00:00 AM | 11 | Permit Number 44580 | 5996909.4172 | 2109622.8664 | 37.7724445099575 | -122.454107281383 | (37.7724445099575, -122.454107281383) | 15 | 5 | 11 | 29492 | 16 | ||
189982 | 46329 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 548 Stanyan St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/12/2002 12:00:00 AM | 6 | Permit Number 44580 | 5996911.3335 | 2109610.2187 | 37.7724098925353 | -122.454099739112 | (37.7724098925353, -122.454099739112) | 15 | 5 | 11 | 29492 | 16 | ||
167833 | 44448 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 65 Winding Way | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/23/2001 12:00:00 AM | 6 | Permit Number 43777 | 6002641.71413 | 2086935.0699 | 37.7104761197367 | -122.432657792736 | (37.7104761197367, -122.432657792736) | 9 | 7 | 6 | 28861 | 5 | |
47509 | 43759 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 249 17th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/26/2000 12:00:00 AM | 9 | Permit Number 43395 | 5990535.98179 | 2113705.55195 | 37.7832869196807 | -122.476451677439 | (37.7832869196807, -122.476451677439) | 11 | 6 | 2 | 55 | 26 | ||
83828 | 43760 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 249 17th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/26/2000 12:00:00 AM | 8 | Permit Number 43395 | 5990536.37641 | 2113724.23454 | 37.7833382397577 | -122.476451677446 | (37.7833382397577, -122.476451677446) | 11 | 6 | 2 | 55 | 26 | |
170135 | 43696 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 1539 Anza St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/25/2000 12:00:00 AM | 8 | Permit Number 43340 | 5993847.57781 | 2112069.22957 | 37.7789855246228 | -122.464876090912 | (37.7789855246228, -122.464876090912) | 11 | 6 | 2 | 54 | 11 | |
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 | |
134266 | 43675 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 611 02nd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/25/2000 12:00:00 AM | 10 | Permit Number 43318 | 5995303.58271 | 2111376.81482 | 37.7771681785952 | -122.459789050934 | (37.7771681785952, -122.459789050934) | 11 | 6 | 2 | 54 | 11 | |
189564 | 43657 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 553 10th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/25/2000 12:00:00 AM | 10 | Permit Number 43301 | 5992810.17 | 2111710.04136 | 37.7779394229571 | -122.468438730278 | (37.7779394229571, -122.468438730278) | 11 | 6 | 2 | 54 | 11 | |
99055 | 40859 | Permitted Site 7 | Schinus terebinthifolius :: Brazilian Pepper 93 | 1670 Florida St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/21/2000 12:00:00 AM | Permit Number 42380 | 6009721.65724328 | 2100087.27684169 | 37.7469882750849 | -122.409115329349 | (37.7469882750849, -122.409115329349) | 2 | 7 | 7 | 28859 | 2 | ||
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 | ||
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 | ||
179056 | 41712 | Permitted Site 7 | Schinus terebinthifolius :: Brazilian Pepper 93 | 395 Sussex St | 2 | 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 | ||
175707 | 41649 | Permitted Site 7 | Schinus terebinthifolius :: Brazilian Pepper 93 | 450X Baker St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/07/2000 12:00:00 AM | Permit Number 42121 | 6000751.83853912 | 2110650.06591878 | 37.7754845196238 | -122.440889708326 | (37.7754845196238, -122.440889708326) | 15 | 5 | 11 | 29492 | 10 | |||
108379 | 41627 | Permitted Site 7 | Schinus terebinthifolius :: Brazilian Pepper 93 | 1095 Natoma St | 2 | 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 | |||
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 | |||
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 | ||
163960 | 40639 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 2740 Golden Gate Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/10/1999 12:00:00 AM | 12 | Permit Number 41638 | 5996441.36597 | 2111293.50073 | 37.7770047854178 | -122.455847097036 | (37.7770047854178, -122.455847097036) | 11 | 6 | 2 | 54 | 16 |
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) );