trees
379 rows where qSpecies_id = 86 sorted by XCoord
This data as json, CSV (advanced)
PlantType ✖
- Tree 378
- Landscaping 1
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
69558 | 84155 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 770 46th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/23/2009 12:00:00 AM | 5 | 3x3 | Permit Number 52704 | 5981697.89996 | 2110507.76717 | 37.7739902053501 | -122.506790127416 | (37.7739902053501, -122.506790127416) | 11 | 6 | 2 | 55 | 26 | |
11629 | 47454 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 5135 Anza St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/14/2002 12:00:00 AM | 6 | Permit Number 45360 | 5982684.34734 | 2111666.51211 | 37.7772298203102 | -122.50346371712 | (37.7772298203102, -122.50346371712) | 11 | 6 | 2 | 55 | 26 | |
1950 | 71713 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 782 40th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 8 | 5983564.60428 | 2110493.72832 | 37.7740614056929 | -122.500331946576 | (37.7740614056929, -122.500331946576) | 11 | 6 | 2 | 55 | 26 | |||
13058 | 260903 | Significant Tree 6 | Taxus baccata :: Irish Yew 86 | 51 Shore View Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | Width 4ft | 5984536 | 2112849 | 37.7805852728313 | -122.497145662996 | (37.7805852728313, -122.497145662996) | 11 | 6 | 2 | 55 | 26 | ||||
71787 | 256414 | Undocumented 4 | Taxus baccata :: Irish Yew 86 | 3001 Sunset Blvd | 2 | Median : Yard | Tree | Private 2 | 10x10 | 5984960 | 2094729 | 37.7308576064943 | -122.49434282122 | (37.7308576064943, -122.49434282122) | 1 | 8 | 4 | 64 | 35 | ||||
110991 | 256413 | Undocumented 4 | Taxus baccata :: Irish Yew 86 | 3001 Sunset Blvd | 1 | Median : Yard | Tree | Private 2 | 10x10 | 5984960 | 2094729 | 37.7308576064943 | -122.49434282122 | (37.7308576064943, -122.49434282122) | 1 | 8 | 4 | 64 | 35 | ||||
163182 | 256443 | Undocumented 4 | Taxus baccata :: Irish Yew 86 | 3001 Sunset Blvd | 27 | Median : Yard | Tree | Private 2 | 10x10 | 5984960 | 2094729 | 37.7308576064943 | -122.49434282122 | (37.7308576064943, -122.49434282122) | 1 | 8 | 4 | 64 | 35 | ||||
145014 | 256324 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 3000X Sunset Blvd | 3 | Median : Yard | Tree | Private 2 | 3x3 | 5985361 | 2095009 | 37.7316498716246 | -122.492977136553 | (37.7316498716246, -122.492977136553) | 1 | 8 | 4 | 64 | 35 | ||||
7835 | 258799 | Significant Tree 6 | Taxus baccata :: Irish Yew 86 | 566 29th Ave | 1 | Front Yard : Cutout | Tree | Private 2 | 3x3 | 5986943 | 2112080 | 37.7786145821325 | -122.488762272653 | (37.7786145821325, -122.488762272653) | 11 | 6 | 2 | 55 | 26 | ||||
150071 | 67960 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 819 28th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/22/1993 12:00:00 AM | 12 | Permit Number 31680 | 5987243.89988 | 2110346.29905 | 37.7738718832899 | -122.487593962509 | (37.7738718832899, -122.487593962509) | 11 | 6 | 2 | 55 | 26 | |
5035 | 103624 | Permitted Site 7 | Taxus baccata :: Irish Yew 86 | 333 El Camino Del Mar | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | 06/04/2013 12:00:00 AM | Permit Number 770205 | 5987603.5 | 2115303.5 | 37.7875039187234 | -122.486714142272 | (37.7875039187234, -122.486714142272) | 11 | 6 | 1 | 55 | 33 | |||
106864 | 103625 | Permitted Site 7 | Taxus baccata :: Irish Yew 86 | 333 El Camino Del Mar | 2 | Sidewalk: Property side : Cutout | Tree | Private 2 | 06/04/2013 12:00:00 AM | Permit Number 770205 | 5987603.5 | 2115303.5 | 37.7875039187234 | -122.486714142272 | (37.7875039187234, -122.486714142272) | 11 | 6 | 1 | 55 | 33 | |||
191808 | 103623 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 333 El Camino Del Mar | 1 | Sidewalk: Property side : Cutout | Landscaping | Private 2 | 06/04/2013 12:00:00 AM | 13x2 | Permit Number 770205 | 5987603.5 | 2115303.5 | 37.7875039187234 | -122.486714142272 | (37.7875039187234, -122.486714142272) | 11 | 6 | 1 | 55 | 33 | ||
21064 | 45165 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 227 26th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/23/2001 12:00:00 AM | 3 | Permit Number 44015 | 5987719.09382 | 2114404.67144 | 37.7850427307042 | -122.486248205367 | (37.7850427307042, -122.486248205367) | 11 | 6 | 1 | 55 | 26 | ||
60405 | 120082 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 261 26th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 5987725.3967 | 2114231.06843 | 37.7845664337094 | -122.486213650773 | (37.7845664337094, -122.486213650773) | 11 | 6 | 1 | 55 | 26 | |||
193341 | 120231 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 154 25th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 2ft | 5988063.88277 | 2114955.73403 | 37.7865758810738 | -122.485095805195 | (37.7865758810738, -122.485095805195) | 11 | 6 | 1 | 55 | 33 | |||
73016 | 120230 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 154 25th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 2ft | 5988064.78369 | 2114963.42937 | 37.7865970627596 | -122.485093253087 | (37.7865970627596, -122.485093253087) | 11 | 6 | 1 | 55 | 33 | |||
22738 | 120295 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 191 24th Ave | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 17 | Width 3ft | 5988321.26869 | 2114707.42753 | 37.7859090914651 | -122.484187107183 | (37.7859090914651, -122.484187107183) | 11 | 6 | 1 | 55 | 33 | |||
72527 | 120265 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 100 24th Ave | 3 | Side Yard : Yard | Tree | Private 2 | 20 | 5988361.48129 | 2115164.47421 | 37.7871663527314 | -122.484081512932 | (37.7871663527314, -122.484081512932) | 11 | 6 | 1 | 55 | 33 | ||||
5717 | 72392 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 2220 Cabrillo St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11 | 5988673.5466 | 2110578.22329 | 37.7745919608967 | -122.48266563867 | (37.7745919608967, -122.48266563867) | 11 | 6 | 2 | 55 | 26 | |||
7366 | 444 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 700X 23rd Ave | 5 | Median : Cutout | Tree | DPW 1 | 3 | 8-HOA | 5988817.90932 | 2110395.27546 | 37.774098034723 | -122.482152859676 | (37.774098034723, -122.482152859676) | 11 | 6 | 2 | 55 | 26 | |||
6392 | 70172 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 3027 Anza St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 8 | 5989237.11171 | 2111905.73167 | 37.7782697016213 | -122.480813388031 | (37.7782697016213, -122.480813388031) | 11 | 6 | 2 | 55 | 26 | |||
5435 | 70223 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 2011 Balboa St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 7 | 5989310.46344 | 2111227.07993 | 37.776410575875 | -122.480509949706 | (37.776410575875, -122.480509949706) | 11 | 6 | 2 | 55 | 26 | |||
25989 | 101973 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 1695 21st Ave | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | 4x4 | Permit Number 769633 | 5989621.7 | 2103844.4 | 37.7561578263999 | -122.478893204843 | (37.7561578263999, -122.478893204843) | 1 | 8 | 3 | 56 | 35 | |||
135535 | 120845 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 295 19th Ave | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 2ft | 5989915.85655 | 2113416.78862 | 37.7824580717728 | -122.478575916409 | (37.7824580717728, -122.478575916409) | 11 | 6 | 2 | 55 | 26 | |||
175109 | 120844 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 295 19th Ave | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 2ft | 5989915.94097 | 2113420.78105 | 37.7824690387717 | -122.478575916411 | (37.7824690387717, -122.478575916411) | 11 | 6 | 2 | 55 | 26 | |||
133639 | 121844 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 518 19th Ave | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 15 | Width 3ft | 5990041.13259 | 2111807.14387 | 37.7780457072257 | -122.478024804476 | (37.7780457072257, -122.478024804476) | 11 | 6 | 2 | 55 | 26 | |||
41820 | 68457 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 119 14th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/04/1993 12:00:00 AM | 12 | Permit Number 32319 | 5991463.79981 | 2114626.05304 | 37.7858681269791 | -122.473308986123 | (37.7858681269791, -122.473308986123) | 11 | 6 | 2 | 54 | 26 | |
38031 | 215288 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 800 Pacheco St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 2ft | 5991477.1073 | 2101838.1015 | 37.7507566211347 | -122.472330389247 | (37.7507566211347, -122.472330389247) | 1 | 8 | 4 | 29491 | 12 | |||
180866 | 179830 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 966 Randolph St | 1 | Sidewalk: Curb side : Pot | Tree | Private 2 | 10 | Width 3ft | 5991498.1765 | 2088667.95393 | 37.7145959293389 | -122.471298058377 | (37.7145959293389, -122.471298058377) | 9 | 8 | 6 | 64 | 24 | |||
64521 | 179831 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 966 Randolph St | 2 | Sidewalk: Curb side : Pot | Tree | Private 2 | 10 | Width 3ft | 5991499.58423 | 2088662.21507 | 37.7145802532566 | -122.471292774854 | (37.7145802532566, -122.471292774854) | 9 | 8 | 6 | 64 | 24 | |||
184131 | 179832 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 89 Belle Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 8 | Width 2ft | 5991610.51667 | 2086489.35195 | 37.7086205125859 | -122.470751174349 | (37.7086205125859, -122.470751174349) | 9 | 8 | 4 | 64 | 24 | |||
157108 | 114608 | Undocumented 4 | Taxus baccata :: Irish Yew 86 | 2398X 15TH AVE | 2 | Sidewalk: Property side : Cutout | Tree | Private 2 | 6 | 5991654 | 2099150 | 37.7433860243849 | -122.471522828523 | (37.7433860243849, -122.471522828523) | 1 | 8 | 4 | 29491 | 40 | ||||
183619 | 215325 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 1301 14th Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 5992027.65667 | 2098311.13553 | 37.7411043262013 | -122.470169759048 | (37.7411043262013, -122.470169759048) | 1 | 8 | 4 | 59 | 40 | |||
192763 | 215327 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 1301 14th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 5992028.3413 | 2098343.65136 | 37.7411936459769 | -122.470169759049 | (37.7411936459769, -122.470169759049) | 1 | 8 | 4 | 59 | 40 | |||
157310 | 215326 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 1301 14th Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 5992028.53266 | 2098327.51469 | 37.7411493498502 | -122.470167922636 | (37.7411493498502, -122.470167922636) | 1 | 8 | 4 | 59 | 40 | |||
138676 | 215328 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 1301 14th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 5992029.37698 | 2098355.00215 | 37.7412248722329 | -122.470167004418 | (37.7412248722329, -122.470167004418) | 1 | 8 | 4 | 59 | 40 | |||
43129 | 100849 | Undocumented 4 | Taxus baccata :: Irish Yew 86 | 1 Estero Ave | 6 | Sidewalk: Property side : Yard | Tree | Private 2 | 5992057.7 | 2091642.6 | 37.7227959320346 | -122.469580550695 | (37.7227959320346, -122.469580550695) | 9 | 8 | 4 | 59 | 40 | |||||
5140 | 70173 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 246 11th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10 | 5992471.1879 | 2113801.97828 | 37.7836637247597 | -122.469763717453 | (37.7836637247597, -122.469763717453) | 11 | 6 | 2 | 54 | 11 | |||
115107 | 123109 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 534 11th Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 10 | Width 4ft | 5992552.3957 | 2111792.37608 | 37.7781505989958 | -122.469336449069 | (37.7781505989958, -122.469336449069) | 11 | 6 | 2 | 54 | 11 | |||
127245 | 123108 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 534 11th Ave | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 10 | Width 4ft | 5992553.53653 | 2111802.27469 | 37.7781778438173 | -122.469333223241 | (37.7781778438173, -122.469333223241) | 11 | 6 | 2 | 54 | 11 | |||
94688 | 215286 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 1642 11th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 2ft | 5992803.42046 | 2104269.10188 | 37.757508190571 | -122.467920721889 | (37.757508190571, -122.467920721889) | 1 | 8 | 4 | 56 | 12 | |||
85795 | 215323 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 1222 10th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | Width 3ft | 5993013.20867 | 2107124.46318 | 37.7653603763971 | -122.467402823005 | (37.7653603763971, -122.467402823005) | 11 | 8 | 11 | 56 | 12 | |||
183558 | 215284 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 1442 10th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 2ft | 5993065.75738 | 2105645.52263 | 37.7613026281332 | -122.467113534456 | (37.7613026281332, -122.467113534456) | 1 | 8 | 4 | 56 | 12 | |||
112978 | 215283 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 1448 10th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 2ft | 5993067.04344 | 2105615.39 | 37.7612199660593 | -122.467106895686 | (37.7612199660593, -122.467106895686) | 1 | 8 | 4 | 56 | 12 | |||
152699 | 215321 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 1546 10th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 5993089.7363 | 2104935.14056 | 37.7593534887954 | -122.466978955425 | (37.7593534887954, -122.466978955425) | 1 | 8 | 4 | 56 | 12 | |||
136982 | 215322 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 1546 10th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 5993091.78936 | 2104948.86266 | 37.7593912846005 | -122.466972852608 | (37.7593912846005, -122.466972852608) | 1 | 8 | 4 | 56 | 12 | |||
94393 | 68663 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 142 08th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/02/1993 12:00:00 AM | 10 | Permit Number 32570 | 5993373.867 | 2114549.20899 | 37.7857675498482 | -122.466695151518 | (37.7857675498482, -122.466695151518) | 11 | 6 | 2 | 54 | 11 | |
161461 | 215320 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 613 Head St | 5 | Sidewalk: Property side : Yard | Tree | Private 2 | 13 | Width 6ft | 5993477.4709 | 2089866.91929 | 37.7180022959343 | -122.464543873715 | (37.7180022959343, -122.464543873715) | 9 | 8 | 6 | 64 | 24 | |||
89241 | 215332 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 2075 09th Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 25 | Width 3ft | 5993490.42536 | 2101424.27814 | 37.7497366847097 | -122.46533815853 | (37.7497366847097, -122.46533815853) | 1 | 8 | 4 | 29491 | 40 | |||
44075 | 215290 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 496 Pacheco St | 4 | Sidewalk: Curb side : Yard | Tree | Private 2 | 16 | Width 6ft | 5993542.94164 | 2101911.83549 | 37.7510784210541 | -122.465191965655 | (37.7510784210541, -122.465191965655) | 1 | 8 | 4 | 29491 | 12 | |||
171043 | 215330 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 2095 09th Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 13 | Width 3ft | 5993552.71459 | 2101379.42964 | 37.7496171342399 | -122.465119504581 | (37.7496171342399, -122.465119504581) | 1 | 8 | 4 | 29491 | 40 | |||
105158 | 215289 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 496 Pacheco St | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 14 | Width 6ft | 5993555.20621 | 2101912.20382 | 37.7510801396391 | -122.465149580605 | (37.7510801396391, -122.465149580605) | 1 | 8 | 4 | 29491 | 12 | |||
92970 | 215331 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 2095 09th Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 14 | Width 3ft | 5993556.00602 | 2101376.01116 | 37.7496079377635 | -122.465107874536 | (37.7496079377635, -122.465107874536) | 1 | 8 | 4 | 29491 | 40 | |||
119328 | 215333 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 8 Mendosa Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 3ft | 5993587.48804 | 2101138.42118 | 37.7489573915925 | -122.464981756306 | (37.7489573915925, -122.464981756306) | 1 | 8 | 4 | 29491 | 40 | |||
129935 | 215324 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 1288 08th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 5ft | 5993647.63812 | 2106753.81902 | 37.764379290687 | -122.465181573075 | (37.764379290687, -122.465181573075) | 11 | 8 | 11 | 56 | 12 | |||
129943 | 123960 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 241 07th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 2ft | Permit Number 782043 | 5993663.58723 | 2113895.36148 | 37.7839889783025 | -122.465645289525 | (37.7839889783025, -122.465645289525) | 11 | 6 | 2 | 54 | 11 | ||
192633 | 215285 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 1536 08th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 5993707.75608 | 2105010.81191 | 37.7595969145732 | -122.464847054052 | (37.7595969145732, -122.464847054052) | 1 | 8 | 4 | 56 | 12 | |||
23215 | 218419 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 206 Castenada Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 8 | Width 0ft | 5994236.56093 | 2100588.83344 | 37.7474857670642 | -122.462697413572 | (37.7474857670642, -122.462697413572) | 1 | 8 | 4 | 29491 | 40 | |||
127847 | 218418 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 206 Castenada Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 8 | Width 0ft | 5994240.64803 | 2100595.30557 | 37.7475037732855 | -122.462683750177 | (37.7475037732855, -122.462683750177) | 1 | 8 | 4 | 29491 | 40 | |||
190200 | 215291 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 275 Pacheco St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 29 | Width 4ft | 5994404.07408 | 2100583.57652 | 37.7474809790792 | -122.462117787007 | (37.7474809790792, -122.462117787007) | 1 | 8 | 4 | 29491 | 40 | |||
42109 | 215292 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 275 Pacheco St | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 31 | Width 4ft | 5994414.45382 | 2100572.16969 | 37.747450256423 | -122.462081067713 | (37.747450256423, -122.462081067713) | 1 | 8 | 4 | 29491 | 40 | |||
61794 | 215293 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 275 Pacheco St | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 33 | Width 4ft | 5994427.84018 | 2100560.89209 | 37.747420061691 | -122.462033961208 | (37.747420061691, -122.462033961208) | 1 | 8 | 4 | 29491 | 40 | |||
166505 | 215294 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 275 Pacheco St | 4 | Sidewalk: Curb side : Yard | Tree | Private 2 | 32 | Width 4ft | 5994441.43842 | 2100548.35757 | 37.7473864279531 | -122.461986030947 | (37.7473864279531, -122.461986030947) | 1 | 8 | 4 | 29491 | 40 | |||
290 | 72670 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 203 04th Ave | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11 | 5994586.71732 | 2114106.61682 | 37.7846222306097 | -122.462466948558 | (37.7846222306097, -122.462466948558) | 11 | 6 | 2 | 54 | 11 | |||
161074 | 41928 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 524 04th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/20/2000 12:00:00 AM | 9 | Permit Number 42287 | 5994708.51972 | 2111929.51477 | 37.7786515066402 | -122.461887634901 | (37.7786515066402, -122.461887634901) | 11 | 6 | 2 | 54 | 11 | |
169423 | 41927 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 524 04th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/20/2000 12:00:00 AM | 6 | Permit Number 42287 | 5994711.05634 | 2111911.6847 | 37.7786026960614 | -122.46187756658 | (37.7786026960614, -122.46187756658) | 11 | 6 | 2 | 54 | 11 | |
6275 | 215306 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 490 Faxon Ave | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 11 | Width 3ft | 5994798.91109 | 2091839.85894 | 37.7234956059322 | -122.46011911751 | (37.7234956059322, -122.46011911751) | 9 | 8 | 4 | 28861 | 24 | |||
30022 | 215307 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 490 Faxon Ave | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 11 | Width 3ft | 5994799.16087 | 2091851.78305 | 37.7235283610397 | -122.460119117526 | (37.7235283610397, -122.460119117526) | 9 | 8 | 4 | 28861 | 24 | |||
96676 | 215308 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 201 Montana St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 11 | Width 2ft | 5994977.25671 | 2089298.75113 | 37.7165285859022 | -122.459318680413 | (37.7165285859022, -122.459318680413) | 9 | 8 | 6 | 28861 | 24 | |||
126092 | 215309 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 201 Montana St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 11 | Width 2ft | 5994986.28741 | 2089298.56204 | 37.7165285859158 | -122.459287452364 | (37.7165285859158, -122.459287452364) | 9 | 8 | 6 | 28861 | 24 | |||
129526 | 215329 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 415 Dewey Blvd | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 15 | Width 3ft | 5995144.12297 | 2100352.21108 | 37.7468882889814 | -122.459542009073 | (37.7468882889814, -122.459542009073) | 1 | 8 | 4 | 59 | 40 | |||
27037 | 106347 | Undocumented 4 | Taxus baccata :: Irish Yew 86 | 415 DEWEY BLVD | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 5995172.1 | 2100351 | 37.7468865723154 | -122.459445180048 | (37.7468865723154, -122.459445180048) | 1 | 8 | 4 | 59 | 40 | |||||
69762 | 11201 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 100 Idora Ave | 4 | Median : Cutout | Tree | DPW 1 | 3 | 8 | 5995318.65927 | 2099418.1217 | 37.7443335470614 | -122.458870864793 | (37.7443335470614, -122.458870864793) | 1 | 8 | 4 | 59 | 40 | |||
112263 | 97298 | Permitted Site 7 | Taxus baccata :: Irish Yew 86 | 1051 Portola Dr | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 5995688.7 | 2098126.6 | 37.7408086112536 | -122.457497926865 | (37.7408086112536, -122.457497926865) | 9 | 7 | 4 | 59 | 40 | |||||
151400 | 97300 | Permitted Site 7 | Taxus baccata :: Irish Yew 86 | 1051 Portola Dr | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 5995688.7 | 2098126.6 | 37.7408086112536 | -122.457497926865 | (37.7408086112536, -122.457497926865) | 9 | 7 | 4 | 59 | 40 | |||||
3404 | 74737 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 151X Palm Ave | 6 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 6 | 3x3 | 5995889.08215 | 2113282.06845 | 37.7824331529909 | -122.457901543211 | (37.7824331529909, -122.457901543211) | 11 | 6 | 1 | 54 | 31 | ||
6245 | 75019 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 151X Palm Ave | 10 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 6 | 3x3 | 5995892.05475 | 2113163.21783 | 37.782106991639 | -122.457882656117 | (37.782106991639, -122.457882656117) | 11 | 6 | 1 | 54 | 31 | ||
113257 | 215310 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 536 Plymouth Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 10 | Width 1ft | 5995931.84882 | 2088877.77404 | 37.7154275189482 | -122.455988739984 | (37.7154275189482, -122.455988739984) | 9 | 8 | 6 | 28861 | 24 | |||
46609 | 215311 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 536 Plymouth Ave | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 10 | Width 1ft | 5995931.93989 | 2088894.46571 | 37.7154733555918 | -122.455989631214 | (37.7154733555918, -122.455989631214) | 9 | 8 | 6 | 28861 | 24 | |||
118052 | 52756 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 176@ GEARY Palm Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/04/2006 12:00:00 AM | 7 | Permit Number 48800 | 5995950.25747 | 2113100.83881 | 37.7819390591214 | -122.457676787394 | (37.7819390591214, -122.457676787394) | 11 | 6 | 1 | 54 | 31 | ||
167373 | 215302 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 698 Hearst Ave | 9 | Sidewalk: Property side : Yard | Tree | Private 2 | 15 | Width 5ft | 5996836.53539 | 2094438.39167 | 37.7307475482438 | -122.453262964135 | (37.7307475482438, -122.453262964135) | 9 | 7 | 4 | 59 | 40 | |||
149391 | 215296 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 615 Hearst Ave | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 15 | Width 5ft | 5997379.68023 | 2094370.54244 | 37.7305923666319 | -122.451380344931 | (37.7305923666319, -122.451380344931) | 9 | 7 | 4 | 28861 | 40 | |||
51255 | 215297 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 615 Hearst Ave | 5 | Sidewalk: Property side : Yard | Tree | Private 2 | 12 | Width 5ft | 5997404.12695 | 2094370.52949 | 37.7305937308948 | -122.45129582845 | (37.7305937308948, -122.45129582845) | 9 | 7 | 4 | 28861 | 40 | |||
190275 | 215305 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 100 Gennessee St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 10 | Width 1ft | 5997468.9434 | 2093863.63233 | 37.7292056228286 | -122.451035210326 | (37.7292056228286, -122.451035210326) | 9 | 7 | 4 | 28861 | 40 | |||
20747 | 215303 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 681 Joost Ave | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 15 | 5997546.26853 | 2094964.87379 | 37.7322337966419 | -122.450847264584 | (37.7322337966419, -122.450847264584) | 9 | 7 | 4 | 59 | 40 | ||||
125099 | 215304 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 681 Joost Ave | 5 | Sidewalk: Property side : Yard | Tree | Private 2 | 19 | 5997552.24164 | 2094964.50066 | 37.7322331140486 | -122.450826587399 | (37.7322331140486, -122.450826587399) | 9 | 7 | 4 | 59 | 40 | ||||
85219 | 136636 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 91 Mayfair Dr | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 10 | Width 3ft | 5997648.25188 | 2114482.46822 | 37.7858300451643 | -122.451902244894 | (37.7858300451643, -122.451902244894) | 15 | 6 | 1 | 54 | 31 | |||
44291 | 215312 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 323 Tara St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 7 | Width 3ft | 5997649.01848 | 2090038.45407 | 37.7187128880716 | -122.450137077175 | (37.7187128880716, -122.450137077175) | 9 | 8 | 6 | 28861 | 24 | |||
23410 | 215313 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 323 Tara St | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 7 | Width 3ft | 5997655.06789 | 2090049.20462 | 37.7187427527624 | -122.450116941352 | (37.7187427527624, -122.450116941352) | 9 | 8 | 6 | 28861 | 24 | |||
27119 | 215314 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 323 Tara St | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 7 | Width 3ft | 5997659.25231 | 2090057.81858 | 37.7187666441474 | -122.450103098091 | (37.7187666441474, -122.450103098091) | 9 | 8 | 6 | 28861 | 24 | |||
44958 | 136637 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 91 Mayfair Dr | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 10 | Width 3ft | 5997659.79036 | 2114483.77284 | 37.7858342881777 | -122.451862419331 | (37.7858342881777, -122.451862419331) | 15 | 6 | 1 | 54 | 31 | |||
122775 | 215315 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 323 Tara St | 6 | Sidewalk: Curb side : Yard | Tree | Private 2 | 7 | Width 3ft | 5997671.74515 | 2090080.76177 | 37.7188303557048 | -122.450061568292 | (37.7188303557048, -122.450061568292) | 9 | 8 | 6 | 28861 | 24 | |||
147312 | 215316 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 323 Tara St | 7 | Sidewalk: Curb side : Yard | Tree | Private 2 | 7 | Width 3ft | 5997674.77739 | 2090086.49914 | 37.7188462827039 | -122.45005150039 | (37.7188462827039, -122.45005150039) | 9 | 8 | 6 | 28861 | 24 | |||
24370 | 215317 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 323 Tara St | 8 | Sidewalk: Curb side : Yard | Tree | Private 2 | 7 | Width 3ft | 5997677.83985 | 2090093.68651 | 37.7188661927949 | -122.450041432477 | (37.7188661927949, -122.450041432477) | 9 | 8 | 6 | 28861 | 24 | |||
42831 | 215318 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 323 Tara St | 9 | Sidewalk: Curb side : Yard | Tree | Private 2 | 7 | Width 3ft | 5997681.5922 | 2090099.04662 | 37.7188811251298 | -122.450028848265 | (37.7188811251298, -122.450028848265) | 9 | 8 | 6 | 28861 | 24 | |||
56759 | 215319 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 323 Tara St | 10 | Sidewalk: Curb side : Yard | Tree | Private 2 | 7 | Width 3ft | 5997686.11778 | 2090106.56575 | 37.7189020298764 | -122.450013746835 | (37.7189020298764, -122.450013746835) | 9 | 8 | 6 | 28861 | 24 | |||
164736 | 136638 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 98 Blake St | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 8 | Width 3ft | 5997852.8228 | 2113221.03458 | 37.7823781953411 | -122.451103490434 | (37.7823781953411, -122.451103490434) | 15 | 6 | 1 | 54 | 31 | |||
98214 | 179796 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 1795 Cayuga Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 18 | Width 1ft | 5997861.23879 | 2088411.17322 | 37.714256892113 | -122.449286343701 | (37.714256892113, -122.449286343701) | 9 | 7 | 6 | 28861 | 25 | |||
169548 | 179797 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 1795 Cayuga Ave | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 12 | Width 1ft | 5997865.72526 | 2088414.28202 | 37.7142656847892 | -122.449271060624 | (37.7142656847892, -122.449271060624) | 9 | 7 | 6 | 28861 | 25 |
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) );