trees
1,977 rows where qSpecies_id = 41 sorted by Zip Codes 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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 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 | |||
| 945 | 217846 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 1 Woodacre Dr | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 54 | 5991427.31798 | 2095733.50913 | 37.7339920935414 | -122.472057659936 | (37.7339920935414, -122.472057659936) | 1 | 8 | 4 | 64 | 40 | ||||
| 2239 | 253844 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 150 Junipero Serra Blvd | 1 | Median : Cutout | Tree | Private 2 | 3x3 | 5991384 | 2095197 | 37.7325164679088 | -122.472168327848 | (37.7325164679088, -122.472168327848) | 1 | 8 | 4 | 64 | 40 | ||||
| 2282 | 19424 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 1000X Sloat Blvd | 1 | Median : Cutout | Tree | DPW 1 | 24 | 20 | 5988569.2838063 | 2095968.4634055 | 37.7344714144349 | -122.481955851921 | (37.7344714144349, -122.481955851921) | 1 | 8 | 3 | 64 | 35 | |||
| 3666 | 113065 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 2X Cranleigh Dr | 6 | Front Yard : Yard | Tree | DPW 1 | 08/18/2016 09:51:00 AM | 3 | 5991370.3 | 2095943.7 | 37.7345659248964 | -122.472270103664 | (37.7345659248964, -122.472270103664) | 1 | 8 | 4 | 64 | 40 | |||
| 4254 | 254282 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 80X Junipero Serra Blvd | 6 | Median : Yard | Tree | Private 2 | 3x3 | 5991405 | 2095520 | 37.733404559811 | -122.472119261767 | (37.733404559811, -122.472119261767) | 1 | 8 | 4 | 64 | 40 | ||||
| 4543 | 206871 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 700 Junipero Serra Blvd | 167 | : | Tree | Private 2 | 28 | Width 0ft | 5991178.39011 | 2091334.01969 | 37.7218977876304 | -122.472597620991 | (37.7218977876304, -122.472597620991) | 9 | 8 | 4 | 64 | 40 | |||
| 5522 | 185128 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 1200x Sloat Blvd | 5 | Median : Cutout | Tree | DPW 1 | 12 | Width 0ft | 5987683.0779 | 2095922.3154 | 37.7342931239465 | -122.48501633511 | (37.7342931239465, -122.48501633511) | 1 | 8 | 4 | 64 | 35 | |||
| 6226 | 261544 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 800X Sloat Blvd | 1 | Median : Cutout | Tree | Private 2 | 10x10 | 5989247 | 2095899 | 37.7343200773404 | -122.47960770916 | (37.7343200773404, -122.47960770916) | 1 | 8 | 4 | 64 | 35 | ||||
| 6439 | 185119 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 1200x Sloat Blvd | 6 | Median : Cutout | Tree | DPW 1 | 25 | Width 0ft | 5987585.1902 | 2095924.1623 | 37.7342924927912 | -122.485354895586 | (37.7342924927912, -122.485354895586) | 1 | 8 | 4 | 64 | 35 | |||
| 6706 | 255369 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 800X Brotherhood Way | 4 | Median : Cutout | Tree | DPW 1 | 14x10 | 5990271 | 2088582 | 37.7142888575797 | -122.475533361779 | (37.7142888575797, -122.475533361779) | 1 | 8 | 4 | 64 | 14 | ||||
| 7283 | 176114 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 10 Zoo Rd | 1 | Front Yard : Yard | Tree | Private 2 | 24 | Width 10ft | 5982696.49512 | 2094384.4536 | 37.7297788507039 | -122.502142508582 | (37.7297788507039, -122.502142508582) | 1 | 8 | 4 | 64 | 14 | |||
| 7536 | 262249 | Undocumented 4 | Cupressus macrocarpa :: Monterey Cypress 41 | 4210 Ocean Ave | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 3x3 | 5986512 | 2095174 | 37.7321701636719 | -122.489010079787 | (37.7321701636719, -122.489010079787) | 1 | 8 | 4 | 64 | 35 | ||||
| 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 | |||
| 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 | |||
| 8394 | 206864 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 700 Junipero Serra Blvd | 108 | : | Tree | Private 2 | 16 | Width 0ft | 5991230.74264 | 2091941.55129 | 37.7235689492395 | -122.472460922234 | (37.7235689492395, -122.472460922234) | 9 | 8 | 4 | 64 | 40 | |||
| 8932 | 254133 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 100X Lake Merced Blvd | 7 | Median : Yard | Tree | DPW 1 | 10x10 | 5983894 | 2095251 | 37.7322284370415 | -122.498066633405 | (37.7322284370415, -122.498066633405) | 1 | 8 | 4 | 64 | 35 | ||||
| 9303 | 259269 | Significant Tree 6 | Cupressus macrocarpa :: Monterey Cypress 41 | 3580X 19th Ave | 7 | Sidewalk: Property side : Yard | Tree | Private 2 | 3x3 | 5990529 | 2092111 | 37.723993571379 | -122.474899060099 | (37.723993571379, -122.474899060099) | 9 | 8 | 4 | 64 | 14 | ||||
| 9662 | 113066 | - 12 | Cupressus macrocarpa :: Monterey Cypress 41 | 2X Cranleigh Dr | 7 | : | Tree | DPW 1 | 09/09/2015 01:08:00 PM | 3 | 5991370.3 | 2095943.7 | 37.7345659248964 | -122.472270103664 | (37.7345659248964, -122.472270103664) | 1 | 8 | 4 | 64 | 40 | |||
| 10140 | 106278 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 200X VIDAL DR | 2 | Median : Cutout | Tree | DPW 1 | 60 | 5987624 | 2090693 | 37.7199313280832 | -122.484837086298 | (37.7199313280832, -122.484837086298) | 1 | 8 | 4 | 64 | 14 | ||||
| 10387 | 261604 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 1300X Sloat Blvd | 5 | Median : Yard | Tree | Private 2 | 3x3 | 5987403 | 2095938 | 37.7343198717706 | -122.485985793061 | (37.7343198717706, -122.485985793061) | 1 | 8 | 3 | 64 | 35 | ||||
| 10397 | 261602 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 800X Sloat Blvd | 2 | Median : Cutout | Tree | Private 2 | 10x10 | 5989247 | 2095899 | 37.7343200773404 | -122.47960770916 | (37.7343200773404, -122.47960770916) | 1 | 8 | 4 | 64 | 35 | ||||
| 11254 | 259267 | Significant Tree 6 | Cupressus macrocarpa :: Monterey Cypress 41 | 3580X 19th Ave | 5 | Sidewalk: Property side : Yard | Tree | Private 2 | 3x3 | 5990529 | 2092111 | 37.723993571379 | -122.474899060099 | (37.723993571379, -122.474899060099) | 9 | 8 | 4 | 64 | 14 | ||||
| 11583 | 261603 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 1300X Sloat Blvd | 4 | Median : Yard | Tree | Private 2 | 3x3 | 5987403 | 2095938 | 37.7343198717706 | -122.485985793061 | (37.7343198717706, -122.485985793061) | 1 | 8 | 3 | 64 | 35 | ||||
| 11790 | 254293 | Undocumented 4 | Cupressus macrocarpa :: Monterey Cypress 41 | 110 Junipero Serra Blvd | 5 | Median : Yard | Tree | Private 2 | 3x3 | 5991396 | 2095383 | 37.7330278715114 | -122.472140394325 | (37.7330278715114, -122.472140394325) | 1 | 8 | 4 | 64 | 40 | ||||
| 11929 | 253845 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 150 Junipero Serra Blvd | 2 | Median : Cutout | Tree | Private 2 | 3x3 | 5991384 | 2095197 | 37.7325164679088 | -122.472168327848 | (37.7325164679088, -122.472168327848) | 1 | 8 | 4 | 64 | 40 | ||||
| 12885 | 254297 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 130X Junipero Serra Blvd | 3 | Median : Yard | Tree | Private 2 | 10x30 | 5991393 | 2095322 | 37.7328602072681 | -122.472146321186 | (37.7328602072681, -122.472146321186) | 1 | 8 | 4 | 64 | 40 | ||||
| 12971 | 253842 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 100X Junipero Serra Blvd | 1 | Median : Yard | Tree | Private 2 | 3x3 | 5991400 | 2095443 | 37.7331928478719 | -122.472130937334 | (37.7331928478719, -122.472130937334) | 1 | 8 | 4 | 64 | 40 | ||||
| 13098 | 254290 | Undocumented 4 | Cupressus macrocarpa :: Monterey Cypress 41 | 110 Junipero Serra Blvd | 2 | Median : Yard | Tree | Private 2 | 3x3 | 5991396 | 2095383 | 37.7330278715114 | -122.472140394325 | (37.7330278715114, -122.472140394325) | 1 | 8 | 4 | 64 | 40 | ||||
| 13318 | 262248 | Undocumented 4 | Cupressus macrocarpa :: Monterey Cypress 41 | 4210 Ocean Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 3x3 | 5986512 | 2095174 | 37.7321701636719 | -122.489010079787 | (37.7321701636719, -122.489010079787) | 1 | 8 | 4 | 64 | 35 | ||||
| 13572 | 261601 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 600X Sloat Blvd | 2 | Median : Cutout | Tree | Private 2 | 10x10 | 5989483 | 2096058 | 37.7347703567949 | -122.478803415035 | (37.7347703567949, -122.478803415035) | 1 | 8 | 3 | 64 | 35 | ||||
| 13755 | 11746 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 700X Junipero Serra Blvd | 29 | Median : Cutout | Tree | DPW 1 | 03/03/2006 12:00:00 AM | 3 | 6X6 | 5991277.67104 | 2092671.80389 | 37.7255767576586 | -122.472351910013 | (37.7255767576586, -122.472351910013) | 9 | 8 | 4 | 64 | 40 | ||
| 14861 | 176144 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 10 Lake Merced Blvd | 5 | : | Tree | Private 2 | 39 | Width 0ft | 5987593.26623 | 2090234.31177 | 37.7186700965335 | -122.484909687836 | (37.7186700965335, -122.484909687836) | 1 | 8 | 4 | 64 | 14 | |||
| 15055 | 259264 | Significant Tree 6 | Cupressus macrocarpa :: Monterey Cypress 41 | 3580X 19th Ave | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 3x3 | 5990529 | 2092111 | 37.723993571379 | -122.474899060099 | (37.723993571379, -122.474899060099) | 9 | 8 | 4 | 64 | 14 | ||||
| 16654 | 261545 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 600X Sloat Blvd | 1 | Median : Cutout | Tree | Private 2 | 10x10 | 5989483 | 2096058 | 37.7347703567949 | -122.478803415035 | (37.7347703567949, -122.478803415035) | 1 | 8 | 3 | 64 | 35 | ||||
| 16810 | 254987 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 850 Junipero Serra Blvd | 1 | Median : Cutout | Tree | Private 2 | 10x10 | 5991239 | 2091717 | 37.7229528649662 | -122.472416015965 | (37.7229528649662, -122.472416015965) | 9 | 8 | 4 | 64 | 40 | ||||
| 17153 | 206856 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 700 Junipero Serra Blvd | 45 | : | Tree | Private 2 | 26 | Width 0ft | 5991248.85263 | 2092491.97057 | 37.7250813121323 | -122.472438427511 | (37.7250813121323, -122.472438427511) | 9 | 8 | 4 | 64 | 40 | |||
| 21554 | 256452 | Undocumented 4 | Cupressus macrocarpa :: Monterey Cypress 41 | 2901 Sunset Blvd | 1 | Median : Yard | Tree | Private 2 | 3x3 | 5984945 | 2095183 | 37.7321032922905 | -122.494428131787 | (37.7321032922905, -122.494428131787) | 1 | 8 | 4 | 64 | 35 | ||||
| 21615 | 254127 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 100X Lake Merced Blvd | 1 | Median : Yard | Tree | DPW 1 | 10x10 | 5983894 | 2095251 | 37.7322284370415 | -122.498066633405 | (37.7322284370415, -122.498066633405) | 1 | 8 | 4 | 64 | 35 | ||||
| 21901 | 12497 | Permitted Site 7 | Cupressus macrocarpa :: Monterey Cypress 41 | 307 Lake Merced Blvd | 42 | Sidewalk: Curb side : Cutout | Tree | PUC 8 | 12 | 90M | 5985224.7663097 | 2094165.6248747 | 37.7293262181041 | -122.49338600271 | (37.7293262181041, -122.49338600271) | 1 | 8 | 4 | 64 | 14 | |||
| 24133 | 11748 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 700X Junipero Serra Blvd | 31 | Median : Cutout | Tree | DPW 1 | 03/09/2013 12:00:00 AM | 3 | 6X6 | 5991276.77165 | 2092652.88165 | 37.7255247498407 | -122.472353640304 | (37.7255247498407, -122.472353640304) | 9 | 8 | 4 | 64 | 40 | ||
| 24527 | 114055 | Undocumented 4 | Cupressus macrocarpa :: Monterey Cypress 41 | 700X LAKE MERCED BLVD | 1 | Median : Cutout | Tree | Private 2 | 50 | 5987837 | 2092819 | 37.7257811856502 | -122.484256664993 | (37.7257811856502, -122.484256664993) | 1 | 8 | 4 | 64 | 14 | ||||
| 27394 | 251152 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 625 Brotherhood Way | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5991521 | 2087959 | 37.7126506341802 | -122.471167551627 | (37.7126506341802, -122.471167551627) | 9 | 8 | 4 | 64 | 24 | ||||
| 27736 | 2271 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 700X Brotherhood Way | 5 | Median : Cutout | Tree | DPW 1 | 25 | 14M | 5990752.82343 | 2088228.49759 | 37.7133461459728 | -122.473842234135 | (37.7133461459728, -122.473842234135) | 1 | 8 | 4 | 64 | 14 | |||
| 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 | ||||
| 28931 | 111586 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 730X Lake Merced Blvd | 2 | Sidewalk: Property side : Yard | Tree | DPW 1 | 48 | 5987577.49507 | 2091187.90071 | 37.7212874908284 | -122.485034126397 | (37.7212874908284, -122.485034126397) | 1 | 8 | 4 | 64 | 14 | ||||
| 29536 | 12500 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 1200X Lake Merced Blvd | 2 | Median : Cutout | Tree | DPW 1 | 6 | 8 | 5987438.4549992 | 2087542.2692131 | 37.7112694082243 | -122.485247377649 | (37.7112694082243, -122.485247377649) | 1 | 8 | 4 | 64 | 14 | |||
| 30007 | 114128 | Undocumented 4 | Cupressus macrocarpa :: Monterey Cypress 41 | 1200X JUNIPERO SERRA BLVD | 21 | Sidewalk: Property side : Yard | Tree | Private 2 | 18 | 5991123 | 2089585 | 37.7170922039834 | -122.472661630304 | (37.7170922039834, -122.472661630304) | 1 | 8 | 4 | 64 | 14 | ||||
| 30774 | 206857 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 700 Junipero Serra Blvd | 64 | : | Tree | Private 2 | 17 | Width 0ft | 5991242.80469 | 2092347.545 | 37.7246844053568 | -122.472448810186 | (37.7246844053568, -122.472448810186) | 9 | 8 | 4 | 64 | 40 | |||
| 31631 | 12498 | Permitted Site 7 | Cupressus macrocarpa :: Monterey Cypress 41 | 307 Lake Merced Blvd | 43 | Sidewalk: Curb side : Cutout | Tree | PUC 8 | 12 | 90M | 5985224.7663097 | 2094165.6248747 | 37.7293262181041 | -122.49338600271 | (37.7293262181041, -122.49338600271) | 1 | 8 | 4 | 64 | 14 | |||
| 33619 | 12466 | Permitted Site 7 | Cupressus macrocarpa :: Monterey Cypress 41 | 307 Lake Merced Blvd | 11 | 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 | |||
| 33801 | 114265 | Undocumented 4 | Cupressus macrocarpa :: Monterey Cypress 41 | 800x BROTHERHOOD WAY | 6 | Front Yard : Cutout | Tree | Private 2 | 26 | 5990271 | 2088582 | 37.7142888575797 | -122.475533361779 | (37.7142888575797, -122.475533361779) | 1 | 8 | 4 | 64 | 14 | ||||
| 36507 | 176151 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 10 Lake Merced Blvd | 12 | : | Tree | Private 2 | 28 | Width 0ft | 5987601.77319 | 2090779.60025 | 37.7201678157831 | -122.484920265686 | (37.7201678157831, -122.484920265686) | 1 | 8 | 4 | 64 | 14 | |||
| 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 | |||
| 37154 | 254306 | Undocumented 4 | Cupressus macrocarpa :: Monterey Cypress 41 | 170 Junipero Serra Blvd | 3 | Median : Cutout | Tree | Private 2 | 10x10 | 5991380 | 2095134 | 37.732343254282 | -122.47217756607 | (37.732343254282, -122.47217756607) | 1 | 8 | 4 | 64 | 40 | ||||
| 37295 | 12460 | Permitted Site 7 | Cupressus macrocarpa :: Monterey Cypress 41 | 307 Lake Merced Blvd | 5 | 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 | |||
| 39401 | 12484 | Permitted Site 7 | Cupressus macrocarpa :: Monterey Cypress 41 | 307 Lake Merced Blvd | 29 | Sidewalk: Curb side : Cutout | Tree | PUC 8 | 12 | 90M | 5985224.7663097 | 2094165.6248747 | 37.7293262181041 | -122.49338600271 | (37.7293262181041, -122.49338600271) | 1 | 8 | 4 | 64 | 14 | |||
| 39547 | 114133 | Undocumented 4 | Cupressus macrocarpa :: Monterey Cypress 41 | 1200X JUNIPERO SERRA BLVD | 26 | Sidewalk: Property side : Yard | Tree | Private 2 | 28 | 5991123 | 2089585 | 37.7170922039834 | -122.472661630304 | (37.7170922039834, -122.472661630304) | 1 | 8 | 4 | 64 | 14 | ||||
| 41437 | 12469 | Permitted Site 7 | Cupressus macrocarpa :: Monterey Cypress 41 | 307 Lake Merced Blvd | 14 | 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 | |||
| 42100 | 114131 | Undocumented 4 | Cupressus macrocarpa :: Monterey Cypress 41 | 1200X JUNIPERO SERRA BLVD | 24 | Sidewalk: Property side : Yard | Tree | Private 2 | 30 | 5991123 | 2089585 | 37.7170922039834 | -122.472661630304 | (37.7170922039834, -122.472661630304) | 1 | 8 | 4 | 64 | 14 | ||||
| 42203 | 251150 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 625 Brotherhood Way | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5991521 | 2087959 | 37.7126506341802 | -122.471167551627 | (37.7126506341802, -122.471167551627) | 9 | 8 | 4 | 64 | 24 | ||||
| 42296 | 206849 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 2 Cranleigh Dr | 14 | Front Yard : Yard | Tree | Private 2 | 3 | Width 0ft | 5991370.13316 | 2095847.84746 | 37.7343027283865 | -122.472263695526 | (37.7343027283865, -122.472263695526) | 1 | 8 | 4 | 64 | 40 | |||
| 42366 | 114061 | Undocumented 4 | Cupressus macrocarpa :: Monterey Cypress 41 | 700X LAKE MERCED BLVD | 7 | Median : Cutout | Tree | Private 2 | 52 | 5987837 | 2092819 | 37.7257811856502 | -122.484256664993 | (37.7257811856502, -122.484256664993) | 1 | 8 | 4 | 64 | 14 | ||||
| 42627 | 109678 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 200X VIDAL DR | 7 | Median : Yard | Tree | DPW 1 | 5987624 | 2090693 | 37.7199313280832 | -122.484837086298 | (37.7199313280832, -122.484837086298) | 1 | 8 | 4 | 64 | 14 | |||||
| 43971 | 251151 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 625 Brotherhood Way | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5991521 | 2087959 | 37.7126506341802 | -122.471167551627 | (37.7126506341802, -122.471167551627) | 9 | 8 | 4 | 64 | 24 | ||||
| 45795 | 217840 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 2 Cranleigh Dr | 30 | Front Yard : Yard | Tree | Private 2 | 1 | 5991415.56175 | 2095863.71205 | 37.7343489175724 | -122.472107791755 | (37.7343489175724, -122.472107791755) | 1 | 8 | 4 | 64 | 40 | ||||
| 45967 | 12480 | Permitted Site 7 | Cupressus macrocarpa :: Monterey Cypress 41 | 307 Lake Merced Blvd | 25 | Sidewalk: Curb side : Cutout | Tree | PUC 8 | 12 | 90M | 5985224.7663097 | 2094165.6248747 | 37.7293262181041 | -122.49338600271 | (37.7293262181041, -122.49338600271) | 1 | 8 | 4 | 64 | 14 | |||
| 47011 | 206863 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 700 Junipero Serra Blvd | 101 | : | Tree | Private 2 | 16 | Width 0ft | 5991231.24746 | 2092036.74802 | 37.723830365071 | -122.472466114026 | (37.723830365071, -122.472466114026) | 9 | 8 | 4 | 64 | 40 | |||
| 47091 | 19431 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 1200X Sloat Blvd | 4 | Median : Cutout | Tree | DPW 1 | 11/13/2007 12:00:00 AM | 6 | 20 | 5987714.9376 | 2095926.0092 | 37.7343051218756 | -122.484906458155 | (37.7343051218756, -122.484906458155) | 1 | 8 | 4 | 64 | 35 | ||
| 47280 | 206872 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 900 Junipero Serra Blvd | 41 | : | Tree | Private 2 | 12 | Width 0ft | 5991149.64989 | 2090725.7488 | 37.7202259623434 | -122.47265264062 | (37.7202259623434, -122.47265264062) | 9 | 8 | 4 | 64 | 40 | |||
| 47800 | 255367 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 800X Brotherhood Way | 2 | Median : Cutout | Tree | DPW 1 | 14x10 | 5990271 | 2088582 | 37.7142888575797 | -122.475533361779 | (37.7142888575797, -122.475533361779) | 1 | 8 | 4 | 64 | 14 | ||||
| 47810 | 206855 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 400 Junipero Serra Blvd | 23 | : | Tree | Private 2 | 48 | Width 0ft | 5991362.72494 | 2093965.51745 | 37.7291338947086 | -122.472152147225 | (37.7291338947086, -122.472152147225) | 9 | 8 | 4 | 64 | 40 | |||
| 48223 | 11710 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 700X Junipero Serra Blvd | 27 | Median : Cutout | Tree | DPW 1 | 03/09/2013 12:00:00 AM | 3 | 3X3 | 5991285.51963 | 2092735.44075 | 37.7257519428913 | -122.472329415287 | (37.7257519428913, -122.472329415287) | 9 | 8 | 4 | 64 | 40 | ||
| 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 | |||
| 48690 | 206866 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 700 Junipero Serra Blvd | 132 | : | Tree | Private 2 | 28 | Width 0ft | 5991206.46725 | 2091692.32993 | 37.7228832440624 | -122.472526676182 | (37.7228832440624, -122.472526676182) | 9 | 8 | 4 | 64 | 40 | |||
| 49414 | 254986 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 866 Junipero Serra Blvd | 1 | Median : Cutout | Tree | Private 2 | 10x10 | 5991230 | 2091572 | 37.7225542099511 | -122.472436561116 | (37.7225542099511, -122.472436561116) | 9 | 8 | 4 | 64 | 40 | ||||
| 49560 | 217841 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 2 Cranleigh Dr | 31 | Front Yard : Yard | Tree | Private 2 | 1 | 5991404.95504 | 2095888.4488 | 37.7344162246301 | -122.472146264739 | (37.7344162246301, -122.472146264739) | 1 | 8 | 4 | 64 | 40 | ||||
| 49941 | 109676 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 200X VIDAL DR | 5 | Median : Yard | Tree | DPW 1 | 5987624 | 2090693 | 37.7199313280832 | -122.484837086298 | (37.7199313280832, -122.484837086298) | 1 | 8 | 4 | 64 | 14 | |||||
| 50382 | 2269 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 700X Brotherhood Way | 3 | Median : Cutout | Tree | DPW 1 | 6 | 14M | 5990714.96133 | 2088247.7727 | 37.7133968776506 | -122.473974502829 | (37.7133968776506, -122.473974502829) | 1 | 8 | 4 | 64 | 14 | |||
| 50796 | 176161 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 0 Gonzalez Dr | 4 | Sidewalk: Curb side : Yard | Tree | Private 2 | 2 | 5990361.86615 | 2090050.7376 | 37.7183269161272 | -122.475326462647 | (37.7183269161272, -122.475326462647) | 1 | 8 | 4 | 64 | 14 | ||||
| 50924 | 2270 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 700X Brotherhood Way | 4 | Median : Cutout | Tree | DPW 1 | 6 | 14M | 5990735.60667 | 2088236.94426 | 37.7133683412468 | -122.473902356505 | (37.7133683412468, -122.473902356505) | 1 | 8 | 4 | 64 | 14 | |||
| 51599 | 11703 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 700X Junipero Serra Blvd | 20 | Median : Cutout | Tree | DPW 1 | 03/30/2006 12:00:00 AM | 3 | 6X6 | 5991288.65534 | 2092789.2072 | 37.7258997536651 | -122.472322493193 | (37.7258997536651, -122.472322493193) | 9 | 8 | 4 | 64 | 40 | ||
| 53424 | 176128 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 3500 Great Hwy | 15 | Median : | Tree | Private 2 | 3 | Width 0ft | 5982352.93882 | 2092754.66757 | 37.7252837063712 | -122.503209580278 | (37.7252837063712, -122.503209580278) | 1 | 8 | 4 | 64 | 14 | |||
| 53564 | 114125 | Undocumented 4 | Cupressus macrocarpa :: Monterey Cypress 41 | 1200X JUNIPERO SERRA BLVD | 18 | Sidewalk: Property side : Yard | Tree | Private 2 | 18 | 5991123 | 2089585 | 37.7170922039834 | -122.472661630304 | (37.7170922039834, -122.472661630304) | 1 | 8 | 4 | 64 | 14 | ||||
| 54579 | 12458 | Permitted Site 7 | Cupressus macrocarpa :: Monterey Cypress 41 | 307 Lake Merced Blvd | 3 | 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 | |||
| 55368 | 109658 | Undocumented 4 | Cupressus macrocarpa :: Monterey Cypress 41 | 800X BROTHERHOOD WAY | 29 | Median : Cutout | Tree | DPW 1 | 5990271.4 | 2088582.7 | 37.7142908027957 | -122.475532030318 | (37.7142908027957, -122.475532030318) | 1 | 8 | 4 | 64 | 14 | |||||
| 56325 | 12483 | Permitted Site 7 | Cupressus macrocarpa :: Monterey Cypress 41 | 307 Lake Merced Blvd | 28 | Sidewalk: Curb side : Cutout | Tree | PUC 8 | 18 | 90M | 5985224.7663097 | 2094165.6248747 | 37.7293262181041 | -122.49338600271 | (37.7293262181041, -122.49338600271) | 1 | 8 | 4 | 64 | 14 | |||
| 56804 | 176140 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 10 Lake Merced Blvd | 3 | : | Tree | Private 2 | 15 | Width 0ft | 5987455.89858 | 2088588.29538 | 37.7141425496068 | -122.485263793215 | (37.7141425496068, -122.485263793215) | 1 | 8 | 4 | 64 | 14 | |||
| 56809 | 176146 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 10 Lake Merced Blvd | 7 | : | Tree | Private 2 | 40 | Width 0ft | 5987590.81022 | 2090334.92594 | 37.7189462144818 | -122.48492555459 | (37.7189462144818, -122.48492555459) | 1 | 8 | 4 | 64 | 14 | |||
| 56871 | 176139 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 10 Lake Merced Blvd | 2 | : | Tree | Private 2 | 10 | Width 0ft | 5987453.25598 | 2088569.38174 | 37.7140904635658 | -122.485271539962 | (37.7140904635658, -122.485271539962) | 1 | 8 | 4 | 64 | 14 | |||
| 59933 | 122637 | Significant Tree 6 | Cupressus macrocarpa :: Monterey Cypress 41 | 3630X 19th Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 3x8 | 5990614 | 2091411 | 37.7220764711857 | -122.47455416919 | (37.7220764711857, -122.47455416919) | 9 | 8 | 4 | 64 | 40 | ||||
| 60213 | 254988 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 870 Junipero Serra Blvd | 1 | Median : Cutout | Tree | Private 2 | 10x10 | 5991228 | 2091536 | 37.7224552471007 | -122.472440851401 | (37.7224552471007, -122.472440851401) | 9 | 8 | 4 | 64 | 40 | ||||
| 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 | |||
| 61669 | 12456 | Permitted Site 7 | Cupressus macrocarpa :: Monterey Cypress 41 | 307 Lake Merced Blvd | 1 | 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 | |||
| 61732 | 29625 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 900X Junipero Serra Blvd | 34 | Median : Cutout | Tree | DPW 1 | 03/09/2013 12:00:00 AM | 3 | 3X3 | 5991156.8644 | 2090780.05839 | 37.7203755006984 | -122.472631660317 | (37.7203755006984, -122.472631660317) | 9 | 8 | 4 | 64 | 40 | ||
| 61895 | 176115 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 10 Skyline Blvd | 1 | : | Tree | Private 2 | 8 | Width 0ft | 5982387.31367 | 2092831.90061 | 37.7254977881756 | -122.503096467121 | (37.7254977881756, -122.503096467121) | 1 | 8 | 4 | 64 | 14 | |||
| 62262 | 251148 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 625 Brotherhood Way | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5991521 | 2087959 | 37.7126506341802 | -122.471167551627 | (37.7126506341802, -122.471167551627) | 9 | 8 | 4 | 64 | 24 | ||||
| 63950 | 254128 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 100X Lake Merced Blvd | 2 | Median : Yard | Tree | DPW 1 | 10x10 | 5983894 | 2095251 | 37.7322284370415 | -122.498066633405 | (37.7322284370415, -122.498066633405) | 1 | 8 | 4 | 64 | 35 | ||||
| 64580 | 114269 | Undocumented 4 | Cupressus macrocarpa :: Monterey Cypress 41 | 800x BROTHERHOOD WAY | 10 | Front Yard : Yard | Tree | Private 2 | 38 | 5990271 | 2088582 | 37.7142888575797 | -122.475533361779 | (37.7142888575797, -122.475533361779) | 1 | 8 | 4 | 64 | 14 | ||||
| 66603 | 254984 | Undocumented 4 | Cupressus macrocarpa :: Monterey Cypress 41 | 830 Junipero Serra Blvd | 1 | Median : Yard | Tree | Private 2 | 10x10 | 5991251 | 2091898 | 37.7234505406642 | -122.472387723412 | (37.7234505406642, -122.472387723412) | 9 | 8 | 4 | 64 | 40 |
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) );