Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, qSiteInfo, PlantType, qCaretaker, PlantDate, DBH, PlotSize, PermitNotes
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress ▼ | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 26085 | 26085 | 121888 | Undocumented 2 | Podocarpus macrophyllus :: Yew Pine 168 | 10 17th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 9 | Width 2ft | 5990543.39906 | 2115002.75523 | 37.786849107740395 | -122.476520812684 | (37.7868491077404, -122.476520812684) | |||
| 13246 | 13246 | 187614 | Undocumented 2 | Podocarpus macrophyllus :: Yew Pine 168 | 100 Castro St | 11 | Sidewalk: Property side : Cutout 5 | Tree 1 | DPW 2 | 3x3 | 6002192.0 | 2107639.0 | 37.767298794762 | -122.43569238083799 | (37.767298794762, -122.435692380838) | ||||
| 13247 | 13247 | 187613 | Undocumented 2 | Podocarpus macrophyllus :: Yew Pine 168 | 100 Castro St | 10 | Sidewalk: Property side : Cutout 5 | Tree 1 | DPW 2 | 3x3 | 6002192.0 | 2107639.0 | 37.767298794762 | -122.43569238083799 | (37.767298794762, -122.435692380838) | ||||
| 13248 | 13248 | 187615 | Undocumented 2 | Podocarpus macrophyllus :: Yew Pine 168 | 100 Castro St | 12 | Sidewalk: Property side : Cutout 5 | Tree 1 | DPW 2 | 3x3 | 6002192.0 | 2107639.0 | 37.767298794762 | -122.43569238083799 | (37.767298794762, -122.435692380838) | ||||
| 13249 | 13249 | 187612 | Undocumented 2 | Podocarpus macrophyllus :: Yew Pine 168 | 100 Castro St | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | DPW 2 | 3x3 | 6002192.0 | 2107639.0 | 37.767298794762 | -122.43569238083799 | (37.767298794762, -122.435692380838) | ||||
| 12731 | 12731 | 38212 | Permitted Site 1 | Podocarpus macrophyllus :: Yew Pine 168 | 108 Wayland St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/17/1998 12:00:00 AM | 8 | 3x3 | Permit Number 40335 | 6011170.868009999 | 2092548.53605 | 37.726369572089894 | -122.403573737557 | (37.7263695720899, -122.403573737557) |
| 18537 | 18537 | 17028 | Permitted Site 1 | Podocarpus macrophyllus :: Yew Pine 168 | 1140 Oak St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 6001519.83997 | 2109777.5071900003 | 37.7731324020756 | -122.438170492981 | (37.7731324020756, -122.438170492981) | |||
| 182029 | 182029 | 234858 | Undocumented 2 | Podocarpus macrophyllus :: Yew Pine 168 | 115 Winfield St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 2ft | 6007085.582140001 | 2098738.0087099997 | 37.743135459435 | -122.41813502591002 | (37.743135459435, -122.41813502591) | |||
| 19579 | 19579 | 17029 | Permitted Site 1 | Podocarpus macrophyllus :: Yew Pine 168 | 1153 Oak St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 6001512.0667 | 2109715.9891 | 37.772963046680395 | -122.438192973878 | (37.7729630466804, -122.438192973878) | |||
| 17619 | 17619 | 17030 | Permitted Site 1 | Podocarpus macrophyllus :: Yew Pine 168 | 1159 Oak St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 6001449.2469 | 2109707.3473 | 37.772935745446404 | -122.438409655481 | (37.7729357454464, -122.438409655481) | |||
| 182921 | 182921 | 234863 | Undocumented 2 | Podocarpus macrophyllus :: Yew Pine 168 | 116 Winfield St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6007043.4928 | 2098718.4405900002 | 37.7430793606347 | -122.418279172852 | (37.7430793606347, -122.418279172852) | |||
| 171566 | 171566 | 234855 | Undocumented 2 | Podocarpus macrophyllus :: Yew Pine 168 | 118 Andover St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6007577.520219999 | 2098081.02135 | 37.7413591949664 | -122.41638750560301 | (37.7413591949664, -122.416387505603) | |||
| 61982 | 61982 | 234857 | Undocumented 2 | Podocarpus macrophyllus :: Yew Pine 168 | 125 Winfield St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 2ft | 6007057.29918 | 2098677.05689 | 37.74296650740129 | -122.418228500567 | (37.7429665074013, -122.418228500567) | |||
| 33293 | 33293 | 186732 | Undocumented 2 | Podocarpus macrophyllus :: Yew Pine 168 | 1250 Sunset Blvd | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 0ft | 5984876.9467 | 2106397.7058 | 37.762891830958296 | -122.49549023544701 | (37.7628918309583, -122.495490235447) | |||
| 62788 | 62788 | 186734 | Undocumented 2 | Podocarpus macrophyllus :: Yew Pine 168 | 1250 Sunset Blvd | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 0ft | 5984876.1357 | 2106411.4914 | 37.7629296348625 | -122.495494057173 | (37.7629296348625, -122.495494057173) | |||
| 43734 | 43734 | 184345 | Undocumented 2 | Podocarpus macrophyllus :: Yew Pine 168 | 1251 Sunset Blvd | 17 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 0ft | 5984653.0421 | 2106395.6187 | 37.7628729870585 | -122.496264477961 | (37.7628729870585, -122.496264477961) | |||
| 185748 | 185748 | 212847 | Undocumented 2 | Podocarpus macrophyllus :: Yew Pine 168 | 1269 02nd Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 5995455.86214 | 2106863.98273 | 37.7647858787024 | -122.45893544780701 | (37.7647858787024, -122.458935447807) | |||
| 55292 | 55292 | 234854 | Undocumented 2 | Podocarpus macrophyllus :: Yew Pine 168 | 130 Andover St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6007573.33331 | 2098019.6233599996 | 37.7411903742509 | -122.41639763464799 | (37.7411903742509, -122.416397634648) | |||
| 169930 | 169930 | 184767 | Undocumented 2 | Podocarpus macrophyllus :: Yew Pine 168 | 1301 Sunset Blvd | 24 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 0ft | 5984672.982999999 | 2106076.3882 | 37.7619976377511 | -122.496171956525 | (37.7619976377511, -122.496171956525) | |||
| 171989 | 171989 | 184772 | Undocumented 2 | Podocarpus macrophyllus :: Yew Pine 168 | 1301 Sunset Blvd | 32 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 0ft | 5984713.9927 | 2106010.1272 | 37.7618181056778 | -122.49602523353201 | (37.7618181056778, -122.496025233532) | |||
| 65840 | 65840 | 97111 | Permitted Site 1 | Podocarpus macrophyllus :: Yew Pine 168 | 1345 Noriega St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Permit Number 18860 | 5989755.1906 | 2103082.2788 | 37.754072995002204 | -122.47837582871401 | (37.7540729950022, -122.478375828714) | |||
| 91939 | 91939 | 122722 | Undocumented 2 | Podocarpus macrophyllus :: Yew Pine 168 | 1385 Natoma St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 3x3 | 6007219.0 | 2107431.0 | 37.76701193031621 | -122.41828991357599 | (37.7670119303162, -122.418289913576) | |||
| 28979 | 28979 | 181504 | Undocumented 2 | Podocarpus macrophyllus :: Yew Pine 168 | 1400 Sunset Blvd | 65 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 0ft | 5984912.3363 | 2105486.7577 | 37.76039269442371 | -122.49530065358499 | (37.7603926944237, -122.495300653585) | |||
| 38450 | 38450 | 181510 | Undocumented 2 | Podocarpus macrophyllus :: Yew Pine 168 | 1400 Sunset Blvd | 70 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 0ft | 5984861.096 | 2105522.4031 | 37.7604875665076 | -122.495480496405 | (37.7604875665076, -122.495480496405) | |||
| 50110 | 50110 | 181518 | Undocumented 2 | Podocarpus macrophyllus :: Yew Pine 168 | 1400 Sunset Blvd | 78 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 0ft | 5984884.7668 | 2105589.5167 | 37.7606732277268 | -122.495403580994 | (37.7606732277268, -122.495403580994) | |||
| 28162 | 28162 | 186644 | Undocumented 2 | Podocarpus macrophyllus :: Yew Pine 168 | 1401 Sunset Blvd | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 0ft | 5984678.2391 | 2105602.2274 | 37.76069603285129 | -122.496118794235 | (37.7606960328513, -122.496118794235) | |||
| 60069 | 60069 | 186693 | Undocumented 2 | Podocarpus macrophyllus :: Yew Pine 168 | 1401 Sunset Blvd | 50 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 0ft | 5984710.8996 | 2105238.1471 | 37.7596982830602 | -122.49597897832399 | (37.7596982830602, -122.495978978324) | |||
| 66894 | 66894 | 186651 | Undocumented 2 | Podocarpus macrophyllus :: Yew Pine 168 | 1401 Sunset Blvd | 8 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 0ft | 5984693.4179 | 2105580.4538 | 37.7606371377004 | -122.49606469199 | (37.7606371377004, -122.49606469199) | |||
| 69316 | 69316 | 186690 | Undocumented 2 | Podocarpus macrophyllus :: Yew Pine 168 | 1401 Sunset Blvd | 47 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 0ft | 5984746.4911 | 2105269.5514 | 37.759786595015704 | -122.495858203478 | (37.7597865950157, -122.495858203478) | |||
| 185531 | 185531 | 186659 | Undocumented 2 | Podocarpus macrophyllus :: Yew Pine 168 | 1401 Sunset Blvd | 16 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 0ft | 5984689.126 | 2105565.0657 | 37.7605946348949 | -122.49607840021002 | (37.7605946348949, -122.49607840021) | |||
| 13160 | 13160 | 91380 | DPW Maintained 3 | Podocarpus macrophyllus :: Yew Pine 168 | 1421 Taraval St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/19/2015 01:27:00 PM | 3 | 3x3 | Permit Number 52077 | 5988771.9062 | 2098963.627 | 37.742707136361105 | -122.48147460973699 | (37.7427071363611, -122.481474609737) | |
| 53954 | 53954 | 47883 | Permitted Site 1 | Podocarpus macrophyllus :: Yew Pine 168 | 1422 45th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/11/2006 12:00:00 AM | 5 | Permit Number 45630 | 5982178.8025 | 2105387.2339 | 37.7599590039895 | -122.504747143589 | (37.7599590039895, -122.504747143589) | |
| 161191 | 161191 | 184192 | Undocumented 2 | Podocarpus macrophyllus :: Yew Pine 168 | 1426 38th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 0ft | 5984302.3594 | 2105559.8646 | 37.7605576926871 | -122.497415645594 | (37.7605576926871, -122.497415645594) | |||
| 60903 | 60903 | 135662 | Undocumented 2 | Podocarpus macrophyllus :: Yew Pine 168 | 1430 Francisco St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6004430.55292 | 2120513.3454 | 37.802775426403606 | -122.42886748667101 | (37.8027754264036, -122.428867486671) | |||
| 49392 | 49392 | 49889 | Permitted Site 1 | Podocarpus macrophyllus :: Yew Pine 168 | 1430@ OCTAVIA Francisco St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/01/2003 12:00:00 AM | 6 | Permit Number 46660 | 6004450.34869 | 2120515.08924 | 37.8027813349583 | -122.42879910759599 | (37.8027813349583, -122.428799107596) | |
| 10804 | 10804 | 93408 | DPW Maintained 3 | Podocarpus macrophyllus :: Yew Pine 168 | 1440 Taraval St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/19/2015 03:17:00 PM | 3 | 3x3 | 5988695.7955 | 2099025.5303 | 37.7428726808967 | -122.48174230877899 | (37.7428726808967, -122.481742308779) | ||
| 52703 | 52703 | 234862 | Undocumented 2 | Podocarpus macrophyllus :: Yew Pine 168 | 147 Andover St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6007596.66098 | 2097957.46338 | 37.741021008521 | -122.41631257406 | (37.741021008521, -122.41631257406) | |||
| 160567 | 160567 | 139412 | Undocumented 2 | Podocarpus macrophyllus :: Yew Pine 168 | 1500 GEARY BLVD | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 0ft | 6004126.3357 | 2114029.8613 | 37.784956209303395 | -122.429457598073 | (37.7849562093034, -122.429457598073) | |||
| 173730 | 173730 | 186617 | Undocumented 2 | Podocarpus macrophyllus :: Yew Pine 168 | 1501 Sunset Blvd | 88 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 0ft | 5984770.9865 | 2104379.1354 | 37.757343195198004 | -122.495707807467 | (37.757343195198, -122.495707807467) | |||
| 56749 | 56749 | 234865 | Undocumented 2 | Podocarpus macrophyllus :: Yew Pine 168 | 152 Beaver St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | Width 1ft | 6001951.81755 | 2106805.77476 | 37.7649973174046 | -122.43646349341299 | (37.7649973174046, -122.436463493413) | |||
| 96882 | 96882 | 55827 | Permitted Site 1 | Podocarpus macrophyllus :: Yew Pine 168 | 154 11th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/09/1973 12:00:00 AM | 10 | 3x3 | Permit Number 11876 | 5992447.89997 | 2114435.52315 | 37.785401918703606 | -122.469890426632 | (37.7854019187036, -122.469890426632) | |
| 90439 | 90439 | 8411 | DPW Maintained 3 | Podocarpus macrophyllus :: Yew Pine 168 | 1570 Geary Blvd | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 6004211.027185 | 2114032.026709 | 37.7849669496355 | -122.42916474711001 | (37.7849669496355, -122.42916474711) | |||
| 85518 | 85518 | 8412 | DPW Maintained 3 | Podocarpus macrophyllus :: Yew Pine 168 | 1590X Geary Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 6004120.4992681 | 2114020.0804586997 | 37.784929023116796 | -122.429477092496 | (37.7849290231168, -122.429477092496) | |||
| 145761 | 145761 | 8413 | DPW Maintained 3 | Podocarpus macrophyllus :: Yew Pine 168 | 1590X Geary Blvd | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 6004120.4992681 | 2114020.0804586997 | 37.784929023116796 | -122.429477092496 | (37.7849290231168, -122.429477092496) | |||
| 76142 | 76142 | 234859 | Undocumented 2 | Podocarpus macrophyllus :: Yew Pine 168 | 160 Carnelian Way | 1 | : Yard 23 | Tree 1 | Private 1 | 8 | 6000570.21064 | 2100519.3738 | 37.7476577875765 | -122.44079113720801 | (37.7476577875765, -122.440791137208) | ||||
| 150305 | 150305 | 234860 | Undocumented 2 | Podocarpus macrophyllus :: Yew Pine 168 | 160 Carnelian Way | 2 | : Yard 23 | Tree 1 | Private 1 | 6 | 6000574.359 | 2100517.55086 | 37.7476530184698 | -122.44077666170799 | (37.7476530184698, -122.440776661708) | ||||
| 188608 | 188608 | 139128 | Undocumented 2 | Podocarpus macrophyllus :: Yew Pine 168 | 1601 POST ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 0ft | 6004473.6733 | 2114291.0091 | 37.7856929151772 | -122.428274539531 | (37.7856929151772, -122.428274539531) | |||
| 24600 | 24600 | 234864 | Undocumented 2 | Podocarpus macrophyllus :: Yew Pine 168 | 161 Beaver St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 3ft | 6001880.22394 | 2106835.6082900004 | 37.7650751645184 | -122.43671325313998 | (37.7650751645184, -122.43671325314) | |||
| 42841 | 42841 | 178684 | Undocumented 2 | Podocarpus macrophyllus :: Yew Pine 168 | 161 Delta St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6009805.30528 | 2088917.07553 | 37.716321963062 | -122.40803845872401 | (37.716321963062, -122.408038458724) | |||
| 58090 | 58090 | 178683 | Undocumented 2 | Podocarpus macrophyllus :: Yew Pine 168 | 161 Delta St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6009800.07713 | 2088901.3026400001 | 37.7162783612237 | -122.408055418121 | (37.7162783612237, -122.408055418121) | |||
| 93139 | 93139 | 18222 | DPW Maintained 3 | Podocarpus macrophyllus :: Yew Pine 168 | 1643X Post St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/02/1991 12:00:00 AM | 6 | 3X3 | 6004309.242075901 | 2114268.2781924 | 37.7856211964399 | -122.428841803498 | (37.7856211964399, -122.428841803498) | ||
| 21894 | 21894 | 17095 | Permitted Site 1 | Podocarpus macrophyllus :: Yew Pine 168 | 1661 Oak St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 3X3 | 5999030.0966 | 2109360.6125 | 37.7718458009941 | -122.446752800648 | (37.7718458009941, -122.446752800648) | |||
| 103208 | 103208 | 18224 | DPW Maintained 3 | Podocarpus macrophyllus :: Yew Pine 168 | 1675 Post St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6004164.0306229 | 2114246.6470389 | 37.7855535827521 | -122.429342650039 | (37.7855535827521, -122.429342650039) | |||
| 39854 | 39854 | 55830 | Permitted Site 1 | Podocarpus macrophyllus :: Yew Pine 168 | 170 11th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/09/1973 12:00:00 AM | 7 | Permit Number 11879 | 5992452.285209999 | 2114337.35562 | 37.7851326311765 | -122.469868105299 | (37.7851326311765, -122.469868105299) | ||
| 58154 | 58154 | 195951 | Undocumented 2 | Podocarpus macrophyllus :: Yew Pine 168 | 1700 Bancroft Ave | 12 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 2 | Width 10ft | 6013796.32813 | 2092612.6576200002 | 37.7266919421623 | -122.39450206474 | (37.7266919421623, -122.39450206474) | |||
| 154226 | 154226 | 195949 | Undocumented 2 | Podocarpus macrophyllus :: Yew Pine 168 | 1700 Bancroft Ave | 7 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 2 | Width 10ft | 6013845.649730001 | 2092576.4103400002 | 37.72659515624 | -122.394329023477 | (37.72659515624, -122.394329023477) | |||
| 171830 | 171830 | 195952 | Undocumented 2 | Podocarpus macrophyllus :: Yew Pine 168 | 1700 Bancroft Ave | 14 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 10ft | 6013787.58166 | 2092619.66724 | 37.7267107029201 | -122.39453279185801 | (37.7267107029201, -122.394532791858) | |||
| 183634 | 183634 | 195950 | Undocumented 2 | Podocarpus macrophyllus :: Yew Pine 168 | 1700 Bancroft Ave | 9 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 10ft | 6013817.51149 | 2092596.07971 | 37.726647600184 | -122.394427673718 | (37.726647600184, -122.394427673718) | |||
| 23297 | 23297 | 17101 | DPW Maintained 3 | Podocarpus macrophyllus :: Yew Pine 168 | 1711 Oak St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 8 | 3X3 | 5998684.4523 | 2109317.8876 | 37.771708738288105 | -122.447945326623 | (37.7717087382881, -122.447945326623) | |||
| 11867 | 11867 | 93415 | DPW Maintained 3 | Podocarpus macrophyllus :: Yew Pine 168 | 1716 Taraval St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/23/2015 06:26:00 PM | 3 | 3x3 | 5987861.1638 | 2098998.3872 | 37.7427495822889 | -122.48462620565901 | (37.7427495822889, -122.484626205659) | ||
| 11729 | 11729 | 93414 | DPW Maintained 3 | Podocarpus macrophyllus :: Yew Pine 168 | 1722 Taraval St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/19/2015 03:10:00 PM | 3 | 3x3 | 5987827.66 | 2098999.0640000002 | 37.7427494893985 | -122.484742100445 | (37.7427494893985, -122.484742100445) | ||
| 150054 | 150054 | 139139 | Undocumented 2 | Podocarpus macrophyllus :: Yew Pine 168 | 1730 GEARY BLVD | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 0ft | 6003434.4937 | 2113953.4325 | 37.784707160370296 | -122.43184568933998 | (37.7847071603703, -122.43184568934) | |||
| 2062 | 2062 | 8436 | Permitted Site 1 | Podocarpus macrophyllus :: Yew Pine 168 | 1730 Geary Blvd | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/28/1997 12:00:00 AM | 11 | 3X3 | 6003412.8094 | 2113950.8814 | 37.784698926436796 | -122.431920527552 | (37.7846989264368, -122.431920527552) | ||
| 8545 | 8545 | 8434 | Permitted Site 1 | Podocarpus macrophyllus :: Yew Pine 168 | 1730 Geary Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/28/1997 12:00:00 AM | 12 | 3X3 | 6003465.1068 | 2113959.1725 | 37.784724656301705 | -122.4317401882 | (37.7847246563017, -122.4317401882) | ||
| 68838 | 68838 | 106982 | DPW Maintained 3 | Podocarpus macrophyllus :: Yew Pine 168 | 1737-1795 Post St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 10 | 6003656.2329 | 2114175.7467 | 37.7853301466286 | -122.431094418652 | (37.7853301466286, -122.431094418652) | ||||
| 20032 | 20032 | 17103 | Permitted Site 1 | Podocarpus macrophyllus :: Yew Pine 168 | 1745 Oak St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 5998656.2538 | 2109314.8969 | 37.7716989147196 | -122.44804265122801 | (37.7716989147196, -122.448042651228) | |||
| 83387 | 83387 | 23889 | DPW Maintained 3 | Podocarpus macrophyllus :: Yew Pine 168 | 1750X Geary Blvd | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 6003201.67908 | 2113890.07748 | 37.7845200030062 | -122.43264662292299 | (37.7845200030062, -122.432646622923) | |||
| 127916 | 127916 | 23888 | DPW Maintained 3 | Podocarpus macrophyllus :: Yew Pine 168 | 1750X Geary Blvd | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 6003201.67908 | 2113890.07748 | 37.7845200030062 | -122.43264662292299 | (37.7845200030062, -122.432646622923) | |||
| 56065 | 56065 | 139135 | Undocumented 2 | Podocarpus macrophyllus :: Yew Pine 168 | 1825 POST ST | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 0ft | 6003465.1068 | 2114153.0556 | 37.785257010462 | -122.43175403601299 | (37.785257010462, -122.431754036013) | |||
| 148492 | 148492 | 139132 | Undocumented 2 | Podocarpus macrophyllus :: Yew Pine 168 | 1825 POST ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 0ft | 6003396.2273 | 2114143.489 | 37.7852268383201 | -122.431991654473 | (37.7852268383201, -122.431991654473) | |||
| 153017 | 153017 | 139131 | Undocumented 2 | Podocarpus macrophyllus :: Yew Pine 168 | 1825 POST ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | Width 0ft | 6003318.4189 | 2114130.7336 | 37.78518740379629 | -122.432259936138 | (37.7851874037963, -122.432259936138) | |||
| 6315 | 6315 | 18251 | Permitted Site 1 | Podocarpus macrophyllus :: Yew Pine 168 | 1825 Post St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 6003359.8742 | 2114137.1113 | 37.7852072657709 | -122.432116969328 | (37.7852072657709, -122.432116969328) | |||
| 93885 | 93885 | 18250 | DPW Maintained 3 | Podocarpus macrophyllus :: Yew Pine 168 | 1825 Post St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6003354.45468 | 2114131.31985 | 37.7851910566456 | -122.432135305453 | (37.7851910566456, -122.432135305453) | |||
| 120388 | 120388 | 93418 | DPW Maintained 3 | Podocarpus macrophyllus :: Yew Pine 168 | 1850 TARAVAL ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/19/2015 01:30:00 PM | 3 | 3x3 | 5987496.0 | 2098972.0 | 37.742655857366294 | -122.485886885578 | (37.7426558573663, -122.485886885578) | ||
| 95995 | 95995 | 18257 | Permitted Site 1 | Podocarpus macrophyllus :: Yew Pine 168 | 1855 Post St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 3x3 | 6003300.7323900005 | 2114129.45265 | 37.785182883793794 | -122.432321034429 | (37.7851828837938, -122.432321034429) | |||
| 122318 | 122318 | 18258 | Permitted Site 1 | Podocarpus macrophyllus :: Yew Pine 168 | 1855 Post St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3x3 | 6003321.44909 | 2114132.20192 | 37.785191607243206 | -122.43224955752501 | (37.7851916072432, -122.432249557525) | |||
| 146776 | 146776 | 139148 | Undocumented 2 | Podocarpus macrophyllus :: Yew Pine 168 | 1865 POST ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 0ft | 6003273.137 | 2114121.8047 | 37.7851603197126 | -122.43241595943 | (37.7851603197126, -122.43241595943) | |||
| 179998 | 179998 | 139149 | Undocumented 2 | Podocarpus macrophyllus :: Yew Pine 168 | 1865 POST ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 0ft | 6003298.6479 | 2114126.9069 | 37.7851757756125 | -122.43232806423201 | (37.7851757756125, -122.432328064232) | |||
| 97218 | 97218 | 122540 | Undocumented 2 | Podocarpus macrophyllus :: Yew Pine 168 | 188 Winfield St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 20 | 3x3 | 6006859.0 | 2098426.0 | 37.742265997424504 | -122.418896364118 | (37.7422659974245, -122.418896364118) | |||
| 27987 | 27987 | 139151 | Undocumented 2 | Podocarpus macrophyllus :: Yew Pine 168 | 1881 POST ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 0ft | 6003144.9445 | 2114104.5849 | 37.7851057685851 | -122.43285823467801 | (37.7851057685851, -122.432858234678) | |||
| 30095 | 30095 | 139152 | Undocumented 2 | Podocarpus macrophyllus :: Yew Pine 168 | 1881 POST ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 0ft | 6003164.7154 | 2114107.1359 | 37.7851138943196 | -122.432790015912 | (37.7851138943196, -122.432790015912) | |||
| 49412 | 49412 | 139153 | Undocumented 2 | Podocarpus macrophyllus :: Yew Pine 168 | 1881 POST ST | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 0ft | 6003212.5485 | 2114113.5137 | 37.785134118902 | -122.432624984211 | (37.785134118902, -122.432624984211) | |||
| 148476 | 148476 | 139150 | Undocumented 2 | Podocarpus macrophyllus :: Yew Pine 168 | 1881 POST ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 0ft | 6003125.8113 | 2114100.7582 | 37.785094176231105 | -122.432924156018 | (37.7850941762311, -122.432924156018) | |||
| 174573 | 174573 | 139154 | Undocumented 2 | Podocarpus macrophyllus :: Yew Pine 168 | 1881 POST ST | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 0ft | 6003238.0594 | 2114116.0648 | 37.7851425702811 | -122.432536906804 | (37.7851425702811, -122.432536906804) | |||
| 87801 | 87801 | 18262 | Permitted Site 1 | Podocarpus macrophyllus :: Yew Pine 168 | 1895X Post St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3x3 | 6003118.209290001 | 2114097.1727299998 | 37.785083900253 | -122.43295020031799 | (37.785083900253, -122.432950200318) | |||
| 91862 | 91862 | 18263 | Permitted Site 1 | Podocarpus macrophyllus :: Yew Pine 168 | 1895X Post St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 6003138.05675 | 2114098.29377 | 37.7850881040741 | -122.43288161451599 | (37.7850881040741, -122.432881614516) | |||
| 92742 | 92742 | 18267 | Permitted Site 1 | Podocarpus macrophyllus :: Yew Pine 168 | 1895X Post St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 6003219.29534 | 2114110.16008 | 37.785125293322295 | -122.432601402633 | (37.7851252933223, -122.432601402633) | |||
| 98507 | 98507 | 18266 | Permitted Site 1 | Podocarpus macrophyllus :: Yew Pine 168 | 1895X Post St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 6003196.88425 | 2114105.80464 | 37.7851120634301 | -122.43267862671301 | (37.7851120634301, -122.432678626713) | |||
| 114048 | 114048 | 18265 | DPW Maintained 3 | Podocarpus macrophyllus :: Yew Pine 168 | 1895X Post St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6003117.8494065 | 2114102.4449837 | 37.785098356117004 | -122.432951822199 | (37.785098356117, -122.432951822199) | |||
| 115725 | 115725 | 18264 | Permitted Site 1 | Podocarpus macrophyllus :: Yew Pine 168 | 1895X Post St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 6003157.167280001 | 2114102.73742 | 37.785101389107496 | -122.432815815695 | (37.7851013891075, -122.432815815695) | |||
| 118975 | 118975 | 18268 | Permitted Site 1 | Podocarpus macrophyllus :: Yew Pine 168 | 1895X Post St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 6003251.63015 | 2114115.07604 | 37.7851406249551 | -122.43248988562401 | (37.7851406249551, -122.432489885624) | |||
| 73670 | 73670 | 135656 | Undocumented 2 | Podocarpus macrophyllus :: Yew Pine 168 | 1920 Beach St | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 6ft | 6001020.2424800005 | 2121027.2609 | 37.8039928872331 | -122.440705754666 | (37.8039928872331, -122.440705754666) | |||
| 186707 | 186707 | 244545 | Undocumented 2 | Podocarpus macrophyllus :: Yew Pine 168 | 1921 Oak St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 0ft | 5997768.4306 | 2109193.5582 | 37.771314959230295 | -122.45110492040001 | (37.7713149592303, -122.4511049204) | |||
| 21215 | 21215 | 17119 | Permitted Site 1 | Podocarpus macrophyllus :: Yew Pine 168 | 1931 Oak St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 3X3 | 5997738.0959 | 2109188.8584 | 37.7713003179936 | -122.451209509969 | (37.7713003179936, -122.451209509969) | |||
| 17827 | 17827 | 17125 | Permitted Site 1 | Podocarpus macrophyllus :: Yew Pine 168 | 1967 Oak St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3x3 | 5997619.3207 | 2109172.1957 | 37.7712477652106 | -122.451619154414 | (37.7712477652106, -122.451619154414) | |||
| 26992 | 26992 | 212838 | Undocumented 2 | Podocarpus macrophyllus :: Yew Pine 168 | 200 Thrift St | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 3ft | 5994980.89281 | 2089655.7396 | 37.717509000710294 | -122.45933194993299 | (37.7175090007103, -122.459331949933) | |||
| 69092 | 69092 | 212837 | Undocumented 2 | Podocarpus macrophyllus :: Yew Pine 168 | 200 Thrift St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 2 | Width 3ft | 5995022.27605 | 2089654.8730900001 | 37.717509000709995 | -122.459188845314 | (37.71750900071, -122.459188845314) | |||
| 10782 | 10782 | 93456 | DPW Maintained 3 | Podocarpus macrophyllus :: Yew Pine 168 | 2039 Taraval St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/19/2015 01:33:00 PM | 3 | 3x3 | 5986815.2712 | 2098896.6914 | 37.7424093879903 | -122.488235084702 | (37.7424093879903, -122.488235084702) | ||
| 19296 | 19296 | 17136 | Permitted Site 1 | Podocarpus macrophyllus :: Yew Pine 168 | 2041 Oak St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 3X3 | 5997241.2054 | 2109118.3624 | 37.7710782917307 | -122.45292317759301 | (37.7710782917307, -122.452923177593) | |||
| 18858 | 18858 | 17137 | Permitted Site 1 | Podocarpus macrophyllus :: Yew Pine 168 | 2045 Oak St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 3X3 | 5997217.7067 | 2109114.9444 | 37.7710675601361 | -122.453004213188 | (37.7710675601361, -122.453004213188) |
JSON shape: default, array, newline-delimited
CREATE TABLE "Street_Tree_List" (
"TreeID" INTEGER,
"qLegalStatus" INTEGER,
"qSpecies" INTEGER,
"qAddress" TEXT,
"SiteOrder" INTEGER,
"qSiteInfo" INTEGER,
"PlantType" INTEGER,
"qCaretaker" INTEGER,
"qCareAssistant" INTEGER,
"PlantDate" TEXT,
"DBH" INTEGER,
"PlotSize" TEXT,
"PermitNotes" TEXT,
"XCoord" REAL,
"YCoord" REAL,
"Latitude" REAL,
"Longitude" REAL,
"Location" TEXT
,
FOREIGN KEY ("PlantType") REFERENCES [PlantType](id),
FOREIGN KEY ("qCaretaker") REFERENCES [qCaretaker](id),
FOREIGN KEY ("qSpecies") REFERENCES [qSpecies](id),
FOREIGN KEY ("qSiteInfo") REFERENCES [qSiteInfo](id),
FOREIGN KEY ("qCareAssistant") REFERENCES [qCareAssistant](id),
FOREIGN KEY ("qLegalStatus") REFERENCES [qLegalStatus](id));
CREATE INDEX ["Street_Tree_List_PlantType"] ON [Street_Tree_List]("PlantType");
CREATE INDEX ["Street_Tree_List_qCaretaker"] ON [Street_Tree_List]("qCaretaker");
CREATE INDEX ["Street_Tree_List_qSpecies"] ON [Street_Tree_List]("qSpecies");
CREATE INDEX ["Street_Tree_List_qSiteInfo"] ON [Street_Tree_List]("qSiteInfo");
CREATE INDEX ["Street_Tree_List_qCareAssistant"] ON [Street_Tree_List]("qCareAssistant");
CREATE INDEX ["Street_Tree_List_qLegalStatus"] ON [Street_Tree_List]("qLegalStatus");