trees
2,306 rows where qSpecies_id = 15 sorted by Fire Prevention Districts
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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2194 | 261477 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 1000 Portola Dr | 6 | Median : Yard | Tree | DPW 1 | 10x10 | 5995664 | 2098286 | 37.741244865522 | -122.457594860017 | (37.741244865522, -122.457594860017) | 1 | 8 | 4 | 59 | 40 | ||||
| 2352 | 101748 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 700X Panorama Dr | 1 | Back Yard : Yard | Tree | Private 2 | 5997177.2 | 2102739.1 | 37.7535587877907 | -122.452684092588 | (37.7535587877907, -122.452684092588) | 1 | 5 | 4 | 63 | 38 | |||||
| 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 | |||
| 2808 | 261474 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 1000 Portola Dr | 4 | Median : Yard | Tree | DPW 1 | 10x10 | 5995664 | 2098286 | 37.741244865522 | -122.457594860017 | (37.741244865522, -122.457594860017) | 1 | 8 | 4 | 59 | 40 | ||||
| 2845 | 21487 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 2792X Sunset Blvd | 10 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 60 | 5985060.3629888 | 2096294.4798015 | 37.7351618711636 | -122.49411119238 | (37.7351618711636, -122.49411119238) | 1 | 8 | 3 | 29491 | 35 | |||
| 2894 | 11190 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 140 Idora Ave | 1 | Median : Cutout | Tree | DPW 1 | 24 | 8 | 5995683.1150394 | 2099368.7198886 | 37.7442188444672 | -122.457607088025 | (37.7442188444672, -122.457607088025) | 1 | 8 | 4 | 59 | 40 | |||
| 3020 | 260513 | Property Tree 8 | Pinus radiata :: Monterey Pine 15 | 1990 41st Ave | 1 | Back Yard : Yard | Tree | Health Dept 13 | 10x10 | 5983703 | 2101544 | 37.7494961014415 | -122.499191781388 | (37.7494961014415, -122.499191781388) | 1 | 8 | 3 | 29491 | 35 | ||||
| 3149 | 21387 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 2601X Sunset Blvd | 11 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3 | 40 | 5985098.343425 | 2097506.3093477 | 37.7384914535226 | -122.494069167367 | (37.7384914535226, -122.494069167367) | 1 | 8 | 3 | 29491 | 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 | ||||
| 4239 | 258982 | Property Tree 8 | Pinus radiata :: Monterey Pine 15 | 239 Panorama Dr | 1 | Back Yard : Yard | Tree | Private 2 | 3x3 | 5997275 | 2101153 | 37.7492093542443 | -122.452231443092 | (37.7492093542443, -122.452231443092) | 1 | 5 | 4 | 63 | 38 | ||||
| 4407 | 185467 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 2400 Sunset Blvd | 19 | unknown : Yard | Tree | Private 2 | 3 | Width 0ft | 5985112.4406 | 2098402.8327 | 37.7409538906719 | -122.494086484448 | (37.7409538906719, -122.494086484448) | 1 | 8 | 3 | 29491 | 35 | |||
| 4876 | 211087 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 1840 Funston Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 56 | 5992084.81362 | 2102739.60541 | 37.7532670696221 | -122.47029454987 | (37.7532670696221, -122.47029454987) | 1 | 8 | 4 | 56 | 12 | ||||
| 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 | |||||
| 5205 | 261497 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 1200X Portola Dr | 4 | Median : Yard | Tree | Private 2 | 10x10 | 5994638 | 2097987 | 37.7403648954334 | -122.46112071093 | (37.7403648954334, -122.46112071093) | 1 | 8 | 4 | 59 | 40 | ||||
| 5279 | 258778 | Undocumented 4 | Pinus radiata :: Monterey Pine 15 | 701X Ortega Way | 1 | Unaccepted Street : Yard | Tree | Private 2 | 10x10 | 5991876 | 2102480 | 37.7525421857889 | -122.470997752755 | (37.7525421857889, -122.470997752755) | 1 | 8 | 4 | 29491 | 12 | ||||
| 5304 | 261473 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 1000 Portola Dr | 3 | Median : Yard | Tree | DPW 1 | 10x10 | 5995664 | 2098286 | 37.741244865522 | -122.457594860017 | (37.741244865522, -122.457594860017) | 1 | 8 | 4 | 59 | 40 | ||||
| 5459 | 20942 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 1992X Sunset Blvd | 20 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 42 | 60 | 5984875.9454268 | 2101638.8759791 | 37.7498253446275 | -122.495142757654 | (37.7498253446275, -122.495142757654) | 1 | 8 | 3 | 29491 | 35 | |||
| 6296 | 260461 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 99X Lopez Ave | 4 | Front Yard : Yard | Tree | Private 2 | 10x10 | Permit Number 784513 | 5994049 | 2100330 | 37.746764271907 | -122.463327202712 | (37.746764271907, -122.463327202712) | 1 | 8 | 4 | 29491 | 40 | |||
| 6400 | 181372 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 1500 Sunset Blvd | 5 | Sidewalk: Property side : Yard | Tree | Private 2 | 8 | Width 0ft | 5984899.4843 | 2104416.3495 | 37.757452898982 | -122.495266162351 | (37.757452898982, -122.495266162351) | 1 | 8 | 3 | 56 | 35 | |||
| 6519 | 251515 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 99x Mountview Ct | 1 | Back Yard : Yard | Tree | Private 2 | 3x3 | 5997620 | 2100449 | 37.7472961010623 | -122.450987675073 | (37.7472961010623, -122.450987675073) | 1 | 5 | 4 | 63 | 38 | ||||
| 6524 | 184984 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 2701 Sunset Blvd | 10 | Sidewalk: Property side : Yard | Tree | Private 2 | 42 | Width 0ft | 5984993.7475 | 2096669.1749 | 37.736186785639 | -122.494369113809 | (37.736186785639, -122.494369113809) | 1 | 8 | 3 | 29491 | 35 | |||
| 6814 | 259576 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 300 Public Park | 2 | Unaccepted Street : Cutout | Tree | Private 2 | 4x4 | 5994278 | 2098760 | 37.7424666368704 | -122.462421492412 | (37.7424666368704, -122.462421492412) | 1 | 8 | 4 | 59 | 40 | ||||
| 6923 | 186737 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 1200 Sunset Blvd | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 10 | Width 0ft | 5984866.449 | 2106593.1371 | 37.7634278157856 | -122.495540957795 | (37.7634278157856, -122.495540957795) | 1 | 8 | 3 | 56 | 35 | |||
| 6936 | 261840 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 1100X Portola Dr | 10 | Sidewalk: Property side : Yard | Tree | DPW 1 | 10x10 | 5995262 | 2098056 | 37.7405902419398 | -122.458968175006 | (37.7405902419398, -122.458968175006) | 1 | 7 | 4 | 59 | 40 | ||||
| 7152 | 261481 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 1000 Portola Dr | 10 | Median : Yard | Tree | DPW 1 | 10x10 | 5995664 | 2098286 | 37.741244865522 | -122.457594860017 | (37.741244865522, -122.457594860017) | 1 | 8 | 4 | 59 | 40 | ||||
| 8368 | 173917 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 2160X 09th Ave | 5 | Median : Cutout | Tree | DPW 1 | 6x10 | 5993671 | 2100995 | 37.7485684085064 | -122.464682560698 | (37.7485684085064, -122.464682560698) | 1 | 8 | 4 | 29491 | 40 | ||||
| 8603 | 185680 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 2101 Sunset Blvd | 12 | Sidewalk: Property side : Yard | Tree | Private 2 | 08/21/2020 12:00:00 AM | 3 | Width 0ft | Permit Number 785560 | 5984864.6841 | 2100703.8022 | 37.7472572283713 | -122.495112755215 | (37.7472572283713, -122.495112755215) | 1 | 8 | 3 | 29491 | 35 | |
| 8774 | 186010 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 1900 Sunset Blvd | 5 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 0ft | 5985033.6672 | 2101672.0069 | 37.749925545641 | -122.494599798949 | (37.749925545641, -122.494599798949) | 1 | 8 | 3 | 29491 | 35 | |||
| 8847 | 110165 | Undocumented 4 | Pinus radiata :: Monterey Pine 15 | 129x GARCES DR | 1 | Front Yard : Yard | Tree | Private 2 | 23 | 5989202 | 2088902 | 37.7151054701837 | -122.479251597893 | (37.7151054701837, -122.479251597893) | 1 | 8 | 4 | 64 | 14 | ||||
| 9020 | 261496 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 1200X Portola Dr | 3 | Median : Yard | Tree | Private 2 | 10x10 | 5994638 | 2097987 | 37.7403648954334 | -122.46112071093 | (37.7403648954334, -122.46112071093) | 1 | 8 | 4 | 59 | 40 | ||||
| 9254 | 87113 | Permitted Site 7 | Pinus radiata :: Monterey Pine 15 | 470 West Portal Ave | 4 | unknown : Yard | Tree | Private 2 | 01/03/2008 12:00:00 AM | Permit Number 50062 | 5991694 | 2096460 | 37.7360022829337 | -122.471188578306 | (37.7360022829337, -122.471188578306) | 1 | 8 | 4 | 29491 | 40 | |||
| 9341 | 20735 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 1601X Sunset Blvd | 22 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3 | 60 | 5984865.3499442 | 2104298.7792234 | 37.7571280850658 | -122.495375540207 | (37.7571280850658, -122.495375540207) | 1 | 8 | 3 | 56 | 35 | |||
| 9482 | 185678 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 2101 Sunset Blvd | 10 | Sidewalk: Property side : Yard | Tree | Private 2 | 14 | Width 0ft | 5984885.606 | 2100736.1658 | 37.7473473148238 | -122.495042795968 | (37.7473473148238, -122.495042795968) | 1 | 8 | 3 | 29491 | 35 | |||
| 9667 | 20951 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 1992X Sunset Blvd | 28 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 48 | 60 | 5984875.9454268 | 2101638.8759791 | 37.7498253446275 | -122.495142757654 | (37.7498253446275, -122.495142757654) | 1 | 8 | 3 | 29491 | 35 | |||
| 9803 | 262258 | Undocumented 4 | Pinus radiata :: Monterey Pine 15 | 2 Everglade Dr | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 3x3 | 5986312 | 2095495 | 37.7330398702545 | -122.489725113139 | (37.7330398702545, -122.489725113139) | 1 | 8 | 4 | 64 | 35 | ||||
| 9819 | 261478 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 1000 Portola Dr | 7 | Median : Yard | Tree | DPW 1 | 10x10 | 5995664 | 2098286 | 37.741244865522 | -122.457594860017 | (37.741244865522, -122.457594860017) | 1 | 8 | 4 | 59 | 40 | ||||
| 10141 | 211242 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 50x Santa Rita Ave | 16 | Median : Cutout | Tree | DPW 1 | 16 | Width 5ft | 5993561.81952 | 2100384.28411 | 37.7468852429767 | -122.465015753384 | (37.7468852429767, -122.465015753384) | 1 | 8 | 4 | 29491 | 40 | |||
| 10159 | 262253 | Undocumented 4 | Pinus radiata :: Monterey Pine 15 | 4210 Ocean Ave | 6 | Sidewalk: Property side : Yard | Tree | Private 2 | 3x3 | 5986512 | 2095174 | 37.7321701636719 | -122.489010079787 | (37.7321701636719, -122.489010079787) | 1 | 8 | 4 | 64 | 35 | ||||
| 10322 | 181388 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 1500 Sunset Blvd | 21 | Sidewalk: Property side : Yard | Tree | Private 2 | 46 | Width 0ft | 5984923.155 | 2104529.1337 | 37.757763958937 | -122.495192617725 | (37.757763958937, -122.495192617725) | 1 | 8 | 3 | 56 | 35 | |||
| 10560 | 178279 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 900 Brotherhood Way | 6 | Front Yard : Yard | Tree | DPW 1 | 4 | Width 0ft | 5987917.15522 | 2088760.91322 | 37.7146433748779 | -122.483682180705 | (37.7146433748779, -122.483682180705) | 1 | 8 | 4 | 64 | 14 | |||
| 10790 | 261495 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 1200X Portola Dr | 2 | Median : Yard | Tree | Private 2 | 10x10 | 5994638 | 2097987 | 37.7403648954334 | -122.46112071093 | (37.7403648954334, -122.46112071093) | 1 | 8 | 4 | 59 | 40 | ||||
| 10808 | 262250 | Undocumented 4 | Pinus radiata :: Monterey Pine 15 | 4210 Ocean Ave | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 3x3 | 5986512 | 2095174 | 37.7321701636719 | -122.489010079787 | (37.7321701636719, -122.489010079787) | 1 | 8 | 4 | 64 | 35 | ||||
| 11223 | 211225 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 2270x 09th Ave | 2 | Median : Cutout | Tree | DPW 1 | 21 | Width 3ft | 5993181.98406 | 2100575.01172 | 37.7473870233022 | -122.466343037597 | (37.7473870233022, -122.466343037597) | 1 | 8 | 4 | 29491 | 40 | |||
| 11277 | 186143 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 1700 Sunset Blvd | 28 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | Width 0ft | 5984952.2085 | 2103240.0556 | 37.7542262082521 | -122.494997090381 | (37.7542262082521, -122.494997090381) | 1 | 8 | 3 | 56 | 35 | |||
| 11693 | 261491 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 1100X Portola Dr | 7 | Sidewalk: Property side : Yard | Tree | DPW 1 | 10x10 | 5995262 | 2098056 | 37.7405902419398 | -122.458968175006 | (37.7405902419398, -122.458968175006) | 1 | 7 | 4 | 59 | 40 | ||||
| 11791 | 20943 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 1992X Sunset Blvd | 19 | Median : Cutout | Tree | DPW 1 | 6 | 60 | 5984875.9454268 | 2101638.8759791 | 37.7498253446275 | -122.495142757654 | (37.7498253446275, -122.495142757654) | 1 | 8 | 3 | 29491 | 35 | |||
| 11834 | 261266 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 1100X Portola Dr | 6 | Sidewalk: Property side : Yard | Tree | DPW 1 | 10x10 | 5995262 | 2098056 | 37.7405902419398 | -122.458968175006 | (37.7405902419398, -122.458968175006) | 1 | 7 | 4 | 59 | 40 | ||||
| 11878 | 104919 | Undocumented 4 | Pinus radiata :: Monterey Pine 15 | 732 Gonzalez Dr | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 5990421 | 2090607 | 37.719857702396 | -122.475162650507 | (37.719857702396, -122.475162650507) | 1 | 8 | 4 | 64 | 40 | |||||
| 12163 | 21077 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 2192X Sunset Blvd | 13 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 42 | 60 | 5984923.321673 | 2100279.0596028 | 37.7460944336033 | -122.494878681905 | (37.7460944336033, -122.494878681905) | 1 | 8 | 3 | 29491 | 35 | |||
| 12253 | 261479 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 1000 Portola Dr | 8 | Median : Yard | Tree | DPW 1 | 10x10 | 5995664 | 2098286 | 37.741244865522 | -122.457594860017 | (37.741244865522, -122.457594860017) | 1 | 8 | 4 | 59 | 40 | ||||
| 12406 | 211138 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 368 Pacheco St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 29 | Width 3ft | 5994210.82415 | 2101290.38351 | 37.7494105635678 | -122.462837296827 | (37.7494105635678, -122.462837296827) | 1 | 8 | 4 | 29491 | 40 | |||
| 12948 | 258070 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 1X Selma Way | 1 | Unaccepted Street : Yard | Tree | Private 2 | 6x10 | 5992537 | 2103375 | 37.7550378314458 | -122.468777042949 | (37.7550378314458, -122.468777042949) | 1 | 8 | 4 | 56 | 12 | ||||
| 12954 | 20695 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 1592X Sunset Blvd | 10 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 42 | 60 | 5984826.8631 | 2104357.0018991 | 37.7572856948155 | -122.49551293462 | (37.7572856948155, -122.49551293462) | 1 | 8 | 3 | 56 | 35 | |||
| 13075 | 261490 | Property Tree 8 | Pinus radiata :: Monterey Pine 15 | 1100X Portola Dr | 4 | Median : Yard | Tree | DPW 1 | 10x10 | 5995262 | 2098056 | 37.7405902419398 | -122.458968175006 | (37.7405902419398, -122.458968175006) | 1 | 7 | 4 | 59 | 40 | ||||
| 13420 | 218401 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 245 Castenada Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 32 | Width 0ft | 5994208.04109 | 2100328.08678 | 37.7467681800257 | -122.462777119594 | (37.7467681800257, -122.462777119594) | 1 | 8 | 4 | 29491 | 40 | |||
| 13422 | 261500 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 1200X Portola Dr | 7 | Median : Yard | Tree | Private 2 | 10x10 | 5994638 | 2097987 | 37.7403648954334 | -122.46112071093 | (37.7403648954334, -122.46112071093) | 1 | 8 | 4 | 59 | 40 | ||||
| 13472 | 259334 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 179X Midcrest Way | 1 | Front Yard : Yard | Tree | DPW 1 | 30x30 | 5998457 | 2101296 | 37.7496696385244 | -122.448154381331 | (37.7496696385244, -122.448154381331) | 1 | 5 | 4 | 63 | 38 | ||||
| 13538 | 178318 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 0 Serrano Dr | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 32 | 5988183.85887 | 2090397.25913 | 37.7191518903345 | -122.482880208457 | (37.7191518903345, -122.482880208457) | 1 | 8 | 4 | 64 | 14 | ||||
| 13614 | 258670 | Property Tree 8 | Pinus radiata :: Monterey Pine 15 | 152 Kensington Way | Front Yard : Yard | Tree | Private 2 | 3x3 | 5994743 | 2098651 | 37.7421941161526 | -122.460805774677 | (37.7421941161526, -122.460805774677) | 1 | 8 | 4 | 59 | 40 | |||||
| 13650 | 113526 | Undocumented 4 | Pinus radiata :: Monterey Pine 15 | 16x SHELDON TER | 1 | Back Yard : Cutout | Tree | Private 2 | 30 | 3x3 | 5991843 | 2103332 | 37.7548796468533 | -122.471173938858 | (37.7548796468533, -122.471173938858) | 1 | 8 | 4 | 56 | 12 | |||
| 13664 | 21451 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 2701X Sunset Blvd | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 48 | 40 | 5985119.0068215 | 2096832.7848434 | 37.7366433445438 | -122.493948101207 | (37.7366433445438, -122.493948101207) | 1 | 8 | 3 | 29491 | 35 | |||
| 13721 | 261493 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 1100X Portola Dr | 9 | Sidewalk: Property side : Yard | Tree | DPW 1 | 10x10 | 5995262 | 2098056 | 37.7405902419398 | -122.458968175006 | (37.7405902419398, -122.458968175006) | 1 | 7 | 4 | 59 | 40 | ||||
| 14228 | 211132 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 335x Pacheco St | 39 | Median : Yard | Tree | DPW 1 | 13 | Width 8ft | 5994073.5471 | 2101557.93366 | 37.750137280527 | -122.463331413139 | (37.750137280527, -122.463331413139) | 1 | 8 | 4 | 29491 | 40 | |||
| 14265 | 20575 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 1392X Sunset Blvd | 14 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 42 | 60 | 5984737.8310876 | 2105717.624989 | 37.7610163726955 | -122.49592120853 | (37.7610163726955, -122.49592120853) | 1 | 8 | 3 | 56 | 35 | |||
| 14470 | 261472 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 1000 Portola Dr | 1 | Median : Yard | Tree | DPW 1 | 10x10 | 5995664 | 2098286 | 37.741244865522 | -122.457594860017 | (37.741244865522, -122.457594860017) | 1 | 8 | 4 | 59 | 40 | ||||
| 14751 | 261503 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 1200X Portola Dr | 10 | Median : Yard | Tree | Private 2 | 10x10 | 5994638 | 2097987 | 37.7403648954334 | -122.46112071093 | (37.7403648954334, -122.46112071093) | 1 | 8 | 4 | 59 | 40 | ||||
| 14911 | 264785 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 1738 14th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10x10 | 5991929 | 2103547 | 37.7554749546691 | -122.470892190435 | (37.7554749546691, -122.470892190435) | 1 | 8 | 4 | 56 | 12 | ||||
| 15325 | 261502 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 1200X Portola Dr | 9 | Median : Yard | Tree | Private 2 | 10x10 | 5994638 | 2097987 | 37.7403648954334 | -122.46112071093 | (37.7403648954334, -122.46112071093) | 1 | 8 | 4 | 59 | 40 | ||||
| 15529 | 261501 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 1200X Portola Dr | 8 | Median : Yard | Tree | Private 2 | 10x10 | 5994638 | 2097987 | 37.7403648954334 | -122.46112071093 | (37.7403648954334, -122.46112071093) | 1 | 8 | 4 | 59 | 40 | ||||
| 15601 | 99374 | Property Tree 8 | Pinus radiata :: Monterey Pine 15 | 21 Panorama Dr | Back Yard : Yard | Tree | Private 2 | 24 | 5998009 | 2100230 | 37.7467170430405 | -122.449626769288 | (37.7467170430405, -122.449626769288) | 1 | 5 | 4 | 63 | 38 | |||||
| 15644 | 187078 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 2600 Sunset Blvd | 14 | Sidewalk: Property side : Yard | Tree | Private 2 | 31 | Width 0ft | 5985145.5887 | 2096954.5889 | 37.7369793412122 | -122.493865171075 | (37.7369793412122, -122.493865171075) | 1 | 8 | 3 | 29491 | 35 | |||
| 15991 | 262259 | Undocumented 4 | Pinus radiata :: Monterey Pine 15 | 2 Everglade Dr | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 3x3 | 5986312 | 2095495 | 37.7330398702545 | -122.489725113139 | (37.7330398702545, -122.489725113139) | 1 | 8 | 4 | 64 | 35 | ||||
| 16100 | 261494 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 1200X Portola Dr | 1 | Median : Yard | Tree | Private 2 | 10x10 | 5994638 | 2097987 | 37.7403648954334 | -122.46112071093 | (37.7403648954334, -122.46112071093) | 1 | 8 | 4 | 59 | 40 | ||||
| 16627 | 261498 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 1200X Portola Dr | 5 | Median : Yard | Tree | Private 2 | 10x10 | 5994638 | 2097987 | 37.7403648954334 | -122.46112071093 | (37.7403648954334, -122.46112071093) | 1 | 8 | 4 | 59 | 40 | ||||
| 16700 | 262531 | Undocumented 4 | Pinus radiata :: Monterey Pine 15 | 23X Knollview Way | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 10x10 | 5997470 | 2101306 | 37.7496406233362 | -122.451568168016 | (37.7496406233362, -122.451568168016) | 1 | 5 | 4 | 63 | 38 | ||||
| 17040 | 21086 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 2192X Sunset Blvd | 22 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 60 | 5984923.321673 | 2100279.0596028 | 37.7460944336033 | -122.494878681905 | (37.7460944336033, -122.494878681905) | 1 | 8 | 3 | 29491 | 35 | |||
| 17052 | 261499 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 1200X Portola Dr | 6 | Median : Yard | Tree | Private 2 | 10x10 | 5994638 | 2097987 | 37.7403648954334 | -122.46112071093 | (37.7403648954334, -122.46112071093) | 1 | 8 | 4 | 59 | 40 | ||||
| 17132 | 20690 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 1592X Sunset Blvd | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 60 | 5984826.8631 | 2104357.0018991 | 37.7572856948155 | -122.49551293462 | (37.7572856948155, -122.49551293462) | 1 | 8 | 3 | 56 | 35 | |||
| 18587 | 178281 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 900 Brotherhood Way | 8 | : | Tree | Private 2 | 23 | Width 0ft | 5988022.78245 | 2088756.97622 | 37.7146387127707 | -122.483316805926 | (37.7146387127707, -122.483316805926) | 1 | 8 | 4 | 64 | 14 | |||
| 18723 | 95885 | Permitted Site 7 | Pinus radiata :: Monterey Pine 15 | 1501@Ocean Sloat Blvd | 16 | Sidewalk: Property side : Yard | Tree | Private 2 | 03/16/2011 12:00:00 AM | 12 | Permit Number 767134 | 5986536.9 | 2095861.8 | 37.7340601352242 | -122.488974540344 | (37.7340601352242, -122.488974540344) | 1 | 8 | 4 | 64 | 35 | ||
| 18799 | 20738 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 1601X Sunset Blvd | 25 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3 | 60 | 5984865.3499442 | 2104298.7792234 | 37.7571280850658 | -122.495375540207 | (37.7571280850658, -122.495375540207) | 1 | 8 | 3 | 56 | 35 | |||
| 18809 | 218136 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 0 Noriega St | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 8 | Width 0ft | 5992370.84065 | 2103479.76822 | 37.7553158970187 | -122.469359289996 | (37.7553158970187, -122.469359289996) | 1 | 8 | 4 | 56 | 12 | |||
| 18993 | 186454 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 1601 Sunset Blvd | 42 | Sidewalk: Property side : Yard | Tree | Private 2 | 22 | Width 0ft | 5984732.5685 | 2103876.5622 | 37.7559610188182 | -122.495803598204 | (37.7559610188182, -122.495803598204) | 1 | 8 | 3 | 56 | 35 | |||
| 19001 | 186308 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 1800 Sunset Blvd | 46 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | Width 0ft | 5984992.9477 | 2102764.6568 | 37.7529232789638 | -122.494821157523 | (37.7529232789638, -122.494821157523) | 1 | 8 | 3 | 56 | 35 | |||
| 19246 | 253252 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 99X Lopez Ave | 3 | Front Yard : Yard | Tree | Private 2 | 10x10 | Permit Number 784513 | 5994049 | 2100330 | 37.746764271907 | -122.463327202712 | (37.746764271907, -122.463327202712) | 1 | 8 | 4 | 29491 | 40 | |||
| 19249 | 185216 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 2500 Sunset Blvd | 72 | Sidewalk: Property side : Yard | Tree | Private 2 | 28 | Width 0ft | 5985145.9746 | 2098128.2524 | 37.7402019291808 | -122.49395030702 | (37.7402019291808, -122.49395030702) | 1 | 8 | 3 | 29491 | 35 | |||
| 19504 | 21311 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 2501X Sunset Blvd | 11 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 60 | 5985074.8907349 | 2098188.1189419 | 37.740362147215 | -122.494200494189 | (37.740362147215, -122.494200494189) | 1 | 8 | 3 | 29491 | 35 | |||
| 19601 | 95883 | Permitted Site 7 | Pinus radiata :: Monterey Pine 15 | 1501@Everglade Sloat Blvd | 14 | Sidewalk: Property side : Yard | Tree | Private 2 | 03/16/2011 12:00:00 AM | 12 | Permit Number 767134 | 5986536.9 | 2095861.8 | 37.7340601352242 | -122.488974540344 | (37.7340601352242, -122.488974540344) | 1 | 8 | 4 | 64 | 35 | ||
| 19616 | 262407 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 300 Font Blvd | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 6x5 | 5990018 | 2089729 | 37.7174235665943 | -122.476491559856 | (37.7174235665943, -122.476491559856) | 1 | 8 | 4 | 64 | 14 | ||||
| 19737 | 20658 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 1501X Sunset Blvd | 12 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3 | 60 | 5984817.9532367 | 2104951.7766639 | 37.7589182591611 | -122.495587616201 | (37.7589182591611, -122.495587616201) | 1 | 8 | 3 | 56 | 35 | |||
| 19844 | 254259 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 45X Everglade Dr | 6 | Sidewalk: Property side : Yard | Tree | Private 2 | 3x3 | 5986312 | 2095495 | 37.7330398702545 | -122.489725113139 | (37.7330398702545, -122.489725113139) | 1 | 8 | 4 | 64 | 35 | ||||
| 20123 | 20914 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 1901X Sunset Blvd | 23 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3 | 60 | 5984934.4009631 | 2102260.4913733 | 37.7515355521167 | -122.494986448304 | (37.7515355521167, -122.494986448304) | 1 | 8 | 3 | 29491 | 35 | |||
| 20180 | 99132 | Undocumented 4 | Pinus radiata :: Monterey Pine 15 | 302X Pacheco St | 15 | Median : Cutout | Tree | Private 2 | 3 | 5994341.5 | 2100725.2 | 37.7478662384021 | -122.46234443277 | (37.7478662384021, -122.46234443277) | 1 | 8 | 4 | 29491 | 40 | ||||
| 20737 | 114465 | Undocumented 4 | Pinus radiata :: Monterey Pine 15 | 404 Noriega St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 5992802 | 2103239 | 37.754679716601 | -122.467850713731 | (37.754679716601, -122.467850713731) | 1 | 8 | 4 | 56 | 12 | |||||
| 20899 | 181456 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 1400 Sunset Blvd | 16 | Sidewalk: Property side : Yard | Tree | Private 2 | 15 | Width 0ft | 5984861.653 | 2105125.2912 | 37.7593972406183 | -122.495449281385 | (37.7593972406183, -122.495449281385) | 1 | 8 | 3 | 56 | 35 | |||
| 20972 | 254094 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 320 Magellan Ave | 1 | Front Yard : Yard | Tree | Private 2 | 10x10 | Permit Number 781012 | 5994209 | 2099943 | 37.7457108840866 | -122.462745872627 | (37.7457108840866, -122.462745872627) | 1 | 8 | 4 | 29491 | 40 | |||
| 21491 | 181458 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 1400 Sunset Blvd | 18 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | Width 0ft | 5984873.9061 | 2105124.1773 | 37.7593948996194 | -122.495406822643 | (37.7593948996194, -122.495406822643) | 1 | 8 | 3 | 56 | 35 | |||
| 21590 | 187369 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 2200 Sunset Blvd | 54 | Sidewalk: Property side : Yard | Tree | Private 2 | 10 | Width 0ft | 5985075.63 | 2099887.979 | 37.7450295470012 | -122.494323205168 | (37.7450295470012, -122.494323205168) | 1 | 8 | 3 | 29491 | 35 | |||
| 21774 | 2295 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 800X Brotherhood Way | 10 | Median : Cutout | Tree | DPW 1 | 45 | 14M | 5990276.2096462 | 2088591.5343604 | 37.7143153385926 | -122.475516051132 | (37.7143153385926, -122.475516051132) | 1 | 8 | 4 | 64 | 14 | |||
| 21921 | 185481 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 2400 Sunset Blvd | 34 | unknown : Yard | Tree | Private 2 | 26 | Width 0ft | 5985135.018 | 2098495.7982 | 37.7412104699771 | -122.494015271118 | (37.7412104699771, -122.494015271118) | 1 | 8 | 3 | 29491 | 35 |
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) );