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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 95203 | 95203 | 3434 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 7050X California St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 3X3 | 5985752.92206 | 2113916.9124 | 37.7835886933669 | -122.493014498456 | (37.7835886933669, -122.493014498456) | |||
| 95597 | 95597 | 3437 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 7050X California St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 3X3 | 5985752.92206 | 2113916.9124 | 37.7835886933669 | -122.493014498456 | (37.7835886933669, -122.493014498456) | |||
| 112668 | 112668 | 3432 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 7050X California St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 3X3 | 5985752.92206 | 2113916.9124 | 37.7835886933669 | -122.493014498456 | (37.7835886933669, -122.493014498456) | |||
| 114435 | 114435 | 3436 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 7050X California St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 3X3 | 5985752.92206 | 2113916.9124 | 37.7835886933669 | -122.493014498456 | (37.7835886933669, -122.493014498456) | |||
| 122785 | 122785 | 3435 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 7050X California St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 3X3 | 5985752.92206 | 2113916.9124 | 37.7835886933669 | -122.493014498456 | (37.7835886933669, -122.493014498456) | |||
| 38838 | 38838 | 250972 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 7010 California St | 1 | : 4 | Tree 1 | Private 1 | 3 | Width 4ft | 5985754.51701 | 2113919.45983 | 37.78359578115 | -122.493009168333 | (37.78359578115, -122.493009168333) | |||
| 65973 | 65973 | 32610 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 3200 Irving St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/23/1996 12:00:00 AM | 6 | Permit Number 37075 | 5985761.6347 | 2106405.465 | 37.762964898882295 | -122.49243102202699 | (37.7629648988823, -122.492431022027) | |
| 132866 | 132866 | 32609 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 3200 Irving St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/23/1996 12:00:00 AM | 7 | Permit Number 37075 | 5985785.2482 | 2106404.8747 | 37.762964658627 | -122.492349308745 | (37.762964658627, -122.492349308745) | |
| 33534 | 33534 | 48888 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 3132 Clement St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/22/2002 12:00:00 AM | 8 | Permit Number 46094 | 5985804.5371900005 | 2113240.84362 | 37.7817354218334 | -122.492786120653 | (37.7817354218334, -122.492786120653) | ||
| 140402 | 140402 | 3429 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 7004 California St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 45 | 3X3 | 5985822.36441 | 2113950.31704 | 37.783684473765994 | -122.492776719205 | (37.783684473766, -122.492776719205) | |||
| 56426 | 56426 | 250971 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 7002 California St | 1 | : 4 | Tree 1 | Private 1 | 10 | Width 4ft | 5985825.16294 | 2113921.74383 | 37.783606183626105 | -122.492764932276 | (37.7836061836261, -122.492764932276) | |||
| 177614 | 177614 | 119589 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 6951 California St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 3ft | 5985952.115569999 | 2113870.87059 | 37.783473923115004 | -122.492321983626 | (37.783473923115, -122.492321983626) | |||
| 187734 | 187734 | 119588 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 6945 California St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 19 | Width 3ft | 5985990.827880001 | 2113870.4748 | 37.7834750995118 | -122.49218802684099 | (37.7834750995118, -122.492188026841) | |||
| 29631 | 29631 | 250970 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 6932 California St | 1 | : 4 | Tree 1 | Private 1 | 9 | Width 4ft | 5985996.4910699995 | 2113927.35673 | 37.7836316119485 | -122.49217262437 | (37.7836316119485, -122.49217262437) | |||
| 128508 | 128508 | 3428 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 6941 California St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 75 | 3X3 | 5986006.25381 | 2113811.6066799997 | 37.783314366378995 | -122.492130323992 | (37.783314366379, -122.492130323992) | |||
| 87931 | 87931 | 3427 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 6935 California St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 35 | 3X3 | 5986031.23866 | 2113812.47414 | 37.7833182086658 | -122.49204395142799 | (37.7833182086658, -122.492043951428) | |||
| 117646 | 117646 | 724 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 6933X California St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 35 | 3X3 | 5986042.95345 | 2113873.6493599997 | 37.783486862959705 | -122.492007929 | (37.7834868629597, -122.492007929) | |||
| 97747 | 97747 | 111712 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 3001x CLEMENT ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5986078.0 | 2113222.0 | 37.7816996697749 | -122.491838693524 | (37.7816996697749, -122.491838693524) | ||||
| 122234 | 122234 | 104348 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 3001X Clement St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6x9 | 5986078.49957 | 2113222.60189 | 37.781701351590705 | -122.49183700959601 | (37.7817013515907, -122.491837009596) | ||||
| 140954 | 140954 | 104349 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 3001X Clement St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7x9 | 5986078.49957 | 2113222.60189 | 37.781701351590705 | -122.49183700959601 | (37.7817013515907, -122.491837009596) | ||||
| 142193 | 142193 | 3426 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 6923 California St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 35 | 3X3 | 5986081.208380001 | 2113814.2097 | 37.783325894808 | -122.491871206253 | (37.783325894808, -122.491871206253) | |||
| 153181 | 153181 | 119587 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 6915 California St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 3ft | 5986093.74324 | 2113874.71044 | 37.78349274505229 | -122.491832296674 | (37.7834927450523, -122.491832296674) | |||
| 55403 | 55403 | 250969 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 6924 California St | 3 | : 4 | Tree 1 | Private 1 | 8 | Width 4ft | 5986098.00978 | 2113930.24714 | 37.7836454821978 | -122.49182162619199 | (37.7836454821978, -122.491821626192) | |||
| 91298 | 91298 | 722 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 6920X California St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 45 | 3X3 | 5986139.11309 | 2113930.71339 | 37.7836491646774 | -122.491679460735 | (37.7836491646774, -122.491679460735) | |||
| 110395 | 110395 | 3425 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 6909 California St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 55 | 3X3 | 5986140.62624 | 2113874.1409400003 | 37.7834939214569 | -122.49167006003599 | (37.7834939214569, -122.491670060036) | |||
| 55279 | 55279 | 250816 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 66 Sea View Ter | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 9 | Width 4ft | 5986143.35026 | 2114166.31593 | 37.7842963089792 | -122.491682151215 | (37.7842963089792, -122.491682151215) | |||
| 34041 | 34041 | 250815 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 66 Sea View Ter | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 8 | Width 4ft | 5986156.52823 | 2114164.57331 | 37.784292294401 | -122.491636432381 | (37.784292294401, -122.491636432381) | |||
| 160860 | 160860 | 111711 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 3001x Clement St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | 3x3 | 5986162.80344 | 2113197.5077400003 | 37.781637377269 | -122.491543514354 | (37.781637377269, -122.491543514354) | |||
| 73953 | 73953 | 250814 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 66 Sea View Ter | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 10 | Width 4ft | 5986166.78643 | 2114163.6239 | 37.7842902870978 | -122.491600873197 | (37.7842902870978, -122.491600873197) | |||
| 82840 | 82840 | 720 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 6910X California St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3 | 5986168.89485 | 2113931.77767 | 37.7836538273778 | -122.491576507002 | (37.7836538273778, -122.491576507002) | |||
| 114035 | 114035 | 719 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 6910X California St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 45 | 3 | 5986168.89485 | 2113931.77767 | 37.7836538273778 | -122.491576507002 | (37.7836538273778, -122.491576507002) | |||
| 71475 | 71475 | 119320 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 3001 Clement St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 3ft | 5986187.45938 | 2113197.50531 | 37.7816388114384 | -122.491458217519 | (37.7816388114384, -122.491458217519) | |||
| 60770 | 60770 | 104346 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 417 31st Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | 4x9 | 5986214.274119999 | 2113133.51512 | 37.7814646796583 | -122.491360741327 | (37.7814646796583, -122.491360741327) | |||
| 161274 | 161274 | 104347 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 417 31st Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | 4x9 | 5986214.92159 | 2113090.52274 | 37.78134667274529 | -122.49135533616999 | (37.7813466727453, -122.49135533617) | |||
| 76263 | 76263 | 119383 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 340 31st Ave | 5 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 12 | Width 3ft | 5986240.80118 | 2113637.97739 | 37.7828513382696 | -122.491306111206 | (37.7828513382696, -122.491306111206) | |||
| 29612 | 29612 | 119384 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 340 31st Ave | 4 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 13 | Width 3ft | 5986242.52312 | 2113595.8501 | 37.78273576945529 | -122.491297052566 | (37.7827357694553, -122.491297052566) | |||
| 31024 | 31024 | 119385 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 340 31st Ave | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 17 | Width 3ft | 5986245.2794 | 2113549.60335 | 37.7826089502225 | -122.491284112348 | (37.7826089502225, -122.491284112348) | |||
| 129062 | 129062 | 718 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 6820X California St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 45 | 5x33 | 5986263.20776 | 2113937.4435799997 | 37.783674895540706 | -122.491250641927 | (37.7836748955407, -122.491250641927) | |||
| 165505 | 165505 | 119396 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 6851 California St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 5986265.27048 | 2113882.8651099997 | 37.7835251592936 | -122.49123948764799 | (37.7835251592936, -122.491239487648) | |||
| 179695 | 179695 | 250968 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 6542 California St | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 11 | Width 4ft | 5986266.0021 | 2113938.0378400004 | 37.783676690482004 | -122.49124101845699 | (37.783676690482, -122.491241018457) | |||
| 117882 | 117882 | 717 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 6820X California St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 65 | 5 | 5986305.22988 | 2113941.78658 | 37.783689275454705 | -122.49110558308901 | (37.7836892754547, -122.491105583089) | |||
| 134246 | 134246 | 250967 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 6542 California St | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 10 | Width 4ft | 5986305.7572 | 2113938.87572 | 37.78368131388 | -122.491103544499 | (37.78368131388, -122.491103544499) | |||
| 107078 | 107078 | 84309 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 851 31st Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/08/2008 12:00:00 AM | 3x3 | Permit Number 51853 | 5986320.037019799 | 2110116.74258849 | 37.7731876600069 | -122.49077281705 | (37.7731876600069, -122.49077281705) | ||
| 167677 | 167677 | 84556 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 851 31st Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/16/2006 12:00:00 AM | 5 | 5986323.51581 | 2110116.60697 | 37.7731874908554 | -122.49076077364201 | (37.7731874908554, -122.490760773642) | ||
| 138348 | 138348 | 716 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 6820X California St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 45 | 5x33 | 5986347.76159 | 2113942.4719599998 | 37.783693642189 | -122.490958491989 | (37.783693642189, -122.490958491989) | |||
| 126148 | 126148 | 3424 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 6833 California St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 45 | 3X3 | 5986349.10744 | 2113885.75045 | 37.7835379798624 | -122.490949660605 | (37.7835379798624, -122.490949660605) | |||
| 42642 | 42642 | 250966 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 6542 California St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 8 | Width 4ft | 5986349.34208 | 2113940.89483 | 37.7836894041789 | -122.490952908074 | (37.7836894041789, -122.490952908074) | |||
| 152604 | 152604 | 84305 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 846 31st Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/11/2008 12:00:00 AM | 2 | 3x3 | Permit Number 51905 | 5986366.33203 | 2110148.04849 | 37.77327632146471 | -122.490614982457 | (37.7732763214647, -122.490614982457) | |
| 119423 | 119423 | 721 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 6859X California St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 45 | 3X3 | 5986379.68484 | 2113889.27863 | 37.783549453567 | -122.49084413577101 | (37.783549453567, -122.490844135771) | |||
| 46424 | 46424 | 250965 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 6540 California St | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 11 | Width 4ft | 5986394.617190001 | 2113942.87838 | 37.7836974953865 | -122.490796421524 | (37.7836974953865, -122.490796421524) | |||
| 128102 | 128102 | 715 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 6810X California St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 45 | 5x33 | 5986402.41509 | 2113942.22606 | 37.7836961598318 | -122.490769396103 | (37.7836961598318, -122.490769396103) | |||
| 143831 | 143831 | 3423 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 6815 California St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 45 | 3X3 | 5986408.872219999 | 2113888.5255400003 | 37.7835490908414 | -122.490743104657 | (37.7835490908414, -122.490743104657) | |||
| 126365 | 126365 | 3422 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 6809 California St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 65 | 3x3 | 5986450.76116 | 2113888.56834 | 37.7835516552386 | -122.49059819022699 | (37.7835516552386, -122.490598190227) | |||
| 176105 | 176105 | 250964 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 6540 California St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 12 | Width 4ft | 5986452.15501 | 2113945.02201 | 37.7837067422095 | -122.490597522969 | (37.7837067422095, -122.490597522969) | |||
| 128019 | 128019 | 714 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 6810X California St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 75 | 5x33 | 5986452.35935 | 2113947.57202 | 37.7837137557398 | -122.490597003715 | (37.7837137557398, -122.490597003715) | |||
| 177211 | 177211 | 119571 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 341 30th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 11 | Width 3ft | 5986507.8802 | 2113640.35291 | 37.7828734631545 | -122.49038231698 | (37.7828734631545, -122.49038231698) | |||
| 153513 | 153513 | 119572 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 341 30th Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 17 | Width 3ft | 5986508.67785 | 2113597.38194 | 37.7827555237835 | -122.490376395298 | (37.7827555237835, -122.490376395298) | |||
| 42376 | 42376 | 119573 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 341 30th Ave | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 14 | Width 3ft | 5986510.27034 | 2113543.4852 | 37.782607631800396 | -122.49036691985901 | (37.7826076318004, -122.490366919859) | |||
| 46812 | 46812 | 182458 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 1500 31st Ave | 6 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 16 | Width 0ft | 5986548.9803 | 2104767.4719 | 37.758513422441204 | -122.489587443554 | (37.7585134224412, -122.489587443554) | |||
| 59199 | 59199 | 42278 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 1646 31st Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/01/2003 12:00:00 AM | 5 | Permit Number 46652 | 5986569.425 | 2104035.4361 | 37.756504646339394 | -122.489462910282 | (37.7565046463394, -122.489462910282) | |
| 186717 | 186717 | 250963 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 6538 California St | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 12 | Width 4ft | 5986577.80338 | 2113949.50565 | 37.7837263914907 | -122.490163163006 | (37.7837263914907, -122.490163163006) | |||
| 81785 | 81785 | 3421 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 6743 California St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 75 | 3X3 | 5986605.45058 | 2113893.32578 | 37.7835737522145 | -122.490063381826 | (37.7835737522145, -122.490063381826) | |||
| 28618 | 28618 | 250962 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 6538 California St | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 12 | Width 4ft | 5986619.26657 | 2113951.14977 | 37.78373332707871 | -122.490019838944 | (37.7837333270787, -122.490019838944) | |||
| 182522 | 182522 | 182467 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 2400 Lawton St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 0ft | 5986633.6373 | 2104393.4735 | 37.7574914674542 | -122.489267167866 | (37.7574914674542, -122.489267167866) | |||
| 54635 | 54635 | 250961 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 6538 California St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 13 | Width 4ft | 5986661.98827 | 2113952.34597 | 37.783739106117295 | -122.489872127989 | (37.7837391061173, -122.489872127989) | |||
| 162460 | 162460 | 182466 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 2400 Lawton St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 0ft | 5986664.369 | 2104396.3727 | 37.7575012217053 | -122.48916109989901 | (37.7575012217053, -122.489161099899) | |||
| 81219 | 81219 | 117257 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 1570 31ST AVE | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | 5986686.8 | 2104596.0 | 37.7580506528461 | -122.489098201432 | (37.7580506528461, -122.489098201432) | |||||
| 104601 | 104601 | 3419 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 6705 California St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 45 | 3X3 | 5986705.37127 | 2113895.64572 | 37.7835859565372 | -122.48971787002199 | (37.7835859565372, -122.489717870022) | |||
| 141614 | 141614 | 710 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 6710X California St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 80 | 5 | 5986716.67704 | 2113957.13547 | 37.783755449840996 | -122.489683280356 | (37.783755449841, -122.489683280356) | |||
| 151747 | 151747 | 250960 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 6536 California St | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 13 | Width 4ft | 5986717.82713 | 2113954.10541 | 37.7837471973129 | -122.489679078628 | (37.7837471973129, -122.489679078628) | |||
| 151076 | 151076 | 182463 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 2400 Lawton St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 0ft | 5986737.4291 | 2104398.6921 | 37.7575118543539 | -122.488908602624 | (37.7575118543539, -122.488908602624) | |||
| 171365 | 171365 | 250959 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 6536 California St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 12 | Width 4ft | 5986752.106919999 | 2113955.90215 | 37.783754131992104 | -122.489560617232 | (37.7837541319921, -122.489560617232) | |||
| 125712 | 125712 | 3420 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 6705 California St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 45 | 3X3 | 5986754.0629 | 2113899.4309400003 | 37.783599192434394 | -122.489549696395 | (37.7835991924344, -122.489549696395) | |||
| 88068 | 88068 | 713 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 6720X California St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 14 | 5 | 5986760.01545 | 2113952.9021099997 | 37.783746356447 | -122.489533036385 | (37.783746356447, -122.489533036385) | |||
| 94870 | 94870 | 711 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 6720X California St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 45 | 5 | 5986760.01545 | 2113952.9021099997 | 37.783746356447 | -122.489533036385 | (37.783746356447, -122.489533036385) | |||
| 140386 | 140386 | 712 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 6720X California St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 65 | 5 | 5986760.01545 | 2113952.9021099997 | 37.783746356447 | -122.489533036385 | (37.783746356447, -122.489533036385) | |||
| 145405 | 145405 | 709 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 6710X California St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 65 | 5 | 5986789.82302 | 2113953.9673099997 | 37.783751021306 | -122.489429993159 | (37.783751021306, -122.489429993159) | |||
| 55288 | 55288 | 182461 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 2400 Lawton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 0ft | 5986799.4723 | 2104403.3308 | 37.757528211731 | -122.48869437611401 | (37.757528211731, -122.488694376114) | |||
| 164776 | 164776 | 182557 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 1410 30th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 0ft | 5986831.512999999 | 2105622.5021 | 37.7608775913779 | -122.488673177997 | (37.7608775913779, -122.488673177997) | |||
| 73299 | 73299 | 119920 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 3801 Anza St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 5986853.1969 | 2111817.4989400003 | 37.7778885876115 | -122.48905362873 | (37.7778885876115, -122.48905362873) | |||
| 169469 | 169469 | 112177 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 607 29th Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/17/2015 12:00:00 AM | 9 | 3x3 | Permit Number 777059 | 5986882.7001 | 2111755.36791 | 37.777719715360206 | -122.488946999623 | (37.7777197153602, -122.488946999623) | |
| 177485 | 177485 | 250958 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 6534 California St | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 12 | Width 4ft | 5986885.78325 | 2113960.21653 | 37.7837737812885 | -122.489098470914 | (37.7837737812885, -122.489098470914) | |||
| 69321 | 69321 | 120003 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 631 29th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 5986889.13779 | 2111599.1450799997 | 37.7772911474511 | -122.48891324273599 | (37.7772911474511, -122.488913242736) | |||
| 95943 | 95943 | 3414 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 6641 California St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 45 | 2X2 | 5986907.819080001 | 2113905.3081099996 | 37.783624304644 | -122.489018198295 | (37.783624304644, -122.489018198295) | |||
| 34856 | 34856 | 250957 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 6534 California St | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 12 | Width 4ft | 5986936.54247 | 2113961.66352 | 37.7837807168614 | -122.488922971817 | (37.7837807168614, -122.488922971817) | |||
| 93958 | 93958 | 3415 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 6641 California St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 45 | 2X2 | 5986955.69055 | 2113907.40325 | 37.783632851202796 | -122.488852737582 | (37.7836328512028, -122.488852737582) | |||
| 84292 | 84292 | 3416 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 6650X California St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 45 | 5 | 5986981.14006 | 2113960.8042599997 | 37.7837809602941 | -122.48876861975401 | (37.7837809602941, -122.488768619754) | |||
| 91064 | 91064 | 3417 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 6650X California St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 45 | 5 | 5986981.14006 | 2113960.8042599997 | 37.7837809602941 | -122.48876861975401 | (37.7837809602941, -122.488768619754) | |||
| 93802 | 93802 | 3418 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 6650X California St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 50 | 5 | 5986981.14006 | 2113960.8042599997 | 37.7837809602941 | -122.48876861975401 | (37.7837809602941, -122.488768619754) | |||
| 150117 | 150117 | 250956 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 6534 California St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 11 | Width 4ft | 5986981.781690001 | 2113961.9646099997 | 37.7837841837271 | -122.488766485305 | (37.7837841837271, -122.488766485305) | |||
| 80971 | 80971 | 3413 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 6625 California St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 65 | 2X2 | 5987004.51958 | 2113910.41235 | 37.7836439628806 | -122.48868403128401 | (37.7836439628806, -122.488684031284) | |||
| 85390 | 85390 | 705 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 6640X California St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 75 | 5 | 5987010.88181 | 2113961.86712 | 37.783785614219205 | -122.48866580397 | (37.7837856142192, -122.48866580397) | |||
| 126299 | 126299 | 704 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 6640X California St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 75 | 5 | 5987010.88181 | 2113961.86712 | 37.783785614219205 | -122.48866580397 | (37.7837856142192, -122.48866580397) | |||
| 173122 | 173122 | 250955 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 6532 California St | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 12 | Width 4ft | 5987034.671490001 | 2113964.2082700003 | 37.7837934305581 | -122.488583673816 | (37.7837934305581, -122.488583673816) | |||
| 83749 | 83749 | 3412 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 6619 California St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 45 | 2X2 | 5987053.9069300005 | 2113910.29646 | 37.7836465265666 | -122.488513163635 | (37.7836465265666, -122.488513163635) | |||
| 60783 | 60783 | 250954 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 6532 California St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 15 | Width 4ft | 5987082.436980001 | 2113964.03529 | 37.7837957427146 | -122.48841841257601 | (37.7837957427146, -122.488418412576) | |||
| 101146 | 101146 | 103209 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 1600X 29th Ave | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 11 | 3x4 | 5987181.0332 | 2104341.2684 | 37.757380064215795 | -122.487370243421 | (37.7573800642158, -122.487370243421) | |||
| 46862 | 46862 | 103223 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 1600X 29th Ave | 9 | Sidewalk: Property side : Cutout 5 | Tree 1 | Rec/Park 3 | 11 | 3x4 | 5987183.9948 | 2104224.5811 | 37.7570598454095 | -122.487351430278 | (37.7570598454095, -122.487351430278) | |||
| 32299 | 32299 | 103222 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 1600X 29th Ave | 8 | Sidewalk: Property side : Cutout 5 | Tree 1 | Rec/Park 3 | 11 | 3x4 | 5987186.3641 | 2104162.3873 | 37.7568892163494 | -122.487338668246 | (37.7568892163494, -122.487338668246) | |||
| 61312 | 61312 | 103208 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 1600X 29th Ave | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 12 | 3x4 | 5987188.7333 | 2104102.5628 | 37.7567250927297 | -122.487326080643 | (37.7567250927297, -122.487326080643) |
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");