trees
1,194 rows where qSpecies_id = 50 sorted by XCoord 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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | |||
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 | ||
26709 | 201517 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 911 Innes Ave | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 2 | Width 5ft | 6019123.25931 | 2094488.31096 | 37.7321368236424 | -122.376216835747 | (37.7321368236424, -122.376216835747) | 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 | |
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 | |
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 | ||
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 | ||
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 | |
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 | ||||
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 | ||||
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 | ||
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 | |
9391 | 149875 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 1388 Tennessee St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 5ft | 6015583.80084 | 2102690.13073 | 37.7544618261772 | -122.38902607571 | (37.7544618261772, -122.38902607571) | 10 | 3 | 8 | 28856 | 29 | |||
18269 | 149874 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 1388 Tennessee St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 5x5 | 6015582.50669 | 2102715.11316 | 37.7545303509079 | -122.389032295422 | (37.7545303509079, -122.389032295422) | 10 | 3 | 8 | 28856 | 29 | |||
15985 | 149873 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 1388 Tennessee St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 5x5 | 6015582.31236 | 2102734.10944 | 37.7545824999013 | -122.389034293714 | (37.7545824999013, -122.389034293714) | 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 | |||
67227 | 47749 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 993 Tennessee St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/31/2002 12:00:00 AM | Permit Number 45529 | 6015544.08915786 | 2104434.58222781 | 37.7592495174377 | -122.389285216664 | (37.7592495174377, -122.389285216664) | 10 | 3 | 8 | 28856 | 29 | |||
88732 | 47750 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 993 Tennessee St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/31/2002 12:00:00 AM | Permit Number 45529 | 6015544.08915786 | 2104434.58222781 | 37.7592495174377 | -122.389285216664 | (37.7592495174377, -122.389285216664) | 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 | |
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 | ||||
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 | |
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 | |
98943 | 38605 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 1556 Revere Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/02/2008 12:00:00 AM | 3 | 3x3 | Permit Number 50557 | 6015347.9546 | 2094242.9168 | 37.7312544446328 | -122.389251883535 | (37.7312544446328, -122.389251883535) | 10 | 3 | 8 | 58 | 1 | |
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 | |||
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 | |||
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 | |||
72353 | 190688 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 1001 Minnesota St | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 4 | Width 4ft | 6015295.35609 | 2103854.98706 | 37.7576442804869 | -122.390104972579 | (37.7576442804869, -122.390104972579) | 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 | |||
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 | |
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 |
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 | |||
73796 | 115552 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 925x Minnesota St | 4 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 6 | 15x7 | 6015276.56251 | 2104229.20593 | 37.7586707630633 | -122.390196112573 | (37.7586707630633, -122.390196112573) | 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 | ||||
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 |
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 |
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 | |||
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 | |||
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 | |||
852 | 108444 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 1 Sycamore St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/22/2014 12:00:00 AM | 2 | 3x2.5 | 6014877 | 2117007 | 37.7937335561349 | -122.392471758503 | (37.7937335561349, -122.392471758503) | 12 | 2 | 9 | 28855 | 6 | |
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
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 |
16102 | 261110 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 20 Latona St | 2 | 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 | ||
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 | ||
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 | |
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 |
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 | |
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 | ||
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 | |||
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 | ||
65837 | 190717 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 1150 19th St | 4 | Sidewalk: Curb side : Yard | Tree | Private 2 | 7 | Width 4ft | 6014133.64605 | 2105280.55607 | 37.7614940829991 | -122.394222475384 | (37.7614940829991, -122.394222475384) | 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 | |
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 | |
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 | |||
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 | |||
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 | ||
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 | |
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 |
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 | |||
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 | |||||
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 | |
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 | |
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 | ||
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 | ||
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 | ||
21056 | 38279 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 651 Texas St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/03/2017 12:00:00 AM | 3 | Permit Number 40367 | 6013875.32423 | 2104028.43016 | 37.7580416558018 | -122.395028206788 | (37.7580416558018, -122.395028206788) | 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 | |
27293 | 105894 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 635 Texas St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | 3x3 | 6013871.77748 | 2104094.24154 | 37.7582221623537 | -122.395045082568 | (37.7582221623537, -122.395045082568) | 10 | 3 | 8 | 28856 | 29 | |||
51950 | 105895 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 635 Texas St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | 3x3 | 6013871.69882 | 2104104.53276 | 37.7582504154377 | -122.395046075423 | (37.7582504154377, -122.395046075423) | 10 | 3 | 8 | 28856 | 29 | |||
96881 | 105896 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 635 Texas St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | 3x3 | 6013869.96834 | 2104118.28699 | 37.7582880853408 | -122.395053023593 | (37.7582880853408, -122.395053023593) | 10 | 3 | 8 | 28856 | 29 | |||
78479 | 105897 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 635 Texas St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | 3x3 | 6013869.92675 | 2104144.58378 | 37.7583602883087 | -122.395055009307 | (37.7583602883087, -122.395055009307) | 10 | 3 | 8 | 28856 | 29 | |||
24333 | 105898 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 635 Texas St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | 3x3 | 6013868.87409 | 2104163.4691 | 37.758412084763 | -122.395059972665 | (37.758412084763, -122.395059972665) | 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 | |
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 | |
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 | |
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 | |
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 | |
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 | |||
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 | |||
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 | |
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 | ||
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 | |||
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 | |||
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 | |||
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 | |||
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 | ||
2360 | 190701 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 199 Texas St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6013753.34046 | 2106269.97699 | 37.7641896695377 | -122.395607129171 | (37.7641896695377, -122.395607129171) | 14 | 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 | |||
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 | |||
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 | |||
64645 | 190712 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 204 Texas St | 2 | Sidewalk: Curb side : Pot | Tree | Private 2 | 14 | Width 3ft | 6013703.78505 | 2106091.36578 | 37.7636964858312 | -122.395766012395 | (37.7636964858312, -122.395766012395) | 14 | 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 | |
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 | |
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 | |
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 | |||
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 |
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) );