trees
154 rows where Fire Prevention Districts = 7 and qSpecies_id = 54 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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
66733 | 140608 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 840 Fillmore St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 19 | Width 0ft | 6003502.6081 | 2111278.9255 | 37.7773674931794 | -122.431419046703 | (37.7773674931794, -122.431419046703) | 7 | 9 | 11 | 29492 | 10 | |||
125577 | 140609 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 850 Fillmore St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | Width 0ft | 6003501.1005 | 2111292.4942 | 37.777404664022 | -122.431425230844 | (37.777404664022, -122.431425230844) | 7 | 9 | 11 | 29492 | 10 | |||
176648 | 140610 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 860 Fillmore St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | Width 0ft | 6003498.0852 | 2111306.0629 | 37.7774417494141 | -122.431436630621 | (37.7774417494141, -122.431436630621) | 7 | 9 | 11 | 29492 | 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 | |||
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 | |||
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 | |||
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 | |
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 | |||
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 | |||
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 | ||
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 |
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 | ||
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 | ||
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 | ||
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 | ||
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 | ||
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 | ||
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 | |
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 | ||
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
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 | ||
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 | ||
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 | |||
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 | |||
148172 | 141792 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1280 WEBSTER ST | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 0ft | 6003805.1483 | 2112935.1558 | 37.7819322319873 | -122.430490666465 | (37.7819322319873, -122.430490666465) | 7 | 9 | 11 | 29490 | 41 | |||
137918 | 141793 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1280 WEBSTER ST | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 0ft | 6003797.3488 | 2112989.7381 | 37.7820816595285 | -122.430521544957 | (37.7820816595285, -122.430521544957) | 7 | 9 | 11 | 29490 | 41 | |||
72409 | 141798 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1280 WEBSTER ST | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 0ft | 6003785.6349 | 2113107.9429 | 37.7824055567974 | -122.430570506849 | (37.7824055567974, -122.430570506849) | 7 | 9 | 11 | 29490 | 41 | |||
163587 | 141799 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1280 WEBSTER ST | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 0ft | 6003782.7951 | 2113127.1113 | 37.782458027558 | -122.430581699509 | (37.782458027558, -122.430581699509) | 7 | 9 | 11 | 29490 | 41 | |||
30992 | 141781 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1480 ELLIS ST | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 0ft | 6003816.5092 | 2113214.7018 | 37.7827004390473 | -122.430471315153 | (37.7827004390473, -122.430471315153) | 7 | 9 | 11 | 29490 | 41 | |||
189942 | 141780 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1480 ELLIS ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 0ft | 6003842.3971 | 2113219.4567 | 37.7827149612606 | -122.430382093414 | (37.7827149612606, -122.430382093414) | 7 | 9 | 11 | 29490 | 41 | |||
107562 | 141779 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1480 ELLIS ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 0ft | 6003870.3983 | 2113222.6267 | 37.7827252513684 | -122.430285447411 | (37.7827252513684, -122.430285447411) | 7 | 9 | 11 | 29490 | 41 | |||
190297 | 141778 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 9 Hollis St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 0ft | 6003916.891 | 2113262.7794 | 37.7828381339765 | -122.430127467778 | (37.7828381339765, -122.430127467778) | 7 | 9 | 11 | 29490 | 41 | |||
81765 | 141777 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 7 Hollis St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 0ft | 6003915.306 | 2113275.4592 | 37.7828728597693 | -122.430133856067 | (37.7828728597693, -122.430133856067) | 7 | 9 | 11 | 29490 | 41 | |||
183700 | 141776 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 5 Hollis St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 0ft | 6003896.2863 | 2113355.7647 | 37.783092281356 | -122.430205387238 | (37.783092281356, -122.430205387238) | 7 | 9 | 11 | 29490 | 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 | ||
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 | ||
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 | ||
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 | ||
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 | |||
122119 | 141768 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 3 Hollis St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 0ft | 6003889.1539 | 2113490.7518 | 37.7834625181939 | -122.430239695918 | (37.7834625181939, -122.430239695918) | 7 | 9 | 11 | 29490 | 41 | |||
149390 | 141767 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1 Hollis St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 0ft | 6003884.399 | 2113511.8848 | 37.7835202748029 | -122.430257654213 | (37.7835202748029, -122.430257654213) | 7 | 9 | 11 | 29490 | 41 |
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) );