trees
353 rows where Supervisor Districts = 8 and qSpecies_id = 50 sorted by SiteOrder
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
35715 | 117954 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 75 Bridgeview Dr | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/05/2016 12:00:00 AM | 3 | 2.5x3 | 6013772.99018 | 2095538.96094 | 37.7347256767529 | -122.394787591666 | (37.7347256767529, -122.394787591666) | 10 | 3 | 8 | 58 | 1 | |||
42631 | 89008 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 707 Carolina St | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/16/2009 12:00:00 AM | 3x3 | Permit Number 52629 | 6012436 | 2104662 | 37.7597011565358 | -122.400050528825 | (37.7597011565358, -122.400050528825) | 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 | ||
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 | |||
779 | 69766 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 1725 Newcomb Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 8 | 6014547.15395 | 2096165.56329 | 37.7364892123042 | -122.392154828809 | (37.7364892123042, -122.392154828809) | 10 | 3 | 8 | 58 | 1 | |||
1622 | 78494 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 2131 24th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 5 | 6012056.35315 | 2102319.00627 | 37.7532466361332 | -122.401198904113 | (37.7532466361332, -122.401198904113) | 10 | 3 | 8 | 28856 | 29 | |||
2344 | 190703 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 707 Carolina St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6012441.45218 | 2104621.0711 | 37.759589078787 | -122.400028798005 | (37.759589078787, -122.400028798005) | 10 | 3 | 8 | 28856 | 29 | |||
3601 | 32960 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 934 Minnesota St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/01/1996 12:00:00 AM | 16 | 6x12 | Permit Number 37274 | 6015218.03519 | 2104239.88822 | 37.7586968478982 | -122.390399274809 | (37.7586968478982, -122.390399274809) | 10 | 3 | 8 | 28856 | 29 |
3966 | 249038 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 22 Carr St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/19/2019 12:00:00 AM | 3 | 4x6 | 6013079.09197 | 2090984.85367 | 37.7221824230653 | -122.396867469658 | (37.7221824230653, -122.396867469658) | 10 | 3 | 8 | 58 | 1 | |
4292 | 190709 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 715 Wisconsin St | 1 | : | Tree | Private 2 | 11 | Width 3ft | 6012742.49696 | 2104176.10053 | 37.7583840672751 | -122.398956396912 | (37.7583840672751, -122.398956396912) | 10 | 3 | 8 | 28856 | 29 | |||
4309 | 69898 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 1019 Rhode Island St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 4 | 6011946.5334 | 2103437.3528 | 37.756311243277 | -122.401657284058 | (37.756311243277, -122.401657284058) | 10 | 3 | 8 | 28856 | 29 | |||
5495 | 260381 | Undocumented 4 | Jacaranda mimosifolia :: Jacaranda 50 | 1924 Jennings St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 6015697 | 2093053 | 37.7280065148754 | -122.387962157958 | (37.7280065148754, -122.387962157958) | 10 | 3 | 8 | 58 | 1 | ||||
7992 | 249041 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 21 Carr St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/19/2019 12:00:00 AM | 3 | 4x6 | 6013113.97722 | 2090973.86381 | 37.7221541888428 | -122.396746108866 | (37.7221541888428, -122.396746108866) | 10 | 3 | 8 | 58 | 1 | |
8434 | 255770 | Planning Code 138.1 required 2 | Jacaranda mimosifolia :: Jacaranda 50 | 450 Toland St | 1 | 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 | ||
9289 | 260836 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 1536 McKinnon Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 6015652 | 2095724 | 37.7353380520345 | -122.388304065218 | (37.7353380520345, -122.388304065218) | 10 | 3 | 8 | 58 | 1 | ||||
9747 | 261106 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 85 Carr St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/19/2019 12:00:00 AM | 3 | 4x6 | 6013023 | 2090614 | 37.7211610112065 | -122.397035377595 | (37.7211610112065, -122.397035377595) | 10 | 3 | 8 | 58 | 1 | |
10612 | 78436 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 1379 Rhode Island St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 8 | 6012015.72942 | 2101977.35144 | 37.7523062600388 | -122.401315382525 | (37.7523062600388, -122.401315382525) | 10 | 3 | 8 | 28856 | 29 | |||
10948 | 261107 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 1324 Fitzgerald Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/19/2019 12:00:00 AM | 3 | 4x6 | 6014006 | 2091032 | 37.7223634274326 | -122.393666646077 | (37.7223634274326, -122.393666646077) | 10 | 3 | 8 | 58 | 1 | |
11458 | 35362 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 979 Rhode Island St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/23/1998 12:00:00 AM | 6 | Permit Number 38824 | 6011922.43629 | 2103880.66513 | 37.75752713659 | -122.401771780343 | (37.75752713659, -122.401771780343) | 10 | 3 | 8 | 28856 | 29 | |
11549 | 70665 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 550 Utah St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10 | 6010647.04803 | 2105639.57925 | 37.7622854639243 | -122.406306536234 | (37.7622854639243, -122.406306536234) | 8 | 4 | 8 | 28859 | 19 | |||
11826 | 43301 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 515 Texas St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/31/2005 12:00:00 AM | 6 | Permit Number 48334 | 6013838.69916 | 2104687.66336 | 37.7598497302126 | -122.395201050183 | (37.7598497302126, -122.395201050183) | 10 | 3 | 8 | 28856 | 29 | |
12120 | 70682 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 414 Utah St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 8 | 6010606.08274 | 2106339.87511 | 37.7642060264098 | -122.406497569303 | (37.7642060264098, -122.406497569303) | 8 | 4 | 8 | 28859 | 19 | |||
12291 | 190743 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 39 Latona St | 1 | : | Tree | Private 2 | 2 | Width 6ft | 6014419.07803 | 2094437.81167 | 37.7317380471513 | -122.392476830144 | (37.7317380471513, -122.392476830144) | 10 | 3 | 8 | 58 | 1 | |||
12628 | 259370 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 1466 Shafter Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 04/27/2019 12:00:00 AM | 3 | 6015644.90497 | 2093658.91441 | 37.7296673488753 | -122.388184521919 | (37.7296673488753, -122.388184521919) | 10 | 3 | 8 | 58 | 1 | ||
13205 | 69888 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 1094 De Haro St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10 | 6012175.72633 | 2103309.76161 | 37.7559736926594 | -122.400855686861 | (37.7559736926594, -122.400855686861) | 10 | 3 | 8 | 28856 | 29 | |||
13967 | 84622 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 382 Texas St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 5 | 6013742.24361 | 2105343.88141 | 37.761646197043 | -122.395580621644 | (37.761646197043, -122.395580621644) | 10 | 3 | 8 | 28856 | 29 | |||
14099 | 38381 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 1464 Rhode Island St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/17/2005 12:00:00 AM | 5 | Permit Number 48279 | 6011990.10357 | 2101552.61207 | 37.7511385883967 | -122.401374155011 | (37.7511385883967, -122.401374155011) | 10 | 3 | 8 | 28856 | 29 | |
14471 | 70661 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 460 Utah St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10 | 6010614.613 | 2106160.28585 | 37.7637133921776 | -122.40645540999 | (37.7637133921776, -122.40645540999) | 8 | 4 | 8 | 28859 | 19 | |||
14592 | 259355 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 1924 Jennings St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 05/25/2019 12:00:00 AM | 3 | 6015758.71756 | 2093108.46198 | 37.728162221452 | -122.387752664752 | (37.728162221452, -122.387752664752) | 10 | 3 | 8 | 58 | 1 | ||
14660 | 78429 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 744 Rhode Island St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 4 | 3x3 | 6011805.9335 | 2104893.37298 | 37.7603013058687 | -122.402245896623 | (37.7603013058687, -122.402245896623) | 10 | 3 | 8 | 28856 | 29 | ||
15198 | 70134 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 342-344 Utah St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 7 | 6010584.92199 | 2106684.72003 | 37.7651517084965 | -122.406595061225 | (37.7651517084965, -122.406595061225) | 8 | 4 | 8 | 28853 | 19 | |||
16486 | 150546 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 975 De Haro St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6012204.80057 | 2103865.42291 | 37.7575010382506 | -122.400794174114 | (37.7575010382506, -122.400794174114) | 10 | 3 | 8 | 28856 | 29 | |||
17504 | 261109 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 20 Latona St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/19/2019 12:00:00 AM | 3 | 4x6 | 6014376 | 2094477 | 37.7318432579921 | -122.392628501141 | (37.7318432579921, -122.392628501141) | 10 | 3 | 8 | 58 | 1 | ||
17748 | 78435 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 2036 22nd St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 6 | 6011985.6646 | 2103761.39443 | 37.7572031738156 | -122.401544727608 | (37.7572031738156, -122.401544727608) | 10 | 3 | 8 | 28856 | 29 | |||
18673 | 229819 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 713 York St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6009886.7617 | 2104802.87513 | 37.7599455053009 | -122.408877057635 | (37.7599455053009, -122.408877057635) | 2 | 4 | 8 | 28859 | 19 | |||
19354 | 262188 | Private 9 | Jacaranda mimosifolia :: Jacaranda 50 | 490 Vermont St | 1 | Front Yard : Cutout | Tree | DPW 1 | 05/19/2020 12:00:00 AM | 3 | 3x3 | Permit Number 784452 | 6011166 | 2106075 | 37.7635100471883 | -122.404542318782 | (37.7635100471883, -122.404542318782) | 8 | 3 | 8 | 28856 | 29 | |
20229 | 37987 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 613 Texas St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/08/1998 12:00:00 AM | 8 | Permit Number 40209 | 6013866.01576 | 2104192.39502 | 37.7584913501141 | -122.39507188416 | (37.7584913501141, -122.39507188416) | 10 | 3 | 8 | 28856 | 29 | |
21580 | 39574 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 863 Kansas St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/28/1998 12:00:00 AM | 7 | Permit Number 40991 | 6011617.31177 | 2104338.8923 | 37.7587682945481 | -122.402859256767 | (37.7587682945481, -122.402859256767) | 10 | 3 | 8 | 28856 | 29 | |
23234 | 48401 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 1170 Rhode Island St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/03/2008 12:00:00 AM | 7 | 3x3 | Permit Number 50635 | 6011912.33745 | 2102971.80272 | 37.7550310367587 | -122.401742823998 | (37.7550310367587, -122.401742823998) | 10 | 3 | 8 | 28856 | 29 | |
24397 | 47676 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 434 Pennsylvania Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/21/2002 12:00:00 AM | 6 | Permit Number 45460 | 6014318.70228 | 2105083.22351 | 37.7609625351244 | -122.393568625994 | (37.7609625351244, -122.393568625994) | 10 | 3 | 8 | 28856 | 29 | |
24742 | 37969 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 601 Missouri St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/08/1998 12:00:00 AM | 8 | Permit Number 40199 | 6013584.10507 | 2104296.87899 | 37.7587625595637 | -122.396054186654 | (37.7587625595637, -122.396054186654) | 10 | 3 | 8 | 28856 | 29 | |
24801 | 35349 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 1162 De Haro St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/23/1998 12:00:00 AM | 12 | Permit Number 38812 | 6012188.57169 | 2103037.28239 | 37.7552262409021 | -122.400792120955 | (37.7552262409021, -122.400792120955) | 10 | 3 | 8 | 28856 | 29 | |
26909 | 35338 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 738 Arkansas St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/23/1998 12:00:00 AM | 4 | Permit Number 38803 | 6013013.2913 | 2103555.40384 | 37.7566948554054 | -122.397976322051 | (37.7566948554054, -122.397976322051) | 10 | 3 | 8 | 28856 | 29 | |
28655 | 116872 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 1250 17th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | 3x3 | 6013499.86788 | 2106650.27714 | 37.7652197871992 | -122.396510483775 | (37.7652197871992, -122.396510483775) | 14 | 3 | 8 | 28856 | 20 | |||
29482 | 104712 | Undocumented 4 | Jacaranda mimosifolia :: Jacaranda 50 | 303 ARKANSAS ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | 3x4 | 6012983 | 2105615 | 37.7623483675995 | -122.39822557732 | (37.7623483675995, -122.39822557732) | 10 | 3 | 8 | 28856 | 29 | |||
29685 | 190682 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 546 Utah St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 4ft | 6010644.58891 | 2105668.45784 | 37.7623646204591 | -122.406317076288 | (37.7623646204591, -122.406317076288) | 8 | 4 | 8 | 28859 | 19 | |||
31469 | 78725 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 1300 Rhode Island St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/22/2010 12:00:00 AM | 5 | 3x3 | Permit Number 53574 | 6011951.34663 | 2102291.29231 | 37.7531646809082 | -122.401560092537 | (37.7531646809082, -122.401560092537) | 10 | 3 | 8 | 28856 | 29 | |
33862 | 106166 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 1051 De Haro St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | 6012226.18355 | 2103510.52022 | 37.7565277460814 | -122.400695290961 | (37.7565277460814, -122.400695290961) | 10 | 3 | 8 | 28856 | 29 | ||||
34108 | 190689 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 1001 Minnesota St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 5 | Width 4ft | 6015296.26829 | 2103832.96006 | 37.7575838496448 | -122.390100279027 | (37.7575838496448, -122.390100279027) | 10 | 3 | 8 | 28856 | 29 | |||
39242 | 49995 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 908@ 20TH ST Kansas St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/25/2003 12:00:00 AM | 7 | Permit Number 46738 | 6011567.97706 | 2104146.58896 | 37.7582375173758 | -122.403016353927 | (37.7582375173758, -122.403016353927) | 10 | 3 | 8 | 28856 | 29 | |
40910 | 50150 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 541@ 20TH ST Mississippi St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/07/2003 12:00:00 AM | 6 | Permit Number 46869 | 6014129.22762 | 2104572.8122 | 37.7595505266559 | -122.394188205843 | (37.7595505266559, -122.394188205843) | 10 | 3 | 8 | 28856 | 29 | |
41290 | 36062 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 1401 Bryant St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/28/1998 12:00:00 AM | Permit Number 39185 | 6009421.20140012 | 2108121.84074464 | 37.7690325354797 | -122.410721604896 | (37.7690325354797, -122.410721604896) | 8 | 4 | 8 | 28853 | 19 | ||
41324 | 122711 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 225 Arkansas St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | 3x3 | 6012928.83224 | 2105933.48701 | 37.7632198451537 | -122.398435273093 | (37.7632198451537, -122.398435273093) | 14 | 3 | 8 | 28856 | 29 | |||
42211 | 37964 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 422 Missouri St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/08/1998 12:00:00 AM | 6 | Permit Number 40195 | 6013476.64244 | 2105094.41315 | 37.760946434546 | -122.396481747729 | (37.760946434546, -122.396481747729) | 10 | 3 | 8 | 28856 | 29 | |
45524 | 67540 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 619 Wisconsin St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/05/1992 12:00:00 AM | 5 | Permit Number 31080 | 6012728.40675 | 2104463.00984 | 37.7591710721042 | -122.399025265205 | (37.7591710721042, -122.399025265205) | 10 | 3 | 8 | 28856 | 29 | |
45918 | 190719 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 642 Mississippi St | 1 | : | Tree | Private 2 | 13 | Width 4ft | 6014091.45327 | 2104130.33792 | 37.7583334885189 | -122.39428786959 | (37.7583334885189, -122.39428786959) | 10 | 3 | 8 | 28856 | 29 | |||
47404 | 190692 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 1007 Tennessee St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 5ft | 6015546.55953 | 2104430.75491 | 37.7592391453969 | -122.389276405591 | (37.7592391453969, -122.389276405591) | 10 | 3 | 8 | 28856 | 29 | |||
48539 | 121582 | Undocumented 4 | Jacaranda mimosifolia :: Jacaranda 50 | 199X Texas St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 3x3 | 6013716 | 2106401 | 37.7645473527506 | -122.395745461209 | (37.7645473527506, -122.395745461209) | 14 | 3 | 8 | 28856 | 29 | |||
49020 | 27140 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 1775 Silver Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 2X3 | 6011410.17472 | 2095355.19259 | 37.7340894298873 | -122.40294377776 | (37.7340894298873, -122.40294377776) | 10 | 3 | 8 | 58 | 1 | |||
49110 | 190693 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 949 Minnesota St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 11 | Width 6ft | 6015286.01268 | 2104068.80958 | 37.7582308731831 | -122.390152223841 | (37.7582308731831, -122.390152223841) | 10 | 3 | 8 | 28856 | 29 | |||
50375 | 52627 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 642@ 18th ST Hampshire St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/01/2006 12:00:00 AM | Permit Number 48710 | 6010085.91969508 | 2105298.86686021 | 37.7613185401792 | -122.408223245875 | (37.7613185401792, -122.408223245875) | 2 | 4 | 8 | 28859 | 19 | |||
50723 | 229783 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 975 San Bruno Ave | 1 | Sidewalk: Curb side : Pot | Tree | Private 2 | 12 | Width 4ft | 6011090.02369 | 2103815.82999 | 37.7573026253193 | -122.404646049572 | (37.7573026253193, -122.404646049572) | 10 | 4 | 8 | 28859 | 19 | |||
53657 | 190744 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 2086 Quesada Ave | 1 | Front Yard : Yard | Tree | Private 2 | 1 | 6012709.58294 | 2096557.7365 | 37.7374638381805 | -122.398535643704 | (37.7374638381805, -122.398535643704) | 10 | 3 | 8 | 58 | 1 | ||||
55836 | 46116 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 648 Carolina St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/27/2001 12:00:00 AM | Permit Number 44475 | 6012371.38389312 | 2104918.06745502 | 37.7604006583276 | -122.400291990633 | (37.7604006583276, -122.400291990633) | 10 | 3 | 8 | 28856 | 29 | |||
57164 | 32969 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 580 Mississippi St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/01/1996 12:00:00 AM | 14 | Permit Number 37284 | 6014077.45388 | 2104409.80131 | 37.7591000562486 | -122.394355852944 | (37.7591000562486, -122.394355852944) | 10 | 3 | 8 | 28856 | 29 | |
57517 | 32962 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 952 Minnesota St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/01/1996 12:00:00 AM | 12 | 6x12 | Permit Number 37276 | 6015219.88415 | 2104168.13629 | 37.7584999350397 | -122.390387866913 | (37.7584999350397, -122.390387866913) | 10 | 3 | 8 | 28856 | 29 |
57579 | 46098 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 624 Arkansas St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/18/2001 12:00:00 AM | 6 | Permit Number 44467 | 6012970.56549 | 2104146.6143 | 37.7583158105448 | -122.398165561015 | (37.7583158105448, -122.398165561015) | 10 | 3 | 8 | 28856 | 29 | ||
57967 | 49762 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 123@ GIRARD Ordway St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/23/2018 12:00:00 AM | 3 | Permit Number 781437 | 6011554.1535 | 2090217.48516 | 37.7199903867389 | -122.402084923384 | (37.7199903867389, -122.402084923384) | 10 | 7 | 8 | 309 | 28 | |
60196 | 121738 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 1201x Vermont St | 1 | Front Yard : Yard | Tree | DPW 1 | 3x3 | 6011405 | 2102539 | 37.7538143308772 | -122.403466904543 | (37.7538143308772, -122.403466904543) | 10 | 4 | 8 | 28859 | 19 | ||||
61281 | 58816 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 1939 20th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/08/1992 12:00:00 AM | 11 | Permit Number 31012 | 6012209.88383 | 2104659.20803 | 37.7596808806999 | -122.400832361144 | (37.7596808806999, -122.400832361144) | 10 | 3 | 8 | 28856 | 29 | |
63197 | 190746 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 1725 Newcomb Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 7 | Width 4ft | 6014545.66843 | 2096162.71895 | 37.7364813198484 | -122.392159766062 | (37.7364813198484, -122.392159766062) | 10 | 3 | 8 | 58 | 1 | |||
63833 | 190728 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 100 Utah St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 4ft | 6010522.48931 | 2107817.1778 | 37.7682576862591 | -122.406890823964 | (37.7682576862591, -122.406890823964) | 8 | 4 | 8 | 28853 | 19 | |||
64830 | 40096 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 359 Mississippi St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/12/2001 12:00:00 AM | 8 | Permit Number 44400 | 6014088.36289 | 2105304.3939 | 37.7615570193592 | -122.394380761457 | (37.7615570193592, -122.394380761457) | 10 | 3 | 8 | 28856 | 29 | ||
65454 | 106484 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 758 Arkansas St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/04/2016 12:00:00 AM | 1 | 3x3 | Permit Number 771079 | 6013015.32424 | 2103511.36307 | 37.7565740422689 | -122.397966201986 | (37.7565740422689, -122.397966201986) | 10 | 3 | 8 | 28856 | 29 | |
66331 | 94180 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 605 San Bruno Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/22/2010 12:00:00 AM | 4 | 3x3 | Permit Number 53586 | 6010991.81939 | 2105452.40233 | 37.7617907981332 | -122.405100915002 | (37.7617907981332, -122.405100915002) | 10 | 3 | 8 | 28856 | 29 | |
68716 | 50730 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 725 Carolina St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/02/2004 12:00:00 AM | 4 | Permit Number 47280 | 6012445.19576 | 2104545.72863 | 37.7593824136929 | -122.400010559737 | (37.7593824136929, -122.400010559737) | 10 | 3 | 8 | 28856 | 29 | ||
71137 | 37945 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 829 Carolina St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/08/1998 12:00:00 AM | 8 | Permit Number 40186 | 6012472.75193 | 2104081.82753 | 37.7581101796629 | -122.399882680666 | (37.7581101796629, -122.399882680666) | 10 | 3 | 8 | 28856 | 29 | |
73465 | 101797 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 600X Carolina St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | 6x6 | 6012355.97365 | 2105123.66121 | 37.7609643139807 | -122.400359728744 | (37.7609643139807, -122.400359728744) | 10 | 3 | 8 | 28856 | 29 | |||
74250 | 190718 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 446 Missouri St | 1 | : | Tree | Private 2 | 6 | Width 3ft | 6013483.0407 | 2105010.44498 | 37.7607162323997 | -122.396453732953 | (37.7607162323997, -122.396453732953) | 10 | 3 | 8 | 28856 | 29 | |||
74946 | 35366 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 1034 Rhode Island St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/23/1998 12:00:00 AM | 10 | Permit Number 38826 | 6011879.44293 | 2103561.14467 | 37.756647404478 | -122.40189800919 | (37.756647404478, -122.40189800919) | 10 | 3 | 8 | 28856 | 29 | |
76015 | 190723 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 2277 Alameda St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 4ft | 6010387.48096 | 2107844.66484 | 37.7683256039748 | -122.407359744866 | (37.7683256039748, -122.407359744866) | 8 | 4 | 8 | 28853 | 19 | |||
77220 | 121726 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 1301 Vermont St | 1 | Front Yard : Yard | Tree | DPW 1 | 3x3 | 6011430 | 2102074 | 37.7525389392772 | -122.403347738299 | (37.7525389392772, -122.403347738299) | 10 | 4 | 8 | 28859 | 19 | ||||
80112 | 47677 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 442 Pennsylvania Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/21/2002 12:00:00 AM | 7 | 6x7 | Permit Number 45461 | 6014320.24712 | 2105057.70594 | 37.7608925552604 | -122.393561497073 | (37.7608925552604, -122.393561497073) | 10 | 3 | 8 | 28856 | 29 |
80273 | 190705 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 2207 25th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6012167.67259 | 2101868.22715 | 37.7520151045386 | -122.400782269783 | (37.7520151045386, -122.400782269783) | 10 | 3 | 8 | 28856 | 29 | |||
80801 | 190684 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 801 Mariposa St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6014721.7183 | 2106200.75287 | 37.7640534132442 | -122.392252919633 | (37.7640534132442, -122.392252919633) | 14 | 3 | 8 | 28856 | 29 | |||
84685 | 32944 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 225 Arkansas St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/01/1996 12:00:00 AM | Permit Number 37262 | 6012923.17595221 | 2106002.78448692 | 37.7634098055879 | -122.398459699211 | (37.7634098055879, -122.398459699211) | 14 | 3 | 8 | 28856 | 29 | |||
85032 | 30882 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 601 Mississippi St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/20/2005 12:00:00 AM | 6 | Permit Number 48128 | 6014140.03931 | 2104332.5507 | 37.7588914216105 | -122.394133992886 | (37.7588914216105, -122.394133992886) | 10 | 3 | 8 | 28856 | 29 | ||
85653 | 34305 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 1254 Utah St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/14/1997 12:00:00 AM | Permit Number 38093 | 6010822.82923264 | 2102485.1673324 | 37.7536339837486 | -122.405476404222 | (37.7536339837486, -122.405476404222) | 10 | 4 | 8 | 28859 | 19 | ||
89588 | 190720 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 315 Mississippi St | 1 | : | Tree | Private 2 | 8 | Width 3ft | 6014070.97859 | 2105596.22306 | 37.7623573521408 | -122.394461321843 | (37.7623573521408, -122.394461321843) | 10 | 3 | 8 | 28856 | 29 | |||
89871 | 12227 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 1551 La Salle Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/11/2000 12:00:00 AM | 6 | 3X3 | 6015788.0003 | 2095930.721 | 37.7359132010346 | -122.387848277235 | (37.7359132010346, -122.387848277235) | 10 | 3 | 8 | 58 | 1 | ||
91033 | 108713 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 1101 Kansas St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/02/2015 12:00:00 AM | 3 | 3x3 | Permit Number 773108 | 6011675.24376 | 2103231.93963 | 37.7557320816825 | -122.402581058681 | (37.7557320816825, -122.402581058681) | 10 | 3 | 8 | 28856 | 29 |
93499 | 106047 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 618- 622 Carolina St | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | 15 | 6x7 | 6012364.1992 | 2105044.14437 | 37.7607464370199 | -122.400325694786 | (37.7607464370199, -122.400325694786) | 10 | 3 | 8 | 28856 | 29 | |||
93777 | 32977 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 448 Pennsylvania Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/25/2003 12:00:00 AM | 4 | Permit Number 46744 | 6014321.91414 | 2105021.23892 | 37.7607925173727 | -122.393553179256 | (37.7607925173727, -122.393553179256) | 10 | 3 | 8 | 28856 | 29 | |
97978 | 68129 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 635 Texas St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/20/1993 12:00:00 AM | 9 | Permit Number 31880 | 6013874.62108 | 2104078.7495 | 37.7581797826985 | -122.39503416301 | (37.7581797826985, -122.39503416301) | 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 | |
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 | |||
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 | |
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 | |||
103487 | 80120 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 1368 Utah St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/22/2010 12:00:00 AM | 3x3 | Permit Number 53583 | 6010852.51966051 | 2101957.65368141 | 37.7521872076664 | -122.405336581456 | (37.7521872076664, -122.405336581456) | 10 | 4 | 8 | 28859 | 19 | ||
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 |
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) );