trees
193 rows where Fire Prevention Districts = 9 and qSpecies_id = 65 sorted by qAddress
This data as json, CSV (advanced)
PermitNotes ✖
- - 123
- Permit Number 42524 6
- Permit Number 32829 2
- Permit Number 39011 2
- Permit Number 45042 2
- Permit Number 772762 2
- Permit Number 774164 2
- Permit Number 11301 1
- Permit Number 28018 1
- Permit Number 28410 1
- Permit Number 28458 1
- Permit Number 28459 1
- Permit Number 28578 1
- Permit Number 28650 1
- Permit Number 29332 1
- Permit Number 29350 1
- Permit Number 29373 1
- Permit Number 29418 1
- Permit Number 29428 1
- Permit Number 29429 1
- Permit Number 29434 1
- Permit Number 29439 1
- Permit Number 29440 1
- Permit Number 30761 1
- Permit Number 30767 1
- Permit Number 31028 1
- Permit Number 31036 1
- Permit Number 31051 1
- Permit Number 31611 1
- Permit Number 31614 1
- ...
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
13677 | 73831 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 102 Teddy Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 19 | 6010808.25129 | 2088026.19044 | 37.713931877121 | -122.404509096323 | (37.713931877121, -122.404509096323) | 9 | 7 | 8 | 309 | 39 | |||
730 | 160454 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 11 France Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/05/2019 12:00:00 AM | 0 | Width 0ft | 6001177.46897 | 2090398.6691 | 37.7199032415307 | -122.437966457494 | (37.7199032415307, -122.437966457494) | 9 | 7 | 6 | 28861 | 5 | ||
19536 | 160455 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 11 France Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/05/2019 12:00:00 AM | 0 | Width 0ft | 6001161.40103 | 2090408.94535 | 37.719930544037 | -122.438022734371 | (37.719930544037, -122.438022734371) | 9 | 7 | 6 | 28861 | 5 | ||
48996 | 94666 | Permitted Site 7 | Agonis flexuosa :: Peppermint Willow 65 | 115 Cuvier St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/22/2010 12:00:00 AM | 3x3 | Permit Number 53803 | 6004020 | 2095225 | 37.7333165119994 | -122.428484644893 | (37.7333165119994, -122.428484644893) | 9 | 7 | 5 | 28861 | 25 | |
152880 | 221838 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 115 Cuvier St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6004035.03303 | 2095100.17103 | 37.7329746104714 | -122.42842377735 | (37.7329746104714, -122.42842377735) | 9 | 7 | 5 | 28861 | 25 | |||
53331 | 203580 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 118 Flood Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 26 | Width 3ft | 5999938.98985 | 2094086.49898 | 37.7299586665457 | -122.442512069977 | (37.7299586665457, -122.442512069977) | 9 | 7 | 4 | 63 | 40 | |||
78160 | 68831 | Permitted Site 7 | Agonis flexuosa :: Peppermint Willow 65 | 118 Flood Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/30/1993 12:00:00 AM | Permit Number 32782 | 5999950.39080564 | 2094093.84509942 | 37.729979487143 | -122.442473182831 | (37.729979487143, -122.442473182831) | 9 | 7 | 4 | 63 | 40 | ||
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 | ||
62808 | 67908 | Permitted Site 7 | Agonis flexuosa :: Peppermint Willow 65 | 120 Judson Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/22/1993 12:00:00 AM | Permit Number 31611 | 5999270.9302444 | 2093516.90049213 | 37.7283565792877 | -122.44478069728 | (37.7283565792877, -122.44478069728) | 9 | 7 | 4 | 28861 | 40 | ||
172281 | 203590 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 120 Judson Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 5999238.54402 | 2093513.75556 | 37.7283460957772 | -122.444892431558 | (37.7283460957772, -122.444892431558) | 9 | 7 | 4 | 28861 | 40 | |||
76757 | 203585 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 122 Detroit St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 2ft | 5999428.77785 | 2093578.76175 | 37.7285354426355 | -122.444239456297 | (37.7285354426355, -122.444239456297) | 9 | 7 | 4 | 63 | 40 | |||
176909 | 68818 | Permitted Site 7 | Agonis flexuosa :: Peppermint Willow 65 | 122 Detroit St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/30/1993 12:00:00 AM | Permit Number 32765 | 5999442.86322085 | 2093551.99082798 | 37.7284627395009 | -122.444188839651 | (37.7284627395009, -122.444188839651) | 9 | 7 | 4 | 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 | ||
7022 | 70397 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 130 Oxford St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 21 | 6006350.25387 | 2093285.00079 | 37.7281212922586 | -122.420290654116 | (37.7281212922586, -122.420290654116) | 9 | 7 | 7 | 309 | 5 | |||
141890 | 39929 | Permitted Site 7 | Agonis flexuosa :: Peppermint Willow 65 | 137 Arleta Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/25/1999 12:00:00 AM | Permit Number 767825 | 6010490.84450997 | 2087849.27835868 | 37.7134283686634 | -122.405593725995 | (37.7134283686634, -122.405593725995) | 9 | 7 | 8 | 309 | 39 | ||
138 | 203559 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 145 Lakeview Ave | 1 | : | Tree | Private 2 | 1 | Width 3ft | 5997146.51683 | 2089373.33367 | 37.7168578537955 | -122.45182605794 | (37.7168578537955, -122.45182605794) | 9 | 8 | 6 | 28861 | 24 | |||
6932 | 112764 | Permitted Site 7 | Agonis flexuosa :: Peppermint Willow 65 | 145 Lakeview Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/19/2015 12:00:00 AM | Permit Number 774164 | 5997123.4 | 2089342.1 | 37.7167707693614 | -122.45190370908 | (37.7167707693614, -122.45190370908) | 9 | 8 | 6 | 28861 | 24 | ||
103379 | 60473 | Permitted Site 7 | Agonis flexuosa :: Peppermint Willow 65 | 145 Lakeview Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/19/2015 12:00:00 AM | Permit Number 774164 | 5997228.1128738 | 2089314.92516138 | 37.7167021506206 | -122.451539811129 | (37.7167021506206, -122.451539811129) | 9 | 8 | 6 | 28861 | 24 | |||
118838 | 203560 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 145 Lakeview Ave | 2 | : | Tree | Private 2 | 1 | Width 3ft | 5997153.12879 | 2089368.29033 | 37.7168443846497 | -122.451802840126 | (37.7168443846497, -122.451802840126) | 9 | 8 | 6 | 28861 | 24 | |||
8616 | 47055 | Permitted Site 7 | Agonis flexuosa :: Peppermint Willow 65 | 149 Casitas Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/02/2002 12:00:00 AM | Permit Number 45042 | 5994940.24503133 | 2097052.6739603 | 37.7378168558175 | -122.460008006142 | (37.7378168558175, -122.460008006142) | 9 | 7 | 4 | 59 | 40 | ||
91379 | 47054 | Permitted Site 7 | Agonis flexuosa :: Peppermint Willow 65 | 149 Casitas Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/02/2002 12:00:00 AM | Permit Number 45042 | 5994940.24503133 | 2097052.6739603 | 37.7378168558175 | -122.460008006142 | (37.7378168558175, -122.460008006142) | 9 | 7 | 4 | 59 | 40 | |||
102836 | 203534 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 149 Casitas Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 2ft | 5995350.02472 | 2096965.99603 | 37.7376024192215 | -122.45858493525 | (37.7376024192215, -122.45858493525) | 9 | 7 | 4 | 59 | 40 | |||
150799 | 203533 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 149 Casitas Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 2ft | 5995336.83178 | 2096965.96659 | 37.737601580145 | -122.458630547087 | (37.737601580145, -122.458630547087) | 9 | 7 | 4 | 59 | 40 | |||
76373 | 175196 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 149 London St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 4ft | 6002904.02638 | 2092823.59155 | 37.7266595719653 | -122.432171435767 | (37.7266595719653, -122.432171435767) | 9 | 7 | 6 | 28861 | 5 | |||
156296 | 87374 | Permitted Site 7 | Agonis flexuosa :: Peppermint Willow 65 | 149 Staples Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | Permit Number 50353 | 5999085.2 | 2093741.7 | 37.7289632252792 | -122.445438930282 | (37.7289632252792, -122.445438930282) | 9 | 7 | 4 | 28861 | 40 | |||
110481 | 175078 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 1584 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 3ft | 6001809.64472 | 2092991.82578 | 37.7270593952569 | -122.435966703417 | (37.7270593952569, -122.435966703417) | 9 | 7 | 6 | 28861 | 25 | |||
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 | ||
190685 | 39931 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 175 Arleta Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/25/1999 12:00:00 AM | 16 | Permit Number 41202 | 6010293.70332 | 2087956.69983 | 37.7137123004597 | -122.406282682604 | (37.7137123004597, -122.406282682604) | 9 | 7 | 8 | 309 | 39 | |
72103 | 40424 | Permitted Site 7 | Agonis flexuosa :: Peppermint Willow 65 | 175 Valdez Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/31/2016 12:00:00 AM | 3 | Permit Number 778380 | 5996165.75170379 | 2094545.8989408 | 37.7310042675093 | -122.455589722394 | (37.7310042675093, -122.455589722394) | 9 | 7 | 4 | 28861 | 40 | |
80252 | 112745 | Permitted Site 7 | Agonis flexuosa :: Peppermint Willow 65 | 179 Caine Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/22/2014 12:00:00 AM | Permit Number 774163 | 5997059.3 | 2088800.2 | 37.7152791660762 | -122.452086194059 | (37.7152791660762, -122.452086194059) | 9 | 8 | 6 | 28861 | 24 | ||
87773 | 203558 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 179 Caine Ave | 1 | : | Tree | Private 2 | 3 | Width 3ft | 5997048.33435 | 2088809.54157 | 37.7153041877202 | -122.45212476956 | (37.7153041877202, -122.45212476956) | 9 | 8 | 6 | 28861 | 24 | |||
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 | ||
83049 | 39933 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 180 Arleta Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/25/1999 12:00:00 AM | 17 | Permit Number 41204 | 6010299.07366 | 2087996.8284 | 37.7138227857583 | -122.406266946271 | (37.7138227857583, -122.406266946271) | 9 | 7 | 8 | 309 | 39 | |
67282 | 203548 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 181 Flood Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 5999484.36005 | 2094058.99303 | 37.7298572167403 | -122.444081798854 | (37.7298572167403, -122.444081798854) | 9 | 7 | 4 | 63 | 40 | |||
117173 | 203550 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 181 Flood Ave | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 5999525.01063 | 2094056.66117 | 37.7298531329131 | -122.443941098101 | (37.7298531329131, -122.443941098101) | 9 | 7 | 4 | 63 | 40 | |||
138666 | 203551 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 181 Flood Ave | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 23 | Width 3ft | 5999536.14329 | 2094057.1534 | 37.7298551194964 | -122.443902646692 | (37.7298551194964, -122.443902646692) | 9 | 7 | 4 | 63 | 40 | |||
142087 | 203547 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 181 Flood Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 22 | Width 3ft | 5999467.73526 | 2094058.60837 | 37.7298552121426 | -122.444139244847 | (37.7298552121426, -122.444139244847) | 9 | 7 | 4 | 63 | 40 | |||
165676 | 203552 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 181 Flood Ave | 11 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 3ft | 5999546.8407 | 2094056.93019 | 37.7298551168086 | -122.443865648605 | (37.7298551168086, -122.443865648605) | 9 | 7 | 4 | 63 | 40 | |||
169633 | 203549 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 181 Flood Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | Width 3ft | 5999506.56732 | 2094057.55855 | 37.7298545448296 | -122.444004922987 | (37.7298545448296, -122.444004922987) | 9 | 7 | 4 | 63 | 40 | |||
69898 | 175184 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 190 Newton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6001047.00422 | 2087602.25445 | 37.7122174923141 | -122.438217204682 | (37.7122174923141, -122.438217204682) | 9 | 7 | 6 | 28861 | 5 | |||
164548 | 175191 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 193 Arleta Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 17 | Width 3ft | 6010202.71269 | 2087988.02388 | 37.7137932196449 | -122.406599386967 | (37.7137932196449, -122.406599386967) | 9 | 7 | 8 | 309 | 39 | |||
20115 | 97549 | Permitted Site 7 | Agonis flexuosa :: Peppermint Willow 65 | 199x FLOOD AVE | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 20 | 3x3 | Permit Number 42524 | 5999753 | 2094070 | 37.7299027608053 | -122.443153872698 | (37.7299027608053, -122.443153872698) | 9 | 7 | 4 | 63 | 40 | ||
23012 | 97550 | Permitted Site 7 | Agonis flexuosa :: Peppermint Willow 65 | 199x FLOOD AVE | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | 3x3 | Permit Number 42524 | 5999753 | 2094070 | 37.7299027608053 | -122.443153872698 | (37.7299027608053, -122.443153872698) | 9 | 7 | 4 | 63 | 40 | ||
145681 | 97551 | Permitted Site 7 | Agonis flexuosa :: Peppermint Willow 65 | 199x FLOOD AVE | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 42524 | 5999753 | 2094070 | 37.7299027608053 | -122.443153872698 | (37.7299027608053, -122.443153872698) | 9 | 7 | 4 | 63 | 40 | ||||
16252 | 203564 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 202 Elmwood Way | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 18 | Width 3ft | 5994856.42725 | 2092686.28381 | 37.7258229929193 | -122.459981583277 | (37.7258229929193, -122.459981583277) | 9 | 8 | 4 | 28861 | 40 | |||
93586 | 102654 | Permitted Site 7 | Agonis flexuosa :: Peppermint Willow 65 | 203X Farallones St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | 3x3 | 5995004 | 2088355 | 37.7139388056528 | -122.459157943572 | (37.7139388056528, -122.459157943572) | 9 | 8 | 6 | 28861 | 24 | |||
169503 | 65718 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 206 Pope St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/18/1990 12:00:00 AM | 22 | Permit Number 28650 | 6000369.4893 | 2087691.53319 | 37.7124240746766 | -122.440565289581 | (37.7124240746766, -122.440565289581) | 9 | 7 | 6 | 28861 | 5 | |
93237 | 203567 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 209 Colon Ave | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 18 | Width 3ft | 5996068.02094 | 2094221.27645 | 37.7301073235953 | -122.455904133578 | (37.7301073235953, -122.455904133578) | 9 | 7 | 4 | 28861 | 40 | |||
159587 | 203566 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 209 Colon Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 17 | Width 3ft | 5996063.41122 | 2094232.89601 | 37.7301389635391 | -122.455920909543 | (37.7301389635391, -122.455920909543) | 9 | 7 | 4 | 28861 | 40 | |||
119492 | 203554 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 209 Farallones St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 2ft | 5994942.92929 | 2088379.09284 | 37.7140014477918 | -122.459370769157 | (37.7140014477918, -122.459370769157) | 9 | 8 | 6 | 28861 | 24 | |||
159787 | 203555 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 209 Farallones St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 2ft | 5994968.99544 | 2088379.28856 | 37.7140034838548 | -122.459280689461 | (37.7140034838548, -122.459280689461) | 9 | 8 | 6 | 28861 | 24 | |||
160387 | 203556 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 209 Farallones St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 2ft | 5994991.30881 | 2088378.07982 | 37.7140014477822 | -122.45920347906 | (37.7140014477822, -122.45920347906) | 9 | 8 | 6 | 28861 | 24 | |||
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 | ||
146650 | 170415 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 216 Theresa St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/07/2018 12:00:00 AM | 3 | Width 3ft | Permit Number 779296 | 6001929.08412 | 2093967.91374 | 37.7297462952572 | -122.435623604862 | (37.7297462952572, -122.435623604862) | 9 | 7 | 6 | 28861 | 25 | |
94208 | 52929 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 22 Cotter St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/03/2006 12:00:00 AM | 3 | 3x3 | Permit Number 48913 | 6002555.71096 | 2093126.63865 | 37.7274719160952 | -122.433397195531 | (37.7274719160952, -122.433397195531) | 9 | 7 | 6 | 28861 | 25 |
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 | ||
105355 | 203573 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 22 Joost Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | Width 4ft | 6001918.41123 | 2094952.28541 | 37.7324485484508 | -122.435730902059 | (37.7324485484508, -122.435730902059) | 9 | 7 | 5 | 63 | 40 | |||
69909 | 175176 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 226 Rome St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 15 | Width 3ft | 5998630.92665 | 2088821.65601 | 37.7154279802818 | -122.446655529047 | (37.7154279802818, -122.446655529047) | 9 | 7 | 6 | 28861 | 25 | |||
158268 | 81935 | Permitted Site 7 | Agonis flexuosa :: Peppermint Willow 65 | 23 Gaviota Way | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/25/2007 12:00:00 AM | 3x3 | Permit Number 49833 | 5998498.7012246 | 2097562.09988585 | 37.7394196374476 | -122.447741409302 | (37.7394196374476, -122.447741409302) | 9 | 7 | 4 | 59 | 40 | ||
95940 | 68849 | Permitted Site 7 | Agonis flexuosa :: Peppermint Willow 65 | 230 Flood Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/28/1993 12:00:00 AM | Permit Number 32812 | 5999215.30905725 | 2094104.51871766 | 37.7299668673625 | -122.44501520736 | (37.7299668673625, -122.44501520736) | 9 | 7 | 4 | 28861 | 40 | ||
156178 | 175175 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 231 Rome St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 20 | Width 3ft | 5998599.64276 | 2088795.69735 | 37.7153549166607 | -122.446761792925 | (37.7153549166607, -122.446761792925) | 9 | 7 | 6 | 28861 | 25 | |||
146877 | 203582 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 24 Gennessee St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 4ft | 5997457.41638 | 2093726.64675 | 37.7288288329774 | -122.451065185614 | (37.7288288329774, -122.451065185614) | 9 | 7 | 4 | 28861 | 40 | |||
148858 | 203581 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 24 Gennessee St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 19 | Width 4ft | 5997456.8868 | 2093709.98189 | 37.7287830449036 | -122.451065815142 | (37.7287830449036, -122.451065815142) | 9 | 7 | 4 | 28861 | 40 | |||
189738 | 203583 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 24 Gennessee St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 5997456.92965 | 2093746.95791 | 37.72888457474 | -122.451068332359 | (37.72888457474, -122.451068332359) | 9 | 7 | 4 | 28861 | 40 | |||
2206 | 70527 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 25 Madrid St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 7 | 6004201.75826 | 2093380.33154 | 37.7282617492704 | -122.427724869209 | (37.7282617492704, -122.427724869209) | 9 | 7 | 6 | 28861 | 5 | |||
87726 | 97554 | Permitted Site 7 | Agonis flexuosa :: Peppermint Willow 65 | 250@Flood Detroit St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 42524 | 5999434 | 2093931 | 37.7295029047189 | -122.444246704733 | (37.7295029047189, -122.444246704733) | 9 | 7 | 4 | 63 | 40 | ||||
107628 | 97552 | Permitted Site 7 | Agonis flexuosa :: Peppermint Willow 65 | 250@Flood Detroit St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 42524 | 5999434 | 2093931 | 37.7295029047189 | -122.444246704733 | (37.7295029047189, -122.444246704733) | 9 | 7 | 4 | 63 | 40 | ||||
139304 | 97553 | Permitted Site 7 | Agonis flexuosa :: Peppermint Willow 65 | 250@Flood Detroit St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 42524 | 5999434 | 2093931 | 37.7295029047189 | -122.444246704733 | (37.7295029047189, -122.444246704733) | 9 | 7 | 4 | 63 | 40 | ||||
63762 | 53384 | Permitted Site 7 | Agonis flexuosa :: Peppermint Willow 65 | 259 Faxon Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/21/2016 12:00:00 AM | Permit Number 772607 | 5994713.25997575 | 2090306.35958478 | 37.7192800571495 | -122.460304141 | (37.7192800571495, -122.460304141) | 9 | 8 | 6 | 28861 | 24 | ||
182887 | 203553 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 259 Faxon Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 5994715.67756 | 2090305.5088 | 37.7192778601644 | -122.46029572277 | (37.7192778601644, -122.46029572277) | 9 | 8 | 6 | 28861 | 24 | |||
13672 | 70491 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 26 Ina Ct | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 18 | 6005035.04728 | 2091735.87999 | 37.7237935486115 | -122.424727215697 | (37.7237935486115, -122.424727215697) | 9 | 7 | 6 | 28861 | 5 | |||
127600 | 39936 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 262 Arleta Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/25/1999 12:00:00 AM | 11 | Permit Number 41207 | 6009779.33678 | 2088185.9421 | 37.7143129666441 | -122.408076686195 | (37.7143129666441, -122.408076686195) | 9 | 7 | 8 | 309 | 39 | |
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 | ||
102685 | 203577 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 268 Joost Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 23 | Width 4ft | 6000290.88836 | 2094968.30244 | 37.7323999463844 | -122.441358765897 | (37.7323999463844, -122.441358765897) | 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 | ||
172010 | 175193 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 28 Harrington St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6002083.86995 | 2092418.47999 | 37.7255006920777 | -122.434977725241 | (37.7255006920777, -122.434977725241) | 9 | 7 | 6 | 28861 | 25 | |||
63890 | 35857 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 28 Santa Rosa Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/23/1998 12:00:00 AM | 28 | 4x6 | Permit Number 39076 | 6002203.07861 | 2092639.23336 | 37.7261135989609 | -122.434581409299 | (37.7261135989609, -122.434581409299) | 9 | 7 | 6 | 28861 | 25 |
95563 | 38954 | Permitted Site 7 | Agonis flexuosa :: Peppermint Willow 65 | 293 Joost Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/30/2008 12:00:00 AM | 3x3 | Permit Number 50374 | 6000154.66929043 | 2094929.77821336 | 37.73228640687 | -122.441826941763 | (37.73228640687, -122.441826941763) | 9 | 7 | 4 | 63 | 40 | ||
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 | ||
171216 | 203540 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 305 Foerster St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 3ft | 5998091.57112 | 2094441.2535 | 37.7308272605603 | -122.448924334186 | (37.7308272605603, -122.448924334186) | 9 | 7 | 4 | 59 | 40 | |||
18137 | 70176 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 307 Athens St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 14 | 3.5x4 to 3.5x7 | 6004287.81152 | 2091470.53201 | 37.7230227297861 | -122.42729139329 | (37.7230227297861, -122.42729139329) | 9 | 7 | 6 | 28861 | 5 | ||
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 | ||
46307 | 203579 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 312 Joost Ave | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 14 | Width 6ft | 5999939.25303 | 2094981.39881 | 37.7324158679899 | -122.44257538767 | (37.7324158679899, -122.44257538767) | 9 | 7 | 4 | 63 | 40 | |||
139320 | 203578 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 312 Joost Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 3ft | 5999939.80462 | 2094974.46238 | 37.7323968536154 | -122.442572982852 | (37.7323968536154, -122.442572982852) | 9 | 7 | 4 | 63 | 40 | |||
111548 | 203537 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 313 Hearst Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | 2X2 | 5999311.41277 | 2094355.91227 | 37.7306626198655 | -122.44470102883 | (37.7306626198655, -122.44470102883) | 9 | 7 | 4 | 28861 | 40 | |||
127453 | 203538 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 313 Hearst Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 2ft | 5999326.9827 | 2094355.31618 | 37.7306618716326 | -122.444647158563 | (37.7306618716326, -122.444647158563) | 9 | 7 | 4 | 28861 | 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 | ||
99091 | 203574 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 32 Joost Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | Width 4ft | 6001891.78226 | 2094951.97424 | 37.7324461814313 | -122.435822942293 | (37.7324461814313, -122.435822942293) | 9 | 7 | 5 | 63 | 40 | |||
40890 | 203565 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 33 Pinehurst Way | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 5993248.53272 | 2093275.53129 | 37.7273483150682 | -122.465582702207 | (37.7273483150682, -122.465582702207) | 9 | 8 | 4 | 59 | 40 | |||
20955 | 203536 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 347 Hearst Ave | 1 | Sidewalk: Curb side : Pot | Tree | Private 2 | 4 | Width 6ft | 5999101.32072 | 2094349.11818 | 37.7306319736778 | -122.445426858158 | (37.7306319736778, -122.445426858158) | 9 | 7 | 4 | 28861 | 40 | |||
20470 | 203539 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 350 Hearst Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 2ft | 5999078.20964 | 2094394.83884 | 37.7307561925253 | -122.445510042754 | (37.7307561925253, -122.445510042754) | 9 | 7 | 4 | 59 | 40 | |||
137107 | 108890 | Permitted Site 7 | Agonis flexuosa :: Peppermint Willow 65 | 350 Hearst Ave | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/08/2015 12:00:00 AM | 3 | 3x3 | Permit Number 773349 | 5999093.24367 | 2094395.39174 | 37.7307585689262 | -122.445458107682 | (37.7307585689262, -122.445458107682) | 9 | 7 | 4 | 59 | 40 | |
4556 | 35737 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 351 Hale St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/14/1998 12:00:00 AM | 11 | Permit Number 39011 | 6008822.29863 | 2094308.62612 | 37.7310709363673 | -122.411816979173 | (37.7310709363673, -122.411816979173) | 9 | 3 | 7 | 309 | 28 | |
104017 | 35736 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 351 Hale St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/14/1998 12:00:00 AM | 9 | Permit Number 39011 | 6008805.61164 | 2094302.44729 | 37.731053034462 | -122.411874232722 | (37.731053034462, -122.411874232722) | 9 | 3 | 7 | 309 | 28 | |
20543 | 203531 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 355 Granada Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | Width 2ft | 5995610.31086 | 2092357.07195 | 37.7249623857941 | -122.457351672459 | (37.7249623857941, -122.457351672459) | 9 | 7 | 4 | 28861 | 40 | |||
93508 | 203530 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 355 Granada Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 2ft | 5995608.47907 | 2092372.56646 | 37.7250048247995 | -122.457359125149 | (37.7250048247995, -122.457359125149) | 9 | 7 | 4 | 28861 | 40 | |||
50392 | 203557 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 377 Capitol Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 5995020.43667 | 2088328.90175 | 37.7138680909275 | -122.459099244044 | (37.7138680909275, -122.459099244044) | 9 | 8 | 6 | 28861 | 24 | |||
83894 | 108683 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 384 Allison St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/31/2014 12:00:00 AM | 3 | 3x3 | Permit Number 774613 | 6000302.20846 | 2086863.37515 | 37.7101463059777 | -122.440738464824 | (37.7101463059777, -122.440738464824) | 9 | 7 | 6 | 28861 | 5 |
175391 | 203584 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 391 Staples Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 23 | Width 5ft | 5997518.2723 | 2093790.63155 | 37.729008004011 | -122.450859415354 | (37.729008004011, -122.450859415354) | 9 | 7 | 4 | 28861 | 40 | |||
59853 | 1275 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 3995X Alemany Blvd | 11 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3X3 | 5992427.65168 | 2087335.55006 | 37.710991191174 | -122.467988584733 | (37.710991191174, -122.467988584733) | 9 | 8 | 4 | 64 | 24 |
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) );