trees
164 rows where Police Districts = 6 and qCaretaker_id = 4 sorted by qCareAssistant
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
297 | 113036 | DPW Maintained 1 | Tree(s) :: 17 | 242X 07TH AVE | 1 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | 3x3 | 5993686 | 2113852 | 37.7838712122002 | -122.46556459896 | (37.7838712122002, -122.46556459896) | 11 | 6 | 2 | 54 | 11 | ||||
1119 | 113031 | DPW Maintained 1 | Quercus suber :: Cork Oak 78 | 251 06th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | 14 | 3x3 | 5993971.49407 | 2113867.66105 | 37.7839306754778 | -122.464578040665 | (37.7839306754778, -122.464578040665) | 11 | 6 | 2 | 54 | 11 | |||
8020 | 95515 | DPW Maintained 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 149 | 600X 32nd Ave | 5 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | 6 | 3x3 | 5985992.57608 | 2111969.58011 | 37.7782558903759 | -122.492041976045 | (37.7782558903759, -122.492041976045) | 11 | 6 | 2 | 55 | 26 | |||
10723 | 113037 | DPW Maintained 1 | Tree(s) :: 17 | 242X 07TH AVE | 2 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | 3x3 | 5993686 | 2113852 | 37.7838712122002 | -122.46556459896 | (37.7838712122002, -122.46556459896) | 11 | 6 | 2 | 54 | 11 | ||||
11601 | 95514 | DPW Maintained 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 149 | 600X 32nd Ave | 6 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | 02/19/2015 02:29:00 PM | 3 | 3x3 | 5985991.7561 | 2111987.56369 | 37.7783052202186 | -122.492046137036 | (37.7783052202186, -122.492046137036) | 11 | 6 | 2 | 55 | 26 | ||
16772 | 113034 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 251 06th Ave | 5 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | 2 | 3x3 | 5993975.1139 | 2113804.1265 | 37.7837564355183 | -122.464560902617 | (37.7837564355183, -122.464560902617) | 11 | 6 | 2 | 54 | 11 | |||
18625 | 113033 | DPW Maintained 1 | Lyonothamnus floribundus subsp. asplenifolius :: Santa Cruz Ironwood 33 | 251 06th Ave | 4 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | 14 | 3x3 | 5993974.82941 | 2113822.74411 | 37.7838075380241 | -122.464563239136 | (37.7838075380241, -122.464563239136) | 11 | 6 | 2 | 54 | 11 | |||
19099 | 113032 | DPW Maintained 1 | Aesculus x carnea 'Briotii' :: Ruby Horse Chestnut 205 | 251 06th Ave | 3 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | 3 | 3x3 | 5993973.41927 | 2113841.38508 | 37.7838586397785 | -122.464569471656 | (37.7838586397785, -122.464569471656) | 11 | 6 | 2 | 54 | 11 | |||
23043 | 95519 | DPW Maintained 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 149 | 600X 32nd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | 5 | 3x3 | 5985993.74648 | 2111883.31804 | 37.7780191077803 | -122.49203157445 | (37.7780191077803, -122.49203157445) | 11 | 6 | 2 | 55 | 26 | |||
38417 | 95498 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 500X 32nd Ave | 7 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | 18 | 3x3 | 5985976.05543 | 2112422.37376 | 37.7794981665366 | -122.492132474117 | (37.7794981665366, -122.492132474117) | 11 | 6 | 2 | 55 | 26 | |||
48931 | 95501 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 500X 32nd Ave | 4 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | 8 | 3x3 | 5985979.29593 | 2112362.71829 | 37.7793345591202 | -122.492116870392 | (37.7793345591202, -122.492116870392) | 11 | 6 | 2 | 55 | 26 | |||
56509 | 95507 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 600X 32nd Ave | 13 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | 10 | 3x3 | 5985983.58763 | 2112182.96811 | 37.7788412674233 | -122.492088785464 | (37.7788412674233, -122.492088785464) | 11 | 6 | 2 | 55 | 26 | |||
62037 | 95492 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 600X 32nd Ave | 6 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | 6 | 3x3 | 5986013.63252 | 2111419.06509 | 37.7767455639501 | -122.491928594276 | (37.7767455639501, -122.491928594276) | 11 | 6 | 2 | 55 | 26 | |||
66912 | 95490 | DPW Maintained 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 149 | 600X 32nd Ave | 8 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | 3 | 3x3 | 5986007.65609 | 2111463.21002 | 37.7768664240251 | -122.491952519112 | (37.7768664240251, -122.491952519112) | 11 | 6 | 2 | 55 | 26 | |||
75199 | 113039 | DPW Maintained 1 | Tree(s) :: 17 | 242X 07TH AVE | 4 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | 3x3 | 5993686 | 2113852 | 37.7838712122002 | -122.46556459896 | (37.7838712122002, -122.46556459896) | 11 | 6 | 2 | 54 | 11 | ||||
83242 | 113035 | DPW Maintained 1 | Acer buergeranum :: Trident Maple 110 | 251 06th Ave | 6 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | 1 | 3x3 | 5993975.80165 | 2113783.25834 | 37.7836991768592 | -122.464557007516 | (37.7836991768592, -122.464557007516) | 11 | 6 | 2 | 54 | 11 | |||
85468 | 95510 | Undocumented 4 | Tristaniopsis laurina :: Swamp Myrtle 1 | 500X 32nd Ave | 10 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | 02/19/2015 02:35:00 PM | 3 | 3x3 | 5985969.9 | 2112493.2 | 37.7796922752829 | -122.492158984519 | (37.7796922752829, -122.492158984519) | 11 | 6 | 2 | 55 | 26 | ||
88671 | 95484 | DPW Maintained 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 149 | 600X 32nd Ave | 15 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | 6 | 3x3 | 5986002.98697 | 2111639.37953 | 37.7773498623685 | -122.491981644298 | (37.7773498623685, -122.491981644298) | 11 | 6 | 2 | 55 | 26 | |||
89046 | 113040 | DPW Maintained 1 | Tree(s) :: 17 | 242X 07TH AVE | 5 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | 3x3 | 5993686 | 2113852 | 37.7838712122002 | -122.46556459896 | (37.7838712122002, -122.46556459896) | 11 | 6 | 2 | 54 | 11 | ||||
102251 | 95513 | DPW Maintained 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 149 | 600X 32nd Ave | 7 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | 6 | 3x3 | 5985988.88946 | 2112008.28561 | 37.7783619491242 | -122.49205757976 | (37.7783619491242, -122.49205757976) | 11 | 6 | 2 | 55 | 26 | |||
104893 | 95486 | DPW Maintained 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 149 | 600X 32nd Ave | 12 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | 3 | 3x3 | 5986007.39345 | 2111549.75354 | 37.7771040325177 | -122.491959800837 | (37.7771040325177, -122.491959800837) | 11 | 6 | 2 | 55 | 26 | |||
106937 | 95512 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 600X 32nd Ave | 8 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | 10 | 3x3 | 5985990.17986 | 2112026.52369 | 37.7784121011104 | -122.492054459017 | (37.7784121011104, -122.492054459017) | 11 | 6 | 2 | 55 | 26 | |||
110253 | 95500 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 500X 32nd Ave | 5 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | 8 | 3x3 | 5985980.30461 | 2112381.8602 | 37.7793871762895 | -122.492114790789 | (37.7793871762895, -122.492114790789) | 11 | 6 | 2 | 55 | 26 | |||
111453 | 95488 | DPW Maintained 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 149 | 600X 32nd Ave | 10 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | 6 | 3x3 | 5986007.7101 | 2111508.12486 | 37.776989750535 | -122.491955639862 | (37.776989750535, -122.491955639862) | 11 | 6 | 2 | 55 | 26 | |||
112874 | 95489 | DPW Maintained 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 149 | 600X 32nd Ave | 9 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | 6 | 3x3 | 5986007.8525 | 2111486.56221 | 37.7769305539658 | -122.491953559362 | (37.7769305539658, -122.491953559362) | 11 | 6 | 2 | 55 | 26 | |||
113363 | 95502 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 500X 32nd Ave | 3 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | 3 | 3x3 | 5985980.32699 | 2112340.5385 | 37.7792737200362 | -122.492111670045 | (37.7792737200362, -122.492111670045) | 11 | 6 | 2 | 55 | 26 | |||
117212 | 95495 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 600X 32nd Ave | 3 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | 6 | 3x3 | 5986000.95497 | 2111699.3103 | 37.7775142963957 | -122.491993087037 | (37.7775142963957, -122.491993087037) | 11 | 6 | 2 | 55 | 26 | |||
118868 | 95499 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 500X 32nd Ave | 6 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | 18 | 3x3 | 5985977.73249 | 2112402.27637 | 37.7794430828921 | -122.49212519236 | (37.7794430828921, -122.49212519236) | 11 | 6 | 2 | 55 | 26 | |||
118940 | 95491 | DPW Maintained 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 149 | 600X 32nd Ave | 7 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | 3 | 3x3 | 5986009.30138 | 2111441.61533 | 37.7768072273274 | -122.491945237383 | (37.7768072273274, -122.491945237383) | 11 | 6 | 2 | 55 | 26 | |||
123553 | 95503 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 500X 32nd Ave | 2 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | 8 | 3x3 | 5985983.49633 | 2112291.66361 | 37.7791397088392 | -122.492097106557 | (37.7791397088392, -122.492097106557) | 11 | 6 | 2 | 55 | 26 | |||
123758 | 95505 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 600X 32nd Ave | 15 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | 3 | 3x3 | 5985982.87909 | 2112248.55872 | 37.7790213190615 | -122.492096067193 | (37.7790213190615, -122.492096067193) | 11 | 6 | 2 | 55 | 26 | |||
124230 | 107423 | DPW Maintained 1 | Acer buergeranum :: Trident Maple 110 | 251 06th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | 2 | 3x3 | 5993968.46376 | 2113916.3836 | 37.7840642796834 | -122.464592063385 | (37.7840642796834, -122.464592063385) | 11 | 6 | 2 | 54 | 11 | |||
129627 | 95506 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 600X 32nd Ave | 14 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | 6 | 3X3 | 5985984.41707 | 2112207.80318 | 37.7789095059085 | -122.4920877452 | (37.7789095059085, -122.4920877452) | 11 | 6 | 2 | 55 | 26 | |||
140462 | 95497 | DPW Maintained 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 149 | 600X 32nd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | 6 | 3x3 | 5985999.23129 | 2111660.71954 | 37.7774082364223 | -122.491996207782 | (37.7774082364223, -122.491996207782) | 11 | 6 | 2 | 55 | 26 | |||
144986 | 113038 | DPW Maintained 1 | Tree(s) :: 17 | 242X 07TH AVE | 3 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | 3x3 | 5993686 | 2113852 | 37.7838712122002 | -122.46556459896 | (37.7838712122002, -122.46556459896) | 11 | 6 | 2 | 54 | 11 | ||||
145506 | 95508 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 600X 32nd Ave | 12 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | 8 | 3x3 | 5985983.44854 | 2112162.31032 | 37.7787845389083 | -122.492087745218 | (37.7787845389083, -122.492087745218) | 11 | 6 | 2 | 55 | 26 | |||
152325 | 95504 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 500X 32nd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | 3 | 3x3 | 5985982.4173 | 2112269.22924 | 37.7790780474023 | -122.492099187045 | (37.7790780474023, -122.492099187045) | 11 | 6 | 2 | 55 | 26 | |||
152853 | 95517 | DPW Maintained 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 149 | 600X 32nd Ave | 3 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | 10 | 3x3 | 5985993.99278 | 2111923.13747 | 37.778128454962 | -122.492033654936 | (37.778128454962, -122.492033654936) | 11 | 6 | 2 | 55 | 26 | |||
160497 | 95509 | DPW Maintained 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 149 | 600X 32nd Ave | 11 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | 02/19/2015 02:37:00 PM | 3 | 3x3 | 5985988.58257 | 2112092.73248 | 37.7785937981587 | -122.492064860632 | (37.7785937981587, -122.492064860632) | 11 | 6 | 2 | 55 | 26 | ||
161839 | 95485 | DPW Maintained 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 149 | 600X 32nd Ave | 13 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | 10 | 3x3 | 5986006.6183 | 2111569.83262 | 37.7771591186395 | -122.491963960946 | (37.7771591186395, -122.491963960946) | 11 | 6 | 2 | 55 | 26 | |||
166185 | 95516 | DPW Maintained 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 149 | 600X 32nd Ave | 4 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | 5 | 3x3 | 5985994.45155 | 2111944.68724 | 37.7781876512929 | -122.492033654948 | (37.7781876512929, -122.492033654948) | 11 | 6 | 2 | 55 | 26 | |||
166601 | 95494 | DPW Maintained 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 149 | 600X 32nd Ave | 4 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | 3 | 3x3 | 5986000.13497 | 2111717.29406 | 37.7775636267397 | -122.491997248036 | (37.7775636267397, -122.491997248036) | 11 | 6 | 2 | 55 | 26 | |||
177073 | 95511 | DPW Maintained 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 149 | 600X 32nd Ave | 9 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | 02/19/2015 02:32:00 PM | 3 | 3x3 | 5985988.37339 | 2112068.78219 | 37.7785280252799 | -122.492063820389 | (37.7785280252799, -122.492063820389) | 11 | 6 | 2 | 55 | 26 | ||
185821 | 95518 | DPW Maintained 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 149 | 600X 32nd Ave | 2 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | 5 | 3x3 | 5985992.05689 | 2111902.81718 | 37.7780725480885 | -122.492038855286 | (37.7780725480885, -122.492038855286) | 11 | 6 | 2 | 55 | 26 | |||
185924 | 95496 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 600X 32nd Ave | 2 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | 5 | 3x3 | 5986002.12653 | 2111683.71465 | 37.7774715436696 | -122.491987885766 | (37.7774715436696, -122.491987885766) | 11 | 6 | 2 | 55 | 26 | |||
191041 | 95487 | DPW Maintained 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 149 | 600X 32nd Ave | 11 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | 3 | 3x3 | 5986008.46306 | 2111529.36899 | 37.7770481248733 | -122.491954599624 | (37.7770481248733, -122.491954599624) | 11 | 6 | 2 | 55 | 26 | |||
194074 | 95493 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 600X 32nd Ave | 5 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | 6 | 3x3 | 5986013.17376 | 2111397.5149 | 37.7766863664514 | -122.491928594282 | (37.7766863664514, -122.491928594282) | 11 | 6 | 2 | 55 | 26 | |||
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 | ||
4799 | 95481 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 601X 30th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 03/12/2011 12:00:00 AM | 3 | 3x3 | 5986568.37611 | 2111910.32722 | 37.778126839673 | -122.490045739805 | (37.778126839673, -122.490045739805) | 11 | 6 | 2 | 55 | 26 | |
5484 | 71815 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 151X Palm Ave | 5 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 10 | 3x3 | 5995888.68435 | 2113315.23973 | 37.7825242096287 | -122.45790532062 | (37.7825242096287, -122.45790532062) | 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 | ||
6745 | 74583 | DPW Maintained 1 | Acacia baileyana 'Purpurea' :: Purple-leaf Acacia 26 | 151X Palm Ave | 4 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 01/31/2018 12:00:00 AM | 3 | 3x3 | 5995884.6031 | 2113341.96396 | 37.7825973527613 | -122.457921374418 | (37.7825973527613, -122.457921374418) | 11 | 6 | 1 | 54 | 31 | |
8399 | 95483 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 601X 30th Ave | 17 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 5 | 3x3 | 5986569.82886 | 2111856.71768 | 37.7779797279503 | -122.490036770148 | (37.7779797279503, -122.490036770148) | 11 | 6 | 2 | 55 | 26 | ||
11183 | 74883 | DPW Maintained 1 | Acacia baileyana 'Purpurea' :: Purple-leaf Acacia 26 | 151X Palm Ave | 7 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 01/31/2018 12:00:00 AM | 3 | 3x3 | 5995886.83117 | 2113252.75826 | 37.7823525456975 | -122.457907208857 | (37.7823525456975, -122.457907208857) | 11 | 6 | 1 | 54 | 31 | |
11450 | 93122 | DPW Maintained 1 | Acacia baileyana 'Purpurea' :: Purple-leaf Acacia 26 | 151X Palm Ave | 14 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 01/31/2018 12:00:00 AM | 3 | 3x3 | 5995895.24901 | 2113041.91566 | 37.7817741116959 | -122.457862824896 | (37.7817741116959, -122.457862824896) | 11 | 6 | 1 | 54 | 31 | |
11807 | 70932 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 250 23rd Ave | 2 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 14 | 5988727.46903 | 2113517.26751 | 37.7826648905872 | -122.482694534783 | (37.7826648905872, -122.482694534783) | 11 | 6 | 2 | 55 | 26 | |||
12386 | 73495 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 250 23rd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 10 | 5988730.14838 | 2113498.62278 | 37.7826138532986 | -122.482683898749 | (37.7826138532986, -122.482683898749) | 11 | 6 | 2 | 55 | 26 | |||
12599 | 93632 | DPW Maintained 1 | Acacia baileyana 'Purpurea' :: Purple-leaf Acacia 26 | 151X Palm Ave | 2 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 01/31/2018 12:00:00 AM | 3 | 3x3 | Permit Number 53266 | 5995882.07932 | 2113403.99303 | 37.7827675230466 | -122.457934595796 | (37.7827675230466, -122.457934595796) | 11 | 6 | 1 | 54 | 31 |
18070 | 99372 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 499X 29th Ave | 26 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 12 | 3x3 | 5986859.5 | 2112566.5 | 37.7799454996166 | -122.489086903101 | (37.7799454996166, -122.489086903101) | 11 | 6 | 2 | 55 | 26 | ||
18124 | 95460 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 601X 30th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 03/12/2011 12:00:00 AM | 3 | 3x3 | 5986585.7747 | 2111417.7398 | 37.7767753504668 | -122.489949313769 | (37.7767753504668, -122.489949313769) | 11 | 6 | 2 | 55 | 26 | |
23321 | 95480 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 601X 30th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 8 | 3x3 | 5986567.36684 | 2111939.07455 | 37.7782057127303 | -122.490051346189 | (37.7782057127303, -122.490051346189) | 11 | 6 | 2 | 55 | 26 | ||
23426 | 99331 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 450 30th Ave | 9 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 6 | 3x3 | 5986581.6367 | 2112796.91447 | 37.7805619300043 | -122.490065095801 | (37.7805619300043, -122.490065095801) | 11 | 6 | 2 | 55 | 26 | ||
23432 | 95461 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 601X 30th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 10 | 3x3 | 5986588.1418 | 2111391.86812 | 37.7767044523908 | -122.489939222082 | (37.7767044523908, -122.489939222082) | 11 | 6 | 2 | 55 | 26 | ||
24143 | 99344 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 450 30th Ave | 22 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 8 | 3x3 | 5986571.83486 | 2113111.88593 | 37.7814261792312 | -122.490122179259 | (37.7814261792312, -122.490122179259) | 11 | 6 | 2 | 55 | 26 | ||
28985 | 95477 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 601X 30th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 8 | 3x3 | 5986565.00775 | 2112026.27031 | 37.7784449897253 | -122.490065922262 | (37.7784449897253, -122.490065922262) | 11 | 6 | 2 | 55 | 26 | ||
32232 | 99335 | DPW Maintained 1 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 42 | 450 30th Ave | 13 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 30 | 3.5x3.5 | 5986578.25407 | 2112899.8451 | 37.780844350584 | -122.490084370963 | (37.780844350584, -122.490084370963) | 11 | 6 | 2 | 55 | 26 | ||
33247 | 99356 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 451X 29th Ave | 10 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 10 | 3x3 | 5986838.12863 | 2112989.55693 | 37.781105845983 | -122.489191947731 | (37.781105845983, -122.489191947731) | 11 | 6 | 2 | 55 | 26 | ||
33781 | 95450 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 601X 30th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 3 | 3x3 | 5986571.54012 | 2111769.53516 | 37.7777404494553 | -122.49002443627 | (37.7777404494553, -122.49002443627) | 11 | 6 | 2 | 55 | 26 | ||
34496 | 99371 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 451X 29th Ave | 25 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 10 | 3x3 | 5986853.20034 | 2112633.29686 | 37.7801285370834 | -122.489113608336 | (37.7801285370834, -122.489113608336) | 11 | 6 | 2 | 55 | 26 | ||
36069 | 99326 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 450 30th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 6 | 3x3 | 5986588.88353 | 2112653.99552 | 37.7801699385412 | -122.490029510836 | (37.7801699385412, -122.490029510836) | 11 | 6 | 2 | 55 | 26 | ||
38966 | 47201 | DPW Maintained 1 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 42 | 2801X Clement St | 3 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 05/08/2002 12:00:00 AM | 8 | 3x3 | Permit Number 45157 | 5986666.18051 | 2113215.92346 | 37.7817173456419 | -122.489803447111 | (37.7817173456419, -122.489803447111) | 11 | 6 | 2 | 55 | 26 |
40927 | 99358 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 451X 29th Ave | 12 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 8 | 3x3 | 5986838.55817 | 2112947.10039 | 37.7809892975063 | -122.489187339371 | (37.7809892975063, -122.489187339371) | 11 | 6 | 2 | 55 | 26 | ||
41997 | 95473 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 601X 30th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 6 | 3x3 | 5986560.12785 | 2112162.57896 | 37.7788189695175 | -122.490092832211 | (37.7788189695175, -122.490092832211) | 11 | 6 | 2 | 55 | 26 | ||
43418 | 99345 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 450 30th Ave | 23 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 12 | 4x4 | 5986571.27659 | 2113136.01167 | 37.7814923890114 | -122.490125885703 | (37.7814923890114, -122.490125885703) | 11 | 6 | 2 | 55 | 26 | ||
43550 | 99349 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 451X 29th Ave | 3 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 8 | 3x3 | 5986833.62785 | 2113132.91132 | 37.781499193517 | -122.489218060865 | (37.781499193517, -122.489218060865) | 11 | 6 | 2 | 55 | 26 | ||
44884 | 99367 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 451X 29th Ave | 21 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 10 | 3x3 | 5986848.24353 | 2112713.43374 | 37.7803482808136 | -122.489136649255 | (37.7803482808136, -122.489136649255) | 11 | 6 | 2 | 55 | 26 | ||
44906 | 95475 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 601X 30th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 3 | 3x3 | 5986561.73612 | 2112070.55828 | 37.7785664008394 | -122.490080498329 | (37.7785664008394, -122.490080498329) | 11 | 6 | 2 | 55 | 26 | ||
46093 | 95466 | Undocumented 4 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 529X 30th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 5 | 3x3 | 5986555.1 | 2112324.8 | 37.7792640886788 | -122.490122160768 | (37.7792640886788, -122.490122160768) | 11 | 6 | 2 | 55 | 26 | ||
46265 | 95452 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 601X 30th Ave | 4 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 6 | 3x3 | 5986573.32223 | 2111731.41091 | 37.7776358751612 | -122.490015466607 | (37.7776358751612, -122.490015466607) | 11 | 6 | 2 | 55 | 26 | ||
49808 | 99350 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 451X 29th Ave | 4 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 10 | 3x3 | 5986835.93382 | 2113116.06056 | 37.7814530607414 | -122.489208844148 | (37.7814530607414, -122.489208844148) | 11 | 6 | 2 | 55 | 26 | ||
51466 | 95482 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 601X 30th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 3 | 3x3 | 5986568.36529 | 2111879.34223 | 37.7780417630679 | -122.490043497613 | (37.7780417630679, -122.490043497613) | 11 | 6 | 2 | 55 | 26 | ||
51914 | 95459 | Undocumented 4 | Corymbia ficifolia :: Red Flowering Gum 28 | 657X 30th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 18 | 3x3 | 5986588.2 | 2111449.2 | 37.776861872872 | -122.489943238472 | (37.776861872872, -122.489943238472) | 11 | 6 | 2 | 55 | 26 | ||
53024 | 99347 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 451X 29th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 3 | 3x3 | 5986832.70752 | 2113173.16715 | 37.7816096708126 | -122.489224205331 | (37.7816096708126, -122.489224205331) | 11 | 6 | 2 | 55 | 26 | ||
54458 | 95149 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 250 23rd Ave | 5 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 15 | 5988721.12033 | 2113580.38159 | 37.7828378146839 | -122.482721124929 | (37.7828378146839, -122.482721124929) | 11 | 6 | 2 | 55 | 26 | |||
55540 | 60316 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 450 30th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 10/07/1982 12:00:00 AM | 8 | 4x4 | 5986588.61699 | 2112633.05068 | 37.7801124144217 | -122.490028891926 | (37.7801124144217, -122.490028891926) | 11 | 6 | 2 | 55 | 26 | |
57556 | 99341 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 450 30th Ave | 19 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 24 | 4x5 | 5986573.71046 | 2113038.86406 | 37.7812257915862 | -122.49011031791 | (37.7812257915862, -122.49011031791) | 11 | 6 | 2 | 55 | 26 | ||
58702 | 95478 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 601X 30th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 6 | 3x3 | 5986565.85749 | 2112005.2728 | 37.7783873861575 | -122.490061437886 | (37.7783873861575, -122.490061437886) | 11 | 6 | 2 | 55 | 26 | ||
58967 | 95156 | DPW Maintained 1 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 71 | 250 23rd Ave | 12 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 21 | 5988717.78601 | 2113765.0163 | 37.7833445754979 | -122.482746195108 | (37.7833445754979, -122.482746195108) | 11 | 6 | 2 | 55 | 26 | |||
63809 | 99258 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 151X Palm Ave | 9 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 5 | 3x3 | 5995889.58772 | 2113188.82138 | 37.7821771504315 | -122.45789304424 | (37.7821771504315, -122.45789304424) | 11 | 6 | 1 | 54 | 31 | ||
64192 | 99336 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 450 30th Ave | 14 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 3 | 3x3 | 5986577.60051 | 2112919.49158 | 37.7808982560395 | -122.490088077428 | (37.7808982560395, -122.490088077428) | 11 | 6 | 2 | 55 | 26 | ||
69455 | 99362 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 451X 29th Ave | 16 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 6 | 3x3 | 5986843.02407 | 2112864.76375 | 37.7807634852432 | -122.489165834601 | (37.7807634852432, -122.489165834601) | 11 | 6 | 2 | 55 | 26 | ||
69617 | 95465 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 601X 30th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 8 | 3x3 | 5986594.5418 | 2111220.34134 | 37.7762338621769 | -122.489904464478 | (37.7762338621769, -122.489904464478) | 11 | 6 | 2 | 55 | 26 | ||
70160 | 95470 | Undocumented 4 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 539X 30th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 4 | 3x3 | 5986557.7 | 2112257.8 | 37.7790802775989 | -122.490108236864 | (37.7790802775989, -122.490108236864) | 11 | 6 | 2 | 55 | 26 | ||
71210 | 95454 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 601X 30th Ave | 6 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 6 | 3x3 | 5986556.01855 | 2112243.67907 | 37.7790414073553 | -122.490113014651 | (37.7790414073553, -122.490113014651) | 11 | 6 | 2 | 55 | 26 | ||
71997 | 99370 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 451X 29th Ave | 24 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 6 | 3x3 | 5986851.72562 | 2112647.47743 | 37.7801673868145 | -122.489119752829 | (37.7801673868145, -122.489119752829) | 11 | 6 | 2 | 55 | 26 | ||
72163 | 95154 | DPW Maintained 1 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 71 | 250 23rd Ave | 10 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 20 | 5988718.8555 | 2113711.85504 | 37.7831986719098 | -122.48273859805 | (37.7831986719098, -122.48273859805) | 11 | 6 | 2 | 55 | 26 | |||
74212 | 93121 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 151X Palm Ave | 11 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 9 | 3x3 | 5995892.67419 | 2113127.59534 | 37.7820092173573 | -122.457877934554 | (37.7820092173573, -122.457877934554) | 11 | 6 | 1 | 54 | 31 | ||
75748 | 47199 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 450 30th Ave | 6 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 05/08/2002 12:00:00 AM | 8 | 4x4 | Permit Number 45157 | 5986584.12235 | 2112732.41489 | 37.7803849777225 | -122.490051751347 | (37.7803849777225, -122.490051751347) | 11 | 6 | 2 | 55 | 26 |
75990 | 99332 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 450 30th Ave | 10 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 8 | 4x4 | 5986580.56369 | 2112816.99686 | 37.7806170078534 | -122.490070285368 | (37.7806170078534, -122.490070285368) | 11 | 6 | 2 | 55 | 26 | ||
77215 | 99354 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 451X 29th Ave | 8 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 8 | 3x3 | 5986839.80551 | 2113026.66255 | 37.7812078253097 | -122.489188875507 | (37.7812078253097, -122.489188875507) | 11 | 6 | 2 | 55 | 26 |
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) );