Street_Tree_List

Data source: data.sfgov.org

6,952 rows where qSpecies = 26 sorted by XCoord descending

View and edit SQL

Suggested facets: qLegalStatus, qSiteInfo, PlantType, qCaretaker, qCareAssistant

Link rowid TreeID qLegalStatus qSpecies qAddress SiteOrder qSiteInfo PlantType qCaretaker qCareAssistant PlantDate DBH PlotSize PermitNotes XCoord ▲ YCoord Latitude Longitude Location
161660 49773 Permitted Site 1 Pittosporum undulatum :: Victorian Box 26 991@ HAWES Innes Ave 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   06/09/2003 12:00:00 AM 5   Permit Number 46560 6018765.60896 2094758.8067599998 37.7328598551943 -122.377472089671 (37.7328598551943, -122.377472089671)
50871 200017 Undocumented 2 Pittosporum undulatum :: Victorian Box 26 1011 Quesada Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     3 Width 0ft   6018377.4011 2092259.3357 37.7259753973207 -122.37864074577601 (37.7259753973207, -122.378640745776)
75282 200016 Undocumented 2 Pittosporum undulatum :: Victorian Box 26 1015 Quesada Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     3 Width 0ft   6018332.7975 2092292.5025 37.7260640079993 -122.37879724133002 (37.7260640079993, -122.37879724133)
70005 199984 Undocumented 2 Pittosporum undulatum :: Victorian Box 26 1049 Quesada Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     3 Width 0ft   6018239.0156 2092359.9798 37.7262441168546 -122.37912612762501 (37.7262441168546, -122.379126127625)
62520 200020 Undocumented 2 Pittosporum undulatum :: Victorian Box 26 1018 Revere Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     4 Width 0ft   6018197.6822 2092123.3004 37.7255919615614 -122.379252584385 (37.7255919615614, -122.379252584385)
75702 199986 Undocumented 2 Pittosporum undulatum :: Victorian Box 26 1036 Revere Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     4 Width 0ft   6018125.6646 2092187.1055 37.7257631863869 -122.37950597633899 (37.7257631863869, -122.379505976339)
60144 199964 Undocumented 2 Pittosporum undulatum :: Victorian Box 26 1235 Griffith St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     8 Width 0ft   6018047.3207 2092773.5801 37.7273692110952 -122.37981753792299 (37.7273692110952, -122.379817537923)
24693 199963 Undocumented 2 Pittosporum undulatum :: Victorian Box 26 1265 Griffith St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     5 Width 0ft   6018034.5896 2092755.7565 37.7273195686648 -122.37986031192499 (37.7273195686648, -122.379860311925)
36859 199990 Undocumented 2 Pittosporum undulatum :: Victorian Box 26 1062 Revere Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     4 Width 0ft   6018021.4286 2092264.1769 37.7259690601423 -122.379871668847 (37.7259690601423, -122.379871668847)
42899 199992 Undocumented 2 Pittosporum undulatum :: Victorian Box 26 1074 Revere Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     5 Width 0ft   6017970.2582 2092302.0809 37.7260703143434 -122.380051196154 (37.7260703143434, -122.380051196154)
75309 199959 Undocumented 2 Pittosporum undulatum :: Victorian Box 26 1250 Griffith St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     7 Width 0ft   6017944.0607 2092712.7775 37.727196562406604 -122.380170287962 (37.7271965624066, -122.380170287962)
30855 199993 Undocumented 2 Pittosporum undulatum :: Victorian Box 26 1082 Revere Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     6 Width 0ft   6017934.2494 2092328.6137 37.726141181664204 -122.380177520727 (37.7261411816642, -122.380177520727)
156315 199994 Undocumented 2 Pittosporum undulatum :: Victorian Box 26 1088 Revere Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     6 Width 0ft   6017897.6089 2092357.0417 37.7262172178466 -122.38030616096901 (37.7262172178466, -122.380306160969)
32408 49732 Permitted Site 1 Pittosporum undulatum :: Victorian Box 26 1300@ REVERE Griffith St 8 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 06/04/2003 12:00:00 AM     Permit Number 46533 6017891.63282432 2092647.03396297 37.727013150708 -122.380346965446 (37.727013150708, -122.380346965446)
86620 49731 Permitted Site 1 Pittosporum undulatum :: Victorian Box 26 1300@ REVERE Griffith St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   06/04/2003 12:00:00 AM     Permit Number 46533 6017891.63282432 2092647.03396297 37.727013150708 -122.380346965446 (37.727013150708, -122.380346965446)
88706 49725 Permitted Site 1 Pittosporum undulatum :: Victorian Box 26 1300@ REVERE Griffith St 6 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 06/04/2003 12:00:00 AM     Permit Number 46533 6017891.63282432 2092647.03396297 37.727013150708 -122.380346965446 (37.727013150708, -122.380346965446)
91757 49730 Permitted Site 1 Pittosporum undulatum :: Victorian Box 26 1300@ REVERE Griffith St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   06/04/2003 12:00:00 AM     Permit Number 46533 6017891.63282432 2092647.03396297 37.727013150708 -122.380346965446 (37.727013150708, -122.380346965446)
102594 49722 Permitted Site 1 Pittosporum undulatum :: Victorian Box 26 1300@ REVERE Griffith St 11 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   06/04/2003 12:00:00 AM     Permit Number 46533 6017891.63282432 2092647.03396297 37.727013150708 -122.380346965446 (37.727013150708, -122.380346965446)
106160 49729 Permitted Site 1 Pittosporum undulatum :: Victorian Box 26 1300@ REVERE Griffith St 5 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   06/04/2003 12:00:00 AM     Permit Number 46533 6017891.63282432 2092647.03396297 37.727013150708 -122.380346965446 (37.727013150708, -122.380346965446)
110226 49726 Permitted Site 1 Pittosporum undulatum :: Victorian Box 26 1300@ REVERE Griffith St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   06/04/2003 12:00:00 AM     Permit Number 46533 6017891.63282432 2092647.03396297 37.727013150708 -122.380346965446 (37.727013150708, -122.380346965446)
114093 49727 Permitted Site 1 Pittosporum undulatum :: Victorian Box 26 1300@ REVERE Griffith St 9 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 06/04/2003 12:00:00 AM     Permit Number 46533 6017891.63282432 2092647.03396297 37.727013150708 -122.380346965446 (37.727013150708, -122.380346965446)
129352 49723 Permitted Site 1 Pittosporum undulatum :: Victorian Box 26 1300@ REVERE Griffith St 7 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 06/04/2003 12:00:00 AM     Permit Number 46533 6017891.63282432 2092647.03396297 37.727013150708 -122.380346965446 (37.727013150708, -122.380346965446)
138899 49728 Permitted Site 1 Pittosporum undulatum :: Victorian Box 26 1300@ REVERE Griffith St 10 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   06/04/2003 12:00:00 AM     Permit Number 46533 6017891.63282432 2092647.03396297 37.727013150708 -122.380346965446 (37.727013150708, -122.380346965446)
141657 49724 Permitted Site 1 Pittosporum undulatum :: Victorian Box 26 1300@ REVERE Griffith St 4 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   06/04/2003 12:00:00 AM     Permit Number 46533 6017891.63282432 2092647.03396297 37.727013150708 -122.380346965446 (37.727013150708, -122.380346965446)
183453 75364 Undocumented 2 Pittosporum undulatum :: Victorian Box 26 1335 Griffith St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 06/13/1998 12:00:00 AM 4     6017823.2525 2092467.3959 37.7265161261373 -122.38057087677299 (37.7265161261373, -122.380570876773)
54594 75439 Undocumented 2 Pittosporum undulatum :: Victorian Box 26 1335 Griffith St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 06/13/1998 12:00:00 AM 8     6017811.7945 2092449.5723 37.7264665536825 -122.380609248682 (37.7264665536825, -122.380609248682)
156888 200012 Undocumented 2 Pittosporum undulatum :: Victorian Box 26 1401 Griffith St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     6 Width 0ft   6017723.9495 2092325.4436 37.726120872223 -122.380904302696 (37.726120872223, -122.380904302696)
54093 200022 Undocumented 2 Pittosporum undulatum :: Victorian Box 26 1524 Griffith St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     4 Width 0ft   6017517.7049 2092135.1129 37.7255868755216 -122.381604054782 (37.7255868755216, -122.381604054782)
42953 195013 Undocumented 2 Pittosporum undulatum :: Victorian Box 26 15 Reuel Ct 10 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     5 Width 3ft   6017390.87176 2096051.0695099998 37.7363323183897 -122.38231482826599 (37.7363323183897, -122.382314828266)
112724 18651 DPW Maintained 3 Pittosporum undulatum :: Victorian Box 26 75 Reuel Ct 2 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     12 3X4   6017333.617127299 2096134.4813376998 37.736558188021704 -122.38251858534201 (37.7365581880217, -122.382518585342)
85089 18648 Permitted Site 1 Pittosporum undulatum :: Victorian Box 26 65 Reuel Ct 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     12 3X4   6017293.842190401 2096150.8170108001 37.7366008452399 -122.382657242033 (37.7366008452399, -122.382657242033)
57650 195012 Undocumented 2 Pittosporum undulatum :: Victorian Box 26 15 Reuel Ct 8 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     7 Width 3ft   6017279.93049 2096066.8069900002 37.736369401921294 -122.382699497078 (37.7363694019213, -122.382699497078)
79187 18645 Permitted Site 1 Pittosporum undulatum :: Victorian Box 26 55 Reuel Ct 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   11/18/2016 12:00:00 AM 3 3X4   6017250.7089794995 2096167.8793555999 37.736645312048296 -122.38280756055401 (37.7366453120483, -122.382807560554)
123476 18646 Permitted Site 1 Pittosporum undulatum :: Victorian Box 26 55 Reuel Ct 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     12 3X4   6017250.7089794995 2096167.8793555999 37.736645312048296 -122.38280756055401 (37.7366453120483, -122.382807560554)
75909 195011 Undocumented 2 Pittosporum undulatum :: Victorian Box 26 15 Reuel Ct 7 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     6 Width 3ft   6017245.52406 2096081.9202599998 37.7364089990626 -122.382819507108 (37.7364089990626, -122.382819507108)
35062 195010 Undocumented 2 Pittosporum undulatum :: Victorian Box 26 15 Reuel Ct 6 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     10 Width 3ft   6017232.0776 2096087.6847599999 37.7364240843076 -122.38286639867701 (37.7364240843076, -122.382866398677)
88894 18644 Permitted Site 1 Pittosporum undulatum :: Victorian Box 26 45 Reuel Ct 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     6 3X4   6017209.0785081 2096178.6405669 37.7366725600424 -122.382952245184 (37.7366725600424, -122.382952245184)
165108 195009 Undocumented 2 Pittosporum undulatum :: Victorian Box 26 15 Reuel Ct 5 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     13 Width 3ft   6017206.74731 2096096.89291 37.736447968491895 -122.382954617674 (37.7364479684919, -122.382954617674)
61621 195008 Undocumented 2 Pittosporum undulatum :: Victorian Box 26 15 Reuel Ct 4 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     14 Width 3ft   6017180.419369999 2096102.2295 37.736461166953 -122.38304601668699 (37.736461166953, -122.383046016687)
120843 18639 DPW Maintained 3 Pittosporum undulatum :: Victorian Box 26 25 Reuel Ct 3 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     6 3X4   6017121.136185501 2096199.8633465 37.736725974033604 -122.383257779638 (37.7367259740336, -122.383257779638)
26123 195007 Undocumented 2 Pittosporum undulatum :: Victorian Box 26 15 Reuel Ct 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     11 Width 3ft   6017052.07909 2096111.26118 37.736478873694 -122.38349037620002 (37.736478873694, -122.3834903762)
175311 194985 Undocumented 2 Pittosporum undulatum :: Victorian Box 26 2 Progress St 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     14 Width 4ft   6017047.98136 2094998.67285 37.7334237013335 -122.383427116962 (37.7334237013335, -122.383427116962)
158891 194763 Undocumented 2 Pittosporum undulatum :: Victorian Box 26 1355 Fairfax Ave 2 : 4 Tree 1 Private 1     7 Width 3ft   6016963.142659999 2097148.26194 37.739321353692496 -122.383870053768 (37.7393213536925, -122.383870053768)
135926 195016 Undocumented 2 Pittosporum undulatum :: Victorian Box 26 1355 Fairfax Ave 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     6 Width 3ft   6016962.32764 2097150.27135 37.7393268260728 -122.38387301165001 (37.7393268260728, -122.38387301165)
117032 199771 Undocumented 2 Pittosporum undulatum :: Victorian Box 26 1639 Hawes St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     13 Width 0ft   6016879.1133 2092313.6857 37.7260419216039 -122.38382406242701 (37.7260419216039, -122.383824062427)
166517 199772 Undocumented 2 Pittosporum undulatum :: Victorian Box 26 1639 Hawes St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     9 Width 0ft   6016857.0794 2092287.7958 37.7259696149574 -122.38389843107599 (37.7259696149574, -122.383898431076)
168561 194998 Undocumented 2 Pittosporum undulatum :: Victorian Box 26 11 Dedman Ct 13 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     16 Width 3ft   6016853.523580001 2096150.4450700001 37.7365754887703 -122.384179601306 (37.7365754887703, -122.384179601306)
135011 199773 Undocumented 2 Pittosporum undulatum :: Victorian Box 26 1639 Hawes St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     10 Width 0ft   6016840.0031 2092265.7618 37.7259081698836 -122.383955929707 (37.7259081698836, -122.383955929707)
30455 199775 Undocumented 2 Pittosporum undulatum :: Victorian Box 26 1641 Hawes St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     10 Width 0ft   6016825.681 2092249.2364 37.725862002585 -122.384004290492 (37.725862002585, -122.384004290492)
43453 194997 Undocumented 2 Pittosporum undulatum :: Victorian Box 26 11 Dedman Ct 12 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     1 Width 3ft   6016824.43505 2096171.98497 37.7366330246822 -122.384281673458 (37.7366330246822, -122.384281673458)
31395 194999 Undocumented 2 Pittosporum undulatum :: Victorian Box 26 11 Dedman Ct 14 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     2 Width 3ft   6016818.43135 2096263.7409 37.7368846361018 -122.38430881949199 (37.7368846361018, -122.384308819492)
183609 199779 Undocumented 2 Pittosporum undulatum :: Victorian Box 26 1651 Hawes St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     5 Width 0ft   6016800.3419 2092212.8803 37.7257607749493 -122.384089356217 (37.7257607749493, -122.384089356217)
57562 194996 Undocumented 2 Pittosporum undulatum :: Victorian Box 26 11 Dedman Ct 11 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     10 Width 3ft   6016795.74249 2096197.5825200002 37.7367017238936 -122.384382659238 (37.7367017238936, -122.384382659238)
86017 26661 Permitted Site 1 Pittosporum undulatum :: Victorian Box 26 1355 Fairfax Ave 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   03/10/2007 12:00:00 AM 6 3x3   6016787.8631263 2097291.0360598997 37.7397036915046 -122.38448604022699 (37.7397036915046, -122.384486040227)
127521 46249 Permitted Site 1 Pittosporum undulatum :: Victorian Box 26 1675 Hawes St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   01/11/2002 12:00:00 AM     Permit Number 44536 6016787.6752368 2092188.79463336 37.7256939401069 -122.384131467798 (37.7256939401069, -122.384131467798)
127542 46250 Permitted Site 1 Pittosporum undulatum :: Victorian Box 26 1675 Hawes St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   01/11/2002 12:00:00 AM     Permit Number 44536 6016787.6752368 2092188.79463336 37.7256939401069 -122.384131467798 (37.7256939401069, -122.384131467798)
55300 199778 Undocumented 2 Pittosporum undulatum :: Victorian Box 26 1699 Hawes St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     5 Width 0ft   6016784.3673 2092190.2955 37.725697878302704 -122.38414300766 (37.7256978783027, -122.38414300766)
161106 199777 Undocumented 2 Pittosporum undulatum :: Victorian Box 26 1699 Hawes St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     4 Width 0ft   6016770.5961 2092171.5667 37.7256456912793 -122.384189310378 (37.7256456912793, -122.384189310378)
40617 195000 Undocumented 2 Pittosporum undulatum :: Victorian Box 26 11 Dedman Ct 15 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     2 Width 3ft   6016757.63596 2096301.5565 37.7369851083784 -122.384521651269 (37.7369851083784, -122.384521651269)
148878 195001 Undocumented 2 Pittosporum undulatum :: Victorian Box 26 11 Dedman Ct 16 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     2 Width 3ft   6016715.85177 2096316.47187 37.7370237522504 -122.384667157956 (37.7370237522504, -122.384667157956)
156376 194995 Undocumented 2 Pittosporum undulatum :: Victorian Box 26 11 Dedman Ct 10 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     1 Width 3ft   6016711.28945 2096245.88288 37.736829676747 -122.38467801638599 (37.736829676747, -122.384678016386)
113013 4949 DPW Maintained 3 Pittosporum undulatum :: Victorian Box 26 64 Dedman Ct 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   11/16/2013 12:00:00 AM 3     6016704.369281599 2096233.9145978 37.736796431530706 -122.38470110921999 (37.7367964315307, -122.38470110922)
172606 194994 Undocumented 2 Pittosporum undulatum :: Victorian Box 26 11 Dedman Ct 9 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     13 Width 3ft   6016695.66804 2096249.95032 37.7368399811784 -122.384732310246 (37.7368399811784, -122.384732310246)
144096 4948 DPW Maintained 3 Pittosporum undulatum :: Victorian Box 26 60 Dedman Ct 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     12 3X4   6016685.2053972 2096242.6447012 37.7368193427664 -122.38476797578001 (37.7368193427664, -122.38476797578)
179144 195002 Undocumented 2 Pittosporum undulatum :: Victorian Box 26 11 Dedman Ct 17 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     2 Width 3ft   6016680.46739 2096324.02955 37.737042547164 -122.384790025147 (37.737042547164, -122.384790025147)
76818 4947 DPW Maintained 3 Pittosporum undulatum :: Victorian Box 26 56 Dedman Ct 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   11/16/2013 12:00:00 AM 3 3X4   6016676.771982799 2096248.5036614 37.73683496386511 -122.384797542111 (37.7368349638651, -122.384797542111)
47280 3838 DPW Maintained 3 Pittosporum undulatum :: Victorian Box 26 55X Dedman Ct 6 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   11/16/2013 12:00:00 AM 3 3X4   6016670.3231407 2096336.3389693 37.7370757852971 -122.38482595599 (37.7370757852971, -122.38482595599)
83375 3836 DPW Maintained 3 Pittosporum undulatum :: Victorian Box 26 55X Dedman Ct 4 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     12 3X4   6016670.3231407 2096336.3389693 37.7370757852971 -122.38482595599 (37.7370757852971, -122.38482595599)
93150 3835 DPW Maintained 3 Pittosporum undulatum :: Victorian Box 26 55X Dedman Ct 3 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     12 3X4   6016670.3231407 2096336.3389693 37.7370757852971 -122.38482595599 (37.7370757852971, -122.38482595599)
108896 3834 DPW Maintained 3 Pittosporum undulatum :: Victorian Box 26 55X Dedman Ct 2 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     12 3X4   6016670.3231407 2096336.3389693 37.7370757852971 -122.38482595599 (37.7370757852971, -122.38482595599)
128250 3833 DPW Maintained 3 Pittosporum undulatum :: Victorian Box 26 55X Dedman Ct 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     12 3X4   6016670.3231407 2096336.3389693 37.7370757852971 -122.38482595599 (37.7370757852971, -122.38482595599)
143821 3837 DPW Maintained 3 Pittosporum undulatum :: Victorian Box 26 55X Dedman Ct 5 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     12 3X4   6016670.3231407 2096336.3389693 37.7370757852971 -122.38482595599 (37.7370757852971, -122.38482595599)
36682 194993 Undocumented 2 Pittosporum undulatum :: Victorian Box 26 11 Dedman Ct 8 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     10 Width 3ft   6016666.91798 2096257.0973099999 37.7368580152904 -122.38483221055701 (37.7368580152904, -122.384832210557)
146562 195003 Undocumented 2 Pittosporum undulatum :: Victorian Box 26 11 Dedman Ct 18 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     1 Width 3ft   6016650.3646599995 2096329.60482 37.737056190782496 -122.38489449311301 (37.7370561907825, -122.384894493113)
140561 194992 Undocumented 2 Pittosporum undulatum :: Victorian Box 26 11 Dedman Ct 7 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     14 Width 3ft   6016636.861740001 2096261.7683299999 37.7368691785546 -122.38493645455401 (37.7368691785546, -122.384936454554)
125547 4943 DPW Maintained 3 Pittosporum undulatum :: Victorian Box 26 47 Dedman Ct 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     12 3X4   6016624.9255784005 2096337.2776573002 37.737075851768395 -122.384982982724 (37.7370758517684, -122.384982982724)
102957 4941 DPW Maintained 3 Pittosporum undulatum :: Victorian Box 26 45 Dedman Ct 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     12 3X4   6016613.8530023 2096337.5066056 37.7370758679492 -122.385021281927 (37.7370758679492, -122.385021281927)
115856 4940 DPW Maintained 3 Pittosporum undulatum :: Victorian Box 26 41 Dedman Ct 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     12 3X4   6016582.986579901 2096332.2845671002 37.7370598218803 -122.385127638349 (37.7370598218803, -122.385127638349)
152680 194991 Undocumented 2 Pittosporum undulatum :: Victorian Box 26 11 Dedman Ct 6 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     1 Width 3ft   6016579.94443 2096258.22378 37.7368562975712 -122.38513299780399 (37.7368562975712, -122.385132997804)
127696 4939 DPW Maintained 3 Pittosporum undulatum :: Victorian Box 26 36 Dedman Ct 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   11/16/2013 12:00:00 AM 3 3X4   6016579.870147 2096241.2722058997 37.7368097478482 -122.385132073872 (37.7368097478482, -122.385132073872)
79790 4938 DPW Maintained 3 Pittosporum undulatum :: Victorian Box 26 32 Dedman Ct 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   11/16/2013 12:00:00 AM 3 3X4   6016560.079733999 2096235.7096036 37.7367933792846 -122.385200111187 (37.7367933792846, -122.385200111187)
39242 194990 Undocumented 2 Pittosporum undulatum :: Victorian Box 26 11 Dedman Ct 5 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     11 Width 3ft   6016555.9151 2096250.2636 37.736833111245204 -122.385215524091 (37.7368331112452, -122.385215524091)
78589 4935 DPW Maintained 3 Pittosporum undulatum :: Victorian Box 26 28 Dedman Ct 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   11/16/2013 12:00:00 AM 3     6016539.8066281 2096230.0113279999 37.73677661144679 -122.385269807917 (37.7367766114468, -122.385269807917)
159730 194989 Undocumented 2 Pittosporum undulatum :: Victorian Box 26 11 Dedman Ct 4 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     7 Width 3ft   6016533.77579 2096242.57848 37.736810784681 -122.38529153479799 (37.736810784681, -122.385291534798)
96960 4937 DPW Maintained 3 Pittosporum undulatum :: Victorian Box 26 31 Dedman Ct 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   11/16/2013 12:00:00 AM 3 3X4   6016529.7381714005 2096313.4471867 37.7370051525187 -122.38531043158001 (37.7370051525187, -122.38531043158)
136182 195004 Undocumented 2 Pittosporum undulatum :: Victorian Box 26 50 Dedman Ct 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     1 Width 3ft   6016527.61209 2096304.47385 37.7369803959213 -122.385317157364 (37.7369803959213, -122.385317157364)
108244 4933 DPW Maintained 3 Pittosporum undulatum :: Victorian Box 26 24 Dedman Ct 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   11/16/2013 12:00:00 AM 3     6016526.7092076 2096227.141084 37.7367680057557 -122.385314891909 (37.7367680057557, -122.385314891909)
161480 194988 Undocumented 2 Pittosporum undulatum :: Victorian Box 26 11 Dedman Ct 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     16 Width 3ft   6016511.35387 2096236.4623599998 37.7367927505907 -122.385368631877 (37.7367927505907, -122.385368631877)
47329 195005 Undocumented 2 Pittosporum undulatum :: Victorian Box 26 50 Dedman Ct 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     17 Width 3ft   6016499.64724 2096292.33943 37.736945530109104 -122.38541299990601 (37.7369455301091, -122.385412999906)
38917 194987 Undocumented 2 Pittosporum undulatum :: Victorian Box 26 11 Dedman Ct 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     17 Width 3ft   6016492.60834 2096223.59489 37.7367563820033 -122.38543254757 (37.7367563820033, -122.38543254757)
44187 4929 DPW Maintained 3 Pittosporum undulatum :: Victorian Box 26 16 Dedman Ct 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   11/16/2013 12:00:00 AM 3 3X4   6016491.974751 2096204.2192507999 37.736703145342496 -122.38543338835899 (37.7367031453425, -122.385433388359)
152092 194986 Undocumented 2 Pittosporum undulatum :: Victorian Box 26 11 Dedman Ct 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     19 Width 3ft   6016473.13756 2096210.02869 37.7367180546823 -122.38549892205 (37.7367180546823, -122.38549892205)
97112 4932 DPW Maintained 3 Pittosporum undulatum :: Victorian Box 26 21 Dedman Ct 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     12 3X4   6016472.936417299 2096288.1310421003 37.7369324968906 -122.385505058787 (37.7369324968906, -122.385505058787)
37624 195006 Undocumented 2 Pittosporum undulatum :: Victorian Box 26 50 Dedman Ct 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     1 Width 3ft   6016468.534519999 2096275.2998900001 37.736897021579296 -122.385519384306 (37.7368970215793, -122.385519384306)
123662 4930 DPW Maintained 3 Pittosporum undulatum :: Victorian Box 26 17 Dedman Ct 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   11/16/2013 12:00:00 AM 3 3X4   6016453.9870213 2096275.6260294 37.7368971121848 -122.38556970464799 (37.7368971121848, -122.385569704648)
120017 4927 DPW Maintained 3 Pittosporum undulatum :: Victorian Box 26 11 Dedman Ct 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     12 3X4   6016420.274248901 2096250.3265868 37.7368257796139 -122.38568450297599 (37.7368257796139, -122.385684502976)
165514 200632 DPW Maintained 3 Pittosporum undulatum :: Victorian Box 26 1300x Newcomb Ave 10 Median : Cutout 11 Tree 1 DPW 2     4 Width 0ft   6016398.592 2094838.1728 37.7329470887224 -122.38566107748899 (37.7329470887224, -122.385661077489)
16834 97231 DPW Maintained 3 Pittosporum undulatum :: Victorian Box 26 1300X Newcomb Ave 11 Median : Cutout 11 Tree 1 DPW 2     6 15x200   6016395.2358 2094838.1728 37.732946903013 -122.385672680851 (37.732946903013, -122.385672680851)
14966 97232 DPW Maintained 3 Pittosporum undulatum :: Victorian Box 26 1300X Newcomb Ave 12 Median : Cutout 11 Tree 1 DPW 2     6 15x200   6016387.2649 2094839.0118 37.732948765679204 -122.38570029703101 (37.7329487656792, -122.385700297031)
15707 2538 Permitted Site 1 Pittosporum undulatum :: Victorian Box 26 1575 Burke Ave 6 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   03/01/2000 12:00:00 AM 3 3X3   6016293.38997 2099044.81151 37.7444918448175 -122.38631797421301 (37.7444918448175, -122.386317974213)

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" TEXT,
  "DBH" INTEGER,
  "PlotSize" TEXT,
  "PermitNotes" TEXT,
  "XCoord" REAL,
  "YCoord" REAL,
  "Latitude" REAL,
  "Longitude" REAL,
  "Location" TEXT
,
FOREIGN KEY ("PlantType") REFERENCES [PlantType](id),
    FOREIGN KEY ("qCaretaker") REFERENCES [qCaretaker](id),
    FOREIGN KEY ("qSpecies") REFERENCES [qSpecies](id),
    FOREIGN KEY ("qSiteInfo") REFERENCES [qSiteInfo](id),
    FOREIGN KEY ("qCareAssistant") REFERENCES [qCareAssistant](id),
    FOREIGN KEY ("qLegalStatus") REFERENCES [qLegalStatus](id));
CREATE INDEX ["Street_Tree_List_PlantType"] ON [Street_Tree_List]("PlantType");
CREATE INDEX ["Street_Tree_List_qCaretaker"] ON [Street_Tree_List]("qCaretaker");
CREATE INDEX ["Street_Tree_List_qSpecies"] ON [Street_Tree_List]("qSpecies");
CREATE INDEX ["Street_Tree_List_qSiteInfo"] ON [Street_Tree_List]("qSiteInfo");
CREATE INDEX ["Street_Tree_List_qCareAssistant"] ON [Street_Tree_List]("qCareAssistant");
CREATE INDEX ["Street_Tree_List_qLegalStatus"] ON [Street_Tree_List]("qLegalStatus");
Powered by Datasette · Query took 1739.29ms · Data source: data.sfgov.org