trees

420 rows where qSpecies_id = 116 sorted by qAddress

✎ View and edit SQL

This data as json, CSV (advanced)

rowid TreeID qLegalStatus_id qSpecies_id qAddress ▼ SiteOrder qSiteInfo PlantType qCaretaker_id qCareAssistant PlantDate DBH PlotSize PermitNotes XCoord YCoord Latitude Longitude Location Fire Prevention Districts Police Districts Supervisor Districts Zip Codes Neighborhoods (old)
34894 253483 Planning Code 138.1 required 2 Trachycarpus fortunei :: Windmill Palm 116 1x Gordon St 1 Sidewalk: Curb side : Cutout Tree Private 2   09/12/2017 12:00:00 AM 3 3x3 Permit Number 772214 6009763 2109812 37.7736924789578 -122.409658650953 (37.7736924789578, -122.409658650953) 8 2 9 28853 34
35262 253489 Planning Code 138.1 required 2 Trachycarpus fortunei :: Windmill Palm 116 1x Gordon St 7 Sidewalk: Curb side : Cutout Tree Private 2   09/12/2017 12:00:00 AM 3 3x3 Permit Number 772214 6009763 2109812 37.7736924789578 -122.409658650953 (37.7736924789578, -122.409658650953) 8 2 9 28853 34
36333 253491 Planning Code 138.1 required 2 Trachycarpus fortunei :: Windmill Palm 116 1x Gordon St 9 Sidewalk: Curb side : Cutout Tree Private 2   09/12/2017 12:00:00 AM 3 3x3 Permit Number 772214 6009763 2109812 37.7736924789578 -122.409658650953 (37.7736924789578, -122.409658650953) 8 2 9 28853 34
50722 253485 Planning Code 138.1 required 2 Trachycarpus fortunei :: Windmill Palm 116 1x Gordon St 3 Sidewalk: Curb side : Cutout Tree Private 2   09/12/2017 12:00:00 AM 3 3x3 Permit Number 772214 6009763 2109812 37.7736924789578 -122.409658650953 (37.7736924789578, -122.409658650953) 8 2 9 28853 34
61025 253495 Planning Code 138.1 required 2 Trachycarpus fortunei :: Windmill Palm 116 1x Gordon St 13 Sidewalk: Curb side : Cutout Tree Private 2   09/12/2017 12:00:00 AM 3 3x3 Permit Number 772214 6009763 2109812 37.7736924789578 -122.409658650953 (37.7736924789578, -122.409658650953) 8 2 9 28853 34
84993 253492 Planning Code 138.1 required 2 Trachycarpus fortunei :: Windmill Palm 116 1x Gordon St 10 Sidewalk: Curb side : Cutout Tree Private 2   09/12/2017 12:00:00 AM 3 3x3 Permit Number 772214 6009763 2109812 37.7736924789578 -122.409658650953 (37.7736924789578, -122.409658650953) 8 2 9 28853 34
85377 253490 Planning Code 138.1 required 2 Trachycarpus fortunei :: Windmill Palm 116 1x Gordon St 8 Sidewalk: Curb side : Cutout Tree Private 2   09/12/2017 12:00:00 AM 3 3x3 Permit Number 772214 6009763 2109812 37.7736924789578 -122.409658650953 (37.7736924789578, -122.409658650953) 8 2 9 28853 34
93105 253487 Planning Code 138.1 required 2 Trachycarpus fortunei :: Windmill Palm 116 1x Gordon St 5 Sidewalk: Curb side : Cutout Tree Private 2   09/12/2017 12:00:00 AM 3 3x3 Permit Number 772214 6009763 2109812 37.7736924789578 -122.409658650953 (37.7736924789578, -122.409658650953) 8 2 9 28853 34
95654 253488 Planning Code 138.1 required 2 Trachycarpus fortunei :: Windmill Palm 116 1x Gordon St 6 Sidewalk: Curb side : Cutout Tree Private 2   09/12/2017 12:00:00 AM 3 3x3 Permit Number 772214 6009763 2109812 37.7736924789578 -122.409658650953 (37.7736924789578, -122.409658650953) 8 2 9 28853 34
105665 253493 Planning Code 138.1 required 2 Trachycarpus fortunei :: Windmill Palm 116 1x Gordon St 11 Sidewalk: Curb side : Cutout Tree Private 2   09/12/2017 12:00:00 AM 3 3x3 Permit Number 772214 6009763 2109812 37.7736924789578 -122.409658650953 (37.7736924789578, -122.409658650953) 8 2 9 28853 34
159122 253486 Planning Code 138.1 required 2 Trachycarpus fortunei :: Windmill Palm 116 1x Gordon St 4 Sidewalk: Curb side : Cutout Tree Private 2   09/12/2017 12:00:00 AM 3 3x3 Permit Number 772214 6009763 2109812 37.7736924789578 -122.409658650953 (37.7736924789578, -122.409658650953) 8 2 9 28853 34
169973 253496 Planning Code 138.1 required 2 Trachycarpus fortunei :: Windmill Palm 116 1x Gordon St 14 Sidewalk: Curb side : Cutout Tree Private 2   09/12/2017 12:00:00 AM 3 3x3 Permit Number 772214 6009763 2109812 37.7736924789578 -122.409658650953 (37.7736924789578, -122.409658650953) 8 2 9 28853 34
181014 253484 Planning Code 138.1 required 2 Trachycarpus fortunei :: Windmill Palm 116 1x Gordon St 2 Sidewalk: Curb side : Cutout Tree Private 2   09/12/2017 12:00:00 AM 3 3x3 Permit Number 772214 6009763 2109812 37.7736924789578 -122.409658650953 (37.7736924789578, -122.409658650953) 8 2 9 28853 34
190324 253494 Planning Code 138.1 required 2 Trachycarpus fortunei :: Windmill Palm 116 1x Gordon St 12 Sidewalk: Curb side : Cutout Tree Private 2   09/12/2017 12:00:00 AM 3 3x3 Permit Number 772214 6009763 2109812 37.7736924789578 -122.409658650953 (37.7736924789578, -122.409658650953) 8 2 9 28853 34
42342 215419 DPW Maintained 1 Trachycarpus fortunei :: Windmill Palm 116 1x Minerva St 36 Median : Cutout Tree DPW 1     10 Width 0ft   5996348.60637 2088999.95907 37.7157869222005 -122.454557070559 (37.7157869222005, -122.454557070559) 9 8 6 28861 24
171008 197987 DPW Maintained 1 Trachycarpus fortunei :: Windmill Palm 116 2 Bridgeview Dr 4 Front Yard : Yard Tree Private 2     9     6014076.35565 2095353.09382 37.7342321864689 -122.393725740265 (37.7342321864689, -122.393725740265) 10 3 8 58 1
32219 215432 DPW Maintained 1 Trachycarpus fortunei :: Windmill Palm 116 20 Lakewood Ave 3 Sidewalk: Curb side : Cutout Tree Private 2     8 Width 3ft   5993607.07382 2092934.57084 37.7264327944236 -122.464318491921 (37.7264327944236, -122.464318491921) 9 8 4 59 40
50185 215433 DPW Maintained 1 Trachycarpus fortunei :: Windmill Palm 116 20 Lakewood Ave 2 Sidewalk: Curb side : Cutout Tree Private 2     9 Width 3ft   5993594.89235 2092910.67012 37.726366466724 -122.464358867875 (37.726366466724, -122.464358867875) 9 8 4 59 40
58620 215431 DPW Maintained 1 Trachycarpus fortunei :: Windmill Palm 116 20 Lakewood Ave 4 Sidewalk: Curb side : Cutout Tree Private 2     8 Width 3ft   5993618.37614 2092959.38451 37.7265015781724 -122.464281221309 (37.7265015781724, -122.464281221309) 9 8 4 59 40
60373 215429 DPW Maintained 1 Trachycarpus fortunei :: Windmill Palm 116 20 Lakewood Ave 6 Sidewalk: Curb side : Cutout Tree Private 2     8 Width 3ft   5993645.02193 2093008.92736 37.726639146565 -122.464192703738 (37.726639146565, -122.464192703738) 9 8 4 59 40
85554 215428 DPW Maintained 1 Trachycarpus fortunei :: Windmill Palm 116 20 Lakewood Ave 7 Sidewalk: Curb side : Cutout Tree Private 2     10 Width 3ft   5993651.19736 2093024.90181 37.7266833644367 -122.464172514845 (37.7266833644367, -122.464172514845) 9 8 4 59 40
177793 215430 DPW Maintained 1 Trachycarpus fortunei :: Windmill Palm 116 20 Lakewood Ave 5 Sidewalk: Curb side : Cutout Tree Private 2     9 Width 3ft   5993628.72422 2092981.53442 37.7265629928729 -122.464247056069 (37.7265629928729, -122.464247056069) 9 8 4 59 40
181035 215434 DPW Maintained 1 Trachycarpus fortunei :: Windmill Palm 116 20 Lakewood Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     12 Width 3ft   5993586.39661 2092891.16546 37.7263124219742 -122.464386821508 (37.7263124219742, -122.464386821508) 9 8 4 59 40
51525 161041 DPW Maintained 1 Trachycarpus fortunei :: Windmill Palm 116 200 Munich St 1 Sidewalk: Property side : Cutout Tree Private 2   01/05/2018 12:00:00 AM 3 Width 0ft Permit Number 781115 6004713.602 2091215.63937 37.722346921643 -122.425801386648 (37.722346921643, -122.425801386648) 9 7 6 28861 5
180994 60926 DPW Maintained 1 Trachycarpus fortunei :: Windmill Palm 116 2000 Irving St 1 Sidewalk: Curb side : Cutout Tree Private 2   06/13/1983 12:00:00 AM 13 3x3 Permit Number 20727 5989507.2134 2106536.1763 37.7635420716385 -122.479486064031 (37.7635420716385, -122.479486064031) 1 8 3 56 35
176061 34654 DPW Maintained 1 Trachycarpus fortunei :: Windmill Palm 116 2000 Kirkham St 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/28/1997 12:00:00 AM 3   Permit Number 38332 5988619.0903 2105142.8889 37.7596648557466 -122.482455667505 (37.7596648557466, -122.482455667505) 1 8 3 56 35
45448 258476 DPW Maintained 1 Trachycarpus fortunei :: Windmill Palm 116 2025 Irving St 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   5989429 2106452 37.7633064029332 -122.479750416533 (37.7633064029332, -122.479750416533) 1 8 3 56 35
10207 258475 DPW Maintained 1 Trachycarpus fortunei :: Windmill Palm 116 2033 Irving St 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   5989468 2106464 37.7633416172482 -122.479616407921 (37.7633416172482, -122.479616407921) 1 8 3 56 35
130674 101284 DPW Maintained 1 Trachycarpus fortunei :: Windmill Palm 116 2034 Irving St 1 Sidewalk: Curb side : Cutout Tree Private 2     6 3x3   5989388.4992 2106533.1127 37.7635267635243 -122.479896429915 (37.7635267635243, -122.479896429915) 1 8 3 56 35
149347 101281 DPW Maintained 1 Trachycarpus fortunei :: Windmill Palm 116 2049 Irving St 1 Sidewalk: Curb side : Cutout Tree Private 2     4 3x3   5989322.9543 2106470.5284 37.7633511157788 -122.480118545713 (37.7633511157788, -122.480118545713) 1 8 3 56 35
169972 258424 DPW Maintained 1 Trachycarpus fortunei :: Windmill Palm 116 2050 Irving St 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   5989314 2106544 37.7635523285903 -122.480154892876 (37.7635523285903, -122.480154892876) 1 8 3 56 35
4646 215421 DPW Maintained 1 Trachycarpus fortunei :: Windmill Palm 116 2085 09th Ave 1 Sidewalk: Curb side : Yard Tree Private 2     7 Width 3ft   5993516.19097 2101401.96684 37.7496769094628 -122.465247440321 (37.7496769094628, -122.465247440321) 1 8 4 29491 40
28741 215420 DPW Maintained 1 Trachycarpus fortunei :: Windmill Palm 116 2085 09th Ave 2 Sidewalk: Curb side : Yard Tree Private 2     7 Width 3ft   5993528.81827 2101394.66819 37.7496575974161 -122.465203244928 (37.7496575974161, -122.465203244928) 1 8 4 29491 40
92770 258425 DPW Maintained 1 Trachycarpus fortunei :: Windmill Palm 116 2100 Irving St 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   5989196 2106551 37.7635646915697 -122.480563525243 (37.7635646915697, -122.480563525243) 1 8 3 56 35
165500 258474 DPW Maintained 1 Trachycarpus fortunei :: Windmill Palm 116 2115 Irving St 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   5989132 2106442 37.7632616874488 -122.480776898017 (37.7632616874488, -122.480776898017) 1 8 3 56 35
188827 258426 DPW Maintained 1 Trachycarpus fortunei :: Windmill Palm 116 2116 Irving St 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   5989195 2106551 37.7635646334525 -122.480566983887 (37.7635646334525, -122.480566983887) 1 8 3 56 35
124668 181320 DPW Maintained 1 Trachycarpus fortunei :: Windmill Palm 116 2126 Irving St 1 Sidewalk: Curb side : Cutout Tree Private 2     8 3x3   5989173 2106514 37.7634617628894 -122.480640365287 (37.7634617628894, -122.480640365287) 1 8 3 56 35
107491 258427 DPW Maintained 1 Trachycarpus fortunei :: Windmill Palm 116 2142 Irving St 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   5989006 2106545 37.7635371731016 -122.481220228107 (37.7635371731016, -122.481220228107) 1 8 3 56 35
116276 258428 DPW Maintained 1 Trachycarpus fortunei :: Windmill Palm 116 2154 Irving St 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   5989006 2106545 37.7635371731016 -122.481220228107 (37.7635371731016, -122.481220228107) 1 8 3 56 35
7183 42736 Permitted Site 7 Trachycarpus fortunei :: Windmill Palm 116 2155 Bay Shore Blvd 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/26/2000 12:00:00 AM     Permit Number 42735 6011836.19977805 2087516.89388515 37.7125908452343 -122.400920338197 (37.7125908452343, -122.400920338197) 10 3 8 309 1
112826 42735 Permitted Site 7 Trachycarpus fortunei :: Windmill Palm 116 2155 Bay Shore Blvd 4 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/26/2000 12:00:00 AM     Permit Number 42735 6011836.19977805 2087516.89388515 37.7125908452343 -122.400920338197 (37.7125908452343, -122.400920338197) 10 3 8 309 1
118808 42738 Permitted Site 7 Trachycarpus fortunei :: Windmill Palm 116 2155 Bay Shore Blvd 3 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/26/2000 12:00:00 AM     Permit Number 42735 6011836.19977805 2087516.89388515 37.7125908452343 -122.400920338197 (37.7125908452343, -122.400920338197) 10 3 8 309 1
137854 42733 Permitted Site 7 Trachycarpus fortunei :: Windmill Palm 116 2155 Bay Shore Blvd 5 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/26/2000 12:00:00 AM     Permit Number 42735 6011836.19977805 2087516.89388515 37.7125908452343 -122.400920338197 (37.7125908452343, -122.400920338197) 10 3 8 309 1
155074 42737 Permitted Site 7 Trachycarpus fortunei :: Windmill Palm 116 2155 Bay Shore Blvd 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/26/2000 12:00:00 AM     Permit Number 42735 6011836.19977805 2087516.89388515 37.7125908452343 -122.400920338197 (37.7125908452343, -122.400920338197) 10 3 8 309 1
159508 42739 Permitted Site 7 Trachycarpus fortunei :: Windmill Palm 116 2155 Bay Shore Blvd 7 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/26/2000 12:00:00 AM     Permit Number 42735 6011836.19977805 2087516.89388515 37.7125908452343 -122.400920338197 (37.7125908452343, -122.400920338197) 10 3 8 309 1
85930 215438 DPW Maintained 1 Trachycarpus fortunei :: Windmill Palm 116 217 Staples Ave 5 Sidewalk: Curb side : Cutout Tree Private 2     11 Width 2ft   5998696.43814 2093778.97623 37.7290433761531 -122.446785584491 (37.7290433761531, -122.446785584491) 9 7 4 28861 40
117606 215439 DPW Maintained 1 Trachycarpus fortunei :: Windmill Palm 116 217 Staples Ave 6 Sidewalk: Curb side : Cutout Tree Private 2     13 Width 2ft   5998709.41817 2093777.72882 37.729040692553 -122.44674062198 (37.729040692553, -122.44674062198) 9 7 4 28861 40
167583 215437 DPW Maintained 1 Trachycarpus fortunei :: Windmill Palm 116 217 Staples Ave 4 Sidewalk: Curb side : Cutout Tree Private 2     12 Width 2ft   5998668.44451 2093778.09263 37.729039350777 -122.446882296697 (37.729039350777, -122.446882296697) 9 7 4 28861 40
49201 258472 DPW Maintained 1 Trachycarpus fortunei :: Windmill Palm 116 2181 Irving St 1 Sidewalk: Curb side : Cutout Tree Private 2       3x4   5989030 2106439 37.7632475211429 -122.481129458533 (37.7632475211429, -122.481129458533) 1 8 3 56 35
124283 246465 DPW Maintained 1 Trachycarpus fortunei :: Windmill Palm 116 220 Duncan St 1 : Tree Private 2     10 Width 3ft   6005035.80445 2099919.28541 37.7462633887397 -122.425306657892 (37.7462633887397, -122.425306657892) 2 7 5 63 22
193222 258429 DPW Maintained 1 Trachycarpus fortunei :: Windmill Palm 116 2206 Irving St 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   5988870 2106540 37.7635155369644 -122.481690237146 (37.7635155369644, -122.481690237146) 1 8 3 56 35
119624 182028 DPW Maintained 1 Trachycarpus fortunei :: Windmill Palm 116 2219 Irving St 1 Sidewalk: Curb side : Cutout Tree Private 2     7 3x3   5988830 2106432 37.7632166722568 -122.481820671399 (37.7632166722568, -122.481820671399) 1 8 3 56 35
163142 258471 DPW Maintained 1 Trachycarpus fortunei :: Windmill Palm 116 2229 Irving St 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   5988796 2106431 37.7632119492313 -122.481938191449 (37.7632119492313, -122.481938191449) 1 8 3 56 35
60671 103568 Undocumented 4 Trachycarpus fortunei :: Windmill Palm 116 223 Parnassus Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     8 3x3   5997125.5 2106655.6 37.7643095465843 -122.453145590268 (37.7643095465843, -122.453145590268) 15 5 11 29492 12
153365 101268 DPW Maintained 1 Trachycarpus fortunei :: Windmill Palm 116 2240 Irving St 1 Sidewalk: Curb side : Cutout Tree Private 2     10 3x3   5988685.6106 2106506.2437 37.7634121273454 -122.482325500356 (37.7634121273454, -122.482325500356) 1 8 3 56 35
50833 110355 DPW Maintained 1 Trachycarpus fortunei :: Windmill Palm 116 2300 Irving St 1 Sidewalk: Curb side : Cutout Tree Private 2     12 3x3   5988563.2444 2106497.4984 37.76338099647 -122.482748079472 (37.76338099647, -122.482748079472) 1 8 3 56 35
150208 101279 DPW Maintained 1 Trachycarpus fortunei :: Windmill Palm 116 2301 Irving St 1 Sidewalk: Curb side : Cutout Tree Private 2     8 3x3   5988600.1162 2106446.7223 37.7632437243179 -122.482616832407 (37.7632437243179, -122.482616832407) 1 8 3 56 35
174905 101273 DPW Maintained 1 Trachycarpus fortunei :: Windmill Palm 116 2324 Irving St 1 Sidewalk: Curb side : Cutout Tree Private 2           5988506 2106527 37.7634586690964 -122.482948229193 (37.7634586690964, -122.482948229193) 1 8 3 56 35
33664 181619 DPW Maintained 1 Trachycarpus fortunei :: Windmill Palm 116 2340 Irving St 1 Sidewalk: Curb side : Cutout Tree Private 2     10 3x3   5988436.1054 2106493.669 37.7633630840514 -122.483187525947 (37.7633630840514, -122.483187525947) 1 8 3 56 35
82012 181620 DPW Maintained 1 Trachycarpus fortunei :: Windmill Palm 116 2340 Irving St 2 Sidewalk: Curb side : Cutout Tree Private 2     10 3x3   5988409.299 2106492.1372 37.7633573181337 -122.483280127139 (37.7633573181337, -122.483280127139) 1 8 3 56 35
106828 181621 DPW Maintained 1 Trachycarpus fortunei :: Windmill Palm 116 2340 Irving St 3 Sidewalk: Curb side : Cutout Tree Private 2     12 3x3   5988377.8972 2106492.1372 37.7633554905962 -122.483388734412 (37.7633554905962, -122.483388734412) 1 8 3 56 35
127663 258439 DPW Maintained 1 Trachycarpus fortunei :: Windmill Palm 116 2341 Irving St 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   5988410 2106416 37.7631483069578 -122.483272121252 (37.7631483069578, -122.483272121252) 1 8 3 56 35
29945 241206 DPW Maintained 1 Trachycarpus fortunei :: Windmill Palm 116 2387 Folsom St 1 Sidewalk: Curb side : Cutout Tree Private 2     13 Width 4ft   6008217.68506 2104568.2265 37.759207580982 -122.414632997525 (37.759207580982, -122.414632997525) 2 4 7 28859 19
178255 241205 DPW Maintained 1 Trachycarpus fortunei :: Windmill Palm 116 2389 Folsom St 1 Sidewalk: Curb side : Cutout Tree Private 2     12 Width 4ft   6008219.00846 2104543.89441 37.7591408449879 -122.414626698671 (37.7591408449879, -122.414626698671) 2 4 7 28859 19
190621 63542 Permitted Site 7 Trachycarpus fortunei :: Windmill Palm 116 2389 Folsom St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 04/13/1987 12:00:00 AM     Permit Number 24157 6008220.8181992 2104530.13411616 37.7591031640479 -122.414619465951 (37.7591031640479, -122.414619465951) 2 4 7 28859 19
129697 98644 Undocumented 4 Trachycarpus fortunei :: Windmill Palm 116 2391 Folsom St 1 Sidewalk: Curb side : Cutout Tree Private 2     8 3x3   6008222 2104509 37.7590452010005 -122.414613883143 (37.7590452010005, -122.414613883143) 2 4 7 28859 19
108025 241204 DPW Maintained 1 Trachycarpus fortunei :: Windmill Palm 116 2399 Folsom St 2 Sidewalk: Curb side : Cutout Tree Private 2     7 Width 4ft   6008220.32471 2104519.20022 37.7590731143473 -122.414620398932 (37.7590731143473, -122.414620398932) 2 4 7 28859 19
181127 241203 DPW Maintained 1 Trachycarpus fortunei :: Windmill Palm 116 2399 Folsom St 1 Sidewalk: Curb side : Cutout Tree Private 2     7 Width 4ft   6008221.76709 2104500.66986 37.7590223152579 -122.414614099173 (37.7590223152579, -122.414614099173) 2 4 7 28859 19
103122 241199 DPW Maintained 1 Trachycarpus fortunei :: Windmill Palm 116 24 Carl St 1 Sidewalk: Curb side : Cutout Tree Private 2     9 Width 4ft   5998508.2304 2107266.01278 37.7660647371231 -122.448407097228 (37.7660647371231, -122.448407097228) 15 5 11 29492 9
33886 179953 DPW Maintained 1 Trachycarpus fortunei :: Windmill Palm 116 240 Peabody St 1 : Tree Private 2     17 Width 3ft   6009701.77248 2086128.1297 37.7086582895102 -122.408199733244 (37.7086582895102, -122.408199733244) 9 7 8 309 39
60510 34081 Permitted Site 7 Trachycarpus fortunei :: Windmill Palm 116 240 SHOTWELL ST 4 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/05/1997 12:00:00 AM 6 3x3 Permit Number 37968 6007737.2 2106597 37.7647511168143 -122.416438454623 (37.7647511168143, -122.416438454623) 8 4 7 28859 19
13922 34080 Permitted Site 7 Trachycarpus fortunei :: Windmill Palm 116 240 Shotwell St 3 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/05/1997 12:00:00 AM 6 3x3 Permit Number 37968 6007780.97837226 2105869.55428135 37.7627561815899 -122.41623551069 (37.7627561815899, -122.41623551069) 8 4 7 28859 19
30821 108222 Permitted Site 7 Trachycarpus fortunei :: Windmill Palm 116 240 Shotwell St 11 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6007737.2 2106597 37.7647511168143 -122.416438454623 (37.7647511168143, -122.416438454623) 8 4 7 28859 19
34216 34084 Permitted Site 7 Trachycarpus fortunei :: Windmill Palm 116 240 Shotwell St 7 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/05/1997 12:00:00 AM 6 3x3 Permit Number 37968 6007780.97837226 2105869.55428135 37.7627561815899 -122.41623551069 (37.7627561815899, -122.41623551069) 8 4 7 28859 19
64915 34083 Permitted Site 7 Trachycarpus fortunei :: Windmill Palm 116 240 Shotwell St 6 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/05/1997 12:00:00 AM 6 3x3 Permit Number 37968 6007780.97837226 2105869.55428135 37.7627561815899 -122.41623551069 (37.7627561815899, -122.41623551069) 8 4 7 28859 19
97320 34082 Permitted Site 7 Trachycarpus fortunei :: Windmill Palm 116 240 Shotwell St 5 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/05/1997 12:00:00 AM 6 3x3 Permit Number 37968 6007780.97837226 2105869.55428135 37.7627561815899 -122.41623551069 (37.7627561815899, -122.41623551069) 8 4 7 28859 19
106666 108225 Permitted Site 7 Trachycarpus fortunei :: Windmill Palm 116 240 Shotwell St 14 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6007737.2 2106597 37.7647511168143 -122.416438454623 (37.7647511168143, -122.416438454623) 8 4 7 28859 19
109210 34079 Permitted Site 7 Trachycarpus fortunei :: Windmill Palm 116 240 Shotwell St 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/05/1997 12:00:00 AM 6 3x3 Permit Number 37968 6007780.97837226 2105869.55428135 37.7627561815899 -122.41623551069 (37.7627561815899, -122.41623551069) 8 4 7 28859 19
114315 108221 Permitted Site 7 Trachycarpus fortunei :: Windmill Palm 116 240 Shotwell St 10 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6007737.2 2106597 37.7647511168143 -122.416438454623 (37.7647511168143, -122.416438454623) 8 4 7 28859 19
158584 108224 Permitted Site 7 Trachycarpus fortunei :: Windmill Palm 116 240 Shotwell St 13 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6007737.2 2106597 37.7647511168143 -122.416438454623 (37.7647511168143, -122.416438454623) 8 4 7 28859 19
159322 108227 Permitted Site 7 Trachycarpus fortunei :: Windmill Palm 116 240 Shotwell St 16 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6007737.2 2106597 37.7647511168143 -122.416438454623 (37.7647511168143, -122.416438454623) 8 4 7 28859 19
164496 108220 Permitted Site 7 Trachycarpus fortunei :: Windmill Palm 116 240 Shotwell St 9 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6007737.2 2106597 37.7647511168143 -122.416438454623 (37.7647511168143, -122.416438454623) 8 4 7 28859 19
185834 108226 Permitted Site 7 Trachycarpus fortunei :: Windmill Palm 116 240 Shotwell St 15 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6007737.2 2106597 37.7647511168143 -122.416438454623 (37.7647511168143, -122.416438454623) 8 4 7 28859 19
190238 108223 Permitted Site 7 Trachycarpus fortunei :: Windmill Palm 116 240 Shotwell St 12 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6007737.2 2106597 37.7647511168143 -122.416438454623 (37.7647511168143, -122.416438454623) 8 4 7 28859 19
193047 88286 Permitted Site 7 Trachycarpus fortunei :: Windmill Palm 116 240 Shotwell St 1 Sidewalk: Curb side : Cutout Tree Private 2   07/09/2008 12:00:00 AM   3x3 Permit Number 51287 6007754 2106536 37.7645845697556 -122.416376026653 (37.7645845697556, -122.416376026653) 8 4 7 28859 19
137988 56678 DPW Maintained 1 Trachycarpus fortunei :: Windmill Palm 116 2400 Irving St 1 Sidewalk: Curb side : Cutout Tree Private 2     12 3x3   5988274.3719 2106490.5517 37.7633451115211 -122.483746674042 (37.7633451115211, -122.483746674042) 1 8 3 56 35
114591 258438 DPW Maintained 1 Trachycarpus fortunei :: Windmill Palm 116 2425 Irving St 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   5988206.1929 2106434.2769 37.7631866273281 -122.483978353246 (37.7631866273281, -122.483978353246) 1 8 3 56 35
135749 100964 DPW Maintained 1 Trachycarpus fortunei :: Windmill Palm 116 2425 Irving St 2 Sidewalk: Curb side : Cutout Tree Private 2     11 3x3   5988206.1929 2106434.2769 37.7631866273281 -122.483978353246 (37.7631866273281, -122.483978353246) 1 8 3 56 35
116314 258437 DPW Maintained 1 Trachycarpus fortunei :: Windmill Palm 116 2435 Irving St 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   5988177 2106369 37.763005695226 -122.484074533324 (37.763005695226, -122.484074533324) 1 8 3 56 35
169337 258432 DPW Maintained 1 Trachycarpus fortunei :: Windmill Palm 116 2450 Irving St 3 Sidewalk: Curb side : Cutout Tree Private 2       3x3   5988181.8432 2106487.3051 37.7633308106608 -122.484066458576 (37.7633308106608, -122.484066458576) 1 8 3 56 35
20538 42308 Permitted Site 7 Trachycarpus fortunei :: Windmill Palm 116 249 Edna St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/23/2000 12:00:00 AM     Permit Number 42531 5998732.34943109 2093642.59637242 37.7286709604577 -122.446651628377 (37.7286709604577, -122.446651628377) 9 7 4 28861 40
89456 42310 Permitted Site 7 Trachycarpus fortunei :: Windmill Palm 116 249 Edna St 3 Sidewalk: Curb side : Cutout Tree Private 2   06/23/2000 12:00:00 AM     Permit Number 42531 5998732.34943109 2093642.59637242 37.7286709604577 -122.446651628377 (37.7286709604577, -122.446651628377) 9 7 4 28861 40
116195 42309 Permitted Site 7 Trachycarpus fortunei :: Windmill Palm 116 249 Edna St 2 Sidewalk: Curb side : Cutout Tree Private 2   06/23/2000 12:00:00 AM     Permit Number 42531 5998732.34943109 2093642.59637242 37.7286709604577 -122.446651628377 (37.7286709604577, -122.446651628377) 9 7 4 28861 40
118475 100963 DPW Maintained 1 Trachycarpus fortunei :: Windmill Palm 116 2495 Irving St 1 Sidewalk: Curb side : Cutout Tree Private 2     8 3x3   5988177 2106369 37.763005695226 -122.484074533324 (37.763005695226, -122.484074533324) 1 8 3 56 35
81340 41897 Permitted Site 7 Trachycarpus fortunei :: Windmill Palm 116 2500 Market St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/20/2000 12:00:00 AM     Permit Number 42262 6001987.05760353 2105790.14936536 37.762210660505 -122.436268917311 (37.762210660505, -122.436268917311) 15 4 5 28862 3
74382 181317 DPW Maintained 1 Trachycarpus fortunei :: Windmill Palm 116 2520 Irving St 6 Sidewalk: Curb side : Cutout Tree Private 2     5 Width 0ft   5987802.3945 2106472.9578 37.7632693181117 -122.48537777809 (37.7632693181117, -122.48537777809) 1 8 3 56 35
104558 181643 DPW Maintained 1 Trachycarpus fortunei :: Windmill Palm 116 2520 Irving St 7 Sidewalk: Curb side : Cutout Tree Private 2     5 3x3   5987777.5915 2106472.9578 37.7632678730962 -122.485463562399 (37.7632678730962, -122.485463562399) 1 8 3 56 35
152615 181644 DPW Maintained 1 Trachycarpus fortunei :: Windmill Palm 116 2520 Irving St 8 Sidewalk: Curb side : Cutout Tree Private 2     5 3x3   5987753.3791 2106472.9578 37.7632664624287 -122.485547304041 (37.7632664624287, -122.485547304041) 1 8 3 56 35
116325 258433 DPW Maintained 1 Trachycarpus fortunei :: Windmill Palm 116 2555 Irving St 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   5987757 2106384 37.7630224196739 -122.485528252067 (37.7630224196739, -122.485528252067) 1 8 3 56 35
75935 241200 DPW Maintained 1 Trachycarpus fortunei :: Windmill Palm 116 26 Carl St 2 Sidewalk: Curb side : Cutout Tree Private 2     10 Width 4ft   5998502.5017 2107263.12139 37.7660564705643 -122.448426703328 (37.7660564705643, -122.448426703328) 15 5 11 29492 9

Next page

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options: 

CREATE TABLE "trees" (
   [rowid] INTEGER PRIMARY KEY,
   [TreeID] TEXT,
   [qLegalStatus_id] INTEGER REFERENCES [qLegalStatus]([id]),
   [qSpecies_id] INTEGER,
   [qAddress] TEXT,
   [SiteOrder] TEXT,
   [qSiteInfo] TEXT,
   [PlantType] TEXT,
   [qCaretaker_id] INTEGER REFERENCES [qCaretaker]([id]),
   [qCareAssistant] TEXT,
   [PlantDate] TEXT,
   [DBH] TEXT,
   [PlotSize] TEXT,
   [PermitNotes] TEXT,
   [XCoord] TEXT,
   [YCoord] TEXT,
   [Latitude] TEXT,
   [Longitude] TEXT,
   [Location] TEXT,
   [Fire Prevention Districts] TEXT,
   [Police Districts] TEXT,
   [Supervisor Districts] TEXT,
   [Zip Codes] TEXT,
   [Neighborhoods (old)] TEXT,
   FOREIGN KEY(qSpecies_id) REFERENCES qSpecies(id)
);