trees

438 rows where qSpecies_id = 63 sorted by Zip Codes

✎ View and edit SQL

This data as json, CSV (advanced)

Supervisor Districts ✖

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)
954 20324 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 101X Sunset Blvd 12 Sidewalk: Curb side : Cutout Tree DPW 1     12 60                      
2047 20346 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 101X Sunset Blvd 32 Sidewalk: Curb side : Cutout Tree DPW 1     18 40                      
3556 20340 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 101X Sunset Blvd 27 Sidewalk: Curb side : Cutout Tree DPW 1     48 40                      
5800 98837 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 1101X Portola Dr 9 Sidewalk: Property side : Yard Tree DPW 1                              
5956 98839 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 1101X Portola Dr 4 Sidewalk: Property side : Yard Tree DPW 1                              
7308 20330 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 101X Sunset Blvd 18 Sidewalk: Curb side : Cutout Tree DPW 1     24 60                      
7987 20066 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 100 STAIRWAY54 13 Sidewalk: Curb side : Cutout Tree DPW 1     6 15ST                      
8061 20397 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 262X Sunset Blvd 42 Sidewalk: Curb side : Cutout Tree DPW 1     42 60                      
8532 19778 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 100 STAIRWAY18 4 Sidewalk: Curb side : Cutout Tree DPW 1     18 50ST                      
9886 20336 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 101X Sunset Blvd 23 Sidewalk: Curb side : Cutout Tree DPW 1     36 60                      
10489 102839 Undocumented 4 Pinus pinea :: Italian Stone Pine 63 1101X Portola Dr 2 Sidewalk: Property side : Yard Tree DPW 1                              
10520 20335 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 101X Sunset Blvd 22 Sidewalk: Curb side : Cutout Tree DPW 1     24 60                      
12952 20300 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 50X Sunset Blvd 2 Sidewalk: Curb side : Cutout Tree DPW 1     18 60                      
13465 20460 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 495X Sunset Blvd 25 Sidewalk: Curb side : Cutout Tree DPW 1     36 60                      
14475 20345 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 101X Sunset Blvd 31 Sidewalk: Curb side : Cutout Tree DPW 1     42 40                      
16263 20326 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 101X Sunset Blvd 14 Sidewalk: Curb side : Cutout Tree DPW 1     36 60                      
25732 116996 Undocumented 4 Pinus pinea :: Italian Stone Pine 63 606x FULTON ST   Front Yard : Yard Tree Private 2   09/29/2016 12:00:00 AM 3     6004628 2111737 37.7786889706302 -122.427558590519 (37.7786889706302, -122.427558590519) 7 9 11 28852 41
8023 121696 Undocumented 4 Pinus pinea :: Italian Stone Pine 63 1300x De Haro St 2 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6012218 2102254 37.7530771598286 -122.400635326689 (37.7530771598286, -122.400635326689) 10 3 8 28856 29
10043 264733 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 1367 De Haro St   Median : Cutout Tree DPW 1       3x3   6012260 2102130 37.7527390251575 -122.400481372119 (37.7527390251575, -122.400481372119) 10 3 8 28856 29
12450 261565 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 1801 26th St 2 Sidewalk: Property side : Yard Tree DPW 1       3x3   6013146 2101521 37.7511162126671 -122.39737469907 (37.7511162126671, -122.39737469907) 10 3 8 28856 1
17195 194439 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 900x Carolina St 32 Median : Yard Tree DPW 1     12     6012481.17054 2103301.60211 37.7559683209947 -122.3997987802 (37.7559683209947, -122.3997987802) 10 3 8 28856 29
29047 194457 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 2001 25th St 32 Sidewalk: Property side : Yard Tree Private 2     30     6012708.71911 2101842.22219 37.7519738634013 -122.398909414543 (37.7519738634013, -122.398909414543) 10 3 8 28856 29
34697 194442 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 900x Carolina St 51 Median : Yard Tree DPW 1     24     6012500.2858 2102979.92319 37.7550861265451 -122.399710087265 (37.7550861265451, -122.399710087265) 10 3 8 28856 29
37115 194449 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 1300x De Haro St 23 Median : Yard Tree DPW 1     23     6012259.688 2102130.23115 37.7527396424455 -122.400482467314 (37.7527396424455, -122.400482467314) 10 3 8 28856 29
37367 194451 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 930 Kansas St 1 Front Yard : Yard Tree Private 2     29     6011573.12502 2104017.28324 37.7578827599862 -122.402989455212 (37.7578827599862, -122.402989455212) 10 3 8 28856 29
40232 194448 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 1300x De Haro St 32 Median : Yard Tree DPW 1     27     6012284.461 2102001.80848 37.7523884032163 -122.400387777686 (37.7523884032163, -122.400387777686) 10 3 8 28856 29
43289 194453 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 2250 26th St 1 Sidewalk: Curb side : Yard Tree Private 2     9     6011877.75436 2101392.1938 37.750691845665 -122.401751398122 (37.750691845665, -122.401751398122) 10 3 8 28856 29
65583 194443 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 1900 23rd St 2 Front Yard : Yard Tree Private 2     28     6012732.21441 2102858.09004 37.7547645253758 -122.398899455441 (37.7547645253758, -122.398899455441) 10 3 8 28856 29
66190 194458 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 2001 25th St 33 Sidewalk: Property side : Yard Tree Private 2     26     6012757.94703 2101850.0059 37.7519979787223 -122.398739722368 (37.7519979787223, -122.398739722368) 10 3 8 28856 29
78908 194452 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 2001 20th St 1 Sidewalk: Property side : Yard Tree Private 2     11 Width 3ft   6011998.43391 2104639.55141 37.7596151114626 -122.401562284167 (37.7596151114626, -122.401562284167) 10 3 8 28856 29
79719 194464 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 2000 25th St 6 Sidewalk: Curb side : Yard Tree Private 2     16     6012478.49596 2101876.43729 37.7520549795584 -122.399707966672 (37.7520549795584, -122.399707966672) 10 3 8 28856 29
81035 194456 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 1501 22nd St 12 Front Yard : Yard Tree Private 2     2     6013384.43791 2103815.09856 37.7574285843868 -122.396710957944 (37.7574285843868, -122.396710957944) 10 3 8 28856 29
95523 194440 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 900x Carolina St 33 Median : Yard Tree DPW 1     6     6012485.2688 2103286.14111 37.7559260969364 -122.399783521388 (37.7559260969364, -122.399783521388) 10 3 8 28856 29
100087 194438 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 1051 18th St 1 Side Yard : Yard Tree Private 2     11     6014405.25344 2105708.40792 37.7626839643245 -122.39331303148 (37.7626839643245, -122.39331303148) 10 3 8 28856 29
105080 173727 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 958 Carolina St 1 Sidewalk: Curb side : Cutout Tree DPW 1     9 3x3   6012430 2103470 37.7564278519739 -122.399987571177 (37.7564278519739, -122.399987571177) 10 3 8 28856 29
109147 194450 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 1300x De Haro St 21 Median : Yard Tree DPW 1     27     6012266.91736 2102141.9772 37.7527722977062 -122.40045829173 (37.7527722977062, -122.40045829173) 10 3 8 28856 29
120848 194447 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 680 De Haro St 4 Sidewalk: Property side : Yard Tree Private 2     1     6012074.20817 2105270.47212 37.761351707727 -122.401344555627 (37.761351707727, -122.401344555627) 10 3 8 28856 29
126912 194445 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 1501 25th St 15 Sidewalk: Curb side : Yard Tree Private 2     11     6014148.42594 2101954.90209 37.7523633759809 -122.393938549541 (37.7523633759809, -122.393938549541) 10 3 8 28856 1
128353 194455 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 1501 22nd St 11 Front Yard : Yard Tree Private 2     8     6013406.26386 2103790.51305 37.757362292666 -122.396633751156 (37.757362292666, -122.396633751156) 10 3 8 28856 29
131381 194466 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 2000 25th St 8 Sidewalk: Curb side : Yard Tree Private 2     25     6012435.9357 2101881.1338 37.7520655025415 -122.399855477046 (37.7520655025415, -122.399855477046) 10 3 8 28856 29
132354 194460 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 2000 25th St 1 Sidewalk: Curb side : Yard Tree Private 2     24     6012680.82829 2101890.2153 37.7521040879384 -122.399009233909 (37.7521040879384, -122.399009233909) 10 3 8 28856 29
133127 194437 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 1021 Minnesota St 1 Sidewalk: Curb side : Yard Tree Private 2     7 Width 4ft   6015301.57899 2103740.56291 37.7573304413508 -122.390075457711 (37.7573304413508, -122.390075457711) 10 3 8 28856 29
133881 194454 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 1301 Rhode Island St 7 Sidewalk: Property side : Yard Tree Private 2     8 Width 6ft   6012013.85217 2102295.56099 37.753179889343 -122.40134423455 (37.753179889343, -122.40134423455) 10 3 8 28856 29
140344 194446 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 1501 25th St 16 Sidewalk: Curb side : Yard Tree Private 2     18     6014162.91853 2101954.38506 37.7523627617528 -122.393888395238 (37.7523627617528, -122.393888395238) 10 3 8 28856 1
140522 121695 Undocumented 4 Pinus pinea :: Italian Stone Pine 63 1300x De Haro St 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6012218 2102254 37.7530771598286 -122.400635326689 (37.7530771598286, -122.400635326689) 10 3 8 28856 29
148743 194465 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 2000 25th St 7 Sidewalk: Curb side : Yard Tree Private 2     23     6012451.33342 2101881.30035 37.7520668182527 -122.399802240798 (37.7520668182527, -122.399802240798) 10 3 8 28856 29
161957 194462 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 2000 25th St 4 Sidewalk: Curb side : Yard Tree Private 2     25     6012536.20636 2101883.40971 37.7520773412124 -122.399508883748 (37.7520773412124, -122.399508883748) 10 3 8 28856 29
163675 194461 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 2000 25th St 3 Sidewalk: Curb side : Yard Tree Private 2     27     6012563.25713 2101880.94422 37.7520720792617 -122.399415164477 (37.7520720792617, -122.399415164477) 10 3 8 28856 29
166032 194459 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 2001 25th St 34 Sidewalk: Property side : Yard Tree Private 2     24     6012781.55557 2101851.76257 37.7520041175184 -122.398658203327 (37.7520041175184, -122.398658203327) 10 3 8 28856 29
170052 194441 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 900x Carolina St 39 Median : Yard Tree DPW 1     18     6012501.46554 2103105.94469 37.7554322198433 -122.399714855461 (37.7554322198433, -122.399714855461) 10 3 8 28856 29
170429 253558 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 1240 Wisconsin St 1 Front Yard : Yard Tree Private 2           6012830 2101639 37.7514226163546 -122.398475746389 (37.7514226163546, -122.398475746389) 10 3 8 28856 29
172636 194463 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 2000 25th St 5 Sidewalk: Curb side : Yard Tree Private 2     18     6012509.33056 2101878.68569 37.7520628720051 -122.399601493222 (37.7520628720051, -122.399601493222) 10 3 8 28856 29
179258 121697 Undocumented 4 Pinus pinea :: Italian Stone Pine 63 1300x De Haro St 3 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6012218 2102254 37.7530771598286 -122.400635326689 (37.7530771598286, -122.400635326689) 10 3 8 28856 29
185304 194444 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 1501 25th St 14 Sidewalk: Curb side : Yard Tree Private 2     14     6014137.98688 2101954.90704 37.7523628094083 -122.393974650128 (37.7523628094083, -122.393974650128) 10 3 8 28856 1
17203 107449 Undocumented 4 Pinus pinea :: Italian Stone Pine 63 1130x CHESTNUT ST 1 Unaccepted Street : Yard Tree Private 2     60     6006351.9 2120450.9 37.8027125282147 -122.422214196597 (37.8027125282147, -122.422214196597) 5 9 1 28858 32
17691 107448 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 1111x Chestnut St 8 Unaccepted Street : Yard Tree Private 2     50     6006408.68895 2120404.86262 37.8025893243113 -122.422014405358 (37.8025893243113, -122.422014405358) 5 9 1 28858 32
19898 98265 Property Tree 8 Pinus pinea :: Italian Stone Pine 63 755 O'Farrell St   Back Yard : Yard Tree Private 2         Backyard tree; not significant 6007700 2113968.3 37.7849888609023 -122.417089467607 (37.7849888609023, -122.417089467607) 7 10 9 28858 36
22744 132175 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 1100 Chestnut St 3 Front Yard : Yard Tree Private 2     49     6006452.3729 2120433.08861 37.8026692893229 -122.421865242911 (37.8026692893229, -122.421865242911) 5 9 1 28858 32
71037 132174 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 1111 Chestnut St 1 Front Yard : Yard Tree Private 2     52     6006441.86345 2120416.15353 37.8026221972261 -122.42190040729 (37.8026221972261, -122.42190040729) 5 9 1 28858 32
103192 132176 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 2745 Larkin St 2 Sidewalk: Property side : Yard Tree Private 2     14     6006527.83964 2120663.1294 37.8033051783476 -122.421620437537 (37.8033051783476, -122.421620437537) 5 9 1 28858 32
103781 108605 Undocumented 4 Pinus pinea :: Italian Stone Pine 63 1140x CHESTNUT ST 2 Unaccepted Street : Yard Tree Private 2           6006369.1 2120452.7 37.8027184407042 -122.422154803739 (37.8027184407042, -122.422154803739) 5 9 1 28858 32
115540 23580 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 3100X Van Ness Ave 3 Median : Cutout Tree DPW 1     24 9   6005507.77084 2121129.71298 37.8045287248816 -122.425183644115 (37.8045287248816, -122.425183644115) 5 1 1 28858 32
117514 132181 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 1302 Columbus Ave 4 Sidewalk: Property side : Yard Tree Private 2     21     6007227.55341 2121889.28804 37.8067113282286 -122.419286081687 (37.8067113282286, -122.419286081687) 5 1 1 28858 32
142225 23579 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 3100X Van Ness Ave 2 Median : Cutout Tree DPW 1     42 3x3   6005511.92719 2121098.11811 37.8044422083102 -122.425167011149 (37.8044422083102, -122.425167011149) 5 1 1 28858 32
146172 132180 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 1302 Columbus Ave 3 Sidewalk: Property side : Yard Tree Private 2     26     6007242.78631 2121872.67886 37.8066665815484 -122.419232186229 (37.8066665815484, -122.419232186229) 5 1 1 28858 32
185949 107450 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 1140x Chestnut St 1 Unaccepted Street : Yard Tree Private 2     60     6006380.05181 2120425.48408 37.8026443304364 -122.422114970234 (37.8026443304364, -122.422114970234) 5 9 1 28858 32
187217 132182 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 601 Beach St 1 Sidewalk: Property side : Yard Tree Private 2     24 Width 5ft   6007241.65576 2121894.78138 37.8067272057567 -122.419237667598 (37.8067272057567, -122.419237667598) 5 1 1 28858 32
193997 132179 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 1302 Columbus Ave 2 Sidewalk: Property side : Yard Tree Private 2     33     6007259.69894 2121860.76679 37.8066348265036 -122.419172811197 (37.8066348265036, -122.419172811197) 5 1 1 28858 32
2154 234510 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 1101 San Jose Ave 20 Front Yard : Yard Tree Private 2     15     6004874.94559 2096454.63294 37.7367411519672 -122.425616344829 (37.7367411519672, -122.425616344829) 2 7 5 28859 2
5675 261201 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 699x Benton Ave 2 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6007339 2095419 37.7340364554683 -122.417023656077 (37.7340364554683, -122.417023656077) 2 7 7 28859 2
6140 243478 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 1499X Eugenia Ave 4 Sidewalk: Curb side : Cutout Tree Private 2     0 3x3   6008755.36846 2097659.39973 37.7402676797185 -122.412285110476 (37.7402676797185, -122.412285110476) 10 7 7 28859 2
18973 233322 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 51 Prentiss St 2 Sidewalk: Curb side : Cutout Tree Private 2     13 Width 3ft   6008884.18383 2098343.89419 37.7421543791283 -122.411888074199 (37.7421543791283, -122.411888074199) 10 7 7 28859 2
22573 105838 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 39X Bonview St 1 Front Yard : Yard Tree DPW 1     15     6007716.90579 2099172.41141 37.7443637468546 -122.415982827151 (37.7443637468546, -122.415982827151) 2 7 7 28859 2
29057 116956 Significant Tree 6 Pinus pinea :: Italian Stone Pine 63 380 SAN JOSE AVE 1 Front Yard : Cutout Tree Private 2     28 3x3   6006172 2100967 37.7492042995658 -122.421452219126 (37.7492042995658, -122.421452219126) 2 4 5 28859 19
32405 246702 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 1 Bonview St 8 Sidewalk: Curb side : Yard Tree Private 2     15     6007696.68665 2099102.86041 37.7441716385189 -122.416047816374 (37.7441716385189, -122.416047816374) 2 7 7 28859 2
43298 23673 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 319 Virginia Ave 2 Median : Cutout Tree DPW 1     12 12   6006936.2458165 2098250.5638735 37.741788638282 -122.418616833275 (37.741788638282, -122.418616833275) 2 7 7 28859 2
58718 234516 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 90x Peralta Ave 2 Median : Yard Tree DPW 1     15 Width 10ft   6010366.95066 2100295.32111 37.7475956480377 -122.406898611185 (37.7475956480377, -122.406898611185) 2 7 7 28859 2
61382 234515 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 2 Peralta Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     19 Width 3ft   6010924.44859 2100544.92665 37.7483121900522 -122.404988378323 (37.7483121900522, -122.404988378323) 2 7 7 28859 2
66441 109838 Significant Tree 6 Pinus pinea :: Italian Stone Pine 63 200x MONTCALM ST 1 Sidewalk: Curb side : Cutout Tree Private 2     30 3x3   6009924 2099647 37.7457907048197 -122.408384592716 (37.7457907048197, -122.408384592716) 2 7 7 28859 2
73422 234509 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 1101 San Jose Ave 9 Front Yard : Yard Tree Private 2     25     6004750.38207 2096347.45133 37.7364398161369 -122.426039387727 (37.7364398161369, -122.426039387727) 2 7 5 28859 2
103851 247910 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 399 Franconia St 1 Side Yard : Yard Tree Private 2     11     6009965.37797 2098759.56576 37.7433563212371 -122.408178935533 (37.7433563212371, -122.408178935533) 2 7 7 28859 2
104488 234502 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 3502 24th St 1 Front Yard : Yard Tree Private 2     27     6006115.28896 2102029.42996 37.7521182909488 -122.421723779538 (37.7521182909488, -122.421723779538) 2 4 5 28859 19
108195 247896 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 351 Mayflower St 1 Sidewalk: Property side : Yard Tree Private 2     29 Width 5ft   6010145.43386 2098385.46575 37.7423392041921 -122.407529975731 (37.7423392041921, -122.407529975731) 10 7 7 28859 2
128520 246698 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 1 Bonview St 4 Sidewalk: Curb side : Yard Tree Private 2     1     6007671.81678 2099058.43431 37.7440482560225 -122.416130665494 (37.7440482560225, -122.416130665494) 2 7 7 28859 2
139657 256152 Undocumented 4 Pinus pinea :: Italian Stone Pine 63 80X Peralta Ave 1 Median : Cutout Tree Private 2       3x3   6010428 2100359 37.747773912222 -122.406691992098 (37.747773912222, -122.406691992098) 2 7 7 28859 2
145433 234514 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 998 York St 10 Sidewalk: Curb side : Yard Tree Private 2     1 Width 7ft   6009944.54234 2103430.26244 37.7561798559202 -122.408580392894 (37.7561798559202, -122.408580392894) 2 4 7 28859 19
156992 253621 Significant Tree 6 Pinus pinea :: Italian Stone Pine 63 200x Montcalm St 1 Back Yard : Yard Tree Private 2       3x3   6010036 2099760 37.7461072494139 -122.408005278478 (37.7461072494139, -122.408005278478) 2 7 7 28859 2
176495 234508 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 201 Coso Ave 2 Side Yard : Yard Tree Private 2     28 Width 5ft   6007691.39954 2099521.32268 37.745320345265 -122.416095727735 (37.745320345265, -122.416095727735) 2 7 7 28859 2
186214 234513 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 998 York St 4 Sidewalk: Curb side : Yard Tree Private 2     5 Width 7ft   6009942.57021 2103461.5506 37.7562656557487 -122.408589420289 (37.7562656557487, -122.408589420289) 2 4 7 28859 19
191676 247975 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 503 Peralta Ave 1 Side Yard : Yard Tree Private 2     21     6009813.28917 2099236.81382 37.744658223 -122.408738483811 (37.744658223, -122.408738483811) 2 7 7 28859 2
133 211075 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 650x Miramar Ave 6 Median : Yard Tree DPW 1     34     5995390.83549 2093912.64173 37.7292209976493 -122.458222905073 (37.7292209976493, -122.458222905073) 9 7 4 28861 40
10229 264894 Significant Tree 6 Pinus pinea :: Italian Stone Pine 63 56 Keystone Way 1 Back Yard : Yard Tree Private 2       3x3   5994156 2093086 37.7268802074189 -122.462431871086 (37.7268802074189, -122.462431871086) 9 8 4 28861 40
12567 211070 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 500x Miramar Ave 7 Median : Yard Tree DPW 1     24     5995378.92982 2093188.43217 37.7272318087773 -122.458211668947 (37.7272318087773, -122.458211668947) 9 7 4 28861 40
23455 97490 Undocumented 4 Pinus pinea :: Italian Stone Pine 63 500X Miramar Ave 7 Median : Cutout Tree Private 2     12 15x280   5995423.2 2092691.6 37.7258701708071 -122.458022688068 (37.7258701708071, -122.458022688068) 9 7 4 28861 40
28620 211073 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 602x Miramar Ave 5 Median : Yard Tree DPW 1     26     5995385.83715 2093544.41078 37.7282096371561 -122.458213544022 (37.7282096371561, -122.458213544022) 9 7 4 28861 40
30931 211072 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 602x Miramar Ave 2 Median : Yard Tree DPW 1     35     5995382.34021 2093429.07469 37.7278927511259 -122.458217288807 (37.7278927511259, -122.458217288807) 9 7 4 28861 40
33425 99460 Undocumented 4 Pinus pinea :: Italian Stone Pine 63 550X Miramar Ave 7 Median : Cutout Tree Private 2     30 15x280   5995413 2092983.7 37.7266716211667 -122.458079078858 (37.7266716211667, -122.458079078858) 9 7 4 28861 40
35868 24283 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 300X Winding Way 21 Median : Cutout Tree DPW 1     6 8   6001646.2933309 2086550.8578367 37.7093646550959 -122.436070699117 (37.7093646550959, -122.436070699117) 9 7 6 28861 5
36279 99451 Undocumented 4 Pinus pinea :: Italian Stone Pine 63 400X Miramar Ave 1 Median : Cutout Tree Private 2     30 15x280   5995388.7 2092398.7 37.7250639553871 -122.458120762721 (37.7250639553871, -122.458120762721) 9 7 4 28861 40
49979 99473 Undocumented 4 Pinus pinea :: Italian Stone Pine 63 600X Miramar Ave 2 Median : Cutout Tree Private 2     30 15x280   5995435.2 2093399 37.7278132105567 -122.458032376835 (37.7278132105567, -122.458032376835) 9 7 4 28861 40

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