trees
1,977 rows where qSpecies_id = 41 sorted by SiteOrder descending
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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 36584 | 206862 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 700 Junipero Serra Blvd | 97 | : | Tree | Private 2 | 16 | Width 0ft | 5991236.44384 | 2092069.53712 | 37.7239206965711 | -122.472450540456 | (37.7239206965711, -122.472450540456) | 9 | 8 | 4 | 64 | 40 | |||
| 160577 | 184094 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 1600 Sunset Blvd | 97 | Sidewalk: Property side : Yard | Tree | Private 2 | 2 | Width 0ft | 5984942.4654 | 2104248.1437 | 37.7569935689127 | -122.495105115522 | (37.7569935689127, -122.495105115522) | 1 | 8 | 3 | 56 | 35 | |||
| 156872 | 184092 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 1600 Sunset Blvd | 95 | Sidewalk: Property side : Yard | Tree | Private 2 | 25 | Width 0ft | 5984922.9495 | 2104224.59 | 37.7569277544289 | -122.49517087102 | (37.7569277544289, -122.49517087102) | 1 | 8 | 3 | 56 | 35 | |||
| 172 | 176155 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 900X Brotherhood Way | 9 | Median : Cutout | Tree | DPW 1 | 25 | 10x10 | 5988860 | 2088745 | 37.7146545182747 | -122.480422197946 | (37.7146545182747, -122.480422197946) | 1 | 8 | 4 | 64 | 14 | |||
| 5408 | 261480 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 1000 Portola Dr | 9 | Median : Yard | Tree | DPW 1 | 10x10 | 5995664 | 2098286 | 37.741244865522 | -122.457594860017 | (37.741244865522, -122.457594860017) | 1 | 8 | 4 | 59 | 40 | ||||
| 5439 | 247017 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 500 Valley St | 9 | Sidewalk: Property side : Yard | Tree | Private 2 | 40 | 6002542.70295 | 2099187.51886 | 37.7441129631509 | -122.433875195085 | (37.7441129631509, -122.433875195085) | 2 | 7 | 5 | 63 | 22 | ||||
| 6786 | 262148 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 420X Portola Dr | 9 | Median : Yard | Tree | DPW 1 | Private | 3x3 | 5998701 | 2100185 | 37.7466330487878 | -122.44723067426 | (37.7466330487878, -122.44723067426) | 2 | 7 | 5 | 63 | 22 | |||
| 8004 | 176122 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 3500 Great Hwy | 9 | Median : | Tree | Private 2 | 3 | Width 0ft | 5982330.17471 | 2092783.08412 | 37.7253603924579 | -122.503290375351 | (37.7253603924579, -122.503290375351) | 1 | 8 | 4 | 64 | 14 | |||
| 13027 | 261955 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 1X Portola Dr To Clipper St Connetion | 9 | Sidewalk: Property side : Yard | Tree | DPW 1 | |||||||||||||||
| 17009 | 258662 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 10X Mendosa Ave | 9 | Median : Cutout | Tree | Private 2 | 3x3 | 5993533 | 2101170 | 37.749040957039 | -122.465172468022 | (37.749040957039, -122.465172468022) | 1 | 8 | 4 | 29491 | 40 | ||||
| 21639 | 190969 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 800 Vermont St | 9 | Sidewalk: Curb side : Yard | Tree | Private 2 | 14 | 6011271.58164 | 2104330.23228 | 37.7587252053147 | -122.404054347838 | (37.7587252053147, -122.404054347838) | 10 | 3 | 8 | 28856 | 29 | ||||
| 25906 | 206883 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 355 Parnassus Ave | 9 | Sidewalk: Property side : Yard | Tree | Private 2 | 23 | Width 5ft | 5996116.5996 | 2106463.98861 | 37.7637255564024 | -122.456621213396 | (37.7637255564024, -122.456621213396) | 15 | 5 | 4 | 29492 | 12 | |||
| 34988 | 20754 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 1692X Sunset Blvd | 9 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 60 | 5984807.4869191 | 2103677.7923597 | 37.7554196391607 | -122.495529849669 | (37.7554196391607, -122.495529849669) | 1 | 8 | 3 | 56 | 35 | |||
| 39498 | 206907 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 901 Monterey Blvd | 9 | Sidewalk: Curb side : Yard | Tree | Private 2 | 13 | Width 3ft | 5996091.97052 | 2094634.86515 | 37.7312443130779 | -122.455851223752 | (37.7312443130779, -122.455851223752) | 9 | 7 | 4 | 59 | 40 | |||
| 40416 | 206821 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 335x Pacheco St | 9 | Median : Yard | Tree | DPW 1 | 3 | Width 8ft | 5994174.99878 | 2101175.06788 | 37.7490918726007 | -122.462952815645 | (37.7490918726007, -122.462952815645) | 1 | 8 | 4 | 29491 | 40 | |||
| 42025 | 186935 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 2800 Sunset Blvd | 9 | Sidewalk: Property side : Yard | Tree | Private 2 | 27 | Width 0ft | 5985193.8921 | 2095957.5728 | 37.7342446267333 | -122.493624723479 | (37.7342446267333, -122.493624723479) | 1 | 8 | 3 | 29491 | 35 | |||
| 48447 | 176148 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 10 Lake Merced Blvd | 9 | : | Tree | Private 2 | 34 | Width 0ft | 5987583.49684 | 2090495.06547 | 37.7193854910228 | -122.484962576086 | (37.7193854910228, -122.484962576086) | 1 | 8 | 4 | 64 | 14 | |||
| 48678 | 186063 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 1901 Sunset Blvd | 9 | Sidewalk: Property side : Yard | Tree | Private 2 | 75 | Width 0ft | 5984824.1542 | 2102129.3734 | 37.7511690836835 | -122.495358020711 | (37.7511690836835, -122.495358020711) | 1 | 8 | 3 | 29491 | 35 | |||
| 51481 | 186198 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 1701 Sunset Blvd | 9 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 0ft | 5984809.4012 | 2103495.5605 | 37.7549193929952 | -122.495509789758 | (37.7549193929952, -122.495509789758) | 1 | 8 | 3 | 56 | 35 | |||
| 52013 | 190990 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 301x Cashmere St | 9 | Median : Yard | Tree | DPW 1 | 8 | 6016177.27303 | 2096204.98812 | 37.7366878401785 | -122.386521512362 | (37.7366878401785, -122.386521512362) | 10 | 3 | 8 | 58 | 1 | ||||
| 58297 | 20782 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 1701X Sunset Blvd | 9 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 42 | 60 | 5984888.092725 | 2103630.7874996 | 37.7552952964732 | -122.49524762816 | (37.7552952964732, -122.49524762816) | 1 | 8 | 3 | 56 | 35 | |||
| 62397 | 5048 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 5399X Diamond Heights Blvd | 9 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 26 | 6002000.04243 | 2098472.35983 | 37.7421184943815 | -122.435700436623 | (37.7421184943815, -122.435700436623) | 2 | 7 | 5 | 63 | 22 | ||||
| 65441 | 21519 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 2801X Sunset Blvd | 9 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 48 | 40 | 5985158.4919923 | 2096224.0649069 | 37.7349742721437 | -122.493766742569 | (37.7349742721437, -122.493766742569) | 1 | 8 | 3 | 29491 | 35 | |||
| 75890 | 251156 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 625 Brotherhood Way | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5991521 | 2087959 | 37.7126506341802 | -122.471167551627 | (37.7126506341802, -122.471167551627) | 9 | 8 | 4 | 64 | 24 | ||||
| 77466 | 181449 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 1400 Sunset Blvd | 9 | Sidewalk: Property side : Yard | Tree | Private 2 | 23 | Width 0ft | 5984873.9061 | 2105087.418 | 37.7592939688237 | -122.495404111594 | (37.7592939688237, -122.495404111594) | 1 | 8 | 3 | 56 | 35 | |||
| 80560 | 114268 | Undocumented 4 | Cupressus macrocarpa :: Monterey Cypress 41 | 800x BROTHERHOOD WAY | 9 | Front Yard : Yard | Tree | Private 2 | 30 | 5990271 | 2088582 | 37.7142888575797 | -122.475533361779 | (37.7142888575797, -122.475533361779) | 1 | 8 | 4 | 64 | 14 | ||||
| 93509 | 223728 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 5210 Diamond Heights Blvd | 9 | Sidewalk: Curb side : Yard | Tree | Private 2 | 39 | Width 3ft | 6001017.17414 | 2099295.49651 | 37.7443227561014 | -122.43915786136 | (37.7443227561014, -122.43915786136) | 2 | 7 | 5 | 63 | 7 | |||
| 96036 | 118630 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 349 Point Lobos Ave | 9 | Sidewalk: Property side : Yard | Tree | Private 2 | 16 | 5981637.79887 | 2112651.00381 | 37.7798713628306 | -122.507157052361 | (37.7798713628306, -122.507157052361) | 11 | 6 | 2 | 55 | 26 | ||||
| 96178 | 186633 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 1300 Lower Great Hwy | 9 | unknown : Yard | Tree | Private 2 | 3 | Width 0ft | 5980876.555 | 2105686.5399 | 37.760704119089 | -122.509273133786 | (37.760704119089, -122.509273133786) | 1 | 8 | 3 | 56 | 35 | |||
| 100621 | 20859 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 1892X Sunset Blvd | 9 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 42 | 60 | 5984852.8466778 | 2102317.5089788 | 37.7516873322231 | -122.49527267334 | (37.7516873322231, -122.49527267334) | 1 | 8 | 3 | 56 | 35 | |||
| 102237 | 8398 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 1500 Geary Blvd | 9 | Median : Cutout | Tree | DPW 1 | 18 | 8 | 6003997.2859 | 2113948.4347 | 37.7847253249416 | -122.429898258777 | (37.7847253249416, -122.429898258777) | 13 | 9 | 11 | 29490 | 41 | |||
| 104650 | 249923 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 358 Greenwich St | 9 | Back Yard : Yard | Tree | Private 2 | 33 | Width 0ft | 6011163.06331 | 2120405.05222 | 37.8028568393309 | -122.405561814838 | (37.8028568393309, -122.405561814838) | 3 | 1 | 10 | 308 | 23 | |||
| 123173 | 21309 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 2501X Sunset Blvd | 9 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 60 | 5985074.8907349 | 2098188.1189419 | 37.740362147215 | -122.494200494189 | (37.740362147215, -122.494200494189) | 1 | 8 | 3 | 29491 | 35 | |||
| 128842 | 253311 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 2 Euclid Ave | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5999085 | 2114289 | 37.7853810185166 | -122.446917590697 | (37.7853810185166, -122.446917590697) | 15 | 6 | 1 | 54 | 31 | |||||
| 132563 | 20531 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 1303X Sunset Blvd | 9 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 48 | 6O | 5984802.8376111 | 2106327.3646052 | 37.7626943540195 | -122.495741360313 | (37.7626943540195, -122.495741360313) | 1 | 8 | 3 | 56 | 35 | |||
| 133481 | 181531 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 1300 Sunset Blvd | 9 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | Width 0ft | 5984868.058 | 2105762.174 | 37.7611463180726 | -122.495474102719 | (37.7611463180726, -122.495474102719) | 1 | 8 | 3 | 56 | 35 | |||
| 136016 | 247031 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 550x Valley St | 9 | Median : Yard | Tree | DPW 1 | 26 | 6002334.80254 | 2099162.94393 | 37.7440336861084 | -122.434592310909 | (37.7440336861084, -122.434592310909) | 2 | 7 | 5 | 63 | 22 | ||||
| 136168 | 20513 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 1211X Sunset Blvd | 9 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 12 | 60 | 5984783.6901595 | 2107169.3790132 | 37.7650051676015 | -122.495869700491 | (37.7650051676015, -122.495869700491) | 11 | 6 | 2 | 55 | 8 | |||
| 136762 | 206895 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 1 Pizarro Way | 9 | Sidewalk: Curb side : Yard | Tree | Private 2 | 6 | Width 3ft | 5995113.71049 | 2093937.45787 | 37.7292732086872 | -122.459182739799 | (37.7292732086872, -122.459182739799) | 9 | 7 | 4 | 28861 | 40 | |||
| 139233 | 21206 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 2392X Sunset Blvd | 9 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 48 | 60 | 5984971.1169577 | 2098921.2732344 | 37.7423691180201 | -122.494613333405 | (37.7423691180201, -122.494613333405) | 1 | 8 | 3 | 29491 | 35 | |||
| 142043 | 97731 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 1150 Francisco St | 9 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 3 | 3x3 | Permit Number 50638 | 6005778.11415 | 2120709.05822 | 37.8033889834786 | -122.424218159845 | (37.8033889834786, -122.424218159845) | 5 | 9 | 1 | 28858 | 32 | |
| 142300 | 20722 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 1601X Sunset Blvd | 9 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 30 | 60 | 5984865.3499442 | 2104298.7792234 | 37.7571280850658 | -122.495375540207 | (37.7571280850658, -122.495375540207) | 1 | 8 | 3 | 56 | 35 | |||
| 144737 | 21168 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 2301 Sunset Blvd | 9 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 60 | 5985027.9083074 | 2099542.6271361 | 37.744078511576 | -122.494462762583 | (37.744078511576, -122.494462762583) | 1 | 8 | 3 | 29491 | 35 | |||
| 145269 | 187147 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 2301 Sunset Blvd | 9 | Sidewalk: Property side : Yard | Tree | Private 2 | 60 | Width 0ft | 5984894.352 | 2099426.4136 | 37.7437516033998 | -122.494915996625 | (37.7437516033998, -122.494915996625) | 1 | 8 | 3 | 29491 | 35 | |||
| 148242 | 223787 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 4004 20th St | 9 | : Yard | Tree | Private 2 | 44 | Width 3ft | 6003650.35726 | 2104229.2336 | 37.7580191233073 | -122.430404821951 | (37.7580191233073, -122.430404821951) | 2 | 4 | 5 | 28862 | 3 | |||
| 148290 | 185284 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 2601 Sunset Blvd | 9 | Sidewalk: Property side : Yard | Tree | Private 2 | 61 | Width 0ft | 5984980.0343 | 2097412.7236 | 37.738227568753 | -122.494471320256 | (37.738227568753, -122.494471320256) | 1 | 8 | 3 | 29491 | 35 | |||
| 150608 | 20932 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 1992X Sunset Blvd | 9 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 42 | 60 | 5984875.9454268 | 2101638.8759791 | 37.7498253446275 | -122.495142757654 | (37.7498253446275, -122.495142757654) | 1 | 8 | 3 | 29491 | 35 | |||
| 152100 | 12464 | Permitted Site 7 | Cupressus macrocarpa :: Monterey Cypress 41 | 307 Lake Merced Blvd | 9 | Sidewalk: Curb side : Cutout | Tree | PUC 8 | 6 | 90M | 5985224.7663097 | 2094165.6248747 | 37.7293262181041 | -122.49338600271 | (37.7293262181041, -122.49338600271) | 1 | 8 | 4 | 64 | 14 | |||
| 153305 | 206818 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 2187x 09th Ave | 9 | Median : Yard | Tree | DPW 1 | 28 | 5993615.24437 | 2100968.4802 | 37.7484923773392 | -122.464873435666 | (37.7484923773392, -122.464873435666) | 1 | 8 | 4 | 29491 | 40 | ||||
| 166325 | 173921 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 2160X 09th Ave | 9 | Median : Cutout | Tree | DPW 1 | 6x10 | 5993671 | 2100995 | 37.7485684085064 | -122.464682560698 | (37.7485684085064, -122.464682560698) | 1 | 8 | 4 | 29491 | 40 | ||||
| 174622 | 20998 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 2003X Sunset Blvd | 9 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 48 | 60 | 5984964.2584556 | 2101570.8346889 | 37.7496436917689 | -122.494832355741 | (37.7496436917689, -122.494832355741) | 1 | 8 | 3 | 29491 | 35 | |||
| 179968 | 21456 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 2701X Sunset Blvd | 9 | Median : Cutout | Tree | DPW 1 | 02/11/2016 05:16:00 AM | 3 | 40 | 5985119.0068215 | 2096832.7848434 | 37.7366433445438 | -122.493948101207 | (37.7366433445438, -122.493948101207) | 1 | 8 | 3 | 29491 | 35 | ||
| 180214 | 20488 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 1204 Sunset Blvd | 9 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 6 | 40 | 5984687.7602675 | 2107238.1673169 | 37.7651884221731 | -122.496206568741 | (37.7651884221731, -122.496206568741) | 11 | 6 | 2 | 55 | 8 | |||
| 186341 | 20831 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 1801X Sunset Blvd | 9 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 36 | 60 | 5984911.465596 | 2102939.293478 | 37.7533980132231 | -122.495115810531 | (37.7533980132231, -122.495115810531) | 1 | 8 | 3 | 56 | 35 | |||
| 186918 | 206812 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 66x Santa Monica Way | 9 | Median : Yard | Tree | DPW 1 | 15 | 5993679.09704 | 2097560.53952 | 37.739138713068 | -122.464405236026 | (37.739138713068, -122.464405236026) | 1 | 8 | 4 | 59 | 40 | ||||
| 7557 | 206861 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 700 Junipero Serra Blvd | 89 | : | Tree | Private 2 | 15 | Width 0ft | 5991235.10134 | 2092148.32282 | 37.7241369448505 | -122.47246092223 | (37.7241369448505, -122.47246092223) | 9 | 8 | 4 | 64 | 40 | |||
| 31374 | 184088 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 1600 Sunset Blvd | 89 | Sidewalk: Property side : Yard | Tree | Private 2 | 52 | Width 0ft | 5984924.9202 | 2104112.1254 | 37.756619073195 | -122.49515576259 | (37.756619073195, -122.49515576259) | 1 | 8 | 3 | 56 | 35 | |||
| 64641 | 185361 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 2601 Sunset Blvd | 86 | Sidewalk: Property side : Yard | Tree | Private 2 | 72 | Width 0ft | 5985015.9398 | 2096870.9998 | 37.7367422415889 | -122.494307259096 | (37.7367422415889, -122.494307259096) | 1 | 8 | 3 | 29491 | 35 | |||
| 68795 | 186615 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 1501 Sunset Blvd | 86 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | Width 0ft | 5984738.326 | 2104396.7218 | 37.7573895698596 | -122.495822055914 | (37.7573895698596, -122.495822055914) | 1 | 8 | 3 | 56 | 35 | |||
| 181658 | 185359 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 2601 Sunset Blvd | 84 | Sidewalk: Property side : Yard | Tree | Private 2 | 26 | Width 0ft | 5984996.2598 | 2096910.7786 | 37.7368503118256 | -122.49437823177 | (37.7368503118256, -122.49437823177) | 1 | 8 | 3 | 29491 | 35 | |||
| 102158 | 186839 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 1200 Sunset Blvd | 83 | Sidewalk: Property side : Yard | Tree | Private 2 | 2 | Width 0ft | 5984830.1212 | 2106502.1656 | 37.7631759062792 | -122.495659891561 | (37.7631759062792, -122.495659891561) | 1 | 8 | 3 | 56 | 35 | |||
| 156801 | 223714 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 1201 San Jose Ave | 82 | Front Yard : Yard | Tree | Private 2 | 34 | 6004606.42672 | 2096213.68372 | 37.7360643833694 | -122.426527580197 | (37.7360643833694, -122.426527580197) | 2 | 7 | 5 | 28861 | 2 | ||||
| 164693 | 223713 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 1201 San Jose Ave | 81 | Front Yard : Yard | Tree | Private 2 | 52 | 6004590.4575 | 2096203.60231 | 37.7360357993049 | -122.426582074619 | (37.7360357993049, -122.426582074619) | 2 | 7 | 5 | 28861 | 2 | ||||
| 41603 | 223706 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 1100 San Jose Ave | 80 | Front Yard : Yard | Tree | Private 2 | 4 | 6004536.52923 | 2096375.86849 | 37.7365057544425 | -122.4267807906 | (37.7365057544425, -122.4267807906) | 2 | 7 | 5 | 63 | 7 | ||||
| 595 | 261954 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 1X Portola Dr To Clipper St Connetion | 8 | Sidewalk: Property side : Yard | Tree | DPW 1 | |||||||||||||||
| 3098 | 20419 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 453X Sunset Blvd | 8 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 60 | |||||||||||||
| 4808 | 186197 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 1701 Sunset Blvd | 8 | Sidewalk: Property side : Yard | Tree | Private 2 | 66 | Width 0ft | 5984786.367 | 2103519.1304 | 37.7549827606067 | -122.495591185684 | (37.7549827606067, -122.495591185684) | 1 | 8 | 3 | 56 | 35 | |||
| 9730 | 190968 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 800 Vermont St | 8 | Sidewalk: Curb side : Yard | Tree | Private 2 | 39 | 6011276.3148 | 2104337.18505 | 37.7587445605265 | -122.404038467608 | (37.7587445605265, -122.404038467608) | 10 | 3 | 8 | 28856 | 29 | ||||
| 10395 | 260478 | Significant Tree 6 | Cupressus macrocarpa :: Monterey Cypress 41 | 3333 California St | 8 | Sidewalk: Property side : Cutout | Tree | DPW 1 | 3X3 | 5998571 | 2114839 | 37.7868617958727 | -122.448735497123 | (37.7868617958727, -122.448735497123) | 15 | 6 | 1 | 54 | 31 | ||||
| 16302 | 21167 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 2301 Sunset Blvd | 8 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 60 | 5985027.9083074 | 2099542.6271361 | 37.744078511576 | -122.494462762583 | (37.744078511576, -122.494462762583) | 1 | 8 | 3 | 29491 | 35 | |||
| 16465 | 19951 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 100 STAIRWAY39 | 8 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 25ST | |||||||||||||
| 17725 | 258661 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 10X Mendosa Ave | 8 | Median : Cutout | Tree | Private 2 | 3x3 | 5993533 | 2101170 | 37.749040957039 | -122.465172468022 | (37.749040957039, -122.465172468022) | 1 | 8 | 4 | 29491 | 40 | ||||
| 17791 | 186062 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 1901 Sunset Blvd | 8 | Sidewalk: Property side : Yard | Tree | Private 2 | 2 | Width 0ft | 5984799.1046 | 2102135.8379 | 37.7511853667035 | -122.495445120336 | (37.7511853667035, -122.495445120336) | 1 | 8 | 3 | 29491 | 35 | |||
| 22522 | 176121 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 3500 Great Hwy | 8 | Median : | Tree | Private 2 | 6 | Width 0ft | 5982310.61133 | 2092790.70938 | 37.7253801793381 | -122.503358567347 | (37.7253801793381, -122.503358567347) | 1 | 8 | 4 | 14 | ||||
| 23686 | 206884 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 355 Parnassus Ave | 8 | Sidewalk: Property side : Yard | Tree | Private 2 | 20 | Width 5ft | 5996099.70651 | 2106459.36925 | 37.7637119028988 | -122.456679306927 | (37.7637119028988, -122.456679306927) | 15 | 5 | 4 | 29492 | 12 | |||
| 26121 | 186013 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 1900 Sunset Blvd | 8 | Sidewalk: Property side : Yard | Tree | Private 2 | 60 | Width 0ft | 5985009.4701 | 2101751.3734 | 37.7501420480542 | -122.49468932302 | (37.7501420480542, -122.49468932302) | 1 | 8 | 3 | 29491 | 35 | |||
| 27900 | 251155 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 625 Brotherhood Way | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5991521 | 2087959 | 37.7126506341802 | -122.471167551627 | (37.7126506341802, -122.471167551627) | 9 | 8 | 4 | 64 | 24 | ||||
| 33268 | 5047 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 5399X Diamond Heights Blvd | 8 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 30 | 6002007.86459 | 2098449.21717 | 37.7420553943514 | -122.43567173476 | (37.7420553943514, -122.43567173476) | 2 | 7 | 5 | 63 | 22 | ||||
| 38325 | 185627 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 2100 Sunset Blvd | 8 | Sidewalk: Property side : Yard | Tree | Private 2 | 87 | Width 0ft | 5985046.4186 | 2100324.9202 | 37.7462275593372 | -122.494456414967 | (37.7462275593372, -122.494456414967) | 1 | 8 | 3 | 29491 | 35 | |||
| 42165 | 21027 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 2101X Sunset Blvd | 8 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 42 | 60 | 5984980.9284488 | 2100900.997098 | 37.7478054765444 | -122.494725332997 | (37.7478054765444, -122.494725332997) | 1 | 8 | 3 | 29491 | 35 | |||
| 45733 | 185949 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 2001 Sunset Blvd | 8 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 0ft | 5984874.0867 | 2101486.1152 | 37.7494057965484 | -122.495137921755 | (37.7494057965484, -122.495137921755) | 1 | 8 | 3 | 29491 | 35 | |||
| 50493 | 21384 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 2601X Sunset Blvd | 8 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 48 | 40 | 5985098.343425 | 2097506.3093477 | 37.7384914535226 | -122.494069167367 | (37.7384914535226, -122.494069167367) | 1 | 8 | 3 | 29491 | 35 | |||
| 61082 | 176147 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 10 Lake Merced Blvd | 8 | : | Tree | Private 2 | 40 | Width 0ft | 5987595.02111 | 2090461.30064 | 37.7192934526127 | -122.484920265678 | (37.7192934526127, -122.484920265678) | 1 | 8 | 4 | 64 | 14 | |||
| 65190 | 190989 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 301x Cashmere St | 8 | Median : Yard | Tree | DPW 1 | 17 | 6016178.92283 | 2096206.88071 | 37.7366931281786 | -122.386515940161 | (37.7366931281786, -122.386515940161) | 10 | 3 | 8 | 58 | 1 | ||||
| 68382 | 249924 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 358 Greenwich St | 8 | Back Yard : Yard | Tree | Private 2 | 12 | Width 0ft | 6011171.36702 | 2120411.09017 | 37.8028738823709 | -122.405533505089 | (37.8028738823709, -122.405533505089) | 3 | 1 | 10 | 308 | 23 | |||
| 72016 | 186632 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 1300 Lower Great Hwy | 8 | unknown : Yard | Tree | Private 2 | 5 | Width 0ft | 5980861.0966 | 2105687.2426 | 37.7607051370684 | -122.509326648666 | (37.7607051370684, -122.509326648666) | 1 | 8 | 3 | 56 | 35 | |||
| 72593 | 99125 | Undocumented 4 | Cupressus macrocarpa :: Monterey Cypress 41 | 302X Pacheco St | 8 | Median : Cutout | Tree | Private 2 | 3 | 5994341.5 | 2100725.2 | 37.7478662384021 | -122.46234443277 | (37.7478662384021, -122.46234443277) | 1 | 8 | 4 | 29491 | 40 | ||||
| 73264 | 217828 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 2400 Ocean Ave | 8 | Sidewalk: Property side : Yard | Tree | Private 2 | 41 | 5991744.92986 | 2094549.55043 | 37.7307596144611 | -122.470873372405 | (37.7307596144611, -122.470873372405) | 9 | 8 | 4 | 59 | 40 | ||||
| 77315 | 186420 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 1601 Sunset Blvd | 8 | Sidewalk: Property side : Yard | Tree | Private 2 | 49 | Width 0ft | 5984736.3371 | 2104166.319 | 37.7567568312994 | -122.495811938679 | (37.7567568312994, -122.495811938679) | 1 | 8 | 3 | 56 | 35 | |||
| 79957 | 12463 | Permitted Site 7 | Cupressus macrocarpa :: Monterey Cypress 41 | 307 Lake Merced Blvd | 8 | Sidewalk: Curb side : Cutout | Tree | PUC 8 | 6 | 90M | 5985224.7663097 | 2094165.6248747 | 37.7293262181041 | -122.49338600271 | (37.7293262181041, -122.49338600271) | 1 | 8 | 4 | 64 | 14 | |||
| 80114 | 223752 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 3944 22nd St | 8 | Front Yard : Yard | Tree | Private 2 | 16 | 6002172.64124 | 2102975.10056 | 37.7544917583143 | -122.435425673069 | (37.7544917583143, -122.435425673069) | 2 | 4 | 5 | 28862 | 22 | ||||
| 89420 | 21104 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 2201X Sunset Blvd | 8 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 42 | 60 | 5985004.6737667 | 2100227.1692458 | 37.7459567185928 | -122.494593556276 | (37.7459567185928, -122.494593556276) | 1 | 8 | 3 | 29491 | 35 | |||
| 91759 | 185458 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 2400 Sunset Blvd | 8 | unknown : Yard | Tree | Private 2 | 22 | Width 0ft | 5985125.7214 | 2098330.4524 | 37.7407559309555 | -122.494035231844 | (37.7407559309555, -122.494035231844) | 1 | 8 | 3 | 29491 | 35 | |||
| 92504 | 187146 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 2301 Sunset Blvd | 8 | Sidewalk: Property side : Yard | Tree | Private 2 | 24 | Width 0ft | 5984905.7598 | 2099438.5436 | 37.7437855768811 | -122.494877445934 | (37.7437855768811, -122.494877445934) | 1 | 8 | 3 | 29491 | 35 | |||
| 93591 | 253310 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 2 Euclid Ave | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5999085 | 2114289 | 37.7853810185166 | -122.446917590697 | (37.7853810185166, -122.446917590697) | 15 | 6 | 1 | 54 | 31 | |||||
| 94812 | 20693 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 1592X Sunset Blvd | 8 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 42 | 60 | 5984826.8631 | 2104357.0018991 | 37.7572856948155 | -122.49551293462 | (37.7572856948155, -122.49551293462) | 1 | 8 | 3 | 56 | 35 | |||
| 95002 | 109656 | Undocumented 4 | Cupressus macrocarpa :: Monterey Cypress 41 | 800X BROTHERHOOD WAY | 8 | Median : Cutout | Tree | DPW 1 | 02/27/2015 10:16:00 AM | 3 | 5990271.4 | 2088582.7 | 37.7142908027957 | -122.475532030318 | (37.7142908027957, -122.475532030318) | 1 | 8 | 4 | 64 | 14 | |||
| 104747 | 185080 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 2801 Sunset Blvd | 8 | Sidewalk: Property side : Yard | Tree | Private 2 | 2 | Width 0ft | 5985014.893 | 2096064.5379 | 37.7345278512133 | -122.494251453083 | (37.7345278512133, -122.494251453083) | 1 | 8 | 3 | 29491 | 35 | |||
| 115055 | 23597 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 200X Vasquez Ave | 8 | Median : Cutout | Tree | DPW 1 | 12 | 40 | 5994426.954874 | 2098963.765109 | 37.7430347013579 | -122.461921227095 | (37.7430347013579, -122.461921227095) | 1 | 8 | 4 | 59 | 40 | |||
| 115496 | 223694 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 1001 San Jose Ave | 8 | Front Yard : Yard | Tree | Private 2 | 65 | 6005104.45792 | 2096735.83838 | 37.7375262448502 | -122.424842819945 | (37.7375262448502, -122.424842819945) | 2 | 7 | 5 | 28859 | 2 |
Advanced export
JSON shape: default, array, newline-delimited, object
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) );