Data source: data.sfgov.org
This data as json, CSV (advanced)
Link | rowid | TreeID ▼ | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
119629 | 119629 | 3974 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 240 Castro St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 6002231.9130424 | 2106826.8321431 | 37.765071047803396 | -122.435496220896 | (37.7650710478034, -122.435496220896) | |||
18689 | 18689 | 3975 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 235 Castro St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 6002286.20237 | 2106869.70807 | 37.7651918578307 | -122.435311514912 | (37.7651918578307, -122.435311514912) | |||
17651 | 17651 | 3976 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 235 Castro St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 6002284.497719999 | 2106886.9941 | 37.7652392242381 | -122.43531864746001 | (37.7652392242381, -122.43531864746) | |||
96645 | 96645 | 3977 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 240 Castro St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 6002231.9130424 | 2106826.8321431 | 37.765071047803396 | -122.435496220896 | (37.7650710478034, -122.435496220896) | |||
21460 | 21460 | 3978 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 239 Castro St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 6002286.40715 | 2106839.71962 | 37.7651095285043 | -122.435308661371 | (37.7651095285043, -122.435308661371) | |||
21901 | 21901 | 3979 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 245 Castro St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 6002287.0751 | 2106812.18659 | 37.765033967463296 | -122.43530438149901 | (37.7650339674633, -122.435304381499) | |||
21384 | 21384 | 3980 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 245 Castro St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 6002287.42325 | 2106829.01943 | 37.765080206100706 | -122.435304381487 | (37.7650802061007, -122.435304381487) | |||
20405 | 20405 | 3981 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 251 Castro St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3x3 | 6002291.05979 | 2106731.4747200003 | 37.764812578668 | -122.43528482573299 | (37.764812578668, -122.435284825733) | |||
17656 | 17656 | 3982 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 252 Castro St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 6002232.266559999 | 2106731.1340099997 | 37.7648083041935 | -122.435488151672 | (37.7648083041935, -122.435488151672) | |||
18750 | 18750 | 3983 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 257 Castro St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 6002293.12902 | 2106710.56946 | 37.764755295437105 | -122.43527617336201 | (37.7647552954371, -122.435276173362) | |||
18506 | 18506 | 3984 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 260 Castro St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/11/2011 12:00:00 AM | 3 | 3x3 | 6002236.64288 | 2106700.83949 | 37.7647253713925 | -122.43547084781 | (37.7647253713925, -122.43547084781) | ||
22143 | 22143 | 3985 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 260 Castro St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 6002238.57323 | 2106688.34419 | 37.764691171982996 | -122.435463277314 | (37.764691171983, -122.435463277314) | |||
80589 | 80589 | 3986 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 260 Castro St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 6002238.616391299 | 2106704.4523347 | 37.7647354034654 | -122.43546428043001 | (37.7647354034654, -122.43546428043) | |||
19573 | 19573 | 3987 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 265 Castro St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3x3 | 6002295.67105 | 2106671.38897 | 37.7646478597339 | -122.43526457841601 | (37.7646478597339, -122.435264578416) | |||
9224 | 9224 | 3988 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 263 Castro St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3x3 | 6002289.1914049005 | 2106695.3229 | 37.764713208493795 | -122.435288701865 | (37.7647132084938, -122.435288701865) | |||
21982 | 21982 | 3989 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 270 Castro St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 6002240.78464 | 2106644.082 | 37.7645697644125 | -122.43545246208299 | (37.7645697644125, -122.435452462083) | |||
20245 | 20245 | 3990 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 273 Castro St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 6002299.091580001 | 2106640.22401 | 37.764562482604795 | -122.435250518391 | (37.7645624826048, -122.435250518391) | |||
9408 | 9408 | 3991 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 271 Castro St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 6002291.775341 | 2106648.1490788003 | 37.76458382743429 | -122.435276390167 | (37.7645838274343, -122.435276390167) | |||
21611 | 21611 | 3992 | DPW Maintained 3 | Magnolia grandiflora :: Southern Magnolia 21 | 276 Castro St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 6002241.162269999 | 2106616.98371 | 37.764495380571105 | -122.43544921733299 | (37.7644953805711, -122.435449217333) | |||
20522 | 20522 | 3993 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 281 Castro St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 3X3 | 6002298.94015 | 2106592.16874 | 37.764430525959995 | -122.435247604596 | (37.76443052596, -122.435247604596) | |||
9152 | 9152 | 3994 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 281 Castro St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 6002294.9936565 | 2106589.3936607 | 37.7644226821565 | -122.435261055898 | (37.7644226821565, -122.435261055898) | |||
20168 | 20168 | 3995 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 291 Castro St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 3x3 | 6002304.09215 | 2106530.0516 | 37.764260260014 | -122.435225341893 | (37.764260260014, -122.435225341893) | |||
127086 | 127086 | 3996 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 297 Castro St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 3x3 | 6002300.1460558 | 2106495.3284961996 | 37.76416469475121 | -122.435236506461 | (37.7641646947512, -122.435236506461) | |||
22108 | 22108 | 4001 | DPW Maintained 3 | Magnolia grandiflora :: Southern Magnolia 21 | 307 Castro St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6002309.8672400005 | 2106370.81435 | 37.7638233612897 | -122.435193977127 | (37.7638233612897, -122.435193977127) | |||
97512 | 97512 | 4002 | DPW Maintained 3 | Magnolia grandiflora :: Southern Magnolia 21 | 307 Castro St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 6002305.454775 | 2106394.4120656997 | 37.763887904299295 | -122.435210926453 | (37.7638879042993, -122.435210926453) | |||
19925 | 19925 | 4003 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 309 Castro St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 6002313.62507 | 2106340.84347 | 37.7637412819466 | -122.43517883613701 | (37.7637412819466, -122.435178836137) | |||
18587 | 18587 | 4004 | DPW Maintained 3 | Magnolia grandiflora :: Southern Magnolia 21 | 311 Castro St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6002314.0736 | 2106317.1690599998 | 37.763676303253604 | -122.435175591386 | (37.7636763032536, -122.435175591386) | |||
19377 | 19377 | 4005 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 313 Castro St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 6002315.82378 | 2106295.9586 | 37.7636181638811 | -122.435168020893 | (37.7636181638811, -122.435168020893) | |||
21576 | 21576 | 4007 | DPW Maintained 3 | Magnolia grandiflora :: Southern Magnolia 21 | 316 Castro St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6002252.81604 | 2106379.15611 | 37.7638430258505 | -122.43539189634599 | (37.7638430258505, -122.435391896346) | |||
21418 | 21418 | 4216 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 3952 Cesar Chavez St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 6004197.80466 | 2100453.6779 | 37.747683327425605 | -122.428242438939 | (37.7476833274256, -122.428242438939) | |||
17043 | 17043 | 4217 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 3952 Cesar Chavez St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 3X3 | 6004187.87976 | 2100453.8824299998 | 37.747683327439205 | -122.428276773273 | (37.7476833274392, -122.428276773273) | |||
20841 | 20841 | 4265 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 4180 Cesar Chavez St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3X3 | 6002850.40899 | 2100380.59435 | 37.747406326337 | -122.432896434125 | (37.747406326337, -122.432896434125) | |||
144531 | 144531 | 4277 | DPW Maintained 3 | Magnolia grandiflora :: Southern Magnolia 21 | 4248 Cesar Chavez St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 3X3 | 6002255.3499279 | 2100352.87305 | 37.747296441170796 | -122.434952122778 | (37.7472964411708, -122.434952122778) | |||
18607 | 18607 | 4399 | DPW Maintained 3 | Magnolia grandiflora :: Southern Magnolia 21 | 1027 Church St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6004435.67123 | 2102911.12945 | 37.7544443730147 | -122.427594963958 | (37.7544443730147, -122.427594963958) | |||
19292 | 19292 | 4407 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 1069 Church St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/07/1998 12:00:00 AM | 12 | 4X4 | 6004449.5969 | 2102676.39492 | 37.7538006346933 | -122.42753008327101 | (37.7538006346933, -122.427530083271) | ||
18593 | 18593 | 4412 | DPW Maintained 3 | Magnolia grandiflora :: Southern Magnolia 21 | 1109 Church St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/20/1997 12:00:00 AM | 3 | 3X3 | 6004462.3255199995 | 2102409.31165 | 37.753068006487396 | -122.427467038993 | (37.7530680064874, -122.427467038993) | ||
22045 | 22045 | 4417 | DPW Maintained 3 | Magnolia grandiflora :: Southern Magnolia 21 | 1128 Church St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 05/08/1997 12:00:00 AM | 6 | 3X3 | 6004410.80351 | 2102293.2815099997 | 37.7527465006717 | -122.427636946115 | (37.7527465006717, -122.427636946115) | ||
18746 | 18746 | 4419 | DPW Maintained 3 | Magnolia grandiflora :: Southern Magnolia 21 | 1129 Church St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 4x4 | Permit Number 769145 | 6004468.6411 | 2102291.38818 | 37.7527445734123 | -122.427436798369 | (37.7527445734123, -122.427436798369) | ||
23083 | 23083 | 4435 | DPW Maintained 3 | Magnolia grandiflora :: Southern Magnolia 21 | 1252 Church St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 6004447.85854 | 2101556.1820400003 | 37.750724693399206 | -122.42745629658 | (37.7507246933992, -122.42745629658) | ||||
147239 | 147239 | 4437 | DPW Maintained 3 | Magnolia grandiflora :: Southern Magnolia 21 | 1295 Church St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 4 | 3X3 | 6004520.40222 | 2101374.9739200003 | 37.7502312407787 | -122.427192528131 | (37.7502312407787, -122.427192528131) | |||
19923 | 19923 | 4441 | DPW Maintained 3 | Magnolia grandiflora :: Southern Magnolia 21 | 1310 Church St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/16/1997 12:00:00 AM | 3 | 4X4 | 6004465.25735 | 2101228.12828 | 37.7498249181033 | -122.427372763052 | (37.7498249181033, -122.427372763052) | ||
23277 | 23277 | 4442 | DPW Maintained 3 | Magnolia grandiflora :: Southern Magnolia 21 | 1326 Church St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/07/2008 12:00:00 AM | 4 | 4X4 | 6004470.775230001 | 2101168.4846799998 | 37.7496614627024 | -122.427349433724 | (37.7496614627024, -122.427349433724) | ||
20143 | 20143 | 4444 | DPW Maintained 3 | Magnolia grandiflora :: Southern Magnolia 21 | 1350 Church St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 60 | 3X3 | 6004481.360640001 | 2100985.8254299997 | 37.7491605214566 | -122.427299819028 | (37.7491605214566, -122.427299819028) | |||
4833 | 4833 | 4457 | DPW Maintained 3 | Magnolia grandiflora :: Southern Magnolia 21 | 1408 Church St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 10/26/2017 12:00:00 AM | 3 | 3X3 | Permit Number 779671 | 6004499.90701 | 2100635.94447 | 37.748200878269294 | -122.42721076637599 | (37.7482008782693, -122.427210766376) | |
18409 | 18409 | 4467 | DPW Maintained 3 | Magnolia grandiflora :: Southern Magnolia 21 | 1485 Church St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 24 | 3X3 | 6004584.107530001 | 2100249.18499 | 37.747143687438296 | -122.426892062817 | (37.7471436874383, -122.426892062817) | |||
17456 | 17456 | 4469 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 1500 Church St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/23/1997 12:00:00 AM | 3 | 3X3 | 6004527.54455 | 2100121.39403 | 37.746789604573706 | -122.427078552542 | (37.7467896045737, -122.427078552542) | ||
138829 | 138829 | 4473 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 1508 Church St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/20/1997 12:00:00 AM | 6 | 3X3 | 6004538.315167201 | 2100103.8857201003 | 37.7467421398461 | -122.42704006196001 | (37.7467421398461, -122.42704006196) | ||
159598 | 159598 | 4485 | DPW Maintained 3 | Magnolia grandiflora :: Southern Magnolia 21 | 1563 Church St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 4 | 3X3 | 6004610.91729 | 2099747.5987400003 | 37.7457679630148 | -122.426763642332 | (37.7457679630148, -122.426763642332) | |||
21358 | 21358 | 4487 | DPW Maintained 3 | Magnolia grandiflora :: Southern Magnolia 21 | 1583 Church St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 36 | 3X3 | 6004614.52228 | 2099624.67653 | 37.7454306507164 | -122.42674242461901 | (37.7454306507164, -122.426742424619) | |||
23342 | 23342 | 4711 | DPW Maintained 3 | Magnolia grandiflora :: Southern Magnolia 21 | 1000 Taylor St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 4 | 3X3 | 6008439.857000001 | 2120847.9647 | 37.8039203178058 | -122.41501690508801 | (37.8039203178058, -122.415016905088) | |||
18334 | 18334 | 4860 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 17 Crags Ct | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/21/2011 12:00:00 AM | 3 | 3x3 | 6000704.95064 | 2098230.87879 | 37.7413817967425 | -122.440161133335 | (37.7413817967425, -122.440161133335) | ||
20846 | 20846 | 4906 | DPW Maintained 3 | Magnolia grandiflora :: Southern Magnolia 21 | 94 Ardath Ct | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/20/2004 12:00:00 AM | 3 | 3X4 | 6017502.5740617 | 2095232.3549831002 | 37.73409045999 | -122.381871694314 | (37.73409045999, -122.381871694314) | ||
17001 | 17001 | 5097 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 2617 Diamond St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/30/2005 12:00:00 AM | 5 | 4x5 | 6002316.78425 | 2096460.88221 | 37.7366134293546 | -122.434461458645 | (37.7366134293546, -122.434461458645) | ||
21973 | 21973 | 5098 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 2617 Diamond St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 30 | 3X3 | 6002314.25274 | 2096487.12385 | 37.73668533914721 | -122.43447208684401 | (37.7366853391472, -122.434472086844) | |||
18268 | 18268 | 5106 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 2660 Diamond St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/29/2007 12:00:00 AM | 6 | 3X3 | 6002290.8135 | 2096430.5356700001 | 37.7365286304926 | -122.434549081386 | (37.7365286304926, -122.434549081386) | ||
18969 | 18969 | 5107 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 2680 Diamond St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/29/2007 12:00:00 AM | 6 | 3X3 | 6002305.282240001 | 2096351.99681 | 37.736313802225 | -122.434493443022 | (37.736313802225, -122.434493443022) | ||
20421 | 20421 | 5110 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 2700 Diamond St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 25 | 3x3 | 6002323.486719999 | 2096255.82448 | 37.7360507685304 | -122.43442362866699 | (37.7360507685304, -122.434423628667) | |||
22012 | 22012 | 5111 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 2700 Diamond St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 25 | 3X3 | 6002328.55465 | 2096230.80286 | 37.7359823525955 | -122.43440431839899 | (37.7359823525955, -122.434404318399) | |||
19962 | 19962 | 5115 | DPW Maintained 3 | Magnolia grandiflora :: Southern Magnolia 21 | 2714 Diamond St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 35 | 3x3 | 6002340.69768 | 2096191.3972599998 | 37.7358748431565 | -122.4343595187 | (37.7358748431565, -122.4343595187) | |||
18697 | 18697 | 5130 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 2776 Diamond St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/10/2007 12:00:00 AM | 3 | 3X3 | 6002498.492330001 | 2095849.4792400002 | 37.734944970224106 | -122.433789530166 | (37.7349449702241, -122.433789530166) | ||
7388 | 7388 | 5226 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 1031 Divisadero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/03/1999 12:00:00 AM | 3 | 3X3 | 6001391.1909 | 2111988.4032 | 37.779195648412 | -122.43877396477501 | (37.779195648412, -122.438773964775) | ||
8133 | 8133 | 5227 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 1045 Divisadero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/27/1990 12:00:00 AM | 4 | 3X3 | 6001390.1765 | 2112022.1316 | 37.779288200344894 | -122.438779891576 | (37.7792882003449, -122.438779891576) | ||
8480 | 8480 | 5228 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 1045 Divisadero St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/03/1999 12:00:00 AM | 2 | 3X3 | 6001391.6981 | 2112008.1837 | 37.77924998951 | -122.438773627985 | (37.77924998951, -122.438773627985) | ||
18098 | 18098 | 5330 | DPW Maintained 3 | Magnolia grandiflora :: Southern Magnolia 21 | 114 Dolores St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/08/2016 12:00:00 AM | 3 | 4X6 | 6004755.88985 | 2107676.42577 | 37.7675468540193 | -122.426826912327 | (37.7675468540193, -122.426826912327) | ||
17691 | 17691 | 5337 | DPW Maintained 3 | Magnolia grandiflora :: Southern Magnolia 21 | 159 Dolores St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/17/2007 12:00:00 AM | 3 | 6X8 | 6004857.08853 | 2107452.88089 | 37.7669387747413 | -122.42646096020201 | (37.7669387747413, -122.426460960202) | ||
19117 | 19117 | 5339 | DPW Maintained 3 | Magnolia grandiflora :: Southern Magnolia 21 | 161 Dolores St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 06/08/2002 12:00:00 AM | 6 | 3X3 | 6004857.90623 | 2107419.52662 | 37.766847238139796 | -122.426455756728 | (37.7668472381398, -122.426455756728) | ||
21101 | 21101 | 5340 | DPW Maintained 3 | Magnolia grandiflora :: Southern Magnolia 21 | 167 Dolores St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/10/2007 12:00:00 AM | 3 | 3X3 | 6004859.30069 | 2107395.8999400004 | 37.766782443770296 | -122.426449251054 | (37.7667824437703, -122.426449251054) | ||
21340 | 21340 | 5342 | DPW Maintained 3 | Magnolia grandiflora :: Southern Magnolia 21 | 173 Dolores St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 100 | 6X8 | 6004862.74294 | 2107362.11728 | 37.7666898792732 | -122.426434939225 | (37.7666898792732, -122.426434939225) | |||
21259 | 21259 | 5345 | DPW Maintained 3 | Magnolia grandiflora :: Southern Magnolia 21 | 185 Dolores St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/21/1997 12:00:00 AM | 25 | 3X3 | 6004863.91196 | 2107309.27783 | 37.7665448608919 | -122.426427133122 | (37.7665448608919, -122.426427133122) | ||
17314 | 17314 | 5346 | DPW Maintained 3 | Magnolia grandiflora :: Southern Magnolia 21 | 198 Dolores St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 14 | 3X3 | 6004778.3025 | 2107273.25188 | 37.7664411024979 | -122.426720675429 | (37.7664411024979, -122.426720675429) | |||
19315 | 19315 | 5351 | DPW Maintained 3 | Magnolia grandiflora :: Southern Magnolia 21 | 207 Dolores St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 10/16/2008 12:00:00 AM | 3 | 4X4 | 6004878.32545 | 2107141.43909 | 37.7660848306774 | -122.42636532811701 | (37.7660848306774, -122.426365328117) | ||
19236 | 19236 | 5357 | DPW Maintained 3 | Magnolia grandiflora :: Southern Magnolia 21 | 225 Dolores St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 27 | 5 | 6004878.95913 | 2107064.53746 | 37.7658737130269 | -122.426357660474 | (37.7658737130269, -122.426357660474) | |||
21702 | 21702 | 5366 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 241 Dolores St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/03/2011 12:00:00 AM | 3 | 3x3 | 6004887.65983 | 2106962.9648700003 | 37.7655953108097 | -122.426320334118 | (37.7655953108097, -122.426320334118) | ||
18874 | 18874 | 5369 | DPW Maintained 3 | Magnolia grandiflora :: Southern Magnolia 21 | 255 Dolores St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 70 | 3X3 | 6004885.62298 | 2106907.40872 | 37.7654426517705 | -122.426323423291 | (37.7654426517705, -122.426323423291) | |||
21925 | 21925 | 5374 | DPW Maintained 3 | Magnolia grandiflora :: Southern Magnolia 21 | 273 Dolores St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 40 | 3X3 | 6004890.61551 | 2106802.7812799998 | 37.76515565202929 | -122.42629870543699 | (37.7651556520293, -122.426298705437) | |||
22146 | 22146 | 5380 | DPW Maintained 3 | Magnolia grandiflora :: Southern Magnolia 21 | 299 Dolores St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 07/11/2015 02:59:00 PM | 3 | 4X4 | 6004898.44668 | 2106749.24528 | 37.7650090976149 | -122.42626780743299 | (37.7650090976149, -122.426267807433) | ||
93672 | 93672 | 5381 | DPW Maintained 3 | Magnolia grandiflora :: Southern Magnolia 21 | 300 Dolores St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/14/2016 08:29:00 AM | 3 | 4x4 | 6004836.697731299 | 2106619.7660371996 | 37.7646500880397 | -122.426472161657 | (37.7646500880397, -122.426472161657) | ||
128895 | 128895 | 5382 | DPW Maintained 3 | Magnolia grandiflora :: Southern Magnolia 21 | 300 Dolores St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/14/2016 08:33:00 AM | 3 | 4x4 | 6004836.697731299 | 2106619.7660371996 | 37.7646500880397 | -122.426472161657 | (37.7646500880397, -122.426472161657) | ||
46256 | 46256 | 5383 | DPW Maintained 3 | Magnolia grandiflora :: Southern Magnolia 21 | 325X Dolores St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/06/2009 12:00:00 AM | 3 | 4X4 | 6004919.4864142 | 2106495.5645768 | 37.7643137401636 | -122.426176974515 | (37.7643137401636, -122.426176974515) | ||
19880 | 19880 | 5391 | DPW Maintained 3 | Magnolia grandiflora :: Southern Magnolia 21 | 344 Dolores St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/10/2006 12:00:00 AM | 6 | 3x3 | 6004835.89586 | 2106322.4764900003 | 37.7638337565372 | -122.426453765626 | (37.7638337565372, -122.426453765626) | ||
17199 | 17199 | 5392 | DPW Maintained 3 | Magnolia grandiflora :: Southern Magnolia 21 | 347 Dolores St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/14/2016 08:36:00 AM | 3 | 3x3 | 6004930.1021300005 | 2106201.6217799997 | 37.7635072432739 | -122.42611933027 | (37.7635072432739, -122.42611933027) | ||
18502 | 18502 | 5400 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 348 Dolores St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/14/2003 12:00:00 AM | 8 | 3X3 | 6004838.66529 | 2106299.78021 | 37.7637715945164 | -122.42644257086599 | (37.7637715945164, -122.426442570866) | ||
87688 | 87688 | 5414 | DPW Maintained 3 | Magnolia grandiflora :: Southern Magnolia 21 | 430X Dolores St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 05/11/2013 12:00:00 AM | 3 | 6 | 6004853.970832599 | 2105864.857711 | 37.7625782660478 | -122.42635866544599 | (37.7625782660478, -122.426358665446) | ||
18813 | 18813 | 5422 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 449 Dolores St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 30 | 3X3 | 6004954.3515099995 | 2105767.4035799997 | 37.762316353836496 | -122.42600454707399 | (37.7623163538365, -122.426004547074) | |||
114158 | 114158 | 5425 | DPW Maintained 3 | Magnolia grandiflora :: Southern Magnolia 21 | 460X Dolores St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/10/2006 12:00:00 AM | 3 | 3X3 | 6004889.2026724005 | 2105697.5669461996 | 37.7621209168257 | -122.42622490044901 | (37.7621209168257, -122.426224900449) | ||
18744 | 18744 | 5437 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 500X Dolores St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 25 | 6 | 6004897.82208 | 2105221.96635 | 37.760815517531206 | -122.426161228775 | (37.7608155175312, -122.426161228775) | |||
20609 | 20609 | 5438 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 500X Dolores St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 02/19/1992 12:00:00 AM | 20 | 6 | 6004899.41142 | 2105199.1804 | 37.7607530425379 | -122.426154109737 | (37.7607530425379, -122.426154109737) | ||
18991 | 18991 | 5440 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 500X Dolores St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 100 | 6 | 6004903.17124 | 2105121.8240799997 | 37.7605408528978 | -122.426135598976 | (37.7605408528978, -122.426135598976) | |||
20901 | 20901 | 5441 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 500X Dolores St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 90 | 6 | 6004905.78091 | 2105098.60706 | 37.76047725195271 | -122.426124920443 | (37.7604772519527, -122.426124920443) | |||
17712 | 17712 | 5442 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 500X Dolores St | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 20 | 6 | 6004907.01705 | 2105068.65381 | 37.7603950772802 | -122.426118512771 | (37.7603950772802, -122.426118512771) | |||
20994 | 20994 | 5443 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 500X Dolores St | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 02/19/1992 12:00:00 AM | 80 | 6 | 6004908.86181 | 2105038.27798 | 37.7603117767003 | -122.426109970095 | (37.7603117767003, -122.426109970095) | ||
19884 | 19884 | 5444 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 500X Dolores St | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 20 | 6 | 6004913.15076 | 2105006.62195 | 37.760225099135795 | -122.426092882994 | (37.7602250991358, -122.426092882994) | |||
21952 | 21952 | 5447 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 500X Dolores St | 15 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 100 | 6 | 6004926.667780001 | 2104747.1594700003 | 37.7595134404185 | -122.42602766326401 | (37.7595134404185, -122.426027663264) | |||
19094 | 19094 | 5449 | DPW Maintained 3 | Magnolia grandiflora :: Southern Magnolia 21 | 513 Dolores St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 10/04/2016 12:00:00 AM | 22 | 3X3 | 6004977.28205 | 2105338.33982 | 37.761139542381294 | -122.425894695777 | (37.7611395423813, -122.425894695777) | ||
17369 | 17369 | 5451 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 537 Dolores St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 26 | 6x6 | 6004982.24134 | 2105222.65442 | 37.7608221779151 | -122.42586930883301 | (37.7608221779151, -122.425869308833) | |||
19934 | 19934 | 5455 | DPW Maintained 3 | Magnolia grandiflora :: Southern Magnolia 21 | 565 Dolores St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 30 | 8 | 6004991.07343 | 2105083.36115 | 37.7604402106537 | -122.42582884742 | (37.7604402106537, -122.42582884742) | |||
100994 | 100994 | 5461 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 600X Dolores St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 03/11/2006 12:00:00 AM | 3 | 6 | 6004918.892342701 | 2104703.9652182 | 37.7593943997498 | -122.426051479658 | (37.7593943997498, -122.426051479658) | ||
141306 | 141306 | 5462 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 600X Dolores St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 06/02/1992 12:00:00 AM | 25 | 6 | 6004918.892342701 | 2104703.9652182 | 37.7593943997498 | -122.426051479658 | (37.7593943997498, -122.426051479658) | ||
105022 | 105022 | 5464 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 600X Dolores St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 90 | 6 | 6004918.892342701 | 2104703.9652182 | 37.7593943997498 | -122.426051479658 | (37.7593943997498, -122.426051479658) | |||
115430 | 115430 | 5466 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 600X Dolores St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 03/20/1990 12:00:00 AM | 25 | 6 | 6004918.892342701 | 2104703.9652182 | 37.7593943997498 | -122.426051479658 | (37.7593943997498, -122.426051479658) |
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");