897 rows where qSpecies_id = 160

View and edit SQL

Suggested facets: qLegalStatus_id, Fire Prevention Districts, Neighborhoods (old)

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)
1012 24992 DPW Maintained 1 Phoenix canariensis :: Canary Island Date Palm 160 340 Dolores St 3 Median : Cutout Tree DPW 1     90 20   6004882.50848 2106257.62148 37.7636583150142 -122.426287928865 (37.7636583150142, -122.426287928865) 8 4 5 28859 3
1062 20065 DPW Maintained 1 Phoenix canariensis :: Canary Island Date Palm 160 100 STAIRWAY54 12 Sidewalk: Curb side : Cutout Tree DPW 1     3 15ST                      
1174 259410 DPW Maintained 1 Phoenix canariensis :: Canary Island Date Palm 160 201x The Embarcadero 7 Median : Cutout Tree Private 2       3x3   6013700 2118549 37.7979020921151 -122.396652459006 (37.7979020921151, -122.396652459006) 3 1 10 28860 6
1493 264741 Landmark tree 11 Phoenix canariensis :: Canary Island Date Palm 160 2040 Sutter St 2 Back Yard : Yard Tree Private 2           6002832.74822 2114456.05498 37.7860531044459 -122.433963466929 (37.7860531044459, -122.433963466929) 13 9 11 29490 27
1504 19794 DPW Maintained 1 Phoenix canariensis :: Canary Island Date Palm 160 100 STAIRWAY19 16 Sidewalk: Curb side : Cutout Tree DPW 1     18 50ST                      
1611 247638 DPW Maintained 1 Phoenix canariensis :: Canary Island Date Palm 160 360 Bradford St 2 Sidewalk: Curb side : Yard Tree Private 2     15     6009465.98098 2096572.55437 37.7373232876386 -122.409751390215 (37.7373232876386, -122.409751390215) 10 7 7 28859 2
1681 132077 DPW Maintained 1 Phoenix canariensis :: Canary Island Date Palm 160 1100x The Embarcadero 7 Median : Yard Tree DPW 1     23 Width 10ft   6012714.412 2120058.13658 37.8019909162964 -122.400168938451 (37.8019909162964, -122.400168938451) 3 1 10 28860 6
1977 132113 DPW Maintained 1 Phoenix canariensis :: Canary Island Date Palm 160 1000x The Embarcadero 2 Median : Yard Tree DPW 1     21 Width 10ft   6013330.52243 2119204.92075 37.7996825238869 -122.397977001937 (37.7996825238869, -122.397977001937) 3 1 10 28860 6
2509 27941 Permitted Site 7 Phoenix canariensis :: Canary Island Date Palm 160 699 The Embarcadero 2 Median : Cutout Tree Port 6   02/01/2001 12:00:00 AM 24     6012787.5534626 2119857.700218 37.8014446443351 -122.399901749617 (37.8014446443351, -122.399901749617) 3 1 10 28860 6
2957 25027 DPW Maintained 1 Phoenix canariensis :: Canary Island Date Palm 160 740X Dolores St 2 Median : Cutout Tree DPW 1     80 20   6004958.5167563 2104022.9997464 37.7575268683213 -122.425865966748 (37.7575268683213, -122.425865966748) 2 4 5 28862 3
3088 261629 DPW Maintained 1 Phoenix canariensis :: Canary Island Date Palm 160 620x The Embarcadero 1 Sidewalk: Property side : Yard Tree DPW 1       3x3   6012640 2120258 37.8025355435841 -122.400440487668 (37.8025355435841, -122.400440487668) 3 1 10 28860 6
3522 25785 Permitted Site 7 Phoenix canariensis :: Canary Island Date Palm 160 500X The Embarcadero 4 Median : Cutout Tree Port 6   08/30/1996 12:00:00 AM 36 10   6013445.7547399 2119056.6213274 37.7992817461076 -122.397567846492 (37.7992817461076, -122.397567846492) 3 1 10 28860 6
3537 18548 Landmark tree 11 Phoenix canariensis :: Canary Island Date Palm 160 1700X Quesada Ave 3 Median : Cutout Tree DPW 1     30 19   6014665.0129 2095058.69239 37.7334565140045 -122.391669970993 (37.7334565140045, -122.391669970993) 10 3 8 58 1
3603 247549 DPW Maintained 1 Phoenix canariensis :: Canary Island Date Palm 160 815 Buena Vista Ave West 6 Sidewalk: Property side : Yard Tree Private 2     32 Width 2ft   6000106.41756 2108406.30035 37.7692869261681 -122.442961199511 (37.7692869261681, -122.442961199511) 15 5 11 29492 9
4101 261179 DPW Maintained 1 Phoenix canariensis :: Canary Island Date Palm 160 205 Leland Ave 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6009827 2087549 37.7125667222905 -122.407867055005 (37.7125667222905, -122.407867055005) 9 7 8 309 39
4245 28231 DPW Maintained 1 Phoenix canariensis :: Canary Island Date Palm 160 399X King St 14 Sidewalk: Curb side : Cutout Tree DPW 1     12     6013667.5202917 2110028.9140531 37.7745060991794 -122.396167417116 (37.7745060991794, -122.396167417116) 14 2 9 310 20
4408 234354 DPW Maintained 1 Phoenix canariensis :: Canary Island Date Palm 160 650x Dolores St 1 Median : Yard Tree DPW 1     23     6004979.81363 2104508.34972 37.7588607286626 -122.425826859935 (37.7588607286626, -122.425826859935) 2 4 5 28862 3
4436 194278 DPW Maintained 1 Phoenix canariensis :: Canary Island Date Palm 160 1750 22nd St 7 Side Yard : Yard Tree Private 2     5     6012817.61072 2103799.38432 37.7573538722899 -122.398670182286 (37.7573538722899, -122.398670182286) 10 3 8 28856 29
4871 132103 DPW Maintained 1 Phoenix canariensis :: Canary Island Date Palm 160 1400x The Embarcadero 1 Median : Yard Tree DPW 1     18 Width 10ft   6012095.78368 2120981.89347 37.8044928149639 -122.402374687645 (37.8044928149639, -122.402374687645) 3 1 10 28860 6
4941 186180 DPW Maintained 1 Phoenix canariensis :: Canary Island Date Palm 160 1700 Sunset Blvd 65 Sidewalk: Property side : Yard Tree Private 2     6 Width 0ft   5984958.094 2103565.49 37.7551201057822 -122.495000731871 (37.7551201057822, -122.495000731871) 1 8 3 56 35
5116 25071 DPW Maintained 1 Phoenix canariensis :: Canary Island Date Palm 160 1100X Dolores St 2 Median : Cutout Tree DPW 1     80 20   6005127.37654 2101840.69033 37.7515442968352 -122.42512670443 (37.7515442968352, -122.42512670443) 2 4 5 28862 22
6713 25016 DPW Maintained 1 Phoenix canariensis :: Canary Island Date Palm 160 710X Dolores St 1 Median : Cutout Tree DPW 1     70 20   6004949.2547318 2104210.5607703 37.7580413433618 -122.425911349448 (37.7580413433618, -122.425911349448) 2 4 5 28862 3
7075 25030 DPW Maintained 1 Phoenix canariensis :: Canary Island Date Palm 160 740X Dolores St 5 Median : Cutout Tree DPW 1     70 20   6004958.5167563 2104022.9997464 37.7575268683213 -122.425865966748 (37.7575268683213, -122.425865966748) 2 4 5 28862 3
7222 25538 DPW Maintained 1 Phoenix canariensis :: Canary Island Date Palm 160 2200X Market St 4 Median : Cutout Tree DPW 1   04/01/1993 12:00:00 AM 36 20   6003277.964 2106841.2745 37.7651700578839 -122.431879221699 (37.7651700578839, -122.431879221699) 15 4 5 28862 3
7512 234395 DPW Maintained 1 Phoenix canariensis :: Canary Island Date Palm 160 599X Ogden Ave 1 Sidewalk: Curb side : Yard Tree Private 2     15 Width 4ft   6008504 2096098 37.7359663084052 -122.413043870385 (37.7359663084052, -122.413043870385) 10 7 7 28859 2
7561 178088 DPW Maintained 1 Phoenix canariensis :: Canary Island Date Palm 160 201 Chicago Way 2 Sidewalk: Curb side : Cutout Tree Private 2     31 Width 3ft   6003023.7628 2086943.78146 37.7105216991954 -122.431337972882 (37.7105216991954, -122.431337972882) 9 7 6 28861 5
7822 26018 Permitted Site 7 Phoenix canariensis :: Canary Island Date Palm 160 899X The Embarcadero 2 Median : Cutout Tree Port 6   12/01/2000 12:00:00 AM 36 10   6012483.6012207 2120310.1113669 37.8026699057947 -122.400985372375 (37.8026699057947, -122.400985372375) 3 1 10 28860 6
8261 25749 Permitted Site 7 Phoenix canariensis :: Canary Island Date Palm 160 1301X The Embarcadero 2 Median : Cutout Tree Port 6   08/30/1996 12:00:00 AM 36 10   6011423.5148387 2121491.4283584 37.805854321699 -122.404737040358 (37.805854321699, -122.404737040358) 3 1 10 28860 23
8378 25503 DPW Maintained 1 Phoenix canariensis :: Canary Island Date Palm 160 1900X Market St 3 Median : Cutout Tree DPW 1   04/01/1993 12:00:00 AM 36 8   6005164.8443 2108651.7776 37.7702480498919 -122.425481812147 (37.7702480498919, -122.425481812147) 7 2 5 28853 19
8561 25119 DPW Maintained 1 Phoenix canariensis :: Canary Island Date Palm 160 1500X Dolores St 6 Median : Cutout Tree DPW 1     30 20   6005258.69008 2099408.1764 37.7448725899054 -122.42449959639 (37.7448725899054, -122.42449959639) 2 7 5 63 22
9418 251108 Landmark tree 11 Phoenix canariensis :: Canary Island Date Palm 160 1700X Quesada Ave 2 Median : Yard Tree DPW 1                              
9423 25058 DPW Maintained 1 Phoenix canariensis :: Canary Island Date Palm 160 1000X Dolores St 1 Median : Cutout Tree DPW 1     90 20   6005092.48697 2102458.1018 37.753237594342 -122.425291287561 (37.753237594342, -122.425291287561) 2 4 5 28862 22
9494 259411 DPW Maintained 1 Phoenix canariensis :: Canary Island Date Palm 160 201x The Embarcadero 1 Median : Cutout Tree Private 2       3x3   6013700 2118549 37.7979020921151 -122.396652459006 (37.7979020921151, -122.396652459006) 3 1 10 28860 6
9507 132129 DPW Maintained 1 Phoenix canariensis :: Canary Island Date Palm 160 500x The Embarcadero 9 Median : Yard Tree DPW 1     24 Width 10ft   6013671.61354 2118630.60451 37.7981245788406 -122.3967564088 (37.7981245788406, -122.3967564088) 3 1 10 28860 6
9676 194361 DPW Maintained 1 Phoenix canariensis :: Canary Island Date Palm 160 380x The Embarcadero 8 Median : Yard Tree DPW 1     28 Width 8ft   6016114.70966 2114269.45463 37.7862855364823 -122.38799801482 (37.7862855364823, -122.38799801482) 6 2 9 28856 6
9755 194362 DPW Maintained 1 Phoenix canariensis :: Canary Island Date Palm 160 380x The Embarcadero 9 Median : Yard Tree DPW 1     29 Width 8ft   6016123.07303 2114362.83881 37.786542411639 -122.387975598289 (37.786542411639, -122.387975598289) 6 2 9 28856 6
9943 25035 DPW Maintained 1 Phoenix canariensis :: Canary Island Date Palm 160 794X Dolores St 4 Median : Cutout Tree DPW 1     60 20   6004985.41588 2103704.6857762 37.7566543729812 -122.425750282521 (37.7566543729812, -122.425750282521) 2 4 5 28862 3
10155 251115 Landmark tree 11 Phoenix canariensis :: Canary Island Date Palm 160 1700X Quesada Ave 19 Median : Yard Tree DPW 1                              
11271 194293 DPW Maintained 1 Phoenix canariensis :: Canary Island Date Palm 160 1700x Quesada Ave 46 Median : Yard Tree DPW 1     28     6014318.79649 2095319.19207 37.7341525685742 -122.392885167337 (37.7341525685742, -122.392885167337) 10 3 8 58 1
11369 28185 DPW Maintained 1 Phoenix canariensis :: Canary Island Date Palm 160 299X King St 3 Sidewalk: Curb side : Cutout Tree DPW 1     12 6   6014324.7762427 2110655.258445 37.7762624487031 -122.393937678457 (37.7762624487031, -122.393937678457) 6 2 9 28856 20
12082 210917 DPW Maintained 1 Phoenix canariensis :: Canary Island Date Palm 160 380 Kingston St 8 Sidewalk: Curb side : Yard Tree Private 2     37 Width 4ft   5994023.92221 2099259.09244 37.7438223849926 -122.463336219994 (37.7438223849926, -122.463336219994) 1 8 4 59 40
12278 259406 DPW Maintained 1 Phoenix canariensis :: Canary Island Date Palm 160 201x The Embarcadero 3 Median : Cutout Tree Private 2       3x3   6013700 2118549 37.7979020921151 -122.396652459006 (37.7979020921151, -122.396652459006) 3 1 10 28860 6
12845 259408 DPW Maintained 1 Phoenix canariensis :: Canary Island Date Palm 160 201x The Embarcadero 5 Median : Cutout Tree Private 2       3x3   6013700 2118549 37.7979020921151 -122.396652459006 (37.7979020921151, -122.396652459006) 3 1 10 28860 6
12943 246349 DPW Maintained 1 Phoenix canariensis :: Canary Island Date Palm 160 2190x Market St 1 Median : Cutout Tree DPW 1     31 Width 0ft   6003723.2107 2107266.4094 37.7663626060268 -122.430369556243 (37.7663626060268, -122.430369556243) 8 4 5 28862 3
12966 251112 Landmark tree 11 Phoenix canariensis :: Canary Island Date Palm 160 1700X Quesada Ave 14 Median : Tree DPW 1                              
13313 251111 Landmark tree 11 Phoenix canariensis :: Canary Island Date Palm 160 1700X Quesada Ave 7 Median : Yard Tree DPW 1                              
13403 261178 Property Tree 8 Phoenix canariensis :: Canary Island Date Palm 160 205 Leland Ave 2 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6009827 2087549 37.7125667222905 -122.407867055005 (37.7125667222905, -122.407867055005) 9 7 8 309 39
13831 251113 Landmark tree 11 Phoenix canariensis :: Canary Island Date Palm 160 1700X Quesada Ave 15 Median : Yard Tree DPW 1                              
14024 194292 DPW Maintained 1 Phoenix canariensis :: Canary Island Date Palm 160 1700x Quesada Ave 43 Median : Yard Tree DPW 1     38     6014354.24031 2095291.86255 37.7340794959614 -122.392760714642 (37.7340794959614, -122.392760714642) 10 3 8 58 1
14183 234399 DPW Maintained 1 Phoenix canariensis :: Canary Island Date Palm 160 319 Virginia Ave 5 Sidewalk: Curb side : Yard Tree Private 2     39 Width 3ft   6006918.01461 2098154.19018 37.7415229912067 -122.418673038125 (37.7415229912067, -122.418673038125) 2 7 7 28859 2
14706 118708 DPW Maintained 1 Phoenix canariensis :: Canary Island Date Palm 160 4201 Balboa St 5 Sidewalk: Property side : Yard Tree Private 2     18 Width 2ft   5982482.88801 2110969.6299 37.7753045397791 -122.504108985066 (37.7753045397791, -122.504108985066) 11 6 2 55 26
14999 233935 DPW Maintained 1 Phoenix canariensis :: Canary Island Date Palm 160 150x Dolores St 9 Median : Yard Tree DPW 1     30     6004826.52958 2107279.95522 37.7664622347806 -122.426554344032 (37.7664622347806, -122.426554344032) 8 4 5 28862 3
15348 264739 Landmark tree 11 Phoenix canariensis :: Canary Island Date Palm 160 2040 Sutter St 1 Back Yard : Yard Tree Private 2           6002832.74822 2114456.05498 37.7860531044459 -122.433963466929 (37.7860531044459, -122.433963466929) 13 9 11 29490 27
15633 25139 DPW Maintained 1 Phoenix canariensis :: Canary Island Date Palm 160 1700X Dolores St 5 Median : Cutout Tree DPW 1     90 20   6005326.84877 2098252.91312 37.7417043484808 -122.424181770586 (37.7417043484808, -122.424181770586) 2 7 5 63 7
15958 251109 Landmark tree 11 Phoenix canariensis :: Canary Island Date Palm 160 1700X Quesada Ave 3 Median : Yard Tree DPW 1                              
15995 251116 Landmark tree 11 Phoenix canariensis :: Canary Island Date Palm 160 1700X Quesada Ave 20 Median : Yard Tree DPW 1                              
16115 194311 DPW Maintained 1 Phoenix canariensis :: Canary Island Date Palm 160 380x The Embarcadero 3 Median : Yard Tree DPW 1     21 Width 7ft   6015171.22981 2116694.38601 37.7928915254696 -122.391431824244 (37.7928915254696, -122.391431824244) 12 2 9 28855 6
16199 259409 DPW Maintained 1 Phoenix canariensis :: Canary Island Date Palm 160 201x The Embarcadero 6 Median : Cutout Tree Private 2       3x3   6013700 2118549 37.7979020921151 -122.396652459006 (37.7979020921151, -122.396652459006) 3 1 10 28860 6
16208 194334 DPW Maintained 1 Phoenix canariensis :: Canary Island Date Palm 160 88x King St 10 Median : Yard Tree DPW 1     30 Width 8ft   6015942.04821 2112270.67914 37.7807877820727 -122.388455820993 (37.7807877820727, -122.388455820993) 6 2 9 28856 20
16574 25108 DPW Maintained 1 Phoenix canariensis :: Canary Island Date Palm 160 1400 Dolores St 1 Median : Cutout Tree DPW 1     30 20   6005223.67149 2100130.84124 37.7468548845426 -122.424672082757 (37.7468548845426, -122.424672082757) 2 7 5 63 22
17161 28026 Permitted Site 7 Phoenix canariensis :: Canary Island Date Palm 160 100 The Embarcadero 6 Median : Cutout Tree Port 6   02/05/2001 12:00:00 AM 24 4X4   6014253.80701 2117776.67601 37.795812278914 -122.394682002417 (37.795812278914, -122.394682002417) 4 2 10 28860 6
17335 24980 DPW Maintained 1 Phoenix canariensis :: Canary Island Date Palm 160 292 Dolores St 7 Median : Cutout Tree DPW 1     90 20   6004817.9533669 2106647.0197828 37.7647238606763 -122.426538934247 (37.7647238606763, -122.426538934247) 8 4 5 28862 3
17465 246342 DPW Maintained 1 Phoenix canariensis :: Canary Island Date Palm 160 2020x Market St 4 Median : Cutout Tree DPW 1     30 Width 0ft   6004356.6072 2107872.2367 37.7680619198287 -122.428221935713 (37.7680619198287, -122.428221935713) 8 4 5 28862 3
18007 259314 DPW Maintained 1 Phoenix canariensis :: Canary Island Date Palm 160 201x The Embarcadero 2 Median : Cutout Tree Private 2       3x3   6013700 2118549 37.7979020921151 -122.396652459006 (37.7979020921151, -122.396652459006) 3 1 10 28860 6
18148 27929 Permitted Site 7 Phoenix canariensis :: Canary Island Date Palm 160 799 The Embarcadero 1 Median : Cutout Tree Port 6   02/01/2001 12:00:00 AM 24 10   6012635.1983488 2120084.4698961 37.8020588041016 -122.400444907677 (37.8020588041016, -122.400444907677) 3 1 10 28860 6
18521 25799 DPW Maintained 1 Phoenix canariensis :: Canary Island Date Palm 160 1300X The Embarcadero 1 Median : Cutout Tree Port 6   08/30/1996 12:00:00 AM 36 10   6012220.09673 2120843.1378 37.8041187644177 -122.401934728525 (37.8041187644177, -122.401934728525) 3 1 10 28860 6
18679 264760 DPW Maintained 1 Phoenix canariensis :: Canary Island Date Palm 160 1501 Sunnydale Ave 8 Sidewalk: Curb side : Cutout Tree DPW 1       3x3   6007165 2087428 37.7120850908031 -122.417059211527 (37.7120850908031, -122.417059211527) 9 7 8 309 39
18870 259407 DPW Maintained 1 Phoenix canariensis :: Canary Island Date Palm 160 201x The Embarcadero 4 Median : Cutout Tree Private 2       3x3   6013700 2118549 37.7979020921151 -122.396652459006 (37.7979020921151, -122.396652459006) 3 1 10 28860 6
18928 25136 DPW Maintained 1 Phoenix canariensis :: Canary Island Date Palm 160 1700X Dolores St 2 Median : Cutout Tree DPW 1     90 20   6005320.97591 2098341.7574 37.7419479631307 -122.424208394127 (37.7419479631307, -122.424208394127) 2 7 5 63 7
18950 25113 DPW Maintained 1 Phoenix canariensis :: Canary Island Date Palm 160 1400 Dolores St 6 Median : Cutout Tree DPW 1     30 20   6005228.94357 2100007.06865 37.7465153311328 -122.424645049125 (37.7465153311328, -122.424645049125) 2 7 5 63 22
19170 251114 Landmark tree 11 Phoenix canariensis :: Canary Island Date Palm 160 1700X Quesada Ave 16 Median : Yard Tree DPW 1                              
19478 251110 Landmark tree 11 Phoenix canariensis :: Canary Island Date Palm 160 1700X Quesada Ave 5 Median : Yard Tree DPW 1                              
19729 25157 DPW Maintained 1 Phoenix canariensis :: Canary Island Date Palm 160 2X Dolores St 5 Median : Cutout Tree DPW 1     90 20   6004782.44605 2108032.94108 37.7685272607631 -122.426760449752 (37.7685272607631, -122.426760449752) 8 4 5 28862 3
19829 23674 DPW Maintained 1 Phoenix canariensis :: Canary Island Date Palm 160 319 Virginia Ave 3 Median : Cutout Tree DPW 1     3 12   6006936.2458165 2098250.5638735 37.741788638282 -122.418616833275 (37.741788638282, -122.418616833275) 2 7 7 28859 2
19932 93074 Permitted Site 7 Phoenix canariensis :: Canary Island Date Palm 160 301 Executive Park Blvd 15 Sidewalk: Curb side : Cutout Tree Private 2   11/30/2007 12:00:00 AM   3x3 Permit Number 49938 6014761.5 2086930.3 37.7111429140183 -122.390768534473 (37.7111429140183, -122.390768534473) 10 3 8 58 1
19989 234338 DPW Maintained 1 Phoenix canariensis :: Canary Island Date Palm 160 420 Dolores St 19 Sidewalk: Property side : Yard Tree Private 2     37 Width 3ft   6004867.72819 2105514.52686 37.7616171183661 -122.426286140092 (37.7616171183661, -122.426286140092) 8 4 5 28862 3
20118 173670 DPW Maintained 1 Phoenix canariensis :: Canary Island Date Palm 160 251x Lathrop Ave 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6012236 2086860 37.7108094381203 -122.399492405366 (37.7108094381203, -122.399492405366) 10 3 8 309 1
20141 132092 DPW Maintained 1 Phoenix canariensis :: Canary Island Date Palm 160 1500x The Embarcadero 12 Median : Yard Tree DPW 1     20 Width 10ft   6011191.46105 2121714.36376 37.806453474602 -122.405555813649 (37.806453474602, -122.405555813649) 3 1 10 308 23
20323 210923 DPW Maintained 1 Phoenix canariensis :: Canary Island Date Palm 160 1540 Plymouth Ave 2 Sidewalk: Curb side : Yard Tree Private 2     41 Width 3ft   5995839.22139 2094293.33064 37.7302920326405 -122.456700326779 (37.7302920326405, -122.456700326779) 9 7 4 28861 40
20512 25787 Permitted Site 7 Phoenix canariensis :: Canary Island Date Palm 160 800X The Embarcadero 1 Median : Cutout Tree Port 6   08/30/1996 12:00:00 AM 36 10   6012271.38601 2120709.84401 37.8037556344242 -122.401747862284 (37.8037556344242, -122.401747862284) 3 1 10 28860 6
20670 24996 DPW Maintained 1 Phoenix canariensis :: Canary Island Date Palm 160 400X Dolores St 1 Median : Cutout Tree DPW 1     90 20   6004898.74738 2105973.30508 37.7628785677218 -122.42621152066 (37.7628785677218, -122.42621152066) 8 4 5 28859 3
20723 28232 DPW Maintained 1 Phoenix canariensis :: Canary Island Date Palm 160 399X King St 15 Sidewalk: Curb side : Cutout Tree DPW 1     12     6013667.5202917 2110028.9140531 37.7745060991794 -122.396167417116 (37.7745060991794, -122.396167417116) 14 2 9 310 20
20840 27943 Permitted Site 7 Phoenix canariensis :: Canary Island Date Palm 160 699 The Embarcadero 4 Median : Cutout Tree Port 6   02/01/2001 12:00:00 AM 24     6012787.5534626 2119857.700218 37.8014446443351 -122.399901749617 (37.8014446443351, -122.399901749617) 3 1 10 28860 6
20887 210907 DPW Maintained 1 Phoenix canariensis :: Canary Island Date Palm 160 1009 Kirkham St 1 Sidewalk: Curb side : Pot Tree Private 2     32 Width 3ft   5991740.69924 2105187.89339 37.7599695243799 -122.471662958305 (37.7599695243799, -122.471662958305) 1 8 4 56 12
20896 187504 DPW Maintained 1 Phoenix canariensis :: Canary Island Date Palm 160 100 Walbridge St 10 Front Yard : Yard Tree Private 2     9     6005101.69485 2086503.71935 37.7094309267755 -122.424124907354 (37.7094309267755, -122.424124907354) 9 7 6 309 5
21114 28183 DPW Maintained 1 Phoenix canariensis :: Canary Island Date Palm 160 299X King St 1 Sidewalk: Curb side : Cutout Tree DPW 1     12 6   6014324.7762427 2110655.258445 37.7762624487031 -122.393937678457 (37.7762624487031, -122.393937678457) 6 2 9 28856 20
21370 25043 DPW Maintained 1 Phoenix canariensis :: Canary Island Date Palm 160 892X Dolores St 8 Median : Cutout Tree DPW 1     90 20   6005007.5951373 2103153.9131268 37.7551433335372 -122.425634379859 (37.7551433335372, -122.425634379859) 2 4 5 28862 22
21377 210922 DPW Maintained 1 Phoenix canariensis :: Canary Island Date Palm 160 380 Kingston St 1 Sidewalk: Curb side : Yard Tree Private 2     39 Width 4ft   5994038.37723 2099205.21989 37.7436752972852 -122.463282329909 (37.7436752972852, -122.463282329909) 1 8 4 59 40
21737 233937 DPW Maintained 1 Phoenix canariensis :: Canary Island Date Palm 160 230x Dolores St 3 Median : Yard Tree DPW 1     32     6004843.94175 2106947.59382 37.7655506342911 -122.426470450778 (37.7655506342911, -122.426470450778) 8 4 5 28862 3
21739 25033 DPW Maintained 1 Phoenix canariensis :: Canary Island Date Palm 160 700X Dolores St 1 Median : Cutout Tree DPW 1     70 20   6004995.41159 2104224.22732 37.7580814768833 -122.425752691957 (37.7580814768833, -122.425752691957) 2 4 5 28862 3
21756 28219 DPW Maintained 1 Phoenix canariensis :: Canary Island Date Palm 160 399X King St 2 Sidewalk: Curb side : Cutout Tree DPW 1     12     6013667.5202917 2110028.9140531 37.7745060991794 -122.396167417116 (37.7745060991794, -122.396167417116) 14 2 9 310 20
21850 143058 DPW Maintained 1 Phoenix canariensis :: Canary Island Date Palm 160 426 GREENWICH ST 1 Sidewalk: Curb side : Cutout Tree Private 2     30 Width 0ft   6010776.1378 2120354.2833 37.8026957973236 -122.406897202115 (37.8026957973236, -122.406897202115) 3 1 10 308 23
22076 234356 DPW Maintained 1 Phoenix canariensis :: Canary Island Date Palm 160 650x Dolores St 3 Median : Yard Tree DPW 1     22     6004985.93046 2104422.99085 37.7586266989802 -122.425799629353 (37.7586266989802, -122.425799629353) 2 4 5 28862 3
22145 25523 DPW Maintained 1 Phoenix canariensis :: Canary Island Date Palm 160 2194X Market St 10 Median : Cutout Tree DPW 1   04/01/1993 12:00:00 AM 36 10   6003574.351798 2107172.9273566 37.7660974938136 -122.430877759148 (37.7660974938136, -122.430877759148) 7 4 5 28862 3
22376 194392 DPW Maintained 1 Phoenix canariensis :: Canary Island Date Palm 160 860x Jamestown Ave 5 Median : Cutout Tree DPW 1     17 Width 5ft   6014755.05221 2089115.57759 37.7171429037943 -122.390943451878 (37.7171429037943, -122.390943451878) 10 3 8 58 1
22504 96822 DPW Maintained 1 Phoenix canariensis :: Canary Island Date Palm 160 610X Dolores St 2 Median : Cutout Tree DPW 1     24 20x225   6004926.4 2104659.4 37.7592724584905 -122.426022342006 (37.7592724584905, -122.426022342006) 2 4 5 28862 3
22525 25795 Permitted Site 7 Phoenix canariensis :: Canary Island Date Palm 160 800X The Embarcadero 9 Median : Cutout Tree Port 6   08/30/1996 12:00:00 AM 36 10   6012764.87501 2119980.67701 37.8017810445969 -122.399988868692 (37.8017810445969, -122.399988868692) 3 1 10 28860 6
22545 28193 DPW Maintained 1 Phoenix canariensis :: Canary Island Date Palm 160 299X King St 11 Sidewalk: Curb side : Cutout Tree DPW 1     12 6   6014324.7762427 2110655.258445 37.7762624487031 -122.393937678457 (37.7762624487031, -122.393937678457) 6 2 9 28856 20
22781 26096 Permitted Site 7 Phoenix canariensis :: Canary Island Date Palm 160 499X The Embarcadero 4 Median : Cutout Tree Port 6   12/01/2000 12:00:00 AM 36 10   6013385.9217822 2119009.0450001 37.7991477810775 -122.397771551765 (37.7991477810775, -122.397771551765) 3 1 10 28860 6
23067 100537 DPW Maintained 1 Phoenix canariensis :: Canary Island Date Palm 160 2010X Market St 1 Median : Cutout Tree DPW 1     36 8   6004815.4 2108376.1 37.7694713555808 -122.426670904591 (37.7694713555808, -122.426670904591) 7 4 5 28862 3

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)
);