trees
155 rows where qSpecies_id = 109 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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1654 | 19584 | DPW Maintained 1 | Cedrus deodara :: Deodar Cedar 109 | 100 STAIRWAY4 | 7 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3 | 60 | |||||||||||||
| 1935 | 19720 | DPW Maintained 1 | Cedrus deodara :: Deodar Cedar 109 | 100 STAIRWAY13 | 18 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3 | 40ST | |||||||||||||
| 3100 | 19586 | DPW Maintained 1 | Cedrus deodara :: Deodar Cedar 109 | 100 STAIRWAY4 | 9 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3 | 60 | |||||||||||||
| 3296 | 19833 | DPW Maintained 1 | Cedrus deodara :: Deodar Cedar 109 | 100 STAIRWAY25 | 17 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 60X | |||||||||||||
| 5828 | 19721 | DPW Maintained 1 | Cedrus deodara :: Deodar Cedar 109 | 100 STAIRWAY13 | 19 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3 | 40ST | |||||||||||||
| 5903 | 19583 | DPW Maintained 1 | Cedrus deodara :: Deodar Cedar 109 | 100 STAIRWAY4 | 6 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 60 | |||||||||||||
| 6107 | 19832 | DPW Maintained 1 | Cedrus deodara :: Deodar Cedar 109 | 100 STAIRWAY25 | 16 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 60X | |||||||||||||
| 8596 | 19826 | DPW Maintained 1 | Cedrus deodara :: Deodar Cedar 109 | 100 STAIRWAY25 | 10 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 10ST | |||||||||||||
| 8827 | 19825 | DPW Maintained 1 | Cedrus deodara :: Deodar Cedar 109 | 100 STAIRWAY25 | 9 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 10ST | |||||||||||||
| 17811 | 185472 | DPW Maintained 1 | Cedrus deodara :: Deodar Cedar 109 | 2400 Sunset Blvd | 24 | unknown : Yard | Tree | Private 2 | 1 | Width 0ft | 5985147.6347 | 2098429.3943 | 37.7410288809669 | -122.493966755049 | (37.7410288809669, -122.493966755049) | 1 | 8 | 3 | 29491 | 35 | |||
| 27831 | 98834 | Significant Tree 6 | Cedrus deodara :: Deodar Cedar 109 | 333 Pacheco St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5994230.9 | 2100817.4 | 37.748113026994 | -122.462733567037 | (37.748113026994, -122.462733567037) | 1 | 8 | 4 | 29491 | 40 | |||||
| 27948 | 205967 | DPW Maintained 1 | Cedrus deodara :: Deodar Cedar 109 | 340 Rivera St | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | Width 3ft | 5992062.49278 | 2100502.89931 | 37.7471243628055 | -122.470208875054 | (37.7471243628055, -122.470208875054) | 1 | 8 | 4 | 29491 | 40 | |||
| 30134 | 101033 | DPW Maintained 1 | Cedrus deodara :: Deodar Cedar 109 | 1010X Portola Dr | 7 | Front Yard : Yard | Tree | DPW 1 | 5995923.3 | 2098391.5 | 37.7415494342357 | -122.45670592621 | (37.7415494342357, -122.45670592621) | 1 | 7 | 4 | 59 | 40 | |||||
| 37591 | 187040 | DPW Maintained 1 | Cedrus deodara :: Deodar Cedar 109 | 2501 Sunset Blvd | 59 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 0ft | 5984973.3237 | 2097770.8307 | 37.7392104419663 | -122.49452091353 | (37.7392104419663, -122.49452091353) | 1 | 8 | 3 | 29491 | 35 | |||
| 42569 | 186969 | DPW Maintained 1 | Cedrus deodara :: Deodar Cedar 109 | 2550x Yorba St | 1 | Median : Cutout | Tree | DPW 1 | 1 | Width 0ft | 5985198.4325 | 2096209.9829 | 37.7349379433341 | -122.493627618821 | (37.7349379433341, -122.493627618821) | 1 | 8 | 3 | 29491 | 35 | |||
| 45148 | 181856 | DPW Maintained 1 | Cedrus deodara :: Deodar Cedar 109 | 2321 30th Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 9 | Width 0ft | 5986994.4655 | 2099435.9665 | 37.7439005468649 | -122.48765510164 | (37.7439005468649, -122.48765510164) | 1 | 8 | 3 | 29491 | 35 | |||
| 46378 | 185499 | DPW Maintained 1 | Cedrus deodara :: Deodar Cedar 109 | 2400 Sunset Blvd | 53 | unknown : Yard | Tree | Private 2 | 1 | Width 0ft | 5985130.3697 | 2098685.0494 | 37.741729830799 | -122.494045287668 | (37.741729830799, -122.494045287668) | 1 | 8 | 3 | 29491 | 35 | |||
| 47970 | 185575 | DPW Maintained 1 | Cedrus deodara :: Deodar Cedar 109 | 2201 Sunset Blvd | 59 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 0ft | 5984929.5876 | 2099652.8652 | 37.744375440677 | -122.494810854753 | (37.744375440677, -122.494810854753) | 1 | 8 | 3 | 29491 | 35 | |||
| 49113 | 186347 | DPW Maintained 1 | Cedrus deodara :: Deodar Cedar 109 | 1801 Sunset Blvd | 14 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 0ft | 5984771.9036 | 2102744.0011 | 37.7528536226758 | -122.495584034876 | (37.7528536226758, -122.495584034876) | 1 | 8 | 3 | 56 | 35 | |||
| 54286 | 181536 | DPW Maintained 1 | Cedrus deodara :: Deodar Cedar 109 | 1300 Sunset Blvd | 14 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 0ft | 5984851.3492 | 2105801.1612 | 37.7612523876307 | -122.495534766047 | (37.7612523876307, -122.495534766047) | 1 | 8 | 3 | 56 | 35 | |||
| 57971 | 185943 | DPW Maintained 1 | Cedrus deodara :: Deodar Cedar 109 | 2001 Sunset Blvd | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 0ft | 5984815.4773 | 2101526.8869 | 37.7495143130094 | -122.49534359797 | (37.7495143130094, -122.49534359797) | 1 | 8 | 3 | 29491 | 35 | |||
| 58916 | 205964 | DPW Maintained 1 | Cedrus deodara :: Deodar Cedar 109 | 340 Rivera St | 6 | Sidewalk: Property side : Yard | Tree | Private 2 | 11 | Width 3ft | 5992030.75114 | 2100502.15338 | 37.7471204795254 | -122.470318579738 | (37.7471204795254, -122.470318579738) | 1 | 8 | 4 | 29491 | 40 | |||
| 60236 | 187049 | DPW Maintained 1 | Cedrus deodara :: Deodar Cedar 109 | 2501 Sunset Blvd | 68 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 0ft | 5984997.5359 | 2097656.4952 | 37.738897924427 | -122.494428773867 | (37.738897924427, -122.494428773867) | 1 | 8 | 3 | 29491 | 35 | |||
| 67929 | 181368 | DPW Maintained 1 | Cedrus deodara :: Deodar Cedar 109 | 1500 Sunset Blvd | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 2 | Width 0ft | 5984948.7535 | 2104361.5119 | 37.7573052146707 | -122.4950917287 | (37.7573052146707, -122.4950917287) | 1 | 8 | 3 | 56 | 35 | |||
| 71413 | 181375 | DPW Maintained 1 | Cedrus deodara :: Deodar Cedar 109 | 1500 Sunset Blvd | 8 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 0ft | 5984932.3448 | 2104426.3747 | 37.7574823492807 | -122.495153258567 | (37.7574823492807, -122.495153258567) | 1 | 8 | 3 | 56 | 35 | |||
| 73741 | 185501 | DPW Maintained 1 | Cedrus deodara :: Deodar Cedar 109 | 2400 Sunset Blvd | 55 | unknown : Yard | Tree | Private 2 | 2 | Width 0ft | 5985131.6978 | 2098729.54 | 37.7418520677037 | -122.494043973834 | (37.7418520677037, -122.494043973834) | 1 | 8 | 3 | 29491 | 35 | |||
| 75721 | 205965 | DPW Maintained 1 | Cedrus deodara :: Deodar Cedar 109 | 340 Rivera St | 5 | Sidewalk: Property side : Yard | Tree | Private 2 | 11 | Width 3ft | 5992042.12067 | 2100502.3853 | 37.7471217736611 | -122.470279282079 | (37.7471217736611, -122.470279282079) | 1 | 8 | 4 | 29491 | 40 | |||
| 83249 | 205969 | DPW Maintained 1 | Cedrus deodara :: Deodar Cedar 109 | 340 Rivera St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 14 | Width 3ft | 5992083.35814 | 2100504.34625 | 37.7471295420093 | -122.470136830344 | (37.7471295420093, -122.470136830344) | 1 | 8 | 4 | 29491 | 40 | |||
| 86087 | 181462 | DPW Maintained 1 | Cedrus deodara :: Deodar Cedar 109 | 1400 Sunset Blvd | 22 | Sidewalk: Property side : Yard | Tree | Private 2 | 2 | Width 0ft | 5984903.9819 | 2105176.5315 | 37.7595404106399 | -122.495306668351 | (37.7595404106399, -122.495306668351) | 1 | 8 | 3 | 56 | 35 | |||
| 91435 | 187245 | DPW Maintained 1 | Cedrus deodara :: Deodar Cedar 109 | 2401 Sunset Blvd | 28 | Median : Yard | Tree | DPW 1 | 1 | Width 0ft | 5984968.6731 | 2098517.9713 | 37.74126161674 | -122.494592058244 | (37.74126161674, -122.494592058244) | 1 | 8 | 3 | 29491 | 35 | |||
| 102066 | 205973 | DPW Maintained 1 | Cedrus deodara :: Deodar Cedar 109 | 100 Edgehill Way | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 7 | Width 3ft | 5994796.55724 | 2098924.8239 | 37.7429490497539 | -122.460640430205 | (37.7429490497539, -122.460640430205) | 1 | 8 | 4 | 59 | 40 | |||
| 102676 | 186338 | DPW Maintained 1 | Cedrus deodara :: Deodar Cedar 109 | 1801 Sunset Blvd | 5 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 0ft | 5984768.4217 | 2102859.4402 | 37.7531703827167 | -122.49560458965 | (37.7531703827167, -122.49560458965) | 1 | 8 | 3 | 56 | 35 | |||
| 103759 | 187248 | DPW Maintained 1 | Cedrus deodara :: Deodar Cedar 109 | 2401 Sunset Blvd | 31 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 0ft | 5984942.1217 | 2098467.7278 | 37.7411221075772 | -122.49468015895 | (37.7411221075772, -122.49468015895) | 1 | 8 | 3 | 29491 | 35 | |||
| 107422 | 186342 | DPW Maintained 1 | Cedrus deodara :: Deodar Cedar 109 | 1801 Sunset Blvd | 9 | Sidewalk: Property side : Yard | Tree | Private 2 | 2 | Width 0ft | 5984831.8998 | 2102810.9611 | 37.7530409894565 | -122.495381497893 | (37.7530409894565, -122.495381497893) | 1 | 8 | 3 | 56 | 35 | |||
| 112470 | 187019 | DPW Maintained 1 | Cedrus deodara :: Deodar Cedar 109 | 2501 Sunset Blvd | 38 | Sidewalk: Property side : Yard | Tree | Private 2 | 0 | Width 0ft | 5984951.1292 | 2097900.2988 | 37.7395646275627 | -122.494607193049 | (37.7395646275627, -122.494607193049) | 1 | 8 | 3 | 29491 | 35 | |||
| 113048 | 184873 | DPW Maintained 1 | Cedrus deodara :: Deodar Cedar 109 | 1201 Sunset Blvd | 63 | Sidewalk: Property side : Yard | Tree | Private 2 | 26 | Width 0ft | 5984678.6788 | 2106815.322 | 37.7640268760632 | -122.496206778479 | (37.7640268760632, -122.496206778479) | 1 | 8 | 3 | 56 | 35 | |||
| 119590 | 187241 | DPW Maintained 1 | Cedrus deodara :: Deodar Cedar 109 | 2401 Sunset Blvd | 24 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 0ft | 5984938.8538 | 2098551.4669 | 37.7413518412824 | -122.494697630172 | (37.7413518412824, -122.494697630172) | 1 | 8 | 3 | 29491 | 35 | |||
| 125322 | 185206 | DPW Maintained 1 | Cedrus deodara :: Deodar Cedar 109 | 2500 Sunset Blvd | 59 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 0ft | 5985140.6623 | 2098012.0455 | 37.7398825454368 | -122.493960112537 | (37.7398825454368, -122.493960112537) | 1 | 8 | 3 | 29491 | 35 | |||
| 130374 | 184778 | DPW Maintained 1 | Cedrus deodara :: Deodar Cedar 109 | 1301 Sunset Blvd | 39 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 0ft | 5984713.9927 | 2105932.6644 | 37.7616054145292 | -122.496019518596 | (37.7616054145292, -122.496019518596) | 1 | 8 | 3 | 56 | 35 | |||
| 134036 | 185070 | DPW Maintained 1 | Cedrus deodara :: Deodar Cedar 109 | 2550x Yorba St | 1 | Median : Cutout | Tree | DPW 1 | 1 | Width 0ft | 5985042.3194 | 2096218.4188 | 37.7349519720941 | -122.494167970386 | (37.7349519720941, -122.494167970386) | 1 | 8 | 3 | 29491 | 35 | |||
| 135419 | 205960 | DPW Maintained 1 | Cedrus deodara :: Deodar Cedar 109 | 55 Marcela Ave | 4 | Sidewalk: Curb side : Yard | Tree | Private 2 | 1 | Width 4ft | 5994725.83926 | 2100688.55493 | 37.747787744113 | -122.461012759449 | (37.747787744113, -122.461012759449) | 1 | 8 | 4 | 29491 | 40 | |||
| 138765 | 205968 | DPW Maintained 1 | Cedrus deodara :: Deodar Cedar 109 | 340 Rivera St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 10 | Width 3ft | 5992072.49202 | 2100505.518 | 37.7471321311413 | -122.470174489472 | (37.7471321311413, -122.470174489472) | 1 | 8 | 4 | 29491 | 40 | |||
| 139596 | 185191 | DPW Maintained 1 | Cedrus deodara :: Deodar Cedar 109 | 2500 Sunset Blvd | 43 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 0ft | 5985141.9904 | 2097877.9096 | 37.7395143219875 | -122.493945637707 | (37.7395143219875, -122.493945637707) | 1 | 8 | 3 | 29491 | 35 | |||
| 140667 | 205958 | DPW Maintained 1 | Cedrus deodara :: Deodar Cedar 109 | 1711 09th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 5993391.35937 | 2103817.45791 | 37.7563020270413 | -122.465854594221 | (37.7563020270413, -122.465854594221) | 1 | 8 | 4 | 56 | 12 | |||
| 143069 | 185482 | DPW Maintained 1 | Cedrus deodara :: Deodar Cedar 109 | 2400 Sunset Blvd | 35 | unknown : Yard | Tree | Private 2 | 1 | Width 0ft | 5985148.9628 | 2098503.7667 | 37.7412331652619 | -122.493967642795 | (37.7412331652619, -122.493967642795) | 1 | 8 | 3 | 29491 | 35 | |||
| 145792 | 185190 | DPW Maintained 1 | Cedrus deodara :: Deodar Cedar 109 | 2500 Sunset Blvd | 42 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 0ft | 5985158.5914 | 2097861.3086 | 37.7394697114092 | -122.493887016425 | (37.7394697114092, -122.493887016425) | 1 | 8 | 3 | 29491 | 35 | |||
| 146744 | 205966 | DPW Maintained 1 | Cedrus deodara :: Deodar Cedar 109 | 340 Rivera St | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 9 | Width 3ft | 5992057.77948 | 2100503.94185 | 37.7471269528584 | -122.470225249018 | (37.7471269528584, -122.470225249018) | 1 | 8 | 4 | 29491 | 40 | |||
| 154677 | 181855 | DPW Maintained 1 | Cedrus deodara :: Deodar Cedar 109 | 2321 30th Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 8 | Width 0ft | 5986995.4808 | 2099452.2108 | 37.7439452086002 | -122.487652784151 | (37.7439452086002, -122.487652784151) | 1 | 8 | 3 | 29491 | 35 | |||
| 156711 | 185487 | DPW Maintained 1 | Cedrus deodara :: Deodar Cedar 109 | 2400 Sunset Blvd | 40 | unknown : Yard | Tree | Private 2 | 1 | Width 0ft | 5985139.0022 | 2098533.6484 | 37.7413146295557 | -122.494004284239 | (37.7413146295557, -122.494004284239) | 1 | 8 | 3 | 29491 | 35 | |||
| 159177 | 184758 | DPW Maintained 1 | Cedrus deodara :: Deodar Cedar 109 | 1301 Sunset Blvd | 31 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 0ft | 5984667.6669 | 2106015.823 | 37.7618310312978 | -122.496185873896 | (37.7618310312978, -122.496185873896) | 1 | 8 | 3 | 56 | 35 | |||
| 166613 | 185858 | DPW Maintained 1 | Cedrus deodara :: Deodar Cedar 109 | 2000 Sunset Blvd | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 0ft | 5985012.4452 | 2100952.2478 | 37.7479480417082 | -122.494620128976 | (37.7479480417082, -122.494620128976) | 1 | 8 | 3 | 29491 | 35 | |||
| 167443 | 181566 | DPW Maintained 1 | Cedrus deodara :: Deodar Cedar 109 | 1300 Sunset Blvd | 44 | Sidewalk: Property side : Yard | Tree | Private 2 | 2 | Width 0ft | 5984886.9946 | 2106096.9065 | 37.7620665086978 | -122.49543329804 | (37.7620665086978, -122.49543329804) | 1 | 8 | 3 | 56 | 35 | |||
| 175823 | 181459 | DPW Maintained 1 | Cedrus deodara :: Deodar Cedar 109 | 1400 Sunset Blvd | 19 | Sidewalk: Property side : Yard | Tree | Private 2 | 2 | Width 0ft | 5984897.8553 | 2105138.1013 | 37.759434533306 | -122.495325022687 | (37.759434533306, -122.495325022687) | 1 | 8 | 3 | 56 | 35 | |||
| 181326 | 186339 | DPW Maintained 1 | Cedrus deodara :: Deodar Cedar 109 | 1801 Sunset Blvd | 6 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 0ft | 5984820.6505 | 2102844.4411 | 37.7531322576305 | -122.495422868583 | (37.7531322576305, -122.495422868583) | 1 | 8 | 3 | 56 | 35 | |||
| 190950 | 205959 | DPW Maintained 1 | Cedrus deodara :: Deodar Cedar 109 | 1501 05th Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 36 | 5994575.87769 | 2105238.79238 | 37.7602729043921 | -122.461861209523 | (37.7602729043921, -122.461861209523) | 1 | 5 | 4 | 56 | 12 | ||||
| 192980 | 181554 | DPW Maintained 1 | Cedrus deodara :: Deodar Cedar 109 | 1300 Sunset Blvd | 32 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 0ft | 5984879.7541 | 2106056.8055 | 37.7619559786179 | -122.495455382075 | (37.7619559786179, -122.495455382075) | 1 | 8 | 3 | 56 | 35 | |||
| 17652 | 187553 | DPW Maintained 1 | Cedrus deodara :: Deodar Cedar 109 | 3960 Somerset St | 1 | Side Yard : Yard | Tree | Private 2 | 16 | 6011370.89706 | 2088323.01324 | 37.7147783208511 | -122.402585230642 | (37.7147783208511, -122.402585230642) | 10 | 7 | 8 | 309 | 39 | ||||
| 23612 | 253210 | Significant Tree 6 | Cedrus deodara :: Deodar Cedar 109 | 567 Mississippi St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 05/02/2019 12:00:00 AM | 3 | 3x3 | 6014163 | 2104519 | 37.7594046471392 | -122.394067636073 | (37.7594046471392, -122.394067636073) | 10 | 3 | 8 | 28856 | 29 | ||
| 25772 | 188433 | DPW Maintained 1 | Cedrus deodara :: Deodar Cedar 109 | 1 Jack Balestreri Way | 8 | Front Yard : Yard | Tree | Private 2 | 22 | 6012415.19625 | 2104737.50493 | 37.7599073164779 | -122.400127781893 | (37.7599073164779, -122.400127781893) | 10 | 3 | 8 | 28856 | 29 | ||||
| 27427 | 188430 | DPW Maintained 1 | Cedrus deodara :: Deodar Cedar 109 | 895 Vermont St | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 3 | 6011323.63457 | 2104185.0777 | 37.7583295512927 | -122.403864109736 | (37.7583295512927, -122.403864109736) | 10 | 3 | 8 | 28856 | 29 | ||||
| 39962 | 187547 | DPW Maintained 1 | Cedrus deodara :: Deodar Cedar 109 | 1398 Somerset St | 1 | Side Yard : Yard | Tree | Private 2 | 15 | 6011342.64618 | 2088318.49889 | 37.7147643480751 | -122.402682560663 | (37.7147643480751, -122.402682560663) | 10 | 7 | 8 | 309 | 39 | ||||
| 56151 | 187558 | DPW Maintained 1 | Cedrus deodara :: Deodar Cedar 109 | 3959 Somerset St | 2 | Side Yard : Yard | Tree | Private 2 | 14 | 6011340.42145 | 2088314.93577 | 37.7147544402534 | -122.402689999868 | (37.7147544402534, -122.402689999868) | 10 | 7 | 8 | 309 | 39 | ||||
| 64212 | 187557 | DPW Maintained 1 | Cedrus deodara :: Deodar Cedar 109 | 3959 Somerset St | 1 | Side Yard : Yard | Tree | Private 2 | 17 | 6011334.94928 | 2088323.74418 | 37.7147783208423 | -122.402709533143 | (37.7147783208423, -122.402709533143) | 10 | 7 | 8 | 309 | 39 | ||||
| 69395 | 188432 | DPW Maintained 1 | Cedrus deodara :: Deodar Cedar 109 | 1 Jack Balestreri Way | 6 | Front Yard : Yard | Tree | Private 2 | 16 | 6012439.74697 | 2104738.60671 | 37.7599117105733 | -122.400042949735 | (37.7599117105733, -122.400042949735) | 10 | 3 | 8 | 28856 | 29 | ||||
| 70049 | 187545 | DPW Maintained 1 | Cedrus deodara :: Deodar Cedar 109 | 1399 Somerset St | 1 | Side Yard : Yard | Tree | Private 2 | 16 | 6011375.77756 | 2088317.82522 | 37.7147643480702 | -122.40256799691 | (37.7147643480702, -122.40256799691) | 10 | 7 | 8 | 309 | 39 | ||||
| 70249 | 113112 | Significant Tree 6 | Cedrus deodara :: Deodar Cedar 109 | 1633 OAKDALE AVE | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6014731 | 2095647 | 37.7350755495662 | -122.391482947841 | (37.7350755495662, -122.391482947841) | 10 | 3 | 8 | 58 | 1 | |||||
| 75652 | 188435 | DPW Maintained 1 | Cedrus deodara :: Deodar Cedar 109 | 47 Ceres St | 1 | : | Tree | Private 2 | 14 | Width 3ft | 6013897.60555 | 2093909.5086 | 37.730258461857 | -122.394242705643 | (37.730258461857, -122.394242705643) | 10 | 3 | 8 | 58 | 1 | |||
| 102464 | 248911 | Significant Tree 6 | Cedrus deodara :: Deodar Cedar 109 | 1633 Oakdale Ave | 1 | Front Yard : Yard | Tree | Private 2 | 6014844.92913 | 2095599.8976 | 37.7349525388235 | -122.391085759591 | (37.7349525388235, -122.391085759591) | 10 | 3 | 8 | 58 | 1 | |||||
| 120016 | 188434 | DPW Maintained 1 | Cedrus deodara :: Deodar Cedar 109 | 406 Arkansas St | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 19 | Width 4ft | 6012917.44565 | 2105140.82493 | 37.7610427357449 | -122.398419034005 | (37.7610427357449, -122.398419034005) | 10 | 3 | 8 | 28856 | 29 | |||
| 128435 | 187548 | DPW Maintained 1 | Cedrus deodara :: Deodar Cedar 109 | 1398 Somerset St | 2 | Side Yard : Yard | Tree | Private 2 | 13 | 6011346.78154 | 2088306.58257 | 37.7147318591505 | -122.402667429564 | (37.7147318591505, -122.402667429564) | 10 | 7 | 8 | 309 | 39 | ||||
| 135623 | 258062 | Significant Tree 6 | Cedrus deodara :: Deodar Cedar 109 | 567 Mississippi St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 05/02/2019 12:00:00 AM | 3 | 3x3 | 6014163 | 2104519 | 37.7594046471392 | -122.394067636073 | (37.7594046471392, -122.394067636073) | 10 | 3 | 8 | 28856 | 29 | ||
| 162063 | 113132 | Significant Tree 6 | Cedrus deodara :: Deodar Cedar 109 | 1375 FAIRFAX AVE | 1 | Front Yard : Yard | Tree | Private 2 | 6016814 | 2097238 | 37.7395595104895 | -122.384391976269 | (37.7395595104895, -122.384391976269) | 10 | 3 | 8 | 58 | 1 | |||||
| 169082 | 108587 | Undocumented 4 | Cedrus deodara :: Deodar Cedar 109 | 950 Goettingen St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 6011025 | 2090361 | 37.7203549001646 | -122.403924129148 | (37.7203549001646, -122.403924129148) | 10 | 7 | 8 | 309 | 28 | |||||
| 183281 | 188431 | DPW Maintained 1 | Cedrus deodara :: Deodar Cedar 109 | 889 Vermont St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 3 | 6011294.06359 | 2104194.03596 | 37.7583524966 | -122.403967010163 | (37.7583524966, -122.403967010163) | 10 | 3 | 8 | 28856 | 29 | ||||
| 26724 | 125941 | DPW Maintained 1 | Cedrus deodara :: Deodar Cedar 109 | 330 Cherry St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 17 | Width 3ft | 5996203.89662 | 2115167.13558 | 37.7876271253444 | -122.456948819342 | (37.7876271253444, -122.456948819342) | 11 | 6 | 1 | 54 | 31 | |||
| 42238 | 26408 | DPW Maintained 1 | Cedrus deodara :: Deodar Cedar 109 | 34 Maple St | 5 | Sidewalk: Property side : Cutout | Tree | DPW 1 | 3 | 10 | 5996561.99823 | 2116111.65083 | 37.7902410678174 | -122.455778167326 | (37.7902410678174, -122.455778167326) | 11 | 6 | 1 | 54 | 31 | |||
| 86731 | 120440 | DPW Maintained 1 | Cedrus deodara :: Deodar Cedar 109 | 99 22nd Ave | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 26 | 5988935.73102 | 2114756.99709 | 37.7860809522857 | -122.482064894816 | (37.7860809522857, -122.482064894816) | 11 | 6 | 1 | 55 | 33 | ||||
| 100469 | 123935 | DPW Maintained 1 | Cedrus deodara :: Deodar Cedar 109 | 1 08th Ave | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 3ft | 5993304.58921 | 2114931.5281 | 37.7868132950893 | -122.466962635679 | (37.7868132950893, -122.466962635679) | 11 | 6 | 1 | 54 | 11 | |||
| 136386 | 20471 | DPW Maintained 1 | Cedrus deodara :: Deodar Cedar 109 | 1203X Sunset Blvd | 5 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 12 | 40 | 5984781.3005655 | 2107242.2257009 | 37.7652050441375 | -122.495883339617 | (37.7652050441375, -122.495883339617) | 11 | 6 | 2 | 55 | 8 | |||
| 143340 | 20473 | DPW Maintained 1 | Cedrus deodara :: Deodar Cedar 109 | 1203X Sunset Blvd | 7 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 12 | 40 | 5984781.3005655 | 2107242.2257009 | 37.7652050441375 | -122.495883339617 | (37.7652050441375, -122.495883339617) | 11 | 6 | 2 | 55 | 8 | |||
| 150083 | 89552 | DPW Maintained 1 | Cedrus deodara :: Deodar Cedar 109 | 5301X Anza St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/27/2008 12:00:00 AM | 3 | 3x3 | 5982134.08217 | 2111641.44969 | 37.7771286413932 | -122.505365369731 | (37.7771286413932, -122.505365369731) | 11 | 6 | 2 | 55 | 26 | ||
| 152519 | 125942 | DPW Maintained 1 | Cedrus deodara :: Deodar Cedar 109 | 330 Cherry St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 19 | Width 3ft | 5996200.38714 | 2115190.83306 | 37.7876919907308 | -122.456962676089 | (37.7876919907308, -122.456962676089) | 11 | 6 | 1 | 54 | 31 | |||
| 171791 | 20472 | DPW Maintained 1 | Cedrus deodara :: Deodar Cedar 109 | 1203X Sunset Blvd | 6 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 12 | 40 | 5984781.3005655 | 2107242.2257009 | 37.7652050441375 | -122.495883339617 | (37.7652050441375, -122.495883339617) | 11 | 6 | 2 | 55 | 8 | |||
| 180388 | 122533 | DPW Maintained 1 | Cedrus deodara :: Deodar Cedar 109 | 330 Cherry St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 20 | 3x3 | 5996206.76468 | 2115142.22456 | 37.7875588910678 | -122.456937093983 | (37.7875588910678, -122.456937093983) | 11 | 6 | 1 | 54 | 31 | |||
| 5014 | 125944 | DPW Maintained 1 | Cedrus deodara :: Deodar Cedar 109 | 100 Alice B Toklas Pl | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 4ft | 6006919.44761 | 2114149.75866 | 37.7854431613244 | -122.419802815953 | (37.7854431613244, -122.419802815953) | 13 | 9 | 9 | 28858 | 36 | |||
| 5414 | 261208 | Significant Tree 6 | Cedrus deodara :: Deodar Cedar 109 | 1131 Sutter St | 1 | Front Yard : Cutout | Tree | Private 2 | 3x3 | 6007175 | 2115019 | 37.7878442781586 | -122.418980353142 | (37.7878442781586, -122.418980353142) | 13 | 9 | 10 | 28858 | 21 | ||||
| 30713 | 99829 | Significant Tree 6 | Cedrus deodara :: Deodar Cedar 109 | 2398 Broadway | 3 | Front Yard : Yard | Tree | Private 2 | 6002195.8 | 2117442.8 | 37.7942177709498 | -122.436380971376 | (37.7942177709498, -122.436380971376) | 13 | 9 | 1 | 29490 | 27 | |||||
| 39009 | 255287 | Significant Tree 6 | Cedrus deodara :: Deodar Cedar 109 | 2758 Green St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5999862 | 2117824 | 37.7951315610034 | -122.444483561153 | (37.7951315610034, -122.444483561153) | 13 | 9 | 1 | 57 | 17 | ||||
| 117634 | 125946 | DPW Maintained 1 | Cedrus deodara :: Deodar Cedar 109 | 100 Alice B Toklas Pl | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 4ft | 6006887.30647 | 2114142.45385 | 37.7854212934049 | -122.419913496417 | (37.7854212934049, -122.419913496417) | 13 | 9 | 9 | 28858 | 36 | |||
| 193015 | 125945 | DPW Maintained 1 | Cedrus deodara :: Deodar Cedar 109 | 100 Alice B Toklas Pl | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 4ft | 6006900.61191 | 2114145.75127 | 37.7854310968993 | -122.41986769754 | (37.7854310968993, -122.41986769754) | 13 | 9 | 9 | 28858 | 36 | |||
| 6682 | 222764 | DPW Maintained 1 | Cedrus deodara :: Deodar Cedar 109 | 191 Corbett Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 2ft | 6000158.84379 | 2105641.525 | 37.76169853039 | -122.442581324981 | (37.76169853039, -122.442581324981) | 15 | 5 | 5 | 28862 | 3 | |||
| 48358 | 112182 | DPW Maintained 1 | Cedrus deodara :: Deodar Cedar 109 | 301x CORBETT AVE | 8 | Sidewalk: Property side : Yard | Tree | DPW 1 | 3x3 | 5999677 | 2105220 | 37.760513648973 | -122.444217531177 | (37.760513648973, -122.444217531177) | 15 | 5 | 5 | 28862 | 3 | ||||
| 56487 | 222767 | DPW Maintained 1 | Cedrus deodara :: Deodar Cedar 109 | 301 Upper Ter | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 12 | Width 3ft | 5999265.86502 | 2105880.94381 | 37.7623049720107 | -122.445686985283 | (37.7623049720107, -122.445686985283) | 15 | 5 | 5 | 29492 | 3 | |||
| 74277 | 251372 | Significant Tree 6 | Cedrus deodara :: Deodar Cedar 109 | 1526 Masonic Ave | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | 11/01/2017 12:00:00 AM | 3 | 3x3 | Permit Number 779800 | 5999767 | 2107205 | 37.7659690994291 | -122.444048894864 | (37.7659690994291, -122.444048894864) | 15 | 5 | 5 | 29492 | 9 | |
| 87221 | 222766 | DPW Maintained 1 | Cedrus deodara :: Deodar Cedar 109 | 230 States St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 15 | Width 3ft | 6000813.28716 | 2106520.59939 | 37.7641495354877 | -122.440380922268 | (37.7641495354877, -122.440380922268) | 15 | 5 | 5 | 28862 | 3 | |||
| 97059 | 222768 | DPW Maintained 1 | Cedrus deodara :: Deodar Cedar 109 | 79 Pierce St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 6002832.56338 | 2108743.90779 | 37.7703689643988 | -122.433555737015 | (37.7703689643988, -122.433555737015) | 15 | 5 | 5 | 29492 | 9 | |||
| 113943 | 222765 | DPW Maintained 1 | Cedrus deodara :: Deodar Cedar 109 | 272 Corbett Ave | 1 | Side Yard : Yard | Tree | Private 2 | 16 | Width 3ft | 5999637.29501 | 2105376.06979 | 37.760939912666 | -122.444366068238 | (37.760939912666, -122.444366068238) | 15 | 5 | 5 | 28862 | 3 | |||
| 124217 | 109412 | Significant Tree 6 | Cedrus deodara :: Deodar Cedar 109 | 24 DELMAR ST | 1 | Front Yard : Yard | Tree | Private 2 | 04/03/2015 12:00:00 AM | 3 | 3x3 | Permit Number 774367 | 5999307.7 | 2108197.1 | 37.7686669444558 | -122.445708866914 | (37.7686669444558, -122.445708866914) | 15 | 5 | 11 | 29492 | 9 | |
| 160978 | 112451 | Significant Tree 6 | Cedrus deodara :: Deodar Cedar 109 | 1526 MASONIC AVE | 1 | Front Yard : Cutout | Tree | Private 2 | 3x6 | 5999767 | 2107205 | 37.7659690994291 | -122.444048894864 | (37.7659690994291, -122.444048894864) | 15 | 5 | 5 | 29492 | 9 | ||||
| 164452 | 117027 | Significant Tree 6 | Cedrus deodara :: Deodar Cedar 109 | 731 CLAYTON ST | 1 | Front Yard : Cutout | Tree | Private 2 | 5998515 | 2108057 | 37.7682369747157 | -122.448440651351 | (37.7682369747157, -122.448440651351) | 15 | 5 | 11 | 29492 | 9 |
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) );