trees
665 rows where qSpecies_id = 89 sorted by PlotSize
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
134140 | 38936 | Permitted Site 7 | Afrocarpus gracilior :: Fern Pine 89 | 144 Lunado Way | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/02/1998 12:00:00 AM | Permit Number 40738 | 5991631.60246352 | 2092606.92529954 | 37.7254190951466 | -122.471123685701 | (37.7254190951466, -122.471123685701) | 9 | 8 | 4 | 59 | 40 | ||
134207 | 33294 | Permitted Site 7 | Afrocarpus gracilior :: Fern Pine 89 | 158 Sproule Ln | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/14/1996 12:00:00 AM | Permit Number 37451 | 6009246.88754349 | 2116916.88448981 | 37.7931718587847 | -122.411946149383 | (37.7931718587847, -122.411946149383) | 3 | 1 | 10 | 28857 | 21 | ||
135153 | 57875 | Permitted Site 7 | Afrocarpus gracilior :: Fern Pine 89 | 411 O'Farrell St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/26/1997 12:00:00 AM | Permit Number 16823 | 6009320.51611206 | 2114267.52405605 | 37.7859014867053 | -122.411504124328 | (37.7859014867053, -122.411504124328) | 14 | 10 | 9 | 28852 | 36 | ||
135510 | 35678 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 373 26th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/08/1998 12:00:00 AM | 3 | Permit Number 39754 | 5987751.63383 | 2113488.06207 | 37.7825278787916 | -122.486068320452 | (37.7825278787916, -122.486068320452) | 11 | 6 | 2 | 55 | 26 | ||
141657 | 33290 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 166 Sproule Ln | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/14/1996 12:00:00 AM | 8 | Permit Number 37451 | 6009219.4283 | 2116994.47406 | 37.7933833601996 | -122.412046646255 | (37.7933833601996, -122.412046646255) | 3 | 1 | 10 | 28857 | 21 | |
142171 | 33292 | Permitted Site 7 | Afrocarpus gracilior :: Fern Pine 89 | 160 Sproule Ln | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/14/1996 12:00:00 AM | Permit Number 37451 | 6009246.88754349 | 2116916.88448981 | 37.7931718587847 | -122.411946149383 | (37.7931718587847, -122.411946149383) | 3 | 1 | 10 | 28857 | 21 | ||
142231 | 31949 | Permitted Site 7 | Afrocarpus gracilior :: Fern Pine 89 | 1677 Bush St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/26/1995 12:00:00 AM | Permit Number 35359 | 6005487.56868066 | 2115128.64858681 | 37.7880501818667 | -122.424826361466 | (37.7880501818667, -122.424826361466) | 13 | 9 | 1 | 28858 | 41 | ||
142938 | 125484 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 1237x Robert C Levy Tunl | 1 | Median : Yard | Tree | DPW 1 | 18 | 6007648.69076 | 2118115.73393 | 37.796373807471 | -122.417561030927 | (37.796373807471, -122.417561030927) | 5 | 1 | 10 | 28858 | 32 | ||||
144199 | 203464 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 312 Hearst Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 30 | 5999389.85516 | 2094399.06798 | 37.7307855913786 | -122.444432942737 | (37.7307855913786, -122.444432942737) | 9 | 7 | 4 | 59 | 40 | ||||
144868 | 97942 | Undocumented 4 | Afrocarpus gracilior :: Fern Pine 89 | 491 Greenwich St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6010516 | 2120277 | 37.8024690368502 | -122.407791962119 | (37.8024690368502, -122.407791962119) | 3 | 1 | 10 | 308 | 23 | |||||
147549 | 35734 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 202 Felton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/06/2003 12:00:00 AM | 6 | Permit Number 47062 | 6010246.45985 | 2093710.97804 | 37.7295097141809 | -122.406851279879 | (37.7295097141809, -122.406851279879) | 10 | 3 | 7 | 309 | 28 | |
148923 | 38937 | Permitted Site 7 | Afrocarpus gracilior :: Fern Pine 89 | 144 Lunado Way | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/02/1998 12:00:00 AM | Permit Number 40738 | 5991631.60246352 | 2092606.92529954 | 37.7254190951466 | -122.471123685701 | (37.7254190951466, -122.471123685701) | 9 | 8 | 4 | 59 | 40 | ||
150762 | 34186 | Permitted Site 7 | Afrocarpus gracilior :: Fern Pine 89 | 2701 Lake St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/14/1997 12:00:00 AM | Permit Number 38079 | 5987120.3446635 | 2114449.05125045 | 37.7851296693951 | -122.488322923297 | (37.7851296693951, -122.488322923297) | 11 | 6 | 1 | 55 | 33 | ||
151616 | 39223 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 842 44th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/26/2000 12:00:00 AM | 1 | Permit Number 42693 | 5982336.53728 | 2109997.98133 | 37.7726280682786 | -122.50454323337 | (37.7726280682786, -122.50454323337) | 11 | 6 | 2 | 55 | 26 | |
152789 | 38941 | Permitted Site 7 | Afrocarpus gracilior :: Fern Pine 89 | 157 Lunado Way | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/17/2001 12:00:00 AM | Permit Number 40741 | 5991578.31713669 | 2092588.28918632 | 37.7253648428023 | -122.471306529261 | (37.7253648428023, -122.471306529261) | 9 | 8 | 4 | 59 | 40 | ||
154300 | 37067 | Permitted Site 7 | Afrocarpus gracilior :: Fern Pine 89 | 345 Valley St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/01/1998 12:00:00 AM | Permit Number 39669 | 6003676.44308345 | 2099207.16082517 | 37.7442311672419 | -122.429956374539 | (37.7442311672419, -122.429956374539) | 2 | 7 | 5 | 63 | 22 | ||
155653 | 63535 | Permitted Site 7 | Afrocarpus gracilior :: Fern Pine 89 | 343 San Carlos St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/10/1987 12:00:00 AM | Permit Number 24148 | 6006747.55377608 | 2104121.784718 | 37.7578990494792 | -122.419685752558 | (37.7578990494792, -122.419685752558) | 2 | 4 | 7 | 28859 | 19 | ||
155948 | 102478 | Significant Tree 6 | Afrocarpus gracilior :: Fern Pine 89 | 760 Victoria St | 4 | Front Yard : Yard | Tree | Private 2 | 5993664.7 | 2092172.3 | 37.7243431058269 | -122.464063971167 | (37.7243431058269, -122.464063971167) | 9 | 8 | 4 | 59 | 40 | |||||
161911 | 41212 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 3676 Fillmore St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/29/1999 12:00:00 AM | 6 | Permit Number 41921 | 6002149.73701 | 2121055.69726 | 37.804135222937 | -122.43679910691 | (37.804135222937, -122.43679910691) | 13 | 9 | 1 | 57 | 17 | |
163458 | 37651 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 1707 Balboa St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/26/1998 12:00:00 AM | 11 | Permit Number 40063 | 5990221.82835 | 2111258.88604 | 37.7765508289575 | -122.477359640658 | (37.7765508289575, -122.477359640658) | 11 | 6 | 2 | 55 | 26 | |
163753 | 42785 | Permitted Site 7 | Afrocarpus gracilior :: Fern Pine 89 | 269 Lily St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/26/2000 12:00:00 AM | Permit Number 42753 | 6005259.26650222 | 2110063.08095744 | 37.7741284823912 | -122.425255647592 | (37.7741284823912, -122.425255647592) | 7 | 9 | 11 | 28852 | 10 | ||
164297 | 34667 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 3065 Buchanan St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/28/1997 12:00:00 AM | 3 | Permit Number 38339 | 6003364.40129 | 2118901.01049 | 37.7982879721724 | -122.432441684758 | (37.7982879721724, -122.432441684758) | 13 | 9 | 1 | 57 | 17 | ||
164516 | 45290 | Permitted Site 7 | Afrocarpus gracilior :: Fern Pine 89 | 600 Gates St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/12/2001 12:00:00 AM | Permit Number 44129 | 6008139.59757362 | 2096081.06824752 | 37.7358993545079 | -122.414302561575 | (37.7358993545079, -122.414302561575) | 2 | 7 | 7 | 28859 | 2 | |||
165775 | 34188 | Permitted Site 7 | Afrocarpus gracilior :: Fern Pine 89 | 2701 Lake St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/14/1997 12:00:00 AM | Permit Number 38079 | 5987120.3446635 | 2114449.05125045 | 37.7851296693951 | -122.488322923297 | (37.7851296693951, -122.488322923297) | 11 | 6 | 1 | 55 | 33 | ||
167430 | 37576 | Permitted Site 7 | Afrocarpus gracilior :: Fern Pine 89 | 124 Danvers St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/26/1998 12:00:00 AM | Permit Number 40009 | 5999906.30838792 | 2105075.4680497 | 37.7601298795068 | -122.44341407918 | (37.7601298795068, -122.44341407918) | 2 | 4 | 5 | 28862 | 3 | ||
167613 | 33368 | Permitted Site 7 | Afrocarpus gracilior :: Fern Pine 89 | 90 Manor Dr | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/14/1996 12:00:00 AM | Permit Number 37499 | 5993674.94282707 | 2093510.9416498 | 37.7280192795988 | -122.464125696941 | (37.7280192795988, -122.464125696941) | 9 | 8 | 4 | 59 | 40 | ||
168006 | 49034 | Permitted Site 7 | Afrocarpus gracilior :: Fern Pine 89 | 1190 Sanchez St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/07/2003 12:00:00 AM | Permit Number 46211 | 6003822.41781324 | 2101344.45239948 | 37.7501079390792 | -122.429604025448 | (37.7501079390792, -122.429604025448) | 2 | 4 | 5 | 28862 | 22 | ||
169681 | 125486 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 1237x Robert C Levy Tunl | 4 | Median : Yard | Tree | DPW 1 | 6 | 6007645.27033 | 2118136.8198 | 37.7964315115565 | -122.417574361577 | (37.7964315115565, -122.417574361577) | 5 | 1 | 10 | 28858 | 32 | ||||
170131 | 45807 | Permitted Site 7 | Afrocarpus gracilior :: Fern Pine 89 | 1993 14th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/28/2001 12:00:00 AM | Permit Number 44435 | 5991886.15341897 | 2101900.86240585 | 37.7509526116716 | -122.470920456526 | (37.7509526116716, -122.470920456526) | 1 | 8 | 4 | 29491 | 12 | |||
170340 | 125439 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 99 Collins St | 0 | Side Yard : Yard | Tree | Private 2 | 7 | 5998117.25486 | 2114050.06951 | 37.7846696436241 | -122.450248453727 | (37.7846696436241, -122.450248453727) | 15 | 6 | 1 | 54 | 31 | ||||
170746 | 38961 | Permitted Site 7 | Afrocarpus gracilior :: Fern Pine 89 | 407 Holladay Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/26/2000 12:00:00 AM | Permit Number 42707 | 6010377.89521168 | 2098716.86029543 | 37.7432621510095 | -122.406749540855 | (37.7432621510095, -122.406749540855) | 10 | 7 | 7 | 28859 | 2 | ||
172501 | 32487 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 257 States St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/10/1996 12:00:00 AM | 5 | Permit Number 36994 | 6000562.08159 | 2106647.67071 | 37.7644841354656 | -122.441258885382 | (37.7644841354656, -122.441258885382) | 15 | 5 | 5 | 28862 | 3 | |
173885 | 92979 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 147 Mason St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/04/2010 12:00:00 AM | 5 | Permit Number 53131 | 6009891.19153 | 2113906.4761 | 37.78494212831 | -122.40950424575 | (37.78494212831, -122.40950424575) | 14 | 10 | 9 | 28852 | 36 | ||
174368 | 32129 | Permitted Site 7 | Afrocarpus gracilior :: Fern Pine 89 | 35 Spofford Ln | 1 | Sidewalk: Curb side : Pot | Tree | Private 2 | FUF | 08/15/1995 12:00:00 AM | Permit Number 35491 | 6010554.96159279 | 2117351.45133924 | 37.7944383752725 | -122.407450761229 | (37.7944383752725, -122.407450761229) | 3 | 1 | 10 | 28857 | 4 | ||
174438 | 31950 | Permitted Site 7 | Afrocarpus gracilior :: Fern Pine 89 | 1677 Bush St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/26/1995 12:00:00 AM | Permit Number 35359 | 6005487.56868066 | 2115128.64858681 | 37.7880501818667 | -122.424826361466 | (37.7880501818667, -122.424826361466) | 13 | 9 | 1 | 28858 | 41 | ||
175348 | 97941 | Undocumented 4 | Afrocarpus gracilior :: Fern Pine 89 | 491 Greenwich St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6010516 | 2120277 | 37.8024690368502 | -122.407791962119 | (37.8024690368502, -122.407791962119) | 3 | 1 | 10 | 308 | 23 | |||||
179660 | 49037 | Permitted Site 7 | Afrocarpus gracilior :: Fern Pine 89 | 1190 Sanchez St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/07/2003 12:00:00 AM | 10 | Permit Number 46211 | 6003822.41781324 | 2101344.45239948 | 37.7501079390792 | -122.429604025448 | (37.7501079390792, -122.429604025448) | 2 | 4 | 5 | 28862 | 22 | |
179959 | 189166 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 1300x De Haro St | 20 | Median : Yard | Tree | DPW 1 | 1 | 6012257.93832 | 2102144.48011 | 37.752778669414 | -122.40048951887 | (37.752778669414, -122.40048951887) | 10 | 3 | 8 | 28856 | 29 | ||||
180503 | 51460 | Permitted Site 7 | Afrocarpus gracilior :: Fern Pine 89 | 816 Crescent Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/20/2004 12:00:00 AM | Permit Number 47775 | 6008159.08468648 | 2095638.69714743 | 37.7346857944121 | -122.414203898561 | (37.7346857944121, -122.414203898561) | 2 | 7 | 7 | 28859 | 2 | ||
182127 | 189164 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 900 Pennsylvania Ave | 12 | Sidewalk: Property side : Yard | Tree | Private 2 | 2 | 6014453.29453 | 2102557.37778 | 37.7540345843346 | -122.392926403935 | (37.7540345843346, -122.392926403935) | 10 | 3 | 8 | 28856 | 29 | ||||
184137 | 46752 | Permitted Site 7 | Afrocarpus gracilior :: Fern Pine 89 | 375 Victoria St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/24/2002 12:00:00 AM | Permit Number 44854 | 5993218.00754376 | 2089670.83747573 | 37.7174489416695 | -122.465426481993 | (37.7174489416695, -122.465426481993) | 9 | 8 | 6 | 64 | 24 | ||
185576 | 69035 | Permitted Site 7 | Afrocarpus gracilior :: Fern Pine 89 | 1407 38th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/06/1994 12:00:00 AM | Permit Number 33041 | 5984298.37219271 | 2105588.33319884 | 37.7606356257767 | -122.497431537078 | (37.7606356257767, -122.497431537078) | 1 | 8 | 3 | 56 | 35 | ||
186226 | 32707 | Permitted Site 7 | Afrocarpus gracilior :: Fern Pine 89 | 1005 Hyde St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/29/1996 12:00:00 AM | Permit Number 37107 | 6007675.42771265 | 2115829.29953352 | 37.7900973284958 | -122.417306405748 | (37.7900973284958, -122.417306405748) | 13 | 1 | 10 | 28858 | 21 | ||
186373 | 96486 | Undocumented 4 | Afrocarpus gracilior :: Fern Pine 89 | 1202 Stanyan St | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | 5997433 | 2105848 | 37.7621097006999 | -122.452023768999 | (37.7621097006999, -122.452023768999) | 15 | 5 | 11 | 29492 | 9 | |||||
186427 | 32706 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 1005 Hyde St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/29/1996 12:00:00 AM | 1 | Permit Number 37107 | 6007669.19829 | 2115867.15124 | 37.790200909505 | -122.417330642617 | (37.790200909505, -122.417330642617) | 13 | 1 | 10 | 28858 | 21 | |
186795 | 69515 | Permitted Site 7 | Afrocarpus gracilior :: Fern Pine 89 | 443 Prentiss St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/01/1997 12:00:00 AM | Permit Number 33643 | 6008794.13528985 | 2096723.61704292 | 37.7377003998713 | -122.412084952925 | (37.7377003998713, -122.412084952925) | 10 | 7 | 7 | 28859 | 2 | ||
187634 | 32133 | Permitted Site 7 | Afrocarpus gracilior :: Fern Pine 89 | 842 Washington St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/15/1995 12:00:00 AM | Permit Number 35494 | 6010631.11006318 | 2117599.53652258 | 37.7951238190257 | -122.407204773258 | (37.7951238190257, -122.407204773258) | 3 | 1 | 10 | 28857 | 4 | ||
188461 | 97939 | Undocumented 4 | Afrocarpus gracilior :: Fern Pine 89 | 491 Greenwich St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6010516 | 2120277 | 37.8024690368502 | -122.407791962119 | (37.8024690368502, -122.407791962119) | 3 | 1 | 10 | 308 | 23 | |||||
189014 | 49035 | Permitted Site 7 | Afrocarpus gracilior :: Fern Pine 89 | 1190 Sanchez St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/07/2003 12:00:00 AM | Permit Number 46211 | 6003822.41781324 | 2101344.45239948 | 37.7501079390792 | -122.429604025448 | (37.7501079390792, -122.429604025448) | 2 | 4 | 5 | 28862 | 22 | ||
189904 | 33365 | Permitted Site 7 | Afrocarpus gracilior :: Fern Pine 89 | 65 Manor Dr | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/14/1996 12:00:00 AM | Permit Number 37497 | 5993537.09779252 | 2093371.5770822 | 37.7276286729381 | -122.464592112193 | (37.7276286729381, -122.464592112193) | 9 | 8 | 4 | 59 | 40 | ||
191382 | 33001 | Permitted Site 7 | Afrocarpus gracilior :: Fern Pine 89 | 255 03rd St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/03/2002 12:00:00 AM | Permit Number 45106 | 6012763.62735273 | 2113645.89457982 | 37.7843871619555 | -122.399548173715 | (37.7843871619555, -122.399548173715) | 6 | 2 | 9 | 28853 | 6 | ||
193860 | 32513 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 777 Moultrie St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/15/1996 12:00:00 AM | 12 | Permit Number 37015 | 6007618.09597 | 2095855.62959 | 37.7352510410088 | -122.416089643829 | (37.7352510410088, -122.416089643829) | 2 | 7 | 7 | 28859 | 2 | |
414 | 8435 | Permitted Site 7 | Afrocarpus gracilior :: Fern Pine 89 | 1730 Geary Blvd | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/28/1997 12:00:00 AM | 13 | 3X3 | 6003010.73492 | 2113853.74303 | 37.784409407274 | -122.433304626878 | (37.784409407274, -122.433304626878) | 13 | 9 | 11 | 29490 | 13 | ||
20279 | 7125 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 300X Fern St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/02/1990 12:00:00 AM | 6 | 3X3 | 6005738.17658 | 2115026.96294 | 37.7877851299198 | -122.423952067531 | (37.7877851299198, -122.423952067531) | 13 | 9 | 1 | 28858 | 41 | ||
24461 | 16391 | Permitted Site 7 | Afrocarpus gracilior :: Fern Pine 89 | 248X Myrtle St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/20/2003 12:00:00 AM | 3 | 3X3 | 6006237.34556 | 2114081.50477 | 37.7852173036048 | -122.422157838958 | (37.7852173036048, -122.422157838958) | 13 | 9 | 11 | 28858 | 41 | ||
30749 | 17018 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 1048 Oak St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 06/22/1998 12:00:00 AM | 3 | 3X3 | 6001982.80486 | 2109858.77961 | 37.7733818753695 | -122.436574858617 | (37.7733818753695, -122.436574858617) | 15 | 5 | 11 | 29492 | 10 | ||
37507 | 17121 | Permitted Site 7 | Afrocarpus gracilior :: Fern Pine 89 | 1931 Oak St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3X3 | 5997743.85041 | 2109170.01524 | 37.7712489089965 | -122.451188245827 | (37.7712489089965, -122.451188245827) | 15 | 5 | 11 | 29492 | 9 | |||
38197 | 28058 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 399X Fern St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/28/2003 12:00:00 AM | 7 | 3X3 | 6005467.03901 | 2114965.36006 | 37.7876006726807 | -122.424885768876 | (37.7876006726807, -122.424885768876) | 13 | 9 | 1 | 28858 | 41 | ||
44580 | 16399 | Permitted Site 7 | Afrocarpus gracilior :: Fern Pine 89 | 299X Myrtle St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/15/1990 12:00:00 AM | 12 | 3X3 | 6006028.76056 | 2113989.39072 | 37.7849526140265 | -122.422872930887 | (37.7849526140265, -122.422872930887) | 13 | 9 | 11 | 28858 | 41 | ||
44607 | 4490 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 1602 Church St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 01/30/2002 12:00:00 AM | 3 | 3X3 | 6004561.8284 | 2099527.9975 | 37.7451622129677 | -122.426917747467 | (37.7451622129677, -122.426917747467) | 2 | 7 | 5 | 63 | 22 | ||
45904 | 27672 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 310 Austin St | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 3X3 | 6005758.15165 | 2115391.49838 | 37.7887871812497 | -122.423908889223 | (37.7887871812497, -122.423908889223) | 13 | 9 | 1 | 28858 | 41 | |||
48705 | 27670 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 310 Austin St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 3X3 | 6005758.15165 | 2115391.49838 | 37.7887871812497 | -122.423908889223 | (37.7887871812497, -122.423908889223) | 13 | 9 | 1 | 28858 | 41 | |||
49659 | 28777 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 365 Austin St | 6 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6005518.5465766 | 2115307.531712 | 37.7885430999734 | -122.424731913891 | (37.7885430999734, -122.424731913891) | 13 | 9 | 1 | 28858 | 41 | |||
61917 | 27665 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 300 Austin St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 3X3 | 6005803.78776 | 2115397.87528 | 37.7888072668978 | -122.423751448163 | (37.7888072668978, -122.423751448163) | 13 | 9 | 1 | 28858 | 41 | |||
62733 | 27668 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 310 Austin St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 3X3 | 6005758.15165 | 2115391.49838 | 37.7887871812497 | -122.423908889223 | (37.7887871812497, -122.423908889223) | 13 | 9 | 1 | 28858 | 41 | |||
66789 | 16404 | Permitted Site 7 | Afrocarpus gracilior :: Fern Pine 89 | 299X Myrtle St | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/15/1990 12:00:00 AM | 6 | 3X3 | 6006028.76056 | 2113989.39072 | 37.7849526140265 | -122.422872930887 | (37.7849526140265, -122.422872930887) | 13 | 9 | 11 | 28858 | 41 | ||
69039 | 16401 | Permitted Site 7 | Afrocarpus gracilior :: Fern Pine 89 | 299X Myrtle St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/15/1990 12:00:00 AM | 6 | 3X3 | 6006028.76056 | 2113989.39072 | 37.7849526140265 | -122.422872930887 | (37.7849526140265, -122.422872930887) | 13 | 9 | 11 | 28858 | 41 | ||
74822 | 27714 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 5587 Diamond Heights Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3 | 3X3 | 6001610.45471 | 2097108.73364 | 37.7383521588292 | -122.436949905209 | (37.7383521588292, -122.436949905209) | 2 | 7 | 5 | 63 | 7 | |||
77242 | 27669 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 310 Austin St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 3X3 | 6005758.15165 | 2115391.49838 | 37.7887871812497 | -122.423908889223 | (37.7887871812497, -122.423908889223) | 13 | 9 | 1 | 28858 | 41 | |||
82689 | 24521 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 365 Austin St | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6005518.5465766 | 2115307.531712 | 37.7885430999734 | -122.424731913891 | (37.7885430999734, -122.424731913891) | 13 | 9 | 1 | 28858 | 41 | |||
87861 | 27666 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 300 Austin St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 3X3 | 6005803.78776 | 2115397.87528 | 37.7888072668978 | -122.423751448163 | (37.7888072668978, -122.423751448163) | 13 | 9 | 1 | 28858 | 41 | |||
87885 | 16912 | Permitted Site 7 | Afrocarpus gracilior :: Fern Pine 89 | 474 Oak St | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | 10 | 3X3 | 6004730.16481 | 2110223.37403 | 37.7745387026084 | -122.427097323497 | (37.7745387026084, -122.427097323497) | 7 | 9 | 11 | 28852 | 10 | |||
98180 | 7129 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 399X Fern St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/02/1990 12:00:00 AM | 4 | 3X3 | 6005508.68317 | 2114972.65603 | 37.7876230577135 | -122.424742207381 | (37.7876230577135, -122.424742207381) | 13 | 9 | 1 | 28858 | 41 | ||
100280 | 8408 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 1570 Geary Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/12/1999 12:00:00 AM | 3 | 3X3 | 6004211.027185 | 2114032.026709 | 37.7849669496355 | -122.42916474711 | (37.7849669496355, -122.42916474711) | 13 | 9 | 11 | 29490 | 13 | ||
128405 | 28059 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 399X Fern St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/28/2003 12:00:00 AM | 3 | 3X3 | 6005443.48959 | 2114960.28563 | 37.7875854093804 | -122.42496688413 | (37.7875854093804, -122.42496688413) | 13 | 9 | 1 | 28858 | 41 | ||
131213 | 16913 | Permitted Site 7 | Afrocarpus gracilior :: Fern Pine 89 | 477 Oak St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | 3X3 | 6004718.6652 | 2110142.96999 | 37.7743172824327 | -122.42713137469 | (37.7743172824327, -122.42713137469) | 7 | 9 | 11 | 28852 | 10 | |||
131522 | 24519 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 365 Austin St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6005518.5465766 | 2115307.531712 | 37.7885430999734 | -122.424731913891 | (37.7885430999734, -122.424731913891) | 13 | 9 | 1 | 28858 | 41 | |||
134327 | 18926 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 2689 Sacramento St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 3X3 | 6001985.03027 | 2115691.49541 | 37.7893971628975 | -122.436984817806 | (37.7893971628975, -122.436984817806) | 13 | 6 | 1 | 29490 | 27 | |||
134937 | 27667 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 300 Austin St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 3X3 | 6005803.78776 | 2115397.87528 | 37.7888072668978 | -122.423751448163 | (37.7888072668978, -122.423751448163) | 13 | 9 | 1 | 28858 | 41 | |||
135907 | 24520 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 365 Austin St | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6005518.5465766 | 2115307.531712 | 37.7885430999734 | -122.424731913891 | (37.7885430999734, -122.424731913891) | 13 | 9 | 1 | 28858 | 41 | |||
139288 | 24518 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 365 Austin St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 3X3 | 6005518.5465766 | 2115307.531712 | 37.7885430999734 | -122.424731913891 | (37.7885430999734, -122.424731913891) | 13 | 9 | 1 | 28858 | 41 | |||
145672 | 7128 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 399X Fern St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/02/1990 12:00:00 AM | 12 | 3X3 | 6005491.12747 | 2114969.49683 | 37.7876133917897 | -122.424802721882 | (37.7876133917897, -122.424802721882) | 13 | 9 | 1 | 28858 | 41 | ||
151012 | 7124 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 300X Fern St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/02/1990 12:00:00 AM | 6 | 3X3 | 6005782.02097 | 2115033.60586 | 37.7878058449088 | -122.423800846553 | (37.7878058449088, -122.423800846553) | 13 | 9 | 1 | 28858 | 41 | ||
156024 | 7130 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 399X Fern St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/02/1990 12:00:00 AM | 5 | 3X3 | 6005539.58789 | 2114975.93468 | 37.7876338054953 | -122.42463551632 | (37.7876338054953, -122.42463551632) | 13 | 9 | 1 | 28858 | 41 | ||
156119 | 24504 | Permitted Site 7 | Afrocarpus gracilior :: Fern Pine 89 | 360X Fern St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 3X3 | 6005526.31532 | 2114998.99681 | 37.7876963787723 | -122.424683078077 | (37.7876963787723, -122.424683078077) | 13 | 9 | 1 | 28858 | 41 | |||
160051 | 27671 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 310 Austin St | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 3X3 | 6005758.15165 | 2115391.49838 | 37.7887871812497 | -122.423908889223 | (37.7887871812497, -122.423908889223) | 13 | 9 | 1 | 28858 | 41 | |||
161362 | 16907 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 452 Oak St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 3X3 | 6004778.47873 | 2110233.49325 | 37.7745692194762 | -122.426930917012 | (37.7745692194762, -122.426930917012) | 7 | 9 | 11 | 28852 | 10 | |||
162324 | 16406 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 299X Myrtle St | 12 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 01/15/1990 12:00:00 AM | 6 | 3X3 | 6006028.76056 | 2113989.39072 | 37.7849526140265 | -122.422872930887 | (37.7849526140265, -122.422872930887) | 13 | 9 | 11 | 28858 | 41 | ||
166235 | 16403 | Permitted Site 7 | Afrocarpus gracilior :: Fern Pine 89 | 299X Myrtle St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/15/1990 12:00:00 AM | 6 | 3X3 | 6006028.76056 | 2113989.39072 | 37.7849526140265 | -122.422872930887 | (37.7849526140265, -122.422872930887) | 13 | 9 | 11 | 28858 | 41 | ||
166460 | 16400 | Permitted Site 7 | Afrocarpus gracilior :: Fern Pine 89 | 299X Myrtle St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/13/2005 12:00:00 AM | 3 | 3X3 | 6006028.76056 | 2113989.39072 | 37.7849526140265 | -122.422872930887 | (37.7849526140265, -122.422872930887) | 13 | 9 | 11 | 28858 | 41 | ||
169624 | 17031 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 1160X Oak St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6001440.12949 | 2109757.61689 | 37.7730732545652 | -122.438444795925 | (37.7730732545652, -122.438444795925) | 15 | 5 | 11 | 29492 | 10 | |||
173456 | 16405 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 299X Myrtle St | 11 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 01/15/1990 12:00:00 AM | 6 | 3X3 | 6006028.76056 | 2113989.39072 | 37.7849526140265 | -122.422872930887 | (37.7849526140265, -122.422872930887) | 13 | 9 | 11 | 28858 | 41 | ||
184630 | 17102 | Permitted Site 7 | Afrocarpus gracilior :: Fern Pine 89 | 1711 Oak St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | 3X3 | 5998685.53291 | 2109300.56616 | 37.771661239802 | -122.447940341436 | (37.771661239802, -122.447940341436) | 15 | 5 | 11 | 29492 | 9 | |||
187360 | 24505 | Permitted Site 7 | Afrocarpus gracilior :: Fern Pine 89 | 360X Fern St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 3X3 | 6005509.85054 | 2114996.70292 | 37.787689150419 | -122.424739879851 | (37.787689150419, -122.424739879851) | 13 | 9 | 1 | 28858 | 41 | |||
193686 | 16402 | Permitted Site 7 | Afrocarpus gracilior :: Fern Pine 89 | 299X Myrtle St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/15/1990 12:00:00 AM | 6 | 3X3 | 6006028.76056 | 2113989.39072 | 37.7849526140265 | -122.422872930887 | (37.7849526140265, -122.422872930887) | 13 | 9 | 11 | 28858 | 41 | ||
2235 | 16944 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 599X Oak St | 7 | Sidewalk: Property side : Cutout | Tree | DPW 1 | 20 | 3x3 | 6004143.7777346 | 2110082.9014722 | 37.774119822678 | -122.429115732545 | (37.774119822678, -122.429115732545) | 7 | 9 | 11 | 28852 | 10 | |||
6336 | 261055 | Private 9 | Afrocarpus gracilior :: Fern Pine 89 | 1948 Quesada Ave | 1 | Front Yard : Cutout | Tree | Private 2 | DPW | 11/20/2019 12:00:00 AM | 3 | 3x3 | Permit Number 780729 | 6013389.35902 | 2096036.97619 | 37.7360717858924 | -122.396148836191 | (37.7360717858924, -122.396148836191) | 10 | 3 | 8 | 58 | 1 |
8824 | 261056 | Private 9 | Afrocarpus gracilior :: Fern Pine 89 | 1952 Quesada Ave | 1 | Front Yard : Cutout | Tree | Private 2 | DPW | 11/20/2019 12:00:00 AM | 3 | 3x3 | Permit Number 780727 | 6013369.93114 | 2096051.4395 | 37.7361104181421 | -122.396217020065 | (37.7361104181421, -122.396217020065) | 10 | 3 | 8 | 58 | 1 |
12247 | 16942 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 599X Oak St | 5 | Sidewalk: Property side : Cutout | Tree | DPW 1 | 6 | 3x3 | 6004143.7777346 | 2110082.9014722 | 37.774119822678 | -122.429115732545 | (37.774119822678, -122.429115732545) | 7 | 9 | 11 | 28852 | 10 | |||
14262 | 92752 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 3356 Baker St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/07/2009 12:00:00 AM | 4 | 3x3 | Permit Number 52980 | 5999300.27951 | 2120375.08626 | 37.8021040941904 | -122.446610827352 | (37.8021040941904, -122.446610827352) | 13 | 9 | 1 | 57 | 17 |
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) );