Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, qSiteInfo, qCaretaker, qCareAssistant
| Link | rowid | TreeID ▼ | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 17077 | 17077 | 551 | DPW Maintained 3 | Ficus microcarpa :: Chinese Banyan 94 | 2900 24th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3x3 | 6009445.64374 | 2102206.2231799997 | 37.752790964934704 | -122.41021934346 | (37.7527909649347, -122.41021934346) | |||
| 17372 | 17372 | 552 | DPW Maintained 3 | Ficus microcarpa :: Chinese Banyan 94 | 2904 24th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 6009418.497 | 2102204.07854 | 37.7527835545272 | -122.41031307080699 | (37.7527835545272, -122.410313070807) | |||
| 20570 | 20570 | 554 | DPW Maintained 3 | Ficus microcarpa :: Chinese Banyan 94 | 2912X 24th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3x3 | 6009391.31353 | 2102200.13523 | 37.7527712032402 | -122.410406798162 | (37.7527712032402, -122.410406798162) | |||
| 21969 | 21969 | 556 | DPW Maintained 3 | Ficus microcarpa :: Chinese Banyan 94 | 2934 24th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3x3 | 6009338.079419999 | 2102203.4712799997 | 37.7527773788967 | -122.410591127672 | (37.7527773788967, -122.410591127672) | |||
| 21452 | 21452 | 569 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 2970 24th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 3x3 | 6009068.4734 | 2102184.68731 | 37.7527106833549 | -122.411522150837 | (37.7527106833549, -122.411522150837) | |||
| 20802 | 20802 | 574 | DPW Maintained 3 | Ficus microcarpa :: Chinese Banyan 94 | 3000 24th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 5x6 | 6008882.07656 | 2102170.50291 | 37.7526612791072 | -122.412165744373 | (37.7526612791072, -122.412165744373) | |||
| 18722 | 18722 | 576 | DPW Maintained 3 | Ficus microcarpa :: Chinese Banyan 94 | 3008 24th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3x3 | 6008852.23919 | 2102169.31321 | 37.7526563382221 | -122.412268843556 | (37.7526563382221, -122.412268843556) | |||
| 17601 | 17601 | 577 | DPW Maintained 3 | Ficus microcarpa :: Chinese Banyan 94 | 3024 24th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3x3 | 6008801.63126 | 2102168.54838 | 37.752651398249604 | -122.41244380126301 | (37.7526513982496, -122.412443801263) | |||
| 17916 | 17916 | 587 | DPW Maintained 3 | Ficus microcarpa :: Chinese Banyan 94 | 3041 24th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3x3 | 6008724.79045 | 2102125.26547 | 37.7525282406021 | -122.41270647162202 | (37.7525282406021, -122.412706471622) | |||
| 1507 | 1507 | 590 | DPW Maintained 3 | Ficus microcarpa :: Chinese Banyan 94 | 3049 24th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6008590.89573 | 2102118.12773 | 37.7525011260356 | -122.413168999261 | (37.7525011260356, -122.413168999261) | |||
| 20951 | 20951 | 592 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 3056 24th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 3x3 | 6008558.8392900005 | 2102157.7680200003 | 37.752608169649 | -122.41328265918699 | (37.752608169649, -122.413282659187) | |||
| 21673 | 21673 | 596 | DPW Maintained 3 | Ficus microcarpa :: Chinese Banyan 94 | 3066 24th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 22 | 3x3 | 6008530.73419 | 2102152.9446900003 | 37.752593347917596 | -122.413379510765 | (37.7525933479176, -122.413379510765) | |||
| 19889 | 19889 | 597 | DPW Maintained 3 | Ficus microcarpa :: Chinese Banyan 94 | 3067 24th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3x3 | 6008545.44191 | 2102115.03145 | 37.7524900724667 | -122.41332596783998 | (37.7524900724667, -122.41332596784) | |||
| 18661 | 18661 | 598 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 3070 24th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 23 | 3x3 | 6008489.074019999 | 2102147.94889 | 37.75257729142999 | -122.41352322603399 | (37.75257729143, -122.413523226034) | |||
| 19961 | 19961 | 600 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 3078 24th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 21 | 3x3 | 6008460.582 | 2102146.28241 | 37.7525711157729 | -122.41362163882401 | (37.7525711157729, -122.413621638824) | |||
| 21513 | 21513 | 604 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 3090 24th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 21 | 3x3 | 6008414.92242 | 2102144.51738 | 37.752563705358604 | -122.413779413197 | (37.7525637053586, -122.413779413197) | |||
| 20158 | 20158 | 605 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 3098 24th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 20 | 3x3 | 6008383.72095 | 2102142.9064 | 37.752557529712895 | -122.41388719964701 | (37.7525575297129, -122.413887199647) | |||
| 20360 | 20360 | 611 | DPW Maintained 3 | Ficus microcarpa :: Chinese Banyan 94 | 3108 24th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3x3 | 6008224.09237 | 2102134.47643 | 37.752525416718 | -122.41443862795799 | (37.752525416718, -122.414438627958) | |||
| 21465 | 21465 | 612 | DPW Maintained 3 | Ficus microcarpa :: Chinese Banyan 94 | 3114 24th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 20 | 3x3 | 6008205.07322 | 2102132.16672 | 37.7525180063146 | -122.41450423619601 | (37.7525180063146, -122.414504236196) | |||
| 19935 | 19935 | 613 | DPW Maintained 3 | Ficus microcarpa :: Chinese Banyan 94 | 3124 24th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 20 | 3X3 | 6008177.96308 | 2102131.82169 | 37.7525155358782 | -122.41459796353998 | (37.7525155358782, -122.41459796354) | |||
| 20356 | 20356 | 620 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 3145 24th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 3x3 | 6008061.58213 | 2102085.15012 | 37.752380847108604 | -122.41499712672 | (37.7523808471086, -122.41499712672) | |||
| 18768 | 18768 | 622 | DPW Maintained 3 | Ficus microcarpa :: Chinese Banyan 94 | 3150 24th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 21 | 3x3 | 6007969.891890001 | 2102118.08704 | 37.7524661316063 | -122.415316538925 | (37.7524661316063, -122.415316538925) | |||
| 18462 | 18462 | 623 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 3158 24th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 20 | 3x3 | 6007941.8237 | 2102115.0630200002 | 37.7524562507759 | -122.415413389641 | (37.7524562507759, -122.415413389641) | |||
| 17117 | 17117 | 625 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 3160 24th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 20 | 4x6 | 6007920.1411 | 2102115.05717 | 37.7524550160009 | -122.415488371495 | (37.7524550160009, -122.415488371495) | |||
| 20796 | 20796 | 626 | DPW Maintained 3 | Ficus microcarpa :: Chinese Banyan 94 | 3155 24th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3 | 3X3 | 6007952.38293 | 2102079.53558 | 37.752359293949795 | -122.415374359065 | (37.7523592939498, -122.415374359065) | |||
| 20532 | 20532 | 627 | DPW Maintained 3 | Ficus microcarpa :: Chinese Banyan 94 | 3168 24th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 21 | 3x3 | 6007870.94281 | 2102116.96374 | 37.752457485548796 | -122.415658642859 | (37.7524574855488, -122.415658642859) | |||
| 18232 | 18232 | 630 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 3176 24th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 22 | 3x3 | 6007837.40103 | 2102111.35303 | 37.752440194268395 | -122.41577423901501 | (37.7524401942684, -122.415774239015) | |||
| 18228 | 18228 | 633 | DPW Maintained 3 | Ficus microcarpa :: Chinese Banyan 94 | 3182 24th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 20 | 3x3 | 6007808.47554 | 2102110.59584 | 37.7524364890666 | -122.415874214834 | (37.7524364890666, -122.415874214834) | |||
| 17807 | 17807 | 640 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 3214 24th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 3X3 | 6007574.72227 | 2102100.08892 | 37.7523944952223 | -122.41668183031601 | (37.7523944952223, -122.416681830316) | |||
| 20895 | 20895 | 641 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 3208 24th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 3X3 | 6007604.52296 | 2102099.47851 | 37.7523944952114 | -122.41657873113 | (37.7523944952114, -122.41657873113) | |||
| 20129 | 20129 | 642 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 3225 24th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 4x4 | 6007512.22413 | 2102054.36572 | 37.7522654344184 | -122.416894720512 | (37.7522654344184, -122.416894720512) | |||
| 17817 | 17817 | 643 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 3224 24th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 3x3 | 6007548.56119 | 2102101.97423 | 37.752398200442 | -122.41677243341199 | (37.752398200442, -122.416772433412) | |||
| 20011 | 20011 | 644 | DPW Maintained 3 | Ficus microcarpa :: Chinese Banyan 94 | 3245 24th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3x3 | 6007452.42683 | 2102052.29911 | 37.75225639624 | -122.41710136313101 | (37.75225639624, -122.417101363131) | |||
| 22195 | 22195 | 1351 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 271 Amber Dr | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 5999796.36324 | 2099302.3291700003 | 37.7442719740833 | -122.443379644158 | (37.7442719740833, -122.443379644158) | |||
| 19453 | 19453 | 1923 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 78 Berkeley Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 3x3 | 6001189.660619999 | 2097346.8097900003 | 37.7389819342562 | -122.43842185440901 | (37.7389819342562, -122.438421854409) | |||
| 17222 | 17222 | 3468 | DPW Maintained 3 | Ficus microcarpa :: Chinese Banyan 94 | 3231 24th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 15 | 4x4 | 6007477.096919999 | 2102052.55322 | 37.752258481762 | -122.41701606785601 | (37.752258481762, -122.417016067856) | |||
| 21001 | 21001 | 5127 | DPW Maintained 3 | Ficus microcarpa :: Chinese Banyan 94 | 2764 Diamond St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/18/1994 12:00:00 AM | 15 | 3X3 | 6002472.72131 | 2095943.62285 | 37.7352020045603 | -122.433885356532 | (37.7352020045603, -122.433885356532) | ||
| 21680 | 21680 | 5133 | DPW Maintained 3 | Ficus microcarpa :: Chinese Banyan 94 | 2796 Diamond St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 4x4 | 6002464.77756 | 2095726.89475 | 37.734606468121704 | -122.433897334607 | (37.7346064681217, -122.433897334607) | |||
| 19320 | 19320 | 5332 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 125 Dolores St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 90 | 6x7 | 6004849.91389 | 2107615.9681599997 | 37.7673861676625 | -122.42649738994601 | (37.7673861676625, -122.426497389946) | |||
| 21156 | 21156 | 5334 | DPW Maintained 3 | Ficus microcarpa :: Chinese Banyan 94 | 140 Dolores St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 90 | 3X3 | 6004762.96876 | 2107575.6784599996 | 37.7672706263574 | -122.426795251693 | (37.7672706263574, -122.426795251693) | |||
| 19950 | 19950 | 5335 | DPW Maintained 3 | Ficus microcarpa :: Chinese Banyan 94 | 149 Dolores St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 90 | 6X8 | 6004854.459 | 2107562.68516 | 37.7672401222731 | -122.42647787465 | (37.7672401222731, -122.42647787465) | |||
| 20206 | 20206 | 5338 | DPW Maintained 3 | Ficus microcarpa :: Chinese Banyan 94 | 158 Dolores St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 5x5 | 6004769.98156 | 2107435.4149 | 37.766885892799 | -122.426761005535 | (37.766885892799, -122.426761005535) | |||
| 20645 | 20645 | 5358 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 230 Dolores St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 40 | 3X3 | 6004797.6722800005 | 2107012.30465 | 37.765725699015604 | -122.426635095043 | (37.7657256990156, -122.426635095043) | |||
| 20213 | 20213 | 5371 | DPW Maintained 3 | Ficus microcarpa :: Chinese Banyan 94 | 266 Dolores St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 14 | 6x6 | 6004805.70542 | 2106808.5131599996 | 37.765166590486395 | -122.42659279722 | (37.7651665904864, -122.42659279722) | |||
| 20031 | 20031 | 5670 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 1416 Dolores St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | 3x3 | 6005182.49595 | 2100071.1312 | 37.7466886088884 | -122.424810216828 | (37.7466886088884, -122.424810216828) | |||
| 16957 | 16957 | 5672 | DPW Maintained 3 | Ficus microcarpa :: Chinese Banyan 94 | 1422 Dolores St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 14 | 3x3 | 6005185.06241 | 2100046.61651 | 37.7466214421279 | -122.424799598532 | (37.7466214421279, -122.424799598532) | |||
| 21323 | 21323 | 5685 | DPW Maintained 3 | Ficus microcarpa :: Chinese Banyan 94 | 1506 Dolores St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 20 | 5x5 | 6005209.87097 | 2099535.96992 | 37.7452207246578 | -122.42467749309601 | (37.7452207246578, -122.424677493096) | |||
| 20211 | 20211 | 5689 | DPW Maintained 3 | Ficus microcarpa :: Chinese Banyan 94 | 1535 Dolores St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 90 | 3X3 | 6005306.00348 | 2099419.02782 | 37.74490505722029 | -122.424336766952 | (37.7449050572203, -122.424336766952) | |||
| 19035 | 19035 | 5708 | DPW Maintained 3 | Ficus microcarpa :: Chinese Banyan 94 | 1603 Dolores St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 80 | 3X3 | 6005329.17263 | 2098980.1167599997 | 37.743701215741794 | -122.424225442544 | (37.7437012157418, -122.424225442544) | |||
| 17131 | 17131 | 5742 | DPW Maintained 3 | Ficus microcarpa :: Chinese Banyan 94 | 1755 Dolores St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 80 | 3X3 | 6005373.18109 | 2098196.81653 | 37.741552935912 | -122.424017580443 | (37.741552935912, -122.424017580443) | |||
| 21076 | 21076 | 5748 | DPW Maintained 3 | Ficus microcarpa :: Chinese Banyan 94 | 1770 Dolores St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 100 | 5X5 | 6005291.423690001 | 2098088.82872 | 37.7412518096224 | -122.424292591354 | (37.7412518096224, -122.424292591354) | |||
| 23078 | 23078 | 7496 | DPW Maintained 3 | Ficus microcarpa :: Chinese Banyan 94 | 2696 Folsom St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6008261.6755800005 | 2102751.78327 | 37.754222512965995 | -122.414352332587 | (37.754222512966, -122.414352332587) | |||
| 20538 | 20538 | 10222 | DPW Maintained 3 | Ficus microcarpa :: Chinese Banyan 94 | 1375-1377 Guerrero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3x3 | 6005868.37697 | 2101019.32612 | 37.7493308512387 | -122.422505871374 | (37.7493308512387, -122.422505871374) | |||
| 17377 | 17377 | 12244 | DPW Maintained 3 | Ficus microcarpa :: Chinese Banyan 94 | 401X Oak St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 30 | 3X3 | 6005028.531359999 | 2110211.81183 | 37.7745238232573 | -122.426064391571 | (37.7745238232573, -122.426064391571) | |||
| 20144 | 20144 | 16900 | DPW Maintained 3 | Ficus microcarpa :: Chinese Banyan 94 | 409 Oak St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 6005007.3916 | 2110203.70331 | 37.774500364432505 | -122.426136940772 | (37.7745003644325, -122.426136940772) | |||
| 17445 | 17445 | 16902 | DPW Maintained 3 | Ficus microcarpa :: Chinese Banyan 94 | 427 Oak St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 6004930.51635 | 2110189.46412 | 37.7744569217764 | -122.42640185318899 | (37.7744569217764, -122.426401853189) | |||
| 16901 | 16901 | 16914 | DPW Maintained 3 | Ficus microcarpa :: Chinese Banyan 94 | 483 Oak St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6004697.20239 | 2110157.0841200002 | 37.77435482265879 | -122.427206624104 | (37.7743548226588, -122.427206624104) | |||
| 20778 | 20778 | 22835 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 104 Turquoise Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/14/1994 12:00:00 AM | 20 | 2X2 | 5999575.13645 | 2098938.39255 | 37.743260073094504 | -122.44411845071899 | (37.7432600730945, -122.444118450719) | ||
| 18629 | 18629 | 23094 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 1384 Valencia St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/01/1992 12:00:00 AM | 3 | 3x3 | 6006412.34173 | 2101544.72785 | 37.750804156590206 | -122.42066211905701 | (37.7508041565902, -122.420662119057) | ||
| 21797 | 21797 | 23099 | DPW Maintained 3 | Ficus microcarpa :: Chinese Banyan 94 | 1406 Valencia St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 24 | 5x4 | 6006424.41645 | 2101384.80463 | 37.7503657245067 | -122.420609012309 | (37.7503657245067, -122.420609012309) | |||
| 7271 | 7271 | 23546 | DPW Maintained 3 | Ficus microcarpa :: Chinese Banyan 94 | 2805 Van Ness Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6005607.92942 | 2120044.70688 | 37.801555234346104 | -122.424759800825 | (37.8015552343461, -122.424759800825) | |||
| 18141 | 18141 | 24446 | DPW Maintained 3 | Ficus microcarpa :: Chinese Banyan 94 | 1156 Valencia St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 25 | 3X3 | 6006345.52984 | 2102866.64807 | 37.754430080088895 | -122.420987008139 | (37.7544300800889, -122.420987008139) | |||
| 17610 | 17610 | 24602 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 419 Cortland Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 6007254.49022 | 2097303.30919 | 37.7392055992492 | -122.41744932972401 | (37.7392055992492, -122.417449329724) | |||
| 19544 | 19544 | 24603 | DPW Maintained 3 | Ficus microcarpa :: Chinese Banyan 94 | 407 Cortland Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 2X2 | 6007220.87336 | 2097309.53692 | 37.739220807683296 | -122.41756600326401 | (37.7392208076833, -122.417566003264) | |||
| 23132 | 23132 | 25364 | DPW Maintained 3 | Ficus microcarpa :: Chinese Banyan 94 | 994 Geneva Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 3X3 | 6000636.2417 | 2088870.0556299998 | 37.7156752201082 | -122.43972775363001 | (37.7156752201082, -122.43972775363) | |||
| 11311 | 11311 | 25396 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 945 Geneva Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | 3X3 | 6000465.251630001 | 2089064.76788 | 37.7162001220051 | -122.440332727576 | (37.7162001220051, -122.440332727576) | |||
| 13913 | 13913 | 26001 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 1711 Oakdale Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 3X3 | 6014400.39468 | 2095925.2599900002 | 37.735821239067796 | -122.392645436853 | (37.7358212390678, -122.392645436853) | |||
| 16905 | 16905 | 26220 | DPW Maintained 3 | Ficus microcarpa :: Chinese Banyan 94 | 765X San Jose Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3x3 | 6005701.2867 | 2098677.11468 | 37.7428902448864 | -122.422917229343 | (37.7428902448864, -122.422917229343) | |||
| 18006 | 18006 | 26514 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 2880 Harrison St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 3X3 | 6008952.92902 | 2101706.37447 | 37.7513908617048 | -122.411887928494 | (37.7513908617048, -122.411887928494) | |||
| 20672 | 20672 | 26517 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 2883 Harrison St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 30 | 3X3 | 6009010.68122 | 2101716.60139 | 37.7514221824079 | -122.411688936397 | (37.7514221824079, -122.411688936397) | |||
| 11743 | 11743 | 28251 | DPW Maintained 3 | Ficus microcarpa :: Chinese Banyan 94 | 3340 San Bruno Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 2X3 | 6011988.71606 | 2089960.7357 | 37.7193096502899 | -122.40056475438101 | (37.7193096502899, -122.400564754381) | |||
| 12579 | 12579 | 28252 | DPW Maintained 3 | Ficus microcarpa :: Chinese Banyan 94 | 3342 San Bruno Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 2X3 | 6011993.05449 | 2089944.3685299999 | 37.7192649513087 | -122.40054860885598 | (37.7192649513087, -122.400548608856) | |||
| 21401 | 21401 | 28743 | DPW Maintained 3 | Ficus microcarpa :: Chinese Banyan 94 | 750 San Jose Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3 | 3x3 | 6005621.9935800005 | 2098694.18206 | 37.742932633526 | -122.42319261615 | (37.742932633526, -122.42319261615) | |||
| 91480 | 91480 | 30505 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 1500 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | Permit Number 34518 | 6007587.04685478 | 2110100.36731732 | 37.7743620934089 | -122.417206068405 | (37.7743620934089, -122.417206068405) | |||
| 81288 | 81288 | 30534 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 1020 Harrison St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/25/1995 12:00:00 AM | Permit Number 34535 | 6011195.92412392 | 2110919.1949505 | 37.776812772940005 | -122.404779881684 | (37.77681277294, -122.404779881684) | |||
| 146184 | 146184 | 30538 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 614 Fillmore St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Permit Number 34538 | 6003619.86564688 | 2110438.7017887 | 37.775067091373295 | -122.43095343382099 | (37.7750670913733, -122.430953433821) | ||||
| 109018 | 109018 | 30843 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 1375 Kansas St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/14/1995 12:00:00 AM | Permit Number 34691 | 6011743.60320296 | 2101979.83639733 | 37.7522978969141 | -122.40225661865 | (37.7522978969141, -122.40225661865) | ||
| 91059 | 91059 | 30886 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 1440 Kearny St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Permit Number 34718 | 6011020.35277298 | 2119822.53522602 | 37.8012494094877 | -122.40601460797501 | (37.8012494094877, -122.406014607975) | ||||
| 150299 | 150299 | 30926 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 230 Holloway Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/13/1995 12:00:00 AM | 13 | Permit Number 34739 | 5996065.71046 | 2091231.3003900002 | 37.7218974306099 | -122.455696079012 | (37.7218974306099, -122.455696079012) | |
| 134768 | 134768 | 30927 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 236 Holloway Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/13/1995 12:00:00 AM | 13 | Permit Number 34740 | 5996038.7385 | 2091232.9544799998 | 37.7219004244455 | -122.455789433158 | (37.7219004244455, -122.455789433158) | |
| 115455 | 115455 | 31210 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 2736 Pierce St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/04/1995 12:00:00 AM | Permit Number 34902 | 6001624.16755345 | 2117801.03750222 | 37.7951689006516 | -122.43838455687201 | (37.7951689006516, -122.438384556872) | |||
| 96095 | 96095 | 31350 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 843 Hayes St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/12/1995 12:00:00 AM | Permit Number 34960 | 6003828.78534548 | 2110731.50789971 | 37.7758829003399 | -122.43025162922702 | (37.7758829003399, -122.430251629227) | ||
| 77451 | 77451 | 31969 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 470 Hamilton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/30/1995 12:00:00 AM | Permit Number 35370 | 6009517.59351868 | 2092163.53246737 | 37.725219944905895 | -122.40926189775499 | (37.7252199449059, -122.409261897755) | |||
| 140871 | 140871 | 32046 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 501 Tunnel Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/13/1999 12:00:00 AM | Permit Number 35428 | 6012610.0 | 2086139.0 | 37.7088505533644 | -122.398149216451 | (37.7088505533644, -122.398149216451) | ||
| 77427 | 77427 | 32868 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 456 Laidley St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/30/1996 12:00:00 AM | Permit Number 37214 | 6003519.04848512 | 2096396.05502281 | 37.736503601704996 | -122.430300092251 | (37.736503601705, -122.430300092251) | |||
| 96551 | 96551 | 33508 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 235 Coleridge St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/25/1996 12:00:00 AM | Permit Number 37603 | 6006396.09682229 | 2098460.33665401 | 37.7423342020889 | -122.420499380726 | (37.7423342020889, -122.420499380726) | |||
| 116527 | 116527 | 33576 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 170 Bonview St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/26/1996 12:00:00 AM | 18 | 2.5x4 | Permit Number 37684 | 6007080.60152815 | 2098048.2941617 | 37.7412413768938 | -122.41810336116998 | (37.7412413768938, -122.41810336117) | |
| 81512 | 81512 | 33580 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 161 Bonview St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/26/1996 12:00:00 AM | Permit Number 37688 | 6007154.09999929 | 2098074.89925627 | 37.7413185651373 | -122.417851114389 | (37.7413185651373, -122.417851114389) | |||
| 108242 | 108242 | 33581 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 159 Bonview St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/26/1996 12:00:00 AM | Permit Number 37689 | 6007159.65124857 | 2098085.1665824 | 37.7413470693377 | -122.417832647693 | (37.7413470693377, -122.417832647693) | |||
| 104502 | 104502 | 33585 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 220 Bonview St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/26/1996 12:00:00 AM | Permit Number 37693 | 6006929.36931778 | 2097797.05936052 | 37.740543028887295 | -122.418608458082 | (37.7405430288873, -122.418608458082) | |||
| 107629 | 107629 | 33588 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 184 Bonview St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/27/1996 12:00:00 AM | Permit Number 37695 | 6007041.74280393 | 2097976.42291715 | 37.741041847234 | -122.418232626766 | (37.741041847234, -122.418232626766) | |||
| 140894 | 140894 | 33607 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 314 Lily St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/02/1996 12:00:00 AM | Permit Number 37719 | 6005021.10976005 | 2110082.43632314 | 37.774168170123794 | -122.42608085228599 | (37.7741681701238, -122.426080852286) | |||
| 124129 | 124129 | 33609 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 308 Lily St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/02/1996 12:00:00 AM | Permit Number 37721 | 6005048.76551317 | 2110086.28535746 | 37.774180301661794 | -122.42598546011699 | (37.7741803016618, -122.425985460117) | |||
| 143220 | 143220 | 33612 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 310 Lily St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/02/1996 12:00:00 AM | Permit Number 37722 | 6005039.5469288 | 2110085.00234602 | 37.774176257824394 | -122.42601725751001 | (37.7741762578244, -122.42601725751) | |||
| 114237 | 114237 | 33613 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 386 Lily St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/02/1996 12:00:00 AM | Permit Number 37723 | 6004689.24070975 | 2110036.24790961 | 37.7740225856392 | -122.42722555593299 | (37.7740225856392, -122.427225555933) | |||
| 141563 | 141563 | 33614 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 312 Lily St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/02/1996 12:00:00 AM | Permit Number 37724 | 6005030.32834442 | 2110083.71933458 | 37.7741722139784 | -122.42604905489999 | (37.7741722139784, -122.4260490549) | |||
| 49595 | 49595 | 33663 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 424 Ivy St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/03/1996 12:00:00 AM | Permit Number 37751 | 6005309.878255201 | 2111164.52643651 | 37.7771556428857 | -122.425158961888 | (37.7771556428857, -122.425158961888) | |||
| 107176 | 107176 | 33695 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 415 Ivy St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/03/1996 12:00:00 AM | Permit Number 37766 | 6005362.72010447 | 2111119.40531281 | 37.7770347362587 | -122.42497295397 | (37.7770347362587, -122.42497295397) | |||
| 125103 | 125103 | 33765 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 1580 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/23/1996 12:00:00 AM | Permit Number 37815 | 6007223.30298499 | 2109757.94023834 | 37.7734013999863 | -122.418440043785 | (37.7734013999863, -122.418440043785) | |||
| 84474 | 84474 | 33816 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 1201 California St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/21/1997 12:00:00 AM | Permit Number 37831 | 6008598.80477101 | 2116262.85239853 | 37.791339665663294 | -122.414142270961 | (37.7913396656633, -122.414142270961) |
JSON shape: default, array, newline-delimited
CREATE TABLE "Street_Tree_List" (
"TreeID" INTEGER,
"qLegalStatus" INTEGER,
"qSpecies" INTEGER,
"qAddress" TEXT,
"SiteOrder" INTEGER,
"qSiteInfo" INTEGER,
"PlantType" INTEGER,
"qCaretaker" INTEGER,
"qCareAssistant" INTEGER,
"PlantDate" TEXT,
"DBH" INTEGER,
"PlotSize" TEXT,
"PermitNotes" TEXT,
"XCoord" REAL,
"YCoord" REAL,
"Latitude" REAL,
"Longitude" REAL,
"Location" TEXT
,
FOREIGN KEY ("PlantType") REFERENCES [PlantType](id),
FOREIGN KEY ("qCaretaker") REFERENCES [qCaretaker](id),
FOREIGN KEY ("qSpecies") REFERENCES [qSpecies](id),
FOREIGN KEY ("qSiteInfo") REFERENCES [qSiteInfo](id),
FOREIGN KEY ("qCareAssistant") REFERENCES [qCareAssistant](id),
FOREIGN KEY ("qLegalStatus") REFERENCES [qLegalStatus](id));
CREATE INDEX ["Street_Tree_List_PlantType"] ON [Street_Tree_List]("PlantType");
CREATE INDEX ["Street_Tree_List_qCaretaker"] ON [Street_Tree_List]("qCaretaker");
CREATE INDEX ["Street_Tree_List_qSpecies"] ON [Street_Tree_List]("qSpecies");
CREATE INDEX ["Street_Tree_List_qSiteInfo"] ON [Street_Tree_List]("qSiteInfo");
CREATE INDEX ["Street_Tree_List_qCareAssistant"] ON [Street_Tree_List]("qCareAssistant");
CREATE INDEX ["Street_Tree_List_qLegalStatus"] ON [Street_Tree_List]("qLegalStatus");