trees
302 rows where qSpecies_id = 167 sorted by qAddress
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
45196 | 124234 | DPW Maintained 1 | Prunus blireiana :: Flowering Plum 167 | 1 Paramount Ter | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 2ft | 5996623.51945 | 2111013.40479 | 37.7762461678144 | -122.455196729351 | (37.7762461678144, -122.455196729351) | 11 | 6 | 2 | 54 | 16 | |||
50258 | 124235 | DPW Maintained 1 | Prunus blireiana :: Flowering Plum 167 | 1 Paramount Ter | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 2ft | 5996597.66018 | 2111009.83191 | 37.7762348739685 | -122.455285924869 | (37.7762348739685, -122.455285924869) | 11 | 6 | 2 | 54 | 16 | |||
53759 | 124233 | DPW Maintained 1 | Prunus blireiana :: Flowering Plum 167 | 1 Paramount Ter | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 2ft | 5996645.22941 | 2111016.06725 | 37.7762547237702 | -122.455121821521 | (37.7762547237702, -122.455121821521) | 11 | 6 | 2 | 54 | 16 | |||
27952 | 117633 | DPW Maintained 1 | Prunus blireiana :: Flowering Plum 167 | 100 Locust St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/05/2018 12:00:00 AM | 3 | 3x3 | 5997552.92531 | 2115962.18049 | 37.7898874813666 | -122.452338860365 | (37.7898874813666, -122.452338860365) | 11 | 6 | 1 | 54 | 31 | ||
122693 | 136032 | DPW Maintained 1 | Prunus blireiana :: Flowering Plum 167 | 100 Locust St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 5997540.73441 | 2116039.76442 | 37.7900998077197 | -122.452386640442 | (37.7900998077197, -122.452386640442) | 11 | 6 | 1 | 54 | 31 | |||
158692 | 117634 | DPW Maintained 1 | Prunus blireiana :: Flowering Plum 167 | 100 Locust St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/05/2018 12:00:00 AM | 3 | 3x3 | 5997551.04889 | 2115977.76508 | 37.7899301649938 | -122.452346477623 | (37.7899301649938, -122.452346477623) | 11 | 6 | 1 | 54 | 31 | ||
182253 | 117637 | DPW Maintained 1 | Prunus blireiana :: Flowering Plum 167 | 100 Locust St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 3x3 | 5997541.40632 | 2116024.00549 | 37.7900565763988 | -122.452383178041 | (37.7900565763988, -122.452383178041) | 11 | 6 | 1 | 54 | 31 | |||
2582 | 19774 | DPW Maintained 1 | Prunus blireiana :: Flowering Plum 167 | 100 STAIRWAY17 | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 20ST | |||||||||||||
1517 | 19783 | DPW Maintained 1 | Prunus blireiana :: Flowering Plum 167 | 100 STAIRWAY19 | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 50ST | |||||||||||||
16360 | 19788 | DPW Maintained 1 | Prunus blireiana :: Flowering Plum 167 | 100 STAIRWAY19 | 10 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 50ST | |||||||||||||
18770 | 19796 | DPW Maintained 1 | Prunus blireiana :: Flowering Plum 167 | 100 STAIRWAY21 | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3 | 40ST | |||||||||||||
10775 | 19839 | DPW Maintained 1 | Prunus blireiana :: Flowering Plum 167 | 100 STAIRWAY25 | 23 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 60X | |||||||||||||
3812 | 19927 | DPW Maintained 1 | Prunus blireiana :: Flowering Plum 167 | 100 STAIRWAY37 | 7 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3 | 20ST | |||||||||||||
3853 | 19924 | DPW Maintained 1 | Prunus blireiana :: Flowering Plum 167 | 100 STAIRWAY37 | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3 | 20ST | |||||||||||||
6216 | 19931 | DPW Maintained 1 | Prunus blireiana :: Flowering Plum 167 | 100 STAIRWAY37 | 11 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3 | 20ST | |||||||||||||
7721 | 19582 | DPW Maintained 1 | Prunus blireiana :: Flowering Plum 167 | 100 STAIRWAY4 | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 60 | |||||||||||||
8077 | 19587 | DPW Maintained 1 | Prunus blireiana :: Flowering Plum 167 | 100 STAIRWAY4 | 10 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 60 | |||||||||||||
13835 | 20004 | DPW Maintained 1 | Prunus blireiana :: Flowering Plum 167 | 100 STAIRWAY46 | 24 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3 | 2 | |||||||||||||
10276 | 20049 | DPW Maintained 1 | Prunus blireiana :: Flowering Plum 167 | 100 STAIRWAY52 | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 10 | |||||||||||||
19416 | 20072 | DPW Maintained 1 | Prunus blireiana :: Flowering Plum 167 | 100 STAIRWAY55 | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 45X | |||||||||||||
26525 | 32263 | DPW Maintained 1 | Prunus blireiana :: Flowering Plum 167 | 1027 Diamond St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/05/1997 12:00:00 AM | 6 | Permit Number 38508 | 6001961.80669 | 2101044.74865 | 37.7491794962361 | -122.436016672442 | (37.7491794962361, -122.436016672442) | 2 | 4 | 5 | 28862 | 22 | ||
153565 | 65660 | Permitted Site 7 | Prunus blireiana :: Flowering Plum 167 | 106 Melrose Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/12/1990 12:00:00 AM | Permit Number 28580 | 5999382.81726917 | 2095526.44780449 | 37.7338807102318 | -122.444538269179 | (37.7338807102318, -122.444538269179) | 9 | 7 | 4 | 59 | 40 | ||
26241 | 122126 | DPW Maintained 1 | Prunus blireiana :: Flowering Plum 167 | 109 16th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 5990812.19137 | 2114688.82235 | 37.7860027216168 | -122.47556793196 | (37.7860027216168, -122.47556793196) | 11 | 6 | 2 | 54 | 26 | |||
46275 | 122127 | DPW Maintained 1 | Prunus blireiana :: Flowering Plum 167 | 109 16th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 5990810.49016 | 2114703.81512 | 37.7860437889569 | -122.475574912767 | (37.7860437889569, -122.475574912767) | 11 | 6 | 2 | 54 | 26 | |||
96337 | 122124 | DPW Maintained 1 | Prunus blireiana :: Flowering Plum 167 | 109 16th Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 5990813.29617 | 2114656.20657 | 37.7859132318364 | -122.475561727296 | (37.7859132318364, -122.475561727296) | 11 | 6 | 2 | 54 | 26 | |||
123954 | 122125 | DPW Maintained 1 | Prunus blireiana :: Flowering Plum 167 | 109 16th Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 5990812.11385 | 2114674.53706 | 37.7859634937051 | -122.475567156694 | (37.7859634937051, -122.475567156694) | 11 | 6 | 2 | 54 | 26 | |||
142615 | 122123 | DPW Maintained 1 | Prunus blireiana :: Flowering Plum 167 | 109 16th Ave | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 5990814.40287 | 2114634.30613 | 37.7858531634971 | -122.475556298764 | (37.7858531634971, -122.475556298764) | 11 | 6 | 2 | 54 | 26 | |||
1951 | 196519 | DPW Maintained 1 | Prunus blireiana :: Flowering Plum 167 | 1100 Pennsylvania Ave | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 1 | 6014493.82827 | 2101802.94838 | 37.7519653333515 | -122.392733453506 | (37.7519653333515, -122.392733453506) | 10 | 3 | 8 | 28856 | 1 | ||||
27193 | 196521 | DPW Maintained 1 | Prunus blireiana :: Flowering Plum 167 | 1100 Pennsylvania Ave | 7 | Sidewalk: Curb side : Yard | Tree | Private 2 | 1 | 6014496.49753 | 2101766.20536 | 37.7518645930792 | -122.392721652585 | (37.7518645930792, -122.392721652585) | 10 | 3 | 8 | 28856 | 1 | ||||
54150 | 196518 | DPW Maintained 1 | Prunus blireiana :: Flowering Plum 167 | 1100 Pennsylvania Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 1 | 6014492.91389 | 2101810.69981 | 37.7519865663454 | -122.392737157804 | (37.7519865663454, -122.392737157804) | 10 | 3 | 8 | 28856 | 1 | ||||
102825 | 196517 | DPW Maintained 1 | Prunus blireiana :: Flowering Plum 167 | 1100 Pennsylvania Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 1 | 6014492.80276 | 2101818.43499 | 37.7520077993331 | -122.392738083189 | (37.7520077993331, -122.392738083189) | 10 | 3 | 8 | 28856 | 1 | ||||
128132 | 196520 | DPW Maintained 1 | Prunus blireiana :: Flowering Plum 167 | 1100 Pennsylvania Ave | 6 | Sidewalk: Curb side : Yard | Tree | Private 2 | 1 | 6014495.9358 | 2101776.59314 | 37.7518930845169 | -122.392724321763 | (37.7518930845169, -122.392724321763) | 10 | 3 | 8 | 28856 | 1 | ||||
96789 | 179167 | DPW Maintained 1 | Prunus blireiana :: Flowering Plum 167 | 111 Brunswick St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 1ft | 6000723.35107 | 2087387.59269 | 37.7116096657128 | -122.439320465973 | (37.7116096657128, -122.439320465973) | 9 | 7 | 6 | 28861 | 5 | |||
67328 | 196531 | DPW Maintained 1 | Prunus blireiana :: Flowering Plum 167 | 1150 19th St | 6 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | Width 4ft | 6014106.81933 | 2105287.87473 | 37.7615126872711 | -122.394315771076 | (37.7615126872711, -122.394315771076) | 10 | 3 | 8 | 28856 | 29 | |||
109538 | 196529 | DPW Maintained 1 | Prunus blireiana :: Flowering Plum 167 | 1150 19th St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | Width 4ft | 6014166.99848 | 2105290.36806 | 37.7615228783907 | -122.394107809149 | (37.7615228783907, -122.394107809149) | 10 | 3 | 8 | 28856 | 29 | |||
183391 | 196530 | DPW Maintained 1 | Prunus blireiana :: Flowering Plum 167 | 1150 19th St | 5 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | Width 4ft | 6014129.09689 | 2105289.45573 | 37.7615182666641 | -122.394238832278 | (37.7615182666641, -122.394238832278) | 10 | 3 | 8 | 28856 | 29 | |||
28226 | 46608 | Permitted Site 7 | Prunus blireiana :: Flowering Plum 167 | 1166 Noriega St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/10/2002 12:00:00 AM | Permit Number 44731 | 5990419.11281219 | 2103161.32215556 | 37.7543285475592 | -122.476085621892 | (37.7543285475592, -122.476085621892) | 1 | 8 | 4 | 56 | 12 | |||
110536 | 46606 | Permitted Site 7 | Prunus blireiana :: Flowering Plum 167 | 1166 Noriega St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/10/2002 12:00:00 AM | Permit Number 44731 | 5990419.11281219 | 2103161.32215556 | 37.7543285475592 | -122.476085621892 | (37.7543285475592, -122.476085621892) | 1 | 8 | 4 | 56 | 12 | |||
113099 | 46607 | Permitted Site 7 | Prunus blireiana :: Flowering Plum 167 | 1166 Noriega St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/10/2002 12:00:00 AM | Permit Number 44731 | 5990419.11281219 | 2103161.32215556 | 37.7543285475592 | -122.476085621892 | (37.7543285475592, -122.476085621892) | 1 | 8 | 4 | 56 | 12 | |||
121892 | 46605 | Permitted Site 7 | Prunus blireiana :: Flowering Plum 167 | 1166 Noriega St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/10/2002 12:00:00 AM | Permit Number 44731 | 5990419.11281219 | 2103161.32215556 | 37.7543285475592 | -122.476085621892 | (37.7543285475592, -122.476085621892) | 1 | 8 | 4 | 56 | 12 | |||
15489 | 67578 | DPW Maintained 1 | Prunus blireiana :: Flowering Plum 167 | 118 Connecticut St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/05/1992 12:00:00 AM | 6 | Permit Number 31142 | 6013124.0144 | 2106441.06609 | 37.7646244162146 | -122.397795803828 | (37.7646244162146, -122.397795803828) | 14 | 3 | 8 | 28856 | 29 | |
171935 | 60803 | Permitted Site 7 | Prunus blireiana :: Flowering Plum 167 | 120 Ewing Ter | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/21/1983 12:00:00 AM | Permit Number 20479 | 5998693.79228565 | 2112443.24923504 | 37.7802907109033 | -122.448138097032 | (37.7802907109033, -122.448138097032) | 15 | 6 | 2 | 54 | 16 | ||
33119 | 213714 | DPW Maintained 1 | Prunus blireiana :: Flowering Plum 167 | 125 Judson Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 4ft | 5999173.83796 | 2093468.34199 | 37.7282177076567 | -122.445112858974 | (37.7282177076567, -122.445112858974) | 9 | 7 | 4 | 28861 | 40 | |||
126896 | 213713 | DPW Maintained 1 | Prunus blireiana :: Flowering Plum 167 | 125 Judson Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 4ft | 5999159.40748 | 2093468.82637 | 37.7282182139859 | -122.445162780338 | (37.7282182139859, -122.445162780338) | 9 | 7 | 4 | 28861 | 40 | |||
134167 | 213715 | DPW Maintained 1 | Prunus blireiana :: Flowering Plum 167 | 125 Judson Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 4ft | 5999200.66697 | 2093467.5999 | 37.728217201345 | -122.445020057043 | (37.728217201345, -122.445020057043) | 9 | 7 | 4 | 28861 | 40 | |||
34949 | 238549 | DPW Maintained 1 | Prunus blireiana :: Flowering Plum 167 | 125 Mullen Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6009831.14885 | 2099860.0052 | 37.7463703703058 | -122.408720684427 | (37.7463703703058, -122.408720684427) | 2 | 7 | 7 | 28859 | 2 | |||
191968 | 60785 | Permitted Site 7 | Prunus blireiana :: Flowering Plum 167 | 126 Ewing Ter | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/14/1983 12:00:00 AM | Permit Number 20455 | 5998690.69552191 | 2112465.2130408 | 37.7803508407843 | -122.448150392076 | (37.7803508407843, -122.448150392076) | 15 | 6 | 2 | 54 | 16 | ||
26232 | 54232 | Permitted Site 7 | Prunus blireiana :: Flowering Plum 167 | 1265 03rd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/18/1983 12:00:00 AM | Permit Number 9972 | 5995143.28929522 | 2106927.58636529 | 37.7649425453263 | -122.460021156774 | (37.7649425453263, -122.460021156774) | 15 | 5 | 11 | 56 | 12 | ||
123939 | 123558 | DPW Maintained 1 | Prunus blireiana :: Flowering Plum 167 | 127 05th Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 7ft | 5994253.98001 | 2114683.08774 | 37.7861858965782 | -122.463659952565 | (37.7861858965782, -122.463659952565) | 11 | 6 | 1 | 54 | 11 | |||
48565 | 60083 | DPW Maintained 1 | Prunus blireiana :: Flowering Plum 167 | 1270 23rd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/16/1982 12:00:00 AM | 3 | Permit Number 19584 | 5988965.7237 | 2106688.207 | 37.7639280389731 | -122.481370017438 | (37.7639280389731, -122.481370017438) | 1 | 8 | 3 | 56 | 35 | |
134630 | 181654 | DPW Maintained 1 | Prunus blireiana :: Flowering Plum 167 | 1270 31st Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 0ft | 5986485.9791 | 2106605.5895 | 37.7635567077637 | -122.489940517963 | (37.7635567077637, -122.489940517963) | 1 | 8 | 3 | 56 | 35 | |||
186986 | 59836 | Permitted Site 7 | Prunus blireiana :: Flowering Plum 167 | 1271 03rd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/18/1983 12:00:00 AM | Permit Number 19290 | 5995144.61588097 | 2106889.02596139 | 37.7648367447545 | -122.46001377482 | (37.7648367447545, -122.46001377482) | 15 | 5 | 11 | 56 | 12 | ||
16791 | 71817 | DPW Maintained 1 | Prunus blireiana :: Flowering Plum 167 | 1271 23rd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 4 | 5988923.2164 | 2106695.866 | 37.7639465970002 | -122.481517596706 | (37.7639465970002, -122.481517596706) | 1 | 8 | 3 | 56 | 35 | |||
181274 | 60074 | DPW Maintained 1 | Prunus blireiana :: Flowering Plum 167 | 1275 23rd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/16/1982 12:00:00 AM | 4 | Permit Number 19575 | 5988921.6846 | 2106672.1231 | 37.7638813163914 | -122.481521155686 | (37.7638813163914, -122.481521155686) | 1 | 8 | 3 | 56 | 35 | |
97602 | 63680 | Permitted Site 7 | Prunus blireiana :: Flowering Plum 167 | 1290 Sanchez St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/03/1987 12:00:00 AM | Permit Number 24335 | 6003854.79358898 | 2100760.12330994 | 37.7485053408812 | -122.42945040251 | (37.7485053408812, -122.42945040251) | 2 | 4 | 5 | 28862 | 22 | ||
73350 | 67526 | Permitted Site 7 | Prunus blireiana :: Flowering Plum 167 | 1301 19th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/22/1992 12:00:00 AM | Permit Number 31064 | 6013774.38377619 | 2105211.91246173 | 37.761285626876 | -122.395460215282 | (37.761285626876, -122.395460215282) | 10 | 3 | 8 | 28856 | 29 | ||
76964 | 196533 | DPW Maintained 1 | Prunus blireiana :: Flowering Plum 167 | 1301 19th St | 1 | : | Tree | Private 2 | 5 | Width 4ft | 6013698.90567 | 2105212.75779 | 37.7612837495574 | -122.395721323302 | (37.7612837495574, -122.395721323302) | 10 | 3 | 8 | 28856 | 29 | |||
38211 | 123559 | DPW Maintained 1 | Prunus blireiana :: Flowering Plum 167 | 131 05th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 7ft | 5994253.7419 | 2114658.86132 | 37.7861193636966 | -122.463659017412 | (37.7861193636966, -122.463659017412) | 11 | 6 | 1 | 54 | 11 | |||
97673 | 123560 | DPW Maintained 1 | Prunus blireiana :: Flowering Plum 167 | 131 05th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 7ft | 5994254.42812 | 2114646.46204 | 37.7860853581858 | -122.463655743051 | (37.7860853581858, -122.463655743051) | 11 | 6 | 1 | 54 | 11 | |||
85134 | 123200 | DPW Maintained 1 | Prunus blireiana :: Flowering Plum 167 | 1310 09th Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | Width 9ft | 5993097.33077 | 2112035.35395 | 37.7788492259481 | -122.467469010607 | (37.7788492259481, -122.467469010607) | 11 | 6 | 2 | 54 | 11 | |||
100481 | 196532 | DPW Maintained 1 | Prunus blireiana :: Flowering Plum 167 | 1317 19th St | 1 | : | Tree | Private 2 | 5 | Width 6ft | 6013654.12142 | 2105210.03972 | 37.761273794973 | -122.395876023757 | (37.761273794973, -122.395876023757) | 10 | 3 | 8 | 28856 | 29 | |||
174135 | 196526 | DPW Maintained 1 | Prunus blireiana :: Flowering Plum 167 | 1327 Rhode Island St | 1 | : | Tree | Private 2 | 7 | Width 3ft | 6012008.29844 | 2102189.51462 | 37.752888399289 | -122.401355988709 | (37.752888399289, -122.401355988709) | 10 | 3 | 8 | 28856 | 29 | |||
98612 | 213708 | DPW Maintained 1 | Prunus blireiana :: Flowering Plum 167 | 1330 Kirkham St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 5990694.19648 | 2105216.19153 | 37.7599866214079 | -122.475284333917 | (37.7599866214079, -122.475284333917) | 1 | 8 | 4 | 56 | 12 | |||
101584 | 213709 | DPW Maintained 1 | Prunus blireiana :: Flowering Plum 167 | 1330 Kirkham St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 5990679.02857 | 2105217.07181 | 37.7599881592429 | -122.475336856123 | (37.7599881592429, -122.475336856123) | 1 | 8 | 4 | 56 | 12 | |||
192207 | 84853 | DPW Maintained 1 | Prunus blireiana :: Flowering Plum 167 | 1338 Anza St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/04/2007 12:00:00 AM | 6 | Permit No. 49311 | 5994481.6608 | 2112148.58575 | 37.779239954215 | -122.462688317698 | (37.779239954215, -122.462688317698) | 11 | 6 | 2 | 54 | 11 | ||
143285 | 60381 | Permitted Site 7 | Prunus blireiana :: Flowering Plum 167 | 1350 Palou Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/06/1982 12:00:00 AM | Permit Number 19961 | 6016233.53392592 | 2094275.31577425 | 37.7313924611256 | -122.386192505476 | (37.7313924611256, -122.386192505476) | 10 | 3 | 8 | 58 | 1 | ||
161372 | 83531 | Permitted Site 7 | Prunus blireiana :: Flowering Plum 167 | 1355x COLE ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/16/2008 12:00:00 AM | 3x3 | Permit Number 50899 | 5998199 | 2105694 | 37.7617307020229 | -122.449363384978 | (37.7617307020229, -122.449363384978) | 15 | 5 | 11 | 29492 | 9 | ||
37321 | 238556 | DPW Maintained 1 | Prunus blireiana :: Flowering Plum 167 | 1374 Sanchez St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 2ft | 6003884.87618 | 2100253.42684 | 37.7471157733724 | -122.429310250782 | (37.7471157733724, -122.429310250782) | 2 | 7 | 5 | 63 | 22 | |||
104270 | 63655 | Permitted Site 7 | Prunus blireiana :: Flowering Plum 167 | 1374 Sanchez St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/26/1987 12:00:00 AM | Permit Number 24302 | 6003882.00730683 | 2100268.96113166 | 37.747158264512 | -122.429321278666 | (37.747158264512, -122.429321278666) | 2 | 7 | 5 | 63 | 22 | ||
1585 | 34112 | Permitted Site 7 | Prunus blireiana :: Flowering Plum 167 | 1398 Plymouth Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/05/1997 12:00:00 AM | Permit Number 37977 | 5995892.17100072 | 2093289.41859175 | 37.7275385716585 | -122.456444707829 | (37.7275385716585, -122.456444707829) | 9 | 7 | 4 | 28861 | 40 | ||
154377 | 34113 | Permitted Site 7 | Prunus blireiana :: Flowering Plum 167 | 1398 Plymouth Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/05/1997 12:00:00 AM | Permit Number 37977 | 5995892.17100072 | 2093289.41859175 | 37.7275385716585 | -122.456444707829 | (37.7275385716585, -122.456444707829) | 9 | 7 | 4 | 28861 | 40 | ||
138936 | 22856 | DPW Maintained 1 | Prunus blireiana :: Flowering Plum 167 | 140 Turquoise Way | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 20 | 3X3 | 5999949.39722 | 2099144.09084 | 37.7438462152458 | -122.442839126451 | (37.7438462152458, -122.442839126451) | 2 | 7 | 5 | 63 | 7 | |||
45898 | 34127 | Permitted Site 7 | Prunus blireiana :: Flowering Plum 167 | 1401 Plymouth Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/05/1997 12:00:00 AM | Permit Number 37983 | 5995840.26429469 | 2093321.75315516 | 37.7276243745144 | -122.456626485978 | (37.7276243745144, -122.456626485978) | 9 | 7 | 4 | 28861 | 40 | ||
34366 | 51866 | Permitted Site 7 | Prunus blireiana :: Flowering Plum 167 | 141 Alpine Ter | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/15/2005 12:00:00 AM | Permit Number 48086 | 6001731.90100781 | 2108013.17914536 | 37.7683000536682 | -122.43731059058 | (37.7683000536682, -122.43731059058) | 15 | 5 | 5 | 29492 | 3 | |||
47384 | 51865 | Permitted Site 7 | Prunus blireiana :: Flowering Plum 167 | 141 Alpine Ter | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/15/2005 12:00:00 AM | Permit Number 48086 | 6001731.90100781 | 2108013.17914536 | 37.7683000536682 | -122.43731059058 | (37.7683000536682, -122.43731059058) | 15 | 5 | 5 | 29492 | 3 | |||
15806 | 139513 | DPW Maintained 1 | Prunus blireiana :: Flowering Plum 167 | 1422 Fulton St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 0ft | 6000956.086 | 2111077.9238 | 37.7766709396845 | -122.440213858451 | (37.7766709396845, -122.440213858451) | 15 | 5 | 11 | 29492 | 41 | |||
79931 | 60386 | Permitted Site 7 | Prunus blireiana :: Flowering Plum 167 | 1432 Palou Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/06/1982 12:00:00 AM | Permit Number 19966 | 6015791.47503069 | 2094604.97930734 | 37.7322731738529 | -122.387743792201 | (37.7322731738529, -122.387743792201) | 10 | 3 | 8 | 58 | 1 | ||
158240 | 60370 | Permitted Site 7 | Prunus blireiana :: Flowering Plum 167 | 1439 Palou Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/06/1982 12:00:00 AM | Permit Number 19948 | 6015729.73368672 | 2094586.16842125 | 37.7322181026296 | -122.387955935836 | (37.7322181026296, -122.387955935836) | 10 | 3 | 8 | 58 | 1 | ||
23016 | 60906 | Permitted Site 7 | Prunus blireiana :: Flowering Plum 167 | 1443 05th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/18/1983 12:00:00 AM | Permit Number 20696 | 5994564.62076665 | 2105704.92459357 | 37.7615521348608 | -122.461933943385 | (37.7615521348608, -122.461933943385) | 1 | 5 | 11 | 56 | 12 | ||
31945 | 141596 | DPW Maintained 1 | Prunus blireiana :: Flowering Plum 167 | 1457 FULTON ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 0ft | 6000792.6568 | 2111003.6819 | 37.7764577843183 | -122.440773879837 | (37.7764577843183, -122.440773879837) | 15 | 5 | 11 | 29492 | 10 | |||
28698 | 63544 | DPW Maintained 1 | Prunus blireiana :: Flowering Plum 167 | 1457 Fulton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/13/1987 12:00:00 AM | 5 | Permit Number 24160 | 6000753.318 | 2110998.5304 | 37.776441399194 | -122.440909593922 | (37.776441399194, -122.440909593922) | 15 | 5 | 11 | 29492 | 10 | |
181649 | 67772 | Permitted Site 7 | Prunus blireiana :: Flowering Plum 167 | 146 Hermann St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/15/1992 12:00:00 AM | Permit Number 31403 | 6004564.19848572 | 2108804.14815363 | 37.7706324670974 | -122.427570300779 | (37.7706324670974, -122.427570300779) | 7 | 9 | 11 | 28852 | 10 | ||
89930 | 67744 | Permitted Site 7 | Prunus blireiana :: Flowering Plum 167 | 1460 06th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/04/1992 12:00:00 AM | Permit Number 31363 | 5994310.57601305 | 2105578.84704093 | 37.7611913298083 | -122.462803426682 | (37.7611913298083, -122.462803426682) | 1 | 5 | 11 | 56 | 12 | ||
133226 | 46266 | Permitted Site 7 | Prunus blireiana :: Flowering Plum 167 | 1461 Sanchez St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/03/1987 12:00:00 AM | Permit Number 44550 | 6003962.08662823 | 2099767.6187722 | 37.7457862278615 | -122.429008632092 | (37.7457862278615, -122.429008632092) | 2 | 7 | 5 | 63 | 22 | ||
14594 | 238571 | DPW Maintained 1 | Prunus blireiana :: Flowering Plum 167 | 1474 Noe St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6003271.46405 | 2099643.85136 | 37.7454072746301 | -122.431387870873 | (37.7454072746301, -122.431387870873) | 2 | 7 | 5 | 63 | 22 | |||
28650 | 238570 | DPW Maintained 1 | Prunus blireiana :: Flowering Plum 167 | 1474 Noe St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6003271.44835 | 2099657.02659 | 37.745443449856 | -122.431388865507 | (37.745443449856, -122.431388865507) | 2 | 7 | 5 | 63 | 22 | |||
84475 | 64804 | Permitted Site 7 | Prunus blireiana :: Flowering Plum 167 | 1476 Sanchez St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/05/1989 12:00:00 AM | Permit Number 25803 | 6003915.51476447 | 2099673.7745449 | 37.7455259170349 | -122.42916298071 | (37.7455259170349, -122.42916298071) | 2 | 7 | 5 | 63 | 22 | ||
101816 | 63684 | Permitted Site 7 | Prunus blireiana :: Flowering Plum 167 | 1477 Sanchez St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/03/1987 12:00:00 AM | Permit Number 24341 | 6003967.42510642 | 2099676.82682244 | 37.7455372363545 | -122.428983700412 | (37.7455372363545, -122.428983700412) | 2 | 7 | 5 | 63 | 22 | ||
123402 | 63670 | Permitted Site 7 | Prunus blireiana :: Flowering Plum 167 | 1480 Sanchez St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/02/1987 12:00:00 AM | Permit Number 24320 | 6003916.84938378 | 2099651.07656136 | 37.7454636691757 | -122.429156747668 | (37.7454636691757, -122.429156747668) | 2 | 7 | 5 | 63 | 22 | ||
185325 | 238554 | DPW Maintained 1 | Prunus blireiana :: Flowering Plum 167 | 1480 Sanchez St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 2ft | 6003916.2981 | 2099645.9415 | 37.7454495382776 | -122.429158287842 | (37.7454495382776, -122.429158287842) | 2 | 7 | 5 | 63 | 22 | |||
92552 | 63685 | Permitted Site 7 | Prunus blireiana :: Flowering Plum 167 | 1488 Sanchez St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/03/1987 12:00:00 AM | Permit Number 24342 | 6003919.51862242 | 2099605.68059427 | 37.7453391734545 | -122.429144281616 | (37.7453391734545, -122.429144281616) | 2 | 7 | 5 | 63 | 22 | ||
140030 | 60907 | Permitted Site 7 | Prunus blireiana :: Flowering Plum 167 | 1491 05th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/18/1983 12:00:00 AM | Permit Number 20697 | 5994575.4199228 | 2105392.22311625 | 37.7606941592004 | -122.461873918454 | (37.7606941592004, -122.461873918454) | 1 | 5 | 11 | 56 | 12 | ||
135358 | 182279 | DPW Maintained 1 | Prunus blireiana :: Flowering Plum 167 | 1496 Kirkham St | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 2 | Width 0ft | 5984984.0246 | 2105052.8568 | 37.7592055205034 | -122.495020725609 | (37.7592055205034, -122.495020725609) | 1 | 8 | 3 | 56 | 35 | |||
93316 | 62805 | DPW Maintained 1 | Prunus blireiana :: Flowering Plum 167 | 15 Chicago Way | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/25/1991 12:00:00 AM | 5 | Permit Number 29952 | 6003841.76502 | 2086802.53618 | 37.7101801951336 | -122.428500718859 | (37.7101801951336, -122.428500718859) | 9 | 7 | 6 | 309 | 5 | ||
131218 | 187550 | DPW Maintained 1 | Prunus blireiana :: Flowering Plum 167 | 15 Chicago Way | 2 | : | Tree | Private 2 | 6 | Width 3ft | 6003854.31887 | 2086791.04585 | 37.7101493555763 | -122.428456511776 | (37.7101493555763, -122.428456511776) | 9 | 7 | 6 | 309 | 5 | |||
39527 | 139116 | Undocumented 4 | Prunus blireiana :: Flowering Plum 167 | 1501 LAGUNA ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Width 0ft | 6004490.8408 | 2114272.6601 | 37.7856435047825 | -122.428213836711 | (37.7856435047825, -122.428213836711) | 13 | 9 | 11 | 29490 | 13 | ||||
153765 | 139117 | DPW Maintained 1 | Prunus blireiana :: Flowering Plum 167 | 1501 LAGUNA ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 0ft | 6004494.7186 | 2114242.7456 | 37.785561586454 | -122.428198287945 | (37.785561586454, -122.428198287945) | 13 | 9 | 11 | 29490 | 13 | |||
154216 | 139122 | DPW Maintained 1 | Prunus blireiana :: Flowering Plum 167 | 1501 LAGUNA ST | 7 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 4 | Width 0ft | 6004515.7696 | 2114102.0367 | 37.7851764260276 | -122.428115426505 | (37.7851764260276, -122.428115426505) | 13 | 9 | 11 | 29490 | 13 | |||
154831 | 12714 | DPW Maintained 1 | Prunus blireiana :: Flowering Plum 167 | 1501 Lake St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 20 | 3X3 | 5990789.16326 | 2114722.34 | 37.7860934167472 | -122.475650050524 | (37.7860934167472, -122.475650050524) | 11 | 6 | 2 | 54 | 26 | |||
53680 | 138762 | DPW Maintained 1 | Prunus blireiana :: Flowering Plum 167 | 1508 Baker St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/12/2018 12:00:00 AM | 3 | Width 0ft | Permit Number 782176 | 6000175.6546 | 2114135.1395 | 37.7850208059477 | -122.443133211033 | (37.7850208059477, -122.443133211033) | 15 | 6 | 1 | 29490 | 27 |
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) );