trees
163,064 rows where qCaretaker_id = 2 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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 148 | 108238 | Undocumented 4 | Tree(s) :: 17 | 764x JUNIPERO SERRA BLVD | 1 | Median : Yard | Tree | Private 2 | 5991289.6 | 2092496.8 | 37.7250969308873 | -122.472297921456 | (37.7250969308873, -122.472297921456) | 9 | 8 | 4 | 64 | 40 | |||||
| 197 | 104920 | Undocumented 4 | Washingtonia robusta :: Mexican Fan Palm 72 | 750 Gonzalez Dr | 1 | Median : Yard | Tree | Private 2 | 5990385 | 2090588 | 37.7198034465129 | -122.47528570222 | (37.7198034465129, -122.47528570222) | 1 | 8 | 4 | 64 | 14 | |||||
| 226 | 56655 | Permitted Site 7 | Tree(s) :: 17 | 491 Bright St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5993749.22353597 | 2090472.28724098 | 37.7196801529508 | -122.463648462413 | (37.7196801529508, -122.463648462413) | 9 | 8 | 6 | 64 | 24 | |||||
| 228 | 256437 | Undocumented 4 | Pinus radiata :: Monterey Pine 15 | 3001 Sunset Blvd | 25 | Median : Yard | Tree | Private 2 | 10x10 | 5984960 | 2094729 | 37.7308576064943 | -122.49434282122 | (37.7308576064943, -122.49434282122) | 1 | 8 | 4 | 64 | 35 | ||||
| 230 | 114428 | Undocumented 4 | Pinus radiata :: Monterey Pine 15 | 34x HIGUERA AVE | 2 | Median : Yard | Tree | Private 2 | 56 | 5987903 | 2090420 | 37.7191979850677 | -122.483852684784 | (37.7191979850677, -122.483852684784) | 1 | 8 | 4 | 64 | 14 | ||||
| 252 | 204152 | DPW Maintained 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 900 Junipero Serra Blvd | 37 | : | Tree | Private 2 | 1 | Width 0ft | 5991169.92245 | 2090751.38969 | 37.7202975393725 | -122.472584434247 | (37.7202975393725, -122.472584434247) | 9 | 8 | 4 | 64 | 40 | |||
| 256 | 254254 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 45X Everglade Dr | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 3x3 | 5986312 | 2095495 | 37.7330398702545 | -122.489725113139 | (37.7330398702545, -122.489725113139) | 1 | 8 | 4 | 64 | 35 | ||||
| 267 | 178174 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 0 Gonzalez Dr | 5 | Sidewalk: Curb side : Yard | Tree | Private 2 | 2 | 5988358.3694 | 2089791.63303 | 37.717499145949 | -122.482232652541 | (37.717499145949, -122.482232652541) | 1 | 8 | 4 | 64 | 14 | ||||
| 291 | 210733 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 239 Ramsell St | 1 | : | Tree | Private 2 | 7 | Width 3ft | 5992956.15258 | 2088805.34296 | 37.7150573966491 | -122.466268722147 | (37.7150573966491, -122.466268722147) | 9 | 8 | 6 | 64 | 24 | |||
| 294 | 53493 | Permitted Site 7 | Tree(s) :: 17 | 262 Ralston St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/04/1969 12:00:00 AM | Permit Number 6403 | 5992228.28376051 | 2089608.56362168 | 37.717220822263 | -122.468842940668 | (37.717220822263, -122.468842940668) | 9 | 8 | 6 | 64 | 24 | |||
| 310 | 218546 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 25 Elmhurst Dr | 5 | : | Tree | Private 2 | 7 | Width 3ft | 5991216.07157 | 2094485.7269 | 37.730553771324 | -122.472697049151 | (37.730553771324, -122.472697049151) | 9 | 8 | 4 | 64 | 40 | |||
| 440 | 204255 | DPW Maintained 1 | Arbutus unedo :: Strawberry Tree 106 | 40 Rossmoor Dr | 1 | : | Tree | Private 2 | 2 | Width 3ft | 5991076.25798 | 2094451.16026 | 37.7304507656815 | -122.473177880653 | (37.7304507656815, -122.473177880653) | 9 | 8 | 4 | 64 | 40 | |||
| 450 | 178165 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 10 Brotherhood Way | 20 | Median : Cutout | Tree | Private 2 | 5 | Width 0ft | 5992928.58802 | 2087852.90738 | 37.7124406464989 | -122.466294818667 | (37.7124406464989, -122.466294818667) | 9 | 8 | 4 | 64 | 24 | |||
| 451 | 114938 | Undocumented 4 | Pinus radiata :: Monterey Pine 15 | 4400x OCEAN AVE | 14 | Front Yard : Cutout | Tree | Private 2 | 3x3 | 5985931 | 2095134 | 37.7320264068308 | -122.491015755892 | (37.7320264068308, -122.491015755892) | 1 | 8 | 4 | 64 | 35 | ||||
| 482 | 175383 | DPW Maintained 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 3001 Ocean Ave | 1 | : | Tree | Private 2 | 8 | Width 3ft | 5989487.94212 | 2095224.7734 | 37.7324828171076 | -122.478725410769 | (37.7324828171076, -122.478725410769) | 1 | 8 | 4 | 64 | 35 | |||
| 498 | 260403 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 500X Brotherhood Way | 1 | Median : Yard | Tree | Private 2 | 30x30 | 5992691 | 2087881 | 37.712504070633 | -122.467118029673 | (37.712504070633, -122.467118029673) | 9 | 8 | 6 | 64 | 24 | ||||
| 515 | 262251 | Undocumented 4 | Pinus radiata :: Monterey Pine 15 | 4210 Ocean Ave | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 3x3 | 5986512 | 2095174 | 37.7321701636719 | -122.489010079787 | (37.7321701636719, -122.489010079787) | 1 | 8 | 4 | 64 | 35 | ||||
| 591 | 264763 | Section 806 (d) 5 | Ginkgo biloba 'Autumn Gold' :: Ginkgo: Autumn Gold 3 | 274 Victoria St | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | 10/05/2020 12:00:00 AM | 3 | 3x3 | Permit Number 781692 | 5993256.27541 | 2089011.86791 | 37.7156417766237 | -122.465246370223 | (37.7156417766237, -122.465246370223) | 9 | 8 | 6 | 64 | 24 | |
| 686 | 254311 | DPW Maintained 1 | Eucalyptus globulus :: Blue Gum 56 | 190X Junipero Serra Blvd | 3 | Median : Yard | Tree | Private 2 | 10x10 | 5991377 | 2095081 | 37.732197556005 | -122.472184075725 | (37.732197556005, -122.472184075725) | 1 | 8 | 4 | 64 | 40 | ||||
| 724 | 178311 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 300 Serrano Dr | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 38 | 10x10 | 5989003 | 2090507 | 37.7195008394357 | -122.480056810171 | (37.7195008394357, -122.480056810171) | 1 | 8 | 4 | 64 | 14 | |||
| 748 | 259270 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 3580X 19th Ave | 8 | Sidewalk: Property side : Yard | Tree | Private 2 | 3x3 | Permit Number 784388 | 5990529 | 2092111 | 37.723993571379 | -122.474899060099 | (37.723993571379, -122.474899060099) | 9 | 8 | 4 | 64 | 14 | |||
| 832 | 211486 | DPW Maintained 1 | Pittosporum tenuifolium :: Tawhiwhi Pittosporum 143 | 300 Junipero Serra Blvd | 17 | : | Tree | Private 2 | 56 | Width 0ft | 5991389.83684 | 2094502.84602 | 37.7306108333036 | -122.47209757005 | (37.7306108333036, -122.47209757005) | 9 | 8 | 4 | 64 | 40 | |||
| 856 | 260411 | DPW Maintained 1 | Myoporum laetum :: Myoporum 62 | 10X Brotherhood Way | 2 | Side Yard : Yard | Tree | Private 2 | Width 0ft | 5992928.58802 | 2087852.90738 | 37.7124406464989 | -122.466294818667 | (37.7124406464989, -122.466294818667) | 9 | 8 | 4 | 64 | 24 | ||||
| 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 | ||||
| 966 | 251257 | DPW Maintained 1 | Phoenix dactylifera :: Date Palm 87 | 1748x Eucalyptus Dr | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 3x3 | 5986101 | 2094852 | 37.7312620395563 | -122.490407299046 | (37.7312620395563, -122.490407299046) | 1 | 8 | 4 | 64 | 35 | ||||
| 1021 | 213351 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 752 Head St | 1 | : | Tree | Private 2 | 3 | Width 3ft | 5993534.80603 | 2090819.23886 | 37.7206204409725 | -122.464414798499 | (37.7206204409725, -122.464414798499) | 9 | 8 | 6 | 64 | 24 | |||
| 1038 | 259268 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 3580X 19th Ave | 6 | Sidewalk: Property side : Yard | Tree | Private 2 | 3x3 | Permit Number 784388 | 5990529 | 2092111 | 37.723993571379 | -122.474899060099 | (37.723993571379, -122.474899060099) | 9 | 8 | 4 | 64 | 14 | |||
| 1059 | 262280 | Section 806 (d) 5 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 10 Niantic Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/25/2020 12:00:00 AM | 3 | 3x3 | Permit Number 784434 | 5992391 | 2086794 | 37.7095021076955 | -122.468075893068 | (37.7095021076955, -122.468075893068) | 9 | 8 | 4 | 64 | 24 | |
| 1236 | 78452 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 3075 23rd Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 4 | 5989337.22841 | 2094863.71499 | 37.7314826909771 | -122.479220054956 | (37.7314826909771, -122.479220054956) | 1 | 8 | 4 | 64 | 35 | |||
| 1257 | 260668 | Permitted Site 7 | Aesculus californica :: California Buckeye 168 | 9 Cardenas Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/03/2019 12:00:00 AM | 3 | 3x6 | 5989909.11704 | 2090923.47277 | 37.7206969761498 | -122.47695514418 | (37.7206969761498, -122.47695514418) | 1 | 8 | 4 | 64 | 14 | ||
| 1260 | 78418 | DPW Maintained 1 | Leptospermum scoparium :: New Zealand Tea Tree 157 | 2987 25th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 6 | 5988809.97189 | 2095328.51144 | 37.732728266388 | -122.481076880696 | (37.732728266388, -122.481076880696) | 1 | 8 | 4 | 64 | 35 | |||
| 1475 | 80073 | Significant Tree 6 | Prunus serrulata :: Ornamental Cherry 84 | 2788 34th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 3 | 5985889.2586 | 2096432.3825 | 37.735588983385 | -122.491255586179 | (37.735588983385, -122.491255586179) | 1 | 8 | 3 | 64 | 35 | |||
| 1512 | 177963 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 0 Grijalva Dr | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 14 | 5988967.05933 | 2088996.09626 | 37.7153501871281 | -122.480070526755 | (37.7153501871281, -122.480070526755) | 1 | 8 | 4 | 64 | 14 | ||||
| 1560 | 258220 | Planning Code 138.1 required 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 477 Eucalyptus Dr | 2 | Sidewalk: Property side : Cutout | Tree | Private 2 | 07/03/2019 12:00:00 AM | 3 | 3x3 | Permit Number 774069 | 5989683 | 2094686 | 37.7310148065902 | -122.478011682019 | (37.7310148065902, -122.478011682019) | 1 | 8 | 4 | 64 | 14 | |
| 1588 | 260075 | Undocumented 4 | Pinus pinea :: Italian Stone Pine 63 | 171X Gellert Dr | 1 | Median : Yard | Tree | Private 2 | 3x3 | 5985371 | 2094678 | 37.7307416178434 | -122.492918192866 | (37.7307416178434, -122.492918192866) | 1 | 8 | 4 | 64 | 35 | ||||
| 1702 | 46741 | Permitted Site 7 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 21 Sargent St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/24/2002 12:00:00 AM | Permit Number 44848 | 5993934.28224784 | 2089153.42556477 | 37.7160695363268 | -122.462913152344 | (37.7160695363268, -122.462913152344) | 9 | 8 | 6 | 64 | 24 | ||
| 1812 | 52955 | Permitted Site 7 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 149 | 516 Victoria St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/03/2006 12:00:00 AM | Permit Number 48942 | 5993282.16384919 | 2090617.22186434 | 37.7200511847077 | -122.465273429637 | (37.7200511847077, -122.465273429637) | 9 | 8 | 6 | 64 | 24 | ||
| 1844 | 212645 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 385 Vernon St | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 6ft | 5992447.95571 | 2090426.49221 | 37.7194793442858 | -122.468143110712 | (37.7194793442858, -122.468143110712) | 9 | 8 | 6 | 64 | 24 | |||
| 1901 | 262254 | Significant Tree 6 | Pinus pinea :: Italian Stone Pine 63 | 4210 Ocean Ave | 7 | Sidewalk: Property side : Yard | Tree | Private 2 | 3x3 | Permit Number 785453 | 5986512 | 2095174 | 37.7321701636719 | -122.489010079787 | (37.7321701636719, -122.489010079787) | 1 | 8 | 4 | 64 | 35 | |||
| 1922 | 260512 | Undocumented 4 | Prunus cerasifera :: Cherry Plum 7 | 180 Stratford Dr | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | 3x3 | 5990850 | 2091280 | 37.7217304489912 | -122.473728831815 | (37.7217304489912, -122.473728831815) | 9 | 8 | 4 | 64 | 40 | ||||
| 1969 | 104927 | Undocumented 4 | Washingtonia robusta :: Mexican Fan Palm 72 | 810 Gonzalez Dr | 2 | Median : Yard | Tree | Private 2 | 10 | 5990385 | 2090588 | 37.7198034465129 | -122.47528570222 | (37.7198034465129, -122.47528570222) | 1 | 8 | 4 | 64 | 14 | ||||
| 2067 | 211204 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 700 Junipero Serra Blvd | 150 | : | Tree | Private 2 | 8 | Width 0ft | 5991184.95958 | 2091479.43645 | 37.7222974463483 | -122.472585508941 | (37.7222974463483, -122.472585508941) | 9 | 8 | 4 | 64 | 40 | |||
| 2070 | 213331 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 151 Byxbee St | 1 | : | Tree | Private 2 | 6 | Width 2ft | 5991924.78555 | 2089552.62516 | 37.7170496899626 | -122.469887910591 | (37.7170496899626, -122.469887910591) | 9 | 8 | 6 | 64 | 24 | |||
| 2174 | 173658 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 1200X JUNIPERO SERRA BLVD | 46 | Sidewalk: Property side : Yard | Tree | Private 2 | 01/20/2017 12:00:00 AM | 3 | 5991123 | 2089585 | 37.7170922039834 | -122.472661630304 | (37.7170922039834, -122.472661630304) | 1 | 8 | 4 | 64 | 14 | |||
| 2179 | 78458 | DPW Maintained 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 401 Sloat Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 9 | 5990186.88196 | 2095940.56831 | 37.7344887657249 | -122.476361303539 | (37.7344887657249, -122.476361303539) | 1 | 8 | 4 | 64 | 35 | |||
| 2183 | 117295 | Significant Tree 6 | Tree(s) :: 17 | 130 CAMBON DR | 1 | Side Yard : Yard | Tree | Private 2 | 3x3 | 5990450 | 2089482 | 37.7167704112637 | -122.474980331165 | (37.7167704112637, -122.474980331165) | 1 | 8 | 4 | 64 | 14 | ||||
| 2210 | 53264 | Permitted Site 7 | Tree(s) :: 17 | 523 Head St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/28/1969 12:00:00 AM | Permit Number 6154 | 5993474.77624345 | 2089341.33970508 | 37.7165590253308 | -122.464515046881 | (37.7165590253308, -122.464515046881) | 9 | 8 | 6 | 64 | 24 | |||
| 2230 | 256764 | Undocumented 4 | Tree(s) :: 17 | 25 Serrano Dr | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | 09/25/2019 12:00:00 AM | 3 | 6x6 | Permit Number 782398 | 5990027 | 2090605 | 37.7198293671123 | -122.476524410241 | (37.7198293671123, -122.476524410241) | 1 | 8 | 4 | 64 | 14 | |
| 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 | ||||
| 2263 | 31189 | Permitted Site 7 | :: 45 | 744 Shields St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/21/1995 12:00:00 AM | Permit Number 34885 | 5992088.16257343 | 2089881.74957895 | 37.7179628280945 | -122.469347142572 | (37.7179628280945, -122.469347142572) | 9 | 8 | 6 | 64 | 24 | ||
| 2361 | 256460 | Undocumented 4 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 2901 Sunset Blvd | 9 | Median : Yard | Tree | Private 2 | 3x3 | 5984945 | 2095183 | 37.7321032922905 | -122.494428131787 | (37.7321032922905, -122.494428131787) | 1 | 8 | 4 | 64 | 35 | ||||
| 2446 | 254284 | DPW Maintained 1 | Eucalyptus globulus :: Blue Gum 56 | 80X Junipero Serra Blvd | 8 | Median : Yard | Tree | Private 2 | 3x3 | 5991405 | 2095520 | 37.733404559811 | -122.472119261767 | (37.733404559811, -122.472119261767) | 1 | 8 | 4 | 64 | 40 | ||||
| 2512 | 99518 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 1501@Clearfield Sloat Blvd | 2 | Sidewalk: Property side : Cutout | Tree | Private 2 | 05/22/2012 12:00:00 AM | Permit Number 768821 | 5986536.9 | 2095861.8 | 37.7340601352242 | -122.488974540344 | (37.7340601352242, -122.488974540344) | 1 | 8 | 4 | 64 | 35 | |||
| 2591 | 92319 | Significant Tree 6 | Prunus serrulata :: Ornamental Cherry 84 | 2788 34th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 3 | 3x3 | 5985889.2586 | 2096423.8922 | 37.7355656712712 | -122.491254961509 | (37.7355656712712, -122.491254961509) | 1 | 8 | 3 | 64 | 35 | ||
| 2850 | 178600 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 200 Winston Dr | 6 | : | Tree | Private 2 | 6 | Width 0ft | 5989476.93903 | 2093627.59215 | 37.7280967254778 | -122.478646687712 | (37.7280967254778, -122.478646687712) | 1 | 8 | 4 | 64 | 14 | |||
| 2885 | 102680 | Permitted Site 7 | Pyrus calleryana :: Ornamental Pear 44 | 333 Eucalyptus Dr | 6 | Front Yard : Yard | Tree | Private 2 | 12/01/2006 12:00:00 AM | Permit Number 58781 | 5990098.7 | 2094672.6 | 37.731002133155 | -122.476573573496 | (37.731002133155, -122.476573573496) | 1 | 8 | 4 | 64 | 14 | |||
| 2919 | 208356 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 4998 19th Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 10 | Width 3ft | 5990631.22914 | 2093445.14336 | 37.7276627189546 | -122.474642998593 | (37.7276627189546, -122.474642998593) | 9 | 8 | 4 | 64 | 40 | |||
| 3015 | 217584 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 2 Randolph St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 6 | Width 0ft | 5993971.4029 | 2088542.2845 | 37.7143936266554 | -122.462740537778 | (37.7143936266554, -122.462740537778) | 9 | 8 | 6 | 64 | 24 | |||
| 3045 | 261353 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 160 Stratford Dr | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | 3x10 | 5990864 | 2091394 | 37.7220442755547 | -122.473688749933 | (37.7220442755547, -122.473688749933) | 9 | 8 | 4 | 64 | 40 | ||||
| 3112 | 44154 | Permitted Site 7 | Quercus agrifolia :: Coast Live Oak 172 | 67 Saint Charles Ave | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/08/2000 12:00:00 AM | Permit Number 43634 | 5992085.5284034 | 2088073.73243086 | 37.7129982990606 | -122.469224726443 | (37.7129982990606, -122.469224726443) | 9 | 8 | 6 | 64 | 24 | |||
| 3173 | 78509 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 750 Eucalyptus Dr | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 3 | 5988915.04586 | 2094775.69423 | 37.7312164799499 | -122.480673162464 | (37.7312164799499, -122.480673162464) | 1 | 8 | 4 | 64 | 35 | |||
| 3219 | 260405 | DPW Maintained 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 500X Brotherhood Way | 3 | Median : Yard | Tree | Private 2 | 30x30 | 5992691 | 2087881 | 37.712504070633 | -122.467118029673 | (37.712504070633, -122.467118029673) | 9 | 8 | 6 | 64 | 24 | ||||
| 3310 | 175373 | Undocumented 4 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 10 Junipero Serra Blvd | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 2 | Width 3ft | 5991419.90979 | 2088711.03664 | 37.714709696259 | -122.47157171488 | (37.714709696259, -122.47157171488) | 9 | 8 | 6 | 64 | 24 | |||
| 3330 | 213252 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 239 Byxbee St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 12 | Width 6ft | 5991927.67162 | 2090111.22138 | 37.7185836258199 | -122.4699185829 | (37.7185836258199, -122.4699185829) | 9 | 8 | 6 | 64 | 24 | |||
| 3631 | 260410 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 400X Brotherhood Way | 10 | Side Yard : Yard | Tree | Private 2 | 30x30 | 5993855 | 2087505 | 37.7115387848875 | -122.463067653224 | (37.7115387848875, -122.463067653224) | 9 | 8 | 6 | 64 | 24 | ||||
| 3723 | 260511 | Undocumented 4 | Prunus cerasifera :: Cherry Plum 7 | 199X Stratford Dr | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | 3x3 | 5990954 | 2091213 | 37.7215525064104 | -122.47336445039 | (37.7215525064104, -122.47336445039) | 9 | 8 | 4 | 64 | 40 | ||||
| 3768 | 262321 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 60 Stonecrest Dr | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | 3x3 | 5990975 | 2093805 | 37.7286707085155 | -122.473480827138 | (37.7286707085155, -122.473480827138) | 9 | 8 | 4 | 64 | 40 | ||||
| 3790 | 262255 | Undocumented 4 | Tree(s) :: 17 | 4210 Ocean Ave | 8 | Sidewalk: Property side : Yard | Tree | Private 2 | 11/10/2020 12:00:00 AM | 3 | 3x3 | Permit Number 785453 | 5986512 | 2095174 | 37.7321701636719 | -122.489010079787 | (37.7321701636719, -122.489010079787) | 1 | 8 | 4 | 64 | 35 | |
| 3807 | 204110 | DPW Maintained 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 500 Junipero Serra Blvd | 24 | : | Tree | Private 2 | 3 | Width 0ft | 5991353.72908 | 2093672.35856 | 37.7283284331018 | -122.472161885976 | (37.7283284331018, -122.472161885976) | 9 | 8 | 4 | 64 | 40 | |||
| 3811 | 32184 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 191 Lakeshore Dr | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/15/1995 12:00:00 AM | Permit Number 35516 | 5984219.12182319 | 2094256.3665376 | 37.7295164954065 | -122.49686924842 | (37.7295164954065, -122.49686924842) | 1 | 8 | 4 | 64 | 35 | ||
| 3872 | 262252 | Undocumented 4 | Pinus radiata :: Monterey Pine 15 | 4210 Ocean Ave | 5 | Sidewalk: Property side : Yard | Tree | Private 2 | 3x3 | 5986512 | 2095174 | 37.7321701636719 | -122.489010079787 | (37.7321701636719, -122.489010079787) | 1 | 8 | 4 | 64 | 35 | ||||
| 3880 | 262281 | Section 806 (d) 5 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 10 Niantic Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/25/2020 12:00:00 AM | 3 | 3x3 | Permit Number 784434 | 5992391 | 2086794 | 37.7095021076955 | -122.468075893068 | (37.7095021076955, -122.468075893068) | 9 | 8 | 4 | 64 | 24 | |
| 3999 | 213261 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 255 Ramsell St | 1 | : | Tree | Private 2 | 7 | Width 3ft | 5992959.15066 | 2088902.16567 | 37.7153234215169 | -122.466265391939 | (37.7153234215169, -122.466265391939) | 9 | 8 | 6 | 64 | 24 | |||
| 4049 | 185126 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 600 Sloat Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 0ft | 5989258.3218 | 2096043.9506 | 37.7347187320697 | -122.479579168443 | (37.7347187320697, -122.479579168443) | 1 | 8 | 3 | 64 | 35 | |||
| 4051 | 260659 | Permitted Site 7 | Pistacia chinensis :: Chinese Pistache 32 | 2 Varela Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/03/2019 12:00:00 AM | 3 | 3x6 | 5990178.30137 | 2091110.96603 | 37.7212273981358 | -122.476038353928 | (37.7212273981358, -122.476038353928) | 1 | 8 | 4 | 64 | 14 | ||
| 4100 | 204072 | DPW Maintained 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 216 Arch St | 1 | : | Tree | Private 2 | 04/14/2020 12:00:00 AM | 3 | Width 3ft | Permit Number 767875 | 5992726.82301 | 2088588.57169 | 37.7144489603362 | -122.467045625763 | (37.7144489603362, -122.467045625763) | 9 | 8 | 6 | 64 | 24 | |
| 4132 | 78489 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 3345 Ocean Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 5 | 5988664.39778 | 2095197.91873 | 37.7323612287764 | -122.481570599508 | (37.7323612287764, -122.481570599508) | 1 | 8 | 4 | 64 | 35 | |||
| 4140 | 260407 | DPW Maintained 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 500X Brotherhood Way | 5 | Median : Yard | Tree | Private 2 | 30x30 | 5992691 | 2087881 | 37.712504070633 | -122.467118029673 | (37.712504070633, -122.467118029673) | 9 | 8 | 6 | 64 | 24 | ||||
| 4197 | 262260 | Undocumented 4 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 2 Everglade Dr | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 3x3 | 5986312 | 2095495 | 37.7330398702545 | -122.489725113139 | (37.7330398702545, -122.489725113139) | 1 | 8 | 4 | 64 | 35 | ||||
| 4241 | 45501 | Permitted Site 7 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 3070 23rd Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/20/2001 12:00:00 AM | Permit Number 44273 | 5989380.64559271 | 2094892.34202186 | 37.7315638149816 | -122.479072048364 | (37.7315638149816, -122.479072048364) | 1 | 8 | 4 | 64 | 35 | ||
| 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 | ||||
| 4289 | 78450 | DPW Maintained 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 2930 21st Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10 | 5990007.36558 | 2095749.13449 | 37.7339527248253 | -122.476967960997 | (37.7339527248253, -122.476967960997) | 1 | 8 | 4 | 64 | 35 | |||
| 4333 | 260669 | Permitted Site 7 | Aesculus californica :: California Buckeye 168 | 9 Cardenas Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/03/2019 12:00:00 AM | 3 | 3x6 | 5989909.11704 | 2090923.47277 | 37.7206969761498 | -122.47695514418 | (37.7206969761498, -122.47695514418) | 1 | 8 | 4 | 64 | 14 | ||
| 4346 | 32173 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 117 Lakeshore Dr | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/15/1995 12:00:00 AM | Permit Number 35511 | 5984955.52028324 | 2094294.56016286 | 37.7296644874619 | -122.494326297163 | (37.7296644874619, -122.494326297163) | 1 | 8 | 4 | 64 | 35 | ||
| 4542 | 31195 | DPW Maintained 1 | Leptospermum scoparium :: New Zealand Tea Tree 157 | 260 Saint Charles Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/22/1995 12:00:00 AM | 6 | Permit Number 34888 | 5992024.42182 | 2086737.21442 | 37.7093250109181 | -122.469338707216 | (37.7093250109181, -122.469338707216) | 9 | 8 | 4 | 64 | 24 | ||
| 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 | |||
| 4569 | 104897 | Undocumented 4 | Callistemon citrinus :: Lemon Bottlebrush 67 | 303 Gonzalez Dr | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 5990401 | 2090562 | 37.7197329843514 | -122.475228499286 | (37.7197329843514, -122.475228499286) | 1 | 8 | 4 | 64 | 14 | |||||
| 4676 | 204157 | DPW Maintained 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 900 Junipero Serra Blvd | 109 | : | Tree | Private 2 | 2 | Width 0ft | 5991141.76494 | 2090345.59901 | 37.7191817082419 | -122.472652193669 | (37.7191817082419, -122.472652193669) | 9 | 8 | 4 | 64 | 40 | |||
| 4684 | 219541 | DPW Maintained 1 | Ulmus americana :: American Elm 74 | 300 Junipero Serra Blvd | 20 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 0ft | 5991386.1412 | 2094492.53294 | 37.7305823023089 | -122.472109594875 | (37.7305823023089, -122.472109594875) | 9 | 8 | 4 | 64 | 40 | |||
| 4735 | 262469 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 35 Broadmoor Dr | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 2x6 | 5991096 | 2093545 | 37.7279638199594 | -122.4730435743 | (37.7279638199594, -122.4730435743) | 9 | 8 | 4 | 64 | 40 | ||||
| 4737 | 261021 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 3440X 19th Ave | 2 | Back Yard : Yard | Tree | Private 2 | 10x10 | Permit Number 784857 | 5990714 | 2092679 | 37.7255638768787 | -122.474300978757 | (37.7255638768787, -122.474300978757) | 9 | 8 | 4 | 64 | 40 | |||
| 4858 | 39677 | Permitted Site 7 | Quercus keloggii :: California Black Oak 282 | 446 Ramsell St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/29/1998 12:00:00 AM | Permit Number 41063 | 5993017.43068395 | 2090147.12878073 | 37.7187451525026 | -122.466154370624 | (37.7187451525026, -122.466154370624) | 9 | 8 | 6 | 64 | 24 | ||
| 4912 | 261377 | Planning Code 138.1 required 2 | Olea Majestic Beauty :: 183 | 3015 25th Ave | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 01/08/2020 12:00:00 AM | 3 | 4x10 | Permit Number 784883 | 5988814.87181 | 2095155.07295 | 37.7322523337557 | -122.481047245899 | (37.7322523337557, -122.481047245899) | 1 | 8 | 4 | 64 | 35 | |
| 4918 | 104883 | Undocumented 4 | Pinus radiata :: Monterey Pine 15 | 132 Gonzalez Dr | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 5990322.1 | 2090011.1 | 37.7182157760013 | -122.475461023549 | (37.7182157760013, -122.475461023549) | 1 | 8 | 4 | 64 | 14 | |||||
| 4970 | 43860 | DPW Maintained 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 500 Crestlake Dr | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/27/2000 12:00:00 AM | 2 | Permit Number 43480 | 5986156.5709 | 2096489.2942 | 37.7357608636081 | -122.490335583477 | (37.7357608636081, -122.490335583477) | 1 | 8 | 3 | 64 | 35 | |
| 5037 | 215607 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 900 Junipero Serra Blvd | 47 | : | Tree | Private 2 | 2 | Width 0ft | 5991157.54734 | 2090681.21679 | 37.7201041455671 | -122.472622096933 | (37.7201041455671, -122.472622096933) | 9 | 8 | 4 | 64 | 40 | |||
| 5273 | 218292 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 1 Woodacre Dr | 16 | Sidewalk: Curb side : Yard | Tree | Private 2 | 39 | 5991223.38049 | 2095418.74528 | 37.7331160279643 | -122.472739784911 | (37.7331160279643, -122.472739784911) | 1 | 8 | 4 | 64 | 40 | ||||
| 5288 | 260453 | Property Tree 8 | Myoporum laetum :: Myoporum 62 | 3554 Alemany Blvd | 4 | unknown : Yard | Tree | Private 2 | 3x3 | 5993855 | 2087505 | 37.7115387848875 | -122.463067653224 | (37.7115387848875, -122.463067653224) | 9 | 8 | 6 | 64 | 24 | ||||
| 5486 | 203905 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 5000 19th Ave | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 24 | Width 8ft | 5990628.48581 | 2093315.14661 | 37.7273056215527 | -122.474642998573 | (37.7273056215527, -122.474642998573) | 9 | 8 | 4 | 64 | 40 | |||
| 5714 | 259658 | Undocumented 4 | Prunus cerasifera :: Cherry Plum 7 | 239 Stonecrest Dr | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 3x3 | 5990787 | 2092898 | 37.7261694250404 | -122.474064598028 | (37.7261694250404, -122.474064598028) | 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) );