trees
254 rows where qSpecies_id = 78 sorted by DBH
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
5519 | 251279 | DPW Maintained 1 | Quercus suber :: Cork Oak 78 | 1200x Hudson Ave | 8 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | Private | 3x3 | 6017356 | 2095183 | 37.733946845802 | -122.382375019073 | (37.733946845802, -122.382375019073) | 10 | 3 | 8 | 58 | 1 | |||
11056 | 111333 | Undocumented 4 | Quercus suber :: Cork Oak 78 | 698x ILLINOIS ST | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6015875 | 2105932 | 37.7633794456224 | -122.388245263499 | (37.7633794456224, -122.388245263499) | 14 | 3 | 8 | 28856 | 29 | ||||
16757 | 111332 | Undocumented 4 | Quercus suber :: Cork Oak 78 | 698x ILLINOIS ST | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6015875 | 2105932 | 37.7633794456224 | -122.388245263499 | (37.7633794456224, -122.388245263499) | 14 | 3 | 8 | 28856 | 29 | ||||
34139 | 111331 | Undocumented 4 | Quercus suber :: Cork Oak 78 | 698x ILLINOIS ST | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6015875 | 2105932 | 37.7633794456224 | -122.388245263499 | (37.7633794456224, -122.388245263499) | 14 | 3 | 8 | 28856 | 29 | ||||
38538 | 119910 | DPW Maintained 1 | Quercus suber :: Cork Oak 78 | 1500X La Salle Ave | 15 | Median : Cutout | Tree | DPW 1 | 12x31 | 6015992.6911276 | 2095862.2429535 | 37.735736511316 | -122.38713579848 | (37.735736511316, -122.38713579848) | 10 | 3 | 8 | 58 | 1 | ||||
47021 | 111329 | Undocumented 4 | Quercus suber :: Cork Oak 78 | 698x ILLINOIS ST | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6015875 | 2105932 | 37.7633794456224 | -122.388245263499 | (37.7633794456224, -122.388245263499) | 14 | 3 | 8 | 28856 | 29 | ||||
63631 | 111325 | Undocumented 4 | Quercus suber :: Cork Oak 78 | 698x ILLINOIS ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6015875 | 2105932 | 37.7633794456224 | -122.388245263499 | (37.7633794456224, -122.388245263499) | 14 | 3 | 8 | 28856 | 29 | ||||
69479 | 111326 | Undocumented 4 | Quercus suber :: Cork Oak 78 | 698x ILLINOIS ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6015875 | 2105932 | 37.7633794456224 | -122.388245263499 | (37.7633794456224, -122.388245263499) | 14 | 3 | 8 | 28856 | 29 | ||||
87605 | 111327 | Undocumented 4 | Quercus suber :: Cork Oak 78 | 698x ILLINOIS ST | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6015875 | 2105932 | 37.7633794456224 | -122.388245263499 | (37.7633794456224, -122.388245263499) | 14 | 3 | 8 | 28856 | 29 | ||||
103279 | 113196 | DPW Maintained 1 | Quercus suber :: Cork Oak 78 | 4090X 20th St | 1 | Median : Yard | Tree | DPW 1 | 6003325.96697 | 2104184.75857 | 37.7578786248615 | -122.431523525971 | (37.7578786248615, -122.431523525971) | 2 | 4 | 5 | 28862 | 3 | |||||
106469 | 111328 | Undocumented 4 | Quercus suber :: Cork Oak 78 | 698x ILLINOIS ST | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6015875 | 2105932 | 37.7633794456224 | -122.388245263499 | (37.7633794456224, -122.388245263499) | 14 | 3 | 8 | 28856 | 29 | ||||
118523 | 251277 | DPW Maintained 1 | Quercus suber :: Cork Oak 78 | 1200x Hudson Ave | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | Private | 10/26/2011 12:00:00 AM | 3x3 | 6017356 | 2095183 | 37.733946845802 | -122.382375019073 | (37.733946845802, -122.382375019073) | 10 | 3 | 8 | 58 | 1 | ||
135367 | 251278 | DPW Maintained 1 | Quercus suber :: Cork Oak 78 | 1200x Hudson Ave | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | Private | 01/27/2016 09:31:00 AM | 3x3 | 6017356 | 2095183 | 37.733946845802 | -122.382375019073 | (37.733946845802, -122.382375019073) | 10 | 3 | 8 | 58 | 1 | ||
139403 | 100171 | Significant Tree 6 | Quercus suber :: Cork Oak 78 | 109 Edgewood Ave | 1 | Front Yard : Yard | Tree | Private 2 | 5996563.8 | 2106359.1 | 37.763463224844 | -122.455066914463 | (37.763463224844, -122.455066914463) | 15 | 5 | 11 | 29492 | 12 | |||||
169584 | 111330 | Undocumented 4 | Quercus suber :: Cork Oak 78 | 698x ILLINOIS ST | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6015875 | 2105932 | 37.7633794456224 | -122.388245263499 | (37.7633794456224, -122.388245263499) | 14 | 3 | 8 | 28856 | 29 | ||||
247 | 240348 | DPW Maintained 1 | Quercus suber :: Cork Oak 78 | 1201 San Jose Ave | 26 | Front Yard : Yard | Tree | Private 2 | 1 | 6004340.86769 | 2095971.00866 | 37.7353830362869 | -122.427428442788 | (37.7353830362869, -122.427428442788) | 2 | 7 | 5 | 28861 | 2 | ||||
13228 | 197239 | DPW Maintained 1 | Quercus suber :: Cork Oak 78 | 830 Rhode Island St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 1 | 4x4 | Permit Number 785334 | 6011827.26305 | 2104492.53285 | 37.7592018783746 | -122.40214394589 | (37.7592018783746, -122.40214394589) | 10 | 3 | 8 | 28856 | 29 | ||
27937 | 240347 | DPW Maintained 1 | Quercus suber :: Cork Oak 78 | 1201 San Jose Ave | 16 | Front Yard : Yard | Tree | Private 2 | 1 | 6004297.07476 | 2095945.05367 | 37.7353092927844 | -122.427578002737 | (37.7353092927844, -122.427578002737) | 2 | 7 | 5 | 28861 | 2 | ||||
71515 | 197261 | DPW Maintained 1 | Quercus suber :: Cork Oak 78 | 1322 Hudson Ave | 41 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6017380.57172 | 2095099.80246 | 37.7337197590624 | -122.382284280115 | (37.7337197590624, -122.382284280115) | 10 | 3 | 8 | 58 | 1 | |||
77492 | 197255 | DPW Maintained 1 | Quercus suber :: Cork Oak 78 | 1320 Hudson Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6018070.99696 | 2094637.60558 | 37.7324887679223 | -122.379865147852 | (37.7324887679223, -122.379865147852) | 10 | 3 | 8 | 58 | 1 | |||
131442 | 197258 | DPW Maintained 1 | Quercus suber :: Cork Oak 78 | 1322 Hudson Ave | 27 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6017525.05376 | 2094913.62104 | 37.7332165209287 | -122.381771813133 | (37.7332165209287, -122.381771813133) | 10 | 3 | 8 | 58 | 1 | |||
161102 | 240346 | DPW Maintained 1 | Quercus suber :: Cork Oak 78 | 1201 San Jose Ave | 14 | Front Yard : Yard | Tree | Private 2 | 1 | 6004285.4248 | 2095936.19817 | 37.7352843186184 | -122.427617650241 | (37.7352843186184, -122.427617650241) | 2 | 7 | 5 | 28861 | 2 | ||||
36362 | 197234 | DPW Maintained 1 | Quercus suber :: Cork Oak 78 | 1201 Illinois St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 6016171.82655 | 2103275.37534 | 37.7561013622073 | -122.387033327344 | (37.7561013622073, -122.387033327344) | 10 | 3 | 8 | 28856 | 29 | |||
67441 | 136291 | DPW Maintained 1 | Quercus suber :: Cork Oak 78 | 401 Van Ness Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 4ft | 6006783.12153 | 2111963.42533 | 37.779432341874 | -122.420119247825 | (37.779432341874, -122.420119247825) | 7 | 9 | 9 | 28852 | 36 | |||
70732 | 201670 | DPW Maintained 1 | Quercus suber :: Cork Oak 78 | 401 08th St | 6 | Front Yard : Yard | Tree | Private 2 | 10 | 6010207.48998 | 2109776.17317 | 37.7736190045563 | -122.408118556848 | (37.7736190045563, -122.408118556848) | 14 | 2 | 9 | 28853 | 34 | ||||
81829 | 49974 | Permitted Site 7 | Quercus suber :: Cork Oak 78 | 138 Laidley St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/18/2003 12:00:00 AM | 10 | 3x6 | Permit Number 46725 | 6003736.17026094 | 2097556.1914573 | 37.739701367535 | -122.429632126542 | (37.739701367535, -122.429632126542) | 2 | 7 | 5 | 63 | 7 |
154737 | 179363 | DPW Maintained 1 | Quercus suber :: Cork Oak 78 | 2300 San Bruno Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 6010218.26631 | 2095644.80145 | 37.7348180057356 | -122.407085003796 | (37.7348180057356, -122.407085003796) | 10 | 3 | 7 | 309 | 28 | |||
167697 | 27569 | Permitted Site 7 | Quercus suber :: Cork Oak 78 | 1299X Illinois St | 20 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 03/07/2006 12:00:00 AM | 10 | 3X3 | 6016181.753398 | 2103053.032112 | 37.7554914042846 | -122.386983490089 | (37.7554914042846, -122.386983490089) | 10 | 3 | 8 | 28856 | 29 | ||
45458 | 136290 | DPW Maintained 1 | Quercus suber :: Cork Oak 78 | 401 Van Ness Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 4ft | 6006768.37866 | 2112062.50938 | 37.7797035719992 | -122.420177283766 | (37.7797035719992, -122.420177283766) | 7 | 9 | 9 | 28852 | 36 | |||
56405 | 201668 | DPW Maintained 1 | Quercus suber :: Cork Oak 78 | 401 08th St | 4 | Front Yard : Yard | Tree | Private 2 | 11 | 6010243.64351 | 2109736.80769 | 37.7735129403066 | -122.407990719097 | (37.7735129403066, -122.407990719097) | 14 | 2 | 9 | 28853 | 34 | ||||
110571 | 240362 | DPW Maintained 1 | Quercus suber :: Cork Oak 78 | 138 Laidley St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 6003721.38231 | 2097581.21775 | 37.7397692466514 | -122.429685041427 | (37.7397692466514, -122.429685041427) | 2 | 7 | 5 | 63 | 7 | |||
111813 | 249489 | DPW Maintained 1 | Quercus suber :: Cork Oak 78 | 1500x Van Ness Ave | 3 | Median : Yard | Tree | DPW 1 | 11 | 6006246.93776 | 2115807.86331 | 37.7899579981201 | -122.422247349544 | (37.7899579981201, -122.422247349544) | 13 | 9 | 1 | 28858 | 21 | ||||
186305 | 136293 | DPW Maintained 1 | Quercus suber :: Cork Oak 78 | 1500x Van Ness Ave | 5 | Median : Yard | Tree | DPW 1 | 11 | 6006248.16207 | 2115803.32411 | 37.7899456036636 | -122.422242790899 | (37.7899456036636, -122.422242790899) | 13 | 9 | 1 | 28858 | 21 | ||||
3206 | 83039 | DPW Maintained 1 | Quercus suber :: Cork Oak 78 | 100X Cargo Way | 13 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 12 | 6018611.72965 | 2097767.00037 | 37.7411112833697 | -122.378212851336 | (37.7411112833697, -122.378212851336) | 10 | 3 | 8 | 58 | 1 | ||||
12987 | 27593 | DPW Maintained 1 | Quercus suber :: Cork Oak 78 | 2200X San Bruno Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 06/21/2001 12:00:00 AM | 12 | 3X3 | 6010149.0566544 | 2095763.2891254 | 37.7351394742744 | -122.407332636882 | (37.7351394742744, -122.407332636882) | 10 | 7 | 7 | 309 | 28 | ||
20000 | 15008 | Permitted Site 7 | Quercus suber :: Cork Oak 78 | 600X Mendell St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/25/2008 12:00:00 AM | 12 | 3x3 | 6016372.25512 | 2097272.64218 | 37.7396301943656 | -122.385921767044 | (37.7396301943656, -122.385921767044) | 10 | 3 | 8 | 58 | 1 | ||
36718 | 14879 | DPW Maintained 1 | Quercus suber :: Cork Oak 78 | 50 Mendell St | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3x3 | 6017057.00036 | 2098638.4724 | 37.7434183582727 | -122.383649254902 | (37.7434183582727, -122.383649254902) | 10 | 3 | 8 | 58 | 1 | |||
51588 | 14901 | DPW Maintained 1 | Quercus suber :: Cork Oak 78 | 175 Mendell St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/25/2008 12:00:00 AM | 12 | 3x3 | 6017044.13522 | 2098333.33165 | 37.7425797926155 | -122.383672499702 | (37.7425797926155, -122.383672499702) | 10 | 3 | 8 | 58 | 1 | ||
60358 | 179368 | DPW Maintained 1 | Quercus suber :: Cork Oak 78 | 2302 San Bruno Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 6010304.52848 | 2095452.39798 | 37.7342945337677 | -122.406773208834 | (37.7342945337677, -122.406773208834) | 10 | 3 | 7 | 309 | 28 | |||
70692 | 240357 | DPW Maintained 1 | Quercus suber :: Cork Oak 78 | 671 Church St | 20 | Front Yard : Yard | Tree | Private 2 | 12 | Width 3ft | 6004316.61445 | 2104979.98621 | 37.7601182299832 | -122.428154122837 | (37.7601182299832, -122.428154122837) | 2 | 4 | 5 | 28862 | 3 | |||
129947 | 240359 | DPW Maintained 1 | Quercus suber :: Cork Oak 78 | 671 Church St | 24 | Front Yard : Yard | Tree | Private 2 | 12 | Width 3ft | 6004303.32084 | 2105026.7227 | 37.7602458051206 | -122.428203429952 | (37.7602458051206, -122.428203429952) | 2 | 4 | 5 | 28862 | 3 | |||
144179 | 249478 | DPW Maintained 1 | Quercus suber :: Cork Oak 78 | 1300x Van Ness Ave | 2 | Median : Yard | Tree | DPW 1 | 12 | 6006350.91475 | 2115079.54882 | 37.7879640914292 | -122.421835842261 | (37.7879640914292, -122.421835842261) | 13 | 9 | 1 | 28858 | 21 | ||||
171090 | 249490 | DPW Maintained 1 | Quercus suber :: Cork Oak 78 | 1500x Van Ness Ave | 4 | Median : Yard | Tree | DPW 1 | 12 | 6006241.6595 | 2115852.26392 | 37.7900796134287 | -122.422268767791 | (37.7900796134287, -122.422268767791) | 13 | 9 | 1 | 28858 | 21 | ||||
30660 | 240354 | DPW Maintained 1 | Quercus suber :: Cork Oak 78 | 671 Church St | 17 | Front Yard : Yard | Tree | Private 2 | 13 | Width 3ft | 6004324.4915 | 2104963.90622 | 37.7600745238281 | -122.428125733918 | (37.7600745238281, -122.428125733918) | 2 | 4 | 5 | 28862 | 3 | |||
33129 | 240361 | DPW Maintained 1 | Quercus suber :: Cork Oak 78 | 138 Laidley St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 3ft | 6003708.02517 | 2097591.62928 | 37.7397970779748 | -122.429731967151 | (37.7397970779748, -122.429731967151) | 2 | 7 | 5 | 63 | 7 | |||
91055 | 249487 | DPW Maintained 1 | Quercus suber :: Cork Oak 78 | 1500x Van Ness Ave | 1 | Median : Yard | Tree | DPW 1 | 13 | 6006262.64335 | 2115713.01946 | 37.7896984663527 | -122.422186268479 | (37.7896984663527, -122.422186268479) | 13 | 9 | 1 | 28858 | 21 | ||||
1119 | 113031 | DPW Maintained 1 | Quercus suber :: Cork Oak 78 | 251 06th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | 14 | 3x3 | 5993971.49407 | 2113867.66105 | 37.7839306754778 | -122.464578040665 | (37.7839306754778, -122.464578040665) | 11 | 6 | 2 | 54 | 11 | |||
52600 | 179364 | DPW Maintained 1 | Quercus suber :: Cork Oak 78 | 2300 San Bruno Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 3ft | 6010224.85869 | 2095626.21613 | 37.7347673433273 | -122.407060901965 | (37.7347673433273, -122.407060901965) | 10 | 3 | 7 | 309 | 28 | |||
92011 | 179362 | DPW Maintained 1 | Quercus suber :: Cork Oak 78 | 2300 San Bruno Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 3ft | 6010207.20881 | 2095669.3235 | 37.7348847192535 | -122.407124961546 | (37.7348847192535, -122.407124961546) | 10 | 3 | 7 | 309 | 28 | |||
92608 | 136294 | DPW Maintained 1 | Quercus suber :: Cork Oak 78 | 1500x Van Ness Ave | 6 | Median : Yard | Tree | DPW 1 | 14 | 6006242.09436 | 2115852.50489 | 37.7900802996014 | -122.422267280337 | (37.7900802996014, -122.422267280337) | 13 | 9 | 1 | 28858 | 21 | ||||
164558 | 249473 | DPW Maintained 1 | Quercus suber :: Cork Oak 78 | 1100x Van Ness Ave | 1 | Median : Yard | Tree | DPW 1 | 14 | 6006432.64407 | 2114489.3949 | 37.7863482830936 | -122.421511143829 | (37.7863482830936, -122.421511143829) | 13 | 9 | 11 | 28858 | 41 | ||||
166337 | 240360 | DPW Maintained 1 | Quercus suber :: Cork Oak 78 | 138 Laidley St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 3ft | 6003696.80727 | 2097599.26117 | 37.7398173981643 | -122.429771298113 | (37.7398173981643, -122.429771298113) | 2 | 7 | 5 | 63 | 7 | |||
60368 | 27594 | DPW Maintained 1 | Quercus suber :: Cork Oak 78 | 2200X San Bruno Ave | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 06/21/2001 12:00:00 AM | 16 | 3X3 | 6010149.05665 | 2095763.28912 | 37.7351394742594 | -122.407332636897 | (37.7351394742594, -122.407332636897) | 10 | 7 | 7 | 309 | 28 | ||
97214 | 136295 | DPW Maintained 1 | Quercus suber :: Cork Oak 78 | 2600x Van Ness Ave | 4 | Median : Yard | Tree | DPW 1 | 16 | Width 8ft | 6005728.53037 | 2119520.31629 | 37.8001222024312 | -122.424305148569 | (37.8001222024312, -122.424305148569) | 13 | 9 | 1 | 28858 | 32 | |||
179134 | 249476 | DPW Maintained 1 | Quercus suber :: Cork Oak 78 | 1200x Van Ness Ave | 3 | Median : Yard | Tree | DPW 1 | 16 | 6006383.25331 | 2114827.68427 | 37.7872743572577 | -122.421706060208 | (37.7872743572577, -122.421706060208) | 13 | 9 | 1 | 28858 | 21 | ||||
69653 | 14961 | DPW Maintained 1 | Quercus suber :: Cork Oak 78 | 355 Mendell St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3X3 | 6016837.91572 | 2097829.62207 | 37.7411853074635 | -122.384350479174 | (37.7411853074635, -122.384350479174) | 10 | 3 | 8 | 58 | 1 | |||
77159 | 240356 | DPW Maintained 1 | Quercus suber :: Cork Oak 78 | 671 Church St | 19 | Front Yard : Yard | Tree | Private 2 | 18 | Width 3ft | 6004321.88535 | 2104984.17972 | 37.760130042589 | -122.428136192158 | (37.760130042589, -122.428136192158) | 2 | 4 | 5 | 28862 | 3 | |||
159580 | 14882 | DPW Maintained 1 | Quercus suber :: Cork Oak 78 | 50 Mendell St | 8 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3x3 | 6017027.26925 | 2098565.83494 | 37.7432172671691 | -122.383747002247 | (37.7432172671691, -122.383747002247) | 10 | 3 | 8 | 58 | 1 | |||
185478 | 240352 | DPW Maintained 1 | Quercus suber :: Cork Oak 78 | 671 Church St | 9 | Front Yard : Yard | Tree | Private 2 | 18 | Width 3ft | 6004316.09652 | 2104917.27177 | 37.7599460017266 | -122.428151444657 | (37.7599460017266, -122.428151444657) | 2 | 4 | 5 | 28862 | 3 | |||
194279 | 249475 | DPW Maintained 1 | Quercus suber :: Cork Oak 78 | 1200x Van Ness Ave | 2 | Median : Yard | Tree | DPW 1 | 18 | Permit Number 787880 | 6006389.52859 | 2114780.40651 | 37.7871448980627 | -122.421680989782 | (37.7871448980627, -122.421680989782) | 13 | 9 | 1 | 28858 | 21 | |||
541 | 225969 | DPW Maintained 1 | Quercus suber :: Cork Oak 78 | 3599 24th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 19 | 3x3 | 6005840.01853 | 2101965.47506 | 37.7519271589233 | -122.422671163153 | (37.7519271589233, -122.422671163153) | 2 | 4 | 5 | 28859 | 19 | |||
29767 | 240355 | DPW Maintained 1 | Quercus suber :: Cork Oak 78 | 671 Church St | 18 | Front Yard : Yard | Tree | Private 2 | 19 | Width 3ft | 6004321.65497 | 2104972.99929 | 37.7600993307501 | -122.428136192147 | (37.7600993307501, -122.428136192147) | 2 | 4 | 5 | 28862 | 3 | |||
1983 | 197256 | DPW Maintained 1 | Quercus suber :: Cork Oak 78 | 1320 Hudson Ave | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6018044.32152 | 2094632.22344 | 37.732472518087 | -122.379956998329 | (37.732472518087, -122.379956998329) | 10 | 3 | 8 | 58 | 1 | |||
3911 | 197246 | DPW Maintained 1 | Quercus suber :: Cork Oak 78 | 1339 Hudson Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6017203.85974 | 2095339.70133 | 37.7343687116489 | -122.382911921471 | (37.7343687116489, -122.382911921471) | 10 | 3 | 8 | 58 | 1 | |||
49522 | 197273 | DPW Maintained 1 | Quercus suber :: Cork Oak 78 | 618 Mendell St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6016318.01168 | 2097190.59348 | 37.7394019032644 | -122.386103601013 | (37.7394019032644, -122.386103601013) | 10 | 3 | 8 | 58 | 1 | |||
75830 | 197264 | DPW Maintained 1 | Quercus suber :: Cork Oak 78 | 1322 Hudson Ave | 55 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6017243.9601 | 2095358.62855 | 37.734422897596 | -122.382774596779 | (37.734422897596, -122.382774596779) | 10 | 3 | 8 | 58 | 1 | |||
77807 | 13296 | DPW Maintained 1 | Quercus suber :: Cork Oak 78 | 2770 Lombard St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/08/2016 12:00:00 AM | 2 | 3X3 | Permit Number 770074 | 5999335.52143 | 2119120.50059 | 37.7986613518083 | -122.446398566642 | (37.7986613518083, -122.446398566642) | 13 | 9 | 1 | 57 | 17 | |
103538 | 197252 | DPW Maintained 1 | Quercus suber :: Cork Oak 78 | 1333 Hudson Ave | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6017782.90663 | 2094656.28102 | 37.7325241508658 | -122.38086245284 | (37.7325241508658, -122.38086245284) | 10 | 3 | 8 | 58 | 1 | |||
115457 | 197257 | DPW Maintained 1 | Quercus suber :: Cork Oak 78 | 1322 Hudson Ave | 26 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6017533.22144 | 2094905.154 | 37.733193723116 | -122.381742986272 | (37.733193723116, -122.381742986272) | 10 | 3 | 8 | 58 | 1 | |||
135622 | 14987 | DPW Maintained 1 | Quercus suber :: Cork Oak 78 | 500 Mendell St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/25/2008 12:00:00 AM | 2 | 3X3 | 6016458.61367 | 2097424.13027 | 37.7400509287079 | -122.38563372862 | (37.7400509287079, -122.38563372862) | 10 | 3 | 8 | 58 | 1 | ||
141560 | 197253 | DPW Maintained 1 | Quercus suber :: Cork Oak 78 | 1333 Hudson Ave | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6017800.41079 | 2094649.24699 | 37.7325058028811 | -122.380801447334 | (37.7325058028811, -122.380801447334) | 10 | 3 | 8 | 58 | 1 | |||
160117 | 197267 | DPW Maintained 1 | Quercus suber :: Cork Oak 78 | 822 Mendell St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 4ft | 6015954.57272 | 2096709.3738 | 37.7380604502387 | -122.387326664599 | (37.7380604502387, -122.387326664599) | 10 | 3 | 8 | 58 | 1 | |||
191501 | 197262 | DPW Maintained 1 | Quercus suber :: Cork Oak 78 | 1322 Hudson Ave | 46 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6017335.88738 | 2095181.6845 | 37.7339421227254 | -122.382444463752 | (37.7339421227254, -122.382444463752) | 10 | 3 | 8 | 58 | 1 | |||
95650 | 240351 | DPW Maintained 1 | Quercus suber :: Cork Oak 78 | 4090 20th St | 1 | : Yard | Tree | Private 2 | 22 | Width 3ft | 6003153.88022 | 2104182.56452 | 37.7578628454134 | -122.432118516979 | (37.7578628454134, -122.432118516979) | 2 | 4 | 5 | 28862 | 3 | |||
147785 | 197260 | DPW Maintained 1 | Quercus suber :: Cork Oak 78 | 1322 Hudson Ave | 40 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 23 | Width 3ft | 6017393.35703 | 2095090.62772 | 37.7336952732179 | -122.382239439017 | (37.7336952732179, -122.382239439017) | 10 | 3 | 8 | 58 | 1 | |||
38964 | 29684 | DPW Maintained 1 | Quercus suber :: Cork Oak 78 | 2000X Van Ness Ave | 2 | Median : Cutout | Tree | DPW 1 | 24 | 6006028.67336 | 2117355.72849 | 37.7941957348865 | -122.423112593587 | (37.7941957348865, -122.423112593587) | 13 | 9 | 10 | 28858 | 32 | ||||
68597 | 23583 | DPW Maintained 1 | Quercus suber :: Cork Oak 78 | 3100X Van Ness Ave | 6 | Median : Cutout | Tree | DPW 1 | 24 | 9 | 6005493.5455 | 2121226.72691 | 37.8047942964921 | -122.425239779807 | (37.8047942964921, -122.425239779807) | 5 | 1 | 1 | 28858 | 32 | |||
87659 | 21043 | DPW Maintained 1 | Quercus suber :: Cork Oak 78 | 2101X Sunset Blvd | 24 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 24 | 60 | 5984980.9284488 | 2100900.997098 | 37.7478054765444 | -122.494725332997 | (37.7478054765444, -122.494725332997) | 1 | 8 | 3 | 29491 | 35 | |||
77040 | 240349 | DPW Maintained 1 | Quercus suber :: Cork Oak 78 | 4736 17th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 27 | Width 4ft | 5998465.34509 | 2105692.76775 | 37.7617425503974 | -122.448442119502 | (37.7617425503974, -122.448442119502) | 15 | 5 | 11 | 29492 | 9 | |||
21876 | 240353 | DPW Maintained 1 | Quercus suber :: Cork Oak 78 | 671 Church St | 10 | Front Yard : Yard | Tree | Private 2 | 29 | Width 3ft | 6004318.10753 | 2104946.36781 | 37.7600260063222 | -122.428146563117 | (37.7600260063222, -122.428146563117) | 2 | 4 | 5 | 28862 | 3 | |||
565 | 170476 | DPW Maintained 1 | Quercus suber :: Cork Oak 78 | 46 Cayuga Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/09/2019 12:00:00 AM | 3 | Width 3ft | 6003788.04729 | 2094625.21712 | 37.7316565146416 | -122.429243816075 | (37.7316565146416, -122.429243816075) | 9 | 7 | 5 | 28861 | 25 | ||
1244 | 27591 | Permitted Site 7 | Quercus suber :: Cork Oak 78 | 2100X San Bruno Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Dept of Real Estate 7 | 06/21/2001 12:00:00 AM | 3 | 3x3 | 6009789.2811665 | 2096218.949435 | 37.7363704769246 | -122.408608649696 | (37.7363704769246, -122.408608649696) | 10 | 7 | 7 | 309 | 2 | ||
1709 | 224383 | Permitted Site 7 | Quercus suber :: Cork Oak 78 | 125 Julian Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/12/2019 12:00:00 AM | 3 | 5x5 | Permit Number 778492 | 6006444.85004 | 2107119.85754 | 37.7661139992865 | -122.420945489154 | (37.7661139992865, -122.420945489154) | 8 | 4 | 7 | 28853 | 19 | |
6880 | 24222 | Section 806 (d) 5 | Quercus suber :: Cork Oak 78 | 54 Whitney Young Cir | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/07/2010 12:00:00 AM | 3 | 4x4 | this is original dpw basin record. | 6017205.2608 | 2094992.48681 | 37.7334154068844 | -122.382882921904 | (37.7334154068844, -122.382882921904) | 10 | 3 | 8 | 58 | 1 | |
13469 | 260844 | DPW Maintained 1 | Quercus suber :: Cork Oak 78 | 651 06th Ave | 7 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 10/13/2018 12:00:00 AM | 3 | 5994076.91489 | 2111079.35374 | 37.7762808110216 | -122.464010852721 | (37.7762808110216, -122.464010852721) | 11 | 6 | 2 | 54 | 11 | ||
13584 | 170477 | DPW Maintained 1 | Quercus suber :: Cork Oak 78 | 17 Cayuga Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 5x5 | 6003910.26031 | 2094625.94541 | 37.7316654323041 | -122.428821353234 | (37.7316654323041, -122.428821353234) | 9 | 7 | 5 | 28861 | 25 | |||
13875 | 226227 | Permitted Site 7 | Quercus suber :: Cork Oak 78 | 2955 22nd St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/19/2020 12:00:00 AM | 3 | 6x6 | Permit Number 787786 | 6008507.27789 | 2103281.70589 | 37.755691354088 | -122.413540452526 | (37.755691354088, -122.413540452526) | 2 | 4 | 7 | 28859 | 19 | |
14449 | 260124 | Permitted Site 7 | Quercus suber :: Cork Oak 78 | 3195X Harrison St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/12/2019 12:00:00 AM | 3 | 3x3 | ||||||||||||
15199 | 778 | DPW Maintained 1 | Quercus suber :: Cork Oak 78 | 1800X 37th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/14/2006 12:00:00 AM | 3 | 3X3 | 5984768.5556 | 2102340.232 | 37.7517447878795 | -122.49556583439 | (37.7517447878795, -122.49556583439) | 1 | 8 | 3 | 56 | 35 | ||
15250 | 222585 | DPW Maintained 1 | Quercus suber :: Cork Oak 78 | 219 Diamond St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 5x5 | 6001765.70571 | 2104562.10445 | 37.7588261686132 | -122.436946567843 | (37.7588261686132, -122.436946567843) | 2 | 4 | 5 | 28862 | 3 | |||
17228 | 29643 | DPW Maintained 1 | Quercus suber :: Cork Oak 78 | 1500X La Salle Ave | 2 | Median : Cutout | Tree | DPW 1 | 04/07/2006 12:00:00 AM | 3 | 12x31 | 6015873.398 | 2095908.1157 | 37.7358558618741 | -122.387551444245 | (37.7358558618741, -122.387551444245) | 10 | 3 | 8 | 58 | 1 | ||
17414 | 197269 | DPW Maintained 1 | Quercus suber :: Cork Oak 78 | 623 Mendell St | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6016467.03521 | 2097318.03546 | 37.7397600798502 | -122.385597217932 | (37.7397600798502, -122.385597217932) | 10 | 3 | 8 | 58 | 1 | |||
18244 | 222586 | DPW Maintained 1 | Quercus suber :: Cork Oak 78 | 219 Diamond St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 5x5 | 6001763.88203 | 2104576.51068 | 37.7588656209757 | -122.436953906316 | (37.7588656209757, -122.436953906316) | 2 | 4 | 5 | 28862 | 3 | |||
19030 | 221366 | Planning Code 138.1 required 2 | Quercus suber :: Cork Oak 78 | 55 Homestead St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/30/2019 12:00:00 AM | 3 | 3x3 | Permit Number 778991 | 6000992.93047 | 2101385.53728 | 37.7500601303816 | -122.439391477336 | (37.7500601303816, -122.439391477336) | 2 | 4 | 5 | 28862 | 22 | |
19431 | 242096 | Planning Code 138.1 required 2 | Quercus suber :: Cork Oak 78 | 3721 21st St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/13/2019 12:00:00 AM | 3 | 4x4 | Permit Number 769571 | 6003563.92038 | 2103590.2718 | 37.756259789464 | -122.430658162741 | (37.756259789464, -122.430658162741) | 2 | 4 | 5 | 28862 | 22 | |
19437 | 3542 | DPW Maintained 1 | Quercus suber :: Cork Oak 78 | 201X Cargo Way | 52 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/01/2006 12:00:00 AM | 3 | 3X3 | 6018537.99972 | 2097717.76917 | 37.7409720404334 | -122.378464368331 | (37.7409720404334, -122.378464368331) | 10 | 3 | 8 | 58 | 1 | ||
19880 | 243367 | Permitted Site 7 | Quercus suber :: Cork Oak 78 | 3686 20th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/28/2018 12:00:00 AM | 3 | 3x3 | Permit Number 782225 | 6005735.65581 | 2104339.74223 | 37.7584404565742 | -122.423200817986 | (37.7584404565742, -122.423200817986) | 2 | 4 | 5 | 28859 | 19 | |
20136 | 219811 | Permitted Site 7 | Quercus suber :: Cork Oak 78 | 580 Douglass St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/11/2018 12:00:00 AM | 3 | 3x3 | Permit Number 782000 | 6001173.93519 | 2102998.57912 | 37.7544994546959 | -122.438881134568 | (37.7544994546959, -122.438881134568) | 2 | 4 | 5 | 28862 | 22 | |
20280 | 197247 | DPW Maintained 1 | Quercus suber :: Cork Oak 78 | 1339 Hudson Ave | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6017256.12018 | 2095247.45205 | 37.7341183008123 | -122.382724821107 | (37.7341183008123, -122.382724821107) | 10 | 3 | 8 | 58 | 1 | |||
23481 | 29669 | DPW Maintained 1 | Quercus suber :: Cork Oak 78 | 300X Van Ness Ave | 4 | Median : Cutout | Tree | DPW 1 | 3 | 6006874.5373229 | 2111536.5864673 | 37.778265495762 | -122.419772706207 | (37.778265495762, -122.419772706207) | 7 | 9 | 9 | 28852 | 36 |
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) );