trees
508 rows where qSpecies_id = 25 sorted by Location
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
171972 | 115822 | Undocumented 4 | Geijera parviflora :: Australian Willow 25 | 122 COLLEGE AVE | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 24 | 3x3 | 6004593 | 2095924 | 37.7352682180932 | -122.426553380791 | (37.7352682180932, -122.426553380791) | 2 | 7 | 5 | 28861 | 2 | |||
53315 | 34425 | Permitted Site 7 | Geijera parviflora :: Australian Willow 25 | 245 Roanoke St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/04/2008 12:00:00 AM | 3x3 | Permit Number 50336 | 6003617.84008567 | 2095979.02625995 | 37.7353641309188 | -122.429928789613 | (37.7353641309188, -122.429928789613) | 2 | 7 | 5 | 63 | 7 | ||
43773 | 21413 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 2692X Sunset Blvd | 15 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 2 | 5985040.0664617 | 2096882.0619327 | 37.7367740271268 | -122.494224659054 | (37.7367740271268, -122.494224659054) | 1 | 8 | 3 | 29491 | 35 | ||||
25081 | 225931 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 337 Bennington St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 2ft | 6007076.3964 | 2096610.27498 | 37.737292658529 | -122.418015982652 | (37.737292658529, -122.418015982652) | 2 | 7 | 7 | 28859 | 2 | |||
55349 | 115881 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 1663 La Salle Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/01/2016 12:00:00 AM | 3 | Permit Number 773046 | 6015043.9945 | 2096491.09601 | 37.737410632491 | -122.390459765022 | (37.737410632491, -122.390459765022) | 10 | 3 | 8 | 58 | 1 | ||
76434 | 67080 | Permitted Site 7 | Geijera parviflora :: Australian Willow 25 | 343 Bennington St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/23/1992 12:00:00 AM | Permit Number 30477 | 6007097.80000141 | 2096683.93673196 | 37.7374961220492 | -122.417947200602 | (37.7374961220492, -122.417947200602) | 2 | 7 | 7 | 28859 | 2 | ||
180292 | 217005 | Permitted Site 7 | Geijera parviflora :: Australian Willow 25 | 532 Wawona St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/24/2018 12:00:00 AM | 3 | 3x12 | Permit Number 782164 | 5991273.49549 | 2097061.96197 | 37.737630785637 | -122.472686293253 | (37.737630785637, -122.472686293253) | 1 | 8 | 4 | 29491 | 40 | |
151826 | 255813 | Permitted Site 7 | Geijera parviflora :: Australian Willow 25 | 532 Wawona St | 1 | Front Yard : Yard | Tree | Private 2 | 07/24/2018 12:00:00 AM | 3 | 3X3 | Permit Number 782164 | 5991340.67425 | 2097062.85197 | 37.7376371178542 | -122.472454091358 | (37.7376371178542, -122.472454091358) | 1 | 8 | 4 | 29491 | 40 | |
191506 | 59773 | Permitted Site 7 | Geijera parviflora :: Australian Willow 25 | 136 Newman St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/02/1991 12:00:00 AM | Permit Number 19218 | 6007237.20914714 | 2096749.07204327 | 37.7376828142423 | -122.417469811222 | (37.7376828142423, -122.417469811222) | 2 | 7 | 7 | 28859 | 2 | ||
27196 | 225957 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 38 Newman St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 6007027 | 2096768 | 37.7377229562927 | -122.418197948284 | (37.7377229562927, -122.418197948284) | 2 | 7 | 7 | 28859 | 2 | |||
180699 | 225958 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 22 Newman St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 6006997.29883 | 2096792.90464 | 37.7377896670691 | -122.418302405036 | (37.7377896670691, -122.418302405036) | 2 | 7 | 7 | 28859 | 2 | |||
151060 | 59771 | Permitted Site 7 | Geijera parviflora :: Australian Willow 25 | 38 Newman St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/23/1992 12:00:00 AM | Permit Number 30471 | 6006914.85070557 | 2096794.9528113 | 37.7377906494843 | -122.41858761398 | (37.7377906494843, -122.41858761398) | 2 | 7 | 7 | 28859 | 2 | ||
57051 | 225959 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 20 Newman St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/15/2005 12:00:00 AM | 12 | Width 3ft | Permit Number 48238 | 6006979.14621 | 2096796.63822 | 37.7377988968125 | -122.418365432231 | (37.7377988968125, -122.418365432231) | 2 | 7 | 7 | 28859 | 2 | |
21840 | 67067 | Permitted Site 7 | Geijera parviflora :: Australian Willow 25 | 22 Newman St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/22/1992 12:00:00 AM | Permit Number 30456 | 6006871.92388007 | 2096801.0625203 | 37.7378050085566 | -122.418736466303 | (37.7378050085566, -122.418736466303) | 2 | 7 | 7 | 28859 | 2 | ||
141655 | 52023 | Permitted Site 7 | Geijera parviflora :: Australian Willow 25 | 20 Newman St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/15/2005 12:00:00 AM | Permit Number 48238 | 6006866.55802505 | 2096801.82623419 | 37.7378068034281 | -122.418755072853 | (37.7378068034281, -122.418755072853) | 2 | 7 | 7 | 28859 | 2 | ||
152965 | 59772 | Permitted Site 7 | Geijera parviflora :: Australian Willow 25 | 131 Newman St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/25/1981 12:00:00 AM | Permit Number 19217 | 6007221.04974766 | 2096803.89603525 | 37.7378324395755 | -122.417529566585 | (37.7378324395755, -122.417529566585) | 2 | 7 | 7 | 28859 | 2 | ||
96140 | 225960 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 202 Jarboe Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 6008021.65482 | 2096973.39205 | 37.7383428544349 | -122.414773468947 | (37.7383428544349, -122.414773468947) | 2 | 7 | 7 | 28859 | 2 | |||
108389 | 225962 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 200 Jarboe Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 6007966.25264 | 2096976.90694 | 37.738349392503 | -122.414965271836 | (37.738349392503, -122.414965271836) | 2 | 7 | 7 | 28859 | 2 | |||
153039 | 225961 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 202 Jarboe Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6007991.11967 | 2096976.87427 | 37.7383507001153 | -122.414879291246 | (37.7383507001153, -122.414879291246) | 2 | 7 | 7 | 28859 | 2 | |||
118115 | 225963 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 200 Jarboe Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 6007947.91694 | 2096980.61578 | 37.7383585458117 | -122.415028930344 | (37.7383585458117, -122.415028930344) | 2 | 7 | 7 | 28859 | 2 | |||
173884 | 225964 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 200 Jarboe Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 6007927.65948 | 2096983.88773 | 37.7383663914855 | -122.415099202478 | (37.7383663914855, -122.415099202478) | 2 | 7 | 7 | 28859 | 2 | |||
33525 | 67084 | Permitted Site 7 | Geijera parviflora :: Australian Willow 25 | 200 Bennington St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/23/1992 12:00:00 AM | Permit Number 30482 | 6007092.73898781 | 2097018.14574656 | 37.738413501248 | -122.417988384197 | (37.738413501248, -122.417988384197) | 2 | 7 | 7 | 28859 | 2 | ||
106476 | 225956 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 126 Fairmount St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6004690.92985 | 2097272.08471 | 37.7389752900871 | -122.426310750952 | (37.7389752900871, -122.426310750952) | 2 | 7 | 5 | 63 | 7 | |||
47126 | 60044 | Permitted Site 7 | Geijera parviflora :: Australian Willow 25 | 126 Fairmount St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/14/2008 12:00:00 AM | 3x3 | Permit Number 51412 | 6004702.07588502 | 2097279.21146554 | 37.7389954885734 | -122.426272720335 | (37.7389954885734, -122.426272720335) | 2 | 7 | 5 | 63 | 7 | ||
19562 | 62935 | Permitted Site 7 | Geijera parviflora :: Australian Willow 25 | 108 Bennington St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/05/1986 12:00:00 AM | Permit Number 23316 | 6007129.03577236 | 2097271.50045175 | 37.7391111999262 | -122.417880841628 | (37.7391111999262, -122.417880841628) | 2 | 7 | 7 | 28859 | 2 | ||
40882 | 219016 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 23 Gaviota Way | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 8 | Width 3ft | 5998493.11217 | 2097521.42795 | 37.7393076426268 | -122.447757806504 | (37.7393076426268, -122.447757806504) | 9 | 7 | 4 | 59 | 40 | |||
109388 | 96194 | Undocumented 4 | Geijera parviflora :: Australian Willow 25 | 1640 Jerrold Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 4x50 | 6015077.4 | 2097255.4 | 37.7395111076977 | -122.390397652393 | (37.7395111076977, -122.390397652393) | 10 | 3 | 8 | 58 | 1 | |||
100531 | 225930 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 269 Winfield St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6006712.58135 | 2098072.63553 | 37.7412874920181 | -122.419377573329 | (37.7412874920181, -122.419377573329) | 2 | 7 | 7 | 28859 | 2 | |||
15256 | 259564 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 200 Public Park | 3 | Unaccepted Street : Cutout | Tree | Private 2 | 5x10 | 5994204 | 2098512 | 37.741781429361 | -122.462659374294 | (37.741781429361, -122.462659374294) | 1 | 8 | 4 | 59 | 40 | ||||
14626 | 225965 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 81 Bernal Heights Blvd | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6009494.27227 | 2098224.22173 | 37.7418599932559 | -122.409770124916 | (37.7418599932559, -122.409770124916) | 10 | 7 | 7 | 28859 | 2 | |||
29569 | 105213 | Undocumented 4 | Geijera parviflora :: Australian Willow 25 | 2400X 21ST AVE | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | 3x3 | 5989837 | 2098691 | 37.7420204448441 | -122.477771936587 | (37.7420204448441, -122.477771936587) | 1 | 8 | 3 | 29491 | 35 | |||
161550 | 105214 | Undocumented 4 | Geijera parviflora :: Australian Willow 25 | 2400X 21ST AVE | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | 3x3 | 5989837 | 2098691 | 37.7420204448441 | -122.477771936587 | (37.7420204448441, -122.477771936587) | 1 | 8 | 3 | 29491 | 35 | |||
72787 | 225929 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 56 Ellsworth St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 3ft | 6008145.90084 | 2098385.005 | 37.7422258131659 | -122.414443742389 | (37.7422258131659, -122.414443742389) | 2 | 7 | 7 | 28859 | 2 | |||
166911 | 94129 | Permitted Site 7 | Geijera parviflora :: Australian Willow 25 | 420 Holladay Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/11/2010 12:00:00 AM | 3x3 | Permit Number 53495 | 6010221.9 | 2098587.9 | 37.7428993246027 | -122.407279845082 | (37.7428993246027, -122.407279845082) | 10 | 7 | 7 | 28859 | 2 | ||
30868 | 95394 | Permitted Site 7 | Geijera parviflora :: Australian Willow 25 | 208 Day St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/24/2011 12:00:00 AM | 3x3 | Permit Number 767264 | 6004579 | 2098715 | 37.7429308791836 | -122.426800483584 | (37.7429308791836, -122.426800483584) | 2 | 7 | 5 | 63 | 22 | |
95461 | 225927 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 172 Day St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 4ft | 6004830.88644 | 2098735.49496 | 37.7430013921091 | -122.425930987935 | (37.7430013921091, -122.425930987935) | 2 | 7 | 5 | 63 | 22 | |||
43247 | 35398 | Permitted Site 7 | Geijera parviflora :: Australian Willow 25 | 540 29th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/16/1998 12:00:00 AM | Permit Number 38853 | 6003072.48314636 | 2098933.73753739 | 37.743446188104 | -122.43202521517 | (37.743446188104, -122.43202521517) | 2 | 7 | 5 | 63 | 22 | ||
149538 | 42034 | Permitted Site 7 | Geijera parviflora :: Australian Willow 25 | 357 29th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/29/2008 12:00:00 AM | 5 | 3x3 | Permit Number 50466 | 6004260 | 2098933 | 37.7435114157111 | -122.427919028307 | (37.7435114157111, -122.427919028307) | 2 | 7 | 5 | 63 | 22 | |
126710 | 46930 | Permitted Site 7 | Geijera parviflora :: Australian Willow 25 | 1 Pacheco St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/29/2016 12:00:00 AM | 3 | Permit Number 779184 | 5995168.47040897 | 2099126.50126016 | 37.7435241958304 | -122.459369067857 | (37.7435241958304, -122.459369067857) | 1 | 8 | 4 | 59 | 40 | |
159651 | 46927 | Permitted Site 7 | Geijera parviflora :: Australian Willow 25 | 1 Pacheco St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/29/2016 12:00:00 AM | 3 | Permit Number 779184 | 5995168.47040897 | 2099126.50126016 | 37.7435241958304 | -122.459369067857 | (37.7435241958304, -122.459369067857) | 1 | 8 | 4 | 59 | 40 | |
162728 | 46929 | Permitted Site 7 | Geijera parviflora :: Australian Willow 25 | 1 Pacheco St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/29/2016 12:00:00 AM | 3 | Permit Number 779184 | 5995168.47040897 | 2099126.50126016 | 37.7435241958304 | -122.459369067857 | (37.7435241958304, -122.459369067857) | 1 | 8 | 4 | 59 | 40 | |
177469 | 46928 | Permitted Site 7 | Geijera parviflora :: Australian Willow 25 | 1 Pacheco St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/29/2016 12:00:00 AM | 3 | Permit Number 779184 | 5995168.47040897 | 2099126.50126016 | 37.7435241958304 | -122.459369067857 | (37.7435241958304, -122.459369067857) | 1 | 8 | 4 | 59 | 40 | ||
40615 | 225925 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 357 29th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6004205.07883 | 2098948.09387 | 37.7435497528103 | -122.428110007472 | (37.7435497528103, -122.428110007472) | 2 | 7 | 5 | 63 | 22 | |||
63945 | 225932 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 557 Peralta Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 2ft | 6009854.01904 | 2098898.01508 | 37.743730236853 | -122.408573752301 | (37.743730236853, -122.408573752301) | 2 | 7 | 7 | 28859 | 2 | |||
732 | 181868 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 2335 28th Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 02/24/2020 12:00:00 AM | 3 | 5x5 | 5987618.1769 | 2099375.389 | 37.7437705756333 | -122.485494034638 | (37.7437705756333, -122.485494034638) | 1 | 8 | 3 | 29491 | 35 | ||
165944 | 37469 | Permitted Site 7 | Geijera parviflora :: Australian Willow 25 | 557 Peralta Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/19/1998 12:00:00 AM | Permit Number 39940 | 6009863.21581356 | 2098931.68283254 | 37.7438231962188 | -122.408544326388 | (37.7438231962188, -122.408544326388) | 2 | 7 | 7 | 28859 | 2 | ||
121409 | 225926 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 448 Valley St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6002953.29528 | 2099219.15304 | 37.7442231148112 | -122.43245771787 | (37.7442231148112, -122.43245771787) | 2 | 7 | 5 | 63 | 22 | |||
83630 | 225921 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 300 Montcalm St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 6009716.79458 | 2099617.55194 | 37.7456982412969 | -122.40909900492 | (37.7456982412969, -122.40909900492) | 2 | 7 | 7 | 28859 | 2 | |||
165441 | 225920 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 300 Montcalm St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 6009736.52173 | 2099618.93286 | 37.7457031381078 | -122.409030888471 | (37.7457031381078, -122.409030888471) | 2 | 7 | 7 | 28859 | 2 | |||
20477 | 39576 | Permitted Site 7 | Geijera parviflora :: Australian Willow 25 | 300 Montcalm St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/28/1998 12:00:00 AM | Permit Number 40993 | 6009738.16770437 | 2099629.76502916 | 37.7457329730731 | -122.409025961078 | (37.7457329730731, -122.409025961078) | 2 | 7 | 7 | 28859 | 2 | ||
52777 | 225919 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 1683 Alabama St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 6009340.70254 | 2099660.44823 | 37.745794948977 | -122.410402509267 | (37.745794948977, -122.410402509267) | 2 | 7 | 7 | 28859 | 2 | |||
72652 | 246444 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 467 Duncan St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 1 | Width 3ft | 6003499.43256 | 2099785.66068 | 37.7458095674622 | -122.430609709989 | (37.7458095674622, -122.430609709989) | 2 | 7 | 5 | 63 | 22 | |||
111491 | 95562 | Permitted Site 7 | Geijera parviflora :: Australian Willow 25 | 467 Duncan St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/02/2011 12:00:00 AM | 3x3 | Permit Number 767356 | 6003496 | 2099787 | 37.7458130504625 | -122.430621674841 | (37.7458130504625, -122.430621674841) | 2 | 7 | 5 | 63 | 22 | |
109731 | 45152 | Permitted Site 7 | Geijera parviflora :: Australian Willow 25 | 1619 Alabama St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/22/2001 12:00:00 AM | Permit Number 44005 | 6009316.84366878 | 2099994.11121489 | 37.7467097764312 | -122.410508567135 | (37.7467097764312, -122.410508567135) | 2 | 7 | 7 | 28859 | 2 | ||
116322 | 225918 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 1619 Alabama St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6009320.79374 | 2100001.018 | 37.7467289623867 | -122.41049539576 | (37.7467289623867, -122.41049539576) | 2 | 7 | 7 | 28859 | 2 | |||
72350 | 225922 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 22 Franconia St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 6009935.78986 | 2099989.59836 | 37.7467320650326 | -122.408367985612 | (37.7467320650326, -122.408367985612) | 2 | 7 | 7 | 28859 | 2 | |||
34641 | 108168 | Permitted Site 7 | Geijera parviflora :: Australian Willow 25 | 2x FRANCONIA ST | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 6009949 | 2099997 | 37.74675312806 | -122.40832282803 | (37.74675312806, -122.40832282803) | 2 | 7 | 7 | 28859 | 2 | ||||
139962 | 67087 | Permitted Site 7 | Geijera parviflora :: Australian Willow 25 | 2x FRANCONIA ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/23/1992 12:00:00 AM | Permit Number 30488 | 6009949 | 2099997 | 37.74675312806 | -122.40832282803 | (37.74675312806, -122.40832282803) | 2 | 7 | 7 | 28859 | 2 | ||
89804 | 108167 | Permitted Site 7 | Geijera parviflora :: Australian Willow 25 | 2x FRANCONIA ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 6009908 | 2100009 | 37.7467837814289 | -122.40846544894 | (37.7467837814289, -122.40846544894) | 2 | 7 | 7 | 28859 | 2 | ||||
28366 | 36001 | Permitted Site 7 | Geijera parviflora :: Australian Willow 25 | 172 Precita Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/27/1998 12:00:00 AM | Permit Number 39150 | 6007547.55752373 | 2100224.75713647 | 37.7472437298861 | -122.41664293336 | (37.7472437298861, -122.41664293336) | 2 | 7 | 7 | 28859 | 2 | ||
60771 | 36002 | Permitted Site 7 | Geijera parviflora :: Australian Willow 25 | 183 Precita Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/27/1998 12:00:00 AM | Permit Number 39151 | 6007567.43623945 | 2100291.02417946 | 37.747426802297 | -122.416578887563 | (37.747426802297, -122.416578887563) | 2 | 7 | 7 | 28859 | 2 | ||
142175 | 225966 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 183 Precita Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 6007593.94414 | 2100298.17812 | 37.7474479361811 | -122.416487731444 | (37.7474479361811, -122.416487731444) | 2 | 7 | 7 | 28859 | 2 | |||
167519 | 225923 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 1523 Florida St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 6009609.76682 | 2100372.84408 | 37.7477661109153 | -122.409522389545 | (37.7477661109153, -122.409522389545) | 2 | 7 | 7 | 28859 | 2 | |||
15108 | 113387 | Permitted Site 7 | Geijera parviflora :: Australian Willow 25 | 185 CASTENADA AVE | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 5994493 | 2100782 | 37.7480309194949 | -122.461824674651 | (37.7480309194949, -122.461824674651) | 1 | 8 | 4 | 29491 | 40 | ||||
55201 | 113388 | Permitted Site 7 | Geijera parviflora :: Australian Willow 25 | 185 CASTENADA AVE | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 5994493 | 2100782 | 37.7480309194949 | -122.461824674651 | (37.7480309194949, -122.461824674651) | 1 | 8 | 4 | 29491 | 40 | ||||
89613 | 113389 | Permitted Site 7 | Geijera parviflora :: Australian Willow 25 | 185 CASTENADA AVE | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 5994493 | 2100782 | 37.7480309194949 | -122.461824674651 | (37.7480309194949, -122.461824674651) | 1 | 8 | 4 | 29491 | 40 | ||||
31110 | 48958 | Permitted Site 7 | Geijera parviflora :: Australian Willow 25 | 1521 Florida St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/26/2002 12:00:00 AM | Permit Number 46145 | 6009607.60540748 | 2100518.70293664 | 37.7481664860313 | -122.40954015648 | (37.7481664860313, -122.40954015648) | 2 | 7 | 7 | 28859 | 2 | |||
85822 | 48957 | Permitted Site 7 | Geijera parviflora :: Australian Willow 25 | 1521 Florida St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/26/2002 12:00:00 AM | Permit Number 46145 | 6009607.60540748 | 2100518.70293664 | 37.7481664860313 | -122.40954015648 | (37.7481664860313, -122.40954015648) | 2 | 7 | 7 | 28859 | 2 | |||
109935 | 48959 | Permitted Site 7 | Geijera parviflora :: Australian Willow 25 | 1521 Florida St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/26/2002 12:00:00 AM | Permit Number 46145 | 6009607.60540748 | 2100518.70293664 | 37.7481664860313 | -122.40954015648 | (37.7481664860313, -122.40954015648) | 2 | 7 | 7 | 28859 | 2 | |||
179106 | 10227 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 1404 Guerrero St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 50 | 3x3 | 6005821.31625 | 2100751.57346 | 37.7485930087737 | -122.422649583919 | (37.7485930087737, -122.422649583919) | 2 | 4 | 5 | 28859 | 19 | |||
38898 | 225905 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 3620 26th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 4ft | 6006092.03845 | 2100850.85024 | 37.7488808700704 | -122.421720479039 | (37.7488808700704, -122.421720479039) | 2 | 4 | 5 | 28859 | 19 | |||
160188 | 46336 | Permitted Site 7 | Geijera parviflora :: Australian Willow 25 | 3458 26th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/13/2002 12:00:00 AM | Permit Number 44586 | 6006755.84747481 | 2100893.1278825 | 37.7490343653145 | -122.419428021305 | (37.7490343653145, -122.419428021305) | 2 | 4 | 7 | 28859 | 19 | ||
63701 | 27660 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 1360 Guerrero St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 35 | 3x3 | 6005798.59708 | 2101052.03016 | 37.7494167122272 | -122.422749495892 | (37.7494167122272, -122.422749495892) | 2 | 4 | 5 | 28859 | 19 | |||
143306 | 225933 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 1256 Treat Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6008673.75291 | 2101213.64343 | 37.7500222662216 | -122.41281852357 | (37.7500222662216, -122.41281852357) | 2 | 4 | 7 | 28859 | 19 | |||
92806 | 69223 | Permitted Site 7 | Geijera parviflora :: Australian Willow 25 | 1256 Treat Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/31/1994 12:00:00 AM | Permit Number 33275 | 6008667.10840058 | 2101226.16540452 | 37.7500562758063 | -122.412842385916 | (37.7500562758063, -122.412842385916) | 2 | 4 | 7 | 28859 | 19 | ||
89880 | 225934 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 1256 Treat Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 6008672.01096 | 2101240.80305 | 37.7500967426882 | -122.412826467282 | (37.7500967426882, -122.412826467282) | 2 | 4 | 7 | 28859 | 19 | |||
112761 | 69222 | Permitted Site 7 | Geijera parviflora :: Australian Willow 25 | 1250 Treat Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/15/2001 12:00:00 AM | 3x3 | Permit Number 33274 | 6008665.27491562 | 2101259.70225891 | 37.7501482575919 | -122.412851097008 | (37.7501482575919, -122.412851097008) | 2 | 4 | 7 | 28859 | 19 | |
8075 | 225935 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 1250 Treat Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/31/1994 12:00:00 AM | 10 | Width 3ft | Permit Number 33274 | 6008670.47689 | 2101262.07632 | 37.7501550682215 | -122.412833276033 | (37.7501550682215, -122.412833276033) | 2 | 4 | 7 | 28859 | 19 | |
140391 | 69220 | Permitted Site 7 | Geijera parviflora :: Australian Willow 25 | 1244 Treat Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/31/1994 12:00:00 AM | 3x3 | Permit Number 33272 | 6008663.44143065 | 2101293.23911329 | 37.7502402393754 | -122.412859808121 | (37.7502402393754, -122.412859808121) | 2 | 4 | 7 | 28859 | 19 | |
4939 | 225906 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 3749 25th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 3ft | 6005541.4535 | 2101364.78602 | 37.7502609561874 | -122.423660939909 | (37.7502609561874, -122.423660939909) | 2 | 4 | 5 | 28859 | 19 | |||
160588 | 225907 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 3749 25th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | Width 3ft | 6005583.06138 | 2101365.98068 | 37.7502665850353 | -122.423517141925 | (37.7502665850353, -122.423517141925) | 2 | 4 | 5 | 28859 | 19 | |||
192021 | 93025 | Permitted Site 7 | Geijera parviflora :: Australian Willow 25 | 3772 25th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6005372 | 2101391 | 37.7503233669919 | -122.424248785816 | (37.7503233669919, -122.424248785816) | 2 | 4 | 5 | 28859 | 19 | |||||
85249 | 225908 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 3772 25th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 4ft | 6005343.316 | 2101393.98229 | 37.7503299359862 | -122.424348189214 | (37.7503299359862, -122.424348189214) | 2 | 4 | 5 | 28859 | 19 | |||
160376 | 225936 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 1232 Treat Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 6008666.40255 | 2101335.68894 | 37.7503569633096 | -122.412852569207 | (37.7503569633096, -122.412852569207) | 2 | 4 | 7 | 28859 | 19 | |||
187856 | 225937 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 1232 Treat Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 6008665.07635 | 2101351.07554 | 37.7503991370286 | -122.412858243028 | (37.7503991370286, -122.412858243028) | 2 | 4 | 7 | 28859 | 19 | |||
94309 | 69219 | Permitted Site 7 | Geijera parviflora :: Australian Willow 25 | 1232 Treat Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/31/1994 12:00:00 AM | Permit Number 33271 | 6008659.77445957 | 2101360.31284296 | 37.7504242029934 | -122.412877230419 | (37.7504242029934, -122.412877230419) | 2 | 4 | 7 | 28859 | 19 | ||
171069 | 225938 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 1232 Treat Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 6008664.0646 | 2101365.80196 | 37.7504395156908 | -122.412862782791 | (37.7504395156908, -122.412862782791) | 2 | 4 | 7 | 28859 | 19 | |||
155371 | 225951 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 4401 24th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6000607.24532 | 2101675.70073 | 37.7508348927316 | -122.440746005644 | (37.7508348927316, -122.440746005644) | 2 | 4 | 5 | 28862 | 22 | |||
185087 | 69160 | Permitted Site 7 | Geijera parviflora :: Australian Willow 25 | 3272 25th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/26/1994 12:00:00 AM | Permit Number 33197 | 6007895.60997349 | 2101540.97783702 | 37.7508773450466 | -122.415532563624 | (37.7508773450466, -122.415532563624) | 2 | 4 | 7 | 28859 | 19 | ||
59021 | 221893 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 3164 25th St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 6008601.79804 | 2101572.78068 | 37.7510043375848 | -122.413092739446 | (37.7510043375848, -122.413092739446) | 2 | 4 | 7 | 28859 | 19 | |||
83523 | 221894 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 3164 25th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 6008618.93304 | 2101573.97925 | 37.7510085904948 | -122.413033569448 | (37.7510085904948, -122.413033569448) | 2 | 4 | 7 | 28859 | 19 | |||
174260 | 75710 | Undocumented 4 | Geijera parviflora :: Australian Willow 25 | 1190 Treat Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/04/1993 12:00:00 AM | 12 | 18x3 | 6008645.48606603 | 2101619.0486747 | 37.7511338315754 | -122.412944932355 | (37.7511338315754, -122.412944932355) | 2 | 4 | 7 | 28859 | 19 | ||
177781 | 26513 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 2864 Harrison St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 35 | 3X3 | 6008948.96043 | 2101783.08136 | 37.7516012590109 | -122.411907072357 | (37.7516012590109, -122.411907072357) | 2 | 4 | 7 | 28859 | 19 | |||
2212 | 225967 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 3599 24th St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6005877.12817 | 2101963.64024 | 37.7519242145407 | -122.422542702196 | (37.7519242145407, -122.422542702196) | 2 | 4 | 5 | 28859 | 19 | |||
132865 | 225968 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 3599 24th St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 20 | Width 3ft | 6005865.3441 | 2101966.56287 | 37.7519315746039 | -122.422583660903 | (37.7519315746039, -122.422583660903) | 2 | 4 | 5 | 28859 | 19 | |||
178381 | 254173 | Significant Tree 6 | Geijera parviflora :: Australian Willow 25 | 1850 19th Ave | 1 | Front Yard : Yard | Tree | Private 2 | 3x6 | 5990394 | 2102783 | 37.7532883185876 | -122.476144836826 | (37.7532883185876, -122.476144836826) | 1 | 8 | 4 | 56 | 12 | ||||
143129 | 225952 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 800 Alvarado St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6001178.25767 | 2102625.59939 | 37.7534755882504 | -122.438839459988 | (37.7534755882504, -122.438839459988) | 2 | 4 | 5 | 28862 | 22 | |||
91917 | 34747 | Permitted Site 7 | Geijera parviflora :: Australian Willow 25 | 2747 Harrison St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/28/1997 12:00:00 AM | Permit Number 38395 | 6008968.42681544 | 2102467.18370323 | 37.7534807427404 | -122.411888091902 | (37.7534807427404, -122.411888091902) | 2 | 4 | 7 | 28859 | 19 | ||
108269 | 26529 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 2747 Harrison St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 10 | 3x3 | 6008970.13177 | 2102467.22828 | 37.75348096079 | -122.411882198931 | (37.75348096079, -122.411882198931) | 2 | 4 | 7 | 28859 | 19 | |||
24456 | 225946 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 3557 23rd St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 3ft | 6005893.76776 | 2102550.85426 | 37.7535375074585 | -122.422526882211 | (37.7535375074585, -122.422526882211) | 2 | 4 | 5 | 28859 | 19 |
Advanced export
JSON shape: default, array, newline-delimited, object
CREATE TABLE "trees" ( [rowid] INTEGER PRIMARY KEY, [TreeID] TEXT, [qLegalStatus_id] INTEGER REFERENCES [qLegalStatus]([id]), [qSpecies_id] INTEGER, [qAddress] TEXT, [SiteOrder] TEXT, [qSiteInfo] TEXT, [PlantType] TEXT, [qCaretaker_id] INTEGER REFERENCES [qCaretaker]([id]), [qCareAssistant] TEXT, [PlantDate] TEXT, [DBH] TEXT, [PlotSize] TEXT, [PermitNotes] TEXT, [XCoord] TEXT, [YCoord] TEXT, [Latitude] TEXT, [Longitude] TEXT, [Location] TEXT, [Fire Prevention Districts] TEXT, [Police Districts] TEXT, [Supervisor Districts] TEXT, [Zip Codes] TEXT, [Neighborhoods (old)] TEXT, FOREIGN KEY(qSpecies_id) REFERENCES qSpecies(id) );