trees
531 rows where Fire Prevention Districts = 15 and qSpecies_id = 54 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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
30570 | 9642 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1482 Golden Gate Ave | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 15 | 3x3 | 6002517.4506 | 2111986.4237 | 37.7792542228164 | -122.434877632371 | (37.7792542228164, -122.434877632371) | 15 | 5 | 11 | 29490 | 41 | |||
152340 | 9641 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1482 Golden Gate Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3x3 | 6002541.4785 | 2111991.5 | 37.7792695252567 | -122.434794873127 | (37.7792695252567, -122.434794873127) | 15 | 5 | 11 | 29490 | 41 | |||
67956 | 9638 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1470 Golden Gate Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | 3x3 | 6002570.9212 | 2111995.2227 | 37.7792814183991 | -122.434693285009 | (37.7792814183991, -122.434693285009) | 15 | 5 | 11 | 29490 | 41 | |||
99649 | 9637 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1460 Golden Gate Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | 3X3 | 6002620.3308 | 2112001.9911 | 37.7793028076481 | -122.434522840958 | (37.7793028076481, -122.434522840958) | 15 | 5 | 11 | 29490 | 41 | |||
65301 | 9636 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1460 Golden Gate Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | 3X3 | 6002640.9745 | 2112004.0216 | 37.7793095547354 | -122.434451571103 | (37.7793095547354, -122.434451571103) | 15 | 5 | 11 | 29490 | 41 | |||
144613 | 9631 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1439 Golden Gate Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6002709.6742 | 2111961.3805 | 37.7791963723972 | -122.434210861246 | (37.7791963723972, -122.434210861246) | 15 | 5 | 11 | 29490 | 41 | |||
102572 | 94860 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 2161 Grove St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | 6x4 | 5997487.0021 | 2110201.3474 | 37.7740659715368 | -122.452151115771 | (37.7740659715368, -122.452151115771) | 15 | 5 | 11 | 29492 | 16 | |||
115233 | 94582 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 710 Steiner St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | 4.5x5 | 6003079.6036 | 2110819.4999 | 37.7760820416979 | -122.432849526968 | (37.7760820416979, -122.432849526968) | 15 | 9 | 11 | 29492 | 10 | |||
72884 | 8204 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1369 Fulton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3X3 | 6001211.3032 | 2111062.2036 | 37.7766423030153 | -122.439329862063 | (37.7766423030153, -122.439329862063) | 15 | 5 | 11 | 29492 | 10 | |||
109241 | 8195 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1301 Fulton St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 3X3 | 6001448.9604 | 2111096.3198 | 37.7767494990677 | -122.438510182933 | (37.7767494990677, -122.438510182933) | 15 | 5 | 11 | 29492 | 10 | |||
192522 | 8181 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1212 Fulton St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 100 | 3X3 | 6001826.5111 | 2111197.1465 | 37.7770478129311 | -122.43721134601 | (37.7770478129311, -122.43721134601) | 15 | 5 | 11 | 29492 | 41 | |||
128548 | 7224 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1234X McAllister St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 15 | 6003339.1357 | 2111756.6534 | 37.778669949054 | -122.432018673024 | (37.778669949054, -122.432018673024) | 15 | 9 | 11 | 29490 | 41 | ||||
67309 | 7214 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 950 Fillmore St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | 4X4 | 6003450.6988 | 2111662.2209 | 37.7784169850751 | -122.431625989594 | (37.7784169850751, -122.431625989594) | 15 | 9 | 11 | 29492 | 41 | |||
190808 | 7213 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 950 Fillmore St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 4X4 | 6003452.6284 | 2111644.2112 | 37.7783676442869 | -122.43161802827 | (37.7783676442869, -122.43161802827) | 15 | 9 | 11 | 29492 | 41 | |||
112668 | 7207 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 940 Fillmore St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 4X4 | 6003456.4877 | 2111615.9101 | 37.7782901552472 | -122.431602656487 | (37.7782901552472, -122.431602656487) | 15 | 9 | 11 | 29492 | 41 | |||
92332 | 7206 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 940 Fillmore St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 4X4 | 6003460.3469 | 2111580.5338 | 37.7781932394573 | -122.431586779834 | (37.7781932394573, -122.431586779834) | 15 | 9 | 11 | 29492 | 41 | |||
143473 | 7201 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 949 Fillmore St | 8 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6003424.6737 | 2111504.3754 | 37.7779821053868 | -122.431704747493 | (37.7779821053868, -122.431704747493) | 15 | 9 | 11 | 29492 | 41 | |||
32007 | 7200 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 949 Fillmore St | 7 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6003420.9887 | 2111521.8792 | 37.7780299575939 | -122.431718745255 | (37.7780299575939, -122.431718745255) | 15 | 9 | 11 | 29492 | 41 | |||
86733 | 7180 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 837 Fillmore St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6003455.9744 | 2111255.1372 | 37.7772995333232 | -122.431578669082 | (37.7772995333232, -122.431578669082) | 15 | 9 | 11 | 29492 | 10 | |||
67143 | 7179 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 833 Fillmore St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6003463.175 | 2111217.4725 | 37.7771965235218 | -122.431551070298 | (37.7771965235218, -122.431551070298) | 15 | 9 | 11 | 29492 | 10 | |||
7894 | 7178 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 837 Fillmore St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 01/24/2020 11:28:00 AM | 12 | 6x6 | 6003458.7438 | 2111235.1971 | 37.7772449397217 | -122.431567664925 | (37.7772449397217, -122.431567664925) | 15 | 9 | 11 | 29492 | 10 | ||
54142 | 7177 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 827 Fillmore St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | 3X3 | 6003463.7289 | 2111198.6401 | 37.7771448458144 | -122.431547809387 | (37.7771448458144, -122.431547809387) | 15 | 9 | 11 | 29492 | 10 | |||
144711 | 7176 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 821 Fillmore St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 3X3 | 6003466.4983 | 2111179.8077 | 37.7770932936782 | -122.431536884374 | (37.7770932936782, -122.431536884374) | 15 | 9 | 11 | 29492 | 10 | |||
149806 | 7172 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 801 Fillmore St | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3x3 | Permit Number 780067 | 6003478.684 | 2111101.7087 | 37.7768795438362 | -122.431489153471 | (37.7768795438362, -122.431489153471) | 15 | 9 | 11 | 29492 | 10 | ||
126179 | 7171 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 801 Fillmore St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3x3 | Permit Number 780067 | 6003475.9145 | 2111120.5411 | 37.7769310959731 | -122.431500078765 | (37.7769310959731, -122.431500078765) | 15 | 9 | 11 | 29492 | 10 | ||
181278 | 7170 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 801 Fillmore St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3x3 | Permit Number 780067 | 6003473.1451 | 2111141.589 | 37.7769887313283 | -122.43151116193 | (37.7769887313283, -122.43151116193) | 15 | 9 | 11 | 29492 | 10 | ||
189104 | 7169 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 801 Fillmore St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3x3 | Permit Number 780067 | 6003470.3756 | 2111160.9753 | 37.7770418043343 | -122.431522126808 | (37.7770418043343, -122.431522126808) | 15 | 9 | 11 | 29492 | 10 | ||
165915 | 7168 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 761 Fillmore St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3X3 | 6003490.0388 | 2111001.7309 | 37.7766056731066 | -122.431442734929 | (37.7766056731066, -122.431442734929) | 15 | 9 | 11 | 29492 | 10 | |||
167294 | 7167 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 761 Fillmore St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3X3 | 6003488.931 | 2111020.5633 | 37.776657319429 | -122.431447911846 | (37.776657319429, -122.431447911846) | 15 | 9 | 11 | 29492 | 10 | |||
8783 | 7166 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 745 Fillmore St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | 3X3 | 6003498.9011 | 2110946.3415 | 37.7764540897977 | -122.431408122706 | (37.7764540897977, -122.431408122706) | 15 | 9 | 11 | 29492 | 10 | |||
170228 | 7164 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 733 Fillmore St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3X3 | 6003503.3323 | 2110918.6468 | 37.7763782981407 | -122.431390816474 | (37.7763782981407, -122.431390816474) | 15 | 9 | 11 | 29492 | 10 | |||
12978 | 7162 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 727 Fillmore St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3X3 | 6003506.9326 | 2110884.8593 | 37.7762857300682 | -122.431375949555 | (37.7762857300682, -122.431375949555) | 15 | 9 | 11 | 29492 | 10 | |||
144651 | 7159 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 719 Fillmore St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6003516.9027 | 2110817.5612 | 37.7761015111675 | -122.431336655161 | (37.7761015111675, -122.431336655161) | 15 | 9 | 11 | 29492 | 10 | |||
60844 | 7158 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 719 Fillmore St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6003514.1332 | 2110837.5014 | 37.7761561050706 | -122.431347659332 | (37.7761561050706, -122.431347659332) | 15 | 9 | 11 | 29492 | 10 | |||
100171 | 7154 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 709 Fillmore St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3X3 | 6003520.226 | 2110798.7288 | 37.776049990393 | -122.431323814363 | (37.776049990393, -122.431323814363) | 15 | 9 | 11 | 29492 | 10 | |||
17314 | 71305 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 445 Broderick St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12 | 6001154.5387 | 2110263.7555 | 37.7744467352044 | -122.439468977163 | (37.7744467352044, -122.439468977163) | 15 | 5 | 11 | 29492 | 10 | |||
10837 | 70252 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 500 Broderick St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10 | 6001164.2534 | 2110490.0118 | 37.7750685309709 | -122.439451594404 | (37.7750685309709, -122.439451594404) | 15 | 5 | 11 | 29492 | 10 | |||
167293 | 7023 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1115 Fell St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6002035.3214 | 2110135.6586 | 37.7741451002744 | -122.436413017138 | (37.7741451002744, -122.436413017138) | 15 | 5 | 11 | 29492 | 10 | |||
190613 | 7021 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1105 Fell St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | 3X3 | 6002080.4157 | 2110140.9294 | 37.7741621348105 | -122.436257405533 | (37.7741621348105, -122.436257405533) | 15 | 5 | 11 | 29492 | 10 | |||
66541 | 6994 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 870 Fell St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6003272.598 | 2110360.763 | 37.7748334078832 | -122.432149140862 | (37.7748334078832, -122.432149140862) | 15 | 9 | 11 | 29492 | 10 | |||
154408 | 67469 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 500 Broderick St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/08/1992 12:00:00 AM | 13 | Permit Number 30990 | 6001172.0898 | 2110442.123 | 37.774937486349 | -122.439421053126 | (37.774937486349, -122.439421053126) | 15 | 5 | 11 | 29492 | 10 | |
100603 | 66825 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 2047 Hayes St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/06/1991 12:00:00 AM | 9 | Permit Number 30121 | 5998040.6169 | 2109928.3267 | 37.7733480244518 | -122.450216391954 | (37.7733480244518, -122.450216391954) | 15 | 5 | 11 | 29492 | 16 | |
89857 | 66720 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 819 Lyon St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/13/1991 12:00:00 AM | 14 | Permit Number 29962 | 5999956.9512 | 2111893.0193 | 37.778852049002 | -122.443728719684 | (37.778852049002, -122.443728719684) | 15 | 5 | 11 | 29490 | 16 | ||
24743 | 66562 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 144 Collins St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/10/1991 12:00:00 AM | 5 | Permit Number 29750 | 5998095.4621 | 2113585.8052 | 37.7833936486138 | -122.450290371551 | (37.7833936486138, -122.450290371551) | 15 | 6 | 1 | 54 | 31 | |
11526 | 66368 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 5 Cook St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/04/1991 12:00:00 AM | 10 | Permit Number 29490 | 5997440.3621 | 2113655.9431 | 37.7835487164216 | -122.452561811691 | (37.7835487164216, -122.452561811691) | 15 | 6 | 1 | 54 | 31 | |
117346 | 65955 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1234 Grove St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/21/1990 12:00:00 AM | 13 | Permit Number 28976 | 6001892.8907 | 2110857.546 | 37.7761191282962 | -122.436957400422 | (37.7761191282962, -122.436957400422) | 15 | 5 | 11 | 29492 | 10 | ||
80284 | 64505 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 412 Broderick St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/20/1988 12:00:00 AM | 9 | Permit Number 25386 | 6001213.6317 | 2110153.0182 | 37.7741460412807 | -122.439256624823 | (37.7741460412807, -122.439256624823) | 15 | 5 | 11 | 29492 | 10 | |
4913 | 64501 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 545 Broderick St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/20/1988 12:00:00 AM | 13 | Permit Number 25381 | 6001107.084 | 2110608.9242 | 37.7753917807448 | -122.439657882213 | (37.7753917807448, -122.439657882213) | 15 | 5 | 11 | 29492 | 10 | |
82175 | 64038 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 16 Loyola Ter | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/12/1988 12:00:00 AM | 10 | Permit Number 25745 | 5998453.4174 | 2110814.7286 | 37.7758054707119 | -122.44885232426 | (37.7758054707119, -122.44885232426) | 15 | 6 | 2 | 29492 | 16 | ||
140116 | 64012 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 10 Loyola Ter | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/08/1987 12:00:00 AM | 10 | Permit Number 24766 | 5998456.7381 | 2110792.4322 | 37.7757444404433 | -122.44883923079 | (37.7757444404433, -122.44883923079) | 15 | 6 | 2 | 29492 | 16 | ||
141102 | 63488 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 811 Lyon St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/07/1987 12:00:00 AM | 12 | Permit Number 24085 | 5999970.1497 | 2111784.3859 | 37.7785545222825 | -122.443675254762 | (37.7785545222825, -122.443675254762) | 15 | 5 | 11 | 29490 | 16 | |
119444 | 62957 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 159 Clayton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/18/1986 12:00:00 AM | 12 | Permit Number 23343 | 5998260.9157 | 2110109.071 | 37.7738569063547 | -122.449467376934 | (37.7738569063547, -122.449467376934) | 15 | 5 | 11 | 29492 | 16 | ||
63983 | 62369 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 137 Clayton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/10/1985 12:00:00 AM | 9 | 3x3 | Permit Number 22515 | 5998258.1694 | 2110129.1192 | 37.7739117964536 | -122.449478321628 | (37.7739117964536, -122.449478321628) | 15 | 5 | 11 | 29492 | 16 | |
165670 | 61337 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 650 Presidio Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/22/1984 12:00:00 AM | 10 | 5x6 | Permit Number 21242 | 5999250.392 | 2114334.8634 | 37.7855163948709 | -122.446348686743 | (37.7855163948709, -122.446348686743) | 15 | 6 | 1 | 29490 | 31 | |
110225 | 61148 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 2237 Fulton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/28/1983 12:00:00 AM | 7 | Permit Number 21005 | 5997050.2982 | 2110479.7459 | 37.7748053558267 | -122.453681848705 | (37.7748053558267, -122.453681848705) | 15 | 5 | 2 | 29492 | 16 | ||
71607 | 61078 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 2590 Post St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/01/1983 12:00:00 AM | 13 | Permit Number 20915 | 5999806.8161 | 2113697.9026 | 37.7837992291467 | -122.444377837774 | (37.7837992291467, -122.444377837774) | 15 | 6 | 11 | 29490 | 31 | ||
194022 | 59752 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 2375 Post St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/10/1981 12:00:00 AM | 11 | Permit Number 19189 | 6000826.215 | 2113783.3508 | 37.7840919573447 | -122.440857239763 | (37.7840919573447, -122.440857239763) | 15 | 6 | 11 | 29490 | 13 | ||
144900 | 59664 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 947 Steiner St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/30/1981 12:00:00 AM | 15 | 5x5 | Permit Number 19086 | 6002929.3099 | 2111572.5338 | 37.7781411599151 | -122.433423256969 | (37.7781411599151, -122.433423256969) | 15 | 9 | 11 | 29492 | 41 | |
137205 | 59663 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 943 Steiner St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/30/1981 12:00:00 AM | 16 | Permit Number 19085 | 6002930.6636 | 2111548.8443 | 37.778076191259 | -122.433416880741 | (37.778076191259, -122.433416880741) | 15 | 9 | 11 | 29492 | 41 | ||
170938 | 59662 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 911 Steiner St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/30/1981 12:00:00 AM | 17 | Permit Number 19084 | 6002943.8621 | 2111474.7299 | 37.7778734403922 | -122.433365924976 | (37.7778734403922, -122.433365924976) | 15 | 9 | 11 | 29492 | 41 | ||
178749 | 59661 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 950 Steiner St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/30/1981 12:00:00 AM | 16 | Permit Number 19083 | 6002974.356 | 2111562.0693 | 37.7781149825494 | -122.433266678398 | (37.7781149825494, -122.433266678398) | 15 | 9 | 11 | 29492 | 41 | ||
173853 | 59660 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 910 Steiner St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/30/1981 12:00:00 AM | 15 | Permit Number 19082 | 6002982.2355 | 2111513.667 | 37.7779825288987 | -122.43323596098 | (37.7779825288987, -122.43323596098) | 15 | 9 | 11 | 29492 | 41 | ||
27540 | 59659 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 906 Steiner St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/30/1981 12:00:00 AM | 16 | Permit Number 19081 | 6002986.1752 | 2111478.2094 | 37.7778853946604 | -122.433219797973 | (37.7778853946604, -122.433219797973) | 15 | 9 | 11 | 29492 | 41 | ||
18641 | 59622 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 448 Broderick St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/20/1988 12:00:00 AM | 8 | Permit Number 25385 | 6001193.7685 | 2110273.1905 | 37.7744748738878 | -122.439333950555 | (37.7744748738878, -122.439333950555) | 15 | 5 | 11 | 29492 | 10 | |
67896 | 59593 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1528 Baker St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/25/1981 12:00:00 AM | 15 | Permit Number 18990 | 6000159.8025 | 2114219.1556 | 37.7852505885272 | -122.443194090382 | (37.7852505885272, -122.443194090382) | 15 | 6 | 1 | 29490 | 27 | ||
36701 | 59351 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 503 Lyon St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/17/2009 12:00:00 AM | 4 | 3x3 | Permit Number 52085 | 6000121.1922 | 2110676.4601 | 37.7755210539143 | -122.443073153769 | (37.7755210539143, -122.443073153769) | 15 | 5 | 11 | 29492 | 16 | |
129892 | 58879 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 2900 Bush St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/18/1988 12:00:00 AM | 13 | Permit Number 25516 | 5999589.5873 | 2114362.4153 | 37.7856114118811 | -122.445177156478 | (37.7856114118811, -122.445177156478) | 15 | 6 | 1 | 29490 | 31 | ||
84048 | 57327 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 2904 Bush St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/28/1976 12:00:00 AM | 17 | Permit Number 16155 | 5999526.9274 | 2114356.6691 | 37.7855920575643 | -122.445393527485 | (37.7855920575643, -122.445393527485) | 15 | 6 | 1 | 29490 | 31 | ||
65242 | 56926 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 419 Broderick St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/15/1974 12:00:00 AM | 13 | Permit Number 14169 | 6001161.4908 | 2110173.8745 | 37.7742003402164 | -122.439438484322 | (37.7742003402164, -122.439438484322) | 15 | 5 | 11 | 29492 | 10 | ||
157958 | 55484 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 701 Scott St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/30/1972 12:00:00 AM | 18 | Permit Number 11437 | 6002049.3973 | 2110903.3005 | 37.7762536529278 | -122.436419278446 | (37.7762536529278, -122.436419278446) | 15 | 5 | 11 | 29492 | 10 | ||
190495 | 55481 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 530 Scott St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/30/1972 12:00:00 AM | 13 | Permit Number 11434 | 6002173.9724 | 2110343.1732 | 37.7747227610629 | -122.435948251092 | (37.7747227610629, -122.435948251092) | 15 | 5 | 11 | 29492 | 10 | ||
103769 | 55477 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 555 Pierce St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/30/1972 12:00:00 AM | 17 | Permit Number 11429 | 6002598.3437 | 2110470.6592 | 37.7750969045142 | -122.434489383438 | (37.7750969045142, -122.434489383438) | 15 | 5 | 11 | 29492 | 10 | ||
162060 | 55476 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 500 Pierce St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/30/1972 12:00:00 AM | 17 | Permit Number 11428 | 6002664.0079 | 2110296.3247 | 37.7746219525119 | -122.434249770689 | (37.7746219525119, -122.434249770689) | 15 | 5 | 11 | 29492 | 10 | ||
54837 | 55473 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1270 Grove St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/30/1972 12:00:00 AM | 18 | Permit Number 11425 | 6001761.1754 | 2110839.3962 | 37.7760618062261 | -122.437411738171 | (37.7760618062261, -122.437411738171) | 15 | 5 | 11 | 29492 | 10 | ||
126360 | 55105 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 219 Clayton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/14/1972 12:00:00 AM | 14 | 3x3 | Permit Number 11004 | 5998291.6539 | 2109868.1545 | 37.7731971698727 | -122.44934368775 | (37.7731971698727, -122.44934368775) | 15 | 5 | 11 | 29492 | 16 | |
191893 | 54834 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 109 Ashbury St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/09/1972 12:00:00 AM | 17 | Permit Number 10688 | 5998714.6082 | 2110323.5588 | 37.7744717777818 | -122.447913432558 | (37.7744717777818, -122.447913432558) | 15 | 5 | 11 | 29492 | 16 | ||
159022 | 54831 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 79 Terra Vista Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/20/1972 12:00:00 AM | 8 | Permit Number 10685 | 6000087.3282 | 2112805.9967 | 37.7813662861419 | -122.443343289517 | (37.7813662861419, -122.443343289517) | 15 | 5 | 1 | 29490 | 16 | ||
20716 | 5146 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 217 Divisadero St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3x3 | 6001830.6224 | 2108865.7235 | 37.7706465411236 | -122.437030167851 | (37.7706465411236, -122.437030167851) | 15 | 5 | 11 | 29492 | 9 | |||
145096 | 47470 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 2902 Bush St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/14/2002 12:00:00 AM | 14 | Permit Number 45371 | 5999554.6801 | 2114357.1647 | 37.7855950025795 | -122.445297547197 | (37.7855950025795, -122.445297547197) | 15 | 6 | 1 | 29490 | 31 | ||
157137 | 45611 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1100 Fillmore St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/06/2001 12:00:00 AM | 16 | Permit Number 44335 | 6003449.1823 | 2112117.4289 | 37.7796667869975 | -122.43166374401 | (37.7796667869975, -122.43166374401) | 15 | 9 | 11 | 29490 | 41 | ||
122184 | 45603 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1100 Fillmore St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/06/2001 12:00:00 AM | 14 | Permit Number 44335 | 6003434.2619 | 2112117.4289 | 37.7796659412631 | -122.431715360111 | (37.7796659412631, -122.431715360111) | 15 | 9 | 11 | 29490 | 41 | ||
52733 | 4510 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1805X Oak St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3x3 | 5998343.9349 | 2109273.4537 | 37.7715672642721 | -122.449119990901 | (37.7715672642721, -122.449119990901) | 15 | 5 | 11 | 29492 | 9 | |||
14071 | 4509 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1807X Oak St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3x3 | 5998320.8634 | 2109271.3175 | 37.7715600792218 | -122.449199642237 | (37.7715600792218, -122.449199642237) | 15 | 5 | 11 | 29492 | 9 | |||
180949 | 38058 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 2844 Bush St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/10/1998 12:00:00 AM | 15 | Permit Number 40253 | 5999884.3012 | 2114402.2303 | 37.7857375510232 | -122.44416039717 | (37.7857375510232, -122.44416039717) | 15 | 6 | 1 | 29490 | 31 | |
112405 | 35162 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 521 Pierce St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/02/1998 12:00:00 AM | 9 | Permit Number 38693 | 6002611.6162 | 2110373.5603 | 37.7748310484791 | -122.434436527113 | (37.7748310484791, -122.434436527113) | 15 | 5 | 11 | 29492 | 10 | |
38278 | 32778 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 555 Broderick St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/29/1996 12:00:00 AM | 2 | Permit Number 37147 | 6001101.7087 | 2110645.4763 | 37.7754918376538 | -122.439679097651 | (37.7754918376538, -122.439679097651) | 15 | 5 | 11 | 29492 | 10 | |
131303 | 28786 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 800 Haight St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 20 | 3X3 | 6002265.8749 | 2109178.7673 | 37.7715308120493 | -122.435547024103 | (37.7715308120493, -122.435547024103) | 15 | 5 | 11 | 29492 | 9 | |||
74774 | 28785 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 800 Haight St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 20 | 3X3 | 6002281.4779 | 2109178.7673 | 37.7715316982304 | -122.435493052551 | (37.7715316982304, -122.435493052551) | 15 | 5 | 11 | 29492 | 9 | |||
190509 | 27413 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1125 Fell St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3X3 | 6002017.7522 | 2110131.5591 | 37.7741328457417 | -122.436473498525 | (37.7741328457417, -122.436473498525) | 15 | 5 | 11 | 29492 | 10 | |||
150634 | 254387 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 401 Broderick St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Width 0ft | 6001170.9258 | 2110090.9457 | 37.7739731755059 | -122.439399901379 | (37.7739731755059, -122.439399901379) | 15 | 5 | 11 | 29492 | 10 | ||||
15279 | 248611 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 862 Shrader St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 0ft | 5997689.6108 | 2107534.9111 | 37.7667562259025 | -122.45125791953 | (37.7667562259025, -122.45125791953) | 15 | 5 | 11 | 29492 | 9 | |||
79951 | 248610 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 872 Shrader St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 0ft | 5997691.4278 | 2107516.4386 | 37.7667056091614 | -122.4512503025 | (37.7667056091614, -122.4512503025) | 15 | 5 | 11 | 29492 | 9 | |||
99152 | 248533 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 174 Belvedere St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 0ft | 5998320.7066 | 2107735.9897 | 37.7673444513971 | -122.449089561777 | (37.7673444513971, -122.449089561777) | 15 | 5 | 11 | 29492 | 9 | |||
124344 | 248473 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 758 Clayton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 17 | Width 0ft | 5998609.6056 | 2107900.123 | 37.7678116388378 | -122.448102124294 | (37.7678116388378, -122.448102124294) | 15 | 5 | 11 | 29492 | 9 | |||
62544 | 248469 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 145 Belvedere St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 0ft | 5998248.1791 | 2107933.2828 | 37.7678820197346 | -122.449354639507 | (37.7678820197346, -122.449354639507) | 15 | 5 | 11 | 29492 | 9 | |||
581 | 248465 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 772 Stanyan St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 0ft | 5997147.6982 | 2107925.2578 | 37.7677969745346 | -122.453160476336 | (37.7677969745346, -122.453160476336) | 15 | 5 | 11 | 29492 | 9 | |||
71673 | 248411 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1737 Waller St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 0ft | 5997411.4623 | 2108107.5609 | 37.7683126457867 | -122.452261308397 | (37.7683126457867, -122.452261308397) | 15 | 5 | 11 | 29492 | 9 | |||
187807 | 248407 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 39 Delmar St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 0ft | 5999275.3753 | 2108109.8322 | 37.7684254834855 | -122.445814398115 | (37.7684254834855, -122.445814398115) | 15 | 5 | 11 | 29492 | 9 | |||
117001 | 248404 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1713 Waller St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 0ft | 5997468.9999 | 2108115.1317 | 37.7683367292403 | -122.452062838629 | (37.7683367292403, -122.452062838629) | 15 | 5 | 11 | 29492 | 9 | |||
101310 | 248383 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1621 Waller St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 0ft | 5997789.5444 | 2108160.7074 | 37.7684802243505 | -122.450957397559 | (37.7684802243505, -122.450957397559) | 15 | 5 | 11 | 29492 | 9 |
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) );