Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, SiteOrder, qSiteInfo, qCaretaker, PlantDate, PlotSize, PermitNotes
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord ▲ | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 164652 | 164652 | 192352 | Undocumented 2 | Fraxinus spp :: Ash Spp 83 | 1040 Palou Ave | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 26 | Width 4ft | 6017850.25276 | 2093091.0077 | 37.728229933050706 | -122.380520862443 | (37.7282299330507, -122.380520862443) | |||
| 52799 | 52799 | 192306 | Undocumented 2 | Fraxinus spp :: Ash Spp 83 | 3600 03rd St | 4 | : 4 | Tree 1 | Private 1 | 21 | Width 5ft | 6015896.02327 | 2098855.55467 | 37.74395018136929 | -122.38767879773701 | (37.7439501813693, -122.387678797737) | |||
| 23985 | 23985 | 192353 | Undocumented 2 | Fraxinus spp :: Ash Spp 83 | 1500 Minnesota St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 25 | Width 2ft | 6015367.9403099995 | 2101545.1725 | 37.7513060448498 | -122.38969261993 | (37.7513060448498, -122.38969261993) | |||
| 151890 | 151890 | 192390 | Undocumented 2 | Fraxinus spp :: Ash Spp 83 | 233 Mississippi St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 4ft | 6014050.42421 | 2105956.49266 | 37.763345430981396 | -122.394557641045 | (37.7633454309814, -122.394557641045) | |||
| 14443 | 14443 | 25984 | DPW Maintained 3 | Fraxinus spp :: Ash Spp 83 | 1901 Oakdale Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 2x2 | 6013408.21183 | 2096665.5323700001 | 37.7377987196205 | -122.396127690947 | (37.7377987196205, -122.396127690947) | |||
| 13842 | 13842 | 25983 | DPW Maintained 3 | Fraxinus spp :: Ash Spp 83 | 1901 Oakdale Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 2x2 | 6013395.85675 | 2096673.78587 | 37.7378206945684 | -122.396170987024 | (37.7378206945684, -122.396170987024) | |||
| 156396 | 156396 | 192354 | Undocumented 2 | Fraxinus spp :: Ash Spp 83 | 1400 Quint St | 1 | : 4 | Tree 1 | Private 1 | 10 | Width 1ft | 6013388.3658300005 | 2096606.99697 | 37.7376368893361 | -122.39619220741999 | (37.7376368893361, -122.39619220742) | |||
| 34313 | 34313 | 192355 | Undocumented 2 | Fraxinus spp :: Ash Spp 83 | 1400 Quint St | 2 | : 4 | Tree 1 | Private 1 | 13 | Width 1ft | 6013376.06433 | 2096591.73652 | 37.7375943028269 | -122.39623367064199 | (37.7375943028269, -122.396233670642) | |||
| 70126 | 70126 | 192356 | Undocumented 2 | Fraxinus spp :: Ash Spp 83 | 1400 Quint St | 3 | : 4 | Tree 1 | Private 1 | 11 | Width 3ft | 6013361.05471 | 2096570.45075 | 37.7375350213353 | -122.396284074954 | (37.7375350213353, -122.396284074954) | |||
| 171215 | 171215 | 44078 | Permitted Site 1 | Fraxinus spp :: Ash Spp 83 | 250 Broadway | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/24/2000 12:00:00 AM | 16 | Permit Number 43599 | 6012239.93104 | 2118827.2823900003 | 37.7985848203962 | -122.40172431143401 | (37.7985848203962, -122.401724311434) | |
| 40346 | 40346 | 128822 | Undocumented 2 | Fraxinus spp :: Ash Spp 83 | 250 Broadway | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6012208.0631 | 2118824.10156 | 37.798574308201204 | -122.401834361485 | (37.7985743082012, -122.401834361485) | |||
| 28875 | 28875 | 109474 | Undocumented 2 | Fraxinus spp :: Ash Spp 83 | 300 Broadway | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | 3x3 | 6012029.14391 | 2118799.20085 | 37.7984959502925 | -122.402451729872 | (37.7984959502925, -122.402451729872) | |||
| 58889 | 58889 | 128823 | Undocumented 2 | Fraxinus spp :: Ash Spp 83 | 600 Market St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 5ft | 6012017.65592 | 2115254.86265 | 37.788763401662294 | -122.402242153673 | (37.7887634016623, -122.402242153673) | |||
| 130927 | 130927 | 109476 | Undocumented 2 | Fraxinus spp :: Ash Spp 83 | 300 Broadway | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | 3x3 | 6012009.31763 | 2118795.25368 | 37.7984840054917 | -122.402520057652 | (37.7984840054917, -122.402520057652) | |||
| 27042 | 27042 | 128824 | Undocumented 2 | Fraxinus spp :: Ash Spp 83 | 600 Market St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 5ft | 6011998.07084 | 2115236.9646099997 | 37.7887131646294 | -122.40230865672301 | (37.7887131646294, -122.402308656723) | |||
| 34034 | 34034 | 128825 | Undocumented 2 | Fraxinus spp :: Ash Spp 83 | 600 Market St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 5ft | 6011989.53481 | 2115248.11567 | 37.7887433063148 | -122.40233897468399 | (37.7887433063148, -122.402338974684) | |||
| 73373 | 73373 | 109478 | Undocumented 2 | Fraxinus spp :: Ash Spp 83 | 300 Broadway | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | 3x3 | 6011984.93585 | 2118790.70315 | 37.798470149639705 | -122.402604106489 | (37.7984701496397, -122.402604106489) | |||
| 149205 | 149205 | 109479 | Undocumented 2 | Fraxinus spp :: Ash Spp 83 | 300 Broadway | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 3x3 | 6011964.26444 | 2118788.1652 | 37.798462026943895 | -122.402675457803 | (37.7984620269439, -122.402675457803) | |||
| 64965 | 64965 | 192311 | Undocumented 2 | Fraxinus spp :: Ash Spp 83 | 100 De Haro St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 4ft | 6011948.83417 | 2107324.65535 | 37.766985039447896 | -122.401922580457 | (37.7669850394479, -122.401922580457) | |||
| 33085 | 33085 | 109480 | Undocumented 2 | Fraxinus spp :: Ash Spp 83 | 300 Broadway | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | 3x3 | 6011947.44314 | 2118785.89715 | 37.7984548602505 | -122.402733505447 | (37.7984548602505, -122.402733505447) | |||
| 188995 | 188995 | 192310 | Undocumented 2 | Fraxinus spp :: Ash Spp 83 | 100 De Haro St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 4ft | 6011946.18566 | 2107352.67758 | 37.76706183436821 | -122.40193371137501 | (37.7670618343682, -122.401933711375) | |||
| 28167 | 28167 | 192309 | Undocumented 2 | Fraxinus spp :: Ash Spp 83 | 100 De Haro St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 4ft | 6011943.7523300005 | 2107376.90821 | 37.767128230416105 | -122.401943831469 | (37.7671282304161, -122.401943831469) | |||
| 71362 | 71362 | 192308 | Undocumented 2 | Fraxinus spp :: Ash Spp 83 | 100 De Haro St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 4ft | 6011941.9905 | 2107419.77079 | 37.7672458230764 | -122.401952938871 | (37.7672458230764, -122.401952938871) | |||
| 132714 | 132714 | 128826 | Undocumented 2 | Fraxinus spp :: Ash Spp 83 | 600 Market St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 6ft | 6011941.770380001 | 2115192.79079 | 37.7885887308418 | -122.40250034183 | (37.7885887308418, -122.40250034183) | |||
| 163536 | 163536 | 192307 | Undocumented 2 | Fraxinus spp :: Ash Spp 83 | 100 De Haro St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 4ft | 6011941.53927 | 2107440.75625 | 37.7673034192378 | -122.40195597501001 | (37.7673034192378, -122.40195597501) | |||
| 136969 | 136969 | 109481 | Undocumented 2 | Fraxinus spp :: Ash Spp 83 | 300 Broadway | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | 3x3 | 6011927.997819999 | 2118783.50855 | 37.7984472160146 | -122.402800624568 | (37.7984472160146, -122.402800624568) | |||
| 152668 | 152668 | 192298 | Undocumented 2 | Fraxinus spp :: Ash Spp 83 | 2200 24th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6011908.73866 | 2102359.4276900003 | 37.7533493881837 | -122.40171222904699 | (37.7533493881837, -122.401712229047) | |||
| 138091 | 138091 | 75974 | Undocumented 2 | Fraxinus spp :: Ash Spp 83 | 350 Broadway | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/07/1995 12:00:00 AM | 15 | 6011885.57896 | 2118777.06264 | 37.7984271485395 | -122.402946954135 | (37.7984271485395, -122.402946954135) | ||
| 23787 | 23787 | 192299 | Undocumented 2 | Fraxinus spp :: Ash Spp 83 | 2250 24th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6011852.1113599995 | 2102354.12957 | 37.7533316805221 | -122.401907686797 | (37.7533316805221, -122.401907686797) | |||
| 146501 | 146501 | 75946 | Undocumented 2 | Fraxinus spp :: Ash Spp 83 | 350 Broadway | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/07/1995 12:00:00 AM | 13 | 6011842.29348 | 2118770.98259 | 37.7984080370505 | -122.403096308158 | (37.7984080370505, -122.403096308158) | ||
| 131706 | 131706 | 192300 | Undocumented 2 | Fraxinus spp :: Ash Spp 83 | 2250 24th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 3ft | 6011831.68624 | 2102353.37218 | 37.7533284609567 | -122.401978268278 | (37.7533284609567, -122.401978268278) | |||
| 155272 | 155272 | 75920 | Undocumented 2 | Fraxinus spp :: Ash Spp 83 | 350 Broadway | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/07/1995 12:00:00 AM | 12 | 6011822.33856 | 2118769.3001099997 | 37.7984023029841 | -122.403165240278 | (37.7984023029841, -122.403165240278) | ||
| 175214 | 175214 | 192301 | Undocumented 2 | Fraxinus spp :: Ash Spp 83 | 2250 24th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6011807.32161 | 2102351.9134 | 37.753323095606106 | -122.402062424168 | (37.7533230956061, -122.402062424168) | |||
| 47641 | 47641 | 75888 | Undocumented 2 | Fraxinus spp :: Ash Spp 83 | 350 Broadway | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/07/1995 12:00:00 AM | 13 | 6011802.87578 | 2118766.0417 | 37.7983922692391 | -122.40323235850501 | (37.7983922692391, -122.403232358505) | ||
| 69720 | 69720 | 192302 | Undocumented 2 | Fraxinus spp :: Ash Spp 83 | 2250 24th St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6011784.47888 | 2102348.07827 | 37.753311290205296 | -122.402141149916 | (37.7533112902053, -122.402141149916) | |||
| 186545 | 186545 | 75860 | Undocumented 2 | Fraxinus spp :: Ash Spp 83 | 350 Broadway | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/07/1995 12:00:00 AM | 9 | 6011761.31231 | 2118758.70866 | 37.7983698131588 | -122.40337566547701 | (37.7983698131588, -122.403375665477) | ||
| 47218 | 47218 | 192303 | Undocumented 2 | Fraxinus spp :: Ash Spp 83 | 2250 24th St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6011758.176530001 | 2102347.8311400004 | 37.753309143502605 | -122.402232092032 | (37.7533091435026, -122.402232092032) | |||
| 48659 | 48659 | 75815 | Undocumented 2 | Fraxinus spp :: Ash Spp 83 | 350 Broadway | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/07/1995 12:00:00 AM | 7 | 6011743.63854 | 2118757.50225 | 37.7983655135139 | -122.403436737532 | (37.7983655135139, -122.403436737532) | ||
| 156923 | 156923 | 192312 | Undocumented 2 | Fraxinus spp :: Ash Spp 83 | 195 Rhode Island St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 5ft | 6011718.3988 | 2107518.4291 | 37.767504235158704 | -122.402733253659 | (37.7675042351587, -122.402733253659) | |||
| 65451 | 65451 | 192313 | Undocumented 2 | Fraxinus spp :: Ash Spp 83 | 195 Rhode Island St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 5ft | 6011716.39826 | 2107540.40476 | 37.767564463659 | -122.402741718952 | (37.767564463659, -122.402741718952) | |||
| 181015 | 181015 | 192314 | Undocumented 2 | Fraxinus spp :: Ash Spp 83 | 195 Rhode Island St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 5ft | 6011714.34761 | 2107590.0026599998 | 37.767700533789395 | -122.402752300399 | (37.7677005337894, -122.402752300399) | |||
| 163044 | 163044 | 192316 | Undocumented 2 | Fraxinus spp :: Ash Spp 83 | 195 Rhode Island St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 5ft | 6011712.06819 | 2107638.3864700003 | 37.7678332575256 | -122.40276358778401 | (37.7678332575256, -122.402763587784) | |||
| 66462 | 66462 | 192315 | Undocumented 2 | Fraxinus spp :: Ash Spp 83 | 195 Rhode Island St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 5ft | 6011711.98857 | 2107614.42243 | 37.7677674532432 | -122.402762177653 | (37.7677674532432, -122.402762177653) | |||
| 62885 | 62885 | 192317 | Undocumented 2 | Fraxinus spp :: Ash Spp 83 | 195 Rhode Island St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 5ft | 6011711.332 | 2107662.3671 | 37.7678990618091 | -122.402767820894 | (37.7678990618091, -122.402767820894) | |||
| 30684 | 30684 | 192318 | Undocumented 2 | Fraxinus spp :: Ash Spp 83 | 195 Rhode Island St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 5ft | 6011708.94846 | 2107685.56864 | 37.7679626349073 | -122.402777697245 | (37.7679626349073, -122.402777697245) | |||
| 136735 | 136735 | 192319 | Undocumented 2 | Fraxinus spp :: Ash Spp 83 | 195 Rhode Island St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 5ft | 6011708.18751 | 2107708.3313599997 | 37.7680250937009 | -122.40278193035401 | (37.7680250937009, -122.402781930354) | |||
| 147600 | 147600 | 192320 | Undocumented 2 | Fraxinus spp :: Ash Spp 83 | 195 Rhode Island St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 5ft | 6011706.66906 | 2107733.95245 | 37.768095358635996 | -122.402788984646 | (37.768095358636, -122.402788984646) | |||
| 67772 | 67772 | 192321 | Undocumented 2 | Fraxinus spp :: Ash Spp 83 | 195 Rhode Island St | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 5ft | 6011705.72913 | 2107757.93723 | 37.7681611629347 | -122.402793922805 | (37.7681611629347, -122.402793922805) | |||
| 28457 | 28457 | 192322 | Undocumented 2 | Fraxinus spp :: Ash Spp 83 | 193 Rhode Island St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 5ft | 6011704.5689199995 | 2107781.11389 | 37.7682247360183 | -122.40279956606301 | (37.7682247360183, -122.402799566063) | |||
| 189119 | 189119 | 192323 | Undocumented 2 | Fraxinus spp :: Ash Spp 83 | 193 Rhode Island St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 5ft | 6011703.7817400005 | 2107812.61007 | 37.7683111734485 | -122.402804504224 | (37.7683111734485, -122.402804504224) | |||
| 54845 | 54845 | 192324 | Undocumented 2 | Fraxinus spp :: Ash Spp 83 | 193 Rhode Island St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 5ft | 6011702.91759 | 2107830.29721 | 37.7683596900813 | -122.40280873732999 | (37.7683596900813, -122.40280873733) | |||
| 49946 | 49946 | 192325 | Undocumented 2 | Fraxinus spp :: Ash Spp 83 | 193 Rhode Island St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 5ft | 6011700.9501 | 2107853.89642 | 37.768424378313206 | -122.40281720266199 | (37.7684243783132, -122.402817202662) | |||
| 168506 | 168506 | 192326 | Undocumented 2 | Fraxinus spp :: Ash Spp 83 | 193 Rhode Island St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 5ft | 6011698.18772 | 2107878.52746 | 37.7684918553317 | -122.40282849005699 | (37.7684918553317, -122.402828490057) | |||
| 40032 | 40032 | 45645 | Permitted Site 1 | Fraxinus spp :: Ash Spp 83 | 1020 Kearny St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/14/2001 12:00:00 AM | 10 | Permit Number 44346 | 6011201.4795699995 | 2118401.58307 | 37.7973579490636 | -122.40528770508999 | (37.7973579490636, -122.40528770509) | ||
| 158173 | 158173 | 45643 | Permitted Site 1 | Fraxinus spp :: Ash Spp 83 | 1020 Kearny St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/14/2001 12:00:00 AM | 13 | Permit Number 44346 | 6011195.59877 | 2118453.88611 | 37.797501231757 | -122.40531173944599 | (37.797501231757, -122.405311739446) | ||
| 54421 | 54421 | 128827 | Undocumented 2 | Fraxinus spp :: Ash Spp 83 | 1048 Kearny St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 3ft | 6011178.99904 | 2118580.19305 | 37.797847111915395 | -122.405378078855 | (37.7978471119154, -122.405378078855) | |||
| 170242 | 170242 | 192294 | Undocumented 2 | Fraxinus spp :: Ash Spp 83 | 551 Utah St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 4ft | 6010701.8989 | 2105624.20056 | 37.7622463056326 | -122.40611574324 | (37.7622463056326, -122.40611574324) | |||
| 25212 | 25212 | 192295 | Undocumented 2 | Fraxinus spp :: Ash Spp 83 | 551 Utah St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 5ft | 6010700.612380001 | 2105651.26498 | 37.7623205464704 | -122.406122099663 | (37.7623205464704, -122.406122099663) | |||
| 188952 | 188952 | 192296 | Undocumented 2 | Fraxinus spp :: Ash Spp 83 | 551 Utah St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 4ft | 6010697.50187 | 2105678.84279 | 37.762396094938104 | -122.406134800806 | (37.7623960949381, -122.406134800806) | |||
| 69712 | 69712 | 192297 | Undocumented 2 | Fraxinus spp :: Ash Spp 83 | 551 Utah St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 2ft | 6010694.42792 | 2105749.21353 | 37.7625891451824 | -122.406150390541 | (37.7625891451824, -122.406150390541) | |||
| 46622 | 46622 | 248136 | Undocumented 2 | Fraxinus spp :: Ash Spp 83 | 226 Rutledge St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 2ft | 6010037.88024 | 2099520.31318 | 37.745449227116204 | -122.407981876971 | (37.7454492271162, -122.407981876971) | |||
| 33563 | 33563 | 192305 | Undocumented 2 | Fraxinus spp :: Ash Spp 83 | 2599 Mariposa St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6009925.06485 | 2105936.96188 | 37.763061595931894 | -122.40882459747 | (37.7630615959319, -122.40882459747) | |||
| 134588 | 134588 | 192304 | Undocumented 2 | Fraxinus spp :: Ash Spp 83 | 2599 Mariposa St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6009910.49486 | 2105936.61453 | 37.7630598260768 | -122.40887496583001 | (37.7630598260768, -122.40887496583) | |||
| 150402 | 150402 | 192229 | Undocumented 2 | Fraxinus spp :: Ash Spp 83 | 1192 Bryant St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6009648.37032 | 2108577.40653 | 37.7702961480689 | -122.409968002743 | (37.7702961480689, -122.409968002743) | |||
| 167643 | 167643 | 192230 | Undocumented 2 | Fraxinus spp :: Ash Spp 83 | 1192 Bryant St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6009632.52889 | 2108561.57413 | 37.7702517881052 | -122.41002168056299 | (37.7702517881052, -122.410021680563) | |||
| 130336 | 130336 | 192228 | Undocumented 2 | Fraxinus spp :: Ash Spp 83 | 340 10th St | 26 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6009630.58485 | 2108639.1143400003 | 37.770464586603 | -122.410033879882 | (37.770464586603, -122.410033879882) | |||
| 151652 | 151652 | 192231 | Undocumented 2 | Fraxinus spp :: Ash Spp 83 | 1192 Bryant St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6009620.79732 | 2108551.27729 | 37.7702228578355 | -122.410061533137 | (37.7702228578355, -122.410061533137) | |||
| 186884 | 186884 | 192227 | Undocumented 2 | Fraxinus spp :: Ash Spp 83 | 340 10th St | 25 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6009609.32047 | 2108657.10894 | 37.7705128037596 | -122.41010870437799 | (37.7705128037596, -122.410108704378) | |||
| 34317 | 34317 | 192232 | Undocumented 2 | Fraxinus spp :: Ash Spp 83 | 1192 Bryant St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6009598.466630001 | 2108528.5531599997 | 37.7701592110077 | -122.41013717060899 | (37.7701592110077, -122.410137170609) | |||
| 53709 | 53709 | 192226 | Undocumented 2 | Fraxinus spp :: Ash Spp 83 | 340 10th St | 24 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6009587.30245 | 2108684.25048 | 37.7705860940019 | -122.410186781721 | (37.7705860940019, -122.410186781721) | |||
| 169673 | 169673 | 192233 | Undocumented 2 | Fraxinus spp :: Ash Spp 83 | 1192 Bryant St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6009583.6177 | 2108515.2759 | 37.7701219224206 | -122.41018759559401 | (37.7701219224206, -122.410187595594) | |||
| 169637 | 169637 | 192234 | Undocumented 2 | Fraxinus spp :: Ash Spp 83 | 1192 Bryant St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6009571.19084 | 2108505.46163 | 37.7700942781462 | -122.410229887119 | (37.7700942781462, -122.410229887119) | |||
| 173132 | 173132 | 192225 | Undocumented 2 | Fraxinus spp :: Ash Spp 83 | 340 10th St | 23 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6009566.76232 | 2108703.16706 | 37.770636883201206 | -122.41025916634399 | (37.7706368832012, -122.410259166344) | |||
| 178248 | 178248 | 192235 | Undocumented 2 | Fraxinus spp :: Ash Spp 83 | 1192 Bryant St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6009557.26279 | 2108491.22918 | 37.7700544184084 | -122.410277059238 | (37.7700544184084, -122.410277059238) | |||
| 29899 | 29899 | 192224 | Undocumented 2 | Fraxinus spp :: Ash Spp 83 | 340 10th St | 22 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6009548.42342 | 2108726.25306 | 37.770699244008895 | -122.410324231382 | (37.7706992440089, -122.410324231382) | |||
| 181341 | 181341 | 192236 | Undocumented 2 | Fraxinus spp :: Ash Spp 83 | 1192 Bryant St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6009533.94871 | 2108466.41752 | 37.7699849844405 | -122.41035595047899 | (37.7699849844405, -122.410355950479) | |||
| 52957 | 52957 | 192223 | Undocumented 2 | Fraxinus spp :: Ash Spp 83 | 340 10th St | 21 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6009532.03276 | 2108741.1041599996 | 37.77073910287 | -122.410381975954 | (37.77073910287, -122.410381975954) | |||
| 174228 | 174228 | 192222 | Undocumented 2 | Fraxinus spp :: Ash Spp 83 | 340 10th St | 20 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6009520.501130001 | 2108752.11009 | 37.7707686761527 | -122.410422641486 | (37.7707686761527, -122.410422641486) | |||
| 25322 | 25322 | 192237 | Undocumented 2 | Fraxinus spp :: Ash Spp 83 | 1192 Bryant St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6009520.068659999 | 2108454.52562 | 37.7699515539505 | -122.410403121719 | (37.7699515539505, -122.410403121719) | |||
| 122157 | 122157 | 192238 | Undocumented 2 | Fraxinus spp :: Ash Spp 83 | 1192 Bryant St | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6009506.6298 | 2108441.21994 | 37.769914266262205 | -122.410448666999 | (37.7699142662622, -122.410448666999) | |||
| 30042 | 30042 | 192221 | Undocumented 2 | Fraxinus spp :: Ash Spp 83 | 340 10th St | 19 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6009500.9778 | 2108774.7519400003 | 37.7708297509354 | -122.41049177239599 | (37.7708297509354, -122.410491772396) | |||
| 50297 | 50297 | 192239 | Undocumented 2 | Fraxinus spp :: Ash Spp 83 | 1192 Bryant St | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6009494.20262 | 2108431.40539 | 37.769886621106295 | -122.410490959396 | (37.7698866211063, -122.410490959396) | |||
| 133631 | 133631 | 192220 | Undocumented 2 | Fraxinus spp :: Ash Spp 83 | 340 10th St | 18 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6009488.97607 | 2108785.76749 | 37.770859324239105 | -122.410534064794 | (37.7708593242391, -122.410534064794) | |||
| 42094 | 42094 | 192240 | Undocumented 2 | Fraxinus spp :: Ash Spp 83 | 1192 Bryant St | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6009484.38016 | 2108422.4744 | 37.7698615480128 | -122.41052430446001 | (37.7698615480128, -122.41052430446) | |||
| 188795 | 188795 | 192219 | Undocumented 2 | Fraxinus spp :: Ash Spp 83 | 340 10th St | 17 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6009481.185869999 | 2108795.76031 | 37.770886325461504 | -122.410561717149 | (37.7708863254615, -122.410561717149) | |||
| 41323 | 41323 | 192218 | Undocumented 2 | Fraxinus spp :: Ash Spp 83 | 340 10th St | 16 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6009470.84858 | 2108807.6783 | 37.770918469946295 | -122.410598315981 | (37.7709184699463, -122.410598315981) | |||
| 186425 | 186425 | 192241 | Undocumented 2 | Fraxinus spp :: Ash Spp 83 | 1192 Bryant St | 13 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6009464.70125 | 2108402.9741599998 | 37.7698069016093 | -122.41059099638599 | (37.7698069016093, -122.410590996386) | |||
| 151326 | 151326 | 192217 | Undocumented 2 | Fraxinus spp :: Ash Spp 83 | 340 10th St | 15 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6009459.542640001 | 2108818.21129 | 37.7709467572235 | -122.410638167623 | (37.7709467572235, -122.410638167623) | |||
| 37426 | 37426 | 192216 | Undocumented 2 | Fraxinus spp :: Ash Spp 83 | 340 10th St | 14 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6009448.92717 | 2108828.0279599996 | 37.7709731163511 | -122.410675580336 | (37.7709731163511, -122.410675580336) | |||
| 176443 | 176443 | 192242 | Undocumented 2 | Fraxinus spp :: Ash Spp 83 | 1192 Bryant St | 14 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6009444.52854 | 2108382.3130900003 | 37.7697490401119 | -122.41065931427299 | (37.7697490401119, -122.410659314273) | |||
| 188482 | 188482 | 192215 | Undocumented 2 | Fraxinus spp :: Ash Spp 83 | 340 10th St | 13 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6009439.261530001 | 2108838.29328 | 37.77100076061021 | -122.410709739261 | (37.7710007606102, -122.410709739261) | |||
| 158448 | 158448 | 192243 | Undocumented 2 | Fraxinus spp :: Ash Spp 83 | 1192 Bryant St | 15 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6009432.09679 | 2108372.2648 | 37.7697207528275 | -122.41070160579599 | (37.7697207528275, -122.410701605796) | |||
| 57400 | 57400 | 192214 | Undocumented 2 | Fraxinus spp :: Ash Spp 83 | 340 10th St | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6009421.09589 | 2108858.33176 | 37.7710547630982 | -122.41077399042 | (37.7710547630982, -122.41077399042) | |||
| 44739 | 44739 | 192244 | Undocumented 2 | Fraxinus spp :: Ash Spp 83 | 1192 Bryant St | 16 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6009411.93836 | 2108352.3057 | 37.7696648195127 | -122.410769923705 | (37.7696648195127, -122.410769923705) | |||
| 34513 | 34513 | 192213 | Undocumented 2 | Fraxinus spp :: Ash Spp 83 | 340 10th St | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6009411.17621 | 2108867.66587 | 37.7710798361979 | -122.410808962379 | (37.7710798361979, -122.410808962379) | |||
| 160485 | 160485 | 192212 | Undocumented 2 | Fraxinus spp :: Ash Spp 83 | 340 10th St | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6009404.47018 | 2108873.18774 | 37.771094621956294 | -122.410832548904 | (37.7710946219563, -122.410832548904) | |||
| 160879 | 160879 | 192245 | Undocumented 2 | Fraxinus spp :: Ash Spp 83 | 1192 Bryant St | 17 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6009401.17079 | 2108343.15985 | 37.7696391033908 | -122.410806522516 | (37.7696391033908, -122.410806522516) | |||
| 159958 | 159958 | 192246 | Undocumented 2 | Fraxinus spp :: Ash Spp 83 | 1192 Bryant St | 18 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 6009392.3217400005 | 2108335.84797 | 37.769618530488295 | -122.410836614725 | (37.7696185304883, -122.410836614725) | |||
| 27145 | 27145 | 192211 | Undocumented 2 | Fraxinus spp :: Ash Spp 83 | 340 10th St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6009388.568940001 | 2108888.9656700003 | 37.7711370528685 | -122.410888666597 | (37.7711370528685, -122.410888666597) | |||
| 43494 | 43494 | 192247 | Undocumented 2 | Fraxinus spp :: Ash Spp 83 | 1192 Bryant St | 19 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6009385.61181 | 2108329.66334 | 37.76960117269039 | -122.410859387372 | (37.7696011726904, -122.410859387372) |
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");