trees
368 rows where qSpecies_id = 144
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
54506 | 223912 | DPW Maintained 1 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 144 | 69 Elsie St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6007426.45015 | 2098992.55773 | 37.7438535743744 | -122.416974423853 | (37.7438535743744, -122.416974423853) | 2 | 7 | 7 | 28859 | 2 | |||
54577 | 191045 | DPW Maintained 1 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 144 | 900x Carolina St | 40 | Median : Yard | Tree | DPW 1 | 7 | 6012497.15794 | 2103097.51934 | 37.7554088455429 | -122.399729160991 | (37.7554088455429, -122.399729160991) | 10 | 3 | 8 | 28856 | 29 | ||||
55014 | 207485 | DPW Maintained 1 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 144 | 115 Judson Ave | 5 | Sidewalk: Property side : Yard | Tree | Private 2 | 8 | Width 8ft | 5999342.30815 | 2093460.30056 | 37.7282052421686 | -122.444529875249 | (37.7282052421686, -122.444529875249) | 9 | 7 | 4 | 28861 | 40 | |||
55523 | 124159 | DPW Maintained 1 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 144 | 970 Anza St | 5 | Sidewalk: Property side : Yard | Tree | Private 2 | 8 | Width 4ft | 5995776.57441 | 2112223.28537 | 37.7795195518878 | -122.458214112906 | (37.7795195518878, -122.458214112906) | 11 | 6 | 2 | 54 | 16 | |||
57488 | 207427 | DPW Maintained 1 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 144 | 1466 15th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 5991507.09847 | 2105443.15069 | 37.7606568753312 | -122.472489472137 | (37.7606568753312, -122.472489472137) | 1 | 8 | 4 | 56 | 12 | |||
57623 | 207431 | DPW Maintained 1 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 144 | 1550 15th Ave | 4 | Sidewalk: Curb side : Yard | Tree | Private 2 | 5 | 5991561.23107 | 2104931.23818 | 37.7592544320617 | -122.472264936581 | (37.7592544320617, -122.472264936581) | 1 | 8 | 4 | 56 | 12 | ||||
57902 | 223919 | DPW Maintained 1 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 144 | 293 Lexington St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6006519.52162 | 2104466.46125 | 37.7588326032685 | -122.420498850765 | (37.7588326032685, -122.420498850765) | 2 | 4 | 7 | 28859 | 19 | |||
58422 | 115364 | Undocumented 4 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 144 | 69 ELSIE ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3x3 | 6007449 | 2098988 | 37.743842328307 | -122.416896128684 | (37.743842328307, -122.416896128684) | 2 | 7 | 7 | 28859 | 2 | |||
58887 | 222517 | DPW Maintained 1 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 144 | 714 Duncan St | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 14 | Width 4ft | 6001862.10862 | 2099746.95983 | 37.7456104108039 | -122.436268564438 | (37.7456104108039, -122.436268564438) | 2 | 7 | 5 | 63 | 22 | |||
60417 | 191042 | DPW Maintained 1 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 144 | 1301 Minnesota St | 37 | Front Yard : Yard | Tree | Private 2 | 6 | 6015379.59979 | 2102513.14016 | 37.7539645262576 | -122.389719900867 | (37.7539645262576, -122.389719900867) | 10 | 3 | 8 | 28856 | 29 | ||||
60811 | 247865 | DPW Maintained 1 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 144 | 400 Mayflower St | 1 | Side Yard : Yard | Tree | Private 2 | 1 | 6009511.40819 | 2098411.13384 | 37.742374173428 | -122.409724064332 | (37.742374173428, -122.409724064332) | 10 | 7 | 7 | 28859 | 2 | ||||
61560 | 103905 | DPW Maintained 1 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 144 | 6025 03rd St | 6 | Sidewalk: Property side : Yard | Tree | Private 2 | 06/19/2013 12:00:00 AM | Permit Number 770276 | 6013653.2 | 2091451 | 37.7234943066524 | -122.394915533675 | (37.7234943066524, -122.394915533675) | 10 | 3 | 8 | 58 | 1 | |||
61613 | 207451 | DPW Maintained 1 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 144 | 135 Marietta Dr | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 7 | Width 10ft | 5998537.14886 | 2098009.22031 | 37.74064952016 | -122.447640652719 | (37.74064952016, -122.447640652719) | 9 | 7 | 4 | 59 | 40 | |||
61632 | 191037 | DPW Maintained 1 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 144 | 2255 Mariposa St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6010742.72974 | 2105979.64591 | 37.7632245620984 | -122.405999565232 | (37.7632245620984, -122.405999565232) | 8 | 4 | 8 | 28859 | 19 | |||
62605 | 176196 | DPW Maintained 1 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 144 | 500 Geneva Ave | 20 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | Width 5ft | 5998970.24187 | 2090551.75587 | 37.7201978153451 | -122.445607049032 | (37.7201978153451, -122.445607049032) | 9 | 7 | 6 | 28861 | 25 | |||
62716 | 176212 | DPW Maintained 1 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 144 | 643 Burrows St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6009383.55707 | 2092917.45205 | 37.7272825386525 | -122.409778442743 | (37.7272825386525, -122.409778442743) | 10 | 3 | 7 | 309 | 28 | |||
63466 | 207478 | DPW Maintained 1 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 144 | 549 Flood Ave | 7 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 10ft | 5997163.33701 | 2094077.03588 | 37.7297740771139 | -122.452107103267 | (37.7297740771139, -122.452107103267) | 9 | 7 | 4 | 28861 | 40 | |||
63641 | 207475 | DPW Maintained 1 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 144 | 549 Flood Ave | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 10ft | 5997163.82346 | 2094082.98352 | 37.7297904357818 | -122.452105850522 | (37.7297904357818, -122.452105850522) | 9 | 7 | 4 | 28861 | 40 | |||
63985 | 122196 | DPW Maintained 1 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 144 | 131 14th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 5991469.44063 | 2114555.28767 | 37.7856741515485 | -122.473284307608 | (37.7856741515485, -122.473284307608) | 11 | 6 | 2 | 54 | 26 | |||
64574 | 207501 | DPW Maintained 1 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 144 | 421 Hazelwood Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 5995678.51493 | 2095805.70725 | 37.7344354233544 | -122.457365278307 | (37.7344354233544, -122.457365278307) | 9 | 7 | 4 | 59 | 40 | |||
65483 | 222536 | DPW Maintained 1 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 144 | 1626 Diamond St | 9 | Sidewalk: Curb side : Pot | Tree | Private 2 | 2 | Width 8ft | 6002000.60418 | 2099254.59883 | 37.7442663713055 | -122.435754448119 | (37.7442663713055, -122.435754448119) | 2 | 7 | 5 | 63 | 22 | |||
65808 | 23596 | DPW Maintained 1 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 144 | 200X Vasquez Ave | 7 | Median : Cutout | Tree | DPW 1 | 12 | 40 | 5994426.954874 | 2098963.765109 | 37.7430347013579 | -122.461921227095 | (37.7430347013579, -122.461921227095) | 1 | 8 | 4 | 59 | 40 | |||
66067 | 117664 | DPW Maintained 1 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 144 | 4739 Anza St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 2ft | 5983878.87513 | 2111710.17251 | 37.7774198517188 | -122.499334755526 | (37.7774198517188, -122.499334755526) | 11 | 6 | 2 | 55 | 26 | |||
66250 | 103906 | DPW Maintained 1 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 144 | 6025 03rd St | 7 | Sidewalk: Property side : Yard | Tree | Private 2 | 06/19/2013 12:00:00 AM | Permit Number 770276 | 6013653.2 | 2091451 | 37.7234943066524 | -122.394915533675 | (37.7234943066524, -122.394915533675) | 10 | 3 | 8 | 58 | 1 | |||
66478 | 223884 | DPW Maintained 1 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 144 | 720 South Van Ness Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 6007476.34391 | 2105418.19682 | 37.7614997244664 | -122.417257150023 | (37.7614997244664, -122.417257150023) | 2 | 4 | 7 | 28859 | 19 | |||
67635 | 207459 | DPW Maintained 1 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 144 | 305 Foerster St | 2 | Sidewalk: Curb side : Pot | Tree | Private 2 | 2 | Width 2ft | 5998080.33255 | 2094441.7162 | 37.7308278882933 | -122.448963220871 | (37.7308278882933, -122.448963220871) | 9 | 7 | 4 | 59 | 40 | |||
68566 | 191038 | DPW Maintained 1 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 144 | 1301 Minnesota St | 17 | Front Yard : Yard | Tree | Private 2 | 7 | 6015383.3127 | 2102378.63663 | 37.7535954139151 | -122.38969766693 | (37.7535954139151, -122.38969766693) | 10 | 3 | 8 | 28856 | 29 | ||||
69334 | 223301 | DPW Maintained 1 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 144 | 4039 21st St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 5ft | 6001871.11422 | 2103502.75724 | 37.7559234475104 | -122.436506195027 | (37.7559234475104, -122.436506195027) | 2 | 4 | 5 | 28862 | 22 | |||
69906 | 67487 | DPW Maintained 1 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 144 | 1715 20th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/08/1992 12:00:00 AM | 3 | Permit Number 31011 | 6012862.87074 | 2104700.41126 | 37.7598304163533 | -122.398576880337 | (37.7598304163533, -122.398576880337) | 10 | 3 | 8 | 28856 | 29 | |
70611 | 35481 | DPW Maintained 1 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 144 | 1011 Silliman St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/18/1998 12:00:00 AM | 9 | Permit Number 38892 | 6007771.76175 | 2093386.17164 | 37.7284790839175 | -122.415383596892 | (37.7284790839175, -122.415383596892) | 9 | 3 | 7 | 309 | 5 | ||
70685 | 207510 | DPW Maintained 1 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 144 | 300 Mangels Ave | 8 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | 5999358.72288 | 2095270.42475 | 37.733176356297 | -122.444603175393 | (37.733176356297, -122.444603175393) | 9 | 7 | 4 | 59 | 40 | ||||
70927 | 88617 | Permitted Site 7 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 144 | 2494 47th Ave | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/04/2008 12:00:00 AM | 3x3 | Permit Number 51590 | 5981831.2 | 2098131.1 | 37.740015242507 | -122.505411474316 | (37.740015242507, -122.505411474316) | 1 | 8 | 3 | 29491 | 35 | |||
71521 | 223335 | DPW Maintained 1 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 144 | 147 Beacon St | 6 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 6ft | 6003368.46906 | 2097136.11169 | 37.7385270976507 | -122.4308735081 | (37.7385270976507, -122.4308735081) | 2 | 7 | 5 | 63 | 7 | |||
72752 | 201988 | DPW Maintained 1 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 144 | 1651 Carroll Ave | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | 6013586.6338 | 2092298.57883 | 37.7258178856713 | -122.39520498563 | (37.7258178856713, -122.39520498563) | 10 | 3 | 8 | 58 | 1 | ||||
72823 | 111277 | DPW Maintained 1 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 144 | 700X BOSWORTH ST | 15 | Front Yard : Yard | Tree | DPW 1 | 3 | 6002150 | 2095428 | 37.7337679036822 | -122.434964255854 | (37.7337679036822, -122.434964255854) | 2 | 7 | 5 | 63 | 7 | ||||
72876 | 187592 | DPW Maintained 1 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 144 | 700 Goettingen St | 3 | Front Yard : Yard | Tree | Private 2 | 3 | 6010726.84858 | 2091332.925 | 37.7230069439869 | -122.405023145203 | (37.7230069439869, -122.405023145203) | 10 | 3 | 7 | 309 | 28 | ||||
73263 | 207513 | DPW Maintained 1 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 144 | 454 Mangels Ave | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 9 | Width 6ft | 5998419.39569 | 2095283.7253 | 37.7331592314112 | -122.447851626453 | (37.7331592314112, -122.447851626453) | 9 | 7 | 4 | 59 | 40 | |||
74750 | 223909 | DPW Maintained 1 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 144 | 1000 Dolores St | 24 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 2ft | 6005053.21271 | 2102428.99396 | 37.7531554520847 | -122.425425034739 | (37.7531554520847, -122.425425034739) | 2 | 4 | 5 | 28862 | 22 | |||
75205 | 207461 | DPW Maintained 1 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 144 | 305 Foerster St | 4 | Sidewalk: Curb side : Pot | Tree | Private 2 | 2 | Width 2ft | 5998080.39557 | 2094433.71396 | 37.7308059196407 | -122.448962426781 | (37.7308059196407, -122.448962426781) | 9 | 7 | 4 | 59 | 40 | |||
75724 | 176185 | DPW Maintained 1 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 144 | 500 Geneva Ave | 6 | Sidewalk: Property side : Yard | Tree | Private 2 | 7 | Width 5ft | 5998832.19664 | 2090623.50383 | 37.7203869364761 | -122.446089381522 | (37.7203869364761, -122.446089381522) | 9 | 7 | 6 | 28861 | 25 | |||
75772 | 176209 | DPW Maintained 1 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 144 | 328 Santa Rosa Ave | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | 6000493.40055 | 2093786.98726 | 37.7291678630035 | -122.440573936562 | (37.7291678630035, -122.440573936562) | 9 | 7 | 6 | 28861 | 25 | ||||
75816 | 207519 | DPW Maintained 1 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 144 | 906 Teresita Blvd | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | Width 10ft | 5998840.32295 | 2095592.38942 | 37.7340308003734 | -122.446418571155 | (37.7340308003734, -122.446418571155) | 9 | 7 | 4 | 59 | 40 | |||
76982 | 117666 | DPW Maintained 1 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 144 | 4739 Anza St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 2ft | 5983855.96869 | 2111709.85463 | 37.7774176350156 | -122.499413971687 | (37.7774176350156, -122.499413971687) | 11 | 6 | 2 | 55 | 26 | |||
77163 | 223308 | DPW Maintained 1 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 144 | 4645 19th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6000449.27846 | 2104630.8077 | 37.7589399004855 | -122.441504300502 | (37.7589399004855, -122.441504300502) | 2 | 4 | 5 | 28862 | 38 | |||
77246 | 207483 | DPW Maintained 1 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 144 | 209 Flood Ave | 6 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | 5999342.79924 | 2094043.6842 | 37.7298071056102 | -122.444570089355 | (37.7298071056102, -122.444570089355) | 9 | 7 | 4 | 28861 | 40 | ||||
77335 | 122197 | DPW Maintained 1 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 144 | 131 14th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 5991469.09784 | 2114541.60598 | 37.7856365655774 | -122.473284495339 | (37.7856365655774, -122.473284495339) | 11 | 6 | 2 | 54 | 26 | |||
77499 | 122933 | DPW Maintained 1 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 144 | 184 10th Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 2ft | 5992764.59544 | 2114230.49713 | 37.7848572746711 | -122.468779840358 | (37.7848572746711, -122.468779840358) | 11 | 6 | 2 | 54 | 11 | |||
77650 | 223906 | DPW Maintained 1 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 144 | 1000 Dolores St | 21 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 2ft | 6005052.89667 | 2102434.79152 | 37.7531713529793 | -122.425426540219 | (37.7531713529793, -122.425426540219) | 2 | 4 | 5 | 28862 | 22 | |||
79281 | 38192 | DPW Maintained 1 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 144 | 715 Girard St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/17/1998 12:00:00 AM | 6 | Permit Number 40321 | 6011331.34824 | 2091527.76082 | 37.7235756968497 | -122.40294719786 | (37.7235756968497, -122.40294719786) | 10 | 3 | 7 | 309 | 28 | |
79445 | 223911 | DPW Maintained 1 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 144 | 248 Richland Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 3ft | 6006019.93763 | 2096086.78594 | 37.735795757653 | -122.421631483913 | (37.735795757653, -122.421631483913) | 2 | 7 | 7 | 28859 | 2 | |||
79880 | 222521 | DPW Maintained 1 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 144 | 791 27th St | 2 | Sidewalk: Curb side : Pot | Tree | Private 2 | 5 | Width 5ft | 6001435.72019 | 2099957.22341 | 37.746163509146 | -122.437758004524 | (37.746163509146, -122.437758004524) | 2 | 7 | 5 | 63 | 22 | |||
80703 | 176199 | DPW Maintained 1 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 144 | 800 Brussels St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 2ft | 6011139.2917 | 2091015.07876 | 37.7221572510345 | -122.403575053247 | (37.7221572510345, -122.403575053247) | 10 | 3 | 7 | 309 | 28 | |||
80761 | 223283 | DPW Maintained 1 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 144 | 1626 Diamond St | 10 | Sidewalk: Curb side : Pot | Tree | Private 2 | 2 | Width 8ft | 6002000.55819 | 2099252.37585 | 37.744260264912 | -122.435754448127 | (37.744260264912, -122.435754448127) | 2 | 7 | 5 | 63 | 22 | |||
81502 | 222508 | DPW Maintained 1 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 144 | 123 Marsily St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 2ft | 6004280.8593 | 2095209.0357 | 37.7332874360711 | -122.427581644992 | (37.7332874360711, -122.427581644992) | 9 | 7 | 5 | 28861 | 25 | |||
82775 | 5564 | DPW Maintained 1 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 144 | 1004 Dolores St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 3x20 | 6005043.3130716 | 2102494.5958208 | 37.753335020195 | -122.425463937964 | (37.753335020195, -122.425463937964) | 2 | 4 | 5 | 28862 | 22 | |||
84683 | 207516 | DPW Maintained 1 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 144 | 132 Melrose Ave | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | Width 10ft | 5999170.90631 | 2095539.25965 | 37.7339037945108 | -122.445271827652 | (37.7339037945108, -122.445271827652) | 9 | 7 | 4 | 59 | 40 | |||
85296 | 207509 | DPW Maintained 1 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 144 | 300 Mangels Ave | 6 | Sidewalk: Property side : Yard | Tree | Private 2 | 2 | 5999366.08904 | 2095270.53369 | 37.7331770757488 | -122.444577716507 | (37.7331770757488, -122.444577716507) | 9 | 7 | 4 | 59 | 40 | ||||
86240 | 223905 | DPW Maintained 1 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 144 | 1000 Dolores St | 20 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 2ft | 6005052.74936 | 2102437.17406 | 37.7531778865567 | -122.425427219187 | (37.7531778865567, -122.425427219187) | 2 | 4 | 5 | 28862 | 22 | |||
86768 | 223900 | DPW Maintained 1 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 144 | 1000 Dolores St | 15 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 2ft | 6005051.2163 | 2102450.92291 | 37.7532155510818 | -122.425433499183 | (37.7532155510818, -122.425433499183) | 2 | 4 | 5 | 28862 | 22 | |||
88044 | 191046 | DPW Maintained 1 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 144 | 900x Carolina St | 44 | Median : Yard | Tree | DPW 1 | 6 | 6012503.19406 | 2103068.83729 | 37.7553304273806 | -122.399706272322 | (37.7553304273806, -122.399706272322) | 10 | 3 | 8 | 28856 | 29 | ||||
88105 | 222518 | DPW Maintained 1 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 144 | 793 27th St | 4 | Sidewalk: Curb side : Pot | Tree | Private 2 | 3 | 6001409.25224 | 2099957.5688 | 37.746162952463 | -122.437849551912 | (37.746162952463, -122.437849551912) | 2 | 7 | 5 | 63 | 22 | ||||
88787 | 207456 | DPW Maintained 1 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 144 | 409 Hearst Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 2ft | 5998672.99795 | 2094364.83217 | 37.7306506597914 | -122.446908759242 | (37.7306506597914, -122.446908759242) | 9 | 7 | 4 | 28861 | 40 | |||
89225 | 223887 | DPW Maintained 1 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 144 | 3487 21st St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6005112.75604 | 2103680.27946 | 37.7565945540051 | -122.42530815707 | (37.7565945540051, -122.42530815707) | 2 | 4 | 5 | 28859 | 19 | |||
89862 | 222509 | DPW Maintained 1 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 144 | 123 Marsily St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | Width 2ft | 6004280.34409 | 2095211.59088 | 37.733294422879 | -122.427583608195 | (37.733294422879, -122.427583608195) | 9 | 7 | 5 | 28861 | 25 | |||
90306 | 207463 | DPW Maintained 1 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 144 | 698 Hearst Ave | 6 | Sidewalk: Property side : Yard | Tree | Private 2 | 11 | Width 6ft | 5996886.40179 | 2094438.11032 | 37.7307496337669 | -122.453090548796 | (37.7307496337669, -122.453090548796) | 9 | 7 | 4 | 59 | 40 | |||
90982 | 207497 | DPW Maintained 1 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 144 | 1315 Plymouth Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 5995861.97122 | 2092806.17827 | 37.7262099757024 | -122.456514177902 | (37.7262099757024, -122.456514177902) | 9 | 7 | 4 | 28861 | 40 | |||
91474 | 223882 | DPW Maintained 1 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 144 | 91 28th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6005342.96974 | 2099598.2197 | 37.7453991645551 | -122.424221686104 | (37.7453991645551, -122.424221686104) | 2 | 7 | 5 | 28859 | 22 | |||
91660 | 37639 | DPW Maintained 1 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 144 | 574 09th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/26/1998 12:00:00 AM | 6 | Permit Number 40056 | 5993171.91156 | 2111565.06758 | 37.7775622521226 | -122.467176805707 | (37.7775622521226, -122.467176805707) | 11 | 6 | 2 | 54 | 11 | |
91854 | 117663 | DPW Maintained 1 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 144 | 4739 Anza St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 2ft | 5983899.75591 | 2111710.53343 | 37.7774220677076 | -122.499262549855 | (37.7774220677076, -122.499262549855) | 11 | 6 | 2 | 55 | 26 | |||
92187 | 176187 | DPW Maintained 1 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 144 | 500 Geneva Ave | 8 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | Width 5ft | 5998858.23397 | 2090609.31611 | 37.7203494671212 | -122.445998359353 | (37.7203494671212, -122.445998359353) | 9 | 7 | 6 | 28861 | 25 | |||
92585 | 223323 | DPW Maintained 1 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 144 | 2811 Market St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6000992.8223 | 2105437.44063 | 37.7611856686148 | -122.43968230461 | (37.7611856686148, -122.43968230461) | 15 | 4 | 5 | 28862 | 3 | |||
92875 | 103911 | DPW Maintained 1 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 144 | 6025 03rd St | 12 | Sidewalk: Property side : Yard | Tree | Private 2 | 06/19/2013 12:00:00 AM | Permit Number 770276 | 6013653.2 | 2091451 | 37.7234943066524 | -122.394915533675 | (37.7234943066524, -122.394915533675) | 10 | 3 | 8 | 58 | 1 | |||
92980 | 50307 | DPW Maintained 1 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 144 | 755 Wisconsin St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/22/2003 12:00:00 AM | 6 | Permit Number 47018 | 6012755.49383 | 2104002.55412 | 37.7579082710796 | -122.398899267499 | (37.7579082710796, -122.398899267499) | 10 | 3 | 8 | 28856 | 29 | ||
93161 | 103910 | DPW Maintained 1 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 144 | 6025 03rd St | 11 | Sidewalk: Property side : Yard | Tree | Private 2 | 06/19/2013 12:00:00 AM | Permit Number 770276 | 6013653.2 | 2091451 | 37.7234943066524 | -122.394915533675 | (37.7234943066524, -122.394915533675) | 10 | 3 | 8 | 58 | 1 | |||
94057 | 113278 | Undocumented 4 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 144 | 2083 UNION ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6003046 | 2118476 | 37.797102943491 | -122.433513059035 | (37.797102943491, -122.433513059035) | 13 | 9 | 1 | 57 | 17 | ||||
94224 | 207438 | DPW Maintained 1 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 144 | 1230 Funston Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 5992085.75278 | 2107027.36715 | 37.7650401898777 | -122.470603574899 | (37.7650401898777, -122.470603574899) | 11 | 8 | 11 | 56 | 12 | |||
94233 | 176182 | DPW Maintained 1 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 144 | 200 Rome St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 7 | Width 0ft | 5998635.4334 | 2088884.2911 | 37.7156002193629 | -122.446644455673 | (37.7156002193629, -122.446644455673) | 9 | 7 | 6 | 28861 | 25 | |||
94242 | 94355 | Permitted Site 7 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 144 | 1265@ Waller St Masonic Ave | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/19/2010 12:00:00 AM | 3x3 | Permit Number 53635 | 5999439.6 | 2108532 | 37.7695940252359 | -122.445276718787 | (37.7695940252359, -122.445276718787) | 15 | 5 | 11 | 29492 | 9 | ||
94635 | 223330 | DPW Maintained 1 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 144 | 71 Randall St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6005065.72447 | 2097560.79174 | 37.7397891927167 | -122.425035418766 | (37.7397891927167, -122.425035418766) | 2 | 7 | 5 | 63 | 7 | |||
94953 | 223306 | DPW Maintained 1 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 144 | 300 Hill St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6004310.1714 | 2103386.37188 | 37.7557421774856 | -122.428062839822 | (37.7557421774856, -122.428062839822) | 2 | 4 | 5 | 28862 | 22 | |||
95558 | 223336 | DPW Maintained 1 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 144 | 5529 Diamond Heights Blvd | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | Width 5ft | 6001836.83808 | 2097447.0447 | 37.7392939468595 | -122.436191387341 | (37.7392939468595, -122.436191387341) | 2 | 7 | 5 | 63 | 7 | |||
95599 | 207515 | DPW Maintained 1 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 144 | 71 Melrose Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | 5999632.40668 | 2095469.97761 | 37.7337398948819 | -122.443671310503 | (37.7337398948819, -122.443671310503) | 9 | 7 | 4 | 63 | 40 | ||||
95988 | 16054 | DPW Maintained 1 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 144 | 215 Monterey Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/11/2000 12:00:00 AM | 3 | 3X3 | 6000626.03277 | 2094620.45379 | 37.7314639212093 | -122.440175160965 | (37.7314639212093, -122.440175160965) | 9 | 7 | 4 | 63 | 40 | ||
96102 | 223921 | DPW Maintained 1 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 144 | 638 San Jose Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6005996.90211 | 2099753.43099 | 37.7458622416657 | -122.421971513987 | (37.7458622416657, -122.421971513987) | 2 | 7 | 5 | 28859 | 22 | |||
96486 | 223914 | DPW Maintained 1 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 144 | 588 Ogden Ave | 2 | Sidewalk: Curb side : Pot | Tree | Private 2 | 2 | Width 4ft | 6007781.00432 | 2096146.35103 | 37.7360584568237 | -122.415546984806 | (37.7360584568237, -122.415546984806) | 2 | 7 | 7 | 28859 | 2 | |||
97048 | 103902 | DPW Maintained 1 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 144 | 6025 03rd St | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 06/19/2013 12:00:00 AM | Permit Number 770276 | 6013653.2 | 2091451 | 37.7234943066524 | -122.394915533675 | (37.7234943066524, -122.394915533675) | 10 | 3 | 8 | 58 | 1 | |||
97801 | 222512 | DPW Maintained 1 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 144 | 95 28th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 4ft | 6005345.21251 | 2099598.65373 | 37.7454004829386 | -122.424213961822 | (37.7454004829386, -122.424213961822) | 2 | 7 | 5 | 28859 | 22 | |||
98316 | 176201 | DPW Maintained 1 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 144 | 746 Olmstead St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 9 | Width 4ft | 6009499.02915 | 2090599.59902 | 37.7209246708253 | -122.409215763009 | (37.7209246708253, -122.409215763009) | 9 | 3 | 7 | 309 | 28 | |||
100112 | 223885 | DPW Maintained 1 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 144 | 1201 San Jose Ave | 53 | Front Yard : Yard | Tree | Private 2 | 4 | 6004491.44373 | 2096094.26439 | 37.7357299839367 | -122.426916620606 | (37.7357299839367, -122.426916620606) | 2 | 7 | 5 | 28861 | 2 | ||||
100836 | 223899 | DPW Maintained 1 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 144 | 1000 Dolores St | 14 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 2ft | 6005050.67979 | 2102453.42416 | 37.7532223886195 | -122.425435532533 | (37.7532223886195, -122.425435532533) | 2 | 4 | 5 | 28862 | 22 | |||
100927 | 223337 | DPW Maintained 1 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 144 | 21 Poppy Ln | 1 | Back Yard : Yard | Tree | Private 2 | 5 | Width 2ft | 6002002.72042 | 2096679.58594 | 37.7371961064217 | -122.435562951888 | (37.7371961064217, -122.435562951888) | 2 | 7 | 5 | 63 | 7 | |||
101311 | 223294 | DPW Maintained 1 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 144 | 779 Andover St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | Width 3ft | 6007381.1978 | 2095205.15374 | 37.7334516540573 | -122.416862619235 | (37.7334516540573, -122.416862619235) | 2 | 7 | 7 | 28859 | 2 | |||
102655 | 207486 | DPW Maintained 1 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 144 | 112 Marston Ave | 7 | Sidewalk: Property side : Yard | Tree | Private 2 | 2 | 5998687.36534 | 2093224.24643 | 37.7275196997744 | -122.446777050815 | (37.7275196997744, -122.446777050815) | 9 | 7 | 4 | 28861 | 40 | ||||
102677 | 223896 | DPW Maintained 1 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 144 | 1000 Dolores St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 2ft | 6005049.72495 | 2102468.45452 | 37.7532636045415 | -122.425439904124 | (37.7532636045415, -122.425439904124) | 2 | 4 | 5 | 28862 | 22 | |||
102769 | 223915 | DPW Maintained 1 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 144 | 588 Ogden Ave | 4 | Sidewalk: Curb side : Pot | Tree | Private 2 | 2 | Width 4ft | 6007768.9471 | 2096146.59786 | 37.7360584568223 | -122.415588689077 | (37.7360584568223, -122.415588689077) | 2 | 7 | 7 | 28859 | 2 | |||
102850 | 207447 | DPW Maintained 1 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 144 | 2 Teresita Blvd | 4 | Sidewalk: Curb side : Pot | Tree | Private 2 | 3 | Width 4ft | 5997345.19439 | 2099475.93136 | 37.7446085570499 | -122.451867739721 | (37.7446085570499, -122.451867739721) | 9 | 7 | 4 | 59 | 40 | |||
102911 | 222534 | DPW Maintained 1 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 144 | 1626 Diamond St | 7 | Sidewalk: Curb side : Pot | Tree | Private 2 | 3 | Width 8ft | 6002001.17039 | 2099260.36967 | 37.7442822488393 | -122.435752903091 | (37.7442822488393, -122.435752903091) | 2 | 7 | 5 | 63 | 22 | |||
103007 | 207445 | DPW Maintained 1 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 144 | 65 Upland Dr | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 5994317.99715 | 2093727.15721 | 37.7286499965007 | -122.461918327265 | (37.7286499965007, -122.461918327265) | 9 | 8 | 4 | 59 | 40 | |||
103322 | 191047 | DPW Maintained 1 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 144 | 508 Missouri St | 3 | : | Tree | Private 2 | 5 | Width 8ft | 6013509.00195 | 2104632.60387 | 37.7596802080014 | -122.396337460525 | (37.7596802080014, -122.396337460525) | 10 | 3 | 8 | 28856 | 29 | |||
103791 | 247051 | DPW Maintained 1 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 144 | 519 Valley St | 1 | : | Tree | Private 2 | 1 | Width 3ft | 6002519.90495 | 2099141.5459 | 37.7439854383853 | -122.433950739945 | (37.7439854383853, -122.433950739945) | 2 | 7 | 5 | 63 | 22 |
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) );