Street_Tree_List

Data source: data.sfgov.org

500 rows where qSiteInfo = 2 and qSpecies = 15 sorted by PlotSize

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: PlotSize

qSiteInfo ✖

  • Sidewalk: Curb side : Yard · 500 ✖
Link rowid TreeID qLegalStatus qSpecies qAddress SiteOrder qSiteInfo PlantType qCaretaker qCareAssistant PlantDate DBH PlotSize ▼ PermitNotes XCoord YCoord Latitude Longitude Location
24035 24035 178607 Undocumented 2 Platanus x hispanica :: Sycamore: London Plane 15 0 Gonzalez Dr 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     2     5990327.66617 2089955.55198 37.7180635775375 -122.47543773036101 (37.7180635775375, -122.475437730361)
31084 31084 134794 Undocumented 2 Platanus x hispanica :: Sycamore: London Plane 15 1040 Lombard St 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     14     6007385.13093 2120235.26271 37.8021786677605 -122.418623384776 (37.8021786677605, -122.418623384776)
33675 33675 134800 Undocumented 2 Platanus x hispanica :: Sycamore: London Plane 15 1070 Lombard St 4 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     8     6007227.6114300005 2120220.91562 37.802130404749896 -122.419167461114 (37.8021304047499, -122.419167461114)
34855 34855 134971 Undocumented 2 Platanus x hispanica :: Sycamore: London Plane 15 2100 The Embarcadero 5 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     9     6009844.1621199995 2122376.03453 37.8081948291999 -122.41026515223 (37.8081948291999, -122.41026515223)
35307 35307 135015 Undocumented 2 Platanus x hispanica :: Sycamore: London Plane 15 1077 Front St 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     18     6012578.55568 2120142.36821 37.802214619965206 -122.40064498919399 (37.8022146199652, -122.400644989194)
38055 38055 134980 Undocumented 2 Platanus x hispanica :: Sycamore: London Plane 15 2350 Stockton St 3 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     8     6009736.585940001 2122356.6353700003 37.8081355332869 -122.410636078516 (37.8081355332869, -122.410636078516)
39130 39130 134791 Undocumented 2 Platanus x hispanica :: Sycamore: London Plane 15 1000 Lombard St 3 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     12     6007500.8396 2120253.7585299998 37.802235966276 -122.418224288116 (37.802235966276, -122.418224288116)
41636 41636 134799 Undocumented 2 Platanus x hispanica :: Sycamore: London Plane 15 1070 Lombard St 3 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     9     6007233.50436 2120221.1606099997 37.802131409291796 -122.419147086091 (37.8021314092918, -122.419147086091)
46112 46112 134975 Undocumented 2 Platanus x hispanica :: Sycamore: London Plane 15 2100 The Embarcadero 9 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     11     6009928.574659999 2122361.54548 37.808159777214705 -122.409971995727 (37.8081597772147, -122.409971995727)
63730 63730 178606 Undocumented 2 Platanus x hispanica :: Sycamore: London Plane 15 0 Gonzalez Dr 3 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     2     5989765.07873 2089203.5232 37.715966065363205 -122.47732740025499 (37.7159660653632, -122.477327400255)
65347 65347 134973 Undocumented 2 Platanus x hispanica :: Sycamore: London Plane 15 2100 The Embarcadero 7 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     10     6009889.50127 2122368.35067 37.808176272591794 -122.41010770071001 (37.8081762725918, -122.41010770071)
69182 69182 134802 Undocumented 2 Platanus x hispanica :: Sycamore: London Plane 15 1070 Lombard St 6 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     10     6007216.80949 2120218.74094 37.802123825306396 -122.419204686742 (37.8021238253064, -122.419204686742)
72737 72737 134801 Undocumented 2 Platanus x hispanica :: Sycamore: London Plane 15 1070 Lombard St 5 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     10     6007223.05893 2120219.35102 37.802125852376705 -122.419183103935 (37.8021258523767, -122.419183103935)
76087 76087 134976 Undocumented 2 Platanus x hispanica :: Sycamore: London Plane 15 2100 The Embarcadero 10 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     10     6009945.63465 2122359.94576 37.808156340907004 -122.409912841929 (37.808156340907, -122.409912841929)
111271 111271 111095 Undocumented 2 Platanus x hispanica :: Sycamore: London Plane 15 841x GONZALEZ DR 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1   06/04/2015 12:00:00 AM 3   Permit Number 775593 5988358.0 2089771.0 37.7174424713469 -122.48223241855301 (37.7174424713469, -122.482232418553)
131497 131497 134966 Undocumented 2 Platanus x hispanica :: Sycamore: London Plane 15 2350 Stockton St 5 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     10     6009730.51186 2122386.61497 37.808217509201704 -122.41065921807 (37.8082175092017, -122.41065921807)
135925 135925 134792 Undocumented 2 Platanus x hispanica :: Sycamore: London Plane 15 1016 Lombard St 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     16     6007425.34562 2120240.11235 37.8021942476325 -122.418484566311 (37.8021942476325, -122.418484566311)
137451 137451 134974 Undocumented 2 Platanus x hispanica :: Sycamore: London Plane 15 2100 The Embarcadero 8 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     11     6009910.79688 2122364.91216 37.808168024892 -122.410033758463 (37.808168024892, -122.410033758463)
139222 139222 111092 Undocumented 2 Platanus x hispanica :: Sycamore: London Plane 15 801 GONZALEZ DR   Sidewalk: Curb side : Yard 2 Tree 1 Private 1   06/04/2015 12:00:00 AM 2   Permit Number 775593 5988333.0 2089769.0 37.717435525652704 -122.48231868452 (37.7174355256527, -122.48231868452)
146394 146394 178605 Undocumented 2 Platanus x hispanica :: Sycamore: London Plane 15 0 Gonzalez Dr 6 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     2     5988508.8443599995 2089780.72483 37.71747794624039 -122.48171173733299 (37.7174779462404, -122.481711737333)
147241 147241 134795 Undocumented 2 Platanus x hispanica :: Sycamore: London Plane 15 1050 Lombard St 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     10     6007333.04572 2120229.52133 37.802159970872395 -122.41880321771099 (37.8021599708724, -122.418803217711)
148106 148106 178604 Undocumented 2 Platanus x hispanica :: Sycamore: London Plane 15 0 Gonzalez Dr 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     2     5988124.07873 2089803.3530000001 37.7175176953569 -122.48304333649999 (37.7175176953569, -122.4830433365)
151134 151134 134968 Undocumented 2 Platanus x hispanica :: Sycamore: London Plane 15 2100 The Embarcadero 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     9     6009782.97322 2122383.0408 37.8082106365745 -122.41047740841101 (37.8082106365745, -122.410477408411)
152361 152361 134979 Undocumented 2 Platanus x hispanica :: Sycamore: London Plane 15 2350 Stockton St 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     10     6009717.25232 2122356.15564 37.808133132108395 -122.4107029539 (37.8081331321084, -122.4107029539)
153265 153265 134978 Undocumented 2 Platanus x hispanica :: Sycamore: London Plane 15 2350 Stockton St 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     7     6009731.6479400005 2122319.12499 37.8080322623412 -122.41065051712201 (37.8080322623412, -122.410650517122)
153466 153466 134965 Undocumented 2 Platanus x hispanica :: Sycamore: London Plane 15 2350 Stockton St 4 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     11     6009712.7239 2122389.48119 37.8082243818107 -122.410720980795 (37.8082243818107, -122.410720980795)
154015 154015 134970 Undocumented 2 Platanus x hispanica :: Sycamore: London Plane 15 2100 The Embarcadero 4 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     10     6009821.57971 2122377.9972900003 37.8081989525817 -122.41034344359 (37.8081989525817, -122.41034344359)
154830 154830 135013 Undocumented 2 Platanus x hispanica :: Sycamore: London Plane 15 11 Filbert St 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     39     6012368.5376 2120177.6875299998 37.8022998828874 -122.401374241337 (37.8022998828874, -122.401374241337)
157479 157479 135014 Undocumented 2 Platanus x hispanica :: Sycamore: London Plane 15 1077 Front St 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     14     6012567.827330001 2120162.89439 37.8022703815431 -122.400683557523 (37.8022703815431, -122.400683557523)
165476 165476 134796 Undocumented 2 Platanus x hispanica :: Sycamore: London Plane 15 1050 Lombard St 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     10     6007325.26696 2120228.09198 37.802155608254 -122.418830034596 (37.802155608254, -122.418830034596)
165728 165728 134967 Undocumented 2 Platanus x hispanica :: Sycamore: London Plane 15 2100 The Embarcadero 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     8     6009753.391419999 2122386.8985 37.8082195704377 -122.410580057033 (37.8082195704377, -122.410580057033)
171848 171848 134790 Undocumented 2 Platanus x hispanica :: Sycamore: London Plane 15 1000 Lombard St 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     12     6007519.93595 2120253.20952 37.802235533706 -122.41815816638099 (37.802235533706, -122.418158166381)
174868 174868 135016 Undocumented 2 Platanus x hispanica :: Sycamore: London Plane 15 1077 Front St 3 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     13     6012585.731319999 2120133.72105 37.802191277152204 -122.400619550052 (37.8021912771522, -122.400619550052)
175640 175640 134977 Undocumented 2 Platanus x hispanica :: Sycamore: London Plane 15 2100 The Embarcadero 11 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     10     6009962.1815599995 2122357.85605 37.808151530425704 -122.40985542918001 (37.8081515304257, -122.40985542918)
176181 176181 134798 Undocumented 2 Platanus x hispanica :: Sycamore: London Plane 15 1070 Lombard St 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     16     6007241.93448 2120222.87266 37.802136584885794 -122.419118035275 (37.8021365848858, -122.419118035275)
181018 181018 134969 Undocumented 2 Platanus x hispanica :: Sycamore: London Plane 15 2100 The Embarcadero 3 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     9     6009807.0374300005 2122379.79592 37.8082030759684 -122.410393898262 (37.8082030759684, -122.410393898262)
181345 181345 134797 Undocumented 2 Platanus x hispanica :: Sycamore: London Plane 15 1050 Lombard St 3 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     9     6007318.65057 2120227.7737 37.8021543617957 -122.418852907954 (37.8021543617957, -122.418852907954)
181647 181647 134972 Undocumented 2 Platanus x hispanica :: Sycamore: London Plane 15 2100 The Embarcadero 6 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     10     6009871.42123 2122369.22021 37.8081776467351 -122.41017033311199 (37.8081776467351, -122.410170333112)
184768 184768 134793 Undocumented 2 Platanus x hispanica :: Sycamore: London Plane 15 1028 Lombard St 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     11     6007395.86697 2120236.40414 37.8021824062669 -122.418586313803 (37.8021824062669, -122.418586313803)
185394 185394 135017 Undocumented 2 Platanus x hispanica :: Sycamore: London Plane 15 1077 Front St 6 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     13     6012595.7467 2120124.7804 37.8021672868545 -122.40058426336701 (37.8021672868545, -122.400584263367)
188462 188462 135018 Undocumented 2 Platanus x hispanica :: Sycamore: London Plane 15 1077 Front St 8 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     19     6012602.08363 2120098.20385 37.802094667483004 -122.400560466418 (37.802094667483, -122.400560466418)
81509 81509 106258 Undocumented 2 Platanus x hispanica :: Sycamore: London Plane 15 205 GRANADA AVE 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     16 4x4   5995602.7 2091290.9 37.722034494846895 -122.457300887551 (37.7220344948469, -122.457300887551)
23915 23915 201200 Undocumented 2 Platanus x hispanica :: Sycamore: London Plane 15 700 Folsom St 8 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     4 Width 0ft   6012679.9726 2113219.2905 37.7832111428923 -122.399807626404 (37.7832111428923, -122.399807626404)
23941 23941 250276 Undocumented 2 Platanus x hispanica :: Sycamore: London Plane 15 43 United Nations Plz 17 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     12 Width 0ft   6008392.62375 2112125.224 37.7799671560941 -122.414562734397 (37.7799671560941, -122.414562734397)
24126 24126 138818 Undocumented 2 Platanus x hispanica :: Sycamore: London Plane 15 723 Grove St 3 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     5 Width 0ft   6004379.6433 2111160.4787 37.7770919345009 -122.428376650964 (37.7770919345009, -122.428376650964)
28283 28283 250263 Undocumented 2 Platanus x hispanica :: Sycamore: London Plane 15 43 United Nations Plz 4 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     17 Width 0ft   6008564.070780001 2112166.2785 37.780089512455895 -122.413972525522 (37.7800895124559, -122.413972525522)
30359 30359 250285 Undocumented 2 Platanus x hispanica :: Sycamore: London Plane 15 43 United Nations Plz 26 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     10 Width 0ft   6008311.26384 2112132.45914 37.7799824508737 -122.41484470781401 (37.7799824508737, -122.414844707814)
32053 32053 250261 Undocumented 2 Platanus x hispanica :: Sycamore: London Plane 15 43 United Nations Plz 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     12 Width 0ft   6008586.13413 2112170.60163 37.7801026218644 -122.41389650404301 (37.7801026218644, -122.413896504043)
32647 32647 250269 Undocumented 2 Platanus x hispanica :: Sycamore: London Plane 15 43 United Nations Plz 10 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     11 Width 0ft   6008517.979119999 2112159.2639599997 37.7800676634378 -122.41413148158199 (37.7800676634378, -122.414131481582)
32801 32801 201209 Undocumented 2 Platanus x hispanica :: Sycamore: London Plane 15 790 Folsom St 4 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     8 Width 0ft   6012419.7025 2112971.3045 37.7825157180222 -122.40069063515399 (37.7825157180222, -122.400690635154)
34450 34450 250300 Undocumented 2 Platanus x hispanica :: Sycamore: London Plane 15 2 United Nations Plz 13 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     10 Width 0ft   6008420.57979 2112029.11153 37.779704824759996 -122.414459218831 (37.77970482476, -122.414459218831)
34948 34948 143032 Undocumented 2 Platanus x hispanica :: Sycamore: London Plane 15 301 LOMBARD ST 6 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     6 Width 0ft   6010840.9204 2120666.3163 37.8035561879378 -122.40669502317199 (37.8035561879378, -122.406695023172)
35843 35843 201199 Undocumented 2 Platanus x hispanica :: Sycamore: London Plane 15 700 Folsom St 7 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     8 Width 0ft   6012695.3277 2113239.2522 37.783266809092495 -122.399755905675 (37.7832668090925, -122.399755905675)
36916 36916 201206 Undocumented 2 Platanus x hispanica :: Sycamore: London Plane 15 790 Folsom St 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     3 Width 0ft   6012480.3554 2113028.1186 37.782675099007704 -122.400484793191 (37.7826750990077, -122.400484793191)
38373 38373 182584 Undocumented 2 Platanus x hispanica :: Sycamore: London Plane 15 2445 26th Ave 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     10 Width 0ft   5988262.1936 2098677.2249 37.7418911015612 -122.483216039459 (37.7418911015612, -122.483216039459)
38801 38801 250306 Undocumented 2 Platanus x hispanica :: Sycamore: London Plane 15 4 United Nations Plz 5 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     13 Width 0ft   6008573.7773400005 2112070.38194 37.7798267485347 -122.41393216035601 (37.7798267485347, -122.413932160356)
39563 39563 250286 Undocumented 2 Platanus x hispanica :: Sycamore: London Plane 15 43 United Nations Plz 27 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     11 Width 0ft   6008300.87263 2112112.7782 37.7799278278445 -122.414879262463 (37.7799278278445, -122.414879262463)
40359 40359 250297 Undocumented 2 Platanus x hispanica :: Sycamore: London Plane 15 2 United Nations Plz 10 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     12 Width 0ft   6008380.5766 2112045.78874 37.7797483690312 -122.414598788204 (37.7797483690312, -122.414598788204)
41048 41048 250294 Undocumented 2 Platanus x hispanica :: Sycamore: London Plane 15 2 United Nations Plz 7 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     8 Width 0ft   6008364.20368 2112023.92173 37.7796874075756 -122.414653881581 (37.7796874075756, -122.414653881581)
45098 45098 138817 Undocumented 2 Platanus x hispanica :: Sycamore: London Plane 15 725 Grove St 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     7 Width 0ft   6004365.9381 2111158.4731 37.777085652085795 -122.42842391857 (37.7770856520858, -122.42842391857)
46336 46336 250260 Undocumented 2 Platanus x hispanica :: Sycamore: London Plane 15 43 United Nations Plz 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     14 Width 0ft   6008585.75695 2112153.44443 37.7800554911055 -122.413896594858 (37.7800554911055, -122.413896594858)
46812 46812 182458 Undocumented 2 Platanus x hispanica :: Sycamore: London Plane 15 1500 31st Ave 6 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     16 Width 0ft   5986548.9803 2104767.4719 37.758513422441204 -122.489587443554 (37.7585134224412, -122.489587443554)
47872 47872 250281 Undocumented 2 Platanus x hispanica :: Sycamore: London Plane 15 43 United Nations Plz 22 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     11 Width 0ft   6008344.09456 2112135.7661599996 37.7799933758261 -122.414731365385 (37.7799933758261, -122.414731365385)
49467 49467 138833 Undocumented 2 Platanus x hispanica :: Sycamore: London Plane 15 745 BUCHANAN ST 5 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     26 Width 0ft   6004458.1976 2111049.1657 37.7767907411066 -122.428096972449 (37.7767907411066, -122.428096972449)
51080 51080 250299 Undocumented 2 Platanus x hispanica :: Sycamore: London Plane 15 2 United Nations Plz 12 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     13 Width 0ft   6008402.94933 2112049.56006 37.7797599810866 -122.414521657841 (37.7797599810866, -122.414521657841)
51845 51845 250272 Undocumented 2 Platanus x hispanica :: Sycamore: London Plane 15 43 United Nations Plz 13 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     12 Width 0ft   6008485.20638 2112139.2449 37.780010855049 -122.414243440893 (37.780010855049, -122.414243440893)
54261 54261 250302 Undocumented 2 Platanus x hispanica :: Sycamore: London Plane 15 4 United Nations Plz 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     14 Width 0ft   6008493.92418 2112059.32847 37.7797919133004 -122.41420762629 (37.7797919133004, -122.41420762629)
54984 54984 250304 Undocumented 2 Platanus x hispanica :: Sycamore: London Plane 15 4 United Nations Plz 3 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     14 Width 0ft   6008532.24811 2112064.35949 37.7798078798681 -122.414075402566 (37.7798078798681, -122.414075402566)
55939 55939 143028 Undocumented 2 Platanus x hispanica :: Sycamore: London Plane 15 301 LOMBARD ST 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     6 Width 0ft   6010783.2032 2120659.2378 37.8035335227011 -122.406894258002 (37.8035335227011, -122.406894258002)
57519 57519 201207 Undocumented 2 Platanus x hispanica :: Sycamore: London Plane 15 790 Folsom St 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     8 Width 0ft   6012455.0194 2113006.6214 37.7826146597246 -122.400570934911 (37.7826146597246, -122.400570934911)
58027 58027 143033 Undocumented 2 Platanus x hispanica :: Sycamore: London Plane 15 301 LOMBARD ST 7 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     14 Width 0ft   6010849.0879 2120667.4053 37.803559635028 -122.40666683581001 (37.803559635028, -122.40666683581)
58316 58316 201197 Undocumented 2 Platanus x hispanica :: Sycamore: London Plane 15 700 Folsom St 5 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     10 Width 0ft   6012737.1706 2113278.7917 37.783377707887794 -122.39961392201401 (37.7833777078878, -122.399613922014)
58454 58454 250271 Undocumented 2 Platanus x hispanica :: Sycamore: London Plane 15 43 United Nations Plz 12 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     12 Width 0ft   6008499.1431599995 2112156.4663299997 37.7800589238189 -122.41419644590799 (37.7800589238189, -122.414196445908)
59578 59578 200809 Undocumented 2 Platanus x hispanica :: Sycamore: London Plane 15 700 Folsom St 3 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     8 Width 0ft   6012806.2688 2113339.4447 37.7835480984018 -122.39937912727501 (37.7835480984018, -122.399379127275)
60151 60151 250277 Undocumented 2 Platanus x hispanica :: Sycamore: London Plane 15 43 United Nations Plz 18 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     12 Width 0ft   6008392.9818 2112142.72321 37.780015224857294 -122.41456273439199 (37.7800152248573, -122.414562734392)
62798 62798 201195 Undocumented 2 Platanus x hispanica :: Sycamore: London Plane 15 700 Folsom St 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     4 Width 0ft   6012829.3016 2113361.7096 37.7836105163668 -122.399301005654 (37.7836105163668, -122.399301005654)
64367 64367 250303 Undocumented 2 Platanus x hispanica :: Sycamore: London Plane 15 4 United Nations Plz 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     14 Width 0ft   6008514.64017 2112059.96196 37.7797948163118 -122.41413600517599 (37.7797948163118, -122.414136005176)
67064 67064 201198 Undocumented 2 Platanus x hispanica :: Sycamore: London Plane 15 700 Folsom St 6 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     5 Width 0ft   6012716.825 2113256.1429 37.783314385408 -122.39968271945801 (37.783314385408, -122.399682719458)
67241 67241 250280 Undocumented 2 Platanus x hispanica :: Sycamore: London Plane 15 43 United Nations Plz 21 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     11 Width 0ft   6008350.1916 2112121.31781 37.7799540466755 -122.41470925013901 (37.7799540466755, -122.414709250139)
67438 67438 250279 Undocumented 2 Platanus x hispanica :: Sycamore: London Plane 15 43 United Nations Plz 20 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     10 Width 0ft   6008368.8075 2112132.87311 37.7799868206815 -122.41464566717698 (37.7799868206815, -122.414645667177)
72230 72230 250301 Undocumented 2 Platanus x hispanica :: Sycamore: London Plane 15 2 United Nations Plz 14 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     14 Width 0ft   6008422.13834 2112053.39653 37.779771593125 -122.414455545984 (37.779771593125, -122.414455545984)
73407 73407 250273 Undocumented 2 Platanus x hispanica :: Sycamore: London Plane 15 43 United Nations Plz 14 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     14 Width 0ft   6008481.10598 2112153.6523700003 37.7800501841947 -122.414258645714 (37.7800501841947, -122.414258645714)
75114 75114 250267 Undocumented 2 Platanus x hispanica :: Sycamore: London Plane 15 43 United Nations Plz 8 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     12 Width 0ft   6008532.85396 2112163.7341 37.7800807728527 -122.414080338948 (37.7800807728527, -122.414080338948)
75807 75807 250264 Undocumented 2 Platanus x hispanica :: Sycamore: London Plane 15 43 United Nations Plz 5 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     14 Width 0ft   6008551.27502 2112146.24871 37.7800337967744 -122.414015374626 (37.7800337967744, -122.414015374626)
76302 76302 247458 Undocumented 2 Platanus x hispanica :: Sycamore: London Plane 15 977 Oak St 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     2 Width 0ft   6002343.7004 2109830.6644 37.773325179802605 -122.435324460366 (37.7733251798026, -122.435324460366)
76920 76920 250262 Undocumented 2 Platanus x hispanica :: Sycamore: London Plane 15 43 United Nations Plz 3 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     12 Width 0ft   6008570.16793 2112151.83053 37.7800501842132 -122.413950410296 (37.7800501842132, -122.413950410296)
129667 129667 143027 Undocumented 2 Platanus x hispanica :: Sycamore: London Plane 15 301 LOMBARD ST 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     11 Width 0ft   6010772.8577 2120657.0598 37.80352696355779 -122.40692990564699 (37.8035269635578, -122.406929905647)
130117 130117 250289 Undocumented 2 Platanus x hispanica :: Sycamore: London Plane 15 2 United Nations Plz 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     10 Width 0ft   6008315.06105 2112034.97107 37.7797149853055 -122.41482467003401 (37.7797149853055, -122.414824670034)
130814 130814 250284 Undocumented 2 Platanus x hispanica :: Sycamore: London Plane 15 43 United Nations Plz 25 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     11 Width 0ft   6008318.07852 2112114.01757 37.77993219764 -122.414819827174 (37.77993219764, -122.414819827174)
130977 130977 250307 Undocumented 2 Platanus x hispanica :: Sycamore: London Plane 15 4 United Nations Plz 6 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     16 Width 0ft   6008588.67814 2112072.19171 37.779832554580295 -122.413880739803 (37.7798325545803, -122.413880739803)
132329 132329 250278 Undocumented 2 Platanus x hispanica :: Sycamore: London Plane 15 43 United Nations Plz 19 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     12 Width 0ft   6008372.2146 2112123.6525 37.7799616945114 -122.414633227763 (37.7799616945114, -122.414633227763)
132687 132687 138816 Undocumented 2 Platanus x hispanica :: Sycamore: London Plane 15 727 Grove St 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     20 Width 0ft   6004347.8874 2111156.4674 37.777079123469896 -122.428486218607 (37.7770791234699, -122.428486218607)
148282 148282 143030 Undocumented 2 Platanus x hispanica :: Sycamore: London Plane 15 301 LOMBARD ST 4 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     9 Width 0ft   6010819.1403 2120662.5048 37.8035445038868 -122.40677012581001 (37.8035445038868, -122.40677012581)
148826 148826 138820 Undocumented 2 Platanus x hispanica :: Sycamore: London Plane 15 745 BUCHANAN ST 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     19 Width 0ft   6004444.1581 2111151.4533 37.7770708033891 -122.428152830639 (37.7770708033891, -122.428152830639)
150038 150038 250270 Undocumented 2 Platanus x hispanica :: Sycamore: London Plane 15 43 United Nations Plz 11 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     13 Width 0ft   6008502.42852 2112141.27996 37.7800174102115 -122.41418400559401 (37.7800174102115, -122.414184005594)
151417 151417 250290 Undocumented 2 Platanus x hispanica :: Sycamore: London Plane 15 2 United Nations Plz 3 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     13 Width 0ft   6008327.51503 2112020.97203 37.7796772470476 -122.41478059514601 (37.7796772470476, -122.414780595146)
153532 153532 250305 Undocumented 2 Platanus x hispanica :: Sycamore: London Plane 15 4 United Nations Plz 4 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     13 Width 0ft   6008554.56675 2112065.4885299997 37.779812233472704 -122.413998272207 (37.7798122334727, -122.413998272207)
155044 155044 201210 Undocumented 2 Platanus x hispanica :: Sycamore: London Plane 15 790 Folsom St 5 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     8 Width 0ft   6012388.2244 2112940.5942 37.7824296389678 -122.400797378169 (37.7824296389678, -122.400797378169)
155911 155911 250265 Undocumented 2 Platanus x hispanica :: Sycamore: London Plane 15 43 United Nations Plz 6 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     10 Width 0ft   6008543.694209999 2112166.29735 37.7800884197775 -122.414043018878 (37.7800884197775, -122.414043018878)
160081 160081 250275 Undocumented 2 Platanus x hispanica :: Sycamore: London Plane 15 43 United Nations Plz 16 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     14 Width 0ft   6008410.57079 2112143.15923 37.7800174102082 -122.414501916834 (37.7800174102082, -122.414501916834)

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