trees
8,659 rows where qSpecies_id = 11 sorted by TreeID
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
174330 | 100030 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 535@Clay Washington St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 19 | 6012036.24942 | 2117732.62521 | 37.7955677864875 | -122.402352109262 | (37.7955677864875, -122.402352109262) | 3 | 1 | 10 | 28860 | 4 | ||||
188934 | 100054 | Significant Tree 6 | Lophostemon confertus :: Brisbane Box 11 | 401X Tehama St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/12/2015 12:00:00 AM | 3 | 3x3 | Permit Number 773313 | 6011330.4 | 2112435.9 | 37.7809848079497 | -122.404421471201 | (37.7809848079497, -122.404421471201) | 14 | 2 | 9 | 28853 | 34 | |
153818 | 100055 | Significant Tree 6 | Lophostemon confertus :: Brisbane Box 11 | 401X Tehama St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/12/2015 12:00:00 AM | 3 | 3x3 | Permit Number 773313 | 6011330.4 | 2112435.9 | 37.7809848079497 | -122.404421471201 | (37.7809848079497, -122.404421471201) | 14 | 2 | 9 | 28853 | 34 | |
37577 | 100056 | Significant Tree 6 | Lophostemon confertus :: Brisbane Box 11 | 401X Tehama St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/12/2015 12:00:00 AM | 3 | 3x3 | Permit Number 773313 | 6011330.4 | 2112435.9 | 37.7809848079497 | -122.404421471201 | (37.7809848079497, -122.404421471201) | 14 | 2 | 9 | 28853 | 34 | |
102447 | 100059 | Section 143 10 | Lophostemon confertus :: Brisbane Box 11 | 260 05th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/12/2015 12:00:00 AM | 3 | 3x3 | Permit Number 773313 | 6011435 | 2112345 | 37.7807410625565 | -122.404053207068 | (37.7807410625565, -122.404053207068) | 14 | 2 | 9 | 28853 | 34 | |
26043 | 100060 | Section 143 10 | Lophostemon confertus :: Brisbane Box 11 | 260 05th St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/12/2015 12:00:00 AM | 3 | 3x3 | Permit Number 773313 | 6011435 | 2112345 | 37.7807410625565 | -122.404053207068 | (37.7807410625565, -122.404053207068) | 14 | 2 | 9 | 28853 | 34 | |
133534 | 100066 | Undocumented 4 | Lophostemon confertus :: Brisbane Box 11 | 93 Buena Vista Ter | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/29/2012 12:00:00 AM | 2x2 | Permit Number 768610 | 6001505.1 | 2107681.4 | 37.7673761743712 | -122.438071302911 | (37.7673761743712, -122.438071302911) | 15 | 5 | 5 | 29492 | 3 | ||
170162 | 100080 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 701X POLK ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/18/2015 12:00:00 AM | 3 | 3x3 | Permit Number 774752 | 6007001 | 2113322 | 37.7831749319814 | -122.419461922492 | (37.7831749319814, -122.419461922492) | 7 | 9 | 9 | 28858 | 36 | |
61684 | 100109 | Undocumented 4 | Lophostemon confertus :: Brisbane Box 11 | 333 Jefferson St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6007662 | 2121967 | 37.8069491634687 | -122.417788103441 | (37.8069491634687, -122.417788103441) | 5 | 1 | 10 | 308 | 23 | |||||
67964 | 100110 | Undocumented 4 | Lophostemon confertus :: Brisbane Box 11 | 333 Jefferson St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6007662 | 2121967 | 37.8069491634687 | -122.417788103441 | (37.8069491634687, -122.417788103441) | 5 | 1 | 10 | 308 | 23 | |||||
81579 | 100111 | Undocumented 4 | Lophostemon confertus :: Brisbane Box 11 | 333 Jefferson St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6007662 | 2121967 | 37.8069491634687 | -122.417788103441 | (37.8069491634687, -122.417788103441) | 5 | 1 | 10 | 308 | 23 | |||||
97575 | 100112 | Undocumented 4 | Lophostemon confertus :: Brisbane Box 11 | 333 Jefferson St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6007662 | 2121967 | 37.8069491634687 | -122.417788103441 | (37.8069491634687, -122.417788103441) | 5 | 1 | 10 | 308 | 23 | |||||
67021 | 100113 | Undocumented 4 | Lophostemon confertus :: Brisbane Box 11 | 333 Jefferson St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6007662 | 2121967 | 37.8069491634687 | -122.417788103441 | (37.8069491634687, -122.417788103441) | 5 | 1 | 10 | 308 | 23 | |||||
51202 | 100114 | Undocumented 4 | Lophostemon confertus :: Brisbane Box 11 | 333 Jefferson St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6007662 | 2121967 | 37.8069491634687 | -122.417788103441 | (37.8069491634687, -122.417788103441) | 5 | 1 | 10 | 308 | 23 | |||||
135501 | 100115 | Undocumented 4 | Lophostemon confertus :: Brisbane Box 11 | 333 Jefferson St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6007662 | 2121967 | 37.8069491634687 | -122.417788103441 | (37.8069491634687, -122.417788103441) | 5 | 1 | 10 | 308 | 23 | |||||
149669 | 100116 | Undocumented 4 | Lophostemon confertus :: Brisbane Box 11 | 333 Jefferson St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6007662 | 2121967 | 37.8069491634687 | -122.417788103441 | (37.8069491634687, -122.417788103441) | 5 | 1 | 10 | 308 | 23 | |||||
93715 | 100117 | Undocumented 4 | Lophostemon confertus :: Brisbane Box 11 | 333 Jefferson St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6007662 | 2121967 | 37.8069491634687 | -122.417788103441 | (37.8069491634687, -122.417788103441) | 5 | 1 | 10 | 308 | 23 | |||||
181201 | 100118 | Undocumented 4 | Lophostemon confertus :: Brisbane Box 11 | 333 Jefferson St | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6007662 | 2121967 | 37.8069491634687 | -122.417788103441 | (37.8069491634687, -122.417788103441) | 5 | 1 | 10 | 308 | 23 | |||||
68742 | 100119 | Undocumented 4 | Lophostemon confertus :: Brisbane Box 11 | 333 Jefferson St | 11 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6007662 | 2121967 | 37.8069491634687 | -122.417788103441 | (37.8069491634687, -122.417788103441) | 5 | 1 | 10 | 308 | 23 | |||||
162104 | 100120 | Undocumented 4 | Lophostemon confertus :: Brisbane Box 11 | 333 Jefferson St | 12 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6007662 | 2121967 | 37.8069491634687 | -122.417788103441 | (37.8069491634687, -122.417788103441) | 5 | 1 | 10 | 308 | 23 | |||||
148324 | 100175 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 1140 Page St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/12/2012 12:00:00 AM | 3x3 | Permit Number 768230 | 6001099 | 2109378.2 | 37.772012061027 | -122.439597598173 | (37.772012061027, -122.439597598173) | 15 | 5 | 11 | 29492 | 9 | ||
41895 | 100296 | Undocumented 4 | Lophostemon confertus :: Brisbane Box 11 | 1494 07th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4.5x5 | 5994028.4 | 2105353.7 | 37.7605568782163 | -122.463763003523 | (37.7605568782163, -122.463763003523) | 1 | 5 | 11 | 56 | 12 | ||||
78603 | 100298 | Undocumented 4 | Lophostemon confertus :: Brisbane Box 11 | 250 Kirkham St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6x6 | 5994135.4 | 2105324.6 | 37.7604831423825 | -122.463390830401 | (37.7604831423825, -122.463390830401) | 1 | 5 | 11 | 56 | 12 | ||||
126879 | 100300 | Undocumented 4 | Lophostemon confertus :: Brisbane Box 11 | 250 Kirkham St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6x6 | 5994135.4 | 2105324.6 | 37.7604831423825 | -122.463390830401 | (37.7604831423825, -122.463390830401) | 1 | 5 | 11 | 56 | 12 | ||||
49853 | 100301 | Undocumented 4 | Lophostemon confertus :: Brisbane Box 11 | 250 Kirkham St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6x6 | 5994135.4 | 2105324.6 | 37.7604831423825 | -122.463390830401 | (37.7604831423825, -122.463390830401) | 1 | 5 | 11 | 56 | 12 | ||||
36629 | 100302 | Undocumented 4 | Lophostemon confertus :: Brisbane Box 11 | 250 Kirkham St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6x6 | 5994135.4 | 2105324.6 | 37.7604831423825 | -122.463390830401 | (37.7604831423825, -122.463390830401) | 1 | 5 | 11 | 56 | 12 | ||||
93347 | 100304 | Undocumented 4 | Lophostemon confertus :: Brisbane Box 11 | 250 Kirkham St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6x6 | 5994135.4 | 2105324.6 | 37.7604831423825 | -122.463390830401 | (37.7604831423825, -122.463390830401) | 1 | 5 | 11 | 56 | 12 | ||||
113844 | 100338 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 1190 Mission St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/06/2012 12:00:00 AM | 3 | 3x3 | Permit Number 767726 | 6008923.44106 | 2111377.62388 | 37.7779442309909 | -122.412673527688 | (37.7779442309909, -122.412673527688) | 8 | 2 | 9 | 28853 | 34 | |
127976 | 100339 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 1190 Mission St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/06/2012 12:00:00 AM | 2 | 3x3 | Permit Number 767726 | 6008905.6037 | 2111360.20225 | 37.7778953941811 | -122.412734001686 | (37.7778953941811, -122.412734001686) | 8 | 2 | 9 | 28853 | 34 | |
120206 | 100340 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 1190 Mission St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/06/2012 12:00:00 AM | 3 | 3x3 | Permit Number 767726 | 6008888.95993 | 2111345.40532 | 37.7778538311389 | -122.412790532155 | (37.7778538311389, -122.412790532155) | 8 | 2 | 9 | 28853 | 34 | |
71096 | 100341 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 1190 Mission St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/06/2012 12:00:00 AM | 4 | 3x3 | Permit Number 767726 | 6008871.11478 | 2111327.60525 | 37.7778039547246 | -122.412851006189 | (37.7778039547246, -122.412851006189) | 8 | 2 | 9 | 28853 | 34 | |
21072 | 100342 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 1190 Mission St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/06/2012 12:00:00 AM | 4 | 3x3 | Permit Number 767726 | 6008841.69587 | 2111301.33767 | 37.7777301788357 | -122.412950919067 | (37.7777301788357, -122.412950919067) | 8 | 2 | 9 | 28853 | 34 | |
140616 | 100343 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 1190 Mission St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/06/2012 12:00:00 AM | 3 | 3x3 | Permit Number 767726 | 6008825.45514 | 2111287.66775 | 37.7776917328153 | -122.413006134737 | (37.7776917328153, -122.413006134737) | 8 | 2 | 9 | 28853 | 34 | |
122471 | 100344 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 1190 Mission St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/06/2012 12:00:00 AM | 4 | 3x3 | Permit Number 767726 | 6008816.06754 | 2111274.61433 | 37.7776553642406 | -122.413037686564 | (37.7776553642406, -122.413037686564) | 8 | 2 | 9 | 28853 | 34 | |
142425 | 100585 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 270x 05th St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 6011529.62988 | 2112216.22494 | 37.7803927629535 | -122.403716771135 | (37.7803927629535, -122.403716771135) | 14 | 2 | 9 | 28853 | 34 | ||||
185224 | 100627 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 270X 05th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 6011410.5 | 2112131.8 | 37.7801542961347 | -122.404122955966 | (37.7801542961347, -122.404122955966) | 14 | 2 | 9 | 28853 | 34 | ||||
36732 | 100628 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 270X 05th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 6011410.5 | 2112131.8 | 37.7801542961347 | -122.404122955966 | (37.7801542961347, -122.404122955966) | 14 | 2 | 9 | 28853 | 34 | ||||
130971 | 100629 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 270X 05th St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 6011502.95528 | 2112245.6234 | 37.7804719941376 | -122.403811120803 | (37.7804719941376, -122.403811120803) | 14 | 2 | 9 | 28853 | 34 | ||||
50659 | 10074 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 589 Guerrero St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/09/1990 12:00:00 AM | 12 | 2X2 | 6005613.39136 | 2105612.3018 | 37.7619277055082 | -122.423714143811 | (37.7619277055082, -122.423714143811) | 8 | 4 | 5 | 28859 | 19 | ||
74315 | 100752 | Undocumented 4 | Lophostemon confertus :: Brisbane Box 11 | 700X Brannan St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | 3x3 | 6012260.07583 | 2110177.24035 | 37.7748349572731 | -122.401046493351 | (37.7748349572731, -122.401046493351) | 14 | 2 | 9 | 28853 | 34 | |||
126046 | 100753 | Undocumented 4 | Lophostemon confertus :: Brisbane Box 11 | 700X Brannan St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | 3x3 | 6012260.07583 | 2110177.24035 | 37.7748349572731 | -122.401046493351 | (37.7748349572731, -122.401046493351) | 14 | 2 | 9 | 28853 | 34 | |||
184122 | 100754 | Undocumented 4 | Lophostemon confertus :: Brisbane Box 11 | 700X Brannan St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | 3x3 | 6012260.07583 | 2110177.24035 | 37.7748349572731 | -122.401046493351 | (37.7748349572731, -122.401046493351) | 14 | 2 | 9 | 28853 | 34 | |||
121450 | 100755 | Undocumented 4 | Lophostemon confertus :: Brisbane Box 11 | 700X Brannan St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | 3x3 | 6012260.07583 | 2110177.24035 | 37.7748349572731 | -122.401046493351 | (37.7748349572731, -122.401046493351) | 14 | 2 | 9 | 28853 | 34 | |||
52913 | 100756 | Undocumented 4 | Lophostemon confertus :: Brisbane Box 11 | 700X Brannan St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | 3x3 | 6012260.07583 | 2110177.24035 | 37.7748349572731 | -122.401046493351 | (37.7748349572731, -122.401046493351) | 14 | 2 | 9 | 28853 | 34 | |||
45330 | 100757 | Undocumented 4 | Lophostemon confertus :: Brisbane Box 11 | 700X Brannan St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | 3x3 | 6012260.07583 | 2110177.24035 | 37.7748349572731 | -122.401046493351 | (37.7748349572731, -122.401046493351) | 14 | 2 | 9 | 28853 | 34 | |||
4689 | 100758 | Undocumented 4 | Lophostemon confertus :: Brisbane Box 11 | 700X Brannan St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | 3x3 | 6012260.07583 | 2110177.24035 | 37.7748349572731 | -122.401046493351 | (37.7748349572731, -122.401046493351) | 14 | 2 | 9 | 28853 | 34 | |||
61492 | 100911 | Undocumented 4 | Lophostemon confertus :: Brisbane Box 11 | 1400x 15th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3x3 | 6007975 | 2107432 | 37.7670572023826 | -122.415675090491 | (37.7670572023826, -122.415675090491) | 8 | 4 | 7 | 28853 | 19 | |||
35956 | 10103 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 780 Guerrero St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/11/1994 12:00:00 AM | 15 | 2x2 | 6005610.10153 | 2104443.54178 | 37.7587183794707 | -122.423642421088 | (37.7587183794707, -122.423642421088) | 2 | 4 | 5 | 28859 | 19 | ||
104286 | 10104 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 780 Guerrero St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/11/1994 12:00:00 AM | 13 | 3x5 | 6005610.43928 | 2104403.21485 | 37.758607670231 | -122.423638385804 | (37.758607670231, -122.423638385804) | 2 | 4 | 5 | 28859 | 19 | ||
119561 | 101064 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 380X Beacon St | 2 | Median : Cutout | Tree | DPW 1 | 3 | 3x3 | 6002433 | 2098186.8 | 37.7413589965156 | -122.434182997537 | (37.7413589965156, -122.434182997537) | 2 | 7 | 5 | 63 | 7 | |||
40548 | 101065 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 380X Beacon St | 1 | Median : Cutout | Tree | DPW 1 | 3 | 3x3 | 6002433 | 2098186.8 | 37.7413589965156 | -122.434182997537 | (37.7413589965156, -122.434182997537) | 2 | 7 | 5 | 63 | 7 | |||
138225 | 101082 | Undocumented 4 | Lophostemon confertus :: Brisbane Box 11 | 1699X Tennessee St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | 3x3 | 6015823 | 2101385 | 37.7508914678049 | -122.388107781388 | (37.7508914678049, -122.388107781388) | 10 | 3 | 8 | 28856 | 1 | |||
172696 | 101083 | Undocumented 4 | Lophostemon confertus :: Brisbane Box 11 | 1699X Tennessee St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | 3x3 | 6015823 | 2101385 | 37.7508914678049 | -122.388107781388 | (37.7508914678049, -122.388107781388) | 10 | 3 | 8 | 28856 | 1 | |||
176781 | 101239 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 3000X Divisadero St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/21/2014 12:00:00 AM | 2 | 3x3 | Permit Number 771215 | 6000530.94903 | 2118615.77604 | 37.7973437154854 | -122.442225767212 | (37.7973437154854, -122.442225767212) | 13 | 9 | 1 | 57 | 17 | |
94795 | 101248 | Undocumented 4 | Lophostemon confertus :: Brisbane Box 11 | 634 IRVING ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | 3x3 | 5993713.5 | 2106706.6 | 37.7642534373973 | -122.464950347427 | (37.7642534373973, -122.464950347427) | 11 | 8 | 11 | 56 | 12 | |||
125985 | 101312 | Undocumented 4 | Lophostemon confertus :: Brisbane Box 11 | 4244X 19th St | 5 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 12 | 4x4 | 6001912 | 2104709 | 37.7592378221466 | -122.436451128899 | (37.7592378221466, -122.436451128899) | 2 | 4 | 5 | 28862 | 3 | |||
9424 | 101331 | Undocumented 4 | Lophostemon confertus :: Brisbane Box 11 | 15X Kittredge Ter | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | 3x3 | 5997920.7 | 2111591.6 | 37.7779080793099 | -122.450751145765 | (37.7779080793099, -122.450751145765) | 15 | 6 | 2 | 54 | 16 | |||
58458 | 101332 | Undocumented 4 | Lophostemon confertus :: Brisbane Box 11 | 15X Kittredge Ter | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 24 | 3x3 | 5997920.7 | 2111591.6 | 37.7779080793099 | -122.450751145765 | (37.7779080793099, -122.450751145765) | 15 | 6 | 2 | 54 | 16 | |||
84930 | 101363 | Undocumented 4 | Lophostemon confertus :: Brisbane Box 11 | 394 Broadway | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6011665.4 | 2118805.7 | 37.7984934826399 | -122.40371086132 | (37.7984934826399, -122.40371086132) | 3 | 1 | 10 | 308 | 23 | ||||
176349 | 101364 | Undocumented 4 | Lophostemon confertus :: Brisbane Box 11 | 394 Broadway | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6011665.4 | 2118805.7 | 37.7984934826399 | -122.40371086132 | (37.7984934826399, -122.40371086132) | 3 | 1 | 10 | 308 | 23 | ||||
108265 | 101365 | Undocumented 4 | Lophostemon confertus :: Brisbane Box 11 | 394 Broadway | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6011665.4 | 2118805.7 | 37.7984934826399 | -122.40371086132 | (37.7984934826399, -122.40371086132) | 3 | 1 | 10 | 308 | 23 | ||||
186528 | 101387 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 1777 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 3x3 | 6001446.8 | 2091921.2 | 37.7240990805525 | -122.437144428251 | (37.7240990805525, -122.437144428251) | 9 | 7 | 6 | 28861 | 25 | |||
46331 | 101388 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 1777 Alemany Blvd | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 3x3 | 6001446.8 | 2091921.2 | 37.7240990805525 | -122.437144428251 | (37.7240990805525, -122.437144428251) | 9 | 7 | 6 | 28861 | 25 | |||
159029 | 101389 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 1777 Alemany Blvd | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 3x3 | 6001446.8 | 2091921.2 | 37.7240990805525 | -122.437144428251 | (37.7240990805525, -122.437144428251) | 9 | 7 | 6 | 28861 | 25 | |||
168379 | 101390 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 1777 Alemany Blvd | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 3x3 | 6001446.8 | 2091921.2 | 37.7240990805525 | -122.437144428251 | (37.7240990805525, -122.437144428251) | 9 | 7 | 6 | 28861 | 25 | |||
94293 | 101452 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 102 Henry Adams St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | 3x3 | 6011366.43435 | 2107858.17309 | 37.7684174373453 | -122.40397456987 | (37.7684174373453, -122.40397456987) | 8 | 2 | 8 | 28853 | 20 | |||
182013 | 101453 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 102 Henry Adams St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | 3x3 | 6011366.28419 | 2107838.89709 | 37.7683645014365 | -122.403973732597 | (37.7683645014365, -122.403973732597) | 8 | 2 | 8 | 28853 | 20 | |||
142030 | 101454 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 102 Henry Adams St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | 3x3 | Permit Number 769522 | 6011366.60789 | 2107819.12966 | 37.7683102426466 | -122.403971221693 | (37.7683102426466, -122.403971221693) | 8 | 2 | 8 | 28853 | 20 | ||
94980 | 101456 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 102 Henry Adams St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | 3x3 | 6011371.03407 | 2107798.79663 | 37.7682546600511 | -122.40395448083 | (37.7682546600511, -122.40395448083) | 8 | 2 | 8 | 28853 | 20 | |||
76470 | 101458 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 102 Henry Adams St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | 3x3 | 6011372.13626 | 2107757.80647 | 37.768142171953 | -122.403947783556 | (37.768142171953, -122.403947783556) | 8 | 2 | 8 | 28853 | 20 | |||
84834 | 101459 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 102 Henry Adams St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | 3x3 | 6011371.6069 | 2107731.79075 | 37.7680707091139 | -122.403947783585 | (37.7680707091139, -122.403947783585) | 8 | 2 | 8 | 28853 | 20 | |||
121433 | 101460 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 102 Henry Adams St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | 3x3 | 6011373.59931 | 2107710.78439 | 37.7680131417293 | -122.403939413597 | (37.7680131417293, -122.403939413597) | 8 | 2 | 8 | 28853 | 20 | |||
49444 | 101461 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 102 Henry Adams St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | 3x3 | 6011374.44126 | 2107692.69319 | 37.7679635144368 | -122.403935228122 | (37.7679635144368, -122.403935228122) | 8 | 2 | 8 | 28853 | 20 | |||
22019 | 101462 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 102 Henry Adams St | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | 3x3 | 6011376.9421 | 2107672.88146 | 37.7679092556385 | -122.403925183621 | (37.7679092556385, -122.403925183621) | 8 | 2 | 8 | 28853 | 20 | |||
190877 | 101463 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 102 Henry Adams St | 11 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | 3x3 | 6011376.92788 | 2107636.49255 | 37.767809339149 | -122.403922671802 | (37.767809339149, -122.403922671802) | 8 | 2 | 8 | 28853 | 20 | |||
60905 | 101464 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 102 Henry Adams St | 12 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | 3x3 | 6011378.39742 | 2107613.56866 | 37.7677464774454 | -122.403915975464 | (37.7677464774454, -122.403915975464) | 8 | 2 | 8 | 28853 | 20 | |||
50103 | 101465 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 102 Henry Adams St | 13 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | 3x3 | 6011381.48513 | 2107598.80565 | 37.7677061140714 | -122.403904256402 | (37.7677061140714, -122.403904256402) | 8 | 2 | 8 | 28853 | 20 | |||
17005 | 101474 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 541 Congo St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/04/2016 12:00:00 AM | Permit Number 775316 | 6000089 | 2095440.1 | 37.7336838892166 | -122.442090592963 | (37.7336838892166, -122.442090592963) | 9 | 7 | 4 | 63 | 40 | |||
135013 | 101475 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 541 Congo St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/04/2016 12:00:00 AM | Permit Number 775316 | 6000089 | 2095440.1 | 37.7336838892166 | -122.442090592963 | (37.7336838892166, -122.442090592963) | 9 | 7 | 4 | 63 | 40 | |||
99357 | 101483 | Undocumented 4 | Lophostemon confertus :: Brisbane Box 11 | 1805X Alameda St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | 3x3 | 6011653.3 | 2107915 | 37.7685894941919 | -122.402986319314 | (37.7685894941919, -122.402986319314) | 8 | 2 | 8 | 28853 | 20 | |||
186797 | 101484 | Undocumented 4 | Lophostemon confertus :: Brisbane Box 11 | 1805X Alameda St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | 3x3 | 6011653.3 | 2107915 | 37.7685894941919 | -122.402986319314 | (37.7685894941919, -122.402986319314) | 8 | 2 | 8 | 28853 | 20 | |||
186796 | 101485 | Undocumented 4 | Lophostemon confertus :: Brisbane Box 11 | 1805X Alameda St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | 3x3 | 6011653.3 | 2107915 | 37.7685894941919 | -122.402986319314 | (37.7685894941919, -122.402986319314) | 8 | 2 | 8 | 28853 | 20 | |||
69396 | 101486 | Undocumented 4 | Lophostemon confertus :: Brisbane Box 11 | 1805X Alameda St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | 3x3 | 6011653.3 | 2107915 | 37.7685894941919 | -122.402986319314 | (37.7685894941919, -122.402986319314) | 8 | 2 | 8 | 28853 | 20 | |||
63123 | 101487 | Undocumented 4 | Lophostemon confertus :: Brisbane Box 11 | 1805X Alameda St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | 3x3 | 6011653.3 | 2107915 | 37.7685894941919 | -122.402986319314 | (37.7685894941919, -122.402986319314) | 8 | 2 | 8 | 28853 | 20 | |||
133846 | 101488 | Undocumented 4 | Lophostemon confertus :: Brisbane Box 11 | 1805X Alameda St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | 3x3 | 6011653.3 | 2107915 | 37.7685894941919 | -122.402986319314 | (37.7685894941919, -122.402986319314) | 8 | 2 | 8 | 28853 | 20 | |||
77489 | 10156 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 998 Guerrero St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 8 | 3x3 | 6005679.7391 | 2103202.59116 | 37.7553149491356 | -122.423313367215 | (37.7553149491356, -122.423313367215) | 2 | 4 | 5 | 28859 | 19 | |||
127842 | 1016 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 1856 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/06/1997 12:00:00 AM | 12 | 3x3 | 6001112.04322 | 2091350.8843 | 37.7225140885303 | -122.438260791209 | (37.7225140885303, -122.438260791209) | 9 | 7 | 6 | 28861 | 25 | ||
60119 | 101620 | Undocumented 4 | Lophostemon confertus :: Brisbane Box 11 | 32 Church St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | 3x2 | 6004057 | 2108606 | 37.7700596990804 | -122.429310574863 | (37.7700596990804, -122.429310574863) | 7 | 9 | 5 | 29492 | 10 | |||
39176 | 101744 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 1000 Montgomery St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 25770 | 6011635 | 2118713 | 37.7982372525996 | -122.403809528937 | (37.7982372525996, -122.403809528937) | 3 | 1 | 10 | 308 | 23 | ||||
162454 | 101745 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 1000 Montgomery St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 25770 | 6011635 | 2118713 | 37.7982372525996 | -122.403809528937 | (37.7982372525996, -122.403809528937) | 3 | 1 | 10 | 308 | 23 | ||||
153882 | 101746 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 1000 Montgomery St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 25770 | 6011635 | 2118713 | 37.7982372525996 | -122.403809528937 | (37.7982372525996, -122.403809528937) | 3 | 1 | 10 | 308 | 23 | ||||
16366 | 101747 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 1000 Montgomery St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 25770 | 6011635 | 2118713 | 37.7982372525996 | -122.403809528937 | (37.7982372525996, -122.403809528937) | 3 | 1 | 10 | 308 | 23 | ||||
38877 | 101808 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 3149 26th St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW for City Agency 14 | 02/03/2015 12:00:00 AM | 3 | 3x3 | 6008718.2 | 2100791.7 | 37.7488661984732 | -122.412634998086 | (37.7488661984732, -122.412634998086) | 2 | 4 | 7 | 28859 | 19 | ||
153187 | 101876 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 150X Moulton St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | 3x3 | Permit Number 48902 | 6002586 | 2119386 | 37.7995754568509 | -122.435169891098 | (37.7995754568509, -122.435169891098) | 13 | 9 | 1 | 57 | 17 | ||
119495 | 101877 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 150X Moulton St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | 3x3 | Permit Number 48902 | 6002592.4 | 2119429.3 | 37.7996947107598 | -122.435150843512 | (37.7996947107598, -122.435150843512) | 13 | 9 | 1 | 57 | 17 | ||
143528 | 101879 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 150X Moulton St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | 3x3 | Permit Number 48902 | 6002592.4 | 2119429.3 | 37.7996947107598 | -122.435150843512 | (37.7996947107598, -122.435150843512) | 13 | 9 | 1 | 57 | 17 | ||
130542 | 101995 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 501X Folsom St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6014257 | 2114662 | 37.7872602812755 | -122.394452755334 | (37.7872602812755, -122.394452755334) | 6 | 2 | 9 | 28855 | 6 | ||||
103764 | 101996 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 501X Folsom St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6014257 | 2114662 | 37.7872602812755 | -122.394452755334 | (37.7872602812755, -122.394452755334) | 6 | 2 | 9 | 28855 | 6 | ||||
27920 | 101997 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 501X Folsom St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6014257 | 2114662 | 37.7872602812755 | -122.394452755334 | (37.7872602812755, -122.394452755334) | 6 | 2 | 9 | 28855 | 6 | ||||
139639 | 101998 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 501X Folsom St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6014257 | 2114662 | 37.7872602812755 | -122.394452755334 | (37.7872602812755, -122.394452755334) | 6 | 2 | 9 | 28855 | 6 |
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) );