trees
1,408 rows where qSpecies_id = 113 sorted by Zip Codes
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 | |||||||||||||||
| 94077 | 103591 | Significant Tree 6 | Juniperus chinensis :: Juniper 113 | 55X Laguna St | 3 | Front Yard : Yard | Tree | Private 2 | 6005242.6 | 2108960.5 | 37.7711001201992 | -122.425234826708 | (37.7711001201992, -122.425234826708) | 7 | 9 | 5 | 28852 | 10 | |||||
| 120358 | 103590 | Significant Tree 6 | Juniperus chinensis :: Juniper 113 | 55X Laguna St | 2 | Front Yard : Yard | Tree | Private 2 | 6005242.6 | 2108960.5 | 37.7711001201992 | -122.425234826708 | (37.7711001201992, -122.425234826708) | 7 | 9 | 5 | 28852 | 10 | |||||
| 154569 | 103589 | Significant Tree 6 | Juniperus chinensis :: Juniper 113 | 55X Laguna St | 1 | Front Yard : Yard | Tree | Private 2 | 6005242.6 | 2108960.5 | 37.7711001201992 | -122.425234826708 | (37.7711001201992, -122.425234826708) | 7 | 9 | 5 | 28852 | 10 | |||||
| 47374 | 190817 | DPW Maintained 1 | Juniperus chinensis :: Juniper 113 | 390x Hampshire St | 5 | Median : Cutout | Tree | DPW 1 | 13 | Width 5ft | 6010044.56493 | 2106488.02831 | 37.7645813917285 | -122.408450158441 | (37.7645813917285, -122.408450158441) | 8 | 4 | 8 | 28853 | 19 | |||
| 51023 | 190814 | DPW Maintained 1 | Juniperus chinensis :: Juniper 113 | 390x Hampshire St | 1 | Median : Cutout | Tree | DPW 1 | 16 | Width 5ft | 6010041.11906 | 2106539.02685 | 37.7647212291204 | -122.408465674446 | (37.7647212291204, -122.408465674446) | 8 | 4 | 8 | 28853 | 19 | |||
| 100239 | 190816 | DPW Maintained 1 | Juniperus chinensis :: Juniper 113 | 390x Hampshire St | 3 | Median : Cutout | Tree | DPW 1 | 7 | Width 5ft | 6010044.10542 | 2106509.48106 | 37.7646402703573 | -122.408453261111 | (37.7646402703573, -122.408453261111) | 8 | 4 | 8 | 28853 | 19 | |||
| 146958 | 226884 | DPW Maintained 1 | Juniperus chinensis :: Juniper 113 | 1 Hidalgo Ter | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 18 | Width 2ft | 6005071.43074 | 2107486.30066 | 37.7670426518224 | -122.425721963013 | (37.7670426518224, -122.425721963013) | 8 | 4 | 5 | 28853 | 19 | |||
| 173378 | 190815 | DPW Maintained 1 | Juniperus chinensis :: Juniper 113 | 390x Hampshire St | 2 | Median : Cutout | Tree | DPW 1 | 11 | Width 5ft | 6010042.68497 | 2106527.82648 | 37.7646905631515 | -122.408459468238 | (37.7646905631515, -122.408459468238) | 8 | 4 | 8 | 28853 | 19 | |||
| 97425 | 129360 | DPW Maintained 1 | Juniperus chinensis :: Juniper 113 | 555 California St | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 4ft | 6011669.48476 | 2116684.16602 | 37.7926684882083 | -122.40354738383 | (37.7926684882083, -122.40354738383) | 4 | 1 | 10 | 28854 | 6 | |||
| 146990 | 129361 | DPW Maintained 1 | Juniperus chinensis :: Juniper 113 | 555 California St | 11 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 4ft | 6011684.8742 | 2116686.03693 | 37.7926744848808 | -122.403494267154 | (37.7926744848808, -122.403494267154) | 4 | 1 | 10 | 28854 | 6 | |||
| 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 | |
| 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 | |||
| 14667 | 190808 | DPW Maintained 1 | Juniperus chinensis :: Juniper 113 | 2115 22nd St | 1 | Sidewalk: Curb side : Pot | Tree | Private 2 | 13 | Width 2ft | 6011806.38674 | 2103701.05515 | 37.7570274903299 | -122.402160501522 | (37.7570274903299, -122.402160501522) | 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | ||||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | ||||
| 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 | |||
| 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 | |||||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 96055 | 190801 | DPW Maintained 1 | Juniperus chinensis :: Juniper 113 | 625 Rhode Island St | 1 | : | Tree | Private 2 | 6 | Width 1ft | 6011843.82819 | 2105357.07787 | 37.7615766515602 | -122.402147437048 | (37.7615766515602, -122.402147437048) | 10 | 3 | 8 | 28856 | 29 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 121284 | 103306 | DPW Maintained 1 | Juniperus chinensis :: Juniper 113 | 611 Rhode Island St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | 6011832.19369 | 2105491.00064 | 37.7619437242424 | -122.402197092231 | (37.7619437242424, -122.402197092231) | 10 | 3 | 8 | 28856 | 29 | ||||
| 130173 | 190809 | DPW Maintained 1 | Juniperus chinensis :: Juniper 113 | 2109 22nd St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 3ft | 6011813.75397 | 2103701.31284 | 37.7570286091033 | -122.402135040812 | (37.7570286091033, -122.402135040812) | 10 | 3 | 8 | 28856 | 29 | |||
| 130442 | 32026 | DPW Maintained 1 | Juniperus chinensis :: Juniper 113 | 910 Harrison St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/15/2005 12:00:00 AM | 2 | Permit Number 48084 | 6011942.61594 | 2111635.52885 | 37.7788213676447 | -122.402247211444 | (37.7788213676447, -122.402247211444) | 14 | 2 | 9 | 28856 | 34 | ||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | ||||
| 142093 | 190758 | DPW Maintained 1 | Juniperus chinensis :: Juniper 113 | 971 Kansas St | 1 | Sidewalk: Curb side : Pot | Tree | Private 2 | 8 | Width 5ft | 6011634.85015 | 2103871.82945 | 37.7574868226729 | -122.402765753358 | (37.7574868226729, -122.402765753358) | 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 | |||
| 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 | |||
| 143909 | 190759 | DPW Maintained 1 | Juniperus chinensis :: Juniper 113 | 960 Rhode Island St | 1 | : | Tree | Private 2 | 6 | Width 2ft | 6011851.68946 | 2103937.20655 | 37.7576784385299 | -122.402020427597 | (37.7576784385299, -122.402020427597) | 10 | 3 | 8 | 28856 | 29 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 181324 | 190802 | DPW Maintained 1 | Juniperus chinensis :: Juniper 113 | 625 Rhode Island St | 2 | : | Tree | Private 2 | 10 | Width 1ft | 6011842.77301 | 2105367.13187 | 37.7616041987086 | -122.402151793375 | (37.7616041987086, -122.402151793375) | 10 | 3 | 8 | 28856 | 29 | |||
| 184539 | 190764 | DPW Maintained 1 | Juniperus chinensis :: Juniper 113 | 2131 18th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6011336.13604 | 2105543.46577 | 37.7620600803242 | -122.403916462872 | (37.7620600803242, -122.403916462872) | 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 18222 | 129252 | DPW Maintained 1 | Juniperus chinensis :: Juniper 113 | 1230 Clay St | 8 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | Width 3ft | 6008758.83473 | 2117005.78057 | 37.7933885519791 | -122.413641138835 | (37.7933885519791, -122.413641138835) | 5 | 1 | 10 | 28857 | 21 | |||
| 37354 | 129249 | DPW Maintained 1 | Juniperus chinensis :: Juniper 113 | 1230 Clay St | 5 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | Width 3ft | 6008800.58358 | 2117012.32673 | 37.7934088703826 | -122.413497147472 | (37.7934088703826, -122.413497147472) | 5 | 1 | 10 | 28857 | 21 | |||
| 55339 | 129251 | DPW Maintained 1 | Juniperus chinensis :: Juniper 113 | 1230 Clay St | 7 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | Width 3ft | 6008764.64924 | 2117007.47062 | 37.7933935189451 | -122.41362113973 | (37.7933935189451, -122.41362113973) | 5 | 1 | 10 | 28857 | 21 | |||
| 70891 | 129111 | DPW Maintained 1 | Juniperus chinensis :: Juniper 113 | 1119 Mason St | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 10 | Width 2ft | 6009422.93827 | 2117173.65707 | 37.793886769202 | -122.411355148517 | (37.793886769202, -122.411355148517) | 3 | 1 | 10 | 28857 | 21 | |||
| 72143 | 129356 | DPW Maintained 1 | Juniperus chinensis :: Juniper 113 | 1310 Jones St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | Width 2ft | 6008546.12536 | 2116981.02443 | 37.7933086310424 | -122.414375378615 | (37.7933086310424, -122.414375378615) | 5 | 1 | 10 | 28857 | 21 | |||
| 87597 | 129355 | DPW Maintained 1 | Juniperus chinensis :: Juniper 113 | 1270 Clay St | 5 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | Width 2ft | 6008550.99342 | 2116976.81365 | 37.7932973427363 | -122.414358236662 | (37.7932973427363, -122.414358236662) | 5 | 1 | 10 | 28857 | 21 | |||
| 99763 | 129258 | DPW Maintained 1 | Juniperus chinensis :: Juniper 113 | 1230 Clay St | 14 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | Width 3ft | 6008692.25508 | 2116996.28885 | 37.7933587511439 | -122.413870838295 | (37.7933587511439, -122.413870838295) | 5 | 1 | 10 | 28857 | 21 | |||
| 106729 | 129255 | DPW Maintained 1 | Juniperus chinensis :: Juniper 113 | 1230 Clay St | 11 | Sidewalk: Property side : Yard | Tree | Private 2 | 7 | Width 3ft | 6008722.7354 | 2117000.92757 | 37.7933731996641 | -122.413765702128 | (37.7933731996641, -122.413765702128) | 5 | 1 | 10 | 28857 | 21 | |||
| 109845 | 129256 | DPW Maintained 1 | Juniperus chinensis :: Juniper 113 | 1230 Clay St | 12 | Sidewalk: Property side : Yard | Tree | Private 2 | 7 | Width 3ft | 6008702.68791 | 2116997.72001 | 37.7933632666622 | -122.413834841121 | (37.7933632666622, -122.413834841121) | 5 | 1 | 10 | 28857 | 21 | |||
| 130929 | 129261 | DPW Maintained 1 | Juniperus chinensis :: Juniper 113 | 1310 Jones St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | Width 2ft | 6008539.52794 | 2117021.77761 | 37.7934201586544 | -122.414401091142 | (37.7934201586544, -122.414401091142) | 5 | 1 | 10 | 28857 | 21 | |||
| 145319 | 129257 | DPW Maintained 1 | Juniperus chinensis :: Juniper 113 | 1230 Clay St | 13 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | Width 3ft | 6008696.73194 | 2116997.18381 | 37.7933614599048 | -122.413855411325 | (37.7933614599048, -122.413855411325) | 5 | 1 | 10 | 28857 | 21 | |||
| 150062 | 129259 | DPW Maintained 1 | Juniperus chinensis :: Juniper 113 | 1230 Clay St | 15 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 3ft | 6008689.11536 | 2116996.18865 | 37.7933582996916 | -122.413881694895 | (37.7933582996916, -122.413881694895) | 5 | 1 | 10 | 28857 | 21 | |||
| 150084 | 129260 | DPW Maintained 1 | Juniperus chinensis :: Juniper 113 | 1230 Clay St | 16 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 3ft | 6008685.62861 | 2116995.27312 | 37.7933555900526 | -122.413893694545 | (37.7933555900526, -122.413893694545) | 5 | 1 | 10 | 28857 | 21 | |||
| 156783 | 129250 | DPW Maintained 1 | Juniperus chinensis :: Juniper 113 | 1230 Clay St | 6 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | Width 3ft | 6008770.61192 | 2117008.33521 | 37.7933962277169 | -122.413600569531 | (37.7933962277169, -122.413600569531) | 5 | 1 | 10 | 28857 | 21 | |||
| 161538 | 129253 | DPW Maintained 1 | Juniperus chinensis :: Juniper 113 | 1230 Clay St | 9 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | Width 3ft | 6008753.35741 | 2117004.41248 | 37.7933844879676 | -122.413659994014 | (37.7933844879676, -122.413659994014) | 5 | 1 | 10 | 28857 | 21 | |||
| 163998 | 129262 | DPW Maintained 1 | Juniperus chinensis :: Juniper 113 | 1330 Jones St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 2ft | 6008525.9218 | 2117107.40359 | 37.7936545022131 | -122.414454231203 | (37.7936545022131, -122.414454231203) | 5 | 1 | 10 | 28857 | 21 | |||
| 164416 | 129245 | DPW Maintained 1 | Juniperus chinensis :: Juniper 113 | 1230 Clay St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | Width 3ft | 6008845.28336 | 2117017.82608 | 37.7934264800057 | -122.413342871494 | (37.7934264800057, -122.413342871494) | 5 | 1 | 10 | 28857 | 21 |
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) );