trees
3,267 rows where qSpecies_id = 67 sorted by qCareAssistant 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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
53878 | 63011 | Permitted Site 7 | Callistemon citrinus :: Lemon Bottlebrush 67 | 199 Powhattan Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/23/1986 12:00:00 AM | Permit Number 23425 | 6007777.05506636 | 2098194.1467313 | 37.7416810309377 | -122.415705589886 | (37.7416810309377, -122.415705589886) | 2 | 7 | 7 | 28859 | 2 | ||
54526 | 40684 | Permitted Site 7 | Callistemon citrinus :: Lemon Bottlebrush 67 | 98 Ney St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/10/1999 12:00:00 AM | Permit Number 41667 | 6004026.21190005 | 2093997.85413123 | 37.7299473965939 | -122.428375735336 | (37.7299473965939, -122.428375735336) | 9 | 7 | 6 | 28861 | 5 | ||
54586 | 117116 | Permitted Site 7 | Callistemon citrinus :: Lemon Bottlebrush 67 | 76 Oakwood St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 6005231.58471967 | 2105020.01841489 | 37.7602798751206 | -122.424992522324 | (37.7602798751206, -122.424992522324) | 2 | 4 | 5 | 28859 | 19 | ||||
54937 | 31347 | Permitted Site 7 | Callistemon citrinus :: Lemon Bottlebrush 67 | 517 Laguna St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/12/1995 12:00:00 AM | Permit Number 34958 | 6004983.34013269 | 2110750.23773381 | 37.7759996553204 | -122.426259058519 | (37.7759996553204, -122.426259058519) | 7 | 9 | 11 | 28852 | 10 | ||
54997 | 31001 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 285 Chicago Way | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/13/1995 12:00:00 AM | 9 | Permit Number 34778 | 6002746.71825 | 2086679.2341 | 37.709779604712 | -122.432276616899 | (37.709779604712, -122.432276616899) | 9 | 7 | 6 | 28861 | 5 | |
56078 | 38346 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1862 45th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/29/1998 12:00:00 AM | 3 | Permit Number 40413 | 5982280.7574 | 2102429.3074 | 37.7518433707941 | -122.504175425295 | (37.7518433707941, -122.504175425295) | 1 | 8 | 3 | 56 | 35 | |
57668 | 64314 | Permitted Site 7 | Callistemon citrinus :: Lemon Bottlebrush 67 | 158 Randall St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/25/1988 12:00:00 AM | Permit Number 25131 | 6004545.85418713 | 2097571.72864017 | 37.739789842685 | -122.426833689992 | (37.739789842685, -122.426833689992) | 2 | 7 | 5 | 63 | 7 | ||
58552 | 42397 | Permitted Site 7 | Callistemon citrinus :: Lemon Bottlebrush 67 | 600 Gennessee St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/23/2000 12:00:00 AM | Permit Number 42555 | 5997487.92419847 | 2095274.73436784 | 37.7330812596511 | -122.451071309951 | (37.7330812596511, -122.451071309951) | 9 | 7 | 4 | 59 | 40 | ||
58928 | 41287 | Permitted Site 7 | Callistemon citrinus :: Lemon Bottlebrush 67 | 80X Rosemont Pl | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/19/2000 12:00:00 AM | Permit Number 771150 | 6005120.37250824 | 2107836.80061549 | 37.7680078062065 | -122.425577628833 | (37.7680078062065, -122.425577628833) | 8 | 4 | 5 | 28853 | 19 | ||
59842 | 67242 | Permitted Site 7 | Callistemon citrinus :: Lemon Bottlebrush 67 | 350 Hermann St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/08/1992 12:00:00 AM | 8 | Permit Number 30706 | 6003591.5003746 | 2108669.41865848 | 37.7702074667281 | -122.430925257683 | (37.7702074667281, -122.430925257683) | 15 | 9 | 11 | 29492 | 10 | |
59979 | 42834 | Permitted Site 7 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1501 Broadway | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/29/2000 12:00:00 AM | Permit Number 42767 | 6006419.40791846 | 2117956.96761218 | 37.7958686285947 | -122.421803333655 | (37.7958686285947, -122.421803333655) | 13 | 9 | 10 | 28858 | 32 | ||
60996 | 39584 | Permitted Site 7 | Callistemon citrinus :: Lemon Bottlebrush 67 | 812 Rhode Island St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/22/2002 12:00:00 AM | Permit Number 45485 | 6011827.16127123 | 2104595.75128112 | 37.759485287628 | -122.402151554664 | (37.759485287628, -122.402151554664) | 10 | 3 | 8 | 28856 | 29 | ||
62154 | 55682 | Permitted Site 7 | Callistemon citrinus :: Lemon Bottlebrush 67 | 105 Lundy's Ln | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/16/1987 12:00:00 AM | Permit Number 24542 | 6006870.6698132 | 2098947.4026548 | 37.7436983094089 | -122.418892984779 | (37.7436983094089, -122.418892984779) | 2 | 7 | 7 | 28859 | 2 | ||
62485 | 65261 | Permitted Site 7 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1156 Florida St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/26/1989 12:00:00 AM | Permit Number 28060 | 6009449.44831989 | 2102437.73284005 | 37.7534268519722 | -122.410222530405 | (37.7534268519722, -122.410222530405) | 2 | 4 | 7 | 28859 | 19 | ||
63650 | 43622 | Permitted Site 7 | Callistemon citrinus :: Lemon Bottlebrush 67 | 2095 35th Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/20/2000 12:00:00 AM | Permit Number 43271 | 5985386.76911027 | 2100967.4929928 | 37.7480118028434 | -122.493326874686 | (37.7480118028434, -122.493326874686) | 1 | 8 | 3 | 29491 | 35 | ||
65675 | 43164 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 243 Madison St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/11/2000 12:00:00 AM | 7 | Permit Number 42974 | 6005687.81247 | 2092539.35146 | 37.7260365522386 | -122.42252777796 | (37.7260365522386, -122.42252777796) | 9 | 7 | 7 | 309 | 5 | |
65850 | 69027 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 3830 Quintara St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/05/1994 12:00:00 AM | 0 | Permit Number 33031 | 5981593.45716069 | 2100816.99566217 | 37.7473759716808 | -122.506432607968 | (37.7473759716808, -122.506432607968) | 1 | 8 | 3 | 29491 | 35 | |
66511 | 43782 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 125 21st Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/26/2000 12:00:00 AM | 4 | Permit Number 43412 | 5989265.29398 | 2114516.23084 | 37.7854390383616 | -122.480907074228 | (37.7854390383616, -122.480907074228) | 11 | 6 | 2 | 55 | 26 | |
66943 | 114662 | Permitted Site 7 | Callistemon citrinus :: Lemon Bottlebrush 67 | 480 Myra Way | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 7 | 5997245.35324946 | 2096954.8836892 | 37.737680654694 | -122.452031115145 | (37.737680654694, -122.452031115145) | 9 | 7 | 4 | 59 | 40 | |||
67897 | 109264 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 3338X Ortega St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/05/2015 12:00:00 AM | 3 | 3x3 | 5983663.54917 | 2102222.75157 | 37.7513574508855 | -122.499378353213 | (37.7513574508855, -122.499378353213) | 1 | 8 | 3 | 29491 | 35 | |
68660 | 42816 | Permitted Site 7 | Callistemon citrinus :: Lemon Bottlebrush 67 | 210 Dorland St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/29/2000 12:00:00 AM | Permit Number 42761 | 6004170.54349458 | 2105725.9585872 | 37.7621582265556 | -122.428712491151 | (37.7621582265556, -122.428712491151) | 8 | 4 | 5 | 28862 | 3 | ||
68826 | 42991 | Permitted Site 7 | Callistemon citrinus :: Lemon Bottlebrush 67 | 500 Yale St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/05/2000 12:00:00 AM | Permit Number 42870 | 6007553.67502493 | 2091408.33369541 | 37.7230361052022 | -122.415997529963 | (37.7230361052022, -122.415997529963) | 9 | 3 | 7 | 309 | 28 | ||
69246 | 45091 | Permitted Site 7 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1900 Ortega St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/08/2001 12:00:00 AM | Permit Number 43969 | 5988148.79891202 | 2102403.3041825 | 37.7521153260597 | -122.48388126909 | (37.7521153260597, -122.48388126909) | 1 | 8 | 3 | 56 | 35 | ||
69457 | 38344 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1858 45th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/29/1998 12:00:00 AM | 2 | Permit Number 40411 | 5982279.7422 | 2102452.6585 | 37.7519074266581 | -122.504180665511 | (37.7519074266581, -122.504180665511) | 1 | 8 | 3 | 56 | 35 | |
69722 | 42673 | Permitted Site 7 | Callistemon citrinus :: Lemon Bottlebrush 67 | 581 Francisco St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/26/2000 12:00:00 AM | Permit Number 42700 | 6008532.69397696 | 2121039.56256614 | 37.8044516138202 | -122.414709203199 | (37.8044516138202, -122.414709203199) | 3 | 1 | 10 | 308 | 23 | ||
70304 | 43528 | Permitted Site 7 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1596 Hayes St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/19/2000 12:00:00 AM | Permit Number 43202 | 6000228.69199764 | 2110281.0663022 | 37.7744415315581 | -122.442672890747 | (37.7744415315581, -122.442672890747) | 15 | 5 | 11 | 29492 | 16 | ||
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 | |
71283 | 69110 | Permitted Site 7 | Callistemon citrinus :: Lemon Bottlebrush 67 | 318 Lawton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/10/1994 12:00:00 AM | Permit Number 33125 | 5993325.06338494 | 2104621.67061738 | 37.7585063618762 | -122.466142306467 | (37.7585063618762, -122.466142306467) | 1 | 8 | 4 | 56 | 12 | ||
71686 | 43362 | Permitted Site 7 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1100X Noe St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/17/2000 12:00:00 AM | 4 | 3x9 | Permit Number 43112 | 6003157.69483217 | 2101814.87307727 | 37.751361942995 | -122.431936260805 | (37.751361942995, -122.431936260805) | 2 | 4 | 5 | 28862 | 22 |
73478 | 66178 | Permitted Site 7 | Callistemon citrinus :: Lemon Bottlebrush 67 | 243 Bradford St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/07/1992 12:00:00 AM | Permit Number 29252 | 6009559.7518934 | 2097182.74370338 | 37.7390039901145 | -122.409470231128 | (37.7390039901145, -122.409470231128) | 10 | 7 | 7 | 28859 | 2 | ||
74588 | 67715 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 472 03rd St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/19/1992 12:00:00 AM | 8 | 3x3 | Permit Number 31328 | 6013692.95356 | 2112582.14451 | 37.7815181053298 | -122.396258423594 | (37.7815181053298, -122.396258423594) | 6 | 2 | 9 | 28856 | 34 |
76097 | 64932 | Permitted Site 7 | Callistemon citrinus :: Lemon Bottlebrush 67 | 2300 Cecilia Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/23/1989 12:00:00 AM | Permit Number 25960 | 5991529 | 2099733 | 37.7449795602653 | -122.471997526068 | (37.7449795602653, -122.471997526068) | 1 | 8 | 4 | 29491 | 40 | ||
76758 | 47842 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 4430 Cabrillo St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/14/2002 12:00:00 AM | 2 | Permit Number 45603 | 5981809.26084 | 2110330.3031 | 37.7735094979411 | -122.506391755128 | (37.7735094979411, -122.506391755128) | 11 | 6 | 2 | 55 | 26 | |
76854 | 61661 | Permitted Site 7 | Callistemon citrinus :: Lemon Bottlebrush 67 | 246 Cambridge St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/26/1984 12:00:00 AM | Permit Number 21655 | 6006644.56233954 | 2093348.38333355 | 37.7283119065735 | -122.419277711746 | (37.7283119065735, -122.419277711746) | 9 | 7 | 7 | 309 | 5 | ||
77048 | 67857 | Permitted Site 7 | Callistemon citrinus :: Lemon Bottlebrush 67 | 596 Valley St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/04/1993 12:00:00 AM | Permit Number 31532 | 6002067.00541727 | 2099182.85111765 | 37.7440731404676 | -122.435519715541 | (37.7440731404676, -122.435519715541) | 2 | 7 | 5 | 63 | 22 | ||
78218 | 42900 | Permitted Site 7 | Callistemon citrinus :: Lemon Bottlebrush 67 | 2200 Wawona St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/03/2000 12:00:00 AM | Permit Number 42815 | 5986138.5427207 | 2097288.78551671 | 37.737955001906 | -122.490456711772 | (37.737955001906, -122.490456711772) | 1 | 8 | 3 | 29491 | 35 | ||
78278 | 108844 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 420 Woolsey St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/06/2015 12:00:00 AM | 3 | Permit Number 772583 | 6010500.63404 | 2091864.14228 | 37.7244529081486 | -122.405842528314 | (37.7244529081486, -122.405842528314) | 10 | 3 | 7 | 309 | 28 | |
78926 | 60175 | Permitted Site 7 | Callistemon citrinus :: Lemon Bottlebrush 67 | 54 Lapidge St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/15/1988 12:00:00 AM | Permit Number 25533 | 6005979.27726365 | 2105187.71035503 | 37.7607825242813 | -122.42241851621 | (37.7607825242813, -122.42241851621) | 2 | 4 | 5 | 28859 | 19 | ||
80478 | 43619 | Permitted Site 7 | Callistemon citrinus :: Lemon Bottlebrush 67 | 2095 35th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/20/2000 12:00:00 AM | Permit Number 43271 | 5985386.76911027 | 2100967.4929928 | 37.7480118028434 | -122.493326874686 | (37.7480118028434, -122.493326874686) | 1 | 8 | 3 | 29491 | 35 | ||
80973 | 35809 | Permitted Site 7 | Callistemon citrinus :: Lemon Bottlebrush 67 | 51 Sycamore St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/22/1998 12:00:00 AM | Permit Number 39051 | 6006563.61712831 | 2105830.66384173 | 37.7625808703221 | -122.420443179735 | (37.7625808703221, -122.420443179735) | 8 | 4 | 7 | 28859 | 19 | ||
81863 | 42874 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 2366 33rd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/03/2000 12:00:00 AM | 5 | Permit Number 42798 | 5986118.9683 | 2099141.5396 | 37.7430410269224 | -122.490660668299 | (37.7430410269224, -122.490660668299) | 1 | 8 | 3 | 29491 | 35 | |
84838 | 37812 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 374 Athens St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/01/2003 12:00:00 AM | 6 | Permit Number 46656 | 6004021.4993 | 2091137.98354 | 37.722094560208 | -122.428188292583 | (37.722094560208, -122.428188292583) | 9 | 7 | 6 | 28861 | 5 | |
84896 | 35812 | Permitted Site 7 | Callistemon citrinus :: Lemon Bottlebrush 67 | 51 Sycamore St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/22/1998 12:00:00 AM | Permit Number 39051 | 6006563.61712831 | 2105830.66384173 | 37.7625808703221 | -122.420443179735 | (37.7625808703221, -122.420443179735) | 8 | 4 | 7 | 28859 | 19 | ||
84962 | 42831 | Permitted Site 7 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1501 Broadway | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/29/2000 12:00:00 AM | Permit Number 42767 | 6006419.40791846 | 2117956.96761218 | 37.7958686285947 | -122.421803333655 | (37.7958686285947, -122.421803333655) | 13 | 9 | 10 | 28858 | 32 | ||
85594 | 32090 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 3983 19th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/09/1995 12:00:00 AM | 6 | Permit Number 35463 | 6003141.07697 | 2104736.86022 | 37.759384082832 | -122.432202380562 | (37.759384082832, -122.432202380562) | 2 | 4 | 5 | 28862 | 3 | |
86371 | 39816 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 2135 45th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/06/1999 12:00:00 AM | 3 | Permit Number 41147 | 5982300.3859 | 2100562.0651 | 37.746717599317 | -122.503969259712 | (37.746717599317, -122.503969259712) | 1 | 8 | 3 | 29491 | 35 | |
87798 | 45341 | Permitted Site 7 | Callistemon citrinus :: Lemon Bottlebrush 67 | 667 Orizaba Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/27/2001 12:00:00 AM | Permit Number 44171 | 5994015.44130584 | 2090992.03620537 | 37.7211225948175 | -122.462765934958 | (37.7211225948175, -122.462765934958) | 9 | 8 | 6 | 64 | 24 | ||
90836 | 64569 | Permitted Site 7 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1429 Fulton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/26/1988 12:00:00 AM | Permit Number 25462 | 6000923.9519361 | 2111020.37522765 | 37.7765110963127 | -122.440320891248 | (37.7765110963127, -122.440320891248) | 15 | 5 | 11 | 29492 | 10 | ||
91000 | 63069 | Permitted Site 7 | Callistemon citrinus :: Lemon Bottlebrush 67 | 152 Banks St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/21/1986 12:00:00 AM | Permit Number 23543 | 6008631.63225831 | 2097862.90988188 | 37.7408195298569 | -122.412727325892 | (37.7408195298569, -122.412727325892) | 10 | 7 | 7 | 28859 | 2 | ||
91595 | 37777 | Permitted Site 7 | Callistemon citrinus :: Lemon Bottlebrush 67 | 449 Felton St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/06/1998 12:00:00 AM | Permit Number 40114 | 6009618.93348363 | 2093468.47161568 | 37.7288087098037 | -122.409003606238 | (37.7288087098037, -122.409003606238) | 10 | 3 | 7 | 309 | 28 | ||
91611 | 65941 | Permitted Site 7 | Callistemon citrinus :: Lemon Bottlebrush 67 | 665 Eddy St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/23/2000 12:00:00 AM | Permit Number 28962 | 6007255.62038472 | 2113291.4844342 | 37.7831054816789 | -122.418578871955 | (37.7831054816789, -122.418578871955) | 7 | 9 | 9 | 28852 | 36 | ||
91727 | 45088 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1900 Ortega St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/08/2001 12:00:00 AM | 2 | Permit Number 43969 | 5988077.6041 | 2102404.3375 | 37.7521140184342 | -122.484127544226 | (37.7521140184342, -122.484127544226) | 1 | 8 | 3 | 56 | 35 | |
91972 | 66534 | Permitted Site 7 | Callistemon citrinus :: Lemon Bottlebrush 67 | 701 Excelsior Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/22/1992 12:00:00 AM | Permit Number 30772 | 6004086.63776587 | 2091699.6936924 | 37.7236405778519 | -122.428003132555 | (37.7236405778519, -122.428003132555) | 9 | 7 | 6 | 28861 | 5 | ||
93438 | 31356 | Permitted Site 7 | Callistemon citrinus :: Lemon Bottlebrush 67 | 2399 16th Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/21/1995 12:00:00 AM | Permit Number 34966 | 5991349.80377986 | 2099091.89396406 | 37.7432088770408 | -122.472570415702 | (37.7432088770408, -122.472570415702) | 1 | 8 | 4 | 29491 | 40 | ||
94137 | 43556 | Permitted Site 7 | Callistemon citrinus :: Lemon Bottlebrush 67 | 338 28th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/20/2000 12:00:00 AM | Permit Number 43219 | 6003694.36665872 | 2099553.79617946 | 37.745183962731 | -122.429919119626 | (37.745183962731, -122.429919119626) | 2 | 7 | 5 | 63 | 22 | ||
94742 | 41819 | Permitted Site 7 | Callistemon citrinus :: Lemon Bottlebrush 67 | 29 Fortuna Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/20/2000 12:00:00 AM | Permit Number 42205 | 6000254.75248069 | 2112385.7950317 | 37.780222066079 | -122.442733903375 | (37.780222066079, -122.442733903375) | 15 | 5 | 1 | 29490 | 16 | ||
94981 | 35810 | Permitted Site 7 | Callistemon citrinus :: Lemon Bottlebrush 67 | 51 Sycamore St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/22/1998 12:00:00 AM | Permit Number 39051 | 6006563.61712831 | 2105830.66384173 | 37.7625808703221 | -122.420443179735 | (37.7625808703221, -122.420443179735) | 8 | 4 | 7 | 28859 | 19 | ||
95105 | 116732 | Permitted Site 7 | Callistemon citrinus :: Lemon Bottlebrush 67 | 3290 25th St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 4x4 | 6007783.42095653 | 2101534.76819168 | 37.7508539880545 | -122.415920085137 | (37.7508539880545, -122.415920085137) | 2 | 4 | 7 | 28859 | 19 | |||
95186 | 102083 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 714 15th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/09/2009 12:00:00 AM | 3 | 3x3 | Permit Number 52511 | 5991334.07902 | 2110523.03796 | 37.7745948642856 | -122.473458397492 | (37.7745948642856, -122.473458397492) | 11 | 6 | 2 | 54 | 26 |
96516 | 34357 | Permitted Site 7 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1822 Church St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/14/1997 12:00:00 AM | Permit Number 38113 | 6004544.96387342 | 2098197.10530749 | 37.741506934238 | -122.426881295332 | (37.741506934238, -122.426881295332) | 2 | 7 | 5 | 63 | 7 | ||
97011 | 63557 | Permitted Site 7 | Callistemon citrinus :: Lemon Bottlebrush 67 | 2971 21st St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/20/2011 12:00:00 AM | 4 | 3x3 | Permit Number 768581 | 6008414.60000343 | 2103856.53351654 | 37.7572644957121 | -122.413901624069 | (37.7572644957121, -122.413901624069) | 2 | 4 | 7 | 28859 | 19 |
98242 | 116731 | Permitted Site 7 | Callistemon citrinus :: Lemon Bottlebrush 67 | 3290 25th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 4x4 | 6007783.42095653 | 2101534.76819168 | 37.7508539880545 | -122.415920085137 | (37.7508539880545, -122.415920085137) | 2 | 4 | 7 | 28859 | 19 | |||
98494 | 69410 | Permitted Site 7 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1033 Prague St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/09/1994 12:00:00 AM | Permit Number 33515 | 6001287.00169166 | 2086793.18756043 | 37.7100096203988 | -122.437329807487 | (37.7100096203988, -122.437329807487) | 9 | 7 | 6 | 28861 | 5 | ||
100109 | 42396 | Permitted Site 7 | Callistemon citrinus :: Lemon Bottlebrush 67 | 600 Gennessee St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/23/2000 12:00:00 AM | Permit Number 42555 | 5997487.92419847 | 2095274.73436784 | 37.7330812596511 | -122.451071309951 | (37.7330812596511, -122.451071309951) | 9 | 7 | 4 | 59 | 40 | ||
100228 | 43816 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 2633 33rd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/27/2000 12:00:00 AM | 4 | Permit Number 43447 | 5986134.8144 | 2097343.6322 | 37.738105378566 | -122.490473636095 | (37.738105378566, -122.490473636095) | 1 | 8 | 3 | 29491 | 35 | |
100704 | 37778 | Permitted Site 7 | Callistemon citrinus :: Lemon Bottlebrush 67 | 449 Felton St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/06/1998 12:00:00 AM | Permit Number 40114 | 6009618.93348363 | 2093468.47161568 | 37.7288087098037 | -122.409003606238 | (37.7288087098037, -122.409003606238) | 10 | 3 | 7 | 309 | 28 | ||
101506 | 69213 | Permitted Site 7 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1177 Shotwell St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/31/1994 12:00:00 AM | Permit Number 33264 | 6008095.60945385 | 2101082.12715709 | 37.7496286841094 | -122.414808474137 | (37.7496286841094, -122.414808474137) | 2 | 4 | 7 | 28859 | 19 | ||
102189 | 46107 | Permitted Site 7 | Callistemon citrinus :: Lemon Bottlebrush 67 | 76 Oakwood St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/18/2001 12:00:00 AM | Permit Number 44471 | 6005231.58471967 | 2105020.01841489 | 37.7602798751206 | -122.424992522324 | (37.7602798751206, -122.424992522324) | 2 | 4 | 5 | 28859 | 19 | ||
102231 | 47679 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 327 Connecticut St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/21/2002 12:00:00 AM | 6 | Permit Number 45466 | 6013233.56276 | 2105528.81136 | 37.762125666091 | -122.397352923703 | (37.762125666091, -122.397352923703) | 10 | 3 | 8 | 28856 | 29 | |
103451 | 31816 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 378 Valley St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/19/1995 12:00:00 AM | 7 | Permit Number 35283 | 6003433.86405 | 2099244.43188 | 37.7443197640544 | -122.430797819357 | (37.7443197640544, -122.430797819357) | 2 | 7 | 5 | 63 | 22 | |
103808 | 69201 | Permitted Site 7 | Callistemon citrinus :: Lemon Bottlebrush 67 | 2829 Harrison St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/31/1994 12:00:00 AM | 20 | Permit Number 33249 | 6008994.37155301 | 2101984.87642995 | 37.7521578906902 | -122.411764291769 | (37.7521578906902, -122.411764291769) | 2 | 4 | 7 | 28859 | 19 | |
104045 | 31621 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 263 Vienna St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/21/2002 12:00:00 AM | 5 | Permit Number 45471 | 6004202.65828 | 2091873.57703 | 37.7241245863632 | -122.427614452251 | (37.7241245863632, -122.427614452251) | 9 | 7 | 6 | 28861 | 5 | |
104318 | 34699 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 783 45th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/28/1997 12:00:00 AM | 5 | Permit Number 38358 | 5981962.67601 | 2110441.20269 | 37.7738230269301 | -122.505869302151 | (37.7738230269301, -122.505869302151) | 11 | 6 | 2 | 55 | 26 | |
104602 | 66255 | Permitted Site 7 | Callistemon citrinus :: Lemon Bottlebrush 67 | 47 Los Palmos Dr | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/02/1991 12:00:00 AM | Permit Number 29357 | 5998777.54020022 | 2095889.92461041 | 37.7348441754269 | -122.446657030024 | (37.7348441754269, -122.446657030024) | 9 | 7 | 4 | 59 | 40 | ||
104970 | 49862 | Permitted Site 7 | Callistemon citrinus :: Lemon Bottlebrush 67 | 75@ LAGUNA Waller St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/17/2004 12:00:00 AM | Permit Number 46631 | 6005455.52049644 | 2109220.32111529 | 37.7718255527878 | -122.424516811052 | (37.7718255527878, -122.424516811052) | 7 | 9 | 5 | 28852 | 10 | ||
105935 | 109717 | Permitted Site 7 | Callistemon citrinus :: Lemon Bottlebrush 67 | 3832 Moraga St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/02/2015 12:00:00 AM | 3 | 3x3 | Permit Number 773646 | 5982350.4 | 2103585.5 | 37.7550220459753 | -122.504020225851 | (37.7550220459753, -122.504020225851) | 1 | 8 | 3 | 56 | 35 |
106486 | 66536 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 555 Bowdoin St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/09/1993 12:00:00 AM | 7 | Permit Number 32084 | 6008859.29808 | 2093449.63302 | 37.7287144005277 | -122.41162839585 | (37.7287144005277, -122.41162839585) | 9 | 3 | 7 | 309 | 28 | |
106907 | 67517 | Permitted Site 7 | Callistemon citrinus :: Lemon Bottlebrush 67 | 331 Staples Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/22/1992 12:00:00 AM | Permit Number 31053 | 5997889.85712008 | 2093779.21238518 | 37.7289979144345 | -122.449574001825 | (37.7289979144345, -122.449574001825) | 9 | 7 | 4 | 28861 | 40 | ||
107611 | 31138 | Permitted Site 7 | Callistemon citrinus :: Lemon Bottlebrush 67 | 419 Hearst Ave | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/21/1995 12:00:00 AM | Permit Number 34852 | 5998635.87955939 | 2094356.6234018 | 37.7306259997996 | -122.447036492148 | (37.7306259997996, -122.447036492148) | 9 | 7 | 4 | 28861 | 40 | ||
107713 | 64933 | Permitted Site 7 | Callistemon citrinus :: Lemon Bottlebrush 67 | 2299 Cecelia Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/23/1989 12:00:00 AM | Permit Number 25961 | 5991453.69210058 | 2099794.8219263 | 37.745144949294 | -122.472262430335 | (37.745144949294, -122.472262430335) | 1 | 8 | 4 | 29491 | 40 | ||
108556 | 42674 | Permitted Site 7 | Callistemon citrinus :: Lemon Bottlebrush 67 | 581 Francisco St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/26/2000 12:00:00 AM | Permit Number 42700 | 6008532.69397696 | 2121039.56256614 | 37.8044516138202 | -122.414709203199 | (37.8044516138202, -122.414709203199) | 3 | 1 | 10 | 308 | 23 | ||
110112 | 31003 | Permitted Site 7 | Callistemon citrinus :: Lemon Bottlebrush 67 | 285 Chicago Way | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/13/1995 12:00:00 AM | Permit Number 34778 | 6002766.74364375 | 2086692.10708835 | 37.7098160865806 | -122.432208324272 | (37.7098160865806, -122.432208324272) | 9 | 7 | 6 | 28861 | 5 | ||
110230 | 42132 | Permitted Site 7 | Callistemon citrinus :: Lemon Bottlebrush 67 | 171 Staples Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/21/2000 12:00:00 AM | Permit Number 42428 | 5998957.22367334 | 2093763.17021168 | 37.729014870842 | -122.445882895755 | (37.729014870842, -122.445882895755) | 9 | 7 | 4 | 28861 | 40 | ||
110243 | 42899 | Permitted Site 7 | Callistemon citrinus :: Lemon Bottlebrush 67 | 2200 Wawona St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/03/2000 12:00:00 AM | Permit Number 42815 | 5986138.5427207 | 2097288.78551671 | 37.737955001906 | -122.490456711772 | (37.737955001906, -122.490456711772) | 1 | 8 | 3 | 29491 | 35 | ||
110281 | 67889 | Permitted Site 7 | Callistemon citrinus :: Lemon Bottlebrush 67 | 217 27th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/22/1993 12:00:00 AM | Permit Number 31586 | 6005100.28778176 | 2100163.31762382 | 37.7469370880579 | -122.425101042804 | (37.7469370880579, -122.425101042804) | 2 | 7 | 5 | 63 | 22 | ||
110311 | 65802 | Permitted Site 7 | Callistemon citrinus :: Lemon Bottlebrush 67 | 2229 17th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/21/1990 12:00:00 AM | Permit Number 28770 | 5990998.9640501 | 2100230.16806226 | 37.7463139697598 | -122.473866540085 | (37.7463139697598, -122.473866540085) | 1 | 8 | 4 | 29491 | 40 | ||
110778 | 62443 | Permitted Site 7 | Callistemon citrinus :: Lemon Bottlebrush 67 | 4486 17th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/07/1985 12:00:00 AM | Permit Number 22606 | 5999444.95917987 | 2105754.12577185 | 37.7619669848025 | -122.445058450512 | (37.7619669848025, -122.445058450512) | 15 | 5 | 5 | 28862 | 3 | ||
111424 | 37785 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 300 Hamilton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/06/1998 12:00:00 AM | 8 | Permit Number 40118 | 6009296.44569 | 2092871.99765 | 37.7271528483173 | -122.410076380036 | (37.7271528483173, -122.410076380036) | 9 | 3 | 7 | 309 | 28 | |
115267 | 42901 | Permitted Site 7 | Callistemon citrinus :: Lemon Bottlebrush 67 | 2200 Wawona St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/03/2000 12:00:00 AM | Permit Number 42815 | 5986138.5427207 | 2097288.78551671 | 37.737955001906 | -122.490456711772 | (37.737955001906, -122.490456711772) | 1 | 8 | 3 | 29491 | 35 | ||
115343 | 32489 | Permitted Site 7 | Callistemon citrinus :: Lemon Bottlebrush 67 | 26 Uranus Ter | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/10/1996 12:00:00 AM | Permit Number 36996 | 5999299.5495957 | 2105598.47960948 | 37.7615313187924 | -122.445550170873 | (37.7615313187924, -122.445550170873) | 15 | 5 | 5 | 28862 | 3 | ||
115426 | 65680 | Permitted Site 7 | Callistemon citrinus :: Lemon Bottlebrush 67 | 223 Molimo Dr | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/13/1990 12:00:00 AM | Permit Number 28600 | 5997900.25631717 | 2096664.39788468 | 37.736920541741 | -122.449745884352 | (37.736920541741, -122.449745884352) | 9 | 7 | 4 | 59 | 40 | ||
117404 | 43562 | Permitted Site 7 | Callistemon citrinus :: Lemon Bottlebrush 67 | 406 29th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/20/2000 12:00:00 AM | Permit Number 43223 | 6003924.16559982 | 2098981.19483718 | 37.7436247428067 | -122.429083695417 | (37.7436247428067, -122.429083695417) | 2 | 7 | 5 | 63 | 22 | ||
117921 | 69349 | Permitted Site 7 | Callistemon citrinus :: Lemon Bottlebrush 67 | 2000 Chestnut St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/18/1994 12:00:00 AM | Permit Number 33440 | 6002263.91991676 | 2119868.04210329 | 37.8008807234583 | -122.436318920048 | (37.8008807234583, -122.436318920048) | 13 | 9 | 1 | 57 | 17 | ||
119372 | 68869 | Permitted Site 7 | Callistemon citrinus :: Lemon Bottlebrush 67 | 142 Staples Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/16/1996 12:00:00 AM | Permit Number 32833 | 5999135.06397081 | 2093812.50890208 | 37.7291604964354 | -122.445271636466 | (37.7291604964354, -122.445271636466) | 9 | 7 | 4 | 28861 | 40 | ||
121758 | 66945 | Permitted Site 7 | Callistemon citrinus :: Lemon Bottlebrush 67 | 83 Stanyan St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/02/1992 12:00:00 AM | Permit Number 30272 | 5996389.61664911 | 2112438.61542597 | 37.7801459984775 | -122.456108923399 | (37.7801459984775, -122.456108923399) | 11 | 6 | 2 | 54 | 16 | ||
121970 | 102062 | Permitted Site 7 | Callistemon citrinus :: Lemon Bottlebrush 67 | 26 Bennington St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/18/2012 12:00:00 AM | 4 | 3x3 | Permit Number 769724 | 6007185 | 2097679 | 37.7402332527197 | -122.417716218117 | (37.7402332527197, -122.417716218117) | 2 | 7 | 7 | 28859 | 2 |
122575 | 63801 | Permitted Site 7 | Callistemon citrinus :: Lemon Bottlebrush 67 | 89 Putnam St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/06/1992 12:00:00 AM | Permit Number 30608 | 6009178.90944984 | 2096954.7470526 | 37.7383566142673 | -122.410770917103 | (37.7383566142673, -122.410770917103) | 10 | 7 | 7 | 28859 | 2 | ||
122615 | 31651 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 3530 Wawona St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/02/2016 12:00:00 AM | 3 | Permit Number 778640 | 5981977.0239 | 2096750.5895 | 37.736233320022 | -122.504805016487 | (37.736233320022, -122.504805016487) | 1 | 8 | 3 | 29491 | 35 | |
122751 | 46792 | Permitted Site 7 | Callistemon citrinus :: Lemon Bottlebrush 67 | 283 Brentwood Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/25/2002 12:00:00 AM | Permit Number 44883 | 5994892.79937141 | 2095160.94854023 | 37.7326199133932 | -122.460035042749 | (37.7326199133932, -122.460035042749) | 9 | 8 | 4 | 59 | 40 | ||
127008 | 65659 | Permitted Site 7 | Callistemon citrinus :: Lemon Bottlebrush 67 | 67 Molimo Dr | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/12/1990 12:00:00 AM | Permit Number 28579 | 5998642.66061394 | 2096596.340533 | 37.7367761199068 | -122.447174176985 | (37.7367761199068, -122.447174176985) | 9 | 7 | 4 | 59 | 40 |
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) );