trees
3,267 rows where qSpecies_id = 67 sorted by Longitude
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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 58331 | 199920 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1270 Shafter Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 0ft | 6016691.2738 | 2092889.8739 | 37.7276136359457 | -122.384513533626 | (37.7276136359457, -122.384513533626) | 10 | 3 | 8 | 58 | 1 | |||
| 34065 | 199954 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1269 Shafter Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 0ft | 6016683.5619 | 2092823.2211 | 37.7274301939891 | -122.384535553346 | (37.7274301939891, -122.384535553346) | 10 | 3 | 8 | 58 | 1 | |||
| 113288 | 199915 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1278 Shafter Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 0ft | 6016654.3669 | 2092917.9672 | 37.7276887336226 | -122.384643078505 | (37.7276887336226, -122.384643078505) | 10 | 3 | 8 | 58 | 1 | |||
| 190655 | 199913 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1282 Shafter Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 0ft | 6016634.5363 | 2092932.8401 | 37.7277284749637 | -122.384712669452 | (37.7277284749637, -122.384712669452) | 10 | 3 | 8 | 58 | 1 | |||
| 68352 | 199948 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1310 Shafter Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 0ft | 6016458.2646 | 2093067.2473 | 37.7280877803005 | -122.385331411366 | (37.7280877803005, -122.385331411366) | 10 | 3 | 8 | 58 | 1 | |||
| 125321 | 199917 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1301 Shafter Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 0ft | 6016454.9595 | 2092989.0267 | 37.7278728191084 | -122.385337388901 | (37.7278728191084, -122.385337388901) | 10 | 3 | 8 | 58 | 1 | |||
| 14798 | 199912 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1319 Shafter Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 0ft | 6016381.1458 | 2093047.4167 | 37.728029062608 | -122.385596634641 | (37.728029062608, -122.385596634641) | 10 | 3 | 8 | 58 | 1 | |||
| 33322 | 99543 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1326 Shafter Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | 3x3 | 6016380.5949 | 2093124.5356 | 37.7282407853998 | -122.385603911567 | (37.7282407853998, -122.385603911567) | 10 | 3 | 8 | 58 | 1 | |||
| 149708 | 99544 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1327 Shafter Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | 3x3 | 6016344.2389 | 2093074.9592 | 37.7281026467009 | -122.385726142965 | (37.7281026467009, -122.385726142965) | 10 | 3 | 8 | 58 | 1 | |||
| 138175 | 56385 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1300 Thomas Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/17/1973 12:00:00 AM | 8 | Permit Number 12536 | 6016338.1795 | 2092806.6957 | 37.7273657127679 | -122.385728401086 | (37.7273657127679, -122.385728401086) | 10 | 3 | 8 | 58 | 1 | ||
| 15573 | 10975 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1468X Hudson Ave | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6016410.2814628 | 2096936.3836856 | 37.7387090009717 | -122.385766856192 | (37.7387090009717, -122.385766856192) | 10 | 3 | 8 | 58 | 1 | |||
| 60964 | 10978 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1468X Hudson Ave | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6016410.2814628 | 2096936.3836856 | 37.7387090009717 | -122.385766856192 | (37.7387090009717, -122.385766856192) | 10 | 3 | 8 | 58 | 1 | |||
| 113371 | 53509 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1306 Thomas Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/17/1973 12:00:00 AM | 4 | Permit Number 12537 | 6016318.8998 | 2092822.1194 | 37.7274069963434 | -122.385796126204 | (37.7274069963434, -122.385796126204) | 10 | 3 | 8 | 58 | 1 | ||
| 18815 | 199909 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1335 Shafter Ave | 1 | Sidewalk: Curb side : Pot | Tree | Private 2 | 11 | Width 0ft | 6016305.1286 | 2093102.5016 | 37.7281761084423 | -122.385863268846 | (37.7281761084423, -122.385863268846) | 10 | 3 | 8 | 58 | 1 | |||
| 100096 | 56386 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1310 Thomas Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/17/1973 12:00:00 AM | 13 | Permit Number 12538 | 6016291.3574 | 2092843.6025 | 37.727464460543 | -122.385892838032 | (37.727464460543, -122.385892838032) | 10 | 3 | 8 | 58 | 1 | ||
| 174469 | 199925 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1314 Thomas Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 17 | Width 0ft | 6016264.3657 | 2092862.8823 | 37.727515905313 | -122.385987492696 | (37.727515905313, -122.385987492696) | 10 | 3 | 8 | 58 | 1 | |||
| 115506 | 99545 | Undocumented 4 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1345 Shafter Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6016251.7 | 2093118.1 | 37.7282159817318 | -122.386049062135 | (37.7282159817318, -122.386049062135) | 10 | 3 | 8 | 58 | 1 | ||||
| 180551 | 56388 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1322 Thomas Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/17/1973 12:00:00 AM | 12 | Permit Number 12540 | 6016246.7386 | 2092876.1026 | 37.7275512300997 | -122.386049351457 | (37.7275512300997, -122.386049351457) | 10 | 3 | 8 | 58 | 1 | ||
| 105655 | 199921 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1322 Thomas Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 0ft | 6016230.764 | 2092890.4247 | 37.7275896716386 | -122.386105574291 | (37.7275896716386, -122.386105574291) | 10 | 3 | 8 | 58 | 1 | |||
| 71105 | 38624 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1351 Shafter Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/17/1998 12:00:00 AM | 8 | Permit Number 40562 | 6016224.1538 | 2093165.8493 | 37.7283455672948 | -122.386147618696 | (37.7283455672948, -122.386147618696) | 10 | 3 | 8 | 58 | 1 | |
| 179657 | 188267 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1348 Palou Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6016242.16008 | 2094272.29436 | 37.7313846423665 | -122.386162472416 | (37.7313846423665, -122.386162472416) | 10 | 3 | 8 | 58 | 1 | |||
| 144127 | 53510 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1326 Thomas Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/17/1973 12:00:00 AM | 11 | Permit Number 12541 | 6016208.73 | 2092903.6451 | 37.7276247527235 | -122.386182668022 | (37.7276247527235, -122.386182668022) | 10 | 3 | 8 | 58 | 1 | ||
| 115339 | 199880 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1387 Revere Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 0ft | 6016216.5667 | 2093521.9579 | 37.7293229510399 | -122.386198663854 | (37.7293229510399, -122.386198663854) | 10 | 3 | 8 | 58 | 1 | |||
| 7645 | 56389 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1338 Thomas Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/17/1973 12:00:00 AM | 14 | Permit Number 12542 | 6016160.8061 | 2092941.1028 | 37.7277249515347 | -122.386350953513 | (37.7277249515347, -122.386350953513) | 10 | 3 | 8 | 58 | 1 | ||
| 108502 | 56391 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1344 Thomas Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/17/1973 12:00:00 AM | 10 | Permit Number 12544 | 6016127.2043 | 2092964.2385 | 37.7277866175614 | -122.386468729017 | (37.7277866175614, -122.386468729017) | 10 | 3 | 8 | 58 | 1 | ||
| 65903 | 5810 | Permitted Site 7 | Callistemon citrinus :: Lemon Bottlebrush 67 | 38 Dukes Ct | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | 3X3 | 6016194.1627128 | 2096297.6107937 | 37.7369430983129 | -122.386469573077 | (37.7369430983129, -122.386469573077) | 10 | 3 | 8 | 58 | 1 | |||
| 43028 | 3788 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 2 Dukes Ct | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X4 | 6016188.5849089 | 2096210.9026271 | 37.7367047064211 | -122.386482814206 | (37.7367047064211, -122.386482814206) | 10 | 3 | 8 | 58 | 1 | |||
| 95824 | 188257 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 2 Dukes Ct | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6016188.2742 | 2096253.73483 | 37.7368222978047 | -122.38648687409 | (37.7368222978047, -122.38648687409) | 10 | 3 | 8 | 58 | 1 | |||
| 69658 | 5800 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 2 Dukes Ct | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | 3X4 | 6016181.28411 | 2096289.16741 | 37.7369192015603 | -122.386513511992 | (37.7369192015603, -122.386513511992) | 10 | 3 | 8 | 58 | 1 | |||
| 152199 | 5813 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 73 Dukes Ct | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 7 | 3X4 | 6016158.83077 | 2096436.54005 | 37.7373226140504 | -122.386601417133 | (37.7373226140504, -122.386601417133) | 10 | 3 | 8 | 58 | 1 | |||
| 105229 | 200080 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1352 Thomas Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 0ft | 6016078.1788 | 2093000.5945 | 37.7278837299247 | -122.386640746762 | (37.7278837299247, -122.386640746762) | 10 | 3 | 8 | 58 | 1 | |||
| 86223 | 5805 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 5 Dukes Ct | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X4 | 6016140.1129448 | 2096198.2445968 | 37.7366672666368 | -122.386649521955 | (37.7366672666368, -122.386649521955) | 10 | 3 | 8 | 58 | 1 | |||
| 101808 | 5804 | Permitted Site 7 | Callistemon citrinus :: Lemon Bottlebrush 67 | 5 Dukes Ct | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3X4 | 6016140.1129448 | 2096198.2445968 | 37.7366672666368 | -122.386649521955 | (37.7366672666368, -122.386649521955) | 10 | 3 | 8 | 58 | 1 | |||
| 75966 | 5802 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 218X Cashmere St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3X4 | 6016122.2563 | 2096227.44621 | 37.7367464597726 | -122.386713296401 | (37.7367464597726, -122.386713296401) | 10 | 3 | 8 | 58 | 1 | |||
| 97768 | 5801 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 218X Cashmere St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3X4 | 6016115.70396 | 2096246.37508 | 37.7367980718607 | -122.386737270517 | (37.7367980718607, -122.386737270517) | 10 | 3 | 8 | 58 | 1 | |||
| 172692 | 50945 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1356 Thomas Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/28/2004 12:00:00 AM | 11 | Permit Number 47441 | 6016050.0855 | 2093024.8319 | 37.7279487256885 | -122.386739556348 | (37.7279487256885, -122.386739556348) | 10 | 3 | 8 | 58 | 1 | ||
| 177591 | 199901 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1391 Shafter Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 0ft | 6016046.7804 | 2093296.4005 | 37.7286942162527 | -122.38676991257 | (37.7286942162527, -122.38676991257) | 10 | 3 | 8 | 58 | 1 | |||
| 183381 | 199685 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1363 Thomas Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 0ft | 6016033.0091 | 2092958.73 | 37.7277662775145 | -122.386793982618 | (37.7277662775145, -122.386793982618) | 10 | 3 | 8 | 58 | 1 | |||
| 49667 | 53512 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1362 Thomas Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/17/1973 12:00:00 AM | 11 | Permit Number 12547 | 6016030.8057 | 2093035.8489 | 37.727977908748 | -122.38680697572 | (37.727977908748, -122.38680697572) | 10 | 3 | 8 | 58 | 1 | ||
| 79896 | 56392 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1363 Thomas Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/17/1973 12:00:00 AM | 9 | Permit Number 12548 | 6016014.8311 | 2092970.2978 | 37.7277970339363 | -122.386857631263 | (37.7277970339363, -122.386857631263) | 10 | 3 | 8 | 58 | 1 | ||
| 169896 | 199679 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1367 Thomas Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 0ft | 6016002.7124 | 2092981.3148 | 37.7278266134379 | -122.386900294245 | (37.7278266134379, -122.386900294245) | 10 | 3 | 8 | 58 | 1 | |||
| 103528 | 199897 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1395 Shafter Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 0ft | 6016007.6701 | 2093322.8413 | 37.7287646519973 | -122.386906963777 | (37.7287646519973, -122.386906963777) | 10 | 3 | 8 | 58 | 1 | |||
| 19634 | 53513 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1370 Thomas Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/17/1973 12:00:00 AM | 11 | Permit Number 12550 | 6015991.6954 | 2093066.1456 | 37.7280589319949 | -122.386944294451 | (37.7280589319949, -122.386944294451) | 10 | 3 | 8 | 58 | 1 | ||
| 178893 | 56393 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1367 Thomas Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/17/1973 12:00:00 AM | 10 | Permit Number 12549 | 6015984.5344 | 2092993.9843 | 37.7278603948519 | -122.386964019791 | (37.7278603948519, -122.386964019791) | 10 | 3 | 8 | 58 | 1 | ||
| 10062 | 199899 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1829 Jennings St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 0ft | 6015967.4581 | 2093314.0277 | 37.7287382249947 | -122.387045366056 | (37.7287382249947, -122.387045366056) | 10 | 3 | 8 | 58 | 1 | |||
| 78667 | 199898 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1829 Jennings St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 0ft | 6015950.3818 | 2093292.5446 | 37.728678291075 | -122.387102902636 | (37.728678291075, -122.387102902636) | 10 | 3 | 8 | 58 | 1 | |||
| 119960 | 27529 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1430 Oakdale Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6015974.48783 | 2094842.30112 | 37.7329349481517 | -122.387127616668 | (37.7329349481517, -122.387127616668) | 10 | 3 | 8 | 58 | 1 | |||
| 146423 | 53514 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1382 Thomas Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/25/1969 12:00:00 AM | 3 | Permit Number 6426 | 6015935.5088 | 2093105.8067 | 37.7281647222543 | -122.38714130029 | (37.7281647222543, -122.38714130029) | 10 | 3 | 8 | 58 | 1 | ||
| 172398 | 200734 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1434 Oakdale Ave | 1 | unknown : Yard | Tree | Private 2 | 7 | Width 0ft | 6015941.8417 | 2094834.993 | 37.7329130736504 | -122.387239974213 | (37.7329130736504, -122.387239974213) | 10 | 3 | 8 | 58 | 1 | |||
| 24664 | 200704 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1466 Newcomb Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 0ft | 6015947.4931 | 2095190.3982 | 37.7338892579459 | -122.387245217903 | (37.7338892579459, -122.387245217903) | 10 | 3 | 8 | 58 | 1 | |||
| 7081 | 199881 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1411 Shafter Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 0ft | 6015892.5426 | 2093410.4263 | 37.7289987677543 | -122.387311077708 | (37.7289987677543, -122.387311077708) | 10 | 3 | 8 | 58 | 1 | |||
| 15816 | 26895 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1245X Lane St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 4 | 6015870.9547371 | 2095407.1210845 | 37.7344800964063 | -122.387524951 | (37.7344800964063, -122.387524951) | 10 | 3 | 8 | 58 | 1 | |||
| 52129 | 200713 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1299 Lane St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 0ft | 6015819.5219 | 2095338.0192 | 37.7342875076715 | -122.387697953212 | (37.7342875076715, -122.387697953212) | 10 | 3 | 8 | 58 | 1 | |||
| 154820 | 188284 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1535 Innes Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6015844.31945 | 2096941.47577 | 37.7386916484079 | -122.387724057934 | (37.7386916484079, -122.387724057934) | 10 | 3 | 8 | 58 | 1 | |||
| 8896 | 56726 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1523 McKinnon Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Permit Number 769408 | 6015773.2097 | 2095596.9346 | 37.7349958716637 | -122.387876131204 | (37.7349958716637, -122.387876131204) | 10 | 3 | 8 | 58 | 1 | |||
| 114884 | 199872 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1452 Shafter Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 0ft | 6015728.3896 | 2093608.7319 | 37.7295341830028 | -122.387892403836 | (37.7295341830028, -122.387892403836) | 10 | 3 | 8 | 58 | 1 | |||
| 122515 | 188283 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1550 Innes Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 6015797.00991 | 2097048.5879 | 37.7389831357492 | -122.387895105398 | (37.7389831357492, -122.387895105398) | 10 | 3 | 8 | 58 | 1 | |||
| 118290 | 60062 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1554 Innes Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/15/1982 12:00:00 AM | 8 | Permit Number 19561 | 6015777.30989 | 2097062.16866 | 37.7390193343766 | -122.387964167027 | (37.7390193343766, -122.387964167027) | 10 | 3 | 8 | 58 | 1 | ||
| 172467 | 38559 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1538 McKinnon Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/17/1998 12:00:00 AM | 9 | Permit Number 40524 | 6015720.042 | 2095709.5571 | 37.7353021647635 | -122.388067809168 | (37.7353021647635, -122.388067809168) | 10 | 3 | 8 | 58 | 1 | |
| 154087 | 38560 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1539 McKinnon Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/17/1998 12:00:00 AM | 7 | Permit Number 40525 | 6015686.9214 | 2095659.8019 | 37.7351637119843 | -122.388178849076 | (37.7351637119843, -122.388178849076) | 10 | 3 | 8 | 58 | 1 | |
| 114343 | 199875 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1467 Shafter Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 0ft | 6015608.3045 | 2093619.7489 | 37.7295577802107 | -122.388308322353 | (37.7295577802107, -122.388308322353) | 10 | 3 | 8 | 58 | 1 | |||
| 158120 | 199874 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1471 Shafter Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 0ft | 6015597.8383 | 2093627.4608 | 37.7295783756022 | -122.388345043424 | (37.7295783756022, -122.388345043424) | 10 | 3 | 8 | 58 | 1 | |||
| 38175 | 56730 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1551 McKinnon Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | 6015631.7584 | 2095701.097 | 37.7352740434099 | -122.388372450522 | (37.7352740434099, -122.388372450522) | 10 | 3 | 8 | 58 | 1 | ||||
| 19837 | 200793 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1574 McKinnon Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 0ft | 6015536.4716 | 2095847.5097 | 37.7356707824742 | -122.388712112413 | (37.7356707824742, -122.388712112413) | 10 | 3 | 8 | 58 | 1 | |||
| 76901 | 56724 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1582 McKinnon Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | 6015504.0444 | 2095869.4942 | 37.7357293502019 | -122.388825761039 | (37.7357293502019, -122.388825761039) | 10 | 3 | 8 | 58 | 1 | ||||
| 20025 | 200070 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1531 Shafter Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 0ft | 6015257.2685 | 2093882.9208 | 37.7302609400431 | -122.389540272139 | (37.7302609400431, -122.389540272139) | 10 | 3 | 8 | 58 | 1 | |||
| 108410 | 200069 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1543 Shafter Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 0ft | 6015198.46 | 2093925.2409 | 37.7303738816119 | -122.38974653751 | (37.7303738816119, -122.38974653751) | 10 | 3 | 8 | 58 | 1 | |||
| 182606 | 53718 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 698 Tennessee St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/28/1984 12:00:00 AM | 10 | Permit Number 21257 | 6015408.67054 | 2105841.27039 | 37.7631044720269 | -122.389851821512 | (37.7631044720269, -122.389851821512) | 14 | 3 | 8 | 28856 | 29 | ||
| 157206 | 188944 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 398 Quint St | 1 | Front Yard : Yard | Tree | Private 2 | 5 | 6015253.92457 | 2099115.96743 | 37.7446296326645 | -122.389917233688 | (37.7446296326645, -122.389917233688) | 10 | 3 | 8 | 58 | 1 | ||||
| 170129 | 188945 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 398 Quint St | 2 | Front Yard : Yard | Tree | Private 2 | 10 | 6015211.76442 | 2099058.69599 | 37.744470038975 | -122.390059016307 | (37.744470038975, -122.390059016307) | 10 | 3 | 8 | 58 | 1 | ||||
| 50381 | 188946 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 398 Quint St | 3 | Front Yard : Yard | Tree | Private 2 | 9 | 6015180.72711 | 2099016.74699 | 37.7443531342865 | -122.390163407814 | (37.7443531342865, -122.390163407814) | 10 | 3 | 8 | 58 | 1 | ||||
| 46297 | 200048 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1590 Shafter Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 0ft | 6015017.088 | 2094135.7424 | 37.7309418170544 | -122.390388273154 | (37.7309418170544, -122.390388273154) | 10 | 3 | 8 | 58 | 1 | |||
| 184893 | 200049 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1590 Shafter Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 0ft | 6015007.7446 | 2094143.437 | 37.7309624265756 | -122.390421112537 | (37.7309624265756, -122.390421112537) | 10 | 3 | 8 | 58 | 1 | |||
| 57231 | 200050 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1590 Shafter Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 0ft | 6014991.2562 | 2094154.9788 | 37.730993203361 | -122.390478922324 | (37.730993203361, -122.390478922324) | 10 | 3 | 8 | 58 | 1 | |||
| 43867 | 200052 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1447 Lane St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 0ft | 6014964.1322 | 2094199.4429 | 37.7311137880856 | -122.390575801186 | (37.7311137880856, -122.390575801186) | 10 | 3 | 8 | 58 | 1 | |||
| 181104 | 189019 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1706 La Salle Ave | 1 | : | Tree | Private 2 | 10 | Width 3ft | 6014964.37337 | 2096622.15224 | 37.7377660688555 | -122.390744210693 | (37.7377660688555, -122.390744210693) | 10 | 3 | 8 | 58 | 1 | |||
| 14853 | 188956 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1706 La Salle Ave | 1 | : | Tree | Private 2 | 13 | Width 3ft | 6014961.30392 | 2096622.74747 | 37.7377675329349 | -122.390754864938 | (37.7377675329349, -122.390754864938) | 10 | 3 | 8 | 58 | 1 | |||
| 108217 | 87177 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1572 Thomas Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/22/2008 12:00:00 AM | 3 | 3x3 | Permit Number 50147 | 6014901.6694 | 2093877.1498 | 37.7302253707536 | -122.390769233 | (37.7302253707536, -122.390769233) | 10 | 3 | 8 | 58 | 1 | |
| 23517 | 189018 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1711 La Salle Ave | 1 | : | Tree | Private 2 | 7 | Width 3ft | 6014940.20739 | 2096568.46333 | 37.7376173092958 | -122.390824013816 | (37.7376173092958, -122.390824013816) | 10 | 3 | 8 | 58 | 1 | |||
| 35388 | 188957 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1708 La Salle Ave | 1 | : | Tree | Private 2 | 10 | Width 3ft | 6014940.68574 | 2096639.31184 | 37.7378118713318 | -122.390827309835 | (37.7378118713318, -122.390827309835) | 10 | 3 | 8 | 58 | 1 | |||
| 175046 | 189016 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1708 La Salle Ave | 1 | : | Tree | Private 2 | 8 | Width 3ft | 6014940.47928 | 2096636.31619 | 37.7378036344353 | -122.390827814378 | (37.7378036344353, -122.390827814378) | 10 | 3 | 8 | 58 | 1 | |||
| 79893 | 188955 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1711 La Salle Ave | 1 | : | Tree | Private 2 | 8 | Width 1ft | 6014937.85326 | 2096568.85447 | 37.737618252668 | -122.390832180559 | (37.737618252668, -122.390832180559) | 10 | 3 | 8 | 58 | 1 | |||
| 93070 | 189015 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1710 La Salle Ave | 1 | : | Tree | Private 2 | 9 | Width 3ft | 6014923.18832 | 2096650.89402 | 37.7378427027714 | -122.390888616642 | (37.7378427027714, -122.390888616642) | 10 | 3 | 8 | 58 | 1 | |||
| 74252 | 188958 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1710 La Salle Ave | 1 | : | Tree | Private 2 | 11 | Width 3ft | 6014921.65166 | 2096653.12278 | 37.7378487372257 | -122.390894085388 | (37.7378487372257, -122.390894085388) | 10 | 3 | 8 | 58 | 1 | |||
| 6333 | 189017 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1715 La Salle Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | 3x3 | 6014919.07097 | 2096583.11887 | 37.7376563776397 | -122.390898117058 | (37.7376563776397, -122.390898117058) | 10 | 3 | 8 | 58 | 1 | |||
| 137319 | 188954 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1715 La Salle Ave | 1 | : | Tree | Private 2 | 11 | Width 3ft | 6014917.05879 | 2096584.25216 | 37.7376593777724 | -122.390905153366 | (37.7376593777724, -122.390905153366) | 10 | 3 | 8 | 58 | 1 | |||
| 130397 | 189014 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1712 La Salle Ave | 1 | : | Tree | Private 2 | 5 | Width 3ft | 6014907.9841 | 2096659.95705 | 37.7378667443547 | -122.390941818707 | (37.7378667443547, -122.390941818707) | 10 | 3 | 8 | 58 | 1 | |||
| 128843 | 188959 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1712 La Salle Ave | 1 | : | Tree | Private 2 | 8 | Width 1ft | 6014904.41664 | 2096665.80836 | 37.7378826129007 | -122.390954562096 | (37.7378826129007, -122.390954562096) | 10 | 3 | 8 | 58 | 1 | |||
| 100256 | 189013 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1728 La Salle Ave | 1 | : | Tree | Private 2 | 6 | Width 3ft | 6014896.64739 | 2096670.03652 | 37.7378937914553 | -122.390981719843 | (37.7378937914553, -122.390981719843) | 10 | 3 | 8 | 58 | 1 | |||
| 84111 | 188960 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1728 La Salle Ave | 1 | : | Tree | Private 2 | 10 | Width 1ft | 6014895.27133 | 2096673.06939 | 37.7379020427381 | -122.390986689509 | (37.7379020427381, -122.390986689509) | 10 | 3 | 8 | 58 | 1 | |||
| 38323 | 100251 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 540 Delancey St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | 3x3 | 6015234.41692 | 2113622.27838 | 37.7844597292764 | -122.390998376191 | (37.7844597292764, -122.390998376191) | 6 | 2 | 9 | 28856 | 6 | |||
| 146724 | 189012 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1723 La Salle Ave | 1 | : | Tree | Private 2 | 9 | Width 3ft | 6014880.56648 | 2096608.52309 | 37.7377239958591 | -122.391033021681 | (37.7377239958591, -122.391033021681) | 10 | 3 | 8 | 58 | 1 | |||
| 17440 | 188953 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1723 La Salle Ave | 1 | : | Tree | Private 2 | 12 | Width 3ft | 6014879.29111 | 2096612.07207 | 37.7377336698595 | -122.391037679267 | (37.7377336698595, -122.391037679267) | 10 | 3 | 8 | 58 | 1 | |||
| 20625 | 188952 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1727 La Salle Ave | 1 | : | Tree | Private 2 | 12 | Width 3ft | 6014856.84284 | 2096629.67768 | 37.7377807655571 | -122.391116524617 | (37.7377807655571, -122.391116524617) | 10 | 3 | 8 | 58 | 1 | |||
| 136783 | 189011 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1727 La Salle Ave | 1 | : | Tree | Private 2 | 11 | Width 3ft | 6014856.73876 | 2096625.96923 | 37.7377705771381 | -122.391116625339 | (37.7377705771381, -122.391116625339) | 10 | 3 | 8 | 58 | 1 | |||
| 162824 | 200063 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1898 Lane St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 0ft | 6014797.2431 | 2094040.9343 | 37.7306692955134 | -122.391141695293 | (37.7306692955134, -122.391141695293) | 10 | 3 | 8 | 58 | 1 | |||
| 129719 | 67678 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1566 Underwood Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/05/1992 12:00:00 AM | 11 | Permit Number 31282 | 6014784.0524 | 2093614.4352 | 37.7294974829563 | -122.391157497644 | (37.7294974829563, -122.391157497644) | 10 | 3 | 8 | 58 | 1 | |
| 119172 | 189010 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1734 La Salle Ave | 1 | : | Tree | Private 2 | 11 | Width 3ft | 6014844.65282 | 2096707.75266 | 37.7379944669672 | -122.391164127549 | (37.7379944669672, -122.391164127549) | 10 | 3 | 8 | 58 | 1 | |||
| 33739 | 200064 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1898 Lane St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 0ft | 6014788.9989 | 2094027.194 | 37.7306311099169 | -122.391169236922 | (37.7306311099169, -122.391169236922) | 10 | 3 | 8 | 58 | 1 | |||
| 104418 | 188961 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1734 La Salle Ave | 1 | : | Tree | Private 2 | 13 | Width 3ft | 6014842.71506 | 2096714.04694 | 37.7380116422333 | -122.391171267237 | (37.7380116422333, -122.391171267237) | 10 | 3 | 8 | 58 | 1 |
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) );