trees
953 rows where qSpecies_id = 60 sorted by Police Districts
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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 422 | 113225 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 970JONES Bush St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 5 | 3x3 | 6008828.65356 | 2115644.68399 | 37.7896552332384 | -122.413303262628 | (37.7896552332384, -122.413303262628) | 5 | 1 | 10 | 28858 | 21 | ||
| 12100 | 96019 | Permitted Site 7 | Callistemon viminalis :: Weeping Bottlebrush 60 | 810 Jones St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/02/2011 12:00:00 AM | 3x3 | Permit Number 767661 | 6008769 | 2115301 | 37.7887082111555 | -122.413485341988 | (37.7887082111555, -122.413485341988) | 5 | 1 | 10 | 28858 | 21 | |
| 23186 | 103507 | Undocumented 4 | Callistemon viminalis :: Weeping Bottlebrush 60 | 100X Leroy Pl | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | 3x3 | 6008356 | 2116660 | 37.7924164947138 | -122.415010494885 | (37.7924164947138, -122.415010494885) | 5 | 1 | 10 | 28858 | 21 | |||
| 37840 | 96018 | Permitted Site 7 | Callistemon viminalis :: Weeping Bottlebrush 60 | 810 Jones St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/02/2011 12:00:00 AM | 3x3 | Permit Number 767661 | 6008769 | 2115301 | 37.7887082111555 | -122.413485341988 | (37.7887082111555, -122.413485341988) | 5 | 1 | 10 | 28858 | 21 | |
| 37894 | 45238 | Permitted Site 7 | Callistemon viminalis :: Weeping Bottlebrush 60 | 871 Sutter St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/11/2001 12:00:00 AM | Permit Number 44088 | 6008421.36689101 | 2115188.65226849 | 37.7883802062735 | -122.414680152021 | (37.7883802062735, -122.414680152021) | 5 | 1 | 10 | 28858 | 21 | |||
| 44956 | 103510 | Undocumented 4 | Callistemon viminalis :: Weeping Bottlebrush 60 | 100X Leroy Pl | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | 3x3 | 6008356 | 2116660 | 37.7924164947138 | -122.415010494885 | (37.7924164947138, -122.415010494885) | 5 | 1 | 10 | 28858 | 21 | |||
| 49184 | 125884 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 786 Sutter St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 4ft | 6008808.31826 | 2115292.90351 | 37.7886881877568 | -122.413348733254 | (37.7886881877568, -122.413348733254) | 5 | 1 | 10 | 28858 | 21 | |||
| 56102 | 52371 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 970JONES Bush St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/14/2005 12:00:00 AM | 6 | 3x3 | Permit Number 48503 | 6008855.4568 | 2115649.67517 | 37.7896704425982 | -122.413210878899 | (37.7896704425982, -122.413210878899) | 5 | 1 | 10 | 28858 | 21 |
| 56301 | 33288 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 1242 Sacramento St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/13/1996 12:00:00 AM | 7 | Permit Number 37449 | 6008832.98278 | 2116682.76958 | 37.7925058062477 | -122.413361726687 | (37.7925058062477, -122.413361726687) | 5 | 1 | 10 | 28857 | 21 | |
| 70980 | 96020 | Permitted Site 7 | Callistemon viminalis :: Weeping Bottlebrush 60 | 810 Jones St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/02/2011 12:00:00 AM | 3x3 | Permit Number 767661 | 6008769 | 2115301 | 37.7887082111555 | -122.413485341988 | (37.7887082111555, -122.413485341988) | 5 | 1 | 10 | 28858 | 21 | |
| 83367 | 103511 | Undocumented 4 | Callistemon viminalis :: Weeping Bottlebrush 60 | 100X Leroy Pl | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | 3x3 | 6008356 | 2116660 | 37.7924164947138 | -122.415010494885 | (37.7924164947138, -122.415010494885) | 5 | 1 | 10 | 28858 | 21 | |||
| 83415 | 107235 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 786 Sutter St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | 3x3 | 6008834.66692 | 2115296.44284 | 37.7886993852058 | -122.413257820814 | (37.7886993852058, -122.413257820814) | 5 | 1 | 10 | 28858 | 21 | |||
| 84156 | 125883 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 786 Sutter St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 4ft | 6008823.04151 | 2115295.32129 | 37.7886956530184 | -122.413297963833 | (37.7886956530184, -122.413297963833) | 5 | 1 | 10 | 28858 | 21 | |||
| 143719 | 103509 | Undocumented 4 | Callistemon viminalis :: Weeping Bottlebrush 60 | 100X Leroy Pl | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | 3x3 | 6008356 | 2116660 | 37.7924164947138 | -122.415010494885 | (37.7924164947138, -122.415010494885) | 5 | 1 | 10 | 28858 | 21 | |||
| 149802 | 96017 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 810 Jones St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/02/2011 12:00:00 AM | 3 | 3x3 | Permit Number 767661 | 6008768.28006 | 2115323.27409 | 37.7887693299764 | -122.413489408823 | (37.7887693299764, -122.413489408823) | 5 | 1 | 10 | 28858 | 21 |
| 160338 | 103508 | Undocumented 4 | Callistemon viminalis :: Weeping Bottlebrush 60 | 100X Leroy Pl | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | 3x3 | 6008356 | 2116660 | 37.7924164947138 | -122.415010494885 | (37.7924164947138, -122.415010494885) | 5 | 1 | 10 | 28858 | 21 | |||
| 166077 | 96016 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 810 Jones St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/02/2011 12:00:00 AM | 4 | 3x3 | Permit Number 767661 | 6008769.14714 | 2115306.341 | 37.788722884507 | -122.41348521079 | (37.788722884507, -122.41348521079) | 5 | 1 | 10 | 28858 | 21 |
| 175825 | 125890 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 8 Sharp Pl | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6007493.35542 | 2119123.01732 | 37.7991308141058 | -122.418169974478 | (37.7991308141058, -122.418169974478) | 5 | 1 | 10 | 28858 | 32 | |||
| 30336 | 125888 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 575 Ellis St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 4ft | 6008045.66737 | 2113749.49498 | 37.7844075146451 | -122.415878065725 | (37.7844075146451, -122.415878065725) | 7 | 10 | 9 | 28858 | 36 | |||
| 96910 | 114307 | Undocumented 4 | Callistemon viminalis :: Weeping Bottlebrush 60 | 595 ELLIS ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6008020 | 2113749 | 37.7844047125189 | -122.415966831143 | (37.7844047125189, -122.415966831143) | 7 | 10 | 9 | 28858 | 36 | ||||
| 116464 | 125885 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 476 Eddy St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 4ft | 6008153.2935 | 2113467.57124 | 37.7836394702246 | -122.415485749065 | (37.7836394702246, -122.415485749065) | 7 | 10 | 9 | 28858 | 36 | |||
| 175317 | 39767 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 476 Eddy St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/23/2000 12:00:00 AM | 3 | 2x2 | Permit Number 42916 | 6008173.90648 | 2113469.9166 | 37.7836470686025 | -122.415414601899 | (37.7836470686025, -122.415414601899) | 7 | 10 | 9 | 28858 | 36 |
| 24479 | 188293 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 1582 12th St | 1 | : | Tree | Private 2 | 19 | Width 5ft | 6008175.89918 | 2108871.24729 | 37.7710203298423 | -122.415082093787 | (37.7710203298423, -122.415082093787) | 8 | 2 | 9 | 28853 | 19 | |||
| 27981 | 30676 | Permitted Site 7 | Callistemon viminalis :: Weeping Bottlebrush 60 | 1040 Minna St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/30/1995 12:00:00 AM | 11 | 3x3 | Permit Number 34599 | 6007565.37727332 | 2109755.15641274 | 37.7734130071983 | -122.417256559972 | (37.7734130071983, -122.417256559972) | 8 | 2 | 9 | 28853 | 19 |
| 39368 | 43890 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 1233 Howard St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/03/2000 12:00:00 AM | 5 | Permit Number 43498 | 6009124.11279 | 2110606.98987 | 37.7758395125283 | -122.41192485917 | (37.7758395125283, -122.41192485917) | 8 | 2 | 9 | 28853 | 34 | ||
| 57867 | 188291 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 40 Sheridan St | 3 | : | Tree | Private 2 | 5 | Width 3ft | 6009385.19996 | 2109515.63966 | 37.7728575647512 | -122.410944589137 | (37.7728575647512, -122.410944589137) | 8 | 2 | 9 | 28853 | 34 | |||
| 58302 | 188285 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 106 Langton St | 1 | : | Tree | Private 2 | 6 | Width 3ft | 6010183.94442 | 2110713.51419 | 37.7761914064457 | -122.408266129292 | (37.7761914064457, -122.408266129292) | 8 | 2 | 9 | 28853 | 34 | |||
| 60961 | 188300 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 90 Kissling St | 1 | : | Tree | Private 2 | 7 | Width 3ft | 6008269.7706 | 2109537.20803 | 37.7728541761188 | -122.41480452791 | (37.7728541761188, -122.41480452791) | 8 | 2 | 9 | 28853 | 34 | |||
| 61923 | 95866 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 32 Sheridan St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/29/2011 12:00:00 AM | 5 | 3x3 | Permit Number 767584 | 6009326.62305 | 2109462.37063 | 37.7727080155855 | -122.411143450809 | (37.7727080155855, -122.411143450809) | 8 | 2 | 9 | 28853 | 34 |
| 67207 | 188299 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 1022 Minna St | 4 | : | Tree | Private 2 | 4 | Width 3ft | 6007530.78901 | 2109693.3141 | 37.7732412569071 | -122.417371822555 | (37.7732412569071, -122.417371822555) | 8 | 2 | 9 | 28853 | 19 | |||
| 67527 | 30677 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 920 Natoma St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/30/1995 12:00:00 AM | 8 | Permit Number 34600 | 6008142.25986 | 2110035.66546 | 37.7742156570679 | -122.415280896104 | (37.7742156570679, -122.415280896104) | 8 | 2 | 9 | 28853 | 34 | |
| 68435 | 188303 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 90 Kissling St | 4 | : | Tree | Private 2 | 8 | Width 3ft | 6008234.3659 | 2109502.33979 | 37.7727564467773 | -122.414924528938 | (37.7727564467773, -122.414924528938) | 8 | 2 | 9 | 28853 | 34 | |||
| 69202 | 43888 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 1233 Howard St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/29/2011 12:00:00 AM | 6 | 3x3 | Permit Number 767585 | 6009068.61437 | 2110555.25783 | 37.7756943547316 | -122.412113186199 | (37.7756943547316, -122.412113186199) | 8 | 2 | 9 | 28853 | 34 |
| 86585 | 188289 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 40 Sheridan St | 1 | : | Tree | Private 2 | 5 | Width 3ft | 6009413.38466 | 2109546.86827 | 37.7729448916301 | -122.410849300561 | (37.7729448916301, -122.410849300561) | 8 | 2 | 9 | 28853 | 34 | |||
| 88999 | 43891 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 1233 Howard St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/03/2000 12:00:00 AM | 5 | Permit Number 43498 | 6009112.33188 | 2110593.08814 | 37.7758006806963 | -122.411964629875 | (37.7758006806963, -122.411964629875) | 8 | 2 | 9 | 28853 | 34 | ||
| 90113 | 43897 | Permitted Site 7 | Callistemon viminalis :: Weeping Bottlebrush 60 | 714 Tehama St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/04/2000 12:00:00 AM | Permit Number 43499 | 6009277.55531704 | 2110532.12490079 | 37.7756425583487 | -122.411388770124 | (37.7756425583487, -122.411388770124) | 8 | 2 | 9 | 28853 | 34 | |||
| 94892 | 188302 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 90 Kissling St | 3 | : | Tree | Private 2 | 7 | Width 3ft | 6008239.71976 | 2109507.11568 | 37.7727698610843 | -122.414906347362 | (37.7727698610843, -122.414906347362) | 8 | 2 | 9 | 28853 | 34 | |||
| 95823 | 43889 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 1233 Howard St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/03/2000 12:00:00 AM | 4 | Permit Number 43498 | 6009135.81805 | 2110617.1891 | 37.775868173909 | -122.411885088422 | (37.775868173909, -122.411885088422) | 8 | 2 | 9 | 28853 | 34 | ||
| 101610 | 188297 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 1582 12th St | 5 | : | Tree | Private 2 | 7 | Width 5ft | 6008118.01492 | 2108896.99552 | 37.7710877753987 | -122.415284140848 | (37.7710877753987, -122.415284140848) | 8 | 2 | 9 | 28853 | 19 | |||
| 103654 | 43892 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 1233 Howard St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/03/2000 12:00:00 AM | 6 | Permit Number 43498 | 6009086.19652 | 2110571.73494 | 37.7757405834934 | -122.412053529658 | (37.7757405834934, -122.412053529658) | 8 | 2 | 9 | 28853 | 34 | ||
| 110873 | 188301 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 90 Kissling St | 2 | : | Tree | Private 2 | 7 | Width 3ft | 6008261.50029 | 2109526.90873 | 37.7728254319749 | -122.41483240691 | (37.7728254319749, -122.41483240691) | 8 | 2 | 9 | 28853 | 34 | |||
| 110924 | 30674 | Permitted Site 7 | Callistemon viminalis :: Weeping Bottlebrush 60 | 1040 Minna St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/26/2005 12:00:00 AM | Permit Number 34599 | 6007565.37727332 | 2109755.15641274 | 37.7734130071983 | -122.417256559972 | (37.7734130071983, -122.417256559972) | 8 | 2 | 9 | 28853 | 19 | ||
| 111154 | 188298 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 1022 Minna St | 3 | : | Tree | Private 2 | 10 | Width 3ft | 6007537.97287 | 2109701.89036 | 37.7732652094644 | -122.41734758044 | (37.7732652094644, -122.41734758044) | 8 | 2 | 9 | 28853 | 19 | |||
| 111675 | 188287 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 106 Langton St | 3 | : | Tree | Private 2 | 6 | Width 3ft | 6010207.19158 | 2110684.55446 | 37.7761131915025 | -122.408183667747 | (37.7761131915025, -122.408183667747) | 8 | 2 | 9 | 28853 | 34 | |||
| 112897 | 188290 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 40 Sheridan St | 2 | : | Tree | Private 2 | 7 | Width 3ft | 6009398.69382 | 2109531.26602 | 37.7729012277415 | -122.410899015985 | (37.7729012277415, -122.410899015985) | 8 | 2 | 9 | 28853 | 34 | |||
| 120697 | 35219 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 896 Folsom St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/03/1998 12:00:00 AM | 7 | Permit Number 38722 | 6011641.6488 | 2112229.3585 | 37.7804350816614 | -122.403330167353 | (37.7804350816614, -122.403330167353) | 6 | 2 | 9 | 28853 | 34 | ||
| 121977 | 41599 | Permitted Site 7 | Callistemon viminalis :: Weeping Bottlebrush 60 | 11 Haight St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/01/2000 12:00:00 AM | Permit Number 42106 | 6006168.11250893 | 2109650.54781373 | 37.7730470683498 | -122.422082471983 | (37.7730470683498, -122.422082471983) | 7 | 2 | 11 | 28852 | 10 | |||
| 126466 | 188296 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 1582 12th St | 4 | : | Tree | Private 2 | 13 | Width 5ft | 6008131.89677 | 2108889.41859 | 37.7710677511061 | -122.415235586466 | (37.7710677511061, -122.415235586466) | 8 | 2 | 9 | 28853 | 19 | |||
| 126759 | 43894 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 716 Tehama St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/04/2000 12:00:00 AM | 6 | Permit Number 43499 | 6009202.88564 | 2110443.77487 | 37.7753957816152 | -122.411640828084 | (37.7753957816152, -122.411640828084) | 8 | 2 | 9 | 28853 | 34 | ||
| 129887 | 43893 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 1233 Howard St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/03/2000 12:00:00 AM | 5 | Permit Number 43498 | 6009099.28139 | 2110583.25278 | 37.7757729429148 | -122.412009079782 | (37.7757729429148, -122.412009079782) | 8 | 2 | 9 | 28853 | 34 | ||
| 136875 | 84731 | Permitted Site 7 | Callistemon viminalis :: Weeping Bottlebrush 60 | 72 Tehama St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/13/2007 12:00:00 AM | Permit No. 49232 | 6013473 | 2114579 | 37.7869887683946 | -122.397159425184 | (37.7869887683946, -122.397159425184) | 6 | 2 | 9 | 28855 | 6 | |||
| 138799 | 188294 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 1582 12th St | 2 | : | Tree | Private 2 | 12 | Width 5ft | 6008162.78535 | 2108877.84718 | 37.7710377146367 | -122.415127922313 | (37.7710377146367, -122.415127922313) | 8 | 2 | 9 | 28853 | 19 | |||
| 150558 | 43896 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 716 Tehama St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/21/2008 12:00:00 AM | 6 | 3x3 | Permit Number 51474 | 6009227.05246 | 2110468.55015 | 37.7754651643179 | -122.411558979885 | (37.7754651643179, -122.411558979885) | 8 | 2 | 9 | 28853 | 34 | |
| 160804 | 35218 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 896 Folsom St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/03/1998 12:00:00 AM | 5 | Permit Number 40401 | 6011658.1335 | 2112244.4696 | 37.7804774939022 | -122.403274202035 | (37.7804774939022, -122.403274202035) | 6 | 2 | 9 | 28853 | 34 | ||
| 161829 | 53084 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 737 8TH & 9TH Tehama St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/26/2006 12:00:00 AM | 2 | Permit Number 49051 | 6009184.03674 | 2110393.9636 | 37.7752579542298 | -122.411702510768 | (37.7752579542298, -122.411702510768) | 8 | 2 | 9 | 28853 | 34 | ||
| 173832 | 188288 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 106 Langton St | 4 | : | Tree | Private 2 | 3 | Width 3ft | 6010227.812 | 2110667.04277 | 37.7760662630739 | -122.408111100563 | (37.7760662630739, -122.408111100563) | 8 | 2 | 9 | 28853 | 34 | |||
| 186653 | 43895 | Permitted Site 7 | Callistemon viminalis :: Weeping Bottlebrush 60 | 714 Tehama St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/04/2000 12:00:00 AM | Permit Number 43499 | 6009277.55531704 | 2110532.12490079 | 37.7756425583487 | -122.411388770124 | (37.7756425583487, -122.411388770124) | 8 | 2 | 9 | 28853 | 34 | |||
| 186821 | 188286 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 106 Langton St | 2 | : | Tree | Private 2 | 5 | Width 3ft | 6010191.87178 | 2110704.80693 | 37.7761679422383 | -122.408238092013 | (37.7761679422383, -122.408238092013) | 8 | 2 | 9 | 28853 | 34 | |||
| 190004 | 188292 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 40 Sheridan St | 4 | : | Tree | Private 2 | 2 | Width 3ft | 6009353.5292 | 2109489.65006 | 37.772784427403 | -122.411052306329 | (37.772784427403, -122.411052306329) | 8 | 2 | 9 | 28853 | 34 | |||
| 190121 | 188295 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 1582 12th St | 3 | : | Tree | Private 2 | 26 | Width 5ft | 6008148.21893 | 2108881.79172 | 37.7710477268126 | -122.415178587438 | (37.7710477268126, -122.415178587438) | 8 | 2 | 9 | 28853 | 19 | |||
| 192026 | 95843 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 30 Sheridan St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/29/2011 12:00:00 AM | 6 | 3x3 | Permit Number 767866 | 6009338.07268 | 2109475.65364 | 37.7727451297231 | -122.411104783558 | (37.7727451297231, -122.411104783558) | 8 | 2 | 9 | 28853 | 34 |
| 5884 | 44280 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 1588 Newhall St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/27/2001 12:00:00 AM | 7 | Permit Number 43704 | 6014158.82633 | 2095418.03078 | 37.734415072582 | -122.393445153596 | (37.734415072582, -122.393445153596) | 10 | 3 | 8 | 58 | 1 | ||
| 10040 | 188312 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 299 Arkansas St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6012939.88574 | 2105717.83125 | 37.7626283178769 | -122.398381909999 | (37.7626283178769, -122.398381909999) | 14 | 3 | 8 | 28856 | 29 | |||
| 12538 | 38150 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 200 Felton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/04/2017 12:00:00 AM | 3 | 3x5 | Permit Number 780230 | 6010281.37407 | 2093721.85483 | 37.7295415331127 | -122.406731343599 | (37.7295415331127, -122.406731343599) | 10 | 3 | 7 | 309 | 28 |
| 17042 | 116875 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 824 Carolina St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3x3 | 6012413.40755 | 2104121.29509 | 37.7582152402716 | -122.400090692059 | (37.7582152402716, -122.400090692059) | 10 | 3 | 8 | 28856 | 29 | |||
| 18161 | 56725 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 1519 McKinnon Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | 6015793.5491 | 2095580.2933 | 37.7349513047544 | -122.387804649295 | (37.7349513047544, -122.387804649295) | 10 | 3 | 8 | 58 | 1 | ||||
| 18692 | 175790 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 79 Colby St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 11 | Width 6ft | 6008193.10922 | 2093597.69816 | 37.7290835632519 | -122.413941929669 | (37.7290835632519, -122.413941929669) | 9 | 3 | 7 | 309 | 28 | |||
| 19123 | 30366 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 764 Arkansas St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/23/1998 12:00:00 AM | 1 | Permit Number 38805 | 6013019.81503 | 2103473.1005 | 37.756469231694 | -122.397947987108 | (37.756469231694, -122.397947987108) | 10 | 3 | 8 | 28856 | 29 | |
| 19828 | 27132 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 2009 Silver Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/19/2004 12:00:00 AM | 3 | 2X3 | 6012226.68156 | 2095938.36762 | 37.7357362666047 | -122.400161784365 | (37.7357362666047, -122.400161784365) | 10 | 3 | 8 | 58 | 1 | ||
| 20518 | 188347 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 83 Scotia Ave | 1 | : | Tree | Private 2 | 3 | Width 2ft | 6011997.83069 | 2095044.25145 | 37.7332684477844 | -122.400890216316 | (37.7332684477844, -122.400890216316) | 10 | 3 | 8 | 58 | 1 | |||
| 21788 | 26984 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 1381 Silver Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 06/22/1999 12:00:00 AM | 6 | 3X3 | 6009547.85305 | 2094416.1727 | 37.7314069136466 | -122.409316188794 | (37.7314069136466, -122.409316188794) | 9 | 3 | 7 | 309 | 28 | ||
| 22794 | 188356 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 1334 Hudson Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6017138.82287 | 2095616.15283 | 37.7351241988078 | -122.383156012747 | (37.7351241988078, -122.383156012747) | 10 | 3 | 8 | 58 | 1 | |||
| 22864 | 175789 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 1038 Silver Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6007776.24891 | 2093611.02457 | 37.7290967338157 | -122.415383996168 | (37.7290967338157, -122.415383996168) | 9 | 3 | 7 | 309 | 5 | |||
| 23180 | 27013 | Permitted Site 7 | Callistemon viminalis :: Weeping Bottlebrush 60 | 1500 Silver Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/19/2004 12:00:00 AM | 6 | 3X3 | 6010352.81235 | 2094643.09069 | 37.7320750491485 | -122.406549264372 | (37.7320750491485, -122.406549264372) | 10 | 3 | 7 | 309 | 28 | ||
| 25164 | 56716 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 1522 McKinnon Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 6015807.4304 | 2095648.0005 | 37.7351379840188 | -122.387761378928 | (37.7351379840188, -122.387761378928) | 10 | 3 | 8 | 58 | 1 | ||||
| 26486 | 47221 | Permitted Site 7 | Callistemon viminalis :: Weeping Bottlebrush 60 | 102 Colby St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/09/2002 12:00:00 AM | Permit Number 45167 | 6008165.27144692 | 2093507.30784615 | 37.7288338073717 | -122.414031775389 | (37.7288338073717, -122.414031775389) | 9 | 3 | 7 | 309 | 28 | ||
| 26763 | 54426 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 770 Carolina St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/02/1973 12:00:00 AM | 15 | 3x3 | Permit Number 12242 | 6012397.0815 | 2104349.75534 | 37.7588416315494 | -122.400163199892 | (37.7588416315494, -122.400163199892) | 10 | 3 | 8 | 28856 | 29 | |
| 26892 | 56727 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 1531 McKinnon Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | 6015734.3799 | 2095622.8211 | 37.7350647995931 | -122.388012186614 | (37.7350647995931, -122.388012186614) | 10 | 3 | 8 | 58 | 1 | ||||
| 26959 | 10888 | Permitted Site 7 | Callistemon viminalis :: Weeping Bottlebrush 60 | 1270X Hudson Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/21/1996 12:00:00 AM | 6 | 3X4 | 6017265.0162454 | 2095327.7862917 | 37.734339374173 | -122.382699652574 | (37.734339374173, -122.382699652574) | 10 | 3 | 8 | 58 | 1 | ||
| 27137 | 188340 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 2080 Silver Ave | 3 | : | Tree | Private 2 | 6 | Width 2ft | 6012583.47847 | 2096093.49596 | 37.7361821046275 | -122.398939075088 | (37.7361821046275, -122.398939075088) | 10 | 3 | 8 | 58 | 1 | |||
| 27809 | 188319 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 800 Wisconsin St | 2 | : | Tree | Private 2 | 3 | Width 3ft | 6012713.14067 | 2103722.27252 | 37.7571363191045 | -122.39902607101 | (37.7571363191045, -122.39902607101) | 10 | 3 | 8 | 28856 | 29 | |||
| 28325 | 26998 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 1223 Silver Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 06/25/1999 12:00:00 AM | 6 | 3X3 | 6008728.29906 | 2094063.8664 | 37.7303936047791 | -122.412124661535 | (37.7303936047791, -122.412124661535) | 9 | 3 | 7 | 309 | 28 | ||
| 28386 | 49816 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 824 Carolina St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/25/2003 12:00:00 AM | 12 | 3x3 | Permit Number 46737 | 6012410.64537 | 2104168.1082 | 37.7583436247676 | -122.400103532548 | (37.7583436247676, -122.400103532548) | 10 | 3 | 8 | 28856 | 29 |
| 29975 | 175763 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 223 Woolsey St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6011100.65099 | 2092002.25417 | 37.7248656727096 | -122.40377805363 | (37.7248656727096, -122.40377805363) | 10 | 3 | 7 | 309 | 28 | |||
| 30618 | 97004 | Property Tree 8 | Callistemon viminalis :: Weeping Bottlebrush 60 | 195A Kiska Rd | Sidewalk: Property side : Cutout | Tree | Housing Authority 15 | FUF | 6019164.1 | 2093438.1 | 37.7292553954157 | -122.376002845114 | (37.7292553954157, -122.376002845114) | 10 | 3 | 8 | 58 | 1 | |||||
| 31303 | 188306 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 635 Tennessee St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6015455.75158 | 2106081.00048 | 37.7637653298293 | -122.38970572754 | (37.7637653298293, -122.38970572754) | 14 | 3 | 8 | 28856 | 29 | |||
| 32080 | 175788 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 913 Silliman St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6008132.91971 | 2093497.94914 | 37.7288062932694 | -122.414142956056 | (37.7288062932694, -122.414142956056) | 9 | 3 | 7 | 309 | 28 | |||
| 32778 | 47219 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 102 Colby St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/09/2002 12:00:00 AM | 6 | Permit Number 45167 | 6008176.9578 | 2093476.05572 | 37.7287486521041 | -122.413989164793 | (37.7287486521041, -122.413989164793) | 9 | 3 | 7 | 309 | 28 | |
| 32876 | 188339 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 901 Bay Shore Blvd | 1 | : | Tree | Private 2 | 3 | Width 2ft | 6011007.54195 | 2094765.98142 | 37.7324490889606 | -122.404294355303 | (37.7324490889606, -122.404294355303) | 10 | 3 | 8 | 58 | 1 | |||
| 34267 | 188311 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 189 Arkansas St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 4ft | 6012910.01504 | 2106269.57454 | 37.764141618776 | -122.398523940823 | (37.764141618776, -122.398523940823) | 14 | 3 | 8 | 28856 | 29 | |||
| 34401 | 27126 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 2095X Silver Ave | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 06/16/1999 12:00:00 AM | 6 | 3X3 | 6012407.8106259 | 2096047.4553772 | 37.7360458965855 | -122.399543203223 | (37.7360458965855, -122.399543203223) | 10 | 3 | 8 | 58 | 1 | ||
| 34470 | 188309 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 195 Arkansas St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 4ft | 6012912.61356 | 2106204.46931 | 37.763962999013 | -122.398510384468 | (37.763962999013, -122.398510384468) | 14 | 3 | 8 | 28856 | 29 | |||
| 34591 | 251286 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 1299x Hudson Ave | 7 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | Private | 02/09/1998 12:00:00 AM | 3x3 | 6017207 | 2095414 | 37.7345728945406 | -122.38290623346 | (37.7345728945406, -122.38290623346) | 10 | 3 | 8 | 58 | 1 | ||
| 34856 | 188343 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 2055 Silver Ave | 2 | : | Tree | Private 2 | 4 | Width 3ft | 6012604.8118 | 2096159.09388 | 37.7363634115335 | -122.398869919026 | (37.7363634115335, -122.398869919026) | 10 | 3 | 8 | 58 | 1 | |||
| 35110 | 188332 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 288 Missouri St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 2ft | 6013443.088 | 2105758.2954 | 37.7627674420819 | -122.396644338879 | (37.7627674420819, -122.396644338879) | 14 | 3 | 8 | 28856 | 29 | |||
| 37364 | 175787 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 913 Silliman St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6008123.23514 | 2093495.17198 | 37.7287981238093 | -122.414176239965 | (37.7287981238093, -122.414176239965) | 9 | 3 | 7 | 309 | 28 | |||
| 37552 | 101159 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 1490X 19th St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3x3 | 6013387.24003 | 2105243.87751 | 37.7613518552239 | -122.396801432457 | (37.7613518552239, -122.396801432457) | 10 | 3 | 8 | 28856 | 29 | |||
| 37723 | 96932 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 901 Bay Shore Blvd | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 3x3 | 6011002.04218 | 2094782.56307 | 37.7324943113535 | -122.404314536086 | (37.7324943113535, -122.404314536086) | 10 | 3 | 8 | 58 | 1 | |||
| 39556 | 26989 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 1327 Silver Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 06/22/1999 12:00:00 AM | 6 | 3X3 | 6009306.59459 | 2094318.78355 | 37.7311259838562 | -122.410143394801 | (37.7311259838562, -122.410143394801) | 9 | 3 | 7 | 309 | 28 | ||
| 40426 | 47227 | Permitted Site 7 | Callistemon viminalis :: Weeping Bottlebrush 60 | 600 Girard St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/09/2002 12:00:00 AM | Permit Number 45171 | 6011131.84499471 | 2092020.43251585 | 37.7249173292839 | -122.403671497463 | (37.7249173292839, -122.403671497463) | 10 | 3 | 7 | 309 | 28 |
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) );