trees
8,758 rows where qSpecies_id = 16 sorted by TreeID descending
This data as json, CSV (advanced)
rowid | TreeID ▲ | qLegalStatus_id | qSpecies_id | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker_id | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location | Fire Prevention Districts | Police Districts | Supervisor Districts | Zip Codes | Neighborhoods (old) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
151556 | 97744 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 2685 30th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 18001 | 5986960.2 | 2097027.9 | 37.7372866359421 | -122.487596715706 | (37.7372866359421, -122.487596715706) | 1 | 8 | 3 | 29491 | 35 | ||||
184931 | 97734 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1150 Francisco St | 13 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 5 | 3x3 | Permit Number 50638 | 6005715.83773 | 2120693.51258 | 37.8033427825912 | -122.424432563629 | (37.8033427825912, -122.424432563629) | 5 | 9 | 1 | 28858 | 32 | |
156701 | 97732 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1150 Francisco St | 11 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 5 | 3x3 | Permit Number 50638 | 6005757.30775 | 2120698.05289 | 37.8033575908394 | -122.424289378073 | (37.8033575908394, -122.424289378073) | 5 | 9 | 1 | 28858 | 32 | |
65139 | 97730 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1150 Francisco St | 8 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 6 | 3x3 | Permit Number 50638 | 6005803.34745 | 2120703.57786 | 37.8033753605476 | -122.424130448959 | (37.8033753605476, -122.424130448959) | 5 | 9 | 1 | 28858 | 32 | |
175602 | 97728 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1150 Francisco St | 6 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 5 | 3x3 | Permit Number 50638 | 6005878.13407 | 2120716.4935 | 37.8034150458325 | -122.423872565669 | (37.8034150458325, -122.423872565669) | 5 | 9 | 1 | 28858 | 32 | |
61400 | 97649 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 2457 Noriega St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3x3 | 5986329.2204 | 2102960.2941 | 37.7535385746319 | -122.490214527777 | (37.7535385746319, -122.490214527777) | 1 | 8 | 3 | 56 | 35 | |||
39038 | 97647 | Undocumented 4 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1844 Noriega St | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5988207.7 | 2103154.5 | 37.7541813368782 | -122.483732655057 | (37.7541813368782, -122.483732655057) | 1 | 8 | 3 | 56 | 35 | |||||
29139 | 97646 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1824 Noriega St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 4x4 | 5988290 | 2103126 | 37.7541078738982 | -122.483445955619 | (37.7541078738982, -122.483445955619) | 1 | 8 | 3 | 56 | 35 | |||
33854 | 97645 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1750 Noriega St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 4x4 | 5988496.9003 | 2103110.255 | 37.7540766821623 | -122.482729298816 | (37.7540766821623, -122.482729298816) | 1 | 8 | 3 | 56 | 35 | |||
56116 | 97644 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1750 Noriega St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | 4x4 | 5988522.0861 | 2103110.8025 | 37.7540796507491 | -122.482642241384 | (37.7540796507491, -122.482642241384) | 1 | 8 | 3 | 56 | 35 | |||
53523 | 97641 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1641 Noriega St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | 5988864.7432 | 2103046.835 | 37.7539239423437 | -122.481452579626 | (37.7539239423437, -122.481452579626) | 1 | 8 | 3 | 56 | 35 | ||||
27167 | 97639 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1322 Noriega St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | 3x3 | 5989849.0459 | 2103149.6081 | 37.7542633115371 | -122.478056180043 | (37.7542633115371, -122.478056180043) | 1 | 8 | 3 | 56 | 35 | |||
38143 | 97575 | Undocumented 4 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 501x Presidio Ave | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5999116.8 | 2114959.9 | 37.7872249510267 | -122.4468558657 | (37.7872249510267, -122.4468558657) | 15 | 6 | 1 | 54 | 31 | |||||
8762 | 97574 | Undocumented 4 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 501x Presidio Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5999116.8 | 2114959.9 | 37.7872249510267 | -122.4468558657 | (37.7872249510267, -122.4468558657) | 15 | 6 | 1 | 54 | 31 | |||||
145367 | 97573 | Undocumented 4 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 501X Presidio Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5999116.8 | 2114959.9 | 37.7872249510267 | -122.4468558657 | (37.7872249510267, -122.4468558657) | 15 | 6 | 1 | 54 | 31 | |||||
97474 | 97572 | Undocumented 4 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 501x Presidio Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5999116.8 | 2114959.9 | 37.7872249510267 | -122.4468558657 | (37.7872249510267, -122.4468558657) | 15 | 6 | 1 | 54 | 31 | |||||
120780 | 97571 | Undocumented 4 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 501x Presidio Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5999116.8 | 2114959.9 | 37.7872249510267 | -122.4468558657 | (37.7872249510267, -122.4468558657) | 15 | 6 | 1 | 54 | 31 | |||||
17658 | 97424 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1431 44th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | 3x3 | 5982447.118 | 2105345.6921 | 37.7598607224916 | -122.503816109052 | (37.7598607224916, -122.503816109052) | 1 | 8 | 3 | 56 | 35 | |||
142551 | 97423 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1431 44th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | 3x3 | 5982447.5194 | 2105362.951 | 37.7599081341288 | -122.50381599907 | (37.7599081341288, -122.50381599907) | 1 | 8 | 3 | 56 | 35 | |||
102117 | 97324 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1033 Taraval St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/23/2016 12:00:00 AM | 3 | 3x3 | Permit Number 777184 | 5990033 | 2099023 | 37.7429434037475 | -122.477118493804 | (37.7429434037475, -122.477118493804) | 1 | 8 | 3 | 29491 | 35 | |
179433 | 97309 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 870 Taraval St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5990545 | 2099071 | 37.7431048903998 | -122.475351661114 | (37.7431048903998, -122.475351661114) | 1 | 8 | 4 | 29491 | 40 | ||||
130586 | 97296 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 513 Parnassus Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5995614.6 | 2106503.7 | 37.7638057586808 | -122.458360338276 | (37.7638057586808, -122.458360338276) | 15 | 5 | 11 | 56 | 12 | ||||
30748 | 97294 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 513 Parnassus Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5995614.6 | 2106503.7 | 37.7638057586808 | -122.458360338276 | (37.7638057586808, -122.458360338276) | 15 | 5 | 11 | 56 | 12 | ||||
160346 | 97112 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1345 Noriega St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Permit Number 18860 | 5989771.682 | 2103084.5073 | 37.7540800712347 | -122.478318961027 | (37.7540800712347, -122.478318961027) | 1 | 8 | 3 | 56 | 35 | |||
184809 | 96877 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 620 Palmetto Ave | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | 3x3 | 5991825.84937 | 2087243.04288 | 37.7107024170406 | -122.47006180623 | (37.7107024170406, -122.47006180623) | 9 | 8 | 4 | 64 | 24 | |||
44394 | 96864 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 620 Palmetto Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | 2x2 | 5991921.11564 | 2087237.00736 | 37.7106913517985 | -122.469732108476 | (37.7106913517985, -122.469732108476) | 9 | 8 | 4 | 64 | 24 | |||
156832 | 96859 | Undocumented 4 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 530 Clipper St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 32 | 6x7 | 6001747 | 2100899 | 37.748767099488 | -122.436749043954 | (37.748767099488, -122.436749043954) | 2 | 4 | 5 | 28862 | 22 | |||
29068 | 96858 | Undocumented 4 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 530 Clipper St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | 6x7 | 6001747 | 2100899 | 37.748767099488 | -122.436749043954 | (37.748767099488, -122.436749043954) | 2 | 4 | 5 | 28862 | 22 | |||
177155 | 96857 | Undocumented 4 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 530 Clipper St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 6x7 | 6001747 | 2100899 | 37.748767099488 | -122.436749043954 | (37.748767099488, -122.436749043954) | 2 | 4 | 5 | 28862 | 22 | |||
154783 | 96838 | Undocumented 4 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 196 Bradford St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | 3x3 | 6009513 | 2097465 | 37.7397763850106 | -122.409651795241 | (37.7397763850106, -122.409651795241) | 10 | 7 | 7 | 28859 | 2 | |||
83605 | 96746 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 2080X 20th Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | 3x3 | 5990085.5252 | 2101224.1284 | 37.7489901752151 | -122.477097689647 | (37.7489901752151, -122.477097689647) | 1 | 8 | 3 | 29491 | 35 | |||
108136 | 96745 | Undocumented 4 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 2080X 20th Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3x3 | 5990081.6 | 2101220.2 | 37.7489791611356 | -122.477110975835 | (37.7489791611356, -122.477110975835) | 1 | 8 | 3 | 29491 | 35 | |||
156191 | 96744 | Undocumented 4 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 2080X 20th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | 3x6 | 5990081.6 | 2101220.2 | 37.7489791611356 | -122.477110975835 | (37.7489791611356, -122.477110975835) | 1 | 8 | 3 | 29491 | 35 | |||
57370 | 96743 | Undocumented 4 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 2080X 20th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3x3 | 5990081.6 | 2101220.2 | 37.7489791611356 | -122.477110975835 | (37.7489791611356, -122.477110975835) | 1 | 8 | 3 | 29491 | 35 | |||
190607 | 96742 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1090 Quintara St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | 4x4 | 5990110.9428 | 2101113.3387 | 37.7486874503378 | -122.477001701975 | (37.7486874503378, -122.477001701975) | 1 | 8 | 3 | 29491 | 35 | |||
89879 | 96741 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1090 Quintara St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | 4x6 | 5990138.4947 | 2101114.1148 | 37.7486911796305 | -122.476906485462 | (37.7486911796305, -122.476906485462) | 1 | 8 | 3 | 29491 | 35 | |||
78423 | 96740 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1090 Quintara St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | 4x5 | 5990158.2855 | 2101115.2789 | 37.7486955239894 | -122.476838134817 | (37.7486955239894, -122.476838134817) | 1 | 8 | 3 | 29491 | 35 | |||
189353 | 96739 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1090 Quintara St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | 3x3 | 5990181.5688 | 2101117.2192 | 37.748702202136 | -122.476757763959 | (37.748702202136, -122.476757763959) | 1 | 8 | 3 | 29491 | 35 | |||
126143 | 96738 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1090 Quintara St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 3x3 | 5990210.2849 | 2101115.2789 | 37.7486985402357 | -122.476658323235 | (37.7486985402357, -122.476658323235) | 1 | 8 | 3 | 29491 | 35 | |||
126911 | 96737 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1090 Quintara St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | 4x6.5 | 5990228.1354 | 2101117.6073 | 37.7487059687745 | -122.476596767087 | (37.7487059687745, -122.476596767087) | 1 | 8 | 3 | 29491 | 35 | |||
99657 | 96610 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1800 24th Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | 3x3 | 5988783.9769 | 2103019.9427 | 37.7538454069259 | -122.481729915573 | (37.7538454069259, -122.481729915573) | 1 | 8 | 3 | 56 | 35 | |||
44814 | 96609 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1800 24th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | 3x3 | 5988784.5002 | 2102992.7293 | 37.7537707166394 | -122.481726112781 | (37.7537707166394, -122.481726112781) | 1 | 8 | 3 | 56 | 35 | |||
126402 | 96608 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1800 24th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | 3x3 | 5988783.9769 | 2102967.6092 | 37.7537017131326 | -122.481726082645 | (37.7537017131326, -122.481726082645) | 1 | 8 | 3 | 56 | 35 | |||
147468 | 96545 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 100@ Front St Pine St | 2 | Sidewalk: Curb side : Pot | Tree | Private 2 | 05/27/2011 12:00:00 AM | 2 | Permit Number 767720 | 6012972.08955 | 2116568.16592 | 37.7924226531442 | -122.399032145021 | (37.7924226531442, -122.399032145021) | 4 | 1 | 10 | 28860 | 6 | ||
6016 | 96544 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 100@ Front St Pine St | 1 | Sidewalk: Curb side : Pot | Tree | Private 2 | 08/29/2019 12:00:00 AM | 3 | Permit Number 784583 | 6013029.74558 | 2116576.80835 | 37.7924495959214 | -122.398833259061 | (37.7924495959214, -122.398833259061) | 4 | 1 | 10 | 28860 | 6 | ||
43851 | 965 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1570 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 20 | 3x3 | 6001836.49719 | 2093055.50829 | 37.7272357783944 | -122.43587842957 | (37.7272357783944, -122.43587842957) | 9 | 7 | 6 | 28861 | 25 | |||
61013 | 96475 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1306 Noriega St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | 3x3x | 5989913.8 | 2103183.8 | 37.7543609517796 | -122.477834745891 | (37.7543609517796, -122.477834745891) | 1 | 8 | 3 | 56 | 35 | |||
73777 | 96474 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1300 Noriega St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/11/2011 12:00:00 AM | 9 | 3x3 | Permit Number 767969 | 5989923.5422 | 2103151.3142 | 37.7542723197964 | -122.477798680667 | (37.7542723197964, -122.477798680667) | 1 | 8 | 3 | 56 | 35 | |
25192 | 964 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1558 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 25 | 3X3 | 6001863.50379 | 2093108.09879 | 37.7273817140762 | -122.435788829205 | (37.7273817140762, -122.435788829205) | 9 | 7 | 6 | 28861 | 25 | |||
17417 | 96352 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 533 Parnassus Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/10/2011 12:00:00 AM | 3x3 | Permit Number 767163 | 5995513.1 | 2106277.2 | 37.7631780147852 | -122.458694995111 | (37.7631780147852, -122.458694995111) | 15 | 5 | 4 | 63 | 12 | ||
189020 | 96351 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 533 Parnassus Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/10/2011 12:00:00 AM | 3x4 | Permit Number 767163 | 5995513.1 | 2106277.2 | 37.7631780147852 | -122.458694995111 | (37.7631780147852, -122.458694995111) | 15 | 5 | 4 | 63 | 12 | ||
168894 | 96341 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1494@ 27th St Guerrero St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6005839 | 2100241 | 37.7471920883951 | -122.422552158036 | (37.7471920883951, -122.422552158036) | 2 | 7 | 5 | 28859 | 22 | ||||
178267 | 96340 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1494@ 27th St Guerrero St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6005839 | 2100241 | 37.7471920883951 | -122.422552158036 | (37.7471920883951, -122.422552158036) | 2 | 7 | 5 | 28859 | 22 | ||||
111255 | 96338 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1494@ 27th St Guerrero St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6005839 | 2100241 | 37.7471920883951 | -122.422552158036 | (37.7471920883951, -122.422552158036) | 2 | 7 | 5 | 28859 | 22 | ||||
22788 | 96245 | Undocumented 4 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 100X 27th St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | 3x3 | 6005866.5 | 2100251.5 | 37.7472224703829 | -122.422457811013 | (37.7472224703829, -122.422457811013) | 2 | 7 | 5 | 28859 | 22 | |||
123550 | 96244 | Undocumented 4 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 100X 27th St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | 3x3 | 6005866.5 | 2100251.5 | 37.7472224703829 | -122.422457811013 | (37.7472224703829, -122.422457811013) | 2 | 7 | 5 | 28859 | 22 | |||
173039 | 96242 | Undocumented 4 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 100X 27th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | 3x3 | 6005866.5 | 2100251.5 | 37.7472224703829 | -122.422457811013 | (37.7472224703829, -122.422457811013) | 2 | 7 | 5 | 28859 | 22 | |||
115631 | 962 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1546 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 20 | 3X3 | 6001900.02269 | 2093175.02274 | 37.7275675463899 | -122.435667369479 | (37.7275675463899, -122.435667369479) | 9 | 7 | 6 | 28861 | 25 | |||
129545 | 96148 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 201X Clipper St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/31/2011 12:00:00 AM | 8 | 3x3 | Permit Number 57048 On Clipper | 6003552 | 2107086 | 37.7658575458736 | -122.430948865036 | (37.7658575458736, -122.430948865036) | 8 | 4 | 5 | 28862 | 3 | |
182403 | 96147 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 201X Clipper St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/31/2011 12:00:00 AM | 8 | 3x3 | Permit Number 57048 On Clipper | 6003552 | 2107086 | 37.7658575458736 | -122.430948865036 | (37.7658575458736, -122.430948865036) | 8 | 4 | 5 | 28862 | 3 | |
167185 | 961 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1545 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 15 | 3X3 | 6002019.17828 | 2093203.17786 | 37.727651621314 | -122.435257461163 | (37.727651621314, -122.435257461163) | 9 | 7 | 6 | 28861 | 25 | |||
55737 | 960 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1542 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 20 | 3X3 | 6001911.33287 | 2093192.76 | 37.7276168912919 | -122.435629538568 | (37.7276168912919, -122.435629538568) | 9 | 7 | 6 | 28861 | 25 | |||
76281 | 95957 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 328 17th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | 5x5 | 5990604.58839 | 2113180.06651 | 37.7818480613884 | -122.476175934175 | (37.7818480613884, -122.476175934175) | 11 | 6 | 2 | 54 | 26 | |||
20040 | 95956 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1245 Noriega St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | 3x3 | 5990078.1094 | 2103097.6559 | 37.7541339575951 | -122.477260233088 | (37.7541339575951, -122.477260233088) | 1 | 8 | 3 | 56 | 35 | |||
113306 | 95904 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1307 28th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/27/2011 12:00:00 AM | 3x3 | Permit Number 767606 | 5987360.8 | 2106376.5 | 37.7629787350259 | -122.486898004026 | (37.7629787350259, -122.486898004026) | 1 | 8 | 3 | 56 | 35 | |
100317 | 959 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1536 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 20 | 3X3 | 6001939.26614 | 2093234.51245 | 37.7277331205838 | -122.435535958732 | (37.7277331205838, -122.435535958732) | 9 | 7 | 6 | 28861 | 25 | |||
63676 | 95857 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 116 08th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3x3 | 5993370.28624 | 2114708.59934 | 37.786204985473 | -122.466719130242 | (37.786204985473, -122.466719130242) | 11 | 6 | 2 | 54 | 11 | |||
30951 | 957 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1528 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 22 | 3X3 | 6001955.00111 | 2093277.90628 | 37.7278531638615 | -122.435484665703 | (37.7278531638615, -122.435484665703) | 9 | 7 | 6 | 28861 | 25 | |||
176479 | 956 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1525 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 35 | 3X3 | 6002060.36471 | 2093260.71871 | 37.727811954252 | -122.435119193111 | (37.727811954252, -122.435119193111) | 9 | 7 | 6 | 28861 | 25 | |||
106937 | 95512 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 600X 32nd Ave | 8 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | 10 | 3x3 | 5985990.17986 | 2112026.52369 | 37.7784121011104 | -122.492054459017 | (37.7784121011104, -122.492054459017) | 11 | 6 | 2 | 55 | 26 | |||
113363 | 95502 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 500X 32nd Ave | 3 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | 3 | 3x3 | 5985980.32699 | 2112340.5385 | 37.7792737200362 | -122.492111670045 | (37.7792737200362, -122.492111670045) | 11 | 6 | 2 | 55 | 26 | |||
185924 | 95496 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 600X 32nd Ave | 2 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | 5 | 3x3 | 5986002.12653 | 2111683.71465 | 37.7774715436696 | -122.491987885766 | (37.7774715436696, -122.491987885766) | 11 | 6 | 2 | 55 | 26 | |||
8399 | 95483 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 601X 30th Ave | 17 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 5 | 3x3 | 5986569.82886 | 2111856.71768 | 37.7779797279503 | -122.490036770148 | (37.7779797279503, -122.490036770148) | 11 | 6 | 2 | 55 | 26 | ||
51466 | 95482 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 601X 30th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 3 | 3x3 | 5986568.36529 | 2111879.34223 | 37.7780417630679 | -122.490043497613 | (37.7780417630679, -122.490043497613) | 11 | 6 | 2 | 55 | 26 | ||
23321 | 95480 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 601X 30th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 8 | 3x3 | 5986567.36684 | 2111939.07455 | 37.7782057127303 | -122.490051346189 | (37.7782057127303, -122.490051346189) | 11 | 6 | 2 | 55 | 26 | ||
149644 | 95479 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 601X 30th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 10 | 3x3 | 5986565.4115 | 2111984.30283 | 37.7783297825409 | -122.490061437893 | (37.7783297825409, -122.490061437893) | 11 | 6 | 2 | 55 | 26 | ||
58702 | 95478 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 601X 30th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 6 | 3x3 | 5986565.85749 | 2112005.2728 | 37.7783873861575 | -122.490061437886 | (37.7783873861575, -122.490061437886) | 11 | 6 | 2 | 55 | 26 | ||
28985 | 95477 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 601X 30th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 8 | 3x3 | 5986565.00775 | 2112026.27031 | 37.7784449897253 | -122.490065922262 | (37.7784449897253, -122.490065922262) | 11 | 6 | 2 | 55 | 26 | ||
154949 | 95476 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 601X 30th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 6 | 3x3 | 5986563.84754 | 2112047.92011 | 37.778504366165 | -122.490071528655 | (37.778504366165, -122.490071528655) | 11 | 6 | 2 | 55 | 26 | ||
44906 | 95475 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 601X 30th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 3 | 3x3 | 5986561.73612 | 2112070.55828 | 37.7785664008394 | -122.490080498329 | (37.7785664008394, -122.490080498329) | 11 | 6 | 2 | 55 | 26 | ||
164971 | 95474 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 601X 30th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 3 | 3x3 | 5986559.68186 | 2112141.60911 | 37.7787613662348 | -122.490092832202 | (37.7787613662348, -122.490092832202) | 11 | 6 | 2 | 55 | 26 | ||
41997 | 95473 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 601X 30th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 6 | 3x3 | 5986560.12785 | 2112162.57896 | 37.7788189695175 | -122.490092832211 | (37.7788189695175, -122.490092832211) | 11 | 6 | 2 | 55 | 26 | ||
191220 | 95472 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 601X 30th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 6 | 3x3 | 5986558.09049 | 2112203.93573 | 37.7789324044573 | -122.490102922958 | (37.7789324044573, -122.490102922958) | 11 | 6 | 2 | 55 | 26 | ||
70160 | 95470 | Undocumented 4 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 539X 30th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 4 | 3x3 | 5986557.7 | 2112257.8 | 37.7790802775989 | -122.490108236864 | (37.7790802775989, -122.490108236864) | 11 | 6 | 2 | 55 | 26 | ||
134117 | 95467 | Undocumented 4 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 533X 30th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 4 | 3x3 | 5986556.1 | 2112298 | 37.7791905619119 | -122.490116729573 | (37.7791905619119, -122.490116729573) | 11 | 6 | 2 | 55 | 26 | ||
46093 | 95466 | Undocumented 4 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 529X 30th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 5 | 3x3 | 5986555.1 | 2112324.8 | 37.7792640886788 | -122.490122160768 | (37.7792640886788, -122.490122160768) | 11 | 6 | 2 | 55 | 26 | ||
125188 | 95464 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 601X 30th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 03/12/2011 12:00:00 AM | 3 | 3x3 | 5986592.75422 | 2111242.97331 | 37.7762958987751 | -122.489912313045 | (37.7762958987751, -122.489912313045) | 11 | 6 | 2 | 55 | 26 | |
93459 | 95462 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 601X 30th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 3 | 3x3 | 5986590.67553 | 2111282.39545 | 37.7764040194223 | -122.489922403821 | (37.7764040194223, -122.489922403821) | 11 | 6 | 2 | 55 | 26 | ||
23432 | 95461 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 601X 30th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 10 | 3x3 | 5986588.1418 | 2111391.86812 | 37.7767044523908 | -122.489939222082 | (37.7767044523908, -122.489939222082) | 11 | 6 | 2 | 55 | 26 | ||
187692 | 95457 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 601X 30th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 6 | 3x3 | 5986582.95432 | 2111498.49198 | 37.776996908357 | -122.489965010916 | (37.776996908357, -122.489965010916) | 11 | 6 | 2 | 55 | 26 | ||
163049 | 95455 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 601X 30th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 8 | 3x3 | 5986575.69735 | 2111690.69221 | 37.7775242118699 | -122.490004254704 | (37.7775242118699, -122.490004254704) | 11 | 6 | 2 | 55 | 26 | ||
71210 | 95454 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 601X 30th Ave | 6 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 6 | 3x3 | 5986556.01855 | 2112243.67907 | 37.7790414073553 | -122.490113014651 | (37.7790414073553, -122.490113014651) | 11 | 6 | 2 | 55 | 26 | ||
189654 | 95453 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 601X 30th Ave | 5 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 6 | 3x3 | 5986555.22372 | 2112267.25724 | 37.7791060998783 | -122.490117499027 | (37.7791060998783, -122.490117499027) | 11 | 6 | 2 | 55 | 26 | ||
46265 | 95452 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 601X 30th Ave | 4 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 6 | 3x3 | 5986573.32223 | 2111731.41091 | 37.7776358751612 | -122.490015466607 | (37.7776358751612, -122.490015466607) | 11 | 6 | 2 | 55 | 26 | ||
113014 | 95451 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 601X 30th Ave | 3 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 6 | 3x3 | 5986574.08529 | 2111752.05161 | 37.7776925932181 | -122.490014345501 | (37.7776925932181, -122.490014345501) | 11 | 6 | 2 | 55 | 26 | ||
33781 | 95450 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 601X 30th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 3 | 3x3 | 5986571.54012 | 2111769.53516 | 37.7777404494553 | -122.49002443627 | (37.7777404494553, -122.49002443627) | 11 | 6 | 2 | 55 | 26 | ||
154427 | 95448 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 601X 30th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 6 | 3x3 | 5986572.26887 | 2111788.56268 | 37.7777927361738 | -122.490023315176 | (37.7777927361738, -122.490023315176) | 11 | 6 | 2 | 55 | 26 | ||
167143 | 954 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1514 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 20 | 3x4 | 6002009.67833 | 2093329.08448 | 37.7279967928139 | -122.435299304842 | (37.7279967928139, -122.435299304842) | 9 | 7 | 6 | 28861 | 25 | |||
169556 | 953 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1515 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 45 | 3x3 | 6002086.14446 | 2093294.44452 | 37.7279060215227 | -122.43503248317 | (37.7279060215227, -122.43503248317) | 9 | 7 | 6 | 28861 | 25 | |||
180905 | 95287 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 4245@Lower Great Highway Lawton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/02/2011 12:00:00 AM | 3x5 | 5981056 | 2104104.5 | 37.7563708691811 | -122.508535077894 | (37.7563708691811, -122.508535077894) | 1 | 8 | 3 | 56 | 35 |
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) );