trees

3,247 rows where qSpecies_id = 22 sorted by Supervisor Districts descending

✎ View and edit SQL

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)
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
55326 190516 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 22 649 Delancey St 12 Sidewalk: Curb side : Cutout Tree Private 2     12 Width 2ft   6015623.81724 2113280.84132 37.7835438201345 -122.389627318361 (37.7835438201345, -122.389627318361) 6 2 9 28856 6
56085 190527 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 22 21 Clarence Pl 5 Sidewalk: Curb side : Cutout Tree Private 2     1 Width 3ft   6014758.91418 2111853.16468 37.7795757477494 -122.392519675649 (37.7795757477494, -122.392519675649) 6 2 9 28856 6
56523 128980 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 22 199 McAllister St 8 Sidewalk: Curb side : Yard Tree Private 2     3 Width 4ft   6008492.62721 2112417.90621 37.7807764092316 -122.414237490093 (37.7807764092316, -122.414237490093) 7 10 9 28852 36
57101 190580 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 22 450 South St 6 Sidewalk: Curb side : Cutout Tree Private 2     1 Width 5ft   6015878.80294 2107959.2807 37.7689461298947 -122.388373613948 (37.7689461298947, -122.388373613948) 14 3 9 310 20
57349 128973 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 22 199 McAllister St 1 Sidewalk: Curb side : Yard Tree Private 2     3 Width 4ft   6008290.76156 2112391.46976 37.7806924800019 -122.414933971833 (37.7806924800019, -122.414933971833) 7 10 9 28852 36
57584 190602 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 22 355 Campus Way 3 Sidewalk: Curb side : Cutout Tree Private 2     2 Width 5ft   6015271.57365 2107530.7974 37.7677359418886 -122.390444054766 (37.7677359418886, -122.390444054766) 14 3 9 310 20
57611 190598 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 22 526 Nelson Rising Ln 8 Sidewalk: Curb side : Cutout Tree Private 2     3 Width 5ft   6015283.47377 2108274.89643 37.7697797348675 -122.390454891574 (37.7697797348675, -122.390454891574) 14 3 9 310 20
58034 190470 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 22 253 Fremont St 6 Sidewalk: Curb side : Cutout Tree Private 2     5 Width 4ft   6014153.83394 2115346.76483 37.7891347515116 -122.394857666546 (37.7891347515116, -122.394857666546) 6 2 9 28855 6
58742 46278 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 22 950 Harrison St 3 Sidewalk: Curb side : Cutout Tree Private 2   01/30/2002 12:00:00 AM 6   Permit Number 44559 6011747.79836 2111454.68409 37.7783139332727 -122.402908443379 (37.7783139332727, -122.402908443379) 14 2 9 28856 34
59494 190469 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 22 253 Fremont St 5 Sidewalk: Curb side : Cutout Tree Private 2     5 Width 4ft   6014167.98906 2115331.84971 37.7890945850967 -122.39480764626 (37.7890945850967, -122.39480764626) 6 2 9 28855 6
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
61512 190522 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 22 464 Harrison St 3 Sidewalk: Curb side : Cutout Tree Private 2     5 Width 3ft   6014410.04206 2114008.08639 37.7854732913004 -122.393877467569 (37.7854732913004, -122.393877467569) 6 2 9 28855 6
61650 35468 Permitted Site 7 Ginkgo biloba :: Maidenhair Tree 22 430 Polk St 7 Sidewalk: Curb side : Cutout Tree Private 2   03/17/1998 12:00:00 AM     Permit Number 38886 6007237.08907724 2112375.34283194 37.7805889355944 -122.418577996505 (37.7805889355944, -122.418577996505) 7 9 9 28852 36
61666 46277 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 22 950 Harrison St 2 Sidewalk: Curb side : Cutout Tree Private 2   01/30/2002 12:00:00 AM 5   Permit Number 44559 6011769.32018 2111474.71903 37.7783701463122 -122.402835400428 (37.7783701463122, -122.402835400428) 14 2 9 28856 34
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
63527 190608 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 22 355 Campus Way 9 Sidewalk: Curb side : Cutout Tree Private 2     2 Width 5ft   6015462.45363 2107535.18496 37.7677585760219 -122.389784125064 (37.7677585760219, -122.389784125064) 14 3 9 310 20
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
64206 93953 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 22 1 Hawthorne St 3 Sidewalk: Curb side : Cutout Tree Private 2   04/30/2010 12:00:00 AM 2 3x3 Permit Number 53397 6012948.58524 2114090.90941 37.7856193771856 -122.398939523867 (37.7856193771856, -122.398939523867) 6 2 9 28855 6
64896 190577 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 22 450 South St 3 Sidewalk: Curb side : Cutout Tree Private 2     3 Width 5ft   6016001.60495 2107966.29221 37.7689721859532 -122.387949335392 (37.7689721859532, -122.387949335392) 14 3 9 310 20
65581 190604 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 22 355 Campus Way 5 Sidewalk: Curb side : Cutout Tree Private 2     2 Width 5ft   6015329.13458 2107531.20473 37.7677402532417 -122.390244985313 (37.7677402532417, -122.390244985313) 14 3 9 310 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
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
67829 190480 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 22 260 Steuart St 2 Sidewalk: Curb side : Cutout Tree Private 2     8 Width 4ft   6015265.33201 2116174.73849 37.7914699158538 -122.391069885787 (37.7914699158538, -122.391069885787) 6 2 9 28855 6
67855 190603 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 22 355 Campus Way 4 Sidewalk: Curb side : Cutout Tree Private 2     2 Width 5ft   6015296.80797 2107531.07269 37.7677380975679 -122.390356790834 (37.7677380975679, -122.390356790834) 14 3 9 310 20
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
69570 49969 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 22 250 McAllister St 2 Sidewalk: Curb side : Cutout Tree Private 2   05/10/2016 12:00:00 AM 3   Permit Number 773269 6007906.30797 2112391.06257 37.7806697514383 -122.416263956709 (37.7806697514383, -122.416263956709) 7 10 9 28852 36
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
72002 190481 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 22 260 Steuart St 3 Sidewalk: Curb side : Cutout Tree Private 2     5 Width 4ft   6015282.68617 2116181.17714 37.7914885578894 -122.391010290399 (37.7914885578894, -122.391010290399) 6 2 9 28855 6
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
72070 39876 Permitted Site 7 Ginkgo biloba :: Maidenhair Tree 22 301 Bryant St 3 Sidewalk: Curb side : Cutout Tree Private 2 FUF 01/21/1999 12:00:00 AM     Permit Number 41173 6015620.67363669 2114221.43610992 37.786126305998 -122.389703911477 (37.786126305998, -122.389703911477) 6 2 9 28855 6
72195 93955 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 22 1 Hawthorne St 5 Sidewalk: Curb side : Cutout Tree Private 2   04/30/2010 12:00:00 AM 2 3x3 Permit Number 53397 6012923.46043 2114122.83633 37.7857056410428 -122.399028690747 (37.7857056410428, -122.399028690747) 6 2 9 28855 6
72872 44190 Permitted Site 7 Ginkgo biloba :: Maidenhair Tree 22 100 Harrison St 13 Sidewalk: Curb side : Cutout Tree Private 2   12/28/2000 12:00:00 AM     Permit Number 43651 6015694.21185643 2115218.20458409 37.7888672826794 -122.389519124295 (37.7888672826794, -122.389519124295) 6 2 9 28855 6
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
73011 190493 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 22 541 Delancey St 7 Sidewalk: Curb side : Cutout Tree Private 2     6 Width 6ft   6015305.91458 2113614.18637 37.784441477541 -122.390750451073 (37.784441477541, -122.390750451073) 6 2 9 28856 6
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
74785 190490 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 22 543 Delancey St 12 Sidewalk: Curb side : Cutout Tree Private 2     4 Width 6ft   6015415.34325 2113497.18941 37.7841263011177 -122.390363685055 (37.7841263011177, -122.390363685055) 6 2 9 28856 6
75086 256583 Undocumented 4 Ginkgo biloba :: Maidenhair Tree 22 2x Stillman St 10 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6014165 2112908 37.7824390851954 -122.394648183134 (37.7824390851954, -122.394648183134) 6 2 9 28856 6
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
75943 256585 Undocumented 4 Ginkgo biloba :: Maidenhair Tree 22 2x Stillman St 12 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6014165 2112908 37.7824390851954 -122.394648183134 (37.7824390851954, -122.394648183134) 6 2 9 28856 6
75979 190606 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 22 355 Campus Way 7 Sidewalk: Curb side : Cutout Tree Private 2     2 Width 5ft   6015393.80416 2107532.25368 37.76774672026 -122.390021372499 (37.76774672026, -122.390021372499) 14 3 9 310 20
76521 190471 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 22 253 Fremont St 7 Sidewalk: Curb side : Cutout Tree Private 2     4 Width 4ft   6014140.34067 2115359.80913 37.7891698178684 -122.394905265869 (37.7891698178684, -122.394905265869) 6 2 9 28855 6
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
77023 190578 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 22 450 South St 4 Sidewalk: Curb side : Cutout Tree Private 2     3 Width 5ft   6015978.37212 2107965.30085 37.7689681767714 -122.388029627781 (37.7689681767714, -122.388029627781) 14 3 9 310 20
77075 190491 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 22 541 Delancey St 5 Sidewalk: Curb side : Cutout Tree Private 2     9 Width 6ft   6015329.13045 2113592.35808 37.7843828300441 -122.390668605586 (37.7843828300441, -122.390668605586) 6 2 9 28856 6
77715 128955 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 22 136 McAllister St 1 Sidewalk: Curb side : Cutout Tree Private 2     3 Width 4ft   6008460.18328 2112464.97423 37.780903824287 -122.414353061058 (37.780903824287, -122.414353061058) 7 10 9 28852 36
77907 190597 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 22 526 Nelson Rising Ln 7 Sidewalk: Curb side : Cutout Tree Private 2     3 Width 5ft   6015311.55248 2108274.70714 37.7697807726996 -122.390357754025 (37.7697807726996, -122.390357754025) 14 3 9 310 20
78345 190460 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 22 5 Anthony St 3 Sidewalk: Curb side : Cutout Tree Private 2     3 Width 5ft   6012767.43065 2115195.29722 37.7886416721168 -122.399643839601 (37.7886416721168, -122.399643839601) 12 2 9 28855 6
78934 256592 Undocumented 4 Ginkgo biloba :: Maidenhair Tree 22 2x Stillman St 19 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6014165 2112908 37.7824390851954 -122.394648183134 (37.7824390851954, -122.394648183134) 6 2 9 28856 6
79499 256582 Undocumented 4 Ginkgo biloba :: Maidenhair Tree 22 2x Stillman St 9 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6014165 2112908 37.7824390851954 -122.394648183134 (37.7824390851954, -122.394648183134) 6 2 9 28856 6
79701 190590 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 22 1245 03rd St 5 Sidewalk: Curb side : Yard Tree Private 2     3 Width 5ft   6015578.74967 2109351.03033 37.7727509375275 -122.389508696885 (37.7727509375275, -122.389508696885) 14 3 9 310 20
82132 104102 Permitted Site 7 Ginkgo biloba :: Maidenhair Tree 22 55X Clarence Pl 5 Sidewalk: Curb side : Cutout Tree Private 2       2x3 Permit Number 768392 6014738.33428 2111855.52316 37.7795810807004 -122.392591035948 (37.7795810807004, -122.392591035948) 6 2 9 28856 6
82997 256595 Undocumented 4 Ginkgo biloba :: Maidenhair Tree 22 2x Stillman St 22 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6014165 2112908 37.7824390851954 -122.394648183134 (37.7824390851954, -122.394648183134) 6 2 9 28856 6
85050 198739 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 22 300 Main St 9 Sidewalk: Curb side : Yard Tree Private 2     0     6015183.09065 2115200.65141 37.7887907329425 -122.391286320207 (37.7887907329425, -122.391286320207) 6 2 9 28855 6
85276 44777 Permitted Site 7 Ginkgo biloba :: Maidenhair Tree 22 938 Harrison St 7 Sidewalk: Curb side : Cutout Tree Private 2   04/12/2001 12:00:00 AM     Permit Number 43877 6011792.18948294 2111489.0452941 37.7784107598375 -122.402757294311 (37.7784107598375, -122.402757294311) 14 2 9 28856 34
85529 192429 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 22 271 Clara St 1 : Tree Private 2     1 Width 3ft   6011461.32034 2111421.96775 37.7782081010676 -122.403897179615 (37.7782081010676, -122.403897179615) 14 2 9 28856 34
86034 256603 Undocumented 4 Ginkgo biloba :: Maidenhair Tree 22 2x Stillman St 30 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6014165 2112908 37.7824390851954 -122.394648183134 (37.7824390851954, -122.394648183134) 6 2 9 28856 6
87043 256584 Undocumented 4 Ginkgo biloba :: Maidenhair Tree 22 2x Stillman St 11 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6014165 2112908 37.7824390851954 -122.394648183134 (37.7824390851954, -122.394648183134) 6 2 9 28856 6
87378 46279 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 22 950 Harrison St 5 Sidewalk: Curb side : Cutout Tree Private 2   01/30/2002 12:00:00 AM 4   Permit Number 44559 6011712.63161 2111419.43384 37.7782151805114 -122.40302761884 (37.7782151805114, -122.40302761884) 14 2 9 28856 34
87806 190568 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 22 550 South St 3 Sidewalk: Curb side : Cutout Tree Private 2     5 Width 5ft   6016318.75266 2107983.43695 37.7690368265244 -122.386853527668 (37.7690368265244, -122.386853527668) 14 3 9 310 20
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
88684 30517 Permitted Site 7 Ginkgo biloba :: Maidenhair Tree 22 375 Eddy St 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/07/2000 12:00:00 AM     Permit Number 42914 6008641.14761203 2113482.39812883 37.7837075903462 -122.413799003426 (37.7837075903462, -122.413799003426) 7 10 9 28852 36
89152 128958 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 22 190 McAllister St 3 Sidewalk: Curb side : Cutout Tree Private 2     3 Width 4ft   6008273.27815 2112444.36454 37.780836733956 -122.414998200512 (37.780836733956, -122.414998200512) 7 10 9 28852 36
89794 256008 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 22 300 Main St 10 Sidewalk: Curb side : Yard Tree Private 2           6015252.9594 2115128.97629 37.7885978067978 -122.391039570534 (37.7885978067978, -122.391039570534) 6 2 9 28855 6
90302 50153 Permitted Site 7 Ginkgo biloba :: Maidenhair Tree 22 215 REVISED Fremont St 6 Sidewalk: Curb side : Cutout Tree Private 2   08/12/2003 12:00:00 AM     Permit Number 46870 6014159.85874387 2115328.34387959 37.7890845068427 -122.3948355307 (37.7890845068427, -122.3948355307) 6 2 9 28855 6
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
91440 50157 Permitted Site 7 Ginkgo biloba :: Maidenhair Tree 22 215 REVISED Fremont St 1 Sidewalk: Curb side : Cutout Tree Private 2   08/12/2003 12:00:00 AM     Permit Number 46870 6014159.85874387 2115328.34387959 37.7890845068427 -122.3948355307 (37.7890845068427, -122.3948355307) 6 2 9 28855 6
91593 190574 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 22 550 South St 9 Sidewalk: Curb side : Cutout Tree Private 2     6 Width 5ft   6016169.13913 2107975.39199 37.769006451918 -122.387370475084 (37.769006451918, -122.387370475084) 14 3 9 310 20
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
92243 190517 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 22 649 Delancey St 13 Sidewalk: Curb side : Cutout Tree Private 2     12 Width 2ft   6015620.20689 2113286.09542 37.7835580465152 -122.389640175967 (37.7835580465152, -122.389640175967) 6 2 9 28856 6
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
92804 190591 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 22 526 Nelson Rising Ln 1 Sidewalk: Curb side : Cutout Tree Private 2     3 Width 5ft   6015405.78137 2108280.36173 37.7698015254385 -122.390032211124 (37.7698015254385, -122.390032211124) 14 3 9 310 20
93319 190589 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 22 1245 03rd St 4 Sidewalk: Curb side : Yard Tree Private 2     3 Width 5ft   6015580.04197 2109334.21151 37.7727048284094 -122.389503051837 (37.7727048284094, -122.389503051837) 14 3 9 310 20
93900 190459 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 22 5 Anthony St 2 Sidewalk: Curb side : Cutout Tree Private 2     4 Width 5ft   6012789.14548 2115174.16236 37.7885848511652 -122.399567224573 (37.7885848511652, -122.399567224573) 12 2 9 28855 6
94248 256602 Undocumented 4 Ginkgo biloba :: Maidenhair Tree 22 2x Stillman St 29 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6014165 2112908 37.7824390851954 -122.394648183134 (37.7824390851954, -122.394648183134) 6 2 9 28856 6
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
95647 44199 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 22 100 Harrison St 2 Sidewalk: Curb side : Cutout Tree Private 2   02/20/2018 12:00:00 AM 3   Permit Number 43651 6015629.81658 2115174.24288 37.7887430032356 -122.389738853189 (37.7887430032356, -122.389738853189) 6 2 9 28855 6
96115 44775 Permitted Site 7 Ginkgo biloba :: Maidenhair Tree 22 938 Harrison St 5 Sidewalk: Curb side : Cutout Tree Private 2   04/12/2001 12:00:00 AM     Permit Number 43877 6011792.18948294 2111489.0452941 37.7784107598375 -122.402757294311 (37.7784107598375, -122.402757294311) 14 2 9 28856 34
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
97836 190477 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 22 30 Tehama St 6 Sidewalk: Curb side : Cutout Tree Private 2     1 Width 3ft   6013845.25263 2114876.39079 37.7878260508834 -122.395892352754 (37.7878260508834, -122.395892352754) 6 2 9 28855 6
98208 44770 Permitted Site 7 Ginkgo biloba :: Maidenhair Tree 22 938 Harrison St 9 Sidewalk: Curb side : Cutout Tree Private 2   04/12/2001 12:00:00 AM     Permit Number 43877 6011792.18948294 2111489.0452941 37.7784107598375 -122.402757294311 (37.7784107598375, -122.402757294311) 14 2 9 28856 34
98998 44774 Permitted Site 7 Ginkgo biloba :: Maidenhair Tree 22 938 Harrison St 4 Sidewalk: Curb side : Cutout Tree Private 2   04/12/2001 12:00:00 AM     Permit Number 43877 6011792.18948294 2111489.0452941 37.7784107598375 -122.402757294311 (37.7784107598375, -122.402757294311) 14 2 9 28856 34
99126 190573 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 22 550 South St 8 Sidewalk: Curb side : Cutout Tree Private 2     5 Width 5ft   6016194.38649 2107976.86529 37.7690118955188 -122.387283248044 (37.7690118955188, -122.387283248044) 14 3 9 310 20
99223 190576 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 22 450 South St 2 Sidewalk: Curb side : Cutout Tree Private 2     3 Width 5ft   6016023.93976 2107967.06556 37.7689755467242 -122.387872134002 (37.7689755467242, -122.387872134002) 14 3 9 310 20
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
99749 190583 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 22 448 South St 1 Sidewalk: Curb side : Cutout Tree Private 2     3 Width 5ft   6015780.1959 2107952.51143 37.7689220784184 -122.388714219602 (37.7689220784184, -122.388714219602) 14 3 9 310 20
99899 45303 Permitted Site 7 Ginkgo biloba :: Maidenhair Tree 22 400 Polk St 1 Sidewalk: Curb side : Cutout Tree Private 2   06/14/2001 12:00:00 AM     Permit Number 44141 6007253.57893325 2112265.23386383 37.7802875313124 -122.418513140067 (37.7802875313124, -122.418513140067) 7 9 9 28852 36
101475 190510 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 22 649 Delancey St 1 Sidewalk: Curb side : Cutout Tree Private 2     6 Width 2ft   6015824.26654 2113066.39708 37.7829661172445 -122.388918858534 (37.7829661172445, -122.388918858534) 6 2 9 28856 6
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
101853 190585 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 22 448 South St 3 Sidewalk: Curb side : Cutout Tree Private 2     2 Width 5ft   6015704.36743 2107948.44562 37.768906711711 -122.388976223597 (37.768906711711, -122.388976223597) 14 3 9 310 20
102111 104096 Permitted Site 7 Ginkgo biloba :: Maidenhair Tree 22 55X Clarence Pl 1 Sidewalk: Curb side : Cutout Tree Private 2       2x3 Permit Number 768392 6014738.33428 2111855.52316 37.7795810807004 -122.392591035948 (37.7795810807004, -122.392591035948) 6 2 9 28856 6
102297 190582 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 22 450 South St 8 Sidewalk: Curb side : Cutout Tree Private 2     3 Width 5ft   6015829.41164 2107957.60094 37.7689387806299 -122.38854433945 (37.7689387806299, -122.38854433945) 14 3 9 310 20
102898 128952 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 22 100 McAllister St 2 Sidewalk: Curb side : Cutout Tree Private 2     3 Width 4ft   6008545.08155 2112474.66764 37.7809352088189 -122.414060041244 (37.7809352088189, -122.414060041244) 7 10 9 28852 36
103647 44198 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 22 100 Harrison St 3 Sidewalk: Curb side : Cutout Tree Private 2   12/28/2000 12:00:00 AM 4   Permit Number 43651 6015613.21564 2115159.68111 37.7887020993715 -122.389795273027 (37.7887020993715, -122.389795273027) 6 2 9 28855 6
104324 50154 Permitted Site 7 Ginkgo biloba :: Maidenhair Tree 22 215 REVISED Fremont St 5 Sidewalk: Curb side : Cutout Tree Private 2   08/12/2003 12:00:00 AM     Permit Number 46870 6014159.85874387 2115328.34387959 37.7890845068427 -122.3948355307 (37.7890845068427, -122.3948355307) 6 2 9 28855 6
104329 190464 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 22 560 Mission St 4 Sidewalk: Curb side : Cutout Tree Private 2     4 Width 5ft   6012895.81714 2115160.20532 37.7885524737596 -122.399197174227 (37.7885524737596, -122.399197174227) 12 2 9 28855 6
104762 190523 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 22 21 Clarence Pl 1 Sidewalk: Curb side : Cutout Tree Private 2     1 Width 3ft   6014817.23751 2111793.6682 37.7794156225798 -122.392313746187 (37.7794156225798, -122.392313746187) 6 2 9 28856 6
104845 75258 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 22 288 Eddy St 3 Sidewalk: Curb side : Cutout Tree Rec/Park 5   04/23/2015 04:17:00 PM 3     6009102.38385 2113598.35596 37.7840518741506 -122.412211492867 (37.7840518741506, -122.412211492867) 14 10 9 28852 36
105014 256580 Undocumented 4 Ginkgo biloba :: Maidenhair Tree 22 2x Stillman St 7 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6014165 2112908 37.7824390851954 -122.394648183134 (37.7824390851954, -122.394648183134) 6 2 9 28856 6

Next page

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options: 

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)
);