trees
408 rows where Police Districts = 9 and qSpecies_id = 53 sorted by Zip Codes
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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 280 | 8072 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 661 Octavia St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 24 | 3x3 | 6005345.6576 | 2111619.4154 | 37.7784066780298 | -122.425067563729 | (37.7784066780298, -122.425067563729) | 7 | 9 | 11 | 28852 | 10 | |||
| 349 | 253694 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 536 Octavia St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6005450 | 2111168 | 37.7771730951376 | -122.424674483112 | (37.7771730951376, -122.424674483112) | 7 | 9 | 11 | 28852 | 10 | ||||
| 1142 | 260393 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 550 Octavia St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 6005467 | 2111269 | 37.7774513766157 | -122.424622861078 | (37.7774513766157, -122.424622861078) | 7 | 9 | 11 | 28852 | 10 | ||||
| 2956 | 139431 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 539 OCTAVIA ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 0ft | 6005398.6042 | 2111220.8061 | 37.7773151849796 | -122.424856035409 | (37.7773151849796, -122.424856035409) | 7 | 9 | 11 | 28852 | 10 | |||
| 5715 | 140049 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 651 Octavia St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 0ft | 6005353.1353 | 2111583.6293 | 37.778308840554 | -122.42503914867 | (37.778308840554, -122.42503914867) | 7 | 9 | 11 | 28852 | 10 | |||
| 5822 | 16933 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 530 Oak St | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | 24 | 3X3 | 6004214.00427 | 2110149.16937 | 37.7743057532085 | -122.428877532014 | (37.7743057532085, -122.428877532014) | 7 | 9 | 11 | 28852 | 10 | |||
| 6753 | 140065 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 612 Octavia St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 17 | Width 0ft | 6005425.1416 | 2111379.12 | 37.7777513751906 | -122.424775499228 | (37.7777513751906, -122.424775499228) | 7 | 9 | 11 | 28852 | 10 | |||
| 7085 | 260395 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 550 Octavia St | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 6005467 | 2111269 | 37.7774513766157 | -122.424622861078 | (37.7774513766157, -122.424622861078) | 7 | 9 | 11 | 28852 | 10 | ||||
| 9194 | 260391 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 550 Octavia St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 6005467 | 2111269 | 37.7774513766157 | -122.424622861078 | (37.7774513766157, -122.424622861078) | 7 | 9 | 11 | 28852 | 10 | ||||
| 10644 | 260392 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 550 Octavia St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 6005467 | 2111269 | 37.7774513766157 | -122.424622861078 | (37.7774513766157, -122.424622861078) | 7 | 9 | 11 | 28852 | 10 | ||||
| 11231 | 57646 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 666 Octavia St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/16/1981 12:00:00 AM | 16 | 7x7 | Permit Number 19439 | 6005402.5793 | 2111576.4092 | 37.7782918087921 | -122.424867589608 | (37.7782918087921, -122.424867589608) | 7 | 9 | 11 | 28852 | 10 | |
| 12223 | 59958 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 515 Octavia St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/19/1981 12:00:00 AM | 17 | Permit Number 19435 | 6005418.82 | 2111104.349 | 37.7769965639956 | -122.424777815426 | (37.7769965639956, -122.424777815426) | 7 | 9 | 11 | 28852 | 10 | |
| 12493 | 140066 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 614 Octavia St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 0ft | 6005423.0428 | 2111393.287 | 37.7777901557735 | -122.424783767818 | (37.7777901557735, -122.424783767818) | 7 | 9 | 11 | 28852 | 10 | |||
| 13855 | 260394 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 550 Octavia St | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 6005467 | 2111269 | 37.7774513766157 | -122.424622861078 | (37.7774513766157, -122.424622861078) | 7 | 9 | 11 | 28852 | 10 | ||||
| 14128 | 16935 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 542 Oak St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 24 | 3X3 | 6004164.66828 | 2110140.85762 | 37.7742801386068 | -122.429047601533 | (37.7742801386068, -122.429047601533) | 7 | 9 | 11 | 28852 | 10 | |||
| 15312 | 59957 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 539 Octavia St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/16/1981 12:00:00 AM | 12 | Permit Number 19434 | 6005396.005 | 2111241.6 | 37.7773721331465 | -122.424866506623 | (37.7773721331465, -122.424866506623) | 7 | 9 | 11 | 28852 | 10 | |
| 15375 | 57511 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 636 Octavia St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/30/1976 12:00:00 AM | 17 | Permit Number 16364 | 6005408.351 | 2111510.821 | 37.7781120456222 | -122.424842955768 | (37.7781120456222, -122.424842955768) | 7 | 9 | 11 | 28852 | 10 | ||
| 15896 | 140067 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 616 Octavia St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 0ft | 6005420.4192 | 2111411.6517 | 37.7778404325738 | -122.424794150591 | (37.7778404325738, -122.424794150591) | 7 | 9 | 11 | 28852 | 10 | |||
| 17302 | 59963 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 523 Octavia St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/19/1981 12:00:00 AM | 15 | Permit Number 19442 | 6005413.5665 | 2111133.9591 | 37.777077569392 | -122.424798095948 | (37.777077569392, -122.424798095948) | 7 | 9 | 11 | 28852 | 10 | |
| 18271 | 139433 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 539 OCTAVIA ST | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 0ft | 6005406.0306 | 2111183.3028 | 37.7772126295238 | -122.424827676313 | (37.7772126295238, -122.424827676313) | 7 | 9 | 11 | 28852 | 10 | |||
| 18607 | 139432 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 539 OCTAVIA ST | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 0ft | 6005403.0601 | 2111196.299 | 37.77724814614 | -122.424838877048 | (37.77724814614, -122.424838877048) | 7 | 9 | 11 | 28852 | 10 | |||
| 20388 | 6375 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 309X Elm St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 4X4 | 6006152.1987649 | 2112618.7866796 | 37.7811962356475 | -122.422348456516 | (37.7811962356475, -122.422348456516) | 7 | 9 | 11 | 28852 | 41 | |||
| 26376 | 107654 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 600 Octavia St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/07/2014 12:00:00 AM | 3 | Permit Number 772916 | 6005452.33302 | 2111401.13742 | 37.7778133653937 | -122.424683001313 | (37.7778133653937, -122.424683001313) | 7 | 9 | 11 | 28852 | 10 | ||
| 34036 | 9687 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 330 Gough St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/10/2001 12:00:00 AM | 16 | 3x3 | 6006025.52151 | 2110969.11138 | 37.7766594822933 | -122.422669431679 | (37.7766594822933, -122.422669431679) | 7 | 9 | 11 | 28852 | 10 | ||
| 34775 | 14651 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 655X McAllister St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 40 | 3x3 | 6006015.9359491 | 2112078.013352 | 37.7797037167615 | -122.422781416289 | (37.7797037167615, -122.422781416289) | 7 | 9 | 11 | 28852 | 10 | |||
| 40655 | 16939 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 599X Oak St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3X3 | 6004143.7777346 | 2110082.9014722 | 37.774119822678 | -122.429115732545 | (37.774119822678, -122.429115732545) | 7 | 9 | 11 | 28852 | 10 | |||
| 45836 | 9661 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 112 Gough St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 40 | 3X3 | 6006079.13931 | 2110176.88384 | 37.7744872417771 | -122.422427647286 | (37.7744872417771, -122.422427647286) | 7 | 9 | 11 | 28852 | 10 | |||
| 48721 | 9675 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 235 Gough St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/19/1981 12:00:00 AM | 12 | 3X3 | 6005972.11971 | 2110519.21136 | 37.7754211527567 | -122.422822183014 | (37.7754211527567, -122.422822183014) | 7 | 9 | 11 | 28852 | 10 | ||
| 52416 | 6378 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 310 Elm St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 4X4 | 6006136.3622128 | 2112667.0618885 | 37.7813278942368 | -122.422406674363 | (37.7813278942368, -122.422406674363) | 7 | 9 | 11 | 28852 | 41 | |||
| 54208 | 9683 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 298 Gough St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/24/1982 12:00:00 AM | 20 | 3X3 | 6006045.73768 | 2110624.99987 | 37.7757157759068 | -122.422575039685 | (37.7757157759068, -122.422575039685) | 7 | 9 | 11 | 28852 | 10 | ||
| 57513 | 12263 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 640 Laguna St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3x3 | 6004991.72568 | 2111198.95935 | 37.7772322091826 | -122.426262005109 | (37.7772322091826, -122.426262005109) | 7 | 9 | 11 | 28852 | 10 | |||
| 61171 | 16895 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 371 Oak St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3X3 | 6005249.75731 | 2110166.87775 | 37.7744129459718 | -122.425295929281 | (37.7744129459718, -122.425295929281) | 7 | 9 | 11 | 28852 | 10 | |||
| 67817 | 16940 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 599X Oak St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3X3 | 6004143.7777346 | 2110082.9014722 | 37.774119822678 | -122.429115732545 | (37.774119822678, -122.429115732545) | 7 | 9 | 11 | 28852 | 10 | |||
| 72584 | 16863 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 215 Oak St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3x3 | 6005958.79101 | 2110336.37823 | 37.774918385113 | -122.422855293382 | (37.774918385113, -122.422855293382) | 7 | 9 | 11 | 28852 | 10 | |||
| 75688 | 6379 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 310 Elm St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 4X4 | 6006136.3622128 | 2112667.0618885 | 37.7813278942368 | -122.422406674363 | (37.7813278942368, -122.422406674363) | 7 | 9 | 11 | 28852 | 41 | |||
| 79471 | 59271 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 110 Webster St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/09/2017 12:00:00 AM | 3 | Permit Number 18607 | 6004280.88948873 | 2109181.36087728 | 37.7716521728269 | -122.428577162778 | (37.7716521728269, -122.428577162778) | 7 | 9 | 11 | 28852 | 10 | ||
| 81976 | 7711 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 43 Franklin St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6006508.0978555 | 2110273.8315465 | 37.7747776257034 | -122.420950679235 | (37.7747776257034, -122.420950679235) | 7 | 9 | 11 | 28852 | 10 | |||
| 83435 | 14655 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 655X McAllister St | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 60 | 3x3 | 6006015.9359491 | 2112078.013352 | 37.7797037167615 | -122.422781416289 | (37.7797037167615, -122.422781416289) | 7 | 9 | 11 | 28852 | 10 | |||
| 83704 | 10626 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 414 Gough St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 20 | 3X3 | 6005955 | 2111106 | 37.7770313662769 | -122.422923117926 | (37.7770313662769, -122.422923117926) | 7 | 9 | 11 | 28852 | 10 | |||
| 90207 | 6932 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 500 Fell St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | Permit Number 780762 | 6004980.8762 | 2110598.20876 | 37.7755820815859 | -122.426256755638 | (37.7755820815859, -122.426256755638) | 7 | 9 | 11 | 28852 | 10 | ||
| 95502 | 16899 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 406 Oak St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3X3 | 6005035.08833 | 2110252.02045 | 37.7746345969303 | -122.426044572686 | (37.7746345969303, -122.426044572686) | 7 | 9 | 11 | 28852 | 10 | |||
| 103903 | 7712 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 47 Franklin St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6006492.59831 | 2110356.24747 | 37.7750030463236 | -122.421010148365 | (37.7750030463236, -122.421010148365) | 7 | 9 | 11 | 28852 | 10 | |||
| 115288 | 107652 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 600 Octavia St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/07/2014 12:00:00 AM | 3 | Permit Number 772916 | 6005452.33302 | 2111401.13742 | 37.7778133653937 | -122.424683001313 | (37.7778133653937, -122.424683001313) | 7 | 9 | 11 | 28852 | 10 | ||
| 116014 | 107653 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 600 Octavia St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/07/2014 12:00:00 AM | 3 | Permit Number 772916 | 6005452.33302 | 2111401.13742 | 37.7778133653937 | -122.424683001313 | (37.7778133653937, -122.424683001313) | 7 | 9 | 11 | 28852 | 10 | ||
| 117462 | 12246 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 501 Laguna St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/03/2015 03:15:00 PM | 3 | 5x5 | 6004973.20209 | 2110637.42143 | 37.775689316239 | -122.426286094705 | (37.775689316239, -122.426286094705) | 7 | 9 | 11 | 28852 | 10 | ||
| 122936 | 16856 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 150 Oak St | 9 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 4X4 | 6006257.87931 | 2110498.54999 | 37.7753805408795 | -122.421832203671 | (37.7753805408795, -122.421832203671) | 7 | 9 | 11 | 28852 | 10 | |||
| 125851 | 253693 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 536 Octavia St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6005450 | 2111168 | 37.7771730951376 | -122.424674483112 | (37.7771730951376, -122.424674483112) | 7 | 9 | 11 | 28852 | 10 | ||||
| 128624 | 117343 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 372 HAYES ST | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5x5 | 6006019 | 2111114 | 37.7770569433878 | -122.422702290381 | (37.7770569433878, -122.422702290381) | 7 | 9 | 11 | 28852 | 10 | ||||
| 133335 | 99718 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 430 Hayes St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | 3x3 | 6005787 | 2111054 | 37.7768791059226 | -122.423500585068 | (37.7768791059226, -122.423500585068) | 7 | 9 | 11 | 28852 | 10 | |||
| 141441 | 26425 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 555 Fulton St | 13 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 3X3 | 6005298.7673 | 2111637.29894 | 37.7784531329654 | -122.425231047872 | (37.7784531329654, -122.425231047872) | 7 | 9 | 11 | 28852 | 10 | |||
| 142032 | 16862 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 205 Oak St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 24 | 7x6 | 6005961.9803 | 2110311.49787 | 37.7748502496054 | -122.422842492323 | (37.7748502496054, -122.422842492323) | 7 | 9 | 11 | 28852 | 10 | |||
| 142334 | 12245 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 503 Laguna St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/03/2015 03:15:00 PM | 3 | 5x5 | Permit Number 780762 | 6004995.5845 | 2110652.4736 | 37.7757319109571 | -122.426209740207 | (37.7757319109571, -122.426209740207) | 7 | 9 | 11 | 28852 | 10 | |
| 158220 | 9662 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 112 Gough St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 22 | 3X3 | 6006086.53311 | 2110106.07673 | 37.7742932396102 | -122.422397038566 | (37.7742932396102, -122.422397038566) | 7 | 9 | 11 | 28852 | 10 | |||
| 163768 | 9696 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 414 Gough St | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 22 | 3X3 | 6005964.80411 | 2111186.62637 | 37.7772532999259 | -122.422894934036 | (37.7772532999259, -122.422894934036) | 7 | 9 | 11 | 28852 | 10 | |||
| 163968 | 16919 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 500 Oak St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 24 | 13x6 | 6004493.27484 | 2110185.04209 | 37.7744200538695 | -122.427914040239 | (37.7744200538695, -122.427914040239) | 7 | 9 | 11 | 28852 | 10 | |||
| 164782 | 26423 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 555 Fulton St | 11 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 3X3 | 6005252.46633 | 2111627.39845 | 37.7784233328254 | -122.425390515771 | (37.7784233328254, -122.425390515771) | 7 | 9 | 11 | 28852 | 10 | |||
| 170574 | 114952 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 601X OCTAVIA ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6005348 | 2111368 | 37.7777164851071 | -122.42504156742 | (37.7777164851071, -122.42504156742) | 7 | 9 | 11 | 28852 | 10 | ||||
| 172169 | 117345 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 395 HAYES ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6006014 | 2111158 | 37.7771774746178 | -122.422722714586 | (37.7771774746178, -122.422722714586) | 7 | 9 | 11 | 28852 | 10 | ||||
| 173262 | 16934 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 534 Oak St | 1 | Sidewalk: Property side : Cutout | Tree | DPW 1 | 24 | 3X3 | 6004202.21217 | 2110156.57626 | 37.7743254232669 | -122.428918851232 | (37.7743254232669, -122.428918851232) | 7 | 9 | 11 | 28852 | 10 | |||
| 174129 | 16872 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 259 Oak St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 4X4 | 6005773.57352 | 2110239.8238 | 37.7746428175577 | -122.423489134945 | (37.7746428175577, -122.423489134945) | 7 | 9 | 11 | 28852 | 10 | |||
| 176749 | 6380 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 310 Elm St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 4X4 | 6006136.3622128 | 2112667.0618885 | 37.7813278942368 | -122.422406674363 | (37.7813278942368, -122.422406674363) | 7 | 9 | 11 | 28852 | 41 | |||
| 182795 | 26424 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 555 Fulton St | 12 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 3X3 | 6005277.15037 | 2111634.16402 | 37.7784433040001 | -122.425305605903 | (37.7784433040001, -122.425305605903) | 7 | 9 | 11 | 28852 | 10 | |||
| 183025 | 26841 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 100 Van Ness Ave | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3X3 | Permit Number 779930 | 6006975.88726 | 2110943.04151 | 37.7766414730488 | -122.419379980819 | (37.7766414730488, -122.419379980819) | 7 | 9 | 9 | 28852 | 36 | ||
| 188066 | 9689 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 332 Gough St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | 3x3 | 6006025.5202 | 2110969.11106 | 37.7766594813407 | -122.422669436188 | (37.7766594813407, -122.422669436188) | 7 | 9 | 11 | 28852 | 10 | |||
| 188563 | 10618 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 350 Gough St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3x3 | 6006025.52151 | 2110969.11138 | 37.7766594822933 | -122.422669431679 | (37.7766594822933, -122.422669431679) | 7 | 9 | 11 | 28852 | 10 | |||
| 191157 | 16897 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 385 Oak St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3x3 | 6005198.99692 | 2110159.80887 | 37.7743906686767 | -122.425471016021 | (37.7743906686767, -122.425471016021) | 7 | 9 | 11 | 28852 | 10 | |||
| 191412 | 2431 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 490X Oak St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 25 | 3X3 | 6004657.78302 | 2110211.29448 | 37.7745014417711 | -122.427346845616 | (37.7745014417711, -122.427346845616) | 7 | 9 | 11 | 28852 | 10 | |||
| 192777 | 48866 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 129 Oak St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/15/2002 12:00:00 AM | Permit Number 46075 | 6006370.62112219 | 2110394.65908683 | 37.7751016387897 | -122.421434823029 | (37.7751016387897, -122.421434823029) | 7 | 9 | 11 | 28852 | 10 | |||
| 2280 | 116028 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 1500 PACIFIC AVE | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6006937 | 2117734 | 37.7952855901943 | -122.419996533467 | (37.7952855901943, -122.419996533467) | 13 | 9 | 10 | 28858 | 32 | ||||
| 7742 | 21626 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 1610 Sutter St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 4X4 | 6004833.69671 | 2114745.44523 | 37.7869610478907 | -122.427061339905 | (37.7869610478907, -122.427061339905) | 13 | 9 | 11 | 28858 | 27 | |||
| 20638 | 21644 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 1657 Sutter St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 4X4 | 6004676.7022509 | 2114666.9735246 | 37.7867367053745 | -122.427598912468 | (37.7867367053745, -122.427598912468) | 13 | 9 | 11 | 28858 | 13 | |||
| 22585 | 23704 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 2119X Gough St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | 3X3 | 6005103.6033 | 2116867.23334 | 37.7928022043515 | -122.426278644375 | (37.7928022043515, -122.426278644375) | 13 | 9 | 1 | 28858 | 27 | |||
| 22613 | 7891 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 1187 Franklin St | 8 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 24 | 3X3 | 6005998.65959 | 2113925.10155 | 37.7847743933389 | -122.422972499839 | (37.7847743933389, -122.422972499839) | 13 | 9 | 11 | 28858 | 41 | |||
| 28409 | 23540 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 2750 Van Ness Ave | 15 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3x3 | 6005743.06666 | 2119831.60651 | 37.8009777467475 | -122.424276999326 | (37.8009777467475, -122.424276999326) | 13 | 9 | 1 | 28858 | 32 | |||
| 29320 | 21640 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 1645 Sutter St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | 4X4 | 6004732.1765743 | 2114674.6857014 | 37.7867610187213 | -122.427407534005 | (37.7867610187213, -122.427407534005) | 13 | 9 | 11 | 28858 | 13 | |||
| 32727 | 16390 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 246 Myrtle St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | 3X3 | 6006205.61528 | 2114051.709 | 37.7851337020107 | -122.422265498437 | (37.7851337020107, -122.422265498437) | 13 | 9 | 11 | 28858 | 41 | |||
| 33408 | 6246 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 1280 Ellis St | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3X3 | 6004721.4422 | 2113335.3655 | 37.7830829720913 | -122.427349228935 | (37.7830829720913, -122.427349228935) | 7 | 9 | 11 | 28858 | 41 | |||
| 38327 | 17368 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 2308X Gough St | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 30 | 3X3 | 6005067.32521 | 2117488.78546 | 37.794506778582 | -122.426448444628 | (37.794506778582, -122.426448444628) | 13 | 9 | 1 | 28858 | 27 | |||
| 38667 | 21584 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 1499 Sutter St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3X3 | 6005574.52113 | 2114792.70084 | 37.787132663766 | -122.424501615425 | (37.787132663766, -122.424501615425) | 13 | 9 | 1 | 28858 | 41 | |||
| 39319 | 23703 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 2119X Gough St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 24 | 3X3 | 6005103.6033 | 2116867.23334 | 37.7928022043515 | -122.426278644375 | (37.7928022043515, -122.426278644375) | 13 | 9 | 1 | 28858 | 27 | |||
| 39669 | 95554 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 1333@ Larkin Bush St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6007121 | 2115358 | 37.7887720478953 | -122.419191239667 | (37.7887720478953, -122.419191239667) | 13 | 9 | 10 | 28858 | 21 | |||||
| 41963 | 21634 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 1629 Sutter St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 4X4 | 6004806.293908 | 2114684.9896753 | 37.786793502462 | -122.427151839633 | (37.786793502462, -122.427151839633) | 13 | 9 | 11 | 28858 | 13 | |||
| 46032 | 121039 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 2101 Polk St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6006363 | 2118098 | 37.7962526868942 | -122.422008539697 | (37.7962526868942, -122.422008539697) | 13 | 9 | 10 | 28858 | 32 | ||||
| 46932 | 17830 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 1961 Pine St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6004561.39396 | 2115345.0767756 | 37.7885920838825 | -122.428046192771 | (37.7885920838825, -122.428046192771) | 13 | 9 | 11 | 28858 | 27 | |||
| 48975 | 21630 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 1615 Sutter St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/23/1990 12:00:00 AM | 6 | 4X4 | 6004701.1521 | 2114671.0024 | 37.786749150585 | -122.427514608894 | (37.786749150585, -122.427514608894) | 13 | 9 | 11 | 28858 | 13 | ||
| 49601 | 16393 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 250X Myrtle St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3X3 | 6006231.99165 | 2114068.14091 | 37.7851803077551 | -122.422175412097 | (37.7851803077551, -122.422175412097) | 13 | 9 | 11 | 28858 | 41 | |||
| 51742 | 11446 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 2191X Gough St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3X3 | 6005072.64937 | 2117089.85961 | 37.7934117301419 | -122.426401604865 | (37.7934117301419, -122.426401604865) | 13 | 9 | 1 | 28858 | 27 | |||
| 55528 | 23492 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 2510 Van Ness Ave | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 24 | 3X3 | 6005839.2618 | 2119053.89467 | 37.7988477792821 | -122.423888789861 | (37.7988477792821, -122.423888789861) | 13 | 9 | 1 | 28858 | 32 | |||
| 62202 | 23539 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 2750 Van Ness Ave | 14 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 23 | 3x3 | 6005738.98285 | 2119846.6704 | 37.8010188777475 | -122.424292203059 | (37.8010188777475, -122.424292203059) | 13 | 9 | 1 | 28858 | 32 | |||
| 62512 | 21625 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 1610 Sutter St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 4X4 | 6004858.21198 | 2114748.18478 | 37.7869699562504 | -122.426976717781 | (37.7869699562504, -122.426976717781) | 13 | 9 | 11 | 28858 | 27 | |||
| 65216 | 23529 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 2750 Van Ness Ave | 18 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 24 | 3X3 | 6005762.85494 | 2119704.71005 | 37.8006304387912 | -122.42419949344 | (37.8006304387912, -122.42419949344) | 13 | 9 | 1 | 28858 | 32 | |||
| 68956 | 16394 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 250X Myrtle St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3X3 | 6006231.99165 | 2114068.14091 | 37.7851803077551 | -122.422175412097 | (37.7851803077551, -122.422175412097) | 13 | 9 | 11 | 28858 | 41 | |||
| 72817 | 121043 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 2125 Polk St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6006363 | 2118096 | 37.7962471953974 | -122.422008397548 | (37.7962471953974, -122.422008397548) | 13 | 9 | 10 | 28858 | 32 | ||||
| 75386 | 23542 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 2750 Van Ness Ave | 17 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 14 | 3x3 | 6005753.45253 | 2119744.59142 | 37.8007394119615 | -122.424234867659 | (37.8007394119615, -122.424234867659) | 13 | 9 | 1 | 28858 | 32 | |||
| 77904 | 56931 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 1909 Vallejo St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/15/1974 12:00:00 AM | 17 | Permit Number 14175 | 6004317.92538 | 2118019.69798 | 37.795922137343 | -122.429079333669 | (37.795922137343, -122.429079333669) | 13 | 9 | 1 | 28858 | 27 | ||
| 78831 | 99639 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 2201 Polk St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6006359 | 2118331 | 37.7968922206311 | -122.422038941111 | (37.7968922206311, -122.422038941111) | 13 | 9 | 10 | 28858 | 32 | ||||
| 79513 | 47917 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 999 Revised) Van Ness Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/21/2002 12:00:00 AM | Permit Number 45655 | 6006486.39229912 | 2113910.68802822 | 37.7847623267063 | -122.421284078173 | (37.7847623267063, -122.421284078173) | 13 | 9 | 11 | 28858 | 41 | |||
| 82597 | 21583 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 1499 Sutter St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3X3 | 6005557.61202 | 2114792.21407 | 37.7871303723087 | -122.424560082666 | (37.7871303723087, -122.424560082666) | 13 | 9 | 1 | 28858 | 41 | |||
| 84337 | 9917 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 1905X Gough St | 1 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 30 | 3x3 | Permit Number 768908 | 6005198.9827241 | 2116181.2464075 | 37.7909240477297 | -122.425899774562 | (37.7909240477297, -122.425899774562) | 13 | 9 | 1 | 28858 | 27 | ||
| 87750 | 53929 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 1700 Laguna St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/29/1972 12:00:00 AM | 3x3 | Permit Number 9642 | 6004487.99959123 | 2114676.46033991 | 37.786752078395 | -122.428252455396 | (37.786752078395, -122.428252455396) | 13 | 9 | 11 | 28858 | 27 |
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) );