trees
467 rows where Police Districts = 7 and qSpecies_id = 8 sorted by Fire Prevention 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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1085 | 223588 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 890x Jarboe Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 2 | Width 3ft | 6009063.07444 | 2096876.26549 | 37.7381346254237 | -122.411165877211 | (37.7381346254237, -122.411165877211) | 10 | 7 | 7 | 28859 | 2 | |||
4986 | 51031 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1085 Girard St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/08/2004 12:00:00 AM | 6 | Permit Number 47506 | 6011820.57141 | 2089923.66488 | 37.7191984823926 | -122.401143367398 | (37.7191984823926, -122.401143367398) | 10 | 7 | 8 | 309 | 28 | ||
9295 | 223587 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 890x Jarboe Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 2 | Width 3ft | 6009072.26343 | 2096875.24392 | 37.7381323357409 | -122.411134034011 | (37.7381323357409, -122.411134034011) | 10 | 7 | 7 | 28859 | 2 | |||
10072 | 223589 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 590X Jarboe Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6008529.06402 | 2096927.29731 | 37.7382447851783 | -122.413015832133 | (37.7382447851783, -122.413015832133) | 10 | 7 | 7 | 28859 | 2 | |||
17045 | 176247 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 10 Ordway St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6011833.80931 | 2090345.75054 | 37.7203581824627 | -122.401127251532 | (37.7203581824627, -122.401127251532) | 10 | 7 | 8 | 309 | 28 | |||
23922 | 58026 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 680 Prentiss St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/26/1987 12:00:00 AM | Permit Number 16994 | 6008648.68681502 | 2095709.61951023 | 37.7349080209093 | -122.412516183192 | (37.7349080209093, -122.412516183192) | 10 | 7 | 7 | 28859 | 2 | ||
26465 | 176246 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 10 Ordway St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6011847.19322 | 2090350.44098 | 37.7203718080967 | -122.401081316846 | (37.7203718080967, -122.401081316846) | 10 | 7 | 8 | 309 | 28 | |||
30817 | 51030 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1085 Girard St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/08/2004 12:00:00 AM | 5 | Permit Number 47506 | 6011828.2745 | 2089900.62278 | 37.7191356431884 | -122.401115122362 | (37.7191356431884, -122.401115122362) | 10 | 7 | 8 | 309 | 28 | ||
42001 | 223564 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 130 Nevada St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 9 | Width 3ft | 6009029.83515 | 2097858.62477 | 37.7408301058168 | -122.411350181559 | (37.7408301058168, -122.411350181559) | 10 | 7 | 7 | 28859 | 2 | |||
42579 | 176250 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 3562 San Bruno Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6012131.39961 | 2089120.6063 | 37.7170107808051 | -122.400012580531 | (37.7170107808051, -122.400012580531) | 10 | 7 | 8 | 309 | 39 | |||
43410 | 176244 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 10 Ordway St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6011881.09111 | 2090360.91966 | 37.7204024713802 | -122.400964878027 | (37.7204024713802, -122.400964878027) | 10 | 7 | 8 | 309 | 28 | |||
50780 | 176252 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 95 Delta St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6010107.1247 | 2089599.03617 | 37.7182113811213 | -122.407043259958 | (37.7182113811213, -122.407043259958) | 10 | 7 | 8 | 309 | 39 | |||
53101 | 34891 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 95 Ward St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/22/1997 12:00:00 AM | Permit Number 38498 | 6011846.48740204 | 2089823.39477464 | 37.7189246067483 | -122.401046743519 | (37.7189246067483, -122.401046743519) | 10 | 7 | 8 | 309 | 39 | |||
59880 | 49496 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 2X ORDWAY ST | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/21/2003 12:00:00 AM | 16 | 3x3 | Permit Number 46411 | 6011821 | 2090323 | 37.720294999502 | -122.401169931587 | (37.720294999502, -122.401169931587) | 10 | 7 | 8 | 309 | 28 | |
70626 | 223482 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 4044 Folsom St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 2ft | 6008350.87212 | 2096284.49377 | 37.7364697824441 | -122.413586482552 | (37.7364697824441, -122.413586482552) | 10 | 7 | 7 | 28859 | 2 | |||
71396 | 66453 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 125 Nevada St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/09/1991 12:00:00 AM | Permit Number 29603 | 6009081.83261092 | 2097914.76259057 | 37.7409871642392 | -122.411174357607 | (37.7409871642392, -122.411174357607) | 10 | 7 | 7 | 28859 | 2 | ||
84067 | 223485 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 125 Nevada St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 2ft | 6009074.65326 | 2097933.54072 | 37.7410383222477 | -122.411200507415 | (37.7410383222477, -122.411200507415) | 10 | 7 | 7 | 28859 | 2 | |||
85918 | 84126 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1045 Girard St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/05/2008 12:00:00 AM | 6 | 3x3 | Permit Number 50691 | 6011772.83718 | 2090087.8836 | 37.7196467305931 | -122.401319901612 | (37.7196467305931, -122.401319901612) | 10 | 7 | 8 | 309 | 28 | |
88817 | 223483 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 562 Banks St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 2ft | 6008521.06241 | 2096162.71972 | 37.7361449725004 | -122.412989453223 | (37.7361449725004, -122.412989453223) | 10 | 7 | 7 | 28859 | 2 | |||
91912 | 107688 | Undocumented 4 | Eriobotrya deflexa :: Bronze Loquat 8 | 300X ALEMANY BLVD | 2 | Sidewalk: Property side : Cutout | Tree | Private 2 | 16 | 6008820.4 | 2095497.5 | 37.7343352217744 | -122.411907523711 | (37.7343352217744, -122.411907523711) | 10 | 7 | 7 | 28859 | 2 | ||||
92062 | 52985 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 483 Harkness Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/08/2006 12:00:00 AM | 5 | Permit Number 48967 | 6010218.63808 | 2089641.81604 | 37.7183350855707 | -122.406660816961 | (37.7183350855707, -122.406660816961) | 10 | 7 | 8 | 309 | 39 | ||
99650 | 28257 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 3508X San Bruno Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/08/2014 12:00:00 AM | 3 | 3x3 | 6012088.3375369 | 2089388.4108582 | 37.7177437172214 | -122.400180224111 | (37.7177437172214, -122.400180224111) | 10 | 7 | 8 | 309 | 39 | ||
104269 | 223565 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 134 Nevada St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 10 | Width 3ft | 6009029.93492 | 2097846.57394 | 37.7407970224666 | -122.411348985471 | (37.7407970224666, -122.411348985471) | 10 | 7 | 7 | 28859 | 2 | |||
106857 | 111194 | Section 143 10 | Eriobotrya deflexa :: Bronze Loquat 8 | 890x JARBOE AVE | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/30/2015 12:00:00 AM | 3x3 | Permit Number 774267 | 6009115 | 2096842 | 37.7380434517433 | -122.410983924329 | (37.7380434517433, -122.410983924329) | 10 | 7 | 7 | 28859 | 2 | ||
109380 | 111193 | Section 143 10 | Eriobotrya deflexa :: Bronze Loquat 8 | 890x JARBOE AVE | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/30/2015 12:00:00 AM | 1 | 3x3 | Permit Number 774267 | 6009115 | 2096842 | 37.7380434517433 | -122.410983924329 | (37.7380434517433, -122.410983924329) | 10 | 7 | 7 | 28859 | 2 | |
116544 | 176243 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 10 Ordway St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6011901.96297 | 2090368.71329 | 37.7204250353617 | -122.400893277618 | (37.7204250353617, -122.400893277618) | 10 | 7 | 8 | 309 | 28 | |||
127843 | 64026 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 907 Crescent Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/09/1987 12:00:00 AM | Permit Number 24783 | 6008326.13361224 | 2095676.92812978 | 37.7348001501968 | -122.413629054856 | (37.7348001501968, -122.413629054856) | 10 | 7 | 7 | 28859 | 2 | ||
129567 | 1769 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 2000X Bay Shore Blvd | 9 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 06/11/2011 12:00:00 AM | 3 | 3x3 | 6012375.8565272 | 2088505.2474917 | 37.7153347551878 | -122.399124435859 | (37.7153347551878, -122.399124435859) | 10 | 7 | 8 | 309 | 39 | ||
131630 | 176237 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 2014 Bay Shore Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 2ft | 6012237.04254 | 2088170.85532 | 37.7144088442801 | -122.399580777334 | (37.7144088442801, -122.399580777334) | 10 | 7 | 8 | 309 | 39 | |||
133094 | 223484 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 331 Prentiss St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 2ft | 6008833.18151 | 2097272.60976 | 37.7392100050437 | -122.411988736185 | (37.7392100050437, -122.411988736185) | 10 | 7 | 7 | 28859 | 2 | |||
133530 | 223590 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 500 Jarboe Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6008475.14451 | 2096933.16197 | 37.7382578613013 | -122.413202674371 | (37.7382578613013, -122.413202674371) | 10 | 7 | 7 | 28859 | 2 | |||
136780 | 52253 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 477 Harkness Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/22/2005 12:00:00 AM | 6 | Permit Number 48420 | 6010242.54537 | 2089633.75943 | 37.7183143013438 | -122.406577611683 | (37.7183143013438, -122.406577611683) | 10 | 7 | 8 | 309 | 39 | ||
141956 | 84009 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 980 Girard St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/05/2008 12:00:00 AM | 6 | 3x3 | Permit Number 50690 | 6011658.3598 | 2090351.5567 | 37.7203643356392 | -122.401734134722 | (37.7203643356392, -122.401734134722) | 10 | 7 | 8 | 309 | 28 | |
144392 | 87531 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 3508X San Bruno Ave | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/08/2014 12:00:00 AM | 3 | 3x3 | 6012093.266153 | 2089389.252949 | 37.7177463042476 | -122.400163247094 | (37.7177463042476, -122.400163247094) | 10 | 7 | 8 | 309 | 39 | ||
147861 | 223562 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 441 Banks St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6008607.93103 | 2096810.15163 | 37.737927555622 | -122.412734868636 | (37.737927555622, -122.412734868636) | 10 | 7 | 7 | 28859 | 2 | |||
150018 | 223563 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 316 Prentiss St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6008805.99519 | 2097308.94516 | 37.7393082487838 | -122.412085301813 | (37.7393082487838, -122.412085301813) | 10 | 7 | 7 | 28859 | 2 | |||
153244 | 176248 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 3500 San Bruno Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/08/2014 12:00:00 AM | 1 | Width 3ft | 6012084.62968 | 2089393.6592 | 37.7177579213627 | -122.400193408991 | (37.7177579213627, -122.400193408991) | 10 | 7 | 8 | 309 | 39 | ||
153447 | 49497 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 2X ORDWAY ST | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/21/2003 12:00:00 AM | 7 | 3x3 | Permit Number 46411 | 6011821 | 2090323 | 37.720294999502 | -122.401169931587 | (37.720294999502, -122.401169931587) | 10 | 7 | 8 | 309 | 28 | |
160868 | 66455 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 134 Nevada St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/09/1991 12:00:00 AM | Permit Number 29605 | 6009024.9615405 | 2097864.85103927 | 37.7408469284457 | -122.411367472491 | (37.7408469284457, -122.411367472491) | 10 | 7 | 7 | 28859 | 2 | ||
162560 | 176253 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 95 Delta St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6010117.92765 | 2089629.2495 | 37.7182949452416 | -122.407008046982 | (37.7182949452416, -122.407008046982) | 10 | 7 | 8 | 309 | 39 | |||
165045 | 114647 | Private 9 | Eriobotrya deflexa :: Bronze Loquat 8 | 331 Prentiss St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/30/2015 12:00:00 AM | Permit Number 774946 | 6008851.6 | 2097283.6 | 37.7392412152063 | -122.41192582952 | (37.7392412152063, -122.41192582952) | 10 | 7 | 7 | 28859 | 2 | |||
166148 | 223561 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 441 Banks St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6008606.47777 | 2096794.40952 | 37.737884249652 | -122.412738780697 | (37.737884249652, -122.412738780697) | 10 | 7 | 7 | 28859 | 2 | |||
166764 | 96201 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 2000X Bay Shore Blvd | 13 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 06/11/2011 12:00:00 AM | 3 | 3x3 | 6012318.2 | 2088514.6 | 37.71535722204 | -122.399324379639 | (37.71535722204, -122.399324379639) | 10 | 7 | 8 | 309 | 39 | ||
167942 | 28261 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 3574 San Bruno Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 06/22/2011 12:00:00 AM | 3 | 3x3 | 6012138.7194258 | 2089093.5243211 | 37.7169368272436 | -122.399985378545 | (37.7169368272436, -122.399985378545) | 10 | 7 | 8 | 309 | 39 | ||
170210 | 176249 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 3500 San Bruno Ave | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/08/2014 12:00:00 AM | 1 | Width 3ft | 6012088.82637 | 2089370.3173 | 37.7176940632127 | -122.400177264384 | (37.7176940632127, -122.400177264384) | 10 | 7 | 8 | 309 | 39 | ||
172015 | 223566 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 144 Nevada St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 11 | Width 3ft | 6009026.08799 | 2097793.63743 | 37.7406514546128 | -122.411358547973 | (37.7406514546128, -122.411358547973) | 10 | 7 | 7 | 28859 | 2 | |||
172131 | 176254 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1101 Girard St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 6011871.08574 | 2089770.57713 | 37.7187809523661 | -122.400958007209 | (37.7187809523661, -122.400958007209) | 10 | 7 | 8 | 309 | 39 | |||
172148 | 176238 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 2018 Bay Shore Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 2ft | 6012153.04029 | 2088061.68652 | 37.7141044057814 | -122.399863463036 | (37.7141044057814, -122.399863463036) | 10 | 7 | 8 | 309 | 39 | |||
175482 | 49494 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 2X ORDWAY ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/21/2003 12:00:00 AM | 6 | 3x3 | Permit Number 46411 | 6011821 | 2090323 | 37.720294999502 | -122.401169931587 | (37.720294999502, -122.401169931587) | 10 | 7 | 8 | 309 | 28 | |
181410 | 34892 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 95 Ward St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/22/1997 12:00:00 AM | Permit Number 38498 | 6011846.48740204 | 2089823.39477464 | 37.7189246067483 | -122.401046743519 | (37.7189246067483, -122.401046743519) | 10 | 7 | 8 | 309 | 39 | |||
181745 | 49495 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 2X ORDWAY ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/21/2003 12:00:00 AM | 9 | 3x3 | Permit Number 46411 | 6011821 | 2090323 | 37.720294999502 | -122.401169931587 | (37.720294999502, -122.401169931587) | 10 | 7 | 8 | 309 | 28 | |
184359 | 49493 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 2X ORDWAY ST | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/21/2003 12:00:00 AM | 8 | 3x3 | Permit Number 46411 | 6011821 | 2090323 | 37.720294999502 | -122.401169931587 | (37.720294999502, -122.401169931587) | 10 | 7 | 8 | 309 | 28 | |
186402 | 66454 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 130 Nevada St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/09/1991 12:00:00 AM | Permit Number 29604 | 6009026.99951004 | 2097886.74358701 | 37.7409071549012 | -122.411361972152 | (37.7409071549012, -122.411361972152) | 10 | 7 | 7 | 28859 | 2 | ||
187784 | 176245 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 10 Ordway St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 3ft | 6011861.55971 | 2090354.44953 | 37.7203836161938 | -122.401031937775 | (37.7203836161938, -122.401031937775) | 10 | 7 | 8 | 309 | 28 | |||
814 | 261435 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 371 Crescent Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 6007244 | 2095778 | 37.7350168462428 | -122.417377534221 | (37.7350168462428, -122.417377534221) | 2 | 7 | 7 | 28859 | 2 | ||||
1037 | 63388 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 139 Crescent Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/10/1987 12:00:00 AM | Permit Number 23969 | 6005989.66886949 | 2095872.0431692 | 37.7352044148911 | -122.421720887046 | (37.7352044148911, -122.421720887046) | 2 | 7 | 7 | 28859 | 2 | ||
1140 | 223581 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 85 Bessie St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6008353.87265 | 2100058.32291 | 37.7468320543491 | -122.413842976384 | (37.7468320543491, -122.413842976384) | 2 | 7 | 7 | 28859 | 2 | |||
1327 | 261443 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 354 Crescent Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6007142 | 2095710 | 37.7348243937619 | -122.417725367022 | (37.7348243937619, -122.417725367022) | 2 | 7 | 7 | 28859 | 2 | ||||
1423 | 223556 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 701x Andover St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 3ft | 6007456 | 2095683 | 37.7347679226533 | -122.416637845271 | (37.7347679226533, -122.416637845271) | 2 | 7 | 7 | 28859 | 2 | |||
2215 | 49868 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 368 Bosworth St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/18/2003 12:00:00 AM | 3x3 | Permit Number 46634 | 6003577.84688999 | 2095267.92973361 | 37.7334093561858 | -122.430016351279 | (37.7334093561858, -122.430016351279) | 2 | 7 | 5 | 28861 | 25 | ||
4370 | 38420 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 1542 Church St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/21/2000 12:00:00 AM | Permit Number 42357 | 6004548.16357043 | 2099910.23270392 | 37.7462109701995 | -122.426992216906 | (37.7462109701995, -122.426992216906) | 2 | 7 | 5 | 63 | 22 | ||
6250 | 261442 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 364 Crescent Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6007175 | 2095707 | 37.7348180134015 | -122.417611061749 | (37.7348180134015, -122.417611061749) | 2 | 7 | 7 | 28859 | 2 | ||||
6331 | 261440 | Undocumented 4 | Eriobotrya deflexa :: Bronze Loquat 8 | 374x Crescent Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6007239 | 2095686 | 37.7347639531109 | -122.417388303298 | (37.7347639531109, -122.417388303298) | 2 | 7 | 7 | 28859 | 2 | ||||
6487 | 261445 | Planning Code 138.1 required 2 | Eriobotrya deflexa :: Bronze Loquat 8 | 339 Crescent Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6007092 | 2095790 | 37.7350412423636 | -122.417903903871 | (37.7350412423636, -122.417903903871) | 2 | 7 | 7 | 28859 | 2 | ||||
7067 | 223489 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 201x Tompkins Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 2ft | 6007880.65482 | 2096572.00473 | 37.73723280954 | -122.415232573728 | (37.73723280954, -122.415232573728) | 2 | 7 | 7 | 28859 | 2 | |||
7760 | 261189 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 599x Benton Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6007159 | 2095436 | 37.7340730065148 | -122.41764717788 | (37.7340730065148, -122.41764717788) | 2 | 7 | 7 | 28859 | 2 | ||||
8093 | 223555 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 701x Andover St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6007456 | 2095683 | 37.7347679226533 | -122.416637845271 | (37.7347679226533, -122.416637845271) | 2 | 7 | 7 | 28859 | 2 | |||
8415 | 96169 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 45 Wool St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/08/2011 12:00:00 AM | 3x3 | Permit Number 767802 | 6007419 | 2097998 | 37.7411223211925 | -122.416929733801 | (37.7411223211925, -122.416929733801) | 2 | 7 | 7 | 28859 | 2 | |
8681 | 223586 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 10x Tompkins Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6007519 | 2096543 | 37.7371328370553 | -122.416480929712 | (37.7371328370553, -122.416480929712) | 2 | 7 | 7 | 28859 | 2 | |||
8760 | 28315 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 739 Cortland Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/30/2017 12:00:00 AM | 3 | 3x3 | Permit Number 780585 | 6008002.89443 | 2097198.99062 | 37.7389612444527 | -122.414854295516 | (37.7389612444527, -122.414854295516) | 2 | 7 | 7 | 28859 | 2 | |
9157 | 261444 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 350 Crescent Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6007112 | 2095712 | 37.7348281970622 | -122.417829229388 | (37.7348281970622, -122.417829229388) | 2 | 7 | 7 | 28859 | 2 | ||||
9542 | 261434 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 383 Crescent Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 6007317 | 2095771 | 37.7350017327518 | -122.417124650781 | (37.7350017327518, -122.417124650781) | 2 | 7 | 7 | 28859 | 2 | ||||
9689 | 63382 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 261 Crescent Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/10/1987 12:00:00 AM | Permit Number 23962 | 6006733.60001952 | 2095809.91850213 | 37.7350757572483 | -122.41914443544 | (37.7350757572483, -122.41914443544) | 2 | 7 | 7 | 28859 | 2 | ||
10016 | 261433 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 393 Crescent Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 6007343 | 2095769 | 37.7349977038172 | -122.417034617662 | (37.7349977038172, -122.417034617662) | 2 | 7 | 7 | 28859 | 2 | ||||
10065 | 223575 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 46 Wool St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6007323 | 2098000 | 37.7411224122402 | -122.417261809722 | (37.7411224122402, -122.417261809722) | 2 | 7 | 7 | 28859 | 2 | |||
10369 | 223584 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 10x Tompkins Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 4ft | 6007576 | 2096576 | 37.7372266531625 | -122.41628619091 | (37.7372266531625, -122.41628619091) | 2 | 7 | 7 | 28859 | 2 | |||
11545 | 261446 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 329 Crescent Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6007068 | 2095792 | 37.7350453831972 | -122.417987022359 | (37.7350453831972, -122.417987022359) | 2 | 7 | 7 | 28859 | 2 | ||||
12550 | 63379 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 311 Crescent Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/10/1987 12:00:00 AM | Permit Number 23959 | 6006965.60744401 | 2095790.54383517 | 37.7350356215507 | -122.418340927554 | (37.7350356215507, -122.418340927554) | 2 | 7 | 7 | 28859 | 2 | ||
14267 | 261441 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 364 Crescent Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6007175 | 2095707 | 37.7348180134015 | -122.417611061749 | (37.7348180134015, -122.417611061749) | 2 | 7 | 7 | 28859 | 2 | ||||
15086 | 207588 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1 Chilton Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 3ft | 6001743.96601 | 2095815.79538 | 37.7348096375426 | -122.436395778947 | (37.7348096375426, -122.436395778947) | 2 | 7 | 5 | 63 | 7 | |||
15246 | 242850 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 483 29th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 2ft | 6003468.14105 | 2098906.5693 | 37.7433940136201 | -122.430655192302 | (37.7433940136201, -122.430655192302) | 2 | 7 | 5 | 63 | 22 | |||
15567 | 223585 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 10x Tompkins Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 4ft | 6007519 | 2096543 | 37.7371328370553 | -122.416480929712 | (37.7371328370553, -122.416480929712) | 2 | 7 | 7 | 28859 | 2 | |||
16056 | 243760 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 2432 Diamond St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 1x3 | 6001985.30347 | 2097161.30264 | 37.7385177995686 | -122.435657623519 | (37.7385177995686, -122.435657623519) | 2 | 7 | 5 | 63 | 7 | |||
18281 | 261190 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 599x Benton Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6007159 | 2095436 | 37.7340730065148 | -122.41764717788 | (37.7340730065148, -122.41764717788) | 2 | 7 | 7 | 28859 | 2 | ||||
18382 | 223425 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1514 York St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6010157.18753 | 2100400.68055 | 37.7478732021894 | -122.407631390476 | (37.7478732021894, -122.407631390476) | 2 | 7 | 7 | 28859 | 2 | |||
20012 | 63372 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 371 Crescent Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/10/1987 12:00:00 AM | Permit Number 23952 | 6007253.22314461 | 2095766.52547538 | 37.7349858586394 | -122.417344833557 | (37.7349858586394, -122.417344833557) | 2 | 7 | 7 | 28859 | 2 | ||
20325 | 223546 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 384 Sussex St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6000939.02096 | 2096709.07098 | 37.7372165929608 | -122.439242751069 | (37.7372165929608, -122.439242751069) | 2 | 7 | 5 | 63 | 7 | |||
20459 | 223560 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 675 Gates St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 6008145.89505 | 2095713.05268 | 37.7348892176551 | -122.414254758854 | (37.7348892176551, -122.414254758854) | 2 | 7 | 7 | 28859 | 2 | |||
20990 | 4475 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1521 Church St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/01/1992 12:00:00 AM | 6 | 3X3 | 6004596.9832 | 2100011.91057 | 37.7464929146108 | -122.426830644527 | (37.7464929146108, -122.426830644527) | 2 | 7 | 5 | 63 | 22 | ||
23051 | 223487 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 315 Park St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 2ft | 6006838.49776 | 2096321.93409 | 37.7364875458659 | -122.418818066419 | (37.7364875458659, -122.418818066419) | 2 | 7 | 7 | 28859 | 2 | |||
23708 | 223428 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 357 Precita Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 5ft | 6008915.2046 | 2100223.65051 | 37.7473175155876 | -122.411913617629 | (37.7473175155876, -122.411913617629) | 2 | 7 | 7 | 28859 | 2 | |||
24051 | 223567 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 500 Crescent Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6007671.39008 | 2095684.74944 | 37.7347848378312 | -122.415893289437 | (37.7347848378312, -122.415893289437) | 2 | 7 | 7 | 28859 | 2 | |||
24439 | 49859 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 338 Bosworth St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/18/2003 12:00:00 AM | 3x3 | Permit Number 46630 | 6003649.21999567 | 2095274.80996329 | 37.7334322896584 | -122.429770085042 | (37.7334322896584, -122.429770085042) | 2 | 7 | 5 | 28861 | 25 | ||
26446 | 223420 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 3247 Harrison St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6009036.51349 | 2099774.38399 | 37.7460907342145 | -122.411462403466 | (37.7460907342145, -122.411462403466) | 2 | 7 | 7 | 28859 | 2 | |||
27726 | 254276 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 102 Bache St | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/30/2018 12:00:00 AM | 3 | 3x3 | Permit Number 778482 | 6007158.62699 | 2095375.94585 | 37.7339080899914 | -122.417644212443 | (37.7339080899914, -122.417644212443) | 2 | 7 | 7 | 28859 | 2 | |
27764 | 223429 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 357 Precita Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6008933.85702 | 2100227.23414 | 37.7473284018833 | -122.411849371861 | (37.7473284018833, -122.411849371861) | 2 | 7 | 7 | 28859 | 2 | |||
28283 | 223478 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 147 Crescent Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6006034.33786 | 2095867.87013 | 37.7351954754822 | -122.42156615355 | (37.7351954754822, -122.42156615355) | 2 | 7 | 7 | 28859 | 2 | |||
28306 | 223532 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 529 28th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6002464.30667 | 2099434.4104 | 37.7447864204556 | -122.434163917953 | (37.7447864204556, -122.434163917953) | 2 | 7 | 5 | 63 | 22 | |||
29004 | 254341 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 38 Mirabel Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/01/2018 12:00:00 AM | 3 | 3x3 | Permit Number 776525 | 6007503.72696 | 2099881.72077 | 37.7462993638251 | -122.416770197945 | (37.7462993638251, -122.416770197945) | 2 | 7 | 7 | 28859 | 2 |
29773 | 63456 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 801 Moultrie St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/17/1987 12:00:00 AM | Permit Number 24046 | 6007615.99374583 | 2095696.52300413 | 37.7348140509231 | -122.416085647719 | (37.7348140509231, -122.416085647719) | 2 | 7 | 7 | 28859 | 2 |
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) );