trees
1,408 rows where qSpecies_id = 113 sorted by Longitude
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3905 | 19979 | DPW Maintained 1 | Juniperus chinensis :: Juniper 113 | 100 STAIRWAY45 | 6 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3 | 30ST | |||||||||||||
5147 | 19819 | DPW Maintained 1 | Juniperus chinensis :: Juniper 113 | 100 STAIRWAY25 | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 100ST | |||||||||||||
5627 | 19964 | DPW Maintained 1 | Juniperus chinensis :: Juniper 113 | 100 STAIRWAY41 | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 25ST | |||||||||||||
9556 | 19963 | DPW Maintained 1 | Juniperus chinensis :: Juniper 113 | 100 STAIRWAY41 | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 25ST | |||||||||||||
11839 | 19962 | DPW Maintained 1 | Juniperus chinensis :: Juniper 113 | 100 STAIRWAY41 | -2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 25ST | |||||||||||||
15840 | 258303 | Private 9 | Juniperus chinensis :: Juniper 113 | 1x Dawnview Way | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | |||||||||||||||
19573 | 254456 | Significant Tree 6 | Juniperus chinensis :: Juniper 113 | 1055X Duncan St | 1 | Side Yard : Yard | Tree | Private 2 | |||||||||||||||
25805 | 190829 | DPW Maintained 1 | Juniperus chinensis :: Juniper 113 | 256 Terry A Francois Blvd | 14 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 6ft | 6016399.44084 | 2108687.19343 | 37.770973655936 | -122.386623509886 | (37.770973655936, -122.386623509886) | 14 | 3 | 9 | 310 | 20 | |||
20127 | 190830 | DPW Maintained 1 | Juniperus chinensis :: Juniper 113 | 256 Terry A Francois Blvd | 15 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 6ft | 6016394.93406 | 2108680.04428 | 37.7709537764279 | -122.38663860051 | (37.7709537764279, -122.38663860051) | 14 | 3 | 9 | 310 | 20 | |||
111781 | 190828 | DPW Maintained 1 | Juniperus chinensis :: Juniper 113 | 256 Terry A Francois Blvd | 13 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 6ft | 6016393.1041 | 2108697.45755 | 37.7710014881618 | -122.386646144905 | (37.7710014881618, -122.386646144905) | 14 | 3 | 9 | 310 | 20 | |||
121275 | 190827 | DPW Maintained 1 | Juniperus chinensis :: Juniper 113 | 256 Terry A Francois Blvd | 12 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 6ft | 6016391.89134 | 2108709.42861 | 37.7710342909422 | -122.386651174818 | (37.7710342909422, -122.386651174818) | 14 | 3 | 9 | 310 | 20 | |||
142461 | 190826 | DPW Maintained 1 | Juniperus chinensis :: Juniper 113 | 256 Terry A Francois Blvd | 11 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 6ft | 6016386.63874 | 2108737.40916 | 37.7711108286363 | -122.38667129537 | (37.7711108286363, -122.38667129537) | 14 | 3 | 9 | 310 | 20 | |||
60573 | 190824 | DPW Maintained 1 | Juniperus chinensis :: Juniper 113 | 256 Terry A Francois Blvd | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 6ft | 6016384.03812 | 2108752.66613 | 37.7711525769716 | -122.386681355179 | (37.7711525769716, -122.386681355179) | 14 | 3 | 9 | 310 | 20 | |||
161382 | 190825 | DPW Maintained 1 | Juniperus chinensis :: Juniper 113 | 256 Terry A Francois Blvd | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 6ft | 6016379.81466 | 2108741.52884 | 37.7711217625796 | -122.386695187647 | (37.7711217625796, -122.386695187647) | 14 | 3 | 9 | 310 | 20 | |||
73210 | 60417 | DPW Maintained 1 | Juniperus chinensis :: Juniper 113 | 1409 Keith St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/26/1982 12:00:00 AM | 8 | Permit Number 19998 | 6016082.74679 | 2094573.46449 | 37.7322027709252 | -122.386734593253 | (37.7322027709252, -122.386734593253) | 10 | 3 | 8 | 58 | 1 | ||
162388 | 200731 | DPW Maintained 1 | Juniperus chinensis :: Juniper 113 | 1462 Oakdale Ave | 1 | unknown : Yard | Tree | Private 2 | 4 | Width 0ft | 6015811.2335 | 2094944.8797 | 37.7332075665853 | -122.387699188627 | (37.7332075665853, -122.387699188627) | 10 | 3 | 8 | 58 | 1 | |||
179173 | 200732 | DPW Maintained 1 | Juniperus chinensis :: Juniper 113 | 1462 Oakdale Ave | 2 | unknown : Yard | Tree | Private 2 | 4 | Width 0ft | 6015803.6984 | 2094934.205 | 37.7331778386107 | -122.387724495212 | (37.7331778386107, -122.387724495212) | 10 | 3 | 8 | 58 | 1 | |||
111742 | 190772 | DPW Maintained 1 | Juniperus chinensis :: Juniper 113 | 1099 Tennessee St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 1ft | 6015576.75199 | 2103999.13742 | 37.7580556897494 | -122.389141847222 | (37.7580556897494, -122.389141847222) | 10 | 3 | 8 | 28856 | 29 | |||
69689 | 190771 | DPW Maintained 1 | Juniperus chinensis :: Juniper 113 | 15 Tubbs St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 2ft | 6015464.37774 | 2103329.09363 | 37.7562096621716 | -122.389483695716 | (37.7562096621716, -122.389483695716) | 10 | 3 | 8 | 28856 | 29 | |||
148234 | 190767 | DPW Maintained 1 | Juniperus chinensis :: Juniper 113 | 1400 Minnesota St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 2ft | 6015346.46104 | 2101795.38447 | 37.7519918831343 | -122.389784373252 | (37.7519918831343, -122.389784373252) | 10 | 3 | 8 | 28856 | 1 | |||
171217 | 190766 | DPW Maintained 1 | Juniperus chinensis :: Juniper 113 | 1400 Minnesota St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 2ft | 6015346.06271 | 2101819.81527 | 37.752058942871 | -122.389787457026 | (37.752058942871, -122.389787457026) | 10 | 3 | 8 | 28856 | 1 | |||
133669 | 190765 | DPW Maintained 1 | Juniperus chinensis :: Juniper 113 | 1050 26th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 6015259.20985 | 2101616.65669 | 37.7514962955391 | -122.390073618616 | (37.7514962955391, -122.390073618616) | 10 | 3 | 8 | 28856 | 1 | |||
110502 | 190768 | DPW Maintained 1 | Juniperus chinensis :: Juniper 113 | 1475 Indiana St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 5ft | 6015141.73354 | 2101746.80367 | 37.7518471354589 | -122.39048896239 | (37.7518471354589, -122.39048896239) | 10 | 3 | 8 | 28856 | 1 | |||
134465 | 190769 | DPW Maintained 1 | Juniperus chinensis :: Juniper 113 | 1199 Indiana St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | Width 2ft | 6015071.47128 | 2103030.97705 | 37.7553693050738 | -122.390821678275 | (37.7553693050738, -122.390821678275) | 10 | 3 | 8 | 28856 | 29 | |||
142487 | 190770 | DPW Maintained 1 | Juniperus chinensis :: Juniper 113 | 1199 Indiana St | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 8 | Width 2ft | 6015070.85795 | 2103044.75282 | 37.7554070963733 | -122.390824762063 | (37.7554070963733, -122.390824762063) | 10 | 3 | 8 | 28856 | 29 | |||
32051 | 110919 | DPW Maintained 1 | Juniperus chinensis :: Juniper 113 | 77 Federal St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 2x1 | 6014784.35432 | 2113116.8816 | 37.7830470409324 | -122.39252008665 | (37.7830470409324, -122.39252008665) | 6 | 2 | 9 | 28856 | 6 | |||
75959 | 255488 | DPW Maintained 1 | Juniperus chinensis :: Juniper 113 | 77 Federal St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2x1 | 6014784.35432 | 2113116.8816 | 37.7830470409324 | -122.39252008665 | (37.7830470409324, -122.39252008665) | 6 | 2 | 9 | 28856 | 6 | ||||
20305 | 110918 | DPW Maintained 1 | Juniperus chinensis :: Juniper 113 | 77 Federal St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 2x1 | 6014775.51071 | 2113108.67341 | 37.7830240119856 | -122.392550107818 | (37.7830240119856, -122.392550107818) | 6 | 2 | 9 | 28856 | 6 | |||
84670 | 110917 | DPW Maintained 1 | Juniperus chinensis :: Juniper 113 | 77 Federal St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 2x1 | 6014761.22745 | 2113096.50864 | 37.7829898170664 | -122.39259867121 | (37.7829898170664, -122.39259867121) | 6 | 2 | 9 | 28856 | 6 | |||
45006 | 110916 | DPW Maintained 1 | Juniperus chinensis :: Juniper 113 | 77 Federal St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 2x1 | 6014753.14393 | 2113088.03092 | 37.7829660902443 | -122.392626043851 | (37.7829660902443, -122.392626043851) | 6 | 2 | 9 | 28856 | 6 | |||
154242 | 110915 | DPW Maintained 1 | Juniperus chinensis :: Juniper 113 | 77 Federal St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 2x1 | 6014720.0191 | 2113052.86526 | 37.7828676936327 | -122.39273818212 | (37.7828676936327, -122.39273818212) | 6 | 2 | 9 | 28856 | 6 | |||
161404 | 190762 | DPW Maintained 1 | Juniperus chinensis :: Juniper 113 | 1540 Newhall St | 5 | Sidewalk: Curb side : Yard | Tree | Private 2 | 3 | Width 6ft | 6014201.85219 | 2095471.12026 | 37.7345632359036 | -122.393300111809 | (37.7345632359036, -122.393300111809) | 10 | 3 | 8 | 58 | 1 | |||
174060 | 190785 | DPW Maintained 1 | Juniperus chinensis :: Juniper 113 | 566 Pennsylvania Ave | 1 | Sidewalk: Curb side : Pot | Tree | Private 2 | 4 | Width 4ft | 6014353.50154 | 2104489.0568 | 37.7593330157277 | -122.393406687779 | (37.7593330157277, -122.393406687779) | 10 | 3 | 8 | 28856 | 29 | |||
174711 | 202033 | DPW Maintained 1 | Juniperus chinensis :: Juniper 113 | 1319 Fitzgerald Ave | 3 | Front Yard : Yard | Tree | Private 2 | 10 | Width 7ft | 6014010.86588 | 2090963.17222 | 37.722174710472 | -122.393645010822 | (37.722174710472, -122.393645010822) | 10 | 3 | 8 | 58 | 1 | |||
60578 | 202032 | DPW Maintained 1 | Juniperus chinensis :: Juniper 113 | 1319 Fitzgerald Ave | 2 | Front Yard : Yard | Tree | Private 2 | 9 | Width 7ft | 6014005.50578 | 2090967.22182 | 37.7221855320171 | -122.393663822829 | (37.7221855320171, -122.393663822829) | 10 | 3 | 8 | 58 | 1 | |||
110846 | 202031 | DPW Maintained 1 | Juniperus chinensis :: Juniper 113 | 1319 Fitzgerald Ave | 1 | Front Yard : Yard | Tree | Private 2 | 6 | Width 7ft | 6013998.1976 | 2090972.78897 | 37.7222004121965 | -122.3936894751 | (37.7222004121965, -122.3936894751) | 10 | 3 | 8 | 58 | 1 | |||
158844 | 190773 | DPW Maintained 1 | Juniperus chinensis :: Juniper 113 | 1250 20th St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 12 | Width 3ft | 6014219.74434 | 2104829.04394 | 37.7602591141902 | -122.393893087907 | (37.7602591141902, -122.393893087907) | 10 | 3 | 8 | 28856 | 29 | |||
192197 | 190774 | DPW Maintained 1 | Juniperus chinensis :: Juniper 113 | 1250 20th St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 8 | Width 3ft | 6014212.60816 | 2104828.72459 | 37.7602578407333 | -122.393917746432 | (37.7602578407333, -122.393917746432) | 10 | 3 | 8 | 28856 | 29 | |||
154764 | 190775 | DPW Maintained 1 | Juniperus chinensis :: Juniper 113 | 1250 20th St | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 7 | Width 3ft | 6014206.12343 | 2104828.07469 | 37.7602556958576 | -122.393940128741 | (37.7602556958576, -122.393940128741) | 10 | 3 | 8 | 28856 | 29 | |||
51456 | 190776 | DPW Maintained 1 | Juniperus chinensis :: Juniper 113 | 1250 20th St | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | Width 3ft | 6014199.34446 | 2104827.43075 | 37.7602535509897 | -122.393963529112 | (37.7602535509897, -122.393963529112) | 10 | 3 | 8 | 28856 | 29 | |||
36765 | 190777 | DPW Maintained 1 | Juniperus chinensis :: Juniper 113 | 1250 20th St | 5 | Sidewalk: Property side : Yard | Tree | Private 2 | 14 | Width 3ft | 6014189.92463 | 2104827.29978 | 37.7602526678497 | -122.393996098953 | (37.7602526678497, -122.393996098953) | 10 | 3 | 8 | 28856 | 29 | |||
191675 | 190778 | DPW Maintained 1 | Juniperus chinensis :: Juniper 113 | 1250 20th St | 6 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | Width 3ft | 6014183.52193 | 2104826.52769 | 37.760250192011 | -122.394018188999 | (37.760250192011, -122.394018188999) | 10 | 3 | 8 | 28856 | 29 | |||
18645 | 190779 | DPW Maintained 1 | Juniperus chinensis :: Juniper 113 | 1250 20th St | 7 | Sidewalk: Property side : Yard | Tree | Private 2 | 7 | Width 3ft | 6014174.76629 | 2104825.83566 | 37.760247805222 | -122.394048422422 | (37.760247805222, -122.394048422422) | 10 | 3 | 8 | 28856 | 29 | |||
95308 | 190780 | DPW Maintained 1 | Juniperus chinensis :: Juniper 113 | 1250 20th St | 8 | Sidewalk: Property side : Yard | Tree | Private 2 | 9 | Width 3ft | 6014170.03779 | 2104825.95659 | 37.7602478744635 | -122.394064784669 | (37.7602478744635, -122.394064784669) | 10 | 3 | 8 | 28856 | 29 | |||
156065 | 190781 | DPW Maintained 1 | Juniperus chinensis :: Juniper 113 | 1250 20th St | 9 | Sidewalk: Property side : Yard | Tree | Private 2 | 11 | Width 3ft | 6014163.55299 | 2104825.48324 | 37.7602462143239 | -122.394087179573 | (37.7602462143239, -122.394087179573) | 10 | 3 | 8 | 28856 | 29 | |||
75872 | 190782 | DPW Maintained 1 | Juniperus chinensis :: Juniper 113 | 1250 20th St | 10 | Sidewalk: Property side : Yard | Tree | Private 2 | 13 | Width 3ft | 6014143.03501 | 2104824.38211 | 37.7602420504487 | -122.394158065056 | (37.7602420504487, -122.394158065056) | 10 | 3 | 8 | 28856 | 29 | |||
75039 | 190783 | DPW Maintained 1 | Juniperus chinensis :: Juniper 113 | 1250 20th St | 11 | Sidewalk: Property side : Yard | Tree | Private 2 | 13 | Width 3ft | 6014136.07474 | 2104824.01763 | 37.7602406627968 | -122.394182112018 | (37.7602406627968, -122.394182112018) | 10 | 3 | 8 | 28856 | 29 | |||
85085 | 190784 | DPW Maintained 1 | Juniperus chinensis :: Juniper 113 | 1250 20th St | 12 | Sidewalk: Property side : Yard | Tree | Private 2 | 15 | Width 3ft | 6014129.55308 | 2104823.76611 | 37.7602396096831 | -122.39420464993 | (37.7602396096831, -122.39420464993) | 10 | 3 | 8 | 28856 | 29 | |||
172158 | 190812 | DPW Maintained 1 | Juniperus chinensis :: Juniper 113 | 618 Texas St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 14 | Width 2ft | 6013802.60494 | 2104175.98165 | 37.7584427561511 | -122.395290039002 | (37.7584427561511, -122.395290039002) | 10 | 3 | 8 | 28856 | 29 | |||
151811 | 176634 | DPW Maintained 1 | Juniperus chinensis :: Juniper 113 | 600 Blanken Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 15 | Width 5ft | 6013132.57563 | 2086873.0357 | 37.7108951651419 | -122.396394525203 | (37.7108951651419, -122.396394525203) | 10 | 3 | 8 | 309 | 1 | |||
58121 | 190761 | DPW Maintained 1 | Juniperus chinensis :: Juniper 113 | 285 Connecticut St | 1 | : | Tree | Private 2 | 21 | Width 3ft | 6013218.56242 | 2105774.14575 | 37.76279846511 | -122.397422010521 | (37.76279846511, -122.397422010521) | 14 | 3 | 8 | 28856 | 29 | |||
39681 | 190819 | DPW Maintained 1 | Juniperus chinensis :: Juniper 113 | 2301 Silver Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 12 | Width 4ft | 6013014.89599 | 2096394.02219 | 37.7370313173328 | -122.397468547752 | (37.7370313173328, -122.397468547752) | 10 | 3 | 8 | 58 | 1 | |||
144631 | 190821 | DPW Maintained 1 | Juniperus chinensis :: Juniper 113 | 13 Jennings Ct | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 8 | Width 2ft | 6012858.06593 | 2089298.31669 | 37.7175392260401 | -122.397513284525 | (37.7175392260401, -122.397513284525) | 10 | 3 | 8 | 58 | 1 | |||
117012 | 201354 | DPW Maintained 1 | Juniperus chinensis :: Juniper 113 | 1 Bitting Ave | 16 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | Width 10ft | 6012921.13477 | 2092559.31371 | 37.7264967776018 | -122.397523861451 | (37.7264967776018, -122.397523861451) | 10 | 3 | 8 | 58 | 1 | |||
77082 | 190822 | DPW Maintained 1 | Juniperus chinensis :: Juniper 113 | 13 Jennings Ct | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | Width 2ft | 6012854.05467 | 2089293.52608 | 37.7175258486306 | -122.397526813914 | (37.7175258486306, -122.397526813914) | 10 | 3 | 8 | 58 | 1 | |||
96751 | 190820 | DPW Maintained 1 | Juniperus chinensis :: Juniper 113 | 2301 Silver Ave | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 12 | Width 4ft | 6012984.54663 | 2096381.05311 | 37.7369940170607 | -122.397572570511 | (37.7369940170607, -122.397572570511) | 10 | 3 | 8 | 58 | 1 | |||
12750 | 201353 | DPW Maintained 1 | Juniperus chinensis :: Juniper 113 | 1 Bitting Ave | 15 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | Width 8ft | 6012904.00238 | 2092563.8073 | 37.7265081621175 | -122.397583402851 | (37.7265081621175, -122.397583402851) | 10 | 3 | 8 | 58 | 1 | |||
160827 | 201352 | DPW Maintained 1 | Juniperus chinensis :: Juniper 113 | 1 Bitting Ave | 14 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | Width 8ft | 6012884.58431 | 2092567.59361 | 37.7265174772786 | -122.397650796243 | (37.7265174772786, -122.397650796243) | 10 | 3 | 8 | 58 | 1 | |||
69717 | 201351 | DPW Maintained 1 | Juniperus chinensis :: Juniper 113 | 1 Bitting Ave | 13 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | Width 8ft | 6012866.15074 | 2092573.24489 | 37.7265319680523 | -122.397714917004 | (37.7265319680523, -122.397714917004) | 10 | 3 | 8 | 58 | 1 | |||
119137 | 201350 | DPW Maintained 1 | Juniperus chinensis :: Juniper 113 | 1 Bitting Ave | 12 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 8ft | 6012847.3383 | 2092578.90387 | 37.7265464588349 | -122.397780348078 | (37.7265464588349, -122.397780348078) | 10 | 3 | 8 | 58 | 1 | |||
190197 | 201349 | DPW Maintained 1 | Juniperus chinensis :: Juniper 113 | 1 Bitting Ave | 11 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | Width 8ft | 6012827.9931 | 2092586.2696 | 37.7265656062986 | -122.39784774059 | (37.7265656062986, -122.39784774059) | 10 | 3 | 8 | 58 | 1 | |||
145430 | 190813 | DPW Maintained 1 | Juniperus chinensis :: Juniper 113 | 870 Arkansas St | 2 | : | Tree | Private 2 | 12 | Width 3ft | 6013034.16138 | 2103011.82985 | 37.7552034817751 | -122.39786601663 | (37.7552034817751, -122.39786601663) | 10 | 3 | 8 | 28856 | 29 | |||
153568 | 201348 | DPW Maintained 1 | Juniperus chinensis :: Juniper 113 | 1 Bitting Ave | 10 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 8ft | 6012808.60563 | 2092591.56329 | 37.7265790619707 | -122.397915133977 | (37.7265790619707, -122.397915133977) | 10 | 3 | 8 | 58 | 1 | |||
170212 | 201347 | DPW Maintained 1 | Juniperus chinensis :: Juniper 113 | 1 Bitting Ave | 9 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | Width 8ft | 6012791.8631 | 2092596.61468 | 37.7265919996064 | -122.397973366875 | (37.7265919996064, -122.397973366875) | 10 | 3 | 8 | 58 | 1 | |||
128308 | 25938 | DPW Maintained 1 | Juniperus chinensis :: Juniper 113 | 2000 Oakdale Ave | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/22/1997 12:00:00 AM | 12 | 3x3 | 6012867.3394 | 2097145.55731 | 37.7390866585199 | -122.398031427109 | (37.7390866585199, -122.398031427109) | 10 | 3 | 8 | 58 | 1 | ||
194059 | 201346 | DPW Maintained 1 | Juniperus chinensis :: Juniper 113 | 1 Bitting Ave | 8 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | Width 8ft | 6012773.9855 | 2092601.68911 | 37.7266049372574 | -122.398035525332 | (37.7266049372574, -122.398035525332) | 10 | 3 | 8 | 58 | 1 | |||
136033 | 25939 | DPW Maintained 1 | Juniperus chinensis :: Juniper 113 | 2000 Oakdale Ave | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/22/1997 12:00:00 AM | 10 | 3x3 | 6012857.31615 | 2097153.53613 | 37.7391080084261 | -122.398066642772 | (37.7391080084261, -122.398066642772) | 10 | 3 | 8 | 58 | 1 | ||
20879 | 201345 | DPW Maintained 1 | Juniperus chinensis :: Juniper 113 | 1 Bitting Ave | 7 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | Width 8ft | 6012754.45078 | 2092609.05906 | 37.7266240856064 | -122.398103573427 | (37.7266240856064, -122.398103573427) | 10 | 3 | 8 | 58 | 1 | |||
23166 | 201343 | DPW Maintained 1 | Juniperus chinensis :: Juniper 113 | 1 Bitting Ave | 5 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | 6012739.9825 | 2092614.25301 | 37.7266375412648 | -122.398153954334 | (37.7266375412648, -122.398153954334) | 10 | 3 | 8 | 58 | 1 | ||||
3844 | 54791 | DPW Maintained 1 | Juniperus chinensis :: Juniper 113 | 280 Tocoloma Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/02/1972 12:00:00 AM | 18 | Permit Number 10640 | 6012628.37407 | 2087183.5823 | 37.7117197939932 | -122.398158948299 | (37.7117197939932, -122.398158948299) | 10 | 3 | 8 | 309 | 1 | ||
108403 | 176635 | DPW Maintained 1 | Juniperus chinensis :: Juniper 113 | 280 Tocoloma Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 17 | Width 3ft | 6012623.11061 | 2087166.05245 | 37.7116713673138 | -122.398175911295 | (37.7116713673138, -122.398175911295) | 10 | 3 | 8 | 309 | 1 | |||
176660 | 190760 | DPW Maintained 1 | Juniperus chinensis :: Juniper 113 | 406 Arkansas St | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 9 | Width 2ft | 6012908.38945 | 2105116.29334 | 37.7609748729022 | -122.398448634303 | (37.7609748729022, -122.398448634303) | 10 | 3 | 8 | 28856 | 29 | |||
133876 | 202046 | DPW Maintained 1 | Juniperus chinensis :: Juniper 113 | 47 Exeter St | 2 | : | Tree | Private 2 | 8 | Width 2ft | 6012581.44921 | 2090990.21223 | 37.722169424252 | -122.398588087695 | (37.722169424252, -122.398588087695) | 10 | 3 | 8 | 58 | 1 | |||
139448 | 190786 | DPW Maintained 1 | Juniperus chinensis :: Juniper 113 | 1800 20th St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 9 | Width 3ft | 6012611.0611 | 2104735.49741 | 37.7599127232141 | -122.39945023535 | (37.7599127232141, -122.39945023535) | 10 | 3 | 8 | 28856 | 29 | |||
115795 | 190794 | DPW Maintained 1 | Juniperus chinensis :: Juniper 113 | 1701 19th St | 17 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | Width 7ft | 6012616.86212 | 2105145.29416 | 37.7610382580338 | -122.399458942574 | (37.7610382580338, -122.399458942574) | 10 | 3 | 8 | 28856 | 29 | |||
48076 | 190793 | DPW Maintained 1 | Juniperus chinensis :: Juniper 113 | 1701 19th St | 16 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 7ft | 6012612.20742 | 2105147.56278 | 37.7610442277201 | -122.39947520054 | (37.7610442277201, -122.39947520054) | 10 | 3 | 8 | 28856 | 29 | |||
173807 | 190792 | DPW Maintained 1 | Juniperus chinensis :: Juniper 113 | 1701 19th St | 15 | Sidewalk: Property side : Yard | Tree | Private 2 | 2 | Width 7ft | 6012608.36477 | 2105144.14311 | 37.7610346238788 | -122.399488250597 | (37.7610346238788, -122.399488250597) | 10 | 3 | 8 | 28856 | 29 | |||
75005 | 190763 | DPW Maintained 1 | Juniperus chinensis :: Juniper 113 | 1901 Quint St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 18 | Width 2ft | 6012404.6522 | 2095210.16355 | 37.7337466919524 | -122.399495357942 | (37.7337466919524, -122.399495357942) | 10 | 3 | 8 | 58 | 1 | |||
191558 | 190791 | DPW Maintained 1 | Juniperus chinensis :: Juniper 113 | 1701 19th St | 14 | Sidewalk: Property side : Yard | Tree | Private 2 | 2 | Width 7ft | 6012603.88401 | 2105144.39947 | 37.7610350780349 | -122.3995037657 | (37.7610350780349, -122.3995037657) | 10 | 3 | 8 | 28856 | 29 | |||
77537 | 190787 | DPW Maintained 1 | Juniperus chinensis :: Juniper 113 | 1800 20th St | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 14 | Width 3ft | 6012588.54994 | 2104735.58067 | 37.7599116970885 | -122.399528096854 | (37.7599116970885, -122.399528096854) | 10 | 3 | 8 | 28856 | 29 | |||
27276 | 190790 | DPW Maintained 1 | Juniperus chinensis :: Juniper 113 | 1701 19th St | 11 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | Width 7ft | 6012585.92688 | 2105143.77126 | 37.7610323521809 | -122.399565827911 | (37.7610323521809, -122.399565827911) | 10 | 3 | 8 | 28856 | 29 | |||
43815 | 190789 | DPW Maintained 1 | Juniperus chinensis :: Juniper 113 | 1701 19th St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | Width 7ft | 6012459.01369 | 2105136.91709 | 37.761006457089 | -122.400004286971 | (37.761006457089, -122.400004286971) | 10 | 3 | 8 | 28856 | 29 | |||
142302 | 190788 | DPW Maintained 1 | Juniperus chinensis :: Juniper 113 | 1701 19th St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | Width 9ft | 6012435.91117 | 2105136.55887 | 37.7610041854195 | -122.400084163877 | (37.7610041854195, -122.400084163877) | 10 | 3 | 8 | 28856 | 29 | |||
68886 | 190796 | DPW Maintained 1 | Juniperus chinensis :: Juniper 113 | 2051 23rd St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 3ft | 6012309.4819 | 2102792.88049 | 37.7545619099258 | -122.400356809539 | (37.7545619099258, -122.400356809539) | 10 | 3 | 8 | 28856 | 29 | |||
188331 | 190757 | DPW Maintained 1 | Juniperus chinensis :: Juniper 113 | 616 Carolina St | 3 | Sidewalk: Curb side : Pot | Tree | Private 2 | 7 | Width 2ft | 6012351.18634 | 2105065.20215 | 37.7608035313788 | -122.400372179842 | (37.7608035313788, -122.400372179842) | 10 | 3 | 8 | 28856 | 29 | |||
65724 | 101799 | DPW Maintained 1 | Juniperus chinensis :: Juniper 113 | 616 Carolina St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | 6x6 | 6012351.43379 | 2105077.38644 | 37.7608370005419 | -122.400372179851 | (37.7608370005419, -122.400372179851) | 10 | 3 | 8 | 28856 | 29 | |||
18027 | 190795 | DPW Maintained 1 | Juniperus chinensis :: Juniper 113 | 2051 23rd St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 3ft | 6012296.97439 | 2102792.20367 | 37.7545593540486 | -122.400400016553 | (37.7545593540486, -122.400400016553) | 10 | 3 | 8 | 28856 | 29 | |||
112756 | 190805 | DPW Maintained 1 | Juniperus chinensis :: Juniper 113 | 1924 22nd St | 2 | : | Tree | Private 2 | 8 | Width 2ft | 6012299.62421 | 2103787.4473 | 37.7572922228659 | -122.400460756771 | (37.7572922228659, -122.400460756771) | 10 | 3 | 8 | 28856 | 29 | |||
68558 | 190811 | DPW Maintained 1 | Juniperus chinensis :: Juniper 113 | 1400 De Haro St | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 15 | 6012250.38187 | 2101814.62177 | 37.7518725286982 | -122.400492482145 | (37.7518725286982, -122.400492482145) | 10 | 3 | 8 | 28856 | 29 | ||||
140743 | 190810 | DPW Maintained 1 | Juniperus chinensis :: Juniper 113 | 1400 De Haro St | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 12 | 6012250.57302 | 2101824.03335 | 37.7518983815133 | -122.400492482157 | (37.7518983815133, -122.400492482157) | 10 | 3 | 8 | 28856 | 29 | ||||
53563 | 190806 | DPW Maintained 1 | Juniperus chinensis :: Juniper 113 | 1924 22nd St | 3 | : | Tree | Private 2 | 8 | Width 2ft | 6012287.44957 | 2103786.76177 | 37.7572896615996 | -122.400502813555 | (37.7572896615996, -122.400502813555) | 10 | 3 | 8 | 28856 | 29 | |||
184683 | 190807 | DPW Maintained 1 | Juniperus chinensis :: Juniper 113 | 1950 22nd St | 1 | : | Tree | Private 2 | 12 | Width 2ft | 6012259.17788 | 2103783.27956 | 37.7572785235114 | -122.400600344128 | (37.7572785235114, -122.400600344128) | 10 | 3 | 8 | 28856 | 29 | |||
1587 | 35594 | DPW Maintained 1 | Juniperus chinensis :: Juniper 113 | 1303 Rhode Island St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/27/1998 12:00:00 AM | 5 | Permit Number 38957 | 6012015.58746 | 2102213.67536 | 37.7529551460873 | -122.401332479509 | (37.7529551460873, -122.401332479509) | 10 | 3 | 8 | 28856 | 29 | |
168403 | 190797 | DPW Maintained 1 | Juniperus chinensis :: Juniper 113 | 2098 20th St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 16 | Width 7ft | 6011937.57127 | 2104699.91058 | 37.7597774480841 | -122.401777021595 | (37.7597774480841, -122.401777021595) | 10 | 3 | 8 | 28856 | 29 | |||
10906 | 190798 | DPW Maintained 1 | Juniperus chinensis :: Juniper 113 | 2098 20th St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 16 | Width 7ft | 6011929.82719 | 2104699.62352 | 37.7597762277144 | -122.401803784534 | (37.7597762277144, -122.401803784534) | 10 | 3 | 8 | 28856 | 29 | |||
152714 | 190799 | DPW Maintained 1 | Juniperus chinensis :: Juniper 113 | 2098 20th St | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 23 | Width 7ft | 6011915.50815 | 2104697.98802 | 37.7597709378887 | -122.401853192367 | (37.7597709378887, -122.401853192367) | 10 | 3 | 8 | 28856 | 29 | |||
87177 | 190800 | DPW Maintained 1 | Juniperus chinensis :: Juniper 113 | 2098 20th St | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 24 | Width 7ft | 6011906.27954 | 2104697.87951 | 37.7597701249107 | -122.401885102143 | (37.7597701249107, -122.401885102143) | 10 | 3 | 8 | 28856 | 29 | |||
80685 | 119672 | Undocumented 4 | Juniperus chinensis :: Juniper 113 | 2090x 20th St | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | 6011896 | 2104722 | 37.7598357807336 | -122.401922349815 | (37.7598357807336, -122.401922349815) | 10 | 3 | 8 | 28856 | 29 | |||||
118330 | 190804 | DPW Maintained 1 | Juniperus chinensis :: Juniper 113 | 960 Rhode Island St | 4 | : | Tree | Private 2 | 9 | Width 2ft | 6011852.70607 | 2103917.67826 | 37.7576248748965 | -122.402015538912 | (37.7576248748965, -122.402015538912) | 10 | 3 | 8 | 28856 | 29 | |||
177692 | 190803 | DPW Maintained 1 | Juniperus chinensis :: Juniper 113 | 960 Rhode Island St | 3 | : | Tree | Private 2 | 7 | Width 2ft | 6011852.27614 | 2103926.33475 | 37.7576486197115 | -122.402017634333 | (37.7576486197115, -122.402017634333) | 10 | 3 | 8 | 28856 | 29 |
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) );