trees
176 rows where DBH = "" and qSpecies_id = 65 sorted by PermitNotes
This data as json, CSV (advanced)
These facets timed out: SiteOrder, DBH
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1070 | 261149 | Undocumented 4 | Agonis flexuosa :: Peppermint Willow 65 | 322x Santiago St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5991839 | 2099782 | 37.7451320352893 | -122.470929181064 | (37.7451320352893, -122.470929181064) | 1 | 8 | 4 | 29491 | 40 | ||||
1841 | 113206 | Undocumented 4 | Agonis flexuosa :: Peppermint Willow 65 | 50x DASHIELL HAMMETT ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2x2 | 6010410 | 2116139 | 37.7911011617465 | -122.407866810246 | (37.7911011617465, -122.407866810246) | 5 | 1 | 10 | 28857 | 21 | ||||
2188 | 260529 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 1814 43rd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 5982887.98375 | 2102765.67441 | 37.7528026329038 | -122.502100475367 | (37.7528026329038, -122.502100475367) | 1 | 8 | 3 | 56 | 35 | ||||
3053 | 262433 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 470 London St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/05/2019 12:00:00 AM | 3x3 | 6001714 | 2091050 | 37.7217221467453 | -122.43615844491 | (37.7217221467453, -122.43615844491) | 9 | 7 | 6 | 28861 | 5 | |||
3681 | 106711 | Undocumented 4 | Agonis flexuosa :: Peppermint Willow 65 | 3990 FOLSOM ST | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6008366.1 | 2096547.2 | 37.7371919715517 | -122.413552407719 | (37.7371919715517, -122.413552407719) | 2 | 7 | 7 | 28859 | 2 | |||||
4589 | 261026 | Undocumented 4 | Agonis flexuosa :: Peppermint Willow 65 | 758 20th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 11/18/2019 12:00:00 AM | 3x3 | 5989802 | 2110189 | 37.7735888483109 | -122.478733667362 | (37.7735888483109, -122.478733667362) | 11 | 6 | 2 | 55 | 26 | |||
5467 | 261155 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 2119 41st Ave | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | FUF | 3x3 | 5983519 | 2100707 | 37.7471871347586 | -122.499766192027 | (37.7471871347586, -122.499766192027) | 1 | 8 | 3 | 29491 | 35 | |||
6228 | 261512 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 811 35th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/25/2020 12:00:00 AM | Width 3ft | 5985072.23291 | 2110298.05819 | 37.7736125294233 | -122.495102444732 | (37.7736125294233, -122.495102444732) | 11 | 6 | 2 | 55 | 26 | |||
9568 | 261150 | Undocumented 4 | Agonis flexuosa :: Peppermint Willow 65 | 3220x Santiago St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5982825 | 2099474 | 37.7437609086011 | -122.502074725774 | (37.7437609086011, -122.502074725774) | 1 | 8 | 3 | 29491 | 35 | ||||
11799 | 261147 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 3220x Santiago St | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | DPW | 3x3 | 5982825 | 2099474 | 37.7437609086011 | -122.502074725774 | (37.7437609086011, -122.502074725774) | 1 | 8 | 3 | 29491 | 35 | |||
12483 | 261152 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 2279 43rd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 3x3 | 5982935 | 2099631 | 37.7441984490884 | -122.501705991239 | (37.7441984490884, -122.501705991239) | 1 | 8 | 3 | 29491 | 35 | |||
12905 | 261154 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 2246 44th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 3x3 | 5982704 | 2099822 | 37.7447093112365 | -122.502518859637 | (37.7447093112365, -122.502518859637) | 1 | 8 | 3 | 29491 | 35 | |||
13131 | 261138 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 2600 Santiago St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 5984799 | 2099596 | 37.7442116594147 | -122.4952581999 | (37.7442116594147, -122.4952581999) | 1 | 8 | 3 | 29491 | 35 | ||||
14927 | 262428 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 99 France Ave | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Width 0ft | 6001205.1197 | 2090381.66789 | 37.7198581324333 | -122.437869661652 | (37.7198581324333, -122.437869661652) | 9 | 7 | 6 | 28861 | 5 | ||||
15772 | 261153 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 2291 43rd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 3x3 | 5982938 | 2099557 | 37.7439954416833 | -122.501690144388 | (37.7439954416833, -122.501690144388) | 1 | 8 | 3 | 29491 | 35 | |||
16950 | 261148 | Undocumented 4 | Agonis flexuosa :: Peppermint Willow 65 | 3220x Santiago St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5982825 | 2099474 | 37.7437609086011 | -122.502074725774 | (37.7437609086011, -122.502074725774) | 1 | 8 | 3 | 29491 | 35 | ||||
17368 | 261151 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 2107 43rd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | DPW | 3x3 | 5982896 | 2100761 | 37.7472988260012 | -122.501924436785 | (37.7472988260012, -122.501924436785) | 1 | 8 | 3 | 29491 | 35 | |||
19544 | 261022 | Undocumented 4 | Agonis flexuosa :: Peppermint Willow 65 | 393 30th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 11/18/2019 12:00:00 AM | 3x3 | 5986499 | 2113341 | 37.7820510072297 | -122.490391009154 | (37.7820510072297, -122.490391009154) | 11 | 6 | 2 | 55 | 26 | |||
29277 | 256167 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 200 Laguna St | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 6005182.68808 | 2109644.93499 | 37.772976028407 | -122.425490781615 | (37.772976028407, -122.425490781615) | 7 | 9 | 11 | 28852 | 10 | ||||
31564 | 113207 | Undocumented 4 | Agonis flexuosa :: Peppermint Willow 65 | 50x DASHIELL HAMMETT ST | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2x2 | 6010410 | 2116139 | 37.7911011617465 | -122.407866810246 | (37.7911011617465, -122.407866810246) | 5 | 1 | 10 | 28857 | 21 | ||||
49622 | 113208 | Undocumented 4 | Agonis flexuosa :: Peppermint Willow 65 | 50x DASHIELL HAMMETT ST | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2x2 | 6010410 | 2116139 | 37.7911011617465 | -122.407866810246 | (37.7911011617465, -122.407866810246) | 5 | 1 | 10 | 28857 | 21 | ||||
52019 | 119902 | Undocumented 4 | Agonis flexuosa :: Peppermint Willow 65 | 598 Laidley St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6002915 | 2095952 | 37.7352500947879 | -122.43235683741 | (37.7352500947879, -122.43235683741) | 2 | 7 | 5 | 63 | 7 | ||||
57700 | 113210 | Undocumented 4 | Agonis flexuosa :: Peppermint Willow 65 | 50x DASHIELL HAMMETT ST | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2x2 | 6010410 | 2116139 | 37.7911011617465 | -122.407866810246 | (37.7911011617465, -122.407866810246) | 5 | 1 | 10 | 28857 | 21 | ||||
69208 | 119901 | Undocumented 4 | Agonis flexuosa :: Peppermint Willow 65 | 598 Laidley St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6002915 | 2095952 | 37.7352500947879 | -122.43235683741 | (37.7352500947879, -122.43235683741) | 2 | 7 | 5 | 63 | 7 | ||||
73407 | 113205 | Undocumented 4 | Agonis flexuosa :: Peppermint Willow 65 | 50x DASHIELL HAMMETT ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2x2 | 6010410 | 2116139 | 37.7911011617465 | -122.407866810246 | (37.7911011617465, -122.407866810246) | 5 | 1 | 10 | 28857 | 21 | ||||
88447 | 113211 | Undocumented 4 | Agonis flexuosa :: Peppermint Willow 65 | 50x DASHIELL HAMMETT ST | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6010410 | 2116139 | 37.7911011617465 | -122.407866810246 | (37.7911011617465, -122.407866810246) | 5 | 1 | 10 | 28857 | 21 | ||||
112453 | 113209 | Undocumented 4 | Agonis flexuosa :: Peppermint Willow 65 | 50x DASHIELL HAMMETT ST | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2x2 | 6010410 | 2116139 | 37.7911011617465 | -122.407866810246 | (37.7911011617465, -122.407866810246) | 5 | 1 | 10 | 28857 | 21 | ||||
121537 | 256166 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 200 Laguna St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 6005182.68808 | 2109644.93499 | 37.772976028407 | -122.425490781615 | (37.772976028407, -122.425490781615) | 7 | 9 | 11 | 28852 | 10 | ||||
122464 | 94832 | Permitted Site 7 | Agonis flexuosa :: Peppermint Willow 65 | 1212 08th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5993646.6 | 2107243.8 | 37.7657245899289 | -122.465220756233 | (37.7657245899289, -122.465220756233) | 11 | 8 | 11 | 56 | 12 | ||||
128238 | 64300 | Permitted Site 7 | Agonis flexuosa :: Peppermint Willow 65 | 170 Valley St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/21/1987 12:00:00 AM | 6004802.69510738 | 2099321.91565877 | 37.7446099759611 | -122.426070203486 | (37.7446099759611, -122.426070203486) | 2 | 7 | 5 | 63 | 22 | |||
157166 | 106344 | Permitted Site 7 | Agonis flexuosa :: Peppermint Willow 65 | 2428 14th Ave | 1 | Median : Cutout | Tree | Private 2 | 04/18/2014 12:00:00 AM | 3x3 | 5992079 | 2098890.7 | 37.7426986307713 | -122.470034423922 | (37.7426986307713, -122.470034423922) | 1 | 8 | 4 | 29491 | 40 | |||
160970 | 107168 | Undocumented 4 | Agonis flexuosa :: Peppermint Willow 65 | 65 SCOTT ST | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2x2 | 6002336.3 | 2108640.7 | 37.7700574118158 | -122.435264926513 | (37.7700574118158, -122.435264926513) | 15 | 5 | 5 | 29492 | 9 | |||||
172746 | 256165 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 200 Laguna St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 6005182.68808 | 2109644.93499 | 37.772976028407 | -122.425490781615 | (37.772976028407, -122.425490781615) | 7 | 9 | 11 | 28852 | 10 | ||||
172907 | 112365 | Undocumented 4 | Agonis flexuosa :: Peppermint Willow 65 | 501x 09TH AVE | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5993143 | 2111731 | 37.7780161887977 | -122.467288887933 | (37.7780161887977, -122.467288887933) | 11 | 6 | 2 | 54 | 11 | ||||
173139 | 98032 | Permitted Site 7 | Agonis flexuosa :: Peppermint Willow 65 | 132 Clement St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5995145 | 2113574 | 37.783191941507 | -122.460496884135 | (37.783191941507, -122.460496884135) | 11 | 6 | 2 | 54 | 11 | ||||
185739 | 106345 | Permitted Site 7 | Agonis flexuosa :: Peppermint Willow 65 | 2428 14th Ave | 2 | Median : Cutout | Tree | Private 2 | 04/18/2014 12:00:00 AM | 3x3 | 5992079 | 2098890.7 | 37.7426986307713 | -122.470034423922 | (37.7426986307713, -122.470034423922) | 1 | 8 | 4 | 29491 | 40 | |||
189079 | 253703 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 1221 Clayton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5998953 | 2105574 | 37.7614443133046 | -122.446746977382 | (37.7614443133046, -122.446746977382) | 15 | 5 | 11 | 29492 | 12 | ||||
151523 | 55367 | Permitted Site 7 | Agonis flexuosa :: Peppermint Willow 65 | 166 San Aleso Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/12/1996 12:00:00 AM | Permit Number 11301 | 5993332.6421826 | 2094501.86251048 | 37.730720369862 | -122.465380982848 | (37.730720369862, -122.465380982848) | 9 | 8 | 4 | 59 | 40 | ||
161874 | 59173 | Permitted Site 7 | Agonis flexuosa :: Peppermint Willow 65 | 327 Day St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/14/1992 12:00:00 AM | Permit Number 18486 | 6003820.21364245 | 2098630.45378724 | 37.742655803759 | -122.429418128827 | (37.742655803759, -122.429418128827) | 2 | 7 | 5 | 63 | 22 | ||
42101 | 59432 | Permitted Site 7 | Agonis flexuosa :: Peppermint Willow 65 | 3045 Castro St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/24/1994 12:00:00 AM | Permit Number 18794 | 6002901.09620901 | 2096034.49584779 | 37.7354758211207 | -122.432410798093 | (37.7354758211207, -122.432410798093) | 2 | 7 | 5 | 63 | 7 | ||
76041 | 59441 | Permitted Site 7 | Agonis flexuosa :: Peppermint Willow 65 | 98 Bosworth St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/03/1980 12:00:00 AM | Permit Number 18804 | 6004258.9190799 | 2095333.58373446 | 37.7336281759245 | -122.42766636908 | (37.7336281759245, -122.42766636908) | 2 | 7 | 5 | 28861 | 25 | |||
62771 | 62339 | Permitted Site 7 | Agonis flexuosa :: Peppermint Willow 65 | 67 Richland Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/27/1994 12:00:00 AM | Permit Number 22481 | 6004929.22923105 | 2096213.38801269 | 37.7360818148322 | -122.425411499586 | (37.7360818148322, -122.425411499586) | 2 | 7 | 5 | 28859 | 2 | ||
69330 | 62770 | Permitted Site 7 | Agonis flexuosa :: Peppermint Willow 65 | 1622 10th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/12/1986 12:00:00 AM | Permit Number 23124 | 5993110.09884511 | 2104424.43713032 | 37.7579524055375 | -122.466871405848 | (37.7579524055375, -122.466871405848) | 1 | 8 | 4 | 56 | 12 | ||
60347 | 62771 | Permitted Site 7 | Agonis flexuosa :: Peppermint Willow 65 | 1628 10th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/12/1986 12:00:00 AM | Permit Number 23125 | 5993111.44496049 | 2104385.34678202 | 37.7578451513046 | -122.466863908769 | (37.7578451513046, -122.466863908769) | 1 | 8 | 4 | 56 | 12 | ||
132571 | 63129 | Permitted Site 7 | Agonis flexuosa :: Peppermint Willow 65 | 34 Prospect Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/11/1986 12:00:00 AM | Permit Number 23643 | 6007144.61352889 | 2099320.79872129 | 37.7447389927671 | -122.417972215495 | (37.7447389927671, -122.417972215495) | 2 | 7 | 7 | 28859 | 2 | ||
56987 | 63133 | Permitted Site 7 | Agonis flexuosa :: Peppermint Willow 65 | 28 Winfield St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/11/1986 12:00:00 AM | Permit Number 23648 | 6007400.02445462 | 2099399.55358264 | 37.7449696074565 | -122.417094630618 | (37.7449696074565, -122.417094630618) | 2 | 7 | 7 | 28859 | 2 | ||
23336 | 63134 | Permitted Site 7 | Agonis flexuosa :: Peppermint Willow 65 | 27 Winfield St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/11/1986 12:00:00 AM | Permit Number 23649 | 6007447.90223159 | 2099378.78534919 | 37.7449152757931 | -122.416927606356 | (37.7449152757931, -122.416927606356) | 2 | 7 | 7 | 28859 | 2 | ||
35130 | 63135 | Permitted Site 7 | Agonis flexuosa :: Peppermint Willow 65 | 25 Winfield St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/11/1986 12:00:00 AM | Permit Number 23650 | 6007455.65629161 | 2099393.17627053 | 37.7449552262088 | -122.416901813576 | (37.7449552262088, -122.416901813576) | 2 | 7 | 7 | 28859 | 2 | ||
185506 | 63233 | Permitted Site 7 | Agonis flexuosa :: Peppermint Willow 65 | 200x ESMERALDA AVE | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/13/1987 12:00:00 AM | Permit Number 23781 | 6007093 | 2098828 | 37.7433829729046 | -122.41811575542 | (37.7433829729046, -122.41811575542) | 2 | 7 | 7 | 28859 | 2 | ||
193961 | 63264 | Permitted Site 7 | Agonis flexuosa :: Peppermint Willow 65 | 474 Elizabeth St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/19/1999 12:00:00 AM | Permit Number 23819 | 6003326.56560874 | 2102164.81247283 | 37.7523323660448 | -122.431377264225 | (37.7523323660448, -122.431377264225) | 2 | 4 | 5 | 28862 | 22 | ||
129447 | 63292 | Permitted Site 7 | Agonis flexuosa :: Peppermint Willow 65 | 3075 Cesar Chavez St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/26/1987 12:00:00 AM | Permit Number 23858 | 6009183.06965006 | 2100534.27317896 | 37.7481854410784 | -122.411009292537 | (37.7481854410784, -122.411009292537) | 2 | 4 | 7 | 28859 | 2 | ||
33290 | 63461 | Permitted Site 7 | Agonis flexuosa :: Peppermint Willow 65 | 45 Powers Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/16/1987 12:00:00 AM | Permit Number 24052 | 6006867.21716204 | 2099801.68707108 | 37.7460437878528 | -122.418965501899 | (37.7460437878528, -122.418965501899) | 2 | 7 | 7 | 28859 | 2 | ||
77926 | 63770 | Permitted Site 7 | Agonis flexuosa :: Peppermint Willow 65 | 533 Steiner St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/20/1999 12:00:00 AM | Permit Number 24449 | 6003130.90758036 | 2110082.2752919 | 37.7740607150966 | -122.432619380335 | (37.7740607150966, -122.432619380335) | 15 | 9 | 11 | 29492 | 10 | ||
55347 | 63855 | Permitted Site 7 | Agonis flexuosa :: Peppermint Willow 65 | 728 Fell St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/16/1987 12:00:00 AM | Permit Number 24554 | 6003932.92812606 | 2110451.32130531 | 37.7751194750929 | -122.429871382589 | (37.7751194750929, -122.429871382589) | 7 | 9 | 11 | 29492 | 10 | ||
54908 | 63857 | Permitted Site 7 | Agonis flexuosa :: Peppermint Willow 65 | 317 Scott St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/16/1987 12:00:00 AM | Permit Number 24557 | 6002233.40181795 | 2109560.38159908 | 37.7725767859044 | -122.435686656968 | (37.7725767859044, -122.435686656968) | 15 | 5 | 11 | 29492 | 9 | ||
103785 | 63866 | Permitted Site 7 | Agonis flexuosa :: Peppermint Willow 65 | 879 Castro St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/16/1987 12:00:00 AM | Permit Number 24569 | 6002490.08825783 | 2103093.39072976 | 37.7548345785172 | -122.434336316133 | (37.7548345785172, -122.434336316133) | 2 | 4 | 5 | 28862 | 22 | ||
85395 | 64103 | Permitted Site 7 | Agonis flexuosa :: Peppermint Willow 65 | 1274 11th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/18/1987 12:00:00 AM | Permit Number 24869 | 5992719.22945305 | 2106794.6949286 | 37.7644379438855 | -122.468395626163 | (37.7644379438855, -122.468395626163) | 11 | 8 | 11 | 56 | 12 | ||
75026 | 64105 | Permitted Site 7 | Agonis flexuosa :: Peppermint Willow 65 | 531 29th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/18/1987 12:00:00 AM | Permit Number 24871 | 6003137.00791589 | 2098885.2523176 | 37.7433167168502 | -122.431798643811 | (37.7433167168502, -122.431798643811) | 2 | 7 | 5 | 63 | 22 | ||
10364 | 64114 | Permitted Site 7 | Agonis flexuosa :: Peppermint Willow 65 | 1270 11th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/18/1987 12:00:00 AM | Permit Number 24882 | 5992718.32165221 | 2106821.08244246 | 37.7645103445899 | -122.468400685881 | (37.7645103445899, -122.468400685881) | 11 | 8 | 11 | 56 | 12 | ||
168332 | 64134 | Permitted Site 7 | Agonis flexuosa :: Peppermint Willow 65 | 553 29th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/05/1987 12:00:00 AM | Permit Number 24905 | 6003001.41812219 | 2098877.69698992 | 37.743288284611 | -122.432266938445 | (37.743288284611, -122.432266938445) | 2 | 7 | 5 | 63 | 22 | ||
84530 | 62373 | Permitted Site 7 | Agonis flexuosa :: Peppermint Willow 65 | 451 30th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/05/1987 12:00:00 AM | Permit Number 24914 | 6003654.71208885 | 2098328.44048503 | 37.741817173247 | -122.429968846467 | (37.741817173247, -122.429968846467) | 2 | 7 | 5 | 63 | 7 | ||
87022 | 64145 | Permitted Site 7 | Agonis flexuosa :: Peppermint Willow 65 | 447 Day St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/05/1987 12:00:00 AM | Permit Number 24920 | 6002941.41423586 | 2098582.0522051 | 37.7424731102471 | -122.432453304275 | (37.7424731102471, -122.432453304275) | 2 | 7 | 5 | 63 | 22 | ||
126686 | 64148 | Permitted Site 7 | Agonis flexuosa :: Peppermint Willow 65 | 1545 Noe St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/05/1987 12:00:00 AM | Permit Number 24927 | 6003347.08832902 | 2099252.09112644 | 37.7443358777099 | -122.431098417838 | (37.7443358777099, -122.431098417838) | 2 | 7 | 5 | 63 | 22 | ||
149484 | 64150 | Permitted Site 7 | Agonis flexuosa :: Peppermint Willow 65 | 412 Valley St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/05/1987 12:00:00 AM | Permit Number 24929 | 6003228.47286853 | 2099240.58677175 | 37.7442975672349 | -122.431507743694 | (37.7442975672349, -122.431507743694) | 2 | 7 | 5 | 63 | 22 | ||
57703 | 64151 | Permitted Site 7 | Agonis flexuosa :: Peppermint Willow 65 | 432 Valley St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/05/1987 12:00:00 AM | Permit Number 24930 | 6003105.46054998 | 2099234.08620142 | 37.7442727453071 | -122.431932629736 | (37.7442727453071, -122.431932629736) | 2 | 7 | 5 | 63 | 22 | ||
30892 | 64152 | Permitted Site 7 | Agonis flexuosa :: Peppermint Willow 65 | 426 Valley St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/05/1987 12:00:00 AM | Permit Number 24931 | 6003142.3642398 | 2099236.03637221 | 37.7442801920451 | -122.431805163973 | (37.7442801920451, -122.431805163973) | 2 | 7 | 5 | 63 | 22 | ||
98833 | 64258 | Permitted Site 7 | Agonis flexuosa :: Peppermint Willow 65 | 184 Day St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/03/1988 12:00:00 AM | Permit Number 25059 | 6004745.64406041 | 2098733.50242163 | 37.742991103255 | -122.426225591142 | (37.742991103255, -122.426225591142) | 2 | 7 | 5 | 63 | 22 | ||
165722 | 64259 | Permitted Site 7 | Agonis flexuosa :: Peppermint Willow 65 | 118 Day St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/03/1988 12:00:00 AM | Permit Number 25060 | 6005164.43101867 | 2098756.56789098 | 37.7430780980429 | -122.424779179687 | (37.7430780980429, -122.424779179687) | 2 | 7 | 5 | 63 | 22 | ||
21507 | 62444 | Permitted Site 7 | Agonis flexuosa :: Peppermint Willow 65 | 221 29th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/18/1988 12:00:00 AM | Permit Number 25105 | 6005138.76094737 | 2098996.79373606 | 37.7437362535856 | -122.424885027142 | (37.7437362535856, -122.424885027142) | 2 | 7 | 5 | 63 | 22 | ||
105667 | 64297 | Permitted Site 7 | Agonis flexuosa :: Peppermint Willow 65 | 219 29th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/18/1988 12:00:00 AM | Permit Number 25106 | 6005151.45554357 | 2098997.50110191 | 37.7437389128818 | -122.424841182538 | (37.7437389128818, -122.424841182538) | 2 | 7 | 5 | 63 | 22 | ||
171966 | 64298 | Permitted Site 7 | Agonis flexuosa :: Peppermint Willow 65 | 217 29th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/18/1988 12:00:00 AM | Permit Number 25107 | 6005164.15015163 | 2098998.20846843 | 37.7437415721643 | -122.424797337889 | (37.7437415721643, -122.424797337889) | 2 | 7 | 5 | 63 | 22 | ||
3753 | 64301 | Permitted Site 7 | Agonis flexuosa :: Peppermint Willow 65 | 151 Valley St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/17/1988 12:00:00 AM | Permit Number 25112 | 6004932.6099578 | 2099277.06478887 | 37.7444941674798 | -122.425617791869 | (37.7444941674798, -122.425617791869) | 2 | 7 | 5 | 63 | 22 | ||
37651 | 64302 | Permitted Site 7 | Agonis flexuosa :: Peppermint Willow 65 | 121 Valley St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/10/1988 12:00:00 AM | Permit Number 25113 | 6005123.1483335 | 2099287.66798911 | 37.7445340460317 | -122.42495970266 | (37.7445340460317, -122.42495970266) | 2 | 7 | 5 | 63 | 22 | ||
98307 | 64417 | Permitted Site 7 | Agonis flexuosa :: Peppermint Willow 65 | 48 Harper St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/03/1988 12:00:00 AM | Permit Number 25265 | 6003653.48603698 | 2098020.8724606 | 37.7409725927511 | -122.429951151332 | (37.7409725927511, -122.429951151332) | 2 | 7 | 5 | 63 | 7 | ||
172119 | 64418 | Permitted Site 7 | Agonis flexuosa :: Peppermint Willow 65 | 76 Harper St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/11/1988 12:00:00 AM | Permit Number 25266 | 6003598.76227624 | 2097871.53968329 | 37.7405594599669 | -122.430129715298 | (37.7405594599669, -122.430129715298) | 2 | 7 | 5 | 63 | 7 | ||
178793 | 64789 | Permitted Site 7 | Agonis flexuosa :: Peppermint Willow 65 | 214 Pierce St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/10/1989 12:00:00 AM | Permit Number 25785 | 6002808.76039687 | 2109284.75060862 | 37.7718526350484 | -122.433676731328 | (37.7718526350484, -122.433676731328) | 15 | 5 | 11 | 29492 | 9 | ||
61402 | 64790 | Permitted Site 7 | Agonis flexuosa :: Peppermint Willow 65 | 221 Pierce St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/11/1989 12:00:00 AM | Permit Number 25786 | 6002754.53875379 | 2109297.20875 | 37.7718837652657 | -122.433865178188 | (37.7718837652657, -122.433865178188) | 15 | 5 | 11 | 29492 | 9 | ||
101142 | 65305 | Permitted Site 7 | Agonis flexuosa :: Peppermint Willow 65 | 3629 19th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/23/1989 12:00:00 AM | Permit Number 28122 | 6005455.44263685 | 2104863.06150764 | 37.7598615508482 | -122.424207139046 | (37.7598615508482, -122.424207139046) | 2 | 4 | 5 | 28859 | 19 | ||
30781 | 65559 | Permitted Site 7 | Agonis flexuosa :: Peppermint Willow 65 | 301 Casitas Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/11/1990 12:00:00 AM | Permit Number 28458 | 5995039.18564511 | 2096207.71663667 | 37.735502500801 | -122.459604741585 | (37.735502500801, -122.459604741585) | 9 | 7 | 4 | 59 | 40 | ||
31519 | 65560 | Permitted Site 7 | Agonis flexuosa :: Peppermint Willow 65 | 310 Casitas Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/11/1990 12:00:00 AM | Permit Number 28459 | 5995012.80467967 | 2096143.76494049 | 37.7353253881276 | -122.459691319295 | (37.7353253881276, -122.459691319295) | 9 | 7 | 4 | 59 | 40 | ||
68752 | 65658 | Permitted Site 7 | Agonis flexuosa :: Peppermint Willow 65 | 72 Molimo Dr | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/12/1990 12:00:00 AM | Permit Number 28578 | 5998676.92004406 | 2096648.99460169 | 37.7369226528823 | -122.44705951572 | (37.7369226528823, -122.44705951572) | 9 | 7 | 4 | 59 | 40 | ||
85940 | 65809 | Permitted Site 7 | Agonis flexuosa :: Peppermint Willow 65 | 2268 16th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/21/1990 12:00:00 AM | Permit Number 28777 | 5991325.30735018 | 2099972.38049218 | 37.7456250483576 | -122.472719302053 | (37.7456250483576, -122.472719302053) | 1 | 8 | 4 | 29491 | 40 | ||
89653 | 66234 | Permitted Site 7 | Agonis flexuosa :: Peppermint Willow 65 | 211 Miramar Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/24/1990 12:00:00 AM | Permit Number 29332 | 5995321.94630668 | 2091329.89787669 | 37.7221254446058 | -122.458274198204 | (37.7221254446058, -122.458274198204) | 9 | 8 | 4 | 28861 | 24 | ||
104709 | 66250 | Permitted Site 7 | Agonis flexuosa :: Peppermint Willow 65 | 718 Holloway Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/24/1990 12:00:00 AM | Permit Number 29350 | 5994696.57852166 | 2091262.84709817 | 37.721905383508 | -122.460431070774 | (37.721905383508, -122.460431070774) | 9 | 8 | 4 | 28861 | 24 | ||
19668 | 66266 | Permitted Site 7 | Agonis flexuosa :: Peppermint Willow 65 | 658 Rockdale Dr | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/30/1990 12:00:00 AM | Permit Number 29373 | 5997726.05518981 | 2098148.01561628 | 37.7409842298876 | -122.450455094169 | (37.7409842298876, -122.450455094169) | 9 | 7 | 4 | 59 | 40 | ||
83501 | 66304 | Permitted Site 7 | Agonis flexuosa :: Peppermint Willow 65 | 400 Congo St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/07/1990 12:00:00 AM | 3x50 | Permit Number 29418 | 6000123.45614997 | 2094964.38431909 | 37.732379648564 | -122.44193733537 | (37.732379648564, -122.44193733537) | 9 | 7 | 5 | 63 | 40 | |
86106 | 66313 | Permitted Site 7 | Agonis flexuosa :: Peppermint Willow 65 | 22 Joost Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/07/1990 12:00:00 AM | Permit Number 29428 | 6001939.09148098 | 2094954.61972241 | 37.7324561325978 | -122.435659572604 | (37.7324561325978, -122.435659572604) | 9 | 7 | 5 | 63 | 40 | ||
20861 | 66314 | Permitted Site 7 | Agonis flexuosa :: Peppermint Willow 65 | 32 Joost Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/07/1990 12:00:00 AM | Permit Number 29429 | 6001885.6486627 | 2094955.45184976 | 37.7324553817298 | -122.435844396286 | (37.7324553817298, -122.435844396286) | 9 | 7 | 5 | 63 | 40 | ||
22865 | 66317 | Permitted Site 7 | Agonis flexuosa :: Peppermint Willow 65 | 125 Joost Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/07/1990 12:00:00 AM | Permit Number 29434 | 6001244.97910985 | 2094913.4211357 | 37.732303560745 | -122.438056328119 | (37.732303560745, -122.438056328119) | 9 | 7 | 4 | 63 | 40 | ||
60112 | 66322 | Permitted Site 7 | Agonis flexuosa :: Peppermint Willow 65 | 268 Joost Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/05/1990 12:00:00 AM | Permit Number 29439 | 6000307.14957074 | 2094979.56664824 | 37.7324318016212 | -122.441303355183 | (37.7324318016212, -122.441303355183) | 9 | 7 | 5 | 63 | 40 | ||
135471 | 66323 | Permitted Site 7 | Agonis flexuosa :: Peppermint Willow 65 | 274 Joost Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/05/1990 12:00:00 AM | Permit Number 29440 | 6000269.21852417 | 2094980.11816522 | 37.7324311551198 | -122.441434530926 | (37.7324311551198, -122.441434530926) | 9 | 7 | 5 | 63 | 40 | ||
74836 | 66622 | Permitted Site 7 | Agonis flexuosa :: Peppermint Willow 65 | 867 Hampshire St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/15/1991 12:00:00 AM | Permit Number 29826 | 6010209.78585513 | 2104179.32451342 | 37.7582514640983 | -122.407715901057 | (37.7582514640983, -122.407715901057) | 10 | 4 | 7 | 28859 | 19 | ||
47906 | 67034 | Permitted Site 7 | Agonis flexuosa :: Peppermint Willow 65 | 3947 23rd St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/13/1992 12:00:00 AM | Permit Number 30406 | 6003485.5850907 | 2102413.54143102 | 37.7530243281476 | -122.430845098487 | (37.7530243281476, -122.430845098487) | 2 | 4 | 5 | 28862 | 22 | ||
84903 | 67260 | Permitted Site 7 | Agonis flexuosa :: Peppermint Willow 65 | 596 39th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/08/1992 12:00:00 AM | Permit Number 30727 | 5983830.17257963 | 2111769.87555254 | 37.7775809215722 | -122.499507644306 | (37.7775809215722, -122.499507644306) | 11 | 6 | 2 | 55 | 26 | ||
26083 | 65485 | Permitted Site 7 | Agonis flexuosa :: Peppermint Willow 65 | 436 Webster St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/08/1992 12:00:00 AM | Permit Number 30733 | 6004123.88206182 | 2110310.82859854 | 37.7747445284274 | -122.429200810683 | (37.7747445284274, -122.429200810683) | 7 | 9 | 11 | 28852 | 10 | ||
55051 | 67285 | Permitted Site 7 | Agonis flexuosa :: Peppermint Willow 65 | 119 Vienna St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/22/1992 12:00:00 AM | Permit Number 30761 | 6004716.66423484 | 2092675.63660854 | 37.7263559262182 | -122.425894675863 | (37.7263559262182, -122.425894675863) | 9 | 7 | 6 | 28861 | 5 | ||
83852 | 67386 | Permitted Site 7 | Agonis flexuosa :: Peppermint Willow 65 | 725 14th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/28/1992 12:00:00 AM | Permit Number 30883 | 5991613.49950521 | 2110478.88524866 | 37.7744898098292 | -122.47248861667 | (37.7744898098292, -122.47248861667) | 11 | 6 | 2 | 54 | 26 | ||
16080 | 67500 | Permitted Site 7 | Agonis flexuosa :: Peppermint Willow 65 | 518 Hearst Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/15/1997 12:00:00 AM | Permit Number 31028 | 5997975.78487802 | 2094419.07569222 | 37.7307597431483 | -122.449323026732 | (37.7307597431483, -122.449323026732) | 9 | 7 | 4 | 59 | 40 | ||
102715 | 67506 | Permitted Site 7 | Agonis flexuosa :: Peppermint Willow 65 | 431 Flood Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/16/1992 12:00:00 AM | Permit Number 31036 | 5997894.54403764 | 2094074.0284741 | 37.7298076778319 | -122.449579034013 | (37.7298076778319, -122.449579034013) | 9 | 7 | 4 | 28861 | 40 | ||
183603 | 67515 | Permitted Site 7 | Agonis flexuosa :: Peppermint Willow 65 | 179 Staples Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/22/1992 12:00:00 AM | Permit Number 31051 | 5998906.63498153 | 2093763.92891486 | 37.7290140653184 | -122.446057838601 | (37.7290140653184, -122.446057838601) | 9 | 7 | 4 | 28861 | 40 |
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) );