home / trees

Street_Tree_List

Data source: data.sfgov.org

347 rows where qSpecies = 90

View and edit SQL

Suggested facets: qLegalStatus, SiteOrder, qSiteInfo, qCaretaker, PlotSize, Fire Prevention Districts, Police Districts, Supervisor Districts, Zip Codes, Neighborhoods

Link rowid TreeID qLegalStatus qSpecies qAddress SiteOrder qSiteInfo PlantType qCaretaker qCareAssistant PlantDate DBH PlotSize PermitNotes XCoord YCoord Latitude Longitude Location Fire Prevention Districts Police Districts Supervisor Districts Zip Codes Neighborhoods
668 100750 Undocumented 3 Schinus molle :: California Pepper 90 757 Castro St 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     18 3x3   6002448.0 2103795.0 37.75675864052629 -122.434532032094 (37.7567586405263, -122.434532032094) 2 4 5 28862 3
669 100751 Undocumented 3 Schinus molle :: California Pepper 90 767 Castro St 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     18 3x3   6002451.0 2103738.0 37.756602302497704 -122.434517581577 (37.7566023024977, -122.434517581577) 2 4 5 28862 3
3582 103991 DPW Maintained 1 Schinus molle :: California Pepper 90 490 12th Ave 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     14 6X9   5992225.21796 2112091.3837099997 37.7789526802379 -122.470490047579 (37.7789526802379, -122.470490047579) 11 6 2 54 11
3742 104219 Permitted Site 2 Schinus molle :: California Pepper 90 642-652 Castro St 2 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2       3x3   6002365.0 2104465.0 37.7585935873912 -122.434866988999 (37.7585935873912, -122.434866988999) 2 4 5 28862 3
3744 104220 Permitted Site 2 Schinus molle :: California Pepper 90 642-652 Castro St 3 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2       3x3   6002365.0 2104465.0 37.7585935873912 -122.434866988999 (37.7585935873912, -122.434866988999) 2 4 5 28862 3
4248 104775 Undocumented 3 Schinus molle :: California Pepper 90 771 CASTRO ST 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     13 3x3   6002522.3 2103728.6 37.7565805395296 -122.434270328818 (37.7565805395296, -122.434270328818) 2 4 5 28862 3
4249 104776 Undocumented 3 Schinus molle :: California Pepper 90 767 CASTRO ST 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     20 3x3   6002481.8 2103753.5 37.7566466101352 -122.434412172394 (37.7566466101352, -122.434412172394) 2 4 5 28862 3
5768 106612 Significant Tree 4 Schinus molle :: California Pepper 90 1189 TENNESSEE ST   Front Yard : Yard 4 Tree 1 Private 2     55     6015654.1 2103577.3 37.7569017014681 -122.388844893024 (37.7569017014681, -122.388844893024) 10 3 8 28856 29
7008 108112 Permitted Site 2 Schinus molle :: California Pepper 90 690 Page St 4 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2           6003299.112919999 2109682.74913 37.772973252262794 -122.432008994211 (37.7729732522628, -122.432008994211) 15 9 11 29492 10
7833 108931 Undocumented 3 Schinus molle :: California Pepper 90 1099x NATOMA ST 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     10 2x2 Permit Number 774500 6007500.0 2109279.0 37.772101916333 -122.417448958018 (37.772101916333, -122.417448958018) 8 2 9 28853 19
8027 109125 Private 7 Schinus molle :: California Pepper 90 890x CASTRO ST 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     12 3x3   6002411.0 2103002.0 37.754579151967796 -122.434603290485 (37.7545791519678, -122.434603290485) 2 4 5 28862 22
8028 109126 Private 7 Schinus molle :: California Pepper 90 890x CASTRO ST 2 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     4 3x3   6002411.0 2103002.0 37.754579151967796 -122.434603290485 (37.7545791519678, -122.434603290485) 2 4 5 28862 22
8948 110276 Permitted Site 2 Schinus molle :: California Pepper 90 3364 25TH ST 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2   05/15/2015 12:00:00 AM 3 5x5 Permit Number 775124 6007285.0 2101529.0 37.7508101157283 -122.417643266234 (37.7508101157283, -122.417643266234) 2 4 7 28859 19
9971 111384 DPW Maintained 1 Schinus molle :: California Pepper 90 340 Brannan St 2 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     21 3x5   6014593.215419999 2112428.75748 37.7811469919725 -122.393133189548 (37.7811469919725, -122.393133189548) 6 2 9 28856 6
11120 112684 Undocumented 3 Schinus molle :: California Pepper 90 86 STANTON ST 1 Front Yard : Yard 4 Tree 1 Private 2       3x3   6000281.0 2103909.0 37.756948404933794 -122.442034474193 (37.7569484049338, -122.442034474193) 2 4 5 28862 38
11121 112685 Undocumented 3 Schinus molle :: California Pepper 90 86 STANTON ST 2 Front Yard : Yard 4 Tree 1 Private 2       3x3   6000281.0 2103909.0 37.756948404933794 -122.442034474193 (37.7569484049338, -122.442034474193) 2 4 5 28862 38
11122 112686 Undocumented 3 Schinus molle :: California Pepper 90 86 STANTON ST 3 Front Yard : Yard 4 Tree 1 Private 2       3x3   6000281.0 2103909.0 37.756948404933794 -122.442034474193 (37.7569484049338, -122.442034474193) 2 4 5 28862 38
11426 113030 Undocumented 3 Schinus molle :: California Pepper 90 200x ESMERALDA AVE 2 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     10 9x9   6007093.0 2098828.0 37.7433829729046 -122.41811575542 (37.7433829729046, -122.41811575542) 2 7 7 28859 2
13599 115363 Undocumented 3 Schinus molle :: California Pepper 90 1709 REVERE AVE 1 Front Yard : Yard 4 Tree 1 Private 2           6014548.0 2094736.0 37.7325639703463 -122.392051962294 (37.7325639703463, -122.392051962294) 10 3 8 58 1
15515 117357 DPW Maintained 1 Schinus molle :: California Pepper 90 602 Hayes St 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     19 3x3   6004937.66325 2110937.7592700003 37.776511961701296 -122.42643042192101 (37.7765119617013, -122.426430421921) 7 9 11 28852 10
15516 117358 DPW Maintained 1 Schinus molle :: California Pepper 90 602 Hayes St 2 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     18 3x3   6004920.033969999 2110936.2579099997 37.7765068427555 -122.426491299758 (37.7765068427555, -122.426491299758) 7 9 11 28852 10
15672 117533 Undocumented 3 Schinus molle :: California Pepper 90 870 PAGE ST 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2       6x6   6002404.0 2109622.0 37.77275566333571 -122.435100948925 (37.7727556633357, -122.435100948925) 15 5 11 29492 9
17148 119662 Undocumented 3 Schinus molle :: California Pepper 90 699x Missouri St 3 Sidewalk: Property side : Yard 5 Tree 1 Private 2           6013712.0 2104098.0 37.7582235960409 -122.39559792996201 (37.7582235960409, -122.395597929962) 10 3 8 28856 29
17149 119663 Undocumented 3 Schinus molle :: California Pepper 90 699x Missouri St 4 Sidewalk: Property side : Yard 5 Tree 1 Private 2           6013712.0 2104098.0 37.7582235960409 -122.39559792996201 (37.7582235960409, -122.395597929962) 10 3 8 28856 29
17150 119664 Undocumented 3 Schinus molle :: California Pepper 90 699x Missouri St 5 Sidewalk: Property side : Yard 5 Tree 1 Private 2           6013712.0 2104098.0 37.7582235960409 -122.39559792996201 (37.7582235960409, -122.395597929962) 10 3 8 28856 29
17151 119665 Undocumented 3 Schinus molle :: California Pepper 90 699x Missouri St 6 Sidewalk: Property side : Yard 5 Tree 1 Private 2           6013712.0 2104098.0 37.7582235960409 -122.39559792996201 (37.7582235960409, -122.395597929962) 10 3 8 28856 29
17152 119666 Undocumented 3 Schinus molle :: California Pepper 90 699x Missouri St 7 Sidewalk: Property side : Yard 5 Tree 1 Private 2           6013712.0 2104098.0 37.7582235960409 -122.39559792996201 (37.7582235960409, -122.395597929962) 10 3 8 28856 29
17154 119668 Undocumented 3 Schinus molle :: California Pepper 90 699x Missouri St 9 Sidewalk: Property side : Yard 5 Tree 1 Private 2           6013712.0 2104098.0 37.7582235960409 -122.39559792996201 (37.7582235960409, -122.395597929962) 10 3 8 28856 29
19535 122117 DPW Maintained 1 Schinus molle :: California Pepper 90 141 16th Ave 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     10 Width 3ft   5990819.371040001 2114444.89613 37.7853333844834 -122.475525275427 (37.7853333844834, -122.475525275427) 11 6 2 54 26
19973 12257 DPW Maintained 1 Schinus molle :: California Pepper 90 601 Laguna St 1 Sidewalk: Curb side : Cutout 2 Tree 1 DPW 1     12 3X3   6004946.44345 2111002.77203 37.776690967174794 -122.426404678747 (37.7766909671748, -122.426404678747) 7 9 11 28852 10
19983 12258 DPW Maintained 1 Schinus molle :: California Pepper 90 601 Laguna St 2 Sidewalk: Curb side : Cutout 2 Tree 1 DPW 1     12 3X3   6004950.99275 2110977.71573 37.7766224258639 -122.42638715692199 (37.7766224258639, -122.426387156922) 7 9 11 28852 10
20003 12260 DPW Maintained 1 Schinus molle :: California Pepper 90 611 LAGUNA ST 1 Sidewalk: Curb side : Cutout 2 Tree 1 DPW 1     21 3X3   6004921.0 2111005.0 37.7766956463335 -122.42649285387199 (37.7766956463335, -122.426492853872) 7 9 11 28852 10
20106 122720 DPW Maintained 1 Schinus molle :: California Pepper 90 1023 Broadway 2 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2       3x3   6008692.81337 2118287.13673 37.796903132994 -122.41396026495701 (37.796903132994, -122.413960264957) 5 1 10 308 21
20107 122721 DPW Maintained 1 Schinus molle :: California Pepper 90 1023 Broadway 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2       3x3   6008692.81337 2118287.13673 37.796903132994 -122.41396026495701 (37.796903132994, -122.413960264957) 5 1 10 308 21
21816 124365 DPW Maintained 1 Schinus molle :: California Pepper 90 69 Palm Ave 4 Sidewalk: Property side : Yard 5 Tree 1 Private 2     6 Width 2ft   5995847.941980001 2114000.61223 37.7844037185844 -122.458095888318 (37.7844037185844, -122.458095888318) 11 6 1 54 31
34866 136365 DPW Maintained 1 Schinus molle :: California Pepper 90 2624 Greenwich St 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     19 Width 3ft   6000330.31034 2118901.65056 37.7981172142989 -122.442940566381 (37.7981172142989, -122.442940566381) 13 9 1 57 17
34867 136366 DPW Maintained 1 Schinus molle :: California Pepper 90 2323 Greenwich St 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     9 Width 3ft   6001763.72183 2119055.52403 37.7986213292711 -122.437991580064 (37.7986213292711, -122.437991580064) 13 9 1 57 17
34868 136367 DPW Maintained 1 Schinus molle :: California Pepper 90 689 Hayes St 5 : 14 Tree 1 Private 2     16 Width 3ft   6004762.56149 2110859.02755 37.7762858838177 -122.427030540428 (37.7762858838177, -122.427030540428) 7 9 11 28852 10
34869 136368 DPW Maintained 1 Schinus molle :: California Pepper 90 2945 Scott St 4 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     6 Width 4ft   6000986.416069999 2118529.18744 37.797131913463 -122.44064352427601 (37.797131913463, -122.440643524276) 13 9 1 57 17
34870 136369 DPW Maintained 1 Schinus molle :: California Pepper 90 2945 Scott St 3 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     2 Width 4ft   6000984.79842 2118544.66291 37.797174312909796 -122.440650232318 (37.7971743129098, -122.440650232318) 13 9 1 57 17
34872 136370 DPW Maintained 1 Schinus molle :: California Pepper 90 2945 Scott St 2 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     9 Width 4ft   6000983.746830001 2118556.26599 37.797206112027794 -122.440654703763 (37.7972061120278, -122.440654703763) 13 9 1 57 17
34873 136371 DPW Maintained 1 Schinus molle :: California Pepper 90 3518 Webster St 2 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     10 Width 3ft   6002669.2857800005 2120724.92735 37.8032565295236 -122.434977502225 (37.8032565295236, -122.434977502225) 13 9 1 57 17
34874 136372 DPW Maintained 1 Schinus molle :: California Pepper 90 2005 Lyon St 2 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     7 Width 4ft   5999418.04323 2115732.63691 37.7893638888782 -122.445869229291 (37.7893638888782, -122.445869229291) 13 6 1 29490 31
34875 136373 DPW Maintained 1 Schinus molle :: California Pepper 90 2858 Vallejo St 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     6 Width 4ft   5999883.3367800005 2117451.31751 37.7941094908262 -122.444382936819 (37.7941094908262, -122.444382936819) 13 9 1 57 27
34876 136374 DPW Maintained 1 Schinus molle :: California Pepper 90 2858 Vallejo St 2 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     3 Width 4ft   5999876.11536 2117451.30478 37.7941090438496 -122.444407922699 (37.7941090438496, -122.444407922699) 13 9 1 57 27
34877 136375 DPW Maintained 1 Schinus molle :: California Pepper 90 2880 Vallejo St 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     21 Width 4ft   5999802.94718 2117441.8408 37.794078883298894 -122.44466041095 (37.7940788832989, -122.44466041095) 13 9 1 57 27
34878 136376 DPW Maintained 1 Schinus molle :: California Pepper 90 2880 Vallejo St 2 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     25 Width 4ft   5999781.6675 2117438.62155 37.7940688297731 -122.444733809114 (37.7940688297731, -122.444733809114) 13 9 1 57 27
34879 136377 DPW Maintained 1 Schinus molle :: California Pepper 90 633 Taylor St 4 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     5 Width 4ft   6009222.09013 2115205.65792 37.7884718549403 -122.41191097001999 (37.7884718549403, -122.41191097002) 5 1 10 28852 21
34880 136378 DPW Maintained 1 Schinus molle :: California Pepper 90 1 Nob Hill Pl 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     9 Width 2ft   6009539.87257 2116302.4428 37.7915011843851 -122.410888982239 (37.7915011843851, -122.410888982239) 5 1 10 28857 21
34881 136379 DPW Maintained 1 Schinus molle :: California Pepper 90 1 Nob Hill Pl 2 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     10 Width 1ft   6009499.81555 2116296.9575099996 37.7914838769232 -122.411027191854 (37.7914838769232, -122.411027191854) 5 1 10 28857 21
34883 136380 DPW Maintained 1 Schinus molle :: California Pepper 90 1023 Broadway 1 Sidewalk: Curb side : Pot 3 Tree 1 Private 2     12 Width 3ft   6008680.39017 2118276.96424 37.7968745041214 -122.414002532311 (37.7968745041214, -122.414002532311) 5 1 10 308 21
34884 136381 DPW Maintained 1 Schinus molle :: California Pepper 90 1023 Broadway 2 Sidewalk: Curb side : Pot 3 Tree 1 Private 2     15 Width 3ft   6008695.6423 2118278.0740799997 37.7968784080765 -122.413949834731 (37.7968784080765, -122.413949834731) 5 1 10 308 21
34885 136382 DPW Maintained 1 Schinus molle :: California Pepper 90 1015 Vallejo St 1 Front Yard : Yard 4 Tree 1 Private 2     14     6008613.871780001 2118642.82165 37.7978753218528 -122.414258600758 (37.7978753218528, -122.414258600758) 5 1 10 308 21
37097 138851 DPW Maintained 1 Schinus molle :: California Pepper 90 602 Hayes St 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     18 Width 0ft   6004934.5518 2110939.3444 37.7765161381936 -122.426441298216 (37.7765161381936, -122.426441298216) 7 9 11 28852 10
37098 138852 DPW Maintained 1 Schinus molle :: California Pepper 90 604 Hayes St 2 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     17 Width 0ft   6004921.1795 2110937.9117 37.776511448416 -122.42648745482401 (37.776511448416, -122.426487454824) 7 9 11 28852 10
37102 138856 DPW Maintained 1 Schinus molle :: California Pepper 90 601 LAGUNA ST 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     20 Width 0ft   6004940.3956 2111052.9695 37.7768284552741 -122.426429175067 (37.7768284552741, -122.426429175067) 7 9 11 28852 10
37104 138858 DPW Maintained 1 Schinus molle :: California Pepper 90 601 LAGUNA ST 3 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     14 Width 0ft   6004946.3367 2111001.3561 37.7766870733429 -122.42640494718701 (37.7766870733429, -122.426404947187) 7 9 11 28852 10
37105 138859 DPW Maintained 1 Schinus molle :: California Pepper 90 601 LAGUNA ST 4 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     12 Width 0ft   6004948.1933 2110978.3343 37.7766239660594 -122.426396885095 (37.7766239660594, -122.426396885095) 7 9 11 28852 10
40802 142226 DPW Maintained 1 Schinus molle :: California Pepper 90 542 LINDEN ST 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     15 Width 0ft   6004780.8856 2110726.6251 37.77592337522171 -122.426957720143 (37.7759233752217, -122.426957720143) 7 9 11 28852 10
40815 142238 DPW Maintained 1 Schinus molle :: California Pepper 90 689 HAYES ST 5 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     15 Width 0ft   6004757.5201 2110863.998 37.776299246383 -122.42704833409701 (37.776299246383, -122.427048334097) 7 9 11 28852 10
43630 15661 DPW Maintained 1 Schinus molle :: California Pepper 90 3900 Mission St 1 Sidewalk: Curb side : Cutout 2 Tree 1 DPW 1     12 3X3   6005100.74203 2095958.2472700002 37.7353909444416 -122.42480036428499 (37.7353909444416, -122.424800364285) 2 7 5 28859 2
43631 156622 DPW Maintained 1 Schinus molle :: California Pepper 90 1245 South Van Ness Ave 5 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2   05/08/2017 12:00:00 AM 3 3x3 Permit Number 779528 6007708.675369999 2102405.4758099997 37.75324055131961 -122.416240224501 (37.7532405513196, -122.416240224501) 2 4 7 28859 19
44771 166073 DPW Maintained 1 Schinus molle :: California Pepper 90 920X Shotwell St 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2   05/08/2017 12:00:00 AM 3 3x3 Permit Number 779528 6007731.0 2102403.0 37.753235008598104 -122.416162845847 (37.7532350085981, -122.416162845847) 2 4 7 28859 19
45644 173720 DPW Maintained 1 Schinus molle :: California Pepper 90 1799x 25th St 1 Sidewalk: Property side : Cutout 9 Tree 1 Private 2           6013424.0 2101939.0 37.752279425117294 -122.396442635345 (37.7522794251173, -122.396442635345) 10 3 8 28856 1
45647 173723 DPW Maintained 1 Schinus molle :: California Pepper 90 1799x 25th St 2 Sidewalk: Property side : Cutout 9 Tree 1 Private 2           6013424.0 2101939.0 37.752279425117294 -122.396442635345 (37.7522794251173, -122.396442635345) 10 3 8 28856 1
45648 173724 DPW Maintained 1 Schinus molle :: California Pepper 90 1101 Connecticut St 1 Sidewalk: Property side : Cutout 9 Tree 1 Private 2           6013424.0 2101939.0 37.752279425117294 -122.396442635345 (37.7522794251173, -122.396442635345) 10 3 8 28856 1
50729 179423 DPW Maintained 1 Schinus molle :: California Pepper 90 103 Vienna St 1 Sidewalk: Property side : Yard 5 Tree 1 Private 2     18     6004767.8211199995 2092745.1735900003 37.7265497503523 -122.425722776001 (37.7265497503523, -122.425722776001) 9 7 6 28861 5
50730 179424 DPW Maintained 1 Schinus molle :: California Pepper 90 367 Madison St 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     13 Width 2ft   6005868.0 2092014.0 37.7246042151677 -122.421867578972 (37.7246042151677, -122.421867578972) 9 7 7 309 5
54592 183549 DPW Maintained 1 Schinus molle :: California Pepper 90 2593 23rd Ave 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     8 Width 0ft   5989226.3762 2097721.7265 37.739323615261895 -122.47981234482799 (37.7393236152619, -122.479812344828) 1 8 3 29491 35
54594 183550 DPW Maintained 1 Schinus molle :: California Pepper 90 2593 23rd Ave 2 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     13 Width 0ft   5989227.3726 2097702.4617 37.7392707770079 -122.479807490437 (37.7392707770079, -122.479807490437) 1 8 3 29491 35
58723 187546 DPW Maintained 1 Schinus molle :: California Pepper 90 1399 Somerset St 2 Side Yard : Yard 27 Tree 1 Private 2     24     6011366.67431 2088362.22575 37.7148857547405 -122.402602582141 (37.7148857547405, -122.402602582141) 10 7 8 309 39
58732 187554 DPW Maintained 1 Schinus molle :: California Pepper 90 3960 Somerset St 3 Side Yard : Yard 27 Tree 1 Private 2     12     6011368.52295 2088357.8500700002 37.71487384321561 -122.40259588490801 (37.7148738432156, -122.402595884908) 10 7 8 309 39
58733 187555 DPW Maintained 1 Schinus molle :: California Pepper 90 3960 Somerset St 2 Side Yard : Yard 27 Tree 1 Private 2     5     6011363.78669 2088352.3188099999 37.714858391064 -122.40261186676202 (37.714858391064, -122.402611866762) 10 7 8 309 39
58734 187556 DPW Maintained 1 Schinus molle :: California Pepper 90 3960 Somerset St 3 Side Yard : Yard 27 Tree 1 Private 2     23     6011365.57696 2088364.56073 37.7148921048592 -122.40260653916599 (37.7148921048592, -122.402606539166) 10 7 8 309 39
69107 19714 DPW Maintained 1 Schinus molle :: California Pepper 90 100 STAIRWAY13 12 Sidewalk: Curb side : Cutout 2 Tree 1 DPW 1     12 40ST                      
69485 197482 DPW Maintained 1 Schinus molle :: California Pepper 90 99 Lafayette St 1 : 14 Tree 1 Private 2     10 Width 3ft   6007465.83226 2109669.87011 37.773173230398505 -122.417594855315 (37.7731732303985, -122.417594855315) 8 2 9 28853 19
69486 197483 DPW Maintained 1 Schinus molle :: California Pepper 90 99 Lafayette St 2 : 14 Tree 1 Private 2     7 Width 3ft   6007475.11808 2109661.30518 37.7731502356402 -122.417562127216 (37.7731502356402, -122.417562127216) 8 2 9 28853 19
69487 197484 DPW Maintained 1 Schinus molle :: California Pepper 90 99 Lafayette St 3 : 14 Tree 1 Private 2     8 Width 3ft   6007489.31465 2109652.98843 37.7731281986314 -122.417512429769 (37.7731281986314, -122.417512429769) 8 2 9 28853 19
69488 197485 DPW Maintained 1 Schinus molle :: California Pepper 90 15 Lafayette St 2 : 14 Tree 1 Private 2     13 Width 3ft   6007471.02195 2109700.81958 37.773258502312004 -122.41757909741301 (37.773258502312, -122.417579097413) 8 2 9 28853 19
69489 197486 DPW Maintained 1 Schinus molle :: California Pepper 90 1112 Tennessee St 2 Sidewalk: Curb side : Pot 3 Tree 1 Private 2     19 Width 6ft   6015516.35006 2103817.5314599997 37.757553689956104 -122.389338063096 (37.7575536899561, -122.389338063096) 10 3 8 28856 29
69490 197487 DPW Maintained 1 Schinus molle :: California Pepper 90 1301 Minnesota St 28 Front Yard : Yard 4 Tree 1 Private 2     11     6015378.84744 2102468.94598 37.75384313667529 -122.389719416144 (37.7538431366753, -122.389719416144) 10 3 8 28856 29
69491 197488 DPW Maintained 1 Schinus molle :: California Pepper 90 1301 Minnesota St 29 Front Yard : Yard 4 Tree 1 Private 2     9     6015374.95978 2102473.44448 37.753855273024996 -122.38973317486601 (37.753855273025, -122.389733174866) 10 3 8 28856 29
69492 197489 DPW Maintained 1 Schinus molle :: California Pepper 90 1301 Minnesota St 42 Front Yard : Yard 4 Tree 1 Private 2     8     6015361.30396 2102471.04633 37.753847930956 -122.389780232768 (37.753847930956, -122.389780232768) 10 3 8 28856 29
69494 197490 DPW Maintained 1 Schinus molle :: California Pepper 90 1301 Minnesota St 43 Front Yard : Yard 4 Tree 1 Private 2     13     6015358.4418 2102466.66646 37.75383574604229 -122.38978982496 (37.7538357460423, -122.38978982496) 10 3 8 28856 29
69495 197491 DPW Maintained 1 Schinus molle :: California Pepper 90 900x Carolina St 23 Median : Yard 11 Tree 1 DPW 1     1     6012477.42612 2103497.4714900004 37.756505926715604 -122.39982548288499 (37.7565059267156, -122.399825482885) 10 3 8 28856 29
69496 197492 DPW Maintained 1 Schinus molle :: California Pepper 90 1501 25th St 20 Sidewalk: Curb side : Yard 7 Tree 1 Private 2     7     6014180.0421 2101964.05724 37.7523902711102 -122.393829855665 (37.7523902711102, -122.393829855665) 10 3 8 28856 1
69497 197493 DPW Maintained 1 Schinus molle :: California Pepper 90 950x Kansas St 7 Median : Yard 11 Tree 1 DPW 1     25     6011595.701219999 2103803.27065 37.7572963894245 -122.402896325021 (37.7572963894245, -122.402896325021) 10 3 8 28856 29
69498 197494 DPW Maintained 1 Schinus molle :: California Pepper 90 401 Texas St 3 : 14 Tree 1 Private 2     23 Width 7ft   6013811.84722 2105166.53521 37.7611631145139 -122.395327465206 (37.7611631145139, -122.395327465206) 10 3 8 28856 29
69499 197495 DPW Maintained 1 Schinus molle :: California Pepper 90 651 Missouri St 15 Sidewalk: Property side : Yard 5 Tree 1 Private 2     9     6013600.82032 2103923.07952 37.757737117488 -122.39597018278 (37.757737117488, -122.39597018278) 10 3 8 28856 29
69500 197496 DPW Maintained 1 Schinus molle :: California Pepper 90 651 Missouri St 17 Sidewalk: Property side : Yard 5 Tree 1 Private 2     11     6013599.60524 2103941.4739 37.757787556858396 -122.395975674052 (37.7577875568584, -122.395975674052) 10 3 8 28856 29
69501 197497 DPW Maintained 1 Schinus molle :: California Pepper 90 651 Missouri St 18 Sidewalk: Property side : Yard 5 Tree 1 Private 2     14     6013599.1640099995 2103957.68535 37.7578320454303 -122.395978336045 (37.7578320454303, -122.395978336045) 10 3 8 28856 29
69502 197498 DPW Maintained 1 Schinus molle :: California Pepper 90 651 Missouri St 22 Sidewalk: Property side : Yard 5 Tree 1 Private 2     9     6013596.26371 2103973.9911700003 37.757876656309 -122.395989509211 (37.757876656309, -122.395989509211) 10 3 8 28856 29
69503 197499 DPW Maintained 1 Schinus molle :: California Pepper 90 651 Missouri St 23 Sidewalk: Property side : Yard 5 Tree 1 Private 2     18     6013595.97387 2103991.32166 37.7579242259433 -122.395991726059 (37.7579242259433, -122.395991726059) 10 3 8 28856 29
69506 197500 DPW Maintained 1 Schinus molle :: California Pepper 90 651 Missouri St 25 Sidewalk: Property side : Yard 5 Tree 1 Private 2     16     6013593.70141 2104032.4139 37.7580369298728 -122.39600246484301 (37.7580369298728, -122.396002464843) 10 3 8 28856 29
69507 197501 DPW Maintained 1 Schinus molle :: California Pepper 90 1101 Connecticut St 2 Sidewalk: Property side : Yard 5 Tree 1 Private 2     7 Width 8ft   6013434.27998 2101904.95506 37.752186517095 -122.396404699215 (37.752186517095, -122.396404699215) 10 3 8 28856 1
69508 197502 DPW Maintained 1 Schinus molle :: California Pepper 90 1799 25th St 1 Sidewalk: Property side : Yard 5 Tree 1 Private 2     7 Width 8ft   6013459.5308300005 2101928.68892 37.752253090306 -122.396319040597 (37.752253090306, -122.396319040597) 10 3 8 28856 1
69509 197503 DPW Maintained 1 Schinus molle :: California Pepper 90 1799 25th St 2 Sidewalk: Property side : Yard 5 Tree 1 Private 2     9 Width 8ft   6013488.947000001 2101929.3256099997 37.752256475356496 -122.396217358746 (37.7522564753565, -122.396217358746) 10 3 8 28856 1
69510 197504 DPW Maintained 1 Schinus molle :: California Pepper 90 1798 Revere Ave 2 Sidewalk: Curb side : Yard 7 Tree 1 Private 2     12     6014086.53204 2095170.8346099998 37.733732305508 -122.39367780459601 (37.733732305508, -122.393677804596) 10 3 8 58 1
69511 197505 DPW Maintained 1 Schinus molle :: California Pepper 90 1705 Newcomb Ave 1 Sidewalk: Curb side : Yard 7 Tree 1 Private 2     10 Width 4ft   6014625.38984 2096105.59346 37.7363288910633 -122.39188013985901 (37.7363288910633, -122.391880139859) 10 3 8 58 1
69512 197506 DPW Maintained 1 Schinus molle :: California Pepper 90 1079 Le Conte Ave 7 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     3 Width 4ft   6012767.16405 2089807.7528400002 37.718932973745396 -122.397863208018 (37.7189329737454, -122.397863208018) 10 3 8 58 1

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

CREATE TABLE "Street_Tree_List" (
"TreeID" INTEGER,
  "qLegalStatus" INTEGER,
  "qSpecies" INTEGER,
  "qAddress" TEXT,
  "SiteOrder" INTEGER,
  "qSiteInfo" INTEGER,
  "PlantType" INTEGER,
  "qCaretaker" INTEGER,
  "qCareAssistant" INTEGER,
  "PlantDate" REAL,
  "DBH" INTEGER,
  "PlotSize" TEXT,
  "PermitNotes" REAL,
  "XCoord" REAL,
  "YCoord" REAL,
  "Latitude" REAL,
  "Longitude" REAL,
  "Location" TEXT,
  "Fire Prevention Districts" INTEGER,
  "Police Districts" INTEGER,
  "Supervisor Districts" INTEGER,
  "Zip Codes" INTEGER,
  "Neighborhoods" INTEGER
,
FOREIGN KEY ("PlantType") REFERENCES [PlantType](id),
    FOREIGN KEY ("qCareAssistant") REFERENCES [qCareAssistant](id),
    FOREIGN KEY ("qCaretaker") REFERENCES [qCaretaker](id),
    FOREIGN KEY ("qLegalStatus") REFERENCES [qLegalStatus](id),
    FOREIGN KEY ("qSiteInfo") REFERENCES [qSiteInfo](id),
    FOREIGN KEY ("qSpecies") REFERENCES [qSpecies](id))
Powered by Datasette · Query took 33.012ms · Data source: data.sfgov.org