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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
53360 | 53360 | 225386 | Undocumented 2 | Fraxinus spp :: Ash Spp 83 | 300 Chattanooga St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 4ft | 6004769.89273 | 2101857.00053 | 37.751568879815395 | -122.42636408974501 | (37.7515688798154, -122.426364089745) | |||
53654 | 53654 | 225790 | Undocumented 2 | Fraxinus spp :: Ash Spp 83 | 920 Ashbury St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 5999222.99784 | 2106999.85397 | 37.765374771852706 | -122.445915724224 | (37.7653747718527, -122.445915724224) | |||
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) | |||
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) | |||
54476 | 54476 | 218970 | Undocumented 2 | Fraxinus spp :: Ash Spp 83 | 85 Teresita Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 2ft | 5997504.5128 | 2099195.16066 | 37.7438467530404 | -122.45129660546499 | (37.7438467530404, -122.451296605465) | |||
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) | |||
55154 | 55154 | 192348 | Undocumented 2 | Fraxinus spp :: Ash Spp 83 | 170 10th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6008297.90047 | 2110029.55008 | 37.774207611721 | -122.414742072711 | (37.774207611721, -122.414742072711) | |||
55477 | 55477 | 225792 | Undocumented 2 | Fraxinus spp :: Ash Spp 83 | 3291 Shotwell St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6007807.819130001 | 2105426.09185 | 37.761540045560295 | -122.416111269835 | (37.7615400455603, -122.416111269835) | |||
55974 | 55974 | 225806 | Undocumented 2 | Fraxinus spp :: Ash Spp 83 | 363 Diamond St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6001815.68909 | 2103737.4020700003 | 37.7565645760008 | -122.43671466866002 | (37.7565645760008, -122.43671466866) | |||
56385 | 56385 | 225807 | Undocumented 2 | Fraxinus spp :: Ash Spp 83 | 144 Noe St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 3ft | 6002846.79255 | 2107449.48757 | 37.7668156107901 | -122.43341400475799 | (37.7668156107901, -122.433414004758) | |||
56814 | 56814 | 192271 | Undocumented 2 | Fraxinus spp :: Ash Spp 83 | 450 11th St | 14 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6009005.79575 | 2108670.8406700003 | 37.7705166618411 | -122.41219727910601 | (37.7705166618411, -122.412197279106) | |||
56819 | 56819 | 68672 | Permitted Site 1 | Fraxinus spp :: Ash Spp 83 | 260 09th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/02/1993 12:00:00 AM | 10 | Permit Number 32580 | 5993093.46375 | 2113748.31872 | 37.7835523382358 | -122.467606994541 | (37.7835523382358, -122.467606994541) | |
57020 | 57020 | 218969 | Undocumented 2 | Fraxinus spp :: Ash Spp 83 | 150 Alton Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 6 | Width 4ft | 5993603.1998 | 2101661.03992 | 37.750393275225704 | -122.46496537605499 | (37.7503932752257, -122.464965376055) | |||
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) | |||
57413 | 57413 | 225818 | Undocumented 2 | Fraxinus spp :: Ash Spp 83 | 98 Hill St | 6 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 10 | Width 6ft | 6005774.11943 | 2103465.5032 | 37.7560421706386 | -122.423005656989 | (37.7560421706386, -122.423005656989) | |||
57897 | 57897 | 51033 | Permitted Site 1 | Fraxinus spp :: Ash Spp 83 | 76 Vienna St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/08/2004 12:00:00 AM | 4 | Permit Number 47508 | 6004871.9247 | 2093005.4504099998 | 37.7272702952631 | -122.42538140772 | (37.7272702952631, -122.42538140772) | ||
58336 | 58336 | 225382 | Undocumented 2 | Fraxinus spp :: Ash Spp 83 | 3614 18th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6005452.14403 | 2105496.18029 | 37.761599759639104 | -122.424263576509 | (37.7615997596391, -122.424263576509) | |||
58873 | 58873 | 192257 | Undocumented 2 | Fraxinus spp :: Ash Spp 83 | 450 11th St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6009251.0050099995 | 2108416.23569 | 37.7698313316731 | -122.41133110605301 | (37.7698313316731, -122.411331106053) | |||
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) | |||
59057 | 59057 | 225804 | Undocumented 2 | Fraxinus spp :: Ash Spp 83 | 4433 20th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 6001581.80688 | 2104063.4307 | 37.7574464772949 | -122.437546862602 | (37.7574464772949, -122.437546862602) | |||
59605 | 59605 | 30514 | Permitted Site 1 | Fraxinus spp :: Ash Spp 83 | 340 Eddy St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/23/2000 12:00:00 AM | 22 | Permit Number 42913 | 6008785.20324 | 2113547.07327 | 37.783893261596 | -122.41330519888201 | (37.783893261596, -122.413305198882) | |
59720 | 59720 | 56313 | Permitted Site 1 | Fraxinus spp :: Ash Spp 83 | 229 09th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/16/1973 12:00:00 AM | 12 | Permit Number 12447 | 5993040.18993 | 2113916.11955 | 37.7840099974474 | -122.467803508187 | (37.7840099974474, -122.467803508187) | ||
60652 | 60652 | 192335 | Undocumented 2 | Fraxinus spp :: Ash Spp 83 | 65 10th St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 4ft | 6007868.48614 | 2110574.3182900003 | 37.775679279409296 | -122.416266089906 | (37.7756792794093, -122.416266089906) | |||
60743 | 60743 | 192197 | Undocumented 2 | Fraxinus spp :: Ash Spp 83 | 315 10th St | 1 | : 4 | Tree 1 | Private 1 | 5 | Width 3ft | 6008969.56374 | 2109417.5428 | 37.77256489838 | -122.412375393416 | (37.77256489838, -122.412375393416) | |||
61003 | 61003 | 192207 | Undocumented 2 | Fraxinus spp :: Ash Spp 83 | 340 10th St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6009328.31589 | 2108955.05277 | 37.771315133921 | -122.411101753766 | (37.771315133921, -122.411101753766) | |||
62312 | 62312 | 128814 | Undocumented 2 | Fraxinus spp :: Ash Spp 83 | 843 Van Ness Ave | 5 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 16 | Width 4ft | 6006609.50703 | 2113290.0026 | 37.783065016591 | -122.420814060425 | (37.783065016591, -122.420814060425) | |||
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) | |||
62979 | 62979 | 128816 | Undocumented 2 | Fraxinus spp :: Ash Spp 83 | 215 Golden Gate Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 23 | Width 4ft | 6008534.849640001 | 2112776.4712099996 | 37.7817633144723 | -122.414116796578 | (37.7817633144723, -122.414116796578) | |||
63148 | 63148 | 128818 | Undocumented 2 | Fraxinus spp :: Ash Spp 83 | 99 Leavenworth St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 24 | Width 4ft | 6008590.072819999 | 2112753.6633099997 | 37.7817037910346 | -122.413924135711 | (37.7817037910346, -122.413924135711) | |||
63906 | 63906 | 192329 | Undocumented 2 | Fraxinus spp :: Ash Spp 83 | 135 10th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 4ft | 6008156.7444 | 2110270.8623200003 | 37.774862266002 | -122.41524744403601 | (37.774862266002, -122.415247444036) | |||
64081 | 64081 | 192259 | Undocumented 2 | Fraxinus spp :: Ash Spp 83 | 450 11th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6009225.68237 | 2108442.7428099997 | 37.7699026937941 | -122.411420569714 | (37.7699026937941, -122.411420569714) | |||
64284 | 64284 | 192258 | Undocumented 2 | Fraxinus spp :: Ash Spp 83 | 450 11th St | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6009238.32682 | 2108428.66995 | 37.7698647621884 | -122.411375838327 | (37.7698647621884, -122.411375838327) | |||
64545 | 64545 | 192256 | Undocumented 2 | Fraxinus spp :: Ash Spp 83 | 450 11th St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6009265.04555 | 2108401.4321 | 37.7697914719171 | -122.41128149407 | (37.7697914719171, -122.41128149407) | |||
64696 | 64696 | 192269 | Undocumented 2 | Fraxinus spp :: Ash Spp 83 | 450 11th St | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6009063.6928900005 | 2108616.03922 | 37.7703694383326 | -122.411993138384 | (37.7703694383326, -122.411993138384) | |||
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) | |||
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) | |||
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) | |||
66815 | 66815 | 192268 | Undocumented 2 | Fraxinus spp :: Ash Spp 83 | 450 11th St | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6009073.27718 | 2108601.79495 | 37.7703308646077 | -122.411958979438 | (37.7703308646077, -122.411958979438) | |||
67135 | 67135 | 138603 | Undocumented 2 | Fraxinus spp :: Ash Spp 83 | 2662 Pine St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 0ft | 6001201.7584 | 2114936.3549 | 37.787279191103295 | -122.439640685052 | (37.7872791911033, -122.439640685052) | |||
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) | |||
69464 | 69464 | 218977 | Undocumented 2 | Fraxinus spp :: Ash Spp 83 | 254 Edgewood Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 27 | Width 3ft | 5996588.22406 | 2105623.7456099996 | 37.761445530401 | -122.45492930356701 | (37.761445530401, -122.454929303567) | |||
69649 | 69649 | 192333 | Undocumented 2 | Fraxinus spp :: Ash Spp 83 | 65 10th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 4ft | 6007912.3493800005 | 2110528.44514 | 37.7755557890086 | -122.416111106161 | (37.7755557890086, -122.416111106161) | |||
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) | |||
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) | |||
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) | |||
70435 | 70435 | 187490 | Undocumented 2 | Fraxinus spp :: Ash Spp 83 | 750 Velasco Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 6 | 6006575.2964699995 | 2086657.1322 | 37.709935258482 | -122.419042759324 | (37.709935258482, -122.419042759324) | ||||
71057 | 71057 | 41070 | Permitted Site 1 | Fraxinus spp :: Ash Spp 83 | 255 10th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/27/1999 12:00:00 AM | 3 | Permit Number 41832 | 6008672.12135 | 2109729.96637 | 37.773406044194495 | -122.413426379828 | (37.7734060441945, -122.413426379828) | |
71246 | 71246 | 128812 | Undocumented 2 | Fraxinus spp :: Ash Spp 83 | 360 Hyde St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 4ft | 6008015.3478 | 2113733.84894 | 37.7843628498196 | -122.415981852889 | (37.7843628498196, -122.415981852889) | |||
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) | |||
72951 | 72951 | 128809 | Undocumented 2 | Fraxinus spp :: Ash Spp 83 | 2798 Vallejo St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 4ft | 6000135.50576 | 2117439.15627 | 37.7940904836317 | -122.443509534145 | (37.7940904836317, -122.443509534145) | |||
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) | |||
73724 | 73724 | 192350 | Undocumented 2 | Fraxinus spp :: Ash Spp 83 | 262 10th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6008739.72067 | 2109564.6786599997 | 37.772955998255206 | -122.413180853213 | (37.7729559982552, -122.413180853213) | |||
74860 | 74860 | 192327 | Undocumented 2 | Fraxinus spp :: Ash Spp 83 | 237 10th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6008504.84777 | 2109907.53416 | 37.7738842101272 | -122.41401756896299 | (37.7738842101272, -122.414017568963) | |||
75021 | 75021 | 225791 | Undocumented 2 | Fraxinus spp :: Ash Spp 83 | 920 Ashbury St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 5999226.76064 | 2106974.09226 | 37.765304251518 | -122.44590085663799 | (37.765304251518, -122.445900856638) | |||
75366 | 75366 | 192266 | Undocumented 2 | Fraxinus spp :: Ash Spp 83 | 450 11th St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6009132.08177 | 2108533.86309 | 37.7701476385359 | -122.411750772897 | (37.7701476385359, -122.411750772897) | |||
75995 | 75995 | 30523 | Permitted Site 1 | Fraxinus spp :: Ash Spp 83 | 215 Golden Gate Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/09/1995 12:00:00 AM | 23 | Permit Number 34528 | 6008465.79864 | 2112766.79262 | 37.7817328607212 | -122.414354996407 | (37.7817328607212, -122.414354996407) | |
76249 | 76249 | 225794 | Undocumented 2 | Fraxinus spp :: Ash Spp 83 | 3291 Shotwell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6007798.59434 | 2105543.95905 | 37.761863162968105 | -122.416151522586 | (37.7618631629681, -122.416151522586) | |||
76795 | 76795 | 225788 | Undocumented 2 | Fraxinus spp :: Ash Spp 83 | 4436 25th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 3ft | 6001105.5651 | 2101159.8137 | 37.7494467567732 | -122.43898580666 | (37.7494467567732, -122.43898580666) | |||
79400 | 79400 | 41689 | Permitted Site 1 | Fraxinus spp :: Ash Spp 83 | 117 Conrad St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/19/2000 12:00:00 AM | Permit Number 42143 | 6001812.465231299 | 2096668.95095007 | 37.737156097415706 | -122.436219989049 | (37.7371560974157, -122.436219989049) | |||
84512 | 84512 | 33479 | Permitted Site 1 | Fraxinus spp :: Ash Spp 83 | 190 Coleridge St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/20/1996 12:00:00 AM | Permit Number 37572 | 6006437.49245401 | 2098651.34949844 | 37.742861013201704 | -122.420369801641 | (37.7428610132017, -122.420369801641) | |||
84899 | 84899 | 92547 | Permitted Site 1 | Fraxinus spp :: Ash Spp 83 | 99 Santa Marina St | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 3x3 | Permit Number 52890 | 6006207.5 | 2097640.2 | 37.740071660795 | -122.42109327168501 | (37.740071660795, -122.421093271685) | |||
86442 | 86442 | 89466 | DPW Maintained 3 | Fraxinus spp :: Ash Spp 83 | 3700 Anza St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/21/2008 12:00:00 AM | 3 | 3x3 | 5987138.86697 | 2111884.81108 | 37.77809007701521 | -122.488070356177 | (37.7780900770152, -122.488070356177) | ||
87227 | 87227 | 64914 | Permitted Site 1 | Fraxinus spp :: Ash Spp 83 | 65 Valley St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/21/1989 12:00:00 AM | 4x4 | Permit Number 25941 | 6005478.362986099 | 2099307.48712071 | 37.7446085231046 | -122.42373284962 | (37.7446085231046, -122.42373284962) | |
90352 | 90352 | 107514 | Undocumented 2 | Fraxinus spp :: Ash Spp 83 | 76 Taraval St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | 3x10 | 5993384.0 | 2099214.0 | 37.7436616846124 | -122.4655456274 | (37.7436616846124, -122.4655456274) | |||
91370 | 91370 | 51032 | Permitted Site 1 | Fraxinus spp :: Ash Spp 83 | 78 Vienna St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/08/2004 12:00:00 AM | 3 | Permit Number 47507 | 6004848.23489 | 2092967.4640400002 | 37.7271646546122 | -122.425460601145 | (37.7271646546122, -122.425460601145) | ||
93732 | 93732 | 11634 | Permitted Site 1 | Fraxinus spp :: Ash Spp 83 | 499X Junipero Serra Blvd | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | PUC 13 | 12 | 3 | 5991474.53212 | 2093889.5616418 | 37.7289318087747 | -122.471760091134 | (37.7289318087747, -122.471760091134) | |||
94836 | 94836 | 33480 | Permitted Site 1 | Fraxinus spp :: Ash Spp 83 | 190 Coleridge St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/20/1996 12:00:00 AM | Permit Number 37572 | 6006437.49245401 | 2098651.34949844 | 37.742861013201704 | -122.420369801641 | (37.7428610132017, -122.420369801641) | |||
95274 | 95274 | 225793 | Undocumented 2 | Fraxinus spp :: Ash Spp 83 | 3291 Shotwell St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6007803.17898 | 2105505.53039 | 37.761757904533205 | -122.416132944404 | (37.7617579045332, -122.416132944404) | |||
97990 | 97990 | 11657 | Permitted Site 1 | Fraxinus spp :: Ash Spp 83 | 699X Junipero Serra Blvd | 18 | Sidewalk: Curb side : Cutout 1 | Tree 1 | PUC 13 | 12 | 3 | 5991405.981861901 | 2093130.1790735 | 37.7268427672434 | -122.47194174766199 | (37.7268427672434, -122.471941747662) | |||
101611 | 101611 | 96698 | Undocumented 2 | Fraxinus spp :: Ash Spp 83 | 1849 Page St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | 3x3 | 5997732.0 | 2108845.0 | 37.770355822096704 | -122.451205793491 | (37.7703558220967, -122.451205793491) | |||
101798 | 101798 | 113749 | Undocumented 2 | Fraxinus spp :: Ash Spp 83 | 459 ASHBURY ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6x6 | 5998867.0 | 2109101.0 | 37.7711236529318 | -122.447298272426 | (37.7711236529318, -122.447298272426) | ||||
105125 | 105125 | 59141 | Permitted Site 1 | Fraxinus spp :: Ash Spp 83 | 588 12th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/23/1980 12:00:00 AM | 15 | Permit Number 18448 | 5992243.78964 | 2111491.996 | 37.7773079985249 | -122.470382138383 | (37.7773079985249, -122.470382138383) | ||
107280 | 107280 | 56260 | Permitted Site 1 | Fraxinus spp :: Ash Spp 83 | 238 Grattan St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/31/1973 12:00:00 AM | Permit Number 12386 | 5997570.92464879 | 2106477.05534424 | 37.763844826719705 | -122.451592119849 | (37.7638448267197, -122.451592119849) | |||
108119 | 108119 | 98345 | Undocumented 2 | Fraxinus spp :: Ash Spp 83 | 784 Cole St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5998016.0 | 2107622.0 | 37.767014032658 | -122.45013527715 | (37.767014032658, -122.45013527715) | ||||
109753 | 109753 | 985 | DPW Maintained 3 | Fraxinus spp :: Ash Spp 83 | 1628 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 15 | 3X3 | 6001654.0889800005 | 2092682.1975 | 37.7262003881553 | -122.436482304747 | (37.7262003881553, -122.436482304747) | |||
112329 | 112329 | 33476 | Permitted Site 1 | Fraxinus spp :: Ash Spp 83 | 190 Coleridge St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/20/1996 12:00:00 AM | Permit Number 37572 | 6006437.49245401 | 2098651.34949844 | 37.742861013201704 | -122.420369801641 | (37.7428610132017, -122.420369801641) | |||
113355 | 113355 | 14546 | Permitted Site 1 | Fraxinus spp :: Ash Spp 83 | 815 Masonic Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3X3 | 5999184.70875 | 2110016.19662 | 37.773654699050496 | -122.44626515618 | (37.7736546990505, -122.44626515618) | |||
115102 | 115102 | 2681 | DPW Maintained 3 | Fraxinus spp :: Ash Spp 83 | 2085 Bush St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/17/2015 12:00:00 AM | 22 | 3X3 | 6003609.80751 | 2114718.21117 | 37.7868169864691 | -122.431293772174 | (37.7868169864691, -122.431293772174) | ||
115239 | 115239 | 14548 | Permitted Site 1 | Fraxinus spp :: Ash Spp 83 | 815 Masonic Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/17/2000 12:00:00 AM | 3 | 3X3 | 5999184.70875 | 2110016.19662 | 37.773654699050496 | -122.44626515618 | (37.7736546990505, -122.44626515618) | ||
116506 | 116506 | 116066 | DPW Maintained 3 | Fraxinus spp :: Ash Spp 83 | 40 MALTA DR | Median : Cutout 11 | Tree 1 | DPW 2 | 10 | 5999623.0 | 2096071.0 | 37.7353896244756 | -122.44374699604401 | (37.7353896244756, -122.443746996044) | |||||
118104 | 118104 | 128815 | Undocumented 2 | Fraxinus spp :: Ash Spp 83 | 215 Golden Gate Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 25 | Width 4ft | 6008510.99254 | 2112773.43009 | 37.781753624263295 | -122.41419911600201 | (37.7817536242633, -122.414199116002) | |||
118261 | 118261 | 33474 | Permitted Site 1 | Fraxinus spp :: Ash Spp 83 | 190 Coleridge St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/20/1996 12:00:00 AM | Permit Number 37572 | 6006437.49245401 | 2098651.34949844 | 37.742861013201704 | -122.420369801641 | (37.7428610132017, -122.420369801641) | |||
121652 | 121652 | 115825 | Undocumented 2 | Fraxinus spp :: Ash Spp 83 | 403 CLAYTON ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6x6 | 5998362.0 | 2109233.0 | 37.7714572219689 | -122.449054588277 | (37.7714572219689, -122.449054588277) | ||||
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) | |||
124107 | 124107 | 225384 | Undocumented 2 | Fraxinus spp :: Ash Spp 83 | 300 Chattanooga St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 4ft | 6004767.459419999 | 2101889.24161 | 37.7516572687753 | -122.426374799776 | (37.7516572687753, -122.426374799776) | |||
129661 | 129661 | 120476 | Undocumented 2 | Fraxinus spp :: Ash Spp 83 | 2153 Lake St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 2 | Width 3ft | 5988709.31254 | 2114650.77812 | 37.785776133796894 | -122.482840445446 | (37.7857761337969, -122.482840445446) | |||
129868 | 129868 | 192343 | Undocumented 2 | Fraxinus spp :: Ash Spp 83 | 10 10th St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6007880.06697 | 2110469.37964 | 37.7753917940266 | -122.416218594918 | (37.7753917940266, -122.416218594918) | |||
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) | |||
130852 | 130852 | 192276 | Undocumented 2 | Fraxinus spp :: Ash Spp 83 | 1490 Harrison St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6009052.59315 | 2108786.2519900003 | 37.7708361801883 | -122.412043563376 | (37.7708361801883, -122.412043563376) | |||
130861 | 130861 | 225380 | Undocumented 2 | Fraxinus spp :: Ash Spp 83 | 3200 Cesar Chavez St | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 3ft | 6008095.36431 | 2100612.74929 | 37.7483398640139 | -122.41477610753401 | (37.7483398640139, -122.414776107534) | |||
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) | |||
131457 | 131457 | 128813 | Undocumented 2 | Fraxinus spp :: Ash Spp 83 | 843 Van Ness Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 14 | Width 4ft | 6006569.2006 | 2113431.92774 | 37.783452436413 | -122.42096358442 | (37.783452436413, -122.42096358442) | |||
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) | |||
131891 | 131891 | 192267 | Undocumented 2 | Fraxinus spp :: Ash Spp 83 | 450 11th St | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 6009086.5930699995 | 2108586.06933 | 37.7702884327847 | -122.41191180818998 | (37.7702884327847, -122.41191180819) | |||
131904 | 131904 | 192291 | Undocumented 2 | Fraxinus spp :: Ash Spp 83 | 1490 Harrison St | 20 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6009258.26702 | 2108978.96062 | 37.77137685078 | -122.41134574611 | (37.77137685078, -122.41134574611) | |||
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) | |||
132924 | 132924 | 120306 | Undocumented 2 | Fraxinus spp :: Ash Spp 83 | 100 23rd Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 6 | Width 6ft | 5988689.7691 | 2114567.26931 | 37.7855457051568 | -122.482901936944 | (37.7855457051568, -122.482901936944) | |||
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) | |||
133855 | 133855 | 192255 | Undocumented 2 | Fraxinus spp :: Ash Spp 83 | 450 11th St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6009278.39034 | 2108387.11077 | 37.769752897294204 | -122.41123432280001 | (37.7697528972942, -122.4112343228) | |||
134215 | 134215 | 192336 | Undocumented 2 | Fraxinus spp :: Ash Spp 83 | 65 10th St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 4ft | 6007840.5436 | 2110603.67429 | 37.775758312732 | -122.41636483009898 | (37.775758312732, -122.416364830099) |
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");