Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, SiteOrder, qSiteInfo, PlantType, qCaretaker, qCareAssistant, DBH
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder ▲ | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 168416 | 168416 | 186800 | Undocumented 2 | :: 54 | 1200 Sunset Blvd | 78 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 0ft | 5984846.2035 | 2106925.1049 | 37.7643381205783 | -122.495635466651 | (37.7643381205783, -122.495635466651) | |||
| 51976 | 51976 | 181517 | Undocumented 2 | :: 54 | 1400 Sunset Blvd | 77 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 0ft | 5984871.9567 | 2105586.7319 | 37.7606648313705 | -122.49544767930401 | (37.7606648313705, -122.495447679304) | |||
| 70132 | 70132 | 186781 | Undocumented 2 | :: 54 | 1200 Sunset Blvd | 49 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 0ft | 5984857.4742 | 2106824.7830000003 | 37.764063324835796 | -122.49558908498399 | (37.7640633248358, -122.495589084984) | |||
| 169869 | 169869 | 186771 | Undocumented 2 | :: 54 | 1200 Sunset Blvd | 39 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 0ft | 5984865.2362 | 2106774.8154 | 37.7639265823683 | -122.495558553205 | (37.7639265823683, -122.495558553205) | |||
| 178220 | 178220 | 199651 | Undocumented 2 | :: 54 | 0 | 37 | : 4 | Tree 1 | Private 1 | 0 | Width 0ft | 6018297.01834 | 2097895.80454 | 37.7414476037323 | -122.37930996579901 | (37.7414476037323, -122.379309965799) | |||
| 72618 | 72618 | 199649 | Undocumented 2 | :: 54 | 1601 Evans Ave | 22 | : 4 | Tree 1 | Private 1 | 0 | Width 1ft | 6015107.35337 | 2098882.19142 | 37.7439796026678 | -122.390407721252 | (37.7439796026678, -122.390407721252) | |||
| 36431 | 36431 | 137758 | Undocumented 2 | :: 54 | 101 Saint Joseph's Ave | 19 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 6000707.9938 | 2112291.934 | 37.7799901751967 | -122.44115920153799 | (37.7799901751967, -122.441159201538) | |||
| 113797 | 113797 | 116339 | Undocumented 2 | :: 54 | 1400X Potrero Ave | 19 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 6010648.284969999 | 2101378.4314900003 | 37.7505853701643 | -122.40600205927099 | (37.7505853701643, -122.406002059271) | |||||
| 108927 | 108927 | 116338 | Undocumented 2 | :: 54 | 1400X Potrero Ave | 18 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 6010648.284969999 | 2101378.4314900003 | 37.7505853701643 | -122.40600205927099 | (37.7505853701643, -122.406002059271) | |||||
| 143572 | 143572 | 116337 | Undocumented 2 | :: 54 | 1400X Potrero Ave | 17 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 6010648.284969999 | 2101378.4314900003 | 37.7505853701643 | -122.40600205927099 | (37.7505853701643, -122.406002059271) | |||||
| 99135 | 99135 | 114630 | Undocumented 2 | :: 54 | 2400X Post St | 16 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6000387.7 | 2114050.6 | 37.7848007706075 | -122.442393531976 | (37.7848007706075, -122.442393531976) | |||||
| 144301 | 144301 | 116336 | Undocumented 2 | :: 54 | 1400X Potrero Ave | 16 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 6010648.284969999 | 2101378.4314900003 | 37.7505853701643 | -122.40600205927099 | (37.7505853701643, -122.406002059271) | |||||
| 169042 | 169042 | 141492 | Undocumented 2 | :: 54 | 2901 TURK BLVD | 16 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 5996949.0657 | 2111520.205 | 37.7776563807789 | -122.454107193938 | (37.7776563807789, -122.454107193938) | |||
| 96844 | 96844 | 114629 | Undocumented 2 | :: 54 | 2400X Post St | 15 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6000387.7 | 2114050.6 | 37.7848007706075 | -122.442393531976 | (37.7848007706075, -122.442393531976) | |||||
| 98178 | 98178 | 116335 | Undocumented 2 | :: 54 | 1400X Potrero Ave | 15 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 6010648.284969999 | 2101378.4314900003 | 37.7505853701643 | -122.40600205927099 | (37.7505853701643, -122.406002059271) | |||||
| 89960 | 89960 | 114628 | Undocumented 2 | :: 54 | 2400X Post St | 14 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6000387.7 | 2114050.6 | 37.7848007706075 | -122.442393531976 | (37.7848007706075, -122.442393531976) | |||||
| 107184 | 107184 | 116334 | Undocumented 2 | :: 54 | 1400X Potrero Ave | 14 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 6010648.284969999 | 2101378.4314900003 | 37.7505853701643 | -122.40600205927099 | (37.7505853701643, -122.406002059271) | |||||
| 2526 | 2526 | 141913 | Undocumented 2 | :: 54 | 900 MCALLISTER ST | 13 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 6004416.1749 | 2111910.2001 | 37.779152551854104 | -122.42830372330299 | (37.7791525518541, -122.428303723303) | |||
| 87576 | 87576 | 114627 | Undocumented 2 | :: 54 | 2400X Post St | 13 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6000387.7 | 2114050.6 | 37.7848007706075 | -122.442393531976 | (37.7848007706075, -122.442393531976) | |||||
| 94078 | 94078 | 116333 | Undocumented 2 | :: 54 | 1400X Potrero Ave | 13 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 6010648.284969999 | 2101378.4314900003 | 37.7505853701643 | -122.40600205927099 | (37.7505853701643, -122.406002059271) | |||||
| 173500 | 173500 | 183897 | Undocumented 2 | :: 54 | 1390 Quintara St | 13 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 0ft | 5989145.605 | 2101022.1677 | 37.7483810695929 | -122.480333121199 | (37.7483810695929, -122.480333121199) | |||
| 177826 | 177826 | 140999 | Undocumented 2 | :: 54 | 2425 GEARY BLVD | 13 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 6000127.896000001 | 2113280.4932 | 37.7826714447065 | -122.44323703523399 | (37.7826714447065, -122.443237035234) | |||
| 71724 | 71724 | 185834 | Undocumented 2 | :: 54 | 2099 34th Ave | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 5985700.3236 | 2100993.5674 | 37.7481017314756 | -122.492244550883 | (37.7481017314756, -122.492244550883) | |||
| 73962 | 73962 | 141419 | Undocumented 2 | :: 54 | 530 IVY ST | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 6004593.8117 | 2111048.5166 | 37.7767966306404 | -122.42762779625099 | (37.7767966306404, -122.427627796251) | |||
| 83855 | 83855 | 114626 | Undocumented 2 | :: 54 | 2400X Post St | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6000387.7 | 2114050.6 | 37.7848007706075 | -122.442393531976 | (37.7848007706075, -122.442393531976) | |||||
| 91482 | 91482 | 116332 | Undocumented 2 | :: 54 | 1400X Potrero Ave | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 6010648.284969999 | 2101378.4314900003 | 37.7505853701643 | -122.40600205927099 | (37.7505853701643, -122.406002059271) | |||||
| 166129 | 166129 | 183896 | Undocumented 2 | :: 54 | 1390 Quintara St | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 0ft | 5989127.4817 | 2101020.5917 | 37.7483756891409 | -122.48039567509501 | (37.7483756891409, -122.480395675095) | |||
| 37652 | 37652 | 141525 | Undocumented 2 | :: 54 | 200 STANYAN ST | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 5996673.9338 | 2111292.1171 | 37.7770143310958 | -122.455042477562 | (37.7770143310958, -122.455042477562) | |||
| 51927 | 51927 | 141418 | Undocumented 2 | :: 54 | 530 IVY ST | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 6004607.07 | 2111051.7308 | 37.776806205978 | -122.42758216085 | (37.776806205978, -122.42758216085) | |||
| 52002 | 52002 | 182469 | Undocumented 2 | :: 54 | 1599 30th Ave | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 5986816.8873 | 2104483.4967 | 37.757749341610705 | -122.488640040992 | (37.7577493416107, -122.488640040992) | |||
| 72583 | 72583 | 114625 | Undocumented 2 | :: 54 | 2400X Post St | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6000387.7 | 2114050.6 | 37.7848007706075 | -122.442393531976 | (37.7848007706075, -122.442393531976) | |||||
| 80868 | 80868 | 116284 | Undocumented 2 | :: 54 | 700X Greenwich St | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 6009521.9 | 2120182.3 | 37.8021533125646 | -122.41122536090799 | (37.8021533125646, -122.411225360908) | |||||
| 97038 | 97038 | 105091 | Significant Tree 6 | :: 54 | 344 Fulton St | 11 | Front Yard : Yard 7 | Tree 1 | Private 1 | 6006101.8 | 2111789.5 | 37.778916373563206 | -122.42246386857201 | (37.7789163735632, -122.422463868572) | |||||
| 121543 | 121543 | 116331 | Undocumented 2 | :: 54 | 1400X Potrero Ave | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 6010648.284969999 | 2101378.4314900003 | 37.7505853701643 | -122.40600205927099 | (37.7505853701643, -122.406002059271) | |||||
| 151138 | 151138 | 183895 | Undocumented 2 | :: 54 | 1390 Quintara St | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 0ft | 5989106.2065 | 2101019.8038 | 37.74837228939921 | -122.480469185732 | (37.7483722893992, -122.480469185732) | |||
| 156661 | 156661 | 137740 | Undocumented 2 | :: 54 | 101 Saint Joseph's Ave | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 6000679.5664 | 2112493.295 | 37.7805414418009 | -122.441271996241 | (37.7805414418009, -122.441271996241) | |||
| 181306 | 181306 | 185833 | Undocumented 2 | :: 54 | 2091 34th Ave | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 5985698.6694 | 2101072.9677 | 37.748319646443 | -122.49225611672199 | (37.748319646443, -122.492256116722) | |||
| 46800 | 46800 | 141745 | Undocumented 2 | :: 54 | 1595 GEARY BLVD | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 6004047.2174 | 2113886.8031 | 37.7845589275233 | -122.429721115021 | (37.7845589275233, -122.429721115021) | |||
| 60095 | 60095 | 137739 | Undocumented 2 | :: 54 | 101 Saint Joseph's Ave | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 6000676.859 | 2112512.2466 | 37.7805933238275 | -122.441282722586 | (37.7805933238275, -122.441282722586) | |||
| 63252 | 63252 | 183894 | Undocumented 2 | :: 54 | 1390 Quintara St | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 0ft | 5989083.3554 | 2101019.0158 | 37.7483687977509 | -122.480548145718 | (37.7483687977509, -122.480548145718) | |||
| 82769 | 82769 | 108801 | Undocumented 2 | :: 54 | 501-599 University St | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6008503.45306 | 2091469.8325200002 | 37.7232583218261 | -122.412718672961 | (37.7232583218261, -122.412718672961) | |||||
| 92470 | 92470 | 116283 | Undocumented 2 | :: 54 | 700X Greenwich St | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 6009521.9 | 2120182.3 | 37.8021533125646 | -122.41122536090799 | (37.8021533125646, -122.411225360908) | |||||
| 107067 | 107067 | 116330 | Undocumented 2 | :: 54 | 1400X Potrero Ave | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 6010648.284969999 | 2101378.4314900003 | 37.7505853701643 | -122.40600205927099 | (37.7505853701643, -122.406002059271) | |||||
| 109194 | 109194 | 108807 | Undocumented 2 | :: 54 | 401-499 University St | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6008323.152369999 | 2092121.01007 | 37.7250361958168 | -122.413387969207 | (37.7250361958168, -122.413387969207) | |||||
| 115978 | 115978 | 108771 | Undocumented 2 | :: 54 | 500X Lathrop Ave | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 6012750.2 | 2086624.6 | 37.7101917236901 | -122.397698699654 | (37.7101917236901, -122.397698699654) | ||||
| 116897 | 116897 | 108813 | Undocumented 2 | :: 54 | 301-399 University St | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6008160.407269999 | 2092653.74948 | 37.726489845684796 | -122.41398823310301 | (37.7264898456848, -122.413988233103) | |||||
| 121162 | 121162 | 105090 | Significant Tree 6 | :: 54 | 344 Fulton St | 10 | Front Yard : Yard 7 | Tree 1 | Private 1 | 6006101.8 | 2111789.5 | 37.778916373563206 | -122.42246386857201 | (37.7789163735632, -122.422463868572) | |||||
| 136199 | 136199 | 185844 | Undocumented 2 | :: 54 | 2000 35th Ave | 10 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 5985416.9086 | 2101532.2764 | 37.74956430714639 | -122.49326425755699 | (37.7495643071464, -122.493264257557) | |||
| 136289 | 136289 | 137589 | Undocumented 2 | :: 54 | 1150 PIERCE ST | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 6002346.2752 | 2112589.0782 | 37.780899240130296 | -122.435512922421 | (37.7808992401303, -122.435512922421) | |||
| 163263 | 163263 | 141945 | Undocumented 2 | :: 54 | 1101 GOLDEN GATE AVE | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 6004212.2215 | 2112170.9783 | 37.7798570416861 | -122.429027879664 | (37.7798570416861, -122.429027879664) | |||
| 28730 | 28730 | 140456 | Undocumented 2 | :: 54 | 1459 Eddy St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 6003479.0697 | 2112771.1641 | 37.7814634747388 | -122.431607035931 | (37.7814634747388, -122.431607035931) | |||
| 31028 | 31028 | 139809 | Undocumented 2 | :: 54 | 1101 GOUGH ST | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 6005660.0139 | 2112868.3262 | 37.7818536339515 | -122.424068925498 | (37.7818536339515, -122.424068925498) | |||
| 75169 | 75169 | 141944 | Undocumented 2 | :: 54 | 1101 GOLDEN GATE AVE | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 6004183.4678 | 2112169.0928 | 37.779850236925 | -122.429127216952 | (37.779850236925, -122.429127216952) | |||
| 86041 | 86041 | 105089 | Significant Tree 6 | :: 54 | 344 Fulton St | 9 | Front Yard : Yard 7 | Tree 1 | Private 1 | 6006101.8 | 2111789.5 | 37.778916373563206 | -122.42246386857201 | (37.7789163735632, -122.422463868572) | |||||
| 88387 | 88387 | 116329 | Undocumented 2 | :: 54 | 1400X Potrero Ave | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 6010648.284969999 | 2101378.4314900003 | 37.7505853701643 | -122.40600205927099 | (37.7505853701643, -122.406002059271) | |||||
| 98757 | 98757 | 116282 | Undocumented 2 | :: 54 | 700X Greenwich St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 6009521.9 | 2120182.3 | 37.8021533125646 | -122.41122536090799 | (37.8021533125646, -122.411225360908) | |||||
| 117492 | 117492 | 115069 | DPW Maintained 3 | :: 54 | 70 Coral Rd | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6012676.36761 | 2102522.24683 | 37.7538392609312 | -122.39906901845501 | (37.7538392609312, -122.399069018455) | |||||
| 134084 | 134084 | 246372 | Undocumented 2 | :: 54 | 1999 Mission St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 6006820.4847 | 2107009.8327 | 37.7658330635794 | -122.41963843327801 | (37.7658330635794, -122.419638433278) | |||
| 135485 | 135485 | 137588 | Undocumented 2 | :: 54 | 1150 PIERCE ST | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 6002345.2566 | 2112562.5967 | 37.7808264707559 | -122.435514551268 | (37.7808264707559, -122.435514551268) | |||
| 150931 | 150931 | 185843 | Undocumented 2 | :: 54 | 2000 35th Ave | 9 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 5985418.5628 | 2101473.2776 | 37.7494024092815 | -122.493254191383 | (37.7494024092815, -122.493254191383) | |||
| 152924 | 152924 | 141523 | Undocumented 2 | :: 54 | 200 STANYAN ST | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 5996684.3575 | 2111222.9913 | 37.7768251277487 | -122.455001422863 | (37.7768251277487, -122.455001422863) | |||
| 166203 | 166203 | 183906 | Undocumented 2 | :: 54 | 2101 22nd Ave | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 5989443.8513 | 2100449.3142 | 37.7468254913409 | -122.47925990315399 | (37.7468254913409, -122.479259903154) | |||
| 10106 | 10106 | 173853 | Permitted Site 1 | :: 54 | 450 Toland St | 8 | Sidewalk: Curb side : Cutout 1 | Landscaping 2 | Private 1 | 01/27/2017 12:00:00 AM | 3 | 26.75x4 | 6012768.71675 | 2099101.44192 | 37.74445161113729 | -122.39850962968201 | (37.7444516111373, -122.398509629682) | ||
| 37734 | 37734 | 137587 | Undocumented 2 | :: 54 | 1150 PIERCE ST | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 6002352.8955 | 2112542.7356 | 37.78077237103221 | -122.435486703411 | (37.7807723710322, -122.435486703411) | |||
| 42883 | 42883 | 185830 | Undocumented 2 | :: 54 | 2071 34th Ave | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 5985698.118 | 2101152.3680000002 | 37.7485376258716 | -122.49226386921801 | (37.7485376258716, -122.492263869218) | |||
| 45116 | 45116 | 185842 | Undocumented 2 | :: 54 | 2000 35th Ave | 8 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 5985421.3197 | 2101412.6246 | 37.7492360339251 | -122.493240190301 | (37.7492360339251, -122.493240190301) | |||
| 46705 | 46705 | 244976 | Undocumented 2 | :: 54 | 201 Rose St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 6005594.1388 | 2109777.4773 | 37.773363196496895 | -122.42407694938998 | (37.7733631964969, -122.42407694939) | |||
| 63962 | 63962 | 141522 | Undocumented 2 | :: 54 | 200 STANYAN ST | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 5996688.4722 | 2111189.7999 | 37.7767342289075 | -122.454984790063 | (37.7767342289075, -122.454984790063) | |||
| 69532 | 69532 | 184973 | Undocumented 2 | :: 54 | 2701 Sunset Blvd | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 5985060.7433 | 2096318.9125 | 37.7352289790934 | -122.494111677716 | (37.7352289790934, -122.494111677716) | |||
| 71149 | 71149 | 142745 | DPW Maintained 3 | :: 54 | 700x COLUMBUS AVE | 8 | Median : Cutout 11 | Tree 1 | DPW 2 | 0 | Width 0ft | 6009127.5357 | 2120116.4029 | 37.8019502507169 | -122.412585395041 | (37.8019502507169, -122.412585395041) | |||
| 79728 | 79728 | 108812 | Undocumented 2 | :: 54 | 301-399 University St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6008160.407269999 | 2092653.74948 | 37.726489845684796 | -122.41398823310301 | (37.7264898456848, -122.413988233103) | |||||
| 83119 | 83119 | 114623 | Undocumented 2 | :: 54 | 2400X Post St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6000387.7 | 2114050.6 | 37.7848007706075 | -122.442393531976 | (37.7848007706075, -122.442393531976) | |||||
| 87071 | 87071 | 115068 | DPW Maintained 3 | :: 54 | 70 Coral Rd | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6012676.36761 | 2102522.24683 | 37.7538392609312 | -122.39906901845501 | (37.7538392609312, -122.399069018455) | |||||
| 93124 | 93124 | 116328 | Undocumented 2 | :: 54 | 1400X Potrero Ave | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 6010648.284969999 | 2101378.4314900003 | 37.7505853701643 | -122.40600205927099 | (37.7505853701643, -122.406002059271) | |||||
| 110162 | 110162 | 108806 | Undocumented 2 | :: 54 | 401-499 University St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6008323.152369999 | 2092121.01007 | 37.7250361958168 | -122.413387969207 | (37.7250361958168, -122.413387969207) | |||||
| 116105 | 116105 | 116281 | Undocumented 2 | :: 54 | 700X Greenwich St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 6009521.9 | 2120182.3 | 37.8021533125646 | -122.41122536090799 | (37.8021533125646, -122.411225360908) | |||||
| 117730 | 117730 | 108800 | Undocumented 2 | :: 54 | 501-599 University St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6008503.45306 | 2091469.8325200002 | 37.7232583218261 | -122.412718672961 | (37.7232583218261, -122.412718672961) | |||||
| 141862 | 141862 | 105088 | Significant Tree 6 | :: 54 | 344 Fulton St | 8 | Front Yard : Yard 7 | Tree 1 | Private 1 | 6006101.8 | 2111789.5 | 37.778916373563206 | -122.42246386857201 | (37.7789163735632, -122.422463868572) | |||||
| 149988 | 149988 | 141161 | Undocumented 2 | :: 54 | 2007 Geary Blvd | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 6002005.8356 | 2113598.0542 | 37.7836502911761 | -122.43676291583598 | (37.7836502911761, -122.436762915836) | |||
| 161855 | 161855 | 142539 | Undocumented 2 | :: 54 | 2100 POWELL ST | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 6009429.9045 | 2121027.6379 | 37.80446924024871 | -122.411603472126 | (37.8044692402487, -122.411603472126) | |||
| 182050 | 182050 | 200501 | Undocumented 2 | :: 54 | 1550 Armstrong Ave | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 6014687.5837 | 2092287.487 | 37.7258485955534 | -122.39139827547399 | (37.7258485955534, -122.391398275474) | |||
| 10092 | 10092 | 173852 | Permitted Site 1 | :: 54 | 450 Toland St | 7 | Sidewalk: Curb side : Cutout 1 | Landscaping 2 | Private 1 | 01/27/2017 12:00:00 AM | 3 | 8.5x4 | 6012768.71675 | 2099101.44192 | 37.74445161113729 | -122.39850962968201 | (37.7444516111373, -122.398509629682) | ||
| 22811 | 22811 | 185829 | Undocumented 2 | :: 54 | 2061 34th Ave | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 5985695.3610000005 | 2101217.9835 | 37.7487176270346 | -122.49227823369301 | (37.7487176270346, -122.492278233693) | |||
| 28402 | 28402 | 137551 | Undocumented 2 | :: 54 | 1526 Steiner St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 6002668.0924 | 2113464.7267 | 37.7833218226195 | -122.434462226416 | (37.7833218226195, -122.434462226416) | |||
| 30940 | 30940 | 185841 | Undocumented 2 | :: 54 | 2000 35th Ave | 7 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 5985424.0767 | 2101308.9631 | 37.748951568943205 | -122.493223020907 | (37.7489515689432, -122.493223020907) | |||
| 40764 | 40764 | 186526 | Undocumented 2 | :: 54 | 1501 Sunset Blvd | 7 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 5984782.9201 | 2104548.9278 | 37.7578100967767 | -122.495679060793 | (37.7578100967767, -122.495679060793) | |||
| 61664 | 61664 | 245454 | Undocumented 2 | :: 54 | 2700 16th St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 6008487.3357 | 2106844.226 | 37.765472098116796 | -122.41386141193001 | (37.7654720981168, -122.41386141193) | |||
| 73809 | 73809 | 139018 | Undocumented 2 | :: 54 | 2569 SUTTER ST | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 6000314.1665 | 2114058.3378 | 37.784817825136706 | -122.44264848882601 | (37.7848178251367, -122.442648488826) | |||
| 74459 | 74459 | 137586 | Undocumented 2 | :: 54 | 1150 PIERCE ST | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 6002357.4789 | 2112504.0318 | 37.7806663604621 | -122.435468077701 | (37.7806663604621, -122.435468077701) | |||
| 97624 | 97624 | 114622 | Undocumented 2 | :: 54 | 2400X Post St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6000387.7 | 2114050.6 | 37.7848007706075 | -122.442393531976 | (37.7848007706075, -122.442393531976) | |||||
| 113187 | 113187 | 115067 | DPW Maintained 3 | :: 54 | 70 Coral Rd | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6012676.36761 | 2102522.24683 | 37.7538392609312 | -122.39906901845501 | (37.7538392609312, -122.399069018455) | |||||
| 113454 | 113454 | 108799 | Undocumented 2 | :: 54 | 501-599 University St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6008503.45306 | 2091469.8325200002 | 37.7232583218261 | -122.412718672961 | (37.7232583218261, -122.412718672961) | |||||
| 118898 | 118898 | 116327 | Undocumented 2 | :: 54 | 1400X Potrero Ave | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 6010648.284969999 | 2101378.4314900003 | 37.7505853701643 | -122.40600205927099 | (37.7505853701643, -122.406002059271) | |||||
| 120796 | 120796 | 105087 | Significant Tree 6 | :: 54 | 344 Fulton St | 7 | Front Yard : Yard 7 | Tree 1 | Private 1 | 6006101.8 | 2111789.5 | 37.778916373563206 | -122.42246386857201 | (37.7789163735632, -122.422463868572) | |||||
| 125482 | 125482 | 116947 | Undocumented 2 | :: 54 | 3676 23RD ST | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6005238.0 | 2102584.0 | 37.753591501312705 | -122.424797029407 | (37.7535915013127, -122.424797029407) | ||||
| 140188 | 140188 | 116280 | Undocumented 2 | :: 54 | 700X Greenwich St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 6009521.9 | 2120182.3 | 37.8021533125646 | -122.41122536090799 | (37.8021533125646, -122.411225360908) | |||||
| 168746 | 168746 | 142538 | Undocumented 2 | :: 54 | 2100 POWELL ST | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 6009433.1509 | 2121013.8406 | 37.8044315384071 | -122.41159126219999 | (37.8044315384071, -122.4115912622) | |||
| 172874 | 172874 | 139933 | Undocumented 2 | :: 54 | 800 GOUGH ST | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 6005708.0541 | 2112525.3709 | 37.7809146750444 | -122.42387833426001 | (37.7809146750444, -122.42387833426) | |||
| 179050 | 179050 | 186412 | Undocumented 2 | :: 54 | 1601 Sunset Blvd | 7 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 5984810.0324 | 2103749.2702 | 37.7556160465723 | -122.49552631838101 | (37.7556160465723, -122.495526318381) | |||
| 4723 | 4723 | 253676 | Permitted Site 1 | :: 54 | 2975 Van Ness Ave | 6 | Sidewalk: Property side : Cutout 5 | Landscaping 2 | Private 1 | 10/24/2017 12:00:00 AM | 3 | 3.2x3.75 | 6005536.30746 | 2120557.52588 | 37.8029592583559 | -122.42504415389 | (37.8029592583559, -122.42504415389) |
JSON shape: default, array, newline-delimited
CREATE TABLE "Street_Tree_List" (
"TreeID" INTEGER,
"qLegalStatus" INTEGER,
"qSpecies" INTEGER,
"qAddress" TEXT,
"SiteOrder" INTEGER,
"qSiteInfo" INTEGER,
"PlantType" INTEGER,
"qCaretaker" INTEGER,
"qCareAssistant" INTEGER,
"PlantDate" TEXT,
"DBH" INTEGER,
"PlotSize" TEXT,
"PermitNotes" TEXT,
"XCoord" REAL,
"YCoord" REAL,
"Latitude" REAL,
"Longitude" REAL,
"Location" TEXT
,
FOREIGN KEY ("PlantType") REFERENCES [PlantType](id),
FOREIGN KEY ("qCaretaker") REFERENCES [qCaretaker](id),
FOREIGN KEY ("qSpecies") REFERENCES [qSpecies](id),
FOREIGN KEY ("qSiteInfo") REFERENCES [qSiteInfo](id),
FOREIGN KEY ("qCareAssistant") REFERENCES [qCareAssistant](id),
FOREIGN KEY ("qLegalStatus") REFERENCES [qLegalStatus](id));
CREATE INDEX ["Street_Tree_List_PlantType"] ON [Street_Tree_List]("PlantType");
CREATE INDEX ["Street_Tree_List_qCaretaker"] ON [Street_Tree_List]("qCaretaker");
CREATE INDEX ["Street_Tree_List_qSpecies"] ON [Street_Tree_List]("qSpecies");
CREATE INDEX ["Street_Tree_List_qSiteInfo"] ON [Street_Tree_List]("qSiteInfo");
CREATE INDEX ["Street_Tree_List_qCareAssistant"] ON [Street_Tree_List]("qCareAssistant");
CREATE INDEX ["Street_Tree_List_qLegalStatus"] ON [Street_Tree_List]("qLegalStatus");