trees
400 rows where qSpecies_id = 43 sorted by Supervisor Districts descending
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
67437 | 36510 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 406 Andover St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/18/1998 12:00:00 AM | Permit Number 39387 | 6007487.22983868 | 2096928.20854387 | 37.7381887481689 | -122.416618053798 | (37.7381887481689, -122.416618053798) | 2 | 7 | 7 | 28859 | 2 | ||
67646 | 39064 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 238 Capp St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/11/2003 12:00:00 AM | Permit Number 40776 | 6007140.57976269 | 2105924.49860202 | 37.7628710155664 | -122.418454324135 | (37.7628710155664, -122.418454324135) | 8 | 4 | 7 | 28859 | 19 | ||
71856 | 36717 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 1850 Mission St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/26/1999 12:00:00 AM | Permit Number 39504 | 6006730.53287232 | 2107601.56248509 | 37.767452746672 | -122.419991553753 | (37.767452746672, -122.419991553753) | 8 | 4 | 7 | 28853 | 19 | ||
72189 | 38209 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 830 Goettingen St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/17/1998 12:00:00 AM | Permit Number 40332 | 6010874.68113014 | 2090828.02861629 | 37.7216288654759 | -122.40447659257 | (37.7216288654759, -122.40447659257) | 10 | 3 | 7 | 309 | 28 | ||
75154 | 23668 | DPW Maintained 1 | Dodonaea viscosa :: Hop Bush 43 | 315 Virginia Ave | 3 | Median : Cutout | Tree | DPW 1 | 3 | 12 | 6006939.5968988 | 2098278.7889768 | 37.7418663267774 | -122.418607247372 | (37.7418663267774, -122.418607247372) | 2 | 7 | 7 | 28859 | 2 | |||
79486 | 37707 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 720 South Van Ness Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/29/1998 12:00:00 AM | Permit Number 40083 | 6007483.64662361 | 2105457.13704999 | 37.7616070561613 | -122.417234652367 | (37.7616070561613, -122.417234652367) | 2 | 4 | 7 | 28859 | 19 | ||
83598 | 34569 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 212 Prentiss St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/28/1997 12:00:00 AM | Permit Number 38277 | 6008791.12126389 | 2097614.61295509 | 37.7401467112036 | -122.41215832665 | (37.7401467112036, -122.41215832665) | 10 | 7 | 7 | 28859 | 2 | ||
86025 | 38199 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 455 Goettingen St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/17/1998 12:00:00 AM | Permit Number 40326 | 6010407.74547618 | 2092510.58020697 | 37.7262226967111 | -122.406209156508 | (37.7262226967111, -122.406209156508) | 10 | 3 | 7 | 309 | 28 | ||
86212 | 43997 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 146 Ripley St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/11/2000 12:00:00 AM | Permit Number 43554 | 6008915.83516029 | 2099075.89728061 | 37.7441660743482 | -122.411830346827 | (37.7441660743482, -122.411830346827) | 2 | 7 | 7 | 28859 | 2 | |||
87797 | 39174 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 7461 South Van Ness Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/19/1998 12:00:00 AM | Permit Number 40835 | 6007491.70606937 | 2105311.60400293 | 37.7612079095392 | -122.417196465004 | (37.7612079095392, -122.417196465004) | 2 | 4 | 7 | 28859 | 19 | ||
88126 | 43999 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 158 Ripley St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/11/2000 12:00:00 AM | Permit Number 43556 | 6009020.46100461 | 2099081.71622052 | 37.7441879209123 | -122.411468983209 | (37.7441879209123, -122.411468983209) | 2 | 7 | 7 | 28859 | 2 | |||
89187 | 251679 | Undocumented 4 | Dodonaea viscosa :: Hop Bush 43 | 5 Dwight St | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6011495 | 2091622 | 37.7238435952898 | -122.402388102511 | (37.7238435952898, -122.402388102511) | 10 | 3 | 7 | 309 | 28 | |||||
89415 | 40641 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 187 Ripley St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/10/1999 12:00:00 AM | Permit Number 41639 | 6009210.87994007 | 2099144.38708889 | 37.7443706801351 | -122.410814978675 | (37.7443706801351, -122.410814978675) | 2 | 7 | 7 | 28859 | 2 | |||
91288 | 106921 | Undocumented 4 | Dodonaea viscosa :: Hop Bush 43 | 112-118 SHOTWELL ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | 3x3 | 6007680.5 | 2107244.2 | 37.7665249882726 | -122.416680417976 | (37.7665249882726, -122.416680417976) | 8 | 4 | 7 | 28853 | 19 | |||
95507 | 36720 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 1850 Mission St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/14/2004 12:00:00 AM | Permit Number 39504 | 6006730.53287232 | 2107601.56248509 | 37.767452746672 | -122.419991553753 | (37.767452746672, -122.419991553753) | 8 | 4 | 7 | 28853 | 19 | ||
96433 | 37701 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 700 South Van Ness Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/29/1998 12:00:00 AM | Permit Number 40082 | 6007477.44704972 | 2105569.08555176 | 37.7619140920083 | -122.417264027542 | (37.7619140920083, -122.417264027542) | 2 | 4 | 7 | 28859 | 19 | ||
98168 | 37716 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 943 South Van Ness Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/29/1998 12:00:00 AM | Permit Number 40086 | 6007607.04837726 | 2104169.37424002 | 37.7580780981898 | -122.416716622543 | (37.7580780981898, -122.416716622543) | 2 | 4 | 7 | 28859 | 19 | ||
100434 | 37455 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 125 Gates St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/19/1998 12:00:00 AM | Permit Number 39928 | 6008336.46582591 | 2098008.78903327 | 37.7412035106459 | -122.413758220259 | (37.7412035106459, -122.413758220259) | 2 | 7 | 7 | 28859 | 2 | ||
100539 | 39065 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 238 Capp St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/11/2003 12:00:00 AM | Permit Number 40776 | 6007140.57976269 | 2105924.49860202 | 37.7628710155664 | -122.418454324135 | (37.7628710155664, -122.418454324135) | 8 | 4 | 7 | 28859 | 19 | ||
105045 | 37437 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 51 Brewster St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/19/1998 12:00:00 AM | Permit Number 39912 | 6010454.2114909 | 2099614.59600709 | 37.745731407921 | -122.406548905427 | (37.745731407921, -122.406548905427) | 2 | 7 | 7 | 28859 | 2 | ||
111237 | 38179 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 36 Dwight St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/17/1998 12:00:00 AM | Permit Number 40312 | 6011464.3100447 | 2091682.81198966 | 37.7240088592297 | -122.402498467389 | (37.7240088592297, -122.402498467389) | 10 | 3 | 7 | 309 | 28 | ||
112873 | 38302 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 2000 Folsom St | 14 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/27/1998 12:00:00 AM | Permit Number 40376 | 6008042.39215173 | 2106787.37094181 | 37.7652909891949 | -122.415396349695 | (37.7652909891949, -122.415396349695) | 8 | 4 | 7 | 28859 | 19 | ||
116815 | 35745 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 1005 Silliman St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/15/1998 12:00:00 AM | Permit Number 39018 | 6007884.66062501 | 2093417.72691387 | 37.728572072766 | -122.414995531053 | (37.728572072766, -122.414995531053) | 9 | 3 | 7 | 309 | 5 | ||
124119 | 37706 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 700 South Van Ness Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/29/1998 12:00:00 AM | Permit Number 40082 | 6007477.44704972 | 2105569.08555176 | 37.7619140920083 | -122.417264027542 | (37.7619140920083, -122.417264027542) | 2 | 4 | 7 | 28859 | 19 | ||
126210 | 37454 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 125 Gates St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/19/1998 12:00:00 AM | Permit Number 39928 | 6008336.46582591 | 2098008.78903327 | 37.7412035106459 | -122.413758220259 | (37.7412035106459, -122.413758220259) | 2 | 7 | 7 | 28859 | 2 | ||
126442 | 35941 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 19 Bennington St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/27/1998 12:00:00 AM | Permit Number 39104 | 6007226.10455525 | 2097703.31078326 | 37.7403023177454 | -122.417575817322 | (37.7403023177454, -122.417575817322) | 2 | 7 | 7 | 28859 | 2 | ||
128039 | 37702 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 700 South Van Ness Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/29/1998 12:00:00 AM | Permit Number 40082 | 6007477.44704972 | 2105569.08555176 | 37.7619140920083 | -122.417264027542 | (37.7619140920083, -122.417264027542) | 2 | 4 | 7 | 28859 | 19 | ||
132556 | 43498 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 4145 Folsom St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/19/2000 12:00:00 AM | Permit Number 43178 | 6008355.55350511 | 2095881.30836855 | 37.7353629859312 | -122.413541790025 | (37.7353629859312, -122.413541790025) | 10 | 7 | 7 | 28859 | 2 | ||
134688 | 43251 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 270 Holyoke St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/12/2000 12:00:00 AM | Permit Number 43039 | 6009534.75313896 | 2093131.57732831 | 37.727878953409 | -122.409270860276 | (37.727878953409, -122.409270860276) | 10 | 3 | 7 | 309 | 28 | ||
136441 | 38176 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 5 Dwight St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/17/1998 12:00:00 AM | Permit Number 40311 | 6011565.07182758 | 2091659.31063556 | 37.7239499540685 | -122.402148496173 | (37.7239499540685, -122.402148496173) | 10 | 3 | 7 | 309 | 28 | ||
142691 | 36568 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 327 Richland Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/19/1998 12:00:00 AM | Permit Number 39430 | 6006720.99763739 | 2096073.95090972 | 37.7358000222337 | -122.419206729617 | (37.7358000222337, -122.419206729617) | 2 | 7 | 7 | 28859 | 2 | ||
147396 | 38211 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 201 Olmstead St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/17/1998 12:00:00 AM | Permit Number 40334 | 6011139.75939059 | 2091047.44760609 | 37.7222461553598 | -122.403575712805 | (37.7222461553598, -122.403575712805) | 10 | 3 | 7 | 309 | 28 | ||
151832 | 36719 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 1850 Mission St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/14/2004 12:00:00 AM | Permit Number 39504 | 6006730.53287232 | 2107601.56248509 | 37.767452746672 | -122.419991553753 | (37.767452746672, -122.419991553753) | 8 | 4 | 7 | 28853 | 19 | ||
152141 | 40299 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 2155 Mission St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/13/1999 12:00:00 AM | Permit Number 41445 | 6006883.99939755 | 2105792.08668164 | 37.7624929958367 | -122.419332354319 | (37.7624929958367, -122.419332354319) | 8 | 4 | 7 | 28859 | 19 | ||
155234 | 39134 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 810 Capp St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/30/2000 12:00:00 AM | Permit Number 40813 | 6007325.69907761 | 2102579.12781976 | 37.7536958179011 | -122.417576944272 | (37.7536958179011, -122.417576944272) | 2 | 4 | 7 | 28859 | 19 | ||
157106 | 38170 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 349 Bacon St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/17/1998 12:00:00 AM | Permit Number 40306 | 6010462.31979056 | 2092763.8646761 | 37.7269212154772 | -122.40603833072 | (37.7269212154772, -122.40603833072) | 10 | 3 | 7 | 309 | 28 | ||
165109 | 39139 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 1081 Capp St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/19/1998 12:00:00 AM | Permit Number 40817 | 6007463.5839422 | 2101024.83737451 | 37.7494358467299 | -122.416989987658 | (37.7494358467299, -122.416989987658) | 2 | 4 | 7 | 28859 | 19 | ||
166564 | 37709 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 720 South Van Ness Ave | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/29/1998 12:00:00 AM | Permit Number 40083 | 6007483.64662361 | 2105457.13704999 | 37.7616070561613 | -122.417234652367 | (37.7616070561613, -122.417234652367) | 2 | 4 | 7 | 28859 | 19 | ||
168179 | 37708 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 720 South Van Ness Ave | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/29/1998 12:00:00 AM | Permit Number 40083 | 6007483.64662361 | 2105457.13704999 | 37.7616070561613 | -122.417234652367 | (37.7616070561613, -122.417234652367) | 2 | 4 | 7 | 28859 | 19 | ||
168287 | 39138 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 1081 Capp St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/19/1998 12:00:00 AM | Permit Number 40817 | 6007463.5839422 | 2101024.83737451 | 37.7494358467299 | -122.416989987658 | (37.7494358467299, -122.416989987658) | 2 | 4 | 7 | 28859 | 19 | ||
168833 | 37703 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 700 South Van Ness Ave | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/29/1998 12:00:00 AM | Permit Number 40082 | 6007477.44704972 | 2105569.08555176 | 37.7619140920083 | -122.417264027542 | (37.7619140920083, -122.417264027542) | 2 | 4 | 7 | 28859 | 19 | ||
169743 | 37845 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 132 Brewster St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/02/2005 12:00:00 AM | Permit Number 40137 | 6010294.81147281 | 2099208.35616527 | 37.7446070428057 | -122.40707146066 | (37.7446070428057, -122.40707146066) | 2 | 7 | 7 | 28859 | 2 | ||
170691 | 37458 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 25 MacEdonia St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/19/1998 12:00:00 AM | Permit Number 39930 | 6010305.7989409 | 2099791.60340169 | 37.7462091274065 | -122.407074571233 | (37.7462091274065, -122.407074571233) | 2 | 7 | 7 | 28859 | 2 | ||
170901 | 36718 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 1850 Mission St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/14/2004 12:00:00 AM | Permit Number 39504 | 6006730.53287232 | 2107601.56248509 | 37.767452746672 | -122.419991553753 | (37.767452746672, -122.419991553753) | 8 | 4 | 7 | 28853 | 19 | ||
172166 | 36078 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 2134 Folsom St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/28/1998 12:00:00 AM | Permit Number 39191 | 6008086.14600314 | 2105996.63644369 | 37.7631222746353 | -122.415189036821 | (37.7631222746353, -122.415189036821) | 8 | 4 | 7 | 28859 | 19 | ||
172758 | 102442 | Undocumented 4 | Dodonaea viscosa :: Hop Bush 43 | 4145 Folsom St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | 3x3 | 6008344 | 2095883 | 37.735366982035 | -122.413581854524 | (37.735366982035, -122.413581854524) | 10 | 7 | 7 | 28859 | 2 | |||
172957 | 40642 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 185 Ripley St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/10/1999 12:00:00 AM | Permit Number 41640 | 6009192.03574967 | 2099143.33903301 | 37.7443667457738 | -122.410880064189 | (37.7443667457738, -122.410880064189) | 2 | 7 | 7 | 28859 | 2 | |||
174203 | 37705 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 700 South Van Ness Ave | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/29/1998 12:00:00 AM | Permit Number 40082 | 6007477.44704972 | 2105569.08555176 | 37.7619140920083 | -122.417264027542 | (37.7619140920083, -122.417264027542) | 2 | 4 | 7 | 28859 | 19 | ||
178631 | 38169 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 349 Bacon St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/17/1998 12:00:00 AM | Permit Number 40306 | 6010462.31979056 | 2092763.8646761 | 37.7269212154772 | -122.40603833072 | (37.7269212154772, -122.40603833072) | 10 | 3 | 7 | 309 | 28 | ||
179341 | 38180 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 42 Dwight St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/17/1998 12:00:00 AM | Permit Number 40313 | 6011447.25206772 | 2091677.58315317 | 37.7239935496068 | -122.402557066965 | (37.7239935496068, -122.402557066965) | 10 | 3 | 7 | 309 | 28 | ||
181109 | 38195 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 730 Girard St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/17/1998 12:00:00 AM | Permit Number 40323 | 6011305.3220934 | 2091453.71988413 | 37.7233709423274 | -122.403031960796 | (37.7233709423274, -122.403031960796) | 10 | 3 | 7 | 309 | 28 | ||
183814 | 37700 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 700 South Van Ness Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/29/1998 12:00:00 AM | Permit Number 40082 | 6007477.44704972 | 2105569.08555176 | 37.7619140920083 | -122.417264027542 | (37.7619140920083, -122.417264027542) | 2 | 4 | 7 | 28859 | 19 | ||
184586 | 37749 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 1271 Florida St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/17/1999 12:00:00 AM | Permit Number 40096 | 6009537.93489258 | 2101780.18844977 | 37.7516263413346 | -122.409870111191 | (37.7516263413346, -122.409870111191) | 2 | 4 | 7 | 28859 | 19 | ||
184921 | 38197 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 731 Girard St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/17/1998 12:00:00 AM | Permit Number 40324 | 6011355.00492598 | 2091469.0696772 | 37.7234158640083 | -122.402861294571 | (37.7234158640083, -122.402861294571) | 10 | 3 | 7 | 309 | 28 | ||
185863 | 37786 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 301 Hamilton St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/06/1998 12:00:00 AM | Permit Number 40119 | 6009341.93324933 | 2092913.86947002 | 37.7272703689284 | -122.409922083912 | (37.7272703689284, -122.409922083912) | 10 | 3 | 7 | 309 | 28 | |||
187515 | 37783 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 289 Hamilton St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/06/1998 12:00:00 AM | Permit Number 40117 | 6009320.94225991 | 2092982.60267054 | 37.7274579192917 | -122.409999500097 | (37.7274579192917, -122.409999500097) | 10 | 3 | 7 | 309 | 28 | ||
191442 | 38168 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 349 Bacon St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/17/1998 12:00:00 AM | Permit Number 40306 | 6010462.31979056 | 2092763.8646761 | 37.7269212154772 | -122.40603833072 | (37.7269212154772, -122.40603833072) | 10 | 3 | 7 | 309 | 28 | ||
193933 | 40300 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 2155 Mission St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/13/1999 12:00:00 AM | Permit Number 41445 | 6006883.99939755 | 2105792.08668164 | 37.7624929958367 | -122.419332354319 | (37.7624929958367, -122.419332354319) | 8 | 4 | 7 | 28859 | 19 | |||
14145 | 52527 | DPW Maintained 1 | Dodonaea viscosa :: Hop Bush 43 | 123 San Juan Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/28/2005 12:00:00 AM | 5 | 2x3 | Permit Number 779986 | 6001343.89555 | 2092234.36388 | 37.7249531074958 | -122.437522568322 | (37.7249531074958, -122.437522568322) | 9 | 7 | 6 | 28861 | 25 |
43841 | 39675 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 520 Orizaba Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/29/1998 12:00:00 AM | Permit Number 41061 | 5994057.0703552 | 2090076.01512202 | 37.7186098185096 | -122.462555624891 | (37.7186098185096, -122.462555624891) | 9 | 8 | 6 | 28861 | 24 | ||
63515 | 207425 | DPW Maintained 1 | Dodonaea viscosa :: Hop Bush 43 | 359 Byxbee St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 7 | Width 10ft | 5991937.91081 | 2090925.40696 | 37.7208197721094 | -122.469942439193 | (37.7208197721094, -122.469942439193) | 9 | 8 | 6 | 64 | 24 | |||
82374 | 43745 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 253 Summit St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/25/2000 12:00:00 AM | Permit Number 43378 | 5996396.86656602 | 2089502.57565196 | 37.7171697577055 | -122.454426548253 | (37.7171697577055, -122.454426548253) | 9 | 8 | 6 | 28861 | 24 | ||
94076 | 31013 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 1016 Munich St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/13/1995 12:00:00 AM | Permit Number 34783 | 6002340.84086344 | 2087450.93520516 | 37.7118755052494 | -122.433734519918 | (37.7118755052494, -122.433734519918) | 9 | 7 | 6 | 28861 | 5 | ||
100219 | 39676 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 520 Orizaba Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/29/1998 12:00:00 AM | Permit Number 41061 | 5994057.0703552 | 2090076.01512202 | 37.7186098185096 | -122.462555624891 | (37.7186098185096, -122.462555624891) | 9 | 8 | 6 | 28861 | 24 | ||
107910 | 51637 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 189 Margaret Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/16/2005 12:00:00 AM | Permit Number 47927 | 5996660.05636895 | 2089154.42395132 | 37.7162289049692 | -122.453491707846 | (37.7162289049692, -122.453491707846) | 9 | 8 | 6 | 28861 | 24 | |||
111332 | 32293 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 160 Margaret Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/15/1999 12:00:00 AM | Permit Number 41561 | 5996702.09015079 | 2089306.207139 | 37.7166480756618 | -122.453357371649 | (37.7166480756618, -122.453357371649) | 9 | 8 | 6 | 28861 | 24 | ||
116835 | 43746 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 253 Summit St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/25/2000 12:00:00 AM | Permit Number 43378 | 5996396.86656602 | 2089502.57565196 | 37.7171697577055 | -122.454426548253 | (37.7171697577055, -122.454426548253) | 9 | 8 | 6 | 28861 | 24 | ||
147242 | 43743 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 240 Summit St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/25/2000 12:00:00 AM | Permit Number 43377 | 5996455.89048278 | 2089497.50907915 | 37.7171592309734 | -122.454222165987 | (37.7171592309734, -122.454222165987) | 9 | 8 | 6 | 28861 | 24 | ||
155289 | 31184 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 700 Shields St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/21/1995 12:00:00 AM | Permit Number 34882 | 5992197.59450604 | 2089880.36663556 | 37.7179653541743 | -122.468968787075 | (37.7179653541743, -122.468968787075) | 9 | 8 | 6 | 64 | 24 | ||
169593 | 43744 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 240 Summit St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/25/2000 12:00:00 AM | Permit Number 43377 | 5996455.89048278 | 2089497.50907915 | 37.7171592309734 | -122.454222165987 | (37.7171592309734, -122.454222165987) | 9 | 8 | 6 | 28861 | 24 | ||
176487 | 34803 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 722 Huron Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/29/1997 12:00:00 AM | Permit Number 38439 | 5997690.29775308 | 2087581.0038805 | 37.7119676582592 | -122.449817388593 | (37.7119676582592, -122.449817388593) | 9 | 7 | 6 | 28861 | 25 | ||
3588 | 37560 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 4645 19th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/26/1998 12:00:00 AM | Permit Number 39999 | 6000466.36495931 | 2104620.54811441 | 37.758912703603 | -122.44144447135 | (37.758912703603, -122.44144447135) | 2 | 4 | 5 | 28862 | 38 | ||
10411 | 47385 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 1231 Douglass St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/13/2002 12:00:00 AM | Permit Number 45301 | 6001377.58877778 | 2100188.59270033 | 37.7467954887327 | -122.437975585037 | (37.7467954887327, -122.437975585037) | 2 | 4 | 5 | 63 | 22 | |||
13812 | 34364 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 1862 Church St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/14/1997 12:00:00 AM | Permit Number 38120 | 6004563.40220029 | 2097868.81083057 | 37.7406065549579 | -122.426794167737 | (37.7406065549579, -122.426794167737) | 2 | 7 | 5 | 63 | 7 | ||
14374 | 34363 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 1846 Church St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/14/1997 12:00:00 AM | Permit Number 38119 | 6004556.0268692 | 2098000.12862747 | 37.7409667067108 | -122.426829018524 | (37.7409667067108, -122.426829018524) | 2 | 7 | 5 | 63 | 7 | ||
14912 | 34353 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 11 Chenery St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/14/1997 12:00:00 AM | Permit Number 38109 | 6004890.69932117 | 2098315.24737801 | 37.7418508681298 | -122.425694266568 | (37.7418508681298, -122.425694266568) | 2 | 7 | 5 | 63 | 7 | ||
18989 | 37041 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 1660 Church St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/01/1998 12:00:00 AM | Permit Number 39650 | 6004584.07651504 | 2099217.83848958 | 37.7443118455047 | -122.426818732995 | (37.7443118455047, -122.426818732995) | 2 | 7 | 5 | 63 | 22 | |||
19915 | 37424 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 1220 Noe St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/15/1998 12:00:00 AM | Permit Number 39902 | 6003190.5059195 | 2101131.09771587 | 37.7494863167503 | -122.431773980118 | (37.7494863167503, -122.431773980118) | 2 | 4 | 5 | 28862 | 22 | |||
20564 | 35401 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 527 30th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/16/1998 12:00:00 AM | Permit Number 38856 | 6003213.78352736 | 2098311.09733417 | 37.7417445720019 | -122.431492193982 | (37.7417445720019, -122.431492193982) | 2 | 7 | 5 | 63 | 7 | ||
26194 | 34414 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 205 Randall St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/15/1997 12:00:00 AM | Permit Number 38161 | 6004190.49432582 | 2097526.98545022 | 37.7396468892769 | -122.428059186764 | (37.7396468892769, -122.428059186764) | 2 | 7 | 5 | 63 | 7 | ||
29030 | 37044 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 1660 Church St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/01/1998 12:00:00 AM | Permit Number 39650 | 6004584.07651504 | 2099217.83848958 | 37.7443118455047 | -122.426818732995 | (37.7443118455047, -122.426818732995) | 2 | 7 | 5 | 63 | 22 | |||
29221 | 34402 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 160 Moffitt St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/15/1997 12:00:00 AM | Permit Number 38149 | 6002458.41825324 | 2097080.12272084 | 37.7383217597979 | -122.434016021054 | (37.7383217597979, -122.434016021054) | 2 | 7 | 5 | 63 | 7 | ||
36835 | 37313 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 485 Hill St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/15/1998 12:00:00 AM | Permit Number 39829 | 6003203.23907746 | 2103274.86360864 | 37.7553733132886 | -122.431883001431 | (37.7553733132886, -122.431883001431) | 2 | 4 | 5 | 28862 | 22 | ||
36889 | 207426 | DPW Maintained 1 | Dodonaea viscosa :: Hop Bush 43 | 404 Baden St | 1 | Side Yard : Yard | Tree | Private 2 | 3 | 6000774.5178 | 2095253.08109 | 37.7332094216698 | -122.439707159174 | (37.7332094216698, -122.439707159174) | 9 | 7 | 5 | 63 | 40 | ||||
37916 | 233997 | DPW Maintained 1 | Dodonaea viscosa :: Hop Bush 43 | 1027 Douglass St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 2ft | 6001336.17311 | 2100800.0445 | 37.7484720346532 | -122.438162590655 | (37.7484720346532, -122.438162590655) | 2 | 4 | 5 | 28862 | 22 | |||
39432 | 37587 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 2805 Market St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/26/1998 12:00:00 AM | Permit Number 40018 | 6001080.41648379 | 2105487.69270452 | 37.7613286337784 | -122.439382956636 | (37.7613286337784, -122.439382956636) | 15 | 4 | 5 | 28862 | 3 | ||
41386 | 121194 | Significant Tree 6 | Dodonaea viscosa :: Hop Bush 43 | 255x Red Rock Way | 1 | Front Yard : Yard | Tree | Private 2 | 3x3 | Permit Number 775289 | 5999917 | 2099808 | 37.7456673038035 | -122.442998816589 | (37.7456673038035, -122.442998816589) | 2 | 7 | 5 | 63 | 22 | |||
44466 | 37043 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 1660 Church St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/01/1998 12:00:00 AM | Permit Number 39650 | 6004584.07651504 | 2099217.83848958 | 37.7443118455047 | -122.426818732995 | (37.7443118455047, -122.426818732995) | 2 | 7 | 5 | 63 | 22 | |||
45134 | 34388 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 100 Mateo St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/14/1997 12:00:00 AM | Permit Number 38136 | 6003730.56187145 | 2096520.40051304 | 37.7368570045518 | -122.429577666227 | (37.7368570045518, -122.429577666227) | 2 | 7 | 5 | 63 | 7 | ||
50923 | 34400 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 156 Moffitt St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/15/1997 12:00:00 AM | Permit Number 38147 | 6002471.83146577 | 2097061.86671715 | 37.738272394243 | -122.433968340214 | (37.738272394243, -122.433968340214) | 2 | 7 | 5 | 63 | 7 | ||
62613 | 37588 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 2805 Market St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/26/1998 12:00:00 AM | Permit Number 40018 | 6001080.41648379 | 2105487.69270452 | 37.7613286337784 | -122.439382956636 | (37.7613286337784, -122.439382956636) | 15 | 4 | 5 | 28862 | 3 | ||
63600 | 34404 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 171 Moffitt St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/15/1997 12:00:00 AM | Permit Number 38152 | 6002491.04646095 | 2096956.56807226 | 37.7379843589135 | -122.433894379886 | (37.7379843589135, -122.433894379886) | 2 | 7 | 5 | 63 | 7 | ||
64957 | 9986 | DPW Maintained 1 | Dodonaea viscosa :: Hop Bush 43 | 2 Guerrero St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 01/01/2007 12:00:00 AM | 8 | 2x2 | 6005339.0167972 | 2108804.8168432 | 37.7706780982219 | -122.424890239466 | (37.7706780982219, -122.424890239466) | 8 | 2 | 5 | 28853 | 19 | ||
65609 | 37589 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 2805 Market St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/26/1998 12:00:00 AM | Permit Number 40018 | 6001080.41648379 | 2105487.69270452 | 37.7613286337784 | -122.439382956636 | (37.7613286337784, -122.439382956636) | 15 | 4 | 5 | 28862 | 3 | ||
72751 | 37286 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 699 Castro St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/02/2002 12:00:00 AM | Permit Number 39818 | 6002432.10165251 | 2104152.77929012 | 37.757740114019 | -122.434612596377 | (37.757740114019, -122.434612596377) | 2 | 4 | 5 | 28862 | 3 | ||
79487 | 37590 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 2805 Market St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/26/1998 12:00:00 AM | Permit Number 40018 | 6001080.41648379 | 2105487.69270452 | 37.7613286337784 | -122.439382956636 | (37.7613286337784, -122.439382956636) | 15 | 4 | 5 | 28862 | 3 | ||
80984 | 36908 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 394 Diamond St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/27/1998 12:00:00 AM | Permit Number 39556 | 6001774.84404362 | 2103557.93464621 | 37.7560694803843 | -122.436843078117 | (37.7560694803843, -122.436843078117) | 2 | 4 | 5 | 28862 | 3 | ||
94256 | 34355 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 84 Chenery St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/11/2003 12:00:00 AM | Permit Number 38111 | 6004874.55521399 | 2097707.40817778 | 37.7401809675376 | -122.425706834494 | (37.7401809675376, -122.425706834494) | 2 | 7 | 5 | 63 | 7 | ||
110816 | 37426 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 1220 Noe St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/15/1998 12:00:00 AM | Permit Number 39902 | 6003190.5059195 | 2101131.09771587 | 37.7494863167503 | -122.431773980118 | (37.7494863167503, -122.431773980118) | 2 | 4 | 5 | 28862 | 22 | |||
114946 | 35548 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 25 Fair Oaks St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/23/1998 12:00:00 AM | Permit Number 38924 | 6005398.06539258 | 2103564.19233402 | 37.7562919206066 | -122.424313197508 | (37.7562919206066, -122.424313197508) | 2 | 4 | 5 | 28859 | 19 |
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) );