trees
891 rows where qSpecies_id = 75 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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
143649 | 88192 | Permitted Site 7 | Acer rubrum :: Red Maple 75 | 364 Tehama St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/08/2008 12:00:00 AM | 3x3 | Permit Number 51197 | 6011427.8 | 2112687.4 | 37.7816808107693 | -122.40410221959 | (37.7816808107693, -122.40410221959) | 6 | 2 | 9 | 28853 | 34 | ||
147641 | 107154 | Undocumented 4 | Acer rubrum :: Red Maple 75 | 275 Spear St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6015276.38031 | 2115978.63581 | 37.7909320761837 | -122.391017946268 | (37.7909320761837, -122.391017946268) | 6 | 2 | 9 | 28855 | 6 | ||||
149022 | 253850 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 3125X San Bruno Ave | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6011499 | 2092098 | 37.7251508166345 | -122.402407728857 | (37.7251508166345, -122.402407728857) | 10 | 3 | 7 | 309 | 28 | ||||
149926 | 100776 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 450 Hayes St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/10/2012 12:00:00 AM | 3x4 | Permit Number 768934 | 6005678.7 | 2111113.4 | 37.7770360905223 | -122.423879452899 | (37.7770360905223, -122.423879452899) | 7 | 9 | 11 | 28852 | 10 | ||
155975 | 256208 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 837 Broadway | 2 | Median : Cutout | Tree | DPW 1 | 3x3 | 6009431 | 2118388 | 37.7972215096833 | -122.411413084134 | (37.7972215096833, -122.411413084134) | 3 | 1 | 10 | 308 | 4 | ||||
158385 | 256198 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 800 Broadway | 3 | Median : Cutout | Tree | DPW 1 | 3x3 | 6009530 | 2118420 | 37.797314926041 | -122.411072779375 | (37.797314926041, -122.411072779375) | 3 | 1 | 10 | 308 | 4 | ||||
158549 | 101992 | Permitted Site 7 | Acer rubrum :: Red Maple 75 | 25 Essex St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6014029.63843 | 2114247.91899 | 37.7861106686205 | -122.395210367086 | (37.7861106686205, -122.395210367086) | 6 | 2 | 9 | 28855 | 6 | ||||
160754 | 255535 | Undocumented 4 | Acer rubrum :: Red Maple 75 | 101 01st St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6013390 | 2115602 | 37.7897930671001 | -122.397518362151 | (37.7897930671001, -122.397518362151) | 12 | 2 | 9 | 28855 | 6 | ||||
161689 | 94415 | Permitted Site 7 | Acer rubrum :: Red Maple 75 | 5800 03rd St | 2 | Front Yard : Yard | Tree | Private 2 | 07/29/2010 12:00:00 AM | 3x3 | Permit Number 53653 | 6013849 | 2092184 | 37.7255178628117 | -122.394289979276 | (37.7255178628117, -122.394289979276) | 10 | 3 | 8 | 58 | 1 | ||
164083 | 251537 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 25 Essex St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6014029 | 2114247 | 37.7861081097809 | -122.395212511502 | (37.7861081097809, -122.395212511502) | 6 | 2 | 9 | 28855 | 6 | ||||
165926 | 256205 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 800 Broadway | 10 | Median : Cutout | Tree | DPW 1 | 3x3 | 6009530 | 2118420 | 37.797314926041 | -122.411072779375 | (37.797314926041, -122.411072779375) | 3 | 1 | 10 | 308 | 4 | ||||
167057 | 6288 | Permitted Site 7 | Acer rubrum :: Red Maple 75 | 1700X Ellis St | 2 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 01/28/2013 12:00:00 AM | 4x3 | Permit Number 768629 | 6002728.2699376 | 2113059.4201816 | 37.7822123689276 | -122.434225051326 | (37.7822123689276, -122.434225051326) | 15 | 9 | 11 | 29490 | 41 | ||
172484 | 256197 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 800 Broadway | 2 | Median : Cutout | Tree | DPW 1 | 3x3 | 6009530 | 2118420 | 37.797314926041 | -122.411072779375 | (37.797314926041, -122.411072779375) | 3 | 1 | 10 | 308 | 4 | ||||
173673 | 92758 | Permitted Site 7 | Acer rubrum :: Red Maple 75 | 528 Carter St | Front Yard : Yard | Tree | Private 2 | 10/09/2009 12:00:00 AM | Permit Number 52985 | 6005271.9 | 2086340.9 | 37.708993467942 | -122.423525081608 | (37.708993467942, -122.423525081608) | 9 | 7 | 8 | 309 | 5 | ||||
175063 | 87445 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 2413X Alemany Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/22/2008 12:00:00 AM | 3x3 | 5999221.04782 | 2088973.52313 | 37.7158786645875 | -122.444626724129 | (37.7158786645875, -122.444626724129) | 9 | 7 | 6 | 28861 | 25 | |||
175622 | 92757 | Permitted Site 7 | Acer rubrum :: Red Maple 75 | 528 Carter St | Front Yard : Yard | Tree | Private 2 | 10/09/2009 12:00:00 AM | Permit Number 52985 | 6005271.9 | 2086340.9 | 37.708993467942 | -122.423525081608 | (37.708993467942, -122.423525081608) | 9 | 7 | 8 | 309 | 5 | ||||
175632 | 88151 | Permitted Site 7 | Acer rubrum :: Red Maple 75 | 300X Clementina St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/08/2008 12:00:00 AM | 3x3 | Permit Number 770961 | 6012270 | 2112782 | 37.7819875812332 | -122.401195237476 | (37.7819875812332, -122.401195237476) | 6 | 2 | 9 | 28856 | 34 | ||
179843 | 49216 | Permitted Site 7 | Acer rubrum :: Red Maple 75 | 500 Howard St | 28 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/05/2003 12:00:00 AM | Permit Number 46300 | 6013774.5913005 | 2115138.38416874 | 37.7885414925604 | -122.396155198 | (37.7885414925604, -122.396155198) | 12 | 2 | 9 | 28855 | 6 | |||
181572 | 255557 | Undocumented 4 | Acer rubrum :: Red Maple 75 | 100x Fremont St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6013542 | 2115679 | 37.7900129533755 | -122.396997853926 | (37.7900129533755, -122.396997853926) | 12 | 2 | 9 | 28855 | 6 | ||||
184236 | 100774 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 450 Hayes St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/10/2012 12:00:00 AM | 3x4 | Permit Number 768934 | 6005678.7 | 2111113.4 | 37.7770360905223 | -122.423879452899 | (37.7770360905223, -122.423879452899) | 7 | 9 | 11 | 28852 | 10 | ||
186332 | 121541 | Planning Code 138.1 required 2 | Acer rubrum :: Red Maple 75 | 318 Main St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8x15 | 6015095 | 2115307 | 37.7890778525244 | -122.391598542205 | (37.7890778525244, -122.391598542205) | 6 | 2 | 9 | 28855 | 6 | ||||
186559 | 251267 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 1174 Bryant St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6009753 | 2108692 | 37.7706166587255 | -122.409614176745 | (37.7706166587255, -122.409614176745) | 8 | 2 | 9 | 28853 | 34 | ||||
188463 | 115734 | Significant Tree 6 | Acer rubrum :: Red Maple 75 | 55 Yerba Buena Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 776555 | 5993732.7 | 2097034 | 37.7376960566374 | -122.464181687663 | (37.7376960566374, -122.464181687663) | 1 | 8 | 4 | 59 | 40 | ||||
191487 | 53153 | Permitted Site 7 | Acer rubrum :: Red Maple 75 | 1397@ JENNINGS Revere Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/02/2006 12:00:00 AM | Permit Number 49077 | 6016165.18448304 | 2093562.93446239 | 37.7294326204666 | -122.386379154297 | (37.7294326204666, -122.386379154297) | 10 | 3 | 8 | 58 | 1 | ||
193594 | 256211 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 837 Broadway | 5 | Median : Cutout | Tree | DPW 1 | 3x3 | 6009431 | 2118388 | 37.7972215096833 | -122.411413084134 | (37.7972215096833, -122.411413084134) | 3 | 1 | 10 | 308 | 4 | ||||
72011 | 141131 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 1760 Ellis St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 0 | Width 0ft | 6002332.7569 | 2113004.3119 | 37.7820385992621 | -122.435589403585 | (37.7820385992621, -122.435589403585) | 15 | 5 | 11 | 29490 | 41 | |||
103123 | 14797 | Permitted Site 7 | Acer rubrum :: Red Maple 75 | 1135 McAllister St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/21/1999 12:00:00 AM | 0 | 4X4 | 6003741.3117055 | 2111761.9657456 | 37.7787073276968 | -122.430627770211 | (37.7787073276968, -122.430627770211) | 15 | 9 | 11 | 29492 | 41 | ||
144642 | 14755 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 950X McAllister St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 05/23/2013 12:00:00 AM | 0 | 4X4 | 6004580.51193 | 2112075.36147 | 37.7796153416711 | -122.427746985107 | (37.7796153416711, -122.427746985107) | 7 | 9 | 11 | 29490 | 41 | ||
9269 | 71335 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 277 Shipley St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 1 | 6011311.01378 | 2111537.1063 | 37.7785158463684 | -122.404425254319 | (37.7785158463684, -122.404425254319) | 14 | 2 | 9 | 28856 | 34 | |||
19089 | 203401 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 24 Yerba Buena Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 1 | Width 6ft | 5993518.80789 | 2097119.92672 | 37.7379196595754 | -122.464927448042 | (37.7379196595754, -122.464927448042) | 1 | 8 | 4 | 59 | 40 | |||
19613 | 187949 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 302 Main St | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 1 | 6015269.3196 | 2115112.5908 | 37.7885537238177 | -122.390981820563 | (37.7885537238177, -122.390981820563) | 6 | 2 | 9 | 28855 | 6 | ||||
28496 | 175131 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 3219 San Bruno Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6011901.5218 | 2090720.78574 | 37.7213917301239 | -122.400919526131 | (37.7213917301239, -122.400919526131) | 10 | 7 | 8 | 309 | 28 | |||
31665 | 189088 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 693 Minna St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6009010.6716 | 2111090.12277 | 37.7771597163869 | -122.412351439063 | (37.7771597163869, -122.412351439063) | 8 | 2 | 9 | 28853 | 34 | |||
37037 | 203405 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 155 Yerba Buena Ave | 4 | Sidewalk: Curb side : Yard | Tree | Private 2 | 1 | Width 8ft | 5994431.87617 | 2096469.95405 | 37.7361875994652 | -122.461723432511 | (37.7361875994652, -122.461723432511) | 9 | 8 | 4 | 59 | 40 | |||
39683 | 203406 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 155 Yerba Buena Ave | 5 | Sidewalk: Curb side : Yard | Tree | Private 2 | 1 | Width 8ft | 5994466.0383 | 2096440.37443 | 37.7361083476053 | -122.461603176966 | (37.7361083476053, -122.461603176966) | 9 | 8 | 4 | 59 | 40 | |||
46552 | 187907 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 167 Jessie St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6012037.39416 | 2114599.46395 | 37.7869649329299 | -122.402127766205 | (37.7869649329299, -122.402127766205) | 12 | 2 | 9 | 28855 | 6 | |||
47087 | 220487 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 416 Hoffman Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6000636.08004 | 2101486.04738 | 37.7503157923525 | -122.440632691055 | (37.7503157923525, -122.440632691055) | 2 | 4 | 5 | 28862 | 22 | |||
60408 | 220502 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 203 States St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6001052.74554 | 2106320.20374 | 37.7636129298281 | -122.439538340217 | (37.7636129298281, -122.439538340217) | 15 | 5 | 5 | 28862 | 3 | |||
60651 | 68389 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 122 Cotter St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/30/1993 12:00:00 AM | 1 | Permit Number 32216 | 6002009.36321 | 2093483.54875 | 37.7284208987036 | -122.43531143848 | (37.7284208987036, -122.43531143848) | 9 | 7 | 6 | 28861 | 25 | |
63417 | 220476 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 849 Cole St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 5998017.46753 | 2107292.9322 | 37.7661105800595 | -122.450106480435 | (37.7661105800595, -122.450106480435) | 15 | 5 | 11 | 29492 | 9 | |||
81119 | 187951 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 302 Main St | 4 | Sidewalk: Curb side : Yard | Tree | Private 2 | 1 | 6015307.96603 | 2115072.71193 | 37.7884463699393 | -122.390845320574 | (37.7884463699393, -122.390845320574) | 6 | 2 | 9 | 28855 | 6 | ||||
89204 | 185773 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 1615 Ortega St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 0ft | 5989001.3995 | 2102380.5121 | 37.7521023420375 | -122.480931213247 | (37.7521023420375, -122.480931213247) | 1 | 8 | 3 | 29491 | 35 | |||
89772 | 96283 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 3229 San Bruno Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/19/2011 12:00:00 AM | 1 | 2x2 | Permit Number 58766 | 6011911.44714 | 2090686.29991 | 37.721297592691 | -122.400882795106 | (37.721297592691, -122.400882795106) | 10 | 7 | 8 | 309 | 28 | |
92037 | 175138 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 67 Edinburgh St | 1 | Sidewalk: Curb side : Pot | Tree | Private 2 | 1 | Width 3ft | 6004374.52258 | 2093135.85691 | 37.7276002475407 | -122.427110209575 | (37.7276002475407, -122.427110209575) | 9 | 7 | 6 | 28861 | 5 | |||
99576 | 123540 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 27 05th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 5994225.0963 | 2115400.25792 | 37.7881533861032 | -122.463811955609 | (37.7881533861032, -122.463811955609) | 11 | 6 | 1 | 54 | 11 | |||
101421 | 189080 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 1047 Bryant St | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/01/2014 12:00:00 AM | 1 | Width 2ft | 6010237.11859 | 2109048.60365 | 37.7716229259945 | -122.407964748472 | (37.7716229259945, -122.407964748472) | 14 | 2 | 9 | 28853 | 34 | ||
102819 | 88175 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 360 Clementina St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/08/2008 12:00:00 AM | 1 | 3x3 | Permit Number 51186 | 6011658.68026 | 2112523.02352 | 37.7812423686803 | -122.403291911611 | (37.7812423686803, -122.403291911611) | 6 | 2 | 9 | 28853 | 34 | |
112998 | 189084 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 350 Tehama St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6011667.54988 | 2112806.97439 | 37.7820225269481 | -122.403281207876 | (37.7820225269481, -122.403281207876) | 6 | 2 | 9 | 28853 | 34 | |||
122971 | 187950 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 302 Main St | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 1 | 6015285.41791 | 2115092.62187 | 37.7884997869723 | -122.390924726221 | (37.7884997869723, -122.390924726221) | 6 | 2 | 9 | 28855 | 6 | ||||
126651 | 96285 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 3237 San Bruno Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/19/2011 12:00:00 AM | 1 | 2x2 | Permit Number 58767 | 6011917.42501 | 2090666.70864 | 37.7212441324916 | -122.400860755445 | (37.7212441324916, -122.400860755445) | 10 | 7 | 8 | 309 | 28 | |
132501 | 189087 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 352 Tehama St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6011613.92436 | 2112756.37403 | 37.7818805950589 | -122.403463167713 | (37.7818805950589, -122.403463167713) | 6 | 2 | 9 | 28853 | 34 | |||
136590 | 104201 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 3135 24th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/30/2015 12:00:00 AM | 1 | 3x3 | Permit Number 770708 | 6008143.9 | 2102068.3 | 37.7523392058798 | -122.41471126484 | (37.7523392058798, -122.41471126484) | 2 | 4 | 7 | 28859 | 19 | |
145906 | 88174 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 360 Clementina St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/08/2008 12:00:00 AM | 1 | 3x3 | Permit Number 51186 | 6011666.30434 | 2112532.55024 | 37.7812689526358 | -122.403266206273 | (37.7812689526358, -122.403266206273) | 6 | 2 | 9 | 28853 | 34 | |
146528 | 203402 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 20 Yerba Buena Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 1 | Width 6ft | 5993459.6533 | 2097164.40162 | 37.738038365583 | -122.465135202222 | (37.738038365583, -122.465135202222) | 1 | 8 | 4 | 59 | 40 | |||
147411 | 220477 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 851 Cole St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 5998019.73949 | 2107271.17336 | 37.7660509658169 | -122.450097053756 | (37.7660509658169, -122.450097053756) | 15 | 5 | 11 | 29492 | 9 | |||
148004 | 109047 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 2146 Bay St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | 6000527.7493 | 2120317.86339 | 37.802017012843 | -122.442359096207 | (37.802017012843, -122.442359096207) | 13 | 9 | 1 | 57 | 17 | ||||
151914 | 114457 | Undocumented 4 | Acer rubrum :: Red Maple 75 | 1985 GOLDEN GATE AVE | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | 3x3 | 6000094 | 2111584 | 37.7780113768023 | -122.443232414545 | (37.7780113768023, -122.443232414545) | 15 | 5 | 11 | 29490 | 16 | |||
158314 | 96282 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 3219 San Bruno Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/19/2011 12:00:00 AM | 1 | 2x2 | Permit Number 58765 | 6011894.72872 | 2090742.08656 | 37.7214498389136 | -122.400944503905 | (37.7214498389136, -122.400944503905) | 10 | 7 | 8 | 309 | 28 | |
170547 | 220427 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 1501 Bryant St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6009439.69021 | 2107723.53455 | 37.7679399153267 | -122.410629521551 | (37.7679399153267, -122.410629521551) | 8 | 4 | 8 | 28853 | 19 | |||
177290 | 203400 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 34 Yerba Buena Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 1 | Width 6ft | 5993596.06359 | 2097068.49274 | 37.7377828888614 | -122.464656605522 | (37.7377828888614, -122.464656605522) | 1 | 8 | 4 | 59 | 40 | |||
181942 | 203404 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 155 Yerba Buena Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 1 | Width 8ft | 5994396.0657 | 2096501.56524 | 37.7362723344984 | -122.461849534529 | (37.7362723344984, -122.461849534529) | 9 | 8 | 4 | 59 | 40 | |||
182498 | 96284 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 3237 San Bruno Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/19/2011 12:00:00 AM | 1 | 2x2 | Permit Number 58767 | 6011926.62111 | 2090638.16357 | 37.7211662664813 | -122.400826962515 | (37.7211662664813, -122.400826962515) | 10 | 7 | 8 | 309 | 28 | |
186116 | 187908 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 167 Jessie St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6012100.15122 | 2114661.96833 | 37.7871400579 | -122.401915035175 | (37.7871400579, -122.401915035175) | 12 | 2 | 9 | 28855 | 6 | |||
190387 | 203403 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 155 Yerba Buena Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 1 | Width 8ft | 5994381.0014 | 2096518.06805 | 37.736316779897 | -122.461902813967 | (37.736316779897, -122.461902813967) | 9 | 8 | 4 | 59 | 40 | |||
38677 | 59325 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 345 Grove St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/26/1990 12:00:00 AM | 12 | Permit Number 29282 | 6006158.21098 | 2111403.55582 | 37.7778598467005 | -122.422241292597 | (37.7778598467005, -122.422241292597) | 7 | 9 | 11 | 28852 | 10 | ||
57551 | 27452 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 1635 Indiana St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 6X6 | 6015192.76909 | 2100696.51451 | 37.7489660934285 | -122.390239101956 | (37.7489660934285, -122.390239101956) | 10 | 3 | 8 | 58 | 1 | |||
101144 | 27453 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 1635 Indiana St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 6X6 | 6015188.65813 | 2100719.92865 | 37.7490301557222 | -122.390254953405 | (37.7490301557222, -122.390254953405) | 10 | 3 | 8 | 58 | 1 | |||
108579 | 22773 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 1741 Turk St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6001679.7734 | 2112097.4839 | 37.7795115699514 | -122.437783455726 | (37.7795115699514, -122.437783455726) | 15 | 5 | 11 | 29490 | 41 | |||
126679 | 27454 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 1635 Indiana St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 6X6 | 6015187.13368 | 2100745.31925 | 37.7490997884263 | -122.390261998696 | (37.7490997884263, -122.390261998696) | 10 | 3 | 8 | 58 | 1 | |||
130736 | 27455 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 1635 Indiana St | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 6X6 | 6015186.58653 | 2100768.66108 | 37.7491638498456 | -122.390265521335 | (37.7491638498456, -122.390265521335) | 10 | 3 | 8 | 58 | 1 | |||
189783 | 2366 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 2500 Bryant St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6009707.81579 | 2102741.7783 | 37.7542761719147 | -122.409350492245 | (37.7542761719147, -122.409350492245) | 2 | 4 | 7 | 28859 | 19 | |||
141341 | 175136 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 313 Delano Ave | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 14 | Width 3ft | 5999930.3709 | 2092032.12822 | 37.7243173479397 | -122.442394436857 | (37.7243173479397, -122.442394436857) | 9 | 7 | 6 | 28861 | 25 | |||
122505 | 203233 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 96 Castenada Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 17 | Width 3ft | 5994437 | 2101362 | 37.7496202288212 | -122.462060373707 | (37.7496202288212, -122.462060373707) | 1 | 8 | 4 | 29491 | 40 | |||
2135 | 187956 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 340 Fremont St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6014829.80215 | 2114536.31276 | 37.7869469986487 | -122.392462171218 | (37.7869469986487, -122.392462171218) | 6 | 2 | 9 | 28855 | 6 | |||
5835 | 118375 | Planning Code 138.1 required 2 | Acer rubrum :: Red Maple 75 | 340 Fremont St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | 4x6 | 6014712.48727 | 2114662.02755 | 37.7872856671566 | -122.392876855803 | (37.7872856671566, -122.392876855803) | 6 | 2 | 9 | 28855 | 6 | |||
6100 | 141590 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 700x DIVISADERO ST | 6 | Median : Cutout | Tree | DPW 1 | 2 | Width 0ft | 6001558.8965 | 2111018.1096 | 37.7765410064467 | -122.438124278141 | (37.7765410064467, -122.438124278141) | 15 | 5 | 11 | 29492 | 10 | |||
9549 | 189101 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 1444 Galvez Ave | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6015952.01721 | 2097639.00089 | 37.7406128754775 | -122.387400332559 | (37.7406128754775, -122.387400332559) | 10 | 3 | 8 | 58 | 1 | |||
11492 | 187952 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 340 Fremont St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6014738.2491 | 2114633.83833 | 37.7872096969197 | -122.392785751786 | (37.7872096969197, -122.392785751786) | 6 | 2 | 9 | 28855 | 6 | |||
15420 | 220483 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 3135 24th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6008148.36276 | 2102088.69137 | 37.7523954467163 | -122.414697274784 | (37.7523954467163, -122.414697274784) | 2 | 4 | 7 | 28859 | 19 | |||
23226 | 139865 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 752 MCALLISTER ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 0ft | 6005530.836 | 2112064.5728 | 37.7796394301742 | -122.424458633546 | (37.7796394301742, -122.424458633546) | 7 | 9 | 11 | 28852 | 41 | |||
24645 | 220503 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 203 States St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6001063.95053 | 2106312.4258 | 37.7635922112288 | -122.439499028168 | (37.7635922112288, -122.439499028168) | 15 | 5 | 5 | 28862 | 3 | |||
26680 | 187919 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 48 Minna St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6013100.51395 | 2115046.75094 | 37.7882523600964 | -122.398480985606 | (37.7882523600964, -122.398480985606) | 12 | 2 | 9 | 28855 | 6 | |||
27552 | 187948 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 302 Main St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 2 | 6015252.9594 | 2115128.97629 | 37.7885978067978 | -122.391039570534 | (37.7885978067978, -122.391039570534) | 6 | 2 | 9 | 28855 | 6 | ||||
28189 | 203426 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 135 Yerba Buena Ave | 4 | Sidewalk: Curb side : Yard | Tree | Private 2 | 2 | Width 4ft | 5994229.44749 | 2096660.50029 | 37.7366991374492 | -122.462437122787 | (37.7366991374492, -122.462437122787) | 9 | 8 | 4 | 59 | 40 | |||
28362 | 203408 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 1945 08th Ave | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 2 | Width 6ft | 5993769.17892 | 2102256.91781 | 37.7520389725334 | -122.464434672649 | (37.7520389725334, -122.464434672649) | 1 | 8 | 4 | 29491 | 12 | |||
28925 | 139861 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 710 McAllister St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 0ft | 6005666.4072 | 2112084.3112 | 37.7797012818942 | -122.423991037673 | (37.7797012818942, -122.423991037673) | 7 | 9 | 11 | 28852 | 41 | |||
29533 | 187958 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 43 Lansing St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6014361.38404 | 2114182.65198 | 37.7859499041048 | -122.394058036143 | (37.7859499041048, -122.394058036143) | 6 | 2 | 9 | 28855 | 6 | |||
31890 | 141993 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 818 Webster St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/21/2008 12:00:00 AM | 2 | Width 0ft | 6003993.152 | 2111582.4748 | 37.778228754 | -122.429743751351 | (37.778228754, -122.429743751351) | 7 | 9 | 11 | 29490 | 41 | ||
33193 | 175132 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 3209 San Bruno Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6011889.98271 | 2090759.53666 | 37.7214974885945 | -122.400962135093 | (37.7214974885945, -122.400962135093) | 10 | 7 | 8 | 309 | 28 | |||
33884 | 220480 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 211 Prentiss St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 2ft | 6008820.1543 | 2097512.38681 | 37.739867649565 | -122.412050719273 | (37.739867649565, -122.412050719273) | 10 | 7 | 7 | 28859 | 2 | |||
37025 | 2365 | Permitted Site 7 | Acer rubrum :: Red Maple 75 | 2500 Bryant St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | 3X3 | 6009712.991769 | 2102766.5035064 | 37.7543443518018 | -122.409334337085 | (37.7543443518018, -122.409334337085) | 2 | 4 | 7 | 28859 | 19 | |||
37592 | 104202 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 3135 24th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/30/2015 12:00:00 AM | 2 | 3x3 | Permit Number 770708 | 6008143.9 | 2102068.3 | 37.7523392058798 | -122.41471126484 | (37.7523392058798, -122.41471126484) | 2 | 4 | 7 | 28859 | 19 | |
42705 | 203416 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 75 Yerba Buena Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 2 | Width 4ft | 5993822.50089 | 2096951.15994 | 37.7374737738828 | -122.463865194036 | (37.7374737738828, -122.463865194036) | 1 | 8 | 4 | 59 | 40 | |||
43780 | 187954 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 340 Fremont St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6014772.69279 | 2114599.27503 | 37.7871167070277 | -122.392664164317 | (37.7871167070277, -122.392664164317) | 6 | 2 | 9 | 28855 | 6 | |||
50503 | 50676 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 320 Clementina St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/17/2009 12:00:00 AM | 2 | 3x3 | Permit Number 53102 | 6011983.41914 | 2112836.30852 | 37.7821207077455 | -122.402190501114 | (37.7821207077455, -122.402190501114) | 6 | 2 | 9 | 28853 | 34 | |
52742 | 220464 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 1900 Bryant St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6009491.00718 | 2105849.84781 | 37.7627980784028 | -122.410319710493 | (37.7627980784028, -122.410319710493) | 8 | 4 | 7 | 28859 | 19 | |||
52833 | 141981 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 961 Buchanan St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 0ft | 6004347.2458 | 2111841.6916 | 37.7789605439257 | -122.428537292711 | (37.7789605439257, -122.428537292711) | 7 | 9 | 11 | 29490 | 41 | |||
54520 | 203411 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 1945 08th Ave | 6 | Sidewalk: Curb side : Yard | Tree | Private 2 | 2 | Width 6ft | 5993801.54167 | 2102222.78745 | 37.7519471247661 | -122.464320280662 | (37.7519471247661, -122.464320280662) | 1 | 8 | 4 | 29491 | 12 | |||
54765 | 203417 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 57 Yerba Buena Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 2 | Width 4ft | 5993769.49059 | 2096990.17002 | 37.7375778308529 | -122.46405130512 | (37.7375778308529, -122.46405130512) | 1 | 8 | 4 | 59 | 40 | |||
54975 | 189092 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 1442 Galvez Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6016181.26551 | 2097468.21329 | 37.7401566215255 | -122.386595766675 | (37.7401566215255, -122.386595766675) | 10 | 3 | 8 | 58 | 1 |
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) );