trees
74 rows where qSpecies_id = 168 sorted by TreeID descending
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
56391 | 99609 | Undocumented 4 | Aesculus californica :: California Buckeye 168 | 1 Entrada Ct | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 5992743 | 2092489 | 37.7251595224946 | -122.467273147781 | (37.7251595224946, -122.467273147781) | 9 | 8 | 4 | 59 | 40 | |||||
172767 | 98696 | Significant Tree 6 | Aesculus californica :: California Buckeye 168 | 191@Clarendon Forest Knolls Dr | 3 | Back Yard : Yard | Tree | Private 2 | 05/01/2012 12:00:00 AM | Permit Number 768674 | 5996330.9 | 2103059.9 | 37.7543910951738 | -122.455633951336 | (37.7543910951738, -122.455633951336) | 1 | 5 | 4 | 63 | 12 | |||
175269 | 98695 | Significant Tree 6 | Aesculus californica :: California Buckeye 168 | 191@Clarendon Forest Knolls Dr | 2 | Back Yard : Yard | Tree | Private 2 | 05/01/2012 12:00:00 AM | Permit Number 768674 | 5996330.9 | 2103059.9 | 37.7543910951738 | -122.455633951336 | (37.7543910951738, -122.455633951336) | 1 | 5 | 4 | 63 | 12 | |||
55746 | 98694 | Significant Tree 6 | Aesculus californica :: California Buckeye 168 | 191@Clarendon Forest Knolls Dr | 1 | Back Yard : Yard | Tree | Private 2 | 05/01/2012 12:00:00 AM | Permit Number 768674 | 5996330.9 | 2103059.9 | 37.7543910951738 | -122.455633951336 | (37.7543910951738, -122.455633951336) | 1 | 5 | 4 | 63 | 12 | |||
185499 | 94945 | Significant Tree 6 | Aesculus californica :: California Buckeye 168 | 1820X Palou Ave | : Cutout | Tree | Rec/Park 5 | FUF | 04/04/2009 12:00:00 AM | 6013714.4 | 2096294.3 | 37.7367964240349 | -122.395043047708 | (37.7367964240349, -122.395043047708) | 10 | 3 | 8 | 58 | 1 | ||||
163804 | 81469 | Permitted Site 7 | Aesculus californica :: California Buckeye 168 | 1552-1554 Dolores St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/09/2008 12:00:00 AM | 3x3 | Permit Number 50069 | 6005235.89227316 | 2099314.73756784 | 37.744614740726 | -122.424571781682 | (37.744614740726, -122.424571781682) | 2 | 7 | 5 | 63 | 22 | ||
19368 | 70406 | DPW Maintained 1 | Aesculus californica :: California Buckeye 168 | 230 Oxford St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 5 | 6006490.11078 | 2092833.88988 | 37.7268905196644 | -122.419775167193 | (37.7268905196644, -122.419775167193) | 9 | 7 | 7 | 309 | 5 | |||
18830 | 70083 | DPW Maintained 1 | Aesculus californica :: California Buckeye 168 | 224 Oxford St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11 | 6006483.02411 | 2092857.70117 | 37.7269555010695 | -122.41980135455 | (37.7269555010695, -122.41980135455) | 9 | 7 | 7 | 309 | 5 | |||
169371 | 68710 | Permitted Site 7 | Aesculus californica :: California Buckeye 168 | 3823 17th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/05/1995 12:00:00 AM | Permit Number 32623 | 6003423.96769423 | 2105918.95053249 | 37.7626458545756 | -122.431308387346 | (37.7626458545756, -122.431308387346) | 15 | 4 | 5 | 28862 | 3 | ||
169351 | 67133 | Permitted Site 7 | Aesculus californica :: California Buckeye 168 | 1315 04th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/30/1992 12:00:00 AM | Permit Number 30556 | 5994844.91533442 | 2106589.76410613 | 37.7639978078107 | -122.461028662211 | (37.7639978078107, -122.461028662211) | 15 | 5 | 11 | 56 | 12 | ||
181482 | 66566 | DPW Maintained 1 | Aesculus californica :: California Buckeye 168 | 89 Vienna St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/15/1991 12:00:00 AM | 7 | Permit Number 29755 | 6004841.08317 | 2092852.53065 | 37.7268486688143 | -122.425477148648 | (37.7268486688143, -122.425477148648) | 9 | 7 | 6 | 28861 | 5 | |
26430 | 64783 | Permitted Site 7 | Aesculus californica :: California Buckeye 168 | 159 Central Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/05/1989 12:00:00 AM | Permit Number 25776 | 5999862.92840033 | 2109021.20882221 | 37.7709614246447 | -122.443847598268 | (37.7709614246447, -122.443847598268) | 15 | 5 | 11 | 29492 | 9 | ||
80439 | 5515 | DPW Maintained 1 | Aesculus californica :: California Buckeye 168 | 832 Dolores St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 07/16/1991 12:00:00 AM | 20 | 6004989.0954255 | 2103498.2312613 | 37.7560877052008 | -122.425722863189 | (37.7560877052008, -122.425722863189) | 2 | 4 | 5 | 28862 | 22 | |||
135035 | 55045 | Permitted Site 7 | Aesculus californica :: California Buckeye 168 | 126 Valley St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/30/2005 12:00:00 AM | Permit Number 45765 | 6005082.1513949 | 2099337.46701929 | 37.7446684669508 | -122.42510500458 | (37.7446684669508, -122.42510500458) | 2 | 7 | 5 | 63 | 22 | ||
23027 | 47522 | DPW Maintained 1 | Aesculus californica :: California Buckeye 168 | 236 Theresa St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/17/2007 12:00:00 AM | 4 | 3x3 | Permit Number 49790 | 6001841.48906 | 2094066.75133 | 37.730012705007 | -122.435933499532 | (37.730012705007, -122.435933499532) | 9 | 7 | 6 | 28861 | 25 | |
6318 | 261662 | Section 806 (d) 5 | Aesculus californica :: California Buckeye 168 | 137 Elsie St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 02/13/2020 12:00:00 AM | 3 | 6007155.81154 | 2098485.15545 | 37.7424451335194 | -122.417874270912 | (37.7424451335194, -122.417874270912) | 2 | 7 | 7 | 28859 | 2 | |||
17088 | 260671 | Permitted Site 7 | Aesculus californica :: California Buckeye 168 | 9 Cardenas Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/03/2019 12:00:00 AM | 3 | 3x6 | 5989909.11704 | 2090923.47277 | 37.7206969761498 | -122.47695514418 | (37.7206969761498, -122.47695514418) | 1 | 8 | 4 | 64 | 14 | ||
5996 | 260670 | Permitted Site 7 | Aesculus californica :: California Buckeye 168 | 9 Cardenas Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/03/2019 12:00:00 AM | 3 | 3x6 | 5989909.11704 | 2090923.47277 | 37.7206969761498 | -122.47695514418 | (37.7206969761498, -122.47695514418) | 1 | 8 | 4 | 64 | 14 | ||
4333 | 260669 | Permitted Site 7 | Aesculus californica :: California Buckeye 168 | 9 Cardenas Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/03/2019 12:00:00 AM | 3 | 3x6 | 5989909.11704 | 2090923.47277 | 37.7206969761498 | -122.47695514418 | (37.7206969761498, -122.47695514418) | 1 | 8 | 4 | 64 | 14 | ||
1257 | 260668 | Permitted Site 7 | Aesculus californica :: California Buckeye 168 | 9 Cardenas Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/03/2019 12:00:00 AM | 3 | 3x6 | 5989909.11704 | 2090923.47277 | 37.7206969761498 | -122.47695514418 | (37.7206969761498, -122.47695514418) | 1 | 8 | 4 | 64 | 14 | ||
14661 | 260667 | Permitted Site 7 | Aesculus californica :: California Buckeye 168 | 2X Serrano Dr | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/03/2019 12:00:00 AM | 3 | 3x6 | ||||||||||||
1076 | 260666 | Permitted Site 7 | Aesculus californica :: California Buckeye 168 | 2X Serrano Dr | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/03/2019 12:00:00 AM | 3 | 3x6 | ||||||||||||
4488 | 260665 | Permitted Site 7 | Aesculus californica :: California Buckeye 168 | 2X Serrano Dr | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/03/2019 12:00:00 AM | 3 | 3x6 | ||||||||||||
10749 | 260664 | Permitted Site 7 | Aesculus californica :: California Buckeye 168 | 2X Serrano Dr | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/03/2019 12:00:00 AM | 3 | 3x6 | ||||||||||||
5725 | 260663 | Permitted Site 7 | Aesculus californica :: California Buckeye 168 | 2X Serrano Dr | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/03/2019 12:00:00 AM | 3 | 3x6 | ||||||||||||
1195 | 260486 | DPW Maintained 1 | Aesculus californica :: California Buckeye 168 | 79 Nevada St | 3 | Front Yard : Yard | Tree | Private 2 | 6009036 | 2098133 | 37.741583825963 | -122.411348244145 | (37.741583825963, -122.411348244145) | 10 | 7 | 7 | 28859 | 2 | |||||
16836 | 255909 | Landmark tree 11 | Aesculus californica :: California Buckeye 168 | 2694 McAllister St | 1 | Front Yard : Yard | Tree | Private 2 | Under Review | 5996297 | 2110789 | 37.7756112723889 | -122.456310013186 | (37.7756112723889, -122.456310013186) | 11 | 6 | 2 | 54 | 16 | ||||
126945 | 255504 | Landmark tree 11 | Aesculus californica :: California Buckeye 168 | 757 Pennsylvania Ave | 7 | Back Yard : Yard | Tree | Private 2 | FUF | 6014476.10973 | 2103508.37921 | 37.7566470977886 | -122.392914033755 | (37.7566470977886, -122.392914033755) | 10 | 3 | 8 | 28856 | 29 | ||||
1635 | 247839 | DPW Maintained 1 | Aesculus californica :: California Buckeye 168 | 79 Nevada St | 2 | Front Yard : Yard | Tree | Private 2 | 3 | 6009036 | 2098133 | 37.741583825963 | -122.411348244145 | (37.741583825963, -122.411348244145) | 10 | 7 | 7 | 28859 | 2 | ||||
133886 | 247063 | DPW Maintained 1 | Aesculus californica :: California Buckeye 168 | 636 30th St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 12 | Width 3ft | 6002447.47603 | 2098283.95273 | 37.7416265769191 | -122.434139888048 | (37.7416265769191, -122.434139888048) | 2 | 7 | 5 | 63 | 7 | |||
164493 | 247004 | DPW Maintained 1 | Aesculus californica :: California Buckeye 168 | 401 Valley St | 4 | Side Yard : Yard | Tree | Private 2 | 8 | Width 8ft | 6003237.98739 | 2099191.84637 | 37.7441642766696 | -122.431471365715 | (37.7441642766696, -122.431471365715) | 2 | 7 | 5 | 63 | 22 | |||
147559 | 220551 | DPW Maintained 1 | Aesculus californica :: California Buckeye 168 | 11 Ohlone Way | 1 | Back Yard : Yard | Tree | Private 2 | 21 | Width 5ft | 6002176.28568 | 2096385.22254 | 37.7363977089798 | -122.434941812622 | (37.7363977089798, -122.434941812622) | 2 | 7 | 5 | 63 | 7 | |||
90845 | 220550 | DPW Maintained 1 | Aesculus californica :: California Buckeye 168 | 37 Poppy Ln | 1 | Back Yard : Yard | Tree | Private 2 | 4 | Width 2ft | 6002449.94428 | 2096771.92833 | 37.7374750482297 | -122.434023295438 | (37.7374750482297, -122.434023295438) | 2 | 7 | 5 | 63 | 7 | |||
39072 | 220549 | DPW Maintained 1 | Aesculus californica :: California Buckeye 168 | 12 Harper St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6003643.97016 | 2098295.12842 | 37.7417250976308 | -122.430003612785 | (37.7417250976308, -122.430003612785) | 2 | 7 | 5 | 63 | 7 | |||
187884 | 220548 | DPW Maintained 1 | Aesculus californica :: California Buckeye 168 | 229 Montcalm St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 5ft | 6009792.04548 | 2099557.52273 | 37.7455376295605 | -122.408834562869 | (37.7455376295605, -122.408834562869) | 2 | 7 | 7 | 28859 | 2 | |||
4639 | 220547 | DPW Maintained 1 | Aesculus californica :: California Buckeye 168 | 801X Powhattan Ave | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 4 | 6008900.20831 | 2098091.37785 | 37.7414619236216 | -122.411814827102 | (37.7414619236216, -122.411814827102) | 10 | 7 | 7 | 28859 | 2 | ||||
2377 | 220546 | DPW Maintained 1 | Aesculus californica :: California Buckeye 168 | 799X Powhattan Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 3 | 6008777.78042 | 2098098.94343 | 37.7414758280375 | -122.412238676667 | (37.7414758280375, -122.412238676667) | 10 | 7 | 7 | 28859 | 2 | ||||
7208 | 220545 | DPW Maintained 1 | Aesculus californica :: California Buckeye 168 | 701X Powhattan Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 2 | 6008718.64128 | 2098106.70395 | 37.7414938180831 | -122.412443708622 | (37.7414938180831, -122.412443708622) | 10 | 7 | 7 | 28859 | 2 | ||||
8372 | 220544 | DPW Maintained 1 | Aesculus californica :: California Buckeye 168 | 701X Powhattan Ave | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 3 | 6008701.62523 | 2098105.03088 | 37.7414882692652 | -122.412502426255 | (37.7414882692652, -122.412502426255) | 10 | 7 | 7 | 28859 | 2 | ||||
18234 | 220543 | DPW Maintained 1 | Aesculus californica :: California Buckeye 168 | 400X Powhattan Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 9 | 6008222.42371 | 2098151.87623 | 37.7415899915791 | -122.414162659283 | (37.7415899915791, -122.414162659283) | 2 | 7 | 7 | 28859 | 2 | ||||
38444 | 220542 | DPW Maintained 1 | Aesculus californica :: California Buckeye 168 | 1150 Dolores St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 2ft | 6005096.34086 | 2101616.87439 | 37.7509279968363 | -122.425218105228 | (37.7509279968363, -122.425218105228) | 2 | 4 | 5 | 28862 | 22 | |||
44219 | 220541 | DPW Maintained 1 | Aesculus californica :: California Buckeye 168 | 200 Eugenia Ave | 23 | Front Yard : Yard | Tree | Private 2 | 1 | 6006634.00648 | 2098067.34276 | 37.7412685334299 | -122.419648882609 | (37.7412685334299, -122.419648882609) | 2 | 7 | 7 | 28859 | 2 | ||||
67773 | 220540 | DPW Maintained 1 | Aesculus californica :: California Buckeye 168 | 1100 San Jose Ave | 65 | Front Yard : Yard | Tree | Private 2 | 3 | 6004745.06753 | 2096608.9728 | 37.737157594747 | -122.426076374136 | (37.737157594747, -122.426076374136) | 2 | 7 | 5 | 63 | 7 | ||||
94016 | 220539 | DPW Maintained 1 | Aesculus californica :: California Buckeye 168 | 1100 San Jose Ave | 60 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | 6004743.1744 | 2096613.75996 | 37.7371706322103 | -122.426083260245 | (37.7371706322103, -122.426083260245) | 2 | 7 | 5 | 63 | 7 | ||||
140517 | 20949 | DPW Maintained 1 | Aesculus californica :: California Buckeye 168 | 1992X Sunset Blvd | 26 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3 | 60 | 5984875.9454268 | 2101638.8759791 | 37.7498253446275 | -122.495142757654 | (37.7498253446275, -122.495142757654) | 1 | 8 | 3 | 29491 | 35 | |||
51263 | 20948 | DPW Maintained 1 | Aesculus californica :: California Buckeye 168 | 1992X Sunset Blvd | 25 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3 | 60 | 5984875.9454268 | 2101638.8759791 | 37.7498253446275 | -122.495142757654 | (37.7498253446275, -122.495142757654) | 1 | 8 | 3 | 29491 | 35 | |||
189144 | 20946 | DPW Maintained 1 | Aesculus californica :: California Buckeye 168 | 1992X Sunset Blvd | 23 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3 | 60 | 5984875.9454268 | 2101638.8759791 | 37.7498253446275 | -122.495142757654 | (37.7498253446275, -122.495142757654) | 1 | 8 | 3 | 29491 | 35 | |||
34638 | 203440 | DPW Maintained 1 | Aesculus californica :: California Buckeye 168 | 363 Staples Ave | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 16 | Width 8ft | 5997689.5972 | 2093775.0971 | 37.7289751562695 | -122.450266015666 | (37.7289751562695, -122.450266015666) | 9 | 7 | 4 | 28861 | 40 | |||
124313 | 203439 | DPW Maintained 1 | Aesculus californica :: California Buckeye 168 | 640 Quintara St | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 1 | Width 6ft | 5991446.07862 | 2101158.03862 | 37.7488875493216 | -122.472388116728 | (37.7488875493216, -122.472388116728) | 1 | 8 | 4 | 29491 | 12 | |||
105271 | 189147 | DPW Maintained 1 | Aesculus californica :: California Buckeye 168 | 2001 Revere Ave | 11 | Sidewalk: Property side : Yard | Tree | Private 2 | 13 | 6012286.41332 | 2096447.34083 | 37.737137130676 | -122.399990998582 | (37.737137130676, -122.399990998582) | 10 | 3 | 8 | 58 | 1 | ||||
7050 | 189146 | DPW Maintained 1 | Aesculus californica :: California Buckeye 168 | 602 Arthur Ave | 47 | Front Yard : Yard | Tree | Private 2 | 11 | Width 8ft | 6015987.00875 | 2099822.70323 | 37.746610811259 | -122.387431643369 | (37.746610811259, -122.387431643369) | 10 | 3 | 8 | 58 | 1 | |||
88616 | 189145 | DPW Maintained 1 | Aesculus californica :: California Buckeye 168 | 602 Arthur Ave | 46 | Front Yard : Yard | Tree | Private 2 | 5 | Width 5ft | 6015973.04978 | 2099833.22723 | 37.7466389348589 | -122.387480646513 | (37.7466389348589, -122.387480646513) | 10 | 3 | 8 | 58 | 1 | |||
108127 | 189144 | DPW Maintained 1 | Aesculus californica :: California Buckeye 168 | 602 Arthur Ave | 45 | Front Yard : Yard | Tree | Private 2 | 11 | Width 5ft | 6015967.83076 | 2099823.77263 | 37.7466126854204 | -122.38749803403 | (37.7466126854204, -122.38749803403) | 10 | 3 | 8 | 58 | 1 | |||
148067 | 189143 | DPW Maintained 1 | Aesculus californica :: California Buckeye 168 | 602 Arthur Ave | 30 | Front Yard : Yard | Tree | Private 2 | 12 | 6015722.08374 | 2099873.00107 | 37.7467342422863 | -122.388351244209 | (37.7467342422863, -122.388351244209) | 3 | 8 | 58 | 1 | |||||
41545 | 189142 | DPW Maintained 1 | Aesculus californica :: California Buckeye 168 | 602 Arthur Ave | 23 | Front Yard : Yard | Tree | Private 2 | 3 | 6015758.1657 | 2099860.0958 | 37.7467008063952 | -122.388225574764 | (37.7467008063952, -122.388225574764) | 3 | 8 | 58 | 1 | |||||
65682 | 189141 | DPW Maintained 1 | Aesculus californica :: California Buckeye 168 | 602 Arthur Ave | 22 | Front Yard : Yard | Tree | Private 2 | 8 | 6015754.1736 | 2099854.82751 | 37.7466861195679 | -122.388239011548 | (37.7466861195679, -122.388239011548) | 3 | 8 | 58 | 1 | |||||
89893 | 189140 | DPW Maintained 1 | Aesculus californica :: California Buckeye 168 | 602 Arthur Ave | 21 | Front Yard : Yard | Tree | Private 2 | 10 | 6015749.22351 | 2099864.37329 | 37.7467120560207 | -122.388256794709 | (37.7467120560207, -122.388256794709) | 3 | 8 | 58 | 1 | |||||
139537 | 189139 | DPW Maintained 1 | Aesculus californica :: California Buckeye 168 | 602 Arthur Ave | 20 | Front Yard : Yard | Tree | Private 2 | 4 | 6015742.38817 | 2099871.11188 | 37.7467301800482 | -122.38828090106 | (37.7467301800482, -122.38828090106) | 3 | 8 | 58 | 1 | |||||
19618 | 189138 | DPW Maintained 1 | Aesculus californica :: California Buckeye 168 | 602 Arthur Ave | 19 | Front Yard : Yard | Tree | Private 2 | 10 | 6015741.24344 | 2099880.89956 | 37.7467569915572 | -122.38828554245 | (37.7467569915572, -122.38828554245) | 3 | 8 | 58 | 1 | |||||
126840 | 189137 | DPW Maintained 1 | Aesculus californica :: California Buckeye 168 | 602 Arthur Ave | 18 | Front Yard : Yard | Tree | Private 2 | 11 | 6015751.92093 | 2099879.11359 | 37.7467526792876 | -122.38824849579 | (37.7467526792876, -122.38824849579) | 3 | 8 | 58 | 1 | |||||
159449 | 189136 | DPW Maintained 1 | Aesculus californica :: California Buckeye 168 | 602 Arthur Ave | 17 | Front Yard : Yard | Tree | Private 2 | 4 | 6015754.5938 | 2099870.74014 | 37.7467298356314 | -122.388238668895 | (37.7467298356314, -122.388238668895) | 3 | 8 | 58 | 1 | |||||
122133 | 189135 | DPW Maintained 1 | Aesculus californica :: California Buckeye 168 | 602 Arthur Ave | 16 | Front Yard : Yard | Tree | Private 2 | 6 | 6015763.80239 | 2099861.91676 | 37.7467061186908 | -122.388206210549 | (37.7467061186908, -122.388206210549) | 3 | 8 | 58 | 1 | |||||
93033 | 189134 | DPW Maintained 1 | Aesculus californica :: California Buckeye 168 | 602 Arthur Ave | 11 | Front Yard : Yard | Tree | Private 2 | 5 | 6015841.58252 | 2099892.34774 | 37.7467939851587 | -122.38793937541 | (37.7467939851587, -122.38793937541) | 3 | 8 | 58 | 1 | |||||
156914 | 189133 | DPW Maintained 1 | Aesculus californica :: California Buckeye 168 | 1451 19th St | 4 | : | Tree | Private 2 | 8 | Width 4ft | 6013351.15838 | 2105193.33432 | 37.7612110663572 | -122.396922680856 | (37.7612110663572, -122.396922680856) | 10 | 3 | 8 | 28856 | 29 | |||
131364 | 189132 | DPW Maintained 1 | Aesculus californica :: California Buckeye 168 | 1750 22nd St | 3 | Side Yard : Yard | Tree | Private 2 | 12 | 6012850.67661 | 2103796.49604 | 37.7573477838995 | -122.398555623956 | (37.7573477838995, -122.398555623956) | 10 | 3 | 8 | 28856 | 29 | ||||
12782 | 189131 | DPW Maintained 1 | Aesculus californica :: California Buckeye 168 | 1900 19th St | 6 | Front Yard : Yard | Tree | Private 2 | 21 | 6012035.08291 | 2105138.4122 | 37.7609869175263 | -122.401470592893 | (37.7609869175263, -122.401470592893) | 10 | 3 | 8 | 28856 | 29 | ||||
132562 | 125423 | DPW Maintained 1 | Aesculus californica :: California Buckeye 168 | 10 MacOndray Ln | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 49 | 6008584.09137 | 2119179.22866 | 37.7993464895011 | -122.41439962436 | (37.7993464895011, -122.41439962436) | 5 | 1 | 10 | 308 | 32 | ||||
180021 | 125422 | DPW Maintained 1 | Aesculus californica :: California Buckeye 168 | 956 Vallejo St | 6 | Front Yard : Yard | Tree | Private 2 | 2 | 6008842.67781 | 2118697.99173 | 37.7980396549647 | -122.413470768567 | (37.7980396549647, -122.413470768567) | 3 | 1 | 10 | 308 | 21 | ||||
126003 | 125421 | DPW Maintained 1 | Aesculus californica :: California Buckeye 168 | 952 Vallejo St | 1 | Front Yard : Yard | Tree | Private 2 | 4 | 6008979.12848 | 2118712.4234 | 37.7980869413024 | -122.412999629036 | (37.7980869413024, -122.412999629036) | 3 | 1 | 10 | 308 | 21 | ||||
106368 | 117063 | Undocumented 4 | Aesculus californica :: California Buckeye 168 | 229 MONTCALM ST | 1 | Unaccepted Street : Cutout | Tree | Private 2 | 3x3 | 6009811 | 2099554 | 37.7455290185947 | -122.40876877231 | (37.7455290185947, -122.40876877231) | 2 | 7 | 7 | 28859 | 2 | ||||
178686 | 116676 | DPW Maintained 1 | Aesculus californica :: California Buckeye 168 | 100 Esmeralda Ave | 15 | Unaccepted Street : Yard | Tree | DPW 1 | 6006917.38983 | 2098966.37493 | 37.7437530336215 | -122.41873278304 | (37.7437530336215, -122.41873278304) | 2 | 7 | 7 | 28859 | 2 | |||||
64831 | 111748 | Landmark tree 11 | Aesculus californica :: California Buckeye 168 | 730 28th Ave | 1 | Back Yard : Yard | Tree | Private 2 | 5987294.2 | 2110946.4 | 37.7755225253955 | -122.487464059213 | (37.7755225253955, -122.487464059213) | 11 | 6 | 2 | 55 | 26 | |||||
153240 | 107142 | Significant Tree 6 | Aesculus californica :: California Buckeye 168 | 2694 MCALLISTER ST | 2 | Front Yard : Yard | Tree | Private 2 | 48 | 5996297.4 | 2110789.6 | 37.7756129427938 | -122.45630867289 | (37.7756129427938, -122.45630867289) | 11 | 6 | 2 | 54 | 16 | ||||
117472 | 103478 | Significant Tree 6 | Aesculus californica :: California Buckeye 168 | 50 Gardenside Dr | 1 | Front Yard : Yard | Tree | Private 2 | Permit Number 770287 | 5999492 | 2102892 | 37.7541109784186 | -122.444690026478 | (37.7541109784186, -122.444690026478) | 2 | 5 | 5 | 63 | 38 |
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) );