trees
154 rows where Fire Prevention Districts = 7 and qSpecies_id = 54 sorted by Longitude
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
45674 | 9652 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 75 Gough St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 01/07/1995 12:00:00 AM | 3 | 2x3 | 6006083.2108 | 2109791.7339 | 37.7734299424642 | -122.42238619159 | (37.7734299424642, -122.42238619159) | 7 | 9 | 11 | 28852 | 10 | ||
192634 | 244321 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 255 Gough St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 0ft | 6005987.0957 | 2110521.4851 | 37.7754282408756 | -122.422770539085 | (37.7754282408756, -122.422770539085) | 7 | 9 | 11 | 28852 | 10 | |||
80103 | 244379 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 219 Oak St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 17 | Width 0ft | 6005931.9708 | 2110333.2151 | 37.7749081865836 | -122.422947845445 | (37.7749081865836, -122.422947845445) | 7 | 9 | 11 | 28852 | 10 | |||
22833 | 244381 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 221 Oak St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 17 | Width 0ft | 6005910.0454 | 2110329.5608 | 37.7748969155572 | -122.423023430361 | (37.7748969155572, -122.423023430361) | 7 | 9 | 11 | 28852 | 10 | |||
12468 | 9697 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 423 Gough St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | 3X3 | 6005890.102 | 2111192.506 | 37.7772652286056 | -122.423153770988 | (37.7772652286056, -122.423153770988) | 7 | 9 | 11 | 28852 | 10 | |||
40947 | 111735 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 313 Ivy St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | 2.5x3 | 6005874.8827 | 2111210.5438 | 37.7773138971451 | -122.423207702005 | (37.7773138971451, -122.423207702005) | 7 | 9 | 11 | 28852 | 10 | |||
9948 | 16864 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 230 Oak St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3X3 | 6005857.5291 | 2110371.9412 | 37.7750103183132 | -122.423208108745 | (37.7750103183132, -122.423208108745) | 7 | 9 | 11 | 28852 | 10 | |||
42302 | 16867 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 235 Oak St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 5x5 | 6005854.7098 | 2110323.2964 | 37.7748765923478 | -122.423214402753 | (37.7748765923478, -122.423214402753) | 7 | 9 | 11 | 28852 | 10 | |||
3207 | 111734 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 313 Ivy St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | 2.5x3 | 6005865.3001 | 2111209.4164 | 37.777310260787 | -122.423240771205 | (37.777310260787, -122.423240771205) | 7 | 9 | 11 | 28852 | 10 | |||
186831 | 16865 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 230 Oak St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6005838.6934 | 2110371.3705 | 37.7750076883115 | -122.423273225017 | (37.7750076883115, -122.423273225017) | 7 | 9 | 11 | 28852 | 10 | |||
114513 | 111733 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 313 Ivy St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | 2.5x3 | 6005854.5902 | 2111208.289 | 37.777306560799 | -122.423277740102 | (37.777306560799, -122.423277740102) | 7 | 9 | 11 | 28852 | 10 | |||
97373 | 30887 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 412 Hayes St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/08/1995 12:00:00 AM | 21 | 4x5 | Permit Number 34719 | 6005841.0474 | 2111067.7548 | 37.7769199237056 | -122.423314596484 | (37.7769199237056, -122.423314596484) | 7 | 9 | 11 | 28852 | 10 | |
128250 | 111732 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 313 Ivy St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | 2.5x3 | 6005836.5524 | 2111203.7796 | 37.7772931610788 | -122.423339818124 | (37.7772931610788, -122.423339818124) | 7 | 9 | 11 | 28852 | 10 | |||
37910 | 244243 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 150 Page St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 0ft | 6005806.4217 | 2110019.2116 | 37.7740389237303 | -122.423359820085 | (37.7740389237303, -122.423359820085) | 7 | 9 | 11 | 28852 | 10 | |||
43861 | 111731 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 313 Ivy St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | 2.5x3 | 6005824.7151 | 2111202.6522 | 37.7772893974301 | -122.423380687053 | (37.7772893974301, -122.423380687053) | 7 | 9 | 11 | 28852 | 10 | |||
97369 | 30888 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 412 Hayes St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/08/1995 12:00:00 AM | 19 | 4x4 | Permit Number 34719 | 6005821.6341 | 2111061.5148 | 37.7769016945255 | -122.4233813094 | (37.7769016945255, -122.4233813094) | 7 | 9 | 11 | 28852 | 10 | |
175132 | 244244 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 150 Page St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 17 | Width 0ft | 6005791.8047 | 2110016.6014 | 37.7740309317752 | -122.423410197258 | (37.7740309317752, -122.423410197258) | 7 | 9 | 11 | 28852 | 10 | |||
158884 | 111730 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 313 Ivy St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | 2.5x3 | 6005810.6231 | 2111200.9612 | 37.7772839590018 | -122.423429315645 | (37.7772839590018, -122.423429315645) | 7 | 9 | 11 | 28852 | 10 | |||
100641 | 30889 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 412 Hayes St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/08/1995 12:00:00 AM | 21 | 4x4 | Permit Number 34719 | 6005803.6075 | 2111060.8215 | 37.7768987734658 | -122.42344361968 | (37.7768987734658, -122.42344361968) | 7 | 9 | 11 | 28852 | 10 | |
106185 | 105961 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 313 Ivy St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | 6005800.4768 | 2111198.1428 | 37.7772756476903 | -122.423464214596 | (37.7772756476903, -122.423464214596) | 7 | 9 | 11 | 28852 | 10 | ||||
192060 | 244242 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 151 Lily St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 0ft | 6005776.1437 | 2110149.7201 | 37.7743955596449 | -122.423473837096 | (37.7743955596449, -122.423473837096) | 7 | 9 | 11 | 28852 | 10 | |||
98121 | 16873 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 262 Oak St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 4X4 | 6005733.6702 | 2110353.6763 | 37.7749531766501 | -122.423635265131 | (37.7749531766501, -122.423635265131) | 7 | 9 | 11 | 28852 | 10 | |||
81768 | 16876 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 274 Oak St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6005679.4463 | 2110349.1101 | 37.7749375780539 | -122.423822512667 | (37.7749375780539, -122.423822512667) | 7 | 9 | 11 | 28852 | 10 | |||
76159 | 110471 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 465 Grove St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12 | 3x3 | 6005689.0684 | 2111342.3906 | 37.7776654283212 | -122.423859872139 | (37.7776654283212, -122.423859872139) | 7 | 9 | 11 | 28852 | 10 | ||
120810 | 139440 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 495 Grove St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 0ft | 6005652 | 2111358 | 37.7777061952248 | -122.423989214784 | (37.7777061952248, -122.423989214784) | 7 | 9 | 11 | 28852 | 10 | |||
105786 | 140059 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 442 GROVE ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | Width 0ft | 6005650.7649 | 2111385.4165 | 37.7777814045245 | -122.423995437557 | (37.7777814045245, -122.423995437557) | 7 | 9 | 11 | 28852 | 10 | |||
55824 | 110470 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 465 Grove St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 15 | 3x3 | 6005644.9931 | 2111337.1436 | 37.7776485330384 | -122.424011970547 | (37.7776485330384, -122.424011970547) | 7 | 9 | 11 | 28852 | 10 | ||
109156 | 110469 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 465 Grove St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 15 | 3x3 | 6005632.4002 | 2111334.52 | 37.7776406182957 | -122.424055347089 | (37.7776406182957, -122.424055347089) | 7 | 9 | 11 | 28852 | 10 | ||
82036 | 140060 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 448 GROVE ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 0ft | 6005624.0049 | 2111381.7435 | 37.777769808526 | -122.424087748475 | (37.777769808526, -122.424087748475) | 7 | 9 | 11 | 28852 | 10 | |||
114167 | 110468 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 465 Grove St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 15 | 3x3 | 6005616.1343 | 2111331.3718 | 37.7776310557335 | -122.42411139247 | (37.7776310557335, -122.42411139247) | 7 | 9 | 11 | 28852 | 10 | ||
125623 | 140061 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 448 GROVE ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 17 | Width 0ft | 6005605.1155 | 2111378.5953 | 37.7777600978209 | -122.42415286955 | (37.7777600978209, -122.42415286955) | 7 | 9 | 11 | 28852 | 10 | |||
159706 | 244974 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 205 Rose St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 0ft | 6005564.966 | 2109773.8307 | 37.7733515366804 | -122.424177602904 | (37.7733515366804, -122.424177602904) | 7 | 9 | 11 | 28852 | 10 | |||
32066 | 110467 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 465 Grove St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 15 | 3x3 | 6005585.7014 | 2111327.1742 | 37.7776178118347 | -122.424216371681 | (37.7776178118347, -122.424216371681) | 7 | 9 | 11 | 28852 | 10 | ||
61814 | 110466 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 465 Grove St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 16 | 3x3 | 6005573.1085 | 2111325.0754 | 37.7776113379896 | -122.424259785517 | (37.7776113379896, -122.424259785517) | 7 | 9 | 11 | 28852 | 10 | ||
8024 | 59162 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 465 Grove St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/16/1981 12:00:00 AM | 16 | 3x3 | Permit Number 19443 | 6005553.1697 | 2111320.8777 | 37.7775986862615 | -122.424328461999 | (37.7775986862615, -122.424328461999) | 7 | 9 | 11 | 28852 | 10 |
111800 | 139444 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 508 OCTAVIA ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | Width 0ft | 6005475.2331 | 2111036.3665 | 37.7768130866772 | -122.424577827872 | (37.7768130866772, -122.424577827872) | 7 | 9 | 11 | 28852 | 10 | |||
117632 | 57633 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 486 Grove St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/04/1976 12:00:00 AM | 19 | Permit Number 16531 | 6005481.2851 | 2111360.2306 | 37.7777026803458 | -122.424579935329 | (37.7777026803458, -122.424579935329) | 7 | 9 | 11 | 28852 | 10 | ||
109817 | 139445 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 508 OCTAVIA ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 0ft | 6005470.16 | 2111049.3311 | 37.7768483978097 | -122.424596299715 | (37.7768483978097, -122.424596299715) | 7 | 9 | 11 | 28852 | 10 | |||
115024 | 139446 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 508 OCTAVIA ST | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 0ft | 6005466.7779 | 2111071.8783 | 37.7769101159246 | -122.424609603708 | (37.7769101159246, -122.424609603708) | 7 | 9 | 11 | 28852 | 10 | |||
24303 | 139447 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 508 OCTAVIA ST | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 0ft | 6005464.5232 | 2111090.4798 | 37.7769610637771 | -122.424618726949 | (37.7769610637771, -122.424618726949) | 7 | 9 | 11 | 28852 | 10 | |||
98584 | 139448 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 508 OCTAVIA ST | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 0ft | 6005463.3958 | 2111104.0081 | 37.7769981455225 | -122.424623589548 | (37.7769981455225, -122.424623589548) | 7 | 9 | 11 | 28852 | 10 | |||
54245 | 139449 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 508 OCTAVIA ST | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 0ft | 6005461.1411 | 2111122.6096 | 37.7770490933731 | -122.42463271281 | (37.7770490933731, -122.42463271281) | 7 | 9 | 11 | 28852 | 10 | |||
33826 | 59960 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 492 Grove St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/19/1981 12:00:00 AM | 21 | Permit Number 19438 | 6005457.1486 | 2111358.1318 | 37.7776955544263 | -122.424663282479 | (37.7776955544263, -122.424663282479) | 7 | 9 | 11 | 28852 | 10 | |
106385 | 139439 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 495 Grove St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 0ft | 6005453.4757 | 2111308.2848 | 37.7775584792902 | -122.424672441445 | (37.7775584792902, -122.424672441445) | 7 | 9 | 11 | 28852 | 10 | |||
120999 | 244926 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 223 Lily St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 0ft | 6005428.5225 | 2110104.1516 | 37.774250812984 | -122.424673083057 | (37.774250812984, -122.424673083057) | 7 | 9 | 11 | 28852 | 10 | |||
144570 | 58783 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 500 Hayes St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/28/1979 12:00:00 AM | 15 | 3x3 | Permit Number 18026 | 6005406.4028 | 2111007.6387 | 37.7767303197423 | -122.424813888538 | (37.7767303197423, -122.424813888538) | 7 | 9 | 11 | 28852 | 10 | |
185324 | 57510 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 630 Octavia St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/30/1976 12:00:00 AM | 16 | Permit Number 16363 | 6005412.5487 | 2111488.2587 | 37.7780503321524 | -122.424826828837 | (37.7780503321524, -122.424826828837) | 7 | 9 | 11 | 28852 | 10 | ||
182947 | 33693 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 401 Ivy St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/03/1996 12:00:00 AM | 13 | Permit Number 37765 | 6005397.8063 | 2111143.0332 | 37.7771015944949 | -122.424853261184 | (37.7771015944949, -122.424853261184) | 7 | 9 | 11 | 28852 | 10 | ||
2553 | 140071 | Undocumented 4 | Ficus retusa nitida :: Banyan Fig 54 | 601X Octavia St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 0ft | 6005402 | 2111410 | 37.7778348570605 | -122.424857751543 | (37.7778348570605, -122.424857751543) | 7 | 9 | 11 | 28852 | 10 | |||
18163 | 140072 | Undocumented 4 | Ficus retusa nitida :: Banyan Fig 54 | 601X Octavia St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 0ft | 6005402 | 2111410 | 37.7778348570605 | -122.424857751543 | (37.7778348570605, -122.424857751543) | 7 | 9 | 11 | 28852 | 10 | |||
39578 | 140070 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 601X Octavia St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 0ft | 6005402 | 2111410 | 37.7778348570605 | -122.424857751543 | (37.7778348570605, -122.424857751543) | 7 | 9 | 11 | 28852 | 10 | |||
185720 | 139434 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 406 Ivy St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 0ft | 6005390.0639 | 2111164.7368 | 37.7771607499747 | -122.424881589077 | (37.7771607499747, -122.424881589077) | 7 | 9 | 11 | 28852 | 10 | |||
187565 | 33694 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 401 Ivy St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/03/1996 12:00:00 AM | 12 | Permit Number 37765 | 6005381.091 | 2111139.6901 | 37.7770914710207 | -122.424910846803 | (37.7770914710207, -122.424910846803) | 7 | 9 | 11 | 28852 | 10 | ||
129493 | 139435 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 408 Ivy St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 0ft | 6005375.9537 | 2111162.1376 | 37.7771528162036 | -122.424930215803 | (37.7771528162036, -122.424930215803) | 7 | 9 | 11 | 28852 | 10 | |||
77520 | 33692 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 401 Ivy St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/03/1996 12:00:00 AM | 11 | Permit Number 37765 | 6005361.9877 | 2111137.3022 | 37.7770838353758 | -122.42497676123 | (37.7770838353758, -122.42497676123) | 7 | 9 | 11 | 28852 | 10 | ||
181093 | 139436 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 410 Ivy St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 0ft | 6005361.8436 | 2111159.167 | 37.7771438626442 | -122.424978815742 | (37.7771438626442, -122.424978815742) | 7 | 9 | 11 | 28852 | 10 | |||
12129 | 57526 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 501 Grove St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/16/1981 12:00:00 AM | 13 | 3x3 | Permit Number 19437 | 6005352.078 | 2111299.9206 | 37.7775297860553 | -122.425022615137 | (37.7775297860553, -122.425022615137) | 7 | 9 | 11 | 28852 | 10 | |
29165 | 108003 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 520 Hayes St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 21 | 4x4 | 6005338.5862 | 2110997.1319 | 37.7766976400209 | -122.425047738741 | (37.7766976400209, -122.425047738741) | 7 | 9 | 11 | 28852 | 10 | |||
118375 | 10259 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 180 Haight St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 90 | 3X3 | 6005281.5755 | 2109598.2125 | 37.7728533265249 | -122.425145392536 | (37.7728533265249, -122.425145392536) | 7 | 9 | 11 | 28852 | 10 | |||
122196 | 108005 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 520 Hayes St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 21 | 3x3 | 6005304.2003 | 2110990.4457 | 37.7766773388863 | -122.425166213949 | (37.7766773388863, -122.425166213949) | 7 | 9 | 11 | 28852 | 10 | |||
87483 | 108006 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 520 Hayes St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 17 | 3x3 | 6005290.3504 | 2110988.0578 | 37.7766699998805 | -122.425213954913 | (37.7766699998805, -122.425213954913) | 7 | 9 | 11 | 28852 | 10 | |||
87360 | 108011 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 419X Ivy St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | 6005290.828 | 2111124.4075 | 37.7770444098803 | -122.42522200735 | (37.7770444098803, -122.42522200735) | 7 | 9 | 11 | 28852 | 10 | ||||
157202 | 140051 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 501 FULTON ST | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 0ft | 6005299.4561 | 2111632.5014 | 37.7784399990073 | -122.42522832358 | (37.7784399990073, -122.42522832358) | 7 | 9 | 11 | 28852 | 10 | |||
174691 | 108010 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 419X Ivy St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | 6005279.8436 | 2111122.0196 | 37.7770372327377 | -122.42525983588 | (37.7770372327377, -122.42525983588) | 7 | 9 | 11 | 28852 | 10 | ||||
188275 | 59956 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 426 Ivy St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/16/1981 12:00:00 AM | 16 | Permit Number 19433 | 6005279.4106 | 2111149.1414 | 37.7771116781194 | -122.42526326419 | (37.7771116781194, -122.42526326419) | 7 | 9 | 11 | 28852 | 10 | ||
106720 | 245842 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 350 Oak St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 0ft | 6005254.4582 | 2110291.4547 | 37.7747552696018 | -122.425288534719 | (37.7747552696018, -122.425288534719) | 7 | 9 | 11 | 28852 | 10 | |||
156143 | 108009 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 419X Ivy St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | 6005268.3816 | 2111120.1092 | 37.7770313396992 | -122.425299350558 | (37.7770313396992, -122.425299350558) | 7 | 9 | 11 | 28852 | 10 | ||||
61349 | 140050 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 501 FULTON ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 0ft | 6005278.6254 | 2111629.2967 | 37.7784300228635 | -122.425300156764 | (37.7784300228635, -122.425300156764) | 7 | 9 | 11 | 28852 | 10 | |||
43203 | 30704 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 369 Oak St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/31/1995 12:00:00 AM | 12 | Permit Number 34615 | 6005232.8948 | 2110236.794 | 37.7746039663436 | -122.42535923638 | (37.7746039663436, -122.42535923638) | 7 | 9 | 11 | 28852 | 10 | |
169233 | 68430 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 501 Fulton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/26/1993 12:00:00 AM | 6 | Permit Number 32281 | 6005253.5217 | 2111626.0919 | 37.7784198049854 | -122.425386771844 | (37.7784198049854, -122.425386771844) | 7 | 9 | 11 | 28852 | 10 | ||
23351 | 33662 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 453 Linden St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/11/2016 12:00:00 AM | 3 | Permit Number 37750 | 6005235.3039 | 2110769.7304 | 37.7760674161616 | -122.425388836438 | (37.7760674161616, -122.425388836438) | 7 | 9 | 11 | 28852 | 10 | ||
177953 | 16896 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 377 Oak St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3X3 | 6005209.3255 | 2110233.2837 | 37.7745929962798 | -122.425440517449 | (37.7745929962798, -122.425440517449) | 7 | 9 | 11 | 28852 | 10 | |||
3763 | 73629 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 530 Grove St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 20 | 5x7 | 6005222.8265 | 2111323.2215 | 37.7775864626885 | -122.425471398253 | (37.7775864626885, -122.425471398253) | 7 | 9 | 11 | 28852 | 10 | ||
93977 | 245843 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 350 Oak St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 19 | Width 0ft | 6005198.7946 | 2110284.9355 | 37.7747342245718 | -122.42548062261 | (37.7747342245718, -122.42548062261) | 7 | 9 | 11 | 28852 | 10 | |||
133022 | 245850 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 381 Oak St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 0ft | 6005186.7592 | 2110228.7704 | 37.7745793288374 | -122.42551825752 | (37.7745793288374, -122.42551825752) | 7 | 9 | 11 | 28852 | 10 | |||
166303 | 33642 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 462 Linden St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/03/1996 12:00:00 AM | 10 | Permit Number 37736 | 6005186.1558 | 2110786.6502 | 37.776111096903 | -122.42556005737 | (37.776111096903, -122.42556005737) | 7 | 9 | 11 | 28852 | 10 | |
6485 | 71703 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 530 Grove St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 14 | 6005189.8095 | 2111320.4314 | 37.7775769362179 | -122.425585416633 | (37.7775769362179, -122.425585416633) | 7 | 9 | 11 | 28852 | 10 | |||
181551 | 244967 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 290 Lily St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 0ft | 6005160.4976 | 2110090.7807 | 37.7741989587748 | -122.425599278654 | (37.7741989587748, -122.425599278654) | 7 | 9 | 11 | 28852 | 10 | |||
19361 | 61824 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 568 Hayes St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/04/1985 12:00:00 AM | 19 | Permit Number 21857 | 6005139.9121 | 2110969.4321 | 37.7766103583758 | -122.425733039566 | (37.7766103583758, -122.425733039566) | 7 | 9 | 11 | 28852 | 10 | ||
138710 | 245220 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 351 Laguna St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 20 | Width 0ft | 6005075.2787 | 2110089.7787 | 37.7741913919096 | -122.425893994936 | (37.7741913919096, -122.425893994936) | 7 | 9 | 11 | 28852 | 10 | |||
128466 | 6224 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1220 Ellis St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3X4 | 6005090.9413 | 2113387.3731 | 37.7832466624445 | -122.426074615309 | (37.7832466624445, -122.426074615309) | 7 | 9 | 11 | 28858 | 41 | |||
50842 | 142266 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 503 Laguna St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 17 | Width 0ft | 6004999.4413 | 2110629.3324 | 37.7756685888616 | -122.426194750692 | (37.7756685888616, -122.426194750692) | 7 | 9 | 11 | 28852 | 10 | |||
38809 | 140069 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 582 GROVE ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 19 | Width 0ft | 6005006.5887 | 2111294.3898 | 37.7774950779447 | -122.426217384893 | (37.7774950779447, -122.426217384893) | 7 | 9 | 11 | 28852 | 10 | |||
173051 | 140068 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 582 GROVE ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 0ft | 6005004.7286 | 2111303.2254 | 37.7775192332012 | -122.426224448803 | (37.7775192332012, -122.426224448803) | 7 | 9 | 11 | 28852 | 10 | |||
157841 | 12247 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 503 Laguna St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6004991.7276 | 2110673.0436 | 37.7757881731565 | -122.426224546997 | (37.7757881731565, -122.426224546997) | 7 | 9 | 11 | 28852 | 10 | |||
3486 | 12249 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 511 Laguna St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6004989.1563 | 2110705.1842 | 37.7758762780635 | -122.426235730542 | (37.7758762780635, -122.426235730542) | 7 | 9 | 11 | 28852 | 10 | |||
43620 | 12248 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 511 Linden St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6004985.728 | 2110723.6115 | 37.7759266811529 | -122.426248902156 | (37.7759266811529, -122.426248902156) | 7 | 9 | 11 | 28852 | 10 | |||
23337 | 142265 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 500 FELL ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | Width 0ft | 6004973.0459 | 2110598.408 | 37.7755821860494 | -122.426283856756 | (37.7755821860494, -122.426283856756) | 7 | 9 | 11 | 28852 | 10 | |||
108929 | 12264 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 640 Laguna St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6004966.4829 | 2111191.3303 | 37.7772098348265 | -122.426348784703 | (37.7772098348265, -122.426348784703) | 7 | 9 | 11 | 28852 | 10 | |||
40612 | 6232 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1220 Ellis St | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 01/02/1991 12:00:00 AM | 12 | 3X3 | 6005007.0756 | 2113377.0261 | 37.7832135118405 | -122.426364020332 | (37.7832135118405, -122.426364020332) | 7 | 9 | 11 | 28858 | 41 | ||
120101 | 139443 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 640 LAGUNA ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | Width 0ft | 6004962.1321 | 2111203.2952 | 37.777242441577 | -122.426364687622 | (37.777242441577, -122.426364687622) | 7 | 9 | 11 | 28852 | 10 | |||
119689 | 12265 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 646 Laguna St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6004962.1321 | 2111217.4355 | 37.7772812673791 | -122.426365694654 | (37.7772812673791, -122.426365694654) | 7 | 9 | 11 | 28852 | 10 | |||
75673 | 12271 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 700X Laguna St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6004951.5507 | 2111300.9055 | 37.7775098574182 | -122.426408243779 | (37.7775098574182, -122.426408243779) | 7 | 9 | 11 | 28852 | 10 | |||
33837 | 138854 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 519 Ivy St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 0ft | 6004884.6976 | 2111071.1642 | 37.7768752647693 | -122.426623147275 | (37.7768752647693, -122.426623147275) | 7 | 9 | 11 | 28852 | 10 | |||
59417 | 6235 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1250 Ellis St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 01/02/1991 12:00:00 AM | 12 | 3X3 | 6004904.9664 | 2113362.05 | 37.7831666187465 | -122.426716210533 | (37.7831666187465, -122.426716210533) | 7 | 9 | 11 | 28858 | 41 | ||
136758 | 6242 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1250 Ellis St | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 01/02/1991 12:00:00 AM | 12 | 3X3 | 6004855.4094 | 2113352.7921 | 37.7831383969133 | -122.426886998286 | (37.7831383969133, -122.426886998286) | 7 | 9 | 11 | 28858 | 41 | ||
131718 | 6245 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1280 Ellis St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 05/20/1995 12:00:00 AM | 18 | 3X3 | 6004753.0279 | 2113338.633 | 37.7830937301366 | -122.427240188063 | (37.7830937301366, -122.427240188063) | 7 | 9 | 11 | 28858 | 41 | ||
28061 | 244147 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 405 Rose St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 0ft | 6004529.1957 | 2109628.6007 | 37.7728942335898 | -122.427750128017 | (37.7728942335898, -122.427750128017) | 7 | 9 | 11 | 28852 | 10 | |||
132720 | 244480 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 436 Page St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 0ft | 6004459.1128 | 2109828.0982 | 37.7734380404188 | -122.428006772012 | (37.7734380404188, -122.428006772012) | 7 | 9 | 11 | 28852 | 10 | |||
38313 | 31337 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 745 Buchanan St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/12/1995 12:00:00 AM | 16 | 6x18 | Permit Number 34951 | 6004453.62375 | 2111092.99154 | 37.7769108173179 | -122.428115918737 | (37.7769108173179, -122.428115918737) | 7 | 9 | 11 | 28852 | 10 |
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) );