trees
356 rows where qSpecies_id = 91 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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
149335 | 239579 | DPW Maintained 1 | Schinus molle :: California Pepper 91 | 4059 26th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 22 | Width 5ft | 6003506.87632 | 2100667.44546 | 37.7482311647378 | -122.430646881656 | (37.7482311647378, -122.430646881656) | 2 | 4 | 5 | 63 | 22 | |||
181859 | 239580 | DPW Maintained 1 | Schinus molle :: California Pepper 91 | 4019 26th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 25 | Width 5ft | 6003715.87137 | 2100677.69284 | 37.748271139596 | -122.429924914027 | (37.748271139596, -122.429924914027) | 2 | 4 | 5 | 63 | 22 | |||
58803 | 239578 | DPW Maintained 1 | Schinus molle :: California Pepper 91 | 4092 26th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 25 | Width 5ft | 6003302.87663 | 2100696.16376 | 37.7482984592023 | -122.431354355844 | (37.7482984592023, -122.431354355844) | 2 | 4 | 5 | 28862 | 22 | |||
78868 | 239576 | DPW Maintained 1 | Schinus molle :: California Pepper 91 | 3971 26th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 2ft | 6004073.25036 | 2100697.787 | 37.7483465459652 | -122.428690539642 | (37.7483465459652, -122.428690539642) | 2 | 4 | 5 | 63 | 22 | |||
120800 | 239577 | DPW Maintained 1 | Schinus molle :: California Pepper 91 | 3961 26th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 5ft | 6004128.58692 | 2100700.88045 | 37.7483581715004 | -122.428499407621 | (37.7483581715004, -122.428499407621) | 2 | 4 | 5 | 63 | 22 | |||
12994 | 239597 | DPW Maintained 1 | Schinus molle :: California Pepper 91 | 1287 Noe St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 17 | Width 6ft | 6003266.18046 | 2100734.45358 | 37.7484015143127 | -122.431483983218 | (37.7484015143127, -122.431483983218) | 2 | 4 | 5 | 28862 | 22 | |||
17171 | 239598 | DPW Maintained 1 | Schinus molle :: California Pepper 91 | 1287 Noe St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 21 | Width 6ft | 6003265.33612 | 2100745.73511 | 37.7484324428976 | -122.431487708187 | (37.7484324428976, -122.431487708187) | 2 | 4 | 5 | 28862 | 22 | |||
94142 | 46335 | Permitted Site 7 | Schinus molle :: California Pepper 91 | 3441 26th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/13/2002 12:00:00 AM | Permit Number 44585 | 6006853.77058428 | 2100846.52070985 | 37.7489119074947 | -122.419086096292 | (37.7489119074947, -122.419086096292) | 2 | 4 | 7 | 28859 | 19 | ||
60508 | 239566 | DPW Maintained 1 | Schinus molle :: California Pepper 91 | 3441 26th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 5ft | 6006878.39898 | 2100850.62787 | 37.748924571708 | -122.419001222341 | (37.748924571708, -122.419001222341) | 2 | 4 | 7 | 28859 | 19 | |||
89962 | 239567 | DPW Maintained 1 | Schinus molle :: California Pepper 91 | 3435 26th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 5ft | 6006895.64188 | 2100851.73373 | 37.7489285791008 | -122.418941674643 | (37.7489285791008, -122.418941674643) | 2 | 4 | 7 | 28859 | 19 | |||
112295 | 63956 | Permitted Site 7 | Schinus molle :: California Pepper 91 | 4232 25th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/31/1992 12:00:00 AM | 6002352.24062254 | 2101234.22323777 | 37.7497219215876 | -122.434680095003 | (37.7497219215876, -122.434680095003) | 2 | 4 | 5 | 28862 | 22 | |||
164036 | 46334 | Permitted Site 7 | Schinus molle :: California Pepper 91 | 3776 25th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/13/2002 12:00:00 AM | Permit Number 44584 | 6005338.11992395 | 2101398.90311865 | 37.7503431540329 | -122.424366507573 | (37.7503431540329, -122.424366507573) | 2 | 4 | 5 | 28859 | 19 | ||
11330 | 166753 | Planning Code 138.1 required 2 | Schinus molle :: California Pepper 91 | 350 Jersey St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/26/2019 12:00:00 AM | 3 | 4x4 | Permit Number 781737 | 6002856.72425 | 2101550.76622 | 37.7506197011549 | -122.43295818429 | (37.7506197011549, -122.43295818429) | 2 | 4 | 5 | 28862 | 22 | |
96303 | 110276 | Permitted Site 7 | Schinus molle :: California Pepper 91 | 3364 25TH ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/15/2015 12:00:00 AM | 3 | 5x5 | Permit Number 775124 | 6007285 | 2101529 | 37.7508101157283 | -122.417643266234 | (37.7508101157283, -122.417643266234) | 2 | 4 | 7 | 28859 | 19 | |
74800 | 214156 | DPW Maintained 1 | Schinus molle :: California Pepper 91 | 495 Pacheco St | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 7 | Width 6ft | 5993555.55486 | 2101853.98601 | 37.7509203085364 | -122.465144146879 | (37.7509203085364, -122.465144146879) | 1 | 8 | 4 | 29491 | 40 | |||
161884 | 214154 | DPW Maintained 1 | Schinus molle :: California Pepper 91 | 495 Pacheco St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 4 | Width 6ft | 5993534.5206 | 2101855.05369 | 37.750922027151 | -122.46521696231 | (37.750922027151, -122.46521696231) | 1 | 8 | 4 | 29491 | 40 | |||
62891 | 214155 | DPW Maintained 1 | Schinus molle :: California Pepper 91 | 495 Pacheco St | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 5 | Width 6ft | 5993543.01566 | 2101855.50119 | 37.7509237457529 | -122.46518761832 | (37.7509237457529, -122.46518761832) | 1 | 8 | 4 | 29491 | 40 | |||
194508 | 203796 | DPW Maintained 1 | Schinus molle :: California Pepper 91 | 460 Pacheco St | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 1 | Width 6ft | 5993728.30174 | 2101878.83793 | 37.7509985054805 | -122.464548580761 | (37.7509985054805, -122.464548580761) | 1 | 8 | 4 | 29491 | 12 | |||
137902 | 239618 | DPW Maintained 1 | Schinus molle :: California Pepper 91 | 703 Elizabeth St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 21 | Width 3ft | 6001824.43589 | 2102039.44346 | 37.751902886217 | -122.436562889192 | (37.751902886217, -122.436562889192) | 2 | 4 | 5 | 28862 | 22 | |||
162055 | 99797 | Undocumented 4 | Schinus molle :: California Pepper 91 | 703-705 Elizabeth St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6001860 | 2102041 | 37.7519091810186 | -122.436440015083 | (37.7519091810186, -122.436440015083) | 2 | 4 | 5 | 28862 | 22 | ||||
141927 | 197501 | DPW Maintained 1 | Schinus molle :: California Pepper 91 | 1101 Connecticut St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 7 | Width 8ft | 6013434.27998 | 2101904.95506 | 37.752186517095 | -122.396404699215 | (37.752186517095, -122.396404699215) | 10 | 3 | 8 | 28856 | 1 | |||
140313 | 197502 | DPW Maintained 1 | Schinus molle :: California Pepper 91 | 1799 25th St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 7 | Width 8ft | 6013459.53083 | 2101928.68892 | 37.752253090306 | -122.396319040597 | (37.752253090306, -122.396319040597) | 10 | 3 | 8 | 28856 | 1 | |||
25942 | 197503 | DPW Maintained 1 | Schinus molle :: California Pepper 91 | 1799 25th St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 9 | Width 8ft | 6013488.947 | 2101929.32561 | 37.7522564753565 | -122.396217358746 | (37.7522564753565, -122.396217358746) | 10 | 3 | 8 | 28856 | 1 | |||
16110 | 173720 | DPW Maintained 1 | Schinus molle :: California Pepper 91 | 1799x 25th St | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | 6013424 | 2101939 | 37.7522794251173 | -122.396442635345 | (37.7522794251173, -122.396442635345) | 10 | 3 | 8 | 28856 | 1 | |||||
48977 | 173723 | DPW Maintained 1 | Schinus molle :: California Pepper 91 | 1799x 25th St | 2 | Sidewalk: Property side : Cutout | Tree | Private 2 | 6013424 | 2101939 | 37.7522794251173 | -122.396442635345 | (37.7522794251173, -122.396442635345) | 10 | 3 | 8 | 28856 | 1 | |||||
86380 | 173724 | DPW Maintained 1 | Schinus molle :: California Pepper 91 | 1101 Connecticut St | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | 6013424 | 2101939 | 37.7522794251173 | -122.396442635345 | (37.7522794251173, -122.396442635345) | 10 | 3 | 8 | 28856 | 1 | |||||
83160 | 239664 | DPW Maintained 1 | Schinus molle :: California Pepper 91 | 1140 Castro St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 21 | Width 5ft | 6002488.98028 | 2102184.88968 | 37.7523399882133 | -122.434275200945 | (37.7523399882133, -122.434275200945) | 2 | 4 | 5 | 28862 | 22 | |||
119856 | 239663 | DPW Maintained 1 | Schinus molle :: California Pepper 91 | 1134 Castro St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 27 | Width 5ft | 6002486.58464 | 2102202.41494 | 37.7523879724368 | -122.434284738254 | (37.7523879724368, -122.434284738254) | 2 | 4 | 5 | 28862 | 22 | |||
65868 | 197492 | DPW Maintained 1 | Schinus molle :: California Pepper 91 | 1501 25th St | 20 | Sidewalk: Curb side : Yard | Tree | Private 2 | 7 | 6014180.0421 | 2101964.05724 | 37.7523902711102 | -122.393829855665 | (37.7523902711102, -122.393829855665) | 10 | 3 | 8 | 28856 | 1 | ||||
101688 | 50158 | DPW Maintained 1 | Schinus molle :: California Pepper 91 | 1863@ ORTEGA 33rd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/07/2003 12:00:00 AM | 4 | Permit Number 46871 | 5985958.4054 | 2102559.7986 | 37.7524172606528 | -122.491467392102 | (37.7524172606528, -122.491467392102) | 1 | 8 | 3 | 56 | 35 | ||
81055 | 239662 | DPW Maintained 1 | Schinus molle :: California Pepper 91 | 1128 Castro St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 4ft | 6002485.47315 | 2102221.41113 | 37.7524400683713 | -122.434289939928 | (37.7524400683713, -122.434289939928) | 2 | 4 | 5 | 28862 | 22 | |||
132442 | 239661 | DPW Maintained 1 | Schinus molle :: California Pepper 91 | 1128 Castro St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 6ft | 6002484.84221 | 2102239.39907 | 37.7524894231662 | -122.434293407712 | (37.7524894231662, -122.434293407712) | 2 | 4 | 5 | 28862 | 22 | |||
119469 | 214167 | DPW Maintained 1 | Schinus molle :: California Pepper 91 | 1911 09th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 5993435.67173 | 2102452.28847 | 37.7525561798324 | -122.465602172524 | (37.7525561798324, -122.465602172524) | 1 | 8 | 4 | 29491 | 12 | |||
3509 | 99817 | Undocumented 4 | Schinus molle :: California Pepper 91 | 1134 Castro St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7x6 | 6002486 | 2102282 | 37.7526064609065 | -122.434292449268 | (37.7526064609065, -122.434292449268) | 2 | 4 | 5 | 28862 | 22 | ||||
33717 | 99818 | Undocumented 4 | Schinus molle :: California Pepper 91 | 1134 Castro St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6x6 | 6002486 | 2102282 | 37.7526064609065 | -122.434292449268 | (37.7526064609065, -122.434292449268) | 2 | 4 | 5 | 28862 | 22 | ||||
132503 | 239660 | DPW Maintained 1 | Schinus molle :: California Pepper 91 | 1116 Castro St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6002481.9632 | 2102282.2017 | 37.7526067855982 | -122.434306423626 | (37.7526067855982, -122.434306423626) | 2 | 4 | 5 | 28862 | 22 | |||
34168 | 68064 | Permitted Site 7 | Schinus molle :: California Pepper 91 | 1911 09th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/26/1993 12:00:00 AM | Permit Number 31801 | 5993434.8119843 | 2102472.74927138 | 37.7526123103472 | -122.465606631992 | (37.7526123103472, -122.465606631992) | 1 | 8 | 4 | 29491 | 12 | ||
47659 | 53355 | Permitted Site 7 | Schinus molle :: California Pepper 91 | 4131 23rd St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/12/1969 12:00:00 AM | Permit Number 6248 | 6002301.07087845 | 2102348.37639489 | 37.752778216412 | -122.434936712045 | (37.752778216412, -122.434936712045) | 2 | 4 | 5 | 28862 | 22 | |||
70122 | 239595 | DPW Maintained 1 | Schinus molle :: California Pepper 91 | 4131 23rd St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 17 | Width 4ft | 6002300.0276 | 2102351.40526 | 37.7527864737179 | -122.434940536483 | (37.7527864737179, -122.434940536483) | 2 | 4 | 5 | 28862 | 22 | |||
148538 | 66525 | Permitted Site 7 | Schinus molle :: California Pepper 91 | 4121 23rd St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/22/1991 12:00:00 AM | Permit Number 29699 | 6002362.5628629 | 2102351.70560046 | 37.7527908488566 | -122.434724299907 | (37.7527908488566, -122.434724299907) | 2 | 4 | 5 | 28862 | 22 | ||
193003 | 239631 | DPW Maintained 1 | Schinus molle :: California Pepper 91 | 3946 23rd St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 6003468.88792 | 2102461.3534 | 37.7531546624799 | -122.430906252449 | (37.7531546624799, -122.430906252449) | 2 | 4 | 5 | 28862 | 22 | |||
115137 | 251332 | DPW Maintained 1 | Schinus molle :: California Pepper 91 | 920X Shotwell St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/08/2017 12:00:00 AM | 3 | 3x3 | Permit Number 779528 | 6007731 | 2102403 | 37.7532350085981 | -122.416162845847 | (37.7532350085981, -122.416162845847) | 2 | 4 | 7 | 28859 | 19 | |
166862 | 166073 | DPW Maintained 1 | Schinus molle :: California Pepper 91 | 920X Shotwell St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/08/2017 12:00:00 AM | 3 | 3x3 | Permit Number 779528 | 6007731 | 2102403 | 37.7532350085981 | -122.416162845847 | (37.7532350085981, -122.416162845847) | 2 | 4 | 7 | 28859 | 19 | |
40104 | 156622 | DPW Maintained 1 | Schinus molle :: California Pepper 91 | 1245 South Van Ness Ave | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/08/2017 12:00:00 AM | 3 | 3x3 | Permit Number 779528 | 6007708.67537 | 2102405.47581 | 37.7532405513196 | -122.416240224501 | (37.7532405513196, -122.416240224501) | 2 | 4 | 7 | 28859 | 19 | |
81470 | 61782 | Permitted Site 7 | Schinus molle :: California Pepper 91 | 2107 24th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/26/1985 12:00:00 AM | 20 | Permit Number 21804 | 6012179.15182 | 2102325.12749 | 37.7532702936903 | -122.400774668711 | (37.7532702936903, -122.400774668711) | 10 | 3 | 8 | 28856 | 29 | |
63400 | 242003 | DPW Maintained 1 | Schinus molle :: California Pepper 91 | 920 Shotwell St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/08/2017 12:00:00 AM | 3 | 3x3 | Permit Number 779528 | 6007974.01021 | 2102435.99237 | 37.7533392591026 | -122.415324800104 | (37.7533392591026, -122.415324800104) | 2 | 4 | 7 | 28859 | 19 | |
13884 | 258775 | DPW Maintained 1 | Schinus molle :: California Pepper 91 | 833 Corbett Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5999913 | 2102615 | 37.7533744192224 | -122.443214216983 | (37.7533744192224, -122.443214216983) | 2 | 5 | 5 | 63 | 38 | ||||
36387 | 251333 | DPW Maintained 1 | Schinus molle :: California Pepper 91 | 1245 South Van Ness Ave | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/08/2017 12:00:00 AM | 3 | 3x3 | Permit Number 779528 | 6007705.96721 | 2102462.31706 | 37.7533964721949 | -122.416253615419 | (37.7533964721949, -122.416253615419) | 2 | 4 | 7 | 28859 | 19 | |
54324 | 239588 | DPW Maintained 1 | Schinus molle :: California Pepper 91 | 1245 South Van Ness Ave | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 4ft | 6007705.96721 | 2102462.31706 | 37.7533964721949 | -122.416253615419 | (37.7533964721949, -122.416253615419) | 2 | 4 | 7 | 28859 | 19 | |||
185270 | 239632 | DPW Maintained 1 | Schinus molle :: California Pepper 91 | 87 Vicksburg St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 6004121.65636 | 2102563.78903 | 37.7534728911634 | -122.428656150459 | (37.7534728911634, -122.428656150459) | 2 | 4 | 5 | 28862 | 22 | |||
35161 | 239594 | DPW Maintained 1 | Schinus molle :: California Pepper 91 | 636 Douglass St | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 10 | Width 4ft | 6001191.4238 | 2102669.11785 | 37.7535958285084 | -122.43879704705 | (37.7535958285084, -122.43879704705) | 2 | 4 | 5 | 28862 | 22 | |||
191230 | 88822 | Permitted Site 7 | Schinus molle :: California Pepper 91 | 1011 Castro St | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | Permit Number 51709 | 6002511 | 2102645 | 37.7536045914774 | -122.434231943794 | (37.7536045914774, -122.434231943794) | 2 | 4 | 5 | 28862 | 22 | ||||
114455 | 239593 | DPW Maintained 1 | Schinus molle :: California Pepper 91 | 636 Douglass St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 9 | Width 4ft | 6001191.36102 | 2102681.58859 | 37.7536300665832 | -122.438798157734 | (37.7536300665832, -122.438798157734) | 2 | 4 | 5 | 28862 | 22 | |||
47789 | 59597 | Permitted Site 7 | Schinus molle :: California Pepper 91 | 636 Douglass St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/25/1981 12:00:00 AM | 6x25 | Permit Number 18994 | 6001186.92515468 | 2102684.94576678 | 37.7536390322156 | -122.438813738462 | (37.7536390322156, -122.438813738462) | 2 | 4 | 5 | 28862 | 22 | ||
56212 | 197490 | DPW Maintained 1 | Schinus molle :: California Pepper 91 | 1301 Minnesota St | 43 | Front Yard : Yard | Tree | Private 2 | 13 | 6015358.4418 | 2102466.66646 | 37.7538357460423 | -122.38978982496 | (37.7538357460423, -122.38978982496) | 10 | 3 | 8 | 28856 | 29 | ||||
58030 | 197487 | DPW Maintained 1 | Schinus molle :: California Pepper 91 | 1301 Minnesota St | 28 | Front Yard : Yard | Tree | Private 2 | 11 | 6015378.84744 | 2102468.94598 | 37.7538431366753 | -122.389719416144 | (37.7538431366753, -122.389719416144) | 10 | 3 | 8 | 28856 | 29 | ||||
15530 | 239630 | DPW Maintained 1 | Schinus molle :: California Pepper 91 | 431 Alvarado St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 37 | Width 3ft | 6003562.89343 | 2102710.70444 | 37.7538446475336 | -122.430598954102 | (37.7538446475336, -122.430598954102) | 2 | 4 | 5 | 28862 | 22 | |||
20260 | 197489 | DPW Maintained 1 | Schinus molle :: California Pepper 91 | 1301 Minnesota St | 42 | Front Yard : Yard | Tree | Private 2 | 8 | 6015361.30396 | 2102471.04633 | 37.753847930956 | -122.389780232768 | (37.753847930956, -122.389780232768) | 10 | 3 | 8 | 28856 | 29 | ||||
116094 | 197488 | DPW Maintained 1 | Schinus molle :: California Pepper 91 | 1301 Minnesota St | 29 | Front Yard : Yard | Tree | Private 2 | 9 | 6015374.95978 | 2102473.44448 | 37.753855273025 | -122.389733174866 | (37.753855273025, -122.389733174866) | 10 | 3 | 8 | 28856 | 29 | ||||
150336 | 239629 | DPW Maintained 1 | Schinus molle :: California Pepper 91 | 430 Alvarado St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 3ft | 6003569.47839 | 2102760.68831 | 37.753982264481 | -122.430579748167 | (37.753982264481, -122.430579748167) | 2 | 4 | 5 | 28862 | 22 | |||
41914 | 62527 | Permitted Site 7 | Schinus molle :: California Pepper 91 | 4255 22nd St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/15/1986 12:00:00 AM | Permit Number 22709 | 6000857.54483189 | 2102854.89709726 | 37.7540869327376 | -122.439964990906 | (37.7540869327376, -122.439964990906) | 2 | 4 | 5 | 28862 | 22 | ||
117373 | 239600 | DPW Maintained 1 | Schinus molle :: California Pepper 91 | 4255 22nd St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 21 | Width 4ft | 6000853.41096 | 2102858.4973 | 37.754096582697 | -122.439979544931 | (37.754096582697, -122.439979544931) | 2 | 4 | 5 | 28862 | 22 | |||
39126 | 52643 | Permitted Site 7 | Schinus molle :: California Pepper 91 | 4264REVISED 22nd St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/27/2006 12:00:00 AM | Permit Number 48726 | 6000793.82011207 | 2102903.5552845 | 37.7542169085305 | -122.440188854974 | (37.7542169085305, -122.440188854974) | 2 | 4 | 5 | 28862 | 22 | ||
115227 | 239665 | DPW Maintained 1 | Schinus molle :: California Pepper 91 | 3977 22nd St | 7 | : | Tree | Private 2 | 1 | 6001970.62949 | 2102924.44279 | 37.7543411893077 | -122.436120656556 | (37.7543411893077, -122.436120656556) | 2 | 4 | 5 | 28862 | 22 | ||||
162473 | 239604 | DPW Maintained 1 | Schinus molle :: California Pepper 91 | 3980 22nd St | 1 | : | Tree | Private 2 | 1 | 6001965.58933 | 2102953.14284 | 37.7544197064144 | -122.436140140357 | (37.7544197064144, -122.436140140357) | 2 | 4 | 5 | 28862 | 22 | ||||
77030 | 239621 | DPW Maintained 1 | Schinus molle :: California Pepper 91 | 489 Diamond St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 37 | Width 3ft | 6001854.41167 | 2103000.82295 | 37.7545443074853 | -122.436528033262 | (37.7545443074853, -122.436528033262) | 2 | 4 | 5 | 28862 | 22 | |||
146475 | 239633 | DPW Maintained 1 | Schinus molle :: California Pepper 91 | 11 Vicksburg St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 5ft | 6004102.43046 | 2102956.46643 | 37.7545500028912 | -122.428750628764 | (37.7545500028912, -122.428750628764) | 2 | 4 | 5 | 28862 | 22 | |||
121062 | 46566 | Permitted Site 7 | Schinus molle :: California Pepper 91 | 3900 22nd St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/02/2002 12:00:00 AM | Permit Number 44701 | 6002455.82917315 | 2102994.91492425 | 37.7545622428397 | -122.434447752947 | (37.7545622428397, -122.434447752947) | 2 | 4 | 5 | 28862 | 22 | |||
83952 | 109126 | Private 9 | Schinus molle :: California Pepper 91 | 890x CASTRO ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | 3x3 | 6002411 | 2103002 | 37.7545791519678 | -122.434603290485 | (37.7545791519678, -122.434603290485) | 2 | 4 | 5 | 28862 | 22 | |||
186484 | 109125 | Private 9 | Schinus molle :: California Pepper 91 | 890x CASTRO ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3x3 | 6002411 | 2103002 | 37.7545791519678 | -122.434603290485 | (37.7545791519678, -122.434603290485) | 2 | 4 | 5 | 28862 | 22 | |||
166727 | 239603 | DPW Maintained 1 | Schinus molle :: California Pepper 91 | 890 Castro St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 4ft | 6002439.95737 | 2103017.51215 | 37.7546233884599 | -122.434504257392 | (37.7546233884599, -122.434504257392) | 2 | 4 | 5 | 28862 | 22 | |||
62623 | 239602 | DPW Maintained 1 | Schinus molle :: California Pepper 91 | 890 Castro St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 5 | Width 4ft | 6002438.31508 | 2103064.33818 | 37.7547518683248 | -122.434513284763 | (37.7547518683248, -122.434513284763) | 2 | 4 | 5 | 28862 | 22 | |||
134487 | 239620 | DPW Maintained 1 | Schinus molle :: California Pepper 91 | 455 Diamond St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 6001841.52504 | 2103217.25207 | 37.7551378375593 | -122.436588089066 | (37.7551378375593, -122.436588089066) | 2 | 4 | 5 | 28862 | 22 | |||
103771 | 62518 | Permitted Site 7 | Schinus molle :: California Pepper 91 | 4367 21st St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/15/1986 12:00:00 AM | Permit Number 22700 | 6000826.50003313 | 2103245.32733573 | 37.7551571922749 | -122.440100345908 | (37.7551571922749, -122.440100345908) | 2 | 4 | 5 | 28862 | 22 | ||
10299 | 239628 | DPW Maintained 1 | Schinus molle :: California Pepper 91 | 872 Sanchez St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 19 | Width 3ft | 6003717.59485 | 2103189.68577 | 37.7551685799882 | -122.430098127942 | (37.7551685799882, -122.430098127942) | 2 | 4 | 5 | 28862 | 22 | |||
16131 | 55409 | Permitted Site 7 | Schinus molle :: California Pepper 91 | 872 Sanchez St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/27/1987 12:00:00 AM | Permit Number 11349 | 6003719.33886967 | 2103195.40450941 | 37.7551843810696 | -122.430092504551 | (37.7551843810696, -122.430092504551) | 2 | 4 | 5 | 28862 | 22 | ||
85704 | 239634 | DPW Maintained 1 | Schinus molle :: California Pepper 91 | 871 Sanchez St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 17 | Width 3ft | 6003772.61458 | 2103201.71767 | 37.7552047327212 | -122.429908711835 | (37.7552047327212, -122.429908711835) | 2 | 4 | 5 | 28862 | 22 | |||
70184 | 50941 | Permitted Site 7 | Schinus molle :: California Pepper 91 | 871 Sanchez St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/17/2004 12:00:00 AM | Permit Number 47603 | 6003770.24487259 | 2103216.54935313 | 37.7552453228177 | -122.429917964884 | (37.7552453228177, -122.429917964884) | 2 | 4 | 5 | 28862 | 22 | ||
168602 | 62517 | Permitted Site 7 | Schinus molle :: California Pepper 91 | 4315 21st St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/15/1986 12:00:00 AM | Permit Number 22698 | 6001100.3292402 | 2103290.9987582 | 37.7552981802714 | -122.439156639775 | (37.7552981802714, -122.439156639775) | 2 | 4 | 5 | 28862 | 22 | ||
122190 | 239601 | DPW Maintained 1 | Schinus molle :: California Pepper 91 | 4315 21st St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 3ft | 6001018.49265 | 2103293.22516 | 37.7552996363918 | -122.439439814104 | (37.7552996363918, -122.439439814104) | 2 | 4 | 5 | 28862 | 22 | |||
185477 | 52692 | Permitted Site 7 | Schinus molle :: California Pepper 91 | 4362ON CASTRO 21st St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/30/2006 12:00:00 AM | Permit Number 48760 | 6000868.9362336 | 2103304.07672076 | 37.755320919647 | -122.439957801702 | (37.755320919647, -122.439957801702) | 2 | 4 | 5 | 28862 | 38 | ||
79145 | 62516 | Permitted Site 7 | Schinus molle :: California Pepper 91 | 4239 21st St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/15/1986 12:00:00 AM | 3x3 | Permit Number 52133 | 6001380.62959357 | 2103332.31744832 | 37.7554275771996 | -122.438190239105 | (37.7554275771996, -122.438190239105) | 2 | 4 | 5 | 28862 | 22 | ||
67293 | 62515 | Permitted Site 7 | Schinus molle :: California Pepper 91 | 4229 21st St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/15/1986 12:00:00 AM | Permit Number 22695 | 6001411.06683037 | 2103335.42666413 | 37.7554378453979 | -122.43808520078 | (37.7554378453979, -122.43808520078) | 2 | 4 | 5 | 28862 | 22 | ||
169418 | 239623 | DPW Maintained 1 | Schinus molle :: California Pepper 91 | 514 Hill St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 3ft | 6002886.08981 | 2103305.68045 | 37.7554399450095 | -122.432982000136 | (37.7554399450095, -122.432982000136) | 2 | 4 | 5 | 28862 | 22 | |||
63611 | 62514 | Permitted Site 7 | Schinus molle :: California Pepper 91 | 4221 21st St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/15/1986 12:00:00 AM | Permit Number 22694 | 6001435.41662208 | 2103337.91403702 | 37.7554460598899 | -122.438001170091 | (37.7554460598899, -122.438001170091) | 2 | 4 | 5 | 28862 | 22 | ||
142827 | 239622 | DPW Maintained 1 | Schinus molle :: California Pepper 91 | 504 Hill St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 3ft | 6003013.03896 | 2103315.76974 | 37.7554748476953 | -122.43254369215 | (37.7554748476953, -122.43254369215) | 2 | 4 | 5 | 28862 | 22 | |||
9411 | 33144 | Permitted Site 7 | Schinus molle :: California Pepper 91 | 4238 21st St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/05/1996 12:00:00 AM | Permit Number 37370 | 6001375.34520428 | 2103384.04824408 | 37.7555693169237 | -122.438212219782 | (37.7555693169237, -122.438212219782) | 2 | 4 | 5 | 28862 | 3 | |||
122621 | 33145 | Permitted Site 7 | Schinus molle :: California Pepper 91 | 4238 21st St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/09/1996 12:00:00 AM | Permit Number 37370 | 6001375.34520428 | 2103384.04824408 | 37.7555693169237 | -122.438212219782 | (37.7555693169237, -122.438212219782) | 2 | 4 | 5 | 28862 | 3 | ||
103494 | 239624 | DPW Maintained 1 | Schinus molle :: California Pepper 91 | 817 Castro St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6002470.85858 | 2103435.32507 | 37.7557723569304 | -122.434427263721 | (37.7557723569304, -122.434427263721) | 2 | 4 | 5 | 28862 | 22 | |||
135975 | 239619 | DPW Maintained 1 | Schinus molle :: California Pepper 91 | 4145 21st St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 5ft | 6001541.55358 | 2103483.24744 | 37.7558511456308 | -122.437644524497 | (37.7558511456308, -122.437644524497) | 2 | 4 | 5 | 28862 | 22 | |||
99960 | 239625 | DPW Maintained 1 | Schinus molle :: California Pepper 91 | 811 Castro St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 3ft | 6002472.06672 | 2103464.35538 | 37.7558521357906 | -122.434425161094 | (37.7558521357906, -122.434425161094) | 2 | 4 | 5 | 28862 | 22 | |||
105314 | 239626 | DPW Maintained 1 | Schinus molle :: California Pepper 91 | 3885 21st St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 3ft | 6002499.39714 | 2103536.73091 | 37.7560524130043 | -122.434335817949 | (37.7560524130043, -122.434335817949) | 2 | 4 | 5 | 28862 | 22 | |||
23225 | 239627 | DPW Maintained 1 | Schinus molle :: California Pepper 91 | 3885 21st St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 3ft | 6002571.81479 | 2103540.6818 | 37.7560673714328 | -122.434085656222 | (37.7560673714328, -122.434085656222) | 2 | 4 | 5 | 28862 | 22 | |||
89326 | 239635 | DPW Maintained 1 | Schinus molle :: California Pepper 91 | 3691 21st St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6003778.26076 | 2103599.43748 | 37.7562970969591 | -122.429917553956 | (37.7562970969591, -122.429917553956) | 2 | 4 | 5 | 28862 | 22 | |||
189202 | 239636 | DPW Maintained 1 | Schinus molle :: California Pepper 91 | 3691 21st St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6003794.28038 | 2103601.33494 | 37.7563032141343 | -122.429862287926 | (37.7563032141343, -122.429862287926) | 2 | 4 | 5 | 28862 | 22 | |||
23040 | 239637 | DPW Maintained 1 | Schinus molle :: California Pepper 91 | 3691 21st St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6003808.38299 | 2103603.27195 | 37.7563093313217 | -122.429813654389 | (37.7563093313217, -122.429813654389) | 2 | 4 | 5 | 28862 | 22 | |||
13603 | 239638 | DPW Maintained 1 | Schinus molle :: California Pepper 91 | 3689 21st St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6003857.31467 | 2103604.80906 | 37.7563163226577 | -122.429644541356 | (37.7563163226577, -122.429644541356) | 2 | 4 | 5 | 28862 | 22 | |||
93453 | 53873 | Permitted Site 7 | Schinus molle :: California Pepper 91 | 3669 21st St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/05/1987 12:00:00 AM | Permit Number 24724 | 6003927.57680575 | 2103608.86941248 | 37.7563314496504 | -122.429401840118 | (37.7563314496504, -122.429401840118) | 2 | 4 | 5 | 28862 | 22 | ||
156673 | 63979 | Permitted Site 7 | Schinus molle :: California Pepper 91 | 801 Sanchez St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/05/1987 12:00:00 AM | Permit Number 24719 | 6003748.05431866 | 2103616.18796413 | 37.7563413791419 | -122.430023213091 | (37.7563413791419, -122.430023213091) | 2 | 4 | 5 | 28862 | 22 | ||
35105 | 46070 | Permitted Site 7 | Schinus molle :: California Pepper 91 | 3746 21st St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/12/2001 12:00:00 AM | Permit Number 44454 | 6003440.19743527 | 2103634.04731282 | 37.7563729765603 | -122.431089163341 | (37.7563729765603, -122.431089163341) | 2 | 4 | 5 | 28862 | 3 |
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) );