trees
891 rows where qSpecies_id = 75 sorted by Police Districts
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
40161 | 88150 | Permitted Site 7 | Acer rubrum :: Red Maple 75 | 300X Clementina St | 1 | 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 | ||
40751 | 121505 | Planning Code 138.1 required 2 | Acer rubrum :: Red Maple 75 | 299 Fremont St | 5 | Sidewalk: Property side : Cutout | Tree | Private 2 | 5 | 10x4 | 6014377.50413 | 2115113.61118 | 37.7885069995398 | -122.394067461056 | (37.7885069995398, -122.394067461056) | 6 | 2 | 9 | 28855 | 6 | |||
41561 | 48548 | Permitted Site 7 | Acer rubrum :: Red Maple 75 | 630(REVISED) 08th St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/22/2002 12:00:00 AM | Permit Number 45867 | 6011089.0530694 | 2108751.21155661 | 37.7708540159333 | -122.404996898488 | (37.7708540159333, -122.404996898488) | 14 | 2 | 9 | 28853 | 34 | |||
42019 | 88168 | Permitted Site 7 | Acer rubrum :: Red Maple 75 | 366 Clementina St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/08/2008 12:00:00 AM | 3x3 | Permit Number 51186 | 6011675 | 2112537 | 37.7812816562818 | -122.403236436508 | (37.7812816562818, -122.403236436508) | 6 | 2 | 9 | 28853 | 34 | ||
42633 | 118377 | Planning Code 138.1 required 2 | Acer rubrum :: Red Maple 75 | 340 Fremont St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4x6 | 6014683 | 2114666 | 37.7872949366988 | -122.392979154362 | (37.7872949366988, -122.392979154362) | 6 | 2 | 9 | 28855 | 6 | ||||
42965 | 49242 | Permitted Site 7 | Acer rubrum :: Red Maple 75 | 500 Howard St | 15 | 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 | |||
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 | |||
44124 | 187938 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 235 01st St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 4ft | 6014012.10729 | 2114977.49045 | 37.7881129283138 | -122.395322147516 | (37.7881129283138, -122.395322147516) | 6 | 2 | 9 | 28855 | 6 | |||
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 | |||
46657 | 121543 | Planning Code 138.1 required 2 | Acer rubrum :: Red Maple 75 | 318 Main St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8x15 | 6015095 | 2115307 | 37.7890778525244 | -122.391598542205 | (37.7890778525244, -122.391598542205) | 6 | 2 | 9 | 28855 | 6 | ||||
47304 | 256005 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 302 Main St | 5 | Sidewalk: Curb side : Yard | Tree | Private 2 | 6015252.9594 | 2115128.97629 | 37.7885978067978 | -122.391039570534 | (37.7885978067978, -122.391039570534) | 6 | 2 | 9 | 28855 | 6 | |||||
47438 | 107155 | Undocumented 4 | Acer rubrum :: Red Maple 75 | 275 Spear St | 3 | 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 | ||||
47592 | 48549 | Permitted Site 7 | Acer rubrum :: Red Maple 75 | 630(REVISED) 08th St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/22/2002 12:00:00 AM | Permit Number 45867 | 6011089.0530694 | 2108751.21155661 | 37.7708540159333 | -122.404996898488 | (37.7708540159333, -122.404996898488) | 14 | 2 | 9 | 28853 | 34 | |||
47707 | 254263 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 66 Lansing St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 6014289.84402 | 2114150.25322 | 37.7858569681792 | -122.394303277683 | (37.7858569681792, -122.394303277683) | 6 | 2 | 9 | 28855 | 6 | ||||
48226 | 121547 | Planning Code 138.1 required 2 | Acer rubrum :: Red Maple 75 | 318 Main St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8x15 | 6015095 | 2115307 | 37.7890778525244 | -122.391598542205 | (37.7890778525244, -122.391598542205) | 6 | 2 | 9 | 28855 | 6 | ||||
48410 | 255900 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 660 Bryant St | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/23/2007 12:00:00 AM | 3x3 | 6012744.76196 | 2111515.06694 | 37.7785353494244 | -122.399463794931 | (37.7785353494244, -122.399463794931) | 6 | 2 | 9 | 28856 | 34 | |||
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 | |
52360 | 189059 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 925 Bryant St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6011015.17329 | 2109787.29138 | 37.7736947229667 | -122.405325426246 | (37.7736947229667, -122.405325426246) | 14 | 2 | 9 | 28853 | 34 | |||
53211 | 49231 | Permitted Site 7 | Acer rubrum :: Red Maple 75 | 500 Howard St | 12 | 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 | |||
56780 | 189071 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 1157 Bryant St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6009822.97122 | 2108648.63961 | 37.7705015217488 | -122.40936908392 | (37.7705015217488, -122.40936908392) | 8 | 2 | 9 | 28853 | 34 | |||
58649 | 88170 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 360 Clementina St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/08/2008 12:00:00 AM | 2 | 3x3 | Permit Number 51186 | 6011731.58168 | 2112591.71808 | 37.781435059217 | -122.403044540485 | (37.781435059217, -122.403044540485) | 6 | 2 | 9 | 28853 | 34 | |
60187 | 115352 | Planning Code 138.1 required 2 | Acer rubrum :: Red Maple 75 | 399 Fremont St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/28/2016 12:00:00 AM | 3 | 4x10 | Permit Number 773314 | 6014845.33617 | 2114621.37484 | 37.7871814222392 | -122.392414378515 | (37.7871814222392, -122.392414378515) | 6 | 2 | 9 | 28855 | 6 | |
60353 | 187962 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 787 Bryant St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6011933.30583 | 2110670.66458 | 37.7761715530167 | -122.402211564127 | (37.7761715530167, -122.402211564127) | 14 | 2 | 9 | 28856 | 34 | |||
61065 | 189076 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 1047 Bryant St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 2ft | 6010179.59918 | 2108995.88933 | 37.7714749641405 | -122.408159994002 | (37.7714749641405, -122.408159994002) | 14 | 2 | 9 | 28853 | 34 | |||
63463 | 189060 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 670 08th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6011065.32352 | 2108759.62205 | 37.7708757827119 | -122.405079572281 | (37.7708757827119, -122.405079572281) | 14 | 2 | 9 | 28853 | 34 | |||
64187 | 107152 | Undocumented 4 | Acer rubrum :: Red Maple 75 | 275 Spear St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | In front of Gap Inc. | 6015276.38031 | 2115978.63581 | 37.7909320761837 | -122.391017946268 | (37.7909320761837, -122.391017946268) | 6 | 2 | 9 | 28855 | 6 | |||
64723 | 118378 | Planning Code 138.1 required 2 | Acer rubrum :: Red Maple 75 | 340 Fremont St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4x6 | 6014683 | 2114666 | 37.7872949366988 | -122.392979154362 | (37.7872949366988, -122.392979154362) | 6 | 2 | 9 | 28855 | 6 | ||||
65353 | 115355 | Planning Code 138.1 required 2 | Acer rubrum :: Red Maple 75 | 399 Fremont St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/28/2016 12:00:00 AM | 3 | 4x10 | Permit Number 773314 | 6014786.34664 | 2114681.69198 | 37.7873437633547 | -122.392622692086 | (37.7873437633547, -122.392622692086) | 6 | 2 | 9 | 28855 | 6 | |
65557 | 189072 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 1111 Bryant St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6009937.54757 | 2108756.65629 | 37.7708045294385 | -122.408980384349 | (37.7708045294385, -122.408980384349) | 8 | 2 | 9 | 28853 | 34 | |||
66465 | 86610 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 1174 Bryant St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 09/20/2012 12:00:00 AM | 3 | 3x3 | 6009792 | 2108692 | 37.7706188440328 | -122.409479274697 | (37.7706188440328, -122.409479274697) | 8 | 2 | 9 | 28853 | 34 | ||
66507 | 121501 | Planning Code 138.1 required 2 | Acer rubrum :: Red Maple 75 | 299 Fremont St | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | 4 | 10x4 | 6014441.60375 | 2115047.86993 | 37.7883300516388 | -122.393841081021 | (37.7883300516388, -122.393841081021) | 6 | 2 | 9 | 28855 | 6 | |||
66781 | 187921 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 48 Minna St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6013082.09278 | 2115028.00052 | 37.7881998495857 | -122.398543403948 | (37.7881998495857, -122.398543403948) | 12 | 2 | 9 | 28855 | 6 | |||
67060 | 88172 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 360 Clementina St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/08/2008 12:00:00 AM | 2 | 3x3 | Permit Number 51186 | 6011709.51547 | 2112571.62711 | 37.7813786618321 | -122.403119465684 | (37.7813786618321, -122.403119465684) | 6 | 2 | 9 | 28853 | 34 | |
68507 | 255556 | Undocumented 4 | Acer rubrum :: Red Maple 75 | 100x Fremont St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6013542 | 2115679 | 37.7900129533755 | -122.396997853926 | (37.7900129533755, -122.396997853926) | 12 | 2 | 9 | 28855 | 6 | ||||
68525 | 86683 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 925 Bryant St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/09/2007 12:00:00 AM | 3 | 3x3 | 6011000.86666 | 2109774.4042 | 37.7736585378513 | -122.405374007613 | (37.7736585378513, -122.405374007613) | 14 | 2 | 9 | 28853 | 34 | ||
70059 | 118374 | Planning Code 138.1 required 2 | Acer rubrum :: Red Maple 75 | 340 Fremont St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | 4x6 | 6014693.17098 | 2114681.80971 | 37.787338911495 | -122.392945071183 | (37.787338911495, -122.392945071183) | 6 | 2 | 9 | 28855 | 6 | |||
71462 | 187943 | Planning Code 138.1 required 2 | Acer rubrum :: Red Maple 75 | 300 Main St | 4 | Sidewalk: Curb side : Yard | Tree | Private 2 | 3 | 6015093.73077 | 2115293.30797 | 37.7890401869059 | -122.391601975949 | (37.7890401869059, -122.391601975949) | 6 | 2 | 9 | 28855 | 6 | ||||
73578 | 187945 | Planning Code 138.1 required 2 | Acer rubrum :: Red Maple 75 | 300 Main St | 6 | Sidewalk: Curb side : Yard | Tree | Private 2 | 3 | 6015129.76051 | 2115255.3706 | 37.7889380194338 | -122.391474663423 | (37.7889380194338, -122.391474663423) | 6 | 2 | 9 | 28855 | 6 | ||||
73605 | 189062 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 670 08th St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6011094.42559 | 2108729.00589 | 37.7707933445767 | -122.404976750984 | (37.7707933445767, -122.404976750984) | 14 | 2 | 9 | 28853 | 34 | |||
73712 | 121545 | Planning Code 138.1 required 2 | Acer rubrum :: Red Maple 75 | 318 Main St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8x15 | 6015095 | 2115307 | 37.7890778525244 | -122.391598542205 | (37.7890778525244, -122.391598542205) | 6 | 2 | 9 | 28855 | 6 | ||||
73863 | 255534 | Undocumented 4 | Acer rubrum :: Red Maple 75 | 101 01st St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6013390 | 2115602 | 37.7897930671001 | -122.397518362151 | (37.7897930671001, -122.397518362151) | 12 | 2 | 9 | 28855 | 6 | ||||
75283 | 118380 | Planning Code 138.1 required 2 | Acer rubrum :: Red Maple 75 | 340 Fremont St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4x6 | 6014683 | 2114666 | 37.7872949366988 | -122.392979154362 | (37.7872949366988, -122.392979154362) | 6 | 2 | 9 | 28855 | 6 | ||||
76630 | 187902 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 47 Fremont St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 5ft | 6013611.03319 | 2115912.70701 | 37.790658500748 | -122.396775394381 | (37.790658500748, -122.396775394381) | 12 | 2 | 9 | 28855 | 6 | |||
76990 | 255558 | Undocumented 4 | Acer rubrum :: Red Maple 75 | 100x Fremont St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6013542 | 2115679 | 37.7900129533755 | -122.396997853926 | (37.7900129533755, -122.396997853926) | 12 | 2 | 9 | 28855 | 6 | ||||
77538 | 38793 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 655 Bryant St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/23/1998 12:00:00 AM | 6 | Permit Number 40642 | 6012718.22828 | 2111411.20954 | 37.7782487018563 | -122.399548292025 | (37.7782487018563, -122.399548292025) | 6 | 2 | 9 | 28856 | 34 | ||
79448 | 88153 | Permitted Site 7 | Acer rubrum :: Red Maple 75 | 300X Clementina St | 4 | 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 | ||
79511 | 116155 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 167X Jessie St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/29/2016 12:00:00 AM | 3 | 3x3 | Permit Number 777681 | 6011953.87529 | 2114523.89639 | 37.7867527801633 | -122.402411408766 | (37.7867527801633, -122.402411408766) | 12 | 2 | 9 | 28855 | 6 | |
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 | ||||
81278 | 187904 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 167 Jessie St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6011967.30497 | 2114536.37936 | 37.7867878051538 | -122.402365823018 | (37.7867878051538, -122.402365823018) | 12 | 2 | 9 | 28855 | 6 | |||
84101 | 255881 | Undocumented 4 | Acer rubrum :: Red Maple 75 | 50 Columbia Square St | 2 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | Private | 3x3 | 6010942 | 2111079 | 37.7772373644855 | -122.405669544588 | (37.7772373644855, -122.405669544588) | 14 | 2 | 9 | 28853 | 34 | |||
84469 | 187953 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 340 Fremont St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6014758.29255 | 2114615.93494 | 37.7871616515452 | -122.392715152285 | (37.7871616515452, -122.392715152285) | 6 | 2 | 9 | 28855 | 6 | |||
85317 | 42181 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 649 Bryant St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/21/2000 12:00:00 AM | 4 | Permit Number 42465 | 6012754.97243 | 2111452.86272 | 37.7783651199972 | -122.399424104664 | (37.7783651199972, -122.399424104664) | 6 | 2 | 9 | 28856 | 34 | |
86255 | 189073 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 1111 Bryant St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6009955.51496 | 2108774.33829 | 37.7708540865838 | -122.40891948225 | (37.7708540865838, -122.40891948225) | 8 | 2 | 9 | 28853 | 34 | |||
86808 | 255533 | Undocumented 4 | Acer rubrum :: Red Maple 75 | 101 01st St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6013390 | 2115602 | 37.7897930671001 | -122.397518362151 | (37.7897930671001, -122.397518362151) | 12 | 2 | 9 | 28855 | 6 | ||||
87245 | 189074 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 1111 Bryant St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6009972.16733 | 2108791.01573 | 37.770900811749 | -122.408863057891 | (37.770900811749, -122.408863057891) | 8 | 2 | 9 | 28853 | 34 | |||
87322 | 62024 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 427 Bryant St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/13/1985 12:00:00 AM | 5 | Permit Number 22097 | 6014298.34567 | 2112925.54615 | 37.7824946755423 | -122.394188090731 | (37.7824946755423, -122.394188090731) | 6 | 2 | 9 | 28856 | 6 | ||
87946 | 101990 | Permitted Site 7 | Acer rubrum :: Red Maple 75 | 25 Essex St | 1 | 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 | ||||
88090 | 85806 | Planning Code 138.1 required 2 | Acer rubrum :: Red Maple 75 | 210X Shipley St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/05/2017 12:00:00 AM | 3 | 2.5x6 | Permit Number 778048 | 6011627 | 2111882 | 37.7794804977568 | -122.403356401218 | (37.7794804977568, -122.403356401218) | 14 | 2 | 9 | 28856 | 34 | |
89005 | 86671 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 1155 Bryant St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/09/2007 12:00:00 AM | 3 | 3x3 | 6009854.63379 | 2108677.64485 | 37.7705829373798 | -122.409261609551 | (37.7705829373798, -122.409261609551) | 8 | 2 | 9 | 28853 | 34 | ||
91194 | 187903 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 47 Fremont St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 5ft | 6013582.62491 | 2115938.98616 | 37.7907290759442 | -122.396875529384 | (37.7907290759442, -122.396875529384) | 12 | 2 | 9 | 28855 | 6 | |||
91455 | 85807 | Planning Code 138.1 required 2 | Acer rubrum :: Red Maple 75 | 210X Shipley St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/05/2017 12:00:00 AM | 3 | 2.5x6 | Permit Number 778048 | 6011604 | 2111950 | 37.7796659253507 | -122.403440753721 | (37.7796659253507, -122.403440753721) | 14 | 2 | 9 | 28856 | 34 | |
93643 | 187959 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 43 Lansing St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6014377.78304 | 2114198.9625 | 37.7859956004712 | -122.39400244187 | (37.7859956004712, -122.39400244187) | 6 | 2 | 9 | 28855 | 6 | |||
93681 | 187925 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 11 Natoma St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 5ft | 6013571.0237 | 2115195.4234 | 37.7886867803215 | -122.396863516254 | (37.7886867803215, -122.396863516254) | 12 | 2 | 9 | 28855 | 6 | |||
94095 | 187920 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 48 Minna St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6013088.63275 | 2115034.82195 | 37.7882189439825 | -122.398521255459 | (37.7882189439825, -122.398521255459) | 12 | 2 | 9 | 28855 | 6 | |||
95882 | 187912 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 5 Natoma St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 5ft | 6013728.03817 | 2115347.11788 | 37.7891120364521 | -122.396330901758 | (37.7891120364521, -122.396330901758) | 12 | 2 | 9 | 28855 | 6 | |||
97512 | 256006 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 302 Main St | 6 | Sidewalk: Curb side : Yard | Tree | Private 2 | 6015252.9594 | 2115128.97629 | 37.7885978067978 | -122.391039570534 | (37.7885978067978, -122.391039570534) | 6 | 2 | 9 | 28855 | 6 | |||||
98992 | 88176 | Permitted Site 7 | Acer rubrum :: Red Maple 75 | 366 Clementina St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/08/2008 12:00:00 AM | 3x3 | Permit Number 51186 | 6011675 | 2112537 | 37.7812816562818 | -122.403236436508 | (37.7812816562818, -122.403236436508) | 6 | 2 | 9 | 28853 | 34 | ||
99183 | 108062 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 333 Fremont St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/19/2014 12:00:00 AM | 3 | Permit Number 770030 | 6014690.02107 | 2114784.12371 | 37.7876196672567 | -122.392963130455 | (37.7876196672567, -122.392963130455) | 6 | 2 | 9 | 28855 | 6 | ||
99247 | 86672 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 1155 Bryant St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/09/2007 12:00:00 AM | 3 | 3x3 | 6009883.68707 | 2108705.67197 | 37.7706615210422 | -122.409163091525 | (37.7706615210422, -122.409163091525) | 8 | 2 | 9 | 28853 | 34 | ||
100478 | 50680 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 320 Clementina St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/07/2004 12:00:00 AM | 2 | Permit Number 47253 | 6011881.28809 | 2112735.18958 | 37.7818373574415 | -122.40253671761 | (37.7818373574415, -122.40253671761) | 6 | 2 | 9 | 28853 | 34 | ||
101037 | 115350 | Planning Code 138.1 required 2 | Acer rubrum :: Red Maple 75 | 399 Fremont St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/28/2016 12:00:00 AM | 3 | 4x10 | Permit Number 773314 | 6014880.23802 | 2114582.9179 | 37.7870777663613 | -122.392290933986 | (37.7870777663613, -122.392290933986) | 6 | 2 | 9 | 28855 | 6 | |
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 | ||
101731 | 86688 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 833 Bryant St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/09/2007 12:00:00 AM | 3 | 3x3 | 6011619.91608 | 2110365.80085 | 37.7753169695418 | -122.403274219231 | (37.7753169695418, -122.403274219231) | 14 | 2 | 9 | 28853 | 34 | ||
102686 | 107153 | Undocumented 4 | Acer rubrum :: Red Maple 75 | 275 Spear St | 2 | 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 | ||||
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 | |
105887 | 88193 | Permitted Site 7 | Acer rubrum :: Red Maple 75 | 364 Tehama St | 2 | 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 | ||
106727 | 49229 | Permitted Site 7 | Acer rubrum :: Red Maple 75 | 500 Howard St | 17 | 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 | |||
107686 | 86673 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 1157 Bryant St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/09/2007 12:00:00 AM | 3 | 3x3 | 6009836.98822 | 2108663.0502 | 37.770541875235 | -122.409321615924 | (37.770541875235, -122.409321615924) | 8 | 2 | 9 | 28853 | 34 | ||
109095 | 189058 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 811 Bryant St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6011753.69364 | 2110494.1907 | 37.7756769690586 | -122.402820480686 | (37.7756769690586, -122.402820480686) | 14 | 2 | 9 | 28853 | 34 | |||
110028 | 189083 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 320 Clementina St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6011822.07431 | 2112680.25228 | 37.7816832064575 | -122.402737706174 | (37.7816832064575, -122.402737706174) | 6 | 2 | 9 | 28853 | 34 | |||
110293 | 187913 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 5 Natoma St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 5ft | 6013740.8132 | 2115359.33428 | 37.7891462907102 | -122.396287558027 | (37.7891462907102, -122.396287558027) | 12 | 2 | 9 | 28855 | 6 | |||
110442 | 255559 | Undocumented 4 | Acer rubrum :: Red Maple 75 | 100x Fremont St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6013542 | 2115679 | 37.7900129533755 | -122.396997853926 | (37.7900129533755, -122.396997853926) | 12 | 2 | 9 | 28855 | 6 | ||||
110523 | 251505 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 360 Clementina St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6011658.68026 | 2112523.02352 | 37.7812423686803 | -122.403291911611 | (37.7812423686803, -122.403291911611) | 6 | 2 | 9 | 28853 | 34 | ||||
110784 | 255532 | Undocumented 4 | Acer rubrum :: Red Maple 75 | 101 01st St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6013390 | 2115602 | 37.7897930671001 | -122.397518362151 | (37.7897930671001, -122.397518362151) | 12 | 2 | 9 | 28855 | 6 | ||||
110801 | 187940 | Planning Code 138.1 required 2 | Acer rubrum :: Red Maple 75 | 300 Main St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 3 | 6015048.62855 | 2115342.19505 | 37.7891719160015 | -122.391761444649 | (37.7891719160015, -122.391761444649) | 6 | 2 | 9 | 28855 | 6 | ||||
111090 | 187957 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 81 Lansing St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6014291 | 2114089 | 37.7856888451687 | -122.394294988121 | (37.7856888451687, -122.394294988121) | 6 | 2 | 9 | 28855 | 6 | |||
112204 | 49215 | Permitted Site 7 | Acer rubrum :: Red Maple 75 | 500 Howard St | 25 | 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 | |||
112715 | 187934 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 211 Spear St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 2ft | 6015195.69866 | 2115800.94411 | 37.7904396983948 | -122.391284677144 | (37.7904396983948, -122.391284677144) | 6 | 2 | 9 | 28855 | 6 | |||
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 | |||
113203 | 88173 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 360 Clementina St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/08/2008 12:00:00 AM | 2 | 3x3 | Permit Number 51186 | 6011687.76515 | 2112550.16033 | 37.7813185043866 | -122.40319320113 | (37.7813185043866, -122.40319320113) | 6 | 2 | 9 | 28853 | 34 | |
114155 | 48551 | Permitted Site 7 | Acer rubrum :: Red Maple 75 | 630(REVISED) 08th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/22/2002 12:00:00 AM | Permit Number 45867 | 6011089.0530694 | 2108751.21155661 | 37.7708540159333 | -122.404996898488 | (37.7708540159333, -122.404996898488) | 14 | 2 | 9 | 28853 | 34 | |||
115115 | 52842 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 50 Lansing St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/22/2006 12:00:00 AM | 5 | 3x3 | Permit Number 48860 | 6014392.61709 | 2114247.39936 | 37.7861294213868 | -122.393954511599 | (37.7861294213868, -122.393954511599) | 6 | 2 | 9 | 28855 | 6 | |
115823 | 187927 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 11 Natoma St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 5ft | 6013603.72769 | 2115224.95515 | 37.7887696879241 | -122.396752435596 | (37.7887696879241, -122.396752435596) | 12 | 2 | 9 | 28855 | 6 | |||
116898 | 115354 | Planning Code 138.1 required 2 | Acer rubrum :: Red Maple 75 | 399 Fremont St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/28/2016 12:00:00 AM | 3 | 4x10 | Permit Number 773314 | 6014804.62773 | 2114662.16926 | 37.7872911737029 | -122.39255807669 | (37.7872911737029, -122.39255807669) | 6 | 2 | 9 | 28855 | 6 | |
117838 | 121542 | Planning Code 138.1 required 2 | Acer rubrum :: Red Maple 75 | 318 Main St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8x15 | 6015095 | 2115307 | 37.7890778525244 | -122.391598542205 | (37.7890778525244, -122.391598542205) | 6 | 2 | 9 | 28855 | 6 | ||||
119049 | 107156 | Undocumented 4 | Acer rubrum :: Red Maple 75 | 275 Spear St | 5 | 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 | ||||
119860 | 88154 | Permitted Site 7 | Acer rubrum :: Red Maple 75 | 300X Clementina St | 5 | 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 | ||
120325 | 112085 | Planning Code 138.1 required 2 | Acer rubrum :: Red Maple 75 | 99X Fremont St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/23/2015 12:00:00 AM | Permit Number 775592 | 6013631.8 | 2115864.7 | 37.7905278405438 | -122.396700174955 | (37.7905278405438, -122.396700174955) | 12 | 2 | 9 | 28855 | 6 | |||
120509 | 49228 | Permitted Site 7 | Acer rubrum :: Red Maple 75 | 500 Howard St | 22 | 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 | |||
120636 | 121503 | Planning Code 138.1 required 2 | Acer rubrum :: Red Maple 75 | 299 Fremont St | 3 | Sidewalk: Property side : Cutout | Tree | Private 2 | 5 | 10x4 | 6014412.49464 | 2115075.87435 | 37.7884053276005 | -122.393943755694 | (37.7884053276005, -122.393943755694) | 6 | 2 | 9 | 28855 | 6 |
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) );