trees
82 rows where Fire Prevention Districts = 10, qCareAssistant = "FUF" and qSpecies_id = 50
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | |||
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 | |
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 | |||
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 | |
9700 | 261108 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 1324 Fitzgerald Ave | 2 | 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 | |
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 | |||
10911 | 78495 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 1300 Rhode Island St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 7 | 6011953.72275 | 2102256.16538 | 37.7530683626141 | -122.401549406774 | (37.7530683626141, -122.401549406774) | 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 | |
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 | |
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 | |
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 | ||
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 | |||
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 | |
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 | |
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 | |
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 | |
53978 | 34556 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 2 Nebraska St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/25/1997 12:00:00 AM | Permit Number 38265 | 6009291.02762051 | 2098031.45158376 | 37.7413192965243 | -122.410459272722 | (37.7413192965243, -122.410459272722) | 10 | 7 | 7 | 28859 | 2 | ||
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 |
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 | |
59136 | 43189 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 175 Sweeny St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/11/2000 12:00:00 AM | 2 | Permit Number 42991 | 6009687.65103 | 2094852.37094 | 37.7326124525905 | -122.408863642464 | (37.7326124525905, -122.408863642464) | 10 | 3 | 7 | 309 | 28 | |
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 | |
70598 | 40721 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 58 Bronte St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/12/1999 12:00:00 AM | Permit Number 41700 | 6009320.76573459 | 2097115.38530681 | 37.7388056449049 | -122.410291784296 | (37.7388056449049, -122.410291784296) | 10 | 7 | 7 | 28859 | 2 | ||
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 | |
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 | |
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 |
85089 | 37988 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 613 Texas St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/08/1998 12:00:00 AM | 9 | Permit Number 40209 | 6013865.90817 | 2104201.25783 | 37.7585156794839 | -122.395072877032 | (37.7585156794839, -122.395072877032) | 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 | ||
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 |
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 | |
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 | |
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 | |
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 |
111132 | 37445 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 428 Franconia St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/19/1998 12:00:00 AM | Permit Number 39919 | 6009952.87320759 | 2098588.12487014 | 37.7428848816788 | -122.408210085028 | (37.7428848816788, -122.408210085028) | 10 | 7 | 7 | 28859 | 2 | ||
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 | |
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 | |
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 | |
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 | |
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 | |
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 | |
120105 | 37443 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 423 Franconia St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/19/1998 12:00:00 AM | Permit Number 39917 | 6010005.91327801 | 2098599.86014619 | 37.742920074008 | -122.408027513819 | (37.742920074008, -122.408027513819) | 10 | 7 | 7 | 28859 | 2 | ||
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 | |
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 | |
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 | |
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 | |
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 | |
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 | ||
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 | ||
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 |
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 | |
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 | ||
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 | |
161348 | 44333 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 2516 25th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/05/2001 12:00:00 AM | Permit Number 43718 | 6011390.61929335 | 2101865.00809081 | 37.7519628937204 | -122.403469222223 | (37.7519628937204, -122.403469222223) | 10 | 4 | 8 | 28859 | 19 | ||
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 | |
168394 | 34557 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 2 Nebraska St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/25/1997 12:00:00 AM | Permit Number 38265 | 6009291.02762051 | 2098031.45158376 | 37.7413192965243 | -122.410459272722 | (37.7413192965243, -122.410459272722) | 10 | 7 | 7 | 28859 | 2 | ||
172836 | 37451 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 444 Franconia St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/19/1998 12:00:00 AM | Permit Number 39924 | 6009949.70212209 | 2098546.33795552 | 37.7427699663381 | -122.408218103257 | (37.7427699663381, -122.408218103257) | 10 | 7 | 7 | 28859 | 2 | ||
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 | ||
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 | |
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 |
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 | |
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 | |
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 | |
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 | |
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 | |
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 | |
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 |
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) );