trees
1,377 rows where qSpecies_id = 61 sorted by XCoord
This data as json, CSV (advanced)
| rowid | TreeID | qLegalStatus_id | qSpecies_id | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker_id | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord ▼ | YCoord | Latitude | Longitude | Location | Fire Prevention Districts | Police Districts | Supervisor Districts | Zip Codes | Neighborhoods (old) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 148527 | 119142 | Permitted Site 7 | Tristania conferta :: 61 | 583 47th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/13/2018 12:00:00 AM | 3 | 3x3 | Permit Number 781376 | 5981295.16505 | 2111765.56723 | 37.7774200299425 | -122.508276611938 | (37.7774200299425, -122.508276611938) | 11 | 6 | 2 | 55 | 26 |
| 30192 | 184232 | DPW Maintained 1 | Tristania conferta :: 61 | 1500 Kirkham St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 0ft | 5983211.3452 | 2104903.2019 | 37.7586906757833 | -122.501140335143 | (37.7586906757833, -122.501140335143) | 1 | 8 | 3 | 56 | 35 | |||
| 4086 | 69819 | DPW Maintained 1 | Tristania conferta :: 61 | 3521 Kirkham St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 5 | 5983899.4988 | 2104926.7311 | 37.7587956653789 | -122.498762161048 | (37.7587956653789, -122.498762161048) | 1 | 8 | 3 | 56 | 35 | |||
| 114010 | 184222 | DPW Maintained 1 | Tristania conferta :: 61 | 3521 Kirkham St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 0ft | 5983907.1382 | 2104926.4256 | 37.7587952746185 | -122.49873571832 | (37.7587952746185, -122.49873571832) | 1 | 8 | 3 | 56 | 35 | |||
| 151990 | 54141 | DPW Maintained 1 | Tristania conferta :: 61 | 1432 38th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/15/2008 12:00:00 AM | 5 | 3x3 | Permit Number 51418 | 5984351.9621 | 2105403.8517 | 37.7601322321577 | -122.497232578221 | (37.7601322321577, -122.497232578221) | 1 | 8 | 3 | 56 | 35 | |
| 63048 | 184807 | DPW Maintained 1 | Tristania conferta :: 61 | 1251 Sunset Blvd | 7 | Sidewalk: Property side : Yard | Tree | Private 2 | 12 | Width 0ft | 5984672.983 | 2106530.3427 | 37.7632440693949 | -122.49620545091 | (37.7632440693949, -122.49620545091) | 1 | 8 | 3 | 56 | 35 | |||
| 169848 | 184808 | DPW Maintained 1 | Tristania conferta :: 61 | 1251 Sunset Blvd | 8 | Sidewalk: Property side : Yard | Tree | Private 2 | 20 | Width 0ft | 5984676.7802 | 2106518.9511 | 37.7632130136864 | -122.49619147733 | (37.7632130136864, -122.49619147733) | 1 | 8 | 3 | 56 | 35 | |||
| 127215 | 184353 | DPW Maintained 1 | Tristania conferta :: 61 | 1251 Sunset Blvd | 9 | Sidewalk: Property side : Yard | Tree | Private 2 | 10 | Width 0ft | 5984679.818 | 2106506.8001 | 37.763179828395 | -122.496180074201 | (37.763179828395, -122.496180074201) | 1 | 8 | 3 | 56 | 35 | |||
| 170373 | 187235 | DPW Maintained 1 | Tristania conferta :: 61 | 2401 Sunset Blvd | 18 | Sidewalk: Property side : Yard | Tree | Private 2 | 11 | Width 0ft | 5984966.2222 | 2098610.2885 | 37.7415149514197 | -122.494607336605 | (37.7415149514197, -122.494607336605) | 1 | 8 | 3 | 29491 | 35 | |||
| 178953 | 187236 | DPW Maintained 1 | Tristania conferta :: 61 | 2401 Sunset Blvd | 19 | Sidewalk: Property side : Yard | Tree | Private 2 | 12 | Width 0ft | 5984970.7155 | 2098606.6122 | 37.7415051202811 | -122.494591529584 | (37.7415051202811, -122.494591529584) | 1 | 8 | 3 | 29491 | 35 | |||
| 88062 | 253300 | DPW Maintained 1 | Tristania conferta :: 61 | 844 33rd Ave | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | 3x3 | 5985769 | 2110141 | 37.773222058846 | -122.492680686455 | (37.773222058846, -122.492680686455) | 11 | 6 | 2 | 55 | 26 | ||||
| 101869 | 107147 | DPW Maintained 1 | Tristania conferta :: 61 | 2466 34th Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | 5985833.5095 | 2098430.6846 | 37.7410725309134 | -122.491595378553 | (37.7410725309134, -122.491595378553) | 1 | 8 | 3 | 29491 | 35 | ||||
| 62984 | 107146 | DPW Maintained 1 | Tristania conferta :: 61 | 2466 34th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | 5985834.1864 | 2098423.2393 | 37.7410521276716 | -122.491592490194 | (37.7410521276716, -122.491592490194) | 1 | 8 | 3 | 29491 | 35 | ||||
| 70707 | 107145 | DPW Maintained 1 | Tristania conferta :: 61 | 2466 34th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | 5985834.5248 | 2098407.3335 | 37.7410084743792 | -122.491590149603 | (37.7410084743792, -122.491590149603) | 1 | 8 | 3 | 29491 | 35 | ||||
| 76664 | 109151 | Permitted Site 7 | Tristania conferta :: 61 | 727 29th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/29/2015 12:00:00 AM | 3 | 3x3 | Permit Number 769036 | 5986896.6 | 2110966.4 | 37.7755542438819 | -122.48884090533 | (37.7755542438819, -122.48884090533) | 11 | 6 | 2 | 55 | 26 |
| 187147 | 38128 | DPW Maintained 1 | Tristania conferta :: 61 | 2817 Lincoln Way | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/13/1998 12:00:00 AM | 6 | Permit Number 40292 | 5986952.8937 | 2107070.8859 | 37.7648615361674 | -122.488359826673 | (37.7648615361674, -122.488359826673) | 1 | 8 | 3 | 56 | 35 | |
| 74206 | 82190 | DPW Maintained 1 | Tristania conferta :: 61 | 1954 23rd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/29/2007 12:00:00 AM | 4 | 3x3 | Permit Number 49859 | 5989124.369 | 2102026.7679 | 37.751138201669 | -122.480480079647 | (37.751138201669, -122.480480079647) | 1 | 8 | 3 | 29491 | 35 | |
| 125029 | 9064 | DPW Maintained 1 | Tristania conferta :: 61 | 5530 Geary Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/25/2001 12:00:00 AM | 3 | 3X3 | 5989802.812 | 2112705.6659 | 37.7804989633648 | -122.478914967756 | (37.7804989633648, -122.478914967756) | 11 | 6 | 2 | 55 | 26 | ||
| 65634 | 81428 | DPW Maintained 1 | Tristania conferta :: 61 | 2015 20th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/29/2007 12:00:00 AM | 5 | 3x3 | Permit Number 49852 | 5990022.9826 | 2101627.3481 | 37.7500936819126 | -122.477343424721 | (37.7500936819126, -122.477343424721) | 1 | 8 | 3 | 29491 | 35 | |
| 31384 | 61393 | DPW Maintained 1 | Tristania conferta :: 61 | 926 Taraval St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/11/2008 12:00:00 AM | 3 | 3x3 | Permit Number 50349 | 5990253.2983 | 2099081.9773 | 37.7431181185655 | -122.476361078322 | (37.7431181185655, -122.476361078322) | 1 | 8 | 3 | 29491 | 35 | |
| 95289 | 115299 | Permitted Site 7 | Tristania conferta :: 61 | 177 Lomita Ave | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | 01/22/2016 12:00:00 AM | Permit Number 775793 | 5991298.7 | 2104254.5 | 37.757381090716 | -122.473123533862 | (37.757381090716, -122.473123533862) | 1 | 8 | 4 | 56 | 12 | |||
| 97027 | 115300 | Permitted Site 7 | Tristania conferta :: 61 | 177 Lomita Ave | 2 | Sidewalk: Property side : Cutout | Tree | Private 2 | 01/22/2016 12:00:00 AM | Permit Number 775793 | 5991298.7 | 2104254.5 | 37.757381090716 | -122.473123533862 | (37.757381090716, -122.473123533862) | 1 | 8 | 4 | 56 | 12 | |||
| 87850 | 54270 | Permitted Site 7 | Tristania conferta :: 61 | 1240 09th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/07/2015 12:00:00 AM | 3 | Permit Number 10023 | 5993331.28695265 | 2107027.13972063 | 37.7651115096687 | -122.466295599736 | (37.7651115096687, -122.466295599736) | 11 | 8 | 11 | 56 | 12 | ||
| 36704 | 111994 | Permitted Site 7 | Tristania conferta :: 61 | 1244 09th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/22/2015 12:00:00 AM | 3 | 3x3 | 5993400.7 | 2107017.1 | 37.7650879480266 | -122.466054789326 | (37.7650879480266, -122.466054789326) | 11 | 8 | 11 | 56 | 12 | ||
| 58736 | 115369 | DPW Maintained 1 | Tristania conferta :: 61 | 720 08th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/28/2016 12:00:00 AM | 3 | Permit Number 777460 | 5993541.3 | 2110551.9 | 37.7748016816289 | -122.465825344597 | (37.7748016816289, -122.465825344597) | 11 | 6 | 2 | 54 | 11 | ||
| 124692 | 25223 | DPW Maintained 1 | Tristania conferta :: 61 | 1951 Ocean Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3x3 | 5993847.033 | 2092637.9106 | 37.7256320661895 | -122.46346745052 | (37.7256320661895, -122.46346745052) | 9 | 8 | 4 | 59 | 40 | |||
| 22456 | 25279 | DPW Maintained 1 | Tristania conferta :: 61 | 1940 Ocean Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 5993856.5207 | 2092712.5569 | 37.7258375734043 | -122.463440067194 | (37.7258375734043, -122.463440067194) | 9 | 8 | 4 | 59 | 40 | |||
| 167484 | 25224 | DPW Maintained 1 | Tristania conferta :: 61 | 1951 Ocean Ave | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3x3 | 5993865.4444 | 2092626.4035 | 37.7256015312656 | -122.463402969615 | (37.7256015312656, -122.463402969615) | 9 | 8 | 4 | 59 | 40 | |||
| 160890 | 25225 | DPW Maintained 1 | Tristania conferta :: 61 | 1949 Ocean Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3X3 | 5993885.2366 | 2092618.1184 | 37.7255799226856 | -122.463333949193 | (37.7255799226856, -122.463333949193) | 9 | 8 | 4 | 59 | 40 | |||
| 37913 | 25228 | DPW Maintained 1 | Tristania conferta :: 61 | 1923 Ocean Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | 3X3 | 5994038.0508 | 2092538.029 | 37.7253688193969 | -122.462799879695 | (37.7253688193969, -122.462799879695) | 9 | 8 | 4 | 59 | 40 | |||
| 17387 | 216652 | DPW Maintained 1 | Tristania conferta :: 61 | 329 Faxon Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 09/23/2020 12:00:00 AM | 3 | Width 4ft | 5994725.9247 | 2090785.70947 | 37.7205969659665 | -122.460295076156 | (37.7205969659665, -122.460295076156) | 9 | 8 | 6 | 28861 | 24 | ||
| 112960 | 29568 | DPW Maintained 1 | Tristania conferta :: 61 | 1515 Ocean Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3x3 | 5995262.4177 | 2092118.4741 | 37.7242872653999 | -122.458537028286 | (37.7242872653999, -122.458537028286) | 9 | 8 | 4 | 28861 | 24 | |||
| 58879 | 49069 | Permitted Site 7 | Tristania conferta :: 61 | 1298 Ocean Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/29/2015 12:00:00 AM | 3x3 | Permit Number 776020 | 5995836.31315767 | 2092013.47244835 | 37.7240319217297 | -122.45654557668 | (37.7240319217297, -122.45654557668) | 9 | 8 | 4 | 28861 | 40 | ||
| 191788 | 141089 | DPW Maintained 1 | Tristania conferta :: 61 | 100x JORDAN AVE | 1 | Median : Cutout | Tree | DPW 1 | 3 | Width 0ft | 5996248.2713 | 2112978.5918 | 37.7816205163369 | -122.456636959709 | (37.7816205163369, -122.456636959709) | 11 | 6 | 1 | 54 | 31 | |||
| 94108 | 141094 | DPW Maintained 1 | Tristania conferta :: 61 | 188 Jordan Ave | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 0ft | 5996267.5613 | 2113016.8335 | 37.7817266254142 | -122.456572992218 | (37.7817266254142, -122.456572992218) | 11 | 6 | 1 | 54 | 31 | |||
| 164145 | 141092 | DPW Maintained 1 | Tristania conferta :: 61 | 192 Jordan Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 0ft | 5996267.8998 | 2112993.8208 | 37.7816634580812 | -122.456570156481 | (37.7816634580812, -122.456570156481) | 11 | 6 | 1 | 54 | 31 | |||
| 72289 | 141093 | DPW Maintained 1 | Tristania conferta :: 61 | 190 Jordan Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 0ft | 5996268.2382 | 2113005.3272 | 37.7816950710308 | -122.456569818134 | (37.7816950710308, -122.456569818134) | 11 | 6 | 1 | 54 | 31 | |||
| 162409 | 141091 | DPW Maintained 1 | Tristania conferta :: 61 | 194 Jordan Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 0ft | 5996268.2382 | 2112980.2839 | 37.7816263087743 | -122.456568006554 | (37.7816263087743, -122.456568006554) | 11 | 6 | 1 | 54 | 31 | |||
| 51619 | 141090 | DPW Maintained 1 | Tristania conferta :: 61 | 196 Jordan Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 0ft | 5996268.5766 | 2112969.4544 | 37.7815965932692 | -122.456566052477 | (37.7815965932692, -122.456566052477) | 11 | 6 | 1 | 54 | 31 | |||
| 97869 | 141234 | DPW Maintained 1 | Tristania conferta :: 61 | 22 COMMONWEALTH AVE | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 6 | Width 0ft | 5996538.8064 | 2114429.9137 | 37.7856221373365 | -122.455736793232 | (37.7856221373365, -122.455736793232) | 11 | 6 | 1 | 54 | 31 | |||
| 172205 | 140639 | DPW Maintained 1 | Tristania conferta :: 61 | 468 Stanyan St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 0ft | 5996860.5832 | 2109999.5178 | 37.7734758965802 | -122.454303413235 | (37.7734758965802, -122.454303413235) | 15 | 5 | 2 | 29492 | 16 | |||
| 42123 | 140638 | DPW Maintained 1 | Tristania conferta :: 61 | 472 Stanyan St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 0ft | 5996864.7991 | 2109972.3061 | 37.7734014220919 | -122.454286863982 | (37.7734014220919, -122.454286863982) | 15 | 5 | 2 | 29492 | 16 | |||
| 139360 | 140231 | DPW Maintained 1 | Tristania conferta :: 61 | 2227 Fulton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 0ft | 5997121.9683 | 2110490.0939 | 37.7748378772141 | -122.453434675612 | (37.7748378772141, -122.453434675612) | 15 | 5 | 2 | 29492 | 16 | |||
| 168845 | 17141 | DPW Maintained 1 | Tristania conferta :: 61 | 2065 Oak St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 3X3 | 5997139.5202 | 2109105.5449 | 37.7710372704709 | -122.453273982724 | (37.7710372704709, -122.453273982724) | 15 | 5 | 11 | 29492 | 9 | |||
| 128173 | 17139 | DPW Maintained 1 | Tristania conferta :: 61 | 2055 Oak St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3x3 | 5997166.0096 | 2109107.6811 | 37.7710446541678 | -122.45318250978 | (37.7710446541678, -122.45318250978) | 15 | 5 | 11 | 29492 | 9 | |||
| 89940 | 246101 | DPW Maintained 1 | Tristania conferta :: 61 | 1764 Waller St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 0ft | 5997168.442 | 2108117.5543 | 37.7683261602514 | -122.45310260948 | (37.7683261602514, -122.45310260948) | 15 | 5 | 11 | 29492 | 9 | |||
| 80829 | 246102 | DPW Maintained 1 | Tristania conferta :: 61 | 1764 Waller St | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 1 | Width 0ft | 5997188.4287 | 2108119.9769 | 37.7683339575358 | -122.453033652641 | (37.7683339575358, -122.453033652641) | 15 | 5 | 11 | 29492 | 9 | |||
| 124738 | 7106 | DPW Maintained 1 | Tristania conferta :: 61 | 2136 Fell St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 24 | 3X3 | 5997200.5381 | 2109511.6187 | 37.7721557413798 | -122.453092239143 | (37.7721557413798, -122.453092239143) | 15 | 5 | 11 | 29492 | 16 | |||
| 11870 | 245936 | DPW Maintained 1 | Tristania conferta :: 61 | 188 Beulah St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 0ft | 5997210.9895 | 2107777.1744 | 37.76739400269 | -122.452930870305 | (37.76739400269, -122.452930870305) | 15 | 5 | 11 | 29492 | 9 | |||
| 25766 | 245935 | DPW Maintained 1 | Tristania conferta :: 61 | 188 Beulah St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 0ft | 5997227.0394 | 2107780.5055 | 37.7674040687868 | -122.452875596673 | (37.7674040687868, -122.452875596673) | 15 | 5 | 11 | 29492 | 9 | |||
| 149408 | 246103 | DPW Maintained 1 | Tristania conferta :: 61 | 1764 Waller St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 0ft | 5997227.3423 | 2108124.368 | 37.7683482444092 | -122.452899371868 | (37.7683482444092, -122.452899371868) | 15 | 5 | 11 | 29492 | 9 | |||
| 96017 | 140234 | DPW Maintained 1 | Tristania conferta :: 61 | 1 SHRADER ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 0ft | 5997242.3128 | 2110421.4899 | 37.7746564060011 | -122.453013427896 | (37.7746564060011, -122.453013427896) | 15 | 5 | 2 | 29492 | 16 | |||
| 58128 | 114168 | DPW Maintained 1 | Tristania conferta :: 61 | 1x Shrader St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | 3x3 | 5997246.1454 | 2110389.6791 | 37.7745692814468 | -122.452997873526 | (37.7745692814468, -122.452997873526) | 15 | 5 | 2 | 29492 | 16 | |||
| 93246 | 246104 | DPW Maintained 1 | Tristania conferta :: 61 | 1764 Waller St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 0ft | 5997246.4205 | 2108126.7906 | 37.7683559895145 | -122.452833557387 | (37.7683559895145, -122.452833557387) | 15 | 5 | 11 | 29492 | 9 | |||
| 98075 | 246105 | DPW Maintained 1 | Tristania conferta :: 61 | 1764 Waller St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 20 | Width 0ft | 5997266.71 | 2108130.1217 | 37.7683662985003 | -122.45276361872 | (37.7683662985003, -122.45276361872) | 15 | 5 | 11 | 29492 | 9 | |||
| 38347 | 247255 | DPW Maintained 1 | Tristania conferta :: 61 | 2027 Oak St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 0ft | 5997293.757 | 2109123.4893 | 37.7710953802668 | -122.452741770892 | (37.7710953802668, -122.452741770892) | 15 | 5 | 11 | 29492 | 9 | |||
| 7868 | 140649 | DPW Maintained 1 | Tristania conferta :: 61 | 109 Shrader St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 0ft | 5997299.8022 | 2110011.7822 | 37.7735347493893 | -122.452784984309 | (37.7735347493893, -122.452784984309) | 15 | 5 | 2 | 29492 | 16 | |||
| 75392 | 10519 | DPW Maintained 1 | Tristania conferta :: 61 | 1840 Haight St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/27/1990 12:00:00 AM | 50 | 5997331.1413 | 2108490.0928 | 37.7693583785533 | -122.452566739633 | (37.7693583785533, -122.452566739633) | 15 | 5 | 11 | 29492 | 9 | |||
| 79018 | 140188 | DPW Maintained 1 | Tristania conferta :: 61 | 294 Shrader St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 0ft | 5997403.6344 | 2109575.9167 | 37.772343924669 | -122.452394356341 | (37.772343924669, -122.452394356341) | 15 | 5 | 11 | 29492 | 16 | |||
| 161502 | 245967 | DPW Maintained 1 | Tristania conferta :: 61 | 142 Beulah St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 17 | Width 0ft | 5997407.2227 | 2107805.0347 | 37.7674817434178 | -122.452254140763 | (37.7674817434178, -122.452254140763) | 15 | 5 | 11 | 29492 | 9 | |||
| 50869 | 246072 | DPW Maintained 1 | Tristania conferta :: 61 | 1827 Haight St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 0ft | 5997411.4623 | 2108451.7262 | 37.7692576354413 | -122.452286145637 | (37.7692576354413, -122.452286145637) | 15 | 5 | 11 | 29492 | 9 | |||
| 93465 | 140186 | DPW Maintained 1 | Tristania conferta :: 61 | 2098 FELL ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 0ft | 5997442.3009 | 2109546.1708 | 37.7722644652587 | -122.452258459283 | (37.7722644652587, -122.452258459283) | 15 | 5 | 11 | 29492 | 16 | |||
| 29646 | 10511 | DPW Maintained 1 | Tristania conferta :: 61 | 1800 Haight St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/10/2007 12:00:00 AM | 6 | 3X3 | 5997484.5237 | 2108509.319 | 37.7694199557275 | -122.452037587086 | (37.7694199557275, -122.452037587086) | 15 | 5 | 11 | 29492 | 9 | ||
| 47191 | 7102 | DPW Maintained 1 | Tristania conferta :: 61 | 2080 Fell St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 30 | 4X4 | 5997497.5881 | 2109552.6978 | 37.7722855537803 | -122.45206768793 | (37.7722855537803, -122.45206768793) | 15 | 5 | 11 | 29492 | 16 | |||
| 32653 | 141068 | DPW Maintained 1 | Tristania conferta :: 61 | 516 Anza St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 0ft | 5997528.6902 | 2112557.7643 | 37.7805384665203 | -122.45217696844 | (37.7805384665203, -122.45217696844) | 15 | 6 | 2 | 54 | 16 | |||
| 170134 | 7101 | DPW Maintained 1 | Tristania conferta :: 61 | 2070 Fell St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/21/1994 12:00:00 AM | 6 | 4X4 | 5997541.7411 | 2109558.8408 | 37.7723049499053 | -122.451915402773 | (37.7723049499053, -122.451915402773) | 15 | 5 | 11 | 29492 | 16 | ||
| 108984 | 141067 | DPW Maintained 1 | Tristania conferta :: 61 | 516 Anza St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 0ft | 5997555.0871 | 2112560.1333 | 37.7805464832628 | -122.452085820488 | (37.7805464832628, -122.452085820488) | 15 | 6 | 2 | 54 | 16 | |||
| 37712 | 141066 | DPW Maintained 1 | Tristania conferta :: 61 | 516 Anza St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 0ft | 5997568.2855 | 2112562.8407 | 37.7805546730892 | -122.452040356585 | (37.7805546730892, -122.452040356585) | 15 | 6 | 2 | 54 | 16 | |||
| 134322 | 246161 | DPW Maintained 1 | Tristania conferta :: 61 | 654 Shrader St | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 6 | Width 0ft | 5997590.7371 | 2108239.7458 | 37.7686858601373 | -122.451650753273 | (37.7686858601373, -122.451650753273) | 15 | 5 | 11 | 29492 | 9 | |||
| 123755 | 246159 | DPW Maintained 1 | Tristania conferta :: 61 | 664 Shrader St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 12 | Width 0ft | 5997597.3994 | 2108195.8356 | 37.7685656755079 | -122.451624541219 | (37.7685656755079, -122.451624541219) | 15 | 5 | 11 | 29492 | 9 | |||
| 122744 | 10510 | DPW Maintained 1 | Tristania conferta :: 61 | 1793 Haight St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 06/09/1992 12:00:00 AM | 1 | 5997601.0333 | 2108476.5582 | 37.7693366759731 | -122.451632224006 | (37.7693366759731, -122.451632224006) | 15 | 5 | 11 | 29492 | 9 | |||
| 28616 | 248567 | DPW Maintained 1 | Tristania conferta :: 61 | 809 Shrader St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 0ft | 5997620.5658 | 2107720.8482 | 37.7672628081675 | -122.451510146252 | (37.7672628081675, -122.451510146252) | 15 | 5 | 11 | 29492 | 9 | |||
| 58973 | 245957 | DPW Maintained 1 | Tristania conferta :: 61 | 850 Shrader St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 0ft | 5997681.1316 | 2107596.9911 | 37.7669261962578 | -122.451291725243 | (37.7669261962578, -122.451291725243) | 15 | 5 | 11 | 29492 | 9 | |||
| 136899 | 248527 | DPW Maintained 1 | Tristania conferta :: 61 | 65 Beulah St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 0ft | 5997684.7656 | 2107798.3724 | 37.7674793460156 | -122.451293681226 | (37.7674793460156, -122.451293681226) | 15 | 5 | 11 | 29492 | 9 | |||
| 115325 | 248528 | DPW Maintained 1 | Tristania conferta :: 61 | 55 Beulah St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 0ft | 5997696.5759 | 2107800.7951 | 37.7674866743633 | -122.451253005926 | (37.7674866743633, -122.451253005926) | 15 | 5 | 11 | 29492 | 9 | |||
| 174799 | 247346 | DPW Maintained 1 | Tristania conferta :: 61 | 1766 Haight St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 0ft | 5997706.6931 | 2108542.6444 | 37.7695241821424 | -122.451271520386 | (37.7695241821424, -122.451271520386) | 15 | 5 | 11 | 29492 | 9 | |||
| 19889 | 248530 | DPW Maintained 1 | Tristania conferta :: 61 | 35 Beulah St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 0ft | 5997722.0136 | 2107803.8234 | 37.7674964457612 | -122.451165239168 | (37.7674964457612, -122.451165239168) | 15 | 5 | 11 | 29492 | 9 | |||
| 161227 | 248609 | DPW Maintained 1 | Tristania conferta :: 61 | 432 Frederick St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 0ft | 5997733.2182 | 2107503.1141 | 37.7666714161881 | -122.451104796338 | (37.7666714161881, -122.451104796338) | 15 | 5 | 11 | 29492 | 9 | |||
| 186188 | 141269 | DPW Maintained 1 | Tristania conferta :: 61 | 399 Anza St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 0ft | 5997767.7852 | 2112527.4756 | 37.7804689951324 | -122.451347644428 | (37.7804689951324, -122.451347644428) | 15 | 6 | 2 | 54 | 16 | |||
| 30694 | 248608 | DPW Maintained 1 | Tristania conferta :: 61 | 432 Frederick St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | Width 0ft | 5997774.403 | 2107510.382 | 37.7666937298525 | -122.450962870008 | (37.7666937298525, -122.450962870008) | 15 | 5 | 11 | 29492 | 9 | |||
| 170503 | 248514 | DPW Maintained 1 | Tristania conferta :: 61 | 25 Beulah St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 17 | Width 0ft | 5997781.3681 | 2107812.9082 | 37.767524788446 | -122.450960596024 | (37.767524788446, -122.450960596024) | 15 | 5 | 11 | 29492 | 9 | |||
| 31977 | 141270 | DPW Maintained 1 | Tristania conferta :: 61 | 387 Anza St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 0ft | 5997821.2558 | 2112535.5977 | 37.7804943578687 | -122.451163251255 | (37.7804943578687, -122.451163251255) | 15 | 6 | 2 | 54 | 16 | |||
| 103346 | 248512 | Permitted Site 7 | Tristania conferta :: 61 | 19 Beulah St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/10/1979 12:00:00 AM | 17 | Width 0ft | Permit Number 17888 | 5997839.8141 | 2107820.479 | 37.7675489217125 | -122.450758985918 | (37.7675489217125, -122.450758985918) | 15 | 5 | 11 | 29492 | 9 | |
| 24535 | 141271 | DPW Maintained 1 | Tristania conferta :: 61 | 381 Anza St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 0ft | 5997841.2227 | 2112537.9666 | 37.7805020054221 | -122.45109434754 | (37.7805020054221, -122.45109434754) | 15 | 6 | 2 | 54 | 16 | |||
| 150218 | 101329 | DPW Maintained 1 | Tristania conferta :: 61 | 2703 Turk Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | 3x3 | 5997904.4066 | 2111642.2894 | 37.7780463265361 | -122.450811165883 | (37.7780463265361, -122.450811165883) | 15 | 6 | 2 | 54 | 16 | |||
| 27653 | 141272 | DPW Maintained 1 | Tristania conferta :: 61 | 365 Anza St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 0ft | 5997908.5687 | 2112548.4577 | 37.7805346667324 | -122.450862123717 | (37.7805346667324, -122.450862123717) | 15 | 6 | 2 | 54 | 16 | |||
| 152365 | 10492 | DPW Maintained 1 | Tristania conferta :: 61 | 1699 Haight St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 06/09/1992 12:00:00 AM | 10 | 3X3 | 5997918.2468 | 2108523.3453 | 37.7694833025616 | -122.450538376308 | (37.7694833025616, -122.450538376308) | 15 | 5 | 11 | 29492 | 9 | ||
| 66862 | 141457 | DPW Maintained 1 | Tristania conferta :: 61 | 1 Kittredge Ter | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 17 | Width 0ft | 5997940.1194 | 2111622.4489 | 37.7779938939643 | -122.450686192278 | (37.7779938939643, -122.450686192278) | 15 | 6 | 2 | 54 | 16 | |||
| 116281 | 141273 | DPW Maintained 1 | Tristania conferta :: 61 | 363 Anza St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 0ft | 5997942.7493 | 2112553.5341 | 37.7805505618304 | -122.450744243509 | (37.7805505618304, -122.450744243509) | 15 | 6 | 2 | 54 | 16 | |||
| 105742 | 141458 | DPW Maintained 1 | Tristania conferta :: 61 | 9 Kittredge Ter | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 0ft | 5997945.4102 | 2111586.3754 | 37.7778951483556 | -122.450665288127 | (37.7778951483556, -122.450665288127) | 15 | 6 | 2 | 54 | 16 | |||
| 146459 | 141459 | DPW Maintained 1 | Tristania conferta :: 61 | 15 Kittredge Ter | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 17 | Width 0ft | 5997948.2961 | 2111555.5927 | 37.7778107922486 | -122.450653084923 | (37.7778107922486, -122.450653084923) | 15 | 6 | 2 | 54 | 16 | |||
| 6338 | 141477 | DPW Maintained 1 | Tristania conferta :: 61 | 25 KITTREDGE TER | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 0ft | 5997952.6249 | 2111528.1769 | 37.777735763362 | -122.450636133087 | (37.777735763362, -122.450636133087) | 15 | 6 | 2 | 54 | 16 | |||
| 23965 | 141511 | DPW Maintained 1 | Tristania conferta :: 61 | 29 KITTREDGE TER | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 0ft | 5997955.5108 | 2111504.1279 | 37.7776698962407 | -122.450624415537 | (37.7776698962407, -122.450624415537) | 15 | 6 | 2 | 54 | 16 | |||
| 44329 | 54243 | DPW Maintained 1 | Tristania conferta :: 61 | 35 Kittredge Ter | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/16/1972 12:00:00 AM | 26 | Permit Number 9984 | 5997958.8776 | 2111479.5979 | 37.7776027359423 | -122.450610999735 | (37.7776027359423, -122.450610999735) | 15 | 6 | 2 | 54 | 16 | ||
| 151122 | 141537 | DPW Maintained 1 | Tristania conferta :: 61 | 41 KITTREDGE TER | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 21 | Width 0ft | 5997962.2445 | 2111456.5108 | 37.777539537476 | -122.450597687662 | (37.777539537476, -122.450597687662) | 15 | 6 | 2 | 54 | 16 | |||
| 111771 | 141548 | DPW Maintained 1 | Tristania conferta :: 61 | 53 KITTREDGE TER | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 23 | Width 0ft | 5997966.0923 | 2111424.7661 | 37.7774525950111 | -122.450582087707 | (37.7774525950111, -122.450582087707) | 15 | 6 | 2 | 54 | 16 | |||
| 59398 | 244220 | DPW Maintained 1 | Tristania conferta :: 61 | 575 Cole St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 0ft | 5997973.512 | 2108683.547 | 37.7699263384799 | -122.450358767117 | (37.7699263384799, -122.450358767117) | 15 | 5 | 11 | 29492 | 9 | |||
| 59410 | 244221 | DPW Maintained 1 | Tristania conferta :: 61 | 575 Cole St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 0ft | 5997975.5756 | 2108661.6728 | 37.7698663956238 | -122.450350052144 | (37.7698663956238, -122.450350052144) | 15 | 5 | 11 | 29492 | 9 | |||
| 101798 | 141274 | DPW Maintained 1 | Tristania conferta :: 61 | 361 Anza St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 0ft | 5997984.0367 | 2112557.9335 | 37.7805650047265 | -122.450601728745 | (37.7805650047265, -122.450601728745) | 15 | 6 | 2 | 54 | 16 | |||
| 163833 | 141470 | DPW Maintained 1 | Tristania conferta :: 61 | 22 KITTREDGE TER | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 0ft | 5997989.6604 | 2111550.7829 | 37.7777999533719 | -122.450509645298 | (37.7777999533719, -122.450509645298) | 15 | 6 | 2 | 54 | 16 |
Advanced export
JSON shape: default, array, newline-delimited, object
CREATE TABLE "trees" ( [rowid] INTEGER PRIMARY KEY, [TreeID] TEXT, [qLegalStatus_id] INTEGER REFERENCES [qLegalStatus]([id]), [qSpecies_id] INTEGER, [qAddress] TEXT, [SiteOrder] TEXT, [qSiteInfo] TEXT, [PlantType] TEXT, [qCaretaker_id] INTEGER REFERENCES [qCaretaker]([id]), [qCareAssistant] TEXT, [PlantDate] TEXT, [DBH] TEXT, [PlotSize] TEXT, [PermitNotes] TEXT, [XCoord] TEXT, [YCoord] TEXT, [Latitude] TEXT, [Longitude] TEXT, [Location] TEXT, [Fire Prevention Districts] TEXT, [Police Districts] TEXT, [Supervisor Districts] TEXT, [Zip Codes] TEXT, [Neighborhoods (old)] TEXT, FOREIGN KEY(qSpecies_id) REFERENCES qSpecies(id) );