trees
3,267 rows where qSpecies_id = 67 sorted by Location
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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 127429 | 205836 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 67 Jules Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 2ft | 5994421.14934 | 2090367.73338 | 37.7194317674391 | -122.461318296897 | (37.7194317674391, -122.461318296897) | 9 | 8 | 6 | 28861 | 24 | |||
| 99156 | 175601 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 638 Madrid St | 1 | Sidewalk: Curb side : Pot | Tree | Private 2 | 6 | Width 2ft | 6002183.73763 | 2090239.52156 | 37.7195234308436 | -122.434476767784 | (37.7195234308436, -122.434476767784) | 9 | 7 | 6 | 28861 | 5 | |||
| 60805 | 175600 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 626 Madrid St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 2ft | 6002200.33228 | 2090264.59279 | 37.7195932128426 | -122.434421197784 | (37.7195932128426, -122.434421197784) | 9 | 7 | 6 | 28861 | 5 | |||
| 131022 | 204391 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 900 Junipero Serra Blvd | 97 | : | Tree | Private 2 | 4 | Width 0ft | 5991142.05412 | 2090528.37768 | 37.7196835902046 | -122.472664513466 | (37.7196835902046, -122.472664513466) | 9 | 8 | 4 | 64 | 40 | |||
| 123318 | 204379 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 704 Garfield St | 1 | : | Tree | Private 2 | 4 | Width 3ft | 5992181.68848 | 2090518.81006 | 37.7197174451861 | -122.469070205624 | (37.7197174451861, -122.469070205624) | 9 | 8 | 6 | 64 | 24 | |||
| 160584 | 47356 | Permitted Site 7 | Callistemon citrinus :: Lemon Bottlebrush 67 | 401 Ralston St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/13/2002 12:00:00 AM | Permit Number 45281 | 5992189.97123037 | 2090518.77996357 | 37.7197178411259 | -122.469041573173 | (37.7197178411259, -122.469041573173) | 9 | 8 | 6 | 64 | 24 | ||
| 86570 | 204390 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 900 Junipero Serra Blvd | 94 | : | Tree | Private 2 | 5 | Width 0ft | 5991146.57188 | 2090545.43725 | 37.7197306930948 | -122.472650140495 | (37.7197306930948, -122.472650140495) | 9 | 8 | 4 | 64 | 40 | |||
| 53218 | 205822 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 88 Lee Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 2ft | 5996534.05939 | 2090432.88282 | 37.7197320303817 | -122.454019490902 | (37.7197320303817, -122.454019490902) | 9 | 8 | 6 | 28861 | 24 | |||
| 4569 | 104897 | Undocumented 4 | Callistemon citrinus :: Lemon Bottlebrush 67 | 303 Gonzalez Dr | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 5990401 | 2090562 | 37.7197329843514 | -122.475228499286 | (37.7197329843514, -122.475228499286) | 1 | 8 | 4 | 64 | 14 | |||||
| 46292 | 104895 | Undocumented 4 | Callistemon citrinus :: Lemon Bottlebrush 67 | 300 Gonzalez Dr | Sidewalk: Curb side : Yard | Tree | Private 2 | 5990401 | 2090562 | 37.7197329843514 | -122.475228499286 | (37.7197329843514, -122.475228499286) | 1 | 8 | 4 | 64 | 14 | ||||||
| 68086 | 104901 | Undocumented 4 | Callistemon citrinus :: Lemon Bottlebrush 67 | 314 Gonzalez Dr | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 5990401 | 2090562 | 37.7197329843514 | -122.475228499286 | (37.7197329843514, -122.475228499286) | 1 | 8 | 4 | 64 | 14 | |||||
| 86867 | 104902 | Undocumented 4 | Callistemon citrinus :: Lemon Bottlebrush 67 | 332 Gonzalez Dr | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 5990401 | 2090562 | 37.7197329843514 | -122.475228499286 | (37.7197329843514, -122.475228499286) | 1 | 8 | 4 | 64 | 14 | |||||
| 93915 | 104907 | Undocumented 4 | Callistemon citrinus :: Lemon Bottlebrush 67 | 432 Gonzalez Dr | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 5990401 | 2090562 | 37.7197329843514 | -122.475228499286 | (37.7197329843514, -122.475228499286) | 1 | 8 | 4 | 64 | 14 | |||||
| 104010 | 104913 | Significant Tree 6 | Callistemon citrinus :: Lemon Bottlebrush 67 | 608 Gonzalez Dr | 1 | Front Yard : Yard | Tree | Private 2 | 5990401 | 2090562 | 37.7197329843514 | -122.475228499286 | (37.7197329843514, -122.475228499286) | 1 | 8 | 4 | 64 | 14 | |||||
| 119556 | 104896 | Undocumented 4 | Callistemon citrinus :: Lemon Bottlebrush 67 | 302 Gonzalez Dr | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 5990401 | 2090562 | 37.7197329843514 | -122.475228499286 | (37.7197329843514, -122.475228499286) | 1 | 8 | 4 | 64 | 14 | |||||
| 131974 | 104917 | Undocumented 4 | Callistemon citrinus :: Lemon Bottlebrush 67 | 702 Gonzalez Dr | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 5990401 | 2090562 | 37.7197329843514 | -122.475228499286 | (37.7197329843514, -122.475228499286) | 1 | 8 | 4 | 64 | 14 | |||||
| 83428 | 104905 | Undocumented 4 | Callistemon citrinus :: Lemon Bottlebrush 67 | 419 Gonzalez Dr | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 5990435 | 2090585 | 37.7197981072685 | -122.475112652722 | (37.7197981072685, -122.475112652722) | 1 | 8 | 4 | 64 | 40 | |||||
| 152262 | 104903 | Undocumented 4 | Callistemon citrinus :: Lemon Bottlebrush 67 | 411 Gonzalez Dr | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 5990435 | 2090585 | 37.7197981072685 | -122.475112652722 | (37.7197981072685, -122.475112652722) | 1 | 8 | 4 | 64 | 40 | |||||
| 65749 | 104923 | Undocumented 4 | Callistemon citrinus :: Lemon Bottlebrush 67 | 767 Gonzalez Dr | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 5990385 | 2090588 | 37.7198034465129 | -122.47528570222 | (37.7198034465129, -122.47528570222) | 1 | 8 | 4 | 64 | 14 | |||||
| 57324 | 104918 | Undocumented 4 | Callistemon citrinus :: Lemon Bottlebrush 67 | 719 Gonzalez Dr | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 5990421 | 2090607 | 37.719857702396 | -122.475162650507 | (37.719857702396, -122.475162650507) | 1 | 8 | 4 | 64 | 40 | |||||
| 178022 | 83014 | Permitted Site 7 | Callistemon citrinus :: Lemon Bottlebrush 67 | 815 Grafton Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/04/2007 12:00:00 AM | 3x3 | Permit Number 49726 | 5994400.44945449 | 2090555.08730476 | 37.7199450051039 | -122.461403423134 | (37.7199450051039, -122.461403423134) | 9 | 8 | 6 | 28861 | 24 | ||
| 27126 | 205835 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 815 Grafton Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 5994339.81958 | 2090564.44928 | 37.7199672210772 | -122.46161367654 | (37.7199672210772, -122.46161367654) | 9 | 8 | 6 | 28861 | 24 | |||
| 152506 | 204364 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 416 Ralston St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | Width 10ft | 5992238.47054 | 2090608.74207 | 37.7199676572632 | -122.468880472981 | (37.7199676572632, -122.468880472981) | 9 | 8 | 6 | 64 | 24 | |||
| 140479 | 175602 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 521 Lisbon St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 12 | Width 6ft | 6002031.92275 | 2090419.60953 | 37.7200092931862 | -122.435014408592 | (37.7200092931862, -122.435014408592) | 9 | 7 | 6 | 28861 | 5 | |||
| 120672 | 204377 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 718 Head St | 5 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | Width 6ft | 5993540.82966 | 2090600.12558 | 37.7200191560468 | -122.464378076488 | (37.7200191560468, -122.464378076488) | 9 | 8 | 6 | 64 | 24 | |||
| 81666 | 205833 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 700 Grafton Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 5994691.90807 | 2090597.09868 | 37.7200771290326 | -122.460399000916 | (37.7200771290326, -122.460399000916) | 9 | 8 | 6 | 28861 | 24 | |||
| 21349 | 200220 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1151 Hollister Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 0ft | 6014047.4712 | 2090254.411 | 37.7202306272165 | -122.393468896776 | (37.7202306272165, -122.393468896776) | 10 | 3 | 8 | 58 | 1 | |||
| 35656 | 205826 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 116 Jules Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 5994471.11499 | 2090695.81427 | 37.7203354745885 | -122.461169353905 | (37.7203354745885, -122.461169353905) | 9 | 8 | 6 | 28861 | 24 | |||
| 97744 | 175619 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 500x Mansell St | 5 | Median : Cutout | Tree | DPW 1 | 14 | Width 0ft | 6010523.52441 | 2090366.11314 | 37.7203409100883 | -122.405657935276 | (37.7203409100883, -122.405657935276) | 10 | 3 | 8 | 309 | 28 | |||
| 87988 | 205827 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 116 Jules Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 5994470.95616 | 2090706.48365 | 37.7203647610097 | -122.461170675902 | (37.7203647610097, -122.461170675902) | 9 | 8 | 6 | 28861 | 24 | |||
| 116438 | 205834 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 125 Ashton Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 5 | Width 3ft | 5994133.07445 | 2090738.36189 | 37.7204328405763 | -122.462340925011 | (37.7204328405763, -122.462340925011) | 9 | 8 | 6 | 28861 | 24 | |||
| 102150 | 175618 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 500x Mansell St | 2 | Median : Cutout | Tree | DPW 1 | 8 | Width 0ft | 6010611.86255 | 2090397.85136 | 37.7204329961751 | -122.405354811601 | (37.7204329961751, -122.405354811601) | 10 | 3 | 8 | 309 | 28 | |||
| 61914 | 205829 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 122 Granada Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 5995652.85009 | 2090722.80681 | 37.7204775260872 | -122.457086459674 | (37.7204775260872, -122.457086459674) | 9 | 8 | 6 | 28861 | 24 | |||
| 52153 | 205828 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 126 Miramar Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 5995357.70352 | 2090747.56335 | 37.7205285473285 | -122.458108470822 | (37.7205285473285, -122.458108470822) | 9 | 8 | 6 | 28861 | 24 | |||
| 145467 | 204366 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 544 Ramsell St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 14 | Width 8ft | 5993020.52615 | 2090799.19022 | 37.7205357338073 | -122.466191031497 | (37.7205357338073, -122.466191031497) | 9 | 8 | 6 | 64 | 24 | |||
| 189630 | 204367 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 544 Ramsell St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 15 | Width 8ft | 5993020.48058 | 2090812.3003 | 37.7205717282756 | -122.466192141252 | (37.7205717282756, -122.466192141252) | 9 | 8 | 6 | 64 | 24 | |||
| 89461 | 205830 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 130 Granada Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 5995652.83573 | 2090787.11518 | 37.720654100797 | -122.457091158655 | (37.720654100797, -122.457091158655) | 9 | 8 | 6 | 28861 | 24 | |||
| 15502 | 78224 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1214 Bowdoin St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 5 | 6009704.84764 | 2090538.93921 | 37.7207696402774 | -122.408500030351 | (37.7207696402774, -122.408500030351) | 9 | 3 | 7 | 309 | 28 | |||
| 155826 | 202069 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1208 Jamestown Ave | 1 | : | Tree | Private 2 | 13 | Width 3ft | 6012889.60074 | 2090482.04244 | 37.7207912554832 | -122.397487253644 | (37.7207912554832, -122.397487253644) | 10 | 3 | 8 | 58 | 1 | |||
| 180902 | 175616 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 200x Mansell St | 14 | Median : Cutout | Tree | DPW 1 | 7 | Width 0ft | 6011130.05143 | 2090542.76805 | 37.7208598665733 | -122.403573780722 | (37.7208598665733, -122.403573780722) | 10 | 7 | 7 | 309 | 28 | |||
| 41735 | 175617 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 200x Mansell St | 19 | Median : Cutout | Tree | DPW 1 | 11 | Width 0ft | 6011092.2529 | 2090548.71621 | 37.7208740875507 | -122.403704857816 | (37.7208740875507, -122.403704857816) | 10 | 3 | 7 | 309 | 28 | |||
| 161750 | 202070 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1216 Jamestown Ave | 1 | : | Tree | Private 2 | 14 | Width 3ft | 6012852.30909 | 2090513.27274 | 37.7208749311243 | -122.39761834962 | (37.7208749311243, -122.39761834962) | 10 | 3 | 8 | 58 | 1 | |||
| 112784 | 204359 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 372 Byxbee St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | Width 10ft | 5991983.23606 | 2090947.52476 | 37.7208831221345 | -122.469787374496 | (37.7208831221345, -122.469787374496) | 9 | 8 | 6 | 64 | 24 | |||
| 74033 | 205873 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 366 Monticello St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 14 | Width 3ft | 5991723.73637 | 2090961.33397 | 37.7209060359618 | -122.470685383523 | (37.7209060359618, -122.470685383523) | 9 | 8 | 6 | 64 | 24 | |||
| 59457 | 113505 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 200x Mansell St | 11 | Median : Cutout | Tree | DPW 1 | 13 | 3x3 | 6011134.80907 | 2090561.37437 | 37.7209112214707 | -122.403558643321 | (37.7209112214707, -122.403558643321) | 10 | 3 | 7 | 309 | 28 | |||
| 68776 | 113504 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 200x Mansell St | 10 | Median : Cutout | Tree | DPW 1 | 7 | 3x3 | 6011150.15882 | 2090569.37703 | 37.7209340525347 | -122.403506146294 | (37.7209340525347, -122.403506146294) | 10 | 3 | 7 | 309 | 28 | |||
| 65909 | 204358 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 374 Byxbee St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 8 | Width 10ft | 5991983.82483 | 2090975.49308 | 37.7209599503178 | -122.469787374484 | (37.7209599503178, -122.469787374484) | 9 | 8 | 6 | 64 | 24 | |||
| 184021 | 113500 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 200x Mansell St | 6 | Median : Cutout | Tree | DPW 1 | 7 | 3x3 | 6011183.30408 | 2090581.60768 | 37.7209694867258 | -122.403392432416 | (37.7209694867258, -122.403392432416) | 10 | 3 | 7 | 309 | 28 | |||
| 43029 | 204357 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 380 Byxbee St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 7 | Width 10ft | 5991985.99504 | 2091008.33716 | 37.7210502575511 | -122.469782262745 | (37.7210502575511, -122.469782262745) | 9 | 8 | 6 | 64 | 24 | |||
| 164585 | 205874 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 380 Byxbee St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 7 | Width 10ft | 5991984.43725 | 2091028.00548 | 37.7211041718932 | -122.469789078727 | (37.7211041718932, -122.469789078727) | 9 | 8 | 6 | 64 | 24 | |||
| 194040 | 175614 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 100x Mansell St | 10 | Median : Cutout | Tree | DPW 1 | 12 | Width 0ft | 6011421.83278 | 2090628.04482 | 37.7211103133815 | -122.402571168832 | (37.7211103133815, -122.402571168832) | 10 | 7 | 8 | 309 | 28 | |||
| 87798 | 45341 | Permitted Site 7 | Callistemon citrinus :: Lemon Bottlebrush 67 | 667 Orizaba Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/27/2001 12:00:00 AM | Permit Number 44171 | 5994015.44130584 | 2090992.03620537 | 37.7211225948175 | -122.462765934958 | (37.7211225948175, -122.462765934958) | 9 | 8 | 6 | 64 | 24 | ||
| 154934 | 175615 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 100x Mansell St | 12 | Median : Cutout | Tree | DPW 1 | 8 | Width 0ft | 6011400.01852 | 2090633.78251 | 37.7211248500058 | -122.402646978091 | (37.7211248500058, -122.402646978091) | 10 | 3 | 8 | 309 | 28 | |||
| 4199 | 78379 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 35 Russia Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 7 | 6001615.3363 | 2090906.3588 | 37.7213221342777 | -122.436489223015 | (37.7213221342777, -122.436489223015) | 9 | 7 | 6 | 28861 | 5 | |||
| 12114 | 78378 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 35 Russia Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 5 | 6001605.25452 | 2090913.72299 | 37.7213417817901 | -122.436524599656 | (37.7213417817901, -122.436524599656) | 9 | 7 | 6 | 28861 | 5 | |||
| 33470 | 205832 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 179 Brighton Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 5996204.59549 | 2091059.7455 | 37.7214343508049 | -122.455203600366 | (37.7214343508049, -122.455203600366) | 9 | 8 | 6 | 28861 | 24 | |||
| 12140 | 260108 | Undocumented 4 | Callistemon citrinus :: Lemon Bottlebrush 67 | 921 Dwight St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6008890 | 2090823 | 37.7215039438499 | -122.411336776053 | (37.7215039438499, -122.411336776053) | 9 | 3 | 7 | 309 | 28 | ||||
| 163089 | 43337 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 451 Naples St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/13/2000 12:00:00 AM | 8 | Permit Number 43094 | 6003321.30466 | 2090952.47585 | 37.7215455546665 | -122.430595462026 | (37.7215455546665, -122.430595462026) | 9 | 7 | 6 | 28861 | 5 | |
| 148357 | 205831 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 183 Brighton Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 5996204.77129 | 2091133.5142 | 37.7216369123021 | -122.455208320919 | (37.7216369123021, -122.455208320919) | 9 | 8 | 6 | 28861 | 24 | |||
| 99739 | 205823 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 400 Holloway Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 5995597.81564 | 2091238.36585 | 37.7218899680335 | -122.457313972857 | (37.7218899680335, -122.457313972857) | 9 | 8 | 4 | 28861 | 24 | |||
| 85422 | 205824 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 430 Holloway Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 5995462.30433 | 2091242.1015 | 37.7218924411521 | -122.457782668052 | (37.7218924411521, -122.457782668052) | 9 | 8 | 4 | 28861 | 24 | |||
| 193688 | 200144 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1351 Gilman Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 0ft | 6013679.8971 | 2090868.8737 | 37.7218973889739 | -122.394782497653 | (37.7218973889739, -122.394782497653) | 10 | 3 | 8 | 58 | 1 | |||
| 40242 | 67987 | Permitted Site 7 | Callistemon citrinus :: Lemon Bottlebrush 67 | 201 Granada Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/22/1993 12:00:00 AM | Permit Number 31711 | 5995615.55852093 | 2091245.53486568 | 37.7219106715002 | -122.457253158986 | (37.7219106715002, -122.457253158986) | 9 | 8 | 4 | 28861 | 24 | ||
| 84838 | 37812 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 374 Athens St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/01/2003 12:00:00 AM | 6 | Permit Number 46656 | 6004021.4993 | 2091137.98354 | 37.722094560208 | -122.428188292583 | (37.722094560208, -122.428188292583) | 9 | 7 | 6 | 28861 | 5 | |
| 45861 | 202030 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1327 Fitzgerald Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 11 | Width 7ft | 6013974.71046 | 2090993.7917 | 37.7222567763217 | -122.393772134473 | (37.7222567763217, -122.393772134473) | 10 | 3 | 8 | 58 | 1 | |||
| 120011 | 175729 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 466 Dwight St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 6010142.91945 | 2091277.34193 | 37.7228216647702 | -122.407037763297 | (37.7228216647702, -122.407037763297) | 10 | 3 | 7 | 309 | 28 | |||
| 108769 | 175728 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 460 Dwight St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 6010166.68828 | 2091285.38928 | 37.7228450912049 | -122.406956166013 | (37.7228450912049, -122.406956166013) | 10 | 3 | 7 | 309 | 28 | |||
| 30804 | 175727 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 454 Dwight St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 6010193.7815 | 2091293.54283 | 37.7228689952038 | -122.406863084384 | (37.7228689952038, -122.406863084384) | 10 | 3 | 7 | 309 | 28 | |||
| 190801 | 175726 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 448 Dwight St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 6010217.17242 | 2091300.20495 | 37.7228885968184 | -122.406782695777 | (37.7228885968184, -122.406782695777) | 10 | 3 | 7 | 309 | 28 | |||
| 183151 | 15758 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 4709 Mission St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | 3X3 | 6001757.7313 | 2091475.0143 | 37.7228916248527 | -122.436037675081 | (37.7228916248527, -122.436037675081) | 9 | 7 | 6 | 28861 | 5 | |||
| 49955 | 175725 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 442 Dwight St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 6010244.61867 | 2091308.52559 | 37.7229129792266 | -122.406688405449 | (37.7229129792266, -122.406688405449) | 10 | 3 | 7 | 309 | 28 | |||
| 190653 | 175724 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 436 Dwight St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 6010269.07582 | 2091316.0366 | 37.7229349712507 | -122.406604390786 | (37.7229349712507, -122.406604390786) | 10 | 3 | 7 | 309 | 28 | |||
| 55353 | 175689 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1419 Wayland St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6007497.28407 | 2091377.76414 | 37.7229489970823 | -122.416190298655 | (37.7229489970823, -122.416190298655) | 9 | 3 | 7 | 309 | 28 | |||
| 136119 | 175723 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 430 Dwight St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 6010294.06457 | 2091323.88496 | 37.7229579192483 | -122.406518562192 | (37.7229579192483, -122.406518562192) | 10 | 3 | 7 | 309 | 28 | |||
| 144720 | 175690 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1419 Wayland St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6007508.06926 | 2091382.7441 | 37.7229632774235 | -122.416153368891 | (37.7229632774235, -122.416153368891) | 9 | 3 | 7 | 309 | 28 | |||
| 76908 | 175691 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1419 Wayland St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6007522.85958 | 2091386.22385 | 37.722973663691 | -122.416102487965 | (37.722973663691, -122.416102487965) | 9 | 3 | 7 | 309 | 28 | |||
| 98647 | 175692 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1419 Wayland St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6007539.58214 | 2091391.31871 | 37.7229885933237 | -122.41604504197 | (37.7229885933237, -122.41604504197) | 9 | 3 | 7 | 309 | 28 | |||
| 125304 | 175722 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 418 Dwight St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 6010347.73696 | 2091340.72553 | 37.7230071625223 | -122.406334212854 | (37.7230071625223, -122.406334212854) | 10 | 3 | 7 | 309 | 28 | |||
| 154646 | 205825 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 469 Faxon Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 4ft | 5994740.59231 | 2091670.23185 | 37.7230264961676 | -122.460308429304 | (37.7230264961676, -122.460308429304) | 9 | 8 | 4 | 28861 | 24 | |||
| 179577 | 175721 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 412 Dwight St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6010372.00157 | 2091347.36999 | 37.7230267641567 | -122.40625080253 | (37.7230267641567, -122.40625080253) | 10 | 3 | 7 | 309 | 28 | |||
| 6979 | 42994 | Permitted Site 7 | Callistemon citrinus :: Lemon Bottlebrush 67 | 500 Yale St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/05/2000 12:00:00 AM | Permit Number 42870 | 6007553.67502493 | 2091408.33369541 | 37.7230361052022 | -122.415997529963 | (37.7230361052022, -122.415997529963) | 9 | 3 | 7 | 309 | 28 | ||
| 68826 | 42991 | Permitted Site 7 | Callistemon citrinus :: Lemon Bottlebrush 67 | 500 Yale St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/05/2000 12:00:00 AM | Permit Number 42870 | 6007553.67502493 | 2091408.33369541 | 37.7230361052022 | -122.415997529963 | (37.7230361052022, -122.415997529963) | 9 | 3 | 7 | 309 | 28 | ||
| 156851 | 42992 | Permitted Site 7 | Callistemon citrinus :: Lemon Bottlebrush 67 | 500 Yale St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/05/2000 12:00:00 AM | Permit Number 42870 | 6007553.67502493 | 2091408.33369541 | 37.7230361052022 | -122.415997529963 | (37.7230361052022, -122.415997529963) | 9 | 3 | 7 | 309 | 28 | ||
| 169813 | 42993 | Permitted Site 7 | Callistemon citrinus :: Lemon Bottlebrush 67 | 500 Yale St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/05/2000 12:00:00 AM | Permit Number 42870 | 6007553.67502493 | 2091408.33369541 | 37.7230361052022 | -122.415997529963 | (37.7230361052022, -122.415997529963) | 9 | 3 | 7 | 309 | 28 | ||
| 67499 | 175713 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 637 Hamilton St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 12 | Width 9ft | 6009802.33788 | 2091425.99493 | 37.7232107699499 | -122.408225566251 | (37.7232107699499, -122.408225566251) | 10 | 3 | 7 | 309 | 28 | |||
| 171633 | 45438 | Permitted Site 7 | Callistemon citrinus :: Lemon Bottlebrush 67 | 601 Urbano Dr | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/13/2001 12:00:00 AM | Permit Number 44225 | 5992911.96074183 | 2091864.48215283 | 37.7234545015521 | -122.466643698449 | (37.7234545015521, -122.466643698449) | 9 | 8 | 4 | 59 | 40 | ||
| 9967 | 15752 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 4650 Mission St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 4x4 | 6001829 | 2091729 | 37.7235930609595 | -122.435809477936 | (37.7235930609595, -122.435809477936) | 9 | 7 | 6 | 28861 | 25 | |||
| 194424 | 62181 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 18 Meda Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/30/2017 12:00:00 AM | 3 | Permit Number 778619 | 6000227.93753 | 2091768.58709 | 37.7236106804803 | -122.441346893068 | (37.7236106804803, -122.441346893068) | 9 | 7 | 6 | 28861 | 25 | |
| 137522 | 15753 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 4650 Mission St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3X3 | 6001853.0947 | 2091735.5112 | 37.7236123079051 | -122.43572665255 | (37.7236123079051, -122.43572665255) | 9 | 7 | 6 | 28861 | 25 | |||
| 173120 | 175720 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 154 Dwight St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6011044.04658 | 2091549.76431 | 37.723620066687 | -122.403941902001 | (37.723620066687, -122.403941902001) | 10 | 3 | 7 | 309 | 28 | |||
| 194439 | 62177 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 33 Meda Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/31/2017 12:00:00 AM | 3 | 3x3 | Permit Number 780357 | 6000151.49887 | 2091775.04378 | 37.7236240542963 | -122.441611590516 | (37.7236240542963, -122.441611590516) | 9 | 7 | 6 | 28861 | 25 |
| 143459 | 66511 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 154 Dwight St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/28/1991 12:00:00 AM | 4 | Permit Number 29675 | 6011062.35807 | 2091556.00811 | 37.723638233911 | -122.403879041192 | (37.723638233911, -122.403879041192) | 10 | 3 | 7 | 309 | 28 | ||
| 91972 | 66534 | Permitted Site 7 | Callistemon citrinus :: Lemon Bottlebrush 67 | 701 Excelsior Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/22/1992 12:00:00 AM | Permit Number 30772 | 6004086.63776587 | 2091699.6936924 | 37.7236405778519 | -122.428003132555 | (37.7236405778519, -122.428003132555) | 9 | 7 | 6 | 28861 | 5 | ||
| 98081 | 175717 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 675 Brussels St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6011008.59251 | 2091558.92414 | 37.723643236824 | -122.404065105513 | (37.723643236824, -122.404065105513) | 10 | 3 | 7 | 309 | 28 | |||
| 174370 | 175718 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 675 Brussels St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6011002.88556 | 2091576.16405 | 37.7236902551914 | -122.40408604626 | (37.7236902551914, -122.40408604626) | 10 | 3 | 7 | 309 | 28 | |||
| 55871 | 175595 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 27 Ocean Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 2ft | 6001772.06496 | 2091793.1589 | 37.7237659924901 | -122.436010880815 | (37.7237659924901, -122.436010880815) | 9 | 7 | 6 | 28861 | 25 | |||
| 70778 | 175719 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 675 Brussels St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6010993.36557 | 2091607.68706 | 37.7237762789462 | -122.404121172871 | (37.7237762789462, -122.404121172871) | 10 | 3 | 7 | 309 | 28 | |||
| 36466 | 25316 | Permitted Site 7 | Callistemon citrinus :: Lemon Bottlebrush 67 | 15X Ocean Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3X3 | 6001811.27411 | 2091808.97426 | 37.7238116453109 | -122.435876472647 | (37.7238116453109, -122.435876472647) | 9 | 7 | 6 | 28861 | 25 | |||
| 72258 | 175663 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 279 Vienna St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 12 | 6004167.57831 | 2091788.97254 | 37.7238902967841 | -122.427729693185 | (37.7238902967841, -122.427729693185) | 9 | 7 | 6 | 28861 | 5 | ||||
| 103632 | 175716 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 600 Somerset St | 5 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 3ft | 6010284.68284 | 2091697.61844 | 37.723983588851 | -122.406577316683 | (37.723983588851, -122.406577316683) | 10 | 3 | 7 | 309 | 28 |
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) );