Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, qSiteInfo, qCaretaker, qCareAssistant
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate ▲ | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 78363 | 78363 | 68927 | Permitted Site 1 | Maytenus boaria :: Mayten 22 | 4545 Geary Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/29/1993 12:00:00 AM | Permit Number 32911 | 5992970.34133889 | 2112717.28670221 | 37.7807142959171 | -122.46795792826 | (37.7807142959171, -122.46795792826) | ||
| 143781 | 143781 | 68944 | Permitted Site 1 | Maytenus boaria :: Mayten 22 | 630 22nd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/29/1993 12:00:00 AM | Permit Number 32932 | 5989131.54731022 | 2111030.37263569 | 37.7758600728658 | -122.481114456974 | (37.7758600728658, -122.481114456974) | ||
| 174971 | 174971 | 68932 | Permitted Site 1 | Maytenus boaria :: Mayten 22 | 678 10th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/29/1993 12:00:00 AM | 16 | Permit Number 32916 | 5992886.220919999 | 2110860.22845 | 37.7756104587291 | -122.46811381233 | (37.7756104587291, -122.46811381233) | |
| 19774 | 19774 | 4220 | Permitted Site 1 | Maytenus boaria :: Mayten 22 | 3966 Cesar Chavez St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/28/2016 12:00:00 AM | 3 | 3X3 | Permit Number 779355 | 6004111.22305 | 2100448.04662 | 37.7476629658728 | -122.428541432041 | (37.7476629658728, -122.428541432041) | |
| 49480 | 49480 | 39560 | Permitted Site 1 | Maytenus boaria :: Mayten 22 | 1007 De Haro St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/28/1998 12:00:00 AM | 4 | Permit Number 40982 | 6012211.61681 | 2103677.23576 | 37.7569846978905 | -122.40075738017299 | (37.7569846978905, -122.400757380173) | |
| 52832 | 52832 | 39561 | Permitted Site 1 | Maytenus boaria :: Mayten 22 | 1007 De Haro St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/28/1998 12:00:00 AM | 3 | Permit Number 40982 | 6012211.61021 | 2103687.83014 | 37.7570137873623 | -122.400758147269 | (37.7570137873623, -122.400758147269) | |
| 90276 | 90276 | 39549 | Permitted Site 1 | Maytenus boaria :: Mayten 22 | 870 Arkansas St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/28/1998 12:00:00 AM | Permit Number 40975 | 6013037.74550207 | 2103006.54108096 | 37.7551891595663 | -122.39785325062799 | (37.7551891595663, -122.397853250628) | ||
| 122671 | 122671 | 39508 | Permitted Site 1 | Maytenus boaria :: Mayten 22 | 925 Noe St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/28/1998 12:00:00 AM | Permit Number 40960 | 6003146.61780984 | 2102859.96956865 | 37.7542309028174 | -122.432049188757 | (37.7542309028174, -122.432049188757) | ||
| 121111 | 121111 | 68855 | Permitted Site 1 | Maytenus boaria :: Mayten 22 | 38 Hearst Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/28/1993 12:00:00 AM | Permit Number 32818 | 6000933.97264468 | 2094374.98298636 | 37.7308074420392 | -122.439092970307 | (37.7308074420392, -122.439092970307) | ||
| 80006 | 80006 | 7254 | DPW Maintained 3 | Maytenus boaria :: Mayten 22 | 1940X Post St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/27/2007 12:00:00 AM | 6 | 4X4 | 6002883.203031099 | 2114120.5638209 | 37.785134793903104 | -122.433764919711 | (37.7851347939031, -122.433764919711) | ||
| 157345 | 157345 | 52454 | Permitted Site 1 | Maytenus boaria :: Mayten 22 | 742 11th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/27/2005 12:00:00 AM | 2 | 3x3 | Permit Number 48565 | 5992594.23647 | 2110379.34086 | 37.7742732041809 | -122.46908884285 | (37.7742732041809, -122.46908884285) |
| 53726 | 53726 | 66362 | Permitted Site 1 | Maytenus boaria :: Mayten 22 | 2727 Union St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/21/1990 12:00:00 AM | 11 | Permit Number 29483 | 5999950.42311 | 2118111.33218 | 37.7959255439908 | -122.44419826196301 | (37.7959255439908, -122.444198261963) | ||
| 132007 | 132007 | 66360 | Permitted Site 1 | Maytenus boaria :: Mayten 22 | 2785 Union St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/21/1990 12:00:00 AM | 9 | Permit Number 29481 | 5999674.8823 | 2118072.76589 | 37.795803927758705 | -122.44514890831199 | (37.7958039277587, -122.445148908312) | ||
| 148947 | 148947 | 66359 | Permitted Site 1 | Maytenus boaria :: Mayten 22 | 2781 Union St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/21/1990 12:00:00 AM | 10 | Permit Number 29480 | 5999713.323480001 | 2118077.83983 | 37.7958200535154 | -122.44501626011998 | (37.7958200535154, -122.44501626012) | ||
| 166566 | 166566 | 66357 | Permitted Site 1 | Maytenus boaria :: Mayten 22 | 2765 Union St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/21/1990 12:00:00 AM | 12 | Permit Number 29478 | 5999787.463269999 | 2118086.0871900003 | 37.7958469297488 | -122.44476031665899 | (37.7958469297488, -122.444760316659) | ||
| 180288 | 180288 | 66361 | Permitted Site 1 | Maytenus boaria :: Mayten 22 | 2784 Union St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/21/1990 12:00:00 AM | 8 | Permit Number 29482 | 5999670.89304 | 2118117.45276 | 37.7959263983422 | -122.445165926171 | (37.7959263983422, -122.445165926171) | ||
| 19558 | 19558 | 52414 | Permitted Site 1 | Maytenus boaria :: Mayten 22 | 3180 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/20/2005 12:00:00 AM | Permit Number 48533 | 6006685.96266598 | 2099861.46080956 | 37.7461977049098 | -122.41959649754601 | (37.7461977049098, -122.419596497546) | |||
| 37773 | 37773 | 44184 | Permitted Site 1 | Maytenus boaria :: Mayten 22 | 128 26th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/19/2000 12:00:00 AM | 5 | Permit Number 43646 | 5987739.153609999 | 2115125.7226400003 | 37.787023700339205 | -122.486231758107 | (37.7870237003392, -122.486231758107) | ||
| 16935 | 16935 | 10205 | DPW Maintained 3 | Maytenus boaria :: Mayten 22 | 1265 Guerrero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/19/1994 12:00:00 AM | 12 | 2X2 | 6005835.28036 | 2101602.69371 | 37.750930777534705 | -122.422661770643 | (37.7509307775347, -122.422661770643) | ||
| 11717 | 11717 | 61760 | Permitted Site 1 | Maytenus boaria :: Mayten 22 | 3739 Landers St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/19/1984 12:00:00 AM | Permit Number 21774 | |||||||
| 116530 | 116530 | 61762 | Permitted Site 1 | Maytenus boaria :: Mayten 22 | 24 Landers St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/19/1984 12:00:00 AM | Permit Number 21776 | 6004439.72474992 | 2107627.23138596 | 37.767393896876 | -122.427916980452 | (37.767393896876, -122.427916980452) | ||
| 3735 | 3735 | 63212 | Permitted Site 1 | Maytenus boaria :: Mayten 22 | 450 38th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/18/1986 12:00:00 AM | 10 | Permit Number 23755 | 5984123.0 | 2112760.0 | 37.7803166927985 | -122.498567828267 | (37.7803166927985, -122.498567828267) | |
| 93738 | 93738 | 58864 | Permitted Site 1 | Maytenus boaria :: Mayten 22 | 342-346 Moultrie St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/18/1986 12:00:00 AM | Permit Number 23730 | 6007699.35923266 | 2097511.83706894 | 37.739803191613795 | -122.41592593112699 | (37.7398031916138, -122.415925931127) | ||
| 99664 | 99664 | 61385 | Permitted Site 1 | Maytenus boaria :: Mayten 22 | 1935 15th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/18/1984 12:00:00 AM | Permit Number 21768 | 6004585.61046069 | 2107169.53679534 | 37.766145429579 | -122.42737977319099 | (37.766145429579, -122.427379773191) | ||
| 104702 | 104702 | 60532 | Permitted Site 1 | Maytenus boaria :: Mayten 22 | 4330 Anza St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/18/1982 12:00:00 AM | Permit Number 20142 | 5985254.11832032 | 2111812.42128565 | 37.7777811840185 | -122.494584946656 | (37.7777811840185, -122.494584946656) | ||
| 139440 | 139440 | 60541 | Permitted Site 1 | Maytenus boaria :: Mayten 22 | 591 34th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/18/1982 12:00:00 AM | Permit Number 20151 | 5985324.75289766 | 2111863.87461327 | 37.7779265939729 | -122.494344394488 | (37.7779265939729, -122.494344394488) | ||
| 145000 | 145000 | 60553 | Permitted Site 1 | Maytenus boaria :: Mayten 22 | 551 35th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/18/1982 12:00:00 AM | Permit Number 20163 | 5985006.55043607 | 2112120.20193432 | 37.7786117682504 | -122.495464062347 | (37.7786117682504, -122.495464062347) | ||
| 147906 | 147906 | 60539 | Permitted Site 1 | Maytenus boaria :: Mayten 22 | 567 34th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/18/1982 12:00:00 AM | 9 | Permit Number 20149 | 5985321.50545 | 2112024.72223 | 37.7783680453141 | -122.494367487919 | (37.7783680453141, -122.494367487919) | |
| 165686 | 165686 | 60555 | Permitted Site 1 | Maytenus boaria :: Mayten 22 | 626 35th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/18/1982 12:00:00 AM | 13 | Permit Number 20165 | 5985073.29397 | 2111571.16572 | 37.7771081805026 | -122.495192675871 | (37.7771081805026, -122.495192675871) | |
| 174341 | 174341 | 60544 | Permitted Site 1 | Maytenus boaria :: Mayten 22 | 662 34th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/18/1982 12:00:00 AM | 14 | Permit Number 20154 | 5985391.24868 | 2111355.99537 | 37.776535994237705 | -122.49407692427 | (37.7765359942377, -122.49407692427) | |
| 182166 | 182166 | 60536 | Permitted Site 1 | Maytenus boaria :: Mayten 22 | 535 34th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/18/1982 12:00:00 AM | 16 | 6x9 | Permit Number 20146 | 5985319.95859 | 2112206.9158 | 37.778868205992 | -122.49438627261001 | (37.778868205992, -122.49438627261) |
| 183320 | 183320 | 60562 | Permitted Site 1 | Maytenus boaria :: Mayten 22 | 639 35th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/18/1982 12:00:00 AM | 12 | Permit Number 20172 | 5985030.246830001 | 2111505.8511200002 | 37.7769263250189 | -122.49533676921999 | (37.7769263250189, -122.49533676922) | |
| 20034 | 20034 | 4164 | Permitted Site 1 | Maytenus boaria :: Mayten 22 | 3760-3762 Cesar Chavez St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/17/2003 12:00:00 AM | 3 | 3X3 | 6005516.25244 | 2100526.93515 | 37.7479589876363 | -122.423688522104 | (37.7479589876363, -122.423688522104) | ||
| 3222 | 3222 | 5838 | DPW Maintained 3 | Maytenus boaria :: Mayten 22 | 860 Eddy St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/17/1997 12:00:00 AM | 6 | 3X3 | 6006312.21276 | 2113211.9775099996 | 37.7828340176265 | -122.421837034768 | (37.7828340176265, -122.421837034768) | ||
| 19351 | 19351 | 67808 | Permitted Site 1 | Maytenus boaria :: Mayten 22 | 4 Hoffman Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/17/1992 12:00:00 AM | Permit Number 31459 | 6000553.20461336 | 2102855.81352911 | 37.754072119422 | -122.44101753615801 | (37.754072119422, -122.441017536158) | ||
| 89812 | 89812 | 63175 | Permitted Site 1 | Maytenus boaria :: Mayten 22 | 1458 11th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/17/1986 12:00:00 AM | Permit Number 23712 | 5992762.43096046 | 2105538.93647329 | 37.760992457072 | -122.468154849792 | (37.760992457072, -122.468154849792) | ||
| 89894 | 89894 | 63173 | Permitted Site 1 | Maytenus boaria :: Mayten 22 | 1489 11th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/17/1986 12:00:00 AM | Permit Number 23710 | 5992717.18513834 | 2105341.71503492 | 37.7604483255676 | -122.46829698590099 | (37.7604483255676, -122.468296985901) | ||
| 93375 | 93375 | 63170 | Permitted Site 1 | Maytenus boaria :: Mayten 22 | 1485 11th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/17/1986 12:00:00 AM | Permit Number 23707 | 5992716.28868026 | 2105367.77285241 | 37.7605198217218 | -122.46830198203699 | (37.7605198217218, -122.468301982037) | ||
| 95675 | 95675 | 63174 | Permitted Site 1 | Maytenus boaria :: Mayten 22 | 1486 11th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/17/1986 12:00:00 AM | Permit Number 23711 | 5992768.70616448 | 2105356.53182397 | 37.76049198416771 | -122.468119877824 | (37.7604919841677, -122.468119877824) | ||
| 106171 | 106171 | 63179 | Permitted Site 1 | Maytenus boaria :: Mayten 22 | 648 Kirkham St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/17/1986 12:00:00 AM | Permit Number 23717 | 5992902.86233817 | 2105288.46570118 | 37.760312839312796 | -122.467650946992 | (37.7603128393128, -122.467650946992) | ||
| 106452 | 106452 | 63182 | Permitted Site 1 | Maytenus boaria :: Mayten 22 | 255 Moultrie St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/17/1986 12:00:00 AM | Permit Number 23721 | 6007786.20135811 | 2097926.16870934 | 37.74094573674871 | -122.41565499552601 | (37.7409457367487, -122.415654995526) | ||
| 113519 | 113519 | 61978 | Permitted Site 1 | Maytenus boaria :: Mayten 22 | 1325 Divisadero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/17/1986 12:00:00 AM | Permit Number 23720 | 6001258.03784349 | 2112917.51741197 | 37.781739183758205 | -122.43930120982701 | (37.7817391837582, -122.439301209827) | ||
| 125076 | 125076 | 63181 | Permitted Site 1 | Maytenus boaria :: Mayten 22 | 1322 Divisadero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/17/1986 12:00:00 AM | Permit Number 23719 | 6001340.37810501 | 2112921.92702892 | 37.7817559767868 | -122.43901666797 | (37.7817559767868, -122.43901666797) | ||
| 142409 | 142409 | 63171 | Permitted Site 1 | Maytenus boaria :: Mayten 22 | 1474 11th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/17/1986 12:00:00 AM | Permit Number 23708 | 5992766.01679025 | 2105434.70527642 | 37.7607064726478 | -122.468134865759 | (37.7607064726478, -122.468134865759) | ||
| 88543 | 88543 | 61217 | Permitted Site 1 | Maytenus boaria :: Mayten 22 | 171 Elmira St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/17/1983 12:00:00 AM | Permit Number 21086 | 6011242.97041685 | 2095692.04603608 | 37.735005020254604 | -122.40354555027399 | (37.7350050202546, -122.403545550274) | ||
| 90487 | 90487 | 61204 | Permitted Site 1 | Maytenus boaria :: Mayten 22 | 164 Elmira St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/17/1983 12:00:00 AM | Permit Number 21072 | 6011188.72655028 | 2095731.78109118 | 37.7351110942274 | -122.403735886588 | (37.7351110942274, -122.403735886588) | ||
| 102937 | 102937 | 61210 | Permitted Site 1 | Maytenus boaria :: Mayten 22 | 128 Elmira St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/17/1983 12:00:00 AM | Permit Number 21078 | 6011174.80056611 | 2095987.17858012 | 37.7358115837426 | -122.403801999464 | (37.7358115837426, -122.403801999464) | ||
| 125437 | 125437 | 61222 | Permitted Site 1 | Maytenus boaria :: Mayten 22 | 199 Elmira St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/17/1983 12:00:00 AM | Permit Number 21091 | 6011253.80173881 | 2095493.40352749 | 37.734460194854705 | -122.403494131474 | (37.7344601948547, -122.403494131474) | ||
| 128932 | 128932 | 61208 | Permitted Site 1 | Maytenus boaria :: Mayten 22 | 142 Elmira St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/17/1983 12:00:00 AM | Permit Number 21076 | 6011180.21622644 | 2095887.85733773 | 37.7355391711765 | -122.403776288754 | (37.7355391711765, -122.403776288754) | ||
| 138843 | 138843 | 61203 | Permitted Site 1 | Maytenus boaria :: Mayten 22 | 184 Elmira St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/17/1983 12:00:00 AM | Permit Number 21070 | 6011196.46320939 | 2095589.89357484 | 37.7347219332729 | -122.403699157745 | (37.7347219332729, -122.403699157745) | ||
| 140159 | 140159 | 61199 | Permitted Site 1 | Maytenus boaria :: Mayten 22 | 1701 Silver Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/17/1983 12:00:00 AM | Permit Number 21065 | 6010989.81507218 | 2095045.46583518 | 37.7332155036894 | -122.40437530667101 | (37.7332155036894, -122.404375306671) | ||
| 149064 | 149064 | 61211 | Permitted Site 1 | Maytenus boaria :: Mayten 22 | 113 Elmira St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/17/1983 12:00:00 AM | 10 | Permit Number 21079 | 6011211.11189 | 2096086.66275 | 37.7360867746889 | -122.403683453943 | (37.7360867746889, -122.403683453943) | |
| 156420 | 156420 | 61212 | Permitted Site 1 | Maytenus boaria :: Mayten 22 | 117 Elmira St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/17/1983 12:00:00 AM | 14 | Permit Number 21080 | 6011212.42648 | 2096074.13197 | 37.7360524412557 | -122.403678027439 | (37.7360524412557, -122.403678027439) | |
| 184654 | 184654 | 61215 | Permitted Site 1 | Maytenus boaria :: Mayten 22 | 149 Elmira St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/17/1983 12:00:00 AM | 10 | Permit Number 21083 | 6011222.64444 | 2095869.17205 | 37.735490235469605 | -122.40362828323 | (37.7354902354696, -122.40362828323) | |
| 94037 | 94037 | 61030 | Permitted Site 1 | Maytenus boaria :: Mayten 22 | 124 Eugenia Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/16/1986 12:00:00 AM | Permit Number 23678 | 6006309.58035175 | 2098190.57799667 | 37.741588629403 | -122.420779382153 | (37.741588629403, -122.420779382153) | ||
| 110867 | 110867 | 63154 | Permitted Site 1 | Maytenus boaria :: Mayten 22 | 1469 11th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/16/1986 12:00:00 AM | Permit Number 23690 | 5992712.70284963 | 2105472.00407364 | 37.760805806193794 | -122.468321966668 | (37.7608058061938, -122.468321966668) | ||
| 5378 | 5378 | 9456 | Permitted Site 1 | Maytenus boaria :: Mayten 22 | 800X Golden Gate Ave | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 12/15/2005 12:00:00 AM | 3 | 3X3 | 6005442.4 | 2112406.4818 | 37.780573233977705 | -122.424788902821 | (37.7805732339777, -122.424788902821) | ||
| 5863 | 5863 | 9461 | Permitted Site 1 | Maytenus boaria :: Mayten 22 | 800X Golden Gate Ave | 17 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 12/15/2005 12:00:00 AM | 3 | 3X3 | 6005331.3816 | 2112388.6106 | 37.780517893039395 | -122.425171696602 | (37.7805178930394, -122.425171696602) | ||
| 6304 | 6304 | 9451 | Permitted Site 1 | Maytenus boaria :: Mayten 22 | 800X Golden Gate Ave | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 12/15/2005 12:00:00 AM | 3 | 3X3 | 6005532.2979 | 2112418.9375 | 37.7806125113537 | -122.424478789137 | (37.7806125113537, -122.424478789137) | ||
| 9143 | 9143 | 12567 | Permitted Site 1 | Maytenus boaria :: Mayten 22 | 311 Lake St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/15/1992 12:00:00 AM | 6 | 3X3 | 5994495.46055 | 2114856.8855 | 37.786677009426604 | -122.462837112849 | (37.7866770094266, -122.462837112849) | ||
| 95837 | 95837 | 67766 | Permitted Site 1 | Maytenus boaria :: Mayten 22 | 2243 15th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/15/1992 12:00:00 AM | Permit Number 31395 | 6002609.16717528 | 2107059.87707371 | 37.7657323512636 | -122.43420805482 | (37.7657323512636, -122.43420805482) | ||
| 100916 | 100916 | 14674 | DPW Maintained 3 | Maytenus boaria :: Mayten 22 | 747 McAllister St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/14/2007 12:00:00 AM | 5 | 4x4 | 6005346.74925 | 2111820.94662 | 37.7789600951073 | -122.425078130411 | (37.7789600951073, -122.425078130411) | ||
| 102277 | 102277 | 74114 | Permitted Site 1 | Maytenus boaria :: Mayten 22 | 1602 Hayes St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/13/2007 12:00:00 AM | 7 | 3x3 | Permit Number 50005 | 6000149.09 | 2110272.5703 | 37.77441366562479 | -122.442947638101 | (37.7744136656248, -122.442947638101) | |
| 112801 | 112801 | 73881 | Permitted Site 1 | Maytenus boaria :: Mayten 22 | 1600 Hayes St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/13/2007 12:00:00 AM | 3x3 | Permit Number 50005 | 6000186.45994601 | 2110275.21140589 | 37.7744230479512 | -122.44281855848499 | (37.7744230479512, -122.442818558485) | ||
| 114128 | 114128 | 70543 | Permitted Site 1 | Maytenus boaria :: Mayten 22 | 1600 Hayes St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/13/2007 12:00:00 AM | 3x3 | Permit Number 50005 | 6000186.45994601 | 2110275.21140589 | 37.7744230479512 | -122.44281855848499 | (37.7744230479512, -122.442818558485) | ||
| 87750 | 87750 | 81887 | Permitted Site 1 | Maytenus boaria :: Mayten 22 | 631 41st Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/11/2007 12:00:00 AM | 3x3 | Permit Number 49992 | 5983167.46795372 | 2111495.3462998 | 37.7767882391274 | -122.50177980851801 | (37.7767882391274, -122.501779808518) | ||
| 22255 | 22255 | 4228 | Permitted Site 1 | Maytenus boaria :: Mayten 22 | 3984 Cesar Chavez St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/11/2002 12:00:00 AM | 3 | 3X3 | 6003996.08177 | 2100441.76825 | 37.747639210289 | -122.428939136556 | (37.747639210289, -122.428939136556) | ||
| 120502 | 120502 | 63137 | Permitted Site 1 | Maytenus boaria :: Mayten 22 | 52 Winfield St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/11/1986 12:00:00 AM | Permit Number 23655 | 6007305.03727002 | 2099223.26489029 | 37.74448021420321 | -122.417410588885 | (37.7444802142032, -122.417410588885) | ||
| 24780 | 24780 | 105060 | Permitted Site 1 | Maytenus boaria :: Mayten 22 | 1265 Bay St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/10/2013 12:00:00 AM | 2 | 3x3 | Permit Number 770217 | 6004734.29072 | 2120854.8026099997 | 37.803730166465705 | -122.427840743265 | (37.8037301664657, -122.427840743265) | |
| 180344 | 180344 | 59950 | Permitted Site 1 | Maytenus boaria :: Mayten 22 | 2926 Gough St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/10/1981 12:00:00 AM | 14 | Permit Number 19426 | 6004763.68338 | 2119656.56878 | 37.800441788217796 | -122.42765360603 | (37.8004417882178, -122.42765360603) | ||
| 52700 | 52700 | 91044 | Permitted Site 1 | Maytenus boaria :: Mayten 22 | 1256 Revere Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/09/2008 12:00:00 AM | 2 | 3x3 | Permit Number 51957 | 6016922.0796 | 2093073.582 | 37.728130823076604 | -122.383728412679 | (37.7281308230766, -122.383728412679) | |
| 81731 | 81731 | 60682 | Permitted Site 1 | Maytenus boaria :: Mayten 22 | 201 Broderick St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/09/2000 12:00:00 AM | Permit Number 20321 | 6001273.50200194 | 2109372.73080822 | 37.7720069742627 | -122.438993591609 | (37.7720069742627, -122.438993591609) | ||
| 84389 | 84389 | 50619 | Permitted Site 1 | Maytenus boaria :: Mayten 22 | 10 Mendosa Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/08/2003 12:00:00 AM | Permit Number 47217 | 5993598.39647465 | 2101142.75642422 | 37.7489699240447 | -122.464944350004 | (37.7489699240447, -122.464944350004) | |||
| 102493 | 102493 | 50620 | Permitted Site 1 | Maytenus boaria :: Mayten 22 | 10 Mendosa Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/08/2003 12:00:00 AM | Permit Number 47217 | 5993598.39647465 | 2101142.75642422 | 37.7489699240447 | -122.464944350004 | (37.7489699240447, -122.464944350004) | |||
| 125023 | 125023 | 50618 | Permitted Site 1 | Maytenus boaria :: Mayten 22 | 10 Mendosa Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/08/2003 12:00:00 AM | Permit Number 47217 | 5993598.39647465 | 2101142.75642422 | 37.7489699240447 | -122.464944350004 | (37.7489699240447, -122.464944350004) | |||
| 163456 | 163456 | 64183 | Permitted Site 1 | Maytenus boaria :: Mayten 22 | 340 Funston Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/08/1987 12:00:00 AM | 10 | Permit Number 24967 | 5991878.196140001 | 2113147.3635 | 37.781832039911706 | -122.47176750135401 | (37.7818320399117, -122.471767501354) | |
| 85570 | 85570 | 60524 | Permitted Site 1 | Maytenus boaria :: Mayten 22 | 381 Duncan St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/08/1982 12:00:00 AM | Permit Number 20128 | 6004064.34240235 | 2099813.12253247 | 37.7459169582989 | -122.42865828942301 | (37.7459169582989, -122.428658289423) | ||
| 88081 | 88081 | 60505 | Permitted Site 1 | Maytenus boaria :: Mayten 22 | 240 28th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/08/1982 12:00:00 AM | Permit Number 20105 | 6004323.79842721 | 2099588.40947873 | 37.7453146284369 | -122.42774511781602 | (37.7453146284369, -122.427745117816) | ||
| 90313 | 90313 | 60507 | Permitted Site 1 | Maytenus boaria :: Mayten 22 | 269 28th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/08/1982 12:00:00 AM | Permit Number 20107 | 6004154.46852142 | 2099527.0154354 | 37.745136474502395 | -122.428326257791 | (37.7451364745024, -122.428326257791) | ||
| 91087 | 91087 | 60517 | Permitted Site 1 | Maytenus boaria :: Mayten 22 | 319 Duncan St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/08/1982 12:00:00 AM | Permit Number 20121 | 6004447.46980385 | 2099835.27460296 | 37.7459994582324 | -122.427335064841 | (37.7459994582324, -122.427335064841) | ||
| 96929 | 96929 | 60520 | Permitted Site 1 | Maytenus boaria :: Mayten 22 | 328 Duncan St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/08/1982 12:00:00 AM | Permit Number 20124 | 6004382.67348784 | 2099883.6149868 | 37.7461285249636 | -122.427562565259 | (37.7461285249636, -122.427562565259) | ||
| 98264 | 98264 | 60519 | Permitted Site 1 | Maytenus boaria :: Mayten 22 | 324 Duncan St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/08/1982 12:00:00 AM | Permit Number 20123 | 6004407.39138508 | 2099885.04415266 | 37.7461338471945 | -122.42747719569799 | (37.7461338471945, -122.427477195698) | ||
| 99695 | 99695 | 60525 | Permitted Site 1 | Maytenus boaria :: Mayten 22 | 435 Duncan St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/08/1982 12:00:00 AM | Permit Number 20132 | 6003708.99139928 | 2099793.33734939 | 37.745842515461895 | -122.429885633027 | (37.7458425154619, -122.429885633027) | ||
| 110252 | 110252 | 60522 | Permitted Site 1 | Maytenus boaria :: Mayten 22 | 373 Duncan St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/08/1982 12:00:00 AM | Permit Number 20126 | 6004113.77817374 | 2099815.98086285 | 37.745927604281704 | -122.42848755100901 | (37.7459276042817, -122.428487551009) | ||
| 125955 | 125955 | 60526 | Permitted Site 1 | Maytenus boaria :: Mayten 22 | 415 Duncan St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/08/1982 12:00:00 AM | Permit Number 20134 | 6003831.51067102 | 2099800.00651477 | 37.74586776501079 | -122.429462454235 | (37.7458677650108, -122.429462454235) | ||
| 126149 | 126149 | 60523 | Permitted Site 1 | Maytenus boaria :: Mayten 22 | 377 Duncan St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/08/1982 12:00:00 AM | 12 | Permit Number 20127 | 6004089.06031114 | 2099814.551699 | 37.7459222813262 | -122.428572920142 | (37.7459222813262, -122.428572920142) | |
| 142570 | 142570 | 60521 | Permitted Site 1 | Maytenus boaria :: Mayten 22 | 334 Duncan St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/08/1982 12:00:00 AM | Permit Number 20125 | 6004345.5966362 | 2099881.47123767 | 37.7461205415 | -122.427690619599 | (37.7461205415, -122.427690619599) | ||
| 114542 | 114542 | 4203 | Permitted Site 1 | Maytenus boaria :: Mayten 22 | 3908 Cesar Chavez St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/07/1996 12:00:00 AM | 3 | 3X3 | 6004473.5973488 | 2100472.366091 | 37.7477502419944 | -122.42729009377399 | (37.7477502419944, -122.427290093774) | ||
| 92354 | 92354 | 62439 | Permitted Site 1 | Maytenus boaria :: Mayten 22 | 106 Ord St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/07/1985 12:00:00 AM | Permit Number 22602 | 6000836.53946249 | 2105758.54557306 | 37.7620584473923 | -122.44024584681999 | (37.7620584473923, -122.44024584682) | ||
| 125775 | 125775 | 62437 | Permitted Site 1 | Maytenus boaria :: Mayten 22 | 193 Corbett Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/07/1985 12:00:00 AM | Permit Number 22598 | 6000163.24208297 | 2105631.40693726 | 37.761670999404295 | -122.442565386618 | (37.7616709994043, -122.442565386618) | ||
| 126829 | 126829 | 61687 | Permitted Site 1 | Maytenus boaria :: Mayten 22 | 102 Corbett Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/07/1985 12:00:00 AM | Permit Number 22600 | 6000834.13705442 | 2105698.15099784 | 37.7618924819567 | -122.440249824562 | (37.7618924819567, -122.440249824562) | ||
| 182240 | 182240 | 78752 | Permitted Site 1 | Maytenus boaria :: Mayten 22 | 526 35th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/06/2007 12:00:00 AM | 2 | 3x3 | Permit Number 49955 | 5985049.37887 | 2112268.39757 | 37.7790211784833 | -122.495326836569 | (37.7790211784833, -122.495326836569) | |
| 19846 | 19846 | 52323 | Permitted Site 1 | Maytenus boaria :: Mayten 22 | 4437EUREKA 20th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/05/2005 12:00:00 AM | Permit Number 48476 | 6001658.45435831 | 2104067.04414381 | 37.7574607564447 | -122.43728204425699 | (37.7574607564447, -122.437282044257) | ||
| 101406 | 101406 | 52326 | Permitted Site 1 | Maytenus boaria :: Mayten 22 | 4534DOUGLASS 19th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/05/2005 12:00:00 AM | Permit Number 48478 | 6000944.39155322 | 2104666.68511538 | 37.759066605889295 | -122.439794543827 | (37.7590666058893, -122.439794543827) | ||
| 103441 | 103441 | 52325 | Permitted Site 1 | Maytenus boaria :: Mayten 22 | 4534DOUGLASS 19th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/05/2005 12:00:00 AM | Permit Number 48478 | 6000944.39155322 | 2104666.68511538 | 37.759066605889295 | -122.439794543827 | (37.7590666058893, -122.439794543827) | ||
| 91169 | 91169 | 33735 | Permitted Site 1 | Maytenus boaria :: Mayten 22 | 75-79X Germania St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/04/1996 12:00:00 AM | 3x9 | Permit Number 37796 | 6003843.98737639 | 2108825.41028285 | 37.7706500845825 | -122.43006303665199 | (37.7706500845825, -122.430063036652) | ||
| 119262 | 119262 | 33734 | Permitted Site 1 | Maytenus boaria :: Mayten 22 | 75-79X Germania St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/04/1996 12:00:00 AM | 3x9 | Permit Number 37796 | 6003843.98737639 | 2108825.41028285 | 37.7706500845825 | -122.43006303665199 | (37.7706500845825, -122.430063036652) | ||
| 120403 | 120403 | 33736 | Permitted Site 1 | Maytenus boaria :: Mayten 22 | 75-79X Germania St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/04/1996 12:00:00 AM | 3x9 | Permit Number 37796 | 6003843.98737639 | 2108825.41028285 | 37.7706500845825 | -122.43006303665199 | (37.7706500845825, -122.430063036652) | ||
| 87962 | 87962 | 67737 | Permitted Site 1 | Maytenus boaria :: Mayten 22 | 1416 11th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/04/1992 12:00:00 AM | Permit Number 31356 | 5992753.01815485 | 2105812.54343511 | 37.7617431662944 | -122.468207308624 | (37.7617431662944, -122.468207308624) | ||
| 101040 | 101040 | 67747 | Permitted Site 1 | Maytenus boaria :: Mayten 22 | 1373 04th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/04/1992 12:00:00 AM | Permit Number 31370 | 5994856.38488326 | 2106256.37370893 | 37.7630830642151 | -122.460964827531 | (37.7630830642151, -122.460964827531) |
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");