trees
1,977 rows where qSpecies_id = 41 sorted by rowid 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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 194499 | 265142 | Significant Tree 6 | Cupressus macrocarpa :: Monterey Cypress 41 | 75X Cedro Ave | 1 | Back Yard : Cutout | Tree | Private 2 | 3x3 | 5992440 | 2092965 | 37.7264490050903 | -122.468355192232 | (37.7264490050903, -122.468355192232) | 9 | 8 | 4 | 59 | 40 | ||||
| 194384 | 254279 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 80X Junipero Serra Blvd | 3 | Median : Yard | Tree | Private 2 | 12/24/2020 01:32:00 PM | 3 | 3x3 | 5991405 | 2095520 | 37.733404559811 | -122.472119261767 | (37.733404559811, -122.472119261767) | 1 | 8 | 4 | 64 | 40 | ||
| 194291 | 264997 | Significant Tree 6 | Cupressus macrocarpa :: Monterey Cypress 41 | 909 Shields St | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | 3x9 | 5991621 | 2089826 | 37.7177827456648 | -122.470957844969 | (37.7177827456648, -122.470957844969) | 9 | 8 | 6 | 64 | 24 | ||||
| 193947 | 186095 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 1901 Sunset Blvd | 41 | Sidewalk: Property side : Yard | Tree | Private 2 | 57 | Width 0ft | 5984840.151 | 2101765.7139 | 37.7501715111334 | -122.495275887194 | (37.7501715111334, -122.495275887194) | 1 | 8 | 3 | 29491 | 35 | |||
| 193891 | 105837 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 2100X SLOAT BLVD | 4 | Median : Yard | Tree | DPW 1 | 7 | 5984309 | 2095832 | 37.733848030924 | -122.49667476772 | (37.733848030924, -122.49667476772) | 1 | 8 | 3 | 64 | 35 | ||||
| 193880 | 92560 | Permitted Site 7 | Cupressus macrocarpa :: Monterey Cypress 41 | 222 Stanyan St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | Permit Number 52905 | 5996693 | 2111182 | 37.7767130721687 | -122.454968563419 | (37.7767130721687, -122.454968563419) | 15 | 6 | 2 | 54 | 16 | |||
| 193653 | 124177 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 8X Almaden Ct | 1 | Sidewalk: Property side : Yard | Tree | DPW 1 | 10 | Width 9ft | 5995876 | 2112606 | 37.7805760973259 | -122.457897862346 | (37.7805760973259, -122.457897862346) | 11 | 6 | 2 | 54 | 16 | |||
| 193618 | 254237 | Significant Tree 6 | Cupressus macrocarpa :: Monterey Cypress 41 | 47 Cole St | 2 | Front Yard : Yard | Tree | Private 2 | 5997708 | 2110435 | 37.7747201781994 | -122.451403505262 | (37.7747201781994, -122.451403505262) | 15 | 5 | 2 | 29492 | 16 | |||||
| 193601 | 186140 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 1700 Sunset Blvd | 25 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 0ft | 5984976.0967 | 2103251.4805 | 37.7542589762797 | -122.494915322593 | (37.7542589762797, -122.494915322593) | 1 | 8 | 3 | 56 | 35 | |||
| 193545 | 109651 | Undocumented 4 | Cupressus macrocarpa :: Monterey Cypress 41 | 800X BROTHERHOOD WAY | 22 | Median : Cutout | Tree | DPW 1 | 5990271.4 | 2088582.7 | 37.7142908027957 | -122.475532030318 | (37.7142908027957, -122.475532030318) | 1 | 8 | 4 | 64 | 14 | |||||
| 193250 | 186011 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 1900 Sunset Blvd | 6 | Sidewalk: Property side : Yard | Tree | Private 2 | 50 | Width 0ft | 5984995.4358 | 2101704.915 | 37.750013664548 | -122.494734428948 | (37.750013664548, -122.494734428948) | 1 | 8 | 3 | 29491 | 35 | |||
| 193245 | 254239 | Significant Tree 6 | Cupressus macrocarpa :: Monterey Cypress 41 | 47 Cole St | 4 | Front Yard : Yard | Tree | Private 2 | 5997708 | 2110435 | 37.7747201781994 | -122.451403505262 | (37.7747201781994, -122.451403505262) | 15 | 5 | 2 | 29492 | 16 | |||||
| 193206 | 186256 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 1701 Sunset Blvd | 67 | Sidewalk: Property side : Yard | Tree | Private 2 | 99 | Width 0ft | 5984812.6153 | 2103003.1364 | 37.7535675206606 | -122.495462358835 | (37.7535675206606, -122.495462358835) | 1 | 8 | 3 | 56 | 35 | |||
| 193151 | 20851 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 1892X Sunset Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 48 | 60 | 5984852.8466778 | 2102317.5089788 | 37.7516873322231 | -122.49527267334 | (37.7516873322231, -122.49527267334) | 1 | 8 | 3 | 56 | 35 | |||
| 193079 | 12476 | Permitted Site 7 | Cupressus macrocarpa :: Monterey Cypress 41 | 307 Lake Merced Blvd | 21 | 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 | |||
| 193061 | 21109 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 2201X Sunset Blvd | 13 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 24 | 60 | 5985004.6737667 | 2100227.1692458 | 37.7459567185928 | -122.494593556276 | (37.7459567185928, -122.494593556276) | 1 | 8 | 3 | 29491 | 35 | |||
| 192786 | 253314 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 2 Euclid Ave | 12 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5999085 | 2114289 | 37.7853810185166 | -122.446917590697 | (37.7853810185166, -122.446917590697) | 15 | 6 | 1 | 54 | 31 | |||||
| 192549 | 98880 | Property Tree 8 | Cupressus macrocarpa :: Monterey Cypress 41 | 101 Lansdale Ave | 1 | Front Yard : Yard | Tree | Private 2 | 11 | 5994747.9 | 2097283.1 | 37.7384384842789 | -122.460689725403 | (37.7384384842789, -122.460689725403) | 9 | 7 | 4 | 59 | 40 | ||||
| 192415 | 251157 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 625 Brotherhood Way | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5991521 | 2087959 | 37.7126506341802 | -122.471167551627 | (37.7126506341802, -122.471167551627) | 9 | 8 | 4 | 64 | 24 | ||||
| 192259 | 253780 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 90 Cuesta Ct | 4 | Front Yard : Yard | Tree | DPW 1 | 5999757 | 2101744 | 37.7509739685765 | -122.443691128062 | (37.7509739685765, -122.443691128062) | 2 | 5 | 5 | 63 | 38 | |||||
| 192234 | 8622 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 2600 Geary Blvd | 10 | Median : Cutout | Tree | DPW 1 | 12 | 20 | 5999315.0497 | 2113216.8408 | 37.782450288182 | -122.446044546347 | (37.782450288182, -122.446044546347) | 15 | 5 | 1 | 54 | 16 | |||
| 192090 | 247060 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 5399 Diamond Heights Blvd | 15 | Sidewalk: Property side : Yard | Tree | Private 2 | 35 | 6001954.14526 | 2098563.83613 | 37.7423670597824 | -122.435865678079 | (37.7423670597824, -122.435865678079) | 2 | 7 | 5 | 63 | 22 | ||||
| 192043 | 12457 | Permitted Site 7 | Cupressus macrocarpa :: Monterey Cypress 41 | 307 Lake Merced Blvd | 2 | 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 | |||
| 191822 | 40713 | Permitted Site 7 | Cupressus macrocarpa :: Monterey Cypress 41 | 2 Crown Ter | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 41692 | 5998528.84920016 | 2104703.4154957 | 37.7590296670037 | -122.448151244492 | (37.7590296670037, -122.448151244492) | 15 | 5 | 5 | 28862 | 12 | ||||
| 191814 | 106757 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 999 Key Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 06/02/2014 12:00:00 AM | 36 | 6013321.20233 | 2089752.82506 | 37.7188129925151 | -122.395944254446 | (37.7188129925151, -122.395944254446) | 10 | 3 | 8 | 58 | 1 | |||
| 191786 | 176108 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 520 Carter St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 25 | 6005255.13814 | 2086372.03343 | 37.7090780076251 | -122.4235852251 | (37.7090780076251, -122.4235852251) | 9 | 7 | 8 | 309 | 5 | ||||
| 191748 | 223759 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 5745 Diamond Heights Blvd | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 17 | Width 6ft | 6000735.24552 | 2096973.38069 | 37.7379307275268 | -122.439966240358 | (37.7379307275268, -122.439966240358) | 2 | 7 | 5 | 63 | 7 | |||
| 191666 | 20535 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 1303X Sunset Blvd | 13 | 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 | |||
| 191505 | 121180 | Significant Tree 6 | Cupressus macrocarpa :: Monterey Cypress 41 | 1000x Duncan St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5999834 | 2099740 | 37.7454758595085 | -122.443280934089 | (37.7454758595085, -122.443280934089) | 2 | 7 | 5 | 63 | 22 | ||||
| 191057 | 100769 | Undocumented 4 | Cupressus macrocarpa :: Monterey Cypress 41 | 3701 21st St | Front Yard : Yard | Tree | Private 2 | 55 | Street tree w/in RoW | 6003717 | 2103606 | 37.7563116466144 | -122.43012988292 | (37.7563116466144, -122.43012988292) | 2 | 4 | 5 | 28862 | 22 | ||||
| 191030 | 253309 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 2 Euclid Ave | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5999085 | 2114289 | 37.7853810185166 | -122.446917590697 | (37.7853810185166, -122.446917590697) | 15 | 6 | 1 | 54 | 31 | |||||
| 191023 | 20803 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 1792X Sunset Blvd | 7 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/21/2017 10:15:00 AM | 3 | 60 | 5984829.6375693 | 2102999.3844439 | 37.7535582155387 | -122.495403216296 | (37.7535582155387, -122.495403216296) | 1 | 8 | 3 | 56 | 35 | ||
| 190973 | 114057 | Undocumented 4 | Cupressus macrocarpa :: Monterey Cypress 41 | 700X LAKE MERCED BLVD | 3 | Median : Cutout | Tree | Private 2 | 46 | 5987837 | 2092819 | 37.7257811856502 | -122.484256664993 | (37.7257811856502, -122.484256664993) | 1 | 8 | 4 | 64 | 14 | ||||
| 190882 | 251610 | Significant Tree 6 | Cupressus macrocarpa :: Monterey Cypress 41 | 56R Amber Dr | 3 | Back Yard : Yard | Tree | Private 2 | 5999423 | 2100048 | 37.7462981080439 | -122.44472423658 | (37.7462981080439, -122.44472423658) | 2 | 7 | 5 | 63 | 22 | |||||
| 190718 | 205911 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 198 Mangels Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 51 | 6000172.88009 | 2095259.68329 | 37.733193286926 | -122.441787651691 | (37.733193286926, -122.441787651691) | 9 | 7 | 5 | 63 | 40 | ||||
| 190717 | 126428 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 1701 North Point St | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | Width 3ft | 6002587.87385 | 2120898.67704 | 37.8037289775726 | -122.43527166598 | (37.8037289775726, -122.43527166598) | 13 | 9 | 1 | 57 | 17 | |||
| 190684 | 253976 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 441 Detroit St | 1 | Unaccepted Street : Yard | Tree | DPW 1 | 10x10 | 5999396 | 2094599 | 37.7313349085161 | -122.444426062201 | (37.7313349085161, -122.444426062201) | 9 | 7 | 4 | 59 | 40 | ||||
| 190603 | 21185 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 2301 Sunset Blvd | 26 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 36 | 60 | 5985027.9083074 | 2099542.6271361 | 37.744078511576 | -122.494462762583 | (37.744078511576, -122.494462762583) | 1 | 8 | 3 | 29491 | 35 | |||
| 190476 | 186070 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 1901 Sunset Blvd | 16 | Sidewalk: Property side : Yard | Tree | Private 2 | 13 | Width 0ft | 5984836.275 | 2102048.8375 | 37.750948663905 | -122.495310167617 | (37.750948663905, -122.495310167617) | 1 | 8 | 3 | 29491 | 35 | |||
| 190415 | 206805 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 68 Aerial Way | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 20 | Width 2ft | 5992337.85259 | 2102586.33778 | 37.7528608629412 | -122.469408341716 | (37.7528608629412, -122.469408341716) | 1 | 8 | 4 | 56 | 12 | |||
| 190358 | 185685 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 2101 Sunset Blvd | 17 | Sidewalk: Property side : Yard | Tree | Private 2 | 43 | Width 0ft | 5984846.0505 | 2100610.3074 | 37.7469994262442 | -122.49517029441 | (37.7469994262442, -122.49517029441) | 1 | 8 | 3 | 29491 | 35 | |||
| 190333 | 120920 | Undocumented 4 | Cupressus macrocarpa :: Monterey Cypress 41 | 198X Miraloma Dr | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 3x10 | 5994595 | 2096392 | 37.7359829456919 | -122.461153801837 | (37.7359829456919, -122.461153801837) | 9 | 8 | 4 | 59 | 40 | |||
| 190154 | 29593 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 900X Junipero Serra Blvd | 2 | Median : Cutout | Tree | DPW 1 | 03/30/2006 12:00:00 AM | 3 | 3X3 | 5991180.05944 | 2091153.12589 | 37.7214011945921 | -122.472578668672 | (37.7214011945921, -122.472578668672) | 9 | 8 | 4 | 64 | 40 | ||
| 190005 | 176123 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 3500 Great Hwy | 10 | Median : | Tree | Private 2 | 3 | Width 0ft | 5982341.65637 | 2092773.52846 | 37.725334830111 | -122.503249977802 | (37.725334830111, -122.503249977802) | 1 | 8 | 4 | 64 | 14 | |||
| 189908 | 190975 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 800 Vermont St | 23 | Sidewalk: Curb side : Yard | Tree | Private 2 | 28 | 6011275.59974 | 2104245.89235 | 37.7584938511263 | -122.40403451598 | (37.7584938511263, -122.40403451598) | 10 | 3 | 8 | 28856 | 29 | ||||
| 189870 | 223696 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 1001 San Jose Ave | 13 | Front Yard : Yard | Tree | Private 2 | 23 | 6005111.39586 | 2096784.72517 | 37.7376608688401 | -122.42482230912 | (37.7376608688401, -122.42482230912) | 2 | 7 | 5 | 28859 | 2 | ||||
| 189594 | 223791 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 69 Levant St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 36 | Width 3ft | 6000368.06545 | 2106346.57806 | 37.7636463558292 | -122.441908320012 | (37.7636463558292, -122.441908320012) | 15 | 5 | 5 | 28862 | 3 | |||
| 189572 | 181404 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 1500 Sunset Blvd | 37 | Sidewalk: Property side : Yard | Tree | Private 2 | 21 | Width 0ft | 5984893.3996 | 2104690.5846 | 37.7582055161201 | -122.495307429068 | (37.7582055161201, -122.495307429068) | 1 | 8 | 3 | 56 | 35 | |||
| 189570 | 206837 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 100x Idora Ave | 25 | Median : Yard | Tree | DPW 1 | 63 | Width 9ft | 5995840.17489 | 2099294.03492 | 37.7440227989188 | -122.457058611284 | (37.7440227989188, -122.457058611284) | 1 | 8 | 4 | 59 | 40 | |||
| 189507 | 223695 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 1001 San Jose Ave | 10 | Front Yard : Yard | Tree | Private 2 | 37 | 6005104.91543 | 2096758.07935 | 37.7375873393881 | -122.424842819957 | (37.7375873393881, -122.424842819957) | 2 | 7 | 5 | 28859 | 2 | ||||
| 189495 | 12470 | Permitted Site 7 | Cupressus macrocarpa :: Monterey Cypress 41 | 307 Lake Merced Blvd | 15 | 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 | |||
| 189462 | 118640 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 495 45th Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 17 | Width 3ft | 5981891.5492 | 2112442.21245 | 37.7793130253265 | -122.506263746074 | (37.7793130253265, -122.506263746074) | 11 | 6 | 2 | 55 | 26 | |||
| 189434 | 187141 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 2301 Sunset Blvd | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 52 | Width 0ft | 5984898.7676 | 2099479.6664 | 37.7438980796356 | -122.494904654416 | (37.7438980796356, -122.494904654416) | 1 | 8 | 3 | 29491 | 35 | |||
| 189392 | 178285 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 900 Brotherhood Way | 14 | Median : Cutout | Tree | Private 2 | 18 | 10x10 | 5988379.49875 | 2088734.13698 | 37.7145967558101 | -122.482082191442 | (37.7145967558101, -122.482082191442) | 1 | 8 | 4 | 64 | 14 | |||
| 189315 | 185977 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 2001 Sunset Blvd | 36 | Sidewalk: Property side : Yard | Tree | Private 2 | 85 | Width 0ft | 5984864.6841 | 2101097.7224 | 37.7483388256863 | -122.495141798808 | (37.7483388256863, -122.495141798808) | 1 | 8 | 3 | 29491 | 35 | |||
| 189267 | 186109 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 1901 Sunset Blvd | 55 | Sidewalk: Property side : Yard | Tree | Private 2 | 57 | Width 0ft | 5984840.4659 | 2101628.7594 | 37.7497954900583 | -122.495264699643 | (37.7497954900583, -122.495264699643) | 1 | 8 | 3 | 29491 | 35 | |||
| 189210 | 223766 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 317 Elsie St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 7 | Width 3ft | 6006968.55634 | 2098198.91003 | 37.7416486273844 | -122.418501452004 | (37.7416486273844, -122.418501452004) | 2 | 7 | 7 | 28859 | 2 | |||
| 189051 | 121994 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 598 15th Ave | 5 | Sidewalk: Property side : Yard | Tree | Private 2 | 16 | Width 3ft | 5991309.65068 | 2111442.68256 | 37.7771185426669 | -122.473609997196 | (37.7771185426669, -122.473609997196) | 11 | 6 | 2 | 54 | 26 | |||
| 189011 | 21412 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 2692X Sunset Blvd | 14 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 60 | 5985040.0664617 | 2096882.0619327 | 37.7367740271268 | -122.494224659054 | (37.7367740271268, -122.494224659054) | 1 | 8 | 3 | 29491 | 35 | |||
| 188942 | 104888 | Significant Tree 6 | Cupressus macrocarpa :: Monterey Cypress 41 | 146 Gonzalez Dr | 1 | Front Yard : Yard | Tree | Private 2 | 5990401 | 2090562 | 37.7197329843514 | -122.475228499286 | (37.7197329843514, -122.475228499286) | 1 | 8 | 4 | 64 | 14 | |||||
| 188262 | 185699 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 2101 Sunset Blvd | 31 | Sidewalk: Property side : Yard | Tree | Private 2 | 49 | Width 0ft | 5984860.4343 | 2100518.1203 | 37.7467471477001 | -122.495113760419 | (37.7467471477001, -122.495113760419) | 1 | 8 | 3 | 29491 | 35 | |||
| 187891 | 8650 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 2800 Geary Blvd | 2 | Median : Cutout | Tree | DPW 1 | 6 | M6 | 5998245.1291 | 2113130.374 | 37.7821517178635 | -122.449739754186 | (37.7821517178635, -122.449739754186) | 15 | 6 | 2 | 54 | 16 | |||
| 187889 | 20474 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 1203X Sunset Blvd | 8 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 48 | 40 | 5984781.3005655 | 2107242.2257009 | 37.7652050441375 | -122.495883339617 | (37.7652050441375, -122.495883339617) | 11 | 6 | 2 | 55 | 8 | |||
| 187767 | 186093 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 1901 Sunset Blvd | 39 | Sidewalk: Property side : Yard | Tree | Private 2 | 21 | Width 0ft | 5984839.5214 | 2101790.2712 | 37.7502389018818 | -122.495279875153 | (37.7502389018818, -122.495279875153) | 1 | 8 | 3 | 29491 | 35 | |||
| 187724 | 8531 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 2100 Geary Blvd | 2 | Median : Cutout | Tree | DPW 1 | 24 | 6 | 6001578.5839 | 2113601.7956 | 37.7836362733136 | -122.438241309064 | (37.7836362733136, -122.438241309064) | 15 | 5 | 11 | 29490 | 41 | |||
| 187702 | 184008 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 1600 Sunset Blvd | 7 | Sidewalk: Property side : Yard | Tree | Private 2 | 17 | Width 0ft | 5984916.8087 | 2103724.6456 | 37.7555546860782 | -122.495155242128 | (37.7555546860782, -122.495155242128) | 1 | 8 | 3 | 56 | 35 | |||
| 187529 | 176107 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 700x Mansell St | 46 | Median : Cutout | Tree | DPW 1 | 61 | Width 0ft | 6008982.60232 | 2089910.35131 | 37.7190031946297 | -122.410952245957 | (37.7190031946297, -122.410952245957) | 9 | 3 | 8 | 309 | 18 | |||
| 187449 | 20830 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 1801X Sunset Blvd | 8 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 42 | 60 | 5984911.465596 | 2102939.293478 | 37.7533980132231 | -122.495115810531 | (37.7533980132231, -122.495115810531) | 1 | 8 | 3 | 56 | 35 | |||
| 187287 | 20835 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 1801X Sunset Blvd | 13 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 42 | 60 | 5984911.465596 | 2102939.293478 | 37.7533980132231 | -122.495115810531 | (37.7533980132231, -122.495115810531) | 1 | 8 | 3 | 56 | 35 | |||
| 187238 | 185408 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 2300 Sunset Blvd | 23 | unknown : Yard | Tree | Private 2 | 10 | Width 0ft | 5985102.6354 | 2099127.4066 | 37.7429428014208 | -122.494173778846 | (37.7429428014208, -122.494173778846) | 1 | 8 | 3 | 29491 | 35 | |||
| 187195 | 21022 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 2101X Sunset Blvd | 3 | 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 | |||
| 187161 | 253304 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 2 Euclid Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5999085 | 2114289 | 37.7853810185166 | -122.446917590697 | (37.7853810185166, -122.446917590697) | 15 | 6 | 1 | 54 | 31 | |||||
| 187146 | 187362 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 2200 Sunset Blvd | 47 | Sidewalk: Property side : Yard | Tree | Private 2 | 2 | Width 0ft | 5985051.5932 | 2099845.3222 | 37.7449110163112 | -122.494403175092 | (37.7449110163112, -122.494403175092) | 1 | 8 | 3 | 29491 | 35 | |||
| 187137 | 206839 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 112 Marston Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 41 | 5998729.31623 | 2093223.37366 | 37.7275196997604 | -122.446631964111 | (37.7275196997604, -122.446631964111) | 9 | 7 | 4 | 28861 | 40 | ||||
| 187049 | 186419 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 1601 Sunset Blvd | 7 | Sidewalk: Property side : Yard | Tree | Private 2 | 52 | Width 0ft | 5984745.9677 | 2104178.462 | 37.7567907366139 | -122.495779528729 | (37.7567907366139, -122.495779528729) | 1 | 8 | 3 | 56 | 35 | |||
| 187022 | 185457 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 2400 Sunset Blvd | 7 | unknown : Yard | Tree | Private 2 | 13 | Width 0ft | 5985129.0416 | 2098307.8751 | 37.740694134038 | -122.494022088477 | (37.740694134038, -122.494022088477) | 1 | 8 | 3 | 29491 | 35 | |||
| 186966 | 114134 | Undocumented 4 | Cupressus macrocarpa :: Monterey Cypress 41 | 1200X JUNIPERO SERRA BLVD | 28 | Sidewalk: Property side : Yard | Tree | Private 2 | 36 | 5991123 | 2089585 | 37.7170922039834 | -122.472661630304 | (37.7170922039834, -122.472661630304) | 1 | 8 | 4 | 64 | 14 | ||||
| 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 | ||||
| 186872 | 186016 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 1900 Sunset Blvd | 11 | Sidewalk: Property side : Yard | Tree | Private 2 | 50 | Width 0ft | 5985010.438 | 2101801.7034 | 37.7502802971025 | -122.49468968613 | (37.7502802971025, -122.49468968613) | 1 | 8 | 3 | 29491 | 35 | |||
| 186871 | 95072 | Permitted Site 7 | Cupressus macrocarpa :: Monterey Cypress 41 | 19 Miguel St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | Permit Number 54021 | 6003434 | 2097382 | 37.7392059633181 | -122.430664475135 | (37.7392059633181, -122.430664475135) | 2 | 7 | 5 | 63 | 7 | |||
| 186544 | 21174 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 2301 Sunset Blvd | 15 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 36 | 60 | 5985027.9083074 | 2099542.6271361 | 37.744078511576 | -122.494462762583 | (37.744078511576, -122.494462762583) | 1 | 8 | 3 | 29491 | 35 | |||
| 186507 | 254476 | Significant Tree 6 | Cupressus macrocarpa :: Monterey Cypress 41 | 1511 Lyon St | 1 | Front Yard : Cutout | Tree | Private 2 | 5999620 | 2114151 | 37.7850326563334 | -122.445056733542 | (37.7850326563334, -122.445056733542) | 15 | 6 | 1 | 29490 | 31 | |||||
| 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 | |||
| 186230 | 253320 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 2 Euclid Ave | 18 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5999085 | 2114289 | 37.7853810185166 | -122.446917590697 | (37.7853810185166, -122.446917590697) | 15 | 6 | 1 | 54 | 31 | |||||
| 185954 | 190982 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 2 Tulare St | 23 | Front Yard : Yard | Tree | Private 2 | 34 | 6016087.28584 | 2100258.68622 | 37.7478134836207 | -122.387115296958 | (37.7478134836207, -122.387115296958) | 3 | 8 | 58 | 1 | |||||
| 185758 | 248488 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 772 Ashbury St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 21 | Width 0ft | 5999103.5198 | 2107851.3675 | 37.7677059906434 | -122.44639023232 | (37.7677059906434, -122.44639023232) | 15 | 5 | 11 | 29492 | 9 | |||
| 185756 | 206888 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 449 Parnassus Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 28 | Width 3ft | 5995669.52074 | 2106315.57274 | 37.7632923655851 | -122.458156768919 | (37.7632923655851, -122.458156768919) | 15 | 5 | 4 | 63 | 12 | |||
| 185686 | 185490 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 2400 Sunset Blvd | 43 | unknown : Yard | Tree | Private 2 | 18 | Width 0ft | 5985127.7135 | 2098570.8346 | 37.7414160723152 | -122.494046056025 | (37.7414160723152, -122.494046056025) | 1 | 8 | 3 | 29491 | 35 | |||
| 185601 | 252907 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 25 Point Lobos Ave | 10 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 10x10 | 5982783.76519 | 2112486.06679 | 37.7794859217892 | -122.503180498061 | (37.7794859217892, -122.503180498061) | 11 | 6 | 2 | 55 | 26 | ||||
| 185567 | 2255 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 700X Brotherhood Way | 1 | Median : Cutout | Tree | DPW 1 | 17 | 5990660.02895 | 2088282.42041 | 37.7134888297138 | -122.474166893001 | (37.7134888297138, -122.474166893001) | 1 | 8 | 4 | 64 | 14 | ||||
| 185344 | 250204 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 206 Union St | 1 | Front Yard : Yard | Tree | Private 2 | 21 | Width 0ft | 6011843.53468 | 2119802.56119 | 37.8012405714539 | -122.403164615272 | (37.8012405714539, -122.403164615272) | 3 | 1 | 10 | 308 | 23 | |||
| 185289 | 251616 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 64R Amber Dr | 3 | Back Yard : Yard | Tree | Private 2 | 5999367 | 2100045 | 37.7462866749207 | -122.444917661566 | (37.7462866749207, -122.444917661566) | 2 | 7 | 5 | 63 | 22 | |||||
| 185113 | 114059 | Undocumented 4 | Cupressus macrocarpa :: Monterey Cypress 41 | 700X LAKE MERCED BLVD | 5 | Median : Cutout | Tree | Private 2 | 38 | 5987837 | 2092819 | 37.7257811856502 | -122.484256664993 | (37.7257811856502, -122.484256664993) | 1 | 8 | 4 | 64 | 14 | ||||
| 185053 | 99826 | Significant Tree 6 | Cupressus macrocarpa :: Monterey Cypress 41 | 1 Cascade Walk | 1 | Front Yard : Yard | Tree | Private 2 | 5992183.1 | 2103187.3 | 37.7545020044945 | -122.469987253468 | (37.7545020044945, -122.469987253468) | 1 | 8 | 4 | 56 | 12 | |||||
| 184977 | 186019 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 1900 Sunset Blvd | 14 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 0ft | 5985029.3117 | 2101835.0954 | 37.7503730870817 | -122.494626882044 | (37.7503730870817, -122.494626882044) | 1 | 8 | 3 | 29491 | 35 | |||
| 184795 | 29598 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 900X Junipero Serra Blvd | 7 | Median : Cutout | Tree | DPW 1 | 12/31/2014 08:52:00 AM | 3 | 5991178.77498 | 2091110.64652 | 37.7212844823864 | -122.472580013151 | (37.7212844823864, -122.472580013151) | 9 | 8 | 4 | 64 | 40 | |||
| 184789 | 21006 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 2003X Sunset Blvd | 18 | 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 | |||
| 184654 | 253327 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 2 Euclid Ave | 22 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5999085 | 2114289 | 37.7853810185166 | -122.446917590697 | (37.7853810185166, -122.446917590697) | 15 | 6 | 1 | 54 | 31 | |||||
| 184619 | 8473 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 1900 Geary Blvd | 10 | Median : Cutout | Tree | DPW 1 | 48 | 8 | 6001933.4192 | 2113657.2968 | 37.7838088404542 | -122.437017691332 | (37.7838088404542, -122.437017691332) | 13 | 5 | 11 | 29490 | 41 | |||
| 184584 | 218150 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 35 Ashton Ave | 3 | Back Yard : Yard | Tree | Private 2 | 8 | 5994126.47455 | 2090031.24651 | 37.7184908913149 | -122.46231247945 | (37.7184908913149, -122.46231247945) | 9 | 8 | 6 | 28861 | 24 |
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) );