trees
3,709 rows where qSpecies_id = 9 sorted by XCoord
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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 100072 | 117859 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 720 40th Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 5983546.44391 | 2110976.69858 | 37.7753864363978 | -122.500430481904 | (37.7753864363978, -122.500430481904) | 11 | 6 | 2 | 55 | 26 | |||
| 18616 | 184963 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 1990 41st Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 0ft | 5983546.455 | 2101707.1153 | 37.7499347861229 | -122.499745164476 | (37.7499347861229, -122.499745164476) | 1 | 8 | 3 | 29491 | 35 | |||
| 134033 | 43049 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 2163 41st Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/07/2000 12:00:00 AM | 4 | Permit Number 42903 | 5983547.8087 | 2100426.6964 | 37.7464191887457 | -122.499645862071 | (37.7464191887457, -122.499645862071) | 1 | 8 | 3 | 29491 | 35 | |
| 4541 | 184962 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 1990 41st Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 0ft | 5983548.4855 | 2101665.8278 | 37.7498215412297 | -122.499735091789 | (37.7498215412297, -122.499735091789) | 1 | 8 | 3 | 29491 | 35 | |||
| 132533 | 117862 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 720 40th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 5983549.37173 | 2110860.65919 | 37.7750679976771 | -122.500411772666 | (37.7750679976771, -122.500411772666) | 11 | 6 | 2 | 55 | 26 | |||
| 7416 | 52562 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 1267 40th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/12/2006 12:00:00 AM | 3 | Permit Number 48659 | 5983648.1273 | 2106539.2749 | 37.7632085093228 | -122.49975069135 | (37.7632085093228, -122.49975069135) | 1 | 8 | 3 | 56 | 35 | |
| 155293 | 183284 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 1267 40th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 0ft | 5983648.6729 | 2106520.7252 | 37.7631576091152 | -122.499747433217 | (37.7631576091152, -122.499747433217) | 1 | 8 | 3 | 56 | 35 | |||
| 48402 | 185050 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 2735 41st Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 0ft | 5983672.8883 | 2096524.5821 | 37.7357123843546 | -122.498925114194 | (37.7357123843546, -122.498925114194) | 1 | 8 | 3 | 29491 | 35 | |||
| 119405 | 52561 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 1234 40th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/12/2006 12:00:00 AM | 7 | Permit Number 48657 | 5983685.9087 | 2106728.1821 | 37.7637294119346 | -122.499633982543 | (37.7637294119346, -122.499633982543) | 1 | 8 | 3 | 56 | 35 | |
| 84998 | 183312 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 1278 40th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 0ft | 5983694.638 | 2106469.3043 | 37.7630191190041 | -122.499584657362 | (37.7630191190041, -122.499584657362) | 1 | 8 | 3 | 56 | 35 | |||
| 49353 | 183311 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 1278 40th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 0ft | 5983695.1836 | 2106447.4811 | 37.7629592306856 | -122.499581157409 | (37.7629592306856, -122.499581157409) | 1 | 8 | 3 | 56 | 35 | |||
| 116839 | 99309 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 1902X 41st Ave | 23 | Sidewalk: Curb side : Cutout | Tree | DPW for City Agency 14 | SFUSD | 6 | 3X3 | 5983703.9 | 2101544.3 | 37.7494969779561 | -122.499188691375 | (37.7494969779561, -122.499188691375) | 1 | 8 | 3 | 29491 | 35 | ||
| 80493 | 117751 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 415 39th Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 9 | Width 4ft | 5983734.82883 | 2113014.83015 | 37.7809936100018 | -122.499929513006 | (37.7809936100018, -122.499929513006) | 11 | 6 | 2 | 55 | 26 | |||
| 191455 | 117750 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 415 39th Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 12 | Width 4ft | 5983735.53337 | 2113025.8643 | 37.7810239479026 | -122.499927891557 | (37.7810239479026, -122.499927891557) | 11 | 6 | 2 | 55 | 26 | |||
| 87835 | 54488 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 541 39th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/11/1972 12:00:00 AM | 7 | Permit Number 10280 | 5983765.72695 | 2112144.55084 | 37.7786058896943 | -122.499758279765 | (37.7786058896943, -122.499758279765) | 11 | 6 | 2 | 55 | 26 | ||
| 99553 | 117905 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 541 39th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 5983767.17374 | 2112125.62524 | 37.7785540103948 | -122.499751875651 | (37.7785540103948, -122.499751875651) | 11 | 6 | 2 | 55 | 26 | |||
| 132393 | 54494 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 555 39th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/11/1972 12:00:00 AM | 7 | Permit Number 10286 | 5983770.26355 | 2112042.83675 | 37.7783268785645 | -122.499735066394 | (37.7783268785645, -122.499735066394) | 11 | 6 | 2 | 55 | 26 | ||
| 143910 | 54503 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 530 39th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/12/1972 12:00:00 AM | 8 | Permit Number 10297 | 5983809.75078 | 2112179.78652 | 37.7787052198621 | -122.499608591667 | (37.7787052198621, -122.499608591667) | 11 | 6 | 2 | 55 | 26 | ||
| 66379 | 117843 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 620x 39th Ave | 4 | Median : Cutout | Tree | DPW 1 | 9 | Width 6ft | 5983810.12526 | 2111540.49138 | 37.7769499228703 | -122.499560036853 | (37.7769499228703, -122.499560036853) | 11 | 6 | 2 | 55 | 26 | |||
| 85332 | 117845 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 620x 39th Ave | 2 | Median : Cutout | Tree | DPW 1 | 23 | Width 6ft | 5983812.70856 | 2111515.33399 | 37.7768809995382 | -122.499549240882 | (37.7768809995382, -122.499549240882) | 11 | 6 | 2 | 55 | 26 | |||
| 20698 | 54489 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 542 39th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/11/1972 12:00:00 AM | 6 | Permit Number 10281 | 5983813.3329 | 2112120.03018 | 37.7785413564974 | -122.49959178241 | (37.7785413564974, -122.49959178241) | 11 | 6 | 2 | 55 | 26 | ||
| 150788 | 54492 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 550 39th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/11/1972 12:00:00 AM | 8 | Permit Number 10284 | 5983814.5335 | 2112067.92848 | 37.7783983708083 | -122.49958377753 | (37.7783983708083, -122.49958377753) | 11 | 6 | 2 | 55 | 26 | ||
| 134006 | 117847 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 640x 39th Ave | 4 | Median : Cutout | Tree | DPW 1 | 12 | Width 6ft | 5983816.43037 | 2111419.86537 | 37.7766190887274 | -122.499529309057 | (37.7766190887274, -122.499529309057) | 11 | 6 | 2 | 55 | 26 | |||
| 102289 | 117836 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 660x 39th Ave | 3 | Median : Cutout | Tree | DPW 1 | 11 | Width 6ft | 5983819.78589 | 2111279.0355 | 37.7762326075425 | -122.499507291354 | (37.7762326075425, -122.499507291354) | 11 | 6 | 2 | 55 | 26 | |||
| 164436 | 117838 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 660x 39th Ave | 1 | Median : Cutout | Tree | DPW 1 | 8 | Width 6ft | 5983820.62988 | 2111252.49481 | 37.7761597840052 | -122.499502409931 | (37.7761597840052, -122.499502409931) | 11 | 6 | 2 | 55 | 26 | |||
| 128524 | 813 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 600X 39th Ave | 11 | Median : Cutout | Tree | DPW 1 | 3 | 6-HOA | 5983831.1679936 | 2111715.0127262 | 37.7774303425616 | -122.499500145383 | (37.7774303425616, -122.499500145383) | 11 | 6 | 2 | 55 | 26 | |||
| 135319 | 810 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 600X 39th Ave | 8 | Median : Cutout | Tree | DPW 1 | 6 | 6-HOA | 5983831.1679936 | 2111715.0127262 | 37.7774303425616 | -122.499500145383 | (37.7774303425616, -122.499500145383) | 11 | 6 | 2 | 55 | 26 | |||
| 147471 | 812 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 600X 39th Ave | 10 | Median : Cutout | Tree | DPW 1 | 6 | 6-HOA | 5983831.1679936 | 2111715.0127262 | 37.7774303425616 | -122.499500145383 | (37.7774303425616, -122.499500145383) | 11 | 6 | 2 | 55 | 26 | |||
| 192460 | 809 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 600X 39th Ave | 7 | Median : Cutout | Tree | DPW 1 | 6 | 6-HOA | 5983831.1679936 | 2111715.0127262 | 37.7774303425616 | -122.499500145383 | (37.7774303425616, -122.499500145383) | 11 | 6 | 2 | 55 | 26 | |||
| 11455 | 71633 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 666 39th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 5 | 5983841.90754 | 2111286.39703 | 37.7762541180901 | -122.499431311865 | (37.7762541180901, -122.499431311865) | 11 | 6 | 2 | 55 | 26 | |||
| 90378 | 53480 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 1206 39th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/10/1969 12:00:00 AM | 2 | Permit Number 6389 | 5983992.7975 | 2106909.1782 | 37.7642443784807 | -122.49858593622 | (37.7642443784807, -122.49858593622) | 1 | 8 | 3 | 56 | 35 | ||
| 157268 | 50403 | Permitted Site 7 | Olea europaea :: Olive Tree 9 | 1546 39th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/12/2006 12:00:00 AM | Permit Number 48650 | 5984072.75898707 | 2104637.91247465 | 37.7580128106665 | -122.49814162679 | (37.7580128106665, -122.49814162679) | 1 | 8 | 3 | 56 | 35 | ||
| 39938 | 83992 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 1682 39th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/30/2008 12:00:00 AM | 2 | 3x3 | Permit Number 51096 | 5984098.9069 | 2103728.8955 | 37.7555184368042 | -122.497984070914 | (37.7555184368042, -122.497984070914) | 1 | 8 | 3 | 56 | 35 | |
| 117484 | 52069 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 1766 39th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/03/2005 12:00:00 AM | 2 | Permit Number 48264 | 5984118.7262 | 2103148.2845 | 37.7539254023633 | -122.497872659115 | (37.7539254023633, -122.497872659115) | 1 | 8 | 3 | 56 | 35 | ||
| 52647 | 118235 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 670 38th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 5984152.37424 | 2111283.69905 | 37.7762649206021 | -122.498357139682 | (37.7762649206021, -122.498357139682) | 11 | 6 | 2 | 55 | 26 | |||
| 180709 | 183714 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 1215 38th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 0ft | 5984258.0858 | 2106883.6724 | 37.7641899012706 | -122.497666510275 | (37.7641899012706, -122.497666510275) | 1 | 8 | 3 | 56 | 35 | |||
| 164107 | 183706 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 1390 38th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 0ft | 5984341.3234 | 2105731.2824 | 37.7610306415519 | -122.497293543423 | (37.7610306415519, -122.497293543423) | 1 | 8 | 3 | 56 | 35 | |||
| 1220 | 75333 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 550 37th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 4 | 5984432.92075 | 2112122.55763 | 37.7785846311766 | -122.497448611437 | (37.7785846311766, -122.497448611437) | 11 | 6 | 2 | 55 | 26 | |||
| 9131 | 75410 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 550 37th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 4 | 5984433.26554 | 2112138.70931 | 37.7786289992279 | -122.497448611431 | (37.7786289992279, -122.497448611431) | 11 | 6 | 2 | 55 | 26 | |||
| 11782 | 75252 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 550 37th Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 6 | 5984435.27406 | 2112051.02131 | 37.7783883510577 | -122.497435187925 | (37.7783883510577, -122.497435187925) | 11 | 6 | 2 | 55 | 26 | |||
| 13889 | 75170 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 550 37th Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 5 | 5984437.14625 | 2112031.30929 | 37.7783343372815 | -122.497427255785 | (37.7783343372815, -122.497427255785) | 11 | 6 | 2 | 55 | 26 | |||
| 193337 | 184540 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 3131 Moraga St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 0ft | 5984528.9702 | 2103585.9441 | 37.7551511364506 | -122.496486253509 | (37.7551511364506, -122.496486253509) | 1 | 8 | 3 | 56 | 35 | |||
| 173153 | 183152 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 2358 38th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 0ft | 5984567.4093 | 2099139.1957 | 37.7429438368853 | -122.49602528472 | (37.7429438368853, -122.49602528472) | 1 | 8 | 3 | 29491 | 35 | |||
| 80058 | 183151 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 2358 38th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 0ft | 5984568.7624 | 2099123.297 | 37.7429002626214 | -122.496019433491 | (37.7429002626214, -122.496019433491) | 1 | 8 | 3 | 29491 | 35 | |||
| 154522 | 69029 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 1423 37th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/06/1994 12:00:00 AM | 8 | Permit Number 33035 | 5984615.7707 | 2105488.0931 | 37.7603789927974 | -122.496326419474 | (37.7603789927974, -122.496326419474) | 1 | 8 | 3 | 56 | 35 | |
| 160701 | 20749 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 1692X Sunset Blvd | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 60 | 5984807.4869191 | 2103677.7923597 | 37.7554196391607 | -122.495529849669 | (37.7554196391607, -122.495529849669) | 1 | 8 | 3 | 56 | 35 | |||
| 117458 | 20876 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 1892X Sunset Blvd | 26 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3 | 60 | 5984852.8466778 | 2102317.5089788 | 37.7516873322231 | -122.49527267334 | (37.7516873322231, -122.49527267334) | 1 | 8 | 3 | 56 | 35 | |||
| 133495 | 20880 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 1892X Sunset Blvd | 30 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3 | 60 | 5984852.8466778 | 2102317.5089788 | 37.7516873322231 | -122.49527267334 | (37.7516873322231, -122.49527267334) | 1 | 8 | 3 | 56 | 35 | |||
| 143165 | 20877 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 1892X Sunset Blvd | 27 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3 | 60 | 5984852.8466778 | 2102317.5089788 | 37.7516873322231 | -122.49527267334 | (37.7516873322231, -122.49527267334) | 1 | 8 | 3 | 56 | 35 | |||
| 53852 | 187200 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 2301 Sunset Blvd | 62 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | Width 0ft | 5984910.7598 | 2099021.3208 | 37.7426402887161 | -122.49482940194 | (37.7426402887161, -122.49482940194) | 1 | 8 | 3 | 29491 | 35 | |||
| 150123 | 184018 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 1600 Sunset Blvd | 18 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 0ft | 5984912.6418 | 2103753.8138 | 37.7556345299307 | -122.495171803184 | (37.7556345299307, -122.495171803184) | 1 | 8 | 3 | 56 | 35 | |||
| 23527 | 184026 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 1600 Sunset Blvd | 26 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 0ft | 5984920.3345 | 2103785.5463 | 37.7557221089671 | -122.495147539697 | (37.7557221089671, -122.495147539697) | 1 | 8 | 3 | 56 | 35 | |||
| 81122 | 184034 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 1600 Sunset Blvd | 34 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 0ft | 5984925.6803 | 2103804.9468 | 37.7557756903402 | -122.495130483038 | (37.7557756903402, -122.495130483038) | 1 | 8 | 3 | 56 | 35 | |||
| 93413 | 184031 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 1600 Sunset Blvd | 31 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 0ft | 5984927.2534 | 2103793.0767 | 37.7557431904272 | -122.495124167563 | (37.7557431904272, -122.495124167563) | 1 | 8 | 3 | 56 | 35 | |||
| 187203 | 184036 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 1600 Sunset Blvd | 36 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 0ft | 5984928.8265 | 2103810.0952 | 37.7557900106144 | -122.495119982258 | (37.7557900106144, -122.495119982258) | 1 | 8 | 3 | 56 | 35 | |||
| 95076 | 184025 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 1600 Sunset Blvd | 25 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 0ft | 5984931.5337 | 2103784.5063 | 37.7557199090675 | -122.495108733182 | (37.7557199090675, -122.495108733182) | 1 | 8 | 3 | 56 | 35 | |||
| 166297 | 184027 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 1600 Sunset Blvd | 27 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 0ft | 5984931.8298 | 2103786.2121 | 37.7557246100571 | -122.495107834969 | (37.7557246100571, -122.495107834969) | 1 | 8 | 3 | 56 | 35 | |||
| 1763 | 184039 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 1600 Sunset Blvd | 39 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 0ft | 5984935.4051 | 2103815.5297 | 37.755805317385 | -122.4950976324 | (37.755805317385, -122.4950976324) | 1 | 8 | 3 | 56 | 35 | |||
| 96240 | 184009 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 1600 Sunset Blvd | 8 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 0ft | 5984939.2377 | 2103728.7585 | 37.7555672920528 | -122.495077980088 | (37.7555672920528, -122.495077980088) | 1 | 8 | 3 | 56 | 35 | |||
| 83257 | 187242 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 2401 Sunset Blvd | 25 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 0ft | 5984947.0235 | 2098562.0875 | 37.7413814807711 | -122.494670165431 | (37.7413814807711, -122.494670165431) | 1 | 8 | 3 | 29491 | 35 | |||
| 94030 | 184010 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 1600 Sunset Blvd | 9 | Sidewalk: Property side : Yard | Tree | Private 2 | 2 | Width 0ft | 5984951.0048 | 2103730.9648 | 37.7555740388181 | -122.495037449073 | (37.7555740388181, -122.495037449073) | 1 | 8 | 3 | 56 | 35 | |||
| 153828 | 187244 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 2401 Sunset Blvd | 27 | Sidewalk: Property side : Yard | Tree | Private 2 | 2 | Width 0ft | 5984957.2356 | 2098537.5785 | 37.7413147833906 | -122.494633049632 | (37.7413147833906, -122.494633049632) | 1 | 8 | 3 | 29491 | 35 | |||
| 165843 | 182356 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 3151 Kirkham St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 7 | Width 0ft | 5985005.527 | 2104966.2042 | 37.7589688553292 | -122.494939971824 | (37.7589688553292, -122.494939971824) | 1 | 8 | 3 | 56 | 35 | |||
| 20989 | 185356 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 2601 Sunset Blvd | 81 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 0ft | 5985014.265 | 2096945.9513 | 37.7369479403483 | -122.49431857261 | (37.7369479403483, -122.49431857261) | 1 | 8 | 3 | 29491 | 35 | |||
| 28823 | 186299 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 1800 Sunset Blvd | 37 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 0ft | 5985021.1385 | 2102711.497 | 37.7527789669048 | -122.494719750937 | (37.7527789669048, -122.494719750937) | 1 | 8 | 3 | 56 | 35 | |||
| 144635 | 21248 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 2401X Sunset Blvd | 12 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 60 | 5985051.1945321 | 2098862.1753589 | 37.7422115377949 | -122.494332098234 | (37.7422115377949, -122.494332098234) | 1 | 8 | 3 | 29491 | 35 | |||
| 183970 | 104071 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 590 35th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/06/2013 12:00:00 AM | 1 | 3x3 | Permit Number 770130 | 5985063.18032 | 2111850.11147 | 37.7778734932803 | -122.495248237578 | (37.7778734932803, -122.495248237578) | 11 | 6 | 2 | 55 | 26 | |
| 153922 | 118253 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 843 35th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 5985078.99766 | 2110125.70475 | 37.7731396920548 | -122.495066333199 | (37.7731396920548, -122.495066333199) | 11 | 6 | 2 | 55 | 26 | |||
| 147921 | 118252 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 843 35th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 5985079.97814 | 2110107.82999 | 37.7730906704583 | -122.495061623336 | (37.7730906704583, -122.495061623336) | 11 | 6 | 2 | 55 | 26 | |||
| 111750 | 182357 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 3141 Kirkham St | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 10 | Width 0ft | 5985082.5718 | 2104968.549 | 37.7589798033254 | -122.494673691497 | (37.7589798033254, -122.494673691497) | 1 | 8 | 3 | 56 | 35 | |||
| 135633 | 96633 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 2827 Noriega St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/14/2011 12:00:00 AM | 1 | 3x3 | Permit Number 767879 | 5985197.0326 | 2102920.1993 | 37.7533623000315 | -122.494126866912 | (37.7533623000315, -122.494126866912) | 1 | 8 | 3 | 56 | 35 | |
| 21144 | 50246 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 1287 35th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/27/2003 12:00:00 AM | 0 | Permit Number 46951 | 5985199.39967199 | 2106457.48369728 | 37.7630748403476 | -122.494379405671 | (37.7630748403476, -122.494379405671) | 1 | 8 | 3 | 56 | 35 | |
| 89925 | 185759 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 2520 Rivera St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 0ft | 5985327.7352 | 2100265.3599 | 37.7460804829424 | -122.493479283219 | (37.7460804829424, -122.493479283219) | 1 | 8 | 3 | 29491 | 35 | |||
| 156802 | 185757 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 2510 Rivera St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 0ft | 5985356.995 | 2100268.6849 | 37.7460913240378 | -122.493378353024 | (37.7460913240378, -122.493378353024) | 1 | 8 | 3 | 29491 | 35 | |||
| 184477 | 45597 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 1770 35th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/31/2001 12:00:00 AM | 7 | Permit Number 44332 | 5985361.4044 | 2103173.351 | 37.7540670019119 | -122.493577094797 | (37.7540670019119, -122.493577094797) | 1 | 8 | 3 | 56 | 35 | |
| 70718 | 182847 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 1790 35th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 0ft | 5985366.9663 | 2103044.3154 | 37.7537130309901 | -122.493548353659 | (37.7537130309901, -122.493548353659) | 1 | 8 | 3 | 56 | 35 | |||
| 87229 | 185755 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 2500 Rivera St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 0ft | 5985387.9173 | 2100269.6824 | 37.7460958716028 | -122.493271502729 | (37.7460958716028, -122.493271502729) | 1 | 8 | 3 | 29491 | 35 | |||
| 22873 | 92250 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 1418 34th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/23/2009 12:00:00 AM | 1 | 3x3 | Permit Number 52699 | 5985588.7674 | 2105529.3375 | 37.7605491882923 | -122.492964362242 | (37.7605491882923, -122.492964362242) | 1 | 8 | 3 | 56 | 35 | |
| 187192 | 182410 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 1522 34th Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 3 | Width 0ft | 5985613.4353 | 2104824.559 | 37.7586155044304 | -122.492827136387 | (37.7586155044304, -122.492827136387) | 1 | 8 | 3 | 56 | 35 | |||
| 184038 | 182411 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 1522 34th Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 5 | Width 0ft | 5985613.8208 | 2104844.1281 | 37.7586692583075 | -122.492827244542 | (37.7586692583075, -122.492827244542) | 1 | 8 | 3 | 56 | 35 | |||
| 101426 | 182383 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 1518 34th Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 5 | Width 0ft | 5985615.4072 | 2104868.7172 | 37.75873686594 | -122.492823569243 | (37.75873686594, -122.492823569243) | 1 | 8 | 3 | 56 | 35 | |||
| 159065 | 118180 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 719 33rd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 5985671.79128 | 2110975.99404 | 37.7755090305098 | -122.493078461204 | (37.7755090305098, -122.493078461204) | 11 | 6 | 2 | 55 | 26 | |||
| 23591 | 118179 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 725 33rd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 5985671.99476 | 2110951.2879 | 37.7754412063892 | -122.493075936947 | (37.7754412063892, -122.493075936947) | 11 | 6 | 2 | 55 | 26 | |||
| 183702 | 118178 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 727 33rd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 5985673.20128 | 2110928.01346 | 37.7753773719698 | -122.493070048484 | (37.7753773719698, -122.493070048484) | 11 | 6 | 2 | 55 | 26 | |||
| 126166 | 118177 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 731 33rd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 5985675.34948 | 2110903.2656 | 37.7753095470309 | -122.493060794027 | (37.7753095470309, -122.493060794027) | 11 | 6 | 2 | 55 | 26 | |||
| 35325 | 118176 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 735 33rd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 5985681.32499 | 2110875.53029 | 37.775233743237 | -122.493038080126 | (37.775233743237, -122.493038080126) | 11 | 6 | 2 | 55 | 26 | |||
| 57066 | 118175 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 791 33rd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 5985688.2167 | 2110525.43748 | 37.7742728910373 | -122.492988446406 | (37.7742728910373, -122.492988446406) | 11 | 6 | 2 | 55 | 26 | |||
| 145408 | 119455 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 770 33rd Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 5985727.9206 | 2110655.10709 | 37.7746312487913 | -122.492860658378 | (37.7746312487913, -122.492860658378) | 11 | 6 | 2 | 55 | 26 | |||
| 120072 | 119454 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 770 33rd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 5985729.2789 | 2110639.79727 | 37.7745892918096 | -122.492854831906 | (37.7745892918096, -122.492854831906) | 11 | 6 | 2 | 55 | 26 | |||
| 97802 | 119453 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 774 33rd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 5985730.23512 | 2110623.19134 | 37.7745437525651 | -122.492850300806 | (37.7745437525651, -122.492850300806) | 11 | 6 | 2 | 55 | 26 | |||
| 22883 | 185266 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 2301 Vicente St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 13 | Width 0ft | 5985748.3724 | 2097496.5905 | 37.7385027823228 | -122.491820997516 | (37.7385027823228, -122.491820997516) | 1 | 8 | 3 | 29491 | 35 | |||
| 144586 | 42882 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 2410 34th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/03/2000 12:00:00 AM | 10 | Permit Number 42803 | 5985820.9879 | 2098800.5796 | 37.7420874316705 | -122.491665895545 | (37.7420874316705, -122.491665895545) | 1 | 8 | 3 | 29491 | 35 | |
| 100075 | 84303 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 3132 Balboa St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/11/2008 12:00:00 AM | 7 | 3x3 | Permit Number 50097 | 5985826.14463 | 2111157.47725 | 37.7760163577605 | -122.492557891983 | (37.7760163577605, -122.492557891983) | 11 | 6 | 2 | 55 | 26 | |
| 191195 | 50239 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 1446 33rd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/27/2003 12:00:00 AM | 4 | Permit Number 46945 | 5985903.9099 | 2105369.6531 | 37.7601291639736 | -122.491862687346 | (37.7601291639736, -122.491862687346) | 1 | 8 | 3 | 56 | 35 | |
| 84624 | 250766 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 242 32nd Ave | 1 | : | Tree | Private 2 | 1 | Width 3ft | 5985905.94434 | 2114279.52557 | 37.7845932723154 | -122.492511820787 | (37.7845932723154, -122.492511820787) | 11 | 6 | 1 | 55 | 33 | |||
| 118243 | 50238 | Permitted Site 7 | Olea europaea :: Olive Tree 9 | 1446 33rd Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/27/2003 12:00:00 AM | Permit Number 46945 | 5985908.94380478 | 2105381.71258491 | 37.7601625702054 | -122.491846165538 | (37.7601625702054, -122.491846165538) | 1 | 8 | 3 | 56 | 35 | |||
| 12888 | 260885 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 639 32nd Ave | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 05/18/2019 12:00:00 AM | 3 | 5985963.68769 | 2111543.65127 | 37.7770847226637 | -122.49211054124 | (37.7770847226637, -122.49211054124) | 11 | 6 | 2 | 55 | 26 | |||
| 125426 | 182782 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 1746 33rd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 0ft | 5985976.0485 | 2103344.9901 | 37.7545742128482 | -122.491464169408 | (37.7545742128482, -122.491464169408) | 1 | 8 | 3 | 56 | 35 | |||
| 119970 | 119436 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 743 32nd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 5985983.03487 | 2110840.76703 | 37.775155933503 | -122.491991851858 | (37.775155933503, -122.491991851858) | 11 | 6 | 2 | 55 | 26 | |||
| 60918 | 119437 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 743 32nd Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 5985984.32142 | 2110827.92359 | 37.7751207442671 | -122.491986455657 | (37.7751207442671, -122.491986455657) | 11 | 6 | 2 | 55 | 26 |
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) );