trees
400 rows where qSpecies_id = 43 sorted by SiteOrder
This data as json, CSV (advanced)
| rowid | TreeID | qLegalStatus_id | qSpecies_id | qAddress | SiteOrder ▼ | qSiteInfo | PlantType | qCaretaker_id | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location | Fire Prevention Districts | Police Districts | Supervisor Districts | Zip Codes | Neighborhoods (old) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 93886 | 68599 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 1939 16th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/21/1993 12:00:00 AM | Permit Number 32502 | 5991241.84953509 | 2102215.30732714 | 37.7517787113613 | -122.473171429533 | (37.7517787113613, -122.473171429533) | 1 | 8 | 4 | 29491 | 12 | ||
| 94076 | 31013 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 1016 Munich St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/13/1995 12:00:00 AM | Permit Number 34783 | 6002340.84086344 | 2087450.93520516 | 37.7118755052494 | -122.433734519918 | (37.7118755052494, -122.433734519918) | 9 | 7 | 6 | 28861 | 5 | ||
| 94256 | 34355 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 84 Chenery St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/11/2003 12:00:00 AM | Permit Number 38111 | 6004874.55521399 | 2097707.40817778 | 37.7401809675376 | -122.425706834494 | (37.7401809675376, -122.425706834494) | 2 | 7 | 5 | 63 | 7 | ||
| 94534 | 42120 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 630 Mangels Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/06/2002 12:00:00 AM | Permit Number 42417 | 5997254.13334531 | 2095296.10071131 | 37.7331265386983 | -122.451881123727 | (37.7331265386983, -122.451881123727) | 9 | 7 | 4 | 59 | 40 | ||
| 97486 | 36111 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 1290 12th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/29/1998 12:00:00 AM | Permit Number 39208 | 5992413.02593495 | 2106678.51938145 | 37.7641012654702 | -122.469446232974 | (37.7641012654702, -122.469446232974) | 11 | 8 | 11 | 56 | 12 | ||
| 98159 | 34672 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 3112 Buchanan St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/01/2005 12:00:00 AM | Permit Number 38340 | 6003381.0349361 | 2119134.6254032 | 37.7989303613953 | -122.432400821612 | (37.7989303613953, -122.432400821612) | 13 | 9 | 1 | 57 | 17 | ||
| 98168 | 37716 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 943 South Van Ness Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/29/1998 12:00:00 AM | Permit Number 40086 | 6007607.04837726 | 2104169.37424002 | 37.7580780981898 | -122.416716622543 | (37.7580780981898, -122.416716622543) | 2 | 4 | 7 | 28859 | 19 | ||
| 100442 | 37225 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 1471 34th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/12/1998 12:00:00 AM | Permit Number 39789 | 5985552.67131947 | 2105212.4791892 | 37.759677072307 | -122.493065858593 | (37.759677072307, -122.493065858593) | 1 | 8 | 3 | 56 | 35 | ||
| 100539 | 39065 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 238 Capp St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/11/2003 12:00:00 AM | Permit Number 40776 | 6007140.57976269 | 2105924.49860202 | 37.7628710155664 | -122.418454324135 | (37.7628710155664, -122.418454324135) | 8 | 4 | 7 | 28859 | 19 | ||
| 100897 | 68054 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 1881 08th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/23/1993 12:00:00 AM | Permit Number 31791 | 5993737.20481548 | 2102706.11474697 | 37.7532705090115 | -122.46457785688 | (37.7532705090115, -122.46457785688) | 1 | 8 | 4 | 56 | 12 | ||
| 101538 | 39689 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 56 Bay View St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/05/1999 12:00:00 AM | Permit Number 41074 | 6013706.29242939 | 2094956.2180602 | 37.7331218759444 | -122.394977388495 | (37.7331218759444, -122.394977388495) | 10 | 3 | 8 | 58 | 1 | ||
| 103016 | 34646 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 1596 27th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/28/1997 12:00:00 AM | Permit Number 38325 | 5987803.91965419 | 2104439.10360026 | 37.7576849982837 | -122.48522326103 | (37.7576849982837, -122.48522326103) | 1 | 8 | 3 | 56 | 35 | |||
| 104093 | 36188 | DPW Maintained 1 | Dodonaea viscosa :: Hop Bush 43 | 35 Parker Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/04/1998 12:00:00 AM | 7 | Permit Number 39256 | 5996804.8059 | 2114366.2904 | 37.7854627064304 | -122.454811918638 | (37.7854627064304, -122.454811918638) | 11 | 6 | 1 | 54 | 31 | |
| 105045 | 37437 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 51 Brewster St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/19/1998 12:00:00 AM | Permit Number 39912 | 6010454.2114909 | 2099614.59600709 | 37.745731407921 | -122.406548905427 | (37.745731407921, -122.406548905427) | 2 | 7 | 7 | 28859 | 2 | ||
| 106874 | 34110 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 1398 Plymouth Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/18/1998 12:00:00 AM | Permit Number 39363 | 5995892.17100072 | 2093289.41859175 | 37.7275385716585 | -122.456444707829 | (37.7275385716585, -122.456444707829) | 9 | 7 | 4 | 28861 | 40 | ||
| 107910 | 51637 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 189 Margaret Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/16/2005 12:00:00 AM | Permit Number 47927 | 5996660.05636895 | 2089154.42395132 | 37.7162289049692 | -122.453491707846 | (37.7162289049692, -122.453491707846) | 9 | 8 | 6 | 28861 | 24 | |||
| 108586 | 38812 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 343 11th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/27/1998 12:00:00 AM | Permit Number 40648 | 5992447.48955931 | 2113145.89233921 | 37.7818609227719 | -122.469797921948 | (37.7818609227719, -122.469797921948) | 11 | 6 | 2 | 54 | 11 | ||
| 110316 | 42870 | DPW Maintained 1 | Dodonaea viscosa :: Hop Bush 43 | 2554 32nd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/03/2000 12:00:00 AM | 5 | Permit Number 42793 | 5986474.4308 | 2097869.1881 | 37.73956824618 | -122.489338060188 | (37.73956824618, -122.489338060188) | 1 | 8 | 3 | 29491 | 35 | |
| 111237 | 38179 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 36 Dwight St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/17/1998 12:00:00 AM | Permit Number 40312 | 6011464.3100447 | 2091682.81198966 | 37.7240088592297 | -122.402498467389 | (37.7240088592297, -122.402498467389) | 10 | 3 | 7 | 309 | 28 | ||
| 111332 | 32293 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 160 Margaret Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/15/1999 12:00:00 AM | Permit Number 41561 | 5996702.09015079 | 2089306.207139 | 37.7166480756618 | -122.453357371649 | (37.7166480756618, -122.453357371649) | 9 | 8 | 6 | 28861 | 24 | ||
| 114140 | 43109 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 415 Taylor St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/31/2004 12:00:00 AM | Permit Number 42936 | 6009339.17842867 | 2114353.98733566 | 37.7861399408742 | -122.411445668311 | (37.7861399408742, -122.411445668311) | 5 | 10 | 9 | 28852 | 36 | ||
| 114946 | 35548 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 25 Fair Oaks St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/23/1998 12:00:00 AM | Permit Number 38924 | 6005398.06539258 | 2103564.19233402 | 37.7562919206066 | -122.424313197508 | (37.7562919206066, -122.424313197508) | 2 | 4 | 5 | 28859 | 19 | ||
| 115816 | 67467 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 4078 25th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/19/1999 12:00:00 AM | Permit Number 30982 | 6003350.50488606 | 2101289.69360575 | 37.7499308522406 | -122.431232018452 | (37.7499308522406, -122.431232018452) | 2 | 4 | 5 | 28862 | 22 | ||
| 116814 | 41829 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 1406 14th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/20/2000 12:00:00 AM | Permit Number 42215 | 5991820.03879919 | 2105845.80564429 | 37.7617805674142 | -122.471436503306 | (37.7617805674142, -122.471436503306) | 1 | 8 | 4 | 56 | 12 | ||
| 116815 | 35745 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 1005 Silliman St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/15/1998 12:00:00 AM | Permit Number 39018 | 6007884.66062501 | 2093417.72691387 | 37.728572072766 | -122.414995531053 | (37.728572072766, -122.414995531053) | 9 | 3 | 7 | 309 | 5 | ||
| 119260 | 38854 | DPW Maintained 1 | Dodonaea viscosa :: Hop Bush 43 | 1466 21st Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/02/1998 12:00:00 AM | 3 | Permit Number 40681 | 5989630.3392 | 2105375.4166 | 37.7603620895733 | -122.478975308071 | (37.7603620895733, -122.478975308071) | 1 | 8 | 3 | 56 | 35 | |
| 120572 | 45413 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 845 Head St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/11/2001 12:00:00 AM | Permit Number 44215 | 5993893.70509068 | 2091558.26488077 | 37.7226703098261 | -122.463227804134 | (37.7226703098261, -122.463227804134) | 9 | 8 | 4 | 59 | 40 | ||
| 122187 | 35402 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 531 30th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/16/1998 12:00:00 AM | Permit Number 38857 | 6003188.18562105 | 2098310.25744294 | 37.7417408149917 | -122.431580643052 | (37.7417408149917, -122.431580643052) | 2 | 7 | 5 | 63 | 7 | ||
| 123655 | 38553 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 1791 La Salle Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/10/2005 12:00:00 AM | Permit Number 40521 | 6014535.26572589 | 2096873.10267881 | 37.7384313099375 | -122.392245401183 | (37.7384313099375, -122.392245401183) | 10 | 3 | 8 | 58 | 1 | ||
| 124119 | 37706 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 700 South Van Ness Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/29/1998 12:00:00 AM | Permit Number 40082 | 6007477.44704972 | 2105569.08555176 | 37.7619140920083 | -122.417264027542 | (37.7619140920083, -122.417264027542) | 2 | 4 | 7 | 28859 | 19 | ||
| 125189 | 38617 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 1619 Revere Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/17/1998 12:00:00 AM | Permit Number 40558 | 6014993.23240611 | 2094434.43177017 | 37.7317606344589 | -122.390491609305 | (37.7317606344589, -122.390491609305) | 10 | 3 | 8 | 58 | 1 | ||
| 125415 | 34401 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 157 Moffitt St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/15/1997 12:00:00 AM | Permit Number 38148 | 6002541.2507672 | 2096900.64630627 | 37.7378336595187 | -122.433716803341 | (37.7378336595187, -122.433716803341) | 2 | 7 | 5 | 63 | 7 | ||
| 126210 | 37454 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 125 Gates St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/19/1998 12:00:00 AM | Permit Number 39928 | 6008336.46582591 | 2098008.78903327 | 37.7412035106459 | -122.413758220259 | (37.7412035106459, -122.413758220259) | 2 | 7 | 7 | 28859 | 2 | ||
| 126430 | 37123 | DPW Maintained 1 | Dodonaea viscosa :: Hop Bush 43 | 4200 Kirkham St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/01/1998 12:00:00 AM | 0 | Permit Number 39711 | 5981854.3307572 | 2104909.94156092 | 37.7586294023629 | -122.505833929701 | (37.7586294023629, -122.505833929701) | 1 | 8 | 3 | 56 | 35 | |
| 126442 | 35941 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 19 Bennington St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/27/1998 12:00:00 AM | Permit Number 39104 | 6007226.10455525 | 2097703.31078326 | 37.7403023177454 | -122.417575817322 | (37.7403023177454, -122.417575817322) | 2 | 7 | 7 | 28859 | 2 | ||
| 129953 | 42147 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 490 19th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/21/2000 12:00:00 AM | Permit Number 42443 | 5990026.73861506 | 2112033.51240967 | 37.7786664170583 | -122.478091152159 | (37.7786664170583, -122.478091152159) | 11 | 6 | 2 | 55 | 26 | |||
| 131078 | 31826 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 204 Dore St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/19/1995 12:00:00 AM | Permit Number 35286 | 6009467.18551703 | 2109171.58635448 | 37.7719174714901 | -122.410636689386 | (37.7719174714901, -122.410636689386) | 8 | 2 | 9 | 28853 | 34 | ||
| 131612 | 37420 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 679 Duncan St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/15/1998 12:00:00 AM | Permit Number 39898 | 6002152.44125634 | 2099703.71933952 | 37.7455081743626 | -122.435261547297 | (37.7455081743626, -122.435261547297) | 2 | 7 | 5 | 63 | 22 | ||
| 132556 | 43498 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 4145 Folsom St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/19/2000 12:00:00 AM | Permit Number 43178 | 6008355.55350511 | 2095881.30836855 | 37.7353629859312 | -122.413541790025 | (37.7353629859312, -122.413541790025) | 10 | 7 | 7 | 28859 | 2 | ||
| 134688 | 43251 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 270 Holyoke St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/12/2000 12:00:00 AM | Permit Number 43039 | 6009534.75313896 | 2093131.57732831 | 37.727878953409 | -122.409270860276 | (37.727878953409, -122.409270860276) | 10 | 3 | 7 | 309 | 28 | ||
| 136510 | 34429 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 204 Surrey St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/15/1997 12:00:00 AM | Permit Number 38173 | 6002089.34387418 | 2096139.54747106 | 37.7357182050796 | -122.435224839434 | (37.7357182050796, -122.435224839434) | 2 | 7 | 5 | 63 | 7 | ||
| 137049 | 37869 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 135 Colon Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/22/2002 12:00:00 AM | Permit Number 40155 | 5996120.55604725 | 2093902.0241844 | 37.7292337486651 | -122.455699446357 | (37.7292337486651, -122.455699446357) | 9 | 7 | 4 | 28861 | 40 | ||
| 138527 | 42740 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 188 Nueva Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/26/2000 12:00:00 AM | Permit Number 42736 | 6012851.94955825 | 2087048.25997051 | 37.7113606761586 | -122.397376721388 | (37.7113606761586, -122.397376721388) | 10 | 3 | 8 | 309 | 1 | ||
| 139109 | 38601 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 1534 Revere Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/17/1998 12:00:00 AM | Permit Number 40552 | 6015446.13574073 | 2094163.07491578 | 37.7310406573671 | -122.388906878559 | (37.7310406573671, -122.388906878559) | 10 | 3 | 8 | 58 | 1 | ||
| 139708 | 31829 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 222 Dore St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/19/1995 12:00:00 AM | Permit Number 35288 | 6009542.64532801 | 2109092.58934898 | 37.7717047944846 | -122.410370088519 | (37.7717047944846, -122.410370088519) | 8 | 2 | 9 | 28853 | 34 | ||
| 139804 | 191035 | DPW Maintained 1 | Dodonaea viscosa :: Hop Bush 43 | 30 Langton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 2ft | 6009859.31671 | 2111047.24968 | 37.7770895827422 | -122.409412667772 | (37.7770895827422, -122.409412667772) | 8 | 2 | 9 | 28853 | 34 | |||
| 139892 | 38864 | DPW Maintained 1 | Dodonaea viscosa :: Hop Bush 43 | 1442 23rd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/02/1998 12:00:00 AM | 4 | Permit Number 40691 | 5989006.457 | 2105496.048 | 37.7606570618134 | -122.481141834437 | (37.7606570618134, -122.481141834437) | 1 | 8 | 3 | 56 | 35 | |
| 140321 | 36492 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 95 Westwood Dr | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/18/1998 12:00:00 AM | Permit Number 39377 | 5995116.30141704 | 2093273.83949404 | 37.7274512220857 | -122.459125749197 | (37.7274512220857, -122.459125749197) | 9 | 7 | 4 | 28861 | 40 | |||
| 140614 | 37066 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 326 Valley St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/16/2004 12:00:00 AM | Permit Number 39668 | 6003784.55345185 | 2099265.25748104 | 37.7443968092105 | -122.429586694845 | (37.7443968092105, -122.429586694845) | 2 | 7 | 5 | 63 | 22 | ||
| 141950 | 34656 | DPW Maintained 1 | Dodonaea viscosa :: Hop Bush 43 | 2200 Kirkham St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/28/1997 12:00:00 AM | 2 | Permit Number 38334 | 5988021.6232 | 2105120.5638 | 37.7595687826789 | -122.484520345625 | (37.7595687826789, -122.484520345625) | 1 | 8 | 3 | 56 | 35 | |
| 142202 | 34398 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 141 Moffitt St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/22/2016 12:00:00 AM | 3 | Permit Number 38145 | 6002598.06465628 | 2096836.91119738 | 37.7376618812243 | -122.433515816831 | (37.7376618812243, -122.433515816831) | 2 | 7 | 5 | 63 | 7 | |
| 142418 | 37039 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 1660 Church St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/01/1998 12:00:00 AM | Permit Number 39650 | 6004584.07651504 | 2099217.83848958 | 37.7443118455047 | -122.426818732995 | (37.7443118455047, -122.426818732995) | 2 | 7 | 5 | 63 | 22 | |||
| 142598 | 35422 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 527 Valley St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/16/1998 12:00:00 AM | Permit Number 38873 | 6002518.46166442 | 2099137.02773671 | 37.7439729506581 | -122.433955407599 | (37.7439729506581, -122.433955407599) | 2 | 7 | 5 | 63 | 22 | ||
| 142691 | 36568 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 327 Richland Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/19/1998 12:00:00 AM | Permit Number 39430 | 6006720.99763739 | 2096073.95090972 | 37.7358000222337 | -122.419206729617 | (37.7358000222337, -122.419206729617) | 2 | 7 | 7 | 28859 | 2 | ||
| 143304 | 42554 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 519 Darien Way | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/26/2000 12:00:00 AM | Permit Number 42646 | 5993007.97320082 | 2094936.14188553 | 37.7318940637686 | -122.466534957812 | (37.7318940637686, -122.466534957812) | 9 | 8 | 4 | 59 | 40 | ||
| 143533 | 38037 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 125 Wawona St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/10/1998 12:00:00 AM | Permit Number 40239 | 5992979.27513605 | 2098217.94646306 | 37.7409034220219 | -122.466872661258 | (37.7409034220219, -122.466872661258) | 1 | 8 | 4 | 59 | 40 | ||
| 145081 | 36827 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 2600 Ingalls St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/26/1998 12:00:00 AM | Permit Number 39535 | 6015154.00494247 | 2091194.79088837 | 37.7228741446414 | -122.38970959128 | (37.7228741446414, -122.38970959128) | 10 | 3 | 8 | 58 | 1 | ||
| 146098 | 38618 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 1648 Revere Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/17/1998 12:00:00 AM | Permit Number 40559 | 6014913.01600852 | 2094558.97753063 | 37.7320981616183 | -122.390777636678 | (37.7320981616183, -122.390777636678) | 10 | 3 | 8 | 58 | 1 | ||
| 146130 | 40068 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 1410 Thomas Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/19/1999 12:00:00 AM | Permit Number 41295 | 6015766.58727052 | 2093225.96783558 | 37.7284853051097 | -122.387733653848 | (37.7284853051097, -122.387733653848) | 10 | 3 | 8 | 58 | 1 | ||
| 147242 | 43743 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 240 Summit St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/25/2000 12:00:00 AM | Permit Number 43377 | 5996455.89048278 | 2089497.50907915 | 37.7171592309734 | -122.454222165987 | (37.7171592309734, -122.454222165987) | 9 | 8 | 6 | 28861 | 24 | ||
| 147396 | 38211 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 201 Olmstead St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/17/1998 12:00:00 AM | Permit Number 40334 | 6011139.75939059 | 2091047.44760609 | 37.7222461553598 | -122.403575712805 | (37.7222461553598, -122.403575712805) | 10 | 3 | 7 | 309 | 28 | ||
| 147777 | 36830 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 2655 Ingalls St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/26/1998 12:00:00 AM | Permit Number 39536 | 6015108.90537025 | 2091047.28537032 | 37.7224666226612 | -122.389855194073 | (37.7224666226612, -122.389855194073) | 10 | 3 | 8 | 58 | 1 | ||
| 150043 | 246390 | DPW Maintained 1 | Dodonaea viscosa :: Hop Bush 43 | 1267 Masonic Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 2 | Width 0ft | 5999435.2691 | 2108467.7761 | 37.7694174354079 | -122.445287080875 | (37.7694174354079, -122.445287080875) | 15 | 5 | 11 | 29492 | 9 | |||
| 150087 | 39909 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 1600 Divisadero St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/08/2001 12:00:00 AM | Permit Number 41187 | 6001194.58559448 | 2113861.70061497 | 37.7843280584248 | -122.439588431897 | (37.7843280584248, -122.439588431897) | 15 | 6 | 11 | 29490 | 13 | ||
| 150948 | 38598 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 1329 Revere Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/17/1998 12:00:00 AM | Permit Number 40549 | 6016511.31684241 | 2093304.91013991 | 37.7287432904596 | -122.385164559023 | (37.7287432904596, -122.385164559023) | 10 | 3 | 8 | 58 | 1 | ||
| 151050 | 42013 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 39 Pinehurst Way | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/21/2000 12:00:00 AM | Permit Number 42341 | 5993258.45652191 | 2093300.0310097 | 37.7274161576674 | -122.465550175008 | (37.7274161576674, -122.465550175008) | 9 | 8 | 4 | 59 | 40 | ||
| 151337 | 36907 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 884 Alvarado St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/02/1998 12:00:00 AM | Permit Number 40695 | 6000695.68812692 | 2102606.86536781 | 37.7533966824522 | -122.440506941015 | (37.7533966824522, -122.440506941015) | 2 | 4 | 5 | 28862 | 22 | ||
| 151562 | 40060 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 1298 Thomas Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/19/1999 12:00:00 AM | Permit Number 41292 | 6016382.10864513 | 2092767.10585329 | 37.7272594375757 | -122.385573778693 | (37.7272594375757, -122.385573778693) | 10 | 3 | 8 | 58 | 1 | ||
| 152141 | 40299 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 2155 Mission St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/13/1999 12:00:00 AM | Permit Number 41445 | 6006883.99939755 | 2105792.08668164 | 37.7624929958367 | -122.419332354319 | (37.7624929958367, -122.419332354319) | 8 | 4 | 7 | 28859 | 19 | ||
| 154775 | 37314 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 485 Hill St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/15/1998 12:00:00 AM | Permit Number 39829 | 6003203.23907746 | 2103274.86360864 | 37.7553733132886 | -122.431883001431 | (37.7553733132886, -122.431883001431) | 2 | 4 | 5 | 28862 | 22 | ||
| 155194 | 55092 | DPW Maintained 1 | Dodonaea viscosa :: Hop Bush 43 | 535 16th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/24/2017 12:00:00 AM | 3 | Permit Number 779353 | 5990916.44075 | 2111744.45268 | 37.7779243407011 | -122.474992253786 | (37.7779243407011, -122.474992253786) | 11 | 6 | 2 | 54 | 26 | ||
| 155234 | 39134 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 810 Capp St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/30/2000 12:00:00 AM | Permit Number 40813 | 6007325.69907761 | 2102579.12781976 | 37.7536958179011 | -122.417576944272 | (37.7536958179011, -122.417576944272) | 2 | 4 | 7 | 28859 | 19 | ||
| 155289 | 31184 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 700 Shields St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/21/1995 12:00:00 AM | Permit Number 34882 | 5992197.59450604 | 2089880.36663556 | 37.7179653541743 | -122.468968787075 | (37.7179653541743, -122.468968787075) | 9 | 8 | 6 | 64 | 24 | ||
| 157890 | 40555 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 215 Santa Ana Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/23/1999 12:00:00 AM | Permit Number 41596 | 5992664.70806244 | 2095313.38893204 | 37.7329100758329 | -122.467749114045 | (37.7329100758329, -122.467749114045) | 9 | 8 | 4 | 59 | 40 | ||
| 159345 | 37542 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 704 Post St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/22/1998 12:00:00 AM | Permit Number 39985 | 6008763.04341244 | 2114941.12322015 | 37.7877197423167 | -122.413480489066 | (37.7877197423167, -122.413480489066) | 5 | 1 | 10 | 28858 | 21 | ||
| 160336 | 68399 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 10 Pinehurst Way | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/09/1993 12:00:00 AM | Permit Number 32230 | 5993170.65048654 | 2093114.37273837 | 37.7269013208382 | -122.465840234227 | (37.7269013208382, -122.465840234227) | 9 | 8 | 4 | 59 | 40 | ||
| 161378 | 34346 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 255 30th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/14/1997 12:00:00 AM | Permit Number 38104 | 6004828.12803067 | 2098393.70147146 | 37.7420627492496 | -122.425916201102 | (37.7420627492496, -122.425916201102) | 2 | 7 | 5 | 63 | 7 | ||
| 162238 | 68548 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 542 44th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/18/1993 12:00:00 AM | Permit Number 32435 | 5982266.27393695 | 2112076.97528737 | 37.7783322447781 | -122.504940366327 | (37.7783322447781, -122.504940366327) | 11 | 6 | 2 | 55 | 26 | ||
| 162751 | 43695 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 754 09th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/25/2000 12:00:00 AM | Permit Number 43339 | 5993219.60495236 | 2110339.98425191 | 37.7742012556984 | -122.466922735732 | (37.7742012556984, -122.466922735732) | 11 | 6 | 2 | 54 | 11 | ||
| 163982 | 35510 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 3478 22nd St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/23/1998 12:00:00 AM | Permit Number 38912 | 6005194.49677521 | 2103146.93967049 | 37.7551347452856 | -122.424987522768 | (37.7551347452856, -122.424987522768) | 2 | 4 | 5 | 28859 | 19 | ||
| 166378 | 38565 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 1360 Oakdale Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/17/1998 12:00:00 AM | Permit Number 40531 | 6016200.74571731 | 2094639.7722335 | 37.7323913709995 | -122.386331262014 | (37.7323913709995, -122.386331262014) | 10 | 3 | 8 | 58 | 1 | ||
| 166774 | 141601 | DPW Maintained 1 | Dodonaea viscosa :: Hop Bush 43 | 1882 GROVE ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 0ft | 5998863.8341 | 2110436.3604 | 37.77479003056 | -122.447405354515 | (37.77479003056, -122.447405354515) | 15 | 5 | 11 | 29492 | 16 | |||
| 168287 | 39138 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 1081 Capp St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/19/1998 12:00:00 AM | Permit Number 40817 | 6007463.5839422 | 2101024.83737451 | 37.7494358467299 | -122.416989987658 | (37.7494358467299, -122.416989987658) | 2 | 4 | 7 | 28859 | 19 | ||
| 168308 | 37063 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 1468 Sanchez St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/01/1998 12:00:00 AM | Permit Number 39664 | 6003912.84552522 | 2099719.17052238 | 37.7456504127787 | -122.429175446828 | (37.7456504127787, -122.429175446828) | 2 | 7 | 5 | 63 | 22 | ||
| 169396 | 33344 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 760 Darien Way | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/14/1996 12:00:00 AM | Permit Number 37481 | 5993727.41255463 | 2094297.74009538 | 37.730182659203 | -122.464001399226 | (37.730182659203, -122.464001399226) | 9 | 8 | 4 | 59 | 40 | ||
| 169743 | 37845 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 132 Brewster St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/02/2005 12:00:00 AM | Permit Number 40137 | 6010294.81147281 | 2099208.35616527 | 37.7446070428057 | -122.40707146066 | (37.7446070428057, -122.40707146066) | 2 | 7 | 7 | 28859 | 2 | ||
| 170691 | 37458 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 25 MacEdonia St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/19/1998 12:00:00 AM | Permit Number 39930 | 6010305.7989409 | 2099791.60340169 | 37.7462091274065 | -122.407074571233 | (37.7462091274065, -122.407074571233) | 2 | 7 | 7 | 28859 | 2 | ||
| 170901 | 36718 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 1850 Mission St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/14/2004 12:00:00 AM | Permit Number 39504 | 6006730.53287232 | 2107601.56248509 | 37.767452746672 | -122.419991553753 | (37.767452746672, -122.419991553753) | 8 | 4 | 7 | 28853 | 19 | ||
| 171637 | 37105 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 1495 48th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/01/1998 12:00:00 AM | Permit Number 39704 | 5981217.84304819 | 2104908.99665532 | 37.7585893245545 | -122.508035083937 | (37.7585893245545, -122.508035083937) | 1 | 8 | 3 | 56 | 35 | ||
| 172042 | 36471 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 101 San Ramon Way | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/18/1998 12:00:00 AM | Permit Number 39368 | 5995817.82622595 | 2092643.889646 | 37.7257618354228 | -122.456655052435 | (37.7257618354228, -122.456655052435) | 9 | 7 | 4 | 28861 | 40 | ||
| 172166 | 36078 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 2134 Folsom St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/28/1998 12:00:00 AM | Permit Number 39191 | 6008086.14600314 | 2105996.63644369 | 37.7631222746353 | -122.415189036821 | (37.7631222746353, -122.415189036821) | 8 | 4 | 7 | 28859 | 19 | ||
| 172670 | 39490 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 4054 24th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/28/1998 12:00:00 AM | Permit Number 40948 | 6002823.01095214 | 2101848.4791437 | 37.7514352381886 | -122.433096036215 | (37.7514352381886, -122.433096036215) | 2 | 4 | 5 | 28862 | 22 | ||
| 172758 | 102442 | Undocumented 4 | Dodonaea viscosa :: Hop Bush 43 | 4145 Folsom St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | 3x3 | 6008344 | 2095883 | 37.735366982035 | -122.413581854524 | (37.735366982035, -122.413581854524) | 10 | 7 | 7 | 28859 | 2 | |||
| 172957 | 40642 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 185 Ripley St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/10/1999 12:00:00 AM | Permit Number 41640 | 6009192.03574967 | 2099143.33903301 | 37.7443667457738 | -122.410880064189 | (37.7443667457738, -122.410880064189) | 2 | 7 | 7 | 28859 | 2 | |||
| 173394 | 64645 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 855 Faxon Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/06/1997 12:00:00 AM | Permit Number 25560 | 5994845.99503562 | 2093786.0882856 | 37.7288421898975 | -122.460097287553 | (37.7288421898975, -122.460097287553) | 9 | 7 | 4 | 28861 | 40 | ||
| 173565 | 38123 | DPW Maintained 1 | Dodonaea viscosa :: Hop Bush 43 | 1200 33rd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/13/1998 12:00:00 AM | 5 | Permit Number 40287 | 5985851.366 | 2107007.0192 | 37.7646218448258 | -122.492164972302 | (37.7646218448258, -122.492164972302) | 1 | 8 | 3 | 56 | 35 | |
| 175884 | 37069 | DPW Maintained 1 | Dodonaea viscosa :: Hop Bush 43 | 1474 42nd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/01/1998 12:00:00 AM | 4 | Permit Number 39671 | 5983120.2149 | 2105112.095 | 37.7592588855971 | -122.501470953069 | (37.7592588855971, -122.501470953069) | 1 | 8 | 3 | 56 | 35 | |
| 176487 | 34803 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 722 Huron Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/29/1997 12:00:00 AM | Permit Number 38439 | 5997690.29775308 | 2087581.0038805 | 37.7119676582592 | -122.449817388593 | (37.7119676582592, -122.449817388593) | 9 | 7 | 6 | 28861 | 25 | ||
| 178201 | 68496 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 1822 09th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/18/1993 12:00:00 AM | Permit Number 32372 | 5993466.35859208 | 2103074.11595722 | 37.7542653280544 | -122.465541223192 | (37.7542653280544, -122.465541223192) | 1 | 8 | 4 | 56 | 12 | ||
| 178986 | 38863 | DPW Maintained 1 | Dodonaea viscosa :: Hop Bush 43 | 1565 22nd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/02/1998 12:00:00 AM | 0 | Permit Number 40690 | 5989296.21457943 | 2104699.06297943 | 37.7584855960627 | -122.480081376814 | (37.7584855960627, -122.480081376814) | 1 | 8 | 3 | 56 | 35 |
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) );