trees
3,247 rows where qSpecies_id = 22 sorted by Zip Codes
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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 51754 | 192481 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 301 Kansas St | 16 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 4ft | 6011473.76418 | 2106869.53362 | 37.7657088529051 | -122.403533758181 | (37.7657088529051, -122.403533758181) | 8 | 3 | 8 | 28853 | 20 | |||
| 51998 | 200878 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 1699 16th St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 0ft | 6011671.017 | 2106962.6332 | 37.7659754993951 | -122.402858047835 | (37.7659754993951, -122.402858047835) | 8 | 3 | 8 | 28853 | 20 | |||
| 52523 | 192434 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 382 07th St | 1 | : | Tree | Private 2 | 10 | Width 3ft | 6010729.70482 | 2110519.81747 | 37.7756901054455 | -122.406364535314 | (37.7756901054455, -122.406364535314) | 14 | 2 | 9 | 28853 | 34 | |||
| 53773 | 192480 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 301 Kansas St | 17 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 4ft | 6011473.03929 | 2106892.33623 | 37.7657714232394 | -122.403537869879 | (37.7657714232394, -122.403537869879) | 8 | 3 | 8 | 28853 | 20 | |||
| 54066 | 45340 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 1335 Minna St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/26/2001 12:00:00 AM | Permit Number 44170 | 6006996.02252299 | 2107706.14751942 | 37.767754866633 | -122.419080678059 | (37.767754866633, -122.419080678059) | 8 | 4 | 7 | 28853 | 19 | |||
| 54300 | 226108 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 229 Guerrero St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6005502.71783 | 2107611.57733 | 37.7674109934501 | -122.424239116741 | (37.7674109934501, -122.424239116741) | 8 | 4 | 5 | 28853 | 19 | |||
| 54891 | 7385 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 1030 Folsom St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 45 | 3X3 | 6010712.59416 | 2111404.7447 | 37.7781189525395 | -122.406486096036 | (37.7781189525395, -122.406486096036) | 14 | 2 | 9 | 28853 | 34 | |||
| 55376 | 91312 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 450 Rhode Island St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/06/2009 12:00:00 AM | 3x3 | Permit Number 52049 | 6011745 | 2106547 | 37.7648383947947 | -122.40257292402 | (37.7648383947947, -122.40257292402) | 8 | 3 | 8 | 28853 | 20 | ||
| 57007 | 48370 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 350& 17th ST Rhode Island St | 23 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/22/2002 12:00:00 AM | Permit Number 45774 | 6011708.83412888 | 2106755.94348957 | 37.7654100874921 | -122.402712708416 | (37.7654100874921, -122.402712708416) | 8 | 3 | 8 | 28853 | 20 | |||
| 59583 | 226032 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 2 Trainor St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6008305.39853 | 2108206.22507 | 37.7692016110942 | -122.414587082622 | (37.7692016110942, -122.414587082622) | 8 | 4 | 7 | 28853 | 19 | |||
| 61394 | 192431 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 340 06th St | 2 | : | Tree | Private 2 | 7 | Width 3ft | 6011135.53343 | 2111313.58749 | 37.7778923077093 | -122.405016568457 | (37.7778923077093, -122.405016568457) | 14 | 2 | 9 | 28853 | 34 | |||
| 61947 | 36689 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 30 Albion St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/22/2002 12:00:00 AM | Permit Number 45855 | 6005757.61033958 | 2107079.95878875 | 37.7659656844986 | -122.423319681918 | (37.7659656844986, -122.423319681918) | 8 | 4 | 5 | 28853 | 19 | ||
| 63028 | 114489 | Undocumented 4 | Ginkgo biloba :: Maidenhair Tree 22 | 740 CLEMENTINA ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | 2x3 | 6009285 | 2110275 | 37.7749369712978 | -122.411344848489 | (37.7749369712978, -122.411344848489) | 8 | 2 | 9 | 28853 | 34 | |||
| 63770 | 52871 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 87@ 9th ST McLea Ct | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/10/2006 12:00:00 AM | 2 | Permit Number 48881 | 6010042.49512 | 2109199.03478 | 37.7720250767276 | -122.408648579482 | (37.7720250767276, -122.408648579482) | 14 | 2 | 9 | 28853 | 34 | ||
| 63871 | 190563 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 1748 Alameda St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/03/2017 12:00:00 AM | 3 | Width 3ft | 6011562.23742 | 2107955.71991 | 37.7686962163789 | -122.403304163964 | (37.7686962163789, -122.403304163964) | 8 | 2 | 8 | 28853 | 20 | ||
| 65810 | 114297 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 301X 07TH ST | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 6010388 | 2110913 | 37.7767505721368 | -122.407574310337 | (37.7767505721368, -122.407574310337) | 14 | 2 | 9 | 28853 | 34 | ||||
| 66001 | 190565 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 1748 Alameda St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/03/2017 12:00:00 AM | 3 | Width 3ft | 6011489.99866 | 2107952.31705 | 37.7686828380703 | -122.403553794194 | (37.7686828380703, -122.403553794194) | 8 | 2 | 8 | 28853 | 20 | ||
| 66084 | 225990 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 2 Pearl St | 2 | : | Tree | Private 2 | 7 | Width 2ft | 6005601.08836 | 2108893.10222 | 37.7709353079426 | -122.42399000814 | (37.7709353079426, -122.42399000814) | 8 | 2 | 5 | 28853 | 19 | |||
| 66262 | 226018 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 56 Julian Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6006377.79954 | 2107591.96659 | 37.7674065193079 | -122.421210931263 | (37.7674065193079, -122.421210931263) | 8 | 4 | 7 | 28853 | 19 | |||
| 66905 | 7412 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 1085 Folsom St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 10 | 3x3 | 6010447.7014 | 2110998.9241 | 37.7769898413182 | -122.40737384335 | (37.7769898413182, -122.40737384335) | 14 | 2 | 9 | 28853 | 34 | |||
| 67103 | 253756 | Planning Code 138.1 required 2 | Ginkgo biloba :: Maidenhair Tree 22 | 41x Division St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/03/2017 12:00:00 AM | 3 | 5x5 | 6011517 | 2108140 | 37.7691996810398 | -122.403473604048 | (37.7691996810398, -122.403473604048) | 8 | 2 | 8 | 28853 | 20 | ||
| 67392 | 39076 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 2280X Alameda St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/18/1998 12:00:00 AM | Permit Number 40778 | 6010277.76687759 | 2108009.04739866 | 37.7687708195348 | -122.40775082962 | (37.7687708195348, -122.40775082962) | 8 | 4 | 8 | 28853 | 19 | |||
| 68025 | 190543 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 685 Townsend St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 4ft | 6011920.29143 | 2109276.52939 | 37.7723428503686 | -122.40215854729 | (37.7723428503686, -122.40215854729) | 14 | 2 | 9 | 28853 | 34 | |||
| 68338 | 7408 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 1070X Folsom St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 45 | 3X3 | 6010493.6316 | 2111129.8248 | 37.7773518347 | -122.407224185568 | (37.7773518347, -122.407224185568) | 14 | 2 | 9 | 28853 | 34 | |||
| 70703 | 121301 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 98x Elgin Park | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6005790 | 2108524 | 37.7699325053292 | -122.423310314383 | (37.7699325053292, -122.423310314383) | 8 | 2 | 5 | 28853 | 19 | ||||
| 71383 | 46477 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 195 Erie St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/10/2017 12:00:00 AM | 3 | Permit Number 779295 | 6006760.77877473 | 2108157.52189336 | 37.7689809837181 | -122.419926393368 | (37.7689809837181, -122.419926393368) | 8 | 4 | 7 | 28853 | 19 | ||
| 71488 | 190612 | Planning Code 138.1 required 2 | Ginkgo biloba :: Maidenhair Tree 22 | 9 Washburn St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/07/2018 12:00:00 AM | 3 | Width 3ft | Permit Number 775218 | 6008236.46776 | 2110619.04505 | 37.7758227734432 | -122.414996312823 | (37.7758227734432, -122.414996312823) | 8 | 2 | 9 | 28853 | 34 | |
| 72028 | 192443 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 12 McLea Ct | 1 | : | Tree | Private 2 | 3 | Width 3ft | 6009970.15581 | 2109159.47449 | 37.7719124015539 | -122.408896016247 | (37.7719124015539, -122.408896016247) | 14 | 2 | 9 | 28853 | 34 | |||
| 72940 | 190542 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 685 Townsend St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 4ft | 6011959.94229 | 2109234.09501 | 37.7722285483283 | -122.402018406821 | (37.7722285483283, -122.402018406821) | 14 | 2 | 9 | 28853 | 34 | |||
| 73801 | 51307 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 455 09th St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/13/2004 12:00:00 AM | Permit Number 47674 | 6009883.81375688 | 2109165.06157558 | 37.7719229056173 | -122.409195075279 | (37.7719229056173, -122.409195075279) | 14 | 2 | 9 | 28853 | 34 | |||
| 73880 | 226028 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 1377 Minna St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6006994.23363 | 2107486.47226 | 37.7671515893999 | -122.419071282214 | (37.7671515893999, -122.419071282214) | 8 | 4 | 7 | 28853 | 19 | |||
| 74701 | 226106 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 263 Guerrero St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6005507.0448 | 2107517.63368 | 37.7671532909287 | -122.424217468275 | (37.7671532909287, -122.424217468275) | 8 | 4 | 5 | 28853 | 19 | |||
| 75683 | 44240 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 317 Harriet St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/30/2001 12:00:00 AM | Permit Number 43677 | 6011781.7513621 | 2110406.95147967 | 37.7754389967998 | -122.402717284978 | (37.7754389967998, -122.402717284978) | 14 | 2 | 9 | 28853 | 34 | |||
| 76795 | 92524 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 275 10th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/07/2009 12:00:00 AM | 3x3 | Permit Number 52874 | 6008743 | 2109634 | 37.7731465224788 | -122.413174412357 | (37.7731465224788, -122.413174412357) | 8 | 2 | 9 | 28853 | 34 | ||
| 78449 | 225988 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 51 Elgin Park | 1 | : | Tree | Private 2 | 3 | Width 3ft | 6005833.50158 | 2108775.5715 | 37.7706257154391 | -122.423177727884 | (37.7706257154391, -122.423177727884) | 8 | 2 | 5 | 28853 | 19 | |||
| 78756 | 226101 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 279 Guerrero St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6005514.12752 | 2107414.4674 | 37.7668704208475 | -122.424185632279 | (37.7668704208475, -122.424185632279) | 8 | 4 | 5 | 28853 | 19 | |||
| 80193 | 48383 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 350& 17th ST Rhode Island St | 14 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/22/2002 12:00:00 AM | 5 | Permit Number 45774 | 6011710.50026 | 2106657.48632 | 37.7651398392626 | -122.402700021013 | (37.7651398392626, -122.402700021013) | 8 | 3 | 8 | 28853 | 20 | ||
| 80256 | 192488 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 301 Kansas St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 4ft | 6011491.35221 | 2106563.87779 | 37.7648705732492 | -122.40345141895 | (37.7648705732492, -122.40345141895) | 8 | 3 | 8 | 28853 | 20 | |||
| 80760 | 225987 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 79 Elgin Park | 1 | : | Tree | Private 2 | 8 | Width 3ft | 6005841.38866 | 2108630.33046 | 37.7702273634261 | -122.423140120925 | (37.7702273634261, -122.423140120925) | 8 | 2 | 5 | 28853 | 19 | |||
| 83232 | 226035 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 1498 Stevenson St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6006320.31244 | 2107962.37646 | 37.7684203358695 | -122.421436080129 | (37.7684203358695, -122.421436080129) | 8 | 4 | 7 | 28853 | 19 | |||
| 83670 | 24353 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 183 Duboce Ave | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 05/24/1995 12:00:00 AM | 8 | 3X3 | 6005571.85249 | 2108429.46983 | 37.7696606340674 | -122.424058159682 | (37.7696606340674, -122.424058159682) | 8 | 4 | 5 | 28853 | 19 | ||
| 84865 | 200876 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 1699 16th St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 0ft | 6011623.4638 | 2106960.7311 | 37.7659676212991 | -122.403022391787 | (37.7659676212991, -122.403022391787) | 8 | 3 | 8 | 28853 | 20 | |||
| 85031 | 226099 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 287 Guerrero St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6005516.73003 | 2107361.98665 | 37.7667264681653 | -122.424172897856 | (37.7667264681653, -122.424172897856) | 8 | 4 | 5 | 28853 | 19 | |||
| 85804 | 24367 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 128 Duboce Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 05/25/1995 12:00:00 AM | 3 | 3X3 | 6005866.15692 | 2108517.99575 | 37.7699203168954 | -122.423046461931 | (37.7699203168954, -122.423046461931) | 8 | 4 | 5 | 28853 | 19 | ||
| 85990 | 226034 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 1498 Stevenson St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6006320.36168 | 2107977.65149 | 37.7684622802495 | -122.421436994744 | (37.7684622802495, -122.421436994744) | 8 | 4 | 7 | 28853 | 19 | |||
| 87112 | 91317 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 450 Rhode Island St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/06/2009 12:00:00 AM | 3x3 | Permit Number 52049 | 6011745 | 2106547 | 37.7648383947947 | -122.40257292402 | (37.7648383947947, -122.40257292402) | 8 | 3 | 8 | 28853 | 20 | ||
| 88046 | 24375 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 157 Duboce Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 05/24/1995 12:00:00 AM | 3 | 3X3 | 6005685.52651 | 2108441.07828 | 37.76969892539 | -122.423665789951 | (37.76969892539, -122.423665789951) | 8 | 4 | 5 | 28853 | 19 | ||
| 88361 | 201864 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 1026 Folsom St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 0ft | 6010749.8037 | 2111375.3509 | 37.778040325586 | -122.406355302524 | (37.778040325586, -122.406355302524) | 14 | 2 | 9 | 28853 | 34 | |||
| 88836 | 200877 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 1699 16th St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 0ft | 6011650.0936 | 2106961.6822 | 37.7659717198345 | -122.402930351127 | (37.7659717198345, -122.402930351127) | 8 | 3 | 8 | 28853 | 20 | |||
| 90667 | 108721 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 375 Rhode Island St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/02/2015 12:00:00 AM | 3 | 3x3 | Permit Number 773094 | 6011766.2386 | 2106696.76782 | 37.7652508093012 | -122.402509996945 | (37.7652508093012, -122.402509996945) | 8 | 3 | 8 | 28853 | 20 |
| 91265 | 7382 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 1000X Folsom St | 6 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 60 | 3X3 | 6010814.6984 | 2111439.6909 | 37.7782206182135 | -122.406135341461 | (37.7782206182135, -122.406135341461) | 14 | 2 | 9 | 28853 | 34 | |||
| 92121 | 10597 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 385X 07th St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 10 | 3X3 | 6010728.50062 | 2110559.72736 | 37.7757996213793 | -122.406371513674 | (37.7757996213793, -122.406371513674) | 14 | 2 | 9 | 28853 | 34 | |||
| 92685 | 51305 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 87 McLea Ct | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/13/2004 12:00:00 AM | 3 | Permit Number 47673 | 6010054.38986 | 2109210.40638 | 37.7720569666911 | -122.408608236801 | (37.7720569666911, -122.408608236801) | 14 | 2 | 9 | 28853 | 34 | ||
| 92925 | 110520 | Undocumented 4 | Ginkgo biloba :: Maidenhair Tree 22 | 99x JULIAN AVE | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | 3x3 | 6006400 | 2107588 | 37.7673968795345 | -122.421133861104 | (37.7673968795345, -122.421133861104) | 8 | 4 | 7 | 28853 | 19 | |||
| 94481 | 48369 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 350& 17th ST Rhode Island St | 31 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/22/2002 12:00:00 AM | Permit Number 45774 | 6011708.83412888 | 2106755.94348957 | 37.7654100874921 | -122.402712708416 | (37.7654100874921, -122.402712708416) | 8 | 3 | 8 | 28853 | 20 | |||
| 95007 | 190539 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 592 Townsend St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 4ft | 6012127.13679 | 2109194.97892 | 37.7721304745846 | -122.401437313484 | (37.7721304745846, -122.401437313484) | 14 | 2 | 9 | 28853 | 34 | |||
| 95930 | 226110 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 229 Guerrero St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6005500.61051 | 2107652.31542 | 37.7675227315286 | -122.424249303359 | (37.7675227315286, -122.424249303359) | 8 | 4 | 5 | 28853 | 19 | |||
| 96461 | 48367 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 350& 17th ST Rhode Island St | 24 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/22/2002 12:00:00 AM | Permit Number 45774 | 6011708.83412888 | 2106755.94348957 | 37.7654100874921 | -122.402712708416 | (37.7654100874921, -122.402712708416) | 8 | 3 | 8 | 28853 | 20 | |||
| 96624 | 226000 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 30 Albion St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 6005770.42513 | 2107080.8717 | 37.7659689143646 | -122.423275423023 | (37.7659689143646, -122.423275423023) | 8 | 4 | 5 | 28853 | 19 | |||
| 96949 | 48391 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 350& 17th ST Rhode Island St | 21 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/22/2002 12:00:00 AM | Permit Number 45774 | 6011708.83412888 | 2106755.94348957 | 37.7654100874921 | -122.402712708416 | (37.7654100874921, -122.402712708416) | 8 | 3 | 8 | 28853 | 20 | |||
| 97349 | 44238 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 317 Harriet St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/30/2001 12:00:00 AM | Permit Number 43677 | 6011781.7513621 | 2110406.95147967 | 37.7754389967998 | -122.402717284978 | (37.7754389967998, -122.402717284978) | 14 | 2 | 9 | 28853 | 34 | |||
| 97633 | 190392 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 2200 Alameda St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 2ft | 6010440.20646 | 2107888.29011 | 37.7684483398498 | -122.407180447037 | (37.7684483398498, -122.407180447037) | 8 | 4 | 8 | 28853 | 19 | |||
| 99648 | 19371 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 390X 06th St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X4 | 6011348.29286 | 2111104.97037 | 37.7773313845055 | -122.404265868127 | (37.7773313845055, -122.404265868127) | 14 | 2 | 9 | 28853 | 34 | |||
| 100035 | 48368 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 350& 17th ST Rhode Island St | 30 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/22/2002 12:00:00 AM | Permit Number 45774 | 6011708.83412888 | 2106755.94348957 | 37.7654100874921 | -122.402712708416 | (37.7654100874921, -122.402712708416) | 8 | 3 | 8 | 28853 | 20 | |||
| 100111 | 24354 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 171 Duboce Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 01/21/2000 12:00:00 AM | 3 | 3X3 | 6005631.29748 | 2108432.71018 | 37.7696728873349 | -122.423852771601 | (37.7696728873349, -122.423852771601) | 8 | 4 | 5 | 28853 | 19 | ||
| 100454 | 192494 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 301 Kansas St | 14 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 4ft | 6011476.96207 | 2106788.73124 | 37.7654871664103 | -122.403517011923 | (37.7654871664103, -122.403517011923) | 8 | 3 | 8 | 28853 | 20 | |||
| 101518 | 190616 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 54 Dore St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6008946.65256 | 2109733.89099 | 37.7734322306479 | -122.412477011428 | (37.7734322306479, -122.412477011428) | 8 | 2 | 9 | 28853 | 34 | |||
| 102220 | 121300 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 98x Elgin Park | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6005790 | 2108524 | 37.7699325053292 | -122.423310314383 | (37.7699325053292, -122.423310314383) | 8 | 2 | 5 | 28853 | 19 | ||||
| 104390 | 190562 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 1748 Alameda St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/03/2017 12:00:00 AM | 3 | Width 3ft | 6011586.29241 | 2107955.63677 | 37.7686973315464 | -122.403220953295 | (37.7686973315464, -122.403220953295) | 8 | 2 | 8 | 28853 | 20 | ||
| 105076 | 192487 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 1900 17th St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 4ft | 6011535.97114 | 2106538.13265 | 37.7648023749638 | -122.403295281363 | (37.7648023749638, -122.403295281363) | 8 | 3 | 8 | 28853 | 20 | |||
| 105846 | 226033 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 42 Woodward St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6006472.4918 | 2108256.82362 | 37.769237396919 | -122.42093061256 | (37.769237396919, -122.42093061256) | 8 | 4 | 7 | 28853 | 19 | |||
| 106165 | 200955 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 1346 Folsom St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 0ft | 6009059.0912 | 2109763.9778 | 37.7735211513317 | -122.412090195341 | (37.7735211513317, -122.412090195341) | 8 | 2 | 9 | 28853 | 34 | |||
| 106190 | 226029 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 1377 Minna St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6006994.42264 | 2107495.68837 | 37.7671769053112 | -122.419071282226 | (37.7671769053112, -122.419071282226) | 8 | 4 | 7 | 28853 | 19 | |||
| 106374 | 192495 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 301 Kansas St | 15 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 4ft | 6011476.27694 | 2106815.84038 | 37.7655615637291 | -122.403521289087 | (37.7655615637291, -122.403521289087) | 8 | 3 | 8 | 28853 | 20 | |||
| 106784 | 228346 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 68 McCoppin St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 4ft | 6006197.13194 | 2109167.38164 | 37.7717220465789 | -122.421947761107 | (37.7717220465789, -122.421947761107) | 8 | 2 | 9 | 28853 | 19 | |||
| 107529 | 226017 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 56 Julian Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6006377.88219 | 2107605.31211 | 37.7674431676034 | -122.421211593149 | (37.7674431676034, -122.421211593149) | 8 | 4 | 7 | 28853 | 19 | |||
| 107608 | 19374 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 390X 06th St | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6011348.29286 | 2111104.97037 | 37.7773313845055 | -122.404265868127 | (37.7773313845055, -122.404265868127) | 14 | 2 | 9 | 28853 | 34 | |||
| 107987 | 31086 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 30 Pearl St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/21/1995 12:00:00 AM | 10 | Permit Number 34822 | 6005604.87213 | 2108833.38623 | 37.7707715558012 | -122.423972672804 | (37.7707715558012, -122.423972672804) | 8 | 2 | 5 | 28853 | 19 | |
| 109291 | 92525 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 275 10th St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/07/2009 12:00:00 AM | 3x3 | Permit Number 52874 | 6008743 | 2109634 | 37.7731465224788 | -122.413174412357 | (37.7731465224788, -122.413174412357) | 8 | 2 | 9 | 28853 | 34 | ||
| 109993 | 7393 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 1058 Folsom St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 60 | 3X3 | 6010566.1424 | 2111194.703 | 37.7775340329276 | -122.406977919834 | (37.7775340329276, -122.406977919834) | 14 | 2 | 9 | 28853 | 34 | |||
| 110501 | 91311 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 450 Rhode Island St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/06/2009 12:00:00 AM | 3x3 | Permit Number 52049 | 6011745 | 2106547 | 37.7648383947947 | -122.40257292402 | (37.7648383947947, -122.40257292402) | 8 | 3 | 8 | 28853 | 20 | ||
| 110707 | 226107 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 263 Guerrero St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6005505.96462 | 2107536.72016 | 37.767205636857 | -122.424222562048 | (37.767205636857, -122.424222562048) | 8 | 4 | 5 | 28853 | 19 | |||
| 112218 | 7387 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 1034 Folsom St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 45 | 3X3 | 6010706.5406 | 2111333.1971 | 37.7779221608577 | -122.406501994649 | (37.7779221608577, -122.406501994649) | 14 | 2 | 9 | 28853 | 34 | |||
| 114600 | 24370 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 170 Duboce Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/14/2007 12:00:00 AM | 3 | 3X3 | 6005596.02318 | 2108503.96371 | 37.7698665410346 | -122.423979852088 | (37.7698665410346, -122.423979852088) | 8 | 4 | 5 | 28853 | 19 | ||
| 114812 | 91315 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 450 Rhode Island St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/06/2009 12:00:00 AM | 3x3 | Permit Number 52049 | 6011745 | 2106547 | 37.7648383947947 | -122.40257292402 | (37.7648383947947, -122.40257292402) | 8 | 3 | 8 | 28853 | 20 | ||
| 117123 | 190541 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 592 Townsend St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 4ft | 6012097.95698 | 2109168.59031 | 37.7720563893144 | -122.401536394489 | (37.7720563893144, -122.401536394489) | 14 | 2 | 9 | 28853 | 34 | |||
| 117230 | 30603 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 146 11th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/30/1995 12:00:00 AM | Permit Number 34569 | 6007781.17491897 | 2109877.16754304 | 37.7737601591827 | -122.416518727592 | (37.7737601591827, -122.416518727592) | 8 | 2 | 9 | 28853 | 19 | ||
| 118225 | 200958 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 1346 Folsom St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 0ft | 6009020.339 | 2109727.2439 | 37.7734181142652 | -122.412221648656 | (37.7734181142652, -122.412221648656) | 8 | 2 | 9 | 28853 | 34 | |||
| 118268 | 226100 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 285 Guerrero St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6005514.81708 | 2107394.28878 | 37.7668150541029 | -122.424181811966 | (37.7668150541029, -122.424181811966) | 8 | 4 | 5 | 28853 | 19 | |||
| 118394 | 48374 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 350& 17th ST Rhode Island St | 22 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/22/2002 12:00:00 AM | Permit Number 45774 | 6011708.83412888 | 2106755.94348957 | 37.7654100874921 | -122.402712708416 | (37.7654100874921, -122.402712708416) | 8 | 3 | 8 | 28853 | 20 | |||
| 118472 | 34987 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 1000 Harrison St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 65 | Permit Number 41601 | 6011225.35237 | 2111221.47074 | 37.7776443970062 | -122.404699365001 | (37.7776443970062, -122.404699365001) | 14 | 2 | 9 | 28853 | 34 | |||
| 119354 | 190610 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 759 Clementina St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 2ft | 6009238.30573 | 2110180.11694 | 37.7746738256641 | -122.411499669594 | (37.7746738256641, -122.411499669594) | 8 | 2 | 9 | 28853 | 34 | |||
| 120174 | 51308 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 455 09th St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/13/2004 12:00:00 AM | 1 | Permit Number 47674 | 6009891.95854 | 2109175.78087 | 37.7719527946077 | -122.409167658287 | (37.7719527946077, -122.409167658287) | 14 | 2 | 9 | 28853 | 34 | ||
| 120384 | 48386 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 350& 17th ST Rhode Island St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/22/2002 12:00:00 AM | 7 | Permit Number 45774 | 6011697.3791 | 2106883.22371 | 37.765758930766 | -122.402761281003 | (37.765758930766, -122.402761281003) | 8 | 3 | 8 | 28853 | 20 | ||
| 121370 | 225984 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 370 14th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6006289.5916 | 2107897.21552 | 37.7682396872461 | -122.421537712521 | (37.7682396872461, -122.421537712521) | 8 | 4 | 7 | 28853 | 19 | |||
| 125095 | 226023 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 56 Julian Ave | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6006384.16307 | 2107500.88522 | 37.7671567901847 | -122.421182452401 | (37.7671567901847, -122.421182452401) | 8 | 4 | 7 | 28853 | 19 | |||
| 126459 | 226036 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 1498 Stevenson St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6006319.78863 | 2107949.74452 | 37.7683856220291 | -122.421436994741 | (37.7683856220291, -122.421436994741) | 8 | 4 | 7 | 28853 | 19 | |||
| 128425 | 48388 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 350& 17th ST Rhode Island St | 18 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/22/2002 12:00:00 AM | Permit Number 45774 | 6011708.83412888 | 2106755.94348957 | 37.7654100874921 | -122.402712708416 | (37.7654100874921, -122.402712708416) | 8 | 3 | 8 | 28853 | 20 | |||
| 129073 | 48385 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 350& 17th ST Rhode Island St | 16 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/22/2002 12:00:00 AM | 5 | Permit Number 45774 | 6011713.25267 | 2106604.51831 | 37.7649945546827 | -122.402686775779 | (37.7649945546827, -122.402686775779) | 8 | 3 | 8 | 28853 | 20 | ||
| 129625 | 201855 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 1085 Folsom St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 0ft | 6010458.0253 | 2111009.8989 | 37.7770205533795 | -122.407338903494 | (37.7770205533795, -122.407338903494) | 14 | 2 | 9 | 28853 | 34 |
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) );