Street_Tree_List

Data source: data.sfgov.org

400 rows where DBH = 4 and qSpecies = 18 sorted by Longitude

View and edit SQL

Suggested facets: qLegalStatus, SiteOrder, qSiteInfo, qCaretaker, PlotSize

DBH

Link rowid TreeID qLegalStatus qSpecies qAddress SiteOrder qSiteInfo PlantType qCaretaker qCareAssistant PlantDate DBH PlotSize PermitNotes XCoord YCoord Latitude Longitude ▼ Location
50040 87823 Permitted Site 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 451 47th Ave   Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   06/05/2008 12:00:00 AM 4 2x3 Permit Number 50716 5981265.5826900005 2112596.97795 37.7797010943021 -122.508440678428 (37.7797010943021, -122.508440678428)
148211 68564 Permitted Site 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 575 45th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 10/18/1993 12:00:00 AM 4   Permit Number 32454 5981914.34705 2111854.14558 37.7776997090602 -122.506141264398 (37.7776997090602, -122.506141264398)
59474 119000 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 623 43rd Ave 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     4 Width 3ft   5982547.10807 2111503.78055 37.776774937935 -122.503926407866 (37.776774937935, -122.503926407866)
57130 92234 Permitted Site 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 530 42nd Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 07/22/2009 12:00:00 AM 4 3x3 Permit Number 52677 5982879.44866 2112163.93194 37.778607057674996 -122.50282564106199 (37.778607057675, -122.502825641062)
130514 117789 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 3921 Balboa St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     4 Width 3ft   5983401.92135 2111008.87073 37.7754662872697 -122.500932791041 (37.7754662872697, -122.500932791041)
43768 81737 Permitted Site 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 591 40th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   12/07/2007 12:00:00 AM 4 3x3 Permit Number 49969 5983468.0529 2111801.95258 37.7776477425111 -122.500762690576 (37.7776477425111, -122.500762690576)
165384 79359 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 567 35th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 08/28/2004 12:00:00 AM 4     5985009.753819999 2112015.61326 37.778324785429895 -122.495445265062 (37.7783247854299, -122.495445265062)
33711 49142 Permitted Site 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 520 35th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   01/14/2003 12:00:00 AM 4   Permit Number 46265 5985047.031690001 2112314.4789400003 37.7791475672211 -122.495338355641 (37.7791475672211, -122.495338355641)
57185 119537 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 871 30th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     4 Width 2ft   5986635.90405 2110003.72423 37.772895790248 -122.489671893334 (37.772895790248, -122.489671893334)
153617 119948 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 318 29th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     4 Width 3ft   5986856.974330001 2113783.1375700003 37.7832858916453 -122.489185114233 (37.7832858916453, -122.489185114233)
39473 250644 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 2610 Lake St 5 : 4 Tree 1 Private 1     4 Width 3ft   5987312.1046400005 2114657.5756599996 37.785713403992 -122.487674827026 (37.785713403992, -122.487674827026)
27074 250328 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 161 27th Ave 3 : 4 Tree 1 Private 1     4 Width 3ft   5987394.32135 2114885.37066 37.7863436587784 -122.487407123146 (37.7863436587784, -122.487407123146)
97076 116721 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 1766 25TH AVE 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     4 3x3   5988485.0 2103297.0 37.7545887414361 -122.48278413706899 (37.7545887414361, -122.482784137069)
39453 68949 Permitted Site 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 726 23rd Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 02/17/1996 12:00:00 AM 4   Permit Number 32938 5988844.72891 2110346.33242 37.7739652106004 -122.48205650095699 (37.7739652106004, -122.482056500957)
175301 67942 Permitted Site 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 586 22nd Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 03/22/1993 12:00:00 AM 4   Permit Number 31656 5989115.53927 2111342.9098799997 37.776717282669296 -122.48119272322701 (37.7767172826693, -122.481192723227)
73876 45510 Permitted Site 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 2929 25th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 07/20/2001 12:00:00 AM 4   Permit Number 44276 5988794.07528 2095754.20535 37.7338961880477 -122.481162998885 (37.7338961880477, -122.481162998885)
133965 120705 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 20 21st Ave 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     4 Width 3ft   5989295.69695 2115021.44108 37.78682797013 -122.480838891203 (37.78682797013, -122.480838891203)
172983 50299 Permitted Site 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 2917 24th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 01/28/2004 12:00:00 AM 4   Permit Number 47010 5989048.57412 2095810.2761099997 37.7340649359436 -122.480287231884 (37.7340649359436, -122.480287231884)
187197 120727 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 474 21st Ave 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     4 Width 3ft   5989397.82148 2112121.21454 37.7788706974235 -122.48027321576001 (37.7788706974235, -122.48027321576)
170485 120737 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 734 21st Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     4 Width 3ft   5989462.460519999 2110322.27124 37.773935053699 -122.4799179267 (37.773935053699, -122.4799179267)
52062 179041 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 2908 20th Ave 1 Sidewalk: Property side : Yard 9 Tree 1 Private 1     4 Width 2ft   5990269.38069 2095895.56899 37.734369993170795 -122.476072795627 (37.7343699931708, -122.476072795627)
162176 45547 Permitted Site 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 345 Sloat Blvd 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   07/24/2001 12:00:00 AM 4   Permit Number 44299 5990293.1703699995 2095939.4617299999 37.734491890875795 -122.47599375241501 (37.7344918908758, -122.475993752415)
167820 45548 Permitted Site 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 345 Sloat Blvd 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   07/24/2001 12:00:00 AM 4   Permit Number 44299 5990306.88184 2095939.17218 37.734491890873606 -122.475946326684 (37.7344918908736, -122.475946326684)
156197 45478 Permitted Site 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 3008 20th Ave 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 07/19/2001 12:00:00 AM 4   Permit Number 44261 5990292.274259999 2095193.2885900002 37.732443037405 -122.475942374151 (37.732443037405, -122.475942374151)
165469 45480 Permitted Site 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 3014 20th Ave 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 07/19/2001 12:00:00 AM 4   Permit Number 44262 5990294.42195 2095159.6612900002 37.732350829908704 -122.47593249418699 (37.7323508299087, -122.475932494187)
43236 50295 Permitted Site 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 3052 20th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 01/28/2004 12:00:00 AM 4   Permit Number 47008 5990301.1325 2094963.1495599998 37.7318116476733 -122.47589494839501 (37.7318116476733, -122.475894948395)
186414 45549 Permitted Site 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 345 Sloat Blvd 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   07/24/2001 12:00:00 AM 4   Permit Number 44299 5990323.96119 2095935.96592 37.7344840775814 -122.47588704426201 (37.7344840775814, -122.475887044262)
55825 67395 Permitted Site 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 755 17th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 07/29/1992 12:00:00 AM 4   Permit Number 30892 5990662.93226 2110247.15301 37.7737984716316 -122.47575985163 (37.7737984716316, -122.47575985163)
132510 214658 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 1877 18th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     4 Width 3ft   5990609.23043 2102637.69118 37.7529018171753 -122.47538992510401 (37.7529018171753, -122.475389925104)
32051 68219 Permitted Site 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 263 16th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 09/27/1993 12:00:00 AM 4   Permit Number 32006 5990848.54158 2113649.76494 37.7831518664143 -122.475366281729 (37.7831518664143, -122.475366281729)
153620 214510 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 1246 17th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     4 Width 3ft   5990818.1577 2106901.7104599997 37.7646217901831 -122.47497865434799 (37.7646217901831, -122.474978654348)
38542 214571 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 1555 Irving St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     4 Width 3ft   5990887.31471 2106522.14894 37.7635836236158 -122.474711756267 (37.7635836236158, -122.474711756267)
75422 44344 Permitted Site 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 231 15th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   03/14/2001 12:00:00 AM 4   Permit Number 43727 5991166.721059999 2113847.95037 37.78371446666 -122.474279986791 (37.78371446666, -122.474279986791)
69039 214487 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 1351 16th Ave 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     4 Width 3ft   5991108.21615 2106198.3695400003 37.7627074096277 -122.47392411200701 (37.7627074096277, -122.473924112007)
182464 214574 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 1441 Irving St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     4 Width 3ft   5991211.29509 2106533.5678 37.7636337446377 -122.473592054438 (37.7636337446377, -122.473592054438)
132278 214668 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 640 Rivera St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     4 Width 3ft   5991094.75038 2100466.4139900003 37.7469681874362 -122.47355255531001 (37.7469681874362, -122.47355255531)
154160 214575 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 1437 Irving St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     4 Width 3ft   5991239.6267099995 2106533.99936 37.7636365703049 -122.47349409668502 (37.7636365703049, -122.473494096685)
34126 45776 Permitted Site 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 782 15th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   11/01/2001 12:00:00 AM 4   Permit Number 44418 5991347.84343 2110102.5113 37.7734410095192 -122.47338010572399 (37.7734410095192, -122.473380105724)
150684 214577 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 1427 Irving St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     4 Width 3ft   5991285.40608 2106533.11575 37.76363679511471 -122.47333569728201 (37.7636367951147, -122.473335697282)
137361 214562 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 1426 Irving St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     4 Width 3ft   5991293.47534 2106598.40333 37.763816524628204 -122.473312550532 (37.7638165246282, -122.473312550532)
61714 214578 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 1419 Irving St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     4 Width 3ft   5991327.39991 2106536.51596 37.7636485627529 -122.473190703187 (37.7636485627529, -122.473190703187)
153167 214491 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 1908 16th Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     4 Width 3ft   5991283.85529 2102380.71309 37.752235304435395 -122.473038230333 (37.7522353044354, -122.473038230333)
39823 213412 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 2295 16th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     4 Width 3ft   5991244.48359 2099804.88144 37.7451604602052 -122.472986563398 (37.7451604602052, -122.472986563398)
25834 214493 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 1359 15th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     4 Width 3ft   5991433.81997 2106159.32578 37.762619060232296 -122.47279512831001 (37.7626190602323, -122.47279512831)
40188 213362 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 50 Elmhurst Dr 1 Sidewalk: Property side : Yard 9 Tree 1 Private 1     4 Width 3ft   5991224.3842 2094533.07073 37.730684246775205 -122.472671762002 (37.7306842467752, -122.472671762002)
44912 213419 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 1500 Ulloa St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     4 Width 3ft   5991327.39795 2098430.88472 37.741392618264 -122.47259970561701 (37.741392618264, -122.472599705617)
4821 214558 DPW Maintained 3 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 1340 Irving St 1 Sidewalk: Curb side : Yard 2 Tree 1 DPW 2   02/18/2009 12:00:00 AM 4 Width 3ft   5991564.93185 2106609.34919 37.7638622938456 -122.472374472204 (37.7638622938456, -122.472374472204)
150750 213406 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 2287 Cecilia Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     4 Width 3ft   5991473.95624 2099862.13765 37.745330953674205 -122.472197267087 (37.7453309536742, -122.472197267087)
176624 213429 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 2344 Cecilia Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     4 Width 3ft   5991482.19388 2099461.6129099997 37.7442316925378 -122.472139593583 (37.7442316925378, -122.472139593583)
182764 213402 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 2111 15th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     4 Width 3ft   5991606.081259999 2101026.68041 37.7485361329461 -122.471825260742 (37.7485361329461, -122.471825260742)
188053 66364 Permitted Site 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 472 Funston Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   08/14/1991 12:00:00 AM 4   Permit Number 29965 5991908.34552 2112195.95462 37.7792214762424 -122.471593848027 (37.7792214762424, -122.471593848027)
186721 213319 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 262 Beverly St 1 Sidewalk: Property side : Yard 9 Tree 1 Private 1     4 Width 5ft   5991459.9673 2090912.89222 37.7207577701313 -122.471593616958 (37.7207577701313, -122.471593616958)
77124 123052 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 544 Funston Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     4 Width 4ft   5991924.81576 2111692.51922 37.7778401329349 -122.471500177083 (37.7778401329349, -122.471500177083)
146644 214672 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 2472 15th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     4 Width 3ft   5991738.99758 2098601.09952 37.7418838009891 -122.471188949006 (37.7418838009891, -122.471188949006)
72144 87155 Permitted Site 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 101 12th Ave 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   01/22/2008 12:00:00 AM 4 3x3 Permit Number 50137 5992081.9043 2114697.2023099996 37.7860992546106 -122.471175721775 (37.7860992546106, -122.471175721775)
161202 214674 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 2650 15th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     4 Width 3ft   5991779.85078 2097391.18651 37.73856405080021 -122.470959574244 (37.7385640508002, -122.470959574244)
77264 123069 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 682 12th Ave 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     4 Width 3ft   5992267.096480001 2110837.88272 37.7755133283989 -122.470253867932 (37.7755133283989, -122.470253867932)
31801 213330 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 217 Byxbee St 3 : 4 Tree 1 Private 1     4 Width 2ft   5991929.42464 2089936.9124 37.7181051172336 -122.46989983921101 (37.7181051172336, -122.469899839211)
54772 213329 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 217 Byxbee St 2 : 4 Tree 1 Private 1     4 Width 2ft   5991930.7925 2089955.0472 37.718154990039295 -122.46989643078999 (37.7181549900393, -122.46989643079)
30960 214687 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 2624 14th Ave 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     4 Width 3ft   5992121.72865 2097435.29348 37.7387049241844 -122.46978074558999 (37.7387049241844, -122.46978074559)
60536 214519 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 1101 Irving St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     4 Width 3ft   5992317.04824 2106570.7861599997 37.763799911465 -122.46977034493901 (37.763799911465, -122.469770344939)
160997 214553 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 1104 Irving St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     4 Width 3ft   5992323.456069999 2106634.49291 37.7639752037022 -122.46975282075701 (37.7639752037022, -122.469752820757)
176727 213479 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 250 San Fernando Way 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     4 Width 3ft   5992112.189780001 2095156.89303 37.7324484585195 -122.46964790583701 (37.7324484585195, -122.469647905837)
154776 213478 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 240 San Fernando Way 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     4 Width 3ft   5992116.2351400005 2095210.5304 37.7325959671276 -122.46963782354099 (37.7325959671276, -122.469637823541)
153724 214635 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 1276 12th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     4 Width 2ft   5992405.22777 2106756.96673 37.764316210447504 -122.469478915116 (37.7643162104475, -122.469478915116)
53361 214622 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 1443 12th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     4 Width 3ft   5992398.43059 2105617.15858 37.76118620548821 -122.469419451044 (37.7611862054882, -122.469419451044)
65836 213340 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 375 Ralston St 2 : 4 Tree 1 Private 1     4 Width 3ft   5992193.1878 2090324.6899599999 37.719185103182895 -122.469016337141 (37.7191851031829, -122.469016337141)
157491 213339 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 375 Ralston St 1 : 4 Tree 1 Private 1     4 Width 3ft   5992194.5826900005 2090348.43318 37.7192503768696 -122.46901324258499 (37.7192503768696, -122.469013242585)
44379 214636 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 1254 11th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     4 Width 3ft   5992710.27647 2106925.6088900003 37.7647968818831 -122.46843611705299 (37.7647968818831, -122.468436117053)
150274 213588 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 2158 12th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     4 Width 3ft   5992611.081590001 2100745.10402 37.747821095483395 -122.468329533907 (37.7478210954834, -122.468329533907)
149124 213467 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 160 Madrone Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     4 Width 3ft   5992632.76086 2098137.23851 37.7406618129833 -122.46806489937299 (37.7406618129833, -122.468064899373)
26022 214523 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 929 Irving St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     4 Width 3ft   5992854.95804 2106590.6252900003 37.7638854612741 -122.46791133836099 (37.7638854612741, -122.467911338361)
43689 214508 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 1961 11th Ave 7 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     4 Width 2ft   5992833.56281 2102184.357 37.751785762105705 -122.46766486656401 (37.7517857621057, -122.467664866564)
45503 214551 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 904 Irving St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     4 Width 3ft   5992951.517530001 2106656.3795 37.7640715804553 -122.46758215319299 (37.7640715804553, -122.467582153193)
54107 214780 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 1723 Monterey Blvd 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     4 Width 4ft   5992818.43379 2095348.2287 37.7330146123238 -122.467220181466 (37.7330146123238, -122.467220181466)
28267 214528 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 839 Irving St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     4 Width 3ft   5993110.1935 2106600.58981 37.7639275567412 -122.467029287771 (37.7639275567412, -122.467029287771)
156755 214709 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 300 San Benito Way 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     4 Width 3ft   5992867.50655 2094851.0126200002 37.7316522131806 -122.46701438961901 (37.7316522131806, -122.467014389619)
129864 214653 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 306 Noriega St 4 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     4 Width 3ft   5993065.83044 2103254.91574 37.7547386482769 -122.46693948148099 (37.7547386482769, -122.466939481481)
56569 213355 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 430 Garfield St 1 : 4 Tree 1 Private 1     4 Width 3ft   5992826.5059 2090512.32679 37.7197368804329 -122.466840849243 (37.7197368804329, -122.466840849243)
36336 214656 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 1797 10th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     4 Width 3ft   5993098.06749 2103308.53562 37.7548877351851 -122.466831895581 (37.7548877351851, -122.466831895581)
60295 214530 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 829 Irving St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     4 Width 3ft   5993181.45103 2106600.0811 37.7639302726919 -122.466782794395 (37.7639302726919, -122.466782794395)
165692 214531 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 825 Irving St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     4 Width 3ft   5993201.56141 2106599.90569 37.763930951669394 -122.46671322643999 (37.7639309516694, -122.46671322644)
171050 214532 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 805 Irving St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     4 Width 3ft   5993224.68666 2106601.39795 37.763936383573295 -122.46663335226499 (37.7639363835733, -122.466633352265)
57270 213376 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 1243 09th Ave 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     4 Width 3ft   5993278.150880001 2107040.93522 37.7651463224575 -122.46648038567 (37.7651463224575, -122.46648038567)
30897 214641 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 1281 09th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     4 Width 2ft   5993288.48621 2106790.9815599998 37.7644606118874 -122.46642647040501 (37.7644606118874, -122.466426470405)
30298 214610 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 1317 09th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     4 Width 2ft   5993294.793 2106507.24559 37.7636819114108 -122.466384034097 (37.7636819114108, -122.466384034097)
152346 213377 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 1210 09th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     4 Width 3ft   5993321.34014 2107196.20465 37.765575143506105 -122.46634229118901 (37.7655751435061, -122.466342291189)
56503 213593 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 2042 10th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     4 Width 3ft   5993205.21101 2101561.12228 37.7500959710504 -122.46633437715201 (37.7500959710504, -122.466334377152)
173982 213346 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 223 Ramsell St 1 : 4 Tree 1 Private 1     4 Width 3ft   5992956.82489 2088699.8094099998 37.7147676656708 -122.466258733373 (37.7147676656708, -122.466258733373)
150154 214604 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 1340 09th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     4 Width 2ft   5993354.43773 2106360.8901400003 37.7632834991452 -122.466167106819 (37.7632834991452, -122.466167106819)
73855 214603 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 1342 09th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     4 Width 2ft   5993355.88687 2106339.40983 37.7632246034565 -122.46616053369301 (37.7632246034565, -122.466160533693)
170090 214602 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 1352 09th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     4 Width 2ft   5993354.826830001 2106288.96143 37.7630860242229 -122.46616053368 (37.7630860242229, -122.46616053368)
133380 214601 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 1360 09th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     4 Width 2ft   5993356.82436 2106203.11935 37.7628504396238 -122.46614738648701 (37.7628504396238, -122.466147386487)
130416 214600 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 1368 09th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     4 Width 2ft   5993361.42673 2106180.94195 37.7627898118252 -122.46612985693301 (37.7627898118252, -122.466129856933)
49643 214599 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 1372 09th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     4 Width 2ft   5993361.64911 2106161.3799 37.7627361123925 -122.466127666177 (37.7627361123925, -122.466127666177)
67343 214598 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 1376 09th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     4 Width 2ft   5993363.63892 2106135.47177 37.762665090255496 -122.466118901381 (37.7626650902555, -122.466118901381)
182153 214597 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 1380 09th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     4 Width 2ft   5993363.01616 2106105.83321 37.7625836746058 -122.46611890136299 (37.7625836746058, -122.466118901363)
33377 59100 Permitted Site 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 574 08th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   04/23/1980 12:00:00 AM 4   Permit Number 53750 5993480.53201 2111592.2596 37.777654724152896 -122.46611116933201 (37.7776547241529, -122.466111169332)
50905 214533 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 755 Irving St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     4 Width 3ft   5993378.22609 2106609.29475 37.763966925444606 -122.466102883542 (37.7639669254446, -122.466102883542)
23875 123972 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 75 07th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     4 Width 3ft   5993617.67519 2115041.45387 37.78713318686079 -122.46588743043002 (37.7871331868608, -122.46588743043)

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 1281.184ms · Data source: data.sfgov.org