trees
1,024 rows where qSpecies_id = 72 sorted by PlantDate descending
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
72763 | 1820 | DPW Maintained 1 | Washingtonia robusta :: Mexican Fan Palm 72 | 2100 Bay Shore Blvd | 1 | Median : Cutout | Tree | DPW 1 | 12/30/1991 12:00:00 AM | 3 | 6 | 6011846.03792 | 2087600.59079 | 37.7128212089973 | -122.400892211026 | (37.7128212089973, -122.400892211026) | 10 | 7 | 8 | 309 | 1 | ||
79950 | 1821 | DPW Maintained 1 | Washingtonia robusta :: Mexican Fan Palm 72 | 2100 Bay Shore Blvd | 2 | Median : Cutout | Tree | DPW 1 | 12/30/1991 12:00:00 AM | 6 | 6 | 6011817.46157 | 2087571.87835 | 37.7127407763393 | -122.400988964593 | (37.7127407763393, -122.400988964593) | 10 | 7 | 8 | 309 | 1 | ||
21670 | 1798 | DPW Maintained 1 | Washingtonia robusta :: Mexican Fan Palm 72 | 2000 Bay Shore Blvd | 6 | Median : Cutout | Tree | DPW 1 | 12/27/1991 12:00:00 AM | 12 | 6 | 6012206.26499 | 2088043.30695 | 37.7140569062806 | -122.399678207209 | (37.7140569062806, -122.399678207209) | 10 | 3 | 8 | 309 | 39 | ||
54748 | 1801 | DPW Maintained 1 | Washingtonia robusta :: Mexican Fan Palm 72 | 2020 Bay Shore Blvd | 3 | Median : Cutout | Tree | DPW 1 | 12/27/1991 12:00:00 AM | 12 | 6 | 6012311.3625688 | 2088370.0571879 | 37.7149599552833 | -122.399337871901 | (37.7149599552833, -122.399337871901) | 10 | 7 | 8 | 309 | 39 | ||
93706 | 1810 | DPW Maintained 1 | Washingtonia robusta :: Mexican Fan Palm 72 | 2040 Bay Shore Blvd | 2 | Median : Cutout | Tree | DPW 1 | 12/27/1991 12:00:00 AM | 12 | 6 | 6012267.4866135 | 2088237.9390645 | 37.7145947398058 | -122.399480256716 | (37.7145947398058, -122.399480256716) | 10 | 7 | 8 | 309 | 39 | ||
96674 | 1800 | DPW Maintained 1 | Washingtonia robusta :: Mexican Fan Palm 72 | 2020 Bay Shore Blvd | 2 | Median : Cutout | Tree | DPW 1 | 12/27/1991 12:00:00 AM | 12 | 6 | 6012311.3625688 | 2088370.0571879 | 37.7149599552833 | -122.399337871901 | (37.7149599552833, -122.399337871901) | 10 | 7 | 8 | 309 | 39 | ||
133388 | 1797 | DPW Maintained 1 | Washingtonia robusta :: Mexican Fan Palm 72 | 2010 Bay Shore Blvd | 5 | Median : Cutout | Tree | DPW 1 | 12/27/1991 12:00:00 AM | 12 | 6012333.445831 | 2088436.5537269 | 37.7151437722719 | -122.399266207491 | (37.7151437722719, -122.399266207491) | 10 | 7 | 8 | 309 | 39 | |||
39827 | 15743 | DPW Maintained 1 | Washingtonia robusta :: Mexican Fan Palm 72 | 4545 Mission St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/21/2001 12:00:00 AM | 12 | 3x3 | 6002337.7208 | 2092395.6969 | 37.7254525452522 | -122.434098558087 | (37.7254525452522, -122.434098558087) | 9 | 7 | 6 | 28861 | 5 | ||
20875 | 15741 | DPW Maintained 1 | Washingtonia robusta :: Mexican Fan Palm 72 | 4531 Mission St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/21/2000 12:00:00 AM | 12 | 3x3 | 6002397.2069 | 2092488.306 | 37.7257102048968 | -122.433899536724 | (37.7257102048968, -122.433899536724) | 9 | 7 | 6 | 28861 | 5 | ||
34601 | 15464 | Permitted Site 7 | Washingtonia robusta :: Mexican Fan Palm 72 | 2434 Mission St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/21/2000 12:00:00 AM | 12 | 4X4 | 6006931.67181 | 2104190.23259 | 37.7580973613707 | -122.41905384857 | (37.7580973613707, -122.41905384857) | 2 | 4 | 7 | 28859 | 19 | ||
159361 | 15738 | DPW Maintained 1 | Washingtonia robusta :: Mexican Fan Palm 72 | 4516 Mission St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/18/1997 12:00:00 AM | 12 | 3X3 | 6002290.9845 | 2092433.856 | 37.7255546689432 | -122.434262847922 | (37.7255546689432, -122.434262847922) | 9 | 7 | 6 | 28861 | 25 | ||
139996 | 21858 | DPW Maintained 1 | Washingtonia robusta :: Mexican Fan Palm 72 | 1830 03rd St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/14/2000 12:00:00 AM | 6 | 3X3 | 6015621.79594 | 2107069.76565 | 37.7664894707397 | -122.389200472218 | (37.7664894707397, -122.389200472218) | 14 | 3 | 9 | 310 | 29 | ||
13986 | 33558 | DPW Maintained 1 | Washingtonia robusta :: Mexican Fan Palm 72 | 2400 Fulton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/11/1996 12:00:00 AM | 14 | Permit Number 37664 | 5996252.18034 | 2110425.94618 | 37.7746118487481 | -122.456438795749 | (37.7746118487481, -122.456438795749) | 11 | 5 | 2 | 54 | 16 | |
22487 | 33555 | DPW Maintained 1 | Washingtonia robusta :: Mexican Fan Palm 72 | 2400 Fulton St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/11/1996 12:00:00 AM | 14 | Permit Number 37664 | 5996213.16627 | 2110420.46964 | 37.7745945717567 | -122.456573356196 | (37.7745945717567, -122.456573356196) | 11 | 5 | 2 | 54 | 16 | ||
68151 | 33557 | DPW Maintained 1 | Washingtonia robusta :: Mexican Fan Palm 72 | 2400 Fulton St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/11/1996 12:00:00 AM | 12 | Permit Number 37664 | 5996239.10441 | 2110423.85984 | 37.7746053695164 | -122.456483876805 | (37.7746053695164, -122.456483876805) | 11 | 5 | 2 | 54 | 16 | ||
85759 | 33556 | DPW Maintained 1 | Washingtonia robusta :: Mexican Fan Palm 72 | 2400 Fulton St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/11/1996 12:00:00 AM | 12 | Permit Number 37664 | 5996225.02102 | 2110420.81163 | 37.774596191384 | -122.456532373263 | (37.774596191384, -122.456532373263) | 11 | 5 | 2 | 54 | 16 | ||
168023 | 33554 | DPW Maintained 1 | Washingtonia robusta :: Mexican Fan Palm 72 | 2400 Fulton St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/11/1996 12:00:00 AM | 12 | Permit Number 37664 | 5996192.14187 | 2110415.99351 | 37.7745810743751 | -122.456645759522 | (37.7745810743751, -122.456645759522) | 11 | 5 | 2 | 54 | 16 | ||
194261 | 15784 | DPW Maintained 1 | Washingtonia robusta :: Mexican Fan Palm 72 | 4840 Mission St | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/02/2015 02:53:00 PM | 3 | 3X3 | Permit Number 785142 | 6001135.2157 | 2090596.8347 | 37.7204449566644 | -122.438126700052 | (37.7204449566644, -122.438126700052) | 9 | 7 | 6 | 28861 | 25 | |
178561 | 15742 | DPW Maintained 1 | Washingtonia robusta :: Mexican Fan Palm 72 | 4534 Mission St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/22/1999 12:00:00 AM | 12 | 3X3 | 6002267.3808 | 2092395.6017 | 37.7254482915062 | -122.434341710076 | (37.7254482915062, -122.434341710076) | 9 | 7 | 6 | 28861 | 25 | ||
28394 | 82270 | Permitted Site 7 | Washingtonia robusta :: Mexican Fan Palm 72 | 3541 20th St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/21/2007 12:00:00 AM | 3x3 | Permit Number 49902 | 6006669.42046782 | 2104344.22621121 | 37.7585054206163 | -122.419971755856 | (37.7585054206163, -122.419971755856) | 2 | 4 | 7 | 28859 | 19 | ||
67637 | 82269 | Permitted Site 7 | Washingtonia robusta :: Mexican Fan Palm 72 | 3541 20th St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/21/2007 12:00:00 AM | 3x3 | Permit Number 49902 | 6006669.42046782 | 2104344.22621121 | 37.7585054206163 | -122.419971755856 | (37.7585054206163, -122.419971755856) | 2 | 4 | 7 | 28859 | 19 | ||
97291 | 82273 | Permitted Site 7 | Washingtonia robusta :: Mexican Fan Palm 72 | 3541 20th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/21/2007 12:00:00 AM | 3x3 | Permit Number 49902 | 6006669.42046782 | 2104344.22621121 | 37.7585054206163 | -122.419971755856 | (37.7585054206163, -122.419971755856) | 2 | 4 | 7 | 28859 | 19 | ||
172573 | 82271 | Permitted Site 7 | Washingtonia robusta :: Mexican Fan Palm 72 | 3541 20th St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/21/2007 12:00:00 AM | 3x3 | Permit Number 49902 | 6006669.42046782 | 2104344.22621121 | 37.7585054206163 | -122.419971755856 | (37.7585054206163, -122.419971755856) | 2 | 4 | 7 | 28859 | 19 | ||
173634 | 82272 | Permitted Site 7 | Washingtonia robusta :: Mexican Fan Palm 72 | 3541 20th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/21/2007 12:00:00 AM | 3x3 | Permit Number 49902 | 6006669.42046782 | 2104344.22621121 | 37.7585054206163 | -122.419971755856 | (37.7585054206163, -122.419971755856) | 2 | 4 | 7 | 28859 | 19 | ||
2813 | 33314 | DPW Maintained 1 | Washingtonia robusta :: Mexican Fan Palm 72 | 1229 Francisco St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/14/1996 12:00:00 AM | 18 | Permit Number 37460 | 6005325.69823 | 2120590.66128 | 37.8030383405174 | -122.425775331487 | (37.8030383405174, -122.425775331487) | 13 | 9 | 1 | 28858 | 17 | |
32570 | 33315 | DPW Maintained 1 | Washingtonia robusta :: Mexican Fan Palm 72 | 1229 Francisco St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/14/1996 12:00:00 AM | 19 | Permit Number 37460 | 6005351.66292 | 2120593.26501 | 37.8030469569032 | -122.42568566546 | (37.8030469569032, -122.42568566546) | 13 | 9 | 1 | 28858 | 17 | |
93259 | 253749 | Planning Code 138.1 required 2 | Washingtonia robusta :: Mexican Fan Palm 72 | 2x Rhode Island St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/03/2017 12:00:00 AM | 3 | 3x6 | 6011517 | 2108140 | 37.7691996810398 | -122.403473604048 | (37.7691996810398, -122.403473604048) | 8 | 2 | 8 | 28853 | 20 | ||
163114 | 253748 | Planning Code 138.1 required 2 | Washingtonia robusta :: Mexican Fan Palm 72 | 2x Rhode Island St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/03/2017 12:00:00 AM | 3 | 3x6 | 6011517 | 2108140 | 37.7691996810398 | -122.403473604048 | (37.7691996810398, -122.403473604048) | 8 | 2 | 8 | 28853 | 20 | ||
162225 | 65881 | DPW Maintained 1 | Washingtonia robusta :: Mexican Fan Palm 72 | 122 Palm Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/28/2010 12:00:00 AM | 19 | 3x3 | Permit Number 53867 | 5995930.99366 | 2113550.02665 | 37.783171302573 | -122.457775944343 | (37.783171302573, -122.457775944343) | 11 | 6 | 1 | 54 | 31 |
144474 | 32558 | Permitted Site 7 | Washingtonia robusta :: Mexican Fan Palm 72 | 727 Florida St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/22/1996 12:00:00 AM | Permit Number 37045 | 6009321.36769465 | 2104857.59081295 | 37.7600640559522 | -122.410836353614 | (37.7600640559522, -122.410836353614) | 2 | 4 | 7 | 28859 | 19 | |||
175381 | 32559 | Permitted Site 7 | Washingtonia robusta :: Mexican Fan Palm 72 | 727 Florida St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/22/1996 12:00:00 AM | Permit Number 37045 | 6009321.36769465 | 2104857.59081295 | 37.7600640559522 | -122.410836353614 | (37.7600640559522, -122.410836353614) | 2 | 4 | 7 | 28859 | 19 | |||
190149 | 32560 | Permitted Site 7 | Washingtonia robusta :: Mexican Fan Palm 72 | 727 Florida St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/22/1996 12:00:00 AM | Permit Number 37045 | 6009321.36769465 | 2104857.59081295 | 37.7600640559522 | -122.410836353614 | (37.7600640559522, -122.410836353614) | 2 | 4 | 7 | 28859 | 19 | |||
58986 | 25049 | DPW Maintained 1 | Washingtonia robusta :: Mexican Fan Palm 72 | 900X Dolores St | 4 | Median : Cutout | Tree | DPW 1 | 10/20/1999 12:00:00 AM | 30 | 20 | 6005065.41733 | 2102966.79857 | 37.7546328277698 | -122.425421098419 | (37.7546328277698, -122.425421098419) | 2 | 4 | 5 | 28862 | 22 | ||
28993 | 15472 | DPW Maintained 1 | Washingtonia robusta :: Mexican Fan Palm 72 | 2480 Mission St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 10/20/1993 12:00:00 AM | 18 | 4X4 | 6006923.7988 | 2103940.4395 | 37.7574110439022 | -122.419063359319 | (37.7574110439022, -122.419063359319) | 2 | 4 | 7 | 28859 | 19 | ||
190208 | 15476 | DPW Maintained 1 | Washingtonia robusta :: Mexican Fan Palm 72 | 2540 Mission St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 10/20/1993 12:00:00 AM | 18 | 4X4 | 6006952.2887 | 2103573.3458 | 37.7564046935445 | -122.418938794072 | (37.7564046935445, -122.418938794072) | 2 | 4 | 7 | 28859 | 19 | ||
167362 | 94635 | Permitted Site 7 | Washingtonia robusta :: Mexican Fan Palm 72 | 3973 19th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/18/2010 12:00:00 AM | 3x3 | Permit Number 53782 | 6003202.2 | 2104721 | 37.7593439998528 | -122.431989854822 | (37.7593439998528, -122.431989854822) | 2 | 4 | 5 | 28862 | 3 | ||
148508 | 49637 | Permitted Site 7 | Washingtonia robusta :: Mexican Fan Palm 72 | 63 Lafayette St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/13/2004 12:00:00 AM | 12 | 3x3 | Permit Number 47722 | 6007662.62246956 | 2109567.06845572 | 37.7729020327715 | -122.416906845471 | (37.7729020327715, -122.416906845471) | 8 | 2 | 9 | 28853 | 19 | |
172235 | 51395 | Permitted Site 7 | Washingtonia robusta :: Mexican Fan Palm 72 | 1050X Natoma St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/13/2004 12:00:00 AM | 12 | 3x3 | Permit Number 47722 | 6007651 | 2109542 | 37.7728325469688 | -122.416945272606 | (37.7728325469688, -122.416945272606) | 8 | 2 | 9 | 28853 | 19 |
175248 | 51396 | Permitted Site 7 | Washingtonia robusta :: Mexican Fan Palm 72 | 63 Lafayette St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/13/2004 12:00:00 AM | 12 | 3x3 | Permit Number 47722 | 6007662.62246956 | 2109567.06845572 | 37.7729020327715 | -122.416906845471 | (37.7729020327715, -122.416906845471) | 8 | 2 | 9 | 28853 | 19 | |
168177 | 181059 | Undocumented 4 | Washingtonia robusta :: Mexican Fan Palm 72 | 5810 Mission St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/10/2017 03:37:00 PM | 3 | Width 3ft | 5997243.54219 | 2086644.28205 | 37.7093700633606 | -122.451293980329 | (37.7093700633606, -122.451293980329) | 9 | 7 | 6 | 28861 | 25 | ||
20483 | 15453 | DPW Maintained 1 | Washingtonia robusta :: Mexican Fan Palm 72 | 2365 Mission St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 10/10/1992 12:00:00 AM | 12 | 4X4 | 6006954.2705 | 2104542.6911 | 37.7590664034557 | -122.419000691119 | (37.7590664034557, -122.419000691119) | 2 | 4 | 7 | 28859 | 19 | ||
28701 | 15444 | DPW Maintained 1 | Washingtonia robusta :: Mexican Fan Palm 72 | 2243 Mission St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 10/10/1992 12:00:00 AM | 12 | 4X4 | 6006909.5324 | 2105286.5572 | 37.7611063676926 | -122.419208183326 | (37.7611063676926, -122.419208183326) | 2 | 4 | 7 | 28859 | 19 | ||
31737 | 15450 | DPW Maintained 1 | Washingtonia robusta :: Mexican Fan Palm 72 | 2301 Mission St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 10/10/1992 12:00:00 AM | 12 | 4x4 | 6006934.5554 | 2104894.5299 | 37.760031361018 | -122.41909383171 | (37.760031361018, -122.41909383171) | 2 | 4 | 7 | 28859 | 19 | ||
47822 | 15454 | DPW Maintained 1 | Washingtonia robusta :: Mexican Fan Palm 72 | 2366 Mission St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 10/10/1992 12:00:00 AM | 18 | 4X4 | 6006889.3715 | 2104582.8537 | 37.7591730259049 | -122.419227992101 | (37.7591730259049, -122.419227992101) | 2 | 4 | 7 | 28859 | 19 | ||
71293 | 15470 | DPW Maintained 1 | Washingtonia robusta :: Mexican Fan Palm 72 | 2467 Mission St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/10/1992 12:00:00 AM | 12 | 4X4 | 6006982.3266 | 2104010.3832 | 37.7576063888546 | -122.418865906959 | (37.7576063888546, -122.418865906959) | 2 | 4 | 7 | 28859 | 19 | ||
96526 | 15488 | DPW Maintained 1 | Washingtonia robusta :: Mexican Fan Palm 72 | 2659 Mission St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 10/10/1992 12:00:00 AM | 12 | 4X4 | 6007044.505 | 2102886.6221 | 37.7545243001758 | -122.418571182074 | (37.7545243001758, -122.418571182074) | 2 | 4 | 7 | 28859 | 19 | ||
109115 | 15449 | DPW Maintained 1 | Washingtonia robusta :: Mexican Fan Palm 72 | 2290 Mission St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 10/10/1992 12:00:00 AM | 18 | 4X4 | 6006865.6984 | 2105042.6887 | 37.7604342928211 | -122.419342486025 | (37.7604342928211, -122.419342486025) | 2 | 4 | 7 | 28859 | 19 | ||
114833 | 15451 | DPW Maintained 1 | Washingtonia robusta :: Mexican Fan Palm 72 | 2337 Mission St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 10/10/1992 12:00:00 AM | 12 | 4x4 | 6006940.6216 | 2104730.7429 | 37.7595819815227 | -122.419061234067 | (37.7595819815227, -122.419061234067) | 2 | 4 | 7 | 28859 | 19 | ||
126301 | 15440 | DPW Maintained 1 | Washingtonia robusta :: Mexican Fan Palm 72 | 2224 Mission St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 10/10/1992 12:00:00 AM | 18 | 4X4 | 6006834.95821 | 2105372.78301 | 37.7613389236012 | -122.419472221327 | (37.7613389236012, -122.419472221327) | 2 | 4 | 7 | 28859 | 19 | ||
128601 | 15438 | DPW Maintained 1 | Washingtonia robusta :: Mexican Fan Palm 72 | 2160 Mission St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 10/10/1992 12:00:00 AM | 18 | 4X4 | 6006822.465 | 2105789.9059 | 37.7624835420667 | -122.419545024984 | (37.7624835420667, -122.419545024984) | 8 | 4 | 7 | 28859 | 19 | ||
135554 | 15473 | DPW Maintained 1 | Washingtonia robusta :: Mexican Fan Palm 72 | 2501 Mission St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 10/10/1992 12:00:00 AM | 18 | 4X4 | 6007001.2834 | 2103755.6033 | 37.7569078893914 | -122.418782277991 | (37.7569078893914, -122.418782277991) | 2 | 4 | 7 | 28859 | 19 | ||
152183 | 15474 | DPW Maintained 1 | Washingtonia robusta :: Mexican Fan Palm 72 | 2515 Mission St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 10/10/1992 12:00:00 AM | 12 | 4X4 | 6007000.5252 | 2103706.3156 | 37.756772514034 | -122.418781404781 | (37.756772514034, -122.418781404781) | 2 | 4 | 7 | 28859 | 19 | ||
180976 | 15439 | DPW Maintained 1 | Washingtonia robusta :: Mexican Fan Palm 72 | 2162 Mission St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/10/1992 12:00:00 AM | 18 | 4X4 | 6006823.9061 | 2105762.5248 | 37.7624084411332 | -122.419538098029 | (37.7624084411332, -122.419538098029) | 8 | 4 | 7 | 28859 | 19 | ||
189262 | 15437 | DPW Maintained 1 | Washingtonia robusta :: Mexican Fan Palm 72 | 2148 Mission St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/10/1992 12:00:00 AM | 18 | 4X4 | 6006821.0239 | 2105826.6543 | 37.7625843634163 | -122.419552616574 | (37.7625843634163, -122.419552616574) | 8 | 4 | 7 | 28859 | 19 | ||
112881 | 38696 | DPW Maintained 1 | Washingtonia robusta :: Mexican Fan Palm 72 | 442 Lyon St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/07/1998 12:00:00 AM | 8 | Permit Number 40608 | 6000200.5427 | 2110464.1107 | 37.7749425203696 | -122.442783410713 | (37.7749425203696, -122.442783410713) | 15 | 5 | 11 | 29492 | 16 | |
16354 | 62210 | DPW Maintained 1 | Washingtonia robusta :: Mexican Fan Palm 72 | 280 Santa Rosa Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/30/1985 12:00:00 AM | 18 | Permit Number 22332 | 6000793.82196 | 2093620.44436 | 37.7287276772231 | -122.439523423176 | (37.7287276772231, -122.439523423176) | 9 | 7 | 6 | 28861 | 25 | |
161694 | 15428 | Permitted Site 7 | Washingtonia robusta :: Mexican Fan Palm 72 | 2109 Mission St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/27/1994 12:00:00 AM | 18 | 3X3 | 6006867.61446 | 2106023.64726 | 37.7631278842618 | -122.419405452183 | (37.7631278842618, -122.419405452183) | 8 | 4 | 7 | 28859 | 19 | ||
121006 | 47457 | Permitted Site 7 | Washingtonia robusta :: Mexican Fan Palm 72 | 1307 Baker St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/26/2006 12:00:00 AM | Permit Number 49033 | 6000227.71556431 | 2113384.63358291 | 37.782963078767 | -122.442899183951 | (37.782963078767, -122.442899183951) | 15 | 5 | 1 | 29490 | 31 | ||
126261 | 47458 | Permitted Site 7 | Washingtonia robusta :: Mexican Fan Palm 72 | 1307 Baker St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/26/2006 12:00:00 AM | Permit Number 49033 | 6000227.71556431 | 2113384.63358291 | 37.782963078767 | -122.442899183951 | (37.782963078767, -122.442899183951) | 15 | 5 | 1 | 29490 | 31 | ||
14425 | 582 | DPW Maintained 1 | Washingtonia robusta :: Mexican Fan Palm 72 | 3013 24th St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 09/23/1992 12:00:00 AM | 12 | 3x3 | Permit Number 782763 | 6008818.92095 | 2102127.6459 | 37.7525400594852 | -122.412381119401 | (37.7525400594852, -122.412381119401) | 2 | 4 | 7 | 28859 | 19 | |
77384 | 619 | DPW Maintained 1 | Washingtonia robusta :: Mexican Fan Palm 72 | 3146 24th St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 09/23/1992 12:00:00 AM | 18 | 3x3 | 6008066.00463 | 2102184.11452 | 37.7526528294897 | -122.414988836945 | (37.7526528294897, -122.414988836945) | 2 | 4 | 7 | 28859 | 19 | ||
134298 | 474 | DPW Maintained 1 | Washingtonia robusta :: Mexican Fan Palm 72 | 2790 Harrison St | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 09/23/1992 12:00:00 AM | 12 | 3x3 | 6008872.67231 | 2102220.87691 | 37.7527990671184 | -122.412201825987 | (37.7527990671184, -122.412201825987) | 2 | 4 | 7 | 28859 | 19 | ||
123319 | 23052 | DPW Maintained 1 | Washingtonia robusta :: Mexican Fan Palm 72 | 1065 Valencia St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 09/16/1992 12:00:00 AM | 15 | 4X4 | 6006449.25295 | 2103416.3322 | 37.7559452321174 | -122.420667325317 | (37.7559452321174, -122.420667325317) | 2 | 4 | 7 | 28859 | 19 | ||
142763 | 23054 | DPW Maintained 1 | Washingtonia robusta :: Mexican Fan Palm 72 | 1081 Valencia St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 09/16/1992 12:00:00 AM | 12 | 4X4 | 6006403.94858 | 2103302.7071 | 37.7556306904017 | -122.420815936586 | (37.7556306904017, -122.420815936586) | 2 | 4 | 7 | 28859 | 19 | ||
102992 | 48685 | DPW Maintained 1 | Washingtonia robusta :: Mexican Fan Palm 72 | 100 Palm Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/12/2002 12:00:00 AM | 22 | Permit Number 45967 | 5995923.78548 | 2113769.63655 | 37.7837738786202 | -122.45781677815 | (37.7837738786202, -122.45781677815) | 11 | 6 | 1 | 54 | 31 | ||
129599 | 667 | DPW Maintained 1 | Washingtonia robusta :: Mexican Fan Palm 72 | 3297X 24th St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 09/10/1992 12:00:00 AM | 18 | 4x4 | 6007079.62061 | 2102029.84762 | 37.7521737701718 | -122.418388996947 | (37.7521737701718, -122.418388996947) | 2 | 4 | 7 | 28859 | 19 | ||
142706 | 666 | DPW Maintained 1 | Washingtonia robusta :: Mexican Fan Palm 72 | 3297X 24th St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 09/10/1992 12:00:00 AM | 18 | 4x4 | 6007079.62061 | 2102029.84762 | 37.7521737701718 | -122.418388996947 | (37.7521737701718, -122.418388996947) | 2 | 4 | 7 | 28859 | 19 | ||
120182 | 15543 | DPW Maintained 1 | Washingtonia robusta :: Mexican Fan Palm 72 | 2830 Mission St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/08/1994 12:00:00 AM | 18 | 3X3 | 6007038.8586 | 2101864.2983 | 37.7517169147733 | -122.418518220595 | (37.7517169147733, -122.418518220595) | 2 | 4 | 7 | 28859 | 19 | ||
188146 | 96035 | Permitted Site 7 | Washingtonia robusta :: Mexican Fan Palm 72 | 2032 Polk St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/02/2011 12:00:00 AM | 3x3 | Permit Number 767674 | 6006483 | 2117763 | 37.7953396281575 | -122.421569509833 | (37.7953396281575, -122.421569509833) | 13 | 9 | 10 | 28858 | 32 | |
18914 | 48631 | Permitted Site 7 | Washingtonia robusta :: Mexican Fan Palm 72 | 1501 15th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/30/2002 12:00:00 AM | Permit Number 45927 | 5991498.56479756 | 2105191.60606182 | 37.7599657064663 | -122.472500646803 | (37.7599657064663, -122.472500646803) | 1 | 8 | 4 | 56 | 12 | ||
88013 | 48632 | Permitted Site 7 | Washingtonia robusta :: Mexican Fan Palm 72 | 1501 15th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/30/2002 12:00:00 AM | Permit Number 45927 | 5991498.56479756 | 2105191.60606182 | 37.7599657064663 | -122.472500646803 | (37.7599657064663, -122.472500646803) | 1 | 8 | 4 | 56 | 12 | ||
182425 | 48630 | Permitted Site 7 | Washingtonia robusta :: Mexican Fan Palm 72 | 1501 15th Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/30/2002 12:00:00 AM | Permit Number 45927 | 5991498.56479756 | 2105191.60606182 | 37.7599657064663 | -122.472500646803 | (37.7599657064663, -122.472500646803) | 1 | 8 | 4 | 56 | 12 | ||
41672 | 56949 | DPW Maintained 1 | Washingtonia robusta :: Mexican Fan Palm 72 | 87 06th St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 08/27/1974 12:00:00 AM | 16 | Permit Number 14201 | 6010069.06775 | 2112529.00786 | 37.7811698923233 | -122.408791633752 | (37.7811698923233, -122.408791633752) | 14 | 2 | 9 | 28853 | 34 | ||
105792 | 26854 | DPW Maintained 1 | Washingtonia robusta :: Mexican Fan Palm 72 | 1850 Mission St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/25/2004 12:00:00 AM | 3 | 3X3 | 6006727.5247 | 2107586.953 | 37.7674124629958 | -122.420000921762 | (37.7674124629958, -122.420000921762) | 8 | 4 | 7 | 28853 | 19 | ||
108631 | 24604 | DPW Maintained 1 | Washingtonia robusta :: Mexican Fan Palm 72 | 1850 Mission St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/25/2004 12:00:00 AM | 6 | 3X3 | 6006726.6671 | 2107610.9661 | 37.7674783489788 | -122.420005592363 | (37.7674783489788, -122.420005592363) | 8 | 4 | 7 | 28853 | 19 | ||
189704 | 26855 | Permitted Site 7 | Washingtonia robusta :: Mexican Fan Palm 72 | 1850 Mission St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/25/2004 12:00:00 AM | 3 | 3X3 | 6006730.05548 | 2107572.97238 | 37.7673742180997 | -122.41999117589 | (37.7673742180997, -122.41999117589) | 8 | 4 | 7 | 28853 | 19 | ||
115630 | 67454 | DPW Maintained 1 | Washingtonia robusta :: Mexican Fan Palm 72 | 18 Rossi Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/18/1992 12:00:00 AM | 24 | Permit Number 30963 | 5996314.72517 | 2112137.62024 | 37.7793152462196 | -122.456346235157 | (37.7793152462196, -122.456346235157) | 11 | 6 | 2 | 54 | 16 | ||
57411 | 15349 | DPW Maintained 1 | Washingtonia robusta :: Mexican Fan Palm 72 | 1906 Mission St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/16/1993 12:00:00 AM | 12 | 4X4 | 6006754.9683 | 2107231.9019 | 37.7664391225711 | -122.419880800641 | (37.7664391225711, -122.419880800641) | 8 | 4 | 7 | 28853 | 19 | ||
57553 | 15489 | DPW Maintained 1 | Washingtonia robusta :: Mexican Fan Palm 72 | 2663 Mission St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 08/13/1992 12:00:00 AM | 12 | 4X4 | 6007048.2964 | 2102838.0926 | 37.7543912627392 | -122.418554629318 | (37.7543912627392, -122.418554629318) | 2 | 4 | 7 | 28859 | 19 | ||
190378 | 15487 | DPW Maintained 1 | Washingtonia robusta :: Mexican Fan Palm 72 | 2637 Mission St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 08/13/1992 12:00:00 AM | 12 | 4X4 | 6007039.9554 | 2102983.6811 | 37.7547905457997 | -122.4185937981 | (37.7547905457997, -122.4185937981) | 2 | 4 | 7 | 28859 | 19 | ||
17227 | 43930 | Permitted Site 7 | Washingtonia robusta :: Mexican Fan Palm 72 | 2937 24th St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/10/2000 12:00:00 AM | Permit Number 43521 | 6009283.57166105 | 2102148.92556307 | 37.7526245524661 | -122.410775774269 | (37.7526245524661, -122.410775774269) | 2 | 4 | 7 | 28859 | 19 | ||
41098 | 43932 | Permitted Site 7 | Washingtonia robusta :: Mexican Fan Palm 72 | 2937 24th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/10/2000 12:00:00 AM | Permit Number 43521 | 6009283.57166105 | 2102148.92556307 | 37.7526245524661 | -122.410775774269 | (37.7526245524661, -122.410775774269) | 2 | 4 | 7 | 28859 | 19 | ||
41268 | 43933 | Permitted Site 7 | Washingtonia robusta :: Mexican Fan Palm 72 | 2937 24th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/10/2000 12:00:00 AM | Permit Number 43521 | 6009283.57166105 | 2102148.92556307 | 37.7526245524661 | -122.410775774269 | (37.7526245524661, -122.410775774269) | 2 | 4 | 7 | 28859 | 19 | ||
143781 | 43931 | Permitted Site 7 | Washingtonia robusta :: Mexican Fan Palm 72 | 2937 24th St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/10/2000 12:00:00 AM | Permit Number 43521 | 6009283.57166105 | 2102148.92556307 | 37.7526245524661 | -122.410775774269 | (37.7526245524661, -122.410775774269) | 2 | 4 | 7 | 28859 | 19 | ||
57241 | 253248 | Planning Code 138.1 required 2 | Washingtonia robusta :: Mexican Fan Palm 72 | 570 Jessie St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/09/2017 12:00:00 AM | 3 | 3x3 | Permit Number 775513 | 6009730.1467 | 2112442.13768 | 37.7809123781536 | -122.409958002933 | (37.7809123781536, -122.409958002933) | 14 | 2 | 9 | 28853 | 34 | |
79696 | 253247 | Planning Code 138.1 required 2 | Washingtonia robusta :: Mexican Fan Palm 72 | 570 Jessie St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/09/2017 12:00:00 AM | 3 | 3x3 | Permit Number 775513 | 6009730.1467 | 2112442.13768 | 37.7809123781536 | -122.409958002933 | (37.7809123781536, -122.409958002933) | 14 | 2 | 9 | 28853 | 34 | |
187618 | 253249 | Planning Code 138.1 required 2 | Washingtonia robusta :: Mexican Fan Palm 72 | 570 Jessie St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/09/2017 12:00:00 AM | 3 | 3x3 | Permit Number 775513 | 6009730.1467 | 2112442.13768 | 37.7809123781536 | -122.409958002933 | (37.7809123781536, -122.409958002933) | 14 | 2 | 9 | 28853 | 34 | |
57795 | 68285 | DPW Maintained 1 | Washingtonia robusta :: Mexican Fan Palm 72 | 1894 48th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/09/1993 12:00:00 AM | 9 | Permit Number 32094 | 5981358.7272 | 2102199.6882 | 37.7511586335316 | -122.50734684264 | (37.7511586335316, -122.50734684264) | 1 | 8 | 3 | 56 | 35 | |
25845 | 28547 | DPW Maintained 1 | Washingtonia robusta :: Mexican Fan Palm 72 | 5109 Mission St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/08/2003 12:00:00 AM | 12 | 3x3 | 6000411.4099 | 2089335.4212 | 37.7169402093066 | -122.440538230978 | (37.7169402093066, -122.440538230978) | 9 | 7 | 6 | 28861 | 5 | ||
30573 | 28546 | DPW Maintained 1 | Washingtonia robusta :: Mexican Fan Palm 72 | 5125 Mission St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/08/2003 12:00:00 AM | 12 | 3x3 | 6000380.5163 | 2089281.6434 | 37.7167907883598 | -122.440641159733 | (37.7167907883598, -122.440641159733) | 9 | 7 | 6 | 28861 | 5 | ||
34666 | 28556 | DPW Maintained 1 | Washingtonia robusta :: Mexican Fan Palm 72 | 4717 Mission St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/08/2003 12:00:00 AM | 12 | 3X3 | 6001738.1279 | 2091443.2433 | 37.7228032751332 | -122.436103167424 | (37.7228032751332, -122.436103167424) | 9 | 7 | 6 | 28861 | 5 | ||
36085 | 28542 | DPW Maintained 1 | Washingtonia robusta :: Mexican Fan Palm 72 | 5036 Mission St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 08/08/2003 12:00:00 AM | 12 | 3X3 | 6000555.9648 | 2089678.6918 | 37.7178909833984 | -122.440063176664 | (37.7178909833984, -122.440063176664) | 9 | 7 | 6 | 28861 | 25 | ||
38025 | 28557 | Permitted Site 7 | Washingtonia robusta :: Mexican Fan Palm 72 | 4681 Mission St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/08/2003 12:00:00 AM | 12 | 3X3 | 6001872.38004 | 2091652.00525 | 37.7233841148131 | -122.43565401519 | (37.7233841148131, -122.43565401519) | 9 | 7 | 6 | 28861 | 5 | ||
39130 | 28550 | DPW Maintained 1 | Washingtonia robusta :: Mexican Fan Palm 72 | 4919 Mission St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/08/2003 12:00:00 AM | 12 | 3X3 | 6001014.7517 | 2090296.9851 | 37.7196147854688 | -122.438521631633 | (37.7196147854688, -122.438521631633) | 9 | 7 | 6 | 28861 | 5 | ||
40185 | 15823 | DPW Maintained 1 | Washingtonia robusta :: Mexican Fan Palm 72 | 5051 Mission St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 08/08/2003 12:00:00 AM | 12 | 3x3 | 6000607.6416 | 2089644.9294 | 37.717801221251 | -122.439882133799 | (37.717801221251, -122.439882133799) | 9 | 7 | 6 | 28861 | 5 | ||
45669 | 28545 | DPW Maintained 1 | Washingtonia robusta :: Mexican Fan Palm 72 | 5098 Mission St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/08/2003 12:00:00 AM | 12 | 3X3 | 6000324.7175 | 2089317.75892 | 37.7168867757364 | -122.440836617463 | (37.7168867757364, -122.440836617463) | 9 | 7 | 6 | 28861 | 25 | ||
45996 | 28555 | DPW Maintained 1 | Washingtonia robusta :: Mexican Fan Palm 72 | 4743 Mission St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/08/2003 12:00:00 AM | 12 | 3X3 | 6001652.2787 | 2091307.3716 | 37.722425324335 | -122.436390209739 | (37.722425324335, -122.436390209739) | 9 | 7 | 6 | 28861 | 5 | ||
51313 | 28559 | Permitted Site 7 | Washingtonia robusta :: Mexican Fan Palm 72 | 4647 Mission St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/08/2003 12:00:00 AM | 12 | 3X3 | 6002004.69492 | 2091867.26763 | 37.7239826914316 | -122.435212017462 | (37.7239826914316, -122.435212017462) | 9 | 7 | 6 | 28861 | 5 | ||
54790 | 28558 | DPW Maintained 1 | Washingtonia robusta :: Mexican Fan Palm 72 | 4675 Mission St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/08/2003 12:00:00 AM | 12 | 3X3 | 6001911 | 2091675 | 37.7234494467538 | -122.435522157567 | (37.7234494467538, -122.435522157567) | 9 | 7 | 6 | 28861 | 5 | ||
55765 | 28543 | DPW Maintained 1 | Washingtonia robusta :: Mexican Fan Palm 72 | 5050 Mission St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/08/2003 12:00:00 AM | 14 | 3X3 | 6000463.3087 | 2089534.8309 | 37.7174906985411 | -122.440373135506 | (37.7174906985411, -122.440373135506) | 9 | 7 | 6 | 28861 | 25 |
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) );