trees
229 rows where Police Districts = 3 and qSpecies_id = 50 sorted by rowid descending
This data as json, CSV (advanced)
rowid ▲ | TreeID | qLegalStatus_id | qSpecies_id | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker_id | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location | Fire Prevention Districts | Police Districts | Supervisor Districts | Zip Codes | Neighborhoods (old) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
192737 | 38603 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 1556 Revere Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/02/2008 12:00:00 AM | 4 | 3x3 | Permit Number 50557 | 6015358.9468 | 2094230.8253 | 37.7312218531881 | -122.389213037195 | (37.7312218531881, -122.389213037195) | 10 | 3 | 8 | 58 | 1 | |
191516 | 34323 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/14/1997 12:00:00 AM | Permit Number 38095 | 6011565.66175485 | 2101164.33215433 | 37.7500487659499 | -122.402814623369 | (37.7500487659499, -122.402814623369) | 10 | 3 | 8 | 28856 | 29 | ||||
191321 | 52004 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 1242 De Haro St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/06/2005 12:00:00 AM | 3 | Permit Number 48221 | 6012214.20801 | 2102602.19108 | 37.7540330051314 | -122.400672898747 | (37.7540330051314, -122.400672898747) | 10 | 3 | 8 | 28856 | 29 | |
190935 | 49831 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 547@ 20th S Missouri St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/11/2003 12:00:00 AM | 9 | Permit Number 46614 | 6013570.32082 | 2104515.66669 | 37.7593625359769 | -122.396117192266 | (37.7593625359769, -122.396117192266) | 10 | 3 | 8 | 28856 | 29 | |
189822 | 190711 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 285 Texas St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 19 | Width 3ft | 6013779.84023 | 2105755.3163 | 37.7627779983326 | -122.395479414663 | (37.7627779983326, -122.395479414663) | 14 | 3 | 8 | 28856 | 29 | |||
189461 | 34328 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/14/1997 12:00:00 AM | Permit Number 38095 | 6011565.66175485 | 2101164.33215433 | 37.7500487659499 | -122.402814623369 | (37.7500487659499, -122.402814623369) | 10 | 3 | 8 | 28856 | 29 | ||||
189285 | 32982 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 559 Texas St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/01/1996 12:00:00 AM | 14 | Permit Number 37295 | 6013853.095 | 2104468.98134 | 37.7592500775456 | -122.395135943769 | (37.7592500775456, -122.395135943769) | 10 | 3 | 8 | 28856 | 29 | |
189188 | 32942 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 999X Minnesota St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/01/1996 12:00:00 AM | 13 | Permit Number 37261 | 6015289.11919 | 2103969.28048 | 37.7579577598656 | -122.390134526983 | (37.7579577598656, -122.390134526983) | 10 | 3 | 8 | 28856 | 29 | |
187364 | 67473 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 880 Wisconsin St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/08/1992 12:00:00 AM | 6 | Permit Number 30995 | 6012731.18304 | 2103360.24925 | 37.7561432876862 | -122.398938264795 | (37.7561432876862, -122.398938264795) | 10 | 3 | 8 | 28856 | 29 | |
186473 | 106865 | Undocumented 4 | Jacaranda mimosifolia :: Jacaranda 50 | 580 MISSISSIPPI ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6014062.5 | 2104405.5 | 37.7590874145177 | -122.394407269796 | (37.7590874145177, -122.394407269796) | 10 | 3 | 8 | 28856 | 29 | |||||
185042 | 32948 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 307 Arkansas St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/01/1996 12:00:00 AM | 9 | Permit Number 37265 | 6012947.03092 | 2105601.86977 | 37.7623103112918 | -122.398349060474 | (37.7623103112918, -122.398349060474) | 10 | 3 | 8 | 28856 | 29 | ||
185009 | 39550 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 815 Carolina St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/28/1998 12:00:00 AM | 8 | Permit Number 40976 | 6012466.96888 | 2104165.36194 | 37.7583392243866 | -122.399908546943 | (37.7583392243866, -122.399908546943) | 10 | 3 | 8 | 28856 | 29 | |
184669 | 39568 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 800 Kansas St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/28/1998 12:00:00 AM | 13 | Permit Number 40987 | 6011544.30248 | 2104593.03235 | 37.7594620297563 | -122.40312963434 | (37.7594620297563, -122.40312963434) | 10 | 3 | 8 | 28856 | 29 | |
184626 | 88048 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 1555 Jerrold Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/24/2008 12:00:00 AM | 4 | 3x3 | Permit Number 51058 | 6015584.72865 | 2096785.64052 | 37.73824937351 | -122.388610732819 | (37.73824937351, -122.388610732819) | 10 | 3 | 8 | 58 | 1 | |
184316 | 34332 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/14/1997 12:00:00 AM | Permit Number 38095 | 6011565.66175485 | 2101164.33215433 | 37.7500487659499 | -122.402814623369 | (37.7500487659499, -122.402814623369) | 10 | 3 | 8 | 28856 | 29 | ||||
183793 | 58933 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 1330 Rhode Island St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/28/1980 12:00:00 AM | 7 | Permit Number 18211 | 6011958.83687 | 2102173.28777 | 37.7528410841477 | -122.401525896729 | (37.7528410841477, -122.401525896729) | 10 | 3 | 8 | 28856 | 29 | ||
183431 | 10960 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 1430 Hudson Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 06/21/2018 12:00:00 AM | 3 | 3X4 | Permit Number 782059 | 6016587.34912 | 2096809.91728 | 37.7383715463994 | -122.385145824822 | (37.7383715463994, -122.385145824822) | 10 | 3 | 8 | 58 | 1 | |
179950 | 32943 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 999X Minnesota St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/01/1996 12:00:00 AM | 8 | 3x3 | Permit Number 37261 | 6015287.47006 | 2104039.63341 | 37.7581508424957 | -122.390145145285 | (37.7581508424957, -122.390145145285) | 10 | 3 | 8 | 28856 | 29 |
179728 | 34310 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 20 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/14/1997 12:00:00 AM | Permit Number 38095 | 6011565.66175485 | 2101164.33215433 | 37.7500487659499 | -122.402814623369 | (37.7500487659499, -122.402814623369) | 10 | 3 | 8 | 28856 | 29 | ||||
179676 | 38602 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 1556 Revere Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/02/2008 12:00:00 AM | 5 | 3x3 | Permit Number 50557 | 6015367.191 | 2094226.978 | 37.7312117463081 | -122.389184266735 | (37.7312117463081, -122.389184266735) | 10 | 3 | 8 | 58 | 1 | |
179328 | 190713 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 529 Texas St | 3 | : | Tree | Private 2 | 7 | Width 3ft | 6013844.95879 | 2104593.96331 | 37.7595927983841 | -122.395172837551 | (37.7595927983841, -122.395172837551) | 10 | 3 | 8 | 28856 | 29 | |||
176891 | 190742 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 1617 Kirkwood Ave | 1 | : | Tree | Private 2 | 4 | Width 4ft | 6015073.9615 | 2096817.26033 | 37.7383078753038 | -122.390378936647 | (37.7383078753038, -122.390378936647) | 10 | 3 | 8 | 58 | 1 | |||
175485 | 94191 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 529 Texas St | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/22/2010 12:00:00 AM | 3x3 | Permit Number 53584 | 6013839 | 2104639 | 37.7597161279512 | -122.395196600917 | (37.7597161279512, -122.395196600917) | 10 | 3 | 8 | 28856 | 29 | |||
175462 | 196543 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 975 De Haro St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/29/2018 12:00:00 AM | 5 | Width 3ft | 6012204.60388 | 2103877.56611 | 37.7575343698359 | -122.400795707451 | (37.7575343698359, -122.400795707451) | 10 | 3 | 8 | 28856 | 29 | ||
174641 | 67525 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 1237 19th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/22/1992 12:00:00 AM | 5 | Permit Number 31063 | 6013863.96904 | 2105222.10332 | 37.7613185911004 | -122.395151089252 | (37.7613185911004, -122.395151089252) | 10 | 3 | 8 | 28856 | 29 | |
173427 | 68130 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 636 Texas St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/20/1993 12:00:00 AM | Permit Number 31881 | 6013816.64959872 | 2104131.08746025 | 37.75832026754 | -122.395238321176 | (37.75832026754, -122.395238321176) | 10 | 3 | 8 | 28856 | 29 | ||
172142 | 255773 | Planning Code 138.1 required 2 | Jacaranda mimosifolia :: Jacaranda 50 | 450 Toland St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/10/2018 12:00:00 AM | 3 | Permit Number 779472 | 6012768.71675 | 2099101.44192 | 37.7444516111373 | -122.398509629682 | (37.7444516111373, -122.398509629682) | 10 | 3 | 8 | 58 | 1 | ||
171733 | 190694 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 99 Missouri St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6013445.19565 | 2106684.95045 | 37.7653119497171 | -122.396702014197 | (37.7653119497171, -122.396702014197) | 14 | 3 | 8 | 28856 | 20 | |||
169649 | 190741 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 1786 Quesada Ave | 1 | : | Tree | Private 2 | 6 | Width 3ft | 6014282.60323 | 2095390.34812 | 37.7343459381091 | -122.393015276746 | (37.7343459381091, -122.393015276746) | 10 | 3 | 8 | 58 | 1 | |||
169574 | 121581 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 199X Texas St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 2 | 3x3 | 6013754.46885 | 2106222.83027 | 37.764060277784 | -122.395599922908 | (37.764060277784, -122.395599922908) | 14 | 3 | 8 | 28856 | 29 | ||
168986 | 190710 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 715 Wisconsin St | 2 | : | Tree | Private 2 | 11 | Width 3ft | 6012743.45877 | 2104190.05175 | 37.7584224278606 | -122.398954049707 | (37.7584224278606, -122.398954049707) | 10 | 3 | 8 | 28856 | 29 | |||
167135 | 34334 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 12 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/14/1997 12:00:00 AM | Permit Number 38095 | 6011565.66175485 | 2101164.33215433 | 37.7500487659499 | -122.402814623369 | (37.7500487659499, -122.402814623369) | 10 | 3 | 8 | 28856 | 29 | ||||
165341 | 34325 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/14/1997 12:00:00 AM | Permit Number 38095 | 6011565.66175485 | 2101164.33215433 | 37.7500487659499 | -122.402814623369 | (37.7500487659499, -122.402814623369) | 10 | 3 | 8 | 28856 | 29 | ||||
164964 | 108456 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 980 Minnesota St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | 6015231.85708 | 2103981.85157 | 37.7579891012316 | -122.390333443542 | (37.7579891012316, -122.390333443542) | 10 | 3 | 8 | 28856 | 29 | ||||
163887 | 34330 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/14/1997 12:00:00 AM | Permit Number 38095 | 6011565.66175485 | 2101164.33215433 | 37.7500487659499 | -122.402814623369 | (37.7500487659499, -122.402814623369) | 10 | 3 | 8 | 28856 | 29 | ||||
162785 | 34322 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 27 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/14/1997 12:00:00 AM | Permit Number 38095 | 6011565.66175485 | 2101164.33215433 | 37.7500487659499 | -122.402814623369 | (37.7500487659499, -122.402814623369) | 10 | 3 | 8 | 28856 | 29 | ||||
161840 | 148099 | Planning Code 138.1 required 2 | Jacaranda mimosifolia :: Jacaranda 50 | 509 Holyoke St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/19/2018 12:00:00 AM | 3 | 4x4 | Permit Number 782106 | 6009909.13224 | 2092063.05855 | 37.7249659929773 | -122.40790129952 | (37.7249659929773, -122.40790129952) | 10 | 3 | 7 | 309 | 28 | |
161547 | 68190 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 1625 19th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/29/1993 12:00:00 AM | 9 | Permit Number 31967 | 6012798.25639 | 2105161.94327 | 37.761094081638 | -122.398832742859 | (37.761094081638, -122.398832742859) | 10 | 3 | 8 | 28856 | 29 | ||
161520 | 41430 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 514 Connecticut St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 03/29/2018 12:00:00 AM | 5 | Permit Number 43060 | 6013229.56642 | 2104526.4373 | 37.7593731443828 | -122.397296450777 | (37.7593731443828, -122.397296450777) | 10 | 3 | 8 | 28856 | 29 | |
160328 | 34333 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 11 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/14/1997 12:00:00 AM | Permit Number 38095 | 6011565.66175485 | 2101164.33215433 | 37.7500487659499 | -122.402814623369 | (37.7500487659499, -122.402814623369) | 10 | 3 | 8 | 28856 | 29 | ||||
159008 | 190714 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 375 Texas St | 2 | : | Tree | Private 2 | 4 | Width 5ft | 6013800.48111 | 2105372.99908 | 37.7617293870175 | -122.395381240171 | (37.7617293870175, -122.395381240171) | 10 | 3 | 8 | 28856 | 29 | |||
157884 | 32980 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 553 Texas St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/01/1996 12:00:00 AM | 12 | Permit Number 37293 | 6013848.61872 | 2104519.06137 | 37.7593873374867 | -122.395154932952 | (37.7593873374867, -122.395154932952) | 10 | 3 | 8 | 28856 | 29 | |
157772 | 34316 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 26 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/14/1997 12:00:00 AM | Permit Number 38095 | 6011565.66175485 | 2101164.33215433 | 37.7500487659499 | -122.402814623369 | (37.7500487659499, -122.402814623369) | 10 | 3 | 8 | 28856 | 29 | ||||
156367 | 94883 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 1786 Quesada Ave | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/23/2010 12:00:00 AM | 3x3 | Permit Number 53950 | 6014292.7 | 2095395.8 | 37.7343614687147 | -122.392980749985 | (37.7343614687147, -122.392980749985) | 10 | 3 | 8 | 58 | 1 | ||
156260 | 40004 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 911 Innes Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/03/1999 12:00:00 AM | 2 | Permit Number 41258 | 6019111.21169 | 2094496.3329 | 37.7321581870346 | -122.376259043617 | (37.7321581870346, -122.376259043617) | 10 | 3 | 8 | 58 | 1 | |
156109 | 34315 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 25 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/14/1997 12:00:00 AM | Permit Number 38095 | 6011565.66175485 | 2101164.33215433 | 37.7500487659499 | -122.402814623369 | (37.7500487659499, -122.402814623369) | 10 | 3 | 8 | 28856 | 29 | ||||
155492 | 38276 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 651 Texas St | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/27/1998 12:00:00 AM | 3 | Permit Number 40367 | 6013924.79961 | 2103962.8321 | 37.7578642888268 | -122.394852504434 | (37.7578642888268, -122.394852504434) | 10 | 3 | 8 | 28856 | 29 | ||
153794 | 190695 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 99 Missouri St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6013444.76571 | 2106699.32295 | 37.7653513894931 | -122.396704508917 | (37.7653513894931, -122.396704508917) | 14 | 3 | 8 | 28856 | 20 | |||
152666 | 32965 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 550 Mississippi St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/01/1996 12:00:00 AM | 11 | 7x6 | Permit Number 37280 | 6014071.41137 | 2104533.66356 | 37.7594398192185 | -122.394385423553 | (37.7594398192185, -122.394385423553) | 10 | 3 | 8 | 28856 | 29 |
152448 | 40005 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 911 Innes Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/03/1999 12:00:00 AM | Permit Number 41258 | 6019178.20708985 | 2094459.30382263 | 37.7320602007089 | -122.376024856319 | (37.7320602007089, -122.376024856319) | 10 | 3 | 8 | 58 | 1 | ||
152140 | 200047 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 1582 Shafter Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 0ft | 6015033.0267 | 2094124.7502 | 37.7309125188233 | -122.390332402249 | (37.7309125188233, -122.390332402249) | 10 | 3 | 8 | 58 | 1 | |||
150369 | 37965 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 448 Missouri St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/08/1998 12:00:00 AM | Permit Number 40196 | 6013488.00942657 | 2104993.46196391 | 37.7606698772605 | -122.396435357808 | (37.7606698772605, -122.396435357808) | 10 | 3 | 8 | 28856 | 29 | ||
150302 | 34324 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 15 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/14/1997 12:00:00 AM | Permit Number 38095 | 6011565.66175485 | 2101164.33215433 | 37.7500487659499 | -122.402814623369 | (37.7500487659499, -122.402814623369) | 10 | 3 | 8 | 28856 | 29 | ||||
149993 | 88471 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 1525 Jerrold Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/18/2008 12:00:00 AM | 3 | 3x3 | Permit Number 51425 | 6015740.82967 | 2096670.14534 | 37.7379408970519 | -122.388062950362 | (37.7379408970519, -122.388062950362) | 10 | 3 | 8 | 58 | 1 | |
149126 | 38643 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 850 Wisconsin St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/29/1998 12:00:00 AM | 8 | Permit Number 41006 | 6012722.66852 | 2103506.4045 | 37.7565441236392 | -122.398977968961 | (37.7565441236392, -122.398977968961) | 10 | 3 | 8 | 28856 | 29 | |
148478 | 34331 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/14/1997 12:00:00 AM | Permit Number 38095 | 6011565.66175485 | 2101164.33215433 | 37.7500487659499 | -122.402814623369 | (37.7500487659499, -122.402814623369) | 10 | 3 | 8 | 28856 | 29 | ||||
147729 | 54450 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 435 Vermont St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/16/2008 12:00:00 AM | 2 | 3x3 | Permit Number 51720 | 6011224.5432 | 2106327.02843 | 37.7642053321404 | -122.40435757586 | (37.7642053321404, -122.40435757586) | 8 | 3 | 8 | 28856 | 29 | |
147463 | 49994 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 908@ 20TH ST Kansas St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/25/2003 12:00:00 AM | 8 | Permit Number 46738 | 6011568.01566 | 2104131.09801 | 37.7581949848158 | -122.403015130859 | (37.7581949848158, -122.403015130859) | 10 | 3 | 8 | 28856 | 29 | |
146544 | 190691 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 1005 Minnesota St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 4 | Width 4ft | 6015298.33049 | 2103800.67785 | 37.757495323968 | -122.390090891879 | (37.757495323968, -122.390090891879) | 10 | 3 | 8 | 28856 | 29 | |||
146004 | 201527 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 740 Earl St | 4 | : | Tree | Private 2 | 6 | Width 5ft | 6020341.20189 | 2093704.82943 | 37.7300525126033 | -122.371951898056 | (37.7300525126033, -122.371951898056) | 10 | 3 | 8 | 58 | 1 | |||
143485 | 190686 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 801 Mariposa St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6014799.41703 | 2106205.91343 | 37.7640718970256 | -122.391984541257 | (37.7640718970256, -122.391984541257) | 14 | 3 | 8 | 28856 | 29 | |||
142907 | 34337 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 14 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/14/1997 12:00:00 AM | Permit Number 38095 | 6011565.66175485 | 2101164.33215433 | 37.7500487659499 | -122.402814623369 | (37.7500487659499, -122.402814623369) | 10 | 3 | 8 | 28856 | 29 | ||||
141895 | 67581 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 321 Connecticut St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/05/1992 12:00:00 AM | 10 | Permit Number 31145 | 6013230.15205 | 2105558.36958 | 37.7622066365616 | -122.39736679307 | (37.7622066365616, -122.39736679307) | 10 | 3 | 8 | 28856 | 29 | |
140964 | 39588 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 1070 Rhode Island St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/29/1998 12:00:00 AM | 9 | Permit Number 40999 | 6011886.49797 | 2103421.11928 | 37.7562633193119 | -122.401863767506 | (37.7562633193119, -122.401863767506) | 10 | 3 | 8 | 28856 | 29 | |
140682 | 66211 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 543 Rhode Island St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 03/29/2018 12:00:00 AM | 6 | 3x3 | Permit Number 53588 | 6011817.82357 | 2105837.41873 | 37.7628941088863 | -122.402271150494 | (37.7628941088863, -122.402271150494) | 8 | 3 | 8 | 28856 | 29 |
139065 | 34317 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 28 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/14/1997 12:00:00 AM | Permit Number 38095 | 6011565.66175485 | 2101164.33215433 | 37.7500487659499 | -122.402814623369 | (37.7500487659499, -122.402814623369) | 10 | 3 | 8 | 28856 | 29 | ||||
137130 | 38274 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 645 Texas St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/27/1998 12:00:00 AM | Permit Number 40367 | 6014125.41454299 | 2103884.52035605 | 37.7576604143577 | -122.394153206319 | (37.7576604143577, -122.394153206319) | 10 | 3 | 8 | 28856 | 29 | |||
136567 | 46565 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 642 Carolina St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/02/2002 12:00:00 AM | 11 | Permit Number 44700 | 6012366.61584 | 2104950.40498 | 37.7604891841446 | -122.400310752549 | (37.7604891841446, -122.400310752549) | 10 | 3 | 8 | 28856 | 29 | ||
134330 | 190745 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 1617 Kirkwood Ave | 1 | : | Tree | Private 2 | 4 | Width 3ft | 6015075.48119 | 2096817.46152 | 37.7383085120296 | -122.390373696315 | (37.7383085120296, -122.390373696315) | 10 | 3 | 8 | 58 | 1 | |||
131668 | 101142 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 450 Connecticut St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | 6x5 | 6013202.87541 | 2105008.80467 | 37.7606961334358 | -122.397422590588 | (37.7606961334358, -122.397422590588) | 10 | 3 | 8 | 28856 | 29 | |||
130836 | 62086 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 508 Connecticut St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/20/1985 12:00:00 AM | 4 | Permit Number 22172 | 6013224.51154 | 2104585.93548 | 37.7595362319382 | -122.397318105545 | (37.7595362319382, -122.397318105545) | 10 | 3 | 8 | 28856 | 29 | |
130744 | 190698 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 99 Missouri St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6013440.07088 | 2106805.70814 | 37.7656432383768 | -122.396728206061 | (37.7656432383768, -122.396728206061) | 14 | 3 | 8 | 28856 | 20 | |||
130713 | 38280 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 651 Texas St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/27/1998 12:00:00 AM | 12 | Permit Number 40367 | 6013876.1493 | 2104054.99501 | 37.7581146430008 | -122.395027213942 | (37.7581146430008, -122.395027213942) | 10 | 3 | 8 | 28856 | 29 | ||
129660 | 190687 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 1001 Minnesota St | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 4 | Width 4ft | 6015294.95519 | 2103873.52866 | 37.7576951695231 | -122.390107654354 | (37.7576951695231, -122.390107654354) | 10 | 3 | 8 | 28856 | 29 | |||
124187 | 190700 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 199 Texas St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6013754.83495 | 2106240.90179 | 37.7641099185662 | -122.395599922892 | (37.7641099185662, -122.395599922892) | 14 | 3 | 8 | 28856 | 29 | |||
123168 | 190683 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 1301 Minnesota St | 39 | Front Yard : Yard | Tree | Private 2 | 4 | 6015372.42654 | 2102509.76476 | 37.7539548603504 | -122.389744472134 | (37.7539548603504, -122.389744472134) | 10 | 3 | 8 | 28856 | 29 | ||||
121410 | 52722 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 1115 Kansas St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/18/2006 12:00:00 AM | 5 | Permit Number 48775 | 6011675.49817 | 2103219.4484 | 37.7556977977188 | -122.402579300492 | (37.7556977977188, -122.402579300492) | 10 | 3 | 8 | 28856 | 29 | ||
119742 | 39569 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 806 Kansas St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/28/1998 12:00:00 AM | 7 | Permit Number 40988 | 6011543.77687 | 2104583.27285 | 37.7594352029858 | -122.403130765671 | (37.7594352029858, -122.403130765671) | 10 | 3 | 8 | 28856 | 29 | |
119323 | 190685 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 801 Mariposa St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6014780.75112 | 2106205.10487 | 37.7640686405785 | -122.392049045151 | (37.7640686405785, -122.392049045151) | 14 | 3 | 8 | 28856 | 29 | |||
118901 | 37938 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 1833 19th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/08/1998 12:00:00 AM | 5 | Permit Number 40182 | 6012201.79932 | 2105128.09339 | 37.7609678851705 | -122.400893265015 | (37.7609678851705, -122.400893265015) | 10 | 3 | 8 | 28856 | 29 | |
118867 | 39570 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 806 Kansas St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/28/1998 12:00:00 AM | 7 | Permit Number 40988 | 6011544.20572 | 2104572.19135 | 37.759404799599 | -122.403128503001 | (37.759404799599, -122.403128503001) | 10 | 3 | 8 | 28856 | 29 | |
117756 | 35348 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 1142 De Haro St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/23/1998 12:00:00 AM | 10 | Permit Number 38811 | 6012185.95108 | 2103089.25023 | 37.7553687870439 | -122.400804834673 | (37.7553687870439, -122.400804834673) | 10 | 3 | 8 | 28856 | 29 | |
113967 | 32967 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 571 Mississippi St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/01/1996 12:00:00 AM | 8 | Permit Number 37282 | 6014131.46964 | 2104484.11535 | 37.7593071089655 | -122.394174242052 | (37.7593071089655, -122.394174242052) | 10 | 3 | 8 | 28856 | 29 | |
113872 | 190697 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 99 Missouri St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6013439.7362 | 2106789.19698 | 37.7655978837597 | -122.396728206045 | (37.7655978837597, -122.396728206045) | 14 | 3 | 8 | 28856 | 20 | |||
113140 | 39551 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 814 Carolina St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/28/1998 12:00:00 AM | 6 | Permit Number 40977 | 6012407.86986 | 2104192.73872 | 37.7584111000042 | -122.40011486132 | (37.7584111000042, -122.40011486132) | 10 | 3 | 8 | 28856 | 29 | |
111213 | 34335 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 21 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/14/1997 12:00:00 AM | Permit Number 38095 | 6011565.66175485 | 2101164.33215433 | 37.7500487659499 | -122.402814623369 | (37.7500487659499, -122.402814623369) | 10 | 3 | 8 | 28856 | 29 | ||||
110878 | 34326 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/14/1997 12:00:00 AM | Permit Number 38095 | 6011565.66175485 | 2101164.33215433 | 37.7500487659499 | -122.402814623369 | (37.7500487659499, -122.402814623369) | 10 | 3 | 8 | 28856 | 29 | ||||
109964 | 38604 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 1556 Revere Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/02/2008 12:00:00 AM | 4 | 3x3 | Permit Number 50557 | 6015379.8321 | 2094216.5354 | 37.7311837737961 | -122.389139834948 | (37.7311837737961, -122.389139834948) | 10 | 3 | 8 | 58 | 1 | |
109395 | 108714 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 443 Pennsylvania Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/02/2015 12:00:00 AM | 3 | 3x3 | Permit Number 773096 | 6014377.05047 | 2105069.75693 | 37.7609288007542 | -122.393365881138 | (37.7609288007542, -122.393365881138) | 10 | 3 | 8 | 28856 | 29 |
108357 | 190715 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 350 Texas St | 1 | : | Tree | Private 2 | 12 | Width 4ft | 6013737.51284 | 2105460.97147 | 37.7619674375704 | -122.395605187539 | (37.7619674375704, -122.395605187539) | 10 | 3 | 8 | 28856 | 29 | |||
107938 | 34311 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 32 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/14/1997 12:00:00 AM | Permit Number 38095 | 6011565.66175485 | 2101164.33215433 | 37.7500487659499 | -122.402814623369 | (37.7500487659499, -122.402814623369) | 10 | 3 | 8 | 28856 | 29 | ||||
106504 | 40804 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 585 Connecticut St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Permit Number 41753 | 6013297.80731 | 2104343.61694 | 37.7588749586426 | -122.397047620054 | (37.7588749586426, -122.397047620054) | 10 | 3 | 8 | 28856 | 29 | |||
103087 | 37937 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 1833 19th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/08/1998 12:00:00 AM | 8 | Permit Number 40182 | 6012230.73908 | 2105130.49486 | 37.7609760932842 | -122.400793343137 | (37.7609760932842, -122.400793343137) | 10 | 3 | 8 | 28856 | 29 | |
102909 | 38277 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 651 Texas St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/03/2017 12:00:00 AM | 3 | Permit Number 40367 | 6013910.55501 | 2103982.27082 | 37.7579168712948 | -122.394903129995 | (37.7579168712948, -122.394903129995) | 10 | 3 | 8 | 28856 | 29 | ||
102465 | 190690 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 1003 Minnesota St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 4 | Width 4ft | 6015296.6982 | 2103817.69544 | 37.7575419601034 | -122.390097725855 | (37.7575419601034, -122.390097725855) | 10 | 3 | 8 | 28856 | 29 | |||
102215 | 67601 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 559 Missouri St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/06/1992 12:00:00 AM | 13 | Permit Number 31171 | 6013574.79686 | 2104468.1921 | 37.7592324301472 | -122.396098384735 | (37.7592324301472, -122.396098384735) | 10 | 3 | 8 | 28856 | 29 | |
101836 | 190716 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 333 Arkansas St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 7 | Width 3ft | 6012961.26572 | 2105490.25457 | 37.7620046335244 | -122.398291995789 | (37.7620046335244, -122.398291995789) | 10 | 3 | 8 | 28856 | 29 | |||
100567 | 34321 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 19 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/14/1997 12:00:00 AM | Permit Number 38095 | 6011565.66175485 | 2101164.33215433 | 37.7500487659499 | -122.402814623369 | (37.7500487659499, -122.402814623369) | 10 | 3 | 8 | 28856 | 29 | ||||
99584 | 39586 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 1011 Rhode Island St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/28/1998 12:00:00 AM | 4 | Permit Number 40997 | 6011941.43836 | 2103546.16349 | 37.7566097291779 | -122.401682552328 | (37.7566097291779, -122.401682552328) | 10 | 3 | 8 | 28856 | 29 | |
99407 | 34313 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 23 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/14/1997 12:00:00 AM | Permit Number 38095 | 6011565.66175485 | 2101164.33215433 | 37.7500487659499 | -122.402814623369 | (37.7500487659499, -122.402814623369) | 10 | 3 | 8 | 28856 | 29 |
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) );